Geocoding Address Data

Geocoding is the process of associating spatial locations (longitude and latitude coordinates) with postal addresses.

Note: Geocoding using SQL that accesses an Oracle managed service is available on Oracle Autonomous AI Database. See SDO_GCDR.ELOC_GEOCODE and SDO_GCDR.ELOC_GEOCODE_AS_GEOM for more information.

• Concepts for Geocoding
  This topic describes concepts that you must understand before you use the Spatial geocoding capabilities.

• Data Types for Geocoding
  This topic describes the data types specific to geocoding functions and procedures.

• Using the Geocoding Capabilities
  To use the Oracle Spatial geocoding capabilities, you must use data provided by a geocoding vendor, and the data must be in the format supported by the Oracle Spatial geocoding feature.

• Geocoding from a Place Name
  If you know a place name (point of interest) but not its locality details, you can create a PL/SQL function to construct an SDO_GEO_ADDR object from placename and country input parameters.

• Data Structures for Geocoding
  Oracle uses the following tables for geocoding.

• Installing the Profile Tables
  The Oracle Geocoder profile tables are typically supplied by a data provider.

• Using the Geocoding Service (XML API)
  In addition to the SQL API, Oracle Spatial also provides an XML API for a geocoding service that enables you to geocode addresses.