- Water Treatment Projects
- Two Raw Datasets: http://apdb.tbeptech.org
- Descriptions, names, location
- dplyr: combine dataset (left_join), subset (filter) to subbasins of interest, find WT projects not listed as complete for further investigation (anti-join)
# A tibble: 5 x 19
HeaderID Project_Name Bay_Segment
<int> <chr> <chr>
1 8 Delany Creek Wetland Restoration Project Hillsborough Bay
2 10 Cone Ranch Restoration Project Hillsborough Bay
3 11 29th or 30th Street Outfall/ Mckay Bay Hillsborough Bay
4 14 Palma Ceia Area Stormwater Pond Hillsborough Bay
5 15 North Tampa Pond Enlargements Hillsborough Bay
# ... with 16 more variables: Lead_Entity <chr>, Completion_Date <int>,
# TP_Reduction_lbs_yr <dbl>, TN_Reduction_lbs_yr <dbl>,
# TSS_Reduction_lbs_yr <int>, ProjectName <chr>,
# OngoingInitiation <int>, DiscontinuedDate <int>, CompletionDate <int>,
# ActualProjectCost <chr>, FundingSource <chr>,
# ProjectDescriptionText <chr>, NonPointProject <int>,
# PointProject <int>, ProjectLatitude <dbl>, ProjectLongitude <dbl>