Working with Grids & Property Sheets

This topic examines the grid views, which give you the means to view the data for a group of objects and provides alternative editing methods, and the property sheets, which provide a way of looking at all the data for a single network object in a more structured way.


This stage assumes that you have started InfoWorks ICM and that Master database, containing the ICM Basic Tutorial, is opened in the Explorer window, showing the 'Langley Catchment Study' model group. The 'Langley Network (TUT)' should be open in the GeoPlan.


Grids are accessible either via the Grid windows option in the Window menu,

ClosedShow me

or by clicking (Grid windows) in the Windows toolbar.

ClosedShow me


Examining grid data

You can display a grid of all objects of one type (e.g. all nodes, all links, etc). To do so:

  1. Select the Grid windows option from the Windows menu, and then choose one of the options in the sub-menu (for example, to view all nodes). ClosedYou can also open a grid view by clicking the appropriate toolbar button.

    The grid view is then displayed.

  2. ClosedShow me

  3. Use the scroll bars to move around the grid.
  4. If applicable, click the tabs at the bottom of the window to see objects of different types (e.g. different types of links). ClosedA grid may have several tabs; one for every sub-type of object.

    ClosedShow me

  5. Drag the corners or edges of the window to change its size and shape.
  6. Drag the borders between column headings to change the widths of the columns.
  7. Click to the left of a row to select that object; the object is highlighted on the GeoPlan. Use Ctrl when clicking to select a number of objects; use Shift to select a group of consecutive objects. ClosedYou can open a grid that lists just a group of selected objects. Select the objects on the GeoPlan, then hold down Ctrl as you click the relevant toolbar button or select an option from the Window | Grid Windows sub menu.
  8. Click the button to close the grid view.

Grid manipulation

Freezing columns

To keep a column visible at all times:

  1. Click the column header (to select the whole column).
  2. Right-click the header and choose Freeze Columns from the pop-up menu. ClosedThe border to the right of the frozen column has a thicker line. You can freeze more than one column by selecting multiple columns. The Unfreeze All Columns option restores the columns to their normal state.

Re-ordering columns

To change the display order of the columns:

  1. Change the order of columns by clicking a column header to select it and then drag the header to the left or right. You can select several columns at once by dragging the pointer over the headers.

    ClosedShow me

  2. Click anywhere on the grid so that the columns are no longer highlighted.
  3. Sort the nodes according to ground level by right-clicking the 'Ground Level' column itself (not the header) and choosing the Sort Ascending option from the pop-up menu.

    ClosedShow me

  4. Sort by ground level and then east-west position by clicking the Ground Level column header, Ctrl-clicking the x (m) column header, right-clicking and choosing Sort on Selected Columns Ascending from the pop-up menu.

    ClosedShow me

  5. In the GeoPlan, make a selection of nodes. ClosedTo make a multiple selection, Ctrl-click the required nodes.

    ClosedShow me

    Bring the selected objects to the top of the grid (leaving the others sorted as before) by clicking the (Group Selections) button in the Selection toolbar.

    ClosedShow me

  6. Click to close the grid.

Examples of grid manipulation

Finding columns

Find in the GeoPlan

The (Find in GeoPlan) button on the GeoPlan Tools toolbar was used in another topic to select objects of a particular type. You can do the same using the relevant grid view.

  1. Click on the Selection toolbar to clear the current selection.
  2. Right-click the GeoPlan and select Zoom to network to display the entire network.
  3. Select Window | Grid windows | New link windows.
  4. Select the Weir tab (at the bottom of the dialog). ClosedUse the arrow buttons in the bottom left-hand corner to show different tabs.

    ClosedShow me

  5. Adjust the size and positions of the GeoPlan and grid windows so that you can see both clearly.
  6. Select a weir by clicking to the left of the record. The weir is highlighted on the GeoPlan.

    ClosedShow me

  7. Select all links by clicking to the left of the first record and then Shift-clicking the last record.
  8. Right-click the GeoPlan and choose Zoom to selection from the pop-up menu.

    ClosedShow me

    SQL_Unexpanded Dialog

  9. Click to close the grid.

Applying different rainfall profiles to groups of subcatchments

You can use the Subcatchments grid view to apply different rainfall profiles to groups of subcatchments, for example, you can set up three profiles (which would be associated with three rain gauges) running from west to east across the network. To do so:

  1. Click on the Selection toolbar to clear the current selection, if applicable.
  2. Right-click the GeoPlan and select Zoom to network to display the entire network.
  3. Select Window | Grid windows | New subcatchment windows.
  4. Maximise the grid view.
  5. Find the Rainfall profile column. ClosedRight-click any column heading and select the Find column option from the pop-up menu. In the Find column in grid dialog, select Rainfall profile from the drop-down list, and click OK. The Rainfall profile column is highlighted in the grid.
  6. Move the Rainfall profile column so that it is next to the x (m) column and adjust the column widths. ClosedTo move a column, click the column header so that the column is highlighted, release the mouse button and then drag the column header to left or right.
    To change the width of a column, place the pointer on the divider between this column and the column to the right, then hold down the left mouse button and drag to left or right until the column is the required width.

    ClosedShow me

  7. Sort the grid according to the values in the x (m) column. ClosedRight-click the x (m) column (not the column heading) and select the Sort Ascending option from the pop-up menu.
  8. Select all Rainfall profile cells for the first seven rows. ClosedClick the first Rainfall profile cell (for which the x (m)value is 644181), scroll down to the last relevant cell (with x value of 644269), hold down Shift and click the Rainfall Profile cell.

    ClosedShow me

  9. Right-click the selection and choose Current Cell(s) Value | Set new value(s) for cell(s) from the pop-up menu, and a New Cell Value dialog is displayed.

    ClosedShow me

  10. Enter a value of 1 and click OK.

  11. Right-click again on the selection and choose Flags... then select the flag that indicates edited data. ClosedFor example, select the 'ED' flag
  12. Re-sort the grid on Subcatchment ID. ClosedRight-click the 'Subcatchment ID'' column and select Sort Ascending from the pop-up menu.

    The edited values now show up clearly.

    ClosedShow me

  13. Click to close the grid.

Exporting grid data

It is possible to copy data to an Excel worksheet. For example:

  1. Open a Nodes grid ClosedSelect Window | Grid windows | New subcatchment windows and drag the x (m) and y (m) columns, as described previously, so that they are next to the Node ID column.
  2. Select the three columns so that the data is highlighted.
  3. Press CTRL + C to copy the data. ClosedAlternatively, right-click the highlighted block and select Copy

    A message is displayed.

  4. Click Yes, to confirm copying of column headers.
  5. Open an Excel worksheet and press CTRL + V to paste the data. ClosedUsing this method, you can copy any part of the grid data to Excel. You can also copy data from Excel and paste it into an InfoWorks ICM grid.
  6. Close the Excel worksheet. ClosedNote that you can also copy and paste data between InfoWorks ICM grids and from one network to another.
  7. Click to close the grid.

Property sheets

Property Sheets provide a way of looking at all the data for a single network object in a structured way. They are displayed in the Object Properties Window.

ClosedShow me

To display the Property Sheet for a network object, either use the Properties tool () on the GeoPlan Window to select the appropriate object or click the Object properties window () button on the Docking Windows toolbar.

Alternatively, you can also display the property sheet for a particular object by doubling-clicking the left-most column entry for the required object in a property grid.

ClosedShow me


Back Back to flowchart


Data Flags

Editing Data in the Network Object Grid Window

Nodes Grid

Links Grid

Subcatchments Grid

Object Properties Window