Saturday, December 8, 2012

How To Make HTML Code for Excel Spreadsheets

How To Make HTML Code for Excel Spreadsheets
Tabelizer Program for Converting Speadsheets to HTML Code
Copy your Speadsheet to this link http://tableizer.journalistopia.com/ and then tabelize it and copy the html and css code to a blog or other online comments box,  

InfoSWMMH2OMAP SWMMUS EPA
Titles Y Y Y
Options Y Y Y
Files Y Y Y
Raingages Y Y Y
Temperature Y Y Y
Evaporation Y Y Y
Subcatchments Y Y Y
Infiltration Subareas Y Y Y
3 Types of Infiltration Per Subcatchment Y Y N
Aquifers Y Y Y
Groundwater Y Y Y
Snowmelt Y Y Y
Junctions Y Y Y
Outfalls Y Y Y
Storages Y Y Y
Dividers Y Y Y
Conduits Y Y Y
Pumps Y Y Y
Orifices Y Y Y
Weirs Y Y Y
Outlets Y Y Y
Cross Section Shapes Y Y Y
Dual Drainage Outlets Y Y N
1D - 2D Connections Y N N
HEC-22 Inlets Y Y N
Transects Y Y Y
Losses Y Y Y
Controls Y Y Y
Pollutants Y Y Y
Landuses Y Y Y
Buildup Y Y Y
Washoff Y Y Y
Coverage Y Y Y
Inflow Y Y Y
DWF Y Y Y
Patterns Y Y Y
RDII Y Y Y
Unit Hydrographs Y Y Y
Loading Y Y Y
Treatment Y Y Y
Curves Y Y Y
Time Series Y Y Y
Reports Y Y P
Coordinates Y Y Y
Vertices Y Y Y
Polygons Y Y Y
Labels Y Y Y
Symbols Y Y Y
Backdrop Y Y Y
Tags Y Y Y
Profiles Y Y Y
Map Y Y Y
LID Controls Y Y Y
LID Usage Y Y Y
LID Reports Y Y P
LID Graphs Y Y N
Calibration Data Y Y P
Scatter Graphs Y Y Y
Mixed Graphs Y Y N
SWMM 5 Engine Up to Date Y Y Y

Friday, December 7, 2012

Global Dry Weather Flow Reduction in InfoSWMM and H2OMAP SWMM

Global Dry Weather Flow Reduction in InfoSWMM and H2OMAP SWMM

A cool tip to reduce the overall dry weather flow in InfoSWMM and H2OMAP SWMM without changing the mean dry weather flow is to do the following:

1.       Make a Reduction or Increase Flow Pattern in the Operations tab of the Attribute Browser (2),
2.      For example, if we want to have 85 percent of the flow use a value of 0.85
3.      In the Node DWF DB Table (2) use the pattern just created (3)
4.      All of the flows in the DWF table and during your simulation will be reduced by 15 percent.


Saturday, December 1, 2012

InfoSWMM 2D Report Variables

InfoSWMM 2D Report Variables

InfoSWMM 2D Report Variables

by dickinsonre
InfoSWMM 2D Report Variables

The Junction Graph variables for 2D Depth, 2D Speed, 2D Froude Number, 2D Unit Flow, 2D Inflow, 2D Volume and 2D Angle for a InfoSWMM 2D simulation for up to 1000 years can be plotted in the Report Manager of InfoSWMM.  This is an image of the 2D inflow over a 10 year period (A), all seven graph variables (B) for the mesh triangle associated with the 1D node (C).  The 2D inflow is + for flow out of the node to a mesh triangle and – for flow from the mesh triangle to the  1D junction.


Tuesday, November 27, 2012

Grupo de Apoyo para usuarios de SWMM (SWMM in Spanish/ SWMM en Español)

There is a Google Group for Hispanic SWMM5 users around the world that has a lot of good discussions and more importantly help for your SWMM5 modeling.   You can easily join if you use GMAIL or Google+   The link is https://groups.google.com/forum/?fromgroups#!forum/swmm-espanol

Sunday, November 25, 2012

Siphon Modeling in InfoSewer and Arc Map

Siphon Modeling in InfoSewer and Arc Map

Siphon Modeling in InfoSewer and Arc Map Atrribute Display

by dickinsonre
Siphon Modeling in InfoSewer and Arc Map

Here is a typical view of  a siphon in InfoSewer, the rising links have a d/D of 1 and the dropping links typically have a d/D value less than 1.  The q/Q for the rising links is based on the slope and the dropping links typically have a q/Q less than 1 as the full flow is high due to the steep slopes.  You can show both the d/D and q/Q values in an Arc Map Display by using the following code.  I find it easier to first plot one variable using the InfoSewer Map Display followed by editing the TOC Properties for Pipes to show more than one variable at a time in the Label properties.

Function FindLabel ([D_OVER_D],  [Q_OVER_Q] )
If IsNull([D_OVER_D]) then Exit Function
FindLabel ="" &  FormatNumber([D_OVER_D],3) & "  d/D "  & "" &  FormatNumber([Q_OVER_Q],3) & " q/Q"
End Function

Saturday, November 24, 2012

SWMM 4 and SWMM 5 St. Venant Solutions Contrasted

SWMM 4 and SWMM 5 St. Venant Solutions Contrasted

SWMM 4 and SWMM 5 St. Venant Solutions Contrasted

by dickinsonre
SWMM 4 and SWMM 5 St. Venant Solutions Contrasted

1. Compute at time t+delta t the values of dQ/dt for the Links and dH/dt for the Nodes from the properties at time t
2 Iterate at least 2 times until either all nodes and links are converged or a maximum of 8 iterations are reached
3. Use the values of Q and H at time t+delta t for the new time step

The SWMM5 Solution for Flow and Depth at each time step.  The new depth and new flow is always based on the old depth and old flow and normally converges fast as the flow is gradually varied.   The solution is iterative and implicitly uses the new depth and flow at each iteration.

The SWMM4 Solution for Flow and Depth is solved Explicitly at each time step.  The new depth and new flow is always based on the old depth and old flow and and a half and full time step during the time step.




The SWMM 4 Dynamic Wave Solution for ISOL=0

The SWMM 4 Dynamic Wave Solution for ISOL=0

The SWMM 4 Dynamic Wave Solution for ISOL=0

by dickinsonre
The SWMM 4 Dynamic Wave Solution for ISOL=0

The attached PDF file is a copy of the Extran 3 solution in the  SWMM 4 manual explaining the ISOL=0 solution in SWMM 4 / Extran 4.  The current SWMM 5 solution in its dynamic wave solution is an adaptive time step iterative solution of the ISOL=0 solution in SWMM 4.

The SWMM 4 Dynamic Wave Solution

The SWMM 4 Dynamic Wave Solution


The SWMM 4 Dynamic Wave Solution

by dickinsonre
The SWMM 4 Dynamic Wave Solution
The attached PDF file is a copy of Appendix C of the SWMM 4 manual explaining the three St Venant solutions in SWMM 4 / Extran 4.  The current SWMM 5 solution in its dynamic wave solution is an adaptive time step iterative solution of the ISOL Zero solution in SWMM 4.

Friday, November 23, 2012

Continuous Simulation using SWMM 5 LID and Groundwater Features in a Linked 1D/2D Network using InfoSWMM 2D for a 50 Year Period

Continuous Simulation using SWMM 5 LID and Groundwater Features in a Linked 1D/2D Network using InfoSWMM 2D for a 50 Year Period

Continuous Simulation using SWMM 5 LID and Groundwater Features in a Linked 1D/2D Network using InfoSWMM 2D for a 50 Year Period

by dickinsonre
Continuous Simulation using SWMM 5 LID and Groundwater Features in a Linked 1D/2D Network using InfoSWMM 2D for a 50 Year Period
A poster at the recent ECI conference on the Past, Present and Future of Watershed modeling.

The Structure of InfoSWMM in Arc Map

The Structure of InfoSWMM in Arc Map

How to Create an InfoSWMM model from CSV Files, Alternate Method

How to Create an InfoSWMM model from CSV Files, Alternate Method


How to Create an InfoSWMM model from CSV Files, Alternate Method

by dickinsonre
How to Create an InfoSWMM model from CSV Files, Alternate Method

An InfoSWMM model can be newly created from a CSV file but it helps to have an idea of the maximum extents before you initialize the Arc Map project.  Use the ArcGIS default and Edit the extents of your future imported network (Figure 1).  Import the CSV files (Figure 2) and define the imported variables (Figure 3) followed by an Update Map from DB (Figure 4) which will draw your imported nodes and links on the Arc Map screen.  The updated Map should be within the extents of your defined spatial reference (Figure 5).  It is important to have the proper spatial reference for your imported data in Arc Map.  If you do not have the proper extents then when you update the Map from DB you will have a warning message "The coordinates or measures are out of bounds". 

Figure 1.  Import a background shape file and initialize your InfoSWMM map to the coordinates of the shapefile.


Figure 2.  Import a CSV file for both pipes and nodes using the Import Manager of InfoSWMM

Figure 3.  Set up the Field Mapping between the CSV parameters and the Node and Link Parameters of InfosWMM.

Figure 4.  Update the Map from the DB tables you just imported using the command Force All Network.
Figure 5.  The imported model has the same coordinates as the original imported shapefile.


Thursday, November 22, 2012

How to Create an InfoSWMM model from CSV Files

How to Create an InfoSWMM model from CSV Files

How to Create an InfoSWMM model from CSV Files

by dickinsonre
How to Create an InfoSWMM model from CSV Files

An InfoSWMM model can be newly created from a CSV file but it helps to have a background map or shapefile to initialize the Arc Map project.  BEFORE initializing yourInfoSWMM map Add a data layer using the Arc Map command Add Data.   Create a new InfoSWMM project using the same spatial reference as your added shapefile (Figure 1).  Import the CSV files (Figure 2) and define the imported variables (Figure 3) followed by an Update Map from DB (Figure 4) which will draw your imported nodes and links on the Arc Map screen.  The updated Map will have the same coordinates as the background shapefile (Figure 5).  It is important to have the proper spatial reference for your imported data in Arc Map.

Figure 1.  Import a background shape file and initialize your InfoSWMM map to the coordinates of the shapefile.


Figure 2.  Import a CSV file for both pipes and nodes using the Import Manager of InfoSWMM

Figure 3.  Set up the Field Mapping between the CSV parameters and the Node and Link Parameters of InfosWMM.

Figure 4.  Update the Map from the DB tables you just imported using the command Force All Network.

Figure 5.  The imported model has the same coordinates as the original imported shapefile.



  





How to Search My Blogs by concentrating on one blog for Information about SWMM5, InfoSWMM and InfoSewer

How to Search My Blogs by concentrating on one Blog:   I have spent a lot of time in the last week redoing all of my tags, names and websites.   You can search SWMM5.NET or SWMM5.ORG for information on infoswmm, infosewer and of course SWMM 5  Hopefully, this makes them a bit more organized – there are a total of 900 posts as of today, but each post now has labels and multiple tags

The site http://www.swmm5.net/  has a built in Google Custom Search Engine which as even more flexibility



How to Save Node and Link Relates in H2OMAP SWMM to Shapefiles

How to Save Node and Link Summary Tables in H2OMAP SWMM to Shapefiles

How to Save Node and Link Summary Tables in H2OMAP SWMM to Shapefiles

by dickinsonre
How to Save Node and Link Summary Tables in H2OMAP SWMM to Shapefiles
The export manager of H2OMAP SWMM is very flexible, you can export shape, MIF and CSV files but you have to do some copy and pasting to allow the program to export ALL of the node and pipe summary tables.  The export manager will export any node or pipe information in the DB hydraulic and information tables.  If you copy and paste, for example, the output pipe summary table to the Pipe information tables (Figure 1) then you can use the Export Manager (Figure 2) to save the shape file with tables(Figure 4) and view the shape file in Arc Map (Figure 4).  The TOC properties in Arc Map can be used to show the maximum d over D or maximum Q over Qfull values in Arc Map using this VBScript.
Function FindLabel ( [DOVEMAXD] )
  FindLabel = "" & FormatNumber([DOVEMAXD],2) & ""
End Function
Figure 1.  Copy and Paste the Pipe Summary information from the Output Tables to the Pipe Information  Tables.
Figure 2.  Select a link Shapefile using the Export Manager
Figure 3.  Save the Link Information and other data to a shape file.
Figure 4.  The created shapefile added to Arc Map and displayed using the Layer Properties of Arc Map

How to Use the Output Relate in Excel using H2OMAP SWMM

How to Use the Output Relate in Excel using H2OMAP SWMM

How to Use the Output Relate in Excel usingH2OMAP SWMM

by dickinsonre
How to Use the Output Relate in Excel using H2OMAP SWMM
You have to perform the following steps:
1.       Make an Output Relate (using the Operations Tab of the H2OMAP SWMM Browser) which will be the same as the Pipe Summary Table in the Output Report Manager
2.      Run the model to make the Output Relate and then update the Relate (Figure 1)
3.      Using Windows Explorer navigate to the HSDB folder of your H2MAP SWMM project
4.      Continue to the Relate Subfolder and open up the Relate DBD file in Excel (Figure 2)
5.      You cannot SAVE this file but you can save is as a new Excel File
Figure 1.  Output Relate in H2OMAP SWMM to use the Pipe Summary Table
Figure 2.   How to Use the Output Relate in Excel

Tuesday, November 20, 2012

Annual International Conference on modeling urban water systems, Feb 21-22 2013 in Toronto - call for papers

Annual International Conference on modeling urban water systems, Feb 21-22 2013 in Toronto - call for papers

My note, this is a conference well worth attending, the Convenor is Dr Bill James and the venue is described at the CHIWater link shown below.

Once again it's the time to request one or more abstracts for the Annual International Conference on the Modeling of Urban Water Systems (formerly SWMM users meeting), to be held Feb 21-22 2013 in Toronto (note the venue). As you probably know, this is the 46th (!) meeting in this extraordinary series. This year our featured speakers include many well-known scientists, researchers and engineers (listed on our website).
The meeting is well attended: your audience exceeds 100 folks in your specialty. Also, the meeting is inexpensive, highly-regarded, professional, friendly and collaborative. Proceedings are produced as a peer-reviewed, integrated archival-quality book (you get the previous year's monograph at this conference, two-for-one value). The conference addresses all aspects of urban water systems, including planning, design, construction, operation, monitoring, models, safety, and security; how to manage urban water systems including water supply, drainage, pollution control, domestic, municipal, and industrial waters and stormwater from surface water catchments or ground water; and real-time control along with education, outreach, and practical applications. We welcome abstracts in any and all of the following general categories:; LIDs and BMPs; TMDLs; Urban water disasters, Urban flood management, Land Use; Nonpoint Sources of Pollution; Pavement; Pathogens; Stormwater and Urban drainage; Potable Water Supplies; Water distribution; Water System utilities; and other management and socio-political issues. Although the discussion is generally technical, it meshes well with management and difficult topics connected to urban water and related to computer modeling. Please visit:

http://www.chiwater.com/Training/Conferences/conferencetoronto.asp
Please email your 1-page abstract(s) to me in the next week or so. Alternatively, if you need a more formal invitation or a flyer, let me know.  We look forward to seeing you and your colleagues in Toronto - you won't get a better deal in these economically-challenged times!


AI Rivers of Wisdom about ICM SWMM

Here's the text "Rivers of Wisdom" formatted with one sentence per line: [Verse 1] 🌊 Beneath the ancient oak, where shadows p...