Index
A B C D E F G H I J L M N O P Q R S T U V W X Y Z
Numerics
- 0
-
- SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 21
- type 0 (zero) element, 2.7.7
- 3D
-
- formats of LRS functions, 7.4
-
- not supported with geodetic data, 6.10.2
- spatial objects, 1.11
-
- solids, 1.11.2
- surfaces, 1.11.1
A
- ADD_PREFERENCE_FOR_OP procedure, 21
- addresses
-
- representing for geocoding, 11.1.1
- aggregate functions
-
- description, 1.10
- reference information, 20
- SDO_AGGR_CENTROID, 20
- SDO_AGGR_CONCAT_LINES, 20
- SDO_AGGR_CONVEXHULL, 20
- SDO_AGGR_LRS_CONCAT, 20
- SDO_AGGR_MBR, 20
- SDO_AGGR_UNION, 20
- SDOAGGRTYPE object type, 1.10.1
- AGGREGATES_FOR_GEOMETRY function, 29
- AGGREGATES_FOR_LAYER function, 29
- aliases, 6.7.2
- ALL_ANNOTATION_TEXT_METADATA view, 3.4.2
- ALL_SDO_GEOM_METADATA view, 2.8
- ALL_SDO_INDEX_INFO view, 2.9.1.1
- ALL_SDO_INDEX_METADATA view, 2.9.1.2
- ALTER INDEX statement, 18
-
- REBUILD clause, 18
- RENAME TO clause, 18
- angle units, 6.8.2
- annotation text, 3.4
- ANYINTERACT
-
- SDO_ANYINTERACT operator, 19
- topological relationship, 1.8
- APPEND function, 32
- APPEND_TO_COLLECTION function, 32
- application size (hardware) requirements, 1.18
- application user management
-
- identity propagation option, 17.1.1
- arc
-
- densifying, 24
- not supported with geodetic data or for transformations, 6.2.4
- area, 24
- area units, 6.8.3
- average minimum bounding rectangle, 31
- AVERAGE_MBR procedure, 31
B
- batch route requests, 13.2.5.1
-
- DTD, 13.2.5
- example, 13.2.4
- batch route responses
-
- DTD, 13.2.6
- example, 13.2.4
- batch_route_request element, 13.2.5.1
- bearing
-
- point at, 32
- BIN_GEOMETRY function, 29
- BIN_LAYER procedure, 29
- binning
-
- spatial, 8.2
-
- See also bins
- bins
-
- assigning, 29
- computing, 29
- tiled, 29
- boundary
-
- of area, 1.8
- of line string, 1.8
- of multiline string, 1.8
- of polygon, 1.8
- bounding rectangle
-
- minimum, 31
- box
-
- optimized, 2.2.4
- break lines, 1.11.1
- buffer area, 24
- bulk loading of spatial data, 4.1
- business directory (YP)
-
- data requirements and providers, 12.2
- data structures for, 12.3
- OpenLS service support and examples, 14.3.4
- support in Spatial, 12
C
- C language
-
- examples (using OCI), 1.20
- Cartesian coordinates, 1.5.4, 6.1.2
- cartographic text (annotation text), 3.4
- center of gravity (centroid), 24
- centroid
-
- SDO_AGGR_CENTROID aggregate function, 20
- SDO_CENTROID function, 24
- circle
-
- creating polygon approximating, 32
- not supported with geodetic data or for projections, 6.2.4
- type, 2.2.4
- CIRCLE_POLYGON function, 32
- CLIP_GEOM_SEGMENT function, 25
- CLIP_PC function, 28
- CLIP_TIN procedure, 30
- clipping
-
- geometric segment, 7.5.3
- closest points
-
- SDO_CLOSEST_POINTS procedure, 24
- COLOCATED_REFERENCE_FEATURES procedure, 29
- colocation mining, 8.4
- column name
-
- restrictions on spatial column names, 2.8.2
- COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2.8.2
- compatibility, A
- complex examples
-
- queries, C
- compound element, 2.2.4
- compound line string, 2.2.4, 2.7.3
- compound polygon, 2.2.4
- CONCAT_LINES function, 32
- CONCATENATE_GEOM_SEGMENTS function, 25
- concatenating
-
- geometric segments, 7.5.5
- line or multiline geometries, 20
- LRS geometries, 7.5.5, 20
- CONNECTED_GEOM_SEGMENTS function, 25
- consistency
-
- checking for valid geometry types, 24
- constraining data to a geometry type, 5.1.1
- constructors
-
- SDO_GEOMETRY object type, 2.4
- CONTAINS
-
- SDO_CONTAINS operator, 19
- topological relationship, 1.8
- 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_NADCON_TO_XML procedure, 21
- CONVERT_NTV2_TO_XML procedure, 21
- CONVERT_TO_LRS_DIM_ARRAY function, 25
- CONVERT_TO_LRS_GEOM function, 25
- CONVERT_TO_LRS_LAYER function, 25
- CONVERT_TO_STD_DIM_ARRAY function, 25
- CONVERT_TO_STD_GEOM function, 25
- CONVERT_TO_STD_LAYER function, 25
- CONVERT_UNIT function, 32
- CONVERT_XML_TO_NADCON procedure, 21
- CONVERT_XML_TO_NTV2 procedure, 21
- converting
-
- geometric segments
-
- overview, 7.5.10
- subprograms for, 25
- convex hull
-
- SDO_AGGR_CONVEXHULL aggregate function, 20
- SDO_CONVEXHULL function, 24
- coordinate dimension
-
- ST_CoordDim method, 2.3
- coordinate reference systems
-
- See coordinate systems
- coordinate systems, 1.5.4
-
- conceptual and usage information, 6
- data structures supplied by Oracle, 6.7
- example, 6.12
- local, 6.3
- subprogram reference information, 21
- unit of measurement support, 2.10
- user-defined, 6.9
- coordinates
-
- Cartesian, 1.5.4, 6.1.2
- geodetic, 1.5.4, 6.1.3, 6.2
- geographic, 1.5.4, 6.1.3
- local, 1.5.4, 6.1.5
- projected, 1.5.4, 6.1.4
- COVEREDBY
-
- SDO_COVEREDBY operator, 19
- topological relationship, 1.8
- COVERS
-
- SDO_COVERS operator, 19
- topological relationship, 1.8
- CPU requirements for applications using Spatial, 1.18
- CREATE INDEX statement, 18
- CREATE_CONCATENATED_OP procedure, 21
- CREATE_OBVIOUS_EPSG_RULES procedure, 21
- CREATE_PC procedure, 28
- CREATE_PREF_CONCATENATED_OP procedure, 21
- CREATE_TIN procedure, 30
- createXMLTableIndex method, 15.4.1, 16.4.1
- creating
-
- geometric segments
-
- subprograms for, 25
- cross-schema index creation, 5.1.2
- CS_SRS table, 6.8.1
- current release
-
- upgrading spatial data to, 26
- cutoff_distance attribute
-
- of batch route request, 13.2.5.2
D
- data mining
-
- spatial
-
- colocation mining, 8.4
- conceptual and usage information, 8
- function reference information, 29
- data model, 1.5
-
- LRS, 7.2
- data types
-
- geocoding, 11.2
- spatial, 2
- database links
-
- not supported if spatial index is defined on the table, 5.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, 25
- defining
-
- geometric segment, 7.5.1
- DELETE_ALL_EPSG_RULES procedure, 21
- DELETE_OP procedure, 21
- DeleteCapabilitiesInfo procedure, 22
- deleteDomainInfo method, 16.4.2
- DeleteDomainInfo procedure, 22
- DeletePluginMap procedure, 22
- deleteRecordViewMap method, 16.4.3
- DeleteRecordViewMap procedure, 22
- demo files
-
- Spatial Web services, 10.4
- densification of arcs, 24
- detailed route geometry
-
- in route request, 13.2.2.2
- DETERMINE_CHAIN function, 21
- DETERMINE_DEFAULT_CHAIN function, 21
- difference
-
- SDO_GEOM.SDO_DIFFERENCE function, 24
- dimension (in SDO_GTYPE), 2.2.1, 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, 16.4.4
- discretization (binning)
-
- spatial, 8.2
- See also bins
- DISJOINT
-
- topological relationship, 1.8
- disk storage requirements for applications using Spatial, 1.18
- distance
-
- SDO_NN_DISTANCE ancillary operator, 19
- WITHIN_DISTANCE function, 24
- distance units, 6.8.5
- distance_unit attribute
-
- of route request, 13.2.2.2
- distributed transactions
-
- requirements to ensure spatial index consistency, 5.1.6
- domain information (CSW)
-
- deleting, 16.4.2
- domains (CSW)
-
- setting information, 16.4.17
- Douglas-Peucker algorithm for geometry simplification, 32
- downgrading
-
- Oracle Spatial to the previous Oracle Database release, A
- driving directions
-
- in route request, 13.2.2.2
- driving_directions_detail attribute
-
- of route request, 13.2.2.2
- DROP INDEX statement, 18
- DROP_DEPENDENCIES procedure, 28, 30
- DROP_WORK_TABLES procedure, 32
- dropFeatureType method, 15.4.2
- DropFeatureType procedure, 34
- DropFeatureTypes procedure, 34
- dropRecordType method, 16.4.5
- dropXMLTableIndex method, 15.4.3, 16.4.6
- duplicate vertices
-
- removing, 32
- dynamic query window, 5.2.1
- DYNAMIC_SEGMENT function, 25
E
- .ear file
-
- deploying and configuring for Spatial Web services, 17.3
- edge ID values
-
- in route request, 13.2.2.2, 13.2.2.2
- EDGE table
-
- routing engine use of, 13.3.1
- editing
-
- geometric segments
-
- subprograms for, 25
- ELEM_INFO (SDO_ELEM_INFO attribute), 2.2.4
- elements, 1.5.1
-
- extracting from a geometry, 32, 32
- returning number of elements in a geometry, 32
- returning number of vertices in a geometry, 32
- ellipse
-
- creating polygon approximating, 32
- ELLIPSE_POLYGON function, 32
- ellipsoidal height, 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, 9.1
- enableVersioning method, 16.4.7
- end location for route, 13.2.2.1
- entity-relationship (E-R) diagram
-
- EPSG tables, 6.7.28
- EPSG, 6.7
-
- mapping of table names to Oracle Spatial names, 6.7.28
- EPSG data
-
- version, 21
- EPSG SRID
-
- mapping Oracle SRID to, 21
- mapping to Oracle SRID, 21
- EQUAL
-
- SDO_EQUAL operator, 19
- topological relationship, 1.8
- E-R (entity-relationship diagram)
-
- EPSG tables, 6.7.28
- error messages
-
- geocoding, 11.1.4
- Spatial, 1.19
- ESTIMATE_RTREE_INDEX_SIZE function, 31
- ETYPE (SDO_ETYPE value), 2.2.4, 2.2.4
- European Petroleum Survey Group
-
- See EPSG
- examples
-
- batch route request and response, 13.2.4
- C, 1.20
- complex queries, C
- coordinate systems, 6.12
- creating, indexing, and querying spatial data, 2.1
- directory for Spatial examples, 1.20
- linear referencing system (LRS), 7.7
- many geometry types (creating), 2.7
- OCI (Oracle Call Interface), 1.20
- PL/SQL, 1.20
- route request and response, 13.2.1
- route request with previously geocoded locations, 13.2.1
- route response with previously geocoded locations, 13.2.1
- SQL, 1.20
- exchanging partitions including indexes, 5.1.4
- Export utility
-
- with spatial indexes and data, 5.1.5
- EXTENT_OF function, 31
- exterior polygon rings, 2.2.4, 2.2.4, 2.7.2, 2.7.2
- exterior solids, 2.2.4
- EXTRACT function, 32, 32
- extractSDO function, 16.2.2
- EXTRUDE function, 32
- extrusion
-
- creating, 32
F
- feature types
-
- dropping, 15.4.2
- granting access to a user, 15.4.5
- publishing, 15.4.7
- revoking access from a user, 15.4.8
- features
-
- linear, 7.1.10
- FILTER
-
- SDO_FILTER operator, 19
- FILTER mask value for SDO_JOIN, 19
- FIND_GEOG_CRS function, 21
- FIND_LRS_DIM_POS function, 25
- FIND_MEASURE function, 25
- FIND_OFFSET function, 25
- FIND_PROJ_CRS function, 21
- formatted addresses, 11.1.1
- FROM_815_TO_81X procedure
-
- use TO_CURRENT instead, 26
- FROM_GML311GEOMETRY function, 32
- FROM_GMLGEOMETRY function, 32
- FROM_OGC_SIMPLEFEATURE_SRS function, 21
- FROM_USNG function, 21
- FROM_WKBGEOMETRY function, 32
- FROM_WKTGEOMETRY function, 32
- frustums, 1.11.2
- function-based indexes
-
- with SDO_GEOMETRY objects, 9.2
- functions
-
- spatial aggregate, 20
- supported by approximations with geodetic data, 6.10.3
G
- GC_AREA_<suffix> table, 11.5.1
- GC_COUNTRY_PROFILE table, 11.5.2
- GC_INTERSECTION_<suffix> table, 11.5.3
- GC_POI_<suffix> table, 11.5.4
- GC_POSTAL_CODE_<suffix> table, 11.5.5
- GC_ROAD_<suffix> table, 11.5.6
- GC_ROAD_SEGMENT_<suffix> table, 11.5.7
- GenCollectionProcs procedure, 34
- GEOCODE function, 23
- GEOCODE_ADDR function, 23
- GEOCODE_ADDR_ALL function, 23
- GEOCODE_ALL function, 23
- GEOCODE_AS_GEOMETRY function, 23
- geocoding, 1.12
-
- concepts, 11.1
- data requirements, 11.3
- data types for, 11.2
- error messages, 11.1.4
- from a place name, 11.4
- indexes required on tables for geocoding, 11.5.8
- match codes, 11.1.3
- match modes, 11.1.2
- reverse, 23
- subprogram reference information, 23
- usage information, 11
- geocoding requests
-
- DTD, 11.6.2
- geocoding responses
-
- DTD, 11.6.3
- geodetic coordinates, 1.5.4, 6.1.3
-
- arcs and circles not supported, 6.2.4
- functions supported by approximations, 6.10.3
- support for, 6.2
- geodetic datum, 1.5.4, 6.1.6
- geodetic MBRs, 6.2.3
- geographic coordinates
-
- See geodetic coordinates
- geography markup language (GML)
-
- converting geometry to, 32, 32
- GEOM_SEGMENT_END_MEASURE function, 25
- GEOM_SEGMENT_END_PT function, 25
- GEOM_SEGMENT_LENGTH function, 25
- GEOM_SEGMENT_START_MEASURE function, 25
- GEOM_SEGMENT_START_PT function, 25
- geometric segment
-
- clipping, 7.5.3
- concatenating, 7.5.5
-
- aggregate, 7.5.5, 20
- converting (overview), 7.5.10
- converting (subprograms for), 25
- creating (subprograms for), 25
- defining, 7.5.1
- definition of, 7.1.1
- direction, 7.1.3
- direction with concatenation, 7.5.5
- editing (subprograms for), 25
- locating point on, 7.5.8
- offsetting, 7.5.7
- projecting point onto, 7.5.9
- querying (subprograms for), 25
- redefining, 7.5.2
- scaling, 7.5.6
- splitting, 7.5.4
- geometry subprograms
-
- reference information, 24
- geometry types, 1.4
-
- constraining data to, 5.1.1
- Get_GType method, 2.3
- SDO_GTYPE, 2.2.1
- GeoRaster
-
- checks and actions after upgrade, A.1
- gerRecordTypeId method, 16.4.9
- Get_Dims method, 2.3
- GET_EPSG_DATA_VERSION function, 21
- Get_GType method, 2.3
- Get_LRS_Dim method, 2.3
- GET_MEASURE function, 25
- GET_NEXT_SHAPE_PT function, 25
- GET_NEXT_SHAPE_PT_MEASURE function, 25
- GET_PREV_SHAPE_PT function, 25
- GET_PREV_SHAPE_PT_MEASURE function, 25
- GET_PT_IDS function, 28
- Get_WKB method, 2.3
- Get_WKT method, 2.3
- GetFeatureTypeId function, 34
- getIsXMLTableIndexCreated method, 15.4.4, 16.4.8
- GETNUMELEM function, 32
- GETNUMVERTICES function, 32
- GetRecordTypeId function, 22
- GETVERTICES function, 32
- GML (geography markup language)
-
- converting geometry to, 32, 32
- grantFeatureTypeToUser method, 15.4.5
- GrantFeatureTypeToUser procedure, 34
- grantMDAccessToUser method, 15.4.6, 16.4.10
- GrantMDAccessToUser procedure, 34
- grantRecordTypeToUser method, 16.4.11
- gravity-related height, 6.5.2
- GTYPE (SDO_GTYPE attribute), 2.2.1
-
- constraining data to a geometry type, 5.1.1
- Get_Dims method, 2.3
- Get_GType method, 2.3
- GET_LRS_Dim method, 2.3
H
- hardware requirements for applications using Spatial, 1.18
- height
-
- ellipsoidal, 6.5.1
- gravity-related, 6.5.2
- hierarchical driving directions
-
- in route request, 13.2.2.2
I
- id attribute
-
- of route request, 13.2.2.2
- identity propagation
-
- application user management, 17.1.1
- proxy authentication, 17.1.1
- single application user, 17.1.1
- Spatial Web services, 17.1.1
- Import utility
-
- with spatial indexes and data, 5.1.5
- index
-
- distributed transactions and spatial index consistency, 5.1.6
- indexes
-
- creating, 5.1
-
- cross-schema, 5.1.2
- parallel execution, 18
- description of Spatial indexing, 1.7
- extending spatial indexing capabilities, 9
- function-based with SDO_GEOMETRY objects, 9.2
- partitioned, 5.1.3
-
- exchanging partitions including indexes, 5.1.4
- rebuilding, 18
-
- parallel execution, 18, 18
- R-tree
-
- description, 1.7.1
- requirements before creating, 5.1.7
- size (R-tree), 31
- index-organized table
-
- cannot create spatial index on, 2.8.1, 18
- INIT function, 28, 30
- INITIALIZE_INDEXES_FOR_TTS procedure, 32
- input_location element, 13.2.2.3
- InsertCapabilitiesInfo procedure, 22, 34
- InsertDomainInfo procedure, 22
- InsertFtDataUpdated procedure, 34
- InsertFtMDUpdated procedure, 34
- inserting spatial data
-
- PL/SQL, 4.2
- InsertPluginMap procedure, 22
- InsertRecordViewMap procedure, 22
- InsertRtDataUpdated procedure, 22
- InsertRtMDUpdated procedure, 22
- INSIDE
-
- SDO_INSIDE operator, 19
- topological relationship, 1.8
- installation, A
-
- Oracle Multimedia requirement for Locator, B
- INTEPRETATION (SDO_INTERPRETATION value), 2.2.4
- interaction
-
- ANYINTERACT, 1.8
- interior
-
- of an area, 1.8
- interior polygon rings, 2.2.4, 2.2.4, 2.7.2, 2.7.2
- interior solids, 2.2.4
- intersection, 24, 25
- intersections
-
- GC_INTERSECTION_<suffix> table, 11.5.3
- inverse flattening, 6.7.23, 6.8.6
- IS_GEOM_SEGMENT_DEFINED function, 25
- IS_MEASURE_DECREASING function, 25
- IS_MEASURE_INCREASING function, 25
- IS_SHAPE_PT_MEASURE function, 25
J
- Java application programming interface (API) for Spatial, 1.13
-
- WFS administration, 15.4, 16.4
- join
-
- SDO_JOIN operator, 19
L
- language attribute
-
- of route request, 13.2.2.2
- layer, 1.5.3
-
- transforming, 21
- validating with context, 24
- layer_gtype
-
- constraining data to a geometry type, 5.1.1
- length
-
- SDO_LENGTH function, 24
- line
-
- converting polygon to, 32
- data, 1.5.1
- length, 24
- line string
-
- boundary of, 1.8
- compound, 2.2.4, 2.7.3
- reversing, 32
- self-crossing, 1.4
- 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, 25
- tolerance values with LRS functions, 7.6
- loading spatial data, 4
- local coordinate systems, 6.3
- local coordinates, 1.5.4, 6.1.5
- LOCAL partitioning
-
- spatial indexes, 5.1.3
- LOCATE_PT function, 25
- location prospecting, 8.6
- Locator, B
- LRS
-
- See linear referencing system (LRS)
- LRS points, 7.1.9
- LRS_INTERSECTION function, 25
M
- MAKE_3D function, 21, 21
- MakeOpenLSClobRequest function, 27
- MakeOpenLSRequest function, 27
- map projections
-
- MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.8.7
- MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.8.7
- MAP_EPSG_SRID_TO_ORACLE function, 21
- MAP_ORACLE_SRID_TO_EPSG function, 21
- match codes, 11.1.3
- match modes, 11.1.2
- match vector (MatchVector attribute)
-
- geocoding, 11.1.5
- MBR
-
- See minimum bounding rectangle (MBR)
- MDDATA account and schema, 1.14
- MDSYS schema, 1.1
- MDSYS.CS_SRS table, 6.8.1
- MDSYS.SDO_ANGLE_UNITS table, 6.8.2
- MDSYS.SDO_AREA_UNITS view, 6.8.3
- MDSYS.SDO_CS package, 21
- 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, 23
- MDSYS.SDO_GEOM_PATH_INFO type, 16.2.2
- MDSYS.SDO_OLS package, 27
- MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.8.7
- MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.8.7
- MDSYS.SDO_SAM package, 29
- MDSYS.SDO_WFS_LOCK package, 33
- MDSYS.SDO_WFS_PROCESS package, 22, 34
- measure, 7.1.4
-
- populating, 7.1.6
- resetting, 25
- reversing, 25
- with multiline strings and polygons with holes, 7.1.11
- measure range, 7.1.7
- MEASURE_RANGE function, 25
- MEASURE_TO_PERCENTAGE function, 25
- messages
-
- Spatial error messages, 1.19
- methods
-
- SDO_GEOMETRY object type, 2.3
- migration
-
- See upgrading
- minimum bounding rectangle (MBR)
-
- AVERAGE_MBR procedure, 31
- EXTENT_OF function, 31
- geodetic, 6.2.3
- SDO_AGGR_MBR aggregate function, 20
- SDO_MAX_MBR_ORDINATE function, 24
- SDO_MBR function, 24
- SDO_MIN_MBR_ORDINATE function, 24
- mining
-
- See data mining
- MIX_INFO procedure, 31
- multiline string
-
- boundary of, 1.8
- LRS measure values, 7.1.11
- 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, 21
- converting to Spatial XML format, 21
- name conflicts
-
- avoiding with SQL Multimedia implementations, 3.3
- naming considerations
-
- Spatial table and column names, 2.8
- nearest neighbor
-
- SDO_NN operator, 19
- SDO_NN_DISTANCE operator, 19
- neighborhood influence, 8.3
- NLS_LENGTH_SEMANTICS parameter
-
- spatial queries on UTF8 data, 5.2
- NODE table
-
- routing engine use of, 13.3.2
- normal vector, 1.11.3
- NTv2 grids
-
- converting Spatial XML format to NTv2 format, 21
- converting to Spatial XML format, 21
O
- object types
-
- embedding SDO_GEOMETRY objects in, 9.1, 9.2.2
- OCG (Open Geospatial Consortium) simple features conformance, 1.16
- OCI (Oracle Call Interface) examples, 1.20
- ODM
-
- See Oracle Data Mining (ODM)
- offset, 7.1.5
-
- FIND_OFFSET function, 25
- OFFSET_GEOM_SEGMENT function, 25
- offsetting
-
- geometric segment, 7.5.7
- OGC_X and OGC_Y function names, 1.16
- ON
-
- SDO_ON operator, 19
- topological relationship, 1.8
- Open Geospatial Consortium (OCG) simple features conformance, 1.16
- OpenLS
-
- subprogram reference information, 27
- OPENLS_DIR_BUSINESS_CHAINS table, 12.3.2
- OPENLS_DIR_BUSINESSES table, 12.3.1
- OPENLS_DIR_CATEGORIES table, 12.3.3
- OPENLS_DIR_CATEGORIZATIONS table, 12.3.4
- OPENLS_DIR_CATEGORY_TYPES table, 12.3.5
- OPENLS_DIR_SYNONYMS table, 12.3.6
- operators
-
- cross-schema invocation, 5.2.3
- ORDERED optimizer hint with, 1.9
-
- SDO_FILTER, 19
- SDO_JOIN, 19
- overview, 1.9
- performance-related guidelines, 1.9
- SDO_ANYINTERACT, 19
- SDO_CONTAINS, 19
- SDO_COVEREDBY, 19
- SDO_COVERS, 19
- SDO_EQUAL, 19
- SDO_FILTER, 19
- SDO_INSIDE, 19
- SDO_JOIN, 19
- SDO_NN, 19
- SDO_NN_DISTANCE, 19
- SDO_ON, 19
- SDO_OVERLAPBDYDISJOINT, 19
- SDO_OVERLAPBDYINTERSECT, 19
- SDO_OVERLAPS, 19
- SDO_RELATE, 19
- SDO_TOUCH, 19
- SDO_WITHIN_DISTANCE, 19
- optimized box, 2.2.4
- optimized rectangle, 2.2.4
- optimizer hint (ORDERED) with spatial operators, 1.9
-
- SDO_FILTER, 19
- SDO_JOIN, 19
- Oracle Call Interface (OCI) examples, 1.20
- Oracle Data Mining (ODM)
-
- spatial analysis and mining information, 8
- Oracle Database 10g
-
- upgrading Spatial to, A
- Oracle Locator
-
- See Locator
- Oracle Multimedia
-
- proper installation required for Locator, B
- ORDERED optimizer hint with spatial operators, 1.9
-
- SDO_FILTER, 19
- SDO_JOIN, 19
- oriented point
-
- illustration and example, 2.7.6
- OVERLAPBDYDISJOINT
-
- SDO_OVERLAPBDYDISJOINT operator, 19
- topological relationship, 1.8
- OVERLAPBDYINTERSECT
-
- SDO_OVERLAPBDYINTERSECT operator, 19
- topological relationship, 1.8
- OVERLAPS
-
- SDO_OVERLAPS operator, 19
P
- parallel execution for index creation and rebuilding, 18, 18, 18
- PARTITION table
-
- routing engine use of, 13.3.3
- partitioned spatial indexes, 5.1.3
-
- exchanging partitions, 5.1.4
- PERCENTAGE_TO_MEASURE function, 25
- performance and tuning information, 1.15
-
- for Spatial operators, 1.9
- planar surfaces, 1.11.1
- PL/SQL and SQL examples, 1.20
- plugins
-
- registering for record type, 16.4.13
- point
-
- data, 1.5.1
- illustration and examples of point-only geometry, 2.7.5
- locating on geometric segment, 7.5.8
- LRS, 7.1.9
- on surface of polygon, 24
- oriented point, 2.7.6
- projection of onto geometric segment, 7.1.8, 7.5.9
- shape, 7.1.2
- point clouds
-
- clipping, 28
- converting to geometry, 28
- dropping dependencies, 28
- getting point IDs, 28
- initializing, 28
- modeling solids as, 1.11.2
- subprograms, 28
- point of interest (POI)
-
- GC_POI_<suffix> table, 11.5.4
- POINT_AT_BEARING function, 32
- policies
-
- RLS restriction relating to SDO_FILTER, 19
- polygon
-
- area of, 24
- boundary of, 1.8
- buffer, 24
- centroid, 24
- compound, 2.2.4
- exterior and interior rings, 2.2.4, 2.2.4, 2.7.2, 2.7.2
- point on surface, 24
- self-crossing not supported, 1.4
- self-intersecting polygons, 24
- with hole (LRS measure values), 7.1.11
- polygon collection, 2.7.2
- polygon data, 1.5.1
- POLYGONTOLINE function, 32
- PopulateFeatureTypeXMLInfo procedure, 34
- populating
-
- measure, 7.1.6
- pre_geocoded_location element, 13.2.2.4
- pre_geocoded_locations attribute
-
- of route request, 13.2.2.2
- PREPARE_FOR_TTS procedure, 32
- primary filter, 1.6, 5.2.1.1, 5.2.1.2
- primitive types, 1.4
- problems in current release, 6.10
- PROJECT_PT function, 25
- 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, 25
- proxy authentication
-
- identity propagation option, 17.1.1
- publishFeatureType method, 15.4.7
- PublishFeatureType procedure, 34
- publishRecordType method, 16.4.12
Q
- quality
-
- degradation of R-tree index, 31
- R-tree, 1.7.2
- QUALITY_DEGRADATION function, 31
- query, 5.2.1
- query model for Spatial, 1.6
- query window, 5.2.1
- querying geometric segments
-
- subprograms for, 25
R
- range
-
- measure, 7.1.7
- README file
-
- for Spatial, GeoRaster, and topology and network data models, 1.21
- rebuilding
-
- spatial indexes, 18
- record types
-
- dropping, 16.4.5
- getting ID, 16.4.9
- granting access to a user, 16.4.11
- publishing, 16.4.12
- registering plugin, 16.4.13
- revoking access from a user, 16.4.15
- setting capabilities information, 16.4.16
- record view map
-
- deleting, 16.4.3
- record view maps (setting), 16.4.18
- rectangle
-
- minimum bounding, 31
- type, 2.2.4
- rectification of geometries, 32
- RECTIFY_GEOMETRY function, 32
- REDEFINE_GEOM_SEGMENT procedure, 25
- redefining
-
- geometric segment, 7.5.2
- RegisterFeatureTable procedure, 33
- RegisterMTableView procedure, 34
- registerTypePluginMap method, 16.4.13
- RELATE function, 24
-
- See also SDO_RELATE operator
- release number (Spatial)
-
- retrieving, 1.17
- REMOVE_DUPLICATE_VERTICES function, 32
- replication
-
- multimaster, B
- object, B
- RESET_MEASURE procedure, 25
- restrictions in current release, 6.10
- return_detailed_geometry attribute
-
- of route request, 13.2.2.2
- return_driving_directions attribute
-
- of route request, 13.2.2.2
- return_hierarchical_driving_directions attribute
-
- of route request, 13.2.2.2
- return_route_edge_ids attribute
-
- of route request, 13.2.2.2, 13.2.2.2
- return_route_geometry attribute
-
- of batch route request, 13.2.5.2
- of route request, 13.2.2.2
- return_segment_geometry attribute
-
- of batch route request, 13.2.5.2
- of route request, 13.2.2.2
- reverse geocoding, 23
- REVERSE_GEOCODE function, 23
- REVERSE_GEOMETRY function, 25
- REVERSE_LINESTRING function, 32
- REVERSE_MEASURE function, 25
- REVOKE_PREFERENCE_FOR_OP procedure, 21
- revokeFeatureTypeFromUser method, 15.4.8
- RevokeFeatureTypeFromUser procedure, 34
- RevokeMDAccessFromUser procedure, 34
- revokeMDAccessToUser method, 15.4.9, 16.4.14
- revokeRecordTypeFromUser method, 16.4.15
- ring
-
- exterior and interior polygon, 2.2.4
- extracting from a geometry, 32, 32
- RLS
-
- restriction regarding fine-grained access control policies and SDO_FILTER, 19
- road segments
-
- GC_ROAD_SEGMENT_<suffix> table, 11.5.7
- road_preference attribute
-
- of batch route request, 13.2.5.2
- of route request, 13.2.2.2
- roads
-
- GC_ROAD_<suffix> table, 11.5.6
- rollback segment
-
- R-tree index creation, 5.1.7
- route geometry
-
- in route request, 13.2.2.2
- route requests, 13.2.2.1
-
- DTD, 13.2.2
- example, 13.2.1
-
- previously geocoded locations, 13.2.1
- input_location element, 13.2.2.3
- pre_geocoded_location element, 13.2.2.4
- route responses
-
- DTD, 13.2.3
- example, 13.2.1
-
- previously geocoded locations, 13.2.1
- route_preference attribute
-
- of route request, 13.2.2.2
- route_request element, 13.2.2.1
- routing engine
-
- configuring, 13.1
- data structures used by, 13.3
- deploying, 13.1
- overview, 13
- XML API, 13.2
- R-tree indexes
-
- description of indexing process, 1.7.1
- quality degradation, 31
- rebuilding, 18
- requirements before creating, 5.1.7
- sequence object, 2.9.3
- R-tree quality, 1.7.2
S
- scaling
-
- geometric segment, 7.5.6
- schemas
-
- creating index on table in another schema, 5.1.2
- invoking operators on table in another schema, 5.2.3
- SDO_ADDR_ARRAY data type, 11.2.2
- SDO_AGGR_CENTROID aggregate function, 20
- SDO_AGGR_CONCAT_LINES aggregate function, 20
- SDO_AGGR_CONVEXHULL aggregate function, 20
- SDO_AGGR_LRS_CONCAT aggregate function, 20
- SDO_AGGR_MBR aggregate function, 20
- SDO_AGGR_UNION aggregate function, 20
-
- complex examples, C.4
- SDO_ANGLE_UNITS table, 6.8.2
- SDO_ANYINTERACT operator, 19
- SDO_ARC_DENSIFY function, 24
- SDO_AREA function, 24
- SDO_AREA_UNITS view, 6.8.3
- SDO_BUFFER function, 24
- SDO_CENTROID function, 24
- SDO_CLOSEST_POINTS procedure, 24
- SDO_CONTAINS operator, 19
- SDO_CONVEXHULL function, 24
- 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, 19
- SDO_COVERS operator, 19
- 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, 21
-
- ADD_PREFERENCE_FOR_OP, 21
- CONVERT_NADCON_TO_XML, 21
- CONVERT_NTV2_TO_XML, 21
- CONVERT_XML_TO_NADCON, 21
- CONVERT_XML_TO_NTV2, 21
- CREATE_CONCATENATED_OP, 21
- CREATE_OBVIOUS_EPSG_RULES, 21
- CREATE_PREF_CONCATENATED_OP, 21
- DELETE_ALL_EPSG_RULES, 21
- DELETE_OP, 21
- DETERMINE_CHAIN, 21
- DETERMINE_DEFAULT_CHAIN, 21
- FIND_GEOG_CRS, 21
- FIND_PROJ_CRS, 21
- FROM_OGC_SIMPLEFEATURE_SRS, 21
- FROM_USNG, 21
- GET_EPSG_DATA_VERSION function, 21
- MAKE_3D, 21, 21
- MAP_EPSG_SRID_TO_ORACLE, 21
- MAP_ORACLE_SRID_TO_EPSG, 21
- REVOKE_PREFERENCE_FOR_OP, 21
- TO_OGC_SIMPLEFEATURE_SRS, 21
- TO_USNG, 21
- TRANSFORM, 21
- TRANSFORM_LAYER, 21
- UPDATE_WKTS_FOR_ALL_EPSG_CRS, 21
- UPDATE_WKTS_FOR_EPSG_CRS, 21
- UPDATE_WKTS_FOR_EPSG_DATUM, 21
- UPDATE_WKTS_FOR_EPSG_ELLIPS, 21
- UPDATE_WKTS_FOR_EPSG_OP, 21
- UPDATE_WKTS_FOR_EPSG_PARAM, 21
- UPDATE_WKTS_FOR_EPSG_PM, 21
- VALIDATE_WKT, 21
- VIEWPORT_TRANSFORM, 21
- SDO_CSW_PROCESS package
-
- DeleteCapabilitiesInfo, 22
- DeleteDomainInfo, 22
- DeletePluginMap, 22
- DeleteRecordViewMap, 22
- GetRecordTypeId, 22
- InsertCapabilitiesInfo, 22
- InsertDomainInfo, 22
- InsertPluginMap, 22
- InsertRecordViewMap, 22
- InsertRtDataUpdated, 22
- InsertRtMDUpdated, 22
- SDO_DATUM_ENGINEERING view, 6.7.19
- SDO_DATUM_GEODETIC view, 6.7.20
- SDO_DATUM_VERTICAL view, 6.7.21
- SDO_DATUMS table, 6.7.22
- SDO_DATUMS_OLD_FORMAT table, 6.8.4
- SDO_DATUMS_OLD_SNAPSHOT table, 6.8.4
- SDO_DIFFERENCE function, 24
- SDO_DIST_UNITS view, 6.8.5
- SDO_DISTANCE function, 24
- SDO_ELEM_INFO attribute, 2.2.4
- SDO_ELEM_INFO_ARRAY type, 2.2
- SDO_ELLIPSOIDS table, 6.7.23
- SDO_ELLIPSOIDS_OLD_FORMAT table, 6.8.6
- SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.8.6
- SDO_EQUAL operator, 19
- SDO_ETYPE value, 2.2.4, 2.2.4
- SDO_FILTER operator, 19
- SDO_GCDR package, 23
-
- GEOCODE, 23
- GEOCODE_ADDR, 23
- GEOCODE_ADDR_ALL, 23
- GEOCODE_ALL, 23
- GEOCODE_AS_GEOMETRY, 23
- REVERSE_GEOCODE, 23
- SDO_GEO_ADDR data type and constructors, 11.2.1
- SDO_GEOM package
-
- RELATE, 24
- SDO_ARC_DENSIFY, 24
- SDO_AREA, 24
- SDO_BUFFER, 24
- SDO_CENTROID, 24
- SDO_CLOSEST_POINTS, 24
- SDO_CONVEXHULL, 24
- SDO_DIFFERENCE, 24
- SDO_DISTANCE, 24
- SDO_INTERSECTION, 24
- SDO_LENGTH, 24
- SDO_MAX_MBR_ORDINATE, 24
- SDO_MBR, 24
- SDO_MIN_MBR_ORDINATE, 24
- SDO_POINTONSURFACE, 24
- SDO_UNION, 24
- SDO_VOLUME, 24
- SDO_XOR, 24
- VALIDATE_GEOMETRY_WITH_CONTEXT, 24
- VALIDATE_LAYER_WITH_CONTEXT, 24
- WITHIN_DISTANCE, 24
- SDO_GEOM_PATH_INFO
-
- MDSYS.SDO_GEOM_PATH_INFO type, 16.2.2
- SDO_GEOMETRY object type, 2.2
-
- constructors, 2.4
- embedding in user-defined type, 9.1, 9.2.2
- in function-based indexes, 9.2
- methods (member functions), 2.3
- SDO_GTYPE attribute, 2.2.1
-
- constraining data to a geometry type, 5.1.1
- 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.9.2
- SDO_INDX_DIMS keyword, 7.3, 18
- SDO_INSIDE operator, 19
- SDO_INTERPRETATION value, 2.2.4
- SDO_INTERSECTION function, 24
- SDO_JOIN operator, 19
- SDO_KEYWORDARRAY data type, 11.2.3
- SDO_LENGTH function, 24
- SDO_LRS package
-
- CLIP_GEOM_SEGMENT, 25
- CONCATENATE_GEOM_SEGMENTS, 25
- CONNECTED_GEOM_SEGMENTS, 25
- CONVERT_TO_LRS_DIM_ARRAY, 25
- CONVERT_TO_LRS_GEOM, 25
- CONVERT_TO_LRS_LAYER, 25
- CONVERT_TO_STD_DIM_ARRAY, 25
- CONVERT_TO_STD_GEOM, 25
- CONVERT_TO_STD_LAYER, 25
- DEFINE_GEOM_SEGMENT, 25
- DYNAMIC_SEGMENT, 25
- FIND_LRS_DIM_POS, 25
- FIND_MEASURE, 25
- FIND_OFFSET, 25
- GEOM_SEGMENT_END_MEASURE, 25
- GEOM_SEGMENT_END_PT, 25
- GEOM_SEGMENT_LENGTH, 25
- GEOM_SEGMENT_START_MEASURE, 25
- GEOM_SEGMENT_START_PT, 25
- GET_MEASURE, 25
- GET_NEXT_SHAPE_PT, 25
- GET_NEXT_SHAPE_PT_MEASURE, 25
- GET_PREV_SHAPE_PT, 25
- GET_PREV_SHAPE_PT_MEASURE, 25
- IS_GEOM_SEGMENT_DEFINED, 25
- IS_MEASURE_DECREASING, 25
- IS_MEASURE_INCREASING, 25
- IS_SHAPE_PT_MEASURE, 25
- LOCATE_PT, 25
- LRS_INTERSECTION, 25
- MEASURE_RANGE, 25
- MEASURE_TO_PERCENTAGE, 25
- OFFSET_GEOM_SEGMENT, 25
- PERCENTAGE_TO_MEASURE, 25
- PROJECT_PT, 25
- REDEFINE_GEOM_SEGMENT, 25
- RESET_MEASURE, 25
- REVERSE_GEOMETRY, 25
- REVERSE_MEASURE, 25
- SET_PT_MEASURE, 25
- SPLIT_GEOM_SEGMENT, 25
- TRANSLATE_MEASURE, 25
- VALID_GEOM_SEGMENT, 25
- VALID_LRS_PT, 25
- VALID_MEASURE, 25
- VALIDATE_LRS_GEOMETRY, 25
- SDO_MAX_MBR_ORDINATE function, 24
- SDO_MBR function, 24
- SDO_MIGRATE package
-
- TO_CURRENT, 26
- SDO_MIN_MBR_ORDINATE function, 24
- SDO_NN operator, 19
-
- complex examples, C.3
- optimizer hints, 19
- SDO_NN_DISTANCE ancillary operator, 19
- SDO_NN_DISTANCE operator
-
- complex examples, C.3
- SDO_OLS package, 27
-
- MakeOpenLSClobRequest, 27
- MakeOpenLSRequest, 27
- SDO_ON operator, 19
- SDO_ORDINATE_ARRAY type, 2.2
- SDO_ORDINATES attribute, 2.2.5
- SDO_OVERLAPBDYDISJOINT operator, 19
- SDO_OVERLAPBDYINTERSECT operator, 19
- SDO_OVERLAPS operator, 19
- SDO_PC object type, 2.6.1
- SDO_PC_BLK object type, 2.6.2
- SDO_PC_BLK_TYPE object type, 2.6.2
- SDO_PC_PKG package
-
- CLIP_PC, 28
- CREATE_PC, 28
- DROP_DEPENDENCIES, 28
- GET_PT_IDS, 28
- INIT, 28
- TO_GEOMETRY, 28
- SDO_POINT attribute, 2.2.3
- SDO_POINT_TYPE object type, 2.2
- SDO_POINTONSURFACE function, 24
- 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, 29, 29
- SDO_REGAGGRSET object type, 29, 29
- SDO_REGION object type, 29
- SDO_REGIONSET object type, 29
- SDO_RELATE operator, 19
- SDO_ROWIDPAIR object type, 19
- SDO_ROWIDSET data type, 19
- SDO_RTREE_SEQ_NAME sequence object, 2.9.3
- SDO_SAM package, 29
-
- AGGREGATES_FOR_GEOMETRY, 29
- AGGREGATES_FOR_LAYER, 29
- BIN_GEOMETRY, 29
- BIN_LAYER, 29
- COLOCATED_REFERENCE_FEATURES, 29
- SIMPLIFY_GEOMETRY, 29
- SIMPLIFY_LAYER, 29
- SPATIAL_CLUSTERS, 29
- TILED_AGGREGATES, 29
- TILED_BINS, 29
- SDO_SRID attribute, 2.2.2
- SDO_ST_TOLERANCE table, 3.2
- SDO_STARTING_OFFSET value, 2.2.4
- SDO_TFM_CHAIN type, 6.6
- SDO_TIN object type, 2.5.1
- SDO_TIN_BLK object type, 2.5.2
- SDO_TIN_BLK_TYPE object type, 2.5.2
- SDO_TIN_PKG package
-
- CLIP_TIN, 30
- CREATE_TIN, 30
- DROP_DEPENDENCIES, 30
- INIT, 30
- TO_GEOMETRY, 30
- SDO_TOUCH operator, 19
- SDO_TUNE package
-
- AVERAGE_MBR, 31
- ESTIMATE_RTREE_INDEX_SIZE, 31
- EXTENT_OF, 31
- MIX_INFO, 31
- QUALITY_DEGRADATION, 31
- SDO_UNION function, 24
- 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
-
- APPEND, 32
- APPEND_TO_COLLECTION, 32
- CIRCLE_POLYGON, 32
- CONCAT_LINES, 32
- CONVERT_UNIT, 32
- DROP_WORK_TABLES, 32
- ELLIPSE_POLYGON, 32
- EXTRACT, 32, 32
- EXTRUDE, 32
- FROM_GML311GEOMETRY, 32
- FROM_GMLGEOMETRY, 32
- FROM_WKBGEOMETRY, 32
- FROM_WKTGEOMETRY, 32
- GETNUMELEM, 32
- GETNUMVERTICES, 32
- GETVERTICES, 32
- INITIALIZE_INDEXES_FOR_TTS, 32
- POINT_AT_BEARING, 32
- POLYGONTOLINE, 32
- PREPARE_FOR_TTS, 32
- RECTIFY_GEOMETRY, 32
- REMOVE_DUPLICATE_VERTICES, 32
- REVERSE_LINESTRING, 32
- SIMPLIFY, 32
- TO_GML311GEOMETRY, 32
- TO_GMLGEOMETRY, 32
- TO_WKBGEOMETRY, 32
- TO_WKTGEOMETRY, 32
- VALIDATE_WKBGEOMETRY, 32
- VALIDATE_WKTGEOMETRY, 32
- SDO_VERSION function, 1.17
- SDO_VOLUME function, 24
- SDO_WFS_LOCK package, 33
-
- RegisterFeatureTable, 33
- UnRegisterFeatureTable, 33
- SDO_WFS_PROCESS package, 22, 34
-
- DropFeatureType, 34
- DropFeatureTypes, 34
- GenCollectionProcs, 34
- GetFeatureTypeId, 34
- GrantFeatureTypeToUser, 34
- GrantMDAccessToUser, 34
- InsertCapabilitiesInfo, 34
- InsertFtDataUpdated, 34
- InsertFtMDUpdated, 34
- PopulateFeatureTypeXMLInfo, 34
- PublishFeatureType, 34
- RegisterMTableView, 34
- RevokeFeatureTypeFromUser, 34
- RevokeMDAccessFromUser, 34
- UnRegisterMTableView, 34
- SDO_WITHIN_DISTANCE operator, 19
-
- complex examples, C.2
- SDO_XOR function, 24
- SDOAGGRTYPE object type, 1.10.1
- sea level
-
- gravity-related height, 6.5.2
- secondary filter, 1.6, 5.2.1.2
- segment geometry
-
- in route request, 13.2.2.2
- segments
-
- geometric, 7.1.1
- self-crossing line strings and polygons, 1.4
- self-intersecting polygons, 24
- self-joins
-
- optimizing, 19
- semi-major axis, 6.7.23, 6.8.6
- semi-minor axis, 6.7.23
- sequence object for R-tree index, 2.9.3
- SET_PT_MEASURE procedure, 25
- setCapabilitiesInfo method, 16.4.16
- setDomainInfo method, 16.4.17
- setRecordViewMap method, 16.4.18
- setXMLTableIndexInfo method, 15.4.10, 16.4.19
- shape point, 7.1.2
-
- determining if measure value is a shape point, 25
- getting measure of next, 25
- getting measure of previous, 25
- getting next, 25
- getting previous, 25
- SIGN_POST table
-
- routing engine use of, 13.3.4
- simple element, 2.2.4
- simple features (OGC)
-
- Oracle Spatial conformance, 1.16
- simplification of geometries, 32
- SIMPLIFY function, 32
- SIMPLIFY_GEOMETRY function, 29
- SIMPLIFY_LAYER procedure, 29
- single application user
-
- identity propagation option, 17.1.1
- size requirements (hardware) for spatial applications, 1.18
- solids
-
- exterior and interior, 2.2.4
- modeling of, 1.11.2
- SDO_ETYPE value, 2.2.4
- volume of, 24
- SORT_AREA_SIZE parameter
-
- R-tree index creation, 5.1.7
- sort_by_distance attribute
-
- of batch route request, 13.2.5.2
- spatial aggregate functions
-
- See aggregate functions
- spatial analysis and mining
-
- conceptual and usage information, 8
- function reference information, 29
- spatial binning, 8.2
-
- See also bins
- spatial clustering, 8.5
- spatial correlation, 8.3
- spatial data mining
-
- conceptual and usage information, 8
- function reference information, 29
- spatial data structures, 2
- spatial data types, 2
- spatial index
-
- See index
- spatial join, 5.2.2
-
- SDO_JOIN operator, 19
- spatial operators
-
- See operators
- spatial query, 5.2.1
- spatial reference systems
-
- conceptual and usage information, 6
- example, 6.12
- subprogram reference information, 21
- spatial routing engine
-
- See routing engine
- Spatial Web services
-
- client setup, 10.3
- demo files, 10.4
- identity propagation, 17.1.1
- introduction, 10
- user management, 17.1
- virtual private databases, 17.2.1
- SPATIAL_CLUSTERS function, 29
- SPATIAL_CSW_ADMIN_USR account and schema, 1.14
- SPATIAL_WFS_ADMIN_USR account and schema, 1.14
- spheroids
-
- MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table, 6.8.6
- MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.8.6
- SPLIT_GEOM_SEGMENT procedure, 25
- splitting
-
- geometric segment, 7.5.4
- SQL and PL/SQL examples, 1.20
- SQL Multimedia
-
- avoiding name conflicts, 3.3
- FROM_WKBGEOMETRY function, 32
- FROM_WKTGEOMETRY function, 32
- ST_GEOMETRY type, 3.1
- support in Spatial, 3
- TO_WKBGEOMETRY function, 32
- TO_WKTGEOMETRY function, 32
- tolerance value, 3.2
- VALIDATE_WKBGEOMETRY function, 32
- VALIDATE_WKTGEOMETRY function, 32
- SQL Multimedia standard
-
- ST_CoordDim method, 2.3
- ST_IsValid method, 2.3
- SQL statements
-
- for indexing spatial data, 18
- SQL*Loader, 4.1
- SRID
-
- 0 (zero) special case with SDO_CS.VIEWPORT_TRANSFORM function, 21
- in USER_SDO_GEOM_METADATA, 2.8.4
- mapping Oracle to EPSG, 21
- SDO_SRID attribute in SDO_GEOMETRY, 2.2.2
- ST_ANNOTATION_TEXT constructor, 3.4.1
- ST_CoordDim method, 2.3
- ST_GEOMETRY type, 3.1
- ST_IsValid method, 2.3
- start location for route, 13.2.2.1
- stop lines, 1.11.1
- subprograms
-
- coordinate system transformation, 21
- data mining, 29
- geocoding, 23
- geometry, 24
- linear referencing, 25
- OpenLS, 27
- point clouds, 28
- SDO_MIGRATE, 26
- spatial analysis, 29
- TINs, 30
- tuning, 31
- utility, 32
- WFS, 33
- WFS processing, 22, 34
- surface normal, 1.11.3
- surfaces, 2.2.4
-
- modeling of, 1.11.1
- planar, 1.11.1
- SDO_ETYPE value, 2.2.4
T
- table names
-
- restrictions on spatial table names, 2.8.1
- TABLE_NAME (in USER_SDO_GEOM_METADATA), 2.8.1
- TFM_PLAN object type, 6.6
- three-dimensional (3D)
-
- formats of LRS functions, 7.4
-
- not supported with geodetic data, 6.10.2
- spatial objects, 1.11
-
- solids, 1.11.2
- surfaces, 1.11.1
- TILED_AGGREGATES function, 29
- TILED_BINS function, 29
- time_unit attribute
-
- of route request, 13.2.2.2
- TINS
-
- subprograms, 30
- TINs
-
- clipping, 30
- converting to geometry, 30
- creating, 28, 30
- dropping dependencies, 30
- initializing, 30
- TINs (triangulated irregular networks), 1.11.1
- TO_81X procedure
-
- use TO_CURRENT instead, 26
- TO_CURRENT procedure and function, 26
- TO_GEOMETRY procedure, 28, 30
- TO_GML311GEOMETRY function, 32
- TO_GMLGEOMETRY function, 32
- TO_OGC_SIMPLEFEATURE_SRS function, 21
- TO_USNG function, 21
- TO_WKBGEOMETRY function, 32
- TO_WKTGEOMETRY function, 32
- tolerance, 1.5.5
-
- for SQL Multimedia types, 3.2
- with LRS functions, 7.6
- TOUCH
-
- SDO_TOUCH operator, 19
- topological relationship, 1.8
- transactional insertion of spatial data, 4.2
- TRANSFORM function, 21
- TRANSFORM_LAYER procedure, 21
-
- table for transformed layer, 21
- transformation, 6.1.7
-
- arcs and circles not supported, 6.2.4
- TRANSLATE_MEASURE function, 25
- transportable tablespaces
-
- initializing spatial indexes, 32
- preparing for when using spatial indexes, 32
- triangulated irregular networks (TINs), 1.11.1
- tuning and performance information, 1.15
-
- for spatial operators, 1.9
- tuning subprograms, 31
- two-tier query model, 1.6
- type zero (0) element, 2.7.7
U
- unformatted addresses, 11.1.1
- union, 24
- unit of measurement
-
- MDSYS tables, 2.10
- 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
- unknown CRS coordinate reference system, 6.10.4
- UnRegisterFeatureTable procedure, 33
- UnRegisterMTableView procedure, 34
- UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure, 21
- UPDATE_WKTS_FOR_EPSG_CRS procedure, 21
- UPDATE_WKTS_FOR_EPSG_DATUM procedure, 21
- UPDATE_WKTS_FOR_EPSG_ELLIPS procedure, 21
- UPDATE_WKTS_FOR_EPSG_OP procedure, 21
- UPDATE_WKTS_FOR_EPSG_PARAM procedure, 21
- UPDATE_WKTS_FOR_EPSG_PM procedure, 21
- upgrading
-
- data to current Spatial release, 26
- GeoRaster, A.1
- Spatial to current Oracle Database release, A
- upgrading spatial data to current release, 26
- U.S. National Grid
-
- SDO_CS.FROM_USNG function, 21
- SDO_CS.TO_USNG function, 21
- support in Oracle Spatial, 6.11
- use cases
-
- for coordinate system transformation, 6.4
- USER_ANNOTATION_TEXT_METADATA view, 3.4.2
- USER_SDO_GEOM_METADATA view, 2.8
- USER_SDO_INDEX_INFO view, 2.9.1.1
- USER_SDO_INDEX_METADATA view, 2.9.1.2
- user-defined coordinate reference system, 6.9
- user-defined data types
-
- embedding SDO_GEOMETRY objects in, 9.1, 9.2.2
- UTF8 character set
-
- NLS_LENGTH_SEMANTICS setting for spatial queries, 5.2
- utility subprograms, 32
V
- VALID_GEOM_SEGMENT function, 25
- VALID_LRS_PT function, 25
- VALID_MEASURE function, 25
- VALIDATE_GEOMETRY_WITH_CONTEXT function, 24
- VALIDATE_LAYER_WITH_CONTEXT procedure, 24
- VALIDATE_LRS_GEOMETRY function, 25
- VALIDATE_WKBGEOMETRY function, 32
- VALIDATE_WKT function, 21
- VALIDATE_WKTGEOMETRY function, 32
- validation of geometries
-
- general and two-dimensional checks, 24
- three-dimensional checks, 1.11.3
- vendor attribute
-
- of route request, 13.2.2.2
- version number (Spatial)
-
- retrieving, 1.17
- versioning (CSW)
-
- disabling, 16.4.4
- enabling, 16.4.7
- VERTEX_SET_TYPE data type, 32
- VERTEX_TYPE object type, 32
- vertices
-
- maximum number in SDO_GEOMETRY object, 2.2
- removing duplicate, 32
- returning geometry coordinates as, 32
- VIEWPORT_TRANSFORM function, 21
- views
-
- ALL_ANNOTATION_TEXT_METADATA, 3.4.2
- ALL_SDO_GEOM_METADATA, 2.8
- ALL_SDO_INDEX_INFO, 2.9.1.1
- ALL_SDO_INDEX_METADATA, 2.9.1.2
- USER_ANNOTATION_TEXT_METADATA, 3.4.2
- USER_SDO_GEOM_METADATA, 2.8
- USER_SDO_INDEX_INFO, 2.9.1.1
- USER_SDO_INDEX_METADATA, 2.9.1.2
- virtual private databases
-
- Spatial Web services security, 17.2.1
- volume, 24
- VPDs
-
- Spatial Web services security, 17.2.1
W
- Web services
-
- client setup, 10.3
- demo files, 10.4
- introduction, 10
- well-known binary (WKB)
-
- See WKB
- well-known text (WKT)
-
- See WKT
- WFS
-
- Java API, 15.4, 16.4
- subprogram reference information, 33
- WFS processing
-
- subprogram reference information, 22, 34
- WFSAdmin Java class, 15.4, 16.4
- WITHIN_DISTANCE function, 24
-
- See also SDO_WITHIN_DISTANCE operator
- WKB
-
- FROM_WKBGEOMETRY function, 32
- Get_WKB method, 2.3
- TO_WKBGEOMETRY function, 32
- VALIDATE_WKBGEOMETRY function, 32
- WKT, 6.8.1.1
-
- FROM_WKTGEOMETRY function, 32
- Get_WKT method, 2.3
- procedures for updating, 6.8.1.3
- TO_WKTGEOMETRY function, 32
- UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure, 21
- UPDATE_WKTS_FOR_EPSG_CRS procedure, 21
- UPDATE_WKTS_FOR_EPSG_DATUM procedure, 21
- UPDATE_WKTS_FOR_EPSG_ELLIPS procedure, 21
- UPDATE_WKTS_FOR_EPSG_OP procedure, 21
- UPDATE_WKTS_FOR_EPSG_PARAM procedure, 21
- UPDATE_WKTS_FOR_EPSG_PM procedure, 21
- VALIDATE_WKTGEOMETRY function, 32
- validating (given SRID), 21
- WKTEXT column of MDSYS.CS_SRS table, 6.8.1.1
-
- procedures for updating value, 6.8.1.3
- Workspace Manager
-
- executing SOAP request in workspace, 17.2.2
- wsclient.jar file, 10.4
X
- XML API
-
- routing engine, 13.2
- XML table index
-
- setting information for a feature type, 15.4.10
- setting information for record type, 16.4.19
- XMLTABLEINDEX index
-
- checking for existence, 15.4.4, 16.4.8
- creating on feature table, 15.4.1, 16.4.1
- deleting on feature table, 15.4.3, 16.4.6
- XOR
-
- SDO_XOR function, 24
Y
- Yellow Pages
-
- See business directory (YP)
- YP
-
- See business directory (YP)
Z
- zero
-
- SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 21
- type 0 element, 2.7.7