To filter data using the Common Query Language

learn more… | top users | synonyms

1
vote
2answers
32 views

How to give multiple user input CQL filters to a single layer using Geoserver?

I have a layer in which I need to apply multiple check box filters. For example, I need to filter a layer based on state, city and some other attribute based on user input/ CQL filter. Basically, I ...
2
votes
1answer
53 views

how to reset cql_filter of wms on ol3?

I can dynamically change the cql filter but in want to reset it to default (get wms without any filter ) class i am using "ol.source.TileWMS" as source from geoserver here is my code to which i ...
2
votes
1answer
91 views

Adding WMS layer with CQL filter

I would like to add to my leaflet's web map layer from my WMS service (Geoserver), but I need to use CQL filter in GetMap link: localhost/geoserver/my_location/wms?(...)&CQL_FILTER=[...] Is ...
1
vote
1answer
37 views

Using nested geometric functions in ECQL queries in GeoServer

When doing a WFS Get Feature request, I am using the cql_filter option to do some more advanced spatial filtering/quering. I am looking for the centroids of the polygons in a database that intersect ...
1
vote
1answer
137 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
139 views

Load Multiple WFS layers from array with OpenLayers

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 iteratively calling WFS layers and ...
2
votes
0answers
238 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
106 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
0answers
181 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", "...
1
vote
0answers
118 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
858 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
11 views

Creating a CQL filter function in Openlayers 2.10

Im having trouble with creating a CQL search function of my geoserver wms in OpenLayers. Im am running a 2.10 version of OpenLayers. Im a rookie in coding, so I'm trying to implement this example: ...
0
votes
0answers
205 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 '%...
0
votes
0answers
69 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
87 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
776 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 type="text/javascript">...
0
votes
0answers
167 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
214 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
514 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 ...