Results 1 to 3 of 3

Thread: Longest conduit in a sub-catchment

  1. #1

    Join Date
    Dec 2016
    Posts
    1

    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 ?
    Thanks
    Last edited by Saker; April 21, 2017 at 05:42 AM.

  2. #2
    Forum Moderator

    Innovyze Employee



    Join Date
    May 2015
    Posts
    251
    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.

  3. #3
    Forum Moderator

    Innovyze Employee



    Join Date
    Feb 2013
    Posts
    105
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •