NSS Regressions – User Manual
Contents
1. Ww Tes Area A Rainfall INTENS 00200 wN 14 26 Legend valid number AW Not applicable 28 Out of range 29 30 31 D data geodatalwtgislib hydrology_tookKNSSOperator TestO60605 XLSFilesiRC_VV_6_ 200506290854 xls 32 System data 23 D data geodata wtgislib hnydrology_tool NSSOperator Test060605itest060605 mdb 34 Watershed l4 4 Pii Data Parameters Isl The Input Data and Area contribution are populated from what was computed in ArcMap The numbers in the valid range will turn red if any of the parameters fall out of the range for which the equations were developed otherwise the numbers are green Numbers in pink indicate the parameter is not used for the region The user can change any of the input data The spreadsheet will automatically update the design discharges when any of the parameters are changed If the watershed crosses the boundary of more than one region the final discharges are computed as an area weighted average of discharges computed for each region If necessary changes to the input data can be made again and the discharges recomputed The range check for the input parameters will be updated automatically when the parameter is changed The discharges will be computed regardless whether the input parameters are out of range or not The invalid boundary will be turned red and that will be the indication that the parameter is not within the boundaries2. GIS Parameters GISParameters OF Help Cancel January 2009 22 NSS Regressions User Manual It creates updates the following fields in the Watershed layer e Q2 0100 2 through 100 year return period discharge computed with the regression equations The function also displays in the NSS Computation Results window the data sent to NSS as a pseudo XML and the results returned by NSS NSS Computation Results Feature id 4 NSS project state 55 gt NSSScenarno area 955 626 gt NS5Region name Area_2 Drainage Area 955 626 Average Soll Permeabilitp 91 2 Stream Slope 10 85 Method 3 4462 NSS Scenarno gt lt NSS project Retumrears 1 2 Flow 1 6169 975 Errs 1 1 25 000 Hetuyr ears 2 5 Flow 2 1 9048 135 Errs 2 25 000 Hetyr ears 3 10 Flow 3 10831 620 Errs 3 25 000 Retumrears 4 25 Flow 4 13234 612 Errs 4 26 000 Returmnrears 5 50 Flow 5 14992 302 Errs 9 26 000 Returntrears 5 100 Flow 6 16503 055 Errs 6 000 How to setup the function XML Parameter RegionThresholdPct If the percent of the area of the watershed within a region 1s strictly less than this threshold this region will be removed and its area added to the area of the biggest region Must be less than 50 Will be set to O i e region never removed if it is set to a value greater or equal to 50 REGIONIDFIELD Name of the RegionID field in the Region layer ApFields NSSFIELDS Definition of the GIS p
3. KEYTO STA_NUM Where AREAFRACTION gage area must be within this area fraction of the watershed area to be considered Default to 0 5 50 KEYFROM identifier of the gage station in the Gage Station Polygon feature class Link to the KEYTO field in the Gage Station layer STA_NUM identifier of the gage station in the Stream Gages layer Link to the KEYFROM field in the Gage Station Polygon layer Input layers used by the function ApLayers Aplawyers ApLayer Watershed ApLayer G5PULY ApLayer StreamGages 6 Similar Gage Selection This function allows selecting gaging stations Stream Gages that have similar physical characteristics as the watershed of interest May be or not in the same hydrologic region Only one watershed can be processed The function requires two input layers Watershed layer Watershed Required fields Hyd_area Hydrologic Area for the watershed 1 5 be populated use 1 for Region if not found Parameters field s AREA2MI FORESTPCT SLP1085FM PRECIP25YR SNOWFALL STORAGEPCT PERMEAB Gage stations layer Stream Gages Required fields Region hardcoded Hydrologic region where the gage is located 1 5 Related to Hyd_Area field of the Watershed Parameters field s DA FOREST SLOPE PRECIP SNOW STORAGE SOIL_PRM January 2009 13 NSS Regressions User Manual e Select NSS Menu Similar Gage Selection e Specify the input Watershed and Stream Gage
4. which may be created by using the Point Delineation tool If no watershed has been selected the function processes all the watersheds The function requires three input layers e Watershed layer Watershed Required fields Q2 Q5 Q10 Q25 Q50 Q100 populated e Gage stations layer Stream Gages Required fields STA NUM DA R2 R5 R10 R25 R50 R100 populated e Gage stations watershed layer Gage Station Polygon Required fields WSHID or PNTID STA_NUM of associated gage station LP Gage Extrapolation Watershed watershed Gage Station Polygon ospoly_wi Stream Gages streamgages OF Help Cancel The gage selection procedure is as follows Step A Select all the gaging stations that contain the watershed of interest That will identify all the gaging stations downstream of the point of interest Find the station that drains the least area and see if it is within 50 of the watershed area January 2009 1 NSS Regressions User Manual Step B Select all the gaging stations contained in the watershed That will identify all the gaging stations upstream of the point of interest Find if any of these stations drains an area closer to the watershed area than the station identified in step A If there is one and is within 50 or the specified area fraction in the XML of the watershed area that is the closest area 1f not the one if any determined in step A is the clos
5. ApFields BASINFIELDS BasinFields ApField FEATUREID ApField NAME Name ApField AREA2M C_AREA2MI ApField FORESTPCT C_FORESTPCT ApField SLP1085FM C_SLP1085FM ApField PRECIP25YR C_PRECIP25YR ApField SNOWFALL C_SNOWFALL ApField STORAGEPCT C STORAGEPCT ApField PERMEAB C_PERMEAB ApField C_Q2 ApField C_Q ApField ApField ApField ApField IF C_Q5 0 5 0 0 ApField RQ C 010 C 025 C 050 C 0100 1 2 5 1 2 ApField RQ5 ApField RQ10 ApField RO25 ApField RQ50 ApField RQ100 ApField QCA2 ApField QCA5 ApField QCA10 ApField QCA25 ApField QCA50 ApField QCA100 ApField REGIONID ApFields STREAMGAGES StreamGages ApFields STREAMGAGES Fields definition for the input stream gages layer BASINCOMPARISON BASINCOMPARIS ON ApFields NSSFIELDS H ApFields BASINFIELDS BasinFields gt ApFields STREAMGAGES SteamGages ApField FEATUREID STA_NUM ApField MAME STA MAME ApField AREAS DA ApField FORESTPCT FOREST ApField SLF1085FM SLOPE ApField FRECIPZ5YR PRE IF ApField SNOWFALL SNOW ApField 5 TORAGEPCET STORAGE ApField PERMEAB SOIL_ PRM ApField o MP ApField E MN Po ApField C_Q10 P10 ApField _ 025 P25 Attribute Editor ApField 050 P50 ApField C_Q100 P100 Name PRECIP25YR ApField RO TagName PRECIP25YR ApField RO
6. Year_24 Hour_Precipitation_Intensity 3 Fieldvidth 10 reich Decimals 3 Decimals AllowNull 1 AllowNull AdditionalParams EXPRESSION 1 AdditionalParams EXPRESSION 4 2 OCA RO C_O where QCA adjusted discharge computed by the function RQ adjustment coefficient computed by the function C_Q Log Pearson discharge at the gaging station read from input Stream Gages layer January 2009 17 NSS Regressions User Manual How to setup the function The parameters used by the function are setup under the ApFunction NSSParams gt BASINCOMPARISON node S BASINCOMPARISON BASINCOMPARISON gt ApFields NSSFIELDS ApFields BASINFIELDS BasinFields ApFields 5 TREAMGAGES Streambages TELPREFIX TBLPREFI T BLPretix TELDESC TBLDESC XML Parameter ApFields NSSFIELDS List of parameter fields from input Watershed layer The alias of the parameter must match the name used to name the cell in the spreadsheet e g PRECIP FE HE BASINCOMPARISON BSSINCOMPARISON ApFields NSSFIELDS ApField AREASMI ApField FORESTPCT ApField SLP1085FM ApField PRECIP25YR ApField SNOWFALL ApField STORAGEPCT ApField PERMEAB ApFields BASINFIELDS BasinFields ApFields STREAMGAGES StreamGages ApFields BASINFIELDS Fields definition for the output BComp HydroID table January 2009 18 NSS Regressions User Manual BASINCOMPARISON BASINCOMPARISON ApFields NSSFIELDS
7. directory of the map document The function exports the predefined fields Name HydroID flows into the spreadsheet to populate the table linked to the flood frequency graph January 2009 25 NSS Regressions User Manual ES Microsoft Excel FF_272_200901121420 xls DOK 87 pie Edit View Insert Format Tools Chart Window Help Type a question for help a oe D OF AS ht aca 52152 BZ AAA ABR EE Chart Area k ROR O O O E DR RS RA ER O RR RR RA MNE e Watershed Name Watershed ld Z Flood Flow Frequency Peak flow rate cfs 38 KM 4 gt H FFLOW Ready January 2009 26
8. that this parameter is not used in the regression equation for this region and is thus not a significant parameter and will not be used in the discharge adjustment If the user enters a number in those fields they will be used in the gage selection but not for discharge adjustment If NA is entered in any field then that parameter will not be used January 2009 14 NSS Regressions User Manual to limit the gage selection The user can choose whether or not to select stream gages from the same region or select them statewide If Stream gages from the same region is checked only the gages having the field REGION populated with the Hyd_Area of the watershed will be selected e Once the parameters are entered click OK The result of this operation is a selected set of gaging stations Stream Gages that can be used in the basin comparison operation A popup window will show how many stream gages were selected The user can then choose whether or not to view the selection statement XML Configuration Parameters are read from the node ApFields GAGEPARAMS under FrameworkConfig HydroConfig ProgParams ApFunctions ApFunction NSSParams or the node ApFields NSSFields if the previous node is not set For each parameter ApField There must be a populated field named after ApField s name attribute in the input Watershed layer There must be a field named after the ApField s alias in the input Stream Gages layer The f
9. 1 43 E 5359500 South Fork Flambeau River near Phillips Mis 615 72 6 b 59 7 y 2 02 E 5367500 Red Cedar River near Colfax Wis 1100 38 7 44 4 i 2 02 lt Record al 1 a Show All Records of 9 Options January 2009 16 NSS Regressions User Manual The adjustment coefficients and adjusted discharges are computed in the following way each region return period and gaging station have a unique adjustment coefficient 2 EgExp i RO T CharWsh i TEMP CharGS i where RQ adjustment coefficient for given region return period and gaging station calculated by the function 1 product index indicating characteristic of interest e g area forest area etc n number of elements in the regression equation for given region and return period CharWsh watershed characteristic read from input Watershed layer CharGS gaging station characteristic read from input Stream Gages layer Eg xp exponent 1n the regression equation for characteristic and for given region return period and gaging station read from template spreadsheet Note For storage forest use CharWsh 1 1 and CharGS i 1 For PRECIP25YR use value 4 2 for the 2 characteristics These adjustments are stored using the additional parameter EXPRESSION o Attribute Editor o Attribute Editor FIELD VALUE aoa SMe PRECIP25YR dels SURI PRECIP25YR FOREST i PRECIP Percent of area covered by forest 3 25
10. 31 Mean Annual Snowfall SNOWFALL lt Null gt 34 4 172 T 491 1332 Drainage_Area AREA2MI lt Null gt 132 3340 gt ai 3 491 1333 Percent Storage STORAGEPCT lt Null gt 0 154 ales n 491 1334 Stream_Slope_10 85 Method SLP1085FM lt Null gt 0 74 74 2 ApField IMPERV2MI 492 1335 Drainage Area AREAZMI lt Null gt 0 47 124 ApField PRECIP25YR 492 1336 Area of Impervious Surfaces IMPERV2MI lt Null gt 4 8 90 8 242 ApField SNOWFALL z 2 ApField STORAGEPCT Record Ki 678 gt Show EN Selected Records 3 out of E ApField PERMEAB Only the parameters belonging to the selected regions are checked by default if PROCESSALLFIELDS is set to O If the parameter is set to 1 all fields are selected by default January 2009 6 NSS Regressions User Manual Select Parameters Select all parameters vV AREA2MI Area in square miles Mronestecr percent of area covered by forest requires Forest q IMPERV2MI Impervious Area PERMEAB Soil Permeability PRECIP25YR 25 Year 24 Hour Precipitation Intensity v SLP1085FM 10 85 slope in feet per mile based on preprocessed data SNOWFALL Mean Annual Snowfall STORAGEPCT Percent of area covered by storage requires Storage e Check the parameters to compute and click OK The function computes the selected parameters based on the method associated to the NSSFields in the XML document and stores them in the Attributes table of Watershed The function a
11. A dialog box will appear informing you that the tools have been added to ArcMap Click OK e Check the box next to NSS Regressions 9 to turn the toolbar on Click on Close button You should now see the NSS Regressions tools in ArcMap January 2009 2 NSS Regressions User Manual NSS Menu NSS Menu provides access to the functionality needed to support regression discharge computations The following options are available NSS Menu NSS Layer Management Remove User Selected Watershed Compute NSS Parameters Calculate Regression LP Gage Extrapolation Similar Gage Selection Basin Comparison Batch Regression Computation Recalculate 1085 Slope Food Frequency 1 NSS Layer Management The NSS Layer Management function allows specifying the layers used by the functions in the NSS Menu The list of layers that can be set reset is retrieved from the 3 following nodes located under the node FrameworkConfig HydroConfig ProgParams ApFunctions ApFunction NSSParams in the XML associated to the map document ApLayer CONTROLLAYERS ApFields NSSFields Layers required for the computation of the NSS parameters LPGAGEEXTR_PARAMS e Select NSS Menu NSS Layer Management A window with the list of the main tags used in regression will appear on the screen A tag is an alternative name uniquely identifying the role of a layer in a map for that application function The user can select the appropriate layer for a tag
12. EE Region2 v fe 9 ee A A A E A E EA EA E A ee Constant Area Precip Slope Storage Permeab Snowfall Forest Rowlndex Regioni Region2 Region3 Region4 Region5 Note 1 The Cells to the right of the RegionNam 2 Each cell mentioned in 1 should be nz 3 The cells to the right of column Parame 4 Each cell mentioned in 3 should be nz at EE EA a 8 EN oi 15 21 22 23 24 ra 4 4 gt gt I Data Parameters Ready 8 Batch Regression Computation The Batch Regression Computation function applies the regression equations to compute Q2 Q100 for the selected set of watersheds in the Watershed layer These watersheds may be created by using the Point Delineation tool If no watershed has been selected the function processes all the watersheds The function uses the NSS National Stream Statistics application by USGS to compute the discharges The parameters needed for regression computation have to be computed extracted first The user has no interaction with the process that is no change in parameters can be made during the process If some of the basins had the discharges already computed the discharges will be recomputed and the existing values will be overwritten The function takes as input the Watershed layer Watershed the Flow Regions layer and the GIS Parameters table Required fields Flow Regions Region Batch Regression Computation Watershed watershed Flow Regions regions
13. It is up to the user to accept or reject the computed discharges An Excel macro allows writing the updated values into the Attributes table of the Watershed layer The macros need to be updated if the parameters are modified January 2009 10 NSS Regressions User Manual Once the satisfactory results are obtained use the Regression Export button to return the results back to GIS The following thirteen fields are added or updated in the Watershed layer e C_AREA2MI CFORESTCPT C_SLP1085FM C_PRECIP25YR CSNOWFALL CSTORAGEPCT CPERMEAB fields contain the input parameters defined in the Regression Calculator application that were used in the regression equations e C_02 C_Q5 C_Q10 C_ 025 C_Q50 C_Q100 fields contain the 2 through 100 year return period discharges cfs computed using the regression equations Regression Export Macros Create WDNRToolbar WriteOutData Save Worksheet 5 LP Gage Extrapolation The Log Pearson LP Gage Extrapolation function allows computing the adjusted discharge Q_mod for a watershed based on the flood frequency computed at the nearest gaging station that is within 50 of the area of interest It requires that the watersheds for gaging stations have been determined and that the Qg Qr ratios have been computed see Gage Qg Qr Ratios below this has already been done in the standard WDNR Streamgages layer The function operates on a selected set of watersheds in the Watershed layer
14. NSS Regressions User Manual January 2009 ESRI 380 New York St Redlands CA 92373 8100 USA e TEL 909 793 2853 e FAX 909 793 5953 e E MAIL info esri com e WEB www esri com NSS Regressions User Manual Copyright O 2009 ESRI All rights reserved Printed in the United States of America The information contained in this document is the exclusive property of ESRI This work is protected under United States copyright law and other international copyright treaties and conventions No part of this work may be reproduced or transmitted in any form or by any means electronic or mechanical including photocopying and recording or by any information storage or retrieval system except as expressly permitted in writing by ESRI All requests should be sent to Attention Contracts Manager ESRI 380 New York Street Redlands CA 92373 8100 USA The information contained in this document is subject to change without notice January 2009 1 NSS Regressions User Manual Table of Contents Eolo 1 Celine Soil ire li 1 NSS MEL 3 L N55 Layer Management ads 3 Za REMOVE User SeleciedWafershed silla 4 3 ComputeINSS Parancola illa 5 4 Meal CU ate RESTOS il T 8 A A DC R Omer a 11 O similar Gage Selec A IS 13 Ci NN AA A 16 Si Batch Regression COMPU A Uli 22 Te Recalculate LOS SOPA oe 23 Se OOO aule Licia ian iii 24 January 2009 11 NSS Regressions User Manual Introduction The purpose of this document is to illustrate ste
15. Parameters Watershed Watershed v Watershed Point WeatershedPaint Flow Regions regions GIS Parameters GlSParameters Help Cancel The function intersects the selected watersheds with the regions to retrieve the IDs of the regions overlaid The function retrieves from the GIS Parameters table the list of GIS parameters defined for these regions The function prompts the user for the parameters to compute based on the definition in the XML Ed Attributes of regions 4 OBJECTID Shape HYD _AREA Shape Length gth Shape_ Area E RegioniD 61 Polygon 4 6071 310053 500748 872540 490 62 Polygon 5 671367 167239 16483719820 3258 am E Record aa a ll 62 i Show All Selected Records 0 out of 62 Selected The only required fields in the GISParameter table are the RegionID field name set in XML as REGIONIDFIELD and the GISParameter field The names in the GISParameter field must match the tags of the ApFields NSSFIELDS in the XML B Attributes of GISParameters LO e ra 489 1325 Percent Storage STORAGEPCT lt Null gt 39 7 489 1326 24 Hour 25 Year Precipitation PRECIP25YR lt Null gt 5 29 490 1327 Drainage Area AREAZMI lt Null gt i 696 490 1328 Percent Storage STORAGEPCT lt Null gt 0 52 4 490 1329 Stream_Slope_10 85_Method SLP1085FM lt Null gt J 204 490 1330 Average Soil Permeability PERMEAB lt Null gt 0 12 4 68 490 13
16. S Alias PRECIP e ApField RQ10 TES rea Mou Frecipkation Intensity ApField ROS Fieldwidth 10 ApField ROSO Decimals 1 ApField RQ100 Area 1 itionalParams ApField ACA ApField CAR ApField 12410 ApField CAE ApField CASO ApField 1241001 ApField REGIONID TBLPREFIX Prefix for the output table name Default to BComp The HydroID of the watershed will be appended if it is a number greater or equal to 0 Otherwise the suffix _cmp will be appended January 2009 19 NSS Regressions User Manual TBLDESC Default to Basin comparison for basin The HydroID of the watershed will be appended if it is a number greater or equal to 0 Otherwise the suffix cmp will be appended to install ArcHydro9 bin if not set EXCELDOCNAME Name of the Regression Calculator Excel Spreadsheet template Default to RegressionCalculator xls if not set Must contain the worksheet Parameters EqExp are set in the Parameters worksheet Index of the column storing the EqExp for a given parameter are read from the spreadsheet the index for a given parameter is stored in a cell named after the parameter For example the cell named Precip with the value 4 indicates that the coefficients used for the Precip parameter are stored in the column 4 in the spreadsheet ES Microsoft Excel RegressionCalculator xls Sele EJ File Edit View Insert Format Tools Data Window Help Type a question for help F
17. X DA AE aa 2 4 2 O Rowlndex Region l Collndex Constant Regions Area Regions Precip Regiond slope Regions 2 storage Permeab Snowfall Forest M 4 Data Parameters Ready Column 4 contains the coefficient for precipitations January 2009 20 NSS Regressions User Manual E Microsoft Excel RegressionCalculator xls Bo x Insert Forma Dat Type a question for help X R f Ea EE ERA A OSA Pe e e O DS Constant Area Precip Slope Storage Permeab Snowfall Forest Z Arial 10 BU ER 4 5 EE EE ER o Exa 14 15 R3Q2 36 5 0832 0 124 0 0143 0614 16 R305 616 0827 0 133 0 0169 0 683 amr eee an _ P DP AM a ARA A A van 4 4 gt MA Data Parameters lt Ready Note the name used to name the cells must match the aliases of the parameters in the XML for the ApFields NSSFIELDS Region definition In spreadsheet the region identifier is built by concatenating Region and the Region ID read from the Stream Gages table i e Region The cells named after the region e g Region2 stores the value of the starting row for retrieving the coefficients e g 9 means that the first coefficient for the Region2 is stored in row 9 January 2009 21 NSS Regressions User Manual ES Microsoft Excel RegressionCalculator xls BG bd File Edit view Insert Format Tools Data Window Help Type a question for help X i DG d 3 3 I RES B 9 9 E 21 O 210 mz U A S
18. all in inches field SNOWFALL e 25 year 24 hour precipitation intensity in inches field PRECIP25YR e Percent forested area field FORESTPCT e Percent storage area field STORAGEPCT e Area weighted average of mean soil permeability in in hr field PERMEAB January 2009 9 NSS Regressions User Manual The Regression Calculator application developed in Microsoft Excel allows the user to change all the parameters extracted from GIS if necessary and compute the discharges based on the regression equations Once the discharges are computed they can be returned back to GIS and stored in the database including the modified regression parameters Refer to the following figure for a description of the elements of the Regression Calculator N Microsoft Excel RC_W_6_200506290854 xls s File Gee T E ES at Tools Data Window Help lej x IO E Regression Export BAS o Ae E fl z fl 4 120 16 Jia o B UA Els 8 BS tE O A lao a EA A E R9C2 9 3447 1 A 5 6 7 8 9 10 11 12 13 Wisconsin Peak Flow Regression Calculator 2003 equations Basin ID A Input Data 17 5344 1 Channel Slope S 9 8447 2 i 10 Storage ST 13 4001 11 Soil Permeability SP 1 7649 12 Snowfall SN 50 7874 13 Forest Cover FOR 58 7058 14 15 Area contribution po 254303 DO T 74597 E a IE Design Discharges cfs 16 17 Return Period years 18 2 4
19. arameters that can be computed and of their computation methods ApLayers CONTROLLAYERS Definition of the input layers required by the function NFFDATABASEPATH Path to the StreamstatsDB mdb database used by the NSS application Default to install ArcHydro9 bin StreamstatsDB mdb if not set or if correctly set This DB must be available on the computer it is not installed with Arc Hydro NFFPWD Password used for opening the StreamstatsDB mdb database 7 Recalculate 1085 Slope The function Recalculate 1085 Slope allows recalculating the slope parameters after moving manually the location of the 10 and 85 points These points may be moved for example when there are issues with extracting the correct elevation due to the stream burning process or when performing the sensitivity analysis The function takes as input the four following layers January 2009 23 NSS Regressions User Manual e Watershed layer Watershed Required field HydroID e 3D Longest flow path layer Longest Flow Path 3D Required field DrainID e Slope Points layer Slope 1085 Point Required field DrainID e Raw DEM Grid Raw DEM Recalculate 1085 Slope Watershed Watershed Longest Flow Path 3D LongestFlowPath3D Slope 1085 Point SIp1085Point Raw DEM dern OF Help Cancel The function updates the following fields in the 3D longest flow path layer Longest Flow Path 3D e ElevI0 Elevation in DEM ver
20. ature for the watershed e Select NSS Menu Remove User Selected Watershed The parameters for this function are defined in the XML in the ApLayer FORUSERREMOVE defined under the node FrameworkConfig HydroConfig ProgParams ApFunctions ApFunction NSSParams ApLaper FORUSERREMOVE Watershed ApFields ApFields ApField Hydrol ApField DRAINID DrainlD ApField MAME Name ApLayers ApLapers ApLayer LongestFlowPath3D ApFields ApFields ApField HYOROID Heydrol D ApField DRAINID DrainlD ApLayer SLP1085PoInt 51p1085Point ApFields ApFields ApField HYDROID Heydrol D ApField DRAINID Drainl D ApField NAME Mame ApLaper w atershedF oint ApFields ApFields ApField Hydrol D ApField DRAINID Drainl D ApField NAME Mame January 2009 4 NSS Regressions User Manual ApLayer FORUSERREMOVE defines the layer to use as the Watershed layer to remove The name of this layer defaults to Watershed i e 1f there is a Watershed feature class in the Table of Contents of ArcMap 1t will be automatically used as the layer containing the watershed features to delete and the form shown below will not be displayed E Remove User Selected Watershed Watershed Watershed OF Help Cancel The ApLayer node has 2 child nodes ApFields and ApLayers ApFields contains a list of fields for the Watershed layer that are used to find related features in other layers The ApLayers node defines
21. est one If a viable gaging station is found it 1s used for discharge adjustment The following computations are performed r_mod r 2 Aw Ag 11 Ag where r_mod adjustment coefficient for given watershed return period and gaging station r adjustment coefficient for the closest gaging station ratio of Log Pearson discharge at the gaging station and discharge obtained using regression equation at gaging station obtained by using the Gage Qg Qr Ratios function Aw watershed area Ag gaging station area and for watershed return period and gaging station O_mod r_mod C_Q where Q_mod adjusted discharge for the watershed r_mod adjustment coefficient CQ discharge for the watershed computed by regression The following fields are added or updated in the Watershed layer e Sta num Number of the station used for discharge adjustment Set to 9 if no nearby station can be found e r2_mod through r100_mod Adjustment coefficients for year 2 through 100 discharges the number by which to multiply the regression discharge to get the adjusted discharge Set to I if no nearby gaging station can be found e 02 mod through 0100_mod Adjusted 2 through 100 year return period discharges Equal to the non adjusted regression discharges if no nearby station can be found January 2009 12 NSS Regressions User Manual XML Configuration XML Parameter LPGAGEEXTR_PARAMS AREAFRACTION 0 5 KEYFROM WSHID
22. get cell location in the Excel Spreadsheet as R row number C column number January 2009 8 NSS Regressions User Manual gt gt sprields EXCELFIELDS ApField AREA ApField FORESTPOT ApField SLF 085FhA ApField PRECIP R ApField SNOWFALL ApField STORAGEPCT ApField PERMEAR ApField 41 ApField A2 ApField 43 ApField 44 ApField 45 ApField MDBPATH ApField TABLENAME ApField HydrolD ApField 012 ApField 05 ApField SS Se Se Se ee ee ee Ss eS eS E ApField 025 ApField 050 ApField 0100 e Select the Watershed feature of interest The function works on one and only one watershed feature at the time Click OK e Select NSS Menu Calculate Regression The following window will be displayed only if the Watershed feature class has not yet been set Calculate Regression Watershed Watershed e Cancel e Select the Watershed feature class and click OK The function copies the template Regression Calculator spreadsheet to create a file named RC_W_BasinID_yyyymmddhhmmss where RC is the default value for the parameter SAVEASRC The required data consist of e Watershed ID field HydroID e Watershed Name field Name e Percent area in each hydrologic region fields A1 A5 e Hydrologic region the outlet resides in field Hyd Area e Area in square miles field AREA2MI e 10 85 slope in feet per mile field SLP1085FM e Average annual snowf
23. in the pull down menu next to the tag name The selected layers are tagged for use by the applications The pull down menu will offer for selection only those layers in the map that match the required layer type e g only the line features will be made available if the tag needs to be pointing to a line layer A NULL option will also be available in the list Selection of NULL will remove that tag from any of the layers in the map Only one primary tag can exist per layer In most cases the user does not need to be concerned about tag assignment as the process of tagging layers is automatically performed by the application The NSS Layer Management option can be used to set up the relevant layers when some of the preprocessing has already been performed and for setting resetting the input layers such as snowfall grid or landuse layer January 2009 3 NSS Regressions User Manual NSS Layer Management Watershed Watershed Point Mull Flow Regions Hull GIS Parameters Mull Forest a Raw DEM Hull Flow Direction Grid Mull Longest Flow Fath 30 Mull Slope 1085 Point Null Precipitation Null Snowfall Hull Storage Mull Soil Permeability Hull Gage Station Polygon Hull Stream Gages Hull OF Help Cancel 2 Remove User Selected Watershed This function allows removing the selected watershed features from the input Watershed layer as well as associated features stored in predefined related layers e g Longest Flow Path fe
24. lso populates the fields Hyd_Area with the region flow associated to the watershed point by subtracting the REGIONBASEID from the REGIONID stored in the Flow Region table e g 5 Hyd_Area 491 REGIONID 486 REGIONIDBASE It populates the fields Al to AS in the Watershed feature class with the percent of the area in each hydrologic region 1 5 If the selected watershed falls in more than one hydrologic region and the percent of the area residing in one region is less that 5 default threshold may be modified in the XML of the total watershed area then this hydrologic region will be ignored and its area percentage will be added to the largest of the remaining regions XML Configuration Name of the field storing the NSS Region ID in the GISParameters table and in the Flow Regions feature class Number to subtract to the lower region NSS ID to yield 1 used to find the name of the regions as Al AS PROCESSALLFIELDS e O Only parameters from overlaying regions are selected by default e 1 All GIS parameters defined in XML are selected by default except IMPERV2MI Default setting ApFields NSSFIELDS List of GIS parameters available for computation with their associated computation method RegionThresholdPct If the percent of the area of the watershed within a region is strictly less than this threshold this region will be removed and its area added to the area of the biggest region Must be less than 50 Will be set
25. ollowing AdditionalParams parameters in these ApFields are used by the function RANGES rangel range2 range3 where rangel is the range in for region 1 range2 is the range in percent for region 2 etc Note that range is either a value in or the string NA ALLOWZERO o 0 Stream gages where the parameter has a value of O will not be selected o 1 Stream gages where the parameter has a value of O may be selected if they fall within the specified range Default ranges are defined as Additional parameter RANGES as a comma separated list RANGES 50 NA NA NA NA 1 range 100 value lt param lt 1 range 100 Attribute Editor Bo FORESTPET FORESTPET FOREST Percent of area covered by forest requ Field idth 10 Decimals 3 s lovet ull AdditionalParams RANGES 50 N4 N4 N4 N4 DK CANCEL January 2009 15 NSS Regressions User Manual 7 Basin Comparison The Basin Comparison function allows performing a comparison of the discharges for a selected watershed in Watershed layer Watershed and a set of selected gaging stations Stream Gages One and only one watershed can be processed at a time The basin comparison methodology is based on the WDNR s Flood Hydrology and Hydraulics Manual 2000 The function uses as input Watershed and a Stream Gages feature classes The Stream Gages must contain the REGION field If available the values in the fields Name or Sta_Name and Sta_Num will copied f
26. p by step how to use the NSS Regressions tools This document is targeted to an experienced water resources ArcGIS user who wants to learn how to use the tools The NSS Regressions tools are installed as a separate toolbar by the Arc Hydro tools setup program Refer to the document Arc Hydro Tools 1 3 Tutorial pdf for installation instructions Getting Started Once the Arc Hydro tools are installed follow the steps described below Open ArcMap Create a new empty map and save it as NSSTest mxd or any other name Right click on the menu bar to pop up the context menu showing available tools Map Cache E M55 Regressions 9 Network Analyst If the NSS Regressions toolbar does not appear in the list click on Customize In the Customize dialog that appears click on the Add from file button Navigate to WshpTools9 dll installed by default under c Program Files ESRI ArcHydro9 bin and click Open to select the file January 2009 NSS Regressions User Manual Look in F Bin de E My Recent Documents amp HBatchPrepro9 dll AHMorphology dll ApGeoDataEx9 dll amp rcHydroTools9 dll Fall dll libStreamStatsDB dll TimeSeriesManager9 dll TinFilters dll WshA amp SPServer dil WSHPToo153 dll Desktop s My Documents E E E 3 E 3 mr a My Computer MT File name wsHPT oole3 dl Places Files of type r ype Libraries olb tlb dll Cancel si e
27. rom the stations into the fields Name and FeatureID in the resulting table Basin Comparison Watershed Watershed Stream Gages Istreamgages OF Help Cancel The function generates as output a Basin comparison table BComp_HydrolD that is stored in the target project geodatabase The first row of this table stores the original data for the selected watershed parameters and regression discharges C_Q2 through C_Q100 All the adjusted discharges QCA2 through QCA100 are equal to the original discharges while all the adjustment coefficients RQ2 through RQ100 are set to 1 Each following row in the table describes one of the selected gaging stations Their regression parameters and LP discharges C_Q2 through C_Q100 are presented as well as the adjustment coefficients RQ2 through RQ100 and the adjusted discharges QCA2 through QCA 100 ES Attributes of BasinCompare_323 E FEATUREID Name C_AREA2MI C_FORESTPCT C_SLP1085FM C_PRECIP25YR C_SNOWFALL C_STORAGEPCT C_PERMEAB b 323 test3 955 63 47 97 i 45 2 12 64 1 91 5436500 Sugar River near Brodhead Wis 523 12 i 5 31 9 0 9 1 08 5434500 Pecatonica River at Martintowen Wis 1030 115 5 f 29 6 0 3 1 08 5426000 Crawfish River at Milford Wis 762 7 4 i 37 2 11 1 1 18 5379500 Trempealeau River at Dodge WWis 643 25 8 45 4 1 4 1 77 5410490 KICKAPOO RIVER AT STEUBEN Wi 690 37 2 E j 35 4 1 51 5405000 Baraboo River near Baraboo Wis 609 28 8 38 2 j
28. s feature class Similar Gage Selection atershed Watershed stream Gages streamgages Help Cancel The function retrieves the value of the Hyd_area field defining the hydrologic region of the watershed It then retrieves the ApFields node to get the names of the parameters to consider and their associated additional parameters in particular RANGES rangel range2 range3 where rangel is the range in for region 1 range2 is the range in percent for region 2 etc Note that range is either a value in or the string NA ALLOWZERO o 0 Stream gages where the parameter have the value O will not be selected o 1 Stream gages where the parameter has the value O may be selected if they fall within the specified range The function displays the following window which is populated with the values of the parameters from the input watershed and the default ranges for those parameters for the hydrologic area of the watershed If Hyd_Area is not correct 1 5 then the ranges will all be set to NA AREAZII 186 2466 FORESTPLT 33 9621 SLP1O85FM 6 7342 PRECIP257 F 5 2800 SNOWFALL 45 1575 STORAGEPCT 0 0443 PERMEAE 1 3945 lw Stream gages from the same region OK Help Cancel The user can define the similarity parameters in this form as a percent of the original parameter for that watershed Default value is 50 Depending on the region some of the parameters will have a NA in their input fields This indicates
29. sions User Manual The name and location of the spreadsheet used as template as well as the name of the worksheet to use and the parameters to export are specified in the XML under the node ApFunctions NSSParams as follows Definition Path to the Flood Frequency template spreadsheet Default to ArcHydro9 bin if not set Name of the Flood Frequency template spreadsheet Default to FF xls if not set Name of the Excel Worksheet to use in the Flood Frequency template spreadsheet Default to FFLOW if not set SA VEASFF Root for the name of the exported file Default to FF The file name will be constructed by appending the HydroID year month hour and minutes of the time when the file was created ApFields FLOWFIELDS List of fields from input Watershed layer whose values will be exported into the Excel spreadsheet The AdditionalParams attributes defines the target cell location in the Excel Spreadsheet as R line number C column number ApFields FLOW FIELDS ApField NAME ApField HYDRQOID ApField C_Q2 ApField C 05 ApField _Q10 ApField Cs C asi e Select the watershed feature whose frequency you want to display e Select NSS Menu Flood Frequency e Specify the Watershed layer if prompted and click OK Flood Frequency Watershed Watershed w Help Cancel The function locates the template Flood Frequency spreadsheet and saves a new copy into the XLSFiles directory under the
30. the related layers containing features linked to the watershed features that should be removed whenever the associated watersheds are deleted The XML shown above as an example lists 3 related layers LongestFlowPath3D SLP1085Point and WatershedPoint The link between the related layers and the watershed layer is established through the FROMKEY TOKEY parameters defined as additional parameters If these parameters are not set they default to DrainID HydroID i e the DrainID in the related layers stores the HydroID of the related watershed feature Attribute Editor LongestFlowPath3D LongestFlowPath3D LongestFlowPath3D Longest Flow Path 30 FeatureType 1 ShapeT ype 3 CanCreate LayerT ype TargetLocation TargetD atasets HasZ 1 AdditionalParams IFROMKEY D RAINID TOREY HYDAOIO DK CANCEL The function deletes the selected watersheds and the related features 3 Compute NSS Parameters This function allows computing the spatial hydrologic parameters required to compute regression discharges for the selected watersheds e Select one of several watersheds of interest e Select NSS Menu Compute NSS Parameters January 2009 5 NSS Regressions User Manual The function will prompt for the input layers if they are not already set Note that the layers may be reset with the NSS Layer Management function Select the input layers and click OK The Flow Regions layer must contain the field REGIONID d Compute N55
31. tical units of the point located at 10 percent of the river length e Elev85 Elevation in DEM vertical units of the point located at 85 percent of the river length e SIpI085FM Slope based on the 10 85 extent of the longest flow path in feet per mile e SIpI085 Dimensionless slope of the river considering the points at 10 and 85 percent of the river length for slope computation e Elev10FT Elevation in feet of the point located at 10 percent of the river length e Elev85FT Elevation in feet of the point located at 85 percent of the river length The function updates the following fields in the Slope Points layer Slope 1085 Point e Eley Elevation in DEM vertical units of the point located at 10 or 85 percent of the river length The function updates the following fields in the Watershed layer Watershed e SLPIO85FM Slope based on the 10 85 extent of the longest flow path in feet per mile e SLP1085 Dimensionless slope of the river considering the points at 10 and 85 percent of the river length for slope computation 8 Flood Frequency The function Flood Frequency allows exporting the HydroID Name and computed flows from the selected input watershed feature into an Excel spreadsheet and displaying the associated flood frequency in a graph The exported spreadsheet will be created from a template and saved into the directory XLSFiles created if needed in the directory of the map document January 2009 24 NSS Regres
32. to O i e region never removed if it is set to a value greater or equal to 50 January 2009 7 NSS Regressions User Manual 4 Calculate Regression This function allows exporting the parameters for one and only one selected watershed in the Watershed layer to a Regression Calculator in an Excel spreadsheet The parameters to export are defined in the XML under the node ApFields EXCELFIELDS Each ApField defines one field to export from the Watershed layer The target cell in the Excel spreadsheet is defined as AdditionalParams For example R 7 C 2 in the example below means that the AREA2MI parameter will be exported into the row 7 and column 2 in the spreadsheet Attribute Editor AREAZII AREAZII AREAZII Area in square miles 3 Fieldwidth te Decimals Z Allow ull 1 AdditionalParamz R f C DK CANCEL template Default to install ArcHydro9 bin if not set Name of the Regression Calculator Excel Spreadsheet template Default to RegressionCalculator xls if not set Name of Excel Worksheet where the parameters will be exported Default to DATA if not set SA VEASRC Root for the name of the exported file Default to FF The file name will be constructed by appending the year month hour and minutes of the time when the file was created ApFields EXCELFIELDS List of fields from input Watershed layer whose values will be exported into the Excel spreadsheet The AdditionalParams attributes defines the tar
Download Pdf Manuals
Related Search