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

[Andrea Peri]

Hi,

googling I found this thread:
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>

> 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>
>
> 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>* wrote:
>>
>>
>> From: aperi2007 <aperi2007 at gmail.com>
>> Subject: [mapserver-users] WFS on a view from a spatialite source
>> To: 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 àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130413/5c06b46a/attachment.html>