Skip Headers
Oracle® Spatial Developer's Guide
11g Release 1 (11.1)
Part Number B28400-01
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
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?
3-D Geometry Support
Enhanced Web Services Support: Business Directory, Web Feature Service, Catalog Services, and OpenLS
Routing Engine Enhancements
SQL Multimedia Types
Annotation Text
DEFAULT Geocoding Match Mode Equivalent to RELAX_POSTAL_CODE
New MatchVector Attribute for SDO_GEOR_ADDR
SDO_GEOM.CLOSEST_POINTS Procedure
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
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
Open Geospatial Consortium (OGC) Conformance
1.17
Spatial Release (Version) Number
1.18
Spatial Application Hardware Requirement Considerations
1.19
Spatial Error Messages
1.20
Spatial Examples
1.21
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
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.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
Cross-Schema Operator Invocation
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
Geodetic MBRs
6.2.4
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.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
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_AREA_<suffix> Table
11.5.2
GC_COUNTRY_PROFILE Table
11.5.3
GC_INTERSECTION_<suffix> Table
11.5.4
GC_POI_<suffix> Table
11.5.5
GC_POSTAL_CODE_<suffix> Table
11.5.6
GC_ROAD_<suffix> Table
11.5.7
GC_ROAD_SEGMENT_<suffix> Table
11.5.8
Indexes on Tables for Geocoding
11.6
Using the Geocoding Service (XML API)
11.6.1
Deploying and Configuring the Geocoding Service
11.6.1.1
Configuring the geocodercfg.xml File
11.6.2
Geocoding Request DTD and Example
11.6.3
Geocoding Response DTD 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
Deploying and Configuring the Routing Engine
13.1.1
Configuring the web.xml File
13.2
Routing Engine XML API
13.2.1
Route Request and Response Examples
13.2.2
Route Request DTD
13.2.2.1
route_request Element
13.2.2.2
route_request Attributes
13.2.2.3
input_location Element
13.2.2.4
pre_geocoded_location Element
13.2.3
Route Response DTD
13.2.4
Batch Route Request and Response Examples
13.2.5
Batch Route Request DTD
13.2.5.1
batch_route_request Element
13.2.5.2
batch_route_request Attributes
13.2.6
Batch Route Response DTD
13.3
Data Structures Used by the Routing Engine
13.3.1
EDGE Table
13.3.2
NODE Table
13.3.3
PARTITION Table
13.3.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
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_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.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
SDO_CS.VIEWPORT_TRANSFORM
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.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_ARC_DENSIFY
SDO_GEOM.SDO_AREA
SDO_GEOM.SDO_BUFFER
SDO_GEOM.SDO_CENTROID
SDO_GEOM.SDO_CLOSEST_POINTS
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_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.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.APPEND
SDO_UTIL.APPEND_TO_COLLECTION
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.EXTRACT3D
SDO_UTIL.EXTRUDE
SDO_UTIL.FROM_GML311GEOMETRY
SDO_UTIL.FROM_GMLGEOMETRY
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.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_WKBGEOMETRY
SDO_UTIL.TO_WKTGEOMETRY
SDO_UTIL.VALIDATE_WKBGEOMETRY
SDO_UTIL.VALIDATE_WKTGEOMETRY
33
SDO_WFS_LOCK Package (WFS)
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 Upgrade
B
Oracle Locator
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
Glossary
Index