To filter data using the Common Query Language

learn more… | top users | synonyms

0
votes
1answer
24 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
18 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
51 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
58 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
55 views

WFS Version issue with DWITHIN CQL_FILTER in geoserver

If my WFS version is 1.0.0 as below ...
0
votes
1answer
146 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
70 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
88 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
107 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
82 views

Load Multiple WFS layers from array with OpenLayers

looking for some help here. 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 ...
0
votes
0answers
43 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
353 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
84 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 ...
0
votes
1answer
68 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
52 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
185 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
0answers
140 views

Making CQL filter to work for all the overlays layer

In my application I am using multiple layer as overlays and want to use CQL filter to work for all of them. Can CQL filter be applied to base layer as well as more than one overlays layer? If yes, ...
0
votes
0answers
142 views

OpenLayers 3 source - validate CQL_FILTER

I have this code: wmsSource = new ol.source.TileWMS({ url: 'http://localhost:8080/geoserver/blah/wms', ... }) function applyCQL(cql) { if (cql){ var params = {CQL_FILTER: cql}; ...
0
votes
1answer
117 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
0answers
44 views

gxp WMS Filter View

I was trying to activate the WMSFilterView gxp plugin in opengeo SDK myviewer, but I couldn't make it work. I added the plugin to the dependencies and this is my code: { ptype: ...
0
votes
1answer
323 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
272 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. ...
1
vote
1answer
395 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 ...
3
votes
2answers
200 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. ...
2
votes
0answers
189 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 ...
2
votes
1answer
1k 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 ...
0
votes
0answers
160 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
780 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
660 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 ...
2
votes
0answers
90 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
447 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
444 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
130 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
247 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 ...
0
votes
1answer
216 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
202 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
455 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
631 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 ...
0
votes
1answer
476 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
103 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
310 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
181 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
885 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
66 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
66 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
472 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: ...
0
votes
0answers
772 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
1answer
298 views

How to use CQL_FILTER for the highest value in a layer field?

I need to query/filter my wms in openlayers to only see the polygons classified with the highest values in a given field. Would be something like: wms_layer.mergeNewParams({'CQL_FILTER': "ND = ...
10
votes
1answer
802 views

Disappearing Point Features in Geoserver using WMS

I have a shapefile with roughly 6,500 points worldwide in it that I am trying to serve with Geoserver 2.2.1 using WMS. All has been apparently fine with it until I implemented a filtering feature on ...