InfoWater Boolean & Partial String DB Queries

In InfoWater a user can select network components and related data by creating logical query statements through the DB Query feature. A DB query allows the user to extract a set of records using logical statements on a field (or fields) stored within a specific database. Often used database query statements include boolean fields and searching a string in a field.

How to construct a Boolean DB Query

A Boolean field is intended to store a value of 1 or 0, where 1 corresponds to the term “Yes” and 0 to the term “No”.

InfoWater has built in boolean fields for check valves for pipe attributes and ‘allow overflow’ for tank attributes, nevertheless custom

Boolean fields can be created in the InfoWater information tables for any of the InfoWater feature types:

Continue reading

Share this post!
    Posted in InfoSewer, InfoSWMM, InfoWater | Comments Off on InfoWater Boolean & Partial String DB Queries

    Using Web Map Services (WMS) in InfoWorks ICM, InfoWorks WS Pro and InfoNet

    InfoWorks ICM, InfoWorks WS Pro and InfoNet all support the following Map Controls: ArcGIS Engine, ArcGIS Desktop and MapXtreme. The GIS Layer Control Dialog is used to choose how map layers are displayed on the GeoPlan Window. The dialog is displayed by right clicking on the GeoPlan View and choosing GIS Layer control… from the popup menu.

    As well as supporting the traditional GIS layers associated with ArcGIS and MapInfo, InfoWorks and InfoNet can utilise Map Layers offered up by WMS Servers.  An example would be mapping provided by Open Street Map (www.openstreetmap.org).  This resource provides maps of the world that are free to use under an open licence. Users can connect the GeoPlan view to both remote web servers and LAN servers.

    To utilise WMS you need to know the URL of the Web Map Server. Many of the publicly available server can be found by searching with Google.  For example, one WMS addresses for Open Street Map is http://ows.terrestris.de/osm/service?.  This will provide a colour map, but if you’d like a black & white version, you could try http://ows.terrestris.de/osm-gray/service? instead.

    Here are some examples you might like to experiment with that can all be used free of charge as background layers for your model. As many organisations offer WMS as a free service, they do not always guarantee any continued availability, but most organisations do their best to keep them up and running.  Please let me know if you have a favourite WMS resources and I’ll update this blog.

    Open Street Maps from Terrestris Server
    URL (colour): http://ows.terrestris.de/osm/service?
    URL (b/w): http://ows.terrestris.de/osm-gray/service?

    Open Street Maps from Mundialis Server
    http://ows.mundialis.de/services/service?

    Cached OSM-WMS via MapProxy (Uni Heidelberg)
    URL: http://129.206.228.72/cached/osm?
    URL: http://129.206.228.72/cached/osm?Request=GetCapabilities

    Cached HillShade WMS of Europe via MapProxy (Uni Heidelberg):
    URL: http://129.206.228.72/cached/hillshade?
    URL: http://129.206.228.72/cached/hillshade?Request=GetCapabilities

    In some cases you need the “?” at the end of the links, in others not.  These WMS map layers can be combined with the traditional GIS layers associated with ArcGIS and MapInfo that have always been available in the GeoPlan view.

    Combining MapInfo TAB file and WMS layer from Open Street Map

    Depending on whether you utilise MapXtreme as the map control for the InfoWorks / InfoNet GeoPlan, or if you work directly with ArcGIS Engine / ArcGIS Desktop in the background, the way you access and apply WMS layers will be slightly different. Continue reading

    Share this post!
      Posted in InfoNet, InfoWorks ICM, InfoWorks WS Pro | Tagged , , , , | Comments Off on Using Web Map Services (WMS) in InfoWorks ICM, InfoWorks WS Pro and InfoNet

      What’s New in InfoMaster 8.5?

       8.5

      To quickly answer the question…A LOT!  We here at Innovyze consider 8.5 a major InfoMaster release and are excited to be delivering it to our clients.  InfoMaster is already revolutionizing the way asset management is done, and we think 8.5 is a major step in the evolution of asset management.

      To summarize the main additions to 8.5 include: Continue reading

      Share this post!
        Posted in InfoMaster | Tagged , , , , , , | Comments Off on What’s New in InfoMaster 8.5?

        Using the Environment Agency Real Time Data API in InfoWorks ICM, ICMLive and Infinity System

        The English Environment Agency provide a flood-monitoring API (Application programming interface which allows software to access the data directly) which provides access to near real-time information including measurements of rainfall, water levels and flows.

        Water levels and flows are regularly monitored, usually every 15 minutes. Data is then transferred back to the Environment Agency at various frequencies, depending on the site and level of flood risk. The APIs are provided as open data under the Open Government Licence with no requirement for registration.

        InfoWorks ICM and ICMLive can connect to the Environment Agency flood monitoring API using a Time-Series DataBase (TSDB). Time Series Databases are described in the following blog post:-

        http://blog.innovyze.com/2016/09/26/working-with-time-series-databases-tsdb/

        The TSDBs can then be connected to via a web-browser using the Infinity System software described on the following page:-

        (http://www.innovyze.com/products/infinity_system/)

        In InfoWorks ICM version 8, a new data source type, EA RestAPI, was added which allows connection to the Environment Agency Real Time Data API for the river levels. To set up a connection, the first step is to configure a TSDB data source with a type, EA RestAPI and the server set to environment.data.gov.uk. The data source name can be set accordingly.

        Figure 1: TSDB Data Source Configuration for EA RestAPI data

        Continue reading

        Share this post!
          Posted in ICMLive, InfoWorks ICM, Wastewater | Tagged , , , , , , , , , | Comments Off on Using the Environment Agency Real Time Data API in InfoWorks ICM, ICMLive and Infinity System

          How to simulate a valve operation with InfoSurge

          This procedure below shows how to apply AV (TCV), how to activate it, and how to apply AV (TCV) Operation Change Data, Stem Change Curve.

          1- Select your Valve
          2- Choose 4: Throttle Control Valve for Valve Type
          3- Click Auxiliary Calculator   and select AV Characteristics Curve Generator
          4- Select Gate Valve from Options and Minor Loss from Pipe Data (Wide Open Data) and assign 1 for Minor Loss
          5- Click Compute

          Continue reading

          Share this post!
            Posted in InfoSurge | Comments Off on How to simulate a valve operation with InfoSurge

            Switching map display in InfoWater

            InfoWater is a fully GIS integrated water distribution modeling and management software application. Built atop ArcGIS, InfoWater seamlessly integrates advanced water network modeling functionality with the latest generation of ArcGIS.

            InfoWater Map Display is a frequently-used tool for users to do color-coding and symbol-sizing in the map based on modeling inputs and outputs of all six element types. It can also show pipe flow directions and apply map display settings on domain only.

            In InfoWater Version 12.4, users can save a set of desired map display settings into the Operation tab, and make a switch between different map displays as needed. The following screenshot shows a map display for viewing status and another map display for viewing hydraulic parameters such as pipe flow and pump flow.

            Share this post!
              Posted in InfoWater, InfoWater SA | Comments Off on Switching map display in InfoWater

              Trouble Opening InfoWorks ICM User Interface?

              Have you ever had an issue with opening the InfoWorks ICM software? Either the software becomes unresponsive or worse still the software fails to open. When you shut down ICM, ICM keeps a record of the previously opened geoplan windows. When you re-open the software, the geoplan windows are re-opened for you. This behaviour can be changed under Tools->Options->General and selecting the ‘None’ option under ‘Windows at Startup’.

              Figure 1: Tools->Options->General options to change behaviour of software when opening previously opened windows

              However, if you have not selected this option and the software is failing to open, it is possibly due to the re-opening of the geoplan windows. In this situation, the user can hold down the ‘shift’ key on their keyboard whilst InfoWorks ICM is opening and the software will open without opening the previously opened geoplan windows regardless of the options set.  The user can then access the software and open network geoplans as required.

              This tools is also present for other InfoWorks software (InfoWorks CS/InfoWorks RS/InfoWorks WS etc…).

              Share this post!
                Posted in ICMLive, InfoWorks CS, InfoWorks ICM, InfoWorks RS, InfoWorks SD, InfoWorks WS | Tagged , , | Comments Off on Trouble Opening InfoWorks ICM User Interface?

                Baseline Replacement Cost

                As one can imagine, it’s very difficult to forecast asset management budgets for thousands of underground pipes on a yearly basis. InfoMaster’s Baseline Replacement Cost tool simplifies this forecast to give users an easy to use tool to get an estimate of costs over a period of time. This blog will shed some light on the inputs and outputs in InfoMaster’s Baseline Replacement Cost tool.

                InfoMaster’s Baseline Replacement Cost tool has four main inputs: Install Date, Material, Replacement Cost, and Life Expectancy. The range of years, interest rate, and pipe length are also inputs, but these four main inputs determine whether the tool will be successful and generate results or not. Below are descriptions for each of these four inputs:

                1. Install Date – this is the year the pipe was installed.  The Baseline Replacement Cost tool will pull the year the pipe was installed from the full install date field.  Users can set the field InfoMaster will use as the Install Date field in the Facility and Asset Type Manager.  Pipes missing install dates will be noted in the IM Message window once the tool is run.  If a larger percentage of pipes are missing install dates, the tool will not run successfully.

                Continue reading

                Share this post!
                  Posted in InfoMaster | Tagged , , , , | Comments Off on Baseline Replacement Cost

                  System vs. Project Databases

                  Often when starting an InfoMaster project and even when opening a project you have consistently worked with, the difference between the “System” and “Project” databases can be confusing. Let’s try to shed some light on this possible confusion.

                  When creating a new InfoMaster project from scratch as show in the picture above, users will be asked to select or create a new system database and create a new project database.  The top option is for the system database.  The system database is there to serve just three specific functions. Continue reading

                  Share this post!
                    Posted in InfoMaster | Tagged , , , | Comments Off on System vs. Project Databases

                    Turn any ICM or SWMM model into a forecasting system in 60 minutes with ICMLive/SWMMLive (Includes scripts – for US users)

                    We are now in a time where models no longer sit on the shelf and become out-of-date in between master plans. Improvements in computing resources, software, and weather forecasts allow any model to turn into a real-time forecasting system.

                    ICMLive lets you connect your ICM model to live data streams (and SWMMLive for SWMM models), and then run it on an automated basis on a server to produce forecasts and alerts. Once you have a model, the rest is quite easy. If you’re an InfoSWMM user, you’ll need to export your desired scenario as a SWMM INP text file and import it into SWMMLive.

                    Prerequisites:
                    • InfoWorks ICM or InfoSWMM with a calibrated model
                    • Install ICMLive/SWMMLive, Workgroup Data Server, Live Server, and Data Loader (refer to our Getting Started Document)

                    Continue reading

                    Share this post!
                      Posted in ICMLive, InfoSWMM, InfoWorks ICM, SWMMLive | Comments Off on Turn any ICM or SWMM model into a forecasting system in 60 minutes with ICMLive/SWMMLive (Includes scripts – for US users)