[gdal-dev] About sqlite tileindex and Mapserver

[Rahkonen Jukka]

Hi,

It is documented in http://mapserver.org/mapfile/layer.html .  
TILEINDEX [filename|layername]

    Name of the tileindex file or layer. A tileindex is similar to an ArcInfo library index. The tileindex contains polygon features for each tile. The item that contains the location of the tiled data is given using the TILEITEM parameter. When a file is used as the tileindex for shapefile or raster layers, the tileindex should be a shapefile. For CONNECTIONTYPE OGR layers, any OGR supported datasource can be a tileindex. Normally the location should contain the path to the tile file relative to the shapepath, not relative to the tileindex itself. If the DATA parameter contains a value then it is added to the end of the location. When a tileindex layer is used, it works similarly to directly referring to a file, but any supported feature source can be used (ie. postgres, oracle).

Perhaps this tileindex section could have direct links to some tileindex layer examples rather than having them only in wiki?

-Jukka Rahkonen-

Smith, Michael wrote:
 
> 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