<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hello Steve,<br>
<br>
maybe you can use a bounding box instead taking the
<meta http-equiv="content-type" content="text/html;
charset=windows-1252">
<title></title>
<meta name="generator" content="LibreOffice 4.2.7.2 (Linux)">
<style type="text/css">
<!--
@page { margin: 2cm }
p { margin-bottom: 0.25cm; line-height: 120% }
a:link { so-language: zxx }
-->
</style><bbox=793732,6570204,793765,6570228> command in the WFS
request somehow (with your own coordinates naturally)? I do not
work with open layers so I do not know how to do it there. It
works quite nicely in Leaflet. <br>
Basically I zoom to where I'm interested in and then fire the
request. I guess one could also do this without zooming in first.<br>
<br>
Hope this can be of any help.<br>
<br>
Cheers<br>
<br>
Lars<br>
<br>
Am 26.01.2015 um 16:38 schrieb <a class="moz-txt-link-abbreviated" href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>:<br>
</div>
<blockquote
cite="mid:OF2F1389A2.E71974B7-ON85257DD9.0054EED8-85257DD9.0055E2B6@isn.rtss.qc.ca"
type="cite">
<p><font size="2" face="sans-serif">I understand the objective of
rfc 91,
but the most common use case would be to pass the supplied
geometry.....</font>
</p>
<p><font size="2" face="sans-serif">If mapserver doesn't use the
supplied
geometry, that means that it doesn't support spatial
filtering. </font>
</p>
<p><font size="2" face="sans-serif">Our data covers the whole
country, not
using the supplied geometry means we can't use mapserver as a
wfs server....</font>
</p>
<p><font size="2" face="sans-serif">Is there something we can do
about it?
A workaround we could use?</font>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
<br>
<br>
<br>
<table style="border-collapse:collapse;" width="100%">
<tbody>
<tr height="8" valign="top">
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px 0px
0px;padding:0px 0px;" width="40%"><font size="1"
face="sans-serif"><b>"Lime,
Steve D (MNIT)" <a class="moz-txt-link-rfc2396E" href="mailto:Steve.Lime@state.mn.us"><Steve.Lime@state.mn.us></a></b> </font>
<p><font size="1" face="sans-serif">2015-01-26 10:14</font>
</p>
</td>
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px 0px
0px;padding:0px 0px;" width="59%">
<table style="border-collapse:collapse;" width="100%">
<tbody>
<tr height="21" valign="top">
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px
0px 0px;padding:0px 0px;" width="57">
<div align="right"><font size="1"
face="sans-serif">A</font></div>
</td>
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px
0px 0px;padding:0px 0px;"><font size="1"
face="sans-serif"><a class="moz-txt-link-rfc2396E" href="mailto:Steve.Toutant@inspq.qc.ca">"Steve.Toutant@inspq.qc.ca"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:Steve.Toutant@inspq.qc.ca"><Steve.Toutant@inspq.qc.ca></a>,
<a class="moz-txt-link-rfc2396E" href="mailto:mapserver-users@lists.osgeo.org">"mapserver-users@lists.osgeo.org"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:mapserver-users@lists.osgeo.org"><mapserver-users@lists.osgeo.org></a></font>
</td>
</tr>
<tr height="21" valign="top">
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px
0px 0px;padding:0px 0px;" width="57">
<div align="right"><font size="1"
face="sans-serif">cc</font></div>
</td>
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px
0px 0px;padding:0px 0px;">
<br>
</td>
</tr>
<tr height="21" valign="top">
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px
0px 0px;padding:0px 0px;" width="57">
<div align="right"><font size="1"
face="sans-serif">Objet</font></div>
</td>
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px
0px 0px;padding:0px 0px;"><font size="1"
face="sans-serif">RE:
[mapserver-users] Mapserver doesn't send good
filter to postgis</font></td>
</tr>
</tbody>
</table>
<br>
<table style="border-collapse:collapse;" width="393">
<tbody>
<tr height="8" valign="top">
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px
0px 0px;padding:0px 0px;" width="57">
<br>
</td>
<td style="border-style:none none none
none;border-color:#000000;border-width:0px 0px
0px 0px;padding:0px 0px;" width="336"><br>
</td>
</tr>
</tbody>
</table>
<br>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<br>
<br>
<font size="3" color="#004080" face="Calibri">It’s a limitation
in older
versions of MapServer where specific backend optimizations
were scattered
about the WMS/WFS code. Most of those optimizations address
the most common
use cases – I guess this wasn’t one of them. It’s surprising
that at
worst the extent of the supplied geometry isn’t passed (I see
a comment
in the WFS code about this). The specific filter intersection
test is applied
on the MapServer side – the results are correct, performance
can suffer
though.</font>
<br>
<font size="3" color="#004080" face="Calibri"> </font>
<br>
<font size="3" color="#004080" face="Calibri">This is being
addresses in
MapServer 7.0 where more complete filter translation functions
are being
supported (RFC 91).</font>
<br>
<font size="3" color="#004080" face="Calibri"> </font>
<br>
<font size="3" color="#004080" face="Calibri">Steve</font>
<br>
<font size="3" color="#004080" face="Calibri"> </font>
<br>
<font size="3" face="Tahoma"><b>From:</b>
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>
[</font><a moz-do-not-send="true"
href="mailto:mapserver-users-bounces@lists.osgeo.org"><font
size="3" face="Tahoma">mailto:mapserver-users-bounces@lists.osgeo.org</font></a><font
size="3" face="Tahoma">]
<b>On Behalf Of </b><a class="moz-txt-link-abbreviated" href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a><b><br>
Sent:</b> Monday, January 26, 2015 8:55 AM<b><br>
To:</b> <a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><b><br>
Subject:</b> [mapserver-users] Mapserver doesn't send good
filter to postgis</font>
<br>
<font size="3" face="Times New Roman"> </font>
<br>
<font size="3" face="Arial">Sorry my first post was with an
inapprpriate
title......</font><font size="3" face="Times New Roman"> <br>
</font><font size="3" face="Arial"><br>
I'm using mapserver 6.4.1 and postgis 2.1</font><font size="3"
face="Times New Roman">
<br>
</font><font size="3" face="Arial"><br>
using OpenLayers 2.13.1 I draw a small polygon that I use for
a within
spatial filter of a WFS getfeature request. The problem is
that mapserver
is not sending this polygon to postgis, it is sending the
extent of the
mapfile as filter...</font><font size="3" face="Times New
Roman"> <br>
</font><font size="3" face="Arial"><br>
The wfs POST Request (created and send by OpenLayers client)</font><font
size="3" face="Times New Roman">
</font><font size="3" color="#2f2f2f" face="DejaVu Sans Mono"><br>
<ogc:Filter xmlns:ogc="</font><a moz-do-not-send="true"
href="http://www.opengis.net/ogc"><font size="3" color="blue"
face="DejaVu Sans Mono"><u>http://www.opengis.net/ogc</u></font></a><font
size="3" color="#2f2f2f" face="DejaVu Sans Mono">"><ogc:Within><ogc:PropertyName>msGeometry</ogc:PropertyName><gml:Polygon
xmlns:gml="</font><a moz-do-not-send="true"
href="http://www.opengis.net/gml"><font size="3" color="blue"
face="DejaVu Sans Mono"><u>http://www.opengis.net/gml</u></font></a><font
size="3" color="#2f2f2f" face="DejaVu Sans Mono">"
srsName="urn:ogc:def:crs:EPSG::3857"><gml:exterior><gml:LinearRing><gml:posList>-8081644.2511244
5835062.56996
-8081707.5505384 5834980.1612889 -8081638.2794815
5834913.2788892
-8081533.1785677 5834988.5215889 -8081644.2511244
5835062.56996</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></ogc:Within></ogc:Filter></font><font
size="3" face="Times New Roman">
<br>
</font><font size="3" face="Arial"><br>
In Mapserver log, I see</font><font size="3" face="Times New
Roman"> </font><font size="3" face="Arial"><br>
FLTLayerApplyPlainFilterToLayer(): ([shape] within
fromText('POLYGON
((-8081644.2511243997141719 5835062.5699599999934435,
-8081707.5505384001880884
5834980.1612889003008604, -8081638.2794815003871918
5834913.2788891997188330,
-8081533.1785677000880241 5834988.5215889001265168,
-8081644.2511243997141719
5835062.5699599999934435))'))</font><font size="3" face="Times
New Roman">
<br>
</font><font size="3" face="Arial"><br>
Then a few lines later, I see that it is not sending the
polygon received
as filter</font><font size="3" face="Times New Roman"> </font><font
size="3" face="Arial"><br>
select ....... where geom_p &&
ST_GeomFromText('POLYGON((-9239517
5465442,-9239517 9349764,-5565974 9349764,-5565974
5465442,-9239517 5465442))',3857);</font><font size="3"
face="Times New Roman">
<br>
</font><font size="3" face="Arial"><br>
See the polygon definition is different, postgis receive the
extent defined
in the mapfile</font><font size="3" face="Times New Roman"> </font><font
size="3" face="Arial"><br>
EXTENT -9239517 5465442 -5565974 9349764</font><font size="3"
face="Times New Roman">
<br>
<br>
</font><font size="3" face="Arial"><br>
And, in postgis log I see this query, See the</font><font
size="3" face="Times New Roman">
</font><font size="3" face="Arial"><br>
select ....... where geom_p &&
ST_GeomFromText('POLYGON((-9239517
5465442,-9239517 9349764,-5565974 9349764,-5565974
5465442,-9239517 5465442))',3857);</font><font size="3"
face="Times New Roman">
<br>
<br>
</font><font size="3" face="Arial"><br>
Why Mapserver is not sending the polygon received as filter to
postgis?</font><font size="3" face="Times New Roman">
<br>
<br>
</font><font size="3" face="Arial"><br>
Thanks!</font><font size="3" face="Times New Roman"> </font>
</p>
<p><font size="3" color="#0080ff" face="Times New Roman"><i>Steve
Toutant,
M. Sc.</i></font><font size="3" face="Times New Roman"><br>
Analyste en géomatique<br>
Secteur environnement<br>
Direction de la santé environnementale et de la toxicologie<br>
Institut national de santé publique du Québec<br>
Tél.: 418 646-6777 poste 30015<br>
Téléc.: 418 644-4593</font><font size="3" color="blue"
face="Times New Roman"><u><br>
</u></font><a moz-do-not-send="true"
href="mailto:steve.toutant@inspq.qc.ca"><font size="3"
color="blue" face="Times New Roman"><u>steve.toutant@inspq.qc.ca</u></font></a><font
size="3" color="blue" face="Times New Roman"><u><br>
</u></font><a moz-do-not-send="true"
href="http://www.inspq.qc.ca/"><font size="3" color="blue"
face="Times New Roman"><u>http://www.inspq.qc.ca</u></font></a><font
size="3" color="blue" face="Times New Roman"><u><br>
</u></font><a moz-do-not-send="true"
href="http://www.monclimatmasante.qc.ca/"><font size="3"
color="blue" face="Times New Roman"><u>http://www.monclimatmasante.qc.ca</u></font></a><font
size="3" face="Times New Roman">
</font>
</p>
<p><font size="3" face="Times New Roman"><i>Pour me rejoindre par
courrier</i><br>
Service de l'infrastructure et du réseau<br>
Direction des technologies de l'information<br>
Ministère de la Sécurité Publique<br>
2525 boul. Laurier, 2e étage<br>
Tour Laurentides<br>
Québec, G1V 2L2 </font>
<br>
<br>
<br>
<br>
</p>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></pre>
</blockquote>
<br>
</body>
</html>