1. Index

Index

Numerics  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  

Numerics

A

  • ADD_PREFERENCE_FOR_OP procedure 22.1
  • adding a WebLogic data source 11.3.2.2
  • addresses
    • representing for geocoding 12.1.1
  • affine transformation
    • of input geometry 35.1
  • AFFINETRANSFORMS function 35.1
  • aggregate functions
    • description 1.10
    • reference information 21
    • SDO_AGGR_CENTROID 21.1
    • SDO_AGGR_CONCAT_LINES 21.2
    • SDO_AGGR_CONCAVEHULL 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 21.8
    • SDOAGGRTYPE object type 1.10.1
  • AGGREGATES_FOR_GEOMETRY function 30.1
  • AGGREGATES_FOR_LAYER function 30.2
  • aliases 6.7.2
  • ALL_ANNOTATION_TEXT_METADATA view 3.5.2
  • ALL_SDO_3DTHEMES view 2.9.1
  • ALL_SDO_GEOM_METADATA view 2.8
  • ALL_SDO_INDEX_INFO view 2.10.1.1
  • ALL_SDO_INDEX_METADATA view 2.10.1.2
  • ALL_SDO_SCENES view 2.9.2
  • ALL_SDO_VIEWFRAMES view 2.9.3
  • alpha shape
    • SDO_ALPHA_SHAPE function 25.2
  • ALTER INDEX statement 19.1
    • REBUILD clause 19.2
    • RENAME TO clause 19.3
  • angle units 6.8.2
  • annotation text 3.5
  • ANYINTERACT
    • SDO_ANYINTERACT operator 20.1
    • topological relationship 1.8
  • APPEND function 35.2
  • application size (hardware) requirements 1.28
  • arc
    • densifying 25.3
    • not supported with geodetic data or for transformations 6.2.6
  • area 25.4
  • area units 6.8.3
  • AVERAGE_MBR procedure 33.1
  • average minimum bounding rectangle 33.1

B

  • batch_route_request element 14.3.5.1
  • batched route requests 14.1.4
  • batch mode route requests 14.1.5
  • batch mode route responses
  • batch route requests 14.3.5.1
    • XML Schema definition 14.3.5
  • batch route responses
    • XML Schema definition 14.3.6
  • bearing
  • BEARING_TILT_FOR_POINTS procedure 35.3
  • BIN_GEOMETRY function 30.3
  • BIN_LAYER procedure 30.4
  • binning
  • bins
  • block table
    • getting for theme 35.63
  • boundary
    • of area 1.8
    • of line string 1.8
    • of multiline string 1.8
    • of polygon 1.8
  • bounding rectangle
  • box
  • British Grid Transformation OSTN02/OSGM02 6.9.7
  • B-tree index on points 5.1.3
  • buffer area 25.5
  • bulk loading of spatial data 4.1
  • business directory (YP)
    • data requirements and providers 13.2
    • data structures for 13.3
    • OpenLS service support and examples 15.3.4
    • support inSpatial 13

C

  • Cartesian coordinates 1.5.4, 6.1.2
  • cartographic text (annotation text) 3.5
  • cbtree_index=true 5.1.3
  • center of gravity (centroid) 25.6
  • centroid
    • SDO_AGGR_CENTROID aggregate function 21.1
    • SDO_CENTROID function 25.6
  • circle
    • creating polygon approximating 35.4
    • not supported with geodetic data or for projections 6.2.6
    • type 2.2.4
  • CIRCLE_POLYGON function 35.4
  • C language
    • examples (using OCI) 1.31
  • CLIP_GEOM_SEGMENT function 26.1
  • CLIP_PC_FLAT_STRING function 29.3
  • CLIP_PC_FLAT function 29.2
  • CLIP_PC function 29.1
  • CLIP_TIN function 31.1
  • clipping
    • geometric segment 7.5.3
  • closed tour (TSP) 14.1.3
  • closest points
    • SDO_CLOSEST_POINTS function 25.7
  • COLOCATED_REFERENCE_FEATURES procedure 30.5
  • colocation mining 9.4
  • COLUMN_NAME (in USER_SDO_GEOM_METADATA) 2.8.2
  • column name
    • restrictions on spatial column names 2.8.2
  • compatibility A
  • complex examples
    • queries B
  • composite B-tree index on points 5.1.3
  • compound element 2.2.4
  • compound line string 2.2.4, 2.7.3
  • compound polygon 2.2.4
  • computes a polygon representing the given cell
  • computes the center of the given H3 cell
  • computes the H3 cell for the given geodetic point
  • computes the parent H3 cell
  • CONCAT_LINES function 35.5
  • CONCATENATE_GEOM_SEGMENTS function 26.2
  • concatenating
  • concave hull
    • SDO_AGGR_CONCAVEHULL aggregate function 21.3
    • SDO_CONCAVEHULL_BOUNDARY function 25.9
    • SDO_CONCAVEHULL function 25.8
  • CONNECTED_GEOM_SEGMENTS function 26.3
  • consistency
    • checking for valid geometry types 25.33
  • constraining data to a geometry type 5.1.2
  • constructors
    • SDO_GEOMETRY object type 2.4
  • CONTAINS
    • SDO_CONTAINS operator 20.2
    • topological relationship 1.8
  • contour geometries
    • creating from point cloud 29.4
  • CONVERSION_FACTOR column
    • in SDO_ANGLE_UNITS table 6.8.2
    • in SDO_AREA_UNITS table 6.8.3
    • in SDO_DIST_UNITS table 6.8.5
  • CONVERT_3D_SRID_TO_2D function 22.2
  • CONVERT_NADCON_TO_XML procedure 22.3
  • CONVERT_NTV2_TO_XML procedure 22.4
  • CONVERT_TO_LRS_DIM_ARRAY function 26.4
  • CONVERT_TO_LRS_GEOM function 26.5
  • CONVERT_TO_LRS_LAYER function 26.6
  • CONVERT_TO_STD_DIM_ARRAY function 26.7
  • CONVERT_TO_STD_GEOM function 26.8
  • CONVERT_TO_STD_LAYER function 26.9
  • CONVERT_UNIT function 35.6
  • CONVERT_XML_TO_NADCON procedure 22.5
  • CONVERT_XML_TO_NTV2 procedure 22.6
  • CONVERT3007TO3008 function 35.7
  • converting
    • geometric segments
  • convex hull
    • SDO_AGGR_CONVEXHULL aggregate function 21.4
    • SDO_CONVEXHULL function 25.10
  • coordinate dimension
    • ST_CoordDim method 2.3
  • coordinate reference systems
    • See: coordinate systems
  • coordinates
  • coordinate systems 1.5.4
    • conceptual and usage information 6
    • data structures supplied by Oracle 6.7
    • example 6.14
    • local 6.3
    • subprogram reference information 22
    • unit of measurement support 2.11
    • user-defined 6.9
  • COVEREDBY
    • SDO_COVEREDBY operator 20.3
    • topological relationship 1.8
  • COVERS
    • SDO_COVERS operator 20.4
    • topological relationship 1.8
  • CPU requirements for applications using Spatial 1.28
  • CREATE_CONCATENATED_OP procedure 22.7
  • CREATE_CONTOUR_GEOMETRIES function 29.4
  • CREATE_MESHES function 31.2
  • CREATE_OBVIOUS_EPSG_RULES procedure 22.8
  • CREATE_PC procedure 29.5
  • CREATE_PREF_CONCATENATED_OP procedure 22.9
  • CREATE_PROFILE_TABLES procedure 24.1
  • CREATE_SPATIAL_IDX procedure 23.1
  • CREATE_TIN procedure 31.3
  • CREATE_TRACKING_SET procedure 32.1
  • CREATE_XQFT_IDX procedure 23.2
  • CREATE INDEX statement 19.4
  • creates a cursor for the results of searching an H3 summary table
  • creates and returns the specified MVT vector tile from an H3 summary table
  • creates an H3 summary table for geodetic points data
    • H3SUM_CREATE_TABLE 35.49
  • creating
    • geometric segments
      • subprograms for 26
  • cross-schema index creation 5.1.4
  • CS_SRS table 6.8.1
  • current release
    • upgrading spatial data to 27.1

D

  • database links
    • not supported if spatial index is defined on the table 5.2
  • data mining
    • spatial
      • colocation mining 9.4
      • conceptual and usage information 9
      • function reference information 30
  • data model 1.5
  • data types
    • geocoding 12.2
    • spatial 2
  • datum
    • geodetic 1.5.4, 6.1.6
    • MDSYS.SDO_DATUMS_OLD_FORMAT table 6.8.4
    • MDSYS.SDO_DATUMS_OLD_SNAPSHOT table 6.8.4
    • transformation 6.1.7
  • dblink
    • not supported if spatial index is defined on the table 5.2
  • DEFINE_GEOM_SEGMENT procedure 26.10
  • defining
    • geometric segment 7.5.1
  • DELETE_ALL_EPSG_RULES procedure 22.10
  • DELETE_OP procedure 22.11
  • DELETE_SDO_GEOM_METADATA procedure 35.8
  • densification of arcs 25.3
  • DENSIFY_GEOMETRY function 35.9
  • deploying in WebLogic server
  • deploying spatial web services in WLS
    • setting up GeoRaster REST API 11.3.2.3
  • DETERMINE_CHAIN function 22.12
  • DETERMINE_DEFAULT_CHAIN function 22.13
  • diameter
    • SDO_DIAMETER_LINE function 25.12
    • SDO_DIAMETER function 25.11
  • difference
    • SDO_GEOM.SDO_DIFFERENCE function 25.13
  • dimension (in SDO_GTYPE) 2.2.1
    • Get_Dims method 2.3
    • Get_LRS_Dim method 2.3
  • DIMINFO (in USER_SDO_GEOM_METADATA) 2.8.3
  • direction of geometric segment 7.1.3
    • concatenation result 7.5.5
  • discretization (binning)
    • See alsobins 9.2
    • spatial 9.2
  • DISJOINT
    • topological relationship 1.8
  • disk storage requirements for applications using Spatial 1.28
  • distance
    • SDO_NN_DISTANCE ancillary operator 20.11
    • WITHIN_DISTANCE function 25.35
  • distance units 6.8.5
  • distributed transactions
    • supported with R-tree spatial indexes 5.1.8
  • document-based feature types (WFS) 16.3
  • Douglas-Peucker algorithm for geometry simplification 35.61, 35.62
  • downgrading
    • Oracle Spatial to the previous Oracle Database release A
  • DROP_DEPENDENCIES procedure 29.6, 31.4
  • DROP_TRACKING_SET procedure 32.2
  • DROP_WORK_TABLES procedure 35.10
  • DropFeatureType procedure 37.1
  • DropFeatureTypes procedure 37.2
  • DROP INDEX statement 19.5
  • duplicate vertices
  • DYNAMIC_SEGMENT function 26.11
  • dynamic query window 5.2.1
  • dynamic segmentation 7.5.3

E

  • EDGE table
  • editing
    • geometric segments
      • subprograms for 26
  • ELEM_INFO (SDO_ELEM_INFO attribute) 2.2.4
  • elements 1.5.1
    • extracting from a geometry 35.13, 35.14
    • returning number of elements in a geometry 35.31
    • returning number of vertices in a geometry 35.32
  • ellipse
    • creating polygon approximating 35.11
  • ELLIPSE_POLYGON function 35.11
  • ellipsoidal height 6.2.3, 6.5.1
  • ellipsoids
    • MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table 6.8.6
    • MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table 6.8.6
  • embedded SDO_GEOMETRY object in user-defined type 10.1
  • EnableDBTxns procedure 36.1
  • end location for route 14.3.2.1
  • entity-relationship (E-R) diagram
  • EPSG
    • entity-relationship (E-R) diagram 6.4
    • mapping of table names to Oracle Spatial names 6.7.28
    • mapping Oracle SRID to 22.29
    • mapping SRID to Oracle SRID 22.28
    • model and use by Spatial 6.4
    • version number of dataset used by Spatial 22.21
  • EQUAL
    • SDO_EQUAL operator 20.5
    • topological relationship 1.8
  • E-R (entity-relationship diagram)
  • error messages
  • ESRI shapefiles
    • loading into Spatial C
  • ESTIMATE_RTREE_INDEX_SIZE function 33.2
  • ETYPE (SDO_ETYPE value) 2.2.4
  • European Petroleum Survey Group
    • See: EPSG
  • event 54700 5.2.4
  • examples
    • batch mode route request and response 14.3.4
    • C 1.31
    • complex queries B
    • coordinate systems 6.14
      • longitude/latitude example 1.32
    • creating, indexing, and querying spatial data 2.1
    • directory for Spatial examples 1.31
    • linear referencing system (LRS) 7.7
    • longitude/latitude data 1.32
    • many geometry types (creating) 2.7
    • OCI (Oracle Call Interface) 1.31
    • PL/SQL 1.31
    • route request and response 14.3.1
    • spatial reference systems
      • longitude/latitude example 1.32
    • SQL 1.31
  • exchanging partitions including indexes 5.1.6
  • EXPAND_GEOM function 35.12
  • Export utility
    • with spatial indexes and data 5.1.7
  • EXTENT_OF function 33.3
  • exterior polygon rings 2.2.4, 2.7.2
  • exterior solids 2.2.4
  • EXTRACT_ALL function 35.14
  • EXTRACT3D function 35.15
  • EXTRACT function 35.13
  • EXTRUDE function 35.16
  • extrusion

F

  • features
  • FILTER
    • SDO_FILTER operator 20.6
  • FILTER mask value for SDO_JOIN 20.9
  • FIND_GEOG_CRS function 22.14
  • FIND_LRS_DIM_POS function 26.12
  • FIND_MEASURE function 26.13
  • FIND_OFFSET function 26.14
  • FIND_PROJ_CRS function 22.15
  • FIND_SRID procedure 22.16
  • formatted addresses 12.1.1
  • FROM_GEOHASH function 22.17
  • FROM_GEOJSON function 35.17
  • FROM_GML311GEOMETRY function 35.18
  • FROM_GMLGEOMETRY function 35.19
  • FROM_JSON function 35.20
  • FROM_KMLGEOMETRY function 35.21
  • FROM_OGC_SIMPLEFEATURE_SRS function 22.18
  • FROM_USNG function 22.19
  • FROM_WKBGEOMETRY function 35.22
  • FROM_WKTGEOMETRY function 35.23
  • frustums 1.13.2
  • function-based indexes
    • with SDO_GEOMETRY objects 10.2
  • functions
    • spatial aggregate 21
    • supported by approximations with geodetic data 6.10.3

G

  • GC_ADDRESS_POINT_((lt))suffix((gt)) table 12.5.1
  • GC_AREA_((lt))suffix((gt)) table 12.5.2
  • GC_COUNTRY_PROFILE table 12.5.3
  • GC_INTERSECTION_((lt))suffix((gt)) table 12.5.4
  • GC_PARSER_PROFILEAFS table 12.5.6
  • GC_PARSER_PROFILES table 12.5.5
  • GC_POI_((lt))suffix((gt)) table 12.5.7
  • GC_POSTAL_CODE_((lt))suffix((gt)) table 12.5.8
  • GC_ROAD_((lt))suffix((gt)) table 12.5.9
  • GC_ROAD_SEGMENT_((lt))suffix((gt)) table 12.5.10
  • GenCollectionProcs procedure 37.3
  • GENERATE_CROSS_SECTION_AS_GEOMS function 29.7
  • GENERATE_SCRIPT_FROM_SRID function 22.20
  • GEO_SEARCH function 35.24
  • GEOCODE_ADDR_ALL function 24.4
  • GEOCODE_ADDR function 24.3
  • GEOCODE_ALL function 24.5
  • GEOCODE_AS_GEOMETRY function 24.6
  • GEOCODE function 24.2
  • geocoding 1.14
    • concepts 12.1
    • data requirements 12.3
    • data types for 12.2
    • error messages 12.1.4
    • from a place name 12.4
    • indexes required on tables for geocoding 12.5.11
    • match codes 12.1.3
    • match modes 12.1.2
    • reverse 24.7
    • subprogram reference information 24
    • usage information 12
  • geocoding requests
    • XML Schema definition 12.7.2
  • geocoding responses
    • XML Schema definition 12.7.3
  • geodetic coordinates 1.5.4, 6.1.3
    • arcs and circles not supported 6.2.6
    • functions supported by approximations 6.10.3
    • support for 6.2
  • geodetic datum 1.5.4, 6.1.6
  • geodetic MBRs 6.2.4
  • geographic coordinates
    • See: geodetic coordinates
  • geography markup language (GML)
  • geohash
    • support in Oracle Spatial 6.12
  • GeoJSON
  • GEOM_SEGMENT_END_MEASURE function 26.15
  • GEOM_SEGMENT_END_PT function 26.16
  • GEOM_SEGMENT_LENGTH function 26.17
  • GEOM_SEGMENT_START_MEASURE function 26.18
  • GEOM_SEGMENT_START_PT function 26.19
  • geometric segment
  • geometry subprograms
    • reference information 25
  • geometry types 1.4
    • constraining data to 5.1.2
    • Get_GType method 2.3
    • SDO_GTYPE 2.2.1
  • GeoRaster
    • enabling after upgrade A.3
  • GET_2D_FOOTPRINT function 35.25
  • GET_BLOCKING_METHOD function 31.5
  • GET_COORDINATE function 35.26
  • Get_Dims method 2.3
  • GET_EPSG_DATA_VERSION function 22.21
  • GET_GEOHASH_CELL_HEIGHT function 22.22
  • GET_GEOHASH_CELL_WIDTH function 22.23
  • Get_GeoJson method 2.3
  • Get_GType method 2.3
  • Get_LRS_Dim method 2.3
  • GET_MEASURE function 26.20
  • GET_NEXT_SHAPE_PT_MEASURE function 26.22
  • GET_NEXT_SHAPE_PT function 26.21
  • GET_NOTIFICATION_MSG procedure 32.3
  • GET_NUM_POINTS function 31.6
  • GET_PREV_SHAPE_PT_MEASURE function 26.24
  • GET_PREV_SHAPE_PT function 26.23
  • GET_PT_IDS function 29.8
  • GET_TILE_ENVELOPE function 35.27
  • GET_TIN_BLOCK_SORT_ORDER function 31.7
  • GET_VECTORTILE function 35.28
  • Get_WKB method 2.3
  • Get_WKT method 2.3
  • GetFeatureTypeId function 37.4
  • GETFIRSTVERTEX function 35.29
  • GETLASTVERTEX function 35.30
  • GETNUMELEM function 35.31
  • GETNUMVERTICES function 35.32
  • GETNURBSAPPROX function 35.33
  • GETVERTICES function 35.34
  • GML (geography markup language)
  • Google Maps
    • considerations for using with Spatial applications 6.13
  • GrantFeatureTypeToUser procedure 37.5
  • GrantMDAccessToUser procedure 37.6
  • gravity-related height 6.5.2
  • GTYPE (SDO_GTYPE attribute) 2.2.1
    • constraining data to a geometry type 5.1.2
    • Get_Dims method 2.3
    • Get_GType method 2.3
    • GET_LRS_Dim method 2.3

H

  • H3_BASE_CELL function 35.35
  • H3_BOUNDARY function 35.36
  • H3_CENTER function 35.37
  • H3_HEX_AREA function 35.38
  • H3_HEX_EDGELEN function 35.39
  • H3_IS_CLASS3 function 35.41
  • H3_KEY function 35.42
  • H3_MBR function 35.43
  • H3_NUM_CELLS function 35.40
  • H3_PARENT function 35.44
  • H3_PENTAGON_AREA function 35.45
  • H3_PENTAGON_EDGELEN function 35.46
  • H3_RESOLUTION function 35.47
  • H3SUM_AS_TABLE function 35.48
  • H3SUM_CREATE_TABLE function 35.49
  • H3SUM_GET_CURSOR function 35.50
  • H3SUM_VECTORTILE function 35.51
  • hardware requirements for applications using Spatial 1.28
  • HAS_PYRAMID function 29.9
  • height
    • ellipsoidal 6.5.1
    • ellipsoidal and non-ellipsoidal 6.2.3
    • gravity-related 6.5.2

I

  • id attribute
  • Import utility
    • with spatial indexes and data 5.1.7
  • indexes
    • creating 5.1
    • description of Spatial indexing 1.7
    • extending spatial indexing capabilities 10
    • function-based with SDO_GEOMETRY objects 10.2
    • granting CREATE TABLE to collect spatial index statistics 5.1.9
    • partitioned 5.1.5
      • exchanging partitions including indexes 5.1.6
    • rebuilding 19.2
    • R-tree
      • description 1.7.1
      • requirements before creating 5.1.10
    • size (R-tree) 33.2
  • index-organized tables
  • INIT function 29.10, 31.8
  • INITIALIZE_CSW procedure 23.3
  • INITIALIZE_INDEXES_FOR_TTS procedure 35.52
  • input_location element 14.3.2.3
  • INSERT_SDO_GEOM_METADATA procedure 35.53
  • INSERT_SRID procedure 22.24
  • InsertCapabilitiesInfo procedure 37.7
  • InsertFtDataUpdated procedure 37.8
  • InsertFtMDUpdated procedure 37.9
  • inserting spatial data
  • INSIDE
    • SDO_INSIDE operator 20.8
    • topological relationship 1.8
  • installation A
  • interaction
    • ANYINTERACT 1.8
  • interior
    • of an area 1.8
  • INTERIOR_POINT function 35.54
  • interior polygon rings 2.2.4, 2.7.2
  • interior solids 2.2.4
  • International Organization for Standardization (ISO)
    • compliance of Spatial with standards 1.23
  • INTERPRETATION (SDO_INTERPRETATION value) 2.2.4
  • intersection 25.15, 26.30
  • intersections
    • GC_INTERSECTION_((lt))suffix((gt)) table 12.5.4
  • interval partitioning
  • inverse flattening 6.7.23, 6.8.6
  • IS_GEOM_SEGMENT_DEFINED function 26.25
  • IS_MEASURE_DECREASING function 26.26
  • IS_MEASURE_INCREASING function 26.27
  • IS_SHAPE_PT_MEASURE function 26.28
  • ISO (International Organization for Standardization)
    • compliance of Spatial with standards 1.23

J

  • Java application programming interface (API) for Spatial 1.20
  • join
    • SDO_JOIN operator 20.9
  • JSON
    • FROM_GEOJSON function 35.17
    • FROM_JSON function 35.20
    • GeoJSON support in Oracle Spatial 1.16.2
    • Get_GeoJson method 2.3
    • schema used for storing spatial data in JSON format 1.16.3
    • support in Oracle Spatial 1.16, 1.16.1
    • TO_GEOJSON_JSON function 35.68
    • TO_GEOJSON function 35.67
    • TO_JSON_JSON function 35.72
    • TO_JSON_VARCHAR function 35.73
    • TO_JSON function 35.71

K

  • Keyhole Markup Language (KML)
    • FROM_KMLGEOMETRY function 35.21
    • TO_KMLGEOMETRY function 35.74
  • KML
    • FROM_KMLGEOMETRY function 35.21
    • TO_KMLGEOMETRY function 35.74

L

  • layer 1.5.3
    • transforming 22.35
    • validating with context 25.34
  • layer_gtype
    • constraining data to a geometry type 5.1.2
  • length
    • SDO_LENGTH function 25.16
  • length_unit attribute
  • levels of detail (LODs)
    • checking if theme has 35.64
  • line
  • LINEAR_KEY function 35.55
  • linear features 7.1.10
  • linear key
    • of input geometry 35.55
  • linear measure 7.1.4
  • linear referencing system (LRS)
    • 3D formats of functions 7.4
      • not supported with geodetic data 6.10.2
    • conceptual and usage information 7
    • data model 7.2
    • example 7.7
    • Get_LRS_Dim method 2.3
    • limiting indexing to X and Y dimensions 7.3
    • LRS points 7.1.9
    • segments 7.1.1
    • subprogram reference information 26
    • tolerance values with LRS functions 7.6
  • line string
  • LIST_TIN_COLUMNS function 31.9
  • LIST_TINS function 31.10
  • LOAD_EPSG_MATRIX procedure 22.25
  • loading spatial data 4
  • local coordinates 1.5.4, 6.1.5
  • local coordinate systems 6.3
  • LOCAL partitioning
  • LOCATE_PT function 26.29
  • location data enrichment 1.15
    • adding user data to the geographic name hierarchy 1.15.2
    • ELOC_ADMIN_AREA_SEARCH table 1.15.1
  • location for route segment 14.3.2.1
  • location messages 32.4, 32.5
  • location prospecting 9.6
  • location tracking messages
    • SEND_LOCATION_MSGS procedure 32.4
    • SEND_TRACKING_MSG procedure 32.5
  • location tracking server
    • conceptual and usage information 8
  • location tracking set
    • CREATE_TRACKING_SET procedure 32.1
    • DROP_TRACKING_SET procedure 32.2
    • GET_NOTIFICATION_MSGprocedure 32.3
    • START_TRACKING_SET procedure 32.6
    • STOP_TRACKING_SET procedure 32.7
  • location tracking subprograms 32
  • locationType type 14.4.1
  • LODs (levels of detail)
    • checking if theme has 35.64
  • LRS
    • See: linear referencing system (LRS)
  • LRS_INTERSECTION function 26.30
  • LRS points 7.1.9

M

  • MAKE_3D function 22.26, 22.27
  • MakeOpenLSClobRequest function 28.1
  • MakeOpenLSRequest function 28.2
  • MAP_EPSG_SRID_TO_ORACLE function 22.28
  • MAP_ORACLE_SRID_TO_EPSG function 22.29
  • map projections
    • MDSYS.SDO_PROJECTIONS_OLD_FORMAT table 6.8.7
    • MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table 6.8.7
  • match codes 12.1.3
  • match modes 12.1.2
  • match vector (MatchVector attribute)
  • max-corner values
    • for three-dimensional rectangle 1.13.3
  • MBR
    • See: minimum bounding rectangle (MBR)
  • MDDATA account and schema 1.21
  • MDSYS.CS_SRS table 6.8.1
  • MDSYS.MOVE_SDO procedure 1.27
  • MDSYS.SDO_ANGLE_UNITS table 6.8.2
  • MDSYS.SDO_AREA_UNITS view 6.8.3
  • MDSYS.SDO_CS package 22
  • MDSYS.SDO_DATUMS_OLD_FORMAT table 6.8.4
  • MDSYS.SDO_DATUMS_OLD_SNAPSHOT table 6.8.4
  • MDSYS.SDO_DIST_UNITS view 6.8.5
  • MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table 6.8.6
  • MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table 6.8.6
  • MDSYS.SDO_GCDR package 24
  • MDSYS.SDO_OLS package 28
  • MDSYS.SDO_PROJECTIONS_OLD_FORMAT table 6.8.7
  • MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table 6.8.7
  • MDSYS.SDO_SAM package 30
  • MDSYS.SDO_WFS_LOCK package 36
  • MDSYS.SDO_WFS_PROCESS package 37
  • MDSYS.VERTEX_TYPE type 35.29, 35.30
  • MDSYS account and schema 1.21
  • MDSYS schema 1.1
    • must exist in destination database for migration A.2
  • mean sea level (MSL) 6.2.3.1
  • measure 7.1.4
  • MEASURE_RANGE function 26.31
  • MEASURE_TO_PERCENTAGE function 26.32
  • measure range 7.1.7
  • messages
    • Spatial error messages 1.30
  • methods
    • SDO_GEOMETRY object type 2.3
  • migration 27.1, A.2
    • See also: upgrading
  • min-corner values
    • for three-dimensional rectangle 1.13.3
  • minimum bounding circle
    • SDO_MBC_CENTER function 25.21
    • SDO_MBC_RADIUS function 25.22
    • SDO_MBC function 25.20
  • minimum bounding rectangle (MBR)
    • AVERAGE_MBR procedure 33.1
    • EXTENT_OF function 33.3
    • geodetic 6.2.4
    • SDO_AGGR_MBR aggregate function 21.6
    • SDO_MAX_MBR_ORDINATE function 25.17
    • SDO_MBR function 25.23
    • SDO_MIN_MBR_ORDINATE function 25.24
  • mining
    • See: data mining
  • MIX_INFO procedure 33.4
  • MOVE_SDO procedure 1.27
  • MSL (mean sea level) 6.2.3.1
  • multi-address routing 14.1
  • multiline string
  • multipolygon 2.7.2

N

  • NaC coordinate reference system 6.10.4
  • NADCON grids
    • converting Spatial XML format to NADCON format 22.5
    • converting to Spatial XML format 22.3
  • name conflicts
    • avoiding with SQL Multimedia implementations 3.4
  • naming considerations
    • Spatial table and column names 2.8
  • nav_strand 14.6.1
  • navigation strand (nav_strand) 14.6.1
  • nearest neighbor
    • SDO_NN_DISTANCE operator 20.11
    • SDO_NN operator 20.10
  • neighborhood influence 9.3
  • nested tables
    • spatial indexes not supported on 5.1
  • NODE table
  • non-ellipsoidal height 6.2.3
  • non-uniform rational B-spline (NURBS) curves 1.17
  • normal vector 1.13.5
  • NTv2 grids
    • converting Spatial XML format to NTv2 format 22.6
    • converting to Spatial XML format 22.4
  • NURBS curves
    • example 2.7.8
    • GETNURBSAPPROX function 35.33
    • support in Oracle Spatial 1.17

O

  • object types
  • OCG (Open Geospatial Consortium) simple features conformance 1.23
  • OCI (Oracle Call Interface) examples 1.31
  • offset 7.1.5
    • FIND_OFFSET function 26.14
  • OFFSET_GEOM_SEGMENT function 26.33
  • offsetting
    • geometric segment 7.5.7
  • OGC_X and OGC_Y function names 1.23
  • ON
    • SDO_ON operator 20.12
    • topological relationship 1.8
  • Open Geospatial Consortium (OCG) simple features conformance 1.23
  • OpenLS
    • subprogram reference information 28
  • OPENLS_DIR_BUSINESS_CHAINS table 13.3.2
  • OPENLS_DIR_BUSINESSES table 13.3.1
  • OPENLS_DIR_CATEGORIES table 13.3.3
  • OPENLS_DIR_CATEGORIZATIONS table 13.3.4
  • OPENLS_DIR_CATEGORY_TYPES table 13.3.5
  • OPENLS_DIR_SYNONYMS table 13.3.6
  • open tour (TSP) 14.1.3
  • operators
  • optimized box 2.2.4
  • optimized rectangle 2.2.4
  • optimizer hint (ORDERED) with spatial operators 1.9
  • Oracle Call Interface (OCI) examples 1.31
  • Oracle Database 10g
    • upgrading Spatial to A
  • Oracle Database In-Memory
    • support by Oracle Spatial 1.19
  • Oracle Data Mining
    • spatial analysis and mining information 9
  • Oracle Workspace Manager
    • using with WFS 16.8
  • Oracle XA transactions
    • supported with R-tree spatial indexes 5.1.8
  • ORDERED optimizer hint with spatial operators 1.9
  • Ordnance Survey grid transformation 6.9.7
  • oriented point
    • illustration and example 2.7.6
  • orthometric height 6.5.2
  • OSTN02/OSGM02 grid transformation 6.9.7
  • output_time_format attribute
  • OVERLAPBDYDISJOINT
    • SDO_OVERLAPBDYDISJOINT operator 20.13
    • topological relationship 1.8
  • OVERLAPBDYINTERSECT
    • SDO_OVERLAPBDYINTERSECT operator 20.14
    • topological relationship 1.8
  • OVERLAPS
    • SDO_OVERLAPS operator 20.15

P

  • parallel execution for index creation and rebuilding 19.1, 19.2, 19.4
  • parser profiles
    • GC_PARSER_PROFILEAFS table 12.5.6
    • GC_PARSER_PROFILES table 12.5.5
  • partitioned spatial indexes 5.1.5
    • exchanging partitions 5.1.6
  • PARTITION table
  • PC_DIFFERENCE function 29.11
  • PC2DEM procedure 29.12
  • PERCENTAGE_TO_MEASURE function 26.34
  • performance and tuning information 1.22
    • for Spatial operators 1.9
  • PL/SQL and SQL examples 1.31
  • point
    • data 1.5.1
    • illustration and examples of point-only geometry 2.7.5
    • interior on surface of polygon 35.54
    • locating on geometric segment 7.5.8
    • LRS 7.1.9
    • on surface of polygon 25.25
    • oriented point 2.7.6
    • projection of onto geometric segment 7.1.8, 7.5.9
    • shape 7.1.2
  • POINT_AT_BEARING function 35.56
  • point clouds
  • point of interest (POI)
    • GC_POI_((lt))suffix((gt)) table 12.5.7
  • polygon
    • area of 25.4
    • boundary of 1.8
    • buffer 25.5
    • centroid 25.6
    • compound 2.2.4
    • exterior and interior rings 2.2.4, 2.7.2
    • interior point on surface 35.54
    • point on surface 25.25
    • self-crossing not supported 1.4
    • self-intersecting polygons 25.33
    • with hole (LRS measure values) 7.1.11
  • polygon collection 2.7.2
  • polygon data 1.5.1
  • POLYGONTOLINE function 35.57
  • PopulateFeatureTypeXMLInfo procedure 37.10
  • populating
  • pre_geocoded_location element 14.3.2.4
  • PRESERVES_LEVEL1 function 29.13
  • primary filter 1.6, 5.2.1.1, 5.2.1.2
  • primitive types 1.4
  • problems in current release 6.10
  • PROJECT_ORDINATES_ONTO_TIN function 31.11
  • PROJECT_PT function 26.35
  • projected coordinates 1.5.4, 6.1.4
  • projections 7.1.8, 7.5.9
    • MDSYS.SDO_PROJECTIONS_OLD_FORMAT table 6.8.7
    • MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table 6.8.7
    • PROJECT_PT function 26.35
  • Publish_FeatureTypes_In_Schema procedure 37.12
  • PublishFeatureType procedure 37.11
  • pyramids

Q

  • quality
  • query 5.2.1
  • querying geometric segments
    • subprograms for 26
  • query model for Spatial 1.6
  • query window 5.2.1

R

  • range
  • README file
    • for Spatial, GeoRaster, and topology and network data models 1.33
  • rebuilding
    • spatial indexes 19.2
  • rectangle
  • rectification of geometries 35.58
  • RECTIFY_GEOMETRY function 35.58
  • REDEFINE_GEOM_SEGMENT procedure 26.36
  • redefining
    • geometric segment 7.5.2
  • RegisterFeatureTable procedure 36.2
  • RegisterMTableView procedure 37.13
  • RELATE function 25.1
    • See also: SDO_RELATE operator
  • relational feature types (WFS) 16.3
  • release number (Spatial)
  • REMOVE_DUPLICATE_VERTICES function 35.59
  • RESET_MEASURE procedure 26.37
  • restrictions in current release 6.10
  • return_route_geometry attribute
  • return_segment_geometry attribute
  • returns a boolean that determines if the cells at the given level are “Class 3”
  • returns rows from an H3 summary table
  • returns the base cell corresponding to the given cell
  • returns the minimum, maximum, or average area of hexes
  • returns the minimum, maximum, or average edgelen of hexes
  • returns the number of H3 cells at the specified resolution
  • returns the resolution of an H3 cell
  • returns the size of a pentagon at the given resolution
    • H3_PENTAGON_AREA 35.45
    • H3_PENTAGON_EDGELEN 35.46
  • REVERSE_GEOCODE function 24.7
  • REVERSE_GEOMETRY function 26.38
  • REVERSE_LINESTRING function 35.60
  • REVERSE_MEASURE function 26.39
  • reverse geocoding 24.7
  • REVOKE_PREFERENCE_FOR_OP procedure 22.30
  • RevokeFeatureTypeFromUser procedure 37.14
  • RevokeMDAccessFromUser procedure 37.15
  • ring
    • exterior and interior polygon 2.2.4
    • extracting from a geometry 35.13, 35.14
  • road_preference attribute
  • roads
    • GC_ROAD_((lt))suffix((gt)) table 12.5.9
  • road segments
    • GC_ROAD_SEGMENT_((lt))suffix((gt)) table 12.5.10
  • rollback segment
    • R-tree index creation 5.1.10
  • route_request element 14.3.2.1
  • route_type attribute
  • ROUTER_TIMEZONE_DATA table
  • ROUTER_TIMEZONES table
  • route requests 14.3.2.1
  • route responses
  • routing 14.1
  • routing engine
    • administration D
    • data structures used by 14.5
    • explanation and usage 14
    • multi-address routing 14.1
    • overview 14
    • routing 14.1
    • user data structures used by 14.6
    • XML API 14.3
  • routing engine servlet (WSServlet)
  • R-tree indexes
    • description of indexing process 1.7.1
    • rebuilding 19.2
    • requirements before creating 5.1.10
    • sequence object 2.10.3
  • R-tree quality 1.7.2

S

  • SCALE_GEOM_SEGMENT function 26.40
  • scaling
    • geometric segment 7.5.6
  • scenes
  • schemas
    • creating index on table in another schema 5.1.4
    • invoking SDO_JOIN on table in another schema 20.9
  • SDO_ADDR_ARRAY data type 12.2.2
  • SDO_AGGR_CENTROID aggregate function 21.1
  • SDO_AGGR_CONCAT_LINES aggregate function 21.2
  • SDO_AGGR_CONCAVEHULL aggregate function 21.3
  • SDO_AGGR_CONVEXHULL aggregate function 21.4
  • SDO_AGGR_LRS_CONCAT aggregate function 21.5
  • SDO_AGGR_MBR aggregate function 21.6
  • SDO_AGGR_SET_UNION aggregate function 21.7
  • SDO_AGGR_UNION aggregate function 21.8
  • SDO_ALPHA_SHAPE function 25.2
  • SDO_ANGLE_UNITS table 6.8.2
  • SDO_ANYINTERACT operator 20.1
  • SDO_ARC_DENSIFY function 25.3
  • SDO_AREA_UNITS view 6.8.3
  • SDO_AREA function 25.4
  • SDO_BUFFER function 25.5
  • SDO_CENTROID function 25.6
  • SDO_CLOSEST_POINTS_TYPE object type 25.7
  • SDO_CLOSEST_POINTS function 25.7
  • SDO_CONCAVEHULL_BOUNDARY function 25.9
  • SDO_CONCAVEHULL function 25.8
  • SDO_CONTAINS operator 20.2
  • SDO_CONVEXHULL function 25.10
  • SDO_COORD_AXES table 6.7.1
  • SDO_COORD_AXIS_NAMES table 6.7.2
  • SDO_COORD_OP_METHODS table 6.7.3
  • SDO_COORD_OP_PARAM_USE table 6.7.4
  • SDO_COORD_OP_PARAM_VALS table 6.7.5
  • SDO_COORD_OP_PARAMS table 6.7.6
  • SDO_COORD_OP_PATHS table 6.7.7
  • SDO_COORD_OPS table 6.7.8
  • SDO_COORD_REF_SYS table 6.7.9
  • SDO_COORD_REF_SYSTEM view 6.7.10
  • SDO_COORD_SYS table 6.7.11
  • SDO_COVEREDBY operator 20.3
  • SDO_COVERS operator 20.4
  • SDO_CRS_COMPOUND view 6.7.12
  • SDO_CRS_ENGINEERING view 6.7.13
  • SDO_CRS_GEOCENTRIC view 6.7.14
  • SDO_CRS_GEOGRAPHIC2D view 6.7.15
  • SDO_CRS_GEOGRAPHIC3D view 6.7.16
  • SDO_CRS_PROJECTED view 6.7.17
  • SDO_CRS_VERTICAL view 6.7.18
  • SDO_CS package 22
    • ADD_PREFERENCE_FOR_OP 22.1
    • CONVERT_3D_SRID_TO_2D 22.2
    • CONVERT_NADCON_TO_XML 22.3
    • CONVERT_NTV2_TO_XML 22.4
    • CONVERT_XML_TO_NADCON 22.5
    • CONVERT_XML_TO_NTV2 22.6
    • CREATE_CONCATENATED_OP 22.7
    • CREATE_OBVIOUS_EPSG_RULES 22.8
    • CREATE_PREF_CONCATENATED_OP 22.9
    • DELETE_ALL_EPSG_RULES 22.10
    • DELETE_OP 22.11
    • DETERMINE_CHAIN 22.12
    • DETERMINE_DEFAULT_CHAIN 22.13
    • FIND_GEOG_CRS 22.14
    • FIND_PROJ_CRS 22.15
    • FIND_SRID 22.16
    • FROM_GEOHASH 22.17
    • FROM_OGC_SIMPLEFEATURE_SRS 22.18
    • FROM_USNG 22.19
    • GENERATE_SCRIPT_FROM_SRID 22.20
    • GET_EPSG_DATA_VERSION function 22.21
    • GET_GEOHASH_CELL_HEIGHT 22.22
    • GET_GEOHASH_CELL_WIDTH 22.23
    • INSERT_SRID 22.24
    • LOAD_EPSG_MATRIX 22.25
    • MAKE_3D 22.26, 22.27
    • MAP_EPSG_SRID_TO_ORACLE 22.28
    • MAP_ORACLE_SRID_TO_EPSG 22.29
    • REVOKE_PREFERENCE_FOR_OP 22.30
    • TO_GEOHASH 22.31
    • TO_OGC_SIMPLEFEATURE_SRS 22.32
    • TO_USNG 22.33
    • TRANSFORM 22.34
    • TRANSFORM_LAYER 22.35
    • UPDATE_WKTS_FOR_ALL_EPSG_CRS 22.36
    • UPDATE_WKTS_FOR_EPSG_CRS 22.37
    • UPDATE_WKTS_FOR_EPSG_DATUM 22.38
    • UPDATE_WKTS_FOR_EPSG_ELLIPS 22.39
    • UPDATE_WKTS_FOR_EPSG_OP 22.40
    • UPDATE_WKTS_FOR_EPSG_PARAM 22.41
    • UPDATE_WKTS_FOR_EPSG_PM 22.42
    • VALIDATE_EPSG_MATRIX 22.43
    • VALIDATE_WKT 22.44
  • SDO_CSW package 23
    • CREATE_SPATIAL_IDX 23.1
    • CREATE_XQFT_IDX 23.2
    • INITIALIZE_CSW 23.3
    • SYNC_INDEX 23.4
  • SDO_DATUM_ENGINEERING view 6.7.19
  • SDO_DATUM_GEODETIC view 6.7.20
  • SDO_DATUM_VERTICAL view 6.7.21
  • SDO_DATUMS_OLD_FORMAT table 6.8.4
  • SDO_DATUMS_OLD_SNAPSHOT table 6.8.4
  • SDO_DATUMS table 6.7.22
  • SDO_DIAMETER_LINE function 25.12
  • SDO_DIAMETER function 25.11
  • SDO_DIFFERENCE function 25.13
  • SDO_DIST_UNITS view 6.8.5
  • SDO_DISTANCE function 25.14
  • SDO_ELEM_INFO_ARRAY type 2.2
  • SDO_ELEM_INFO attribute 2.2.4
  • SDO_ELLIPSOIDS_OLD_FORMAT table 6.8.6
  • SDO_ELLIPSOIDS_OLD_SNAPSHOT table 6.8.6
  • SDO_ELLIPSOIDS table 6.7.23
  • SDO_EQUAL operator 20.5
  • SDO_ETYPE value 2.2.4
  • SDO_FILTER operator 20.6
  • SDO_GCDR package 24
    • CREATE_PROFILE_TABLES 24.1
    • GEOCODE 24.2
    • GEOCODE_ADDR 24.3
    • GEOCODE_ADDR_ALL 24.4
    • GEOCODE_ALL 24.5
    • GEOCODE_AS_GEOMETRY 24.6
    • REVERSE_GEOCODE 24.7
  • SDO_GEO_ADDR data type and constructors 12.2.1
  • SDO_GEOM_MAX_X SQL Function 2.8.3.1
  • SDO_GEOM_MAX_Y SQL Function 2.8.3.1
  • SDO_GEOM_MAX_Z SQL Function 2.8.3.1
  • SDO_GEOM_MBR operator 20.7
  • SDO_GEOM_MIN_X SQL Function 2.8.3.1
  • SDO_GEOM_MIN_Y SQL Function 2.8.3.1
  • SDO_GEOM_MIN_Z SQL Function 2.8.3.1
  • SDO_GEOMETRY object type 2.2
    • constructors 2.4
    • embedding in user-defined type 10.1, 10.2.2
    • in function-based indexes 10.2
    • methods (member functions) 2.3
  • SDO_GEOM package
  • SDO_GTYPE
  • SDO_GTYPE attribute 2.2.1
    • constraining data to a geometry type 5.1.2
    • Get_Dims method 2.3
    • Get_GType method 2.3
    • Get_LRS_Dim method 2.3
  • SDO_INDEX_TABLE entry in index metadata views 2.10.2
  • SDO_INDX_DIMS keyword 7.3, 19.1
  • SDO_INSIDE operator 20.8
  • SDO_INTERPRETATION value 2.2.4
  • SDO_INTERSECTION function 25.15
  • SDO_JOIN operator 20.9
    • cross-schema invocation 20.9
  • SDO_KEYWORDARRAY data type 12.2.3
  • SDO_LENGTH function 25.16
  • SDO_LRS package
    • CLIP_GEOM_SEGMENT 26.1
    • CONCATENATE_GEOM_SEGMENTS 26.2
    • CONNECTED_GEOM_SEGMENTS 26.3
    • CONVERT_TO_LRS_DIM_ARRAY 26.4
    • CONVERT_TO_LRS_GEOM 26.5
    • CONVERT_TO_LRS_LAYER 26.6
    • CONVERT_TO_STD_DIM_ARRAY 26.7
    • CONVERT_TO_STD_GEOM 26.8
    • CONVERT_TO_STD_LAYER 26.9
    • DEFINE_GEOM_SEGMENT 26.10
    • DYNAMIC_SEGMENT 26.11
    • FIND_LRS_DIM_POS 26.12
    • FIND_MEASURE 26.13
    • FIND_OFFSET 26.14
    • GEOM_SEGMENT_END_MEASURE 26.15
    • GEOM_SEGMENT_END_PT 26.16
    • GEOM_SEGMENT_LENGTH 26.17
    • GEOM_SEGMENT_START_MEASURE 26.18
    • GEOM_SEGMENT_START_PT 26.19
    • GET_MEASURE 26.20
    • GET_NEXT_SHAPE_PT 26.21
    • GET_NEXT_SHAPE_PT_MEASURE 26.22
    • GET_PREV_SHAPE_PT 26.23
    • GET_PREV_SHAPE_PT_MEASURE 26.24
    • IS_GEOM_SEGMENT_DEFINED 26.25
    • IS_MEASURE_DECREASING 26.26
    • IS_MEASURE_INCREASING 26.27
    • IS_SHAPE_PT_MEASURE 26.28
    • LOCATE_PT 26.29
    • LRS_INTERSECTION 26.30
    • MEASURE_RANGE 26.31
    • MEASURE_TO_PERCENTAGE 26.32
    • OFFSET_GEOM_SEGMENT 26.33
    • PERCENTAGE_TO_MEASURE 26.34
    • PROJECT_PT 26.35
    • REDEFINE_GEOM_SEGMENT 26.36
    • RESET_MEASURE 26.37
    • REVERSE_GEOMETRY 26.38
    • REVERSE_MEASURE 26.39
    • SCALE_GEOM_SEGMENT 26.40
    • SET_PT_MEASURE 26.41
    • SPLIT_GEOM_SEGMENT 26.42
    • TRANSLATE_MEASURE 26.43
    • VALID_GEOM_SEGMENT 26.44
    • VALID_LRS_PT 26.45
    • VALID_MEASURE 26.46
    • VALIDATE_LRS_GEOMETRY 26.47
  • SDO_MAX_MBR_ORDINATE function 25.17
  • SDO_MAXDISTANCE_LINE function 25.19
  • SDO_MAXDISTANCE function 25.18
  • SDO_MBC_CENTER function 25.21
  • SDO_MBC_RADIUS function 25.22
  • SDO_MBC function 25.20
  • SDO_MBR function 25.23
  • SDO_MIGRATE package
  • SDO_MIN_MBR_ORDINATE function 25.24
  • SDO_NN_DISTANCE ancillary operator 20.11
  • SDO_NN_DISTANCE operator
    • complex examples B.3
  • SDO_NN operator 20.10
    • complex examples B.3
    • optimizer hints 20.10
  • SDO_OLS package 28
    • MakeOpenLSClobRequest 28.1
    • MakeOpenLSRequest 28.2
  • SDO_ON operator 20.12
  • SDO_ORDINATE_ARRAY type 2.2
  • SDO_ORDINATES attribute 2.2.5
  • SDO_OVERLAPBDYDISJOINT operator 20.13
  • SDO_OVERLAPBDYINTERSECT operator 20.14
  • SDO_OVERLAPS operator 20.15
  • SDO_PC_BLK_TYPE object type 2.6.2
  • SDO_PC_BLK object type 2.6.2
  • SDO_PC_NN_FOR_EACH function 29.15
  • SDO_PC_NN function 29.14
  • SDO_PC_PKG package
  • SDO_PC object type 2.6.1
  • SDO_POINT_TYPE object type 2.2
  • SDO_POINT attribute 2.2.3
  • SDO_POINTINPOLYGON operator 20.16
  • SDO_POINTONSURFACE function 25.25
  • SDO_PREFERRED_OPS_SYSTEM table 6.7.24
  • SDO_PREFERRED_OPS_USER table 6.7.25
  • SDO_PRIME_MERIDIANS table 6.7.26
  • SDO_PROJECTIONS_OLD_FORMAT table 6.8.7
  • SDO_PROJECTIONS_OLD_SNAPSHOT table 6.8.7
  • SDO_REGAGGR object type 30.2, 30.9
  • SDO_REGAGGRSET object type 30.2, 30.9
  • SDO_REGION object type 30.10
  • SDO_REGIONSET object type 30.10
  • SDO_RELATE operator 20.17
  • SDO_ROWIDPAIR object type 20.9
  • SDO_ROWIDSET data type 20.9
  • SDO_RTREE_SEQ_NAME sequence object 2.10.3
  • SDO_SAM package 30
    • AGGREGATES_FOR_GEOMETRY 30.1
    • AGGREGATES_FOR_LAYER 30.2
    • BIN_GEOMETRY 30.3
    • BIN_LAYER 30.4
    • COLOCATED_REFERENCE_FEATURES 30.5
    • SIMPLIFY_GEOMETRY 30.6
    • SIMPLIFY_LAYER 30.7
    • SPATIAL_CLUSTERS 30.8
    • TILED_AGGREGATES 30.9
    • TILED_BINS 30.10
  • SDO_SELF_UNION function 25.26
  • SDO_SRID
  • SDO_SRID attribute 2.2.2
  • SDO_ST_TOLERANCE table 3.3
  • SDO_STARTING_OFFSET value 2.2.4
  • SDO_TFM_CHAIN type 6.6
  • SDO_TIN_BLK_TYPE object type 2.5.2
  • SDO_TIN_BLK object type 2.5.2
  • SDO_TIN_PKG package
  • SDO_TIN object type 2.5.1
  • SDO_TOLERANCE SQL Function 1.5.5.3
  • SDO_TOUCH operator 20.18
  • SDO_TRIANGULATE function 25.27
  • SDO_TRKR package
    • CREATE_TRACKING_SET 32.1
    • DROP_TRACKING_SET 32.2
    • GET_NOTIFICATION_MSG 32.3
    • SEND_LOCATION_MSGS 32.4
    • SEND_TRACKING_MSG 32.5
    • START_TRACKING_SET 32.6
    • STOP_TRACKING_SET 32.7
  • SDO_TUNE package
  • SDO_UNION function 25.28
  • SDO_UNIT column
    • in SDO_AREA_UNITS table 6.8.3
    • in SDO_DIST_UNITS table 6.8.5
  • SDO_UNITS_OF_MEASURE table 6.7.27
  • SDO_UTIL package
  • SDO_VERSION function 1.24
  • SDO_VOLUME function 25.29
  • SDO_WCS.CreateTempTable procedure 34.1
  • SDO_WCS.DropTempTable procedure 34.2
  • SDO_WCS.GrantPrivilegesToWCS procedure 34.3
  • SDO_WCS.Init procedure 34.4
  • SDO_WCS.PublishCoverage procedure 34.5
  • SDO_WCS.RevokePrivilegesFromWCS procedure 34.6
  • SDO_WCS.UnpublishCoverage procedure 34.7
  • SDO_WCS.ValidateCoverages function 34.8
  • SDO_WCS package
    • CreateTempTable 34.1
    • DropTempTable 34.2
    • GrantPrivilegesToWCS 34.3
    • Init 34.4
    • PublishCoverage 34.5
    • RevokePrivilegesFromWCS 34.6
    • UnpublishCoverage 34.7
    • ValidateCoverages 34.8
  • SDO_WFS_LOCK package 36
    • EnableDBTxns 36.1
    • RegisterFeatureTable 36.2
    • UnRegisterFeatureTable 36.3
  • SDO_WFS_PROCESS package 37
    • DropFeatureType 37.1
    • DropFeatureTypes 37.2
    • GenCollectionProcs 37.3
    • GetFeatureTypeId 37.4
    • GrantFeatureTypeToUser 37.5
    • GrantMDAccessToUser 37.6
    • InsertCapabilitiesInfo 37.7
    • InsertFtDataUpdated 37.8
    • InsertFtMDUpdated 37.9
    • PopulateFeatureTypeXMLInfo 37.10
    • Publish_FeatureTypes_In_Schema 37.12
    • PublishFeatureType 37.11
    • RegisterMTableView 37.13
    • RevokeFeatureTypeFromUser 37.14
    • RevokeMDAccessFromUser 37.15
    • UnRegisterMTableView 37.16
  • SDO_WIDTH_LINE function 25.31
  • SDO_WIDTH function 25.30
  • SDO_WITHIN_DISTANCE operator 20.19
    • complex examples B.2
  • SDO_XOR function 25.32
  • SDOAGGRTYPE object type 1.10.1
  • sdows.ear file
  • sea level
    • gravity-related height 6.5.2
  • secondary filter 1.6, 5.2.1.2
  • segments
  • self-crossing line strings and polygons 1.4
  • self-intersecting polygons 25.33
  • self-joins
  • self union 25.26
  • semi-major axis 6.7.23, 6.8.6
  • semi-minor axis 6.7.23
  • SEND_LOCATION_MSGS procedure 32.4
  • SEND_TRACKING_MSG procedure 32.5
  • sequence object for R-tree index 2.10.3
  • SET_PT_MEASURE procedure 26.41
  • setting up GDAL 11.3.2.1
  • setting up GeoRaster REST API 11.3.2.3
  • shapefiles
    • loading into Spatial C
  • shape point 7.1.2
    • determining if measure value is a shape point 26.28
    • getting measure of next 26.22
    • getting measure of previous 26.24
    • getting next 26.21
    • getting previous 26.23
  • sharded database
    • support by Oracle Spatial 1.18
  • SIGN_POST table
    • routing engine use of 14.5.4
  • simple element 2.2.4
  • simple features (OGC)
    • Oracle Spatial conformance 1.23
  • simplification of geometries 35.61, 35.62
  • SIMPLIFY_GEOMETRY function 30.6
  • SIMPLIFY_LAYER procedure 30.7
  • SIMPLIFY function 35.61, 35.62
  • size requirements (hardware) for spatial applications 1.28
  • solids
  • SORT_AREA_SIZE parameter
    • R-tree index creation 5.1.10
  • SPATIAL_CLUSTERS function 30.8
  • SPATIAL_VECTOR_ACCELERATION system parameter 1.25
  • spatial aggregate functions
    • See: aggregate functions
  • spatial analysis and mining
    • conceptual and usage information 9
    • function reference information 30
  • spatial binning 9.2
    • See alsobins 9.2
  • spatial clustering 9.5
  • spatial correlation 9.3
  • spatial data mining
    • conceptual and usage information 9
    • function reference information 30
  • spatial data structures 2
  • spatial data types 2
  • spatial index
    • See: index
  • spatial indexes
    • interval partitioning example 5.1.1.1
    • system-managed 5.1.1
    • virtual column partitioning example 5.1.1.2
  • spatial join 5.2.2
    • SDO_JOIN operator 20.9
  • spatially enabling a table 1.26
  • Spatial metadata tables
  • spatial operators
    • See: operators
  • spatial query 5.2.1
  • spatial reference systems
    • conceptual and usage information 6
    • example 6.14
    • subprogram reference information 22
  • spatial routing engine
    • See: routing engine
  • Spatial Studio application 1.29
  • Spatialweb services
    • introduction 11
  • Spatial web services
  • speed limit
    • request and response examples 14.4.2.1
    • request and response schema definitions 14.4.2.2
    • support in WSServlet 14.4.2
  • spheroids
    • MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table 6.8.6
    • MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table 6.8.6
  • SPLIT_GEOM_SEGMENT procedure 26.42
  • splitting
    • geometric segment 7.5.4
  • SQL*Loader 4.1
  • SQL and PL/SQL examples 1.31
  • SQL Multimedia
    • avoiding name conflicts 3.4
    • FROM_WKBGEOMETRY function 35.22
    • FROM_WKTGEOMETRY function 35.23
    • ST_GEOMETRY type 3.1
    • support in Spatial 3
    • TO_WKBGEOMETRY function 35.75
    • TO_WKTGEOMETRY function 35.76
    • tolerance value 3.3
    • VALIDATE_WKBGEOMETRY function 35.80
    • VALIDATE_WKTGEOMETRY function 35.81
  • SQL Multimedia standard
    • ST_CoordDim method 2.3
    • ST_IsValid method 2.3
  • SQL statements
    • for indexing spatial data 19
  • SRID
    • checking for existence 22.16
    • finding 22.16
    • inserting 22.24
    • inserting SRID 22.24
    • in USER_SDO_GEOM_METADATA 2.8.4
    • mapping Oracle to EPSG 22.29
    • SDO_SRID attribute in SDO_GEOMETRY 2.2.2
  • ST_ANNOTATION_TEXT constructor 3.5.1
  • ST_CoordDim method 2.3
  • ST_GEOMETRY type 3.1
  • ST_IsValid method 2.3
  • start_date attribute
  • start_time attribute
  • START_TRACKING_SET procedure 32.6
  • start location for route 14.3.2.1
  • STOP_TRACKING_SET procedure 32.7
  • subprograms
    • coordinate system transformation 22
    • data mining 30
    • geocoding 24
    • geometry 25
    • linear referencing 26
    • location tracking 32
    • OpenLS 28
    • point clouds
    • SDO_CSW (Catalog Services for the Web) 23
    • SDO_MIGRATE 27
    • spatial analysis 30
    • TINs
    • tuning 33
    • utility
    • Web Coverage Service
    • WFS 36
    • WFS processing 37
  • subroutes
  • surface normal 1.13.5
  • surfaces 2.2.4
  • SYNC_INDEX procedure 23.4
  • system-managed indexes 5.1.1

T

  • TABLE_NAME (in USER_SDO_GEOM_METADATA) 2.8.1
  • table names
    • restrictions on spatial table names 2.8.1
  • tables
    • spatially enabling 1.26
  • textures
  • TFM_PLAN object type 6.6
  • THEME3D_GET_BLOCK_TABLE function 35.63
  • THEME3D_HAS_LOD function 35.64
  • THEME3D_HAS_TEXTURE function 35.65
  • themes
  • three-dimensional (3D)
  • TILE_GEOMETRY function 35.66
  • TILED_AGGREGATES function 30.9
  • TILED_BINS function 30.10
  • TINs
    • 3D mesh generation 31.2
    • clipping 31.1
    • converting to DEM 31.12
    • converting to geometry 31.13
    • creating 29.5, 31.3
    • dropping dependencies 31.4
    • get blocking method 31.5
    • get the blocking type 31.7
    • get total number of points for a TIN object 31.6
    • initializing 31.8
    • list all SDO_TIN column names 31.9
    • lists all the SDO_TIN objects 31.10
    • projecting ordinates onto 31.11
    • pyramiding 31.8
    • subprograms
  • TINs (triangulated irregular networks) 1.13.1
  • TO_CURRENT procedure and function 27.1
  • TO_DEM procedure 31.12
  • TO_GEOHASH function 22.31
  • TO_GEOJSON_JSON function 35.68
  • TO_GEOJSON function 35.67
  • TO_GEOMETRY function 29.16, 31.13
  • TO_GML311GEOMETRY function 35.69
  • TO_GMLGEOMETRY function 35.70
  • TO_JSON_JSON function 35.72
  • TO_JSON_VARCHAR function 35.73
  • TO_JSON function 35.71
  • TO_KMLGEOMETRY function 35.74
  • TO_OGC_SIMPLEFEATURE_SRS function 22.32
  • TO_USNG function 22.33
  • TO_WKBGEOMETRY function 35.75
  • TO_WKTGEOMETRY function 35.76
  • tolerance 1.5.5
    • for SQL Multimedia types 3.3
    • with LRS functions 7.6
  • topological self union 25.26
  • TOUCH
    • SDO_TOUCH operator 20.18
    • topological relationship 1.8
  • TP_USER_DATA table
  • tracking set 32.1, 32.2, 32.7, 32.3, 32.6
  • traffic speed
    • request and response examples 14.4.3.1
    • request and response schema definitions 14.4.3.2
    • support in WSServlet 14.4.3
  • transactional insertion of spatial data 4.2
  • TRANSFORM_LAYER procedure 22.35
    • table for transformed layer 22.35
  • transformation 6.1.7
    • arcs and circles not supported 6.2.6
  • TRANSFORM function 22.34
  • TRANSLATE_MEASURE function 26.43
  • transportable tablespaces
    • initializing spatial indexes 35.52
  • traveling salesperson (TSP) route 14.1.3
  • triangulated irregular networks (TINs) 1.13.1
  • triangulation
    • SDO_TRIANGULATE function 25.27
  • truck_height attribute
  • truck_length attribute
  • truck_per_axle_weight attribute
  • truck_type attribute
  • truck_weight attribute
  • truck_width attribute
  • TSP route 14.1.3
  • tuning and performance information 1.22
    • for spatial operators 1.9
  • tuning subprograms 33
  • two-tier query model 1.6
  • type zero (0) element 2.7.7

U

  • U.S. National Grid
    • SDO_CS.FROM_USNG function 22.19
    • SDO_CS.TO_USNG function 22.33
    • support in Oracle Spatial 6.11
  • unformatted addresses 12.1.1
  • union 25.28
  • UNIT_NAME column
    • in SDO_ANGLE_UNITS table 6.8.2
    • in SDO_AREA_UNITS table 6.8.3
    • in SDO_DIST_UNITS table 6.8.5
  • unit of measurement
  • unit-spheres 1.5.5.3
  • unknown CRS coordinate reference system 6.10.4
  • UnRegisterFeatureTable procedure 36.3
  • UnRegisterMTableView procedure 37.16
  • UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure 22.36
  • UPDATE_WKTS_FOR_EPSG_CRS procedure 22.37
  • UPDATE_WKTS_FOR_EPSG_DATUM procedure 22.38
  • UPDATE_WKTS_FOR_EPSG_ELLIPS procedure 22.39
  • UPDATE_WKTS_FOR_EPSG_OP procedure 22.40
  • UPDATE_WKTS_FOR_EPSG_PARAM procedure 22.41
  • UPDATE_WKTS_FOR_EPSG_PM procedure 22.42
  • upgrading
    • data to current Spatial release 27.1
    • GeoRaster A.3
    • Spatial to current Oracle Database release A
  • upgrading spatial data to current release 27.1
  • USE_SPHERICAL use case name 6.13
  • use cases
    • for coordinate system transformation 6.4
  • USER_ANNOTATION_TEXT_METADATA view 3.5.2
  • USER_SDO_3DTHEMES view 2.9.1
  • USER_SDO_GEOM_METADATA view 2.8
  • USER_SDO_INDEX_INFO view 2.10.1.1
  • USER_SDO_INDEX_METADATA view 2.10.1.2
  • USER_SDO_SCENES view 2.9.2
  • USER_SDO_VIEWFRAMES view 2.9.3
  • user-defined coordinate reference system 6.9
  • user-defined data types
  • utility subprograms

V

  • VALID_GEOM_SEGMENT function 26.44
  • VALID_LRS_PT function 26.45
  • VALID_MEASURE function 26.46
  • VALIDATE_3DTHEME function 35.77
  • VALIDATE_EPSG_MATRIX procedure 22.43
  • VALIDATE_GEOMETRY_WITH_CONTEXT function 25.33
  • VALIDATE_LAYER_WITH_CONTEXT procedure 25.34
  • VALIDATE_LRS_GEOMETRY function 26.47
  • VALIDATE_SCENE function 35.78
  • VALIDATE_VIEWFRAME function 35.79
  • VALIDATE_WKBGEOMETRY function 35.80
  • VALIDATE_WKT function 22.44
  • VALIDATE_WKTGEOMETRY function 35.81
  • validation of geometries
    • general and two-dimensional checks 25.33
    • importance of performing 4.3
    • three-dimensional checks 1.13.5
  • Vector Performance Accelerator (VPA) feature 1.25
  • vector tiles
    • aggregate function converting geometry into an MVT vector tile 35.28
    • spatial objects 1.11, 1.12
  • vehicle_type attribute
  • vendor attribute
  • version number (Spatial)
  • vertex
  • VERTEX_SET_TYPE data type 35.34
  • VERTEX_TYPE object type 35.34
  • VERTEX_TYPE type 35.29, 35.30
  • vertices
    • maximum number in SDO_GEOMETRY object 2.2
    • removing duplicate 35.59
    • returning geometry coordinates as 35.34
  • viewframes
  • views
    • ALL_ANNOTATION_TEXT_METADATA 3.5.2
    • ALL_SDO_GEOM_METADATA 2.8
    • ALL_SDO_INDEX_INFO 2.10.1.1
    • ALL_SDO_INDEX_METADATA 2.10.1.2
    • USER_ANNOTATION_TEXT_METADATA 3.5.2
    • USER_SDO_GEOM_METADATA 2.8
    • USER_SDO_INDEX_INFO 2.10.1.1
    • USER_SDO_INDEX_METADATA 2.10.1.2
  • virtual column partitioning
  • volume 25.29
  • VPA (Vector Performance Accelerator) feature 1.25

W

  • Web Coverage Service (WCS) subprograms
  • web services
    • deploying and configuring 11.3
    • introduction 11
  • well-known binary (WKB)
    • See: WKB
  • well-known text (WKT)
    • See: WKT
  • WFS
    • engine 16.1
    • feature types 16.3
    • subprogram reference information 36
    • using with Oracle Workspace Manager 16.8
  • WFS processing
    • subprogram reference information 37
  • width
    • SDO_WIDTH_LINE function 25.31
    • SDO_WIDTH function 25.30
  • WITHIN_DISTANCE function 25.35
    • See also: SDO_WITHIN_DISTANCE operator
  • WKB
    • FROM_WKBGEOMETRY function 35.22
    • Get_WKB method 2.3
    • TO_WKBGEOMETRY function 35.75
    • VALIDATE_WKBGEOMETRY function 35.80
  • WKT 6.8.1.1
    • FROM_WKTGEOMETRY function 35.23
    • Get_WKT method 2.3
    • procedures for updating 6.8.1.3
    • TO_WKTGEOMETRY function 35.76
    • UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure 22.36
    • UPDATE_WKTS_FOR_EPSG_CRS procedure 22.37
    • UPDATE_WKTS_FOR_EPSG_DATUM procedure 22.38
    • UPDATE_WKTS_FOR_EPSG_ELLIPS procedure 22.39
    • UPDATE_WKTS_FOR_EPSG_OP procedure 22.40
    • UPDATE_WKTS_FOR_EPSG_PARAM procedure 22.41
    • UPDATE_WKTS_FOR_EPSG_PM procedure 22.42
    • VALIDATE_WKTGEOMETRY function 35.81
    • validating (given SRID) 22.44
  • WKTEXT column of MDSYS.CS_SRS table 6.8.1.1
    • procedures for updating value 6.8.1.3
  • Workspace Manager
    • using with WFS 16.8
  • WSConfig.xml file 11.3
  • WSServlet exception handling 14.4.4

X

  • XA transactions
    • supported with R-tree spatial indexes 5.1.8
  • XML API
    • routing engine 14.3
    • routing engine servlet (WSServlet) 14.4
  • XOR

Y

  • Yellow Pages
    • See: business directory (YP)
  • YP
    • See: business directory (YP)

Z

  • zero