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

9-1 Spatial Index Creation and Usage Statements

9-2 SDO_LEVEL and SDO_NUMTILES Combinations

10-1 SDO_GEOMETRY Type Methods

11-1 Spatial Usage Operators

11-2 Keywords for SDO_NN Parameter

12-1 Geometry Functions

13-1 Spatial Aggregate Functions

14-1 Functions and Procedures for Coordinate Systems

14-2 Table to Hold Transformed Layer

15-1 Functions for Creating and Editing Geometric Segments

15-2 Functions for Querying Geometric Segments

15-3 Functions for Converting Geometric Segments

15-4 Functions to Use Instead of SCALE_GEOM_SEGMENT

16-1 Migration Procedures

17-1 Tuning Functions and Procedures

B-1 Section of the SDOINDEX Table

C-1 Spatial Features Supported for Locator