My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.