Abstract
Improving Oregon's Water Distribution Reporting System
Track: Water Resources
Authors: Robert Harmon
The OWRD is working on improving the speed and accuracy of it water distribution reporting tools. It is migrating its stream codes to the NHD to take advantage of the single nationwide hydro data set maintained by many groups across several levels of government. Routes are built on the OWRD stream codes which provide indices on the water right points of diversion. A recursive query in MS SQL Server can quickly select water rights served by those diversions above or below a specified location.