<div dir="ltr"><div><div>Hi,<br><br></div>googling I found this thread:<br><a href="http://lists.osgeo.org/pipermail/gdal-dev/2011-April/028373.html">http://lists.osgeo.org/pipermail/gdal-dev/2011-April/028373.html</a><br>
<br></div>as reported in it seem that to see the spatialite view need to set the <br><pre>SQLITE_LIST_ALL_TABLES<br></pre><pre>parameter.<br><br></pre><pre>Is this kind of sqlite/spatialite parameters settable for an ogr connection inside a mafile ?<br>
<br></pre><pre>Thx<br></pre><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/4/13 Andrea Peri <span dir="ltr"><<a href="mailto:aperi2007@gmail.com" target="_blank">aperi2007@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hi,<br></div>thx for reply.<br><div class="gmail_extra"><br></div><div class="gmail_extra">I check your hint.<br>
</div><div class="gmail_extra">As readable from spatialite documentation a spatial view seem need to registered on a special geometry column named:<br>
<br></div><div class="gmail_extra">views_geometry_columns<br><br></div><div class="gmail_extra">I add the view to this table but still the wfs seem don't understand any.<br><br></div><div class="gmail_extra">This is what it return:<br>
<br><wfs:FeatureCollection <br> xsi:schemaLocation="<a href="http://mapserver.gis.umn.edu/mapserver" target="_blank">http://mapserver.gis.umn.edu/mapserver</a> <a href="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" target="_blank">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</a> <a href="http://www.opengis.net/wfs" target="_blank">http://www.opengis.net/wfs</a> <a href="http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" target="_blank">http://schemas.opengis.net/wfs/1.1.0/wfs.xsd</a>"><br>
<gml:boundedBy><br> <gml:Null>missing</gml:Null><br></gml:boundedBy><br></wfs:FeatureCollection><br><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/4/13 <span dir="ltr"><<a href="mailto:pcreso@pcreso.com" target="_blank">pcreso@pcreso.com</a>></span><div>
<div class="h5"><br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit" valign="top">
Hi Andrea,<br>
<br>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.<br><br><br>Brent Wood<br><br><br>--- On <b>Sat, 4/13/13, aperi2007 <i><<a href="mailto:aperi2007@gmail.com" target="_blank">aperi2007@gmail.com</a>></i></b> wrote:<br>
<blockquote style="border-left:2px solid rgb(16,16,255);margin-left:5px;padding-left:5px"><br>From: aperi2007 <<a href="mailto:aperi2007@gmail.com" target="_blank">aperi2007@gmail.com</a>><br>Subject: [mapserver-users] WFS on a view from a spatialite source<br>
To: <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>Date: Saturday, April 13, 2013, 11:17 AM<br><br><div><div><div>Hi,<br><br>I'm try-ing to start a wfs service using a spatialite db as datasosurce.<br>
It work if I use a table.<br><br>But using a spatial view it don't seem work<br>It return a GML Bound NULL.<br><br>I don't know if I'm wrong to set
it.<br><br>There is any on that as successfully use a spatial view of spatialite as datasource for wfs ?<br><br>Thx,<br><br>Andrea Peri<br><br></div></div>_______________________________________________<br>mapserver-users mailing list<br>
<a href="http://mc/compose?to=mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div></blockquote></td></tr></tbody></table></blockquote></div></div></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><br>-- <br>-----------------<br>Andrea Peri<br>. . . . . . . . . <br>qwerty àèìòù<br>
-----------------<br>
</font></span></div></div>
</blockquote></div><br><br clear="all"><br>-- <br>-----------------<br>Andrea Peri<br>. . . . . . . . . <br>qwerty àèìòù<br>-----------------<br>
</div>