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
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; /
Parent topic: SDO_NFE Package Subprograms