The Result From the Geocoding Gets Rid Of The Leading Zeroes

(Doc ID 1238723.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

The result from the Geocoding gets rid of the leading zeroes

Example:

select sdo_gcdr.geocode_addr('ODF_NA_Q110',SDO_GEO_ADDR('US','DEFAULT',
'0N950 Probst Ct', 'Maple Park', null, 'IL', '60151'))
from dual;


SDO_GCDR.GEOCODE_ADDR('ODF_NA_Q110',SDO_GEO_ADDR('US','DEFAULT','0N950PROBSTCT
',

------------------------------------------------------------------------------
--

SDO_GEO_ADDR(0, SDO_KEYWORDARRAY(), NULL, 'PROBST CT', NULL, NULL, 'MAPLE
PARK',

NULL, 'IL', 'US', '60151', NULL, '60151', NULL, 'N950', 'PROBST', 'CT', 'F',
'F

', NULL, NULL, 'L', .510204082, 427804653, '????#ENUT?B281CP?', 1, 'DEFAULT',
-8

8.553516, 41.8786581, '???10101014??000?')

Note the "N950" without the leading zero.


select sdo_gcdr.geocode_addr('ODF_NA_Q110',SDO_GEO_ADDR('US','DEFAULT',
'01700 SW COMUS ST', 'Portland', null, 'OR', '60151'))
from dual;

SDO_GCDR.GEOCODE_ADDR('ODF_NA_Q110',SDO_GEO_ADDR('US','DEFAULT','01700SWCOMUSS
T'

------------------------------------------------------------------------------
--

SDO_GEO_ADDR(0, SDO_KEYWORDARRAY(), NULL, 'SW COMUS ST', NULL, NULL,
'PORTLAND',

NULL, 'OR', 'US', '97219', NULL, '97219', NULL, '1700', 'COMUS', 'ST', 'F',
'F'

, 'SW', NULL, 'R', 0, 254585060, '????#ENUT?B281C??', 10, 'DEFAULT',
-122.66163,

45.44627, '???10001014??002?')

Note the "1700" without the leading zero.

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