New York State provides real-time hourly PM2.5 data in micrograms per cubic metre µg/m³ for twenty-three air quality monitoring stations across the state.
Select Reports and then Station Report.
The default settings are ok - Grid and Daily.
DO NOT select Export Excel on this screen. It will not give you a usable Excel format (it's maybe just producing HTML, I think it's an error unless it's some sort of XML format).
Select the station you want.
Note that not all stations have PM2.5 data. See the bottom of the post for the list of twenty-three PM2.5 stations.
Select the starting day. Ignore the ending day; no matter what you select it will only give you a day's worth of data.
When you click Generate Report, you will get a screen with a table of hourly measurements, and some options across the top.
In the Export pulldown menu, select CSV, and then click on the blue Export link.
And that's basically it for getting a day's worth of realtime PM2.5 data from a single station.
If you want a one-hour snapshot of PM2.5 across all the stations, instead select Dynamic Tables from the left-hand menu, then select PM2.5, then select Export Text.
Export Text will give you a vertical bar | separated set of values, you should be able to import into a spreadsheet by telling it that a vertical bar is the delimiter rather than a comma.
Incidentally, either of these approaches will enable you to get realtime data from Whiteface Base (the base of Whiteface Mountain, New York), the closest monitoring station to Ottawa.
This is different from the US EPA data for Whiteface Base which is not real-time (the latest approved EPA data from the AirData map are at least two months old).
PM 2.5 Station List
- Albany County HD
- Buffalo
- Buffalo Near Road
- CCNY
- Eisenhower Park
- Fresh Kills West
- IS 143
- IS 52
- IS 74
- Maspeth
- Newburgh
- Pinnacle
- Port Richmond
- PS 274
- PS 314
- Queens College
- Rochester Near Rd
- Rockland County
- Suffolk County
- Tonawanda II
- White Plains
- Utica
- Whiteface Base
Recent Comments