网络建模.txt

文档介绍：
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', ---GEOMET