BZ10M: Bolzano Roads Network Spatial Table v2.0

Import
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).

Index
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 Number of lanes. When =0, means there are two lanes (one per direction)
NODO_MT

Explanations from an old table (may not match):

IDlong integer, the ID for each road segment
FEATTYP?
FT?
F_JNCTID?
F_JNCTTYP?
T_JNCTID?
T_JNCTTYP?
PJ?
METERSLength of a segment in meters, rounded up to the hundredth part. See LENGTH
FRC?
NETCLASS?
NETBCLASS?
NET2CLASS?
NAMEName of the street/highway number
NAMELC?
SOL?
NAMETYP?
CHARGE?
ROUTENUMHighway number
RTETYP?
RTEDIR?
RTEDIRVD?
PROCSTAT?
FOW?
SLIPRD?
BACKRD?
TOLLRD?
RDCOND?
STUBBLE?
PRIVATERD?
CONSTATUS?
ONEWAYRoad 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?
KPHSpeed limit
MINUTESCalculated column: amount of time in minutes which takes to drive the road segment, when driving at the speed limit
POSACCUR?
CARRIAGE?
LANESNumber of lanes. Utterly incomplete (98.7% are zeroes)
LENGTHThe length of the road in meters, precise up to a thousandth part