12 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 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 fromplacenameandcountryinput 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.
Parent topic: Spatial Web Services