Thursday, November 29, 2012

Visit the CUAHSI Booth at AGU!


If you are attending next week's American Geophysical Union Fall Meeting, be sure to stop by the CUAHSI booth (Booth #105 on NSF Street) and say hi! We will be discussing CUAHSI's activities in the water research community, showing HydroDesktop and HIS related demos, and giving away CUAHSI gear!

Need some suggestions for sessions to attend? Check out the list below for sessions that involve HIS.

Monday, 12/3/2012

Session: IN11F. Open Source Technologies and Architectures Facilitating Science Data Center Collaboration and Management II. 8:00 AM - 10:00 AM; 2020 (Moscone West)
 8:30 AM - 8:45 AM. Combining data from multiple sources using the CUAHSI Hydrologic Information System.
David G. Tarboton; Daniel P. Ames; Jeffery S. Horsburgh; Jonathan L. Goodall

Session: GC12B. Sustainable Future: Climate, Resources, and Development I. 10:20 AM - 12:20 PM; 3001 (Moscone West)
11:00 AM. Sharing Water Data to Encourage Sustainable Choices in Areas of the Marcellus Shale.
Susan L. Brantley; Jorge D. Abad; Julie Vastine; David Yoxtheimer; Candie Wilderman; Radisav Vidic; Richard P. Hooper; Kathy Brasier

Thursday, 12/6/2012

Session: ED41A. Distributing Science Data for Reuse Posters. 8:00 AM - 12:20 PM; Hall A-C (Moscone South)
The CUAHSI Water Data Center: Empowering scientists to discover, use, store, and share water data
Alva L. Couch; Richard P. Hooper; Jennifer S. Arrigo

Friday, 12/7/2012

Session: IN53D. Semantics and Cyberinfrastructures for Next Generation Science II. 1:40 PM - 3:40 PM; 2020 (Moscone West)
1:40 PM. Providing Data Access for Interdisciplinary Research.
Richard P. Hooper; Alva Couch

Tuesday, November 27, 2012

Using HydroDesktop to Examine Precipitation and Discharge in Topeka, Kansas

A quintessential benefit of using HIS is the ability to access time series data from multiple sources. HydroDesktop provides tools to discover, download, and examine data from any data source registered in CUAHSI HIS. And, what you will see in the following exercise, is that HydroDesktop can be used to examine multiple variables from multiple sources to enable a better understand of a site or watershed. In this example, we will look at precipitation and discharge near Topeka, Kansas from 1990 to 2010.

Note: The screenshots included in this post are from HydroDesktop 1.5.10. Since this is an ongoing development project, the interface and functionality of the client are subject to change.

The first step we must take, is to limit our search by geography. To do this, lets first look at the state of Kansas as a whole. Select the state of Kansas either by using the Select by Attribute Tool on the Search Ribbon or highlighting the states layer in the Legend and, using the Select Tool (located on both the Map and Search ribbons), clicking on the state of Kansas.

When selecting a feature in HydroDesktop, the corresponding layer must be highlighted in the Legend.

Next, we can limit the search for specific variables during a specific time period. This can be done under the Search Ribbon. There are three ways to search for multiple keywords. The first is to type the keywords into the upper search box separated by semicolons. You should use this only if you know the exact search terms, otherwise you may not get any search results. The second way is to begin typing the bottom search box, which uses autofill, to identify keywords then entering them into the upper search box (pressing enter will add a term to the upper search box). Lastly, you can add keywords by opening up the hierarchy of keywords under the Add More Keywords button. In this example, we will be searching for "Precipitation; Discharge, stream"

To define the search temporally, simply add start and end dates in the applicable boxes to the right of the keyword search boxes. In this example we will search from the 1/1/1990 to 1/1/2010.

The keyword date search boxes are located next to each other on the Search Tab. 

Once you have entered the search criteria, click the Search Button. The search will take a few moments as HydroDesktop searches the metadata catalog for sites that match our search criteria.


There are sites throughout the state of Kansas with observed precipitation and discharge values.

The search result yields a plethora of sites in the state from a number of data sources including the USGS, EPA, Kansas State University, and is a bit overwhelming to look at. Let's take a closer look at Shawnee County, where Topeka is located. To do this, open the Select by Attribute tool, select the US Counties layer, and type "Shawnee, Kansas" (autofill will complete your entry as it is typed).

You can use any GIS layer, like the U.S. counties layer that is included with the HydroDesktop download, to search for data.

When we zoom into Shawnee County, we can see the search results are much more manageable and we can distinguish between sites that have precipitation observations and those that have discharge observations. To identify the stations with data I want to download, I have zoomed in further on Topeka (see screenshot below), turned the counties layer off, and turned the Google basemap on. After surveying the available sites, I've decided to examine sites in North Topeka. One has precipitation data from Kansas State University Daily Weather Data while the other has discharge data from the USGS NWIS Daily Values.


I decided to download data from two sites in North Topeka.

Finally, I can download the data from these sites by selecting them and clicking the Download button or hovering over them with Map Popups enabled (on the Search Ribbon) and clicking Download Data. With the download complete, I can examine the data in the Graph Ribbon.


This graph shows precipitation and discharge data observed in North Topeka, Kansas from 1990 to 2010.

The data can also be exported using the Export button on the Table Ribbon.

The option to export data is available on the Table Ribbon.


Wednesday, November 21, 2012

An Introduction to WaterOneFlow Web Services


A cornerstone of the CUAHSI HIS is a family of unique web services that enable data transmission. Web services are computer applications that interact, and exchange information, with other computers over the internet. The family of web services that has been developed for and employed by HIS is called WaterOneFlow (WOF).

WOF uses a set of functions to query to retrieve information from a HydroServer and the data is returned in a specific type of XML, WaterML, which has been specifically designed to transmit water data across the internet. The functions used are as follows:

Get Sites: Returns sites in a data source including location
Get Site Info: Returns information about any time series located at a specific site such as variables measured, start & end dates of observations, and units.
Get Variable Info: Returns information about a specific times series such as units, value type, data type, and sample medium.
Get Values: Returns values of a specific time series.

An easy way to become acquainted with these web services is by using HydroExcel, which is one of the CUAHSI clients that has been developed for retrieving water data registered in HIS. HydroExcel is Microsoft Excel spreadsheet that  uses VBA macros and an object library called HydroObjects to communicate with and retrieve data from WaterOneFlow web services.

HydroExcel is especially useful if you know what data source you are interested in, but is not as useful if you are trying to search over multiple data sources. When first opening HydroExcel, you are presented with the list of registered data services in HIS Central. To look at data, and metadata, you must simply copy the WSDL Location from a respective service and paste this URL into the WSDL Location box at the top of the Data Source tab.

The Data Source tab of HydroExcel. Be sure to enable macros and to refresh the list of services from HIS Central when the file is first opened.

After pasting the URL for your data source, you can invoke the individual web services by clicking on the buttons on the data source sheet (i.e. Get Sites, Get Variables, etc.). Clicking these will bring you to other sheets in the file where additional functionality is available.