imp user/pass file=/bz10m/roads_spatial2-1.0.dmp full=y
Current version: 1.0 (12/5/2007)
The table will be called BZ_ROADS2.
This is the TeleAtlas table we got from the municipality 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 NUMCORSIE=2 (one lane per one direction, bi-directed road).
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 | Number of lanes. When =0, means there are two lanes (one per direction) |
| 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/highway number |
| 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 |