Hi Jukka. effectively the work of spatialite with mapserver is quite strange. :)
But thx to youe response I have resolved and it work. :) Infact my original setting was exactly: DATA 'select field1,field1,field3 from my_view' I usually use this configuration because it is better for the GetFeatureInfo wms's requests. And with this configuration the wfs seem don't work. But if I change to this other configuration: DATA 'my_view' It work. As you can see http://www502.regione.toscana.it/wmsraster/com.rt.wms.RTmap/wms?map=wmstest&service=wfs&version=1.1.0&srsname=epsg:25832&request=GetFeature&typename=v_lista_comuni_ordered_prov_com&propertyName=nprov,ncom,codcom,codprov&sortBy=ncom But the response is quite strange because the response is not sorted on the "ncom" attribute, and also I see two attribute are lowercase and two are uppercase. This is strange because the view is defined with the alias always lowercase. However it now work and this is a good start point. Thx, 2013/4/13 Rahkonen Jukka <[email protected]> > 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 àèìòù > ----------------- > -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù -----------------
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
