MnRAM 3.3 Database Training. Visual Quick Start User Manual. Database information Downloading MnRAM software Getting started entering data Overview of reports Using MnRAM highlights Field/office procedures List of all questions Step by step through all the questions.
Visual Quick Start User Manual
<Save> the file to your hard drive.
Documentation to supplement MnRAM:
These will help you understand the assessment tool, how to prepare for field work, and one way to manage the data after you collect it. They are not required to run the program. Comprehensive Guidance includes a written Quick Reference guide.
These are a standard Microsoft security warnings. Click <Open> on each screen.Opening the Database
LocationID will fill in automatically.
Three-digit identifier unique to each wetland in a cluster (see Comprehensive Guidance) or leave blank.
Letter indicates first (a) or subsequent assessment visits.Adding a New Wetland
Press <X> to close. Your data is saved.
A single Project Name for multiple, related Wetland IDs allows grouping of records in Reports.
The database aspect of MnRAM is fully utilized when a single copy is used to store wetland quality information.
Instead of making several copies of the database for each project, assign unique Project NamesProject Name
Estimated original size of the total wetland if effectively drained or filled areas were restored (not including any buffer area).
Successful creation projects will show negative restorable acreage, upon completion.Wetland Size
Restorable area and % drained/altered is calculated automatically in the database.
Even similar wetlands can differ in small ways—be sure to run through all the questions for every site!Copy wetland record, cont.
Reminder: <Copy to New> will result in identical location data. Don’t forget to return to <Add/Edit> to change the ID of the new wetland.
From this window you add, view, or delete photos. Choose the “open folder” icon to browse to a folder with photo files (set up ahead of time).
Caution: photos take up lots of disk space! Work out a plan for managing photo files ahead of time.
Import/Export data, cont.
Subsets of records can be filtered for:
(click to see sample report)
Shows your responses to each question for a single site.
Does not show vegetation rating.
Site survey, hydrology, topography, aerial photos, soils data
Review other project information
Enter all Wetland IDs
Answer certain marked questions:
Database red highlighted
Excel fieldsheet italicized
Text version “~” in left marginData Collection Procedures, cont.
Before you go outside…
Project name and Watershed.
Other location data is optional.
Size of existing and original size of wetland (anything = zero, enter “0.0001”).
Record special notes and purpose of assessment.
(See next slide for screen view and animated highlights)Entering Data: Getting Started
No data entry on this page.Introduction tab
Check those that apply:
a. ____ Designated trout streams or trout lakes (see MnDNR Commissioners Order 2450 Part 6262.0400 subparts 3 and 5) (If yes, Fishery Habitat Rating is Exceptional).
b. ____ Calcareous fen (Special Status see MN Rule Chapter 7050) (If yes, Vegetative Diversity/Integrity functional rating is Exceptional) Consult MN DNR for regulatory purposes.
c. ____ Designated scientific and natural area (If yes, then Aesthetics/Recreation/Education/Cultural functional rating is Exceptional).
d. ____ Rare natural community (refer to MnDNR County Biological Survey/Natural Heritage)(If yes, Vegetative Diversity/Integrity is Exceptional, also if question 36 is yes and Wildlife Habitat functional rating is Exceptional);
e. ____ High priority wetland, environmentally sensitive area or environmental corridor identified in a local water management plan,
f. ____ Public park, forest, trail or recreation area.Special Features in detail, a-f
Floodplain forest, 3B
Sedge meadow, 13A
Shallow, open water, 16A
Shallow marsh, 13B
Wondering what happened to #2? It comes up later….
2#1: Identify Plant Communities
#3: Rate Plant Communities
Rate quality of each community:
Unsure after seeing the ratings? Reconsider your classification.
Click the Display Name Toggle to alternate.
Don’t try to list every plant.#2: Dominant Species drop-down list
To access the images, press “Image”
(click for image)#2: Cattail Key/Table
If Special Features questions d or i [rare natural community and rare plant species] are answered yes, then this question is yes and Vegetative Diversity function is Exceptional.
5. Y N Is the wetland plant community scarce or rare within the watershed, imperiled (S2), or critically imperiled (S1).?
Yes if Special Features question b is answered yes. If the wetland community identified in Question #1 is 3A (not dominated by silver maple), 4A, 4B, 7A, 7B, 10A, 13A, 13B (mixed emergent marsh not dominated by cattails), 14A, 15A, AND has a High quality rating from Question #2, then this question is yes and Vegetation function is Exceptional; otherwise continue with following questions.#4-5: Rare or endangered vegetation
State Element Rank:
S1: Critically imperiled in the state because of extreme rarity.
S2: Imperiled in state because of rarity.
S3: Rare or uncommon in state.
S4: Apparently secure in state.
S5: Demonstrably secure in state.#5 Guidance, rare community
If yes, then Vegetation function is Exceptional (continue to answer subsequent questions).
Created wetlands would not qualify, regardless of quality.#6: Pre-European-settlement Condition
Individual Community Scores: maintain raw data as recorded.
Highest Quality Community: report the highest-functioning community.
Non-Weighted Average Quality of all Communities: straight average
Weighted Average Quality Based on Percentage of Each Community: multiply each community rating by its percentage, then add all together.Formula: Vegetative Integrity/Diversity
Every other question is formatted as bold just to make it easier to read.
If the question asks for a percentage of H-M-L, put the percentage of each under the correct heading:Field Worksheet: useful tips
H M L
20% 60% 20%
___ Depressional/Isolated (no discernable outlets)
___ Depressional/Flow-through (apparent inlet and outlet)
___ Depressional/Tributary (outlet but no perennial inlet or drainage entering from upstream subwatershed)
___ Riverine (within the river/stream banks)
___ Lacustrine Fringe (edge of deepwater areas)/Shoreland
___ Extensive Peatland/Organic Flat
___ Floodplain (outside waterbody banks)
___ Other ________________________#7: Topographic data
Percent of wetland area inundated: ______%
9. What is the estimated area of the wetland\'s immediate drainage area in acres?_____
10. Wetland size. This information should have been entered on the General Information page. The number remains as a placeholder.#8-10: Site data
Each question has guidance to assist the user in interpreting the question and understanding how to answer in difficult site conditions…MnRAM Rating Questions
…then use the scroll bar to read the text:
#13: Outlet/hydrologic regime
#14: Upland conditions/Immediate upland land use
#15: Wetland soil condition
16-18: Flow-Through Wetlands
#16: Wetland vegetation
#17: Detention of floodwater
#18: Sediment deliveryQuestions #12 - 22
#19: Upland watershed soils
#20: Stormwater runoff
#21: Subwatershed wetland density
#24: Upland area management
#25: Upland Area Diversity and Structure
#26: Upland Slope
#27: Water Quality Protection (downstream resource)
#28: Nutrient loading#23–28: Upland area quality
Difference between #24 and #25:
#29: Shoreline wetland?
#30: Rooted Shoreline Vegetation
#31: Wetland width
#33: Erosion potential (opportunity)
#30: Percent cover (density)
#31: Average width (in-water area)
#32: Emergent shore protection
#33: Shoreline erosion
#34: Bank protection
#42: Amphibian –hydroperiod
#44: Depth for Overwintering
#45: List Wildlife Species
#46: Fishery Quality
#47: List fish species
Formulas are used to arrive at numeric ratings for each function.
Each Vegetative Community is listed with its rating, as well as the other options for that function.
Scroll to see all functions.
(click for image)Run summary report
This is the last tab in the database, where you can see individual ratings for each function for that particular wetland.
Guide policy approaches using MnRAM wetland data.
Two levels allow flexibility for regional landscape or policy differences.Management Classification
Increased Standard keeps more wetlands in the stronger protection levels.MC Preset Options: “Basic” or “Increased”