Margaret A. Palmer Departments of Biology and Entomology, University of Maryland 410 326-7241 palmer@cbl.umces.edu Emily Bernhardt Duke University emily.bernhardt@duke.edu J. David Allan University of Michigan, Ann Arbor Professor School of Natural Resources &Environment University of Michigan 734.764.6553 734.936.2195 dallan@umich.edu National Center for Ecological Analysis and Synthesis NCEAS 4700: Palmer: StreamRestoration The NRRSS (National River Restoration Science Systhensis) Summary Database is a representative database of stream restoration projects throughout the country, with focus on seven geographic regions--California, Chesapeake Bay, Central US, Pacific Northwest, Southeast, Southwest, and Upper Midwest. These data were collected from a variety of electronic, paper, and human sources from 2002 to 2004. Information from this database has been summarized in Bernhardt et al 2005 (link) as well as published and forthcoming regional summaries. As of December 15, 2005, the information in this database is now freely searchable, downloadable, and usable by members of the public. Rivers/Stream Habitat Restoration River restoration Stream Riparian Wetlands This database is avilable online at Restoring Rivers.org http://www.restoringrivers.org/index.html where there is more information regarding the NRRSS database. The PDF file Science Supporting Online Material is part ot Synthesizing U.S. River Restoration Efforts at Science 29 April 2005: Vol. 308. no. 5722, pp. 636 - 637 DOI: 10.1126/science.1109769 (http://www.sciencemag.org/cgi/content/full/308/5722/636/DC1) The information in this database is now freely searchable, downloadable, and usable by members of the public. http://www.restoringrivers.org/index.html The focus is on seven geographic regions--California, Chesapeake Bay, Central US, Pacific Northwest, Southeast, Southwest, and Upper Midwest -126.0 -72.875 51.125 24.25 2002-01-01 2004-07-22 1143066233931 1143065948759

We began by compiling data on restoration projects from 18 national coverage databases maintained by federal agencies (b), but found that the majority of projects are recorded only at the regional or local level. A large number of municipal, state and regional databases are being developed, but we found few extensive databases (b) of river restoration [average no. of project records per data source was 51 ± 26 (95%CI)] (this does not include personal contacts which on average yielded information on six projects). Our working group, with the extensive collaboration of data providers, restoration scientists, managers and practitioners within each of our nodes, has designed and implemented a database to begin addressing this need. The NRRSS metadata and database structure provides a common format to reduce duplication of effort in planned project tracking efforts and is freely available to all interested parties. The NRRSS Summary Database is a mySQL relational database developed on a LINUX platform (g). Only open source software was used for the database. The database schema, structure and metadata are available on line (at http://nrrss.nbii.gov) and the raw summary data is avaialble online

Metadata were developed for all database fields to ensure consistency, repeatability, and utility of the data. Calibration of data entry for the database was done initially by the entire working group. All members received the same ten example project files which they entered into the database following the metadata. After this round, the group met to discuss differences in the entries and to modify the metadata to eliminate confusion. All persons responsible for data entry completed three additional rounds of calibration with 10 different projects in each round in which the only field completed was the categorization of stated project goals, objectives, or purposes into the intent categories, the only subjective field in this database.

This is a PDF document that descibes the Methodology for the NRRSS Database. Science Supporting Online Material Bernhardt et al Contents (a) Notes on NRRSS Methodology (b) List of National Coverage Databases (c) Metadata for Classification of Project Goals/Intents (d) Fig. S1. The number of river restoration projects recorded in NRRSS and citations related to stream restoration. (e) Cost Estimates (f) Note on Large Restoration Project Cost (g) Full Description of NRRSS Database Software (h) Table S1. Regional differences in stream restoration efforts.

public read uid=nceasadmin,o=NCEAS,dc=ecoinformatics,dc=org all Science Supporting Online Material Synthesizing U.S. River Restoration Efforts Manual for the NRRSS NRRSSMethodology.pdf Acrobat PDF file ecogrid://knb/bowdish.142.1 PDF Manual for NRRSS Database Science Supporting Online Material Synthesizing U.S. River Restoration Efforts Name of PDF File NRRSS Database MS Access 2000 National River Restoration Science Sythesis Database in MS Access 2000 format. This Database does not include any forms, queries or reports. It was downloaded 03/27/06 as a back up to the online database site at http://www.nbii.gov/ or for use for those who want to do their own queries. Directions to download the most recent version of the Access files can currently be found at the online site. nrrss.mdb MSAccess 2000 mdb file ecogrid://knb/bowdish.144.1 NRRSS Database in MS Access 2000 National River Restoration Science Synthesis (NRRSS) this is a file to download