To filter data using the Common Query Language

learn more… | top users | synonyms

10
votes
1answer
722 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 ...
6
votes
2answers
2k views

OpenLayers filter: OGC (xml) or CQL?

While having not used filtering that much in OpenLayers, we are discussing which type of filtering we should use: The OGC XML filter or the more simple CQL filter? Are one of them more appropriate ...
6
votes
2answers
2k views

Can i do Custom Styling on Geoserver

i want to use Geoserver WMS server for custom styling. lets say i have an area as polygon in a shape file. But i dont have this area's temperature as an attribute. From a web service i gather ...
5
votes
3answers
8k views

How to get the layer name?

I am using OpenLayers, Geoserver 2.1 CQL language. The problem is that I do not know how to address the layer. I am trying to call a function like this: var createWmsLayer = function(name, url, ...
3
votes
1answer
2k views

Restrict CQL filter to an specific BBOX

I need to filter an OpenLayers layer using a CQL filter to an specific Bounding Box. Is it possible? Something like this isn't working: igh > 5000 AND ...
3
votes
2answers
121 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. ...
3
votes
1answer
205 views

Determing, whether WMS service supports CQL filtering

Is it possible to query, whether WMS service supports CQL filtering (like Geoserver does) or not? I didn't find any hints from GetCapabilities query result.
3
votes
1answer
641 views

Setting CQL_FILTER on WMS in ArcGIS?

Is it at all possible to use a CQL_FILTER on a WMS service in ArcGIS? Ideally we'd be able to programatically change the CQL_FILTER parameter in the WMS URL.
3
votes
2answers
1k views

Zoom after apply CQL_FILTER in OpenLayers

I apply a filter to one layer and works nice. I want to maximize the bounds where I applied the filter, like this: // mapbounds = array(minx,miny,maxx,maxy) activeLayer = new OpenLayers.Layer.WMS( ...
3
votes
2answers
710 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 ...
2
votes
1answer
198 views

Any source code for converting an infix filter to a WFS filter?

A WFS GetFeature query looks something like this: ...
2
votes
1answer
775 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 ...
2
votes
1answer
352 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: ...
2
votes
1answer
267 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 ...
2
votes
1answer
386 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: ...
2
votes
0answers
135 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
0answers
70 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 ...
2
votes
1answer
172 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 ...
2
votes
1answer
93 views

Error executing CQL on layer other then demo layers

I have some sort of wierd problem as I was playing with CQL. CQL works well with given layer but when i try with layer loaded from mapinfo or some views then it does not work. As in the picture when I ...
1
vote
1answer
1k 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
263 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 = ...
1
vote
1answer
633 views

Can I do Intersection queries in ECQL?

I am building a statistical analysis project using ASP.NET, Geoserver, and OpenLayers. I need to let the user draw a polygon on OpenLayers then find geometries(villages etc.) that intersects this ...
1
vote
2answers
34 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 ...
1
vote
1answer
1k views

How to use cql_filter in OpenLayers.Control.WMSGetFeatureInfo?

I am a newbie and I am using OpenLayers, GeoServer 2.1.3. I have a function that works to filter the markers on the map with a CQL_FILTER function. But when I click on a marker it shows a popup with ...
1
vote
1answer
81 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 ...
1
vote
1answer
238 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 ...
1
vote
1answer
361 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 ...
1
vote
1answer
367 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 ...
1
vote
1answer
109 views

Does linux suport “like '%c'” filter(cql_filter)

I can execute the following request: http://My.host:8080/geoserver/wfs?request=GetFeature&version=1.1.0&typeName=topp:states&cql_filter=STATE_NAME like 'California' But I can't execute ...
1
vote
1answer
467 views

How to get CQL_FILTER parameters from vector polygon

map projection is EPSG:900913, displayprojection for map EPSG:4326. vector layer is polygonLayer = new OpenLayers.Layer.Vector("Polygon Layer"); with draw polygoon option with following code I get ...
1
vote
1answer
392 views

CQL_TEXT in CSW doesn't work

I need to retrieve some data from CSW server running GeoNetwork. I'm using this query but it doesn't work: http://serverurl/geonetwork/srv/en/csw? REQUEST=GetRecords& SERVICE=CSW& ...
1
vote
1answer
124 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
0answers
92 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
62 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
62 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 ...
1
vote
1answer
128 views

interiorPoint or Intersects Filter

I have a set of x-coord and y-coord coordinates in separate columns in a PostGIS table. I also have a separate geometry column, named the_geom, of type Point. I've written an Intersects filter to ...
0
votes
1answer
148 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 ...
0
votes
1answer
1k views

CQL Filter in Geoserver very slow?

I am experimenting with CQL filtering in Geoserver. I have two layers, one (A) has 8000 features, the other one (B) has 3000 features or so. I would like to search of layer A for intersection with ...
0
votes
1answer
29 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
1answer
201 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.
0
votes
1answer
508 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
1answer
436 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 ...
0
votes
3answers
1k views

How to zoom map after CQL_Filter?

I have WMS map, after applying CQL filter to layer how can I zoom map to see filter result? UPDATE: Here is my code what I'm trying to do var layerArray = map.layers; var someLayer; for (var i = ...
0
votes
0answers
8 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
0answers
24 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 ...
0
votes
0answers
15 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 ...
0
votes
0answers
89 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
86 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
57 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
25 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: ...