User Tools

Site Tools


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-current.dmp full=y

Current version: 1.0 (9/26/2007)

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.

Index

The imported table will have its index created automatically. Index is needed in case you want to use any spatial operators (such as finding all segments within distance, retrieving bounding rectangle etc.)

Columns of the table

We are working on the meanings of the columns:
BZ_ROADS:

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
/data/www/wiki.inf.unibz.it/data/attic/contrib/bz10m_roads_spatial.1190821622.txt.gz · Last modified: 2019/01/16 10:03 (external edit)