24 SDO_GCDR Package (Geocoding)

The MDSYS.SDO_GCDR package contains subprograms for performing geocoding.

To use the subprograms in this chapter, you must understand the conceptual and usage information about geocoding in Geocoding Address Data.

Note:

• SDO_GCDR.ELOC_GEOCODE and SDO_GCDR.ELOC_GEOCODE_AS_GEOM leverage a hosted geocoding service and are available only on Oracle Autonomous Database Serverless deployments.
• With the exception of SDO_GCDR.ELOC_GEOCODE and SDO_GCDR.ELOC_GEOCODE_AS_GEOM, geocoding functions require the acquisition and loading of supporting reference data. See Data Structures for Geocoding for more information.

The rest of this chapter provides reference information on the subprograms, listed in alphabetical order.

• SDO_GCDR.CREATE_PROFILE_TABLES
  
• SDO_GCDR.ELOC_GEOCODE
  
• SDO_GCDR.ELOC_GEOCODE_AS_GEOM
  
• SDO_GCDR.ELOC_GRANT_ACCESS
  
• SDO_GCDR.ELOC_REVOKE_ACCESS
  
• SDO_GCDR.GEOCODE
  
• SDO_GCDR.GEOCODE_ADDR
  
• SDO_GCDR.GEOCODE_ADDR_ALL
  
• SDO_GCDR.GEOCODE_ALL
  
• SDO_GCDR.GEOCODE_AS_GEOMETRY
  
• SDO_GCDR.REVERSE_GEOCODE