• 460 likes • 600 Views
National Water Information System -- Web Interface Operation and Quality Assurance. Water Information Management Systems Workshop Missoula, MT Sept 7, 2005 Dave Briar. Topics:. Architecture reflects history and USGS culture – local control Hardening the system for 24 x 365
E N D
National Water Information System -- Web Interface Operation and Quality Assurance Water Information Management Systems WorkshopMissoula, MT Sept 7, 2005Dave Briar
Topics: • Architecture reflects history and USGS culture – local control • Hardening the system for 24 x 365 • Quality-assurance tools – existing and needed
Secure Repository Public “View” 48 NWIS hosts http://waterdata.usgs.gov/
Secure Repository Public “View” 48 NWIS hosts http://waterdata.usgs.gov/ NationalAggregateDataset Total sitesReal-time sitesDaily valuesGround-water levelsQW samplesQW valuesPeaks 1,615,003 9,785225,606,560 7,820,464 4,376,679 69,736,624 662,227
-- NWIS database installation -- NatWeb Node with Firewall
NWIS – NatWeb Delivery NatWeb SD Sioux Falls NatWeb CA Menlo Park Three redundant copies of all real-time data for all sites nationwide NatWeb VA Reston NAD Single copy of all data (real-time and discrete / historical) for all sites nationwide
LRGS WSCDatabase
NWIS – NatWeb Data Transfer LRGS WSC Database NatWeb SD NatWeb VA NatWeb CA HUB1 NAD
NWIS – NatWeb Data Transfer NatWeb SD RT data NatWeb VA RT data RT data NatWeb CA HUB1 NAD All data
NWIS – NatWeb Data Transfer LRGS NatWeb SD HUB2 NatWebVA NatWeb CA HUB1 NAD
NWIS – NatWeb Data Transfer NatWeb SD RT data HUB2 RT data RT data NatWebVA NatWeb CA All data NAD
NWIS – NatWeb Data Transfer NatWeb SD RT data HUB2 RT data RT data NatWeb VA NatWeb CA All data NAD
NWIS – NatWeb Concurrency waterdata.usgs.gov/zz/nwis/rt waterdata.usgs.gov/zz/nwis/rt NAD
NWIS – NatWeb Concurrency waterdata.usgs.gov/zz/nwis/rt NAD
NWIS – NatWeb Concurrency waterdata.usgs.gov/zz/nwis/rt 01646500 POTOMAC RIVER NR WASH, DC LITTLE FALLS Latency = 11 sec naddb01 [2004-06-07 10:15:00 4.82] 2004-06-07 11:36:43 cadb02 [2004-06-07 10:15:00 4.82] 2004-06-07 11:36:36 sdww02 [2004-06-07 10:15:00 4.82] 2004-06-07 11:36:42 vadb02 [2004-06-07 10:15:00 4.82] 2004-06-07 11:36:32 NAD
WSC Database to Web Latency District Database NatWeb SD NatWeb VA NatWeb CA HUB1 NAD
WSC Database to Web Latency Seconds Percent of Sites
NWIS – NatWeb Efficiency May 2005 • 12.5 GB Data transferred from the 48 NWIS Databases to the National system-- includes 4.35 million real-time site updates
NWIS – NatWeb Efficiency May 2005 • 12.5 GB Data transferred from the 48 NWIS Databases to the National system-- includes 4.35 million real-time site updates • 273.9 GB Data delivered to primarily external users by the 4 NatWeb nodes-- 22.9 million requests
WSC Database is single point of failure WSCDatabase NatWeb SD NatWeb VA NatWeb CA HUB1 NAD
LRGS WSCDatabase
NWIS – NWIS-RT Backup Replication WSC Database NatWeb VA HUB1 NWIS-RT in “Hot Standby” NAD
NWIS – NWIS-RT Backup NatWeb VA HUB1 NWIS-RT Serving WSC Data NAD
Quality Assurance: • Automated • Filters applied during processing • Erroneous values masked from public display and questionable values flagged
Threshold Filters Very High Value ( Impossible Value -- Masked ) High Value ( Warning ) ( Warning ) Low Value Very Low Value ( Impossible Value -- Masked )
Threshold Filters Very Rapid Increase Rapid Increase Very Rapid Decrease Rapid Decrease
Quality Assurance: • Automated • Filters applied during processing • Erroneous values masked from public display and questionable values flagged • Daily “QA report” from National system
Quality Assurance: • Automated • Filters applied during processing • Erroneous values masked from public display and questionable values flagged • Daily “QA report” from National system • Periodic visual inspection • Lists of selected sites • Internal-only reference levels provide context for QA process
Display of “Looked-At” Flag USGS 12345678 Hirsch Creek near Spikeville, VA GAGE HEIGHT – RAW UNREVIEWED GAGE HEIGHT –REVIEWED
Questions? http://waterdata.usgs.gov/ dbriar@usgs.gov