How to Import the SWMM 5 Report File as a Layer in infoSWMM

Subject:  How to Import the SWMM 5 Report File as a Layer in InfoSWMM

How to Import the SWMM 5 Report File as a Layer in infoSWMM

by dickinsonre
Subject:  How to Import the SWMM 5 Report File as a Layer in infoSWMM
 The idea of this blog of note is to show how one may extract information from the SWMM 5 or InfoSWMM RPT file and import the Excel  File as a feature in InfoSWMM. This blog has an example Excel file to illustrate the linkage. The steps are:
 Step 1:  Copy the whole row  from Conduit Summary from the InfoSWMM Browser
Step 2:  Add the two columns length and  slope from the Link Summary Table and the InfoSWMM Browser
Step 3:  You need a few calculations based on the table values from SWMM 5 to estimate the CFL  time steps in the .
Step 4:   Add the Excel Spreadsheet as a layer in InfoSWMM – the Named Rangeshould be added to insure valid numbers and not Nulls after the join
Step 5:  You can now plot the CFL Time Step for the Links using the Layer Properties command in Arc Map
  Step 1:  Copy the whole row  from Conduit Summary
 
 Step 2:  Add the two columns length and  slope from the Link Summary Table



Step 3:  You need a few calculations based on the table values from SWMM 5 to estimate the CFL  time steps.

The CFL Step      = Length / (Full  Velocity + (Gravity * Full Depth)^0.5)
Full Velocity        = Full Flow / Full  Area

You also need to create a Name A Range for you data so that the data does not show up as Nulls

 Step 4:  Add the Excel Spreadsheet as a layer in InfoSWMM – the Named Range should be added
 
 Step 4:  Join the Excel  Table to the InfoSWMM Conduit Feature Layer
 
 Step 5:  You can now plot the CFL Time Step for the Links using the Layer Properties command in Arc Map



Comments

Post a Comment

Popular posts from this blog

Water Analogies for Divergence, Curl and Gradient

Image
Comment: A really nice water analogy for the field properties Divergence, Curl and Gradient from the Blog Starts With a Bang

....it's pretty mathematically intensive, but what's missing from most textbooks and E&M courses are physical explanations of what the mathematics means. For instance, I've started teaching about fields, and pretty much every textbook out there goes on and on about the properties of fields. They say you can do three things to fields, take the gradient, divergence, orcurl of them. (Are you asleep yet? I'm sorry!) What do these things mean? An easy way to picture it is in terms of water. If you placed a drop of water anywhere on, say,Earth, the magnitude and direction of how it rolls down is the gradient of the Earth's elevation. If you let that drop of water flow, as it goes downhill, it can either spread out or converge to a narrower stream. When we quantify that, that's what the divergence of the field is. And finally, when that water is …
Read more

Soffit Level

Image
Soffit Level
(pipe technology)The top point of the inside open section of a pipe or box conduit.
The soffit is the highest point of the internal surface of a pipe or culvert at any cross-section. The soffit is also referred to as the pipe obvert.
So it is not quite the Crown of the Pipe.  Here is an image I found that hopefully explains it better.


Read more

SWMM 5 Error Messages

Engine Error Number Description ERROR 101: memory allocation error.                                                                                             ERROR 103: cannot solve KW equations for Link                                                                                   ERROR 105: cannot open ODE solver.                                                                                              ERROR 107: cannot compute a valid time step.                                                                                     ERROR 108: ambiguous outlet ID name for Subcatchment
Read more