Stream Monitoring Database

2014 Fiscal Year Funding Amount:
$50,000
2013 Fiscal Year Funding Amount:
$40,000
2012 Fiscal Year Funding Amount:
$40,000
Source: 
Clean Water Fund
Status: 
In Progress
Start Date: 
July 2011
Activity Type: 
Digitization/Online Information Access
Counties Affected: 
Statewide
Project Details:
2014 Fiscal Year
Legal Citation / Subdivision: 
M.L. 2013, Chp. 137, Art. 2, Sec. 6(g)
Appropriation Language 
$675,000 the first year and $675,000 the second year are for applied research and tools, including watershed hydrologic modeling; maintaining and updating spatial data for watershed boundaries, streams, and water bodies and integrating high-resolution digital elevation data; assessing effectiveness of forestry best management practices for water quality; and developing an ecological monitoring database.
Fiscal Year Funding Amount: 
$50,000
Number of full time equivalents funded: 
0.0
Proposed Measurable Outcome(s) 
In FY14, DNR will work with partners to create the physical biomonitoring database tables and prototype user interface application screens for entering data using the business object model created in FY13, and they will develop a prototype ready for testing by spring of 2014 that allows for entry of all components of the MN DNR Stream Survey Manual.
Project Details:
2013 Fiscal Year
Legal Citation / Subdivision: 
M.L. 2011, First Special Session, Chp. 6, Art. 2, Sec. 6(g)
Appropriation Language 
$1,725,000 the first year and $1,725,000 the second year are for shoreland stewardship, TMDL implementation coordination, providing technical assistance to the Drainage Work Group and Drainage Management Team, and maintaining and updating data. Of this amount, $235,000 each year is for maintaining and updating watershed boundaries and integrating high-resolution digital elevation data with watershed modeling and $40,000 each year is for a biomonitoring database. TMDL implementation coordination efforts shall be focused on major watersheds with TMDL implementation plans, including forested watersheds.
Fiscal Year Funding Amount: 
$40,000
Direct expenses: 
$44,760
Administration costs: 
$3,880
Number of full time equivalents funded: 
0.0
Proposed Measurable Outcome(s) 
In FY13, DNR will work with multiple PCA and DNR programs to develop a pilot version of a stream monitoring database. Development will include a prototype interface program for users to enter data.
Measurable Outcome(s) 
In FY13, DNR worked with multiple PCA and DNR program staff on developing a common stream biomonitoring database. A model outlining the structure of the database was completed during FY13, laying the groundwork for database construction in FY14. Development of the physical database tables and user interface application was delayed during 2013 by a thorough business analysis modeling of PCA database tables, and by PCA staff and MN IT @ DNR staff time limitations due to other project priorities.
Project Details:
2012 Fiscal Year
Legal Citation / Subdivision: 
M.L. 2011, First Special Session, Chp. 6, Art. 2, Sec. 6(g)
Appropriation Language 
$1,725,000 the first year and $1,725,000 the second year are for shoreland stewardship, TMDL implementation coordination, providing technical assistance to the Drainage Work Group and Drainage Management Team, and maintaining and updating data. Of this amount, $235,000 each year is for maintaining and updating watershed boundaries and integrating high-resolution digital elevation data with watershed modeling and $40,000 each year is for a biomonitoring database. TMDL implementation coordination efforts shall be focused on major watersheds with TMDL implementation plans, including forested watersheds.
Fiscal Year Funding Amount: 
$40,000
Direct expenses: 
$40,000
Administration costs: 
$0
Number of full time equivalents funded: 
0.0
Proposed Measurable Outcome(s) 
In FY11, DNR will lead a multi-agency effort to develop a data management structure for storing and sharing stream and river data.
Measurable Outcome(s) 
In FY12, DNR hired a consultant to assist in creating a framework for a stream monitoring database. A key part of the process was identifying programs within DNR and MPCA that collect similar types of data, which will become candidates for inclusion in the database. Working with DNR staff, the consultant developed a draft structure for a stream monitoring database.

Project Overview

This project will develop a multi-agency stream monitoring database to support storage and sharing of assessment and monitoring data to facilitate data sharing among multiple programs, increase efficiency, and allow for easier public access to data. Because each program often has different reasons or methods for collecting and storing monitoring data, the database must account for each program’s needs while maintaining a common structure where data can be shared. When complete, the database will allow for better access to available data on streams that will better inform watershed management decisions by DNR, MPCA, and external partners.

About the Issue

State agencies collect stream monitoring data for a variety of different purposes in carrying out their mission. However, monitoring data held by each program that could be used by others to better manage streams is located in multiple places, making it difficult to know what data is available and how to access it. A common monitoring database serving multiple programs will help ensure the most efficient and effective use of the data collected by making that information readily available across agencies and other organizations.

Project Manager

Brian
Nerbonne
Minnesota Department of Natural Resrouces
500 Lafayette Road
Saint Paul
55155
651-259-5205