Index

A C D E F G H I J L M N O P R S T U V

A

ADD_EDGE function, 4

ADD_ISOLATED_NODE function, 4

ADD_LOOP function, 4

ADD_NODE function, 4

ADD_TOPO_GEOMETRY_LAYER procedure, 3

ALL_SDO_NETWORK_METADATA view, 6.7.1

ALL_SDO_TOPO_INFO view, 1.7.1

ALL_SDO_TOPO_METADATA view, 1.7.2

API

network data model, 6.8

topology data model, 1.8

application programming interface (API)

network data model, 6.8

topology data model, 1.8

C

cache

TopoMap object associated with, 2.1.1

See also TopoMap objects

census (U.S.) data

demo for processing, 1

CHANGE_EDGE_COORDS procedure, 4

child layer, 1.4

child node, 6.5

CLEAR_TOPO_MAP procedure, 4

COMMIT_TOPO_MAP procedure, 4

constraints

network, 6.3

containing face

getting for point, 4

COPY_NETWORK procedure, 7

cost, 6.3

CREATE_EDGE_INDEX procedure, 4

CREATE_FACE_INDEX procedure, 4

CREATE_LINK_TABLE procedure, 7

CREATE_LOGICAL_NETWORK procedure, 7

CREATE_LRS_NETWORK procedure, 7

CREATE_LRS_TABLE procedure, 7

CREATE_NODE_TABLE procedure, 7

CREATE_PATH_LINK_TABLE procedure, 7

CREATE_PATH_TABLE procedure, 7

CREATE_SDO_NETWORK procedure, 7

CREATE_TOPO_MAP procedure, 4

CREATE_TOPO_NETWORK procedure, 7

CREATE_TOPOLOGY procedure, 3

D

degree

of a node, 6.3

DELETE_TOPO_GEOMETRY_LAYER procedure, 3

demo files for topology data model, 1

directed links, 6.3

directed networks, 6.3

direction of edge, 1.2

DROP_NETWORK procedure, 7

DROP_TOPO_MAP procedure, 4

DROP_TOPOLOGY procedure, 3

E

edge index

creating for TopoMap object, 4

edge information table, 1.5.1

edges

adding, 2.3.1, 4

adding loop, 4

changing coordinates, 2.3.4, 4

definition, 1.2

direction, 1.2

getting coordinates of shape points, 4

getting ID numbers of added edges, 4

getting ID numbers of changed edges, 4

getting ID numbers of deleted edges, 4

getting nearest edge for point, 4

getting nodes on, 4

island, 1.2

moving, 2.3.2, 4

removing, 2.3.3, 4

storing information in edge information table, 1.5.1

updating, 2.3.4

error handling

topology editing, 2.1.6

examples

network data model (PL/SQL), 6.9

topology data model (PL/SQL), 1.11

exception handling

topology editing, 2.1.6

F

F0 (face zero), 1.2

face index

creating for TopoMap object, 4

face information table, 1.5.3

faces

definition, 1.2

getting boundary of, 3

getting containing face for point, 4

getting ID numbers of added faces, 4

getting ID numbers of changed faces, 4

getting ID numbers of deleted faces, 4

redefining, 2.3.3

storing information in face information table, 1.5.3

feature

in network application, 6.3

feature table, 1.3

function-based indexes

not supported on SDO_TOPO_GEOMETRY columns, 1.10

G

GET_CHILD_LINKS function, 7

GET_CHILD_NODES function, 7

GET_CONTAINING_FACE function, 4

GET_EDGE_ADDITIONS function, 4

GET_EDGE_CHANGES function, 4

GET_EDGE_COORDS function, 4

GET_EDGE_DELETIONS function, 4

GET_EDGE_NODES function, 4

GET_FACE_ADDITIONS function, 4

GET_FACE_BOUNDARY function, 3

GET_FACE_CHANGES function, 4

GET_FACE_DELETIONS function, 4

GET_GEOMETRY member function, 1.6.3

GET_GEOMETRY_TYPE function, 7

GET_IN_LINKS function, 7

GET_LINK_COST_COLUMN function, 7

GET_LINK_DIRECTION function, 7

GET_LINK_GEOM_COLUMN function, 7

GET_LINK_GEOMETRY function, 7

GET_LINK_TABLE_NAME function, 7

GET_LRS_GEOM_COLUMN function, 7

GET_LRS_LINK_GEOMETRY function, 7

GET_LRS_NODE_GEOMETRY function, 7

GET_LRS_TABLE_NAME function, 7

GET_NEAREST_EDGE function, 4

GET_NEAREST_NODE function, 4

GET_NETWORK_TYPE function, 7

GET_NO_OF_HIERARCHY_LEVELS function, 7

GET_NO_OF_LINKS function, 7

GET_NO_OF_NODES function, 7

GET_NODE_ADDITIONS function, 4

GET_NODE_CHANGES function, 4

GET_NODE_COORD function, 4

GET_NODE_DEGREE function, 7

GET_NODE_DELETIONS function, 4

GET_NODE_GEOM_COLUMN function, 7

GET_NODE_GEOMETRY function, 7

GET_NODE_IN_DEGREE function, 7

GET_NODE_OUT_DEGREE function, 7

GET_NODE_STAR function, 4

GET_NODE_TABLE_NAME function, 7

GET_OUT_LINKS function, 7

GET_PATH_GEOM_COLUMN function, 7

GET_PATH_TABLE_NAME function, 7

GET_TOPO_NAME function, 4

GET_TOPO_OBJECTS function, 3

H

hierarchy

network, 6.5

topology geometry layer, 1.4

history information table, 1.5.5

I

inbound links, 6.3

getting link ID numbers, 7

getting number of for node, 7

in-degree, 6.3

INITIALIZE_METADATA procedure, 3

IS_HIERARCHICAL function, 7

IS_LOGICAL function, 7

IS_SPATIAL function, 7

island edge, 1.2

island node, 1.2

isolated nodes

adding, 4

J

Java client interface for network data model (sdonm), 6.8.2

Java client interface for topology data model (sdotopo), 1.8.1

L

layer

topology geometry, 1.3, 3

link direction

getting, 7

link geometry

getting, 7

link table

definition, 6.6.2

links

definition, 6.3

determining if directed, 7

getting geometry for, 7

relationship to paths, 6.3

See also inbound links, outbound links

LIST_TOPO_MAPS function, 4

LOAD_TOPO_MAP function, 4

logical network, 6.3

loops

adding, 4

LRS network, 6.3

LRS_GEOMETRY_NETWORK function, 7

M

metadata

initializing for a topology, 3

minimum cost path, 6.3

minimum cost spanning tree, 6.3

MOVE_EDGE procedure, 4

MOVE_ISOLATED_NODE procedure, 4

MOVE_NODE procedure, 4

N

nearest edge

getting for point, 4

nearest node

getting for point, 4

network constraints, 6.3

network data model

application programming interface (API), 6.8

concepts, 6.3

overview, 6

PL/SQL examples, 6.9

steps for using, 6.2

subprogram reference information, 7

tables for, 6.6

NETWORK_EXISTS function, 7

networks

definition, 6.3

hierarchical, 6.5

logical, 6.3

spatial, 6.3

node geometry

getting, 7

node information table, 1.5.2

node star

getting for node, 4

node table

definition, 6.6.1

nodes

adding, 2.2.1, 4, 4

definition, 1.2, 6.3

degree, 6.3

getting coordinates of, 4

getting geometry, 7

getting ID numbers of added nodes, 4

getting ID numbers of changed nodes, 4

getting ID numbers of deleted nodes, 4

getting nearest node for point, 4

getting node star, 4

getting number of, 7

island, 1.2

moving, 2.2.2, 4

moving isolated nodes, 4

reachable, 6.3

reaching, 6.3

removing, 2.2.3, 4

storing information in node information table, 1.5.2

O

operators

SDO_ANYINTERACT, 5

topology data model, 5

outbound links, 6.3

getting link ID numbers, 7

getting number of for node, 7

out-degree, 6.3

P

parent layer, 1.4

parent node, 6.5

path table

definition, 6.6.3

path-link table

definition, 6.6.4

paths

definition, 6.3

minimum cost, 6.3

PL/SQL examples

network data model, 6.9

R

reachable nodes, 6.3

reaching nodes, 6.3

read-only TopoMap objects, 2.1.1

relationship information table, 1.5.4

REMOVE_EDGE procedure, 4

REMOVE_NODE procedure, 4

ROLLBACK_TOPO_MAP procedure, 4

S

SDO network, 6.3

SDO_ANYINTERACT operator, 5

SDO_EDGE_ARRAY type, 1.6.5

SDO_GEOMETRY_NETWORK function, 7

SDO_LIST_TYPE type, 1.6.4

SDO_NET package

COPY_NETWORK, 7

CREATE_LINK_TABLE, 7

CREATE_LOGICAL_NETWORK, 7

CREATE_LRS_NETWORK, 7

CREATE_LRS_TABLE, 7

CREATE_NODE_TABLE, 7

CREATE_PATH_LINK_TABLE, 7

CREATE_PATH_TABLE, 7

CREATE_SDO_NETWORK, 7

CREATE_TOPO_NETWORK, 7

DROP_NETWORK, 7

GET_CHILD_LINKS, 7

GET_CHILD_NODES, 7

GET_GEOMETRY_TYPE, 7

GET_IN_LINKS, 7

GET_LINK_COST_COLUMN, 7

GET_LINK_DIRECTION, 7

GET_LINK_GEOM_COLUMN, 7

GET_LINK_GEOMETRY, 7

GET_LINK_TABLE_NAME, 7

GET_LRS_GEOM_COLUMN, 7

GET_LRS_LINK_GEOMETRY, 7

GET_LRS_NODE_GEOMETRY, 7

GET_LRS_TABLE_NAME, 7

GET_NETWORK_TYPE, 7

GET_NO_OF_HIERARCHY_LEVELS, 7

GET_NO_OF_LINKS, 7

GET_NO_OF_NODES, 7

GET_NODE_DEGREE, 7

GET_NODE_GEOM_COLUMN, 7

GET_NODE_GEOMETRY, 7

GET_NODE_IN_DEGREE, 7

GET_NODE_OUT_DEGREE, 7

GET_NODE_TABLE_NAME, 7

GET_OUT_LINKS, 7

GET_PATH_GEOM_COLUMN, 7

GET_PATH_TABLE_NAME, 7

IS_HIERARCHICAL, 7

IS_LOGICAL, 7

IS_SPATIAL, 7

LRS_GEOMETRY_NETWORK, 7

NETWORK_EXISTS, 7

reference information, 7

SDO_GEOMETRY_NETWORK, 7

TOPO_GEOMETRY_NETWORK, 7

VALIDATE_LINK_SCHEMA, 7

VALIDATE_LRS_SCHEMA, 7

VALIDATE_NETWORK, 7

VALIDATE_NODE_SCHEMA, 7

VALIDATE_PATH_SCHEMA, 7

SDO_NUMBER_ARRAY type, 1.6.5

SDO_TGL_OBJECT type, 1.6.2.2

SDO_TGL_OBJECT_ARRAY type, 1.6.2.2

SDO_TOPO package

ADD_TOPO_GEOMETRY_LAYER, 3

CREATE_TOPOLOGY, 3

DELETE_TOPO_GEOMETRY_LAYER, 3

DROP_TOPOLOGY, 3

GET_FACE_BOUNDARY, 3

GET_TOPO_OBJECTS, 3

INITIALIZE_METADATA, 3

reference information, 3

SDO_TOPO_GEOMETRY constructors, 1.6.2

SDO_TOPO_GEOMETRY member function (GET_GEOMETRY), 1.6.3

SDO_TOPO_GEOMETRY type, 1.6.1

SDO_TOPO_MAP package

ADD_EDGE, 4

ADD_ISOLATED_NODE, 4

ADD_LOOP, 4

ADD_NODE, 4

CHANGE_EDGE_COORDS, 4

CLEAR_TOPO_MAP, 4

COMMIT_TOPO_MAP, 4

CREATE_EDGE_INDEX, 4

CREATE_FACE_INDEX, 4

CREATE_TOPO_MAP, 4

DROP_TOPO_MAP, 4

GET_CONTAINING_FACE, 4

GET_EDGE_ADDITIONS, 4

GET_EDGE_CHANGES, 4

GET_EDGE_COORDS, 4

GET_EDGE_DELETIONS, 4

GET_EDGE_NODES, 4

GET_FACE_ADDITIONS, 4

GET_FACE_CHANGES, 4

GET_FACE_DELETIONS, 4

GET_NEAREST_EDGE, 4

GET_NEAREST_NODE, 4

GET_NODE_ADDITIONS, 4

GET_NODE_CHANGES, 4

GET_NODE_COORD, 4

GET_NODE_DELETIONS, 4

GET_NODE_STAR, 4

GET_TOPO_NAME, 4

LIST_TOPO_MAPS, 4

LOAD_TOPO_MAP, 4

MOVE_EDGE, 4

MOVE_ISOLATED_NODE, 4

MOVE_NODE, 4

reference information, 4

REMOVE_EDGE, 4

REMOVE_NODE, 4

ROLLBACK_TOPO_MAP, 4

UPDATE_TOPO_MAP, 4

VALIDATE_TOPO_MAP, 4

VALIDATE_TOPOLOGY, 4

SDO_TOPO_OBJECT type, 1.6.2.1

SDO_TOPO_OBJECT_ARRAY type, 1.6.2.1

sdonm Java client interface, 6.8.2

sdotopo Java client interface, 1.8.1

spanning tree, 6.3

minimum cost, 6.3

spatial network, 6.3

T

TG_ID attribute of SDO_TOPO_GEOMETRY type, 1.6.1

TG_LAYER_ID attribute of SDO_TOPO_GEOMETRY type, 1.6.1

TG_TYPE attribute of SDO_TOPO_GEOMETRY type, 1.6.1

TOPO_GEOMETRY_NETWORK function, 7

topo_map parameter

SDO_TOPO subprograms, 2.1.3

topology

clearing map, 4

committing map, 4

creating, 3

creating edge index, 4

creating face index, 4

creating map, 4

deleting (dropping), 3

deleting (dropping) map, 4

editing, 2

getting name from TopoMap object, 4

hierarchy of geometry layers, 1.4

initializing metadata, 3

loading into TopoMap object, 4

updating, 4

validating, 4

topology data model

application programming interface (API), 1.8

concepts, 1.2

operator reference information, 5

overview, 1

PL/SQL example, 1.11

steps for using, 1.1

subprogram reference information, 3, 4

topology data types, 1.6

topology editor

demo, 1

topology geometry

definition, 1.3

layer, 1.3

topology geometry layer

adding, 3

definition, 1.3

deleting, 3

hierarchical relationships in, 1.4

topology geometry network, 6.3

topology maps

listing, 4

loading, 4

rolling back, 4

validating, 4

See also TopoMap objects

topology operators, 5

SDO_ANYINTERACT, 5

topology parameter

SDO_TOPO subprograms, 2.1.2, 2.1.3

TOPOLOGY_ID attribute of SDO_TOPO_GEOMETRY type, 1.6.1

TopoMap objects

clearing, 4

committing changes to the database, 4

creating, 4

creating edge index, 4

creating face index, 4

deleting (dropping), 4

description, 2.1.1

getting topology name, 4

listing, 4

loading, 4

process for using to edit topologies, 2.1.4, 2.1.5

read-only, 2.1.1

rolling back changes in, 4

updatable, 2.1.1

validating, 4

U

undirected links, 6.3

undirected networks, 6.3

universal face (F0), 1.2

updatable TopoMap objects, 2.1.1

UPDATE_TOPO_MAP procedure, 4

USER_SDO_NETWORK_METADATA view, 6.7.1

USER_SDO_TOPO_INFO view, 1.7.1

USER_SDO_TOPO_METADATA view, 1.7.2

V

VALIDATE_LINK_SCHEMA function, 7

VALIDATE_LRS_SCHEMA function, 7

VALIDATE_NETWORK function, 7

VALIDATE_NODE_SCHEMA function, 7

VALIDATE_PATH_SCHEMA function, 7

VALIDATE_TOPO_MAP function, 4

VALIDATE_TOPOLOGY procedure, 4