Index

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 1
  • 3D
    • formats of LRS functions
      • not supported with geodetic data 1
    • spatial objects
      • solids 1
      • surfaces 1

A

  • ADD_PREFERENCE_FOR_OP procedure 1
  • addresses
    • representing for geocoding 1
  • affine transformation
    • of input geometry 1
  • AFFINETRANSFORMS procedure 1
  • aggregate functions
    • description 1
    • reference information 1
    • SDO_AGGR_CENTROID 1
    • SDO_AGGR_CONCAT_LINES 1
    • SDO_AGGR_CONVEXHULL 1
    • SDO_AGGR_LRS_CONCAT 1
    • SDO_AGGR_MBR 1
    • SDO_AGGR_SET_UNION 1
    • SDO_AGGR_UNION 1
    • SDOAGGRTYPE object type 1
  • AGGREGATES_FOR_GEOMETRY function 1
  • AGGREGATES_FOR_LAYER function 1
  • aliases 1
  • ALL_ANNOTATION_TEXT_METADATA view 1
  • ALL_SDO_3DTHEMES view 1
  • ALL_SDO_GEOM_METADATA view 1
  • ALL_SDO_INDEX_INFO view 1
  • ALL_SDO_INDEX_METADATA view 1
  • ALL_SDO_SCENES view 1
  • ALL_SDO_VIEWFRAMES view 1
  • alpha shape
    • SDO_ALPHA_SHAPE function 1
  • ALTER INDEX statement
    • REBUILD clause 1
    • RENAME TO clause 1
  • angle units 1
  • annotation text 1
  • ANYINTERACT
    • SDO_ANYINTERACT operator 1
    • topological relationship 1
  • APPEND function 1
  • application size (hardware) requirements 1
  • arc
    • densifying 1
    • not supported with geodetic data or for transformations 1
  • area 1
  • area units 1
  • AVERAGE_MBR procedure 1
  • average minimum bounding rectangle 1

B

  • batch_route_request element 1
  • batched route requests 1
  • batch mode route requests
    • example 1
  • batch mode route responses
    • example 1
  • batch route requests
    • XML Schema definition 1
  • batch route responses
    • XML Schema definition 1
  • bearing
    • point at 1
    • tilt for points 1
  • BEARING_TILT_FOR_POINTS procedure 1
  • BIN_GEOMETRY function 1
  • BIN_LAYER procedure 1
  • binning
    • spatial 1
  • bins
    • assigning 1
    • computing 1
    • tiled 1
  • block table
    • getting for theme 1
  • boundary
    • of area 1
    • of line string 1
    • of multiline string 1
    • of polygon 1
  • bounding rectangle
    • minimum 1
  • box
    • optimized 1
  • British Grid Transformation OSTN02/OSGM02 1
  • B-tree index on points 1
  • buffer area 1
  • bulk loading of spatial data 1
  • business directory (YP)
    • data requirements and providers 1
    • data structures for 1
    • OpenLS service support and examples 1
    • support in Spatial and Graph 1

C

  • Cartesian coordinates 1 , 2
  • cartographic text (annotation text) 1
  • cbtree_index=true 1
  • center of gravity (centroid) 1
  • centroid
    • SDO_AGGR_CENTROID aggregate function 1
    • SDO_CENTROID function 1
  • circle
    • creating polygon approximating 1
    • not supported with geodetic data or for projections 1
    • type 1
  • CIRCLE_POLYGON function 1
  • C language
    • examples (using OCI) 1
  • CLIP_GEOM_SEGMENT function 1
  • CLIP_PC_FLAT function 1
  • CLIP_PC function 1
  • CLIP_TIN function 1
  • clipping
    • geometric segment 1
  • closed tour (TSP) 1
  • closest points
    • SDO_CLOSEST_POINTS procedure 1
  • COLOCATED_REFERENCE_FEATURES procedure 1
  • colocation mining 1
  • COLUMN_NAME (in USER_SDO_GEOM_METADATA) 1
  • column name
    • restrictions on spatial column names 1
  • compatibility 1
  • complex examples
    • queries 1
  • composite B-tree index on points 1
  • compound element 1
  • compound line string 1 , 2
  • compound polygon 1
  • CONCAT_LINES function 1
  • CONCATENATE_GEOM_SEGMENTS function 1
  • concatenating
    • geometric segments 1
    • line or multiline geometries 1
    • LRS geometries 1 , 2
  • concave hull
    • SDO_CONCAVEHULL_BOUNDARY function 1
    • SDO_CONCAVEHULL function 1
  • CONNECTED_GEOM_SEGMENTS function 1
  • consistency
    • checking for valid geometry types 1
  • constraining data to a geometry type 1
  • constructors
    • SDO_GEOMETRY object type 1
  • CONTAINS
    • SDO_CONTAINS operator 1
    • topological relationship 1
  • contour geometries
    • creating from point cloud 1
  • CONVERSION_FACTOR column
    • in SDO_ANGLE_UNITS table 1
    • in SDO_AREA_UNITS table 1
    • in SDO_DIST_UNITS table 1
  • CONVERT_3D_SRID_TO_2D function 1
  • CONVERT_NADCON_TO_XML procedure 1
  • CONVERT_NTV2_TO_XML procedure 1
  • CONVERT_TO_LRS_DIM_ARRAY function 1
  • CONVERT_TO_LRS_GEOM function 1
  • CONVERT_TO_LRS_LAYER function 1
  • CONVERT_TO_STD_DIM_ARRAY function 1
  • CONVERT_TO_STD_GEOM function 1
  • CONVERT_TO_STD_LAYER function 1
  • CONVERT_UNIT function 1
  • CONVERT_XML_TO_NADCON procedure 1
  • CONVERT_XML_TO_NTV2 procedure 1
  • CONVERT3007TO3008 function 1
  • converting
    • geometric segments
      • overview 1
      • subprograms for 1
  • convex hull
    • SDO_AGGR_CONVEXHULL aggregate function 1
    • SDO_CONVEXHULL function 1
  • coordinate dimension
    • ST_CoordDim method 1
  • coordinate reference systems
    • See: coordinate systems
  • coordinates
    • Cartesian 1 , 2
    • geodetic 1 , 2 , 3
    • geographic 1 , 2
    • local 1 , 2
    • projected 1 , 2
  • coordinate systems
    • conceptual and usage information 1
    • data structures supplied by Oracle 1
    • example 1
    • local 1
    • subprogram reference information 1
    • unit of measurement support 1
    • user-defined 1
  • COVEREDBY
    • SDO_COVEREDBY operator 1
    • topological relationship 1
  • COVERS
    • SDO_COVERS operator 1
    • topological relationship 1
  • CPU requirements for applications using Spatial and Graph 1
  • CREATE_CONCATENATED_OP procedure 1
  • CREATE_CONTOUR_GEOMETRIES function 1
  • CREATE_OBVIOUS_EPSG_RULES procedure 1
  • CREATE_PC procedure 1
  • CREATE_PREF_CONCATENATED_OP procedure 1
  • CREATE_PROFILE_TABLES procedure 1
  • CREATE_SPATIAL_IDX procedure 1
  • CREATE_TIN procedure 1
  • CREATE_TRACKING_REGIONS procedure 1
  • CREATE_XQFT_IDX procedure 1
  • CREATE INDEX statement 1
  • creating
    • geometric segments
      • subprograms for 1
  • cross-schema index creation 1
  • CS_SRS table 1
  • current release
    • upgrading spatial data to 1

D

  • database links
    • not supported if spatial index is defined on the table 1
  • data mining
    • spatial
      • colocation mining 1
      • conceptual and usage information 1
      • function reference information 1
  • data model
    • LRS 1
  • data types
    • geocoding 1
    • spatial 1
  • datum
    • geodetic 1 , 2
    • MDSYS.SDO_DATUMS_OLD_FORMAT table 1
    • MDSYS.SDO_DATUMS_OLD_SNAPSHOT table 1
    • transformation 1
  • dblink
    • not supported if spatial index is defined on the table 1
  • DEFINE_GEOM_SEGMENT procedure 1
  • defining
    • geometric segment 1
  • DELETE_ALL_EPSG_RULES procedure 1
  • DELETE_OP procedure 1
  • deleteDomainInfo method 1
  • deleteRecordViewMap method 1
  • densification of arcs 1
  • DESTROY_TRACKING_REGIONS procedure 1
  • DETERMINE_CHAIN function 1
  • DETERMINE_DEFAULT_CHAIN function 1
  • diameter
    • SDO_DIAMETER_LINE function 1
    • SDO_DIAMETER function 1
  • difference
    • SDO_GEOM.SDO_DIFFERENCE function 1
  • dimension (in SDO_GTYPE)
    • Get_Dims method 1
    • Get_LRS_Dim method 1
  • DIMINFO (in USER_SDO_GEOM_METADATA) 1
  • direction of geometric segment
    • concatenation result 1
  • disableVersioning method 1
  • discretization (binning)
    • See alsobins 1
    • spatial 1
  • DISJOINT
    • topological relationship 1
  • disk storage requirements for applications using Spatial and Graph 1
  • distance
    • SDO_NN_DISTANCE ancillary operator 1
    • WITHIN_DISTANCE function 1
  • distance units 1
  • distributed transactions
    • not supported with R-tree spatial indexes 1
  • document-based feature types (WFS) 1
  • domain information (CSW)
    • deleting 1
  • domains (CSW)
    • setting information 1
  • Douglas-Peucker algorithm for geometry simplification 1 , 2
  • downgrading
    • Oracle Spatial to the previous Oracle Database release 1
  • DROP_DEPENDENCIES procedure 1 , 2
  • DROP_WORK_TABLES procedure 1
  • DropFeatureType procedure 1
  • DropFeatureTypes procedure 1
  • DROP INDEX statement 1
  • dropRecordType method 1
  • dropXMLTableIndex method 1
  • duplicate vertices
    • removing 1
  • DYNAMIC_SEGMENT function 1
  • dynamic query window 1

E

  • EDGE table
    • routing engine use of 1 , 2
  • editing
    • geometric segments
      • subprograms for 1
  • ELEM_INFO (SDO_ELEM_INFO attribute) 1
  • elements
    • extracting from a geometry 1 , 2
    • returning number of elements in a geometry 1
    • returning number of vertices in a geometry 1
  • ellipse
    • creating polygon approximating 1
  • ELLIPSE_POLYGON function 1
  • ellipsoidal height 1 , 2
  • ellipsoids
    • MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table 1
    • MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table 1
  • embedded SDO_GEOMETRY object in user-defined type 1
  • EnableDBTxns procedure 1
  • enableVersioning method 1
  • end location for route 1
  • entity-relationship (E-R) diagram
    • EPSG tables 1
  • EPSG
    • entity-relationship (E-R) diagram 1
    • mapping of table names to Oracle Spatial names 1
    • mapping Oracle SRID to 1
    • mapping SRID to Oracle SRID 1
    • model and use by Spatial 1
    • version number of dataset used by Spatial 1
  • EQUAL
    • SDO_EQUAL operator 1
    • topological relationship 1
  • E-R (entity-relationship diagram)
    • EPSG tables 1
  • error messages
    • geocoding 1
    • Spatial 1
  • ESRI shapefiles
    • loading into Spatial 1
  • ESTIMATE_RTREE_INDEX_SIZE function 1
  • ETYPE (SDO_ETYPE value) 1
  • European Petroleum Survey Group
    • See: EPSG
  • examples
    • batch mode route request and response 1
    • C 1
    • complex queries 1
    • coordinate systems 1
    • creating, indexing, and querying spatial data 1
    • directory for Spatial examples 1
    • linear referencing system (LRS) 1
    • many geometry types (creating) 1
    • OCI (Oracle Call Interface) 1
    • PL/SQL 1
    • route request and response 1
    • SQL 1
  • exchanging partitions including indexes 1
  • Export utility
    • with spatial indexes and data 1
  • EXTENT_OF function 1
  • exterior polygon rings 1 , 3
  • exterior solids 1
  • EXTRACT_ALL function 1
  • EXTRACT3D function 1
  • EXTRACT function 1
  • extractSDO function 1
  • EXTRUDE function 1
  • extrusion
    • creating 1

F

  • features
    • linear 1
  • FILTER
    • SDO_FILTER operator 1
  • FILTER mask value for SDO_JOIN 1 , 2
  • FIND_GEOG_CRS function 1
  • FIND_LRS_DIM_POS function 1
  • FIND_MEASURE function 1
  • FIND_OFFSET function 1
  • FIND_PROJ_CRS function 1
  • FIND_SRID procedure 1
  • formatted addresses 1
  • FROM_GEOHASH function 1
  • FROM_GEOJSON function 1
  • FROM_GML311GEOMETRY function 1
  • FROM_GMLGEOMETRY function 1
  • FROM_KMLGEOMETRY function 1
  • FROM_OGC_SIMPLEFEATURE_SRS function 1
  • FROM_USNG function 1
  • FROM_WKBGEOMETRY function 1
  • FROM_WKTGEOMETRY function 1
  • frustums 1
  • function-based indexes
    • with SDO_GEOMETRY objects 1
  • functions
    • spatial aggregate 1
    • supported by approximations with geodetic data 1

G

  • GC_ADDRESS_POINT_((lt))suffix((gt)) table 1
  • GC_AREA_((lt))suffix((gt)) table 1
  • GC_COUNTRY_PROFILE table 1
  • GC_INTERSECTION_((lt))suffix((gt)) table 1
  • GC_PARSER_PROFILEAFS table 1
  • GC_PARSER_PROFILES table 1
  • GC_POI_((lt))suffix((gt)) table 1
  • GC_POSTAL_CODE_((lt))suffix((gt)) table 1
  • GC_ROAD_((lt))suffix((gt)) table 1
  • GC_ROAD_SEGMENT_((lt))suffix((gt)) table 1
  • GenCollectionProcs procedure 1
  • GEO_SEARCH function 1
  • GEOCODE_ADDR_ALL function 1
  • GEOCODE_ADDR function 1
  • GEOCODE_ALL function 1
  • GEOCODE_AS_GEOMETRY function 1
  • GEOCODE function 1
  • geocoding
    • concepts 1
    • data requirements 1
    • data types for 1
    • error messages 1
    • from a place name 1
    • indexes required on tables for geocoding 1
    • match codes 1
    • match modes 1
    • reverse 1
    • subprogram reference information 1
    • usage information 1
  • geocoding requests
    • XML Schema definition 1
  • geocoding responses
    • XML Schema definition 1
  • geodetic coordinates
    • arcs and circles not supported 1
    • functions supported by approximations 1
    • support for 1
  • geodetic datum 1 , 2
  • geodetic MBRs 1
  • geographic coordinates
    • See: geodetic coordinates
  • geography markup language (GML)
    • converting geometry to 1 , 2
  • geohash
    • support in Oracle Spatial 1
  • GeoJSON
    • support in Oracle Spatial 1
  • GEOM_SEGMENT_END_MEASURE function 1
  • GEOM_SEGMENT_END_PT function 1
  • GEOM_SEGMENT_LENGTH function 1
  • GEOM_SEGMENT_START_MEASURE function 1
  • GEOM_SEGMENT_START_PT function 1
  • geometric segment
    • clipping 1
    • concatenating
      • aggregate 1 , 2
    • converting (overview) 1
    • converting (subprograms for) 1
    • creating (subprograms for) 1
    • defining 1
    • definition of 1
    • direction 1
    • direction with concatenation 1
    • editing (subprograms for) 1
    • locating point on 1
    • offsetting 1
    • projecting point onto 1
    • querying (subprograms for) 1
    • redefining 1
    • scaling 1
    • splitting 1
  • geometry subprograms
    • reference information 1
  • geometry types
    • constraining data to 1
    • Get_GType method 1
    • SDO_GTYPE 1
  • GeoRaster
    • enabling after upgrade 1
  • gerRecordTypeId method 1
  • GET_2D_FOOTPRINT function 1
  • Get_Dims method 1
  • GET_EPSG_DATA_VERSION function 1
  • GET_GEOHASH_CELL_HEIGHT function 1
  • GET_GEOHASH_CELL_WIDTH function 1
  • Get_GeoJson method 1
  • Get_GType method 1
  • Get_LRS_Dim method 1
  • GET_MEASURE function 1
  • GET_NEXT_SHAPE_PT_MEASURE function 1
  • GET_NEXT_SHAPE_PT function 1
  • GET_PREV_SHAPE_PT_MEASURE function 1
  • GET_PREV_SHAPE_PT function 1
  • GET_PT_IDS function 1
  • Get_WKB method 1
  • Get_WKT method 1
  • GetFeatureTypeId function 1
  • getIsXMLTableIndexCreated method 1
  • GETNUMELEM function 1
  • GETNUMVERTICES function 1
  • GETNURBSAPPROX function 1
  • GETVERTICES function 1
  • GML (geography markup language)
    • converting geometry to 1 , 2
  • Google Maps
    • considerations for using with Spatial applications 1
  • GrantFeatureTypeToUser procedure 1
  • grantMDAccessToUser method 1
  • GrantMDAccessToUser procedure 1
  • grantRecordTypeToUser method 1
  • gravity-related height 1
  • GTYPE (SDO_GTYPE attribute)
    • constraining data to a geometry type 1
    • Get_Dims method 1
    • Get_GType method 1
    • GET_LRS_Dim method 1

H

  • hardware requirements for applications using Spatial 1
  • HAS_PYRAMID function 1
  • height
    • ellipsoidal 1
    • ellipsoidal and non-ellipsoidal 1
    • gravity-related 1

I

  • id attribute
    • of route request 1
  • Import utility
    • with spatial indexes and data 1
  • indexes
    • creating
      • cross-schema 1
      • parallel execution 1
    • description of Spatial indexing 1
    • extending spatial indexing capabilities 1
    • function-based with SDO_GEOMETRY objects 1
    • granting CREATE TABLE to collect spatial index statistics 1
    • partitioned
      • exchanging partitions including indexes 1
    • rebuilding
      • parallel execution 1 , 2
    • R-tree
      • description 1
      • requirements before creating 1
    • size (R-tree) 1
  • index-organized tables
    • cannot create spatial index on 1 , 2
  • INIT function 1 , 2
  • INITIALIZE_CSW procedure 1
  • INITIALIZE_INDEXES_FOR_TTS procedure 1
  • input_location element 1
  • InsertCapabilitiesInfo procedure 1
  • InsertFtDataUpdated procedure 1
  • InsertFtMDUpdated procedure 1
  • inserting spatial data
    • PL/SQL 1
  • INSIDE
    • SDO_INSIDE operator 1
    • topological relationship 1
  • installation
    • Oracle Multimedia requirement for Locator 1
  • interaction
    • ANYINTERACT 1
  • interior
    • of an area 1
  • INTERIOR_POINT function 1
  • interior polygon rings 1 , 3
  • interior solids 1
  • International Organization for Standardization (ISO)
    • compliance of Spatial with standards 1
  • INTERPRETATION (SDO_INTERPRETATION value) 1
  • intersection 1 , 2
  • intersections
    • GC_INTERSECTION_((lt))suffix((gt)) table 1
  • interval partitioning
    • spatial indexing example 1
  • inverse flattening 1 , 2
  • IS_GEOM_SEGMENT_DEFINED function 1
  • IS_MEASURE_DECREASING function 1
  • IS_MEASURE_INCREASING function 1
  • IS_SHAPE_PT_MEASURE function 1
  • ISO (International Organization for Standardization)
    • compliance of Spatial with standards 1

J

  • Java application programming interface (API) for Spatial 1
  • join
    • SDO_JOIN operator 1
  • JSON
    • FROM_GEOJSON function 1
    • GeoJSON support in Oracle Spatial 1
    • Get_GeoJson method 1
    • TO_GEOJSON function 1

K

  • Keyhole Markup Language (KML)
    • FROM_KMLGEOMETRY function 1
    • TO_KMLGEOMETRY function 1
  • KML
    • FROM_KMLGEOMETRY function 1
    • TO_KMLGEOMETRY function 1

L

  • layer
    • transforming 1
    • validating with context 1
  • layer_gtype
    • constraining data to a geometry type 1
  • length
    • SDO_LENGTH function 1
  • length_unit attribute
    • of route request 1
  • levels of detail (LODs)
    • checking if theme has 1
  • line
    • converting polygon to 1
    • data 1
    • length 1
  • linear features 1
  • linear measure 1
  • linear referencing system (LRS)
    • 3D formats of functions
      • not supported with geodetic data 1
    • conceptual and usage information 1
    • data model 1
    • example 1
    • Get_LRS_Dim method 1
    • limiting indexing to X and Y dimensions 1
    • LRS points 1
    • segments 1
    • subprogram reference information 1
    • tolerance values with LRS functions 1
  • line string
    • boundary of 1
    • compound 1 , 2
    • reversing 1
    • self-crossing 1
  • LOAD_EPSG_MATRIX procedure 1
  • loading spatial data 1
  • local coordinates 1 , 2
  • local coordinate systems 1
  • LOCAL partitioning
    • spatial indexes 1
  • LOCATE_PT function 1
  • location data enrichment
    • adding user data to the geographic name hierarchy 1
    • ELOC_ADMIN_AREA_SEARCH table 1
  • location for route segment 1
  • location messages 1 , 2
  • location prospecting 1
  • location tracking messages
    • SEND_LOCATION_MSGS procedure 1
    • SEND_TRACKING_MSG procedure 1
  • location tracking regions
    • CREATE_TRACKING_REGIONS procedure 1
    • DESTROY_TRACKING_REGIONS procedure 1
    • START_TRACKING_REGIONS procedure 1
    • STOP_TRACKING_REGIONS procedure 1
  • location tracking server
    • conceptual and usage information 1
  • location tracking subprograms 1
  • Locator
    • manually installing 1
  • LODs (levels of detail)
    • checking if theme has 1
  • LRS
    • See: linear referencing system (LRS)
  • LRS_INTERSECTION function 1
  • LRS points 1

M

  • MAKE_3D function 1
  • MakeOpenLSClobRequest function 1
  • MakeOpenLSRequest function 1
  • MAP_EPSG_SRID_TO_ORACLE function 1
  • MAP_ORACLE_SRID_TO_EPSG function 1
  • map projections
    • MDSYS.SDO_PROJECTIONS_OLD_FORMAT table 1
    • MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table 1
  • match codes 1
  • match modes 1
  • match vector (MatchVector attribute)
    • geocoding 1
  • max-corner values
    • for three-dimensional rectangle 1
  • MBR
    • See: minimum bounding rectangle (MBR)
  • MDDATA account and schema 1
  • mddins.sql script 1
  • mdinst.sql script 1
  • MDSYS.CS_SRS table 1
  • MDSYS.MOVE_SDO procedure 1
  • MDSYS.SDO_ANGLE_UNITS table 1
  • MDSYS.SDO_AREA_UNITS view 1
  • MDSYS.SDO_CS package 1
  • MDSYS.SDO_DATUMS_OLD_FORMAT table 1
  • MDSYS.SDO_DATUMS_OLD_SNAPSHOT table 1
  • MDSYS.SDO_DIST_UNITS view 1
  • MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table 1
  • MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table 1
  • MDSYS.SDO_GCDR package 1
  • MDSYS.SDO_GEOM_PATH_INFO type 1
  • MDSYS.SDO_OLS package 1
  • MDSYS.SDO_PROJECTIONS_OLD_FORMAT table 1
  • MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table 1
  • MDSYS.SDO_SAM package 1
  • MDSYS.SDO_WFS_LOCK package 1
  • MDSYS.SDO_WFS_PROCESS package 1
  • MDSYS account and schema 1
  • MDSYS schema
    • must exist in destination database for migration 1
  • MDXT_%objID% table 1
  • mean sea level (MSL) 1
  • measure
    • populating 1
    • resetting 1
    • reversing 1
    • with multiline strings and polygons with holes 1
  • MEASURE_RANGE function 1
  • MEASURE_TO_PERCENTAGE function 1
  • measure range 1
  • messages
    • Spatial error messages 1
  • methods
    • SDO_GEOMETRY object type 1
  • migration 1 , 2
    • See also: upgrading
  • min-corner values
    • for three-dimensional rectangle 1
  • minimum bounding circle
    • SDO_MBC_CENTER function 1
    • SDO_MBC_RADIUS function 1
    • SDO_MBC function 1
  • minimum bounding rectangle (MBR)
    • AVERAGE_MBR procedure 1
    • EXTENT_OF function 1
    • geodetic 1
    • SDO_AGGR_MBR aggregate function 1
    • SDO_MAX_MBR_ORDINATE function 1
    • SDO_MBR function 1
    • SDO_MIN_MBR_ORDINATE function 1
  • mining
    • See: data mining
  • MIX_INFO procedure 1
  • MOVE_SDO procedure 1
  • MSL (mean sea level) 1
  • multi-address routing 1
  • multiline string
    • boundary of 1
    • LRS measure values 1
  • multimaster replication
    • SDO_GEOMETRY objects 1
  • multipolygon 1

N

  • NaC coordinate reference system 1
  • NADCON grids
    • converting Spatial XML format to NADCON format 1
    • converting to Spatial XML format 1
  • name conflicts
    • avoiding with SQL Multimedia implementations 1
  • naming considerations
    • Spatial table and column names 1
  • nav_strand 1
  • navigation strand (nav_strand) 1
  • nearest neighbor
    • SDO_NN_DISTANCE operator 1
    • SDO_NN operator 1
  • neighborhood influence 1
  • NODE table
    • routing engine use of 1 , 2 , 3
  • non-ellipsoidal height 1
  • non-uniform rational B-spline (NURBS) curves
    • example 1
  • normal vector 1
  • NTv2 grids
    • converting Spatial XML format to NTv2 format 1
    • converting to Spatial XML format 1
  • NURBS curves
    • example 1
    • GETNURBSAPPROX function 1
    • support in Oracle Spatial 1

O

  • object types
    • embedding SDO_GEOMETRY objects in 1 , 2
  • OCG (Open Geospatial Consortium) simple features conformance 1
  • OCI (Oracle Call Interface) examples 1
  • offset
    • FIND_OFFSET function 1
  • OFFSET_GEOM_SEGMENT function 1
  • offsetting
    • geometric segment 1
  • OGC_X and OGC_Y function names 1
  • ON
    • SDO_ON operator 1
    • topological relationship 1
  • Open Geospatial Consortium (OCG) simple features conformance 1
  • OpenLS
    • subprogram reference information 1
  • OPENLS_DIR_BUSINESS_CHAINS table 1
  • OPENLS_DIR_BUSINESSES table 1
  • OPENLS_DIR_CATEGORIES table 1
  • OPENLS_DIR_CATEGORIZATIONS table 1
  • OPENLS_DIR_CATEGORY_TYPES table 1
  • OPENLS_DIR_SYNONYMS table 1
  • open tour (TSP) 1
  • operators
    • ORDERED optimizer hint with
      • SDO_FILTER 1
      • SDO_JOIN 1
    • overview 1
    • performance-related guidelines 1
    • SDO_ANYINTERACT 1
    • SDO_CONTAINS 1
    • SDO_COVEREDBY 1
    • SDO_COVERS 1
    • SDO_EQUAL 1
    • SDO_FILTER 1
    • SDO_INSIDE 1
    • SDO_JOIN 1
    • SDO_NN 1
    • SDO_NN_DISTANCE 1
    • SDO_ON 1
    • SDO_OVERLAPBDYDISJOINT 1
    • SDO_OVERLAPBDYINTERSECT 1
    • SDO_OVERLAPS 1
    • SDO_POINTINPOLYGON 1
    • SDO_RELATE 1
    • SDO_TOUCH 1
    • SDO_WITHIN_DISTANCE 1
  • optimized box 1
  • optimized rectangle
    • three-dimensional 1
  • optimizer hint (ORDERED) with spatial operators
    • SDO_FILTER 1
    • SDO_JOIN 1
  • Oracle Call Interface (OCI) examples 1
  • Oracle Database 10g
    • upgrading Spatial to 1
  • Oracle Data Mining
    • spatial analysis and mining information 1
  • Oracle Locator
    • See: Locator
  • Oracle Multimedia
    • proper installation required for Locator 1
  • Oracle Workspace Manager
    • using with WFS 1
  • Oracle XA transactions
    • not supported with R-tree spatial indexes 1
  • ORDERED optimizer hint with spatial operators
    • SDO_FILTER 1
    • SDO_JOIN 1
  • Ordnance Survey grid transformation 1
  • oriented point
    • illustration and example 1
  • orthometric height 1
  • OSTN02/OSGM02 grid transformation 1
  • output_time_format attribute
    • of route request 1
  • OVERLAPBDYDISJOINT
    • SDO_OVERLAPBDYDISJOINT operator 1
    • topological relationship 1
  • OVERLAPBDYINTERSECT
    • SDO_OVERLAPBDYINTERSECT operator 1
    • topological relationship 1
  • OVERLAPS
    • SDO_OVERLAPS operator 1

P

  • parallel execution for index creation and rebuilding 1 , 2 , 3
  • parser profiles
    • GC_PARSER_PROFILEAFS table 1
    • GC_PARSER_PROFILES table 1
  • partitioned spatial indexes
    • exchanging partitions 1
  • PARTITION table
    • routing engine use of 1 , 2
  • PERCENTAGE_TO_MEASURE function 1
  • performance and tuning information
    • for Spatial operators 1
  • PL/SQL and SQL examples 1
  • plugins
    • registering for record type 1
  • point
    • data 1
    • illustration and examples of point-only geometry 1
    • interior on surface of polygon 1
    • locating on geometric segment 1
    • LRS 1
    • on surface of polygon 1
    • oriented point 1
    • projection of onto geometric segment 1 , 2
    • shape 1
  • POINT_AT_BEARING function 1
  • point clouds
    • clipping 1 , 2
    • converting to DEM 1
    • converting to geometry 1
    • creating contour geometries 1
    • dropping dependencies 1
    • getting point IDs 1
    • initializing 1
    • modeling solids as 1
    • pyramid 1 , 2
    • pyramiding 1
    • subprograms 1
  • point of interest (POI)
    • GC_POI_((lt))suffix((gt)) table 1
  • polygon
    • area of 1
    • boundary of 1
    • buffer 1
    • centroid 1
    • compound 1
    • exterior and interior rings 1 , 3
    • interior point on surface 1
    • point on surface 1
    • self-crossing not supported 1
    • self-intersecting polygons 1
    • with hole (LRS measure values) 1
  • polygon collection 1
  • polygon data 1
  • POLYGONTOLINE function 1
  • PopulateFeatureTypeXMLInfo procedure 1
  • populating
    • measure 1
  • pre_geocoded_location element 1
  • PRESERVES_LEVEL1 function 1
  • primary filter 1 , 2 , 3
  • primitive types 1
  • problems in current release 1
  • PROJECT_ORDINATES_ONTO_TIN function 1
  • PROJECT_PT function 1
  • projected coordinates 1 , 2
  • projections
    • MDSYS.SDO_PROJECTIONS_OLD_FORMAT table 1
    • MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table 1
    • PROJECT_PT function 1
  • Publish_FeatureTypes_In_Schema procedure 1
  • PublishFeatureType procedure 1
  • publishRecordType method 1
  • pyramids
    • point cloud 1
    • TIN 1

Q

  • quality
    • R-tree 1
  • query 1
  • querying geometric segments
    • subprograms for 1
  • query model for Spatial 1
  • query window 1

R

  • range
    • measure 1
  • README file
    • for Spatial, GeoRaster, and topology and network data models 1
  • rebuilding
    • spatial indexes 1
  • record types
    • dropping 1
    • getting ID 1
    • granting access to a user 1
    • publishing 1
    • registering plugin 1
    • revoking access from a user 1
    • setting capabilities information 1
  • record view map
    • deleting 1
  • record view maps (setting) 1
  • rectangle
    • minimum bounding 1
    • three-dimensional optimized 1
    • type 1
  • rectification of geometries 1
  • RECTIFY_GEOMETRY function 1
  • REDEFINE_GEOM_SEGMENT procedure 1
  • redefining
    • geometric segment 1
  • RegisterFeatureTable procedure 1
  • RegisterMTableView procedure 1
  • registerTypePluginMap method 1
  • RELATE function 1
    • See also: SDO_RELATE operator
  • relational feature types (WFS) 1
  • release number (Spatial)
    • retrieving 1
  • REMOVE_DUPLICATE_VERTICES function 1
  • replication
    • multimaster 1
    • object 1
  • RESET_MEASURE procedure 1
  • restrictions in current release 1
  • return_route_geometry attribute
    • of batch route request 1
  • return_segment_geometry attribute
    • of batch route request 1
  • REVERSE_GEOCODE function 1
  • REVERSE_GEOMETRY function 1
  • REVERSE_LINESTRING function 1
  • REVERSE_MEASURE function 1
  • reverse geocoding 1
  • REVOKE_PREFERENCE_FOR_OP procedure 1
  • RevokeFeatureTypeFromUser procedure 1
  • RevokeMDAccessFromUser procedure 1
  • revokeMDAccessToUser method 1
  • revokeRecordTypeFromUser method 1
  • ring
    • exterior and interior polygon 1
    • extracting from a geometry 1 , 2
  • road_preference attribute
    • of batch route request 1
  • roads
    • GC_ROAD_((lt))suffix((gt)) table 1
  • road segments
    • GC_ROAD_SEGMENT_((lt))suffix((gt)) table 1
  • rollback segment
    • R-tree index creation 1
  • route_request element 1
  • route_type attribute
    • of route request 1
  • ROUTER_TIMEZONE_DATA table
    • routing engine use of 1
  • ROUTER_TIMEZONES table
    • routing engine use of 1
  • route requests
    • example 1
    • input_location element 1
    • pre_geocoded_location element 1
    • schema definition 1
  • route responses
    • example 1
    • XML Schema definition 1
  • routing 1
  • routing engine
    • administration 1
    • data structures used by 1
    • explanation and usage 1
    • multi-address routing 1
    • overview 1
    • routing 1
    • user data structures used by 1
    • XML API 1
  • R-tree indexes
    • description of indexing process 1
    • rebuilding 1
    • requirements before creating 1
    • sequence object 1
  • R-tree quality 1

S

  • SCALE_GEOM_SEGMENT function 1
  • scaling
    • geometric segment 1
  • scenes
    • validating 1
  • schemas
    • creating index on table in another schema 1
    • invoking SDO_JOIN on table in another schema 1
  • SDO_ADDR_ARRAY data type 1
  • SDO_AGGR_CENTROID aggregate function 1
  • SDO_AGGR_CONCAT_LINES aggregate function 1
  • SDO_AGGR_CONVEXHULL aggregate function 1
  • SDO_AGGR_LRS_CONCAT aggregate function 1
  • SDO_AGGR_MBR aggregate function 1
  • SDO_AGGR_SET_UNION aggregate function 1
  • SDO_AGGR_UNION aggregate function 1
  • SDO_ALPHA_SHAPE function 1
  • SDO_ANGLE_UNITS table 1
  • SDO_ANYINTERACT operator 1
  • SDO_ARC_DENSIFY function 1
  • SDO_AREA_UNITS view 1
  • SDO_AREA function 1
  • SDO_BUFFER function 1
  • SDO_CENTROID function 1
  • SDO_CLOSEST_POINTS procedure 1
  • SDO_CONCAVEHULL_BOUNDARY function 1
  • SDO_CONCAVEHULL function 1
  • SDO_CONTAINS operator 1
  • SDO_CONVEXHULL function 1
  • SDO_COORD_AXES table 1
  • SDO_COORD_AXIS_NAMES table 1
  • SDO_COORD_OP_METHODS table 1
  • SDO_COORD_OP_PARAM_USE table 1
  • SDO_COORD_OP_PARAM_VALS table 1
  • SDO_COORD_OP_PARAMS table 1
  • SDO_COORD_OP_PATHS table 1
  • SDO_COORD_OPS table 1
  • SDO_COORD_REF_SYS table 1
  • SDO_COORD_REF_SYSTEM view 1
  • SDO_COORD_SYS table 1
  • SDO_COVEREDBY operator 1
  • SDO_COVERS operator 1
  • SDO_CRS_COMPOUND view 1
  • SDO_CRS_ENGINEERING view 1
  • SDO_CRS_GEOCENTRIC view 1
  • SDO_CRS_GEOGRAPHIC2D view 1
  • SDO_CRS_GEOGRAPHIC3D view 1
  • SDO_CRS_PROJECTED view 1
  • SDO_CRS_VERTICAL view 1
  • SDO_CS package
    • ADD_PREFERENCE_FOR_OP 1
    • CONVERT_3D_SRID_TO_2D 1
    • CONVERT_NADCON_TO_XML 1
    • CONVERT_NTV2_TO_XML 1
    • CONVERT_XML_TO_NADCON 1
    • CONVERT_XML_TO_NTV2 1
    • CREATE_CONCATENATED_OP 1
    • CREATE_OBVIOUS_EPSG_RULES 1
    • CREATE_PREF_CONCATENATED_OP 1
    • DELETE_ALL_EPSG_RULES 1
    • DELETE_OP 1
    • DETERMINE_CHAIN 1
    • DETERMINE_DEFAULT_CHAIN 1
    • FIND_GEOG_CRS 1
    • FIND_PROJ_CRS 1
    • FIND_SRID 1
    • FROM_GEOHASH 1
    • FROM_OGC_SIMPLEFEATURE_SRS 1
    • FROM_USNG 1
    • GET_EPSG_DATA_VERSION function 1
    • GET_GEOHASH_CELL_HEIGHT 1
    • GET_GEOHASH_CELL_WIDTH 1
    • LOAD_EPSG_MATRIX 1
    • MAKE_3D 1
    • MAP_EPSG_SRID_TO_ORACLE 1
    • MAP_ORACLE_SRID_TO_EPSG 1
    • REVOKE_PREFERENCE_FOR_OP 1
    • TO_GEOHASH 1
    • TO_OGC_SIMPLEFEATURE_SRS 1
    • TO_USNG 1
    • TRANSFORM 1
    • TRANSFORM_LAYER 1
    • UPDATE_WKTS_FOR_ALL_EPSG_CRS 1
    • UPDATE_WKTS_FOR_EPSG_CRS 1
    • UPDATE_WKTS_FOR_EPSG_DATUM 1
    • UPDATE_WKTS_FOR_EPSG_ELLIPS 1
    • UPDATE_WKTS_FOR_EPSG_OP 1
    • UPDATE_WKTS_FOR_EPSG_PARAM 1
    • UPDATE_WKTS_FOR_EPSG_PM 1
    • VALIDATE_EPSG_MATRIX 1
    • VALIDATE_WKT 1
  • SDO_CSW package
    • CREATE_SPATIAL_IDX 1
    • CREATE_XQFT_IDX 1
    • INITIALIZE_CSW 1
    • SYNC_INDEX 1
  • SDO_DATUM_ENGINEERING view 1
  • SDO_DATUM_GEODETIC view 1
  • SDO_DATUM_VERTICAL view 1
  • SDO_DATUMS_OLD_FORMAT table 1
  • SDO_DATUMS_OLD_SNAPSHOT table 1
  • SDO_DATUMS table 1
  • SDO_DIAMETER_LINE function 1
  • SDO_DIAMETER function 1
  • SDO_DIFFERENCE function 1
  • SDO_DIST_UNITS view 1
  • SDO_DISTANCE function 1
  • SDO_ELEM_INFO_ARRAY type 1
  • SDO_ELEM_INFO attribute 1
  • SDO_ELLIPSOIDS_OLD_FORMAT table 1
  • SDO_ELLIPSOIDS_OLD_SNAPSHOT table 1
  • SDO_ELLIPSOIDS table 1
  • SDO_EQUAL operator 1
  • SDO_ETYPE value 1
  • SDO_FILTER operator 1
  • SDO_GCDR package
    • CREATE_PROFILE_TABLES 1
    • GEOCODE 1
    • GEOCODE_ADDR 1
    • GEOCODE_ADDR_ALL 1
    • GEOCODE_ALL 1
    • GEOCODE_AS_GEOMETRY 1
    • REVERSE_GEOCODE 1
  • SDO_GEO_ADDR data type and constructors 1
  • SDO_GEOM_MBR operator 1
  • SDO_GEOM_PATH_INFO
    • MDSYS.SDO_GEOM_PATH_INFO type 1
  • SDO_GEOMETRY object type
    • constructors 1
    • embedding in user-defined type 1 , 2
    • in function-based indexes 1
    • methods (member functions) 1
  • SDO_GEOM package
    • RELATE 1
    • SDO_ALPHA_SHAPE 1
    • SDO_ARC_DENSIFY 1
    • SDO_AREA 1
    • SDO_BUFFER 1
    • SDO_CENTROID 1
    • SDO_CLOSEST_POINTS 1
    • SDO_CONCAVEHULL 1
    • SDO_CONCAVEHULL_BOUNDARY 1
    • SDO_CONVEXHULL 1
    • SDO_DIAMETER 1
    • SDO_DIAMETER_LINE 1
    • SDO_DIFFERENCE 1
    • SDO_DISTANCE 1
    • SDO_INTERSECTION 1
    • SDO_LENGTH 1
    • SDO_MAX_MBR_ORDINATE 1
    • SDO_MAXDISTANCE 1
    • SDO_MAXDISTANCE_LINE 1
    • SDO_MBC 1
    • SDO_MBC_CENTER 1
    • SDO_MBC_RADIUS 1
    • SDO_MBR 1
    • SDO_MIN_MBR_ORDINATE 1
    • SDO_POINTONSURFACE 1
    • SDO_SELF_UNION 1
    • SDO_TRIANGULATE 1
    • SDO_UNION 1
    • SDO_VOLUME 1
    • SDO_WIDTH 1
    • SDO_WIDTH_LINE 1
    • SDO_XOR 1
    • VALIDATE_GEOMETRY_WITH_CONTEXT 1
    • VALIDATE_LAYER_WITH_CONTEXT 1
    • WITHIN_DISTANCE 1
  • SDO_GEORASTER type
    • checking after upgrade 1
  • SDO_GTYPE attribute
    • constraining data to a geometry type 1
    • Get_Dims method 1
    • Get_GType method 1
    • Get_LRS_Dim method 1
  • SDO_INDEX_TABLE entry in index metadata views 1
  • SDO_INDX_DIMS keyword 1 , 2
  • SDO_INSIDE operator 1
  • SDO_INTERPRETATION value 1
  • SDO_INTERSECTION function 1
  • SDO_JOIN operator
    • cross-schema invocation 1
  • SDO_KEYWORDARRAY data type 1
  • SDO_LENGTH function 1
  • SDO_LRS package
    • CLIP_GEOM_SEGMENT 1
    • CONCATENATE_GEOM_SEGMENTS 1
    • CONNECTED_GEOM_SEGMENTS 1
    • CONVERT_TO_LRS_DIM_ARRAY 1
    • CONVERT_TO_LRS_GEOM 1
    • CONVERT_TO_LRS_LAYER 1
    • CONVERT_TO_STD_DIM_ARRAY 1
    • CONVERT_TO_STD_GEOM 1
    • CONVERT_TO_STD_LAYER 1
    • DEFINE_GEOM_SEGMENT 1
    • DYNAMIC_SEGMENT 1
    • FIND_LRS_DIM_POS 1
    • FIND_MEASURE 1
    • FIND_OFFSET 1
    • GEOM_SEGMENT_END_MEASURE 1
    • GEOM_SEGMENT_END_PT 1
    • GEOM_SEGMENT_LENGTH 1
    • GEOM_SEGMENT_START_MEASURE 1
    • GEOM_SEGMENT_START_PT 1
    • GET_MEASURE 1
    • GET_NEXT_SHAPE_PT 1
    • GET_NEXT_SHAPE_PT_MEASURE 1
    • GET_PREV_SHAPE_PT 1
    • GET_PREV_SHAPE_PT_MEASURE 1
    • IS_GEOM_SEGMENT_DEFINED 1
    • IS_MEASURE_DECREASING 1
    • IS_MEASURE_INCREASING 1
    • IS_SHAPE_PT_MEASURE 1
    • LOCATE_PT 1
    • LRS_INTERSECTION 1
    • MEASURE_RANGE 1
    • MEASURE_TO_PERCENTAGE 1
    • OFFSET_GEOM_SEGMENT 1
    • PERCENTAGE_TO_MEASURE 1
    • PROJECT_PT 1
    • REDEFINE_GEOM_SEGMENT 1
    • RESET_MEASURE 1
    • REVERSE_GEOMETRY 1
    • REVERSE_MEASURE 1
    • SCALE_GEOM_SEGMENT 1
    • SET_PT_MEASURE 1
    • SPLIT_GEOM_SEGMENT 1
    • TRANSLATE_MEASURE 1
    • VALID_GEOM_SEGMENT 1
    • VALID_LRS_PT 1
    • VALID_MEASURE 1
    • VALIDATE_LRS_GEOMETRY 1
  • SDO_MAX_MBR_ORDINATE function 1
  • SDO_MAXDISTANCE_LINE function 1
  • SDO_MAXDISTANCE function 1
  • SDO_MBC_CENTER function 1
  • SDO_MBC_RADIUS function 1
  • SDO_MBC function 1
  • SDO_MBR function 1
  • SDO_MIGRATE package
    • TO_CURRENT 1
  • SDO_MIN_MBR_ORDINATE function 1
  • SDO_NN_DISTANCE ancillary operator 1
  • SDO_NN_DISTANCE operator
    • complex examples 1
  • SDO_NN operator
    • complex examples 1
    • optimizer hints 1
  • SDO_OLS package
    • MakeOpenLSClobRequest 1
    • MakeOpenLSRequest 1
  • SDO_ON operator 1
  • SDO_ORDINATE_ARRAY type 1
  • SDO_ORDINATES attribute 1
  • SDO_OVERLAPBDYDISJOINT operator 1
  • SDO_OVERLAPBDYINTERSECT operator 1
  • SDO_OVERLAPS operator 1
  • SDO_PC_BLK_TYPE object type 1
  • SDO_PC_BLK object type 1
  • SDO_PC_PKG package
    • CLIP_PC 1
    • CLIP_PC_FLAT 1
    • CREATE_CONTOUR_GEOMETRIES 1
    • CREATE_PC 1
    • DROP_DEPENDENCIES 1
    • GET_PT_IDS 1
    • HAS_PYRAMID 1
    • INIT 1
    • PRESERVES_LEVEL1 1
    • TO_DEM 1
    • TO_GEOMETRY 1
  • SDO_PC object type 1
  • SDO_POINT_TYPE object type 1
  • SDO_POINT attribute 1
  • SDO_POINTINPOLYGON operator 1
  • SDO_POINTONSURFACE function 1
  • SDO_PREFERRED_OPS_SYSTEM table 1
  • SDO_PREFERRED_OPS_USER table 1
  • SDO_PRIME_MERIDIANS table 1
  • SDO_PROJECTIONS_OLD_FORMAT table 1
  • SDO_PROJECTIONS_OLD_SNAPSHOT table 1
  • SDO_REGAGGR object type 1 , 2
  • SDO_REGAGGRSET object type 1 , 2
  • SDO_REGION object type 1
  • SDO_REGIONSET object type 1
  • SDO_RELATE operator 1
  • SDO_ROWIDPAIR object type 1
  • SDO_ROWIDSET data type 1
  • SDO_RTREE_SEQ_NAME sequence object 1
  • SDO_SAM package
    • AGGREGATES_FOR_GEOMETRY 1
    • AGGREGATES_FOR_LAYER 1
    • BIN_GEOMETRY 1
    • BIN_LAYER 1
    • COLOCATED_REFERENCE_FEATURES 1
    • SIMPLIFY_GEOMETRY 1
    • SIMPLIFY_LAYER 1
    • SPATIAL_CLUSTERS 1
    • TILED_AGGREGATES 1
    • TILED_BINS 1
  • SDO_SELF_UNION function 1
  • SDO_SRID attribute 1
  • SDO_ST_TOLERANCE table 1
  • SDO_STARTING_OFFSET value 1
  • SDO_TFM_CHAIN type 1
  • SDO_TIN_BLK_TYPE object type 1
  • SDO_TIN_BLK object type 1
  • SDO_TIN_PKG package
    • CLIP_TIN 1
    • CREATE_TIN 1
    • DROP_DEPENDENCIES 1
    • INIT 1
    • PROJECT_ORDINATES_ONTO_TIN 1
    • TO_DEM 1
    • TO_GEOMETRY 1
  • SDO_TIN object type 1
  • SDO_TOUCH operator 1
  • SDO_TRIANGULATE function 1
  • SDO_TRKR package
    • CREATE_TRACKING_REGIONS 1
    • DESTROY_TRACKING_REGIONS 1
    • SEND_LOCATION_MSGS 1
    • SEND_TRACKING_MSG 1
    • START_TRACKING_REGIONS 1
    • STOP_TRACKING_REGIONS 1
  • SDO_TUNE package
    • AVERAGE_MBR 1
    • ESTIMATE_RTREE_INDEX_SIZE 1
    • EXTENT_OF 1
    • MIX_INFO 1
  • SDO_UNION function 1
  • SDO_UNIT column
    • in SDO_AREA_UNITS table 1
    • in SDO_DIST_UNITS table 1
  • SDO_UNITS_OF_MEASURE table 1
  • SDO_UTIL package
    • AFFINETRANSFORMS 1
    • APPEND 1
    • BEARING_TILT_FOR_POINTS 1
    • CIRCLE_POLYGON 1
    • CONCAT_LINES 1
    • CONVERT_UNIT 1
    • CONVERT3007TO3008 1
    • DROP_WORK_TABLES 1
    • ELLIPSE_POLYGON 1
    • EXTRACT 1
    • EXTRACT_ALL 1
    • EXTRACT3D 1
    • EXTRUDE 1
    • FROM_GEOJSON 1
    • FROM_GML311GEOMETRY 1
    • FROM_GMLGEOMETRY 1
    • FROM_KMLGEOMETRY 1
    • FROM_WKBGEOMETRY 1
    • FROM_WKTGEOMETRY 1
    • GEO_SEARCH 1
    • GET_2D_FOOTPRINT 1
    • GETNUMELEM 1
    • GETNUMVERTICES 1
    • GETNURBSAPPROX 1
    • GETVERTICES 1
    • INITIALIZE_INDEXES_FOR_TTS 1
    • INTERIOR_POINT 1
    • POINT_AT_BEARING 1
    • POLYGONTOLINE 1
    • RECTIFY_GEOMETRY 1
    • REMOVE_DUPLICATE_VERTICES 1
    • REVERSE_LINESTRING 1
    • SIMPLIFY 1 , 2
    • THEME3D_GET_BLOCK_TABLE 1
    • THEME3D_HAS_LOD 1
    • THEME3D_HAS_TEXTURE 1
    • TO_GEOJSON 1
    • TO_GML311GEOMETRY 1
    • TO_GMLGEOMETRY 1
    • TO_KMLGEOMETRY 1
    • TO_WKBGEOMETRY 1
    • TO_WKTGEOMETRY 1
    • VALIDATE_3DTHEME 1
    • VALIDATE_SCENE 1
    • VALIDATE_VIEWFRAME 1
    • VALIDATE_WKBGEOMETRY 1
    • VALIDATE_WKTGEOMETRY 1
  • SDO_VERSION function 1
  • SDO_VOLUME function 1
  • SDO_WCS.CreateTempTable procedure 1
  • SDO_WCS.DropTempTable procedure 1
  • SDO_WCS.GrantPrivilegesToWCS procedure 1
  • SDO_WCS.Init procedure 1
  • SDO_WCS.PublishCoverage procedure 1
  • SDO_WCS.RevokePrivilegesFromWCS procedure 1
  • SDO_WCS.UnpublishCoverage procedure 1
  • SDO_WCS.ValidateCoverages function 1
  • SDO_WCS package
    • CreateTempTable 1
    • DropTempTable 1
    • GrantPrivilegesToWCS 1
    • Init 1
    • PublishCoverage 1
    • RevokePrivilegesFromWCS 1
    • UnpublishCoverage 1
    • ValidateCoverages 1
  • SDO_WFS_LOCK package
    • EnableDBTxns 1
    • RegisterFeatureTable 1
    • UnRegisterFeatureTable 1
  • SDO_WFS_PROCESS package
    • DropFeatureType 1
    • DropFeatureTypes 1
    • GenCollectionProcs 1
    • GetFeatureTypeId 1
    • GrantFeatureTypeToUser 1
    • GrantMDAccessToUser 1
    • InsertCapabilitiesInfo 1
    • InsertFtDataUpdated 1
    • InsertFtMDUpdated 1
    • PopulateFeatureTypeXMLInfo 1
    • Publish_FeatureTypes_In_Schema 1
    • PublishFeatureType 1
    • RegisterMTableView 1
    • RevokeFeatureTypeFromUser 1
    • RevokeMDAccessFromUser 1
    • UnRegisterMTableView 1
  • SDO_WIDTH_LINE function 1
  • SDO_WIDTH function 1
  • SDO_WITHIN_DISTANCE operator
    • complex examples 1
  • SDO_XOR function 1
  • SDOAGGRTYPE object type 1
  • sdows.ear file
    • deploying 1
  • sea level
    • gravity-related height 1
  • secondary filter 1 , 2
  • segments
    • geometric 1
  • self-crossing line strings and polygons 1
  • self-intersecting polygons 1
  • self-joins
    • optimizing 1
  • self union 1
  • semi-major axis 1 , 2
  • semi-minor axis 1
  • SEND_LOCATION_MSGS procedure 1
  • SEND_TRACKING_MSG procedure 1
  • sequence object for R-tree index 1
  • SET_PT_MEASURE procedure 1
  • setCapabilitiesInfo method 1
  • setDomainInfo method 1
  • setRecordViewMap method 1
  • setXMLTableIndexInfo method 1
  • shapefiles
    • loading into Spatial 1
  • shape point
    • determining if measure value is a shape point 1
    • getting measure of next 1
    • getting measure of previous 1
    • getting next 1
    • getting previous 1
  • SIGN_POST table
    • routing engine use of 1
  • simple element 1
  • simple features (OGC)
    • Oracle Spatial conformance 1
  • simplification of geometries 1 , 2
  • SIMPLIFY_GEOMETRY function 1
  • SIMPLIFY_LAYER procedure 1
  • SIMPLIFY function 1 , 2
  • size requirements (hardware) for spatial applications 1
  • solids
    • exterior and interior 1
    • modeling of 1
    • SDO_ETYPE value 1
    • volume of 1
  • SORT_AREA_SIZE parameter
    • R-tree index creation 1
  • SPATIAL_CLUSTERS function 1
  • SPATIAL_CSW_ADMIN_USR account and schema 1
  • SPATIAL_VECTOR_ACCELERATION system parameter 1
  • spatial aggregate functions
    • See: aggregate functions
  • spatial analysis and mining
    • conceptual and usage information 1
    • function reference information 1
  • Spatial and Graph web services
    • deploying and configuring 1
    • introduction 1
  • spatial binning
    • See alsobins 1
  • spatial clustering 1
  • spatial correlation 1
  • spatial data mining
    • conceptual and usage information 1
    • function reference information 1
  • spatial data structures 1
  • spatial data types 1
  • spatial index
    • See: index
  • spatial indexes
    • interval partitioning example 1
    • system-managed 1
    • virtual column partitioning example 1
  • spatial join
    • SDO_JOIN operator 1
  • spatially enabling a table 1
  • Spatial metadata tables
    • moving 1
  • spatial operators
    • See: operators
  • spatial query 1
  • spatial reference systems
    • conceptual and usage information 1
    • example 1
    • subprogram reference information 1
  • spatial routing engine
    • See: routing engine
  • spheroids
    • MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table 1
    • MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table 1
  • SPLIT_GEOM_SEGMENT procedure 1
  • splitting
    • geometric segment 1
  • SQL*Loader 1
  • SQL and PL/SQL examples 1
  • SQL Multimedia
    • avoiding name conflicts 1
    • FROM_WKBGEOMETRY function 1
    • FROM_WKTGEOMETRY function 1
    • ST_GEOMETRY type 1
    • support in Spatial 1
    • TO_WKBGEOMETRY function 1
    • TO_WKTGEOMETRY function 1
    • tolerance value 1
    • VALIDATE_WKBGEOMETRY function 1
    • VALIDATE_WKTGEOMETRY function 1
  • SQL Multimedia standard
    • ST_CoordDim method 1
    • ST_IsValid method 1
  • SQL statements
    • for indexing spatial data 1
  • SRID
    • checking for existence 1
    • finding 1
    • in USER_SDO_GEOM_METADATA 1
    • mapping Oracle to EPSG 1
    • SDO_SRID attribute in SDO_GEOMETRY 1
  • ST_ANNOTATION_TEXT constructor 1
  • ST_CoordDim method 1
  • ST_GEOMETRY type 1
  • ST_IsValid method 1
  • start_date attribute
    • of route request 1
  • start_time attribute
    • of route request 1
  • START_TRACKING_REGIONS procedure 1
  • start location for route 1
  • STOP_TRACKING_REGIONS procedure 1
  • subprograms
    • coordinate system transformation 1
    • data mining 1
    • geocoding 1
    • geometry 1
    • linear referencing 1
    • location tracking 1
    • OpenLS 1
    • point clouds 1
    • SDO_CSW (Catalog Services for the Web) 1
    • SDO_MIGRATE 1
    • spatial analysis 1
    • TINs 1
    • tuning 1
    • utility 1
    • Web Coverage Service 1
    • WFS 1
    • WFS processing 1
  • subroutes
    • explanation of 1
  • surface normal 1
  • surfaces
    • modeling of 1
    • SDO_ETYPE value 1
  • SYNC_INDEX procedure 1
  • system-managed indexes 1

T

  • TABLE_NAME (in USER_SDO_GEOM_METADATA) 1
  • table names
    • restrictions on spatial table names 1
  • tables
    • spatially enabling 1
  • textures
    • checking if theme has 1
    • using 1
  • TFM_PLAN object type 1
  • THEME3D_GET_BLOCK_TABLE function 1
  • THEME3D_HAS_LOD function 1
  • THEME3D_HAS_TEXTURE function 1
  • themes
    • checking for LODs 1
    • checking for textures 1
    • getting block table 1
    • validating 1
  • three-dimensional (3D)
    • formats of LRS functions
      • not supported with geodetic data 1
    • spatial objects
      • solids 1
      • surfaces 1
  • TILED_AGGREGATES function 1
  • TILED_BINS function 1
  • TINs
    • clipping 1
    • converting to DEM 1
    • converting to geometry 1
    • creating 1 , 2
    • dropping dependencies 1
    • initializing 1
    • projecting ordinates onto 1
    • pyramiding 1
    • subprograms 1
  • TINs (triangulated irregular networks) 1
  • TO_CURRENT procedure and function 1
  • TO_DEM procedure 1 , 2
  • TO_GEOHASH function 1
  • TO_GEOJSON function 1
  • TO_GEOMETRY function 1 , 2
  • TO_GML311GEOMETRY function 1
  • TO_GMLGEOMETRY function 1
  • TO_KMLGEOMETRY function 1
  • TO_OGC_SIMPLEFEATURE_SRS function 1
  • TO_USNG function 1
  • TO_WKBGEOMETRY function 1
  • TO_WKTGEOMETRY function 1
  • tolerance
    • for SQL Multimedia types 1
    • with LRS functions 1
  • topological self union 1
  • TOUCH
    • SDO_TOUCH operator 1
    • topological relationship 1
  • TP_USER_DATA table
    • routing engine use of 1
  • tracking regions 1 , 2 , 3 , 4
  • transactional insertion of spatial data 1
  • TRANSFORM_LAYER procedure
    • table for transformed layer 1
  • transformation
    • arcs and circles not supported 1
  • TRANSFORM function 1
  • TRANSLATE_MEASURE function 1
  • transportable tablespaces
    • initializing spatial indexes 1
  • traveling salesperson (TSP) route 1
  • triangulated irregular networks (TINs) 1
  • triangulation
    • SDO_TRIANGULATE function 1
  • truck_height attribute
    • of route request 1
  • truck_length attribute
    • of route request 1
  • truck_per_axle_weight attribute
    • of route request 1
  • truck_type attribute
    • of route request 1
  • truck_weight attribute
    • of route request 1
  • truck_width attribute
    • of route request 1
  • TSP route 1
  • tuning and performance information
    • for spatial operators 1
  • tuning subprograms 1
  • two-tier query model 1
  • type zero (0) element 1

U

  • U.S. National Grid
    • SDO_CS.FROM_USNG function 1
    • SDO_CS.TO_USNG function 1
    • support in Oracle Spatial 1
  • unformatted addresses 1
  • union 1
  • UNIT_NAME column
    • in SDO_ANGLE_UNITS table 1
    • in SDO_AREA_UNITS table 1
    • in SDO_DIST_UNITS table 1
  • unit of measurement
    • MDSYS tables 1
  • unknown CRS coordinate reference system 1
  • UnRegisterFeatureTable procedure 1
  • UnRegisterMTableView procedure 1
  • UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure 1
  • UPDATE_WKTS_FOR_EPSG_CRS procedure 1
  • UPDATE_WKTS_FOR_EPSG_DATUM procedure 1
  • UPDATE_WKTS_FOR_EPSG_ELLIPS procedure 1
  • UPDATE_WKTS_FOR_EPSG_OP procedure 1
  • UPDATE_WKTS_FOR_EPSG_PARAM procedure 1
  • UPDATE_WKTS_FOR_EPSG_PM procedure 1
  • upgrading
    • data to current Spatial release 1
    • GeoRaster 1
    • Spatial to current Oracle Database release 1
  • upgrading spatial data to current release 1
  • USE_SPHERICAL use case name 1
  • use cases
    • for coordinate system transformation 1
  • USER_ANNOTATION_TEXT_METADATA view 1
  • USER_SDO_3DTHEMES view 1
  • USER_SDO_GEOM_METADATA view 1
  • USER_SDO_INDEX_INFO view 1
  • USER_SDO_INDEX_METADATA view 1
  • USER_SDO_SCENES view 1
  • USER_SDO_VIEWFRAMES view 1
  • user-defined coordinate reference system 1
  • user-defined data types
    • embedding SDO_GEOMETRY objects in 1 , 2
  • utility subprograms 1

V

  • VALID_GEOM_SEGMENT function 1
  • VALID_LRS_PT function 1
  • VALID_MEASURE function 1
  • VALIDATE_3DTHEME function 1
  • VALIDATE_EPSG_MATRIX procedure 1
  • VALIDATE_GEOMETRY_WITH_CONTEXT function 1
  • VALIDATE_LAYER_WITH_CONTEXT procedure 1
  • VALIDATE_LRS_GEOMETRY function 1
  • VALIDATE_SCENE function 1
  • VALIDATE_VIEWFRAME function 1
  • VALIDATE_WKBGEOMETRY function 1
  • VALIDATE_WKT function 1
  • VALIDATE_WKTGEOMETRY function 1
  • validation of geometries
    • general and two-dimensional checks 1
    • importance of performing 1
    • three-dimensional checks 1
  • Vector Performance Accelerator (VPA) feature 1
  • vehicle_type attribute
    • of route request 1
  • vendor attribute
    • of route request 1
  • versioning (CSW)
    • disabling 1
    • enabling 1
  • version number (Spatial)
    • retrieving 1
  • VERTEX_SET_TYPE data type 1
  • VERTEX_TYPE object type 1
  • vertices
    • maximum number in SDO_GEOMETRY object 1
    • removing duplicate 1
    • returning geometry coordinates as 1
  • viewframes
    • validating 1
  • views
    • ALL_ANNOTATION_TEXT_METADATA 1
    • ALL_SDO_GEOM_METADATA 1
    • ALL_SDO_INDEX_INFO 1
    • ALL_SDO_INDEX_METADATA 1
    • USER_ANNOTATION_TEXT_METADATA 1
    • USER_SDO_GEOM_METADATA 1
    • USER_SDO_INDEX_INFO 1
    • USER_SDO_INDEX_METADATA 1
  • virtual column partitioning
    • spatial indexing example 1
  • volume 1
  • VPA (Vector Performance Accelerator) feature 1

W

  • Web Coverage Service (WCS) subprograms 1
  • web services
    • deploying and configuring 1
    • introduction 1
  • well-known binary (WKB)
    • See: WKB
  • well-known text (WKT)
    • See: WKT
  • WFS
    • engine 1
    • feature types 1
    • subprogram reference information 1
    • using with Oracle Workspace Manager 1
  • WFS processing
    • subprogram reference information 1
  • width
    • SDO_WIDTH_LINE function 1
    • SDO_WIDTH function 1
  • WITHIN_DISTANCE function 1
    • See also: SDO_WITHIN_DISTANCE operator
  • WKB
    • FROM_WKBGEOMETRY function 1
    • Get_WKB method 1
    • TO_WKBGEOMETRY function 1
    • VALIDATE_WKBGEOMETRY function 1
  • WKT
    • FROM_WKTGEOMETRY function 1
    • Get_WKT method 1
    • procedures for updating 1
    • TO_WKTGEOMETRY function 1
    • UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure 1
    • UPDATE_WKTS_FOR_EPSG_CRS procedure 1
    • UPDATE_WKTS_FOR_EPSG_DATUM procedure 1
    • UPDATE_WKTS_FOR_EPSG_ELLIPS procedure 1
    • UPDATE_WKTS_FOR_EPSG_OP procedure 1
    • UPDATE_WKTS_FOR_EPSG_PARAM procedure 1
    • UPDATE_WKTS_FOR_EPSG_PM procedure 1
    • VALIDATE_WKTGEOMETRY function 1
    • validating (given SRID) 1
  • WKTEXT column of MDSYS.CS_SRS table
    • procedures for updating value 1
  • Workspace Manager
    • using with WFS 1
  • WSConfig.xml file 1

X

  • XA transactions
    • not supported with R-tree spatial indexes 1
  • XML API
    • routing engine 1
  • XML table index
    • setting information for record type 1
  • XMLTABLEINDEX index
    • checking for existence 1
    • deleting on feature table 1
  • XOR
    • SDO_XOR function 1

Y

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

Z

  • zero
    • type 0 element 1