ICM SWMM sw_mesh_level_zone Variable Names for SQL and Ruby Scripts

     The file "opwrowobjectlayoutswmm.xml" is a data file used by the Integrated Urban Water Management Model (ICM) software. The ICM software is used to simulate and analyze the performance of stormwater management systems, including the design and operation of stormwater collection and conveyance systems.

The file "opwrowobjectlayoutswmm.xml" contains variable names specific to the SWMM (Storm Water Management Model) conduit feature in the ICM software. These variable names are used in SQL and Ruby scripts, which are programming languages used to manipulate and analyze the data generated by the ICM software.

These variable names are used to represent the different attributes of a sw_mesh_level_zone within the ICM software and the SQL and Ruby scripts allow users to access and manipulate that data in a variety of ways.

<table name="sw_mesh_level_zone">

<group name="Mesh level zone definition">

polygon_id

area

level_type

use_upper_limit

upper_limit_level

use_lower_limit

lower_limit_level

level_sections

level

raise_by

</group>

<group import_group="gen_prop"/>

<group import_group="user_prop"/>

Table: sw_mesh_level_zone

Group	Column Name
Mesh level zone definition	polygon_id
Mesh level zone definition	area
Mesh level zone definition	level_type
Mesh level zone definition	use_upper_limit
Mesh level zone definition	upper_limit_level
Mesh level zone definition	use_lower_limit
Mesh level zone definition	lower_limit_level
Mesh level zone definition	level_sections
Mesh level zone definition	level
Mesh level zone definition	raise_by
Imports group "gen_prop"
Imports group "user_prop"

A Disturbance in a Water Distribution System

 A disturbance in a water distribution system can be defined as any event that causes a change in the normal flow or pressure conditions within the system. These disturbances can be caused by a variety of situations, such as changes in pump operations, valve movements, boundary pressures, demand conditions, and transmission conditions.

Pump startup or shutdown is one of the most common disturbances in water distribution systems. When a pump is started, it can cause an increase in flow and pressure within the system, which can lead to variations in flow and pressure downstream. On the other hand, when a pump is shut down, it can lead to a decrease in flow and pressure, which can also cause variations in flow and pressure downstream. These variations in flow and pressure can have a significant impact on the overall performance and reliability of the system.

Valve opening or closing can also cause disturbances in water distribution systems. When a valve is opened, it increases the flow area within the system, which can lead to an increase in flow and pressure. On the other hand, when a valve is closed, it decreases the flow area within the system, which can lead to a decrease in flow and pressure. These variations in flow and pressure can also have a significant impact on the overall performance and reliability of the system.

Changes in boundary pressures, such as changes in the level or pressure of reservoirs, tanks, etc. can also cause disturbances in water distribution systems. These changes in boundary pressures can lead to variations in pressure and water quality within the system, which can impact the overall performance and reliability of the system.

Rapid changes in demand conditions, such as hydrant flushing, can also cause disturbances in water distribution systems. Sudden changes in water usage can lead to variations in flow and pressure within the system, which can impact the overall performance and reliability of the system.

Changes in transmission conditions, such as pipe breaks or leaks, can also cause disturbances in water distribution systems. These changes in transmission conditions can lead to variations in flow and pressure, as well as water quality issues within the system.

It is important to note that water distribution systems are complex systems and disturbances in one area can have knock-on effects in other parts of the system. Therefore, it is important to monitor and control the system to ensure stability and reliability.

For the EPS option, doing multi-fireflow is important as it will look for the lowest pressure and report that, instead of just reporting the pressure at a specific hydrant. This allows for a more comprehensive understanding of the system and can help identify potential issues before they become critical.

Surge Tanks

Disturbances in water distribution systems can be caused by various situations, including changes in pump operations, valve movements, boundary pressures, demand conditions, and transmission conditions. These disturbances can result in variations in flow, pressure, and water quality, which can impact the overall performance and reliability of the system. The following table summarizes the different types of disturbances and their potential effects on the system:

Disturbance Type	Description	Potential Effects
Pump Startup/Shutdown	Changes in the operation of pumps in the system	Variations in flow and pressure
Valve Opening/Closing	Changes in the flow area caused by the movement of valves	Variations in flow and pressure
Boundary Pressure Changes	Changes in the level or pressure of reservoirs, tanks, etc.	Variations in pressure and water quality
Rapid Demand Changes	Sudden changes in water usage, such as hydrant flushing	Variations in flow and pressure
Transmission Conditions	Changes in the condition of pipes, such as breaks or leaks	Variations in flow and pressure, water quality

It's important to note that water distribution systems are complex systems and disturbances in one area can have knock-on effects in other parts of the system, so it is important to monitor and control the system to ensure stability and reliability.

 Open surge tanks

Closed surge vessels Bladder tanks Hybrid tanks (vented to admit air) Bypass lines Check valves Feed tanks (provide inflow to prevent cavitation) Air release/vacuum valves (2 and 3 stage valves) Pressure relief valves Surge anticipation valves

Type of Tank	Description	Advantages	Disadvantages
Open Surge Tanks	These tanks are open to the atmosphere and allow the excess pressure to be released.	- They are relatively simple and inexpensive to construct. <br> - They can be used to prevent the water hammer effect.	- They are subject to evaporation and contamination. <br> - They are not suitable for use with hazardous materials.
Closed Surge Vessels	These tanks are sealed and use a compressible gas (such as air) to absorb the excess pressure.	- They can be used with hazardous materials. <br> - They are less susceptible to evaporation and contamination.	- They are more expensive to construct than open surge tanks. <br> - They require regular maintenance to ensure the compressible gas is at the correct pressure.
Bladder Tanks	These tanks use a flexible bladder to separate the water from the compressible gas.	- They are less expensive to construct than closed surge vessels. <br> - They require less maintenance than closed surge vessels.	- They are not suitable for use with hazardous materials. <br> - They have a limited life-span and need to be replaced periodically.
Hybrid Tanks (vented to admit air)	These tanks are similar to closed surge vessels but have a vent to admit air.	- They are less expensive to construct than closed surge vessels. <br> - They require less maintenance than closed surge vessels. <br> - They can be used to prevent the water hammer effect.	- They are not suitable for use with hazardous materials. <br> - They are subject to evaporation and contamination.
Bypass Lines	These lines allow water to bypass the tank and the pump, reducing the pressure surge.	- They reduce the pressure surge. <br> - They are relatively simple and inexpensive to construct.	- They can increase the system head loss. <br> - They can increase the pump energy consumption.
Check Valves	These valves prevent the water from flowing back through the system, reducing the pressure surge.	- They reduce the pressure surge. <br> - They are relatively simple and inexpensive to construct.	- They can increase the system head loss. <br> - They can increase the pump energy consumption.
Feed Tanks	These tanks provide inflow to prevent cavitation.	- They prevent cavitation. <br> - They are relatively simple and inexpensive to construct.	- They can increase the system head loss. <br> - They can increase the pump energy consumption.
Air Release/Vacuum Valves	These valves release or admit air to the system to prevent or correct negative pressures. They can have 2 or 3 stages.	- They prevent or correct negative pressures. <br> - They are relatively simple and inexpensive to construct.	- They can increase the system head loss. <br> - They can increase the pump energy consumption.
Pressure Relief Valves	These valves release the excess pressure to prevent damage to the system.	- They prevent damage to the system. <br> - They are relatively simple and inexpensive to construct.	- They can increase the system head loss. <br> - They can increase the pump energy consumption.
Surge Anticipation Valves	These valves are designed to anticipate and absorb pressure surges in a pipeline.	- They anticipate and absorb pressure surges. <br> - They are relatively simple and inexpensive to construct.	- They can increase the system head loss. <br> - They can increase the pump energy consumption.

ICM SWMM SQL Code for Links

ICM SWMM SQL Code for Links

This creates a table called "links" with the specified columns to store the link variables. The data types of each column are defined as well. Keep in mind that this is just an example, you may have to tweak it to fit your specific use case. Also, you may want to add more columns and constraints depending on your specific needs.

CREATE TABLE links (

  id INT PRIMARY KEY,

  horiz_ellipse_size_code INT,

  vert_ellipse_size_code INT,

  arch_material VARCHAR(255),

  arch_concrete_size_code INT,

  arch_steel_half_size_code INT,

  arch_steel_inch_size_code INT,

  arch_plate_18_size_code INT,

  arch_plate_31_size_code INT,

  conduit_height FLOAT,

  conduit_width FLOAT,

  number_of_barrels INT,

  roughness_HW FLOAT,

  roughness_DW FLOAT,

  top_radius FLOAT,

  left_slope FLOAT,

  right_slope FLOAT,

  triangle_height FLOAT,

  bottom_radius FLOAT,

  shape_exponent FLOAT,

  us_invert FLOAT,

  ds_invert FLOAT,

  us_headloss_coeff FLOAT,

  ds_headloss_coeff FLOAT,

  Mannings_N FLOAT,

  bottom_mannings_N FLOAT,

  roughness_depth_threshold FLOAT,

  initial_flow FLOAT,

  max_flow FLOAT,

  sediment_depth FLOAT,

  av_headloss_coeff FLOAT,

  seepage_rate FLOAT,

  flap_gate INT,

  culvert_code INT

);

);

The file "opwrowobjectlayoutswmm.xml" is a data file used by the Integrated Urban Water Management Model (ICM) software. The ICM software is used to simulate and analyze the performance of stormwater management systems, including the design and operation of stormwater collection and conveyance systems.

The file "opwrowobjectlayoutswmm.xml" contains variable names specific to the SWMM (Storm Water Management Model) conduit feature in the ICM software. These variable names are used in SQL and Ruby scripts, which are programming languages used to manipulate and analyze the data generated by the ICM software.

The variable names in this file include the definition of the conduit, such as the id, us_node_id, ds_node_id and branch_id; as well as the conduit properties, such as the length, shape, shape_curve, transect, horiz_ellipse_size_code, vert_ellipse_size_code, arch_material, arch_concrete_size_code, arch_steel_half_size_code, arch_steel_inch_size_code, arch_plate_18_size_code, arch_plate_31_size_code, conduit_height, conduit_width, number_of_barrels, roughness_HW, roughness_DW, top_radius, left_slope, right_slope, triangle_height, bottom_radius, shape_exponent, us_invert, ds_invert, us_headloss_coeff, ds_headloss_coeff, Mannings_N, bottom_mannings_N, roughness_depth_threshold, initial_flow, max_flow, sediment_depth, av_headloss_coeff, seepage_rate, flap_gate, culvert_code.

These variable names are used to represent the different attributes of a conduit within the ICM software, and the SQL and Ruby scripts allow users to access and manipulate that data in a variety of ways.