Oracle Spatial User's Guide and Reference -- Index

_3D

formats of LRS functions, 6-9

0

SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 14-8

type 0 (zero) element, 2-21

3D

formats of LRS functions, 6-9

9i

changes to this guide for Oracle9i, xxi

migrating to Oracle9i, 16-11

aggregate functions

description, 1-23

SDO_AGGR_CENTROID, 13-2

SDO_AGGR_CONVEXHULL, 13-4

SDO_AGGR_LRS_CONCAT, 13-5

SDO_AGGR_MBR, 13-7

SDO_AGGR_UNION, 13-8

SDOAGGRTYPE object type, 1-24

ALL_SDO_GEOM_METADATA view, 2-24

ALL_SDO_INDEX_INFO view, 2-27

ALL_SDO_INDEX_METADATA view, 2-27

ALTER INDEX statement, 9-2

REBUILD clause, 9-5

RENAME TO clause, 9-8

ANALYZE_RTREE procedure, 17-3

angle units, 5-10

ANYINTERACT mask relationship, 12-5

arc

densifying, 12-7

not supported with geodetic data, 5-4

area, 12-10

authalic sphere, 5-2

average minimum bounding rectangle, 17-5

AVERAGE_MBR procedure, 17-5

batch geocoding, 7-4

bounding rectangle

minimum, 17-17

buffer area, 12-12

bulk loading of spatial data, 3-1

C language

examples (using OCI), 1-26

Cartesian coordinates, 1-6, 5-1

center of gravity (centroid), 12-16

centroid

SDO_AGGR_CENTROID aggregate function, 13-2

SDO_CENTROID function, 12-16

changes and new features for Oracle9i, xxi

circle

not supported with geodetic data, 5-4

type, 2-12

CLIP_GEOM_SEGMENT function, 15-5

clipping a geometric segment, 6-12

COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2-25

compatibility mode

changing to, A-3

compound element, 2-10

compound line string, 2-13, 2-18

compound polygon, 2-13

CONCATENATE_GEOM_SEGMENTS function, 15-7

concatenating geometric segments, 6-13

aggregate concatenation, 6-15, 13-5

CONNECTED_GEOM_SEGMENTS function, 15-10

consistency

checking for valid geometry types, 12-45

constraining data to a geometry type, 4-6

CONTAINS mask relationship, 12-5

CONVERSION_FACTOR column

in SDO_ANGLE_UNITS table, 5-10

in SDO_AREA_UNITS table, 2-32

in SDO_DIST_UNITS table, 2-32

CONVERSION_FACTOR column in SDO_DIST_UNITS table, 5-11

CONVERT_TO_LRS_DIM_ARRAY function, 15-12

CONVERT_TO_LRS_GEOM function, 15-15

CONVERT_TO_LRS_LAYER function, 15-18

CONVERT_TO_STD_DIM_ARRAY function, 15-21

CONVERT_TO_STD_GEOM function, 15-23

CONVERT_TO_STD_LAYER function, 15-25

converting

geometric segments

functions for, 15-3

overview, 6-19

convex hull

SDO_AGGR_CONVEXHULL aggregate function, 13-4

SDO_CONVEXHULL function, 12-18

coordinate systems

conceptual and usage information, 5-1

example, 5-15

function reference information, 14-1

local, 5-5

user-defined, 5-13

coordinates

Cartesian, 1-6, 5-1

geodetic, 1-6, 5-2, 5-3

geographic, 1-6, 5-2

local, 5-2

projected, 1-7, 5-2

COVEREDBY mask relationship, 12-5

COVERS mask relationship, 12-5

CREATE INDEX statement, 9-9

creating

geometric segments

functions for, 15-1

CS_SRS table, 5-6

current release

migrating to, 16-11

data model, 1-5

LRS, 6-7

datum

geodetic, 1-6, 5-2

MDSYS.SDO_DATUMS table, 5-11

transformation, 5-2

DBA_SDO_GEOM_METADATA view, 2-24

DBA_SDO_INDEX_INFO view, 2-27

DBA_SDO_INDEX_METADATA view, 2-27

DEFINE_GEOM_SEGMENT function, 15-27

defining a gemoetric segment, 6-10

densification of arcs, 12-7

difference, 12-20

dimension (in SDO_GTYPE), 2-6, 2-7

GET_DIMS method, 10-2

GET_LRS_DIM method, 10-4

DIMINFO (in USER_SDO_GEOM_METADATA), 2-25

direction of geometric segment, 6-3

concatenation result, 6-14

DISJOINT mask relationship, 12-5

distance

SDO_NN_DISTANCE ancillary operator, 11-11

WITHIN_DISTANCE function, 12-51

distance units, 5-10

DROP INDEX statement, 9-15

dynamic query window, 4-12

DYNAMIC_SEGMENT function, 15-30

editing

geometric segments

functions for, 15-1

ELEM_INFO (SDO_ELEM_INFO), 2-9

element, 1-5

ellipsoids, 5-12

embedded SDO_GEOMETRY object in user-defined type, 8-1

enabling third-party geocoders, 7-11

EQUAL mask relationship, 12-5

error messages, xxiii

ESTIMATE_INDEX_PERFORMANCE function, 17-7

ESTIMATE_TILING_LEVEL function, 17-10

ESTIMATE_TILING_TIME function, 17-12

ESTIMATE_TOTAL_NUMTILES function, 17-14

ETYPE (SDO_ETYPE), 2-9

examples

C, 1-26

coordinate systems, 5-15

creating, indexing, and querying spatial data, 2-1

directory, 1-26

Linear Referencing System (LRS), 6-20

OCI (Oracle Call Interface), 1-26

PL/SQL, 1-26

SQL, 1-26

EXTENT_OF function, 17-17

exterior polygon rings, 2-7, 2-9, 2-10, 2-15, 2-17

features

linear, 6-6

FIND_LRS_DIM_POS function, 15-32

FIND_MEASURE function, 15-33

fixed indexing, 1-16

fixed-size tiles, 4-3

FROM_815_TO_81x procedure, 16-2

function-based index

with SDO_GEOMETRY objects, 8-3

function-based indexes

privilege and session requirements, 8-4

functions and procedures

ANALYZE_RTREE, 17-3

AVERAGE_MBR, 17-5

CLIP_GEOM_SEGMENT, 15-5

CONCATENATE_GEOM_SEGMENTS, 15-7

CONNECTED_GEOM_SEGMENTS, 15-10

CONVERT_TO_LRS_DIM_ARRAY, 15-12

CONVERT_TO_LRS_GEOM, 15-15

CONVERT_TO_LRS_LAYER, 15-18

CONVERT_TO_STD_DIM_ARRAY, 15-21

CONVERT_TO_STD_GEOM, 15-23

CONVERT_TO_STD_LAYER, 15-25

DEFINE_GEOM_SEGMENT, 15-27

DYNAMIC_SEGMENT, 15-30

ESTIMATE_INDEX_PERFORMANCE, 17-7

ESTIMATE_TILING_LEVEL, 17-10

ESTIMATE_TILING_TIME, 17-12

ESTIMATE_TOTAL_NUMTILES, 17-14

EXTENT_OF, 17-17

FIND_LRS_DIM_POS, 15-32

FIND_MEASURE, 15-33

FROM_815_TO_81x, 16-2

GEOM_SEGMENT_END_MEASURE, 15-45

GEOM_SEGMENT_END_PT, 15-37

GEOM_SEGMENT_LENGTH, 15-39

GEOM_SEGMENT_START_MEASURE, 15-41

GEOM_SEGMENT_START_PT, 15-43

GET_MEASURE, 15-45

HISTOGRAM_ANALYSIS, 17-19

IS_GEOM_SEGMENT_DEFINED, 15-47

IS_MEASURE_DECREASING, 15-49

IS_MEASURE_INCREASING, 15-51

LOCATE_PT, 15-53

MEASURE_RANGE, 15-55

MEASURE_TO_PERCENTAGE, 15-57

MIX_INFO, 17-21

not supported with geodetic data, 5-15

OFFSET_GEOM_SEGMENT, 15-59

OGIS_METADATA_FROM, 16-4

OGIS_METADATA_TO, 16-5

PERCENTAGE_TO_MEASURE, 15-63

PROJECT_PT, 15-65

QUALITY_DEGRADATION, 17-23

REDEFINE_GEOM_SEGMENT, 15-67

RELATE, 12-4

RESET_MEASURE, 15-70

REVERSE_GEOMETRY, 15-72

REVERSE_MEASURE, 15-74

RTREE_QUALITY, 17-25

SCALE_GEOM_SEGMENT, 15-76

SDO_AGGR_CENTROID, 13-2

SDO_AGGR_CONVEXHULL, 13-4

SDO_ARC_DENSIFY, 12-7

SDO_AREA, 12-10

SDO_BUFFER, 12-12

SDO_CENTROID, 12-16

SDO_CONVEXHULL, 12-18

SDO_DIFFERENCE, 12-20

SDO_DISTANCE, 12-23

SDO_INTERSECTION, 12-25

SDO_LENGTH, 12-28

SDO_MAX_MBR_ORDINATE, 12-31

SDO_MBR, 12-33

SDO_MIN_MBR_ORDINATE, 12-35

SDO_POINTONSURFACE, 12-37

SDO_UNION, 12-39

SDO_XOR, 12-42

SET_PT_MEASURE, 15-79

SPLIT_GEOM_SEGMENT, 15-82

supported by approximations with geodetic data, 5-15

TRANSFORM_LAYER, 14-5

TRANSLATE_MEASURE, 15-85

VALID_GEOM_SEGMENT, 15-87

VALID_LRS_POINT, 15-89

VALID_MEASURE, 15-91

VALIDATE_GEOMETRY, 12-45

VALIDATE_LAYER, 12-48

VALIDATE_LRS_GEOMETRY, 15-93

VIEWPORT_TRANSFORM, 14-7

WITHIN_DISTANCE, 12-51

generic geocoding interface, 7-1

GEOCODE_SCHEMA_PROPERTY_TYPE, 7-5

GEOCODE_SERVER_PROPERTY_TYPE, 7-4

GEOCODE_TABLE_COLUMN_TYPE, 7-5

GEOCODE_TASK_METADATA, 7-4

geocoder metadata, 7-3

GEOCODER_HTTP package, 7-10

geocoding

generic interface, 7-1

geodetic coordinates, 1-6, 5-2

arcs and circles not supported, 5-4

functions not supported, 5-15

functions supported by approximations, 5-15

support for, 5-3

geodetic datum, 1-6, 5-2

geographic coordinates, 1-6, 5-2

GEOM_SEGMENT_END_MEASURE function, 15-45

GEOM_SEGMENT_END_PT function, 15-37

GEOM_SEGMENT_LENGTH function, 15-39

GEOM_SEGMENT_START_MEASURE function, 15-41

GEOM_SEGMENT_START_PT function, 15-43

geometric segment

clipping, 6-12

concatenating, 6-13

aggregate, 6-15, 13-5

converting (functions for), 15-3

converting (overview), 6-19

creating (functions for), 15-1

defining, 6-10

definition of, 6-2

direction, 6-3

direction with concatenation, 6-14

editing (functions for), 15-1

locating point on, 6-17

offsetting, 6-16

projecting point onto, 6-18

querying (functions for), 15-2

redefining, 6-11

scaling, 6-15

splitting, 6-13

geometry type

constraining data to, 4-6

GET_DIMS method, 10-3

SDO_GTYPE, 2-6

geometry types, 1-3

GET_DIMS method, 10-2

GET_GTYPE method, 10-3

GET_LRS_DIM method, 10-4

GET_MEASURE function, 15-45

GTYPE (SDO_GTYPE), 2-6

constraining data to a geometry type, 4-6

HISTOGRAM_ANALYSIS procedure, 17-19

hybrid indexing, B-1

index

creation, 4-1

creation (cross-schema), 4-7

description of Spatial indexing, 1-11

R-tree (requirements before creating), 4-2

inserting spatial data

PL/SQL, 3-4

INSIDE mask relationship, 12-6

installation procedure for Spatial, A-2

INTEPRETATION (SDO_INTERPRETATION), 2-10

interaction

ANYINTERACT, 12-5

interior polygon rings, 2-7, 2-9, 2-10, 2-15, 2-17

interMedia Locator

See Locator

intersection, 12-25

inverse flattening, 5-12

IS_GEOM_SEGMENT_DEFINED function, 15-47

IS_MEASURE_DECREASING function, 15-49

IS_MEASURE_INCREASING function, 15-51

Java Virtual Machine (JVM)

platform for geocoding, 7-2

layer, 1-5

transforming, 14-5

validating, 12-48

layer_gtype

constraining data to a geometry type, 4-6

length

SDO_LENGTH function, 12-28

line

line string

linear features, 6-6

linear measure, 6-3

Linear Referencing System (LRS)

3D formats of functions, 6-9

conceptual and usage information, 6-1

data model, 6-7

example, 6-20

function reference information, 15-1

GET_LRS_DIM method, 10-4

limiting indexing to X and Y dimensions, 6-8

LRS point, 6-6

segments, 6-2

loading spatial data, 3-1

local coordinate systems, 5-5

local coordinates, 5-2

LOCAL partitioning

spatial index, 4-7

LOCATE_PT function, 15-53

Locator, C-1

LRS

See Linear Referencing System (LRS)

LRS point, 6-6

map projections, 5-12

MBR

SDO_MAX_MBR_ORDINATE function, 12-31

SDO_MBR function, 12-33

SDO_MIN_MBR_ORDINATE function, 12-35

MDSYS schema, 1-1

MDSYS user

created during default installation, A-2

protecting against unauthorized use, A-2

MDSYS.CS_SRS table, 5-6

MDSYS.SDO_ANGLE_UNITS table, 5-10

MDSYS.SDO_CS package, 14-1

MDSYS.SDO_DATUMS table, 5-11

MDSYS.SDO_DIST_UNITS table, 5-10

MDSYS.SDO_ELLIPSOIDS table, 5-12

MDSYS.SDO_PROJECTIONS table, 5-12

measure, 6-3

populating, 6-4

resetting, 15-70

reversing, 15-74

measure range, 6-6

MEASURE_RANGE function, 15-55

MEASURE_TO_PERCENTAGE function, 15-57

metadata for geocoding, 7-3

migration

OGIS, 16-4, 16-5

to current Spatial release, 16-11

to release 7.3.4, 16-6

minimum bounding rectangle

AVERAGE_MBR procedure, 17-5

EXTENT_OF function, 17-17

SDO_MAX_MBR_ORDINATE function, 12-31

SDO_MBR function, 12-33

SDO_MIN_MBR_ORDINATE function, 12-35

MIX_INFO procedure, 17-21

multimatch table, 7-9

multiple matches, 7-9

multipolygon, 2-17

nearest neighbor

SDO_NN operator, 11-6

new features for Oracle9i, xxi

object types

embedding SDO_GEOMETRY objects in, 8-1, 8-6

object-relational model

schema, 2-1

OCI (Oracle Call Interface) examples, 1-26

offset, 6-3

OFFSET_GEOM_SEGMENT function, 15-59

offsetting a geometric segment, 6-16

OGIS_METADATA_FROM procedure, 16-4

OGIS_METADATA_TO procedure, 16-5

operators

cross-schema invocation, 4-18

SDO_FILTER, 11-2

SDO_NN, 11-6

SDO_NN_DISTANCE, 11-11

SDO_RELATE, 11-13

SDO_WITHIN_DISTANCE, 11-18

optimized rectangle, 2-12

Oracle Call Interface (OCI) examples, 1-26

Oracle Technology Network (OTN), xxiii

oracle.spatial.geocoder.Metadata, 7-9

OVERLAPBDYDISJOINT mask relationship, 12-6

OVERLAPBDYINTERSECT mask relationship, 12-6

partitioned spatial index, 4-7

PERCENTAGE_TO_MEASURE function, 15-63

performance and tuning information, 1-25

PL/SQL and SQL examples, 1-26

point

data, 1-5

locating on geometric segment, 6-17

LRS, 6-6

on surface of polygon, 12-37

polygon

exterior and interior rings, 2-7, 2-9, 2-10, 2-15, 2-17

point on surface, 12-37

self-crossing not supported, 1-4

polygon collection, 2-17

polygon data, 1-5

populating

measure, 6-4

primitive types, 1-3

problems in current release, 5-14

geodetic data, 5-4

procedures

See functions and procedures

PROJECT_PT function, 15-65

projected coordinates, 1-7, 5-2

projection, 6-6

point onto geometric segment, 6-18

PROJECT_PT function, 15-65

projections, 5-12

quadtree indexes, 1-14

quality

degradation of R-tree index, 17-23

R-tree, 1-13

QUALITY_DEGRADATION function, 17-23

query, 1-9

QUERY REWRITE

privilege and session requirements, 8-4

query window, 4-11

querying geometric segments

functions for, 15-2

range

measure, 6-6

rectangle

minimum bounding, 17-17

type, 2-12

REDEFINE_GEOM_SEGMENT procedure, 15-67

redefining a gemoetric segment, 6-11

rejected records, 7-9

RELATE function, 12-4

release 9i

changes to this guide for Oracle9i, xxi

migrating to Oracle9i, 16-11

release number (Spatial)

retrieving, 1-26

RESET_MEASURE procedure, 15-70

restrictions in current release, 5-14

geodetic data, 5-4

REVERSE_GEOMETRY function, 15-72

REVERSE_MEASURE function, 15-74

rollback segment

R-tree index creation, 4-2

R-tree indexes, 1-12

analyzing quality, 17-3

before creating, 4-2

quality degradation, 17-23

quality score, 17-25

sequence object, 2-31

R-tree quality, 1-13

RTREE_QUALITY function, 17-25

SCALE_GEOM_SEGMENT function, 15-76

scaling a geometric segment, 6-15

schema

creating index on table in another schema, 4-7

invoking operators on table in another schema, 4-18

object-relational model, 2-1

SDO_AGGR_CENTROID aggregate function, 13-2

SDO_AGGR_CONVEXHULL aggregate function, 13-4

SDO_AGGR_LRS_CONCAT aggregate function, 13-5

SDO_AGGR_MBR aggregate function, 13-7

SDO_AGGR_UNION aggregate function, 13-8

SDO_ANGLE_UNITS table, 5-10

SDO_ARC_DENSIFY function, 12-7

SDO_AREA function, 12-10

SDO_AREA_UNITS table, 2-32

SDO_BUFFER function, 12-12

SDO_CENTROID function, 12-16

SDO_CODE, 2-30

SDO_CONVEXHULL function, 12-18

SDO_CS package, 14-1

SDO_DATUMS table, 5-11

SDO_DIFFERENCE function, 12-20

SDO_DIST_UNITS table, 2-31, 5-10

SDO_DISTANCE function, 12-23

SDO_ELEM_INFO, 2-9

SDO_ELLIPSOIDS table, 5-12

SDO_ETYPE, 2-9

SDO_FILTER operator, 11-2

SDO_GEOMETRY object type, 2-6

embedding in user-defined type, 8-1, 8-6

in function-based indexes, 8-3

methods, 10-1, 13-1

SDO_GROUPCODE, 2-30

SDO_GTYPE, 2-6

constraining data to a geometry type, 4-6

GET_DIMS method, 10-2

GET_GTYPE method, 10-3

GET_LRS_DIM method, 10-4

SDO_INDEX_TABLE, 2-30

SDO_INDX_DIMS keyword, 6-8

SDO_INTERPRETATION, 2-10

SDO_INTERSECTION function, 12-25

SDO_LENGTH function, 12-28

SDO_LEVEL, 1-15

SDO_MAX_MBR_ORDINATE function, 12-31

SDO_MBR function, 12-33

SDO_MIN_MBR_ORDINATE function, 12-35

SDO_NN operator, 11-6

optimizer hint, 11-9

SDO_NN_DISTANCE ancillary operator, 11-11

SDO_NUMTILES, 1-15

SDO_ORDINATES, 2-13

SDO_POINT, 2-8

SDO_POINTONSURFACE function, 12-37

SDO_POLY_xxx functions (deprecated and removed), 12-3

SDO_PROJECTIONS table, 5-12

SDO_RELATE operator, 11-13

SDO_ROWID, 2-30

SDO_RTREE_SEQ_NAME, 2-31

SDO_SRID, 2-8

SDO_STARTING_OFFSET, 2-9

SDO_STATUS, 2-30

SDO_UNION function, 12-39

SDO_UNIT column

in SDO_AREA_UNITS table, 2-32

in SDO_DIST_UNITS table, 2-32, 5-10

SDO_VERSION function, 1-26

SDO_WITHIN_DISTANCE operator, 11-18

SDO_XOR function, 12-42

SDOAGGRTYPE object type, 1-24

segments

geometric, 6-2

self-crossing line strings and polygons, 1-4

semi-major axis, 5-12

sequence object for R-tree index, 2-31

SET_PT_MEASURE procedure, 15-79

shape point, 6-2

simple element, 2-9

SORT_AREA_SIZE parameter

R-tree index creation, 4-2

spatial aggregate functions

See aggregate functions

spatial data structures

object-relational model, 2-1

spatial index

See index

Spatial Index Advisor

using to determine best tiling level, 4-6

spatial indexing

fixed, 1-16

spatial join, 4-18

spatial query, 4-11

spatial reference systems

conceptual and usage information, 5-1

example, 5-15

function reference information, 14-1

sphere

authalic, 5-2

spheroids (ellipsoids), 5-12

SPLIT_GEOM_SEGMENT procedure, 15-82

splitting a geometric segment, 6-13

SQL and PL/SQL examples, 1-26

SQL*Loader, 3-1

SRID

0 (zero) special case with SDO_CS.VIEWPORT_TRANSFORM function, 14-8

in USER_SDO_GEOM_METADATA, 2-26

SDO_SRID in SDO_GEOMETRY, 2-8

TABLE_NAME (in USER_SDO_GEOM_METADATA), 2-25

tessellation, 1-15

three-dimensional (3D)

formats of LRS functions, 6-9

tile, 1-15, 4-10

tiling level

estimating, 17-10

TO_734 procedure, 16-6

TO_81x procedure, 16-8

TO_CURRENT procedure, 16-11

tolerance, 1-7

TOUCH mask relationship, 12-6

transactional insertion of spatial data, 3-4

TRANSFORM, 14-2

TRANSFORM_LAYER, 14-5

table for transformed layer, 14-6

transformation, 5-2

TRANSLATE_MEASURE procedure, 15-85

tuning and performance information, 1-25

two-tier query, 1-9, 4-10

type zero (0) element, 2-21

union, 12-39

unit of measurement

MDSYS tables, 2-31

UNIT_NAME column

in SDO_ANGLE_UNITS table, 5-10

in SDO_AREA_UNITS table, 2-32

in SDO_DIST_UNITS table, 2-32

UNIT_NAME column in SDO_DIST_UNITS table, 5-11

USER_SDO_GEOM_METADATA view, 2-24

USER_SDO_INDEX_INFO view, 2-26

USER_SDO_INDEX_METADATA view, 2-27

user-defined coordinate system, 5-13

user-defined data types

embedding SDO_GEOMETRY objects in, 8-1, 8-6

VALID_GEOM_SEGMENT function, 15-87

VALID_LRS_POINT function, 15-89

VALID_MEASURE function, 15-91

VALIDATE_GEOMETRY function, 12-45

VALIDATE_LAYER procedure, 12-48

VALIDATE_LRS_GEOMETRY function, 15-93

version number (Spatial)

retrieving, 1-26

VIEWPORT_TRANSFORM, 14-7

well-known text (WKTEXT), 5-7

WITHIN_DISTANCE function, 12-51

WKTEXT column of MDSYS.CS_SRS table, 5-7

XOR

SDO_XOR function, 12-42

zero

SRID value used with SDO_CS.VIEWPORT_TRANSFORM function, 14-8

type 0 element, 2-21

Index

Symbols

Numerics

A

B

C

D

E

F

G

H

I

J

L

M

N

O

P

Q

R

S

T

U

V

W

X

Z