How do I work the USGS streamflow site... Seriously - Page 2 - Mountain Buzz
 

Go Back   Mountain Buzz > Whitewater Boating > Whitewater Kayaking


Reply
 
Thread Tools Display Modes
 
Old 04-01-2013   #11
 
2kanzam's Avatar
 
Charleston, West Virginny
Paddling Since: 1996
Join Date: Aug 2012
Posts: 462
Quote:
Originally Posted by boatless View Post
Here is how to build a discharge graph using the USGS website:

1) open the site you're interested in
2) click on "Summary of all availbel data for this site"---this is just below the parameter box at the top of the page
3) select daily data from the available data
4) select "graph" as the output format and enter the Begin and End dates on the left. Note that the pop-up calander feature does not work (at least with explorer) you must enter the date range manually.
5) press go and enjoy

This works for daily discharge but does not work for average flow by month as the poster asked for.

In mine I should have suggested the OP use bar or column as opposed to line (at least makes more sense to me)

2kanzam is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old 04-02-2013   #12
LSB
Renaissance Redneck
 
LSB's Avatar
 
Huson, Montana
Paddling Since: 1988
Join Date: Mar 2004
Posts: 1,222
Quote:
Originally Posted by 2kanzam View Post
#1 Go to the site of the gauge you are interested in.

#2 Near the top there is a drop-down box that says "Available data for this site" and choose > "Time series: Monthly statistics"

#3 in the resulting page/Parameters box check the box next to "Cubic foot discharge"

#4 Enter the date range you want below that

#5 Below that just make sure the radio button for "Table of monthly mean" is checked

#6 Submit

#7 The result is a text chart> Drag your cursor across JUST THE NUMBERS, YEARS AND MONTHS YOU WANT so they are highlighted in blue(I often leave out the years for a cleaner graph)

#8 While they are still hilighted hit ctrl and C at the same time (or right click and select> copy)

#9 Open excel and click in a cell. Hit ctrl and V at the same time (or right click and select> paste)

#10 Now in excel select all the months and cfs readings by dragging your cursor across them all

#11 Hit the "Insert tab" and you will see a little line graph that says "Line" under it. Hit that button, choose the style of graph you want

#12 Sit back and read your awesome chart and amaze your friends
Thanks
That worked
You're right a bar graph looks better
but what a PITA
Can't somebody wright an app for this
__________________
"You're gonna be doin a lot of doobie rolling when youre LIVIN IN A VAN DOWN BY THE RIVER"
LSB is offline   Reply With Quote
Old 04-02-2013   #13
LSB
Renaissance Redneck
 
LSB's Avatar
 
Huson, Montana
Paddling Since: 1988
Join Date: Mar 2004
Posts: 1,222
A pivot chart of the data works better to reduce clutter because I can eliminate the months I'm not interested in
__________________
"You're gonna be doin a lot of doobie rolling when youre LIVIN IN A VAN DOWN BY THE RIVER"
LSB is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old 06-12-2015   #14
LSB
Renaissance Redneck
 
LSB's Avatar
 
Huson, Montana
Paddling Since: 1988
Join Date: Mar 2004
Posts: 1,222
I thought I'd bump this thread because I had to search it to figure out how to do it again.
Still a PITA
After 2 years surely theres a better way.
__________________
"You're gonna be doin a lot of doobie rolling when youre LIVIN IN A VAN DOWN BY THE RIVER"
LSB is offline   Reply With Quote
Old 2 Weeks Ago   #15
LSB
Renaissance Redneck
 
LSB's Avatar
 
Huson, Montana
Paddling Since: 1988
Join Date: Mar 2004
Posts: 1,222
Bumping again because I needed to do it and couldnt remember how
__________________
"You're gonna be doin a lot of doobie rolling when youre LIVIN IN A VAN DOWN BY THE RIVER"
LSB is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Topic Thread Starter Forum Replies Last Post
USGS guages sequestered wyosam Whitewater Kayaking 9 03-08-2013 01:03 PM
Streamflow prediction website david23 Whitewater Kayaking 3 04-10-2009 12:34 PM
sup w/ USGS? latenightjoneser Whitewater Kayaking 1 07-31-2008 08:26 PM
whats up with USGS? yetigonecrazy Whitewater Kayaking 0 07-21-2008 07:55 AM
Streamflow forecasts - is there such a thing? wycoloboater Whitewater Kayaking 5 02-14-2006 08:18 PM

» Classified Ads
Powered by vBadvanced CMPS v3.2.3

All times are GMT -6. The time now is 12:23 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.