Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Spatial query returns no rows

427650Aug 13 2004 — edited Aug 13 2004

I have an oracle table with spatial index with the following details:
( Oracle 9i 9.2.0.4 )

SRS : 8265
Data Extents : -77.129588,38.815658 to -76.879555,38.985733

The SDO_GEOM_METADATA has the following entry

DIMINFO :SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180, 180, .001111949), SDO_DIM_ELEMENT('Y',-90, 90, .001111949))
SRID :8265

I get no rows back with the following query
SELECT * FROM DCLANDMARKS WHERE
(MDSYS.SDO_RELATE(GEOLOC,
MDSYS.SDO_GEOMETRY(
2003, -- 2-dimensional polygon
8265,
NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), -- polygon with hole
MDSYS.SDO_ORDINATE_ARRAY(-91,-80, 91,-80, 91,80, -91,80,-91,-80)
),'QUERYTYPE=WINDOW MASK=ANYINTERACT') = 'TRUE')

However changing the ordinate array above to
MDSYS.SDO_ORDINATE_ARRAY(-90,-80, 90,-80, 90,80, -90,80,-90,-80)
Returns rows ? Seems like the extents for Y are being used for X ?
Any ideas ? - We have not been able to work around this one ???

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2004

Added on Aug 13 2004

#database-key-features, #spatial

2 comments

154 views