SDO_WITHIN_DISTANCE unit not set when for example kilometers is specified in
CQL filter
---------------------------------------------------------------------------------------
Key: GEOT-2384
URL: http://jira.codehaus.org/browse/GEOT-2384
Project: GeoTools
Issue Type: Bug
Components: data jdbc-ng
Affects Versions: 2.5.5
Reporter: Kris Geusebroek
If a unit is specified in the CQL Filter. for example
CQL_FILTER=DWITHIN(GEOMETRY, ENVELOPE(n,n,n,n), 25, 'kilometers') then the
resulting query states
SELECT GEOMETRY FROM table1 WHERE SDO_WITHIN_DISTANCE(GEOMETRY,
MDO_SYS.GEOMETRY(), 'distance=25')
default is the unit of measurement associated with the data. For geodetic data,
the default is meters.
so if a different unit is specified in the CQL Filter the query should state:
SELECT GEOMETRY FROM table1 WHERE SDO_WITHIN_DISTANCE(GEOMETRY,
MDO_SYS.GEOMETRY(), 'distance=25 unit=kilometers')
workaround is to specify CQL filter in meters
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)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
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
