contrib:bz10m_roads_spatial
This is an old revision of the document!
BZ10M: Bolzano Roads Network Spatial Table
Import:
imp user/pass file=/bz10m/roads_spatial/roads_spatial-current.dmp full=y
The table will be called BZ_ROADS.
This is the TeleAtlas table we got from the municipality on July the 18, 2007. The table contains linestrings (in GEOMETRY column), which represent roads segments; In Network Data Model they become links.
We are working on the meanings of the columns:
| 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 |
/data/www/wiki.inf.unibz.it/data/attic/contrib/bz10m_roads_spatial.1190812569.txt.gz · Last modified: 2019/01/16 10:03 (external edit)