[gdal-dev] About sqlite tileindex and Mapserver

[Rahkonen Jukka]

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-