Standardize ISBI Data Number 2

[loriabendroth]

@giorgichi, can you standardize a new data set for ISBI (https://drive.google.com/drive/u/0/folders/1xDqvrgsXy7z45wJnvtRCYEnStjRQh7Qx). This is complementary to another so want to use same headers and variables as possible.

Tasks include:

• [x] Rename column headers to match these from DN1 as possible. For those that don't exist, put in red font and we will come back later. https://docs.google.com/spreadsheets/d/1LyHN7hcPiNWjD6Ljj9Me1oCDIfMmeugkkjSApaKwY-c/edit#gid=607235473

• [x] Add columns for watershed and contract number as in DN1 and populate based on the town/county information.

• [x] Add yes/no column if entry is not within our priority watersheds so we can filter out later.

• [x] Add DN2 to the data dictionary. https://drive.google.com/drive/u/0/folders/1rUW1NjYvmIO9ZiPCLCflCc-6rbQWWtzs

Additional standardizing within some of the columns will be done in the future. We will also need to cross-check this data for those not reported within DN1 by water coordinators so we can have a true total number of events held.

[giorgichi]

Add columns for watershed and contract number as in DN1 and populate based on the town/county information. Add yes/no column if entry is not within our priority watersheds so we can filter out later.

I am not sure if it is generally accurate to map events with the watersheds. This should be clarified with Lori and Jamie.

[giorgichi]

Corrected and partially standardized location names:

• some cities were spelled incorrectly, while few were entered with different format (e.g. Ames, IA vs Ames, or Mt. Pleasant vs Mount Pleasant, etc.)

[loriabendroth]

@giorgichi The events will be allocated to a particular watershed so even if participants come from a larger area, we will apply it to one watershed only. Is that what you are getting at with your comment?

[loriabendroth]

For town names, we need to follow some standard across all sheets. Can you bring in a standard and cross-check against what we have here?
Here is list of city names for Iowa: https://gist.github.com/Jonathonbyrd/536074 Or from Census: https://www.census.gov/data/tables/time-series/demo/popest/2010s-total-cities-and-towns.html

[loriabendroth]

Having lat/long with cities is needed at some point also. https://github.com/kelvins/US-Cities-Database

[giorgichi]

@giorgichi The events will be allocated to a particular watershed so even if participants come from a larger area, we will apply it to one watershed only. Is that what you are getting at with your comment?

@loriabendroth - I should have stated my question clearer. What I wanted to say is - if a location (city/town) is not within the boundaries of the watershed, does it automatically mean that it is not related to that watershed (even if it is close to the watershed)?

[loriabendroth]

Got it! I think we have to be very strict in this sense otherwise it becomes a slippery slope of what to include. If it is not within the bounds of the watershed, we will NOT include it now.

[loriabendroth]

Used 25 mile centroid approach.