Skip Headers
Oracle® Spatial User's Guide and Reference
10g Release 2 (10.2)

Part Number B14255-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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

0
SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 13
type 0 (zero) element, 2.5.7
10g
upgrading spatial data to Oracle Database 10g, 17
3D
formats of LRS functions, 7.4
not supported with geodetic data, 6.9.2

A

ADD_PREFERENCE_FOR_OP procedure, 13
addresses
representing for geocoding, 5.1.1
aggregate functions
description, 1.10
reference information, 12
SDO_AGGR_CENTROID, 12
SDO_AGGR_CONCAT_LINES, 12
SDO_AGGR_CONVEXHULL, 12
SDO_AGGR_LRS_CONCAT, 12
SDO_AGGR_MBR, 12
SDO_AGGR_UNION, 12
SDOAGGRTYPE object type, 1.10.1
AGGREGATES_FOR_GEOMETRY function, 18
AGGREGATES_FOR_LAYER function, 18
aliases, 6.6.2
ALL_SDO_GEOM_METADATA view, 2.6
ALL_SDO_INDEX_INFO view, 2.7.1.1
ALL_SDO_INDEX_METADATA view, 2.7.1.2
ALTER INDEX statement, 10
REBUILD clause, 10
RENAME TO clause, 10
angle units, 6.7.2
ANYINTERACT
SDO_ANYINTERACT operator, 11
topological relationship, 1.8
APPEND function, 20
application size (hardware) requirements, 1.17
arc
densifying, 15
not supported with geodetic data, 6.2.4
area, 15
area units, 2.8
average minimum bounding rectangle, 19
AVERAGE_MBR procedure, 19

B

batch route requests, C.2.5.1
DTD, C.2.5
example, C.2.4
batch route responses
DTD, C.2.6
example, C.2.4
batch_route_request element, C.2.5.1
bearing
point at, 20
BIN_GEOMETRY function, 18
BIN_LAYER procedure, 18
binning
spatial, 8.2
See also bins
bins
assigning, 18
computing, 18
tiled, 18
boundary
of area, 1.8
of line string, 1.8
of multiline string, 1.8
of polygon, 1.8
bounding rectangle
minimum, 19
buffer area, 15
bulk loading of spatial data, 3.1

C

C language
examples (using OCI), 1.19
Cartesian coordinates, 1.5.4, 6.1.2
center of gravity (centroid), 15
centroid
SDO_AGGR_CENTROID aggregate function, 12
SDO_CENTROID function, 15
circle
creating polygon approximating, 20
not supported with geodetic data, 6.2.4
type, 2.2.4
CIRCLE_POLYGON function, 20
CLIP_GEOM_SEGMENT function, 16
clipping
geometric segment, 7.5.3
COLOCATED_REFERENCE_FEATURES procedure, 18
colocation mining, 8.4
column name
restrictions on spatial column names, 2.6.2
COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2.6.2
compatibility, A
complex examples
queries, D
compound element, 2.2.4
compound line string, 2.2.4, 2.5.3
compound polygon, 2.2.4
CONCAT_LINES function, 20
CONCATENATE_GEOM_SEGMENTS function, 16
concatenating
geometric segments, 7.5.5
line or multiline geometries, 12
LRS geometries, 7.5.5, 12
configuration
routing engine, C.1
CONNECTED_GEOM_SEGMENTS function, 16
consistency
checking for valid geometry types, 15
constraining data to a geometry type, 4.1.2
constructors
SDO_GEOMETRY object type, 2.4
CONTAINS
SDO_CONTAINS operator, 11
topological relationship, 1.8
CONVERSION_FACTOR column
in SDO_ANGLE_UNITS table, 6.7.2
in SDO_AREA_UNITS table, 2.8
in SDO_DIST_UNITS table, 2.8
CONVERT_NADCON_TO_XML procedure, 13
CONVERT_NTV2_TO_XML procedure, 13
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, 20
CONVERT_XML_TO_NADCON procedure, 13
CONVERT_XML_TO_NTV2 procedure, 13
converting
geometric segments
overview, 7.5.10
subprograms for, 16
convex hull
SDO_AGGR_CONVEXHULL aggregate function, 12
SDO_CONVEXHULL function, 15
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.6
example, 6.11
local, 6.3
subprogram reference information, 13
unit of measurement support, 2.8
user-defined, 6.8
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, 11
topological relationship, 1.8
COVERS
SDO_COVERS operator, 11
topological relationship, 1.8
CPU requirements for applications using Spatial, 1.17
CREATE INDEX statement, 10
CREATE_CONCATENATED_OP procedure, 13
CREATE_OBVIOUS_EPSG_RULES procedure, 13
CREATE_PREF_CONCATENATED_OP procedure, 13
creating
geometric segments
subprograms for, 16
cross-schema index creation, 4.1.3
CS_SRS table, 6.7.1
current release
upgrading spatial data to, 17
cutoff_distance attribute
of batch route request, C.2.5.2

D

data mining
spatial
colocation mining, 8.4
conceptual and usage information, 8
function reference information, 18
data model, 1.5
LRS, 7.2
data types
geocoding, 5.2
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_OLD_FORMAT table, 6.7.3
MDSYS.SDO_DATUMS_OLD_SNAPSHOT table, 6.7.3
transformation, 6.1.7
dblink
not supported if spatial index is defined on the table, 4.2
DEFINE_GEOM_SEGMENT procedure, 16
defining
geometric segment, 7.5.1
DELETE_ALL_EPSG_RULES procedure, 13
DELETE_OP procedure, 13
densification of arcs, 15
DETERMINE_CHAIN function, 13
DETERMINE_DEFAULT_CHAIN function, 13
difference
SDO_GEOM.SDO_DIFFERENCE function, 15
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.6.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 applications using Spatial, 1.17
distance
SDO_NN_DISTANCE ancillary operator, 11
WITHIN_DISTANCE function, 15
distance units, 2.8
distance_unit attribute
of route request, C.2.2.2
Douglas-Peucker algorithm for geometry simplification, 20
downgrading
Oracle Spatial to the previous Oracle Database release, A
driving directions
in route request, C.2.2.2
not allowed for batch route request, C.2.5.2
DROP INDEX statement, 10
duplicate vertices
removing, 20
dynamic query window, 4.2.1
DYNAMIC_SEGMENT function, 16

E

EDGE table
routing engine use of, C.3.1
editing
geometric segments
subprograms for, 16
ELEM_INFO (SDO_ELEM_INFO attribute), 2.2.4
elements, 1.5.1
extracting from a geometry, 20
returning number of elements in a geometry, 20
returning number of vertices in a geometry, 20
ellipse
creating polygon approximating, 20
ELLIPSE_POLYGON function, 20
ellipsoids
MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table, 6.7.4
MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.7.4
embedded SDO_GEOMETRY object in user-defined type, 9.1
end location for route, C.2.2.1
EPSG, 6.6
EPSG SRID
mapping Oracle SRID to, 13
mapping to Oracle SRID, 13
EQUAL
SDO_EQUAL operator, 11
topological relationship, 1.8
error messages
geocoding, 5.1.4
Spatial, 1.18
ESTIMATE_RTREE_INDEX_SIZE function, 19
ETYPE (SDO_ETYPE value), 2.2.4, 2.2.4
European Petroleum Survey Group
See EPSG
examples
batch route request and response, C.2.4
C, 1.19
complex queries, D
coordinate systems, 6.11
creating, indexing, and querying spatial data, 2.1
directory for Spatial examples, 1.19
linear referencing system (LRS), 7.7
many geometry types (creating), 2.5
OCI (Oracle Call Interface), 1.19
PL/SQL, 1.19
route request and response, C.2.1
route request with previously geocoded locations, C.2.1
route response with previously geocoded locations, C.2.1
SQL, 1.19
exchanging partitions including indexes, 4.1.5
Export utility
with spatial indexes and data, 4.1.6
EXTENT_OF function, 19
exterior polygon rings, 2.2.4, 2.2.4, 2.5.2, 2.5.2
EXTRACT function, 20

F

features
linear, 7.1.10
FILTER
SDO_FILTER operator, 11
FILTER mask value for SDO_JOIN, 11
FIND_GEOG_CRS function, 13
FIND_LRS_DIM_POS function, 16
FIND_MEASURE function, 16
FIND_OFFSET function, 16
FIND_PROJ_CRS function, 13
formatted addresses, 5.1.1
FROM_815_TO_81X procedure
use TO_CURRENT instead, 17
FROM_OGC_SIMPLEFEATURE_SRS function, 13
FROM_USNG function, 13
FROM_WKBGEOMETRY function, 20
FROM_WKTGEOMETRY function, 20
function-based indexes
with SDO_GEOMETRY objects, 9.2
functions
spatial aggregate, 12
supported by approximations with geodetic data, 6.9.3

G

GC_AREA_<suffix> table, 5.5.1
GC_COUNTRY_PROFILE table, 5.5.2
GC_INTERSECTION_<suffix> table, 5.5.3
GC_POI_<suffix> table, 5.5.4
GC_POSTAL_CODE_<suffix> table, 5.5.5
GC_ROAD_<suffix> table, 5.5.6
GC_ROAD_SEGMENT_<suffix> table, 5.5.7
GEOCODE function, 14
GEOCODE_ADDR function, 14
GEOCODE_ADDR_ALL function, 14
GEOCODE_ALL function, 14
GEOCODE_AS_GEOMETRY function, 14
geocoding, 1.11
concepts, 5.1
data requirements, 5.3
data types for, 5.2
error messages, 5.1.4
from a place name, 5.4
match codes, 5.1.3
match modes, 5.1.2
reverse, 14
subprogram reference information, 14
usage information, 5
geocoding requests
DTD, C.2.7.1
geocoding responses
DTD, C.2.7.2
geodetic coordinates, 1.5.4, 6.1.3
arcs and circles not supported, 6.2.4
functions supported by approximations, 6.9.3
support for, 6.2
geodetic datum, 1.5.4, 6.1.6
geodetic indexes, 4.1.1
geodetic MBRs, 6.2.3
geographic coordinates
See geodetic coordinates
geography markup language (GML)
converting geometry to, 20
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, 12
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, 15
geometry types, 1.4
constraining data to, 4.1.2
Get_GType method, 2.3
SDO_GTYPE, 2.2.1
GeoRaster
checks and actions after upgrade, A.2
Get_Dims method, 2.3
Get_GType method, 2.3
Get_LRS_Dim method, 2.3
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
Get_WKB method, 2.3
Get_WKT method, 2.3
GETNUMELEM function, 20
GETNUMVERTICES function, 20
GETVERTICES function, 20
GML (geography markup language)
converting geometry to, 20
GTYPE (SDO_GTYPE attribute), 2.2.1
constraining data to a geometry type, 4.1.2
Get_Dims method, 2.3
Get_GType method, 2.3
GET_LRS_Dim method, 2.3

H

hardware requirements for applications using Spatial, 1.17

I

id attribute
of route request, C.2.2.2
Import utility
with spatial indexes and data, 4.1.6
indexes
creating, 4.1
cross-schema, 4.1.3
parallel execution, 10
description of Spatial indexing, 1.7
extending spatial indexing capabilities, 9
function-based with SDO_GEOMETRY objects, 9.2
geodetic and non-geodetic, 4.1.1
partitioned, 4.1.4
exchanging partitions including indexes, 4.1.5
quadtree
deprecated feature of Spatial, 1.7
rebuilding, 10
parallel execution, 10, 10
R-tree
description, 1.7.1
requirements before creating, 4.1
size (R-tree), 19
index-organized table
cannot create spatial index on, 2.6.1, 10
INITIALIZE_INDEXES_FOR_TTS procedure, 20
input_location element, C.2.2.3
inserting spatial data
PL/SQL, 3.2
INSIDE
SDO_INSIDE operator, 11
topological relationship, 1.8
installation, A
interMedia requirement for Locator, B
routing engine, C.1
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.5.2, 2.5.2
interMedia
proper installation required for Locator, B
intersection, 15
intersections
GC_INTERSECTION_<suffix> table, 5.5.3
inverse flattening, 6.6.23, 6.7.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 application programming interface (API) for Spatial, 1.12
join
SDO_JOIN operator, 11

L

language attribute
of route request, C.2.2.2
layer, 1.5.3
transforming, 13
validating with context, 15
layer_gtype
constraining data to a geometry type, 4.1.2
length
SDO_LENGTH function, 15
line
converting polygon to, 20
data, 1.5.1
length, 15
line string
boundary of, 1.8
compound, 2.2.4, 2.5.3
reversing, 20
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.9.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, 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 indexes, 4.1.4
LOCATE_PT function, 16
location prospecting, 8.6
Locator, B
LRS
See linear referencing system (LRS)
LRS points, 7.1.9

M

map projections
MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.7.5
MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.7.5
MAP_EPSG_SRID_TO_ORACLE function, 13
MAP_ORACLE_SRID_TO_EPSG function, 13
match codes, 5.1.3
match modes, 5.1.2
MBR
See minimum bounding rectangle (MBR)
MDDATA schema, 1.13
MDSYS schema, 1.1
MDSYS.CS_SRS table, 6.7.1
MDSYS.SDO_ANGLE_UNITS table, 6.7.2
MDSYS.SDO_AREA_UNITS table, 2.8
MDSYS.SDO_CS package, 13
MDSYS.SDO_DATUMS_OLD_FORMAT table, 6.7.3
MDSYS.SDO_DATUMS_OLD_SNAPSHOT table, 6.7.3
MDSYS.SDO_DIST_UNITS table, 2.8
MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table, 6.7.4
MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.7.4
MDSYS.SDO_GCDR package, 14
MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.7.5
MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.7.5
MDSYS.SDO_SAM package, 18
measure, 7.1.4
populating, 7.1.6
resetting, 16
reversing, 16
with multiline strings and polygons with holes, 7.1.11
measure range, 7.1.7
MEASURE_RANGE function, 16
MEASURE_TO_PERCENTAGE function, 16
messages
Spatial error messages, 1.18
methods
SDO_GEOMETRY object type, 2.3
migration
See upgrading
minimum bounding rectangle (MBR)
AVERAGE_MBR procedure, 19
EXTENT_OF function, 19
geodetic, 6.2.3
SDO_AGGR_MBR aggregate function, 12
SDO_MAX_MBR_ORDINATE function, 15
SDO_MBR function, 15
SDO_MIN_MBR_ORDINATE function, 15
mining
See data mining
MIX_INFO procedure, 19
multiline string
boundary of, 1.8
LRS measure values, 7.1.11
multimaster replication
SDO_GEOMETRY objects, B
multipolygon, 2.5.2

N

NaC coordinate reference system, 6.9.4
NADCON grids
converting Spatial XML format to NADCON format, 13
converting to Spatial XML format, 13
naming considerations
Spatial table and column names, 2.6
nearest neighbor
SDO_NN operator, 11
SDO_NN_DISTANCE operator, 11
neighborhood influence, 8.3
NLS_LENGTH_SEMANTICS parameter
spatial queries on UTF8 data, 4.2
NODE table
routing engine use of, C.3.2
non-geodetic indexes, 4.1.1
NTv2 grids
converting Spatial XML format to NTv2 format, 13
converting to Spatial XML format, 13

O

object types
embedding SDO_GEOMETRY objects in, 9.1, 9.2.2
OCG (Open Geospatial Consortium) simple features conformance, 1.15
OCI (Oracle Call Interface) examples, 1.19
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
ON
SDO_ON operator, 11
topological relationship, 1.8
Open Geospatial Consortium (OCG) simple features conformance, 1.15
operators
cross-schema invocation, 4.2.3
ORDERED optimizer hint with, 1.9
SDO_FILTER, 11
SDO_JOIN, 11
overview, 1.9
performance-related guidelines, 1.9
SDO_ANYINTERACT, 11
SDO_CONTAINS, 11
SDO_COVEREDBY, 11
SDO_COVERS, 11
SDO_EQUAL, 11
SDO_FILTER, 11
SDO_INSIDE, 11
SDO_JOIN, 11
SDO_NN, 11
SDO_NN_DISTANCE, 11
SDO_ON, 11
SDO_OVERLAPBDYDISJOINT, 11
SDO_OVERLAPBDYINTERSECT, 11
SDO_OVERLAPS, 11
SDO_RELATE, 11
SDO_TOUCH, 11
SDO_WITHIN_DISTANCE, 11
optimized rectangle, 2.2.4
optimizer hint (ORDERED) with spatial operators, 1.9
SDO_FILTER, 11
SDO_JOIN, 11
Oracle Call Interface (OCI) examples, 1.19
Oracle Data Mining (ODM)
spatial analysis and mining information, 8
Oracle Database 10g
upgrading Spatial to, A
Oracle Locator
See Locator
ORDERED optimizer hint with spatial operators, 1.9
SDO_FILTER, 11
SDO_JOIN, 11
oriented point
illustration and example, 2.5.6
OVERLAPBDYDISJOINT
SDO_OVERLAPBDYDISJOINT operator, 11
topological relationship, 1.8
OVERLAPBDYINTERSECT
SDO_OVERLAPBDYINTERSECT operator, 11
topological relationship, 1.8
OVERLAPS
SDO_OVERLAPS operator, 11

P

parallel execution for index creation and rebuilding, 10, 10, 10
PARTITION table
routing engine use of, C.3.3
partitioned spatial indexes, 4.1.4
exchanging partitions, 4.1.5
PERCENTAGE_TO_MEASURE function, 16
performance and tuning information, 1.14
for Spatial operators, 1.9
PL/SQL and SQL examples, 1.19
point
data, 1.5.1
illustration and examples of point-only geometry, 2.5.5
locating on geometric segment, 7.5.8
LRS, 7.1.9
on surface of polygon, 15
oriented point, 2.5.6
projection of onto geometric segment, 7.1.8, 7.5.9
shape, 7.1.2
point of interest (POI)
GC_POI_<suffix> table, 5.5.4
POINT_AT_BEARING function, 20
polygon
area of, 15
boundary of, 1.8
buffer, 15
centroid, 15
compound, 2.2.4
exterior and interior rings, 2.2.4, 2.2.4, 2.5.2, 2.5.2
point on surface, 15
self-crossing not supported, 1.4
with hole (LRS measure values), 7.1.11
polygon collection, 2.5.2
polygon data, 1.5.1
POLYGONTOLINE function, 20
populating
measure, 7.1.6
pre_geocoded_location element, C.2.2.4
pre_geocoded_locations attribute
of route request, C.2.2.2
PREPARE_FOR_TTS procedure, 20
primary filter, 1.6, 4.2.1.1, 4.2.1.2
primitive types, 1.4
problems in current release, 6.9
geodetic data, 6.2.4
PROJECT_PT function, 16
projected coordinates, 1.5.4, 6.1.4
projections, 7.1.8, 7.5.9
MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.7.5
MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.7.5
PROJECT_PT function, 16

Q

quadtree indexes
deprecated feature of Spatial, 1.7
quality
degradation of R-tree index, 19
R-tree, 1.7.2
QUALITY_DEGRADATION function, 19
query, 4.2.1
query model for Spatial, 1.6
query window, 4.2.1
querying geometric segments
subprograms for, 16

R

range
measure, 7.1.7
README file
for Spatial, GeoRaster, and topology and network data models, 1.20
rebuilding
spatial indexes, 10
rectangle
minimum bounding, 19
type, 2.2.4
rectification of geometries, 20
RECTIFY_GEOMETRY function, 20
REDEFINE_GEOM_SEGMENT procedure, 16
redefining
geometric segment, 7.5.2
RELATE function, 15
See also SDO_RELATE operator
release number (Spatial)
retrieving, 1.16
REMOVE_DUPLICATE_VERTICES function, 20
replication
multimaster, B
object, B
RESET_MEASURE procedure, 16
restrictions in current release, 6.9
geodetic data, 6.2.4
return_driving_directions attribute
of batch route request, C.2.5.2
of route request, C.2.2.2
return_route_geometry attribute
of batch route request, C.2.5.2
of route request, C.2.2.2
return_segment_geometry attribute
of batch route request, C.2.5.2
of route request, C.2.2.2
reverse geocoding, 14
REVERSE_GEOCODE function, 14
REVERSE_GEOMETRY function, 16
REVERSE_LINESTRING function, 20
REVERSE_MEASURE function, 16
REVOKE_PREFERENCE_FOR_OP procedure, 13
ring
exterior and interior polygon, 2.2.4
extracting from a geometry, 20
road segments
GC_ROAD_SEGMENT_<suffix> table, 5.5.7
road_preference attribute
of batch route request, C.2.5.2
of route request, C.2.2.2
roads
GC_ROAD_<suffix> table, 5.5.6
rollback segment
R-tree index creation, 4.1
route geometry
in route request, C.2.2.2
route requests, C.2.2.1
DTD, C.2.2
example, C.2.1
previously geocoded locations, C.2.1
input_location element, C.2.2.3
pre_geocoded_location element, C.2.2.4
route responses
DTD, C.2.3
example, C.2.1
previously geocoded locations, C.2.1
route_preference attribute
of route request, C.2.2.2
route_request element, C.2.2.1
RouteServer.zip file, C.1
routing engine
configuring, C.1
data structures used by, C.3
installing, C.1
kit for, C.1
overview, C
XML API, C.2
R-tree indexes
description of indexing process, 1.7.1
quality degradation, 19
rebuilding, 10
requirements before creating, 4.1
sequence object, 2.7.3
when to use, 1.7
R-tree quality, 1.7.2

S

scaling
geometric segment, 7.5.6
schemas
creating index on table in another schema, 4.1.3
invoking operators on table in another schema, 4.2.3
SDO_ADDR_ARRAY data type, 5.2.2
SDO_AGGR_CENTROID aggregate function, 12
SDO_AGGR_CONCAT_LINES 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
complex examples, D.4
SDO_ANGLE_UNITS table, 6.7.2
SDO_ANYINTERACT operator, 11
SDO_ARC_DENSIFY function, 15
SDO_AREA function, 15
SDO_AREA_UNITS table, 2.8
SDO_BUFFER function, 15
SDO_CENTROID function, 15
SDO_CONTAINS operator, 11
SDO_CONVEXHULL function, 15
SDO_COORD_AXES table, 6.6.1
SDO_COORD_AXIS_NAMES table, 6.6.2
SDO_COORD_OP_METHODS table, 6.6.3
SDO_COORD_OP_PARAM_USE table, 6.6.4
SDO_COORD_OP_PARAM_VALS table, 6.6.5
SDO_COORD_OP_PARAMS table, 6.6.6
SDO_COORD_OP_PATHS table, 6.6.7
SDO_COORD_OPS table, 6.6.8
SDO_COORD_REF_SYS table, 6.6.9
SDO_COORD_REF_SYSTEM view, 6.6.10
SDO_COORD_SYS table, 6.6.11
SDO_COVEREDBY operator, 11
SDO_COVERS operator, 11
SDO_CRS_COMPOUND view, 6.6.12
SDO_CRS_ENGINEERING view, 6.6.13
SDO_CRS_GEOCENTRIC view, 6.6.14
SDO_CRS_GEOGRAPHIC2D view, 6.6.15
SDO_CRS_GEOGRAPHIC3D view, 6.6.16
SDO_CRS_PROJECTED view, 6.6.17
SDO_CRS_VERTICAL view, 6.6.18
SDO_CS package, 13
ADD_PREFERENCE_FOR_OP, 13
CONVERT_NADCON_TO_XML, 13
CONVERT_NTV2_TO_XML, 13
CONVERT_XML_TO_NADCON, 13
CONVERT_XML_TO_NTV2, 13
CREATE_CONCATENATED_OP, 13
CREATE_OBVIOUS_EPSG_RULES, 13
CREATE_PREF_CONCATENATED_OP, 13
DELETE_ALL_EPSG_RULES, 13
DELETE_OP, 13
DETERMINE_CHAIN, 13
DETERMINE_DEFAULT_CHAIN, 13
FIND_GEOG_CRS, 13
FIND_PROJ_CRS, 13
FROM_OGC_SIMPLEFEATURE_SRS, 13
FROM_USNG, 13
MAP_EPSG_SRID_TO_ORACLE, 13
MAP_ORACLE_SRID_TO_EPSG, 13
REVOKE_PREFERENCE_FOR_OP, 13
TO_OGC_SIMPLEFEATURE_SRS, 13
TO_USNG, 13
TRANSFORM, 13
TRANSFORM_LAYER, 13
UPDATE_WKTS_FOR_ALL_EPSG_CRS, 13
UPDATE_WKTS_FOR_EPSG_CRS, 13
UPDATE_WKTS_FOR_EPSG_DATUM, 13
UPDATE_WKTS_FOR_EPSG_ELLIPS, 13
UPDATE_WKTS_FOR_EPSG_OP, 13
UPDATE_WKTS_FOR_EPSG_PARAM, 13
UPDATE_WKTS_FOR_EPSG_PM, 13
VALIDATE_WKT, 13
VIEWPORT_TRANSFORM, 13
SDO_DATUM_ENGINEERING view, 6.6.19
SDO_DATUM_GEODETIC view, 6.6.20
SDO_DATUM_VERTICAL view, 6.6.21
SDO_DATUMS table, 6.6.22
SDO_DATUMS_OLD_FORMAT table, 6.7.3
SDO_DATUMS_OLD_SNAPSHOT table, 6.7.3
SDO_DIFFERENCE function, 15
SDO_DIST_UNITS table, 2.8
SDO_DISTANCE function, 15
SDO_ELEM_INFO attribute, 2.2.4
SDO_ELEM_INFO_ARRAY type, 2.2
SDO_ELLIPSOIDS table, 6.6.23
SDO_ELLIPSOIDS_OLD_FORMAT table, 6.7.4
SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.7.4
SDO_EQUAL operator, 11
SDO_ETYPE value, 2.2.4, 2.2.4
SDO_FILTER operator, 11
SDO_GCDR package, 14
GEOCODE, 14
GEOCODE_ADDR, 14
GEOCODE_ADDR_ALL, 14
GEOCODE_ALL, 14
GEOCODE_AS_GEOMETRY, 14
REVERSE_GEOCODE, 14
SDO_GEO_ADDR data type and constructors, 5.2.1
SDO_GEOM package
RELATE, 15
SDO_ARC_DENSIFY, 15
SDO_AREA, 15
SDO_BUFFER, 15
SDO_CENTROID, 15
SDO_CONVEXHULL, 15
SDO_DIFFERENCE, 15
SDO_DISTANCE, 15
SDO_INTERSECTION, 15
SDO_LENGTH, 15
SDO_MAX_MBR_ORDINATE, 15
SDO_MBR, 15
SDO_MIN_MBR_ORDINATE, 15
SDO_POINTONSURFACE, 15
SDO_UNION, 15
SDO_XOR, 15
VALIDATE_GEOMETRY_WITH_CONTEXT, 15
VALIDATE_LAYER_WITH_CONTEXT, 15
WITHIN_DISTANCE, 15
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, 4.1.2
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.7.2
SDO_INDX_DIMS keyword, 7.3, 10
SDO_INSIDE operator, 11
SDO_INTERPRETATION value, 2.2.4
SDO_INTERSECTION function, 15
SDO_JOIN operator, 11
SDO_KEYWORDARRAY data type, 5.2.3
SDO_LENGTH function, 15
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
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, 15
SDO_MBR function, 15
SDO_MIGRATE package
TO_CURRENT, 17
SDO_MIN_MBR_ORDINATE function, 15
SDO_NN operator, 11
complex examples, D.3
optimizer hints, 11
SDO_NN_DISTANCE ancillary operator, 11
SDO_NN_DISTANCE operator
complex examples, D.3
SDO_ON operator, 11
SDO_ORDINATE_ARRAY type, 2.2
SDO_ORDINATES attribute, 2.2.5
SDO_OVERLAPBDYDISJOINT operator, 11
SDO_OVERLAPBDYINTERSECT operator, 11
SDO_OVERLAPS operator, 11
SDO_POINT attribute, 2.2.3
SDO_POINT_TYPE object type, 2.2
SDO_POINTONSURFACE function, 15
SDO_PREFERRED_OPS_SYSTEM table, 6.6.24
SDO_PREFERRED_OPS_USER table, 6.6.25
SDO_PRIME_MERIDIANS table, 6.6.26
SDO_PROJECTIONS_OLD_FORMAT table, 6.7.5
SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.7.5
SDO_REGAGGR object type, 18, 18
SDO_REGAGGRSET object type, 18, 18
SDO_REGION object type, 18
SDO_REGIONSET object type, 18
SDO_RELATE operator, 11
SDO_ROWIDPAIR object type, 11
SDO_ROWIDSET data type, 11
SDO_RTREE_SEQ_NAME sequence object, 2.7.3
SDO_SAM package, 18
AGGREGATES_FOR_GEOMETRY, 18
AGGREGATES_FOR_LAYER, 18
BIN_GEOMETRY, 18
BIN_LAYER, 18
COLOCATED_REFERENCE_FEATURES, 18
SIMPLIFY_GEOMETRY, 18
SIMPLIFY_LAYER, 18
SPATIAL_CLUSTERS, 18
TILED_AGGREGATES, 18
TILED_BINS, 18
SDO_SRID attribute, 2.2.2
SDO_STARTING_OFFSET value, 2.2.4
SDO_TFM_CHAIN type, 6.5
SDO_TOUCH operator, 11
SDO_TUNE package
AVERAGE_MBR, 19
ESTIMATE_RTREE_INDEX_SIZE, 19
EXTENT_OF, 19
MIX_INFO, 19
QUALITY_DEGRADATION, 19
SDO_UNION function, 15
SDO_UNIT column
in SDO_AREA_UNITS table, 2.8
in SDO_DIST_UNITS table, 2.8
SDO_UNITS_OF_MEASURE table, 6.6.27
SDO_UTIL package
APPEND, 20
CIRCLE_POLYGON, 20
CONCAT_LINES, 20
CONVERT_UNIT, 20
ELLIPSE_POLYGON, 20
EXTRACT, 20
FROM_WKBGEOMETRY, 20
FROM_WKTGEOMETRY, 20
GETNUMELEM, 20
GETNUMVERTICES, 20
GETVERTICES, 20
INITIALIZE_INDEXES_FOR_TTS, 20
POINT_AT_BEARING, 20
POLYGONTOLINE, 20
PREPARE_FOR_TTS, 20
RECTIFY_GEOMETRY, 20
REMOVE_DUPLICATE_VERTICES, 20
REVERSE_LINESTRING, 20
SIMPLIFY, 20
TO_GMLGEOMETRY, 20
TO_WKBGEOMETRY, 20
TO_WKTGEOMETRY, 20
VALIDATE_WKBGEOMETRY, 20
VALIDATE_WKTGEOMETRY, 20
SDO_VERSION function, 1.16
SDO_WITHIN_DISTANCE operator, 11
complex examples, D.2
SDO_XOR function, 15
SDOAGGRTYPE object type, 1.10.1
secondary filter, 1.6, 4.2.1.2
segment geometry
in route request, C.2.2.2
segments
geometric, 7.1.1
self-crossing line strings and polygons, 1.4
semi-major axis, 6.6.23, 6.7.4
semi-minor axis, 6.6.23
sequence object for R-tree index, 2.7.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
SIGN_POST table
routing engine use of, C.3.4
simple element, 2.2.4
simple features (OGC)
Oracle Spatial conformance, 1.15
simplification of geometries, 20
SIMPLIFY function, 20
SIMPLIFY_GEOMETRY function, 18
SIMPLIFY_LAYER procedure, 18
size requirements (hardware) for spatial applications, 1.17
SORT_AREA_SIZE parameter
R-tree index creation, 4.1
sort_by_distance attribute
of batch route request, C.2.5.2
spatial aggregate functions
See aggregate functions
spatial analysis and mining
conceptual and usage information, 8
function reference information, 18
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, 18
spatial data structures, 2
spatial data types, 2
spatial index
See index
spatial join, 4.2.2
SDO_JOIN operator, 11
spatial operators
See operators
spatial query, 4.2.1
spatial reference systems
conceptual and usage information, 6
example, 6.11
subprogram reference information, 13
spatial routing engine
See routing engine
SPATIAL_CLUSTERS function, 18
spheroids
MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table, 6.7.4
MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.7.4
SPLIT_GEOM_SEGMENT procedure, 16
splitting
geometric segment, 7.5.4
SQL and PL/SQL examples, 1.19
SQL Multimedia
FROM_WKBGEOMETRY function, 20
FROM_WKTGEOMETRY function, 20
TO_WKBGEOMETRY function, 20
TO_WKTGEOMETRY function, 20
VALIDATE_WKBGEOMETRY function, 20
VALIDATE_WKTGEOMETRY function, 20
SQL Multimedia standard
ST_CoordDim method, 2.3
ST_IsValid method, 2.3
SQL statements
for indexing spatial data, 10
SQL*Loader, 3.1
SRID
0 (zero) special case with SDO_CS.VIEWPORT_TRANSFORM function, 13
in USER_SDO_GEOM_METADATA, 2.6.4
mapping Oracle to EPSG, 13
SDO_SRID attribute in SDO_GEOMETRY, 2.2.2
ST_CoordDim method, 2.3
ST_IsValid method, 2.3
start location for route, C.2.2.1
subprograms
coordinate system transformation, 13
data mining, 18
geocoding, 14
geometry, 15
linear referencing, 16
SDO_MIGRATE, 17
spatial analysis, 18
tuning, 19
utility, 20

T

table names
restrictions on spatial table names, 2.6.1
TABLE_NAME (in USER_SDO_GEOM_METADATA), 2.6.1
TFM_PLAN object type, 6.5
three-dimensional (3D)
formats of LRS functions, 7.4
not supported with geodetic data, 6.9.2
TILED_AGGREGATES function, 18
TILED_BINS function, 18
time_unit attribute
of route request, C.2.2.2
TO_81X procedure
use TO_CURRENT instead, 17
TO_CURRENT procedure and function, 17
TO_GMLGEOMETRY function, 20
TO_OGC_SIMPLEFEATURE_SRS function, 13
TO_USNG function, 13
TO_WKBGEOMETRY function, 20
TO_WKTGEOMETRY function, 20
tolerance, 1.5.5
with LRS functions, 7.6
TOUCH
SDO_TOUCH operator, 11
topological relationship, 1.8
transactional insertion of spatial data, 3.2
TRANSFORM function, 13
TRANSFORM_LAYER procedure, 13
table for transformed layer, 13
transformation, 6.1.7
TRANSLATE_MEASURE function, 16
transportable tablespaces
initializing spatial indexes, 20
preparing for when using spatial indexes, 20
tuning and performance information, 1.14
for spatial operators, 1.9
tuning subprograms, 19
two-tier query model, 1.6
type zero (0) element, 2.5.7

U

unformatted addresses, 5.1.1
union, 15
unit of measurement
MDSYS tables, 2.8
UNIT_NAME column
in SDO_ANGLE_UNITS table, 6.7.2
in SDO_AREA_UNITS table, 2.8
in SDO_DIST_UNITS table, 2.8
unknown CRS coordinate reference system, 6.9.4
UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure, 13
UPDATE_WKTS_FOR_EPSG_CRS procedure, 13
UPDATE_WKTS_FOR_EPSG_DATUM procedure, 13
UPDATE_WKTS_FOR_EPSG_ELLIPS procedure, 13
UPDATE_WKTS_FOR_EPSG_OP procedure, 13
UPDATE_WKTS_FOR_EPSG_PARAM procedure, 13
UPDATE_WKTS_FOR_EPSG_PM procedure, 13
upgrading
data to current Spatial release, 17
GeoRaster, A.2
LRS data, A.1
Spatial to current Oracle Database release, A
U.S. National Grid
SDO_CS.FROM_USNG function, 13
SDO_CS.TO_USNG function, 13
support in Oracle Spatial, 6.10
use cases
for coordinate system transformation, 6.4
USER_SDO_GEOM_METADATA view, 2.6
USER_SDO_INDEX_INFO view, 2.7.1.1
USER_SDO_INDEX_METADATA view, 2.7.1.2
user-defined coordinate reference system, 6.8
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, 20

V

VALID_GEOM_SEGMENT function, 16
VALID_LRS_PT function, 16
VALID_MEASURE function, 16
VALIDATE_GEOMETRY_WITH_CONTEXT function, 15
VALIDATE_LAYER_WITH_CONTEXT procedure, 15
VALIDATE_LRS_GEOMETRY function, 16
VALIDATE_WKBGEOMETRY function, 20
VALIDATE_WKT function, 13
VALIDATE_WKTGEOMETRY function, 20
vendor attribute
of route request, C.2.2.2
version number (Spatial)
retrieving, 1.16
VERTEX_SET_TYPE data type, 20
VERTEX_TYPE object type, 20
vertices
maximum number in SDO_GEOMETRY object, 2.2
removing duplicate, 20
returning geometry coordinates as, 20
VIEWPORT_TRANSFORM function, 13
views
ALL_SDO_GEOM_METADATA, 2.6
ALL_SDO_INDEX_INFO, 2.7.1.1
ALL_SDO_INDEX_METADATA, 2.7.1.2
USER_SDO_GEOM_METADATA, 2.6
USER_SDO_INDEX_INFO, 2.7.1.1
USER_SDO_INDEX_METADATA, 2.7.1.2

W

well-known binary (WKB)
See WKB
well-known text (WKT)
See WKT
WITHIN_DISTANCE function, 15
See also SDO_WITHIN_DISTANCE operator
WKB
FROM_WKBGEOMETRY function, 20
Get_WKB method, 2.3
TO_WKBGEOMETRY function, 20
VALIDATE_WKBGEOMETRY function, 20
WKT, 6.7.1.1
FROM_WKTGEOMETRY function, 20
Get_WKT method, 2.3
procedures for updating, 6.7.1.2
TO_WKTGEOMETRY function, 20
UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure, 13
UPDATE_WKTS_FOR_EPSG_CRS procedure, 13
UPDATE_WKTS_FOR_EPSG_DATUM procedure, 13
UPDATE_WKTS_FOR_EPSG_ELLIPS procedure, 13
UPDATE_WKTS_FOR_EPSG_OP procedure, 13
UPDATE_WKTS_FOR_EPSG_PARAM procedure, 13
UPDATE_WKTS_FOR_EPSG_PM procedure, 13
VALIDATE_WKTGEOMETRY function, 20
validating (given SRID), 13
WKTEXT column of MDSYS.CS_SRS table, 6.7.1.1
procedures for updating value, 6.7.1.2

X

XML API
routing engine, C.2
XOR
SDO_XOR function, 15

Z

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