Differences

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

--- projects:wifi:scan_3 [2020/04/13 23:51]
neil
+++ projects:wifi:scan_3 [2020/04/15 23:09] (current)
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|}}

neil.mckillop.org