[Geoserver-users] CQL wildcards & filtering WMS GetFeatureInfo

Josh_Marcus · July 21, 2008, 5:42pm

Hey folks,

I have two separate questions, related to my goal of presenting a map with a filter and then obtaining information about features through WMS’s GetFeatureInfo.

#1 – Does Geoserver support wildcards in CQL? For example, if I’m using the topp:states openlayers map preview, I can’t get a query like:

STATE_NAME=“Ut*”

to work, even though * and ? are in the CQL specification.

#2 – I am trying to generate a map using a filter, and then use WMS’s GetFeatureInfo to get information about features. I don’t want features to be included that were excluded by the filter.

2a) Will GetFeatureInfo respect SLDs, in particular the filter in an external SLD? I’ve tried this but it doesn’t seem to work.
2b) GetFeatureInfo seems to be crashing when I try to use an OGC Filter.

For example, if I use the topp:states open layers preview/demo, and enter:

STATE_NAMEUtah

or

STATE_NAMEUtah

for an OGC filter, and then click Utah (the only visible state),

I get …

org.geoserver.platform.ServiceException: org.xml.sax.SAXParseException: XML document structures must start and end within the same entity. org.xml.sax.SAXParseException: XML document structures must start and end within the same entity. XML document structures must start and end within the same entity.

–j

Josh_Marcus · July 21, 2008, 6:54pm

After looking at the geotools source, I’ve figured out that the CQL syntax in geotools for wildcard searches is SQL-like: ATTRIBUTE LIKE ‘%foo’. But I’m still curious about my second question.

Thanks,
–j

On Mon, Jul 21, 2008 at 1:42 PM, Josh Marcus <jmarcus@anonymised.com> wrote:

Hey folks,

I have two separate questions, related to my goal of presenting a map with a filter and then obtaining information about features through WMS’s GetFeatureInfo.

#1 – Does Geoserver support wildcards in CQL? For example, if I’m using the topp:states openlayers map preview, I can’t get a query like:

STATE_NAME=“Ut*”

to work, even though * and ? are in the CQL specification.

#2 – I am trying to generate a map using a filter, and then use WMS’s GetFeatureInfo to get information about features. I don’t want features to be included that were excluded by the filter.

2a) Will GetFeatureInfo respect SLDs, in particular the filter in an external SLD? I’ve tried this but it doesn’t seem to work.
2b) GetFeatureInfo seems to be crashing when I try to use an OGC Filter.

For example, if I use the topp:states open layers preview/demo, and enter:

STATE_NAMEUtah

or

STATE_NAMEUtah

for an OGC filter, and then click Utah (the only visible state),

I get …

org.geoserver.platform.ServiceException: org.xml.sax.SAXParseException: XML document structures must start and end within the same entity. org.xml.sax.SAXParseException: XML document structures must start and end within the same entity. XML document structures must start and end within the same entity.

–j

Daniel_Gorni1 · July 22, 2008, 11:14pm

Hi all,

My name is Daniel, from Brazil. We are using GeoServer 1.6.2 and OpenLayers. We build a mosaic with 142 images and a SHP contructed from these 142 images.

I would like just to know how to put blank in the backgournd of this mosaic. I have read the SLD docs from OGC (Styled Layer Descriptor Implementation Specification - OGC 02-070) but I can´t find how to do it. If I change the opacity, all images change too, and I don´t want to do this. I would like to put opacity 0.0 just in background of my mosaic.

Could anyone help me please?

Thanks in advance.

Regards,

Daniel

My SLD:

<?xml version="1.0" encoding="UTF-8"?>

raster_layer

raster
A boring default style
A sample style for rasters

Feature

1.0

Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.

Arne_Kepp · July 22, 2008, 11:20pm

Assuming you mean PNG og GIF output through WMS, append transparent=true to the URL.

In OpenLayers this is an option you pass to the constructor of the WMSLayer.

-Arne

Daniel Gorni wrote:

Hi all,

My name is Daniel, from Brazil. We are using GeoServer 1.6.2 and OpenLayers. We build a mosaic with 142 images and a SHP contructed from these 142 images.

I would like just to know how to put blank in the backgournd of this mosaic. I have read the SLD docs from OGC (Styled Layer Descriptor Implementation Specification - OGC 02-070) but I can´t find how to do it. If I change the opacity, all images change too, and I don´t want to do this. I would like to put opacity 0.0 just in background of my mosaic.

Could anyone help me please?

Thanks in advance.

Regards,

Daniel

My SLD:

<?xml version="1.0" encoding="UTF-8"?>
<StyledLayerDescriptor xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/sld
http://schemas.opengis.net/sld/1.0.0/StyledLayerDescriptor.xsd" version="1.0.0">
<UserLayer>
  <Name>raster_layer</Name>
        <LayerFeatureConstraints>
            <FeatureTypeConstraint/>
        </LayerFeatureConstraints>
  <UserStyle>
    <Name>raster</Name>
    <Title>A boring default style</Title>
    <Abstract>A sample style for rasters</Abstract>

    <FeatureTypeStyle>
          <FeatureTypeName>Feature</FeatureTypeName>
      <Rule>
        <RasterSymbolizer>
        <Opacity>1.0</Opacity>
            <OverlapBehavior>
               <AVERAGE/>
            </OverlapBehavior>
            <ShadedRelief/>
        </RasterSymbolizer>
      </Rule>
    </FeatureTypeStyle>
  </UserStyle>
</UserLayer>
</StyledLayerDescriptor>

------------------------------------------------------------------------
Novos endereços, o Yahoo! que você conhece. Crie um email novo <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.new.mail.yahoo.com/addresses> com a sua cara @ymail.com ou @rocketmail.com. !DSPAM:4038,48866a36201246491211187!
------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

!DSPAM:4038,48866a36201246491211187!
  ------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4038,48866a36201246491211187!

Andrea_Aime3 · July 28, 2008, 9:31am

Josh Marcus ha scritto:

#1 -- Does Geoserver support wildcards in CQL? For example, if I'm using the topp:states openlayers map preview, I can't get a query like:

STATE_NAME="Ut*"

to work, even though * and ? are in the CQL specification.

Mumble, interesting, I thought the parser was completely CQL compliant.
Mauricio, cc'ed, is the developer of the CQL parser. Mauricio, can you
shed some light on this mystery?

2a) Will GetFeatureInfo respect SLDs, in particular the filter in an external SLD? I've tried this but it doesn't seem to work.

Nope, it won't. We have a Jira issue open to track this:
http://jira.codehaus.org/browse/GEOS-1008
but there has been no push to actually solve it since the full solution
(one that takes into account the symbolizer size and not only the filters) is not trivial to implement.

2b) GetFeatureInfo seems to be crashing when I try to use an OGC Filter.

Hum... which version of GeoServer are you using and what error message are you getting?
I've tried the following request (properly url-encoded):

http://localhost:8080/geoserver/wms?bbox=-130,24,-66,50&styles=population&Format=image/png&request=GetMap&layers=topp:states&width=550&height=250&srs=EPSG:4326&filter=<Filter><PropertyIsEqualTo><PropertyName>STATE_NAME</PropertyName><Literal>Utah</Literal></PropertyIsEqualTo></Filter>

and it works fine on both a GeoServer 1.6.2 and a GeoServer 1.7.0-beta1.

Let me know
Cheers
Andrea

Mauricio_Pazos · July 28, 2008, 10:20am

On Monday 28 July 2008 11:31:35 Andrea Aime wrote:

> #1 -- Does Geoserver support wildcards in CQL? For example, if I'm using
> the topp:states openlayers map preview, I can't get a query like:
>
> STATE_NAME="Ut*"
>
> to work, even though * and ? are in the CQL specification.

Mumble, interesting, I thought the parser was completely CQL compliant.
Mauricio, cc'ed, is the developer of the CQL parser. Mauricio, can you
shed some light on this mystery?

Yes I can. You should use the like sentence

STATE_NAME LIKE 'Ut*'

cheers
--

Mauricio Pazos
www.axios.es
Tel.: +34 94 682 42 86

Andrea_Aime3 · July 28, 2008, 11:03am

Mauricio Pazos ha scritto:

On Monday 28 July 2008 11:31:35 Andrea Aime wrote:

#1 -- Does Geoserver support wildcards in CQL? For example, if I'm using
the topp:states openlayers map preview, I can't get a query like:

STATE_NAME="Ut*"

to work, even though * and ? are in the CQL specification.

Mumble, interesting, I thought the parser was completely CQL compliant.
Mauricio, cc'ed, is the developer of the CQL parser. Mauricio, can you
shed some light on this mystery?

Yes I can. You should use the like sentence

STATE_NAME LIKE 'Ut*'

Yes yes, that I understand, what I'm wondering about is if
STATE_NAME='Ut*' is a valid CQL statement to be used as an alternative
to LIKE and if so, if there's a reason why we don't support that syntax.
The user seemed to expect that expression to act as a LIKE.

Cheers
Andrea

Mauricio_Pazos · July 28, 2008, 11:09am

On Monday 28 July 2008 12:20:44 Mauricio Pazos wrote:

Yes I can. You should use the like sentence
    STATE\_NAME LIKE &#39;Ut\*&#39;
cheers

Sorry, the statement sould be

STATE_NAME LIKE 'Ut%'

cheers
--

Mauricio Pazos
www.axios.es
Tel.: +34 94 682 42 86

Mauricio_Pazos · July 28, 2008, 12:59pm

On Monday 28 July 2008 13:03:53 Andrea Aime wrote:

Yes yes, that I understand, what I'm wondering about is if
STATE_NAME='Ut*' is a valid CQL statement to be used as an alternative
to LIKE and if so, if there's a reason why we don't support that syntax.
The user seemed to expect that expression to act as a LIKE.

Cheers
Andrea

the lexical analyser require different context to distinguish if that token is
an *string* or a *text pattern*. String and text patterns are similar:
quote , characters, .. quote. So, the way used by the parser to know what is
the rule to use is looking lthe prefix “=” or “like”.

cheers
--

Mauricio Pazos
www.axios.es
Tel.: +34 94 682 42 86

Greg_Toomey · November 3, 2008, 4:56am

Mauricio Pazos wrote:

On Monday 28 July 2008 13:03:53 Andrea Aime wrote:

Yes yes, that I understand, what I'm wondering about is if
STATE_NAME='Ut*' is a valid CQL statement to be used as an alternative
to LIKE and if so, if there's a reason why we don't support that syntax.
The user seemed to expect that expression to act as a LIKE.

Cheers
Andrea

the lexical analyser require different context to distinguish if that
token is
an *string* or a *text pattern*. String and text patterns are similar:
quote , characters, .. quote. So, the way used by the parser to know what
is
the rule to use is looking lthe prefix “=” or “like”.

cheers
--

Mauricio Pazos
www.axios.es
Tel.: +34 94 682 42 86

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

I am using GeoServer with google earth and can not get "like" to work. The
following are the network links I have tried. Can anyone tell me what is
wrong with these?
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference+like+'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference
like 'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference+LIKE+'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference
LIKE 'XCASD12%'
Also tried all of the above with an asterix(*) instead of percent (%) - no
luck

I am trying to show all records starting with the text "XCASD12".

All help appreciated...

--
View this message in context: http://www.nabble.com/CQL-wildcards---filtering-WMS-GetFeatureInfo-tp18573836p20297342.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Andrea_Aime3 · November 3, 2008, 8:14am

toomg ha scritto:
...

I am using GeoServer with google earth and can not get "like" to work. The
following are the network links I have tried. Can anyone tell me what is
wrong with these?
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference+like+'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference
like 'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference+LIKE+'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference
LIKE 'XCASD12%'
Also tried all of the above with an asterix(*) instead of percent (%) - no
luck

I am trying to show all records starting with the text "XCASD12".

Hum, I've tried getting all the states that do start with M out
of the topp:states demo map an it works using %
http://geo.openplans.org:8080/geoserver/wms?bbox=-127.61950064999999,23.7351786,-64.08177035,50.592523400000005&styles=&Format=image/png&request=GetMap&version=1.1.1&layers=topp:states&width=800&height=317&srs=EPSG:4326&CQL_FILTER=STATE_NAME%20LIKE%20'M%25'

It may be that your issue is not related to the CQL parsing per
se, but to how the like statement is executed. For example, with a
database backend that would be turned into a SQL statement.

Can you report which backed you're using, and if it's a database,
can you enable "geotools developer" logging level, issue the query
again, and look into the logs for the translated query?

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Mauricio_Pazos · November 3, 2008, 8:51am

On Monday 03 November 2008 06:26:40 toomg wrote:

I am using GeoServer with google earth and can not get "like" to work. The
following are the network links I have tried. Can anyone tell me what is
wrong with these?
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=appli
cation/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=
topp:NTWKS_FI_CA&cql_filter=reference+like+'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=appli
cation/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=
topp:NTWKS_FI_CA&cql_filter=reference like 'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=appli
cation/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=
topp:NTWKS_FI_CA&cql_filter=reference+LIKE+'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=appli
cation/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=
topp:NTWKS_FI_CA&cql_filter=reference LIKE 'XCASD12%'
Also tried all of the above with an asterix(*) instead of percent (%) - no
luck

I am trying to show all records starting with the text "XCASD12".

All help appreciated...

The % symbol is ok for LIKE predicate.

cheers
--
Mauricio Pazos
www.axios.es

Greg_Toomey · November 3, 2008, 11:04pm

Andrea Aime-4 wrote:

toomg ha scritto:
...

I am using GeoServer with google earth and can not get "like" to work.
The
following are the network links I have tried. Can anyone tell me what is
wrong with these?
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference+like+'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference
like 'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference+LIKE+'XCASD12%'
http://localhost:8080/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kmz+xml&width=1024&height=1024&srs=EPSG:4326&layers=topp:NTWKS_FI_CA&cql_filter=reference
LIKE 'XCASD12%'
Also tried all of the above with an asterix(*) instead of percent (%) -
no
luck

I am trying to show all records starting with the text "XCASD12".

Hum, I've tried getting all the states that do start with M out
of the topp:states demo map an it works using %
http://geo.openplans.org:8080/geoserver/wms?bbox=-127.61950064999999,23.7351786,-64.08177035,50.592523400000005&styles=&Format=image/png&request=GetMap&version=1.1.1&layers=topp:states&width=800&height=317&srs=EPSG:4326&CQL_FILTER=STATE_NAME%20LIKE%20'M%25'

It may be that your issue is not related to the CQL parsing per
se, but to how the like statement is executed. For example, with a
database backend that would be turned into a SQL statement.

Can you report which backed you're using, and if it's a database,
can you enable "geotools developer" logging level, issue the query
again, and look into the logs for the translated query?

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Thanks for the suggestion Andrea.

Below is a brief outline of the results:

--This is resulting query in the "geoserver.log" when I use an asterix (as
the wildcard) in the Google Earth network link
--I have then tried this SQL against postgis substituting a percent symbol
for the asterix and it returns results so nothing wrong with the SQL except
the asterix.
About to execute query: SELECT "oid", "numberoffibers",
encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM "public"."FI_CA"
WHERE ( ( "reference" LIKE 'XXCA12S*' ) AND ("the_geom" &&
GeometryFromText('POLYGON ((2774713.671998282 2353254.654006172,
2774713.671998282 2353676.782899789, 2775167.884092414 2353676.782899789,
2775167.884092414 2353254.654006172, 2774713.671998282 2353254.654006172))',
3107) AND (((("numberoffibers" BETWEEN 0 AND 71 OR "numberoffibers" = 72) OR
"numberoffibers" = 144) OR "numberoffibers" = 216) OR "numberoffibers"
BETWEEN 288 AND 5000)))

--However, if I put a percent symbol in the Google Earth network link this
is the resulting error in the "geoserver.log"
Caused by: org.geotools.filter.text.cql2.CQLException: Lexical error at line
1, column 114. Encountered: <EOF> after :
"\'XXCA12S?BBOX=60.5299853228588,-58.08312693226858,209.5251551562438,2.766203476221067",
Current Token : reference

--
View this message in context: http://www.nabble.com/CQL-wildcards---filtering-WMS-GetFeatureInfo-tp18573836p20312908.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Andrea_Aime3 · November 4, 2008, 9:11am

toomg ha scritto:
<snip>

Below is a brief outline of the results:

--This is resulting query in the "geoserver.log" when I use an asterix (as
the wildcard) in the Google Earth network link
--I have then tried this SQL against postgis substituting a percent symbol
for the asterix and it returns results so nothing wrong with the SQL except
the asterix.
About to execute query: SELECT "oid", "numberoffibers",
encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM "public"."FI_CA"
WHERE ( ( "reference" LIKE 'XXCA12S*' ) AND ("the_geom" &&
GeometryFromText('POLYGON ((2774713.671998282 2353254.654006172,
2774713.671998282 2353676.782899789, 2775167.884092414 2353676.782899789,
2775167.884092414 2353254.654006172, 2774713.671998282 2353254.654006172))',
3107) AND (((("numberoffibers" BETWEEN 0 AND 71 OR "numberoffibers" = 72) OR
"numberoffibers" = 144) OR "numberoffibers" = 216) OR "numberoffibers"
BETWEEN 288 AND 5000)))

--However, if I put a percent symbol in the Google Earth network link this
is the resulting error in the "geoserver.log"
Caused by: org.geotools.filter.text.cql2.CQLException: Lexical error at line
1, column 114. Encountered: <EOF> after :
"\'XXCA12S?BBOX=60.5299853228588,-58.08312693226858,209.5251551562438,2.766203476221067",
Current Token : reference

Hum, I just tried on a version of the sample STATES layer that I've
imported in postgis (and renamed pg_states). The following works just
fine for me:

http://localhost:8080/geoserver/wms?WIDTH=800&LAYERS=topp%3Apg_states&STYLES=&SRS=EPSG%3A4326&HEIGHT=317&FORMAT=image%2Fpng&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&BBOX=-145.48948800563758,17.49445739761009,-46.211783051490926,56.833247985690704&cql_filter=state_name+LIKE+'M%25'

and the resulting query executes fine as well:
SELECT "gid", "state_abbr", "persons", encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM "public"."states" WHERE ( ( "state_name" LIKE 'M%' ) AND "the_geom" && GeometryFromText('POLYGON ((-145.61358513683027 17.370360266417407, -145.61358513683027 56.95734511688339, -46.08768592029824 56.95734511688339, -46.08768592029824 17.370360266417407, -145.61358513683027 17.370360266417407))', 4326))

Soo... my guess is that you did not properly URL-encode the cql filter?
I made a similar mistake in my tests, usually Firefox does the url
encoding for me, but it did not for the % symbol. Yet, when I made
that mistake, the CQL parser complained about an invalid token, it
did not reach the databast at all.

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Greg_Toomey · November 4, 2008, 10:03pm

Andrea Aime-4 wrote:

toomg ha scritto:
<snip>

Below is a brief outline of the results:

--This is resulting query in the "geoserver.log" when I use an asterix
(as
the wildcard) in the Google Earth network link
--I have then tried this SQL against postgis substituting a percent
symbol
for the asterix and it returns results so nothing wrong with the SQL
except
the asterix.
About to execute query: SELECT "oid", "numberoffibers",
encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM
"public"."FI_CA"
WHERE ( ( "reference" LIKE 'XXCA12S*' ) AND ("the_geom" &&
GeometryFromText('POLYGON ((2774713.671998282 2353254.654006172,
2774713.671998282 2353676.782899789, 2775167.884092414 2353676.782899789,
2775167.884092414 2353254.654006172, 2774713.671998282
2353254.654006172))',
3107) AND (((("numberoffibers" BETWEEN 0 AND 71 OR "numberoffibers" = 72)
OR
"numberoffibers" = 144) OR "numberoffibers" = 216) OR "numberoffibers"
BETWEEN 288 AND 5000)))

--However, if I put a percent symbol in the Google Earth network link
this
is the resulting error in the "geoserver.log"
Caused by: org.geotools.filter.text.cql2.CQLException: Lexical error at
line
1, column 114. Encountered: <EOF> after :
"\'XXCA12S?BBOX=60.5299853228588,-58.08312693226858,209.5251551562438,2.766203476221067",
Current Token : reference

Hum, I just tried on a version of the sample STATES layer that I've
imported in postgis (and renamed pg_states). The following works just
fine for me:

http://localhost:8080/geoserver/wms?WIDTH=800&LAYERS=topp%3Apg_states&STYLES=&SRS=EPSG%3A4326&HEIGHT=317&FORMAT=image%2Fpng&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&BBOX=-145.48948800563758,17.49445739761009,-46.211783051490926,56.833247985690704&cql_filter=state_name+LIKE+'M%25'

and the resulting query executes fine as well:
SELECT "gid", "state_abbr", "persons",
encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM
"public"."states" WHERE ( ( "state_name" LIKE 'M%' ) AND "the_geom" &&
GeometryFromText('POLYGON ((-145.61358513683027 17.370360266417407,
-145.61358513683027 56.95734511688339, -46.08768592029824
56.95734511688339, -46.08768592029824 17.370360266417407,
-145.61358513683027 17.370360266417407))', 4326))

Soo... my guess is that you did not properly URL-encode the cql filter?
I made a similar mistake in my tests, usually Firefox does the url
encoding for me, but it did not for the % symbol. Yet, when I made
that mistake, the CQL parser complained about an invalid token, it
did not reach the databast at all.

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Andrea

Thanks - I used your suggested URL-encoding of the CQL filter and the "like"
now works fine.

--
View this message in context: http://www.nabble.com/CQL-wildcards---filtering-WMS-GetFeatureInfo-tp18573836p20332210.html
Sent from the GeoServer - User mailing list archive at Nabble.com.