Go to main content
1/475
Contents
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 1 (12.1.0.2)
Routing Engine Information Revised
Change in Behavior for SDO_GEOM.SDO_CLOSEST_POINTS
GeoRaster Not Enabled by Default
Changes in Oracle Database 12
c
Release 1 (12.1.0.1)
New Features
New and Changed SDO_GEOM Subprograms (Release 12.1.0.2)
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
NURBS Curve Support in Oracle Spatial and Graph
1.14
Spatial and Graph Java Application Programming Interface
1.15
Predefined User Accounts Created by Spatial and Graph
1.16
Performance and Tuning Information
1.17
OGC and ISO Compliance
1.18
Spatial and Graph Release (Version) Number
1.19
SPATIAL_VECTOR_ACCELERATION System Parameter
1.20
Spatially Enabling a Table
1.21
Moving Spatial Metadata (MDSYS.MOVE_SDO)
1.22
Spatial Application Hardware Requirement Considerations
1.23
Spatial and Graph Error Messages
1.24
Spatial Examples
1.25
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
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
Enabling Access to Spatial Index Statistics
5.1.8
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 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
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
Deploying and Configuring 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
Routing
13.1.1
Simple Route Request
13.1.2
Simple Multi-address Route Request
13.1.3
Traveling Salesperson (TSP) Route Request
13.1.4
Batched Route Request
13.1.5
Batch Mode Route Request
13.2
Deploying the Routing Engine
13.2.1
Preparing WebLogic Server
13.2.2
Unpacking the routeserver.ear File
13.2.3
Editing the web.xml File
13.2.4
Deploying the Routing Engine on WebLogic Server
13.3
Routing Engine XML API
13.3.1
Route Request and Response Examples
13.3.2
Route Request XML Schema Definition
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 XML Schema Definition
13.3.4
Batch Mode Route Request and Response Examples
13.3.5
Batch Route Request XML Schema Definition
13.3.5.1
batch_route_request Element
13.3.5.2
batch_route_request Attributes
13.3.6
Batch Route Response XML Schema
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
13.5
User Data Structures Used by the Routing Engine
13.5.1
Turn Restriction User Data
13.5.1.1
ROUTER_CONDITION Table
13.5.1.2
ROUTER_NAV_STRAND Table
13.5.1.3
ROUTER_TURN_RESTRICTION_DATA Table
13.5.2
Trucking User Data
13.5.2.1
ROUTER_TRANSPORT Table
13.5.2.2
ROUTER_TRUCKING_DATA 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 (CSW)
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
Part III Reference Information
17
SQL Statements for Indexing Spatial Data
17.1
ALTER INDEX
17.2
ALTER INDEX REBUILD
17.3
ALTER INDEX RENAME TO
17.4
CREATE INDEX
17.5
DROP INDEX
18
Spatial Operators
18.1
SDO_ANYINTERACT
18.2
SDO_CONTAINS
18.3
SDO_COVEREDBY
18.4
SDO_COVERS
18.5
SDO_EQUAL
18.6
SDO_FILTER
18.7
SDO_INSIDE
18.8
SDO_JOIN
18.9
SDO_NN
18.10
SDO_NN_DISTANCE
18.11
SDO_ON
18.12
SDO_OVERLAPBDYDISJOINT
18.13
SDO_OVERLAPBDYINTERSECT
18.14
SDO_OVERLAPS
18.15
SDO_POINTINPOLYGON
18.16
SDO_RELATE
18.17
SDO_TOUCH
18.18
SDO_WITHIN_DISTANCE
19
Spatial Aggregate Functions
19.1
SDO_AGGR_CENTROID
19.2
SDO_AGGR_CONCAT_LINES
19.3
SDO_AGGR_CONVEXHULL
19.4
SDO_AGGR_LRS_CONCAT
19.5
SDO_AGGR_MBR
19.6
SDO_AGGR_SET_UNION
19.7
SDO_AGGR_UNION
20
SDO_CS Package (Coordinate System Transformation)
20.1
SDO_CS.ADD_PREFERENCE_FOR_OP
20.2
SDO_CS.CONVERT_3D_SRID_TO_2D
20.3
SDO_CS.CONVERT_NADCON_TO_XML
20.4
SDO_CS.CONVERT_NTV2_TO_XML
20.5
SDO_CS.CONVERT_XML_TO_NADCON
20.6
SDO_CS.CONVERT_XML_TO_NTV2
20.7
SDO_CS.CREATE_CONCATENATED_OP
20.8
SDO_CS.CREATE_OBVIOUS_EPSG_RULES
20.9
SDO_CS.CREATE_PREF_CONCATENATED_OP
20.10
SDO_CS.DELETE_ALL_EPSG_RULES
20.11
SDO_CS.DELETE_OP
20.12
SDO_CS.DETERMINE_CHAIN
20.13
SDO_CS.DETERMINE_DEFAULT_CHAIN
20.14
SDO_CS.FIND_GEOG_CRS
20.15
SDO_CS.FIND_PROJ_CRS
20.16
SDO_CS.FIND_SRID
20.17
SDO_CS.FROM_OGC_SIMPLEFEATURE_SRS
20.18
SDO_CS.FROM_USNG
20.19
SDO_CS.GET_EPSG_DATA_VERSION
20.20
SDO_CS.LOAD_EPSG_MATRIX
20.21
SDO_CS.MAKE_2D
20.22
SDO_CS.MAKE_3D
20.23
SDO_CS.MAP_EPSG_SRID_TO_ORACLE
20.24
SDO_CS.MAP_ORACLE_SRID_TO_EPSG
20.25
SDO_CS.REVOKE_PREFERENCE_FOR_OP
20.26
SDO_CS.TO_OGC_SIMPLEFEATURE_SRS
20.27
SDO_CS.TO_USNG
20.28
SDO_CS.TRANSFORM
20.29
SDO_CS.TRANSFORM_LAYER
20.30
SDO_CS.UPDATE_WKTS_FOR_ALL_EPSG_CRS
20.31
SDO_CS.UPDATE_WKTS_FOR_EPSG_CRS
20.32
SDO_CS.UPDATE_WKTS_FOR_EPSG_DATUM
20.33
SDO_CS.UPDATE_WKTS_FOR_EPSG_ELLIPS
20.34
SDO_CS.UPDATE_WKTS_FOR_EPSG_OP
20.35
SDO_CS.UPDATE_WKTS_FOR_EPSG_PARAM
20.36
SDO_CS.UPDATE_WKTS_FOR_EPSG_PM
20.37
SDO_CS.VALIDATE_EPSG_MATRIX
20.38
SDO_CS.VALIDATE_WKT
21
SDO_CSW_PROCESS Package (CSW Processing)
21.1
SDO_CSW_PROCESS.DeleteCapabilitiesInfo
21.2
SDO_CSW_PROCESS.DeleteDomainInfo
21.3
SDO_CSW_PROCESS.DeletePluginMap
21.4
SDO_CSW_PROCESS.DeleteRecordViewMap
21.5
SDO_CSW_PROCESS.GetRecordTypeId
21.6
SDO_CSW_PROCESS.InsertCapabilitiesInfo
21.7
SDO_CSW_PROCESS.InsertDomainInfo
21.8
SDO_CSW_PROCESS.InsertPluginMap
21.9
SDO_CSW_PROCESS.InsertRecordViewMap
21.10
SDO_CSW_PROCESS.InsertRtDataUpdated
21.11
SDO_CSW_PROCESS.InsertRtMDUpdated
22
SDO_GCDR Package (Geocoding)
22.1
SDO_GCDR.CREATE_PROFILE_TABLES
22.2
SDO_GCDR.GEOCODE
22.3
SDO_GCDR.GEOCODE_ADDR
22.4
SDO_GCDR.GEOCODE_ADDR_ALL
22.5
SDO_GCDR.GEOCODE_ALL
22.6
SDO_GCDR.GEOCODE_AS_GEOMETRY
22.7
SDO_GCDR.REVERSE_GEOCODE
23
SDO_GEOM Package (Geometry)
23.1
SDO_GEOM.RELATE
23.2
SDO_GEOM.SDO_ALPHA_SHAPE
23.3
SDO_GEOM.SDO_ARC_DENSIFY
23.4
SDO_GEOM.SDO_AREA
23.5
SDO_GEOM.SDO_BUFFER
23.6
SDO_GEOM.SDO_CENTROID
23.7
SDO_GEOM.SDO_CLOSEST_POINTS
23.8
SDO_GEOM.SDO_CONCAVEHULL
23.9
SDO_GEOM.SDO_CONCAVEHULL_BOUNDARY
23.10
SDO_GEOM.SDO_CONVEXHULL
23.11
SDO_GEOM.SDO_DIAMETER
23.12
SDO_GEOM.SDO_DIAMETER_LINE
23.13
SDO_GEOM.SDO_DIFFERENCE
23.14
SDO_GEOM.SDO_DISTANCE
23.15
SDO_GEOM.SDO_INTERSECTION
23.16
SDO_GEOM.SDO_LENGTH
23.17
SDO_GEOM.SDO_MAX_MBR_ORDINATE
23.18
SDO_GEOM.SDO_MAXDISTANCE
23.19
SDO_GEOM.SDO_MAXDISTANCE_LINE
23.20
SDO_GEOM.SDO_MBC
23.21
SDO_GEOM.SDO_MBC_CENTER
23.22
SDO_GEOM.SDO_MBC_RADIUS
23.23
SDO_GEOM.SDO_MBR
23.24
SDO_GEOM.SDO_MIN_MBR_ORDINATE
23.25
SDO_GEOM.SDO_POINTONSURFACE
23.26
SDO_GEOM.SDO_SELF_UNION
23.27
SDO_GEOM.SDO_TRIANGULATE
23.28
SDO_GEOM.SDO_UNION
23.29
SDO_GEOM.SDO_VOLUME
23.30
SDO_GEOM.SDO_WIDTH
23.31
SDO_GEOM.SDO_WIDTH_LINE
23.32
SDO_GEOM.SDO_XOR
23.33
SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
23.34
SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT
23.35
SDO_GEOM.WITHIN_DISTANCE
24
SDO_LRS Package (Linear Referencing System)
24.1
SDO_LRS.CLIP_GEOM_SEGMENT
24.2
SDO_LRS.CONCATENATE_GEOM_SEGMENTS
24.3
SDO_LRS.CONNECTED_GEOM_SEGMENTS
24.4
SDO_LRS.CONVERT_TO_LRS_DIM_ARRAY
24.5
SDO_LRS.CONVERT_TO_LRS_GEOM
24.6
SDO_LRS.CONVERT_TO_LRS_LAYER
24.7
SDO_LRS.CONVERT_TO_STD_DIM_ARRAY
24.8
SDO_LRS.CONVERT_TO_STD_GEOM
24.9
SDO_LRS.CONVERT_TO_STD_LAYER
24.10
SDO_LRS.DEFINE_GEOM_SEGMENT
24.11
SDO_LRS.DYNAMIC_SEGMENT
24.12
SDO_LRS.FIND_LRS_DIM_POS
24.13
SDO_LRS.FIND_MEASURE
24.14
SDO_LRS.FIND_OFFSET
24.15
SDO_LRS.GEOM_SEGMENT_END_MEASURE
24.16
SDO_LRS.GEOM_SEGMENT_END_PT
24.17
SDO_LRS.GEOM_SEGMENT_LENGTH
24.18
SDO_LRS.GEOM_SEGMENT_START_MEASURE
24.19
SDO_LRS.GEOM_SEGMENT_START_PT
24.20
SDO_LRS.GET_MEASURE
24.21
SDO_LRS.GET_NEXT_SHAPE_PT
24.22
SDO_LRS.GET_NEXT_SHAPE_PT_MEASURE
24.23
SDO_LRS.GET_PREV_SHAPE_PT
24.24
SDO_LRS.GET_PREV_SHAPE_PT_MEASURE
24.25
SDO_LRS.IS_GEOM_SEGMENT_DEFINED
24.26
SDO_LRS.IS_MEASURE_DECREASING
24.27
SDO_LRS.IS_MEASURE_INCREASING
24.28
SDO_LRS.IS_SHAPE_PT_MEASURE
24.29
SDO_LRS.LOCATE_PT
24.30
SDO_LRS.LRS_INTERSECTION
24.31
SDO_LRS.MEASURE_RANGE
24.32
SDO_LRS.MEASURE_TO_PERCENTAGE
24.33
SDO_LRS.OFFSET_GEOM_SEGMENT
24.34
SDO_LRS.PERCENTAGE_TO_MEASURE
24.35
SDO_LRS.PROJECT_PT
24.36
SDO_LRS.REDEFINE_GEOM_SEGMENT
24.37
SDO_LRS.RESET_MEASURE
24.38
SDO_LRS.REVERSE_GEOMETRY
24.39
SDO_LRS.REVERSE_MEASURE
24.40
SDO_LRS.SCALE_GEOM_SEGMENT
24.41
SDO_LRS.SET_PT_MEASURE
24.42
SDO_LRS.SPLIT_GEOM_SEGMENT
24.43
SDO_LRS.TRANSLATE_MEASURE
24.44
SDO_LRS.VALID_GEOM_SEGMENT
24.45
SDO_LRS.VALID_LRS_PT
24.46
SDO_LRS.VALID_MEASURE
24.47
SDO_LRS.VALIDATE_LRS_GEOMETRY
25
SDO_MIGRATE Package (Upgrading)
25.1
SDO_MIGRATE.TO_CURRENT
26
SDO_OLS Package (OpenLS)
26.1
SDO_OLS.MakeOpenLSClobRequest
26.2
SDO_OLS.MakeOpenLSRequest
27
SDO_PC_PKG Package (Point Clouds)
27.1
SDO_PC_PKG.CLIP_PC
27.2
SDO_PC_PKG.CLIP_PC_FLAT
27.3
SDO_PC_PKG.CREATE_CONTOUR_GEOMETRIES
27.4
SDO_PC_PKG.CREATE_PC
27.5
SDO_PC_PKG.DROP_DEPENDENCIES
27.6
SDO_PC_PKG.GET_PT_IDS
27.7
SDO_PC_PKG.INIT
27.8
SDO_PC_PKG.TO_GEOMETRY
28
SDO_SAM Package (Spatial Analysis and Mining)
28.1
SDO_SAM.AGGREGATES_FOR_GEOMETRY
28.2
SDO_SAM.AGGREGATES_FOR_LAYER
28.3
SDO_SAM.BIN_GEOMETRY
28.4
SDO_SAM.BIN_LAYER
28.5
SDO_SAM.COLOCATED_REFERENCE_FEATURES
28.6
SDO_SAM.SIMPLIFY_GEOMETRY
28.7
SDO_SAM.SIMPLIFY_LAYER
28.8
SDO_SAM.SPATIAL_CLUSTERS
28.9
SDO_SAM.TILED_AGGREGATES
28.10
SDO_SAM.TILED_BINS
29
SDO_TIN_PKG Package (TINs)
29.1
SDO_TIN_PKG.CLIP_TIN
29.2
SDO_TIN_PKG.CREATE_TIN
29.3
SDO_TIN_PKG.DROP_DEPENDENCIES
29.4
SDO_TIN_PKG.INIT
29.5
SDO_TIN_PKG.PROJECT_ORDINATES_ONTO_TIN
29.6
SDO_TIN_PKG.TO_DEM
29.7
SDO_TIN_PKG.TO_GEOMETRY
30
SDO_TUNE Package (Tuning)
30.1
SDO_TUNE.AVERAGE_MBR
30.2
SDO_TUNE.ESTIMATE_RTREE_INDEX_SIZE
30.3
SDO_TUNE.EXTENT_OF
30.4
SDO_TUNE.MIX_INFO
31
SDO_UTIL Package (Utility)
31.1
SDO_UTIL.AFFINETRANSFORMS
31.2
SDO_UTIL.APPEND
31.3
SDO_UTIL.BEARING_TILT_FOR_POINTS
31.4
SDO_UTIL.CIRCLE_POLYGON
31.5
SDO_UTIL.CONCAT_LINES
31.6
SDO_UTIL.CONVERT_UNIT
31.7
SDO_UTIL.CONVERT3007TO3008
31.8
SDO_UTIL.DROP_WORK_TABLES
31.9
SDO_UTIL.ELLIPSE_POLYGON
31.10
SDO_UTIL.EXTRACT
31.11
SDO_UTIL.EXTRACT_ALL
31.12
SDO_UTIL.EXTRACT3D
31.13
SDO_UTIL.EXTRUDE
31.14
SDO_UTIL.FROM_GML311GEOMETRY
31.15
SDO_UTIL.FROM_GMLGEOMETRY
31.16
SDO_UTIL.FROM_KMLGEOMETRY
31.17
SDO_UTIL.FROM_WKBGEOMETRY
31.18
SDO_UTIL.FROM_WKTGEOMETRY
31.19
SDO_UTIL.GET_2D_FOOTPRINT
31.20
SDO_UTIL.GETNUMELEM
31.21
SDO_UTIL.GETNUMVERTICES
31.22
SDO_UTIL.GETNURBSAPPROX
31.23
SDO_UTIL.GETVERTICES
31.24
SDO_UTIL.INITIALIZE_INDEXES_FOR_TTS
31.25
SDO_UTIL.INTERIOR_POINT
31.26
SDO_UTIL.POINT_AT_BEARING
31.27
SDO_UTIL.POLYGONTOLINE
31.28
SDO_UTIL.RECTIFY_GEOMETRY
31.29
SDO_UTIL.REMOVE_DUPLICATE_VERTICES
31.30
SDO_UTIL.REVERSE_LINESTRING
31.31
SDO_UTIL.SIMPLIFY
31.32
SDO_UTIL.SIMPLIFYVW
31.33
SDO_UTIL.THEME3D_GET_BLOCK_TABLE
31.34
SDO_UTIL.THEME3D_HAS_LOD
31.35
SDO_UTIL.THEME3D_HAS_TEXTURE
31.36
SDO_UTIL.TO_GML311GEOMETRY
31.37
SDO_UTIL.TO_GMLGEOMETRY
31.38
SDO_UTIL.TO_KMLGEOMETRY
31.39
SDO_UTIL.TO_WKBGEOMETRY
31.40
SDO_UTIL.TO_WKTGEOMETRY
31.41
SDO_UTIL.VALIDATE_3DTHEME
31.42
SDO_UTIL.VALIDATE_SCENE
31.43
SDO_UTIL.VALIDATE_VIEWFRAME
31.44
SDO_UTIL.VALIDATE_WKBGEOMETRY
31.45
SDO_UTIL.VALIDATE_WKTGEOMETRY
32
SDO_WFS_LOCK Package (WFS)
32.1
SDO_WFS_LOCK.EnableDBTxns
32.2
SDO_WFS_LOCK.RegisterFeatureTable
32.3
SDO_WFS_LOCK.UnRegisterFeatureTable
33
SDO_WFS_PROCESS Package (WFS Processing)
33.1
SDO_WFS_PROCESS.DropFeatureType
33.2
SDO_WFS_PROCESS.DropFeatureTypes
33.3
SDO_WFS_PROCESS.GenCollectionProcs
33.4
SDO_WFS_PROCESS.GetFeatureTypeId
33.5
SDO_WFS_PROCESS.GrantFeatureTypeToUser
33.6
SDO_WFS_PROCESS.GrantMDAccessToUser
33.7
SDO_WFS_PROCESS.InsertCapabilitiesInfo
33.8
SDO_WFS_PROCESS.InsertFtDataUpdated
33.9
SDO_WFS_PROCESS.InsertFtMDUpdated
33.10
SDO_WFS_PROCESS.PopulateFeatureTypeXMLInfo
33.11
SDO_WFS_PROCESS.PublishFeatureType
33.12
SDO_WFS_PROCESS.RegisterMTableView
33.13
SDO_WFS_PROCESS.RevokeFeatureTypeFromUser
33.14
SDO_WFS_PROCESS.RevokeMDAccessFromUser
33.15
SDO_WFS_PROCESS.UnRegisterMTableView
Part IV 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.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
User Data Examples
E.4.6.1
Rebuilding the Turn Restriction User Data
E.4.6.2
Dumping All Hard Turn Restriction User Data BLOBs
E.4.6.3
Rebuilding the Trucking User Data
E.4.6.4
Dumping the Trucking User Data Restrictions
E.5
Other Functions and Procedures
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.