Alternative demand data fields

This topic contains details of these alternative demand data fields.

Alternative Demand Page

Database Table Name: wn_alt_node_demand

Show Columns	Help Text
	Visibility
	Size, Type and Units
	Database Names
	Error Limits

Field Name

Help Text

Flag

Grid

Property Page

Size

Precision

Units

Database Field

Data Type

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

Demand By Category

Displayed on Node Demand Page only.

The Demand box contains a grid where you can define the Existing Demand for the node. Total demand, or demand per property is defined for each User Category supplied from the node.

The demand grid can only be edited from the Node Demand Page so full details on using this grid are included there.

Database Table Name: wn_node_demand_by_category

Show Columns	Help Text
	Size, Type and Units
	Database Names
	Error Limits

Position in Data Structure

Field Name

Help Text

Flag

Size

Units

Database Field

Type

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

Demand Category

The name of the Demand Category. If there is a current Demand Diagram, the dropdown list will be filled with the categories for the current Demand Diagram. Or you can type in a category name.

There are two special Demand Category names:

If the Demand Category field is left blank or CONST is entered, a constant demand profile is assumed.
If CONST_LEAKAGE is entered in this field, a constant leakage profile is assumed.

YES

category_id

Text

Specific Consumption

The consumption for each property in this category

YES

WN_QD

spec_consumption

Average Demand

The average demand from this node for all properties in the category

YES

WN_DQ

average_demand

Number of Equivalent Persons

The number of equivalent persons in this category

YES

WN_QD

equivalent_persons

Double

Number Of Properties

The number of properties in this category

YES

no_of_properties

Direct Demand Factor

A factor applied to a demand category created as Direct demand to adjust the demand category values.

Note: A Direct Demand Factor should only be used with demand categories created as Direct demand. If a Direct Demand Factor is applied to a Factored demand category, it will be ignored. See Editing Demand Diagrams for more details.

The factor will normally be 1.0

YES

direct_demand

Source

Data Field	Description
0	Customer Point
1	Land Use Area
2	User Defined

source

Integer

Category Type

Data Field	Description
0	Property
1	Average
2	Direct
3	Equivalent Persons

YES

category_type

Integer

YES

demand_by_category

Array

Node ID

Name of node

YES

node_id

Text

Total Conns

The number of customer connections attributed to node.

YES

total_connections

Alternative Customer Points Page

Database Table Name: wn_alt_customer_demand

Show Columns	Help Text
	Visibility
	Size, Type and Units
	Database Names
	Error Limits

Field Name

Help Text

Flag

Grid

Property Page

Size

Precision

Units

Database Field

Data Type

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

Key

A unique identifier for the Customer Point object

YES

reference

Text

Category Type

Database Value	Description	Help Text
0	Property	Property based demand
1	Average	Average demand
2	Direct	Direct demand
3	Equivalent Persons	Equivalent Persons demand

YES

category_type

Integer

External Category

You may have an external demand category name that does not match any of the categories in your Demand Diagram in InfoWorks. You can use this External Category name to map data onto InfoWorks demand categories during the import process on the Demand Allocation Wizard Special Review Page.

YES

external_category

Text

Demand Category

The name of the InfoWorks Demand category

YES

category_id

Text

Number of Equivalent Persons

The number of equivalent persons associated with the customer point. See additional table below.

YES

WN_QD

equivalent_persons

Double

Number Of Properties

The number of properties associated with the customer point. See additional table below.

YES

no_of_properties

Specific Consumption

The daily consumption per property. See additional table below.

YES

WN_QD

spec_consumption

Average Demand

The average demand per customer point. See additional table below.

YES

WN_DQ

average_demand

Direct Demand Factor

A factor applied to a demand category created as Direct demand to adjust the demand category values.

The factor will normally be 1.0.

See additional table below.

YES

direct_demand

Alternative Land Use Page

Database Table Name: wn_alt_landuse_demand

Show Columns	Help Text
	Visibility
	Size, Type and Units
	Database Names
	Error Limits

Field Name

Help Text

Flag

Grid

Property Page

Size

Precision

Units

Database Field

Data Type

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

Demand By Category

Database Table Name: wn_node_landuse_areas

Show Columns	Help Text
	Size, Type and Units
	Database Names
	Error Limits

Position in Data Structure	Field Name	Help Text	Flag	Size	Units	Database Field	Type
1	Land Use Demand ID	Land Use ID	YES	30		landuse2_id	Text
2	Area	Area	YES		WN_PA	area
3	Land Use Area	Proportion of Land Use Total Area	YES		WN_PA	proportion
4	Polygon ID	Polygon Name. Demand values specified at this polygon will override the demand values specified at the Land Use object.	YES	30		polygon_id	Text

YES

landuse_areas

Array

Node ID

Name of node

YES

node_id

Text

Network Objects

Basic Node Data Fields

Hydrant Node Data Fields

Reservoir Data Fields

Basic Pipe Data Fields