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

Tue May 12 12:58:34 PDT 2015

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
> <cesaregerbino at gmail.com>>@lists.osgeo.org <http://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*
> <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*
> <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=*
> <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*
> <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*
> <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*
> <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*
> <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://cesaregerbino.wordpress.com/>
> *http://www.facebook.com/cesare.gerbino*
> <http://www.facebook.com/cesare.gerbino>
>
> *http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl*
> <http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl>
> *https://twitter.com/CesareGerbino* <https://twitter.com/CesareGerbino>
> *http://www.linkedin.com/pub/cesare-gerbino/56/494/77b*
> <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/1ceb5bdc/attachment.htm>