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.

SQL for Setting All Link and Node Parameters in an ICM SWMM Network

 SQL for Setting All Link and Node Parameters in an ICM SWMM Network

SQL for Links 

SET conduit_height=1000;

SET conduit_width=1000;

SET length=100;

SET roughness_depth_threshold=0.011;

SQL for Nodes

SET maximum_depth=10;

SET invert_elevation=0.0;

SQL for Setting All Subcatchment Parameters in an ICM SWMM Network

 Here is the SQL dialog - works for both InfoWorks and SWMM Networks in ICM.

SET raingauge_id='RG';

SET catchment_slope=1;

SET infiltration="Curve_number"';

SET area=1;

SET Curve_number=oid;

SET percent_impervious=0;

SET storage_impervious=0.05;

SET storage_pervious=0.20;

SET width=100;

SET percent_routed=100;

SET roughness_impervious=0.013;

SET roughness_pervious=0.10;

SET hydraulic_length=100;

SET decay_factor=7;