search

npri-tools / npri-db

Scripts to access, copy, and create new views of NPRI, Stat Can, and other data
GNU General Public License v3.0
0 stars 0 forks source link

finish fleshing out main pollutant summaries for Facilities/Places tables #2

Open ericnost opened 1 month ago

ericnost commented 1 month ago

May need to focus on criteria air contaminants first. But also need to come up with a range of timespans (for Facilities) and distances (for Places)

This is something with fields like: pollutant X most recent year pollutant X past 3 years pollutant X past 10 years pollutant X past 20 years pollutant X cumulative pollutant Y ....

(separately, for Facilities, also a measure like "how many other facilities within 1, 5, 10km")

....

ericnost commented 1 month ago

pollutant X most recent year pollutant X past 3 years pollutant X past 10 years pollutant X past 20 years pollutant X cumulative pollutant Y ....

Done for current year, past 5, past 15, and total for criteria air contaminants. May have to switch to Pandas to do for all pollutants.

ericnost commented 1 month ago

Which DAs does each facility buffer (1,3,5 km) contain? (currently only doing 1km) what da is each facility contained by? how many other facilities within 1, 3, 5km? (doing 1km)