Questions tagged [cql]

In this context CQL implies OGC Common Query Language, a query language for catalog interfaces. It should not be used for questions related to the Cassandra Query Language

Filter by
Sorted by
Tagged with
0
votes
1answer
13 views

Optional parameters in PointSymbolizer href

I am trying to build a dynamic url for a PointSymbolizer: /api/icons?foo=${strUrlEncode("foo")}&bar=${strUrlEncode("bar")} The problem I am running into is that the strUrlEncode will return null ...
0
votes
1answer
38 views

Choosing which attributes to return with WFS?

I am trying to use this documentation: https://docs.geoserver.org/stable/en/user/services/wfs/reference.html#getfeature to figure out a way where I can limit the attributes returned by a wfs call. ...
1
vote
1answer
35 views

WFS filter on entire row?

With PostgreSQL I can query an entire row for a string: SELECT * FROM table_name WHERE table_name::text LIKE '%string%'; Is there an equivalent (CQL?) for a Geoserver WFS serving PostGIS data? I've ...
2
votes
0answers
117 views

WFS nearest feature by CQL Filter

At the moment I have a WFS with the following cql_filter: 'cql_filter: 'dwithin(bag:geometrie, point(lon lat), 100, meters)' The problem is that this filter does not sort the features from closest ...
2
votes
1answer
193 views

GeoServer CQL Filter IN and strToLowerCase

I am trying to query GeoServer with a CQL Filter using the IN clause. If I send a request like this I get data back. http://server.com/geoserver/server/wfs?service=wfs&version=1.0.0&request=...
2
votes
1answer
53 views

Adding filter functions in place of a literal expression in GeoTools?

I'm writing some code to use filter functions in geotools. (attName >= replacementFunc() AND title LIKE replacementFunc()) AND attName2 = replacementFunc() In the area that says LIKE I get a ...
1
vote
0answers
318 views

Cross layer Filtering in Geoserver still getting error Could not parse CQL filter list. Function not found. Parsing :

Im trying to apply cross filter to retrieve the layer1 (where des= land) interects with layer2 as follows http://localhost:2211/geoserver/wfs?service=WFS&version=1.0.0&outputFormat=...
1
vote
0answers
58 views

How to successfully call CQL in YSLD?

I am trying to create a web map using GeoServer, and doing styling via YSLD. According to YSLD documentation, I should be able to include CQL in order to do filtering. For a test, I am using ...
3
votes
1answer
125 views

Geoserver CQL + SQL Server Plugin - .Filter Statement

Does anyone know why GeoServer's SQL Server Plugin when making a WFS request with a spatial cql/ecql predicate ends up adding a SQL .Filter to the generated query in addition to the spatial predicate ...
1
vote
0answers
118 views

CQL query from PostGIS using GeoTools

I have a shapefile (points) loaded in PostGIS. What I want to do is execute an ECQL query using geotools filtering points within a certain radius (10 kilometers) from a specific point (user input). ...
1
vote
1answer
628 views

Trying to perform A WFS CQL_FILTER for multiple TYPENAMES with different GEOM name identifiers

Using a WFS service https://geo.onroerenderfgoed.be/geoserver/wfs I want to retrieve the features with a CQL INTERSECT query. I need to get results from 2 TYPENAME: vioe_geoportaal:vast_htp,...
2
votes
1answer
616 views

Is it possible to use SELECT DISTINCT in a GeoServer CQL_FILTER statement?

I'm running a query on a GeoServer WFS layer, using a CQL_FILTER. This results in duplicates, whereas I only want to see one instance of each matching result. The query I'm running is: &...
2
votes
2answers
542 views

WFS GetFeature request with CQL_FILTERS with SPATIAL OPERATORS does not retrieve correct results

I have a WFS service : https://services.ovam.be/geoserver/wfs?REQUEST=GetCapabilities&SERVICE=WFS Where I'm trying the following: http://services.ovam.be/geoserver/wfs?SERVICE=WFS&REQUEST=...
0
votes
1answer
309 views

OGC WFS CQL Filter XML

Does WFS (specifically we are using geoserver) allow for a 'CQL Filter' to be specified when making a XML request? All the examples that I'm finding are for KVP requests. I don't see why you ...
3
votes
3answers
1k views

Refreshing WMS based on updated CQL Filter in Leaflet

How do you update a WMS in a LeafletJS Map? Using a simple text box and submit button, as well as a variable to hold a CQL filter (SQL query text) I've been able to update the CQL filter value on the ...
1
vote
0answers
134 views

Not possible to print GeoServer layers with CQL filters

I use geoexplorer together with GeoServer and mapfish. I make a WMS request passing in it two layers with corresponding CQL filters. I make this request through Geoexplorer to GeoServer. This works ...
1
vote
1answer
387 views

How can I serve data from a single PostGIS view, via WMS/WFS, in a way that allows users in a GIS client to filter based on attributes?

I have a materialized VIEW in PostgreSQL/PostGIS that contains observations for thousands of species. I am currently serving this view as a single WMS/WFS layer using Geoserver, and this works fine ...
1
vote
0answers
191 views

Two CQL Filter not working on a layer

I have wms layers like: LAYERS=layer1,layer2&CQL_FILTER=(type=10);INCLUDE it works fine but when I add another filter with 'and' operator to layer 1 it does not show on map. I am adding second ...
1
vote
1answer
111 views

geotools filter CQLException: Encountered “t”

I am querying a simple feature type schema: r:Long:index=join,*g:Point:srid=4326,di:Integer:index=join,al:Float,s:Float,b:Float,an:Float,he:Float,ve:Float,t:Float,m:Boolean,i:Boolean,ts:Long;geomesa....
1
vote
1answer
561 views

How to convert int to string in CQL filter GeoServer?

I want to filter columns in GeoServer WMS layer using 'ilike'. I tried following cql query. "column_name" ilike 'string' It works for columns of datatype string, not working for integer columns. ...
1
vote
1answer
460 views

What is the difference between CQL_FILTER and FILTER?

In a CSW request what is the difference between the parameters CQL_FILTER and FILTER ? Examples: localhost:8080/geonetwork/srv/eng/csw?REQUEST=GetRecords&CONSTRAINT_LANGUAGE_VERSION=1.1.0&...
4
votes
4answers
594 views

Can any WFS server accept ECQL filter as a POST request parameter

I believe GeoServer requires that filters passed in a WFS POST request are in the OGC XML based format. If you make a GetFeature request to GeoServer using a GET request the filter can be CQL or ...
2
votes
1answer
24 views

Where do I find the variable name to use in a CQL statement

For example I have been following tutorials and see examples such as DISJOINT(the_geom, POLYGON((-90 40, -90 45, -60 45, -60 40, -90 40))) I have accessed some map data from sources such as data....
1
vote
2answers
411 views

Inconsistent CQL Filtering w/ Geoserver

I am trying to utilize Geoserver's geometric filters to show subsets of a large number of polygons, but am getting inconsistent results. I am testing CQL statements in the 'Edit Layer' page on ...
3
votes
1answer
2k views

geotools cql full syntax and examples [closed]

You know you can use CQL to create GeoTools Filter used when filtering FeatureCollection. GeoTools 16 user guide has made a quick tutorial and examples for CQL strings like the following ones: ATTR1 &...
1
vote
0answers
146 views

Dynamic Symbolizers w/ CQL not URL encoded

I am trying user Dynamic Symbolizers in my SLD: <?xml version="1.0" encoding="UTF-8"?> <StyledLayerDescriptor xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc" xmlns:...
1
vote
1answer
481 views

Single quotes break my CQL filter

I am building a function which creates the CQL filter on the fly based on selections from dropdown menus. Then I append the filter in the corresponding KML URL and download the KML file. It works ...
1
vote
0answers
58 views

Downloading shapefile from geoserver after applying CQL filter? [duplicate]

I have managed to download a zipped shapefile from geoserver but now I want to be able to download part of the layer in a shapefile. This is what I did in order to download the whole layer as ...
12
votes
2answers
4k views

How to filter big datasets in Geoserver WMS?

Is there a good way to filter datasets with approx 50,000 features in Geoserver? I'd have to select between 100 and 200 features based on ids. These ids are different from the FeatureIds. Couldn't ...