Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Spatial?

• Release 11.2
• Release 11.1

Part I Conceptual and Usage Information

1 Spatial Concepts

• 1.1 What Is Oracle Spatial?
• 1.2 Object-Relational Model
• 1.3 Introduction to Spatial Data
• 1.4 Geometry Types
• 1.5 Data Model
  • 1.5.1 Element
  • 1.5.2 Geometry
  • 1.5.3 Layer
  • 1.5.4 Coordinate System
  • 1.5.5 Tolerance
    • 1.5.5.1 Tolerance in the Geometry Metadata for a Layer
    • 1.5.5.2 Tolerance as an Input Parameter
• 1.6 Query Model
• 1.7 Indexing of Spatial Data
  • 1.7.1 R-Tree Indexing
  • 1.7.2 R-Tree Quality
• 1.8 Spatial Relationships and Filtering
• 1.9 Spatial Operators, Procedures, and Functions
• 1.10 Spatial Aggregate Functions
  • 1.10.1 SDOAGGRTYPE Object Type
• 1.11 Three-Dimensional Spatial Objects
  • 1.11.1 Modeling Surfaces
  • 1.11.2 Modeling Solids
  • 1.11.3 Three-Dimensional Optimized Rectangles
  • 1.11.4 Using Texture Data
    • 1.11.4.1 Schema Considerations with Texture Data
  • 1.11.5 Validation Checks for Three-Dimensional Geometries
• 1.12 Geocoding
• 1.13 Spatial Java Application Programming Interface
• 1.14 Predefined User Accounts Created by Spatial
• 1.15 Performance and Tuning Information
• 1.16 OGC and ISO Compliance
• 1.17 Spatial Release (Version) Number
• 1.18 Moving Spatial Metadata (MDSYS.MOVE_SDO)
• 1.19 Spatial Application Hardware Requirement Considerations
• 1.20 Spatial Error Messages
• 1.21 Spatial Examples
• 1.22 README File for Spatial and Related Features

2 Spatial Data Types and Metadata

• 2.1 Simple Example: Inserting, Indexing, and Querying Spatial Data
• 2.2 SDO_GEOMETRY Object Type
  • 2.2.1 SDO_GTYPE
  • 2.2.2 SDO_SRID
  • 2.2.3 SDO_POINT
  • 2.2.4 SDO_ELEM_INFO
  • 2.2.5 SDO_ORDINATES
  • 2.2.6 Usage Considerations
• 2.3 SDO_GEOMETRY Methods
• 2.4 SDO_GEOMETRY Constructors
• 2.5 TIN-Related Object Types
  • 2.5.1 SDO_TIN Object Type
  • 2.5.2 SDO_TIN_BLK_TYPE and SDO_TIN_BLK Object Types
• 2.6 Point Cloud-Related Object Types
  • 2.6.1 SDO_PC Object Type
  • 2.6.2 SDO_PC_BLK_TYPE and SDO_PC_BLK Object Type
• 2.7 Geometry Examples
  • 2.7.1 Rectangle
  • 2.7.2 Polygon with a Hole
  • 2.7.3 Compound Line String
  • 2.7.4 Compound Polygon
  • 2.7.5 Point
  • 2.7.6 Oriented Point
  • 2.7.7 Type 0 (Zero) Element
  • 2.7.8 Several Two-Dimensional Geometry Types
  • 2.7.9 Three-Dimensional Geometry Types
• 2.8 Geometry Metadata Views
  • 2.8.1 TABLE_NAME
  • 2.8.2 COLUMN_NAME
  • 2.8.3 DIMINFO
  • 2.8.4 SRID
• 2.9 Spatial Index-Related Structures
  • 2.9.1 Spatial Index Views
    • 2.9.1.1 xxx_SDO_INDEX_INFO Views
    • 2.9.1.2 xxx_SDO_INDEX_METADATA Views
  • 2.9.2 Spatial Index Table Definition
  • 2.9.3 R-Tree Index Sequence Object
• 2.10 Unit of Measurement Support
  • 2.10.1 Creating a User-Defined Unit of Measurement

3 SQL Multimedia Type Support

• 3.1 ST_GEOMETRY and SDO_GEOMETRY Interoperability
• 3.2 Tolerance Value with SQL Multimedia Types
• 3.3 Avoiding Name Conflicts
• 3.4 Annotation Text Type and Views
  • 3.4.1 Using the ST_ANNOTATION_TEXT Constructor
  • 3.4.2 Annotation Text Metadata Views

4 Loading Spatial Data

• 4.1 Bulk Loading
  • 4.1.1 Bulk Loading SDO_GEOMETRY Objects
  • 4.1.2 Bulk Loading Point-Only Data in SDO_GEOMETRY Objects
• 4.2 Transactional Insert Operations Using SQL
• 4.3 Recommendations for Loading and Validating Spatial Data

5 Indexing and Querying Spatial Data

• 5.1 Creating a Spatial Index
  • 5.1.1 Constraining Data to a Geometry Type
  • 5.1.2 Creating a Cross-Schema Index
  • 5.1.3 Using Partitioned Spatial Indexes
    • 5.1.3.1 Creating a Local Partitioned Spatial Index
  • 5.1.4 Exchanging Partitions Including Indexes
  • 5.1.5 Export and Import Considerations with Spatial Indexes and Data
  • 5.1.6 Distributed Transactions and Spatial Index Consistency
  • 5.1.7 Rollback Segments and Sort Area Size
• 5.2 Querying Spatial Data
  • 5.2.1 Spatial Query
    • 5.2.1.1 Primary Filter Operator
    • 5.2.1.2 Primary and Secondary Filter Operator
    • 5.2.1.3 Within-Distance Operator
    • 5.2.1.4 Nearest Neighbor Operator
    • 5.2.1.5 Spatial Functions
  • 5.2.2 Spatial Join
  • 5.2.3 Data and Index Dimensionality, and Spatial Queries

6 Coordinate Systems (Spatial Reference Systems)

• 6.1 Terms and Concepts
  • 6.1.1 Coordinate System (Spatial Reference System)
  • 6.1.2 Cartesian Coordinates
  • 6.1.3 Geodetic Coordinates (Geographic Coordinates)
  • 6.1.4 Projected Coordinates
  • 6.1.5 Local Coordinates
  • 6.1.6 Geodetic Datum
  • 6.1.7 Transformation
• 6.2 Geodetic Coordinate Support
  • 6.2.1 Geodesy and Two-Dimensional Geometry
  • 6.2.2 Choosing a Geodetic or Projected Coordinate System
  • 6.2.3 Choosing Non-Ellipsoidal or Ellipsoidal Height
    • 6.2.3.1 Non-Ellipsoidal Height
    • 6.2.3.2 Ellipsoidal Height
  • 6.2.4 Geodetic MBRs
  • 6.2.5 Other Considerations and Requirements with Geodetic Data
• 6.3 Local Coordinate Support
• 6.4 EPSG Model and Spatial
• 6.5 Three-Dimensional Coordinate Reference System Support
  • 6.5.1 Geographic 3D Coordinate Reference Systems
  • 6.5.2 Compound Coordinate Reference Systems
  • 6.5.3 Three-Dimensional Transformations
  • 6.5.4 Cross-Dimensionality Transformations
• 6.6 TFM_PLAN Object Type
• 6.7 Coordinate Systems Data Structures
  • 6.7.1 SDO_COORD_AXES Table
  • 6.7.2 SDO_COORD_AXIS_NAMES Table
  • 6.7.3 SDO_COORD_OP_METHODS Table
  • 6.7.4 SDO_COORD_OP_PARAM_USE Table
  • 6.7.5 SDO_COORD_OP_PARAM_VALS Table
  • 6.7.6 SDO_COORD_OP_PARAMS Table
  • 6.7.7 SDO_COORD_OP_PATHS Table
  • 6.7.8 SDO_COORD_OPS Table
  • 6.7.9 SDO_COORD_REF_SYS Table
  • 6.7.10 SDO_COORD_REF_SYSTEM View
  • 6.7.11 SDO_COORD_SYS Table
  • 6.7.12 SDO_CRS_COMPOUND View
  • 6.7.13 SDO_CRS_ENGINEERING View
  • 6.7.14 SDO_CRS_GEOCENTRIC View
  • 6.7.15 SDO_CRS_GEOGRAPHIC2D View
  • 6.7.16 SDO_CRS_GEOGRAPHIC3D View
  • 6.7.17 SDO_CRS_PROJECTED View
  • 6.7.18 SDO_CRS_VERTICAL View
  • 6.7.19 SDO_DATUM_ENGINEERING View
  • 6.7.20 SDO_DATUM_GEODETIC View
  • 6.7.21 SDO_DATUM_VERTICAL View
  • 6.7.22 SDO_DATUMS Table
  • 6.7.23 SDO_ELLIPSOIDS Table
  • 6.7.24 SDO_PREFERRED_OPS_SYSTEM Table
  • 6.7.25 SDO_PREFERRED_OPS_USER Table
  • 6.7.26 SDO_PRIME_MERIDIANS Table
  • 6.7.27 SDO_UNITS_OF_MEASURE Table
  • 6.7.28 Relationships Among Coordinate System Tables and Views
  • 6.7.29 Finding Information About EPSG-Based Coordinate Systems
    • 6.7.29.1 Geodetic Coordinate Systems
    • 6.7.29.2 Projected Coordinate Systems
• 6.8 Legacy Tables and Views
  • 6.8.1 MDSYS.CS_SRS Table
    • 6.8.1.1 Well-Known Text (WKT)
    • 6.8.1.2 US-American and European Notations for Datum Parameters
    • 6.8.1.3 Procedures for Updating the Well-Known Text
  • 6.8.2 MDSYS.SDO_ANGLE_UNITS View
  • 6.8.3 MDSYS.SDO_AREA_UNITS View
  • 6.8.4 MDSYS.SDO_DATUMS_OLD_FORMAT and SDO_DATUMS_OLD_SNAPSHOT Tables
  • 6.8.5 MDSYS.SDO_DIST_UNITS View
  • 6.8.6 MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT and SDO_ELLIPSOIDS_OLD_SNAPSHOT Tables
  • 6.8.7 MDSYS.SDO_PROJECTIONS_OLD_FORMAT and SDO_PROJECTIONS_OLD_SNAPSHOT Tables
• 6.9 Creating a User-Defined Coordinate Reference System
  • 6.9.1 Creating a Geodetic CRS
  • 6.9.2 Creating a Projected CRS
  • 6.9.3 Creating a Vertical CRS
  • 6.9.4 Creating a Compound CRS
  • 6.9.5 Creating a Geographic 3D CRS
  • 6.9.6 Creating a Transformation Operation
  • 6.9.7 Using British Grid Transformation OSTN02/OSGM02 (EPSG Method 9633)
• 6.10 Notes and Restrictions with Coordinate Systems Support
  • 6.10.1 Different Coordinate Systems for Geometries with Operators and Functions
  • 6.10.2 3D LRS Functions Not Supported with Geodetic Data
  • 6.10.3 Functions Supported by Approximations with Geodetic Data
  • 6.10.4 Unknown CRS and NaC Coordinate Reference Systems
• 6.11 U.S. National Grid Support
• 6.12 Google Maps Considerations
• 6.13 Example of Coordinate System Transformation

7 Linear Referencing System

• 7.1 Terms and Concepts
  • 7.1.1 Geometric Segments (LRS Segments)
  • 7.1.2 Shape Points
  • 7.1.3 Direction of a Geometric Segment
  • 7.1.4 Measure (Linear Measure)
  • 7.1.5 Offset
  • 7.1.6 Measure Populating
  • 7.1.7 Measure Range of a Geometric Segment
  • 7.1.8 Projection
  • 7.1.9 LRS Point
  • 7.1.10 Linear Features
  • 7.1.11 Measures with Multiline Strings and Polygons with Holes
• 7.2 LRS Data Model
• 7.3 Indexing of LRS Data
• 7.4 3D Formats of LRS Functions
• 7.5 LRS Operations
  • 7.5.1 Defining a Geometric Segment
  • 7.5.2 Redefining a Geometric Segment
  • 7.5.3 Clipping a Geometric Segment
  • 7.5.4 Splitting a Geometric Segment
  • 7.5.5 Concatenating Geometric Segments
  • 7.5.6 Scaling a Geometric Segment
  • 7.5.7 Offsetting a Geometric Segment
  • 7.5.8 Locating a Point on a Geometric Segment
  • 7.5.9 Projecting a Point onto a Geometric Segment
  • 7.5.10 Converting LRS Geometries
• 7.6 Tolerance Values with LRS Functions
• 7.7 Example of LRS Functions

8 Spatial Analysis and Mining

• 8.1 Spatial Information and Data Mining Applications
• 8.2 Spatial Binning for Detection of Regional Patterns
• 8.3 Materializing Spatial Correlation
• 8.4 Colocation Mining
• 8.5 Spatial Clustering
• 8.6 Location Prospecting

9 Extending Spatial Indexing Capabilities

• 9.1 SDO_GEOMETRY Objects in User-Defined Type Definitions
• 9.2 SDO_GEOMETRY Objects in Function-Based Indexes
  • 9.2.1 Example: Function with Standard Types
  • 9.2.2 Example: Function with a User-Defined Object Type

Part II Spatial Web Services

10 Introduction to Spatial Web Services

• 10.1 Types of Spatial Web Services
• 10.2 Types of Users of Spatial Web Services
• 10.3 Setting Up the Client for Spatial Web Services
• 10.4 Demo Files for Sample Java Client

11 Geocoding Address Data

• 11.1 Concepts for Geocoding
  • 11.1.1 Address Representation
  • 11.1.2 Match Modes
  • 11.1.3 Match Codes
  • 11.1.4 Error Messages for Output Geocoded Addresses
  • 11.1.5 Match Vector for Output Geocoded Addresses
• 11.2 Data Types for Geocoding
  • 11.2.1 SDO_GEO_ADDR Type
  • 11.2.2 SDO_ADDR_ARRAY Type
  • 11.2.3 SDO_KEYWORDARRAY Type
• 11.3 Using the Geocoding Capabilities
• 11.4 Geocoding from a Place Name
• 11.5 Data Structures for Geocoding
  • 11.5.1 GC_ADDRESS_POINT_<suffix> Table and Index
  • 11.5.2 GC_AREA_<suffix> Table
  • 11.5.3 GC_COUNTRY_PROFILE Table
  • 11.5.4 GC_INTERSECTION_<suffix> Table
  • 11.5.5 GC_PARSER_PROFILES Table
  • 11.5.6 GC_PARSER_PROFILEAFS Table
    • 11.5.6.1 ADDRESS_FORMAT_STRING Description
  • 11.5.7 GC_POI_<suffix> Table
  • 11.5.8 GC_POSTAL_CODE_<suffix> Table
  • 11.5.9 GC_ROAD_<suffix> Table
  • 11.5.10 GC_ROAD_SEGMENT_<suffix> Table
  • 11.5.11 Indexes on Tables for Geocoding
• 11.6 Installing the Profile Tables
• 11.7 Using the Geocoding Service (XML API)
  • 11.7.1 Deploying and Configuring the J2EE Geocoder
    • 11.7.1.1 Configuring the geocodercfg.xml File
  • 11.7.2 Geocoding Request XML Schema Definition and Example
  • 11.7.3 Geocoding Response XML Schema Definition and Example

12 Business Directory (Yellow Pages) Support

• 12.1 Business Directory Concepts
• 12.2 Using the Business Directory Capabilities
• 12.3 Data Structures for Business Directory Support
  • 12.3.1 OPENLS_DIR_BUSINESSES Table
  • 12.3.2 OPENLS_DIR_BUSINESS_CHAINS Table
  • 12.3.3 OPENLS_DIR_CATEGORIES Table
  • 12.3.4 OPENLS_DIR_CATEGORIZATIONS Table
  • 12.3.5 OPENLS_DIR_CATEGORY_TYPES Table
  • 12.3.6 OPENLS_DIR_SYNONYMS Table

13 Routing Engine

• 13.1 Multi-Address Routing
• 13.2 Deploying and Configuring the Routing Engine
  • 13.2.1 Configuring the web.xml File
• 13.3 Routing Engine XML API
  • 13.3.1 Route Request and Response Examples
  • 13.3.2 Route Request DTD
    • 13.3.2.1 route_request Element
    • 13.3.2.2 route_request Attributes
    • 13.3.2.3 input_location Element
    • 13.3.2.4 pre_geocoded_location Element
  • 13.3.3 Route Response DTD
  • 13.3.4 Batch Route Request and Response Examples
  • 13.3.5 Batch Route Request DTD
    • 13.3.5.1 batch_route_request Element
    • 13.3.5.2 batch_route_request Attributes
  • 13.3.6 Batch Route Response DTD
• 13.4 Data Structures Used by the Routing Engine
  • 13.4.1 EDGE Table
  • 13.4.2 NODE Table
  • 13.4.3 PARTITION Table
  • 13.4.4 SIGN_POST Table

14 OpenLS Support

• 14.1 Supported OpenLS Services
• 14.2 OpenLS Application Programming Interfaces
• 14.3 OpenLS Service Support and Examples
  • 14.3.1 OpenLS Geocoding
  • 14.3.2 OpenLS Mapping
  • 14.3.3 OpenLS Routing
  • 14.3.4 OpenLS Directory Service (YP)

15 Web Feature Service (WFS) Support

• 15.1 WFS Engine
• 15.2 Managing Feature Types
  • 15.2.1 Capabilities Documents
• 15.3 Request and Response XML Examples
• 15.4 Java API for WFS Administration
  • 15.4.1 createXMLTableIndex method
  • 15.4.2 dropFeatureType method
  • 15.4.3 dropXMLTableIndex method
  • 15.4.4 getIsXMLTableIndexCreated method
  • 15.4.5 grantFeatureTypeToUser method
  • 15.4.6 grantMDAccessToUser method
  • 15.4.7 publishFeatureType method
    • 15.4.7.1 Related Classes for publishFeatureType
  • 15.4.8 revokeFeatureTypeFromUser method
  • 15.4.9 revokeMDAccessFromUser method
  • 15.4.10 setXMLTableIndexInfo method
• 15.5 Using WFS with Oracle Workspace Manager

16 Catalog Services for the Web (CSW) Support

• 16.1 CSW Engine and Architecture
• 16.2 CSW APIs and Configuration
  • 16.2.1 Capabilities Documents
  • 16.2.2 Spatial Path Extractor Function (extractSDO)
    • 16.2.2.1 Registering and Unregistering the extractSDO Function
• 16.3 Request and Response XML Examples
• 16.4 Java API for CSW Administration
  • 16.4.1 createXMLTableIndex method
  • 16.4.2 deleteDomainInfo method
  • 16.4.3 deleteRecordViewMap method
  • 16.4.4 disableVersioning method
  • 16.4.5 dropRecordType method
  • 16.4.6 dropXMLTableIndex method
  • 16.4.7 enableVersioning method
  • 16.4.8 getIsXMLTableIndexCreated method
  • 16.4.9 getRecordTypeId method
  • 16.4.10 grantMDAccessToUser method
  • 16.4.11 grantRecordTypeToUser method
  • 16.4.12 publishRecordType method
    • 16.4.12.1 Related Classes for publishRecordType
  • 16.4.13 registerTypePluginMap method
  • 16.4.14 revokeMDAccessFromUser method
  • 16.4.15 revokeRecordTypeFromUser method
  • 16.4.16 setCapabilitiesInfo method
  • 16.4.17 setDomainInfo method
  • 16.4.18 setRecordViewMap method
  • 16.4.19 setXMLTableIndexInfo method

17 Security Considerations for Spatial Web Services

• 17.1 User Management
  • 17.1.1 Identity Propagation to the Database
  • 17.1.2 Caching and User Administration
• 17.2 Access Control and Versioning
  • 17.2.1 Virtual Private Databases
  • 17.2.2 Workspace Manager
• 17.3 Deploying and Configuring the .ear File
  • 17.3.1 Adding Spatial Service Handlers
• 17.4 Interfaces for Spatial Web Services
  • 17.4.1 SOAP/WSS Interface
  • 17.4.2 XML (Non-SOAP) Interface
  • 17.4.3 PL/SQL Interface (OpenLS Only)
  • 17.4.4 Level of Security, by Interface

Part III Reference Information

18 SQL Statements for Indexing Spatial Data

• ALTER INDEX
• ALTER INDEX REBUILD
• ALTER INDEX RENAME TO
• CREATE INDEX
• DROP INDEX

19 Spatial Operators

• SDO_ANYINTERACT
• SDO_CONTAINS
• SDO_COVEREDBY
• SDO_COVERS
• SDO_EQUAL
• SDO_FILTER
• SDO_INSIDE
• SDO_JOIN
• SDO_NN
• SDO_NN_DISTANCE
• SDO_ON
• SDO_OVERLAPBDYDISJOINT
• SDO_OVERLAPBDYINTERSECT
• SDO_OVERLAPS
• SDO_RELATE
• SDO_TOUCH
• SDO_WITHIN_DISTANCE

20 Spatial Aggregate Functions

• SDO_AGGR_CENTROID
• SDO_AGGR_CONCAT_LINES
• SDO_AGGR_CONVEXHULL
• SDO_AGGR_LRS_CONCAT
• SDO_AGGR_MBR
• SDO_AGGR_SET_UNION
• SDO_AGGR_UNION

21 SDO_CS Package (Coordinate System Transformation)

• SDO_CS.ADD_PREFERENCE_FOR_OP
• SDO_CS.CONVERT_NADCON_TO_XML
• SDO_CS.CONVERT_NTV2_TO_XML
• SDO_CS.CONVERT_XML_TO_NADCON
• SDO_CS.CONVERT_XML_TO_NTV2
• SDO_CS.CREATE_CONCATENATED_OP
• SDO_CS.CREATE_OBVIOUS_EPSG_RULES
• SDO_CS.CREATE_PREF_CONCATENATED_OP
• SDO_CS.DELETE_ALL_EPSG_RULES
• SDO_CS.DELETE_OP
• SDO_CS.DETERMINE_CHAIN
• SDO_CS.DETERMINE_DEFAULT_CHAIN
• SDO_CS.FIND_GEOG_CRS
• SDO_CS.FIND_PROJ_CRS
• SDO_CS.FIND_SRID
• SDO_CS.FROM_OGC_SIMPLEFEATURE_SRS
• SDO_CS.FROM_USNG
• SDO_CS.GET_EPSG_DATA_VERSION
• SDO_CS.MAKE_2D
• SDO_CS.MAKE_3D
• SDO_CS.MAP_EPSG_SRID_TO_ORACLE
• SDO_CS.MAP_ORACLE_SRID_TO_EPSG
• SDO_CS.REVOKE_PREFERENCE_FOR_OP
• SDO_CS.TO_OGC_SIMPLEFEATURE_SRS
• SDO_CS.TO_USNG
• SDO_CS.TRANSFORM
• SDO_CS.TRANSFORM_LAYER
• SDO_CS.UPDATE_WKTS_FOR_ALL_EPSG_CRS
• SDO_CS.UPDATE_WKTS_FOR_EPSG_CRS
• SDO_CS.UPDATE_WKTS_FOR_EPSG_DATUM
• SDO_CS.UPDATE_WKTS_FOR_EPSG_ELLIPS
• SDO_CS.UPDATE_WKTS_FOR_EPSG_OP
• SDO_CS.UPDATE_WKTS_FOR_EPSG_PARAM
• SDO_CS.UPDATE_WKTS_FOR_EPSG_PM
• SDO_CS.VALIDATE_WKT

22 SDO_CSW_PROCESS Package (CSW Processing)

• SDO_CSW_PROCESS.DeleteCapabilitiesInfo
• SDO_CSW_PROCESS.DeleteDomainInfo
• SDO_CSW_PROCESS.DeletePluginMap
• SDO_CSW_PROCESS.DeleteRecordViewMap
• SDO_CSW_PROCESS.GetRecordTypeId
• SDO_CSW_PROCESS.InsertCapabilitiesInfo
• SDO_CSW_PROCESS.InsertDomainInfo
• SDO_CSW_PROCESS.InsertPluginMap
• SDO_CSW_PROCESS.InsertRecordViewMap
• SDO_CSW_PROCESS.InsertRtDataUpdated
• SDO_CSW_PROCESS.InsertRtMDUpdated

23 SDO_GCDR Package (Geocoding)

• SDO_GCDR.CREATE_PROFILE_TABLES
• SDO_GCDR.GEOCODE
• SDO_GCDR.GEOCODE_ADDR
• SDO_GCDR.GEOCODE_ADDR_ALL
• SDO_GCDR.GEOCODE_ALL
• SDO_GCDR.GEOCODE_AS_GEOMETRY
• SDO_GCDR.REVERSE_GEOCODE

24 SDO_GEOM Package (Geometry)

• SDO_GEOM.RELATE
• SDO_GEOM.SDO_ALPHA_SHAPE
• SDO_GEOM.SDO_ARC_DENSIFY
• SDO_GEOM.SDO_AREA
• SDO_GEOM.SDO_BUFFER
• SDO_GEOM.SDO_CENTROID
• SDO_GEOM.SDO_CLOSEST_POINTS
• SDO_GEOM.SDO_CONCAVEHULL
• SDO_GEOM.SDO_CONCAVEHULL_BOUNDARY
• SDO_GEOM.SDO_CONVEXHULL
• SDO_GEOM.SDO_DIFFERENCE
• SDO_GEOM.SDO_DISTANCE
• SDO_GEOM.SDO_INTERSECTION
• SDO_GEOM.SDO_LENGTH
• SDO_GEOM.SDO_MAX_MBR_ORDINATE
• SDO_GEOM.SDO_MBR
• SDO_GEOM.SDO_MIN_MBR_ORDINATE
• SDO_GEOM.SDO_POINTONSURFACE
• SDO_GEOM.SDO_TRIANGULATE
• SDO_GEOM.SDO_UNION
• SDO_GEOM.SDO_VOLUME
• SDO_GEOM.SDO_XOR
• SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
• SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT
• SDO_GEOM.WITHIN_DISTANCE

25 SDO_LRS Package (Linear Referencing System)

• SDO_LRS.CLIP_GEOM_SEGMENT
• SDO_LRS.CONCATENATE_GEOM_SEGMENTS
• SDO_LRS.CONNECTED_GEOM_SEGMENTS
• SDO_LRS.CONVERT_TO_LRS_DIM_ARRAY
• SDO_LRS.CONVERT_TO_LRS_GEOM
• SDO_LRS.CONVERT_TO_LRS_LAYER
• SDO_LRS.CONVERT_TO_STD_DIM_ARRAY
• SDO_LRS.CONVERT_TO_STD_GEOM
• SDO_LRS.CONVERT_TO_STD_LAYER
• SDO_LRS.DEFINE_GEOM_SEGMENT
• SDO_LRS.DYNAMIC_SEGMENT
• SDO_LRS.FIND_LRS_DIM_POS
• SDO_LRS.FIND_MEASURE
• SDO_LRS.FIND_OFFSET
• SDO_LRS.GEOM_SEGMENT_END_MEASURE
• SDO_LRS.GEOM_SEGMENT_END_PT
• SDO_LRS.GEOM_SEGMENT_LENGTH
• SDO_LRS.GEOM_SEGMENT_START_MEASURE
• SDO_LRS.GEOM_SEGMENT_START_PT
• SDO_LRS.GET_MEASURE
• SDO_LRS.GET_NEXT_SHAPE_PT
• SDO_LRS.GET_NEXT_SHAPE_PT_MEASURE
• SDO_LRS.GET_PREV_SHAPE_PT
• SDO_LRS.GET_PREV_SHAPE_PT_MEASURE
• SDO_LRS.IS_GEOM_SEGMENT_DEFINED
• SDO_LRS.IS_MEASURE_DECREASING
• SDO_LRS.IS_MEASURE_INCREASING
• SDO_LRS.IS_SHAPE_PT_MEASURE
• SDO_LRS.LOCATE_PT
• SDO_LRS.LRS_INTERSECTION
• SDO_LRS.MEASURE_RANGE
• SDO_LRS.MEASURE_TO_PERCENTAGE
• SDO_LRS.OFFSET_GEOM_SEGMENT
• SDO_LRS.PERCENTAGE_TO_MEASURE
• SDO_LRS.PROJECT_PT
• SDO_LRS.REDEFINE_GEOM_SEGMENT
• SDO_LRS.RESET_MEASURE
• SDO_LRS.REVERSE_GEOMETRY
• SDO_LRS.REVERSE_MEASURE
• SDO_LRS.SCALE_GEOM_SEGMENT
• SDO_LRS.SET_PT_MEASURE
• SDO_LRS.SPLIT_GEOM_SEGMENT
• SDO_LRS.TRANSLATE_MEASURE
• SDO_LRS.VALID_GEOM_SEGMENT
• SDO_LRS.VALID_LRS_PT
• SDO_LRS.VALID_MEASURE
• SDO_LRS.VALIDATE_LRS_GEOMETRY

26 SDO_MIGRATE Package (Upgrading)

• SDO_MIGRATE.TO_CURRENT

27 SDO_OLS Package (OpenLS)

• SDO_OLS.MakeOpenLSClobRequest
• SDO_OLS.MakeOpenLSRequest

28 SDO_PC_PKG Package (Point Clouds)

• SDO_PC_PKG.CLIP_PC
• SDO_PC_PKG.CREATE_PC
• SDO_PC_PKG.DROP_DEPENDENCIES
• SDO_PC_PKG.GET_PT_IDS
• SDO_PC_PKG.INIT
• SDO_PC_PKG.TO_GEOMETRY

29 SDO_SAM Package (Spatial Analysis and Mining)

• SDO_SAM.AGGREGATES_FOR_GEOMETRY
• SDO_SAM.AGGREGATES_FOR_LAYER
• SDO_SAM.BIN_GEOMETRY
• SDO_SAM.BIN_LAYER
• SDO_SAM.COLOCATED_REFERENCE_FEATURES
• SDO_SAM.SIMPLIFY_GEOMETRY
• SDO_SAM.SIMPLIFY_LAYER
• SDO_SAM.SPATIAL_CLUSTERS
• SDO_SAM.TILED_AGGREGATES
• SDO_SAM.TILED_BINS

30 SDO_TIN_PKG Package (TINs)

• SDO_TIN_PKG.CLIP_TIN
• SDO_TIN_PKG.CREATE_TIN
• SDO_TIN_PKG.DROP_DEPENDENCIES
• SDO_TIN_PKG.INIT
• SDO_TIN_PKG.TO_GEOMETRY

31 SDO_TUNE Package (Tuning)

• SDO_TUNE.AVERAGE_MBR
• SDO_TUNE.ESTIMATE_RTREE_INDEX_SIZE
• SDO_TUNE.EXTENT_OF
• SDO_TUNE.MIX_INFO
• SDO_TUNE.QUALITY_DEGRADATION

32 SDO_UTIL Package (Utility)

• SDO_UTIL.AFFINETRANSFORMS
• SDO_UTIL.APPEND
• SDO_UTIL.BEARING_TILT_FOR_POINTS
• SDO_UTIL.CIRCLE_POLYGON
• SDO_UTIL.CONCAT_LINES
• SDO_UTIL.CONVERT_UNIT
• SDO_UTIL.DROP_WORK_TABLES
• SDO_UTIL.ELLIPSE_POLYGON
• SDO_UTIL.EXTRACT
• SDO_UTIL.EXTRACT_ALL
• SDO_UTIL.EXTRACT3D
• SDO_UTIL.EXTRUDE
• SDO_UTIL.FROM_GML311GEOMETRY
• SDO_UTIL.FROM_GMLGEOMETRY
• SDO_UTIL.FROM_KMLGEOMETRY
• SDO_UTIL.FROM_WKBGEOMETRY
• SDO_UTIL.FROM_WKTGEOMETRY
• SDO_UTIL.GETNUMELEM
• SDO_UTIL.GETNUMVERTICES
• SDO_UTIL.GETVERTICES
• SDO_UTIL.INITIALIZE_INDEXES_FOR_TTS
• SDO_UTIL.INTERIOR_POINT
• SDO_UTIL.POINT_AT_BEARING
• SDO_UTIL.POLYGONTOLINE
• SDO_UTIL.PREPARE_FOR_TTS
• SDO_UTIL.RECTIFY_GEOMETRY
• SDO_UTIL.REMOVE_DUPLICATE_VERTICES
• SDO_UTIL.REVERSE_LINESTRING
• SDO_UTIL.SIMPLIFY
• SDO_UTIL.TO_GML311GEOMETRY
• SDO_UTIL.TO_GMLGEOMETRY
• SDO_UTIL.TO_KMLGEOMETRY
• SDO_UTIL.TO_WKBGEOMETRY
• SDO_UTIL.TO_WKTGEOMETRY
• SDO_UTIL.VALIDATE_WKBGEOMETRY
• SDO_UTIL.VALIDATE_WKTGEOMETRY

33 SDO_WFS_LOCK Package (WFS)

• SDO_WFS_LOCK.EnableDBTxns
• SDO_WFS_LOCK.RegisterFeatureTable
• SDO_WFS_LOCK.UnRegisterFeatureTable

34 SDO_WFS_PROCESS Package (WFS Processing)

• SDO_WFS_PROCESS.DropFeatureType
• SDO_WFS_PROCESS.DropFeatureTypes
• SDO_WFS_PROCESS.GenCollectionProcs
• SDO_WFS_PROCESS.GetFeatureTypeId
• SDO_WFS_PROCESS.GrantFeatureTypeToUser
• SDO_WFS_PROCESS.GrantMDAccessToUser
• SDO_WFS_PROCESS.InsertCapabilitiesInfo
• SDO_WFS_PROCESS.InsertFtDataUpdated
• SDO_WFS_PROCESS.InsertFtMDUpdated
• SDO_WFS_PROCESS.PopulateFeatureTypeXMLInfo
• SDO_WFS_PROCESS.PublishFeatureType
• SDO_WFS_PROCESS.RegisterMTableView
• SDO_WFS_PROCESS.RevokeFeatureTypeFromUser
• SDO_WFS_PROCESS.RevokeMDAccessFromUser
• SDO_WFS_PROCESS.UnRegisterMTableView

Part IV Supplementary Information

A Installation, Compatibility, and Upgrade

• A.1 Ensuring That GeoRaster Works Properly After an Installation or Upgrade
• A.2 Index Maintenance Before and After an Upgrade (WFS and CSW)
• A.3 Increasing the Size of Ordinate Arrays to Support Very Large Geometries

B Oracle Locator

• B.1 Installing and Deinstalling Locator or Spatial Manually

C Complex Spatial Queries: Examples

• C.1 Tables Used in the Examples
• C.2 SDO_WITHIN_DISTANCE Examples
• C.3 SDO_NN Examples
• C.4 SDO_AGGR_UNION Example

D Loading ESRI Shapefiles into Spatial

• D.1 Usage of the Shapefile Converter
• D.2 Examples of the Shapefile Converter

Glossary

Index