[gdal-dev] Can GDAL Access Raster File Stored as Blob in SQLite3 Database?

[Jema Bingham]

Ahah!  You have to add the raster table name then to the command.  The
Rasterlite documentation should be updated to reflect this example as it
now misleadingly does not.  See below...

Thank you much!
Examples:

   - Accessing a rasterlite DB with a single raster table :

   $ gdalinfo rasterlitedb.sqlite -noct

   Output:

   Driver: Rasterlite/Rasterlite
   Files: rasterlitedb.sqlite
   Size is 7200, 7200
   Coordinate System is:
   GEOGCS["WGS 84",
       DATUM["WGS_1984",
           SPHEROID["WGS 84",6378137,298.257223563,
               AUTHORITY["EPSG","7030"]],
           AUTHORITY["EPSG","6326"]],
       PRIMEM["Greenwich",0,
           AUTHORITY["EPSG","8901"]],
       UNIT["degree",0.01745329251994328,
           AUTHORITY["EPSG","9122"]],
       AUTHORITY["EPSG","4326"]]
   Origin = (-5.000000000000000,55.000000000000000)
   Pixel Size = (0.002083333333333,-0.002083333333333)
   Metadata:
     TILE_FORMAT=GIF
   Image Structure Metadata:
     INTERLEAVE=PIXEL
   Corner Coordinates:
   Upper Left  (  -5.0000000,  55.0000000) (  5d 0'0.00"W, 55d 0'0.00"N)
   Lower Left  (  -5.0000000,  40.0000000) (  5d 0'0.00"W, 40d 0'0.00"N)
   Upper Right (  10.0000000,  55.0000000) ( 10d 0'0.00"E, 55d 0'0.00"N)
   Lower Right (  10.0000000,  40.0000000) ( 10d 0'0.00"E, 40d 0'0.00"N)
   Center      (   2.5000000,  47.5000000) (  2d30'0.00"E, 47d30'0.00"N)
   Band 1 Block=480x480 Type=Byte, ColorInterp=Palette
     Color Table (RGB with 256 entries)


   - Listing a multi-raster table DB :

   $ gdalinfo multirasterdb.sqlite

   Output:

   Driver: Rasterlite/Rasterlite
   Files:
   Size is 512, 512
   Coordinate System is `'
   Subdatasets:
     SUBDATASET_1_NAME=RASTERLITE:multirasterdb.sqlite,table=raster1
     SUBDATASET_1_DESC=RASTERLITE:multirasterdb.sqlite,table=raster1
     SUBDATASET_2_NAME=RASTERLITE:multirasterdb.sqlite,table=raster2
     SUBDATASET_2_DESC=RASTERLITE:multirasterdb.sqlite,table=raster2
   Corner Coordinates:
   Upper Left  (    0.0,    0.0)
   Lower Left  (    0.0,  512.0)
   Upper Right (  512.0,    0.0)
   Lower Right (  512.0,  512.0)
   Center      (  256.0,  256.0)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20141106/ded1ce59/attachment.html>