Category Archives: InfoNet

A Spatial SQL – Selecting Objects from another Table based on their Proximity to a Selection

I’ll use the following example to demonstrate how, with a couple of simple SQL Queries, it is possible to select objects from another table based on their proximity to a current selection of objects. In the following distribution network there … Continue reading

Posted in InfoNet, InfoWorks ICM | Comments Off on A Spatial SQL – Selecting Objects from another Table based on their Proximity to a Selection

How to Untangle A String… A Method to Convert a String to Float.

In this BLOG post I’ll outline a method of converting a value in a text field into a number. So whilst I have what appears to be a number such as 43 or 43.0 or 43.67 in a text field, … Continue reading

Posted in General, InfoNet, InfoWorks CS, InfoWorks ICM, InfoWorks RS, InfoWorks WS | Comments Off on How to Untangle A String… A Method to Convert a String to Float.

Why is the ‘GIS Layer Control’ Unavailable?

When you right click on your GeoPlan, you may notice that your GIS Layer Control option is grayed out and unavailable. To fix this problem, first, make sure that your Map Control is not set to ‘None’ (Tools>Options>GeoPlan). You can … Continue reading

Posted in General, InfoNet, InfoWorks ICM | Tagged , , , , | Comments Off on Why is the ‘GIS Layer Control’ Unavailable?

Running Spatial Queries on a Selection.

A spatial SQL allows users to make selections or carry out other SQL functionality based on how objects are spatially related to each other. Such as where object as lines ‘cross’ each other. If an object is ‘inside’ another such … Continue reading

Posted in InfoNet, InfoWorks ICM | Comments Off on Running Spatial Queries on a Selection.

Innovyze Workgroup Data Server (WDS)

Overview of the Innovyze Workgroup Data Server (WDS) The Innovyze Workgroup Data Server is a server component which manages access to Workgroup databases from InfoWorks ICM and InfoNet Clients. The Data Server is designed to improve the performance and reliability … Continue reading

Posted in InfoNet, InfoWorks ICM | Comments Off on Innovyze Workgroup Data Server (WDS)

Little Gems Of Functionality – Visualising Structural and Serviceability Defect Scores on the Long Section View.

The long section pick tool has always been a great tool, giving users the ability to display one or more pipes in profile. The CCTV Survey Defects can also be displayed along the pipes, which appear as coloured crosses. The … Continue reading

Posted in InfoNet | Tagged , , , , | Comments Off on Little Gems Of Functionality – Visualising Structural and Serviceability Defect Scores on the Long Section View.

Cross Network SQLs – Running an SQL Query Across Multiple Networks

It is possible to run an SQL query across more than one network. This can be achieved by selecting the main menu Tools > Run Query Across Multiple Networks. Let say I am interested in knowing the total length of … Continue reading

Posted in InfoNet | Comments Off on Cross Network SQLs – Running an SQL Query Across Multiple Networks

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

What To Do If You Get ‘Record Not Found In Local Datastore’ Error

Once in a while, when committing changes to a network in InfoWorks ICM or InfoNet , you may receive an error such as this one: There are several reasons why this problem may have occurred. Innovyze has resolved many of these … Continue reading

Posted in InfoNet, InfoWorks ICM | Tagged , , , | Comments Off on What To Do If You Get ‘Record Not Found In Local Datastore’ Error

Dealing With Some Common Invalid Signature Errors

Upon opening InfoWorks ICM or InfoNet or a master database within one of these software platforms, you may encounter an Invalid Signature error preventing you from working in your database. If the error reads something like: INVALID SIGNATURE followed by … Continue reading

Posted in InfoNet, InfoWorks ICM | Comments Off on Dealing With Some Common Invalid Signature Errors