[mapserver-users] RE VS: Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve.Toutant at inspq.qc.ca]

this is weird.....
First, DescribeFeatureType returns string for every attributes
<element name="LONG_STAT" minOccurs="0" type="string"/> 

Here is a getfeature response ( 
http:/xxxxx?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=feature:SMDVDP_STAT_METE&maxFeatures=5 
) 
 <ms:LONG_STAT>-65,6906</ms:LONG_STAT>    

Using ogc:PropertyIsEqualTo matchCase="true" <ogc:Literal>-61,
8031</ogc:Literal> it crashes
Using ogc:PropertyIsEqualTo matchCase="true" <ogc:Literal>-61.
8031</ogc:Literal> it works
Using ogc:PropertyIsEqualTo matchCase="false" <ogc:Literal>-61.
8031</ogc:Literal> it crashes

So getfeature returns "," as decimals separator, but getfeature with a 
filter needs a "." to works, but with matchCase=false crashes in any 
case.....

I'm totally confuse




"Rahkonen Jukka (MML)" <jukka.rahkonen at maanmittauslaitos.fi> 
2015-05-13 10:46

A
"Steve.Toutant at inspq.qc.ca" <Steve.Toutant at inspq.qc.ca>
cc
MapserverList OSGEO <mapserver-users at lists.osgeo.org>
Objet
VS: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field








Hi,
 
What does the schema of the feature type show if you check it with 
DescribeFeatureType? If the property is String I think you should stop 
what you do and make Mapserver to consider and announce the property as 
numeric first.
 
-Jukka Rahkonen-
 
Steve.Toutant at inspq.qc.ca wrote:
 
this works 
<ogc:PropertyIsLike matchCase="true" wildCard="*" singleChar="." 
escapeChar="!"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>*-61,8031*</ogc:Literal></ogc:PropertyIsLike> 


But we want to be able to usePropertyIsEqual because are end users won't 
use PropertyIsLike... 



thomas bonfort <thomas.bonfort at gmail.com> 
2015-05-13 05:40 


A
Steve.Toutant at inspq.qc.ca 
cc
MapserverList OSGEO <mapserver-users at lists.osgeo.org> 
Objet
Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field
 










can you try the same request without the "matchCase" part and report
back please?

On 12 May 2015 at 18:11,  <Steve.Toutant at inspq.qc.ca> wrote:
> I have a problem using a FILTER in a wfs getFeature request on an oracle 
DB
> with MS7
> When I launch a getFeature request with a Filter on a numeric field it
> doesn't work,
> <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc
"><ogc:PropertyIsEqualTo
> 
matchCase="false"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter>
> here is the error we get in the browser
> <ows:Exception exceptionCode="NoApplicableCode" locator="mapserv">
>    <ows:ExceptionText>msWFSGetFeature(): WFS server error.
> FLTApplyFilterToLayer() failed
> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data
> statement and server logs</ows:ExceptionText>
>
> from mapserver logs
> [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.
> String:  ([LONG_STAT] =*-61)
>
> LONG_STAT is a NUMBER in the DB
> DescribefeatureType returns
>           <element name="NO_STAT_CLIM" minOccurs="0" type="string"/>
>          <element name="NO_STAT_FADQ" minOccurs="0" type="string"/>
>          <element name="NOM_STAT" minOccurs="0" type="string"/>
>          <element name="LATI_STAT" minOccurs="0" type="string"/>
>          <element name="LONG_STAT" minOccurs="0" type="string"/>
>          <element name="ALTI_STAT" minOccurs="0" type="string"/>
>
> I tried to add "gml_types" "auto" in the mapfile, but it still returns
> string as data type
> I tried "gml_LONG_STAT_type" = "Integer" in the mapfile, 
describeFeatureType
> returns "<element name="LONG_STAT" minOccurs="0" type="double"/> " but I
> still get an error in getFeature
>
> I'm using CONNECTIONTYPE oraclespatial in the mapfile
>
> I can provide more information....
>
> Is it a known issue or can I do something about that?
>
> Thank you!
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150513/160887bf/attachment.htm>