Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Spatial Developer's Guide
-
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.6 Query Model
- 1.7 Indexing of Spatial Data
- 1.8 Spatial Relationships and Filtering
- 1.9 Spatial Operators, Procedures, and Functions
- 1.10 Spatial Aggregate Functions
- 1.11 Vector Tiles
- 1.12 H3 Indexing
- 1.13 Three-Dimensional Spatial Objects
- 1.14 Geocoding
- 1.15 Location Data Enrichment
- 1.16 JSON and GeoJSON Support in Oracle Spatial
- 1.17 NURBS Curve Support in Oracle Spatial
- 1.18 Sharded Database Support by Oracle Spatial
- 1.19 Database In-Memory Support by Oracle Spatial
- 1.20 Spatial Java Application Programming Interface
- 1.21 Predefined User Accounts Created by Spatial
- 1.22 Performance and Tuning Information
- 1.23 OGC and ISO Compliance
- 1.24 Spatial Release (Version) Number
- 1.25 SPATIAL_VECTOR_ACCELERATION System Parameter
- 1.26 Spatially Enabling a Table
- 1.27 Moving Spatial Metadata (MDSYS.MOVE_SDO)
- 1.28 Spatial Application Hardware Requirement Considerations
- 1.29 Spatial Studio Application
- 1.30 Spatial Error Messages
- 1.31 Spatial Examples
- 1.32 Getting Started with Longitude/Latitude Spatial Data
- 1.33 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.3 SDO_GEOMETRY Methods
- 2.4 SDO_GEOMETRY Constructors
- 2.5 TIN-Related Object Types
- 2.6 Point Cloud-Related Object Types
- 2.7 Geometry Examples
- 2.8 Geometry Metadata Views
- 2.9 Other Spatial Metadata Views
- 2.10 Spatial Index-Related Structures
- 2.11 Unit of Measurement Support
- 3 SQL Multimedia Type Support
- 4 Loading Spatial Data
-
5
Indexing and Querying Spatial Data
-
5.1
Creating a Spatial Index
- 5.1.1 Using System-Managed Spatial Indexes
- 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.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 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.1
Creating a Spatial Index
-
6
Coordinate Systems (Spatial Reference Systems)
- 6.1 Terms and Concepts
- 6.2 Geodetic Coordinate Support
- 6.3 Local Coordinate Support
- 6.4 EPSG Model and Spatial
- 6.5 Three-Dimensional Coordinate Reference System Support
- 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.8
Legacy Tables and Views
- 6.8.1 MDSYS.CS_SRS Table
- 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.10 Notes and Restrictions with Coordinate Systems Support
- 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 (Dynamic Segmentation)
- 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
-
7.1
LRS Terms and Concepts
- 8 Location Tracking Server
- 9 Spatial Analysis and Mining
- 10 Extending Spatial Indexing Capabilities
-
1
Spatial Concepts
-
Part II Spatial Web Services
- 11 Introduction to Spatial Web Services
-
12
Geocoding Address Data
- 12.1 Concepts for Geocoding
- 12.2 Data Types for Geocoding
- 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.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)
- 13 Business Directory (Yellow Pages) Support
-
14
Routing Engine
- 14.1 Routing
- 14.2 Deploying the Routing Engine
- 14.3 Routing Engine XML API
- 14.4 Location-Based Query Using the WSServlet XML API
- 14.5 Data Structures Used by the Routing Engine
- 14.6 User Data Structures Used by the Routing Engine
- 15 OpenLS Support
-
16
Web Feature Service (WFS) Support
- 16.1 WFS Engine
- 16.2 Configuring 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
- 16.9 Dropping WFS Support (Release 21c or Later Only)
- 16.10 Updating a WFS Instance from an Oracle Database for a Release Before 21c to Release 21c or Later
-
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.6 WCS Administration Console
- 17.7 Oracle Implementation Extension for WCS
- 17.8 WCS Operations: Requests and Responses with XML Examples
- 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 Capabilities Documents (CSW)
- 18.5 CSW Major Operations (DCMI Profile)
- 18.6 CSW Major Operations (ISO Profile)
- 18.7 CSW Administration Console
- 18.8 Diagnosing CSW Issues
-
Part III Reference Information
- 19 SQL Statements for Indexing Spatial Data
-
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_GEOM_MBR
- 20.8 SDO_INSIDE
- 20.9 SDO_JOIN
- 20.10 SDO_NN
- 20.11 SDO_NN_DISTANCE
- 20.12 SDO_ON
- 20.13 SDO_OVERLAPBDYDISJOINT
- 20.14 SDO_OVERLAPBDYINTERSECT
- 20.15 SDO_OVERLAPS
- 20.16 SDO_POINTINPOLYGON
- 20.17 SDO_RELATE
- 20.18 SDO_TOUCH
- 20.19 SDO_WITHIN_DISTANCE
- 21 Spatial Aggregate Functions
-
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.GENERATE_SCRIPT_FROM_SRID
- 22.21 SDO_CS.GET_EPSG_DATA_VERSION
- 22.22 SDO_CS.GET_GEOHASH_CELL_HEIGHT
- 22.23 SDO_CS.GET_GEOHASH_CELL_WIDTH
- 22.24 SDO_CS.INSERT_SRID
- 22.25 SDO_CS.LOAD_EPSG_MATRIX
- 22.26 SDO_CS.MAKE_2D
- 22.27 SDO_CS.MAKE_3D
- 22.28 SDO_CS.MAP_EPSG_SRID_TO_ORACLE
- 22.29 SDO_CS.MAP_ORACLE_SRID_TO_EPSG
- 22.30 SDO_CS.REVOKE_PREFERENCE_FOR_OP
- 22.31 SDO_CS.TO_GEOHASH
- 22.32 SDO_CS.TO_OGC_SIMPLEFEATURE_SRS
- 22.33 SDO_CS.TO_USNG
- 22.34 SDO_CS.TRANSFORM
- 22.35 SDO_CS.TRANSFORM_LAYER
- 22.36 SDO_CS.UPDATE_WKTS_FOR_ALL_EPSG_CRS
- 22.37 SDO_CS.UPDATE_WKTS_FOR_EPSG_CRS
- 22.38 SDO_CS.UPDATE_WKTS_FOR_EPSG_DATUM
- 22.39 SDO_CS.UPDATE_WKTS_FOR_EPSG_ELLIPS
- 22.40 SDO_CS.UPDATE_WKTS_FOR_EPSG_OP
- 22.41 SDO_CS.UPDATE_WKTS_FOR_EPSG_PARAM
- 22.42 SDO_CS.UPDATE_WKTS_FOR_EPSG_PM
- 22.43 SDO_CS.VALIDATE_EPSG_MATRIX
- 22.44 SDO_CS.VALIDATE_WKT
- 23 SDO_CSW Package (Catalog Services for the Web)
-
24
SDO_GCDR Package (Geocoding)
- 24.1 SDO_GCDR.CREATE_PROFILE_TABLES
- 24.2 SDO_GCDR.ELOC_DRIVE_TIME_POLYGON
- 24.3 SDO_GCDR.ELOC_GEOCODE
- 24.4 SDO_GCDR.ELOC_GEOCODE_AS_GEOM
- 24.5 SDO_GCDR.ELOC_GRANT_ACCESS
- 24.6 SDO_GCDR.ELOC_ISO_POLYGON
- 24.7 SDO_GCDR.ELOC_REVOKE_ACCESS
- 24.8 SDO_GCDR.ELOC_ROUTE
- 24.9 SDO_GCDR.ELOC_ROUTE_DISTANCE
- 24.10 SDO_GCDR.ELOC_ROUTE_GEOM
- 24.11 SDO_GCDR.ELOC_ROUTE_TIME
- 24.12 SDO_GCDR.GEOCODE
- 24.13 SDO_GCDR.GEOCODE_ADDR
- 24.14 SDO_GCDR.GEOCODE_ADDR_ALL
- 24.15 SDO_GCDR.GEOCODE_ALL
- 24.16 SDO_GCDR.GEOCODE_AS_GEOMETRY
- 24.17 SDO_GCDR.REVERSE_GEOCODE
-
25
SDO_GEOM Package (Geometry)
- 25.1 SDO_GEOM.DTW_DISTANCE
- 25.2 SDO_GEOM.RELATE
- 25.3 SDO_GEOM.SDO_ALPHA_SHAPE
- 25.4 SDO_GEOM.SDO_ARC_DENSIFY
- 25.5 SDO_GEOM.SDO_AREA
- 25.6 SDO_GEOM.SDO_BUFFER
- 25.7 SDO_GEOM.SDO_CENTROID
- 25.8 SDO_GEOM.SDO_CLOSEST_POINTS
- 25.9 SDO_GEOM.SDO_CONCAVEHULL
- 25.10 SDO_GEOM.SDO_CONCAVEHULL_BOUNDARY
- 25.11 SDO_GEOM.SDO_CONVEXHULL
- 25.12 SDO_GEOM.SDO_DIAMETER
- 25.13 SDO_GEOM.SDO_DIAMETER_LINE
- 25.14 SDO_GEOM.SDO_DIFFERENCE
- 25.15 SDO_GEOM.SDO_DISTANCE
- 25.16 SDO_GEOM.SDO_INTERSECTION
- 25.17 SDO_GEOM.SDO_LENGTH
- 25.18 SDO_GEOM.SDO_MAX_MBR_ORDINATE
- 25.19 SDO_GEOM.SDO_MAXDISTANCE
- 25.20 SDO_GEOM.SDO_MAXDISTANCE_LINE
- 25.21 SDO_GEOM.SDO_MBC
- 25.22 SDO_GEOM.SDO_MBC_CENTER
- 25.23 SDO_GEOM.SDO_MBC_RADIUS
- 25.24 SDO_GEOM.SDO_MBR
- 25.25 SDO_GEOM.SDO_MIN_MBR_ORDINATE
- 25.26 SDO_GEOM.SDO_POINTONSURFACE
- 25.27 SDO_GEOM.SDO_SELF_UNION
- 25.28 SDO_GEOM.SDO_TRIANGULATE
- 25.29 SDO_GEOM.SDO_UNION
- 25.30 SDO_GEOM.SDO_VOLUME
- 25.31 SDO_GEOM.SDO_WIDTH
- 25.32 SDO_GEOM.SDO_WIDTH_LINE
- 25.33 SDO_GEOM.SDO_XOR
- 25.34 SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
- 25.35 SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT
- 25.36 SDO_GEOM.WITHIN_DISTANCE
-
26
SDO_LRS Package (Linear Referencing System)
- 26.1 SDO_LRS.CLIP_GEOM_SEGMENT
- 26.2 SDO_LRS.CONCATENATE_GEOM_SEGMENTS
- 26.3 SDO_LRS.CONNECTED_GEOM_SEGMENTS
- 26.4 SDO_LRS.CONVERT_TO_LRS_DIM_ARRAY
- 26.5 SDO_LRS.CONVERT_TO_LRS_GEOM
- 26.6 SDO_LRS.CONVERT_TO_LRS_LAYER
- 26.7 SDO_LRS.CONVERT_TO_STD_DIM_ARRAY
- 26.8 SDO_LRS.CONVERT_TO_STD_GEOM
- 26.9 SDO_LRS.CONVERT_TO_STD_LAYER
- 26.10 SDO_LRS.DEFINE_GEOM_SEGMENT
- 26.11 SDO_LRS.DYNAMIC_SEGMENT
- 26.12 SDO_LRS.FIND_LRS_DIM_POS
- 26.13 SDO_LRS.FIND_MEASURE
- 26.14 SDO_LRS.FIND_OFFSET
- 26.15 SDO_LRS.GEOM_SEGMENT_END_MEASURE
- 26.16 SDO_LRS.GEOM_SEGMENT_END_PT
- 26.17 SDO_LRS.GEOM_SEGMENT_LENGTH
- 26.18 SDO_LRS.GEOM_SEGMENT_START_MEASURE
- 26.19 SDO_LRS.GEOM_SEGMENT_START_PT
- 26.20 SDO_LRS.GET_MEASURE
- 26.21 SDO_LRS.GET_NEXT_SHAPE_PT
- 26.22 SDO_LRS.GET_NEXT_SHAPE_PT_MEASURE
- 26.23 SDO_LRS.GET_PREV_SHAPE_PT
- 26.24 SDO_LRS.GET_PREV_SHAPE_PT_MEASURE
- 26.25 SDO_LRS.IS_GEOM_SEGMENT_DEFINED
- 26.26 SDO_LRS.IS_MEASURE_DECREASING
- 26.27 SDO_LRS.IS_MEASURE_INCREASING
- 26.28 SDO_LRS.IS_SHAPE_PT_MEASURE
- 26.29 SDO_LRS.LOCATE_PT
- 26.30 SDO_LRS.LRS_INTERSECTION
- 26.31 SDO_LRS.MEASURE_RANGE
- 26.32 SDO_LRS.MEASURE_TO_PERCENTAGE
- 26.33 SDO_LRS.OFFSET_GEOM_SEGMENT
- 26.34 SDO_LRS.PERCENTAGE_TO_MEASURE
- 26.35 SDO_LRS.PROJECT_PT
- 26.36 SDO_LRS.REDEFINE_GEOM_SEGMENT
- 26.37 SDO_LRS.RESET_MEASURE
- 26.38 SDO_LRS.REVERSE_GEOMETRY
- 26.39 SDO_LRS.REVERSE_MEASURE
- 26.40 SDO_LRS.SCALE_GEOM_SEGMENT
- 26.41 SDO_LRS.SET_PT_MEASURE
- 26.42 SDO_LRS.SPLIT_GEOM_SEGMENT
- 26.43 SDO_LRS.TRANSLATE_MEASURE
- 26.44 SDO_LRS.VALID_GEOM_SEGMENT
- 26.45 SDO_LRS.VALID_LRS_PT
- 26.46 SDO_LRS.VALID_MEASURE
- 26.47 SDO_LRS.VALIDATE_LRS_GEOMETRY
- 27 SDO_MIGRATE Package (Upgrading)
- 28 SDO_OLS Package (OpenLS)
-
29
SDO_PC_PKG Package (Point Clouds)
- 29.1 SDO_PC_PKG.CLIP_PC
- 29.2 SDO_PC_PKG.CLIP_PC_FLAT
- 29.3 SDO_PC_PKG.CLIP_PC_FLAT_STRING
- 29.4 SDO_PC_PKG.CREATE_CONTOUR_GEOMETRIES
- 29.5 SDO_PC_PKG.CREATE_PC
- 29.6 SDO_PC_PKG.DROP_DEPENDENCIES
- 29.7 SDO_PC_PKG.GENERATE_CROSS_SECTION_AS_GEOMS
- 29.8 SDO_PC_PKG.GET_PT_IDS
- 29.9 SDO_PC_PKG.HAS_PYRAMID
- 29.10 SDO_PC_PKG.INIT
- 29.11 SDO_PC_PKG.PC_DIFFERENCE
- 29.12 SDO_PC_PKG.PC2DEM
- 29.13 SDO_PC_PKG.PRESERVES_LEVEL1
- 29.14 SDO_PC_PKG.SDO_PC_NN
- 29.15 SDO_PC_PKG.SDO_PC_NN_FOR_EACH
- 29.16 SDO_PC_PKG.TO_GEOMETRY
-
30
SDO_SAM Package (Spatial Analysis and Mining)
- 30.1 SDO_SAM.AGGREGATES_FOR_GEOMETRY
- 30.2 SDO_SAM.AGGREGATES_FOR_LAYER
- 30.3 SDO_SAM.BIN_GEOMETRY
- 30.4 SDO_SAM.BIN_LAYER
- 30.5 SDO_SAM.COLOCATED_REFERENCE_FEATURES
- 30.6 SDO_SAM.SIMPLIFY_GEOMETRY
- 30.7 SDO_SAM.SIMPLIFY_LAYER
- 30.8 SDO_SAM.SPATIAL_CLUSTERS
- 30.9 SDO_SAM.TILED_AGGREGATES
- 30.10 SDO_SAM.TILED_BINS
-
31
SDO_TIN_PKG Package (TINs)
- 31.1 SDO_TIN_PKG.CLIP_TIN
- 31.2 SDO_TIN_PKG.CREATE_MESHES
- 31.3 SDO_TIN_PKG.CREATE_TIN
- 31.4 SDO_TIN_PKG.DROP_DEPENDENCIES
- 31.5 SDO_TIN_PKG.GET_BLOCKING_METHOD
- 31.6 SDO_TIN_PKG.GET_NUM_POINTS
- 31.7 SDO_TIN_PKG.GET_TIN_BLOCK_SORT_ORDER
- 31.8 SDO_TIN_PKG.INIT
- 31.9 SDO_TIN_PKG.LIST_TIN_COLUMNS
- 31.10 SDO_TIN_PKG.LIST_TINS
- 31.11 SDO_TIN_PKG.PROJECT_ORDINATES_ONTO_TIN
- 31.12 SDO_TIN_PKG.TO_DEM
- 31.13 SDO_TIN_PKG.TO_GEOMETRY
- 32 SDO_TRKR Package (Location Tracking)
- 33 SDO_TUNE Package (Tuning)
- 34 SDO_WCS Package (Web Coverage Service)
-
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.DELETE_SDO_GEOM_METADATA
- 35.9 SDO_UTIL.DENSIFY_GEOMETRY
- 35.10 SDO_UTIL.DROP_WORK_TABLES
- 35.11 SDO_UTIL.ELLIPSE_POLYGON
- 35.12 SDO_UTIL.EXPAND_GEOM
- 35.13 SDO_UTIL.EXTRACT
- 35.14 SDO_UTIL.EXTRACT_ALL
- 35.15 SDO_UTIL.EXTRACT3D
- 35.16 SDO_UTIL.EXTRUDE
- 35.17 SDO_UTIL.FROM_GEOJSON
- 35.18 SDO_UTIL.FROM_GML311GEOMETRY
- 35.19 SDO_UTIL.FROM_GMLGEOMETRY
- 35.20 SDO_UTIL.FROM_JSON
- 35.21 SDO_UTIL.FROM_KMLGEOMETRY
- 35.22 SDO_UTIL.FROM_WKBGEOMETRY
- 35.23 SDO_UTIL.FROM_WKTGEOMETRY
- 35.24 SDO_UTIL.GEO_SEARCH
- 35.25 SDO_UTIL.GET_2D_FOOTPRINT
- 35.26 SDO_UTIL.GET_COORDINATE
- 35.27 SDO_UTIL.GET_TILE_ENVELOPE
- 35.28 SDO_UTIL.GET_VECTORTILE
- 35.29 SDO_UTIL.GETFIRSTVERTEX
- 35.30 SDO_UTIL.GETLASTVERTEX
- 35.31 SDO_UTIL.GETNUMELEM
- 35.32 SDO_UTIL.GETNUMVERTICES
- 35.33 SDO_UTIL.GETNURBSAPPROX
- 35.34 SDO_UTIL.GETVERTICES
- 35.35 SDO_UTIL.H3_BASE_CELL
- 35.36 SDO_UTIL.H3_BOUNDARY
- 35.37 SDO_UTIL.H3_CENTER
- 35.38 SDO_UTIL.H3_HEX_AREA
- 35.39 SDO_UTIL.H3_HEX_EDGELEN
- 35.40 SDO_UTIL.H3_NUM_CELLS
- 35.41 SDO_UTIL.H3_IS_CLASS3
- 35.42 SDO_UTIL.H3_KEY
- 35.43 SDO_UTIL.H3_MBR
- 35.44 SDO_UTIL.H3_PARENT
- 35.45 SDO_UTIL.H3_PENTAGON_AREA
- 35.46 SDO_UTIL.H3_PENTAGON_EDGELEN
- 35.47 SDO_UTIL.H3_RESOLUTION
- 35.48 SDO_UTIL.H3SUM_AS_TABLE
- 35.49 SDO_UTIL.H3SUM_CREATE_TABLE
- 35.50 SDO_UTIL.H3SUM_GET_CURSOR
- 35.51 SDO_UTIL.H3SUM_VECTORTILE
- 35.52 SDO_UTIL.INITIALIZE_INDEXES_FOR_TTS
- 35.53 SDO_UTIL.INSERT_SDO_GEOM_METADATA
- 35.54 SDO_UTIL.INTERIOR_POINT
- 35.55 SDO_UTIL.LINEAR_KEY
- 35.56 SDO_UTIL.POINT_AT_BEARING
- 35.57 SDO_UTIL.POLYGONTOLINE
- 35.58 SDO_UTIL.RECTIFY_GEOMETRY
- 35.59 SDO_UTIL.REMOVE_DUPLICATE_VERTICES
- 35.60 SDO_UTIL.REVERSE_LINESTRING
- 35.61 SDO_UTIL.SIMPLIFY
- 35.62 SDO_UTIL.SIMPLIFYVW
- 35.63 SDO_UTIL.THEME3D_GET_BLOCK_TABLE
- 35.64 SDO_UTIL.THEME3D_HAS_LOD
- 35.65 SDO_UTIL.THEME3D_HAS_TEXTURE
- 35.66 SDO_UTIL.TILE_GEOMETRY
- 35.67 SDO_UTIL.TO_GEOJSON
- 35.68 SDO_UTIL.TO_GEOJSON_JSON
- 35.69 SDO_UTIL.TO_GML311GEOMETRY
- 35.70 SDO_UTIL.TO_GMLGEOMETRY
- 35.71 SDO_UTIL.TO_JSON
- 35.72 SDO_UTIL.TO_JSON_JSON
- 35.73 SDO_UTIL.TO_JSON_VARCHAR
- 35.74 SDO_UTIL.TO_KMLGEOMETRY
- 35.75 SDO_UTIL.TO_WKBGEOMETRY
- 35.76 SDO_UTIL.TO_WKTGEOMETRY
- 35.77 SDO_UTIL.VALIDATE_3DTHEME
- 35.78 SDO_UTIL.VALIDATE_SCENE
- 35.79 SDO_UTIL.VALIDATE_VIEWFRAME
- 35.80 SDO_UTIL.VALIDATE_WKBGEOMETRY
- 35.81 SDO_UTIL.VALIDATE_WKTGEOMETRY
- 36 SDO_WFS_LOCK Package (WFS)
-
37
SDO_WFS_PROCESS Package (WFS Processing)
- 37.1 SDO_WFS_PROCESS.DropFeatureType
- 37.2 SDO_WFS_PROCESS.DropFeatureTypes
- 37.3 SDO_WFS_PROCESS.GenCollectionProcs
- 37.4 SDO_WFS_PROCESS.GetFeatureTypeId
- 37.5 SDO_WFS_PROCESS.GrantFeatureTypeToUser
- 37.6 SDO_WFS_PROCESS.GrantMDAccessToUser
- 37.7 SDO_WFS_PROCESS.InsertCapabilitiesInfo
- 37.8 SDO_WFS_PROCESS.InsertFtDataUpdated
- 37.9 SDO_WFS_PROCESS.InsertFtMDUpdated
- 37.10 SDO_WFS_PROCESS.PopulateFeatureTypeXMLInfo
- 37.11 SDO_WFS_PROCESS.PublishFeatureType
- 37.12 SDO_WFS_PROCESS.Publish_FeatureTypes_In_Schema
- 37.13 SDO_WFS_PROCESS.RegisterMTableView
- 37.14 SDO_WFS_PROCESS.RevokeFeatureTypeFromUser
- 37.15 SDO_WFS_PROCESS.RevokeMDAccessFromUser
- 37.16 SDO_WFS_PROCESS.UnRegisterMTableView
-
Supplementary Information
-
A
Installation, Migration, Compatibility, and Upgrade
- A.1 Manually Installing Spatial
- A.2 Migrating Spatial Data from One Database to Another
- A.3 Ensuring That GeoRaster Works Properly After an Installation or Upgrade
- A.4 Index Maintenance Before and After an Upgrade (WFS and CSW)
- A.5 Increasing the Size of Ordinate Arrays to Support Very Large Geometries
- B Complex Spatial Queries: Examples
- C Loading ESRI Shapefiles into Spatial
-
D
Routing Engine Administration
- D.1 Logging Administration Operations
- D.2 Network Data Model (NDM) Network Administration
- D.3 Routing Engine Data
-
D.4
User Data
- D.4.1 Restricted Driving Maneuvers User Data
- D.4.2 CREATE_TURN_RESTRICTION_DATA Procedure
- D.4.3 DUMP_TURN_RESTRICTION_DATA Procedure
- D.4.4 CREATE_TRUCKING_DATA Procedure
- D.4.5 DUMP_TRUCKING_DATA Procedure
- D.4.6 CREATE_TIMEZONE_DATA Procedure
- D.4.7 DUMP_TIMEZONE_DATA Procedure
- D.4.8 User Data Examples
- D.5 Other Functions and Procedures
-
A
Installation, Migration, Compatibility, and Upgrade
- Glossary
- Index