Downloading Annual Peak Streamflow Data from USGS
Text: USGS gauge station name (USGS 03335500)
DateTime: Start date/time (1981)
DateTime: End date/time (2015)
Numerical Values: Time series of annual peak streamflow for thirty five years in a text file.
- Internet Browser
- MS Excel
To begin with, type the name of the USGS station number and gauge name in the internet browser (USGS 03335500 wabash river at lafayette) and click on the National Water Information System's Web Interface for the site as shown below:
Now click on the arrow next to 'Available data for this site' and select 'Surface Water: Peak Streamflow'. You will be directed to a new window as shown below:
From the 'output formats', select tab separated file option. A file with information on the annual peak streamflow will open up. Select the entire data on the new page and copy in a notepad file and save the file as USGS03335500. For more information on downloading data from USGS website, please refer to http://serc.carleton.edu/hydromodules/steps/dm1.html.
The saved file in notepad will look like the image below:
Now, open MS excel and in a blank workbook, select the 'Data' tab and click on the 'From Text' option. In the new window, select the notepad file USGS03335500 and click on 'Import'. The MS Excel window will open up a text import wizard that allows importing data from text files in a specific format. Select 'Delimited' in Step 1 and click on Next as shown below:
In the step 2, click on 'Tab' in the delimiters menu and click on Next. Click on Finish. Select the first cell of the workbook to import the data in the next window and save the excel workbook as 'USGS03335500'. After saving the excel workbook, select the data in the columns named 'peak_dt' and 'peak_va' and delete everything else. Rename the tab 'peak_dt' as 'Time' and 'peak_va' as 'Annual Peak Streamflow (cfs)'. Here, 'cfs' refers to cubic feet per second which is the unit for measurement of streamflow. Now, delete all the data prior to 1981 from both the columns to only include 35 years of data in the excel sheet.
The final excel file should look as shown in the image below:
Save the excel sheet.
Okay, you are done downloading annual peak streamflow data into a text file and importing it into an excel workbook!