Go to main content
1/57
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release for Oracle Spatial and Graph Developer's Guide
Changes in Oracle Database 12
c
Release 2 (12.2)
GeoJSON Support
Web Coverage Service (WCS) 2.0.1 Support
Catalog Services for the Web (CSW) 2.0.2 Supported
New Spatial Web Services Administration Console for WFS, WCS, and CSW
Unified WFS, WCS, and CSW Framework and Architecture
Location Tracking Server Added
Location Data Enrichment Support
Routing Engine Can Incorporate Start Date and Time in Computations
Support for System-Managed Spatial Indexes
Composite B-tree Spatial Index on Points
Option to Use Ellipsoidal Distance with All Geodetic Data
Changes in Oracle Database 12
c
Release 1 (12.1.0.2)
Routing Engine Information Revised
Change in Behavior for SDO_GEOM.SDO_CLOSEST_POINTS
New and Changed SDO_GEOM Subprograms
GeoRaster Not Enabled by Default
Changes in Oracle Database 12
c
Release 1 (12.1.0.1)
New Features
NURBS Curve Support
Height Information Approximated for Certain 3D Geodetic Operations
New Spatial Metadata Views (3D Themes, Scenes, Viewframes)
New and Changed Aggregate Functions
New and Changed SDO_CS Subprograms
New and Changed SDO_GEOM Subprograms
New and Changed SDO_PC_PKG Subprograms
New and Changed SDO_TIN_PKG Subprograms
New and Changed SDO_UTIL Subprograms
New SDO_GEOM_MBR Operator
New SDO_POINTINPOLYGON Operator
SPATIAL_VECTOR_ACCELERATION System Parameter (VPA)
Other Changes
Part I Conceptual and Usage Information
1
Spatial Concepts
1.1
What Is Oracle Spatial and Graph?
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
Location Data Enrichment
1.13.1
ELOC_ADMIN_AREA_SEARCH Table
1.13.2
Adding User Data to the Geographic Name Hierarchy
1.14
GeoJSON Support in Oracle Spatial and Graph
1.15
NURBS Curve Support in Oracle Spatial and Graph
1.16
Spatial and Graph Java Application Programming Interface
1.17
Predefined User Accounts Created by Spatial and Graph
1.18
Performance and Tuning Information
1.19
OGC and ISO Compliance
1.20
Spatial and Graph Release (Version) Number
1.21
SPATIAL_VECTOR_ACCELERATION System Parameter
1.22
Spatially Enabling a Table
1.23
Moving Spatial Metadata (MDSYS.MOVE_SDO)
1.24
Spatial Application Hardware Requirement Considerations
1.25
Spatial and Graph Error Messages
1.26
Spatial Examples
1.27
README File for Spatial and Graph 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
NURBS Curve
2.7.9
Several Two-Dimensional Geometry Types
2.7.10
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
Other Spatial Metadata Views
2.9.1
xxx_SDO_3DTHEMES Views
2.9.2
xxx_SDO_SCENES Views
2.9.3
xxx_SDO_VIEWFRAMES Views
2.10
Spatial Index-Related Structures
2.10.1
Spatial Index Views
2.10.1.1
xxx_SDO_INDEX_INFO Views
2.10.1.2
xxx_SDO_INDEX_METADATA Views
2.10.2
Spatial Index Table Definition
2.10.3
R-Tree Index Sequence Object
2.11
Unit of Measurement Support
2.11.1
Creating a User-Defined Unit of Measurement
3
SQL Multimedia Type Support
3.1
ST_GEOMETRY and SDO_GEOMETRY Interoperability
3.2
ST_xxx Functions and Spatial and Graph Counterparts
3.3
Tolerance Value with SQL Multimedia Types
3.4
Avoiding Name Conflicts
3.5
Annotation Text Type and Views
3.5.1
Using the ST_ANNOTATION_TEXT Constructor
3.5.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
Using System-Managed Spatial Indexes
5.1.1.1
Spatial Indexing Example: Interval Partitioning
5.1.1.2
Spatial Indexing Example: Virtual Column Partitioning
5.1.2
Constraining Data to a Geometry Type
5.1.3
Creating a Composite B-tree Spatial Index on Points
5.1.4
Creating a Cross-Schema Index
5.1.5
Using Partitioned Spatial Indexes
5.1.5.1
Creating a Local Partitioned Spatial Index
5.1.6
Exchanging Partitions Including Indexes
5.1.7
Export and Import Considerations with Spatial Indexes and Data
5.1.8
Distributed and Oracle XA Transactions Not Supported with R-Tree Spatial Indexes
5.1.9
Enabling Access to Spatial Index Statistics
5.1.10
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
Distance: Spherical versus Ellipsoidal with Geodetic Data
6.2.6
Other Considerations and Requirements with Geodetic Data
6.3
Local Coordinate Support
6.4
EPSG Model and Spatial and Graph
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.5.5
3D Equivalent for WGS 84?
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
Geohash Support
6.13
Google Maps Considerations
6.14
Example of Coordinate System Transformation
7
Linear Referencing System
7.1
LRS 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
Location Tracking Server
8.1
About the Location Tracking Server
8.2
Location Tracking Regions
8.3
Data Types for the Location Tracking Server
8.4
Data Structures and Workflow for the Location Tracking Server
9
Spatial Analysis and Mining
9.1
Spatial Information and Data Mining Applications
9.2
Spatial Binning for Detection of Regional Patterns
9.3
Materializing Spatial Correlation
9.4
Colocation Mining
9.5
Spatial Clustering
9.6
Location Prospecting
10
Extending Spatial Indexing Capabilities
10.1
SDO_GEOMETRY Objects in User-Defined Type Definitions
10.2
SDO_GEOMETRY Objects in Function-Based Indexes
10.2.1
Example: Function with Standard Types
10.2.2
Example: Function with a User-Defined Object Type
Part II Spatial Web Services
11
Introduction to Spatial Web Services
11.1
Types of Spatial Web Services
11.2
Types of Users of Spatial Web Services
11.3
Deploying and Configuring Spatial Web Services
11.4
Spatial Web Services Administration Console
12
Geocoding Address Data
12.1
Concepts for Geocoding
12.1.1
Address Representation
12.1.2
Match Modes
12.1.3
Match Codes
12.1.4
Error Messages for Output Geocoded Addresses
12.1.5
Match Vector for Output Geocoded Addresses
12.2
Data Types for Geocoding
12.2.1
SDO_GEO_ADDR Type
12.2.2
SDO_ADDR_ARRAY Type
12.2.3
SDO_KEYWORDARRAY Type
12.3
Using the Geocoding Capabilities
12.4
Geocoding from a Place Name
12.5
Data Structures for Geocoding
12.5.1
GC_ADDRESS_POINT_<suffix> Table and Index
12.5.2
GC_AREA_<suffix> Table
12.5.3
GC_COUNTRY_PROFILE Table
12.5.4
GC_INTERSECTION_<suffix> Table
12.5.5
GC_PARSER_PROFILES Table
12.5.6
GC_PARSER_PROFILEAFS Table
12.5.6.1
ADDRESS_FORMAT_STRING Description
12.5.7
GC_POI_<suffix> Table
12.5.8
GC_POSTAL_CODE_<suffix> Table
12.5.9
GC_ROAD_<suffix> Table
12.5.10
GC_ROAD_SEGMENT_<suffix> Table
12.5.11
Indexes on Tables for Geocoding
12.6
Installing the Profile Tables
12.7
Using the Geocoding Service (XML API)
12.7.1
Deploying and Configuring the J2EE Geocoder
12.7.1.1
Configuring the geocodercfg.xml File
12.7.2
Geocoding Request XML Schema Definition and Example
12.7.3
Geocoding Response XML Schema Definition and Example
13
Business Directory (Yellow Pages) Support
13.1
Business Directory Concepts
13.2
Using the Business Directory Capabilities
13.3
Data Structures for Business Directory Support
13.3.1
OPENLS_DIR_BUSINESSES Table
13.3.2
OPENLS_DIR_BUSINESS_CHAINS Table
13.3.3
OPENLS_DIR_CATEGORIES Table
13.3.4
OPENLS_DIR_CATEGORIZATIONS Table
13.3.5
OPENLS_DIR_CATEGORY_TYPES Table
13.3.6
OPENLS_DIR_SYNONYMS Table
14
Routing Engine
14.1
Routing
14.1.1
Simple Route Request
14.1.2
Simple Multi-address Route Request
14.1.3
Traveling Salesperson (TSP) Route Request
14.1.4
Batched Route Request
14.1.5
Batch Mode Route Request
14.2
Deploying the Routing Engine
14.2.1
Unpacking the routeserver.ear File
14.2.2
Editing the web.xml File for Routing Engine Deployment
14.2.3
Deploying the Routing Engine on WebLogic Server
14.3
Routing Engine XML API
14.3.1
Route Request and Response Examples
14.3.2
Route Request XML Schema Definition
14.3.2.1
route_request Element
14.3.2.2
route_request Attributes
14.3.2.3
input_location Element
14.3.2.4
pre_geocoded_location Element
14.3.3
Route Response XML Schema Definition
14.3.4
Batch Mode Route Request and Response Examples
14.3.5
Batch Route Request XML Schema Definition
14.3.5.1
batch_route_request Element
14.3.5.2
batch_route_request Attributes
14.3.6
Batch Route Response XML Schema
14.4
Data Structures Used by the Routing Engine
14.4.1
EDGE Table
14.4.2
NODE Table
14.4.3
PARTITION Table
14.4.4
SIGN_POST Table
14.5
User Data Structures Used by the Routing Engine
14.5.1
Turn Restriction User Data
14.5.1.1
ROUTER_CONDITION Table
14.5.1.2
ROUTER_NAV_STRAND Table
14.5.1.3
ROUTER_TURN_RESTRICTION_DATA Table
14.5.2
Trucking User Data
14.5.2.1
ROUTER_TRANSPORT Table
14.5.2.2
ROUTER_TRUCKING_DATA Table
14.5.3
Time Zone User Data
14.5.3.1
ROUTER_TIMEZONES Table
14.5.3.2
ROUTER_TIMEZONE_DATA Table
14.5.4
Traffic User Data
14.5.4.1
TP_USER_DATA Table
15
OpenLS Support
15.1
Supported OpenLS Services
15.2
OpenLS Application Programming Interfaces
15.3
OpenLS Service Support and Examples
15.3.1
OpenLS Geocoding
15.3.2
OpenLS Mapping
15.3.3
OpenLS Routing
15.3.4
OpenLS Directory Service (YP)
16
Web Feature Service (WFS) Support
16.1
WFS Engine
16.2
Configuring the WFS Engine
16.2.1
Editing the WFSConfig.xml File
16.2.2
Data Source Setup for the WFS Engine
16.3
Managing Feature Types
16.4
Capabilities Documents (WFS)
16.5
WFS Operations: Requests and Responses with XML Examples
16.6
WFS Administration Console
16.7
Diagnosing WFS Issues
16.8
Using WFS with Oracle Workspace Manager
17
Web Coverage Service (WCS) Support
17.1
Web Coverage Service Architecture
17.2
Database Schemas for WCS
17.3
Database Objects Used for WCS
17.4
PL/SQL Subprograms for Using WCS
17.5
Setting Up WCS Using WebLogic Server
17.5.1
Configuring the Database Schemas
17.5.2
Setting Up WCS Data Sources
17.5.3
Configuring GDAL for the WCS Server
17.6
WCS Administration Console
17.7
Oracle Implementation Extension for WCS
17.8
WCS Operations: Requests and Responses with XML Examples
17.8.1
GetCapabilities Operation (WCS)
17.8.2
DescribeCoverage Operation (WCS)
17.8.3
GetCoverage Operation (WCS)
17.9
WCS Extensions Implemented
17.10
Diagnosing WCS Issues
18
Catalog Services for the Web (CSW) Support
18.1
CSW Engine and Architecture
18.2
Database Schema and Objects for CSW
18.3
Configuring and Deploying the CSW Engine
18.4
Loading CSW 2.0.2 Data
18.5
Capabilities Documents (CSW)
18.6
CSW Administration Console
18.7
CSW Operations: Requests and Responses with XML Examples
18.7.1
GetCapabilities Operation (CSW)
18.7.2
DescribeRecord Operation (CSW)
18.7.3
GetRecords Operation (CSW)
18.7.4
GetRecordById Operation (CSW)
18.8
Diagnosing CSW Issues
Part III Reference Information
19
SQL Statements for Indexing Spatial Data
19.1
ALTER INDEX
19.2
ALTER INDEX REBUILD
19.3
ALTER INDEX RENAME TO
19.4
CREATE INDEX
19.5
DROP INDEX
20
Spatial Operators
20.1
SDO_ANYINTERACT
20.2
SDO_CONTAINS
20.3
SDO_COVEREDBY
20.4
SDO_COVERS
20.5
SDO_EQUAL
20.6
SDO_FILTER
20.7
SDO_INSIDE
20.8
SDO_JOIN
20.9
SDO_NN
20.10
SDO_NN_DISTANCE
20.11
SDO_ON
20.12
SDO_OVERLAPBDYDISJOINT
20.13
SDO_OVERLAPBDYINTERSECT
20.14
SDO_OVERLAPS
20.15
SDO_POINTINPOLYGON
20.16
SDO_RELATE
20.17
SDO_TOUCH
20.18
SDO_WITHIN_DISTANCE
21
Spatial Aggregate Functions
21.1
SDO_AGGR_CENTROID
21.2
SDO_AGGR_CONCAT_LINES
21.3
SDO_AGGR_CONVEXHULL
21.4
SDO_AGGR_LRS_CONCAT
21.5
SDO_AGGR_MBR
21.6
SDO_AGGR_SET_UNION
21.7
SDO_AGGR_UNION
22
SDO_CS Package (Coordinate System Transformation)
22.1
SDO_CS.ADD_PREFERENCE_FOR_OP
22.2
SDO_CS.CONVERT_3D_SRID_TO_2D
22.3
SDO_CS.CONVERT_NADCON_TO_XML
22.4
SDO_CS.CONVERT_NTV2_TO_XML
22.5
SDO_CS.CONVERT_XML_TO_NADCON
22.6
SDO_CS.CONVERT_XML_TO_NTV2
22.7
SDO_CS.CREATE_CONCATENATED_OP
22.8
SDO_CS.CREATE_OBVIOUS_EPSG_RULES
22.9
SDO_CS.CREATE_PREF_CONCATENATED_OP
22.10
SDO_CS.DELETE_ALL_EPSG_RULES
22.11
SDO_CS.DELETE_OP
22.12
SDO_CS.DETERMINE_CHAIN
22.13
SDO_CS.DETERMINE_DEFAULT_CHAIN
22.14
SDO_CS.FIND_GEOG_CRS
22.15
SDO_CS.FIND_PROJ_CRS
22.16
SDO_CS.FIND_SRID
22.17
SDO_CS.FROM_GEOHASH
22.18
SDO_CS.FROM_OGC_SIMPLEFEATURE_SRS
22.19
SDO_CS.FROM_USNG
22.20
SDO_CS.GET_EPSG_DATA_VERSION
22.21
SDO_CS.GET_GEOHASH_CELL_HEIGHT
22.22
SDO_CS.GET_GEOHASH_CELL_WIDTH
22.23
SDO_CS.LOAD_EPSG_MATRIX
22.24
SDO_CS.MAKE_2D
22.25
SDO_CS.MAKE_3D
22.26
SDO_CS.MAP_EPSG_SRID_TO_ORACLE
22.27
SDO_CS.MAP_ORACLE_SRID_TO_EPSG
22.28
SDO_CS.REVOKE_PREFERENCE_FOR_OP
22.29
SDO_CS.TO_GEOHASH
22.30
SDO_CS.TO_OGC_SIMPLEFEATURE_SRS
22.31
SDO_CS.TO_USNG
22.32
SDO_CS.TRANSFORM
22.33
SDO_CS.TRANSFORM_LAYER
22.34
SDO_CS.UPDATE_WKTS_FOR_ALL_EPSG_CRS
22.35
SDO_CS.UPDATE_WKTS_FOR_EPSG_CRS
22.36
SDO_CS.UPDATE_WKTS_FOR_EPSG_DATUM
22.37
SDO_CS.UPDATE_WKTS_FOR_EPSG_ELLIPS
22.38
SDO_CS.UPDATE_WKTS_FOR_EPSG_OP
22.39
SDO_CS.UPDATE_WKTS_FOR_EPSG_PARAM
22.40
SDO_CS.UPDATE_WKTS_FOR_EPSG_PM
22.41
SDO_CS.VALIDATE_EPSG_MATRIX
22.42
SDO_CS.VALIDATE_WKT
23
SDO_CSW Package (Catalog Services for the Web)
23.1
SDO_CSW.CREATE_SPATIAL_IDX
23.2
SDO_CSW.CREATE_XQFT_IDX
23.3
SDO_CSW.INITIALIZE_CSW
23.4
SDO_CSW.SYNC_INDEX
24
SDO_CSW_PROCESS Package [deprecated]
24.1
SDO_CSW_PROCESS.DeleteCapabilitiesInfo
24.2
SDO_CSW_PROCESS.DeleteDomainInfo
24.3
SDO_CSW_PROCESS.DeletePluginMap
24.4
SDO_CSW_PROCESS.DeleteRecordViewMap
24.5
SDO_CSW_PROCESS.GetRecordTypeId
24.6
SDO_CSW_PROCESS.InsertCapabilitiesInfo
24.7
SDO_CSW_PROCESS.InsertDomainInfo
24.8
SDO_CSW_PROCESS.InsertPluginMap
24.9
SDO_CSW_PROCESS.InsertRecordViewMap
24.10
SDO_CSW_PROCESS.InsertRtDataUpdated
24.11
SDO_CSW_PROCESS.InsertRtMDUpdated
25
SDO_GCDR Package (Geocoding)
25.1
SDO_GCDR.CREATE_PROFILE_TABLES
25.2
SDO_GCDR.GEOCODE
25.3
SDO_GCDR.GEOCODE_ADDR
25.4
SDO_GCDR.GEOCODE_ADDR_ALL
25.5
SDO_GCDR.GEOCODE_ALL
25.6
SDO_GCDR.GEOCODE_AS_GEOMETRY
25.7
SDO_GCDR.REVERSE_GEOCODE
26
SDO_GEOM Package (Geometry)
26.1
SDO_GEOM.RELATE
26.2
SDO_GEOM.SDO_ALPHA_SHAPE
26.3
SDO_GEOM.SDO_ARC_DENSIFY
26.4
SDO_GEOM.SDO_AREA
26.5
SDO_GEOM.SDO_BUFFER
26.6
SDO_GEOM.SDO_CENTROID
26.7
SDO_GEOM.SDO_CLOSEST_POINTS
26.8
SDO_GEOM.SDO_CONCAVEHULL
26.9
SDO_GEOM.SDO_CONCAVEHULL_BOUNDARY
26.10
SDO_GEOM.SDO_CONVEXHULL
26.11
SDO_GEOM.SDO_DIAMETER
26.12
SDO_GEOM.SDO_DIAMETER_LINE
26.13
SDO_GEOM.SDO_DIFFERENCE
26.14
SDO_GEOM.SDO_DISTANCE
26.15
SDO_GEOM.SDO_INTERSECTION
26.16
SDO_GEOM.SDO_LENGTH
26.17
SDO_GEOM.SDO_MAX_MBR_ORDINATE
26.18
SDO_GEOM.SDO_MAXDISTANCE
26.19
SDO_GEOM.SDO_MAXDISTANCE_LINE
26.20
SDO_GEOM.SDO_MBC
26.21
SDO_GEOM.SDO_MBC_CENTER
26.22
SDO_GEOM.SDO_MBC_RADIUS
26.23
SDO_GEOM.SDO_MBR
26.24
SDO_GEOM.SDO_MIN_MBR_ORDINATE
26.25
SDO_GEOM.SDO_POINTONSURFACE
26.26
SDO_GEOM.SDO_SELF_UNION
26.27
SDO_GEOM.SDO_TRIANGULATE
26.28
SDO_GEOM.SDO_UNION
26.29
SDO_GEOM.SDO_VOLUME
26.30
SDO_GEOM.SDO_WIDTH
26.31
SDO_GEOM.SDO_WIDTH_LINE
26.32
SDO_GEOM.SDO_XOR
26.33
SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
26.34
SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT
26.35
SDO_GEOM.WITHIN_DISTANCE
27
SDO_LRS Package (Linear Referencing System)
27.1
SDO_LRS.CLIP_GEOM_SEGMENT
27.2
SDO_LRS.CONCATENATE_GEOM_SEGMENTS
27.3
SDO_LRS.CONNECTED_GEOM_SEGMENTS
27.4
SDO_LRS.CONVERT_TO_LRS_DIM_ARRAY
27.5
SDO_LRS.CONVERT_TO_LRS_GEOM
27.6
SDO_LRS.CONVERT_TO_LRS_LAYER
27.7
SDO_LRS.CONVERT_TO_STD_DIM_ARRAY
27.8
SDO_LRS.CONVERT_TO_STD_GEOM
27.9
SDO_LRS.CONVERT_TO_STD_LAYER
27.10
SDO_LRS.DEFINE_GEOM_SEGMENT
27.11
SDO_LRS.DYNAMIC_SEGMENT
27.12
SDO_LRS.FIND_LRS_DIM_POS
27.13
SDO_LRS.FIND_MEASURE
27.14
SDO_LRS.FIND_OFFSET
27.15
SDO_LRS.GEOM_SEGMENT_END_MEASURE
27.16
SDO_LRS.GEOM_SEGMENT_END_PT
27.17
SDO_LRS.GEOM_SEGMENT_LENGTH
27.18
SDO_LRS.GEOM_SEGMENT_START_MEASURE
27.19
SDO_LRS.GEOM_SEGMENT_START_PT
27.20
SDO_LRS.GET_MEASURE
27.21
SDO_LRS.GET_NEXT_SHAPE_PT
27.22
SDO_LRS.GET_NEXT_SHAPE_PT_MEASURE
27.23
SDO_LRS.GET_PREV_SHAPE_PT
27.24
SDO_LRS.GET_PREV_SHAPE_PT_MEASURE
27.25
SDO_LRS.IS_GEOM_SEGMENT_DEFINED
27.26
SDO_LRS.IS_MEASURE_DECREASING
27.27
SDO_LRS.IS_MEASURE_INCREASING
27.28
SDO_LRS.IS_SHAPE_PT_MEASURE
27.29
SDO_LRS.LOCATE_PT
27.30
SDO_LRS.LRS_INTERSECTION
27.31
SDO_LRS.MEASURE_RANGE
27.32
SDO_LRS.MEASURE_TO_PERCENTAGE
27.33
SDO_LRS.OFFSET_GEOM_SEGMENT
27.34
SDO_LRS.PERCENTAGE_TO_MEASURE
27.35
SDO_LRS.PROJECT_PT
27.36
SDO_LRS.REDEFINE_GEOM_SEGMENT
27.37
SDO_LRS.RESET_MEASURE
27.38
SDO_LRS.REVERSE_GEOMETRY
27.39
SDO_LRS.REVERSE_MEASURE
27.40
SDO_LRS.SCALE_GEOM_SEGMENT
27.41
SDO_LRS.SET_PT_MEASURE
27.42
SDO_LRS.SPLIT_GEOM_SEGMENT
27.43
SDO_LRS.TRANSLATE_MEASURE
27.44
SDO_LRS.VALID_GEOM_SEGMENT
27.45
SDO_LRS.VALID_LRS_PT
27.46
SDO_LRS.VALID_MEASURE
27.47
SDO_LRS.VALIDATE_LRS_GEOMETRY
28
SDO_MIGRATE Package (Upgrading)
28.1
SDO_MIGRATE.TO_CURRENT
29
SDO_OLS Package (OpenLS)
29.1
SDO_OLS.MakeOpenLSClobRequest
29.2
SDO_OLS.MakeOpenLSRequest
30
SDO_PC_PKG Package (Point Clouds)
30.1
SDO_PC_PKG.CLIP_PC
30.2
SDO_PC_PKG.CLIP_PC_FLAT
30.3
SDO_PC_PKG.CREATE_CONTOUR_GEOMETRIES
30.4
SDO_PC_PKG.CREATE_PC
30.5
SDO_PC_PKG.DROP_DEPENDENCIES
30.6
SDO_PC_PKG.GET_PT_IDS
30.7
SDO_PC_PKG.HAS_PYRAMID
30.8
SDO_PC_PKG.INIT
30.9
SDO_PC_PKG.PRESERVES_LEVEL1
30.10
SDO_PC_PKG.TO_DEM
30.11
SDO_PC_PKG.TO_GEOMETRY
31
SDO_SAM Package (Spatial Analysis and Mining)
31.1
SDO_SAM.AGGREGATES_FOR_GEOMETRY
31.2
SDO_SAM.AGGREGATES_FOR_LAYER
31.3
SDO_SAM.BIN_GEOMETRY
31.4
SDO_SAM.BIN_LAYER
31.5
SDO_SAM.COLOCATED_REFERENCE_FEATURES
31.6
SDO_SAM.SIMPLIFY_GEOMETRY
31.7
SDO_SAM.SIMPLIFY_LAYER
31.8
SDO_SAM.SPATIAL_CLUSTERS
31.9
SDO_SAM.TILED_AGGREGATES
31.10
SDO_SAM.TILED_BINS
32
SDO_TIN_PKG Package (TINs)
32.1
SDO_TIN_PKG.CLIP_TIN
32.2
SDO_TIN_PKG.CREATE_TIN
32.3
SDO_TIN_PKG.DROP_DEPENDENCIES
32.4
SDO_TIN_PKG.INIT
32.5
SDO_TIN_PKG.PROJECT_ORDINATES_ONTO_TIN
32.6
SDO_TIN_PKG.TO_DEM
32.7
SDO_TIN_PKG.TO_GEOMETRY
33
SDO_TRKR Package (Location Tracking)
33.1
SDO_TRKR.CREATE_TRACKING_REGIONS
33.2
SDO_TRKR.DESTROY_TRACKING_REGIONS
33.3
SDO_TRKR.SEND_LOCATION_MSGS
33.4
SDO_TRKR.SEND_TRACKING_MSG
33.5
SDO_TRKR.START_TRACKING_REGIONS
33.6
SDO_TRKR.STOP_TRACKING_REGIONS
34
SDO_TUNE Package (Tuning)
34.1
SDO_TUNE.AVERAGE_MBR
34.2
SDO_TUNE.ESTIMATE_RTREE_INDEX_SIZE
34.3
SDO_TUNE.EXTENT_OF
34.4
SDO_TUNE.MIX_INFO
35
SDO_UTIL Package (Utility)
35.1
SDO_UTIL.AFFINETRANSFORMS
35.2
SDO_UTIL.APPEND
35.3
SDO_UTIL.BEARING_TILT_FOR_POINTS
35.4
SDO_UTIL.CIRCLE_POLYGON
35.5
SDO_UTIL.CONCAT_LINES
35.6
SDO_UTIL.CONVERT_UNIT
35.7
SDO_UTIL.CONVERT3007TO3008
35.8
SDO_UTIL.DROP_WORK_TABLES
35.9
SDO_UTIL.ELLIPSE_POLYGON
35.10
SDO_UTIL.EXTRACT
35.11
SDO_UTIL.EXTRACT_ALL
35.12
SDO_UTIL.EXTRACT3D
35.13
SDO_UTIL.EXTRUDE
35.14
SDO_UTIL.FROM_GEOJSON
35.15
SDO_UTIL.FROM_GML311GEOMETRY
35.16
SDO_UTIL.FROM_GMLGEOMETRY
35.17
SDO_UTIL.FROM_KMLGEOMETRY
35.18
SDO_UTIL.FROM_WKBGEOMETRY
35.19
SDO_UTIL.FROM_WKTGEOMETRY
35.20
SDO_UTIL.GEO_SEARCH
35.21
SDO_UTIL.GET_2D_FOOTPRINT
35.22
SDO_UTIL.GETNUMELEM
35.23
SDO_UTIL.GETNUMVERTICES
35.24
SDO_UTIL.GETNURBSAPPROX
35.25
SDO_UTIL.GETVERTICES
35.26
SDO_UTIL.INITIALIZE_INDEXES_FOR_TTS
35.27
SDO_UTIL.INTERIOR_POINT
35.28
SDO_UTIL.POINT_AT_BEARING
35.29
SDO_UTIL.POLYGONTOLINE
35.30
SDO_UTIL.RECTIFY_GEOMETRY
35.31
SDO_UTIL.REMOVE_DUPLICATE_VERTICES
35.32
SDO_UTIL.REVERSE_LINESTRING
35.33
SDO_UTIL.SIMPLIFY
35.34
SDO_UTIL.SIMPLIFYVW
35.35
SDO_UTIL.THEME3D_GET_BLOCK_TABLE
35.36
SDO_UTIL.THEME3D_HAS_LOD
35.37
SDO_UTIL.THEME3D_HAS_TEXTURE
35.38
SDO_UTIL.TO_GEOJSON
35.39
SDO_UTIL.TO_GML311GEOMETRY
35.40
SDO_UTIL.TO_GMLGEOMETRY
35.41
SDO_UTIL.TO_KMLGEOMETRY
35.42
SDO_UTIL.TO_WKBGEOMETRY
35.43
SDO_UTIL.TO_WKTGEOMETRY
35.44
SDO_UTIL.VALIDATE_3DTHEME
35.45
SDO_UTIL.VALIDATE_SCENE
35.46
SDO_UTIL.VALIDATE_VIEWFRAME
35.47
SDO_UTIL.VALIDATE_WKBGEOMETRY
35.48
SDO_UTIL.VALIDATE_WKTGEOMETRY
36
SDO_WCS Package (Web Coverage Service)
36.1
SDO_WCS.CreateTempTable
36.2
SDO_WCS.DropTempTable
36.3
SDO_WCS.GrantPrivilegesToWCS
36.4
SDO_WCS.Init
36.5
SDO_WCS.PublishCoverage
36.6
SDO_WCS.RevokePrivilegesFromWCS
36.7
SDO_WCS.UnpublishCoverage
36.8
SDO_WCS.ValidateCoverages
37
SDO_WFS_LOCK Package (WFS)
37.1
SDO_WFS_LOCK.EnableDBTxns
37.2
SDO_WFS_LOCK.RegisterFeatureTable
37.3
SDO_WFS_LOCK.UnRegisterFeatureTable
38
SDO_WFS_PROCESS Package (WFS Processing)
38.1
SDO_WFS_PROCESS.DropFeatureType
38.2
SDO_WFS_PROCESS.DropFeatureTypes
38.3
SDO_WFS_PROCESS.GenCollectionProcs
38.4
SDO_WFS_PROCESS.GetFeatureTypeId
38.5
SDO_WFS_PROCESS.GrantFeatureTypeToUser
38.6
SDO_WFS_PROCESS.GrantMDAccessToUser
38.7
SDO_WFS_PROCESS.InsertCapabilitiesInfo
38.8
SDO_WFS_PROCESS.InsertFtDataUpdated
38.9
SDO_WFS_PROCESS.InsertFtMDUpdated
38.10
SDO_WFS_PROCESS.PopulateFeatureTypeXMLInfo
38.11
SDO_WFS_PROCESS.PublishFeatureType
38.12
SDO_WFS_PROCESS.Publish_FeatureTypes_In_Schema
38.13
SDO_WFS_PROCESS.RegisterMTableView
38.14
SDO_WFS_PROCESS.RevokeFeatureTypeFromUser
38.15
SDO_WFS_PROCESS.RevokeMDAccessFromUser
38.16
SDO_WFS_PROCESS.UnRegisterMTableView
Supplementary Information
A
Installation, Migration, Compatibility, and Upgrade
A.1
Migrating Spatial Data from One Database to Another
A.2
Ensuring That GeoRaster Works Properly After an Installation or Upgrade
A.2.1
Enabling GeoRaster
A.2.2
Ensuring Oracle XML DB Repository is Installed
A.2.3
Checking if the SDO_GEORASTER Type Needs to be Altered After an Upgrade
A.3
Index Maintenance Before and After an Upgrade (WFS and CSW)
A.4
Increasing the Size of Ordinate Arrays to Support Very Large Geometries
B
Oracle Locator
B.1
Installing and Deinstalling Locator or Spatial and Graph Manually
C
Complex Spatial Queries: Examples
C.1
Tables Used in the Examples
C.2
SDO_WITHIN_DISTANCE Examples
C.3
SDO_NN Examples
D
Loading ESRI Shapefiles into Spatial and Graph
D.1
Usage of the Shapefile Converter
D.2
Examples of the Shapefile Converter
E
Routing Engine Administration
E.1
Logging Administration Operations
E.1.1
CREATE_SDO_ROUTER_LOG_DIR Procedure
E.1.2
VALIDATE_SDO_ROUTER_LOG_DIR Procedure
E.2
Network Data Model (NDM) Network Administration
E.2.1
CREATE_ROUTER_NETWORK Procedure
E.2.2
DELETE_ROUTER_NETWORK Procedure
E.2.3
Network Creation Example
E.3
Routing Engine Data
E.3.1
PARTITION_ROUTER Procedure
E.3.2
CLEANUP_ROUTER Procedure
E.3.3
DUMP_PARTITIONS Procedure
E.3.4
VALIDATE_PARTITIONS Procedure
E.3.5
GET_VERSION Procedure
E.3.6
Routing Engine Data Examples
E.3.6.1
Partitioning a Small Data Set
E.3.6.2
Partitioning a Full Data Set
E.3.6.3
Dumping the Contents of a Partition
E.3.6.4
Validating the Contents of a Partition
E.3.6.5
Querying the Routing Engine Data Version
E.4
User Data
E.4.1
Restricted Driving Maneuvers User Data
E.4.2
CREATE_TURN_RESTRICTION_DATA Procedure
E.4.3
DUMP_TURN_RESTRICTION_DATA Procedure
E.4.4
CREATE_TRUCKING_DATA Procedure
E.4.5
DUMP_TRUCKING_DATA Procedure
E.4.6
CREATE_TIMEZONE_DATA Procedure
E.4.7
DUMP_TIMEZONE_DATA Procedure
E.4.8
User Data Examples
E.4.8.1
Rebuilding the Turn Restriction User Data
E.4.8.2
Dumping All Hard Turn Restriction User Data BLOBs
E.4.8.3
Rebuilding the Trucking User Data
E.4.8.4
Dumping the Trucking User Data Restrictions
E.4.8.5
Rebuilding the Time Zone User Data
E.4.8.6
Dumping All Time Zone User Data BLOBs
E.5
Other Functions and Procedures
F
Catalog Services for the Web (CSW) Support [deprecated implementation]
F.1
CSW Engine and Architecture [deprecated implementation]
F.2
CSW APIs and Configuration [deprecated implementation]
F.2.1
Capabilities Documents [deprecated implementation]
F.2.2
Spatial Path Extractor Function (extractSDO) [deprecated implementation]
F.2.2.1
Registering and Unregistering the extractSDO Function [deprecated implementation]
F.3
Request and Response XML Examples [deprecated implementation]
F.4
Java API for CSW Administration [deprecated implementation]
F.4.1
createXMLTableIndex method
F.4.2
deleteDomainInfo method
F.4.3
deleteRecordViewMap method
F.4.4
disableVersioning method
F.4.5
dropRecordType method
F.4.6
dropXMLTableIndex method
F.4.7
enableVersioning method
F.4.8
getIsXMLTableIndexCreated method
F.4.9
getRecordTypeId method
F.4.10
grantMDAccessToUser method
F.4.11
grantRecordTypeToUser method
F.4.12
publishRecordType method
F.4.12.1
Related Classes for publishRecordType
F.4.13
registerTypePluginMap method
F.4.14
revokeMDAccessFromUser method
F.4.15
revokeRecordTypeFromUser method
F.4.16
setCapabilitiesInfo method
F.4.17
setDomainInfo method
F.4.18
setRecordViewMap method
F.4.19
setXMLTableIndexInfo method
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.