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_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.4.2
ALL_SDO_GEOM_METADATA view, 2.8
ALL_SDO_INDEX_INFO view, 2.9.1.1
ALL_SDO_INDEX_METADATA view, 2.9.1.2
ALTER INDEX statement, 18
REBUILD clause, 18
RENAME TO clause, 18
angle units, 6.8.2
annotation text, 3.4
ANYINTERACT
SDO_ANYINTERACT operator, 19
topological relationship, 1.8
APPEND function, 32
application size (hardware) requirements, 1.18
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.2.5.1
DTD, 13.2.5
example, 13.2.4
batch route responses
DTD, 13.2.6
example, 13.2.4
batch_route_request element, 13.2.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
See also bins
bins
assigning, 29
computing, 29
tiled, 29
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
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, 12

C

C language
examples (using OCI), 1.20
Cartesian coordinates, 1.5.4, 6.1.2
cartographic text (annotation text), 3.4
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_TIN procedure, 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
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
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_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
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.12
local, 6.3
subprogram reference information, 21
unit of measurement support, 2.10
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, 1.18
CREATE INDEX statement, 18
CREATE_CONCATENATED_OP procedure, 21
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.2.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 Web services, 10.4
densification of arcs, 24
detailed route geometry
in route request, 13.2.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 also bins
DISJOINT
topological relationship, 1.8
disk storage requirements for applications using Spatial, 1.18
distance
SDO_NN_DISTANCE ancillary operator, 19
WITHIN_DISTANCE function, 24
distance units, 6.8.5
distance_unit attribute
of route request, 13.2.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
downgrading
Oracle Spatial to the previous Oracle Database release, A
driving directions
in route request, 13.2.2.2
driving_directions_detail attribute
of route request, 13.2.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
deploying and configuring for Spatial Web services, 17.3
edge ID values
in route request, 13.2.2.2, 13.2.2.2
EDGE table
routing engine use of, 13.3.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
enableVersioning method, 16.4.7
end location for route, 13.2.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.19
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.2.4
C, 1.20
complex queries, C
coordinate systems, 6.12
creating, indexing, and querying spatial data, 2.1
directory for Spatial examples, 1.20
linear referencing system (LRS), 7.7
many geometry types (creating), 2.7
OCI (Oracle Call Interface), 1.20
PL/SQL, 1.20
route request and response, 13.2.1
route request with previously geocoded locations, 13.2.1
route response with previously geocoded locations, 13.2.1
SQL, 1.20
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, 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
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_AREA_<suffix> table, 11.5.1
GC_COUNTRY_PROFILE table, 11.5.2
GC_INTERSECTION_<suffix> table, 11.5.3
GC_POI_<suffix> table, 11.5.4
GC_POSTAL_CODE_<suffix> table, 11.5.5
GC_ROAD_<suffix> table, 11.5.6
GC_ROAD_SEGMENT_<suffix> table, 11.5.7
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.8
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.1
gerRecordTypeId method, 16.4.9
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
GetRecordTypeId function, 22
GETVERTICES function, 32
GML (geography markup language)
converting geometry to, 32, 32
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.18
height
ellipsoidal, 6.5.1
ellipsoidal and non-ellipsoidal, 6.2.3
gravity-related, 6.5.2
hierarchical driving directions
in route request, 13.2.2.2

I

id attribute
of route request, 13.2.2.2
identity propagation
application user management, 17.1.1
proxy authentication, 17.1.1
single application user, 17.1.1
Spatial 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
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.7
size (R-tree), 31
index-organized table
cannot create spatial index on, 2.8.1, 18
INIT function, 28, 30
INITIALIZE_INDEXES_FOR_TTS procedure, 32
input_location element, 13.2.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
intersection, 24, 25
intersections
GC_INTERSECTION_<suffix> table, 11.5.3
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

J

Java application programming interface (API) for Spatial, 1.13
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.2.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
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
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 prospecting, 8.6
Locator, B
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.14
MDSYS schema, 1.1
MDSYS.CS_SRS table, 6.8.1
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
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.19
methods
SDO_GEOMETRY object type, 2.3
migration
See 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
MSL (mean sea level), 6.2.3.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.3
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.3.2
non-ellipsoidal height, 6.2.3
normal vector, 1.11.4
NTv2 grids
converting Spatial XML format to NTv2 format, 21
converting to Spatial XML format, 21

O

object types
embedding SDO_GEOMETRY objects in, 9.1, 9.2.2
OCG (Open Geospatial Consortium) simple features conformance, 1.16
OCI (Oracle Call Interface) examples, 1.20
ODM
See Oracle Data Mining (ODM)
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.16
ON
SDO_ON operator, 19
topological relationship, 1.8
Open Geospatial Consortium (OCG) simple features conformance, 1.16
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_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.20
Oracle Data Mining (ODM)
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
ORDERED optimizer hint with spatial operators, 1.9
SDO_FILTER, 19
SDO_JOIN, 19
oriented point
illustration and example, 2.7.6
orthometric height, 6.5.2
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
PARTITION table
routing engine use of, 13.3.3
partitioned spatial indexes, 5.1.3
exchanging partitions, 5.1.4
PERCENTAGE_TO_MEASURE function, 25
performance and tuning information, 1.15
for Spatial operators, 1.9
PL/SQL and SQL examples, 1.20
plugins
registering for record type, 16.4.13
point
data, 1.5.1
illustration and examples of point-only geometry, 2.7.5
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
converting to geometry, 28
dropping dependencies, 28
getting point IDs, 28
initializing, 28
modeling solids as, 1.11.2
subprograms, 28
point of interest (POI)
GC_POI_<suffix> table, 11.5.4
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
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.2.2.4
pre_geocoded_locations attribute
of route request, 13.2.2.2
PREPARE_FOR_TTS procedure, 32
primary filter, 1.6, 5.2.1.1, 5.2.1.2
primitive types, 1.4
problems in current release, 6.10
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

Q

quality
R-tree, 1.7.2
QUALITY_DEGRADATION function (deprecated), 31
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.21
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.17
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.2.2.2
return_driving_directions attribute
of route request, 13.2.2.2
return_hierarchical_driving_directions attribute
of route request, 13.2.2.2
return_route_edge_ids attribute
of route request, 13.2.2.2, 13.2.2.2
return_route_geometry attribute
of batch route request, 13.2.5.2
of route request, 13.2.2.2
return_segment_geometry attribute
of batch route request, 13.2.5.2
of route request, 13.2.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.7
road_preference attribute
of batch route request, 13.2.5.2
of route request, 13.2.2.2
roads
GC_ROAD_<suffix> table, 11.5.6
rollback segment
R-tree index creation, 5.1.7
route geometry
in route request, 13.2.2.2
route requests, 13.2.2.1
DTD, 13.2.2
example, 13.2.1
previously geocoded locations, 13.2.1
input_location element, 13.2.2.3
pre_geocoded_location element, 13.2.2.4
route responses
DTD, 13.2.3
example, 13.2.1
previously geocoded locations, 13.2.1
route_preference attribute
of route request, 13.2.2.2
route_request element, 13.2.2.1
routing engine
configuring, 13.1
data structures used by, 13.3
deploying, 13.1
overview, 13
XML API, 13.2
R-tree indexes
description of indexing process, 1.7.1
rebuilding, 18
requirements before creating, 5.1.7
sequence object, 2.9.3
R-tree quality, 1.7.2

S

SCALE_GEOM_SEGMENT function, 25
scaling
geometric segment, 7.5.6
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_UNION aggregate function, 20
complex examples, C.4
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_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_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
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_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_ARC_DENSIFY, 24
SDO_AREA, 24
SDO_BUFFER, 24
SDO_CENTROID, 24
SDO_CLOSEST_POINTS, 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_UNION, 24
SDO_VOLUME, 24
SDO_XOR, 24
VALIDATE_GEOMETRY_WITH_CONTEXT, 24
VALIDATE_LAYER_WITH_CONTEXT, 24
WITHIN_DISTANCE, 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.9.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
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_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.9.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_SRID attribute, 2.2.2
SDO_ST_TOLERANCE table, 3.2
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
TO_GEOMETRY, 30
SDO_TOUCH operator, 19
SDO_TUNE package
AVERAGE_MBR, 31
ESTIMATE_RTREE_INDEX_SIZE, 31
EXTENT_OF, 31
MIX_INFO, 31
QUALITY_DEGRADATION (deprecated function), 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
DROP_WORK_TABLES, 32
ELLIPSE_POLYGON, 32
EXTRACT, 32, 32
EXTRUDE, 32
FROM_GML311GEOMETRY, 32
FROM_GMLGEOMETRY, 32
FROM_KMLGEOMETRY, 32
FROM_WKBGEOMETRY, 32
FROM_WKTGEOMETRY, 32
GETNUMELEM, 32
GETNUMVERTICES, 32
GETVERTICES, 32
INITIALIZE_INDEXES_FOR_TTS, 32
POINT_AT_BEARING, 32
POLYGONTOLINE, 32
PREPARE_FOR_TTS, 32
RECTIFY_GEOMETRY, 32
REMOVE_DUPLICATE_VERTICES, 32
REVERSE_LINESTRING, 32
SIMPLIFY, 32
TO_GML311GEOMETRY, 32
TO_GMLGEOMETRY, 32
TO_KMLGEOMETRY, 32
TO_WKBGEOMETRY, 32
TO_WKTGEOMETRY, 32
VALIDATE_WKBGEOMETRY, 32
VALIDATE_WKTGEOMETRY, 32
SDO_VERSION function, 1.17
SDO_VOLUME function, 24
SDO_WFS_LOCK package, 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.2.2.2
segments
geometric, 7.1.1
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.9.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
SIGN_POST table
routing engine use of, 13.3.4
simple element, 2.2.4
simple features (OGC)
Oracle Spatial conformance, 1.16
simplification of geometries, 32
SIMPLIFY function, 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.18
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.7
sort_by_distance attribute
of batch route request, 13.2.5.2
spatial aggregate functions
See aggregate functions
spatial analysis and mining
conceptual and usage information, 8
function reference information, 29
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, 29
spatial data structures, 2
spatial data types, 2
spatial index
See index
spatial join, 5.2.2
SDO_JOIN operator, 19
spatial operators
See operators
spatial query, 5.2.1
spatial reference systems
conceptual and usage information, 6
example, 6.12
subprogram reference information, 21
spatial routing engine
See routing engine
Spatial 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_CLUSTERS function, 29
SPATIAL_CSW_ADMIN_USR account and schema, 1.14
SPATIAL_WFS_ADMIN_USR account and schema, 1.14
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.20
SQL Multimedia
avoiding name conflicts, 3.3
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.2
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.4.1
ST_CoordDim method, 2.3
ST_GEOMETRY type, 3.1
ST_IsValid method, 2.3
start location for route, 13.2.2.1
stop lines, 1.11.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
surface normal, 1.11.4
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
TFM_PLAN object type, 6.6
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.2.2.2
TINS
subprograms, 30
TINs
clipping, 30
converting to geometry, 30
creating, 28, 30
dropping dependencies, 30
initializing, 30
TINs (triangulated irregular networks), 1.11.1
TO_CURRENT procedure and function, 26
TO_GEOMETRY procedure, 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.2
with LRS functions, 7.6
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
preparing for when using spatial indexes, 32
triangulated irregular networks (TINs), 1.11.1
tuning and performance information, 1.15
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.10
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.1
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
USER_ANNOTATION_TEXT_METADATA view, 3.4.2
USER_SDO_GEOM_METADATA view, 2.8
USER_SDO_INDEX_INFO view, 2.9.1.1
USER_SDO_INDEX_METADATA view, 2.9.1.2
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_GEOMETRY_WITH_CONTEXT function, 24
VALIDATE_LAYER_WITH_CONTEXT procedure, 24
VALIDATE_LRS_GEOMETRY function, 25
VALIDATE_WKBGEOMETRY function, 32
VALIDATE_WKT function, 21
VALIDATE_WKTGEOMETRY function, 32
validation of geometries
general and two-dimensional checks, 24
three-dimensional checks, 1.11.4
vendor attribute
of route request, 13.2.2.2
version number (Spatial)
retrieving, 1.17
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
views
ALL_ANNOTATION_TEXT_METADATA, 3.4.2
ALL_SDO_GEOM_METADATA, 2.8
ALL_SDO_INDEX_INFO, 2.9.1.1
ALL_SDO_INDEX_METADATA, 2.9.1.2
USER_ANNOTATION_TEXT_METADATA, 3.4.2
USER_SDO_GEOM_METADATA, 2.8
USER_SDO_INDEX_INFO, 2.9.1.1
USER_SDO_INDEX_METADATA, 2.9.1.2
virtual private databases
Spatial Web services security, 17.2.1
volume, 24
VPDs
Spatial 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
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
wsclient.jar file, 10.4
WSConfig.xml file, 10.3

X

XML API
routing engine, 13.2
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