Appendix D
Data File Structure
and
File Descriptions
Data File Structure and File Descriptions
Overview
During this project we collected a large quantity of data. This data was created and collected in a variety of ways. These include data collected from GPS and the Criterion. Data that was create included Arc/Info coverages, Maps, and Road design data. Because of this large quantity of data it was necessary to create an organized method of storage. Below is a list of the main structure that you will find on the CD included with the report.
The following pages will give you a detailed description of the type of information that is contained in the different directories. There will also be a description of the files, how to read the naming of the files, descriptions of the various subdirectories, and how you can use these files.
Criterion Data
We used the Criterion for a large portion of the Field Portion of the project. We initially went in flagging the road. Then after it was verified that it would work, the Criterion was brought in to P-Line the Road. We also used the Criterion to collect data on two bridge site surveys. All of the data collected from the Criterion was stored in the \TOUTLE\CRITDATA directory. There are two types of file extensions used. All files with extensions of S*, where the * consists of a number, were the files downloaded from the Criterion. Files that have an extension of POL were files that have been edited in EXCEL to have the correct data structure to be used by RoadEng. Below is a list of the file names and what data is contained in the file.
|
4100ALT |
P-Line in the East portion of the 4100 bypassing the various FEMA points. |
|
5103BLOW |
Bridge Site Survey of the 5103 culvert washout. |
|
5601CNCT |
P-Line of road connecting 5601 to the 5103( Links 4100 system to 5100 system. |
|
5601PRT1 |
P-Line of first half of 5601 to 5103 connection road. |
|
5601PRT2 |
P-Line of second half of 5601 to 5103 connection road. |
|
BRDGEAPR |
P-Line of road from 5601/5103 connector east to Herrington Alternate bridge. |
|
BRDGSITE |
Bridge Site Survey of Herrington Alternate bridge location. |
|
BRDGWAPR |
P-Line of road from 5601/5103 connector west to Herrington Alternate bridge. |
|
BRDGWPRT |
First half of BRDGWAPR file. |
|
BRTO4100 |
P-Line of road connecting Herrington Alternative bridge to the 4100. |
Arc/Info Export Files
The following files are located in the \TOUTLE\E00 directory. Below are listed the file names with a brief description of the type of information that they contain.
|
BLOCK51.E00 |
Clip of the WORKPOLY.E00 showing area accessed by the 5100 road system. |
|
BOUNDARY.E00 |
Clip of WAU.E00 showing boundary of DNR and Weyco lands in Toutle. |
|
BRDGOVER.E00 |
|
|
BRIDGE.E00 |
Contours in 5’ intervals of the Herrington Alternate Bridge site(from RoadEng). |
|
CLIPNE.E00 |
|
|
CLIPNW.E00 |
|
|
CLIPSE.E00 |
|
|
CLIPSW.E00 |
|
|
FEMA.E00 |
Cover showing aproximate FEMA report locations. |
|
HYDRO.E00 |
|
|
HYDROI~1.E00 |
Hydro coverage with buffer item. |
|
POCA.E00 |
|
|
POCAL.E00 |
|
|
POCAL2.E00 |
|
|
RDPOINT.E00 |
Point coverage of the node locations of the WORKROAD.E00. |
|
ROADBUF.E00 |
Buffer of the WORKROAD.E00. |
|
SHAW.E00 |
|
|
SHAWE.E00 |
|
|
SHAWW.E00 |
|
|
SLOPE.E00 |
|
|
SOILS.E00 |
|
|
T8R2.E00 |
Road Coverage. |
|
T8R3.E00 |
Road Coverage. |
|
T8R4.E00 |
Road Coverage. |
|
T9R2.E00 |
Road Coverage. |
|
T9R3.E00 |
Road Coverage. |
|
T9R4.E00 |
Road Coverage. |
|
TICCOV2.E00 |
Cover with standardized TICS. |
|
TIMSALES.E00 |
|
|
TRANS.E00 |
|
|
TRAN_MN.E00 |
Road cover containing 4100, 5100, 2730, etc. |
|
USGSCON.E00 |
40’ Contour cover |
|
WAU.E00 |
|
|
WORKPOLY.E00 |
Vegitation cover used for SNAP analysis. |
|
WORKROAD.E00 |
Transportation cover used for SNAP analysis. |
GPS Data
GPS was used quite a bit through this project. Its main purpose was to allow us the opportunity to study the transportation system of the main roads in the Toutle Block. It also gave us the ability to give the data collected with the Criterion Real World Coordinates in X, Y, and Z. There are two file extensions, COR and SSF. COR files have been corrected. The SSF files are directly downloaded from GPS unit. Following are a list of names and sub-directories found in the \TOUTLE\GPSDATA directory.
|
BASE |
Sub-directory containing correction files. |
|
BACKUP |
Sub-directory containing backups of the files listed below. |
|
2730DOWN |
2730 road from 4250 to the 5600. |
|
4100ALTP |
|
|
4100EEND |
|
|
4100ETOW |
First half of 4100 from Herrington Washout to Railroad tracks. |
|
4100ETW2 |
Second half of 4100 from Herrington Washout to Railroad tracks. |
|
4100LOW |
|
|
4200UP |
4200 from 4100 to 2730 |
|
5600UP |
5600 from 4100 to 5 way. |
|
5601WTOE |
|
|
5WAYDOWN |
4250 from 5 way to the 2730. |
|
FEMA8OR9 |
|
|
FEMA9OR1 |
|
|
FEMABRU |
|
|
TOUTCRSS |
Maps and AML/SML
These files are located in the \TOUTLE\MAPS directory. Most maps were work maps created for the Field with a few maps exploring the use of 3-D mapping for displaying information. Below is a brief description of the various maps and files.
|
CLIPNW.MAP |
|
|
3D_TIN.AML |
|
|
3D_TIN4.AML |
|
|
3D_TIN_M.AML |
|
|
BRIDGE.AML |
Creates 3-D map of Herrington Alt Bridge site. |
|
BRIDGE.GRA |
3-D map of Herrington Alt Bridge site. |
|
BRIDGE2.GRA |
3-D map of Herrington Alt Bridge site. |
|
DISP.GRA |
|
|
LOC_NE.MAP |
Maps with the NAD27 and LAT/LONG coordinates |
|
LOCATE.SML |
Creates maps with the NAD27 and LAT/LONG coordinates. |
|
LOC_NW.MAP |
Maps with the NAD27 and LAT/LONG coordinates |
|
LOC_SE.MAP |
Maps with the NAD27 and LAT/LONG coordinates |
|
MAP.AML |
|
|
MAP2.AML |
|
|
RECALC.AML |
|
|
SALEMAP.SML |
|
|
TEST.SML |
Creates maps with roads, polygons, polygon Ids, and road F-Nodes. |
|
TESTNE.MAP |
Maps with roads, polygons, polygon Ids, and road F-Nodes. |
|
TESTNW.MAP |
Maps with roads, polygons, polygon Ids, and road F-Nodes. |
|
TESTSE.MAP |
Maps with roads, polygons, polygon Ids, and road F-Nodes. |
|
TESTNW.SML |
Maps with roads, polygons, polygon Ids, and road F-Nodes. |
|
TEST_3D.GRA |
Photographs
These are photographs of the Spring Field Studies project. They are found in the \TOUTLE\PHOTOS directory. These photographs are Seattle Filmworks formate and can be viewed using the software package PhotoWorks.
RoadEng Data
All of the RoadEng data was stored in the directory \TOUTLE\RDENGDAT. We used RoadEng for analysis of data collected in the field using the Criterion. RoadEng uses a variety of Extensions for its files. These Extensions are listed in the following Table. The # sign is used to indicate that there are a variety of numbers that are used.
|
DXF |
AutoCadd graphics file |
|
DB# |
Survey notes |
|
DSN |
Location Design file |
|
KY# |
Location file |
|
TER |
Terrain Module file |
|
TLT |
Terrain Module file |
In the next Table are the names that were used for the various RoadEng analysis. Not all of the names contain all of the extensions. There were varying purposes for the different locations, but for the main roads you will find all of the different files.
|
4100ALT |
4100 East of Herrington Washout. |
|
4100ALT1 |
4100 East of Herrington Washout. |
|
5103BLOW |
5103 Bridge Survey |
|
5103BRG |
5103 Bridge Survey and Road design. |
|
5103BRG5 |
5103 Bridge Survey and Road design. |
|
5601CNCT |
5601 to 5103 Road |
|
5601PRT2 |
5601 to 5103 Road |
|
5650REC |
|
|
BRDGAREA |
|
|
BRDGEAS2 |
Road from 5601CNCT to Herrington Alternate Bridge Site. |
|
BRDGEAST |
Road from 5601CNCT to Herrington Alternate Bridge Site. |
|
BRDGSITE |
Herrington Alterate Bridge Site Survey. |
|
BRDGWAPR |
Road from 5103 to Herrington Alternate Site |
|
BRDGWES2 |
Road from 5103 to Herrington Alternate Site |
|
BRDGWEST |
Road from 5103 to Herrington Alternate Site |
|
BRDGWPR |
Road from 5103 to Herrington Alternate Site |
|
BRDGWPRT |
Road from 5103 to Herrington Alternate Site |
|
BRGREPT |
DNR Presentation of June 5th
The following files were created for the presentation that was presented to the DNR and Weyco on June 5th 1997. The presentation occured in Castlerock, WA at the SW Region Department of Natural Resources. The presentation files are in Microsoft PowerPoint format and are located in the \TOUTLE\REPORTS\PRESENT directory.
|
20MMBF.PPT |
Vegetation and SNAP input. |
|
4100ALT.PPT |
|
|
5103.PPT |
|
|
BRULOTTE.PPT |
Herrington Alternate Bridge Presentation. |
|
DRAFT.PPT |
Final Presentation. |
|
MATT.PPT |
Road System Overview and SNAP results. |
|
METTLER.PPT |
Speed analysis, GPS, and cost analysis. |
|
TOUTLE.PPT |
Final Presentation |
Toutle River Final Report
You will find the digital copy of the report in \TOUTLE\REPORTS\TOUTLE. Since you are looking in the report now, not much detail will be mentioned about the various parts of the report. These files are Microsoft Word 6.0 files.
|
APPEND_A.DOC |
Silvicultural Treatments by Five Year Period |
|
APPEND_B.DOC |
Seral Stage Distribution by Five Year Period |
|
APPEND_C.DOC |
SNAP Road Use First 20 Years |
|
APPEND_D.DOC |
Data File Structure and File Descriptions |
|
CHAP_1.DOC |
INTRODUCTION |
|
CHAP_1.DOT |
Template for standardizing report. |
|
CHAP_2.DOC |
Planning |
|
CHAP_3.DOC |
SILVICULTURE AND HARVEST YIELD PROJECTIONS |
|
CHAP_4.DOC |
General Road Use Patterns |
|
CHAP_5.DOC |
5103 Bridge Design |
|
CHAP_6.DOC |
Alternative Route FEMA Points Seven through Eleven |
|
CHAP_7.DOC |
Haul Time Comparison and Break-Even Analysis |
|
CHAP_8.DOC |
South Toutle Bridge Location and Approach Design |
|
CHAP_9.DOC |
Reconnaissance Reports |
|
CONTENTS.DOC |
|
|
LST_FIGS.DOC |
|
|
LST_TABL.DOC |
|
|
SIGPAGE.DOC |
|
|
COVER1.DOC |
|
|
COVER2.DOC |
|
|
COVER3.DOC |
|
|
COVER4.DOC |
Cost Analysis Calculations
To find out how the cost analysis results found in the report were determined you can look at the EXCEL files found in \TOUTLE\REPORTS\TOUTLE\COSTING. The following table shows a discription of the files.
|
BRIGEA12.XLS |
Analysis for the east approach to the bridge for a 12 foot running surface |
|
BRIGEAST.XLS |
Analysis for east approach to bridge with 14 foot running surface.. |
|
BRIGWEST.XLS |
Analysis for west approach to bridge. |
|
BRSOUT.XLS |
Analysis for south approach to bridge. |
|
SEEDING.XLS |
Seeding costs. |
|
4100CST.XLS |
4100 Alt construction costs. |
Graphics from Report
All of the graphics files found in the report are located in the \TOUTLE\REPORTS\TOUTLE\GRAPHICS directory. There are also other graphic files not found in the report located in this same directory. As much as possible all files have been described as to their content, but given the number of files and the number of people creating these files, not all have been identified.
|
14CR.GIF |
Recon Report graphics. |
|
14CRALT.GIF |
Recon Report graphics. |
|
4100ALT.GIF |
Recon Report graphics. |
|
4100CN1.GIF |
Recon Report graphics. |
|
4100CN2.GIF |
Recon Report graphics. |
|
4100P1.GIF |
Recon Report graphics. |
|
4100P2.GIF |
Recon Report graphics. |
|
5103CN.GIF |
Recon Report graphics. |
|
5103CON.GIF |
Recon Report graphics. |
|
5103P.GIF |
Recon Report graphics. |
|
5103R.GIF |
Recon Report graphics. |
|
5650REC.GIF |
Recon Report graphics. |
|
5650RECO.GIF |
Recon Report graphics. |
|
76448_37.PCX |
Photograph |
|
76449_01.PCX |
Photograph |
|
76449_02.PCX |
Photograph |
|
76449_04.PCX |
Photograph |
|
76449_06.PCX |
Photograph |
|
76450_04.PCX |
Photograph |
|
76450_05.PCX |
Photograph |
|
76450_24.PCX |
Photograph |
|
76450_25.PCX |
Photograph |
|
76459_04.PCX |
Photograph |
|
76459_12.PCX |
Photograph |
|
76459_14.PCX |
Photograph |
|
BRIDGE.GIF |
Graphic of Arc/Info map, Herrington Alt Bridge Site. |
|
BRIDGE.PCX |
Graphic of Arc/Info map, Herrington Alt Bridge Site. |
|
BRIDGE1.PCX |
Photograph |
|
BRIDGE2.PCX |
Photograph |
|
BRRECON.GIF |
Recon Report graphics. |
|
CCVOL.GIF |
SNAP table showing Clearcut Volumes. Chapter 3. |
|
CLIPNE.PCX |
Graphic of Arc/Info map |
|
DISP.GIF |
Graphic of Arc/Info map, Overview of whole area. |
|
DISP.TIF |
Graphic of Arc/Info map, Overview of whole area. |
|
FEMA12.GIF |
Photograph |
|
FEMA14.GIF |
Photograph |
|
FEMA14A.PCX |
Photograph |
|
FEMA14B.PCX |
Photograph |
|
FEMA4.GIF |
Photograph |
|
FEMA6.GIF |
Photograph |
|
HAULTIM.GIF |
Haultime comparison, Chapter 7. |
|
HERRING.PCX |
Photograph |
|
LD.BMP |
Little Debie Snack Cracker Logo |
|
OVERVIEW.GIF |
Graphic of Arc/Info map, Overview of whole area. |
|
REP1.GIF |
Silvicultural Treatment, Chapter 3 |
|
REP2.GIF |
Silvicultural Treatment, Chapter 3 |
|
ROADS_EX.GIF |
Roads graphics found in Chapter 4. |
|
ROAD_3B.GIF |
Roads graphics found in Chapter 4. |
|
ROAD_41.GIF |
Roads graphics found in Chapter 4. |
|
ROAD_51.GIF |
Roads graphics found in Chapter 4. |
|
ROAD_HER.GIF |
Roads graphics found in Chapter 4. |
|
ROAD_OVR.GIF |
Roads graphics found in Chapter 4. |
|
ROCKNOB.GIF |
Location of a FEMA point. |
|
ROUTES~1.GIF |
Roads graphics found in Chapter 4. |
|
RTE_WHER.GIF |
Roads graphics found in Chapter 4. |
|
RTE_WO~1.GIF |
Roads graphics found in Chapter 4. |
|
TEST_2.PCX |
|
|
THVOL.GIF |
SNAP table showing Thinning Volumes. Chapter 3. |
|
WEYCOBRG.PCX |
Photograph |
|
COVER3.PCX |
Document cover graphic. |
|
COVER1.GIF |
Document cover graphic. |
|
LOGO.GIF |
University of Washington Forest Engineering Logo |
|
APPEND~1 |
Directory containing all graphics found in Appendix 1 |
|
APPEND~2 |
Directory containing all graphics found in Appendix 2 |
Haultime Analysis Results
In the following directory are the EXCEL files used to create the results shown in Chapter 7 of the report. The files are found on the CD in the \TOUTLE\REPORTS\TOUTLE\HAULTIME directory. Following is a list of the files in the directory.
|
2730.XLS |
Results for run using 2730/4250/4200/4100 route. |
|
2730OPT.GPS |
OTTO file used to get results. |
|
4100.XLS |
Results for run using Herrington Alt/4100. |
|
4100OPT.GPS |
OTTO file used to get results. |
1997 Forest Engineering Handbook
This is the handbook used by the Forest Engineering Students and updated by the Forest Engineering Students. This is the final copy finished in June of 1997. It is a Word Document in 6.0 format with the name of HNDBK97.DOC. There is also a file called CRI2RDNG.DOC that is contained in the handbook but was also kept as a separate file for easy access. It containes information on how to transfer data from the Criterean unit the RoadEng.
SNAP Data
A SNAP run was completed on the Toutle River Transportation System. The following files in the \TOUTLE\SNAPFILE directory are the base files put into SNAP to run the analysis. There is also included a copy of the version of SNAP that we used.
SNAP Results
The results for the SNAP run have been stored in the \TOUTLE\SNAPFILE\TOUTLE directory. A brief description of some of the files follows.
|
TOUTLE.ADJ |
Adjacency information |
|
TOUTLE.ATT |
|
|
TOUTLE.BUF |
Buffering information |
|
TOUTLE.DEF |
Polygon definitions |
|
TOUTLE.GRO |
Growth definitions |
|
TOUTLE.GRP |
|
|
TOUTLE.GST |
|
|
TOUTLE.LA |
|
|
TOUTLE.LIF |
|
|
TOUTLE.LP |
|
|
TOUTLE.LPD |
|
|
TOUTLE.LSD |
|
|
TOUTLE.MCD |
|
|
TOUTLE.MIL |
Mill information |
|
TOUTLE.PRI |
|
|
TOUTLE.RLF |
|
|
TOUTLE.SAF |
|
|
TOUTLE.SER |
Seral Stage definitions |
|
TOUTLE.SYS |
|
|
TOUTLE.TEM |
|
|
TOUTLE.TRT |
|
|
TOUTLE.UA |
|
|
TOUTLE.UP |
|
|
TOUTLE.UPD |
|
|
TOUTLE.US |
|
|
BRIDGE |
Analysis run with Herrington Alt Bridge. 30 Iterations with harvest of 30MMBF/per. |
|
NOBRDG |
Analysis run w/o Herrington Alt Bridge. 30 Iterations with harvest of 30MMBF/per. Had an error in the results. |
|
NOBRDG2 |
Analysis run w/o Herrington Alt Bridge. 30 Iterations with harvest of 30MMBF/per. |
|
UNCONS |
Analysis run with Herrington Alt Bridge. 30 Iterations w/o harvest goals. |
SNAP Presentation of Results
There were three maps created that showed the results from the SNAP runs for the first four periods. The maps were the BDG_OVER.PCX, NOB_OVER.PCX, and the UNC_OVER.PCX. All of the files have the first three charactors as the run type, the next four charactors indicate the type of picture, and the final charactor if there is one is the period number. The following table shows the files that are found in the \TOUTLE\SNAPFILE\PCX directory.
|
BDG_CC.PCX |
Clearcut Volume Table |
|
BDG_LNK1.PCX |
|
|
BDG_LNK2.PCX |
|
|
BDG_LNK3.PCX |
|
|
BDG_LNK4.PCX |
|
|
BDG_SER1.PCX |
|
|
BDG_SER2.PCX |
|
|
BDG_SER3.PCX |
|
|
BDG_SER4.PCX |
|
|
BDG_SIL1.PCX |
|
|
BDG_SIL2.PCX |
|
|
BDG_SIL3.PCX |
|
|
BDG_SIL4.PCX |
|
|
BDG_THIN.PCX |
Thinning Volume Table |
|
BDG_THV.PCX |
Total Harvest Volume Table |
|
BRD_EM~1.PCX |
|
|
BRD_OVER.PCX |
Overview of SNAP results. |
|
LINKS.PAL |
|
|
LINK_LEG.GIF |
|
|
NOB_CC.PCX |
Clearcut Table |
|
NOB_LNK1.PCX |
|
|
NOB_LNK2.PCX |
|
|
NOB_LNK3.PCX |
|
|
NOB_LNK4.PCX |
|
|
NOB_OVER.PCX |
Overview of SNAP results. |
|
NOB_SER1.PCX |
|
|
NOB_SER2.PCX |
|
|
NOB_SER3.PCX |
|
|
NOB_SER4.PCX |
|
|
NOB_SIL1.PCX |
|
|
NOB_SIL2.PCX |
|
|
NOB_SIL3.PCX |
|
|
NOB_SIL4.PCX |
|
|
NOB_THIN.PCX |
Thinning Volume Table |
|
NOB_THV.PCX |
Total Harvest Volume Table |
|
SERS_LEG.GIF |
|
|
SIL_LEG.GIF |
|
|
UNC_CC.PCX |
Clearcut Volume Table |
|
UNC_LNK1.PCX |
|
|
UNC_LNK2.PCX |
|
|
UNC_LNK3.PCX |
|
|
UNC_LNK4.PCX |
|
|
UNC_OVER.PCX |
Overview of SNAP results. |
|
UNC_SER1.PCX |
|
|
UNC_SER2.PCX |
|
|
UNC_SER3.PCX |
|
|
UNC_SER4.PCX |
|
|
UNC_SIL1.PCX |
|
|
UNC_SIL2.PCX |
|
|
UNC_SIL3.PCX |
|
|
UNC_SIL4.PCX |
|
|
UNC_THIN.PCX |
Thinning Volume Table |
|
UNC_THV.PCX |
Total Harvest Volume Table |