I’m trying to use a cql filter to filter out all geometries within n kilometers of a region. I’m doing this by adding cql filter dwithin to my request.
The oracle nG pluging translates the (openlayers) request into a query with an SDO_WITHIN_DISTANCE and a SDO_RELATE part of the where clause
This query never returns any results.
Only by removing the SDO_RELATE part the query returns the expected results.
I think this part of the query comes from the BBOX parameter in the request but I’m not sure.
So my question is: is this wrong in the oracle plugin or shouldn’t openlayers pass the bbox parameter in the request or should this be ok and are the parameters of the sdo_relate part wrong and should I investigate them more.
Extra information is that I have a map with EPSG:28992 projection and this particular layer is in EPSG:4326.
I convert the parameters to the CQL_FILTER to EPSG:4326 myself (with OpenLayers transform method) but BBOX parameter is set by OpenLayers itself I think
With regards of your previous emails in ml, If you use an Oracle version prior 10.1. With these releases, and with geodetic data (as your layer with EPSG:4326 specified), default is unit of measurement associated with the data. For geodetic data, the default is meters. Also, if this operator is used with geodetic data and if the R-tree spatial index is created with ‘geodetic=false’ specified, you cannot use the unit parameter.
I’m trying to use a cql filter to filter out all geometries within n kilometers of a region. I’m doing this by adding cql filter dwithin to my request.
The oracle nG pluging translates the (openlayers) request into a query with an SDO_WITHIN_DISTANCE and a SDO_RELATE part of the where clause
This query never returns any results.
Only by removing the SDO_RELATE part the query returns the expected results.
I think this part of the query comes from the BBOX parameter in the request but I’m not sure.
So my question is: is this wrong in the oracle plugin or shouldn’t openlayers pass the bbox parameter in the request or should this be ok and are the parameters of the sdo_relate part wrong and should I investigate them more.
Extra information is that I have a map with EPSG:28992 projection and this particular layer is in EPSG:4326.
I convert the parameters to the CQL_FILTER to EPSG:4326 myself (with OpenLayers transform method) but BBOX parameter is set by OpenLayers itself I think
Apps built with the Adobe(R) Flex(R) framework and Flex Builder™ are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse™based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
