Saturday, July 9, 2011

H2OMAP Sewer and InfoSewer DB Queries to find Loading Manholes

Subject:   H2OMAP Sewer and InfoSewer DB Queries to find Loading Manholes

H2OMAP Sewer and InfoSewer DB Queries to find Loading Manholes

by dickinsonre
Subject:   H2OMAP Sewer and InfoSewer DB Queries to find Loading Manholes
This Database Query (DB) will find all loading Manholes with a Load1 and a Load2 greater than 0.  InfoSewer has up to ten possible loads in a Manhole.  You can use the DB Query (Figure 1) to create a Query Report to show all of the Manholes with a non zero loading for both Load1 and Load2.  New Queries can be made to show any combination of the ten Manhole Loadings either by altering the DB Query or creating a new DB Query.
Figure 1. DB Query to find Manholes with Load1 and Load2 greater than 0.0
 Figure 2.  Query Report for the DB Query


No comments:

InfoSWMM Version Numbers and the version of Arc Map they use and which EPA SWMM5 Engine is used for Each InfoSWMM Version

 InfoSWMM Version Numbers  InfoSWMM Version 14.7  Update 3 for Arc Map 10 to 10.8 and Windows 7/8/8.1/10 - EPA SWMM 5.1.014   4/12/2020   ...