[gdal-dev] About sqlite tileindex and Mapserver

[Smith, Michael ERDC-RDE-CRREL-NH]

Jukka,

Perhaps you can document this on the Wiki as a Spatialite example in
addition to the example for Oracle
(https://github.com/mapserver/mapserver/wiki/MapServer-TILEINDEXes-with-Dat
abase-RASTERS)

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 8/24/12 7:12 AM, "Rahkonen Jukka" <Jukka.Rahkonen at mmmtike.fi> wrote:

>Hi,
>
>There is a trick with using Spatialite tileindex with Mapserver. I have
>no idea anymore how I came to this solution but most probably I was
>reading something about it from the internet.
>
>Try odd trick is that you cannot user Spatialite directly as tileindex
>but you must first create a LAYER from Spatialite and use that as
>tileindex. Let's take an example.  In the following
>"z:\tindex\aerial_images.sqlite" is the Spatialite db and tile locations
>are in the table "aerial_images"
>
>LAYER
>        NAME "sqlite_tileindex"
>        STATUS OFF
>        TYPE POLYGON
>        CONNECTIONTYPE OGR
>        CONNECTION "z:\tindex\aerial_images.sqlite"
>        DATA "aerial_images"
>    END
>
>Now for the real aerial image layer the tileindex is read from the LAYER
>that was just created
>
>LAYER
>        NAME "aerial_imagery"
>        STATUS ON
>        TILEINDEX "sqlite_tileindex"
>
>
>-Jukka Rahkonen-
>_______________________________________________
>gdal-dev mailing list
>gdal-dev at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/gdal-dev