Log of ReNewport Project

Tue Mar 19 21:43:28 EDT 2024

nky = do.call(rbind.data.frame,list(pas$sensor_index,pas$longitude,pas$latitude,pas$pm2.5_10minute,pas$pm2.5_30minute,pas$pm2.5_60minute,pas$pm2.5_6hour,pas$pm2.5_24hour,pas$pm2.5_1week))
write.table(t(nky),file="nkymatrix.csv", quote=F,sep=",",row.names=F)

Mon Mar 18 21:36:42 EDT 2024

Good lord, they've implemented some new dashboard, https://develop.purpleair.com/dashboards/organization , and I was supposed to know that?
And it looks like I've consumed all of my points: I have -33,033 available.
Working within R, and within Newport.R specifically:
- save(pat_data,file = "stuff",ascii=TRUE) % (thanks)
- write.table(as.data.frame(pas),file="mylist.csv", quote=F,sep=",",row.names=F) % (thanks)
- write.table(as.data.frame(pat_data),file="patdata.csv", quote=F,sep=",",row.names=F)
From https://api.purpleair.com/:
- this call
PurpleAir Data Exploration Vignette: RISE Presentation, Author Stephen Colegate, Published July 31, 2023.
- https://github.com/geomarker-io/purple_air_data_in_R/ -- github site for this vignette
Cool relay control project, using PurpleAir data to turn on HVAC:
https://github.com/jcdoll/purpleAirRelayControl/blob/master/PurpleAirRelayControl.ino#L23

asdf

Saturday, March 16th

Since Brandyn is using the EPA's 710 (had a file called EPA_710_DailySource.csv), I investigated and found EPA's Outdoor Air Quality Data page

request an API key: https://aqs.epa.gov/data/api/signup?email=longa@nku.edu

The account you requested for the EPA's AQS Data Mart has been created. Please click on the link below to confirm your account:

https://aqs.epa.gov/data/api/confirm_email?email=longa@nku.edu&confirm_token=uzJjNpNFMFo_fHiNrfp8KQ

Your user ID is your email address: longa@nku.edu
Your key is: taupeswift45

This key was automatically generated. If, for any reason, it will not work for you, please respond and request a new one.

You can stay informed of system and data developments at our RSS feed: http://www.epa.gov/airquality/airdata/rssairdata.xml

Followed the link, as requested above. Now what?:)

AirNow:

Response to my request (username: cassandrew; airnow@org):

Thank you for your interest in creating an AirNow API account.

Your confirmation code is: 77D07E02-8858-4385-A2C6-9960B41E4276

Please activate your account at:

https://docs.airnowapi.org//account/request?userCode=77D07E02-8858-4385-A2C6-9960B41E4276

Or you may paste the link above in your browser.


AirNow Data Management Center

airnowdmc@airnowtech.org

Followed my link, and account activated.
FAQ
Current Air Quality for Newport (and forecast!) from AirNow: PM2.5 and PM10, and ozone.

Now what?:)

IQAir has a dashboard for air quality. Its map includies winds!
I found an interesting Rule 1180 dashboard for Southern CA.

Sat Mar 16 01:18:39 EDT 2024

Brandyn Ruiz:
Shiny Dashboard (USC)
I'd say it's a stretch to call it a dashboard....

Sun Feb 25 08:34:46 EST 2024

I've looked, and I've actually pulled some data. So now I have to think about what to show folks at the meeting. I'm thinking about creating a heat map, using the data, and letting it evolve over time. So maybe I'll use all of February data for the area's sensors, create a model, and then generate an animation of air quality over time....

Thu Feb 22 22:31:44 EST 2024

I've just installed AirSensor2, and made my first pull from PurpleAir.
There's a script in the sub-directory AirSensor, purpleair.R, which Tiffany Harvey sent me; time to look into that.

Wed Feb 21 22:39:26 EST 2024

Sun Feb 18 14:19:49 EST 2024

I found my shiny app, and will be able to adapt it (I hope) to create a dashboard:
- Fatten-n-Flatten the Covid-19 Infection Curve
- Here's a link to administer the project (will require a log-in).

Mon Feb 12 21:49:36 EST 2024

I've created my first PurpleAir API keys
Needed to login via google to get the keys, and used cassandrewlong@gmail.com to do so.
Created a PurpleAir account, too, with username longa; purpleair usual com ending.
I assigned some of my 1000000 points to my project, following the instructions here.

RISE Communities FREE Training and PurpleAir Sensors

I tried making a pull, but was told that I don't have any points; since I've moved the points, I can make a call, based on the example at this page (search for ....)

Loading PurpleAir Widget...

PurpleAir Map of Cincinnati

So we're somewhere in the vicinity of /39.0969/-84.51483 and /39.08311/-84.46898

So I'm going to make this call

which got me this:

{
  "api_version" : "V1.0.11-0.0.49",
  "time_stamp" : 1707795173,
  "data_time_stamp" : 1707795164,
  "location_type" : 0,
  "max_age" : 604800,
  "firmware_default_version" : "7.02",
  "fields" : ["sensor_index","name","latitude","longitude"],
  "data" : [
    [177011,"Trinity Episcopal Church",39.08723,-84.510574],
    [184237,"Monitor 7",39.086807,-84.49592],
    [184671,"Monitor 12",39.092567,-84.48834],
    [184699,"Monitor 10",39.084312,-84.497215],
    [184711,"Monitor 9",39.087906,-84.4918],
    [184723,"ReNewport",39.094616,-84.48508],
    [184721,"Monitor 4",39.090923,-84.49152],
    [184799,"338 E 9th St Newport KY 41071",39.0902,-84.48639]
  ]
}

Let's expand things with this call

{
  "api_version" : "V1.0.11-0.0.49",
  "time_stamp" : 1707795657,
  "data_time_stamp" : 1707795620,
  "location_type" : 0,
  "max_age" : 604800,
  "firmware_default_version" : "7.02",
  "fields" : ["sensor_index","name","latitude","longitude"],
  "data" : [
    [173711,"Hellmann Creative Center",39.07635,-84.51451],
    [175247,"home",39.09708,-84.48963],
    [177011,"Trinity Episcopal Church",39.08723,-84.510574],
    [184237,"Monitor 7",39.086807,-84.49592],
    [184259,"Monitor 6",39.082287,-84.498024],
    [184605,"Monitor 11",39.099586,-84.49018],
    [184671,"Monitor 12",39.092567,-84.48834],
    [184699,"Monitor 10",39.084312,-84.497215],
    [184711,"Monitor 9",39.087906,-84.4918],
    [184723,"ReNewport",39.094616,-84.48508],
    [184721,"Monitor 4",39.090923,-84.49152],
    [184725,"Monitor Mickey 8",39.082706,-84.49669],
    [184799,"338 E 9th St Newport KY 41071",39.0902,-84.48639],
    [188039,"McFarland",39.098476,-84.51862]
  ]
}

A little bit more: this call

And that did it:

		{
  "api_version" : "V1.0.11-0.0.49",
  "time_stamp" : 1707797663,
  "data_time_stamp" : 1707797617,
  "location_type" : 0,
  "max_age" : 604800,
  "firmware_default_version" : "7.02",
  "fields" : ["sensor_index","name","latitude","longitude"],
  "data" : [
    [160405,"Devou Park",39.08122,-84.52894],
    [168209,"Park Hills",39.068443,-84.53976],
    [172829,"The Bluffs near Devou Park",39.085186,-84.527145],
    [173711,"Hellmann Creative Center",39.07635,-84.51451],
    [175247,"home",39.09708,-84.48963],
    [177011,"Trinity Episcopal Church",39.08723,-84.510574],
    [184237,"Monitor 7",39.086807,-84.49592],
    [184259,"Monitor 6",39.082287,-84.498024],
    [184605,"Monitor 11",39.099586,-84.49018],
    [184671,"Monitor 12",39.092567,-84.48834],
    [184699,"Monitor 10",39.084312,-84.497215],
    [184711,"Monitor 9",39.087906,-84.4918],
    [184723,"ReNewport",39.094616,-84.48508],
    [184721,"Monitor 4",39.090923,-84.49152],
    [184725,"Monitor Mickey 8",39.082706,-84.49669],
    [184799,"338 E 9th St Newport KY 41071",39.0902,-84.48639],
    [188039,"McFarland",39.098476,-84.51862]
  ]
}

Now in R, I'm loading in a csv file of that stuff. From there I'll try loading in the csv of the data off the PurpleAir site for the region, and we'll see what happens....

source("readCSV.R")
sensors
sensors$sensor_index
 [1] 160405 168209 172829 173711 175247 177011 184237 184259 184605 184671
[11] 184699 184711 184723 184721 184725 184799 188039
max(sensors$longitude)
[1] -84.48508
 min(sensors$longitude)
[1] -84.53976

Website maintained by Andy Long. Comments appreciated.