Skip to Main Content

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 RELATE QUERY

363741Jan 31 2003 — edited Feb 3 2003
We are just starting to get into Oracle Spatial and I have a problem trying to do something that should be simple.
We have a regular table that consists of 200,000 records.
For each record there is an X, Y(Montana State Plane Coordinates) This table isn't spatially enabled.
But we have a County Polygon table in State Plane coordinates that is spatially enabled. There are 56 counties.
I am trying to populate an actual County Name to each of the 200,000 records by performing a SDO_RELATE.
The select statement will run -- for a long time but never gets completed.
Has anyone ever used the SDO_RELATE command on a spatially enabled table back to an unspatially enabled table.
Here is the select statement that I'm using


SELECT GEOSPATIAL.MT_COUNTIES.NAME FROM GEOSPATIAL.MT_COUNTIES
WHERE
SDO_RELATE(GEOSPATIAL.MT_COUNTIES.GEOM,
MDSYS.SDO_GEOMETRY(2001,41079,MDSYS.SDO_POINT_TYPE(GPS_SYS.SAMPLE_TABLE.ISH_X_COORD,
GPS_SYS.SAMPLE_TABLE.ISH_X_COORD,NULL),NULL,NULL),
'MASK=CONTAINS QUERYTYPE=WINDOW')='TRUE'

Thanks for your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2003
Added on Jan 31 2003
3 comments
173 views