[mapserver-users] WFS on a view from a spatialite source

[Andrea Peri]

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 <jukka.rahkonen at mmmtike.fi>

> 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 <aperi2007 at gmail.com<mailto:aperi2007 at gmail.com>>
> 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 <pcreso at pcreso.com<mailto:pcreso at pcreso.com>>
>
> 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 <aperi2007 at gmail.com<mailto:
> aperi2007 at gmail.com>> wrote:
>
> From: aperi2007 <aperi2007 at gmail.com<mailto:aperi2007 at gmail.com>>
> Subject: [mapserver-users] WFS on a view from a spatialite source
> To: mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org
> >
> 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
> mapserver-users at lists.osgeo.org<
> http://mc/compose?to=mapserver-users@lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
>
> --
> -----------------
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -----------------
>
>
>
> --
> -----------------
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -----------------
>



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130413/bff87a9f/attachment.htm>