H2OMAP Sewer and InfoSewer DB Queries to find Loading Manholes

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

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  via Blogger http://www.swmm5.net/2013/08/h2omap-sewer-and-infosewer-db-queries.html