Latest Activity

Robert Dickinson commented on Robert Dickinson's group Stream of Information
"At the Summit of Olympus Mons Credit: G. Neukum (FU Berlin) et al., DLR, ESA From martian orbit, the Mars Express cameras looked down on the largest volcano in the solar system. The result was this stunningly detailed overhead view of the…"
6 hours ago
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…"
20 hours ago
Robert Dickinson left a comment for wu ze jian
23 hours ago
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
23 hours ago
Robert Dickinson added a page to the group Hydraulics
Thumbnail

Force Main Friction Loss in InfoSWMM and the Transition from Partial to Full Flow

Subject:  Force Main Friction Loss in InfoSWMM and the Transition from Partial to Full Flow You can model Force Main friction loss in InfoSWMM using either Darcy Weisbach or Hazen Williams as the full pipe friction loss method (see Figure 1 for the…
yesterday
Robert Dickinson commented on Robert Dickinson's group Hydraulics
yesterday
Robert Dickinson's blog post was featured

SWMM 5 Precipitation Options

Subject:  SWMM 5 Precipitation Options You can have design storms, monitored storms of any length of the time from minutes to centuries, use intensity, volume or cumulative precipitation, use both rainfall and snowfall in the same rain gage depending on temperature, use both time series or external files for the rain gage and have unlimited rain gages with the limitation of one rain gage per subcatchment.  …See More
yesterday
Robert Dickinson posted a blog post

SWMM 5 Precipitation Options

Subject:  SWMM 5 Precipitation Options You can have design storms, monitored storms of any length of the time from minutes to centuries, use intensity, volume or cumulative precipitation, use both rainfall and snowfall in the same rain gage depending on temperature, use both time series or external files for the rain gage and have unlimited rain gages with the limitation of one rain gage per subcatchment.  …See More
yesterday
Robert Dickinson commented on Robert Dickinson's group Stream of Information
"Pacheena Indian Reserve, British Columbia, Canada May. 25, 2012 "
yesterday
Robert Dickinson commented on Robert Dickinson's group Stream of Information
"All the Water on Europa Illustration Credit & Copyright: Kevin Hand (JPL/Caltech), Jack Cook (Woods Hole Oceanographic Institution), Howard Perlman (USGS) Explanation: How much of Jupiter's moon…"
Friday
Robert Dickinson's 2 blog posts were featured
Thursday
Robert Dickinson posted blog posts
Thursday
Robert Dickinson commented on Robert Dickinson's group Water Quality
"URBAN STORMWATER QUANTITY/QUALITY MODELING USING THE SCS METHOD AND EMPIRICAL EQUATIONS† http://onlinelibrary.wiley.com/doi/10.1111/j.1752-1688.1997.tb04093.x/abstract May 24, 2012 Wiley Online Library will be disrupted on 26 May from…"
Thursday
Robert Dickinson commented on Robert Dickinson's group Water Quality
"Hi MeHa,  Here is one good source of data, I also have the SWMM 5 models for the USGS areas. http://www.1000friendsofflorida.org/pubs/stmarksgreen/apend4.asp http://sofia.usgs.gov/publications/ofr/78-324/ofr-78-324.pdf "
Thursday
MeHa commented on Robert Dickinson's group Water Quality
"I want to model WQ of sewers. Can any body provide me a network with real measured calibration files? "
Thursday
MeHa posted a status
"Hello, When designing a sewer system, we consider the Node Flooding and Conduit surcharge in the status report. Is there any guideline which"
Thursday
Quah Soon Tong left a comment for Esther Bergareche Auricenea
"Hi Esther, I am not sure you are the same Esther that was at the United World College in South Wales with me. I am Quah Soon Tong from Singapore. I noticed you are also an engineer. I did Civil Engineering at Cambridge University, but practised as…"
Thursday
Quah Soon Tong is now a member of SWMM5 - Stormwater Management Model
Thursday
Robert Dickinson commented on Robert Dickinson's group Stream of Information
"River Canyon May. 23, 2012 "
Wednesday
Robert Dickinson commented on Robert Dickinson's group Stream of Information
"Litla Dimun, Faroe Islands May. 23, 2012 "
Wednesday

10,000+ subcatchments to be assigned with outlets

  • Rating: No Rating

Hi experts,

I am to assign outlet to some 10,000 sub catchments, manually doing it doesn't seem professional.

Luckily, name of subcatchment is same name of junction (outlet)

i.e.

Subcatcment              Junction

177119                      177119

177123                      177123

177126                      177126

263803                      263803

263806                      263806

These are not in particular sequence but name of subcatchment is always same as of junction.

Any clue

Thanks in advance

Tags: large, nodes, number, outlet, subcatchment

Views: 101

Reply to This

Replies to This Discussion

You can save the SWMM 5 input file to Excel using this tool and then use Excel to populate the OUTLET column

http://www.swmm2000.com/xn/detail/2039064:Note:1021

Please try inp.PINS and select inpTools --> Subcatchments connection

(https://sites.google.com/site/inppins/)

You can also edit inp text file, or even use GIS functions.

Thanks Robert,

It really what I needed - without reading the manual, I was trying each option in the swmm to see if there is way to export the data in excel format.

However, data being too large, excel simply says sorry with this message (This message can appear if:
You are trying to open a file that contains more than 65,536 rows or 256 columns. To fix this problem, open the source file in a text editor such as Microsoft Word. Save the source file as several smaller files that conform to this row and column limit, and then open the smaller files in Excel. If the source data cannot be opened in a text editor, try importing the data into Microsoft Access, and then exporting subsets of the data from Access to Excel.
You are trying to paste tab-delimited data into an area that is too small. To fix this problem, select an area in the worksheet large enough to accommodate every delimited item.
Notes
You can not configure Excel to exceed the limit of 65,536 rows and 256 columns.
By default, Excel places three worksheets in a workbook file. Each worksheet can contain 65,536 rows and 256 columns of data, and workbooks can contain more than three worksheets if your computer has enough memory to support the additional data.)

I tried one more add-on by replacing excel with access. But it says unrecognized data format. phewww

Entering the data in SWMM is made pretty easy with Dr. Rui's inp.PINS (straight from ArcGIS), but adjusting missing data would be simpler in MS Excel directly from SWMM environment.

Thanks again, and look forward if you have got idea about editing large data

Can send you the .INP file which is now 10MB.


Robert Dickinson said:

You can save the SWMM 5 input file to Excel using this tool and then use Excel to populate the OUTLET column

http://www.swmm2000.com/xn/detail/2039064:Note:1021

Thanks Rui for your time and efforts to go through this project,

By using GIS functions and adding fields in attribute files, the sub catchments are now linked with their appropriate outlets. 

Also, rather than, loading all hydrologic and hydraulic parameters (from shp files), I tried one by one and kept running Make.inp and overwriting the same .inp file - it did the job.

Now, fixing the missing data is becoming difficult - as discussed above.

And, exploring GIS to fix the missing data (upstream/downstream elevation of pipes) by interpolation as you advised.

I would discuss in the next meeting if this project could be completed with your collaboration and by taking advantage of your research and accomplishments.

here is the file created

http://www.mediafire.com/?a5u64plrksd3tec

regards,



Rui Daniel Pina said:

Please try inp.PINS and select inpTools --> Subcatchments connection

(https://sites.google.com/site/inppins/)

You can also edit inp text file, or even use GIS functions.



Robert Dickinson said:

You can save the SWMM 5 input file to Excel using this tool and then use Excel to populate the OUTLET column

http://www.swmm2000.com/xn/detail/2039064:Note:1021

Hello Robert,

Here is the .inp file for your review, if you can see how large data can be handled by excel add-on

http://www.mediafire.com/?a5u64plrksd3tec



Robert Dickinson said:

You can save the SWMM 5 input file to Excel using this tool and then use Excel to populate the OUTLET column

http://www.swmm2000.com/xn/detail/2039064:Note:1021

You also use a text editor - strip out the Subcatchment Section and then use use Excel  just on the Subcatchment Section - of course you will then have to use a text editor to paste the altered Subcatchment section back into you SWMM 5 input file.

Thanks Robert it works,

A bit time consuming but still ok

regards

Robert Dickinson said:

You also use a text editor - strip out the Subcatchment Section and then use use Excel  just on the Subcatchment Section - of course you will then have to use a text editor to paste the altered Subcatchment section back into you SWMM 5 input file.

Reply to Discussion

RSS

© 2012   Created by Robert Dickinson.   Powered by

Badges  |  Report an Issue  |  Terms of Service