Differences

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

--- contrib:bz10m_sensors_tables [2008/01/16 19:37] – vrepsys
+++ contrib:bz10m_sensors_tables [2008/01/28 11:40] – deleted -- obsolete information sleleiva
@@ Line 1: / Line 1: @@
-=== BZ10M: Bolzano  ===
+=== 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=/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 that have passed the sensor in half an hour starting with TIME|
+=== Please update your records. ===