To filter data using the Common Query Language

learn more… | top users | synonyms

2
votes
1answer
22 views

how to reset cql_filter of wms on ol3?

I can dynamically change the cql filter but in want to reset it to default (get wms without any filter ) class i am using "ol.source.TileWMS" as source from geoserver here is my code to which i ...
1
vote
1answer
29 views

Using nested geometric functions in ECQL queries in GeoServer

When doing a WFS Get Feature request, I am using the cql_filter option to do some more advanced spatial filtering/quering. I am looking for the centroids of the polygons in a database that intersect ...
1
vote
1answer
24 views

POST CQL filter (with large geometry) in HTTP body

The size of an URL is limited. Therefore I'm not able to request a WFS with a complex geometry. I read (Geoserver POST filter to WMS layer) that is possible to do in a WMS, but I didn't get it to work....
2
votes
1answer
65 views

Adding WMS layer with CQL filter

I would like to add to my leaflet's web map layer from my WMS service (Geoserver), but I need to use CQL filter in GetMap link: localhost/geoserver/my_location/wms?(...)&CQL_FILTER=[...] Is ...
1
vote
1answer
102 views

CQL filter not displaying in leaflet.js

I have a CQL filter that only displays a certain number of points, however when I try to apply the CQL to my existing leaflet map through the options for a layer nothing displays. No errors are thrown ...
2
votes
1answer
102 views

CQL_FILTER on multilayer request where only one layer needs filtered

I have an image mosaic timeseries layer called agdd as well as a shapefile layer called cb_2014_us_state_500k that displays us state boundaries. I can stack both layers with the following query: ...
0
votes
1answer
115 views

CQL_filter parameter on WMS layer doesn't work

I am trying to filter my WMS layer using CQL_filter parameter as: wms_layer = new OpenLayers.Layer.WMS( "Larisa","http://localhost/geoserver/gwc/service/wms", { layers: '...
0
votes
1answer
26 views

Does CQL requires bringing the data on the client?

I want to use ECQL in order to filter some data on my browser. I have a postgis table which will have around 300k of rows. Bringing this layer at once might make things a bit slow. I was wondering how ...
1
vote
1answer
201 views

Refresh of a customized WMS-Layer (with cql-filter) generates a new map instances on website

I've two simple problems, but I can't fix it by my own :o( My OL-map features a basemap and a cql-filtered WMS from my local geoserver (topp:states). The map is just shown, when i click the ...
1
vote
2answers
136 views

GeoServer: Creating CQL-filter which only filters dates for given weekday

I use a GeoServer which i query over Openlayers with WMS and CQL. I have a date field in my database which i want to filter with CQL. I want only have Dates which has the weekday monday. The Result ...
0
votes
1answer
119 views

WFS Version issue with DWITHIN CQL_FILTER in geoserver

If my WFS version is 1.0.0 as below service=WFS&request=GetFeature&version=1.0.0&typename=XXXX&outputFormat=json&srsname=EPSG:3857&cql_filter=DWITHIN(geometry,POINT(63....
0
votes
3answers
244 views

WMS GetMap Request with featureid CQL filter

I have WMS and WFS services available to me and am trying to do the following: I am trying to identify images(features) within a given BBOX using WFS, and then I want to retrieve the individual ...
0
votes
1answer
136 views

Using GeoServer WFS to GetFeature by Clicking on it on the map

Can someone point me to document of crafting a Geoserver WFS GetFeature request with CQL_Filters? I've already read the GeoServer CQL_Filter Geometric filter section I have a Geoserver WMS set up to ...
2
votes
1answer
168 views

Leaflet polygon (multi polygon) to CQL equivelent

I am using leaflet with geoserver. I want to set up a CQL filter to do an intersect but having an issue with getting the geometry from leaflet polygon to cql polygon. For instance, the feature has ...
0
votes
0answers
195 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 '%...
2
votes
0answers
131 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 ...
0
votes
0answers
61 views

Query PB Spectrum WMS with Openlayers3

I want to get tiles with CQL_FILTER on spectrum server. There are many examples on geo server but i cant find spectrum example. There is code block: WMSLayer = new ol.layer.Tile({ source: ...
0
votes
1answer
714 views

Ol3, dynamic CQL for WFS layer (GeoJSON) from Geoserver

My map in Openlayers (Ol3) contains a WFS layer with GeoJSON format from Geoserver. My intention is to use CQL filters that can be applied by the user through comboboxes next to the map. The CQL ...
1
vote
2answers
133 views

How to request paginated or filtered data from WFS 2.0?

I want to download a data set from a WFS 2.0 server via HTTP GET, with curl for instance. $ curl -X GET http://example.com/wfs/?service=WFS&request=GetFeature &version=2.0.0&typeNames=...
0
votes
1answer
91 views

How to find out if a WFS instance supports filtering via CQL?

I am considering using Common Query Language (CQL) to add filter parameter to a HTTP curl query which runs against a WFS server. I found out that GeoServer supports CQL via WFS. Can I tell from a ...
0
votes
0answers
79 views

Insensitive case query in Geotools to WFS

I'm trying to make an insensitive case query from Geotools to WFS (Web feature service) datasource,I used FilterFactory2 with the method like(Expression expr, String pattern, String wildcard, String ...
2
votes
1answer
250 views

Geoserver WMS Filtering: Clipping geometry against a polygon

My data set is a series of multilinestrings representing roads. During a WMS GetMap request, I want to specify a polygon and display only the portions of those roads that fall within the polygon. I am ...
0
votes
1answer
178 views

Remove CQL_Filter from Open Layer Map

I'm using Open Layer to show my map with some layers. I've a field where I can add some filters with CQL code. I can successfully add a new filter to my map, and only the right points appear in my map ...
0
votes
1answer
425 views

Geometry filtering in Openlayers 3

Is there anything like OpenLayers.Filter implemented yet in Openlayers 3? I'm trying to implement a DWITHIN filter using a ol.geom.Polygon and I am searching for API support, which I couldn't find.
2
votes
1answer
402 views

CQL_FILTER that joins two feature types in WFS

I want to join two feature types in my WFS in a union. How can I achieve this using CQL? E.g. http://localhost:8080/example/ows?service=wfs&version=2.0.0&request=GetFeature&srsName=epsg:...
2
votes
1answer
513 views

Geoserver 2.5.2 CQL BBOX filter

Trying to use CQL bounding-box filter, but get a strange result like this: loadFeatures({"type":"FeatureCollection","totalFeatures":15640,"features":[]}) It showing a total 15640 features in that ...
4
votes
2answers
268 views

How to run a temporal query on a CSW using GeoNetwork?

On my GeoNetwork 2.10.3 a CSW GetRecords request (CQL) for TempExtent_begin after a certain date returns all of my metadata records. It seems like the filter expression is simply ignored. http://...
2
votes
0answers
230 views

PyQGIS add WMS layer with CQL_FILTER

Dear PyQgis developers! I'd like to add a wms layer through my QGIS plugin with custom CQL_FILTER parameters. My problem is, that the CQL_FILTER parameters are not passed to the GeoServer (I can see ...
4
votes
1answer
2k views

query WMS in Openlayers3

In previous versions of OpenLayers, we could filter WMS services with CQL. However, I can't filter my WMS services using CQL or other. How do I do that in OpenLayers 3? var wmsLayer = new ol.layer....
1
vote
0answers
180 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", "...
0
votes
1answer
1k views

WFS request with CQL_Filter projection

I have a layer in Geoserver called bln_blocks. The layer is in EPSG:3857. I am doing the follwoing WFS request with a CQL Filter: var geoserverURL = geoserverURL + '/ows?'; var service = '...
0
votes
0answers
762 views

CQl Filter Don't work with WFS layer in Open Layers

I used a WFS layer from geoserver in open Layers it's shown on MAP but when I want to use a filter it doesn't work I don't know where the error this is the code : <script type="text/javascript">...
2
votes
0answers
104 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
1answer
497 views

OpenLayers pan to CQL filter result

I'm new to OpenLayers and looking for some help. I would like to filter my shapefile with CQL and display the result. (that's actually working :-) The Problem is that I don't know how to pan the map ...
2
votes
1answer
547 views

Case insensitive CQL-OpenLayers filter?

I have the following filter in OpenLayers 2.13 var filter_c = new OpenLayers.Filter.Comparison({ type: OpenLayers.Filter.Comparison.LIKE, property: 'p_name', value: '%'+...
0
votes
0answers
162 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 ...
0
votes
1answer
324 views

Openlayers CQL DWITHIN returns errors

I'm trying to use CQL but I guess I do it wrong because I get pink layer in return and error in geoserver : Binary geometry filter, but first expression is not a property name? (it's a class org....
0
votes
1answer
248 views

cql_filter for fid

when i run this code: http://****/geoserver/Kaski/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=Kaski:PIN&maxFeatures=50&outputFormat=json&cql_filter=(fid=97) i ...
2
votes
1answer
224 views

CQL filter causing slowness in Java \ Geoserver app

I have a Java application that includes an OpenLayers map with WMS tiles pulled from Geoserver. Geoserver and the Java app are looking at the same MySQL database. In the Java application I have a ...
1
vote
1answer
2k views

CQL_FILTER not liking '%' wildcards

I am setting up a query against a layer on my GeoServer instance. My query string can become quite complex, and some statements require using multiple '%' wildcards. For starter's here's an example: ...
1
vote
1answer
525 views

GeoServer , select feature , highlight it , and export it to PNG

Like any GIS Web application , You need to provide a facility to print a report with a part of map , and specially the position of a given ParcelID on the map with different zooms .. I have GeoServer ...
0
votes
1answer
722 views

OpenLayers CQL filter gets info about NOT VISIBLE features

I have a WMS layer and a control WMSGetFeatureInfo. If I apply a CQL Filter to the layer and I redraw it, the WMSGetFeatureInfo control continue querying also NOT VISIBLE features. Why in your opinion?...
0
votes
1answer
511 views

zoomToExtent (getDataExtend) combined CQL filter, does not work

I'm using openlayers 2.12 and geoserver 2.1.3. I created a search functionality for a vector layer that contains points/lines/polygons. I used CQL that dynamically gets data from a form. When I ...
1
vote
0answers
116 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 > ...
2
votes
1answer
365 views

MapFish print module with cql_filter params

Does anyone know how to pass cql_filter params into MapFish's Print module? I already tried this, but it does not work. It generates the PDF but I get this error "The byte array is not a recognized ...
0
votes
0answers
211 views

How to ask the Interpolate function with CQL in Geoserver?

I like to display my own picture on Geoserver. But I want to use the geoserver's dynamic feature to color my picture. As explain in the documentation, I tried the purposed solutions : create a ...
3
votes
2answers
1k views

Dynamic SLD styling based on min / max value in a PostGIS column

I have a PostGIS table that contains the GDP of countries together with their polygon boundaries. I am using GeoServer to display this data via OpenLayers. When styling the data, I want to avoid ...
1
vote
0answers
71 views

CQL Filter on WMS [duplicate]

I have CQL_Filter which filters WMS layer and displays only the points I asked for, The problem is that all features even the hidden, keep showing its popup when I click on their spot. So, as I ...
1
vote
1answer
67 views

geoserver returns incorrect number of points when cql used

I'm using Geoserver 2.2.4 to support WMS queries. All testing is done via the "Layer Preview" page. If I send a request with no CQL a map full of points is returned as expected. If I add a CQL ...
2
votes
1answer
524 views

Geoserver CQL Cross Layer Intersection Failing

I am having trouble forming a properly formatted CQL request using geoServer cross layer filer functions and was hoping others could assist. My request is as follows: http://localhost:8080/geoserver/...