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

type 0 (zero) element, 2.7.7

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_GEOM_METADATA view, 2.8

ALL_SDO_INDEX_INFO view, 2.9.1.1

ALL_SDO_INDEX_METADATA view, 2.9.1.2

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.19

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

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

C

C language

examples (using OCI), 1.21

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_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

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

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.13

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.19

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.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 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

E

.ear file

configuring for Spatial 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.20

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.21

complex queries, C

coordinate systems, 6.13

creating, indexing, and querying spatial data, 2.1

directory for Spatial examples, 1.21

linear referencing system (LRS), 7.7

many geometry types (creating), 2.7

OCI (Oracle Call Interface), 1.21

PL/SQL, 1.21

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.21

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

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.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

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.19

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 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 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.16

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.16

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.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

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 for route segment, 13.3.2.1

location prospecting, 8.6

Locator, B

manually installing, B.1

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

mddins.sql script, B.1

mdinst.sql script, B.1

MDSYS schema, 1.1

MDSYS.CS_SRS table, 6.8.1

MDSYS.MOVE_SDO procedure, 1.18

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.20

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

MOVE_SDO procedure, 1.18

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

normal vector, 1.11.5

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.21

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

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.21

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

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.15

for Spatial operators, 1.9

PL/SQL and SQL examples, 1.21

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

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.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

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.22

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

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_SET_UNION aggregate function, 20

SDO_AGGR_UNION aggregate function, 20

complex examples, C.4

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_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_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_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_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.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

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

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

EXTRACT_ALL, 32

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

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

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

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.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.19

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.3.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

T

table names

restrictions on spatial table names, 2.8.1

TABLE_NAME (in USER_SDO_GEOM_METADATA), 2.8.1

textures

using, 1.11.4

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.3.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.3

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

triangulation

SDO_TRIANGULATE function, 24

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

USE_SPHERICAL use case name, 6.12

USER_ANNOTATION_TEXT_METADATA view, 3.5.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.5

vendor attribute

of route request, 13.3.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.5.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.5.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

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

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)

Z

zero

type 0 element, 2.7.7