Skip Headers

Oracle® Spatial User's Guide and Reference
Release 9.2
Part No. A96630-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Previous

Index

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

Numerics

0
SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 13
type 0 (zero) element, 2.3.6
_3D
formats of LRS functions, 6.4
9i
migrating to Oracle9i, 15

A

aggregate functions
description, 1.9
reference information, 12
SDO_AGGR_CENTROID, 12
SDO_AGGR_CONVEXHULL, 12
SDO_AGGR_LRS_CONCAT, 12
SDO_AGGR_MBR, 12
SDO_AGGR_UNION, 12
SDOAGGRTYPE object type, 1.9.1
ALL_SDO_GEOM_METADATA view, 2.4
ALL_SDO_INDEX_INFO view, 2.5.1.1
ALL_SDO_INDEX_METADATA view, 2.5.1.2
ALTER INDEX statement, 8
REBUILD clause, 8
RENAME TO clause, 8
ANALYZE_RTREE procedure, 16
angle units, 5.4.2
ANYINTERACT mask relationship, 11
application size (hardware) requirements, 1.13
arc
densifying, 11
not supported with geodetic data, 5.2.3
area, 11
authalic sphere, 5.1.7
average minimum bounding rectangle, 16
AVERAGE_MBR procedure, 16

B

bounding rectangle
minimum, 16
buffer area, 11
bulk loading of spatial data, 3.1

C

C language
examples (using OCI), 1.15
Cartesian coordinates, 1.5.4, 5.1.2
center of gravity (centroid), 11
centroid
SDO_AGGR_CENTROID aggregate function, 12
SDO_CENTROID function, 11
circle
not supported with geodetic data, 5.2.3
type, 2.2.4
CLIP_GEOM_SEGMENT function, 14
clipping a geometric segment, 6.5.3
column name
restrictions on spatial column names, 2.4.2
COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2.4.2
compatibility, A
compound element, 2.2.4
compound line string, 2.2.4, 2.3.3
compound polygon, 2.2.4
CONCATENATE_GEOM_SEGMENTS function, 14
concatenating geometric segments, 6.5.5
aggregate concatenation, 6.5.5, 12
CONNECTED_GEOM_SEGMENTS function, 14
consistency
checking for valid geometry types, 11, 11
constraining data to a geometry type, 4.1.5
CONTAINS mask relationship, 11
CONVERSION_FACTOR column
in SDO_ANGLE_UNITS table, 5.4.2
in SDO_AREA_UNITS table, 2.6
in SDO_DIST_UNITS table, 2.6
CONVERSION_FACTOR column in SDO_DIST_UNITS table, 5.4.3
CONVERT_TO_LRS_DIM_ARRAY function, 14
CONVERT_TO_LRS_GEOM function, 14
CONVERT_TO_LRS_LAYER function, 14
CONVERT_TO_STD_DIM_ARRAY function, 14
CONVERT_TO_STD_GEOM function, 14
CONVERT_TO_STD_LAYER function, 14
converting
geometric segments
functions for, 14
overview, 6.5.10
convex hull
SDO_AGGR_CONVEXHULL aggregate function, 12
SDO_CONVEXHULL function, 11
coordinate systems
conceptual and usage information, 5
example, 5.8
function reference information, 13
local, 5.3
user-defined, 5.5
coordinates
Cartesian, 1.5.4, 5.1.2
geodetic, 1.5.4, 5.1.3, 5.2
geographic, 1.5.4, 5.1.3
local, 1.5.4, 5.1.5
projected, 1.5.4, 5.1.4
COVEREDBY mask relationship, 11
COVERS mask relationship, 11
CPU requirements for spatial applications, 1.13
CREATE INDEX statement, 8
creating
geometric segments
functions for, 14
cross-schema index creation, 4.1.6
CS_SRS table, 5.4.1
current release
migrating to, 15

D

data model, 1.5
LRS, 6.2
data types
spatial, 2
datum
geodetic, 1.5.4, 5.1.6
MDSYS.SDO_DATUMS table, 5.4.4
transformation, 5.1.8
DBA_SDO_GEOM_METADATA view, 2.4
DBA_SDO_INDEX_INFO view, 2.5.1.1
DBA_SDO_INDEX_METADATA view, 2.5.1.2
deferred index updates, 8
DEFINE_GEOM_SEGMENT function, 14
defining a geometric segment, 6.5.1
densification of arcs, 11
difference, 11
dimension (in SDO_GTYPE), 2.2.1, 2.2.1
GET_DIMS method, 9
GET_LRS_DIM method, 9
DIMINFO (in USER_SDO_GEOM_METADATA), 2.4.3
direction of geometric segment, 6.1.3
concatenation result, 6.5.5
DISJOINT mask relationship, 11
disk storage requirements for spatial applications, 1.13
distance
SDO_NN_DISTANCE ancillary operator, 10
WITHIN_DISTANCE function, 11
distance units, 5.4.3
DROP INDEX statement, 8
dynamic query window, 4.2.1
DYNAMIC_SEGMENT function, 14

E

editing
geometric segments
functions for, 14
ELEM_INFO (SDO_ELEM_INFO), 2.2.4
element, 1.5.1
extracting from a geometry, 17
ellipsoids, 5.4.5
embedded SDO_GEOMETRY object in user-defined type, 7.1
EQUAL mask relationship, 11
error messages
Spatial, 1.14
ESTIMATE_INDEX_PERFORMANCE function, 16
ESTIMATE_TILING_LEVEL function, 16
ESTIMATE_TILING_TIME function, 16
ESTIMATE_TOTAL_NUMTILES function, 16
ETYPE (SDO_ETYPE), 2.2.4
examples
C, 1.15
coordinate systems, 5.8
creating, indexing, and querying spatial data, 2.1
directory for Spatial examples, 1.15
Linear Referencing System (LRS), 6.6
OCI (Oracle Call Interface), 1.15
PL/SQL, 1.15
SQL, 1.15
exchanging partitions including indexes, 4.1.8
EXTENT_OF function, 16
exterior polygon rings, 2.2.1, 2.2.4, 2.2.4, 2.3.2, 2.3.2
EXTRACT function, 17

F

features
linear, 6.1.10
FIND_LRS_DIM_POS function, 14
FIND_MEASURE function, 14
fixed indexing, 1.7.2.2
fixed-size tiles, 4.1.3
FROM_815_TO_81x procedure, 15
function-based index
with SDO_GEOMETRY objects, 7.2
function-based indexes
privilege and session requirements, 7.2
functions and procedures
aggregate (spatial), 12
ANALYZE_RTREE, 16
AVERAGE_MBR, 16
CLIP_GEOM_SEGMENT, 14
CONCATENATE_GEOM_SEGMENTS, 14
CONNECTED_GEOM_SEGMENTS, 14
CONVERT_TO_LRS_DIM_ARRAY, 14
CONVERT_TO_LRS_GEOM, 14
CONVERT_TO_LRS_LAYER, 14
CONVERT_TO_STD_DIM_ARRAY, 14
CONVERT_TO_STD_GEOM, 14
CONVERT_TO_STD_LAYER, 14
coordinate system transformation, 13
DEFINE_GEOM_SEGMENT, 14
DYNAMIC_SEGMENT, 14
ESTIMATE_INDEX_PERFORMANCE, 16
ESTIMATE_TILING_LEVEL, 16
ESTIMATE_TILING_TIME, 16
ESTIMATE_TOTAL_NUMTILES, 16
EXTENT_OF, 16
EXTRACT, 17
FIND_LRS_DIM_POS, 14
FIND_MEASURE, 14
FROM_815_TO_81x, 15
GEOM_SEGMENT_END_MEASURE, 14
GEOM_SEGMENT_END_PT, 14
GEOM_SEGMENT_LENGTH, 14
GEOM_SEGMENT_START_MEASURE, 14
GEOM_SEGMENT_START_PT, 14
geometry, 11
GET_MEASURE, 14
GETVERTICES, 17
HISTOGRAM_ANALYSIS, 16
IS_GEOM_SEGMENT_DEFINED, 14
IS_MEASURE_DECREASING, 14
IS_MEASURE_INCREASING, 14
linear referencing (LRS), 14
LOCATE_PT, 14
MEASURE_RANGE, 14
MEASURE_TO_PERCENTAGE, 14
migration, 15
MIX_INFO, 16
not supported with geodetic data, 5.7.2
OFFSET_GEOM_SEGMENT, 14
OGIS_METADATA_FROM, 15
OGIS_METADATA_TO, 15
PERCENTAGE_TO_MEASURE, 14
PROJECT_PT, 14
QUALITY_DEGRADATION, 16
REDEFINE_GEOM_SEGMENT, 14
RELATE, 11
RESET_MEASURE, 14
REVERSE_GEOMETRY, 14
REVERSE_MEASURE, 14
RTREE_QUALITY, 16
SCALE_GEOM_SEGMENT, 14
SDO_AGGR_CENTROID, 12
SDO_AGGR_CONVEXHULL, 12
SDO_ARC_DENSIFY, 11
SDO_AREA, 11
SDO_BUFFER, 11
SDO_CENTROID, 11
SDO_CONVEXHULL, 11
SDO_DIFFERENCE, 11
SDO_DISTANCE, 11
SDO_INTERSECTION, 11
SDO_LENGTH, 11
SDO_MAX_MBR_ORDINATE, 11
SDO_MBR, 11
SDO_MIN_MBR_ORDINATE, 11
SDO_POINTONSURFACE, 11
SDO_UNION, 11
SDO_XOR, 11
SET_PT_MEASURE, 14
spatial aggregate, 12
SPLIT_GEOM_SEGMENT, 14
supported by approximations with geodetic data, 5.7.3
TO_734, 15
TO_81x, 15
TO_CURRENT, 15
TRANSFORM, 13
TRANSFORM_LAYER, 13
TRANSLATE_MEASURE, 14
tuning, 16
utility, 17
VALID_GEOM_SEGMENT, 14
VALID_LRS_POINT, 14
VALID_MEASURE, 14
VALIDATE_GEOMETRY, 11
VALIDATE_GEOMETRY_WITH_CONTEXT, 11
VALIDATE_LAYER, 11
VALIDATE_LAYER_WITH_CONTEXT, 11
VALIDATE_LRS_GEOMETRY, 14
VIEWPORT_TRANSFORM function, 13
WITHIN_DISTANCE, 11

G

geocoding, 1.10
geodetic coordinates, 1.5.4, 5.1.3
arcs and circles not supported, 5.2.3
functions not supported, 5.7.2
functions supported by approximations, 5.7.3
support for, 5.2
geodetic datum, 1.5.4, 5.1.6
geodetic index, 4.1.4
geographic coordinates, 1.5.4, 5.1.3
GEOM_SEGMENT_END_MEASURE function, 14
GEOM_SEGMENT_END_PT function, 14
GEOM_SEGMENT_LENGTH function, 14
GEOM_SEGMENT_START_MEASURE function, 14
GEOM_SEGMENT_START_PT function, 14
geometric segment
clipping, 6.5.3
concatenating, 6.5.5
aggregate, 6.5.5, 12
converting (functions for), 14
converting (overview), 6.5.10
creating (functions for), 14
defining, 6.5.1
definition of, 6.1.1
direction, 6.1.3
direction with concatenation, 6.5.5
editing (functions for), 14
locating point on, 6.5.8
offsetting, 6.5.7
projecting point onto, 6.5.9
querying (functions for), 14
redefining, 6.5.2
scaling, 6.5.6
splitting, 6.5.4
geometry functions
reference information, 11
geometry type
constraining data to, 4.1.5
GET_DIMS method, 9
SDO_GTYPE, 2.2.1
geometry types, 1.4
GET_DIMS method, 9
GET_GTYPE method, 9
GET_LRS_DIM method, 9
GET_MEASURE function, 14
GETVERTICES function, 17
GTYPE (SDO_GTYPE), 2.2.1
constraining data to a geometry type, 4.1.5

H

hardware requirements for spatial applications, 1.13
HISTOGRAM_ANALYSIS procedure, 16
hybrid indexing, B

I

index
creation, 4.1
cross-schema, 4.1.6
parallel execution, 8
deferred updating, 8
description of Spatial indexing, 1.7
geodetic and non-geodetic, 4.1.4
hybrid, B
partitioned, 4.1.7
exchanging partitions including indexes, 4.1.8
performance, 16
quadtree, 1.7.2
rebuilding
parallel execution, 8
R-tree, 1.7.1
R-tree (requirements before creating), 4.1.1, 4.1.1
synchronizing deferred updates, 8
index-organized table
cannot create spatial index on, 8
inserting spatial data
PL/SQL, 3.2
INSIDE mask relationship, 11
installation, A
installation procedure for Spatial, A.2
INTEPRETATION (SDO_INTERPRETATION), 2.2.4
interaction
ANYINTERACT, 11
interior polygon rings, 2.2.1, 2.2.4, 2.2.4, 2.3.2, 2.3.2
interMedia Locator
See Locator
intersection, 11
inverse flattening, 5.4.5
IS_GEOM_SEGMENT_DEFINED function, 14
IS_MEASURE_DECREASING function, 14
IS_MEASURE_INCREASING function, 14

L

layer, 1.5.3
transforming, 13
validating, 11
validating with context, 11
layer_gtype
constraining data to a geometry type, 4.1.5
length
SDO_LENGTH function, 11
line
data, 1.5.1
length, 11
line string
compound, 2.2.4, 2.3.3
self-crossing, 1.4
linear features, 6.1.10
linear measure, 6.1.4
Linear Referencing System (LRS)
3D formats of functions, 6.4
conceptual and usage information, 6
data model, 6.2
example, 6.6
function reference information, 14
GET_LRS_DIM method, 9
limiting indexing to X and Y dimensions, 6.3
LRS point, 6.1.9
segments, 6.1.1
upgrading data to current release, A.5
loading spatial data, 3
local coordinate systems, 5.3
local coordinates, 1.5.4, 5.1.5
LOCAL partitioning
spatial index, 4.1.7
LOCATE_PT function, 14
Locator, C
LRS
See Linear Referencing System (LRS)
LRS point, 6.1.9

M

map projections, 5.4.6
MBR
SDO_AGGR_MBR aggregate function, 12
SDO_MAX_MBR_ORDINATE function, 11
SDO_MBR function, 11
SDO_MIN_MBR_ORDINATE function, 11
MDSYS schema, 1.1
MDSYS user
created during default installation, A.2
protecting against unauthorized use, A.2
MDSYS.CS_SRS table, 5.4.1
MDSYS.SDO_ANGLE_UNITS table, 5.4.2
MDSYS.SDO_CS package, 13
MDSYS.SDO_DATUMS table, 5.4.4
MDSYS.SDO_DIST_UNITS table, 5.4.3
MDSYS.SDO_ELLIPSOIDS table, 5.4.5
MDSYS.SDO_PROJECTIONS table, 5.4.6
measure, 6.1.4
populating, 6.1.6
resetting, 14
reversing, 14
measure range, 6.1.7
MEASURE_RANGE function, 14
MEASURE_TO_PERCENTAGE function, 14
messages
Spatial error messages, 1.14
migration
instructions and issues, A
OGIS, 15, 15
procedures, 15
to current Spatial release, 15
to release 7.3.4, 15
See also upgrading
minimum bounding rectangle
AVERAGE_MBR procedure, 16
EXTENT_OF function, 16
SDO_AGGR_MBR aggregate function, 12
SDO_MAX_MBR_ORDINATE function, 11
SDO_MBR function, 11
SDO_MIN_MBR_ORDINATE function, 11
MIX_INFO procedure, 16
multipolygon, 2.3.2

N

nearest neighbor
SDO_NN operator, 10
non-geodetic index, 4.1.4

O

object types
embedding SDO_GEOMETRY objects in, 7.1, 7.2.2
object-relational model, 2
OCI (Oracle Call Interface) examples, 1.15
offset, 6.1.5
OFFSET_GEOM_SEGMENT function, 14
offsetting a geometric segment, 6.5.7
OGIS_METADATA_FROM procedure, 15
OGIS_METADATA_TO procedure, 15
ON mask relationship, 11
operators
cross-schema invocation, 4.2.3
SDO_FILTER, 10
SDO_NN, 10
SDO_NN_DISTANCE, 10
SDO_RELATE, 10
SDO_WITHIN_DISTANCE, 10
optimized rectangle, 2.2.4
Oracle Call Interface (OCI) examples, 1.15
OVERLAPBDYDISJOINT mask relationship, 11
OVERLAPBDYINTERSECT mask relationship, 11

P

parallel execution for index creation and rebuilding, 8, 8
partitioned spatial index, 4.1.7
exchanging partitions, 4.1.8
PERCENTAGE_TO_MEASURE function, 14
performance and tuning information, 1.11
PL/SQL and SQL examples, 1.15
point
data, 1.5.1
illustration and examples of point-only geometry, 2.3.5
locating on geometric segment, 6.5.8
LRS, 6.1.9
on surface of polygon, 11
shape, 6.1.2
polygon
area of, 11
centroid, 11
compound, 2.2.4
exterior and interior rings, 2.2.1, 2.2.4, 2.2.4, 2.3.2, 2.3.2
point on surface, 11
self-crossing not supported, 1.4
polygon collection, 2.3.2
polygon data, 1.5.1
populating
measure, 6.1.6
primary filter, 1.6, 4.2.1.1, 4.2.1.2
primitive types, 1.4
problems in current release, 5.7
geodetic data, 5.2.3
procedures
See functions and procedures
PROJECT_PT function, 14
projected coordinates, 1.5.4, 5.1.4
projection, 6.1.8
point onto geometric segment, 6.5.9
PROJECT_PT function, 14
projections, 5.4.6

Q

quadtree indexes, 1.7.2
quality
degradation of R-tree index, 16
R-tree, 1.7.1.1
QUALITY_DEGRADATION function, 16
query, 4.2.1
query model for Spatial, 1.6
QUERY REWRITE
privilege and session requirements, 7.2
query window, 4.2.1
querying geometric segments
functions for, 14

R

range
measure, 6.1.7
rectangle
minimum bounding, 16
type, 2.2.4
REDEFINE_GEOM_SEGMENT procedure, 14
redefining a geometric segment, 6.5.2
RELATE function, 11
release 9i
migrating to Oracle9i, 15
release number (Spatial)
retrieving, 1.12
RESET_MEASURE procedure, 14
restrictions in current release, 5.7
geodetic data, 5.2.3
REVERSE_GEOMETRY function, 14
REVERSE_MEASURE function, 14
ring
exterior and interior polygon, 2.2.4
extracting from a geometry, 17
rollback segment
R-tree index creation, 4.1.1
R-tree indexes, 1.7.1
analyzing quality, 16
before creating, 4.1.1, 4.1.1
quality degradation, 16
quality score, 16
sequence object, 2.5.3
R-tree quality, 1.7.1.1
RTREE_QUALITY function, 16

S

SCALE_GEOM_SEGMENT function, 14
scaling a geometric segment, 6.5.6
schema
creating index on table in another schema, 4.1.6
invoking operators on table in another schema, 4.2.3
SDO_AGGR_CENTROID aggregate function, 12
SDO_AGGR_CONVEXHULL aggregate function, 12
SDO_AGGR_LRS_CONCAT aggregate function, 12
SDO_AGGR_MBR aggregate function, 12
SDO_AGGR_UNION aggregate function, 12
SDO_ANGLE_UNITS table, 5.4.2
SDO_ARC_DENSIFY function, 11
SDO_AREA function, 11
SDO_AREA_UNITS table, 2.6
SDO_BUFFER function, 11
SDO_CENTROID function, 11
SDO_CODE, 2.5.2
SDO_CONVEXHULL function, 11
SDO_CS package, 13
SDO_DATUMS table, 5.4.4
SDO_DIFFERENCE function, 11
SDO_DIST_UNITS table, 2.6, 5.4.3
SDO_DISTANCE function, 11
SDO_ELEM_INFO, 2.2.4
SDO_ELEM_INFO_ARRAY type, 2.2
SDO_ELLIPSOIDS table, 5.4.5
SDO_ETYPE, 2.2.4
SDO_FILTER operator, 10
SDO_GEOMETRY object type, 2.2
embedding in user-defined type, 7.1, 7.2.2
in function-based indexes, 7.2
methods, 9, 12
SDO_GROUPCODE, 2.5.2
SDO_GTYPE, 2.2.1
constraining data to a geometry type, 4.1.5
GET_DIMS method, 9
GET_GTYPE method, 9
GET_LRS_DIM method, 9
SDO_INDEX_TABLE, 2.5.2
SDO_INDX_DIMS keyword, 6.3
SDO_INTERPRETATION, 2.2.4
SDO_INTERSECTION function, 11
SDO_LENGTH function, 11
SDO_LEVEL, 1.7.2
SDO_MAX_MBR_ORDINATE function, 11
SDO_MBR function, 11
SDO_MIN_MBR_ORDINATE function, 11
SDO_NN operator, 10
optimizer hint, 10
SDO_NN_DISTANCE ancillary operator, 10
SDO_NUMTILES, 1.7.2
SDO_ORDINATE_ARRAY type, 2.2
SDO_ORDINATES, 2.2.5
SDO_POINT, 2.2.3
SDO_POINT_TYPE object type, 2.2
SDO_POINTONSURFACE function, 11
SDO_POLY_xxx functions (deprecated and removed), 11
SDO_PROJECTIONS table, 5.4.6
SDO_RELATE operator, 10
SDO_ROWID, 2.5.2
SDO_RTREE_SEQ_NAME, 2.5.3
SDO_SRID, 2.2.2
SDO_STARTING_OFFSET, 2.2.4
SDO_STATUS, 2.5.2
SDO_UNION function, 11
SDO_UNIT column
in SDO_AREA_UNITS table, 2.6
in SDO_DIST_UNITS table, 2.6, 5.4.3
SDO_VERSION function, 1.12
SDO_WITHIN_DISTANCE operator, 10
SDO_XOR function, 11
SDOAGGRTYPE object type, 1.9.1
secondary filter, 1.6, 4.2.1.2
segments
geometric, 6.1.1
self-crossing line strings and polygons, 1.4
semi-major axis, 5.4.5
sequence object for R-tree index, 2.5.3
SET_PT_MEASURE procedure, 14
shape point, 6.1.2
simple element, 2.2.4
size requirements (hardware) for spatial applications, 1.13
SORT_AREA_SIZE parameter
R-tree index creation, 4.1.1
spatial aggregate functions
See aggregate functions
spatial data structures
object-relational model, 2
spatial data types, 2
spatial index
See index
Spatial Index Advisor
using to determine best tiling level, 4.1.3
spatial indexing
fixed, 1.7.2.2
spatial join, 4.2.2
spatial query, 4.2.1
spatial reference systems
conceptual and usage information, 5
example, 5.8
function reference information, 13
sphere
authalic, 5.1.7
spheroids (ellipsoids), 5.4.5
SPLIT_GEOM_SEGMENT procedure, 14
splitting a geometric segment, 6.5.4
SQL and PL/SQL examples, 1.15
SQL*Loader, 3.1
SRID
0 (zero) special case with SDO_CS.VIEWPORT_TRANSFORM function, 13
in USER_SDO_GEOM_METADATA, 2.4.4
SDO_SRID in SDO_GEOMETRY, 2.2.2
synchronizing deferred index updates, 8

T

table name
restrictions on spatial table names, 2.4.1
TABLE_NAME (in USER_SDO_GEOM_METADATA), 2.4.1
tessellation, 1.7.2.1
three-dimensional (3D)
formats of LRS functions, 6.4
tile, 1.7.2, 4.2.1
tiling level
estimating, 16
TO_734 procedure, 15
TO_81x procedure, 15
TO_CURRENT procedure, 15
tolerance, 1.5.5
TOUCH mask relationship, 11
transactional insertion of spatial data, 3.2
TRANSFORM, 13
TRANSFORM_LAYER, 13
table for transformed layer, 13
transformation, 5.1.8
TRANSLATE_MEASURE procedure, 14
tuning and performance information, 1.11
tuning functions and procedures, 16
two-tier query, 1.6
type zero (0) element, 2.3.6

U

union, 11
unit of measurement
MDSYS tables, 2.6
UNIT_NAME column
in SDO_ANGLE_UNITS table, 5.4.2
in SDO_AREA_UNITS table, 2.6
in SDO_DIST_UNITS table, 2.6
UNIT_NAME column in SDO_DIST_UNITS table, 5.4.3
upgrading
from Spatial release 8.1.5, 8.1.6, or 8.7.1, A.3
from Spatial release 9.0.1, A.4
instructions and issues, A
LRS data, A.5
See also migration
USER_SDO_GEOM_METADATA view, 2.4
USER_SDO_INDEX_INFO view, 2.5.1.1
USER_SDO_INDEX_METADATA view, 2.5.1.2
user-defined coordinate system, 5.5
user-defined data types
embedding SDO_GEOMETRY objects in, 7.1, 7.2.2
utility functions, 17

V

VALID_GEOM_SEGMENT function, 14
VALID_LRS_POINT function, 14
VALID_MEASURE function, 14
VALIDATE_GEOMETRY function, 11
VALIDATE_GEOMETRY_WITH_CONTEXT function, 11
VALIDATE_LAYER procedure, 11
VALIDATE_LAYER_WITH_CONTEXT procedure, 11
VALIDATE_LRS_GEOMETRY function, 14
version number (Spatial)
retrieving, 1.12
VERTEX_SET_TYPE data type, 17
VERTEX_TYPE object type, 17
vertices
returning geometry coordinates as, 17
VIEWPORT_TRANSFORM, 13

W

well-known text (WKTEXT), 5.4.1.1
WITHIN_DISTANCE function, 11
WKTEXT column of MDSYS.CS_SRS table, 5.4.1.1

X

XOR
SDO_XOR function, 11

Z

zero
SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 13
type 0 element, 2.3.6

Previous
Oracle Logo
Copyright © 1999, 2002 Oracle Corporation

All rights reserved
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback