Skip to content
Snippets Groups Projects
02_NHD_navigate.Rmd 25.5 KiB
Newer Older
  • Learn to ignore specific revisions
  • editor_options:
      chunk_output_type: console
    
    This notebook Generate Segments and POIS from POI data sources and builds
    
    a minimally-sufficient stream network connecting all POis, as well as generating first-cut of
    national segment network.
    
    ```{r setup_rmd, echo=FALSE, cache=FALSE}
    knitr::opts_chunk$set(
      collapse = TRUE,
      comment = "#>",
      fig.width=6, 
      fig.height=4,
      cache=FALSE)
    
    # Load custom functions
    
    source("R/hyrefactor_funs.R")
    
    # Load Configuration of environment
    source("R/config.R")
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    gages <- read_sf("cache/Gages_info.gpkg", "Gages")
    
    nc <- RNetCDF::open.nc(data_paths$nwm_network)
    
    nwm_gages <- data.frame(
      comid = RNetCDF::var.get.nc(nc, "link"), 
      gage_id = RNetCDF::var.get.nc(nc, "gages")) %>%
      mutate(gage_id = gsub(" ", "", gage_id)) %>%
      mutate(gage_id = ifelse(gage_id == "", NA, gage_id))
    
    RNetCDF::close.nc(nc)
    
    
    # need some extra attributes
    
    atts <- readRDS(file.path(data_paths$nhdplus_dir, "nhdplus_flowline_attributes.rds"))
    
    Bock, Andy's avatar
    Bock, Andy committed
    
    
    ```{r huc12 POIs}
    
    Bock, Andy's avatar
    Bock, Andy committed
    #  Derive or load HUC12 POIs
    
    if(needs_layer(temp_gpkg, nav_poi_layer)) {
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
       nhd <- read_sf(nav_gpkg, nhd_flowline)
    
       try(nhd <- select(nhd, -c(minNet, WB, struct_POI, struct_Net, POI_ID)), silent = TRUE)
    
    Bock, Andy's avatar
    Bock, Andy committed
      # HUC02 includes some 
    
    Bock, Andy's avatar
    Bock, Andy committed
      if(vpu == "02"){
    
    Bock, Andy's avatar
    Bock, Andy committed
        grep_exp <-"^02|^04"
    
    Bock, Andy's avatar
    Bock, Andy committed
      } else if (vpu == "08") {
    
    Bock, Andy's avatar
    Bock, Andy committed
        grep_exp <- "^03|^08"
      } else {
    
    Bock, Andy's avatar
    Bock, Andy committed
        grep_exp <- paste0("^", substr(vpu, start = 1, stop = 2))
    
    Bock, Andy's avatar
    Bock, Andy committed
      }
      
    
    Bock, Andy's avatar
    Bock, Andy committed
      # Join HUC12 outlets with NHD
    
      HUC12_COMIDs <- read_sf(data_paths$hu12_points_path, "hu_points") %>% 
    
    Bock, Andy's avatar
    Bock, Andy committed
        filter(grepl(grep_exp, .data$HUC12)) %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        select(COMID, HUC12) %>%
    
        # Remove this when HUC12 outlets finished
        group_by(COMID) %>% 
    
    Bock, Andy's avatar
    Bock, Andy committed
        filter(row_number() == 1) %>%
        ungroup()
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    
    
      # Create POIs - some r05 HUC12 POIs not in R05 NHD
    
      huc12_POIs <- POI_creation(st_drop_geometry(HUC12_COMIDs), filter(nhd, poi == 1), "HUC12")
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    
    
      # Write out geopackage layer representing POIs for given theme
    
      write_sf(huc12_POIs, temp_gpkg, nav_poi_layer)
    
      # Load HUC12 POIs as the tmpPOIs if they already exist
    
      tmp_POIs <- read_sf(temp_gpkg, nav_poi_layer) 
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      nhd <- read_sf(nav_gpkg, nhd_flowline)
    
    
    mapview(filter(tmp_POIs, Type_HUC12 != ""), layer.name = "HUC12 POIs", col.regions = "red") 
    
    ```{r streamgage POIs}
    
    if(all(is.na(tmp_POIs$Type_Gages))) { 
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    
    
      # Previously identified streamgages within Gage_Selection.Rmd
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      streamgages_VPU <- gages %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        rename(COMID = comid) %>%
    
        filter(COMID %in% nhd$COMID) %>%
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
        st_drop_geometry() %>%
    
        switchDiv(., nhd) 
      
      streamgages <- streamgages_VPU %>% 
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
        group_by(COMID) %>%
    
        # If multiple gages per COMID, pick one with highest rank as rep POI_ID
    
    Bock, Andy's avatar
    Bock, Andy committed
        filter(gage_score == max(gage_score), !is.na(drain_area)) %>%
    
        ungroup() %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        select(COMID, site_no)
    
      # Derive GAGE POIs; use NHD as we've alredy filtered by NWIS DA in the Gage selection step
    
      tmp_POIs <- POI_creation(streamgages, nhd, "Gages") %>%
    
        addType(., tmp_POIs, "Gages")
    
    Bock, Andy's avatar
    Bock, Andy committed
      
      # As a fail-safe, write out list of gages not assigned a POI
    
    Bock, Andy's avatar
    Bock, Andy committed
      if(nrow(filter(streamgages_VPU, !site_no %in% tmp_POIs$Type_Gages)) > 0) {
        write_sf(filter(streamgages_VPU, !site_no %in% tmp_POIs$Type_Gages),
    
    Bock, Andy's avatar
    Bock, Andy committed
        
        # Start documenting gages that are dropped out; these gages have no mean daily Q
        gage_document(filter(streamgages_VPU, !site_no %in% tmp_POIs$Type_Gages) %>%
                        select(site_no),
    
    Bock, Andy's avatar
    Bock, Andy committed
                  "Gages_info", paste0("VPU ", vpu, "; low gage score"))
    
    Bock, Andy's avatar
    Bock, Andy committed
        
    
      # Write out geopackage layer representing POIs for given theme
    
      write_sf(tmp_POIs, temp_gpkg, nav_poi_layer)
    
    Bock, Andy's avatar
    Bock, Andy committed
    } else {
    
      tmp_POIs <- read_sf(temp_gpkg, nav_poi_layer)
    
    Bock, Andy's avatar
    Bock, Andy committed
    mapview(filter(tmp_POIs, !is.na(Type_Gages)), layer.name = "Streamgage POIs", col.regions = "blue") 
    
    ```{r TE POIs}
    
    if(all(is.na(tmp_POIs$Type_TE))) {
    
    Bock, Andy's avatar
    Bock, Andy committed
      if(vpu == "08"){
    
    Bock, Andy's avatar
    Bock, Andy committed
        nhd$VPUID <- "08"
      } else {
        nhd$VPUID <- substr(nhd$RPUID, 1, 2)
      }
      
    
      # Read in Thermoelectric shapefile
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      TE_COMIDs <- read_sf(data_paths$TE_points_path, "2015_TE_Model_Estimates_lat.long_COMIDs") %>%
        mutate(COMID = as.integer(COMID)) %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        inner_join(., select(st_drop_geometry(nhd), COMID, VPUID), by = "COMID") %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        filter(grepl(paste0("^", substr(vpu, 1, 2), ".*"), .data$VPUID), COMID > 0) %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        switchDiv(., nhd) %>%
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
        group_by(COMID) %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        summarize(EIA_PLANT = paste0(unique(EIA_PLANT_), collapse = " "), count = n()) %>%
        ungroup()
    
    Bock, Andy's avatar
    Bock, Andy committed
      
       # Derive TE POIs
      tmp_POIs <- POI_creation(st_drop_geometry(TE_COMIDs), filter(nhd, dend == 1), "TE") %>%
    
        addType(., tmp_POIs, "TE")
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    
    
    Bock, Andy's avatar
    Bock, Andy committed
      # As a fail-safe, write out list of TE plants not assigned a POI
      if(nrow(filter(TE_COMIDs, !COMID %in% tmp_POIs$COMID)) > 0) {
        write_sf(filter(TE_COMIDs, !COMID %in% tmp_POIs$COMID),
    
      # Write out geopackage layer representing POIs for given theme
    
      write_sf(tmp_POIs, temp_gpkg, nav_poi_layer)
    
    } else {
      # Load TE POIs if they already exist
    
      tmp_POIs <- read_sf(temp_gpkg, nav_poi_layer)
    
    
    mapview(filter(tmp_POIs, Type_TE != ""), layer.name = "TE Plant POIs", col.regions = "blue") 
    
    Bock, Andy's avatar
    Bock, Andy committed
    ```{r Terminal POIs}
    #  Derive or load Terminal POIs ----------------------
    
    Bock, Andy's avatar
    Bock, Andy committed
    if(all(is.na(tmp_POIs$Type_Term))) {
    
    Bock, Andy's avatar
    Bock, Andy committed
      
      # Terminal POIs on levelpaths with upstream POIs
      term_paths <- filter(st_drop_geometry(nhd), Hydroseq %in% filter(nhd, COMID %in% tmp_POIs$COMID)$TerminalPa)
      
      # Non-POI levelpath terminal pois, but meet size criteria
      terminal_POIs <- st_drop_geometry(nhd) %>%
        filter(Hydroseq == TerminalPa | (toCOMID == 0 | is.na(toCOMID) | !toCOMID %in% COMID)) %>%
        filter(!COMID %in% term_paths$COMID, TotDASqKM >= 20) %>%
        bind_rows(term_paths) %>%
        # Use level path identifier as Type ID
        select(COMID, LevelPathI)
    
      tmp_POIs <- POI_creation(terminal_POIs, nhd, "Term") %>%
        addType(., tmp_POIs, "Term")
    
    
      write_sf(tmp_POIs, temp_gpkg, nav_poi_layer)
    
    Bock, Andy's avatar
    Bock, Andy committed
    } else {
    
      tmp_POIs <- read_sf(temp_gpkg, nav_poi_layer)
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      nhd <- read_sf(nav_gpkg, nhd_flowline)
    
    Bock, Andy's avatar
    Bock, Andy committed
    }
    
    
    mapview(filter(tmp_POIs, !is.na(Type_Term)), layer.name = "Terminal POIs", col.regions = "blue") 
    
    Bock, Andy's avatar
    Bock, Andy committed
    ```
    
    
    Bock, Andy's avatar
    Bock, Andy committed
    ```{r waterbody outlet POIs}
    #  Derive or load Waterbody POIs ----------------------
    if(all(is.na(tmp_POIs$Type_WBOut))) {
      
      # Waterbodies sourced from NHD waterbody layer for entire VPU
      WBs_VPU_all <- filter(readRDS("data/NHDPlusNationalData/nhdplus_waterbodies.rds"), 
                            COMID %in% nhd$WBAREACOMI) %>%
        mutate(FTYPE = as.character(FTYPE)) %>%
        mutate(source = "NHDv2WB")
    
      # Waterbody list that strictly meet the size criteria
      wb_lst <- st_drop_geometry(WBs_VPU_all) %>%
        dplyr::filter(FTYPE %in% c("LakePond", "Reservoir") & AREASQKM >= (min_da_km/2)) %>%
        dplyr::select(COMID)
    
      if (file.exists(data_paths$resops_NID_CW)){
        # ResOpsUS locations in the VPU waterbody set
        resops_wb_df <- read.csv(data_paths$resops_NID_CW) %>%
          dplyr::filter(WBAREACOMI %in% WBs_VPU_all$COMID) %>%
          dplyr::select(DAM_ID, DAM_NAME, COMID = WBAREACOMI, FlowLcomid) %>%
          distinct()
    
        # Add ResOPsUS locations to waterbody list 
        if(nrow(resops_wb_df) > 0){
          wb_lst <- rbind(wb_lst, select(resops_wb_df, COMID)) %>%
            distinct()
        }
      }
      
      # Waterbodies that meet the size criteria and/or are in ResOpsUS datasets
      WBs_VPU <- WBs_VPU_all %>%
        dplyr::filter(COMID %in% wb_lst$COMID) 
      
      # Attribute flowlines that are in waterbodies
      nhd <- mutate(nhd, WB = ifelse(WBAREACOMI > 0 & WBAREACOMI %in% WBs_VPU$COMID, 1, 0))
      
      # Create waterbody outlet POIs for waterbodies that are in NHDv2 waterbody set
      wbout_COMIDs <- filter(nhd, dend == 1 & WB == 1) %>%
        group_by(WBAREACOMI) %>%
        slice(which.min(Hydroseq)) %>%
        switchDiv(., nhd) %>%
        select(COMID, WBAREACOMI, LevelPathI) 
      
      # Get NHDArea and HI-Res waterbodies for ResOpsUS locaitons
      WBs_VPU_areaHR <- HR_Area_coms(nhd, WBs_VPU, data_paths)
      # If the return is not NA
    
      if(inherits(WBs_VPU_areaHR, "list")){
    
    Bock, Andy's avatar
    Bock, Andy committed
        # Attribute flowlines that intersect NHDARea and/or NHD HR waterbodies with 
        #           waterbody COMIDs
        nhd <- nhd %>%
          left_join(select(WBs_VPU_areaHR$wb_table, comid, wb_comid), by = c("COMID" = "comid")) %>%
          mutate(WBAREACOMI = ifelse(!is.na(wb_comid), wb_comid, WBAREACOMI)) %>%
          select(-wb_comid)
        
        # Full table of HR and NHDArea waterbodies and their flowlines
        # Subset down to specific outlets
        resops_wb_hr <- WBs_VPU_areaHR$wb_table %>%
          filter(!wb_comid %in% WBs_VPU$COMID, !is.na(outlet)) %>%
          rename(WBAREACOMI = wb_comid) %>%
          select(DAM_ID, DAM_NAME, COMID = WBAREACOMI, FlowLcomid = comid) %>%
          rbind(resops_wb_df)
        
        # NHD flowlines within the HR/NHDArea waterbodies
        nhd_WBs <- filter(nhd, WBAREACOMI %in% WBs_VPU_areaHR$wb_table$wb_comid)
        if(nrow(nhd_WBs) > 0){
          # Create outlet events for splitting HR and NHDArea waterbodies
          wb_outlet_events <- WB_event(WBs_VPU_areaHR, nhd_WBs, "outlet")
          
          # Create Navigate POIs for the NHDarea and HR waterbodies
          wbout_COMIDs <- rbind(select(wbout_COMIDs, COMID, WBAREACOMI),
                          select(wb_outlet_events, COMID, WBAREACOMI))
        }
        
    
        WBs_VPU_areaHR$wb <- nhdplusTools::st_compatibalize(
          WBs_VPU_areaHR$wb, WBs_VPU)
        
    
    Bock, Andy's avatar
    Bock, Andy committed
        # Append NHDArea and NHDHR waterbodies to waterbody layer
        WBs_VPU <- data.table::rbindlist(list(WBs_VPU, WBs_VPU_areaHR$wb), fill = TRUE) %>%
    
          st_as_sf()
        
        st_geometry(WBs_VPU) <- st_make_valid(st_geometry(WBs_VPU))
    
    Bock, Andy's avatar
    Bock, Andy committed
      }
        
      # Write out waterbodies
      write_sf(WBs_VPU, nav_gpkg, WBs_layer)
       
      tmp_POIs <- POI_creation(wbout_COMIDs, nhd, "WBOut") %>%
        addType(., tmp_POIs, "WBOut")
      
      # Write specific ResOpsUS data to a separate sheet
      if(nrow(wb_lst) > 0){
        
        resops_POIs_df <- st_drop_geometry(tmp_POIs) %>%
          dplyr::select(COMID, Type_WBOut) %>%
          dplyr::filter(!is.na(Type_WBOut)) %>%
          dplyr::inner_join(select(resops_wb_df, -FlowLcomid), by = c("Type_WBOut" = "COMID")) 
        
        write.csv(resops_POIs_df, file.path("data/reservoir_Data", paste0("resops_POIs_",vpu,".csv")))
      }
        
      write_sf(nhd, nav_gpkg, nhd_flowline)
    
      write_sf(tmp_POIs, temp_gpkg, nav_poi_layer)
    
    Bock, Andy's avatar
    Bock, Andy committed
    } else {
    
      tmp_POIs <- read_sf(temp_gpkg, nav_poi_layer)
    
    Bock, Andy's avatar
    Bock, Andy committed
      nhd <- read_sf(nav_gpkg, nhd_flowline)
      WBs_VPU <- read_sf(nav_gpkg, WBs_layer)
      resops_POIs_df <- read.csv(file.path("data/reservoir_Data", paste0("resops_POIs_",vpu,".csv")))
    }
    
    mapview(filter(tmp_POIs, !is.na(Type_WBOut)), layer.name = "Waterbody outlet POIs", col.regions = "red")
    ```
    
    
    ```{r Confluence POIs}
    
    # Derive POIs at confluences where they are absent ----------------------
    
    if(all(is.na(tmp_POIs$Type_Conf))) {
    
      # Navigate upstream from each POI and determine minimally-sufficient network between current POI sets
      up_net <- unique(unlist(lapply(unique(tmp_POIs$COMID), NetworkNav, nhd))) 
      finalNet <- unique(NetworkConnection(up_net, st_drop_geometry(nhd))) 
    
      # Subset NHDPlusV2 flowlines to navigation results and write to shapefile
      nhd <- mutate(nhd, minNet = ifelse(COMID %in% finalNet, 1, 0))
      
    
      # Create new confluence POIs
    
      conf_COMIDs <- st_drop_geometry(filter(nhd, minNet == 1)) %>%
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
        # Downstream hydrosequence of 0 indicates
    
    Bock, Andy's avatar
    Bock, Andy committed
        #   the flowline is terminating or
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
        #   leaving the domain, so they
    
    Bock, Andy's avatar
    Bock, Andy committed
        #   are excluded from this process
    
    Bock, Andy's avatar
    Bock, Andy committed
        filter(DnHydroseq > 0) %>%
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
        group_by(DnHydroseq) %>%
        filter(n()> 1) %>%
        mutate(Type_Conf = LevelPathI) %>%
    
        select(COMID, Type_Conf)
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    
    
    Bock, Andy's avatar
    Bock, Andy committed
      tmp_POIs <- POI_creation(conf_COMIDs, filter(nhd, minNet == 1), "Conf") %>%
    
        addType(., tmp_POIs, "Conf")
      
    
    Bock, Andy's avatar
    Bock, Andy committed
      write_sf(nhd, temp_gpkg, nhd_flowline)
    
      write_sf(tmp_POIs, temp_gpkg, nav_poi_layer)
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      nhd <- read_sf(nav_gpkg, nhd_flowline)
    
      tmp_POIs <- read_sf(temp_gpkg, nav_poi_layer)
    
    
    mapview(filter(tmp_POIs, !is.na(Type_Conf)), layer.name = "Confluence POIs", col.regions = "blue") 
    
    ```{r NID POIs}
    
    #  Derive or load NID POIs ----------------------
    
    if(all(is.na(tmp_POIs$Type_NID))) {
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    
    
      # Read in NID shapefile
    
    Bock, Andy's avatar
    Bock, Andy committed
      NID_COMIDs <- read.csv(file.path(data_paths$NID_points_path, "NID_attributes_20170612.txt"), 
                             stringsAsFactors = FALSE) %>%
    
        filter(ONNHDPLUS == 1, FlowLcomid %in% filter(nhd, dend ==1)$COMID) %>%
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
        switchDiv(., nhd) %>%
    
        group_by(FlowLcomid) %>%
        summarize(Type_NID = paste0(unique(NIDID), collapse = " ")) 
      
    
      tmp_POIs <- POI_creation(NID_COMIDs, filter(nhd, dend ==1), "NID") %>%
        addType(., tmp_POIs, "NID", bind = FALSE)
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    
    
      # Write out geopackage layer representing POIs for given theme
    
      write_sf(tmp_POIs, temp_gpkg, nav_poi_layer)
    
    } else {
      # Load NID POIs if they already exist
    
      tmp_POIs <- read_sf(temp_gpkg, nav_poi_layer)
    
    
    mapview(filter(tmp_POIs, Type_NID != ""), layer.name = "NID POIs", col.regions = "blue") 
    
    Bock, Andy's avatar
    Bock, Andy committed
    ```{r waterbody inlet POIs}
    
    #  Derive or load Waterbody POIs ----------------------
    
    Bock, Andy's avatar
    Bock, Andy committed
    if(all(is.na(tmp_POIs$Type_WBIn))) {
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    
    
    Bock, Andy's avatar
    Bock, Andy committed
      # Get waterbody outlet POIs
      wbout_COMIDs <- filter(tmp_POIs, !is.na(Type_WBOut)) 
    
      # Create waterbody inlet POIs
    
    Bock, Andy's avatar
    Bock, Andy committed
      wbin_COMIDs <- filter(nhd, WB == 0, 
    
                            DnHydroseq %in% filter(nhd, WB == 1)$Hydroseq) %>%
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
        select(-WBAREACOMI) %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        switchDiv(., nhd) %>%
    
        inner_join(st_drop_geometry(filter(nhd, minNet == 1)) %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
                     select(Hydroseq, WBAREACOMI), by = c("DnHydroseq" = "Hydroseq")) %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        select(COMID, WBAREACOMI, minNet) %>%
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
        group_by(COMID) %>%
    
    Bock, Andy's avatar
    Bock, Andy committed
        # Ensure the inlets are on the network defined by confluence POIs
        filter(minNet == 1) 
    
    Bock, Andy's avatar
    Bock, Andy committed
      # Headwater Waterbodies that may need the network extended through the inlet
      need_wbin <- st_drop_geometry(filter(WBs_VPU, source == "NHDv2WB")) %>%
        dplyr::select(COMID)%>%
        dplyr::filter(!COMID %in% wbin_COMIDs$WBAREACOMI)
    
    Bock, Andy's avatar
    Bock, Andy committed
      if(nrow(need_wbin)>0){
        
        nhd_inlet <- mutate(nhd, WB = ifelse(WBAREACOMI > 0 & WBAREACOMI %in% need_wbin$COMID, 1, 0))
        
        missing_wbin_COMIDs <- filter(nhd_inlet, WB == 0,
                              DnHydroseq %in% filter(nhd_inlet, WB == 1)$Hydroseq) %>%
          select(-WBAREACOMI) %>%
          switchDiv(., nhd_inlet) %>%
          inner_join(st_drop_geometry(filter(nhd_inlet, minNet == 1)) %>%
                       select(Hydroseq, WBAREACOMI), by = c("DnHydroseq" = "Hydroseq")) %>%
          select(COMID, WBAREACOMI) %>%
          group_by(COMID) %>%
          filter(row_number() == 1) %>%
          ungroup()
        
        missing_wbin_COMIDs <- missing_wbin_COMIDs %>%
          left_join(select(st_drop_geometry(nhd_inlet), COMID, TotDASqKM, minNet), by = c("COMID")) %>%
          group_by(COMID) %>% 
          slice(which.max(TotDASqKM))%>%
          select(-TotDASqKM)
        
        if(nrow(missing_wbin_COMIDs) > 0){
          wbin_COMIDs <- rbind(wbin_COMIDs, missing_wbin_COMIDs)
        }
    
    Santiago, Marilyn's avatar
    Santiago, Marilyn committed
      }
    
    Bock, Andy's avatar
    Bock, Andy committed
      
      # Get NHDArea and HR waterbodies 
      WBs_VPU_areaHR <- HR_Area_coms(nhd, WBs_VPU, data_paths)
      # Get flowlines that intersect waterbodies and are on the minimal network 
      #     (outlets should already be defined)
      nhd_WBs <- filter(nhd, minNet == 1 & WBAREACOMI %in% WBs_VPU_areaHR$wb_table$wb_comid)
      if(nrow(nhd_WBs) > 0){
    
    Bock, Andy's avatar
    Bock, Andy committed
        # Get the outlet events again
        wb_outlet_events <- WB_event(WBs_VPU_areaHR, nhd_WBs, "outlet")
        
        # Drive the inlet events 
        nhd_inlet <- filter(nhd_WBs, !COMID %in% wb_outlet_events$COMID)
        if (nrow(nhd_inlet) > 0){
          # Get inlet events and bind with outlets
          wb_inlet_events <- WB_event(WBs_VPU_areaHR, nhd_inlet, "inlet")
          wb_events <- rbind(wb_inlet_events, wb_outlet_events)
          
          wbin_COMIDs <- rbind(select(wbin_COMIDs, COMID, WBAREACOMI),
                     filter(select(wb_inlet_events, COMID, WBAREACOMI)))
        } else {
          wb_events <- wb_outlet_events
        }
        # write out to geopackage
        write_sf(wb_events, nav_gpkg, WB_events_layer)
      }
      
      tmp_POIs <- POI_creation(filter(st_drop_geometry(wbin_COMIDs), !COMID %in% wbout_COMIDs$COMID), 
                               nhd, "WBIn") %>%
        addType(., tmp_POIs, "WBIn")
    
      write_sf(nhd, nav_gpkg, nhd_flowline)
      write_sf(tmp_POIs, nav_gpkg, nav_poi_layer)
    
    Bock, Andy's avatar
    Bock, Andy committed
      tmp_POIs <- read_sf(nav_gpkg, nav_poi_layer)
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      nhd <- read_sf(nav_gpkg, nhd_flowline)
    
    
    mapview(filter(tmp_POIs, !is.na(Type_WBIn)), layer.name = "Waterbody inlet POIs", col.regions = "blue") +
    
    Bock, Andy's avatar
    Bock, Andy committed
    mapview(filter(tmp_POIs, !is.na(Type_WBOut)), layer.name = "Waterbody outlet POIs", col.regions = "red") +
      mapview(wb_events) + mapview(WBs_VPU_areaHR$wb)
    
    ```
    
    
    This chunk breaks up potential aggregated segments where the elevation range of the are contributing to the segment exceeds 500-m
    ```{r Elevation Break POIs}
    
    Bock, Andy's avatar
    Bock, Andy committed
    # derive incremental segments from POIs
    inc_segs <- segment_increment(filter(nhd, minNet == 1), 
                                  filter(st_drop_geometry(nhd),
                                         COMID %in% tmp_POIs$COMID, COMID %in% filter(nhd, minNet == 1)$COMID)) %>%
      # bring over VAA data
      inner_join(select(atts, COMID, DnHydroseq, VA_MA, TOTMA, LENGTHKM, MAXELEVSMO, MINELEVSMO, WBAREACOMI, WBAreaType, FTYPE,
                        AreaSqKM, TotDASqKM), by = "COMID") 
    
    Bock, Andy's avatar
    Bock, Andy committed
    # Build dataframe for creation of points based on breaks
    elev_pois_split <- inc_segs %>%
      group_by(POI_ID) %>%
      # Get elevation info
      mutate(MAXELEVSMO = na_if(MAXELEVSMO, -9998), MINELEVSMO = na_if(MINELEVSMO, -9998), 
             elev_diff_seg = max(MAXELEVSMO) - min(MINELEVSMO)) %>%
      # Filter out to those incremental segments that need splitting above the defined elevation threshold
      filter((max(MAXELEVSMO) - min(MINELEVSMO)) > (elev_diff * 100)) %>%
      # Do not aggregate on fake lfowlines
      filter(AreaSqKM > 0, TotDASqKM > max_elev_TT_DA) %>% 
      # Order from upstream to downstream
      arrange(desc(Hydroseq)) %>%
      # Get attributes used for splitting
      # csum_length = cumulative length US to DS along segment, cumsum_elev = cumulative US to DS elev diff along segment
      # inc_elev = elevation range of each segment
      # iter = estimated number of times we'd need to split existing agg flowlines, or number of rows in set
      mutate(csum_length = cumsum(LENGTHKM),
             inc_elev = cumsum(MAXELEVSMO - MINELEVSMO),
             #nc_elev_diff = c(inc_elev[1], (inc_elev - lag(inc_elev))[-1]),
             iter = min(round(max(inc_elev) / (elev_diff * 100)), n()),
             elev_POI_ID = NA) %>%
      # Remove segments we can't break
      filter(iter > 0, n() > 1) %>%
      # Track original iteration number
      mutate(orig_iter = iter) %>%
      ungroup() 
    
    if(nrow(elev_pois_split) > 0) {
    
    Bock, Andy's avatar
    Bock, Andy committed
      
      # For reach iteration
      elev_POIs <- do.call("rbind", lapply(unique(elev_pois_split$POI_ID), split_elev, 
                                          elev_pois_split, elev_diff*100, max_elev_TT_DA)) %>%
        filter(!elev_POI_ID %in% tmp_POIs$COMID, COMID == elev_POI_ID) %>%
        mutate(Type_Elev = 1) %>%
        select(COMID, Type_Elev) %>%
        unique()
      
    
    Bock, Andy's avatar
    Bock, Andy committed
      if(nrow(elev_POIs) > 0){
        tmp_POIs <- POI_creation(select(elev_POIs, COMID, Type_Elev), nhd, "Elev") %>%
          addType(., tmp_POIs, "Elev")
      } 
      
    
    } else {
    
      
      tmp_POIs$Type_Elev <- rep(NA, nrow(tmp_POIs))
    
    
      write_sf(tmp_POIs, temp_gpkg, nav_poi_layer)
    
      tmp_POIs <- read_sf(temp_gpkg, nav_poi_layer) 
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      nhd <- read_sf(nav_gpkg, nhd_flowline)
    
    Bock, Andy's avatar
    Bock, Andy committed
    if(!all(is.na(tmp_POIs$Type_Elev)))
      mapview(filter(tmp_POIs, Type_Elev == 1), layer.name = "Elevation break POIs", col.regions = "blue") 
    
    ```{r Time of travel POIs}
    if(all(is.na(tmp_POIs$Type_Travel))) {
    
      
      # derive incremental segments from POIs
      inc_segs <- segment_increment(filter(nhd, minNet == 1), 
                                    filter(st_drop_geometry(nhd),
                                           COMID %in% tmp_POIs$COMID, COMID %in% filter(nhd, minNet == 1)$COMID)) %>%
        # bring over VAA data
        inner_join(select(atts, COMID, DnHydroseq, VA_MA, TOTMA, LENGTHKM, MAXELEVSMO, MINELEVSMO, WBAREACOMI, WBAreaType, FTYPE,
                          AreaSqKM, TotDASqKM), by = "COMID") 
    
      # TT POIs
      tt_pois_split <- inc_segs %>%
    
        # Should we substitute with a very small value
        mutate(VA_MA = ifelse(VA_MA < 0, NA, VA_MA)) %>%
        mutate(FL_tt_hrs = (LENGTHKM * 3280.84)/ VA_MA / 3600 ) %>%
        group_by(POI_ID) %>%
    
        filter(sum(FL_tt_hrs) > travt_diff, TotDASqKM > max_elev_TT_DA) %>%
    
        # Sort upstream to downsream
        arrange(desc(Hydroseq)) %>%
        # Get cumulative sums of median elevation
    
    Bock, Andy's avatar
    Bock, Andy committed
        mutate(csum_length = cumsum(LENGTHKM), 
               cumsum_tt = cumsum(FL_tt_hrs), 
    
               iter = min(round(sum(FL_tt_hrs) / travt_diff), n()),
               tt_POI_ID = NA) %>%
    
        # Only look to split segments based on travel time longer than 10 km
    
    Bock, Andy's avatar
    Bock, Andy committed
        #filter(sum(LENGTHKM) > (split_meters/1000)) %>%
        filter(iter > 0, n() > 1) %>%
        # Track original iteration number
        mutate(orig_iter = iter) %>%
    
        ungroup() 
    
    
      # For reach iteration
      tt_POIs <- do.call("rbind", lapply(unique(tt_pois_split$POI_ID), split_tt, 
                                          tt_pois_split, travt_diff, max_elev_TT_DA)) %>%
        filter(!tt_POI_ID %in% tmp_POIs$COMID, COMID == tt_POI_ID) %>%
        mutate(Type_Travel = 1) %>%
        select(COMID, Type_Travel) %>%
        unique()
        
    
      tmp_POIs <- POI_creation(select(tt_POIs, COMID, Type_Travel), nhd, "Travel") %>%
        addType(., tmp_POIs, "Travel")
    
      write_sf(tmp_POIs, temp_gpkg, nav_poi_layer)
    
    }else{
    
      tmp_POIs <- read_sf(temp_gpkg, nav_poi_layer)
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      nhd <- read_sf(nav_gpkg, nhd_flowline)
    
    }
    
    mapview(filter(tmp_POIs, Type_Travel == 1), layer.name = "Travel time break POIs", col.regions = "blue") 
    ```
      
    
    # Derive final POI set ----------------------
    
    if(needs_layer(temp_gpkg, pois_all_layer)) {
    
    
      unCon_POIs <- filter(st_drop_geometry(filter(nhd, minNet == 1)), COMID %in% tmp_POIs$COMID, AreaSqKM == 0)
    
      # If any POIs happened to fall on flowlines w/o catchment
      if (nrow(unCon_POIs) >0){
        # For confluence POIs falling on Flowlines w/o catchments, derive upstream valid flowline,
    
        poi_fix <- DS_poiFix(tmp_POIs, filter(nhd, dend == 1))
    
        new_POIs <- st_compatibalize(poi_fix$new_POIs, tmp_POIs)
        xWalk <- poi_fix$xWalk
    
        # POIs that didn't need to be moved
        tmp_POIs_fixed <- filter(tmp_POIs, !COMID %in% c(poi_fix$xWalk$oldPOI, poi_fix$xWalk$COMID))
        # bind together
        final_POIs <- bind_rows(tmp_POIs_fixed, select(poi_fix$new_POIs, -c(oldPOI, to_com)))
        # Write out fixes
    
        write_sf(new_POIs, temp_gpkg, poi_moved_layer)
        write_sf(xWalk, temp_gpkg, poi_xwalk_layer)
    
        write_sf(final_POIs, temp_gpkg, pois_all_layer)
    
      } else {
        # If no fixes designate as NA
        poi_fix <- NA
        # write out final POIs
    
        write_sf(tmp_POIs, temp_gpkg, pois_all_layer)
    
      # Need all three sets for attribution below
    
      final_POIs <- read_sf(temp_gpkg, pois_all_layer)
      new_POIs <- if(!needs_layer(temp_gpkg, poi_moved_layer)) read_sf(temp_gpkg, poi_moved_layer) else (NA)
      xWalk <- if(!needs_layer(temp_gpkg, poi_xwalk_layer)) read_sf(temp_gpkg, poi_xwalk_layer) else (NA)
    
    Bock, Andy's avatar
    Bock, Andy committed
      unCon_POIs <- filter(st_drop_geometry(filter(nhd, minNet == 1)), 
                           COMID %in% tmp_POIs$COMID, AreaSqKM == 0)
    
    ``` 
      
    ```{r Draft nsegment generation}
    
    if(needs_layer(temp_gpkg, nsegments_layer)) {
    
      # Sort POIs by Levelpath and Hydrosequence in upstream to downstream order
    
      seg_POIs <-  filter(st_drop_geometry(nhd), COMID %in% tmp_POIs$COMID, COMID %in% filter(nhd, minNet == 1)$COMID)
    
    Bock, Andy's avatar
    Bock, Andy committed
      # derive incremental segments from POIs
    
      inc_segs <- segment_increment(filter(nhd, minNet == 1), seg_POIs)
    
    
    Bock, Andy's avatar
    Bock, Andy committed
        left_join(select(inc_segs, COMID, POI_ID), by = "COMID")
    
      # create and write out final dissolved segments
    
      nsegments_fin <- segment_creation(nhd_Final, xWalk)
    
      nhd_Final <- select(nhd_Final, -POI_ID) %>%
    
        left_join(select(st_drop_geometry(nsegments_fin$raw_segs), COMID, POI_ID), by = "COMID")
      nsegments <- nsegments_fin$diss_segs
    
      # Produce the minimal POIs needed to derive the network based on LP and terminal outlets
    
      strucFeat <- structPOIsNet(nhd_Final, final_POIs)
    
      nhd_Final <- nhd_Final %>%
    
        mutate(struct_POI = ifelse(COMID %in% strucFeat$struc_POIs$COMID, 1, 0),
               struct_Net = ifelse(COMID %in% strucFeat$structnet$COMID, 1, 0))
    
      write_sf(nhd_Final, nav_gpkg, nhd_flowline)
    
      write_sf(nsegments, temp_gpkg, nsegments_layer)
    
      # Read in NHDPlusV2 flowline simple features and filter by vector processing unit (VPU)
    
      final_POIs <- read_sf(temp_gpkg, pois_all_layer)
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      nhd_Final <- read_sf(nav_gpkg, nhd_flowline)
    
      nsegments <- read_sf(temp_gpkg, nsegments_layer)
    
    Bock, Andy's avatar
    Bock, Andy committed
    
    
    # Ensure that all the problem POIs have been taken care of
    
    sub <- nhd_Final %>% filter(COMID %in% final_POIs$COMID)
    print (paste0(nrow(sub[sub$AreaSqKM == 0,]), " POIs on flowlines with no local drainage contributions"))
    ```
    
    
    ```{r POI Collapse}
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
    if(needs_layer(nav_gpkg, final_poi_layer)) {
    
      if(!"Type_Elev" %in% names(final_POIs)) final_POIs$Type_Elev <- rep(NA_real_, nrow(final_POIs))
      
    
      #1 Move POIs downstream by category
    
      out_HUC12 <- POI_move_down(temp_gpkg, final_POIs, nsegments, filter(nhd_Final, !is.na(POI_ID)), "Type_HUC12", .10)
      out_gages <- POI_move_down(temp_gpkg, out_HUC12$allPOIs, out_HUC12$segs, out_HUC12$FL, "Type_Gages", .05)
    
    Bock, Andy's avatar
    Bock, Andy committed
      # Convert empty strings to NA for handling within R
    
      out_gages$allPOIs <- mutate_all(out_gages$allPOIs, list(~na_if(.,"")))
    
      
      out_gages$allPOIs$snapped <- out_gages$allPOIs$COMID %in% new_POIs$COMID
    
      nhd_Final <- select(nhd_Final, -POI_ID) %>%
    
        left_join(st_drop_geometry(out_HUC12$FL) %>%
    
                    select(COMID, POI_ID), by = "COMID")
    
      # Write out geopackage layer representing POIs for given theme
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      write_sf(out_gages$allPOIs, nav_gpkg, final_poi_layer)
    
      write_sf(out_gages$segs, temp_gpkg, nsegments_layer)
    
      nsegments <- out_gages$segs
      final_POIs <- out_gages$allPOIs
    
    Blodgett, David L.'s avatar
    Blodgett, David L. committed
      final_POIs <- read_sf(nav_gpkg, final_poi_layer)
      nhd_Final <- read_sf(nav_gpkg, nhd_flowline)
    
      nsegments <- read_sf(temp_gpkg, nsegments_layer)
    
    
    mapview(final_POIs, layer.name = "All POIs", col.regions = "red") + 
      mapview(nsegments, layer.name = "Nsegments", col.regions = "blue")