SewerExpanded_UtilityNetwork

Workspace

Key	Value
Name	SewerExpanded_UtilityNetwork.geodatabase
Workspace Type	Local Database
Workspace Factory	Sqlite
Geodatabase Release	3.0.0
Date Exported	2025-06-09 12:57:22
Path

Domain Name	Description	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
Asset_Type_Sewer_Device_Anode	The Asset Types for the Sewer Device's Asset Group Anode	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Device_Backflow_Preventer	The asset type for the sewer device's asset group backflow preventer.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Sewer_Device_Cleanout	The asset type for the sewer device's asset group cleanout.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Sewer_Device_Connection	The asset type for the sewer device's asset group connection point.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Sewer_Device_Controllable_Valve	The asset type for the sewer device's asset group controllable valve	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Device_Flow_Valve	The asset type for the sewer device's asset group flow valve.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Sewer_Device_Gate	The asset type for the sewer device's asset group gate.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Device_Grease_Trap	The asset type for the sewer device's asset group grease trap.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Sewer_Device_Groundbed	The Asset Type domain for the asset group's groundbed.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Sewer_Device_Manhole_Channel	The asset type for the sewer device's asset group manhole channel.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Device_Meter	The asset type for the sewer device's asset group meter.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Device_Monitoring	The asset type for the sewer junction's asset group monitoring	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Device_Outlet	The Asset Types for the sewer device asset group outlet.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Device_Pump	The asset type for the sewer device's asset group pump.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Device_Rectifier	The Asset Types for the Sewer Device Asset Group Rectifier	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Sewer_Device_Relief_Valve	The asset type for the sewer device's asset group relief valve.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Sewer_Device_Service_Connection	The asset type for the sewer device's asset group service connection.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Sewer_Device_Test_Point	The Asset Types for the Sewer Device's Asset Group Test Point	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Sewer_Device_Treatment	The asset type for the sewer device's asset group treatment.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Sewer_Device_Weir	The asset type for the sewer device's asset group weir.	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Sewer_Junction_Fitting	The asset type for the sewer junction's asset group fitting.	Short Integer	Coded Value	Duplicate	Default Value	20	1
Asset_Type_Sewer_Junction_Insulation_Junction	The Asset Types for the Sewer Junction's Asset Group Insulation Junction	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Sewer_Junction_Wire_Junction	The Asset Types for the Sewer Junction's Asset Group Wire Junction	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Line_Bonding_Line	The Asset Types for the Sewer Line's Asset Group Bonding Line	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Line_Lateral_Service	The asset type for the sewer line's lateral service.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Sewer_Line_Rectifier_Cable	The Asset Types for the Sewer Line's Asset Group Rectifier Cable	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Sewer_Line_Sewer_Force_Main	The asset type for the sewer line's asset group sewer force main.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Sewer_Line_Sewer_Gravity_Main	The asset type for the sewer line's asset group sewer gravity main.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Sewer_Line_Test_Lead_Wire	The Asset Types for the Sewer Line's Asset Group Test Lead Wire	Short Integer	Coded Value	Duplicate	Default Value	11	1
Asset_Type_Structure_Boundary_Sewer_Lift_Station_Boundary	The asset type of the structure boundary's asset group sewer lift station footprint.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Boundary_Sewer_Storm_Vault_Boundary	The asset type for the structure boundary's asset group sewer storm vault	Short Integer	Coded Value	Duplicate	Default Value	5	1
Asset_Type_Structure_Boundary_Sewer_Treatment_Plant_Boundary	The asset type of the structure boundary's asset group sewer treatment plant footprint.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Sewer_Lift_Station	The asset type for the structure junction's asset group sewer lift station.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Sewer_Storm_Vault	The asset type for the structure junction's asset group sewer storm vault.	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Structure_Line_Sewer_Storm_Casing	The asset type for the structure line's asset group sewer storm casing.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Attribute Rule Type	The attribute rule type that created the error record.	Short Integer	Coded Value	Default Value	Default Value	3	4
Backflow_Preventer_Manufacturer	Manufacturers of backflow preventers	Short Integer	Coded Value	Duplicate	Default Value	12	1
Bonded_Insulated	Values to indicate if a feature is bonded or insulated.	Short Integer	Coded Value	Duplicate	Default Value	2	34
Construction_Status	Valid Construction statues for the assets.	Short Integer	Coded Value	Duplicate	Default Value	8	57
CP_Anode_Material	List of materials used for Anodes	Short Integer	Coded Value	Duplicate	Default Value	11	1
CP_Anode_Weight	List of valid anode weights	Double	Coded Value	Duplicate	Default Value	11	1
CP_Rectifier_Cooling_Method	List of rectifier cooling methods	Short Integer	Coded Value	Duplicate	Default Value	5	1
CP_Rectifier_Manufacturer	List of manufacturers for rectifiers	Short Integer	Coded Value	Duplicate	Default Value	5	1
CP_Test_Point_Wire_Count	Number of wires on a test point	Short Integer	Coded Value	Duplicate	Default Value	9	1
CP_Traceability	Valid cathodic protection status values	Short Integer	Coded Value	Duplicate	Default Value	2	66
CP_Wire_Gauge	List of valid sizes used for wire/cable gauges	Double	Coded Value	Duplicate	Default Value	3	3
Event_Level	The event level value of a stormwater or sewer device.	Short Integer	Coded Value	Duplicate	Default Value	4	3
Groundbed_Depth	The depth of bed.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Inspection_Manhole_Adjustable_Ring_Condition		Short Integer	Coded Value	Duplicate	Default Value	7	1
Inspection_Manhole_Cover_Condition		Short Integer	Coded Value	Duplicate	Default Value	7	1
Inspection_Manhole_Cover_Fit		Short Integer	Coded Value	Duplicate	Default Value	5	1
Inspection_Manhole_Cover_Insert_Condition		Short Integer	Coded Value	Duplicate	Default Value	6	1
Inspection_Manhole_Frame_Condition		Short Integer	Coded Value	Duplicate	Default Value	7	1
Inspection_Manhole_Frame_Seal_Condition		Short Integer	Coded Value	Duplicate	Default Value	5	1
Inspection_Manhole_Frame_Seal_Inflow		Short Integer	Coded Value	Duplicate	Default Value	8	1
Inspection_Manhole_Pre-Cleaning		Short Integer	Coded Value	Duplicate	Default Value	4	1
Inspection_Manhole_Purpose		Short Integer	Coded Value	Duplicate	Default Value	9	1
Inspection_Manhole_Runoff_Potential		Short Integer	Coded Value	Duplicate	Default Value	4	1
Inspection_Manhole_Status		Short Integer	Coded Value	Duplicate	Default Value	10	1
Inspection_Manhole_Weather		Short Integer	Coded Value	Duplicate	Default Value	8	1
Lifecycle_Combined	Bitwise combination of lifecycle states for subnetwork management	Short Integer	Coded Value	Duplicate	Default Value	6	11
Lifecycle_Status	Valid lifecycle states for the assets.	Short Integer	Coded Value	Duplicate	Default Value	4	46
Location	Specifies the location of an asset being inside or outside	Short Integer	Coded Value	Duplicate	Default Value	3	1
Network_6_AssociationStatus	Indicates how the feature participates in associations.	Short Integer	Coded Value	Duplicate	Default Value	36	57
Network_6_FeatureSourceID	The source feature class name in the utility network.	Short Integer	Coded Value	Default Value	Default Value	16	0
Network_6_FlowDirection	Indicates how the feature flows in network.	Short Integer	Coded Value	Duplicate	Default Value	3	15
Network_6_IsConnected	Indicates if the feature is connected to a subnetwork controller.	Short Integer	Coded Value	Duplicate	Default Value	3	39
Network_6_IsContentVisible	Indicates if the content or attachment association is visible for containment associations.	Short Integer	Coded Value	Default Value	Default Value	2	0
Network_6_IsDeleted	Indicates if a subnetwork has been marked for deletion.	Short Integer	Coded Value	Default Value	Default Value	2	0
Network_6_IsDirty	Indicates if a subnetwork is clean, dirty, or invalid.	Short Integer	Coded Value	Default Value	Default Value	3	5
Network_6_IsSubnetworkController	Indicates if a device feature is a subnetwork controller.	Short Integer	Coded Value	Default Value	Default Value	2	24
Network_6_TerminalNames	The terminal names in the utility network.	Short Integer	Coded Value	Duplicate	Default Value	22	16
Network_6_TierName	The tier names in the utility network.	Short Integer	Coded Value	Default Value	Default Value	4	24
Network_6_TierTopologyType	The type of topology for each tier.	Short Integer	Coded Value	Default Value	Default Value	2	0
Network_6_UnknownAssetType	The AssetType domain for the Unknown AssetGroup.	Short Integer	Coded Value	Default Value	Default Value	1	11
Operable_Status	Status of an operable device	Short Integer	Coded Value	Duplicate	Default Value	2	2
Pipeline_Valve_Close_Direction	The close direction of a valve	Short Integer	Coded Value	Duplicate	Default Value	2	1
Pipeline_Valve_Status	The state of a device	Short Integer	Coded Value	Duplicate	Default Value	2	5
Sewer_Asset_Manager	The manager of the asset.	Short Integer	Coded Value	Duplicate	Default Value	3	41
Sewer_Asset_Owner	The owner of the asset.	Short Integer	Coded Value	Duplicate	Default Value	3	41
Sewer_Cleanout_Access_Diameter	The access diameter of sewer cleanouts.	Double	Coded Value	Duplicate	Default Value	20	1
Sewer_Cleanout_Material	The material of sewer cleanouts.	Short Integer	Coded Value	Duplicate	Default Value	11	1
Sewer_Controllable_Valve_Diameter	The diameter of sewer controllable valves.	Double	Coded Value	Duplicate	Default Value	30	1
Sewer_Controllable_Valve_Type	The types of sewer controllable valves.	Short Integer	Coded Value	Duplicate	Default Value	6	1
Sewer_Flow_Valve_Diameter	The diameter of a sewer flow valve.	Double	Coded Value	Duplicate	Default Value	30	1
Sewer_Lateral_Diameter	The diameter of sewer laterals.	Double	Coded Value	Duplicate	Default Value	20	1
Sewer_Lateral_Material	The material of sewer laterals.	Short Integer	Coded Value	Duplicate	Default Value	11	1
Sewer_Main_Diameter	The diameter of sewer interceptor mains.	Double	Coded Value	Duplicate	Default Value	30	2
Sewer_Main_Liner	The lining method of sewer collector mains.	Short Integer	Coded Value	Duplicate	Default Value	14	2
Sewer_Main_Material	The material of sewer mains.	Short Integer	Coded Value	Duplicate	Default Value	27	2
Sewer_Main_Shape	The shape of sewer collector mains.	Short Integer	Coded Value	Duplicate	Default Value	7	2
Sewer_Pump_Discharge_Diameter	The discharge diameter of sewer pumps.	Double	Coded Value	Duplicate	Default Value	14	1
Sewer_Pump_Inlet_Diameter	The inlet diameter of sewer pumps.	Double	Coded Value	Duplicate	Default Value	14	1
Sewer_Pump_Type	The type of sewer pumps.	Short Integer	Coded Value	Duplicate	Default Value	8	1
Sewer_Relief_Valve_Diameter	The diameter of sewer relief valves.	Double	Coded Value	Duplicate	Default Value	30	1
Sewer_Storm_Manhole_Type	The types of sewer and storm manholes.	Short Integer	Coded Value	Duplicate	Default Value	10	1
Spatial_Confidence	Confidence values for the data	Short Integer	Coded Value	Duplicate	Default Value	4	42
Spatial_Source	Source of the data	Short Integer	Coded Value	Duplicate	Default Value	6	42
Structure_Sewer_Storm_Access_Point_Cover_Shape	The cover shape of structure sewer storm access points.	Short Integer	Coded Value	Duplicate	Default Value	10	1
Structure_Sewer_Storm_Casing_Diameter	The diameter of structure sewer storm casings.	Double	Coded Value	Duplicate	Default Value	7	1
Structure_Sewer_Storm_Manhole_Frame_Material	The material of the frame of a manhole structure	Short Integer	Coded Value	Duplicate	Default Value	12	1
Structure_Sewer_Storm_Manhole_Step_Material	The material of the steps of a manhole structure	Short Integer	Coded Value	Duplicate	Default Value	4	1
Structure_Sewer_Storm_Manhole_Surface	The surface type of structure manholes.	Short Integer	Coded Value	Duplicate	Default Value	7	1
Structure_Sewer_Storm_Manhole_Wall_Material	The material of the wall of a manhole structure	Short Integer	Coded Value	Duplicate	Default Value	7	1
Structure_Sewer_Storm_Vault_Manhole_Cone	The cone type of structure manholes.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Structure_Sewer_Storm_Vault_Manhole_Location	The location of structure manholes.	Short Integer	Coded Value	Duplicate	Default Value	14	1
Symbol_Rotation	Valid range of degrees for rotation	Short Integer	Range	Duplicate	Default Value		31
Validation Error Exception	Indicates if the error record has been marked as an exception.	Short Integer	Coded Value	Default Value	Default Value	2	4
Validation Error Phase	Indicates error lifecycle phase of an error	Long Integer	Coded Value	Default Value	Default Value	3	4
Validation Error Status	Indicates error lifecycle status of an error	Long Integer	Coded Value	Default Value	Default Value	6	4
Validation Status	The current record's validation status.	Short Integer	Coded Value	Default Value	Default Value	8	47
Yes_No	A yes/no indicator	Short Integer	Coded Value	Duplicate	Default Value	3	7

Datasets

main.GDB_ValidationLineErrors

Properties

Key	Value
Name	main.GDB_ValidationLineErrors
Dataset Type	FeatureClass
Dataset ID	171
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
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
Catalog ID	{73888E48-9209-426E-9816-BEE4C85AFEE8}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

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

Indexes

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

main.GDB_ValidationObjectErrors

Properties

Key	Value
Name	main.GDB_ValidationObjectErrors
Dataset Type	Table
Dataset ID	169
Minimum Client Version	10.1
Alias	Validation Object Errors
OID Field	ObjectID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	CREATOR
Create Date Field	CREATIONDATE
Editor Field	UPDATEDBY
Edit Date Field	LASTUPDATE
Catalog ID	{7F82740A-0DEB-4572-8185-19E0EC7B845F}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

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

Indexes

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

main.GDB_ValidationPointErrors

Properties

Key	Value
Name	main.GDB_ValidationPointErrors
Dataset Type	FeatureClass
Dataset ID	170
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
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
Catalog ID	{5A009019-3CEB-40CA-8EB0-023A5F821B64}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

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

Indexes

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

main.GDB_ValidationPolygonErrors

Properties

Key	Value
Name	main.GDB_ValidationPolygonErrors
Dataset Type	FeatureClass
Dataset ID	172
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
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
Catalog ID	{5DC61610-394B-40BC-80D5-FE42B521AF0A}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

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

Indexes

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

main.Network

Key	Value
Name	main.Network
Dataset Type	UtilityNetwork
Feature Dataset	main.UtilityNetwork
Dataset ID	6
Schema Generation	7
Pro Version	ArcGIS Pro 3.5.1
Creation Time	2025-06-09 11:50:30
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min	500372.76851503144
X-Max	1270078.1610237402
Y-Min	1550391.9656167035
Y-Max	2190094.254910357
Z-Min	0.00010000000474974513
Z-Max	0.00010000000474974513
Service Territory	main.ServiceTerritory

Key	Value
HasClusterKey	False

Domain Network Name	Domain Network Alias	Domain Network ID	Tier Definition	Subnetwork Controller Type	Creation Time
Structure	Structure	1	None		2025-06-09 11:50:30
Sewer	Sewer	2	Hierarchical	Sink	2025-06-09 11:50:47

Domain Network Name	Tier Group Name	Creation Time
Sewer	Sewer Cathodic Protection Coverage	2025-06-09 11:50:52
Sewer	Sewer Collection	2025-06-09 11:50:52

Domain Network Name	Tier Group Name	Tier Name	Tier ID	Tier Rank	Tier Topology	Supports Disjoint	Subnetwork Field Name	Edit Mode in Default	Edit Mode in Version	Update Structures	Update Containers	Validate Locatability	Manage isDirty	Creation Time
Sewer	Sewer Cathodic Protection Coverage	Sewer Cathodic Protection	1	1	Mesh	True	cpsubnetworkname	Without Eventing	Without Eventing	True	True	False	False	2025-06-09 11:50:52
Sewer	Sewer Collection	Sewer Collection System	2	1	Mesh	True	systemsubnetworkname	Without Eventing	Without Eventing	True	True	False	False	2025-06-09 11:50:52
Sewer	Sewer Collection	Sewershed	3	2	Mesh	True	sewershedsubnetworkname	Without Eventing	Without Eventing	True	True	False	False	2025-06-09 11:50:52

Tier Name	Source Name	Asset Group	Asset Type	Controller / Aggregated
Sewer Cathodic Protection	Device	Pump	Unknown	False
Sewer Cathodic Protection	Device	Pump	Pump	False
Sewer Cathodic Protection	Device	Pump	Pump with Grinder	False
Sewer Cathodic Protection	Device	Monitoring	Unknown	False
Sewer Cathodic Protection	Device	Monitoring	Pressure Sensor	False
Sewer Cathodic Protection	Device	Monitoring	Temperature Sensor	False
Sewer Cathodic Protection	Device	Flow Valve	Unknown	False
Sewer Cathodic Protection	Device	Flow Valve	Air Gap	False
Sewer Cathodic Protection	Device	Flow Valve	Altitude	False
Sewer Cathodic Protection	Device	Flow Valve	Check	False
Sewer Cathodic Protection	Device	Weir	Unknown	False
Sewer Cathodic Protection	Device	Weir	Broad-Crested	False
Sewer Cathodic Protection	Device	Weir	Combination	False
Sewer Cathodic Protection	Device	Weir	Labyrinth	False
Sewer Cathodic Protection	Device	Weir	Minimum Energy Loss	False
Sewer Cathodic Protection	Device	Weir	Sharp-Crested	False
Sewer Cathodic Protection	Device	Weir	V-Notch	False
Sewer Cathodic Protection	Device	Meter	Unknown	False
Sewer Cathodic Protection	Device	Meter	Bulk	False
Sewer Cathodic Protection	Device	Meter	Station	False
Sewer Cathodic Protection	Device	Controllable Valve	Unknown	False
Sewer Cathodic Protection	Device	Controllable Valve	System	False
Sewer Cathodic Protection	Device	Controllable Valve	Vault	False
Sewer Cathodic Protection	Device	Relief Valve	Unknown	False
Sewer Cathodic Protection	Device	Relief Valve	Air & Vacuum	False
Sewer Cathodic Protection	Device	Relief Valve	Air Release	False
Sewer Cathodic Protection	Device	Relief Valve	Combination Air	False
Sewer Cathodic Protection	Device	Treatment	Unknown	False
Sewer Cathodic Protection	Device	Treatment	Treatment Plant	False
Sewer Cathodic Protection	Device	Gate	Unknown	False
Sewer Cathodic Protection	Device	Gate	Gate	False
Sewer Cathodic Protection	Device	Gate	Stop Log	False
Sewer Cathodic Protection	Device	Service Connection	Unknown	False
Sewer Cathodic Protection	Device	Service Connection	Commercial	False
Sewer Cathodic Protection	Device	Service Connection	Industrial	False
Sewer Cathodic Protection	Device	Service Connection	Residential	False
Sewer Cathodic Protection	Device	Cleanout	Unknown	False
Sewer Cathodic Protection	Device	Cleanout	Cleanout	False
Sewer Cathodic Protection	Device	Cleanout	Lamp Hole	False
Sewer Cathodic Protection	Device	Cleanout	Terminal	False
Sewer Cathodic Protection	Device	Anode	Unknown	False
Sewer Cathodic Protection	Device	Anode	ICCP	False
Sewer Cathodic Protection	Device	Anode	Galvanic	False
Sewer Cathodic Protection	Device	Rectifier	Unknown	False
Sewer Cathodic Protection	Device	Rectifier	Rectifier	False
Sewer Cathodic Protection	Device	Test Point	Unknown	False
Sewer Cathodic Protection	Device	Test Point	Test Point	True
Sewer Cathodic Protection	Device	Grease Trap	Unknown	False
Sewer Cathodic Protection	Device	Grease Trap	Grease Trap	False
Sewer Cathodic Protection	Device	Grease Trap	Grease Interceptor	False
Sewer Cathodic Protection	Device	Grease Trap	Grease Recovery	False
Sewer Cathodic Protection	Device	Backflow Preventer	Unknown	False
Sewer Cathodic Protection	Device	Backflow Preventer	Backflow Preventer	False
Sewer Cathodic Protection	Device	Connection	Unknown	False
Sewer Cathodic Protection	Device	Connection	Pipe Connection	False
Sewer Cathodic Protection	Device	Outlet	Unknown	False
Sewer Cathodic Protection	Device	Outlet	Overflow	False
Sewer Cathodic Protection	Device	Groundbed	Unknown	False
Sewer Cathodic Protection	Device	Groundbed	Anode Bed	True
Sewer Cathodic Protection	Device	Manhole Channel	Unknown	False
Sewer Cathodic Protection	Device	Manhole Channel	Manhole Channel	False
Sewer Cathodic Protection	Device	Manhole Channel	Directional Manhole Channel	False
Sewer Cathodic Protection	Line	Bonding Line	Unknown	False
Sewer Cathodic Protection	Line	Bonding Line	Wire	False
Sewer Cathodic Protection	Line	Bonding Line	Strap	False
Sewer Cathodic Protection	Line	Sewer Force Main	Unknown	False
Sewer Cathodic Protection	Line	Sewer Force Main	Force Main	True
Sewer Cathodic Protection	Line	Test Lead Wire	Unknown	False
Sewer Cathodic Protection	Line	Test Lead Wire	Aqua	False
Sewer Cathodic Protection	Line	Test Lead Wire	Blue	False
Sewer Cathodic Protection	Line	Test Lead Wire	Forest	False
Sewer Cathodic Protection	Line	Test Lead Wire	Green	False
Sewer Cathodic Protection	Line	Test Lead Wire	Lavender	False
Sewer Cathodic Protection	Line	Test Lead Wire	Orange	False
Sewer Cathodic Protection	Line	Test Lead Wire	Pink	False
Sewer Cathodic Protection	Line	Test Lead Wire	Red	False
Sewer Cathodic Protection	Line	Test Lead Wire	Yellow	False
Sewer Cathodic Protection	Line	Test Lead Wire	Purple	False
Sewer Cathodic Protection	Line	Lateral	Unknown	False
Sewer Cathodic Protection	Line	Lateral	Commercial	False
Sewer Cathodic Protection	Line	Lateral	Industrial	False
Sewer Cathodic Protection	Line	Lateral	Residential	False
Sewer Cathodic Protection	Line	Rectifier Cable	Unknown	False
Sewer Cathodic Protection	Line	Rectifier Cable	Rectifier Cable	False
Sewer Cathodic Protection	Line	Sewer Gravity Main	Unknown	False
Sewer Cathodic Protection	Line	Sewer Gravity Main	Collector Gravity Main	True
Sewer Cathodic Protection	Line	Sewer Gravity Main	Interceptor Gravity Main	True
Sewer Cathodic Protection	Junction	Fitting	Unknown
Sewer Cathodic Protection	Junction	Fitting	Coupling
Sewer Cathodic Protection	Junction	Fitting	Cross
Sewer Cathodic Protection	Junction	Fitting	Elbow
Sewer Cathodic Protection	Junction	Fitting	End Cap
Sewer Cathodic Protection	Junction	Fitting	Expansion Joint
Sewer Cathodic Protection	Junction	Fitting	Flange
Sewer Cathodic Protection	Junction	Fitting	Plug
Sewer Cathodic Protection	Junction	Fitting	Reducer
Sewer Cathodic Protection	Junction	Fitting	Reducing Cross
Sewer Cathodic Protection	Junction	Fitting	Reducing Tee
Sewer Cathodic Protection	Junction	Fitting	Saddle
Sewer Cathodic Protection	Junction	Fitting	Screw
Sewer Cathodic Protection	Junction	Fitting	Sleeve
Sewer Cathodic Protection	Junction	Fitting	Tap
Sewer Cathodic Protection	Junction	Fitting	Tapping Saddle
Sewer Cathodic Protection	Junction	Fitting	Tee
Sewer Cathodic Protection	Junction	Fitting	Transition
Sewer Cathodic Protection	Junction	Fitting	Weld
Sewer Cathodic Protection	Junction	Fitting	Wye
Sewer Cathodic Protection	Junction	Wire Junction	Unknown
Sewer Cathodic Protection	Junction	Wire Junction	Bond Junction
Sewer Cathodic Protection	Junction	Wire Junction	Test Lead
Sewer Cathodic Protection	Junction	Insulation Junction	Unknown
Sewer Cathodic Protection	Junction	Insulation Junction	Flange Insert
Sewer Collection System	Device	Pump	Unknown	False
Sewer Collection System	Device	Pump	Pump	False
Sewer Collection System	Device	Pump	Pump with Grinder	False
Sewer Collection System	Device	Monitoring	Unknown	False
Sewer Collection System	Device	Monitoring	Pressure Sensor	False
Sewer Collection System	Device	Monitoring	Temperature Sensor	False
Sewer Collection System	Device	Flow Valve	Unknown	False
Sewer Collection System	Device	Flow Valve	Air Gap	False
Sewer Collection System	Device	Flow Valve	Altitude	False
Sewer Collection System	Device	Flow Valve	Check	False
Sewer Collection System	Device	Weir	Unknown	False
Sewer Collection System	Device	Weir	Broad-Crested	False
Sewer Collection System	Device	Weir	Combination	False
Sewer Collection System	Device	Weir	Labyrinth	False
Sewer Collection System	Device	Weir	Minimum Energy Loss	False
Sewer Collection System	Device	Weir	Sharp-Crested	False
Sewer Collection System	Device	Weir	V-Notch	False
Sewer Collection System	Device	Meter	Unknown	False
Sewer Collection System	Device	Meter	Bulk	False
Sewer Collection System	Device	Meter	Station	False
Sewer Collection System	Device	Controllable Valve	Unknown	False
Sewer Collection System	Device	Controllable Valve	System	False
Sewer Collection System	Device	Controllable Valve	Vault	False
Sewer Collection System	Device	Relief Valve	Unknown	False
Sewer Collection System	Device	Relief Valve	Air & Vacuum	False
Sewer Collection System	Device	Relief Valve	Air Release	False
Sewer Collection System	Device	Relief Valve	Combination Air	False
Sewer Collection System	Device	Treatment	Unknown	False
Sewer Collection System	Device	Treatment	Treatment Plant	True
Sewer Collection System	Device	Gate	Unknown	False
Sewer Collection System	Device	Gate	Gate	False
Sewer Collection System	Device	Gate	Stop Log	False
Sewer Collection System	Device	Service Connection	Unknown	False
Sewer Collection System	Device	Service Connection	Commercial	False
Sewer Collection System	Device	Service Connection	Industrial	False
Sewer Collection System	Device	Service Connection	Residential	False
Sewer Collection System	Device	Cleanout	Unknown	False
Sewer Collection System	Device	Cleanout	Cleanout	False
Sewer Collection System	Device	Cleanout	Lamp Hole	False
Sewer Collection System	Device	Cleanout	Terminal	False
Sewer Collection System	Device	Anode	Unknown	False
Sewer Collection System	Device	Anode	ICCP	False
Sewer Collection System	Device	Anode	Galvanic	False
Sewer Collection System	Device	Rectifier	Unknown	False
Sewer Collection System	Device	Rectifier	Rectifier	False
Sewer Collection System	Device	Test Point	Unknown	False
Sewer Collection System	Device	Test Point	Test Point	False
Sewer Collection System	Device	Grease Trap	Grease Trap	False
Sewer Collection System	Device	Grease Trap	Grease Interceptor	False
Sewer Collection System	Device	Grease Trap	Grease Recovery	False
Sewer Collection System	Device	Backflow Preventer	Unknown	False
Sewer Collection System	Device	Backflow Preventer	Backflow Preventer	False
Sewer Collection System	Device	Connection	Unknown	False
Sewer Collection System	Device	Connection	Pipe Connection	False
Sewer Collection System	Device	Outlet	Overflow	True
Sewer Collection System	Device	Groundbed	Unknown	False
Sewer Collection System	Device	Groundbed	Anode Bed	False
Sewer Collection System	Device	Manhole Channel	Unknown	False
Sewer Collection System	Device	Manhole Channel	Manhole Channel	False
Sewer Collection System	Device	Manhole Channel	Directional Manhole Channel	False
Sewer Collection System	Line	Bonding Line	Unknown	False
Sewer Collection System	Line	Bonding Line	Wire	False
Sewer Collection System	Line	Bonding Line	Strap	False
Sewer Collection System	Line	Sewer Force Main	Unknown	False
Sewer Collection System	Line	Sewer Force Main	Force Main	True
Sewer Collection System	Line	Test Lead Wire	Unknown	False
Sewer Collection System	Line	Test Lead Wire	Aqua	False
Sewer Collection System	Line	Test Lead Wire	Blue	False
Sewer Collection System	Line	Test Lead Wire	Forest	False
Sewer Collection System	Line	Test Lead Wire	Green	False
Sewer Collection System	Line	Test Lead Wire	Lavender	False
Sewer Collection System	Line	Test Lead Wire	Orange	False
Sewer Collection System	Line	Test Lead Wire	Pink	False
Sewer Collection System	Line	Test Lead Wire	Red	False
Sewer Collection System	Line	Test Lead Wire	Yellow	False
Sewer Collection System	Line	Test Lead Wire	Purple	False
Sewer Collection System	Line	Lateral	Unknown	False
Sewer Collection System	Line	Lateral	Commercial	False
Sewer Collection System	Line	Lateral	Industrial	False
Sewer Collection System	Line	Lateral	Residential	False
Sewer Collection System	Line	Rectifier Cable	Unknown	False
Sewer Collection System	Line	Rectifier Cable	Rectifier Cable	False
Sewer Collection System	Line	Sewer Gravity Main	Unknown	False
Sewer Collection System	Line	Sewer Gravity Main	Collector Gravity Main	True
Sewer Collection System	Line	Sewer Gravity Main	Interceptor Gravity Main	True
Sewer Collection System	Junction	Fitting	Unknown
Sewer Collection System	Junction	Fitting	Coupling
Sewer Collection System	Junction	Fitting	Cross
Sewer Collection System	Junction	Fitting	Elbow
Sewer Collection System	Junction	Fitting	End Cap
Sewer Collection System	Junction	Fitting	Expansion Joint
Sewer Collection System	Junction	Fitting	Flange
Sewer Collection System	Junction	Fitting	Plug
Sewer Collection System	Junction	Fitting	Reducer
Sewer Collection System	Junction	Fitting	Reducing Cross
Sewer Collection System	Junction	Fitting	Reducing Tee
Sewer Collection System	Junction	Fitting	Saddle
Sewer Collection System	Junction	Fitting	Screw
Sewer Collection System	Junction	Fitting	Sleeve
Sewer Collection System	Junction	Fitting	Tap
Sewer Collection System	Junction	Fitting	Tapping Saddle
Sewer Collection System	Junction	Fitting	Tee
Sewer Collection System	Junction	Fitting	Transition
Sewer Collection System	Junction	Fitting	Weld
Sewer Collection System	Junction	Fitting	Wye
Sewer Collection System	Junction	Wire Junction	Unknown
Sewer Collection System	Junction	Wire Junction	Bond Junction
Sewer Collection System	Junction	Wire Junction	Test Lead
Sewer Collection System	Junction	Insulation Junction	Unknown
Sewer Collection System	Junction	Insulation Junction	Flange Insert
Sewershed	Device	Pump	Unknown	False
Sewershed	Device	Pump	Pump	False
Sewershed	Device	Pump	Pump with Grinder	False
Sewershed	Device	Monitoring	Unknown	False
Sewershed	Device	Monitoring	Pressure Sensor	False
Sewershed	Device	Monitoring	Temperature Sensor	False
Sewershed	Device	Flow Valve	Unknown	False
Sewershed	Device	Flow Valve	Air Gap	False
Sewershed	Device	Flow Valve	Altitude	False
Sewershed	Device	Flow Valve	Check	False
Sewershed	Device	Weir	Unknown	False
Sewershed	Device	Weir	Broad-Crested	False
Sewershed	Device	Weir	Combination	False
Sewershed	Device	Weir	Labyrinth	False
Sewershed	Device	Weir	Minimum Energy Loss	False
Sewershed	Device	Weir	Sharp-Crested	False
Sewershed	Device	Weir	V-Notch	False
Sewershed	Device	Meter	Unknown	False
Sewershed	Device	Meter	Bulk	False
Sewershed	Device	Meter	Station	False
Sewershed	Device	Controllable Valve	Unknown	False
Sewershed	Device	Controllable Valve	System	False
Sewershed	Device	Controllable Valve	Vault	False
Sewershed	Device	Relief Valve	Unknown	False
Sewershed	Device	Relief Valve	Air & Vacuum	False
Sewershed	Device	Relief Valve	Air Release	False
Sewershed	Device	Relief Valve	Combination Air	False
Sewershed	Device	Treatment	Unknown	False
Sewershed	Device	Treatment	Treatment Plant	False
Sewershed	Device	Gate	Unknown	False
Sewershed	Device	Gate	Gate	False
Sewershed	Device	Gate	Stop Log	False
Sewershed	Device	Service Connection	Unknown	False
Sewershed	Device	Service Connection	Commercial	False
Sewershed	Device	Service Connection	Industrial	False
Sewershed	Device	Service Connection	Residential	False
Sewershed	Device	Cleanout	Unknown	False
Sewershed	Device	Cleanout	Cleanout	False
Sewershed	Device	Cleanout	Lamp Hole	False
Sewershed	Device	Cleanout	Terminal	False
Sewershed	Device	Anode	Unknown	False
Sewershed	Device	Anode	ICCP	False
Sewershed	Device	Anode	Galvanic	False
Sewershed	Device	Rectifier	Unknown	False
Sewershed	Device	Rectifier	Rectifier	False
Sewershed	Device	Test Point	Unknown	False
Sewershed	Device	Test Point	Test Point	False
Sewershed	Device	Grease Trap	Grease Trap	False
Sewershed	Device	Grease Trap	Grease Interceptor	False
Sewershed	Device	Grease Trap	Grease Recovery	False
Sewershed	Device	Backflow Preventer	Unknown	False
Sewershed	Device	Backflow Preventer	Backflow Preventer	False
Sewershed	Device	Connection	Unknown	False
Sewershed	Device	Connection	Pipe Connection	False
Sewershed	Device	Outlet	Overflow	False
Sewershed	Device	Groundbed	Unknown	False
Sewershed	Device	Groundbed	Anode Bed	False
Sewershed	Device	Manhole Channel	Unknown	False
Sewershed	Device	Manhole Channel	Manhole Channel	False
Sewershed	Device	Manhole Channel	Directional Manhole Channel	True
Sewershed	Line	Bonding Line	Unknown	False
Sewershed	Line	Bonding Line	Wire	False
Sewershed	Line	Bonding Line	Strap	False
Sewershed	Line	Sewer Force Main	Unknown	False
Sewershed	Line	Sewer Force Main	Force Main	True
Sewershed	Line	Test Lead Wire	Unknown	False
Sewershed	Line	Test Lead Wire	Aqua	False
Sewershed	Line	Test Lead Wire	Blue	False
Sewershed	Line	Test Lead Wire	Forest	False
Sewershed	Line	Test Lead Wire	Green	False
Sewershed	Line	Test Lead Wire	Lavender	False
Sewershed	Line	Test Lead Wire	Orange	False
Sewershed	Line	Test Lead Wire	Pink	False
Sewershed	Line	Test Lead Wire	Red	False
Sewershed	Line	Test Lead Wire	Yellow	False
Sewershed	Line	Test Lead Wire	Purple	False
Sewershed	Line	Lateral	Unknown	False
Sewershed	Line	Lateral	Commercial	False
Sewershed	Line	Lateral	Industrial	False
Sewershed	Line	Lateral	Residential	False
Sewershed	Line	Rectifier Cable	Unknown	False
Sewershed	Line	Rectifier Cable	Rectifier Cable	False
Sewershed	Line	Sewer Gravity Main	Unknown	False
Sewershed	Line	Sewer Gravity Main	Collector Gravity Main	True
Sewershed	Line	Sewer Gravity Main	Interceptor Gravity Main	True
Sewershed	Junction	Fitting	Unknown
Sewershed	Junction	Fitting	Coupling
Sewershed	Junction	Fitting	Cross
Sewershed	Junction	Fitting	Elbow
Sewershed	Junction	Fitting	End Cap
Sewershed	Junction	Fitting	Expansion Joint
Sewershed	Junction	Fitting	Flange
Sewershed	Junction	Fitting	Plug
Sewershed	Junction	Fitting	Reducer
Sewershed	Junction	Fitting	Reducing Cross
Sewershed	Junction	Fitting	Reducing Tee
Sewershed	Junction	Fitting	Saddle
Sewershed	Junction	Fitting	Screw
Sewershed	Junction	Fitting	Sleeve
Sewershed	Junction	Fitting	Tap
Sewershed	Junction	Fitting	Tapping Saddle
Sewershed	Junction	Fitting	Tee
Sewershed	Junction	Fitting	Transition
Sewershed	Junction	Fitting	Weld
Sewershed	Junction	Fitting	Wye
Sewershed	Junction	Wire Junction	Unknown
Sewershed	Junction	Wire Junction	Bond Junction
Sewershed	Junction	Wire Junction	Test Lead
Sewershed	Junction	Insulation Junction	Unknown
Sewershed	Junction	Insulation Junction	Flange Insert

Tier Name	Include Containers	Include Content	Include Structures	Include Barriers	Validate Locatability	Traversability Scope
Sewer Cathodic Protection	True	True	True	False	False	junctionsAndEdges
Sewer Collection System	True	True	True	False	False	junctionsAndEdges
Sewershed	True	True	True	False	False	junctionsAndEdges

Tier Name	Network Attribute / Category	Operator	Value	Combine Using Or
Sewer Cathodic Protection	Cathodic Protection Traceability	Equal	2	False
Sewer Collection System	S:Activate Value	Greater Than	0	True
Sewer Collection System	P:Device Status	Equal	0	True
Sewer Collection System	Lifecycle Status	Does Not Include Any	6	True
Sewer Collection System	Category	Equal	CP Only	True
Sewershed	S:Activate Value	Greater Than	0	True
Sewershed	P:Device Status	Equal	0	True
Sewershed	Lifecycle Status	Does Not Include Any	6	True
Sewershed	Category	Equal	CP Only	True

Domain Network Name	Source Name	Table	Usage Type	Source ID	# of Asset Groups	# of Asset Types
Structure	StructureJunction	main.StructureJunction	Structure Junction	4	3	9
Structure	StructureBoundary	main.StructureBoundary	Structure Boundary	6	4	10
Structure	StructureJunctionObject	main.StructureJunctionObject	Structure Junction Object	7	1	1
Structure	StructureLine	main.StructureLine	Structure Line	5	2	3
Structure	StructureEdgeObject	main.StructureEdgeObject	Structure Edge Object	8	1	1
Sewer	SewerDevice	main.SewerDevice	Device	9	21	64
Sewer	SewerAssembly	main.SewerAssembly	Assembly	11	1	1
Sewer	SewerJunction	main.SewerJunction	Junction	12	4	26
Sewer	SewerJunctionObject	main.SewerJunctionObject	Junction Object	14	1	1
Sewer	SewerLine	main.SewerLine	Line	10	7	26
Sewer	SewerSubnetLine	main.SewerSubnetLine	Subnet Line	13	4	0
Sewer	SewerEdgeObject	main.SewerEdgeObject	Edge Object	15	1	1

Source Name	Asset Group Name	Asset Group Code	# of Asset Types	Creation Time
StructureJunction	Unknown	0	1	2025-06-09 11:50:32
StructureJunction	Sewer Storm Vault	208	6	2025-06-09 11:51:19
StructureJunction	Sewer Lift Station	301	2	2025-06-09 11:51:19
StructureBoundary	Unknown	0	1	2025-06-09 11:50:32
StructureBoundary	Sewer Treatment Plant Boundary	307	2	2025-06-09 11:51:24
StructureBoundary	Sewer Storm Vault Boundary	208	5	2025-06-09 11:51:24
StructureBoundary	Sewer Lift Station Boundary	301	2	2025-06-09 11:51:24
StructureJunctionObject	Unknown	0	1	2025-06-09 11:50:32
StructureLine	Unknown	0	1	2025-06-09 11:50:32
StructureLine	Sewer Storm Casing	201	2	2025-06-09 11:51:28
StructureEdgeObject	Unknown	0	1	2025-06-09 11:50:32
SewerDevice	Unknown	0	1	2025-06-09 11:50:49
SewerDevice	Pump	5	3	2025-06-09 11:51:37
SewerDevice	Flow Valve	1	4	2025-06-09 11:51:37
SewerDevice	Controllable Valve	2	3	2025-06-09 11:51:37
SewerDevice	Relief Valve	3	4	2025-06-09 11:51:37
SewerDevice	Meter	10	3	2025-06-09 11:51:37
SewerDevice	Treatment	15	2	2025-06-09 11:51:37
SewerDevice	Weir	26	7	2025-06-09 11:51:37
SewerDevice	Monitoring	25	3	2025-06-09 11:51:37
SewerDevice	Gate	27	3	2025-06-09 11:51:37
SewerDevice	Service Connection	7	4	2025-06-09 11:51:37
SewerDevice	Cleanout	21	4	2025-06-09 11:51:37
SewerDevice	Anode	50	3	2025-06-09 11:51:37
SewerDevice	Rectifier	51	2	2025-06-09 11:51:37
SewerDevice	Test Point	52	2	2025-06-09 11:51:37
SewerDevice	Grease Trap	30	4	2025-06-09 11:51:37
SewerDevice	Backflow Preventer	31	2	2025-06-09 11:51:37
SewerDevice	Connection	23	2	2025-06-09 11:51:37
SewerDevice	Outlet	22	3	2025-06-09 11:51:37
SewerDevice	Groundbed	53	2	2025-06-09 11:51:37
SewerDevice	Manhole Channel	32	3	2025-06-09 11:51:37
SewerAssembly	Unknown	0	1	2025-06-09 11:50:49
SewerJunction	Unknown	0	1	2025-06-09 11:50:49
SewerJunction	Fitting	20	20	2025-06-09 11:51:54
SewerJunction	Wire Junction	50	3	2025-06-09 11:51:54
SewerJunction	Insulation Junction	51	2	2025-06-09 11:51:54
SewerJunctionObject	Unknown	0	1	2025-06-09 11:50:49
SewerLine	Unknown	0	1	2025-06-09 11:50:49
SewerLine	Bonding Line	50	3	2025-06-09 11:52:00
SewerLine	Test Lead Wire	51	11	2025-06-09 11:52:00
SewerLine	Rectifier Cable	52	2	2025-06-09 11:52:00
SewerLine	Sewer Gravity Main	1	3	2025-06-09 11:52:00
SewerLine	Sewer Force Main	2	2	2025-06-09 11:52:00
SewerLine	Lateral	3	4	2025-06-09 11:52:00
SewerSubnetLine	Unknown	0	0	2025-06-09 11:50:49
SewerSubnetLine	Sewer Cathodic Protection	1	0	2025-06-09 11:51:19
SewerSubnetLine	Sewer Collection System	2	0	2025-06-09 11:51:19
SewerSubnetLine	Sewershed	3	0	2025-06-09 11:51:19
SewerEdgeObject	Unknown	0	1	2025-06-09 11:50:49

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								2025-06-09 11:50:32
StructureJunction	Sewer Storm Vault	Unknown	208	0								2025-06-09 11:51:19
StructureJunction	Sewer Storm Vault	Baffle Chamber	208	1		Container	Restricted	15				2025-06-09 11:51:19
StructureJunction	Sewer Storm Vault	Regulator Chamber	208	4		Container	Restricted	15				2025-06-09 11:51:19
StructureJunction	Sewer Storm Vault	Tide Gate Chamber	208	5		Container	Restricted	15				2025-06-09 11:51:19
StructureJunction	Sewer Storm Vault	Manhole	208	9		Container	Restricted	10				2025-06-09 11:51:19
StructureJunction	Sewer Storm Vault	Wet Well	208	16		Container	Restricted	10				2025-06-09 11:51:19
StructureJunction	Sewer Lift Station	Unknown	301	0		Container	Restricted	50				2025-06-09 11:51:20
StructureJunction	Sewer Lift Station	Lift Station	301	81		Container	Restricted	50				2025-06-09 11:51:20
StructureBoundary	Unknown	Unknown	0	0								2025-06-09 11:50:32
StructureBoundary	Sewer Treatment Plant Boundary	Unknown	307	0								2025-06-09 11:51:24
StructureBoundary	Sewer Treatment Plant Boundary	Treatment Plant	307	81		Container	Restricted	500				2025-06-09 11:51:24
StructureBoundary	Sewer Storm Vault Boundary	Unknown	208	0								2025-06-09 11:51:24
StructureBoundary	Sewer Storm Vault Boundary	Baffle Chamber	208	1		Container	Restricted	15				2025-06-09 11:51:24
StructureBoundary	Sewer Storm Vault Boundary	Regulator Chamber	208	4		Container	Restricted	15				2025-06-09 11:51:24
StructureBoundary	Sewer Storm Vault Boundary	Tide Gate Chamber	208	5		Container	Restricted	15				2025-06-09 11:51:24
StructureBoundary	Sewer Storm Vault Boundary	Wet Well	208	16		Container	Restricted	15				2025-06-09 11:51:24
StructureBoundary	Sewer Lift Station Boundary	Unknown	301	0								2025-06-09 11:51:24
StructureBoundary	Sewer Lift Station Boundary	Lift Station	301	41		Container	Restricted	50				2025-06-09 11:51:24
StructureJunctionObject	Unknown	Unknown	0	0								2025-06-09 11:50:32
StructureLine	Unknown	Unknown	0	0								2025-06-09 11:50:32
StructureLine	Sewer Storm Casing	Unknown	201	0								2025-06-09 11:51:28
StructureLine	Sewer Storm Casing	Casing	201	1		Container	Restricted	200	True			2025-06-09 11:51:28
StructureEdgeObject	Unknown	Unknown	0	0								2025-06-09 11:50:32
SewerDevice	Unknown	Unknown	0	0								2025-06-09 11:50:49
SewerDevice	Pump	Unknown	5	0								2025-06-09 11:51:37
SewerDevice	Pump	Pump	5	61	Pressure Increasing							2025-06-09 11:51:37
SewerDevice	Pump	Pump with Grinder	5	62	Pressure Increasing							2025-06-09 11:51:37
SewerDevice	Flow Valve	Unknown	1	0								2025-06-09 11:51:37
SewerDevice	Flow Valve	Air Gap	1	41								2025-06-09 11:51:37
SewerDevice	Flow Valve	Altitude	1	42								2025-06-09 11:51:37
SewerDevice	Flow Valve	Check	1	43								2025-06-09 11:51:37
SewerDevice	Controllable Valve	Unknown	2	0								2025-06-09 11:51:37
SewerDevice	Controllable Valve	System	2	141								2025-06-09 11:51:37
SewerDevice	Controllable Valve	Vault	2	142								2025-06-09 11:51:37
SewerDevice	Relief Valve	Unknown	3	0								2025-06-09 11:51:37
SewerDevice	Relief Valve	Air & Vacuum	3	121								2025-06-09 11:51:37
SewerDevice	Relief Valve	Air Release	3	122								2025-06-09 11:51:37
SewerDevice	Relief Valve	Combination Air	3	123								2025-06-09 11:51:37
SewerDevice	Meter	Unknown	10	0								2025-06-09 11:51:37
SewerDevice	Meter	Bulk	10	161								2025-06-09 11:51:37
SewerDevice	Meter	Station	10	162								2025-06-09 11:51:37
SewerDevice	Treatment	Unknown	15	0								2025-06-09 11:51:37
SewerDevice	Treatment	Treatment Plant	15	201	Pipe Directional Dual Terminal						Subnetwork Controller	2025-06-09 11:51:37
SewerDevice	Weir	Unknown	26	0								2025-06-09 11:51:38
SewerDevice	Weir	Broad-Crested	26	281								2025-06-09 11:51:38
SewerDevice	Weir	Combination	26	282								2025-06-09 11:51:38
SewerDevice	Weir	Labyrinth	26	283								2025-06-09 11:51:38
SewerDevice	Weir	Minimum Energy Loss	26	284								2025-06-09 11:51:38
SewerDevice	Weir	Sharp-Crested	26	285								2025-06-09 11:51:38
SewerDevice	Weir	V-Notch	26	286								2025-06-09 11:51:38
SewerDevice	Monitoring	Unknown	25	0								2025-06-09 11:51:38
SewerDevice	Monitoring	Pressure Sensor	25	181								2025-06-09 11:51:38
SewerDevice	Monitoring	Temperature Sensor	25	182								2025-06-09 11:51:38
SewerDevice	Gate	Unknown	27	0								2025-06-09 11:51:38
SewerDevice	Gate	Gate	27	101								2025-06-09 11:51:38
SewerDevice	Gate	Stop Log	27	102								2025-06-09 11:51:38
SewerDevice	Service Connection	Unknown	7	0								2025-06-09 11:51:38
SewerDevice	Service Connection	Commercial	7	1								2025-06-09 11:51:38
SewerDevice	Service Connection	Industrial	7	2								2025-06-09 11:51:38
SewerDevice	Service Connection	Residential	7	3								2025-06-09 11:51:38
SewerDevice	Cleanout	Unknown	21	0								2025-06-09 11:51:38
SewerDevice	Cleanout	Cleanout	21	81								2025-06-09 11:51:38
SewerDevice	Cleanout	Lamp Hole	21	82								2025-06-09 11:51:38
SewerDevice	Cleanout	Terminal	21	83								2025-06-09 11:51:38
SewerDevice	Anode	Unknown	50	0								2025-06-09 11:51:38
SewerDevice	Anode	ICCP	50	901							CP Only	2025-06-09 11:51:38
SewerDevice	Anode	Galvanic	50	902							CP Only	2025-06-09 11:51:38
SewerDevice	Rectifier	Unknown	51	0								2025-06-09 11:51:38
SewerDevice	Rectifier	Rectifier	51	941							CP Only	2025-06-09 11:51:38
SewerDevice	Test Point	Unknown	52	0								2025-06-09 11:51:38
SewerDevice	Test Point	Test Point	52	981	Sewer Terminal Block						CP Only;Subnetwork Controller	2025-06-09 11:51:38
SewerDevice	Grease Trap	Unknown	30	0								2025-06-09 11:51:38
SewerDevice	Grease Trap	Grease Trap	30	301								2025-06-09 11:51:38
SewerDevice	Grease Trap	Grease Interceptor	30	302								2025-06-09 11:51:38
SewerDevice	Grease Trap	Grease Recovery	30	303								2025-06-09 11:51:38
SewerDevice	Backflow Preventer	Unknown	31	0								2025-06-09 11:51:38
SewerDevice	Backflow Preventer	Backflow Preventer	31	321								2025-06-09 11:51:38
SewerDevice	Connection	Unknown	23	0								2025-06-09 11:51:38
SewerDevice	Connection	Pipe Connection	23	241								2025-06-09 11:51:38
SewerDevice	Outlet	Unknown	22	0								2025-06-09 11:51:38
SewerDevice	Outlet	Effluent Discharge	22	221								2025-06-09 11:51:38
SewerDevice	Outlet	Overflow	22	222	Pipe Directional Dual Terminal						Subnetwork Controller	2025-06-09 11:51:38
SewerDevice	Groundbed	Unknown	53	0		Container	Restricted	10				2025-06-09 11:51:39
SewerDevice	Groundbed	Anode Bed	53	911	Pipe Bidirectional Dual Terminal	Container	Restricted	10			CP Only;Subnetwork Controller	2025-06-09 11:51:39
SewerDevice	Manhole Channel	Unknown	32	0								2025-06-09 11:51:39
SewerDevice	Manhole Channel	Manhole Channel	32	301								2025-06-09 11:51:39
SewerDevice	Manhole Channel	Directional Manhole Channel	32	302	Directional Manhole Terminal						Subnetwork Controller	2025-06-09 11:51:39
SewerAssembly	Unknown	Unknown	0	0								2025-06-09 11:50:49
SewerJunction	Unknown	Unknown	0	0								2025-06-09 11:50:49
SewerJunction	Fitting	Unknown	20	0								2025-06-09 11:51:54
SewerJunction	Fitting	Coupling	20	41								2025-06-09 11:51:54
SewerJunction	Fitting	Cross	20	42								2025-06-09 11:51:54
SewerJunction	Fitting	Elbow	20	43								2025-06-09 11:51:54
SewerJunction	Fitting	End Cap	20	44								2025-06-09 11:51:54
SewerJunction	Fitting	Expansion Joint	20	45								2025-06-09 11:51:54
SewerJunction	Fitting	Flange	20	46								2025-06-09 11:51:54
SewerJunction	Fitting	Plug	20	47								2025-06-09 11:51:54
SewerJunction	Fitting	Reducer	20	48								2025-06-09 11:51:54
SewerJunction	Fitting	Reducing Cross	20	49								2025-06-09 11:51:54
SewerJunction	Fitting	Reducing Tee	20	50								2025-06-09 11:51:54
SewerJunction	Fitting	Saddle	20	51								2025-06-09 11:51:54
SewerJunction	Fitting	Screw	20	52								2025-06-09 11:51:54
SewerJunction	Fitting	Sleeve	20	53								2025-06-09 11:51:54
SewerJunction	Fitting	Tap	20	54								2025-06-09 11:51:54
SewerJunction	Fitting	Tapping Saddle	20	55								2025-06-09 11:51:54
SewerJunction	Fitting	Tee	20	56								2025-06-09 11:51:54
SewerJunction	Fitting	Transition	20	57								2025-06-09 11:51:54
SewerJunction	Fitting	Weld	20	58								2025-06-09 11:51:54
SewerJunction	Fitting	Wye	20	59								2025-06-09 11:51:54
SewerJunction	Wire Junction	Unknown	50	0								2025-06-09 11:51:54
SewerJunction	Wire Junction	Bond Junction	50	901								2025-06-09 11:51:54
SewerJunction	Wire Junction	Test Lead	50	902								2025-06-09 11:51:54
SewerJunction	Insulation Junction	Unknown	51	0								2025-06-09 11:51:54
SewerJunction	Insulation Junction	Flange Insert	51	941								2025-06-09 11:51:54
SewerJunctionObject	Unknown	Unknown	0	0								2025-06-09 11:50:49
SewerLine	Unknown	Unknown	0	0								2025-06-09 11:50:49
SewerLine	Bonding Line	Unknown	50	0							CP Only	2025-06-09 11:52:00
SewerLine	Bonding Line	Wire	50	941							CP Only	2025-06-09 11:52:00
SewerLine	Bonding Line	Strap	50	942							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Unknown	51	0							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Aqua	51	901							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Blue	51	902							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Forest	51	903							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Green	51	904							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Lavender	51	905							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Orange	51	906							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Pink	51	907							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Red	51	908							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Yellow	51	909							CP Only	2025-06-09 11:52:00
SewerLine	Test Lead Wire	Purple	51	910							CP Only	2025-06-09 11:52:00
SewerLine	Rectifier Cable	Unknown	52	0							CP Only	2025-06-09 11:52:00
SewerLine	Rectifier Cable	Rectifier Cable	52	961							CP Only	2025-06-09 11:52:00
SewerLine	Sewer Gravity Main	Unknown	1	0								2025-06-09 11:52:01
SewerLine	Sewer Gravity Main	Collector Gravity Main	1	1						Any Vertex		2025-06-09 11:52:01
SewerLine	Sewer Gravity Main	Interceptor Gravity Main	1	2						Any Vertex		2025-06-09 11:52:01
SewerLine	Sewer Force Main	Unknown	2	0								2025-06-09 11:52:01
SewerLine	Sewer Force Main	Force Main	2	41						Any Vertex		2025-06-09 11:52:01
SewerLine	Lateral	Unknown	3	0						Any Vertex		2025-06-09 11:52:01
SewerLine	Lateral	Commercial	3	121						Any Vertex		2025-06-09 11:52:01
SewerLine	Lateral	Industrial	3	122						Any Vertex		2025-06-09 11:52:01
SewerLine	Lateral	Residential	3	123						Any Vertex		2025-06-09 11:52:01
SewerEdgeObject	Unknown	Unknown	0	0								2025-06-09 11:50:49

Category Name	Creation Time
Subnetwork Controller	2025-06-09 11:50:30
Subnetwork Tap	2025-06-09 11:50:30
Attribute Substitution	2025-06-09 11:50:30
CP Only	2025-06-09 11:52:24

Configuration Name	Configuration ID	Traversability Model	Default	Creation Time
Single terminal	0	Bidirectional	All	2025-06-09 11:50:30
Pressure Reducing	2	Directional	All	2025-06-09 11:52:24
Pressure Increasing	3	Directional	All	2025-06-09 11:52:24
Pipe Directional Dual Terminal	4	Directional	All	2025-06-09 11:52:24
Pipe Bidirectional Dual Terminal	5	Bidirectional	All	2025-06-09 11:52:24
Sewer Terminal Block	6	Directional	All	2025-06-09 11:52:24
Directional Manhole Terminal	7	Directional	All	2025-06-09 11:52:24

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
Pipe Directional Dual Terminal	Inlet Port	6	True
Pipe Directional Dual Terminal	Outlet Port	7	False
Pipe Bidirectional Dual Terminal	Port One	8
Pipe Bidirectional Dual Terminal	Port Two	9
Sewer Terminal Block	Terminal One	10	True
Sewer Terminal Block	Terminal Two	11	True
Sewer Terminal Block	Terminal Three	12	True
Sewer Terminal Block	Terminal Four	13	True
Sewer Terminal Block	Terminal Five	14	True
Sewer Terminal Block	Terminal Six	15	True
Sewer Terminal Block	Terminal Seven	16	True
Sewer Terminal Block	Terminal Eight	17	False
Directional Manhole Terminal	Upstream	18	True
Directional Manhole Terminal	Upstream 2	19	True
Directional Manhole Terminal	Downstream	20	False
Directional Manhole Terminal	Downstream 2	21	False

Configuration Name	Path Name	Path ID	Path Description
Directional Manhole Terminal	All	1	All

Name	ID	Usage Type	Data Type	Field Type	Inline	Domain Name	Nullable	Apportionable	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	2025-06-09 11:50:30
Terminal ID	2	Terminal ID	Integer	Short Integer	False		False	False	7	0	3	4	2025-06-09 11:50:30
Asset group	3	Asset Group	Integer	Short Integer	True		False	False	7	10	5	6	2025-06-09 11:50:30
Asset type	4	Asset Type	Integer	Short Integer	True		False	False	17	10	7	8	2025-06-09 11:50:30
Is subnetwork controller	5	Is Subnetwork Controller	Integer	Short Integer	True		False	False	27	1	9	10	2025-06-09 11:50:30
Tier name	6	Tier Name	Integer	Short Integer	True		False	False	28	6	11	12	2025-06-09 11:50:30
Shape length	7	Shape Length	Double	Double	False		False	True	34	0	13	14	2025-06-09 11:50:30
Position from	8	Position From	Double	Double	False		False	False	34	0	15	16	2025-06-09 11:50:30
Position to	9	Position To	Double	Double	False		False	False	34	0	17	18	2025-06-09 11:50:30
Flow direction	10	Flow Direction	Integer	Short Integer	True		False	False	34	2	19	20	2025-06-09 11:50:30
Cathodic Protection Traceability	11	Unknown	Integer	Short Integer	False		True	False	0	0	21	22	2025-06-09 11:52:24
Device Asset Group	12	Unknown	Integer	Long Integer	False		False	False	0	0	23	24	2025-06-09 11:52:24
Junction Asset Group	13	Unknown	Integer	Long Integer	False		False	False	0	0	25	26	2025-06-09 11:52:24
Lifecycle Status	14	Unknown	Integer	Short Integer	True	Lifecycle_Combined	False	False	36	3	27	28	2025-06-09 11:52:24
Line Asset Group	15	Unknown	Integer	Long Integer	False		False	False	0	0	29	30	2025-06-09 11:52:24
P:Device Status	16	Unknown	Integer	Short Integer	False		True	False	0	0	31	32	2025-06-09 11:52:24
S:Activate Value	17	Unknown	Integer	Short Integer	False		True	False	0	0	33	34	2025-06-09 11:52:24
Structure Junction Asset Group	18	Unknown	Integer	Long Integer	False		False	False	0	0	35	36	2025-06-09 11:52:24
Construction Status	19	Unknown	Integer	Short Integer	False		True	False	0	0	37	38	2025-06-09 11:52:24
P:Closeable	20	Unknown	Integer	Short Integer	True	Operable_Status	True	False	39	1	39	40	2025-06-09 11:52:24

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.SewerDevice	ASSETGROUP
Asset group	main.SewerLine	ASSETGROUP
Asset group	main.SewerAssembly	ASSETGROUP
Asset group	main.SewerJunction	ASSETGROUP
Asset group	main.SewerJunctionObject	ASSETGROUP
Asset group	main.SewerEdgeObject	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.SewerDevice	ASSETTYPE
Asset type	main.SewerLine	ASSETTYPE
Asset type	main.SewerAssembly	ASSETTYPE
Asset type	main.SewerJunction	ASSETTYPE
Asset type	main.SewerJunctionObject	ASSETTYPE
Asset type	main.SewerEdgeObject	ASSETTYPE
Is subnetwork controller	main.SewerDevice	ISSUBNETWORKCONTROLLER
Is subnetwork controller	main.SewerJunctionObject	ISSUBNETWORKCONTROLLER
Tier name	main.SewerDevice	TIERNAME
Tier name	main.SewerJunctionObject	TIERNAME
Shape length	main.StructureLine	st_length(SHAPE)
Shape length	main.SewerLine	st_length(SHAPE)
Flow direction	main.StructureLine	FLOWDIRECTION
Flow direction	main.StructureEdgeObject	FLOWDIRECTION
Flow direction	main.SewerLine	FLOWDIRECTION
Flow direction	main.SewerEdgeObject	FLOWDIRECTION
Cathodic Protection Traceability	main.SewerDevice	cptraceability
Cathodic Protection Traceability	main.SewerJunction	cptraceability
Cathodic Protection Traceability	main.SewerLine	cptraceability
Device Asset Group	main.SewerDevice	assetgroup
Junction Asset Group	main.SewerJunction	assetgroup
Lifecycle Status	main.StructureBoundary	lifecyclestatus
Lifecycle Status	main.StructureJunction	lifecyclestatus
Lifecycle Status	main.StructureLine	lifecyclestatus
Lifecycle Status	main.SewerAssembly	lifecyclestatus
Lifecycle Status	main.SewerDevice	lifecyclestatus
Lifecycle Status	main.SewerJunction	lifecyclestatus
Lifecycle Status	main.SewerLine	lifecyclestatus
Lifecycle Status	main.SewerEdgeObject	lifecyclestatus
Lifecycle Status	main.SewerJunctionObject	lifecyclestatus
Lifecycle Status	main.StructureEdgeObject	lifecyclestatus
Lifecycle Status	main.StructureJunctionObject	lifecyclestatus
Line Asset Group	main.SewerLine	assetgroup
P:Device Status	main.SewerDevice	presentstatus
S:Activate Value	main.SewerDevice	activevol
Structure Junction Asset Group	main.StructureJunction	assetgroup
Construction Status	main.SewerEdgeObject	constructionstatus
Construction Status	main.SewerJunctionObject	constructionstatus
Construction Status	main.StructureEdgeObject	constructionstatus
Construction Status	main.StructureJunctionObject	constructionstatus
Construction Status	main.StructureLine	constructionstatus
Construction Status	main.StructureJunction	constructionstatus
Construction Status	main.StructureBoundary	constructionstatus
Construction Status	main.SewerLine	constructionstatus
Construction Status	main.SewerJunction	constructionstatus
Construction Status	main.SewerDevice	constructionstatus
Construction Status	main.SewerAssembly	constructionstatus
P:Closeable	main.SewerDevice	operable

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
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.3772654273
X-Max	1235091.5522733442
Y-Min	1579469.3424027786
Y-Max	2161016.8781242818
Z-Min	0.00010000000474974513
Z-Max	0.00010000000474974513
Catalog ID	{32DFE65D-6564-40D6-88B8-A965B7F85745}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Controller Membership

Key	Value
utilityNetworkName	main.Network

Fields

Name	Alias	Type	Usage	Nullable	Length	Editable	Required
objectid	OBJECTID	OID	Index	False	8	False	True
globalid	GLOBALID	Global ID	Index	False	38	False	True
name	Name	String		True	255	True	False
created_user	Creator	String	Creator	True	255	False	False
created_date	Creation Date	Date	Created	True	8	False	False
last_edited_user	Editor	String	Editor	True	255	False	False
last_edited_date	Edit Date	Date	Edited	True	8	False	False
shape	shape	Geometry	Index	True	8	True	True
st_area(shape)		Double	Area	True	0	False	True
st_perimeter(shape)		Double	Length	True	0	False	True

Indexes

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.Sewer_Manhole_Inspection__ATTACHREL

Key	Value
Name	main.Sewer_Manhole_Inspection__ATTACHREL
Dataset Type	RelationshipClass
Dataset ID	161
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.SewerManholeInspection
Origin Primary Key	globalid
Origin Foreign Key	REL_GLOBALID
Destination Name	main.SewerManholeInspection__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{7F11BE72-83F9-44DB-A901-8767340ED4BC}

main.SewerAssembly

Properties

Key	Value
Name	main.SewerAssembly
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	142
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	Sewer 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.76851503144
X-Max	1270078.1610237402
Y-Min	1550391.9656167035
Y-Max	2190094.254910357
Z-Min	0.00010000000474974513
Z-Max	0.00010000000474974513
Catalog ID	{DC9DE0F6-44BC-4ED8-A69F-6D2079331CA5}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Controller Membership

Key	Value
utilityNetworkName	main.Network

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
SHAPE	Shape	Geometry	Index	False			8	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
SUPPORTEDSUBNETWORKNAME	Supported subnetwork name	String	Index	False		Unknown	2000	False	True
cpsubnetworkname	cpsubnetworkname	String		False		Unknown	2000	True	False
systemsubnetworkname	systemsubnetworkname	String		False		Unknown	2000	True	False
sewershedsubnetworkname	sewershedsubnetworkname	String		False		Unknown	2000	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
installdate	Install Date	Date		True			8	True	False
assetid	Asset ID	String		True			64	True	False
notes	Notes	String		True			2000	True	False
ownedby	Owned By	Short Integer		True	Sewer_Asset_Owner	1	2	True	False
maintby	Maintained By	Short Integer		True	Sewer_Asset_Manager	1	2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	2	True	False
created_user	Creator	String	Creator	True			255	False	False
created_date	Creation Date	Date	Created	True			8	False	False
last_edited_user	Editor	String	Editor	True			255	False	False
last_edited_date	Edit Date	Date	Edited	True			8	False	False
constructionstatus	Construction Status	Short Integer		True	Construction_Status	6	2	True	False

Indexes

Name	Is Unique	Is Ascending	Field Name
GDB_142_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
UUID_45	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__SewerAssembly_SHAPE	True	True	SHAPE

Subtypes

Name	Code	Details
Unknown	0

Assignments

Subtype Name	Field Name	Default Value	Domain Name
Unknown	ASSETTYPE	0	Network_6_UnknownAssetType
Unknown	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Unknown	SUPPORTEDSUBNETWORKNAME	Unknown
Unknown	constructionstatus	6	Construction_Status
Unknown	lifecyclestatus	2	Lifecycle_Status
Unknown	maintby	1	Sewer_Asset_Manager
Unknown	ownedby	1	Sewer_Asset_Owner
Unknown	cpsubnetworkname	Unknown
Unknown	sewershedsubnetworkname	Unknown
Unknown	systemsubnetworkname	Unknown

main.SewerAssembly__ATTACH

Properties

Key	Value
Name	main.SewerAssembly__ATTACH
Dataset Type	Table
Dataset ID	147
Minimum Client Version	10.1
Alias	Sewer Assembly Attachment
OID Field	attachmentid
GlobalID Field	globalid
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	{65E19DFC-E207-4BBC-B0CF-E34500A05630}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

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

Indexes

Name	Is Unique	Is Ascending	Field Name
GDB_147_REL_GLOB	False	True	rel_globalid
UUID_50	True	True	globalid
FDO_attachmentid	True	True	attachmentid

main.SewerAssembly__ATTACHREL

Key	Value
Name	main.SewerAssembly__ATTACHREL
Dataset Type	RelationshipClass
Feature Dataset	main.UtilityNetwork
Dataset ID	156
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.SewerAssembly
Origin Primary Key	globalid
Origin Foreign Key	REL_GLOBALID
Destination Name	main.SewerAssembly__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{18095CC4-3ACE-4939-98B1-EFD380F46363}

main.SewerDevice

Key	Value
Name	main.SewerDevice
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	139
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	Sewer 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.76851503144
X-Max	1270078.1610237402
Y-Min	1550391.9656167035
Y-Max	2190094.254910357
Z-Min	0.00010000000474974513
Z-Max	918.122199999998
Catalog ID	{FA2B3DF6-CFA3-4D5E-AB65-7B855CB970ED}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Key	Value
utilityNetworkName	main.Network

Name	Is Unique	Is Ascending	Field Name
GDB_139_VALIDATI	False	True	VALIDATIONSTATUS
GDB_139_SUBNETWO	False	True	SUBNETWORKCONTROLLERNAME
GDB_139_cpsubnet	False	True	cpsubnetworkname
GDB_139_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_139_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_139_systemsu	False	True	systemsubnetworkname
GDB_139_sewershe	False	True	sewershedsubnetworkname
UUID_43	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__SewerDevice_SHAPE	True	True	SHAPE

main.SewerDevice__ATTACH

Properties

Fields

Indexes

main.SewerDevice__ATTACHREL

main.SewerEdgeObject

Properties

Controller Membership

Fields

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

Indexes

Subtypes

Assignments

main.SewerJunction

Properties

Controller Membership

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
ISCONNECTED	Is connected	Short Integer		False	Network_6_IsConnected	2	2	False	True
SHAPE	Shape	Geometry	Index	False			8	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
cpsubnetworkname	cpsubnetworkname	String	Index	False		Unknown	2000	False	True
SUPPORTEDSUBNETWORKNAME	Supported subnetwork name	String	Index	False		Unknown	2000	False	True
SUPPORTINGSUBNETWORKNAME	Supporting subnetwork name	String	Index	False		Unknown	2000	False	True
systemsubnetworkname	systemsubnetworkname	String	Index	False		Unknown	2000	False	True
sewershedsubnetworkname	sewershedsubnetworkname	String	Index	False		Unknown	2000	False	True
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
installdate	Install Date	Date		True			8	True	False
assetid	Asset ID	String		True			64	True	False
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		2	True	False
ownedby	Owned By	Short Integer		True	Sewer_Asset_Owner	1	2	True	False
maintby	Maintained By	Short Integer		True	Sewer_Asset_Manager	1	2	True	False
notes	Notes	String		True			2000	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	2	True	False
cpoverride	Cathodic Protection Override	Short Integer		True	CP_Traceability		2	True	False
cptraceability	Cathodic Protection Traceability	Short Integer		True	CP_Traceability		2	True	False
bondedinsulated	Bonded/Insulated	Short Integer		True	Bonded_Insulated		2	True	False
created_user	Creator	String	Creator	True			255	False	False
created_date	Creation Date	Date	Created	True			8	False	False
last_edited_user	Editor	String	Editor	True			255	False	False
last_edited_date	Edit Date	Date	Edited	True			8	False	False
constructionstatus	Construction Status	Short Integer		True	Construction_Status	6	2	True	False
VALIDATIONSTATUS	Validation status	Short Integer	Index	True	Validation Status	6	2	False	True

Indexes

Subtypes

Assignments

Attribute Rules

Sewer Junction - Cathodic Protection Traceability

Key	Value
ID	17
Minimum Client Version	12.3
Evaluation Order	1
Name	Sewer Junction - Cathodic Protection Traceability
Description	Cathodic Protection Traceability for Sewer Junctions. Set traceability flag for junction assets
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Field Name	cptraceability
Editable	True
Enabled	True
Exclude From Client	False
Creation Time	2025-06-09 11:53:35
Script	// Assigned To: SewerJunction // Type: Calculation // Name: Sewer Junction - Cathodic Protection Traceability // Description: Cathodic Protection Traceability for Sewer Junctions. Set traceability flag for junction assets // Subtypes: All // Field: cptraceability // Trigger: Insert, Update // Exclude From Client: False // Disable: False // Is Editable: 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. // - Device - Cathodic Protection Traceability // - Line - Cathodic Protection Traceability // *********** 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 CP information // Implementation Note: This value does not need to change if using the industry data model var assigned_to_field = $feature.cptraceability; var cp_override = $feature.cpoverride; var cp_bondedinsulated = $feature.bondedinsulated; // Field in the data model used to store and manage the material details // Implementation Note: This value is not used in the Sewer data model var cp_material = null; //$feature.material; // The list of material types that are conductive from the a material field // Implementation Note: These do not need to be adjusted unless the value of the material attribute domains were changed. var conductive_materials = []; // The list of material types that are not conductive from the material field // Implementation Note: These do not need to be adjusted unless the value of the material attribute domains were changed. var non_conductive_materials = []; // 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 valid_asset_groups = [20, 50, 51]; // List of asset groups that are always included in a CP trace. // Implementation Note: If you have extended the CP model for additional asset groups, those asset groups should be added here var asset_groups_always_traceability = [50]; // List of asset groups that are always not include in a CP trace and are CP barriers. // Implementation Note: If you have extended the pipe model for additional asset groups that never conduct cp current, those asset groups should be added here var asset_groups_never_traceability = [51]; // Values to determine traceability // Implementation Note: These do not need to be adjusted unless the values of the CP_Traceability attribute domain were changed. var traceable = 1; // Also used for Bonded var not_traceable = 2; // Also used for Insulated // ********* End User Variables Section *********** if (TypeOf(valid_asset_groups) != 'Array' \|\| IndexOf(valid_asset_groups, $feature.assetgroup) == -1) { return assigned_to_field; } // If an override is specified, use that value regardless of other attributes if (cp_override > 0) { return cp_override; } // If a feature is always traceability or not, regardless of material, return the proper status if (TypeOf(asset_groups_always_traceability) == 'Array' && IndexOf(asset_groups_always_traceability, $feature.assetgroup) > -1) { return traceable; } if (TypeOf(asset_groups_never_traceability) == 'Array' && IndexOf(asset_groups_never_traceability, $feature.assetgroup) > -1) { return not_traceable; } // If a value is set on the bonded, insulated field, return that value if (!IsEmpty(cp_bondedinsulated) && cp_bondedinsulated > 0) { return cp_bondedinsulated; } // Check if the material is conductive if (TypeOf(conductive_materials) == 'Array' && IndexOf(conductive_materials, cp_material) > -1) { return traceable; } if (TypeOf(non_conductive_materials) == 'Array' && IndexOf(non_conductive_materials, cp_material) > -1) { return not_traceable; } //Return the value in the field when no other condition is met return assigned_to_field;

SewerJunction-GenerateIDs

Key	Value
ID	18
Minimum Client Version	12.3
Evaluation Order	2
Name	SewerJunction-GenerateIDs
Description	Generate IDs for SewerJunction using database sequences
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:35
Script	// Assigned To: SewerJunction // Type: Calculation // Name: SewerJunction-GenerateIDs // Description: Generate IDs for SewerJunction using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - StructureLine-GenerateIDs // - SewerDevice-GenerateIDs // - SewerLine-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 == '20') { id_format = { 'prefix': "Fttng", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_J_Fttng_20_seq'); }else if (selector_value_txt == '50') { id_format = { 'prefix': "Wr-Jnctn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_J_Wr_Jnctn_50_seq'); }else if (selector_value_txt == '51') { id_format = { 'prefix': "Insltn-Jnctn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_J_Insltn_Jnctn_51_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { return assigned_to_field } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

Junction Symbol Rotation

Key	Value
ID	19
Minimum Client Version	12.4
Evaluation Order	3
Name	Junction Symbol Rotation
Description	Symbol rotation calculation for junction features
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Field Name	symbolrotation
Editable	True
Enabled	True
Exclude From Client	False
Creation Time	2025-06-09 11:53:36
Script	// Assigned To: SewerJunction // 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, "{DC5F6D8F-B31D-4102-9AA9-687A8855371F}", ["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']; }

SewerJunction-GenerateIDs batch

Key	Value
ID	20
Minimum Client Version	12.3
Evaluation Order	1
Name	SewerJunction-GenerateIDs batch
Description	Generate IDs for SewerJunction using database sequences
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2025-06-09 11:53:36
Script	// Assigned To: SewerJunction // Type: Calculation // Name: SewerJunction-GenerateIDs // Description: Generate IDs for SewerJunction using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - StructureLine-GenerateIDs // - SewerDevice-GenerateIDs // - SewerLine-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 == '20') { id_format = { 'prefix': "Fttng", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_J_Fttng_20_seq'); }else if (selector_value_txt == '50') { id_format = { 'prefix': "Wr-Jnctn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_J_Wr_Jnctn_50_seq'); }else if (selector_value_txt == '51') { id_format = { 'prefix': "Insltn-Jnctn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_J_Insltn_Jnctn_51_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { return assigned_to_field } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

Validate Domains-SwJ

Key	Value
ID	21
Minimum Client Version	12.9
Evaluation Order	1
Name	Validate Domains-SwJ
Description	Validate domains applied by subtype. Checks for nulls where no domain applied and for valid value where domain applied.
Type	Validation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Severity	5
Error Number	5003
Error Message	Error
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:36
Script	// Assigned To: SewerJunction // Type: Validation // Name: Validate Domains-SwJ // Description: Validate domains applied by subtype. Checks for nulls where no domain applied and for valid value where domain applied. // Subtypes: All // Error Number: 5003 // Error Message: Error // Severity: 4 // 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. // - SwD-Validate Domains // - SwL-Validate Domains // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, "cpoverride", "cptraceability", "bondedinsulated") // Enable domain checks // Implementation Note: This rule can check two scenarios. These checks can be enabled or disabled. // 1. If a field specified in the field list below has no domain applied for a particular subtype, ensure the value is null. // (this is useful for Network Attributes) // 2. If a domain is applied to a field, ensure the value is valid for domain. This will check every field on $feature. var no_domain_check = true; var value_invalid_for_domain_check = true; // Custom error messages // Implementation Note: Customize error messages for the two domain checks. var no_domain_mess = 'Value found where no domain is applied in following fields:'; // field names will be appended at end of message var value_invalid_for_domain_mess = 'Invalid values found in following fields:'; // field names will be appended at end of message // The subtype field of $feature var assetgroup = $feature.ASSETGROUP; // Fields to run "no_domain_check" against. Each field should be declared to ensure ArcGIS validation succeeds. // Info on field declares: https://developers.arcgis.com/arcade/guide/logic/#global-variables var fields = ["cpoverride", "cptraceability", "bondedinsulated"]; // The Device class name var class_name = 'SewerJunction'; // ********* End User Variables Section ********* // ********* Functions ********* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_valid_codes(d) { // extract coded values from domain object var valid_codes = []; var coded_values = d["codedValues"]; for (var idx in coded_values) { push(valid_codes, coded_values[idx]["code"]); } return valid_codes; } function get_all_fields() { // extract list of all fields from $feature var all_fields = []; var flds = Schema($feature)['fields']; for (var idx in flds) { push(all_fields, flds[idx]['name']); } return all_fields; } // ********* End Functions Section **************** // Scan all fields for invalid values based on whether a domain is applied. // Check fields specified in user section. If no domain applied then the value should be null. var no_domain_errors = []; var class_fs = get_features_switch_yard($datastore, class_name, fields, false); if (no_domain_check) { for (var idx in fields) { var field = fields[idx]; var d = Domain(class_fs, field, Number(assetgroup)); // have to force assetgroup to Number to get past validation if (IsEmpty(d)) { // no domain is applied to this field, on this subtype. It should be null. if (!IsEmpty($feature[field])) { push(no_domain_errors, field); } } } } // Check for invalid values in fields that have domain applied var invalid_value_errors = []; if (value_invalid_for_domain_check) { var all_fields = get_all_fields(); class_fs = get_features_switch_yard($datastore, class_name, all_fields, false); for (var idx in all_fields) { var d2 = Domain(class_fs, all_fields[idx], Number(assetgroup)); // have to force assetgroup to Number to get past validation if (IsEmpty(d2)) { continue; } // domain applied, check if value is valid. allow nulls. var value = $feature[all_fields[idx]]; if (IsEmpty(value)) { continue; } // only coded value and range domains supported currently if (d2["type"] == "codedValue") { var allowed_codes = get_valid_codes(d2); if (!Includes(allowed_codes, value)) { push(invalid_value_errors, all_fields[idx]); } } else if (d2["type"] == "range") { if (value < d2["min"] \|\| d2["max"] < value) { push(invalid_value_errors, all_fields[idx]); } } } } // Build error message from results var error_mess = ''; if (Count(no_domain_errors) > 0) { error_mess += `${no_domain_mess} ${Concatenate(no_domain_errors, ', ')}. `; } if (Count(invalid_value_errors) > 0) { error_mess += `${value_invalid_for_domain_mess} ${Concatenate(invalid_value_errors, ', ')}. `; } if (!IsEmpty(error_mess)) { return {'errorMessage': error_mess}; } return true;

main.SewerJunction__ATTACH

Properties

Fields

Indexes

main.SewerJunction__ATTACHREL

main.SewerJunctionObject

Properties

Controller Membership

Fields

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

Indexes

Subtypes

Assignments

main.SewerLine

Properties

Controller Membership

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
ISCONNECTED	Is connected	Short Integer		False	Network_6_IsConnected	2	2	False	True
FROMDEVICETERMINAL	From device terminal	Short Integer		False	Network_6_TerminalNames	0	2	True	True
TODEVICETERMINAL	To device terminal	Short Integer		False	Network_6_TerminalNames	0	2	True	True
FLOWDIRECTION	Flow direction	Short Integer		True	Network_6_FlowDirection	1	2	True	True
SHAPE	Shape	Geometry	Index	False			8	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
cpsubnetworkname	cpsubnetworkname	String	Index	False		Unknown	2000	False	True
SUPPORTEDSUBNETWORKNAME	Supported subnetwork name	String	Index	False		Unknown	2000	False	True
SUPPORTINGSUBNETWORKNAME	Supporting subnetwork name	String	Index	False		Unknown	2000	False	True
systemsubnetworkname	systemsubnetworkname	String	Index	False		Unknown	2000	False	True
sewershedsubnetworkname	sewershedsubnetworkname	String	Index	False		Unknown	2000	False	True
diameter	Size/Diameter	Double		True			8	True	False
linertype	Liner Type	Short Integer		True			2	True	False
downelev	Downstream Elevation	Double		True			8	True	False
upelev	Upstream Elevation	Double		True			8	True	False
slope	Slope	Double		True			8	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
installdate	Install Date	Date		True			8	True	False
assetid	Asset ID	String		True			64	True	False
ownedby	Owned By	Short Integer		True	Sewer_Asset_Owner	1	2	True	False
maintby	Maintained By	Short Integer		True	Sewer_Asset_Manager	1	2	True	False
tracerwire	Tracer Wire	Short Integer		True			2	True	False
measuredlength	Measured Length	Double		True			8	True	False
notes	Notes	String		True			2000	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	2	True	False
cptraceability	Cathodic Protection Traceability	Short Integer		True	CP_Traceability		2	True	False
cpoverride	Cathodic Protection Override	Short Integer		True	CP_Traceability		2	True	False
material	Material	Short Integer		True			2	True	False
bondedinsulated	Bonded/Insulated	Short Integer		True	Bonded_Insulated		2	True	False
mainshape	Main Shape	Short Integer		True			2	True	False
created_user	Creator	String	Creator	True			255	False	False
created_date	Creation Date	Date	Created	True			8	False	False
last_edited_user	Editor	String	Editor	True			255	False	False
last_edited_date	Edit Date	Date	Edited	True			8	False	False
constructionstatus	Construction Status	Short Integer		True	Construction_Status	6	2	True	False
VALIDATIONSTATUS	Validation status	Short Integer	Index	True	Validation Status	6	2	False	True
st_length(SHAPE)	shape_Length	Double	Length	True			0	False	True

Indexes

Subtypes

Assignments

Attribute Rules

Sewer Line - Cathodic Protection Traceability

Key	Value
ID	22
Minimum Client Version	12.3
Evaluation Order	1
Name	Sewer Line - Cathodic Protection Traceability
Description	Cathodic protection traceability for Sewer lines. Set traceability flag for lines assets
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Field Name	cptraceability
Editable	True
Enabled	True
Exclude From Client	False
Creation Time	2025-06-09 11:53:45
Script	// Assigned To: SewerLine // Type: Calculation // Name: Sewer Line - Cathodic Protection Traceability // Description: Cathodic protection traceability for Sewer lines. Set traceability flag for lines assets // Subtypes: All // Field: cptraceability // Trigger: Insert, Update // Exclude From Client: False // Disable: False // Is Editable: 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. // - Device - Cathodic Protection Traceability // - Junction - Cathodic Protection Traceability // *********** 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 CP information // Implementation Note: This value does not need to change if using the industry data model var assigned_to_field = $feature.cptraceability; var cp_override = $feature.cpoverride; var cp_bondedinsulated = $feature.bondedinsulated; // Field in the data model used to store and manage the material details // Implementation Note: This value does not need to change if using the industry data model var cp_material = $feature.material; // The list of material types that are conductive from the assettype field and the asset type domains // Implementation Note: These do not need to be adjusted unless the value of the asset type attribute domains were changed. var conductive_materials = [5, 11, 13, 25]; // The list of material types that are not conductive from the assettype field and the asset type domains // Implementation Note: These do not need to be adjusted unless the value of the asset type attribute domains were changed. var non_conductive_materials = [1, 2, 3, 4, 6, 7, 8, 9, 10, 12, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 26]; // 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 valid_asset_groups = [1, 2, 3, 50, 51, 52]; // List of asset groups that are always included in a CP trace. // Implementation Note: If you have extended the CP model for additional asset groups, those asset groups should be added here var asset_groups_always_traceability = [50, 51, 52]; // List of asset groups that are always not include in a CP trace and are CP barriers. // Implementation Note: If you have extended the pipe model for additional asset groups that never conduct cp current, those asset groups should be added here var asset_groups_never_traceability = []; // Values to determine traceability // Implementation Note: These do not need to be adjusted unless the value of the CP_Traceability attribute domain were changed. var traceable = 1; // Also used for Bonded var not_traceable = 2; // Also used for Insulated // ********* End User Variables Section *********** if (TypeOf(valid_asset_groups) != 'Array' \|\| IndexOf(valid_asset_groups, $feature.assetgroup) == -1) { return assigned_to_field; } // If an override is specified, use that value regardless of other attributes if (cp_override > 0) { return cp_override; } // If a feature is always traceability or not, regardless of material, return the proper status if (TypeOf(asset_groups_always_traceability) == 'Array' && IndexOf(asset_groups_always_traceability, $feature.assetgroup) > -1) { return traceable; } if (TypeOf(asset_groups_never_traceability) == 'Array' && IndexOf(asset_groups_never_traceability, $feature.assetgroup) > -1) { return not_traceable; } // If a value is set on the bonded, insulated field, return that value if (!IsEmpty(cp_bondedinsulated) && cp_bondedinsulated > 0) { return cp_bondedinsulated; } // Check if the material is conductive if (TypeOf(conductive_materials) == 'Array' && IndexOf(conductive_materials, cp_material) > -1) { return traceable; } if (TypeOf(non_conductive_materials) == 'Array' && IndexOf(non_conductive_materials, cp_material) > -1) { return not_traceable; } //Return the value in the field when no other condition is met return assigned_to_field;

SewerLine-GenerateIDs

Key	Value
ID	23
Minimum Client Version	12.3
Evaluation Order	2
Name	SewerLine-GenerateIDs
Description	Generate IDs for SewerLine using database sequences
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:45
Script	// Assigned To: SewerLine // Type: Calculation // Name: SewerLine-GenerateIDs // Description: Generate IDs for SewerLine using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - StructureLine-GenerateIDs // - SewerDevice-GenerateIDs // - SewerJunction-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 == '50') { id_format = { 'prefix': "Bndng-Ln", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Bndng_Ln_50_seq'); }else if (selector_value_txt == '51') { id_format = { 'prefix': "Tst-Ld-Wr", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Tst_Ld_Wr_51_seq'); }else if (selector_value_txt == '52') { id_format = { 'prefix': "Rctfr-Cbl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Rctfr_Cbl_52_seq'); }else if (selector_value_txt == '1') { id_format = { 'prefix': "Swr-Grvty-Mn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Swr_Grvty_Mn_1_seq'); }else if (selector_value_txt == '2') { id_format = { 'prefix': "Swr-Frc-Mn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Swr_Frc_Mn_2_seq'); }else if (selector_value_txt == '3') { id_format = { 'prefix': "Ltrl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Ltrl_3_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { return assigned_to_field } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

Line - Snap to Manhole

Key	Value
ID	24
Minimum Client Version	12.7
Evaluation Order	3
Name	Line - Snap to Manhole
Description	Generates pipe connection points when Sewer Main is snapped to a Manhole Channel.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:45
Script	// Assigned To: SewerLine // Type: Calculation // Name: Line - Snap to Manhole // Description: Generates pipe connection points when Sewer Main 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 Main, Force Main // Gravity Main = 1, Force = 2 var asset_group = $feature.assetgroup; var valid_asset_groups = [1, 2]; // 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 // Collector Gravity Main, Interceptor Gravity Main, Force Main // Collector = 1, Interceptor = 2, Force = 41 var asset_type = $feature.assettype; var valid_asset_types = [1, 2, 41]; // 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 = "SewerDevice"; 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, '{479132B4-51F7-45CF-ABE0-98733149F306}', ['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 - Sewer Storm Vault sql // Implementation Note: SQL expression used to find Sewer Storm Vault containers var vault_sql = 'ASSETGROUP in (208) and ASSETTYPE in (9)'; // The High Pipe Elevation field name on a Sewer 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 Sewer Storm 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 Sewer Storm 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; } // Limit the rule to valid asset types if (!Includes(valid_asset_types, asset_type)) { 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 Sewer Storm 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 Sewer Storm 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 Sewer Storm 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 };

Line - Set Attributes from Z

Key	Value
ID	25
Minimum Client Version	12.7
Evaluation Order	4
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.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:45
Script	// Assigned To: SewerLine // 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: 4 // 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 = [1, 2]; // Sewer Gravity Main, Sewer Force Main // 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}};

Line - Main Slope

Key	Value
ID	26
Minimum Client Version	12.7
Evaluation Order	5
Name	Line - Main Slope
Description	Adjusts the slope based on the upstream, downstream, and length of the main
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Field Name	slope
Editable	True
Enabled	True
Exclude From Client	False
Creation Time	2025-06-09 11:53:45
Script	// Assigned To: SewerLine // 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: 5 // 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 = [1, 2]; // Sewer Gravity Main, Sewer Force Main // *********** 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)));

SewerLine-GenerateIDs batch

Key	Value
ID	27
Minimum Client Version	12.3
Evaluation Order	1
Name	SewerLine-GenerateIDs batch
Description	Generate IDs for SewerLine using database sequences
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2025-06-09 11:53:45
Script	// Assigned To: SewerLine // Type: Calculation // Name: SewerLine-GenerateIDs // Description: Generate IDs for SewerLine using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - StructureLine-GenerateIDs // - SewerDevice-GenerateIDs // - SewerJunction-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 == '50') { id_format = { 'prefix': "Bndng-Ln", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Bndng_Ln_50_seq'); }else if (selector_value_txt == '51') { id_format = { 'prefix': "Tst-Ld-Wr", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Tst_Ld_Wr_51_seq'); }else if (selector_value_txt == '52') { id_format = { 'prefix': "Rctfr-Cbl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Rctfr_Cbl_52_seq'); }else if (selector_value_txt == '1') { id_format = { 'prefix': "Swr-Grvty-Mn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Swr_Grvty_Mn_1_seq'); }else if (selector_value_txt == '2') { id_format = { 'prefix': "Swr-Frc-Mn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Swr_Frc_Mn_2_seq'); }else if (selector_value_txt == '3') { id_format = { 'prefix': "Ltrl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('S_L_Ltrl_3_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { return assigned_to_field } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

Line - Snap to Manhole batch

Key	Value
ID	28
Minimum Client Version	12.7
Evaluation Order	2
Name	Line - Snap to Manhole batch
Description	Generates pipe connection points when Sewer Main is snapped to a Manhole Channel.
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2025-06-09 11:53:45
Script	// Assigned To: SewerLine // Type: Calculation // Name: Line - Snap to Manhole // Description: Generates pipe connection points when Sewer Main 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 Main, Force Main // Gravity Main = 1, Force = 2 var asset_group = $feature.assetgroup; var valid_asset_groups = [1, 2]; // 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 // Collector Gravity Main, Interceptor Gravity Main, Force Main // Collector = 1, Interceptor = 2, Force = 41 var asset_type = $feature.assettype; var valid_asset_types = [1, 2, 41]; // 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 = "SewerDevice"; 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, '{479132B4-51F7-45CF-ABE0-98733149F306}', ['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 - Sewer Storm Vault sql // Implementation Note: SQL expression used to find Sewer Storm Vault containers var vault_sql = 'ASSETGROUP in (208) and ASSETTYPE in (9)'; // The High Pipe Elevation field name on a Sewer 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 Sewer Storm 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 Sewer Storm 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; } // Limit the rule to valid asset types if (!Includes(valid_asset_types, asset_type)) { 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 Sewer Storm 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 Sewer Storm 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 Sewer Storm 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 };

Validate Domains-SwL

Key	Value
ID	29
Minimum Client Version	12.9
Evaluation Order	1
Name	Validate Domains-SwL
Description	Validate domains applied by subtype. Checks for nulls where no domain applied and for valid value where domain applied.
Type	Validation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Severity	5
Error Number	5003
Error Message	Error
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:45
Script	// Assigned To: SewerLine // Type: Validation // Name: Validate Domains-SwL // Description: Validate domains applied by subtype. Checks for nulls where no domain applied and for valid value where domain applied. // Subtypes: All // Error Number: 5003 // Error Message: Error // Severity: 4 // 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. // - SwD-Validate Domains // - SwJ-Validate Domains // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, "cpoverride", "cptraceability", "bondedinsulated") // Enable domain checks // Implementation Note: This rule can check two scenarios. These checks can be enabled or disabled. // 1. If a field specified in the field list below has no domain applied for a particular subtype, ensure the value is null. // (this is useful for Network Attributes) // 2. If a domain is applied to a field, ensure the value is valid for domain. This will check every field on $feature. var no_domain_check = true; var value_invalid_for_domain_check = true; // Custom error messages // Implementation Note: Customize error messages for the two domain checks. var no_domain_mess = 'Value found where no domain is applied in following fields:'; // field names will be appended at end of message var value_invalid_for_domain_mess = 'Invalid values found in following fields:'; // field names will be appended at end of message // The subtype field of $feature var assetgroup = $feature.ASSETGROUP; // Fields to run "no_domain_check" against. Each field should be declared to ensure ArcGIS validation succeeds. // Info on field declares: https://developers.arcgis.com/arcade/guide/logic/#global-variables var fields = ["cpoverride", "cptraceability", "bondedinsulated"]; // The applied class name var class_name = 'SewerLine'; // ********* End User Variables Section ********* // ********* Functions ********* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_valid_codes(d) { // extract coded values from domain object var valid_codes = []; var coded_values = d["codedValues"]; for (var idx in coded_values) { push(valid_codes, coded_values[idx]["code"]); } return valid_codes; } function get_all_fields() { // extract list of all fields from $feature var all_fields = []; var flds = Schema($feature)['fields']; for (var idx in flds) { push(all_fields, flds[idx]['name']); } return all_fields; } // ********* End Functions Section **************** // Scan all fields for invalid values based on whether a domain is applied. // Check fields specified in user section. If no domain applied then the value should be null. var no_domain_errors = []; var class_fs = get_features_switch_yard($datastore, class_name, fields, false); if (no_domain_check) { for (var idx in fields) { var field = fields[idx]; var d = Domain(class_fs, field, Number(assetgroup)); // have to force assetgroup to Number to get past validation if (IsEmpty(d)) { // no domain is applied to this field, on this subtype. It should be null. if (!IsEmpty($feature[field])) { push(no_domain_errors, field); } } } } // Check for invalid values in fields that have domain applied var invalid_value_errors = []; if (value_invalid_for_domain_check) { var all_fields = get_all_fields(); class_fs = get_features_switch_yard($datastore, class_name, all_fields, false); for (var idx in all_fields) { var d2 = Domain(class_fs, all_fields[idx], Number(assetgroup)); // have to force assetgroup to Number to get past validation if (IsEmpty(d2)) { continue; } // domain applied, check if value is valid. allow nulls. var value = $feature[all_fields[idx]]; if (IsEmpty(value)) { continue; } // only coded value and range domains supported currently if (d2["type"] == "codedValue") { var allowed_codes = get_valid_codes(d2); if (!Includes(allowed_codes, value)) { push(invalid_value_errors, all_fields[idx]); } } else if (d2["type"] == "range") { if (value < d2["min"] \|\| d2["max"] < value) { push(invalid_value_errors, all_fields[idx]); } } } } // Build error message from results var error_mess = ''; if (Count(no_domain_errors) > 0) { error_mess += `${no_domain_mess} ${Concatenate(no_domain_errors, ', ')}. `; } if (Count(invalid_value_errors) > 0) { error_mess += `${value_invalid_for_domain_mess} ${Concatenate(invalid_value_errors, ', ')}. `; } if (!IsEmpty(error_mess)) { return {'errorMessage': error_mess}; } return true;

main.SewerLine__ATTACH

Properties

Fields

Indexes

main.SewerLine__ATTACHREL

main.SewerManholeInspection

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Length	Editable	Required
objectid	OBJECTID	OID	Index	False		4	False	True
inspector	Inspector	String		True		50	True	False
inspectdt	Inspection Date	Date		True		8	True	False
inspectpurp	Inspection Purpose	Short Integer		True	Inspection_Manhole_Purpose	2	True	False
precleaning	Pre-Cleaning	Short Integer		True	Inspection_Manhole_Pre-Cleaning	2	True	False
precleaningdt	Pre-Cleaning Date	Date		True		8	True	False
weather	Weather	Short Integer		True	Inspection_Manhole_Weather	2	True	False
runoff	Runoff Potential	Short Integer		True	Inspection_Manhole_Runoff_Potential	2	True	False
inspectionstatus	Inspection Status	Short Integer		True	Inspection_Manhole_Status	2	True	False
evidsurcharge	Evidence of Surcharge	Short Integer		True	Yes_No	2	True	False
coverfit	Cover Fit	Short Integer		True	Inspection_Manhole_Cover_Fit	2	True	False
covercondition	Cover Condition	Short Integer		True	Inspection_Manhole_Cover_Condition	2	True	False
coverinsertcondition	Cover Insert Condition	Short Integer		True	Inspection_Manhole_Cover_Insert_Condition	2	True	False
coverringcondition	Cover Ring Condition	Short Integer		True	Inspection_Manhole_Adjustable_Ring_Condition	2	True	False
framecondition	Frame Condition	Short Integer		True	Inspection_Manhole_Frame_Condition	2	True	False
framesealcondition	Frame Seal Condition	Short Integer		True	Inspection_Manhole_Frame_Seal_Condition	2	True	False
framesealinflow	Evidence of Frame Seal Inflow	Short Integer		True	Inspection_Manhole_Frame_Seal_Inflow	2	True	False
notes	Notes	String		True		2000	True	False
assetguid	Asset Guid	GUID	Index	True		38	True	False
created_user	Creator	String	Creator	True		255	False	False
created_date	Creation Date	Date	Created	True		8	False	False
last_edited_user	Editor	String	Editor	True		255	False	False
last_edited_date	Edit Date	Date	Edited	True		8	False	False
globalid	GlobalID	Global ID	Index	False		38	False	True

Indexes

main.SewerManholeInspection__ATTACH

Properties

Fields

Indexes

main.SewerStructure_Manhole_To_Inspection

main.SewerSubnetLine

Properties

Controller Membership

Fields

Indexes

Subtypes

Assignments

main.StructureBoundary

Properties

Controller Membership

Fields

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

Indexes

Subtypes

Assignments

Attribute Rules

StructureBoundary-GenerateIDs

Key	Value
ID	6
Minimum Client Version	12.3
Evaluation Order	1
Name	StructureBoundary-GenerateIDs
Description	Generate IDs for StructureBoundary using database sequences
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:08
Script	// Assigned To: StructureBoundary // Type: Calculation // Name: StructureBoundary-GenerateIDs // Description: Generate IDs for StructureBoundary using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - StructureLine-GenerateIDs // - SewerDevice-GenerateIDs // - SewerJunction-GenerateIDs // - SewerLine-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 == '307') { id_format = { 'prefix': "Swr-Trtmnt-Plnt-Bndry", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_Swr_Tmt_Plnt_307_seq'); }else if (selector_value_txt == '208') { id_format = { 'prefix': "Swr-Strm-Vlt-Bndry", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_Swr_Strm_Vlt_Bndry_208_seq'); }else if (selector_value_txt == '301') { id_format = { 'prefix': "Swr-Lft-Sttn-Bndry", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_Swr_Lft_Sttn_Bndry_301_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { return assigned_to_field } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

StructureBoundary-GenerateIDs batch

Key	Value
ID	7
Minimum Client Version	12.3
Evaluation Order	1
Name	StructureBoundary-GenerateIDs batch
Description	Generate IDs for StructureBoundary using database sequences
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2025-06-09 11:53:08
Script	// Assigned To: StructureBoundary // Type: Calculation // Name: StructureBoundary-GenerateIDs // Description: Generate IDs for StructureBoundary using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - StructureLine-GenerateIDs // - SewerDevice-GenerateIDs // - SewerJunction-GenerateIDs // - SewerLine-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 == '307') { id_format = { 'prefix': "Swr-Trtmnt-Plnt-Bndry", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_Swr_Tmt_Plnt_307_seq'); }else if (selector_value_txt == '208') { id_format = { 'prefix': "Swr-Strm-Vlt-Bndry", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_Swr_Strm_Vlt_Bndry_208_seq'); }else if (selector_value_txt == '301') { id_format = { 'prefix': "Swr-Lft-Sttn-Bndry", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_Swr_Lft_Sttn_Bndry_301_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { return assigned_to_field } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

main.StructureBoundary__ATTACH

Properties

Fields

Indexes

main.StructureBoundary__ATTACHREL

main.StructureEdgeObject

Properties

Controller Membership

Fields

Indexes

Subtypes

Assignments

main.StructureJunction

Properties

Controller Membership

Fields

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

Indexes

Subtypes

Assignments

Attribute Rules

StructureJunction - Create Manhole Channel

Key	Value
ID	1
Minimum Client Version	12.7
Evaluation Order	1
Name	StructureJunction - Create Manhole Channel
Description	When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Subtype	Sewer Storm Vault
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:02
Script	// 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 SewerDevice / Manhole Channel var device_class = "SewerDevice"; // The Asset Group and Asset Type of a SewerDevice / 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};

StructureJunction-GenerateIDs

Key	Value
ID	2
Minimum Client Version	12.3
Evaluation Order	2
Name	StructureJunction-GenerateIDs
Description	Generate IDs for StructureJunction using database sequences
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:02
Script	// Assigned To: StructureJunction // Type: Calculation // Name: StructureJunction-GenerateIDs // Description: Generate IDs for StructureJunction using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - StructureLine-GenerateIDs // - SewerDevice-GenerateIDs // - SewerJunction-GenerateIDs // - SewerLine-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 if (selector_value_txt == '301') { id_format = { 'prefix': "Swr-Lft-Sttn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SJ_Swr_Lft_Sttn_301_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { return assigned_to_field } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

StructureJunction - Manhole Elevation Attributes

Key	Value
ID	3
Minimum Client Version	12.7
Evaluation Order	3
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.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Subtype	Sewer Storm Vault
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:02
Script	// 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 = "SewerDevice"; // Sewer 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;

StructureJunction - Create Manhole Channel batch

Key	Value
ID	4
Minimum Client Version	12.7
Evaluation Order	1
Name	StructureJunction - Create Manhole Channel batch
Description	When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel.
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Subtype	Sewer Storm Vault
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2025-06-09 11:53:03
Script	// 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 SewerDevice / Manhole Channel var device_class = "SewerDevice"; // The Asset Group and Asset Type of a SewerDevice / 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};

StructureJunction-GenerateIDs batch

Key	Value
ID	5
Minimum Client Version	12.3
Evaluation Order	2
Name	StructureJunction-GenerateIDs batch
Description	Generate IDs for StructureJunction using database sequences
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2025-06-09 11:53:03
Script	// Assigned To: StructureJunction // Type: Calculation // Name: StructureJunction-GenerateIDs // Description: Generate IDs for StructureJunction using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - StructureLine-GenerateIDs // - SewerDevice-GenerateIDs // - SewerJunction-GenerateIDs // - SewerLine-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 if (selector_value_txt == '301') { id_format = { 'prefix': "Swr-Lft-Sttn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SJ_Swr_Lft_Sttn_301_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { return assigned_to_field } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

main.StructureJunction__ATTACH

Properties

Fields

Indexes

main.StructureJunction__ATTACHREL

main.StructureJunctionObject

Properties

Controller Membership

Fields

Indexes

Subtypes

Assignments

main.StructureLine

Properties

Controller Membership

Fields

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

Indexes

Subtypes

Assignments

Attribute Rules

StructureLine-GenerateIDs

Key	Value
ID	8
Minimum Client Version	12.3
Evaluation Order	1
Name	StructureLine-GenerateIDs
Description	Generate IDs for StructureLine using database sequences
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2025-06-09 11:53:16
Script	// Assigned To: StructureLine // Type: Calculation // Name: StructureLine-GenerateIDs // Description: Generate IDs for StructureLine using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - SewerDevice-GenerateIDs // - SewerJunction-GenerateIDs // - SewerLine-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 == '201') { id_format = { 'prefix': "Swr-Strm-Csng", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SL_Swr_Strm_Csng_201_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { return assigned_to_field } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

StructureLine-GenerateIDs batch

Key	Value
ID	9
Minimum Client Version	12.3
Evaluation Order	1
Name	StructureLine-GenerateIDs batch
Description	Generate IDs for StructureLine using database sequences
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2025-06-09 11:53:16
Script	// Assigned To: StructureLine // Type: Calculation // Name: StructureLine-GenerateIDs // Description: Generate IDs for StructureLine using database sequences // Subtypes: All // Field: assetid // Trigger: Insert // 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 // - SewerDevice-GenerateIDs // - SewerJunction-GenerateIDs // - SewerLine-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 == '201') { id_format = { 'prefix': "Swr-Strm-Csng", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SL_Swr_Strm_Csng_201_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 (IsEmpty(assigned_to_field) == false && assigned_to_field != '') { 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__ATTACH

Properties

Fields

Indexes

main.StructureLine__ATTACHREL

main.UtilityNetwork

Domains

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

Name	Is Unique	Is Ascending	Field Name
GDB_146_sewershe	False	True	sewershedsubnetworkname
GDB_146_systemsu	False	True	systemsubnetworkname
GDB_146_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_146_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_146_cpsubnet	False	True	cpsubnetworkname
UUID_49	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID

Name	Is Unique	Is Ascending	Field Name
GDB_143_VALIDATI	False	True	VALIDATIONSTATUS
GDB_143_cpsubnet	False	True	cpsubnetworkname
GDB_143_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_143_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_143_systemsu	False	True	systemsubnetworkname
GDB_143_sewershe	False	True	sewershedsubnetworkname
UUID_46	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__SewerJunction_SHAPE	True	True	SHAPE

Name	Is Unique	Is Ascending	Field Name
GDB_149_REL_GLOB	False	True	rel_globalid
UUID_52	True	True	globalid
FDO_attachmentid	True	True	attachmentid

Name	Is Unique	Is Ascending	Field Name
GDB_145_sewershe	False	True	sewershedsubnetworkname
GDB_145_systemsu	False	True	systemsubnetworkname
GDB_145_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_145_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_145_cpsubnet	False	True	cpsubnetworkname
GDB_145_SUBNETWO	False	True	SUBNETWORKCONTROLLERNAME
UUID_48	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID

Name	Is Unique	Is Ascending	Field Name
GDB_141_VALIDATI	False	True	VALIDATIONSTATUS
GDB_141_cpsubnet	False	True	cpsubnetworkname
GDB_141_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_141_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_141_systemsu	False	True	systemsubnetworkname
GDB_141_sewershe	False	True	sewershedsubnetworkname
UUID_44	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__SewerLine_SHAPE	True	True	SHAPE

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

Name	Is Unique	Is Ascending	Field Name
GDB_151_assetgui	False	True	assetguid
UUID_54	True	True	globalid
FDO_objectid	True	True	objectid

Name	Is Unique	Is Ascending	Field Name
GDB_152_REL_GLOB	False	True	rel_globalid
UUID_55	True	True	globalid
FDO_attachmentid	True	True	attachmentid

Rule ID	Origin Subtype	Origin Max Cardinality	Destination Max Cardinality
1	Sewer Lift Station	0	0
2	Sewer Storm Vault	10000	10000
3	Unknown	0	0

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

Name	Is Unique	Is Ascending	Field Name
GDB_38_VALIDATIO	False	True	VALIDATIONSTATUS
GDB_38_SUBNETWOR	False	True	SUBNETWORKNAME
UUID_40	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__StructureBoundary_SHAPE	True	True	SHAPE

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

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

Name	Is Unique	Is Ascending	Field Name
GDB_34_VALIDATIO	False	True	VALIDATIONSTATUS
GDB_34_SUBNETWOR	False	True	SUBNETWORKNAME
UUID_38	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__StructureJunction_SHAPE	True	True	SHAPE

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

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

Name	Is Unique	Is Ascending	Field Name
GDB_37_VALIDATIO	False	True	VALIDATIONSTATUS
GDB_37_SUBNETWOR	False	True	SUBNETWORKNAME
UUID_39	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__StructureLine_SHAPE	True	True	SHAPE

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

Code	Description	Details
0	Unknown
1	Ames Company Inc
2	BAVCO
3	Cla-Val
4	Conbraco Industries Inc
5	Febco Backflow Prevention
6	Danfoss Flomatic Valve
7	Mid-West Instrument
8	Watts Regulator
9	Hunter Industries
10	Wilkins/Zurn Industries
100	Other

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

Code	Description	Details
0	Unknown
11	Carbon-Graphite
12	Cast Iron
13	Galvanic
14	Graphite
15	Magnesium
16	Magnesium (High Grade B)
17	Magnesium (High Potential)
18	Mixed Metal Oxide
19	Scrap Steel
20	Zinc

Code	Description	Details
0	Unknown
0.75	3/4 lb
1	1 lb
1.5	1 1/2 lb
3	3 lb
5	5 lb
9	9 lb
17	17 lb
20	20 lb
32	32 lb
48	48 lb

Code	Description	Details
0	Unknown
21	Fan Cooling
22	Convection Cooling
23	System Cooling
24	Assisted Cooling

Code	Description	Details
0	Unknown
1	Sound
2	Cracked
3	Broken
4	Corroded/Pitted/Worn
5	Leaking
6	Poor Installation

Code	Description	Details
0	Unknown
1	Sound
2	Poorly Fitting
3	Cracked/Torn/Holes
4	Leaking
5	Insert Fell

Code	Description	Details
0	Unknown
1	None
2	Stains
3	I&I Visible - Weeper
4	I&I Visible - Dripper
5	I&I Visible - Runner
6	I&I Visible - Gusher
7	Dye Test Positive

Code	Description	Details
0	Unknown
1	Maintenance Required
2	I&I Investigation
3	Post-Rehab Survey
4	Pre-Rehab Survey
5	Pre-Acceptance
6	Routine Assessment
7	CIP Assessment
8	Resurvey for Any Reason

Code	Description	Details
0	Unknown
1	Surface Inspection
2	Descent Inspection
3	Remote Inspection
4	Not Found
5	Not Opened
6	Surcharged/Debris
7	Not Inspected - Traffic
8	No Access
9	Buried and Marked

Code	Description	Details
0	Unknown
1	Very Dry
2	Dry
3	Damp
4	Light Rain
5	Heavy Rain
6	Snow
7	Saturated