mi3nts / mints-aq-reports

Repository for generation of MINTS automated reports
https://mi3nts.github.io/mints-aq-reports/
1 stars 2 forks source link

Physical Addresses for Each Node #9

Open john-waczak opened 1 year ago

john-waczak commented 1 year ago

Currently we have a list of mac address device id's for each central node, lora node, utd node, etc in the network. The problem is that individual devices are exchanged when nodes come in for repair and nodes themselves often move physical location between westec, the lab, and out in the field. To make interfacing with the data simpler, we should generate a data table with the physical addresses for each node together with the date ranges at that address. This will further facilitate the reports as what we really want it to analyze the AQ data at a given location regardless of which nodes/sensors are placed there.

john-waczak commented 1 year ago

Per today's conversation we want 3 csv files:

  1. A file with "nice names" (perhaps using LaTeX strings) for each sensor. Example pm2_5 $\longrightarrow$ PM 2.5 as well as supplied instrument uncertainty information
  2. A file matching mac addresses to node names (we already have this in the AirQualityAnalysisWorkflows repo)
  3. A file containing street address together with latitude, longitude, altitude, and some kind of name for each deployment location (e.g. Westech, Joppa, etc...)

We can then use these files when formatting graphs, loading data, etc...

john-waczak commented 1 year ago

Per today's discussion, @lakithaomal we should create a script which for each day

  1. reads gps data
  2. computes the mean location and standard deviation
  3. convert the location to a open location code
  4. Generates a table on OSN for AirQualityNetwork/data/location/plus_code/year/month/day with links to all relevant time series for that day at that location.

We should make the code coarse enough that the exact location is not easily identifiable.