Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Documentation Accessibility

Related Documentation

Part I Topology Data Model

1 Topology Data Model Overview

1.1 Main Steps in Using Topology Data

1.2 Topology Data Model Concepts

1.3 Topology Geometries and Layers

1.3.1 Features and Topology Objects

1.4 Topology Geometry Layer Hierarchy

1.5 Topology Data Model Tables

1.5.1 Edge Information Table

1.5.2 Node Information Table

1.5.3 Face Information Table

1.5.4 Relationship Information Table

1.5.5 History Information Table

1.6 Topology Data Types

1.6.1 SDO_TOPO_GEOMETRY Type

1.6.2 SDO_TOPO_GEOMETRY Constructors

1.6.2.1 Constructors for Insert Operations into the Lowest Level

1.6.2.2 Constructors for Insert Operations into a Parent Level

1.6.2.3 Constructors for Update Operations into the Lowest Level

1.6.2.4 Constructors for Update Operations into a Parent Level

1.6.3 GET_GEOMETRY Member Function

1.6.4 SDO_LIST_TYPE Type

1.6.5 SDO_EDGE_ARRAY and SDO_NUMBER_ARRAY Types

1.7 Topology Metadata Views

1.7.1 xxx_SDO_TOPO_INFO Views

1.7.2 xxx_SDO_TOPO_METADATA Views

1.8 Topology Application Programming Interface

1.8.1 Topology Data Model Java Interface

1.9 Exporting and Importing Topology Data

1.10 Function-Based Indexes Not Supported

1.11 Topology Example (PL/SQL)

2 Editing Topologies

2.1 Approaches for Editing Topology Data

2.1.1 TopoMap Objects

2.1.2 Specifying the Editing Approach with the Topology Parameter

2.1.3 Using GET_xxx Topology Functions

2.1.4 Process for Editing Using Cache Explicitly (PL/SQL API)

2.1.5 Process for Editing Using the Java API

2.1.6 Error Handling for Topology Editing

2.1.6.1 Input Parameter Errors

2.1.6.2 All Exceptions

2.2 Performing Operations on Nodes

2.2.1 Adding a Node

2.2.2 Moving a Node

2.2.2.1 Additional Examples of Allowed and Disallowed Node Moves

2.2.3 Removing a Node

2.3 Performing Operations on Edges

2.3.1 Adding an Edge

2.3.2 Moving an Edge

2.3.3 Removing an Edge

2.3.4 Updating an Edge

3 SDO_TOPO Package Subprograms

SDO_TOPO.ADD_TOPO_GEOMETRY_LAYER

SDO_TOPO.CREATE_TOPOLOGY

SDO_TOPO.DELETE_TOPO_GEOMETRY_LAYER

SDO_TOPO.DROP_TOPOLOGY

SDO_TOPO.GET_FACE_BOUNDARY

SDO_TOPO.GET_TOPO_OBJECTS

SDO_TOPO.INITIALIZE_METADATA

4 SDO_TOPO_MAP Package Subprograms

SDO_TOPO_MAP.ADD_EDGE

SDO_TOPO_MAP.ADD_ISOLATED_NODE

SDO_TOPO_MAP.ADD_LOOP

SDO_TOPO_MAP.ADD_NODE

SDO_TOPO_MAP.CHANGE_EDGE_COORDS

SDO_TOPO_MAP.CLEAR_TOPO_MAP

SDO_TOPO_MAP.COMMIT_TOPO_MAP

SDO_TOPO_MAP.CREATE_EDGE_INDEX

SDO_TOPO_MAP.CREATE_FACE_INDEX

SDO_TOPO_MAP.CREATE_TOPO_MAP

SDO_TOPO_MAP.DROP_TOPO_MAP

SDO_TOPO_MAP.GET_CONTAINING_FACE

SDO_TOPO_MAP.GET_EDGE_ADDITIONS

SDO_TOPO_MAP.GET_EDGE_CHANGES

SDO_TOPO_MAP.GET_EDGE_COORDS

SDO_TOPO_MAP.GET_EDGE_DELETIONS

SDO_TOPO_MAP.GET_EDGE_NODES

SDO_TOPO_MAP.GET_FACE_ADDITIONS

SDO_TOPO_MAP.GET_FACE_CHANGES

SDO_TOPO_MAP.GET_FACE_DELETIONS

SDO_TOPO_MAP.GET_NEAREST_EDGE

SDO_TOPO_MAP.GET_NEAREST_NODE

SDO_TOPO_MAP.GET_NODE_ADDITIONS

SDO_TOPO_MAP.GET_NODE_CHANGES

SDO_TOPO_MAP.GET_NODE_COORD

SDO_TOPO_MAP.GET_NODE_DELETIONS

SDO_TOPO_MAP.GET_NODE_STAR

SDO_TOPO_MAP.GET_TOPO_NAME

SDO_TOPO_MAP.LIST_TOPO_MAPS

SDO_TOPO_MAP.LOAD_TOPO_MAP

SDO_TOPO_MAP.MOVE_EDGE

SDO_TOPO_MAP.MOVE_ISOLATED_NODE

SDO_TOPO_MAP.MOVE_NODE

SDO_TOPO_MAP.REMOVE_EDGE

SDO_TOPO_MAP.REMOVE_NODE

SDO_TOPO_MAP.ROLLBACK_TOPO_MAP

SDO_TOPO_MAP.UPDATE_TOPO_MAP

SDO_TOPO_MAP.VALIDATE_TOPO_MAP

SDO_TOPO_MAP.VALIDATE_TOPOLOGY

5 Topology Operators

SDO_ANYINTERACT

Part II Network Data Model

6 Network Data Model Overview

6.1 Introduction to Network Modeling

6.2 Main Steps in Using the Network Data Model

6.2.1 Letting Spatial Perform Most Operations

6.2.2 Performing the Operations Yourself

6.3 Network Data Model Concepts

6.4 Network Applications

6.4.1 Road Network Example

6.4.2 Train (Subway) Network Example

6.4.3 Utility Network Example

6.4.4 Biochemical Network Example

6.5 Network Hierarchy

6.6 Network Data Model Tables

6.6.1 Node Table

6.6.2 Link Table

6.6.3 Path Table

6.6.4 Path-Link Table

6.7 Network Data Model Metadata Views

6.7.1 xxx_SDO_NETWORK_METADATA Views

6.8 Network Data Model Application Programming Interface

6.8.1 Network Data Model PL/SQL Interface

6.8.2 Network Data Model Java Interface

6.8.2.1 Network Metadata and Data Management

6.8.2.2 Network Analysis

6.9 Network Examples (PL/SQL)

6.9.1 Simple Spatial (SDO) Network Example

6.9.2 Simple Logical Network Example

6.9.3 Spatial (LRS) Network Example

6.9.4 Logical Hierarchical Network Example

7 SDO_NET Package Subprograms

SDO_NET.COPY_NETWORK

SDO_NET.CREATE_LINK_TABLE

SDO_NET.CREATE_LOGICAL_NETWORK

SDO_NET.CREATE_LRS_NETWORK

SDO_NET.CREATE_LRS_TABLE

SDO_NET.CREATE_NODE_TABLE

SDO_NET.CREATE_PATH_LINK_TABLE

SDO_NET.CREATE_PATH_TABLE

SDO_NET.CREATE_SDO_NETWORK

SDO_NET.CREATE_TOPO_NETWORK

SDO_NET.DROP_NETWORK

SDO_NET.GET_CHILD_LINKS

SDO_NET.GET_CHILD_NODES

SDO_NET.GET_GEOMETRY_TYPE

SDO_NET.GET_IN_LINKS

SDO_NET.GET_LINK_COST_COLUMN

SDO_NET.GET_LINK_DIRECTION

SDO_NET.GET_LINK_GEOM_COLUMN

SDO_NET.GET_LINK_GEOMETRY

SDO_NET.GET_LINK_TABLE_NAME

SDO_NET.GET_LRS_GEOM_COLUMN

SDO_NET.GET_LRS_LINK_GEOMETRY

SDO_NET.GET_LRS_NODE_GEOMETRY

SDO_NET.GET_LRS_TABLE_NAME

SDO_NET.GET_NETWORK_TYPE

SDO_NET.GET_NO_OF_HIERARCHY_LEVELS

SDO_NET.GET_NO_OF_LINKS

SDO_NET.GET_NO_OF_NODES

SDO_NET.GET_NODE_DEGREE

SDO_NET.GET_NODE_GEOM_COLUMN

SDO_NET.GET_NODE_GEOMETRY

SDO_NET.GET_NODE_IN_DEGREE

SDO_NET.GET_NODE_OUT_DEGREE

SDO_NET.GET_NODE_TABLE_NAME

SDO_NET.GET_OUT_LINKS

SDO_NET.GET_PATH_GEOM_COLUMN

SDO_NET.GET_PATH_TABLE_NAME

SDO_NET.IS_HIERARCHICAL

SDO_NET.IS_LOGICAL

SDO_NET.IS_SPATIAL

SDO_NET.LRS_GEOMETRY_NETWORK

SDO_NET.NETWORK_EXISTS

SDO_NET.SDO_GEOMETRY_NETWORK

SDO_NET.TOPO_GEOMETRY_NETWORK

SDO_NET.VALIDATE_LINK_SCHEMA

SDO_NET.VALIDATE_LRS_SCHEMA

SDO_NET.VALIDATE_NETWORK

SDO_NET.VALIDATE_NODE_SCHEMA

SDO_NET.VALIDATE_PATH_SCHEMA

Index