As I mentioned in my previous email, I got the SLD with ECQL filter working on
ESRI shapefiles (both the TIGER poly_landmarks that comes with GeoServer and an
ESRI shapefile I created through ogr2ogr from my PostGIS table).
However, having added the poly_landmarks.shp to my PostGIS database through
ogr2ogr, the same SLD with ECQL filter I used for the poly_landmarks.shp does
NOT work on the PostGIS table.
- client_encoding of the PostGIS database is utf8
- postgis_full_version: POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel.
4.7.1, 23 September 2009" LIBXML="2.7.6" USE_STATS
HTH
Edward
> Date: Thu, 10 Feb 2011 15:42:45 +0100
> Subject: Re: [Geoserver-users] How to filter road numbers in SLD using
> [SEC=Unclassified] propertyislike? [SEC=Unclassified]
> From: [email protected]
> To: [email protected]
> CC: [email protected]
>
> On Thu, Feb 10, 2011 at 3:06 PM, Edward Mac Gillavry
> <[email protected]> wrote:
> > Updated to Geoserver 2.1 beta1! Pardon my ignorance, but how would I
> > reformulate the ECQL filter strMatches(CFCC, 'D\d+') = true in an SLD? What
> > to put between <ogc:Filter> ... </ogc:Filter>?
>
> See my previous mail, it has an example:
>
> <ogc:Filter>
> <ogc:PropertyIsEqualTo>
> <ogc:Function name="strMatches">
> <ogc:PropertyName>CFCC</ogc:PropertyName>
> <ogc:Literal>D\d+</ogc:Literal>
> </ogc:Function>
> <ogc:Literal>true</ogc:Literal>
> </ogc:PropertyIsEqualTo>
> </ogc:Filter>
>
> Cheers
> Andrea
>
>
> --
> -------------------------------------------------------
> Ing. Andrea Aime
> GeoSolutions S.A.S.
> Tech lead
>
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
>
> phone: +39 0584 962313
> fax: +39 0584 962313
> mob: +39 333 8128928
>
> http://www.geo-solutions.it
> http://geo-solutions.blogspot.com/
> http://www.youtube.com/user/GeoSolutionsIT
> http://www.linkedin.com/in/andreaaime
> http://twitter.com/geowolf
>
> -------------------------------------------------------
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
