4/51

List of Tables

• 1-1 SDO_GEOMETRY Attributes for Three-Dimensional Geometries
• 1-2 Predefined User Accounts Created by Spatial
• 2-1 Valid SDO_GTYPE Values
• 2-2 Values and Semantics in SDO_ELEM_INFO
• 2-3 SDO_GEOMETRY Methods
• 2-4 SDO_TIN Type Attributes
• 2-5 Columns in the TIN Block Table
• 2-6 SDO_PC Type Attributes
• 2-7 Columns in the Point Cloud Block Table
• 2-8 Columns in the xxx_SDO_INDEX_INFO Views
• 2-9 Columns in the xxx_SDO_INDEX_METADATA Views
• 2-10 Columns in an R-Tree Spatial Index Data Table
• 2-11 SDO_UNITS_OF_MEASURE Table Entries for User-Defined Unit
• 3-1 ST_xxx Functions and Spatial Counterparts
• 3-2 Columns in the Annotation Text Metadata Views
• 5-1 Data and Index Dimensionality, and Query Support
• 6-1 SDO_COORD_AXES Table
• 6-2 SDO_COORD_AXIS_NAMES Table
• 6-3 SDO_COORD_OP_METHODS Table
• 6-4 SDO_COORD_OP_PARAM_USE Table
• 6-5 SDO_COORD_OP_PARAM_VALS Table
• 6-6 SDO_COORD_OP_PARAMS Table
• 6-7 SDO_COORD_OP_PATHS Table
• 6-8 SDO_COORD_OPS Table
• 6-9 SDO_COORD_REF_SYS Table
• 6-10 SDO_COORD_SYS Table
• 6-11 SDO_CRS_COMPOUND View
• 6-12 SDO_CRS_ENGINEERING View
• 6-13 SDO_CRS_GEOCENTRIC View
• 6-14 SDO_CRS_GEOGRAPHIC2D View
• 6-15 SDO_CRS_GEOGRAPHIC3D View
• 6-16 SDO_CRS_PROJECTED View
• 6-17 SDO_CRS_VERTICAL View
• 6-18 SDO_DATUM_ENGINEERING View
• 6-19 SDO_DATUM_GEODETIC View
• 6-20 SDO_DATUM_VERTICAL View
• 6-21 SDO_DATUMS Table
• 6-22 SDO_ELLIPSOIDS Table
• 6-23 SDO_PREFERRED_OPS_SYSTEM Table
• 6-24 SDO_PREFERRED_OPS_USER Table
• 6-25 SDO_PRIME_MERIDIANS Table
• 6-26 SDO_UNITS_OF_MEASURE Table
• 6-27 EPSG Table Names and Oracle Spatial Names
• 6-28 MDSYS.CS_SRS Table
• 6-29 MDSYS.SDO_ANGLE_UNITS View
• 6-30 SDO_AREA_UNITS View
• 6-31 MDSYS.SDO_DATUMS_OLD_FORMAT and SDO_DATUMS_OLD_SNAPSHOT Tables
• 6-32 MDSYS.SDO_DIST_UNITS View
• 6-33 MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT and SDO_ELLIPSOIDS_OLD_SNAPSHOT Tables
• 6-34 MDSYS.SDO_PROJECTIONS_OLD_FORMAT and SDO_PROJECTIONS_OLD_SNAPSHOT Tables
• 7-1 Highway Features and LRS Counterparts
• 11-1 Attributes for Formal Address Representation
• 11-2 Match Modes for Geocoding Operations
• 11-3 Match Codes for Geocoding Operations
• 11-4 Geocoded Address Error Message Interpretation
• 11-5 Geocoded Address Match Vector Interpretation
• 11-6 SDO_GEO_ADDR Type Attributes
• 11-7 GC_ADDRESS_POINT_<suffix> Table
• 11-8 GC_AREA_<suffix> Table
• 11-9 GC_COUNTRY_PROFILE Table
• 11-10 GC_INTERSECTION_<suffix> Table
• 11-11 GC_PARSER_PROFILES Table
• 11-12 GC_PARSER_PROFILEAFS Table
• 11-13 GC_POI_<suffix> Table
• 11-14 GC_POSTAL_CODE_<suffix> Table
• 11-15 GC_ROAD_<suffix> Table
• 11-16 GC_ROAD_SEGMENT_<suffix> Table
• 12-1 OPENLS_DIR_BUSINESSES Table
• 12-2 OPENLS_DIR_BUSINESS_CHAINS Table
• 12-3 OPENLS_DIR_CATEGORIES Table
• 12-4 OPENLS_DIR_CATEGORIZATIONS Table
• 12-5 OPENLS_DIR_CATEGORY_TYPES Table
• 12-6 OPENLS_DIR_SYNONYMS Table
• 13-1 EDGE Table
• 13-2 NODE Table
• 13-3 PARTITION Table
• 13-4 SIGN_POST Table
• 14-1 Spatial OpenLS Services Dependencies
• 18-1 Spatial Index Creation and Usage Statements
• 19-1 Main Spatial Operators
• 19-2 Convenience Operators for SDO_RELATE Operations
• 19-3 params Keywords for the SDO_JOIN Operator
• 19-4 Keywords for the SDO_NN Param Parameter
• 20-1 Spatial Aggregate Functions
• 21-1 Subprograms for Coordinate System Transformation
• 21-2 Table to Hold Transformed Layer
• 22-1 Subprograms for CSW Processing Operations
• 23-1 Subprograms for Geocoding Address Data
• 24-1 Geometry Subprograms
• 25-1 Subprograms for Creating and Editing Geometric Segments
• 25-2 Subprograms for Querying and Validating Geometric Segments
• 25-3 Subprograms for Converting Geometric Segments
• 27-1 Subprograms for OpenLS Support
• 28-1 Point Cloud Subprograms
• 29-1 Subprograms for Spatial Analysis and Mining
• 30-1 TIN Subprograms
• 31-1 Tuning Subprograms
• 32-1 Spatial Utility Subprograms
• 33-1 Subprograms for WFS Support
• 34-1 Subprograms for WFS Processing Operations
• 34-2 Geometry Types and columnInfo Parameter Values (WFS 1.0.n)
• B-1 Spatial-Related Features Supported for Locator
• B-2 Spatial Features Not Supported for Locator
• B-3 Feature Availability with Standard or Enterprise Edition