Skip to main content

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
15 views

How to set CQL_FILTER and recalculate layer boundary values through interface calls

Scenario description: GIS data volume is tens of millions and requires the creation of multi-dimensional layers, using WTMS's tile cache for rendering Using the CQL_FILTER condition to filter data ...
user24214434's user avatar
0 votes
0 answers
112 views

Adding marker at dynamic location on WMS map with GeoServer

I need to generate a static map image with a marker at coordinates specified in the WMS request URL. I have a GeoServer instance which provides the WMS layer, and I am able to get static map images ...
stalemate's user avatar
  • 121
1 vote
1 answer
321 views

POLYGON CQL Filter throws error - "NoSuchMethodError" on GeoServer

All spatial query requests perform well on GeoServer 2.19 using CQL filters. But for some reason, I'm getting an internal error with the following POLYGON CQL filter. Hence, the same CQL filter works ...
Ardour's user avatar
  • 13
0 votes
0 answers
96 views

Label polygons with count of intersecting points in GeoServer

I have two spatial layers in a GeoServer instance - polygons (administrative boundaries) and points (resource locations) - and would like to define a layer style (ideally using the CSS format) which ...
mdmeadows's user avatar
0 votes
1 answer
351 views

How to properly craft a LineString CQL for WFS GET filter?

A helper class I'm working on has to make an occasional requests to a GeoServer. These can be GET calls and I'd prefer them to be. These are filtered with CQL. Here is an example, which is returning ...
auslander's user avatar
  • 1,527
0 votes
1 answer
177 views

How to parameterize the PointSymbolizer in a SLD Style?

I am trying to clean my GeoServer deleting some redundant SLD Styles. All this styles work in the same way, they assign some image (different for every style, which name is hardcoded in every style) ...
Federico Matonte's user avatar
0 votes
1 answer
1k 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 ...
Burak's user avatar
  • 11
-1 votes
1 answer
604 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&...
Lalikinelo's user avatar
1 vote
1 answer
2k 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 ...
dve's user avatar
  • 191
1 vote
1 answer
678 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 ...
Muhammad Imran Siddique's user avatar
0 votes
1 answer
970 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 ...
Andrey R1CF's user avatar
4 votes
2 answers
735 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 ...
A. Mort's user avatar
  • 395
0 votes
1 answer
87 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 ...
lostintranslation's user avatar
0 votes
1 answer
857 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. ...
boshek's user avatar
  • 175
1 vote
1 answer
97 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 ...
minisaurus's user avatar
4 votes
1 answer
1k 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 ...
Seki's user avatar
  • 41
2 votes
1 answer
2k 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=...
mkeller's user avatar
  • 179
2 votes
1 answer
130 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 ...
John Lippson's user avatar
1 vote
0 answers
2k 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=...
Satya Chandra's user avatar
1 vote
0 answers
95 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 ...
auslander's user avatar
  • 1,527
3 votes
1 answer
385 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 ...
mikeo's user avatar
  • 339
1 vote
0 answers
287 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). ...
Rey's user avatar
  • 21
1 vote
1 answer
3k 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,...
daan.desmedt's user avatar
2 votes
1 answer
2k 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: &...
Stephen Lead's user avatar
  • 21.1k
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=...
daan.desmedt's user avatar
0 votes
1 answer
694 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 ...
Mrc0113's 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 ...
DPSSpatial_BoycottingGISSE's user avatar
1 vote
0 answers
258 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 ...
user1919's user avatar
  • 2,654
1 vote
1 answer
3k 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 ...
M. Andersen's user avatar
1 vote
0 answers
441 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 ...
Furkan's user avatar
  • 11
1 vote
1 answer
221 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....
Suresh Prajapati's 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. ...
S. Thiyaku's user avatar
1 vote
1 answer
903 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&...
yeaaaahhhh..hamf hamf's user avatar
7 votes
4 answers
2k 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 ...
Paul Wittle's user avatar
2 votes
1 answer
53 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....
Ryan's user avatar
  • 237
1 vote
2 answers
999 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 ...
Kent Walters's user avatar
5 votes
1 answer
4k 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 &...
Dariush's user avatar
  • 1,033
1 vote
0 answers
242 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:...
lostintranslation's user avatar
1 vote
1 answer
1k 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 ...
user1919's user avatar
  • 2,654
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 ...
user1919's user avatar
  • 2,654
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 ...
underdark's user avatar
  • 84.2k