[mapserver-users] RE How to use filter encoding in MapServer in a WFS query?

Tue May 12 13:07:17 PDT 2015

The link you provided works...I received 15 features

I don't know what to say, what firebug or chrome say?

cesare gerbino <cesaregerbino at gmail.com> 
2015-05-12 15:58

A
Steve.Toutant at inspq.qc.ca
cc
mapserver-users at lists.osgeo.org, mapserver-users-bounces at lists.osgeo.org
Objet
Re: RE [mapserver-users] How to use filter encoding in MapServer in a WFS 
query?

Hi Steve,

thank you for the quckly response!!

I've just tried to change my request using you suggestion ... this is the 
new request now ..

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.1.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=
<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc"><ogc:PropertyIsLike 
matchCase="false" wildCard="*" singleChar="." 
escapeChar="!"><ogc:PropertyName>id</ogc:PropertyName><ogc:Literal>*13800000050414*</ogc:Literal></ogc:PropertyIsLike></ogc:Filter> 

or better how it's used in my browser

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.1.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3Cogc:Filter%20xmlns:ogc=%22http://www.opengis.net/ogc%22%3E%3Cogc:PropertyIsLike%20matchCase=%22false%22%20wildCard=%22*%22%20singleChar=%22.%22%20escapeChar=%22!%22%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E*13800073301968*%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E

Unfortunately still doesn't work .... No data received is the response 
.... 

Cesare

Cesare Gerbino

http://cesaregerbino.wordpress.com/
http://www.facebook.com/cesare.gerbino
http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl

https://twitter.com/CesareGerbino
http://www.linkedin.com/pub/cesare-gerbino/56/494/77b

Questo è un account di posta personale di Cesare Gerbino: tutte le 
opinioni espresse sono personali e non riflettono necessariamente quelle 
del mio datore di lavoro

This is Cesare Gerbino mail account. Text is written by Cesare Gerbino: 
 the views expressed  are mine and not necessarily those of my employer.
.

2015-05-12 21:48 GMT+02:00 <Steve.Toutant at inspq.qc.ca>:
Your syntax are good. This is an old problem with int considered as string 

Using ogc:PropertyIsLike works though, here is a request 

<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc"><ogc:PropertyIsLike 
matchCase="false" wildCard="*" singleChar="." 
escapeChar="!"><ogc:PropertyName>id</ogc:PropertyName><ogc:Literal>*13800073301968*</ogc:Literal></ogc:PropertyIsLike></ogc:Filter> 

Also this wfs support version= 1.1.0, you should do your request by 
specifying this version 

cesare gerbino <cesaregerbino at gmail.com>@lists.osgeo.org 
Envoyé par : mapserver-users-bounces at lists.osgeo.org 
2015-05-12 15:33 

A
mapserver-users at lists.osgeo.org 
cc

Objet
[mapserver-users] How to use filter encoding in MapServer in a WFS       
 query?

Hi all! 

I need to query this WFS public service  

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&service=wfs&request=getCapabilities 

The layer I need to query is this one 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&service=wfs&version=1.0.0&request=DescribeFeatureType 

It's a layer with a very big number of point features. 

The OGC service is done using MapServer but I don't know the version. 

I need to query this layer in a no spatial way: the simplest query I need 
to do is something like this one 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=
<Filter><PropertyIsEqualTo><PropertyName>id</PropertyName><Literal>13800000050414</Literal></PropertyIsEqualTo></Filter> 

My final query would like to combine several clauses using the AND logical 
operator. 

Unfortunately at the moment the simplest query above doesn't work: if you 
try it in the response ther will be something like  

HINT: No operator matches the given name and argument type(s). You might 
need to add explicit type casts 

I've done several attempts to change it and I've tried other queries: for 
example 

1) this one ... 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3Cogc:Filter%3E%3Cogc:PropertyIsEqualTo%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E%2713800000050414%27%3C/ogc:Literal%3E%3C/ogc:PropertyIsEqualTo%3E%3C/ogc:Filter%3E 

returns  

    <gml:boundedBy><gml:null>missing</gml:null></gml:boundedBy> 

so I think that in this case the sintax could be right but I'm not sure 
and I don0't understand because the response is null  

2) trying to do a spatial query like this one ... 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3CFilter%3E%3CBBOX%3E%3CPropertyName%3EName%3ENAME%3C/PropertyName%3E%3CBox%20srsName=%27EPSG:4326%27%3E%3Ccoordinates%3E7.626630,45.029061%207.673107,45.052713%3C/coordinates%3E%3C/Box%3E%3C/BBOX%3E%3C/Filter%3E 

returns a right response. 

I've found on the web that probably there is a workaround ... 

http://osgeo-org.1560.x6.nabble.com/WFS-filter-creates-a-query-using-a-number-instead-of-text-td5130361.html#a5190402 

that suggest to use the PropertyIsLike operator instead of the 
PropertyIsEqual. I've tried to use it but it doesn't work in my case ...  

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.map&VERSION=1.0.0&service=wfs&request=GetFeature&TYPENAME=IN.NUMERICIVICI.2012&Filter=%3Cogc:Filter%3E%3Cogc:PropertyIsLike%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E%2713800000050414%27%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E 

in this case after a long time it seems that the service goes in time out 
and no data is returned ....  

Now I am completely blocked .... :-( 

Any suggestions / workaround?  

Thank you very much in advance ... 

Cesare 

Cesare Gerbino

http://cesaregerbino.wordpress.com/
http://www.facebook.com/cesare.gerbino
http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl

https://twitter.com/CesareGerbino
http://www.linkedin.com/pub/cesare-gerbino/56/494/77b 

Questo è un account di posta personale di Cesare Gerbino: tutte le 
opinioni espresse sono personali e non riflettono necessariamente quelle 
del mio datore di lavoro 

This is Cesare Gerbino mail account. Text is written by Cesare Gerbino: 
 the views expressed  are mine and not necessarily those of my employer. 
.
_______________________________________________
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/20150512/b60dd742/attachment-0001.html>