[mapserver-users] wfs request getfeature with polygon

[Lime, Steve D (DNR)]

I would expect to see a bbox query using the bbox of your search shape. That would then identify candidate shapes, likely a much smaller set, for which actual intersection tests are done. I'll defer to the WFS devs for a bit more insight.

Steve

From: Marc-André Trottier [mailto:trottier.marcandre at gmail.com]
Sent: Wednesday, November 30, 2011 12:28 PM
To: Lime, Steve D (DNR); mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] wfs request getfeature with polygon

there is my POST :

<wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><wfs:Query typeName="ms:MSSS_SGS_P" srsName="EPSG:32198"><ogc:Filter xmlns:ogc="http://www.opengis.net/ogc"><ogc:Intersects><ogc:PropertyName>geometry</ogc:PropertyName><gml:Polygon xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:32198"><gml:exterior><gml:LinearRing><gml:posList>-206501.9511156373 322690.6403888138 -222920.53608453833 315197.18794487417 -217872.36749086587 305166.3182788128 -205933.97268351325 315573.2833999051 -206501.9511156373 322690.6403888138</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></ogc:Intersects></ogc:Filter></wfs:Query></wfs:GetFeature>

we got some performance issues with 4 millions features.

2011/11/30 Lime, Steve D (DNR) <Steve.Lime at state.mn.us<mailto:Steve.Lime at state.mn.us>>
What exactly is the WFS filter being used? Only certain queries are done wholly in the database. Most often bbox tests
are done in the database with other work done in MapServer.  We hope to move more load off to the database
eventually. Are you seeing performance issues?

Steve

From: mapserver-users-bounces at lists.osgeo.org<mailto:mapserver-users-bounces at lists.osgeo.org> [mailto:mapserver-users-bounces at lists.osgeo.org<mailto:mapserver-users-bounces at lists.osgeo.org>] On Behalf Of Marc-André Trottier
Sent: Tuesday, November 29, 2011 5:06 PM

To: mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Subject: [mapserver-users] wfs request getfeature with polygon


! i'm doing a WFS GetFeature request with a polygon.

Usually everything is fine.
but for one table a got a enconding error with my data. (my problem) and the mapserver's log give me this SQL :

select "nom","adresse","postal","code","telephone","postal0","etab_code","etab_nom","rss_code","rss_nom","rls_code","rls_nom","clsc_code","clsc_nom","mun_code","mun_nom","longitude","latitude","sgs","hsld","clsc","pdi","pdp","pat","cj","sp","objectid","nom_commun",encode(ST_AsBinary(ST_Force_2D("geom_p"),'NDR'),'hex') as geom,"objectid" from msss_v_sgs_p where geom_p && GeomFromText('POLYGON((-1100000 -23500,-1100000 2253500,1100000 2253500,1100000 -23500,-1100000 -23500))',find_srid('','msss_v_sgs_p','geom_p'))

So my question, Why is mapserver does a spatial query with the layer's extent?
with a table of 2millions features, that,s very slow even with a spatial index

marc-andre trottier

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111130/ed867c87/attachment.html