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

Numerics

SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 15

type 0 (zero) element, 2.3.6

10g

upgrading spatial data to Oracle Database 10g, 17

formats of LRS functions, 7.4

A

addresses

representing for geocoding, 5.1.1

aggregate functions

description, 1.10

reference information, 14

SDO_AGGR_CENTROID, 14

SDO_AGGR_CONCAT_LINES, 14

SDO_AGGR_CONVEXHULL, 14

SDO_AGGR_LRS_CONCAT, 14

SDO_AGGR_MBR, 14

SDO_AGGR_UNION, 14

SDOAGGRTYPE object type, 1.10.1

AGGREGATES_FOR_GEOMETRY function, 21

AGGREGATES_FOR_LAYER function, 21

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, 10

REBUILD clause, 10

RENAME TO clause, 10

angle units, 6.4.2

ANYINTERACT

SDO_ANYINTERACT operator, 12

topological relationship, 1.8

APPEND function, 19

application size (hardware) requirements, 1.16

arc

densifying, 13

not supported with geodetic data, 6.2.4

area, 13

area units, 2.6

authalic sphere, 6.1.7

average minimum bounding rectangle, 18

AVERAGE_MBR procedure, 18

B

bearing

point at, 19

BIN_GEOMETRY function, 21

BIN_LAYER procedure, 21

binning

spatial, 8.2

See also bins

bins

assigning, 21

computing, 21

tiled, 21

boundary

of an area, 1.8

of line string, 1.8

of multiline string, 1.8

of polygon, 1.8

bounding rectangle

minimum, 18

buffer area, 13

bulk loading of spatial data, 3.1

C

C language

examples (using OCI), 1.18

Cartesian coordinates, 1.5.4, 6.1.2

center of gravity (centroid), 13

centroid

SDO_AGGR_CENTROID aggregate function, 14

SDO_CENTROID function, 13

circle

creating polygon approximating, 19

not supported with geodetic data, 6.2.4

type, 2.2.4

CIRCLE_POLYGON function, 19

CLIP_GEOM_SEGMENT function, 16

clipping

geometric segment, 7.5.3

COLOCATED_REFERENCE_FEATURES procedure, 21

colocation mining, 8.4

column name

restrictions on spatial column names, 2.4.2

COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2.4.2

compatibility, A

complex examples

queries, C

compound element, 2.2.4

compound line string, 2.2.4, 2.3.3

compound polygon, 2.2.4

CONCAT_LINES function, 19

CONCATENATE_GEOM_SEGMENTS function, 16

concatenating

geometric segments, 7.5.5

line or multiline geometries, 14

LRS geometries, 7.5.5, 14

CONNECTED_GEOM_SEGMENTS function, 16

consistency

checking for valid geometry types, 13

constraining data to a geometry type, 4.1.4

CONTAINS

SDO_CONTAINS operator, 12

topological relationship, 1.8

CONVERSION_FACTOR column

in SDO_ANGLE_UNITS table, 6.4.2

in SDO_AREA_UNITS table, 2.6

in SDO_DIST_UNITS table, 2.6

CONVERT_TO_LRS_DIM_ARRAY function, 16

CONVERT_TO_LRS_GEOM function, 16

CONVERT_TO_LRS_LAYER function, 16

CONVERT_TO_STD_DIM_ARRAY function, 16

CONVERT_TO_STD_GEOM function, 16

CONVERT_TO_STD_LAYER function, 16

CONVERT_UNIT function, 19

converting

geometric segments

overview, 7.5.10

subprograms for, 16

convex hull

SDO_AGGR_CONVEXHULL aggregate function, 14

SDO_CONVEXHULL function, 13

coordinate systems

conceptual and usage information, 6

example, 6.8

local, 6.3

subprogram reference information, 15

unit of measurement support, 2.6

user-defined, 6.5

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, 12

topological relationship, 1.8

COVERS

SDO_COVERS operator, 12

topological relationship, 1.8

CPU requirements for spatial applications, 1.16

CREATE INDEX statement, 10

creating

geometric segments

subprograms for, 16

cross-schema index creation, 4.1.5

CS_SRS table, 6.4.1

current release

upgrading spatial data to, 17

D

data mining

spatial

colocation mining, 8.4

conceptual and usage information, 8

function reference information, 21

data model, 1.5

LRS, 7.2

data types

spatial, 2

database links

not supported if spatial index is defined on the table, 4.2

datum

geodetic, 1.5.4, 6.1.6

MDSYS.SDO_DATUMS table, 6.4.3

transformation, 6.1.8

dblink

not supported if spatial index is defined on the table, 4.2

deferred index updates, 10

DEFINE_GEOM_SEGMENT procedure, 16

defining

geometric segment, 7.5.1

densification of arcs, 13

difference, 13

dimension (in SDO_GTYPE), 2.2.1, 2.2.1

GET_DIMS method, 11

GET_LRS_DIM method, 11

DIMINFO (in USER_SDO_GEOM_METADATA), 2.4.3

direction of geometric segment, 7.1.3

concatenation result, 7.5.5

discretization (binning)

spatial, 8.2

See also bins

DISJOINT

topological relationship, 1.8

disk storage requirements for spatial applications, 1.16

distance

SDO_NN_DISTANCE ancillary operator, 12

WITHIN_DISTANCE function, 13

distance units, 2.6

Douglas-Peucker algorithm for geometry simplification, 19

DROP INDEX statement, 10

duplicate vertices

removing, 19

dynamic query window, 4.2.1

DYNAMIC_SEGMENT function, 16

E

editing

geometric segments

subprograms for, 16

ELEM_INFO (SDO_ELEM_INFO attribute), 2.2.4

elements, 1.5.1

extracting from a geometry, 19

returning number of elements in a geometry, 19

returning number of vertices in a geometry, 19

ellipse

creating polygon approximating, 19

ELLIPSE_POLYGON function, 19

ellipsoids, 6.4.4

embedded SDO_GEOMETRY object in user-defined type, 9.1

EQUAL

SDO_EQUAL operator, 12

topological relationship, 1.8

error messages

geocoding, 5.1.4

Spatial, 1.17

ESTIMATE_RTREE_INDEX_SIZE function, 18

ETYPE (SDO_ETYPE value), 2.2.4, 2.2.4

examples

C, 1.18

complex queries, C

coordinate systems, 6.8

creating, indexing, and querying spatial data, 2.1

directory for Spatial examples, 1.18

linear referencing system (LRS), 7.7

OCI (Oracle Call Interface), 1.18

PL/SQL, 1.18

SQL, 1.18

exchanging partitions including indexes, 4.1.7

Export utility

with spatial indexes and data, 4.1.8

EXTENT_OF function, 18

exterior polygon rings, 2.2.4, 2.2.4, 2.3.2, 2.3.2

EXTRACT function, 19

F

features

linear, 7.1.10

FILTER

SDO_FILTER operator, 12

FILTER mask value for SDO_JOIN, 12

FIND_LRS_DIM_POS function, 16

FIND_MEASURE function, 16

FIND_OFFSET function, 16

formatted addresses, 5.1.1

FROM_815_TO_81X procedure

use TO_CURRENT instead, 17

function-based indexes

privilege and session requirements, 9.2

with SDO_GEOMETRY objects, 9.2

functions

spatial aggregate, 14

supported by approximations with geodetic data, 6.7.3

G

GEOCODE function, 20

GEOCODE_ALL function, 20

GEOCODE_AS_GEOMETRY function, 20

geocoding, 1.12

concepts, 5.1

data requirements, 5.3

data types for, 5.2

error messages, 5.1.4

match codes, 5.1.3

match modes, 5.1.2

subprogram reference information, 20

usage information, 5

geodetic coordinates, 1.5.4, 6.1.3

arcs and circles not supported, 6.2.4

functions not supported, 6.7.2

functions supported by approximations, 6.7.3

support for, 6.2

geodetic datum, 1.5.4, 6.1.6

geodetic index, 4.1.2

geodetic MBRs, 6.2.3

geographic coordinates

See geodetic coordinates

geography markup language (GML)

converting geometry to, 19

GEOM_SEGMENT_END_MEASURE function, 16

GEOM_SEGMENT_END_PT function, 16

GEOM_SEGMENT_LENGTH function, 16

GEOM_SEGMENT_START_MEASURE function, 16

GEOM_SEGMENT_START_PT function, 16

geometric segment

clipping, 7.5.3

concatenating, 7.5.5

aggregate, 7.5.5, 14

converting (overview), 7.5.10

converting (subprograms for), 16

creating (subprograms for), 16

defining, 7.5.1

definition of, 7.1.1

direction, 7.1.3

direction with concatenation, 7.5.5

editing (subprograms for), 16

locating point on, 7.5.8

offsetting, 7.5.7

projecting point onto, 7.5.9

querying (subprograms for), 16

redefining, 7.5.2

scaling, 7.5.6

splitting, 7.5.4

geometry subprograms

reference information, 13

geometry types, 1.4

constraining data to, 4.1.4

GET_DIMS method, 11

SDO_GTYPE, 2.2.1

GET_DIMS method, 11

GET_GTYPE method, 11

GET_LRS_DIM method, 11

GET_MEASURE function, 16

GET_NEXT_SHAPE_PT function, 16

GET_NEXT_SHAPE_PT_MEASURE function, 16

GET_PREV_SHAPE_PT function, 16

GET_PREV_SHAPE_PT_MEASURE function, 16

GETNUMELEM function, 19

GETNUMVERTICES function, 19

GETVERTICES function, 19

GML (geography markup language)

converting geometry to, 19

GTYPE (SDO_GTYPE attribute), 2.2.1

constraining data to a geometry type, 4.1.4

GET_DIMS method, 11

GET_GTYPE method, 11

GET_LRS_DIM method, 11

H

hardware requirements for spatial applications, 1.16

I

Import utility

with spatial indexes and data, 4.1.8

index

creation, 4.1

cross-schema, 4.1.5

parallel execution, 10

deferred updating, 10

description of Spatial indexing, 1.7

geodetic and non-geodetic, 4.1.2

partitioned, 4.1.6

exchanging partitions including indexes, 4.1.7

quadtree

deprecated feature of Spatial, 1.7

rebuilding, 10

parallel execution, 10, 10

R-tree

description, 1.7.1

requirements before creating, 4.1.1

size (R-tree), 18

synchronizing deferred updates, 10

index-organized table

cannot create spatial index on, 10

INITIALIZE_INDEXES_FOR_TTS procedure, 19

inserting spatial data

PL/SQL, 3.2

INSIDE

SDO_INSIDE operator, 12

topological relationship, 1.8

installation, A

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.3.2, 2.3.2

intersection, 13

inverse flattening, 6.4.4

IS_GEOM_SEGMENT_DEFINED function, 16

IS_MEASURE_DECREASING function, 16

IS_MEASURE_INCREASING function, 16

IS_SHAPE_PT_MEASURE function, 16

J

Java client interface for Spatial (sdoapi), 1.11

JGeometry class (Spatial Java interface), 1.11

join

SDO_JOIN operator, 12

L

layer, 1.5.3

transforming, 15

validating, 13

validating with context, 13

layer_gtype

constraining data to a geometry type, 4.1.4

length

SDO_LENGTH function, 13

line

converting polygon to, 19

data, 1.5.1

length, 13

line string

boundary of, 1.8

compound, 2.2.4, 2.3.3

reversing, 19

self-crossing, 1.4

linear features, 7.1.10

linear measure, 7.1.4

linear referencing system (LRS)

3D formats of functions, 7.4

conceptual and usage information, 7

data model, 7.2

example, 7.7

GET_LRS_DIM method, 11

limiting indexing to X and Y dimensions, 7.3

LRS point, 7.1.9

segments, 7.1.1

subprogram reference information, 16

tolerance values with LRS functions, 7.6

upgrading data to current release, A.1

loading spatial data, 3

local coordinate systems, 6.3

local coordinates, 1.5.4, 6.1.5

LOCAL partitioning

spatial index, 4.1.6

LOCATE_PT function, 16

location prospecting, 8.6

Locator, B

LRS

See linear referencing system (LRS)

LRS point, 7.1.9

M

map projections, 6.4.5

match codes, 5.1.3

match modes, 5.1.2

MBR

See minimum bounding rectangle

MDDATA schema, 1.13

MDSYS schema, 1.1

MDSYS.CS_SRS table, 6.4.1

MDSYS.SDO_ANGLE_UNITS table, 6.4.2

MDSYS.SDO_AREA_UNITS table, 2.6

MDSYS.SDO_CS package, 15

MDSYS.SDO_DATUMS table, 6.4.3

MDSYS.SDO_DIST_UNITS table, 2.6

MDSYS.SDO_ELLIPSOIDS table, 6.4.4

MDSYS.SDO_GCDR package, 20

MDSYS.SDO_PROJECTIONS table, 6.4.5

MDSYS.SDO_SAM package, 21

measure, 7.1.4

populating, 7.1.6

resetting, 16

reversing, 16

measure range, 7.1.7

MEASURE_RANGE function, 16

MEASURE_TO_PERCENTAGE function, 16

messages

Spatial error messages, 1.17

migration

See upgrading

minimum bounding rectangle

AVERAGE_MBR procedure, 18

EXTENT_OF function, 18

geodetic, 6.2.3

SDO_AGGR_MBR aggregate function, 14

SDO_MAX_MBR_ORDINATE function, 13

SDO_MBR function, 13

SDO_MIN_MBR_ORDINATE function, 13

mining

See data mining

MIX_INFO procedure, 18

multiline string

boundary of, 1.8

multimaster replication

SDO_GEOMETRY objects, B

multipolygon, 2.3.2

N

nearest neighbor

SDO_NN operator, 12

SDO_NN_DISTANCE operator, 12

neighborhood influence, 8.3

NLS_LENGTH_SEMANTICS parameter

spatial queries on UTF8 data, 4.2

non-geodetic index, 4.1.2

O

object types

embedding SDO_GEOMETRY objects in, 9.1, 9.2.2

OCI (Oracle Call Interface) examples, 1.18

ODM

See Oracle Data Mining (ODM)

offset, 7.1.5

FIND_OFFSET function, 16

OFFSET_GEOM_SEGMENT function, 16

offsetting

geometric segment, 7.5.7

SDO_ON operator, 12

topological relationship, 1.8

operators

cross-schema invocation, 4.2.3

overview, 1.9

performance-related guidelines, 1.9

SDO_ANYINTERACT, 12

SDO_CONTAINS, 12

SDO_COVEREDBY, 12

SDO_COVERS, 12

SDO_EQUAL, 12

SDO_FILTER, 12

SDO_INSIDE, 12

SDO_JOIN, 12

SDO_NN, 12

SDO_NN_DISTANCE, 12

SDO_ON, 12

SDO_OVERLAPBDYDISJOINT, 12

SDO_OVERLAPBDYINTERSECT, 12

SDO_OVERLAPS, 12

SDO_RELATE, 12

SDO_TOUCH, 12

SDO_WITHIN_DISTANCE, 12

optimized rectangle, 2.2.4

Oracle Call Interface (OCI) examples, 1.18

Oracle Data Mining (ODM)

spatial analysis and mining information, 8

Oracle Database 10g

upgrading spatial data to, A

Oracle Locator

See Locator

OVERLAPBDYDISJOINT

SDO_OVERLAPBDYDISJOINT operator, 12

topological relationship, 1.8

OVERLAPBDYINTERSECT

SDO_OVERLAPBDYINTERSECT operator, 12

topological relationship, 1.8

OVERLAPS

SDO_OVERLAPS operator, 12

P

parallel execution for index creation and rebuilding, 10, 10, 10

partitioned spatial index, 4.1.6

exchanging partitions, 4.1.7

PERCENTAGE_TO_MEASURE function, 16

performance and tuning information, 1.14

for Spatial operators, 1.9

PL/SQL and SQL examples, 1.18

point

data, 1.5.1

illustration and examples of point-only geometry, 2.3.5

locating on geometric segment, 7.5.8

LRS, 7.1.9

on surface of polygon, 13

projection of onto geometric segment, 7.1.8, 7.5.9

shape, 7.1.2

POINT_AT_BEARING function, 19

polygon

area of, 13

boundary of, 1.8

buffer, 13

centroid, 13

compound, 2.2.4

exterior and interior rings, 2.2.4, 2.2.4, 2.3.2, 2.3.2

point on surface, 13

self-crossing not supported, 1.4

polygon collection, 2.3.2

polygon data, 1.5.1

POLYGONTOLINE function, 19

populating

measure, 7.1.6

PREPARE_FOR_TTS procedure, 19

primary filter, 1.6, 4.2.1.1, 4.2.1.2

primitive types, 1.4

problems in current release, 6.7

geodetic data, 6.2.4

PROJECT_PT function, 16

projected coordinates, 1.5.4, 6.1.4

projection, 7.1.8

map, 6.4.5

point onto geometric segment, 7.5.9

PROJECT_PT function, 16

Q

quadtree indexes

deprecated feature of Spatial, 1.7

quality

degradation of R-tree index, 18

R-tree, 1.7.2

QUALITY_DEGRADATION function, 18

query, 4.2.1

query model for Spatial, 1.6

QUERY REWRITE

privilege and session requirements, 9.2

query window, 4.2.1

querying geometric segments

subprograms for, 16

R

range

measure, 7.1.7

rebuilding

spatial indexes, 10

rectangle

minimum bounding, 18

type, 2.2.4

REDEFINE_GEOM_SEGMENT procedure, 16

redefining

geometric segment, 7.5.2

RELATE function, 13

See also SDO_RELATE operator

release number (Spatial)

retrieving, 1.15

REMOVE_DUPLICATE_VERTICES function, 19

replication

multimaster, B

object, B

RESET_MEASURE procedure, 16

restrictions in current release, 6.7

geodetic data, 6.2.4

REVERSE_GEOMETRY function, 16

REVERSE_LINESTRING function, 19

REVERSE_MEASURE function, 16

ring

exterior and interior polygon, 2.2.4

extracting from a geometry, 19

rollback segment

R-tree index creation, 4.1.1

R-tree indexes

description of indexing process, 1.7.1

quality degradation, 18

rebuilding, 10

requirements before creating, 4.1.1

sequence object, 2.5.3

when to use, 1.7

R-tree quality, 1.7.2

S

SCALE_GEOM_SEGMENT function, 16

scaling

geometric segment, 7.5.6

schema

creating index on table in another schema, 4.1.5

invoking operators on table in another schema, 4.2.3

SDO_ADDR_ARRAY data type, 5.2.2

SDO_AGGR_CENTROID aggregate function, 14

SDO_AGGR_CONCAT_LINES aggregate function, 14

SDO_AGGR_CONVEXHULL aggregate function, 14

SDO_AGGR_LRS_CONCAT aggregate function, 14

SDO_AGGR_MBR aggregate function, 14

SDO_AGGR_UNION aggregate function, 14

SDO_ANGLE_UNITS table, 6.4.2

SDO_ANYINTERACT operator, 12

SDO_ARC_DENSIFY function, 13

SDO_AREA function, 13

SDO_AREA_UNITS table, 2.6

SDO_BUFFER function, 13

SDO_CENTROID function, 13

SDO_CONTAINS operator, 12

SDO_CONVEXHULL function, 13

SDO_COVEREDBY operator, 12

SDO_COVERS operator, 12

SDO_CS package, 15

TRANSFORM, 15

TRANSFORM_LAYER, 15

VALIDATE_WKT, 15

VIEWPORT_TRANSFORM, 15

SDO_DATUMS table, 6.4.3

SDO_DIFFERENCE function, 13

SDO_DIST_UNITS table, 2.6

SDO_DISTANCE function, 13

SDO_ELEM_INFO attribute, 2.2.4

SDO_ELEM_INFO_ARRAY type, 2.2

SDO_ELLIPSOIDS table, 6.4.4

SDO_EQUAL operator, 12

SDO_ETYPE value, 2.2.4, 2.2.4

SDO_FILTER operator, 12

SDO_GCDR package, 20

GEOCODE, 20

GEOCODE_ALL, 20

GEOCODE_AS_GEOMETRY, 20

SDO_GEO_ADDR data type and constructors, 5.2.1

SDO_GEOM package

RELATE, 13

SDO_ARC_DENSIFY, 13

SDO_AREA, 13

SDO_BUFFER, 13

SDO_CENTROID, 13

SDO_CONVEXHULL, 13

SDO_DIFFERENCE, 13

SDO_DISTANCE, 13

SDO_INTERSECTION, 13

SDO_LENGTH, 13

SDO_MAX_MBR_ORDINATE, 13

SDO_MBR, 13

SDO_MIN_MBR_ORDINATE, 13

SDO_POINTONSURFACE, 13

SDO_UNION, 13

SDO_XOR, 13

VALIDATE_GEOMETRY, 13

VALIDATE_GEOMETRY_WITH_CONTEXT, 13

VALIDATE_LAYER, 13

VALIDATE_LAYER_WITH_CONTEXT, 13

WITHIN_DISTANCE, 13

SDO_GEOMETRY object type, 2.2

embedding in user-defined type, 9.1, 9.2.2

in function-based indexes, 9.2

methods, 11, 14

SDO_GTYPE attribute, 2.2.1

constraining data to a geometry type, 4.1.4

GET_DIMS method, 11

GET_GTYPE method, 11

GET_LRS_DIM method, 11

SDO_INDEX_TABLE entry in index metadata views, 2.5.2

SDO_INDX_DIMS keyword, 7.3, 10

SDO_INSIDE operator, 12

SDO_INTERPRETATION value, 2.2.4

SDO_INTERSECTION function, 13

SDO_JOIN operator, 12

SDO_KEYWORDARRAY data type, 5.2.3

SDO_LENGTH function, 13

SDO_LRS package

CLIP_GEOM_SEGMENT, 16

CONCATENATE_GEOM_SEGMENTS, 16

CONNECTED_GEOM_SEGMENTS, 16

CONVERT_TO_LRS_DIM_ARRAY, 16

CONVERT_TO_LRS_GEOM, 16

CONVERT_TO_LRS_LAYER, 16

CONVERT_TO_STD_DIM_ARRAY, 16

CONVERT_TO_STD_GEOM, 16

CONVERT_TO_STD_LAYER, 16

DEFINE_GEOM_SEGMENT, 16

DYNAMIC_SEGMENT, 16

FIND_LRS_DIM_POS, 16

FIND_MEASURE, 16

FIND_OFFSET, 16

GEOM_SEGMENT_END_MEASURE, 16

GEOM_SEGMENT_END_PT, 16

GEOM_SEGMENT_LENGTH, 16

GEOM_SEGMENT_START_MEASURE, 16

GEOM_SEGMENT_START_PT, 16

GET_MEASURE, 16

GET_NEXT_SHAPE_PT, 16

GET_NEXT_SHAPE_PT_MEASURE, 16

GET_PREV_SHAPE_PT, 16

GET_PREV_SHAPE_PT_MEASURE, 16

IS_GEOM_SEGMENT_DEFINED, 16

IS_MEASURE_DECREASING, 16

IS_MEASURE_INCREASING, 16

IS_SHAPE_PT_MEASURE, 16

LOCATE_PT, 16

MEASURE_RANGE, 16

MEASURE_TO_PERCENTAGE, 16

OFFSET_GEOM_SEGMENT, 16

PERCENTAGE_TO_MEASURE, 16

PROJECT_PT, 16

REDEFINE_GEOM_SEGMENT, 16

RESET_MEASURE, 16

REVERSE_GEOMETRY, 16

REVERSE_MEASURE, 16

SCALE_GEOM_SEGMENT, 16

SET_PT_MEASURE, 16

SPLIT_GEOM_SEGMENT, 16

TRANSLATE_MEASURE, 16

VALID_GEOM_SEGMENT, 16

VALID_LRS_PT, 16

VALID_MEASURE, 16

VALIDATE_LRS_GEOMETRY, 16

SDO_MAX_MBR_ORDINATE function, 13

SDO_MBR function, 13

SDO_MIGRATE package

TO_CURRENT, 17

SDO_MIN_MBR_ORDINATE function, 13

SDO_NN operator, 12

optimizer hints, 12

SDO_NN_DISTANCE ancillary operator, 12

SDO_ON operator, 12

SDO_ORDINATE_ARRAY type, 2.2

SDO_ORDINATES attribute, 2.2.5

SDO_OVERLAPBDYDISJOINT operator, 12

SDO_OVERLAPBDYINTERSECT operator, 12

SDO_OVERLAPS operator, 12

SDO_POINT attribute, 2.2.3

SDO_POINT_TYPE object type, 2.2

SDO_POINTONSURFACE function, 13

SDO_PROJECTIONS table, 6.4.5

SDO_REGAGGR object type, 21, 21

SDO_REGAGGRSET object type, 21, 21

SDO_REGION object type, 21

SDO_REGIONSET object type, 21

SDO_RELATE operator, 12

SDO_ROWIDPAIR object type, 12

SDO_ROWIDSET data type, 12

SDO_RTREE_SEQ_NAME sequence object, 2.5.3

SDO_SAM package, 21

AGGREGATES_FOR_GEOMETRY, 21

AGGREGATES_FOR_LAYER, 21

BIN_GEOMETRY, 21

BIN_LAYER, 21

COLOCATED_REFERENCE_FEATURES, 21

SIMPLIFY_GEOMETRY, 21

SIMPLIFY_LAYER, 21

SPATIAL_CLUSTERS, 21

TILED_AGGREGATES, 21

TILED_BINS, 21

SDO_SRID attribute, 2.2.2

SDO_STARTING_OFFSET value, 2.2.4

SDO_TOUCH operator, 12

SDO_TUNE package

AVERAGE_MBR, 18

ESTIMATE_RTREE_INDEX_SIZE, 18

EXTENT_OF, 18

MIX_INFO, 18

QUALITY_DEGRADATION, 18

SDO_UNION function, 13

SDO_UNIT column

in SDO_AREA_UNITS table, 2.6

in SDO_DIST_UNITS table, 2.6

SDO_UTIL package

APPEND, 19

CIRCLE_POLYGON, 19

CONCAT_LINES, 19

CONVERT_UNIT, 19

ELLIPSE_POLYGON, 19

EXTRACT, 19

GETNUMELEM, 19

GETNUMVERTICES, 19

GETVERTICES, 19

INITIALIZE_INDEXES_FOR_TTS, 19

POINT_AT_BEARING, 19

POLYGONTOLINE, 19

PREPARE_FOR_TTS, 19

REMOVE_DUPLICATE_VERTICES, 19

REVERSE_LINESTRING, 19

SIMPLIFY, 19

TO_GMLGEOMETRY, 19

SDO_VERSION function, 1.15

SDO_WITHIN_DISTANCE operator, 12

SDO_XOR function, 13

SDOAGGRTYPE object type, 1.10.1

sdoapi Java client interface, 1.11

secondary filter, 1.6, 4.2.1.2

segments

geometric, 7.1.1

self-crossing line strings and polygons, 1.4

semi-major axis, 6.4.4

sequence object for R-tree index, 2.5.3

SET_PT_MEASURE procedure, 16

shape point, 7.1.2

determining if measure value is a shape point, 16

getting measure of next, 16

getting measure of previous, 16

getting next, 16

getting previous, 16

simple element, 2.2.4

simplification of geometries, 19

SIMPLIFY function, 19

SIMPLIFY_GEOMETRY function, 21

SIMPLIFY_LAYER procedure, 21

size requirements (hardware) for spatial applications, 1.16

SORT_AREA_SIZE parameter

R-tree index creation, 4.1.1

spatial aggregate functions

See aggregate functions

spatial analysis and mining

conceptual and usage information, 8

function reference information, 21

spatial binning, 8.2

See also bins

spatial clustering, 8.5

spatial correlation, 8.3

spatial data mining

function reference information, 21

spatial data structures, 2

spatial data types, 2

spatial index

See index

spatial join, 4.2.2

SDO_JOIN operator, 12

spatial operators

See operators

spatial query, 4.2.1

spatial reference systems

conceptual and usage information, 6

example, 6.8

subprogram reference information, 15

SPATIAL_CLUSTERS function, 21

sphere

authalic, 6.1.7

spheroids (ellipsoids), 6.4.4

SPLIT_GEOM_SEGMENT procedure, 16

splitting

geometric segment, 7.5.4

SQL and PL/SQL examples, 1.18

SQL statements

for indexing spatial data, 10

SQL*Loader, 3.1

SRID

0 (zero) special case with SDO_CS.VIEWPORT_TRANSFORM function, 15

in USER_SDO_GEOM_METADATA, 2.4.4

SDO_SRID attribute in SDO_GEOMETRY, 2.2.2

subprograms

coordinate system transformation, 15

data mining, 21

geocoding, 20

geometry, 13

linear referencing, 16

not supported with geodetic data, 6.7.2

SDO_MIGRATE, 17

spatial analysis, 21

tuning, 18

utility, 19

synchronizing deferred index updates, 10

T

table name

restrictions on spatial table names, 2.4.1

TABLE_NAME (in USER_SDO_GEOM_METADATA), 2.4.1

three-dimensional (3D)

formats of LRS functions, 7.4

TILED_AGGREGATES function, 21

TILED_BINS function, 21

TO_81X procedure

use TO_CURRENT instead, 17

TO_CURRENT procedure, 17

TO_GMLGEOMETRY function, 19

tolerance, 1.5.5

with LRS functions, 7.6

TOUCH

SDO_TOUCH operator, 12

topological relationship, 1.8

transactional insertion of spatial data, 3.2

TRANSFORM function, 15

TRANSFORM_LAYER procedure, 15

table for transformed layer, 15

transformation, 6.1.8

TRANSLATE_MEASURE function, 16

transportable tablespaces

initializing spatial indexes, 19

preparing for when using spatial indexes, 19

tuning and performance information, 1.14

for spatial operators, 1.9

tuning subprograms, 18

two-tier query model, 1.6

type zero (0) element, 2.3.6

U

unformatted addresses, 5.1.1

union, 13

unit of measurement

MDSYS tables, 2.6

UNIT_NAME column

in SDO_ANGLE_UNITS table, 6.4.2

in SDO_AREA_UNITS table, 2.6

in SDO_DIST_UNITS table, 2.6

upgrading

instructions and issues, A

LRS data, A.1

to current Spatial release, 17

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, 6.5

user-defined data types

embedding SDO_GEOMETRY objects in, 9.1, 9.2.2

UTF8 character set

NLS_LENGTH_SEMANTICS setting for spatial queries, 4.2

utility subprograms, 19

V

VALID_GEOM_SEGMENT function, 16

VALID_LRS_PT function, 16

VALID_MEASURE function, 16

VALIDATE_GEOMETRY function, 13

VALIDATE_GEOMETRY_WITH_CONTEXT function, 13

VALIDATE_LAYER procedure, 13

VALIDATE_LAYER_WITH_CONTEXT procedure, 13

VALIDATE_LRS_GEOMETRY function, 16

VALIDATE_WKT function, 15

version number (Spatial)

retrieving, 1.15

VERTEX_SET_TYPE data type, 19

VERTEX_TYPE object type, 19

vertices

removing duplicate, 19

returning geometry coordinates as, 19

VIEWPORT_TRANSFORM function, 15

views

ALL_SDO_GEOM_METADATA, 2.4

ALL_SDO_INDEX_INFO, 2.5.1.1

ALL_SDO_INDEX_METADATA, 2.5.1.2

USER_SDO_GEOM_METADATA, 2.4

USER_SDO_INDEX_INFO, 2.5.1.1

USER_SDO_INDEX_METADATA, 2.5.1.2

W

well-known text (WKT), 6.4.1.1

validating, 15

WITHIN_DISTANCE function, 13

See also SDO_WITHIN_DISTANCE operator

WKT

See well-known text (WKT)

WKTEXT column of MDSYS.CS_SRS table, 6.4.1.1

X

XOR

SDO_XOR function, 13

Z

zero

SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 15

type 0 element, 2.3.6