List of Tables

1-1 Choosing R-tree or Quadtree Indexing

1-2 SDOINDEX Table Using Fixed-Size Tiles

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 a Quadtree Spatial Index Data Table

2-7 Columns in the SDO DIST UNITS Table

2-8 Columns in the SDO AREA UNITS Table

5-1 MDSYS.CS SRS Table

5-2 MDSYS.SDO ANGLE UNITS Table

5-3 MDSYS.SDO DIST UNITS Table

5-4 MDSYS.SDO DATUMS Table

5-5 MDSYS.SDO ELLIPSOIDS Table

5-6 MDSYS.SDO PROJECTIONS Table

6-1 Highway Features and LRS Counterparts

8-1 Spatial Index Creation and Usage Statements

8-2 SDO LEVEL and SDO NUMTILES Combinations

9-1 SDO GEOMETRY Type Methods

10-1 Spatial Usage Operators

10-2 Keywords for SDO NN Parameter

11-1 Geometry Functions

12-1 Spatial Aggregate Functions

13-1 Functions and Procedures for Coordinate Systems

13-2 Table to Hold Transformed Layer

14-1 Functions for Creating and Editing Geometric Segments

14-2 Functions for Querying Geometric Segments

14-3 Functions for Converting Geometric Segments

14-4 Functions to Use Instead of SCALE GEOM SEGMENT

15-1 Migration Procedures

16-1 Tuning Functions and Procedures

17-1 Utility Functions and Procedures

B-1 Section of the SDOINDEX Table

C-1 Spatial Features Supported for Locator

C-2 Spatial Features Not Supported for Locator

C-3 Feature Availability with Standard and Enterprise Editions