Exporting summary data

00:04

Info

00:04

works. WS pro allows you to export both time varying data, TVD and summary data

00:12

summary data provides a summary of the time varying

00:15

data such as maximum minimum and average values.

00:20

This can be useful for exporting large numbers of objects. For comparison.

00:24

In this example,

00:26

you will export a summary report of the average minimum and

00:29

maximum pressure values for a selection of customers to CSV,

00:34

create a folder on your desktop and name it results.

00:39

This is where you will save the results of this exercise.

00:43

Open a completed run with results by dragging the simulation into the workspace

00:49

zoom into a part of the network populated with customer points

00:54

with the polygon select tool active,

00:56

draw a polygon around several customer points.

01:00

It is acceptable if the selection includes other objects

01:04

from the selection tab click SQL,

01:07

select to open the SQL

01:09

dialog,

01:11

expand the object type field and click customer point,

01:15

check the box next to apply filter to current selection.

01:20

Then enter the following query into the large type Boxx.

01:26

Select

01:27

reference as key

01:30

sim dot PN

01:31

AVG as average pressure

01:33

SIM dot PN Max as max pressure

01:37

sim dot PN M

01:38

as min

01:40

pressure,

01:41

click the test button,

01:43

click OK. In the notification saying the query has valid syntax

01:48

then click apply.

01:50

This opens a grid with the average minimum and

01:53

maximum pressures of all the selected customer points.

01:58

You can copy and paste the contents of this grid

02:01

into a spreadsheet or export it to a CSV file

02:05

to export to a CSV file. Close the grid results window

02:10

in the SQL

02:11

dialogue, start a new line in the query and type into file followed by a double quote,

02:19

open file explorer and navigate to the results folder you created earlier.

02:24

Left, click the address bar to see the full path. Then right click and select copy,

02:30

return to the WS pro SQL

02:33

dialogue,

02:34

press control V to paste the file path.

02:37

And then at the end type backslash customers

02:41

results dot CSV followed by a double quote,

02:45

click apply

02:47

return to your results folder.

02:49

You will see the customers

02:50

results dot CSV file. You just exported,

02:54

you can open this file in a spreadsheet application.

Video transcript

00:04

Info

00:04

works. WS pro allows you to export both time varying data, TVD and summary data

00:12

summary data provides a summary of the time varying

00:15

data such as maximum minimum and average values.

00:20

This can be useful for exporting large numbers of objects. For comparison.

00:24

In this example,

00:26

you will export a summary report of the average minimum and

00:29

maximum pressure values for a selection of customers to CSV,

00:34

create a folder on your desktop and name it results.

00:39

This is where you will save the results of this exercise.

00:43

Open a completed run with results by dragging the simulation into the workspace

00:49

zoom into a part of the network populated with customer points

00:54

with the polygon select tool active,

00:56

draw a polygon around several customer points.

01:00

It is acceptable if the selection includes other objects

01:04

from the selection tab click SQL,

01:07

select to open the SQL

01:09

dialog,

01:11

expand the object type field and click customer point,

01:15

check the box next to apply filter to current selection.

01:20

Then enter the following query into the large type Boxx.

01:26

Select

01:27

reference as key

01:30

sim dot PN

01:31

AVG as average pressure

01:33

SIM dot PN Max as max pressure

01:37

sim dot PN M

01:38

as min

01:40

pressure,

01:41

click the test button,

01:43

click OK. In the notification saying the query has valid syntax

01:48

then click apply.

01:50

This opens a grid with the average minimum and

01:53

maximum pressures of all the selected customer points.

01:58

You can copy and paste the contents of this grid

02:01

into a spreadsheet or export it to a CSV file

02:05

to export to a CSV file. Close the grid results window

02:10

in the SQL

02:11

dialogue, start a new line in the query and type into file followed by a double quote,

02:19

open file explorer and navigate to the results folder you created earlier.

02:24

Left, click the address bar to see the full path. Then right click and select copy,

02:30

return to the WS pro SQL

02:33

dialogue,

02:34

press control V to paste the file path.

02:37

And then at the end type backslash customers

02:41

results dot CSV followed by a double quote,

02:45

click apply

02:47

return to your results folder.

02:49

You will see the customers

02:50

results dot CSV file. You just exported,

02:54

you can open this file in a spreadsheet application.

Video quiz

Which of the following is an example of summary data?

(Select one)
Select an answer

1/1 questions left unanswered

Step-by-step Guide

InfoWorks WS Pro allows users to export both time varying data (TVD) and summary data.

Summary data provides a summary of the Time Varying Data, such as maximum, minimum, and average values. This functionality can be useful for exporting large numbers of objects for comparison.

This example exports a summary report of the average, minimum, and maximum pressure values for a selection of customers to CSV.

  1. Create a new folder with the name “Results” to store the results of this exercise.
  2. From the Model Group window, drag-and-drop a completed run with results into the workspace to open the simulation GeoPlan.
  3. Zoom into a part of the network populated with customer points.
  4. In the Tools toolbar, click the Polygon select tool.
  5. Click to draw the vertices of a polygon around several customer points.

The InfoWorks WS Pro interface, Tools toolbar, with the Polygon select tool highlighted in red, and a zoomed in view of the BridgeCon GeoPlan, with a polygon being drawn in red around several customer points.

Note: The selection may include other objects.

  1. In the Selection menu, pick SQL Select.

In the Selection menu, SQL Select selected, and in the GeoPlan, the selected customer points highlighted in red.

  1. In the SQL dialog box, expand the Object Type drop-down and select Customer Point.
  2. Check the box next to Apply Filter to Current Selection.

In the SQL dialog box, Customer Point selected in the Object Type drop-down and Apply Filter to Current Selection enabled.

  1. Enter the following query into the text box:

SELECT

reference AS ‘Key’,

sim.pnavg AS ‘Average Pressure’,

sim.pnmax AS ‘Max Pressure’,

sim.pnmin AS ‘Min Pressure’

In the SQL dialog box, the text box with the query entered.

  1. Click the Test button.
  2. Click OK in the valid syntax notification.
  3. Click Apply.

A grid appears displaying the average, minimum, and maximum pressures of all the selected customer points. The contents can be copied and pasted into a spreadsheet.

A grid displaying Average Pressure, Max Pressure and Min Pressure for the selected customer points.

OR, to Export the contents to a CSV file:

  1. Close the grid results window.
  2. In the SQL dialog box, start a new line in the query and type: INTO FILE ”
  3. In a file explorer window, navigate to the Results folder created previously.
  4. Click the address bar to display the full path of the folder.
  5. Right-click the path and select Copy.

In a file explorer window, the path of the Results folder highlighted in the Address bar, and in its shortcut menu, Copy selected.

  1. In the WS Pro SQL dialog box, press CTRL+V to paste the file path into the query.
  2. At the end of the query, type: \CustomerResults.csv”
  3. Click Apply.

In the SQL dialog box, the completed query, with the new line highlighted in red, and Apply selected.

The CustomerResults.csv file now appears in the Results folder and can be opened in a spreadsheet application.

The file explorer window, Results folder, with the exported CSV file highlighted.

Was this information helpful?