User Tools

Site Tools


contrib:bz10m_sensors_tables

This is an old revision of the document!


BZ10M: Bolzano

Import
imp user/pass file=/home/students/vrepsys/sensors-16-01-2007.dmp full=y

Two tables will be imported: SENSORS and SENSORS_DATA

Index

No indexes will be created automatically while importing yet.

Tables

SENSORS:

SENSOR_IDNUMBER(16)
NAMEVARCHAR2(16)Name of the sensor

SENSORS_DATA:

SENSORS_DATA_IDNUMBER(16)
SENSOR_IDNUMBER(16)foreign key, references SENSORS table
LANENUMBER(16)the number of the lane
TIMETIMESTAMPtime of the flow (the data is colleted every half an hour)
VEHICLE_TYPENUMBER(1)0 for light vehicle, 1 for heavy vehicle
DIRECTIONNUMBER(1)0 for “out of the city”, 1 for “into the city”, 3 for unknown direction. NOTE: no directions known yet
FLOWNUMBER(16)number of cars passed in half an hour starting with TIME
/data/www/wiki.inf.unibz.it/data/attic/contrib/bz10m_sensors_tables.1200508591.txt.gz · Last modified: 2019/01/16 10:03 (external edit)