<font size=2 face="sans-serif">Is there a documentation that says that
it is not?</font>
<br><font size=2 face="sans-serif">Folks from gdal list also think that
it is not supported...I guess you are right. But as I said on the gdal
list, many countries are using a comma as a decimal separator....what other
people on the planet do?</font>
<br><font size=2 face="sans-serif">Anyway the comma is another problem
that I try to manage later......</font>
<br>
<br><font size=2 face="sans-serif">For now, We have an application that
generate and launch spatial queries on WFS, matchCase=false by default.
Before modifying the code I want to understand what is going on....</font>
<br><font size=2 face="sans-serif">It seems,when using numeric value, that
matchCase as no impact in PostGIS, but it is important in oracle to be
set to true</font>
<br>
<br><font size=2 face="sans-serif">gml_type = auto, returns double in postgis
and oracle, so that is fine</font>
<br><font size=2 face="sans-serif">A WFS getFeature with the operator PropertyIsEqualTo
AND matchCase=<b>false</b></font>
<br><font size=2 face="sans-serif">using this value -64<b>.</b>225</font>
<br><font size=2 face="sans-serif">PostGis: it works</font>
<br><font size=2 face="sans-serif">Oracle (from mike's test): it fails...matchCase
must be set to true</font>
<br>
<br><font size=2 face="sans-serif">A WFS getFeature with the operator PropertyIsEqualTo
AND matchCase=<b>false</b></font>
<br><font size=2 face="sans-serif">using this value -64<b>,</b>225</font>
<br><font size=2 face="sans-serif">PotsGis: not tested </font>
<br><font size=2 face="sans-serif">Oracle: it fails...matchCase must be
set to true</font>
<br>
<br><font size=2 face="sans-serif">Is there a reason why, with oracle,
matchCase should be set to true when using numeric value, or that could
be fixed?</font>
<br><font size=2 face="sans-serif">Regards</font>
<br><font size=2 face="sans-serif">Steve</font>
<br>
<p>
<br>
<br>
<br>
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=40% 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"><b>"Smith,
Michael ERDC-RDE-CRREL-NH" <Michael.Smith@erdc.dren.mil></b>
</font>
<p><font size=1 face="sans-serif">2015-05-14 09:17</font>
<td width=59% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=21>
<td width=57 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align=right><font size=1 face="sans-serif">A</font></div>
<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">"Steve.Toutant@inspq.qc.ca"
<Steve.Toutant@inspq.qc.ca></font>
<tr valign=top height=21>
<td width=57 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align=right><font size=1 face="sans-serif">cc</font></div>
<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">MapserverList
OSGEO <mapserver-users@lists.osgeo.org>, thomas bonfort <thomas.bonfort@gmail.com></font>
<tr valign=top height=21>
<td width=57 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align=right><font size=1 face="sans-serif">Objet</font></div>
<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:
[EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with
filter on numeric field</font></table>
<br>
<table width=393 style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=57 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<td width=336 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"></table>
<br></table>
<br>
<br>
<br>
<br>
<br><font size=2 face="Calibri">Its not clear to me that commas as the
decimal separator is supported in XML/GML. I can't find any documentation
to indicate that it is. Can you point some out to me?</font>
<br>
<br><font size=2 face="Calibri">In any event, I didn't test with comma
decimal separators. </font>
<br>
<br><font size=2 face="Calibri">Mike</font>
<br>
<br><font size=2 face="Calibri"> </font>
<br><font size=2 face="Calibri">----</font>
<br><font size=2 face="Calibri">Michael Smith</font>
<br><font size=2 face="Calibri">US Army Corps</font>
<br><font size=2 face="Calibri">Remote Sensing GIS/Center</font>
<br><font size=2 face="Calibri">michael.smith@usace.army.mil</font>
<br>
<br>
<br><font size=2 face="Calibri"><b>From: </b>"</font><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=2 color=blue face="Calibri"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=2 face="Calibri">"
<</font><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=2 color=blue face="Calibri"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=2 face="Calibri">><b><br>
Date: </b>Thursday, May 14, 2015 at 8:54 AM<b><br>
To: </b>Michael Smith <</font><a href=mailto:michael.smith@erdc.dren.mil><font size=2 color=blue face="Calibri"><u>michael.smith@erdc.dren.mil</u></font></a><font size=2 face="Calibri">><b><br>
Cc: </b>MapserverList OSGEO <</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size=2 color=blue face="Calibri"><u>mapserver-users@lists.osgeo.org</u></font></a><font size=2 face="Calibri">>,
thomas bonfort <</font><a href=mailto:thomas.bonfort@gmail.com><font size=2 color=blue face="Calibri"><u>thomas.bonfort@gmail.com</u></font></a><font size=2 face="Calibri">><b><br>
Subject: </b>Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle -
wfs getFeature with filter on numeric field</font>
<br>
<br><font size=2 face="sans-serif">Thanks Mike for having a look at it.</font><font size=2 face="Calibri">
</font><font size=2 face="sans-serif"><br>
Your decimals are separated by a comma or a dot?</font><font size=2 face="Calibri"><br>
</font>
<p><font size=2 face="Calibri"><br>
<br>
</font>
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=39% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size=1 face="sans-serif"><b>"Smith,
Michael ERDC-RDE-CRREL-NH" <</b></font><a href=mailto:Michael.Smith@erdc.dren.mil><font size=1 color=blue face="sans-serif"><b><u>Michael.Smith@erdc.dren.mil</u></b></font></a><font size=1 face="sans-serif"><b>></b></font><font size=3 face="Calibri">
</font>
<p><font size=1 face="sans-serif">2015-05-13 18:53</font><font size=3 face="Calibri">
</font>
<td width=60% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<br>
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=9% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align=right><font size=1 face="sans-serif">A</font></div>
<td width=90% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size=1 face="sans-serif">"</font><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=1 color=blue face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=1 face="sans-serif">"
<</font><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=1 color=blue face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=1 face="sans-serif">>,
thomas bonfort <</font><a href=mailto:thomas.bonfort@gmail.com><font size=1 color=blue face="sans-serif"><u>thomas.bonfort@gmail.com</u></font></a><font size=1 face="sans-serif">></font>
<tr valign=top height=8>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size=1 face="sans-serif">MapserverList
OSGEO <</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size=1 color=blue face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size=1 face="sans-serif">></font>
<tr valign=top height=8>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align=right><font size=1 face="sans-serif">Objet</font></div>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size=1 face="sans-serif">Re:
[EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with
filter on numeric field</font></table>
<br>
<br>
<table width=393 style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=56 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<td width=332 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"></table>
<br></table>
<br><font size=2 face="Calibri"><br>
<br>
<br>
<br>
</font><font size=2 face="sans-serif"><br>
Steve,</font><font size=2 face="Calibri"> <br>
</font><font size=2 face="sans-serif"><br>
I tested this out with 7.1 with numeric type fields and it works for me
as long as I don't use matchCase="false". That seems to kick
it in to a string comparison. matchCase="true" and just PropertyIsEqualTo
work fine.</font><font size=2 face="Calibri"><br>
</font><font size=2 face="sans-serif"><br>
In our metadata we use "gml_types" "auto" when
the database knows the types and explicit declarations (eg "gml_attributename_type"
"integer") when it doesn't work.</font><font size=2 face="Calibri"><br>
</font><font size=2 face="sans-serif"><br>
The key is that the field type has to report as a numeric type or the backend
treats it as a string comparison.</font><font size=2 face="Calibri"><br>
</font><font size=2 face="sans-serif"><br>
Mike</font><font size=2 face="Calibri"> </font><font size=2 face="sans-serif"><br>
----</font><font size=2 face="Calibri"> </font><font size=2 face="sans-serif"><br>
Michael Smith</font><font size=2 face="Calibri"> </font><font size=2 face="sans-serif"><br>
US Army Corps</font><font size=2 face="Calibri"> </font><font size=2 face="sans-serif"><br>
Remote Sensing GIS/Center</font><font size=2 face="Calibri"> </font><font size=2 color=blue face="sans-serif"><u><br>
</u></font><a href=mailto:michael.smith@usace.army.mil><font size=2 color=blue face="sans-serif"><u>michael.smith@usace.army.mil</u></font></a><font size=2 face="Calibri">
<br>
<br>
</font><font size=2 face="Calibri"><b><br>
From: </b>"</font><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=2 color=blue face="Calibri"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=2 face="Calibri">"
<</font><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=2 color=blue face="Calibri"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=2 face="Calibri">><b><br>
Date: </b>Wednesday, May 13, 2015 at 10:35 AM<b><br>
To: </b>thomas bonfort <</font><a href=mailto:thomas.bonfort@gmail.com><font size=2 color=blue face="Calibri"><u>thomas.bonfort@gmail.com</u></font></a><font size=2 face="Calibri">><b><br>
Cc: </b>MapserverList OSGEO <</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size=2 color=blue face="Calibri"><u>mapserver-users@lists.osgeo.org</u></font></a><font size=2 face="Calibri">><b><br>
Subject: </b>[EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs
getFeature with filter on numeric field<b><br>
Resent-From: </b>Michael Smith <</font><a href=mailto:michael.smith@usace.army.mil><font size=2 color=blue face="Calibri"><u>michael.smith@usace.army.mil</u></font></a><font size=2 face="Calibri">></font><font size=2 face="Calibri"><br>
</font><font size=2 face="sans-serif"><br>
Precision: we are using MS7.1<br>
Removing matchcase part makes oracle, and postgis, crash.<br>
I have this error: </font><font size=2 color=#2f2f2f face="Arial"><br>
<br>
<ows:ExceptionReport xmlns:xsi="</font><a href="http://www.google.com/url?q=http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance&sa=D&sntz=1&usg=AFQjCNFERp6A_kcvqihMCKJ7EHX8O14vIA" target=_blank><font size=2 color=blue face="Arial"><u>http://www.w3.org/2001/XMLSchema-instance</u></font></a><font size=2 color=#2f2f2f face="Arial">"
xmlns:ows="</font><a href="http://www.google.com/url?q=http%3A%2F%2Fwww.opengis.net%2Fows&sa=D&sntz=1&usg=AFQjCNE9_q7eSkcBl4XJimXTw1Zx0EiDow" target=_blank><font size=2 color=blue face="Arial"><u>http://www.opengis.net/ows</u></font></a><font size=2 color=#2f2f2f face="Arial">"
version="1.1.0" language="en-US"xsi:schemaLocation="</font><a href="http://www.google.com/url?q=http%3A%2F%2Fwww.opengis.net%2Fows&sa=D&sntz=1&usg=AFQjCNE9_q7eSkcBl4XJimXTw1Zx0EiDow" target=_blank><font size=2 color=blue face="Arial"><u>http://www.opengis.net/ows</u></font><font size=2 color=blue face="sans-serif"><u><
/a></u></font></a><a href="http://www.google.com/url?q=http%3A%2F%2Fschemas.opengis.net%2Fows%2F1.0.0%2FowsExceptionReport.xsd&sa=D&sntz=1&usg=AFQjCNGmnK6iSrh-cSWEtM2VV17uuSbVNA" target=_blank><font size=2 color=blue face="Arial"><u>http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd</u></font></a><font size=2 color=#2f2f2f face="Arial">"><br>
<ows:Exception exceptionCode="NoApplicableCode" locator="mapserv"><br>
<ows:ExceptionText><br>
msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed msOracleSpatialLayerWhichShapes():
OracleSpatial error. Check your data statement and server logs<br>
</ows:ExceptionText></font><font size=3 face="sans-serif"> </font><font size=2 face="sans-serif"><br>
<br>
<br>
The problem might be the decimals? <br>
Here is the request <br>
<wfs:Query typeName="feature:SMDVDP_STAT_METE" srsName="EPSG:32198"><br>
<ogc:Filter xmlns:ogc="</font><a href=http://www.opengis.net/ogc><font size=2 color=blue face="sans-serif"><u>http://www.opengis.net/ogc</u></font></a><font size=2 face="sans-serif">"><br>
<ogc:PropertyIsEqualTo> <br>
<ogc:PropertyName>LONG_STAT</ogc:PropertyName><br>
<ogc:Literal><b>-61,8031</b></ogc:Literal><br>
</ogc:PropertyIsEqualTo> <br>
</ogc:Filter> <br>
</wfs:Query> <br>
</wfs:GetFeature> </font>
<p><font size=2 face="sans-serif"><br>
</font>
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=34% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size=1 face="sans-serif"><b>thomas
bonfort <</b></font><a href=mailto:thomas.bonfort@gmail.com><font size=1 color=blue face="sans-serif"><b><u>thomas.bonfort@gmail.com</u></b></font></a><font size=1 face="sans-serif"><b>></b></font><font size=3 face="Calibri">
</font>
<p><font size=1 face="sans-serif">2015-05-13 05:40</font>
<td width=65% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<br>
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=6% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align=right><font size=1 face="sans-serif">A</font></div>
<td width=93% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=1 color=blue face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a>
<tr valign=top height=8>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size=1 face="sans-serif">MapserverList
OSGEO <</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size=1 color=blue face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size=1 face="sans-serif">></font>
<tr valign=top height=8>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align=right><font size=1 face="sans-serif">Objet</font></div>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size=1 face="sans-serif">Re:
[mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric
field</font></table>
<br><font size=3 face="Calibri"><br>
</font>
<br>
<table width=392 style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=56 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<td width=332 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"></table>
<br></table>
<br><font size=2 face="sans-serif"><br>
<br>
<br>
<br>
<br>
<br>
can you try the same request without the "matchCase" part and
report<br>
back please?<br>
<br>
On 12 May 2015 at 18:11, <</font><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=2 color=blue face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=2 face="sans-serif">>
wrote:<br>
> I have a problem using a FILTER in a wfs getFeature request on an
oracle DB<br>
> with MS7<br>
> When I launch a getFeature request with a Filter on a numeric field
it<br>
> doesn't work,<br>
> <ogc:Filter xmlns:ogc="</font><a href=http://www.opengis.net/ogc><font size=2 color=blue face="sans-serif"><u>http://www.opengis.net/ogc</u></font></a><font size=2 face="sans-serif">"><ogc:PropertyIsEqualTo<br>
> matchCase="false"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter><br>
> here is the error we get in the browser<br>
> <ows:Exception exceptionCode="NoApplicableCode" locator="mapserv"><br>
> <ows:ExceptionText>msWFSGetFeature(): WFS server
error.<br>
> FLTApplyFilterToLayer() failed<br>
> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your
data<br>
> statement and server logs</ows:ExceptionText><br>
><br>
> from mapserver logs<br>
> [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.<br>
> String: ([LONG_STAT] =*-61)<br>
><br>
> LONG_STAT is a NUMBER in the DB<br>
> DescribefeatureType returns<br>
> <element name="NO_STAT_CLIM"
minOccurs="0" type="string"/><br>
> <element name="NO_STAT_FADQ"
minOccurs="0" type="string"/><br>
> <element name="NOM_STAT"
minOccurs="0" type="string"/><br>
> <element name="LATI_STAT"
minOccurs="0" type="string"/><br>
> <element name="LONG_STAT"
minOccurs="0" type="string"/><br>
> <element name="ALTI_STAT"
minOccurs="0" type="string"/><br>
><br>
> I tried to add "gml_types" "auto" in the mapfile,
but it still returns<br>
> string as data type<br>
> I tried "gml_LONG_STAT_type" = "Integer" in the
mapfile, describeFeatureType<br>
> returns "<element name="LONG_STAT" minOccurs="0"
type="double"/> " but I<br>
> still get an error in getFeature<br>
><br>
> I'm using CONNECTIONTYPE oraclespatial in the mapfile<br>
><br>
> I can provide more information....<br>
><br>
> Is it a known issue or can I do something about that?<br>
><br>
> Thank you!<br>
> _______________________________________________<br>
> mapserver-users mailing list<br>
> </font><a href="mailto:mapserver-users@lists.osgeo.org"><font size=2 color=blue face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size=2 face="sans-serif"><br>
> </font><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"><font size=2 color=blue face="sans-serif"><u>http://lists.osgeo.org/mailman/listinfo/mapserver-users</u></font></a><font size=2 face="sans-serif"><br>
<br>
</font><font size=2 face="Calibri"><br>
<br>
<br>
</font>
<br>
<br>
<br>