To filter data using the Common Query Language

learn more… | top users | synonyms

3
votes
2answers
278 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
55 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
73 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
99 views

case insesitive 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: ...
1
vote
1answer
143 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 ...
1
vote
1answer
111 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
28 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
0answers
18 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
0answers
186 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: ...
1
vote
0answers
49 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 > ...
0
votes
0answers
32 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
0answers
121 views

CQL Filter contradiction between WFS getFeature request and WMS mergeNewParams

I am developing a web map application by using Geoserver 2.4.0. In my application, I have developed a module like Arcgis Query builder as shown below screenshot. In that, while I am using CQL ...
0
votes
0answers
78 views

Openlayers client interface: Query group layers using CQL

I have a layer group in Geoserver and I view the layers in openlayers. In the default view, there is a filter and one can query using CQL. When I have a single layer, it works for me. I just write ...
0
votes
0answers
165 views

Dynamic CQL filter does not work

I'm using Openlayers 2.12 with Geoserver 2.1.3. I am implementing a dynamic CQL filter to search a vector layer. This is for the back-end of the web-site, so I want to restrict the search like so: ...
0
votes
0answers
73 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 ...
0
votes
0answers
106 views

Geoserver Cross-layer filtering Overlap

Has anybody a WMS Example how to set a OVERLAPS Funktion with two layers? When i use the example for intersect it works great, but by OVERLAPS i get a blank respsonse. Here is my WMS Request: ...
0
votes
0answers
31 views

Using mergeNewParms to modify wms layers

i have two wms layes and geosatelite as a base layer. i have a problem when i try to filter data using cql_filter, the debugger says "Uncaught TypeError: Cannot call method 'mergeNewParams' of ...
0
votes
0answers
354 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', { ...
0
votes
0answers
343 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 ...