Oracle® Spatial Developer's Guide
11g Release 2 (11.2)
Part Number E11830-11

PDF · Mobi · ePub

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

Copyright © 1999, 2012, Oracle and/or its affiliates. All rights reserved.
Legal Notices