InfoNet SQL – Notes Field, Adding a Return Carriage Character (New Line)

Quick one… Let’s say I want to add to my notes field and start a new paragraph. How do I do this?

Well I would need to familiarise myself with be the use of NL() function, which returns a new-line character.

For example, to set up a three line note field:

SET notes = ‘Set’ + NL() + ‘new’ + NL() + ‘line’

Writing to Notes, Including a Return Carriage Character

Writing to Notes, Including a Return Carriage Character

Results in Notes Field

Results in Notes Field

And so to add to existing notes try the following:

SET notes = notes + NL() + ‘Set’ + NL() + ‘new’ + NL() +’line’

SQL to add to existing Notes field

SQL to add to existing Notes field

Share this post!
    Posted in InfoNet | Comments Off on InfoNet SQL – Notes Field, Adding a Return Carriage Character (New Line)

    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 a 2D mesh but it could be pressure at a node, or flow in a conduit.

    Step 1: With a set of results already open Right Click on the second set of simulation results and Open As

    Step1

    Step 2: Select As Alternate Results For Comparison
    Note that the header bar shows that both simulations are open in the same GeoPlan view.  Also note that for this particular theme the mesh needs to be the same in each simulation.

    Continue reading

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

      Categorize your CCTV Inspection Data Fields for easy review with InfoMaster

      InfoMaster is a NASSCO Certified Asset Management software for PACP/MACP/LACP data (in addition, the MSCC, EN 13508-2, WSA-05, and New Zealand standards are supported). As such, InfoMaster handles all required fields from a given survey. However, perhaps there are only a few fields that matter to you the most when reviewing or analyzing your CCTV data in InfoMaster. Our interactive data table lets you customize which fields are visible, group fields together, and expand/collapse these groups to simplify your tabular view and enhance the overall viewing capabilities of CCTV data in InfoMaster in tandem with the 3-D internal view.

      Simply click the “Edit Fields” button on the Inspections tab…

      1

      And you can go from this:

      Continue reading

      Share this post!
        Posted in InfoMaster | Tagged , | Comments Off on Categorize your CCTV Inspection Data Fields for easy review with InfoMaster

        The Next Frontier: Representing Groundwater Interactions in InfoWorks ICM – User Case Study

        A case study has been written by one of our clients that shows how their modellers have used InfoWorks ICM functionality to represent the interaction of groundwater flow with their integrated InfoWorks ICM model network. The paper was originally presented at CIWEM’s ‘Surface Water Management’ 2014 conference and the British Hydrological Society’s ‘Groundwater Extremes and Surface Water Impacts’ conference. The paper is available on the Innovyze website at the following link:-

        http://www.innovyze.com/news/1615/The_Next_Frontier:_Representing_Groundwater_Interactions_in_InfoWorks_ICM

        The case study describes a novel approach to linking groundwater representation with an integrated sewer model in chalk-dominated region for a study for Southern Water and West Sussex County Council. This formed the basis for simulating design storms with appropriate antecedent conditions.

        Our thanks to the case study authors, Adam Cambridge, Senior Consultant, and William Rust, Assistant Hydrologists both from Atkins, UK for sharing this case study with us. If you have a case study or an interesting project which utilises Innovyze software, such as InfoWorks ICM, which you would like to share with others users, please let us know.

        Share this post!
          Posted in InfoWorks CS, InfoWorks ICM | Tagged , | Comments Off on The Next Frontier: Representing Groundwater Interactions in InfoWorks ICM – User Case Study

          Representing Bridge Losses within InfoWorks ICM

          Introduction

          Bridges in ICM are dealt with differently to the empirical Arch Bridge (HR Wallingford, 1988) and US BPR Bridge (US Federal Highway Administration, 1978) approaches in Infoworks RS. The approach in ICM has much more in common with the approach used in HECRAS (USACE, 2008) and also described in the Afflux Estimation System (DEFRA/Environment Agency, 2007). The approach is considered to be much more physically meaningful than the empirical approaches derived from limited experimental data. This blogs provides a description of the types of losses that can be represented within Infoworks ICM.

          Bridge Losses

          There are a number of different losses which can be represented in ICM bridge links.  These are:-

          Continue reading

          Share this post!
            Posted in InfoWorks ICM, InfoWorks RS | Tagged , , , , , , , , , | Comments Off on Representing Bridge Losses within InfoWorks ICM

            ArcGIS and ArcEngine 10.3 are now supported by InfoWorks and InfoNet

            For customers who use ESRI ArcGIS or ArcEngine version 10.3, these products are now supported by InfoWorks and InfoNet. In order to use ArcGIS or ArcEngine 10.3 you will need to download the latest patch from our website.

            The patches required are:

            • InfoWorks ICM               5.5.5
            • InfoWorks ICM SE         5.5.5
            • ICMLive                           5.5.5
            • InfoNet                           15.5.5
            • InfoWorks WS               15.5.3
            • IWLive                            15.5.3
            • InfoWorks RS                15.5.3
            • InfoWorks CS                15.5.3
            • InfoWorks SD                15.5.3

            These patches are now available to download from the product updates section of our website for all supported customers.

            Note that earlier versions of these products will not recognise ArcGIS 10.3 installations and will generate the following error message: “ArcGIS Licence Error: ArcGIS product not installed”.

            Share this post!
              Posted in ICMLive, InfoNet, InfoWorks CS, InfoWorks ICM, InfoWorks RS, InfoWorks SD, InfoWorks WS, IWLive | Comments Off on ArcGIS and ArcEngine 10.3 are now supported by InfoWorks and InfoNet

              Copying SQLs from an Internet Browser into InfoNet. Error Message: Error Parsing Query: Invalid Character at Start Of Token ‘‘’

              Copying SQL syntax directly from an internet browser (Windows Internet Explorer, Google Chrome, Mozilla Firefox etc.) into an SQL dialog box in InfoNet will return an error when the user attempts to test or to run the query. Error messages similar to the following are returned.

              ErrorMessage

               

              Continue reading

              Share this post!
                Posted in InfoNet | Comments Off on Copying SQLs from an Internet Browser into InfoNet. Error Message: Error Parsing Query: Invalid Character at Start Of Token ‘‘’

                Setting Antecedent Wetness Conditions for the New UK Runoff Model in InfoWorks ICM

                Initial NAPI Values in InfoWorks ICM

                Initial NAPI Values in InfoWorks ICM

                In the New UK runoff model was calibrated against a variety or urban catchments in the UK. It uses a value of the antecedent wetness conditions (NAPI) which can vary depending on the soil type. The soil type is defined as part of the subcatchment data or as part of the user defined defaults. In the UK, the soil type classification is derived from Maps. There are 5 different soil types although commonly soil type 5 is not used. The soil type effects the value of a constant which is used in the calculation of NAPI. It is common to set an initial value of NAPI which as above can vary depending on the soil type.

                A feature of InfoWorks ICM which has been inherited from InfoWorks CS and its predecessor HydroWorks, is that it is only possible to use one value of NAPI with any one rainfall profile. This is a problem in catchments with different soil types where a different value of NAPI is needed for each soil type. This blog describes how it is possible to represent the effect of different soil types on NAPI values within subcatchments.

                Download Paper Initial NAPI Values in InfoWorks ICM

                Share this post!
                  Posted in InfoWorks CS, InfoWorks ICM | Tagged , , , , , , , , , , , , , | Comments Off on Setting Antecedent Wetness Conditions for the New UK Runoff Model in InfoWorks ICM

                  Creating Baseline Replacement Cost Graph in InfoMaster using previous failure data (via InfoMaster’s Reliability Analysis tools to estimate pipe lifetimes)

                  First, establish expected lifetimes of your pipes. This can be achieved by many different means in InfoMaster, some available options are:

                  • Reliability Analysis – incorporating statistical models (Cox, LEYP, Herz, Weibull, NHPP…)
                  • Likelihood of Failure – incorporating any data you have available, be it GIS layers or ODBC tables

                  InfoMaster can perform a variety of different complex statistical deterioration models. Though these models are extremely complex mathematically, all the user needs to do is to specify install dates for pipes (when the pipes ‘began their life’) and specify criteria that defines which pipes have reached the end of their useful life, be it that the pipes have had previous failures, or based on age, material, or any other criteria. The InfoMaster tools will take that data from a sample-size of the network and scale the statistical results to the whole system.

                  Pipe Reliab

                  Continue reading

                  Share this post!
                    Posted in InfoMaster | Comments Off on Creating Baseline Replacement Cost Graph in InfoMaster using previous failure data (via InfoMaster’s Reliability Analysis tools to estimate pipe lifetimes)

                    Modelling Variable Speed Pumps in InfoWorks ICM and CS

                    InfoWorks ICM and CS have a number of different ways to model pumps. The two most commonly used are:

                    • Fixed Pumps (a simplistic method where the discharge is independent of the head on the pump) and
                    • Rotodynamic Pumps (where a head-discharge curve is used to determine the flow rate of the pump, but there is no speed control of the pump).

                    Variable Frequency Drive Pumps allows the user to change the speed of a rotodynamic pump by use of an Real Time Control (RTC). These are not to be confused with the Variable Speed Pump – which regulates discharge, and not speed of the pump.

                    Step 1: Create the model and include the pump as type VFDPump.

                    PumpDetails

                    Continue reading

                    Share this post!
                      Posted in InfoWorks CS, InfoWorks ICM | Comments Off on Modelling Variable Speed Pumps in InfoWorks ICM and CS