Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
Numerics
- 8.1.7
-
changes to this guide for release 8.1.7, xxiii
-
migrating to release 8.1.7, 10-5
-
migrating to release 8.1.7 from release 8.1.5, 10-2
A
- 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
B
- 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
- 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
-
error messages, D-14
-
example, D-8
- coordinates
-
Cartesian, D-2
-
geodetic, D-2
-
geographic, D-2
-
projected, D-2
- 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
D
- 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
E
- 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
F
- 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
G
- 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
H
- HISTOGRAM_ANALYSIS, 11-16, 16-10
- hybrid indexing, 1-18
I
- 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
J
- Java Virtual Machine, C-2
- JVM (Java Virtual Machine), C-2
L
- 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
M
- 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
N
- nearest neighbor (SDO_NN), 6-6
O
- 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
P
- 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
Q
- quadtree indexes, 1-12
- query, 1-8
- query window, 4-3, 14-4
- querying geometric segments
-
functions for, 9-2
R
- 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
S
- 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
T
- 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
U
- 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
V
- 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
W
- well-known text (WKTEXT), D-4
- WITHIN_DISTANCE, 7-39
- WKTEXT, D-4
- Workspace Management, xxiv
X
- XOR, 7-30