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
Field Name |
Help Text |
Flag |
Grid |
Property Page |
Size |
Precision |
Database Field |
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
Field Name |
Help Text |
Flag |
Grid |
Property Page |
Size |
Precision |
Database Field |
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 |
|
|
|
|
|