South Fork Catawba Database for EEP project

Objective: To generate a database of environment layers for NHD catchments in the S. Fork Catawba.

ArcMap Models

A. Data Prep

• For the identified HUC6 ID: 030501
  • Select and project WDBHU6 (Watershed boundary database)--> SiteLayers.gdb\WDBHU6
  • Select and project HUC12s --> SiteLayers.gdb\HUC12
  • Select and project NHD Flowlines --> SiteLayers.gdb\NHDFlowlines
    • Create a feature class of Flowline midpoints SiteLayers.gdb\FlowlineMidPts
• Select NHD Catchments falling within WDBHU6 --> SiteLayers.gdb\NHDCatchments
  • Dissolve NHDCatchments into a single feature --> SiteLayers.gdb\MaskPoly
  • Convert MaskPoly to a 30m raster, snapped to NHD elev_cm cells --> LocalData\Mask
• Extract the following layers using the LocalData\Mask raster:
  • USA.sde/2011 NLCD --> LocalData\nlcd_2011
  • USA.sde/2011 Canopy Cover --> LocalData\canopycov
  • USA.sde/2011 Impervious Surface--> LocalData\impervious
  • NHDplusV2.sde/ElevCm--> LocalData\elev_cm
  • NHDplusV2.sde/catchments--> Localdata\catchments
  • NHDplusV2.sde/flowdir --> Localdata\flowdir
  • NHDplusV2.sde/fdrnull--> Localdata\fdrnull

B. Join NHD Tables

• Copy NHDFlowline attribute table to SiteLayers.gdb/FlowlineData
  • Include: COMID, LENGTHKM, REACHCODE, FTYPE, FCODE
• Join PlusFlowlineVAA.dbf to FlowlineData
  • Include: StreamOrder, PathLength, ArbolateSum, AreaSQKm
• Join CumulativeArea.dbf to FlowlineData
  • Include: ToDASqKM
• Join elevslope.dbf to FlowlineData
  • Include: SLOPE, SLOPELENKM
• Join EROM_MA0001.dbf to FlowlineData
  • Include: Q0001E, V0001E, Qincr0001E, TEMP0001, PPT001E, PET0001, QLOSS0001

B1. Join Monthly EROM Tables {optional}

• Loop through EROM_Extension\EROM_* tables and join to FlowlineFlow table
  • Include: Q0001E, V0001E, Qincr0001E, TEMP0001, PPT001E, PET0001, QLOSS0001 for each month

C. Join VPU Tables

• Copy Catchments attribute table to SiteLayers.gdb/FlowlineVPUData
  • Include: COMID, FEATUREID
• Convert VPUAttributeExtension\IncrPrecipMA.txt to table and join to FlowlineVPUData
  • Include: PrecipV
• Convert 'VPUAttributeExtension\IncrTempMA'.txt to table and join to FlowlineVPUData
  • Include: TempV
• Convert VPUAttributeExtension\ROMA0001.txt to table and join to FlowlineVPUData
  • Include: RunOffV
• Convert VPUAttributeExtension\CumTotPrecip.txt to table and join to FlowlineVPUData
  • Include: TempVC
• Convert VPUAttributeExtension\CumTotTemp.txt to table and join to FlowlineVPUData
  • Include:
• Convert VPUAttributeExtension\!CumDivNLCD2011.txt to table and join to FlowlineVPUData
• Convert VPUAttributeExtension\IncrNLCD2011.txt to table and join to FlowlineVPUData

D. Calculate ESRI Landscape Stats

• Extract

E. Flow line stats

• Invert fdrnull raster to create a raster of catchment cells in the flow line only
• Tabulate area of NLCD classes along the catchment flowlines --> SiteLayers.gdb\FlowlineNLCD

F. Calculate stream shade stats

• Create a table: SiteLayers.gdb\ShadeStats by t
  • Includes: ShadedFragments, ShadedLength, LongestShade, MeanShadeLength

G. Calculate Canopy and Impervious Stats

H. Calcualte Riparian Stats