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