This is a Code for Boston project that is trying to predict health-based drinking water violations using the Environmental Protection Agency's Safe Drinking Water Information System.

We will explore other datasets from the EPA, including the Toxic Release Inventory database, the Superfund Enterprise Management System, the Environmental Radiation Monitoring database, and the Enforcement and Compliance History Outline.

We are using Python for the analysis and are in the early stages.

Find us on our Slack channel #water

• Log files should note tables which where not collected at all for one reason or another so they can be explored further
• there should be one log file for all tables OR one log file for each table, the current state is sub optimal
• we will have alot of tables now, can we make sure that the raw data is somehow being grouped into useful subsets
• how can we join and aggreate data so that we dont always have to navigate
• parallel-ize scripts so that general users could potentially pull scritps
• additional print out info to better understand were we are in the scripts

(instructions only tested on solus linux but should hold on other os') in the command line cd to the safe water directory run the command 'python3.6 -i swid-db-scraper.py' this will load the file and put you into a command prompt now run the following command: 'pull_envirofacts_data()'