Questions tagged [cql-filter]

To filter data using the Common Query Language

32 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
185 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 ...
2
votes
0answers
44 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....
2
votes
0answers
374 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-...
2
votes
0answers
499 views

Load Multiple WFS layers from array with OpenLayers

I have a layer on my Geoserver that contains a few dozen pipeline alignments in a single layer. My goal is to get those into the map frame as individual layers by iteratively calling WFS layers and ...
1
vote
0answers
32 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 ...
1
vote
0answers
127 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 ...
1
vote
0answers
683 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
425 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 ...
1
vote
0answers
336 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 ...
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&...
1
vote
0answers
182 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
331 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
0answers
94 views

OpenLayers 2 WMS CQL_Filter with diacritic

I´m using GeoServer where I can query WMS services to get image from a CQL Filter query. The URL for the service looks like: http://myserver/ows/LIMITS_ADM/wms?LAYERS=LIMADM_MUNICIPI&TRANSPARENT=...
1
vote
0answers
568 views

OpenLayers getfeatureinfo shows all features, even with CQL filter

I have a map with several CQL filters that a user can use in my website. When the user applies the CQL filter, I want them to be able to use getfeatureinfo which only shows features from the CQL ...
1
vote
0answers
738 views

How to replace accented characters in the CQL filter, using GeoServer?

I have GIS API based on OpenLayers and GeoServer. I want to perform an Ajax request in order to get all the features that have a given keyword. For example, I could use the CQL filter: name LIKE '%...
1
vote
0answers
372 views

GeoServer - Sometimes bounding box property is missing following CQL Filter - why?

Usually when I run a WFS GetFeature query on GeoServer and request JSON the results conform to this format: { "type":"FeatureCollection", "features": [..features here...], "crs":{"type":"EPSG", "...
1
vote
0answers
1k views

CQL filters don't work with WFS layer in OpenLayers

I used a WFS layer from GeoServer in OpenLayers it's shown on the map, but when I want to use a filter it doesn't work; I don't know where the error is. This is the code: <script type="text/...
1
vote
0answers
328 views

SLD styling based on Cql filter result

I am using Geoserver 2.4.4 with a PostGIS database. I have 2 layers configured, one of them represents some polygons. I am trying to put a label inside the polygon with the number of the features of ...
1
vote
0answers
145 views

Openlayers CQL.js compare attribute columns

I'm trying to use a CQL filter in OpenLayers in order to identify some polygons in which the value of one column is higher then the other. So, when I use the following cql filter production_2010 > ...
1
vote
0answers
1k views

WMS CQL Filter in GeoServer not working on adding to the layer

I draw in the init() function a WMS layer an add it to the map: var lyr_osm = {}; var map = {}; $(document).ready(function () { map = new OpenLayers.Map('map', { ...
1
vote
0answers
720 views

Using CQL_FILTER BBOX on WMS layer causes ORA exception window SRID does not match layer SRID

I'm trying to limit WMS layer to a specific BBOX. mainLayer.mergeNewParams({ 'CQL_FILTER' : "BBOX(geom, 6541844, 5577147, 6584851, 5620154)" }); Which gives following exception in geoserver's ...
0
votes
0answers
34 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 ...
0
votes
0answers
62 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
169 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 ...
0
votes
0answers
74 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=...
0
votes
0answers
188 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 ...
0
votes
1answer
228 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 | ...
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
0answers
959 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:...
0
votes
0answers
1k views

How to find legal WFS property name on GeoServer?

I am querying a GeoServer using a CQL filter and testing it via browser url. My filter appears to be correct per documentation: https://myserver/geoserver/ows?service=WFS&version=2.0.0&...
0
votes
0answers
204 views

How to optimize the WFS service's CQL and ECQL?

I am using wfs cql filters to get the attribute data but when the cql filter selects a large dataset say 1000+ point data the response time is large. How can I optimize cql filter ? The following ...
0
votes
0answers
301 views

Why CQL DWITHIN returns different result than PostGIS DWITHIN?

I have 2 tables in PostGIS that I publish to geoserver. both have same SRS (2039). When I do the following query in PostGIS , I get 69 results : SELECT a.gid,b.gid FROM Table_A a INNER JOIN ...