<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>I’m looking for advice on how to pass a GET request Filter through mapserver to an oracle spatial database connection. Although I have successfully implemented a BBOX filter, both DWithin and Intersects spatial filters seem to be ignored during the query process because all features (up to MAXFEATURES) are returned. No errors are returned with debug set to 5. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Here is a sample URL:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="http://wfsd.visualapms.com/wfs.php?SERVICE=WFS&VERSION=1.1.0&REQUEST=getfeature&TYPENAME=parcels&SRSNAME=EPSG:4269&OUTPUTFORMAT=json&Filter=%3CFilter%3E%3CDWithin%3E%3CPropertyName%3ESHAPE%3C/PropertyName%3E%3Cgml:Point%3E%3Cgml:coordinates%3E-101.9378217465,36.758602636999996%3C/gml:coordinates%3E%3C/gml:Point%3E%3CDistance%20units=%27meters%27%3E200%3C/Distance%3E%3C/DWithin%3E%3C/Filter%3E&MAXFEATURES=300">http://wfsd.visualapms.com/wfs.php?SERVICE=WFS&VERSION=1.1.0&REQUEST=getfeature&TYPENAME=parcels&SRSNAME=EPSG:4269&OUTPUTFORMAT=json&Filter=%3CFilter%3E%3CDWithin%3E%3CPropertyName%3ESHAPE%3C/PropertyName%3E%3Cgml:Point%3E%3Cgml:coordinates%3E-101.9378217465,36.758602636999996%3C/gml:coordinates%3E%3C/gml:Point%3E%3CDistance%20units=%27meters%27%3E200%3C/Distance%3E%3C/DWithin%3E%3C/Filter%3E&MAXFEATURES=300</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Here is the filter part of that url in xml format:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>&Filter=<Filter><DWithin><PropertyName>SHAPE</PropertyName><gml:Point><gml:coordinates>-101.9378217465,36.758602636999996<gml:coordinates></gml:Point><Distance units=”meters”>200</Distance></DWithin></Filter><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>…and here is the layer definition within the map file I’m using:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> LAYER<o:p></o:p></p><p class=MsoNormal> NAME "parcels"<o:p></o:p></p><p class=MsoNormal> METADATA<o:p></o:p></p><p class=MsoNormal> "wfs_title" "Parcels"<o:p></o:p></p><p class=MsoNormal> "wfs_srs" "EPSG:4269"<o:p></o:p></p><p class=MsoNormal> "gml_include_items" "all"<o:p></o:p></p><p class=MsoNormal> "gml_featureid" "OBJECTID"<o:p></o:p></p><p class=MsoNormal> "wfs_enable_request" "*"<o:p></o:p></p><p class=MsoNormal> "wfs_getfeature_formatlist" "gml,json,geojson"<o:p></o:p></p><p class=MsoNormal> "gml_COUNTRY_ID_type" "Character"<o:p></o:p></p><p class=MsoNormal> "gml_STATE_ID_type" "Character"<o:p></o:p></p><p class=MsoNormal> "gml_COUNTY_ID_type" "Character"<o:p></o:p></p><p class=MsoNormal> "gml_PARCEL_ID_type" "Character"<o:p></o:p></p><p class=MsoNormal> END<o:p></o:p></p><p class=MsoNormal> TYPE POLYGON<o:p></o:p></p><p class=MsoNormal> STATUS ON<o:p></o:p></p><p class=MsoNormal> EXTENT -180 -90 180 90<o:p></o:p></p><p class=MsoNormal> CONNECTIONTYPE oraclespatial<o:p></o:p></p><p class=MsoNormal> CONNECTION "SDE/3nz0rb4rr4g1n@ArcSDE"<o:p></o:p></p><p class=MsoNormal> DATA "SHAPE FROM (select OBJECTID, COUNTRY_ID, STATE_ID, COUNTY_ID, PARCEL_ID, APP_USER_G, SHAPE from PARCEL) USING FILTER"<o:p></o:p></p><p class=MsoNormal> PROJECTION<o:p></o:p></p><p class=MsoNormal> "init=epsg:4269"<o:p></o:p></p><p class=MsoNormal> END<o:p></o:p></p><p class=MsoNormal> CLASS<o:p></o:p></p><p class=MsoNormal> NAME "Parcels"<o:p></o:p></p><p class=MsoNormal> STYLE<o:p></o:p></p><p class=MsoNormal> COLOR 240 240 240<o:p></o:p></p><p class=MsoNormal> OUTLINECOLOR 0 0 0<o:p></o:p></p><p class=MsoNormal> END<o:p></o:p></p><p class=MsoNormal> END<o:p></o:p></p><p class=MsoNormal> END<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hoping others have gone down this rabbit hole…thanks for looking!<o:p></o:p></p></div></body></html>