To filter data using the Common Query Language

learn more… | top users | synonyms

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 ...
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( ...
1
vote
1answer
109 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
1k 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 = ...
1
vote
1answer
478 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
199 views
1
vote
1answer
401 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& ...
0
votes
0answers
459 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 ...
3
votes
1answer
649 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.
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 ...
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 ...