Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
Symbols
- _3D
-
formats of LRS functions, 6-9
Numerics
- 0
-
SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 14-8
-
type 0 (zero) element, 2-21
- 3D
-
formats of LRS functions, 6-9
- 9i
-
changes to this guide for Oracle9i, xxi
-
migrating to Oracle9i, 16-11
A
- aggregate functions
-
description, 1-23
-
SDO_AGGR_CENTROID, 13-2
-
SDO_AGGR_CONVEXHULL, 13-4
-
SDO_AGGR_LRS_CONCAT, 13-5
-
SDO_AGGR_MBR, 13-7
-
SDO_AGGR_UNION, 13-8
-
SDOAGGRTYPE object type, 1-24
- ALL_SDO_GEOM_METADATA view, 2-24
- ALL_SDO_INDEX_INFO view, 2-27
- ALL_SDO_INDEX_METADATA view, 2-27
- ALTER INDEX statement, 9-2
-
REBUILD clause, 9-5
-
RENAME TO clause, 9-8
- ANALYZE_RTREE procedure, 17-3
- angle units, 5-10
- ANYINTERACT mask relationship, 12-5
- arc
-
densifying, 12-7
-
not supported with geodetic data, 5-4
- area, 12-10
- authalic sphere, 5-2
- average minimum bounding rectangle, 17-5
- AVERAGE_MBR procedure, 17-5
B
- batch geocoding, 7-4
- bounding rectangle
-
minimum, 17-17
- buffer area, 12-12
- bulk loading of spatial data, 3-1
C
- C language
-
examples (using OCI), 1-26
- Cartesian coordinates, 1-6, 5-1
- center of gravity (centroid), 12-16
- centroid
-
SDO_AGGR_CENTROID aggregate function, 13-2
-
SDO_CENTROID function, 12-16
- changes and new features for Oracle9i, xxi
- circle
-
not supported with geodetic data, 5-4
-
type, 2-12
- CLIP_GEOM_SEGMENT function, 15-5
- clipping a geometric segment, 6-12
- COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2-25
- compatibility mode
-
changing to, A-3
- compound element, 2-10
- compound line string, 2-13, 2-18
- compound polygon, 2-13
- CONCATENATE_GEOM_SEGMENTS function, 15-7
- concatenating geometric segments, 6-13
-
aggregate concatenation, 6-15, 13-5
- CONNECTED_GEOM_SEGMENTS function, 15-10
- consistency
-
checking for valid geometry types, 12-45
- constraining data to a geometry type, 4-6
- CONTAINS mask relationship, 12-5
- CONVERSION_FACTOR column
-
in SDO_ANGLE_UNITS table, 5-10
-
in SDO_AREA_UNITS table, 2-32
-
in SDO_DIST_UNITS table, 2-32
- CONVERSION_FACTOR column in SDO_DIST_UNITS table, 5-11
- CONVERT_TO_LRS_DIM_ARRAY function, 15-12
- CONVERT_TO_LRS_GEOM function, 15-15
- CONVERT_TO_LRS_LAYER function, 15-18
- CONVERT_TO_STD_DIM_ARRAY function, 15-21
- CONVERT_TO_STD_GEOM function, 15-23
- CONVERT_TO_STD_LAYER function, 15-25
- converting
-
geometric segments
- functions for, 15-3
- overview, 6-19
- convex hull
-
SDO_AGGR_CONVEXHULL aggregate function, 13-4
-
SDO_CONVEXHULL function, 12-18
- coordinate systems
-
conceptual and usage information, 5-1
-
example, 5-15
-
function reference information, 14-1
-
local, 5-5
-
user-defined, 5-13
- coordinates
-
Cartesian, 1-6, 5-1
-
geodetic, 1-6, 5-2, 5-3
-
geographic, 1-6, 5-2
-
local, 5-2
-
projected, 1-7, 5-2
- COVEREDBY mask relationship, 12-5
- COVERS mask relationship, 12-5
- CREATE INDEX statement, 9-9
- creating
-
geometric segments
- functions for, 15-1
- CS_SRS table, 5-6
- current release
-
migrating to, 16-11
D
- data model, 1-5
-
LRS, 6-7
- datum
-
geodetic, 1-6, 5-2
-
MDSYS.SDO_DATUMS table, 5-11
-
transformation, 5-2
- DBA_SDO_GEOM_METADATA view, 2-24
- DBA_SDO_INDEX_INFO view, 2-27
- DBA_SDO_INDEX_METADATA view, 2-27
- DEFINE_GEOM_SEGMENT function, 15-27
- defining a gemoetric segment, 6-10
- densification of arcs, 12-7
- difference, 12-20
- dimension (in SDO_GTYPE), 2-6, 2-7
-
GET_DIMS method, 10-2
-
GET_LRS_DIM method, 10-4
- DIMINFO (in USER_SDO_GEOM_METADATA), 2-25
- direction of geometric segment, 6-3
-
concatenation result, 6-14
- DISJOINT mask relationship, 12-5
- distance
-
SDO_NN_DISTANCE ancillary operator, 11-11
-
WITHIN_DISTANCE function, 12-51
- distance units, 5-10
- DROP INDEX statement, 9-15
- dynamic query window, 4-12
- DYNAMIC_SEGMENT function, 15-30
E
- editing
-
geometric segments
- functions for, 15-1
- ELEM_INFO (SDO_ELEM_INFO), 2-9
- element, 1-5
- ellipsoids, 5-12
- embedded SDO_GEOMETRY object in user-defined type, 8-1
- enabling third-party geocoders, 7-11
- EQUAL mask relationship, 12-5
- error messages, xxiii
- ESTIMATE_INDEX_PERFORMANCE function, 17-7
- ESTIMATE_TILING_LEVEL function, 17-10
- ESTIMATE_TILING_TIME function, 17-12
- ESTIMATE_TOTAL_NUMTILES function, 17-14
- ETYPE (SDO_ETYPE), 2-9
- examples
-
C, 1-26
-
coordinate systems, 5-15
-
creating, indexing, and querying spatial data, 2-1
-
directory, 1-26
-
Linear Referencing System (LRS), 6-20
-
OCI (Oracle Call Interface), 1-26
-
PL/SQL, 1-26
-
SQL, 1-26
- EXTENT_OF function, 17-17
- exterior polygon rings, 2-7, 2-9, 2-10, 2-15, 2-17
F
- features
-
linear, 6-6
- FIND_LRS_DIM_POS function, 15-32
- FIND_MEASURE function, 15-33
- fixed indexing, 1-16
- fixed-size tiles, 4-3
- FROM_815_TO_81x procedure, 16-2
- function-based index
-
with SDO_GEOMETRY objects, 8-3
- function-based indexes
-
privilege and session requirements, 8-4
- functions and procedures
-
ANALYZE_RTREE, 17-3
-
AVERAGE_MBR, 17-5
-
CLIP_GEOM_SEGMENT, 15-5
-
CONCATENATE_GEOM_SEGMENTS, 15-7
-
CONNECTED_GEOM_SEGMENTS, 15-10
-
CONVERT_TO_LRS_DIM_ARRAY, 15-12
-
CONVERT_TO_LRS_GEOM, 15-15
-
CONVERT_TO_LRS_LAYER, 15-18
-
CONVERT_TO_STD_DIM_ARRAY, 15-21
-
CONVERT_TO_STD_GEOM, 15-23
-
CONVERT_TO_STD_LAYER, 15-25
-
DEFINE_GEOM_SEGMENT, 15-27
-
DYNAMIC_SEGMENT, 15-30
-
ESTIMATE_INDEX_PERFORMANCE, 17-7
-
ESTIMATE_TILING_LEVEL, 17-10
-
ESTIMATE_TILING_TIME, 17-12
-
ESTIMATE_TOTAL_NUMTILES, 17-14
-
EXTENT_OF, 17-17
-
FIND_LRS_DIM_POS, 15-32
-
FIND_MEASURE, 15-33
-
FROM_815_TO_81x, 16-2
-
GEOM_SEGMENT_END_MEASURE, 15-45
-
GEOM_SEGMENT_END_PT, 15-37
-
GEOM_SEGMENT_LENGTH, 15-39
-
GEOM_SEGMENT_START_MEASURE, 15-41
-
GEOM_SEGMENT_START_PT, 15-43
-
GET_MEASURE, 15-45
-
HISTOGRAM_ANALYSIS, 17-19
-
IS_GEOM_SEGMENT_DEFINED, 15-47
-
IS_MEASURE_DECREASING, 15-49
-
IS_MEASURE_INCREASING, 15-51
-
LOCATE_PT, 15-53
-
MEASURE_RANGE, 15-55
-
MEASURE_TO_PERCENTAGE, 15-57
-
MIX_INFO, 17-21
-
not supported with geodetic data, 5-15
-
OFFSET_GEOM_SEGMENT, 15-59
-
OGIS_METADATA_FROM, 16-4
-
OGIS_METADATA_TO, 16-5
-
PERCENTAGE_TO_MEASURE, 15-63
-
PROJECT_PT, 15-65
-
QUALITY_DEGRADATION, 17-23
-
REDEFINE_GEOM_SEGMENT, 15-67
-
RELATE, 12-4
-
RESET_MEASURE, 15-70
-
REVERSE_GEOMETRY, 15-72
-
REVERSE_MEASURE, 15-74
-
RTREE_QUALITY, 17-25
-
SCALE_GEOM_SEGMENT, 15-76
-
SDO_AGGR_CENTROID, 13-2
-
SDO_AGGR_CONVEXHULL, 13-4
-
SDO_ARC_DENSIFY, 12-7
-
SDO_AREA, 12-10
-
SDO_BUFFER, 12-12
-
SDO_CENTROID, 12-16
-
SDO_CONVEXHULL, 12-18
-
SDO_DIFFERENCE, 12-20
-
SDO_DISTANCE, 12-23
-
SDO_INTERSECTION, 12-25
-
SDO_LENGTH, 12-28
-
SDO_MAX_MBR_ORDINATE, 12-31
-
SDO_MBR, 12-33
-
SDO_MIN_MBR_ORDINATE, 12-35
-
SDO_POINTONSURFACE, 12-37
-
SDO_UNION, 12-39
-
SDO_XOR, 12-42
-
SET_PT_MEASURE, 15-79
-
SPLIT_GEOM_SEGMENT, 15-82
-
supported by approximations with geodetic data, 5-15
-
TO_734, 16-6
-
TO_81x, 16-8
-
TO_CURRENT, 16-11
-
TRANSFORM, 14-2
-
TRANSFORM_LAYER, 14-5
-
TRANSLATE_MEASURE, 15-85
-
VALID_GEOM_SEGMENT, 15-87
-
VALID_LRS_POINT, 15-89
-
VALID_MEASURE, 15-91
-
VALIDATE_GEOMETRY, 12-45
-
VALIDATE_LAYER, 12-48
-
VALIDATE_LRS_GEOMETRY, 15-93
-
VIEWPORT_TRANSFORM, 14-7
-
WITHIN_DISTANCE, 12-51
G
- generic geocoding interface, 7-1
- GEOCODE_SCHEMA_PROPERTY_TYPE, 7-5
- GEOCODE_SERVER_PROPERTY_TYPE, 7-4
- GEOCODE_TABLE_COLUMN_TYPE, 7-5
- GEOCODE_TASK_METADATA, 7-4
- geocoder metadata, 7-3
- GEOCODER_HTTP package, 7-10
- geocoding
-
generic interface, 7-1
- geodetic coordinates, 1-6, 5-2
-
arcs and circles not supported, 5-4
-
functions not supported, 5-15
-
functions supported by approximations, 5-15
-
support for, 5-3
- geodetic datum, 1-6, 5-2
- geographic coordinates, 1-6, 5-2
- GEOM_SEGMENT_END_MEASURE function, 15-45
- GEOM_SEGMENT_END_PT function, 15-37
- GEOM_SEGMENT_LENGTH function, 15-39
- GEOM_SEGMENT_START_MEASURE function, 15-41
- GEOM_SEGMENT_START_PT function, 15-43
- geometric segment
-
clipping, 6-12
-
concatenating, 6-13
- aggregate, 6-15, 13-5
-
converting (functions for), 15-3
-
converting (overview), 6-19
-
creating (functions for), 15-1
-
defining, 6-10
-
definition of, 6-2
-
direction, 6-3
-
direction with concatenation, 6-14
-
editing (functions for), 15-1
-
locating point on, 6-17
-
offsetting, 6-16
-
projecting point onto, 6-18
-
querying (functions for), 15-2
-
redefining, 6-11
-
scaling, 6-15
-
splitting, 6-13
- geometry type
-
constraining data to, 4-6
-
GET_DIMS method, 10-3
-
SDO_GTYPE, 2-6
- geometry types, 1-3
- GET_DIMS method, 10-2
- GET_GTYPE method, 10-3
- GET_LRS_DIM method, 10-4
- GET_MEASURE function, 15-45
- GTYPE (SDO_GTYPE), 2-6
-
constraining data to a geometry type, 4-6
H
- HISTOGRAM_ANALYSIS procedure, 17-19
- hybrid indexing, B-1
I
- index
-
creation, 4-1
-
creation (cross-schema), 4-7
-
description of Spatial indexing, 1-11
-
hybrid, B-1
-
partitioned, 4-7
-
performance, 17-7
-
quadtree, 1-14
-
R-tree, 1-12
-
R-tree (requirements before creating), 4-2
- inserting spatial data
-
PL/SQL, 3-4
- INSIDE mask relationship, 12-6
- installation procedure for Spatial, A-2
- INTEPRETATION (SDO_INTERPRETATION), 2-10
- interaction
-
ANYINTERACT, 12-5
- interior polygon rings, 2-7, 2-9, 2-10, 2-15, 2-17
- interMedia Locator
-
See Locator
- intersection, 12-25
- inverse flattening, 5-12
- IS_GEOM_SEGMENT_DEFINED function, 15-47
- IS_MEASURE_DECREASING function, 15-49
- IS_MEASURE_INCREASING function, 15-51
J
- Java Virtual Machine (JVM)
-
platform for geocoding, 7-2
L
- layer, 1-5
-
transforming, 14-5
-
validating, 12-48
- layer_gtype
-
constraining data to a geometry type, 4-6
- length
-
SDO_LENGTH function, 12-28
- line
-
data, 1-5
-
length, 12-28
- line string
-
compound, 2-13, 2-18
-
self-crossing, 1-4
- linear features, 6-6
- linear measure, 6-3
- Linear Referencing System (LRS)
-
3D formats of functions, 6-9
-
conceptual and usage information, 6-1
-
data model, 6-7
-
example, 6-20
-
function reference information, 15-1
-
GET_LRS_DIM method, 10-4
-
limiting indexing to X and Y dimensions, 6-8
-
LRS point, 6-6
-
segments, 6-2
- loading spatial data, 3-1
- local coordinate systems, 5-5
- local coordinates, 5-2
- LOCAL partitioning
-
spatial index, 4-7
- LOCATE_PT function, 15-53
- Locator, C-1
- LRS
-
See Linear Referencing System (LRS)
- LRS point, 6-6
M
- map projections, 5-12
- MBR
-
SDO_MAX_MBR_ORDINATE function, 12-31
-
SDO_MBR function, 12-33
-
SDO_MIN_MBR_ORDINATE function, 12-35
- MDSYS schema, 1-1
- MDSYS user
-
created during default installation, A-2
-
protecting against unauthorized use, A-2
- MDSYS.CS_SRS table, 5-6
- MDSYS.SDO_ANGLE_UNITS table, 5-10
- MDSYS.SDO_CS package, 14-1
- MDSYS.SDO_DATUMS table, 5-11
- MDSYS.SDO_DIST_UNITS table, 5-10
- MDSYS.SDO_ELLIPSOIDS table, 5-12
- MDSYS.SDO_PROJECTIONS table, 5-12
- measure, 6-3
-
populating, 6-4
-
resetting, 15-70
-
reversing, 15-74
- measure range, 6-6
- MEASURE_RANGE function, 15-55
- MEASURE_TO_PERCENTAGE function, 15-57
- metadata for geocoding, 7-3
- migration
-
OGIS, 16-4, 16-5
-
to current Spatial release, 16-11
-
to release 7.3.4, 16-6
- minimum bounding rectangle
-
AVERAGE_MBR procedure, 17-5
-
EXTENT_OF function, 17-17
-
SDO_MAX_MBR_ORDINATE function, 12-31
-
SDO_MBR function, 12-33
-
SDO_MIN_MBR_ORDINATE function, 12-35
- MIX_INFO procedure, 17-21
- multimatch table, 7-9
- multiple matches, 7-9
- multipolygon, 2-17
N
- nearest neighbor
-
SDO_NN operator, 11-6
- new features for Oracle9i, xxi
O
- object types
-
embedding SDO_GEOMETRY objects in, 8-1, 8-6
- object-relational model
-
schema, 2-1
- OCI (Oracle Call Interface) examples, 1-26
- offset, 6-3
- OFFSET_GEOM_SEGMENT function, 15-59
- offsetting a geometric segment, 6-16
- OGIS_METADATA_FROM procedure, 16-4
- OGIS_METADATA_TO procedure, 16-5
- operators
-
cross-schema invocation, 4-18
-
SDO_FILTER, 11-2
-
SDO_NN, 11-6
-
SDO_NN_DISTANCE, 11-11
-
SDO_RELATE, 11-13
-
SDO_WITHIN_DISTANCE, 11-18
- optimized rectangle, 2-12
- Oracle Call Interface (OCI) examples, 1-26
- Oracle Technology Network (OTN), xxiii
- oracle.spatial.geocoder.Metadata, 7-9
- OVERLAPBDYDISJOINT mask relationship, 12-6
- OVERLAPBDYINTERSECT mask relationship, 12-6
P
- partitioned spatial index, 4-7
- PERCENTAGE_TO_MEASURE function, 15-63
- performance and tuning information, 1-25
- PL/SQL and SQL examples, 1-26
- point
-
data, 1-5
-
locating on geometric segment, 6-17
-
LRS, 6-6
-
on surface of polygon, 12-37
-
shape, 6-2
- polygon
-
area of, 12-10
-
centroid, 12-16
-
compound, 2-13
-
exterior and interior rings, 2-7, 2-9, 2-10, 2-15, 2-17
-
point on surface, 12-37
-
self-crossing not supported, 1-4
- polygon collection, 2-17
- polygon data, 1-5
- populating
-
measure, 6-4
- primitive types, 1-3
- problems in current release, 5-14
-
geodetic data, 5-4
- procedures
-
See functions and procedures
- PROJECT_PT function, 15-65
- projected coordinates, 1-7, 5-2
- projection, 6-6
-
point onto geometric segment, 6-18
-
PROJECT_PT function, 15-65
- projections, 5-12
Q
- quadtree indexes, 1-14
- quality
-
degradation of R-tree index, 17-23
-
R-tree, 1-13
- QUALITY_DEGRADATION function, 17-23
- query, 1-9
- QUERY REWRITE
-
privilege and session requirements, 8-4
- query window, 4-11
- querying geometric segments
-
functions for, 15-2
R
- range
-
measure, 6-6
- rectangle
-
minimum bounding, 17-17
-
type, 2-12
- REDEFINE_GEOM_SEGMENT procedure, 15-67
- redefining a gemoetric segment, 6-11
- rejected records, 7-9
- RELATE function, 12-4
- release 9i
-
changes to this guide for Oracle9i, xxi
-
migrating to Oracle9i, 16-11
- release number (Spatial)
-
retrieving, 1-26
- RESET_MEASURE procedure, 15-70
- restrictions in current release, 5-14
-
geodetic data, 5-4
- REVERSE_GEOMETRY function, 15-72
- REVERSE_MEASURE function, 15-74
- rollback segment
-
R-tree index creation, 4-2
- R-tree indexes, 1-12
-
analyzing quality, 17-3
-
before creating, 4-2
-
quality degradation, 17-23
-
quality score, 17-25
-
sequence object, 2-31
- R-tree quality, 1-13
- RTREE_QUALITY function, 17-25
S
- SCALE_GEOM_SEGMENT function, 15-76
- scaling a geometric segment, 6-15
- schema
-
creating index on table in another schema, 4-7
-
invoking operators on table in another schema, 4-18
-
object-relational model, 2-1
- SDO_AGGR_CENTROID aggregate function, 13-2
- SDO_AGGR_CONVEXHULL aggregate function, 13-4
- SDO_AGGR_LRS_CONCAT aggregate function, 13-5
- SDO_AGGR_MBR aggregate function, 13-7
- SDO_AGGR_UNION aggregate function, 13-8
- SDO_ANGLE_UNITS table, 5-10
- SDO_ARC_DENSIFY function, 12-7
- SDO_AREA function, 12-10
- SDO_AREA_UNITS table, 2-32
- SDO_BUFFER function, 12-12
- SDO_CENTROID function, 12-16
- SDO_CODE, 2-30
- SDO_CONVEXHULL function, 12-18
- SDO_CS package, 14-1
- SDO_DATUMS table, 5-11
- SDO_DIFFERENCE function, 12-20
- SDO_DIST_UNITS table, 2-31, 5-10
- SDO_DISTANCE function, 12-23
- SDO_ELEM_INFO, 2-9
- SDO_ELLIPSOIDS table, 5-12
- SDO_ETYPE, 2-9
- SDO_FILTER operator, 11-2
- SDO_GEOMETRY object type, 2-6
-
embedding in user-defined type, 8-1, 8-6
-
in function-based indexes, 8-3
-
methods, 10-1, 13-1
- SDO_GROUPCODE, 2-30
- SDO_GTYPE, 2-6
-
constraining data to a geometry type, 4-6
-
GET_DIMS method, 10-2
-
GET_GTYPE method, 10-3
-
GET_LRS_DIM method, 10-4
- SDO_INDEX_TABLE, 2-30
- SDO_INDX_DIMS keyword, 6-8
- SDO_INTERPRETATION, 2-10
- SDO_INTERSECTION function, 12-25
- SDO_LENGTH function, 12-28
- SDO_LEVEL, 1-15
- SDO_MAX_MBR_ORDINATE function, 12-31
- SDO_MBR function, 12-33
- SDO_MIN_MBR_ORDINATE function, 12-35
- SDO_NN operator, 11-6
-
optimizer hint, 11-9
- SDO_NN_DISTANCE ancillary operator, 11-11
- SDO_NUMTILES, 1-15
- SDO_ORDINATES, 2-13
- SDO_POINT, 2-8
- SDO_POINTONSURFACE function, 12-37
- SDO_POLY_xxx functions (deprecated and removed), 12-3
- SDO_PROJECTIONS table, 5-12
- SDO_RELATE operator, 11-13
- SDO_ROWID, 2-30
- SDO_RTREE_SEQ_NAME, 2-31
- SDO_SRID, 2-8
- SDO_STARTING_OFFSET, 2-9
- SDO_STATUS, 2-30
- SDO_UNION function, 12-39
- SDO_UNIT column
-
in SDO_AREA_UNITS table, 2-32
-
in SDO_DIST_UNITS table, 2-32, 5-10
- SDO_VERSION function, 1-26
- SDO_WITHIN_DISTANCE operator, 11-18
- SDO_XOR function, 12-42
- SDOAGGRTYPE object type, 1-24
- segments
-
geometric, 6-2
- self-crossing line strings and polygons, 1-4
- semi-major axis, 5-12
- sequence object for R-tree index, 2-31
- SET_PT_MEASURE procedure, 15-79
- shape point, 6-2
- simple element, 2-9
- SORT_AREA_SIZE parameter
-
R-tree index creation, 4-2
- spatial aggregate functions
-
See aggregate functions
- spatial data structures
-
object-relational model, 2-1
- spatial index
-
See index
- Spatial Index Advisor
-
using to determine best tiling level, 4-6
- spatial indexing
-
fixed, 1-16
- spatial join, 4-18
- spatial query, 4-11
- spatial reference systems
-
conceptual and usage information, 5-1
-
example, 5-15
-
function reference information, 14-1
- sphere
-
authalic, 5-2
- spheroids (ellipsoids), 5-12
- SPLIT_GEOM_SEGMENT procedure, 15-82
- splitting a geometric segment, 6-13
- SQL and PL/SQL examples, 1-26
- SQL*Loader, 3-1
- SRID
-
0 (zero) special case with SDO_CS.VIEWPORT_TRANSFORM function, 14-8
-
in USER_SDO_GEOM_METADATA, 2-26
-
SDO_SRID in SDO_GEOMETRY, 2-8
T
- TABLE_NAME (in USER_SDO_GEOM_METADATA), 2-25
- tessellation, 1-15
- three-dimensional (3D)
-
formats of LRS functions, 6-9
- tile, 1-15, 4-10
- tiling level
-
estimating, 17-10
- TO_734 procedure, 16-6
- TO_81x procedure, 16-8
- TO_CURRENT procedure, 16-11
- tolerance, 1-7
- TOUCH mask relationship, 12-6
- transactional insertion of spatial data, 3-4
- TRANSFORM, 14-2
- TRANSFORM_LAYER, 14-5
-
table for transformed layer, 14-6
- transformation, 5-2
- TRANSLATE_MEASURE procedure, 15-85
- tuning and performance information, 1-25
- two-tier query, 1-9, 4-10
- type zero (0) element, 2-21
U
- union, 12-39
- unit of measurement
-
MDSYS tables, 2-31
- UNIT_NAME column
-
in SDO_ANGLE_UNITS table, 5-10
-
in SDO_AREA_UNITS table, 2-32
-
in SDO_DIST_UNITS table, 2-32
- UNIT_NAME column in SDO_DIST_UNITS table, 5-11
- USER_SDO_GEOM_METADATA view, 2-24
- USER_SDO_INDEX_INFO view, 2-26
- USER_SDO_INDEX_METADATA view, 2-27
- user-defined coordinate system, 5-13
- user-defined data types
-
embedding SDO_GEOMETRY objects in, 8-1, 8-6
V
- VALID_GEOM_SEGMENT function, 15-87
- VALID_LRS_POINT function, 15-89
- VALID_MEASURE function, 15-91
- VALIDATE_GEOMETRY function, 12-45
- VALIDATE_LAYER procedure, 12-48
- VALIDATE_LRS_GEOMETRY function, 15-93
- version number (Spatial)
-
retrieving, 1-26
- VIEWPORT_TRANSFORM, 14-7
W
- well-known text (WKTEXT), 5-7
- WITHIN_DISTANCE function, 12-51
- WKTEXT column of MDSYS.CS_SRS table, 5-7
X
- XOR
-
SDO_XOR function, 12-42
Z
- zero
-
SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 14-8
-
type 0 element, 2-21