TUSCALOOSA, Ala. — Using Google BigQuery, developers from the Cooperative Institute for Research to Operations in Hydrology, or CIROH, partnered with researchers from Brigham Young University, Google and SADA Inc. to rebuild the way that forecasts from the National Water Model, or NWM, are stored.
The CIROH-funded team converted cumbersome nationwide forecasts into tables that facilitate easy access to forecasts for specific streams. These reshaped forecasts allow others to build on their work faster than ever before, accelerating product development and research-to-operations in the field of hydrology.
Understanding the NWM
The National Oceanic and Atmospheric Administration created the NWM to provide streamflow forecasts for millions of river reaches across the United States. It is the most detailed picture of the nation’s rivers, making it an invaluable resource for flood and drought prediction and response, water supply planning, agriculture and recreation.

Despite the importance of the NWM, finding the forecasts for a specific stream used to be difficult. The NWM forecasts are saved in nationwide snapshots packed into large files. To find the forecasts for a specific stream, users had to download large files and dig through forecasts for the entire country. This method was slow, and required an immense amount of storage, discouraging anyone without the time and space for the files.
“Anyone who wanted the forecast for one stream had to pull the nationwide snapshot files over and over, and dig out the reach they cared about,” said Dr. Dan Ames, a professor of civil and construction engineering at BYU. “That kept most students, app developers and water managers away from the data.”

Restructuring the Data
While these data-access problems were obvious to those who had tried to build apps on the model, Ames and the team at CIROH were the first to take steps toward restructuring the data itself. Ames, alongside Arpita Patel, CIROH’s assistant director of IT and DevOps, recognized the potential of a partnership between their team, SADA Inc. and Google to improve the system.
The team’s project began in the fall of 2023. They worked remotely from California, Utah and Alabama, building on their existing collaborations to transform the data and its storage method. To take the large, nationwide files, they needed to rebuild the way the information from the NWM is stored.
Using Google Cloud Platform Services, they constructed tidy tables in which each row is one forecast for one stream at a specific time. Separating the data in this way is much more digestible, in addition to being much less storage-intensive. Rather than being stored locally on a researcher or developer’s drive, these tables are stored in Google BigQuery, a cloud data warehouse. BigQuery can sift through enormous datasets, like those produced by the NWM, and return the requested information in seconds rather than hours.
Sharing New Tools
In April 2024, the team shared their dataset publicly for the first time. To make their simplified version of NWM forecasts more accessible, the team also developed a free, open-source web application programming interface, or API. The CIROH-hosted API allows anyone to pull the exact forecast that they need with only a simple web request. This system removes the need for cloud or database expertise, opening the door for more users to access critical forecasts that can inform decision-making processes.
“CIROH’s DevOps team hosts and maintains the service to give researchers in the consortium a single, maintained and secure way into the National Water Model, instead of each team building and paying for its own pipeline.” Patel said.
To help other researchers implement the new tools, Ames and Patel’s team taught API workshops at the CIROH Developers Conferences in 2024 and 2025 with lots of positive feedback. Across the CIROH consortium, researchers recognized that the API solved a problem they had spent semesters trying to figure out.
Continued Work with Continuous Impact
Already, these tools are being put to work across the country to improve flood prediction. The API and improved dataset form the foundation for tools like CUAHSI’s FloodSavvy and help to train case studies from Utah to Vermont. Several student-built apps also use the tools, demonstrating that these developments also foster further creativity and advancements in hydrology.
“The best feedback is that people build on it,” said Ames. “Because the whole design is open source, other groups have asked how to copy it for their own models, which is exactly the point.”
The team has a mobile flood-awareness app in review with the Journal of the American Water Resources Association. They also recently launched another app, called RIVR, that displays the NWM forecasts in a simple to use mobile application. These apps continue the work that they started more than three years ago, with the goal of continuously improving the usefulness and accessibility of critical NWM forecasts.
Open-source tools like those created through this collaboration support the principles of open science, transparency and reproducibility in research. The work of Ames, Patel and their partners enhances the value of the NWM while making contributions that will benefit the hydrologic community far into the future.
About CIROH
The Cooperative Institute for Research to Operations in Hydrology (CIROH) is a NOAA Cooperative Institute hosted at The University of Alabama and supported by the National Weather Service. As a unique national consortium with 28 partner institutions, CIROH unites academic, government and private sector partners to co-produce research that enhances operational water prediction capabilities and informs critical decision-making for issues like floods, droughts and water quality. Through its interdisciplinary research, educational initiatives and outreach programs, CIROH advances NOAA’s water prediction services with new techniques such as artificial intelligence and remote sensing, equips the next generation of water-resource professionals with essential skills and fosters public and stakeholder engagement to support federal agency and private sector needs. CIROH transforms scientific innovations into practical solutions and operational tools that boosts the delivery of actionable water intelligence, increases effectiveness of water resources management, promotes community resilience and informs decision-makers across the United States.