Oracle Spatial User's Guide and Reference -- Index

8.1.7

administrative procedures, 15-1

ALL_SDO_GEOM_METADATA view, 2-18

ALL_SDO_INDEX_METADATA view, 2-20

ALTER INDEX, 5-2

REBUILD, 5-5

RENAME TO, 5-8

ANYINTERACT, 7-5, 17-3

arcs, A-14

area, 7-7

authalic sphere, D-3

average minimum bounding rectangle, 11-2

AVERAGE_MBR, 11-2, 16-2

batch geocoding, C-4

bounding rectangle

minimum, 11-14

buffer area, 7-9

BUILD_WINDOW, 18-3

BUILD_WINDOW_FIXED, 18-5

bulk loading, 3-1, 13-2

C language examples (using OCI), 1-26

Cartesian coordinates, D-2

center of gravity (centroid), 7-11

centroid, 7-11

circle, 2-11, A-14

CLEAN_WINDOW, 18-7

CLEANUP_GID, 18-8

clip, E-11

CLIP_GEOM_SEGMENT, 9-5

COLUMN_NAME (in USER_SDO_GEOM_METADATA), 2-19

compound element, 2-9

CONCATENATE_GEOM_SEGMENT, 9-59

concatenating geometric segments, E-12

CONNECTED_GEOM_SEGMENTS, 9-10

consistency check, 7-33, 17-5

CONTAINS, 7-5, 17-3

control file, 13-2

CONVERT_TO_LRS_DIM_ARRAY, 9-12

CONVERT_TO_LRS_GEOM, 9-14

CONVERT_TO_LRS_LAYER, 9-16

CONVERT_TO_STD_DIM_ARRAY, 9-18

CONVERT_TO_STD_GEOM, 9-20

CONVERT_TO_STD_LAYER, 9-22

converting geometric segments

functions for, 9-3

overview, E-17

convex hull, 7-13

coordinate systems

conceptual and usage information, D-1

coordinates

COVEREDBY, 7-5, 17-3

COVERS, 7-5, 17-4

cr_spatial_index.sql, A-16

CREATE INDEX, 5-9

CREATE_WINDOW_LAYER, 18-9

creating geometric segments

functions for, 9-1

creating layer tables, A-17

crlayer.sql, A-17

CS_SRS table, D-3

customized geometry types, A-14

data model, 1-6, A-1

LRS, E-7

datum

geodetic, D-2

transformation, D-3

DBA_SDO_GEOM_METADATA view, 2-18

DBA_SDO_INDEX_METADATA view, 2-20

DEFINE_GEOM_SEGMENT, 9-24

difference, 7-15

dimension (in SDO_GTYPE), 2-7

DIMINFO (in USER_SDO_GEOM_METADATA), 2-19

direction of geometric segment, E-3

concatenation result, E-13

disjoint, 7-5, 17-4

displaying geometries, A-18, A-20

distance, 7-39

DROP INDEX, 5-14

dynamic query window, 4-3, 14-4

DYNAMIC_SEGMENT, 9-27

editing geometric segments

functions for, 9-1

ELEM_INFO (SDO_ELEM_INFO), 2-8

element, 1-6

ellipsoids

list of supported, D-6

enabling third-party geocoders, C-11

EQUAL, 7-5, 17-4

error messages, xxiv

coordinate systems, D-14

linear referencing system, E-31

ESTIMATE_INDEX_PERFORMANCE, 11-4, 16-3

ESTIMATE_TILING_LEVEL, 11-7, 16-5

ESTIMATE_TILING_TIME, 11-9, 16-8

ESTIMATE_TOTAL_NUMTILES, 11-11

ETYPE (SDO_ETYPE), 2-9

examples

C, 1-26

coordinate systems, D-8

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

directory, 1-25

Linear Referencing System (LRS), E-19

OCI (Oracle Call Interface), 1-26

PL/SQL, 1-26

SQL, 1-26

extent, 16-9

EXTENT_OF, 11-14, 16-9

exterior polygon rings, 2-7, 2-9, 2-14, 2-15

features

linear, E-6

filter, 14-6

FIND_MEASURE, 9-29

fixed indexing, 1-13

fixed-size tiles, 3-12, 13-7, 15-5, 15-14

FROM_815_TO_81x, 10-2

functions

CLIP_GEOM_SEGMENT, 9-5

CONCATENATE_GEOM_SEGMENT, 9-59

CONNECTED_GEOM_SEGMENTS, 9-10

CONVERT_TO_LRS_DIM_ARRAY, 9-12

CONVERT_TO_LRS_GEOM, 9-14

CONVERT_TO_LRS_LAYER, 9-16

CONVERT_TO_STD_DIM_ARRAY, 9-18

CONVERT_TO_STD_GEOM, 9-20

CONVERT_TO_STD_LAYER, 9-22

DEFINE_GEOM_SEGMENT procedure, 9-24

DYNAMIC_SEGMENT, 9-27

FIND_MEASURE, 9-29

GEOM_SEGMENT_END_MEASURE, 9-41

GEOM_SEGMENT_END_PT, 9-33

GEOM_SEGMENT_LENGTH, 9-35

GEOM_SEGMENT_START_MEASURE, 9-37

GEOM_SEGMENT_START_PT, 9-39

GET_MEASURE, 9-41

IS_GEOM_SEGMENT_DEFINED, 9-69

LOCATE_PT, 9-45

MEASURE_RANGE, 9-47

MEASURE_TO_PERCENTAGE, 9-49

PERCENTAGE_TO_MEASURE, 9-51

PROJECT_PT, 9-53

REDEFINE_GEOM_SEGMENT, 9-55

REVERSE_MEASURE, 9-57

SCALE_GEOM_SEGMENT, 9-59

SPLIT_GEOM_SEGMENT procedure, 9-62

TRANSLATE_MEASURE, 9-65

VALID_GEOM_SEGMENT, 9-67

VALID_LRS_PT, 9-69

VALID_MEASURE, 9-71

generic geocoding interface, C-1

GEOCODE_SCHEMA_PROPERTY_TYPE, C-5

GEOCODE_SERVER_PROPERTY_TYPE, C-4

GEOCODE_TABLE_COLUMN_TYPE, C-5

GEOCODE_TASK_METADATA, C-4

geocoder metadata, C-3

GEOCODER_HTTP package, C-10

geocoding

generic interface, C-1

geocoding support

interMedia Locator, A-17

geodetic coordinates, D-2

geodetic datum, D-2

geographic coordinates, D-2

GeoImage feature, xxiv

GEOM_SEGMENT_END_MEASURE, 9-41

GEOM_SEGMENT_END_PT, 9-33

GEOM_SEGMENT_LENGTH, 9-35

GEOM_SEGMENT_START_MEASURE, 9-37

GEOM_SEGMENT_START_PT, 9-39

geometric primitive, 1-4

geometric segment

clipping, E-11

concatenating, E-12

converting (functions for), 9-3

converting (overview), E-17

creating (functions for), 9-1

direction, E-3

direction with concatenation, E-13

editing (functions for), 9-1

locating point on, E-15

projecting point onto, E-17

querying (functions for), 9-2

scaling, E-14

splitting, E-12

geometric segments, E-2

geometry types, 1-4

custom, A-14

object-relational, 2-6

relational, 12-3

GET_MEASURE, 9-41

GIS, 1-3

GTYPE (SDO_GTYPE), 2-6

HISTOGRAM_ANALYSIS, 11-16, 16-10

hybrid indexing, 1-18

index

creation, 3-11

creation (cross-schema), 3-16

creation in parallel, A-14

description of Spatial indexing, 1-9

performance, 11-4, 16-3

quadtree, 1-12

R-tree, 1-10

R-tree (requirements before creating), 1-11

inserting spatial data, 13-4

INSIDE, 7-6, 17-4

INTEPRETATION (SDO_INTERPRETATION), 2-9

interaction, 7-5, 17-3

interior polygon rings, 2-7, 2-9, 2-14, 2-15

interMedia Locator, A-17

intersection, 7-20

IS_GEOM_SEGMENT_DEFINED, 9-69

Java Virtual Machine, C-2

JVM (Java Virtual Machine), C-2

layer, 1-7, A-17

transforming, 8-5

validating, 7-36

length (SDO_LENGTH), 7-23

line, 2-12

length, 7-23

line data, 1-6

linear features, E-6

linear measure, E-3

Linear Referencing System (LRS)

conceptual and usage information, E-1

data model, E-7

error messages, E-31

example, E-19

function reference information, 9-1

limiting indexing to X and Y dimensions, E-8

LRS point, E-6

segments, E-2

loading process, 3-1, 13-2

in parallel, A-14

LOCATE_PT, 9-45

location, 1-3

Locator (interMedia), A-17

long transactions (Workspace Management), xxiv

LRS

See Linear Referencing System (LRS)

LRS point, E-6

map projections

list of supported, D-5

MDSYS schema, 1-1

MDSYS.CS_SRS table, D-3

measure, E-3

measure populating, E-4

measure range, E-6

MEASURE_RANGE, 9-47

MEASURE_TO_PERCENTAGE, 9-49

metadata for geocoding, C-3

migration

OGIS, 10-8, 10-9

to current Spatial release, 10-5

to current Spatial release from 8.1.5, 10-2

to release 7.3.4, 10-3

minimum bounding rectangle, 11-2, 11-14, 16-2, 16-9

average, 11-2

MIX_INFO, 11-18, 16-12

multimatch table, C-9

multiple matches, C-9

multipolygon, 2-15

nearest neighbor (SDO_NN), 6-6

object-relational model

schema, 2-1

OCI (Oracle Call Interface) examples, 1-26

offset, E-3

OGIS_METADATA_FROM, 10-8

OGIS_METADATA_TO, 10-9

operators

cross-schema invocation, 4-9

SDO_FILTER, 6-2

SDO_NN, 6-6

SDO_RELATE, 6-8

SDO_WITHIN_DISTANCE, 6-13

Oracle Call Interface (OCI) examples, 1-26

Oracle Technology Network (OTN), xxiv

oracle.spatial.geocoder.Metadata, C-9

OVERLAPBDYDISJOINT, 7-6, 17-4

OVERLAPBDYINTERSECT, 7-6, 17-4

parallel load, A-14

partitioned tables, 1-25, A-14

PERCENTAGE_TO_MEASURE, 9-51

plotting tiles, A-5

PL/SQL and SQL examples, 1-26

point

locating on geometric segment, E-15

LRS, E-6

shape, E-2

point data, 1-6, 15-8, A-9

point on surface of polygon, 7-25

polygon

area of, 7-7

centroid, 7-11

exterior and interior rings, 2-7, 2-9, 2-14, 2-15

point on surface, 7-25

polygon collection, 2-15

polygon data, 1-6

POPULATE_INDEX, 15-3

POPULATE_INDEX_FIXED, 15-5

POPULATE_INDEX_FIXED_POINTS, 15-8

populating

measure, E-4

primary filter, 14-6

primitive, 1-4

problems in current release, D-7

procedures

DEFINE_GEOM_SEGMENT, 9-24

SPLIT_GEOM_SEGMENT, 9-62

PROJECT_PT, 9-53

projected coordinates, D-2

projection, E-6

point onto geometric segment, E-17

PROJECT_PT function, 9-53

quadtree indexes, 1-12

query, 1-8

query window, 4-3, 14-4

querying geometric segments

functions for, 9-2

range

measure, E-6

rectangle, 2-11

minimum bounding, 11-14

REDEFINE_GEOM_SEGMENT, 9-55

rejected records, C-9

RELATE, 7-4, 17-2

relational model

schema, 12-1

release 8.1.7

changes to this guide, xxiii

migrating to release 8.1.7, 10-5

migrating to release 8.1.7 from release 8.1.5, 10-2

restrictions in current release, D-7

REVERSE_MEASURE, 9-57

rollback segment

R-tree index creation, 1-11

R-tree indexes, 1-10

before creating, 1-11

sequence object, 2-23

sample program, A-18, A-20

SCALE_GEOM_SEGMENT, 9-59

scaling a geometric segment, E-14

schema, 12-1

creating index on table in another schema, 3-16

invoking operators on table in another schema, 4-9

object-relational model, 2-1

relational model, 12-1

SDO_AREA, 7-7

SDO_BUFFER, 7-9

SDO_CENTROID, 7-11

SDO_CODE, 2-22

SDO_CODE_SIZE, 15-10

SDO_CONVEXHULL, 7-13

SDO_DIFFERENCE, 7-15

SDO_DISTANCE, 7-18

SDO_ELEM_INFO, 2-8

SDO_ETYPE, 2-9

SDO_FILTER operator, 6-2

SDO_GEOMETRY object type, 2-6

SDO_GROUPCODE, 2-22

SDO_GTYPE, 2-6

SDO_INDEX_TABLE, 2-22

SDO_INDX_DIMS, E-8

SDO_INTERPRETATION, 2-9

SDO_INTERSECTION, 7-20

SDO_LENGTH, 7-23

SDO_LEVEL, 1-12

SDO_NN

optimizer hint, 6-7

SDO_NN operator, 6-6

SDO_NUMTILES, 1-12

SDO_ORDINATES, 2-12

SDO_POINT, 2-8

SDO_POINTONSURFACE, 7-25

SDO_POLY_xxx functions (deprecated and removed), 7-2

SDO_RELATE operator, 6-8

SDO_ROWID, 2-22

SDO_RTREE_SEQ_NAME, 2-23

SDO_SRID, 2-8

SDO_STARTING_OFFSET, 2-8

SDO_STATUS, 2-22

SDO_UNION, 7-27

SDO_VERSION, 15-11

SDO_WITHIN_DISTANCE operator, 6-13

SDO_XOR, 7-30

secondary filter, 14-7

segments

geometric, E-2

sequence object for R-tree index, 2-23

shape point, E-2

simple element, 2-9

SORT_AREA_SIZE parameter

R-tree index creation, 1-11

spatial data structures

object-relational model, 2-1

relational model, 12-1

spatial database

sizing, A-4

spatial index

See index

Spatial Index Advisor

using to determine best tiling level, 3-14

spatial indexing

fixed, 1-13

hybrid, 1-18

spatial join, 4-9, 14-8, A-11

spatial query, 4-3, 14-4

spatial reference systems

conceptual and usage information, D-1

example, D-8

sphere

authalic, D-3

SPLIT_GEOM_SEGMENT, 9-62

splitting a geometric segment, E-12

SQL and PL/SQL examples, 1-26

SQL script, A-16

SQL*Loader, 3-1, 13-2

SRID

in USER_SDO_GEOM_METADATA, 2-20

SDO_SRID in SDO_GEOMETRY, 2-8

table partitioning, 1-25

TABLE_NAME (in USER_SDO_GEOM_METADATA), 2-19

tessellation, 1-13, 13-6

tile, 1-12, 4-1, 14-1

tiling, 11-7, 15-14, 16-5, A-2

TO_734, 10-3

TO_81x, 10-5

tolerance, 1-7

TOUCH, 7-6, 17-4

transactional insert, 3-3, 13-4

TRANSFORM (function), 8-2

TRANSFORM_LAYER (procedure), 8-5

Transform_Layer (procedure)

table for transformed layer, 8-6

transformation, D-3

TRANSLATE_MEASURE, 9-65

two-tier query, 1-8, 4-1, 14-1

union, 7-27

UPDATE_INDEX, 15-12

UPDATE_INDEX_FIXED, 15-14

USER_SDO_GEOM_METADATA view, 2-18

USER_SDO_INDEX_METADATA view, 2-20

VALID_GEOM_SEGMENT, 9-67

VALID_LRS_PT, 9-69

VALID_MEASURE, 9-71

VALIDATE_GEOMETRY, 7-33, 17-5

VALIDATE_LAYER, 7-36

VERIFY_LAYER, 15-16

visualizing geometries, A-18, A-20

visualizing tiles, A-5, A-20

well-known text (WKTEXT), D-4

WITHIN_DISTANCE, 7-39

WKTEXT, D-4

Workspace Management, xxiv

XOR, 7-30

Index

Numerics

A

B

C

D

E

F

G

H

I

J

L

M

N

O

P

Q

R

S

T

U

V

W

X