This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
projects:wifi:scan_3 [2020/04/14 00:51] neil |
projects:wifi:scan_3 [2020/04/16 00:09] neil |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Project Wifi Scanner: Data Scan 3 ====== | + | ====== Project Wifi Scanner: Data Scan 3a ====== |
- | Full scan of March 2020 - are people self isolating for COVID-19? Seems so. | + | Full scan of Feb 1st to April 10th 2020 - are people self isolating for COVID-19? Seems so. |
+ | |||
+ | {{:projects:wifi:feb-apr.png?600|}} | ||
+ | |||
+ | I loaded data in as below. Then exported the basics to a CSV in MySQL: | ||
+ | <code sql> | ||
+ | SELECT DATE(seen_time),COUNT(DISTINCT mac) FROM simple_data WHERE DATE(seen_time) BETWEEN '2020-02-01' AND '2020-04-31' GROUP BY DATE(seen_time) INTO OUTFILE '/tmp/feb-apr-plot.csv' | ||
+ | </code> | ||
+ | |||
+ | Then use [[gnuplot]] to generate a table of this data: | ||
+ | <code> | ||
+ | set xdata time | ||
+ | set key off | ||
+ | set timefmt "%Y-%m-%d" | ||
+ | set boxwidth 0.9 relative | ||
+ | set format x "%Y-%m-%d" | ||
+ | set title "Distinct MACs seen" | ||
+ | set style fill solid 1 | ||
+ | set label "Pubs are closed" at "2020-03-20", 10000 rotate by 90 | ||
+ | plot "/tmp/feb-apr-plot.csv" using 1:2 with boxes lt rgb 'orange' | ||
+ | </code> | ||
+ | |||
+ | I had to manually colour the weekends (until I can figure out how to get gnuplot to do that for me. | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ==== Original Version (Scan 3) ==== | ||
{{:projects:wifi:covid-19-wifi-weekend.png?600|}} | {{:projects:wifi:covid-19-wifi-weekend.png?600|}} |