[mapserver-users] How use a spatialite as tileindex for raster

[Rahkonen Jukka (MML)]

Hi,

I use a batch file which creates own shapefile tileindex for each orthophoto directory because I need separate shapefiles for another purpose, snippet here:
gdaltindex -t_srs epsg:3067 -write_absolute_path -src_srs_name src_srs %1.shp /%1/*.TIF

 and another batch file that combines them into Spatialite to be used with Mapserver:

ogr2ogr -f "SQLite" -dsco spatialite=yes -dsco init_with_epsg=yes -a_srs epsg:3067 ortho.sqlite dir_0.shp -nln orthos
ogr2ogr -update -append -a_srs epsg:3067 ortho.sqlite dir_1.shp -nln orthos
ogr2ogr -update -append -a_srs epsg:3067 ortho.sqlite dir_2.shp -nln orthos
...

Spatialite suits me perfectly because I can add some metadata into it and then make layers by attributes like acquisition year:
LAYER
NAME "orthos_2011"
CONNECTIONTYPE OGR
CONNECTION "/ortho.sqlite"
DATA "select * from orthos where year=2011"
...

-Jukka Rahkonen-

Schylberg Lars wrote:

> Hi 

> Looking at your old example I became curious.  Did You use gdaltindex to create the indexfile in spatialite or did You do in some other way?
The -f option in gdaltindex seems like a rather recent addition that I haven't tried. 

/Lars

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Rahkonen Jukka (MML)
Sent: den 16 mars 2015 17:25
To: Andrea Peri; mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] How use a spatialite as tileindex for raster

Hi Andrea,

I share your feelings, it is odd. Therefore I wrote this mail and now when I am lost I can search for "spatialite ogr tileindex rahkonen"

http://osgeo-org.1560.x6.nabble.com/How-to-use-Spatialite-as-a-TILEINDEX-td4228164.html

-Jukka Rahkonen-




________________________________________
Andrea Peri wrote:

> Hi,
reading the mapserver docs,
I understand that is possible to use every OGR datasource to access a raster catalog using tileindex.

> So I try to use a spatialite as tileindex.

> I try this setting but without success.

    NAME "rt_ofc2k.ofc2k"
    STATUS OFF
    EXTENT 555870.99 4677465.00 752890.00 4924883.05
    TYPE raster
    CONNECTIONTYPE OGR
    CONNECTION "/pth-to-spatialite/db.sqlite"
    TILEINDEX 'table'
    TILEITEM 'location'

The error reported from log is:

[Mon Mar 16 16:49:58 2015].129679 msShapefileOpen(): Unable to access file. (/home/..../table)

Perhaps is not true that an OGR spatialite can be used as tileindex source ?

Thx,

--
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users