Generated with sparks and insights from 26 sources

img6

img7

img8

img9

img10

img11

Introduction

  • InfoWorks ICM: InfoWorks ICM is an advanced integrated catchment modeling software used for modeling complex hydraulic and hydrologic network elements.

  • Database Support: InfoWorks ICM supports several database types including Standard (WorkGroup) Database, Standard Standalone Database, SQL Server (WorkGroup) Database, and Oracle (WorkGroup) Database.

  • PostgreSQL: There is no direct mention of PostgreSQL support in the provided documents. InfoWorks ICM primarily supports SQL Server and Oracle for workgroup databases.

  • SQL Usage: InfoWorks ICM implements its own subset of SQL for selecting and updating network objects using specified criteria.

  • SQL Queries: Users can create SQL queries to select, deselect, update fields in objects, and clear selections within the InfoWorks ICM environment.

InfoWorks ICM Overview [1]

  • Definition: InfoWorks ICM is an advanced integrated catchment modeling software.

  • Usage: It is used by small utilities and large enterprise organizations to model complex hydraulic and hydrologic network elements.

  • Collaboration: The software allows for collaborative work in a workgroup environment.

  • Flexibility: It can be used as a standalone product or in a workgroup setup.

  • Data Management: InfoWorks ICM maintains model data in a centralized, multi-user master database.

img6

img7

img8

img9

img10

img11

Supported Databases [1]

  • Standard (WorkGroup) Database: Default database type for InfoWorks ICM, intended for use by individuals and groups of users.

  • Standard Standalone Database: Intended for use by individual users working on a single PC.

  • SQL Server (WorkGroup) Database: Requires an existing Microsoft SQL Server database installation.

  • Oracle (WorkGroup) Database: Requires an existing Oracle database installation.

  • PostgreSQL: No direct support for PostgreSQL is mentioned in the provided documents.

img6

img7

img8

img9

img10

img11

SQL in InfoWorks ICM [2]

  • SQL Subset: InfoWorks ICM implements its own subset of SQL for selecting and updating network objects.

  • SQL Dialog: Users can build SQL queries using the SQL Dialog within the software.

  • Query Types: SQL queries can select objects, deselect objects, update fields in objects, and clear selections.

  • Validation: The syntax of SQL queries can be validated within the SQL Dialog.

  • Execution: Queries can be executed directly from the SQL Dialog, and results can be viewed in a grid format.

img6

img7

img8

img9

img10

img11

Creating SQL Queries [2]

  • Open Network: A network must be open and the current active window.

  • SQL Dialog: Access the SQL Dialog from the menu or toolbar.

  • SQL Page: Select options on the SQL Page for the query.

  • Field Selection: Choose fields from dropdown lists to add to the query.

  • Execution: Validate the syntax and execute the query using the Apply or Run button.

img6

img7

img8

Example SQL Scripts [3]

  • Links: SQL variables for links include oid, us_depth, us_flow, us_froude, us_vel, ds_depth, ds_flow, ds_froude, and ds_vel.

  • Nodes: Key variables include depth, flooding, flow_volume_difference, head, head_class, invert_elevation, lateral_inflow, and more.

  • Subcatchments: Variables include effrain, evapprof, EVAPRATE, max_EVAPRATE, lid_drain, various max_qsurf variables, and more.

  • 1D Results Points: SQL query for 1D Result Points includes depth, flow, froude, max_depth, max_flow, max_froude, and more.

  • SUDS Controls: Variables include control_id, drainagemat_thickness, pave_clogging_factor, soil_conductivity, storage_void_ratio, and more.

img6

img7

Related Videos

<br><br>

<div class="-md-ext-youtube-widget"> { "title": "Practical SQL queries in InfoWorks ICM and InfoWorks WS Pro", "link": "https://www.youtube.com/watch?v=qMMLJh4FCj4", "channel": { "name": ""}, "published_date": "Sep 26, 2023", "length": "" }</div>

<div class="-md-ext-youtube-widget"> { "title": "Using SQL queries to automate processes in InfoWorks ICM", "link": "https://www.youtube.com/watch?v=6Q49nQqHsH4", "channel": { "name": ""}, "published_date": "Jun 20, 2012", "length": "" }</div>