search

edgi-govdata-archiving / ECHO-Cross-Program

Jupyter Notebooks for ECHO that use data from multiple EPA programs
https://colab.research.google.com/github/edgi-govdata-archiving/ECHO-Cross-Program/blob/master/ECHO-Cross-Programs.ipynb
GNU General Public License v3.0
8 stars 5 forks source link

Expand the top violators lists and graphs in #5 to include SDWA, TRI, GHG #150

Open shansen5 opened 2 months ago

shansen5 commented 2 months ago

Top violators for CAA, CWA and RCRA are identified and graphed. Add graphs for SDWA, TRI, GHG. The lists of top violators can be used to pre-populate the selection of facilities later in #11. SDWA, TRI, GHG do not use the same identifiers of violations that CAA, CWA, RCRA do. The ECHO_modules utilities.py will need to be augmented to report the top violators for these new programs. Possible fields to use: SDWA - SDWA_COMPLIANCE_STATUS (Serious violator, Violation identified, Unknown, No Violation Identified - can be mapped into the same results as CAA, etc.) TRI - TRI_RELEASES_TRANSFERS (Total pounds per year released) GHG - GHG_CO2_RELEASES (Total facility emissions in metric tons CO2e from the most recent reporting year)

ericnost commented 2 months ago

I really like this idea. The trickiest thing is that TRI releases may all be in pounds (I think), but a small amount of lead may be more important to know about than a heavy amount of a less toxic chemical. Not much we can do about that at this point, except another metric would simply be: Total number of substances reported.