wiki:EEPSF
Last modified 3 years ago Last modified on 11/11/14 06:48:45

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