WQX and NHD+V2

1. WQX and NHD+V2 ABE 527 January 2013 • Larry Theller

2. WQX • What is WQX • How is it used • Original concept for data upload • Current “state of the art” data loader • Process flow • Data loader upgrades created for this project • Future Tool (2 year NEIEN project) OISCWQX

3. NHD+ V2 • What is NHD+ V2 • How is it used • Original concept for data upload • Current “state of the art” data loader • Process flow • Data loader upgrades created for this project OISC WQX

4. WQX as Framework • The Water Quality Exchange (WQX) is a framework that makes it easier for States, Tribes, and others to submit and share water quality monitoring data over the Internet. • States, Tribes and other organizations can now submit data directly to the publicly-accessible STORET Data Warehouse using the WQX framework. • WQX will eventually replace the distributed STORET, the STORET Data Entry Module, Reports Module, and STORET Import Module or SIM as the primary means of submitting water quality monitoring data to EPA. OISC WQX

5. OISC WQX WQX_Web_User_Guide_v2.0.pdf

6. CDX NODE WEB STORET OISC WQX http://www.epa.gov/storet/wqx/products/WQX_factsheet.pdf

7. OISC WQX

8. Spreadsheet of results Staging Excel Authenticated upload to staging database 1 OISC CDX QC done and Reformat to XML Current WQX Web Design Authenticated XML upload to CDX 2 6

9. Project Name Monitoring Locations 2011 Activity - Results 2010Activity - Results 2009 Activity - Results http://www.epa.gov/storet/wqx/products/WQX_factsheet.pdf

10. Sample XML for monitoring location upload.

12. The National Hydrography Dataset (NHD) is the surface water component of The National Map. • Contains features such as lakes, ponds, streams, rivers, canals, dams and streamgages. • GIS technologies take advantage of a rich set of attributes imbedded in the NHD to generate specialized information. • These analyses are possible because the NHD contains a flow network that allows for tracing water downstream or upstream. • It also uses an addressing system based on reach codes and linear referencing to link specific information about the water such as water discharge rates, water quality, and fish population. • Using basic NHD features like flow network, linked information, and other characteristics.

13. Hydrography Event Management Tool The Hydrography Event Management (HEM) Tool provides full functionality for adding and editing events in the NHD. Events are informational data that are linked to the NHD using a linear referencing system on NHDFlowlines. The use of events is a key characteristic of the NHD by allowing vast amounts of scientific information to be linked to the NHD while keeping the design simple and by making advanced analysis techniques possible. The HEM tool handles all the linear referencing mechanics to make working with events easy. A Source Feature ID is created that provides the link between the event location and the informational data tied to the location. It also creates metadata linked to the event. The tool also provides network measuring to determine distances through the flowline network. Developer: Department of the Interior - Bureau of Land Management

14. NHD+ V2 • Greatly improved 1:100K National Hydrography Dataset (NHD) • Greatly improved 30 meter National Elevation Dataset (NED) • Nationally complete Watershed Boundary Dataset (WBD) • A set of value added attributes to enhance stream network navigation, analysis and display • An elevation-based catchment for each flowline in the stream network • Catchment characteristics and cumulative drainage area characteristics • Flow direction, flow accumulation and elevation grids • Flowline min/max elevations and slopes • Flow volume & velocity estimates for each flowline in the stream network • Catchment attributes and network accumulated attributes • Various grids from the hydro-enforcement process including the hydro-enforced DEM.

15. OISC WQX

21. Select Dams, by point or by Reach CODE and you can select downstream water features. OISC WQX

26. WATERS Status Update www.epa.gov/waters

27. Available WATERS Data • National Hydrography Dataset (NHD) • NHDPlus Catchments • Watershed Boundary Dataset (WBD) • Water Program Features indexed to the NHD: • Assessed Waters • Impaired Waters • Beaches • Combined Sewer Overflows • Clean Watersheds Needs Survey • Fish Consumption Advisories • Clean Water State Revolving Fund Projects • No Discharge Zones • Permitted Dischargers • Total Maximum Daily Loads • Water Quality Standards Additional Information: http://www.epa.gov/waters/data/prog.html http://www.epa.gov/waters/doc/auxiliary/index.html

28. WATERS Data Web Pages • Contains detailed information about the Reach Address Database, NHD, NHDPlus, and other supplemental tables.

29. WATERS Data Web Pages • Web page contains hyperlinks to Auxiliary Dataset information. • Watershed Boundary Dataset • Tiger 2008 (subset) • NHDPlus Smoothed • Regional layers • National Atlas (subset)

30. Available WATERS Services • Web and Database Services • Identify Service • Total Waters by State, HUC, FCODE, and Bounding Box • Name Service • Upstream/Downstream Service • Navigation Service * • Validate and Convert Lat/Long Service • Get Entities by Lat/Long, HUC, and Radius Service • Get Program Waters Entities • NHD Event Indexing Service * • NHD Point Indexing Service * * Currently database only service Additional Information: http://www.epa.gov/waters/geoservices/index.html

31. WATERS Services Web Page • Services web page contains high-level overview information about available services. • Indicates if service is available as web and/or database service. • Provides link to SOAP Service Endpoint and WSDL. • Provides information about underlying database location and name.

32. WATERS Services Web Page • Services web pages contain detailed level information about individual services. • Description of the service • Input parameters • Example call to the database service • Sample SOAP Request • UML object diagram • Output object • Sample SOAP Response

33. WATERS Services Web Page • Services web pages contain detailed level information about individual services. • Description of the service • Input parameters • Example call to the database service • Sample SOAP Request • UML object diagram • Output object • Sample SOAP Response

34. WATERS Services Web Page • Services web pages contain detailed level information about individual services. • Description of the service • Input parameters • Example call to the database service • Sample SOAP Request • UML object diagram • Output object • Sample SOAP Response

35. WATERS Services Web Page • Services web pages contain detailed level information about individual services. • Description of the service • Input parameters • Example call to the database service • Sample SOAP Request • UML object diagram • Output object • Sample SOAP Response

36. Future Direction • GIS services • Enable ArcGIS based KML and WFS services • Update RAD Download service functionality • Release Google Earth based KML files, ArcMap Template, and ArcGIS Explorer map document • Basin delineation service • Deployment of SOAP based versions of existing NHD Event Indexing Service, NHD Point Indexing Service, and Navigation Service • New lightweight HTTP gateway service endpoints • KML, JSON, GeoJSON and user provided style sheet output options • Similar to ERSI’s JavaScript API for Google Maps and Virtual Earth • Avoids cross-site browser scripting limitations when accessing services from different domains

38. What it means to users • Users can develop light weight mapping clients that easily consume OW services. • The example screenshot shows a light weight client making a call to the OW Navigation Service requesting navigation results 25 miles upstream of a point location.

39. What it means to users • Users can develop light weight mapping clients that easily consume OW services. • The example screenshot shows a light weight client making a call to the NHD Point Indexing Service. • 1) Shows the results of a snap operation. • 2) Shows the results of a raindrop operation.

40. What it means to users • Users can develop light weight mapping clients that easily consume OW services. • The example screenshot shows a light weight client making a call to a prototype basin delineation service that dissolves smoothed catchments into a resulting basin of interest.

41. What it means to users • Users can display web service results using customizable style sheets.

42. Demonstration • Access to framework geospatial datasets stored in the WATERS Database and to general purpose interactive service panels. • Dialog boxes providing access to tools, services, and information, such as NHD feature name query, total waters, up/downstream navigation, watershed reports, ATTAINS reports, etc. • Access to indexed water program features, with hyperlinks to additional attributes, and context sensitive analysis services, such as up/downstream navigation and watershed reports.

43. The End OISC WQX