Differences

This shows you the differences between two versions of the page.

--- contrib:bz10m_bus_network [2007/09/26 17:54] – created sleleiva
+++ contrib:bz10m_bus_network [2007/10/25 18:03] – Lines 1 and 1_HOLIDAYS added sleleiva
@@ Line 3: / Line 3: @@
 == Import ==
-  imp user/pass file=/bz10m/bus_network-current.dmp full=y
+  imp user/pass file=/bz10m/bus_network-1.1.dmp full=y
 Create network (needs to be done once for each bus):
 <code oracle8>
+INSERT INTO USER_SDO_NETWORK_METADATA(
+                network, network_category, geometry_type,
+                node_table_name, node_geom_column,
+                link_table_name, link_geom_column, link_direction)
+        VALUES(
+                'BZ_BUS_L1_NET', 'SPATIAL', 'SDO_GEOMETRY',
+                'BZ_BUS_L1_NODE$', 'GEOMETRY',
+                'BZ_BUS_L1_LINK$', 'GEOMETRY', 'DIRECTED');
+INSERT INTO USER_SDO_NETWORK_METADATA(
+                network, network_category, geometry_type,
+                node_table_name, node_geom_column,
+                link_table_name, link_geom_column, link_direction)
+        VALUES(
+                'BZ_BUS_L1_HOLIDAYS_NET', 'SPATIAL', 'SDO_GEOMETRY',
+                'BZ_BUS_L1_HOLIDAYS_NODE$', 'GEOMETRY',
+                'BZ_BUS_L1_HOLIDAYS_LINK$', 'GEOMETRY', 'DIRECTED');
 INSERT INTO USER_SDO_NETWORK_METADATA(
                 network, network_category, geometry_type,
@@ Line 14: / Line 30: @@
                 'BZ_BUS_L2_NET', 'SPATIAL', 'SDO_GEOMETRY',
                 'BZ_BUS_L2_NODE$', 'GEOMETRY',
-                'BZ_BUS_L2_LINK$', 'GEOMETRY', ' DIRECTED');
+                'BZ_BUS_L2_LINK$', 'GEOMETRY', 'DIRECTED');
 INSERT INTO USER_SDO_NETWORK_METADATA(
                 network, network_category, geometry_type,
@@ Line 22: / Line 38: @@
                 'BZ_BUS_L10A_NET', 'SPATIAL', 'SDO_GEOMETRY',
                 'BZ_BUS_L10A_NODE$', 'GEOMETRY',
-                'BZ_BUS_L10A_LINK$', 'GEOMETRY', ' DIRECTED');
+                'BZ_BUS_L10A_LINK$', 'GEOMETRY', 'DIRECTED');
 </code>
-Current version: 1.0 (9/26/2007) (bus lines 2, 10A)
+Current version: 1.1 (10/25/2007) (bus lines 1, 1_HOLIDAYS, 2, 10A)\\
+Previous versions: 1.0 (9/26/2007) (bus lines 2, 10A)
 The imported network data model will contain two tables per bus line BZ_BUS_L*_LINK$ and BZ_BUS_L*_NODE$; and the table BZ_BUS_STOPS_ON_LINK to connect bus network with the roads network.
-The links are taken from a bus network provided long time ago by Municipality, thus it does not exactly map on the corresponding links (streets) of the [[contrib:bz10m_roads_network]]. The nodes are the bus stations. The link directions corresponds to the direction of a bus.
+The links are taken from a bus network provided long time ago by Municipality, thus it does not exactly map on the corresponding links (streets) of the [[contrib:bz10m_roads_network|BZ_ROADS_LINK$]]. The nodes are the bus stations. The link directions corresponds to the direction of a bus.
 To transfer oneself from a bus network to a roads network and vice versa, use the BZ_BUS_STOPS_ON_LINK table. Look at the column descriptions below.
@@ Line 48: / Line 65: @@
 **BZ_BUS_STOPS_ON_LINK:**
 |STOP_NODE_ID  |ID of the bus stop in the BZ_BUS_L*_NODE$ table|
-|LINE          |Name of the bus line (e.g. '2', '10A')|
+|LINE          |Name of the bus line (e.g. '1', '1_HOLIDAYS', '10A')|
-|LINK_ID       |ID of the link of the [[contrib:bz10m_roads_network|BZ_ROADS_LINK$l]] table\\ It indicates the link, on which the current bus stop (STOP_NODE_ID) of the bus line (LINE) resides |
+|LINK_ID       |ID of the link of the [[contrib:bz10m_roads_network|BZ_ROADS_LINK$]] table\\ It indicates the link, on which the current bus stop (STOP_NODE_ID) of the bus line (LINE) resides |
 |DISTANCE_RATIO|A value between 0 and 1, indicating on which part of the link (LINK_ID) the bus stop (STOP_NODE_ID) is (WRT to link start)|