managing the nation’s hydro events nhd stewardship conference 2012

NHD Stewardship Conference 2012

U.S. Department of the InteriorU.S. Geological Survey

Hydrography Event Hydrography Event Management (HEM) ToolsManagement (HEM) ToolsUpdateUpdate

Ariel DoumbouyaAriel Doumbouya

3

4

NHD Update Tools and NHD NHD Update Tools and NHD EventsEvents

• HEM Job TypeHEM Job Type

• All HEM required feature classes and tables are All HEM required feature classes and tables are delivereddelivered

• Requires a subset of the normal QCRequires a subset of the normal QC

5

What’s Next?What’s Next?

• ArcGIS 10.1ArcGIS 10.1

• WebWeb

6

More Information: More Information: http://nhd.usgs.gov

Jay StevensBureau of Land

ManagementOregon State Office

Using event data in analysis and Using event data in analysis and reportingreporting::

How Oregon BLM Uses Event OverlayHow Oregon BLM Uses Event Overlay

First version of Aquatic Resource Information Management System (ARIMS) database deploys in 2000. Used ArcView and Informix. Uses Linear Events on routed line-work (LLID system)

Decision is made in 2006 to switch to NHD data model for PNW Framework Hydrography. Forest Service and BLM are main drivers.

Development of Hydro Event Management (HEM) tools begins in 2007 with Forest Service event-maker app as starting point.

ARIMS redesigned to use HEM and NHD in ARCGIS 9 environment in 2008

Legacy event data (millions of records) are migrated to NHD and HEM format in 2008-2009

Subsequent HEM development with EPA and USGS support add enhancements to system.

HEM and ARIMS work together in ARCGIS environment to manage aquatic data stored as events on the NHD route system.

All event data and NHD data used for linear referencing stored in same SDE Oracle instance

Deployed on Citrix server farm Users located in central, district, and

field offices.

Fish Distribution Riparian Wetland Condition Stream Surveys /Geomorphology Flow characteristics Water Quality Data

Criteria from multiple event tables needed to calculate riparian buffer distance

BLM Fishbearing Status

BLM Flow for Planning

Selection for varying buffer distances can be made easily when both events’ attributes are on same set of flowlines

("PLANFLOW" = 'I' or "PLANFLOW" = 'P' ) and "FISHBEARING" = 'ANV'

Need to be able to select and report miles of stream by fish presence, riparian condition, periodicity, etc.

Can’t have duplicate copies of geometry (no double-reporting miles)

Some of the data is temporal so need to extract most recent information

ARCGIS Event Overlay – Not line on line geometry overlay. Event overlay uses tabular route and measure info to INTERSECT or UNION event tables thus adding new fields from each successive overlay.

Oracle PL/SQL Analytical Queries – Used to analyze temporal event data to bring most recent records forward into publication dataset. Riparian Functioning data (PFC) and Fish presence data are processed this way.

Jay StevensOregon State OfficeBureau of Land ManagementgStevens@blm.gov

Dan WickwireOregon State Office Bureau of Land ManagementDan_Wickwire@blm.gov

Dana BakerOregon State OfficeBureau of Land Managementd2baker@blm.gov

PNWHFwww.pnwhf.org

NHD Stewardship ConferenceNHD Stewardship ConferenceMarch 29-30, 2012March 29-30, 2012New Orleans, LANew Orleans, LA

Montana Hydro Event ManagementMontana Hydro Event Management

Troy Blandford, Montana Department of Natural Resources and ConservationMichael Pipp, Montana Department Environmental Quality

Evan Hammer, Montana State Library

• Hydrography is one of 14 Montana Spatial Data Hydrography is one of 14 Montana Spatial Data Infrastructure (MSDI) Framework Layers.Infrastructure (MSDI) Framework Layers.

• Montana adopted the NHD as the state Hydrography Montana adopted the NHD as the state Hydrography Framework.Framework.

• The Montana State Library (MSL)/Natural Resource The Montana State Library (MSL)/Natural Resource Information System (NRIS) has an agreement with the USGS Information System (NRIS) has an agreement with the USGS to act as the state level data steward for the NHD and…to act as the state level data steward for the NHD and…

• NRIS is recognized by the Montana Land Information NRIS is recognized by the Montana Land Information Advisory Council as the state steward of the MSDI Advisory Council as the state steward of the MSDI Hydrography Framework.Hydrography Framework.

Montana Hydrography Stewardship ModelMontana Hydrography Stewardship Model

• NRIS provides staff for NHD Stewardship and the NHD Technical Point NRIS provides staff for NHD Stewardship and the NHD Technical Point of Contactof Contact

• NRIS is a data provider and not an end user so our focus is on getting NRIS is a data provider and not an end user so our focus is on getting state hydrography users together to build the dataset that they needstate hydrography users together to build the dataset that they need

• NRIS holds regular Hydrography Workgroup meetings and develops a NRIS holds regular Hydrography Workgroup meetings and develops a Hydrography Strategic/Business Plan Hydrography Strategic/Business Plan

• Current stewardship focus on getting core state agencies to use a Current stewardship focus on getting core state agencies to use a common Hydrography. common Hydrography.

• Projects underway at the Department of Natural Resources and Projects underway at the Department of Natural Resources and Conservation, Department of Fish, Wildlife and Parks, and the Conservation, Department of Fish, Wildlife and Parks, and the Department of Environmental Quality.Department of Environmental Quality.

• All of these projects take an event management approach to leveraging All of these projects take an event management approach to leveraging the value of the NHD for filling state agency business needs.the value of the NHD for filling state agency business needs.

Montana Hydrography Stewardship ActivitiesMontana Hydrography Stewardship Activities

Montana Department of Natural Resources – Water Rights Point of Diversions – Montana Department of Natural Resources – Water Rights Point of Diversions – Troy Blandford will give a brief overview of the project and discuss the success they Troy Blandford will give a brief overview of the project and discuss the success they have had trying different approaches for matching up dams in the Water Rights have had trying different approaches for matching up dams in the Water Rights database to the NHD.database to the NHD.

Montana Department of Environmental Quality – Water Quality Data – Michael Pipp Montana Department of Environmental Quality – Water Quality Data – Michael Pipp will talk about the data management workflows that were developed to allow the will talk about the data management workflows that were developed to allow the agency to use the continuously changing NHD as a reference dataset.agency to use the continuously changing NHD as a reference dataset.

Montana Department of Fish Wildlife and Parks – fisheries data and the Montana Department of Fish Wildlife and Parks – fisheries data and the requirement of Whole Stream Identifiers. Much of the fisheries work done by this requirement of Whole Stream Identifiers. Much of the fisheries work done by this agency is in collaboration with other pacific nw states. The fundamental organizing agency is in collaboration with other pacific nw states. The fundamental organizing unit for their data management is the full river. We are exploring the possibility of unit for their data management is the full river. We are exploring the possibility of developing a type of compund event that may meet their business needs.developing a type of compund event that may meet their business needs.

Montana Hydrography Stewardship ProjectsMontana Hydrography Stewardship Projects

Troy BlandfordTroy BlandfordMontana DNRCMontana DNRC

NHD Stewardship ConferenceNHD Stewardship ConferenceMarch 29-30, 2012March 29-30, 2012New Orleans, LANew Orleans, LA

Dams to NHD: An Exercise in Locating Dams from Dams to NHD: An Exercise in Locating Dams from the Montana Water Rights Database. the Montana Water Rights Database.

Overview of the Bigger ProjectOverview of the Bigger Project

POD2NHD Overall Goal: POD2NHD Overall Goal: •Assess the feasibility of geospatially enabling the DNRC Assess the feasibility of geospatially enabling the DNRC Water Rights Database and integrating it with the NHD.Water Rights Database and integrating it with the NHD.

A large majority of the diversions: DAMSA large majority of the diversions: DAMS

* Active water rights only, March 2012. Minimum counts (dissolved by unique legal land description).

Total ~ 180,000

The majority of the diversions: DAMSThe majority of the diversions: DAMS

* Active water rights only, March 2012. Minimum counts (dissolved by unique legal land description).

Total ~ 180,000

Example of Livestock Direct from Source

Amount of time to place all dams estimated at over a year.

• Automate the process as much as possible.• Use multiple sources and their spatial relationships.

Successfully automated the placement of over 23K (55%) of the water right dams to NHD.

• Only 20K dams and 140K more surface water right points of diversion to go.

• Attribute the dams

• Continue to investigate referencing additional means of diversion types (significant effort; not as easy to place as dams; may not have as much success automating).

Managing the NHD as a reference dataset for Managing the NHD as a reference dataset for Water Quality event featuresWater Quality event features

Michael PippMichael PippMontana DEQMontana DEQ

NHD Stewardship ConferenceNHD Stewardship ConferenceMarch 29-30, 2012March 29-30, 2012New Orleans, LANew Orleans, LA

Mapping Montana DamsMapping Montana Dams

Mapping Montana DamsMapping Montana Dams

Questions?Questions?Evan Hammer – Ehammer@mt.gov

Troy Blandford – tblandford@mt.govMichael Pipp – mpipp@mt.gov

Thank You!Thank You!