DistrictEnergy_UtilityNetwork

Workspace

Properties

Key	Value
Name	DistrictEnergy_UtilityNetwork.geodatabase
Workspace Type	Local Database
Workspace Factory	Sqlite
Geodatabase Release	3.0.0
Date Exported	2025-06-09 12:51:14
Path

Feature Datasets

Feature Classes

Tables

Relationship Classes

Utility Networks

Domains

Domain Name	Description	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
AnnotationStatus	Valid annotation state values.	Short Integer	Coded Value	Duplicate	Default Value	2	5
Asset_Manager	The manager of the asset	Short Integer	Coded Value	Duplicate	Default Value	4	59
Asset_Owner	The owner of the asset	Short Integer	Coded Value	Duplicate	Default Value	4	59
Asset_Type_Assembly_DHC_Fitting_Assembly	List of valid types of Town Border Stations	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Assembly_DHC_Station	List of valid types of Stations facilties	Short Integer	Coded Value	Duplicate	Default Value	9	1
Asset_Type_Assembly_DHC_Well_Pad	List of valid types of Well Pads	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Device_DHC_Anode	List of valid Asset Types for Cathodic Protection Anodes	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Device_DHC_Bypass	List of valid Asset Types for bypass devices	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Device_DHC_Chiller	List of valid Asset Types for Chilled Water Chiller units	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Device_DHC_Controllable_Valve	List of valid Asset Types for Controllable Valves	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Device_DHC_Filter	List of valid Asset Types for filtering devices	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Device_DHC_Flow_Valve	List of valid Asset Types for Flow Valves	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Device_DHC_Heat_Exchanger	List of valid Asset Types for Heat Exchangers	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Device_DHC_Leak_Detect_Panel	List of valid Asset Type for Leak Detection Panels	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Device_DHC_Leak_Detect_Test_Point	List of valid Asset Type for Leak Detection Test Point	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Device_DHC_Meter	List of valid Asset Types for Meters	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Device_DHC_Monitor	List of valid Asset Types for monitoring devices such as sensors	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Device_DHC_Pressure_Regulator	List of valid Asset Types for Pressure Regulators	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Device_DHC_Pressure_Valve	List of valid Asset Types for Pressure Valves	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Device_DHC_Production_Unit	List of valid Asset Types for Energy Plants	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Device_DHC_Pump	List of valid Asset Types for pumps	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Device_DHC_Rectifier	List of valid Asset Types for Cathodic Protection Rectifiers	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Device_DHC_Service_Connection	List of valid Asset Types for Service Connections	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Device_DHC_Tank	List of valid Asset Types for storage devices	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Device_DHC_Test_Point	List of valid Asset Types for Cthodic Protection Test Points	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Device_DHC_Trap	List of valid Asset Type for Traps	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Device_DHC_Well	List of valid Asset Types for wells	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Junction_DHC_Cooling_Chamber	List of valid values for Steam system cooling chambers	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Junction_DHC_Drip_Leg	List of valid values for Drip Leg	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Junction_DHC_Fitting	List of valid values for fittings	Short Integer	Coded Value	Duplicate	Default Value	21	1
Asset_Type_Junction_DHC_Insulation_Junction	List of valid values for CP Insulation Junctions	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Junction_DHC_Vent	List of valid values for Vents	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Junction_DHC_Wire_Junction	List of valid values for CP Wire Junctions	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Line_DHC_Bonding_Line	List of valid types of Cathodic Protection Bond Wires	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Line_DHC_Customer	List of Valid Types of Customer Piping	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Line_DHC_Distribution	List of Valid Types of Distribution Mains	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Line_DHC_Rectifier_Cable	List of valid types of Cathodic Protection Rectifier Cables	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Line_DHC_Sensing	List of valid types of Sensing Pipe	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Line_DHC_Service	List of Valid Types of Service Pipe	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Line_DHC_Station_Pipe	List of Valid Types of Station Pipes	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Line_DHC_Test_Lead_Wire	List of valid types of Cathodic Protection Test Lead Wires	Short Integer	Coded Value	Duplicate	Default Value	11	1
Asset_Type_Line_DHC_Transmission	List of Valid Types of Transmission Mains	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Pipeline_Structure_Boundary_Station_Structure	The Asset Types for the StructureBoundary's Asset Group Station Structure	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Pipeline_Structure_Boundary_Vault_Boundary	The Asset Types for the StructureBoundary's Asset Group Vault Boundary	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Pipeline_Structure_Junction_Anchor	The Asset Types for the StructureJunction's Asset Group Anchor	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Pipeline_Structure_Junction_Pipe_Hanger	The Asset Types for the StructureJunction's Asset Group Pipe Hanger	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Pipeline_Structure_Junction_Pipe_Support	The Asset Types for the StructureJunction's Asset Group Pipe Support	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Pipeline_Structure_Line_Casing	The Asset Types for the StructureLine's Asset Group Casing	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Structure_Boundary_DHC_Protection_Plate	List of valid types of Structure Boundaries of Protection Plates	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Boundary_Pipe_Customer_Building	List of valid types of Customer Buildings	Short Integer	Coded Value	Duplicate	Default Value	5	1
Asset_Type_Structure_Junction_DHC_Box	List of valid types of Box structures	Short Integer	Coded Value	Duplicate	Default Value	9	1
Asset_Type_Structure_Junction_DHC_Guide	List of valid types of Structure Junctions of Guides	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Junction_DHC_Pillar	List of valid types of Structure Junctions of Group Pillar	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Pipe_Access_Point	List of valid types of Manholes	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Line_DHC_Communication_Conduit	List of valid types of Structure Lines of Communication Conduit	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Line_DHC_Trench	List of valid types of Structure Lines of Trench	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Line_DHC_Tunnel	List of valid types of Structure Lines of Tunnels	Short Integer	Coded Value	Duplicate	Default Value	3	1
Bonded_Insulated	Values to indicate if a feature is bonded or insulated	Short Integer	Coded Value	Duplicate	Default Value	3	38
BooleanSymbolValue	Valid values are Yes and No.	Short Integer	Coded Value	Duplicate	Default Value	2	5
Construction_Status	Valid Construction statues for the assets.	Short Integer	Coded Value	Duplicate	Default Value	8	65
CP_Traceability	Valid cathodic protection status values	Short Integer	Coded Value	Duplicate	Default Value	3	76
DHC_Device_Angle_To_Close	Valid Range of degrees for closing the device	Double	Range	Geometry Ratio	Default Value		2
DHC_Device_Automation_Status	List of valid values for indicating the method by which the device is operated.	Short Integer	Coded Value	Duplicate	Default Value	3	8
DHC_Device_Bypass_Manufacturer	List of valid types of manufacturers of Bypass	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Bypass_Operation_Type	List of valid types of methods for operating the Controllable valve	Short Integer	Coded Value	Duplicate	Default Value	5	1
DHC_Device_Casing_Material	List of valid types of device casing materials	Short Integer	Coded Value	Duplicate	Default Value	5	12
DHC_Device_Chiller_Manufacturer	List of valid types of manufacturers of Chillers	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Connection_Type	List of valid types of end device connection	Short Integer	Coded Value	Duplicate	Default Value	8	11
DHC_Device_Control_Signal	List of valid types of methods for communicating with the device	Short Integer	Coded Value	Duplicate	Default Value	3	2
DHC_Device_CPAnode_Manufacturer	List of valid types of manufacturers of Cathodic Protection Anodes	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_CPRectifier_Manufacturer	List of valid types of manufacturers of Cathodic Protection Rectifiers	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_CPTestPoint_Manufacturer	List of valid types of manufacturers of Cathodic Protection Test Points	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_CValve_Manufacturer	List of valid types of manufacturers of Controllable Valves	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_CValve_Operation_Type	List of valid types of methods for operating the Controllable valve	Short Integer	Coded Value	Duplicate	Default Value	5	1
DHC_Device_Design_Type_Bypass	List of valid values of designs for bypass units	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Design_Type_Chiller	List of valid values of designs for chiller units	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Design_Type_CValve	List of valid types of controllable valves	Short Integer	Coded Value	Duplicate	Default Value	7	1
DHC_Device_Design_Type_Filter	List of valid values of designs for filter units	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Design_Type_HeatExchanger	List of valid values of designs for heat exchangers	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_Device_Design_Type_LDPanel	List of valid sub classification of Leak Detection Panels	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Design_Type_LDTPoint	List of valid sub classification of Leak Detection Test Points	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Design_Type_Meter	List of valid types of meters	Short Integer	Coded Value	Duplicate	Default Value	8	1
DHC_Device_Design_Type_Monitoring	List of valid sub classification of sensors	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Design_Type_PRegulator	List of valid types of pressure Regulators	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Design_Type_ProductionUnit	List of valid values for types of production unit design types	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_Device_Design_Type_Pump	List of valid types of pumps	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_Device_Design_Type_PValve	List of valid types of pressure valves	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_Device_Design_Type_Trap	List of valid types of steam traps	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Filter_Manufacturer	List of valid types of manufacturers of Filters	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_FValve_Manufacturer	List of valid types of manufacturers of Flow Valves	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_HExchanger_Manufacturer	List of valid types of manufacturers of Heat Exchangers	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Insulating_Material	List of valid device insulating materials	Short Integer	Coded Value	Duplicate	Default Value	11	13
DHC_Device_LDPanel_Manufacturer	List of valid types of manufacturers of Leak Detection Panels	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_LDTestPoint_Manufacturer	List of valid types of manufacturers of Leak Detection Test Points	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Meter_Manufacturer	List of valid types of manufacturers of Meters	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Meter_Operation_Type	List of valid types of operating classificaiton of meters	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Device_Monitoring_Manufacturer	List of valid types of manufacturers of Monitoring Sensors	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Monitoring_Operation_Type	List of valid types of methods for monitoring data acquisition	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Device_PReg_Operation_Type	List of valid types of methods for operating the pressure regulators	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_PRegulator_Manufacturer	List of valid types of manufacturers of Pressure Regulators	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_ProdUnit_Manufacturer	List of valid types of manufacturers of Production Units	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Pump_Manufacturer	List of valid types of manufacturers of pumps	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_PValve_Manufacturer	List of valid types of manufacturers of Pressure Valves	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_PValve_Operation_Type	List of valid types of methods for operating the pressure valve	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_Device_Rating_Heat_Exchanger	List of valid types of industry standard ratings for heat exchangers	String	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Tank_Location	List of valid types of locations for tanks	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Device_Tank_Manufacturer	List of valid types of manufacturers of tanks	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Tank_Material	List of valid types of materials for Tanks	Short Integer	Coded Value	Duplicate	Default Value	5	1
DHC_Device_Trap_Casing_Material	List of valid types of trap device casing materials	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_Device_Trap_Manufacturer	List of valid types of manufacturers of Traps	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Valve_Key_Type	List of valid types of valve key sizes and shapes	Short Integer	Coded Value	Duplicate	Default Value	7	1
DHC_Device_Well_Manufacturer	List of valid types of manufacturers of Well	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Device_Well_Material	List of valid types of well pipe materials	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_DeviceStatus	List of valid values for the Network Attribute Device Status	Short Integer	Coded Value	Duplicate	Default Value	3	16
DHC_Junction_Chamber_Ins_Material	List of valid insulating materials for cooling chamber	Short Integer	Coded Value	Duplicate	Default Value	9	1
DHC_Junction_Chamber_Manufacturer	List of valid types of manufacturers of cooling chambers	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Junction_Chamber_Material	List of valid types of materials for Steam Cooling Chambers	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_Junction_Drip_Leg_Insulating_Material	List of valid insulating materials for drip legs	Short Integer	Coded Value	Duplicate	Default Value	9	1
DHC_Junction_Drip_Leg_Material	List of valid types of pipe material for steam drip legs	Short Integer	Coded Value	Duplicate	Default Value	7	1
DHC_Junction_dripleg_Manufacturer	List of valid types of manufacturers of drip legs	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Junction_Fit_Ins_Material	List of valid fitting insulating materials	Short Integer	Coded Value	Duplicate	Default Value	11	1
DHC_Junction_Fitting_Manufacturer	List of valid types of manufacturers of fittings	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Junction_Fitting_Material	List of valid types of materials for Fittings	Short Integer	Coded Value	Duplicate	Default Value	10	1
DHC_Junction_Vent_Ins_Material	List of valid types of insulating materials for vents	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Junction_Vent_Manufacturer	List of valid types of manufacturers of vents	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Junction_Vent_Material	List of valid types of materials for vents	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_LengthSource	List of valid types of sources for measured length	Short Integer	Coded Value	Duplicate	Default Value	10	10
DHC_MeasuredLength	Valid Range of values for pipe lengths	Double	Range	Geometry Ratio	Default Value		9
DHC_Pipe_Casing_Diameter_Metric	List of valid pipe casing nominal diameter. Metric unit millimeter	Double	Coded Value	Duplicate	Default Value	33	9
DHC_Pipe_Casing_Material	List of valid pipe casing materials	Short Integer	Coded Value	Duplicate	Default Value	5	6
DHC_Pipe_Commodity	List of valid pipe fluid of gas flowing thru the pipe	Short Integer	Coded Value	Duplicate	Default Value	5	28
DHC_Pipe_Diameter_Metric	List of valid pipe nominal diameter. Metric unit millimeter	Double	Coded Value	Duplicate	Default Value	40	32
DHC_Pipe_Install_Location	List of valid pipe installation locations	Short Integer	Coded Value	Duplicate	Default Value	6	6
DHC_Pipe_Install_Method	List of valid pipe installation methods	Short Integer	Coded Value	Duplicate	Default Value	4	6
DHC_Pipe_Insulating_Material	List of valid pipe insulating materials for services	Short Integer	Coded Value	Duplicate	Default Value	11	6
DHC_Pipe_Material	List of valid pipe materials	Short Integer	Coded Value	Duplicate	Default Value	18	6
DHC_Pipe_Material_Grade	List of valid pipe material grades	Short Integer	Coded Value	Duplicate	Default Value	39	6
DHC_Pipe_Material_Std	List of valid pipe material industry standards	Short Integer	Coded Value	Duplicate	Default Value	11	6
DHC_Pipe_Pipe_Manufacturer	List of valid types of pipe manufacturers	Short Integer	Coded Value	Duplicate	Default Value	3	6
DHC_Pipe_Rect_Cable_Manu	List of valid types of rectifier cable manufacturers	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_Pipe_Test_Lead_Wire_Manu	List of valid types of test lead wire manufacturers	Short Integer	Coded Value	Duplicate	Default Value	1	1
DHC_PressureRange_Imperial	Valid Range of values for Imperial pipe pressures	Double	Range	Geometry Ratio	Default Value		0
DHC_PressureRange_Metric	Valid Range of values for metric pipe pressures	Double	Range	Geometry Ratio	Default Value		12
DHC_SpatialAccuracy	Assessment of the spatial accuracy of the XY coordinates	Short Integer	Coded Value	Duplicate	Default Value	11	112
DHC_Sructure_Line_InstallMethod	List of valid method for installing pipe casings and conduit	Short Integer	Coded Value	Duplicate	Default Value	3	3
DHC_Str_Bndry_facilitytype_Station_Structure	Valid list of types of facilities used for Station structures	Short Integer	Coded Value	Duplicate	Default Value	14	1
DHC_Structure_Boundary_Material_Pipe_Customer_Building	Valid list of types of material used for Station structures	Short Integer	Coded Value	Duplicate	Default Value	6	1
DHC_Structure_Boundary_Material_Pipe_Station_Structure	Valid list of types of material used for Station structures	Short Integer	Coded Value	Duplicate	Default Value	6	1
DHC_Structure_Boundary_Material_Pipe_Vault	Valid list of types of material used for Station structures	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_Structure_Boundary_Material_Protection_Plate	Valid list of types of material used for access box structures	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_CoverMaterial_Access_Box	Valid list of types of material used for pipe access box covers	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_CoverMaterial_Access_Point	Valid list of types of material used for pipe access point covers	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_CoverShape_Access_Box	Valid list of types of shapes used for access box covers	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_CoverShape_Access_Point	Valid list of types of shapes used for access point covers	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_LadderType_Access_Point	Valid list of types of ladders used for pipe access points	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_Material_Access_Box	Valid list of types of material used for access box structures	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_Material_Access_Point	Valid list of types of material used for access point structures	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_Material_Anchor	Valid list of types of material used for anchors	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_Material_Guide	Valid list of types of material used for pipe guides	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_Material_Hanger	Valid list of types of material used for pipe hangers	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_Material_Pillar	Valid list of types of material used for pipe pillars	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Junction_Material_Support	Valid list of types of material used for pipe supports	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Line_Material_CommConduit	List of valid material types of a communication conduit	Short Integer	Coded Value	Duplicate	Default Value	3	1
DHC_Structure_Line_Material_Pipe_Casing	List of valid material types of a tunnel	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_Structure_Line_Material_Tunnel	List of valid material types of a tunnel	Short Integer	Coded Value	Duplicate	Default Value	4	1
DHC_TemperatureRange	Valid Range of values for pipe temperature	Double	Range	Geometry Ratio	Default Value		12
DHC_UnitsForDepth	List of valid units of measure for pipe depth below ground surface	Short Integer	Coded Value	Duplicate	Default Value	5	20
DHC_UnitsForDiameter	List of valid units of measure for pipe diameter	Short Integer	Coded Value	Duplicate	Default Value	5	42
DHC_UnitsForFlow	List of valid units of measure of the volumetric flow	Short Integer	Coded Value	Duplicate	Default Value	5	1
DHC_UnitsForLength	List of valid types of measures of length	Short Integer	Coded Value	Duplicate	Default Value	5	41
DHC_UnitsForPressure	List of valid units of measure of pressure	Short Integer	Coded Value	Duplicate	Default Value	5	6
DHC_UnitsForSurfaceArea	List of valid units of measure of surface area	Short Integer	Coded Value	Duplicate	Default Value	5	6
DHC_UnitsForTemperature	List of valid units of measure of heat	Short Integer	Coded Value	Duplicate	Default Value	3	10
DHC_UnitsForVolume	List of valid units of measure of pipe volume	Short Integer	Coded Value	Duplicate	Default Value	5	8
DHC_ValvePosition	Boolean value to determine whether the valve is open or closed.	Short Integer	Coded Value	Duplicate	Default Value	2	14
HorizontalAlignment	Valid horizontal symbol alignment values.	Short Integer	Coded Value	Duplicate	Default Value	4	5
LD_Traceability	Boolean to determine whether the asset is leak detection traceable	Short Integer	Coded Value	Duplicate	Default Value	3	40
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	54
Network_6_AssociationStatus	Indicates how the feature participates in associations.	Short Integer	Coded Value	Duplicate	Default Value	36	76
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	21
Network_6_IsConnected	Indicates if the feature is connected to a subnetwork controller.	Short Integer	Coded Value	Duplicate	Default Value	3	46
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	7
Network_6_IsSubnetworkController	Indicates if a device feature is a subnetwork controller.	Short Integer	Coded Value	Default Value	Default Value	2	25
Network_6_TerminalNames	The terminal names in the utility network.	Short Integer	Coded Value	Duplicate	Default Value	25	22
Network_6_TierName	The tier names in the utility network.	Short Integer	Coded Value	Default Value	Default Value	6	25
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
Spatial_Source	Source of the spatial location	Short Integer	Coded Value	Duplicate	Default Value	6	56
VerticalAlignment	Valid symbol vertical alignment values.	Short Integer	Coded Value	Duplicate	Default Value	4	5
Yes_No	Boolean value for fields with a Yes or No input.	Short Integer	Coded Value	Duplicate	Default Value	3	26

Datasets

Key	Value
Name	main.additionaltext
Dataset Type	FeatureClass
Dataset ID	239
Geometry Type	Polygon
Feature Type	Annotation
Z-Aware	False
M-Aware	False
Split Model	Update Insert
Minimum Client Version	12.1
Alias	Additional Text
OID Field	OBJECTID
Subtype Field	AnnotationClassID
Default Subtype	Class 1
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	RD_New
X-Min	89998.91490000114
X-Max	90005.3647999987
Y-Min	436052.10339999944
Y-Max	436055.23220000044
Catalog ID	{7FDDD9E4-243B-48E1-882C-CA2D8BF7A6B1}
Class ID	{3FF1675E-4FFB-4D9B-9438-767CE04DE34A}
Extension Class ID	{F245DFEB-851B-4981-9860-4BACC8C0A688}

Key	Value
CIMVersion	2.7.0
Build	26828
Version	1
MaxLabelClassID	3
MaxSymbolID	3
AllowSymbolOverrides	-1
RequireSymbolID	0
AutoCreate	-1
UpdateOnShapeChange	-1
ReferenceScale	200
ReferenceScaleUnit	{ "uwkid": 9001 }
SymbolCollection	[ { "type": "CIMSymbolIdentifier", "name": "Class 1", "symbol": { "type": "CIMTextSymbol", "blockProgression": "TTB", "depth3D": 1, "extrapolateBaselines": true, "fontEffects": "Normal", "fontEncoding": "Unicode", "fontFamilyName": "Arial", "fontStyleName": "Regular", "fontType": "TTOpenType", "haloSize": 1, "height": 10, "hinting": "Default", "horizontalAlignment": "Left", "kerning": true, "letterWidth": 100, "ligatures": true, "lineGapType": "ExtraLeading", "symbol": { "type": "CIMPolygonSymbol", "symbolLayers": [ { "type": "CIMSolidFill", "enable": true, "color": { "type": "CIMRGBColor", "values": [ 0, 0, 0, 100 ] } } ] }, "symbol3DProperties": { "type": "CIM3DSymbolProperties", "dominantSizeAxis3D": "Z", "rotationOrder3D": "YXZ", "scaleZ": 1, "scaleY": 1 }, "textCase": "Normal", "textDirection": "LTR", "verticalAlignment": "Bottom", "verticalGlyphOrientation": "Right", "wordSpacing": 100, "billboardMode3D": "FaceNearPlane" } }, { "type": "CIMSymbolIdentifier", "iD": 1, "name": "Steam Text", "symbol": { "type": "CIMTextSymbol", "blockProgression": "TTB", "depth3D": 1, "extrapolateBaselines": true, "fontEffects": "Normal", "fontEncoding": "Unicode", "fontFamilyName": "Arial", "fontStyleName": "Regular", "fontType": "TTOpenType", "haloSize": 1, "height": 10, "hinting": "Default", "horizontalAlignment": "Left", "kerning": true, "letterWidth": 100, "ligatures": true, "lineGapType": "ExtraLeading", "symbol": { "type": "CIMPolygonSymbol", "symbolLayers": [ { "type": "CIMSolidFill", "enable": true, "color": { "type": "CIMRGBColor", "values": [ 168, 0, 0, 100 ] } } ] }, "symbol3DProperties": { "type": "CIM3DSymbolProperties", "dominantSizeAxis3D": "Z", "rotationOrder3D": "YXZ", "scaleZ": 1, "scaleY": 1 }, "textCase": "Normal", "textDirection": "LTR", "verticalAlignment": "Bottom", "verticalGlyphOrientation": "Right", "wordSpacing": 100, "billboardMode3D": "FaceNearPlane" } }, { "type": "CIMSymbolIdentifier", "iD": 2, "name": "Chilled Water Text", "symbol": { "type": "CIMTextSymbol", "blockProgression": "TTB", "depth3D": 1, "extrapolateBaselines": true, "fontEffects": "Normal", "fontEncoding": "Unicode", "fontFamilyName": "Arial", "fontStyleName": "Regular", "fontType": "TTOpenType", "haloSize": 1, "height": 10, "hinting": "Default", "horizontalAlignment": "Left", "kerning": true, "letterWidth": 100, "ligatures": true, "lineGapType": "ExtraLeading", "symbol": { "type": "CIMPolygonSymbol", "symbolLayers": [ { "type": "CIMSolidFill", "enable": true, "color": { "type": "CIMRGBColor", "values": [ 0, 112, 255, 100 ] } } ] }, "symbol3DProperties": { "type": "CIM3DSymbolProperties", "dominantSizeAxis3D": "Z", "rotationOrder3D": "YXZ", "scaleZ": 1, "scaleY": 1 }, "textCase": "Normal", "textDirection": "LTR", "verticalAlignment": "Bottom", "verticalGlyphOrientation": "Right", "wordSpacing": 100, "billboardMode3D": "FaceNearPlane" } }, { "type": "CIMSymbolIdentifier", "iD": 3, "name": "Heated Water Text", "symbol": { "type": "CIMTextSymbol", "blockProgression": "TTB", "depth3D": 1, "extrapolateBaselines": true, "fontEffects": "Normal", "fontEncoding": "Unicode", "fontFamilyName": "Arial", "fontStyleName": "Regular", "fontType": "TTOpenType", "haloSize": 1, "height": 10, "hinting": "Default", "horizontalAlignment": "Left", "kerning": true, "letterWidth": 100, "ligatures": true, "lineGapType": "ExtraLeading", "symbol": { "type": "CIMPolygonSymbol", "symbolLayers": [ { "type": "CIMSolidFill", "enable": true, "color": { "type": "CIMRGBColor", "values": [ 230, 0, 0, 100 ] } } ] }, "symbol3DProperties": { "type": "CIM3DSymbolProperties", "dominantSizeAxis3D": "Z", "rotationOrder3D": "YXZ", "scaleZ": 1, "scaleY": 1 }, "textCase": "Normal", "textDirection": "LTR", "verticalAlignment": "Bottom", "verticalGlyphOrientation": "Right", "wordSpacing": 100, "billboardMode3D": "FaceNearPlane" } } ]
LabelClassCollection	[ { "type": "CIMLabelClass", "expressionEngine": "Arcade", "featuresToLabel": "AllVisibleFeatures", "maplexLabelPlacementProperties": { "type": "CIMMaplexLabelPlacementProperties", "featureType": "Polygon", "avoidPolygonHoles": true, "canOverrunFeature": true, "canPlaceLabelOutsidePolygon": true, "canRemoveOverlappingLabel": true, "canStackLabel": true, "connectionType": "Unambiguous", "constrainOffset": "NoConstraint", "contourAlignmentType": "Page", "contourLadderType": "Straight", "contourMaximumAngle": 90, "enableConnection": true, "featureWeight": 0, "fontHeightReductionLimit": 4, "fontHeightReductionStep": 0.5, "fontWidthReductionLimit": 90, "fontWidthReductionStep": 5, "graticuleAlignmentType": "Straight", "keyNumberGroupName": "Default", "labelBuffer": 15, "labelLargestPolygon": true, "labelPriority": -1, "labelStackingProperties": { "type": "CIMMaplexLabelStackingProperties", "stackAlignment": "ChooseBest", "maximumNumberOfLines": 3, "minimumNumberOfCharsPerLine": 3, "maximumNumberOfCharsPerLine": 24, "separators": [ { "type": "CIMMaplexStackingSeparator", "separator": " ", "splitAfter": true }, { "type": "CIMMaplexStackingSeparator", "separator": ",", "visible": true, "splitAfter": true } ] }, "lineFeatureType": "General", "linePlacementMethod": "OffsetCurvedFromLine", "maximumLabelOverrun": 80, "maximumLabelOverrunUnit": "Point", "minimumFeatureSizeUnit": "Map", "multiPartOption": "OneLabelPerPart", "offsetAlongLineProperties": { "type": "CIMMaplexOffsetAlongLineProperties", "placementMethod": "BestPositionAlongLine", "labelAnchorPoint": "CenterOfLabel", "distanceUnit": "Percentage", "useLineDirection": true }, "pointExternalZonePriorities": { "type": "CIMMaplexExternalZonePriorities", "aboveLeft": 4, "aboveCenter": 2, "aboveRight": 1, "centerRight": 3, "belowRight": 5, "belowCenter": 7, "belowLeft": 8, "centerLeft": 6 }, "pointPlacementMethod": "AroundPoint", "polygonAnchorPointType": "GeometricCenter", "polygonBoundaryWeight": 0, "polygonExternalZones": { "type": "CIMMaplexExternalZonePriorities", "aboveLeft": 4, "aboveCenter": 2, "aboveRight": 1, "centerRight": 3, "belowRight": 5, "belowCenter": 7, "belowLeft": 8, "centerLeft": 6 }, "polygonFeatureType": "General", "polygonInternalZones": { "type": "CIMMaplexInternalZonePriorities", "center": 1 }, "polygonPlacementMethod": "HorizontalInPolygon", "primaryOffset": 1, "primaryOffsetUnit": "Point", "removeExtraWhiteSpace": true, "repetitionIntervalUnit": "Point", "rotationProperties": { "type": "CIMMaplexRotationProperties", "rotationType": "Arithmetic", "alignmentType": "Straight" }, "secondaryOffset": 100, "strategyPriorities": { "type": "CIMMaplexStrategyPriorities", "stacking": 1, "overrun": 2, "fontCompression": 3, "fontReduction": 4, "abbreviation": 5 }, "thinningDistanceUnit": "Point", "truncationMarkerCharacter": ".", "truncationMinimumLength": 1, "truncationPreferredCharacters": "aeiou", "truncationExcludedCharacters": "0123456789", "polygonAnchorPointPerimeterInsetUnit": "Point" }, "minimumScale": 1000, "name": "Class 1", "priority": -1, "textSymbol": { "type": "CIMSymbolReference", "symbol": { "type": "CIMTextSymbol", "blockProgression": "TTB", "depth3D": 1, "extrapolateBaselines": true, "fontEffects": "Normal", "fontEncoding": "Unicode", "fontFamilyName": "Arial", "fontStyleName": "Regular", "fontType": "TTOpenType", "haloSize": 1, "height": 10, "hinting": "Default", "horizontalAlignment": "Left", "kerning": true, "letterWidth": 100, "ligatures": true, "lineGapType": "ExtraLeading", "symbol": { "type": "CIMPolygonSymbol", "symbolLayers": [ { "type": "CIMSolidFill", "enable": true, "color": { "type": "CIMRGBColor", "values": [ 0, 0, 0, 100 ] } } ] }, "symbol3DProperties": { "type": "CIM3DSymbolProperties", "dominantSizeAxis3D": "Z", "rotationOrder3D": "YXZ", "scaleZ": 1, "scaleY": 1 }, "textCase": "Normal", "textDirection": "LTR", "verticalAlignment": "Bottom", "verticalGlyphOrientation": "Right", "wordSpacing": 100, "billboardMode3D": "FaceNearPlane" }, "symbolName": "0" }, "useCodedValue": true, "visibility": true, "iD": 0 }, { "type": "CIMLabelClass", "expressionEngine": "Arcade", "featuresToLabel": "AllVisibleFeatures", "maplexLabelPlacementProperties": { "type": "CIMMaplexLabelPlacementProperties", "featureType": "Polygon", "avoidPolygonHoles": true, "canOverrunFeature": true, "canPlaceLabelOutsidePolygon": true, "canRemoveOverlappingLabel": true, "canStackLabel": true, "connectionType": "Unambiguous", "constrainOffset": "NoConstraint", "contourAlignmentType": "Page", "contourLadderType": "Straight", "contourMaximumAngle": 90, "enableConnection": true, "featureWeight": 0, "fontHeightReductionLimit": 4, "fontHeightReductionStep": 0.5, "fontWidthReductionLimit": 90, "fontWidthReductionStep": 5, "graticuleAlignmentType": "Straight", "keyNumberGroupName": "Default", "labelBuffer": 15, "labelLargestPolygon": true, "labelPriority": -1, "labelStackingProperties": { "type": "CIMMaplexLabelStackingProperties", "stackAlignment": "ChooseBest", "maximumNumberOfLines": 3, "minimumNumberOfCharsPerLine": 3, "maximumNumberOfCharsPerLine": 24, "separators": [ { "type": "CIMMaplexStackingSeparator", "separator": " ", "splitAfter": true }, { "type": "CIMMaplexStackingSeparator", "separator": ",", "visible": true, "splitAfter": true } ] }, "lineFeatureType": "General", "linePlacementMethod": "OffsetCurvedFromLine", "maximumLabelOverrun": 80, "maximumLabelOverrunUnit": "Point", "minimumFeatureSizeUnit": "Map", "multiPartOption": "OneLabelPerPart", "offsetAlongLineProperties": { "type": "CIMMaplexOffsetAlongLineProperties", "placementMethod": "BestPositionAlongLine", "labelAnchorPoint": "CenterOfLabel", "distanceUnit": "Percentage", "useLineDirection": true }, "pointExternalZonePriorities": { "type": "CIMMaplexExternalZonePriorities", "aboveLeft": 4, "aboveCenter": 2, "aboveRight": 1, "centerRight": 3, "belowRight": 5, "belowCenter": 7, "belowLeft": 8, "centerLeft": 6 }, "pointPlacementMethod": "AroundPoint", "polygonAnchorPointType": "GeometricCenter", "polygonBoundaryWeight": 0, "polygonExternalZones": { "type": "CIMMaplexExternalZonePriorities", "aboveLeft": 4, "aboveCenter": 2, "aboveRight": 1, "centerRight": 3, "belowRight": 5, "belowCenter": 7, "belowLeft": 8, "centerLeft": 6 }, "polygonFeatureType": "General", "polygonInternalZones": { "type": "CIMMaplexInternalZonePriorities", "center": 1 }, "polygonPlacementMethod": "HorizontalInPolygon", "primaryOffset": 1, "primaryOffsetUnit": "Point", "removeExtraWhiteSpace": true, "repetitionIntervalUnit": "Point", "rotationProperties": { "type": "CIMMaplexRotationProperties", "rotationType": "Arithmetic", "alignmentType": "Straight" }, "secondaryOffset": 100, "strategyPriorities": { "type": "CIMMaplexStrategyPriorities", "stacking": 1, "overrun": 2, "fontCompression": 3, "fontReduction": 4, "abbreviation": 5 }, "thinningDistanceUnit": "Point", "truncationMarkerCharacter": ".", "truncationMinimumLength": 1, "truncationPreferredCharacters": "aeiou", "truncationExcludedCharacters": "0123456789", "polygonAnchorPointPerimeterInsetUnit": "Point" }, "minimumScale": 1000, "name": "Steam Text", "priority": -1, "textSymbol": { "type": "CIMSymbolReference", "symbol": { "type": "CIMTextSymbol", "blockProgression": "TTB", "depth3D": 1, "extrapolateBaselines": true, "fontEffects": "Normal", "fontEncoding": "Unicode", "fontFamilyName": "Arial", "fontStyleName": "Regular", "fontType": "TTOpenType", "haloSize": 1, "height": 10, "hinting": "Default", "horizontalAlignment": "Left", "kerning": true, "letterWidth": 100, "ligatures": true, "lineGapType": "ExtraLeading", "symbol": { "type": "CIMPolygonSymbol", "symbolLayers": [ { "type": "CIMSolidFill", "enable": true, "color": { "type": "CIMRGBColor", "values": [ 168, 0, 0, 100 ] } } ] }, "symbol3DProperties": { "type": "CIM3DSymbolProperties", "dominantSizeAxis3D": "Z", "rotationOrder3D": "YXZ", "scaleZ": 1, "scaleY": 1 }, "textCase": "Normal", "textDirection": "LTR", "verticalAlignment": "Bottom", "verticalGlyphOrientation": "Right", "wordSpacing": 100, "billboardMode3D": "FaceNearPlane" }, "symbolName": "1" }, "useCodedValue": true, "visibility": true, "iD": 1 }, { "type": "CIMLabelClass", "expressionEngine": "Arcade", "featuresToLabel": "AllVisibleFeatures", "maplexLabelPlacementProperties": { "type": "CIMMaplexLabelPlacementProperties", "featureType": "Polygon", "avoidPolygonHoles": true, "canOverrunFeature": true, "canPlaceLabelOutsidePolygon": true, "canRemoveOverlappingLabel": true, "canStackLabel": true, "connectionType": "Unambiguous", "constrainOffset": "NoConstraint", "contourAlignmentType": "Page", "contourLadderType": "Straight", "contourMaximumAngle": 90, "enableConnection": true, "featureWeight": 0, "fontHeightReductionLimit": 4, "fontHeightReductionStep": 0.5, "fontWidthReductionLimit": 90, "fontWidthReductionStep": 5, "graticuleAlignmentType": "Straight", "keyNumberGroupName": "Default", "labelBuffer": 15, "labelLargestPolygon": true, "labelPriority": -1, "labelStackingProperties": { "type": "CIMMaplexLabelStackingProperties", "stackAlignment": "ChooseBest", "maximumNumberOfLines": 3, "minimumNumberOfCharsPerLine": 3, "maximumNumberOfCharsPerLine": 24, "separators": [ { "type": "CIMMaplexStackingSeparator", "separator": " ", "splitAfter": true }, { "type": "CIMMaplexStackingSeparator", "separator": ",", "visible": true, "splitAfter": true } ] }, "lineFeatureType": "General", "linePlacementMethod": "OffsetCurvedFromLine", "maximumLabelOverrun": 80, "maximumLabelOverrunUnit": "Point", "minimumFeatureSizeUnit": "Map", "multiPartOption": "OneLabelPerPart", "offsetAlongLineProperties": { "type": "CIMMaplexOffsetAlongLineProperties", "placementMethod": "BestPositionAlongLine", "labelAnchorPoint": "CenterOfLabel", "distanceUnit": "Percentage", "useLineDirection": true }, "pointExternalZonePriorities": { "type": "CIMMaplexExternalZonePriorities", "aboveLeft": 4, "aboveCenter": 2, "aboveRight": 1, "centerRight": 3, "belowRight": 5, "belowCenter": 7, "belowLeft": 8, "centerLeft": 6 }, "pointPlacementMethod": "AroundPoint", "polygonAnchorPointType": "GeometricCenter", "polygonBoundaryWeight": 0, "polygonExternalZones": { "type": "CIMMaplexExternalZonePriorities", "aboveLeft": 4, "aboveCenter": 2, "aboveRight": 1, "centerRight": 3, "belowRight": 5, "belowCenter": 7, "belowLeft": 8, "centerLeft": 6 }, "polygonFeatureType": "General", "polygonInternalZones": { "type": "CIMMaplexInternalZonePriorities", "center": 1 }, "polygonPlacementMethod": "HorizontalInPolygon", "primaryOffset": 1, "primaryOffsetUnit": "Point", "removeExtraWhiteSpace": true, "repetitionIntervalUnit": "Point", "rotationProperties": { "type": "CIMMaplexRotationProperties", "rotationType": "Arithmetic", "alignmentType": "Straight" }, "secondaryOffset": 100, "strategyPriorities": { "type": "CIMMaplexStrategyPriorities", "stacking": 1, "overrun": 2, "fontCompression": 3, "fontReduction": 4, "abbreviation": 5 }, "thinningDistanceUnit": "Point", "truncationMarkerCharacter": ".", "truncationMinimumLength": 1, "truncationPreferredCharacters": "aeiou", "truncationExcludedCharacters": "0123456789", "polygonAnchorPointPerimeterInsetUnit": "Point" }, "minimumScale": 1000, "name": "Chilled Water Text", "priority": -1, "textSymbol": { "type": "CIMSymbolReference", "symbol": { "type": "CIMTextSymbol", "blockProgression": "TTB", "depth3D": 1, "extrapolateBaselines": true, "fontEffects": "Normal", "fontEncoding": "Unicode", "fontFamilyName": "Arial", "fontStyleName": "Regular", "fontType": "TTOpenType", "haloSize": 1, "height": 10, "hinting": "Default", "horizontalAlignment": "Left", "kerning": true, "letterWidth": 100, "ligatures": true, "lineGapType": "ExtraLeading", "symbol": { "type": "CIMPolygonSymbol", "symbolLayers": [ { "type": "CIMSolidFill", "enable": true, "color": { "type": "CIMRGBColor", "values": [ 0, 112, 255, 100 ] } } ] }, "symbol3DProperties": { "type": "CIM3DSymbolProperties", "dominantSizeAxis3D": "Z", "rotationOrder3D": "YXZ", "scaleZ": 1, "scaleY": 1 }, "textCase": "Normal", "textDirection": "LTR", "verticalAlignment": "Bottom", "verticalGlyphOrientation": "Right", "wordSpacing": 100, "billboardMode3D": "FaceNearPlane" }, "symbolName": "2" }, "useCodedValue": true, "visibility": true, "iD": 2 }, { "type": "CIMLabelClass", "expressionEngine": "Arcade", "featuresToLabel": "AllVisibleFeatures", "maplexLabelPlacementProperties": { "type": "CIMMaplexLabelPlacementProperties", "featureType": "Polygon", "avoidPolygonHoles": true, "canOverrunFeature": true, "canPlaceLabelOutsidePolygon": true, "canRemoveOverlappingLabel": true, "canStackLabel": true, "connectionType": "Unambiguous", "constrainOffset": "NoConstraint", "contourAlignmentType": "Page", "contourLadderType": "Straight", "contourMaximumAngle": 90, "enableConnection": true, "featureWeight": 0, "fontHeightReductionLimit": 4, "fontHeightReductionStep": 0.5, "fontWidthReductionLimit": 90, "fontWidthReductionStep": 5, "graticuleAlignmentType": "Straight", "keyNumberGroupName": "Default", "labelBuffer": 15, "labelLargestPolygon": true, "labelPriority": -1, "labelStackingProperties": { "type": "CIMMaplexLabelStackingProperties", "stackAlignment": "ChooseBest", "maximumNumberOfLines": 3, "minimumNumberOfCharsPerLine": 3, "maximumNumberOfCharsPerLine": 24, "separators": [ { "type": "CIMMaplexStackingSeparator", "separator": " ", "splitAfter": true }, { "type": "CIMMaplexStackingSeparator", "separator": ",", "visible": true, "splitAfter": true } ] }, "lineFeatureType": "General", "linePlacementMethod": "OffsetCurvedFromLine", "maximumLabelOverrun": 80, "maximumLabelOverrunUnit": "Point", "minimumFeatureSizeUnit": "Map", "multiPartOption": "OneLabelPerPart", "offsetAlongLineProperties": { "type": "CIMMaplexOffsetAlongLineProperties", "placementMethod": "BestPositionAlongLine", "labelAnchorPoint": "CenterOfLabel", "distanceUnit": "Percentage", "useLineDirection": true }, "pointExternalZonePriorities": { "type": "CIMMaplexExternalZonePriorities", "aboveLeft": 4, "aboveCenter": 2, "aboveRight": 1, "centerRight": 3, "belowRight": 5, "belowCenter": 7, "belowLeft": 8, "centerLeft": 6 }, "pointPlacementMethod": "AroundPoint", "polygonAnchorPointType": "GeometricCenter", "polygonBoundaryWeight": 0, "polygonExternalZones": { "type": "CIMMaplexExternalZonePriorities", "aboveLeft": 4, "aboveCenter": 2, "aboveRight": 1, "centerRight": 3, "belowRight": 5, "belowCenter": 7, "belowLeft": 8, "centerLeft": 6 }, "polygonFeatureType": "General", "polygonInternalZones": { "type": "CIMMaplexInternalZonePriorities", "center": 1 }, "polygonPlacementMethod": "HorizontalInPolygon", "primaryOffset": 1, "primaryOffsetUnit": "Point", "removeExtraWhiteSpace": true, "repetitionIntervalUnit": "Point", "rotationProperties": { "type": "CIMMaplexRotationProperties", "rotationType": "Arithmetic", "alignmentType": "Straight" }, "secondaryOffset": 100, "strategyPriorities": { "type": "CIMMaplexStrategyPriorities", "stacking": 1, "overrun": 2, "fontCompression": 3, "fontReduction": 4, "abbreviation": 5 }, "thinningDistanceUnit": "Point", "truncationMarkerCharacter": ".", "truncationMinimumLength": 1, "truncationPreferredCharacters": "aeiou", "truncationExcludedCharacters": "0123456789", "polygonAnchorPointPerimeterInsetUnit": "Point" }, "name": "Heated Water Text", "priority": -1, "textSymbol": { "type": "CIMSymbolReference", "symbol": { "type": "CIMTextSymbol", "blockProgression": "TTB", "depth3D": 1, "extrapolateBaselines": true, "fontEffects": "Normal", "fontEncoding": "Unicode", "fontFamilyName": "Arial", "fontStyleName": "Regular", "fontType": "TTOpenType", "haloSize": 1, "height": 10, "hinting": "Default", "horizontalAlignment": "Left", "kerning": true, "letterWidth": 100, "ligatures": true, "lineGapType": "ExtraLeading", "symbol": { "type": "CIMPolygonSymbol", "symbolLayers": [ { "type": "CIMSolidFill", "enable": true, "color": { "type": "CIMRGBColor", "values": [ 230, 0, 0, 100 ] } } ] }, "symbol3DProperties": { "type": "CIM3DSymbolProperties", "dominantSizeAxis3D": "Z", "rotationOrder3D": "YXZ", "scaleZ": 1, "scaleY": 1 }, "textCase": "Normal", "textDirection": "LTR", "verticalAlignment": "Bottom", "verticalGlyphOrientation": "Right", "wordSpacing": 100, "billboardMode3D": "FaceNearPlane" }, "symbolName": "3" }, "useCodedValue": true, "visibility": true, "iD": 3 } ]
GeneralPlacementProperties	{ "type": "CIMMaplexGeneralPlacementProperties", "invertedLabelTolerance": 2, "rotateLabelWithDisplay": true, "unplacedLabelColor": { "type": "CIMRGBColor", "values": [ 255, 0, 0, 100 ] }, "allowBorderOverlap": true, "keyNumberGroups": [ { "type": "CIMMaplexKeyNumberGroup", "delimiterCharacter": ".", "horizontalAlignment": "Left", "maximumNumberOfLines": 20, "minimumNumberOfLines": 2, "name": "Default", "numberResetType": "None", "keyNumberMethod": "PreventUnplacedLabels" } ], "placementQuality": "High" }

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	OBJECTID	OID	Index	False			4	False	True
featureid	FeatureID	Long Integer		True			4	True	True
zorder	ZOrder	Long Integer		True			4	True	True
annotationclassid	AnnotationClassID	Long Integer	Subtype	True		0	4	True	True
element	Element	Blob		True			0	True	True
symbolid	SymbolID	Long Integer		True			4	True	True
status	Status	Short Integer		True	AnnotationStatus		2	True	True
textstring	TextString	String		True			255	True	False
fontname	FontName	String		True			255	True	False
fontstyle	FontStyle	String		True			255	True	False
fontsize	FontSize	Double		True			8	True	False
underline	Underline	Short Integer		True	BooleanSymbolValue		2	True	False
verticalalignment	VerticalAlignment	Short Integer		True	VerticalAlignment		2	True	False
horizontalalignment	HorizontalAlignment	Short Integer		True	HorizontalAlignment		2	True	False
xoffset	XOffset	Double		True			8	True	False
yoffset	YOffset	Double		True			8	True	False
angle	Angle	Double		True			8	True	False
fontleading	FontLeading	Double		True			8	True	False
wordspacing	WordSpacing	Double		True			8	True	False
characterwidth	CharacterWidth	Double		True			8	True	False
characterspacing	CharacterSpacing	Double		True			8	True	False
flipangle	FlipAngle	Double		True			8	True	False
override	Override	Long Integer		True			4	False	False
created_user	created_user	String	Creator	True			255	False	False
created_date	created_date	Date	Created	True			8	False	False
last_edited_user	last_edited_user	String	Editor	True			255	False	False
last_edited_date	last_edited_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

Name	Is Unique	Is Ascending	Field Name
FDO_OBJECTID	True	True	OBJECTID
st_spindex__additionaltext_shape	True	True	shape

Name	Code	Details
Class 1	0
Steam Text	1
Chilled Water Text	2
Heated Water Text	3

Subtype Name	Subtype Code	Field Name	Domain Name
Class 1	0	horizontalalignment	HorizontalAlignment
Class 1	0	status	AnnotationStatus
Class 1	0	underline	BooleanSymbolValue
Class 1	0	verticalalignment	VerticalAlignment
Steam Text	1	horizontalalignment	HorizontalAlignment
Steam Text	1	status	AnnotationStatus
Steam Text	1	underline	BooleanSymbolValue
Steam Text	1	verticalalignment	VerticalAlignment
Chilled Water Text	2	horizontalalignment	HorizontalAlignment
Chilled Water Text	2	status	AnnotationStatus
Chilled Water Text	2	underline	BooleanSymbolValue
Chilled Water Text	2	verticalalignment	VerticalAlignment
Heated Water Text	3	horizontalalignment	HorizontalAlignment
Heated Water Text	3	status	AnnotationStatus
Heated Water Text	3	underline	BooleanSymbolValue
Heated Water Text	3	verticalalignment	VerticalAlignment

Key	Value
Name	main.DHC_ProtectionZone
Dataset Type	FeatureClass
Dataset ID	237
Geometry Type	Polygon
Feature Type	Simple
Z-Aware	False
M-Aware	False
Split Model	Update Insert
Minimum Client Version	10.1
Alias	DHC_ProtectionZone
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	RD_New
Catalog ID	{153C689D-B5CF-4E74-A631-ECD6B2906C3D}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Name	Alias	Type	Usage	Nullable	Length	Editable	Required
OBJECTID	OBJECTID	OID	Index	False	4	False	True
zoneradius	Zone Radius	Double		True	8	True	False
globalid	GlobalID	Global ID	Index	False	38	False	True
created_user	created_user	String	Creator	True	255	False	False
created_date	created_date	Date	Created	True	8	False	False
last_edited_user	last_edited_user	String	Editor	True	255	False	False
last_edited_date	last_edited_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

Name	Is Unique	Is Ascending	Field Name
UUID_53	True	True	globalid
FDO_OBJECTID	True	True	OBJECTID
st_spindex__DHC_ProtectionZone_shape	True	True	shape

Key	Value
Name	main.DHCAssembly
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	229
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	DHC 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	RD_New
X-Min	74670.57032500059
X-Max	104587.78457500189
Y-Min	425722.00917500164
Y-Max	445872.6281250017
Z-Min	0
Z-Max	0
Catalog ID	{58BAAD67-CF7C-4A5A-9601-C309220FAF47}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Key	Value
utilityNetworkName	main.Network

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
inservicedate	Inservice Date	Date		True			8	True	False
stationname	Station Name	String		True			50	True	False
owner	Owner	Short Integer		True			2	True	False
maintby	Maintained By	Short Integer		True			2	True	False
facilityid	FacilityID	String		True			20	True	False
locationdescription	Location Description	String		True			255	True	False
commodity	commodity	Long Integer		True			4	True	False
assetid	Asset ID	String		True			64	True	False
constructionstatus	Construction Status	Short Integer		True	Construction_Status	6	2	True	False
created_user	created_user	String	Creator	True			255	False	False
created_date	created_date	Date	Created	True			8	False	False
last_edited_user	last_edited_user	String	Editor	True			255	False	False
last_edited_date	last_edited_date	Date	Edited	True			8	False	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False

Name	Is Unique	Is Ascending	Field Name
GDB_229_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
UUID_45	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__DHCAssembly_SHAPE	True	True	SHAPE

Name	Code	Details
Unknown	0
Station	1
Well Pad	2
Fitting Assembly	3

Subtype Name	Subtype Code	Field Name	Default Value	Domain Name
Unknown	0	ASSETTYPE	0	Network_6_UnknownAssetType
Unknown	0	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Unknown	0	SUPPORTEDSUBNETWORKNAME	Unknown
Unknown	0	maintby	1	Asset_Manager
Unknown	0	owner	1	Asset_Owner
Station	1	ASSETTYPE	1	Asset_Type_Assembly_DHC_Station
Station	1	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Station	1	SUPPORTEDSUBNETWORKNAME	Unknown
Station	1	constructionstatus	6	Construction_Status
Station	1	lifecyclestatus	2	Lifecycle_Status
Station	1	maintby	1	Asset_Manager
Station	1	owner	1	Asset_Owner
Well Pad	2	ASSETTYPE	20	Asset_Type_Assembly_DHC_Well_Pad
Well Pad	2	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Well Pad	2	SUPPORTEDSUBNETWORKNAME	Unknown
Well Pad	2	constructionstatus	6	Construction_Status
Well Pad	2	lifecyclestatus	2	Lifecycle_Status
Well Pad	2	maintby	1	Asset_Manager
Well Pad	2	owner	1	Asset_Owner
Fitting Assembly	3	ASSETTYPE	40	Asset_Type_Assembly_DHC_Fitting_Assembly
Fitting Assembly	3	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Fitting Assembly	3	SUPPORTEDSUBNETWORKNAME	Unknown
Fitting Assembly	3	constructionstatus	6	Construction_Status
Fitting Assembly	3	lifecyclestatus	2	Lifecycle_Status
Fitting Assembly	3	maintby	1	Asset_Manager
Fitting Assembly	3	owner	1	Asset_Owner

Key	Value
ID	11
Minimum Client Version	12.9
Evaluation Order	1
Name	GenerateIDs-DHCA
Description	Generate IDs for DHCAssembly using database sequences
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:05
Script	// Assigned To: DHCAssembly // Type: Calculation // Name: GenerateIDs-DHCA // Description: Generate IDs for DHCAssembly using database sequences // Subtypes: All // Field: assetid // Evaluation Order: 1 // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules are rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated In: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - GenerateIDs-SJ // - GenerateIDs-SB // - GenerateIDs-SL // - GenerateIDs-DHCD // - GenerateIDs-DHCJ // - GenerateIDs-DHCL // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'assetid', 'assetgroup'); // 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 == '1') { id_format = { 'prefix': "Sttn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_A_Sttn_1_seq'); }else if (selector_value_txt == '2') { id_format = { 'prefix': "Wll-Pd", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_A_Wll_Pd_2_seq'); }else if (selector_value_txt == '3') { id_format = { 'prefix': "Fttng-Assmbly", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_A_Fttng_Assmbly_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 ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

Key	Value
Name	main.DHCDevice
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	226
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	DHC 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	RD_New
X-Min	74670.57032500059
X-Max	104587.78457500189
Y-Min	425722.00917500164
Y-Max	445872.6281250017
Z-Min	0
Z-Max	0
Catalog ID	{C1EF4146-352E-4D6A-B613-139BFE462CC8}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Key	Value
utilityNetworkName	main.Network

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
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
LeakDetectSubnetworkName	LeakDetectSubnetworkName	String	Index	False		Unknown	2000	False	True
SystemSubnetworkName	SystemSubnetworkName	String	Index	False		Unknown	2000	False	True
CirculationSubnetworkName	CirculationSubnetworkName	String	Index	False		Unknown	2000	False	True
PressureSubnetworkName	PressureSubnetworkName	String	Index	False		Unknown	2000	False	True
devicestatus	Device Status	Short Integer		True			2	True	False
accessible	Accessible	Short Integer		True			2	True	False
normalposition	Normal Position	Short Integer		True			2	True	False
commodity	Commodity	Short Integer		True			2	True	False
designtype	Device Type	Short Integer		True			2	True	False
casingmaterial	Casing Material	Short Integer		True			2	True	False
insulatingmaterial	Insulating Material	Short Integer		True			2	True	False
connectiondiameter	Connection Diameter	Double		True			8	True	False
connectiontype	Connection Type	Short Integer		True			2	True	False
internaldiameter	Internal Diameter	Double		True			8	True	False
diameterunit	Diameter Unit	Short Integer		True			2	True	False
inletpressure	Inlet Pressure	Double		True			8	True	False
outletpressure	Outlet Pressure	Double		True			8	True	False
devicelength	Length	Double		True			8	True	False
lengthunit	Length Unit	Short Integer		True			2	True	False
installdate	Installation Date	Date		True			8	True	False
inservicedate	Inservice Date	Date		True			8	True	False
retireddate	Retired Abandoned Date	Date		True			8	True	False
installlocation	Installation Location	Short Integer		True			2	True	False
automationstatus	Automation Status	Short Integer		True			2	True	False
operationtype	Operation Type	Short Integer		True			2	True	False
controlsignal	Control Signal	Short Integer		True			2	True	False
manufacturer	Manufacturer	Short Integer		True			2	True	False
manufacturerlotno	Manufacturer Lot#	String		True			10	True	False
manufacturedate	Manufacture Date	Date		True			8	True	False
devicerating	Device Rating	String		True			20	True	False
turnstoclose	Turns to Close	Double		True			8	True	False
angletoclose	Angle to Close	Double		True			8	True	False
seasonalturnsfreeze	Seasonal Turns Freezing	Double		True			8	True	False
valvekeytype	Valve Key Type	Short Integer		True			2	True	False
valvewrenchsize	Valve Wrench Size	Double		True			8	True	False
depth	Depth	Double		True			8	True	False
depthunit	Depth Unit	Short Integer		True			2	True	False
volume	Volume	Double		True			8	True	False
volumeunit	Volume Unit	Short Integer		True			2	True	False
temperature	Temperature	Double		True			8	True	False
temperatureunit	Temperature Unit	Short Integer		True			2	True	False
owner	Owner	Short Integer		True			2	True	False
maintby	Maintained By	Short Integer		True			2	True	False
assetid	Asset ID	String		True			64	True	False
serialnumber	Serial Number	String		True			20	True	False
ldtraceability	Leak Detection Traceability	Short Integer		True			2	True	False
bondedinsulated	Bonded/Insulated	Short Integer		True			2	True	False
cptraceability	Cathodic Protection Traceability	Short Integer		True			2	True	False
cpoverride	CP Override	Short Integer		True			2	True	False
connectioncapacity	Connection Capacity	Double		True			8	True	False
flowrate	Flow Rate	Double		True			8	True	False
flowrateunit	Flow Rate Unit	Short Integer		True			2	True	False
measuringsocket	Measuring Socket	Short Integer		True			2	True	False
spatialsource	Spatial Source	Short Integer		True			2	True	False
spatialaccuracyxy	Spatial Accuracy XY	Short Integer		True			2	True	False
spatialaccuracyz	Spatial Accuracy Z	Short Integer		True			2	True	False
building_identification	Building Identification	String		True			255	True	False
building_height	Building Height	Float		True			4	True	False
base_elevation	Base Elevation	Float		True			4	True	False
heating_demand	Heating Demand	Long Integer		True			4	True	False
cooling_demand	Cooling Demand	Long Integer		True			4	True	False
number_floors	Number of Floors	Long Integer		True			4	True	False
constructionstatus	Construction Status	Short Integer		True	Construction_Status	6	2	True	False
created_user	created_user	String	Creator	True			255	False	False
created_date	created_date	Date	Created	True			8	False	False
last_edited_user	last_edited_user	String	Editor	True			255	False	False
last_edited_date	last_edited_date	Date	Edited	True			8	False	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False

Name	Is Unique	Is Ascending	Field Name
GDB_226_SUBNETWO	False	True	SUBNETWORKCONTROLLERNAME
GDB_226_CPSubnet	False	True	CPSubnetworkName
GDB_226_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_226_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_226_LeakDete	False	True	LeakDetectSubnetworkName
GDB_226_SystemSu	False	True	SystemSubnetworkName
GDB_226_Circulat	False	True	CirculationSubnetworkName
GDB_226_Pressure	False	True	PressureSubnetworkName
UUID_43	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__DHCDevice_SHAPE	True	True	SHAPE

Name	Code	Details
Unknown	0
Pump	1
Flow Valve	2
Controllable Valve	3
Pressure Valve	4
Pressure Regulator	5
Meter	6
Trap	7
Monitoring	8
Heat Exchanger	9
Production Unit	10
Chiller	11
Service Connection	12
Well	13
Bypass	14
Leak Detection Panel	15
Leak Detection Test Point	16
Filter	17
Tank	18
Anode	50
Rectifier	51
Test Point	52

Subtype Name	Subtype Code	Field Name	Default Value	Domain Name
Unknown	0	ASSETTYPE	0	Network_6_UnknownAssetType
Unknown	0	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Unknown	0	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Unknown	0	ISCONNECTED	2	Network_6_IsConnected
Unknown	0	SUBNETWORKCONTROLLERNAME	Unknown
Unknown	0	TIERNAME	0	Network_6_TierName
Unknown	0	TIERRANK	0
Unknown	0	TERMINALCONFIGURATION	Default
Unknown	0	CPSubnetworkName	Unknown
Unknown	0	SUPPORTEDSUBNETWORKNAME	Unknown
Unknown	0	SUPPORTINGSUBNETWORKNAME	Unknown
Unknown	0	LeakDetectSubnetworkName	Unknown
Unknown	0	SystemSubnetworkName	Unknown
Unknown	0	CirculationSubnetworkName	Unknown
Unknown	0	PressureSubnetworkName	Unknown
Unknown	0	accessible	1	Yes_No
Unknown	0	automationstatus		DHC_Device_Automation_Status
Unknown	0	bondedinsulated	0	Bonded_Insulated
Unknown	0	commodity		DHC_Pipe_Commodity
Unknown	0	connectiondiameter	0	DHC_Pipe_Diameter_Metric
Unknown	0	connectiontype		DHC_Device_Connection_Type
Unknown	0	cpoverride		CP_Traceability
Unknown	0	cptraceability	0	CP_Traceability
Unknown	0	devicestatus		DHC_DeviceStatus
Unknown	0	diameterunit	3	DHC_UnitsForDiameter
Unknown	0	ldtraceability		LD_Traceability
Unknown	0	lengthunit	3	DHC_UnitsForLength
Unknown	0	maintby	1	Asset_Manager
Unknown	0	owner	1	Asset_Owner
Unknown	0	spatialaccuracyxy		DHC_SpatialAccuracy
Unknown	0	spatialaccuracyz		DHC_SpatialAccuracy
Unknown	0	spatialsource		Spatial_Source
Pump	1	ASSETTYPE	1	Asset_Type_Device_DHC_Pump
Pump	1	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Pump	1	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Pump	1	ISCONNECTED	2	Network_6_IsConnected
Pump	1	SUBNETWORKCONTROLLERNAME	Unknown
Pump	1	TIERNAME	0	Network_6_TierName
Pump	1	TIERRANK	0
Pump	1	TERMINALCONFIGURATION	Default
Pump	1	CPSubnetworkName	Unknown
Pump	1	SUPPORTEDSUBNETWORKNAME	Unknown
Pump	1	SUPPORTINGSUBNETWORKNAME	Unknown
Pump	1	LeakDetectSubnetworkName	Unknown
Pump	1	SystemSubnetworkName	Unknown
Pump	1	CirculationSubnetworkName	Unknown
Pump	1	PressureSubnetworkName	Unknown
Pump	1	accessible	1	Yes_No
Pump	1	automationstatus		DHC_Device_Automation_Status
Pump	1	bondedinsulated	0	Bonded_Insulated
Pump	1	casingmaterial		DHC_Device_Casing_Material
Pump	1	commodity		DHC_Pipe_Commodity
Pump	1	connectiondiameter	0	DHC_Pipe_Diameter_Metric
Pump	1	connectiontype		DHC_Device_Connection_Type
Pump	1	constructionstatus	6	Construction_Status
Pump	1	cpoverride		CP_Traceability
Pump	1	cptraceability	0	CP_Traceability
Pump	1	designtype		DHC_Device_Design_Type_Pump
Pump	1	devicestatus	1	DHC_DeviceStatus
Pump	1	diameterunit	3	DHC_UnitsForDiameter
Pump	1	flowrateunit	3	DHC_UnitsForFlow
Pump	1	insulatingmaterial	0	DHC_Device_Insulating_Material
Pump	1	ldtraceability	0	LD_Traceability
Pump	1	lengthunit	3	DHC_UnitsForLength
Pump	1	lifecyclestatus	2	Lifecycle_Status
Pump	1	maintby	1	Asset_Manager
Pump	1	manufacturer		DHC_Device_Pump_Manufacturer
Pump	1	normalposition	1	DHC_ValvePosition
Pump	1	owner	1	Asset_Owner
Pump	1	spatialaccuracyxy	0	DHC_SpatialAccuracy
Pump	1	spatialaccuracyz	0	DHC_SpatialAccuracy
Pump	1	spatialsource	0	Spatial_Source
Flow Valve	2	ASSETTYPE	0	Asset_Type_Device_DHC_Flow_Valve
Flow Valve	2	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Flow Valve	2	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Flow Valve	2	ISCONNECTED	2	Network_6_IsConnected
Flow Valve	2	SUBNETWORKCONTROLLERNAME	Unknown
Flow Valve	2	TIERNAME	0	Network_6_TierName
Flow Valve	2	TIERRANK	0
Flow Valve	2	TERMINALCONFIGURATION	Default
Flow Valve	2	CPSubnetworkName	Unknown
Flow Valve	2	SUPPORTEDSUBNETWORKNAME	Unknown
Flow Valve	2	SUPPORTINGSUBNETWORKNAME	Unknown
Flow Valve	2	LeakDetectSubnetworkName	Unknown
Flow Valve	2	SystemSubnetworkName	Unknown
Flow Valve	2	CirculationSubnetworkName	Unknown
Flow Valve	2	PressureSubnetworkName	Unknown
Flow Valve	2	accessible	1	Yes_No
Flow Valve	2	automationstatus		DHC_Device_Automation_Status
Flow Valve	2	bondedinsulated	0	Bonded_Insulated
Flow Valve	2	casingmaterial		DHC_Device_Casing_Material
Flow Valve	2	commodity		DHC_Pipe_Commodity
Flow Valve	2	connectiondiameter	0	DHC_Pipe_Diameter_Metric
Flow Valve	2	connectiontype		DHC_Device_Connection_Type
Flow Valve	2	constructionstatus	6	Construction_Status
Flow Valve	2	cpoverride		CP_Traceability
Flow Valve	2	cptraceability	0	CP_Traceability
Flow Valve	2	devicestatus	1	DHC_DeviceStatus
Flow Valve	2	diameterunit	3	DHC_UnitsForDiameter
Flow Valve	2	insulatingmaterial	0	DHC_Device_Insulating_Material
Flow Valve	2	ldtraceability	0	LD_Traceability
Flow Valve	2	lengthunit	3	DHC_UnitsForLength
Flow Valve	2	lifecyclestatus	2	Lifecycle_Status
Flow Valve	2	maintby	1	Asset_Manager
Flow Valve	2	manufacturer		DHC_Device_FValve_Manufacturer
Flow Valve	2	normalposition	1	DHC_ValvePosition
Flow Valve	2	owner	1	Asset_Owner
Flow Valve	2	spatialaccuracyxy	0	DHC_SpatialAccuracy
Flow Valve	2	spatialaccuracyz	0	DHC_SpatialAccuracy
Flow Valve	2	spatialsource	0	Spatial_Source
Controllable Valve	3	ASSETTYPE	0	Asset_Type_Device_DHC_Controllable_Valve
Controllable Valve	3	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Controllable Valve	3	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Controllable Valve	3	ISCONNECTED	2	Network_6_IsConnected
Controllable Valve	3	SUBNETWORKCONTROLLERNAME	Unknown
Controllable Valve	3	TIERNAME	0	Network_6_TierName
Controllable Valve	3	TIERRANK	0
Controllable Valve	3	TERMINALCONFIGURATION	Default
Controllable Valve	3	CPSubnetworkName	Unknown
Controllable Valve	3	SUPPORTEDSUBNETWORKNAME	Unknown
Controllable Valve	3	SUPPORTINGSUBNETWORKNAME	Unknown
Controllable Valve	3	LeakDetectSubnetworkName	Unknown
Controllable Valve	3	SystemSubnetworkName	Unknown
Controllable Valve	3	CirculationSubnetworkName	Unknown
Controllable Valve	3	PressureSubnetworkName	Unknown
Controllable Valve	3	accessible	1	Yes_No
Controllable Valve	3	angletoclose	0	DHC_Device_Angle_To_Close
Controllable Valve	3	automationstatus		DHC_Device_Automation_Status
Controllable Valve	3	bondedinsulated	0	Bonded_Insulated
Controllable Valve	3	casingmaterial		DHC_Device_Casing_Material
Controllable Valve	3	commodity		DHC_Pipe_Commodity
Controllable Valve	3	connectiondiameter	0	DHC_Pipe_Diameter_Metric
Controllable Valve	3	connectiontype		DHC_Device_Connection_Type
Controllable Valve	3	constructionstatus	6	Construction_Status
Controllable Valve	3	cpoverride		CP_Traceability
Controllable Valve	3	cptraceability	0	CP_Traceability
Controllable Valve	3	depthunit		DHC_UnitsForDepth
Controllable Valve	3	designtype		DHC_Device_Design_Type_CValve
Controllable Valve	3	devicestatus	1	DHC_DeviceStatus
Controllable Valve	3	diameterunit	3	DHC_UnitsForDiameter
Controllable Valve	3	insulatingmaterial	0	DHC_Device_Insulating_Material
Controllable Valve	3	ldtraceability	0	LD_Traceability
Controllable Valve	3	lengthunit	3	DHC_UnitsForLength
Controllable Valve	3	lifecyclestatus	2	Lifecycle_Status
Controllable Valve	3	maintby	1	Asset_Manager
Controllable Valve	3	manufacturer		DHC_Device_CValve_Manufacturer
Controllable Valve	3	normalposition	1	DHC_ValvePosition
Controllable Valve	3	operationtype		DHC_Device_CValve_Operation_Type
Controllable Valve	3	owner	1	Asset_Owner
Controllable Valve	3	spatialaccuracyxy	0	DHC_SpatialAccuracy
Controllable Valve	3	spatialaccuracyz	0	DHC_SpatialAccuracy
Controllable Valve	3	spatialsource	0	Spatial_Source
Controllable Valve	3	valvekeytype		DHC_Device_Valve_Key_Type
Pressure Valve	4	ASSETTYPE	0	Asset_Type_Device_DHC_Pressure_Valve
Pressure Valve	4	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Pressure Valve	4	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Pressure Valve	4	ISCONNECTED	2	Network_6_IsConnected
Pressure Valve	4	SUBNETWORKCONTROLLERNAME	Unknown
Pressure Valve	4	TIERNAME	0	Network_6_TierName
Pressure Valve	4	TIERRANK	0
Pressure Valve	4	TERMINALCONFIGURATION	Default
Pressure Valve	4	CPSubnetworkName	Unknown
Pressure Valve	4	SUPPORTEDSUBNETWORKNAME	Unknown
Pressure Valve	4	SUPPORTINGSUBNETWORKNAME	Unknown
Pressure Valve	4	LeakDetectSubnetworkName	Unknown
Pressure Valve	4	SystemSubnetworkName	Unknown
Pressure Valve	4	CirculationSubnetworkName	Unknown
Pressure Valve	4	PressureSubnetworkName	Unknown
Pressure Valve	4	accessible	1	Yes_No
Pressure Valve	4	angletoclose	0	DHC_Device_Angle_To_Close
Pressure Valve	4	automationstatus		DHC_Device_Automation_Status
Pressure Valve	4	bondedinsulated	0	Bonded_Insulated
Pressure Valve	4	casingmaterial		DHC_Device_Casing_Material
Pressure Valve	4	commodity		DHC_Pipe_Commodity
Pressure Valve	4	connectiondiameter	0	DHC_Pipe_Diameter_Metric
Pressure Valve	4	connectiontype		DHC_Device_Connection_Type
Pressure Valve	4	constructionstatus	6	Construction_Status
Pressure Valve	4	controlsignal		DHC_Device_Control_Signal
Pressure Valve	4	cpoverride		CP_Traceability
Pressure Valve	4	cptraceability	0	CP_Traceability
Pressure Valve	4	depthunit		DHC_UnitsForDepth
Pressure Valve	4	designtype		DHC_Device_Design_Type_PValve
Pressure Valve	4	devicestatus	1	DHC_DeviceStatus
Pressure Valve	4	diameterunit	3	DHC_UnitsForDiameter
Pressure Valve	4	insulatingmaterial	0	DHC_Device_Insulating_Material
Pressure Valve	4	ldtraceability	0	LD_Traceability
Pressure Valve	4	lengthunit	3	DHC_UnitsForLength
Pressure Valve	4	lifecyclestatus	2	Lifecycle_Status
Pressure Valve	4	maintby	1	Asset_Manager
Pressure Valve	4	manufacturer		DHC_Device_PValve_Manufacturer
Pressure Valve	4	normalposition	1	DHC_ValvePosition
Pressure Valve	4	operationtype		DHC_Device_PValve_Operation_Type
Pressure Valve	4	owner	1	Asset_Owner
Pressure Valve	4	spatialaccuracyxy	0	DHC_SpatialAccuracy
Pressure Valve	4	spatialaccuracyz	0	DHC_SpatialAccuracy
Pressure Valve	4	spatialsource	0	Spatial_Source
Pressure Regulator	5	ASSETTYPE	0	Asset_Type_Device_DHC_Pressure_Regulator
Pressure Regulator	5	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Pressure Regulator	5	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Pressure Regulator	5	ISCONNECTED	2	Network_6_IsConnected
Pressure Regulator	5	SUBNETWORKCONTROLLERNAME	Unknown
Pressure Regulator	5	TIERNAME	0	Network_6_TierName
Pressure Regulator	5	TIERRANK	0
Pressure Regulator	5	TERMINALCONFIGURATION	Default
Pressure Regulator	5	CPSubnetworkName	Unknown
Pressure Regulator	5	SUPPORTEDSUBNETWORKNAME	Unknown
Pressure Regulator	5	SUPPORTINGSUBNETWORKNAME	Unknown
Pressure Regulator	5	LeakDetectSubnetworkName	Unknown
Pressure Regulator	5	SystemSubnetworkName	Unknown
Pressure Regulator	5	CirculationSubnetworkName	Unknown
Pressure Regulator	5	PressureSubnetworkName	Unknown
Pressure Regulator	5	accessible	1	Yes_No
Pressure Regulator	5	automationstatus		DHC_Device_Automation_Status
Pressure Regulator	5	bondedinsulated	0	Bonded_Insulated
Pressure Regulator	5	casingmaterial		DHC_Device_Casing_Material
Pressure Regulator	5	commodity		DHC_Pipe_Commodity
Pressure Regulator	5	connectiondiameter	0	DHC_Pipe_Diameter_Metric
Pressure Regulator	5	connectiontype		DHC_Device_Connection_Type
Pressure Regulator	5	constructionstatus	6	Construction_Status
Pressure Regulator	5	controlsignal		DHC_Device_Control_Signal
Pressure Regulator	5	cpoverride		CP_Traceability
Pressure Regulator	5	cptraceability	0	CP_Traceability
Pressure Regulator	5	depthunit		DHC_UnitsForDepth
Pressure Regulator	5	designtype		DHC_Device_Design_Type_PRegulator
Pressure Regulator	5	devicestatus	1	DHC_DeviceStatus
Pressure Regulator	5	diameterunit	3	DHC_UnitsForDiameter
Pressure Regulator	5	insulatingmaterial	0	DHC_Device_Insulating_Material
Pressure Regulator	5	ldtraceability	0	LD_Traceability
Pressure Regulator	5	lengthunit	3	DHC_UnitsForLength
Pressure Regulator	5	lifecyclestatus	2	Lifecycle_Status
Pressure Regulator	5	maintby	1	Asset_Manager
Pressure Regulator	5	manufacturer		DHC_Device_PRegulator_Manufacturer
Pressure Regulator	5	normalposition	1	DHC_ValvePosition
Pressure Regulator	5	operationtype		DHC_Device_PReg_Operation_Type
Pressure Regulator	5	owner	1	Asset_Owner
Pressure Regulator	5	spatialaccuracyxy	0	DHC_SpatialAccuracy
Pressure Regulator	5	spatialaccuracyz	0	DHC_SpatialAccuracy
Pressure Regulator	5	spatialsource	0	Spatial_Source
Meter	6	ASSETTYPE	0	Asset_Type_Device_DHC_Meter
Meter	6	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Meter	6	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Meter	6	ISCONNECTED	2	Network_6_IsConnected
Meter	6	SUBNETWORKCONTROLLERNAME	Unknown
Meter	6	TIERNAME	0	Network_6_TierName
Meter	6	TIERRANK	0
Meter	6	TERMINALCONFIGURATION	Default
Meter	6	CPSubnetworkName	Unknown
Meter	6	SUPPORTEDSUBNETWORKNAME	Unknown
Meter	6	SUPPORTINGSUBNETWORKNAME	Unknown
Meter	6	LeakDetectSubnetworkName	Unknown
Meter	6	SystemSubnetworkName	Unknown
Meter	6	CirculationSubnetworkName	Unknown
Meter	6	PressureSubnetworkName	Unknown
Meter	6	accessible	1	Yes_No
Meter	6	automationstatus		DHC_Device_Automation_Status
Meter	6	bondedinsulated	0	Bonded_Insulated
Meter	6	casingmaterial		DHC_Device_Casing_Material
Meter	6	commodity		DHC_Pipe_Commodity
Meter	6	connectiondiameter	0	DHC_Pipe_Diameter_Metric
Meter	6	connectiontype		DHC_Device_Connection_Type
Meter	6	constructionstatus	6	Construction_Status
Meter	6	cpoverride		CP_Traceability
Meter	6	cptraceability	0	CP_Traceability
Meter	6	designtype		DHC_Device_Design_Type_Meter
Meter	6	devicestatus	1	DHC_DeviceStatus
Meter	6	diameterunit	3	DHC_UnitsForDiameter
Meter	6	insulatingmaterial	0	DHC_Device_Insulating_Material
Meter	6	ldtraceability	0	LD_Traceability
Meter	6	lengthunit	3	DHC_UnitsForLength
Meter	6	lifecyclestatus	2	Lifecycle_Status
Meter	6	maintby	1	Asset_Manager
Meter	6	manufacturer		DHC_Device_Meter_Manufacturer
Meter	6	normalposition	1	DHC_ValvePosition
Meter	6	operationtype		DHC_Device_Meter_Operation_Type
Meter	6	owner	1	Asset_Owner
Meter	6	spatialaccuracyxy	0	DHC_SpatialAccuracy
Meter	6	spatialaccuracyz	0	DHC_SpatialAccuracy
Meter	6	spatialsource	0	Spatial_Source
Trap	7	ASSETTYPE	0	Asset_Type_Device_DHC_Trap
Trap	7	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Trap	7	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Trap	7	ISCONNECTED	2	Network_6_IsConnected
Trap	7	SUBNETWORKCONTROLLERNAME	Unknown
Trap	7	TIERNAME	0	Network_6_TierName
Trap	7	TIERRANK	0
Trap	7	TERMINALCONFIGURATION	Default
Trap	7	CPSubnetworkName	Unknown
Trap	7	SUPPORTEDSUBNETWORKNAME	Unknown
Trap	7	SUPPORTINGSUBNETWORKNAME	Unknown
Trap	7	LeakDetectSubnetworkName	Unknown
Trap	7	SystemSubnetworkName	Unknown
Trap	7	CirculationSubnetworkName	Unknown
Trap	7	PressureSubnetworkName	Unknown
Trap	7	accessible	1	Yes_No
Trap	7	bondedinsulated	0	Bonded_Insulated
Trap	7	casingmaterial		DHC_Device_Trap_Casing_Material
Trap	7	commodity		DHC_Pipe_Commodity
Trap	7	constructionstatus	6	Construction_Status
Trap	7	cpoverride		CP_Traceability
Trap	7	cptraceability	0	CP_Traceability
Trap	7	designtype		DHC_Device_Design_Type_Trap
Trap	7	devicestatus	1	DHC_DeviceStatus
Trap	7	diameterunit	3	DHC_UnitsForDiameter
Trap	7	ldtraceability	0	LD_Traceability
Trap	7	lengthunit	3	DHC_UnitsForLength
Trap	7	lifecyclestatus	2	Lifecycle_Status
Trap	7	maintby	1	Asset_Manager
Trap	7	manufacturer		DHC_Device_Trap_Manufacturer
Trap	7	normalposition		DHC_ValvePosition
Trap	7	owner	1	Asset_Owner
Trap	7	spatialaccuracyxy	0	DHC_SpatialAccuracy
Trap	7	spatialaccuracyz	0	DHC_SpatialAccuracy
Trap	7	spatialsource	0	Spatial_Source
Monitoring	8	ASSETTYPE	0	Asset_Type_Device_DHC_Monitor
Monitoring	8	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Monitoring	8	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Monitoring	8	ISCONNECTED	2	Network_6_IsConnected
Monitoring	8	SUBNETWORKCONTROLLERNAME	Unknown
Monitoring	8	TIERNAME	0	Network_6_TierName
Monitoring	8	TIERRANK	0
Monitoring	8	TERMINALCONFIGURATION	Default
Monitoring	8	CPSubnetworkName	Unknown
Monitoring	8	SUPPORTEDSUBNETWORKNAME	Unknown
Monitoring	8	SUPPORTINGSUBNETWORKNAME	Unknown
Monitoring	8	LeakDetectSubnetworkName	Unknown
Monitoring	8	SystemSubnetworkName	Unknown
Monitoring	8	CirculationSubnetworkName	Unknown
Monitoring	8	PressureSubnetworkName	Unknown
Monitoring	8	accessible	1	Yes_No
Monitoring	8	bondedinsulated	0	Bonded_Insulated
Monitoring	8	casingmaterial		DHC_Device_Casing_Material
Monitoring	8	commodity		DHC_Pipe_Commodity
Monitoring	8	connectiontype		DHC_Device_Connection_Type
Monitoring	8	constructionstatus	6	Construction_Status
Monitoring	8	cpoverride		CP_Traceability
Monitoring	8	cptraceability	0	CP_Traceability
Monitoring	8	designtype		DHC_Device_Design_Type_Monitoring
Monitoring	8	devicestatus	1	DHC_DeviceStatus
Monitoring	8	diameterunit	3	DHC_UnitsForDiameter
Monitoring	8	insulatingmaterial	0	DHC_Device_Insulating_Material
Monitoring	8	ldtraceability	0	LD_Traceability
Monitoring	8	lengthunit	3	DHC_UnitsForLength
Monitoring	8	lifecyclestatus	2	Lifecycle_Status
Monitoring	8	maintby	1	Asset_Manager
Monitoring	8	manufacturer		DHC_Device_Monitoring_Manufacturer
Monitoring	8	operationtype		DHC_Device_Monitoring_Operation_Type
Monitoring	8	owner	1	Asset_Owner
Monitoring	8	spatialaccuracyxy	0	DHC_SpatialAccuracy
Monitoring	8	spatialaccuracyz	0	DHC_SpatialAccuracy
Monitoring	8	spatialsource	0	Spatial_Source
Heat Exchanger	9	ASSETTYPE	0	Asset_Type_Device_DHC_Heat_Exchanger
Heat Exchanger	9	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Heat Exchanger	9	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Heat Exchanger	9	ISCONNECTED	2	Network_6_IsConnected
Heat Exchanger	9	SUBNETWORKCONTROLLERNAME	Unknown
Heat Exchanger	9	TIERNAME	0	Network_6_TierName
Heat Exchanger	9	TIERRANK	0
Heat Exchanger	9	TERMINALCONFIGURATION	Default
Heat Exchanger	9	CPSubnetworkName	Unknown
Heat Exchanger	9	SUPPORTEDSUBNETWORKNAME	Unknown
Heat Exchanger	9	SUPPORTINGSUBNETWORKNAME	Unknown
Heat Exchanger	9	LeakDetectSubnetworkName	Unknown
Heat Exchanger	9	SystemSubnetworkName	Unknown
Heat Exchanger	9	CirculationSubnetworkName	Unknown
Heat Exchanger	9	PressureSubnetworkName	Unknown
Heat Exchanger	9	accessible	1	Yes_No
Heat Exchanger	9	bondedinsulated	0	Bonded_Insulated
Heat Exchanger	9	casingmaterial		DHC_Device_Casing_Material
Heat Exchanger	9	commodity		DHC_Pipe_Commodity
Heat Exchanger	9	constructionstatus	6	Construction_Status
Heat Exchanger	9	cpoverride		CP_Traceability
Heat Exchanger	9	cptraceability	0	CP_Traceability
Heat Exchanger	9	designtype		DHC_Device_Design_Type_HeatExchanger
Heat Exchanger	9	devicerating		DHC_Device_Rating_Heat_Exchanger
Heat Exchanger	9	devicestatus	1	DHC_DeviceStatus
Heat Exchanger	9	diameterunit	3	DHC_UnitsForDiameter
Heat Exchanger	9	insulatingmaterial	0	DHC_Device_Insulating_Material
Heat Exchanger	9	ldtraceability	0	LD_Traceability
Heat Exchanger	9	lengthunit	3	DHC_UnitsForLength
Heat Exchanger	9	lifecyclestatus	2	Lifecycle_Status
Heat Exchanger	9	maintby	1	Asset_Manager
Heat Exchanger	9	manufacturer		DHC_Device_HExchanger_Manufacturer
Heat Exchanger	9	normalposition		DHC_ValvePosition
Heat Exchanger	9	owner	1	Asset_Owner
Heat Exchanger	9	spatialaccuracyxy	0	DHC_SpatialAccuracy
Heat Exchanger	9	spatialaccuracyz	0	DHC_SpatialAccuracy
Heat Exchanger	9	spatialsource	0	Spatial_Source
Heat Exchanger	9	temperatureunit		DHC_UnitsForTemperature
Production Unit	10	ASSETTYPE	0	Asset_Type_Device_DHC_Production_Unit
Production Unit	10	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Production Unit	10	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Production Unit	10	ISCONNECTED	2	Network_6_IsConnected
Production Unit	10	SUBNETWORKCONTROLLERNAME	Unknown
Production Unit	10	TIERNAME	0	Network_6_TierName
Production Unit	10	TIERRANK	0
Production Unit	10	TERMINALCONFIGURATION	Default
Production Unit	10	CPSubnetworkName	Unknown
Production Unit	10	SUPPORTEDSUBNETWORKNAME	Unknown
Production Unit	10	SUPPORTINGSUBNETWORKNAME	Unknown
Production Unit	10	LeakDetectSubnetworkName	Unknown
Production Unit	10	SystemSubnetworkName	Unknown
Production Unit	10	CirculationSubnetworkName	Unknown
Production Unit	10	PressureSubnetworkName	Unknown
Production Unit	10	bondedinsulated	0	Bonded_Insulated
Production Unit	10	casingmaterial		DHC_Device_Casing_Material
Production Unit	10	commodity		DHC_Pipe_Commodity
Production Unit	10	constructionstatus	6	Construction_Status
Production Unit	10	cpoverride		CP_Traceability
Production Unit	10	cptraceability	0	CP_Traceability
Production Unit	10	designtype		DHC_Device_Design_Type_ProductionUnit
Production Unit	10	devicestatus	1	DHC_DeviceStatus
Production Unit	10	insulatingmaterial	0	DHC_Device_Insulating_Material
Production Unit	10	ldtraceability	0	LD_Traceability
Production Unit	10	lifecyclestatus	2	Lifecycle_Status
Production Unit	10	maintby	1	Asset_Manager
Production Unit	10	manufacturer		DHC_Device_ProdUnit_Manufacturer
Production Unit	10	normalposition		DHC_ValvePosition
Production Unit	10	owner	1	Asset_Owner
Production Unit	10	spatialaccuracyxy	0	DHC_SpatialAccuracy
Production Unit	10	spatialaccuracyz	0	DHC_SpatialAccuracy
Production Unit	10	spatialsource	0	Spatial_Source
Production Unit	10	temperatureunit	1	DHC_UnitsForTemperature
Chiller	11	ASSETTYPE	0	Asset_Type_Device_DHC_Chiller
Chiller	11	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Chiller	11	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Chiller	11	ISCONNECTED	2	Network_6_IsConnected
Chiller	11	SUBNETWORKCONTROLLERNAME	Unknown
Chiller	11	TIERNAME	0	Network_6_TierName
Chiller	11	TIERRANK	0
Chiller	11	TERMINALCONFIGURATION	Default
Chiller	11	CPSubnetworkName	Unknown
Chiller	11	SUPPORTEDSUBNETWORKNAME	Unknown
Chiller	11	SUPPORTINGSUBNETWORKNAME	Unknown
Chiller	11	LeakDetectSubnetworkName	Unknown
Chiller	11	SystemSubnetworkName	Unknown
Chiller	11	CirculationSubnetworkName	Unknown
Chiller	11	PressureSubnetworkName	Unknown
Chiller	11	bondedinsulated	0	Bonded_Insulated
Chiller	11	commodity		DHC_Pipe_Commodity
Chiller	11	constructionstatus	6	Construction_Status
Chiller	11	cpoverride		CP_Traceability
Chiller	11	cptraceability	0	CP_Traceability
Chiller	11	designtype		DHC_Device_Design_Type_Chiller
Chiller	11	devicestatus	1	DHC_DeviceStatus
Chiller	11	diameterunit	3	DHC_UnitsForDiameter
Chiller	11	lengthunit	3	DHC_UnitsForLength
Chiller	11	lifecyclestatus	2	Lifecycle_Status
Chiller	11	maintby	1	Asset_Manager
Chiller	11	manufacturer		DHC_Device_Chiller_Manufacturer
Chiller	11	normalposition		DHC_ValvePosition
Chiller	11	owner	1	Asset_Owner
Chiller	11	spatialaccuracyxy		DHC_SpatialAccuracy
Chiller	11	spatialaccuracyz		DHC_SpatialAccuracy
Chiller	11	spatialsource		Spatial_Source
Chiller	11	temperatureunit	1	DHC_UnitsForTemperature
Chiller	11	ldtraceability	0
Service Connection	12	ASSETTYPE	0	Asset_Type_Device_DHC_Service_Connection
Service Connection	12	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Service Connection	12	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Service Connection	12	ISCONNECTED	2	Network_6_IsConnected
Service Connection	12	SUBNETWORKCONTROLLERNAME	Unknown
Service Connection	12	TIERNAME	0	Network_6_TierName
Service Connection	12	TIERRANK	0
Service Connection	12	TERMINALCONFIGURATION	Default
Service Connection	12	CPSubnetworkName	Unknown
Service Connection	12	SUPPORTEDSUBNETWORKNAME	Unknown
Service Connection	12	SUPPORTINGSUBNETWORKNAME	Unknown
Service Connection	12	LeakDetectSubnetworkName	Unknown
Service Connection	12	SystemSubnetworkName	Unknown
Service Connection	12	CirculationSubnetworkName	Unknown
Service Connection	12	PressureSubnetworkName	Unknown
Service Connection	12	constructionstatus	6	Construction_Status
Service Connection	12	diameterunit	3	DHC_UnitsForDiameter
Service Connection	12	lengthunit	3	DHC_UnitsForLength
Service Connection	12	lifecyclestatus	2	Lifecycle_Status
Service Connection	12	measuringsocket		Yes_No
Well	13	ASSETTYPE	0	Asset_Type_Device_DHC_Well
Well	13	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Well	13	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Well	13	ISCONNECTED	2	Network_6_IsConnected
Well	13	SUBNETWORKCONTROLLERNAME	Unknown
Well	13	TIERNAME	0	Network_6_TierName
Well	13	TIERRANK	0
Well	13	TERMINALCONFIGURATION	Default
Well	13	CPSubnetworkName	Unknown
Well	13	SUPPORTEDSUBNETWORKNAME	Unknown
Well	13	SUPPORTINGSUBNETWORKNAME	Unknown
Well	13	LeakDetectSubnetworkName	Unknown
Well	13	SystemSubnetworkName	Unknown
Well	13	CirculationSubnetworkName	Unknown
Well	13	PressureSubnetworkName	Unknown
Well	13	bondedinsulated	0	Bonded_Insulated
Well	13	casingmaterial		DHC_Device_Well_Material
Well	13	commodity		DHC_Pipe_Commodity
Well	13	constructionstatus	6	Construction_Status
Well	13	cpoverride		CP_Traceability
Well	13	cptraceability	0	CP_Traceability
Well	13	depthunit	4	DHC_UnitsForDepth
Well	13	devicestatus	1	DHC_DeviceStatus
Well	13	diameterunit		DHC_UnitsForDiameter

Key	Value
ID	4
Minimum Client Version	12.3
Evaluation Order	1
Name	Containment Association
Description	Calculation to automatically create containment association between content and container.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Error Number	1010
Error Message	Could not create containment association
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2024-04-26 11:17:03
Script	// Assigned To: DHCDevice // Type: Calculation // Name: Containment Association // Description: Calculation to automatically create containment association between content and container. // Subtypes: All // Field: assetid // Is Editable: True // Trigger: Insert // Error Number: 1010 // Error Message: Could not create containment association // Exclude From Client: True // Batch: False // Severity: None // Disable: True // Evaluation Order: 1 // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation var assigned_to_field = $feature.assetid; // Meters var search_distance = 5; var search_unit = 9001; // Feet //var search_distance = 15; //var search_unit = 9002; // ********* End User Variables Section ******** // ********* Functions ********* function sortCandidates(a, b) { if (a['distance'] < b['distance']) return -1; if (a['distance'] > b['distance']) return 1; return 0; } function class_id_to_name(id) { if (id == 4 \|\| id == '4') { return 'StructureJunction'; } else if (id == 5 \|\| id == '5') { return 'StructureLine'; } else if (id == 6 \|\| id == '6') { return 'StructureBoundary'; } else if (id == 9 \|\| id == '9') { return 'DHCDevice'; } else if (id == 10 \|\| id == '10') { return 'DHCLine'; } else if (id == 11 \|\| id == '11') { return 'DHCAssembly'; } else if (id == 12 \|\| id == '12') { return 'DHCJunction'; } else { return id; } } function get_featureset_from_classname(class_name, fields, include_geometry) { var class_name = Split(class_name, '.')[-1]; var feature_set = null; if (class_name == 'DHCDevice') { feature_set = FeatureSetByName($datastore, '{C1EF4146-352E-4D6A-B613-139BFE462CC8}', fields, include_geometry); } else if (class_name == 'DHCJunction') { feature_set = FeatureSetByName($datastore, '{9062050C-735A-40AC-9193-50B85B1A8AD5}', fields, include_geometry); } else if (class_name == 'DHCAssembly') { feature_set = FeatureSetByName($datastore, '{58BAAD67-CF7C-4A5A-9601-C309220FAF47}', fields, include_geometry); } else if (class_name == 'DHCLine') { feature_set = FeatureSetByName($datastore, '{00581CA8-603F-421F-8F0F-4DFAD30F849C}', fields, include_geometry); } else if (class_name == 'StructureJunction') { feature_set = FeatureSetByName($datastore, '{32CEC08A-A271-4D12-B63A-B3A08979DA00}', fields, include_geometry); } else if (class_name == 'StructureLine') { feature_set = FeatureSetByName($datastore, '{70FDE1BD-688D-400B-B5B4-D273C7D268A8}', fields, include_geometry); } else if (class_name == 'StructureBoundary') { feature_set = FeatureSetByName($datastore, '{5C0EA9EE-FEFF-4335-8667-A920BA47BFD9}', fields, include_geometry); } else if (class_name == 'Rules') { feature_set = FeatureSetByName($datastore, '{E996AEA0-3BB7-477B-9BA2-B11F43F989B6}', fields, false); } else { feature_set = FeatureSetByName($datastore, '{5C0EA9EE-FEFF-4335-8667-A920BA47BFD9}', fields, include_geometry); } return feature_set; } function build_containers_info() { var rule_fields = ['OBJECTID', 'RULETYPE', 'FROMNETWORKSOURCEID', 'FROMASSETGROUP', 'FROMASSETTYPE', 'FROMTERMINALID', 'TONETWORKSOURCEID', 'TOASSETGROUP', 'TOASSETTYPE', 'TOTERMINALID', 'VIANETWORKSOURCEID', 'VIAASSETGROUP', 'VIAASSETTYPE', 'VIATERMINALID', 'CREATIONDATE', 'GLOBALID'] var rules_fs = get_featureset_from_classname('Rules', rule_fields, false); var containment_sql = 'RULETYPE = 2' var feature_sql = 'TOASSETGROUP = ' + $feature.assetgroup + ' and TOASSETTYPE = ' + $feature.assettype; var containers_rows = Filter(rules_fs, containment_sql + ' and ' + feature_sql); var container_row_count = Count(containers_rows) if (container_row_count == 0) { return null; } var container_class_types = {}; for (var container_row in containers_rows) { var class_name = class_id_to_name(container_row['FROMNETWORKSOURCEID']); if (HasKey(container_class_types, class_name) == false) { container_class_types[class_name] = {}; } var asset_group = Text(container_row['FROMASSETGROUP']) if (HasKey(container_class_types[class_name], asset_group) == false) { container_class_types[class_name][asset_group] = []; } var asset_type = Text(container_row['FROMASSETTYPE']) if (IndexOf(container_class_types[class_name][asset_group], asset_type) == -1) { var at_cnt = Count(container_class_types[class_name][asset_group]) container_class_types[class_name][asset_group][at_cnt] = asset_type; } } return container_class_types } function build_sql(container_info, feat_global_id) { var sql_class = []; var i = 0; for (var cls in container_info) { var sub_where = []; var k = 0; for (var ag in container_info[cls]) { sub_where[k++] = "(AssetGroup = " + ag + " AND AssetType IN (" + Concatenate(container_info[cls][ag], ',') + '))' } sql_class[i++] = [cls, '(' + Concatenate(sub_where, ' OR ') + ") and GLOBALID <> '" + feat_global_id + "'"]; } return sql_class } function generate_candidates(feature, sql_by_class, search_shape) { var container_candidate = []; var k = 0; for (var i = 0; i < Count(sql_by_class); i++) { var class_name = sql_by_class[i][0]; var where = sql_by_class[i][1]; var fs = get_featureset_from_classname(class_name, ['GLOBALID'], false); var container_features = Filter(Intersects(fs, search_shape), where); var cont_feat_count = Count(container_features); if (cont_feat_count > 0) { for (var feat in container_features) { container_candidate[k++] = { 'class_name': class_name, 'globalid': feat.globalid, 'distance': Distance(feature, feat, search_unit) } } } } return container_candidate; } // Function to check if a bit is in an int value function has_bit(num, test_value) { // num = number to test if it contains a bit // test_value = the bit value to test for // determines if num has the test_value bit set // Equivalent to num AND test_value == test_value // first we need to determine the bit position of test_value var bit_pos = -1; for (var i = 0; i < 64; i++) { // equivalent to test_value >> 1 var test_value = Floor(test_value / 2); bit_pos++; if (test_value == 0) break; } // now that we know the bit position, we shift the bits of // num until we get to the bit we care about for (var i = 1; i <= bit_pos; i++) { var num = Floor(num / 2); } if (num % 2 == 0) { return false } else { return true } } // ********* End Functions Section *************** // Uncomment this section if this rule is enabled for an update trigger. If the feature is already content, return /* if (has_bit($feature.ASSOCIATIONSTATUS, 4) \|\| has_bit($feature.ASSOCIATIONSTATUS, 16)) { return assigned_to_field; } */ //Ensure AssetGroup and AssetType fields are populated. if (IsEmpty($feature.assetgroup)) return assigned_to_field; if (IsEmpty($feature.assettype)) return assigned_to_field; //Query the rules table to get all containment records var container_info = build_containers_info(); if (IsEmpty(container_info)) return assigned_to_field; var sql_by_class = build_sql(container_info, $feature.globalid); var search_shape = Buffer(Geometry($feature), search_distance, search_unit); var candidates = generate_candidates($feature, sql_by_class, search_shape) if (Count(candidates) == 0) return assigned_to_field; var sorted_candidates = Sort(candidates, sortCandidates); //When the closest container is a StructureBoundary feature, the device/junction must be contained within extent of it's polygon. var candidateClassName = sorted_candidates[0]['class_name']; if (candidateClassName == "StructureBoundary"){ var candidateGlobalid = sorted_candidates[0]['globalid']; var fsBoundary = get_featureset_from_classname(candidateClassName, ['GLOBALID'], true); var boundary_features = Intersects(fsBoundary, $feature); var filtered_feature = Filter(boundary_features, "globalid = @candidateGlobalid"); if (Count(filtered_feature) == 0) // didn't find the candidate boundary feature. return assigned_to_field; } var edit_payload = [{ 'className': sorted_candidates[0]['class_name'], 'updates': [{ 'globalID': sorted_candidates[0]['globalid'], 'associationType': 'container' }] }]; return {"result": assigned_to_field, "edit": edit_payload};

Key	Value
ID	5
Minimum Client Version	12.9
Evaluation Order	2
Name	GenerateIDs-DHCD
Description	Generate IDs for DHCDevice using database sequences
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:03
Script	// Assigned To: DHCDevice // Type: Calculation // Name: GenerateIDs-DHCD // Description: Generate IDs for DHCDevice using database sequences // Subtypes: All // Field: assetid // Evaluation Order: 2 // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules are rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated In: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - GenerateIDs-SJ // - GenerateIDs-SB // - GenerateIDs-SL // - GenerateIDs-DHCA // - GenerateIDs-DHCJ // - GenerateIDs-DHCL // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'assetid', 'assetgroup'); // 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 == '1') { id_format = { 'prefix': "Pmp", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Pmp_1_seq'); }else if (selector_value_txt == '2') { id_format = { 'prefix': "Flw-Vlv", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Flw_Vlv_2_seq'); }else if (selector_value_txt == '3') { id_format = { 'prefix': "CTRLlbl-Vlv", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_CTRLlbl_Vlv_3_seq'); }else if (selector_value_txt == '4') { id_format = { 'prefix': "Prssr-Vlv", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Prssr_Vlv_4_seq'); }else if (selector_value_txt == '5') { id_format = { 'prefix': "Prssr-REG", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Prssr_REG_5_seq'); }else if (selector_value_txt == '6') { id_format = { 'prefix': "MTR", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_MTR_6_seq'); }else if (selector_value_txt == '7') { id_format = { 'prefix': "Trp", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Trp_7_seq'); }else if (selector_value_txt == '8') { id_format = { 'prefix': "Mntrng", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Mntrng_8_seq'); }else if (selector_value_txt == '9') { id_format = { 'prefix': "Ht-Exchngr", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Ht_Exchngr_9_seq'); }else if (selector_value_txt == '10') { id_format = { 'prefix': "PrdctnU", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_PrdctnU_10_seq'); }else if (selector_value_txt == '11') { id_format = { 'prefix': "Chllr", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Chllr_11_seq'); }else if (selector_value_txt == '12') { id_format = { 'prefix': "SVC-Cnnctn", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_SVC_Cnnctn_12_seq'); }else if (selector_value_txt == '13') { id_format = { 'prefix': "Wll", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Wll_13_seq'); }else if (selector_value_txt == '14') { id_format = { 'prefix': "Bypss", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Bypss_14_seq'); }else if (selector_value_txt == '15') { id_format = { 'prefix': "Lk-Dtctn-Pnl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Lk_Dtctn_Pnl_15_seq'); }else if (selector_value_txt == '16') { id_format = { 'prefix': "Lk-Dtctn-Tst-Pnt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Lk_Dtctn_Tst_Pnt_16_seq'); }else if (selector_value_txt == '17') { id_format = { 'prefix': "Fltr", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Fltr_17_seq'); }else if (selector_value_txt == '18') { id_format = { 'prefix': "Tnk", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Tnk_18_seq'); }else if (selector_value_txt == '50') { id_format = { 'prefix': "And", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_And_50_seq'); }else if (selector_value_txt == '51') { id_format = { 'prefix': "Rctfr", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Rctfr_51_seq'); }else if (selector_value_txt == '52') { id_format = { 'prefix': "Tst-Pnt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_D_Tst_Pnt_52_seq'); } else { return null; } var id_parts = remove_empty([id_format['prefix'], seq_val, id_format['suffix']]) return Concatenate(id_parts, id_format['join_char']) } // *********** End User Variables Section ********* // ********* Functions ********* function remove_empty(arr) { var new_arr = []; var j = 0; for (var i = 0; i < Count(arr); i++) { if (!IsEmpty(arr[i]) && arr[i] != '') { new_arr[j++] = arr[i]; } } return new_arr; } // ********* End Functions Section *************** if ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

Key	Value
ID	6
Minimum Client Version	12.1
Evaluation Order	3
Name	CP Traceability
Description	Calculation to automatically populate the CPTraceability attribute
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	cptraceability
Error Number	1012
Error Message	Could not determine CP Traceability
Editable	True
Enabled	False
Exclude From Client	False
Creation Time	2024-04-26 11:17:03
Script	// Assigned To: DHCDevice // Type: Calculation // Name: CP Traceability // Description: Calculation to automatically populate the CPTraceability attribute // Subtypes: All // Field: cptraceability // Is Editable: False // Trigger: Insert // Error Number: 1012 // Error Message: Could not determine CP Traceability // Exclude From Client: False // Batch: False // Severity: None // Disable: True // Evaluation Order: 3 // ************************************* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups and asset types var assigned_to_field = $feature.cptraceability; var cp_override = $feature.cpoverride; var cp_bondedinsulated = $feature.bondedinsulated; var cp_material = $feature.casingmaterial; var valid_asset_groups = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 50, 51, 52]; var asset_groups_always_traceability = [50, 51, 52]; var asset_groups_never_traceability = [15, 16]; var traceable = 1; // Also used for Bonded var not_traceable = 2; // Also used for Insulated // The material field and list of material types and that are conductive var conductive_materials = [0, 1, 18]; var non_conductive_materials = [9]; // ********* End 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 device 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;

Key	Value
ID	7
Minimum Client Version	12.3
Evaluation Order	4
Name	Connection Diameter Inherit Diameter
Description	Auto-populate connection diameter from coincident pipe diameter value
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	connectiondiameter
Error Number	1001
Error Message	Could not inherit connection diameter
Editable	True
Enabled	False
Exclude From Client	False
Creation Time	2024-04-26 11:17:03
Script	// Assigned To: DHCDevice // Type: Calculation // Name: Connection Diameter Inherit Diameter // Description: Auto-populate connection diameter from coincident pipe diameter value // Subtypes: All // Field: connectiondiameter // Is Editable: True // Trigger: Insert // Error Number: 1001 // Error Message: Could not inherit connection diameter // Exclude From Client: False // Batch: False // Severity: None // Disable: True // Evaluation Order: 4 var return_field = $feature.connectiondiameter; if ($feature.assetgroup == 1 \|\| //Pump $feature.assetgroup == 2 \|\| //Flow Valve $feature.assetgroup == 3 \|\| //Controllable Valve $feature.assetgroup == 4 \|\| //Pressure Valve $feature.assetgroup == 5 \|\| //Pressure Regulator $feature.assetgroup == 6 \|\| //Meter $feature.assetgroup == 14 \|\| //Bypass $feature.assetgroup == 17) //Filter { // Create feature set to the intersecting class using the GDB Name var intersecting_line_field = 'nominalpipediameter'; var intersecting_featset = FeatureSetByName($datastore, '{00581CA8-603F-421F-8F0F-4DFAD30F849C}', [intersecting_line_field], false); // Intersect the edited feature with the feature set and retrieve the first feature var intersected_feature = First(Intersects(intersecting_featset, $feature)); // Check to make sure there was an intersected feature, if not, return the original value if (intersected_feature == null) return return_field; // If the intersected feature is null, return the original value if (IsEmpty(intersected_feature[intersecting_line_field])) return return_field; // Return the intersected features value return intersected_feature[intersecting_line_field]; } else return return_field; // rule doesn't apply to this assetgroup. Return the existing value for ConnectionDiameter

Key	Value
ID	8
Minimum Client Version	12.1
Evaluation Order	1
Name	Check Inservice Date
Description	Constraint to verify that Inservice Date is greater than Installation Date
Type	Constraint
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Error Number	103
Error Message	Inservice date cannot be before the Install date
Enabled	False
Exclude From Client	False
Creation Time	2024-04-26 11:17:03
Script	// Assigned To: DHCDevice // Type: Constraint // Name: Check Inservice Date // Description: Constraint to verify that Inservice Date is greater than Installation Date // Subtypes: All // Field: // Is Editable: False // Trigger: Insert // Error Number: 103 // Error Message: Inservice date cannot be before the Install date // Exclude From Client: False // Batch: False // Severity: None // Disable: True // Evaluation Order: 1 function FormatDateAsYearMonthDay(myDate){ //Example: 20200526 return Number(Text(Year(myDate)) + Text((Month(myDate)+1)) + Text(Day(myDate))); } if (IsEmpty($feature.inservicedate)) return true; if (IsEmpty($feature.installdate)) return true; //Inservice Date shouldn't occur before install date. Don't consider Hours, Minutes, Seconds when comparing dates if (FormatDateAsYearMonthDay($feature.inservicedate) <= FormatDateAsYearMonthDay($feature.installdate)){ var message = 'In Service date of ' + $feature.inservicedate + ' can not be before the install date ' + ($feature.installdate); return {'errorMessage': message}; } return true;

Key	Value
ID	9
Minimum Client Version	12.1
Evaluation Order	2
Name	Pump Pressure Constraint
Description	Constraint to verify inlet pressure is greater than outlet pressure
Type	Constraint
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Error Number	105
Error Message	Pump inlet pressure must be less than the outlet pressure
Enabled	False
Exclude From Client	False
Creation Time	2024-04-26 11:17:03
Script	// Assigned To: DHCDevice // Type: Constraint // Name: Pump Pressure Constraint // Description: Constraint to verify inlet pressure is greater than outlet pressure // Subtypes: All // Field: // Is Editable: False // Trigger: Insert // Error Number: 105 // Error Message: Pump inlet pressure must be less than the outlet pressure // Exclude From Client: False // Batch: False // Severity: None // Disable: True // Evaluation Order: 2 if (IsEmpty($feature.inletpressure)) return true; if (IsEmpty($feature.outletpressure)) return true; //Pump Inlet pressure must be less then the outlet pressure if ($feature.inletpressure >= $feature.outletpressure){ var message = 'Inlet Pressure ' + $feature.inletpressure + ' must be less then the Outlet Pressure, ' + $feature.outletpressure; return {'errorMessage': message}; } return true;

Key	Value
ID	10
Minimum Client Version	12.1
Evaluation Order	3
Name	Check Retire Date
Description	Constraint to verify that Retire Date is greater than Installation Date
Type	Constraint
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Error Number	104
Error Message	Retire date cannot be before the Install date
Enabled	False
Exclude From Client	False
Creation Time	2024-04-26 11:17:04
Script	// Assigned To: DHCDevice // Type: Constraint // Name: Check Retire Date // Description: Constraint to verify that Retire Date is greater than Installation Date // Subtypes: All // Field: // Is Editable: False // Trigger: Insert // Error Number: 104 // Error Message: Retire date cannot be before the Install date // Exclude From Client: False // Batch: False // Severity: None // Disable: True // Evaluation Order: 3 function FormatDateAsYearMonthDay(myDate){ //Example: 20200526 return Number(Text(Year(myDate)) + Text((Month(myDate)+1)) + Text(Day(myDate))); } if (IsEmpty($feature.retireddate)) return true; if (IsEmpty($feature.installdate)) return true; //Retired Date must be after installation date. Don't consider Hours, Minutes, Seconds when comparing dates if (FormatDateAsYearMonthDay($feature.retireddate) <= FormatDateAsYearMonthDay($feature.installdate)){ var message = 'Retired date of ' + $feature.retireddate + ' can not be before the install date ' + ($feature.installdate); return {'errorMessage': message}; } return true;

Key	Value
Name	main.DHCDevice__ATTACH
Dataset Type	Table
Dataset ID	234
Minimum Client Version	10.1
Alias	DHCDevice__ATTACH
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	{0D43A8D9-113E-4D96-BFB8-FCDD1096B07A}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

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	created_user	String	Creator	True	255	False	False
created_date	created_date	Date	Created	True	8	False	False
last_edited_user	last_edited_user	String	Editor	True	255	False	False
last_edited_date	last_edited_date	Date	Edited	True	8	False	False

Name	Is Unique	Is Ascending	Field Name
GDB_234_REL_GLOB	False	True	rel_globalid
UUID_50	True	True	globalid
FDO_ATTACHMENTID	True	True	ATTACHMENTID

Key	Value
Name	main.DHCDevice__ATTACHREL
Dataset Type	RelationshipClass
Dataset ID	240
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.DHCDevice
Origin Primary Key	GLOBALID
Origin Foreign Key	REL_GLOBALID
Destination Name	main.DHCDevice__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{FB1D0356-388A-4AB7-B793-F959CFA4FA8E}

Key	Value
Name	main.DHCEdgeObject
Dataset Type	Table
Dataset ID	233
Minimum Client Version	13.2
Alias	DHC Edge Object
OID Field	OBJECTID
GlobalID Field	GLOBALID
Subtype Field	ASSETGROUP
Default Subtype	Unknown
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{E70897EC-0D24-4507-9303-F11E63618065}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Key	Value
utilityNetworkName	main.Network

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
LeakDetectSubnetworkName	LeakDetectSubnetworkName	String	Index	False		Unknown	2000	False	True
SystemSubnetworkName	SystemSubnetworkName	String	Index	False		Unknown	2000	False	True
CirculationSubnetworkName	CirculationSubnetworkName	String	Index	False		Unknown	2000	False	True
PressureSubnetworkName	PressureSubnetworkName	String	Index	False		Unknown	2000	False	True
constructionstatus	Construction Status	Short Integer		True	Construction_Status	6	2	True	False
created_user	created_user	String	Creator	True			255	False	False
created_date	created_date	Date	Created	True			8	False	False
last_edited_user	last_edited_user	String	Editor	True			255	False	False
last_edited_date	last_edited_date	Date	Edited	True			8	False	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False

Name	Is Unique	Is Ascending	Field Name
GDB_233_Pressure	False	True	PressureSubnetworkName
GDB_233_Circulat	False	True	CirculationSubnetworkName
GDB_233_SystemSu	False	True	SystemSubnetworkName
GDB_233_LeakDete	False	True	LeakDetectSubnetworkName
GDB_233_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_233_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_233_CPSubnet	False	True	CPSubnetworkName
UUID_49	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID

Name	Code	Details
Unknown	0

Subtype Name	Field Name	Default Value	Domain Name
Unknown	ASSETTYPE	0	Network_6_UnknownAssetType
Unknown	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Unknown	ISCONNECTED	2	Network_6_IsConnected
Unknown	FLOWDIRECTION	1	Network_6_FlowDirection
Unknown	CPSubnetworkName	Unknown
Unknown	SUPPORTEDSUBNETWORKNAME	Unknown
Unknown	SUPPORTINGSUBNETWORKNAME	Unknown
Unknown	LeakDetectSubnetworkName	Unknown
Unknown	SystemSubnetworkName	Unknown
Unknown	CirculationSubnetworkName	Unknown
Unknown	PressureSubnetworkName	Unknown

Key	Value
Name	main.DHCJunction
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	230
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	DHC Junction
OID Field	OBJECTID
GlobalID Field	GLOBALID
Subtype Field	ASSETGROUP
Default Subtype	Unknown
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	SHAPE
Spatial Reference	RD_New
X-Min	74670.57032500059
X-Max	104587.78457500189
Y-Min	425722.00917500164
Y-Max	445872.6281250017
Z-Min	0
Z-Max	0
Catalog ID	{9062050C-735A-40AC-9193-50B85B1A8AD5}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Key	Value
utilityNetworkName	main.Network

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
LeakDetectSubnetworkName	LeakDetectSubnetworkName	String	Index	False		Unknown	2000	False	True
SystemSubnetworkName	SystemSubnetworkName	String	Index	False		Unknown	2000	False	True
CirculationSubnetworkName	CirculationSubnetworkName	String	Index	False		Unknown	2000	False	True
PressureSubnetworkName	PressureSubnetworkName	String	Index	False		Unknown	2000	False	True
commodity	Commodity	Short Integer		True			2	True	False
designtype	Design Type	Short Integer		True			2	True	False
junctionmaterial	Junction Material	Short Integer		True			2	True	False
insulatingmaterial	Insulating Material	Short Integer		True			2	True	False
diameter1	Diameter1	Double		True			8	True	False
diameter2	Diameter2	Double		True			8	True	False
diameter3	Diameter3	Double		True			8	True	False
diameter4	Diameter4	Double		True			8	True	False
diameterunit	Diameter Unit	Short Integer		True			2	True	False
angle	Angle	Double		True			8	True	False
junctionlength	Length	Double		True			8	True	False
lengthunit	Length Unit	Short Integer		True			2	True	False
volume	Storage Volume	Double		True			8	True	False
volumeunit	Volume Unit	Short Integer		True			2	True	False
tempdifference	Storage Temperature Difference	Double		True			8	True	False
installdate	Install Date	Date		True			8	True	False
inservicedate	Inservice Date	Date		True			8	True	False
retireddate	Retired Abandoned Date	Date		True			8	True	False
manufacturer	Manufacturer	Short Integer		True			2	True	False
manufacturerlotno	Manufacturer Lot#	String		True			10	True	False
manufacturedate	Manufacture Date	Date		True			8	True	False
surfacelocation	Surface Location	Short Integer		True			2	True	False
depth	Depth	Double		True			8	True	False
depthunit	Depth Unit	Short Integer		True			2	True	False
locationdescription	Location Description	String		True			255	True	False
installperson	Install Person	String		True			50	True	False
owner	Owner	Short Integer		True			2	True	False
maintby	Maintained By	Short Integer		True			2	True	False
assetid	Asset ID	String		True			255	True	False
spatialsource	Spatial Source	Short Integer		True			2	True	False
spatialaccuracyxy	Spatial Accuracy XY	Short Integer		True			2	True	False
spatialaccuracyz	Spatial Accuracy Z	Short Integer		True			2	True	False
ldtraceability	Leak Detection Traceability	Short Integer		True			2	True	False
ldoverride	Leak Detection Override	Short Integer		True			2	True	False
bondedinsulated	Bonded/Insulated	Short Integer		True			2	True	False
cptraceability	Cathodic Protection Traceability	Short Integer		True			2	True	False
cpoverride	Cathodic Protection Override	Short Integer		True			2	True	False
constructionstatus	Construction Status	Short Integer		True	Construction_Status	6	2	True	False
created_user	created_user	String	Creator	True			255	False	False
created_date	created_date	Date	Created	True			8	False	False
last_edited_user	last_edited_user	String	Editor	True			255	False	False
last_edited_date	last_edited_date	Date	Edited	True			8	False	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False

Name	Is Unique	Is Ascending	Field Name
GDB_230_CPSubnet	False	True	CPSubnetworkName
GDB_230_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_230_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_230_LeakDete	False	True	LeakDetectSubnetworkName
GDB_230_SystemSu	False	True	SystemSubnetworkName
GDB_230_Circulat	False	True	CirculationSubnetworkName
GDB_230_Pressure	False	True	PressureSubnetworkName
UUID_46	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__DHCJunction_SHAPE	True	True	SHAPE

Name	Code	Details
Unknown	0
Fitting	20
Vent	22
Cooling Chamber	23
Drip Leg	24
Wire Junction	50
Insulation Junction	51

Subtype Name	Subtype Code	Field Name	Default Value	Domain Name
Unknown	0	ASSETTYPE	0	Network_6_UnknownAssetType
Unknown	0	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Unknown	0	ISCONNECTED	2	Network_6_IsConnected
Unknown	0	CPSubnetworkName	Unknown
Unknown	0	SUPPORTEDSUBNETWORKNAME	Unknown
Unknown	0	SUPPORTINGSUBNETWORKNAME	Unknown
Unknown	0	LeakDetectSubnetworkName	Unknown
Unknown	0	SystemSubnetworkName	Unknown
Unknown	0	CirculationSubnetworkName	Unknown
Unknown	0	PressureSubnetworkName	Unknown
Unknown	0	bondedinsulated	0	Bonded_Insulated
Unknown	0	commodity		DHC_Pipe_Commodity
Unknown	0	cpoverride	0	CP_Traceability
Unknown	0	cptraceability	0	CP_Traceability
Unknown	0	depthunit		DHC_UnitsForDepth
Unknown	0	diameterunit	3	DHC_UnitsForDiameter
Unknown	0	ldoverride		LD_Traceability
Unknown	0	ldtraceability	0	LD_Traceability
Unknown	0	lengthunit		DHC_UnitsForLength
Unknown	0	maintby	1	Asset_Manager
Unknown	0	owner	1	Asset_Owner
Unknown	0	spatialaccuracyxy		DHC_SpatialAccuracy
Unknown	0	spatialaccuracyz		DHC_SpatialAccuracy
Unknown	0	spatialsource		Spatial_Source
Unknown	0	angle	0
Unknown	0	diameter1	0
Unknown	0	diameter2	0
Unknown	0	diameter3	0
Unknown	0	diameter4	0
Unknown	0	junctionlength	0
Unknown	0	manufacturer	0
Fitting	20	ASSETTYPE	0	Asset_Type_Junction_DHC_Fitting
Fitting	20	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Fitting	20	ISCONNECTED	2	Network_6_IsConnected
Fitting	20	CPSubnetworkName	Unknown
Fitting	20	SUPPORTEDSUBNETWORKNAME	Unknown
Fitting	20	SUPPORTINGSUBNETWORKNAME	Unknown
Fitting	20	LeakDetectSubnetworkName	Unknown
Fitting	20	SystemSubnetworkName	Unknown
Fitting	20	CirculationSubnetworkName	Unknown
Fitting	20	PressureSubnetworkName	Unknown
Fitting	20	bondedinsulated	0	Bonded_Insulated
Fitting	20	commodity		DHC_Pipe_Commodity
Fitting	20	constructionstatus	6	Construction_Status
Fitting	20	cpoverride	0	CP_Traceability
Fitting	20	cptraceability	0	CP_Traceability
Fitting	20	depthunit		DHC_UnitsForDepth
Fitting	20	diameter1	0	DHC_Pipe_Diameter_Metric
Fitting	20	diameter2	0	DHC_Pipe_Diameter_Metric
Fitting	20	diameter3	0	DHC_Pipe_Diameter_Metric
Fitting	20	diameter4	0	DHC_Pipe_Diameter_Metric
Fitting	20	diameterunit	3	DHC_UnitsForDiameter
Fitting	20	insulatingmaterial		DHC_Junction_Fit_Ins_Material
Fitting	20	junctionmaterial		DHC_Junction_Fitting_Material
Fitting	20	ldoverride		LD_Traceability
Fitting	20	ldtraceability	0	LD_Traceability
Fitting	20	lengthunit		DHC_UnitsForLength
Fitting	20	lifecyclestatus	2	Lifecycle_Status
Fitting	20	maintby	1	Asset_Manager
Fitting	20	manufacturer	0	DHC_Junction_Fitting_Manufacturer
Fitting	20	owner	1	Asset_Owner
Fitting	20	spatialaccuracyxy		DHC_SpatialAccuracy
Fitting	20	spatialaccuracyz		DHC_SpatialAccuracy
Fitting	20	spatialsource		Spatial_Source
Fitting	20	angle	0
Fitting	20	junctionlength	0
Vent	22	ASSETTYPE	0	Asset_Type_Junction_DHC_Vent
Vent	22	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Vent	22	ISCONNECTED	2	Network_6_IsConnected
Vent	22	CPSubnetworkName	Unknown
Vent	22	SUPPORTEDSUBNETWORKNAME	Unknown
Vent	22	SUPPORTINGSUBNETWORKNAME	Unknown
Vent	22	LeakDetectSubnetworkName	Unknown
Vent	22	SystemSubnetworkName	Unknown
Vent	22	CirculationSubnetworkName	Unknown
Vent	22	PressureSubnetworkName	Unknown
Vent	22	bondedinsulated	0	Bonded_Insulated
Vent	22	commodity		DHC_Pipe_Commodity
Vent	22	constructionstatus	6	Construction_Status
Vent	22	cpoverride	0	CP_Traceability
Vent	22	cptraceability	0	CP_Traceability
Vent	22	depthunit		DHC_UnitsForDepth
Vent	22	diameter1	0	DHC_Pipe_Diameter_Metric
Vent	22	diameter2	0	DHC_Pipe_Diameter_Metric
Vent	22	diameter3	0	DHC_Pipe_Diameter_Metric
Vent	22	diameter4	0	DHC_Pipe_Diameter_Metric
Vent	22	diameterunit	3	DHC_UnitsForDiameter
Vent	22	insulatingmaterial		DHC_Junction_Vent_Ins_Material
Vent	22	junctionmaterial		DHC_Junction_Vent_Material
Vent	22	ldoverride		LD_Traceability
Vent	22	ldtraceability	0	LD_Traceability
Vent	22	lengthunit		DHC_UnitsForLength
Vent	22	lifecyclestatus	2	Lifecycle_Status
Vent	22	maintby	1	Asset_Manager
Vent	22	manufacturer	0	DHC_Junction_Vent_Manufacturer
Vent	22	owner	1	Asset_Owner
Vent	22	spatialaccuracyxy		DHC_SpatialAccuracy
Vent	22	spatialaccuracyz		DHC_SpatialAccuracy
Vent	22	spatialsource		Spatial_Source
Vent	22	junctionlength	0
Cooling Chamber	23	ASSETTYPE	0	Asset_Type_Junction_DHC_Cooling_Chamber
Cooling Chamber	23	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Cooling Chamber	23	ISCONNECTED	2	Network_6_IsConnected
Cooling Chamber	23	CPSubnetworkName	Unknown
Cooling Chamber	23	SUPPORTEDSUBNETWORKNAME	Unknown
Cooling Chamber	23	SUPPORTINGSUBNETWORKNAME	Unknown
Cooling Chamber	23	LeakDetectSubnetworkName	Unknown
Cooling Chamber	23	SystemSubnetworkName	Unknown
Cooling Chamber	23	CirculationSubnetworkName	Unknown
Cooling Chamber	23	PressureSubnetworkName	Unknown
Cooling Chamber	23	bondedinsulated	0	Bonded_Insulated
Cooling Chamber	23	commodity		DHC_Pipe_Commodity
Cooling Chamber	23	constructionstatus	6	Construction_Status
Cooling Chamber	23	cpoverride	0	CP_Traceability
Cooling Chamber	23	cptraceability	0	CP_Traceability
Cooling Chamber	23	depthunit		DHC_UnitsForDepth
Cooling Chamber	23	diameter1	0	DHC_Pipe_Diameter_Metric
Cooling Chamber	23	diameter2	0	DHC_Pipe_Diameter_Metric
Cooling Chamber	23	diameter3	0	DHC_Pipe_Diameter_Metric
Cooling Chamber	23	diameter4	0	DHC_Pipe_Diameter_Metric
Cooling Chamber	23	diameterunit	3	DHC_UnitsForDiameter
Cooling Chamber	23	insulatingmaterial		DHC_Junction_Chamber_Ins_Material
Cooling Chamber	23	junctionmaterial		DHC_Junction_Chamber_Material
Cooling Chamber	23	ldoverride		LD_Traceability
Cooling Chamber	23	ldtraceability	0	LD_Traceability
Cooling Chamber	23	lengthunit		DHC_UnitsForLength
Cooling Chamber	23	lifecyclestatus	2	Lifecycle_Status
Cooling Chamber	23	maintby	1	Asset_Manager
Cooling Chamber	23	manufacturer	0	DHC_Junction_Chamber_Manufacturer
Cooling Chamber	23	owner	1	Asset_Owner
Cooling Chamber	23	spatialaccuracyxy		DHC_SpatialAccuracy
Cooling Chamber	23	spatialaccuracyz		DHC_SpatialAccuracy
Cooling Chamber	23	spatialsource		Spatial_Source
Cooling Chamber	23	volumeunit		DHC_UnitsForVolume
Cooling Chamber	23	junctionlength	0
Drip Leg	24	ASSETTYPE	0	Asset_Type_Junction_DHC_Drip_Leg
Drip Leg	24	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Drip Leg	24	ISCONNECTED	2	Network_6_IsConnected
Drip Leg	24	CPSubnetworkName	Unknown
Drip Leg	24	SUPPORTEDSUBNETWORKNAME	Unknown
Drip Leg	24	SUPPORTINGSUBNETWORKNAME	Unknown
Drip Leg	24	LeakDetectSubnetworkName	Unknown
Drip Leg	24	SystemSubnetworkName	Unknown
Drip Leg	24	CirculationSubnetworkName	Unknown
Drip Leg	24	PressureSubnetworkName	Unknown
Drip Leg	24	bondedinsulated	0	Bonded_Insulated
Drip Leg	24	commodity		DHC_Pipe_Commodity
Drip Leg	24	constructionstatus	6	Construction_Status
Drip Leg	24	cpoverride	0	CP_Traceability
Drip Leg	24	cptraceability	0	CP_Traceability
Drip Leg	24	depthunit		DHC_UnitsForDepth
Drip Leg	24	diameter1	0	DHC_Pipe_Diameter_Metric
Drip Leg	24	diameter2	0	DHC_Pipe_Diameter_Metric
Drip Leg	24	diameter3	0	DHC_Pipe_Diameter_Metric
Drip Leg	24	diameter4	0	DHC_Pipe_Diameter_Metric
Drip Leg	24	diameterunit	3	DHC_UnitsForDiameter
Drip Leg	24	insulatingmaterial		DHC_Junction_Drip_Leg_Insulating_Material
Drip Leg	24	junctionmaterial		DHC_Junction_Drip_Leg_Material
Drip Leg	24	ldoverride		LD_Traceability
Drip Leg	24	ldtraceability	0	LD_Traceability
Drip Leg	24	lengthunit		DHC_UnitsForLength
Drip Leg	24	lifecyclestatus	2	Lifecycle_Status
Drip Leg	24	maintby	1	Asset_Manager
Drip Leg	24	manufacturer	0	DHC_Junction_dripleg_Manufacturer
Drip Leg	24	owner	1	Asset_Owner
Drip Leg	24	spatialaccuracyxy		DHC_SpatialAccuracy
Drip Leg	24	spatialaccuracyz		DHC_SpatialAccuracy
Drip Leg	24	spatialsource		Spatial_Source
Drip Leg	24	junctionlength	0
Wire Junction	50	ASSETTYPE	0	Asset_Type_Junction_DHC_Wire_Junction
Wire Junction	50	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Wire Junction	50	ISCONNECTED	2	Network_6_IsConnected
Wire Junction	50	CPSubnetworkName	Unknown
Wire Junction	50	SUPPORTEDSUBNETWORKNAME	Unknown
Wire Junction	50	SUPPORTINGSUBNETWORKNAME	Unknown
Wire Junction	50	LeakDetectSubnetworkName	Unknown
Wire Junction	50	SystemSubnetworkName	Unknown
Wire Junction	50	CirculationSubnetworkName	Unknown
Wire Junction	50	PressureSubnetworkName	Unknown
Wire Junction	50	bondedinsulated	1	Bonded_Insulated
Wire Junction	50	constructionstatus	6	Construction_Status
Wire Junction	50	cpoverride	0	CP_Traceability
Wire Junction	50	cptraceability	1	CP_Traceability
Wire Junction	50	depthunit		DHC_UnitsForDepth
Wire Junction	50	ldoverride		LD_Traceability
Wire Junction	50	ldtraceability	0	LD_Traceability
Wire Junction	50	lifecyclestatus	2	Lifecycle_Status
Wire Junction	50	maintby	1	Asset_Manager
Wire Junction	50	owner	1	Asset_Owner
Wire Junction	50	spatialaccuracyxy		DHC_SpatialAccuracy
Wire Junction	50	spatialaccuracyz		DHC_SpatialAccuracy
Wire Junction	50	spatialsource		Spatial_Source
Wire Junction	50	manufacturer	0
Insulation Junction	51	ASSETTYPE	0	Asset_Type_Junction_DHC_Insulation_Junction
Insulation Junction	51	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Insulation Junction	51	ISCONNECTED	2	Network_6_IsConnected
Insulation Junction	51	CPSubnetworkName	Unknown
Insulation Junction	51	SUPPORTEDSUBNETWORKNAME	Unknown
Insulation Junction	51	SUPPORTINGSUBNETWORKNAME	Unknown
Insulation Junction	51	LeakDetectSubnetworkName	Unknown
Insulation Junction	51	SystemSubnetworkName	Unknown
Insulation Junction	51	CirculationSubnetworkName	Unknown
Insulation Junction	51	PressureSubnetworkName	Unknown
Insulation Junction	51	bondedinsulated	1	Bonded_Insulated
Insulation Junction	51	constructionstatus	6	Construction_Status
Insulation Junction	51	cpoverride	0	CP_Traceability
Insulation Junction	51	cptraceability	1	CP_Traceability
Insulation Junction	51	depthunit		DHC_UnitsForDepth
Insulation Junction	51	ldoverride		LD_Traceability
Insulation Junction	51	ldtraceability	0	LD_Traceability
Insulation Junction	51	lifecyclestatus	2	Lifecycle_Status
Insulation Junction	51	maintby	1	Asset_Manager
Insulation Junction	51	owner	1	Asset_Owner
Insulation Junction	51	spatialaccuracyxy		DHC_SpatialAccuracy
Insulation Junction	51	spatialaccuracyz		DHC_SpatialAccuracy
Insulation Junction	51	spatialsource		Spatial_Source
Insulation Junction	51	manufacturer	0

Key	Value
ID	12
Minimum Client Version	12.3
Evaluation Order	1
Name	Containment Association
Description	Calculate the containment association between the content and the container
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	assetid
Error Number	1010
Error Message	Could not create containment association
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2024-04-26 11:17:07
Script	// Assigned To: DHCJunction // Type: Calculation // Name: Containment Association // Description: Calculate the containment association between the content and the container // Subtypes: All // Field: assetid // Is Editable: True // Trigger: Insert // Error Number: 1010 // Error Message: Could not create containment association // Exclude From Client: True // Batch: False // Severity: None // Disable: True // Evaluation Order: 1 // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation var assigned_to_field = $feature.assetid; // Meters var search_distance = 5; var search_unit = 9001; // Feet //var search_distance = 15; //var search_unit = 9002; // ********* End User Variables Section ******** // ********* Functions ********* function sortCandidates(a, b) { if (a['distance'] < b['distance']) return -1; if (a['distance'] > b['distance']) return 1; return 0; } function class_id_to_name(id) { if (id == 4 \|\| id == '4') { return 'StructureJunction'; } else if (id == 5 \|\| id == '5') { return 'StructureLine'; } else if (id == 6 \|\| id == '6') { return 'StructureBoundary'; } else if (id == 9 \|\| id == '9') { return 'DHCDevice'; } else if (id == 10 \|\| id == '10') { return 'DHCLine'; } else if (id == 11 \|\| id == '11') { return 'DHCAssembly'; } else if (id == 12 \|\| id == '12') { return 'DHCJunction'; } else { return id; } } function get_featureset_from_classname(class_name, fields, include_geometry) { var class_name = Split(class_name, '.')[-1]; var feature_set = null; if (class_name == 'DHCDevice') { feature_set = FeatureSetByName($datastore, '{C1EF4146-352E-4D6A-B613-139BFE462CC8}', fields, include_geometry); } else if (class_name == 'DHCJunction') { feature_set = FeatureSetByName($datastore, '{9062050C-735A-40AC-9193-50B85B1A8AD5}', fields, include_geometry); } else if (class_name == 'DHCAssembly') { feature_set = FeatureSetByName($datastore, '{58BAAD67-CF7C-4A5A-9601-C309220FAF47}', fields, include_geometry); } else if (class_name == 'DHCLine') { feature_set = FeatureSetByName($datastore, '{00581CA8-603F-421F-8F0F-4DFAD30F849C}', fields, include_geometry); } else if (class_name == 'StructureJunction') { feature_set = FeatureSetByName($datastore, '{32CEC08A-A271-4D12-B63A-B3A08979DA00}', fields, include_geometry); } else if (class_name == 'StructureLine') { feature_set = FeatureSetByName($datastore, '{70FDE1BD-688D-400B-B5B4-D273C7D268A8}', fields, include_geometry); } else if (class_name == 'StructureBoundary') { feature_set = FeatureSetByName($datastore, '{5C0EA9EE-FEFF-4335-8667-A920BA47BFD9}', fields, include_geometry); } else if (class_name == 'Rules') { feature_set = FeatureSetByName($datastore, '{E996AEA0-3BB7-477B-9BA2-B11F43F989B6}', fields, false); } else { feature_set = FeatureSetByName($datastore, '{5C0EA9EE-FEFF-4335-8667-A920BA47BFD9}', fields, include_geometry); } return feature_set; } function build_containers_info() { var rule_fields = ['OBJECTID', 'RULETYPE', 'FROMNETWORKSOURCEID', 'FROMASSETGROUP', 'FROMASSETTYPE', 'FROMTERMINALID', 'TONETWORKSOURCEID', 'TOASSETGROUP', 'TOASSETTYPE', 'TOTERMINALID', 'VIANETWORKSOURCEID', 'VIAASSETGROUP', 'VIAASSETTYPE', 'VIATERMINALID', 'CREATIONDATE', 'GLOBALID'] var rules_fs = get_featureset_from_classname('Rules', rule_fields, false); var containment_sql = 'RULETYPE = 2' var feature_sql = 'TOASSETGROUP = ' + $feature.assetgroup + ' and TOASSETTYPE = ' + $feature.assettype; var containers_rows = Filter(rules_fs, containment_sql + ' and ' + feature_sql); var container_row_count = Count(containers_rows) if (container_row_count == 0) { return null; } var container_class_types = {}; for (var container_row in containers_rows) { var class_name = class_id_to_name(container_row['FROMNETWORKSOURCEID']); if (HasKey(container_class_types, class_name) == false) { container_class_types[class_name] = {}; } var asset_group = Text(container_row['FROMASSETGROUP']) if (HasKey(container_class_types[class_name], asset_group) == false) { container_class_types[class_name][asset_group] = []; } var asset_type = Text(container_row['FROMASSETTYPE']) if (IndexOf(container_class_types[class_name][asset_group], asset_type) == -1) { var at_cnt = Count(container_class_types[class_name][asset_group]) container_class_types[class_name][asset_group][at_cnt] = asset_type; } } return container_class_types } function build_sql(container_info, feat_global_id) { var sql_class = []; var i = 0; for (var cls in container_info) { var sub_where = []; var k = 0; for (var ag in container_info[cls]) { sub_where[k++] = "(AssetGroup = " + ag + " AND AssetType IN (" + Concatenate(container_info[cls][ag], ',') + '))' } sql_class[i++] = [cls, '(' + Concatenate(sub_where, ' OR ') + ") and GLOBALID <> '" + feat_global_id + "'"]; } return sql_class } function generate_candidates(feature, sql_by_class, search_shape) { var container_candidate = []; var k = 0; for (var i = 0; i < Count(sql_by_class); i++) { var class_name = sql_by_class[i][0]; var where = sql_by_class[i][1]; var fs = get_featureset_from_classname(class_name, ['GLOBALID'], false); var container_features = Filter(Intersects(fs, search_shape), where); var cont_feat_count = Count(container_features); if (cont_feat_count > 0) { for (var feat in container_features) { container_candidate[k++] = { 'class_name': class_name, 'globalid': feat.globalid, 'distance': Distance(feature, feat, search_unit) } } } } return container_candidate; } // Function to check if a bit is in an int value function has_bit(num, test_value) { // num = number to test if it contains a bit // test_value = the bit value to test for // determines if num has the test_value bit set // Equivalent to num AND test_value == test_value // first we need to determine the bit position of test_value var bit_pos = -1; for (var i = 0; i < 64; i++) { // equivalent to test_value >> 1 var test_value = Floor(test_value / 2); bit_pos++; if (test_value == 0) break; } // now that we know the bit position, we shift the bits of // num until we get to the bit we care about for (var i = 1; i <= bit_pos; i++) { var num = Floor(num / 2); } if (num % 2 == 0) { return false } else { return true } } // ********* End Functions Section *************** // Uncomment this section if this rule is enabled for an update trigger. If the feature is already content, return /* if (has_bit($feature.ASSOCIATIONSTATUS, 4) \|\| has_bit($feature.ASSOCIATIONSTATUS, 16)) { return assigned_to_field; } */ //Ensure AssetGroup and AssetType fields are populated. if (IsEmpty($feature.assetgroup)) return assigned_to_field; if (IsEmpty($feature.assettype)) return assigned_to_field; //Query the rules table to get all containment records var container_info = build_containers_info(); if (IsEmpty(container_info)) return assigned_to_field; var sql_by_class = build_sql(container_info, $feature.globalid); var search_shape = Buffer(Geometry($feature), search_distance, search_unit); var candidates = generate_candidates($feature, sql_by_class, search_shape) if (Count(candidates) == 0) return assigned_to_field; var sorted_candidates = Sort(candidates, sortCandidates); //When the closest container is a StructureBoundary feature, the device/junction must be contained within extent of it's polygon. var candidateClassName = sorted_candidates[0]['class_name']; if (candidateClassName == "StructureBoundary"){ var candidateGlobalid = sorted_candidates[0]['globalid']; var fsBoundary = get_featureset_from_classname(candidateClassName, ['GLOBALID'], true); var boundary_features = Intersects(fsBoundary, $feature); var filtered_feature = Filter(boundary_features, "globalid = @candidateGlobalid"); if (Count(filtered_feature) == 0) // didn't find the candidate boundary feature. return assigned_to_field; } var edit_payload = [{ 'className': sorted_candidates[0]['class_name'], 'updates': [{ 'globalID': sorted_candidates[0]['globalid'], 'associationType': 'container' }] }]; return {"result": assigned_to_field, "edit": edit_payload};

Key	Value
ID	13
Minimum Client Version	12.9
Evaluation Order	2
Name	GenerateIDs-DHCJ
Description	Generate IDs for DHCJunction using database sequences
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Field Name	assetid
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:07
Script	// Assigned To: DHCJunction // Type: Calculation // Name: GenerateIDs-DHCJ // Description: Generate IDs for DHCJunction using database sequences // Subtypes: All // Field: assetid // Evaluation Order: 2 // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules are rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated In: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - GenerateIDs-SJ // - GenerateIDs-SB // - GenerateIDs-SL // - GenerateIDs-DHCD // - GenerateIDs-DHCA // - GenerateIDs-DHCL // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'assetid', 'assetgroup'); // 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('DHC_J_Fttng_20_seq'); }else if (selector_value_txt == '22') { id_format = { 'prefix': "Vnt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_J_Vnt_22_seq'); }else if (selector_value_txt == '23') { id_format = { 'prefix': "Clng-Chmbr", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_J_Clng_Chmbr_23_seq'); }else if (selector_value_txt == '24') { id_format = { 'prefix': "Drp-Lg", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_J_Drp_Lg_24_seq'); }else if (selector_value_txt == '50') { id_format = { 'prefix': "Wr-JCT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_J_Wr_JCT_50_seq'); }else if (selector_value_txt == '51') { id_format = { 'prefix': "Insltn-JCT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('DHC_J_Insltn_JCT_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 ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

Key	Value
ID	14
Minimum Client Version	12.1
Evaluation Order	3
Name	CP Traceability
Description	Set Traceability flag for junction assets
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Field Name	cptraceability
Error Number	1012
Error Message	CPTraceability attribute rule generated and error
Editable	True
Enabled	False
Exclude From Client	False
Creation Time	2024-04-26 11:17:07
Script	// Assigned To: DHCJunction // Type: Calculation // Name: CP Traceability // Description: Set Traceability flag for junction assets // Subtypes: All // Field: cptraceability // Is Editable: True // Trigger: Insert // Error Number: 1012 // Error Message: CPTraceability attribute rule generated and error // Exclude From Client: False // Batch: False // Severity: None // Disable: True // Evaluation Order: 3 // ************************************* // 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: These values do 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.junctionmaterial; // Limit the rule to valid asset groups and asset types var valid_asset_groups = [20, 22, 23, 24, 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 included 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 // The material field and list of material types and that are conductive // Implementation Note: These do not need to be adjusted unless the value of the asset type attribute domains were changed. var conductive_materials = [1, 2, 3, 4, 5]; // 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 = [9, 10, 11, 12]; // *********** End 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 device 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;

Domains

Key	Value
Name	main.DHCJunction__ATTACH
Dataset Type	Table
Dataset ID	235
Minimum Client Version	10.1
Alias	DHCJunction__ATTACH
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	{97AB44D3-1209-453F-9501-351B5A3B517F}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Name	Is Unique	Is Ascending	Field Name
GDB_235_REL_GLOB	False	True	rel_globalid
UUID_51	True	True	globalid
FDO_ATTACHMENTID	True	True	ATTACHMENTID

Key	Value
Name	main.DHCJunction__ATTACHREL
Dataset Type	RelationshipClass
Dataset ID	241
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.DHCJunction
Origin Primary Key	GLOBALID
Origin Foreign Key	REL_GLOBALID
Destination Name	main.DHCJunction__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{0AC4726D-CA7D-47FA-B7E5-31862C5A6A3E}

Key	Value
Name	main.DHCJunctionObject
Dataset Type	Table
Dataset ID	232
Minimum Client Version	13.2
Alias	DHC Junction Object
OID Field	OBJECTID
GlobalID Field	GLOBALID
Subtype Field	ASSETGROUP
Default Subtype	Unknown
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{CBC75684-1E2F-4A6B-BC93-8EFF88668759}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Name	Is Unique	Is Ascending	Field Name
GDB_232_Pressure	False	True	PressureSubnetworkName
GDB_232_Circulat	False	True	CirculationSubnetworkName
GDB_232_SystemSu	False	True	SystemSubnetworkName
GDB_232_LeakDete	False	True	LeakDetectSubnetworkName
GDB_232_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_232_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_232_CPSubnet	False	True	CPSubnetworkName
GDB_232_SUBNETWO	False	True	SUBNETWORKCONTROLLERNAME
UUID_48	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID

Key	Value
Name	main.DHCLine
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	228
Geometry Type	Polyline
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	DHC Line
OID Field	OBJECTID
GlobalID Field	GLOBALID
Subtype Field	ASSETGROUP
Default Subtype	Unknown
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	SHAPE
Spatial Reference	RD_New
X-Min	74670.57032500059
X-Max	104587.78457500189
Y-Min	425722.00917500164
Y-Max	445872.6281250017
Z-Min	0
Z-Max	0
Catalog ID	{00581CA8-603F-421F-8F0F-4DFAD30F849C}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Name	Is Unique	Is Ascending	Field Name
GDB_228_CPSubnet	False	True	CPSubnetworkName
GDB_228_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_228_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_228_LeakDete	False	True	LeakDetectSubnetworkName
GDB_228_SystemSu	False	True	SystemSubnetworkName
GDB_228_Circulat	False	True	CirculationSubnetworkName
GDB_228_Pressure	False	True	PressureSubnetworkName
UUID_44	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__DHCLine_SHAPE	True	True	SHAPE

Name	Code	Details
Unknown	0
Service Pipe	1
Distribution Pipe	2
Transmission Pipe	3
Station Pipe	5
Customer Pipe	6
Sensing Pipe	8
Bonding Line	50
Test Lead Wire	51
Rectifier Cable	52

Key	Value
Name	main.DHCLine__ATTACH
Dataset Type	Table
Dataset ID	236
Minimum Client Version	10.1
Alias	DHCLine__ATTACH
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	{B505321A-6BF1-4318-B4CA-AF885D5B7030}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Name	Is Unique	Is Ascending	Field Name
GDB_236_REL_GLOB	False	True	rel_globalid
UUID_52	True	True	globalid
FDO_ATTACHMENTID	True	True	ATTACHMENTID

Key	Value
Name	main.DHCLine__ATTACHREL
Dataset Type	RelationshipClass
Dataset ID	242
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.DHCLine
Origin Primary Key	GLOBALID
Origin Foreign Key	REL_GLOBALID
Destination Name	main.DHCLine__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{59261075-C7DD-4AE9-A8BD-5915D45AE556}

Key	Value
Name	main.DHCSubnetLine
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	231
Geometry Type	Polyline
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	DHC Subnet Line
OID Field	OBJECTID
GlobalID Field	GLOBALID
Subtype Field	TIERNAME
Default Subtype	Unknown
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	SHAPE
Spatial Reference	RD_New
X-Min	74670.57032500059
X-Max	104587.78457500189
Y-Min	425722.00917500164
Y-Max	445872.6281250017
Z-Min	0
Z-Max	0
Catalog ID	{532B89FA-1543-4D22-93E4-AB423A0F0C03}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

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

Name	Code	Details
Unknown	0
DHC Cathodic Protection	1
DHC Leak Detection	2
DHC Energy System	3
DHC Circulation	4
DHC Pressure	5

Subtype Name	Subtype Code	Field Name	Default Value	Domain Name
Unknown	0	SUBNETWORKNAME	Unknown
Unknown	0	ISDIRTY	1	Network_6_IsDirty
Unknown	0	SUBNETWORKCONTROLLERNAMES	Unknown
DHC Cathodic Protection	1	SUBNETWORKNAME	Unknown
DHC Cathodic Protection	1	ISDIRTY	1	Network_6_IsDirty
DHC Cathodic Protection	1	SUBNETWORKCONTROLLERNAMES	Unknown
DHC Leak Detection	2	SUBNETWORKNAME	Unknown
DHC Leak Detection	2	ISDIRTY	1	Network_6_IsDirty
DHC Leak Detection	2	SUBNETWORKCONTROLLERNAMES	Unknown
DHC Energy System	3	SUBNETWORKNAME	Unknown
DHC Energy System	3	ISDIRTY	1	Network_6_IsDirty
DHC Energy System	3	SUBNETWORKCONTROLLERNAMES	Unknown
DHC Circulation	4	SUBNETWORKNAME	Unknown
DHC Circulation	4	ISDIRTY	1	Network_6_IsDirty
DHC Circulation	4	SUBNETWORKCONTROLLERNAMES	Unknown
DHC Pressure	5	SUBNETWORKNAME	Unknown
DHC Pressure	5	ISDIRTY	1	Network_6_IsDirty
DHC Pressure	5	SUBNETWORKCONTROLLERNAMES	Unknown

Domain Network Name	Domain Network Alias	Domain Network ID	Tier Definition	Subnetwork Controller Type	Creation Time
Structure	Structure	1	None		2024-04-26 11:12:51
DHC	DHC	2	Hierarchical	Source	2024-04-26 11:14:01

Domain Network Name	Tier Group Name	Creation Time
DHC	DHC Cathodic Protection	2024-04-26 11:14:09
DHC	DHC Leak Detection	2024-04-26 11:14:09
DHC	DHC Pipe System	2024-04-26 11:14:09

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
DHC	DHC Cathodic Protection	DHC Cathodic Protection	1	1	Mesh	True	CPSubnetworkName	Without Eventing	Without Eventing	True	True	False	True	2024-04-26 11:14:09
DHC	DHC Leak Detection	DHC Leak Detection	2	1	Mesh	True	LeakDetectSubnetworkName	Without Eventing	Without Eventing	True	True	False	True	2024-04-26 11:14:09
DHC	DHC Pipe System	DHC Energy System	3	1	Mesh	True	SystemSubnetworkName	Without Eventing	Without Eventing	True	True	False	True	2024-04-26 11:14:09
DHC	DHC Pipe System	DHC Circulation	4	2	Mesh	True	CirculationSubnetworkName	Without Eventing	Without Eventing	True	True	False	True	2024-04-26 11:14:09
DHC	DHC Pipe System	DHC Pressure	5	2	Mesh	True	PressureSubnetworkName	Without Eventing	Without Eventing	True	True	False	True	2024-04-26 11:14:09

Tier Name	Network Attribute / Category	Operator	Value	Combine Using Or
DHC Cathodic Protection	Cathodic Protection Traceability	Equal	2	False
DHC Leak Detection	Leak Detection Traceability	Equal	2	False
DHC Energy System	Lifecycle Status	Does Not Include Any	6	True
DHC Energy System	DHC:Device Status	Equal	2	True
DHC Energy System	Category	Equal	CP Only	True
DHC Energy System	Category	Equal	Leak Detection Only	False
DHC Circulation	Lifecycle Status	Does Not Include Any	6	True
DHC Circulation	DHC:Device Status	Equal	2	True
DHC Circulation	Category	Equal	CP Only	True
DHC Circulation	Category	Equal	Leak Detection Only	False
DHC Pressure	Lifecycle Status	Does Not Include Any	6	True
DHC Pressure	DHC:Device Status	Equal	2	True
DHC Pressure	Category	Equal	Heat Exchanger	True
DHC Pressure	Category	Equal	CP Only	True
DHC Pressure	Category	Equal	Leak Detection Only	False

Domain Network Name	Source Name	Table	Usage Type	Source ID	# of Asset Groups	# of Asset Types
Structure	StructureJunction	main.StructureJunction	Structure Junction	4	8	26
Structure	StructureBoundary	main.StructureBoundary	Structure Boundary	6	5	13
Structure	StructureJunctionObject	main.StructureJunctionObject	Structure Junction Object	7	1	1
Structure	StructureLine	main.StructureLine	Structure Line	5	5	13
Structure	StructureEdgeObject	main.StructureEdgeObject	Structure Edge Object	8	1	1
DHC	DHCDevice	main.DHCDevice	Device	9	22	69
DHC	DHCAssembly	main.DHCAssembly	Assembly	11	4	15
DHC	DHCJunction	main.DHCJunction	Junction	12	7	34
DHC	DHCJunctionObject	main.DHCJunctionObject	Junction Object	14	1	1
DHC	DHCLine	main.DHCLine	Line	10	10	54
DHC	DHCSubnetLine	main.DHCSubnetLine	Subnet Line	13	6	0
DHC	DHCEdgeObject	main.DHCEdgeObject	Edge Object	15	1	1

Source Name	Asset Group Name	Asset Group Code	# of Asset Types	Creation Time
StructureJunction	Unknown	0	1	2024-04-26 11:12:52
StructureJunction	Pipe Anchor	2	2	2024-04-26 11:14:16
StructureJunction	Pipe Support	3	3	2024-04-26 11:14:16
StructureJunction	Pipe Hanger	4	4	2024-04-26 11:14:16
StructureJunction	Pipe Access Point	10	2	2024-04-26 11:14:16
StructureJunction	DHC Guide	706	3	2024-04-26 11:14:16
StructureJunction	DHC Pipe Box	707	9	2024-04-26 11:14:16
StructureJunction	DHC Pillar	708	2	2024-04-26 11:14:16
StructureBoundary	Unknown	0	1	2024-04-26 11:12:52
StructureBoundary	Pipe Station	1	3	2024-04-26 11:14:21
StructureBoundary	Pipe Vault	2	2	2024-04-26 11:14:21
StructureBoundary	Pipe Customer Building	4	5	2024-04-26 11:14:21
StructureBoundary	DHC Protection Plate	702	2	2024-04-26 11:14:21
StructureJunctionObject	Unknown	0	1	2024-04-26 11:12:52
StructureLine	Unknown	0	1	2024-04-26 11:12:52
StructureLine	Pipe Casing	1	4	2024-04-26 11:14:25
StructureLine	DHC Tunnel	701	3	2024-04-26 11:14:25
StructureLine	DHC Trench	702	3	2024-04-26 11:14:25
StructureLine	DHC Communication Conduit	703	2	2024-04-26 11:14:25
StructureEdgeObject	Unknown	0	1	2024-04-26 11:12:52
DHCDevice	Unknown	0	1	2024-04-26 11:14:03
DHCDevice	Pump	1	6	2024-04-26 11:14:39
DHCDevice	Flow Valve	2	2	2024-04-26 11:14:39
DHCDevice	Controllable Valve	3	6	2024-04-26 11:14:39
DHCDevice	Pressure Valve	4	6	2024-04-26 11:14:39
DHCDevice	Pressure Regulator	5	2	2024-04-26 11:14:39
DHCDevice	Meter	6	3	2024-04-26 11:14:39
DHCDevice	Trap	7	2	2024-04-26 11:14:39
DHCDevice	Monitoring	8	4	2024-04-26 11:14:39
DHCDevice	Heat Exchanger	9	3	2024-04-26 11:14:39
DHCDevice	Production Unit	10	3	2024-04-26 11:14:39
DHCDevice	Chiller	11	4	2024-04-26 11:14:39
DHCDevice	Service Connection	12	2	2024-04-26 11:14:39
DHCDevice	Well	13	3	2024-04-26 11:14:39
DHCDevice	Bypass	14	2	2024-04-26 11:14:39
DHCDevice	Leak Detection Panel	15	2	2024-04-26 11:14:39
DHCDevice	Leak Detection Test Point	16	2	2024-04-26 11:14:39
DHCDevice	Filter	17	2	2024-04-26 11:14:39
DHCDevice	Tank	18	3	2024-04-26 11:14:39
DHCDevice	Anode	50	3	2024-04-26 11:14:39
DHCDevice	Rectifier	51	2	2024-04-26 11:14:39
DHCDevice	Test Point	52	6	2024-04-26 11:14:39
DHCAssembly	Unknown	0	1	2024-04-26 11:14:03
DHCAssembly	Station	1	9	2024-04-26 11:15:10
DHCAssembly	Well Pad	2	3	2024-04-26 11:15:10
DHCAssembly	Fitting Assembly	3	2	2024-04-26 11:15:10
DHCJunction	Unknown	0	1	2024-04-26 11:14:03
DHCJunction	Fitting	20	21	2024-04-26 11:15:15
DHCJunction	Vent	22	3	2024-04-26 11:15:15
DHCJunction	Cooling Chamber	23	2	2024-04-26 11:15:15
DHCJunction	Drip Leg	24	2	2024-04-26 11:15:15
DHCJunction	Wire Junction	50	3	2024-04-26 11:15:15
DHCJunction	Insulation Junction	51	2	2024-04-26 11:15:15
DHCJunctionObject	Unknown	0	1	2024-04-26 11:14:03
DHCLine	Unknown	0	1	2024-04-26 11:14:03
DHCLine	Service Pipe	1	7	2024-04-26 11:15:27
DHCLine	Distribution Pipe	2	7	2024-04-26 11:15:27
DHCLine	Transmission Pipe	3	7	2024-04-26 11:15:27
DHCLine	Station Pipe	5	7	2024-04-26 11:15:27
DHCLine	Customer Pipe	6	7	2024-04-26 11:15:27
DHCLine	Sensing Pipe	8	2	2024-04-26 11:15:27
DHCLine	Bonding Line	50	3	2024-04-26 11:15:27
DHCLine	Test Lead Wire	51	11	2024-04-26 11:15:27
DHCLine	Rectifier Cable	52	2	2024-04-26 11:15:27
DHCSubnetLine	Unknown	0	0	2024-04-26 11:14:03
DHCSubnetLine	DHC Cathodic Protection	1	0	2024-04-26 11:14:16
DHCSubnetLine	DHC Leak Detection	2	0	2024-04-26 11:14:16
DHCSubnetLine	DHC Energy System	3	0	2024-04-26 11:14:16
DHCSubnetLine	DHC Circulation	4	0	2024-04-26 11:14:16
DHCSubnetLine	DHC Pressure	5	0	2024-04-26 11:14:16
DHCEdgeObject	Unknown	0	1	2024-04-26 11:14:03

Category Name	Creation Time
Subnetwork Controller	2024-04-26 11:12:51
Subnetwork Tap	2024-04-26 11:12:51
Attribute Substitution	2024-04-26 11:12:51
CP Only	2024-04-26 11:15:52
DHC Isolating	2024-04-26 11:15:52
Leak Detection Only	2024-04-26 11:15:52
MetalPipe	2024-04-26 11:15:52
Heat Exchanger	2024-04-26 11:15:52

Configuration Name	Configuration ID	Traversability Model	Default	Creation Time
Single terminal	0	Bidirectional	All	2024-04-26 11:12:51
Flow Direction	2	Directional	All	2024-04-26 11:15:52
Pressure Reducing	3	Directional	All	2024-04-26 11:15:52
Pressure Increasing	4	Directional	All	2024-04-26 11:15:52
Pipe Directional Dual Terminal	5	Directional	All	2024-04-26 11:15:52
Pipe Bidirectional Dual Terminal	6	Bidirectional	All	2024-04-26 11:15:52
Terminal Block	7	Bidirectional	All	2024-04-26 11:15:52
Bypass Device	8	Directional	Outflow Only	2024-04-26 11:15:52
Exchanger Device	9	Directional	All	2024-04-26 11:15:52

Configuration Name	Path Name	Path ID	Path Description
Bypass Device	Outflow Only	2	Inflow-Outflow
Bypass Device	Bypass Only	3	Inflow-Bypass
Bypass Device	Outflow and Bypass	4	Inflow-Outflow,Inflow-Bypass

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	2024-04-26 11:12:51
Terminal ID	2	Terminal ID	Integer	Short Integer	False		False	False	7	0	3	4	2024-04-26 11:12:51
Asset group	3	Asset Group	Integer	Short Integer	True		False	False	7	10	5	6	2024-04-26 11:12:51
Asset type	4	Asset Type	Integer	Short Integer	True		False	False	17	10	7	8	2024-04-26 11:12:51
Is subnetwork controller	5	Is Subnetwork Controller	Integer	Short Integer	True		False	False	27	1	9	10	2024-04-26 11:12:51
Tier name	6	Tier Name	Integer	Short Integer	True		False	False	28	6	11	12	2024-04-26 11:12:51
Shape length	7	Shape Length	Double	Double	False		False	True	34	0	13	14	2024-04-26 11:12:51
Position from	8	Position From	Double	Double	False		False	False	34	0	15	16	2024-04-26 11:12:51
Position to	9	Position To	Double	Double	False		False	False	34	0	17	18	2024-04-26 11:12:51
Flow direction	10	Flow Direction	Integer	Short Integer	True		False	False	34	2	19	20	2024-04-26 11:12:51
Accessible	11	Unknown	Integer	Short Integer	False		True	False	0	0	21	22	2024-04-26 11:15:52
Cathodic Protection Traceability	12	Unknown	Integer	Short Integer	False		True	False	0	0	23	24	2024-04-26 11:15:52
Commodity	13	Unknown	Integer	Short Integer	False		True	False	0	0	25	26	2024-04-26 11:15:52
DHC:Device Status	14	Unknown	Integer	Short Integer	True	DHC_DeviceStatus	True	False	36	2	27	28	2024-04-26 11:15:52
DHC:Pipe Surface Area	15	Unknown	Double	Double	False		True	True	0	0	29	30	2024-04-26 11:15:52
DHC:Pipe Volume	16	Unknown	Double	Double	False		True	True	0	0	31	32	2024-04-26 11:15:52
Install Date	17	Unknown	Double	Date	False		True	False	0	0	33	34	2024-04-26 11:15:52
Leak Detection Traceability	18	Unknown	Integer	Short Integer	False		True	False	0	0	35	36	2024-04-26 11:15:52
Lifecycle Status	19	Unknown	Integer	Short Integer	True	Lifecycle_Combined	False	False	39	3	37	38	2024-04-26 11:15:52
Line Material	20	Unknown	Integer	Short Integer	False		True	False	0	0	39	40	2024-04-26 11:15:52
Construction Status	21	Unknown	Integer	Short Integer	False		True	False	0	0	41	42	2024-04-26 11:15:52

Key	Value
Name	main.OffsetDimensions
Dataset Type	FeatureClass
Dataset ID	238
Geometry Type	Polygon
Feature Type	Dimension
Z-Aware	False
M-Aware	False
Split Model	Update Insert
Minimum Client Version	12.3
Alias	Offset Dimensions
OID Field	OBJECTID
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	RD_New
X-Min	89880.61360000074
X-Max	90046.56439999864
Y-Min	436052.9908000007
Y-Max	436350.5384999998
Catalog ID	{DC21882B-DA17-4DB4-8A8C-6DAABA8FF47F}
Class ID	{8C0ECA0E-F66E-474C-855F-6542701E8009}
Extension Class ID	{A6280912-4D2F-49C0-AD2E-A4E625798BC8}

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	ServiceArea
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	RD_New
X-Min	76030.44370000064
X-Max	103227.91120000184
Y-Min	426637.94640000165
Y-Max	444956.6909000017
Z-Min	0
Z-Max	0
Catalog ID	{DFC9445B-8D44-4A04-949B-31BB9B304303}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Name	Is Unique	Is Ascending	Field Name
UUID_9	True	True	globalid
FDO_OBJECTID	True	True	OBJECTID
st_spindex__ServiceTerritory_shape	True	True	shape

Name	Is Unique	Is Ascending	Field Name
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_40_SUBNETWOR	False	True	SUBNETWORKNAME
UUID_42	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID