To filter data using the Common Query Language

learn more… | top users | synonyms

2
votes
1answer
13 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
21 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
19 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
15 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
59 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
44 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
37 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
18 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 ...
1
vote
1answer
101 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
102 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
88 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
65 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
27 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
221 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.
1
vote
1answer
143 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
253 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
143 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
138 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
827 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
195 views

Filtering 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
63 views

Openlayers map changelayer event firing twice for params

I have registered changelayer event of my map. var registerEvents = function () { map.events.register("changelayer", null, onMapLayerChanged, true); }; var onMapLayerChanged = ...
0
votes
0answers
123 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
544 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
532 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
74 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
375 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
369 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
95 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
188 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
166 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
175 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
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
378 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
536 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
444 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
96 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
276 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
147 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
741 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
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 ...
2
votes
1answer
394 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
688 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
268 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
729 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 ...
3
votes
1answer
208 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.
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 ...
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
657 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
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 ...