The Result From the Geocoding Gets Rid Of The Leading Zeroes
(Doc ID 1238723.1)
Last updated on APRIL 01, 2020
Applies to:
Oracle Spatial and Graph - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
The result from the Geocoding functions eliminates 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?')
'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.
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 |