![](https://csdnimg.cn/release/download_crawler_static/5527599/bg11.jpg)
xvii
List of Tables
2–1 Valid SDO_GTYPE Values ....................................................................................................... 2-6
2–2 Values and Semantics in SDO_ELEM_INFO......................................................................... 2-9
2–3 SDO_GEOMETRY Methods.................................................................................................. 2-11
2–4 Columns in the xxx_SDO_INDEX_INFO Views................................................................ 2-31
2–5 Columns in the xxx_SDO_INDEX_METADATA Views .................................................. 2-32
2–6 Columns in an R-Tree 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 Attributes for Formal Address Representation..................................................................... 5-1
5–2 Match Modes for Geocoding Operations ............................................................................... 5-2
5–3 Match Codes for Geocoding Operations ................................................................................ 5-3
5–4 Geocoded Address Error Message Interpretation ................................................................ 5-4
5–5 SDO_GEO_ADDR Type Attributes......................................................................................... 5-5
5–6 GC_AREA_<suffix> Table..................................................................................................... 5-10
5–7 GC_COUNTRY_PROFILE Table.......................................................................................... 5-11
5–8 GC_INTERSECTION_<suffix> Table .................................................................................. 5-13
5–9 GC_POI_<suffix> Table......................................................................................................... 5-14
5–10 GC_POSTAL_CODE_<suffix> Table................................................................................... 5-15
5–11 GC_ROAD_<suffix> Table.................................................................................................... 5-16
5–12 GC_ROAD_SEGMENT_<suffix> Table .............................................................................. 5-18
6–1 SDO_COORD_AXES Table ...................................................................................................... 6-9
6–2 SDO_COORD_AXIS_NAMES Table ...................................................................................... 6-9
6–3 SDO_COORD_OP_METHODS Table..................................................................................... 6-9
6–4 SDO_COORD_OP_PARAM_USE Table............................................................................. 6-10
6–5 SDO_COORD_OP_PARAM_VALS Table .......................................................................... 6-10
6–6 SDO_COORD_OP_PARAMS Table..................................................................................... 6-11
6–7 SDO_COORD_OP_PATHS Table......................................................................................... 6-11
6–8 SDO_COORD_OPS Table...................................................................................................... 6-12
6–9 SDO_COORD_REF_SYS Table ............................................................................................. 6-13
6–10 SDO_COORD_SYS Table....................................................................................................... 6-15
6–11 SDO_CRS_COMPOUND View ............................................................................................ 6-15
6–12 SDO_CRS_ENGINEERING View ........................................................................................ 6-16
6–13 SDO_CRS_GEOCENTRIC View........................................................................................... 6-16
6–14 SDO_CRS_GEOGRAPHIC2D View..................................................................................... 6-17
6–15 SDO_CRS_GEOGRAPHIC3D View..................................................................................... 6-17
6–16 SDO_CRS_PROJECTED View .............................................................................................. 6-18
6–17 SDO_CRS_VERTICAL View................................................................................................. 6-19
6–18 SDO_DATUM_ENGINEERING View ................................................................................ 6-19
6–19 SDO_DATUM_GEODETIC View ........................................................................................ 6-20
6–20 SDO_DATUM_VERTICAL View......................................................................................... 6-20
6–21 SDO_DATUMS Table............................................................................................................. 6-21
6–22 SDO_ELLIPSOIDS Table ....................................................................................................... 6-22
6–23 SDO_PREFERRED_OPS_SYSTEM Table............................................................................ 6-23
6–24 SDO_PREFERRED_OPS_USER Table ................................................................................. 6-24
6–25 SDO_PRIME_MERIDIANS Table ........................................................................................ 6-24
6–26 SDO_UNITS_OF_MEASURE Table..................................................................................... 6-24
6–27 MDSYS.CS_SRS Table ............................................................................................................ 6-26
6–28 MDSYS.SDO_ANGLE_UNITS Table................................................................................... 6-29
6–29 MDSYS.SDO_DATUMS_OLD_FORMAT and SDO_DATUMS_OLD_SNAPSHOT Tables..
6-30
6–30 MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT and SDO_ELLIPSOIDS_OLD_SNAPSHOT
Tables 6-32
6–31 MDSYS.SDO_PROJECTIONS_OLD_FORMAT and SDO_PROJECTIONS_OLD_