7.5 SDO_NFE.CREATE_MODEL_UNDERLYING_NET

Format

SDO_NFE.CREATE_MODEL_UNDERLYING_NET(
     model_id             IN NUMBER,
     network_name         IN VARCHAR2,
     num_hierarchy_levels IN NUMBER,
     is_directed          IN BOOLDEAN,
     node_with_costs      IN BOOLEAN);

Description

Creates a spatial network and associates it to the specified NFE Model. It also creates sequences for its nodes, links, and paths, and registers them in the model's metadata.

Parameters

model_id

ID of the NFE model.

network_name

Name of the network to be created.

num_hierarchy_levels

Number of hierarchical levels for the network.

is_directed

TRUE if the network is directed.

node_with_costs

TRUE if the network’s nodes contain cost values.

Usage Notes

An NFE model with the specified ID must exist. The geometry metadata must be registered for the newly created network’s nodes and links tables.

Examples

The following example creates an underlying network for an NFE model and registers the geometry metadata for the network’s links and nodes tables.

DECLARE
  model_id      	 NUMBER	:= 1;
  network_name          VARCHAR2(50) := 'MODEL01';
  num_hierarchy_levels  NUMBER := 1;
  is_directed           VARCHAR2(10) := 'TRUE';
  node_with_costs       VARCHAR2(10) := 'TRUE';
BEGIN
-- create underlying network
  SDO_NFE.create_model_underlying_net( model_id, network_name, num_hierarchy_levels, is_directed, node_with_costs );
-- register links and nodes tables geom metadata
  SDO_NET.insert_geom_metadata(network_name, SDO_DIM_ARRAY(SDO_DIM_ELEMENT('LONGITUDE', -180, 180, 0.5), SDO_DIM_ELEMENT('LATITUDE', -90, 90, 0.5)), 8307);
END;
/