The following instructions describe how to parameterize BRAT within the continental United States. Users outside the United States should refer to the international instructions.
BRAT Parameter Database
BRAT Parameters for the continental Unoted States are stored in a PostGres database. Email the BRAT development team at (firstname.lastname@example.org) for access to this database should you wish to get access to this database and contribute parameters.
The BRAT parameter database schema is a subset of the database that is generated as part of each BRAT run. When the BRAT model is run, the contents of the parameter database are used to seed a copy of the model run database on your local computer. In this way the BRAT parameter database is intended to act as the central repository of BRAT parameters for BRAT runs, and a single place where analysts can share these parameters.
Refer to the BRAT model database documentation for a description of the database tables.
To edit BRAT parameters you will need a piece of software that can connect to PostGres databases. We recommend DataGrip for which there is a free educational license. With DataGrip you can enter parameters using SQL statements or there are also editing tools that let you edit the data within a table, like a spreadsheet.
Contact the BRAT development team (email@example.com) for credentials to access this database.
4. Maximum Drainage Area
Beaver dams are washed out by high flows and so BRAT needsd to know the places in the watershed where these high flows occur. Anywhere with flows higher than the specified parameter will have the output beaver dam capacity set to zero. BRAT takes this parameter in the form of a “maximum drainage area” value as opposed to discharge. The steps to find this parameter are:
- Open your desktop GIS software.
- Load the stream network layer from your BRAT run:
- Open the RAVE toolbar
1. Open the BRAT run riverscapes project file called
project.rs.xml. It should reside in the root of the BRAT project. 1. Right click on the *NHDFlowline* layer in the BRAT inputs section of the project tree and click “Add To Map”.
- Load the best available base imagery. You can use satellite basemap in ArcGIS or add a similar satellite layer in QGIS.
- Open the RAVE toolbar 1. Open the BRAT run riverscapes project file called
- Pan and zoom to find the place where water flows out of the eight digit HUC. There may be several actual streams if the outflow is braided.
- Use the measure tool (ArcGIS, QGIS) to measure the width of the visible river channel at the watesrhed outflow.
- Proceed upstream looking for the first reach where the width of the channel is approximately 20 m or less.
- Use the identify tool (ArcGIS, QGIS) to query the attributes of the uppermost reach that has a width of 20 m.
- Note down the drainage area value for this feature from the
- Enter the
iGeo_DAdrainage area value into the
MaxDrainageAreacolumn of the Google Sheet.
5. Hydrologic Regional Equations
BRAT needs two discharge values for each reach feature within a watershed. The first is for low flow that captures whether there is sufficient water in the channel during dry periods to support a beaver dam and lodge. The second is for peak flow that captures whether a 2 year recurrance interval flood would wash out a beaver dam.
BRAT calculates these discharges using regional hydrologic equations that convert drainage area into discharge. The USGS maintains a series of publications that contain hydrologic equations for the continental United States:
The typical equation will be of the form where Q equals:
0.000133 * (DRNAREA ** 1.05) * (PRECIP) ** 2.1
DRNAREA represents the drainage area for a particular reach. Other parameters (such as
PRECIP in the example given) may be present. We have calculate most of these for the Pacific northwest United States.
Copy and paste the relevant low (QLow) and peak (Q2) formulas into the relevant columns in the aforementioned Google Sheet. Note that the syntax is Python where the syntax for raising the power is double asterix (**) and not a carrot (^).
State specific documentation can be found here.
6. Vegetation Suitability
The suitability of riparian vegetation for beaver dam construction is calculated for both existing conditions as well as in the past, pre-European settlement. LandFire 2.0 Existing Vegetation Type (EVT) is used for the existing conditions and LandFire 2.0 Biophysical Settings (BPS) is used for historical context. Each possible EVT and BPS vegetation type is assigned a default suitability from 0 to 4, with 0 being unsuitable for beavers and 4 being the most suitable.
Each vegetation type might also have an override suitability within a specific ecoregion given the relative availability of other vegetation species. For example Ponderosa pine might have a default suitability of 2 given its thick bark, but in a specific dry ecoregion with few other options, Ponderosa Pine might be assigned an override suitability of 3.
Default suitabilities can be specified on the Vegetation Types tab of the Google Sheet. It can be useful to filter the vegetation types by epoch, representing either the existing EVT or historical BPS. Note that this worksheet is used by all BRAT runs in all watersheds in the continental United States. Be careful when assigning values that this affects all watersheds!
Override suitabilities can be assigned to specific ecoregions using the VegetationOverrides worksheet. Refer to the Watersheds worksheet to determine the ecoregion assignment for each watershed.
It might be helpful to review which vegetation types are present within a BRAT project. To do this open the
brat.sqlite database using your preferred database software and review the contents of the
vwReachVegetationTypes view. This view summarizes the total area of all the different vegetation types present within both the 100 m and 30 m buffers adjacent to reaches within a watershed.
Information on how to import vegetation suitability values from old pyBRAT projects can be found on the page for importing suitability values.
7. Run BRAT
Once you have updated all three parameters for a particular watershed you should contact North Arrow Research to re-run BRAT for your watershed. The results will automatically be uploaded to the riverscapes Data Warehouse where you can download them and review the affects of your changes.
Useful BRAT Parameter Database Commands
You can execute these commands by right clicking on the database node in DataGrip and choosing to open a new Console. Cut and paste in the following commands and then tweak as necessary.
To update the max drainage value of a particular HUC:
UPDATE watersheds SET max_drainage = 1234.5678 WHERE watershed_id = '17050001'
To update the default suitability to zero for the existing vegetation type Alaska Arctic Tidal Marsh which has the LandFire ID of 2222:
UPDATE vegetation_types SET default_suitability = 0 WHERE vegetation_id = 2222
To update default suitabilities for several vegetation types:
UPDATE vegetation_types SET default_suitability = 3 WHERE vegetation_id IN (1234, 4567, 7777)
To add an override vegetation suitability for a specific vegetation type and ecoregion:
INSERT INTO vegetation_overrides (vegetation_id, ecoregion_it, override_suitability) VALUES (2222, 14, 0);
To find all the vegetation overrides for a particular ecoregion:
SELECT * FROM vegetation_overrides WHERE ecoregion_id = 14
To delete a particular vegetation override:
DELETE FROM vegetation_overrides WHERE vegetation_id = 2222 and ecoregion_id = 14