Latest Activity

Robert Dickinson commented on Robert Dickinson's group Stream of Information
"Brixham, England May. 29, 2012 "
8 hours ago
Robert Dickinson commented on Robert Dickinson's group Stream of Information
"by jasonkillinger. Browse more data visualizations. "
8 hours ago
Robert Dickinson left a comment for kerma ben
"Welcome Kerma!"
20 hours ago
kerma ben is now a member of SWMM5 - Stormwater Management Model
yesterday
Robert Dickinson added a page to the group SWMM4 Input Files
Thumbnail

Historical SWMM 5 and SWMM 4 Engines and Examples

Subject:  Historical SWMM 5 and SWMM 4 Engines and Examples   The web site has http://swmm5legacycode.ning.com/  historical SWMM 5 installs, SWMM 5 input file examples and SWMM 4 input files and engines.   The SWMM 4 engines go back to SWMM 3.5…
yesterday
Robert Dickinson commented on Robert Dickinson's group SWMM4 Input Files
"Subject:  Historical SWMM 5 and SWMM 4 Engines and Examples   The web site has http://swmm5legacycode.ning.com/  historical SWMM 5 installs, SWMM 5 input file examples and SWMM 4 input files and engines.   The SWMM…"
yesterday
Robert Dickinson added a page to the group Blog Links
Thumbnail

SWMM5.NET

15 GPM 1985 1D Components in InfoSWMM 2D 3 Types of Manholes in SWMM 5 and InfoSWMM 3 Types of Subcatchment Flow in SWMM 5 A Basic InfoSewer Wet Well A feedback loop involves four distinct stages A rise in Pipe Inverts Across a SWMM 5 Node A…
yesterday
Robert Dickinson posted groups
yesterday
Robert Dickinson commented on Robert Dickinson's group Stream of Information
"Udaipur, India May. 28, 2012 "
yesterday
Robert Dickinson posted photos
yesterday
Robert Dickinson commented on Robert Dickinson's group Weather
"Man-made Pollution Shifting Tropics and Sub-Tropics Poleward "If a poleward displacement of the mid-latitude storm tracks also occurs, this will shift mid-latitude precipitation poleward, impacting regional agriculture, economy, and…"
yesterday
Robert Dickinson commented on Robert Dickinson's group Weather
"Poor neighborhoods have fewer trees, as these jarring satellite photos reveal.: http://www.treehugger.com/economics/how-spot-income-inequality-space-look-trees.html"
yesterday
Robert Dickinson commented on Robert Dickinson's group Weather
" Climate Change is Frying Our Cities Rising temperatures are set triple the heat-related deaths in cities across the U.S., a new report finds. Cities need to fight back."
yesterday
Robert Dickinson posted a video

RSA Animate - The Power of Networks

In this new RSA Animate, Manuel Lima, senior UX design lead at Microsoft Bing, explores the power of network visualisation to help navigate our complex moder...
Monday
Profile IconThere are 291 members on SWMM5 - Stormwater Management Model
Sunday
Robert Dickinson commented on Robert Dickinson's group ExtraVariables
"Update of May, 20012 Epaswmm5.exe swmm5.dll"
Sunday
Robert Dickinson commented on Robert Dickinson's group Stream of Information
"Ocean Currents "
Sunday
Robert Dickinson replied to Robert Dickinson's discussion How is the St Venant Equation Solved for in the Dynamic Wave Solution of SWMM 5?
"Subject:   Link Iterations in the SWMM 5 Dynamic Wave Solution   Each of the links in the SWMM 5 network can use up to 8 iterations to reach convergence during a time step in the dynamic wave solution of SWMM 5.  The rules…"
Sunday
Robert Dickinson left a comment for wu ze jian
Saturday
Robert Dickinson posted a discussion

How is the St Venant Equation Solved for in the Dynamic Wave Solution of SWMM 5?

Subject:   How is the St Venant Equation Solved for in the Dynamic Wave Solution of SWMM 5? An explanation of the four St. Venant Terms in SWMM 5 and how they change for Gravity Mains and Force Mains. The HGL is the water surface elevation in the upstream and downstream nodes of the link. The HGL for a full link goes from the pipe crown elevation up to the rim elevation of the node + the surcharge depth of the node.  The four terms are: dq2 = Time Step * Awtd * (Head Downstream – Head Upstream)…See More
Saturday

Export from WeatherUnderground to InfoSWMM

  • Rating: No Rating

Note: Export from WeatherUnderground using the CSV File Export Option to InfoSWMM


Weather Underground is a site that provides excellent local weather information in the form of graphs, tables and csv files. You can use the data very easily in InfoSWMM by copying from Excel to a time series in InfoSWMM. Here is the rainfall for a storm event in Tampa, Florida in September 11, 2010

Step 1: Export from WeatherUnderground using the CSV File Export Option

Step 2: The data imported from the csv file to Excel and after the text to columns tool is used looks like this in Excel. The data is now ready to be imported into InfoSWMM after the time column is adjusted to fall on even 5 minute intervals. In Excel you can use the formula @ROUND((B2)/"0:05:00",0)*"0:05:00" to round all of the time values to 5 minutes. If you do not do this step then you will have problems in InfoSWMM due to the rainfall interval not being equal to the defined raingage interval.

 

Step 3: You will need to format the new rounded time as a time format for import into a InfoSWMM time series. The time series is created in the operation tab of the attribute browser.

 

Step 4: Open up and make a new time series in InfoSWMM.

 

Step 5: Copy and then paste the date, rounded time column and rainfall column into the InfoSWMM time series columns.

 

Step 6: Make a raingage in the DB Table in InfoSWMM that will use the time series you just made. In the case of the Weather Underground data we will use inches, intensity, a rainfall interval of 5 minutes, time series and the name of the time series. SCF should be 1 for Snow conversion and do not need to include a Filename or Station name as we are not using an external file.

 

 

 

 

 

Views: 48

Tags: Export from WeatherUnderground to InfoSWMM

Comment

You need to be a member of SWMM5 - Stormwater Management Model to add comments!

Join SWMM5 - Stormwater Management Model

© 2012   Created by Robert Dickinson.   Powered by

Badges  |  Report an Issue  |  Terms of Service