Hi, I made some trials too. I used two different Windows binaries - MS4W with gdal18.dll (2011-08-12) and Mapserver 6.0.1 - binaries from gisinternals including gdal110dev.dll (2013-03-24) and Mapserver 6.3dev
Spatialite database was of version 3.0 and created with Spatialite-gui 1.5.0 When I used MS4W with gdal18.dll I could use Spatialite layers in two ways: CONNECTIONTYPE OGR CONNECTION "test.sqlite" DATA "layer" or with DATA "select GEOMETRY from layer" View did not work. Error was: msOGRFileOpen(): OGR error. GetLayer(layer_view) failed for OGR connection `test.sqlite'. With the gdal110dev.dll thing were not better but worse. Only thing which worked was to use DATA "layer". If I used SELECT in the DATA definitions I got msOGRFileNextShape(): OGR error. Unable to query table layer(GEOMETRY) for column definitions : no such table: layer(GEOMETRY). View did not work with gdaldev110.dll and the error was again the same "no such table: layer(GEOMETRY)". Ogrinfo using this same gdaldev110 version has no troubles in seeing the view as a layer in sqlite database, and is can also read data from the view. It looks like the problem is not in the GDAL but in the way Mapserver is using GDAL. Could you repeat the test with "DATA "SELECT something FROM layer"?. My test suggests that even that does not work with Mapserver 6.3dev at the moment. -Jukka Rahkonen- ________________________________ Andrea Peri wrote > Hi, > googling I found this thread: > http://lists.osgeo.org/pipermail/gdal-dev/2011-April/028373.html<http://lists.osgeo.org/pipermail/gdal-dev/2011-April/028373.html> > as reported in it seem that to see the spatialite view need to set the > SQLITE_LIST_ALL_TABLES > parameter. > Is this kind of sqlite/spatialite parameters settable for an ogr connection > inside a mafile ? > Thx 2013/4/13 Andrea Peri <[email protected]<mailto:[email protected]>> Hi, thx for reply. I check your hint. As readable from spatialite documentation a spatial view seem need to registered on a special geometry column named: views_geometry_columns I add the view to this table but still the wfs seem don't understand any. This is what it return: <wfs:FeatureCollection xsi:schemaLocation="http://mapserver.gis.umn.edu/mapserver http://www502.regione.toscana.it/cartografia/wmsraster/com.rt.wms.RTmap/wms?map=wmstest&SERVICE=WFS&VERSION=1.1.0&REQUEST=DescribeFeatureType&TYPENAME=v_lista_comuni_ordered_prov_com&OUTPUTFORMAT=text/xml;%20subtype=gml/3.1.1 http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd";> <gml:boundedBy> <gml:Null>missing</gml:Null> </gml:boundedBy> </wfs:FeatureCollection> 2013/4/13 <[email protected]<mailto:[email protected]>> Hi Andrea, I'm not a spatialite user (more Postgis), but you may need to create an entry in the geometry_columns table that describes the view for mapserver to be able to access it. Brent Wood --- On Sat, 4/13/13, aperi2007 <[email protected]<mailto:[email protected]>> wrote: From: aperi2007 <[email protected]<mailto:[email protected]>> Subject: [mapserver-users] WFS on a view from a spatialite source To: [email protected]<mailto:[email protected]> Date: Saturday, April 13, 2013, 11:17 AM Hi, I'm try-ing to start a wfs service using a spatialite db as datasosurce. It work if I use a table. But using a spatial view it don't seem work It return a GML Bound NULL. I don't know if I'm wrong to set it. There is any on that as successfully use a spatial view of spatialite as datasource for wfs ? Thx, Andrea Peri _______________________________________________ mapserver-users mailing list [email protected]<http://mc/[email protected]> http://lists.osgeo.org/mailman/listinfo/mapserver-users -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù ----------------- -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù ----------------- _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
