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;