Transcript MnRAM 3.0 Database Training

MnRAM 3.4 Database Training
A Visual User Manual
1
1
Contents of this slideshow
• Database information
– Downloading MnRAM software
– Getting started entering data
– Overview of reports
• Using MnRAM highlights
– Field/office hints
– List of all questions
2
2
Disclaimer
• 3.4 is in beta release—not yet fully tested (although much
improved over 3.2).
• Your comments are welcome.
• If you don’t see a soil type, watershed, or other item you
expect in a drop-down list, contact us.
• MnRAM is being improved all the time. Planning for
Version 4.0 has already begun.
• For best understanding, review the full Visual User
Manual and the text Comprehensive Guidance.
3
3
Downloading MnRAM 3.4
www.bwsr.state.mn.us/wetlands/mnram/index.html
4
4
Downloading MnRAM 3.4
www.bwsr.state.mn.us/wetlands/mnram/index.html
<Save> the file to your hard drive.
5
5
Opening MnRAM 3.4
• When you first open
the database, there is
a Security Alert. This
is a Microsoft feature
that cannot be
removed.
• Click “Enable this
content” to continue.
6
6
Opening the Database
These are standard Microsoft security warnings.
Click <Open> on each screen.
7
7
Adding a New Wetland
• Wetland Name can be any combination of text +/or
numeric id.
• LocationID will fill in automatically.
• Three-digit identifier unique to each wetland in a cluster
Press <X> to close.
Your data
is saved.
(see Comprehensive
Guidance)
or leave
blank.
• Letter indicates first (a) or subsequent assessment visits.
8
8
Using the Wetland ID Search
Pick your site from this list to start adding data.
9
9
Project Name
• Assigning a Project Name is optional.
• 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 Names
10
10
Wetland Size
Existing wetland area.
Estimated original size of the total wetland if effectively
drained or filled areas were restored (not including any
buffer area).
Restorable area and % drained/altered is
calculated automatically in the database.
Successful creation projects will show negative restorable
acreage, upon completion.
11
11
Adding a New Wetland ID Using
<Copy Wetland >
• If several wetlands share similar
characteristics, you can copy data
from one record over to another…
12
12
Copy Wetland: Two Options
• If you are entering an
additional wetland “on
the fly,” use “Copy to
New Wetland” to name
the new wetland now.
• If you entered all your
wetland names ahead of
time, use the simple
“Copy Wetland” option.
13
13
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.
14
14
Wetland photos
If you want to attach a photo, press
<Photos> on the General
Information tab...
15
15
Wetland photos, cont.
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).
16
16
Wetland photos, cont.
Add photos one at a time. Click the “camera”
icon to view the photo. Once the photo is
open, double-click the image to close it.
17
17
Import/Export data
• Use this feature to
– Import data from a previous version of MnRAM
– Export data to an excel file for custom sorting
– Compile data from different users into a single copy of
the database.
18
18
Import/Export data, cont.
Only records that are checked “complete” on the
Summary tab will be exported.

• Importing will overwrite existing wetlands with new data if
their Wetland IDs match.
• To import without overwriting, use the <Upgrade from 3.2>
option.
19
19
Import GIS data
• Set up in comma-delimited format.
• Comprehensive Guidance has detailed
instructions.
• Imported data will overwrite existing data
with same Wetland ID.
20
20
Update functional summary
• This option no longer has a function.
21
21
Getting Data Out: Reports
Run Summary Report
Individual Site Response
Individual Site Print Summary
22
22
Run Summary Report
Subsets of records can be
filtered for:
– Project
– Location
– Complete status of record
Report Choices:
– Numeric or Text
– Veg or Functional
(click to see sample report)
23
23
Individual Site Response Summary
Shows your responses to each
question for a single site.
Does not show vegetation rating.
24
24
Site Summary Report
• A complete summary of the wetland
• Numeric and text ratings of all functions.
• Vegetative communities, with ratings.
25
25
Data Collection Procedures
26
26
Data Collection Procedures
• Collect background documentation:
– Site survey, hydrology, topography, aerial
photos, soils data
– Comprehensive Guidance covers procedures
for an inventory, map notation, GIS
labeling, managing incoming field data, etc.
• Enter all Wetland IDs
• Answer certain marked questions:
– Database red highlighted
– Excel fieldsheet italicized
– Text version “~” in left margin
27
27
Entering Data: Getting Started
•
•
•
•
Start on the General Information tab.
Project name and Watershed.
Some location data is optional.
Record special notes and purpose of assessment.
(See next slide for screen view and animated highlights)
28
28
Entering Data: General Information
29
29
Drop-down lists
• Some drop-down lists can be edited.
• Most are restricted, to limit confusing
duplicates.
• Report missing choices to the MnRAM
coordinator.
30
30
Entering area data
• Formula
calculations
require area
data.
• If the current
size is zero,
enter 0.0001.
31
31
Introduction tab
• Background history and purpose of wetland
assessment and ranking structure.
• No data entry on this page.
32
32
Special Features tab
• Check all that apply.
• Use scroll bar to see lower portion of page:
Some special features “bump” a wetland into an
Exceptional rating. Others are for record-keeping.
33
33
Special Features, a-f
Is the wetland part of, or directly adjacent to, an area of special natural resource interest?
Check those that apply:
a.
b.
c.
d.
e.
f.
____ 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).
____ Calcareous fen (Special Status see MN Rule Chapter 7050) (If yes, Vegetative
Diversity/Integrity functional rating is Exceptional) Consult MN DNR for regulatory
purposes.
____ Designated scientific and natural area (If yes, then
Aesthetics/Recreation/Education/Cultural functional rating is Exceptional).
____ 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);
____ High priority wetland, environmentally sensitive area or environmental corridor
identified in a local water management plan,
____ Public park, forest, trail or recreation area.
34
34
Special Features, g-m
35
35
#1: Identify Plant Communities
• Up to five communities may be listed.
• Each community’s contribution to the whole wetland
is counted as a percentage of 100%.
• Communities less than 10% are not counted*.
*With one exception (see next slide)
36
36
#1:
Identify
Communities
#3: Rate
PlantPlant
Communities
• Rate
Key quality
out plant
ofcommunities:
each community:
1.
2.
3.
4.
5.
Floodplain forest, 3B – High
– High
Sedge meadow, 13A [10%
rule exception for shallow, open water: any fringe emergent
community]
Shrub-carr, 8B – High
Unsure after seeing the
ratings? Reconsider
Shallow, open water, 16A – High
your classification.
Shallow marsh, 13B – High
1
2
4
3
5
37
37
~ Plant Communities ~
First: Identify & Rate
• Identify communities (#1).
• Cowardin and Circular 39.
• Quality rating of each community (#3).
#2 is a separate table...
38
38
~ Plant Communities ~
Next: record dominant species
• Identify the dominant species that make up at least
10% coverage (#2).
Click here for a drop-down Cover Category list…
39
39
~ Plant Communities ~
#2: Dominant Species drop-down list
• Look up species by common/group name or
by scientific name.
• Click the Display Name Toggle to alternate.
• Don’t try to list every plant.
• Use the <3% cover
class only for rare or
invasive species.
40
40
~ Plant Communities ~
Worksheet
• Each community
has its own section
• Enter cover class
and rate
community quality.
Field Worksheet Side 1
41
41
~ Plant Communities ~
Cattail Key/Table
• For help distinguishing among native,
invasive, and hybrid cattail, click on the
Key (for a written description) or Table
(summary version).
(click for image)
42
42
#4-5-6: Unique sites
4. Are state or federally listed rare plant species or species
found or known to be found recently?
5.
Is the wetland plant community scarce or rare within the
watershed, imperiled (S2), or critically imperiled (S1).?
6.
Does the wetland represent pre-European-settlement
conditions? Created wetlands would not qualify, regardless of
quality.
43
43
Formula: Vegetative Integrity/Diversity
There are four ways to report this function:
Individual Community Scores: maintain raw data as
recorded.
Highest Quality Community: report the highestfunctioning 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.
44
44
Field Worksheet: Side 2
MNRAM 3.0 Wetland Assessment Methodology Score Sheet
• Four columns per sheet
• One wetland per column
or
• Same wetland, different assumptions (one as-is,
another as expected, etc.)
• Watch ratings! You might circle High when the
answer you want give is called “Low” on the
worksheet.
Date:
Wet ID _________
Wet ID _________
Wet ID _________
Wet ID _________
MnRAM
#
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Question Description
Hydrogeomorphology and Topography (circle one)
Maximum Water Depth (inches) : % inundation
Local Watershed Area--immediate drainage (acres)
Estimated size of existing wetland (acres)
SOILS: Upland/Wetland (survey classification +
site)
Outlet characteristics for flood retention
Outlet characteristics for hydrologic regime
Dominant upland land use
Soil condition (wetland)
Rating
Rating
Rating
Rating
Depressional/Isolated,
Depress'l/Flow-through,
Depress'l/Tributary,
Riverine, Lacustrine,
Peatland, Floodplain,
Slope, Other
:
Depressional/Isolated,
Depress'l/Flow-through,
Depress'l/Tributary,
Riverine, Lacustrine,
Peatland, Floodplain,
Slope, Other
:
Depressional/Isolated,
Depress'l/Flow-through,
Depress'l/Tributary,
Riverine, Lacustrine,
Peatland, Floodplain,
Slope, Other
:
Depressional/Isolated,
Depress'l/Flow-through,
Depress'l/Tributary,
Riverine, Lacustrine,
Peatland, Floodplain,
Slope, Other
:
H
F-T: Emergent vegetation (% cover)
Flow-through emerg. veg. (roughness coefficient)
Sediment delivery
Upland soils (based on soil group)
Stormwater runoff pretreatment & detention
Subwatershed wetland density
Channels/sheet flow
Upland buffer average width (feet)
Upland area management
(% of each, minimum 20%)
M
L
N/A
H
M
L
H M
L
H M
L
H
____ %
H M
L
H M
L
H M
L
H M
L
H M
L
H M
L
____ feet
H
M
L
M
L
N/A
H
M
L
H M
L
H M
L
____ %
H M
L
H M
L
H M
L
H M
L
H M
L
H M
L
____ feet
H
M
L
Upland area diversity and structure
(% percent of each)
26
Upland area slope
(% in each category)
H
M
H
M
L
L
H
M
H
M
L
L
M
L
N/A
H
M
L
H M
L
H M
L
H
____ %
H M
L
H M
L
H M
L
H M
L
H M
L
H M
L
____ feet
H
M
L
(click to see the sheet)
25
H
H
H
M
M
____ %
H M
L
H M
L
H M
L
H M
L
H M
L
H M
L
____ feet
H
M
L
L
L
M
L
N/A
H
M
L
H M
L
H M
L
H
M
H
M
L
L
45
45
Field Worksheet: useful tips
• The italicized questions require maps or
other data to be answered.
• 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: H
M
L
20%
60%
20%
46
46
#7-10: Site data
7. Hydrogeomorphology of the site
8. Depth of standing water in the wetland (inches):____
Percent of wetland area inundated: ______%
9. 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.
47
47
#11: Soils data
•
Survey Classification(s):
–
–
Adjacent upland (within 500 feet)
Wetland area
click for image of soil data website
48
48
MnRAM Rating Questions
• Starting with #12, most questions are
answered by filling in A-B-C.
• Each question has guidance to assist the user
in interpreting the question and understanding
how to answer in difficult site conditions…
49
49
Guidance, how to
• For help with individual
questions, click the “?”…
…then use
the scroll
bar to read
the text:
50
50
Image file for diagrams
To access the images,
press “Image”
51
51
Questions #12 - 22
#12: Outlet/Flood retention
#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 delivery
#19: Upland watershed soils
#20: Stormwater runoff
#21: Subwatershed wetland density
#22: Channelization
52
52
#23–28: Upland area quality
• #23: Buffer width
• #24: Upland area management
• #25: Upland Area Diversity and Structure
•Difference
#26: Upland
Slope
between
#24 and #25:
Upland
area management
(#24) measures
the amount
of any
•• #27:
Water
Quality Protection
(downstream
resource)
vegetative cover. This is important for water quality.
• #28: Nutrient loading
• Upland Diversity & Structure (#25) measures the quality of
that cover as habitat for native species.
53
53
#29-34: Shoreland Questions
#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
54
54
#35-41: Habitat
•
•
•
•
•
•
•
#35: Rare wildlife
#36: Rare / natural community
#37: Open water/cover interspersion
#38: Veg. community interspersion
#39: Detritus
#40: Wetland Interspersion
#41: Barriers to wildlife movement
55
55
#42–44: Amphibian habitat
#45–47: Fish habitat
#42: Amphibian –hydroperiod
#43: Amphibian—Fish
#44: Depth for Overwintering
#45: List Wildlife Species
#46: Fishery Quality
#47: List fish species
56
56
#48-57: Aesthetics/values
•
•
•
•
•
•
•
•
•
•
#48: Unique/rare Opportunity
#49: Visibility
#50: Opportunity for use/nearby population
#51: Ownership
#52: Public Access
#53: Human Disturbance
#54: Viewshed Quality
#55 Spatial buffer
#56: Recreational use (potential)
#57: Commercial effects and wetland quality
57
57
#58-63: Hydrogeology
•
•
•
•
•
•
#58: Wetland Soils
#59: Land use/runoff
#60:Wetland size/soils
#61: Hydroperiod
#62: Inlet/Outlet for GW
#63: Topographic relief
58
58
#64-72 Restoration-related questions, Optional
#64: Hydrologic Restoration Potential
#65: Landowners
#66 Wetland Size
#67: Potential Buffer Width
#68: Restoration Ease
#69: Hydrologic Alteration
#70: Potential Classification
#71: Stormwater Sensitivity
#72: Nutrient Loading
59
59
Formula for Functional Rank
• Comprehensive Guidance describes each formula.
60
60
Run summary report
• The last tab is the summary report.
• 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)
61
61
Management Classification
A standard method for assessing MnRAM
results, endorsed by the MnRAM Workgroup.
• Guide policy approaches using MnRAM
wetland data.
• Two levels allow flexibility for regional
landscape or policy differences.
62
62
MC Preset Options:
“Basic” or “Increased”
Basic Protection: fewer
wetlands will remain in the
“Preserve” category
Increased Standard keeps
more wetlands in the
stronger protection levels.
63
63
Known bugs
Deleting an entry from #24-25-26 without
entering a zero may result in a run-time
error. Pressing <End> will return you to the
field to correct your error.
64
64
BWSR MnRAM Support
Natasha DeVoe
(651) 205-4664
[email protected]
65
65