Communications_UtilityNetwork

Workspace

Key	Value
Name	Communications_UtilityNetwork.geodatabase
Workspace Type	Local Database
Workspace Factory	Sqlite
Geodatabase Release	3.0.0
Date Exported	2025-06-09 12:47:48
Path

Domain Name	Description	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
Asset_Manager	The manager of the asset	Short Integer	Coded Value	Duplicate	Default Value	3	97
Asset_Owner	The owner of the asset	Short Integer	Coded Value	Duplicate	Default Value	3	97
Asset_Type_Communications_Device_Access_Cable_Components	Devices used on cables in Access Network	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Communications_Device_Distribution_Cable_Components	Devices used on cables in Distribution Network	Short Integer	Coded Value	Duplicate	Default Value	9	1
Asset_Type_Communications_Device_Drop_Cable_Components	Devices used on cables in Drop Network	Short Integer	Coded Value	Duplicate	Default Value	8	1
Asset_Type_Communications_Device_Indoor_Cable_Components	Devices used on cables in Indoor Network	Short Integer	Coded Value	Duplicate	Default Value	8	1
Asset_Type_Communications_Device_National_Cable_Components	Devices used on cables in National Network	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Communications_Device_Regional_Cable_Components	Devices used on cables in Regional Network	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Communications_Device_Submarine_Cable_Components	Devices used on cables in Submarine Network	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_Device_Wireless_Components	Devices used on cables in Wireless Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Communications_EdgeObject_Link	Non-spatial Links between connector	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_EdgeObject_Strand	Non-spatial Strands	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_EdgeObject_Wireless	Non-spatial Wireless links	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Communications_Junction_Connection_Point	Junction Deatures used as connections to attach or contain cables in/on structures	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_JunctionObject_Antenna	Objects used in the wireless network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Communications_JunctionObject_Chassis	Objects used to contain main equipment	Short Integer	Coded Value	Duplicate	Default Value	12	1
Asset_Type_Communications_JunctionObject_Connector	Junction Objects used on the end of strands to connect to equipment and other strands	Short Integer	Coded Value	Duplicate	Default Value	5	1
Asset_Type_Communications_JunctionObject_Connector_Group	Objects used to contain connector	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_JunctionObject_Equipment	Objects used to represent the main equipment	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Communications_JunctionObject_Port	Objects used to convert between connector and equipment	Short Integer	Coded Value	Duplicate	Default Value	11	1
Asset_Type_Communications_JunctionObject_Port_Group	Objects used to contain port	Short Integer	Coded Value	Duplicate	Default Value	5	1
Asset_Type_Communications_JunctionObject_Splice	Objects used to splice between connectors	Short Integer	Coded Value	Duplicate	Default Value	1	1
Asset_Type_Communications_JunctionObject_Splice_Group	Objects used to contain splices	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_Line_Access_Cable	Lines used as cables in the Access Network	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_Line_Distribution_Cable	Lines used as cables in the Distribution Network	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_Line_Drop_Cable	Lines used as cables in the Drop Network	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_Line_Indoor_Cable	Lines used as cables in the Indoor Network	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Communications_Line_National_Cable	Lines used as cables in National Network	Short Integer	Coded Value	Duplicate	Default Value	1	1
Asset_Type_Communications_Line_Regional_Cable	Lines used as cables in Regional Network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Communications_Line_Submarine_Cable	Lines used as cables in Submarine Network	Short Integer	Coded Value	Duplicate	Default Value	1	1
Asset_Type_Communications_Line_Wireless	Lines used as line of sight connections in the Wireless Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Boundary_Building	Asset Types for Building Boundaries	Short Integer	Coded Value	Default Value	Default Value	4	1
Asset_Type_Structure_Boundary_Communications_Wire_Vault_Boundary	Polygon used to store the perimeter of vault	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Structure_Boundary_Support	List of valid support boundaries	Short Integer	Coded Value	Default Value	Default Value	11	1
Asset_Type_Structure_Boundary_Wire_Cabinet_Boundary	The Asset Types for the Electric Distribution Asset Group Cabinet Boundary	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_EdgeObject_Communications_Conduit	List of Conduit types	Short Integer	Coded Value	Default Value	Default Value	2	1
Asset_Type_Structure_EdgeObject_Wire_Duct	Edge objects used to represent different ducts in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	5	1
Asset_Type_Structure_Junction_Building	Asset Types for Buildings	Short Integer	Coded Value	Default Value	Default Value	4	1
Asset_Type_Structure_Junction_Communications_Conduit_Fittings	List of Conduit Fitings	Short Integer	Coded Value	Default Value	Default Value	4	1
Asset_Type_Structure_Junction_Communications_Pole	Junctions used to represent communication poles in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Junction_Communications_Tower	Junctions used to represent communication towers in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	5	1
Asset_Type_Structure_Junction_Duct_Junctions	Asset Types for Microduct Junctions	Short Integer	Coded Value	Default Value	Default Value	4	1
Asset_Type_Structure_Junction_Ground	Asset Types for Ground Points	Short Integer	Coded Value	Default Value	Default Value	4	1
Asset_Type_Structure_Junction_Marker	Junctions used to represent markers in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Structure_Junction_Structure_Attachment_Point		Short Integer	Coded Value	Default Value	Default Value	2	1
Asset_Type_Structure_Junction_Support	List of valid support types	Short Integer	Coded Value	Default Value	Default Value	3	1
Asset_Type_Structure_Junction_Wire_Building_Riser	Building Riser	Short Integer	Coded Value	Default Value	Default Value	1	1
Asset_Type_Structure_Junction_Wire_Cabinet	The Asset Types for the Structure Junction Asset Group Wire Cabinet	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Junction_Wire_Customer_Attachment	The Asset Types for the Structure Junction Asset Group Customer Service Entrance	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Wire_Guy	Junctions used to represent guy wires in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Wire_Handhole	Junctions used to represent handholds in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Wire_Junction_Box	Junctions used to represent junction boxes in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Wire_Pedestal	Junctions used to represent pedestals in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Wire_Stock_Sites	Asset Types for Wire Stock Locations	Short Integer	Coded Value	Default Value	Default Value	5	1
Asset_Type_Structure_Junction_Wire_Structure_Representation	Junctions used to build representations of vaults in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Junction_Wire_Support_Pole	Junctions used to represent support poles in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Structure_Junction_Wire_Vault	Junctions used to represent vaults in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Junction_Wire_Vault_Access	Junctions used to represent access locations for vaults in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Wire_Vault_Components	Junctions used to represent structure items in vaults in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Wire_Vault_Knockouts	Junctions used to represent knockouts and ports for vaults in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_JunctionObject_Communications_Conduit_Fittings	List of Conduit Fitings	Short Integer	Coded Value	Default Value	Default Value	4	1
Asset_Type_Structure_JunctionObject_Crossarm	List of valid Crossarm Types	Short Integer	Coded Value	Default Value	Default Value	4	1
Asset_Type_Structure_JunctionObject_Pole	Junctions used to represent support poles in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Structure_JunctionObject_Wire_Microduct_Connection_Point		Short Integer	Coded Value	Default Value	Default Value	2	1
Asset_Type_Structure_JunctionObject_Wire_Microduct_Fitting	Objects used to connect microducts	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_JunctionObject_Wire_Microduct_Fitting_Group	Asset Types for Microduct Fittings	Short Integer	Coded Value	Default Value	Default Value	2	1
Asset_Type_Structure_JunctionObject_Wire_Vault_Components	Junction Objects used to represent structure items in vaults in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_JunctionObject_Wire_Vault_Knockouts	Junction Objects used to represent knockouts and ports for vaults in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Line_Communications_Cable_Hardware	Lines used to represent linear containers links in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Line_Communications_Conduit	Lines used to represent conduit in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Line_Connector	Lines used to represent connecters inside vaults and handholes in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Line_Ground	Asset Types for Ground Cables	Short Integer	Coded Value	Default Value	Default Value	3	1
Asset_Type_Structure_Line_Tunnel	Lines used to represent access tunnels in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Line_Wire_Aerial_Support	Lines used to represent aerial supports in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	8	1
Asset_Type_Structure_Line_Wire_Duct_Bank	Lines used to represent duct banks in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Line_Wire_Microduct_Pathway	Asset Types for Microduct Casings	Short Integer	Coded Value	Default Value	Default Value	3	1
Asset_Type_Structure_Line_Wire_Trench	Lines used to represent trenches in the Structure Network	Short Integer	Coded Value	Duplicate	Default Value	2	1
Attribute Rule Type	The attribute rule type that created the error record.	Short Integer	Coded Value	Default Value	Default Value	3	4
Communications_Cable_OD_in	Communications cable outside diameter in inches	Double	Coded Value	Duplicate	Default Value	9	7
Communications_Component_Location	The location of the cable component	Short Integer	Coded Value	Duplicate	Default Value	5	9
Communications_Component_Type	The type of hub terminator	Short Integer	Coded Value	Duplicate	Default Value	9	5
Communications_Conduit_Material	The material of the conduit	Short Integer	Coded Value	Duplicate	Default Value	9	2
Communications_Conduit_Type	The type of conduit	Short Integer	Coded Value	Duplicate	Default Value	7	1
Communications_Device_Drop_Type	The type of drop component	Short Integer	Coded Value	Duplicate	Default Value	11	1
Communications_Fiber_Cable_Grade	The grade of the fiber cable	Short Integer	Coded Value	Duplicate	Default Value	9	9
Communications_Network_Levels	The network levels	Short Integer	Coded Value	Duplicate	Default Value	9	2
Communications_Port_Usage_Type	The usage type for ports	Short Integer	Coded Value	Duplicate	Default Value	14	1
Communications_Riser_Material	The material of the riser guard	Short Integer	Coded Value	Duplicate	Default Value	4	2
Communications_Service_Type	The type of customer service	Short Integer	Coded Value	Duplicate	Default Value	3	2
Communications_Strand_Color_Codes	Communications fiber strand or twisted pair color codes	Short Integer	Coded Value	Duplicate	Default Value	64	2
Communications_Strand_Counts_Access	Valid number of strands	Short Integer	Coded Value	Duplicate	Default Value	200	1
Communications_Strand_Counts_Distribution	Valid number of strands	Short Integer	Coded Value	Duplicate	Default Value	217	1
Communications_Strand_Counts_Drop	Valid number of strands	Short Integer	Coded Value	Duplicate	Default Value	194	1
Communications_Strand_Counts_Indoor	Valid number of strands	Short Integer	Coded Value	Duplicate	Default Value	202	1
Communications_Strand_Counts_National	Valid number of strands	Short Integer	Coded Value	Duplicate	Default Value	192	1
Communications_Strand_Counts_Regional	Valid number of strands	Short Integer	Coded Value	Duplicate	Default Value	194	1
Communications_Strand_Counts_Submarine	Valid number of strands	Short Integer	Coded Value	Duplicate	Default Value	187	1
Communications_Strand_Group_Color_Codes	Copper binders or buffer tubes color codes	Short Integer	Coded Value	Duplicate	Default Value	62	3
Communications_Strand_Group_Counts	The number of buffer tubes or binder groups a cable can contain	Short Integer	Coded Value	Duplicate	Default Value	185	9
Communications_Strand_Status	The status of a strand indicating its use	Short Integer	Coded Value	Duplicate	Default Value	8	5
Communications_Tower_Height	Height of Tower	Short Integer	Coded Value	Default Value	Default Value	1	1
Communications_Tower_Height _Metric	Height of Tower	Short Integer	Coded Value	Default Value	Default Value	1	1
Communications_Wireless_Spectrum	General wireless spectrum band	Short Integer	Coded Value	Duplicate	Default Value	8	1
Communications_Wireless_Technology	General wireless technology type	Short Integer	Coded Value	Duplicate	Default Value	13	1
Communications_Wireless_Tower_Type	General construction type of tower	Short Integer	Coded Value	Duplicate	Default Value	7	1
Construction_Status	Valid Construction statues for the assets	Short Integer	Coded Value	Default Value	Default Value	8	92
Electric_Combined_Usage_Or_Type		Short Integer	Coded Value	Default Value	Default Value	7	2
Electric_Wire_Diameter_mm	Wire diameter AWG size, stored as mm	Double	Coded Value	Duplicate	Default Value	9	1
Lifecycle_Combined	Bitwise combination of lifecycle states for subnetwork management	Short Integer	Coded Value	Duplicate	Default Value	6	11
Lifecycle_Status	Valid lifecycle states for the assets.	Short Integer	Coded Value	Duplicate	Default Value	4	87
Lifecycle_Status_Combined	Bitwise combination of lifecycle states for subnetwork management	Short Integer	Coded Value	Duplicate	Default Value	6	0
Network_6_AssociationStatus	Indicates how the feature participates in associations.	Short Integer	Coded Value	Duplicate	Default Value	36	98
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	30
Network_6_IsConnected	Indicates if the feature is connected to a subnetwork controller.	Short Integer	Coded Value	Duplicate	Default Value	3	39
Network_6_IsContentVisible	Indicates if the content or attachment association is visible for containment associations.	Short Integer	Coded Value	Default Value	Default Value	2	0
Network_6_IsDeleted	Indicates if a subnetwork has been marked for deletion.	Short Integer	Coded Value	Default Value	Default Value	2	0
Network_6_IsDirty	Indicates if a subnetwork is clean, dirty, or invalid.	Short Integer	Coded Value	Default Value	Default Value	3	5
Network_6_IsSubnetworkController	Indicates if a device feature is a subnetwork controller.	Short Integer	Coded Value	Default Value	Default Value	2	21
Network_6_TerminalNames	The terminal names in the utility network.	Short Integer	Coded Value	Duplicate	Default Value	8	20
Network_6_TierName	The tier names in the utility network.	Short Integer	Coded Value	Default Value	Default Value	4	21
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_Confidence	Confidence in the accuracy of the spatial data	Short Integer	Coded Value	Duplicate	Default Value	4	92
Spatial_Source	Source of the spatial location	Short Integer	Coded Value	Duplicate	Default Value	6	92
Structure_Junction_Communications_Pole_Height	Communications pole heights	Short Integer	Coded Value	Duplicate	Default Value	17	1
Structure_Junction_Communications_Pole_Height_metric	Comms Height of Pole in Metric	Short Integer	Coded Value	Default Value	Default Value	29	1
Structure_Pole_Depth	Depth of pole in ground	Double	Range	Duplicate	Default Value		1
Structure_Wall_Count	Number of walls in a vault	Short Integer	Range	Duplicate	Default Value		2
Structure_Wall_Position	The position of the wall in the vault	Short Integer	Coded Value	Duplicate	Default Value	9	7
StructureJunctionObject_Building Riser		Short Integer	Coded Value	Default Value	Default Value	2	1
Symbol_Rotation	Valid range of degrees for rotation	Short Integer	Range	Duplicate	Default Value		39
Validation Error Exception	Indicates if the error record has been marked as an exception.	Short Integer	Coded Value	Default Value	Default Value	2	4
Validation Error Phase	Indicates error lifecycle phase of an error	Long Integer	Coded Value	Default Value	Default Value	3	4
Validation Error Status	Indicates error lifecycle status of an error	Long Integer	Coded Value	Default Value	Default Value	6	4
Validation Status	The current record's validation status.	Short Integer	Coded Value	Default Value	Default Value	8	27
Wire_Aerial_Support_Height		Double	Coded Value	Default Value	Default Value	1	1
Wire_Aerial_Support_Height_Metric		Double	Coded Value	Default Value	Default Value	1	1
Wire_Aerial_Support_Length		Double	Range	Default Value	Default Value		1
Wire_Aerial_Support_Length_Metric		Double	Range	Default Value	Default Value		1
Wire_Aerial_Support_Material		Short Integer	Coded Value	Default Value	Default Value	9	1
Wire_Anchor_Guy_Depth	Minimum and maximum anchor guy depth	Double	Range	Duplicate	Default Value		1
Wire_Crossarm_Brace_Count	Number of Braces	Short Integer	Range	Default Value	Default Value		2
Wire_Crossarm_Count	Number of Crossarms	Short Integer	Range	Default Value	Default Value		2
Wire_Crossarm_Face_Height	Width of crossarm face	Double	Coded Value	Duplicate	Default Value	9	2
Wire_Crossarm_Face_Height_Metric		Double	Coded Value	Default Value	Default Value	5	1
Wire_Crossarm_Length		Double	Coded Value	Default Value	Default Value	6	2
Wire_Crossarm_Length_Metric	Crossarm Length in Meters	Double	Range	Default Value	Default Value		3
Wire_Crossarm_Material	Crossarm material	Short Integer	Coded Value	Duplicate	Default Value	5	1
Wire_Crossarm_Mount_Height_Metric	Crossarm Mounting Height Metric	Double	Range	Default Value	Default Value		2
Wire_Crossarm_MountHeight		Double	Range	Default Value	Default Value		2
Wire_Crossarm_Thickness		Double	Coded Value	Default Value	Default Value	7	2
Wire_Crossarm_Thickness_Metric		Double	Coded Value	Default Value	Default Value	6	2
Wire_Crossarm_Usage_Type	Crossarm usage	Short Integer	Coded Value	Duplicate	Default Value	7	1
Wire_Duct_Bank_Width	Width of the duct bank	Double	Range	Duplicate	Default Value		1
Wire_Duct_Diameter	Diameter of duct	Double	Coded Value	Duplicate	Default Value	12	4
Wire_Duct_Diameter_mm	Diameter of the duct in millimeters	Double	Coded Value	Duplicate	Default Value	19	4
Wire_Number_of_Ducts		Short Integer	Range	Default Value	Default Value		5
Wire_Pedestal_Depth	Minimum and maximum pedestal depth	Double	Range	Duplicate	Default Value		1
Wire_Pole_Height_Combined	List of valid heights for all poles	Short Integer	Coded Value	Duplicate	Default Value	22	1
Wire_Structure_Cabinet_Design_Type	List of cabinet designs	Short Integer	Coded Value	Duplicate	Default Value	4	1
Wire_Structure_Guy_Diameter_in	List of diameters of guys in inches	Double	Coded Value	Duplicate	Default Value	8	2
Wire_Structure_Junction_Anchor_Guy_Size	List of anchor guy sizes	Short Integer	Coded Value	Duplicate	Default Value	5	1
Wire_Structure_Junction_Anchor_Guy_Type	List of anchor guy types	Short Integer	Coded Value	Duplicate	Default Value	8	1
Wire_Structure_Junction_Cabinet_Material	List of valid cabinet materials	Short Integer	Coded Value	Duplicate	Default Value	10	2
Wire_Structure_Junction_Cabinet_Size	List of cabinet sizes	Short Integer	Coded Value	Duplicate	Default Value	1	1
Wire_Structure_Junction_Combined_Material	Combined list of structure materials	Short Integer	Coded Value	Duplicate	Default Value	11	1
Wire_Structure_Junction_Comm_Pole_Material	Communications Pole Material	Short Integer	Coded Value	Duplicate	Default Value	7	1
Wire_Structure_Junction_Foundation	Type of foundation	Short Integer	Coded Value	Duplicate	Default Value	6	1
Wire_Structure_Junction_Guy_Material	List of valid guy materials	Short Integer	Coded Value	Duplicate	Default Value	2	1
Wire_Structure_Junction_Handhole_Material	List of valid electric handhole materials	Short Integer	Coded Value	Duplicate	Default Value	5	1
Wire_Structure_Junction_Handhole_Size	List of handhole sizes	Short Integer	Coded Value	Duplicate	Default Value	1	1
Wire_Structure_Junction_Junction_Box_Material	List of valid junction box materials	Short Integer	Coded Value	Duplicate	Default Value	6	1
Wire_Structure_Junction_Junction_Box_Size	List of valid junction box sizes	Short Integer	Coded Value	Duplicate	Default Value	1	1
Wire_Structure_Junction_Maker_Material	List of types of marker materials	Short Integer	Coded Value	Duplicate	Default Value	9	1
Wire_Structure_Junction_Manhole_Size	List of valid manhole sizes	Short Integer	Coded Value	Duplicate	Default Value	7	1
Wire_Structure_Junction_Manhole_Type	List of types of manholes	Short Integer	Coded Value	Duplicate	Default Value	4	2
Wire_Structure_Junction_Pedestal_Material	List of valid pedestal materials	Short Integer	Coded Value	Duplicate	Default Value	4	1
Wire_Structure_Junction_Pole_Class_Combined	Combined list of pole classes	Short Integer	Coded Value	Duplicate	Default Value	16	1
Wire_Structure_Junction_Pole_Treatment_Type	List of pole or tower treatment types	Short Integer	Coded Value	Duplicate	Default Value	12	2
Wire_Structure_Junction_Support_Pole_Class	List of valid pole classes	Short Integer	Coded Value	Duplicate	Default Value	12	1
Wire_Structure_Junction_Support_Pole_Height	Support Pole Heights	Short Integer	Coded Value	Duplicate	Default Value	14	1
Wire_Structure_Junction_Support_Pole_Height_metric	Wire Support Height of Pole in Metric	Short Integer	Coded Value	Default Value	Default Value	29	1
Wire_Structure_Junction_Support_Pole_Material	List of support pole materials	Short Integer	Coded Value	Duplicate	Default Value	5	1
Wire_Structure_Junction_Vault_Cover_Material	Manhole Cover Material	Short Integer	Coded Value	Duplicate	Default Value	7	1
Wire_Structure_Junction_Vault_Material	List of vault materials	Short Integer	Coded Value	Duplicate	Default Value	6	1
Wire_Structure_Junction_Vault_Size	List of vault sizes	Short Integer	Coded Value	Duplicate	Default Value	1	1
Wire_Structure_JunctionObject_Material		Short Integer	Coded Value	Default Value	Default Value	9	1
Wire_Structure_Line_Aerial_Support_Material	List of materials used for aerial supports	Short Integer	Coded Value	Duplicate	Default Value	4	1
Wire_Structure_Line_Duct_Bank_Material	List of materials for duct banks	Short Integer	Coded Value	Duplicate	Default Value	7	1
Wire_Structure_Line_Duct_Material	List of duct materials	Short Integer	Coded Value	Duplicate	Default Value	7	2
Wire_Structure_Line_Trench_Material	List of valid trench materials	Short Integer	Coded Value	Duplicate	Default Value	4	1
Wire_Structure_Manufacturer	All Electric Structure Manufacturer	Short Integer	Coded Value	Duplicate	Default Value	50	10
Wire_Support_Pole_Depth	Support pole buried depth	Double	Range	Duplicate	Default Value		1
Wire_Trench_Width	Depth of trench	Double	Range	Duplicate	Default Value		1
Wire_Vault_Depth	Dept of vault	Double	Range	Duplicate	Default Value		1
Yes_No	Valid Yes, No values	Short Integer	Coded Value	Duplicate	Default Value	3	29

Datasets

main.CommunicationsAssembly

Properties

Key	Value
Name	main.CommunicationsAssembly
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	227
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	Communications Assembly
OID Field	OBJECTID
GlobalID Field	GLOBALID
Subtype Field	ASSETGROUP
Default Subtype	Unknown
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	SHAPE
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min	500372.76851503144
X-Max	1270078.1610237402
Y-Min	1550391.9656167035
Y-Max	2190094.254910357
Z-Min	0.00010000000474974513
Z-Max	0.00010000000474974513
Catalog ID	{877CA070-849C-4FF8-8EA9-F7F57C88751C}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Controller Membership

Key	Value
utilityNetworkName	main.Network

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
SHAPE	Shape	Geometry	Index	False			8	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
SUPPORTEDSUBNETWORKNAME	Supported subnetwork name	String	Index	False		Unknown	2000	False	True
assetid	Asset ID	String		True			64	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
ownedby	Owned By	Short Integer		True	Asset_Owner	1	2	True	False
maintby	Maintained By	Short Integer		True	Asset_Manager	1	2	True	False
installdate	Install Date	Date		True			8	True	False
retireddate	Retired Date	Date		True			8	True	False
inservicedate	In-Service Date	Date		True			8	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source		2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence		2	True	False
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		2	True	False
constructionstatus	Construction Status	Short Integer		False	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

Indexes

Name	Is Unique	Is Ascending	Field Name
GDB_227_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
UUID_45	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__CommunicationsAssembly_SHAPE	True	True	SHAPE

Subtypes

Name	Code	Details
Unknown	0

Assignments

Subtype Name	Field Name	Default Value	Domain Name
Unknown	ASSETTYPE	0	Network_6_UnknownAssetType
Unknown	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Unknown	SUPPORTEDSUBNETWORKNAME	Unknown
Unknown	lifecyclestatus	2	Lifecycle_Status
Unknown	maintby	1	Asset_Manager
Unknown	ownedby	1	Asset_Owner
Unknown	spatialconfidence		Spatial_Confidence
Unknown	spatialsource		Spatial_Source
Unknown	symbolrotation		Symbol_Rotation

main.CommunicationsAssembly__ATTACH

Properties

Key	Value
Name	main.CommunicationsAssembly__ATTACH
Dataset Type	Table
Dataset ID	232
Minimum Client Version	10.1
Alias	CommunicationsAssembly__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	{7713F74E-C5EF-4549-AA46-81D3E62856DD}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Length	Editable	Required
ATTACHMENTID	ATTACHMENTID	OID	Index	False	4	False	True
REL_GLOBALID	REL_GLOBALID	GUID	Index	False	38	True	False
CONTENT_TYPE	CONTENT_TYPE	String		False	150	True	False
ATT_NAME	ATT_NAME	String		False	250	True	False
DATA_SIZE	DATA_SIZE	Long Integer		False	4	True	False
DATA	DATA	Blob		True	0	True	False
GLOBALID	GLOBALID	Global ID	Index	False	38	False	True
created_user	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

Indexes

Name	Is Unique	Is Ascending	Field Name
GDB_232_REL_GLOB	False	True	REL_GLOBALID
UUID_50	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

main.CommunicationsAssembly__ATTACHREL

Key	Value
Name	main.CommunicationsAssembly__ATTACHREL
Dataset Type	RelationshipClass
Feature Dataset	main.UtilityNetwork
Dataset ID	243
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.CommunicationsAssembly
Origin Primary Key	GLOBALID
Origin Foreign Key	REL_GLOBALID
Destination Name	main.CommunicationsAssembly__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{D93D73A7-5BB5-47E7-ADEC-F155110AB120}

main.CommunicationsDevice

Key	Value
Name	main.CommunicationsDevice
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	224
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	Communications Device
OID Field	OBJECTID
GlobalID Field	GLOBALID
Subtype Field	ASSETGROUP
Default Subtype	Unknown
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	SHAPE
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min	500372.76851503144
X-Max	1270078.1610237402
Y-Min	1550391.9656167035
Y-Max	2190094.254910357
Z-Min	0
Z-Max	0.00010000000474974513
Catalog ID	{6EEC7423-4E25-401F-8ED2-6D7A159946BA}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Key	Value
utilityNetworkName	main.Network

Name	Is Unique	Is Ascending	Field Name
GDB_224_SUBNETWO	False	True	SUBNETWORKCONTROLLERNAME
GDB_224_CableSub	False	True	CableSubnetwork
GDB_224_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_224_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_224_SwitchSu	False	True	SwitchSubnetwork
GDB_224_Communic	False	True	CommunicationsCircuit
UUID_43	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__CommunicationsDevice_SHAPE	True	True	SHAPE

Name	Code	Details
Unknown	0
Submarine Cable Components	20
National Cable Components	25
Regional Cable Components	30
Distribution Cable Components	35
Access Cable Components	40
Drop Cable Components	45
Indoor Cable Components	50
Wireless Components	60

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	CableSubnetwork	Unknown
Unknown	0	SUPPORTEDSUBNETWORKNAME	Unknown
Unknown	0	SUPPORTINGSUBNETWORKNAME	Unknown
Unknown	0	SwitchSubnetwork	Unknown
Unknown	0	CommunicationsCircuit	Unknown
Unknown	0	lifecyclestatus	2	Lifecycle_Status
Unknown	0	maintby	1	Asset_Manager
Unknown	0	ownedby	1	Asset_Owner
Submarine Cable Components	20	ASSETTYPE	0	Asset_Type_Communications_Device_Submarine_Cable_Components
Submarine Cable Components	20	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Submarine Cable Components	20	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Submarine Cable Components	20	ISCONNECTED	2	Network_6_IsConnected
Submarine Cable Components	20	SUBNETWORKCONTROLLERNAME	Unknown
Submarine Cable Components	20	TIERNAME	0	Network_6_TierName
Submarine Cable Components	20	TIERRANK	0
Submarine Cable Components	20	TERMINALCONFIGURATION	Default
Submarine Cable Components	20	CableSubnetwork	Unknown
Submarine Cable Components	20	SUPPORTEDSUBNETWORKNAME	Unknown
Submarine Cable Components	20	SUPPORTINGSUBNETWORKNAME	Unknown
Submarine Cable Components	20	SwitchSubnetwork	Unknown
Submarine Cable Components	20	CommunicationsCircuit	Unknown
Submarine Cable Components	20	constructionstatus	6	Construction_Status
Submarine Cable Components	20	designtype		Communications_Component_Type
Submarine Cable Components	20	lifecyclestatus	2	Lifecycle_Status
Submarine Cable Components	20	loctype		Communications_Component_Location
Submarine Cable Components	20	maintby	1	Asset_Manager
Submarine Cable Components	20	ownedby	1	Asset_Owner
Submarine Cable Components	20	spatialconfidence		Spatial_Confidence
Submarine Cable Components	20	spatialsource		Spatial_Source
Submarine Cable Components	20	symbolrotation		Symbol_Rotation
National Cable Components	25	ASSETTYPE	0	Asset_Type_Communications_Device_National_Cable_Components
National Cable Components	25	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
National Cable Components	25	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
National Cable Components	25	ISCONNECTED	2	Network_6_IsConnected
National Cable Components	25	SUBNETWORKCONTROLLERNAME	Unknown
National Cable Components	25	TIERNAME	0	Network_6_TierName
National Cable Components	25	TIERRANK	0
National Cable Components	25	TERMINALCONFIGURATION	Default
National Cable Components	25	CableSubnetwork	Unknown
National Cable Components	25	SUPPORTEDSUBNETWORKNAME	Unknown
National Cable Components	25	SUPPORTINGSUBNETWORKNAME	Unknown
National Cable Components	25	SwitchSubnetwork	Unknown
National Cable Components	25	CommunicationsCircuit	Unknown
National Cable Components	25	constructionstatus	6	Construction_Status
National Cable Components	25	designtype		Communications_Component_Type
National Cable Components	25	lifecyclestatus	2	Lifecycle_Status
National Cable Components	25	loctype		Communications_Component_Location
National Cable Components	25	maintby	1	Asset_Manager
National Cable Components	25	ownedby	1	Asset_Owner
National Cable Components	25	spatialconfidence		Spatial_Confidence
National Cable Components	25	spatialsource		Spatial_Source
National Cable Components	25	symbolrotation		Symbol_Rotation
Regional Cable Components	30	ASSETTYPE	0	Asset_Type_Communications_Device_Regional_Cable_Components
Regional Cable Components	30	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Regional Cable Components	30	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Regional Cable Components	30	ISCONNECTED	2	Network_6_IsConnected
Regional Cable Components	30	SUBNETWORKCONTROLLERNAME	Unknown
Regional Cable Components	30	TIERNAME	0	Network_6_TierName
Regional Cable Components	30	TIERRANK	0
Regional Cable Components	30	TERMINALCONFIGURATION	Default
Regional Cable Components	30	CableSubnetwork	Unknown
Regional Cable Components	30	SUPPORTEDSUBNETWORKNAME	Unknown
Regional Cable Components	30	SUPPORTINGSUBNETWORKNAME	Unknown
Regional Cable Components	30	SwitchSubnetwork	Unknown
Regional Cable Components	30	CommunicationsCircuit	Unknown
Regional Cable Components	30	constructionstatus	6	Construction_Status
Regional Cable Components	30	designtype		Communications_Component_Type
Regional Cable Components	30	lifecyclestatus	2	Lifecycle_Status
Regional Cable Components	30	loctype		Communications_Component_Location
Regional Cable Components	30	maintby	1	Asset_Manager
Regional Cable Components	30	ownedby	1	Asset_Owner
Regional Cable Components	30	spatialconfidence		Spatial_Confidence
Regional Cable Components	30	spatialsource		Spatial_Source
Regional Cable Components	30	symbolrotation		Symbol_Rotation
Distribution Cable Components	35	ASSETTYPE	0	Asset_Type_Communications_Device_Distribution_Cable_Components
Distribution Cable Components	35	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Distribution Cable Components	35	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Distribution Cable Components	35	ISCONNECTED	2	Network_6_IsConnected
Distribution Cable Components	35	SUBNETWORKCONTROLLERNAME	Unknown
Distribution Cable Components	35	TIERNAME	0	Network_6_TierName
Distribution Cable Components	35	TIERRANK	0
Distribution Cable Components	35	TERMINALCONFIGURATION	Default
Distribution Cable Components	35	CableSubnetwork	Unknown
Distribution Cable Components	35	SUPPORTEDSUBNETWORKNAME	Unknown
Distribution Cable Components	35	SUPPORTINGSUBNETWORKNAME	Unknown
Distribution Cable Components	35	SwitchSubnetwork	Unknown
Distribution Cable Components	35	CommunicationsCircuit	Unknown
Distribution Cable Components	35	constructionstatus	6	Construction_Status
Distribution Cable Components	35	designtype		Communications_Component_Type
Distribution Cable Components	35	lifecyclestatus	2	Lifecycle_Status
Distribution Cable Components	35	loctype		Communications_Component_Location
Distribution Cable Components	35	maintby	1	Asset_Manager
Distribution Cable Components	35	ownedby	1	Asset_Owner
Distribution Cable Components	35	spatialconfidence		Spatial_Confidence
Distribution Cable Components	35	spatialsource		Spatial_Source
Distribution Cable Components	35	symbolrotation		Symbol_Rotation
Access Cable Components	40	ASSETTYPE	0	Asset_Type_Communications_Device_Access_Cable_Components
Access Cable Components	40	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Access Cable Components	40	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Access Cable Components	40	ISCONNECTED	2	Network_6_IsConnected
Access Cable Components	40	SUBNETWORKCONTROLLERNAME	Unknown
Access Cable Components	40	TIERNAME	0	Network_6_TierName
Access Cable Components	40	TIERRANK	0
Access Cable Components	40	TERMINALCONFIGURATION	Default
Access Cable Components	40	CableSubnetwork	Unknown
Access Cable Components	40	SUPPORTEDSUBNETWORKNAME	Unknown
Access Cable Components	40	SUPPORTINGSUBNETWORKNAME	Unknown
Access Cable Components	40	SwitchSubnetwork	Unknown
Access Cable Components	40	CommunicationsCircuit	Unknown
Access Cable Components	40	constructionstatus	6	Construction_Status
Access Cable Components	40	designtype		Communications_Component_Type
Access Cable Components	40	lifecyclestatus	2	Lifecycle_Status
Access Cable Components	40	loctype		Communications_Component_Location
Access Cable Components	40	maintby	1	Asset_Manager
Access Cable Components	40	ownedby	1	Asset_Owner
Access Cable Components	40	spatialconfidence		Spatial_Confidence
Access Cable Components	40	spatialsource		Spatial_Source
Access Cable Components	40	symbolrotation		Symbol_Rotation
Drop Cable Components	45	ASSETTYPE	0	Asset_Type_Communications_Device_Drop_Cable_Components
Drop Cable Components	45	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Drop Cable Components	45	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Drop Cable Components	45	ISCONNECTED	2	Network_6_IsConnected
Drop Cable Components	45	SUBNETWORKCONTROLLERNAME	Unknown
Drop Cable Components	45	TIERNAME	0	Network_6_TierName
Drop Cable Components	45	TIERRANK	0
Drop Cable Components	45	TERMINALCONFIGURATION	Default
Drop Cable Components	45	CableSubnetwork	Unknown
Drop Cable Components	45	SUPPORTEDSUBNETWORKNAME	Unknown
Drop Cable Components	45	SUPPORTINGSUBNETWORKNAME	Unknown
Drop Cable Components	45	SwitchSubnetwork	Unknown
Drop Cable Components	45	CommunicationsCircuit	Unknown
Drop Cable Components	45	constructionstatus	6	Construction_Status
Drop Cable Components	45	designtype		Communications_Device_Drop_Type
Drop Cable Components	45	lifecyclestatus	2	Lifecycle_Status
Drop Cable Components	45	loctype		Communications_Component_Location
Drop Cable Components	45	maintby	1	Asset_Manager
Drop Cable Components	45	ownedby	1	Asset_Owner
Drop Cable Components	45	servicetype		Communications_Service_Type
Drop Cable Components	45	spatialconfidence		Spatial_Confidence
Drop Cable Components	45	spatialsource		Spatial_Source
Drop Cable Components	45	symbolrotation		Symbol_Rotation
Indoor Cable Components	50	ASSETTYPE	0	Asset_Type_Communications_Device_Indoor_Cable_Components
Indoor Cable Components	50	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Indoor Cable Components	50	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Indoor Cable Components	50	ISCONNECTED	2	Network_6_IsConnected
Indoor Cable Components	50	SUBNETWORKCONTROLLERNAME	Unknown
Indoor Cable Components	50	TIERNAME	0	Network_6_TierName
Indoor Cable Components	50	TIERRANK	0
Indoor Cable Components	50	TERMINALCONFIGURATION	Default
Indoor Cable Components	50	CableSubnetwork	Unknown
Indoor Cable Components	50	SUPPORTEDSUBNETWORKNAME	Unknown
Indoor Cable Components	50	SUPPORTINGSUBNETWORKNAME	Unknown
Indoor Cable Components	50	SwitchSubnetwork	Unknown
Indoor Cable Components	50	CommunicationsCircuit	Unknown
Indoor Cable Components	50	constructionstatus	6	Construction_Status
Indoor Cable Components	50	lifecyclestatus	2	Lifecycle_Status
Indoor Cable Components	50	loctype		Communications_Component_Location
Indoor Cable Components	50	maintby	1	Asset_Manager
Indoor Cable Components	50	ownedby	1	Asset_Owner
Indoor Cable Components	50	spatialconfidence		Spatial_Confidence
Indoor Cable Components	50	spatialsource		Spatial_Source
Indoor Cable Components	50	symbolrotation		Symbol_Rotation
Wireless Components	60	ASSETTYPE	0	Asset_Type_Communications_Device_Wireless_Components
Wireless Components	60	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Wireless Components	60	ISSUBNETWORKCONTROLLER	0	Network_6_IsSubnetworkController
Wireless Components	60	ISCONNECTED	2	Network_6_IsConnected
Wireless Components	60	SUBNETWORKCONTROLLERNAME	Unknown
Wireless Components	60	TIERNAME	0	Network_6_TierName
Wireless Components	60	TIERRANK	0
Wireless Components	60	TERMINALCONFIGURATION	Default
Wireless Components	60	CableSubnetwork	Unknown
Wireless Components	60	SUPPORTEDSUBNETWORKNAME	Unknown
Wireless Components	60	SUPPORTINGSUBNETWORKNAME	Unknown
Wireless Components	60	SwitchSubnetwork	Unknown
Wireless Components	60	CommunicationsCircuit	Unknown
Wireless Components	60	constructionstatus	6	Construction_Status
Wireless Components	60	lifecyclestatus	2	Lifecycle_Status
Wireless Components	60	loctype		Communications_Component_Location
Wireless Components	60	maintby	1	Asset_Manager
Wireless Components	60	ownedby	1	Asset_Owner
Wireless Components	60	spatialconfidence		Spatial_Confidence
Wireless Components	60	spatialsource		Spatial_Source
Wireless Components	60	symbolrotation		Symbol_Rotation

Key	Value
ID	21
Minimum Client Version	12.9
Evaluation Order	1
Name	CD-GenerateIDs
Description	Generate IDs for CommunicationsDevice 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:21
Script	// Assigned To: CommunicationsDevice // Type: Calculation // Name: CD-GenerateIDs // Description: Generate IDs for CommunicationsDevice 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. // - SJ-GenerateIDs // - SB-GenerateIDs // - SJO-GenerateIDs // - SL-GenerateIDs // - SEO-GenerateIDs // - CJ-GenerateIDs // - CJO-GenerateIDs // - CL-GenerateIDs // - CEO-GenerateIDs // *********** 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': "Sbmrn-Cbl-CPNT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_D_Sbmrn_Cbl_CPNT_20_seq'); }else if (selector_value_txt == '25') { id_format = { 'prefix': "Ntnl-Cbl-CPNT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_D_Ntnl_Cbl_CPNT_25_seq'); }else if (selector_value_txt == '30') { id_format = { 'prefix': "Rgnl-Cbl-CPNT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_D_Rgnl_Cbl_CPNT_30_seq'); }else if (selector_value_txt == '35') { id_format = { 'prefix': "Dstrbtn-Cbl-CPNT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_D_Dstrbtn_Cbl_CPNT_35_seq'); }else if (selector_value_txt == '40') { id_format = { 'prefix': "Accss-Cbl-CPNT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_D_Accss_Cbl_CPNT_40_seq'); }else if (selector_value_txt == '45') { id_format = { 'prefix': "Drp-Cbl-CPNT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_D_Drp_Cbl_CPNT_45_seq'); }else if (selector_value_txt == '50') { id_format = { 'prefix': "Indr-Cbl-CPNT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_D_Indr_Cbl_CPNT_50_seq'); }else if (selector_value_txt == '60') { id_format = { 'prefix': "Wrlss-CPNT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_D_Wrlss_CPNT_60_seq'); } else { return null; } var id_parts = remove_empty([id_format['prefix'], seq_val, id_format['suffix']]) return Concatenate(id_parts, id_format['join_char']) } // *********** End User Variables Section ********* // ********* Functions ********* function remove_empty(arr) { var new_arr = []; var j = 0; for (var i = 0; i < Count(arr); i++) { if (!IsEmpty(arr[i]) && arr[i] != '') { new_arr[j++] = arr[i]; } } return new_arr; } // ********* End Functions Section *************** if ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

main.CommunicationsDevice__ATTACH

Properties

Key	Value
Name	main.CommunicationsDevice__ATTACH
Dataset Type	Table
Dataset ID	233
Minimum Client Version	10.1
Alias	CommunicationsDevice__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	{12F117E4-046E-4745-B6BF-02B7998969A6}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Length	Editable	Required
ATTACHMENTID	ATTACHMENTID	OID	Index	False	4	False	True
REL_GLOBALID	REL_GLOBALID	GUID	Index	False	38	True	False
CONTENT_TYPE	CONTENT_TYPE	String		False	150	True	False
ATT_NAME	ATT_NAME	String		False	250	True	False
DATA_SIZE	DATA_SIZE	Long Integer		False	4	True	False
DATA	DATA	Blob		True	0	True	False
GLOBALID	GLOBALID	Global ID	Index	False	38	False	True
created_user	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

Indexes

Name	Is Unique	Is Ascending	Field Name
GDB_233_REL_GLOB	False	True	REL_GLOBALID
UUID_51	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

main.CommunicationsDevice__ATTACHREL

Key	Value
Name	main.CommunicationsDevice__ATTACHREL
Dataset Type	RelationshipClass
Feature Dataset	main.UtilityNetwork
Dataset ID	244
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.CommunicationsDevice
Origin Primary Key	GLOBALID
Origin Foreign Key	REL_GLOBALID
Destination Name	main.CommunicationsDevice__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{A995999D-A430-4005-A9ED-7E2E4310AD1A}

main.CommunicationsEdgeObject

Properties

Key	Value
Name	main.CommunicationsEdgeObject
Dataset Type	Table
Dataset ID	231
Minimum Client Version	13.2
Alias	Communications 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	{40E3C2C1-D5BF-4F8E-98A4-22E698D729E9}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Controller Membership

Key	Value
utilityNetworkName	main.Network

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
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
CableSubnetwork	CableSubnetwork	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
SwitchSubnetwork	SwitchSubnetwork	String	Index	False		Unknown	2000	False	True
CommunicationsCircuit	CommunicationsCircuit	String	Index	False		Unknown	2000	False	True
strandgroupid	Strand Group Color	Short Integer		True	Communications_Strand_Group_Color_Codes		2	True	False
strandid	Strand Color	Short Integer		True	Communications_Strand_Color_Codes		2	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
strandgrade	Strand Grade	Short Integer		True			2	True	False
measuredlength	Measured Length	Double		True			8	True	False
opticallength	Optical Length	Double		True			8	True	False
startfrequency	Splitter Start of Frequency Banc	Double		True			8	True	False
endfrequency	Splitter End of Frequency Banc	Double		True			8	True	False
strandstatus	Strand Status	Short Integer		True	Communications_Strand_Status		2	True	False
installdate	Install Date	Date		True			8	True	False
retireddate	Retired Date	Date		True			8	True	False
inservicedate	In-Service Date	Date		True			8	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence		2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source		2	True	False
ownedby	Owned By	Short Integer		True	Asset_Owner	1	2	True	False
maintby	Maintained By	Short Integer		True	Asset_Manager	1	2	True	False
networksite	Network Site	String		True			120	True	False
building	Building	String		True			120	True	False
floor	Floor	String		True			120	True	False
room	Room	String		True			120	True	False
aisle	Aisle	String		True			120	True	False
bay	Bay	String		True			120	True	False
assetid	Asset ID	String		True			2000	True	False
signalfibermode	Fiber Mode	Short Integer		True			2	True	False
signalcladding	Core Cladding	Short Integer		True			2	True	False
signalwavelength	Wavelength	Short Integer		True			2	True	False
signalloss850	Signal Loss 850	Double		True			8	True	False
signalloss1300	Signal Loss 1300	Double		True			8	True	False
signalloss1310	Signal Loss 1310	Double		True			8	True	False
signalloss1550	Signal Loss 1550	Double		True			8	True	False
signallosscoax	Signal Loss Coax	Double		True			8	True	False
signallosscopper	Signal Loss Copper	Double		True			8	True	False
signallosspermeter850	Signal Loss Per Length 850	Double		True			8	True	False
signallosspermeter1300	Signal Loss Per Length 1300	Double		True			8	True	False
signallosspermeter1310	Signal Loss Per Length 1310	Double		True			8	True	False
signallosspermeter1550	Signal Loss Per Length 1550	Double		True			8	True	False
signallosspermetercoax	Signal Loss Per Length Coax	Double		True			8	True	False
signallosspermetercopper	Signal Loss Per Length Copper	Double		True			8	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
ribbongroupid	Ribbon Group Color	Short Integer		True	Communications_Strand_Group_Color_Codes		2	True	False

Indexes

Name	Is Unique	Is Ascending	Field Name
GDB_231_CableSub	False	True	CableSubnetwork
GDB_231_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_231_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_231_SwitchSu	False	True	SwitchSubnetwork
GDB_231_Communic	False	True	CommunicationsCircuit
UUID_49	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID

Subtypes

Name	Code	Details
Unknown	0
Strand	8
Link	10
Wireless	11

Assignments

Subtype Name	Subtype Code	Field Name	Default Value	Domain Name
Unknown	0	ASSETTYPE	0	Network_6_UnknownAssetType
Unknown	0	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Unknown	0	ISCONNECTED	2	Network_6_IsConnected
Unknown	0	FLOWDIRECTION	1	Network_6_FlowDirection
Unknown	0	CableSubnetwork	Unknown
Unknown	0	SUPPORTEDSUBNETWORKNAME	Unknown
Unknown	0	SUPPORTINGSUBNETWORKNAME	Unknown
Unknown	0	SwitchSubnetwork	Unknown
Unknown	0	CommunicationsCircuit	Unknown
Unknown	0	lifecyclestatus	2	Lifecycle_Status
Unknown	0	maintby	1	Asset_Manager
Unknown	0	ownedby	1	Asset_Owner
Unknown	0	strandstatus	1	Communications_Strand_Status
Strand	8	ASSETTYPE	0	Asset_Type_Communications_EdgeObject_Strand
Strand	8	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Strand	8	ISCONNECTED	2	Network_6_IsConnected
Strand	8	FLOWDIRECTION	1	Network_6_FlowDirection
Strand	8	CableSubnetwork	Unknown
Strand	8	SUPPORTEDSUBNETWORKNAME	Unknown
Strand	8	SUPPORTINGSUBNETWORKNAME	Unknown
Strand	8	SwitchSubnetwork	Unknown
Strand	8	CommunicationsCircuit	Unknown
Strand	8	constructionstatus	6	Construction_Status
Strand	8	lifecyclestatus	2	Lifecycle_Status
Strand	8	maintby	1	Asset_Manager
Strand	8	ownedby	1	Asset_Owner
Strand	8	spatialconfidence		Spatial_Confidence
Strand	8	spatialsource		Spatial_Source
Strand	8	strandgroupid		Communications_Strand_Group_Color_Codes
Strand	8	strandid		Communications_Strand_Color_Codes
Strand	8	strandstatus	1	Communications_Strand_Status
Link	10	ASSETTYPE	0	Asset_Type_Communications_EdgeObject_Link
Link	10	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Link	10	ISCONNECTED	2	Network_6_IsConnected
Link	10	FLOWDIRECTION	1	Network_6_FlowDirection
Link	10	CableSubnetwork	Unknown
Link	10	SUPPORTEDSUBNETWORKNAME	Unknown
Link	10	SUPPORTINGSUBNETWORKNAME	Unknown
Link	10	SwitchSubnetwork	Unknown
Link	10	CommunicationsCircuit	Unknown
Link	10	constructionstatus	6	Construction_Status
Link	10	lifecyclestatus	2	Lifecycle_Status
Link	10	maintby	1	Asset_Manager
Link	10	ownedby	1	Asset_Owner
Link	10	spatialconfidence		Spatial_Confidence
Link	10	spatialsource		Spatial_Source
Link	10	strandstatus	1	Communications_Strand_Status
Wireless	11	ASSETTYPE	0	Asset_Type_Communications_EdgeObject_Wireless
Wireless	11	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Wireless	11	ISCONNECTED	2	Network_6_IsConnected
Wireless	11	FLOWDIRECTION	1	Network_6_FlowDirection
Wireless	11	CableSubnetwork	Unknown
Wireless	11	SUPPORTEDSUBNETWORKNAME	Unknown
Wireless	11	SUPPORTINGSUBNETWORKNAME	Unknown
Wireless	11	SwitchSubnetwork	Unknown
Wireless	11	CommunicationsCircuit	Unknown
Wireless	11	constructionstatus	6	Construction_Status
Wireless	11	lifecyclestatus	2	Lifecycle_Status
Wireless	11	maintby	1	Asset_Manager
Wireless	11	ownedby	1	Asset_Owner
Wireless	11	spatialconfidence		Spatial_Confidence
Wireless	11	spatialsource		Spatial_Source
Wireless	11	strandstatus	1	Communications_Strand_Status

Attribute Rules

CEO-GenerateIDs

Key	Value
ID	31
Minimum Client Version	12.9
Evaluation Order	1
Name	CEO-GenerateIDs
Description	Generate IDs for CommunicationsEdgeObject 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:33
Script	// Assigned To: CommunicationsEdgeObject // Type: Calculation // Name: CEO-GenerateIDs // Description: Generate IDs for CommunicationsEdgeObject 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. // - SJ-GenerateIDs // - SB-GenerateIDs // - SJO-GenerateIDs // - SL-GenerateIDs // - SEO-GenerateIDs // - CD-GenerateIDs // - CJ-GenerateIDs // - CJO-GenerateIDs // - CL-GenerateIDs // *********** 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 == '8') { id_format = { 'prefix': "Strnd", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_EO_Strnd_8_seq'); }else if (selector_value_txt == '10') { id_format = { 'prefix': "Lnk", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_EO_Lnk_10_seq'); }else if (selector_value_txt == '11') { id_format = { 'prefix': "Wrlss", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_EO_Wrlss_11_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

CEO-Require Calculation

Key	Value
ID	32
Minimum Client Version	12.9
Evaluation Order	2
Name	CEO-Require Calculation
Description	Require a batch calculation on the parent Cable when a Strand is updated.
Type	Calculation
Batch	False
Insert Trigger	False
Update Trigger	True
Delete Trigger	True
Subtype	Strand
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:33
Script	// Assigned To: CommunicationsEdgeObject // Type: Calculation // Name: CEO-Require Calculation // Description: Require a batch calculation on the parent Cable when a Strand is updated. // Subtypes: Strand // Trigger: Update, Delete // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - CL - Batch Strand Status // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'strandstatus', 'associationstatus'); // The strand status field // Implementation Note: Different states of strandstatus are compared to determine if strandstatus has been changed. // Adjust only if strand status field name differs. var strand_status = $feature.strandstatus; var orig_strand_status = $originalfeature.strandstatus; // The association status field // Implementation Note: used to check if strand is content var assoc_status = $feature.associationstatus; var orig_assoc_status = $originalfeature.associationstatus; // The class name of the container Cable // Implementation Note: This is just the class name and should not be fully qualified. Adjust this only if class name differs. var cable_class = "CommunicationsLine"; // *********** End User Variables Section ********* // ********* Functions ********* function get_contain_assoc_fs(feature) { // Query to get all the container associations var associations = FeatureSetByAssociation(feature, "container"); // return only containers from the cable class return Filter(associations, "className = @cable_class"); } // ********* End Functions Section **************** // if strand status did not change and association status did not change, exit if (strand_status == orig_strand_status && $editContext.editType == 'UPDATE') { if (((orig_assoc_status & 0x14) == 0 && (assoc_status & 0x14) == 0) \|\| ((orig_assoc_status & 0x14) > 0 && (assoc_status & 0x14) > 0)) { return; } } // get containers var container_assoc_fs = get_contain_assoc_fs($feature); // Strand can potentially have more one container (2 cables, 1 strand) var container_ids = []; for (var container_assoc in container_assoc_fs) { push(container_ids, container_assoc.globalid); } if (Count(container_ids) == 0) return; return { 'calculationRequired': [{ 'className': cable_class, 'globalIDs': container_ids }] }

main.CommunicationsEdgeObject__ATTACH

Properties

Key	Value
Name	main.CommunicationsEdgeObject__ATTACH
Dataset Type	Table
Dataset ID	234
Minimum Client Version	10.1
Alias	CommunicationsEdgeObject__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	{28E33ADC-05DF-4BEC-87EE-6C7146B55DA1}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Length	Editable	Required
ATTACHMENTID	ATTACHMENTID	OID	Index	False	4	False	True
REL_GLOBALID	REL_GLOBALID	GUID	Index	False	38	True	False
CONTENT_TYPE	CONTENT_TYPE	String		False	150	True	False
ATT_NAME	ATT_NAME	String		False	250	True	False
DATA_SIZE	DATA_SIZE	Long Integer		False	4	True	False
DATA	DATA	Blob		True	0	True	False
GLOBALID	GLOBALID	Global ID	Index	False	38	False	True
created_user	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

Indexes

Name	Is Unique	Is Ascending	Field Name
GDB_234_REL_GLOB	False	True	REL_GLOBALID
UUID_52	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

main.CommunicationsEdgeObject__ATTACHREL

Key	Value
Name	main.CommunicationsEdgeObject__ATTACHREL
Dataset Type	RelationshipClass
Dataset ID	245
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.CommunicationsEdgeObject
Origin Primary Key	GLOBALID
Origin Foreign Key	REL_GLOBALID
Destination Name	main.CommunicationsEdgeObject__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{B4AC74FF-77BE-4DD4-9199-A8821B4E0DAB}

main.CommunicationsJunction

Properties

Key	Value
Name	main.CommunicationsJunction
Dataset Type	FeatureClass
Feature Dataset	main.UtilityNetwork
Dataset ID	228
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	13.2
Alias	Communications Junction
OID Field	OBJECTID
GlobalID Field	GLOBALID
Subtype Field	ASSETGROUP
Default Subtype	Unknown
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Shape Field	SHAPE
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min	500372.76851503144
X-Max	1270078.1610237402
Y-Min	1550391.9656167035
Y-Max	2190094.254910357
Z-Min	0
Z-Max	122
Catalog ID	{77F25A0D-48BB-405F-B349-547C209E582B}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Controller Membership

Key	Value
utilityNetworkName	main.Network

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
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
CableSubnetwork	CableSubnetwork	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
SwitchSubnetwork	SwitchSubnetwork	String	Index	False		Unknown	2000	False	True
CommunicationsCircuit	CommunicationsCircuit	String	Index	False		Unknown	2000	False	True
assetid	Asset ID	String		True			64	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source		2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence		2	True	False
ownedby	Owned By	Short Integer		True	Asset_Owner	1	2	True	False
maintby	Maintained By	Short Integer		True	Asset_Manager	1	2	True	False
installdate	Install Date	Date		True			8	True	False
retireddate	Retired Date	Date		True			8	True	False
inservicedate	In-Service Date	Date		True			8	True	False
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		2	True	False
riserheight	riserheight	Double		True			8	True	False
hasguard	hasguard	Short Integer		True			2	True	False
guardmaterial	guardmaterial	Short Integer		True	Communications_Riser_Material		2	True	False
hasconduit	hasconduit	Short Integer		True			2	True	False
conduitmaterial	conduitmaterial	Short Integer		True	Communications_Conduit_Material		2	True	False
networklevel	Network Level	Short Integer		True	Communications_Network_Levels		2	True	False
networksite	Network Site	String		True			120	True	False
building	Building	String		True			120	True	False
floor	Floor	String		True			120	True	False
room	Room	String		True			120	True	False
aisle	Aisle	String		True			120	True	False
bay	Bay	String		True			120	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

Indexes

Name	Is Unique	Is Ascending	Field Name
GDB_228_CableSub	False	True	CableSubnetwork
GDB_228_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_228_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_228_SwitchSu	False	True	SwitchSubnetwork
GDB_228_Communic	False	True	CommunicationsCircuit
UUID_46	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__CommunicationsJunction_SHAPE	True	True	SHAPE

Subtypes

Name	Code	Details
Unknown	0
Connection Point	1

Assignments

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	CableSubnetwork	Unknown
Unknown	0	SUPPORTEDSUBNETWORKNAME	Unknown
Unknown	0	SUPPORTINGSUBNETWORKNAME	Unknown
Unknown	0	SwitchSubnetwork	Unknown
Unknown	0	CommunicationsCircuit	Unknown
Unknown	0	lifecyclestatus	2	Lifecycle_Status
Unknown	0	maintby	1	Asset_Manager
Unknown	0	ownedby	1	Asset_Owner
Unknown	0	spatialconfidence		Spatial_Confidence
Unknown	0	spatialsource		Spatial_Source
Unknown	0	symbolrotation		Symbol_Rotation
Connection Point	1	ASSETTYPE	0	Asset_Type_Communications_Junction_Connection_Point
Connection Point	1	ASSOCIATIONSTATUS	0	Network_6_AssociationStatus
Connection Point	1	ISCONNECTED	2	Network_6_IsConnected
Connection Point	1	CableSubnetwork	Unknown
Connection Point	1	SUPPORTEDSUBNETWORKNAME	Unknown
Connection Point	1	SUPPORTINGSUBNETWORKNAME	Unknown
Connection Point	1	SwitchSubnetwork	Unknown
Connection Point	1	CommunicationsCircuit	Unknown
Connection Point	1	conduitmaterial		Communications_Conduit_Material
Connection Point	1	constructionstatus	6	Construction_Status
Connection Point	1	guardmaterial		Communications_Riser_Material
Connection Point	1	hasconduit		Yes_No
Connection Point	1	hasguard		Yes_No
Connection Point	1	lifecyclestatus	2	Lifecycle_Status
Connection Point	1	maintby	1	Asset_Manager
Connection Point	1	networklevel	0	Communications_Network_Levels
Connection Point	1	ownedby	1	Asset_Owner
Connection Point	1	spatialconfidence		Spatial_Confidence
Connection Point	1	spatialsource		Spatial_Source
Connection Point	1	symbolrotation		Symbol_Rotation

Attribute Rules

CJ-GenerateIDs

Key	Value
ID	22
Minimum Client Version	12.9
Evaluation Order	1
Name	CJ-GenerateIDs
Description	Generate IDs for CommunicationsJunction 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:24
Script	// Assigned To: CommunicationsJunction // Type: Calculation // Name: CJ-GenerateIDs // Description: Generate IDs for CommunicationsJunction 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. // - SJ-GenerateIDs // - SB-GenerateIDs // - SJO-GenerateIDs // - SL-GenerateIDs // - SEO-GenerateIDs // - CD-GenerateIDs // - CJO-GenerateIDs // - CL-GenerateIDs // - CEO-GenerateIDs // *********** 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': "CPT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_J_CPT_1_seq'); } else { return null; } var id_parts = remove_empty([id_format['prefix'], seq_val, id_format['suffix']]) return Concatenate(id_parts, id_format['join_char']) } // *********** End User Variables Section ********* // ********* Functions ********* function remove_empty(arr) { var new_arr = []; var j = 0; for (var i = 0; i < Count(arr); i++) { if (!IsEmpty(arr[i]) && arr[i] != '') { new_arr[j++] = arr[i]; } } return new_arr; } // ********* End Functions Section *************** if ($editcontext.editType == 'UPDATE'){ if (IsEmpty(assigned_to_field) == false) { return assigned_to_field } } var new_id = get_id(id_selector_value) if (IsEmpty(new_id)) { return assigned_to_field; } return new_id

main.CommunicationsJunction__ATTACH

Properties

Key	Value
Name	main.CommunicationsJunction__ATTACH
Dataset Type	Table
Dataset ID	236
Minimum Client Version	10.1
Alias	CommunicationsJunction__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	{A599AFF9-8498-429C-B17A-B400A96B3BBC}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Length	Editable	Required
ATTACHMENTID	ATTACHMENTID	OID	Index	False	4	False	True
REL_GLOBALID	REL_GLOBALID	GUID	Index	False	38	True	False
CONTENT_TYPE	CONTENT_TYPE	String		False	150	True	False
ATT_NAME	ATT_NAME	String		False	250	True	False
DATA_SIZE	DATA_SIZE	Long Integer		False	4	True	False
DATA	DATA	Blob		True	0	True	False
GLOBALID	GLOBALID	Global ID	Index	False	38	False	True
created_user	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

Indexes

Name	Is Unique	Is Ascending	Field Name
GDB_236_REL_GLOB	False	True	REL_GLOBALID
UUID_54	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

main.CommunicationsJunction__ATTACHREL

Key	Value
Name	main.CommunicationsJunction__ATTACHREL
Dataset Type	RelationshipClass
Feature Dataset	main.UtilityNetwork
Dataset ID	247
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.CommunicationsJunction
Origin Primary Key	GLOBALID
Origin Foreign Key	REL_GLOBALID
Destination Name	main.CommunicationsJunction__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{C79BB947-98FB-466C-A1AE-FE284CC5B4F0}

main.CommunicationsJunctionObject

Key	Value
Name	main.CommunicationsJunctionObject
Dataset Type	Table
Dataset ID	230
Minimum Client Version	13.2
Alias	Communications 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	{C78C13DB-7D8F-4318-BA92-87DDC2893F05}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Key	Value
utilityNetworkName	main.Network

Name	Is Unique	Is Ascending	Field Name
GDB_230_SUBNETWO	False	True	SUBNETWORKCONTROLLERNAME
GDB_230_CableSub	False	True	CableSubnetwork
GDB_230_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_230_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_230_SwitchSu	False	True	SwitchSubnetwork
GDB_230_Communic	False	True	CommunicationsCircuit
UUID_48	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID

main.CommunicationsJunctionObject__ATTACH

Properties

Fields

Indexes

main.CommunicationsJunctionObject__ATTACHREL

main.CommunicationsLine

Properties

Controller Membership

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
ISCONNECTED	Is connected	Short Integer		False	Network_6_IsConnected	2	2	False	True
FROMDEVICETERMINAL	From device terminal	Short Integer		False	Network_6_TerminalNames	0	2	True	True
TODEVICETERMINAL	To device terminal	Short Integer		False	Network_6_TerminalNames	0	2	True	True
FLOWDIRECTION	Flow direction	Short Integer		True	Network_6_FlowDirection	1	2	True	True
SHAPE	Shape	Geometry	Index	False			8	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
CableSubnetwork	CableSubnetwork	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
SwitchSubnetwork	SwitchSubnetwork	String	Index	False		Unknown	2000	False	True
CommunicationsCircuit	CommunicationsCircuit	String	Index	False		Unknown	2000	False	True
assetid	Asset ID	String		True			64	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
cablegrade	Cable Grade	Short Integer		True	Communications_Fiber_Cable_Grade		2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source		2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence		2	True	False
ownedby	Owned By	Short Integer		True	Asset_Owner	1	2	True	False
maintby	Maintained By	Short Integer		True	Asset_Manager	1	2	True	False
installdate	Install Date	Date		True			8	True	False
retireddate	Retired Date	Date		True			8	True	False
inservicedate	In-Service Date	Date		True			8	True	False
searchdistance	Structure Search Distance	Double		True			8	True	False
measuredlength	Measured Length	Double		True			8	True	False
strandgroupcount	Strand Group Count	Short Integer		True	Communications_Strand_Group_Counts		2	True	False
strandcount	Strand Count	Short Integer		True		0	2	True	False
generatefromports	Generate From Ports when cable created	Short Integer		True	Yes_No	1	2	True	False
generatetoports	Generate To Ports when cable created	Short Integer		True	Yes_No	1	2	True	False
strandsavailable	Strands Available	Short Integer		True		0	2	True	False
strandsreserved	Strands Reserved	Short Integer		True		0	2	True	False
strandsdedicated	Strands Dedicated	Short Integer		True		0	2	True	False
strandsunusable	Strands Unusable	Short Integer		True		0	2	True	False
strandsinuse	Stands In Use	Short Integer		True		0	2	True	False
strandspendingconnect	Strands Pending Customer Connection	Short Integer		True			2	True	False
strandspendingdisconnect	Strands Pending Customer Disconnect	Short Integer		True			2	True	False
cablename	Name	String		True			120	True	False
diameter	Diameter	Double		True			8	True	False
networksite	Network Site	String		True			120	True	False
building	Building	String		True			120	True	False
floor	Floor	String		True			120	True	False
room	Room	String		True			120	True	False
aisle	Aisle	String		True			120	True	False
bay	Bay	String		True			120	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
VALIDATIONSTATUS	Validation status	Short Integer	Index	True	Validation Status	6	2	False	True
st_length(SHAPE)	SHAPE_Length	Double	Length	True			0	False	True

Indexes

Subtypes

Assignments

Attribute Rules

CL-GenerateIDs

Key	Value
ID	25
Minimum Client Version	12.9
Evaluation Order	1
Name	CL-GenerateIDs
Description	Generate IDs for CommunicationsLine 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:28
Script	// Assigned To: CommunicationsLine // Type: Calculation // Name: CL-GenerateIDs // Description: Generate IDs for CommunicationsLine 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. // - SJ-GenerateIDs // - SB-GenerateIDs // - SJO-GenerateIDs // - SL-GenerateIDs // - SEO-GenerateIDs // - CD-GenerateIDs // - CJ-GenerateIDs // - CJO-GenerateIDs // - CEO-GenerateIDs // *********** 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': "Sbmrn-Cbl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_L_Sbmrn_Cbl_20_seq'); }else if (selector_value_txt == '25') { id_format = { 'prefix': "Ntnl-Cbl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_L_Ntnl_Cbl_25_seq'); }else if (selector_value_txt == '30') { id_format = { 'prefix': "Rgnl-Cbl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_L_Rgnl_Cbl_30_seq'); }else if (selector_value_txt == '35') { id_format = { 'prefix': "Dstrbtn-Cbl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_L_Dstrbtn_Cbl_35_seq'); }else if (selector_value_txt == '40') { id_format = { 'prefix': "Accss-Cbl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_L_Accss_Cbl_40_seq'); }else if (selector_value_txt == '45') { id_format = { 'prefix': "Drp-Cbl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_L_Drp_Cbl_45_seq'); }else if (selector_value_txt == '50') { id_format = { 'prefix': "Indr-Cbl", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_L_Indr_Cbl_50_seq'); }else if (selector_value_txt == '60') { id_format = { 'prefix': "Wrlss", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('C_L_Wrlss_60_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

CL-Connection Point At Vertex

Key	Value
ID	26
Minimum Client Version	12.9
Evaluation Order	2
Name	CL-Connection Point At Vertex
Description	Create connection points at vertex. Generates connection points at a vertex when within a distance of a structure junction.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:28
Script	// Assigned To: CommunicationsLine // Type: Calculation // Name: CL-Connection Point At Vertex // Description: Create connection points at vertex. Generates connection points at a vertex when within a distance of a structure junction. // Subtypes: All // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'assetgroup', 'assettype', 'searchdistance'); // Limit the rule to valid asset groups/subtypes // Implementation Note: Instead of recreating this rule for each subtype, this rule uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. var valid_asset_groups = [20, 25, 30, 35, 40, 45, 50, 60]; // Optionally limit rule to specific asset types. // Implementation Note: Add to list to limit rule to specific asset types. If not specified, will be ignored. var valid_asset_types = []; // Call the StructureJunction class on which a distance search can be performed // Implementation Note: Only update the class name and field names if they differ. var structure_junc_class = 'StructureJunction'; var structure_junc_fs = FeatureSetByName($datastore, "{C8FDCC27-3587-4A33-8949-10F094BC7F8B}", ["GLOBALID", "AssetGroup", "AssetType"], true); // Call the CommunicationsJunction class to check for existing Connection Points // Implementation Note: Only update the class name and field names if they differ. var communications_junc_fs = FeatureSetByName($datastore, "{77F25A0D-48BB-405F-B349-547C209E582B}", ["GLOBALID", "AssetGroup", "AssetType"], true); // Limit StructureJunction features to certain Asset Groups and Asset Types // Implementation Note: This SQL query limits which Structure Junction features are considered in distance search var filter_sql = "AssetGroup in (101, 103, 104, 105, 107, 110, 111, 113, 125, 134) and " + "AssetType in (81, 102, 121, 161, 162, 163, 221, 222, 223, 224, 241, 242, 361, 581, 582)"; // The maximum distance from a structure junction feature to create connection points // Implementation Note: This value is derived from the field. If field is null or empty, the value will default // to number shown in second parameter. var search_distance = DefaultValue($feature.searchdistance, 35); // The unit of the distance value in search_distance // Implementation Note: Options for Unit of Measure: https://developers.arcgis.com/arcade/function-reference/geometry_functions/#units-reference var search_unit = 9002; // Connection point settings. The class name, asset group, and asset type of the connection points to be generated. // Implementation Note: Asset type will differ depending on if connection point is an attachment or container. var connection_point_class = 'CommunicationsJunction'; var connection_point_AG = 1; var connection_point_AT_over = 1; // Overhead var connection_point_AT_under = 3; // Underground function association_type_lookup(asset_group, asset_type) { // Translate the Asset group and Asset Type of the Structure to the type of association and // the asset type of the connection point // The return is Association Type and Connection Point Asset Type // These are the asset types for the connection point // 1 = Overhead // 3 = Underground return Decode(Text(asset_group), "111", ['attachment',connection_point_AT_over], // Communications Tower "113", ['attachment',connection_point_AT_over], // Wire Customer Attachment "125", ['attachment',connection_point_AT_over], // Communications Pole "101", ['attachment',connection_point_AT_under], // Wire Cabinet "103", ['attachment',connection_point_AT_under], // Wire Handhole "104", ['attachment',connection_point_AT_under], // Wire Junction Box "105", ['attachment',connection_point_AT_under], // Wire Vault Access Point "107", ['attachment',connection_point_AT_under], // Wire Pedestal "110", ['attachment',connection_point_AT_under], // Wire Vault "134", ['containment', iif(Text(asset_type)=="162", connection_point_AT_over, connection_point_AT_under)], // Wire Microduct null); } // ********* End User Variables Section ********* // ********* Functions *********** function build_assoc(tag, container_guid, association_type) { // Contain or Attach Connection Point to Structure Junction return { "fromClass": structure_junc_class, "fromGlobalID": container_guid, "toClass": connection_point_class, "toGlobalID": tag + ".globalid", "associationType": association_type }; } function nearly_equal(a, b, sig_fig) { // check if nearly equal to certain significant figure https://stackoverflow.com/a/558289/12665063 return (a==b \|\| Round(a * Pow(10, sig_fig), 0) == Round(b * Pow(10, sig_fig), 0)) } // Used to check different empty null states, override of core IsEmpty function IsEmptyButBetter(data) { if (IsEmpty(data)) return true; for (var x in data) return false; return true; } // *********** End Functions Section **************** // Validation if (!Includes(valid_asset_groups, $feature.assetgroup)) { return; } if (Count(valid_asset_types) > 0 && !Includes(valid_asset_types, $feature.assettype)) { return; } // Buffer the line feature to find structure features within a certain distance var closest_features = Intersects(structure_junc_fs, Buffer(Geometry($feature), search_distance, search_unit)); // Filter the closest results based on the sql to get assets of a certain type var filtered_features = Filter(closest_features, filter_sql); var closest_features = []; for (var structure_feat in filtered_features) { Push(closest_features, [Geometry(structure_feat), structure_feat.globalid, structure_feat.AssetGroup, structure_feat.AssetType]); } var closest_structure_count = Count(closest_features); if (closest_structure_count == 0) { return; } // Get feat set of connection points to check if they already exist var connection_point_sql = "AssetGroup = @connection_point_AG and AssetType in (@connection_point_AT_over, @connection_point_AT_under)"; var filtered_connections = Filter(communications_junc_fs, connection_point_sql); var line_geo = Geometry($feature); var line_vertices = line_geo['paths'][0]; var new_connection_points = []; var used_structures = []; var un_adds = []; if (Count(line_vertices) > 2) { for (var i = 1; i < Count(line_vertices) - 1; i++) { // find closest structure junc to each vertex var structure_candidate = []; var closest_found_dist = search_distance; for (var j in closest_features) { var structure_feat = closest_features[j]; if (Count(used_structures) == closest_structure_count) { break; } if (Includes(used_structures, structure_feat[1])) { continue; } var dist = Distance(line_vertices[i], structure_feat[0], search_unit); if (dist <= closest_found_dist) { closest_found_dist = dist; structure_candidate = structure_feat; } } if (IsEmptyButBetter(structure_candidate)) continue; // structure candidate has been found, create connection point // check to see if there is already a conn point, move to next vertex if there is var inter_fs = Intersects(filtered_connections, line_vertices[i]); if (Count(inter_fs) > 0) { // cycle any intersecting Conn Points to see if Z is same as vertex. if so, don't need a new Conn Point. var same_xyz = false; var vert_z = line_vertices[i]['z']; for (var conn in inter_fs) { if (nearly_equal(Geometry(conn).z, vert_z, 2)) { // sig_fig: 2, 0=0.001, 0!=0.01 same_xyz = true; break; } } if(same_xyz) continue; } // See if the feature that we are trying to associate with needs a containment or attachment association var assoc_result = association_type_lookup(structure_candidate[2], structure_candidate[3]); if (IsEmptyButBetter(assoc_result)) { continue; } var attributes = { 'AssetGroup': connection_point_AG, 'AssetType': assoc_result[1] }; push(new_connection_points, { 'tag': 'connpoint' + Text(i), 'attributes': attributes, 'geometry': line_vertices[i] }); push(un_adds, build_assoc('connpoint' + Text(i), structure_candidate[1], assoc_result[0])); push(used_structures, structure_candidate[1]); } } // If not feature was found, exit if (Count(new_connection_points) < 1) { return; } var edit_payload = [ {'className': connection_point_class, 'adds': new_connection_points}, {'className': '^UN_Association', 'adds': un_adds} ]; return { "edit": edit_payload };

CL-Contain Communications Line In Structure Line

Key	Value
ID	27
Minimum Client Version	12.9
Evaluation Order	3
Name	CL-Contain Communications Line In Structure Line
Description	Rule searches for structure line containers within a certain distance to contain the cable in it.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:28
Script	// Assigned To: CommunicationsLine // Type: Calculation // Name: CL-Contain Communications Line In Structure Line // Description: Rule searches for structure line containers within a certain distance to contain the cable in it. // Subtypes: All // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'assetgroup', 'assettype', 'assetid', 'searchdistance'); // Limit the rule to valid asset groups/subtypes of Cables // Implementation Note: Instead of recreating this rule for each subtype, this rule uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. var valid_asset_groups = [20, 25, 30, 35, 40, 45, 50, 60]; // Optionally limit rule to specific asset types. // Implementation Note: Add to list to limit rule to specific asset types. If not specified, will be ignored var valid_asset_types = []; // Exclude specific asset group and asset type combinations. // Implementation Note: Specific Cable types can be excluded by adding to this list in following format [AG, AT] var invalid_ag_and_at = [[5, 4]]; // Structure Line container class name // Implementation Note: This is the name of the class used to create containers for Cables var structure_line_class = 'StructureLine'; var structure_edge_class = 'StructureEdgeObject'; // Call the StructureLine class on which a distance search will be performed // Implementation Note: Only update the class name and field names if they differ. var structure_line_fs = FeatureSetByName($datastore, '{D6857479-89AC-4610-9AF6-030EB2C3573D}', ["GLOBALID", "ASSOCIATIONSTATUS", "AssetType", "AssetGroup"], true); var structure_edge_fs = FeatureSetByName($datastore, '{795137F1-9555-4E75-A722-02F64845CB82}', ["GLOBALID", "ASSOCIATIONSTATUS", "AssetType", "AssetGroup"], false); // Limit StructureLine features to certain Asset Groups and Asset Types // Implementation Note: This SQL query limits which Structure Line features are considered for containers in distance search // A cable can be in a duct(edge in a duct bank), aerial span, lashing guy, conduit, tunnel var sl_container_sql = "AssetGroup in (102, 103, 104, 109, 112) and AssetType in (81, 101, 125, 127, 121, 221)"; // list of AG/AT values in a string format to identify if the object has edges that the cable should be contained in var ag_at_edge_containment = ['102,81']; // Set the container asset types that can only contain one child item, a duct and conduit can only have one cable // List the asset types in order that a cable should be contained in first. In industry data model this is duct, conduit, and then lashing guy. // Implementation Note: These values do not need to change if using the industry data model. var restrict_to_one_content = [41, 121]; var contain_cable_in_first = [41, 121, 127]; // The maximum distance a structure line container can be from the Cable // Implementation Note: This value is derived from the field. If field is null or empty, the value will default // to number shown in second parameter. var search_distance = DefaultValue($feature.searchdistance, 75); // The unit of the distance value in search_distance // Implementation Note: Options for Unit of Measure: https://developers.arcgis.com/arcade/function-reference/geometry_functions/#units-reference var search_unit = 9002; // *********** End User Variables Section ********* // ********* Functions ********* function sortCandidates(a, b) { if (!Includes(contain_cable_in_first, a['at']) && !Includes(contain_cable_in_first, b['at'])) { if (a['distance'] < b['distance']) return -1; if (a['distance'] > b['distance']) return 1; return 0; } else if (Includes(contain_cable_in_first, a['at']) && Includes(contain_cable_in_first, b['at'])) { if (a['distance'] < b['distance']) return -1; if (a['distance'] > b['distance']) return 1; return 0; } else if (Includes(contain_cable_in_first, a['at'])) { return -1; } return 1; } // ********* End Functions Section **************** // Validation if (!Includes(valid_asset_groups, $feature.assetgroup)) { return; } if (Count(valid_asset_types) > 0 && !Includes(valid_asset_types, $feature.assettype)) { return; } for (var idx in invalid_ag_and_at) { var ag_and_at = invalid_ag_and_at[idx]; if (ag_and_at[0] == $feature.assetgroup && ag_and_at[1] == $feature.assettype) { return; } } var line_geo = Geometry($feature); // Buffer the features to find features within a certain distance var closest_structure_lines = Intersects(structure_line_fs, Buffer(line_geo, search_distance, search_unit)); // Filter the closest results to structures we can use for containment var closest_structures_fs = Filter(closest_structure_lines, sl_container_sql); // This is a list of features that can contain an item // Format Geometry(parent container in case of an edge), GlobalID, AssetType, Class, restrict to one flag var container_features = []; for (var feat in closest_structures_fs) { var feat_geo = Geometry(feat); // If the structure feature has edges that content the feature, get their edges and not the feature if (Includes(ag_at_edge_containment, `${feat.AssetGroup},${feat.AssetType}`)) { var edge_content = FeatureSetByAssociation(feat, "content"); var edge_feats = Filter(edge_content, "className = @structure_edge_class"); for (var edge_feat in edge_feats) { // If the object is restricted to one contained item and has content, skip it if ((edge_feat.ASSOCIATIONSTATUS & 0x1) > 0 && Includes(restrict_to_one_content, edge_feat.AssetType)) { continue; } // Store the edge info, but the containing line geo Push(container_features, [feat_geo, edge_feat.globalid, edge_feat.assettype, structure_edge_class]); } } else { // If the object is restricted to one contained item and has content, skip it if ((feat.ASSOCIATIONSTATUS & 0x1) > 0 && Includes(restrict_to_one_content, feat.AssetType)) { continue; } Push(container_features, [feat_geo, feat.globalid, feat.assettype, structure_line_class]); } } if (Count(container_features) == 0) { return; } // Loop thru each segment to find potential containers var line_vertices = line_geo['paths'][0]; var vertex_count = Count(line_vertices); var structure_containers = []; var structure_edge_containers = []; var added_to = []; for (var vert_idx = 0; vert_idx < vertex_count - 1; vert_idx++) { var structure_candidates = []; // Check to see if point is between vertexs var from_point = line_vertices[vert_idx]; var to_point = line_vertices[vert_idx + 1]; var pointJSON = { "x": (from_point.x + to_point.x) / 2, "y": (from_point.y + to_point.y) / 2, "spatialReference": {"wkid": line_geo.spatialReference.wkid} }; var mid_point = Point(pointJSON); // find structure features that could be used as container for (var i in container_features) { var struct_feat = container_features[i]; var dist = Distance(struct_feat[0], mid_point, search_unit); if (dist < search_distance / 2) { push(structure_candidates, { 'at': struct_feat[2], 'globalid': struct_feat[1], 'distance': dist, 'class': struct_feat[3] }); } } if (Count(structure_candidates) == 0) { continue; } // Sort the candidates by what the cable should be in first and by distance var sorted_candidates = Sort(structure_candidates, sortCandidates); var parent_globalid = sorted_candidates[0]['globalid']; // If the parent has already been added as a container, dont add it more than once if (Includes(added_to, parent_globalid)) { continue; } if (sorted_candidates[0]['class'] == structure_line_class) { push(structure_containers, { 'globalID': parent_globalid, 'associationType': 'container' }); } else if (sorted_candidates[0]['class'] == structure_edge_class) { push(structure_edge_containers, { 'globalID': parent_globalid, 'associationType': 'container' }); } push(added_to, parent_globalid); } if (Count(structure_containers) == 0 && Count(structure_edge_containers) == 0) { return; } var edit_payload = []; if (Count(structure_containers) > 0) { push(edit_payload, { 'className': structure_line_class, 'updates': structure_containers }); } if (Count(structure_edge_containers) > 0) { push(edit_payload, { 'className': structure_edge_class, 'updates': structure_edge_containers }); } return { "edit": edit_payload };

CL-Create Strands in Cable

Key	Value
ID	28
Minimum Client Version	12.9
Evaluation Order	4
Name	CL-Create Strands in Cable
Description	Generates strands inside a cable based on the strand count field. Must be snapped to a Cable Terminator, Splice Enclosure, or Splitter Enclosure. Will create Connectors and connect strands.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:28
Script	// Assigned To: CommunicationsLine // Type: Calculation // Name: CL-Create Strands in Cable // Description: Generates strands inside a cable based on the strand count field. Must be snapped to a Cable Terminator, Splice Enclosure, or Splitter Enclosure. Will create Connectors and connect strands. // Subtypes: All // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'assetgroup', 'assettype', 'StrandCount', 'StrandGroupCount', 'generatefromports', 'generatetoports', 'measuredlength'); // Limit the rule to valid asset groups/subtypes // Implementation Note: Instead of recreating this rule for each subtype, this rules uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. var asset_group = $feature.assetgroup; var valid_asset_groups = [20, 25, 30, 35, 40, 45, 50, 60]; // Limit the rule to valid asset types // Implementation Note: Instead of recreating this rule for each asset type, this rules uses a list of domains and exits if not valid // If you have added Asset Types, they will need to be added to this list. Industry data model allows coax, copper, and fiber var coax_at = 1; var copper_at = 2; var fiber_at = 3; var tower_fiber_at = 4; // The class names of the Strands, Devices, non-spatial Strands, and non-spatial Devices // Implementation Note: These are just the class/table name and should not be fully qualified. var device_class = "CommunicationsDevice"; var strand_edge_class = "CommunicationsEdgeObject"; var device_obj_class = "CommunicationsJunctionObject"; // The fields for Strand Count, Tube Count // Implementation Note: Adjust these values only if the field names differ var strand_count = $feature.StrandCount; var tube_count = $feature.StrandGroupCount; // The fields for generatefromports and generatetoports // Implementation Note: These variables control whether Ports (Connectors) are created at the from and to point that the cable snaps to var create_fromports = $feature.generatefromports; var create_toports = $feature.generatetoports; // Strand Connector and Connector Group asset types mapping // Implementation Note: Map the asset type code of the cable to the asset type of the Strands and the Connectors // that should be created for strand ends function cable_to_conn_at(id) { return Decode(id, 1, 122, // AT Coax Cable: AT Coax Connector 2, 123, // AT Copper Cable: AT Copper Connector 3, 124, // AT Fiber Cable: AT Fiber Connector id) } function cable_to_strand_at(id) { return Decode(id, 1, 161, // AT Coax Cable: AT Coax Strand 2, 162, // AT Copper Cable: AT Copper Strand 3, 163, // AT Fiber Cable: AT Fiber Strand id) } // The Asset Group of the strand // Implementation Note: Adjust this only if the asset group of Strands differs var strands_AG = 8; // The Asset Group of new Connectors created for strands // Implementation Note: When a strand is created in a cable, strand Connectors are created at each endpoint of strand. // Adjust these only if the asset group Connectors differ. var new_strand_connector_AG = 4; // The Asset Group of new Connector Group created at Cable ends // Implementation Note: When a cable is created and snapped to a Splitter, Splice, Hub Terminator, or Network Interface Unit // a Connector Group (non-spatial) is created as content of snapped feature, and will contain Connectors. var new_conn_group_AG = 1; // Strand status default value for all Strands created // Implementation Note: This sets the Strand Status value to "Available" on all child Strands created by this rule. var strand_status_avail = 1; // The Asset Group and Asset Type of Cable Component types // Implementation Note: The Asset Type value specifies what type of Cable Component that a Cable can snap to. var cable_snap_types = 'AssetGroup in (20,25,30,35,40,45,50,60) and AssetType in (1,3,4,5,6,7,201,221,220,223)'; // The terminal name on the Connector // Implementation Note: The name of the terminal used in junctionEdgeFrom and junctionEdgeTo associations between Connectors and Strands. var terminal_name = "C:Back"; // Names of strand status fields on the strands // Implementation Note: These are used to populate the "strand counts" fields on the cable. Adjust these only if the fields names differ. var strands_available = "strandsavailable"; var strands_dedicated = "strandsdedicated"; var strands_inuse = "strandsinuse"; var strands_pendingconnect = "strandspendingconnect"; var strands_pendingdisconnect = "strandspendingdisconnect"; var strands_reserved = "strandsreserved"; var strands_unusable = "strandsunusable"; // The unit of measure used to calculate length // Implementation Note: Options for Unit of Measure: https://developers.arcgis.com/arcade/function-reference/geometry_functions/#units-reference var unit_of_measure = 'feet'; // ********* End User Variables Section ********* // ********* Functions ********* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function is_even(value) { return (Number(value) % 2) == 0; } function get_snapped_container_info(point_geo) { // Get guid of point that intersects point_geo. Must match an AG and AT group specified in cable_snap_types. var container_GUID = null; var device_fs = get_features_switch_yard($datastore, device_class, ["globalid", "assetgroup", 'assettype'], false); if (IsEmpty(device_fs)) return container_GUID; var snapped_feats = Intersects(device_fs, Point(point_geo)); var snapped_feat = First(Filter(snapped_feats, cable_snap_types)); if (!IsEmpty(snapped_feat)) { container_GUID = snapped_feat['globalid']; } return container_GUID; } function conn_group_payload(fromto) { // Build payload to create new Connectory Group var new_conn_group_attributes = { 'AssetGroup': new_conn_group_AG, 'AssetType': cable_to_conn_at($feature.assettype) }; var new_conn_group = { "tag": fromto + "conngroup", "attributes": new_conn_group_attributes, "associationType": "container" }; return new_conn_group; } function contain_conn_group(conn_group_tag, container_guid, un_adds) { // Contain Connector Group in Device that the Cable is snapping to var device_contain_conn = { "fromClass": device_class, "fromGlobalID": container_guid, "toClass": device_obj_class, "toGlobalID": conn_group_tag + ".globalid", "associationType": "containment" }; push(un_adds, device_contain_conn); } function strand_conn_payload(new_junc_objs, un_adds, strand_id, tube_id, conn_group, association_type) { // Build payload to create new strand Connector and // 1. contain it in new Connector Group // 2. connect Connector(s) to the Strand(s) contained in Cable // Do not generate Connectors if generateFromPorts or generateToPorts field is not Yes. Can do this by checking if conn_group is null. if (IsEmpty(conn_group)) return; // Create new Connector var new_junction_attributes = { 'AssetGroup': new_strand_connector_AG, 'AssetType': cable_to_conn_at($feature.assettype), }; var new_junction = { "tag": tube_id + '-' + strand_id + association_type, // will always be unique 'attributes': new_junction_attributes }; push(new_junc_objs, new_junction); // Contain Connector in the Connector Group contained in the Device the Cable is snapping to var group_contain_conn = { "fromClass": device_obj_class, "fromGlobalID": conn_group['tag'] + ".globalid", "toClass": device_obj_class, "toGlobalID": tube_id + '-' + strand_id + association_type + ".globalid", "associationType": "containment" }; // Connect Connector to Strand in the Cable var strand_connect_conn = { "fromClass": device_obj_class, "fromGlobalID": tube_id + '-' + strand_id + association_type + ".globalid", "fromTerminal": terminal_name, "toClass": strand_edge_class, "toGlobalID": "strand" + tube_id + '-' + strand_id + ".globalid", "associationType": association_type }; push(un_adds, group_contain_conn); push(un_adds, strand_connect_conn); } function strand_status_for_cable() { // update strand status attributes on cable. default for all strands is 'available'. var attrs = Dictionary(strands_available, strand_count, strands_dedicated, 0, strands_inuse, 0, strands_pendingconnect, 0, strands_pendingdisconnect, 0, strands_reserved, 0, strands_unusable, 0); return {"attributes": attrs}; } // ********* End Functions Section **************** // Validation // Limit the rule to valid asset groups if (!Includes(valid_asset_groups, asset_group)) { return; } // Limit the rule to valid asset types if (!Includes([fiber_at, copper_at, coax_at, tower_fiber_at], $feature.assettype)) { return; } // Require a value for fiber count if (IsEmpty(strand_count) \|\| strand_count == 0) { return {'errorMessage': 'A value is required for the strand count field'}; } // Require a value for generateFromPorts if (!Includes([1, 2], create_fromports)) { return {'errorMessage': 'A value is required for the generateFromPorts field'}; } // Require a value for generateToPorts if (!Includes([1, 2], create_toports)) { return {'errorMessage': 'A value is required for the generateToPorts field'}; } // Fiber count must be even if not 1 strand if (strand_count > 1 && is_even(strand_count) == false) { return {'errorMessage': 'Fiber count must be even if not one strand'}; } // Get the tube count based on the cable design and strand count var coax_copper_tube_provided = true; if (IsEmpty(tube_count) && Includes([fiber_at, tower_fiber_at], $feature.assettype)) { return {'errorMessage': 'Number of tubes is required for fiber'}; } else if (IsEmpty(tube_count)) { tube_count = 1; coax_copper_tube_provided = false; } // Ensure the strand distribution is even var strand_per_tube = iif(strand_count == 1, 1, strand_count / tube_count); if (strand_per_tube > 1 && strand_per_tube % 1 != 0) { return { 'errorMessage': 'Fiber per tube distribution is not uniform: ' + 'Fiber Count: ' + strand_count + TextFormatting.NewLine + 'Tube Count: ' + tube_count + TextFormatting.NewLine + 'Strands Per Tube: ' + strand_per_tube }; } // Get the start and end vertex of the line var assigned_line_geo = Geometry($feature); var vertices = assigned_line_geo['paths'][0]; var from_point = vertices[0]; var to_point = vertices[-1]; // Get the snapped container. This could be a device var from_container_GUID = get_snapped_container_info(Point(from_point)); var to_container_GUID = get_snapped_container_info(Point(to_point)); if (IsEmpty(from_container_GUID)) { return {'errorMessage': 'A Cable must start at a Cable terminator, splice, or splitter'}; } if (IsEmpty(to_container_GUID)) { return {'errorMessage': 'A Cable must end at a Cable terminator, splice, or splitter'}; } // Create non-spatial Strands, Connector Groups, and Connectors var new_strands = []; var attributes = {}; var new_device_objs = []; var un_adds = []; // only create Connector Groups if generateFromPorts/generateToPorts is set to Yes var from_conn_group = null; var to_conn_group = null; if (create_fromports == 1) { from_conn_group = conn_group_payload('from'); push(new_device_objs, from_conn_group); contain_conn_group(from_conn_group['tag'], from_container_GUID, un_adds); } if (create_toports == 1) { to_conn_group = conn_group_payload('to'); push(new_device_objs, to_conn_group); contain_conn_group(to_conn_group['tag'], to_container_GUID, un_adds); } var length_value = $feature.measuredlength; // Only calculate if field is null or zero if (IsEmpty(length_value) \|\| length_value == 0) { length_value = Length(assigned_line_geo, unit_of_measure); } // build payload for strands when cable is snapped to terminator, splitter, or splice for (var tube_index = 1; tube_index <= tube_count; tube_index++) { for (var strand_index = 1; strand_index <= strand_per_tube; strand_index++) { // build payload to create new Connector and associate it to Device and Strand strand_conn_payload(new_device_objs, un_adds, Text(strand_index), Text(tube_index), from_conn_group, 'junctionEdgeFrom'); strand_conn_payload(new_device_objs, un_adds, Text(strand_index), Text(tube_index), to_conn_group, 'junctionEdgeTo'); // strand attributes attributes = { 'AssetGroup': strands_AG, 'AssetType': cable_to_strand_at($feature.assettype), // if copper we need to scale by 1000 'StrandID': iif($feature.assettype == copper_at, strand_index + 1000, strand_index), 'StrandStatus': strand_status_avail, 'measuredlength': length_value, }; // only add TubeID if cable is Fiber or tube count provided for coax and copper if (Includes([fiber_at, tower_fiber_at], $feature.assettype) \|\| coax_copper_tube_provided) { // if copper we need to scale by 1000 attributes['StrandGroupID'] = iif($feature.assettype == copper_at, tube_index + 1000, tube_index); } push(new_strands, { 'tag': 'strand' + Text(tube_index) + '-' + Text(strand_index), 'attributes': attributes, 'associationType': 'content' }); } } var edit_payload = [{ 'className': strand_edge_class, 'adds': new_strands }, { 'className': device_obj_class, 'adds': new_device_objs }, { 'className': '^UN_Association', 'adds': un_adds }]; var cable_attrs = strand_status_for_cable(); cable_attrs['measuredlength'] = length_value; return { "result": cable_attrs, "edit": edit_payload };

CL-MeasuredLength From Shape Set Content

Key	Value
ID	29
Minimum Client Version	12.9
Evaluation Order	5
Name	CL-MeasuredLength From Shape Set Content
Description	Calculate MeasureLength field using length of line in specified units. Pass value to any content Strands if they exist.
Type	Calculation
Batch	False
Insert Trigger	False
Update Trigger	True
Delete Trigger	False
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:29
Script	// Assigned To: CommunicationsLine // Type: Calculation // Name: CL-MeasuredLength From Shape Set Content // Description: Calculate MeasureLength field using length of line in specified units. Pass value to any content Strands if they exist. // Subtypes: All // Trigger: Update // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - Line - Create Strands In Cable - Create Strands rule calcuates the length on insert // 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. // - StructureLine - MeasuredLength From Shape // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'measuredlength'); // Field in the data model used to store measured length // Implementation Note: This value does not need to change if using the industry data model. Fields need to be // declared with dot syntax. var measured_length_field = "measuredlength"; var measured_length = $feature.measuredlength; var orig_measured_length = $originalfeature.measuredlength; // The class name of the content objects. MeasuredLength value will be pushed to any content of Line. // Implementation Note: This is just the class name and should not be fully qualified. Adjust this only if class name differs. var contained_edge_class = "CommunicationsEdgeObject"; var contained_edge_fs = FeatureSetByName($datastore, "{40E3C2C1-D5BF-4F8E-98A4-22E698D729E9}", [], false); // Settings for content. contained sql expression. // Implementation Note: Only content features that match sql statement will be used to update $feature attributes. var contained_sql = "AssetGroup in (8) and AssetType in (161, 162, 163)"; // The unit of measure used to calculate length // Implementation Note: Options for Unit of Measure: https://developers.arcgis.com/arcade/function-reference/geometry_functions/#units-reference var unit_of_measure = 'feet'; // ********* End User Variables Section ********* // ********* Functions ********* function get_content_ids(feature) { // Query to get all the content associations var associations = FeatureSetByAssociation(feature, "content"); // Due to a bug in MGDB, where class name is fully qualified, filter is not used, but can be once resolved // var filtered = Filter(associations, "className = @contained_edge_class"); // loop over all associated records to get a list of IDs var associated_edge_ids = []; for (var row in associations) { if (Lower(Split(row.classname, '.')[-1]) == Lower(contained_edge_class)) { push(associated_edge_ids, row.globalId); } } return associated_edge_ids; } // ********* End Functions Section **************** // Calculate measuredlength field based on edit context. Do not calculate unless field is null or zero. var new_measured_length = null; if (orig_measured_length != measured_length) { // measuredlength field has been manually updated. Pass it to any content containeds. new_measured_length = measured_length; } else if (IsEmpty(measured_length) \|\| measured_length <= 0) { new_measured_length = Length(Geometry($feature), unit_of_measure); } else { // Never overwrite an existing valid measuredlength value, even if geometry is updated. return; } // get ids of content objects var content_ids = get_content_ids($feature); if (Count(content_ids) == 0) { return { "result": { "attributes": Dictionary(measured_length_field, new_measured_length) } }; } var contained_contents = Filter(contained_edge_fs, "globalid in @content_ids and " + contained_sql); // build return payload var updates = []; for (var contained in contained_contents) { push(updates, { 'globalID': contained.globalid, 'attributes': Dictionary(measured_length_field, new_measured_length) }); } if (Count(updates) == 0) { return { "result": { "attributes": Dictionary(measured_length_field, new_measured_length) } }; } var edit_payload = [{ 'className': contained_edge_class, 'updates': updates }]; return { "result": { "attributes": Dictionary(measured_length_field, new_measured_length) }, "edit": edit_payload };

CL-Batch Strand Status

Key	Value
ID	30
Minimum Client Version	12.9
Evaluation Order	1
Name	CL-Batch Strand Status
Description	When calculation is required, update strand status fields of Cable based on attributes of content of Cable.
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:29
Script	// Assigned To: CommunicationsLine // Type: Calculation // Name: CL-Batch Strand Status // Description: When calculation is required, update strand status fields of Cable based on attributes of content of Cable. // Subtypes: All // Batch: True // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - CEO - Require Calculation: set calculation required on Cable, which indicates this batch rule should run // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'strandstatus'); // Name of strand status field on a Strand var strand_status = "strandstatus"; // The class name of the content Strands // Implementation Note: This is just the class name and should not be fully qualified. Adjust this only if class name differs. var contained_edge_class = "CommunicationsEdgeObject"; var contained_edge_fs = FeatureSetByName($datastore, "{40E3C2C1-D5BF-4F8E-98A4-22E698D729E9}", [strand_status], false); // Settings for content. Strand sql expression. // Implementation Note: Only content features that match sql statement will be used to update $feature attributes. var strand_sql = "AssetGroup in (8) and AssetType in (161, 162, 163)"; // Names of strand status fields on a Cable // Implementation Note: These are used to populate the "strand counts" fields on the cable. Adjust these only if the fields names differ. var strand_count = "strandcount"; var strands_available = "strandsavailable"; var strands_dedicated = "strandsdedicated"; var strands_inuse = "strandsinuse"; var strands_pendingconnect = "strandspendingconnect"; var strands_pendingdisconnect = "strandspendingdisconnect"; var strands_reserved = "strandsreserved"; var strands_unusable = "strandsunusable"; // Cable strand attributes which will be updated if strand status changes // Implementation Note: Adjust only if strand status names or coded values differ function strand_status_id_to_name(id) { return Decode(Text(id), "1", strands_available, "2", strands_inuse, "3", strands_reserved, "4", strands_dedicated, "5", strands_unusable, "6", strands_pendingconnect, "7", strands_pendingdisconnect, Text(id)); } // ********* End User Variables Section ********* // ********* Functions ********* function get_content_ids(feature) { // Query to get all the content associations var associations = FeatureSetByAssociation(feature, "content"); // Due to a bug in MGDB, where class name is fully qualified, filter is not used, but can be once resolved // var filtered = Filter(associations, "className = @contained_edge_class"); // loop over all associated records to get a list of IDs var associated_edge_ids = []; for (var row in associations) { if (Lower(Split(row.classname,'.')[-1]) == Lower(contained_edge_class)){ push(associated_edge_ids, row.globalId); } } return associated_edge_ids; } function strand_status_for_cable() { // update strand status attributes on cable. default for all strands is 'available'. return Dictionary(strand_count, 0, strands_available, 0, strands_dedicated, 0, strands_inuse, 0, strands_pendingconnect, 0, strands_pendingdisconnect, 0, strands_reserved, 0, strands_unusable, 0) } // ********* End Functions Section **************** // get ids of content strands var content_ids = get_content_ids($feature); if (Count(content_ids) == 0) return; var strand_contents = Filter(contained_edge_fs, "globalid in @content_ids and " + strand_sql); // build payload to update fields on cable var attrs = strand_status_for_cable(); var empty_loop = true; for (var strand in strand_contents) { empty_loop = false; var field_name = strand_status_id_to_name(strand[strand_status]); if (!(HasKey(attrs, field_name))) { continue; } attrs[field_name] += 1; attrs[strand_count] += 1; } if (empty_loop) return; return { 'result': {'attributes': attrs} }

main.CommunicationsLine__ATTACH

Properties

Fields

Indexes

main.CommunicationsLine__ATTACHREL

main.CommunicationsSubnetLine

Properties

Controller Membership

Fields

Indexes

Subtypes

Assignments

main.GDB_ValidationLineErrors

Properties

Fields

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

Indexes

main.GDB_ValidationObjectErrors

Properties

Fields

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

Indexes

main.GDB_ValidationPointErrors

Properties

Fields

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

Indexes

main.GDB_ValidationPolygonErrors

Properties

Fields

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

Indexes

main.Network

main.ServiceTerritory

Properties

Controller Membership

Fields

Indexes

main.StructureBoundary

Properties

Controller Membership

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	OBJECTID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
SUBNETWORKNAME	Supported subnetwork name	String	Index	False		Unknown	2000	False	True
SHAPE	Shape	Geometry	Index	False			8	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
name	Name	String		True			64	True	False
notes	General Notes	String		True			2000	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
retireddate	Retired Date	Date		True			8	True	False
inservicedate	In-Service Date	Date		True			8	True	False
installdate	Install Date	Date		True			8	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source		2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence		2	True	False
ownedby	Owned By	Short Integer		True	Asset_Owner	1	2	True	False
assetid	Asset ID	String		True			64	True	False
maintby	Maintained By	Short Integer		True	Asset_Manager	1	2	True	False
materialcode	Material Code	Short Integer		True			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
constructionstatus	Construction Status	Short Integer		False	Construction_Status	6	2	True	False
VALIDATIONSTATUS	Validation status	Short Integer	Index	True	Validation Status	6	2	False	True
st_area(SHAPE)	SHAPE_Area	Double	Area	True			0	False	True
st_perimeter(SHAPE)	SHAPE_Length	Double	Length	True			0	False	True

Indexes

Subtypes

Assignments

Attribute Rules

SB-GenerateIDs

Key	Value
ID	2
Minimum Client Version	12.9
Evaluation Order	1
Name	SB-GenerateIDs
Description	Generate IDs for StructureBoundary 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:10
Script	// Assigned To: StructureBoundary // Type: Calculation // Name: SB-GenerateIDs // Description: Generate IDs for StructureBoundary 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. // - SJ-GenerateIDs // - SJO-GenerateIDs // - SL-GenerateIDs // - SEO-GenerateIDs // - ED-GenerateIDs // - EA-GenerateIDs // - EJ-GenerateIDs // - EJO-GenerateIDs // - EL-GenerateIDs // - EEO-GenerateIDs // *********** 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 == '101') { id_format = { 'prefix': "Wr-CAB", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_Wr_CAB_101_seq'); }else if (selector_value_txt == '104') { id_format = { 'prefix': "Wr-VLT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_Wr_VLT_104_seq'); }else if (selector_value_txt == '801') { id_format = { 'prefix': "BLD", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_BLD_801_seq'); }else if (selector_value_txt == '803') { id_format = { 'prefix': "SUP", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SB_SUP_803_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

SB-Validate Network Distance

Key	Value
ID	3
Minimum Client Version	12.9
Evaluation Order	1
Name	SB-Validate Network Distance
Description	Validate $feature is within allowable distance from associated features
Type	Validation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Severity	4
Error Number	5004
Error Message	Error
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:12
Script	// Assigned To: StructureBoundary // Type: Validation // Name: SB-Validate Network Distance // Description: Validate $feature is within allowable distance from associated features // Subtypes: All // Error Number: 5004 // Error Message: Error // Severity: 4 // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - SB-Require Validation Distance // 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. // - EA-Validate Network Distance // - ED-Validate Network Distance // - EL-Validate Network Distance // - SL-Validate Network Distance // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'assetgroup'); // The allowable distance value a feature can be from container // Implementation Note: Adjust this value based on the distance var distance_check = 100; // The unit of the distance value in distance_check // Implementation Note: Options for Unit of Measure: https://developers.arcgis.com/arcade/function-reference/geometry_functions/#units-reference var unit_of_measure = "feet"; // Optionally limit rule to specific asset groups. // Implementation Note: Add to list to limit rule to specific asset types. If not specified, will be ignored. var asset_group = $feature.assetgroup; var valid_asset_groups = []; // Association type to check. // Implementation Note: Associated features will only be considered if association type is listed here. var assoc_types = ["content", "container", "attached", "structure"]; // ********* End User Variables Section ********* // ********* Functions ********* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_container_feature_ids(feature, assoc, spatial_only) { // Function to get UN associated container feature id // feature(Feature): A feature object used to lookup associations var associated_ids = {}; // Query to get all the content associations var associations = FeatureSetByAssociation(feature, assoc); // loop over all associated records to get a list of the associated classes and the IDs of the features for (var row in associations) { // Skip Non Spatial features if (spatial_only && (Right(Lower(row.className), 6) == 'object')) { continue; } if (!HasKey(associated_ids, row.className)) { associated_ids[row.className] = []; } push(associated_ids[row.className], row.globalId); } //return a dict by class name with GlobalIDs of features, if empty, return empty dict return associated_ids; } // ********* End Functions Section **************** // Limit the rule to valid asset groups if (Count(valid_asset_groups) > 0) { if (!Includes(valid_asset_groups, asset_group)) { return true; } } // Get global IDs of any associated features outside allowable distance from feature var distance_errors = {}; for (var idx in assoc_types) { // Get objectids of associated features var associated_ids = get_container_feature_ids($feature, assoc_types[idx], true); for (var class_name in associated_ids) { var feature_set = get_features_switch_yard($datastore, class_name, ['globalID'], true); var global_ids = associated_ids[class_name]; var features = Filter(feature_set, "globalid in @global_ids"); for (var feat in features) { // Distance measures shortest distance between two geometries, including edges if (Distance($feature, feat, unit_of_measure) > distance_check) { if (!HasKey(distance_errors, assoc_types[idx])) { distance_errors[assoc_types[idx]] = []; } push(distance_errors[assoc_types[idx]], feat.globalid); } } } } // build error message and return var mess = ''; for (var assoc_t in distance_errors) { mess += `Feature is outside allowable distance from ${assoc_t}(s): ${Concatenate(distance_errors[assoc_t], ", ")} ` } if (mess != '') { return {"errorMessage": mess} } return true;

main.StructureBoundary__ATTACH

Properties

Fields

Indexes

main.StructureBoundary__ATTACHREL

main.StructureEdgeObject

Properties

Controller Membership

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	OBJECTID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
SUBNETWORKNAME	Supported Subnetwork Name	String	Index	False		Unknown	2000	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
assetid	Asset ID	String		True			64	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
installdate	Install Date	Date		True			8	True	False
retireddate	Retired Date	Date		True			8	True	False
inservicedate	In-Service Date	Date		True			8	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence		2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source		2	True	False
ownedby	Owned By	Short Integer		True	Asset_Owner	1	2	True	False
maintby	Maintained By	Short Integer		True	Asset_Manager	1	2	True	False
ductid	Duct Identifier	Short Integer		True			2	True	False
measuredlength	Measured Length	Double		True			8	True	False
ductavailable	Duct Availability Indicator	Short Integer		True	Yes_No		2	True	False
minimumbendradius	Minimum Bend Radius	Double		True			8	True	False
fromport	From AR Count	Short Integer		True			2	True	False
toport	To AR Count	Short Integer		True			2	True	False
diametermetric	Diameter	Double		True	Wire_Duct_Diameter_mm		8	True	False
measuredlengthmetric	Measured Length	Double		True			8	True	False
diameter	Diameter	Double		True	Wire_Duct_Diameter		8	True	False
minimumbendradius_metric	Minimum Bend Radius	Double		True			8	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
constructionstatus	Construction Status	Short Integer		False	Construction_Status	6	2	True	False

Indexes

Subtypes

Assignments

Attribute Rules

SEO-GenerateIDs

Key	Value
ID	19
Minimum Client Version	12.9
Evaluation Order	1
Name	SEO-GenerateIDs
Description	Generate IDs for StructureEdgeObject 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:19
Script	// Assigned To: StructureEdgeObject // Type: Calculation // Name: SEO-GenerateIDs // Description: Generate IDs for StructureEdgeObject 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. // - SJ-GenerateIDs // - SB-GenerateIDs // - SJO-GenerateIDs // - SL-GenerateIDs // - ED-GenerateIDs // - EA-GenerateIDs // - EJ-GenerateIDs // - EJO-GenerateIDs // - EL-GenerateIDs // - EEO-GenerateIDs // *********** 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 == '101') { id_format = { 'prefix': "WRDCT", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SEO_WRDCT_101_seq'); }else if (selector_value_txt == '111') { id_format = { 'prefix': "Cndt", 'join_char': '-', 'suffix': '' } seq_val = NextSequenceValue('SEO_Cndt_111_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

SEO-Ductavailable From Content

Key	Value
ID	20
Minimum Client Version	12.9
Evaluation Order	2
Name	SEO-Ductavailable From Content
Description	Update ductavailable attribute when association status changes. Also updates capacity attributes on any Container (duct bank).
Type	Calculation
Batch	False
Insert Trigger	False
Update Trigger	True
Delete Trigger	False
Subtype	Wire Duct
Field Name	ductavailable
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:17:19
Script	// Assigned To: StructureEdgeObject // Type: Calculation // Name: SEO-Ductavailable From Content // Description: Update ductavailable attribute when association status changes. Also updates capacity attributes on any Container (duct bank). // Subtypes: Wire Duct // Field: ductavailable // Trigger: Update // Exclude From Client: True // Disable: False // Implementation Note: This rule is disabled by default. It auto updates the ductavailable attribute of the feature (wire duct) // and capacity attributes of any container feature (wire duct bank). This occurs when a wire duct is added/removed as content // of a wire duct bank. If you desire this function, enable this rule and adjust. // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation Expects($feature, 'ductavailable','ASSOCIATIONSTATUS'); // The field the rule is assigned to // Implementation Note: Adjust this value only if the field name for Duct Available differs var assigned_to_field = $feature.ductavailable; // The class name of the wire duct // Implementation Note: This value does not need to change if using the industry data model. var assigned_to_class = "StructureEdgeObject"; var container_class = "StructureLine"; // SQL state for wire duct // Implementation Note: Used to query all ducts contained with feature's container. var duct_sql = "AssetGroup = 101 and AssetType = 41"; // Compare association status states // Implementation Note: Different states of association status on feature are compared to determine if new container // was added or removed. var association_status = $feature.ASSOCIATIONSTATUS; var orig_association_status = $originalFeature.ASSOCIATIONSTATUS; // ********* End User Variables Section ********* // ********* Functions ********* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function container_id_from_assoctable(content_guid) { // Using the associations table to get old container id. Cannot use FeatureSetByAssociation because association was deleted, // but it still exists in the associations table var assoc_fs = get_features_switch_yard($datastore, 'UN_6_Associations', ['FROMGLOBALID'], false); var filtered_fs = Filter(assoc_fs, "toglobalid = @content_guid and ASSOCIATIONTYPE = 2"); return First(filtered_fs)['FROMGLOBALID']; } // ********* End Functions Section *************** //Association Status did not change, return original value if (association_status == orig_association_status) { return assigned_to_field; } // The feature is content and still is content, return the original value if ((orig_association_status & 0x14) > 0 && (association_status & 0x14) > 0) { return assigned_to_field; } var assoc_removed = false; // The feature was content, but is not now if ((orig_association_status & 0x14) > 0 && (association_status & 0x14) == 0) { // Duct Available is now true assigned_to_field = 1; assoc_removed = true; } // The object was not content and is now if ((orig_association_status & 0x14) == 0 && (association_status & 0x14) > 0) { // Duct Available is now false if it was null assigned_to_field = DefaultValue(assigned_to_field, 0); } // Get globalID of container var container_id = null; if (assoc_removed) { container_id = container_id_from_assoctable($feature.globalid); } else { var container_row = First(FeatureSetByAssociation($feature, 'container')); if (IsEmpty(container_row)) { return assigned_to_field; } container_id = container_row['globalid']; } if (IsEmpty(container_id)){ return assigned_to_field; } // Get featureSet of container var cont_fs = get_features_switch_yard($datastore, container_class, ['globalid'], false); var container_fs = First(Filter(cont_fs, "globalid = @container_id")); if (IsEmpty(container_fs)) return assigned_to_field; // Get list of ids that are content of container. Ignore ID of $feature. var content_rows = FeatureSetByAssociation(container_fs, 'content'); var associated_ids = []; for (var row in content_rows) { if (Lower(row.className) == Lower(assigned_to_class)) { // Might need to ignore the current feature if ($feature.globalid != row.globalId) { push(associated_ids, row.globalId); } } } if (Count(associated_ids) == 0){ return assigned_to_field; } // Get all ducts, except for $feature and get capacity counts var content_fs = get_features_switch_yard($datastore, assigned_to_class, ['globalid', 'ductavailable'], false); var all_ducts = Filter(content_fs, "globalid in @associated_ids and " + duct_sql); var max_cap = 0; var used_cap = 0; var avail_cap = 0; for (var duct_row in all_ducts) { max_cap += 1; if(duct_row['ductavailable'] == 1){ avail_cap += 1; } else{ used_cap += 1; } } // to pick up $feature if it was added if (assoc_removed == false) { max_cap += 1; if (assigned_to_field == 1){ avail_cap += 1; } else{ used_cap += 1; } } var edit_payload = [{'className':"main.StructureLine", 'updates':[{ 'globalID': container_fs.globalid, 'attributes':{'maximumcapacity':max_cap, 'usedcapacity': used_cap, 'availablecapacity': avail_cap }}]}]; return { "result": assigned_to_field, "edit": edit_payload };

main.StructureEdgeObject__ATTACH

Properties

Fields

Indexes

main.StructureEdgeObject__ATTACHREL

main.StructureJunction

main.StructureJunction__ATTACH

Properties

Fields

Indexes

main.StructureJunction__ATTACHREL

main.StructureJunctionObject

main.StructureJunctionObject__ATTACH

Properties

Fields

Indexes

main.StructureJunctionObject__ATTACHREL

main.StructureLine

Properties

Controller Membership

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	OBJECTID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
SUBNETWORKNAME	Subnetwork name	String	Index	False		Unknown	2000	False	True
FLOWDIRECTION	Flow direction	Short Integer		True	Network_6_FlowDirection	1	2	True	True
SHAPE	Shape	Geometry	Index	False			8	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
assetid	Asset ID	String		True			64	True	False
diameterwidth	Diameter/Width	Double		True			8	True	False
materialsoil	materialsoil: Material, Soil Type	Short Integer		True			2	True	False
distance	Depth/Height	Double		True			8	True	False
labeltext	Labeling String	String		True			256	True	False
installdate	Install Date	Date		True			8	True	False
retireddate	Retired Date	Date		True			8	True	False
inservicedate	In-Service Date	Date		True			8	True	False
maximumcapacity	Number of Ducts	Short Integer		True			2	True	False
usedcapacity	Ducts Used	Short Integer		True			2	True	False
availablecapacity	Ducts Open	Short Integer		True		999	2	True	False
measuredlength	Measured Length	Double		True		0	8	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source		2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence		2	True	False
notes	General Notes	String		True			2000	True	False
ownedby	Owned By	Short Integer		True	Asset_Owner	1	2	True	False
maintby	Maintained By	Short Integer		True	Asset_Manager	1	2	True	False
designtype	Type	Short Integer		True			2	True	False
searchdistance	Structure Search Distance	Double		True			8	True	False
diameterwidth_metric	Diameter/Width	Double		True			8	True	False
measuredlength_metric	Measured Length	Double		True			8	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
constructionstatus	Construction Status	Short Integer		False	Construction_Status	6	2	True	False
sectionid	Section ID	String		True			2000	True	False
VALIDATIONSTATUS	Validation status	Short Integer	Index	True	Validation Status	6	2	False	True
st_length(SHAPE)	SHAPE_Length	Double	Length	True			0	False	True

Indexes

Subtypes

Assignments

Attribute Rules

SL-GenerateIDs

SL-Contain Structure Line in Structure Line

SL-Create Ducts In Duct Bank

SL-MeasuredLength From Shape - WireAerialSupport

SL-MeasuredLength From Shape - WireTrench

SL-MeasuredLength From Shape - ConnectorLine

SL-MeasuredLength From Shape - CommunicationsConduit

SL-MeasuredLength From Shape - CommunicationsCableHardware

SL-MeasuredLength From Shape - AccessTunnel

SL-MeasuredLength From Shape - WireMicroductPathway

SL-MeasuredLength From Shape - Ground

SL-MeasuredLength From Shape and Content

SL-Require Validation Distance

SL-Validate Network Distance

main.StructureLine__ATTACH

Properties

Fields

Indexes

main.StructureLine__ATTACHREL

main.UtilityNetwork

Domains

Name	Code	Details
Unknown	0
Connector	4
Connector Group	1
Chassis	5
Port	7
Equipment	8
Port Group	9
Antenna	11
Splice	12
Splice Group	13

Name	Is Unique	Is Ascending	Field Name
GDB_235_REL_GLOB	False	True	REL_GLOBALID
UUID_53	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

Name	Is Unique	Is Ascending	Field Name
GDB_226_VALIDATI	False	True	VALIDATIONSTATUS
GDB_226_CableSub	False	True	CableSubnetwork
GDB_226_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_226_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
GDB_226_SwitchSu	False	True	SwitchSubnetwork
GDB_226_Communic	False	True	CommunicationsCircuit
UUID_44	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__CommunicationsLine_SHAPE	True	True	SHAPE

Name	Code	Details
Unknown	0
Submarine Cable	20
National Cable	25
Regional Cable	30
Distribution Cable	35
Access Cable	40
Drop Cable	45
Indoor Cable	50
Wireless	60

Name	Is Unique	Is Ascending	Field Name
GDB_237_REL_GLOB	False	True	REL_GLOBALID
UUID_55	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

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

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

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

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

Domain Network Name	Domain Network Alias	Domain Network ID	Tier Definition	Subnetwork Controller Type	Creation Time
Structure	Structure	1	None		2024-04-26 11:13:04
Communications	Communications	2	Hierarchical	Source	2024-04-26 11:14:10

Domain Network Name	Tier Group Name	Creation Time
Communications	Cables	2024-04-26 11:14:18
Communications	Strand	2024-04-26 11:14:18

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
Communications	Cables	Cable	1	1	Mesh	True	CableSubnetwork	Without Eventing	Without Eventing	False	False	False	True	2024-04-26 11:14:18
Communications	Strand	Switch	2	1	Mesh	True	SwitchSubnetwork	Without Eventing	Without Eventing	False	False	False	False	2024-04-26 11:14:18
Communications	Strand	Communications Circuit	3	2	Mesh	True	CommunicationsCircuit	Without Eventing	Without Eventing	False	False	False	False	2024-04-26 11:14:18

Tier Name	Source Name	Asset Group	Asset Type	Controller / Aggregated
Cable	Device	Regional Cable Components	Hub Terminator	True
Cable	Device	Regional Cable Components	Spare Cable	False
Cable	Device	Regional Cable Components	Splice Enclosure	False
Cable	Device	Regional Cable Components	Splitter Enclosure	False
Cable	Device	Regional Cable Components	Mid Cable Splice Enclosure	False
Cable	Device	Regional Cable Components	Amplifier Enclosure	False
Cable	Device	Distribution Cable Components	Hub Terminator	True
Cable	Device	Distribution Cable Components	Spare Cable	False
Cable	Device	Distribution Cable Components	Splice Enclosure	False
Cable	Device	Distribution Cable Components	Splitter Enclosure	False
Cable	Device	Distribution Cable Components	Mid Cable Splice Enclosure	False
Cable	Device	Distribution Cable Components	Network Interface Unit	False
Cable	Device	Distribution Cable Components	Amplifier Enclosure	False
Cable	Device	Distribution Cable Components	Wall Plate	False
Cable	Device	Access Cable Components	Hub Terminator	True
Cable	Device	Access Cable Components	Spare Cable	False
Cable	Device	Access Cable Components	Splice Enclosure	False
Cable	Device	Access Cable Components	Splitter Enclosure	False
Cable	Device	Access Cable Components	Mid Cable Splice Enclosure	False
Cable	Device	Access Cable Components	Amplifier Enclosure	False
Cable	Device	Drop Cable Components	Hub Terminator	True
Cable	Device	Drop Cable Components	Spare Cable	False
Cable	Device	Drop Cable Components	Splice Enclosure	False
Cable	Device	Drop Cable Components	Splitter Enclosure	False
Cable	Device	Drop Cable Components	Mid Cable Splice Enclosure	False
Cable	Device	Drop Cable Components	Network Interface Unit	False
Cable	Device	Drop Cable Components	Amplifier Enclosure	False
Cable	Device	Indoor Cable Components	Hub Terminator	True
Cable	Device	Indoor Cable Components	Spare Cable	False
Cable	Device	Indoor Cable Components	Splice Enclosure	False
Cable	Device	Indoor Cable Components	Splitter Enclosure	False
Cable	Device	Indoor Cable Components	Mid Cable Splice Enclosure	False
Cable	Device	Indoor Cable Components	Amplifier Enclosure	False
Cable	Device	Indoor Cable Components	Wall Plate	False
Cable	Device	Wireless Components	Wireless Site	False
Cable	Line	Submarine Cable	Fiber	False
Cable	Line	National Cable	Fiber	False
Cable	Line	Regional Cable	Copper	False
Cable	Line	Regional Cable	Fiber	False
Cable	Line	Distribution Cable	Coax	True
Cable	Line	Distribution Cable	Copper	True
Cable	Line	Distribution Cable	Fiber	True
Cable	Line	Access Cable	Coax	True
Cable	Line	Access Cable	Copper	True
Cable	Line	Access Cable	Fiber	True
Cable	Line	Drop Cable	Coax	True
Cable	Line	Drop Cable	Copper	True
Cable	Line	Drop Cable	Fiber	True
Cable	Line	Indoor Cable	Coax	True
Cable	Line	Indoor Cable	Copper	True
Cable	Line	Indoor Cable	Fiber	True
Cable	Junction	Connection Point	Overhead
Cable	Junction	Connection Point	Underground
Cable	Junction	Connection Point	Riser
Switch	JunctionObject	Connector	Coax	False
Switch	JunctionObject	Connector	Copper	False
Switch	JunctionObject	Connector	Fiber	False
Switch	JunctionObject	Connector	Wireless	False
Switch	JunctionObject	Splice	Splice Point	False
Switch	JunctionObject	Port	Switch Port	False
Switch	JunctionObject	Port	Splitter Port	False
Switch	JunctionObject	Port	Amplifier Port	False
Switch	JunctionObject	Port	Patch Panel Port	False
Switch	JunctionObject	Port	Demultiplexer Port	False
Switch	JunctionObject	Port	Multiplexer Port	False
Switch	JunctionObject	Port	Baseband Port	False
Switch	JunctionObject	Port	Remote Radio Unit Port	False
Switch	JunctionObject	Port	Cell Antenna Port	False
Switch	JunctionObject	Port	Microwave Antenna Port	False
Switch	JunctionObject	Equipment	Amplifier	False
Switch	JunctionObject	Equipment	Demultiplexer	False
Switch	JunctionObject	Equipment	Multiplexer	False
Switch	JunctionObject	Equipment	Splitter	False
Switch	JunctionObject	Equipment	Switch	True
Switch	JunctionObject	Equipment	Baseband Unit	False
Switch	EdgeObject	Strand	Coax
Switch	EdgeObject	Strand	Copper
Switch	EdgeObject	Strand	Fiber
Switch	EdgeObject	Link	Splice
Switch	EdgeObject	Link	Patch Cable
Switch	EdgeObject	Link	Jumper Cable
Switch	EdgeObject	Wireless	Direct Path
Switch	EdgeObject	Wireless	Reflected Path
Communications Circuit	JunctionObject	Connector	Coax	True
Communications Circuit	JunctionObject	Connector	Copper	True
Communications Circuit	JunctionObject	Connector	Fiber	True
Communications Circuit	JunctionObject	Splice	Splice Point	False
Communications Circuit	JunctionObject	Port	Switch Port	False
Communications Circuit	JunctionObject	Port	Splitter Port	False
Communications Circuit	JunctionObject	Port	Amplifier Port	False
Communications Circuit	JunctionObject	Port	Patch Panel Port	False
Communications Circuit	JunctionObject	Port	Demultiplexer Port	False
Communications Circuit	JunctionObject	Port	Multiplexer Port	False
Communications Circuit	JunctionObject	Port	Baseband Port	False
Communications Circuit	JunctionObject	Port	Remote Radio Unit Port	False
Communications Circuit	JunctionObject	Port	Cell Antenna Port	False
Communications Circuit	JunctionObject	Port	Microwave Antenna Port	False
Communications Circuit	JunctionObject	Equipment	Amplifier	False
Communications Circuit	JunctionObject	Equipment	Demultiplexer	False
Communications Circuit	JunctionObject	Equipment	Multiplexer	False
Communications Circuit	JunctionObject	Equipment	Splitter	False
Communications Circuit	JunctionObject	Equipment	Switch	False
Communications Circuit	JunctionObject	Equipment	Baseband Unit	False
Communications Circuit	EdgeObject	Strand	Coax
Communications Circuit	EdgeObject	Strand	Copper
Communications Circuit	EdgeObject	Strand	Fiber

Tier Name	Network Attribute / Category	Operator	Value	Combine Using Or
Cable	Lifecycle Status	Does Not Include Any	6	True
Cable	Category	Equal	C:Cable Termination	False
Switch	Lifecycle Status	Does Not Include Any	6	True
Switch	Category	Equal	C:Wireless	False
Communications Circuit	Lifecycle Status	Does Not Include Any	6	True
Communications Circuit	Category	Equal	C:Wireless	False

Domain Network Name	Source Name	Table	Usage Type	Source ID	# of Asset Groups	# of Asset Types
Structure	StructureJunction	main.StructureJunction	Structure Junction	4	24	73
Structure	StructureBoundary	main.StructureBoundary	Structure Boundary	6	5	24
Structure	StructureJunctionObject	main.StructureJunctionObject	Structure Junction Object	7	10	28
Structure	StructureLine	main.StructureLine	Structure Line	5	10	29
Structure	StructureEdgeObject	main.StructureEdgeObject	Structure Edge Object	8	3	8
Communications	CommunicationsDevice	main.CommunicationsDevice	Device	9	9	53
Communications	CommunicationsAssembly	main.CommunicationsAssembly	Assembly	11	1	1
Communications	CommunicationsJunction	main.CommunicationsJunction	Junction	12	2	5
Communications	CommunicationsJunctionObject	main.CommunicationsJunctionObject	Junction Object	14	10	53
Communications	CommunicationsLine	main.CommunicationsLine	Line	10	9	24
Communications	CommunicationsSubnetLine	main.CommunicationsSubnetLine	Subnet Line	13	4	0
Communications	CommunicationsEdgeObject	main.CommunicationsEdgeObject	Edge Object	15	4	12

Source Name	Asset Group Name	Asset Group Code	# of Asset Types	Creation Time
StructureJunction	Unknown	0	1	2024-04-26 11:13:05
StructureJunction	Wire Cabinet	101	3	2024-04-26 11:14:29
StructureJunction	Wire Structure Guy	102	2	2024-04-26 11:14:29
StructureJunction	Wire Handhole	103	2	2024-04-26 11:14:29
StructureJunction	Wire Junction Box	104	2	2024-04-26 11:14:29
StructureJunction	Wire Vault Access Point	105	2	2024-04-26 11:14:29
StructureJunction	Wire Pedestal	107	2	2024-04-26 11:14:29
StructureJunction	Wire Vault	110	3	2024-04-26 11:14:29
StructureJunction	Wire Support Pole	123	4	2024-04-26 11:14:29
StructureJunction	Marker	124	7	2024-04-26 11:14:29
StructureJunction	Wire Structure Representation	132	3	2024-04-26 11:14:29
StructureJunction	Wire Vault Knockouts	130	3	2024-04-26 11:14:29
StructureJunction	Communications Tower	111	5	2024-04-26 11:14:29
StructureJunction	Communications Pole	125	3	2024-04-26 11:14:29
StructureJunction	Wire Vault Components	131	2	2024-04-26 11:14:29
StructureJunction	Wire Customer Attachment	113	2	2024-04-26 11:14:29
StructureJunction	Structure Attachment Point	133	2	2024-04-26 11:14:29
StructureJunction	Duct Junctions	134	4	2024-04-26 11:14:29
StructureJunction	Ground	801	4	2024-04-26 11:14:29
StructureJunction	Wire Stock Sites	136	5	2024-04-26 11:14:29
StructureJunction	Building	802	4	2024-04-26 11:14:29
StructureJunction	Support	803	3	2024-04-26 11:14:29
StructureJunction	Building Riser	137	1	2024-04-26 11:14:29
StructureJunction	Wire Conduit Fittings	126	4	2024-04-26 11:14:29
StructureBoundary	Unknown	0	1	2024-04-26 11:13:05
StructureBoundary	Wire Cabinet Boundary	101	2	2024-04-26 11:14:42
StructureBoundary	Wire Vault Boundary	104	6	2024-04-26 11:14:42
StructureBoundary	Building	801	4	2024-04-26 11:14:42
StructureBoundary	Support	803	11	2024-04-26 11:14:42
StructureJunctionObject	Unknown	0	1	2024-04-26 11:13:05
StructureJunctionObject	Wire Vault Knockouts	130	3	2024-04-26 11:14:47
StructureJunctionObject	Wire Vault Components	131	3	2024-04-26 11:14:47
StructureJunctionObject	Wire Crossarm	114	4	2024-04-26 11:14:47
StructureJunctionObject	Wire Microduct Fitting	134	3	2024-04-26 11:14:47
StructureJunctionObject	Wire Microduct Connection Point	135	2	2024-04-26 11:14:47
StructureJunctionObject	Pole	120	4	2024-04-26 11:14:47
StructureJunctionObject	Wire Conduit Fittings	126	4	2024-04-26 11:14:47
StructureJunctionObject	Wire Microduct Fitting Group	132	2	2024-04-26 11:14:47
StructureJunctionObject	Building Riser	137	2	2024-04-26 11:14:47
StructureLine	Unknown	0	1	2024-04-26 11:13:05
StructureLine	Wire Duct Bank	102	2	2024-04-26 11:14:53
StructureLine	Wire Aerial Support	103	8	2024-04-26 11:14:53
StructureLine	Wire Trench	104	2	2024-04-26 11:14:53
StructureLine	Connector Line	111	3	2024-04-26 11:14:53
StructureLine	Communications Cable Hardware	110	3	2024-04-26 11:14:53
StructureLine	Access Tunnel	112	2	2024-04-26 11:14:53
StructureLine	Wire Microduct Pathway	118	3	2024-04-26 11:14:53
StructureLine	Ground	801	3	2024-04-26 11:14:53
StructureLine	Communications Conduit	109	2	2024-04-26 11:14:53
StructureEdgeObject	Unknown	0	1	2024-04-26 11:13:05
StructureEdgeObject	Wire Duct	101	5	2024-04-26 11:14:58
StructureEdgeObject	Conduit	111	2	2024-04-26 11:14:58
CommunicationsDevice	Unknown	0	1	2024-04-26 11:14:11
CommunicationsDevice	Submarine Cable Components	20	4	2024-04-26 11:15:02
CommunicationsDevice	National Cable Components	25	7	2024-04-26 11:15:02
CommunicationsDevice	Regional Cable Components	30	7	2024-04-26 11:15:02
CommunicationsDevice	Distribution Cable Components	35	9	2024-04-26 11:15:02
CommunicationsDevice	Access Cable Components	40	7	2024-04-26 11:15:02
CommunicationsDevice	Drop Cable Components	45	8	2024-04-26 11:15:02
CommunicationsDevice	Indoor Cable Components	50	8	2024-04-26 11:15:02
CommunicationsDevice	Wireless Components	60	2	2024-04-26 11:15:02
CommunicationsAssembly	Unknown	0	1	2024-04-26 11:14:11
CommunicationsJunction	Unknown	0	1	2024-04-26 11:14:11
CommunicationsJunction	Connection Point	1	4	2024-04-26 11:15:07
CommunicationsJunctionObject	Unknown	0	1	2024-04-26 11:14:11
CommunicationsJunctionObject	Connector	4	5	2024-04-26 11:15:12
CommunicationsJunctionObject	Connector Group	1	4	2024-04-26 11:15:12
CommunicationsJunctionObject	Chassis	5	12	2024-04-26 11:15:12
CommunicationsJunctionObject	Port	7	11	2024-04-26 11:15:12
CommunicationsJunctionObject	Equipment	8	7	2024-04-26 11:15:12
CommunicationsJunctionObject	Port Group	9	5	2024-04-26 11:15:12
CommunicationsJunctionObject	Antenna	11	3	2024-04-26 11:15:12
CommunicationsJunctionObject	Splice	12	1	2024-04-26 11:15:12
CommunicationsJunctionObject	Splice Group	13	4	2024-04-26 11:15:12
CommunicationsLine	Unknown	0	1	2024-04-26 11:14:11
CommunicationsLine	Submarine Cable	20	1	2024-04-26 11:15:19
CommunicationsLine	National Cable	25	1	2024-04-26 11:15:19
CommunicationsLine	Regional Cable	30	3	2024-04-26 11:15:19
CommunicationsLine	Distribution Cable	35	4	2024-04-26 11:15:19
CommunicationsLine	Access Cable	40	4	2024-04-26 11:15:19
CommunicationsLine	Drop Cable	45	4	2024-04-26 11:15:19
CommunicationsLine	Indoor Cable	50	4	2024-04-26 11:15:19
CommunicationsLine	Wireless	60	2	2024-04-26 11:15:19
CommunicationsSubnetLine	Unknown	0	0	2024-04-26 11:14:11
CommunicationsSubnetLine	Cable	1	0	2024-04-26 11:14:29
CommunicationsSubnetLine	Switch	2	0	2024-04-26 11:14:29
CommunicationsSubnetLine	Communications Circuit	3	0	2024-04-26 11:14:29
CommunicationsEdgeObject	Unknown	0	1	2024-04-26 11:14:11
CommunicationsEdgeObject	Strand	8	4	2024-04-26 11:15:27
CommunicationsEdgeObject	Link	10	4	2024-04-26 11:15:27
CommunicationsEdgeObject	Wireless	11	3	2024-04-26 11:15:27

Category Name	Creation Time
Subnetwork Controller	2024-04-26 11:13:04
Subnetwork Tap	2024-04-26 11:13:04
Attribute Substitution	2024-04-26 11:13:04
Asset Functional	2024-04-26 11:15:35
Asset Location	2024-04-26 11:15:35
C:Cable	2024-04-26 11:15:35
C:Cable Termination	2024-04-26 11:15:35
C:Coax	2024-04-26 11:15:35
C:Copper	2024-04-26 11:15:35
C:Fiber	2024-04-26 11:15:35
C:Overhead	2024-04-26 11:15:35
C:Port	2024-04-26 11:15:35
C:Splice	2024-04-26 11:15:35
C:Strand Connection	2024-04-26 11:15:35
C:Switch	2024-04-26 11:15:35
C:Underground	2024-04-26 11:15:35
C:Wireless	2024-04-26 11:15:35
STR:Cable Pathway	2024-04-26 11:15:35
STR:Cable Support	2024-04-26 11:15:35
STR:Duct Bank	2024-04-26 11:15:35
STR:Duct Trace	2024-04-26 11:15:35
STR:Wire Aerial Support Structure	2024-04-26 11:15:35

Configuration Name	Configuration ID	Traversability Model	Default	Creation Time
Single terminal	0	Bidirectional	All	2024-04-26 11:13:04
Communications Port	2	Bidirectional	All	2024-04-26 11:15:35
Communications Equipment	3	Directional	All	2024-04-26 11:15:35
Communications Hub	4	Bidirectional	All	2024-04-26 11:15:35

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:13:04
Terminal ID	2	Terminal ID	Integer	Short Integer	False		False	False	7	0	3	4	2024-04-26 11:13:04
Asset group	3	Asset Group	Integer	Short Integer	True		False	False	7	10	5	6	2024-04-26 11:13:04
Asset type	4	Asset Type	Integer	Short Integer	True		False	False	17	10	7	8	2024-04-26 11:13:04
Is subnetwork controller	5	Is Subnetwork Controller	Integer	Short Integer	True		False	False	27	1	9	10	2024-04-26 11:13:04
Tier name	6	Tier Name	Integer	Short Integer	True		False	False	28	6	11	12	2024-04-26 11:13:04
Shape length	7	Shape Length	Double	Double	False		False	True	34	0	13	14	2024-04-26 11:13:04
Position from	8	Position From	Double	Double	False		False	False	34	0	15	16	2024-04-26 11:13:04
Position to	9	Position To	Double	Double	False		False	False	34	0	17	18	2024-04-26 11:13:04
Flow direction	10	Flow Direction	Integer	Short Integer	True		False	False	34	2	19	20	2024-04-26 11:13:04
Available Duct Capacity	11	Unknown	Integer	Short Integer	False		True	False	0	0	21	22	2024-04-26 11:15:35
C:Optical Length	12	Unknown	Double	Double	False		True	False	0	0	23	24	2024-04-26 11:15:35
C:Service Type	13	Unknown	Integer	Short Integer	False		True	False	0	0	25	26	2024-04-26 11:15:35
C:SignalLoss1300	14	Unknown	Double	Double	False		True	False	0	0	27	28	2024-04-26 11:15:35
C:SignalLoss1310	15	Unknown	Double	Double	False		True	False	0	0	29	30	2024-04-26 11:15:35
C:SignalLoss1550	16	Unknown	Double	Double	False		True	False	0	0	31	32	2024-04-26 11:15:35
C:SignalLoss850	17	Unknown	Double	Double	False		True	False	0	0	33	34	2024-04-26 11:15:35
C:SignalLossCoax	18	Unknown	Double	Double	False		True	False	0	0	35	36	2024-04-26 11:15:35
C:SignalLossCopper	19	Unknown	Double	Double	False		True	False	0	0	37	38	2024-04-26 11:15:35
C:Strand Status	20	Unknown	Integer	Short Integer	True	Communications_Strand_Status	True	False	36	3	39	40	2024-04-26 11:15:35
C:Strand Total	21	Unknown	Integer	Long Integer	False		True	False	0	0	41	42	2024-04-26 11:15:35
C:Strands Available	22	Unknown	Integer	Long Integer	False		True	False	0	0	43	44	2024-04-26 11:15:35
C:Strands Dedicated	23	Unknown	Integer	Long Integer	False		True	False	0	0	45	46	2024-04-26 11:15:35
C:Strands In Use	24	Unknown	Integer	Long Integer	False		True	False	0	0	47	48	2024-04-26 11:15:35
C:Strands Pending Connect	25	Unknown	Integer	Long Integer	False		True	False	0	0	49	50	2024-04-26 11:15:35
C:Strands Pending Disconnect	26	Unknown	Integer	Long Integer	False		True	False	0	0	51	52	2024-04-26 11:15:35
C:Strands Reserved	27	Unknown	Integer	Long Integer	False		True	False	0	0	53	54	2024-04-26 11:15:35
C:Strands Unusable	28	Unknown	Integer	Long Integer	False		True	False	0	0	55	56	2024-04-26 11:15:35
C:UsageType	29	Unknown	Integer	Short Integer	False		True	False	0	0	57	58	2024-04-26 11:15:35
Duct Diameter	30	Unknown	Double	Double	False		True	False	0	0	59	60	2024-04-26 11:15:35
Ducts Available	31	Unknown	Integer	Short Integer	False		True	False	0	0	61	62	2024-04-26 11:15:35
Is Valid Loop	32	Unknown	Integer	Short Integer	False		True	False	0	0	63	64	2024-04-26 11:15:35
Lifecycle Status	33	Unknown	Integer	Short Integer	True	Lifecycle_Combined	False	False	40	3	65	66	2024-04-26 11:15:35
Measured Length	34	Unknown	Double	Double	False		True	True	0	0	67	68	2024-04-26 11:15:35
Minimum Bend Radius	35	Unknown	Double	Double	False		True	False	0	0	69	70	2024-04-26 11:15:35
Construction Status	36	Unknown	Integer	Short Integer	False		True	False	0	0	71	72	2024-04-26 11:15:35

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_VALIDATIO	False	True	VALIDATIONSTATUS
GDB_38_SUBNETWOR	False	True	SUBNETWORKNAME
UUID_40	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__StructureBoundary_SHAPE	True	True	SHAPE

Name	Is Unique	Is Ascending	Field Name
GDB_238_REL_GLOB	False	True	REL_GLOBALID
UUID_56	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

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

Name	Is Unique	Is Ascending	Field Name
GDB_239_REL_GLOB	False	True	REL_GLOBALID
UUID_57	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

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

Name	Is Unique	Is Ascending	Field Name
GDB_241_REL_GLOB	False	True	REL_GLOBALID
UUID_59	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

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

Name	Is Unique	Is Ascending	Field Name
GDB_240_REL_GLOB	False	True	REL_GLOBALID
UUID_58	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID

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

Name	Is Unique	Is Ascending	Field Name
GDB_242_REL_GLOB	False	True	REL_GLOBALID
UUID_60	True	True	GLOBALID
FDO_ATTACHMENTID	True	True	ATTACHMENTID