openaq / openaq-fetch

A tool to collect data for OpenAQ platform.
MIT License
85 stars 39 forks source link

Investigate Australia, Queensland adapter for quality and coverage #1035

Open russbiggs opened 1 year ago

russbiggs commented 1 year ago

Per a user email we may be missing some sites and there may be another API for access AQ data from queensland

https://airquality.des.qld.gov.au/v1/stations/PROS/parameters/131/measurements?pagesize=1000&pagenumber=1

This data seems to show only 24 hr averages and AQI (though other sites may have different periods)

For our current data source data seems really spotty. Its not clear if this is an issue with the source or how we are scraping it.

e.g. (note the gaps)

Screenshot 2023-07-06 at 8 55 14 AM
majesticio commented 1 year ago

Ok, I will look into it

majesticio commented 1 year ago
Here are all the unique parameters from all stations from the new Queensland source: level_0 index parameter_id parameter_name abbreviation units 1hr_standard standard category_id link standard_units station_id
0 0 131 Particle PM2.5 PM2.5 µg/m³ 50.0 25.0 5 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-monitoring/trend-graphs\#c µg/m³ (24hr avg) abpo
1 1 1 Wind direction WD deg 0.0 0.0 2 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-monitoring/meteorology-factors\#windspeed deg (1hr avg) ald
2 2 2 Wind speed WS m/s 0.0 0.0 2 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-monitoring/meteorology-factors\#windspeed m/s (1hr avg) ald
3 3 9 Humidity Hum % 0.0 0.0 2 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-monitoring/meteorology-factors\#humidity % (1hr avg) ald
4 4 10 Temperature Temp °C 100.0 0.0 2 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-monitoring/meteorology-factors\#temperature deg C (1hr avg) ald
5 5 27 Rainfall Rainfall mm 0.0 0.0 2 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-monitoring/meteorology-factors\#rainfall mm (1hr total) ald
6 6 16 Nitrogen dioxide NO₂ ppm 0.08 0.08 1 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/nitrogen-oxides ppm (1hr avg) aru
7 7 3 Ozone O₃ ppm 0.1 0.065 1 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/ozone ppm (8hr avg) aru
8 8 18 Particle PM10 PM10 µg/m³ 100.0 50.0 1 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-monitoring/trend-graphs\#b µg/m³ (24hr avg) aru
9 21 6 Visibility Bsp Mm⁻¹ 235.0 235.0 1 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-monitoring/trend-graphs\#a Mm⁻¹ (1hr avg) ayr
10 30 13 Solar radiation Rad W/m² 0.0 0.0 2 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-monitoring/meteorology-factors\#solar W/m² (1hr avg) ayr1
11 32 7 Sulfur dioxide SO₂ ppm 0.1 0.1 1 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/sulfur-dioxide ppm (1hr avg) bar
12 42 160 Hydrogen sulfide (30min) H₂S ppb 5.0 108.0 6 https://www\.qld\.gov\.au/environment/pollution/monitoring/air/air-programs/cleanaway-new-chum-odour-issues ppb (30min avg) bda
13 99 8 Carbon monoxide CO ppm 0.0 9.0 1 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/carbon-monoxide ppm (8hr avg) boy
14 124 47 Particles TSP TSP µg/m³ 250.0 80.0 1 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/samplers µg/m³ (24hr avg) can
15 168 20 Benzene Benz ppb 0.0 250.0 3 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/toxics\#benzene ppb (24hr avg) cgm
16 169 21 Toluene Tol ppb 0.0 1000.0 3 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/toxics\#toluene ppb (24hr avg) cgm
17 170 22 Xylene Xyl ppb 0.0 250.0 3 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/toxics\#xylene ppb (24hr avg) cgm
18 171 23 Formaldehyde Formald ppb 0.0 40.0 3 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/toxics\#formaldehyde ppb (24hr avg) cgm
19 538 52 Lead Pb µg/m³ 0.0 2.0 4 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/metals\#lead µg/m³ (24hr avg) oai
20 539 53 Arsenic As µg/m³ 0.0 0.3 4 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/metals\#arsenic µg/m³ (24hr avg) oai
21 540 54 Cadmium Cd µg/m³ 0.0 2.0 4 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/metals\#cadmium µg/m³ (24hr avg) oai
22 541 55 Copper Cu µg/m³ 0.0 50.0 4 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/metals\#copper µg/m³ (24hr avg) oai
23 542 57 Zinc Zn µg/m³ 0.0 120.0 4 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/metals\#zinc µg/m³ (24hr avg) oai
24 543 41 Nickel Ni µg/m³ 0.0 0.12 4 https://www\.qld\.gov\.au/environment/pollution/monitoring/air-pollution/metals/\#nickel µg/m³ (24hr avg) oai
majesticio commented 1 year ago

It looks like pm10 and pm25 are reported as 24 hour averages, and only so2 and no2 are 1 hour averages. co2 and o3 are 8 hour averages

majesticio commented 1 year ago

It looks like we are already pulling from this source as xml https://apps.des.qld.gov.au/air-quality/xml/feed.php?category=1&region=ALL. I could try to troubleshoot, or it might be better to just redo the adapter using the json data instead of xml

russbiggs commented 1 year ago

Does this explain the spotty coverage though? and does the json endpoint have the "missing" site in question, Proserpine, while xml does not?

majesticio commented 1 year ago

I am not sure about the coverage, the xml is missing Proserpine though (Proserpine is included in the json). It would probably be better to rewrite the adapter

majesticio commented 1 year ago

I am getting a lot of timeouts, both from the API and the xml endpoints. I am guessing this is why the coverage is spotty. Hopefully we can get special access somehow, their public facing server seems to have some traffic issues