SWMM5, InfoSWMM

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.

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 your InfoSWMM 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.

http://swmm5.posterous.com/?sort=&search=infoswmm

you can search for infoswmm, infosewer and of course SWMM 5  Hopefully, this makes them a bit more organized – there are a total of 600 posts as of today, but each post now has labels and multiple tags

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

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 Max.

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