To filter data using the Common Query Language
0
votes
0answers
17 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 ...
0
votes
0answers
16 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
14 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 ...
1
vote
0answers
40 views
CQL Filter on WMS [duplicate]
I have CQL_Filter which filters WMS layer and displays only the points I asked for,
The problem is that all features even the hidden, keep showing its popup when I click on their spot.
So, as I ...
1
vote
1answer
22 views
geoserver returns incorrect number of points when cql used
I'm using Geoserver 2.2.4 to support WMS queries. All testing is done via the "Layer Preview" page.
If I send a request with no CQL a map full of points is returned as expected.
If I add a CQL ...
2
votes
3answers
2k 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, ...
2
votes
0answers
60 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:
...
0
votes
0answers
23 views
Non-native SRS in CQL query?
In my application, I'm using OpenLayers to composite a Google baselayer with an overlay of my own construction, served up with GeoServer 2.3. The layers in my thing are all in a Wisconsin-specific ...
0
votes
0answers
189 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
108 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 = ...
10
votes
1answer
367 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 ...
2
votes
1answer
71 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.
2
votes
1answer
67 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 ...
5
votes
2answers
647 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 ...
1
vote
1answer
177 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 ...
0
votes
0answers
216 views
WMSGetFeatureInfo results empty when not in CQL_FILTER
I'm trying to get WMSGetFeatureInfo with CQL_FILTER to work correctly.
Right now when I click on a result of the CQL_FILTER I get an HTML response with the object attributes.
<html>
...
1
vote
1answer
96 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
885 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
75 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
589 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
834 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
483 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
250 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
2answers
123 views
Any source code for converting an infix filter to a WFS filter?
A WFS GetFeature query looks something like this:
...
1
vote
1answer
234 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
254 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
420 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
900 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
1k 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 ...
