SRID issue ???
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