Spatial (MOSC)

MOSC Banner

SRID issue ???

edited Feb 7, 2011 4:42AM in Spatial (MOSC) 2 commentsAnswered ✓
 Hi .. I perform the following query :

select sdo_geom.sdo_distance(a.geometry, b.geometry, .005, 'UNIT=FOOT') from mps a, mps b where a.name = '46008' and b.name = '45770';

and I get :

SQL> select sdo_geom.sdo_distance(a.geometry, b.geometry, .005, 'UNIT=FOOT') from mps a,

SDO_GEOM.SDO_DISTANCE(A.GEOMETRY,B.GEOMETRY,.005,'UNIT=FOOT')
-------------------------------------------------------------
                                                   68.1841369

But ... two other tools show the distance to be about 192 feet.  What am I doing wrong ??

NAME
------------------------------
GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
--------------------------------------------------------------------------------
ISCOLLECTOR
-----------
46008
SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(30.253374, -87.730944, NULL), NULL, NULL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center