Differences

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

--- contrib:bz10m_roads_network [2007/09/26 16:39] – created sleleiva
+++ contrib:bz10m_roads_network [2019/01/16 10:03] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-=== BZ10M: Bolzano Roads Network - Network Data Model ===
+=== This page has been moved to: ===
+https://www.inf.unibz.it/dis/wiki/doku.php?id=projects:bz10m:roads_network
-== Import ==
+=== Please update your records. ===
-  imp user/pass file=/bz10m/roads_network-current.dmp full=y
-Current version: 1.0 (9/26/2007)
-The imported network data model will contain two tables: BZ_ROADS_LINK$ and BZ_ROADS_NODE$
-The links are taken directly from the [[contrib:bz10m_roads_spatial|Spatial table]] road segments (linestrings). The nodes are created by generating a node for each segment start and end points.
-== Columns ==
-BZ_ROADS_LINK$:
-|LINK_ID      |ID of the link. Equals to the Municipality's spatial table ID column with the following formula:\\ LINK_ID=ID-23800000000000 - this is because [[contrib:orcl_visualization_tools|Network Model Editor]] is not able to visualize objects with huge IDs|
-|START_NODE_ID|ID of the starting node of the link in the BZ_ROADS_NODE$|
-|END_NODE_ID  |ID of the ending node of the link in the BZ_ROADS_NODE$||
-|COST         |NUMBER value created for your needs. Initially - NULL|
-|LINK_NAME    |Name of the link (street name). Copied from the [[contrib:bz10m_roads_spatial|BZ_ROADS]].NAME|
-|LENGTH       |The length of the link in meters, a thousandth part precision. Copied from the [[contrib:bz10m_roads_spatial|BZ_ROADS]].LENGTH|
-|MINUTES      |Amount of minutes to travel this link. Copied from the [[contrib:bz10m_roads_spatial|BZ_ROADS]].LINK|
-|KPH          |Speed limit. Copied from the [[contrib:bz10m_roads_spatial|BZ_ROADS]].KPH|
-|GEOMETRY     |Geometry column to specify link appearance. Copied from the [[contrib:bz10m_roads_spatial|BZ_ROADS]].GEOMETRY|
-BZ_ROADS_NODE$:
-|NODE_ID      |ID of the node|
-|GEOMETRY     |Geometry column to indicate node coordinates. Was taken from either a start or end point of each [[contrib:bz10m_roads_spatial|BZ_ROADS]].GEOMETRY row|
-== 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 this table.
-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, COLUMN_NAME, DIMINFO)
-       VALUES('BZ_ROADS_LINK$', 'GEOMETRY',
-              SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180, 180, 0.05),
-                            SDO_DIM_ELEMENT('Y', -90, 90, 0.05))
-       );
-CREATE INDEX BZ_ROADS_LINK$_INDEX ON BZ_ROADS_LINK$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX;
-</code>