My Oracle Support Banner

Sdo_gcdr.Geocode_As_Geometry Returns SRID 8307 But Projected Coordinates (Doc ID 1307765.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Spatial and Graph - Version 11.1.0.7 to 11.2.0.4 [Release 11.1 to 11.2]
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))

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.