xvi
List of Tables
1–1 Choosing R-tree or Quadtree Indexing............................................................................ 1-11
1–2 SDOINDEX Table Using Fixed-Size Tiles........................................................................ 1-19
2–1 Valid SDO_GTYPE Values................................................................................................... 2-7
2–2 Values and Semantics in SDO_ELEM_INFO .................................................................. 2-12
2–3 Columns in the xxx_SDO_INDEX_INFO Views ............................................................ 2-30
2–4 Columns in the xxx_SDO_INDEX_METADATA Views............................................... 2-31
2–5 Columns in an R-tree Spatial Index Data Table.............................................................. 2-33
2–6 Columns in a Quadtree Spatial Index Data Table ........................................................ 2-34
2–7 Columns in the SDO_DIST_UNITS Table ....................................................................... 2-35
2–8 Columns in the SDO_AREA_UNITS Table..................................................................... 2-35
5–1 MDSYS.CS_SRS Table........................................................................................................... 5-7
5–2 MDSYS.SDO_ANGLE_UNITS Table................................................................................ 5-11
5–3 MDSYS.SDO_DIST_UNITS Table..................................................................................... 5-11
5–4 MDSYS.SDO_DATUMS Table........................................................................................... 5-12
5–5 MDSYS.SDO_ELLIPSOIDS Table ..................................................................................... 5-14
5–6 MDSYS.SDO_PROJECTIONS Table................................................................................. 5-15
6–1 Highway Features and LRS Counterparts....................................................................... 6-21
8–1 Spatial Index Creation and Usage Statements .................................................................. 8-1
8–2 SDO_LEVEL and SDO_NUMTILES Combinations....................................................... 8-16
9–1 SDO_GEOMETRY Type Methods ...................................................................................... 9-1
10–1 Spatial Usage Operators..................................................................................................... 10-1
10–2 Keywords for SDO_NN Parameter .................................................................................. 10-6
11–1 Geometry Functions............................................................................................................ 11-1
12–1 Spatial Aggregate Functions.............................................................................................. 12-1
13–1 Functions and Procedures for Coordinate Systems ....................................................... 13-1
13–2 Table to Hold Transformed Layer..................................................................................... 13-6
14–1 Functions for Creating and Editing Geometric Segments............................................. 14-1
14–2 Functions for Querying Geometric Segments................................................................. 14-2
14–3 Functions for Converting Geometric Segments.............................................................. 14-3
14–4 Functions to Use Instead of SCALE_GEOM_SEGMENT............................................ 14-78
15–1 Migration Procedures ......................................................................................................... 15-1
16–1 Tuning Functions and Procedures.................................................................................... 16-1
17–1 Utility Functions and Procedures...................................................................................... 17-1
B–1 Section of the SDOINDEX Table ......................................................................................... B-4
C–1 Spatial Features Supported for Locator.............................................................................. C-2
C–2 Spatial Features Not Supported for Locator...................................................................... C-3
C–3 Feature Availability with Standard and Enterprise Editions.......................................... C-4