April 21, 2017, 05:25 AM
Longest conduit in a sub-catchment
Is there a way by which i can use SQL selection tool in InfoWorks ICM to select the longest conduit in each and every sub-catchment ?
Last edited by Saker; April 21, 2017 at 05:42 AM.
April 21, 2017, 07:50 AM
Hi Saker, you accidentally posted this question in the water forum. I will move it to the wastewater forum where you will get better response for InfoWorks ICM questions.
April 24, 2017, 04:07 AM
The following SQL will provide the ID and length of the longest conduit.
SELECT oid, max(conduit_length)
It would then depend on how you're defining each subcatchment.