Oracle Spatial User's Guide and Reference
Release 9.0.1

Part Number A88805-01

Library

Product

Contents

Go to previous page

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

Go to previous page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents