Importing network data using the Open Data Import Centre

A network contains all the information needed to describe the water supply system: the reservoirs, pipes, nodes, valves, pumping stations etc. You can now import some existing data to create your first network. This topic shows you how to import a network of existing data from two sources: GIS files and CSV files. Finally this topic introduces the GeoPlan, a geographical representation of the network, usually displayed over the top of a map.

If you are licensed to use more than one map control, you may want to change the current map control. Please refer to Selecting the map control in the main Help for more details.

This stage assumes that you have started InfoWorks WS Pro and that the Model Group window is open, showing the Newtown icon.

The tutorial dataset uses InfoWorks WS Pro native units (metric units). To import the tutorial data correctly, set the user units to metric by selecting Options from the Tools menu and clicking the Metric (Native) button on the Units tab.

  1. Select Options from the Tools menu and click the Metric (Native) button on the Units tab to ensure that user units are set to metric units. Click OK to close the Options dialog.
  2. Right-click the Newtown icon in the Model Group window and select Import | Network using Open Data Import Centre from the context menu. The New Name - Network dialog is displayed.
  3. Enter a network name, such as 'Newtown Network', and click OK.

    ClosedShow image

    New Name - Network dialog

    The Open Data Import Centre dialog is displayed. ClosedThis dialog will be used to import data from GIS files. You can also use the dialog to import data from a variety of other sources.

    ClosedShow image

    Open Data Import Centre

  4. Check that the Table is set to 'Node' and the Source Type is either 'MapInfo TAB File', 'Raw Shape File', 'ArcView Shape File' or 'Geodatabase layer', depending on your GIS.

    Note: You can also import some data using the CSV format by selecting CSV in the Source Type drop-down list. Once you have imported the example network from GIS data, as per this topic, please refer to the Importing Data from CSV Files / Updating Network with CSV files topic for an example of network update using CSV files.

    IMPORTANT: If you are going to import data in MapInfo Tab File (.tab) format, you must first set the coordinate system.

  5. Click the Dots button button in the Data Source section.  From the Example Data Directory, select Tutorial Files/Import Files/GIS Data.

    ClosedShow image

    Open GIS data

  6. Open the MapInfo directory, click the iw_wnode file and click Open. ClosedThis file contains data that defines the nodes in your network.
  7. Click Auto-Map. ClosedThis button searches the import file for fields that match those that define the nodes in the network.

    ClosedShow image

    ODIC Node

  8. Click Import. The GIS data is imported.
  9. When the data has finished importing, click OK.

    ClosedShow image

    Imported Data confirmation message

  10. Using the Open Data Import Centre again, import the pipe data:
    1. Change the Table To Import Data Into to 'Pipe'.
    2. Change the Data Source to iw_wpipe.
    3. Click Auto-Map.
    4. Click Import.

      ClosedShow image

      ODIC Pipe

    5. Click Import.
    6. When the data has finished importing, click OK on the displayed information message.
  11. Import the other GIS files:
    1. Repeat the steps above for each of the following Table types and files:
      Customer Pointiw_waddr
      Fixed Headiw_wfixh
      Float Valve / Inletiw_wfltv
      Hydrantiw_whyd
      Meteriw_wmetr
      Non Return Valveiw_wnrv
      Pump Stationiw_wpst
      Reservoiriw_wres
      Transfer Nodeiw_wtran
      Valveiw_wvalv
    2. When all files have been imported, click Close. The network is displayed in the GeoPlan window. ClosedThe network object describes the physical aspects of the system.

      ClosedShow image

      GeoPlan Network

  12. The new network has been included in the Newtown model group. Drag the edge of the Model Group window to make the window wider if necessary.

    ClosedShow image

    Dragging the Model Group Window

  13. Update the network with the data in the CSV files:
    1. Right-click the Newtown Network icon (outlined in red) and select Update | From CSV from the popup menu. The Import/Update From CSV Data dialog is displayed. Check that the Block Headers entry is 'IDs'. All data in the database has a data flag, which indicates the source or reliability of the data.ClosedBy default, the Import dialog sets the flag to #V for all imported data. This will allow you to distinguish the CSV data from the existing data.

      ClosedShow image

      Import / Update from CSV Data

    2. Click OK.
    3. From the Example Data Directory, select Tutorial Files/Import Files/CSV Data/Newtown Base Model_pump.csv and click Open.

      ClosedShow image

      Open Pump file in CSV format

      After the data has been imported, the import directory is redisplayed.

    4. Select each of the other three Newtown Base Model files in turn (but do not import Newtown Base Control.csv).
    5. When the last file has been imported, click Cancel. A text report is displayed, showing the results of the update.

      ClosedShow image

      Results of CSV update

    6. Close the window.
  14. Import the control data for the network. ClosedThe control data describes the initial state of the network and the way in which it will be controlled during a simulation.
    1. Right-click the Newtown Model Group icon at the top of the Model Group window and select Import | Control from CSV files.
    2. Click OK.
    3. From the Example Data Directory, select Tutorial Files/Import Files/CSV Data/Newtown Base Control.csv and click Open.
    4. Click Cancel to close the dialog. In the Control dialog, the control name is shown as 'Newtown Base Control'.
    5. Click OK to accept this name. An icon for the control is added to the Newtown model group.

      ClosedShow image

      Control Dialog

      A text report is displayed.

      ClosedShow image

      Results of CSV import

    6. Close the text window.
  15. Set the coordinate system to British National Grid [EPSG 27700].
    • To set the coordinate system, first use Tools | Options to set MapXtreme as the map control on the GeoPlan page of the Options dialog, then, having closed the dialog, select Set coordinate system from the GeoPlan menu to choose British National Grid [EPSG 27700] as the projection.
  16. Commit the new network to the database: ClosedThis process saves the data as your base network.
    1. Right-click the Network icon (with the red exclamation mark) and select Commit changes to master database.
    2. You are asked if you want to validate the network. Click No.
    3. You are shown a summary of the changes and can leave a suitable comment. Type a suitable comment and click OK.

      ClosedShow image

      Check in Comment

  17. Close the GeoPlan view by clicking the Close button in the top right corner of the window.

CSV files format can be used to import data onto a network, either to build a network from scratch or to update it. The Importing data from CSV files / Updating a network with CSV files topic shows you how to update the 'Newtown Network' network.

You can now begin to explore the imported network and investigate the facilities that are available in the GeoPlan view.

Back Back to flowchart