contrib:bz10m_roads2_network
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
contrib:bz10m_roads2_network [2008/01/10 13:07] – created sleleiva | contrib:bz10m_roads2_network [2008/01/17 11:14] – vrepsys | ||
---|---|---|---|
Line 18: | Line 18: | ||
Current version: 1.0 (1/10/2008) | Current version: 1.0 (1/10/2008) | ||
+ | |||
+ | 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, | ||
The imported network data model will contain two tables: BZ_ROADS_LINK$ and BZ_ROADS_NODE$ | The imported network data model will contain two tables: BZ_ROADS_LINK$ and BZ_ROADS_NODE$ | ||
Line 23: | Line 26: | ||
The links are taken directly from the [[contrib: | 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) \\ \\ From the old database documentation (sent by Linas): \\ DW = Double Way \\ FT = One Way (you must symbolize with an arrow) \\ N = only for bus or cycle (transit Limited e.g. Downtown) \\ E = Motorway | ||
+ | |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 == | == Creating index == | ||
Line 28: | Line 134: | ||
How to do this for the LINK table (same for NODE, just substitute LINK$ with NODE$): | How to do this for the LINK table (same for NODE, just substitute LINK$ with NODE$): | ||
<code oracle8> | <code oracle8> | ||
- | INSERT INTO USER_SDO_GEOM_METADATA(TABLE_NAME, | + | 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_ARRAY(SDO_DIM_ELEMENT(' |
- | SDO_DIM_ELEMENT(' | + | SDO_DIM_ELEMENT(' |
+ | 82344) | ||
); | ); | ||
CREATE INDEX BZ_ROADS2_LINK$_INDEX ON BZ_ROADS2_LINK$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX; | 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