SPATIAL RELATE QUERY
363741Jan 31 2003 — edited Feb 3 2003We 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.