To filter data using the Common Query Language

learn more… | top users | synonyms

2
votes
1answer
117 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
120 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 ...
2
votes
0answers
50 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
271 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
26 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
0answers
41 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 ...
1
vote
0answers
63 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
86 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
23 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
54 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
0answers
24 views

Parsing OGC Filters with C++

Google Translation I am developing an application in C + + you need to parse OGC filter. Anyone know any way to parse an OGC filter with C + +? Estoy desarrollando una aplicación en C++ que ...
0
votes
0answers
15 views

SLD filter function usage for placing symbol at a particular point on the geometry (the_geom)

I am applying a symbol to a point on ellipse. For this i used the startPoint function, but my ellipse's coordinates start from the right side on the curve so it wrongly places the symbol at the right ...
0
votes
0answers
241 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 ...
0
votes
0answers
57 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
242 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
99 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
540 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
404 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 ...