chrislopez28 / mass-emissions-viewer

Data Viewer for Mass Emissions Station Monitoring

Mass Emissions Data Viewer

Data Viewer for water quality monitoring data collected at various "Mass Emissions Stations" in Los Angeles County. This data gives an idea of the water quality during wet weather and dry weather conditions in Ballona Creek, Malibu Creek, Los Angeles River, Coyote Creek, San Gabriel River, Dominguez Channel, and Santa Clara River. Information on these stations can be found on the Los Angeles County Department of Public Works website.

mass-emissions-viewer's Issues

Clean 1995-2015 ME data

Clean and format 1995-2015 mass emissions station data from the following files:

Table A_1995 to 1999_all constituents.xls
Table B_2000 to 2005 Data_all constituents.xlsx
Table C_2005 to 2006_all constituents.xls
Table D_2006 to present_all except metals.xlsx
Table E_2006 to present_Metals only.xlsx

Upload app on Shiny server

Add reactive table functionality

Incorporate 2015-2019 ME data

Pictures of Monitoring Stations

Obtain pictures of each mass emission station and put in /data subfolder.

These pictures along with other station information will pop up when a User selects a monitoring station on the map.

Add reactive plotting functionality

Determine formatting for cleaned monitoring data

We'll have to choose what columns to include in the cleaned monitoring data that will get loaded in the viewer. Some things to consider:

• What columns would various users be most interested in?
• What columns are unnecessary for most users (and may obfuscate reading information in the app)?
• What columns do we have across the different datasets?
• Should we have a limited set of columns viewable on the app and an expanded set of columns that the user can download if they choose to export the data?
• Should we add column(s) that give information on the source data.

Add download CSV functionality

Incorporate data for mass emission stations in Ventura County and the Los Cerritos Channel