Examples of Data Management and Modeling

Forest Carbon 
A carbon tracking model in Excel for northern California forests.  This model structure is being converted to a matrix method following my attendance of the carbon modeling workshop of Dr. Yiqi Luo’s lab at Northern Arizona University.  These models track carbon following changes to canopy closure following forest thinning. Model Northern California Carbon Budget excel file.

Fish Production
Ran the EDT (Ecosystem Diagnosis and Treatment) fish habitat model for the Shasta River in northern California to assess current habitat and production capability.  Ran scenarios of restoration to predict gains in production of Chinook salmon. 

Roads Network  
Created and ran an ORACLE data table and a culvert assessment data entry form.  Updated the GIS roads layers for the Siuslaw National Forest.  

Elk habitat and Hydrology 
Ran the HEIwest elk habitat model to evaluate conditions  in the Quartz Creek watershed of the Blue River Ranger District, Willamette National Forest. The model evaluates condition based on size, spacing, and types of forest cover, edge habitat, and road density. Also parameterized and ran the Aggregate Recovery Program (ARP) model to evaluate degree of hydrologic recovery of forest cover in Quartz Creek watershed.

Summaries of stream habitat data
Wrote and ran programs in Statistical Analysis Software(SAS) to create summaries of Level II stream habitat data similar to SMART summaries used by Willamette National Forest.

Map generation using GIS
Maps have been produced as part of four watershed analyses. Data layers are normally obtained from participating agencies and manipulated using ESRI software.  New data is edited into databases to create new layers.