DAT 223 Project Three Status Report Western Forest
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
223
Subject
Geography
Date
Dec 6, 2023
Type
docx
Pages
5
Uploaded by DeaconSwanPerson697
Western Forest Service Project Status Report
Name: Golda Smith
Date: October 15, 2023
Status Report
Status
Progress
Supporting Documentation
The following updates were completed to the original codebook to ensure accuracy, clearly define all data types, and align with the research questions. Wilderness Area and Soil Type are the main variables of interest.
Secondary tables were added to the database to allow for easier look up of soil type and wilderness area.
Dummy variable binary columns have been condensed to single columns. In the provided dataset, Soil Type and Wilderness are never in more than one column.
The following columns were added:
Column 6 (Vertical_Distance_To_Roadways). This was missing from the original dataset.
Column 7 (Tree_Density). Infestations move much faster in denser areas, therefore, understanding tree density would be very pertinent information.
Column 8 (Infestation_Levels). We must understand the existing infestation levels.
Column 12 (Boring_Dust) and Column 13 (Downed_Trees). These were added
to record symptoms of the infestation in the given areas.
Each columns data type was added to each line from the original codebook to
support with future analysts comprehension of each values meaning.
Preliminary Data
Variables of interest:
Wilderness_Area
Soil_Type
Cover_Type
Elevation
Aspect
Slope
Horizontal_Distance_To_Hydrology
Vertical_Distance_To_Hydrology
Horizontal_Distance_To_Roadways
Hillshade_9am
Hillshade_Noon
Hillshade_3pm
Horizontal_Distance_To_Fire_Points
1
Status
Progress
Data Analysis Requirements
The available data meets the data analysis requirements by providing additional meaning behind the soil type in the wilderness areas. The data also provides information on the proximity to roadways and water, shade and tree cover, and overall topography.
The given information will be used to address the research problem by allowing
us to analyze how different soil types are affected and the similarities in the wilderness areas which will help us formulate plans to control and prevent infestation.
There is not sufficient information to completely answer the research questions
and support the client’s concerns. The dataset is missing information regarding Spruce Beetle infestation, which is the main concern of the client. Without this information it will not be possible to completely resolve the research questions.
The data set is also missing information to link the different wilderness areas together. We don’t have any true location points to connect the areas and formulate a true pattern.
We are also missing information regarding the costs of each strategy being used to control the infestation. Without this information we won’t be able to recommend the best strategy.
Next Steps and Rationale
The data provided may prove useful because it provides information on different wilderness areas and soil types. However, there is no information regarding infestation levels or geographical points given. We are unable to connect the locations and create a plan based on this information. Infestation
proximity is very important. Without this information, we are unable to completely address the organizational problem. We will also need information regarding the costs of any strategies that have been proven to control the infestation.
This information is crucial in addressing the organizational problem. If it is not
readily available, a research team will need to be created to review and capture information regarding infestation and record specific geographical points. Supporting Documentation
Table 1: Observations – Column Description
1.
Elevation: Elevation in meters (INTEGER)
2.
Slope: Slope in degrees (INTEGER)
3.
Horizontal_Distance_To_Hydrology: Horizontal distance to nearest surface water in meters (INTEGER)
4.
Vertical_Distance_To_Hydrology: Vertical distance to nearest surface water in meters (INTEGER)
5.
Horizontal_Distance_To_Roadways: Horizontal distance to nearest roadway in meters (INTEGER)
6.
Vertical_Distance_To_Roadways: Vertical distance to nearest roadway in meters (INTEGER)
7.
Tree_Density: Count of trees per acre (INTEGER)
8.
Infestation_Levels: INTEGER value between 1-5 with the following key:
2
a.
High (1)
b.
Medium (2)
c.
Low (3)
d.
None (4)
e.
Unknown (5)
9.
Wilderness_Area: INTEGER value between 1-4 with the following key:
a.
Rawah Wilderness Area (1)
b.
Neota Wilderness Area (2)
c.
Comanche Park Wilderness Area (3)
d.
Cache la Poudre Wilderness Area (4)
10.
Soil_Type: INTEGER value between 1-40 with the following key:
a.
Cathedral family - Rock outcrop complex, extremely stony (1)
b.
Vanet - Ratake families complex, very stony (2)
c.
Haploborolis - Rock outcrop complex, rubbly (3)
d.
Ratake family - Rock outcrop complex, rubbly (4)
e.
Vanet family - Rock outcrop complex, rubbly (5)
f.
Vanet - Wetmore families - Rock outcrop complex, stony (6)
g.
Gothic family (7)
h.
Supervisor - Limber families complex (8)
i.
Troutville family, very stony (9)
j.
Bullwark - Catamount families - Rock outcrop complex, rubbly (10)
k.
Bullwark - Catamount families - Rock land complex, rubbly. (11)
l.
Legault family - Rock land (11)
m.
Unknown (12)
n.
Catamount family - Rock land - Bullwark family complex, rubbly (13)
o.
Pachic Argiborolis - Aquolis complex (14)
p.
Unspecified in the USFS Soil and ELU Survey (15)
q.
Cryaquolis - Cryoborolis complex (16)
r.
Gateview family - Cryaquolis complex (17)
s.
Rogert family, very stony (18)
t.
Typic Cryaquolis - Borohemists complex (19)
u.
Typic Cryaquepts - Typic Cryaquolls complex (20)
v.
Typic Cryaquolls - Leighcan family, till substratum complex (21)
w.
Leighcan family, till substratum, extremely boulder (22)
x.
Leighcan family, till substratum - Typic Cryaquolls complex (23)
y.
Leighcan family, extremely stony (24)
z.
Leighcan family, warm, extremely stony (25)
aa.
Granile - Catamount families complex, very stony (26)
bb.
Leighcan family, warm - Rock outcrop complex, extremely stony (27)
cc.
Leighcan family - Rock outcrop complex, extremely stony (28)
dd.
Como - Legault families complex, extremely stony (29)
ee.
Como family - Rock land - Legault family complex, extremely stony (30)
ff.
Leighcan - Catamount families complex, extremely stony (31)
gg.
Catamount family - Rock outcrop - Leighcan family complex, extremely stony (32)
hh.
Leighcan - Catamount families - Rock outcrop complex, extremely stony (33)
ii.
Cryorthents - Rock land complex, extremely stony (34)
jj.
Cryumbrepts - Rock outcrop - Cryaquepts complex (35)
kk.
Bross family - Rock land - Cryumbrepts complex, extremely stony (36)
3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ll.
Rock outcrop - Cryumbrepts - Cryorthents complex, extremely stony (37)
mm.
Leighcan - Moran families - Cryaquolls complex, extremely stony (38)
nn.
Moran family - Cryorthents - Leighcan family complex, extremely stony (39)
oo.
Moran family - Cryorthents - Rock land complex, extremely stony (40)
11.
Cover_Type: INTEGER 1-7
a.
Spruce/Fir (1)
b.
Lodgepole Pine (2)
c.
Ponderosa Pine (3)
d.
Cottonwood/Willow (4)
e.
Aspen (5)
f.
Douglas-fir (6)
g.
Krummholz (7)
12.
Boring_Dust: INTEGER between 1-5
a.
High (1)
b.
Medium (2)
c.
Low (3)
d.
None (4)
e.
Unknown (5)
13.
Downed_Trees: INTEGER Approximate number of downed trees
Table 2: Soil_Type Column Description
1.
ID (INTEGER)
2.
Description (VARCHAR)
Table 3 : Wilderness_Area – Column Description
1.
ID (INTEGER)
2.
Description (VARCHAR)
Table 4: Infestation – Column Description
1.
ID (INTEGER)
2.
Description (VARCHAR)
Preliminary Data
4
5