Workspace Properties

Key Value
Name Stormwater_UtilityNetwork.geodatabase
Workspace Type Local Database
Workspace Factory Sqlite
Geodatabase Release 3.0.0
Date Exported 2024-03-18 12:11:44
Path

Datasets

Name Dataset Type Feature Dataset Dataset ID
main.UtilityNetwork FeatureDataset
main.StructureBoundary FeatureClass main.UtilityNetwork 39
main.StructureLine__ATTACHREL RelationshipClass main.UtilityNetwork 134
main.StormwaterJunction FeatureClass main.UtilityNetwork 106
main.Stormwater_Device_BMP_to_Inspection RelationshipClass main.UtilityNetwork 130
main.StormwaterDevice FeatureClass main.UtilityNetwork 103
main.ServiceTerritory FeatureClass main.UtilityNetwork 5
main.StructureJunction__ATTACHREL RelationshipClass main.UtilityNetwork 133
main.StructureJunction FeatureClass main.UtilityNetwork 35
main.StructureBoundary__ATTACHREL RelationshipClass main.UtilityNetwork 132
main.Network UtilityNetwork main.UtilityNetwork 6
main.StormwaterJunction__ATTACHREL RelationshipClass main.UtilityNetwork 128
main.StormwaterLine FeatureClass main.UtilityNetwork 104
main.StormwaterLine__ATTACHREL RelationshipClass main.UtilityNetwork 129
main.StormwaterAssembly FeatureClass main.UtilityNetwork 105
main.Stormwater_Device_Discharge_To_Inspection RelationshipClass main.UtilityNetwork 131
main.Structure_Junction_Manhole_To_Inspection RelationshipClass main.UtilityNetwork 135
main.StormwaterDevice__ATTACHREL RelationshipClass main.UtilityNetwork 127
main.StormwaterAssembly__ATTACHREL RelationshipClass main.UtilityNetwork 125
main.StructureLine FeatureClass main.UtilityNetwork 38
main.StormwaterSubnetLine FeatureClass main.UtilityNetwork 107
main.StructureJunctionObject Table 40
main.StructureEdgeObject Table 41
main.StormwaterJunctionObject Table 108
main.StormwaterEdgeObject Table 109
main.DischargeInspection Table 110
main.DischargeInspection__ATTACH Table 111
main.ManholeInspection Table 112
main.ManholeInspection__ATTACH Table 113
main.StormwaterAssembly__ATTACH Table 114
main.StormwaterBMPInspection Table 115
main.StormwaterBMPInspection__ATTACH Table 116
main.StormwaterDevice__ATTACH Table 117
main.StormwaterJunction__ATTACH Table 118
main.StormwaterLine__ATTACH Table 119
main.StructureBoundary__ATTACH Table 120
main.StructureJunction__ATTACH Table 121
main.StructureLine__ATTACH Table 122
main.DischargeInspection__ATTACHREL RelationshipClass 123
main.ManholeInspection__ATTACHREL RelationshipClass 124
main.StormwaterBMPInspection__ATTACHREL RelationshipClass 126
main.GDB_ValidationObjectErrors Table 138
main.GDB_ValidationPointErrors FeatureClass 139
main.GDB_ValidationLineErrors FeatureClass 140
main.GDB_ValidationPolygonErrors FeatureClass 141

main.UtilityNetwork

Properties

Key Value
Name main.UtilityNetwork
Dataset Type FeatureDataset
Feature Dataset
Dataset ID
# of Children 20
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min
Y-Min
X-Max
Y-Max

Datasets

Name Dataset Type Feature Dataset Dataset ID
main.StructureBoundary FeatureClass main.UtilityNetwork 39
main.StructureLine__ATTACHREL RelationshipClass main.UtilityNetwork 134
main.StormwaterJunction FeatureClass main.UtilityNetwork 106
main.Stormwater_Device_BMP_to_Inspection RelationshipClass main.UtilityNetwork 130
main.StormwaterDevice FeatureClass main.UtilityNetwork 103
main.ServiceTerritory FeatureClass main.UtilityNetwork 5
main.StructureJunction__ATTACHREL RelationshipClass main.UtilityNetwork 133
main.StructureJunction FeatureClass main.UtilityNetwork 35
main.StructureBoundary__ATTACHREL RelationshipClass main.UtilityNetwork 132
main.Network UtilityNetwork main.UtilityNetwork 6
main.StormwaterJunction__ATTACHREL RelationshipClass main.UtilityNetwork 128
main.StormwaterLine FeatureClass main.UtilityNetwork 104
main.StormwaterLine__ATTACHREL RelationshipClass main.UtilityNetwork 129
main.StormwaterAssembly FeatureClass main.UtilityNetwork 105
main.Stormwater_Device_Discharge_To_Inspection RelationshipClass main.UtilityNetwork 131
main.Structure_Junction_Manhole_To_Inspection RelationshipClass main.UtilityNetwork 135
main.StormwaterDevice__ATTACHREL RelationshipClass main.UtilityNetwork 127
main.StormwaterAssembly__ATTACHREL RelationshipClass main.UtilityNetwork 125
main.StructureLine FeatureClass main.UtilityNetwork 38
main.StormwaterSubnetLine FeatureClass main.UtilityNetwork 107

main.StructureBoundary

Properties

Key Value
Name main.StructureBoundary
Dataset Type FeatureClass
Feature Dataset main.UtilityNetwork
Dataset ID 39
Geometry Type Polygon
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 13.2
Alias Structure Boundary
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field SHAPE
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 500372.76851501653
Y-Min 1550391.9656166665
X-Max 1270078.1610237253
Y-Max 2190094.2549103117
Catalog ID {105F74B4-2F1F-4670-AC1B-C286A53E86FC}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
SUBNETWORKNAME Subnetwork name String Index False Unknown 0 0 2000 False True
SHAPE Shape Geometry Index False 0 0 8 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
depth Depth Double True 0 0 8 True False
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 2 True False
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 2 True False
assetcondition Condition Short Integer True 0 0 2 True False
bmpclass BMP Class Short Integer True 0 0 2 True False
assetid Asset ID String True 0 0 64 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False
st_area(SHAPE) shape_Area Double Area True 0 0 0 False True
st_perimeter(SHAPE) shape_Length Double Length True 0 0 0 False True

Index

Name Is Unique Is Ascending Field Name
GDB_39_SUBNETWOR False True SUBNETWORKNAME
UUID_40 True True GLOBALID
FDO_OBJECTID True True OBJECTID
st_spindex__StructureBoundary_SHAPE True True SHAPE

Subtype

Name Code Details
Unknown 0
BMP Boundary 401
Storm Lift Station Boundary 404

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 SUBNETWORKNAME Unknown
BMP Boundary 401 ASSETTYPE 0 Asset_Type_Structure_Boundary_BMP_Boundary
BMP Boundary 401 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
BMP Boundary 401 SUBNETWORKNAME Unknown
BMP Boundary 401 assetcondition 0 Structure_Boundary_BMP_Condition
BMP Boundary 401 bmpclass 0 BMP_Class
BMP Boundary 401 constructionstatus 6 Construction_Status
BMP Boundary 401 lifecyclestatus 2 Lifecycle_Status
BMP Boundary 401 spatialconfidence 0 Spatial_Confidence
BMP Boundary 401 spatialsource 0 Spatial_Source
Storm Lift Station Boundary 404 ASSETTYPE 0 Asset_Type_Structure_Boundary_Storm_Lift_Station_Boundary
Storm Lift Station Boundary 404 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Storm Lift Station Boundary 404 SUBNETWORKNAME Unknown
Storm Lift Station Boundary 404 constructionstatus 6 Construction_Status
Storm Lift Station Boundary 404 lifecyclestatus 2 Lifecycle_Status
Storm Lift Station Boundary 404 spatialconfidence 0 Spatial_Confidence
Storm Lift Station Boundary 404 spatialsource 0 Spatial_Source

AttributeRule

ID Minimum Client Version Evaluation Order Name Description Type Batch Insert Trigger Update Trigger Delete Trigger Subtype Field Name Severity Error Number Error Message Editable Enabled Exclude From Client Tags Creation Time Category Check Parameters Script
5 12.6 1 StructureBoundary-GenerateIDs Generate IDs for StructureBoundary using database sequences Calculation False True True False assetid True True True 2024-03-18 12:02:52 // Assigned To: StructureBoundary // Type: Calculation // Name: StructureBoundary-GenerateIDs // Description: Generate IDs for StructureBoundary using database sequences // Subtypes: All // Field: assetid // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules are rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated In: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - StructureJunction-GenerateIDs // - StormwaterDevice-GenerateIDs // - StormwaterJunction-GenerateIDs // - StormwaterLine-GenerateIDs // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Field in the data model used to store and manage the ID // ** Implementation Note: This value does not need to change if using the industry data model var assigned_to_field = $feature.assetid; // Asset group/Subtype field used to define different IDs per the class // ** Implementation Note: This value does not need to change if using the industry data model var id_selector_value = $feature.assetgroup; // Define the leading text, the trailing text and the delimiter for the ID, this function requires the keyed passed in // NextSequenceValue requires a string literal for copy and paste, although it supports a variable, it is recommended // to not use one // ** Implementation Note: Adjust the prefix and join_char for each subtype. The selector_value_txt is the subtype of the layer function get_id(selector_value) { var id_format = {} var seq_val = null; var selector_value_txt = Text(selector_value) if (selector_value_txt == '401') { id_format = { 'prefix': "BMP", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_BMP_401_seq'); }else if (selector_value_txt == '404') { id_format = { 'prefix': "Strm-Lft-Sttn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_Strm_Lft_Sttn_404_seq'); } else { return null; } var id_parts = remove_empty([id_format['prefix'], seq_val, id_format['suffix']]) return Concatenate(id_parts, id_format['join_char']) } // ************* End User Variables Section ************* // ************* Functions ************* function remove_empty(arr) { var new_arr = []; var j = 0; for (var i = 0; i < Count(arr); i++) { if (!IsEmpty(arr[i]) && arr[i] != '') { new_arr[j++] = arr[i]; } } return new_arr; } // ************* End Functions Section ***************** if ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

main.StructureLine__ATTACHREL

Properties

Key Value
Name main.StructureLine__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 134
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.StructureLine
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.StructureLine__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {18AFA4C8-1C24-497A-BD74-422EA8B732DB}
Class ID
Extension Class ID

main.StormwaterJunction

Properties

Key Value
Name main.StormwaterJunction
Dataset Type FeatureClass
Feature Dataset main.UtilityNetwork
Dataset ID 106
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 13.2
Alias Stormwater Junction
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field SHAPE
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 500372.76851501653
Y-Min 1550391.9656166665
X-Max 1270078.1610237253
Y-Max 2190094.2549103117
Catalog ID {1D03EB23-3A9B-4F43-AD0E-8DB90207940E}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
ISCONNECTED Is connected Short Integer False Network_6_IsConnected 2 0 0 2 False True
SHAPE Shape Geometry Index False 0 0 8 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
SUBNETWORKNAME Subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTEDSUBNETWORKNAME Supported subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTINGSUBNETWORKNAME Supporting subnetwork name String Index False Unknown 0 0 2000 False True
installdate Install Date Date True 0 0 8 True False
ownedby Owned By Short Integer True Asset_Owner 1 0 0 2 True False
maintby Maintained By Short Integer True Asset_Manager 1 0 0 2 True False
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 2 True False
material Material Short Integer True 0 0 2 True False
assetid Asset ID String True 0 0 64 True False
notes Notes String True 0 0 2000 True False
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 2 True False
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 2 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_106_SUPPORTI False True SUPPORTINGSUBNETWORKNAME
GDB_106_SUPPORTE False True SUPPORTEDSUBNETWORKNAME
GDB_106_SUBNETWO False True SUBNETWORKNAME
UUID_46 True True GLOBALID
FDO_OBJECTID True True OBJECTID
st_spindex__StormwaterJunction_SHAPE True True SHAPE

Subtype

Name Code Details
Unknown 0
Wall 23

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 ISCONNECTED 2 Network_6_IsConnected
Unknown 0 SUBNETWORKNAME Unknown
Unknown 0 SUPPORTEDSUBNETWORKNAME Unknown
Unknown 0 SUPPORTINGSUBNETWORKNAME Unknown
Wall 23 ASSETTYPE 0 Asset_Type_Stormwater_Junction_Wall
Wall 23 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Wall 23 ISCONNECTED 2 Network_6_IsConnected
Wall 23 SUBNETWORKNAME Unknown
Wall 23 SUPPORTEDSUBNETWORKNAME Unknown
Wall 23 SUPPORTINGSUBNETWORKNAME Unknown
Wall 23 constructionstatus 6 Construction_Status
Wall 23 lifecyclestatus 2 Lifecycle_Status
Wall 23 maintby 1 Asset_Manager
Wall 23 material 0 Stormwater_Wall_Material
Wall 23 ownedby 1 Asset_Owner
Wall 23 spatialconfidence 0 Spatial_Confidence
Wall 23 spatialsource 0 Spatial_Source
Wall 23 symbolrotation Symbol_Rotation

AttributeRule

ID Minimum Client Version Evaluation Order Name Description Type Batch Insert Trigger Update Trigger Delete Trigger Subtype Field Name Severity Error Number Error Message Editable Enabled Exclude From Client Tags Creation Time Category Check Parameters Script
10 12.6 1 StormwaterJunction-GenerateIDs Generate IDs for StormwaterJunction using database sequences Calculation False True True False assetid True True True 2024-03-18 12:03:00 // Assigned To: StormwaterJunction // Type: Calculation // Name: StormwaterJunction-GenerateIDs // Description: Generate IDs for StormwaterJunction using database sequences // Subtypes: All // Field: assetid // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules are rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated In: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - StructureJunction-GenerateIDs // - StructureBoundary-GenerateIDs // - StormwaterDevice-GenerateIDs // - StormwaterLine-GenerateIDs // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Field in the data model used to store and manage the ID // ** Implementation Note: This value does not need to change if using the industry data model var assigned_to_field = $feature.assetid; // Asset group/Subtype field used to define different IDs per the class // ** Implementation Note: This value does not need to change if using the industry data model var id_selector_value = $feature.assetgroup; // Define the leading text, the trailing text and the delimiter for the ID, this function requires the keyed passed in // NextSequenceValue requires a string literal for copy and paste, although it supports a variable, it is recommended // to not use one // ** Implementation Note: Adjust the prefix and join_char for each subtype. The selector_value_txt is the subtype of the layer function get_id(selector_value) { var id_format = {} var seq_val = null; var selector_value_txt = Text(selector_value) if (selector_value_txt == '23') { id_format = { 'prefix': "Wll", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_J_Wll_23_seq'); } else { return null; } var id_parts = remove_empty([id_format['prefix'], seq_val, id_format['suffix']]) return Concatenate(id_parts, id_format['join_char']) } // ************* End User Variables Section ************* // ************* Functions ************* function remove_empty(arr) { var new_arr = []; var j = 0; for (var i = 0; i < Count(arr); i++) { if (!IsEmpty(arr[i]) && arr[i] != '') { new_arr[j++] = arr[i]; } } return new_arr; } // ************* End Functions Section ***************** if ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id
11 12.4 2 Junction Symbol Rotation Symbol rotation calculation for junction features Calculation False True True False symbolrotation True True False 2024-03-18 12:03:00 // Assigned To: StormwaterJunction // Type: Calculation // Name: Junction Symbol Rotation // Description: Symbol rotation calculation for junction features // Subtypes: All // Field: symbolrotation // Trigger: Insert, Update // Exclude From Client: False // Disable: False // This calculation attribute rule intersects a line layer and based on the number of // intersected features, calculates the angle for the point // Set to true if the rotation setting is set to geographic in the layer properties var geographic_rotation = false; // Set the counter clockwise spin angle used for the symbol in the symbology options var symbol_flip_angle = 0 // Return if a value is already set, to recalculate an angle, the field must be set to null if (IsEmpty($feature.symbolrotation) == false) { return $feature.symbolrotation; } // Create a feature set to the line layer var lineClass = FeatureSetByName($datastore, "{7C039769-C72B-4CE4-B32C-602ABF505582}", ["objectid"], true); // Find the intersecting lines var lines = Intersects(lineClass, $feature); var intersectcount = Count(lines); //If no lines intersect, return the original value if (intersectcount == 0) { return $feature.symbolrotation; } var diff_tol = 5; // Variable to store all found angles var angles = []; var new_segment = null; // Store the features geometry var feature_geometry = Geometry($feature); // Loop over all intersecting lines and find their angles var angle_type; var angle_value; for (var line in lines) { // Buffer and create an extenf of the point by a small amount to extract the segment var clip_area = Extent(Buffer($feature, .01, "meter")); // Clip the line by the extend and get the first line segment var segment = Clip(line, clip_area)["paths"][0]; // The features location is on the start of the line, get the angle from the feature to the end vertex if (Equals(segment[0], feature_geometry)) { angle_type = 'from' angle_value = Round(Angle(feature_geometry, segment[-1]), 0) } // The features location is on the end of the line, create a new segment from the feature to the start vertex else if (Equals(segment[-1], feature_geometry)) { angle_type = 'to' angle_value = Round(Angle(feature_geometry, segment[0]), 0) } // The features location is midspan of the segment, use the angle of the segment else { angle_type = 'mid' angle_value = Round(Angle(segment[0], segment[-1]), 0) } if (geographic_rotation == true) { // Convert Arithmetic to Geographic angle_value = (450 - angle_value) % 360; } // Add 180 to match 0 rotation in the TOC // Add user specified spin angle if their symbol is rotated angle_value = (angle_value + 180 + symbol_flip_angle) % 360; angles[Count(angles)] = {'angle': angle_value, 'type': angle_type}; } // If only one angle, return that value if (Count(angles) == 1) { // If the point is midspan, flip to match symbol as it if was on the end point if (angles[0]['type'] == 'mid') { return (angles[0]['angle'] + 180) % 360; } return angles[0]['angle']; } else if (Count(angles) == 2) { // If the feature is midpan of the first line, return the angle of the second line if (angles[0]['type'] == 'mid') return angles[1]['angle']; // If the feature is midpan of the second line, return the angle of the first line else if (angles[1]['type'] == 'mid') return angles[0]['angle']; // If the feature is at the end point of both lines, return the angle of the first line else if (angles[0]['type'] == 'to' && angles[1]['type'] == 'to') { return angles[0]['angle']; } // If the feature is at the start point of both lines, return the angle of the first line else if (angles[0]['type'] == 'from' && angles[1]['type'] == 'from') { return angles[0]['angle']; } // If the feature is at the start point of the first line and end of the second line, return the second line else if (angles[0]['type'] == 'from') { return angles[1]['angle']; } // If the feature is at the start point of the second line and start of the second line, return the first line return angles[0]['angle']; } else if (Count(angles) == 3) { // Flatten the angles to ignore direction var flat_angle1 = angles[0]['angle'] % 180; var flat_angle2 = angles[1]['angle'] % 180; var flat_angle3 = angles[2]['angle'] % 180; // Create differences between angles var angle_dif_a = Abs(flat_angle1 - flat_angle2); var angle_dif_b = Abs(flat_angle1 - flat_angle3); var angle_dif_c = Abs(flat_angle2 - flat_angle3); // If difference between line 1 and 2 is below the tolerance, meaning the lines follow the same plane, return the // third line if (angle_dif_a <= (diff_tol * 2) || angle_dif_a >= (180 - (diff_tol * 2))) { return angles[2]['angle']; } // If difference between line 1 and 3 is below the tolerance, meaning the lines follow the same plane, return the // second line else if (angle_dif_b <= (diff_tol * 2) || angle_dif_b >= (180 - (diff_tol * 2))) { return angles[1]['angle']; } // If difference between line 2 and 3 is below the tolerance, meaning the lines follow the same plane, return the // first line else if (angle_dif_c <= (diff_tol * 2) || angle_dif_c >= (180 - (diff_tol * 2))) { return angles[0]['angle']; } // Return first if not covered above return angles[0]['angle']; } // All other cases, the first feature is returned else { return angles[0]['angle']; }

main.Stormwater_Device_BMP_to_Inspection

Properties

Key Value
Name main.Stormwater_Device_BMP_to_Inspection
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 130
Type Composite
Cardinality One To Many
Notification None
Is Attachment False
Is Attributed False
Origin Name main.StormwaterDevice
Origin Primary Key globalid
Origin Foreign Key assetguid
Destination Name main.StormwaterBMPInspection
Destination Primary Key
Destination Foreign Key
Forward Path Label StormwaterBMPInspection
Backward Path Label StormwaterDevice
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {2209BBCB-266F-4F84-B1C9-51DA4A77B4F4}
Class ID
Extension Class ID

RelationshipClassRule

Rule ID Origin Subtype Origin Min Cardinality Origin Max Cardinality Destination Subtype Destination Min Cardinality Destination Max Cardinality
1 BMP Point 0 10000 0 10000
2 Catch Basin 0 10000 0 10000
3 Cleanout 0 0 0 0
4 Connection 0 0 0 0
5 Manhole Channel 0 0 0 0
6 Pump 0 0 0 0
7 Unknown 0 0 0 0
8 Weir 0 0 0 0
9 BMP Inlet 0 0 0 0
10 Outlet 0 0 0 0

main.StormwaterDevice

Properties

Key Value
Name main.StormwaterDevice
Dataset Type FeatureClass
Feature Dataset main.UtilityNetwork
Dataset ID 103
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 13.2
Alias Stormwater Device
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field SHAPE
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 500372.76851501653
Y-Min 1550391.9656166665
X-Max 1270078.1610237253
Y-Max 2190094.2549103117
Catalog ID {22B2EFA9-B93D-4017-A161-84EA77DDB6C3}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
ISSUBNETWORKCONTROLLER Is subnetwork controller Short Integer False Network_6_IsSubnetworkController 0 0 0 2 False True
ISCONNECTED Is connected Short Integer False Network_6_IsConnected 2 0 0 2 False True
SUBNETWORKCONTROLLERNAME Subnetwork controller name String Index False Unknown 0 0 2000 False True
TIERNAME Tier name Short Integer False Network_6_TierName 0 0 0 2 False True
TIERRANK Tier rank Long Integer False 0 0 0 4 False True
TERMINALCONFIGURATION Terminal path String False Default 0 0 128 True True
SHAPE Shape Geometry Index False 0 0 8 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
SUBNETWORKNAME Subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTEDSUBNETWORKNAME Supported subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTINGSUBNETWORKNAME Supporting subnetwork name String Index False Unknown 0 0 2000 False True
installdate Install Date Date True 0 0 8 True False
ownedby Owned By Short Integer True Asset_Owner 1 0 0 2 True False
maintby Maintained By Short Integer True Asset_Manager 1 0 0 2 True False
assetid Asset ID String True 0 0 64 True False
notes Notes String True 0 0 2000 True False
diameter Diameter Double True 0 0 8 True False
permitid Permit ID String True 0 0 50 True False
location Location Short Integer True 0 0 2 True False
material Material Short Integer True 0 0 2 True False
wingwall Wingwall Short Integer True 0 0 2 True False
orifice Orifice Short Integer True 0 0 2 True False
permitted Permitted Short Integer True 0 0 2 True False
surfacewater Receives Surface Water Short Integer True 0 0 2 True False
exitsystem Water Exiting System Short Integer True 0 0 2 True False
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
activevol Activate Volume Short Integer False 0 0 2 True False
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 2 True False
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 2 True False
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 2 True False
signage Signage Short Integer True 0 0 2 True False
designtype Type Short Integer True 0 0 2 True False
length2 Length Double True 0 0 8 True False
width Width Double True 0 0 8 True False
depth Depth Double True 0 0 8 True False
inletcount Number of Inlets Short Integer True 0 0 2 True False
outletcount Number of Outlets Short Integer True 0 0 2 True False
volume Storage Volume Double True 0 0 8 True False
rate Treatment Rate Double True 0 0 8 True False
rate2 Infiltration Rate Double True 0 0 8 True False
reuse Capture and Reuse Short Integer True 0 0 2 True False
outfallid Outfall ID String True 0 0 64 True False
outfall Outfall Short Integer True 0 0 2 True False
elevation Elevation Short Integer True 0 0 2 True False
bmpclass BMP Class Short Integer True 0 0 2 True False
inletshape Inlet Shape Short Integer True 0 0 2 True False
sump Sump Short Integer True 0 0 2 True False
observationport Observation Port Short Integer True 0 0 2 True False
confinedspace Confined Space Short Integer True 0 0 2 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False
VALIDATIONSTATUS Validation status Short Integer Index True Validation Status 6 0 0 2 False True

Index

Name Is Unique Is Ascending Field Name
GDB_103_VALIDATI False True VALIDATIONSTATUS
GDB_103_SUBNETWO False True SUBNETWORKCONTROLLERNAME
GDB_103_SUBNETWO_1 False True SUBNETWORKNAME
GDB_103_SUPPORTE False True SUPPORTEDSUBNETWORKNAME
GDB_103_SUPPORTI False True SUPPORTINGSUBNETWORKNAME
UUID_43 True True GLOBALID
FDO_OBJECTID True True OBJECTID
st_spindex__StormwaterDevice_SHAPE True True SHAPE

Subtype

Name Code Details
Unknown 0
Pump 5
Weir 26
Cleanout 21
Catch Basin 28
BMP Point 29
Outlet 22
BMP Inlet 30
Connection 23
Manhole Channel 32

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
Unknown 0 ISCONNECTED 2 Network_6_IsConnected
Unknown 0 SUBNETWORKCONTROLLERNAME Unknown
Unknown 0 TIERNAME 0 Network_6_TierName
Unknown 0 TIERRANK 0
Unknown 0 TERMINALCONFIGURATION Default
Unknown 0 SUBNETWORKNAME Unknown
Unknown 0 SUPPORTEDSUBNETWORKNAME Unknown
Unknown 0 SUPPORTINGSUBNETWORKNAME Unknown
Unknown 0 VALIDATIONSTATUS 6 Validation Status
Pump 5 ASSETTYPE 0 Asset_Type_Stormwater_Device_Pump
Pump 5 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Pump 5 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
Pump 5 ISCONNECTED 2 Network_6_IsConnected
Pump 5 SUBNETWORKCONTROLLERNAME Unknown
Pump 5 TIERNAME 0 Network_6_TierName
Pump 5 TIERRANK 0
Pump 5 TERMINALCONFIGURATION Default
Pump 5 SUBNETWORKNAME Unknown
Pump 5 SUPPORTEDSUBNETWORKNAME Unknown
Pump 5 SUPPORTINGSUBNETWORKNAME Unknown
Pump 5 constructionstatus 6 Construction_Status
Pump 5 designtype 0 Stormwater_Pump_Type
Pump 5 exitsystem 0 Stormwater_Exiting_System
Pump 5 lifecyclestatus 2 Lifecycle_Status
Pump 5 maintby 1 Asset_Manager
Pump 5 ownedby 1 Asset_Owner
Pump 5 spatialconfidence 0 Spatial_Confidence
Pump 5 spatialsource 0 Spatial_Source
Pump 5 symbolrotation Symbol_Rotation
Pump 5 VALIDATIONSTATUS 6 Validation Status
Weir 26 ASSETTYPE 0 Asset_Type_Stormwater_Device_Weir
Weir 26 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Weir 26 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
Weir 26 ISCONNECTED 2 Network_6_IsConnected
Weir 26 SUBNETWORKCONTROLLERNAME Unknown
Weir 26 TIERNAME 0 Network_6_TierName
Weir 26 TIERRANK 0
Weir 26 TERMINALCONFIGURATION Default
Weir 26 SUBNETWORKNAME Unknown
Weir 26 SUPPORTEDSUBNETWORKNAME Unknown
Weir 26 SUPPORTINGSUBNETWORKNAME Unknown
Weir 26 constructionstatus 6 Construction_Status
Weir 26 exitsystem 0 Stormwater_Exiting_System
Weir 26 lifecyclestatus 2 Lifecycle_Status
Weir 26 maintby 1 Asset_Manager
Weir 26 orifice 0 Yes_No
Weir 26 ownedby 1 Asset_Owner
Weir 26 permitted 0 Yes_No
Weir 26 spatialconfidence 0 Spatial_Confidence
Weir 26 spatialsource 0 Spatial_Source
Weir 26 surfacewater 0 Yes_No
Weir 26 symbolrotation Symbol_Rotation
Weir 26 wingwall 0 Yes_No
Weir 26 VALIDATIONSTATUS 6 Validation Status
Cleanout 21 ASSETTYPE 0 Asset_Type_Stormwater_Device_Cleanout
Cleanout 21 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Cleanout 21 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
Cleanout 21 ISCONNECTED 2 Network_6_IsConnected
Cleanout 21 SUBNETWORKCONTROLLERNAME Unknown
Cleanout 21 TIERNAME 0 Network_6_TierName
Cleanout 21 TIERRANK 0
Cleanout 21 TERMINALCONFIGURATION Default
Cleanout 21 SUBNETWORKNAME Unknown
Cleanout 21 SUPPORTEDSUBNETWORKNAME Unknown
Cleanout 21 SUPPORTINGSUBNETWORKNAME Unknown
Cleanout 21 constructionstatus 6 Construction_Status
Cleanout 21 diameter 0 Stormwater_Cleanout_Diameter
Cleanout 21 lifecyclestatus 2 Lifecycle_Status
Cleanout 21 maintby 1 Asset_Manager
Cleanout 21 material 0 Stormwater_Cleanout_Material
Cleanout 21 ownedby 1 Asset_Owner
Cleanout 21 spatialconfidence 0 Spatial_Confidence
Cleanout 21 spatialsource 0 Spatial_Source
Cleanout 21 symbolrotation Symbol_Rotation
Cleanout 21 VALIDATIONSTATUS 6 Validation Status
Catch Basin 28 ASSETTYPE 0 Asset_Type_Stormwater_Device_Catch_Basin
Catch Basin 28 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Catch Basin 28 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
Catch Basin 28 ISCONNECTED 2 Network_6_IsConnected
Catch Basin 28 SUBNETWORKCONTROLLERNAME Unknown
Catch Basin 28 TIERNAME 0 Network_6_TierName
Catch Basin 28 TIERRANK 0
Catch Basin 28 TERMINALCONFIGURATION Default
Catch Basin 28 SUBNETWORKNAME Unknown
Catch Basin 28 SUPPORTEDSUBNETWORKNAME Unknown
Catch Basin 28 SUPPORTINGSUBNETWORKNAME Unknown
Catch Basin 28 activevol 0 Event_Level
Catch Basin 28 constructionstatus 6 Construction_Status
Catch Basin 28 designtype 0 Stormwater_Catch_Basin_Opening_Type
Catch Basin 28 exitsystem 0 Stormwater_Exiting_System
Catch Basin 28 inletshape 0 Stormwater_Inlet_Shape
Catch Basin 28 lifecyclestatus 2 Lifecycle_Status
Catch Basin 28 maintby 1 Asset_Manager
Catch Basin 28 material 0 Structure_Sewer_Storm_Materials
Catch Basin 28 ownedby 1 Asset_Owner
Catch Basin 28 signage 0 Yes_No
Catch Basin 28 spatialconfidence 0 Spatial_Confidence
Catch Basin 28 spatialsource 0 Spatial_Source
Catch Basin 28 sump 0 Yes_No
Catch Basin 28 surfacewater 0 Yes_No
Catch Basin 28 symbolrotation Symbol_Rotation
Catch Basin 28 VALIDATIONSTATUS 6 Validation Status
BMP Point 29 ASSETTYPE 0 Asset_Type_Stormwater_Device_BMP_Point
BMP Point 29 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
BMP Point 29 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
BMP Point 29 ISCONNECTED 2 Network_6_IsConnected
BMP Point 29 SUBNETWORKCONTROLLERNAME Unknown
BMP Point 29 TIERNAME 0 Network_6_TierName
BMP Point 29 TIERRANK 0
BMP Point 29 TERMINALCONFIGURATION Default
BMP Point 29 SUBNETWORKNAME Unknown
BMP Point 29 SUPPORTEDSUBNETWORKNAME Unknown
BMP Point 29 SUPPORTINGSUBNETWORKNAME Unknown
BMP Point 29 bmpclass 0 BMP_Class
BMP Point 29 confinedspace 0 Yes_No
BMP Point 29 constructionstatus 6 Construction_Status
BMP Point 29 lifecyclestatus 2 Lifecycle_Status
BMP Point 29 maintby 1 Asset_Manager
BMP Point 29 material 0 Stormwater_BMP_Material
BMP Point 29 observationport 0 Yes_No
BMP Point 29 ownedby 1 Asset_Owner
BMP Point 29 reuse 0 Yes_No
BMP Point 29 spatialconfidence 0 Spatial_Confidence
BMP Point 29 spatialsource 0 Spatial_Source
BMP Point 29 symbolrotation Symbol_Rotation
BMP Point 29 VALIDATIONSTATUS 6 Validation Status
Outlet 22 ASSETTYPE 0 Asset_Type_Stormwater_Device_Outlet
Outlet 22 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Outlet 22 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
Outlet 22 ISCONNECTED 2 Network_6_IsConnected
Outlet 22 SUBNETWORKCONTROLLERNAME Unknown
Outlet 22 TIERNAME 0 Network_6_TierName
Outlet 22 TIERRANK 0
Outlet 22 TERMINALCONFIGURATION Default
Outlet 22 SUBNETWORKNAME Unknown
Outlet 22 SUPPORTEDSUBNETWORKNAME Unknown
Outlet 22 SUPPORTINGSUBNETWORKNAME Unknown
Outlet 22 activevol 0 Event_Level
Outlet 22 constructionstatus 6 Construction_Status
Outlet 22 diameter 0 Stormwater_Outlet_Diameter
Outlet 22 exitsystem 0 Stormwater_Exiting_System
Outlet 22 lifecyclestatus 2 Lifecycle_Status
Outlet 22 location 0 Stormwater_Outlet_Location
Outlet 22 maintby 1 Asset_Manager
Outlet 22 material 0 Stormwater_Outlet_Material
Outlet 22 outfall 0 Yes_No
Outlet 22 ownedby 1 Asset_Owner
Outlet 22 permitted 0 Yes_No
Outlet 22 spatialconfidence 0 Spatial_Confidence
Outlet 22 spatialsource 0 Spatial_Source
Outlet 22 surfacewater 0 Yes_No
Outlet 22 symbolrotation Symbol_Rotation
Outlet 22 VALIDATIONSTATUS 6 Validation Status
BMP Inlet 30 ASSETTYPE 0 Asset_Type_Stormwater_Device_BMP_Inlet
BMP Inlet 30 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
BMP Inlet 30 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
BMP Inlet 30 ISCONNECTED 2 Network_6_IsConnected
BMP Inlet 30 SUBNETWORKCONTROLLERNAME Unknown
BMP Inlet 30 TIERNAME 0 Network_6_TierName
BMP Inlet 30 TIERRANK 0
BMP Inlet 30 TERMINALCONFIGURATION Default
BMP Inlet 30 SUBNETWORKNAME Unknown
BMP Inlet 30 SUPPORTEDSUBNETWORKNAME Unknown
BMP Inlet 30 SUPPORTINGSUBNETWORKNAME Unknown
BMP Inlet 30 constructionstatus 6 Construction_Status
BMP Inlet 30 lifecyclestatus 2 Lifecycle_Status
BMP Inlet 30 maintby 1 Asset_Manager
BMP Inlet 30 ownedby 1 Asset_Owner
BMP Inlet 30 permitted 0 Yes_No
BMP Inlet 30 spatialconfidence 0 Spatial_Confidence
BMP Inlet 30 spatialsource 0 Spatial_Source
BMP Inlet 30 symbolrotation Symbol_Rotation
BMP Inlet 30 VALIDATIONSTATUS 6 Validation Status
Connection 23 ASSETTYPE 0 Asset_Type_Stormwater_Device_Connection
Connection 23 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Connection 23 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
Connection 23 ISCONNECTED 2 Network_6_IsConnected
Connection 23 SUBNETWORKCONTROLLERNAME Unknown
Connection 23 TIERNAME 0 Network_6_TierName
Connection 23 TIERRANK 0
Connection 23 TERMINALCONFIGURATION Default
Connection 23 SUBNETWORKNAME Unknown
Connection 23 SUPPORTEDSUBNETWORKNAME Unknown
Connection 23 SUPPORTINGSUBNETWORKNAME Unknown
Connection 23 activevol 0 Event_Level
Connection 23 constructionstatus 6 Construction_Status
Connection 23 lifecyclestatus 2 Lifecycle_Status
Connection 23 maintby 1 Asset_Manager
Connection 23 ownedby 1 Asset_Owner
Connection 23 spatialconfidence 0 Spatial_Confidence
Connection 23 spatialsource 0 Spatial_Source
Connection 23 symbolrotation Symbol_Rotation
Connection 23 VALIDATIONSTATUS 6 Validation Status
Manhole Channel 32 ASSETTYPE Asset_Type_Stormwater_Device_Manhole_Channel
Manhole Channel 32 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Manhole Channel 32 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
Manhole Channel 32 ISCONNECTED 2 Network_6_IsConnected
Manhole Channel 32 SUBNETWORKCONTROLLERNAME Unknown
Manhole Channel 32 TIERNAME 0 Network_6_TierName
Manhole Channel 32 TIERRANK 0
Manhole Channel 32 TERMINALCONFIGURATION Default
Manhole Channel 32 SUBNETWORKNAME Unknown
Manhole Channel 32 SUPPORTEDSUBNETWORKNAME Unknown
Manhole Channel 32 SUPPORTINGSUBNETWORKNAME Unknown
Manhole Channel 32 constructionstatus 6 Construction_Status
Manhole Channel 32 lifecyclestatus 2 Lifecycle_Status
Manhole Channel 32 maintby 1 Asset_Manager
Manhole Channel 32 ownedby 1 Asset_Owner
Manhole Channel 32 spatialconfidence 0 Spatial_Confidence
Manhole Channel 32 spatialsource 0 Spatial_Source
Manhole Channel 32 symbolrotation Symbol_Rotation
Manhole Channel 32 VALIDATIONSTATUS 6 Validation Status

AttributeRule

ID Minimum Client Version Evaluation Order Name Description Type Batch Insert Trigger Update Trigger Delete Trigger Subtype Field Name Severity Error Number Error Message Editable Enabled Exclude From Client Tags Creation Time Category Check Parameters Script
6 12.6 1 StormwaterDevice-GenerateIDs Generate IDs for StormwaterDevice using database sequences Calculation False True True False assetid True True True 2024-03-18 12:02:57 // Assigned To: StormwaterDevice // Type: Calculation // Name: StormwaterDevice-GenerateIDs // Description: Generate IDs for StormwaterDevice using database sequences // Subtypes: All // Field: assetid // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules are rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated In: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - StructureJunction-GenerateIDs // - StructureBoundary-GenerateIDs // - StormwaterJunction-GenerateIDs // - StormwaterLine-GenerateIDs // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Field in the data model used to store and manage the ID // ** Implementation Note: This value does not need to change if using the industry data model var assigned_to_field = $feature.assetid; // Asset group/Subtype field used to define different IDs per the class // ** Implementation Note: This value does not need to change if using the industry data model var id_selector_value = $feature.assetgroup; // Define the leading text, the trailing text and the delimiter for the ID, this function requires the keyed passed in // NextSequenceValue requires a string literal for copy and paste, although it supports a variable, it is recommended // to not use one // ** Implementation Note: Adjust the prefix and join_char for each subtype. The selector_value_txt is the subtype of the layer function get_id(selector_value) { var id_format = {} var seq_val = null; var selector_value_txt = Text(selector_value) if (selector_value_txt == '5') { id_format = { 'prefix': "Pmp", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_D_Pmp_5_seq'); }else if (selector_value_txt == '26') { id_format = { 'prefix': "Wr", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_D_Wr_26_seq'); }else if (selector_value_txt == '21') { id_format = { 'prefix': "Clnt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_D_Clnt_21_seq'); }else if (selector_value_txt == '28') { id_format = { 'prefix': "Ctch-Bsn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_D_Ctch_Bsn_28_seq'); }else if (selector_value_txt == '29') { id_format = { 'prefix': "BMP-Pnt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_D_BMP_Pnt_29_seq'); }else if (selector_value_txt == '22') { id_format = { 'prefix': "Otlt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_D_Otlt_22_seq'); }else if (selector_value_txt == '30') { id_format = { 'prefix': "BMP-Inlt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_D_BMP_Inlt_30_seq'); }else if (selector_value_txt == '23') { id_format = { 'prefix': "Cnnctn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_D_Cnnctn_23_seq'); }else if (selector_value_txt == '32') { id_format = { 'prefix': "Mnhl-Chnnl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_D_Mnhl_Chnnl_32_seq'); } else { return null; } var id_parts = remove_empty([id_format['prefix'], seq_val, id_format['suffix']]) return Concatenate(id_parts, id_format['join_char']) } // ************* End User Variables Section ************* // ************* Functions ************* function remove_empty(arr) { var new_arr = []; var j = 0; for (var i = 0; i < Count(arr); i++) { if (!IsEmpty(arr[i]) && arr[i] != '') { new_arr[j++] = arr[i]; } } return new_arr; } // ************* End Functions Section ***************** if ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id
7 12.7 2 Device - Set Attributes from Z Update Elevation attribute of a Pipe Connection based on the Geometry Z value. Calculation False True True False Connection True True True 2024-03-18 12:02:57 // Assigned To: StormwaterDevice // Type: Calculation // Name: Device - Set Attributes from Z // Description: Update Elevation attribute of a Pipe Connection based on the Geometry Z value. // Subtypes: Connection // Field: // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - Line - Set Attributes from Z // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups/subtypes // ** Implementation Note: Instead of recreating this rule for each asset type, this rule uses a list of asset types and exits if not valid // If you have added Asset Types, they will need to be added to this list. var asset_type = $feature.assettype; var valid_asset_types = [241]; // Pipe Connection // The attribute fields to update using Z value var elevation = "elevation"; // ************* End User Variables Section ************* // Limit the rule to valid asset groups if (!Includes(valid_asset_types, asset_type)) return; // Get the start and end vertex of the line var current_z = Geometry($feature).z; return {'result': {'attributes': Dictionary(elevation, current_z)}};
8 12.4 3 Device Symbol Rotation Symbol rotation calculation for device features Calculation False True True False symbolrotation True True False 2024-03-18 12:02:57 // Assigned To: StormwaterDevice // Type: Calculation // Name: Device Symbol Rotation // Description: Symbol rotation calculation for device features // Subtypes: All // Field: symbolrotation // Trigger: Insert, Update // Exclude From Client: False // Disable: False // This calculation attribute rule intersects a line layer and based on the number of // intersected features, calculates the angle for the point // Set to true if the rotation setting is set to geographic in the layer properties var geographic_rotation = false; // Set the counter clockwise spin angle used for the symbol in the symbology options var symbol_flip_angle = 0 // Return if a value is already set, to recalculate an angle, the field must be set to null if (IsEmpty($feature.symbolrotation) == false) { return $feature.symbolrotation; } // Create a feature set to the line layer var lineClass = FeatureSetByName($datastore, "{7C039769-C72B-4CE4-B32C-602ABF505582}", ["objectid"], true); // Find the intersecting lines var lines = Intersects(lineClass, $feature); var intersectcount = Count(lines); //If no lines intersect, return the original value if (intersectcount == 0) { return $feature.symbolrotation; } var diff_tol = 5; // Variable to store all found angles var angles = []; var new_segment = null; // Store the features geometry var feature_geometry = Geometry($feature); // Loop over all intersecting lines and find their angles var angle_type; var angle_value; for (var line in lines) { // Buffer and create an extenf of the point by a small amount to extract the segment var clip_area = Extent(Buffer($feature, .01, "meter")); // Clip the line by the extend and get the first line segment var segment = Clip(line, clip_area)["paths"][0]; // The features location is on the start of the line, get the angle from the feature to the end vertex if (Equals(segment[0], feature_geometry)) { angle_type = 'from' angle_value = Round(Angle(feature_geometry, segment[-1]), 0) } // The features location is on the end of the line, create a new segment from the feature to the start vertex else if (Equals(segment[-1], feature_geometry)) { angle_type = 'to' angle_value = Round(Angle(feature_geometry, segment[0]), 0) } // The features location is midspan of the segment, use the angle of the segment else { angle_type = 'mid' angle_value = Round(Angle(segment[0], segment[-1]), 0) } if (geographic_rotation == true) { // Convert Arithmetic to Geographic angle_value = (450 - angle_value) % 360; } // Add 180 to match 0 rotation in the TOC // Add user specified spin angle if their symbol is rotated angle_value = (angle_value + 180 + symbol_flip_angle) % 360; angles[Count(angles)] = {'angle': angle_value, 'type': angle_type}; } // If only one angle, return that value if (Count(angles) == 1) { // If the point is midspan, flip to match symbol as it if was on the end point if (angles[0]['type'] == 'mid') { return (angles[0]['angle'] + 180) % 360; } return angles[0]['angle']; } else if (Count(angles) == 2) { // If the feature is midpan of the first line, return the angle of the second line if (angles[0]['type'] == 'mid') return angles[1]['angle']; // If the feature is midpan of the second line, return the angle of the first line else if (angles[1]['type'] == 'mid') return angles[0]['angle']; // If the feature is at the end point of both lines, return the angle of the first line else if (angles[0]['type'] == 'to' && angles[1]['type'] == 'to') { return angles[0]['angle']; } // If the feature is at the start point of both lines, return the angle of the first line else if (angles[0]['type'] == 'from' && angles[1]['type'] == 'from') { return angles[0]['angle']; } // If the feature is at the start point of the first line and end of the second line, return the second line else if (angles[0]['type'] == 'from') { return angles[1]['angle']; } // If the feature is at the start point of the second line and start of the second line, return the first line return angles[0]['angle']; } else if (Count(angles) == 3) { // Flatten the angles to ignore direction var flat_angle1 = angles[0]['angle'] % 180; var flat_angle2 = angles[1]['angle'] % 180; var flat_angle3 = angles[2]['angle'] % 180; // Create differences between angles var angle_dif_a = Abs(flat_angle1 - flat_angle2); var angle_dif_b = Abs(flat_angle1 - flat_angle3); var angle_dif_c = Abs(flat_angle2 - flat_angle3); // If difference between line 1 and 2 is below the tolerance, meaning the lines follow the same plane, return the // third line if (angle_dif_a <= (diff_tol * 2) || angle_dif_a >= (180 - (diff_tol * 2))) { return angles[2]['angle']; } // If difference between line 1 and 3 is below the tolerance, meaning the lines follow the same plane, return the // second line else if (angle_dif_b <= (diff_tol * 2) || angle_dif_b >= (180 - (diff_tol * 2))) { return angles[1]['angle']; } // If difference between line 2 and 3 is below the tolerance, meaning the lines follow the same plane, return the // first line else if (angle_dif_c <= (diff_tol * 2) || angle_dif_c >= (180 - (diff_tol * 2))) { return angles[0]['angle']; } // Return first if not covered above return angles[0]['angle']; } // All other cases, the first feature is returned else { return angles[0]['angle']; }
9 12.7 1 Device - Check Pipe Connection Run validation on all Pipe Connection features. Validation True False False False Connection 5 5001 Error True True 2024-03-18 12:02:57 // Assigned To: StormwaterDevice // Type: Validation // Name: Device - Check Pipe Connection // Description: Run validation on all Pipe Connection features. // Subtypes: Connection // Error Number: 5001 // Error Message: Error // Severity: 5 // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to specific asset types on $feature. // ** Implementation Note: This rule uses a list of asset types and exits if not valid. Add to list to limit rule to specific asset types. var valid_asset_types = [241]; // The class name of intersecting Pipes (Mains) var pipe_fs = FeatureSetByName($datastore, "{7C039769-C72B-4CE4-B32C-602ABF505582}", [], true); // SQL expression to identify Mains in the StormwaterLine class var pipe_sql = "ASSETGROUP in (4) and ASSETTYPE in (3, 4, 5)"; // The class on containing Sewer Storm Vault / Manhole var vault_class = "StructureJunction"; // SQL expression to identify Sewer Storm Vault / Manhole features in the Structure Junction class var vault_sql = "ASSETGROUP in (208) and ASSETTYPE in (9)"; // ************* End User Variables Section ************* // ************* Functions ************* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_contain_ids(feature) { // Query to get all the container associations var associations = FeatureSetByAssociation(feature, "container"); var container_ids = []; for (var row in associations) { if (row.className == vault_class) { push(container_ids, row.globalId) } } return container_ids } function nearly_equal(a, b, sig_fig) { // check if nearly equal to certain significant figure https://stackoverflow.com/a/558289/12665063 return (a==b || Round(a * Pow(10, sig_fig), 0) == Round(b * Pow(10, sig_fig), 0)) } // ************* End Functions Section ****************** var error_mess = ''; // Limit the rule to valid subtypes if (!Includes(valid_asset_types, $feature.assettype)) { return true; } // Check if container of Vault var contain_ids = get_contain_ids($feature); if (Count(contain_ids) > 0) { var vault_fs = get_features_switch_yard($datastore, vault_class, ["globalid", "assetgroup", "assettype"], false); var filtered = Filter(vault_fs, "GLOBALID in @contain_ids and " + vault_sql); if (Count(filtered) != 1) { error_mess = error_mess + "Pipe Connection must be contained in 1 Sewer Storm Vault. " } } else { error_mess = error_mess + "Pipe Connection must be contained in a Sewer Storm Vault. " } // Intersect with Pipe fs var pipe_feats = Filter(pipe_fs, pipe_sql); var intersect_fs = Intersects(Geometry($feature), pipe_feats); if (IsEmpty(First(intersect_fs))) { error_mess = error_mess + "Pipe Connection must be connected to end of a Pipe. " } else { // if intersects Pipe, make sure intersection is at a begin/endpoint var pt_dict = Dictionary(Text(Geometry($feature))); var count_xyz_match = 0; for (var inter in intersect_fs) { var line = Geometry(inter); var paths = line['paths']; var from_point = paths[0][0]; var to_point = paths[-1][-1]; if (Intersects(Geometry($feature), Point(from_point))) { // Intersects is planar and only checks x y. Need to manually check z. if (HasKey(pt_dict, 'z')) { if (nearly_equal(Number(pt_dict['z']), Number(from_point['z']), 5)) { count_xyz_match ++; } } else {count_xyz_match ++} } else if (Intersects(Geometry($feature), Point(to_point))) { // Intersects is planar and only checks x y. Need to manually check z. if (HasKey(pt_dict, 'z')) { if (nearly_equal(Number(pt_dict['z']), Number(to_point['z']), 5)) { count_xyz_match ++; } } else {count_xyz_match ++} } } if (count_xyz_match == 0) { error_mess = error_mess + `Pipe Connection has x, y, z intersection with ${count_xyz_match} endpoints of a Pipe. Must be snapped to at least 1 endpoint.` } } if (IsEmpty(error_mess)) { return true; } else { return {'errorMessage': error_mess} }

main.ServiceTerritory

Properties

Key Value
Name main.ServiceTerritory
Dataset Type FeatureClass
Feature Dataset main.UtilityNetwork
Dataset ID 5
Geometry Type Polygon
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 13.2
Alias Service Territory
OID Field objectid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field shape
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 535359.3772654124
Y-Min 1579469.3424027413
X-Max 1235091.5522733293
Y-Max 2161016.878124237
Catalog ID {37A76409-6AB8-4ABE-ACB1-FC689826B7C8}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
objectid objectid OID Index False 0 0 8 False True
globalid GLOBALID Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False
shape shape Geometry Index True 0 0 8 True True
st_area(shape) Double Area True 0 0 0 False True
st_perimeter(shape) Double Length True 0 0 0 False True

Index

Name Is Unique Is Ascending Field Name
UUID_9 True True globalid
FDO_objectid True True objectid
st_spindex__ServiceTerritory_shape True True shape

main.StructureJunction__ATTACHREL

Properties

Key Value
Name main.StructureJunction__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 133
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.StructureJunction
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.StructureJunction__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {3F1E5E4D-6C5C-4DA9-9B8B-AC303C899511}
Class ID
Extension Class ID

main.StructureJunction

Properties

Key Value
Name main.StructureJunction
Dataset Type FeatureClass
Feature Dataset main.UtilityNetwork
Dataset ID 35
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 13.2
Alias Structure Junction
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field SHAPE
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 500372.76851501653
Y-Min 1550391.9656166665
X-Max 1270078.1610237253
Y-Max 2190094.2549103117
Catalog ID {4050C86C-CDD4-472A-9987-2D40AEB44CD2}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
SUBNETWORKNAME Subnetwork name String Index False Unknown 0 0 2000 False True
SHAPE Shape Geometry Index False 0 0 8 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
conetype Cone Type Short Integer True 0 0 2 True False
location Manhole Location Short Integer True 0 0 2 True False
surface Manhole Surface Type Short Integer True 0 0 2 True False
covershape Cover Shape Short Integer True 0 0 2 True False
type Cover Type Short Integer True 0 0 2 True False
channel Channel Short Integer True 0 0 2 True False
bench Bench Short Integer True 0 0 2 True False
material Frame Material Short Integer True 0 0 2 True False
wall Wall Short Integer True 0 0 2 True False
numsteps Number of Steps Short Integer True 0 0 2 True False
stepmaterial Step Material Short Integer True 0 0 2 True False
ownedby Owned By Short Integer True Asset_Owner 1 0 0 2 True False
maintby Maintained By Short Integer True Asset_Manager 1 0 0 2 True False
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 2 True False
installdate Install Date Date True 0 0 8 True False
assetid Asset ID String True 0 0 64 True False
notes Notes String True 0 0 2000 True False
surfacewater Receives Surface Water Short Integer True 0 0 2 True False
exitsystem Water Exiting System Short Integer True 0 0 2 True False
rimelev Rim Elevation Double True 0 0 8 True False
invertelev Invert Elevation Double True 0 0 8 True False
depth Depth Double True 0 0 8 True False
highpipeelev High Pipe Elevation Double True 0 0 8 True False
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 2 True False
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 2 True False
wallmaterial Wall Material Short Integer True 0 0 2 True False
manholetype Manhole Type Short Integer True 0 0 2 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False
VALIDATIONSTATUS Validation status Short Integer Index True Validation Status 6 0 0 2 False True

Index

Name Is Unique Is Ascending Field Name
GDB_35_VALIDATIO False True VALIDATIONSTATUS
GDB_35_SUBNETWOR False True SUBNETWORKNAME
UUID_38 True True GLOBALID
FDO_OBJECTID True True OBJECTID
st_spindex__StructureJunction_SHAPE True True SHAPE

Subtype

Name Code Details
Unknown 0
Sewer Storm Vault 208

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 SUBNETWORKNAME Unknown
Unknown 0 VALIDATIONSTATUS 6 Validation Status
Sewer Storm Vault 208 ASSETTYPE 0 Asset_Type_Structure_Junction_Sewer_Storm_Vault
Sewer Storm Vault 208 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Sewer Storm Vault 208 SUBNETWORKNAME Unknown
Sewer Storm Vault 208 bench 0 Yes_No
Sewer Storm Vault 208 channel 0 Yes_No
Sewer Storm Vault 208 conetype 0 Structure_Sewer_Storm_Vault_Manhole_Cone
Sewer Storm Vault 208 constructionstatus 6 Construction_Status
Sewer Storm Vault 208 covershape 0 Structure_Sewer_Storm_Vault_Cover_Shape
Sewer Storm Vault 208 exitsystem 0 Stormwater_Exiting_System
Sewer Storm Vault 208 lifecyclestatus 2 Lifecycle_Status
Sewer Storm Vault 208 location 0 Structure_Sewer_Storm_Vault_Manhole_Location
Sewer Storm Vault 208 maintby 1 Asset_Manager
Sewer Storm Vault 208 manholetype 0 Manhole_Types
Sewer Storm Vault 208 material 0 Structure_Sewer_Storm_Materials
Sewer Storm Vault 208 ownedby 1 Asset_Owner
Sewer Storm Vault 208 spatialconfidence 0 Spatial_Confidence
Sewer Storm Vault 208 spatialsource 0 Spatial_Source
Sewer Storm Vault 208 stepmaterial 0 Structure_Sewer_Storm_Manhole_Step_Material
Sewer Storm Vault 208 surface 0 Structure_Sewer_Storm_Vault_Manhole_Surface
Sewer Storm Vault 208 surfacewater 0 Yes_No
Sewer Storm Vault 208 symbolrotation Symbol_Rotation
Sewer Storm Vault 208 type 0 Structure_Sewer_Storm_Vault_Cover_Type
Sewer Storm Vault 208 wall 0 Yes_No
Sewer Storm Vault 208 wallmaterial 0 Structure_Sewer_Storm_Materials
Sewer Storm Vault 208 VALIDATIONSTATUS 6 Validation Status

AttributeRule

ID Minimum Client Version Evaluation Order Name Description Type Batch Insert Trigger Update Trigger Delete Trigger Subtype Field Name Severity Error Number Error Message Editable Enabled Exclude From Client Tags Creation Time Category Check Parameters Script
1 12.7 1 StructureJunction - Create Manhole Channel When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel. Calculation False True False False Sewer Storm Vault True True True 2024-03-18 12:02:50 // Assigned To: StructureJunction // Type: Calculation // Name: StructureJunction - Create Manhole Channel // Description: When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel. // Subtypes: Sewer Storm Vault // Field: // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset types // ** Implementation Note: Instead of recreating this rule for each asset type, this rules uses a list of domains and exits if not valid var asset_type = $feature.assettype; var valid_asset_types = [9]; // The class name of StormwaterDevice / Manhole Channel var device_class = "StormwaterDevice"; // The Asset Group and Asset Type of a StormwaterDevice / Manhole Channel (non-directional) var manhole_chan_ag = 32; var manhole_chan_at = 301; // ************* End User Variables Section ************* // Limit the rule to valid asset types if (!Includes(valid_asset_types, asset_type)) { return; } var geom = Geometry($feature); var new_manhole_chan = { 'attributes': { 'AssetGroup': manhole_chan_ag, 'AssetType': manhole_chan_at }, 'geometry': geom, 'associationType': 'content', 'isContentVisible': true }; var edit_payload = [{ 'className': device_class, 'adds': [new_manhole_chan] }]; return {"edit": edit_payload};
2 12.6 2 StructureJunction-GenerateIDs Generate IDs for StructureJunction using database sequences Calculation False True True False assetid True True True 2024-03-18 12:02:50 // Assigned To: StructureJunction // Type: Calculation // Name: StructureJunction-GenerateIDs // Description: Generate IDs for StructureJunction using database sequences // Subtypes: All // Field: assetid // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules are rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated In: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - StructureBoundary-GenerateIDs // - StormwaterDevice-GenerateIDs // - StormwaterJunction-GenerateIDs // - StormwaterLine-GenerateIDs // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Field in the data model used to store and manage the ID // ** Implementation Note: This value does not need to change if using the industry data model var assigned_to_field = $feature.assetid; // Asset group/Subtype field used to define different IDs per the class // ** Implementation Note: This value does not need to change if using the industry data model var id_selector_value = $feature.assetgroup; // Define the leading text, the trailing text and the delimiter for the ID, this function requires the keyed passed in // NextSequenceValue requires a string literal for copy and paste, although it supports a variable, it is recommended // to not use one // ** Implementation Note: Adjust the prefix and join_char for each subtype. The selector_value_txt is the subtype of the layer function get_id(selector_value) { var id_format = {} var seq_val = null; var selector_value_txt = Text(selector_value) if (selector_value_txt == '208') { id_format = { 'prefix': "Swr-Strm-Vlt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SJ_Swr_Strm_Vlt_208_seq'); } else { return null; } var id_parts = remove_empty([id_format['prefix'], seq_val, id_format['suffix']]) return Concatenate(id_parts, id_format['join_char']) } // ************* End User Variables Section ************* // ************* Functions ************* function remove_empty(arr) { var new_arr = []; var j = 0; for (var i = 0; i < Count(arr); i++) { if (!IsEmpty(arr[i]) && arr[i] != '') { new_arr[j++] = arr[i]; } } return new_arr; } // ************* End Functions Section ***************** if ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id
3 12.7 3 StructureJunction - Manhole Elevation Attributes Set rim elevation, invert elevation, and depth on Sewer Storm Vault - Manhole from the Z value. Update Manhole Channel content feature z value if needed. Calculation False True True False Sewer Storm Vault True True True 2024-03-18 12:02:50 // Assigned To: StructureJunction // Type: Calculation // Name: StructureJunction - Manhole Elevation Attributes // Description: Set rim elevation, invert elevation, and depth on Sewer Storm Vault - Manhole from the Z value. Update Manhole Channel content feature z value if needed. // Subtypes: Sewer Storm Vault // Field: // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset types // ** Implementation Note: Instead of recreating this rule for each asset type, this rules uses a list of domains and exits if not valid var asset_type = $feature.assettype; var valid_asset_types = [9]; // The rim elevation, invert elevation and depth field names var rimelev_fld = "rimelev"; var invertelev_fld = "invertelev"; var depth_fld = "depth"; var depth = $feature.depth; // The class names of the Manhole Channels // ** Implementation Note: These are just the class/table name and should not be fully qualified. var device_class = "StormwaterDevice"; // Stormwater Device - Manhole Channel sql clause // ** Implementation Note: Sql expression used to find content Manhole Channels to update z value with Invert Elevation value var manhole_chan_sql = 'AssetGroup in (32) and AssetType in (301, 302)'; // ************* End User Variables Section ************* // ************* Functions ************* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_content_manhole_chan() { // find Manhole Channel globalid that is content of $feature var associations = FeatureSetByAssociation($feature, 'content'); var filtered = Filter(associations, "className = @device_class"); var associated_ids = []; for (var row in filtered) { push(associated_ids, row.globalId) } if (Count(associated_ids) < 1) return null; var device_fs = get_features_switch_yard($datastore, device_class, ["globalid", "assetgroup", 'assettype'], true); var content_man_chan = First(Filter(device_fs, "GLOBALID in @associated_ids and " + manhole_chan_sql)); return iif(IsEmpty(content_man_chan), null, content_man_chan) } function update_geom(geo, new_z) { // Set z on point to new value var geo_dict = Dictionary(Text(geo)); geo_dict['z'] = new_z; return Point(drop_nans(geo_dict)) } function drop_nans(dict_with_nans) { // drop any keys with a value of NaN var new_dict = {}; for (var k in dict_with_nans) { if (!IsNan(dict_with_nans[k])) { new_dict[k] = dict_with_nans[k] } } return new_dict } // ************* End Functions Section ****************** // Limit the rule to valid asset types if (!Includes(valid_asset_types, asset_type)) { return; } // Round z to 2 sigfigs var geo_z = Geometry($feature).z; geo_z = Round(geo_z, 2); // build payload to update rim elevation, invert elevation, depth if (IsEmpty(depth)) depth = 0; var res = {"attributes": Dictionary(rimelev_fld, geo_z, invertelev_fld, geo_z - depth, depth_fld, depth)}; var ret = {"result": res}; // Get manhole channel and update z to invertelev var man_chan = get_content_manhole_chan(); if (!IsEmpty(man_chan)) { // if invertelev of Manhole does not match Z of Manhole Channel, update the Manhole Channel if (Geometry(man_chan).z != res["attributes"][invertelev_fld]){ var update_manhole_chan = { "globalid": man_chan.globalid, 'geometry': update_geom(Geometry(man_chan), res["attributes"][invertelev_fld]) }; var edit_payload = [{ 'className': device_class, 'updates': [update_manhole_chan] }]; ret["edit"] = edit_payload } } return ret;
4 12.7 1 StructureJunction - Create Manhole Channel batch When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel. Calculation True False False False Sewer Storm Vault True False True 2024-03-18 12:02:51 // Assigned To: StructureJunction // Type: Calculation // Name: StructureJunction - Create Manhole Channel // Description: When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel. // Subtypes: Sewer Storm Vault // Field: // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset types // ** Implementation Note: Instead of recreating this rule for each asset type, this rules uses a list of domains and exits if not valid var asset_type = $feature.assettype; var valid_asset_types = [9]; // The class name of StormwaterDevice / Manhole Channel var device_class = "StormwaterDevice"; // The Asset Group and Asset Type of a StormwaterDevice / Manhole Channel (non-directional) var manhole_chan_ag = 32; var manhole_chan_at = 301; // ************* End User Variables Section ************* // Limit the rule to valid asset types if (!Includes(valid_asset_types, asset_type)) { return; } var geom = Geometry($feature); var new_manhole_chan = { 'attributes': { 'AssetGroup': manhole_chan_ag, 'AssetType': manhole_chan_at }, 'geometry': geom, 'associationType': 'content', 'isContentVisible': true }; var edit_payload = [{ 'className': device_class, 'adds': [new_manhole_chan] }]; return {"edit": edit_payload};

main.StructureBoundary__ATTACHREL

Properties

Key Value
Name main.StructureBoundary__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 132
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.StructureBoundary
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.StructureBoundary__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {4DC316CF-8B55-49C6-879C-515493554B37}
Class ID
Extension Class ID

main.Network

Properties

Key Value
Name main.Network
Dataset Type UtilityNetwork
Feature Dataset main.UtilityNetwork
Dataset ID 6
Schema Generation 7
Pro Version ArcGIS Pro 3.3.0-beta.2+build.51449
User Identity
Creation Time 2024-03-18 12:00:27
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 500372.76851501653
Y-Min 1550391.9656166665
X-Max 1270078.1610237253
Y-Max 2190094.2549103117
Service Territory main.ServiceTerritory

DomainNetwork

Domain Network Name Domain Network Alias Domain Network ID Tier Definition Subnetwork Controller Type Creation Time
Structure Structure 1 None 2024-03-18 12:00:27
Stormwater Stormwater 2 Partitioned Sink 2024-03-18 12:01:42

Tier

Domain Network Name Tier Group Name Tier Name Tier ID Tier Rank Tier Topology Diagram Templates Supports Disjoint Subnetwork Field Name Edit Mode in Default Edit Mode in Version Update Structures Update Containers Validate Locatability Manage isDirty Creation Time
Stormwater Stormwater Management Area 1 1 Radial True Without Eventing Without Eventing True True False False 2024-03-18 12:01:54

ValidGroupsTypes

Tier Name Source Name Asset Group Asset Type Controller / Aggregated
Stormwater Management Area Device BMP Point Unknown False
Stormwater Management Area Device BMP Point Detention Basin False
Stormwater Management Area Device BMP Point Dry Basin False
Stormwater Management Area Device BMP Point Treatment Vault False
Stormwater Management Area Device BMP Point Wet Basin False
Stormwater Management Area Device BMP Point Bed Filter False
Stormwater Management Area Device BMP Point Infiltration Basin False
Stormwater Management Area Device BMP Point Media Filter False
Stormwater Management Area Device BMP Point Bio-Filtration False
Stormwater Management Area Device BMP Point Bio-Retention False
Stormwater Management Area Device BMP Point Bioswale False
Stormwater Management Area Device BMP Point Filtration Device False
Stormwater Management Area Device BMP Point Infiltration Feature False
Stormwater Management Area Device BMP Point Pervious Pavement False
Stormwater Management Area Device BMP Point Sediment Trap False
Stormwater Management Area Device BMP Point Settling Basin False
Stormwater Management Area Device BMP Point Green Roof False
Stormwater Management Area Device BMP Point Retention Basin False
Stormwater Management Area Device Cleanout Unknown False
Stormwater Management Area Device Cleanout Cleanout False
Stormwater Management Area Device Pump Unknown False
Stormwater Management Area Device Pump Pump False
Stormwater Management Area Device Weir Unknown False
Stormwater Management Area Device Weir Broad-Crested False
Stormwater Management Area Device Weir Combination False
Stormwater Management Area Device Weir Labyrinth False
Stormwater Management Area Device Weir Minimum Energy Loss False
Stormwater Management Area Device Weir Sharp-Crested False
Stormwater Management Area Device Weir V-Notch False
Stormwater Management Area Device Catch Basin Unknown False
Stormwater Management Area Device Catch Basin Infiltration False
Stormwater Management Area Device Catch Basin Sediment Trap False
Stormwater Management Area Device Catch Basin Drop Inlet False
Stormwater Management Area Device BMP Inlet Unknown False
Stormwater Management Area Device BMP Inlet Apron Inlet False
Stormwater Management Area Device BMP Inlet Pipe Inlet False
Stormwater Management Area Device BMP Inlet Channel Inlet False
Stormwater Management Area Device Outlet Unknown False
Stormwater Management Area Device Outlet Pipe Outlet True
Stormwater Management Area Device Outlet Tide Gate Chamber False
Stormwater Management Area Device Outlet Apron Outlet True
Stormwater Management Area Device Outlet Flap Gate True
Stormwater Management Area Device Outlet Riser False
Stormwater Management Area Device Connection Unknown False
Stormwater Management Area Device Connection Pipe Connection False
Stormwater Management Area Device Connection Open Channel Connection False
Stormwater Management Area Device Connection Linear Drain Connection False
Stormwater Management Area Device Manhole Channel Unknown False
Stormwater Management Area Device Manhole Channel Manhole Channel False
Stormwater Management Area Device Manhole Channel Directional Manhole Channel False
Stormwater Management Area Line Pipe Unknown True
Stormwater Management Area Line Pipe Gravity Pipe True
Stormwater Management Area Line Pipe Force Pipe True
Stormwater Management Area Line Pipe Perforated Pipe True
Stormwater Management Area Line Open Channel Unknown True
Stormwater Management Area Line Open Channel Aquaduct Channel True
Stormwater Management Area Line Open Channel Spillway Channel True
Stormwater Management Area Line Open Channel Natural Channel True
Stormwater Management Area Line Open Channel Ditch Channel True
Stormwater Management Area Line Open Channel Roadside Gutter True
Stormwater Management Area Line Culvert Unknown True
Stormwater Management Area Line Culvert Pipe Culvert True
Stormwater Management Area Line Culvert Pipe Arch True
Stormwater Management Area Line Culvert Box Culvert True
Stormwater Management Area Line Culvert Arch Culvert True
Stormwater Management Area Line Culvert Bridge Culvert True
Stormwater Management Area Line Linear Drain Trench Drain True
Stormwater Management Area Line Linear Drain Slotted Drain True
Stormwater Management Area Junction Wall Unknown
Stormwater Management Area Junction Wall Endwall
Stormwater Management Area Junction Wall Headwall
Stormwater Management Area Junction Wall Wingwall
Stormwater Management Area Junction Wall Floodwall

TierTraceConfiguration

Tier Name Include Containers Include Content Include Structures Include Barriers Validate Locatability Traversability Scope
Stormwater Management Area True True True True False junctionsAndEdges

Condition

Tier Name Network Attribute / Category Operator Value Combine Using Or
Stormwater Management Area Lifecycle Status Does Not Include Any 6 True
Stormwater Management Area S:Activate Value Greater Than 0 False

Source

Domain Network Name Source Name Table Usage Type Source ID # of Asset Groups # of Asset Types
Structure StructureJunction main.StructureJunction Structure Junction 4 2 3
Structure StructureBoundary main.StructureBoundary Structure Boundary 6 3 21
Structure StructureJunctionObject main.StructureJunctionObject Structure Junction Object 7 1 1
Structure StructureLine main.StructureLine Structure Line 5 1 1
Structure StructureEdgeObject main.StructureEdgeObject Structure Edge Object 8 1 1
Stormwater StormwaterDevice main.StormwaterDevice Device 9 10 51
Stormwater StormwaterAssembly main.StormwaterAssembly Assembly 11 1 1
Stormwater StormwaterJunction main.StormwaterJunction Junction 12 2 6
Stormwater StormwaterJunctionObject main.StormwaterJunctionObject Junction Object 14 1 1
Stormwater StormwaterLine main.StormwaterLine Line 10 5 20
Stormwater StormwaterSubnetLine main.StormwaterSubnetLine Subnet Line 13 2 0
Stormwater StormwaterEdgeObject main.StormwaterEdgeObject Edge Object 15 1 1

AssetGroup

Source Name Asset Group Name Asset Group Code # of Asset Types Creation Time
StructureJunction Unknown 0 1 2024-03-18 12:00:28
StructureJunction Sewer Storm Vault 208 2 2024-03-18 12:01:57
StructureBoundary Unknown 0 1 2024-03-18 12:00:28
StructureBoundary BMP Boundary 401 18 2024-03-18 12:01:59
StructureBoundary Storm Lift Station Boundary 404 2 2024-03-18 12:01:59
StructureJunctionObject Unknown 0 1 2024-03-18 12:00:28
StructureLine Unknown 0 1 2024-03-18 12:00:28
StructureEdgeObject Unknown 0 1 2024-03-18 12:00:28
StormwaterDevice Unknown 0 1 2024-03-18 12:01:43
StormwaterDevice Pump 5 2 2024-03-18 12:02:03
StormwaterDevice Weir 26 7 2024-03-18 12:02:03
StormwaterDevice Cleanout 21 2 2024-03-18 12:02:03
StormwaterDevice Catch Basin 28 4 2024-03-18 12:02:03
StormwaterDevice BMP Point 29 18 2024-03-18 12:02:03
StormwaterDevice Outlet 22 6 2024-03-18 12:02:03
StormwaterDevice BMP Inlet 30 4 2024-03-18 12:02:03
StormwaterDevice Connection 23 4 2024-03-18 12:02:03
StormwaterDevice Manhole Channel 32 3 2024-03-18 12:02:03
StormwaterAssembly Unknown 0 1 2024-03-18 12:01:43
StormwaterJunction Unknown 0 1 2024-03-18 12:01:43
StormwaterJunction Wall 23 5 2024-03-18 12:02:09
StormwaterJunctionObject Unknown 0 1 2024-03-18 12:01:43
StormwaterLine Unknown 0 1 2024-03-18 12:01:43
StormwaterLine Pipe 4 4 2024-03-18 12:02:12
StormwaterLine Open Channel 5 6 2024-03-18 12:02:12
StormwaterLine Culvert 6 6 2024-03-18 12:02:12
StormwaterLine Linear Drain 7 3 2024-03-18 12:02:12
StormwaterSubnetLine Unknown 0 0 2024-03-18 12:01:43
StormwaterSubnetLine Stormwater Management Area 1 0 2024-03-18 12:01:57
StormwaterEdgeObject Unknown 0 1 2024-03-18 12:01:43

AssetType

Source Name Asset Group Name Asset Type Name Asset Group Code Asset Type Code Terminal Configuration Association Role Delete Type Containment Scale Split Content Connectivity Policy Network Categories Creation Time
StructureJunction Unknown Unknown 0 0 2024-03-18 12:00:28
StructureJunction Sewer Storm Vault Unknown 208 0 Container Restricted 10 2024-03-18 12:01:57
StructureJunction Sewer Storm Vault Manhole 208 9 Container Restricted 10 2024-03-18 12:01:57
StructureBoundary Unknown Unknown 0 0 2024-03-18 12:00:28
StructureBoundary BMP Boundary Unknown 401 0 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Detention Basin 401 2 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Dry Basin 401 3 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Treatment Vault 401 6 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Wet Basin 401 7 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Bed Filter 401 8 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Infiltration Basin 401 9 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Media Filter 401 10 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Bio-Filtration 401 21 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Bio-Retention 401 22 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Bioswale 401 23 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Filtration Device 401 24 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Infiltration Feature 401 25 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Pervious Pavement 401 26 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Sediment Trap 401 27 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Settling Basin 401 28 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Green Roof 401 29 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary BMP Boundary Retention Basin 401 30 Container Restricted 500 2024-03-18 12:01:59
StructureBoundary Storm Lift Station Boundary Unknown 404 0 Container Restricted 50 2024-03-18 12:01:59
StructureBoundary Storm Lift Station Boundary Lift Station 404 42 Container Restricted 50 2024-03-18 12:01:59
StructureJunctionObject Unknown Unknown 0 0 2024-03-18 12:00:28
StructureLine Unknown Unknown 0 0 2024-03-18 12:00:28
StructureEdgeObject Unknown Unknown 0 0 2024-03-18 12:00:28
StormwaterDevice Unknown Unknown 0 0 2024-03-18 12:01:43
StormwaterDevice Pump Unknown 5 0 Container Restricted 50 2024-03-18 12:02:03
StormwaterDevice Pump Pump 5 61 Pressure Increasing Container Restricted 50 2024-03-18 12:02:03
StormwaterDevice Weir Unknown 26 0 2024-03-18 12:02:03
StormwaterDevice Weir Broad-Crested 26 281 2024-03-18 12:02:03
StormwaterDevice Weir Combination 26 282 2024-03-18 12:02:03
StormwaterDevice Weir Labyrinth 26 283 2024-03-18 12:02:03
StormwaterDevice Weir Minimum Energy Loss 26 284 2024-03-18 12:02:03
StormwaterDevice Weir Sharp-Crested 26 285 2024-03-18 12:02:03
StormwaterDevice Weir V-Notch 26 286 2024-03-18 12:02:03
StormwaterDevice Cleanout Unknown 21 0 2024-03-18 12:02:03
StormwaterDevice Cleanout Cleanout 21 1 2024-03-18 12:02:03
StormwaterDevice Catch Basin Unknown 28 0 Container Restricted 10 2024-03-18 12:02:03
StormwaterDevice Catch Basin Infiltration 28 204 Container Restricted 10 2024-03-18 12:02:03
StormwaterDevice Catch Basin Sediment Trap 28 205 Container Restricted 10 2024-03-18 12:02:03
StormwaterDevice Catch Basin Drop Inlet 28 210 Container Restricted 10 2024-03-18 12:02:03
StormwaterDevice BMP Point Unknown 29 0 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Detention Basin 29 2 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Dry Basin 29 3 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Treatment Vault 29 6 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Wet Basin 29 7 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Bed Filter 29 8 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Infiltration Basin 29 9 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Media Filter 29 10 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Bio-Filtration 29 21 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Bio-Retention 29 22 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Bioswale 29 23 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Filtration Device 29 24 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Infiltration Feature 29 25 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Pervious Pavement 29 26 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Sediment Trap 29 27 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Settling Basin 29 28 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Green Roof 29 29 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice BMP Point Retention Basin 29 30 Container Restricted 500 2024-03-18 12:02:03
StormwaterDevice Outlet Unknown 22 0 2024-03-18 12:02:03
StormwaterDevice Outlet Pipe Outlet 22 5 Directional Dual Terminal Subnetwork Controller 2024-03-18 12:02:03
StormwaterDevice Outlet Tide Gate Chamber 22 9 2024-03-18 12:02:03
StormwaterDevice Outlet Apron Outlet 22 10 Directional Dual Terminal Subnetwork Controller 2024-03-18 12:02:03
StormwaterDevice Outlet Flap Gate 22 11 Directional Dual Terminal Subnetwork Controller 2024-03-18 12:02:03
StormwaterDevice Outlet Riser 22 12 2024-03-18 12:02:03
StormwaterDevice BMP Inlet Unknown 30 0 2024-03-18 12:02:03
StormwaterDevice BMP Inlet Apron Inlet 30 6 2024-03-18 12:02:03
StormwaterDevice BMP Inlet Pipe Inlet 30 7 2024-03-18 12:02:03
StormwaterDevice BMP Inlet Channel Inlet 30 8 2024-03-18 12:02:03
StormwaterDevice Connection Unknown 23 0 2024-03-18 12:02:04
StormwaterDevice Connection Pipe Connection 23 241 2024-03-18 12:02:04
StormwaterDevice Connection Open Channel Connection 23 242 2024-03-18 12:02:04
StormwaterDevice Connection Linear Drain Connection 23 245 2024-03-18 12:02:04
StormwaterDevice Manhole Channel Unknown 32 0 2024-03-18 12:02:04
StormwaterDevice Manhole Channel Manhole Channel 32 301 2024-03-18 12:02:04
StormwaterDevice Manhole Channel Directional Manhole Channel 32 302 Directional Manhole Terminal Subnetwork Controller 2024-03-18 12:02:04
StormwaterAssembly Unknown Unknown 0 0 2024-03-18 12:01:43
StormwaterJunction Unknown Unknown 0 0 2024-03-18 12:01:43
StormwaterJunction Wall Unknown 23 0 2024-03-18 12:02:09
StormwaterJunction Wall Endwall 23 81 2024-03-18 12:02:09
StormwaterJunction Wall Headwall 23 82 2024-03-18 12:02:09
StormwaterJunction Wall Wingwall 23 83 2024-03-18 12:02:09
StormwaterJunction Wall Floodwall 23 84 2024-03-18 12:02:09
StormwaterJunctionObject Unknown Unknown 0 0 2024-03-18 12:01:43
StormwaterLine Unknown Unknown 0 0 2024-03-18 12:01:43
StormwaterLine Pipe Unknown 4 0 2024-03-18 12:02:12
StormwaterLine Pipe Gravity Pipe 4 3 Any Vertex 2024-03-18 12:02:12
StormwaterLine Pipe Force Pipe 4 4 Any Vertex 2024-03-18 12:02:12
StormwaterLine Pipe Perforated Pipe 4 5 Any Vertex 2024-03-18 12:02:12
StormwaterLine Open Channel Unknown 5 0 2024-03-18 12:02:12
StormwaterLine Open Channel Aquaduct Channel 5 43 Any Vertex 2024-03-18 12:02:12
StormwaterLine Open Channel Spillway Channel 5 44 Any Vertex 2024-03-18 12:02:12
StormwaterLine Open Channel Natural Channel 5 45 Any Vertex 2024-03-18 12:02:12
StormwaterLine Open Channel Ditch Channel 5 46 Any Vertex 2024-03-18 12:02:12
StormwaterLine Open Channel Roadside Gutter 5 47 Any Vertex 2024-03-18 12:02:12
StormwaterLine Culvert Unknown 6 0 2024-03-18 12:02:12
StormwaterLine Culvert Pipe Culvert 6 81 Any Vertex 2024-03-18 12:02:12
StormwaterLine Culvert Pipe Arch 6 82 Any Vertex 2024-03-18 12:02:12
StormwaterLine Culvert Box Culvert 6 83 Any Vertex 2024-03-18 12:02:12
StormwaterLine Culvert Arch Culvert 6 84 Any Vertex 2024-03-18 12:02:12
StormwaterLine Culvert Bridge Culvert 6 85 Any Vertex 2024-03-18 12:02:12
StormwaterLine Linear Drain Unknown 7 0 2024-03-18 12:02:12
StormwaterLine Linear Drain Trench Drain 7 121 Any Vertex 2024-03-18 12:02:12
StormwaterLine Linear Drain Slotted Drain 7 122 Any Vertex 2024-03-18 12:02:12
StormwaterEdgeObject Unknown Unknown 0 0 2024-03-18 12:01:43

NetworkCategory

Category Name Creation Time
Subnetwork Controller 2024-03-18 12:00:27
Subnetwork Tap 2024-03-18 12:00:27
Attribute Substitution 2024-03-18 12:00:27

TerminalConfiguration

Configuration Name Configuration ID Traversability Model Default Creation Time
Single terminal 0 Bidirectional All 2024-03-18 12:00:27
Pressure Reducing 2 Directional All 2024-03-18 12:02:22
Pressure Increasing 3 Directional All 2024-03-18 12:02:22
Directional Dual Terminal 4 Directional All 2024-03-18 12:02:22
Bidirectional Dual Terminal 5 Bidirectional All 2024-03-18 12:02:22
Directional Manhole Terminal 6 Directional All 2024-03-18 12:02:22

Terminal

Configuration Name Terminal Name Terminal ID Upstream
Single terminal Single Terminal 1
Pressure Reducing High Pressure In 2 True
Pressure Reducing Low Pressure Out 3 False
Pressure Increasing Low Pressure In 4 True
Pressure Increasing High Pressure Out 5 False
Directional Dual Terminal Inlet Port 6 True
Directional Dual Terminal Outlet Port 7 False
Bidirectional Dual Terminal Port One 8
Bidirectional Dual Terminal Port Two 9
Directional Manhole Terminal Upstream 10 True
Directional Manhole Terminal Upstream 2 11 True
Directional Manhole Terminal Downstream 12 False
Directional Manhole Terminal Downstream 2 13 False

TerminalPath

Configuration Name Path Name Path ID Path Description
Directional Manhole Terminal All 1 All
Directional Manhole Terminal D-D2 2 Downstream-Downstream 2

NetworkAttribute

Name ID Usage Type Data Type Field Type Inline Domain Name Nullable Apportionable Substitution Attribute Bit Position Bit Size Junction ID Edge ID Creation Time
Source ID 1 Source ID Integer Short Integer True False False 0 7 1 2 2024-03-18 12:00:27
Terminal ID 2 Terminal ID Integer Short Integer False False False 7 0 3 4 2024-03-18 12:00:27
Asset group 3 Asset Group Integer Short Integer True False False 7 10 5 6 2024-03-18 12:00:27
Asset type 4 Asset Type Integer Short Integer True False False 17 10 7 8 2024-03-18 12:00:27
Is subnetwork controller 5 Is Subnetwork Controller Integer Short Integer True False False 27 1 9 10 2024-03-18 12:00:27
Tier name 6 Tier Name Integer Short Integer True False False 28 6 11 12 2024-03-18 12:00:27
Shape length 7 Shape Length Double Double False False True 34 0 13 14 2024-03-18 12:00:27
Position from 8 Position From Double Double False False False 34 0 15 16 2024-03-18 12:00:27
Position to 9 Position To Double Double False False False 34 0 17 18 2024-03-18 12:00:27
Flow direction 10 Flow Direction Integer Short Integer True False False 34 2 19 20 2024-03-18 12:00:27
Lifecycle Status 11 Unknown Integer Short Integer True Lifecycle_Combined False False 36 3 21 22 2024-03-18 12:02:22
Outfall 12 Unknown Integer Short Integer False True False 0 0 23 24 2024-03-18 12:02:22
S:Activate Value 13 Unknown Integer Short Integer False False False 0 0 25 26 2024-03-18 12:02:22
Construction Status 14 Unknown Integer Short Integer False True False 0 0 27 28 2024-03-18 12:02:22

NetworkAttributeAssignment

Network Attribute Name Source Name Field Name
Asset group main.StructureJunction ASSETGROUP
Asset group main.StructureLine ASSETGROUP
Asset group main.StructureBoundary ASSETGROUP
Asset group main.StructureJunctionObject ASSETGROUP
Asset group main.StructureEdgeObject ASSETGROUP
Asset group main.StormwaterDevice ASSETGROUP
Asset group main.StormwaterLine ASSETGROUP
Asset group main.StormwaterAssembly ASSETGROUP
Asset group main.StormwaterJunction ASSETGROUP
Asset group main.StormwaterJunctionObject ASSETGROUP
Asset group main.StormwaterEdgeObject ASSETGROUP
Asset type main.StructureJunction ASSETTYPE
Asset type main.StructureLine ASSETTYPE
Asset type main.StructureBoundary ASSETTYPE
Asset type main.StructureJunctionObject ASSETTYPE
Asset type main.StructureEdgeObject ASSETTYPE
Asset type main.StormwaterDevice ASSETTYPE
Asset type main.StormwaterLine ASSETTYPE
Asset type main.StormwaterAssembly ASSETTYPE
Asset type main.StormwaterJunction ASSETTYPE
Asset type main.StormwaterJunctionObject ASSETTYPE
Asset type main.StormwaterEdgeObject ASSETTYPE
Is subnetwork controller main.StormwaterDevice ISSUBNETWORKCONTROLLER
Is subnetwork controller main.StormwaterJunctionObject ISSUBNETWORKCONTROLLER
Tier name main.StormwaterDevice TIERNAME
Tier name main.StormwaterJunctionObject TIERNAME
Shape length main.StructureLine st_length(SHAPE)
Shape length main.StormwaterLine st_length(SHAPE)
Flow direction main.StructureLine FLOWDIRECTION
Flow direction main.StructureEdgeObject FLOWDIRECTION
Flow direction main.StormwaterLine FLOWDIRECTION
Flow direction main.StormwaterEdgeObject FLOWDIRECTION
Lifecycle Status main.StructureBoundary lifecyclestatus
Lifecycle Status main.StructureJunction lifecyclestatus
Lifecycle Status main.StructureLine lifecyclestatus
Lifecycle Status main.StormwaterAssembly lifecyclestatus
Lifecycle Status main.StormwaterDevice lifecyclestatus
Lifecycle Status main.StormwaterJunction lifecyclestatus
Lifecycle Status main.StormwaterLine lifecyclestatus
Lifecycle Status main.StructureJunctionObject lifecyclestatus
Lifecycle Status main.StructureEdgeObject lifecyclestatus
Lifecycle Status main.StormwaterJunctionObject lifecyclestatus
Lifecycle Status main.StormwaterEdgeObject lifecyclestatus
Outfall main.StormwaterDevice outfall
S:Activate Value main.StormwaterDevice activevol
Construction Status main.StructureJunctionObject constructionstatus
Construction Status main.StructureEdgeObject constructionstatus
Construction Status main.StormwaterJunctionObject constructionstatus
Construction Status main.StormwaterEdgeObject constructionstatus
Construction Status main.StormwaterJunction constructionstatus
Construction Status main.StormwaterAssembly constructionstatus
Construction Status main.StormwaterLine constructionstatus
Construction Status main.StormwaterDevice constructionstatus
Construction Status main.StructureBoundary constructionstatus
Construction Status main.StructureLine constructionstatus
Construction Status main.StructureJunction constructionstatus

main.StormwaterJunction__ATTACHREL

Properties

Key Value
Name main.StormwaterJunction__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 128
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.StormwaterJunction
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.StormwaterJunction__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {77710766-C24E-40C9-B295-CAB38367CF7E}
Class ID
Extension Class ID

main.StormwaterLine

Properties

Key Value
Name main.StormwaterLine
Dataset Type FeatureClass
Feature Dataset main.UtilityNetwork
Dataset ID 104
Geometry Type Polyline
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 13.2
Alias Stormwater Line
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field SHAPE
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 500372.76851501653
Y-Min 1550391.9656166665
X-Max 1270078.1610237253
Y-Max 2190094.2549103117
Catalog ID {7C039769-C72B-4CE4-B32C-602ABF505582}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
ISCONNECTED Is connected Short Integer False Network_6_IsConnected 2 0 0 2 False True
FROMDEVICETERMINAL From device terminal Short Integer False Network_6_TerminalNames 0 0 0 2 True True
TODEVICETERMINAL To device terminal Short Integer False Network_6_TerminalNames 0 0 0 2 True True
FLOWDIRECTION Flow direction Short Integer True Network_6_FlowDirection 1 0 0 2 True True
SHAPE Shape Geometry Index False 0 0 8 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
SUBNETWORKNAME Subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTEDSUBNETWORKNAME Supported subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTINGSUBNETWORKNAME Supporting subnetwork name String Index False Unknown 0 0 2000 False True
diameter Diameter Double True 0 0 8 True False
upelev Upstream Elevation Double True 0 0 8 True False
downelev Downstream Elevation Double True 0 0 8 True False
slope Slope Double True 0 0 8 True False
installdate Install Date Date True 0 0 8 True False
ownedby Owned By Short Integer True Asset_Owner 1 0 0 2 True False
maintby Maintained By Short Integer True Asset_Manager 1 0 0 2 True False
pipeshape Culvert Shape, Pipe Shape Short Integer True 0 0 2 True False
type Type Short Integer True 0 0 2 True False
lined Lined? Short Integer True 0 0 2 True False
lineryear Liner Year Short Integer True 0 0 2 True False
linermethod Liner Method Short Integer True 0 0 2 True False
assetid Asset ID String True 0 0 64 True False
notes Notes String True 0 0 2000 True False
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 2 True False
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 2 True False
material Material Short Integer True 0 0 2 True False
width Width Double True 0 0 8 True False
height Height Double True 0 0 8 True False
wall Wall Short Integer True 0 0 2 True False
measuredlength Measured Length Double True 0 0 8 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False
VALIDATIONSTATUS Validation status Short Integer Index True Validation Status 6 0 0 2 False True
st_length(SHAPE) shape_Length Double Length True 0 0 0 False True

Index

Name Is Unique Is Ascending Field Name
GDB_104_VALIDATI False True VALIDATIONSTATUS
GDB_104_SUBNETWO False True SUBNETWORKNAME
GDB_104_SUPPORTE False True SUPPORTEDSUBNETWORKNAME
GDB_104_SUPPORTI False True SUPPORTINGSUBNETWORKNAME
UUID_44 True True GLOBALID
FDO_OBJECTID True True OBJECTID
st_spindex__StormwaterLine_SHAPE True True SHAPE

Subtype

Name Code Details
Unknown 0
Pipe 4
Open Channel 5
Culvert 6
Linear Drain 7

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 ISCONNECTED 2 Network_6_IsConnected
Unknown 0 FROMDEVICETERMINAL 0 Network_6_TerminalNames
Unknown 0 TODEVICETERMINAL 0 Network_6_TerminalNames
Unknown 0 FLOWDIRECTION 1 Network_6_FlowDirection
Unknown 0 SUBNETWORKNAME Unknown
Unknown 0 SUPPORTEDSUBNETWORKNAME Unknown
Unknown 0 SUPPORTINGSUBNETWORKNAME Unknown
Unknown 0 VALIDATIONSTATUS 6 Validation Status
Pipe 4 ASSETTYPE 0 Asset_Type_Stormwater_Line_Pipe
Pipe 4 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Pipe 4 ISCONNECTED 2 Network_6_IsConnected
Pipe 4 FROMDEVICETERMINAL 0 Network_6_TerminalNames
Pipe 4 TODEVICETERMINAL 0 Network_6_TerminalNames
Pipe 4 FLOWDIRECTION 1 Network_6_FlowDirection
Pipe 4 SUBNETWORKNAME Unknown
Pipe 4 SUPPORTEDSUBNETWORKNAME Unknown
Pipe 4 SUPPORTINGSUBNETWORKNAME Unknown
Pipe 4 constructionstatus 6 Construction_Status
Pipe 4 diameter 0 Stormwater_Pipe_Diameter
Pipe 4 lifecyclestatus 2 Lifecycle_Status
Pipe 4 lined 0 Yes_No
Pipe 4 linermethod 0 Stormwater_Pipe_Liner_Method
Pipe 4 lineryear Stormwater_Pipe_Liner_Year
Pipe 4 maintby 1 Asset_Manager
Pipe 4 material 0 Stormwater_Pipe_Material
Pipe 4 ownedby 1 Asset_Owner
Pipe 4 pipeshape 0 Stormwater_Pipe_Shape
Pipe 4 spatialconfidence 0 Spatial_Confidence
Pipe 4 spatialsource 0 Spatial_Source
Pipe 4 VALIDATIONSTATUS 6 Validation Status
Open Channel 5 ASSETTYPE 0 Asset_Type_Stormwater_Line_Open_Channel
Open Channel 5 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Open Channel 5 ISCONNECTED 2 Network_6_IsConnected
Open Channel 5 FROMDEVICETERMINAL 0 Network_6_TerminalNames
Open Channel 5 TODEVICETERMINAL 0 Network_6_TerminalNames
Open Channel 5 FLOWDIRECTION 1 Network_6_FlowDirection
Open Channel 5 SUBNETWORKNAME Unknown
Open Channel 5 SUPPORTEDSUBNETWORKNAME Unknown
Open Channel 5 SUPPORTINGSUBNETWORKNAME Unknown
Open Channel 5 constructionstatus 6 Construction_Status
Open Channel 5 lifecyclestatus 2 Lifecycle_Status
Open Channel 5 maintby 1 Asset_Manager
Open Channel 5 ownedby 1 Asset_Owner
Open Channel 5 spatialconfidence 0 Spatial_Confidence
Open Channel 5 spatialsource 0 Spatial_Source
Open Channel 5 type 0 Stormwater_Open_Channel_Type
Open Channel 5 VALIDATIONSTATUS 6 Validation Status
Culvert 6 ASSETTYPE 0 Asset_Type_Stormwater_Line_Culvert
Culvert 6 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Culvert 6 ISCONNECTED 2 Network_6_IsConnected
Culvert 6 FROMDEVICETERMINAL 0 Network_6_TerminalNames
Culvert 6 TODEVICETERMINAL 0 Network_6_TerminalNames
Culvert 6 FLOWDIRECTION 1 Network_6_FlowDirection
Culvert 6 SUBNETWORKNAME Unknown
Culvert 6 SUPPORTEDSUBNETWORKNAME Unknown
Culvert 6 SUPPORTINGSUBNETWORKNAME Unknown
Culvert 6 constructionstatus 6 Construction_Status
Culvert 6 lifecyclestatus 2 Lifecycle_Status
Culvert 6 maintby 1 Asset_Manager
Culvert 6 material 0 Stormwater_Pipe_Material
Culvert 6 ownedby 1 Asset_Owner
Culvert 6 pipeshape 0 Stormwater_Culvert_Shape
Culvert 6 spatialconfidence 0 Spatial_Confidence
Culvert 6 spatialsource 0 Spatial_Source
Culvert 6 wall 0 Yes_No
Culvert 6 VALIDATIONSTATUS 6 Validation Status
Linear Drain 7 ASSETTYPE 0 Asset_Type_Stormwater_Line_Linear_Drain
Linear Drain 7 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Linear Drain 7 ISCONNECTED 2 Network_6_IsConnected
Linear Drain 7 FROMDEVICETERMINAL 0 Network_6_TerminalNames
Linear Drain 7 TODEVICETERMINAL 0 Network_6_TerminalNames
Linear Drain 7 FLOWDIRECTION 1 Network_6_FlowDirection
Linear Drain 7 SUBNETWORKNAME Unknown
Linear Drain 7 SUPPORTEDSUBNETWORKNAME Unknown
Linear Drain 7 SUPPORTINGSUBNETWORKNAME Unknown
Linear Drain 7 constructionstatus 6 Construction_Status
Linear Drain 7 diameter 0 Stormwater_Pipe_Diameter
Linear Drain 7 lifecyclestatus 2 Lifecycle_Status
Linear Drain 7 maintby 1 Asset_Manager
Linear Drain 7 material 0 Stormwater_Pipe_Material
Linear Drain 7 ownedby 1 Asset_Owner
Linear Drain 7 spatialconfidence 0 Spatial_Confidence
Linear Drain 7 spatialsource 0 Spatial_Source
Linear Drain 7 VALIDATIONSTATUS 6 Validation Status

AttributeRule

ID Minimum Client Version Evaluation Order Name Description Type Batch Insert Trigger Update Trigger Delete Trigger Subtype Field Name Severity Error Number Error Message Editable Enabled Exclude From Client Tags Creation Time Category Check Parameters Script
12 12.6 1 StormwaterLine-GenerateIDs Generate IDs for StormwaterLine using database sequences Calculation False True True False assetid True True True 2024-03-18 12:03:02 // Assigned To: StormwaterLine // Type: Calculation // Name: StormwaterLine-GenerateIDs // Description: Generate IDs for StormwaterLine using database sequences // Subtypes: All // Field: assetid // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules are rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated In: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - StructureJunction-GenerateIDs // - StructureBoundary-GenerateIDs // - StormwaterDevice-GenerateIDs // - StormwaterJunction-GenerateIDs // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Field in the data model used to store and manage the ID // ** Implementation Note: This value does not need to change if using the industry data model var assigned_to_field = $feature.assetid; // Asset group/Subtype field used to define different IDs per the class // ** Implementation Note: This value does not need to change if using the industry data model var id_selector_value = $feature.assetgroup; // Define the leading text, the trailing text and the delimiter for the ID, this function requires the keyed passed in // NextSequenceValue requires a string literal for copy and paste, although it supports a variable, it is recommended // to not use one // ** Implementation Note: Adjust the prefix and join_char for each subtype. The selector_value_txt is the subtype of the layer function get_id(selector_value) { var id_format = {} var seq_val = null; var selector_value_txt = Text(selector_value) if (selector_value_txt == '4') { id_format = { 'prefix': "Pp", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Pp_4_seq'); }else if (selector_value_txt == '5') { id_format = { 'prefix': "Opn-Chnnl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Opn_Chnnl_5_seq'); }else if (selector_value_txt == '6') { id_format = { 'prefix': "Clvrt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Clvrt_6_seq'); }else if (selector_value_txt == '7') { id_format = { 'prefix': "Lnr-Drn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Lnr_Drn_7_seq'); } else { return null; } var id_parts = remove_empty([id_format['prefix'], seq_val, id_format['suffix']]) return Concatenate(id_parts, id_format['join_char']) } // ************* End User Variables Section ************* // ************* Functions ************* function remove_empty(arr) { var new_arr = []; var j = 0; for (var i = 0; i < Count(arr); i++) { if (!IsEmpty(arr[i]) && arr[i] != '') { new_arr[j++] = arr[i]; } } return new_arr; } // ************* End Functions Section ***************** if ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id
13 12.7 2 Line - Snap to Manhole Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel. Calculation False True False False True True True 2024-03-18 12:03:02 // Assigned To: StormwaterLine // Type: Calculation // Name: Line - Snap to Manhole // Description: Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel. // Subtypes: All // Field: // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups/subtypes // ** Implementation Note: Instead of recreating this rule for each subtype, this rules uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. Industry data model includes Gravity Pipe, Force Main var asset_group = $feature.assetgroup; var valid_asset_groups = [4]; // The class names of the Manholes, Diversion Point // ** Implementation Note: These are just the class/table name and should not be fully qualified. var device_class = "StormwaterDevice"; var struct_junc_class = "StructureJunction"; // The class name of the Associations table // ** Implementation Note: Used for determining associations not on $feature var assoc_fs = FeatureSetByName($datastore, '{1733BB7C-7976-41B8-A898-F29CFAC3568D}', ['FROMGLOBALID', 'TOGLOBALID'], false); // The Asset Group and Asset Type of a Connection / Pipe Connection var conn_ag = 23; var conn_at = 241; // The Asset Group and Asset Type of the Manhole Channel // ** Implementation Note: The Asset Type value specifies what type of point that a Main can snap to. var manhole_chan = 301; var dir_manhole_chan = 302; var pipe_snap_types = 'AssetGroup in (32) and AssetType in (@manhole_chan, @dir_manhole_chan)'; // The Terminal Names used for connecting Directional Manhole Channels to Pipe Connections var from_terminal = "Downstream"; var to_terminal= "Upstream"; // Structure Junction - Stormwater Storm Vault sql // ** Implementation Note: SQL expression used to find Stormwater Storm Vault containers var vault_sql = 'ASSETGROUP in (208) and ASSETTYPE in (9)'; // The High Pipe Elevation field name on a Stormwater Storm Vault - Manhole var high_pipe_elev = "highpipeelev"; // Distance to offset Pipe line from snapped Manhole var offset_distance = 2; var percent_distance = 10; // if length of pipe is too short, pull back by this percent var offset_unit = 'feet'; // ************* End User Variables Section ************* // ************* Functions ************* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_snapped_point_info(point_geo) { // Get point that intersects point_geo. Must match an AG and AT group specified in pipe_snap_types. var device_fs = get_features_switch_yard($datastore, device_class, ["globalid", "assetgroup", 'assettype'], true); var snapped_feats = Intersects(device_fs, Point(point_geo)); return First(Filter(snapped_feats, pipe_snap_types)); } function pull_line_back(line_geo, endpoint_geo, pull_back) { // Buffer the endpoint_geo point by 'pull_back' units. Use new buffer polygon to clip the line_geo. if ((Length(line_geo, offset_unit)) < pull_back * 3) { pull_back = (percent_distance / 100) * Length(line_geo, offset_unit); } var clip_geom = Buffer(endpoint_geo, pull_back, offset_unit); return Difference(line_geo, clip_geom); } function create_connection_points(new_line, create_from, create_to) { var new_conns = []; var paths = new_line['paths']; var new_from_point = Point({'x': paths[0][0]['x'], 'y': paths[0][0]['y'], 'z': paths[0][0]['z'], 'spatialReference': new_line['spatialReference']}); var new_to_point = Point({'x': paths[-1][-1]['x'], 'y': paths[-1][-1]['y'], 'z': paths[-1][-1]['z'], 'spatialReference': new_line['spatialReference']}); if (create_from) { var conn1 = { 'tag': 'newconn0', 'attributes': { 'AssetGroup': conn_ag, 'AssetType': conn_at }, 'geometry': new_from_point }; push(new_conns, conn1) } if (create_to) { var conn2 = { 'tag': 'newconn1', 'attributes': { 'AssetGroup': conn_ag, 'AssetType': conn_at }, 'geometry': new_to_point }; push(new_conns, conn2) } return new_conns } function reset_z(line_geo, from_to, z_value) { // adjust z-values of begin/end points in polyline. convert to dictionary to update. var line_dict = Dictionary(Text(line_geo)); line_dict['paths'][iif(from_to == 'from', 0, -1)][iif(from_to == 'from', 0, -1)][2] = z_value; // custom projections can sometimes cause SR to be dropped if (!HasKey(line_dict, "spatialReference")) line_dict["spatialReference"] = line_geo.spatialReference return Polyline(line_dict) } function get_container(manhole_id) { // Get Stormwater Vault - Manhole which is container of Manhole Channel we are snapping to var filtered_fs = Filter(assoc_fs, "TOGLOBALID = @manhole_id and ASSOCIATIONTYPE in (2)"); if (Count(filtered_fs) == 0) return null; var container = First(filtered_fs).fromglobalid; // verify container is a Stormwater Vault var vault = get_features_switch_yard($datastore, struct_junc_class, ['GLOBALID', 'ASSETGROUP', 'ASSETTYPE', high_pipe_elev], false); var filtered_vault = Filter(vault, "GLOBALID = @container and " + vault_sql); if (Count(filtered_vault) == 0) return null; return First(filtered_vault); } function create_connect_assocs(manhole_ch, idx) { // build association payload for connectivity var connect_assoc = { "fromClass": device_class, "fromGlobalID": manhole_ch.globalid, "toClass": device_class, "toGlobalid": 'newconn' + Text(idx) + ".globalid", "associationType": "connectivity" }; // if AT is Directional Manhole Channel, need to use terminals if (manhole_ch.assettype == dir_manhole_chan){ connect_assoc['fromTerminal'] = iif(idx == 0, from_terminal, to_terminal) } return connect_assoc; } function create_contain_assocs(pt_id, idx) { // build association payload for containment return { "fromClass": struct_junc_class, "fromGlobalID": pt_id, "toClass": device_class, "toGlobalid": 'newconn' + Text(idx) + ".globalid", "associationType": "containment" }; } function high_pipe_payload(manhole, pipe_z) { // if manhole High Pipe Elevation attribute is less then incoming Pipe Connection z, update High Pipe Elev var updates = []; if (IsEmpty(manhole[high_pipe_elev]) || manhole[high_pipe_elev] < pipe_z) { var attr = {"globalid": manhole.globalid, "attributes": Dictionary(high_pipe_elev, pipe_z)}; push(updates, attr) } return updates } // ************* End Functions Section ****************** // Validation // Limit the rule to valid asset groups if (!Includes(valid_asset_groups, asset_group)) { return; } // Get the start and end vertex of the line var assigned_line_geo = Geometry($feature); var paths = assigned_line_geo['paths']; var from_point = paths[0][0]; var to_point = paths[-1][-1]; // Get the snapped Device(s) var from_manhole_chan = get_snapped_point_info(Point(from_point)); var to_manhole_chan = get_snapped_point_info(Point(to_point)); if (IsEmpty(from_manhole_chan) && IsEmpty(to_manhole_chan)) return; // pull line back var new_line_geo = assigned_line_geo; if (!IsEmpty(from_manhole_chan)) { new_line_geo = pull_line_back(new_line_geo, Geometry(from_manhole_chan), offset_distance); // reset z-values to original new_line_geo = reset_z(new_line_geo, 'from', from_point['z']); } if (!IsEmpty(to_manhole_chan)) { new_line_geo = pull_line_back(new_line_geo, Geometry(to_manhole_chan), offset_distance); // reset z-values to original new_line_geo = reset_z(new_line_geo, 'to', to_point['z']); } // need to check for empty to get past runtime if (IsEmpty(new_line_geo)) return; // generate new Pipe Connections var new_conns = create_connection_points(new_line_geo, !IsEmpty(from_manhole_chan), !IsEmpty(to_manhole_chan)); // build associations var struct_junc_updates = []; var un_adds = []; if (!IsEmpty(from_manhole_chan)) { // connect Pipe Connection to Manhole Channel push(un_adds, create_connect_assocs(from_manhole_chan, 0)); // contain Pipe Connection in Stormwater Vault var from_contain = get_container(from_manhole_chan.globalid); if(!IsEmpty(from_contain)) { push(un_adds, create_contain_assocs(from_contain.globalid, 0)); } } if (!IsEmpty(to_manhole_chan)) { // connect Pipe Connection to Manhole Channel push(un_adds, create_connect_assocs(to_manhole_chan, 1)); // contain Pipe Connection in Stormwater Vault var to_contain = get_container(to_manhole_chan.globalid); if(!IsEmpty(to_contain)) { push(un_adds, create_contain_assocs(to_contain.globalid, 1)); // update High Pipe Elevation attribute on Stormwater Vault. only do this with pipe endpoints struct_junc_updates = high_pipe_payload(to_contain, new_line_geo['paths'][-1][-1]['z']); } } var edit_payload = [{ 'className': device_class, 'adds': new_conns }, { 'className': '^UN_Association', 'adds': un_adds }]; if (Count(struct_junc_updates) > 0) { push(edit_payload, {'className': struct_junc_class, 'updates': struct_junc_updates}) } return { "result": {"geometry": new_line_geo}, "edit": edit_payload };
14 12.7 3 Line - Set Attributes from Z Update upstream and downstream attributes a Main based on Geometry Z values of begin and endpoints of line. Calculation False True True False True True True 2024-03-18 12:03:02 // Assigned To: StormwaterLine // Type: Calculation // Name: Line - Set Attributes from Z // Description: Update upstream and downstream attributes a Main based on Geometry Z values of begin and endpoints of line. // Subtypes: All // Field: // Trigger: Insert, Update // Evaluation Order: 3 // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - Device - Set Attributes from Z // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups/subtypes // ** Implementation Note: Instead of recreating this rule for each subtype, this rule uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. var asset_group = $feature.assetgroup; var valid_asset_groups = [4, 5, 6, 7]; // Pipe, Open Channel, Culvert, Linear Drain // The attribute fields to update using Z values var upelev = "upelev"; var downelev = "downelev"; // ************* End User Variables Section ************* // Limit the rule to valid asset groups if (!Includes(valid_asset_groups, asset_group)) return; // Get the start and end vertex of the line var assigned_line_geo = Geometry($feature); var from_z = assigned_line_geo['paths'][0][0].z; var to_z = assigned_line_geo['paths'][-1][-1].z; if (IsEmpty(from_z) && IsEmpty(to_z)) return; var ret = {}; if (!IsEmpty(to_z)) ret[downelev] = Round(to_z, 2); if (!IsEmpty(from_z)) ret[upelev] = Round(from_z, 2); return {'result': {'attributes': ret}};
15 12.7 4 Line - Main Slope Adjusts the slope based on the upstream, downstream, and length of the main Calculation False True True False slope True True False 2024-03-18 12:03:02 // Assigned To: StormwaterLine // Type: Calculation // Name: Line - Main Slope // Description: Adjusts the slope based on the upstream, downstream, and length of the main // Subtypes: All // Field: slope // Trigger: Insert, Update // Evaluation Order: 4 // Exclude From Client: False // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups/subtypes // ** Implementation Note: Instead of recreating this rule for each subtype, this rules uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. var asset_group = $feature.assetgroup; var valid_asset_groups = [4, 5, 6, 7]; // Pipe, Open Channel, Culvert, Linear Drain // ************* End User Variables Section ************* // Limit the rule to valid asset groups if (!Includes(valid_asset_groups, asset_group)) return $feature.slope; if (IsEmpty($feature.UPELEV) || IsEmpty($feature.DOWNELEV)) { return $feature.slope; } if (IsEmpty(Geometry($feature)) || Length(Geometry($feature)) == 0) { return $feature.slope; } return ABS(($feature.UPELEV - $feature.DOWNELEV)/Length(Geometry($feature)));
16 12.7 1 Line - Snap to Manhole batch Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel. Calculation True False False False True False True 2024-03-18 12:03:02 // Assigned To: StormwaterLine // Type: Calculation // Name: Line - Snap to Manhole // Description: Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel. // Subtypes: All // Field: // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // ************* User Variables ************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups/subtypes // ** Implementation Note: Instead of recreating this rule for each subtype, this rules uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. Industry data model includes Gravity Pipe, Force Main var asset_group = $feature.assetgroup; var valid_asset_groups = [4]; // The class names of the Manholes, Diversion Point // ** Implementation Note: These are just the class/table name and should not be fully qualified. var device_class = "StormwaterDevice"; var struct_junc_class = "StructureJunction"; // The class name of the Associations table // ** Implementation Note: Used for determining associations not on $feature var assoc_fs = FeatureSetByName($datastore, '{1733BB7C-7976-41B8-A898-F29CFAC3568D}', ['FROMGLOBALID', 'TOGLOBALID'], false); // The Asset Group and Asset Type of a Connection / Pipe Connection var conn_ag = 23; var conn_at = 241; // The Asset Group and Asset Type of the Manhole Channel // ** Implementation Note: The Asset Type value specifies what type of point that a Main can snap to. var manhole_chan = 301; var dir_manhole_chan = 302; var pipe_snap_types = 'AssetGroup in (32) and AssetType in (@manhole_chan, @dir_manhole_chan)'; // The Terminal Names used for connecting Directional Manhole Channels to Pipe Connections var from_terminal = "Downstream"; var to_terminal= "Upstream"; // Structure Junction - Stormwater Storm Vault sql // ** Implementation Note: SQL expression used to find Stormwater Storm Vault containers var vault_sql = 'ASSETGROUP in (208) and ASSETTYPE in (9)'; // The High Pipe Elevation field name on a Stormwater Storm Vault - Manhole var high_pipe_elev = "highpipeelev"; // Distance to offset Pipe line from snapped Manhole var offset_distance = 2; var percent_distance = 10; // if length of pipe is too short, pull back by this percent var offset_unit = 'feet'; // ************* End User Variables Section ************* // ************* Functions ************* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_snapped_point_info(point_geo) { // Get point that intersects point_geo. Must match an AG and AT group specified in pipe_snap_types. var device_fs = get_features_switch_yard($datastore, device_class, ["globalid", "assetgroup", 'assettype'], true); var snapped_feats = Intersects(device_fs, Point(point_geo)); return First(Filter(snapped_feats, pipe_snap_types)); } function pull_line_back(line_geo, endpoint_geo, pull_back) { // Buffer the endpoint_geo point by 'pull_back' units. Use new buffer polygon to clip the line_geo. if ((Length(line_geo, offset_unit)) < pull_back * 3) { pull_back = (percent_distance / 100) * Length(line_geo, offset_unit); } var clip_geom = Buffer(endpoint_geo, pull_back, offset_unit); return Difference(line_geo, clip_geom); } function create_connection_points(new_line, create_from, create_to) { var new_conns = []; var paths = new_line['paths']; var new_from_point = Point({'x': paths[0][0]['x'], 'y': paths[0][0]['y'], 'z': paths[0][0]['z'], 'spatialReference': new_line['spatialReference']}); var new_to_point = Point({'x': paths[-1][-1]['x'], 'y': paths[-1][-1]['y'], 'z': paths[-1][-1]['z'], 'spatialReference': new_line['spatialReference']}); if (create_from) { var conn1 = { 'tag': 'newconn0', 'attributes': { 'AssetGroup': conn_ag, 'AssetType': conn_at }, 'geometry': new_from_point }; push(new_conns, conn1) } if (create_to) { var conn2 = { 'tag': 'newconn1', 'attributes': { 'AssetGroup': conn_ag, 'AssetType': conn_at }, 'geometry': new_to_point }; push(new_conns, conn2) } return new_conns } function reset_z(line_geo, from_to, z_value) { // adjust z-values of begin/end points in polyline. convert to dictionary to update. var line_dict = Dictionary(Text(line_geo)); line_dict['paths'][iif(from_to == 'from', 0, -1)][iif(from_to == 'from', 0, -1)][2] = z_value; // custom projections can sometimes cause SR to be dropped if (!HasKey(line_dict, "spatialReference")) line_dict["spatialReference"] = line_geo.spatialReference return Polyline(line_dict) } function get_container(manhole_id) { // Get Stormwater Vault - Manhole which is container of Manhole Channel we are snapping to var filtered_fs = Filter(assoc_fs, "TOGLOBALID = @manhole_id and ASSOCIATIONTYPE in (2)"); if (Count(filtered_fs) == 0) return null; var container = First(filtered_fs).fromglobalid; // verify container is a Stormwater Vault var vault = get_features_switch_yard($datastore, struct_junc_class, ['GLOBALID', 'ASSETGROUP', 'ASSETTYPE', high_pipe_elev], false); var filtered_vault = Filter(vault, "GLOBALID = @container and " + vault_sql); if (Count(filtered_vault) == 0) return null; return First(filtered_vault); } function create_connect_assocs(manhole_ch, idx) { // build association payload for connectivity var connect_assoc = { "fromClass": device_class, "fromGlobalID": manhole_ch.globalid, "toClass": device_class, "toGlobalid": 'newconn' + Text(idx) + ".globalid", "associationType": "connectivity" }; // if AT is Directional Manhole Channel, need to use terminals if (manhole_ch.assettype == dir_manhole_chan){ connect_assoc['fromTerminal'] = iif(idx == 0, from_terminal, to_terminal) } return connect_assoc; } function create_contain_assocs(pt_id, idx) { // build association payload for containment return { "fromClass": struct_junc_class, "fromGlobalID": pt_id, "toClass": device_class, "toGlobalid": 'newconn' + Text(idx) + ".globalid", "associationType": "containment" }; } function high_pipe_payload(manhole, pipe_z) { // if manhole High Pipe Elevation attribute is less then incoming Pipe Connection z, update High Pipe Elev var updates = []; if (IsEmpty(manhole[high_pipe_elev]) || manhole[high_pipe_elev] < pipe_z) { var attr = {"globalid": manhole.globalid, "attributes": Dictionary(high_pipe_elev, pipe_z)}; push(updates, attr) } return updates } // ************* End Functions Section ****************** // Validation // Limit the rule to valid asset groups if (!Includes(valid_asset_groups, asset_group)) { return; } // Get the start and end vertex of the line var assigned_line_geo = Geometry($feature); var paths = assigned_line_geo['paths']; var from_point = paths[0][0]; var to_point = paths[-1][-1]; // Get the snapped Device(s) var from_manhole_chan = get_snapped_point_info(Point(from_point)); var to_manhole_chan = get_snapped_point_info(Point(to_point)); if (IsEmpty(from_manhole_chan) && IsEmpty(to_manhole_chan)) return; // pull line back var new_line_geo = assigned_line_geo; if (!IsEmpty(from_manhole_chan)) { new_line_geo = pull_line_back(new_line_geo, Geometry(from_manhole_chan), offset_distance); // reset z-values to original new_line_geo = reset_z(new_line_geo, 'from', from_point['z']); } if (!IsEmpty(to_manhole_chan)) { new_line_geo = pull_line_back(new_line_geo, Geometry(to_manhole_chan), offset_distance); // reset z-values to original new_line_geo = reset_z(new_line_geo, 'to', to_point['z']); } // need to check for empty to get past runtime if (IsEmpty(new_line_geo)) return; // generate new Pipe Connections var new_conns = create_connection_points(new_line_geo, !IsEmpty(from_manhole_chan), !IsEmpty(to_manhole_chan)); // build associations var struct_junc_updates = []; var un_adds = []; if (!IsEmpty(from_manhole_chan)) { // connect Pipe Connection to Manhole Channel push(un_adds, create_connect_assocs(from_manhole_chan, 0)); // contain Pipe Connection in Stormwater Vault var from_contain = get_container(from_manhole_chan.globalid); if(!IsEmpty(from_contain)) { push(un_adds, create_contain_assocs(from_contain.globalid, 0)); } } if (!IsEmpty(to_manhole_chan)) { // connect Pipe Connection to Manhole Channel push(un_adds, create_connect_assocs(to_manhole_chan, 1)); // contain Pipe Connection in Stormwater Vault var to_contain = get_container(to_manhole_chan.globalid); if(!IsEmpty(to_contain)) { push(un_adds, create_contain_assocs(to_contain.globalid, 1)); // update High Pipe Elevation attribute on Stormwater Vault. only do this with pipe endpoints struct_junc_updates = high_pipe_payload(to_contain, new_line_geo['paths'][-1][-1]['z']); } } var edit_payload = [{ 'className': device_class, 'adds': new_conns }, { 'className': '^UN_Association', 'adds': un_adds }]; if (Count(struct_junc_updates) > 0) { push(edit_payload, {'className': struct_junc_class, 'updates': struct_junc_updates}) } return { "result": {"geometry": new_line_geo}, "edit": edit_payload };

main.StormwaterLine__ATTACHREL

Properties

Key Value
Name main.StormwaterLine__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 129
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.StormwaterLine
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.StormwaterLine__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {816938E7-36B9-4D7E-A48D-00C7CB516FCE}
Class ID
Extension Class ID

main.StormwaterAssembly

Properties

Key Value
Name main.StormwaterAssembly
Dataset Type FeatureClass
Feature Dataset main.UtilityNetwork
Dataset ID 105
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 13.2
Alias Stormwater Assembly
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field SHAPE
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 500372.76851501653
Y-Min 1550391.9656166665
X-Max 1270078.1610237253
Y-Max 2190094.2549103117
Catalog ID {839F1E9C-07C8-46DF-A969-31DF7E92FDEC}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
SHAPE Shape Geometry Index False 0 0 8 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
SUPPORTEDSUBNETWORKNAME Supported subnetwork name String Index False Unknown 0 0 2000 False True
subnetworkname Subnetwork name String False Unknown 0 0 2000 True False
installdate Install Date Date True 0 0 8 True False
ownedby Asset Owner Short Integer True Asset_Owner 1 0 0 2 True False
maintby Asset Manager Short Integer True Asset_Manager 1 0 0 2 True False
symbolrotation symbolrotation: Symbol Rotation Short Integer True Symbol_Rotation 0 0 2 True False
assetid Asset ID String True 0 0 64 True False
notes Notes String True 0 0 2000 True False
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 2 True False
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 2 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_105_SUPPORTE False True SUPPORTEDSUBNETWORKNAME
UUID_45 True True GLOBALID
FDO_OBJECTID True True OBJECTID
st_spindex__StormwaterAssembly_SHAPE True True SHAPE

Subtype

Name Code Details
Unknown 0

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 SUPPORTEDSUBNETWORKNAME Unknown
Unknown 0 subnetworkname Unknown

main.Stormwater_Device_Discharge_To_Inspection

Properties

Key Value
Name main.Stormwater_Device_Discharge_To_Inspection
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 131
Type Composite
Cardinality One To Many
Notification None
Is Attachment False
Is Attributed False
Origin Name main.StormwaterDevice
Origin Primary Key GLOBALID
Origin Foreign Key assetguid
Destination Name main.DischargeInspection
Destination Primary Key
Destination Foreign Key
Forward Path Label DischargeInspection
Backward Path Label StormwaterDevice
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {9213D720-B9A8-432B-B9DB-F1B5E43512AE}
Class ID
Extension Class ID

RelationshipClassRule

Rule ID Origin Subtype Origin Min Cardinality Origin Max Cardinality Destination Subtype Destination Min Cardinality Destination Max Cardinality
1 BMP Inlet 0 0 0 0
2 BMP Point 0 0 0 0
3 Catch Basin 0 0 0 0
4 Cleanout 0 0 0 0
5 Connection 0 0 0 0
6 Manhole Channel 0 0 0 0
7 Outlet 0 1000 0 1000
8 Pump 0 0 0 0
9 Unknown 0 0 0 0
10 Weir 0 0 0 0

main.Structure_Junction_Manhole_To_Inspection

Properties

Key Value
Name main.Structure_Junction_Manhole_To_Inspection
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 135
Type Composite
Cardinality One To Many
Notification None
Is Attachment False
Is Attributed False
Origin Name main.StructureJunction
Origin Primary Key GLOBALID
Origin Foreign Key assetguid
Destination Name main.ManholeInspection
Destination Primary Key
Destination Foreign Key
Forward Path Label ManholeInspection
Backward Path Label StructureJunction
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {A9F0C299-CE87-4044-8CB0-3160195076DF}
Class ID
Extension Class ID

main.StormwaterDevice__ATTACHREL

Properties

Key Value
Name main.StormwaterDevice__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 127
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.StormwaterDevice
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.StormwaterDevice__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {D1C9A8B3-FDFC-4277-87E3-F48F6ABC9C0D}
Class ID
Extension Class ID

main.StormwaterAssembly__ATTACHREL

Properties

Key Value
Name main.StormwaterAssembly__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset main.UtilityNetwork
Dataset ID 125
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.StormwaterAssembly
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.StormwaterAssembly__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {E6EE8926-1D33-4914-913F-C19061749910}
Class ID
Extension Class ID

main.StructureLine

Properties

Key Value
Name main.StructureLine
Dataset Type FeatureClass
Feature Dataset main.UtilityNetwork
Dataset ID 38
Geometry Type Polyline
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 13.2
Alias Structure Line
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field SHAPE
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 500372.76851501653
Y-Min 1550391.9656166665
X-Max 1270078.1610237253
Y-Max 2190094.2549103117
Catalog ID {F64AC84F-6180-4305-A3AA-9832290E8223}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
SUBNETWORKNAME Subnetwork name String Index False Unknown 0 0 2000 False True
FLOWDIRECTION Flow direction Short Integer True Network_6_FlowDirection 1 0 0 2 True True
SHAPE Shape Geometry Index False 0 0 8 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
name Name String True 0 0 64 True False
notes Notes String True 0 0 2000 True False
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 2 True False
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 2 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False
st_length(SHAPE) shape_Length Double Length True 0 0 0 False True

Index

Name Is Unique Is Ascending Field Name
GDB_38_SUBNETWOR False True SUBNETWORKNAME
UUID_39 True True GLOBALID
FDO_OBJECTID True True OBJECTID
st_spindex__StructureLine_SHAPE True True SHAPE

Subtype

Name Code Details
Unknown 0

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 SUBNETWORKNAME Unknown
Unknown 0 FLOWDIRECTION 1 Network_6_FlowDirection

main.StormwaterSubnetLine

Properties

Key Value
Name main.StormwaterSubnetLine
Dataset Type FeatureClass
Feature Dataset main.UtilityNetwork
Dataset ID 107
Geometry Type Polyline
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 13.2
Alias Stormwater Networks
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field TIERNAME
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field SHAPE
Spatial Reference NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min 500372.76851501653
Y-Min 1550391.9656166665
X-Max 1270078.1610237253
Y-Max 2190094.2549103117
Catalog ID {FC9090B2-D732-406F-877A-4C28412FF122}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
SUBNETWORKNAME Subnetwork name String False Unknown 0 0 64 False True
ISDIRTY Is dirty Short Integer False Network_6_IsDirty 1 0 0 2 False True
TIERNAME Tier name Short Integer Subtype False 0 0 0 2 False True
SUBNETWORKCONTROLLERNAMES Subnetwork controller names String False Unknown 0 0 1073741822 False True
LASTUPDATESUBNETWORK Last update subnetwork Date True 0 0 8 False True
LASTACKEXPORTSUBNETWORK Last ack export subnetwork Date True 0 0 8 False True
SHAPE Shape Geometry Index False 0 0 8 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False
st_length(SHAPE) shape_Length Double Length True 0 0 0 False True

Index

Name Is Unique Is Ascending Field Name
UUID_47 True True GLOBALID
FDO_OBJECTID True True OBJECTID
st_spindex__StormwaterSubnetLine_SHAPE True True SHAPE

Subtype

Name Code Details
Unknown 0
Stormwater Management Area 1

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 SUBNETWORKNAME Unknown
Unknown 0 ISDIRTY 1 Network_6_IsDirty
Unknown 0 SUBNETWORKCONTROLLERNAMES Unknown
Stormwater Management Area 1 SUBNETWORKNAME Unknown
Stormwater Management Area 1 ISDIRTY 1 Network_6_IsDirty
Stormwater Management Area 1 SUBNETWORKCONTROLLERNAMES Unknown

main.StructureJunctionObject

Properties

Key Value
Name main.StructureJunctionObject
Dataset Type Table
Feature Dataset
Dataset ID 40
Minimum Client Version 13.2
Alias Structure Junction Object
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {A4286208-44B6-487D-9B11-F100AF85CC86}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
SUBNETWORKNAME Supported subnetwork name String Index False Unknown 0 0 2000 False True
GLOBALID Global ID Global ID Index False 0 0 38 False True
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_40_SUBNETWOR False True SUBNETWORKNAME
UUID_41 True True GLOBALID
FDO_OBJECTID True True OBJECTID

Subtype

Name Code Details
Unknown 0

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 SUBNETWORKNAME Unknown

main.StructureEdgeObject

Properties

Key Value
Name main.StructureEdgeObject
Dataset Type Table
Feature Dataset
Dataset ID 41
Minimum Client Version 13.2
Alias Structure Edge Object
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {D4A3B136-B60F-433E-86A9-97E229292AC5}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
SUBNETWORKNAME Supported subnetwork name String Index False Unknown 0 0 2000 False True
FLOWDIRECTION Flow direction Short Integer True Network_6_FlowDirection 1 0 0 2 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_41_SUBNETWOR False True SUBNETWORKNAME
UUID_42 True True GLOBALID
FDO_OBJECTID True True OBJECTID

Subtype

Name Code Details
Unknown 0

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 SUBNETWORKNAME Unknown
Unknown 0 FLOWDIRECTION 1 Network_6_FlowDirection

main.StormwaterJunctionObject

Properties

Key Value
Name main.StormwaterJunctionObject
Dataset Type Table
Feature Dataset
Dataset ID 108
Minimum Client Version 13.2
Alias Stormwater Junction Object
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {7BACABAB-E722-4E93-9BC7-25ABC393A5E7}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
ISSUBNETWORKCONTROLLER Is subnetwork controller Short Integer False Network_6_IsSubnetworkController 0 0 0 2 False True
ISCONNECTED Is connected Short Integer False Network_6_IsConnected 2 0 0 2 False True
SUBNETWORKCONTROLLERNAME Subnetwork controller name String Index False Unknown 0 0 2000 False True
TIERNAME Tier name Short Integer False Network_6_TierName 0 0 0 2 False True
TIERRANK Tier rank Long Integer False 0 0 0 4 False True
TERMINALCONFIGURATION Terminal path String False Default 0 0 128 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
SUBNETWORKNAME Subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTEDSUBNETWORKNAME Supported subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTINGSUBNETWORKNAME Supporting subnetwork name String Index False Unknown 0 0 2000 False True
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_108_SUPPORTI False True SUPPORTINGSUBNETWORKNAME
GDB_108_SUPPORTE False True SUPPORTEDSUBNETWORKNAME
GDB_108_SUBNETWO_1 False True SUBNETWORKNAME
GDB_108_SUBNETWO False True SUBNETWORKCONTROLLERNAME
UUID_48 True True GLOBALID
FDO_OBJECTID True True OBJECTID

Subtype

Name Code Details
Unknown 0

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 ISSUBNETWORKCONTROLLER 0 Network_6_IsSubnetworkController
Unknown 0 ISCONNECTED 2 Network_6_IsConnected
Unknown 0 SUBNETWORKCONTROLLERNAME Unknown
Unknown 0 TIERNAME 0 Network_6_TierName
Unknown 0 TIERRANK 0
Unknown 0 TERMINALCONFIGURATION Default
Unknown 0 SUBNETWORKNAME Unknown
Unknown 0 SUPPORTEDSUBNETWORKNAME Unknown
Unknown 0 SUPPORTINGSUBNETWORKNAME Unknown

main.StormwaterEdgeObject

Properties

Key Value
Name main.StormwaterEdgeObject
Dataset Type Table
Feature Dataset
Dataset ID 109
Minimum Client Version 13.2
Alias Stormwater Edge Object
OID Field OBJECTID
GlobalID Field GLOBALID
Subtype Field ASSETGROUP
Default Subtype Unknown
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {2803E4F4-9007-4B61-834D-65EC889C7EAC}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

ControllerMembership

Key Value
utilityNetworkName main.Network

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID Object ID OID Index False 0 0 8 False True
ASSETGROUP Asset group Long Integer Subtype False 0 0 0 4 True True
ASSETTYPE Asset type Short Integer False 0 0 0 2 True True
ASSOCIATIONSTATUS Association status Short Integer False Network_6_AssociationStatus 0 0 0 2 False True
ISCONNECTED Is connected Short Integer False Network_6_IsConnected 2 0 0 2 False True
FLOWDIRECTION Flow direction Short Integer True Network_6_FlowDirection 1 0 0 2 True True
GLOBALID Global ID Global ID Index False 0 0 38 False True
SUBNETWORKNAME Subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTEDSUBNETWORKNAME Supported subnetwork name String Index False Unknown 0 0 2000 False True
SUPPORTINGSUBNETWORKNAME Supporting subnetwork name String Index False Unknown 0 0 2000 False True
lifecyclestatus Lifecycle Status Short Integer False Lifecycle_Combined 2 0 0 2 True False
constructionstatus Construction Status Short Integer True Construction_Status 6 0 0 2 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_109_SUPPORTI False True SUPPORTINGSUBNETWORKNAME
GDB_109_SUPPORTE False True SUPPORTEDSUBNETWORKNAME
GDB_109_SUBNETWO False True SUBNETWORKNAME
UUID_49 True True GLOBALID
FDO_OBJECTID True True OBJECTID

Subtype

Name Code Details
Unknown 0

SubtypeFieldInfo

Subtype Name Subtype Code Field Name Default Value Domain Name
Unknown 0 ASSETTYPE 0 Network_6_UnknownAssetType
Unknown 0 ASSOCIATIONSTATUS 0 Network_6_AssociationStatus
Unknown 0 ISCONNECTED 2 Network_6_IsConnected
Unknown 0 FLOWDIRECTION 1 Network_6_FlowDirection
Unknown 0 SUBNETWORKNAME Unknown
Unknown 0 SUPPORTEDSUBNETWORKNAME Unknown
Unknown 0 SUPPORTINGSUBNETWORKNAME Unknown

main.DischargeInspection

Properties

Key Value
Name main.DischargeInspection
Dataset Type Table
Feature Dataset
Dataset ID 110
Minimum Client Version 10.1
Alias Discharge Inspection
OID Field objectid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {881E67E4-ED1B-4FC3-A4EB-067A6FA1C5A8}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
objectid OBJECTID OID Index False 0 0 4 False True
inspector Inspector String True 0 0 50 True False
inspectdt Inspection Date Date True 0 0 8 True False
dryweather Dry Weather Inspection? Short Integer True 0 0 2 True False
dateprecip Date of Last Precipitation Date True 0 0 8 True False
amountprecip Amount of Last Precipitation Double True 0 0 8 True False
flow Flow Present? Short Integer True 0 0 2 True False
flowrate Flow Rate Short Integer True 0 0 2 True False
flowcolor Flow contains color? Short Integer True 0 0 2 True False
colordesc Color Description Short Integer True 0 0 2 True False
colordesc_other Specify other String True 0 0 50 True False
flowodor Flow contains odor? Short Integer True 0 0 2 True False
odordesc Odor Description Short Integer True 0 0 2 True False
odordesc_other Specify other String True 0 0 50 True False
flowfloatable Flow contains floatables? Short Integer True 0 0 2 True False
floatabledesc Floatable Description Short Integer True 0 0 2 True False
floatabledesc_other Specify other String True 0 0 50 True False
recievingwater Change in recieving water? Short Integer False 0 0 2 True False
recievingwaterdesc Description of Change String True 0 0 150 True False
illicitdischarge Is Flow Illicit Discharge? Short Integer True 0 0 2 True False
illicitdischargesource Efforts to determine source String True 0 0 150 True False
illicitdischargeaction Corrective Action Taken String True 0 0 150 True False
notes Notes String True 0 0 2000 True False
assetguid Asset GUID GUID Index True 0 0 38 True False
globalid globalid Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_110_assetgui False True assetguid
UUID_50 True True globalid
FDO_objectid True True objectid

main.DischargeInspection__ATTACH

Properties

Key Value
Name main.DischargeInspection__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 111
Minimum Client Version 10.1
Alias DischargeInspection__ATTACH
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {D1BE986B-82C5-4450-A20C-A6BE25FAD529}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid REL_GLOBALID GUID Index False 0 0 38 True False
content_type CONTENT_TYPE String False 0 0 150 True False
att_name ATT_NAME String False 0 0 250 True False
data_size DATA_SIZE Long Integer False 0 0 4 True False
data DATA Blob True 0 0 0 True False
globalid GLOBALID Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False True
created_date created_date Date Created True 0 0 8 False True
last_edited_user last_edited_user String Editor True 0 0 255 False True
last_edited_date last_edited_date Date Edited True 0 0 8 False True

Index

Name Is Unique Is Ascending Field Name
GDB_111_REL_GLOB False True rel_globalid
UUID_51 True True globalid
FDO_attachmentid True True attachmentid

main.ManholeInspection

Properties

Key Value
Name main.ManholeInspection
Dataset Type Table
Feature Dataset
Dataset ID 112
Minimum Client Version 10.1
Alias Manhole Inspection
OID Field objectid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {5DDCC14F-1E90-40E6-9920-D0CD6ED56C39}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
objectid OBJECTID OID Index False 0 0 4 False True
inspector Inspector String True 0 0 50 True False
inspectdt Inspection Date Date True 0 0 8 True False
inspectpurp Purpose of Inspection Short Integer True 0 0 2 True False
precleaning Pre-Cleaning Short Integer True 0 0 2 True False
precleaningdate Pre-Cleaning Date Date True 0 0 8 True False
weather Weather Short Integer True 0 0 2 True False
runoff Runoff Potential Short Integer True 0 0 2 True False
inspectionstatus Inspection Status Short Integer True 0 0 2 True False
evidsurcharge Evidence of Surchage Short Integer True 0 0 2 True False
coverfit Cover Fit Short Integer True 0 0 2 True False
covercondition Cover Condition Short Integer True 0 0 2 True False
coverinsertcondition Cover Insert Condition Short Integer True 0 0 2 True False
coverringcondition Cover Ring Condition Short Integer True 0 0 2 True False
framecondition Frame Condition Short Integer True 0 0 2 True False
framesealcondition Frame Seal Condition Short Integer True 0 0 2 True False
framesealinflow Evidence of Frame Seal Inflow Short Integer True 0 0 2 True False
notes Notes String True 0 0 2000 True False
assetguid Asset GUID GUID Index True 0 0 38 True False
globalid globalid Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_112_assetgui False True assetguid
UUID_52 True True globalid
FDO_objectid True True objectid

main.ManholeInspection__ATTACH

Properties

Key Value
Name main.ManholeInspection__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 113
Minimum Client Version 10.1
Alias ManholeInspection__ATTACH
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {4AB358C8-3E7E-42C2-8948-B4B70627A84A}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid REL_GLOBALID GUID Index False 0 0 38 True False
content_type CONTENT_TYPE String False 0 0 150 True False
att_name ATT_NAME String False 0 0 250 True False
data_size DATA_SIZE Long Integer False 0 0 4 True False
data DATA Blob True 0 0 0 True False
globalid GLOBALID Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False True
created_date created_date Date Created True 0 0 8 False True
last_edited_user last_edited_user String Editor True 0 0 255 False True
last_edited_date last_edited_date Date Edited True 0 0 8 False True

Index

Name Is Unique Is Ascending Field Name
GDB_113_REL_GLOB False True rel_globalid
UUID_53 True True globalid
FDO_attachmentid True True attachmentid

main.StormwaterAssembly__ATTACH

Properties

Key Value
Name main.StormwaterAssembly__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 114
Minimum Client Version 10.1
Alias Stormwater Assembly Attachment
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {6E95C0E3-701A-4C2E-A374-CAFBA2B3AE59}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid rel_globalid GUID Index False 0 0 38 True False
content_type content_type String False 0 0 150 True False
att_name att_name String False 0 0 250 True False
data_size data_size Long Integer False 0 0 4 True False
data data Blob True 0 0 0 True False
globalid globalid Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_114_REL_GLOB False True rel_globalid
UUID_54 True True globalid
FDO_attachmentid True True attachmentid

main.StormwaterBMPInspection

Properties

Key Value
Name main.StormwaterBMPInspection
Dataset Type Table
Feature Dataset
Dataset ID 115
Minimum Client Version 10.1
Alias BMP Inspection
OID Field objectid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {DE2C4C9D-10DF-4535-84B1-ECBA460E1A57}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
objectid OBJECTID OID Index False 0 0 4 False True
inspector Inspector String True 0 0 50 True False
inspectdt Inspection Date Date True 0 0 8 True False
removal Removal of... Short Integer True 0 0 2 True False
removalequipment Equipment Needed Short Integer True 0 0 2 True False
removalnotes Removal Notes String True 0 0 2000 True False
damage Damage To... Short Integer True 0 0 2 True False
damage_other Specify other String True 0 0 150 True False
damageengineer Engineer Inspection Needed? Short Integer True 0 0 2 True False
damagenotes Damage Notes String True 0 0 2000 True False
globalid globalid Global ID Index False 0 0 38 False True
assetguid Asset Guid GUID Index True 0 0 38 True False
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_115_assetgui False True assetguid
UUID_55 True True globalid
FDO_objectid True True objectid

main.StormwaterBMPInspection__ATTACH

Properties

Key Value
Name main.StormwaterBMPInspection__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 116
Minimum Client Version 10.1
Alias StormwaterBMPInspection__ATTACH
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {75FBF7C4-F4FB-4939-A544-8CD5DB5E47DA}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid REL_GLOBALID GUID Index False 0 0 38 True False
content_type CONTENT_TYPE String False 0 0 150 True False
att_name ATT_NAME String False 0 0 250 True False
data_size DATA_SIZE Long Integer False 0 0 4 True False
data DATA Blob True 0 0 0 True False
globalid GLOBALID Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False True
created_date created_date Date Created True 0 0 8 False True
last_edited_user last_edited_user String Editor True 0 0 255 False True
last_edited_date last_edited_date Date Edited True 0 0 8 False True

Index

Name Is Unique Is Ascending Field Name
GDB_116_REL_GLOB False True rel_globalid
UUID_56 True True globalid
FDO_attachmentid True True attachmentid

main.StormwaterDevice__ATTACH

Properties

Key Value
Name main.StormwaterDevice__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 117
Minimum Client Version 10.1
Alias Stormwater Device Attachment
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {199459E0-1662-4497-B7C5-34437CE2B6EB}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid rel_globalid GUID Index False 0 0 38 True False
content_type content_type String False 0 0 150 True False
att_name att_name String False 0 0 250 True False
data_size data_size Long Integer False 0 0 4 True False
data data Blob True 0 0 0 True False
globalid globalid Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_117_REL_GLOB False True rel_globalid
UUID_57 True True globalid
FDO_attachmentid True True attachmentid

main.StormwaterJunction__ATTACH

Properties

Key Value
Name main.StormwaterJunction__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 118
Minimum Client Version 10.1
Alias Stormwater Junction Attachment
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {CB817B9F-6470-423E-A0D6-761375CB619B}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid rel_globalid GUID Index False 0 0 38 True False
content_type content_type String False 0 0 150 True False
att_name att_name String False 0 0 250 True False
data_size data_size Long Integer False 0 0 4 True False
data data Blob True 0 0 0 True False
globalid globalid Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_118_REL_GLOB False True rel_globalid
UUID_58 True True globalid
FDO_attachmentid True True attachmentid

main.StormwaterLine__ATTACH

Properties

Key Value
Name main.StormwaterLine__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 119
Minimum Client Version 10.1
Alias Stormwater Line Attachment
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {14A7C938-6A61-4D8F-BA42-93C080614872}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid rel_globalid GUID Index False 0 0 38 True False
content_type content_type String False 0 0 150 True False
att_name att_name String False 0 0 250 True False
data_size data_size Long Integer False 0 0 4 True False
data data Blob True 0 0 0 True False
globalid globalid Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_119_REL_GLOB False True rel_globalid
UUID_59 True True globalid
FDO_attachmentid True True attachmentid

main.StructureBoundary__ATTACH

Properties

Key Value
Name main.StructureBoundary__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 120
Minimum Client Version 10.1
Alias Structure Boundary Attachment
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {1FEFACD4-6173-4CB8-BBFC-0FA34C23FBFD}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid rel_globalid GUID Index False 0 0 38 True False
content_type content_type String False 0 0 150 True False
att_name att_name String False 0 0 250 True False
data_size data_size Long Integer False 0 0 4 True False
data data Blob True 0 0 0 True False
globalid globalid Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_120_REL_GLOB False True rel_globalid
UUID_60 True True globalid
FDO_attachmentid True True attachmentid

main.StructureJunction__ATTACH

Properties

Key Value
Name main.StructureJunction__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 121
Minimum Client Version 10.1
Alias Structure Junction Attachment
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {C93DFA2A-9055-4A3F-A3C1-1158766EC617}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid rel_globalid GUID Index False 0 0 38 True False
content_type content_type String False 0 0 150 True False
att_name att_name String False 0 0 250 True False
data_size data_size Long Integer False 0 0 4 True False
data data Blob True 0 0 0 True False
globalid globalid Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_121_REL_GLOB False True rel_globalid
UUID_61 True True globalid
FDO_attachmentid True True attachmentid

main.StructureLine__ATTACH

Properties

Key Value
Name main.StructureLine__ATTACH
Dataset Type Table
Feature Dataset
Dataset ID 122
Minimum Client Version 10.1
Alias Structure Line Attachment
OID Field attachmentid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID {5CB7DAD5-6979-4734-A9BE-33FE60113152}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
attachmentid ATTACHMENTID OID Index False 0 0 4 False True
rel_globalid rel_globalid GUID Index False 0 0 38 True False
content_type content_type String False 0 0 150 True False
att_name att_name String False 0 0 250 True False
data_size data_size Long Integer False 0 0 4 True False
data data Blob True 0 0 0 True False
globalid globalid Global ID Index False 0 0 38 False True
created_user created_user String Creator True 0 0 255 False False
created_date created_date Date Created True 0 0 8 False False
last_edited_user last_edited_user String Editor True 0 0 255 False False
last_edited_date last_edited_date Date Edited True 0 0 8 False False

Index

Name Is Unique Is Ascending Field Name
GDB_122_REL_GLOB False True rel_globalid
UUID_62 True True globalid
FDO_attachmentid True True attachmentid

main.DischargeInspection__ATTACHREL

Properties

Key Value
Name main.DischargeInspection__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset
Dataset ID 123
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.DischargeInspection
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.DischargeInspection__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {8BC22580-7FC8-4CE8-AF5A-063D129FB364}
Class ID
Extension Class ID

main.ManholeInspection__ATTACHREL

Properties

Key Value
Name main.ManholeInspection__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset
Dataset ID 124
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.ManholeInspection
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.ManholeInspection__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {F6FBF8AB-8461-4C41-89CA-3C867B43AD21}
Class ID
Extension Class ID

main.StormwaterBMPInspection__ATTACHREL

Properties

Key Value
Name main.StormwaterBMPInspection__ATTACHREL
Dataset Type RelationshipClass
Feature Dataset
Dataset ID 126
Type Composite
Cardinality One To Many
Notification None
Is Attachment True
Is Attributed False
Origin Name main.StormwaterBMPInspection
Origin Primary Key globalid
Origin Foreign Key REL_GLOBALID
Destination Name main.StormwaterBMPInspection__ATTACH
Destination Primary Key
Destination Foreign Key
Forward Path Label attachment
Backward Path Label object
Split Policy
Minimum Client Version 10.0
Alias
OID Field
GlobalID Field
Subtype Field
Default Subtype
Editor Tracking Enabled False
Editor Tracking UTC
Creator Field
Create Date Field
Editor Field
Edit Date Field
Catalog ID {41DCD3D4-572A-4A25-AEF0-84986DCA0096}
Class ID
Extension Class ID

main.GDB_ValidationObjectErrors

Properties

Key Value
Name main.GDB_ValidationObjectErrors
Dataset Type Table
Feature Dataset
Dataset ID 138
Minimum Client Version 10.1
Alias Validation Object Errors
OID Field ObjectID
GlobalID Field GlobalID
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field CREATOR
Create Date Field CREATIONDATE
Editor Field UPDATEDBY
Edit Date Field LASTUPDATE
Catalog ID {E8EDABA8-70B3-45C9-A27E-61DF3F18B270}
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
ObjectID Object ID OID Index False 0 0 4 False True
FeatureClassID Feature class ID Long Integer False 0 0 4 True True
FeatureObjectID Feature object ID Long Integer False 0 0 4 True True
FeatureGlobalID Feature global ID GUID False 0 0 38 True True
ErrorNumber Error number Long Integer False 0 0 4 True True
ErrorMessage Error message String False 0 0 2000 True True
RuleType Rule type Short Integer False Attribute Rule Type 0 0 2 True True
RuleName Rule name String False 0 0 64 True True
RuleID Rule ID Long Integer False 0 0 4 True True
RuleDescription Rule description String True 0 0 256 True True
Severity Severity Long Integer True 0 0 4 True True
IsException Is exception Short Integer True Validation Error Exception 0 0 2 True True
ErrorStatus Error status Long Integer True Validation Error Status 1 0 0 4 True True
ErrorPhase Error phase Long Integer True Validation Error Phase 2 0 0 4 True True
CorrectionNotes Correction notes String True 0 0 256 True True
CorrectionTechnician Correction technician String True 0 0 256 True True
VerificationNotes Verification notes String True 0 0 256 True True
VerificationTechnician Verification technician String True 0 0 256 True True
CREATIONDATE Creation date Date Created False 0 0 8 False True
CREATOR Creator String Creator False 0 0 255 False True
LASTUPDATE Last update Date Edited False 0 0 8 False True
UPDATEDBY Updated by String Editor False 0 0 255 False True
GlobalID Global ID Index False 0 0 38 False True

Index

Name Is Unique Is Ascending Field Name
UUID_63 True True GlobalID
FDO_ObjectID True True ObjectID

main.GDB_ValidationPointErrors

Properties

Key Value
Name main.GDB_ValidationPointErrors
Dataset Type FeatureClass
Feature Dataset
Dataset ID 139
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.1
Alias Validation Point Errors
OID Field ObjectID
GlobalID Field GlobalID
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field CREATOR
Create Date Field CREATIONDATE
Editor Field UPDATEDBY
Edit Date Field LASTUPDATE
Shape Field Shape
Spatial Reference GCS_WGS_1984
X-Min
Y-Min
X-Max
Y-Max
Catalog ID {8FFBDBBB-2376-4CFD-BB58-99F4AE03F967}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
ObjectID Object ID OID Index False 0 0 4 False True
FeatureClassID Feature class ID Long Integer False 0 0 4 True True
FeatureObjectID Feature object ID Long Integer False 0 0 4 True True
FeatureGlobalID Feature global ID GUID False 0 0 38 True True
ErrorNumber Error number Long Integer False 0 0 4 True True
ErrorMessage Error message String False 0 0 2000 True True
RuleType Rule type Short Integer False Attribute Rule Type 0 0 2 True True
RuleName Rule name String False 0 0 64 True True
RuleID Rule ID Long Integer False 0 0 4 True True
RuleDescription Rule description String True 0 0 256 True True
Severity Severity Long Integer True 0 0 4 True True
IsException Is exception Short Integer True Validation Error Exception 0 0 2 True True
ErrorStatus Error status Long Integer True Validation Error Status 1 0 0 4 True True
ErrorPhase Error phase Long Integer True Validation Error Phase 2 0 0 4 True True
CorrectionNotes Correction notes String True 0 0 256 True True
CorrectionTechnician Correction technician String True 0 0 256 True True
VerificationNotes Verification notes String True 0 0 256 True True
VerificationTechnician Verification technician String True 0 0 256 True True
CREATIONDATE Creation date Date Created False 0 0 8 False True
CREATOR Creator String Creator False 0 0 255 False True
LASTUPDATE Last update Date Edited False 0 0 8 False True
UPDATEDBY Updated by String Editor False 0 0 255 False True
Shape Geometry Index True 0 0 8 True True
GlobalID Global ID Index False 0 0 38 False True

Index

Name Is Unique Is Ascending Field Name
UUID_64 True True GlobalID
FDO_ObjectID True True ObjectID
st_spindex__GDB_ValidationPointErrors_Shape True True Shape

main.GDB_ValidationLineErrors

Properties

Key Value
Name main.GDB_ValidationLineErrors
Dataset Type FeatureClass
Feature Dataset
Dataset ID 140
Geometry Type Polyline
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.1
Alias Validation Line Errors
OID Field ObjectID
GlobalID Field GlobalID
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field CREATOR
Create Date Field CREATIONDATE
Editor Field UPDATEDBY
Edit Date Field LASTUPDATE
Shape Field Shape
Spatial Reference GCS_WGS_1984
X-Min
Y-Min
X-Max
Y-Max
Catalog ID {D28CD17E-1F42-4A72-85C0-CF273C95F160}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
ObjectID Object ID OID Index False 0 0 4 False True
FeatureClassID Feature class ID Long Integer False 0 0 4 True True
FeatureObjectID Feature object ID Long Integer False 0 0 4 True True
FeatureGlobalID Feature global ID GUID False 0 0 38 True True
ErrorNumber Error number Long Integer False 0 0 4 True True
ErrorMessage Error message String False 0 0 2000 True True
RuleType Rule type Short Integer False Attribute Rule Type 0 0 2 True True
RuleName Rule name String False 0 0 64 True True
RuleID Rule ID Long Integer False 0 0 4 True True
RuleDescription Rule description String True 0 0 256 True True
Severity Severity Long Integer True 0 0 4 True True
IsException Is exception Short Integer True Validation Error Exception 0 0 2 True True
ErrorStatus Error status Long Integer True Validation Error Status 1 0 0 4 True True
ErrorPhase Error phase Long Integer True Validation Error Phase 2 0 0 4 True True
CorrectionNotes Correction notes String True 0 0 256 True True
CorrectionTechnician Correction technician String True 0 0 256 True True
VerificationNotes Verification notes String True 0 0 256 True True
VerificationTechnician Verification technician String True 0 0 256 True True
CREATIONDATE Creation date Date Created False 0 0 8 False True
CREATOR Creator String Creator False 0 0 255 False True
LASTUPDATE Last update Date Edited False 0 0 8 False True
UPDATEDBY Updated by String Editor False 0 0 255 False True
Shape Geometry Index True 0 0 8 True True
GlobalID Global ID Index False 0 0 38 False True
st_length(Shape) Double Length True 0 0 0 False True

Index

Name Is Unique Is Ascending Field Name
UUID_65 True True GlobalID
FDO_ObjectID True True ObjectID
st_spindex__GDB_ValidationLineErrors_Shape True True Shape

main.GDB_ValidationPolygonErrors

Properties

Key Value
Name main.GDB_ValidationPolygonErrors
Dataset Type FeatureClass
Feature Dataset
Dataset ID 141
Geometry Type Polygon
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.1
Alias Validation Polygon Errors
OID Field ObjectID
GlobalID Field GlobalID
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field CREATOR
Create Date Field CREATIONDATE
Editor Field UPDATEDBY
Edit Date Field LASTUPDATE
Shape Field Shape
Spatial Reference GCS_WGS_1984
X-Min
Y-Min
X-Max
Y-Max
Catalog ID {74B1E277-1635-4B62-8380-4264F369CEEF}
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
ObjectID Object ID OID Index False 0 0 4 False True
FeatureClassID Feature class ID Long Integer False 0 0 4 True True
FeatureObjectID Feature object ID Long Integer False 0 0 4 True True
FeatureGlobalID Feature global ID GUID False 0 0 38 True True
ErrorNumber Error number Long Integer False 0 0 4 True True
ErrorMessage Error message String False 0 0 2000 True True
RuleType Rule type Short Integer False Attribute Rule Type 0 0 2 True True
RuleName Rule name String False 0 0 64 True True
RuleID Rule ID Long Integer False 0 0 4 True True
RuleDescription Rule description String True 0 0 256 True True
Severity Severity Long Integer True 0 0 4 True True
IsException Is exception Short Integer True Validation Error Exception 0 0 2 True True
ErrorStatus Error status Long Integer True Validation Error Status 1 0 0 4 True True
ErrorPhase Error phase Long Integer True Validation Error Phase 2 0 0 4 True True
CorrectionNotes Correction notes String True 0 0 256 True True
CorrectionTechnician Correction technician String True 0 0 256 True True
VerificationNotes Verification notes String True 0 0 256 True True
VerificationTechnician Verification technician String True 0 0 256 True True
CREATIONDATE Creation date Date Created False 0 0 8 False True
CREATOR Creator String Creator False 0 0 255 False True
LASTUPDATE Last update Date Edited False 0 0 8 False True
UPDATEDBY Updated by String Editor False 0 0 255 False True
Shape Geometry Index True 0 0 8 True True
GlobalID Global ID Index False 0 0 38 False True
st_area(Shape) Double Area True 0 0 0 False True
st_perimeter(Shape) Double Length True 0 0 0 False True

Index

Name Is Unique Is Ascending Field Name
UUID_66 True True GlobalID
FDO_ObjectID True True ObjectID
st_spindex__GDB_ValidationPolygonErrors_Shape True True Shape

Domains

Stormwater_Pipe_Liner_Year

Properties

Key Value
Owner
Domain Name Stormwater_Pipe_Liner_Year
Description The liner year of stormwater pipes.
Field Type Short Integer
Domain Type Range
Split Policy Duplicate
Merge Policy Default Value
# of Codes
# of Assignments 1

DomainRange

Minimum Maximum
1800 2060

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 4 Pipe lineryear

Network_6_IsDeleted

Properties

Key Value
Owner
Domain Name Network_6_IsDeleted
Description Indicates if a subnetwork has been marked for deletion.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 0

DomainCodedValue

Code Description Details
0 False
1 True

Construction_Status

Properties

Key Value
Owner
Domain Name Construction_Status
Description Valid Construction statues for the assets.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 8
# of Assignments 28

DomainCodedValue

Code Description Details
0 Warehouse
1 Abandoned
2 Removed
3 Design
4 Approved
5 Under construction
6 Construction complete
7 Maintenance

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary constructionstatus
main.StructureBoundary 401 BMP Boundary constructionstatus
main.StructureBoundary 404 Storm Lift Station Boundary constructionstatus
main.StormwaterJunction constructionstatus
main.StormwaterJunction 23 Wall constructionstatus
main.StormwaterDevice constructionstatus
main.StormwaterDevice 5 Pump constructionstatus
main.StormwaterDevice 26 Weir constructionstatus
main.StormwaterDevice 21 Cleanout constructionstatus
main.StormwaterDevice 28 Catch Basin constructionstatus
main.StormwaterDevice 29 BMP Point constructionstatus
main.StormwaterDevice 22 Outlet constructionstatus
main.StormwaterDevice 30 BMP Inlet constructionstatus
main.StormwaterDevice 23 Connection constructionstatus
main.StormwaterDevice 32 Manhole Channel constructionstatus
main.StructureJunction constructionstatus
main.StructureJunction 208 Sewer Storm Vault constructionstatus
main.StormwaterLine constructionstatus
main.StormwaterLine 4 Pipe constructionstatus
main.StormwaterLine 5 Open Channel constructionstatus
main.StormwaterLine 6 Culvert constructionstatus
main.StormwaterLine 7 Linear Drain constructionstatus
main.StormwaterAssembly constructionstatus
main.StructureLine constructionstatus
main.StructureJunctionObject constructionstatus
main.StructureEdgeObject constructionstatus
main.StormwaterJunctionObject constructionstatus
main.StormwaterEdgeObject constructionstatus

Asset_Type_Structure_Boundary_Storm_Lift_Station_Boundary

Properties

Key Value
Owner
Domain Name Asset_Type_Structure_Boundary_Storm_Lift_Station_Boundary
Description The asset type for the structure boundary's asset group storm pump station.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
42 Lift Station

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary 404 Storm Lift Station Boundary ASSETTYPE

Symbol_Rotation

Properties

Key Value
Owner
Domain Name Symbol_Rotation
Description The rotation of an asset's symbol.
Field Type Short Integer
Domain Type Range
Split Policy Duplicate
Merge Policy Default Value
# of Codes
# of Assignments 15

DomainRange

Minimum Maximum
0 359

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterJunction symbolrotation
main.StormwaterJunction 23 Wall symbolrotation
main.StormwaterDevice symbolrotation
main.StormwaterDevice 5 Pump symbolrotation
main.StormwaterDevice 26 Weir symbolrotation
main.StormwaterDevice 21 Cleanout symbolrotation
main.StormwaterDevice 28 Catch Basin symbolrotation
main.StormwaterDevice 29 BMP Point symbolrotation
main.StormwaterDevice 22 Outlet symbolrotation
main.StormwaterDevice 30 BMP Inlet symbolrotation
main.StormwaterDevice 23 Connection symbolrotation
main.StormwaterDevice 32 Manhole Channel symbolrotation
main.StructureJunction symbolrotation
main.StructureJunction 208 Sewer Storm Vault symbolrotation
main.StormwaterAssembly symbolrotation

Network_6_FeatureSourceID

Properties

Key Value
Owner
Domain Name Network_6_FeatureSourceID
Description The source feature class name in the utility network.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 16
# of Assignments 0

DomainCodedValue

Code Description Details
0 Unknown
1 Association
2 System Junction
3 System Junction Object
4 Structure Junction
5 Structure Line
6 Structure Boundary
7 Structure Junction Object
8 Structure Edge Object
9 Stormwater Device
10 Stormwater Line
11 Stormwater Assembly
12 Stormwater Junction
13 Stormwater Networks
14 Stormwater Junction Object
15 Stormwater Edge Object

Structure_Sewer_Storm_Vault_Manhole_Location

Properties

Key Value
Owner
Domain Name Structure_Sewer_Storm_Vault_Manhole_Location
Description The location of structure manholes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 14
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Main Highway
2 Light Highway
3 Easement/Right of Way
4 Woods
5 Sidewalk
6 Parking Lot
7 Alley
8 Ditch
9 Building
10 Creek
11 Railway
12 Airport
13 Yard

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureJunction 208 Sewer Storm Vault location

Network_6_FlowDirection

Properties

Key Value
Owner
Domain Name Network_6_FlowDirection
Description Indicates how the feature flows in network.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 12

DomainCodedValue

Code Description Details
1 With digitized
2 Against digitized
3 Indeterminate

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine FLOWDIRECTION
main.StormwaterLine 0 Unknown FLOWDIRECTION
main.StormwaterLine 4 Pipe FLOWDIRECTION
main.StormwaterLine 5 Open Channel FLOWDIRECTION
main.StormwaterLine 6 Culvert FLOWDIRECTION
main.StormwaterLine 7 Linear Drain FLOWDIRECTION
main.StructureLine FLOWDIRECTION
main.StructureLine 0 Unknown FLOWDIRECTION
main.StructureEdgeObject FLOWDIRECTION
main.StructureEdgeObject 0 Unknown FLOWDIRECTION
main.StormwaterEdgeObject FLOWDIRECTION
main.StormwaterEdgeObject 0 Unknown FLOWDIRECTION

Structure_Sewer_Storm_Vault_Cover_Shape

Properties

Key Value
Owner
Domain Name Structure_Sewer_Storm_Vault_Cover_Shape
Description The cover shape of structure manholes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 12
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
3 Arched (with flat bottom) - A
4 Barrel - B
5 Circular - C
6 Egg shaped - E
7 Horseshoe - H
8 Oval or Elliptical - O
9 Rectangular - R
10 Square - S
11 Trapezoidal - T
12 U-Shaped with flat top (straight walls) - U
100 Other - Z

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureJunction 208 Sewer Storm Vault covershape

Stormwater_Pump_Type

Properties

Key Value
Owner
Domain Name Stormwater_Pump_Type
Description The type of the stormwater pump.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Centerfugal Pump
2 Duplex Pump
4 Simplex Pump
5 Split-case Pump
6 Triplex Pump
7 Turbine Pump

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 5 Pump designtype

Network_6_TerminalNames

Properties

Key Value
Owner
Domain Name Network_6_TerminalNames
Description The terminal names in the utility network.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 14
# of Assignments 12

DomainCodedValue

Code Description Details
0 None
1 Single Terminal
2 High Pressure In
3 Low Pressure Out
4 Low Pressure In
5 High Pressure Out
6 Inlet Port
7 Outlet Port
8 Port One
9 Port Two
10 Upstream
11 Upstream 2
12 Downstream
13 Downstream 2

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine FROMDEVICETERMINAL
main.StormwaterLine TODEVICETERMINAL
main.StormwaterLine 0 Unknown FROMDEVICETERMINAL
main.StormwaterLine 0 Unknown TODEVICETERMINAL
main.StormwaterLine 4 Pipe FROMDEVICETERMINAL
main.StormwaterLine 4 Pipe TODEVICETERMINAL
main.StormwaterLine 5 Open Channel FROMDEVICETERMINAL
main.StormwaterLine 5 Open Channel TODEVICETERMINAL
main.StormwaterLine 6 Culvert FROMDEVICETERMINAL
main.StormwaterLine 6 Culvert TODEVICETERMINAL
main.StormwaterLine 7 Linear Drain FROMDEVICETERMINAL
main.StormwaterLine 7 Linear Drain TODEVICETERMINAL

Network_6_TierTopologyType

Properties

Key Value
Owner
Domain Name Network_6_TierTopologyType
Description The type of topology for each tier.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 0

DomainCodedValue

Code Description Details
1 Radial
2 Mesh

Asset_Type_Stormwater_Device_Pump

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Device_Pump
Description The asset type for the stormwater device's asset group pump.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown Unknown type of pump.
61 Pump Pump device that convey stormwater from a lower elevation to a higher elevation.

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 5 Pump ASSETTYPE

Network_6_IsContentVisible

Properties

Key Value
Owner
Domain Name Network_6_IsContentVisible
Description Indicates if the content or attachment association is visible for containment associations.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 0

DomainCodedValue

Code Description Details
0 False
1 True

Network_6_AssociationStatus

Properties

Key Value
Owner
Domain Name Network_6_AssociationStatus
Description Indicates how the feature participates in associations.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 36
# of Assignments 39

DomainCodedValue

Code Description Details
0 None
1 Container
2 Structure
4 Content
5 Content and Container
6 Content and Structure
8 Attachment
9 Attachment and Container
10 Attachment and Structure
12 Attachment and Content
13 Attachment and Content and Container
14 Attachment and Content and Structure
16 Visible Content
17 Visible Content and Container
18 Visible Content and Structure
24 Visible Content and Attachment
25 Visible Content and Attachment and Container
26 Visible Content and Attachment and Structure
32 Connectivity
33 Connectivity and Container
34 Connectivity and Structure
36 Connectivity and Content
37 Connectivity and Content and Container
38 Connectivity and Content and Structure
40 Connectivity and Attachment
41 Connectivity and Attachment and Container
42 Connectivity and Attachment and Structure
44 Connectivity and Attachment and Content
45 Connectivity and Attachment and Content and Container
46 Connectivity and Attachment and Content and Structure
48 Connectivity and Visible Content
49 Connectivity and Visible Content and Container
50 Connectivity and Visible Content and Structure
56 Connectivity and Visible Content and Attachment
57 Connectivity and Visible Content and Attachment and Container
58 Connectivity and Visible Content and Attachment and Structure

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary ASSOCIATIONSTATUS
main.StructureBoundary 0 Unknown ASSOCIATIONSTATUS
main.StructureBoundary 401 BMP Boundary ASSOCIATIONSTATUS
main.StructureBoundary 404 Storm Lift Station Boundary ASSOCIATIONSTATUS
main.StormwaterJunction ASSOCIATIONSTATUS
main.StormwaterJunction 0 Unknown ASSOCIATIONSTATUS
main.StormwaterJunction 23 Wall ASSOCIATIONSTATUS
main.StormwaterDevice ASSOCIATIONSTATUS
main.StormwaterDevice 0 Unknown ASSOCIATIONSTATUS
main.StormwaterDevice 5 Pump ASSOCIATIONSTATUS
main.StormwaterDevice 26 Weir ASSOCIATIONSTATUS
main.StormwaterDevice 21 Cleanout ASSOCIATIONSTATUS
main.StormwaterDevice 28 Catch Basin ASSOCIATIONSTATUS
main.StormwaterDevice 29 BMP Point ASSOCIATIONSTATUS
main.StormwaterDevice 22 Outlet ASSOCIATIONSTATUS
main.StormwaterDevice 30 BMP Inlet ASSOCIATIONSTATUS
main.StormwaterDevice 23 Connection ASSOCIATIONSTATUS
main.StormwaterDevice 32 Manhole Channel ASSOCIATIONSTATUS
main.StructureJunction ASSOCIATIONSTATUS
main.StructureJunction 0 Unknown ASSOCIATIONSTATUS
main.StructureJunction 208 Sewer Storm Vault ASSOCIATIONSTATUS
main.StormwaterLine ASSOCIATIONSTATUS
main.StormwaterLine 0 Unknown ASSOCIATIONSTATUS
main.StormwaterLine 4 Pipe ASSOCIATIONSTATUS
main.StormwaterLine 5 Open Channel ASSOCIATIONSTATUS
main.StormwaterLine 6 Culvert ASSOCIATIONSTATUS
main.StormwaterLine 7 Linear Drain ASSOCIATIONSTATUS
main.StormwaterAssembly ASSOCIATIONSTATUS
main.StormwaterAssembly 0 Unknown ASSOCIATIONSTATUS
main.StructureLine ASSOCIATIONSTATUS
main.StructureLine 0 Unknown ASSOCIATIONSTATUS
main.StructureJunctionObject ASSOCIATIONSTATUS
main.StructureJunctionObject 0 Unknown ASSOCIATIONSTATUS
main.StructureEdgeObject ASSOCIATIONSTATUS
main.StructureEdgeObject 0 Unknown ASSOCIATIONSTATUS
main.StormwaterJunctionObject ASSOCIATIONSTATUS
main.StormwaterJunctionObject 0 Unknown ASSOCIATIONSTATUS
main.StormwaterEdgeObject ASSOCIATIONSTATUS
main.StormwaterEdgeObject 0 Unknown ASSOCIATIONSTATUS

Network_6_IsDirty

Properties

Key Value
Owner
Domain Name Network_6_IsDirty
Description Indicates if a subnetwork is clean, dirty, or invalid.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 3
# of Assignments 3

DomainCodedValue

Code Description Details
0 Clean
1 Dirty
2 Invalid

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterSubnetLine ISDIRTY
main.StormwaterSubnetLine 0 Unknown ISDIRTY
main.StormwaterSubnetLine 1 Stormwater Management Area ISDIRTY

Network_6_UnknownAssetType

Properties

Key Value
Owner
Domain Name Network_6_UnknownAssetType
Description The AssetType domain for the Unknown AssetGroup.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 1
# of Assignments 11

DomainCodedValue

Code Description Details
0 Unknown

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary 0 Unknown ASSETTYPE
main.StormwaterJunction 0 Unknown ASSETTYPE
main.StormwaterDevice 0 Unknown ASSETTYPE
main.StructureJunction 0 Unknown ASSETTYPE
main.StormwaterLine 0 Unknown ASSETTYPE
main.StormwaterAssembly 0 Unknown ASSETTYPE
main.StructureLine 0 Unknown ASSETTYPE
main.StructureJunctionObject 0 Unknown ASSETTYPE
main.StructureEdgeObject 0 Unknown ASSETTYPE
main.StormwaterJunctionObject 0 Unknown ASSETTYPE
main.StormwaterEdgeObject 0 Unknown ASSETTYPE

BMP_Class

Properties

Key Value
Owner
Domain Name BMP_Class
Description The class of a BMP.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 2

DomainCodedValue

Code Description Details
0 Unknown
1 Centralized
2 Decentralized

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary 401 BMP Boundary bmpclass
main.StormwaterDevice 29 BMP Point bmpclass

Asset_Manager

Properties

Key Value
Owner
Domain Name Asset_Manager
Description The manager of an asset.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 20

DomainCodedValue

Code Description Details
1 Our Agency
2 Private
100 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterJunction maintby
main.StormwaterJunction 23 Wall maintby
main.StormwaterDevice maintby
main.StormwaterDevice 5 Pump maintby
main.StormwaterDevice 26 Weir maintby
main.StormwaterDevice 21 Cleanout maintby
main.StormwaterDevice 28 Catch Basin maintby
main.StormwaterDevice 29 BMP Point maintby
main.StormwaterDevice 22 Outlet maintby
main.StormwaterDevice 30 BMP Inlet maintby
main.StormwaterDevice 23 Connection maintby
main.StormwaterDevice 32 Manhole Channel maintby
main.StructureJunction maintby
main.StructureJunction 208 Sewer Storm Vault maintby
main.StormwaterLine maintby
main.StormwaterLine 4 Pipe maintby
main.StormwaterLine 5 Open Channel maintby
main.StormwaterLine 6 Culvert maintby
main.StormwaterLine 7 Linear Drain maintby
main.StormwaterAssembly maintby

Asset_Owner

Properties

Key Value
Owner
Domain Name Asset_Owner
Description The owner of an asset.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 20

DomainCodedValue

Code Description Details
1 Our Agency
2 Private
100 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterJunction ownedby
main.StormwaterJunction 23 Wall ownedby
main.StormwaterDevice ownedby
main.StormwaterDevice 5 Pump ownedby
main.StormwaterDevice 26 Weir ownedby
main.StormwaterDevice 21 Cleanout ownedby
main.StormwaterDevice 28 Catch Basin ownedby
main.StormwaterDevice 29 BMP Point ownedby
main.StormwaterDevice 22 Outlet ownedby
main.StormwaterDevice 30 BMP Inlet ownedby
main.StormwaterDevice 23 Connection ownedby
main.StormwaterDevice 32 Manhole Channel ownedby
main.StructureJunction ownedby
main.StructureJunction 208 Sewer Storm Vault ownedby
main.StormwaterLine ownedby
main.StormwaterLine 4 Pipe ownedby
main.StormwaterLine 5 Open Channel ownedby
main.StormwaterLine 6 Culvert ownedby
main.StormwaterLine 7 Linear Drain ownedby
main.StormwaterAssembly ownedby

Stormwater_Cleanout_Material

Properties

Key Value
Owner
Domain Name Stormwater_Cleanout_Material
Description The material of stormwater cleanouts.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 27
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 ABS Plastic - ABS
2 Asbestos Cement - AC
3 Asphalt - ASP
4 Brick - BR
5 Cast Iron - CAS
6 Clay Tile - CT
7 Concrete (Non-Reinforced) - CP
8 Concrete Segments (Bolted) - CSB
9 Concrete Segments (Unbolted) - CSU
10 Cured In Place - CIP
11 Ductile Iron - DIP
12 Fiberglass Reinforced - FRP
13 Galvanized Pipe - GP
14 Glass Reinforced Cement - GRC
15 High Density Polyethylene - HDPE
17 Plastic/Steel Composite - PSC
18 Polyethylene - PE
19 Polypropylene - PP
20 Polyvinyl Chloride - PVC
21 Pre-Stressed Concrete Cylinder - PCCP
22 Reinforced Concrete - RCP
23 Reinforced Plastic (Truss) - RMP
24 Segmented Block - SB
25 Steel - SP
26 Vitrified Clay - VCP
16 Other - OTH

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 21 Cleanout material

Asset_Type_Stormwater_Device_BMP_Inlet

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Device_BMP_Inlet
Description The asset type for the stormwater devices's asset group BMP Inlet.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
6 Apron Inlet
7 Pipe Inlet
8 Channel Inlet

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 30 BMP Inlet ASSETTYPE

Stormwater_Culvert_Shape

Properties

Key Value
Owner
Domain Name Stormwater_Culvert_Shape
Description The shape of stormwater culverts.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 8
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Circular
2 Horseshoe
3 Oblong
4 Rectangular
5 Trapezoidal
6 Triangular
100 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 6 Culvert pipeshape

Asset_Type_Stormwater_Device_BMP_Point

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Device_BMP_Point
Description The asset type for the stormwater device's asset group BMP Point.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 18
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
2 Detention Basin
3 Dry Basin
6 Treatment Vault
7 Wet Basin
8 Bed Filter
9 Infiltration Basin
10 Media Filter
21 Bio-Filtration
22 Bio-Retention
23 Bioswale
24 Filtration Device
25 Infiltration Feature
26 Pervious Pavement
27 Sediment Trap
28 Settling Basin
29 Green Roof
30 Retention Basin

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 29 BMP Point ASSETTYPE

Asset_Type_Stormwater_Device_Catch_Basin

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Device_Catch_Basin
Description The asset type for the stormwater device's asset group catch basin.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
204 Infiltration
205 Sediment Trap
210 Drop Inlet

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 28 Catch Basin ASSETTYPE

Asset_Type_Stormwater_Device_Cleanout

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Device_Cleanout
Description The asset type for the stormwater device's asset group clean out.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Cleanout

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 21 Cleanout ASSETTYPE

Asset_Type_Stormwater_Device_Connection

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Device_Connection
Description The asset type for the stormwater device's asset group pipe connection.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
241 Pipe Connection
242 Open Channel Connection
245 Linear Drain Connection

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 23 Connection ASSETTYPE

Stormwater_Open_Channel_Type

Properties

Key Value
Owner
Domain Name Stormwater_Open_Channel_Type
Description The type of open channel.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
3 Wet
4 Dry

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 5 Open Channel type

Asset_Type_Stormwater_Device_Manhole_Channel

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Device_Manhole_Channel
Description The asset type for the Stormwater device's asset group manhole channel.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
301 Manhole Channel
302 Directional Manhole Channel

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 32 Manhole Channel ASSETTYPE

Stormwater_BMP_Material

Properties

Key Value
Owner
Domain Name Stormwater_BMP_Material
Description The material of stormwater BMPs
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 16
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Amended Soil
2 Biochar
3 Bioretention Soil
4 Brick
5 Concrete
6 Gravel
7 Iron-enhanced Filter
8 Mulch
9 Native Soil
10 Pavers
11 Permeable Pavement
12 Rock
13 Sand Compost Mix
14 Sand Filter
15 Spent Lime

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 29 BMP Point material

Asset_Type_Stormwater_Line_Pipe

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Line_Pipe
Description The asset type for the stormwater line's asset group pipe
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown Unknown type of pipe.
3 Gravity Pipe Pipe in which stormwater flow results from a difference in elevation.
4 Force Pipe Pipes that convey stormwater under pressure from a pump to a discharge point.
5 Perforated Pipe Pipe with small slots or holes to allow stormwater to exit or enter easily.

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 4 Pipe ASSETTYPE

Lifecycle_Combined

Properties

Key Value
Owner
Domain Name Lifecycle_Combined
Description Bitwise combination of lifecycle states for subnetwork management
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 11

DomainCodedValue

Code Description Details
0 Out of Service
1 Proposed
2 In Service
3 Proposed and In Service
4 Planned Removal
6 In Service and Planned Removal

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary lifecyclestatus
main.StormwaterJunction lifecyclestatus
main.StormwaterDevice lifecyclestatus
main.StructureJunction lifecyclestatus
main.StormwaterLine lifecyclestatus
main.StormwaterAssembly lifecyclestatus
main.StructureLine lifecyclestatus
main.StructureJunctionObject lifecyclestatus
main.StructureEdgeObject lifecyclestatus
main.StormwaterJunctionObject lifecyclestatus
main.StormwaterEdgeObject lifecyclestatus

Asset_Type_Stormwater_Device_Weir

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Device_Weir
Description The asset type for the stormwater device's asset group weir.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown Unknown type of weir.
281 Broad-Crested A weir that typically spans the width of a bioswale, or channel, and operates with higher levels of downstream water.
282 Combination A weir designed for areas of varying flows of water.
283 Labyrinth A weir designed to control flow by an increased length in respect to the bioswale or channel's width.
284 Minimum Energy Loss A weir designed for areas of heavy/torrential storms to minimize flooding upstream.
285 Sharp-Crested A weir designed to take accurate measurements of flow and discharge.
286 V-Notch A weir with a "V" shape to minimize the flow of a bioswale or open channel.

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 26 Weir ASSETTYPE

Asset_Type_Stormwater_Device_Outlet

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Device_Outlet
Description The asset type for the stormwater device's asset group discharge.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
5 Pipe Outlet
9 Tide Gate Chamber
10 Apron Outlet
11 Flap Gate
12 Riser

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 22 Outlet ASSETTYPE

Asset_Type_Stormwater_Junction_Wall

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Junction_Wall
Description The asset type for the stormwater junction's asset group wall.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 5
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown Unknown type of wall.
81 Endwall A wall to support a transportation feature and/or protect from erosion at the outlet of a culvert.
82 Headwall A wall to support a transportation feature and/or protect from erosion at the inlet of a culvert.
83 Wingwall An extending wall at a headwall to maintain slope.
84 Floodwall A manmade structure to protect assets from inundation and debris during a storm event.

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterJunction 23 Wall ASSETTYPE

Stormwater_Cleanout_Diameter

Properties

Key Value
Owner
Domain Name Stormwater_Cleanout_Diameter
Description The diameter of stormwater cleanouts.
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 30
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
2 2"
2.5 2 1/2"
3 3"
4 4"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"
30 30"
36 36"
40 40"
42 42"
48 48"
54 54"
60 60"
66 66"
72 72"
75 75"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 21 Cleanout diameter

Event_Level

Properties

Key Value
Owner
Domain Name Event_Level
Description The activate value of a stormwater or sewer device.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 3

DomainCodedValue

Code Description Details
0 Unknown
1 Low Event
50 Medium Event
100 High Event

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 28 Catch Basin activevol
main.StormwaterDevice 22 Outlet activevol
main.StormwaterDevice 23 Connection activevol

Asset_Type_Stormwater_Line_Culvert

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Line_Culvert
Description The asset type for the stormwater line's asset group culvert
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown Unknown type of culvert.
81 Pipe Culvert A culvert made of pipe and typically surrounded by soil or natural materials.
82 Pipe Arch A culvert made of a pipe that has been shaped into a specific width to form an arch.
83 Box Culvert A culvert in a box or rectangular shape allowing for the flow of stormwater through an open channel under a roadway
84 Arch Culvert A culvert in an arch shape allowing for the flow of stormwater through an open channel under a roadway.
85 Bridge Culvert A culvert allowing for the flow of stormwater through an open channel under a bridge.

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 6 Culvert ASSETTYPE

Asset_Type_Stormwater_Line_Linear_Drain

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Line_Linear_Drain
Description The asset type for the stormwater line's asset group linear drain
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
121 Trench Drain
122 Slotted Drain

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 7 Linear Drain ASSETTYPE

Structure_Sewer_Storm_Vault_Manhole_Surface

Properties

Key Value
Owner
Domain Name Structure_Sewer_Storm_Vault_Manhole_Surface
Description The surface type of structure manholes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Asphalt
2 Concrete Pavement
3 Concrete Collar
4 Grass/Dirt
5 Gravel
100 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureJunction 208 Sewer Storm Vault surface

Asset_Type_Stormwater_Line_Open_Channel

Properties

Key Value
Owner
Domain Name Asset_Type_Stormwater_Line_Open_Channel
Description The asset type for the stormwater line's asset group open channel.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
43 Aquaduct Channel
44 Spillway Channel
45 Natural Channel
46 Ditch Channel
47 Roadside Gutter

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 5 Open Channel ASSETTYPE

Asset_Type_Structure_Boundary_BMP_Boundary

Properties

Key Value
Owner
Domain Name Asset_Type_Structure_Boundary_BMP_Boundary
Description The asset type for the structure boundary's asset group BMP.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 18
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
2 Detention Basin
3 Dry Basin
6 Treatment Vault
7 Wet Basin
8 Bed Filter
9 Infiltration Basin
10 Media Filter
21 Bio-Filtration
22 Bio-Retention
23 Bioswale
24 Filtration Device
25 Infiltration Feature
26 Pervious Pavement
27 Sediment Trap
28 Settling Basin
29 Green Roof
30 Retention Basin

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary 401 BMP Boundary ASSETTYPE

Asset_Type_Structure_Junction_Sewer_Storm_Vault

Properties

Key Value
Owner
Domain Name Asset_Type_Structure_Junction_Sewer_Storm_Vault
Description The asset type for the structure junction's asset group sewer storm vault.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown Unknown type of sewer storm vault.
9 Manhole A manhole is a feature that connects two or more pipes and controls the flow of water through the system through the elevation of the pipes.

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureJunction 208 Sewer Storm Vault ASSETTYPE

Stormwater_Exiting_System

Properties

Key Value
Owner
Domain Name Stormwater_Exiting_System
Description The way water exits the stormwater system.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 5

DomainCodedValue

Code Description Details
0 Unknown
1 Waterway
2 Other System
3 None

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 5 Pump exitsystem
main.StormwaterDevice 26 Weir exitsystem
main.StormwaterDevice 28 Catch Basin exitsystem
main.StormwaterDevice 22 Outlet exitsystem
main.StructureJunction 208 Sewer Storm Vault exitsystem

Lifecycle_Status

Properties

Key Value
Owner
Domain Name Lifecycle_Status
Description Valid lifecycle states for the assets.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 17

DomainCodedValue

Code Description Details
0 Out of Service
1 Proposed
2 In Service
4 Planned Removal

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary 401 BMP Boundary lifecyclestatus
main.StructureBoundary 404 Storm Lift Station Boundary lifecyclestatus
main.StormwaterJunction 23 Wall lifecyclestatus
main.StormwaterDevice 5 Pump lifecyclestatus
main.StormwaterDevice 26 Weir lifecyclestatus
main.StormwaterDevice 21 Cleanout lifecyclestatus
main.StormwaterDevice 28 Catch Basin lifecyclestatus
main.StormwaterDevice 29 BMP Point lifecyclestatus
main.StormwaterDevice 22 Outlet lifecyclestatus
main.StormwaterDevice 30 BMP Inlet lifecyclestatus
main.StormwaterDevice 23 Connection lifecyclestatus
main.StormwaterDevice 32 Manhole Channel lifecyclestatus
main.StructureJunction 208 Sewer Storm Vault lifecyclestatus
main.StormwaterLine 4 Pipe lifecyclestatus
main.StormwaterLine 5 Open Channel lifecyclestatus
main.StormwaterLine 6 Culvert lifecyclestatus
main.StormwaterLine 7 Linear Drain lifecyclestatus

Stormwater_Wall_Material

Properties

Key Value
Owner
Domain Name Stormwater_Wall_Material
Description The material of stormwater walls.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 33
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 ABS Plastic - ABS
2 Asbestos Cement - AC
3 Asphalt - ASP
4 Brick - BR
5 Cast Iron - CAS
6 Clay Tile - CT
7 Concrete (Non-Reinforced) - CP
8 Concrete Segments (Bolted) - CSB
9 Concrete Segments (Unbolted) - CSU
10 Cured In Place - CIP
11 Ductile Iron - DIP
12 Fiberglass Reinforced - FRP
13 Galvanized Pipe - GP
14 Glass Reinforced Cement - GRC
15 High Density Polyethylene - HDPE
16 Other - OTH
17 Plastic/Steel Composite - PSC
18 Polyethylene - PE
19 Polypropylene - PP
20 Polyvinyl Chloride - PVC
21 Pre-Stressed Concrete Cylinder - PCCP
22 Reinforced Concrete - RCP
23 Reinforced Plastic (Truss) - RMP
24 Segmented Block - SB
25 Steel - SP
26 Vitrified Clay - VCP
27 Corrugated Metal - CMP
28 Earth & Geotextile - EARGEO
29 Earthen - EAR
30 Geotextile - GEO
31 Transite - TTE
32 Wood - WD

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterJunction 23 Wall material

Manhole_Types

Properties

Key Value
Owner
Domain Name Manhole_Types
Description Types of manholes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 10
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
2 Diversion Manhole
3 Junction Manhole
6 Drop Manhole
7 Drop Trap Manhole
8 Flush Manhole
9 Manhole
10 Offset Manhole
11 Shallow Manhole
12 Siphon Manhole

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureJunction 208 Sewer Storm Vault manholetype

Network_6_IsConnected

Properties

Key Value
Owner
Domain Name Network_6_IsConnected
Description Indicates if the feature is connected to a subnetwork controller.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 24

DomainCodedValue

Code Description Details
0 False
1 True
2 Unknown

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterJunction ISCONNECTED
main.StormwaterJunction 0 Unknown ISCONNECTED
main.StormwaterJunction 23 Wall ISCONNECTED
main.StormwaterDevice ISCONNECTED
main.StormwaterDevice 0 Unknown ISCONNECTED
main.StormwaterDevice 5 Pump ISCONNECTED
main.StormwaterDevice 26 Weir ISCONNECTED
main.StormwaterDevice 21 Cleanout ISCONNECTED
main.StormwaterDevice 28 Catch Basin ISCONNECTED
main.StormwaterDevice 29 BMP Point ISCONNECTED
main.StormwaterDevice 22 Outlet ISCONNECTED
main.StormwaterDevice 30 BMP Inlet ISCONNECTED
main.StormwaterDevice 23 Connection ISCONNECTED
main.StormwaterDevice 32 Manhole Channel ISCONNECTED
main.StormwaterLine ISCONNECTED
main.StormwaterLine 0 Unknown ISCONNECTED
main.StormwaterLine 4 Pipe ISCONNECTED
main.StormwaterLine 5 Open Channel ISCONNECTED
main.StormwaterLine 6 Culvert ISCONNECTED
main.StormwaterLine 7 Linear Drain ISCONNECTED
main.StormwaterJunctionObject ISCONNECTED
main.StormwaterJunctionObject 0 Unknown ISCONNECTED
main.StormwaterEdgeObject ISCONNECTED
main.StormwaterEdgeObject 0 Unknown ISCONNECTED

Spatial_Confidence

Properties

Key Value
Owner
Domain Name Spatial_Confidence
Description Confidence values for the data
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 24

DomainCodedValue

Code Description Details
0 Unknown
1 High
2 Medium
3 Low

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary spatialconfidence
main.StructureBoundary 401 BMP Boundary spatialconfidence
main.StructureBoundary 404 Storm Lift Station Boundary spatialconfidence
main.StormwaterJunction spatialconfidence
main.StormwaterJunction 23 Wall spatialconfidence
main.StormwaterDevice spatialconfidence
main.StormwaterDevice 5 Pump spatialconfidence
main.StormwaterDevice 26 Weir spatialconfidence
main.StormwaterDevice 21 Cleanout spatialconfidence
main.StormwaterDevice 28 Catch Basin spatialconfidence
main.StormwaterDevice 29 BMP Point spatialconfidence
main.StormwaterDevice 22 Outlet spatialconfidence
main.StormwaterDevice 30 BMP Inlet spatialconfidence
main.StormwaterDevice 23 Connection spatialconfidence
main.StormwaterDevice 32 Manhole Channel spatialconfidence
main.StructureJunction spatialconfidence
main.StructureJunction 208 Sewer Storm Vault spatialconfidence
main.StormwaterLine spatialconfidence
main.StormwaterLine 4 Pipe spatialconfidence
main.StormwaterLine 5 Open Channel spatialconfidence
main.StormwaterLine 6 Culvert spatialconfidence
main.StormwaterLine 7 Linear Drain spatialconfidence
main.StormwaterAssembly spatialconfidence
main.StructureLine spatialconfidence

Stormwater_Catch_Basin_Opening_Type

Properties

Key Value
Owner
Domain Name Stormwater_Catch_Basin_Opening_Type
Description The type of catch basin
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Curb Opening
2 Grate
3 Combination

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 28 Catch Basin designtype

Spatial_Source

Properties

Key Value
Owner
Domain Name Spatial_Source
Description Source of the data
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 24

DomainCodedValue

Code Description Details
0 Unknown
1 As-Built
2 CAD
3 Digitized
4 GPS/GNSS
5 Field Sketch

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary spatialsource
main.StructureBoundary 401 BMP Boundary spatialsource
main.StructureBoundary 404 Storm Lift Station Boundary spatialsource
main.StormwaterJunction spatialsource
main.StormwaterJunction 23 Wall spatialsource
main.StormwaterDevice spatialsource
main.StormwaterDevice 5 Pump spatialsource
main.StormwaterDevice 26 Weir spatialsource
main.StormwaterDevice 21 Cleanout spatialsource
main.StormwaterDevice 28 Catch Basin spatialsource
main.StormwaterDevice 29 BMP Point spatialsource
main.StormwaterDevice 22 Outlet spatialsource
main.StormwaterDevice 30 BMP Inlet spatialsource
main.StormwaterDevice 23 Connection spatialsource
main.StormwaterDevice 32 Manhole Channel spatialsource
main.StructureJunction spatialsource
main.StructureJunction 208 Sewer Storm Vault spatialsource
main.StormwaterLine spatialsource
main.StormwaterLine 4 Pipe spatialsource
main.StormwaterLine 5 Open Channel spatialsource
main.StormwaterLine 6 Culvert spatialsource
main.StormwaterLine 7 Linear Drain spatialsource
main.StormwaterAssembly spatialsource
main.StructureLine spatialsource

Stormwater_Pipe_Material

Properties

Key Value
Owner
Domain Name Stormwater_Pipe_Material
Description The material of stormwater pipes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 27
# of Assignments 3

DomainCodedValue

Code Description Details
0 Unknown
1 ABS Plastic - ABS
2 Asbestos Cement - AC
3 Asphalt - ASP
4 Brick - BR
5 Cast Iron - CAS
6 Clay Tile - CT
7 Concrete (Non-Reinforced) - CP
8 Concrete Segments (Bolted) - CSB
9 Concrete Segments (Unbolted) - CSU
10 Cured In Place - CIP
11 Ductile Iron - DIP
12 Fiberglass Reinforced - FRP
13 Galvanized Pipe - GP
14 Glass Reinforced Cement - GRC
15 High Density Polyethylene - HDPE
16 Other - OTH
17 Plastic/Steel Composite - PSC
18 Polyethylene - PE
19 Polypropylene - PP
20 Polyvinyl Chloride - PVC
21 Pre-Stressed Concrete Cylinder - PCCP
22 Reinforced Concrete - RCP
23 Reinforced Plastic (Truss) - RMP
24 Segmented Block - SB
25 Steel - SP
26 Vitrified Clay - VCP

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 4 Pipe material
main.StormwaterLine 6 Culvert material
main.StormwaterLine 7 Linear Drain material

Stormwater_Inlet_Shape

Properties

Key Value
Owner
Domain Name Stormwater_Inlet_Shape
Description The shpae of the stormwater inlet.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Round
2 Square
3 Rectangle

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 28 Catch Basin inletshape

Stormwater_Outlet_Diameter

Properties

Key Value
Owner
Domain Name Stormwater_Outlet_Diameter
Description The diameter of a stormwater oulet.
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 29
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.5 1 1/2"
2 2"
2.5 2 1/2"
3 3"
4 4"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"
30 30"
36 36"
40 40"
42 42"
48 48"
54 54"
60 60"
66 66"
72 72"
75 75"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 22 Outlet diameter

Stormwater_Outlet_Location

Properties

Key Value
Owner
Domain Name Stormwater_Outlet_Location
Description The location of the stormwater oulet.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Closed Pipe
2 Open Drainage
3 In-Stream

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 22 Outlet location

Stormwater_Outlet_Material

Properties

Key Value
Owner
Domain Name Stormwater_Outlet_Material
Description The material of stormwater outlets.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 27
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 ABS Plastic - ABS
2 Asbestos Cement - AC
3 Asphalt - ASP
4 Brick - BR
5 Cast Iron - CAS
6 Clay Tile - CT
7 Concrete (Non-Reinforced) - CP
8 Concrete Segments (Bolted) - CSB
9 Concrete Segments (Unbolted) - CSU
10 Cured In Place - CIP
11 Ductile Iron - DIP
12 Fiberglass Reinforced - FRP
13 Galvanized Pipe - GP
14 Glass Reinforced Cement - GRC
15 High Density Polyethylene - HDPE
16 Other - OTH
17 Plastic/Steel Composite - PSC
18 Polyethylene - PE
19 Polypropylene - PP
20 Polyvinyl Chloride - PVC
21 Pre-Stressed Concrete Cylinder - PCCP
22 Reinforced Concrete - RCP
23 Reinforced Plastic (Truss) - RMP
24 Segmented Block - SB
25 Steel - SP
26 Vitrified Clay - VCP

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 22 Outlet material

Stormwater_Pipe_Diameter

Properties

Key Value
Owner
Domain Name Stormwater_Pipe_Diameter
Description The diameter of stormwater pipes.
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 30
# of Assignments 2

DomainCodedValue

Code Description Details
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
2 2"
2.5 2 1/2"
3 3"
4 4"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"
30 30"
36 36"
40 40"
42 42"
48 48"
54 54"
60 60"
66 66"
72 72"
75 75"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 4 Pipe diameter
main.StormwaterLine 7 Linear Drain diameter

Stormwater_Pipe_Liner_Method

Properties

Key Value
Owner
Domain Name Stormwater_Pipe_Liner_Method
Description The liner method of stormwater pipes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 14
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Cured In Place - CIP
2 Fold and Form or Deform/Reform - FF
3 Formed-In-Place Liner - FP
4 Grout-In-Place Liner - GP
5 Glass Reinforced Cement - GRC
6 None - N
7 Continuous Slip Liner - SC
8 Sectional Slip Liner - SE
9 Spray Liner - SL
10 Segmented Panel - SN
11 Segmented Pipe - SP
12 Spiral Wound - SW
100 Other - ZZ

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 4 Pipe linermethod

Stormwater_Pipe_Shape

Properties

Key Value
Owner
Domain Name Stormwater_Pipe_Shape
Description The shape of stormwater pipes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 8
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Circular
2 Horseshoe
3 Oblong
4 Rectangular
5 Trapezoidal
6 Triangular
100 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterLine 4 Pipe pipeshape

Structure_Boundary_BMP_Condition

Properties

Key Value
Owner
Domain Name Structure_Boundary_BMP_Condition
Description The condition of a BMP.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 More Data Needed
2 Inspection Due
3 Inspected >4
4 Inspected 3-4
5 Inspected 2-3
6 Inspected <2

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureBoundary 401 BMP Boundary assetcondition

Structure_Sewer_Storm_Manhole_Step_Material

Properties

Key Value
Owner
Domain Name Structure_Sewer_Storm_Manhole_Step_Material
Description The step material of structure manholes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 5
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
4 Brick - BR
16 Other - OTH
33 Metal - M
34 Plastic - P

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureJunction 208 Sewer Storm Vault stepmaterial

Structure_Sewer_Storm_Materials

Properties

Key Value
Owner
Domain Name Structure_Sewer_Storm_Materials
Description The materials of sewer storm structures.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 12
# of Assignments 3

DomainCodedValue

Code Description Details
0 Unknown
1 ABS Plastic - ABS
5 Cast Iron - CAS
11 Ductile Iron - DIP
15 High Density Polyethylene - HDPE
17 Plastic/Steel Composite - PSC
18 Polyethylene - PE
19 Polypropylene - PP
20 Polyvinyl Chloride - PVC
23 Reinforced Plastic (Truss) - RMP
25 Steel - SP
100 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 28 Catch Basin material
main.StructureJunction 208 Sewer Storm Vault material
main.StructureJunction 208 Sewer Storm Vault wallmaterial

Structure_Sewer_Storm_Vault_Cover_Type

Properties

Key Value
Owner
Domain Name Structure_Sewer_Storm_Vault_Cover_Type
Description The cover type of structure manholes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
3 Solid
4 Vented/Slotted
5 Gasketed
6 Bolted
7 Inner Cover
8 Locking

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureJunction 208 Sewer Storm Vault type

Structure_Sewer_Storm_Vault_Manhole_Cone

Properties

Key Value
Owner
Domain Name Structure_Sewer_Storm_Vault_Manhole_Cone
Description The cone type of structure manholes.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Straight
2 Offset

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StructureJunction 208 Sewer Storm Vault conetype

Validation Error Phase

Properties

Key Value
Owner
Domain Name Validation Error Phase
Description Indicates error lifecycle phase of an error
Field Type Long Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 3
# of Assignments 4

DomainCodedValue

Code Description Details
2 Review
4 Correction
6 Verification

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.GDB_ValidationObjectErrors ErrorPhase
main.GDB_ValidationPointErrors ErrorPhase
main.GDB_ValidationLineErrors ErrorPhase
main.GDB_ValidationPolygonErrors ErrorPhase

Validation Error Status

Properties

Key Value
Owner
Domain Name Validation Error Status
Description Indicates error lifecycle status of an error
Field Type Long Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 6
# of Assignments 4

DomainCodedValue

Code Description Details
1 Reviewed
2 Resolved
3 Mark As Exception
4 Acceptable
6 Unacceptable
9 Exception

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.GDB_ValidationObjectErrors ErrorStatus
main.GDB_ValidationPointErrors ErrorStatus
main.GDB_ValidationLineErrors ErrorStatus
main.GDB_ValidationPolygonErrors ErrorStatus

Validation_Status

Properties

Key Value
Owner
Domain Name Validation_Status
Description The current record's validation status.
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 8
# of Assignments 0

DomainCodedValue

Code Description Details
0 No calculation required, no validation required, no error
1 No calculation required, no validation required, has error(s)
2 No calculation required, validation required, no error
3 No calculation required, validation required, has error(s)
4 Calculation required, no validation required, no error
5 Calculation required, no validation required, has error(s)
6 Calculation required, validation required, no error
7 Calculation required, validation required, has error(s)

Yes_No

Properties

Key Value
Owner
Domain Name Yes_No
Description A yes/no indicator
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 20

DomainCodedValue

Code Description Details
0 Unknown
1 Yes
2 No

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice 26 Weir orifice
main.StormwaterDevice 26 Weir permitted
main.StormwaterDevice 26 Weir surfacewater
main.StormwaterDevice 26 Weir wingwall
main.StormwaterDevice 28 Catch Basin signage
main.StormwaterDevice 28 Catch Basin sump
main.StormwaterDevice 28 Catch Basin surfacewater
main.StormwaterDevice 29 BMP Point confinedspace
main.StormwaterDevice 29 BMP Point observationport
main.StormwaterDevice 29 BMP Point reuse
main.StormwaterDevice 22 Outlet outfall
main.StormwaterDevice 22 Outlet permitted
main.StormwaterDevice 22 Outlet surfacewater
main.StormwaterDevice 30 BMP Inlet permitted
main.StructureJunction 208 Sewer Storm Vault bench
main.StructureJunction 208 Sewer Storm Vault channel
main.StructureJunction 208 Sewer Storm Vault surfacewater
main.StructureJunction 208 Sewer Storm Vault wall
main.StormwaterLine 4 Pipe lined
main.StormwaterLine 6 Culvert wall

Network_6_IsSubnetworkController

Properties

Key Value
Owner
Domain Name Network_6_IsSubnetworkController
Description Indicates if a device feature is a subnetwork controller.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 13

DomainCodedValue

Code Description Details
0 False
1 True

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice ISSUBNETWORKCONTROLLER
main.StormwaterDevice 0 Unknown ISSUBNETWORKCONTROLLER
main.StormwaterDevice 5 Pump ISSUBNETWORKCONTROLLER
main.StormwaterDevice 26 Weir ISSUBNETWORKCONTROLLER
main.StormwaterDevice 21 Cleanout ISSUBNETWORKCONTROLLER
main.StormwaterDevice 28 Catch Basin ISSUBNETWORKCONTROLLER
main.StormwaterDevice 29 BMP Point ISSUBNETWORKCONTROLLER
main.StormwaterDevice 22 Outlet ISSUBNETWORKCONTROLLER
main.StormwaterDevice 30 BMP Inlet ISSUBNETWORKCONTROLLER
main.StormwaterDevice 23 Connection ISSUBNETWORKCONTROLLER
main.StormwaterDevice 32 Manhole Channel ISSUBNETWORKCONTROLLER
main.StormwaterJunctionObject ISSUBNETWORKCONTROLLER
main.StormwaterJunctionObject 0 Unknown ISSUBNETWORKCONTROLLER

Network_6_TierName

Properties

Key Value
Owner
Domain Name Network_6_TierName
Description The tier names in the utility network.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 13

DomainCodedValue

Code Description Details
0 Unknown
1 Stormwater Management Area

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice TIERNAME
main.StormwaterDevice 0 Unknown TIERNAME
main.StormwaterDevice 5 Pump TIERNAME
main.StormwaterDevice 26 Weir TIERNAME
main.StormwaterDevice 21 Cleanout TIERNAME
main.StormwaterDevice 28 Catch Basin TIERNAME
main.StormwaterDevice 29 BMP Point TIERNAME
main.StormwaterDevice 22 Outlet TIERNAME
main.StormwaterDevice 30 BMP Inlet TIERNAME
main.StormwaterDevice 23 Connection TIERNAME
main.StormwaterDevice 32 Manhole Channel TIERNAME
main.StormwaterJunctionObject TIERNAME
main.StormwaterJunctionObject 0 Unknown TIERNAME

Attribute Rule Type

Properties

Key Value
Owner
Domain Name Attribute Rule Type
Description The attribute rule type that created the error record.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 3
# of Assignments 4

DomainCodedValue

Code Description Details
0 Calculation
1 Constraint
2 Validation

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.GDB_ValidationObjectErrors RuleType
main.GDB_ValidationPointErrors RuleType
main.GDB_ValidationLineErrors RuleType
main.GDB_ValidationPolygonErrors RuleType

Validation Error Exception

Properties

Key Value
Owner
Domain Name Validation Error Exception
Description Indicates if the error record has been marked as an exception.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 4

DomainCodedValue

Code Description Details
0 False
1 True

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.GDB_ValidationObjectErrors IsException
main.GDB_ValidationPointErrors IsException
main.GDB_ValidationLineErrors IsException
main.GDB_ValidationPolygonErrors IsException

Validation Status

Properties

Key Value
Owner
Domain Name Validation Status
Description The current record's validation status.
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 8
# of Assignments 20

DomainCodedValue

Code Description Details
0 No calculation required, no validation required, no error
1 No calculation required, no validation required, has error(s)
2 No calculation required, validation required, no error
3 No calculation required, validation required, has error(s)
4 Calculation required, no validation required, no error
5 Calculation required, no validation required, has error(s)
6 Calculation required, validation required, no error
7 Calculation required, validation required, has error(s)

DomainUsage

Dataset Subtype Code Subtype Name Field Name
main.StormwaterDevice VALIDATIONSTATUS
main.StormwaterDevice 0 Unknown VALIDATIONSTATUS
main.StormwaterDevice 5 Pump VALIDATIONSTATUS
main.StormwaterDevice 26 Weir VALIDATIONSTATUS
main.StormwaterDevice 21 Cleanout VALIDATIONSTATUS
main.StormwaterDevice 28 Catch Basin VALIDATIONSTATUS
main.StormwaterDevice 29 BMP Point VALIDATIONSTATUS
main.StormwaterDevice 22 Outlet VALIDATIONSTATUS
main.StormwaterDevice 30 BMP Inlet VALIDATIONSTATUS
main.StormwaterDevice 23 Connection VALIDATIONSTATUS
main.StormwaterDevice 32 Manhole Channel VALIDATIONSTATUS
main.StructureJunction VALIDATIONSTATUS
main.StructureJunction 0 Unknown VALIDATIONSTATUS
main.StructureJunction 208 Sewer Storm Vault VALIDATIONSTATUS
main.StormwaterLine VALIDATIONSTATUS
main.StormwaterLine 0 Unknown VALIDATIONSTATUS
main.StormwaterLine 4 Pipe VALIDATIONSTATUS
main.StormwaterLine 5 Open Channel VALIDATIONSTATUS
main.StormwaterLine 6 Culvert VALIDATIONSTATUS
main.StormwaterLine 7 Linear Drain VALIDATIONSTATUS