Skip Headers
Oracle® Spatial and Graph Developer's Guide
12c Release 1 (12.1)

E17896-14
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
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

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

Numerics

0
type 0 (zero) element, 2.7.7
3D
formats of LRS functions, 7.4
not supported with geodetic data, 6.10.2
spatial objects, 1.11
solids, 1.11.2
surfaces, 1.11.1

A

ADD_PREFERENCE_FOR_OP procedure, 21
addresses
representing for geocoding, 11.1.1
affine transformation
of input geometry, 32
AFFINETRANSFORMS procedure, 32
aggregate functions
description, 1.10
reference information, 20
SDO_AGGR_CENTROID, 20
SDO_AGGR_CONCAT_LINES, 20
SDO_AGGR_CONVEXHULL, 20
SDO_AGGR_LRS_CONCAT, 20
SDO_AGGR_MBR, 20
SDO_AGGR_SET_UNION, 20
SDO_AGGR_UNION, 20
SDOAGGRTYPE object type, 1.10.1
AGGREGATES_FOR_GEOMETRY function, 29
AGGREGATES_FOR_LAYER function, 29
aliases, 6.7.2
ALL_ANNOTATION_TEXT_METADATA view, 3.5.2
ALL_SDO_3DTHEMES view, 2.9.1
ALL_SDO_GEOM_METADATA view, 2.8
ALL_SDO_INDEX_INFO view, 2.10.1.1
ALL_SDO_INDEX_METADATA view, 2.10.1.2
ALL_SDO_SCENES view, 2.9.2
ALL_SDO_VIEWFRAMES view, 2.9.3
alpha shape
SDO_ALPHA_SHAPE function, 24
ALTER INDEX statement, 18
REBUILD clause, 18
RENAME TO clause, 18
angle units, 6.8.2
annotation text, 3.5
ANYINTERACT
SDO_ANYINTERACT operator, 19
topological relationship, 1.8
APPEND function, 32
application size (hardware) requirements, 1.22
application user management
identity propagation option, 17.1.1
arc
densifying, 24
not supported with geodetic data or for transformations, 6.2.5
area, 24
area units, 6.8.3
average minimum bounding rectangle, 31
AVERAGE_MBR procedure, 31

B

batch route requests, 13.3.5.1
DTD, 13.3.5
example, 13.3.4
batch route responses
DTD, 13.3.6
example, 13.3.4
batch_route_request element, 13.3.5.1
bearing
point at, 32
tilt for points, 32
BEARING_TILT_FOR_POINTS procedure, 32
BIN_GEOMETRY function, 29
BIN_LAYER procedure, 29
binning
spatial, 8.2
bins
assigning, 29
computing, 29
tiled, 29
block table
getting for theme, 32
boundary
of area, 1.8
of line string, 1.8
of multiline string, 1.8
of polygon, 1.8
bounding rectangle
minimum, 31
box
optimized, 2.2.4
British Grid Transformation OSTN02/OSGM02, 6.9.7
buffer area, 24
bulk loading of spatial data, 4.1
business directory (YP)
data requirements and providers, 12.2
data structures for, 12.3
OpenLS service support and examples, 14.3.4
support in Spatial and Graph, 12

C

C language
examples (using OCI), 1.24
Cartesian coordinates, 1.5.4, 6.1.2
cartographic text (annotation text), 3.5
center of gravity (centroid), 24
centroid
SDO_AGGR_CENTROID aggregate function, 20
SDO_CENTROID function, 24
circle
creating polygon approximating, 32
not supported with geodetic data or for projections, 6.2.5
type, 2.2.4
CIRCLE_POLYGON function, 32
CLIP_GEOM_SEGMENT function, 25
CLIP_PC function, 28
CLIP_PC_FLAT function, 28
CLIP_TIN function, 30
clipping
geometric segment, 7.5.3
closest points
SDO_CLOSEST_POINTS procedure, 24
COLOCATED_REFERENCE_FEATURES procedure, 29
colocation mining, 8.4
column name
restrictions on spatial column names, 2.8.2
COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2.8.2
compatibility, A
complex examples
queries, C
compound element, 2.2.4
compound line string, 2.2.4, 2.7.3
compound polygon, 2.2.4
CONCAT_LINES function, 32
CONCATENATE_GEOM_SEGMENTS function, 25
concatenating
geometric segments, 7.5.5
line or multiline geometries, 20
LRS geometries, 7.5.5, 20
concave hull
SDO_CONCAVEHULL function, 24
SDO_CONCAVEHULL_BOUNDARY function, 24
CONNECTED_GEOM_SEGMENTS function, 25
consistency
checking for valid geometry types, 24
constraining data to a geometry type, 5.1.1
constructors
SDO_GEOMETRY object type, 2.4
CONTAINS
SDO_CONTAINS operator, 19
topological relationship, 1.8
contour geometries
creating from point cloud, 28
CONVERSION_FACTOR column
in SDO_ANGLE_UNITS table, 6.8.2
in SDO_AREA_UNITS table, 6.8.3
in SDO_DIST_UNITS table, 6.8.5
CONVERT_3D_SRID_TO_2D function, 21
CONVERT_NADCON_TO_XML procedure, 21
CONVERT_NTV2_TO_XML procedure, 21
CONVERT_TO_LRS_DIM_ARRAY function, 25
CONVERT_TO_LRS_GEOM function, 25
CONVERT_TO_LRS_LAYER function, 25
CONVERT_TO_STD_DIM_ARRAY function, 25
CONVERT_TO_STD_GEOM function, 25
CONVERT_TO_STD_LAYER function, 25
CONVERT_UNIT function, 32
CONVERT_XML_TO_NADCON procedure, 21
CONVERT_XML_TO_NTV2 procedure, 21
CONVERT3007TO3008 function, 32
converting
geometric segments
overview, 7.5.10
subprograms for, 25
convex hull
SDO_AGGR_CONVEXHULL aggregate function, 20
SDO_CONVEXHULL function, 24
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.7
example, 6.13
local, 6.3
subprogram reference information, 21
unit of measurement support, 2.11
user-defined, 6.9
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, 19
topological relationship, 1.8
COVERS
SDO_COVERS operator, 19
topological relationship, 1.8
CPU requirements for applications using Spatial and Graph, 1.22
CREATE INDEX statement, 18
CREATE_CONCATENATED_OP procedure, 21
CREATE_CONTOUR_GEOMETRIES function, 28
CREATE_OBVIOUS_EPSG_RULES procedure, 21
CREATE_PC procedure, 28
CREATE_PREF_CONCATENATED_OP procedure, 21
CREATE_PROFILE_TABLES procedure, 23
CREATE_TIN procedure, 30
createXMLTableIndex method, 15.4.1, 16.4.1
creating
geometric segments
subprograms for, 25
cross-schema index creation, 5.1.2
CS_SRS table, 6.8.1
current release
upgrading spatial data to, 26
cutoff_distance attribute
of batch route request, 13.3.5.2

D

data mining
spatial
colocation mining, 8.4
conceptual and usage information, 8
function reference information, 29
data model, 1.5
LRS, 7.2
data types
geocoding, 11.2
spatial, 2
database links
not supported if spatial index is defined on the table, 5.2
data-sources.xml file, 10.3
datum
geodetic, 1.5.4, 6.1.6
MDSYS.SDO_DATUMS_OLD_FORMAT table, 6.8.4
MDSYS.SDO_DATUMS_OLD_SNAPSHOT table, 6.8.4
transformation, 6.1.7
dblink
not supported if spatial index is defined on the table, 5.2
DEFINE_GEOM_SEGMENT procedure, 25
defining
geometric segment, 7.5.1
DELETE_ALL_EPSG_RULES procedure, 21
DELETE_OP procedure, 21
DeleteCapabilitiesInfo procedure, 22
deleteDomainInfo method, 16.4.2
DeleteDomainInfo procedure, 22
DeletePluginMap procedure, 22
deleteRecordViewMap method, 16.4.3
DeleteRecordViewMap procedure, 22
demo files
Spatial and Graph web services, 10.4
densification of arcs, 24
detailed route geometry
in route request, 13.3.2.2
DETERMINE_CHAIN function, 21
DETERMINE_DEFAULT_CHAIN function, 21
difference
SDO_GEOM.SDO_DIFFERENCE function, 24
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.8.3
direction of geometric segment, 7.1.3
concatenation result, 7.5.5
disableVersioning method, 16.4.4
discretization (binning)
spatial, 8.2
See alsobins
DISJOINT
topological relationship, 1.8
disk storage requirements for applications using Spatial and Graph, 1.22
distance
SDO_NN_DISTANCE ancillary operator, 19
WITHIN_DISTANCE function, 24
distance units, 6.8.5
distance_unit attribute
of route request, 13.3.2.2
distributed transactions
requirements to ensure spatial index consistency, 5.1.6
document-based feature types (WFS), 15.2
domain information (CSW)
deleting, 16.4.2
domains (CSW)
setting information, 16.4.17
Douglas-Peucker algorithm for geometry simplification, 32, 32
downgrading
Oracle Spatial to the previous Oracle Database release, A
driving directions
in route request, 13.3.2.2
driving_directions_detail attribute
of route request, 13.3.2.2
DROP INDEX statement, 18
DROP_DEPENDENCIES procedure, 28, 30
DROP_WORK_TABLES procedure, 32
dropFeatureType method, 15.4.2
DropFeatureType procedure, 34
DropFeatureTypes procedure, 34
dropRecordType method, 16.4.5
dropXMLTableIndex method, 15.4.3, 16.4.6
duplicate vertices
removing, 32
dynamic query window, 5.2.1
DYNAMIC_SEGMENT function, 25

E

.ear file
configuring for Spatial and Graph web services, 17.3
edge ID values
for subroutes in route request, 13.3.2.2
in route request, 13.3.2.2, 13.3.2.2
EDGE table
routing engine use of, 13.4.1
editing
geometric segments
subprograms for, 25
ELEM_INFO (SDO_ELEM_INFO attribute), 2.2.4
elements, 1.5.1
extracting from a geometry, 32, 32
returning number of elements in a geometry, 32
returning number of vertices in a geometry, 32
ellipse
creating polygon approximating, 32
ELLIPSE_POLYGON function, 32
ellipsoidal height, 6.2.3, 6.5.1
ellipsoids
MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table, 6.8.6
MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.8.6
embedded SDO_GEOMETRY object in user-defined type, 9.1
EnableDBTxns procedure, 33
enableVersioning method, 16.4.7
end location for route, 13.3.2.1
entity-relationship (E-R) diagram
EPSG tables, 6.7.28
EPSG
entity-relationship (E-R) diagram, 6.4
mapping of table names to Oracle Spatial names, 6.7.28
mapping Oracle SRID to, 21
mapping SRID to Oracle SRID, 21
model and use by Spatial, 6.4
version number of dataset used by Spatial, 21
EQUAL
SDO_EQUAL operator, 19
topological relationship, 1.8
E-R (entity-relationship diagram)
EPSG tables, 6.7.28
error messages
geocoding, 11.1.4
Spatial, 1.23
ESRI shapefiles
loading into Spatial, D
ESTIMATE_RTREE_INDEX_SIZE function, 31
ETYPE (SDO_ETYPE value), 2.2.4, 2.2.4
European Petroleum Survey Group
See EPSG
examples
batch route request and response, 13.3.4
C, 1.24
complex queries, C
coordinate systems, 6.13
creating, indexing, and querying spatial data, 2.1
directory for Spatial examples, 1.24
linear referencing system (LRS), 7.7
many geometry types (creating), 2.7
OCI (Oracle Call Interface), 1.24
PL/SQL, 1.24
route request and response, 13.3.1
route request with previously geocoded locations, 13.3.1
route response with previously geocoded locations, 13.3.1
SQL, 1.24
exchanging partitions including indexes, 5.1.4
Export utility
with spatial indexes and data, 5.1.5
EXTENT_OF function, 31
exterior polygon rings, 2.2.4, 2.2.4, 2.7.2, 2.7.2
exterior solids, 2.2.4
EXTRACT function, 32
EXTRACT_ALL function, 32
EXTRACT3D function, 32
extractSDO function, 16.2.2
EXTRUDE function, 32
extrusion
creating, 32

F

feature types
dropping, 15.4.2
granting access to a user, 15.4.5
publishing, 15.4.7
revoking access from a user, 15.4.8
features
linear, 7.1.10
FILTER
SDO_FILTER operator, 19
FILTER mask value for SDO_JOIN, 19, 19
FIND_GEOG_CRS function, 21
FIND_LRS_DIM_POS function, 25
FIND_MEASURE function, 25
FIND_OFFSET function, 25
FIND_PROJ_CRS function, 21
FIND_SRID procedure, 21
formatted addresses, 11.1.1
FROM_GML311GEOMETRY function, 32
FROM_GMLGEOMETRY function, 32
FROM_KMLGEOMETRY function, 32
FROM_OGC_SIMPLEFEATURE_SRS function, 21
FROM_USNG function, 21
FROM_WKBGEOMETRY function, 32
FROM_WKTGEOMETRY function, 32
frustums, 1.11.2
function-based indexes
with SDO_GEOMETRY objects, 9.2
functions
spatial aggregate, 20
supported by approximations with geodetic data, 6.10.3

G

GC_ADDRESS_POINT_<suffix> table, 11.5.1
GC_AREA_<suffix> table, 11.5.2
GC_COUNTRY_PROFILE table, 11.5.3
GC_INTERSECTION_<suffix> table, 11.5.4
GC_PARSER_PROFILEAFS table, 11.5.6
GC_PARSER_PROFILES table, 11.5.5
GC_POI_<suffix> table, 11.5.7
GC_POSTAL_CODE_<suffix> table, 11.5.8
GC_ROAD_<suffix> table, 11.5.9
GC_ROAD_SEGMENT_<suffix> table, 11.5.10
GenCollectionProcs procedure, 34
GEOCODE function, 23
GEOCODE_ADDR function, 23
GEOCODE_ADDR_ALL function, 23
GEOCODE_ALL function, 23
GEOCODE_AS_GEOMETRY function, 23
geocoding, 1.12
concepts, 11.1
data requirements, 11.3
data types for, 11.2
error messages, 11.1.4
from a place name, 11.4
indexes required on tables for geocoding, 11.5.11
match codes, 11.1.3
match modes, 11.1.2
reverse, 23
subprogram reference information, 23
usage information, 11
geocoding requests
DTD, 11.7.2
geocoding responses
DTD, 11.7.3
geodetic coordinates, 1.5.4, 6.1.3
arcs and circles not supported, 6.2.5
functions supported by approximations, 6.10.3
support for, 6.2
geodetic datum, 1.5.4, 6.1.6
geodetic MBRs, 6.2.4
geographic coordinates
See geodetic coordinates
geography markup language (GML)
converting geometry to, 32, 32
GEOM_SEGMENT_END_MEASURE function, 25
GEOM_SEGMENT_END_PT function, 25
GEOM_SEGMENT_LENGTH function, 25
GEOM_SEGMENT_START_MEASURE function, 25
GEOM_SEGMENT_START_PT function, 25
geometric segment
clipping, 7.5.3
concatenating, 7.5.5
aggregate, 7.5.5, 20
converting (overview), 7.5.10
converting (subprograms for), 25
creating (subprograms for), 25
defining, 7.5.1
definition of, 7.1.1
direction, 7.1.3
direction with concatenation, 7.5.5
editing (subprograms for), 25
locating point on, 7.5.8
offsetting, 7.5.7
projecting point onto, 7.5.9
querying (subprograms for), 25
redefining, 7.5.2
scaling, 7.5.6
splitting, 7.5.4
geometry subprograms
reference information, 24
geometry types, 1.4
constraining data to, 5.1.1
Get_GType method, 2.3
SDO_GTYPE, 2.2.1
GeoRaster
checks and actions after upgrade, A.2
gerRecordTypeId method, 16.4.9
GET_2D_FOOTPRINT function, 32
Get_Dims method, 2.3
GET_EPSG_DATA_VERSION function, 21
Get_GType method, 2.3
Get_LRS_Dim method, 2.3
GET_MEASURE function, 25
GET_NEXT_SHAPE_PT function, 25
GET_NEXT_SHAPE_PT_MEASURE function, 25
GET_PREV_SHAPE_PT function, 25
GET_PREV_SHAPE_PT_MEASURE function, 25
GET_PT_IDS function, 28
Get_WKB method, 2.3
Get_WKT method, 2.3
GetFeatureTypeId function, 34
getIsXMLTableIndexCreated method, 15.4.4, 16.4.8
GETNUMELEM function, 32
GETNUMVERTICES function, 32
GETNURBSAPPROX function, 32
GetRecordTypeId function, 22
GETVERTICES function, 32
GML (geography markup language)
converting geometry to, 32, 32
Google Maps
considerations for using with Spatial applications, 6.12
grantFeatureTypeToUser method, 15.4.5
GrantFeatureTypeToUser procedure, 34
grantMDAccessToUser method, 15.4.6, 16.4.10
GrantMDAccessToUser procedure, 34
grantRecordTypeToUser method, 16.4.11
gravity-related height, 6.5.2
GTYPE (SDO_GTYPE attribute), 2.2.1
constraining data to a geometry type, 5.1.1
Get_Dims method, 2.3
Get_GType method, 2.3
GET_LRS_Dim method, 2.3

H

hardware requirements for applications using Spatial, 1.22
height
ellipsoidal, 6.5.1
ellipsoidal and non-ellipsoidal, 6.2.3
gravity-related, 6.5.2
hierarchical driving directions
in route request, 13.3.2.2

I

id attribute
of route request, 13.3.2.2
identity propagation
application user management, 17.1.1
proxy authentication, 17.1.1
single application user, 17.1.1
Spatial and Graph web services, 17.1.1
Import utility
with spatial indexes and data, 5.1.5
index
distributed transactions and spatial index consistency, 5.1.6
indexes
creating, 5.1
cross-schema, 5.1.2
parallel execution, 18
description of Spatial indexing, 1.7
extending spatial indexing capabilities, 9
function-based with SDO_GEOMETRY objects, 9.2
granting CREATE TABLE to collect spatial index statistics, 5.1.7
partitioned, 5.1.3
exchanging partitions including indexes, 5.1.4
rebuilding, 18
parallel execution, 18, 18
R-tree
description, 1.7.1
requirements before creating, 5.1.8
size (R-tree), 31
index-organized tables
cannot create spatial index on, 2.8.1, 18
INIT function, 28, 30
INITIALIZE_INDEXES_FOR_TTS procedure, 32
input_location element, 13.3.2.3
InsertCapabilitiesInfo procedure, 22, 34
InsertDomainInfo procedure, 22
InsertFtDataUpdated procedure, 34
InsertFtMDUpdated procedure, 34
inserting spatial data
PL/SQL, 4.2
InsertPluginMap procedure, 22
InsertRecordViewMap procedure, 22
InsertRtDataUpdated procedure, 22
InsertRtMDUpdated procedure, 22
INSIDE
SDO_INSIDE operator, 19
topological relationship, 1.8
installation, A
Oracle Multimedia requirement for Locator, B
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.7.2, 2.7.2
interior solids, 2.2.4
INTERIOR_POINT function, 32
International Organization for Standardization (ISO)
compliance of Spatial with standards, 1.17
intersection, 24, 25
intersections
GC_INTERSECTION_<suffix> table, 11.5.4
inverse flattening, 6.7.23, 6.8.6
IS_GEOM_SEGMENT_DEFINED function, 25
IS_MEASURE_DECREASING function, 25
IS_MEASURE_INCREASING function, 25
IS_SHAPE_PT_MEASURE function, 25
ISO (International Organization for Standardization)
compliance of Spatial with standards, 1.17

J

Java application programming interface (API) for Spatial, 1.14
WFS administration, 15.4, 16.4
join
SDO_JOIN operator, 19

K

Keyhole Markup Language (KML)
FROM_KMLGEOMETRY function, 32
TO_KMLGEOMETRY function, 32
KML
FROM_KMLGEOMETRY function, 32
TO_KMLGEOMETRY function, 32

L

language attribute
of route request, 13.3.2.2
layer, 1.5.3
transforming, 21
validating with context, 24
layer_gtype
constraining data to a geometry type, 5.1.1
length
SDO_LENGTH function, 24
levels of detail (LODs)
checking if theme has, 32
line
converting polygon to, 32
data, 1.5.1
length, 24
line string
boundary of, 1.8
compound, 2.2.4, 2.7.3
reversing, 32
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.10.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, 25
tolerance values with LRS functions, 7.6
LOAD_EPSG_MATRIX procedure, 21
loading spatial data, 4
local coordinate systems, 6.3
local coordinates, 1.5.4, 6.1.5
LOCAL partitioning
spatial indexes, 5.1.3
LOCATE_PT function, 25
location for route segment, 13.3.2.1
location prospecting, 8.6
Locator, B
manually installing, B.1
LODs (levels of detail)
checking if theme has, 32
LRS
See linear referencing system (LRS)
LRS points, 7.1.9
LRS_INTERSECTION function, 25

M

MAKE_3D function, 21, 21
MakeOpenLSClobRequest function, 27
MakeOpenLSRequest function, 27
map projections
MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.8.7
MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.8.7
MAP_EPSG_SRID_TO_ORACLE function, 21
MAP_ORACLE_SRID_TO_EPSG function, 21
match codes, 11.1.3
match modes, 11.1.2
match vector (MatchVector attribute)
geocoding, 11.1.5
max-corner values
for three-dimensional rectangle, 1.11.3
MBR
See minimum bounding rectangle (MBR)
MDDATA account and schema, 1.15
mddins.sql script, B.1
mdinst.sql script, B.1
MDSYS schema, 1.1
must exist in destination database for migration, A.1
MDSYS.CS_SRS table, 6.8.1
MDSYS.MOVE_SDO procedure, 1.21
MDSYS.SDO_ANGLE_UNITS table, 6.8.2
MDSYS.SDO_AREA_UNITS view, 6.8.3
MDSYS.SDO_CS package, 21
MDSYS.SDO_DATUMS_OLD_FORMAT table, 6.8.4
MDSYS.SDO_DATUMS_OLD_SNAPSHOT table, 6.8.4
MDSYS.SDO_DIST_UNITS view, 6.8.5
MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table, 6.8.6
MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.8.6
MDSYS.SDO_GCDR package, 23
MDSYS.SDO_GEOM_PATH_INFO type, 16.2.2
MDSYS.SDO_OLS package, 27
MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.8.7
MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.8.7
MDSYS.SDO_SAM package, 29
MDSYS.SDO_WFS_LOCK package, 33
MDSYS.SDO_WFS_PROCESS package, 22, 34
MDXT_%objID% table, 5.1.7
mean sea level (MSL), 6.2.3.1
measure, 7.1.4
populating, 7.1.6
resetting, 25
reversing, 25
with multiline strings and polygons with holes, 7.1.11
measure range, 7.1.7
MEASURE_RANGE function, 25
MEASURE_TO_PERCENTAGE function, 25
messages
Spatial error messages, 1.23
methods
SDO_GEOMETRY object type, 2.3
migration, A.1
See also upgrading
min-corner values
for three-dimensional rectangle, 1.11.3
minimum bounding rectangle (MBR)
AVERAGE_MBR procedure, 31
EXTENT_OF function, 31
geodetic, 6.2.4
SDO_AGGR_MBR aggregate function, 20
SDO_MAX_MBR_ORDINATE function, 24
SDO_MBR function, 24
SDO_MIN_MBR_ORDINATE function, 24
mining
See data mining
MIX_INFO procedure, 31
MOVE_SDO procedure, 1.21
MSL (mean sea level), 6.2.3.1
multi-address routing, 13.1
multiline string
boundary of, 1.8
LRS measure values, 7.1.11
multimaster replication
SDO_GEOMETRY objects, B
multipolygon, 2.7.2

N

NaC coordinate reference system, 6.10.4
NADCON grids
converting Spatial XML format to NADCON format, 21
converting to Spatial XML format, 21
name conflicts
avoiding with SQL Multimedia implementations, 3.4
naming considerations
Spatial table and column names, 2.8
nearest neighbor
SDO_NN operator, 19
SDO_NN_DISTANCE operator, 19
neighborhood influence, 8.3
NODE table
routing engine use of, 13.4.2
non-ellipsoidal height, 6.2.3
non-uniform rational B-spline (NURBS) curves, 1.13
example, 2.7.8
normal vector, 1.11.5
NTv2 grids
converting Spatial XML format to NTv2 format, 21
converting to Spatial XML format, 21
NURBS curves
example, 2.7.8
GETNURBSAPPROX function, 32
support in Oracle Spatial, 1.13

O

object types
embedding SDO_GEOMETRY objects in, 9.1, 9.2.2
OCG (Open Geospatial Consortium) simple features conformance, 1.17
OCI (Oracle Call Interface) examples, 1.24
offset, 7.1.5
FIND_OFFSET function, 25
OFFSET_GEOM_SEGMENT function, 25
offsetting
geometric segment, 7.5.7
OGC_X and OGC_Y function names, 1.17
ON
SDO_ON operator, 19
topological relationship, 1.8
Open Geospatial Consortium (OCG) simple features conformance, 1.17
OpenLS
subprogram reference information, 27
OPENLS_DIR_BUSINESS_CHAINS table, 12.3.2
OPENLS_DIR_BUSINESSES table, 12.3.1
OPENLS_DIR_CATEGORIES table, 12.3.3
OPENLS_DIR_CATEGORIZATIONS table, 12.3.4
OPENLS_DIR_CATEGORY_TYPES table, 12.3.5
OPENLS_DIR_SYNONYMS table, 12.3.6
operators
ORDERED optimizer hint with, 1.9
SDO_FILTER, 19
SDO_JOIN, 19
overview, 1.9
performance-related guidelines, 1.9
SDO_ANYINTERACT, 19
SDO_CONTAINS, 19
SDO_COVEREDBY, 19
SDO_COVERS, 19
SDO_EQUAL, 19
SDO_FILTER, 19
SDO_INSIDE, 19
SDO_JOIN, 19
SDO_NN, 19
SDO_NN_DISTANCE, 19
SDO_ON, 19
SDO_OVERLAPBDYDISJOINT, 19
SDO_OVERLAPBDYINTERSECT, 19
SDO_OVERLAPS, 19
SDO_POINTINPOLYGON, 19
SDO_RELATE, 19
SDO_TOUCH, 19
SDO_WITHIN_DISTANCE, 19
optimized box, 2.2.4
optimized rectangle, 2.2.4
three-dimensional, 1.11.3
optimizer hint (ORDERED) with spatial operators, 1.9
SDO_FILTER, 19
SDO_JOIN, 19
Oracle Call Interface (OCI) examples, 1.24
Oracle Data Mining
spatial analysis and mining information, 8
Oracle Database 10g
upgrading Spatial to, A
Oracle Locator
See Locator
Oracle Multimedia
proper installation required for Locator, B
Oracle Workspace Manager
using with WFS, 15.5
ORDERED optimizer hint with spatial operators, 1.9
SDO_FILTER, 19
SDO_JOIN, 19
Ordnance Survey grid transformation, 6.9.7
oriented point
illustration and example, 2.7.6
orthometric height, 6.5.2
OSTN02/OSGM02 grid transformation, 6.9.7
OVERLAPBDYDISJOINT
SDO_OVERLAPBDYDISJOINT operator, 19
topological relationship, 1.8
OVERLAPBDYINTERSECT
SDO_OVERLAPBDYINTERSECT operator, 19
topological relationship, 1.8
OVERLAPS
SDO_OVERLAPS operator, 19

P

parallel execution for index creation and rebuilding, 18, 18, 18
parser profiles
GC_PARSER_PROFILEAFS table, 11.5.6
GC_PARSER_PROFILES table, 11.5.5
PARTITION table
routing engine use of, 13.4.3
partitioned spatial indexes, 5.1.3
exchanging partitions, 5.1.4
PERCENTAGE_TO_MEASURE function, 25
performance and tuning information, 1.16
for Spatial operators, 1.9
PL/SQL and SQL examples, 1.24
plugins
registering for record type, 16.4.13
point
data, 1.5.1
illustration and examples of point-only geometry, 2.7.5
interior on surface of polygon, 32
locating on geometric segment, 7.5.8
LRS, 7.1.9
on surface of polygon, 24
oriented point, 2.7.6
projection of onto geometric segment, 7.1.8, 7.5.9
shape, 7.1.2
point clouds
clipping, 28, 28
converting to geometry, 28
creating contour geometries, 28
dropping dependencies, 28
getting point IDs, 28
initializing, 28
modeling solids as, 1.11.2
pyramiding, 28
subprograms, 28
point of interest (POI)
GC_POI_<suffix> table, 11.5.7
POINT_AT_BEARING function, 32
policies
RLS restriction relating to SDO_FILTER, 19
polygon
area of, 24
boundary of, 1.8
buffer, 24
centroid, 24
compound, 2.2.4
exterior and interior rings, 2.2.4, 2.2.4, 2.7.2, 2.7.2
interior point on surface, 32
point on surface, 24
self-crossing not supported, 1.4
self-intersecting polygons, 24
with hole (LRS measure values), 7.1.11
polygon collection, 2.7.2
polygon data, 1.5.1
POLYGONTOLINE function, 32
PopulateFeatureTypeXMLInfo procedure, 34
populating
measure, 7.1.6
pre_geocoded_location element, 13.3.2.4
pre_geocoded_locations attribute
of route request, 13.3.2.2
primary filter, 1.6, 5.2.1.1, 5.2.1.2
primitive types, 1.4
problems in current release, 6.10
PROJECT_ORDINATES_ONTO_TIN function, 30
PROJECT_PT function, 25
projected coordinates, 1.5.4, 6.1.4
projections, 7.1.8, 7.5.9
MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.8.7
MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.8.7
PROJECT_PT function, 25
proxy authentication
identity propagation option, 17.1.1
publishFeatureType method, 15.4.7
PublishFeatureType procedure, 34
publishRecordType method, 16.4.12
pyramids
point cloud, 28
TIN, 30

Q

quality
R-tree, 1.7.2
query, 5.2.1
query model for Spatial, 1.6
query window, 5.2.1
querying geometric segments
subprograms for, 25

R

range
measure, 7.1.7
README file
for Spatial, GeoRaster, and topology and network data models, 1.25
rebuilding
spatial indexes, 18
record types
dropping, 16.4.5
getting ID, 16.4.9
granting access to a user, 16.4.11
publishing, 16.4.12
registering plugin, 16.4.13
revoking access from a user, 16.4.15
setting capabilities information, 16.4.16
record view map
deleting, 16.4.3
record view maps (setting), 16.4.18
rectangle
minimum bounding, 31
three-dimensional optimized, 1.11.3
type, 2.2.4
rectification of geometries, 32
RECTIFY_GEOMETRY function, 32
REDEFINE_GEOM_SEGMENT procedure, 25
redefining
geometric segment, 7.5.2
RegisterFeatureTable procedure, 33
RegisterMTableView procedure, 34
registerTypePluginMap method, 16.4.13
RELATE function, 24
See also SDO_RELATE operator
relational feature types (WFS), 15.2
release number (Spatial)
retrieving, 1.18
REMOVE_DUPLICATE_VERTICES function, 32
replication
multimaster, B
object, B
RESET_MEASURE procedure, 25
restrictions in current release, 6.10
return_detailed_geometry attribute
of route request, 13.3.2.2
return_driving_directions attribute
of route request, 13.3.2.2
return_hierarchical_driving_directions attribute
of route request, 13.3.2.2
return_locations attribute
of route request, 13.3.2.2
return_route_edge_ids attribute
of route request, 13.3.2.2, 13.3.2.2
return_route_geometry attribute
of batch route request, 13.3.5.2
of route request, 13.3.2.2
return_segment_geometry attribute
of batch route request, 13.3.5.2
of route request, 13.3.2.2
return_subroute_edge_ids attribute
of route request, 13.3.2.2
return_subroute_geometry attribute
of route request, 13.3.2.2
return_subroutes attribute
of route request, 13.3.2.2
reverse geocoding, 23
REVERSE_GEOCODE function, 23
REVERSE_GEOMETRY function, 25
REVERSE_LINESTRING function, 32
REVERSE_MEASURE function, 25
REVOKE_PREFERENCE_FOR_OP procedure, 21
revokeFeatureTypeFromUser method, 15.4.8
RevokeFeatureTypeFromUser procedure, 34
RevokeMDAccessFromUser procedure, 34
revokeMDAccessToUser method, 15.4.9, 16.4.14
revokeRecordTypeFromUser method, 16.4.15
ring
exterior and interior polygon, 2.2.4
extracting from a geometry, 32, 32
RLS
restriction regarding fine-grained access control policies and SDO_FILTER, 19
road segments
GC_ROAD_SEGMENT_<suffix> table, 11.5.10
road_preference attribute
of batch route request, 13.3.5.2
of route request, 13.3.2.2
roads
GC_ROAD_<suffix> table, 11.5.9
rollback segment
R-tree index creation, 5.1.8
route geometry
in route request, 13.3.2.2
route requests, 13.3.2.1
DTD, 13.3.2
example, 13.3.1
previously geocoded locations, 13.3.1
input_location element, 13.3.2.3
pre_geocoded_location element, 13.3.2.4
route responses
DTD, 13.3.3
example, 13.3.1
previously geocoded locations, 13.3.1
route_preference attribute
of route request, 13.3.2.2
route_request element, 13.3.2.1
routing engine
configuring, 13.2
data structures used by, 13.4
deploying, 13.2
multi-address routing, 13.1
overview, 13
XML API, 13.3
R-tree indexes
description of indexing process, 1.7.1
rebuilding, 18
requirements before creating, 5.1.8
sequence object, 2.10.3
R-tree quality, 1.7.2

S

SCALE_GEOM_SEGMENT function, 25
scaling
geometric segment, 7.5.6
scenes
validating, 32
schemas
creating index on table in another schema, 5.1.2
invoking SDO_JOIN on table in another schema, 19
SDO_ADDR_ARRAY data type, 11.2.2
SDO_AGGR_CENTROID aggregate function, 20
SDO_AGGR_CONCAT_LINES aggregate function, 20
SDO_AGGR_CONVEXHULL aggregate function, 20
SDO_AGGR_LRS_CONCAT aggregate function, 20
SDO_AGGR_MBR aggregate function, 20
SDO_AGGR_SET_UNION aggregate function, 20
SDO_AGGR_UNION aggregate function, 20
SDO_ALPHA_SHAPE function, 24
SDO_ANGLE_UNITS table, 6.8.2
SDO_ANYINTERACT operator, 19
SDO_ARC_DENSIFY function, 24
SDO_AREA function, 24
SDO_AREA_UNITS view, 6.8.3
SDO_BUFFER function, 24
SDO_CENTROID function, 24
SDO_CLOSEST_POINTS procedure, 24
SDO_CONCAVEHULL function, 24
SDO_CONCAVEHULL_BOUNDARY function, 24
SDO_CONTAINS operator, 19
SDO_CONVEXHULL function, 24
SDO_COORD_AXES table, 6.7.1
SDO_COORD_AXIS_NAMES table, 6.7.2
SDO_COORD_OP_METHODS table, 6.7.3
SDO_COORD_OP_PARAM_USE table, 6.7.4
SDO_COORD_OP_PARAM_VALS table, 6.7.5
SDO_COORD_OP_PARAMS table, 6.7.6
SDO_COORD_OP_PATHS table, 6.7.7
SDO_COORD_OPS table, 6.7.8
SDO_COORD_REF_SYS table, 6.7.9
SDO_COORD_REF_SYSTEM view, 6.7.10
SDO_COORD_SYS table, 6.7.11
SDO_COVEREDBY operator, 19
SDO_COVERS operator, 19
SDO_CRS_COMPOUND view, 6.7.12
SDO_CRS_ENGINEERING view, 6.7.13
SDO_CRS_GEOCENTRIC view, 6.7.14
SDO_CRS_GEOGRAPHIC2D view, 6.7.15
SDO_CRS_GEOGRAPHIC3D view, 6.7.16
SDO_CRS_PROJECTED view, 6.7.17
SDO_CRS_VERTICAL view, 6.7.18
SDO_CS package, 21
ADD_PREFERENCE_FOR_OP, 21
CONVERT_3D_SRID_TO_2D, 21
CONVERT_NADCON_TO_XML, 21
CONVERT_NTV2_TO_XML, 21
CONVERT_XML_TO_NADCON, 21
CONVERT_XML_TO_NTV2, 21
CREATE_CONCATENATED_OP, 21
CREATE_OBVIOUS_EPSG_RULES, 21
CREATE_PREF_CONCATENATED_OP, 21
DELETE_ALL_EPSG_RULES, 21
DELETE_OP, 21
DETERMINE_CHAIN, 21
DETERMINE_DEFAULT_CHAIN, 21
FIND_GEOG_CRS, 21
FIND_PROJ_CRS, 21
FIND_SRID, 21
FROM_OGC_SIMPLEFEATURE_SRS, 21
FROM_USNG, 21
GET_EPSG_DATA_VERSION function, 21
LOAD_EPSG_MATRIX, 21
MAKE_3D, 21, 21
MAP_EPSG_SRID_TO_ORACLE, 21
MAP_ORACLE_SRID_TO_EPSG, 21
REVOKE_PREFERENCE_FOR_OP, 21
TO_OGC_SIMPLEFEATURE_SRS, 21
TO_USNG, 21
TRANSFORM, 21
TRANSFORM_LAYER, 21
UPDATE_WKTS_FOR_ALL_EPSG_CRS, 21
UPDATE_WKTS_FOR_EPSG_CRS, 21
UPDATE_WKTS_FOR_EPSG_DATUM, 21
UPDATE_WKTS_FOR_EPSG_ELLIPS, 21
UPDATE_WKTS_FOR_EPSG_OP, 21
UPDATE_WKTS_FOR_EPSG_PARAM, 21
UPDATE_WKTS_FOR_EPSG_PM, 21
VALIDATE_EPSG_MATRIX, 21
VALIDATE_WKT, 21
SDO_CSW_PROCESS package
DeleteCapabilitiesInfo, 22
DeleteDomainInfo, 22
DeletePluginMap, 22
DeleteRecordViewMap, 22
GetRecordTypeId, 22
InsertCapabilitiesInfo, 22
InsertDomainInfo, 22
InsertPluginMap, 22
InsertRecordViewMap, 22
InsertRtDataUpdated, 22
InsertRtMDUpdated, 22
SDO_DATUM_ENGINEERING view, 6.7.19
SDO_DATUM_GEODETIC view, 6.7.20
SDO_DATUM_VERTICAL view, 6.7.21
SDO_DATUMS table, 6.7.22
SDO_DATUMS_OLD_FORMAT table, 6.8.4
SDO_DATUMS_OLD_SNAPSHOT table, 6.8.4
SDO_DIFFERENCE function, 24
SDO_DIST_UNITS view, 6.8.5
SDO_DISTANCE function, 24
SDO_ELEM_INFO attribute, 2.2.4
SDO_ELEM_INFO_ARRAY type, 2.2
SDO_ELLIPSOIDS table, 6.7.23
SDO_ELLIPSOIDS_OLD_FORMAT table, 6.8.6
SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.8.6
SDO_EQUAL operator, 19
SDO_ETYPE value, 2.2.4, 2.2.4
SDO_FILTER operator, 19
SDO_GCDR package, 23
CREATE_PROFILE_TABLES, 23
GEOCODE, 23
GEOCODE_ADDR, 23
GEOCODE_ADDR_ALL, 23
GEOCODE_ALL, 23
GEOCODE_AS_GEOMETRY, 23
REVERSE_GEOCODE, 23
SDO_GEO_ADDR data type and constructors, 11.2.1
SDO_GEOM package
RELATE, 24
SDO_ALPHA_SHAPE, 24
SDO_ARC_DENSIFY, 24
SDO_AREA, 24
SDO_BUFFER, 24
SDO_CENTROID, 24
SDO_CLOSEST_POINTS, 24
SDO_CONCAVEHULL, 24
SDO_CONCAVEHULL_BOUNDARY, 24
SDO_CONVEXHULL, 24
SDO_DIFFERENCE, 24
SDO_DISTANCE, 24
SDO_INTERSECTION, 24
SDO_LENGTH, 24
SDO_MAX_MBR_ORDINATE, 24
SDO_MBR, 24
SDO_MIN_MBR_ORDINATE, 24
SDO_POINTONSURFACE, 24
SDO_SELF_UNION, 24
SDO_TRIANGULATE, 24
SDO_UNION, 24
SDO_VOLUME, 24
SDO_XOR, 24
VALIDATE_GEOMETRY_WITH_CONTEXT, 24
VALIDATE_LAYER_WITH_CONTEXT, 24
WITHIN_DISTANCE, 24
SDO_GEOM_MBR operator, 24
SDO_GEOM_PATH_INFO
MDSYS.SDO_GEOM_PATH_INFO type, 16.2.2
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, 5.1.1
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.10.2
SDO_INDX_DIMS keyword, 7.3, 18
SDO_INSIDE operator, 19
SDO_INTERPRETATION value, 2.2.4
SDO_INTERSECTION function, 24
SDO_JOIN operator, 19
cross-schema invocation, 19
SDO_KEYWORDARRAY data type, 11.2.3
SDO_LENGTH function, 24
SDO_LRS package
CLIP_GEOM_SEGMENT, 25
CONCATENATE_GEOM_SEGMENTS, 25
CONNECTED_GEOM_SEGMENTS, 25
CONVERT_TO_LRS_DIM_ARRAY, 25
CONVERT_TO_LRS_GEOM, 25
CONVERT_TO_LRS_LAYER, 25
CONVERT_TO_STD_DIM_ARRAY, 25
CONVERT_TO_STD_GEOM, 25
CONVERT_TO_STD_LAYER, 25
DEFINE_GEOM_SEGMENT, 25
DYNAMIC_SEGMENT, 25
FIND_LRS_DIM_POS, 25
FIND_MEASURE, 25
FIND_OFFSET, 25
GEOM_SEGMENT_END_MEASURE, 25
GEOM_SEGMENT_END_PT, 25
GEOM_SEGMENT_LENGTH, 25
GEOM_SEGMENT_START_MEASURE, 25
GEOM_SEGMENT_START_PT, 25
GET_MEASURE, 25
GET_NEXT_SHAPE_PT, 25
GET_NEXT_SHAPE_PT_MEASURE, 25
GET_PREV_SHAPE_PT, 25
GET_PREV_SHAPE_PT_MEASURE, 25
IS_GEOM_SEGMENT_DEFINED, 25
IS_MEASURE_DECREASING, 25
IS_MEASURE_INCREASING, 25
IS_SHAPE_PT_MEASURE, 25
LOCATE_PT, 25
LRS_INTERSECTION, 25
MEASURE_RANGE, 25
MEASURE_TO_PERCENTAGE, 25
OFFSET_GEOM_SEGMENT, 25
PERCENTAGE_TO_MEASURE, 25
PROJECT_PT, 25
REDEFINE_GEOM_SEGMENT, 25
RESET_MEASURE, 25
REVERSE_GEOMETRY, 25
REVERSE_MEASURE, 25
SCALE_GEOM_SEGMENT, 25
SET_PT_MEASURE, 25
SPLIT_GEOM_SEGMENT, 25
TRANSLATE_MEASURE, 25
VALID_GEOM_SEGMENT, 25
VALID_LRS_PT, 25
VALID_MEASURE, 25
VALIDATE_LRS_GEOMETRY, 25
SDO_MAX_MBR_ORDINATE function, 24
SDO_MBR function, 24
SDO_MIGRATE package
TO_CURRENT, 26
SDO_MIN_MBR_ORDINATE function, 24
SDO_NN operator, 19
complex examples, C.3
optimizer hints, 19
SDO_NN_DISTANCE ancillary operator, 19
SDO_NN_DISTANCE operator
complex examples, C.3
SDO_OLS package, 27
MakeOpenLSClobRequest, 27
MakeOpenLSRequest, 27
SDO_ON operator, 19
SDO_ORDINATE_ARRAY type, 2.2
SDO_ORDINATES attribute, 2.2.5
SDO_OVERLAPBDYDISJOINT operator, 19
SDO_OVERLAPBDYINTERSECT operator, 19
SDO_OVERLAPS operator, 19
SDO_PC object type, 2.6.1
SDO_PC_BLK object type, 2.6.2
SDO_PC_BLK_TYPE object type, 2.6.2
SDO_PC_PKG package
CLIP_PC, 28
CLIP_PC_FLAT, 28
CREATE_CONTOUR_GEOMETRIES, 28
CREATE_PC, 28
DROP_DEPENDENCIES, 28
GET_PT_IDS, 28
INIT, 28
TO_GEOMETRY, 28
SDO_POINT attribute, 2.2.3
SDO_POINT_TYPE object type, 2.2
SDO_POINTINPOLYGON operator, 19
SDO_POINTONSURFACE function, 24
SDO_PREFERRED_OPS_SYSTEM table, 6.7.24
SDO_PREFERRED_OPS_USER table, 6.7.25
SDO_PRIME_MERIDIANS table, 6.7.26
SDO_PROJECTIONS_OLD_FORMAT table, 6.8.7
SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.8.7
SDO_REGAGGR object type, 29, 29
SDO_REGAGGRSET object type, 29, 29
SDO_REGION object type, 29
SDO_REGIONSET object type, 29
SDO_RELATE operator, 19
SDO_ROWIDPAIR object type, 19
SDO_ROWIDSET data type, 19
SDO_RTREE_SEQ_NAME sequence object, 2.10.3
SDO_SAM package, 29
AGGREGATES_FOR_GEOMETRY, 29
AGGREGATES_FOR_LAYER, 29
BIN_GEOMETRY, 29
BIN_LAYER, 29
COLOCATED_REFERENCE_FEATURES, 29
SIMPLIFY_GEOMETRY, 29
SIMPLIFY_LAYER, 29
SPATIAL_CLUSTERS, 29
TILED_AGGREGATES, 29
TILED_BINS, 29
SDO_SELF_UNION function, 24
SDO_SRID attribute, 2.2.2
SDO_ST_TOLERANCE table, 3.3
SDO_STARTING_OFFSET value, 2.2.4
SDO_TFM_CHAIN type, 6.6
SDO_TIN object type, 2.5.1
SDO_TIN_BLK object type, 2.5.2
SDO_TIN_BLK_TYPE object type, 2.5.2
SDO_TIN_PKG package
CLIP_TIN, 30
CREATE_TIN, 30
DROP_DEPENDENCIES, 30
INIT, 30
PROJECT_ORDINATES_ONTO_TIN, 30
TO_DEM, 30
TO_GEOMETRY, 30
SDO_TOUCH operator, 19
SDO_TRIANGULATE function, 24
SDO_TUNE package
AVERAGE_MBR, 31
ESTIMATE_RTREE_INDEX_SIZE, 31
EXTENT_OF, 31
MIX_INFO, 31
SDO_UNION function, 24
SDO_UNIT column
in SDO_AREA_UNITS table, 6.8.3
in SDO_DIST_UNITS table, 6.8.5
SDO_UNITS_OF_MEASURE table, 6.7.27
SDO_UTIL package
AFFINETRANSFORMS, 32
APPEND, 32
BEARING_TILT_FOR_POINTS, 32
CIRCLE_POLYGON, 32
CONCAT_LINES, 32
CONVERT_UNIT, 32
CONVERT3007TO3008, 32
DROP_WORK_TABLES, 32
ELLIPSE_POLYGON, 32
EXTRACT, 32
EXTRACT_ALL, 32
EXTRACT3D, 32
EXTRUDE, 32
FROM_GML311GEOMETRY, 32
FROM_GMLGEOMETRY, 32
FROM_KMLGEOMETRY, 32
FROM_WKBGEOMETRY, 32
FROM_WKTGEOMETRY, 32
GET_2D_FOOTPRINT, 32
GETNUMELEM, 32
GETNUMVERTICES, 32
GETNURBSAPPROX, 32
GETVERTICES, 32
INITIALIZE_INDEXES_FOR_TTS, 32
INTERIOR_POINT, 32
POINT_AT_BEARING, 32
POLYGONTOLINE, 32
RECTIFY_GEOMETRY, 32
REMOVE_DUPLICATE_VERTICES, 32
REVERSE_LINESTRING, 32
SIMPLIFY, 32, 32
THEME3D_GET_BLOCK_TABLE, 32
THEME3D_HAS_LOD, 32
THEME3D_HAS_TEXTURE, 32
TO_GML311GEOMETRY, 32
TO_GMLGEOMETRY, 32
TO_KMLGEOMETRY, 32
TO_WKBGEOMETRY, 32
TO_WKTGEOMETRY, 32
VALIDATE_3DTHEME, 32
VALIDATE_SCENE, 32
VALIDATE_VIEWFRAME, 32
VALIDATE_WKBGEOMETRY, 32
VALIDATE_WKTGEOMETRY, 32
SDO_VERSION function, 1.18
SDO_VOLUME function, 24
SDO_WFS_LOCK package, 33
EnableDBTxns, 33
RegisterFeatureTable, 33
UnRegisterFeatureTable, 33
SDO_WFS_PROCESS package, 22, 34
DropFeatureType, 34
DropFeatureTypes, 34
GenCollectionProcs, 34
GetFeatureTypeId, 34
GrantFeatureTypeToUser, 34
GrantMDAccessToUser, 34
InsertCapabilitiesInfo, 34
InsertFtDataUpdated, 34
InsertFtMDUpdated, 34
PopulateFeatureTypeXMLInfo, 34
PublishFeatureType, 34
RegisterMTableView, 34
RevokeFeatureTypeFromUser, 34
RevokeMDAccessFromUser, 34
UnRegisterMTableView, 34
SDO_WITHIN_DISTANCE operator, 19
complex examples, C.2
SDO_XOR function, 24
SDOAGGRTYPE object type, 1.10.1
sdows.ear file
deploying, 10.3
sea level
gravity-related height, 6.5.2
secondary filter, 1.6, 5.2.1.2
segment geometry
in route request, 13.3.2.2
segments
geometric, 7.1.1
in a route or subroute, 13.1
self union, 24
self-crossing line strings and polygons, 1.4
self-intersecting polygons, 24
self-joins
optimizing, 19
semi-major axis, 6.7.23, 6.8.6
semi-minor axis, 6.7.23
sequence object for R-tree index, 2.10.3
SET_PT_MEASURE procedure, 25
setCapabilitiesInfo method, 16.4.16
setDomainInfo method, 16.4.17
setRecordViewMap method, 16.4.18
setXMLTableIndexInfo method, 15.4.10, 16.4.19
shape point, 7.1.2
determining if measure value is a shape point, 25
getting measure of next, 25
getting measure of previous, 25
getting next, 25
getting previous, 25
shapefiles
loading into Spatial, D
SIGN_POST table
routing engine use of, 13.4.4
simple element, 2.2.4
simple features (OGC)
Oracle Spatial conformance, 1.17
simplification of geometries, 32, 32
SIMPLIFY function, 32, 32
SIMPLIFY_GEOMETRY function, 29
SIMPLIFY_LAYER procedure, 29
single application user
identity propagation option, 17.1.1
size requirements (hardware) for spatial applications, 1.22
solids
exterior and interior, 2.2.4
modeling of, 1.11.2
SDO_ETYPE value, 2.2.4
volume of, 24
SORT_AREA_SIZE parameter
R-tree index creation, 5.1.8
sort_by_distance attribute
of batch route request, 13.3.5.2
spatial aggregate functions
See aggregate functions
spatial analysis and mining
conceptual and usage information, 8
function reference information, 29
Spatial and Graph web services
client setup, 10.3
demo files, 10.4
identity propagation, 17.1.1
introduction, 10
user management, 17.1
virtual private databases, 17.2.1
spatial binning, 8.2
See alsobins
spatial clustering, 8.5
spatial correlation, 8.3
spatial data mining
conceptual and usage information, 8
function reference information, 29
spatial data structures, 2
spatial data types, 2
spatial index
See index
spatial join, 5.2.2
SDO_JOIN operator, 19
Spatial metadata tables
moving, 1.21
spatial operators
See operators
spatial query, 5.2.1
spatial reference systems
conceptual and usage information, 6
example, 6.13
subprogram reference information, 21
spatial routing engine
See routing engine
SPATIAL_CLUSTERS function, 29
SPATIAL_CSW_ADMIN_USR account and schema, 1.15
SPATIAL_VECTOR_ACCELERATION system parameter, 1.19
SPATIAL_WFS_ADMIN_USR account and schema, 1.15
spatially enabling a table, 1.20
spheroids
MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table, 6.8.6
MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.8.6
SPLIT_GEOM_SEGMENT procedure, 25
splitting
geometric segment, 7.5.4
SQL and PL/SQL examples, 1.24
SQL Multimedia
avoiding name conflicts, 3.4
FROM_WKBGEOMETRY function, 32
FROM_WKTGEOMETRY function, 32
ST_GEOMETRY type, 3.1
support in Spatial, 3
TO_WKBGEOMETRY function, 32
TO_WKTGEOMETRY function, 32
tolerance value, 3.3
VALIDATE_WKBGEOMETRY function, 32
VALIDATE_WKTGEOMETRY function, 32
SQL Multimedia standard
ST_CoordDim method, 2.3
ST_IsValid method, 2.3
SQL statements
for indexing spatial data, 18
SQL*Loader, 4.1
SRID
checking for existence, 21
finding, 21
in USER_SDO_GEOM_METADATA, 2.8.4
mapping Oracle to EPSG, 21
SDO_SRID attribute in SDO_GEOMETRY, 2.2.2
ST_ANNOTATION_TEXT constructor, 3.5.1
ST_CoordDim method, 2.3
ST_GEOMETRY type, 3.1
ST_IsValid method, 2.3
start location for route, 13.3.2.1
subprograms
coordinate system transformation, 21
data mining, 29
geocoding, 23
geometry, 24
linear referencing, 25
OpenLS, 27
point clouds, 28
SDO_MIGRATE, 26
spatial analysis, 29
TINs, 30
tuning, 31
utility, 32
WFS, 33
WFS processing, 22, 34
subroutes
explanation of, 13.1
returning coordinates in route request, 13.3.2.2
returning edge IDs in route request, 13.3.2.2
returning in route request, 13.3.2.2
surface normal, 1.11.5
surfaces, 2.2.4
modeling of, 1.11.1
SDO_ETYPE value, 2.2.4

T

table names
restrictions on spatial table names, 2.8.1
TABLE_NAME (in USER_SDO_GEOM_METADATA), 2.8.1
tables
spatially enabling, 1.20
textures
checking if theme has, 32
using, 1.11.4
TFM_PLAN object type, 6.6
THEME3D_GET_BLOCK_TABLE function, 32
THEME3D_HAS_LOD function, 32
THEME3D_HAS_TEXTURE function, 32
themes
checking for LODs, 32
checking for textures, 32
getting block table, 32
validating, 32
three-dimensional (3D)
formats of LRS functions, 7.4
not supported with geodetic data, 6.10.2
spatial objects, 1.11
solids, 1.11.2
surfaces, 1.11.1
TILED_AGGREGATES function, 29
TILED_BINS function, 29
time_unit attribute
of route request, 13.3.2.2
TINs
clipping, 30
converting to DEM, 30
converting to geometry, 30
creating, 28, 30
dropping dependencies, 30
initializing, 30
projecting ordinates onto, 30
pyramiding, 30
subprograms, 30
TINs (triangulated irregular networks), 1.11.1
TO_CURRENT procedure and function, 26
TO_DEM procedure, 30
TO_GEOMETRY function, 28, 30
TO_GML311GEOMETRY function, 32
TO_GMLGEOMETRY function, 32
TO_KMLGEOMETRY function, 32
TO_OGC_SIMPLEFEATURE_SRS function, 21
TO_USNG function, 21
TO_WKBGEOMETRY function, 32
TO_WKTGEOMETRY function, 32
tolerance, 1.5.5
for SQL Multimedia types, 3.3
with LRS functions, 7.6
topological self union, 24
TOUCH
SDO_TOUCH operator, 19
topological relationship, 1.8
transactional insertion of spatial data, 4.2
TRANSFORM function, 21
TRANSFORM_LAYER procedure, 21
table for transformed layer, 21
transformation, 6.1.7
arcs and circles not supported, 6.2.5
TRANSLATE_MEASURE function, 25
transportable tablespaces
initializing spatial indexes, 32
triangulated irregular networks (TINs), 1.11.1
triangulation
SDO_TRIANGULATE function, 24
tuning and performance information, 1.16
for spatial operators, 1.9
tuning subprograms, 31
two-tier query model, 1.6
type zero (0) element, 2.7.7

U

unformatted addresses, 11.1.1
union, 24
unit of measurement
MDSYS tables, 2.11
UNIT_NAME column
in SDO_ANGLE_UNITS table, 6.8.2
in SDO_AREA_UNITS table, 6.8.3
in SDO_DIST_UNITS table, 6.8.5
unknown CRS coordinate reference system, 6.10.4
UnRegisterFeatureTable procedure, 33
UnRegisterMTableView procedure, 34
UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure, 21
UPDATE_WKTS_FOR_EPSG_CRS procedure, 21
UPDATE_WKTS_FOR_EPSG_DATUM procedure, 21
UPDATE_WKTS_FOR_EPSG_ELLIPS procedure, 21
UPDATE_WKTS_FOR_EPSG_OP procedure, 21
UPDATE_WKTS_FOR_EPSG_PARAM procedure, 21
UPDATE_WKTS_FOR_EPSG_PM procedure, 21
upgrading
data to current Spatial release, 26
GeoRaster, A.2
Spatial to current Oracle Database release, A
upgrading spatial data to current release, 26
U.S. National Grid
SDO_CS.FROM_USNG function, 21
SDO_CS.TO_USNG function, 21
support in Oracle Spatial, 6.11
use cases
for coordinate system transformation, 6.4
USE_SPHERICAL use case name, 6.12
USER_ANNOTATION_TEXT_METADATA view, 3.5.2
USER_SDO_3DTHEMES view, 2.9.1
USER_SDO_GEOM_METADATA view, 2.8
USER_SDO_INDEX_INFO view, 2.10.1.1
USER_SDO_INDEX_METADATA view, 2.10.1.2
USER_SDO_SCENES view, 2.9.2
USER_SDO_VIEWFRAMES view, 2.9.3
user-defined coordinate reference system, 6.9
user-defined data types
embedding SDO_GEOMETRY objects in, 9.1, 9.2.2
utility subprograms, 32

V

VALID_GEOM_SEGMENT function, 25
VALID_LRS_PT function, 25
VALID_MEASURE function, 25
VALIDATE_3DTHEME function, 32
VALIDATE_EPSG_MATRIX procedure, 21
VALIDATE_GEOMETRY_WITH_CONTEXT function, 24
VALIDATE_LAYER_WITH_CONTEXT procedure, 24
VALIDATE_LRS_GEOMETRY function, 25
VALIDATE_SCENE function, 32
VALIDATE_VIEWFRAME function, 32
VALIDATE_WKBGEOMETRY function, 32
VALIDATE_WKT function, 21
VALIDATE_WKTGEOMETRY function, 32
validation of geometries
general and two-dimensional checks, 24
importance of performing, 4.3
three-dimensional checks, 1.11.5
Vector Performance Accelerator (VPA) feature, 1.19
vendor attribute
of route request, 13.3.2.2
version number (Spatial)
retrieving, 1.18
versioning (CSW)
disabling, 16.4.4
enabling, 16.4.7
VERTEX_SET_TYPE data type, 32
VERTEX_TYPE object type, 32
vertices
maximum number in SDO_GEOMETRY object, 2.2
removing duplicate, 32
returning geometry coordinates as, 32
viewframes
validating, 32
views
ALL_ANNOTATION_TEXT_METADATA, 3.5.2
ALL_SDO_GEOM_METADATA, 2.8
ALL_SDO_INDEX_INFO, 2.10.1.1
ALL_SDO_INDEX_METADATA, 2.10.1.2
USER_ANNOTATION_TEXT_METADATA, 3.5.2
USER_SDO_GEOM_METADATA, 2.8
USER_SDO_INDEX_INFO, 2.10.1.1
USER_SDO_INDEX_METADATA, 2.10.1.2
virtual private databases
Spatial and Graph web services security, 17.2.1
volume, 24
VPA (Vector Performance Accelerator) feature, 1.19
VPDs
Spatial and Graph web services security, 17.2.1

W

web services
client setup, 10.3
demo files, 10.4
introduction, 10
well-known binary (WKB)
See WKB
well-known text (WKT)
See WKT
WFS
engine, 15.1
feature types, 15.2
Java API, 15.4, 16.4
subprogram reference information, 33
using with Oracle Workspace Manager, 15.5
WFS processing
subprogram reference information, 22, 34
WFSAdmin Java class, 15.4, 16.4
WITHIN_DISTANCE function, 24
See also SDO_WITHIN_DISTANCE operator
WKB
FROM_WKBGEOMETRY function, 32
Get_WKB method, 2.3
TO_WKBGEOMETRY function, 32
VALIDATE_WKBGEOMETRY function, 32
WKT, 6.8.1.1
FROM_WKTGEOMETRY function, 32
Get_WKT method, 2.3
procedures for updating, 6.8.1.3
TO_WKTGEOMETRY function, 32
UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure, 21
UPDATE_WKTS_FOR_EPSG_CRS procedure, 21
UPDATE_WKTS_FOR_EPSG_DATUM procedure, 21
UPDATE_WKTS_FOR_EPSG_ELLIPS procedure, 21
UPDATE_WKTS_FOR_EPSG_OP procedure, 21
UPDATE_WKTS_FOR_EPSG_PARAM procedure, 21
UPDATE_WKTS_FOR_EPSG_PM procedure, 21
VALIDATE_WKTGEOMETRY function, 32
validating (given SRID), 21
WKTEXT column of MDSYS.CS_SRS table, 6.8.1.1
procedures for updating value, 6.8.1.3
Workspace Manager
executing SOAP request in workspace, 17.2.2
using with WFS, 15.5
wsclient.jar file, 10.4
WSConfig.xml file, 10.3

X

XML API
routing engine, 13.3
XML table index
setting information for a feature type, 15.4.10
setting information for record type, 16.4.19
XMLTABLEINDEX index
checking for existence, 15.4.4, 16.4.8
creating on feature table, 15.4.1, 16.4.1
deleting on feature table, 15.4.3, 16.4.6
XOR
SDO_XOR function, 24

Y

Yellow Pages
See business directory (YP)
YP
See business directory (YP)

Z

zero
type 0 element, 2.7.7