contrib:bz10m_sensors_tables
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
contrib:bz10m_sensors_tables [2008/01/16 19:37] – vrepsys | contrib:bz10m_sensors_tables [2019/01/16 10:03] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
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 passed in half an hour starting with TIME| | + | |
+ | === Please update your records. === | ||
/data/www/wiki.inf.unibz.it/data/pages/contrib/bz10m_sensors_tables.txt · Last modified: 2019/01/16 10:03 by 127.0.0.1