Search:

Is there a way to select the head discharge tables from a selection set of pumps? For example, I would like to be able to select, say, 10 pumps and have SQL return the notes field from the...

When I use the following SQL to insert a node into the table, a data type error occurs.

SET $new_node_id = node_id+"S";
SET $new_x = x+10;
SET $new_y = y+10;

INSERT INTO node (node_id,x,y)...

Thanks Duncan! Your blog post was helpful (http://blog.innovyze.com/2018/05/22/a-neat-ruby-script-to-delete-all-scenarios-other-than-the-base-network/).

Is there a way to modify the script such...

Is there a way to export the scenario names? or definite a variable as a list of all scenarios?

Thanks for the article. I am familiar with it and it is a useful tool for sensitivity analysis and uncertainty modeling.

However, I am more interested in something along the lines of...

LET...

Is there a way to delete multiple scenarios? Possibly in SQL?!

Statistics Template is a good application for model pump runtimes too.


We use a similar query for dual pumpstation starts...


SELECT us_node_id, Duration (tsr.pmpstate>0) WHERE link_suffix =...

Thanks Robert.

Is there a way to modify the Ruby script such that only selected subcatchments are considered?


EDIT:
I think I can do it with...
if (subcatchment['node_id'] == '')

...and...

Is it possible to assign a subcatchment to the nearest manhole?

Has anyone had any luck with H2S modeling in ICM without rainfall events?


So far I'm loading general WQ parameters into the wastewater/trade flow profiles; high BOD contributors as BOD...

Thanks! I did not realize it was buried there

In ICM, is it possible to convert polygon to subcatchments and visa versa?

Thanks. We have discussed using a common results folder for a while now. I just moved our database to a workgroup database (ironically, that's the reason for also changing results folders). We...

Is there a disadvantage to having a common results folder for several users? For example, if John, Jane, and Jim store their simulation results in d:/ICM/Results/ instead of d:/ICM/Results/John/ ......

I created a slow open/close valve using UPC similar to this example (http://blog.innovyze.com/wp-content/uploads/2013/06/UPC-Examples.pdf).

Strangely, the flow doesn't ramp up as the valve opens...

Hello all—

Running Infoworks WS with either the built-in pump controls or UPC, we have issues with "chatter". For example, I have a booster station, upstream are pumps and downsteam is a tank...

We're using 5.0.2.10020 (32 bit) July 2014. I guess their isn't a way to do it pre-version 6.

Is there a way to find the pump runtime during a simulation?

I know that WS has a "duration()" SQL aggregate function that can be used to find the "duration the flow was greater than 0"... Is...

Is it possible to write an SQL query that, for example, would return the average pressure of the selected nodes during 4:00AM and 6:00AM?

I've been experimenting with tsr, but I'm not having any...

I'm having an issue with network data imported from GIS. In several instances, a node will spatially overlay a link and not be connected to it. It's a big problem at loops where the connectivity...

It worked! Thanks again.

Is there a way to automatically populate node elevations based on the ground elevation of a TIN in infoworks WS?

Thanks in advance.