Oracle Geocoder Inconsistent Results

(Doc ID 1557053.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Trying to geocode UK data.

For no apparent reason this one works:

SELECT to_char(z.x.Latitude) || 'N , ' || to_char(z.x.longitude * -1) || 'W' location
FROM (
  SELECT sdo_gcdr.geocode('MACHERES', SDO_KEYWORDARRAY('', 'SWANSEA'), 'UK', 'DEFAULT'
  ) x from dual) z;

LOCATION
-------------------------------------------------------------------------------------
51.63928N , 4.06796W

This one does not:

SELECT to_char(z.x.Latitude) || 'N , ' || to_char(z.x.longitude * -1) || 'W' location
FROM (
  SELECT sdo_gcdr.geocode('MACHERES', SDO_KEYWORDARRAY('', 'POWYS'), 'UK', 'DEFAULT'
  ) x from dual) z;


LOCATION
-------------------------------------------------------------------------------------
N , W

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