innovyze / Open-Source-Support

This repository hosts open code that can be used in Innovyze products that support scripting. This includes Ruby for the UI/Exchange, SQL and other useful stuff. We stand on the shoulders of badgers and penguins.
44 stars 20 forks source link

Not an issue, but an improvement for Chamber and Shaft plan area #18

Open CyberNinjaX opened 6 months ago

CyberNinjaX commented 6 months ago

This is just a suggestion. The file MHHYD.csv has diameter of manhole, so we can calculate the diameter by adding a column in the csv and use the ODIC to the Chamber plan area and Shaft plan area. This alleviate the need of assuming all of them are 4 ft manholes and the need for the SQL_InfoSewer_Manhole_Area.

dfmore commented 5 months ago

Hi @CyberNinjaX , could you point us to the link concerning the script you are using? Thanks

dickinsonre commented 5 months ago

HI I do have a SQL for doing this and we also have a conversion between diameter and area in ICM InfoWorks from InfoSewer Manholes in InfoSewer are always 4 for the most part