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;