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_ID | NUMBER(16) | |
| NAME | VARCHAR2(16) | Name of the sensor |
SENSORS_DATA:
| SENSORS_DATA_ID | NUMBER(16) | |
| SENSOR_ID | NUMBER(16) | foreign key, references SENSORS table |
| LANE | NUMBER(16) | the number of the lane |
| TIME | TIMESTAMP | time of the flow (the data is colleted every half an hour) |
| VEHICLE_TYPE | NUMBER(1) | 0 for light vehicle, 1 for heavy vehicle |
| DIRECTION | NUMBER(1) | 0 for “out of the city”, 1 for “into the city”, 3 for unknown direction. NOTE: no directions known yet |
| FLOW | NUMBER(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)