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
-1
votes
1answer
32 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&...
0
votes
0answers
22 views

WFS request (INTERSECTS POINT) to Geoserver returns 2 features - 1 correct polygon and 1 near polygon

I am using a Geoserver with SHP layers, that works fine in my project.I am trying to migrate layers to MySQL db, works fine for WMS requests. But when I try to send a point coordinates to find if it ...
0
votes
1answer
193 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 ...
1
vote
1answer
128 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
1answer
123 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
2answers
221 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 ...
0
votes
1answer
20 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
1answer
132 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
60 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 ...
3
votes
1answer
306 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
633 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
74 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
699 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
76 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
216 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
162 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
1k 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
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: &...
2
votes
2answers
1k 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
461 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
2k 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
184 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
1k 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
338 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
138 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....
2
votes
1answer
892 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
605 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&...
6
votes
4answers
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 ...
2
votes
1answer
31 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
612 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
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 &...
1
vote
0answers
179 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
793 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
115 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 ...