文档介绍：网络建模 BEGIN .WORK ( NETWORK=>'US_ROADS', ON_OF_HIERARCHY_LEVELS=>1, IS_DIRECTED=>TRUE, NODE_WITH_COST=>FALSE ); END; EXEC .WORK ('US_ROADS',1,TRUE,FALSE) DESDISCRIBE US_ROADS_NODES CREATE TABLE us_intersections ( node_id NUMBER , locaiton SDO_GEOMETRY, CONSTRAINT us_intersections_pk PRIMARY KEY (node_id) ); CREATE TABLE us_streets ( link_id NUMBER , start_node_id NUMBER NOT NULL, end_node_id NUMBER NOT NULL, active CHAR(1), street_geom SDO_GEOMETRY, street_length NUMBER, travel_time NUMBER, bidirected CHAR(1), CONSTRAINT us_streets_pk PRIMARY KEY (link_id) ); CREATE TABLE us_paths ( path_id NUMBER, start_node_id NUMBER NOT NULL, end_node_id NUMBER NOT NULL, cost NUMBER, simple VARCHAR2(1), path_geom SDO_GEOMETRY, CONSTRAINT us_paths_pk PRIMARY KEY (path_id) ); CREATE TABLE us_path_links( path_id NUMBER, link_id NUMBER, seq_no NUMBER, CONSTRAINT us_path_links_pk PRIMARY KEY (path_id,link_id) ); 设置网络元数据 INSERT INTO WORK_METADATA( NETWORK, NETWORK_CATEGORY, GEOMETRY_TYPE, NO_OF_HIERARCHY_LEVELS, NO_OF_PARTITIONS, LINK_DIRECTION, NODE_TABLE_NAME, NODE_GEOM_COLUMN, NODE_COST_COLUMN, LINK_TABLE_NAME, LINK_GEOM_COLUMN, LINK_COST_COLUMN, PATH_TABLE_NAME, PATH_GEOM_COLUMN, PATH_LINK_TABLE_NAME ) VALUES( 'US_ROADS', -------NETWORK (PRIMARY KEY) 'SPATIAL', --------BETWORK_CATEGORY 'SDO_GEOMETRY', ---GEOMETRY_TYPE 1, -------NO_OF_HIERARCHY_LEVELS 1, --------NO_OF_PARTITIONS 'D