Geocode Requests Return Null Community When Zip Code Is Provided (Doc ID 1377491.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

  Addresses will Drop the Settlement if we provide a zip code

Some addresses will drop the settlement if we code in a zip (it is a valid zip). If we send the same address without the zip the settlement stays and the proper zip gets added. Below are a few examples, customer has found numerous addresses returning this way.

Using Navteq geocoding data from the 2011Q1 ODF delivery. Example below:

This one adds the proper zip

SELECT SDO_GCDR.GEOCODE('GEOCODE_2011_Q1',
SDO_KEYWORDARRAY('400 5th st', 'Eagle Lake, FL'),
'US', 'DEFAULT') FROM DUAL;

SDO_GCDR.GEOCODE('GEOCODE_2011_Q1',SDO_KEYWORDARRAY('4005THST','EAGLELAKE,FL'
),'
-----------------------------------------------------------------------------
---
SDO_GEO_ADDR(0, SDO_KEYWORDARRAY(), NULL, 'S 5th St', NULL, NULL, 'Eagle
Lake',
NULL, 'FL', 'US', '33839', NULL, '33839', NULL, '400', '5TH', 'ST', 'F',
'F', 'S
', NULL, 'R', 1, 105835291, '????#?NUT?B281CP?', 2, 'DEFAULT', -81.75945,
27.976
11, '???10401010??004?')

This removes the settlement and returns in a different zip (33843)

SELECT SDO_GCDR.GEOCODE('GEOCODE_2011_Q1',
SDO_KEYWORDARRAY('400 5th st', 'Eagle Lake, FL 33839'),
'US', 'DEFAULT') FROM DUAL;

SDO_GCDR.GEOCODE('GEOCODE_2011_Q1',SDO_KEYWORDARRAY('4005THST','EAGLELAKE,FL3
383
-----------------------------------------------------------------------------
---
SDO_GEO_ADDR(0, SDO_KEYWORDARRAY(), NULL, '5th St', NULL, NULL, NULL,
'POLK', 'F
L', 'US', '33843', NULL, '33843', NULL, '400', '5TH', 'ST', 'F', 'F', NULL,
NULL
, 'R', 0, 106064664, '????#ENUT??281C??', 11, 'DEFAULT', -81.53601,
27.73993, '?
??10101012??002?')


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