National River Restoration Science Synthesis
R
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
R starting shiny Jul 28, 2015
README.md
nrrss.sqlite

README.md

National River Restoration Science Synthesis

In 2004, the National River Restoration Scientific Synthesis (NRRSS) database was compiled by a team of ~ 20 scientists. This was the first-ever comprehensive database on stream and river restoration projects. It includes basic information on more than 37,000 projects across the U.S. It resulted in many publications with the broad national-level results published in Science. Lead scientists for the project were: M.A. Palmer (Univ of Maryland), J.D. Allan (Univ Michigan), and E.S. Bernhardt (postdoc at Univ of Maryland; now faculty at Duke University). The project included a collaboration with American Rivers and benefitted from funding from the National Center for Ecological Analysis and Synthesis, the Packard Foundation, the C.S. Mott Foundation; cyber support was provided by the U.S. Geological Survey.

Publications resulting from the NRRSS database

NRRSS national synthesis (entire U.S.) papers:

2005

  • Bernhardt, Emily S.; Palmer, Margaret A.; Allan, J. David; Alexander, Gretchen; Barnas, Katie; Brooks, Shane; Carr, Jamie; Clayton, Steve; Dahm, Clifford; Follstad-Shah, Jennifer; Galat, David L.; Gloss, Steven P.; Goodwin, Peter; Hart, David; Hassett, Brooke; Jenkinson, Robin; Katz, Stephen L.; Kondolf, G. Mathias; Lake, P. Sam; Lave, Rebecca; Meyer, Judy; O'Donnell, T. Kevin; Pagano, Laura; Powell, Bruce; Sudduth, Elizabeth. 2005. Synthesizing US river restoration efforts. Science. Vol: 308(5722). Pages 636-637.

  • Palmer, Margaret A.; Bernhardt, Emily S.; Allan, J. David; Lake, P. Sam; Alexander, Gretchen; Brooks, Shane; Carr, Jamie; Clayton, Steve; Dahm, Clifford; Follstad-Shah, Jennifer; Galat, David L.; Loss, S. G.; Goodwin, Peter; Hart, David; Hassett, Brooke; Jenkinson, Robin; Kondolf, G. Mathias; Lave, Rebecca; Meyer, Judy; O'Donnell, T. Kevin; Pagano, Laura; Sudduth, Elizabeth. 2005. Standards for ecologically successful river restoration. Journal of Applied Ecology. Vol: 42. Pages 208-217.

2006

  • Palmer, Margaret A. and J. David Allan. 2006. Restoring Rivers. 2006. Policy Recommendations to Enhance Effectiveness of River Restoration published in U. S. National Academy of Science: Issues in Science and Technology, 22: 40 - 48.

2007

Regional Synthesis Papers

2005

2006

2007

How to access the database

Browse this database (nrrss.sqlite) with sqlite db browser: http://sqlitebrowser.org/ or with the firefox browser plug-in: https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

R Users

The RSQLite package provides an easy interface to working with .sqlite files in R.

install.packages("RSQLite")
library(RSQLite)

drv <- dbDriver("SQLite")
db <- "filepath/nrrss.sqlite" # specify directory where file is
con <- dbConnect(drv, db)