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/17 10:54] – vrepsys
@@ Line 3: / Line 3: @@
 == Import ==
-  imp user/pass file=/home/students/vrepsys/sensors-16-01-2007.dmp full=y
+  imp user/pass file=/data/temporal/bz10m_sensors-16-01-2007.dmp full=y
 Two tables will be imported: SENSORS and SENSORS_DATA
@@ Line 20: / Line 20: @@
 **SENSORS_DATA:**
 |SENSORS_DATA_ID|NUMBER(16)| |
-|SENSOR_ID|NUMBER(16)|foreign key, references SENSORS table|
+|SENSOR_ID|NUMBER(16)|Foreign key, references SENSORS table|
-|LANE|NUMBER(16)|the number of the lane|
+|LANE|NUMBER(16)|The number of the lane|
-|TIME|TIMESTAMP|time of the flow (the data is colleted every half an hour)|
+|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|
+|FLOW|NUMBER(16)|Number of cars that have passed the sensor in half an hour starting with TIME|