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 on Oracle Autonomous AI Database.

• 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 following subprograms support Oracle Spatial routing capabilities and are available on Oracle Autonomous AI Database:

  • SDO_GCDR.ELOC_DRIVE_DISTANCE_POLYGON

  • SDO_GCDR.ELOC_DRIVE_TIME_POLYGON

  • SDO_GCDR.ELOC_ROUTE

  • SDO_GCDR.ELOC_ROUTE_DISTANCE

  • SDO_GCDR.ELOC_ROUTE_GEOM

  • SDO_GCDR.ELOC_ROUTE_TIME

• To use the SDO_GCDR.ELOC_* functions on an Autonomous AI Database instance, ensure that you have been granted the required privileges. See SDO_GCDR.ELOC_GRANT_ACCESS 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_DRIVE_DISTANCE_POLYGON

• SDO_GCDR.ELOC_DRIVE_TIME_POLYGON

• SDO_GCDR.ELOC_GEOCODE

• SDO_GCDR.ELOC_GEOCODE_AS_GEOM

• SDO_GCDR.ELOC_GRANT_ACCESS

• SDO_GCDR.ELOC_REVOKE_ACCESS

• SDO_GCDR.ELOC_ROUTE

• SDO_GCDR.ELOC_ROUTE_DISTANCE

• SDO_GCDR.ELOC_ROUTE_GEOM

• SDO_GCDR.ELOC_ROUTE_TIME

• 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