Polygon data fields

Polygon data can be edited on the Polygons Grid View of the Polygons Grid or the Polygon Definition Page of the Polygon Property Sheet. You can also keep notes about a polygon on the Notes Tab of the property sheet.

Further information, including units details, about all the Network Object fields stored in the Master Database can be found in the data fields topics listed in the Network Data Fields topic.

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

The following table describes all polygon specific data fields.

Polygon Data

Database Table Name: wn_polygon

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

Polygon ID

The name of the polygon

YES

YES

1

30

0

 

polygon_id

Text

 

 

 

 

 

Category ID

You can add the polygon to a category. Select a category from the dropdown list. Polygon Categories are defined on the Polygon Category Grid View in the Polygons Grid.

YES

YES

1

30

0

 

category_id

Text

 

 

 

 

 

Polygon Area

Polygon area default value calculated from polygon geometry.

YES

YES

1

 

3

WN_PA

area

Double

1

0

 

 

 

Number of Properties

The property count for the polygon. Enter a value manually, or generate the information from GIS address point data or from existing network demand data. See Property Counting for more information.

Can be used in conjunction with the Specific Consumption and Polygon Area fields to override Land Use object demand values when calculating Land Use demand using the Property Density calculation methods. See Allocating Land Use Demand to Nodes for details.

YES

YES

1

 

0

 

property_num

Double

0

0

 

 

 

Occupancy Rate

A multiplier used to convert the Number of Properties value into an estimate of Population. The value used will depend on the source of the Number of Properties data

YES

YES

1

 

1

 

population_factor

Double

2.4

0

 

 

 

Land Use

Add ID of Land Use

YES

YES

1

30

0

 

landuse2_id

Text

 

 

 

 

 

Specific Consumption

Daily consumption per property.

Can be used to override Land Use object demand values when calculating Land Use demand using the Property Density calculation method.

See Allocating Land Use Demand to Nodes for details.

YES

YES

1

 

2

WN_QD

spec_consumption

 

 

 

 

 

 

Land Use Demand

Total demand for the land use area.

Can be used to override Land Use object demand values when calculating Land Use demand using the Land Use Demand or Demand Density calculation methods.

See Allocating Land Use Demand to Nodes for details.

YES

YES

1

 

4

WN_DQ

total_demand

 

 

 

 

 

 

Population

A read-only field generated from Number of Properties multiplied by Occupancy Rate

NO

YES

NO

 

3

 

population

Double

 

 

 

 

 

Points

An array of X/Y values giving the geometry of the polygon.

NO

YES

NO

 

0

XY

boundary_array

Array

 

 

 

 

 

InfoNet Unique ID

The InfoNet Unique ID and InfoNet Network ID are unique identifiers associated with the corresponding object and network in an InfoNet database. When importing from InfoNet, these identifiers can be copied from the InfoNet database in order to maintain links between the two networks.

YES

YES

NO

 

0

 

asset_uid

GUID

 

 

 

 

 

InfoNet Network ID

See InfoNet Unique ID

NO

YES

NO

 

0

 

asset_network_uid

GUID

 

 

 

 

 

Polygon Category Data

Database Table Name: wn_category

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

Notes

You can keep freeform notes about any object in your network. The notes field can be up to 64,000 characters in size, or about 10 pages of printed text.

NO

YES

 

 

0

 

notes

Memo

 

 

 

 

 

Category ID

Category that can be associated with a polygon.

Polygon Categories will be displayed in the choice list of the Category field on the Polygon property sheet or grid view.

YES

YES

 

30

0

 

category_id

Text

 

 

 

 

 


Polygons

Common Data Fields

Polygon Categories

Property Counting

Polygons Grid

GeoPlan Window

Polygon Definition Page