An Integrated Framework for
Evaluating Wetland and Stream

Compensatory Mitigation -
Summary of Pilot Applications

SCCWRP Technical Report 1210
EPA-840-S-22001 | March 2022


-------
An Integrated Framework for Evaluating Wetland and
Stream Compensatory Mitigation - Summary of Pilot

Applications

Eric D. Stein1, Jeff Brown1, Tim Smith2, Cody Cox3, Nathan Nibbelink3, and Katie

Sheehan Hill3

Southern California Coastal Water Research Project, Costa Mesa, CA
2Minnesota Board of Water and Soil Resources
3University of Georgia, Athens

Brian Topping4, Palmer Hough4
4U.S. Environmental Protection Agency Project Managers

March 2022

SCCWRP Technical Report 1210
EPA-840-S-22001


-------
TABLE OF CONTENTS

BACKGROUND AND OBJECTIVES	3

OVERVIEW OF PILOT PROJECTS	5

Minnesota	6

Georgia	7

MAJOR OUTCOMES	9

Minnesota	9

Georgia	13

COMPATIBILITY OF DATA PRODUCTS	20

HOW PILOT PROJECTS HAVE SUPPORTED APPLICATION OF THE FRAMEWORK 21

Minnesota	21

Georgia	22

LESSONS LEARNED AND RECOMMENDATIONS	23

Scoping, Project Management and General Implementation	25

Technical Approach	27

Stakeholder Coordination and Outreach	27

FUTURE EFFORTS	29

Next Steps for Minnesota Program	29

Next Steps for Georgia Program	30

APPENDIX A: OVERVIEW OF MINNESOTA PILOT PROJECT	32

Section 1 Agency Overview	32

1.1	Key agencies and general structure	32

1.2	Authorities	33

1.3	General goals and mandates	34

Section 2 Overview of mitigation components of the state program	34

2.1	The Minnesota Wetland Bank	34

2.2	Number of Mitigation Sites included	35

2.3	Timeframe covered by assessments	35

2.4	Resources (staff, budget etc.)	36

Section 3 Objectives of the case study - what are you trying to accomplish	37

Section 4 Main Challenges	37

An Integrated Framework: Pilot Applications » March 2022	1


-------
Section 5 Approach and Strategy Used	38

5.1	Staffing	38

5.2	Software Used	39

Section 6 Outcomes	40

6.1	Products Produced	40

6.2	Capacities Developed	40

6.3	Partnerships or Leverage Opportunities Enhanced	40

Section 7 Lessons Learned	41

Section 8 Conclusions and Roadmap for the Future	42

APPENDIX B: OVERVIEW OF GEORGIA PILOT PROJECT	43

Section 1 Summary of state program assessing mitigation performance	43

1.1.	Key agencies and general structure	43

1.2.	Authorities	43

1.3.	General goals and mandates	44

Section 2 Overview of mitigation components of the state program	46

Section 3 Objectives of the case study - what are you trying to accomplish	46

Section 4 Main challenges	47

Section 5 Approach and strategy used	49

5.1.	How was it staffed? (internal, contractors)	49

5.2.	Software used	49

5.3.	Process (e.g., stakeholder coordination, key agencies coordinated with, guidance

docs used)	50

Section 6 Outcomes	51

6.1.	Products produced	51

6.2.	Capacities developed	52

6.3.	Partnerships or leverage opportunities enhanced	52

Section 7 Lessons learned	53

7.1.	What worked well/keys to success	53

7.2.	Challenges/things you would have done differently	53

7.3.	Recommendations for others	55

Section 8 Conclusions and roadmap for the future	55

8.1 Recommendations for next steps	55

An Integrated Framework: Pilot Applications » March 2022	2


-------
BACKGROUND AND OBJECTIVES

Compensatory mitigation is a commonly utilized strategy for offsetting unavoidable,
adverse impacts to wetlands, streams and other aquatic resources as a result of permitted
activities that affect aquatic resources. Program managers who are tasked with implementing
and overseeing compensatory mitigation for wetlands, streams, and other aquatic resources
often struggle to identify rigorous, standardized approaches for conducting monitoring and
performance assessments, and to access and manage data relevant to their compensatory
mitigation projects. To provide clearer recommendations and improve consistency of
compensatory mitigation performance assessments across the country, the United States
Environmental Protection Agency (USEPA) Office of Wetlands, Oceans, and Watersheds, in
partnership with the Southern California Coastal Water Research Project (SCCWRP) and the
Environmental Law Institute (ELI) developed a set of best practices for conducting
compensatory mitigation assessments and produced An Integrated Framework for Evaluating
Wetland and Stream. Compensatory Mitigation1.

The Framework includes a series of recommendations and best practices that states can use
to augment their existing programs and ultimately improve their effectiveness. Also included in
the proposed Framework are recommendations for data management that are aimed at helping
to improve data accessibility across agency programs and to the public. The proposed
Framework recommends that comprehensive compensatory mitigation evaluation include
assessments of both project and program performance. To achieve this, the Framework
recommends a flexible, modular approach that allows states to prioritize different modules
depending on their needs and the status of their existing assessment programs. Where feasible,
the Framework recommends implementation of all three modules to provide a comprehensive
evaluation of program performance.

1.	Compensatory mitigation site performance ("Performance"): This module evaluates the
success of mitigation projects relative to defined ecological endpoints (e.g., morphology,
habitats, species, communities), functional goals and permit requirements. This module
can also help assess factors that influence mitigation success and the length of time
necessary to achieve desired targets.

2.	Program effectiveness ("Effectiveness"): This module evaluates the overall effectiveness
of the regulatory program at achieving programmatic goals, such as no-net loss, specific
area goals, and/or desired ecological targets at reach, watershed and regional scales.

3.	Resiliency of compensatory mitigation practices ("Resiliency"): This module evaluates
likely long-term trajectories of compensatory mitigation sites at achieving functional
replacement of aquatic resource impacts. This includes the role of adaptive

1 Stein et al. (2022) An Integrated Framework for Evaluating Wetland, and. Stream Compensatory
Mitigation. EPA-840-S-22001.

An Integrated Framework: Pilot Applications » March 2022

3


-------
management ability to adapt for climate change effects, and vulnerability to future
degradation due to changing land use, climate, and management practices.

To facilitate implementation of the Framework, USEPA funded two pilot projects in the
states of Minnesota and Georgia aimed at demonstrating one or more modules of the
framework and/ or implementation of an open data system to produce data products based on
monitoring data that can be used to inform decision making.

Both pilot projects focused on developing data management systems intended to improve
access to information on compensatory mitigation projects, facilitate information sharing among
agencies and programs and provide easier access of this information to stakeholders, and the
public at large. Improved information access will allow agency staff to better address all three
modules of the Framework.

This report provides a summary of the two pilot projects, lessons learned, and example
products. Details of each pilot study are provided as appendices. These pilot studies are initial
steps toward achieving the overall goals proposed in the Framework. Future efforts will be
necessary to incrementally advance the ability of both programs to fully evaluate compensatory
mitigation program effectiveness. The pilot projects provide examples of a state with a robust
wetland regulatory, monitoring and assessment program (Minnesota) and a state that relies
almost entirely on the Federal agencies for wetland protection and mitigation (Georgia). The
results of these pilot studies, and the associated lessons learned and recommendations, can
provide examples and ideas for other states as they contemplate implementation of the
Framework and work to advance the capacity to address key management questions
nationwide.

An Integrated Framework: Pilot Applications » March 2022

4


-------
OVERVIEW OF PILOT PROJECTS

Minnesota and Georgia provide useful similarities and contrasts in their existing
programmatic structure for regulation and implementation of compensatory mitigation and in
their approaches to the pilot projects. Mitigation banking is the predominant strategy used in
both states, with Minnesota having one of the most active and robust wetland banking markets
in the country with an estimated 400 wetland banks approved since inception of the Minnesota
State Wetland bank in the 1990s and Georgia having 190 banks listed in the Army Corps of
Engineers (ACOE) Regulatory In lieu fee and Bank Information Tracking System (RIBITS).
However, the regulatory structure differs between the two pilot projects. In Minnesota, the
wetland banking program is administered by the Minnesota Board of Water and Soil Resources
(BVVSR, a state agency) through their Wetland Conservation Act (WCA) authorities, in
coordination with the ACOE (although the scope and scale of the state program is much
broader). In contrast, the role of the state is quite limited in Georgia, with the ACOE assuming
the lead oversight role for compensatory mitigation. Reflecting this difference, Minnesota has a
much more robust wetland mitigation monitoring and assessment program and consequently
more state agency capacity for assessment and data management compared to Georgia. Despite
these differences, both states need to improve their data management infrastructure to be able
to answer key questions about compensatory mitigation performance, program effectiveness
and resiliency, and chose this as the focus of their pilot studies. Minnesota hired a third-party
contractor to develop the data management system, whereas the Georgia system was developed
by faculty and staff from the University of Georgia. Figure 1 depicts the status of each state
relative to the implementation process outlined in the Framework. The general implementation
process was structured to provide the information necessary to efficiently address all three
modules for a comprehensive evaluation of program performance. Individual programs may
focus on different steps in the process depending on their needs and priorities.

An Integrated Framework: Pilot Applications » March 2022

5


-------
A

•	prograrnrnati c goal s

•	current conditions and
needs

A

Infrastructure
Development

•	protocols and procedures

•	datatemplates and
checkers

•	reference networks and
arnbientassessement

Operationalization

•	institutional partnerships

•	sharedfunding
mechanisms

•	outreach and reporting

Georgia

Minnesota

%

FIGURE 1: Status of development of the two pilot project states relative
to the implementation process outlined in the Framework (Stein et al.
2022).

Minnesota

Minnesota state agencies and the ACOE have worked together for many years to increase
consistency between state and federal policy regarding compensatory wetland mitigation
programs and mitigation bank implementation. State agencies account for the majority of
waters/wetlands permitting and compensatory mitigation requirements. For example, the
Minnesota Board of Water and Soil Resources (BWSR) approved 175 wetland replacement plans
in 2018 and has processed approximately 305 wetland banking transactions per year
(withdrawals, deposits, and transfers) between 2015 and 2019. Responsibility for the monitoring
of wetland replacement sites is divided based on the time that has elapsed since construction.
The establishment period, roughly defined as the time from construction through the fifth full
growing season, is conducted by the mitigation project sponsor and reviewed by the ACOE,
BWSR, the Department of Natural Resources, and the local government unit with jurisdiction
over the site under WCA. After the establishment period, BWSR takes over long-term
monitoring with the focus primarily on compliance with the conservation easement recorded in
favor of the State of Minnesota.

Once the establishment period has concluded, permittee responsible mitigation sites are
only monitored if a regulatory agency randomly conducts an inspection or if a specific issue is
identified that requires attention. Follow-up assessments to evaluate resiliency and overall
functional condition for permittee responsible mitigation are infrequently performed by state
and local agencies implementing WCA. Wetland bank sites in Minnesota are subjected to a
more structured inspection approach because of a rule that requires BWSR to periodically

An Integrated Framework: Pilot Applications » March 2022

6


-------
inspect wetlands associated with the wetland banking program to ensure that easement
conditions are being met. Data on all wetland banks is managed and organized by BWSR.
Building on recent efforts funded by US EPA, BWSR is in the process of developing a more
comprehensive long-term monitoring approach that will assess resiliency at mitigation sites at
regular intervals using standardized methodologies. Additional details on the Minnesota
program are available in Appendix A.

The Minnesota BWSR is developing a new Monitoring Data Management System (MDMS)
to improve their ability to organize, track and report monitoring data from wetland mitigation
sites. The current pilot study supports this larger effort through support of the following tasks:
(1) developing the specifications and work flow processes for the monitoring module in the
database; (2) developing standardized forms and processes for the collection of wetland
mitigation monitoring data; (3) compiling wetland mitigation site metadata; (4) building the
MDMS; and (5) testing the monitoring module and refining any data collection, submission, or
standardization processes. The final version of the monitoring module will be driven by
electronic data flow that is stored, presented, and accessed in a geospatial format. The stored
data would be accessible via a web-based application operated and maintained by BWSR.

Georgia

Georgia's compensatory mitigation program is administered by the ACOE Savannah
District under the auspices of the Clean Water Act Section 404 program. The mitigation banking
program in the state is quite robust because the Savannah District was an early adopter of the
banking concept and began permitting mitigation banks in the early 1990s. However, the State
of Georgia has no written guidance, policy or regulatory program that regulates impacts to state
waters2. Monitoring of mitigation banks occurs pursuant to the Savanah District's Standard
Operating Procedure for Compensatory Mitigation, associated guidance, and individual
banking instruments. There is currently no central database for cataloging monitoring data.

Prior to 2018, compensatory mitigation in Georgia was governed by the Savannah District's
2004 Standard Operating Procedure for Compensatory Mitigation (2004 SOP). Under the 2004
SOP, each bank was responsible for its own data management (typically in Excel or ArcGIS) and
there was no standard approach to organizing monitoring reports and data. Monitoring data
was typically submitted as hard copy reports and had to be extracted and manually entered
before it could be analyzed. In 2018, the Savannah District adopted a new SOP for
Compensatory Mitigation (2018 SOP). The 2018 SOP is a major overhaul of compensatory
mitigation in the state. It moves the District to a more function-based approach to mitigation,
using the Hydrogeomorphic Approach for wetlands (HGM) and the Stream Quantification Tool
for streams (SQT) as the frameworks for calculating credits for wetland and stream mitigation

2 The State of GA has a Stream Buffer Variance program. The Georgia Erosion and Sedimentation Act (12-
7-1) requires a 25-foot vegetated buffer along all state waters and a 50-foot vegetated buffer on state-
designated trout streams. A variance may be obtained to allow impacts within these buffers under certain
circumstances. Such a variance must be applied for and ultimately approved by the Georgia
Environmental Protection Division. However, this program does not include a compensatory mitigation
element.

An Integrated Framework: Pilot Applications » March 2022

7


-------
projects in the state. The Savannah District also reworked its monitoring and performance
requirements in 2018 with the 2018 Draft Monitoring Guidelines and Performance Standards for
Freshwater Wetlands and Non-Tidal Streams (2018 Monitoring Guidelines). Under the 2018
Monitoring Guidelines, monitoring data must now be submitted electronically via Excel
spreadsheet tools. Neither the 2004 SOP nor the 2018 SOP or associated guidance require long-
term performance or resiliency monitoring beyond that required by permit conditions.
Additional details on Georgia's program are available in Appendix B.

The goal of the pilot project was to build a prototype database and a web interface that
supports existing compensatory mitigation data while also providing a template for desired
new data collection. Specific tasks included: (1) bring together a working group of diverse
stakeholders involved in compensatory mitigation programs in Georgia to address the diverse
needs and common structures across stakeholders; (2) assess practices and standards for current
mitigation data collection, reporting, and use and inventory available datasets; (3) construct a
pilot geospatial database for mitigation monitoring and evaluation; and (4) generate a plan for
scaling up based on stakeholder input and challenges confronted during pilot database
construction. To accomplish these goals, 14 stakeholders involved in compensatory mitigation
in Georgia were assembled for two workshops to provide insight into the state of current data
collection and analysis, identify available datasets to populate the database, define database
goals and priorities, and provide feedback on database elements during the development
process. Due to the lack of consistency in historical data collection and reporting in Georgia
prior to the implementation of the 2018 SOP, the team focused much of their database
development efforts on creating data reporting standards for a range of metrics to facilitate
future analysis. Therefore, the priority of this pilot project became developing tools and
standards to facilitate future data analysis, rather than entering and analyzing trends in historic
data to draw conclusions about the effectiveness of compensatory mitigation programs in
Georgia.

An Integrated Framework: Pilot Applications » March 2022

8


-------
MAJOR OUTCOMES

Minnesota

The MDMS functionality allows users to upload vegetation and hydrology data associated
with long-term monitoring of wetland sites in Minnesota. For mitigation sites, long-term
monitoring data is associated with other information about the site in the BWSR wetland
banking application using a system derived site identification number as the primary key. The
site identification number is assigned during the regulatory review process and is used to link
all information in the BWSR wetland banking application collected during the mitigation site
lifecycle. This includes tabular and geospatial information about the review process,
monitoring, credits and transactions, and compliance inspections. Wetlands that are not
mitigation sites (reference or conservation) can also be assigned a site identification number in
the system to enable data uploads in the condition monitoring module. Using the site
identification number users can access the condition monitoring features of the application and
initiate the data upload process. The landing screen for uploading data, referred to as the
Condition Monitoring Header, is shown in Figure 2.

« Back to List

Condition Monitoring ID:	1340

Site ID	Type Of Site

4953	q Replacement Site

Condition Monitoring Header	Assessment Area Vegetation	Hydrology

Monitoring Year	Data Collected during Monitoring Period

2019	Vegetation

Save Condition Monitoring I Cancel

Created By

Created By	Created Date

Add Monitoring Note

FIGURE 2: Minnesota Condition Monitoring Header landing page for uploading
monitoring data.

Using the data entry fields on the Condition Monitoring Header the user provides the year
monitoring data was collected and the type of data collected. Data uploads are then completed
using the Assessment Area and Vegetation tabs for vegetation data and the Hydrology tab for
water level measurements. Data upload is accomplished using standardized Microsoft Excel
spreadsheet templates for both types of data. Currently BWSR has developed five vegetation
upload templates (each recognizing different data collection methods) and two hydrology
templates (one for time series data and one for manual readings). The user interfaces for each
data type request additional information from the user to further define the data collection
methods and areas of the site where the information is collected. For vegetation data, the
Assessment Area tab is used to identify the boundaries of the area encompassed by the
monitoring using a GIS mapping tool as well as the opportunity to upload maps (in pdf format)
that show transect, meander, or plot locations within the assessment area. Specific information
about the vegetative data collected within the assessment area is entered under the Vegetation
tab. An example of the data capture screen for a circular plot with a 5-foot radius in a sedge
meadow community is provided in Figure 3. After entering the descriptive information about

An Integrated Framework: Pilot Applications » March 2022

9


-------
the sample method, the user can upload data using the templates mentioned previously. All
data submitted for upload are reviewed by an automatic data checker to ensure basic quality
assurance requirements are satisfied before files are accepted into the MDMS. The MDMS
provides specific information on fields that failed the data check to assist users with making
corrections. Hydrology data entry is completed following a similar process under the
Hydrology tab.

Sample ID Information

Assesment Area ID

Sample ID

4953 - 1

V

WEME-1

Community Type



Sample Method

2 - Fresh Wet Meadow

V

Meander v

Date Sampled

Plot Type Meander Type

08/06/2019

	~

I

Circular Rectangle 1 Timed Not

Plot Circular Radius (ft)



Plot Rectangle Dimension (ft)

0



I 0

Meander Timed (minutes)

Meander Species

Shoreline Species

30

ALL

V V

Point Intecept Length (ft)



Point intecept Interval (ft)

0

0

Belt Transect Width (ft)



Belt Transect Length (ft)

0

0

Percent Bareground



Percent Litter Cover

I Percent Bareground J



Percent Inundated



Average Inundation ((in) or N/A)





Cancel

Upload Sample

Choose File No file chosen

FIGURE 3: Example MDMS data capture screen for vegetation data.

An overview of the data compilation, upload, and checking process used in the MDMS is
shown in Figure 4.

An Integrated Framework: Pilot Applications » March 2022

10


-------
FIGURE 4: Overview of data submittal and automated checking process.

The MDMS will be linked with a relational database3 maintained by the Minnesota Pollution
Control Agency to share hydrology data for mitigation sites with other groundwater data
collected and managed by the State of Minnesota. Ultimately, the monitoring data from the
MDMS will be publicly available through the Minnesota Cooperative Groundwater Proeram
managed by the Minnesota Department of Natural Resources. Through their web application
the public can view the location and type of monitoring well data available across the state
(Figure 5). Data can also be downloaded in several formats for further analysis.

3 The Minnesota Pollution Control Agency uses WISKI, a data management platform developed by
Kisters, to store and analyze water resources data.

An Integrated Framework: Pilot Applications » March 2022

11


-------
Cooperative Groundwater Monitoring (CGM)

Map View Table View Feedback

E3I

Reset 1







+











Dryland WMA





y.



Q.











\







¦ - b 	.

1





QWTA ni Staples, CO. RD. 7 R-O-

f





W PR 104







MDH Unique W. 244574







DNR ObweU ft 8GG24







WeC Deoth: 20.00 *







Measure Point Eevafcorv.







jj 1271.21 ft MSL (as of 1974-10-17)







• 1272.82 ft MSL (as of 2016-04-23)







» County: Wadena







B 0 A







'*¦ ¦ ¦ ^<111 jl

















Famham Lake WMA









t







m V

Terms and Conations of Use





FIGURE 5: Minnesota web viewer for accessing groundwater monitoring data.

When completed, a public facing web interface will show the locations and types of
condition monitoring data available across the State. Users will be able to identify sites of
interest and download the selected hydrology and/or vegetation data (Figure 6). The interface
also will include information on the location of approved wetland mitigation banks using
geospatial data collected and maintained by BWSR as part of the agency's wetland banking
review process and easement compliance activities.

An Integrated Framework: Pilot Applications » March 2022

12


-------
FIGURE 6: Interactive public viewer map showing attribute information. The header in
the map interface has links for downloading data.

Georgia

The Georgia pilot project developed products under each of its objectives that will provide
key benefits to compensatory mitigation evaluation both in Georgia and nationally. The Georgia
team hosted two stakeholder workshops to bring together a working group of diverse
stakeholders involved in compensatory mitigation programs to address needs and common
structures across stakeholders (Objective 1). The workshops included members of 14
organizations involved with or interested in compensatory mitigation in Georgia, and provided
a forum for participants to share insights into the state of current data collection and analysis,
identify available datasets to populate the database, define database goals and priorities, and
provide feedback on database elements during the development process (Objective 2). The team
compiled a spreadsheet of available spatial data for each bank to highlight locations where
spatial data is missing in current state databases to improve future data management (e.g.,
missing boundary polygon).

The main product developed through this project is a pilot interactive mitigation evaluation
database for the state of Georgia (Objective 3). The database will be published online, allowing
access to mitigation data upload, download, and visualization by all members of the Georgia
mitigation community including bank providers and regulatory agencies. The construction of
this database is a key step in the development of mitigation data entry standards for the state of

An Integrated Framework: Pilot Applications » March 2022

13


-------
Georgia. The web database application was developed using the RSQLite4 and R Shiny5
packages in the open-source statistical program R6.

The first tab of the online database (Figure 7) includes an interactive map depicting Georgia
mitigation banks, which allows users to zoom into areas of interest within the state. The
interactive map allows users to click on icons representing each bank to view site-level
information (e.g., acres, date established) and turn on other key spatial layers (e.g., service
areas) for the state of Georgia by checking boxes next to the name of each spatial layer in the
panel to the left of the map. Menus on the side panel also allow users to zoom to specific service
areas or banks of interest (Figure 8). Additionally, users can upload shapefiles containing the
locations of individual sampling sites within banks using the "Browse" button at the bottom of
the side panel on this tab. These shapefiles will ultimately be appended to a layer that will be
displayed on the map in this tab in future iterations of the database.

FIGURE 7: Georgia bank sites viewer.

4	KiriU Milller, Hadley Wickham, David A. James and Seth Falcon. 2020. RSQLite: 'SQLite' Interface for R.
R package version 2.2.1. https://CRAN.R-project.org/package=RSQLite

5	Winston Chang, Joe Cheng, JJ Allaire, Yihui Xie and Jonathan McPherson. 2020. Shiny: Web Application
Framework for R. R package version 1.5.0. https://CRAN.R-project.org/package=shiny

6	R Core Team. 2020. R: A language and environment for statistical computing. R Foundation for
Statistical Computing, Vienna, Austria. URL https://www.R-project.org/.

An Integrated Framework: Pilot Applications » March 2022

14


-------
FIGURE 8: Map zoomed into the AA Shaw mitigation bank.

The database also includes eight data entry tabs that facilitate the upload of multiple types
of data (e.g., vegetation, ground cover, groundwater hydrology, surface water hydrology,
macroinvertebrates, wetland large woody debris, stream large woody debris, and habitat-
assessment characteristics) into the database in standardized formats. On each tab, data can be
uploaded either as a batch by uploading a CSV file or entered manually as individual records in
a standardized form (Figure 9), When the user browses and selects a CSV file for batch upload,
the contents of the file will be previewed at the top of the screen (Figure 10). Data is appended
to the database when the user clicks the "Upload" button in the batch entry box or the "Submit"
button at the bottom of the form. While the batch upload tool is likely to be used for the vast
majority of data uploads, the inclusion of the manual data entry form on each tab was deemed
useful because it provides a helpful visualization to orient new users and facilitated discussion
about field modification with stakeholders during database development.

An Integrated Framework: Pilot Applications » March 2022

15


-------
s Map Vegciatan Ground -

? Water Hydrology MawomverteBrates Wi
VEGETATION DATA ENTRY FORM

Woody Deoos Habitat A

±, Download Data Entry Template
A Download M

Assessment AreaMomtoring u

Reference Sit®

Community Type

Common Name

Planted or Volunteer Status

Exotie/lnvasive Species

FIGURE 9: Sample from vegetation data entry form.

CW

























ij

Sites Map Vfcgelatwn

Ground Cover Groundwater Hydrology



later Hydrology Macron vertebras



and Large Yi



















es e

¦oofly s . ream

rje













Choose CSV File





VEGETATION DATA ENTRY FORM



















Browse vegData4 cw





permit no stream

OateV

TimeV

veg_mu

PlotlDV PlotLatV

PlotLongV

refSiteV

•coRigV

subReg65V

CommtypeV

GenusV

upload





200600634 Bannister
Creek

4/19/2021

1200

Banmster_Creek_HGM

GW01 3343

-83 76

0

Piedmont
(ecoreglon
45)



Freshwater
wetland

Betula

A Download Data Entry T
£ Download Metadata

mpiaie



200700968 Hard
Laoot
Creek

4/19/2021

14.00

Hard_Labor_Cteek_HGM

GW01 33.43

-83 78

0

southeastern

Piams

iecoregion

65)

Dougherty
Plains (65g)

Freshwater
Wetland

Betuta







200700968 Hard
Labor
Creek

4/19<2021

1600

Hard_LaOor_CteeK_HGM

GW01 3343

-83 78

0

Soutneastem
Piams
(ecoreglori
65)

Twion
upland
(650)

Ripanan
Zone

Betula







200600834 Bannisier
Creek

4/19/2021

1800

9ann«er_Creek_HGM

GW01 33 43

¦83 78



Ridge &
Valley
(ecoreglon
67)



Upland
Buffer

Betuia







Date





Time

















































Bank







Area/Monitoring Unit





Sampling Plot

















-













































FIGURE 10: Example batch data upload.

QAQC protocols within the data entry forms were developed to flag potentially erroneous
records before they are entered into the database. In the manual data entry forms, field text
changes from black to red to alert the user that entered data is outside of the acceptable range
(Figure 13). Additionally, if the user attempts to upload data with QAQC issues, an error
message will be produced when the "Submit" button is pressed, alerting the user that the data
failed a QAQC check and cannot be appended to the database. An additional message alerts the
user to the specific field(s) that failed the QAQC check (Figure 14). The user must resolve these
QAQC issues to successfully upload data to the database. The batch data upload tools require

An Integrated Framework: Pilot Applications » March 2022

16


-------
data to pass the same QAQC protocols and produce similar error messages highlighting cells
that failed the protocols, forcing the user to correct the data to successfully upload it.

Temperature (degrees C)

pH

DO (mg/L)

Water Quality:





15

20

6



FIGURE 11: Example of field highlighted to alert user to QAQC issue ("pH" text in red).

Submit

There are problems with the entered data that prevented them from being imported into the database.
Resolve these errors before attempting to resubmit.

Entered pH value outside reasonable range (0-14).

FIGURE 12: Example of data submission error due to failing QAQC check.

To supplement the database, metadata spreadsheets for each data entry type, which include
QAQC protocols, units, and descriptions of all fields included in the database, are available for
download in the side panel of each tab (Figure 13). Additionally, to facilitate batch uploads,
CSV data templates can be downloaded from the side panel of each tab, allowing users to
ensure that fields are formatted correctly prior to entering and attempting to upload data
(Figure 14).

A	B	C	D	E	F	G	H

1 Variable

Code

Question Type

Data Type

Min

Max

Units

Options

2 Date

DateV

Date

Date

1/1/1900

current date

N/A

N/A

3 Time

TimeV

Numeric

Numeric

0:00

24:00

24-hour format

N/A

4 Bank

BankID

Dropdown

Text

N/A

N/A

N/A

AA Shaw, Alaculsy, etc.

5 Assessment Area/Monitoring Unit

veg mu

Text

Text

N/A

N/A

N/A

N/A

6 Plot

PlotlDV

Text

Text

N/A

N/A

N/A

N/A

7 Latitude

PlotLatV

Numeric

Numeric

30

35

Decimal Degrees

N/A

8 Longitude

PlotLongV

Numeric

Numeric

-86

-80

Decimal Degrees

N/A

9 Reference Site

refSiteV

Checkbox

Numeric

0

1

N/A

0 = FALSE, 1 = TRUE

10 Ecoregion

ecoRegV

Dropdown

Text

N/A

N/A

N/A

Piedmont (ecoregion 45), Southeastern Plains (ecoregion 65), Blue Ridge

11 Sub-region

subReg65V

Dropdown

Text

N/A

N/A

N/A

Dougherty Plains (65g), Tifton Upland (65h), Atlantic Southern Loam Plain

12 Community Type

CommTypeV

Dropdown

Text

N/A

N/A

N/A

Freshwater Wetland, Saltwater Wetland, Riparian Zone, Upland Buffer

13 Genus

GenusV

Dropdown

Text

N/A

N/A

N/A

All plant genera included in USACE-NWPL list for GA

14 Species Scientific Name

SpSciV

Dropdown

Text

N/A

N/A

N/A

All plant species included in USACE-NWPL list for GA

15 Common Name

SpCommV

Auto-fill

Text

N/A

N/A

N/A

N/A

16 Height

tHeight

Numeric

Numeric

0

200

Feet

N/A

17 DBH

DBH

Numeric

Numeric

0

100

Inches

N/A

18 Age

tAge

Numeric

Numeric

0

1000

Years

N/A

19 Indicator Status Rating

IndStatusV

Dropdown

Text

N/A

N/A

N/A

OBL, FACW, FAC, FACU, UPL

20 Planted or Volunteer Status

PlantVol

Dropdown

Text

N/A

N/A

N/A

Planted, Volunteer

21 Exotic/Invasive Species

ExlnvV

Checkbox

Numeric

0

1

N/A

0 = FALSE, 1 = TRUE

22 Soil Series

soil Series V

Text

Text

N/A

N/A

N/A

N/A

23 jAdditional Comments

commentv

Text

Text

N/A

N/A

N/A

N/A

FIGURE 13: Excerpt from the Georgia vegetation metadata spreadsheet.

An Integrated Framework: Pilot Applications » March 2022

17


-------
A

B

C

D

E

F

G

H

J K L

permit no

stream

DateV

TimeV

WAA

PlotID

PlotLat

PlotLong

refSiteV

CommTypeV

GenusV SpSciV

2 {{character string}}

{{character string}}

{{mm-dd-yy}}

{{hh:mm}}

{{character string}}

{{character string}}

{{numeric}} {{numeric}}

{{numeric}}

{{character string}}

{{character string}} {{chracter string}]

3



















4



















5



















FIGURE 14: Excerpt from the Georgia vegetation data template.

The database also includes a tab allowing users to view, query, and download existing data
stored within the database (Figure 15). On this tab, options are organized under headings for
each data type (e.g., vegetation, ground cover, etc.) Under each heading, data can be viewed by
clicking the "View Data" button, queried by field using dropdown menus (e.g., bank name),
and downloaded by clicking on the ''Download Data" button. The final database tab allows
users to plot data stored in the database to facilitate visualization and analysis of data trends
(Figure 16). This tool allows individual data fields to be selected for analysis and additional
fields to be selected to group data. It also allows the user to specify the type of plot to use for
data visualization.











aiei HvtJroiogv



















*****

Map vegetation











e ¦ Qe









lessmew Data viewei







Date Rang*















ank Name















I I»]















All



-











Vegetation D3ta































View vegetator. Data















± (Download vegetation Data













snow 50 • entries

























Search

I



Permit _ .
NumMr





Assessment







Reference

site Ecoregion

SE

Plams
Sub-
region

Community
Type



Species

Common



Indicator

Planted volunte
Status

Date

Time

Area/Monitofing
Unit

Plot

Latitude

Longitude

Genus

(Scientific
name)

DBH Age

Status
Rating

, « ST"













Piedmont



Freshwaler
Wetland













Q4M 9*2021

12:00

Ro<*y_CreeK_HGM

GW01

3342849

-83 782602

0 (ecoreglon
45)



Betuia

nigra

River Bircn 18

1.8 18

OBL

Planted

2 200700968 LatW
CreeK

04/19-2021

1400

Rockv_CreeK_HGM

G'.VOI

33 42849

¦83 782602

Southeaster
Plains
(ecoregion
65)

Doogheriy

Plains

(65g)

Freshwater
Wei land

Betula

nigra

River even 16

1.6 16

06L

Planted

Hart













^neaSte'n Tfflon















5 200700968 Latxx
cree«

04/1*2021

1600

Pocky_Creek_HGM

GW01

3342849

-83 782602

0 """"
(ecoregion

65)

Upland

(68H)

Riparian Zone

Betuia

nigra

River Bircti 24

24 24

FACW

volunteer

: 		 v

aw













stages

















04/19/2021

1800

«odcy_CreeK_HGM

GW01

33-42849

-83782602

1 vaiiey
(ecoregion



upland Buffer

Betula

nigra

River Birch 22

7-2 22

FAC

VWunteer













67)

















Showing 1 to 4 of 4 entiles



























PKVttUS



Ground Cover Data































\rtew Ground Cover Data















A Download Ground Cover Data













































FIGURE 15: Data viewer tab, which allows data to be viewed, queried, and
downloaded.

An Integrated Framework: Pilot Applications » March 2022

18


-------
ly Debris Strea

Habitat Assessment Data Viewer Graphical Analysis

Select Options

Boxplot



I-

FIGURE 16: Graphical analysis tab, which allows data to be plotted for trend analysis.

Finally, the Georgia team produced a plan for scaling-up the database based on stakeholder
input, lessons learned, and capacities developed through this pilot project (Objective 4). The
plan for scaling-up the Georgia database was divided into three phases. Phase 1 encompasses
pilot database development, which was accomplished under Objective 3 of the current project.
Phase 2, which will last two years, will focus on implementing a soft launch of the database,
beta testing, and iteratively building-out the database based on stakeholder feedback. During
this phase, the team will work with USACE and other partners to lay the groundwork for
requiring database use as part of the formal reporting process under mitigation evaluation
guidelines, select a permanent host for the database, and design a funding model for long-term
maintenance and hosting of the database. Phase 2 will conclude with the launch of the finalized
database for use by all partners and the transition to the permanent hosting arrangement. Phase
3, which will begin at the conclusion of Phase 2, represents long-term hosting and maintenance
of the database. This phase will require regular maintenance and user support,
software/hosting updates, and adapting the database to meet evolving user needs. We estimate
that these Phase 3 tasks will require about 20% of a data manager's time. Specific details about
the plans for scaling-up and implementing Georgia's database can be found in Appendix B. The
plans will also be circulated to all members of the Georgia mitigation community.

An Integrated Framework: Pilot Applications » March 2022

19


-------
COMPATIBILITY OF DATA PRODUCTS

A long-term goal of the Framework is to develop capability to combine mitigation datasets
from different state programs to be able to compare results among regions and assess overall
condition on a regional or national level. To combine datasets from different agencies, the data
needs to be in a similar format, or have data structures that can easily be matched or
transformed (e.g., units) to correspond with variables across agencies. We used the preliminary
results from the two pilot projects to evaluate the ability to combine data sets and to inform
recommendations for future development of data tools.

In this section we evaluate the ability and effort required to combine completed vegetation
data templates from mitigation projects in Georgia and Minnesota. This included one Excel file
of database output from GA that had data for two example mitigation plots, and nine Excel files
from MN, each with data for a separate plot.

Direct merging of all files as they currently exist is not possible, mostly due to differences in
the assessment endpoints used. Some of the files expressed vegetation as a density (number of
individual plant species per unit area), while other files used absolute cover (%) of each species,
and one dataset used height and age (counts would be available by adding up the individuals
of a species). These differences presumably reflect different mitigation performance objectives
or data collection methods. Combining all datasets would be possible if a standard unit of
measurement was used for each species, to derive either counts or percent cover for the data.

Other key differences among the files were the inclusion/ omission of a sample date column
and columns for site coordinates. Sample date is usually an important variable to include with
all field data. It can be used to help combine additional indicators from a particular sampling
period, or to help keep track of a mitigation project's age and succession. GIS data on the other
hand may be included with the field data or maintained in a separate file that can be referenced
by a plot (subplot) identification code.

The last difference to note among datasets is that some files had vegetation strata (e.g., tree,
herbaceous, shrub-sapling) in separate sheets, while other files combined all strata
measurements into a single sheet. While this would require additional effort to combine
datasets, the type of data structure to use should be left to each agency to decide.

In conclusion, use of standard data templates and metadata forms made it easy to access
and interpret the data from each state program. However, the ability to combine data sets to
provide more integrative assessments would require states to adopt common data formats and
assessment endpoints. Standard data formats developed through the National Wetlands
Condition Assessment and National Rivers and Streams Assessment could form the basis of
such standardization in the future.

An Integrated Framework: Pilot Applications » March 2022

20


-------
HOW PILOT PROJECTS HAVE SUPPORTED APPLICATION OF THE
FRAMEWORK

The intent of each pilot project was to demonstrate how investing in data management can
help address the core questions of the Framework and establish a foundation for continued
development of state capacity to evaluate mitigation program effectiveness.

1.	How successful are mitigation sites/banks at achieving their ecological goals?

2.	How effective has the overall program been at achieving its stated goals with respect to
aquatic resource protection?

3.	How resilient are compensatory mitigation sites/banks at replacing the intended
functions over the long term?

Minnesota

With the enactment of WCA in 1991, the State of Minnesota expanded protection to
wetlands not covered under a more limited permit program focused on lakes, streams, and
large wetlands with persistent surface water. The new law established a goal of no net loss of
the State's remaining wetlands. The comprehensive state approach to wetland protection
combined with the requirements of the Clean Water Act Section 404 permitting program have
created a regulatory framework where most wetland impacts require authorization as well as
replacement of lost functions. With over 25 years of experience implementing these programs
Minnesota has a wealth of information from which to evaluate the success in meeting protection
goals such as no net loss. Since the inception of WCA data show that the State has met the goal
of no net-loss of wetland area statewide, but it is unclear if wetland quality and function have
been maintained. A review of wetlands between 2006-2014 observed no-net loss in area;
however, concerns were raised regarding loss of wetland function due to conversions of
wetland type7. A more recent study concluded that quality of depressional wetland mitigation
sites 7-16 years after restoration was similar to quality observed in naturally occurring wetlands
within the same region8. The evaluation of mitigation project success on a comprehensive,
statewide basis has suffered from the same challenges seen in other states: disorganized data
storage, varying report formats and mediums, and the absence of a structured approach and
staff dedicated to a programmatic review of mitigation performance and assessment.

7	Kloiber, S.M. and D.J. Norris. 2017. Monitoring Changes in Minnesota Wetland Area and Type from
2006-2014. Wetland Science and Practice 34: 76-87.

8	Strojny, C., J. Overland, and T. Smith. 2020. Assessing Wetland Quality of Depressional Wetlands to
Refine Restoration Requirements and. Strategies. Report for Grant No. CD-00E02072). Minnesota Board of
Water and Soil Resources. https://bwsr.state.mn.us/sites/default/files/2020-ll/CD%20-

% 2000E02072 % 20Final% 20Project % 20Report % 2030Qct20.pdf

An Integrated Framework: Pilot Applications » March 2022	21


-------
This pilot study has moved Minnesota forward in this context by supporting development
of a data management system that, coupled with planned changes to the monitoring and
reporting done during the mitigation site establishment period, will allow regular evaluations
of program effectiveness and site resiliency. In addition, the structure of the MDMS allows for
these evaluations to be conducted by agency staff directly involved in program implementation
as well as individuals and organizations external to the regulatory programs. Although this
pilot was specifically directed at building the infrastructure to collect and store mitigation site
data and did not involve collection of field data to assess performance, BWSR is engaged in
other efforts partially funded by the EPA to assess resiliency of mitigation sites. The data
produced by these parallel efforts will be the first uploaded to the MDMS beginning in 2021.
When the upload is completed, the MDMS will have vegetation community data for over 50
wetland bank sites across the state and hydrology data from 15 of these sites. Without
development of the MDMS this information would be mostly unavailable outside of BWSR and
would likely be lost for future assessments of resiliency because of the challenges associated
with storage.

Georgia

Analysis of historical (pre-2018) mitigation data has been an immense challenge for agencies
because the data were usually submitted in hard copy or PDF reports, meaning that data must
be extracted and entered manually, which is a very inefficient process, and coupled with the
volume of reports generated makes analysis very challenging. While the initial goal for the GA
pilot database project was to begin addressing this issue by populating the database with
historical data from a subset of sites to provide preliminary assessments of the ecological effects
and resiliency of mitigation banks in Georgia, the project shifted focus away from this objective
at the recommendation of several of key stakeholders, who believed that the lack of historical
data standardization would make analysis of trends difficult or potentially misleading.
Stakeholders noted that there historically was no standardized way to organize monitoring
reports and collect and report many types of mitigation data in Georgia, and that the regulatory
and scientific framework for data collection and reporting has evolved considerably over time,
which would make comparisons between banks over time difficult to interpret. Thus, the pilot
project focused largely on developing data compilation and entry standards to facilitate upload
of current and future data into the electronic database, which will facilitate future mitigation
evaluation in Georgia and permit the effectiveness of mitigation banks to meet ecological goals
to be better assessed.

An Integrated Framework: Pilot Applications » March 2022

22


-------
LESSONS LEARNED AND RECOMMENDATIONS

The two pilot projects were largely successful in that they (1) increased awareness and
knowledge among agency staff and key partners on the needs and importance of managing
compensatory mitigation data in a systematic way; (2) produced prototype systems that vastly
improved data management capabilities; (3) provide a foundation for continued development
and implementation of data management systems that will enhance the ability to answer the
key management questions about compensatory mitigation program effectiveness; and (4) serve
as examples for other states and programs that are considering developing their own wetland
data management systems.

These projects generated important lessons that can inform continued pursuit of the goals of
the Framework nationwide. The lessons learned, and associated recommendations have been
grouped into three major categories of project management, technical approach, and
stakeholder coordination (Table 1).

TABLE 1: Summary of key challenges and potential solutions identified during the
case studies

Issue

Potential Solution

Project Management and Scoping

1

Desired objectives and product end points
may not be clearly defined at the onset of
the project from an IT/ database
architecture perspective

Clearly relate effort to programmatic goals.
Consider utilizing user stories and clear
descriptions when documenting
specifications and work flows to provide as
much detail as possible early in the process

2

Data access tools may be inconsistent with
agency permissions and data policies

Scope development efforts to address access
needs, such as server and firewall issues.
Consult early to ensure appropriate data
access specifications are included

3

Data products and formats may not
directly address key questions

Include end users in development process

4

Third party IT contractors have limited
familiarity with program scope and
operations

Consider requiring vendors to have subject
matter experts on team

5

Concern over the ability to manage and
update the system over time as
technology changes

Explore the use of standard formats or off-
the-shelf applications with standard
approaches vs. customized development

6

Costs and staff capacity for long term
hosting and maintenance

Identify an agency hosted site or third party
location (e.g., university) with dedicated
funding or revenue source (e.g., fees)

Technical Approach

An Integrated Framework: Pilot Applications » March 2022

23


-------
Issue

Potential Solution

/

DiHiLullies in including legacy da La due
to changes in data collection metrics,
standards, and quality

Ideality aad priorilize key legacy da la sels
aad provide resources to digitize; focus
database oa preseat/ future rather thaa
trying to retrofit old data

8

Challenges with assessing long-term
function/performance

Connect products with other available,
current monitoring programs/data

9

Mechanism for data sharing/ exchange
with RIBITS or other data systems

Establish uaiversal digital object ideatifier
(DOI) or other uaique ideatifiers and ideatify
key data fields aad coordinate via web
services or applicatioa program interfaces
(APIs)

10

Requirements for spatial and tabular data
upload/ storage are very different and
could require different user interfaces

Ideatify data types aad aeeds early aad
collaborate with IT staff to develop a
workflow process aad schematic that defines
desired iaputs aad outputs and the
relatioaships betweea spatial aad tabular
data.

11

Long-term monitoring data and
mitigation site establishment data may
have different objectives and/ or varying
collection methodologies

Ideatify core set of moaitoring data for short-
aad loag-term assessmeats aad develop
staadardized methods

12

Need to make data collected at multiple
sub-sites within each bank site (e.g., veg.
plots) spatially explicit to facilitate post-
hoc analysis, but these locations do not
exist in single, standardized database

Create tool to allow baaks to upload sub-site
locatioas directly into the database as
shapefiles or provide the ability to directly
eater spatial information via points or
polygoas

14

Monitoring approaches are not
standardized, and data collected for many
metrics (e.g., vegetation) are not
submitted in standardized formats across
banks.

Create staadardized data eatry forms as part
of the database using most up to date
staadards. Require data uploads to be
staadardized using either dowaloadable
excel templates or a user interface within the
applicatioa. Doa't focus oa matching
specifics from pre-existing data sheets

15

Need capability for "batch data upload
tools" for many data entry types that
require numerous inputs per site (e.g.,
macroinvertebrates, hydrology,
vegetation) so that records don't need to
be entered one at a time

Prioritize batch upload tool developmeat
aad creatioa of dowaloadable excel
templates to standardize formatting over
developmeat of single-entry forms in
database app

Stakeholder Coordination and Outreach

An Integrated Framework: Pilot Applications » March 2022

24


-------
Issue

Potential Solution

lb

Coordination wilh oilier bLilc agenues
collecting and managing similar
monitoring data

Identify PLXJs Ihroughoul sidle dgenues
with overlapping program areas early in
process and involve IT staff in these
discussions

17

Need to identify sentinel/ reference sites
with good long-term datasets to guide
planning/ assessment of other sites

Explore opportunities to partner/leverage
other programs that may provide sentinel
sites, e.g., ambient monitoring program,
conservation programs. Consider
development of regional reference site
networks using a fee-based approach

18

Stakeholders' primary goal for the
database is the ability to
obtain/ download raw data. Online
analytical tools are a secondary priority.

Focus on aspects of the database that
facilitate dataset querying and acquisition
first, then create a few key example analytical
tools, which can facilitate future discussion
about developing an expanded suite of tools

19

Skepticism in user community about
quality of older/ existing data

Focus on future data collection and prioritize
a selected set of past data to determine
challenges and identify benefits of analyzing
older data

20

Achieving consensus from stakeholder
community on data input structure,
priorities, and functionality of the
database

Conduct outreach workshops to gain input
and investment in products early in the
process. Meet with key personnel to discuss
examples and ideas for standardization and
implementation protocols

21

Creating time-efficient opportunities for
regular stakeholder engagement and
feedback on database development.

Prioritize regular meetings with small
groups of key stakeholders to share
development progress and solicit feedback,
which can allow more time for dialogue and
reduce "information overload." Provide
regular email updates to keep stakeholders
engaged during periods when there is less
tangible progress to showcase.

Scoping, Project Management and General Implementation

Agreeing on a clear set of goals and expectations and selecting (or building) the right project
team are important early steps that influence progress and ultimate success of the project. Both
teams emphasized the importance of early and frequent communication with their stakeholders
to clearly define goals and establish a common vision for the desired outcomes and
functionality. This vision is often refined over the course of a project, so ongoing
communication is critical for ultimate success. The Georgia team invested time with
stakeholders and end-users to build consensus around focused goals and well-defined end

An Integrated Framework: Pilot Applications » March 2022

25


-------
products. This not only built support for the project but established common expectations for
the functionality of the products relative to the ability to address agreed upon questions/needs.
However, they focused much of their effort on less frequent, larger stakeholder meetings and
would have benefitted from increased communication with small groups of key stakeholders at
more regular intervals between larger meetings to create more opportunities for iterative
feedback on database development.

The Minnesota team outsourced the technical work to a third-party vendor. The Request for
Proposal that was published for the wetland application did not require that the developer have
individuals with wetland regulatory program familiarity or experience on their team nor did it
require expertise working with GIS/Mapping programs. These were both identified as desired
qualifications but were not required. The selected vendor did not have this expertise on their
team which created significant communication issues associated with wetland mitigation
terminology and familiarity with general program workflows. As a result, BWSR staff had to
invest additional time to correct issues with functionality stemming from lack of subject matter
expertise by the contractor.

Using off-the-shelf platforms for developing the data management system generally results
in lower cost and greater longevity regardless of whether the work is done in house or
outsourced. There are numerous data platforms that are commonly used and can be easily
customized. These systems are typically more stable over time and can be more readily
updated. Using such systems also reduces the likelihood of creating a system that is difficult to
update or becomes obsolete due to its reliance on specific expertise or familiarity. However, the
Minnesota case study lost some of the flexibility associated with developing a standalone
version of their data system because vendors and state information technology staff gravitated
towards consistency in approach for the entire application rather than making use of off-the
shelf software that may have been more efficient or practicable for a single purpose application.

Finally, because all systems must be maintained and updated over time, it is critical to
identify the intended long-term steward of the products and involve them in the scoping
process. This will ensure that ease of maintenance is considered in the design and improve
familiarity with the ultimate product by the entity ultimately charged with implementation. For
states such as Minnesota that have an established program and internal state capacity, long-
term stewardship can be incorporated into existing information technology programs and
maintained using state resources or permit related fees. For states such as Georgia that lack an
established program, a third party, such as university or local agency or conservancy may be
able to serve as a long-term data steward. Reaching this stage in Georgia will require a two-year
intermediate phase focused on a soft launch of the database, beta testing, database build out,
and implementation. This phase will require a full-time database manager, along with
additional staff support and web hosting service fees, which in total are estimated to cost
approximately $120,000 annually. Long-term hosting and management of the database beyond
the intermediate phase will require funding for a web hosting service and a significant portion
of a database manager's time (estimated approximately 20%) to perform regular maintenance
and user support, software and hosting updates, and adapt the database to evolving user needs,

An Integrated Framework: Pilot Applications » March 2022

26


-------
which is estimated to cost approximately $26,000 annually. For such a program to succeed
permitting agencies (e.g., ACOE, State programs) should require mitigation monitoring data to
be submitted to the designated database in specified formats (or using specified templates). In
addition, the data stewardship entity will need a funding mechanism to maintain the data
system (e.g., fees, grants, or dedicated internal funding).

Technical Approach

Creating standard data templates and mechanisms for data queries, access and linkages can
address many of the technical challenges associated with developing data management
systems. Both pilot projects identified a broad range of data types that can be produced in
different formats (e.g., tabular, spatial, time series). Creating standard data templates in flat-file
format was found to provide the maximum flexibility in accommodating a variety of data types.
This approach can accommodate batch upload of data in addition to data entry via a user
interface, which was a desire articulated by many stakeholders. Standard data templates also
allow for the development of automated data checkers and automated data analysis, which can
improve data quality and support timely and readily available data analysis.

Both pilot projects also identified a priority for providing linkages with other data systems
through web services or application program interfaces (APIs). Such linkages can support
connections with other data sets, such as hydrology data sets collected by the Department of
Natural Resources in Minnesota. They can also make it easier to connect with existing wetland
data sets, such as those maintained by US Fish and Wildlife Service and private bankers in
Georgia.

How to accommodate legacy data was a challenge for both case studies. There is broad
agreement of the important context provided by historic data sets, particularly for questions of
resiliency and long-term success. However, integrating these data sets is challenged by lack of
compatibility in data formats or unavailability of older data in digital form. One potential
solution is to identify priority legacy data sets and use them to demonstrate the process,
challenges, and benefit of incorporating them into contemporary data systems. These initial
experiences can be used to determine which data sets provide sufficient benefit to warrant the
investment necessary to integrate them into current data systems and to develop a strategy for
accomplishing this integration. It has a secondary benefit of aiding in tool development by
providing test data that can be used to refine data structures and analytical methods.

Stakeholder Coordination and Outreach

Conducting outreach workshops to gain input and investment in products early in the
process is critical to eventual acceptance and use of any data management system. Both pilot
study teams met with key personnel to discuss examples and ideas for standardization and
implementation protocols early in the process. The Georgia team would recommend balancing
larger workshops with more frequent, targeted meetings with key stakeholders to allow more
opportunities for specific feedback on database development and modification and reduce

An Integrated Framework: Pilot Applications » March 2022

27


-------
"information overload." In Minnesota, additional coordination would have been beneficial as
well. Because of scheduling issues during development of the MDMS, BWSR staff was not able
to include a stakeholder coordination task in the contractor's scope of work and was forced to
independently make decisions on data collection methods, standardization, and reporting that
may have been better discussed in a broader interagency forum. In the future, they recommend
a more coordinated up-front approach to identify stakeholder needs in advance of project
scoping and establishment of a standing interagency workgroup to provide input when needed
during the process. This would also be beneficial in adjusting agency policy to orient the state
and federal wetland mitigation programs to direct monitoring data towards the local data
management system and having it serve as a repository for all long-term monitoring data.

Sentinel sites provide important context for assessing resiliency of compensatory mitigation
sites and long-term program success. These sites can often come from other programs such as
ambient monitoring under water quality programs, status and trends sites, or conservation sites
from wildlife or sensitive species protection programs. Considerable long-term benefit can be
achieved by broadly surveying agency and community programs, watershed plans, and
stakeholder groups to identify candidate sentinel sites with permanent protection or
management. This allows targeted effort and resource allocation at sites with the greatest
potential benefit for long-term monitoring. Early and ongoing communication helps identify
these partnership opportunities, build collaborations, and account for data sharing between
programs in design of the data management system from the onset of the program
development process. For example, in Minnesota the Department of Natural Resources has
assumed the lead role in establishing wetland hydrology reference sites across the state to
gather data that can be used in permit decisions, mitigation site assessment, and long-term
trend analysis. Other state and federal agencies have participated in the site selection process
and the data will be available through the State's Cooperative Groundwater Monitoring
Program.

An Integrated Framework: Pilot Applications » March 2022

28


-------
FUTURE EFFORTS

Conclusion of the pilot project does not constitute completion of the desired work for either
state. Both states hope to build on the foundation of their initial efforts and continue to enhance
their data management systems to support evaluation of compensatory mitigation. Future
efforts will include:

•	Expanding standard data templates and checkers to include additional data types

•	Providing expanded functionality for batch uploads of data

•	Improving capacity to accept and manage geospatial data

•	Retrofitting historical data for inclusion in the data management system

•	Expanding data query capabilities to better cross-link different data types and sources

•	Developing tools to facilitate graphical analysis of data trends

•	Automating routine data analyses to hasten output to end-users

•	Securing commitments and funding for long term hosting and stewardship

•	Enhancing dynamic data linkages with other data systems to better leverage data
between programs

Robust data management is an important tool for full implementation of all three modules
of the Framework, performance evaluation, program effectiveness assessment, and
determination of long-term resiliency. A mature compensatory mitigation evaluation program
will include infrastructure, staffing, funding, and partnerships necessary to support all three
modules and to provide ready access to the data and information produced through these
evaluations. This will in turn allow for ongoing program refinement and ongoing evaluation.
As states work to improve their capacity for managing and analyzing data to assess
compensatory mitigation effectiveness, USEPA will need to develop tools and approaches to
synthesize state data into regional or national data sets. This will involve aligning and
reconciling data fields, checking data accuracy and completeness, and compiling metadata
(among other challenges). Only through development of these tools will larger/national
evaluations of compensatory mitigation program effectiveness be possible.

Next Steps for Minnesota Program

Technical

•	Link the newly developed database to a groundwater monitoring database managed by
other state agencies such that hydrology data collected at wetland mitigation sites will

An Integrated Framework: Pilot Applications » March 2022

29


-------
be stored in a larger statewide database that can be accessed through a web-based
application.

•	Develop capacity for vegetation data to be accessible to external users (outside of BWSR)
through a web-based interface. Although this data will not be integrated with wetland
condition data collected by other agency staff in Minnesota it does provide a platform to
build on and satisfies a short-term goal of organizing the data and making it available
through a web-based interface.

•	Upload data collected as part of recent long-term monitoring studies. Working with the
other state and federal agencies in Minnesota establish a requirement for mitigation sites
leaving the establishing monitoring period to provide standardized vegetation and
hydrology data that will serve as a baseline for future monitoring as part of assessing
site resiliency.

•	Establish a process for determining historical wetland mitigation sites for which
establishment data will be obtained from files and loaded into the MDMS.

•	Develop automated quality control process to verify well identification number
provided by the MDMS user is associated with the location information for the
identification number in the state database.

Testine / Refinement

•	Develop a protocol to integrate taxonomic changes into the MDMS data checker.

•	Increase MDMS functionality by adding the ability to calculate standard metrics of
interest such as percent native cover, native species richness, and measures of floristic
quality.

•	Enhance user interface for accessing uploaded vegetation and hydrology data through
improvements to BWSR website and GIS web maps.

Outreach

•	Once long-term monitoring data processes have been established and successfully
implemented, efforts will be directed toward integrating reporting and data collection
from the establishment period into the MDMS so that all monitoring data for mitigation
sites can be collected and stored in one location.

•	Provide training to stakeholders on access to, and use of, the MDMS to increase
awareness and familiarity.

Next Steps for Georgia Program

Technical

An Integrated Framework: Pilot Applications » March 2022

30


-------
•	Develop general user instructions document to serve as a database homepage to guide
new users.

•	Work with stakeholders to fine-tune QAQC protocols for specific data fields and locate
missing spatial data (e.g., bank boundaries) for inclusion in the database.

•	Expand QAQC protocols (e.g., coordinate system) for sampling site shapefile upload
tool.

•	Create additional query fields in data viewer tab to allow users to better filter data by
fields of interest.

•	Expand pilot graphical analysis tool to better allow users to explore trends in data.

•	Decide on best way to link vegetation data with soil series (currently there is a
placeholder text field).

Testine / Refinement

•	Allow stakeholders to begin uploading sample datasets to beta test database and allow
them to provide feedback on processes that were unclear or bugs that they encountered,
which can then be iteratively addressed.

Outreach

•	Circulate plan for beta testing, "going live," and scaling up the database within Georgia
mitigation community.

•	Once technical and testing objectives have been accomplished, share the link to the
online database with all stakeholders in the GA mitigation community and encourage
them to begin uploading recent datasets.

An Integrated Framework: Pilot Applications » March 2022

31


-------
APPENDIX A: OVERVIEW OF MINNESOTA PILOT PROJECT

Section 1 Agency Overview

1,1 Key agencies and general structure

Alterations to lakes, rivers, streams and wetlands in Minnesota are regulated by a mix of
programs administered by state and local governments. The main state water/wetland
regulatory programs in

Minnesota is described briefly below.

•	CWA Section 401 - authorizes state agencies to impose conditions or prevent issuance of
Section 404 permits to ensure compliance with state water quality requirements;
administered by the Minnesota Pollution Control Agency (MPCA).

•	Public Waters Permit Program (PWPP) - regulates alterations to the course, current or
cross section of public waters and public waters wetlands; administered by the
Minnesota Department of Natural Resources (DNR). Public waters are a defined subset
of all lakes, streams and wetlands meeting certain criteria.

•	Water quality standards - regulates point source and non-point source discharges and
physical alterations of wetlands. Generally applied through other regulatory programs,
such as National Pollutant Discharge Elimination System (NPDES) permits or Section
404 permits. Administered by the MPCA.

•	Wetland Conservation Act (WCA) - regulates draining, filling, and in some cases
excavation in all wetlands exclusive of public waters wetlands; administered by local
governments with oversight from the Minnesota Board of Water and Soil resources
(BWSR). In state statute and rule, authorizations under WCA to impact wetlands are not
referred to as "permits" - impacts are authorized under exemptions, no-loss
determinations and wetland replacement plans.

Although the agencies administering each of these programs have the authority to require
mitigation to offset approved impacts to waters/wetlands by far the most active program with
respect to mitigation is WCA. Referred to as wetland replacement under this program, WCA
requires that no person may impact a wetland, wholly or partially, without being eligible for an
exemption, receiving a no-loss determination, or first having a wetland replacement plan
approved by the local government unit. The requirement for replacement for most wetland
impacts under WCA creates a significant demand for wetland replacement. In calendar year
2018, WCA local government units approved 175 replacement plans (i.e., permits) resulting in
84.23 acres of wetland impact. This does not include wetland impacts associated with local
government road improvement projects which, based on historical wetland credit usage, would
double this impact amount. Responsibility for the monitoring of wetland replacement sites (i.e.,
mitigation site) is divided based on the time that has elapsed since construction. The

An Integrated Framework: Pilot Applications » March 2022

32


-------
establishment period, roughly defined as the time from construction through the fifth full
growing season, is done by the mitigation project sponsor with review and oversight provided
by ACOE, BVVSR, DNR, and the local government unit with jurisdiction over the site under
WCA. After the establishment period, BWSR takes over long-term monitoring with the focus
primarily on compliance with the conservation easement recorded in favor of the State of
Minnesota.

1.2 Authorities

1.2.1	Minnesota Wetland Conservation Act

The Minnesota Wetland Conservation Act (WCA) was enacted in 1991 to protect wetlands
not protected under DNR's public waters permit program and to provide no net loss of
Minnesota's remaining wetlands. The basic requirement is that "[w]etlands must not be drained
or filled, wholly or partially, unless replaced by restoring or creating wetland areas of at least
equal public value under a[n approved] replacement plan." (Minn. Stat. § 103G.222, subd. 1(a)).
As a result of legislation adopted in 2000, the WCA also applies to excavation in permanently
and semi permanently flooded areas of types 3, 4, and 5 wetlands (See Minn. Stat. §103G.222,
subd. 1).

1.2.2	Minnesota DNR Public Wafers Permit Program (MnDNR PWPP)

Work in public waters has been regulated by the Minnesota Department of Natural
Resources ("DNR"), or its predecessor the Department of Conservation, since 1937. The basic
rule is that a public waters work permit must be obtained from the DNR for work affecting the
course, current, or cross-section of public waters, including public waters wetlands (See Minn.
Stat. § 103G.245, subd. 1(2)). This would include, for example, work involving draining, filling,
excavating, and placing structures in public waters wetlands.

Public waters wetlands are a subset of the broader category of "public waters" regulated by
the DNR, which includes most lakes and larger streams and rivers. Public waters and wetlands
have been inventoried by the DNR and are shown on maps for each county. Public waters
wetlands are defined in statute as follows:

"Public waters wetlands" means all types 3, 4, and 5 wetlands, as defined in United
States Fish and Wildlife Service Circular No. 39 (1971 edition), not included within the
definition of public waters, that are ten or more acres in size in unincorporated areas or
2-1/2 or more acres in incorporated areas."

In general, PWPP rules stipulate that, "The commissioner may not issue a permit that causes
pollution, impairment, or destruction of the air, water, land, or other natural resources so long
as there is a feasible and prudent alternative consistent with the reasonable requirements of the
public health, safety, and welfare."

An Integrated Framework: Pilot Applications » March 2022

33


-------
1.3 General goals and mandates

The purpose of the WCA is to:

a.	achieve no net loss in the quantity, quality, and biological diversity of Minnesota's
existing wetlands;

b.	increase the quantity, quality, and biological diversity of Minnesota's wetlands by
restoring or enhancing diminished or drained wetlands;

c.	avoid direct or indirect impacts from activities that destroy or diminish the quantity,
quality, and biological diversity of wetlands; and

d.	replace wetland values where avoidance of activity is not feasible and prudent.

Applicants seeking to impact a wetland where submission of a replacement is required must
demonstrate that they have exhausted all possibilities to avoid and minimize wetland impacts
according to the sequencing requirements codified in rule. In addition, the applicant must also
provide information documenting that the replacement site meets the standards and guidelines
in rule to ensure adequate replacement of wetland function and value.

Section 2 Overview of mitigation components of the state program

2.1 The Minnesota Wetland Bank

Under Section 404 of the Clean Water Act and Minnesota state regulatory programs,
unavoidable wetland impacts are potentially subject to compensatory mitigation unless a
specific exemption from this requirement exists. As the name implies, the goal of compensatory
mitigation, or wetland replacement, is to compensate for or replace the functions and values
that the impacted wetland provides. Minnesota state agencies and the ACOE have worked
together for many years to achieve consistency between state and federal policy regarding
compensatory wetland mitigation, and the ability of the COE to adapt their more flexible policy
to changes in WCA rules has contributed to this consistency. In most instances, wetland
mitigation projects that meet state requirements will also meet federal requirements and vice
versa. Minor differences are generally the result of inconsistencies between COE, St. Paul
District policy and WCA rules, rather than conflicts between state statutes and the Federal
Mitigation Rule.

Both the state and federal regulatory programs in Minnesota have a stated preference in
regulation/rule for mitigation that is completed in advance of the authorized impacts.

Although some permittee responsible, or project-specific, mitigation is still used today the vast
majority of the wetland mitigation in Minnesota is accomplished through wetland banking.
Minnesota has one of the most active and robust wetland banking markets in the country with
an estimated 400 wetland banks approved since inception of the Minnesota State Wetland bank
in the 1990s. The strong demand for credits affects both the project development part of the

An Integrated Framework: Pilot Applications » March 2022

34


-------
program and the transaction side of the program. The state has documented a significant
increase in the number of wetland bank documents submitted for review over the past three
years with just over 80 different submittals in 2019. On the transaction side, staff at BWSR have
processed approximately 305 wetland banking transactions per year (withdrawals, deposits,
and transfers) between 2015 and 2019. Despite a strong wetland banking program and the high
volume of wetland banking activity BWSR is pursuing an in-lieu fee (ILF) program. The ILF is
specifically designed to service public transportation projects to assist local and state road
authorities with obtaining mitigation credits for projects in a predictable and efficient manner.

2.2	Number of Mitigation. Sites included

Once the MDMS is open for production in 2021, BWSR staff will begin entering data for sites
that have been the focus of three recent USEPA grants focused on long-term condition
monitoring of restored wetlands. Two of these grants are directed specifically at vegetative
quality and the other is looking at hydrology. Results from the completed study can be found
on BWSR's website. This BWSR led effort will result in long-term vegetative monitoring data
(from 5 to 15 years post-construction) for approximately 50 wetland bank sites to be publicly
available. In addition, hydrology data for 15 wetland bank sites in southern and southwestern
Minnesota will also be uploaded and available. The MDMS also will be accessible for other
agency staff and consultants to upload data on a voluntary basis. Additional coordination will
be conducted in the near future to establish and implement procedures that will require
wetland bank sponsors to collect and submit monitoring data into the MDMS for their projects
as part of each site's monitoring requirement.

2.3	Timeframe covered by assessments

Post-construction monitoring of mitigation sites in Minnesota is the responsibility of
multiple parties depending on the type of compensation site and the time that has elapsed since
construction was completed. All mitigation sites in Minnesota are monitored from the time
construction activities are completed (earthwork and initial vegetation establishment) until the
site has met performance standards as determined by the federal, state, and local agencies with
jurisdiction over the site. This is referred to as the establishment period. For wetland banks,
both the federal and state programs require the site to be monitored for five years unless there is
justification for a longer duration (e.g., wooded sites or bog restorations). Permittee responsible,
or project specific, mitigation sites have less stringent monitoring requirements but still must
demonstrate that the site has achieved the functional goals established in the approved
mitigation plan. Establishment period monitoring is the responsibility of the wetland bank
sponsor or the permittee in the case of project specific mitigation. Once the establishment
monitoring period has ended the site enters what is referred to as the long-term monitoring
phase. Long-term monitoring is handled differently for project specific and wetland banking
sites.

Once the establishment period has concluded project specific mitigation sites are only
monitored if a regulatory agency randomly conducts an inspection or if a specific issue is

An Integrated Framework: Pilot Applications » March 2022

35


-------
identified that requires attention. Follow-up assessments to evaluate resiliency and overall
functional condition for permittee responsible mitigation are infrequently performed by state
and local agencies implementing WCA. Specifics regarding follow-up assessments by federal
agency staff are not available but is assumed they are equally as infrequent.

Wetland bank sites in Minnesota are subjected to a more structured inspection approach
because of a rule that requires BWSR to periodically inspect wetlands associated with the
wetland banking program to ensure that easement conditions are being met. The frequency is
not specific in rule but BWSR has loosely adopted an approach that sets a goal of conducting at
least a desktop review of each site every three to five years. Site visits are conducted where a
desktop assessment identifies a potential issue at a site. The periodic inspections have not been
focused on collecting site data to assess wetland condition in the context of resiliency. Instead,
the inspections have focused on easement violations such as encroachment, vegetation
alteration, signage requirements, trails, and structure maintenance and modification. BWSR's
approach to long-term monitoring changed significantly in 2016 when the EPA awarded a
Wetland Program Development Grant (WPDG) to assess the long-term condition of wetland
mitigation sites, wetlands restored for other conservation programs, and unrestored reference
wetlands. The study, which concluded in 2020, focused on the mixed woods plains and
temperate prairies ecoregions of Minnesota and documented vegetative community condition
at 32 wetland bank sites. Although resiliency is not mentioned specifically in the grant
application, one of the primary objectives of the 2016 study is to assess this mitigation site
attribute by focusing on sites that were 7-16 years post restoration. The study focused on
depressional wetlands and found mitigation sites to have similar floristic quality as naturally
occurring sites. In recognition of the value of the 2016 study, BWSR has received additional
WPDGs from the EPA to study hydrology of restored sites in the same geographic area of the
2016 effort (focusing on many of the same sites) and to continue vegetative condition
assessments throughout the rest of the State. Although these efforts are heavily subsidized
through the award of EPA WPDGs, BWSR intends to use these initial studies as the baseline for
a more comprehensive long-term monitoring approach that will assess resiliency at mitigation
sites at regular intervals using standardized methodologies.

2.4 Resources (staff, budget, etc.)

BWSR is responsible for oversight of implementation of the WCA in Minnesota. This
includes the day-to-day operations of a statewide regulatory program but also the responsibility
for managing the State Wetland Bank and satisfying the requirements in statute and rule for the
monitoring and enforcement of conservation easements. BWSR employs a Wetland Mitigation
Monitoring Specialists who is the agency lead for planning, developing, and managing
monitoring programs for wetland mitigation sites. These tasks are split between programs
focused on long term monitoring of mitigation sites and those associated with establishment
monitoring of BWSR sponsored wetland banks. Currently, this employee spends approximately
60% of their time annually on long term monitoring activities. The Wetland Mitigation
Monitoring Coordinator position is supplemented by seasonal hires who are hired to conduct
monitoring during the growing season in Minnesota (April through September). These seasonal

An Integrated Framework: Pilot Applications » March 2022

36


-------
staff typically add 0.5 to 1.0 full-time employees to BWSR each year. Additional staff assist with
planning and implementing hydrology monitoring activities. Without this assistance it would
be difficult to conduct site inspections at more than 10 to 15 sites annually.

Section 3 Objectives of the case study - what are you trying to accomplish

The study will enhance BWSR's ability to effectively manage monitoring data collected at
wetland mitigation sites by developing a comprehensive data management system specifically
for wetland mitigation sites. The ability to collect, organize, and make monitoring data available
for analysis will help inform future program policies regarding compensatory mitigation.
Minnesota has invested considerable resources in monitoring the status and trends of wetlands
but lacks the ability to efficiently collect and integrate data from mitigation sites to evaluate
overall program success and to integrate our mitigation programs with other status and trends
data.

A new data management system, referred to as the Monitoring Data Management System
(MDMS), will be integrated into the framework of a new wetland mitigation database currently
being developed by BWSR. Funding for the study was used for five specific tasks. These
include: (1) developing the business requirements of the monitoring module in the database; (2)
developing standardized forms and processes for the collection of monitoring data; (3)
compiling wetland mitigation site metadata; (4) building the MDMS; and (5) testing the
monitoring module and refining any data collection, submission, or standardization processes.
Consistent with the preliminary recommendations in the soon to be published technical report
addressing the evaluation of stream and wetland compensatory mitigation, the final version of
the monitoring module will be driven by electronic data flow that is stored, presented, and
accessed in a geospatial format. The stored data would be accessible via a web-based
application operated and maintained by BWSR. BWSR currently provides wetland bank credit
availability and site location information in a similar manner using a web-based tool on our
agency website. Providing access to monitoring data would benefit local, state and federal
agencies involved in the regulatory programs in Minnesota as well as researchers, academics,
and other individuals and/ or organizations interested in assessing the success of mitigation
activities.

Section 4 Main Challenges

The opportunity to develop the MDMS came at a time when BWSR was planning for
replacement of its FoxPro based wetland banking database. Combining these two projects into
one single project resulted in several significant challenges. Those associated with the MDMS
are described below.

Development Schedules and Prioritization of Functionality: The more comprehensive
database replacement project involved the development of an application with five functional
areas, or modules, with the MDMS being housed within the monitoring module. The
development schedule provided by the vendor had the modules built in series which resulted

An Integrated Framework: Pilot Applications » March 2022

37


-------
in a silo approach and impacted the schedule when a module fell behind. Further, because other
modules were determined to be higher priority for implementation of the State's wetland
mitigation program the MDMS was pushed back in the schedule and was eventually released as
part of the second version of the wetland application because of scheduling issues.

Qualifications of the Development Team: The Request for Proposal that was published for
the wetland application did not require that the developer have individuals with wetland
regulatory program familiarity or experience on their team nor did it require expertise working
with GIS/Mapping programs. These were both identified as desired qualifications but were not
required. The selected vendor did not have this expertise on their team which created
significant communication issues associated with wetland mitigation terminology and
familiarity with general program workflows.

Software Requirements/Options: As part of a larger database project, some of the flexibility
associated with developing a standalone version of an MDMS like application was lost because
vendors and state information technology staff gravitated towards consistency in approach for
the entire application rather than making use of off-the shelf software that may have been more
efficient or practicable for a single purpose application.

Other challenges not necessarily associated with the development approach are described
below.

Aeency Coordination and Consideration of Future Directions: Support for development of
the MDMS was consistent throughout BWSR and other regulatory agencies in Minnesota.
However, agreement on assessment methodologies and reporting protocols was not sought and
obtained prior to initiation of the MDMS build. Instead, BWSR relied on its experience with
conducting wetland condition assessments as the basis for setting the standards for the MDMS
with respect to data upload especially data associated with vegetation. While this is not
anticipated to be problematic from an agency coordination and concurrence standpoint there
were situations where the MDMS build forced BWSR staff to make decisions on data collection
methods, standardization, and reporting that may have been better discussed in a broader
interagency forum. A more coordinated up-front approach to the MDMS and a standing agency
workgroup to provide input when needed during the process would have been useful during
the process. This would also be beneficial in adjusting agency policy to orient the state and
federal wetland mitigation programs to direct monitoring data towards the MDMS and having
it serve as a repository for all long-term monitoring data.

Section 5 Approach and Strategy Used

5,1 Staffing

Staffing support for the MDMS study was focused on the vendor development approach
used for the larger BWSR database replacement project. Using a competitive request for
proposal process, a third-party vendor was selected through a submission evaluation process
that included members with expertise in information technology and wetland banking subject

An Integrated Framework: Pilot Applications » March 2022

38


-------
matter experts (preferred but not required). The contract, and communications with the vendor,
was managed by Minnesota Information Technology Services (MNIT) who is the information
technology agency for Minnesota's executive branch. MNIT provided a dedicated project
manager and access to several staff who are assigned to a BWSR support team that aids with the
development of new applications and the maintenance of existing ones. The Wetlands Section at
BWSR provided a single point of contact that was familiar with the existing wetland banking
application and the wetland banking program in general. This person provided direct input to
the development process but also was responsible for obtaining input from other BWSR
Wetlands Section staff when necessary. A summary of the MNIT/BWSR development team is
provided in the table below.

TABLE A1: Summary of Minnesota Development Team.

Position

Agency

Roles/Responsibilities

Membership

Project Manager

MNIT

Manages contract, liaison
between vendor and State
agencies

Standing

Application

Support

Specialist

MNIT

Provides technical input
regarding state data
management requirements and
standards.

Standing

GIS Specialist

MNIT

Provides technical support
regarding geospatial data, data
standards, and workflow
processes

Standing

Wetland

Mitigation

Coordinator

BWSR

Wetland mitigation program
subject matter expert

Standing

Various

BWSR

Wetland mitigation subject
matter experts (monitoring,
plant identification, hydrology,
etc.)

As needed

5.2 Software Used

The MDMS is part of a larger effort by BWSR to replace an existing FoxPro application that
was used to manage wetland banking activity in Minnesota regulated under WCA. The goal of
the larger project was to replace the existing FoxPro application with an Oracle (or other) based
solution that is able to meet all activities and specifications required by BWSR. The respondents
to the State's RFP were given the flexibility to propose to develop/modify an existing
application (if licensed to do so) or to build a new application as long as it could be
demonstrated the solution would meet all business requirements and meet or exceed
performance expectations.

An Integrated Framework: Pilot Applications » March 2022

39


-------
The selected vendor chose to develop the wetland application on a Windows .Net platform as a
web hosted service on the internal BWSR network with server-side session-based
authentication. The web components will be Angular developed with a focus on security and
accessibility so the application will meet current State of Minnesota standards. The application
data will be hosted in an Oracle 12.x relational database.

Section 6 Outcomes

6.1	Products Produced

The MDMS consists of an Oracle based electronic data upload and retrieval system designed
specifically for data associated with long-term monitoring of wetland mitigation sites. The
application accepts vegetation and hydrology data for sites for multiple monitoring
periods/ events. General information regarding the mitigation site is in the application prior to
monitoring or will be entered by BWSR to establish the site in the MDMS. Users have the
opportunity to upload maps identifying the assessment area and sample locations for
vegetation data. Hydrology data is associated with a well location and will be identified as time
series data or manual readings. Data previously entered in the application will be displayed to
users through a public GIS interface that shows the location of the mitigation sites in Minnesota
and the types of data available at that location. For data retrieval, users will be directed to the
Cooperative Groundwater Monitoring application for hydrology data, or an interactive site
with filters for vegetation data downloads.

6.2	Capacities Developed

Development of the MDMS provides BWSR, and the State of Minnesota, the ability to
compile, save, and make available long-term wetland mitigation site data. This is a significant
improvement over the hard copy and/or disorganized electronic filing systems that exist
currently. The MDMS allows monitoring data to be linked digitally with the wetland banking
database where information on the site, conservation easement, and credit transactions are
maintained. Further, the MDMS will be linked to spatial data for wetland mitigation site
easements that is obtained during the establishment of the mitigation site as well as compliance
data collected as part of BWSR's statutory responsibility to periodically inspect easements for
these sites. The MDMS will bring these previously disconnected agency processes together
thereby increasing BWSR's ability to assess the success of the wetland mitigation program.

6.3	Partnerships or Leverage Opportunities Enhanced

The State of Minnesota has three agencies participating in the regulation and assessment of
wetlands. As expected, this has created silos between the programs with respect to the
collection, storage, and availability of monitoring data. Efforts to address the barriers associated
with wetland monitoring data began many years ago and progress has been made. However,
many challenges remain and one of the most significant from a regulatory program perspective
was the vast amount of data collected each year for the monitoring of wetland mitigation sites
and the inability to access and make use of this information for purposes other than single site

An Integrated Framework: Pilot Applications » March 2022

40


-------
evaluations. This pilot study identified several opportunities to share this information outside
of the regulatory arena. First, the MDMS will be linked to a groundwater monitoring database
managed by other state agencies such that hydrology data collected at wetland mitigation sites
will now be stored in a larger statewide database that can be accessed through a web-based
application. Second, vegetation data will now be accessible to external users (outside of BWSR)
through a web-based interface. Although this data will not be integrated with other wetland
condition data collected by agency staff in Minnesota it does provide a platform to build on and
satisfies a short-term goal of organizing the data and making it available through a web-based
interface.

Section 7 Lessons Learned

The MDMS process was part of a larger database development project undertaken by BWSR
to replace and upgrade an outdated application. In some ways, this combined approach was
beneficial and in others it was a detriment to MDMS development. Combining the MDMS with
a broader scale project was beneficial from a cost and staffing perspective because it took
advantage of a dedicated team of IT program staff. It also allowed the architecture of the MDMS
to be designed and integrated into the larger database as part of the build process as opposed to
being done separately and facing limitations from existing applications. The downside of this
approach were the competing priorities and schedules associated with other parts of the
application. For example, the most important part of the application was the wetland bank
accounting and transaction module. Because of its importance, this module was prioritized over
other functional areas and had more of an influence on schedule and resource decisions. This
ultimately led to work on the MDMS being deferred to make sure higher priority functionalities
were completed and implemented on schedule.

The MDMS was completed using a third-party vendor selected using a competitive
selection process. The request for proposal did not require respondents to have wetland
banking expertise as part of their team (it was identified as a preferred quality). In hindsight,
this stands out as our biggest mistake with the pilot. Bridging the knowledge gap between the
world of wetland mitigation and information technology is a significant challenge and one that
should not be overlooked. Requiring a third party vendor to have a member(s) of their team
familiar with wetland mitigation or wetland regulatory program work flows would save staff
time for the agencies involved in the project as well as reduce the number of iterations during
review that result from basic misunderstandings. Other relevant lessons learned from this
project are listed below.

•	Invest ample time in defining business requirements and work flows before starting the
project. Although there will always be items that require further definition during the
process, spending time up front to establish a workflow and system components will
reduce the time spent sorting out basic questions later.

•	Utilize user stories (narrative case studies) from subject matter experts to illustrate
processes for those unfamiliar with wetland mitigation.

An Integrated Framework: Pilot Applications » March 2022

41


-------
• Utilize staff from other agencies who have worked through similar processes and can
share their experiences. Minnesota is very active in developing applications to collect
and store natural resource data. The MDMS process benefitted from work done by other
agencies but many of these similar efforts were unknown at the beginning of the
process.

Section 8 Conclusions and Roadmap for the Future

The MDMS is the first step in a comprehensive reevaluation of tracking mitigation site
monitoring. The MDMS moves long-term monitoring of these sites in Minnesota from a
disorganized multi-media approach to a centralized digital storage and access portal.
Integrating vegetation and hydrology data with geospatial attributes from the mitigation sites
will improve the quality and usability of the data while improving accessibility for users
outside of BWSR. BWSR's near-term goal is to upload long-term monitoring data collected as
part of recent studies and establish a requirement for mitigation sites leaving the establishing
monitoring period to provide standardized vegetation and hydrology data that will serve as a
baseline for future monitoring as part of assessing site resiliency. Once long-term monitoring
data processes have been established and successfully implemented, efforts will be directed
toward integrating establishment reporting and data collection into the MDMS so that all
monitoring data for mitigation sites can be collected and stored in one location.

An Integrated Framework: Pilot Applications » March 2022

42


-------
APPENDIX B: OVERVIEW OF GEORGIA PILOT PROJECT

Section 1 Summary of state program assessing mitigation performance

1.1.	Key agencies and general structure

Georgia's compensatory mitigation program is administered by the U.S. Army Corps of
Engineers (ACOE) Savannah District under the auspices of the Clean Water Act Section 404
program, with minimal involvement by state agencies. The mitigation banking program in the
state is quite robust, since the Savannah District was an early adopter of the banking concept
and began permitting mitigation banks in the early 1990s. Today, the vast majority of
compensatory mitigation in Georgia occurs in mitigation banks. Monitoring of mitigation banks
occurs pursuant to the District's 2018 Standard Operating Procedure for Compensatory
Mitigation, associated guidance, and individual banking instruments. There is currently no
central database for cataloging monitoring data, and no long-term performance or resiliency
monitoring is required beyond that dictated by permit conditions.

1.2.	Authorities

Compensatory mitigation in Georgia is almost entirely conducted pursuant to the Clean
Water Act Section 404 program administered by the USACE Savannah District. State agencies
have a very limited role - the Georgia Environmental Protection Division (EPD) of the state's
Department of Natural Resources may impose conditions on or prevent issuance of 404 permits
under Clean Water Act Section 401, require compensatory mitigation as a condition of stream
buffer variances required under the state's Erosion and Sedimentation Act, or require
compensatory mitigation as a component of consent orders. Compared to what is required
under the 404 programs, however, the compensatory mitigation resulting from these authorities
is quite small.

The USACE Savannah District began its wetland mitigation program in the early 1990s, and
approved Georgia's first mitigation bank in 1992. In 2000, it became one of the first ACOE
districts in the country to include streams in its program. Today, the Savannah District, which
encompasses the entire state of Georgia, relies on mitigation banks for the vast majority of
compensatory mitigation required for 404 permits. The Savannah District allows both public
and private entities to own and operate 404 mitigation banks. Public entities owning banks
include the Georgia Department of Transportation and some local and county governments.
Private entities include mitigation banking firms, private landowners, timber companies, and
Georgia Power. The Savannah District also oversees the state's In-Lieu Fee (ILF) program,
which is sponsored by the Georgia-Alabama Land Trust (GALT). GALT collects fees from 404-
permittees when there are no available mitigation credits in the permitted project's service area;
when enough fees in that service area are collected, GALT requests proposals to develop a
mitigation project there.

An Integrated Framework: Pilot Applications » March 2022

43


-------
1.3, General goals and mandates

Mitigation bank development is currently guided by the USACE Savannah District's 2018
Standard Operating Procedure for Compensatory Mitigation (2018 SOP). Mitigation bank
performance monitoring is guided by the Savannah District's 2018 Draft Monitoring Guidelines
& Performance Standards for Freshwater Wetlands and Non-Tidal Streams (Monitoring
Guidelines). These guidelines are designed to support the District's Freshwater Wetland HGM
(Hydrogeomorphic) for Georgia and its Georgia Interim SQT (Stream Quantification Tool),
which are used to calculate permitted projects' mitigation debits and compensatory mitigation
project credits under the District's 2018 SOP, described below. The Monitoring Guidelines cover
the following areas:

•	General monitoring requirements

•	Evaluation of normal precipitation and growing season

•	Freshwater wetland monitoring

o Vegetation monitoring
o Prevalence index
o Wetland hydrology monitoring
o Large woody debris monitoring

•	Non-tidal stream monitoring

o Vegetation monitoring

o Vegetation monitoring in streamside vegetation zones
o Vegetation monitoring in riparian zones

o Stream channel geomorphology and stream hydrology monitoring
o Biological monitoring
o Stream water quality monitoring
o Large woody debris monitoring

•	Freshwater wetland mitigation performance standards

•	Non-tidal stream mitigation performance standards

An Integrated Framework: Pilot Applications » March 2022

44


-------
Monitoring reports are submitted annually; parameters are assessed according to the
following tables from the Monitoring Guidelines:

TABLE B1: Post-construction monitoring schedule for freshwater mitigation projects in
Georgia.

Wetland Monitoring
Parameter

Years

preceding interim credit release

As-Built

Continuous

Annual

Bi-annual

Vegetation

X



X



Hydrology



X





Prevalence Index

X



X



Wetland Monitoring
Parameter

Years following interim credit release

As-Built

Continuous

Annual

Bi-annual

Vegetation







X

Hydrology



X





Prevalence Index







X

Large Woody Debris







X

TABLE B2: Post-construction monitoring schedule for non-tidal stream mitigation
projects in Georgia

Stream Monitoring
Parameter

Years

preceding interim credit release

As-Built

Continuous

Annual

Bi-annual

Hydrology



X





Geomorphology









Channel cross-sections

X



X



Longitudinal profiles

X



X



Vegetation

X



X



Biology

(macroinvertebrates)





x<1>



Stream Monitoring
Parameter

Years following interim credit release

As-Built

Continuous

Annual

Bi-annual

Hydrology

n/a

X





Geomorphology

n/a







Channel cross-sections

n/a





X

Longitudinal profiles

n/a





X

Large woody debris

n/a





X

Vegetation

n/a





X

Biology

(macroinvertebrates)

n/a





X

Sponsor may initiate biological monitoring at any time following construction, so long as s/he
has at least two consecutive years of biological sampling that demonstrates attainment of interim
success criteria prior to seeking the interim mitigation credit release

An Integrated Framework: Pilot Applications » March 2022

45


-------
The Monitoring Guidelines outline the following general requirements for annual
monitoring reports:

•	An executive summary that describes the overall monitoring results, including
hydrologic monitoring, vegetation monitoring, large woody debris monitoring,
geomorphological monitoring, water quality, and macroinvertebrate monitoring (as
applicable), areas of concern (e.g., exotic/invasive vegetation, stream instability,
nuisance herbivory, etc.) and any adaptive management activities undertaken during
the previous year (e.g., supplemental planting, reconstruction or modification of
structural habitat features, etc.).

•	Results of any monitoring parameters required to demonstrate project specific
performance standards.

•	Performance standards, as provided in the Mitigation Work Plan or in the permit
conditions, must be restated verbatim in each monitoring report.

•	Each monitoring report should include a discussion/presentation of the current year's
monitoring data in context with data collected during all previous years. Summary
tables must include summary data from all previous years.

Section 2 Overview of mitigation components of the state program

Section 404 mitigation requirements in the Savannah District are guided by its SOP. In 2018,
the District issued a new SOP to replace the previous version, which had been in place since
2004. The goals of the 2018 SOP are to "1) provide stakeholders with a consistent, repeatable,
functionally-based mitigation credit assessment methodology for aquatic resources; and 2)
establish a transition to functionally-based credit types to facilitate in-kind replacement of
aquatic resources." It establishes what the District describes as a functional approach to
mitigation, which was not utilized in the 2004 SOP and is identified as the preferred type of
mitigation approach in the USACE and U.S. Environmental Protection Agency's 2008
Compensatory Mitigation Rule. The 2018 SOP uses Excel spreadsheet tools, the
Hydrogeomorphic Approach (HGM) for wetlands, and the Stream Quantification Tool (SQT), to
calculate credits awarded to wetland and stream mitigation projects in the state.

Section 3 Objectives of the case study - what are you trying to accomplish

The primary objectives of this project were to 1) bring together a working group of diverse
stakeholders involved in compensatory mitigation programs in Georgia; 2) assess current
practices and standards for mitigation data collection, reporting, and use; 3) construct a
prototype database that includes basic data analytics and a web interface to support existing
data in support of compensatory mitigation evaluation; and 4) provide a template for future
needs and develop a plan for scaling up the database statewide and broadening the analytical
and visualization tools based on shared objectives developed with stakeholders.

An Integrated Framework: Pilot Applications » March 2022

46


-------
Partners:

1.	Athens Land Trust

2.	Georgia Department of Natural Resources - Coastal Resources Division

3.	Georgia Department of Natural Resources - Wildlife Resources Division

4.	Georgia Department of Natural Resources - Environmental Protection Division

5.	U.S. Environmental Protection Agency

6.	Georgia Department of Transportation

7.	Georgia Environmental Restoration Association

8.	Georgia/ Alabama Land Trust

9.	Georgia Power

10.	Oconee River Land Trust

11.	The Nature Conservancy

12.	U.S. Army Corps of Engineers

13.	U.S. Fish and Wildlife Service

14.	University of Georgia
Section 4 Main challenges

This project encountered several key challenges. One key project objective was to upload
historical (pre-2018) data into the database to assess the effectiveness of the Georgia mitigation
program at achieving ecological goals and to identify trends over time. However, we decided
not to pursue this objective during this pilot project due to challenges posed by working with
historical mitigation data. In Georgia, data has primarily been submitted and archived in PDF
format. Thus, entering data into the database from historical records must be done manually in
a time-intensive process. We were further dissuaded from focusing on historical data due to
concerns raised by key stakeholders about the lack of standardization and quality of historical
data and changes in sampling protocols over time, which could limit analysis. These factors led
us to decide to use this pilot project as an opportunity to promote data standardization moving
forward, consistent with the USACE Savannah District's 2018 mitigation and monitoring
guidance, rather than spending significant effort to enter and standardize historical data with
little perceived benefit. Additionally, the relative lack of standardization of historical data
reporting and recent implementation of new guidelines (2018 Monitoring Guidelines) required

An Integrated Framework: Pilot Applications » March 2022

47


-------
our team to work with partners to iteratively develop standard data reporting protocols and
forms, rather than using pre-existing data forms for database development.

The development of the database also presented us with a series of challenges. We chose to
develop the database in-house using a combination of the RSQLite9 and R Shiny10 packages in
an effort to offer the greatest database flexibility, easy interfaces with multiple other platforms,
and ultimately the best user experience. However, this undertaking required training and a
period of working through a learning curve for project personnel to become proficient with
database development using this software. Additionally, since locations of sampling sites
within mitigation banks have historically been recorded in PDF reports, a high priority of
stakeholders was to develop a database tool to upload spatial data. Uploading the data is not a
significant issue by itself, but determining the ideal way to load and assure the quality of many
types of spatial data (per mitigation project) posed some significant challenges. While we
ultimately decided on a fairly straightforward approach for the pilot database, some additional
complexity and utility could be added with the input of users as this pilot is scaled up.

Determining the best strategies and schedule for effective communication with stakeholders
also proved to be a challenge, as meeting time had to be balanced with time spent on database
development. This challenge was heightened by the need to adapt our plans to navigate the
COVID-19 pandemic, which virtually eliminated our ability to conduct in-person meetings with
stakeholders and required us to negotiate the challenge of hosting online meetings with an
array of stakeholders, each with different agency mandates on permissible meeting platforms.
We decided to hold two general stakeholder meetings, where we solicited feedback on database
goals and progress, and conducted several follow-up meetings with key stakeholders. While the
general stakeholder meetings provided our team with valuable information in a time-efficient
format, it was a challenge to allow adequate time for discussion by a range of stakeholders with
varying levels of specialization on a range of topics. In an effort to maximize efficiency, we also
packed a substantial amount of information into each meeting, which may have resulted in
"information overload" and some of the key takeaways were not as well communicated as
desired. Additionally, the project would have benefitted from more frequent communication
with key stakeholders to solicit input on database features. While this was our intent, early
staffing challenges slowed initial progress on the database. Then, as database development
accelerated, our desire for progress overshadowed reconnecting with key stakeholders, thus
missing opportunities for iterative feedback. However, we ultimately were able to increase
opportunities for feedback from stakeholders late in the project and respond with substantial
changes and improvements. Moving forward, frequent feedback between the development
team and key stakeholders will be prioritized.

9	Kirill Miiller, Hadley Wickham, David A. James and Seth Falcon. 2020. RSQLite: 'SQLite' Interface for R.
R package version 2.2.1. https://CRAN.R-project.org/package=RSQLite

10	Winston Chang, Joe Cheng, JJ Allaire, Yihui Xie and Jonathan McPherson. 2020. Shiny: Web
Application Framework for R. R package version 1.5.0. https://CRAN.R-project.org/package=shiny

An Integrated Framework: Pilot Applications » March 2022	48


-------
Section 5 Approach and strategy used

5. v was it staffed? (internal, contractors)

The Georgia mitigation evaluation database project was developed internally and staffed
exclusively with University of Georgia personnel. Nathan Nibbelink, a professor in the Warnell
School of Forestry and Natural Resources at UGA, served as the principal investigator on the
project and was tasked with overseeing project administration and directly supervising and
assisting in database development, facilitating stakeholder meetings, and generating reports.
Katie Sheehan Hill, a research professional in the Odum School of Ecology's River Basin Center
and Carl Vinson Institute of Government at UGA, served as the co-PI on the project and
provided expertise on the mitigation banking system in Georgia and facilitated connections
with key stakeholders. Maxwell Kleinhans, a research professional in the River Basin Center,
provided expertise in developing the initial database framework. Cody Cox, a research
professional in the Warnell School of Forestry and Natural Resources, managed day-to-day
operations on the project, coordinated meetings with stakeholders, developed meeting agendas,
and produced meeting summary reports. He also took over database development after the
preliminary structure was created by Kleinhans and assisted in report writing.

5.2. Software used

The Georgia mitigation evaluation database was developed exclusively within the open
source statistics software, R11. We used the RSQLite package12 within R to construct a SQL
database to store data on a range of metrics related to mitigation evaluation. The SQL database
was then integrated into a user-friendly app developed using the R Shiny package13 in program
R, which permitted a visualization of bank sites within the state of Georgia, along with key
bank data, data entry forms (individual records and batch upload) for multiple types of data
(e.g., vegetation, hydrology, macroinvertebrates, large woody debris, and habitat assessment), a
data query and download tool, and a tool that interfaces with the ggplot214 package to plot data
for graphical analysis of data trends. This database app will be published online on a password-
protected website after final approval of the partners. Initially the site will be hosted by Dr.
Nibbelink's Spatial Analysis Lab at the University of Georgia until a permanent host is selected
by the partners.

11	R Core Team. 2020. R: A language and environment for statistical computing. R Foundation for
Statistical Computing, Vienna, Austria. URL https://www.R-project.org/.

12	Kirill Miiller, Hadley Wickham, David A. James and Seth Falcon. 2020. RSQLite: 'SQLite' Interface for
R. R package version 2.2.1. https://CRAN.R-project.org/package=RSQLite

13	Winston Chang, Joe Cheng, JJ Allaire, Yihui Xie and Jonathan McPherson. 2020. Shiny: Web
Application Framework for R. R package version 1.5.0. https://CRAN.R-project.org/package=shiny

14	H. Wickham. ggplot2: Elegant Graphics for Data Analysis. Springer-Verlag New York, 2016.
https://ggplot2.tidyverse.org

An Integrated Framework: Pilot Applications » March 2022

49


-------
5. cess (e.g., stakeholder coordination, key agencies coordinated with, guidance
docs used)

The Georgia mitigation evaluation database project began with a review of relevant
literature to provide a foundational understanding of the current state of mitigation banking
and evaluation in Georgia and identify goals for the future. The key piece of literature for
understanding mitigation data collection standards in Georgia is a document produced by the
Savannah District of the USACE in 2018 (Draft Monitoring Guidelines & Performance
Standards for Freshwater Wetlands and Non-Tidal Streams, 2018), which provided new
statewide requirements. The draft final version of the Integrated Framework for Evaluating
Wetland and Stream Compensatory Mitigation (Stein et al. 2018), co-produced by members of
the Southern California Coastal Water Research Project, Environmental Law Institute, and U.S.
Environmental Protection Agency, supplied us with valuable examples of the range of
mitigation evaluation practices occurring in various states and provided insights into goals for
national-level synthesis.

Concurrent with our literature review, we researched platforms for developing and hosting
our online database, and settled on using R Shiny for database development due to the
flexibility that it offered as a free, open source program that would permit in-house database
development and hosting. We then built a simple demonstration database as a vehicle for
stakeholder feedback. For this initial version, we used template data sheets provided in the
USACE 2018 guidance to guide construction of data input forms for both wetland and stream
mitigation projects.

In May 2020, we held our first stakeholder meeting, which was attended by key personnel
from 14 different organizations involved or interested in compensatory mitigation in Georgia.
During this meeting, we acquired stakeholder feedback on the current state of mitigation
evaluation in Georgia, including data collection and dataset availability, and discussed
stakeholder database goals and priorities. At this meeting, we also provided a brief
demonstration of an early version of our online database and solicited stakeholder feedback on
its design. We subsequently conducted follow-up meetings with two key stakeholders (USFWS
and Georgia Environmental Restoration Association) about data availability and potential
sentinel sites to use in the database. We then synthesized all feedback and developed a brief
summary report, which was sent out to all stakeholders.

Following these meetings, we entered a phase of intense database development in the fall of
2020. Based on our stakeholders' recommendations that historical data was not collected
consistently and would not be useful for analysis, we focused our database efforts on
developing standards for current and future data collection and entry and developing tools to
facilitate analysis in the future. We then held a second stakeholder meeting in January 2021 in
which we provided a more in-depth demonstration of our fleshed out database and solicited
stakeholder feedback to better tailor the design to their needs and goals. Subsequently, we
developed a meeting summary document, which we sent to all of our stakeholders. Following
the stakeholder meeting, we conducted a follow-up meeting with key stakeholders (USACE,

An Integrated Framework: Pilot Applications » March 2022

50


-------
EPA) to discuss specific recommendations for adding additional data entry forms, fields, and
tools to ensure that the database better aligned with their goals. We used the feedback provided
by stakeholders in our meetings to guide our process of expanding and revising our pilot
database during the winter/spring of 2021. We then held an additional meeting with key
stakeholders (USACE, EPA) in April 2021 to highlight expansions and revisions made to the
database during the previous months based on their feedback and solicit an additional round of
feedback, which we incorporated into the final version of our pilot database. We intend to post
the pilot database online to allow stakeholder beta testing during summer 2021.

Section 6 Outcomes

6. ducts produced

Through this project, we developed a range of products that will benefit compensatory
mitigation evaluation both in Georgia and nationally:

•	The primary product developed from our efforts on this project is an interactive
mitigation evaluation database for the state of Georgia. This interactive database will be
published as an R Shiny app online to facilitate use by the mitigation community in the
state. Key features of the database include:

o An interactive map of mitigation banks and sampling sites within the state,
which includes information (e.g., acres, date established) for each site and other
key spatial layers (e.g., watersheds and ecoregions).

o Data entry tools to facilitate the upload of multiple types of data (e.g., vegetation,
hydrology, macroinvertebrates, large woody debris, and habitat assessment
characteristics) into the database as either individual records or batch uploads.

o A tool allowing shapefiles of sampling sites within banks to be uploaded into the
database by users, since these have historically only been reported in PDF
reports, which will facilitate future analysis.

o A data viewer that permits data visualization, query by a range of fields, and
download.

o A pilot graphical analysis tool for data trend visualization.

•	We also developed metadata spreadsheets for each data entry form, which can be
downloaded from the corresponding database tab, and include information about each
data entry field, such as data type, data range, and lists of options for categorical fields.

•	We created downloadable Excel templates for each data entry form, which can be
downloaded by users from the appropriate database tab, to standardize data entry for a
range of mitigation evaluation criteria (e.g., vegetation, hydrology, macroinvertebrates,

An Integrated Framework: Pilot Applications » March 2022

51


-------
large woody debris, habitat assessment characteristics), to facilitate data entry and
future analysis.

•	Additionally, we developed a spreadsheet listing the availability of spatial data for each
bank site, which highlighted where spatial data is incomplete in current state databases,
such as missing bank boundary shapefiles or banks not listed in RIBITS.

•	Finally, we produced summary documents from the two stakeholder meetings that we
conducted, which synthesized valuable insights from 14 organizations that comprise a
large portion of the Georgia compensatory mitigation community on a range of topics,
including current data collection and use, current dataset availability, database goals,
and feedback on database progress.

mcities developed

This project greatly enhanced the capacity to collect, share, and analyze mitigation data in
Georgia through the development of standardized data entry forms, interactive maps, and data
query and download tools, which will enhance access to data for all stakeholders in the Georgia
mitigation community. Since we decided to develop the database in-house, this project
provided the opportunity for project personnel at UGA to expand our capacity for database
programming, management, and online application development using the R Shiny and
RSQLite packages in the open source software program, R. This adds to our past experience
with ArcGIS Online, VB for Applications, Python, and other tools to bring even more capacity
to our ability to build and host geospatially-enabled database tools to enhance environmental
management and decision-making.

6.3. Partnerships or leverage opportunities enhanced

This project helped UGA to develop important partnerships in the compensatory mitigation
community within Georgia and to better connect mitigation evaluation efforts in Georgia to best
practices being promoted or used in other states through review of the draft final version of
Stein et al. (2022) document and meetings with teams from other states. This project allowed us
to develop connections with a team undertaking a similar project in Minnesota and with
national-level partners at the Southern California Coastal Water Research Project and EPA to
better understand how Georgia fits in, and how we can contribute to (and learn from) national
advances in mitigation evaluation. Our two stakeholder meetings and additional individual
follow-up meetings helped us develop connections with 14 organizations involved with
compensatory mitigation in Georgia, who provided us valuable insight and feedback during the
course of our database development to allow our final product to best suit the needs of the
Georgia mitigation community.

An Integrated Framework: Pilot Applications » March 2022

52


-------
Section 7 Lessons learned

7.1.	What worked well/keys to success

While our model for soliciting stakeholder feedback could have been improved (see 7.2,
below), we believe that a key benefit of our in-house, user-driven approach avoids many of the
pitfalls often associated with outsourcing database development. Based on our observation of
other efforts, we were less prone to forcing elements into preconceived best practices from the
computational world (often useful for "big data" with millions/billions of records), and more
likely to make decisions that highlighted key needs of stream and wetland mitigation programs,
for which databases are relatively modest in size, and thus optimal efficiency can be traded off
for a better user experience. However, this decision required us to overcome a learning curve to
gain experience using some newer (to us) packages for database programming. Our decision to
use open-source software for database development will allow it to be more easily managed
and expanded in the future. Another element that was key for project success was creating
opportunities for stakeholder engagement and input during the database development process.
While the project could have benefitted from more frequent engagement with key stakeholders,
our meetings did provide us with a wealth of information and increased interactions late in the
project resulted in a cycle of iterative feedback that increased the alignment between the
database structure and stakeholder goals. Our two general stakeholder meetings also provided
our team with valuable information about current data collection and analysis in Georgia,
challenges in utilizing historical data for analysis, and preferences for database layout and
development priorities. This input shaped our prioritization of project components, such as
focusing more on setting standards for the present and future than loading historical data and
helping to ensure that the pilot database will meet user needs to the greatest extent possible.

7.2.	Challenges/things you would have done differently

While we made considerable progress during this pilot project, we experienced several
notable challenges that can serve as valuable learning opportunities for other states undertaking
similar database development, particularly where little historical regulation or oversight has
occurred. The biggest challenge we faced early in the project was in working with historical
data to meet broader project objectives of evaluating performance, effectiveness, and resiliency
of compensatory mitigation in Georgia. Due to stakeholder concerns about data consistency and
accuracy, we ultimately decided not to focus on including historical data to analyze trends in
mitigation in our pilot database and instead used the development of the database as an
opportunity to promote better standardization going forward. Including historical data in the
database was further complicated by the fact that most historical mitigation data were
submitted and archived in PDF format, which would require data to be manually entered into
the database; a time-consuming process in which stakeholders saw little benefit relative to our
other goals. The lingering lack of standardized data reporting in Georgia presented us with an
additional challenge because we had to develop data entry standards for several metrics and
new data entry forms as part of the database development, rather than using pre-existing forms
as templates. Additionally, since most sampling sites within mitigation banks have historically

An Integrated Framework: Pilot Applications » March 2022

53


-------
only been identified in PDF reports and have not been compiled into existing geospatial
databases, rather than creating a layer with locations of sampling sites in the database for user
analysis, we were tasked with developing a tool to allow users to upload site locations of
multiple feature classes (e.g., point, line, polygon) into the database, which required the
development of additional QAQC procedures to ensure proper formatting of fields and
coordinate systems. Our decision to develop the database in-house greatly increased our
flexibility and ability to iteratively modify the database based on stakeholder feedback.
However, these benefits did come with a learning curve, as previously mentioned. We do,
however, think that the choice of platform was a good one in looking to the future, and served
to add capacity for us to do more of this work.

We learned a few lessons that would lead us to make some different decisions in the
database development process if we had it to do over again. These lessons primarily related to
how we solicited stakeholder feedback in the database development process. We had
anticipated that our first stakeholder meeting would provide important information about
current data collection and analysis, available datasets for populating our database, and
stakeholder visions for the database itself, which would guide our database development. Thus,
we spent a relatively small portion of the meeting time actually performing a database
demonstration and soliciting feedback on design elements, and only presented a relatively bare
bones version of the database. While the meeting did provide valuable information on all topics
presented, we likely would have benefitted from presenting a more fleshed out version of the
database at this juncture and setting aside more time for direct feedback on its layout because
most of the feedback that we received at the first meeting was more conceptual, and we found
that a lot more ideas about the database structure and details emerged during our second
meeting, held several months later, when we spent most of the meeting time soliciting direct
feedback on design elements of a much more fleshed out version of the database. Had we
presented some of these elements earlier, it might have provided us with more concrete
database-specific feedback earlier in the process, which would have allowed more opportunities
for iterative feedback during the development process and would have saved us from spending
considerable time on elements deemed less important by the user community, such as matching
the exact formatting details of existing data collection forms, since not all users use the exact
same forms and would prefer to focus on batch upload of data. Additionally, "information
overload" in large stakeholder meetings may have reduced the utility of these meetings.
Originally, stakeholder meetings were designed as in-person, half-day workshops. Due to
scheduling issues and "zoom fatigue" during the COVID-19 pandemic, the meetings were
instead scheduled as shorter online sessions, which were not ideal.

Additionally, we would have benefitted from setting aside more time throughout the
database development process to meet with key stakeholders to workshop elements of the
database, including communicating more regularly about other project developments (e.g., key
takeaways from meetings with national/MN teams) and more effectively sharing timelines and
expectations. While more frequent meetings do require a diversion of time away from direct
database development, they would have increased development efficiency in the long run by
steering our efforts towards features of greater user priority, and thus avoiding sinking time

An Integrated Framework: Pilot Applications » March 2022

54


-------
into less important details. Due to early staffing challenges and learning curves, progress was
initially slow. Nonetheless, more frequent communication during this period, followed by
frequent opportunities for feedback as our progress accelerated would have been valuable. We
ultimately achieved a higher level of feedback and iterative improvements late in the project,
but would improve the model of engagement significantly if we could do it again.

7.3, Recommendations for others

Our primary recommendation is that communication with stakeholders is the biggest key to
successfully and efficiently developing a database that meets the needs and goals of a diverse
mitigation community. Creating opportunities to understand goals and priorities can inform
database development and providing further opportunities for feedback throughout the
development process can ensure that the database matches the needs of the community.

Section 8 Conclusions and roadmap for the future

Despite its robust number of mitigation banks, Georgia is still early in the process of
improving the consistency and effectiveness of mitigation evaluation. Our approach to building
a standardized, accessible database to better enable effective mitigation evaluation could be
used as a roadmap for other states at a similar stage in the process. The development of
standardized data entry forms and a queryable database through this effort will greatly
improve the capacity for future evaluation of mitigation outcomes in the state. While significant
progress was made on a functional database during the timeframe of this pilot project,
additional work is needed to beta-test, publish, and scale-up the database to maximize its utility
for mitigation evaluation in Georgia. We estimate that this process will take 2 years and require
a full-time database manager/programmer. During this time period, the database manager
would continue to build out and troubleshoot the database iteratively through user feedback,
while developing additional query and analysis tools to facilitate future mitigation evaluation
and assist with the upload of new (and high quality historical/sentinel site) mitigation data into
the database. Having a full full-time database manager will enable a soft implementation phase
that permits "on call" revisions and troubleshooting and culminates in dissemination to all
partners with the expectation that they commit to using the new system. If the University of
Georgia is selected to continue to develop the Georgia mitigation database, we could serve as
the database host during that time period, which would allow time for the stakeholder group to
determine (and secure funding) for a long-term host. Regardless of who is selected for the next
phase of this work, UGA is committed to hosting the pilot database and logging feedback from
partners for up to one year from project completion, and sharing all project components with
anyone who would pick up the work moving forward.

8.1 Recommendations for next steps

Below we describe our recommendations for two additional phases of this work. We also
propose a timeline and budget. However, budget projections are flexible, depending on the

An Integrated Framework: Pilot Applications » March 2022

55


-------
needs/ desires of project partners, and the numbers reflect estimates based on salaries and time
of personnel at the University of Georgia.

Phase V. Pilot database development - complete

Phase 2: Soft launch, beta testing, build-out, and implementation (2 years)

Soft launch - Key partners would be selected to be beta testers of the database. We
would propose a launch meeting with partners to highlight initial functionality and set
goals for the build-out, including any initial modifications and additional functionality.
After the launch meeting, partners would meet monthly to review progress and adjust
goals as needed. In between meetings, the database manager would work on agreed-
upon tasks and be on call for questions, edits, and suggestions as they arise. Phase 2
would also include working with USACE and other partners to lay the groundwork for
requiring use of the database as a part of formal reporting under mitigation evaluation
guidelines. Finally, during Phase 2, the database development team would work with
partners to select a permanent host and design a funding model for long term
maintenance and hosting of the database. By the end of Phase 2, the goal would be to
fully launch the database tool for use by all partners and transition to the permanent
hosting arrangement.

TABLE B3: Estimated Phase 2 budget for Georgia.

PERSONNEL

SALARY
(monthly)

TIME
(months)

SALARY

FRINGE
RATE

Yearl

Year 2

Total

Database manager

5,000

12

60,000

38.00%

82,800

84,870

167,670

Staff support (proj mngmt,
communications)

3,400

2

6,800

46.00%

5,667

2,607

8,273

PERSONNEL SUBTOTALS









88,467

87,477

175,943

















SUPPLIES















R-Shiny Apps Hosting
Service

99

12





1,188

1,188

2,376

















Sub-TOTAL UGA Direct
Costs









89,655

88,665

178,319

Indirect Costs (IDC) est @

35%









31,379

31,033

62,412

TOTAL









121,034

119,697

240,731

Phase 3: Long term hosting and maintenance

Long term maintenance could take several forms, depending on the needs of the
partners. We feel that this type of database will always require a minimum level of
maintenance and user support, considering the variety of data types, necessary
software/hosting updates, and evolving user needs. Based on communications with Eric

An Integrated Framework: Pilot Applications » March 2022

56


-------
Stein's team, we are estimating high at about 20% of a data manager's time, plus some
minor additional staff support and web app hosting services. These estimates could be
revisited and revised as appropriate during Phase 2 as the project team considers
funding models and needs for long term support.

TABLE B4: Estimated Phase 3 budget for Georgia

PERSONNEL

SALARY
(monthly)

TIME
(months)

SALARY

FRINGE
RATE

Yearl

Year
2

Total

Database manager

5,000

2.5

12,500

38.00%

17,250

17,681

34,931

Staff support (proj mngmt,
communications)

3,400

0.5

1,700

46.00%

1,417

652

2,068

PERSONNEL SUBTOTALS









18,667

18,333

37,000

















SUPPLIES















R-Shiny Apps Hosting
Service

99

12





1,188

1,188

2,376

















Sub-TOTAL UGA Direct
Costs









19,855

19,521

39,376

Indirect Costs (IDC) est @

35%









6,949

6,832

13,781

TOTAL









26,804

26,353

53,157

An Integrated Framework: Pilot Applications » March 2022

57


-------