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
42
questions
1
vote
1
answer
15
views
How to achieve statistical queries similar to ArcGIS map services based on CQL queries of GeoServer's WMS service?
In ArcGIS MapServer, through the layer's query interface, it is possible to achieve statistics such as the maximum, minimum, or average of a layer based on a specific category field and a statistic ...
- 47
0
votes
1
answer
23
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 ...
0
votes
0
answers
142
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 ...
- 121
1
vote
1
answer
384
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 ...
- 13
0
votes
0
answers
101
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 ...
0
votes
1
answer
392
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 ...
- 1,577
0
votes
1
answer
202
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) ...
- 143
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 ...
- 11
-1
votes
1
answer
662
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&...
- 61
2
votes
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 ...
- 201
1
vote
1
answer
715
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 ...
0
votes
1
answer
1k
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 ...
4
votes
2
answers
785
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 ...
- 395
0
votes
1
answer
94
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 ...
0
votes
1
answer
937
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. ...
- 175
1
vote
1
answer
99
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 ...
- 645
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 ...
- 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=...
- 179
2
votes
1
answer
131
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 ...
- 163
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=...
- 1,409
1
vote
0
answers
96
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 ...
- 1,577
3
votes
1
answer
410
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 ...
- 339
1
vote
0
answers
298
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). ...
- 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,...
- 193
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:
&...
- 21.2k
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=...
- 193
0
votes
1
answer
712
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 ...
- 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 ...
- 18.9k
1
vote
0
answers
265
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 ...
- 2,674
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 ...
- 513
1
vote
0
answers
442
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 ...
- 11
1
vote
1
answer
236
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....
- 123
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.
...
- 855
1
vote
1
answer
924
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&...
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 ...
- 463
2
votes
1
answer
54
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....
- 237
1
vote
2
answers
1k
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 ...
- 21
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 &...
- 1,033
1
vote
0
answers
245
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
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 ...
- 2,674
1
vote
0
answers
144
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 ...
- 2,674
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 ...
- 84.3k