User Tools

Site Tools


contrib:bz10m_sensors_tables

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
contrib:bz10m_sensors_tables [2008/01/17 10:54] vrepsyscontrib:bz10m_sensors_tables [2019/01/16 10:03] (current) – external edit 127.0.0.1
Line 1: Line 1:
-=== BZ10MBolzano  === +=== This page has been moved to: === 
- +https://www.inf.unibz.it/dis/wiki/doku.php?id=projects:bz10m:data:sensors_tables
-== Import == +
- +
-  imp user/pass file=/data/temporal/bz10m_sensors-16-01-2007.dmp full=+
- +
-Two tables will be importedSENSORS 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. NOTEno directions known yet | +
-|FLOW|NUMBER(16)|Number of cars that have passed the sensor in half an hour starting with TIME| +
  
 +=== Please update your records. ===
  
  
/data/www/wiki.inf.unibz.it/data/attic/contrib/bz10m_sensors_tables.1200563697.txt.gz · Last modified: 2019/01/16 10:03 (external edit)