List of Tables

2-1 Valid SDO_GTYPE Values

2-2 Values and Semantics in SDO_ELEM_INFO

2-3 SDO_GEOMETRY Methods

2-4 Columns in the xxx_SDO_INDEX_INFO Views

2-5 Columns in the xxx_SDO_INDEX_METADATA Views

2-6 Columns in an R-Tree Spatial Index Data Table

2-7 Columns in the SDO_DIST_UNITS Table

2-8 Columns in the SDO_AREA_UNITS Table

5-1 Attributes for Formal Address Representation

5-2 Match Modes for Geocoding Operations

5-3 Match Codes for Geocoding Operations

5-4 Geocoded Address Error Message Interpretation

5-5 SDO_GEO_ADDR Type Attributes

5-6 GC_AREA_<suffix> Table

5-7 GC_COUNTRY_PROFILE Table

5-8 GC_INTERSECTION_<suffix> Table

5-9 GC_POI_<suffix> Table

5-10 GC_POSTAL_CODE_<suffix> Table

5-11 GC_ROAD_<suffix> Table

5-12 GC_ROAD_SEGMENT_<suffix> Table

6-1 SDO_COORD_AXES Table

6-2 SDO_COORD_AXIS_NAMES Table

6-3 SDO_COORD_OP_METHODS Table

6-4 SDO_COORD_OP_PARAM_USE Table

6-5 SDO_COORD_OP_PARAM_VALS Table

6-6 SDO_COORD_OP_PARAMS Table

6-7 SDO_COORD_OP_PATHS Table

6-8 SDO_COORD_OPS Table

6-9 SDO_COORD_REF_SYS Table

6-10 SDO_COORD_SYS Table

6-11 SDO_CRS_COMPOUND View

6-12 SDO_CRS_ENGINEERING View

6-13 SDO_CRS_GEOCENTRIC View

6-14 SDO_CRS_GEOGRAPHIC2D View

6-15 SDO_CRS_GEOGRAPHIC3D View

6-16 SDO_CRS_PROJECTED View

6-17 SDO_CRS_VERTICAL View

6-18 SDO_DATUM_ENGINEERING View

6-19 SDO_DATUM_GEODETIC View

6-20 SDO_DATUM_VERTICAL View

6-21 SDO_DATUMS Table

6-22 SDO_ELLIPSOIDS Table

6-23 SDO_PREFERRED_OPS_SYSTEM Table

6-24 SDO_PREFERRED_OPS_USER Table

6-25 SDO_PRIME_MERIDIANS Table

6-26 SDO_UNITS_OF_MEASURE Table

6-27 MDSYS.CS_SRS Table

6-28 MDSYS.SDO_ANGLE_UNITS Table

6-29 MDSYS.SDO_DATUMS_OLD_FORMAT and SDO_DATUMS_OLD_SNAPSHOT Tables

6-30 MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT and SDO_ELLIPSOIDS_OLD_SNAPSHOT Tables

6-31 MDSYS.SDO_PROJECTIONS_OLD_FORMAT and SDO_PROJECTIONS_OLD_SNAPSHOT Tables

7-1 Highway Features and LRS Counterparts

10-1 Spatial Index Creation and Usage Statements

11-1 Main Spatial Operators

11-2 Convenience Operators for SDO_RELATE Operations

11-3 params Keywords for the SDO_JOIN Operator

11-4 Keywords for the SDO_NN Param Parameter

12-1 Spatial Aggregate Functions

13-1 Subprograms for Coordinate System Transformation

13-2 Table to Hold Transformed Layer

14-1 Subprograms for Geocoding Address Data

15-1 Geometry Subprograms

16-1 Subprograms for Creating and Editing Geometric Segments

16-2 Subprograms for Querying and Validating Geometric Segments

16-3 Subprograms for Converting Geometric Segments

18-1 Subprograms for Spatial Analysis and Mining

19-1 Tuning Subprograms

20-1 Spatial Utility Subprograms

B-1 Spatial Features Supported for Locator

B-2 Spatial Features Not Supported for Locator

B-3 Feature Availability with Standard and Enterprise Editions

C-3 PARTITION Table

C-4 SIGN_POST Table