[gdal-dev] Fwd: MBTiles Write support

[Lorenzo Pini]

Hi Even,
sorry for the late answer.
The latest version did a good job.
I am now investigating a strange issue after the gdaladdo run but I think
it is caused by my MBTiles reader library.

Thank you for your work so far.

Regards
Lorenzo Pini
Software Engineer

==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:     +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

On Wed, Apr 20, 2016 at 11:03 AM, Even Rouault <even.rouault at spatialys.com>
wrote:

> Le lundi 18 avril 2016 17:55:57, Even Rouault a écrit :
> > Lorenzo,
> >
> > > The command I used is:
> > >
> > > \>gdal_translate mosaic.tif full_def9.mbtiles -of MBTILES -expand rgb
> -co
> > > TILE_FORMAT=PNG8 -co ZLEVEL=9
> > > Input file size is 645661, 308112
> > > 0...10...20...30...40...50...60...70...80ERROR 1: Failure when
> inserting
> > > partial tile (row=759306,col=1099566) at zoom_level=21 : database or
> disk
> > > is full
> > > ERROR 1: full_def9.mbtiles, band 4: An error occurred while writing a
> > > dirty block
> > > ERROR 1: Failure when inserting partial tile (row=759306,col=1099566)
> at
> > > zoom_level=21 : database disk image is malformed
> > > ERROR 1: Failure when inserting partial tile (row=759306,col=1099566)
> at
> > > zoom_level=21 : database disk image is malformed
> > > ERROR 1: Failure when inserting partial tile (row=759306,col=1099566)
> at
> > > zoom_level=21 : database disk image is malformed
> > > ERROR 1: Failure when inserting partial tile (row=759306,col=1099576)
> at
> > > zoom_level=21 : database disk image is malformed
> > >
> > > NOTE: without the "-expand rgb" option, all the output tiles will be
> > > black, gdal_translate will warn you.
> > >
> > > The process failed due to insufficient disk space (70Gb free was not
> > > enough) but the resulting incomplete file (7Gb) looks good.
> > > Most of the space was used by the "partial_tiles" database, is there
> any
> > > settings I can use to force a more frequent "flush" of the tiles in the
> > > main database?
> >
> > I've pushed a fix for that per https://trac.osgeo.org/gdal/ticket/6462
>
> With the fix, I managed to convert a VRT whose dimensions and spatial
> registration is the same as yours to a MBTiles (which is 333476 x 160000
> large) at level 20. The temporary database didn't grow above 1 GB.
>
> I'm thinking it might probably be possible to improve the conversion
> process
> to not use the temp DB at all (which would be likely result in significant
> speedup as quick profiling showed that the write activity in the temp DB is
> quite intense) by aligning the origin of the destination raster to tiles
> boundaries during the conversion, so that GDAL blocks and MBTiles tiles
> aren't
> shifted. For a later improvement...
>
> --
> Spatialys - Geospatial professional services
> http://www.spatialys.com
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20160506/15b9cac3/attachment.html>