SQLDialect.encodeGeometryEnvelope needs to pass in the descriptor and the
connection
------------------------------------------------------------------------------------
Key: GEOT-1998
URL: http://jira.codehaus.org/browse/GEOT-1998
Project: GeoTools
Issue Type: Bug
Components: data h2
Reporter: Andrea Aime
Assignee: Andrea Aime
Fix For: 2.5.0, 2.6-M0
With Oracle there are two functions to get the MBR. From the Oracle spatial
docs:
{panel}
The SDO_AGGR_MBR function, documented in Chapter 12, also returns the MBR of
geometries. The SDO_TUNE.EXTENT_OF function has better performance than the
SDO_AGGR_MBR function if the data is non-geodetic and if a spatial index is
defined
on the geometry column; however, the SDO_TUNE.EXTENT_OF function is limited to
two-dimensional geometries, whereas the SDO_AGGR_MBR function is not. In
addition, the SDO_TUNE.EXTENT_OF function computes the extent for all
geometries in a table; by contrast, the SDO_AGGR_MBR function can operate on
subsets of rows.
The SDO_TUNE.EXTENT_OF function returns NULL if the data is inconsistent.
If a non-geodetic spatial index is used, this function may return an
approximate MBR
that encloses the largest extent of data stored in the index, even if data was
subsequently deleted. This can occur because the function extracts MBR
information
from a non-geodetic spatial index, if one exists.
{panel}
SDO_AGGR_MBR will do a full scan of the table, we need to avoid it when
possible.
This means we need to determine if the srid is considered geodetic by oracle
(look into the MDSYS.GEODETIC_SRIDS view) and then decide which function to use.
So we need the NATIVE_SRID and a connection to run the query.
--
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
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
