Property (Distribution) Data Fields

Property data can be edited on either the Property Grid Window of the Zones Grid or the Property(Distribution) Property Sheet.

To view and edit all property data, use the Property Sheet.

The following describes all the data which can be used to define a property.

Common Data Fields

Fields that are common to the majority of objects can be found in the Common Fields topic.

Property Data

Database Table Name: wams_property

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Field Name

Help Text

Database Field

Data Type

Size

Units

Precision

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

Property ID

Unique identifier for the property.

id

Text

40

 

0

 

 

 

 

 

Property type

The type of the property:

Database Value

Description

RESIDENTIAL

Residential

COMMERCIAL

Commercial

INDUSTRIAL

Industrial

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

property_type

Text

40

 

0

 

 

 

 

 

Area

Area covered by property. Default area is calculated from polygon geometry if property is an asset area or 100 m2 if property is an asset point.

area

Double

 

 

3

 

 

 

 

 

Owner

Owner of the property.

owner

Text

200

 

0

 

 

 

 

 

X coord

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y Coord

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 

Ground level

Ground level at property location.

ground_level

Double

 

 

3

 

 

 

-99.99

 

Pipe ID

ID of the pipe to which the property is connected.

pipe_id

Text

40

 

0

 

 

 

 

 

Occupancy Number of residents at the property. occupancy Double     3          
Occupancy (Key)

Number of key residents (residents for which interruption to supply could be dangerous, e.g. dialysis patients) at the property.

occupancy_key Double     3          

Property name

Name of the property.

property_name

Text

200

 

0

 

 

 

 

 

Property address

Address of the property.

property_address

Text

200

 

0

 

 

 

 

 

Property town

Town the property is in.

property_town

Text

200

 

0

 

 

 

 

 

Property district

District the property is in.

property_district

Text

200

 

0

 

 

 

 

 

Property zip or postcode

Postcode of the property.

property_postalcode

Text

200

 

0

 

 

 

 

 

Property phone

Phone number of the property.

property_phone

Text

200

 

0

 

 

 

 

 

Contact name

Contact name for the property.

contact_name

Text

200

 

0

 

 

 

 

 

Contact address

Address of the contact for the property.

contact_address

Text

200

 

0

 

 

 

 

 

Contact town

Town of the contact for the property.

contact_town

Text

200

 

0

 

 

 

 

 

Contact district

District of the contact for the property.

contact_district

Text

200

 

0

 

 

 

 

 

Contact zip or postcode

Postcode of the contact for the property.

contact_postalcode

Text

200

 

0

 

 

 

 

 

Contact phone

Phone number of the contact for the property.

contact_phone

Text

200

 

0

 

 

 

 

 

Contact email address

Email address of the contact for the property.

contact_email

Text

200

 

0

 

 

 

 

 

Attachments

Click the button to display the Attachments Editor, used to attach and manage photos, sketches and other files associated with the network object.

See Attachments Editor and Common Data Fields for further details.

attachments Array                
General properties fields See Common Data Fields for details of field in the General properties section of the property sheet.                    
User defined properties fields See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet.                    
Time series links

Click the button to display the Time Series Data Source Grid, which is used to specify or update the time series data streams that are linked to this property.

tsdb_links                  
Network Data Fields

Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.

Property

Zones Grid