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-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Rahkonen Jukka (MML) Sent: den 16 mars 2015 17:25 To: Andrea Peri; mapserver-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
