To filter data using the Common Query Language

learn more… | top users | synonyms

1
vote
0answers
849 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
315 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 = max(...
10
votes
1answer
861 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
229 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.
7
votes
2answers
3k 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
106 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

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
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 ...
1
vote
1answer
115 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 ...
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 ...
1
vote
1answer
2k 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 ...
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;...
5
votes
3answers
11k 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, ...
1
vote
1answer
535 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 ...
2
votes
1answer
204 views

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

A WFS GetFeature query looks something like this: http://hname/arcgis/services/sname/MapServer/WFSServer?SERVICE=WFS&REQUEST=GetFeature&VERSION=1.0.0&MAXFEATURES=1001&FILTER=%3CFilter%...
0
votes
0answers
506 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 ...
2
votes
1answer
510 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& VERSION=2.0....
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
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 bbox(igh,20786691,22051867,-305577260,-...
3
votes
1answer
757 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.
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 ...