List of Tables

2-1 Valid SDO_GTYPE Values

2-2 Values and Semantics in SDO_ELEM_INFO

2-3 Columns in the xxx_SDO_INDEX_INFO Views

2-4 Columns in the xxx_SDO_INDEX_METADATA Views

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

2-6 Columns in the SDO_DIST_UNITS Table

2-7 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

6-1 MDSYS.CS_SRS Table

6-2 MDSYS.SDO_ANGLE_UNITS Table

6-3 MDSYS.SDO_DATUMS Table

6-4 MDSYS.SDO_ELLIPSOIDS Table

6-5 MDSYS.SDO_PROJECTIONS Table

7-1 Highway Features and LRS Counterparts

10-1 Spatial Index Creation and Usage Statements

11-1 SDO_GEOMETRY Type Methods

12-1 Main Spatial Operators

12-2 Convenience Operators for SDO_RELATE Operations

12-3 params Keywords for the SDO_JOIN Operator

12-4 Keywords for the SDO_NN Param Parameter

13-1 Geometry Subprograms

14-1 Spatial Aggregate Functions

15-1 Subprograms for Coordinate System Transformation

15-2 Table to Hold Transformed Layer

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

16-4 Functions to Use Instead of SCALE_GEOM_SEGMENT

18-1 Tuning Subprograms

19-1 Spatial Utility Subprograms

20-1 Subprograms for Geocoding Address Data

21-1 Subprograms for Spatial Analysis and Mining

B-1 Spatial Features Supported for Locator

B-2 Spatial Features Not Supported for Locator

B-3 Feature Availability with Standard and Enterprise Editions