Geometry

Description (User Interface): Network

ShortCode: GMT

Contents:

Tables
Structures

Tables

wn_address_point

Description (User Interface): Customer Point

Primary Key: reference

Name	Description	Type	Size	Flag	Unit	Notes
allocated_pipe_id	Pipe Id	String	63	true
allocation_run	Run	Integer		true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
average_demand	Average Demand	Float		true	WN_DQ
category_id	Category Id	String	30	true
category_type	Category Type	Integer		true
connection_point_x	Connection Point X	Float		true	XY
connection_point_y	Connection Point Y	Float		true	XY
demand_at_us_node	Demand at From Node	Boolean		true
direct_demand	Direct Demand Factor	Float		true
equivalent_persons	Equiv. Persons	Float		false
external_category	Ext Category	String	30	true
identifier	Identifier	String	50	true
key_customer	Key Customer	Boolean		true
no_of_properties	No. Props.	Integer		true
parent_key	Parent Key	String	50	true
reference	Key	String	25	true
saved	Saved	Boolean		false
spec_consumption	Spec. Cons.	Float		true	WN_QD
status	Status	Integer		false
x	X	Float		true	XY
y	Y	Float		true	XY
z	Z	Float		true	Z
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_category

Description (User Interface): Polygon Category

Primary Key: category_id

Name	Description	Type	Size	Flag	Unit	Notes
category_id	Category ID	String	30	true
notes	Notes	String		false

wn_channel_shape

Description (User Interface): Channel Shape

Name	Description	Type	Size	Flag	Unit	Notes
shape_description	Description	String	80	false
shape_id	Shape ID	String	64	false

wn_componentset_area

Description (User Interface): Area Group

Primary Key: componentset_id

Name	Description	Type	Size	Flag	Unit	Notes
area_code	Area Code	String	100	false
area_nodes	Node ID	Structure		false		wn_area_group_area_nodes
asset_id	Asset ID	String	30	false
boundary_array	Points	Array<Float>		false	XY
boundary_links	Boundary links	Structure		false		wn_area_group_boundary_links
componentset_id	Object Group ID	String	30	false
hotlinks	Hyperlinks	String		false
notes	Notes	String		false
x	X	Float		false	XY
y	Y	Float		false	XY
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_componentset_node

Description (User Interface): Node Group

Primary Key: componentset_id

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	false
boundary_array	Points	Array<Float>		false	XY
componentset_id	Object Group ID	String	30	false
hotlinks	Hyperlinks	String		false
nodes	Node ID	Structure		false		wn_node_group_nodes
notes	Notes	String		false
x	X	Float		false	XY
y	Y	Float		false	XY
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_componentset_pipe

Description (User Interface): Link Group

Primary Key: componentset_id

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	true
boundary_array	Points	Array<Float>		false	XY
componentset_id	Object Group ID	String	30	true
hotlinks	Hyperlinks	String		false
notes	Notes	String		false
pipe_links	Link ID	Structure		false		wn_pipe_links
x	X	Float		false	XY
y	Y	Float		false	XY
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_componentset_pump

Description (User Interface): Pump Station Group

Primary Key: componentset_id

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	true
boundary_array	Points	Array<Float>		false	XY
componentset_id	Object Group ID	String	30	true
eghgf_regime	GHG Regime	String	30	false
electricity_tariff	Electricity Tariff	String	30	true
hotlinks	Hyperlinks	String		false
max_power	Licensed Max Power Demand	Float		true	WN_KVA
notes	Notes	String		false
pump_links	Link ID	Structure		false		wn_pump_links
voltage	Voltage	Boolean		true
x	X	Float		false	XY
y	Y	Float		false	XY
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_componentset_res

Description (User Interface): Reservoir Group

Primary Key: componentset_id

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	true
boundary_array	Points	Array<Float>		false	XY
componentset_id	Object Group ID	String	30	true
hotlinks	Hyperlinks	String		false
multi_component_reservoir	Multicomponent Reservoir	Boolean		false
notes	Notes	String		false
res_nodes	Node ID	Structure		false		wn_res_nodes
x	X	Float		false	XY
y	Y	Float		false	XY
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_demand_area

Description (User Interface): Demand Area

Primary Key: area_id

Name	Description	Type	Size	Flag	Unit	Notes
ignore_leakage	Ignore Leakage	Boolean		false
notes	Notes	String		false

wn_fixed_head

Description (User Interface): Fixed Head

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
fire_zone	Fire Zone	String	30	true
ground_level	Ground Level	Float		true	Z
highest_property	Highest Property	Float		true	Z
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
node_id	Node ID	String	30	true
notes	Notes	String		false
system_type	System Type	String	40	true
x	X	Float		true	XY
y	Y	Float		true	XY
z	Z	Float		true	Z
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_float_valve

Description (User Interface): Float Valve/Inlet

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
alt_sim_method	Alternate Simulation Method	Boolean		false
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
backfeed	Backfeed	Boolean		true
bends	Bends	Array<Float>		false	XY
bulk_coeff	WQ Bulk Coefficient	Float		true
construction_date	Construction Date	DateTime		false
construction_type	Valve Curve	String	30	true
control_depth	Control Depth	Float		true	Y
criticality	Criticality	Integer		true
criticality_count	Criticality Count	Integer		true
darcy_weissbach	DW - f	Float		true
diameter	Diameter	Float		true	PS
ds_node_id	Node2	String	30	true
hazen_williams	HW - c	Float		true
hotlinks	Hyperlinks	String		false
inlet_level	Inlet Level	Float		true	Z
inlet_position	Inlet Position	Boolean		true
isolation_area	Isolation Area	String	30	false
k	CW - k	Float		true	WN_K
length	Length	Float		true	L
link_suffix	Link Suffix	String	1	true
local_loss	Local Loss	Float		true
loss_when_open	Loss When Open	Float		true
material	Material	String	10	true
notes	Notes	String		false
pressure_rating	Pressure Rating	Float		true	WN_P
regulating_range	Regulating Range	Float		true	Y
regulation_type	Regulation Type	Boolean		true
roughness_type	Friction Type	String	2	true
system_type	System Type	String	40	true
us_node_id	Node1	String	30	true
valve_diameter	Valve Diameter	Float		true	PS
wall_coeff	WQ Wall Coefficient	Float		true
wave_celerity	Wave Celerity	Float		true	V
year	Year	Integer		true
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_hydrant

Description (User Interface): Hydrant

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
construction_type	Valve Curve	String	30	true
demand_by_category	Demand By Category	Structure		false		wn_node_demand_by_category
diameter	Diameter	Float		true	PS
fire_zone	Fire Zone	String	30	true
ground_level	Ground Level	Float		true	Z
head_z	Outlet Elevation	Float		true	Z
highest_property	Highest Property	Float		true	Z
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
landuse_areas	Land Use Areas	Structure		false		wn_node_landuse_areas
leakage_loss	Leakage Loss	Float		true	WN_DQ
local_loss	Local Loss	Float		true
loss_when_open	Loss When Open	Float		true
node_id	Node ID	String	30	true
nominal_average_pressure	Nominal Average Pressure	Float		true	WN_P
notes	Notes	String		false
rel_head	Relative Outlet Elevation	Float		true	L
system_type	System Type	String	40	true
total_connections	Total Conns	Integer		true
type	Hydrant Type	String	30	true
valve_diameter	Valve Diameter	Float		true	PS
x	X	Float		true	XY
y	Y	Float		true	XY
z	Z	Float		true	Z
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_incident_report

Description (User Interface): Spatial Data

Primary Key: identifier

Name	Description	Type	Size	Flag	Unit
allocated_pipe_id	Pipe Id	String	63	true
allocation_run	Run	Integer		true
date_time	Date Time	DateTime		true
details	Details	String	32	true
identifier	Key	String	30	true
notes	Notes	String		false
reference	Reference	String	25	true
saved	Saved	Boolean		false
status	Status	Integer		false
type	Type	String	30	true
x	X	Float		true	XY
y	Y	Float		true	XY
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_landuse

Description (User Interface): Land Use

Primary Key: landuse2_id

Name	Description	Type	Size	Flag	Unit
category_id	Demand Category	String	30	true
density_demand	Demand Density	Float		true	WN_DDEN
density_property	Prop. Density	Float		true	WN_PDEN
description	Description	String	80	true
hotlinks	Hyperlinks	String		false
landuse	Land Use	String	30	true
landuse2_id	Land Use Demand ID	String	30	true
method	Method	Integer		true
notes	Notes	String		false
proportion	Proportion	Float		true
spec_consumption	Spec. Cons.	Float		true	WN_QD
total_demand	Land Use Demand	Float		true	WN_DQ
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_meter

Description (User Interface): Meter

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
bends	Bends	Array<Float>		false	XY
billing_id	Meter Id	String	30	true
bulk_coeff	WQ Bulk Coefficient	Float		true
construction_date	Construction Date	DateTime		false
construction_type	Construction Type	String	10	true
criticality	Criticality	Integer		true
criticality_count	Criticality Count	Integer		true
darcy_weissbach	DW - f	Float		true
diameter	Diameter	Float		true	PS
ds_node_id	Node2	String	30	true
hazen_williams	HW - c	Float		true
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
k	CW - k	Float		true	WN_K
length	Length	Float		true	L
link_suffix	Link Suffix	String	1	true
local_loss	Local Loss	Float		true
loss_when_open	Meter Loss Coeff	Float		true
material	Material	String	10	true
meter_diameter	Meter Diameter	Float		true	PS
notes	Notes	String		false
pressure_rating	Pressure Rating	Float		true	WN_P
roughness_type	Friction Type	String	2	true
system_type	System Type	String	40	true
us_node_id	Node1	String	30	true
wall_coeff	WQ Wall Coefficient	Float		true
wave_celerity	Wave Celerity	Float		true	V
year	Year	Integer		true
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_meter_construction

Description (User Interface): Meter Construction

Primary Key: id

Name	Description	Type	Size	Flag	Unit	Notes
id	Meter Construction ID	String	10	false

wn_node

Description (User Interface): Node

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
demand_by_category	Demand By Category	Structure		false		wn_node_demand_by_category
fire_zone	Fire Zone	String	30	true
ground_level	Ground Level	Float		true	Z
highest_property	Highest Property	Float		true	Z
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
landuse_areas	Land Use Areas	Structure		false		wn_node_landuse_areas
leakage_loss	Leakage Loss	Float		true	WN_DQ
node_id	Node ID	String	30	true
nominal_average_pressure	Nominal Average Pressure	Float		true	WN_P
notes	Notes	String		false
system_type	System Type	String	40	true
total_connections	Total Conns	Integer		true
x	X	Float		true	XY
y	Y	Float		true	XY
z	Z	Float		true	Z
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_non_return_valve

Description (User Interface): Non Return Valve

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
bends	Bends	Array<Float>		false	XY
bulk_coeff	WQ Bulk Coefficient	Float		true
construction_date	Construction Date	DateTime		false
criticality	Criticality	Integer		true
criticality_count	Criticality Count	Integer		true
darcy_weissbach	DW - f	Float		true
diameter	Diameter	Float		true	PS
ds_node_id	Node2	String	30	true
hazen_williams	HW - c	Float		true
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
k	CW - k	Float		true	WN_K
length	Length	Float		true	L
link_suffix	Link Suffix	String	1	true
local_loss	Local Loss	Float		true
material	Material	String	10	true
notes	Notes	String		false
pressure_rating	Pressure Rating	Float		true	WN_P
roughness_type	Friction Type	String	2	true
system_type	System Type	String	40	true
us_node_id	Node1	String	30	true
valve_diameter	Valve Diameter	Float		true	PS
wall_coeff	WQ Wall Coefficient	Float		true
wave_celerity	Wave Celerity	Float		true	V
year	Year	Integer		true
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_open_channel

Description (User Interface): Open Channel

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	false
asset_id	Asset ID	String	30	false
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
bends	Bends	Array<Float>		false	XY
bulk_coeff	WQ Bulk Coefficient	Float		false
channel_height	Height	Float		false	PS
channel_width	Width	Float		false	PS
construction_date	Construction Date	DateTime		false
ds_invert	DS invert level	Float		false	Z
ds_node_id	Node2	String	30	false
hotlinks	Hyperlinks	String		false
inlet_orifice_diameter	Inlet orifice diameter	Float		false	PS
inlet_orifice_invert	Inlet orifice invert level	Float		false	Z
isolation_area	Isolation Area	String	30	false
iwlive_can_be_closed	Has Valve	Boolean		true
k	CW - k	Float		false	WN_K
length	Length	Float		false	L
link_suffix	Link Suffix	String	1	false
material	Material	String	10	false
notes	Notes	String		false
outlet_weir_crest	Outlet weir crest	Float		false	PS
outlet_weir_length	Outlet weir length	Float		false	PS
outlet_weir_width	Outlet weir width	Float		false	PS
roughness_Manning	Manning's 1/n	Float		false
roughness_N	Manning's n	Float		false
roughness_type	Friction Type	String	8	false
shape	Shape ID	String	64	false
system_type	System Type	String	40	false
us_invert	US invert level	Float		false	Z
us_node_id	Node1	String	30	false
year	Year	Integer		false
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_pipe

Description (User Interface): Pipe

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
bends	Bends	Array<Float>		false	XY
bulk_coeff	WQ Bulk Coefficient	Float		true
CO2cost	CO2 Material Cost	Float		false	PIPE_CO2TOT
construction_date	Construction Date	DateTime		false
criticality	Criticality	Integer		true
criticality_count	Criticality Count	Integer		true
darcy_weissbach	DW - f	Float		true
diameter	Diameter	Float		true	PS
ds_node_id	Node2	String	30	true
hazen_williams	HW - c	Float		true
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
iwlive_can_be_closed	Has Valve	Boolean		true
k	CW - k	Float		true	WN_K
length	Length	Float		true	L
link_suffix	Link Suffix	String	1	true
local_loss	Local Loss	Float		true
material	Material	String	10	true
notes	Notes	String		false
pressure_rating	Pressure Rating	Float		true	WN_P
roughness_type	Friction Type	String	2	true
system_type	System Type	String	40	true
us_node_id	Node1	String	30	true
wall_coeff	WQ Wall Coefficient	Float		true
wave_celerity	Wave Celerity	Float		true	V
year	Year	Integer		true
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_pipe_material

Description (User Interface): Pipe Material

Primary Key: id

Name	Description	Type	Size	Flag	Unit	Notes
id	Pipe Material ID	String	10	false

wn_polygon

Description (User Interface): Polygons

Primary Key: polygon_id

Name	Description	Type	Size	Flag	Unit	Notes
area	Polygon Area	Float		true	WN_PA
area_code	Area Code	String	100	false
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
boundary_array	Points	Array<Float>		false	XY
category_id	Category ID	String	30	true
hotlinks	Hyperlinks	String		false
landuse2_id	Land Use	String	30	true
notes	Notes	String		false
polygon_id	Polygon ID	String	30	true
population_factor	Occupancy Rate	Float		true
property_num	Number of Properties	Float		true
spec_consumption	Spec. Cons.	Float		true	WN_QD
total_demand	Land Use Demand	Float		true	WN_DQ
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_polygon_node

Description (User Interface): Node Polygons

Primary Key: polygon_id

Name	Description	Type	Size	Flag	Unit
area	Polygon Area	Float		true	WN_PA
boundary_array	Points	Array<Float>		false	XY
hotlinks	Hyperlinks	String		false
node_id	Node ID	String	30	true
notes	Notes	String		false
polygon_id	Polygon ID	String	30	true
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_prd_curve

Description (User Interface): PRD Curve

Primary Key: curve_id

Name	Description	Type	Size	Flag	Notes
curve	Loss Coefficients	Structure		false	wn_prd_values
curve_id	Curve ID	String	30	true
description	Description	String	80	true
notes	Notes	String		false
power	Power	Float		true
relationship	Relationship	Integer		true
user_defined	Curve Type	Boolean		false

wn_prunes

Description (User Interface): Pruned Link

Primary Key: prune_id

Name	Description	Type	Size	Flag
date	Date pruned	DateTime		false
point_array	Point Array	Array<Float>		false
prune_id	Prune ID	String	40	false
prune_network_GUID	Prune Network Version ID	String	40	false

wn_pst

Description (User Interface): Pump Station

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
active_total_ratio	Power Factor	Float		true
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
bends	Bends	Array<Float>		false	XY
bulk_coeff	WQ Bulk Coefficient	Float		true
bypass	Bypass	Boolean		true
construction_date	Construction Date	DateTime		false
criticality	Criticality	Integer		true
criticality_count	Criticality Count	Integer		true
darcy_weissbach	DW - f	Float		true
diameter	Diameter	Float		true	PS
ds_node_id	Node2	String	30	true
duty_head	Duty Head	Float		true	HEAD
eghgf_regime	CO2 Factor Regime	String	30	false
electric_hydraulic_ratio	Electric Mechanical Power Ratio	Float		true
electricity_tariff	Electricity Tariff	String	30	true
hazen_williams	HW - c	Float		true
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
k	CW - k	Float		true	WN_K
length	Length	Float		true	L
link_suffix	Link Suffix	String	1	true
local_loss	Local Loss	Float		true
material	Material	String	10	true
notes	Notes	String		false
power_consumption	Power Consumption	Float		true	WN_ESC
pressure_rating	Pressure Rating	Float		true	WN_P
pumps	Pumps	Structure		false		wn_pst_pumps
roughness_type	Friction Type	String	2	true
system_type	System Type	String	40	true
turbine	Turbine	Boolean		false
us_node_id	Node1	String	30	true
voltage	Voltage	Boolean		true
wall_coeff	WQ Wall Coefficient	Float		true
wave_celerity	Wave Celerity	Float		true	V
year	Year	Integer		true
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_pump

Description (User Interface): Pump

Primary Key: id

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	true
id	Pump ID	String	30	true
iwts_inertia_total	Inertia	Float		false	WN_INERTIA
iwts_inertia_type	Inertia Type	String	10	false
nominal_flow	Nominal Flow	Float		true	WN_Q
nominal_speed	Nominal Speed	Float		true	WN_AV
notes	Notes	String		false
pressure_diameter	Pressure Diameter	Float		true	PS
suction_diameter	Suction Diameter	Float		true	PS
triplets	Triplets	Structure		false		wn_pump_triplets

wn_reservoir

Description (User Interface): Reservoir

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
bottom_level	Bottom Level	Float		true	Z
bulk_coeff	Reaction Coefficient	Float		true
demand_by_category		Structure		false		wn_node_demand_by_category
depth_volume	Depth Volume	Structure		false		wn_reservoir_depth_volume
fire_zone	Fire Zone	String	30	true
ground_level	Ground Level	Float		true	Z
highest_property	Highest Property	Float		true	Z
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
landuse_areas	Land Use Areas	Structure		false		wn_node_landuse_areas
leakage_loss	Leakage Loss	Float		true	WN_DQ
minimum_level	Minimum Operating Level	Float		true	Z
node_id	Node ID	String	30	true
nominal_average_pressure	Nominal Average Pressure	Float		true	WN_P
notes	Notes	String		false
system_type	System Type	String	40	true
top_level	Top Level	Float		true	Z
total_connections	Total Connections	Integer		true
x	X	Float		true	XY
y	Y	Float		true	XY
z	Z	Float		true	Z
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_transfer_node

Description (User Interface): Transfer Node

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
fire_zone	Fire Zone	String	30	true
ground_level	Ground Level	Float		true	Z
highest_property	Highest Property	Float		true	Z
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
node_id	Node ID	String	30	true
notes	Notes	String		false
system_type	System Type	String	40	true
x	X	Float		true	XY
y	Y	Float		true	XY
z	Z	Float		true	Z
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_valve

Description (User Interface): Valve

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
bends	Bends	Array<Float>		false	XY
bulk_coeff	WQ Bulk Coefficient	Float		true
construction_date	Construction Date	DateTime		false
construction_type	Valve Curve	String	30	true
criticality	Criticality	Integer		true
criticality_count	Criticality Count	Integer		true
darcy_weissbach	DW - f	Float		true
diameter	Diameter	Float		true	PS
ds_node_id	Node2	String	30	true
hazen_williams	HW - c	Float		true
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
k	CW - k	Float		true	WN_K
length	Length	Float		true	L
link_suffix	Link Suffix	String	1	true
local_loss	Local Loss	Float		true
loss_when_open	Loss When Open	Float		true
material	Material	String	10	true
notes	Notes	String		false
pressure_rating	Pressure Rating	Float		true	WN_P
roughness_type	Friction Type	String	2	true
system_type	System Type	String	40	true
us_node_id	Node1	String	30	true
valve_diameter	Valve Diameter	Float		true	PS
wall_coeff	WQ Wall Coefficient	Float		true
wave_celerity	Wave Celerity	Float		true	V
year	Year	Integer		true
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

wn_valve_curve

Description (User Interface): Valve Curve

Primary Key: curve_id

Name	Description	Type	Size	Flag	Notes
curve	Loss Coefficients	Structure		false	wn_valve_loss_coefficients
curve_id	Curve ID	String	30	true
description	Description	String	80	true
notes	Notes	String		false
user_defined	Curve Type	Boolean		false

wn_well

Description (User Interface): Well

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
area	Area	String	30	true
asset_id	Asset ID	String	30	true
asset_network_uid		String		false		GUID
asset_uid		String		false		GUID
fire_zone	Fire Zone	String	30	true
ground_level	Ground Level	Float		true	Z
highest_property	Highest Property	Float		true	Z
hotlinks	Hyperlinks	String		false
isolation_area	Isolation Area	String	30	false
node_id	Node ID	String	30	true
notes	Notes	String		false
system_type	System Type	String	40	true
x	X	Float		true	XY
y	Y	Float		true	XY
z	Z	Float		true	Z
user_number_1	User Number 1	Double		true
user_number_2	User Number 2	Double		true
user_number_3	User Number 3	Double		true
user_number_4	User Number 4	Double		true
user_number_5	User Number 5	Double		true
user_number_6	User Number 6	Double		true
user_number_7	User Number 7	Double		true
user_number_8	User Number 8	Double		true
user_number_9	User Number 9	Double		true
user_number_10	User Number 10	Double		true
user_number_11	User Number 11	Double		true
user_number_12	User Number 12	Double		true
user_number_13	User Number 13	Double		true
user_number_14	User Number 14	Double		true
user_number_15	User Number 15	Double		true
user_text_1	User Text 1	String	100	true
user_text_2	User Text 2	String	100	true
user_text_3	User Text 3	String	100	true
user_text_4	User Text 4	String	100	true
user_text_5	User Text 5	String	100	true
user_text_6	User Text 6	String	100	true
user_text_7	User Text 7	String	100	true
user_text_8	User Text 8	String	100	true
user_text_9	User Text 9	String	100	true
user_text_10	User Text 10	String	100	true
user_text_11	User Text 11	String	100	true
user_text_12	User Text 12	String	100	true
user_text_13	User Text 13	String	100	true
user_text_14	User Text 14	String	100	true
user_text_15	User Text 15	String	100	true

Structures

wn_area_group_area_nodes

Description (User Interface): Node Group Nodes

Name	Description	Type	Size	Flag	Unit	Notes
key_node	Key node	Boolean		false
node_id	Node ID	String	30	false

wn_area_group_boundary_links

Description (User Interface): Node Group Nodes

Name	Description	Type	Size	Flag
direction_downstream_inside	Downstream inside	Boolean		false
key_link	Key link	Boolean		false
link_id	Link ID	String	80	false

wn_node_group_nodes

Description (User Interface): Node Group Nodes

Name	Description	Type	Size	Flag	Unit	Notes
node_id	Node ID	String	30	false

wn_pipe_links

Description (User Interface): Pipe Links

Name	Description	Type	Size	Flag	Unit	Notes
link_id	Link ID	String	65	false
positive_flow	Positive Flow	Boolean		false

wn_pump_links

Description (User Interface): Pump Links

Name	Description	Type	Size	Flag	Unit	Notes
link_id	Pump Station ID	String	65	false

wn_res_nodes

Description (User Interface): Res Nodes

Name	Description	Type	Size	Flag	Unit	Notes
node_id	Node ID	String	30	false

wn_node_demand_by_category

Description (User Interface): Demand By Category

Name	Description	Type	Size	Flag	Unit
average_demand	Average Demand	Float		false	WN_DQ
category_id	Category Id	String	30	false
direct_demand	Direct Demand Factor	Float		false
equivalent_persons	Equiv. Persons	Float		false
no_of_properties	No. Props.	Integer		false
spec_consumption	Spec. Cons.	Float		false	WN_QD

wn_node_landuse_areas

Description (User Interface): Land Use Areas

Name	Description	Type	Size	Flag	Unit
area	Area	Float		false	WN_PA
landuse2_id	Land Use Demand ID	String	30	false
polygon_id	Polygon ID	String	30	false
proportion	Land Use Area	Float		false	WN_PA

wn_prd_values

Description (User Interface): PRD Relationship Values

Name	Description	Type	Size	Flag	Unit	Notes
demand_ratio	Demand Ratio	Float		false
pressure_ratio	Pressure Ratio	Float		false

wn_pst_pumps

Description (User Interface): Pumps

Name	Description	Type	Size	Flag	Unit
actual_speed	Maximum Speed	Integer		false	WN_AV
cut_off_level	Cut Off Level	Float		false	Z
duty_flow	Duty Flow	Float		false	WN_Q
local_loss_coeff	Local Loss Coeff	Float		false
minimal_speed	Minimal Speed	Integer		false	WN_AV
no_of_stages	No Of Stages	Integer		false
pump_curve_id	Pump Curve ID	String	30	false

wn_pump_triplets

Description (User Interface): Triplets

Name	Description	Type	Flag	Unit
flow	Flow	Float	false	WN_Q
head	Head	Float	false	HEAD
power	Power	Float	false	WN_POW

wn_reservoir_depth_volume

Description (User Interface): Depth Volume

Name	Description	Type	Size	Flag	Unit	Notes
depth	Depth	Float		false	Y
volume	Volume	Float		false	WN_RVO

wn_valve_loss_coefficients

Description (User Interface): Valve Loss Coefficients

Name	Description	Type	Size	Flag	Unit	Notes
loss_coeff	Loss Coefficient	Float		false
opening	Opening	Float		false	WN_OPEN

Geometry

Tables

wn_address_point

wn_category

wn_channel_shape

wn_componentset_area

wn_componentset_node

wn_componentset_pipe

wn_componentset_pump

wn_componentset_res

wn_demand_area

wn_fixed_head

wn_float_valve

wn_hydrant

wn_incident_report

wn_landuse

wn_meter

wn_meter_construction

wn_node

wn_non_return_valve

wn_open_channel

wn_pipe

wn_pipe_material

wn_polygon

wn_polygon_node

wn_prd_curve

wn_prunes

wn_pst

wn_pump

wn_reservoir

wn_transfer_node

wn_valve

wn_valve_curve

wn_well

Structures

wn_area_group_area_nodes

wn_area_group_boundary_links

wn_node_group_nodes

wn_pipe_links

wn_pump_links

wn_res_nodes

wn_node_demand_by_category

wn_node_landuse_areas

wn_prd_values

wn_pst_pumps

wn_pump_triplets

wn_reservoir_depth_volume

wn_valve_loss_coefficients

Was this information helpful?