AQUIS conversion notes
Network and Control Data information can be imported from an AQUIS Hydraulic Static Data Input (.DAT) file.
If an AQUIS .cf1 file is also present, time series data will also be imported.
This topic discusses how InfoWorks converts existing AQUIS network components into an InfoWorks network and InfoWorks control objects. Some data is not imported at all, or is only partially imported. Some AQUIS objects are imported as more complex InfoWorks objects, and additional data will be required to completely define these InfoWorks objects.
The following keywords are read from the .dat file by the IWWS AQUIS importer:
- *HAZW - Hazen Williams Friction Formula
- *NODE - Nodes
- *WTOW - Reservoir
- *LEAK - Leak
- *HYDR - Hydrant
- *PIPE - Pipe Segments
- *PUMP - Pump
- *VALV - Valves
- *VALC - Control Valve
- *CVTL - Non-return Valve
- *PRVL - Pressure Reducing Valves
- *PSVL - Pressure Sustaining Valves
- *CASC - Continuously Regulated Air Controlled Valve
- *ACV - Full Open / Closed Air Controlled Valve
The following keywords are read from the .cf1 file by the IWWS AQUIS importer:
- *PNOD - Node pressure time series
- *PROT - Pump rotation time series
- *PPMP - Pump pressure time series
- *QFAC - Flow factor time series
- *VOPN - Valve opening time series
- *HYTI - Hydrant opening time series
- *PRES - Pressure time series applied to a reservoir
- *PPRV - Pressure time series applied to a PRV
Values are assumed to be metric values.
*HAZW - Hazen Williams Friction Formula
The AQUIS *HAZW keyword is used to is used to switch from the Colebrook-White friction formula to the Hazen-Williams formula.
If the *HAZW keyword is not present in the AQUIS .DAT file, all pipe friction data is imported as CW.
If the *HAZW keyword is present, pipe friction data is imported as HW. The exception to this is for IWWS Pump Stations created from AQUIS node pump controls and IWWS Float Valves created from AQUIS air controlled valves. In these cases, the friction type is set to DW with a small nominal friction factor.
*NODE - Nodes
AQUIS Nodes are imported in general as IW Nodes. The exceptions are a follows:
- There is a corresponding time series *PNOD or *PRES entry in the AQUIS .cf1 file: the node will be imported as an IW Fixed Head node with the .cf1 time series imported to the Fixed Head control profile.
- The node has a corresponding *WTOW entry in the AQUIS .dat file (and no corresponding time series in the AQUIS .cf1 file): the node will be imported as an IW Reservoir node
- The node has a corresponding *LEAK or *HYDR entry in the AQUIS .dat file: the node will be imported as an IW Hydrant node
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"nodeid" |
Node Name |
Node ID |
|
"zoneid" |
Zone Name |
Area Code |
|
xcoor |
X Coordinate |
X |
|
ycoor |
Y Coordinate |
Y |
|
zcoor |
Z Coordinate |
Elevation |
|
press |
Pressure at Node |
If pressure is specified at the AQUIS node, the node is imported as an IW Fixed Head node. A Constant Head is imported to the Control Data calculated as: IW Constant Head = AQUIS Press + AQUIS zcoor |
If the AQUIS node defines an inlet pump control, a series of Well, Pump Station and Node objects are imported.
- The Well object is named based on the AQUIS node name appended by _Well and is set to profile mode.
- The Pump Station is set to AUTO mode and is imported with nominal length, diameter and DW-f values of 1, 555mm and 0.015 respectively.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"res" |
Reservoir Name |
Pump Control Node in Control Data. |
|
Zstart |
Level in Reservoir at which Pump Starts |
Pump Control On level. |
|
Zstop |
Level in Reservoir at which Pump Stops |
Pump Control Off level. |
|
TSStart |
Pump Start Pressure Time Series |
The corresponding time series in the .cf1 file is imported to UPC Script in the Control data as a table. A rule is created to turn the pump off when the controlling level is reached in the controlling reservoir. |
|
TSStop |
Pump Stop Pressure Time Series |
The corresponding time series in the .cf1 file is imported to UPC Script in the Control data as a table. A rule is created to turn the pump on when the controlling level is reached in the controlling reservoir. |
|
Q0 |
Initial Flow Supplied by Pump |
Not imported. |
|
Qi |
i'th flow supplied by pump |
Pump Curve named after the Node is created. Qi, Pi and Ei are imported to Flow / Head / Mechanical Power grid of Pump Curve. |
|
Pi |
i'th supply pressure corresponding to Qi |
|
|
Ei |
i'th energy corresponding to Qi |
|
|
Price |
Cost of running pump |
Not imported. |
|
PriceT |
Time series containing costs |
Not imported. |
*WTOW - Reservoir
AQUIS reservoirs are imported as IW reservoirs along with the underlying node data, unless a pressure-time series is specified in the AQUIS file, in which case the reservoir is converted to a Fixed Head node with a Constant Head set from the reservoir initial level.
If there is a corresponding time series *PRES entry in the AQUIS .cf1 file, the .cf1 time series will be imported to the Fixed Head control profile.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"nodeid" |
Node name |
Node ID |
|
P0 |
Initial Pressure |
Imported to Control Data as Initial Depth |
|
Pmax |
Maximum Water Level |
Top Water Level Calculated as: IW Top Water Level = AQUIS Pmax + AQUIS Node zcoor |
|
PT |
Pressure Time Series ID |
If a Pressure Time Series is specified in the AQUIS file, the node is imported as an IW Fixed Head node. A Constant Head is imported to the Control Data calculated as: IW Constant Head = AQUIS WTOW P0 + AQUIS Node zcoor The corresponding time series *PRES entry in the AQUIS .cf1 file will be imported to the Fixed Head control profile. |
|
zup |
Altitude Valve Upper Level |
Not currently imported |
|
zdw |
Altitude Valve Lower Level |
Minimum Operating Level Calculated as: IW Minimum Operating Level = AQUIS zdw + AQUIS Node zcoor |
|
Zi |
i'th Level in Level/Volume Curve |
Depth field of Depth/Volume curve |
|
Vi |
i'th Volume in Level/Volume Curve |
Volume field of Depth/Volume curve |
*LEAK - Leak
AQUIS leaks are imported as IW Hydrant nodes along with the underlying node data.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"nodeid" |
Node Name |
Node ID |
|
dleak |
Diameter of Leak |
Hydrant Diameter Valve Diameter |
*HYDR - Hydrant
AQUIS hydrants are imported as IW Hydrant nodes along with the underlying node data.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"nodeid" |
Node Name |
Node ID |
|
dhydrant |
Diameter of Hydrant |
Hydrant Diameter Valve Diameter |
|
"TS" |
Name of time series |
The corresponding time series *HYTI entry in the AQUIS .cf1 file will be imported to the Hydrant Flow opening / time control profile. |
*PIPE - Pipe Segments
AQUIS Pipes are imported as IW Pipes unless the pipe has one of the following corresponding entries in the AQUIS file:
- *PUMP: the pipe will be imported as an IW Pump Station
- *CVTL: the pipe will be imported as an IW Non-Return Valve
- *VALC: the pipe will be imported as an IW valve of mode PCV
- *VALV: the pipe will be imported as an IW valve of mode THV
- *PRVL: the pipe will be imported as an IW valve of mode PRV
- *PSVL: the pipe will be imported as an IW valve of mode PSV
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"pipeid" |
Pipe Name |
Asset ID |
|
"onode" |
Upstream Node |
From Node ID |
|
"dnode" |
Downstream Node |
To Node ID |
|
"pipetype" |
Type of Pipe |
Not imported. |
|
diam |
Internal Diameter |
Diameter (Set to 555mm if AQUIS diam is specified as unknown) |
|
rough |
Roughness |
CW-k or HW-c depending on whether the *HAZW keyword id present in the AQUIS file (Set to CW-k = 0.001 / HW-c = 20 if AQUIS roughness is specified as unknown) |
|
enkl |
Local Pressure Drop Coefficient |
Local Loss (Set to 0.0 if AQUIS local pressure drop coefficient is specified as unknown) |
|
length |
Pipe Length |
Length (Set to 1m if AQUIS length is specified as unknown) |
|
flow |
Pipe Flow |
Not imported. |
|
DPup |
Upstream Change in Pressure |
|
|
DPdw |
Downstream Change in Pressure |
|
|
pup |
Upstream Pressure |
|
|
pdw |
Downstream Pressure |
|
|
xi |
X coordinate of Pipe Bend |
Used to determine pipe vertices. |
|
yi |
Y coordinate of Pipe Bend |
*PUMP - Pump
AQUIS pumps are imported as IW Pump Stations and Pump Curves along with the underlying pipe data.
Pump Stations are set to Mode of Control PLAN, unless the AQUIS pump is controlled by a reservoir (see below).
If there is a corresponding time series *PROT entry in the AQUIS .cf1 file: the .cf1 time series will be imported to the IW UPC Script as a table with rules to control the speed of the pump.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"pipeid" |
Pipe Name |
Asset ID A Pump Curve named after the pipe name is also created. |
|
nact |
Actual Speed |
Maximum Speed Minimum Speed If the AQUIS actual speed is greater than zero the pump is set to permanently on. If the AQUIS speed is set to zero the pump is set to permanently off. |
|
price |
Energy Cost |
Not imported. |
|
ndef |
Nominal Speed |
Pump Curve Nominal Speed |
|
flowi |
i'th Flow in Flow / Head / Energy curve |
Pump Curve Flow in Flow / Head / Mechanical Power curve |
|
DPi |
i'th Pumping Head in Flow / Head / Energy curve |
Pump Curve Head in Flow / Head / Mechanical Power curve |
|
Ei |
i'th Energy consumption in Flow / Head Energy curve |
Pump Curve Mechanical Power in Flow / Head / Mechanical Power curve |
|
chkV |
Indicates whether Pump is equipped with a non-return valve |
If the AQUIS pump is not equipped with a check valve, a reversed IW non-return valve is connected in parallel with the IW pump station to allow back flow. |
|
"TSprice" |
Energy Time series Name |
Not imported. |
In the case that the AQUIS pump is controlled by a reservoir the IW Pump Station is set to Mode of Control Auto:
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
PlOnOff |
Initial Status of pump |
Pump Initial Status Set to Active or Standby. |
|
"Name" |
Name of Controlling Reservoir |
Control Node in Control Data |
|
ZStart |
Reservoir level at which pump starts |
Pump Control Data On |
|
ZStop |
Reservoir level at which pump stops |
Pump Control Data Off |
|
"TSStop" |
Name of time series controlling level at which pump stops |
The corresponding time series in the .cf1 file is imported to UPC Script in the Control data as a table. A rule is created to turn the pump off when the controlling level is reached in the controlling reservoir. |
|
"TSStart" |
Name of time series controlling level at which pump starts |
The corresponding time series in the .cf1 file is imported to UPC Script in the Control data as a table. A rule is created to turn the pump on when the controlling level is reached in the controlling reservoir. |
*VALV - Valves
AQUIS valves are imported as IW valves of Mode THV along with the underlying pipe data with the following exception:
- If there is a corresponding time series *VOPN entry in the AQUIS .cf1 file: the valve will be imported as an IW valve of mode TCV with the .cf1 time series imported to the date-time / opening control profile.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"pipeid" |
Pipe Name |
Asset ID |
|
alpha |
Actual Opening |
Imported to Control Data as Valve Opening |
|
alphai |
i'th Opening in Opening/Pressure Drop Coefficient curve |
Imported to a Valve Curve named after the Pipe name of the AQUIS valve. The AQUIS Kv values are converted to IW loss coefficients by: 2.592e3 x area2/Kv2 |
|
Kvi |
i'th Pressure Drop Coefficient in Opening/Pressure Drop Coefficient curve |
*VALC - Control Valve
AQUIS control valves are imported as IW valves of mode PCV along with the underlying pipe data.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"pipeid" |
Pipe Name |
Asset ID |
|
"nodeid" |
Control Node |
Imported to Control Data Control Node field |
|
upper level |
upper level for switching valve open and closed |
Imported to Control Data in the Depth column of the Depth/Opening grid. |
|
lower level |
lower level for switching valve open and closed |
Imported to Control Data in the Depth column of the Depth/Opening grid. |
|
mode |
specifies normal or reverse mode switch |
Imported to Control Data Depth/Opening grid. If AQUIS mode is set to 'ULCLOSE', Opening When Falling and Opening When Rising set to 100 at upper level, 0 at lower level. If AQUIS mode is set to 'ULOPEN', Opening When Falling and Opening When Rising set to 0 at upper level, 100 at lower level. |
|
alphai |
i'th Opening in Opening/Pressure Drop Coefficient curve |
Imported to a Valve Curve named after the Pipe name of the AQUIS valve. The AQUIS Kv values are converted to IW loss coefficients by: 2.592e3 x area2/Kv2 |
|
Kvi |
i'th Pressure Drop Coefficient in Opening/Pressure Drop Coefficient curve |
*CVTL - Non-return Valve
AQUIS non-return valves are imported as IW non-return valves along with the underlying pipe data.
|
AQUIS Field |
Description |
InfoWorks Data Field |
|---|---|---|
|
"pipeid" |
Pipe name |
Asset ID |
|
alpha |
Initial opening |
Not imported. |
|
alphai |
i'th Opening in Opening/Pressure Drop Coefficient curve |
Pipe Local Loss The AQUIS Opening/Pressure Drop Coefficient curve is Used to determine the Local Loss coefficient of the valve when fully open. The AQUIS Kv value of the valve when fully open is converted to an IW loss coefficient by: 2.592e3 x area2/Kv2 This calculated value is added to the Local Pressure Drop Coefficient of the associated pipe and the total is imported to the IW pipe Local Loss field. |
|
Kvi |
i'th Pressure Drop Coefficient in Opening/Pressure Drop Coefficient curve |
*PRVL - Pressure Reducing Valves
AQUIS pressure reducing valves are imported as IW valves of type PRV along with the underlying pipe data.
The Control Node in the Control Data is set to the Downstream Node of the valve.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"pipeid" |
Pipe name |
Asset ID |
|
DHest |
Estimate of pressure loss |
Not imported. |
|
pipeend |
Indicates whether controlling pressure is in pipe end or node |
Not imported. |
|
Check |
Indicates whether PRV has an integral non return valve |
Not imported |
|
"PT" |
Pressure time series name |
The corresponding time series *PPRV entry in the AQUIS .cf1 file will be imported to the date-time / control profile. |
|
P1, i |
i'th Controlling Pressure in Controlling Pressure / Resulting Pressure curve |
If the controlling/resulting pressure curve in the AQUIS file has a constant resulting pressure for the last two curve points, the IW Pressure setting in the Control Data is set to this constant value.
Otherwise, the Controlling / Resulting Pressure curve is imported to the IW UPC Script as a table. For example: TABLE PRVPressure IN NODE N-01168 PRESSURE OUT PRESSURE TYPE LINEAR 0.000000 0.000000 20.000000 10.000000 100.000000 50.000000 ENDTABLE RULE RL_P-012559 IF TRUE THEN NODE N-01167 PRESSURE = PRVPressure USING UPSTREAM REGULATOR ENDIF |
|
P2, i |
i'th Resulting Pressure in Controlling Pressure / Resulting Pressure curve |
*PSVL - Pressure Sustaining Valves
AQUIS pressure sustaining valves are imported as IW valves of type PSV along with the underlying pipe data.
The Control Node in the Control Data is set to the Upstream Node of the valve.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"pipeid" |
Pipe name |
Asset ID |
|
pipeend |
Indicates whether controlling pressure is in pipe end or node |
Not imported. |
|
Pressure |
Upstream Pressure to be maintained |
Control Pressure field of Control Data. |
*CASC - Continuously Regulated Air Controlled Valve
AQUIS continuously regulated air control valves are imported as IW float valves with continuous regulation type.
- The Inlet Level of the IW float valve is set to the elevation of the upstream node.
- The pipe parameters of the float valve are set to a nominal length, diameter and DW-f values of 1, 555mm and 0.015 respectively.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"nodeid" |
Node Name |
From Node ID |
|
"wtid" |
Reservoir Name |
To Node ID |
|
ZSTART |
Level at which valve is fully open |
Regulating Range calculated as: ZSTOP - ZSTART |
|
ZSTOP |
Level at which valve is fully closed |
Control Depth |
|
alphai |
i'th Opening in Opening/Pressure Drop Coefficient curve |
Pipe Local Loss The AQUIS Opening/Pressure Drop Coefficient curve is Used to determine the Local Loss coefficient of the valve when fully open. The AQUIS Kv value of the valve when fully open is converted to an IW loss coefficient by: 2.592e3 x area2/Kv2 This calculated value is added to the Local Pressure Drop Coefficient of the associated pipe and the total is imported to the IW pipe Local Loss field. |
|
Kvi |
i'th Pressure Drop Coefficient in Opening/Pressure Drop Coefficient curve |
*ACV - Full Open / Closed Air Controlled Valve
AQUIS air controlled valves are imported as IW float valves with On/Off regulation type.
| AQUIS Field | Description | InfoWorks Data Field |
|---|---|---|
|
"nodeid" |
Node Name |
From Node ID |
|
"wtid" |
Reservoir Name |
To Node ID |
|
alpha |
Initial opening |
Used to determine setting of Initially Open check box in Control Data. |
|
ZSTART |
Level at which valve is fully open |
Regulating Range calculated as: ZSTOP - ZSTART |
|
ZSTOP |
Level at which valve is fully closed |
Control Depth |
|
alphai |
i'th Opening in Opening/Pressure Drop Coefficient curve |
Pipe Local Loss The AQUIS Opening/Pressure Drop Coefficient curve is Used to determine the Local Loss coefficient of the valve when fully open. The AQUIS Kv value of the valve when fully open is converted to an IW loss coefficient by: 2.592e3 x area2/Kv2 This calculated value is added to the Local Pressure Drop Coefficient of the associated pipe and the total is imported to the IW pipe Local Loss field. |
|
Kvi |
i'th Pressure Drop Coefficient in Opening/Pressure Drop Coefficient curve |
*QFAC - Flow factor time series (.cf1 file)
AQUIS flow factor time series in the .cf1 file are imported as demand categories to a Demand Diagram.
| AQUIS Field | Description | InfoWorks Demand Diagram Data Field |
|---|---|---|
|
"NAME" |
Name of flow factor type |
Category Comment |
|
Type |
Flow factor type number |
Demand Category number |
|
TGFF |
Type specific global factor |
Not imported |
|
ti |
i'th time |
Imported to the Daily Values (Time / Factor) Grid. |
|
ffi |
Flow factor at the i'th time |
