Questions tagged [cql-filter]
To filter data using the Common Query Language
138
questions
0
votes
0answers
30 views
GeoServer property desciptor is null did you request a property that does not exist - problem with raster in group
In GeoServer 2.9.1 I have thematic groups configured. Each group consists of a series of vector layers and each of them has at least one raster. In version 2.9.1 cql filter deals with them perfectly ...
1
vote
0answers
27 views
GeoServer: Cross layer filtering with current bbox
I have two layers "building" and "soil" on a French region and I have about 1 million land and 500,000 buildings. I am trying to filter on the WMS query to get the land with the ...
0
votes
0answers
48 views
WFS GetFeature with cql_filter=Intersects not working for cascaded layers
I have a cascaded (WFS store) layer in my GeoServer. I want to download the data of the layer in Excel format for a provided polygon. In a normal scenario I export the data as below:
https://my-...
0
votes
1answer
131 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
66 views
How to fix cql_filter problem with unicode characters in GeoServer 2.17.2?
I am using GeoServer 2.17.2 and OpenLayers v6.4.3, I can not get result when my cql_filter query is consist of unicode characters, I found out this issue can solve by add a code in tomcat server.xml, ...
1
vote
1answer
96 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 ...
1
vote
1answer
749 views
GeoServer - WMS CQL_FILTER id = 'XXX' works but id IN ('XXX') does not
I have a WMS that I need to filter with CQL_FILTER parameter using an array of srting IDs.
The layer is published from a PostGIS Table View which is declared like so:
create view mob.daily_origin_all
...
0
votes
0answers
64 views
Error getting GeoJSON data from GeoServer with CQL filter
I have a problem obtaining GeoJSON data from GeoServer with CQL filter.
When I do the normal query, I get some results, then it's OK ("totalFeatures":2081).
https://mygeoserver/ows?service=...
2
votes
2answers
133 views
How to use UNION ALL in GeoServer CQL Filter?
Basically I want to combine 2 cql filters of the same layer and output the result on my geoserver layer. It is similar to this SQl query (my case using PostgreSQL):
select * from table1 where val = 'a'...
1
vote
1answer
68 views
Geoserver cql filter, closing single quote in URL is not read
I got a very strange behavior when using CQL filter. Here's the URL result when using AJAX
http://localhost/geoserver/visualization/ows?service=WFS&version=1.1.0&request=GetFeature&...
2
votes
1answer
81 views
GeoServer CQL Filter doesnt work with Unicode
I'm using CQL filter to extract certain data from my GeoServer layer.
var source = new ol.source.Vector({
loader: function (extent, resolution, projection) {
var url = "http://...
1
vote
1answer
89 views
WMS - Multiple paramters in CQL_FILTER not working?
I'm doing a WMS request with 2 cql_filters. This is the resultant query:
?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&FORMAT=image%2Fpng&TRANSPARENT=true&LAYERS=...
1
vote
1answer
59 views
Get WMS service properties for cql filtering?
From a wms service I know its url and a layer name called: CATAST_Pol_Municipio
https://idena.navarra.es/ogc/wms
I need to apply a cql_filter on a GetMap request on that layer, filtering by ...
0
votes
0answers
181 views
Highlight the filtered Features using CQL_FILTER on map
I have a WMS service with multiple layers which I am consuming within a single source through Layers Param.
I need to filter features for few layers from the service. I am able to get the updated ...
2
votes
0answers
42 views
CQL filter not quite properly formatted
I am trying to use the following CQL filter in Geoserver for extracting all polygons (layer1) intersecting a line (layer2):
http://XXX.XX.X.XX:8080/geoserver/workspace/wfs?service=wfs&version=1.1....
0
votes
1answer
220 views
Specifying join on multiple datasets in a WFS URL request (CQL/Filter)?
I’m using a WFS and trying to join two/three datasets together in a URL query.
Two of the datasets are linked via an aspatial table in the middle like so:
| Table 1 | | Table 2 | ...
2
votes
1answer
358 views
Make POST request for WMS in Leaflet for big values of cql_filter
I am passing a spatial query such as CONTAINS(geom, POLYGON((// geometry))) in the cql_filter, but for big polygons GET request the allowed URI length is violated and hence my requests is getting HTTP ...
1
vote
0answers
123 views
Geomesa BBOX query provide result only for whole world BBOX
I am running command line query to get bounding box data. The geomesa query is returning result only if the bounding box is "BBOX(geom, -180, -90, 180, 90.0)". For any other parameter, it is returning ...
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 ...
2
votes
2answers
99 views
Geotools CQL to OGC filter
I'm trying to convert a CQL filter to OCG. I followed this example: https://blog.ianturton.com/geotools/code/ogc/2015/03/18/Generating-OGC-Filters.html
In line with org.geotools.xml.Configuration ...
1
vote
1answer
268 views
How to specify a polygon's coordinate reference system in a CQL_FILTER geometric filter?
The CQL tutorial page contains an example showing how a polygon can be used in a DISJOINT query:
DISJOINT(the_geom, POLYGON((-90 40, -90 45, -60 45, -60 40, -90 40))
What is the syntax for ...
1
vote
1answer
57 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 ...
0
votes
1answer
267 views
Geoserver cql_filter on wms json/vector requests
I'm trying to make a cql filtered wms request for a non image based format like geojson or mapbox vector but the filters aren't applying. If i change the format to image/png the filters behave as ...
1
vote
1answer
664 views
Geoserver CQL file queryCollection limit
I'm using GeoServer 2.9.0 and I need to get some result using CQL_FILTER, intersects between polygon and line String layer, cql query is as follow:
INTERSECTS(geom, collectGeometries(queryCollection('...
1
vote
1answer
182 views
Is it possible to take advantage of lowercase index on column using CQL filter on WFS?
I am querying a WFS housed in geoserver - the data itself lives in a postgresql database. I would like to run case insensitive queries against the WFS and see there is an option to specify ...
2
votes
0answers
359 views
GeoServer CQL cross layer filtering: querySingle/queryCollection for non-geometry attribute return
I have only been able to find examples where geometry attributes are returned from cross layer filtering functions, but the GeoServer documentation says:
A common use case is to extract a geometry-...
1
vote
1answer
694 views
Is it possible to do a CQL filtering on an array field in a Postgis DB
I have a Postgis (2.2.3 in PostgreSQL 9.5) database with a view that has aggregate array fields.
I can filter on these fields directly on the DB with
Select * from myschema."ViewWithArrays" v
where ...
2
votes
1answer
498 views
How to select features which overlap one geometry but are disjoint from another?
Given a point layer and a polygon layer (P1) in GeoServer, the following CQL Filter selects points which intersect the polygon P1:
CQL_FILTER = "Within(geom,POLYGON((P1_coordinates)))";
The ...
2
votes
1answer
568 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
880 views
GeoServer WMS service CQL filter query with Mapbox GL
Is there any way to query WMS tile layer for Mapbox GL?
map.addLayer({
'id': 'wms-test-layer',
'type': 'raster',
'source': {
'type': 'raster',
'tiles': [
'...
1
vote
2answers
229 views
How to override the memory limits in GeoServer cross layer filtering?
According to this document retrieving of minimum features and coordinates can be override by using QUERY_LAYER_MAX_FEATURES and
GEOMETRY_COLLECT_MAX_COORDINATES. This can be done using JVM system ...
1
vote
1answer
117 views
CQL to XML with string substitution using geotools?
I have some cql attr > PLACEHOLDER that I want to convert to valid XML using geotools. I have heard of terms like filter functions that can somehow replace the placeholder with a function, but not ...
1
vote
0answers
642 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=...
3
votes
1answer
208 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
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,...
1
vote
0answers
412 views
Why is DWITHIN filtering my data with native EPSG 4326 with meters instead of degrees?
Ok so I have a PostgreSQL Table, to which I added a PostGIS geometry column using:
SELECT AddGeometryColumn ('public','my_table','geom',4326,'POINT',2);
Followed by:
UPDATE public.my_table
SET geom ...
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
446 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 ...
0
votes
1answer
289 views
CQL Concatenation
I would like to use concatenation on a CQL filter being passed to Geoserver, if the filter I was trying to achieve were for Postgres it would look like this:
house_name||house_number||streetname ...
1
vote
0answers
332 views
Help with WFS Filter request
I'm trying to download all features from this WFS: capabilities, describefeaturetype
It's working fine with the most simple requests like: getfeatures
But now, I need >all< features in the ...
3
votes
2answers
646 views
cql_filter with strToUpperCase() fails with “Cannot do natural order without a primary key”
I'm trying to convert a query into uppercase in a GeoServer WFS request. According to the Filter Function reference this can be achieved using strToUpperCase().
This is working successfully on a ...
1
vote
0answers
1k views
CQL Filter for geoserver geojson service with fields with space
I have trouble with CQL filter in geojson.
The CQL filter that I want:
"Sector Catastral" = 'VERONA'
The URL that compose for this purpose:
http://localhost:3000/geoserver/SIGUD/ows?service=WFS&...
2
votes
1answer
1k views
How to use CQL to return a geometry type?
I would like to use CQL in a URL call to return only a particular geometric type from a WFS that broadcasts multiple geometries. I have been going over this:
http://docs.geoserver.org/latest/en/user/...
0
votes
0answers
936 views
How to use CQL_FILTER as URL encoded parameter to compare a field containing numbers
I want to apply the CQL_FILTER parameter as an URL parameter in order to filter a field containing numbers (zip codes) starting with 79 (using 79% Wildcard) for instance.
So I'm using this CQL_FILTER:...
3
votes
0answers
177 views
Geoserver: how to filter a layer related to another layer?
I have the following problem:
I have 2 vector layers from PostGIS datastores: "firepoints" and "threats". The corresponding tables "firepoints" and "threats" have IDs and other attributes. They are ...
1
vote
0answers
178 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
0answers
317 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
137 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
866 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.
...
