Oracle datastore is not able to properly return data when the bbox filter
exceeds the world bounds
--------------------------------------------------------------------------------------------------
Key: GEOT-1940
URL: http://jira.codehaus.org/browse/GEOT-1940
Project: GeoTools
Issue Type: Bug
Components: data oraclespatial
Affects Versions: 2.5-M2
Reporter: Andrea Aime
Assignee: Andrea Aime
Unlike other spatial databases Oracle knows about lat/lon periodicity and
normalizes the coordinates provided in the query, meaning a bbox exceeding the
world bounds end ups being smaller than the actual world bounds and return less
records.
For example in a sample dataset covering the world bounds with 19 polygons here
are some results:
{code}
SELECT count(*)
FROM "FAO_MAJOR"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-179.99999,-89.99999,179.99999,89.99999)),'mask=anyinteract
querytype=WINDOW') = 'TRUE';
--> 19
SELECT count(*)
FROM "FAO_MAJOR"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180,-90,180,90)),'mask=anyinteract
querytype=WINDOW') = 'TRUE';
--> 17 (not sure why)
SELECT count(*)
FROM "FAO_MAJOR"
WHERE
SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-310.1484375,-143.2460937499999,310.1484375,145.2460937500001)),'mask=anyinteract
querytype=WINDOW') = 'TRUE';
--> 12!
{code}
--
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
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
