contrib:bz10m_roads2_network
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
contrib:bz10m_roads2_network [2008/01/17 10:47] – Merged sleleiva | contrib:bz10m_roads2_network [2019/01/16 10:03] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | === BZ10M: Bolzano Roads 2 (New) Network - Network Data Model === | + | === This page has been moved to: === |
+ | https:// | ||
- | == Import | + | === Please update your records. === |
- | + | ||
- | imp user/pass file=/ | + | |
- | + | ||
- | Create network (needs to be done once): | + | |
- | <code oracle8> | + | |
- | INSERT INTO USER_SDO_NETWORK_METADATA( | + | |
- | network, network_category, | + | |
- | node_table_name, | + | |
- | link_table_name, | + | |
- | VALUES( | + | |
- | ' | + | |
- | ' | + | |
- | ' | + | |
- | </ | + | |
- | + | ||
- | Current version: 1.0 (1/ | + | |
- | + | ||
- | This is the TeleAtlas table we got from the Creaform on November the 12th. The table contains linestrings (in GEOMETRY column), which represent roads segments. | + | |
- | The most important change here is the number of lanes (NUMCORSIE). Whenever NUMCORSIE=0, it is assumed | + | |
- | + | ||
- | The imported network data model will contain two tables: BZ_ROADS_LINK$ and BZ_ROADS_NODE$ | + | |
- | + | ||
- | The links are taken directly from the [[contrib: | + | |
- | + | ||
- | == Columns of the table == | + | |
- | We are working on the meanings of the columns: | + | |
- | **BZ_ROADS: | + | |
- | |LINK_ID | + | |
- | |LINK_NAME | + | |
- | |START_NODE_ID| | + | |
- | |END_NODE_ID | + | |
- | |LINK_TYPE | + | |
- | |ACTIVE | + | |
- | |LINK_LEVEL | + | |
- | |GEOMETRY | + | |
- | |COST | | + | |
- | |BIDIRECTED | + | |
- | |GC_ID | + | |
- | |GC_CODICE | + | |
- | |GC_CODAGGR | + | |
- | |GC_QMED | + | |
- | |GC_COUNT | + | |
- | |GC_SVIL | + | |
- | |ID | | + | |
- | |FEATTYP | + | |
- | |FT | | + | |
- | |F_JNCTID | + | |
- | |F_JNCTTYP | + | |
- | |T_JNCTID | + | |
- | |T_JNCTTYP | + | |
- | |PJ | | + | |
- | |METERS | + | |
- | |FRC | | + | |
- | |NET1CLASS | + | |
- | |NET2CLASS | + | |
- | |NAME | | + | |
- | |NAMELC | + | |
- | |SOL | | + | |
- | |JUMP | | + | |
- | |ROUTENUM | + | |
- | |RTETYP | + | |
- | |RTEDIR | + | |
- | |RTEDIRVD | + | |
- | |PROCSTAT | + | |
- | |COD_REG | + | |
- | |COD_PROV | + | |
- | |COD_COM | + | |
- | |GC_DESCR | + | |
- | |LONG1 | + | |
- | |LONG2 | + | |
- | |IDASSE | + | |
- | |LST_ONEWAY | + | |
- | |LST_PUT | + | |
- | |ID_STRASSE | + | |
- | |TEXT_D | + | |
- | |TEXT_I | + | |
- | |TEXT_DIL | + | |
- | |ANNOTAZION | + | |
- | |NODO_VL | + | |
- | |CORSIABUS | + | |
- | |NUMCORSIE | + | |
- | |NODO_MT | + | |
- | + | ||
- | Explanations from an old table (may not match): | + | |
- | + | ||
- | |ID|long integer, the ID for each road segment| | + | |
- | |FEATTYP|? | + | |
- | |FT|?| | + | |
- | |F_JNCTID|? | + | |
- | |F_JNCTTYP|? | + | |
- | |T_JNCTID|? | + | |
- | |T_JNCTTYP|? | + | |
- | |PJ|?| | + | |
- | |METERS|Length of a segment in meters, rounded up to the hundredth part. See LENGTH| | + | |
- | |FRC|?| | + | |
- | |NETCLASS|? | + | |
- | |NETBCLASS|? | + | |
- | |NET2CLASS|? | + | |
- | |NAME|Name of the street/ | + | |
- | |NAMELC|? | + | |
- | |SOL|?| | + | |
- | |NAMETYP|? | + | |
- | |CHARGE|? | + | |
- | |ROUTENUM|Highway number| | + | |
- | |RTETYP|? | + | |
- | |RTEDIR|? | + | |
- | |RTEDIRVD|? | + | |
- | |PROCSTAT|? | + | |
- | |FOW|?| | + | |
- | |SLIPRD|? | + | |
- | |BACKRD|? | + | |
- | |TOLLRD|? | + | |
- | |RDCOND|? | + | |
- | |STUBBLE|? | + | |
- | |PRIVATERD|? | + | |
- | |CONSTATUS|? | + | |
- | |ONEWAY|Road type. Looks utterly incomplete.\\ FT-one way street\\ N-only for bus or cycle (transit limited e.g. Downtown)| | + | |
- | |F_BP|?| | + | |
- | |T_BP|?| | + | |
- | |F_ELEV|? | + | |
- | |T_ELEV|? | + | |
- | |KPH|Speed limit| | + | |
- | |MINUTES|Calculated column: amount of time in minutes which takes to drive the road segment, when driving at the speed limit| | + | |
- | |POSACCUR|? | + | |
- | |CARRIAGE|? | + | |
- | |LANES|Number of lanes. Utterly incomplete (98.7% are zeroes)| | + | |
- | |LENGTH|The length of the road in meters, precise up to a thousandth part| | + | |
- | + | ||
- | == 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> | + | |
- | DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME=' | + | |
- | INSERT INTO USER_SDO_GEOM_METADATA(TABLE_NAME, | + | |
- | | + | |
- | SDO_DIM_ARRAY(SDO_DIM_ELEMENT(' | + | |
- | SDO_DIM_ELEMENT(' | + | |
- | 82344) | + | |
- | ); | + | |
- | CREATE INDEX BZ_ROADS2_LINK$_INDEX ON BZ_ROADS2_LINK$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX; | + | |
- | </ | + | |
/data/www/wiki.inf.unibz.it/data/pages/contrib/bz10m_roads2_network.txt · Last modified: 2019/01/16 10:03 by 127.0.0.1