Sdo_gcdr.Geocode_As_Geometry Returns SRID 8307 But Projected Coordinates

(Doc ID 1307765.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms


SDO_GCDR.GEOCODE_AS_GEOMETRY function returns SRID 8307 but the value in Lat/Lon fields are in Projection Units, same as the data SRID 40983.


SELECT SDO_GCDR.GEOCODE_AS_GEOMETRY('ADCI',
SDO_KEYWORDARRAY('111 N Hope', 'Los Angeles, CA 90012'), 'US')
FROM DUAL;

SDO_GCDR.GEOCODE_AS_GEOMETRY('ADCI',SDO_KEYWORDARRAY('111NHOPE','LOSANGELES,CA90
--------------------------------------------------------------------------------
SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(6486019.81, 1843046.69, NULL), NULL, NULL)



Expected result:

SDO_GCDR.GEOCODE_AS_GEOMETRY('ADCI',SDO_KEYWORDARRAY('111NHOPE','LOSANGELES,CA90
--------------------------------------------------------------------------------
SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(-118.24975, 34.056525, NULL), NULL, NULL)


The Geocoding data is in projected SRID 40983


select table_name,srid from mdsys.user_sdo_geom_metadata;

TABLE_NAME SRID
-------------------------------- ----------
EDGE 40983



select geometry from edge where rownum<=1;

GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
--------------------------------------------------------------------------------
SDO_GEOMETRY(2002, 40983, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY
(6688759.91, 1702237.5, 6688358.14, 1702261.3, 6688315.51, 1702268.41, 6688266.6
8, 1702300.96, 6688248.26, 1702340.92, 6688235.64, 1702450.04, 6688218.09, 17030
14.07))

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms