Property (Collection) Data Fields

Property data can be edited on either the Property Grid Window of the Zones Grid or the Property (Collection) 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: cams_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

 

 

 

 

 

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

 

 

 

 

 

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

 

 

 

 

 

Ground level

Ground level at property location.

ground_level

 Double   Z 3

 

 

 

-99.99

 
Occupancy Number of residents at the property. occupancy Double     3          

Sanitary US node ID

ID of the sanitary upstream node.

sanitary_us_node_id

Text

40

 

0

 

 

 

 

 

Sanitary DS node ID

ID of the sanitary downstream node.

sanitary_ds_node_id

Text

40

 

0

 

 

 

 

 

Sanitary link suffix

Suffix of the sanitary link.

sanitary_link_suffix

Text

1

 

0

 

 

 

 

 

Storm US node ID

ID of the storm upstream node.

storm_us_node_id

Text

40

 

0

 

 

 

 

 

Storm DS node ID

ID of the storm downstream node.

storm_ds_node_id

Text

40

 

0

 

 

 

 

 

Storm link suffix

Suffix of the storm link.

storm_link_suffix

Text

1

 

0

 

 

 

 

 

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

 

 

 

 

 
Drain tests

Click the button to display the read-only drain test grid which lists the details of any drain test associated with this property.

Field name

Description
Drain test ID Unique identifier for the drain test survey associated with this property.
Current A Yes/No field which indicates whether or not the drain test survey for this property is current.
Drain type The type of drain connected to the property.
Survey date The date of the survey.
Sanitary manhole observation A Yes/No field which indicates whether or not dye was observed at the sanitary manhole.
Storm manhole observation A Yes/No field which indicates whether or not dye was observed at the storm manhole.
Curb outlet observation A Yes/No field which indicates whether or not dye was observed at the curb outlet.
Drainage swale observation A Yes/No field which indicates whether or not whether or not dye was observed at the drainage swale.
Other observation A Yes/No field which indicates whether or not whether or not dye was observed at another location. The other location is defined as the Other Image in the Drain Test's attachment editor.
None observed A Yes/No field which indicates whether or not whether or not dye was observed at any of the monitored locations.
                   
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                  
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