Index

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

Numerics

SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 13

type 0 (zero) element, 2.5.7

10g

upgrading spatial data to Oracle Database 10g, 17

formats of LRS functions, 7.4

not supported with geodetic data, 6.9.2

A

ADD_PREFERENCE_FOR_OP procedure, 13

addresses

representing for geocoding, 5.1.1

aggregate functions

description, 1.10

reference information, 12

SDO_AGGR_CENTROID, 12

SDO_AGGR_CONCAT_LINES, 12

SDO_AGGR_CONVEXHULL, 12

SDO_AGGR_LRS_CONCAT, 12

SDO_AGGR_MBR, 12

SDO_AGGR_UNION, 12

SDOAGGRTYPE object type, 1.10.1

AGGREGATES_FOR_GEOMETRY function, 18

AGGREGATES_FOR_LAYER function, 18

aliases, 6.6.2

ALL_SDO_GEOM_METADATA view, 2.6

ALL_SDO_INDEX_INFO view, 2.7.1.1

ALL_SDO_INDEX_METADATA view, 2.7.1.2

ALTER INDEX statement, 10

REBUILD clause, 10

RENAME TO clause, 10

angle units, 6.7.2

ANYINTERACT

SDO_ANYINTERACT operator, 11

topological relationship, 1.8

APPEND function, 20

application size (hardware) requirements, 1.17

arc

densifying, 15

not supported with geodetic data, 6.2.4

area, 15

area units, 2.8

average minimum bounding rectangle, 19

AVERAGE_MBR procedure, 19

B

batch route requests, C.2.5.1

DTD, C.2.5

example, C.2.4

batch route responses

DTD, C.2.6

example, C.2.4

batch_route_request element, C.2.5.1

bearing

point at, 20

BIN_GEOMETRY function, 18

BIN_LAYER procedure, 18

binning

spatial, 8.2

C

C language

examples (using OCI), 1.19

Cartesian coordinates, 1.5.4, 6.1.2

center of gravity (centroid), 15

centroid

SDO_AGGR_CENTROID aggregate function, 12

SDO_CENTROID function, 15

circle

creating polygon approximating, 20

not supported with geodetic data, 6.2.4

type, 2.2.4

CIRCLE_POLYGON function, 20

CLIP_GEOM_SEGMENT function, 16

clipping

geometric segment, 7.5.3

COLOCATED_REFERENCE_FEATURES procedure, 18

colocation mining, 8.4

column name

restrictions on spatial column names, 2.6.2

COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2.6.2

compatibility, A

complex examples

queries, D

compound element, 2.2.4

compound line string, 2.2.4, 2.5.3

compound polygon, 2.2.4

CONCAT_LINES function, 20

CONCATENATE_GEOM_SEGMENTS function, 16

concatenating

geometric segments, 7.5.5

line or multiline geometries, 12

LRS geometries, 7.5.5, 12

configuration

routing engine, C.1

CONNECTED_GEOM_SEGMENTS function, 16

consistency

checking for valid geometry types, 15

constraining data to a geometry type, 4.1.2

constructors

SDO_GEOMETRY object type, 2.4

CONTAINS

SDO_CONTAINS operator, 11

topological relationship, 1.8

CONVERSION_FACTOR column

in SDO_ANGLE_UNITS table, 6.7.2

in SDO_AREA_UNITS table, 2.8

in SDO_DIST_UNITS table, 2.8

CONVERT_NADCON_TO_XML procedure, 13

CONVERT_NTV2_TO_XML procedure, 13

CONVERT_TO_LRS_DIM_ARRAY function, 16

CONVERT_TO_LRS_GEOM function, 16

CONVERT_TO_LRS_LAYER function, 16

CONVERT_TO_STD_DIM_ARRAY function, 16

CONVERT_TO_STD_GEOM function, 16

CONVERT_TO_STD_LAYER function, 16

CONVERT_UNIT function, 20

CONVERT_XML_TO_NADCON procedure, 13

CONVERT_XML_TO_NTV2 procedure, 13

converting

geometric segments

overview, 7.5.10

subprograms for, 16

convex hull

SDO_AGGR_CONVEXHULL aggregate function, 12

SDO_CONVEXHULL function, 15

coordinate dimension

ST_CoordDim method, 2.3

coordinate reference systems

See coordinate systems

coordinate systems, 1.5.4

conceptual and usage information, 6

data structures supplied by Oracle, 6.6

example, 6.11

local, 6.3

subprogram reference information, 13

unit of measurement support, 2.8

user-defined, 6.8

coordinates

Cartesian, 1.5.4, 6.1.2

geodetic, 1.5.4, 6.1.3, 6.2

geographic, 1.5.4, 6.1.3

local, 1.5.4, 6.1.5

projected, 1.5.4, 6.1.4

COVEREDBY

SDO_COVEREDBY operator, 11

topological relationship, 1.8

COVERS

SDO_COVERS operator, 11

topological relationship, 1.8

CPU requirements for applications using Spatial, 1.17

CREATE INDEX statement, 10

CREATE_CONCATENATED_OP procedure, 13

CREATE_OBVIOUS_EPSG_RULES procedure, 13

CREATE_PREF_CONCATENATED_OP procedure, 13

creating

geometric segments

subprograms for, 16

cross-schema index creation, 4.1.3

CS_SRS table, 6.7.1

current release

upgrading spatial data to, 17

cutoff_distance attribute

of batch route request, C.2.5.2

D

data mining

spatial

colocation mining, 8.4

conceptual and usage information, 8

function reference information, 18

data model, 1.5

LRS, 7.2

data types

geocoding, 5.2

spatial, 2

database links

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

datum

geodetic, 1.5.4, 6.1.6

MDSYS.SDO_DATUMS_OLD_FORMAT table, 6.7.3

MDSYS.SDO_DATUMS_OLD_SNAPSHOT table, 6.7.3

transformation, 6.1.7

dblink

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

DEFINE_GEOM_SEGMENT procedure, 16

defining

geometric segment, 7.5.1

DELETE_ALL_EPSG_RULES procedure, 13

DELETE_OP procedure, 13

densification of arcs, 15

DETERMINE_CHAIN function, 13

DETERMINE_DEFAULT_CHAIN function, 13

difference

SDO_GEOM.SDO_DIFFERENCE function, 15

dimension (in SDO_GTYPE), 2.2.1, 2.2.1

Get_Dims method, 2.3

Get_LRS_Dim method, 2.3

DIMINFO (in USER_SDO_GEOM_METADATA), 2.6.3

direction of geometric segment, 7.1.3

concatenation result, 7.5.5

discretization (binning)

spatial, 8.2

E

EDGE table

routing engine use of, C.3.1

editing

geometric segments

subprograms for, 16

ELEM_INFO (SDO_ELEM_INFO attribute), 2.2.4

elements, 1.5.1

extracting from a geometry, 20

returning number of elements in a geometry, 20

returning number of vertices in a geometry, 20

ellipse

creating polygon approximating, 20

ELLIPSE_POLYGON function, 20

ellipsoids

MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table, 6.7.4

MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.7.4

embedded SDO_GEOMETRY object in user-defined type, 9.1

end location for route, C.2.2.1

EPSG, 6.6

EPSG SRID

mapping Oracle SRID to, 13

mapping to Oracle SRID, 13

EQUAL

SDO_EQUAL operator, 11

topological relationship, 1.8

error messages

geocoding, 5.1.4

Spatial, 1.18

ESTIMATE_RTREE_INDEX_SIZE function, 19

ETYPE (SDO_ETYPE value), 2.2.4, 2.2.4

European Petroleum Survey Group

See EPSG

examples

batch route request and response, C.2.4

C, 1.19

complex queries, D

coordinate systems, 6.11

creating, indexing, and querying spatial data, 2.1

directory for Spatial examples, 1.19

linear referencing system (LRS), 7.7

many geometry types (creating), 2.5

OCI (Oracle Call Interface), 1.19

PL/SQL, 1.19

route request and response, C.2.1

route request with previously geocoded locations, C.2.1

route response with previously geocoded locations, C.2.1

SQL, 1.19

exchanging partitions including indexes, 4.1.5

Export utility

with spatial indexes and data, 4.1.6

EXTENT_OF function, 19

exterior polygon rings, 2.2.4, 2.2.4, 2.5.2, 2.5.2

EXTRACT function, 20

F

features

linear, 7.1.10

FILTER

SDO_FILTER operator, 11

FILTER mask value for SDO_JOIN, 11

FIND_GEOG_CRS function, 13

FIND_LRS_DIM_POS function, 16

FIND_MEASURE function, 16

FIND_OFFSET function, 16

FIND_PROJ_CRS function, 13

formatted addresses, 5.1.1

FROM_815_TO_81X procedure

use TO_CURRENT instead, 17

FROM_OGC_SIMPLEFEATURE_SRS function, 13

FROM_USNG function, 13

FROM_WKBGEOMETRY function, 20

FROM_WKTGEOMETRY function, 20

function-based indexes

with SDO_GEOMETRY objects, 9.2

functions

spatial aggregate, 12

supported by approximations with geodetic data, 6.9.3

G

GC_AREA_<suffix> table, 5.5.1

GC_COUNTRY_PROFILE table, 5.5.2

GC_INTERSECTION_<suffix> table, 5.5.3

GC_POI_<suffix> table, 5.5.4

GC_POSTAL_CODE_<suffix> table, 5.5.5

GC_ROAD_<suffix> table, 5.5.6

GC_ROAD_SEGMENT_<suffix> table, 5.5.7

GEOCODE function, 14

GEOCODE_ADDR function, 14

GEOCODE_ADDR_ALL function, 14

GEOCODE_ALL function, 14

GEOCODE_AS_GEOMETRY function, 14

geocoding, 1.11

concepts, 5.1

data requirements, 5.3

data types for, 5.2

error messages, 5.1.4

from a place name, 5.4

match codes, 5.1.3

match modes, 5.1.2

reverse, 14

subprogram reference information, 14

usage information, 5

geocoding requests

DTD, C.2.7.1

geocoding responses

DTD, C.2.7.2

geodetic coordinates, 1.5.4, 6.1.3

arcs and circles not supported, 6.2.4

functions supported by approximations, 6.9.3

support for, 6.2

geodetic datum, 1.5.4, 6.1.6

geodetic indexes, 4.1.1

geodetic MBRs, 6.2.3

geographic coordinates

See geodetic coordinates

geography markup language (GML)

converting geometry to, 20

GEOM_SEGMENT_END_MEASURE function, 16

GEOM_SEGMENT_END_PT function, 16

GEOM_SEGMENT_LENGTH function, 16

GEOM_SEGMENT_START_MEASURE function, 16

GEOM_SEGMENT_START_PT function, 16

geometric segment

clipping, 7.5.3

concatenating, 7.5.5

aggregate, 7.5.5, 12

converting (overview), 7.5.10

converting (subprograms for), 16

creating (subprograms for), 16

defining, 7.5.1

definition of, 7.1.1

direction, 7.1.3

direction with concatenation, 7.5.5

editing (subprograms for), 16

locating point on, 7.5.8

offsetting, 7.5.7

projecting point onto, 7.5.9

querying (subprograms for), 16

redefining, 7.5.2

scaling, 7.5.6

splitting, 7.5.4

geometry subprograms

reference information, 15

geometry types, 1.4

constraining data to, 4.1.2

Get_GType method, 2.3

SDO_GTYPE, 2.2.1

GeoRaster

checks and actions after upgrade, A.2

Get_Dims method, 2.3

Get_GType method, 2.3

Get_LRS_Dim method, 2.3

GET_MEASURE function, 16

GET_NEXT_SHAPE_PT function, 16

GET_NEXT_SHAPE_PT_MEASURE function, 16

GET_PREV_SHAPE_PT function, 16

GET_PREV_SHAPE_PT_MEASURE function, 16

Get_WKB method, 2.3

Get_WKT method, 2.3

GETNUMELEM function, 20

GETNUMVERTICES function, 20

GETVERTICES function, 20

GML (geography markup language)

converting geometry to, 20

GTYPE (SDO_GTYPE attribute), 2.2.1

constraining data to a geometry type, 4.1.2

Get_Dims method, 2.3

Get_GType method, 2.3

GET_LRS_Dim method, 2.3

H

hardware requirements for applications using Spatial, 1.17

I

id attribute

of route request, C.2.2.2

Import utility

with spatial indexes and data, 4.1.6

indexes

creating, 4.1

cross-schema, 4.1.3

parallel execution, 10

description of Spatial indexing, 1.7

extending spatial indexing capabilities, 9

function-based with SDO_GEOMETRY objects, 9.2

geodetic and non-geodetic, 4.1.1

partitioned, 4.1.4

exchanging partitions including indexes, 4.1.5

quadtree

deprecated feature of Spatial, 1.7

rebuilding, 10

parallel execution, 10, 10

R-tree

description, 1.7.1

requirements before creating, 4.1

size (R-tree), 19

index-organized table

cannot create spatial index on, 2.6.1, 10

INITIALIZE_INDEXES_FOR_TTS procedure, 20

input_location element, C.2.2.3

inserting spatial data

PL/SQL, 3.2

INSIDE

SDO_INSIDE operator, 11

topological relationship, 1.8

installation, A

interMedia requirement for Locator, B

routing engine, C.1

INTEPRETATION (SDO_INTERPRETATION value), 2.2.4

interaction

ANYINTERACT, 1.8

interior

of an area, 1.8

interior polygon rings, 2.2.4, 2.2.4, 2.5.2, 2.5.2

interMedia

proper installation required for Locator, B

intersection, 15

intersections

GC_INTERSECTION_<suffix> table, 5.5.3

inverse flattening, 6.6.23, 6.7.4

IS_GEOM_SEGMENT_DEFINED function, 16

IS_MEASURE_DECREASING function, 16

IS_MEASURE_INCREASING function, 16

IS_SHAPE_PT_MEASURE function, 16

J

Java application programming interface (API) for Spatial, 1.12

join

SDO_JOIN operator, 11

L

language attribute

of route request, C.2.2.2

layer, 1.5.3

transforming, 13

validating with context, 15

layer_gtype

constraining data to a geometry type, 4.1.2

length

SDO_LENGTH function, 15

line

converting polygon to, 20

data, 1.5.1

length, 15

line string

boundary of, 1.8

compound, 2.2.4, 2.5.3

reversing, 20

self-crossing, 1.4

linear features, 7.1.10

linear measure, 7.1.4

linear referencing system (LRS)

3D formats of functions, 7.4

not supported with geodetic data, 6.9.2

conceptual and usage information, 7

data model, 7.2

example, 7.7

Get_LRS_Dim method, 2.3

limiting indexing to X and Y dimensions, 7.3

LRS points, 7.1.9

segments, 7.1.1

subprogram reference information, 16

tolerance values with LRS functions, 7.6

upgrading data to current release, A.1

loading spatial data, 3

local coordinate systems, 6.3

local coordinates, 1.5.4, 6.1.5

LOCAL partitioning

spatial indexes, 4.1.4

LOCATE_PT function, 16

location prospecting, 8.6

Locator, B

LRS

See linear referencing system (LRS)

LRS points, 7.1.9

M

map projections

MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.7.5

MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.7.5

MAP_EPSG_SRID_TO_ORACLE function, 13

MAP_ORACLE_SRID_TO_EPSG function, 13

match codes, 5.1.3

match modes, 5.1.2

MBR

See minimum bounding rectangle (MBR)

MDDATA schema, 1.13

MDSYS schema, 1.1

MDSYS.CS_SRS table, 6.7.1

MDSYS.SDO_ANGLE_UNITS table, 6.7.2

MDSYS.SDO_AREA_UNITS table, 2.8

MDSYS.SDO_CS package, 13

MDSYS.SDO_DATUMS_OLD_FORMAT table, 6.7.3

MDSYS.SDO_DATUMS_OLD_SNAPSHOT table, 6.7.3

MDSYS.SDO_DIST_UNITS table, 2.8

MDSYS.SDO_ELLIPSOIDS_OLD_FORMAT table, 6.7.4

MDSYS.SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.7.4

MDSYS.SDO_GCDR package, 14

MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.7.5

MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.7.5

MDSYS.SDO_SAM package, 18

measure, 7.1.4

populating, 7.1.6

resetting, 16

reversing, 16

with multiline strings and polygons with holes, 7.1.11

measure range, 7.1.7

MEASURE_RANGE function, 16

MEASURE_TO_PERCENTAGE function, 16

messages

Spatial error messages, 1.18

methods

SDO_GEOMETRY object type, 2.3

migration

See upgrading

minimum bounding rectangle (MBR)

AVERAGE_MBR procedure, 19

EXTENT_OF function, 19

geodetic, 6.2.3

SDO_AGGR_MBR aggregate function, 12

SDO_MAX_MBR_ORDINATE function, 15

SDO_MBR function, 15

SDO_MIN_MBR_ORDINATE function, 15

mining

See data mining

MIX_INFO procedure, 19

multiline string

boundary of, 1.8

LRS measure values, 7.1.11

multimaster replication

SDO_GEOMETRY objects, B

multipolygon, 2.5.2

N

NaC coordinate reference system, 6.9.4

NADCON grids

converting Spatial XML format to NADCON format, 13

converting to Spatial XML format, 13

naming considerations

Spatial table and column names, 2.6

nearest neighbor

SDO_NN operator, 11

SDO_NN_DISTANCE operator, 11

neighborhood influence, 8.3

NLS_LENGTH_SEMANTICS parameter

spatial queries on UTF8 data, 4.2

NODE table

routing engine use of, C.3.2

non-geodetic indexes, 4.1.1

NTv2 grids

converting Spatial XML format to NTv2 format, 13

converting to Spatial XML format, 13

O

object types

embedding SDO_GEOMETRY objects in, 9.1, 9.2.2

OCG (Open Geospatial Consortium) simple features conformance, 1.15

OCI (Oracle Call Interface) examples, 1.19

ODM

See Oracle Data Mining (ODM)

offset, 7.1.5

FIND_OFFSET function, 16

OFFSET_GEOM_SEGMENT function, 16

offsetting

geometric segment, 7.5.7

SDO_ON operator, 11

topological relationship, 1.8

Open Geospatial Consortium (OCG) simple features conformance, 1.15

operators

cross-schema invocation, 4.2.3

ORDERED optimizer hint with, 1.9

SDO_FILTER, 11

SDO_JOIN, 11

overview, 1.9

performance-related guidelines, 1.9

SDO_ANYINTERACT, 11

SDO_CONTAINS, 11

SDO_COVEREDBY, 11

SDO_COVERS, 11

SDO_EQUAL, 11

SDO_FILTER, 11

SDO_INSIDE, 11

SDO_JOIN, 11

SDO_NN, 11

SDO_NN_DISTANCE, 11

SDO_ON, 11

SDO_OVERLAPBDYDISJOINT, 11

SDO_OVERLAPBDYINTERSECT, 11

SDO_OVERLAPS, 11

SDO_RELATE, 11

SDO_TOUCH, 11

SDO_WITHIN_DISTANCE, 11

optimized rectangle, 2.2.4

optimizer hint (ORDERED) with spatial operators, 1.9

SDO_FILTER, 11

SDO_JOIN, 11

Oracle Call Interface (OCI) examples, 1.19

Oracle Data Mining (ODM)

spatial analysis and mining information, 8

Oracle Database 10g

upgrading Spatial to, A

Oracle Locator

See Locator

ORDERED optimizer hint with spatial operators, 1.9

SDO_FILTER, 11

SDO_JOIN, 11

oriented point

illustration and example, 2.5.6

OVERLAPBDYDISJOINT

SDO_OVERLAPBDYDISJOINT operator, 11

topological relationship, 1.8

OVERLAPBDYINTERSECT

SDO_OVERLAPBDYINTERSECT operator, 11

topological relationship, 1.8

OVERLAPS

SDO_OVERLAPS operator, 11

P

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

PARTITION table

routing engine use of, C.3.3

partitioned spatial indexes, 4.1.4

exchanging partitions, 4.1.5

PERCENTAGE_TO_MEASURE function, 16

performance and tuning information, 1.14

for Spatial operators, 1.9

PL/SQL and SQL examples, 1.19

point

data, 1.5.1

illustration and examples of point-only geometry, 2.5.5

locating on geometric segment, 7.5.8

LRS, 7.1.9

on surface of polygon, 15

oriented point, 2.5.6

projection of onto geometric segment, 7.1.8, 7.5.9

shape, 7.1.2

point of interest (POI)

GC_POI_<suffix> table, 5.5.4

POINT_AT_BEARING function, 20

polygon

area of, 15

boundary of, 1.8

buffer, 15

centroid, 15

compound, 2.2.4

exterior and interior rings, 2.2.4, 2.2.4, 2.5.2, 2.5.2

point on surface, 15

self-crossing not supported, 1.4

with hole (LRS measure values), 7.1.11

polygon collection, 2.5.2

polygon data, 1.5.1

POLYGONTOLINE function, 20

populating

measure, 7.1.6

pre_geocoded_location element, C.2.2.4

pre_geocoded_locations attribute

of route request, C.2.2.2

PREPARE_FOR_TTS procedure, 20

primary filter, 1.6, 4.2.1.1, 4.2.1.2

primitive types, 1.4

problems in current release, 6.9

geodetic data, 6.2.4

PROJECT_PT function, 16

projected coordinates, 1.5.4, 6.1.4

projections, 7.1.8, 7.5.9

MDSYS.SDO_PROJECTIONS_OLD_FORMAT table, 6.7.5

MDSYS.SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.7.5

PROJECT_PT function, 16

Q

quadtree indexes

deprecated feature of Spatial, 1.7

quality

degradation of R-tree index, 19

R-tree, 1.7.2

QUALITY_DEGRADATION function, 19

query, 4.2.1

query model for Spatial, 1.6

query window, 4.2.1

querying geometric segments

subprograms for, 16

R

range

measure, 7.1.7

README file

for Spatial, GeoRaster, and topology and network data models, 1.20

rebuilding

spatial indexes, 10

rectangle

minimum bounding, 19

type, 2.2.4

rectification of geometries, 20

RECTIFY_GEOMETRY function, 20

REDEFINE_GEOM_SEGMENT procedure, 16

redefining

geometric segment, 7.5.2

RELATE function, 15

S

scaling

geometric segment, 7.5.6

schemas

creating index on table in another schema, 4.1.3

invoking operators on table in another schema, 4.2.3

SDO_ADDR_ARRAY data type, 5.2.2

SDO_AGGR_CENTROID aggregate function, 12

SDO_AGGR_CONCAT_LINES aggregate function, 12

SDO_AGGR_CONVEXHULL aggregate function, 12

SDO_AGGR_LRS_CONCAT aggregate function, 12

SDO_AGGR_MBR aggregate function, 12

SDO_AGGR_UNION aggregate function, 12

complex examples, D.4

SDO_ANGLE_UNITS table, 6.7.2

SDO_ANYINTERACT operator, 11

SDO_ARC_DENSIFY function, 15

SDO_AREA function, 15

SDO_AREA_UNITS table, 2.8

SDO_BUFFER function, 15

SDO_CENTROID function, 15

SDO_CONTAINS operator, 11

SDO_CONVEXHULL function, 15

SDO_COORD_AXES table, 6.6.1

SDO_COORD_AXIS_NAMES table, 6.6.2

SDO_COORD_OP_METHODS table, 6.6.3

SDO_COORD_OP_PARAM_USE table, 6.6.4

SDO_COORD_OP_PARAM_VALS table, 6.6.5

SDO_COORD_OP_PARAMS table, 6.6.6

SDO_COORD_OP_PATHS table, 6.6.7

SDO_COORD_OPS table, 6.6.8

SDO_COORD_REF_SYS table, 6.6.9

SDO_COORD_REF_SYSTEM view, 6.6.10

SDO_COORD_SYS table, 6.6.11

SDO_COVEREDBY operator, 11

SDO_COVERS operator, 11

SDO_CRS_COMPOUND view, 6.6.12

SDO_CRS_ENGINEERING view, 6.6.13

SDO_CRS_GEOCENTRIC view, 6.6.14

SDO_CRS_GEOGRAPHIC2D view, 6.6.15

SDO_CRS_GEOGRAPHIC3D view, 6.6.16

SDO_CRS_PROJECTED view, 6.6.17

SDO_CRS_VERTICAL view, 6.6.18

SDO_CS package, 13

ADD_PREFERENCE_FOR_OP, 13

CONVERT_NADCON_TO_XML, 13

CONVERT_NTV2_TO_XML, 13

CONVERT_XML_TO_NADCON, 13

CONVERT_XML_TO_NTV2, 13

CREATE_CONCATENATED_OP, 13

CREATE_OBVIOUS_EPSG_RULES, 13

CREATE_PREF_CONCATENATED_OP, 13

DELETE_ALL_EPSG_RULES, 13

DELETE_OP, 13

DETERMINE_CHAIN, 13

DETERMINE_DEFAULT_CHAIN, 13

FIND_GEOG_CRS, 13

FIND_PROJ_CRS, 13

FROM_OGC_SIMPLEFEATURE_SRS, 13

FROM_USNG, 13

MAP_EPSG_SRID_TO_ORACLE, 13

MAP_ORACLE_SRID_TO_EPSG, 13

REVOKE_PREFERENCE_FOR_OP, 13

TO_OGC_SIMPLEFEATURE_SRS, 13

TO_USNG, 13

TRANSFORM, 13

TRANSFORM_LAYER, 13

UPDATE_WKTS_FOR_ALL_EPSG_CRS, 13

UPDATE_WKTS_FOR_EPSG_CRS, 13

UPDATE_WKTS_FOR_EPSG_DATUM, 13

UPDATE_WKTS_FOR_EPSG_ELLIPS, 13

UPDATE_WKTS_FOR_EPSG_OP, 13

UPDATE_WKTS_FOR_EPSG_PARAM, 13

UPDATE_WKTS_FOR_EPSG_PM, 13

VALIDATE_WKT, 13

VIEWPORT_TRANSFORM, 13

SDO_DATUM_ENGINEERING view, 6.6.19

SDO_DATUM_GEODETIC view, 6.6.20

SDO_DATUM_VERTICAL view, 6.6.21

SDO_DATUMS table, 6.6.22

SDO_DATUMS_OLD_FORMAT table, 6.7.3

SDO_DATUMS_OLD_SNAPSHOT table, 6.7.3

SDO_DIFFERENCE function, 15

SDO_DIST_UNITS table, 2.8

SDO_DISTANCE function, 15

SDO_ELEM_INFO attribute, 2.2.4

SDO_ELEM_INFO_ARRAY type, 2.2

SDO_ELLIPSOIDS table, 6.6.23

SDO_ELLIPSOIDS_OLD_FORMAT table, 6.7.4

SDO_ELLIPSOIDS_OLD_SNAPSHOT table, 6.7.4

SDO_EQUAL operator, 11

SDO_ETYPE value, 2.2.4, 2.2.4

SDO_FILTER operator, 11

SDO_GCDR package, 14

GEOCODE, 14

GEOCODE_ADDR, 14

GEOCODE_ADDR_ALL, 14

GEOCODE_ALL, 14

GEOCODE_AS_GEOMETRY, 14

REVERSE_GEOCODE, 14

SDO_GEO_ADDR data type and constructors, 5.2.1

SDO_GEOM package

RELATE, 15

SDO_ARC_DENSIFY, 15

SDO_AREA, 15

SDO_BUFFER, 15

SDO_CENTROID, 15

SDO_CONVEXHULL, 15

SDO_DIFFERENCE, 15

SDO_DISTANCE, 15

SDO_INTERSECTION, 15

SDO_LENGTH, 15

SDO_MAX_MBR_ORDINATE, 15

SDO_MBR, 15

SDO_MIN_MBR_ORDINATE, 15

SDO_POINTONSURFACE, 15

SDO_UNION, 15

SDO_XOR, 15

VALIDATE_GEOMETRY_WITH_CONTEXT, 15

VALIDATE_LAYER_WITH_CONTEXT, 15

WITHIN_DISTANCE, 15

SDO_GEOMETRY object type, 2.2

constructors, 2.4

embedding in user-defined type, 9.1, 9.2.2

in function-based indexes, 9.2

methods (member functions), 2.3

SDO_GTYPE attribute, 2.2.1

constraining data to a geometry type, 4.1.2

Get_Dims method, 2.3

Get_GType method, 2.3

Get_LRS_Dim method, 2.3

SDO_INDEX_TABLE entry in index metadata views, 2.7.2

SDO_INDX_DIMS keyword, 7.3, 10

SDO_INSIDE operator, 11

SDO_INTERPRETATION value, 2.2.4

SDO_INTERSECTION function, 15

SDO_JOIN operator, 11

SDO_KEYWORDARRAY data type, 5.2.3

SDO_LENGTH function, 15

SDO_LRS package

CLIP_GEOM_SEGMENT, 16

CONCATENATE_GEOM_SEGMENTS, 16

CONNECTED_GEOM_SEGMENTS, 16

CONVERT_TO_LRS_DIM_ARRAY, 16

CONVERT_TO_LRS_GEOM, 16

CONVERT_TO_LRS_LAYER, 16

CONVERT_TO_STD_DIM_ARRAY, 16

CONVERT_TO_STD_GEOM, 16

CONVERT_TO_STD_LAYER, 16

DEFINE_GEOM_SEGMENT, 16

DYNAMIC_SEGMENT, 16

FIND_LRS_DIM_POS, 16

FIND_MEASURE, 16

FIND_OFFSET, 16

GEOM_SEGMENT_END_MEASURE, 16

GEOM_SEGMENT_END_PT, 16

GEOM_SEGMENT_LENGTH, 16

GEOM_SEGMENT_START_MEASURE, 16

GEOM_SEGMENT_START_PT, 16

GET_MEASURE, 16

GET_NEXT_SHAPE_PT, 16

GET_NEXT_SHAPE_PT_MEASURE, 16

GET_PREV_SHAPE_PT, 16

GET_PREV_SHAPE_PT_MEASURE, 16

IS_GEOM_SEGMENT_DEFINED, 16

IS_MEASURE_DECREASING, 16

IS_MEASURE_INCREASING, 16

IS_SHAPE_PT_MEASURE, 16

LOCATE_PT, 16

MEASURE_RANGE, 16

MEASURE_TO_PERCENTAGE, 16

OFFSET_GEOM_SEGMENT, 16

PERCENTAGE_TO_MEASURE, 16

PROJECT_PT, 16

REDEFINE_GEOM_SEGMENT, 16

RESET_MEASURE, 16

REVERSE_GEOMETRY, 16

REVERSE_MEASURE, 16

SET_PT_MEASURE, 16

SPLIT_GEOM_SEGMENT, 16

TRANSLATE_MEASURE, 16

VALID_GEOM_SEGMENT, 16

VALID_LRS_PT, 16

VALID_MEASURE, 16

VALIDATE_LRS_GEOMETRY, 16

SDO_MAX_MBR_ORDINATE function, 15

SDO_MBR function, 15

SDO_MIGRATE package

TO_CURRENT, 17

SDO_MIN_MBR_ORDINATE function, 15

SDO_NN operator, 11

complex examples, D.3

optimizer hints, 11

SDO_NN_DISTANCE ancillary operator, 11

SDO_NN_DISTANCE operator

complex examples, D.3

SDO_ON operator, 11

SDO_ORDINATE_ARRAY type, 2.2

SDO_ORDINATES attribute, 2.2.5

SDO_OVERLAPBDYDISJOINT operator, 11

SDO_OVERLAPBDYINTERSECT operator, 11

SDO_OVERLAPS operator, 11

SDO_POINT attribute, 2.2.3

SDO_POINT_TYPE object type, 2.2

SDO_POINTONSURFACE function, 15

SDO_PREFERRED_OPS_SYSTEM table, 6.6.24

SDO_PREFERRED_OPS_USER table, 6.6.25

SDO_PRIME_MERIDIANS table, 6.6.26

SDO_PROJECTIONS_OLD_FORMAT table, 6.7.5

SDO_PROJECTIONS_OLD_SNAPSHOT table, 6.7.5

SDO_REGAGGR object type, 18, 18

SDO_REGAGGRSET object type, 18, 18

SDO_REGION object type, 18

SDO_REGIONSET object type, 18

SDO_RELATE operator, 11

SDO_ROWIDPAIR object type, 11

SDO_ROWIDSET data type, 11

SDO_RTREE_SEQ_NAME sequence object, 2.7.3

SDO_SAM package, 18

AGGREGATES_FOR_GEOMETRY, 18

AGGREGATES_FOR_LAYER, 18

BIN_GEOMETRY, 18

BIN_LAYER, 18

COLOCATED_REFERENCE_FEATURES, 18

SIMPLIFY_GEOMETRY, 18

SIMPLIFY_LAYER, 18

SPATIAL_CLUSTERS, 18

TILED_AGGREGATES, 18

TILED_BINS, 18

SDO_SRID attribute, 2.2.2

SDO_STARTING_OFFSET value, 2.2.4

SDO_TFM_CHAIN type, 6.5

SDO_TOUCH operator, 11

SDO_TUNE package

AVERAGE_MBR, 19

ESTIMATE_RTREE_INDEX_SIZE, 19

EXTENT_OF, 19

MIX_INFO, 19

QUALITY_DEGRADATION, 19

SDO_UNION function, 15

SDO_UNIT column

in SDO_AREA_UNITS table, 2.8

in SDO_DIST_UNITS table, 2.8

SDO_UNITS_OF_MEASURE table, 6.6.27

SDO_UTIL package

APPEND, 20

CIRCLE_POLYGON, 20

CONCAT_LINES, 20

CONVERT_UNIT, 20

ELLIPSE_POLYGON, 20

EXTRACT, 20

FROM_WKBGEOMETRY, 20

FROM_WKTGEOMETRY, 20

GETNUMELEM, 20

GETNUMVERTICES, 20

GETVERTICES, 20

INITIALIZE_INDEXES_FOR_TTS, 20

POINT_AT_BEARING, 20

POLYGONTOLINE, 20

PREPARE_FOR_TTS, 20

RECTIFY_GEOMETRY, 20

REMOVE_DUPLICATE_VERTICES, 20

REVERSE_LINESTRING, 20

SIMPLIFY, 20

TO_GMLGEOMETRY, 20

TO_WKBGEOMETRY, 20

TO_WKTGEOMETRY, 20

VALIDATE_WKBGEOMETRY, 20

VALIDATE_WKTGEOMETRY, 20

SDO_VERSION function, 1.16

SDO_WITHIN_DISTANCE operator, 11

complex examples, D.2

SDO_XOR function, 15

SDOAGGRTYPE object type, 1.10.1

secondary filter, 1.6, 4.2.1.2

segment geometry

in route request, C.2.2.2

segments

geometric, 7.1.1

self-crossing line strings and polygons, 1.4

semi-major axis, 6.6.23, 6.7.4

semi-minor axis, 6.6.23

sequence object for R-tree index, 2.7.3

SET_PT_MEASURE procedure, 16

shape point, 7.1.2

determining if measure value is a shape point, 16

getting measure of next, 16

getting measure of previous, 16

getting next, 16

getting previous, 16

SIGN_POST table

routing engine use of, C.3.4

simple element, 2.2.4

simple features (OGC)

Oracle Spatial conformance, 1.15

simplification of geometries, 20

SIMPLIFY function, 20

SIMPLIFY_GEOMETRY function, 18

SIMPLIFY_LAYER procedure, 18

size requirements (hardware) for spatial applications, 1.17

SORT_AREA_SIZE parameter

R-tree index creation, 4.1

sort_by_distance attribute

of batch route request, C.2.5.2

spatial aggregate functions

See aggregate functions

spatial analysis and mining

conceptual and usage information, 8

function reference information, 18

spatial binning, 8.2

T

table names

restrictions on spatial table names, 2.6.1

TABLE_NAME (in USER_SDO_GEOM_METADATA), 2.6.1

TFM_PLAN object type, 6.5

three-dimensional (3D)

formats of LRS functions, 7.4

not supported with geodetic data, 6.9.2

TILED_AGGREGATES function, 18

TILED_BINS function, 18

time_unit attribute

of route request, C.2.2.2

TO_81X procedure

use TO_CURRENT instead, 17

TO_CURRENT procedure and function, 17

TO_GMLGEOMETRY function, 20

TO_OGC_SIMPLEFEATURE_SRS function, 13

TO_USNG function, 13

TO_WKBGEOMETRY function, 20

TO_WKTGEOMETRY function, 20

tolerance, 1.5.5

with LRS functions, 7.6

TOUCH

SDO_TOUCH operator, 11

topological relationship, 1.8

transactional insertion of spatial data, 3.2

TRANSFORM function, 13

TRANSFORM_LAYER procedure, 13

table for transformed layer, 13

transformation, 6.1.7

TRANSLATE_MEASURE function, 16

transportable tablespaces

initializing spatial indexes, 20

preparing for when using spatial indexes, 20

tuning and performance information, 1.14

for spatial operators, 1.9

tuning subprograms, 19

two-tier query model, 1.6

type zero (0) element, 2.5.7

U

unformatted addresses, 5.1.1

union, 15

unit of measurement

MDSYS tables, 2.8

UNIT_NAME column

in SDO_ANGLE_UNITS table, 6.7.2

in SDO_AREA_UNITS table, 2.8

in SDO_DIST_UNITS table, 2.8

unknown CRS coordinate reference system, 6.9.4

UPDATE_WKTS_FOR_ALL_EPSG_CRS procedure, 13

UPDATE_WKTS_FOR_EPSG_CRS procedure, 13

UPDATE_WKTS_FOR_EPSG_DATUM procedure, 13

UPDATE_WKTS_FOR_EPSG_ELLIPS procedure, 13

UPDATE_WKTS_FOR_EPSG_OP procedure, 13

UPDATE_WKTS_FOR_EPSG_PARAM procedure, 13

UPDATE_WKTS_FOR_EPSG_PM procedure, 13

upgrading

data to current Spatial release, 17

GeoRaster, A.2

LRS data, A.1

Spatial to current Oracle Database release, A

U.S. National Grid

SDO_CS.FROM_USNG function, 13

SDO_CS.TO_USNG function, 13

support in Oracle Spatial, 6.10

use cases

for coordinate system transformation, 6.4

USER_SDO_GEOM_METADATA view, 2.6

USER_SDO_INDEX_INFO view, 2.7.1.1

USER_SDO_INDEX_METADATA view, 2.7.1.2

user-defined coordinate reference system, 6.8

user-defined data types

embedding SDO_GEOMETRY objects in, 9.1, 9.2.2

UTF8 character set

NLS_LENGTH_SEMANTICS setting for spatial queries, 4.2

utility subprograms, 20

V

VALID_GEOM_SEGMENT function, 16

VALID_LRS_PT function, 16

VALID_MEASURE function, 16

VALIDATE_GEOMETRY_WITH_CONTEXT function, 15

VALIDATE_LAYER_WITH_CONTEXT procedure, 15

VALIDATE_LRS_GEOMETRY function, 16

VALIDATE_WKBGEOMETRY function, 20

VALIDATE_WKT function, 13

VALIDATE_WKTGEOMETRY function, 20

vendor attribute

of route request, C.2.2.2

version number (Spatial)

retrieving, 1.16

VERTEX_SET_TYPE data type, 20

VERTEX_TYPE object type, 20

vertices

maximum number in SDO_GEOMETRY object, 2.2

removing duplicate, 20

returning geometry coordinates as, 20

VIEWPORT_TRANSFORM function, 13

views

ALL_SDO_GEOM_METADATA, 2.6

ALL_SDO_INDEX_INFO, 2.7.1.1

ALL_SDO_INDEX_METADATA, 2.7.1.2

USER_SDO_GEOM_METADATA, 2.6

USER_SDO_INDEX_INFO, 2.7.1.1

USER_SDO_INDEX_METADATA, 2.7.1.2

W

well-known binary (WKB)

See WKB

well-known text (WKT)

See WKT

WITHIN_DISTANCE function, 15

X

XML API

routing engine, C.2

XOR

SDO_XOR function, 15

Z

zero

SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 13

type 0 element, 2.5.7