Home

Stream Reach Editor User Manual

Contents

1. Edit Edit Edit Edit Edit Edit wn C 4 wn Q D ao oO 4 4 4 uw oO wo 4 Ea E ae 53 amp 54 v 54 v 54 v 427 454 622 045 622 v 124 204 _ 54 St 54 54 54 797 54 883 v Send Data to Excel Insert from Excel ho pos mp 4 2668 ee a l ll ee ee 4PaPe Pa pate ta pata ta pa dada oo a a a a apaPa apa haa J wn pa 4 an pos 4 4 oO Figure 46 Habitat Attribute Editor with Predation Revised Ratings Change the existing ratings for the Template T or Current C condition Focus Mon No Select the focus month from ths drop down list see discussion on Shape Monthly Pattern below for details on how to identify your focus month Stream Reach Editor User Manual May 2004 Page 45 ECOSYSTEM DIAGNOS amp TREATMENT Data Precision Enter 1 if the data entered is Categorical or 2 if Non Categorical Note that if this field is shaded gray then data precision is always non categorical See discussion on page 35 for more information on categorical and non categorical ratings Shape Monthly Pattern This field allows you to assign a monthly pattern to all attributes requiring a pattern For this set of attributes only Predation Risk requires a monthly pattern This pattern screen is shown below Stream Reach Editor Pattern Editor Use to crea
2. EDT ECOSYSTEM DIAGNOSIS amp TREATMENT Stream Reach Editor User Manual Mobrand Biometrics Inc May 2004 m r E E e n Stream Reach Editor User Manual TABLE OF CONTENTS MTV ERO CUNO Misses Sectectct apa cau oica ea seals Run aval cosas erin Gali ace neva ueeate ican Gaui austen ties 1 Who wall use the Stream Reach Eton sigs phesaes i208 he tice ic aeeearcto sas a e ea eae eatin Cheeta 1 VW Hiatt OU SOU RNO Wapis eel ate koe tee ae Lone tela eet ae ean enn eae 1 What software and hardware you Will need o eee eeeeeeseeseeeseeeeesecseeeseeseceeeeaeceeeeaesseseseaesseseseeseeeseeseenaees 1 Before You Beinaris a atta accra seen seaatan a a E eects 2 Downloading the Stream Reach Editor Documentation and Data eee eeeeseeseeeeeeseeeeeeaeeaeeseeeaeens 2 Getme the oiream Reach Edtorse t UPeerocinuriii niia aa E E T EA 7 Defining the Reach Siac rane srren eeina aea Eain EOE AENA SETAE EEIE EEE aeS 12 Edine cs iS CACC S scala E T T otc 12 Creatine NEW REICH ES irinn o E ETE gcse nian stash ONTA EOE EO 22 Rating Habitat Attributes suona aaa a E eaS a EOS O DE 24 Hydrolog ig C haracteristicS miere na nan A E AA 26 Overview or MLE IDULES enea accel la ear eae A EA 26 Data Mpu aly o0 a9 e aerntaee rer ret tt PO Pee ee Oe en ee ee ere 27 Additional Comments about Hydrologic Regime Attributes eee eseeeeeesecseceseeeeeseeseeeseeseeeaeens 30 Streat GOL PIG OF SUT AC ELM Calas ta
3. and Description Edit Reach Length Edit Reach Hierarchy Structure Edit Reach Routing Split an Existing Reach into an Upper and Lower Reach Delete Reach caution deletes reach and all associated data Exit to Main Reach Menu Figure 20 Edit Reaches screen The procedures for each of the six menu options shown above will be described separately here To edit reach sequence name and description 1 Click on the first button on the Edit Reaches for Subbasin menu The Edit Reach Name and Description screen appears Stream Reach Editor User Manual May 2004 Page 13 i M J ECOSYSTEM DAGNOHS amp TREATMENT Edit Reach Name and Description Subbasin Entiat Import Stream Reach Data Export Stream Reach Data Reach Editor Attribute Editor SeqNo Reach Name Description dg Menu Options tfentiat 1 1 Entiat 1 From Columbia River to End of slack water Length mi 0 6 2lEntiat 2 Entiat 2 From Slack water to Fire Station Bridge Length mi 2 6 Edit Reach Sequence Name St Entit 3 Entiat 3 From Fire Station Bridge to Roaring Creek Length mi 3 nd Description dit Reach Length SEntiat 4 SS Enttiat 4 From Roaring Creek to JS Bridge Length mi 2 6 Z d B Entiat 5 SS Enttiat S From J S Bridge to Mad River Length m 18 o oe iMad 1 Mad River MouthtoTillicumCreek O O O O O O OOOO Edit Reach Routing ___BfTilicum 4_______ Tilicum Creek O O O O O O O 9 Split an Existing Reach into
4. 3 1 Chemistry 3 2 Temperature variation 4 Biological Community 4 1 Community effects 4 2 _Macroinvertebrates This section will describe the procedure that you will use in working with the habitat editor to rate the above attributes To rate habitat attributes 1 Click on the Attribute Editor button of the navigation bar on the Stream Reach Editor Main Menu page The Habitat Attribute Editor screen appears Habitat Attribute Editor Subbasin Entiat minor stream Reach Wata Export Stream each Wata Reach Editor ASB UtE Editar Exit Habitat Attribute Select attribute from list then review definition and rating rule Select Category 1 Hydrologic Characteristics Select Sub Category ki Figure 34 Habitat Attribute Editor main screen top portion Note To illustrate the process we will use the category Hydrologic Characteristics and the sub category Flow variation 2 Select the category Hydrologic Characteristics and the sub category Flow Variation from the two drop down boxes at the top of the screen Stream Reach Editor User Manual May 2004 Page 25 ECOSYSTEM DIAGNOSIS amp TREATMENT Habitat Attribute Select attribute from list then review definition and rating rule Select Category 1 Hydrologic Characteristics select Sub Category 1 1 Flow variation FiavHigh FiyvLowy FivDielar Fly lntraAnn Figure 35 Habitat Attribute screen with category and sub category select
5. e Metals Pollutants In Sediment Soils e Miscellaneous Toxic Pollutants In Water Column MscToxWat e Nutrient Enrichment NutEnrch Temperature Variation includes these attributes e Maximum Temperature TempMx e Minimum Temperature TempMn e Temperature Spatial Variation ImpSptVar Data Input Example We will use Minimum Temperature TempMn as the example to describe how data for the Water Quality attributes are entered Select Water Quality from the Select Category drop down list select Temperature Variation from the Sub Category drop down list and click on the TempMn button The following screen will appear The upper left portion of the screen provides a description of the attribute TempMn Directly to the right of the attribute definition a text box displays the definitions of the ratings from 0 through 4 Note that you Stream Reach Editor User Manual May 2004 Page 41 EDT ECOSYSTEM DIAGNOSIS amp TREATMENT must use the vertical scroll bar to view all five rating definitions in the box Habitat Attribute Editor X Subbasin Entiat Import Stream Reach Data Export Stream Reach Data Reach Editor Attribute Editor Habitat Attribute Select attribute from list then review definition and rating rule Select Category 3 Water Quality x Select Sub Category 3 2 Temperature variation Temp Mx TempMn TmpSpt ar Temperature daily minimum by month Rating 0 Coldest day g
6. from the drop down list in the Downstream Reach field 5 Select the name of the tributary that enters the reach at the top of the reach from the drop down list in the Upstream Tributary Reach field 6 Click the box labeled This Reach Leaves Subbasin enters mainstem if this reach is the first in the basin Rating Habitat Attributes Once you have defined your reach structure with the Reach Editor function of the offline Stream Reach Editor you are ready to create your dataset of environmental attributes with the Attribute Editor function The subbasin data that you downloaded from the EDT Online Web site and imported into the Stream Reach Editor may have data for some of the environmental attributes already entered Therefore the way to proceed with the Habitat Editor is to view the existing data and then either edit the existing data or where no data exist enter new data Before beginning it is important to know how the attributes are arranged within the offline Stream Reach Editor Attributes are oganized into four major categories and 12 sub categories 1 Hydrologic Characteristics 1 1 Flow variation 1 2 Hydrologoc regime Stream Reach Editor User Manual May 2004 Page 24 ECOSYSTEM DIAGNOSIS amp TREATMENT 2 Stream Corridor Structure 2 1 Channel morphometry 2 2 Confinement 2 3 Habitat type 2 4 Obstructions 2 5 Riparian amp channel integrity 2 6 Sediment type 3 Water Quality
7. or a portion of the fields described below Stream Reach Editor User Manual May 2004 Page 33 ECOSYSTEM DIAGNOSIS amp TREATMENT Revised Ratings Change the existing ratings for the Template T or Current C condition Focus Mon No Select the focus month from the drop down list see discussion on Shape Monthly Pattern for details on how to identify your focus month Data Precision Enter 1 if the data entered is Categorical or 2 if Non Categorical Note that if this field is shaded gray then data precision is always non categorical see discussion on page 34 regarding categorical and non categorical ratings Shape Monthly Pattern Assign a monthly pattern to all attributes requiring a pattern Refer to page 35 for a list of seasonal variables that require monthly pattern E Edit Pattern Multpliers for Attribute stream Reach Editor Pattern Editor Use to createvedit a monthly pattern for a particular attribute Pattern ID 8d Pattern Description Pattern Mame WWidth P 1 Patterns created for Entiat by work team 2001 Rating Focus Morith Oo omj O al al aaj aaf 2 iz al af af af 1 Figure 39 Stream Reach Editor Pattern Editor To assign a monthly pattern to WidthMx click on the Edit button to bring up the screen shown below Use this screen to create edit the width patterns and thus assign widths by month Simply place the actual stream width for each month in its corresponding box Use the sa
8. 3 importing the data files into the Stream Reach Editor To launch the Stream Reach Editor 1 Navigate to the directory where you downloaded and extracted the Stream Reach Editor database application 2 Double click on the mdb file Stream Reach Editor mdb The MS Access application and database file will open as shown in the following screen Stream Reach Editor User Manual May 2004 Page 7 EDT ECOSYSTEM OIAGHOSS amp TREATMENT Welcome to the Stream Reach Editor Subbasin Need to import Data into Stream Reach Editor ECOSYSTEM DIAGNOSIS amp TREATMENT Welcome to the EDT Offline Stream Reach Editor System requirements MS Access 2000 Application is designed for screen resolution of 800 x 600 and higher Two files were included in the Offline Editor download this MS Access application Stream Reach Editor mdb and an executable file VBzipperDll exe This second file must be extracted into the same directory on your local hard drive as the Stream Reach Editor mdhb file Note for first time users You will need to download the Stream Reach Data from EDT Online before using this offline editor Figure 11 Stream Reach Editor Welcome screen 3 Click on Begin at the bottom of the screen The Stream Reach Editor Main Menu screen appears EDT Stream Reach Editor Stream Reach Editor Main Menu EDT Subbasin Need to impart Data into Stream Reach Editor ECOSYSTEM DIAGNOSIS amp TREATMENT Import Stream Reach
9. Available 8 Click View Edit Route Errors to review and correct routing errors The Reach Routing Editor appears Reach Route Errors Reach Routing Editor Reach Description Downstream Reach Upstream Reach Upstream Tributary Reach Nooksack2 Lummi River RM 4 5 to Tenmile Creek Nooksack2 Nooksack3 Tenmile2 X Confluence RM 6 9 z z Nooksack3 Tenmile Creek Confluence RM 6 9 ta Nooksack2 p Nooksack4A Ej ser Lake Creek confluence RM 10 2 Nooksack4A iser Lake Creek confluence RM Nooksack3 Ej Nooksack4B z 10 2 to Bertrand Creek confluence Nooksack4B Bertrand Creek confluence RM 12 6 Nooksack44 p Nooksack5S p to Fishtrap Creek confluence RM 13 2 Nooksack5 Fishtrap Creek confluence RM 13 2 to Nooksack4B x Nooksack p ScottDitch1 Kamm Ditch Stickney Slough Nooksack6 Kamm Ditch Stickney Slough RM 18 1 Nooksack5 Nooksack 4 X Please review the list of reaches that route to global reaches mainstem Columbia or Snake River or to estuarine marine reaches Multiple reaches can route to global reaches if necessary However each set of reaches must be Reaches that Route to Global Reach independent i e the EDT model is not designed to handled distributary Error Description channels Mainstem Nooksack to just below Sandy Lane Route Errors table identifies those reaches that an error was discovered in the routing table You can correct this in the previous Route Editing form or in the upper table The u
10. Ca m T it f Sr T T N o pole mg a bif ba ba 4 Djaja ho r BI boa bo Djaja cn 4 ba o cn ony on afifi J mm 2 2 J 2 o hJ mm mm Pa co 15 2 a o o O o Oo O SS el O Ss i O J on on on an fifili cn 4 oO _ evised Rating Shape Monthly Pattern Enter Rating Comments Template 74 x Edit Template T4 M Edit 74 ea f a03 f ect Ta ect 62 cai 74 ef eat i452 eat fi Dar 514 f ect 74 eat ff soe cit 76 eat Ao ect 76 eat isos f cat fi 76 cat iio2 cat fi 76 eat i162 f Edit 74 Edt 664 Edi 74 Egi 263 Edi 74 eat E 772 Edi 74 657 Edit Send Data to Excel Inzert from Excel i 7c Edit 4 ha 4 Figure 36 Habitat Attribute screen with flow high Select Hyrologic Characteristics from the Select Category drop down list select Flow Variation from the Select Sub Category drop down list and click on the FlwHigh button The FlwHigh data screen will appear as shown below The upper left portion of the screen provides a description of the attribute FlwHigh Directly to the right of the attribute definition a text box displays the definitions of the ratings from 0 through 4 Note that you must use the vertical scroll bar to view all five rating definitions in the box The Habitat Attribute Ratin
11. Datasets When the download is complete you may F Return to Stream Reach Main Menu Log Out Figure 8 Download Datasets screen from EDT Online 4 Click Download Datasets The File Download dialog box appears File Download x Q fou are downloading the file e ntiat_ 10643574991 33 AH zip from we mobrand com Would you like to open the file or save it to your computer cave Cancel More Infa M Always ask before opening this type of file Figure 9 File Download dialog box 5 Click on Save The Save As dialog box appears Stream Reach Editor User Manual May 2004 Page 6 EDT ECOSYSTEM OIAGHOSS amp TREATMENT 2 x Desktop My Documents as ter Compi File name kmobrand_E ntiat_1064357499133_RH zip v Save My Network P Save as type WinZip File Cancel Z A Figure 10 File Save As dialog box 6 Save the file to the same directory where you placed the Stream Reach Editor files Now that you have downloaded the Stream Reach Editor User Guide and dataset you are ready to log off from the EDT Online Web site and get the Stream Reach Editor set up and ready for use Getting the Stream Reach Editor set up This section describes getting the Stream Reach Editor tool ready for defining reaches and rating habitat attributes There are three steps involved in this process 1 launching the Stream Reach Editor application 2 unzipping the datafiles and
12. Online Web site Note that this is the directory into which you extracted the downloaded files for importing into the Stream Reach Editor 4 After completing the Export Data file step click on the Proceed button at the bottom of the screen which returns you to the Stream Reach Editor main menu 5 Return to EDT Online and follow the steps outlined for Uploading Draft Data to the EDT Web application 6 Select Upload Draft Data from the Stream Reach Main Menu page of EDT Online The Upload Draft Data screen appears STREAM REACH EDITOR Upload Data If you made changes to our Datasets with the offline Editor you may import them to our database for use with other EDT Online features Enter Dataset Name KM Entiat 4 24 03 E ete Test dataset I FIPTION r hard drive E Katie Export_StreamD Browse Please be patient after clicking the upload button below It may take a minute or two to upload your dataset Upload Figure 56 Upload Stream Reach Data screen from EDT Online Stream Reach Editor User Manual May 2004 Page 51 ECOSYSTEM DIAGNOSIS amp TREATMENT 7 Click Upload at the bottom of the screen An Upload Progress screen will appear 4rea Province Columbia Cascade Subbasin Entiat Screen Reach Editor Dataset Upload In Progress Your draft Dataset is being uploaded and saved to the online system Please be patient This may take a while especially if the dataset is large
13. You must repeat this process for all life stages and species affected by the obstruction Withdrawals To work with Withdrawals select Stream Corridor Structure from the Select Category drop down list and Obstructions from the Select Sub Category drop down list Click on the Withdrawals button to bring up the screen below Stream Reach Editor User Manual May 2004 Page 38 EDT ECOSYSTEM DIAGNOS amp TREATMENT Habitat Attribute Editor Subbasin Entiat ECOSYSTEM DIAGNOSIS amp TREATMENT Select Category 2 Stream Corridor Structure Select Sub Category 2 4 Obstructions Obstr widre Water withdrawals Rating 0 No withdrawals The number and relative size of water withdrawals in the stream reach Habitat Attribute Ratings Edit rating assumption focus month and data precision Send Data to Excel Insert from Excel Figure 42 Habitat Attribute Editor screen with water withdrawals With this screen you can rate the Withdrawals attribute number and relative size of water withdrawals in a reach This attribute identifies the risk of fish being entrained or injured by screening or other structures associated with water withdrawals from streams Generally you would use this attribute to account for smaller diversions such as single housing or small hobby farm type pumping or diversion systems Large water withdrawals associated with cities are better captured with the Obstruction button T
14. casei aa Du natel edescalne a ete aae aad toed eed ace ds 31 OVEN EW OFATI DEUTE Sironin tale set ace ATE comer einen lanseieeeantae 31 Data Toppur E cotaqho ame err errr tt Mer ect T int Reet eerste wer et E ot meen ner eerie ee er eee 22 Excepuons m Data MPU Esna a a e A EE 35 INE ca O10 VN kauri tree irar eter erence Tanta treet rer Tetra errr ern eee ere ant Teeter ern terre creer oT eee Tere er eT ere tery 41 Overview o PTO CS Serec enn A 41 Data Input Exampl seniai Eer o AE EA EE ATE E E E AAE 41 Biolos ikale onn tu by oenen a 44 ROVEEVIEW Ol ANTI DUES aro EA EEA T E O ENAT ACE a 44 Data Tit Px Ale eeno N O E RUE EE N E 44 Copying Habitat Data from One Reach to AnotheTr eeseeeseseesereserisresrsrrsrsresreresresesrestsrestesrerestsreresresesresrees 47 Using Excel to View and Enter Habitat Data ee eeesseeseceeeesecseesseeseeesecseesesssesseseeeeaeseseaeeseesseseaeeaes 48 Exporting and Uploading your New Stream Reach Dataset sssscssscsssssssccssecssesssecssssesseesssssceesseeees 49 ECOSYSTEM DIAGNOSIS amp TREATMENT Introduction The first major task in subbasin assessment using EDT Online is defining or profiling the environment for the area you are analyzing This task is currently accomplished through the use of the offline Stream Reach Editor tool downloaded from the EDT Online Web site Who will use the Stream Reach Editor This User Manual provides step by step instructions for working with the Str
15. steps 1 Extract all text files from the zip file downloaded from EDT Online this will require software to unzip these files 2 Set path to local zip file directory 3 Begin import after confirming that all files were successfully found on the local directory total of nine files 4 Confirm successful data import Figure 13 Extract Data Files screen 2 Navigate with Windows Explorer to the directory where you downloaded your stream reach dataset file and double click on it The contents of the zip file are shown below WinZip Jane_Doe1035157591789_RH zip File Ac tions O Opti Ons Help D a 9 Add Extract View CheckOut Wizard 2 1_Attribute_Data txt Text Document 10 20 02 4 46 PM 122 869 81 1_Attribute_Data_Documentation txt Text Document 10 20 02 4 46 PM 182 780 93 1_Hatchery_Program_Data txt Test Document 10 20 02 4 46 PM 0 2 1_0bstruction_Attribute_D ata txt Test Document 10 20 02 4 46 PM 0 2_Pattern_Data tst Text Document 10 20 02 4 46 PM 85 2_Pattern_Data_Documentation txt Text Document 10 20 02 4 46 PM j 85 3_Reference_Sources txt Text Document 10 20 02 4 46 PM 0 5_Basin_Hydrography txt Test Document 10 20 02 4 46 PM l 80 6_Reach_Data txt Test Document 10 20 02 4 46 PM E 85 HARD _info tst Text Document 10 20 02 4 46 PM 25 Selected 0 files 0 bytes Total 10 files 318KB Figure 14 Data files within the downloaded dataset zip file NOTE The
16. the various file download times the larger files may take several minutes with a dialup modem Before You Begin Before you can begin to use the Stream Reach Editor to define strea reaches and rate habitat attributes you must download the tool and data from the EDT Online Web site and get it set up offline This section describes these procedures Downloading the Stream Reach Editor Documentation and Data This section describes how to download the Stream Reach Editor User Manual the Stream Reach Editor offline tool and a stream reach dataset from the EDT Online Web site To download the User Guide and Stream Reach Editor 1 Goto the EDT Online Web site http www mobrand com edt 2 Click on the desired Sponsor Logo e g the Northwest Power and Conservation Council Select your area province and click on Go 4 Login OY register as a public user 5 Select your subbasin from the drop down list in the center of the page and click on Go The EDT Main Menu appears 6 Click on Stream Reach Editor from the EDT Main Menu page The Stream Reach Editor Main Menu appears Stream Reach Editor User Manual May 2004 Page 2 EDT Online Main Menu Subbasins EDT ECOSYSTEM OIAGHOSS amp TREATMENT Reports Cer Accounts Populations Scenarios Log Out Subbasin Entiat STREAM REACH EDITOR MAIN MENU Download Editor and User Manual Download the offline Stream Reach Editor and cr
17. Data Export Stream Reach Data Reach Editor Attribute Editor Exit Begin Offline Session Select from menu bar 1 First time users need to import data files from EDT Online using Import Stream Reach Data 2 After reviewing reach ratings upload to EDT Online using Export Stream Reach Data 3 Review and edit add reaches to the stream reach dataset using Reach Editor 4 Review and edit the reach ratings using Attribute Editor 5 Close EDT Stream Reach Editor using Exit Figure 12 Stream Reach Editor Main Menu screen NOTE This screen describes the functionality of the menu buttons that are located across the top of the page It does NOT represent the order in which the steps will be taken when using the offline Stream Reach Editor Now that you have launched the Stream Reach Editor you are ready to to unzip the dataset that you downloaded from EDT Online Stream Reach Editor User Manual May 2004 Page 8 ECOSYSTEM DIAGNOSIS amp TREATMENT Extracting the data files 1 Click on the Import Stream Reach Data button on the left end of the navigation bar on the Stream Reach Editor Main Menu page The Step 1 Extract Data Files screen appears import Stream Reach Data miot stteath tech Wata Export stream keach Wata Reach catar AAHBULe Editar Step 1 Extract Data Files From Zip Download This process will import the stream reach dataset that was downloaded from EDT Online Data import requires the following four
18. Export Stream Reach Data Attribute Editar Habitat Attribute Select attribute from list then review definition and rating rule Select Category 1 Hydrologic Characteristics Select Sub Category 1 1 Flow variatian FilavAigh FlyLow FhvDielvar FhvintraAnn Flow change in interannual variability in high flows The extent of relative change in average peak annual discharge compared to an undisturbed watershed of comparable size geology orientation topography and geography Cor as vould have existed in the pristine state Evidence of change in peak tow can be empirical where sutticiently long data series exists can be based on indicator metrics such as Tamean see Konrad 2000 or inferred from patterns corresponding to watershed development Relative change in peak annual discharge here iz based on changes in the peak annual flay expected on Rating O Peak annual flows expected to be strongly reduced lrelative to an undisturbed watershed of similar size geclogy onentation topography and geography or the pristine state for the watershed of interest OR gt 40 and 100 decrease in Q2yr based on a long time seres 40 yrs or longer with at least 20 yrs pertaining to la watershed development state or as known by regulated flow levels This condition i associated with flow regulation or water diversion projects Habitat Attribute Ratings Edit rating assumption focus month and data precision vy T aa EI aa
19. J This reach routes to a global reach dit Reach Routing estuary Columbia mainstem etc Split an Existing Reach into an or MV This reach leaves subbasin Reach Description enters mainstem Test Routing Upper and Lower Reach Entiat 1 From Columbia River to End of slack water Length Delete Reach cauti PRS mi 0 6 e ach caution de s KM 4 gt rl reach and all associated data Reach 1 of 119 Exit to Main Reach Menu Figure 24 Edit Reach Routing Screen Stream Reach Editor User Manual May 2004 Page 16 ECOSYSTEM DIAGNOSIS amp TREATMENT NOTE This function allows you to change routing data IMPORTANT Edits made through this screen are written directly to the database there is no save feature for this screen Therefore make edits with caution 2 Select a reach to route by scrolling through the navigation buttons in the lower portion of the screen OYr right clicking in the Reach Name box to bring up the filter sub menu and type an entry in the Filter for field 3 Select reaches from each of the three drop down boxes Upstream Tributary Upstream and Downstream 4 Continue selecting and routing reaches until you are finished 5 Click on the Test Routing button in the center of the screen to verify that the reaches are routed correctly NOTE During export to the web the Stream Reach Editor checks for valid reach routing If routing is incorrect the d
20. Processing os Time 0 31 Status LOG start Time Surrent Time O9 24 03 03 4 Figure 57 Dataset Upload in Progress screen NOTE Processing time may take a few minutes Stream Reach Editor User Manual May 2004 Page 52 ECOSYSTEM DIAGNOSIS amp TREATMENT 4rea Province Columbia Cascade Subbasin Entiat 5s TREAM REACH EDITOR Dataset Was Uploaded Successfully Your draft Dataset has been saved to the online system and is naw available for online use You may use the Population Editor to define fish populations for the subbasin then run Reports on the dataset You may Register your draft as the official dataset for your subbasin Figure 58 Successful Upload message At this point your dataset is uploaded to EDT Online and you can use the Population Editor on EDT Online Web site to create a population and then run reports on the dataset Stream Reach Editor User Manual May 2004 Page 53
21. age 22 ECOSYSTEM OIAGHOSS amp TREATMENT Reach Definition Reach name description length and organization within subbasin Reach Mame must be unique for B Reach Description This i an obstruction reach culvert falls dam etc Reach Length mile Patient Template Watershed Name Watershed Code Coptionaly Sub iWatershed Mame SuUb vatershed Code Coptionaly stream Mame Stream Code optional rESCTCNrrnwrw 0 a _CG C Oo Figure 32 Reach definition form Geographic Area for Diagnostic Summaries T 2 Enter a unique name in the Reach Name field you can use numbers letters dashes etc NOTE We suggest that you name reaches starting at the mouth and working your way to the headwaters of the stream 3 Provide a description of this reach in the Reach Description field that clearly denotes where the reach starts and ends 4 Enter the length of this reach for both the Patient and Template conditions in the Reach Length fields enter the length in miles 5 Check the This is an obstruction reach box if the reach you are describing is an obstruction to either juvenile or adult migrants e g dams culverts or waterfalls NOTE If you check this box the Reach Length box grays out In EDT obstruction reaches are given zero length so that survival past this point can be rated as an instantaneous value e g 95 survival through a turbine 6 Provide the name of your watershe
22. an ___10fMad 3_ Pine Flatto Camp 9 O O O O O O O O O O O O O OOOO O Upper and Lower Reach 11 Entiat 6_____________ Entiat 6 From Mad River to Mud Creek Length mi 1 2 Z 12 Mud 1 Mud Creek S O Delete Reach caution deletes 13 Entiat 7 ___________ Entiat 7 From Mud Creek to R S Bridge Length mi 2 2 O Z reach and all associated data __15 Potato 1 Potato Creek _ O O O O O O O O OOO O Exit to Main Reach Menu 16 Entist 9 Enttiat 9 From Potato Creek to Potato Moraine Length mi 0 9 Refresh Screen Figure 21 Edit Reach Name and Description screen NOTE When you make changes to data on this screen your changes will be written immediately to the database there is no save function associated with this screen Therefore make changes cautiously 2 Click on a cell in the first column the sequence number column to enter a new number if desired NOTE The reach sequence number SeqNo for example determines the order in which the reaches will be displayed Typically SeqNo increases from mouth to headwaters SeqNo is not critical to the function of the model but can be helpful for navigation 3 Click on a cell in the second column reach name to make any desired changes to the text NOTE Choose names carefully The numerical suffix should increase from mouth to headwater Obstruction reaches should be clearly identified e g Rock Cr 1B dam or Rock Cr 1B culvert 4 Click
23. at comprise this sub category you may enter either a value from 0 to 4 or an actual percent value for each reach Percent values may be entered as 10 or 0 1 Obstructions To work with Obstructions e g culverts dams waterfalls select Stream Corridor Structure from the Select Category drop down list and Obstructions from the Select Sub Category drop down list Click on the Obstructions button to bring up the screen below Stream Reach Editor User Manual May 2004 Page 35 ECOSYSTEM DIAGNOSIS amp TREATMENT Habitat Attribute Editor Q a Subbasin Entiat Import Stream Reach Data Export Stream Reach Data Reach Editor Attribute Editor Exit Habitat Attribute Select attribute from list then review definition and rating rule Select Category 2 Stream Corridor Structure x Select Sub Category 2 4 Obstructions Obstr VWdrwl Obstructions to fish migration Rating 0 None documented or inferred Obstructions to fish passage by physical barriers not dewatered channels or hinderances to migration caused by pollutants or lack of oxygen Habitat Attribute Ratings Edit rating assumption focus month and data precision Obstruction Obstruction ff Obstruction pssung MEA ll General help information for using the Obstruction Editor Functions Reach Name No Reach Reach fEntiet 1 Ct TCU Obstructions culverts dams waterfalls etc are their own reaches Entiat 2 se Jajo o a The EDT model treats the
24. at 1 Fe Enitiat 2 F Entiat 3 Roaring 1 FF Entiat 4 F Entiat 5 Mad Tilicum F Entiat 7 Fe Enitiat 3 Potata 1 FF Entiat 3 Fe Entiat 10 m Stormy 1 FF Entiat 11 FF Entiat 12 Fe Enitiat 13 E Select all reaches for co Instructions Data shown is for the reach cursor location lf you wish to copy data from a different reach then close this form and move your cursor to the correct reach Options for copying data are original ratings revised ratings focus month data precision and data comment id After selecting copy options then identity reaches to copy data Close form when complete You will see new ratings in the revised ratings column of the Editor teven if copying the original ratings IMPORTANT ou must save the data to make these changes permanent Close Figure 49 Select Copy Options Screen 5 Select Copy Data The data will be copied to the reaches selected Click Close to return you to the Habitat Attributes screen The new ratings will be visible Using Excel to View and Enter Habitat Data The Stream Reach Editor allows you to export habitat attribute data into Microsoft Excel so you can edit the data and then import it back into the Stream Reach Editor to complete your analysis This is particularly useful if you wish to plot your data using Excel features When exported the Excel file will be protected against any formatting changes If
25. ata can still be uploaded to others to access however the dataset cannot be used to run reports or create populations 6 If the reaches are not properly routed an error message appears Roul E IES x x Route errors discovered open route Form to view and edit errors GK Figure 25 Route Error Testing Message 7 Click OK The Edit Reach Routing screen appears The View Edit Route Error option is now available highlighted in yellow Stream Reach Editor User Manual May 2004 Page 17 EDT ECOSYSTEM DIAGNOSIS amp TREATMENT Edit Reach Routing Subbasin Entiat Import Stream Reach Bata Export Stream Reach Data Reach Editor Attribute Editor Exit Menu Options Upstream Tributary Reach Reach Description O H Edit Reach Sequence Hame and Description Upstream Reach Feach Mame Entiat 2 Edit Reach Length Edit Reach Hierarchy Structure Down Reach Mame Downstream reach is global re yf This reach routes to a global reach Edit Reach Routing OF estuary Calumbia mainstem etc ae lt I This reach leaves subbasin Split an Existing Reach into an Reach Description enters mainstem Test Routing Upper and Lower Reach Entiat 1 From Columbia River to End of slack water Length View Edit Route Errors imij 0 6 Delete Reach caution deletes reach and all associated data Exit to Main Reach Menu Figure 26 Edit Reach Routing Screen with View Edit Route Errors Option
26. cum Creek O Split an Existing Reach into an Tilicum t Tilicum Cresk CC Upper and Lower Reach Mad 2 Tilicum CreektoPineFlat O O Mad 3 Pine Flatto Camp 9 Delete Reach caution delete Entist 6 Entiat 6 From Mad River to Mud Creek Length m 12 reach and all associated data Pt Mudd Mud Creek O mek eee ee T ed ee M AO Miela l a idb Mi A Exit to Main Reach Menu Delete Reaches Figure 31 Delete Reach from Database screen 2 Click each reach that you wish to delete from the database NOTE You will need to scroll vertically to see all of the reaches 3 Click the Delete Reaches button at the bottom of the screen Now that you have edited existing reaches you are ready to begin adding new reaches your reach structure Creating New Reaches This section describes the procedure for adding new reaches to your reach structure Click on the Creating New Reaches for Subbasin button on the Reach Editor main menu screen The Creating New Reaches for Subbasin form that appears is divided into two sections the Reach Definition input form and the Reach Routing input form These two sections will be discussed separately To define new reaches 1 Click on the Create New Reaches for Subbasin button on the Reach Editor Main Menu screen The Create New Reaches for Subbasin screen appears containing the Reach Definition form shown below Stream Reach Editor User Manual May 2004 P
27. d in the Watershed Name field 7 Provide a subwatershed name for your dataset in the Sub Watershed Name field 8 Provide the USGS 4th HUC code for this reach in the Watershed Code field required 9 Provide the USGS 6t Field HUC Code for this reach in the Sub Watershed Code field required 10 Enter another type of stream classification code in the Stream Code optional Now that you have defined a new reach you are ready to move to the bottom of the screen to the reach routing portion to route the new reach To route new reaches 1 Use the bottom of the screen to input reach routing data Stream Reach Editor User Manual May 2004 Page 23 ECOSYSTEM OIAGHOSIS amp TREATMENT Reach Routing Select from list the downstream reach upstream reach and upstream tributary reach Reach Routing Upstream Tributary Reach Last step for new reaches Reach Mame must be unique for Upstream Reach reach routing Subhasini This is critical for proper ro Downstream Reach for running lite history traje OF This reach leaves subbasin Centers mainstem Figure 33 Reach routing form NOTE Use the fields in this input form to hydraulically link stream reaches 2 Enter a unique name in the Reach Name field 3 Select the name of the stream reach directly upstream of this reach from the drop down list in the Upstream Reach field 4 Select the name of the stream reach directly downstream of this reach
28. dit reach name sequence number Ratings data fields or any fields that are grayed out not required Depending upon the attribute being edited you should be able to edit all or a portion of the fields described below Habitat Attribute Editor gt a Subbasin Entiat Import Stream Reach Data Export Stream Reach Data Reach Editor Attribute Editor Habitat Attribute Select attribute from list then review definition and rating rule Select Category 4 Biological Community Select Sub Category 4 1 Community Effects z FshComRch FshPath FSplntro Harass HatFOutp PredRisk SalmCarcas Predation risk Rating 0 Many or most native predators are depressed or rare Level of predation risk on fish species due to presence of top level Inone are greatly increased over natural levels and there carnivores or unusual concentrations of other fish eating species This is a IIs expected a significant numerical survival advantage classification of per capita predation risk in terms of the likelihood ito fish as a result compared to historical predator magnitude and frequency of exposure to potential predators assuming abundance other habitat factors are constant NOTE This attribute is being updated to distinguish risk posed to small bodied fish 10 in from that to large bodied fish 10 in Focus Mon No Data Precision Enter Rating Comments a Template Template Edit Edit E BES E EES E 54 edit 54 54 x eat 54
29. e selected online dataset for viewing editing purposes When you make edits in the offline Editor you are not changing the online data when you Upload a dataset you are not replacing any existing datasets you are creating a new draft dataset that uses the original dataset as a baseline starting point Select a dataset you would like to use with the Editor from the drop down list below and then click Proceed Select Datasetto Download Figure 6 Download Stream Reach Dataset Copy screen from EDT Online Stream Reach Editor User Manual May 2004 Page 5 a ECOSYSTEM DIAGNOSIS amp TREATMENT 2 Select a dataset from the drop down list at the bottom of the page Select a dataset you would like to use with the Editor from the drop down list below and then click Proceed Entiat 4 30 U2 reqistered Please be patient after clicking the proceed button below It may take a minute or two to prepare your dataset for download Once the dataset is prepared you will be forwarded to the next screen and provided a download link to click Proceed Figure 7 Dataset drop down list NOTE Public users will see on the registered dataset for the subbasin in the list users with assigned permissions will see other datasets 3 Click on the Proceed button This brings up the Download Datasets screen 5 TREAM REACH EDITOR Download Datasets Click the button below to complete your dataset download Download
30. e to and select the Excel file that you previously exported Click Open The data will be imported into the Stream Reach Editor 4 Click Save Changes to save the newly imported data 5 Save the Excel file 6 Click Close to return to the Main Stream Reach Editor menu Exporting and Uploading your New Stream Reach Dataset Once you have defined your stream reach structure and rated your habitat attributes you are ready to export your dataset for upload to EDT Online Stream Reach Editor User Manual May 2004 Page 49 ECOSYSTEM DIAGNOSIS amp TREATMENT This section describes how you export your stream reach dataset and upload it to EDT Online To export your dataset 1 Click on the Export Stream Reach Data button on the navigation bar on the main menu page of the Stream Reach Editor The Export Stream Reach Data Step 1 Begin Data Export screen appears EDT Stream Reach Editor a Export Stream Reach Data EDT Subbasin Entiat ECOSYSTEM DIAGNOSIS amp TREATMENT meot stream keach Wata Export stream heen Wata ditar AHO Editar Exit Step 1 Begin Data Export This process will extract the data tables as text files and create a zip file for uploading to EDT Online Data export requires three steps 1 First you will create a local directory for your stream reach data by clicking button below you will need to note location and file name 2 Export data file to directory 3 Confirm succe
31. eam Reach Editor and is written for the following groups e General public e Subbasin work groups e Subbasin administrators EDT Online allows users with varying levels of permission to edit view stream reach data All user groups may download the Stream Reach Editor User Manual and datasets and thus may use the editor to create new datasets However only authorized subbasin work group members and subbasin administrators may upload new datasets to EDT Online What you should know This manual assumes a familiarity with basic operating system functionality such as copying saving and deleting files and installing applications familiarity with various utilities such as unzipping files and familiarity with Web based activities such as navigation and filling in forms What software and hardware you will need The offline Stream Reach Editor requires a PC with Windows 98 NT4 or later operating system and MS Access 2000 installed It is also necessary to have file expansion software such as Winzip or Aladdin Stuffit and Acrobat Reader for viewing the documentation The Stream Reach Editor is a component of the EDT Online Web site which may be accessed from a variety of operating systems through various Browsers and across a range of Internet connections T 1 DSL line cable modem or dial up modem Your Internet connection will Stream Reach Editor User Manual May 2004 Page 1 ECOSYSTEM DIAGNOSIS amp TREATMENT affect
32. eate your own subbasin datasets File size for the Editor is 2 6 MB You must have a Windows operating system with MS Access installed on your hard drive to use the Editor File size for the User Manual is 2 17 MB The Manual is in Adobe Acrobat format Download Data Download baseline reach definitions and habitat attribute profiles to use with the Stream Reach Editor Upload Draft Data Once you have edited the data offline come back here to upload your new draft data to our online database Delete Draft Data Permanently remove draft data from our database Register Draft Data Register your draft as the official data for your subbasin ECOSYSTEM DIAGNOSIS amp TREATMENT Describe the environment with the d own loa d Data Edit the data on your computer to create your subbasin dataset When finished come back to EDT Online to upload and register your dataset for use with the Fish Population Editor Builder and Report Generator Figure 1 Stream Reach Editor Main Menu screen from EDT Online Note Download Editor Download Data If you are a public user you will not see all of the options listed on this main menu page you will not be able to upload revised datasets Subbasin work group members with permissions from the subbasin administrator will see more menu options and will be able to upload revised datasets run reports on them and delete their own draft datasets Click on Do
33. ed NOTE When the category and subcategory are selected you will see the individual attributes that are assigned to this category displayed across the top of the page as buttons as shown below 3 Click on a specific attribute to begin rating e g FlwHigh The next sections describe in detail how you use the Habitat Attribute Editor to work with the attributes They will be discussed by major category Hydrologic Characteristics Hydrologic Characteristics is the first major category of attributes We will provide an overview the attributes in this category and a data input example There is also a section describing the Hydrologic Regime attributes Overview of Attributes As outlined above the Hydrologic Characteristics category is divided into two sub categories Flow Variation and Hydrologic Regime Flow Variation is composed of the following attributes e Flow High FlwHigh e Flow Low FlwLow e Flow Diel Variation FlwDielVar e Flow Intra annual Variation FlwIntraAnn Hydrologic Regime includes these attributes e Regime Natural Regime Nat e Regime Regulated Regime Reg Stream Reach Editor User Manual May 2004 Page 26 ECOSYSTEM DIAGNOSIS amp TREATMENT Data Input Example We will use FlwHigh as the example to describe how data for the Hydrologic Characteristic Attributes are entered Habitat Attribute Editor SUbbasin Entiat EDT M DIAGNOSIS amp TREATMENT Import Stream Reach Data
34. en entered for the remaining months the model assumes that high flow is not an issue for these months Some key points to remember in shaping a monthly flow pattern e Use values from 0 to 1 otherwise the function does not work properly e Assign a value of 1 for both the Focus Month and any other months where you want the model to assign the full effect of the rating If you want 50 of the effect to be modeled use a 0 5 if 25 assign a value of 0 25 etc After you have created a pattern it is automatically assigned a pattern number and is added to the list of patterns so that you can assign this same pattern to additional reaches if desired Enter Rating Comments Enter comments to support your rationale for the attribute rating or the flow pattern used or more likely both The database keeps a running list of all comments entered so that you can assign the same comment or data source to multiple reaches or attributes Additional Comments about Hydrologic Regime Attributes Selecting the category Hydrologic Characteristics and the sub category Hydrologic Regime displays the attributes Regime Nat natural hydrologic regime and Regime Reg regulated hydrologic regime The attribute Regime Nat is used to indicate which of five distinct patterns best characterizes the seasonal pattern of flow over a year The particular natural hydrologic regime indicated here affects the opeartion of various rules e g t
35. es that withdrawals have no effect this also holds true for months where a zero appears Some key points to remember in shaping a monthly pattern e Use values from 0 to 1 otherwise the function does not work properly e Assign a value of 1 for both the Focus Month and any other months where you want the model to assign the full effect of the rating If you want 50 of the effect to be modeled use a 0 5 if 25 assign a value of 0 25 etc After you have created a pattern it is automatically assigned a pattern number and is added to the list of patterns so that you can assign the same pattern to additional reaches if desired Enter Rating Comments Enter comments to support your rationale for the attribute rating or flow pattern used or more likely both The database keeps a running list of all comments entered so that you will be Stream Reach Editor User Manual May 2004 Page 40 ECOSYSTEM DIAGNOSIS amp TREATMENT able to assign the same comment or data source to multiple reaches or attributes Water Quality Water Quality is the next major category of attributes We will provide an overview the attributes in this category and a data input example Overview of Attributes The Water Quality category is divided into two sub categories hemistry and Temperature Variation Chemistry is composed of the following attributes e Alkalinity Alk e Dissolved Oxygen DisOxy e Metals In The Water Column MetWatCal
36. f Edit 133 Edit ae 80 ecit 82 gt B2 213 80 eit 719 E ost eat ost eat fiogr cat 80 Edt Edit S06 80 it Edit Edit 91 Edi Edit m m mim im im m ojo ojo j2 2 2 fe fe fe fe 4 eee eee apagagiaga Ym i oO a a e 4 4 4 4 4 4 4 4 4 4 4 4 4 4 d BIj hij ee R hd amp ony on on cn 4 aqyajqa 4 on on on an 4 ifiji 4 a E E D D a a a 4 aya Send Data to Excel Insert from Excel Figure 38 Habitat Attribute screen with channel width Select Stream Corridor Structure from the Select Category drop down list select Channel morphometry from the Sub Category drop down list and click on the WidthMx button The following screen will appear The upper left portion of the screen provides a description of the attribute WidthMx Directly to the right of the attribute definition a text box displays the definitions of the ratings from 0 through 4 Note that you must use the vertical scroll bar to view all five rating definitions in the box Also note that categorical values are no longer used for width you enter widths in feet The Habitat Attribute Ratings portion of the screen is where you will enter or edit the data Note that you will not be able to edit reach name sequence number the first two ratings fields or any fields that are grayed out not required Depending upon the attribute you should be able to edit all
37. file contains ten txt files nine data files and one HARD_info text file 3 Extract these ten files into the same directory where you placed the downloaded zip file and the Stream Reach Editor files 4 Return to the Extract Data Files screen and click Proceed The Step 2 Locate Data Files screen appears Stream Reach Editor User Manual May 2004 Page 9 ECOSYSTEM DIAGNOSIS amp TREATMENT Import Stream Reach Data miot estean beach Data Export stream teach Weta Reach Editar Mtnpute editar Step 2 Locate Data Files Set paths you will be asked to locate the local directory and file named HARD_Info tt This is the same directory that the text files were extracted into in Step 1 Figure 15 Locate Data Files screen NOTE In this step you will be asked to set the path to the directory where the dataset files were downloaded and unzipped The Editor is looking for a file called HARD_info txt 5 Click on Set Paths at the bottom of the screen The Select Import File dialog box appears Look in ay Stream Feach Editor amp ag 2 HARD_info File name HAR D info Oper Files of type Text Cancel T Open as read only ve Figure 16 Select Import File dialog box 6 Click on Open The Step 3 Import Data Files screen appears Stream Reach Editor User Manual May 2004 Page 10 ECOSYSTEM DIAGNOSIS amp TREATMENT Import Stream Reach Data mior etrean keach wata E
38. ge in variability magnitude of high flows e Change in variability magnitude of low flows e Channel width e Bed scour e Icing e Turbidity e Dissolved oxygen e Water temperature e Predation risk stream Reach Editor Pattern Editor Use to createfedit a monthly pattern for a particular attribute Pattern ID Pattern Description Pattern Mame FlowHigh P1 Patterns created for Entiat by work team 2001 5 I 1 I I Figure 37 Stream Reach Editor Pattern Editor To assign a monthly pattern to FlwHigh click on the Edit button to produce the Stream Reach Pattern Editor Screen shown below Use this screen to create edit flow patterns and assign attribute ratings by month To begin simply place a 1 in the month s where you want the full effect of the rating to be expressed Note that you should define at least one of these months in the Focus Month field Next shape the pattern so that it expresses how the effect changes by month Be sure to Stream Reach Editor User Manual May 2004 Page 29 ECOSYSTEM OIAGHOSIS amp TREATMENT click on the Save Changes button to have your changes be written to the database If you click on the Close button before saving you will be prompted to save The example shown in the screen capture above indicates high flows have the largest effect on this reach in June followed by May only 33 of the effect assigned to June July 25 and April 10 Because values have not be
39. gs portion of the screen is where you will enter or edit the data Note that you will not be able to edit reach name Stream Reach Editor User Manual May 2004 Page 27 ECOSYSTEM DIAGNOSIS amp TREATMENT sequence number the first two ratings fields or any fields that are grayed out not required Depending upon the attribute you should be able to edit all or a portion of the fields described below Revised Ratings Change the existing ratings for the Template T or Current C condition Focus Mon No Select the focus month from ths drop down list see discussion on Shape Monthly Pattern below for details on how to identify your focus month Data Precision Enter 1 if the data entered is Categorical or 2 if Non Categorical Note that if this field is shaded gray then data precision is always non categorical Categorical ratings may be either continuous or discrete and are coded simply as the integers 0 through 4 For attributes categorized in terms of a range of values a categorical rating is modeled as the mean of the attribute values that define the range For example Fine Sediment is categorized by five ranges of percent fines in the substrate A rating of 3 is associated with the range 18 to 30 fines and is modeled as the mean of this range or 24 Approximate categorical ratings of this kind are entirely appropriate when knowledge of the atual conditions in a particular reach is incomplete Sometimes howeve
40. he impact of fine sediment on incubating eggs will be less in reaches with a groundwater dominated hydrologic regime than in reaches with a rainfall dominated pattern Importantly the natural hydrologic regime selected here will NOT generate a default pattern for other hyrologic attributes That is to say selecting a rainfall dominated natural hydrologic regime for Regime Nat will not cause the patterns that shape Stream Reach Editor User Manual May 2004 Page 30 ECOSYSTEM DIAGNOSIS amp TREATMENT FlwHigh or FlwLow to chage to the default pattern for rainfall dominated areas The attribute RegimeRegis largely an artifact of an earlier model The planner should ignore the rating definiations for this attribute Instead Regime Reg should be used mainly a a mnemonic device for the planner If a value is entered for Regime Reg for a particular reach it should be used as a reminder to the planner that a natural hydrologic regime has been distorted in the reach In turn this reminder should lead to a revision of one or more patterns for other hydrologic characteristics An example of a situation where revising one or more patterns for a hydrologic characteristic may be needed would be a reach below a major irrigation diversion The pattern for low flow would likely be altered in this reach especially if the timing of maximum withdrawal did not conincide with the natural period of minimum flow Stream Corridor Structure Stream Corridor Str
41. his screen works the same as those that have been described for other habitat attributes Ratings are entered in the Revised Rating cells and the proposed pattern is entered using the Edit button under Shape Monthly Pattern If you click this button you will see the pattern screen below Stream Reach Editor User Manual May 2004 Page 39 ECOSYSTEM DIAGNOSIS amp TREATMENT yo apes E e OSEE ie y iL Fn T f Ta MLE EENI Stream Reach Editor Pattern Editor Use to createfedit a monthly pattern for a particular attribute Pattern ID Pattern Description Pattern Name With P2 Patterns created for Entiat by work team 2001 Rating Figure 43 Stream Reach Editor Pattern Editor Use this screen to create edit withdrawal patterns and assign attribute ratings by month To begin simply place a 1 in the month s where you want the full effect of the rating to be expressed Note that you should define at least one of these months in the Focus Month field Next shape the pattern so that it expresses how the effect changes by month Be sure to click on the Save Changes button to have your changes written to the database If you click on the Close button before saving you will be prompted to save The example shown in the screen capture above indicates withdrawals have the largest effect on this reach from May through October Because values have not been entered for November and December the model assum
42. iat 1 Upper and Lower Reach Mud Creek v Up Columbia Entiat w Delete Reach caution deletes j Up Columbia Entiat Y reach and all associated data e Up Columbia Entiat v Potato Creek v Up Columbia Entiat Y v Exit to Main Reach Menu Esi l Figure 23 Edit Reach Hierarchy screen IMPORTANT Changes are written immediately to the database there is no save function associated with this screen Therefore make changes cautiously NOTE You must use both horizontal and vertical scroll bars to see all of the data If there is no information in the Geographic Area drop down list you will need to enter new data Your new entries will appear in the drop down list for use with other reaches 2 Make desired edits by selecting entries from the drop down lists in all but the first column NOTE It is important to indicate the correct 6th field HUC sub watershed for each reach To edit reach routing 1 Click on the fourth button under Menu Options Edit Reach Routing which brings up the following screen Edit Reach Routing Subbasin Entiat import Stream Reach Data Export Stream Reach Data Reach Editor Attribute Editor Menu Options dit Reach Sequence Name nd Description Upstream Tributary Reach Reach Description Upstream Reach f Reach Name Entiat 2 x dit Reach Length dit Reach Hierarchy Structure Down Reach Name Downstream reach is global re
43. iption _ Upstream Reach Name Edit Reach Sequence Name and Description Edit Reach Length Edit Reach Hierarchy Structure K 4 gt bl Downstream Reach Description Edit Reach Routing Downstream Reach Name Reach of Split an Existing Reach into an Upper and Lower Reach Original Reach Description Split Reach for Entiat 1 From Columbia River to End of slack water a tributary confluence Delete Reach caution deletes Length mi 0 6 Split Reach insert reach and all associated data al Obstruction Reach Save Exit to Main Reach Menu Figure 28 Split Existing Reaches screen NOTE This feature is typically utilized when there is a need to add additional small tributaries or obstructions such as a culvert into the database Select a reach using the navigation buttons at the left of the screen or right clicking on the shaded Reach Name box and using the filter sub menu NOTE You cannot input data to this screen directly you must select the tributary confluence or obstruction reach option in order to access the actual data input data screen Stream Reach Editor User Manual May 2004 Page 19 ECOSYSTEM DIAGNOSIS amp TREATMENT To split reaches to add tributaries 1 Click on the Split Reach for tributary confluences button to add a tributary that enters in the middle of a reach for example The following screen appears Upstream Reach Description Upstream Reach Mame Do
44. les in the Reach Description field For example for Entiat 1A describe the reach as Entiat River from mouth to unnamed RB tributary RM 0 0 to 1 8 NOTE The split reach feature uses the length for the reach being split as the default length for the two new reaches To change the reach lengths for the two new reaches use the Edit Reach Length button described previously Obstruction reaches always have a length of zero and therefore you will not enter a length value 4 Click on the Save button near the bottom of the screen 5 Continue splitting reaches for obstructions as desired To delete reaches 1 To delete reaches from your dataset click on the sixth button under Menu Options Delete Reaches to bring up the following screen Stream Reach Editor User Manual May 2004 Page 21 ECOSYSTEM DIAGNOSIS amp TREATMENT Delete Reach from Database Subbasin Entiat aonb stream Reach Wata Exhar stream Reach Wata Reaeh Editar Sttribute Editar Exit ReachHame Description O O O o o o O Coo ne Description OCC Oo No Description CC Edit Reach Sequence Hame Entiat 2 Entiat 2 i i idge in 2 and Description Entiat 3 ss Entiat 3 From Fire Station Bridge to Roaring Creek Length mi 3 Edit Reach Length er Oct Entit A No Description CCCs Edit Peach HierarchySiructure i a ee art Entiat 5 Entiat 5 From WS Bridge to Mad River Length mi 18 Madd Mad River Mouth to Tili
45. m Successful Import screen 8 Click on Proceed at the bottom of the screen to return to the Stream Reach Editor Main Menu Stream Reach Editor User Manual May 2004 Page 11 ECOSYSTEM DIAGNOSIS amp TREATMENT Now that you have the Stream Reach Editor launched and loaded with data you are ready to proceed to the heart of the process defining your reach structure Defining the Reach Structure This section describes the process of defining or profiling your reach structure with the offline Stream Reach Editor You will start with the stream reach dataset that you downloaded from the EDT Online Web site and imported into the Editor NOTE You may also use the process described in this section for editing reaches to simply review your dataset before making any revisions additions or deletions This section will address separately the procedures followed for editing existing reaches and for creating new reaches In working with the many forms described in this section it is useful to use a filter function to find specific entries or to display a group of similar entries To use the filter function 1 Select the cell containing the entry of interest 2 Right click in that cell bringing up the filter sub menu 3 Select Filter by Selection which refreshes the screen to show only those entries that share the same information as displayed in the selected cell or selection the Filter on and t
46. me pattern for both the WidthMx and WidthMin attributes Alternatively these widths could be scaled to the 0 to 1 range used in the other patterns in which 1 represents the maximum width and amsller numbers represent the ratio of the expected width to the maximum width Remember to click on the Save Changes button to have your changes written to the database If you click on the Close button before savign you will be prompted to save Stream Reach Editor User Manual May 2004 Page 34 ECOSYSTEM DIAGNOSIS amp TREATMENT After you have created a pattern it is automatically assigned a pattern number and is added to the list of patterns You can use the pull down feature to assign the same pattern to additional reaches if desired Enter Rating Comments Enter comments to support your rationale for the attribute rating or the pattern used or more likely both The database keeps a running list of all comments entered so that you will be able to assign the same comment or data source to multiple reaches or attributes Exceptions in Data Input The description of the fields and corresponding instructions given above apply for the most part to all attributes Exceptions are presented below Habitat Type To work with Habitat Type attributes select Stream Corridor Structure from the Select Category drop down list and Habitat Type from the Select Sub Category drop down list For the eight habitat attributes th
47. o provide general documentation about the obstruction as follows e Obstruction name e Description e Comments optional e Select the obstruction type from the drop down list The lower portion of the screen is for entering passage assumptions by making selection from the following drop down lists e Species e Life stage Stream Reach Editor User Manual May 2004 Page 37 ECOSYSTEM DIAGNOSIS amp TREATMENT e Migration direction denotes whether the survival data entered in the month boxes applies to upstream or downstream migrants e Focus month denotes the month with the highest survival Also enter data for e Percent effective passage in focus month percent survival for this month for the target life stage and species e Percent survival by month percent survival e g 0 95 or 95 for all months for the target life stage and species note that if you leave this field blank the model assumes that survival is 100 Once you have filled in all of the fields you must save your work Save Changes before adding another record e g species or life stage To add another record click on the Create New button at the bottom of the screen A screen will appear alerting you to the fact that you will need to use the arrow keys in the lower right hand corner to move to the correct record The correct record will not have any data in any of the boxes in the lower portion of the screen species life stage etc
48. ocked against entries Sequence number and reach name are handled through the Edit Reach Sequence Name and Description screen discussed previously 2 Review reach lengths carefully NOTE One of the most common and significant sources of error in an EDT analysis is incorrect lengths and or widths for reaches lengths tend to err on the short side 3 Click in any cell in either of the reach length columns template or patient to make desired changes 4 When finished making edits click on the Save button at the bottom of the screen to save your changes to the database NOTE Entries do NOT get written immediately to the database you must use the Save button To edit reach hierarchy structure 1 Click on the third button under Option Menu Edit Reach Hierarchy Structure The screen shown below will appear Stream Reach Editor User Manual May 2004 Page 15 ECOSYSTEM DIAGNOSIS amp TREATMENT Edit Reach Hierarchy Subbasin Entiat import Stream Reach Data Export Stream Reach Data Reach Editor Attribute Editor Reach Name Geographic Area Watershed Watershed Code Sub VYatershed Menu Options Entiat blw Roaring Cr 7020010 v Entiat blw Roaring Cr Edit Reach Sequence Name and Description oaring 1 Edit Reach Length ntiat 4 Lower Entiat 4_ Up Columbia Entiat Y 17020010 i i 020010 d Edit Reach Hierarchy Structure 3 Edit Reach Routing ilicum 1 i Split an Existing Reach into an Up Columbia Ent
49. on a cell in the third column reach description to make any desired changes to the text NOTE The reach description should clearly indicate upstream and downstream end points A very concise summary of the salient characteristics of the reach e g from Columbia confluence to end of slack water will enhance the usefulness of the reach structure 5 After making your edits click the Refresh Screen button at the bottom of the page to view any changes in routing as a result of editing the sequence numbers To edit reach length 1 Click on the Edit Reach Length button under Menu Options The Edit Reach Length screen appears Stream Reach Editor User Manual May 2004 Page 14 he ECOSYSTEM DIAGNOSIS amp TREATMENT Edit Reach Length Subbasin Entiat SeqNo enu Options E a Edit Reach Sequence Name ieee 4 and Description 4 Edit Reach Length E g Edit Reach Hierarchy Structure A 3 C af Ticuna E E aani crea E et et i Ci Split an Existing Reach into an 10 Mad 3 SB SBT Upper and Lower Reach EDE Cis O 12 Mudd o o o oo od O Delete Reach caution deletes Entiat 7 O O O i o 22 reach and all associated data 14 Entiat 8 E 15 Potato 1 SSS SC Exit to Main Reach Menu SAVE Figure 22 Edit Reach Length screen NOTE You may make edits only in the two reach length columns Template Length and Patient Length The other three columns are l
50. ortality or other physical or mechanical injuries Culverts or falls with significant length should be described as two reaches 1 the feature as an obstruction to fish passage described using this form and 2 the feature as a reach with a length and associated environmental features attributes Stream Reach Editor User Manual May 2004 Page 36 ECOSYSTEM DIAGNOSIS amp TREATMENT 6 Edit Obstruction Assumptions a E 0 x A Stream Reach Editor Obstructions 1 Use to create edit reach obstruction assumptions RecchNone A 33281 General Documention Common name for obstuction description type etc PO Enter Passage Assumptions Passage is specific for species life stage and migration direction Select a Species J Select a Life Stage sd Migration Direction Focus Month Effective Passage in Focus Month Note Blank entries assume 100 passage no effect l4 4 gt Pl Species Lifestage Record 1 of 1 ___CreateNew _ Save Changes Close Figure 41 Stream Reach Editor Obstructions screen To use this form you must first identify the Obstruction by assigning a value of 1 to either or both of the Template and Current condition fields Revised Rating Next click on the Edit button to the right of this field which brings up the following screen Use the scroll bar to view all of the data fields or expand your window to see the entire screen The top portion of the screen is used t
51. own in the screen capture above indicates that minimum temperature has the largest effect on this reach in November February as a value of 1 is provided for these months The effect in May is only 75 that of February and the effect in April and October is only 25 Because values are not entered for the remaining months the model assumes that minimum temperature is not an issue for these months Some key points to remember in shaping a monthly pattern e Use values from 0 to 1 otherwise the function does not work properly e Assign a value of 1 for both the Focus Month and any other months where you want the model to assign the full effect of the rating If you want 50 of the effect to be modeled use a 0 5 if 25 assign a value of 0 25 etc After you have created a pattern it is automatically assigned a pattern number and is added to the list of patterns so that you can assign the same pattern to additional reaches if desired Stream Reach Editor User Manual May 2004 Page 43 ECOSYSTEM DIAGNOSIS amp TREATMENT Enter Rating Comments Enter comments to support your rationale for the attribute rating or flow pattern used or more likely both The database keeps a running list of all comments entered so that you will be able to assign the same comment or data source to multiple reaches or attributes Biological Community Biological Community is the next major category of attributes We will provide an overview the attrib
52. pper table is useful to see multiple reaches and correct routing Route Error Table for multiple reaches Please confirm the reach route for this reach This reach is not routing correctly however unable to locate route problem Figure 27 Reach Routing Editor 9 Review the reach and error description in the Route Error Table at the bottom of the screen Stream Reach Editor User Manual May 2004 Page 18 10 11 12 13 14 15 16 a i ECOSYSTEM DIAGNOSIS amp TREATMENT Locate each reach named in the Error Table by scrolling through the Reach Routing Editing table at the top of the screen Locate the downstream and upstream reaches for that reach in the drop down lists Carefully check the routing for that reach as well as those reaches above and below Repeat for each reach that appears in the Error Table When finished click Close to return to the Edit Reach Routing screen Click Test Routing again to verify that the reaches are routed correctly If a routing error appears repeat steps 7 13 above Otherwise select another option from the side menu To split existing reaches 1 Click on the fifth button under Menu Options Split an Existing Reach into an Upper and Lower Reach to bring up the screen shown Split Existing Reaches Subbasin Entiat Import Stream Reach Data Export Stream Reach Data Reach Editor Attribute Editor Reach Name Upstream Reach Descr
53. r our knowledge of local conditions for a particular attribute is much greater In such cases and especially when the attribute is expected to have a significant impact on production the use of non categorical ratings might be more appropriate Non categorical ratings are expressed as decimals between 0 and 4 To indicate that an attribute should be modeled as the upper value of a rating range the rating should be entered as a 0 5 value Thus if a fine sediment rating of 3 is modeled as the mean of 18 and 30 a 3 5 would be modeled as 30 Similarly a categorical fine sediment rating of 2 will be modeled as the mean of the range 11 to 18 14 5 whereas a rating of 2 5 will be modeled as 18 When warranted by the precision of environmental information and the probable importance of the attribute finer non categorical interpolations may be made In such cases the planner should Stream Reach Editor User Manual May 2004 Page 28 ECOSYSTEM DIAGNOSIS amp TREATMENT assume a linear relationship between attribute values at the upper end of a category range and the ratings that define these end points Shape Monthly Pattern Assign a monthly pattern to all four Flow Variation attributes for both patient and temp Note however that flow patterns are not needed for the two Hyrologic Regime attributes Regime Reg and Regime Nat Several seasonally variable attributes require monthly shaping patterns as shown below e Chan
54. ributary that you now wish to add To actually add the tributary you must use the Create New Reaches function To split reaches to add obstructions 1 Click on the Split Reach to Insert Obstructions Reach button to bring up the following form Stream Reach Editor User Manual May 2004 Page 20 ECOSYSTEM OIAGHOSS amp TREATMENT Upstream Reach Description Upstream Reach Name Entiat 5 7 Obstruction Reach Name Obstruction Reach Description J Entiat 5_Obstr_H Reach Mame Downstream Reach Description Downstream Reach Mame Reach Blof Original Reach Description j Split Reach for Entiat 3 From JS Bridge to Mad River Length mij 1 6 tributary confluence jae Reach insert Obstruction Reach Save Figure 30 Split reach for obstruction form IMPORTANT When you are using the Split Reach for Obstructions feature your inputs are not being saved automatically to the database Be sure to save your work by clicking on the Save button at the center bottom of the screen 2 Enter a unique name for each reach in the Upstream Reach Name Obstruction Reach and Downstream Reach Name fields unless you choose to accept the default reach names that appear in those fields NOTE Using these defaults will ensure a consistent naming protocol for each split 3 Provide a description for each new reach NOTE Itis useful to adopt the convention of including beginning and ending river mi
55. s Add Extract View CheckOut Wizard Modified Size Ratio Packed crc Attrib E vbzipperDll exe 4 3 2002 4 38 PM 101 888 11 91 032 c7411715 A SC a E 7142002 5 19 PM 12 476 416 76 2 942 476ef071 4 El 4 Selected 1 file 12 184KB Total 2 files 12 284KB wW de Figure 5 Contents of downloaded zip file NOTE The zip files contains two files an executable DLL file utility VbzipperDll exe and an MS Access database file Stream Reach Editor mdb as shown below 13 Extract these files into the same directory that you created for the downloaded zip file NOTE These two files must be saved in the same directory or the application will not function properly Now that you have downloaded the Stream Reach Editor and documentation you are ready to download a stream reach dataset To download the stream reach data 1 Click on the Download Data button from the Stream Reach Editor Main Menu The Download Stream Reach Dataset screen appears STREAM REACH EDITOR Download A Stream Reach Dataset Copy The downloadable datasets consist of Reach Definition and Habitat Attribute data that can used in the offline editor 4 downloaded dataset can serve as a baseline starting point for your new data You may edit the baseline datasets with the Stream Reach Editor to build your own subbasin dataset and then upload this edited dataset as a new draft Important The offline Editor uses a copy of th
56. se as 0 length stream features They fentit 3 hI ee describe partial or complete barriers to fish migration and other sources of mortality associated with in stream structures mortality Roaring aT Pe due to predation impingement on screens trauma etc Entiat 4 iil i Ertiat 5 Jej E i i Culverts or falls with a significant length should be described as two e o reaches 1 the feature as an obstruction to fish passage described Tilicum 1 A z using this form and 2 the feature as a reach with a length and associated environmental features quality and quantity descriptions Mad 2 ST i i Mad 3 o Joj ooo o l i i How to use this form Idenfity obstruction reaches with a rating 1 Entiat 6 Juj o E o i i template and current condition Then click on EDIT for the appropriate Muai o o el scenario Obstructions need to be described for species life stages Emar Msl E and effective passage survival through the feature Delayed mortality associated with the obstruction should be included in this Figure 40 Habitat Attribute editor with obstructions Obstructions are their own reaches the EDT model treats them as zero length 0 ft stream features They describe partial or complete barriers to fish migration and other sources of mortality associated with in stream structures These mortality sources could include such factors as predation in a tailrace of a dam screen impingement turbine m
57. should be able to edit all or a portion of the fields described below Revised Ratings Change the existing ratings for the Template T or Current C condition Focus Mon No Select the focus month from ths drop down list see discussion on Shape Monthly Pattern below for details on how to identify your focus month Data Precision Enter 1 if the data entered is Categorical or 2 if Non Categorical Note that if this field is shaded gray then data precision is always non categorical See discussion on page 35 for more information on categorical and non categorical ratings Stream Reach Editor User Manual May 2004 Page 42 ECOSYSTEM DIAGNOSIS amp TREATMENT Shape Monthly Pattern Assign monthly pattern to all Flow Variation attributes The pattern screen for the Temperature Minimum attribute is shown below Use this screen to create edit patterns and assign attribute ratings by month To begin simply place a 1 in the month s where you want the full effect of the rating to be expressed Note that you defined at least one of these months in the Focus Month field Next shape the pattern so that it expresses how the effect changes by month stream Reach Editor Pattern Editor Use to createfedt a monthly pattern for a particular attribute Pattern ID BB Pattern Description Pattern Mame T emphin P1 Patterns created for Entiat by work team 2001 ri Figure 45 Stream Reach Editor Pattern Editor The example sh
58. ssful data export Create Export Directory Figure 53 Export Stream Reach Data screen 2 Click on the Create Export Directory button at the bottom of the page step 2 Export Data to Zip File Review local directory and file name Please make note of the directory location and file name as you will be asked for this location and name later During the upload process in EDT Online you will again be asked for this information Hint The root file directory is your default directory in Access this can be changed by going to Tools Options General E Katie Export StreamData 20030924335 Stream Data Entiat 20030924335 RD Export Data to File Figure 54 Step 2 Export Data to Zip File screen 3 Click on the Export Data to File button found at the bottom of the screen Processing may take a few moments The Confirm Successful Data Export screen appears Stream Reach Editor User Manual May 2004 Page 50 ECOSYSTEM DIAGNOSIS amp TREATMENT step 3 Confirm Successful Data Export Congratulations data export is complete Exit Stream Reach Editor and log on to EDT Online to upload data Finished fable expor fables zoned into file FE afielexoot Streamate 400009249745 Strean Data Entiat 20030924955 _ RO Figure 55 Step 3 Confirm Successful Data Export screen NOTE Make note of the export directory path and name You will be asked for this information again when you are uploading to the EDT
59. t 4 C Minimum water temperatures within the stream reach during a month Habitat Attribute Ratings Edit rating assumption focus month and data precision Focus Mon No Data Precision Enter Rating Comments lt Template Template 66 Edi 884 Edit 430 459 457 539 625 048 625 127 207 713 Reach Name e _ 4 _ _ _ a _ _ _ _ _ _ _ _ _ oa 4a aa 444444 aha Pana mo 54 4 3 4 4 _ el ee MW m OO 0 Oo MO oO oO ao a w w 0 5 0j oja o O ap ata pape hahah agea 365 v aqa4 4 67 4 68 85 x 68 x 6r 4 Edit Edit Edit Edit 67 Edit 67 a7 est 67 a7 eat 67 gt Edit Edit Edit Edit Edit Edit on J 4 on d 4 er a7 87 a7 P87 aT P67 a7 P87 aT 67 886 Send Data to Excel Insert from Excel m D j EE EE n d 4 dij ho oO wn J BR gt wo 4 apa a gt a pare m 54 4 4 co rh o wo O 4 4 43 Figure 44 Habitat Attribute Editor with temperature daily minimum The Habitat Attribute Ratings portion of the screen is where you will enter or edit the data Note that you will not be able to edit reach name sequence number Ratings data fields or any fields that are grayed out not required Depending upon the attribute being edited you
60. tabase keeps a running list of all comments entered so that you will be able to assign the same comment or data source to multiple reaches or attributes Copying Habitat Data from One Reach to Another Once you have input habitat attributes for a reach you can copy those same attributes to other reaches To copy habitat data from one reach to another 1 Select the Habitat Attribute that you wish to copy 2 Insert your cursor at the reach that you wish to copy 3 Click Copy at the bottom of the screen sien 00 ee E rT Figure 48 Copy Save and Export options for the Habitat Data Screen 4 The Select Copy Options page appears On the left side of the screen select the attributes you wish to copy On the right side of the screen select the reaches to which these attributes should be copied Stream Reach Editor User Manual May 2004 Page 47 Copy Data from this Reach Enitiat 1 and this attribute FlyvHigh Copy Options Original Rating 21 Copy T Rating 267 Copy C Rating Revised Ratings E Copy T Revised Rating C Copy C Revised Rating Focus Month E Copy T Focus Month alr Copy Focus Month Data Precision 1 7 Copy T Data Precision ar Copy C Data Precsion Monthly Patten aae Copy T Pattern ID ae Copy Pattern ID Data Comment E Copy T Data Comment JE Copy Data Comment ECOSYSTEM OIAGHOSS amp TREATMENT Identify Reaches for Copy Select Reaches from List FF Enti
61. tefedit a monthly pattern for a particular attribute Pattern ID Bl Pattern Description Pattern Name Prec Pe Patterns created tor Entiat by work team 2001 Rating 2 0 Figure 47 Stream Reach Editor Pattern Editor You can use this screen to create edit patterns and assign attribute ratings by month To begin simply place a 1 in the month s where you want the full effect of the rating to be expressed Note that you defined at least one of these months in the Focus Month field Next shape the pattern so that it expresses how the effect changes by month The example shown in the screen capture above indicates that Predation Risk is equal for all months Some key points to remember in shaping a monthly pattern e Use values from 0 to 1 otherwise the function does not work properly e Assign a value of 1 for both the Focus Month and any other months where you want the model to assign the full effect of the rating If you want 50 of the effect to be modeled use a 0 5 if 25 assign a value of 0 25 etc After you have created a pattern it is automatically assigned a pattern number and is added to the list of patterns so that you can assign the same pattern to additional reaches if desired Stream Reach Editor User Manual May 2004 Page 46 ECOSYSTEM DIAGNOSIS amp TREATMENT Enter Rating Comments Enter comments to support your rationale for the attribute rating or flow pattern used or more likely both The da
62. the page to either view the User Manual as a pdf file or to save it to your computer for printing 9 Click on Download Editor at the bottom of the page The Download File dialog box appears File Download 2 fou are downloading the file Reach Editor zip from we mobrand com Would pou like to open the file or save it to your computer cave Cancel More Info IY Always ask before opening this type of file Figure 3 Download file dialog box 10 Click on Save The Save As dialog box appears Save as el Save in J Desktop gt e i c E My Documents LW kmobrand_Entiat_1064352750909_RH zir ks J My Computer ET QHA 8 07a Blank zip History ERE My Network Places i l Scenario Demo Session_9 12 03 Desktop l ScenarioBuilderSep12_03 l ScenBuilder_Sept_15_03 E l ScenBuilderSept_16_03 My Documents I SRE TodaysDate _ Test5Sep20 J webworkongoing My Computer Ej File name teach Editor zi My Network P al Save as type Winzip File Cancel h Figure 4 Save As dialog box 11 Create a directory for the Stream Reach Editor files and click Save 12 Navigate with Windows Explorer to the newly created directory and double click on the downloaded file Reach_Editor zip Stream Reach Editor User Manual May 2004 Page 4 5 h ECOSYSTEM DIAGNOSIS amp TREATMENT i WinZip Stream Reach Editor zip loj x Fie Actions Options Help aeVIueavesd New Open Favorite
63. ty Turb Data Input Example We will use Width Maximum WidthMx as the example to describe how data for the Stream Corridor Structure attributes are entered Stream Reach Editor User Manual May 2004 Page 32 ECOSYSTEM DIAGNOSIS amp TREATMENT Habitat Attribute Editor SUbbasin Entiat Import Stream Reach Data Export Stream Reach Bate Reach Editor Attribute Editor Exit Habitat Attribute Select attribute from list then review definition and rating rule Select Category 2 Stream Corridor Structure Select Sub Category 2 1 Channel morphometry T ChLnigth Widths Wicthhin Grad Channel month Maximum width ft Rating 0 Width values are entered as point values in ft Average width of the wetted channel during peak tow month average l monthly conditions lf the stream is braided or contains multiple channels then the width would represent the sum of the wetted widths along a l transect that extends across all channels Mote Categories are not to be used for calculation of wetted surface area categories here are used to l designate relative stream size i Habitat Attribute Ratings Edit rating assumption focus month and data precision vised Rating Focus Mon Mo Shape Monthly Pattern ing Comments T Cc T Cc Template Template Edit Edit 50 E 80 Eat 80 Eat a1 gt 80 5d m a T mi 3 F Ci D Edit 4i7 Edit Edit 545 Edit 054 edit 630
64. ucture is the next major category of attributes We will provide an overview the attributes in this category and a data input example Overview of Attributes As outlined above the Stream Corridor Structure category is divided into six sub categories Channel Morphometry Confinement Habitat Type Obstructions Riparian amp Channel Integrity and Sediment Type Channel Morphometry includes the following attributes e Channel Length ChLnegth e Width Maximum WidthMx e Width Minimum WidthMn e Gradient Grad Confinement is composed of these attributes e Natural stream confinement Confine e Confinement Hydro ConfineHydro Stream Reach Editor User Manual May 2004 Page 31 ECOSYSTEM DIAGNOSIS amp TREATMENT Habitat Type includes these attributes e Back water Pools HbBckPIs e Beaver Ponds HbBvrPnds e Glides HbGlide e Large Cobble HbLrgCbl e Small Cobble HbSmlCbl e Pool Tail outs HbPITails e Pools HbPIs e Off channel habitat factor HbOfChFctr Obstructions is composed of the following attributes e Obstructions Obstr such as waterfalls culverts and dams e Water Withdrawals Wdrwl Riparian and Channel Integrity includes these attributes e Channel Bed Scour BdScour e Icing Icing e Riparian Function Rip Func e Large Woody Debris WdDeb Sediment Type includes the following attributes e Stream channel substrate Embeddedness Emb e Fine Sediment FnSedi e Turbidi
65. utes in this category and a data input example Overview of Attributes The Biological Community category is divided into two sub categories Community Effects and Macroinvertebrates Community Effects includes the following attributes e Fish Community Richness FshComRch e Fish Pathogens FshPath e Fish Species Introductions FspIntro e Harassment Harass e Hatchery Fish Outplants HatFOutP e Predation Risk PredRisk e Salmon Caracasses SalmCarcass Macroinvertebrates includes only one attribute e Benthic Community Richness BnComKch Data Input Example We will use Predation Risk PredRisk as the example to describe how data for the Biological Community attributes are entered Select Biological Community from the Select Category drop down list select Community Effects from the Sub Category drop down list and click on the PredRisk button The following screen will appear Stream Reach Editor User Manual May 2004 Page 44 EDT ECOSYSTEM DIAGNOSIS amp TREATMENT The upper left portion of the screen provides a description of the attribute PredRisk Directly to the right of the attribute definition a text box displays the definitions of the ratings from 0 through 4 Note that you must use the vertical scroll bar to view all five rating definitions in the box The Habitat Attribute Ratings portion of the screen is where you will enter or edit the data Note that you will not be able to e
66. wnload Editor and User Manual The Download the Stream Reach Editor and User Manual screen appears STREAM REACH EDITOR Download the Stream Reach Editor and User Manual This is a four step process First check the list of Requirements below Second download the Editor to your computer Third download the User Manual Last return to the Editor main menu and select Download Data to download a dataset to use with the Editor Requirements To use the Stream Reach Editor you must have a Windows operating system with MS Access 2000 installed on your hard drive Both the Editor and the Datasets have been compressed for faster downloading If you don t already have file expansion software you may download Aladdin Stuffit free of charge opens in a new window The Stream Reach Editor User Manual is in Adobe Acrobat format If you don t already have it you may download the Adobe Acrobat Reader free of charge opens in anew window OSO File size 2 6 MB This make take up to 5 minutes to download with a dial up modem connection ETETA Pen File size 2 17 MB You will see a blank screen for quite a while as the manual loads perhaps a 4 few minutes if you are on a dial up connection Figure 2 Download the Stream Reach Editor and User Manual screen from EDT Online Stream Reach Editor User Manual May 2004 Page 3 ECOSYSTEM DIAGNOSIS amp TREATMENT 8 Click on Download User Manual at the bottom of
67. wnstream Reach Description ownestream Reach Mame Reach alot ntiat 3_A Original Reach Description j Split Reach for Entiat 3 From Fire Station Bridge to Roaring Creek tributary confluence Length mii 3 aa Reach insert Obstruction Reach Save Figure 29 Split reach for tributary confluence form IMPORTANT When you are using the Split Reach for Tributary Confluence feature your inputs are not being saved automatically to the database Be sure to save your work by clicking on the Save button at the center bottom of the screen 2 Enter a unique name for each reach in the Upstream Reach Name and Downstream Reach Name fields unless you choose to accept the default reach names that appear in the Upstream and Downstream Reach Name boxes NOTE Using these defaults will ensure a consistent naming protocol for each split 3 Provide a description for each new reach 4 Click on the Save button at the bottom of the form 5 Continue splitting reaches and saving as desired NOTE Itis useful to adopt the convention of including beginning and ending river miles in the Reach Description field For example for Entiat 1A describe the reach as Entiat River from mouth to unnamed RB tributary RM 0 0 to 1 8 NOTE The Editor does not ADD a tributary during this reach splitting procedure it simply splits the original reach into two new segments one below and one above the previously omitted t
68. xport stream each Wata Reach catar AtHBULe cdtar Step 3 Import Data Files Before clicking on the Begin Import button first verify that all t t files were successfully located Any missing files will be highlighted and noted as missing Importing may take several minutes Text Files in Directory ARD Info txt Attribute_Data txt Attribute _Data_Documentation txt Hatchery_Program_Data txt Obstruction_Attribute_Data txt Pattern_Data txt Pattern_Data_Documentation txt Reference_Sources txt Basin_Hydrography txt Reach_Data txt ay mn Data files are ready to import into Stream Reach Editor Begin Import Figure 17 Step 3 Import Data Files screen NOTE You should see the two files that were in the downloaded zip file If any files were not successfully located they will be highlighted and noted as missing 7 Click on Begin Import at the bottom of the screen When complete the Step 4 Confirm Successful Import Screen appears NOTE Importing may take several minutes ha Import Stream Reach Data Subbasin Entiat Import Stream Reach Data Export Stream Reach Data Reach Editor Attribute Editor Step 4 Confirm Successful Import Congratulations data import is complete The Stream Reach Editor has completed a successful import of Stream Reach Data for your Subbasin You are now ready to begin editing your data Finished successful import Stream Reach fables Figure 18 Step 4 Confir
69. you change the format in any way the data cannot be imported back into the Stream Reach Editor To export habitat data into Microsoft Excel 1 Select the Habitat Attribute that you wish to export 2 Click Send Data to Excel Send Data to Excel from Excel Figure 50 Copy Save and Export options for the Habitat Data Screen Stream Reach Editor User Manual May 2004 Page 48 ECOSYSTEM DIAGNOSIS amp TREATMENT 3 Microsoft Excel will launch displaying your data Plot or edit your data as desired being careful not to change the formatting Ey EEEE FiwHigh Original Ratings Original Precision Revised Ratings Entiat 1 FlwHigh FiwHign 20 26 1 2 ft 6 Entiat 4 FiwHign 20 26 1 2 J J J oy et pt fff H 11 Mad 2 rwo 20 24 1 2f TT ma a OS A ss Se 17 Potato 1 FiwHign 20 30 1 2 ft Entiat 10 FiwHign 20 23 1 2 ft 21 Entit rwo 20 23 1 2 TT 22 Be EE ee CL a a E E Figure 51 Habitat Attribute Data exported into Excel 4 Plot or edit your data as desired being careful not to change the formatting To import habitat data from Microsoft Excel 1 Select the Habitat Attribute for which you have an Excel file to import 2 Click Insert Data from Excel Send Data to Excel Inzert from Excel ETENE T oO o rNrO_ rr Figure 52 Copy Save and Export options for the Habitat Data Screen 3 Navigat
70. ype in the name of the specific record that has that name in the selected cell 4 Right click in any cell to bring up the filter sub menu and select Remove Filter Sort to return to the regular view with all data showing Editing Existing Reaches To begin editing reaches click on the Reach Editor button on the navigation bar of the Stream Reach Editor Main Menu The following screen appears Stream Reach Editor User Manual May 2004 Page 12 ECOSYSTEM DIAGNOSIS amp TREATMENT Reach Editor Subbasin Entiat Import Stream Reach Data Export Stream Reach Data Reach Editor Attribute Editor 2 General help information for using the Reach Editor Create New Reaches for Subbasin Erections Add new streams reaches to the dataset This is the first step prior to entering habitat attributes User will be working with an existing set of Subbasin data First step will be to reviews these reaches Edit Reaches for Subbasin Edit reach information split existing reaches Edits are reach routing length reach hi eo a After review then begin to add streams reaches ene CIE and or edit the existing reaches The edit screen can also be used to split an existing reach into two reaches Figure 19 Create or Edit Reaches for Subbasin screen Click on Edit Reaches for Subbasin to bring up the following screen Edit Reaches for Subbasin Subbasin Entiat Reach Editor Attribute Editor Edit Reach Sequence Hame

Download Pdf Manuals

Related Search

Related Contents

User Manual - securi  Toei Bus to Offer Free Passenger Wi  Tecumseh VSCF515ZXT Performance Data Sheet  Echotel 961-962 Manual de Instalacao e Operacao BZ51-646  Manual de Gestão do Desktop  MANUAL DE INSTRUCCIONES TOSTADOR DE PAN  Programme et revue été 2012 - Club Alpin Français d`Annecy  

Copyright © All rights reserved. Failed to retrieve file