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

  • 0
    • type 0 (zero) element 2.7.7
  • 3D

A

  • ADD_PREFERENCE_FOR_OP procedure 22.1
  • addresses
    • representing for geocoding 12.1.1
  • affine transformation
    • of input geometry 35.1
  • AFFINETRANSFORMS procedure 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 31.1
  • AGGREGATES_FOR_LAYER function 31.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 26.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.25
  • arc
    • densifying 26.3
    • not supported with geodetic data or for transformations 6.2.6
  • area 26.4
  • area units 6.8.3
  • AVERAGE_MBR procedure 34.1
  • average minimum bounding rectangle 34.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 31.3
  • BIN_LAYER procedure 31.4
  • binning
  • bins
  • block table
    • getting for theme 35.42
  • 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 26.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 in Spatial and Graph 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) 26.6
  • centroid
    • SDO_AGGR_CENTROID aggregate function 21.1
    • SDO_CENTROID function 26.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.27
  • CLIP_GEOM_SEGMENT function 27.1
  • CLIP_PC_FLAT function 30.2
  • CLIP_PC function 30.1
  • CLIP_TIN function 32.1
  • clipping
    • geometric segment 7.5.3
  • closed tour (TSP) 14.1.3
  • closest points
    • SDO_CLOSEST_POINTS procedure 26.7
  • COLOCATED_REFERENCE_FEATURES procedure 31.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 C
  • 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
  • CONCAT_LINES function 35.5
  • CONCATENATE_GEOM_SEGMENTS function 27.2
  • concatenating
  • concave hull
    • SDO_AGGR_CONCAVEHULL aggregate function 21.3
    • SDO_CONCAVEHULL_BOUNDARY function 26.9
    • SDO_CONCAVEHULL function 26.8
  • CONNECTED_GEOM_SEGMENTS function 27.3
  • consistency
    • checking for valid geometry types 26.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 30.3
  • 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 27.4
  • CONVERT_TO_LRS_GEOM function 27.5
  • CONVERT_TO_LRS_LAYER function 27.6
  • CONVERT_TO_STD_DIM_ARRAY function 27.7
  • CONVERT_TO_STD_GEOM function 27.8
  • CONVERT_TO_STD_LAYER function 27.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 26.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 and Graph 1.25
  • CREATE_CONCATENATED_OP procedure 22.7
  • CREATE_CONTOUR_GEOMETRIES function 30.3
  • CREATE_OBVIOUS_EPSG_RULES procedure 22.8
  • CREATE_PC procedure 30.4
  • CREATE_PREF_CONCATENATED_OP procedure 22.9
  • CREATE_PROFILE_TABLES procedure 25.1
  • CREATE_SPATIAL_IDX procedure 23.1
  • CREATE_TIN procedure 32.2
  • CREATE_TRACKING_SET procedure 33.1
  • CREATE_XQFT_IDX procedure 23.2
  • CREATE INDEX statement 19.4
  • creating
    • geometric segments
      • subprograms for 27
  • cross-schema index creation 5.1.4
  • CS_SRS table 6.8.1
  • current release
    • upgrading spatial data to 28.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 31
  • 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 27.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
  • deleteDomainInfo method F.4.2
  • deleteRecordViewMap method F.4.3
  • densification of arcs 26.3
  • DENSIFY_GEOMETRY function 35.9
  • DETERMINE_CHAIN function 22.12
  • DETERMINE_DEFAULT_CHAIN function 22.13
  • diameter
    • SDO_DIAMETER_LINE function 26.12
    • SDO_DIAMETER function 26.11
  • difference
    • SDO_GEOM.SDO_DIFFERENCE function 26.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
  • disableVersioning method F.4.4
  • discretization (binning)
    • See alsobins 9.2
    • spatial 9.2
  • DISJOINT
    • topological relationship 1.8
  • disk storage requirements for applications using Spatial and Graph 1.25
  • distance
    • SDO_NN_DISTANCE ancillary operator 20.10
    • WITHIN_DISTANCE function 26.35
  • distance units 6.8.5
  • distributed transactions
    • supported with R-tree spatial indexes 5.1.8
  • document-based feature types (WFS) 16.3
  • domain information (CSW)
  • domains (CSW)
  • Douglas-Peucker algorithm for geometry simplification 35.40, 35.41
  • downgrading
    • Oracle Spatial to the previous Oracle Database release A
  • DROP_DEPENDENCIES procedure 30.5, 32.3
  • DROP_TRACKING_SET procedure 33.2
  • DROP_WORK_TABLES procedure 35.10
  • DropFeatureType procedure 38.1
  • DropFeatureTypes procedure 38.2
  • DROP INDEX statement 19.5
  • dropRecordType method F.4.5
  • dropXMLTableIndex method F.4.6
  • duplicate vertices
  • DYNAMIC_SEGMENT function 27.11
  • dynamic query window 5.2.1
  • dynamic segmentation 7.5.3

E

  • EDGE table
  • editing
    • geometric segments
      • subprograms for 27
  • 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.28
    • returning number of vertices in a geometry 35.29
  • 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 37.1
  • enableVersioning method F.4.7
  • 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.28
    • mapping SRID to Oracle SRID 22.27
    • 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 D
  • ESTIMATE_RTREE_INDEX_SIZE function 34.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.27
    • complex queries C
    • coordinate systems 6.14
    • creating, indexing, and querying spatial data 2.1
    • directory for Spatial examples 1.27
    • linear referencing system (LRS) 7.7
    • many geometry types (creating) 2.7
    • OCI (Oracle Call Interface) 1.27
    • PL/SQL 1.27
    • route request and response 14.3.1
    • SQL 1.27
  • 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 34.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
  • extractSDO function F.2.2
  • EXTRUDE function 35.16
  • extrusion

F

  • features
  • FILTER
    • SDO_FILTER operator 20.6
  • FILTER mask value for SDO_JOIN 20.8
  • FIND_GEOG_CRS function 22.14
  • FIND_LRS_DIM_POS function 27.12
  • FIND_MEASURE function 27.13
  • FIND_OFFSET function 27.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.11.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 38.3
  • GENERATE_SCRIPT_FROM_SRID function 22.20
  • GEO_SEARCH function 35.24
  • GEOCODE_ADDR_ALL function 25.4
  • GEOCODE_ADDR function 25.3
  • GEOCODE_ALL function 25.5
  • GEOCODE_AS_GEOMETRY function 25.6
  • GEOCODE function 25.2
  • geocoding 1.12
    • 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 25.7
    • subprogram reference information 25
    • 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 27.15
  • GEOM_SEGMENT_END_PT function 27.16
  • GEOM_SEGMENT_LENGTH function 27.17
  • GEOM_SEGMENT_START_MEASURE function 27.18
  • GEOM_SEGMENT_START_PT function 27.19
  • geometric segment
  • geometry subprograms
    • reference information 26
  • 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.2
  • gerRecordTypeId method F.4.9
  • GET_2D_FOOTPRINT function 35.25
  • 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 27.20
  • GET_NEXT_SHAPE_PT_MEASURE function 27.22
  • GET_NEXT_SHAPE_PT function 27.21
  • GET_NOTIFICATION_MSG procedure 33.3
  • GET_PREV_SHAPE_PT_MEASURE function 27.24
  • GET_PREV_SHAPE_PT function 27.23
  • GET_PT_IDS function 30.6
  • Get_WKB method 2.3
  • Get_WKT method 2.3
  • GetFeatureTypeId function 38.4
  • GETFIRSTVERTEX function 35.26
  • getIsXMLTableIndexCreated method F.4.8
  • GETLASTVERTEX function 35.27
  • GETNUMELEM function 35.28
  • GETNUMVERTICES function 35.29
  • GETNURBSAPPROX function 35.30
  • GETVERTICES function 35.31
  • GML (geography markup language)
  • Google Maps
    • considerations for using with Spatial applications 6.13
  • GrantFeatureTypeToUser procedure 38.5
  • grantMDAccessToUser method F.4.10
  • GrantMDAccessToUser procedure 38.6
  • grantRecordTypeToUser method F.4.11
  • 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

  • hardware requirements for applications using Spatial 1.25
  • HAS_PYRAMID function 30.7
  • 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) 34.2
  • index-organized tables
  • INIT function 30.8, 32.4
  • INITIALIZE_CSW procedure 23.3
  • INITIALIZE_INDEXES_FOR_TTS procedure 35.32
  • input_location element 14.3.2.3
  • INSERT_SDO_GEOM_METADATA procedure 35.33
  • InsertCapabilitiesInfo procedure 38.7
  • InsertFtDataUpdated procedure 38.8
  • InsertFtMDUpdated procedure 38.9
  • inserting spatial data
  • INSIDE
    • SDO_INSIDE operator 20.7
    • topological relationship 1.8
  • installation A
    • Oracle Multimedia requirement for Locator B
  • interaction
    • ANYINTERACT 1.8
  • interior
    • of an area 1.8
  • INTERIOR_POINT function 35.34
  • 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.20
  • INTERPRETATION (SDO_INTERPRETATION value) 2.2.4
  • intersection 26.15, 27.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 27.25
  • IS_MEASURE_DECREASING function 27.26
  • IS_MEASURE_INCREASING function 27.27
  • IS_SHAPE_PT_MEASURE function 27.28
  • ISO (International Organization for Standardization)
    • compliance of Spatial with standards 1.20

J

  • Java application programming interface (API) for Spatial 1.17
  • join
    • SDO_JOIN operator 20.8
  • JSON
    • FROM_GEOJSON function 35.17
    • FROM_JSON function 35.20
    • GeoJSON support in Oracle Spatial 1.14.2
    • Get_GeoJson method 2.3
    • support in Oracle Spatial 1.14, 1.14.1
    • TO_GEOJSON function 35.45
    • TO_JSON_VARCHAR function 35.49
    • TO_JSON function 35.48

K

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

L

  • layer 1.5.3
    • transforming 22.34
    • validating with context 26.34
  • layer_gtype
    • constraining data to a geometry type 5.1.2
  • length
    • SDO_LENGTH function 26.16
  • length_unit attribute
  • levels of detail (LODs)
    • checking if theme has 35.43
  • line
  • linear features 7.1.10
  • 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 27
    • tolerance values with LRS functions 7.6
  • line string
  • LOAD_EPSG_MATRIX procedure 22.24
  • loading spatial data 4
  • local coordinates 1.5.4, 6.1.5
  • local coordinate systems 6.3
  • LOCAL partitioning
  • LOCATE_PT function 27.29
  • location data enrichment 1.13
    • adding user data to the geographic name hierarchy 1.13.2
    • ELOC_ADMIN_AREA_SEARCH table 1.13.1
  • location for route segment 14.3.2.1
  • location messages 33.4, 33.5
  • location prospecting 9.6
  • location tracking messages
    • SEND_LOCATION_MSGS procedure 33.4
    • SEND_TRACKING_MSG procedure 33.5
  • location tracking server
    • conceptual and usage information 8
  • location tracking set
    • CREATE_TRACKING_SET procedure 33.1
    • DROP_TRACKING_SET procedure 33.2
    • GET_NOTIFICATION_MSGprocedure 33.3
    • START_TRACKING_SET procedure 33.6
    • STOP_TRACKING_SET procedure 33.7
  • location tracking subprograms 33
  • locationType type 14.4.1
  • Locator B
    • manually installing B.1
  • LODs (levels of detail)
    • checking if theme has 35.43
  • LRS
    • See: linear referencing system (LRS)
  • LRS_INTERSECTION function 27.30
  • LRS points 7.1.9

M

  • MAKE_3D function 22.25, 22.26
  • MakeOpenLSClobRequest function 29.1
  • MakeOpenLSRequest function 29.2
  • MAP_EPSG_SRID_TO_ORACLE function 22.27
  • MAP_ORACLE_SRID_TO_EPSG function 22.28
  • 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.11.3
  • MBR
    • See: minimum bounding rectangle (MBR)
  • MDDATA account and schema 1.18
  • mddins.sql script B.1
  • mdinst.sql script B.1
  • MDSYS.CS_SRS table 6.8.1
  • MDSYS.MOVE_SDO procedure 1.24
  • 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 25
  • MDSYS.SDO_GEOM_PATH_INFO type F.2.2
  • MDSYS.SDO_OLS package 29
  • MDSYS.SDO_PROJECTIONS_OLD_FORMAT table 6.8.7
  • MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table 6.8.7
  • MDSYS.SDO_SAM package 31
  • MDSYS.SDO_WFS_LOCK package 37
  • MDSYS.SDO_WFS_PROCESS package 38
  • MDSYS.VERTEX_TYPE type 35.26, 35.27
  • MDSYS account and schema 1.18
  • MDSYS schema 1.1
    • must exist in destination database for migration A.1
  • mean sea level (MSL) 6.2.3.1
  • measure 7.1.4
  • MEASURE_RANGE function 27.31
  • MEASURE_TO_PERCENTAGE function 27.32
  • measure range 7.1.7
  • messages
    • Spatial error messages 1.26
  • methods
    • SDO_GEOMETRY object type 2.3
  • migration 28.1, A.1
    • See also: upgrading
  • min-corner values
    • for three-dimensional rectangle 1.11.3
  • minimum bounding circle
    • SDO_MBC_CENTER function 26.21
    • SDO_MBC_RADIUS function 26.22
    • SDO_MBC function 26.20
  • minimum bounding rectangle (MBR)
    • AVERAGE_MBR procedure 34.1
    • EXTENT_OF function 34.3
    • geodetic 6.2.4
    • SDO_AGGR_MBR aggregate function 21.6
    • SDO_MAX_MBR_ORDINATE function 26.17
    • SDO_MBR function 26.23
    • SDO_MIN_MBR_ORDINATE function 26.24
  • mining
    • See: data mining
  • MIX_INFO procedure 34.4
  • MOVE_SDO procedure 1.24
  • MSL (mean sea level) 6.2.3.1
  • multi-address routing 14.1
  • multiline string
  • multimaster replication
    • SDO_GEOMETRY objects B
  • 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.10
    • SDO_NN operator 20.9
  • 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.15
  • normal vector 1.11.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.30
    • support in Oracle Spatial 1.15

O

  • object types
  • OCG (Open Geospatial Consortium) simple features conformance 1.20
  • OCI (Oracle Call Interface) examples 1.27
  • offset 7.1.5
    • FIND_OFFSET function 27.14
  • OFFSET_GEOM_SEGMENT function 27.33
  • offsetting
    • geometric segment 7.5.7
  • OGC_X and OGC_Y function names 1.20
  • ON
    • SDO_ON operator 20.11
    • topological relationship 1.8
  • Open Geospatial Consortium (OCG) simple features conformance 1.20
  • OpenLS
    • subprogram reference information 29
  • 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.27
  • Oracle Database 10g
    • upgrading Spatial to A
  • Oracle Data Mining
    • spatial analysis and mining information 9
  • Oracle Locator
    • See: Locator
  • Oracle Multimedia
    • proper installation required for Locator B
  • 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.12
    • topological relationship 1.8
  • OVERLAPBDYINTERSECT
    • SDO_OVERLAPBDYINTERSECT operator 20.13
    • topological relationship 1.8
  • OVERLAPS
    • SDO_OVERLAPS operator 20.14

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
  • PC2DEM procedure 30.9
  • PERCENTAGE_TO_MEASURE function 27.34
  • performance and tuning information 1.19
    • for Spatial operators 1.9
  • PL/SQL and SQL examples 1.27
  • plugins
    • registering for record type F.4.13
  • point
    • data 1.5.1
    • illustration and examples of point-only geometry 2.7.5
    • interior on surface of polygon 35.34
    • locating on geometric segment 7.5.8
    • LRS 7.1.9
    • on surface of polygon 26.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.35
  • point clouds
  • point of interest (POI)
    • GC_POI_((lt))suffix((gt)) table 12.5.7
  • polygon
    • area of 26.4
    • boundary of 1.8
    • buffer 26.5
    • centroid 26.6
    • compound 2.2.4
    • exterior and interior rings 2.2.4, 2.7.2
    • interior point on surface 35.34
    • point on surface 26.25
    • self-crossing not supported 1.4
    • self-intersecting polygons 26.33
    • with hole (LRS measure values) 7.1.11
  • polygon collection 2.7.2
  • polygon data 1.5.1
  • POLYGONTOLINE function 35.36
  • PopulateFeatureTypeXMLInfo procedure 38.10
  • populating
  • pre_geocoded_location element 14.3.2.4
  • PRESERVES_LEVEL1 function 30.10
  • 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 32.5
  • PROJECT_PT function 27.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 27.35
  • Publish_FeatureTypes_In_Schema procedure 38.12
  • PublishFeatureType procedure 38.11
  • publishRecordType method F.4.12
  • pyramids

Q

  • quality
  • query 5.2.1
  • querying geometric segments
    • subprograms for 27
  • 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.28
  • rebuilding
    • spatial indexes 19.2
  • record types
  • record view map
  • record view maps (setting) F.4.18
  • rectangle
  • rectification of geometries 35.37
  • RECTIFY_GEOMETRY function 35.37
  • REDEFINE_GEOM_SEGMENT procedure 27.36
  • redefining
    • geometric segment 7.5.2
  • RegisterFeatureTable procedure 37.2
  • RegisterMTableView procedure 38.13
  • registerTypePluginMap method F.4.13
  • RELATE function 26.1
    • See also: SDO_RELATE operator
  • relational feature types (WFS) 16.3
  • release number (Spatial)
  • REMOVE_DUPLICATE_VERTICES function 35.38
  • replication
    • multimaster B
    • object B
  • RESET_MEASURE procedure 27.37
  • restrictions in current release 6.10
  • return_route_geometry attribute
  • return_segment_geometry attribute
  • REVERSE_GEOCODE function 25.7
  • REVERSE_GEOMETRY function 27.38
  • REVERSE_LINESTRING function 35.39
  • REVERSE_MEASURE function 27.39
  • reverse geocoding 25.7
  • REVOKE_PREFERENCE_FOR_OP procedure 22.29
  • RevokeFeatureTypeFromUser procedure 38.14
  • RevokeMDAccessFromUser procedure 38.15
  • revokeMDAccessToUser method F.4.14
  • revokeRecordTypeFromUser method F.4.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 E
    • 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 27.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.8
  • 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 26.2
  • SDO_ANGLE_UNITS table 6.8.2
  • SDO_ANYINTERACT operator 20.1
  • SDO_ARC_DENSIFY function 26.3
  • SDO_AREA_UNITS view 6.8.3
  • SDO_AREA function 26.4
  • SDO_BUFFER function 26.5
  • SDO_CENTROID function 26.6
  • SDO_CLOSEST_POINTS procedure 26.7
  • SDO_CONCAVEHULL_BOUNDARY function 26.9
  • SDO_CONCAVEHULL function 26.8
  • SDO_CONTAINS operator 20.2
  • SDO_CONVEXHULL function 26.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
    • LOAD_EPSG_MATRIX 22.24
    • MAKE_3D 22.25, 22.26
    • MAP_EPSG_SRID_TO_ORACLE 22.27
    • MAP_ORACLE_SRID_TO_EPSG 22.28
    • REVOKE_PREFERENCE_FOR_OP 22.29
    • TO_GEOHASH 22.30
    • TO_OGC_SIMPLEFEATURE_SRS 22.31
    • TO_USNG 22.32
    • TRANSFORM 22.33
    • TRANSFORM_LAYER 22.34
    • UPDATE_WKTS_FOR_ALL_EPSG_CRS 22.35
    • UPDATE_WKTS_FOR_EPSG_CRS 22.36
    • UPDATE_WKTS_FOR_EPSG_DATUM 22.37
    • UPDATE_WKTS_FOR_EPSG_ELLIPS 22.38
    • UPDATE_WKTS_FOR_EPSG_OP 22.39
    • UPDATE_WKTS_FOR_EPSG_PARAM 22.40
    • UPDATE_WKTS_FOR_EPSG_PM 22.41
    • VALIDATE_EPSG_MATRIX 22.42
    • VALIDATE_WKT 22.43
  • 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 26.12
  • SDO_DIAMETER function 26.11
  • SDO_DIFFERENCE function 26.13
  • SDO_DIST_UNITS view 6.8.5
  • SDO_DISTANCE function 26.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 25
    • CREATE_PROFILE_TABLES 25.1
    • GEOCODE 25.2
    • GEOCODE_ADDR 25.3
    • GEOCODE_ADDR_ALL 25.4
    • GEOCODE_ALL 25.5
    • GEOCODE_AS_GEOMETRY 25.6
    • REVERSE_GEOCODE 25.7
  • SDO_GEO_ADDR data type and constructors 12.2.1
  • SDO_GEOM_MBR operator 26.23
  • SDO_GEOM_PATH_INFO
    • MDSYS.SDO_GEOM_PATH_INFO type F.2.2
  • 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 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.7
  • SDO_INTERPRETATION value 2.2.4
  • SDO_INTERSECTION function 26.15
  • SDO_JOIN operator 20.8
    • cross-schema invocation 20.8
  • SDO_KEYWORDARRAY data type 12.2.3
  • SDO_LENGTH function 26.16
  • SDO_LRS package
    • CLIP_GEOM_SEGMENT 27.1
    • CONCATENATE_GEOM_SEGMENTS 27.2
    • CONNECTED_GEOM_SEGMENTS 27.3
    • CONVERT_TO_LRS_DIM_ARRAY 27.4
    • CONVERT_TO_LRS_GEOM 27.5
    • CONVERT_TO_LRS_LAYER 27.6
    • CONVERT_TO_STD_DIM_ARRAY 27.7
    • CONVERT_TO_STD_GEOM 27.8
    • CONVERT_TO_STD_LAYER 27.9
    • DEFINE_GEOM_SEGMENT 27.10
    • DYNAMIC_SEGMENT 27.11
    • FIND_LRS_DIM_POS 27.12
    • FIND_MEASURE 27.13
    • FIND_OFFSET 27.14
    • GEOM_SEGMENT_END_MEASURE 27.15
    • GEOM_SEGMENT_END_PT 27.16
    • GEOM_SEGMENT_LENGTH 27.17
    • GEOM_SEGMENT_START_MEASURE 27.18
    • GEOM_SEGMENT_START_PT 27.19
    • GET_MEASURE 27.20
    • GET_NEXT_SHAPE_PT 27.21
    • GET_NEXT_SHAPE_PT_MEASURE 27.22
    • GET_PREV_SHAPE_PT 27.23
    • GET_PREV_SHAPE_PT_MEASURE 27.24
    • IS_GEOM_SEGMENT_DEFINED 27.25
    • IS_MEASURE_DECREASING 27.26
    • IS_MEASURE_INCREASING 27.27
    • IS_SHAPE_PT_MEASURE 27.28
    • LOCATE_PT 27.29
    • LRS_INTERSECTION 27.30
    • MEASURE_RANGE 27.31
    • MEASURE_TO_PERCENTAGE 27.32
    • OFFSET_GEOM_SEGMENT 27.33
    • PERCENTAGE_TO_MEASURE 27.34
    • PROJECT_PT 27.35
    • REDEFINE_GEOM_SEGMENT 27.36
    • RESET_MEASURE 27.37
    • REVERSE_GEOMETRY 27.38
    • REVERSE_MEASURE 27.39
    • SCALE_GEOM_SEGMENT 27.40
    • SET_PT_MEASURE 27.41
    • SPLIT_GEOM_SEGMENT 27.42
    • TRANSLATE_MEASURE 27.43
    • VALID_GEOM_SEGMENT 27.44
    • VALID_LRS_PT 27.45
    • VALID_MEASURE 27.46
    • VALIDATE_LRS_GEOMETRY 27.47
  • SDO_MAX_MBR_ORDINATE function 26.17
  • SDO_MAXDISTANCE_LINE function 26.19
  • SDO_MAXDISTANCE function 26.18
  • SDO_MBC_CENTER function 26.21
  • SDO_MBC_RADIUS function 26.22
  • SDO_MBC function 26.20
  • SDO_MBR function 26.23
  • SDO_MIGRATE package
  • SDO_MIN_MBR_ORDINATE function 26.24
  • SDO_NN_DISTANCE ancillary operator 20.10
  • SDO_NN_DISTANCE operator
    • complex examples C.3
  • SDO_NN operator 20.9
    • complex examples C.3
    • optimizer hints 20.9
  • SDO_OLS package 29
    • MakeOpenLSClobRequest 29.1
    • MakeOpenLSRequest 29.2
  • SDO_ON operator 20.11
  • SDO_ORDINATE_ARRAY type 2.2
  • SDO_ORDINATES attribute 2.2.5
  • SDO_OVERLAPBDYDISJOINT operator 20.12
  • SDO_OVERLAPBDYINTERSECT operator 20.13
  • SDO_OVERLAPS operator 20.14
  • SDO_PC_BLK_TYPE object type 2.6.2
  • SDO_PC_BLK object type 2.6.2
  • SDO_PC_NN_FOR_EACH function 30.12
  • SDO_PC_NN function 30.11
  • 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.15
  • SDO_POINTONSURFACE function 26.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 31.2, 31.9
  • SDO_REGAGGRSET object type 31.2, 31.9
  • SDO_REGION object type 31.10
  • SDO_REGIONSET object type 31.10
  • SDO_RELATE operator 20.16
  • SDO_ROWIDPAIR object type 20.8
  • SDO_ROWIDSET data type 20.8
  • SDO_RTREE_SEQ_NAME sequence object 2.10.3
  • SDO_SAM package 31
    • AGGREGATES_FOR_GEOMETRY 31.1
    • AGGREGATES_FOR_LAYER 31.2
    • BIN_GEOMETRY 31.3
    • BIN_LAYER 31.4
    • COLOCATED_REFERENCE_FEATURES 31.5
    • SIMPLIFY_GEOMETRY 31.6
    • SIMPLIFY_LAYER 31.7
    • SPATIAL_CLUSTERS 31.8
    • TILED_AGGREGATES 31.9
    • TILED_BINS 31.10
  • SDO_SELF_UNION function 26.26
  • 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_TOUCH operator 20.17
  • SDO_TRIANGULATE function 26.27
  • SDO_TRKR package
    • CREATE_TRACKING_SET 33.1
    • DROP_TRACKING_SET 33.2
    • GET_NOTIFICATION_MSG 33.3
    • SEND_LOCATION_MSGS 33.4
    • SEND_TRACKING_MSG 33.5
    • START_TRACKING_SET 33.6
    • STOP_TRACKING_SET 33.7
  • SDO_TUNE package
  • SDO_UNION function 26.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.21
  • SDO_VOLUME function 26.29
  • SDO_WCS.CreateTempTable procedure 36.1
  • SDO_WCS.DropTempTable procedure 36.2
  • SDO_WCS.GrantPrivilegesToWCS procedure 36.3
  • SDO_WCS.Init procedure 36.4
  • SDO_WCS.PublishCoverage procedure 36.5
  • SDO_WCS.RevokePrivilegesFromWCS procedure 36.6
  • SDO_WCS.UnpublishCoverage procedure 36.7
  • SDO_WCS.ValidateCoverages function 36.8
  • SDO_WCS package
    • CreateTempTable 36.1
    • DropTempTable 36.2
    • GrantPrivilegesToWCS 36.3
    • Init 36.4
    • PublishCoverage 36.5
    • RevokePrivilegesFromWCS 36.6
    • UnpublishCoverage 36.7
    • ValidateCoverages 36.8
  • SDO_WFS_LOCK package 37
    • EnableDBTxns 37.1
    • RegisterFeatureTable 37.2
    • UnRegisterFeatureTable 37.3
  • SDO_WFS_PROCESS package 38
    • DropFeatureType 38.1
    • DropFeatureTypes 38.2
    • GenCollectionProcs 38.3
    • GetFeatureTypeId 38.4
    • GrantFeatureTypeToUser 38.5
    • GrantMDAccessToUser 38.6
    • InsertCapabilitiesInfo 38.7
    • InsertFtDataUpdated 38.8
    • InsertFtMDUpdated 38.9
    • PopulateFeatureTypeXMLInfo 38.10
    • Publish_FeatureTypes_In_Schema 38.12
    • PublishFeatureType 38.11
    • RegisterMTableView 38.13
    • RevokeFeatureTypeFromUser 38.14
    • RevokeMDAccessFromUser 38.15
    • UnRegisterMTableView 38.16
  • SDO_WIDTH_LINE function 26.31
  • SDO_WIDTH function 26.30
  • SDO_WITHIN_DISTANCE operator 20.18
    • complex examples C.2
  • SDO_XOR function 26.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 26.33
  • self-joins
  • self union 26.26
  • semi-major axis 6.7.23, 6.8.6
  • semi-minor axis 6.7.23
  • SEND_LOCATION_MSGS procedure 33.4
  • SEND_TRACKING_MSG procedure 33.5
  • sequence object for R-tree index 2.10.3
  • SET_PT_MEASURE procedure 27.41
  • setCapabilitiesInfo method F.4.16
  • setDomainInfo method F.4.17
  • setRecordViewMap method F.4.18
  • setXMLTableIndexInfo method F.4.19
  • shapefiles
    • loading into Spatial D
  • shape point 7.1.2
    • determining if measure value is a shape point 27.28
    • getting measure of next 27.22
    • getting measure of previous 27.24
    • getting next 27.21
    • getting previous 27.23
  • sharded database
    • support by Oracle Spatial and Graph 1.16
  • SIGN_POST table
    • routing engine use of 14.5.4
  • simple element 2.2.4
  • simple features (OGC)
    • Oracle Spatial conformance 1.20
  • simplification of geometries 35.40, 35.41
  • SIMPLIFY_GEOMETRY function 31.6
  • SIMPLIFY_LAYER procedure 31.7
  • SIMPLIFY function 35.40, 35.41
  • size requirements (hardware) for spatial applications 1.25
  • solids
  • SORT_AREA_SIZE parameter
    • R-tree index creation 5.1.10
  • SPATIAL_CLUSTERS function 31.8
  • SPATIAL_CSW_ADMIN_USR account and schema 1.18
  • SPATIAL_VECTOR_ACCELERATION system parameter 1.22
  • spatial aggregate functions
    • See: aggregate functions
  • spatial analysis and mining
    • conceptual and usage information 9
    • function reference information 31
  • Spatial and Graph web services
    • deploying and configuring 11.3
    • introduction 11
  • 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 31
  • 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.8
  • spatially enabling a table 1.23
  • 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
  • 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 27.42
  • splitting
    • geometric segment 7.5.4
  • SQL*Loader 4.1
  • SQL and PL/SQL examples 1.27
  • 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.51
    • TO_WKTGEOMETRY function 35.52
    • tolerance value 3.3
    • VALIDATE_WKBGEOMETRY function 35.56
    • VALIDATE_WKTGEOMETRY function 35.57
  • 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
    • in USER_SDO_GEOM_METADATA 2.8.4
    • mapping Oracle to EPSG 22.28
    • 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 33.6
  • start location for route 14.3.2.1
  • STOP_TRACKING_SET procedure 33.7
  • subprograms
    • coordinate system transformation 22
    • data mining 31
    • geocoding 25
    • geometry 26
    • linear referencing 27
    • location tracking 33
    • OpenLS 29
    • point clouds 30
    • SDO_CSW (Catalog Services for the Web) 23
    • SDO_MIGRATE 28
    • spatial analysis 31
    • TINs 32
    • tuning 34
    • utility 35
    • Web Coverage Service 36
    • WFS 37
    • WFS processing 38
  • subroutes
  • surface normal 1.11.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.23
  • textures
  • TFM_PLAN object type 6.6
  • THEME3D_GET_BLOCK_TABLE function 35.42
  • THEME3D_HAS_LOD function 35.43
  • THEME3D_HAS_TEXTURE function 35.44
  • themes
  • three-dimensional (3D)
  • TILED_AGGREGATES function 31.9
  • TILED_BINS function 31.10
  • TINs
    • clipping 32.1
    • converting to DEM 32.6
    • converting to geometry 32.7
    • creating 30.4, 32.2
    • dropping dependencies 32.3
    • initializing 32.4
    • projecting ordinates onto 32.5
    • pyramiding 32.4
    • subprograms 32
  • TINs (triangulated irregular networks) 1.11.1
  • TO_CURRENT procedure and function 28.1
  • TO_DEM procedure 32.6
  • TO_GEOHASH function 22.30
  • TO_GEOJSON function 35.45
  • TO_GEOMETRY function 30.13, 32.7
  • TO_GML311GEOMETRY function 35.46
  • TO_GMLGEOMETRY function 35.47
  • TO_JSON_VARCHAR function 35.49
  • TO_JSON function 35.48
  • TO_KMLGEOMETRY function 35.50
  • TO_OGC_SIMPLEFEATURE_SRS function 22.31
  • TO_USNG function 22.32
  • TO_WKBGEOMETRY function 35.51
  • TO_WKTGEOMETRY function 35.52
  • tolerance 1.5.5
    • for SQL Multimedia types 3.3
    • with LRS functions 7.6
  • topological self union 26.26
  • TOUCH
    • SDO_TOUCH operator 20.17
    • topological relationship 1.8
  • TP_USER_DATA table
  • tracking set 33.1, 33.2, 33.7, 33.3, 33.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.34
    • table for transformed layer 22.34
  • transformation 6.1.7
    • arcs and circles not supported 6.2.6
  • TRANSFORM function 22.33
  • TRANSLATE_MEASURE function 27.43
  • transportable tablespaces
    • initializing spatial indexes 35.32
  • traveling salesperson (TSP) route 14.1.3
  • triangulated irregular networks (TINs) 1.11.1
  • triangulation
    • SDO_TRIANGULATE function 26.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.19
    • for spatial operators 1.9
  • tuning subprograms 34
  • 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.32
    • support in Oracle Spatial 6.11
  • unformatted addresses 12.1.1
  • union 26.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
  • unknown CRS coordinate reference system 6.10.4
  • UnRegisterFeatureTable procedure 37.3
  • UnRegisterMTableView procedure 38.16
  • UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure 22.35
  • UPDATE_WKTS_FOR_EPSG_CRS procedure 22.36
  • UPDATE_WKTS_FOR_EPSG_DATUM procedure 22.37
  • UPDATE_WKTS_FOR_EPSG_ELLIPS procedure 22.38
  • UPDATE_WKTS_FOR_EPSG_OP procedure 22.39
  • UPDATE_WKTS_FOR_EPSG_PARAM procedure 22.40
  • UPDATE_WKTS_FOR_EPSG_PM procedure 22.41
  • upgrading
    • data to current Spatial release 28.1
    • GeoRaster A.2
    • Spatial to current Oracle Database release A
  • upgrading spatial data to current release 28.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 35

V

  • VALID_GEOM_SEGMENT function 27.44
  • VALID_LRS_PT function 27.45
  • VALID_MEASURE function 27.46
  • VALIDATE_3DTHEME function 35.53
  • VALIDATE_EPSG_MATRIX procedure 22.42
  • VALIDATE_GEOMETRY_WITH_CONTEXT function 26.33
  • VALIDATE_LAYER_WITH_CONTEXT procedure 26.34
  • VALIDATE_LRS_GEOMETRY function 27.47
  • VALIDATE_SCENE function 35.54
  • VALIDATE_VIEWFRAME function 35.55
  • VALIDATE_WKBGEOMETRY function 35.56
  • VALIDATE_WKT function 22.43
  • VALIDATE_WKTGEOMETRY function 35.57
  • validation of geometries
    • general and two-dimensional checks 26.33
    • importance of performing 4.3
    • three-dimensional checks 1.11.5
  • Vector Performance Accelerator (VPA) feature 1.22
  • vehicle_type attribute
  • vendor attribute
  • versioning (CSW)
  • version number (Spatial)
  • vertex
  • VERTEX_SET_TYPE data type 35.31
  • VERTEX_TYPE object type 35.31
  • VERTEX_TYPE type 35.26, 35.27
  • vertices
    • maximum number in SDO_GEOMETRY object 2.2
    • removing duplicate 35.38
    • returning geometry coordinates as 35.31
  • 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 26.29
  • VPA (Vector Performance Accelerator) feature 1.22

W

  • Web Coverage Service (WCS) subprograms 36
  • 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 37
    • using with Oracle Workspace Manager 16.8
  • WFS processing
    • subprogram reference information 38
  • width
    • SDO_WIDTH_LINE function 26.31
    • SDO_WIDTH function 26.30
  • WITHIN_DISTANCE function 26.35
    • See also: SDO_WITHIN_DISTANCE operator
  • WKB
    • FROM_WKBGEOMETRY function 35.22
    • Get_WKB method 2.3
    • TO_WKBGEOMETRY function 35.51
    • VALIDATE_WKBGEOMETRY function 35.56
  • 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.52
    • UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure 22.35
    • UPDATE_WKTS_FOR_EPSG_CRS procedure 22.36
    • UPDATE_WKTS_FOR_EPSG_DATUM procedure 22.37
    • UPDATE_WKTS_FOR_EPSG_ELLIPS procedure 22.38
    • UPDATE_WKTS_FOR_EPSG_OP procedure 22.39
    • UPDATE_WKTS_FOR_EPSG_PARAM procedure 22.40
    • UPDATE_WKTS_FOR_EPSG_PM procedure 22.41
    • VALIDATE_WKTGEOMETRY function 35.57
    • validating (given SRID) 22.43
  • 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
  • XML table index
    • setting information for record type F.4.19
  • XMLTABLEINDEX index
    • checking for existence F.4.8
    • deleting on feature table F.4.6
  • XOR

Y

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

Z

  • zero