1 / 34

RESSED THE NATIONAL RESERVOIR SEDIMENTATION DATABASE

RESSED THE NATIONAL RESERVOIR SEDIMENTATION DATABASE. Annual Tri-Agency Coordination Meeting Memphis, TN November 17, 2009. Mark E. Smith , mesmith@usgs.gov USGS Central Region Science Office, Denver, CO On behalf of John R. Gray, jrgray@usgs.gov

ernie
Download Presentation

RESSED THE NATIONAL RESERVOIR SEDIMENTATION DATABASE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RESSED THE NATIONAL RESERVOIR SEDIMENTATION DATABASE Annual Tri-Agency Coordination Meeting Memphis, TN November 17, 2009 Mark E. Smith, mesmith@usgs.gov USGS Central Region Science Office, Denver, CO On behalf of John R. Gray, jrgray@usgs.gov USGS Office of Surface Water, Reston, VA

  2. RESSED FEDERAL INTERAGENCY SUBCOMMITTEE ON SEDIMENTATION John R. Gray, jrgray@usgs.gov USGS Office of Surface Water, Reston, VA with Jerry M. Bernard, NRCS; David W. Stewart, Gregory E. Schwarz, and Karen T. Ray, USGS http://ida.water.usgs.gov/ressed/

  3. RESSED – Subcommittee on Sedimentation Presentation Overview • RESSED – Unfunded Work in Progress • RESSED History (yes, it is relevant) • Description of RESSED Database and Website* • RESSED issues/problems • Future – RESSED-II? • *But not much in way of findings!

  4. RESSED – Subcommittee on Sedimentation But First – a Word from Our Sponsor: ACWI’s Subcommittee on Sedimentation • SOS – top national level committee for coordinating • national or organization-specific sedimentation issues • Formed ~1939, now under the Advisory Committee on • Water Information (ACWI; http://acwi.gov/) • Since ~2004, Gov’t and non-Gov’t • Members: ARS, ASCE, CUAHSI, BLM, CWRRI (CSU), • FHWA, FS, NCED, NOAA, NPS, NRCS, OSM, USBR, • UCOWR, USACE, USEPA, USGS (RESSED workgroup)

  5. RESSED – Subcommittee on Sedimentation What Is RESSED? • MS-ACCESS database and website containing sequentially measured reservoir capacities. • Changes in capacities are computed from these • data (+/- acre feet/year) • 1,824 reservoirs, 6,618 surveys: lower US (1in PR) • Based on Soil Conservation Service Form 34 (1953) • Presumed to be largest such database for US (?)

  6. RESSED – Subcommittee on Sedimentation What Is RESSED? (cont) • Clickable reservoir location info via interface • Not yet any on-line analytical capability; • Access database downloadable in entirety • Website seeks metadata on additional surveys • and/or additional reservoirs, but not updatable • Culmination of ~1.5 decades quest…! • “It’s the best we have” – Jerry Bernard, 2009 • “But a long way to go” – Gray et al., 9/16/2009

  7. RESSED – Subcommittee on Sedimentation Some History • SCS Form 34 developed in 1953 • Results published in at least 3 summary reports: • through 1953; through 1975; 1981-1985 • 1980’s: SCS attempts to develop RESIS database • (Dennis Erinakes’ oversight) • 1993: An unmarked magnetic tape is found in a • box by NRCS – presumably Erinakes’ results

  8. RESSED – Subcommittee on Sedimentation Some History (cont) • 1994: Jay Atwood, NRCS, places these data in Prelude and • Informix database formats – RESIS • 1997: Jerry Bernard: “Someone Please Give RESSED a Home!” • ~1997: Bob Stallard and David Mixon, USGS, as part of research on • global carbon budget, convert Atwood’s product to Microsoft • Access format as RESIS-II • ~2004: Eric Sundquist and Kate Ackerman, USGS, obtain Stallard • Access database and provide make improvements, also as RESIS-II • 2008-09: Subcommittee on Sedimentation (SoS) updated ~1,500 reservoir coordinates in RESIS-II, adds a reservoir as a test case, places online as RESSED

  9. RESSED – Subcommittee on Sedimentation And The Point Is??? • RESSED was not – ever – populated directly from SCS Form 34 • SCS Form 34 has 47 entries (2-page); RESSED has ~325 fields • SOS has identified the origin of values in most but not all ~325 fields • Reverse engineering required to identify all RESSED fields • We’re finding inconsistencies in this regard • Comment fields are important but currently not electronically useful • Other “warts” described later…but take it on faith… • RESSED is a Work…In…Progress.

  10. RESSED – Subcommittee on Sedimentation

  11. RESSED Subcommittee on Sedimentation SCS Form 34Lake MeadeP. 1

  12. RESSED Subcommittee on Sedimentation SCS Form 34Lake MeadeP. 2

  13. RESSED Subcommittee on Sedimentation SCS Form 34Lake MeadeP. 3

  14. RESSED – Subcommittee on Sedimentation

  15. RESSED – Subcommittee on Sedimentation SELECTED RESSED DATABASE CHARACTERISTICS

  16. 1,824 RESSED Reservoir Locations (2009) Puerto Rico – 1 reservoir (information 9/9/2009 D.W. Stewart)

  17. RESSED Reservoir Surveys by Year 95% of surveys: 1930-1990

  18. RESSED Reservoir Capacities by Acre-Feet Classes (320) (331) (273) ~Half <10,000 Acre Feet (205) Number of Reservoirs (121) (86) (24) 1k – 10k 10 -100 .05 - 10 10k – 100k 1,000k – 1 mill 100k – 1,000k 1 mill – 29.8 mill Acre-feet

  19. RESSED Reservoir Capacities 1,360/1,824 reservoirs

  20. Number of Reservoir Surveys in RESSED* * Caveat – probably not all surveys!

  21. RESSED Years Between First & Last Surveys ~78%: first-to-last surveys: 5-30 years (1,128/1,442 reservoirs)

  22. RESSED Annualized % Capacity Loss ~82%: <2% capacity loss/year (1,124/1,365 reservoirs)

  23. RESSED Total % Capacity Loss ~32% have lost 10-30% capacity (432/1,365 reservoirs)

  24. RESSED – Subcommittee on Sedimentation Other RESSED Issues • Have yet to develop a data-entry form for SCS Form 34 (in progress*) • SCS Form 34 is but one of many data formats that now exist • - Bureau of Reclamation e-Form 34 • - Corps 2008 Reservoirs Data Call format • - On-line reservoir information from Maryland, elsewhere • GPS, depth sounders, other instrumentation provide a wealth of new • types of information, much of which needs to be stored • Quality assurance protocols have special data-storage requirements • Current RESSED isn’t amenable to the long haul *FilemakerPro Front End

  25. RESSED – Subcommittee on Sedimentation Other RESSED Issues (cont) • Let’s do a little math: • -1,824 reservoirs in RESSED • - ~81,000 dams (ergo reservoirs?) in the National Inventory of Dams (COE) • - ~?6 million – 9 million impoundments in the U.S. (USGS • National Hydrography Dataset; Renwick, Miami of Ohio) • Hence, the number of reservoirs in RESSED are: • - ~2% of number of dams in the NID (but not all cross-listed) • - ~0.03% of U.S. impoundments • RESSED reservoirs are much less than the “tip of the iceberg!”

  26. RESSED – Subcommittee on Sedimentation Other RESSED Issues (cont) American Society of Civil Engineers USA Infrastructure Report Card, February 2009 * But presumably nationally reliable statistics on other categories

  27. RESSED – Subcommittee on Sedimentation So…. • THE NATION NEEDS A CAREFULLY DESIGNED AND FULLY POPULATED NATIONAL “RESSED-FUTURE” • UNRESTRICTED ACCESS/USE • LINKED TO OTHER KEY DATABASES (NID, ETC) • UPDATABLE • CAPABLE OF STORING ALL RELEVANT DATA • ANALYZABLE LOCAL, REGIONAL, NATIONAL SCALES • BUILD IT AND THEY WILL COME

  28. RESSED – Subcommittee on Sedimentation RESSED-FUTURE • Subcommittee on Sedimentation Organized Program with wide • participation in public and private sector • Three Workgroups under SOS RESSED Committee, form in 2009 • - Data types and uses workgroup • - Data architecture workgroup • - Data-collection protocols workgroup • Must develop a base-funded, long-term project • How long can the Nation afford NOT to know the status and trends in the capacities of it’s reservoirs?!

  29. RESSED – Subcommittee on Sedimentation Take Home Message • RESSED on-line, useful tool – best we’ve got? • Work in Progress • Short Term: Need update capability, report production, other information • Long Term: 1. Need base-funded project 2. Need data types & requirements statement 3. Need new database architecture • Interested in helping….?

  30. Provide insights/suggestions/offers to help Join a Subcommittee on Sediment workgroup For that matter, join the SOS! Locate and forward data jrgray@usgs.gov jerry.bernard@wdc.usda.gov Scratch Our Back – We Scratch Yours RESSED – Subcommittee on Sedimentation

  31. Not The End…The Beginning! http://ida.water.usgs.gov/ressed/

More Related