contrib:bz10m_bus_network
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
contrib:bz10m_bus_network [2007/09/26 17:54] – created sleleiva | contrib:bz10m_bus_network [2019/01/16 10:03] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | === BZ10M: Bolzano Buses Network - Network Data Model === | + | === This page has been moved to: === |
+ | https:// | ||
- | == Import | + | === Please update |
- | + | ||
- | imp user/pass file=/ | + | |
- | + | ||
- | Create network (needs to be done once for each bus): | + | |
- | <code oracle8> | + | |
- | INSERT INTO USER_SDO_NETWORK_METADATA( | + | |
- | network, network_category, | + | |
- | node_table_name, | + | |
- | link_table_name, | + | |
- | VALUES( | + | |
- | ' | + | |
- | ' | + | |
- | ' | + | |
- | INSERT INTO USER_SDO_NETWORK_METADATA( | + | |
- | network, network_category, | + | |
- | node_table_name, | + | |
- | link_table_name, | + | |
- | VALUES( | + | |
- | ' | + | |
- | ' | + | |
- | ' | + | |
- | </ | + | |
- | + | ||
- | Current version: 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$; | + | |
- | + | ||
- | The links are taken from a bus network provided long time ago by Municipality, | + | |
- | + | ||
- | 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. | + | |
- | + | ||
- | == Columns == | + | |
- | **BZ_BUS_L*_LINK$: | + | |
- | |LINK_ID | + | |
- | |START_NODE_ID|ID of the starting node (bus station) of the link in the BZ_BUS_L*_NODE$| | + | |
- | |END_NODE_ID | + | |
- | |COST | + | |
- | |GEOMETRY | + | |
- | + | ||
- | **BZ_BUS_L*_NODE$: | + | |
- | |NODE_ID | + | |
- | |NAME |Name of the bus station| | + | |
- | |GEOMETRY | + | |
- | + | ||
- | **BZ_BUS_STOPS_ON_LINK: | + | |
- | |STOP_NODE_ID | + | |
- | |LINE |Name of the bus line (e.g. ' | + | |
- | |LINK_ID | + | |
- | |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)| | + | |
- | + | ||
- | + | ||
- | == Creating index == | + | |
- | If you want to use any spatial operators (such as finding all segments within distance, retrieving bounding rectangle etc.) you need to create an index for any table of the bus line. | + | |
- | How to do this for the LINK table (same for NODE, just substitute LINK$ with NODE$): | + | |
- | <code oracle8> | + | |
- | INSERT INTO USER_SDO_GEOM_METADATA(TABLE_NAME, | + | |
- | | + | |
- | SDO_DIM_ARRAY(SDO_DIM_ELEMENT(' | + | |
- | SDO_DIM_ELEMENT(' | + | |
- | ); | + | |
- | CREATE INDEX BZ_BUS_L*_LINK$_INDEX ON BZ_BUS_L*_LINK$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX; | + | |
- | </ | + | |
/data/www/wiki.inf.unibz.it/data/attic/contrib/bz10m_bus_network.1190822060.txt.gz · Last modified: 2019/01/16 10:03 (external edit)