[gdal-dev] [EXTERNAL] Re: Maximum size of Raster and vector layers in geopackage database

[Newcomb, Doug]

Thank you for all of the responses!

Doug

On Thu, Sep 6, 2018 at 3:35 AM <a.furieri at lqt.it> wrote:

> On Thu, 06 Sep 2018 09:11:35 +0200, Even Rouault wrote:
> > On mercredi 5 septembre 2018 16:48:52 CEST Newcomb, Doug wrote:
> >> Hi Folks,
> >> I was in a meeting today and the question came up:
> >> What is the maximum size of a vector data layer in a geopackage
> >> database? a
> >> raster layer?
> >
> > No limits other than the ones of the SQLite format
> >
> > Quoting http://www.geopackage.org/spec/
> > """
> > The maximum size of a GeoPackage file is about 140TB [K4a]. In
> > practice a
> > lower size limit MAY be imposed by the filesystem to which the file
> > is
> > written. Many mobile devices require external memory cards to be
> > formatted
> > using the FAT32 file system which imposes a maximum size limit of
> > 4GB.
> > """
> >
>
> Just for the sake of curiosity, during last years a testing session
> based on SpatiaLite and RasterLite (same identical SQLite architecture
> as in GeoPackage) produced an impressive 320 GB db-file, and anything
> worked as expected.
> We then stopped any further testing just because we had completely
> exhausted any available disk storage.
>
> bye Sandro
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev



-- 
Doug Newcomb - Cartographer
USFWS
551F Pylon Dr
Raleigh, NC
919-856-4520 ext. 14 doug_newcomb at fws.gov
---------------------------------------------------------------------------------------------------------

*NOTE: This email correspondence and any attachments to and from this
sender is subject to the Freedom of Information Act (FOIA) and may be
disclosed to third parties.*​
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20180906/ecaa59b9/attachment.html>