Tag Archives: SQL

A neat Ruby script to delete all scenarios other than the base network

Within InfoWorks ICM, scenarios are a useful way of creating options, testing different network configurations and undertaking sensitivity analysis. However, once created and no longer needed, there is no easy way to delete them en masse. It is possible to … Continue reading

Posted in ICMLive, InfoWorks ICM | Tagged , , , , | Comments Off on A neat Ruby script to delete all scenarios other than the base network

Simplifying the input of Culvert Inlet Parameters with SQL Prompts in InfoWorks ICM

The use of the SQL functionality is subject to a large number of blog posts within our blog pages.  This is because they allow the user to avoid repetitive tasks and automate processes.  One of the SQL functionality which is … Continue reading

Posted in ICMLive, InfoWorks CS, InfoWorks ICM, InfoWorks RS | Tagged , , , , , , , | Comments Off on Simplifying the input of Culvert Inlet Parameters with SQL Prompts in InfoWorks ICM

Using SQL Queries to add Scenarios and Update Object Parameters

There are many blog posts on here highlighting the usefulness and effectiveness of the SQL functionality.  This blog post provides another way to use SQL queries to automatically add scenarios to a network and then to change object parameters within … Continue reading

Posted in InfoWorks ICM | Tagged , , , | Comments Off on Using SQL Queries to add Scenarios and Update Object Parameters

Tip & Tricks. Comments in SQLs

Want to make your code understood to colleagues? Want to ignore certain lines whilst developing an InfoNet SQL? From InfoNet version 17.5 a double Forwardslash ‘//’ acts as a comment in InfoNet SQL Comments. In computer programming, a comment is … Continue reading

Posted in InfoNet, InfoWorks ICM | Tagged , , | Comments Off on Tip & Tricks. Comments in SQLs

Theming Incidents On Time or Date to Display Most Recent

By default the GeoPlan displays all objects, which can lead to a visually busy display. Displaying all objects also incurs a performance cost, the graphics card processor having to render all objects. Consider the following section of a network displaying … Continue reading

Posted in ICMLive, InfoNet, InfoWorks ICM, InfoWorks WS, IWLive, SWMMLive | Tagged , , , | Comments Off on Theming Incidents On Time or Date to Display Most Recent

SQL Prompts and Custom Actions to edit River Reach Parameters in InfoWorks ICM

The SQL or Structured Query Language functionality in InfoWorks ICM is a highly powerful and flexible way to edit a model network properties. A simple SQL which is commonly used when building river reaches is the following to set the … Continue reading

Posted in InfoWorks ICM | Tagged , , , , , , , | Comments Off on SQL Prompts and Custom Actions to edit River Reach Parameters in InfoWorks ICM

SQL to SET the Video Path on a CCTV Survey

The MSCC4 standard specifies that a survey must contain either a VVR (Video volume reference new vol) or VID (Video file) Defect Code. The Video name then appears in the ‘Remarks’ column, see image below. An SQL Can be used … Continue reading

Posted in InfoNet | Tagged , , , , , | Comments Off on SQL to SET the Video Path on a CCTV Survey

Custom Actions

For a while now InfoNet and InfoWorks ICM has had the ability to apply an action to a button that can either float freely on set into the toolbar. These are custom and user actions, the difference between these being … Continue reading

Posted in InfoNet, InfoWorks ICM | Tagged , , , , , | Comments Off on Custom Actions

Theming the differences between two sets of results

Often we wish to see the difference between two sets of results displayed in the GeoPlan. This can easily be done in InfoWorks ICM and InfoWorks WS by using a SQL Theme. In the example below I will be using … Continue reading

Posted in InfoWorks ICM, InfoWorks WS | Tagged , | Comments Off on Theming the differences between two sets of results

SQL Example: Using a background polygon to summarise asset information or simulation results

Recently I had a query asking if it was possible to summarise information based on a polygon loaded as a background layer. The specific information they wanted to summarise was the average pressure from a water supply network in InfoWorks … Continue reading

Posted in InfoNet, InfoWorks CS, InfoWorks ICM, InfoWorks RS, InfoWorks SD, InfoWorks WS | Tagged | Comments Off on SQL Example: Using a background polygon to summarise asset information or simulation results