1/51
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 1 (12.1.0.2)
Changes in Oracle Database 12
c
Release 1 (12.1.0.1)
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
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
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
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
ALTER INDEX
ALTER INDEX REBUILD
ALTER INDEX RENAME TO
CREATE INDEX
DROP INDEX
18
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_POINTINPOLYGON
SDO_RELATE
SDO_TOUCH
SDO_WITHIN_DISTANCE
19
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
20
SDO_CS Package (Coordinate System Transformation)
SDO_CS.ADD_PREFERENCE_FOR_OP
SDO_CS.CONVERT_3D_SRID_TO_2D
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.LOAD_EPSG_MATRIX
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_EPSG_MATRIX
SDO_CS.VALIDATE_WKT
21
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
22
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
23
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_DIAMETER
SDO_GEOM.SDO_DIAMETER_LINE
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_MAXDISTANCE
SDO_GEOM.SDO_MAXDISTANCE_LINE
SDO_GEOM.SDO_MBC
SDO_GEOM.SDO_MBC_CENTER
SDO_GEOM.SDO_MBC_RADIUS
SDO_GEOM.SDO_MBR
SDO_GEOM.SDO_MIN_MBR_ORDINATE
SDO_GEOM.SDO_POINTONSURFACE
SDO_GEOM.SDO_SELF_UNION
SDO_GEOM.SDO_TRIANGULATE
SDO_GEOM.SDO_UNION
SDO_GEOM.SDO_VOLUME
SDO_GEOM.SDO_WIDTH
SDO_GEOM.SDO_WIDTH_LINE
SDO_GEOM.SDO_XOR
SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT
SDO_GEOM.WITHIN_DISTANCE
24
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
25
SDO_MIGRATE Package (Upgrading)
SDO_MIGRATE.TO_CURRENT
26
SDO_OLS Package (OpenLS)
SDO_OLS.MakeOpenLSClobRequest
SDO_OLS.MakeOpenLSRequest
27
SDO_PC_PKG Package (Point Clouds)
SDO_PC_PKG.CLIP_PC
SDO_PC_PKG.CLIP_PC_FLAT
SDO_PC_PKG.CREATE_CONTOUR_GEOMETRIES
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
28
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
29
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.PROJECT_ORDINATES_ONTO_TIN
SDO_TIN_PKG.TO_DEM
SDO_TIN_PKG.TO_GEOMETRY
30
SDO_TUNE Package (Tuning)
SDO_TUNE.AVERAGE_MBR
SDO_TUNE.ESTIMATE_RTREE_INDEX_SIZE
SDO_TUNE.EXTENT_OF
SDO_TUNE.MIX_INFO
31
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.CONVERT3007TO3008
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.GET_2D_FOOTPRINT
SDO_UTIL.GETNUMELEM
SDO_UTIL.GETNUMVERTICES
SDO_UTIL.GETNURBSAPPROX
SDO_UTIL.GETVERTICES
SDO_UTIL.INITIALIZE_INDEXES_FOR_TTS
SDO_UTIL.INTERIOR_POINT
SDO_UTIL.POINT_AT_BEARING
SDO_UTIL.POLYGONTOLINE
SDO_UTIL.RECTIFY_GEOMETRY
SDO_UTIL.REMOVE_DUPLICATE_VERTICES
SDO_UTIL.REVERSE_LINESTRING
SDO_UTIL.SIMPLIFY
SDO_UTIL.SIMPLIFYVW
SDO_UTIL.THEME3D_GET_BLOCK_TABLE
SDO_UTIL.THEME3D_HAS_LOD
SDO_UTIL.THEME3D_HAS_TEXTURE
SDO_UTIL.TO_GML311GEOMETRY
SDO_UTIL.TO_GMLGEOMETRY
SDO_UTIL.TO_KMLGEOMETRY
SDO_UTIL.TO_WKBGEOMETRY
SDO_UTIL.TO_WKTGEOMETRY
SDO_UTIL.VALIDATE_3DTHEME
SDO_UTIL.VALIDATE_SCENE
SDO_UTIL.VALIDATE_VIEWFRAME
SDO_UTIL.VALIDATE_WKBGEOMETRY
SDO_UTIL.VALIDATE_WKTGEOMETRY
32
SDO_WFS_LOCK Package (WFS)
SDO_WFS_LOCK.EnableDBTxns
SDO_WFS_LOCK.RegisterFeatureTable
SDO_WFS_LOCK.UnRegisterFeatureTable
33
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, 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.