Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Get top violators for SDWA, GHG, TRI programs #75

Open
shansen5 opened this issue Apr 6, 2024 · 1 comment
Open

Get top violators for SDWA, GHG, TRI programs #75

shansen5 opened this issue Apr 6, 2024 · 1 comment
Assignees

Comments

@shansen5
Copy link
Collaborator

shansen5 commented Apr 6, 2024

In utilities.py, enhance get_top_violators() and chart_top_violators() to handle SDWA, GHG, TRI programs.

SDWA, TRI, GHG do not use the same identifiers of violations that CAA, CWA, RCRA do.
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)

@shansen5 shansen5 self-assigned this Apr 6, 2024
@ericnost ericnost moved this to Todo in ECHO_modules Jul 19, 2024
@ericnost
Copy link
Member

I think this is done (except SDWA). See cross-programs:

    df_violators['GHG'] = get_tri_ghg_violators(df_active, 'GHG_CO2_RELEASES',  20)
    display(chart_tri_ghg_violators(df_violators['GHG'], field='GHG_CO2_RELEASES',
            title='Greenhouse Gas Emissions in Metric Tons (most recent year)',
            xlabel='Emissions in Metric Tons'))

    df_violators['TRI'] = get_tri_ghg_violators(df_active, 'TRI_RELEASES_TRANSFERS', 20)
    display(chart_tri_ghg_violators(df_violators['TRI'], field='TRI_RELEASES_TRANSFERS',
            title='Total pounds per year released for Air Emissions, Surface Water Discharges, Underground Injections, Releases to Land and Off-Site Transfers',
            xlabel='Total pounds per year'))

@ericnost ericnost moved this from Todo to In Progress in ECHO_modules Aug 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: In Progress
Development

No branches or pull requests

2 participants