Water table example

watertest.sh

#!/bin/bash

# Check to see if the data is already downloaded
if [[ -e ./waterData ]]; then
    echo "Water data already downloaded reading from cache";
else
    # Data isn't downloaded so grab it from the web
    echo "No cached data found downloading water data...";
    wget -O waterData "http://nwis.waterdata.usgs.gov/ca/nwis/uv/?search_station_nm=russian%20river&search_station_nm_match_type=beginning&county_cd=06097&index_pmcode_00400=1&index_pmcode_00095=1&index_pmcode_00010=1&index_pmcode_63680=1&group_key=NONE&sitefile_output_format=html_table&column_name=agency_cd&column_name=site_no&column_name=station_nm&range_selection=date_range&begin_date=2008-01-01&end_date=2008-12-31&format=rdb&date_format=YYYY-MM-DD&rdb_compression=value&list_of_search_criteria=county_cd%2Csearch_station_nm%2Crealtime_parameter_selection";
    # Convert line endings to unix style (The site is currently providing Windows Style)
    dos2unix waterData
fi

# Print the result
cat waterData | dos2unix | grep USGS | awk '{ total += $6; count++ } END { print total/count }'