Oracle Geocoder Returns A Matchcode Of 1 Even If The Postalcode Is Incorrect (Doc ID 1290068.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms


The following query returns a matchcode of 1 even though the postal code is incorrect.


select sdo_gcdr.geocode_addr('odf_na_q210',
SDO_GEO_ADDR('US', 'RELAX_BASE_NAME', '555 N Central Ave',
'Glendale',NULL,'CA','80521'))
FROM DUAL;

SDO_GCDR.GEOCODE_ADDR('ODF_NA_Q210',SDO_GEO_ADDR('US','RELAX_BASE_NAME','555NCENTRALAVE','GLENDALE',
----------------------------------------------------------------------------------------------------
SDO_GEO_ADDR(0, SDO_KEYWORDARRAY(), NULL, 'N CENTRAL AVE', NULL, NULL, 'GLENDALE', NULL, 'CA', 'US',
???#ENUT?B281CP?', 1, 'RELAX_BASE_NAME', -118.25794, 34.1540362, '???10001014??000?')


Furthermore, the postalcode value in the result is blank.
Using Navteq Q210 dataset
This reproduces from 10gr2 (10.2.0.4) through 11.2.0.2.0

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