Data overview

The data available through the Lawrence Berkeley National Laboratory Sustainable Systems SFA 2.0 Rifle Datamanagement Site include both current and historic data from the Rifle site. In addition to the data (which can be downloaded in different forms) the site provides basic capabilities for visualizing the different datasources.

There are several sources of data, which are accessible in different ways. The two ways in which data is available is

  • As a data package. This is a file (.zip, *.doc, *.xls etc) which contains data provided by a collaborator. In several cases it is handy to grab these files directly (for instance, information on wells or chemistry results).
  • Through a spatial interface. The data which is available through a spatial interface includes timeseries data of physical and chemical measurements and borehole logs. In the future this should als o include biogeochemical data
The data available through the spatial interface include
  • Data collected by the DOE LM (Legacy Management) operated SOARS system. SOARS stands for System Operation and Analysis at Remote Sites. The SOARS system provides logging and storage of data from nu merous sensors at many DOE LM. While the SOARS system can be accessed through a webinterface, it can be challenging to get the data in an easily useable format. Thus, in a collaboration between LM and the SFA2.0 effort data is transmitted hourly for those sensors located at the Rifle site. This data is then made available through a webinterface. SOARS typically collects data at 5 minute intervals.
  • Data obtained from the DOE LM operated GEMS (Geospatial Environmental Mapping System). This includes both borehole log data and geochemical data.
  • Manually collected well waterlevel data. This data can be used to verify the quality of the SOARS data (which can have jumps). Manual waterlevel data is typically collected at monthly or sometimes weekly intervals. This data is also available through the web interface.
  • Well chemistry data collected by Ken Williams and his colleagues at Rifle. This data has been collected for several years. This data was often collected in association with one of the several exper iments which have been performed at the Rifle site over the past several years, but there is also site wide data which can be used to understand the floodplain evolution under natural conditions.
  • Data from 3rd parties. This includes weather data from Weatherunderground at two stations in the vicinity of Rifle and data from a USGS gaging station ups tream from the Rifle site.

Visualizing and downloading timeseries data

One of the main interests for most scientists will be to download data for their own use. This can be done easily through the webinterface. The same webinterface also allows graphing and limited ana lysis. There are several ways to find data. These include through the Rifle map link , and through Time Series data link. Both of these provide information to the same data,but in different ways. The Rifle map provides a good starting point to find out what data is available for a well. Wells can be found easily by selecting the appropriate layer(s). When you select a well (either by clicking on the map symbol, or on the name of the well on the right hand site) the map zooms to this well and shows a pop up window. This pop up can have either one or multiple tabs which p rovide a direct link to the associated data with the borehole. A tab is only present if there is associated data. The following tabs can exist

  • Borehole information This tab always exist and provides information on well name and location.
  • Borehole data If a borehole log exists this tab will provide a link to the log. If the link is clicked it will show the log in a new tab. The log is in pdf form.
  • Physical data If a borehole has waterlevel or temperature measurements associated with it, this tab will provide links to it. Clicking the links will show you the data
  • Chemical data If a borehole has chemistry measurements associated with it from either GEMS or from LBNL efforts, this tab will provide a link to it. Clicking the links will bring you to an interface which shows the available data and allows you to visualize or download the data.

Visualization settings

The visualization interface has a number of settings. These are generally the same for different data types. See e.g. the Waterlevel data interface for the discussion below

  • Graph title The title on the graph. Can be left blank or changed by user. If the visualization is invoked from the Map interface this field is automatically set to the name of the well.
  • Start Date and End date The start and end date for the plot. If these fields are left blank all data is used.
  • Sec. Start Date and Sec. End date If these fields are not blank a second period will be plotted, with a secondary time axis on the top. This allows for the comparison of data over two differ ent periods.
  • Time zone In order to maintain conformity all dates are internally stored in coordinated Universal time. When a user graphs or retrieves the data he/she can select what timezone the data sho uld be presented in. Note that the timezone in which the data is given will be standard time (so data will be continuous, ie no jumps/holes at the daylight savings time). Note however that currently th e SOARS system overwrites data when the clock jumps back, so that there will be an hour data hole in the fall.
  • Processing period Users can select several processing options on the data. This choice determines the period. If this is set to none no processing is done
  • Processing choice This selection determines the processing which is done. Choices are
    • AVG This calculates the average of the values over the selected period
    • SUM This calculates the sum of the values over the selected period
    • MIN This calculates the minimum of the values over the selected period
    • MAX This calculates the maximum of the values over the selected period
    • STDDEV This calculates the standard deviation of the values over the selected period
  • Y lower and upper bound The bounds of the graph are calculated automatically from the data ranges. This option allows one to set the bounds manually
  • Show 0 values If this box is checked 0 values are shown. Note that 0 values can be real (e.g. rainfall) or associated with instrument dropouts (e.g for waterlevels)
  • Normalize data What this option does (if checked) is to subtract the first value of each dataset from all the other values in that dataset (so that all datasets start at 0). This is a good w ay to compare changes between waterlevel excursions in different wells
  • Image Size This selects the size of the image generated by the webinterface

Note that the options apply both to the Graphing and Download data choices.