Tag Archives: SQL

Tip & Tricks. Comments in SQLs

Want to make your code understood to colleagues? Want to ignore certain lines whilst developing an InfoNet SQL? A double Backslash ‘\\’ acts as a comment in InfoNet SQL Comments. In computer programming, a comment is a programmer-readable explanation or … 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

InfoWorks WS – Using SQL to compare two simulations

  The SQL tool in InfoWorks can be very powerful in quickly comparing two simulations. In the attached paper a method is described to produce a grid and select links with the estimate of the links that may have a discoloration … Continue reading

Posted in InfoWorks WS | Tagged | Comments Off on InfoWorks WS – Using SQL to compare two simulations