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
1 answer
58 views

How to add CQL_FILTER to WMTS layer on GeoServer?

I have a wmts layer on GeoServer and I tried to add some CQL_FILTER to my request but it's not working. Whatever I added to uri, geoserver always return result but in some cases it shouldn't. Here's ...
user avatar
  • 11
-1 votes
1 answer
154 views

WFS with CQL_FILTER=BBOX return empty layer

This is the first time I using WFS. I'm trying to get features with this WFS request inside a BBOX: uri=https://wxs.ign.fr/choisirgeoportail/geoportail/wfs?service=WFS&srsName=EPSG:4326&...
user avatar
1 vote
1 answer
527 views

Add a CQL Filter to a WMS Layer in QGIS

I have a WMS Layer published by a geoserver instance. It has the capability of being filtered by a CQL Filter via GetMap CQL_FILTER query parameter. Adding it to QGIS works, but I can't find a place ...
user avatar
  • 191
1 vote
1 answer
330 views

GeoServer Raster WMS Layer update/filter like CQL, ECQL

I have added the raster layer from GeoServer as a WMS source. There is an HTML filter to apply changes with GeoServer Raster WMS Layer, which is not working with RasterSymbolizer, and CQL filter. Like ...
user avatar
0 votes
1 answer
307 views

Geoserver CQL filter with many “IN” conditions

I am using Geoserver to generate colored regions on a map a wms link, CQL condition can contain a long string of "IN". Max number of INs could be up to 1-2 thousands. I tried to divide it ...
user avatar
4 votes
2 answers
390 views

How do I retrieve a single image from an ImageMosaic in GeoServer?

If I have an ImageMosaic in GeoServer containing several raster images that overlap, is there a way to retrieve/display one of the original images? Could I use CQL or WCS to get them by fileName or ...
user avatar
  • 365
0 votes
1 answer
27 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 ...
user avatar
0 votes
1 answer
271 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. ...
user avatar
  • 165
1 vote
1 answer
67 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 ...
user avatar
4 votes
1 answer
529 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 ...
user avatar
  • 41
2 votes
1 answer
916 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=...
user avatar
  • 169
2 votes
1 answer
93 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 ...
user avatar
1 vote
0 answers
964 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=...
user avatar
1 vote
0 answers
79 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 ...
user avatar
  • 1,325
3 votes
1 answer
253 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 ...
user avatar
  • 329
1 vote
0 answers
192 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). ...
user avatar
  • 21
1 vote
1 answer
2k 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,...
user avatar
2 votes
1 answer
1k 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: &...
user avatar
  • 20.5k
2 votes
2 answers
2k 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=...
user avatar
0 votes
1 answer
521 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 ...
user avatar
  • 103
3 votes
3 answers
3k 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 ...
user avatar
1 vote
0 answers
199 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 ...
user avatar
  • 2,514
1 vote
1 answer
2k 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 ...
user avatar
1 vote
0 answers
377 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 ...
user avatar
  • 11
1 vote
1 answer
144 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....
user avatar
2 votes
1 answer
1k 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. ...
user avatar
1 vote
1 answer
669 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&...
user avatar
7 votes
4 answers
1k 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 ...
user avatar
2 votes
1 answer
38 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....
user avatar
  • 227
1 vote
2 answers
719 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 ...
user avatar
4 votes
1 answer
3k 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 &...
user avatar
  • 1,023
1 vote
0 answers
191 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:...
user avatar
1 vote
1 answer
898 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 ...
user avatar
  • 2,514
1 vote
0 answers
143 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 ...
user avatar
  • 2,514
12 votes
2 answers
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 ...
user avatar
  • 81.9k