Stormwater_UtilityNetwork

Workspace

Key	Value
Name	Stormwater_UtilityNetwork.geodatabase
Workspace Type	Local Database
Workspace Factory	Sqlite
Geodatabase Release	3.0.0
Date Exported	2025-06-09 12:59:39
Path

Domain Name	Description	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
Asset_Manager	The manager of an asset.	Short Integer	Coded Value	Duplicate	Default Value	3	20
Asset_Owner	The owner of an asset.	Short Integer	Coded Value	Duplicate	Default Value	3	20
Asset_Type_Stormwater_Device_BMP_Inlet	The asset type for the stormwater devices's asset group BMP Inlet.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Stormwater_Device_BMP_Point	The asset type for the stormwater device's asset group BMP Point.	Short Integer	Coded Value	Duplicate	Default Value	18	1
Asset_Type_Stormwater_Device_Catch_Basin	The asset type for the stormwater device's asset group catch basin.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Stormwater_Device_Cleanout	The asset type for the stormwater device's asset group clean out.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Stormwater_Device_Connection	The asset type for the stormwater device's asset group pipe connection.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Stormwater_Device_Manhole_Channel	The asset type for the Stormwater device's asset group manhole channel.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Stormwater_Device_Outlet	The asset type for the stormwater device's asset group discharge.	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Stormwater_Device_Pump	The asset type for the stormwater device's asset group pump.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Stormwater_Device_Weir	The asset type for the stormwater device's asset group weir.	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Stormwater_Junction_Wall	The asset type for the stormwater junction's asset group wall.	Short Integer	Coded Value	Duplicate	Default Value	5	1
Asset_Type_Stormwater_Line_Culvert	The asset type for the stormwater line's asset group culvert	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Stormwater_Line_Linear_Drain	The asset type for the stormwater line's asset group linear drain	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Stormwater_Line_Open_Channel	The asset type for the stormwater line's asset group open channel.	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Stormwater_Line_Pipe	The asset type for the stormwater line's asset group pipe	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Structure_Boundary_BMP_Boundary	The asset type for the structure boundary's asset group BMP.	Short Integer	Coded Value	Duplicate	Default Value	18	1
Asset_Type_Structure_Boundary_Storm_Lift_Station_Boundary	The asset type for the structure boundary's asset group storm pump station.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Structure_Junction_Sewer_Storm_Vault	The asset type for the structure junction's asset group sewer storm vault.	Short Integer	Coded Value	Duplicate	Default Value	2	1
Attribute Rule Type	The attribute rule type that created the error record.	Short Integer	Coded Value	Default Value	Default Value	3	4
BMP_Class	The class of a BMP.	Short Integer	Coded Value	Duplicate	Default Value	3	2
Construction_Status	Valid Construction statues for the assets.	Short Integer	Coded Value	Duplicate	Default Value	8	28
Event_Level	The activate value of a stormwater or sewer device.	Short Integer	Coded Value	Duplicate	Default Value	4	3
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	17
Manhole_Types	Types of manholes.	Short Integer	Coded Value	Duplicate	Default Value	10	1
Network_6_AssociationStatus	Indicates how the feature participates in associations.	Short Integer	Coded Value	Duplicate	Default Value	36	39
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	12
Network_6_IsConnected	Indicates if the feature is connected to a subnetwork controller.	Short Integer	Coded Value	Duplicate	Default Value	3	24
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	3
Network_6_IsSubnetworkController	Indicates if a device feature is a subnetwork controller.	Short Integer	Coded Value	Default Value	Default Value	2	13
Network_6_TerminalNames	The terminal names in the utility network.	Short Integer	Coded Value	Duplicate	Default Value	14	12
Network_6_TierName	The tier names in the utility network.	Short Integer	Coded Value	Default Value	Default Value	2	13
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 values for the data	Short Integer	Coded Value	Duplicate	Default Value	4	24
Spatial_Source	Source of the data	Short Integer	Coded Value	Duplicate	Default Value	6	24
Stormwater_BMP_Material	The material of stormwater BMPs	Short Integer	Coded Value	Duplicate	Default Value	16	1
Stormwater_Catch_Basin_Opening_Type	The type of catch basin	Short Integer	Coded Value	Duplicate	Default Value	4	1
Stormwater_Cleanout_Diameter	The diameter of stormwater cleanouts.	Double	Coded Value	Duplicate	Default Value	30	1
Stormwater_Cleanout_Material	The material of stormwater cleanouts.	Short Integer	Coded Value	Duplicate	Default Value	27	1
Stormwater_Culvert_Shape	The shape of stormwater culverts.	Short Integer	Coded Value	Duplicate	Default Value	8	1
Stormwater_Exiting_System	The way water exits the stormwater system.	Short Integer	Coded Value	Duplicate	Default Value	4	5
Stormwater_Inlet_Shape	The shpae of the stormwater inlet.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Stormwater_Open_Channel_Type	The type of open channel.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Stormwater_Outlet_Diameter	The diameter of a stormwater oulet.	Double	Coded Value	Duplicate	Default Value	29	1
Stormwater_Outlet_Location	The location of the stormwater oulet.	Short Integer	Coded Value	Duplicate	Default Value	4	1
Stormwater_Outlet_Material	The material of stormwater outlets.	Short Integer	Coded Value	Duplicate	Default Value	27	1
Stormwater_Pipe_Diameter	The diameter of stormwater pipes.	Double	Coded Value	Duplicate	Default Value	30	2
Stormwater_Pipe_Liner_Method	The liner method of stormwater pipes.	Short Integer	Coded Value	Duplicate	Default Value	14	1
Stormwater_Pipe_Liner_Year	The liner year of stormwater pipes.	Short Integer	Range	Duplicate	Default Value		1
Stormwater_Pipe_Material	The material of stormwater pipes.	Short Integer	Coded Value	Duplicate	Default Value	27	3
Stormwater_Pipe_Shape	The shape of stormwater pipes.	Short Integer	Coded Value	Duplicate	Default Value	8	1
Stormwater_Pump_Type	The type of the stormwater pump.	Short Integer	Coded Value	Duplicate	Default Value	7	1
Stormwater_Wall_Material	The material of stormwater walls.	Short Integer	Coded Value	Duplicate	Default Value	33	1
Structure_Boundary_BMP_Condition	The condition of a BMP.	Short Integer	Coded Value	Duplicate	Default Value	7	1
Structure_Sewer_Storm_Manhole_Step_Material	The step material of structure manholes.	Short Integer	Coded Value	Duplicate	Default Value	5	1
Structure_Sewer_Storm_Materials	The materials of sewer storm structures.	Short Integer	Coded Value	Duplicate	Default Value	12	3
Structure_Sewer_Storm_Vault_Cover_Shape	The cover shape of structure manholes.	Short Integer	Coded Value	Duplicate	Default Value	12	1
Structure_Sewer_Storm_Vault_Cover_Type	The cover type of structure manholes.	Short Integer	Coded Value	Duplicate	Default Value	7	1
Structure_Sewer_Storm_Vault_Manhole_Cone	The cone type of structure manholes.	Short Integer	Coded Value	Duplicate	Default Value	3	1
Structure_Sewer_Storm_Vault_Manhole_Location	The location of structure manholes.	Short Integer	Coded Value	Duplicate	Default Value	14	1
Structure_Sewer_Storm_Vault_Manhole_Surface	The surface type of structure manholes.	Short Integer	Coded Value	Duplicate	Default Value	7	1
Symbol_Rotation	The rotation of an asset's symbol.	Short Integer	Range	Duplicate	Default Value		15
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	20
Validation_Status	The current record's validation status.	Short Integer	Coded Value	Duplicate	Default Value	8	0
Yes_No	A yes/no indicator	Short Integer	Coded Value	Duplicate	Default Value	3	20

Datasets

main.DischargeInspection

Properties

Key	Value
Name	main.DischargeInspection
Dataset Type	Table
Dataset ID	110
Minimum Client Version	10.1
Alias	Discharge Inspection
OID Field	objectid
GlobalID Field	globalid
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{F301D897-3645-4E50-B290-340150ACEB88}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Length	Editable	Required
objectid	OBJECTID	OID	Index	False	4	False	True
inspector	Inspector	String		True	50	True	False
inspectdt	Inspection Date	Date		True	8	True	False
dryweather	Dry Weather Inspection?	Short Integer		True	2	True	False
dateprecip	Date of Last Precipitation	Date		True	8	True	False
amountprecip	Amount of Last Precipitation	Double		True	8	True	False
flow	Flow Present?	Short Integer		True	2	True	False
flowrate	Flow Rate	Short Integer		True	2	True	False
flowcolor	Flow contains color?	Short Integer		True	2	True	False
colordesc	Color Description	Short Integer		True	2	True	False
colordesc_other	Specify other	String		True	50	True	False
flowodor	Flow contains odor?	Short Integer		True	2	True	False
odordesc	Odor Description	Short Integer		True	2	True	False
odordesc_other	Specify other	String		True	50	True	False
flowfloatable	Flow contains floatables?	Short Integer		True	2	True	False
floatabledesc	Floatable Description	Short Integer		True	2	True	False
floatabledesc_other	Specify other	String		True	50	True	False
recievingwater	Change in recieving water?	Short Integer		False	2	True	False
recievingwaterdesc	Description of Change	String		True	150	True	False
illicitdischarge	Is Flow Illicit Discharge?	Short Integer		True	2	True	False
illicitdischargesource	Efforts to determine source	String		True	150	True	False
illicitdischargeaction	Corrective Action Taken	String		True	150	True	False
notes	Notes	String		True	2000	True	False
assetguid	Asset GUID	GUID	Index	True	38	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_110_assetgui	False	True	assetguid
UUID_50	True	True	globalid
FDO_objectid	True	True	objectid

main.DischargeInspection__ATTACH

Properties

Key	Value
Name	main.DischargeInspection__ATTACH
Dataset Type	Table
Dataset ID	111
Minimum Client Version	10.1
Alias	DischargeInspection__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	{8A09F4AB-815C-4A86-825C-83ACCBB9A001}
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	True
created_date	created_date	Date	Created	True	8	False	True
last_edited_user	last_edited_user	String	Editor	True	255	False	True
last_edited_date	last_edited_date	Date	Edited	True	8	False	True

Indexes

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

main.DischargeInspection__ATTACHREL

Key	Value
Name	main.DischargeInspection__ATTACHREL
Dataset Type	RelationshipClass
Dataset ID	123
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.DischargeInspection
Origin Primary Key	globalid
Origin Foreign Key	REL_GLOBALID
Destination Name	main.DischargeInspection__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{0973A9A7-E8F3-4F8B-9FE8-5B97BDFE6FCC}

main.GDB_ValidationLineErrors

Properties

Key	Value
Name	main.GDB_ValidationLineErrors
Dataset Type	FeatureClass
Dataset ID	140
Geometry Type	Polyline
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.1
Alias	Validation Line Errors
OID Field	ObjectID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	CREATOR
Create Date Field	CREATIONDATE
Editor Field	UPDATEDBY
Edit Date Field	LASTUPDATE
Shape Field	Shape
Spatial Reference	GCS_WGS_1984
Catalog ID	{8321C66F-B627-4A78-86F0-83BE1472A478}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

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

Indexes

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

main.GDB_ValidationObjectErrors

Properties

Key	Value
Name	main.GDB_ValidationObjectErrors
Dataset Type	Table
Dataset ID	138
Minimum Client Version	10.1
Alias	Validation Object Errors
OID Field	ObjectID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	CREATOR
Create Date Field	CREATIONDATE
Editor Field	UPDATEDBY
Edit Date Field	LASTUPDATE
Catalog ID	{BE0B888A-DD83-4D99-AFFC-7779E6A63AF4}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

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

Indexes

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

main.GDB_ValidationPointErrors

Properties

Key	Value
Name	main.GDB_ValidationPointErrors
Dataset Type	FeatureClass
Dataset ID	139
Geometry Type	Point
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.1
Alias	Validation Point Errors
OID Field	ObjectID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	CREATOR
Create Date Field	CREATIONDATE
Editor Field	UPDATEDBY
Edit Date Field	LASTUPDATE
Shape Field	Shape
Spatial Reference	GCS_WGS_1984
Catalog ID	{00AB2FB3-3FF6-4381-874F-F1344114D263}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

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

Indexes

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

main.GDB_ValidationPolygonErrors

Properties

Key	Value
Name	main.GDB_ValidationPolygonErrors
Dataset Type	FeatureClass
Dataset ID	141
Geometry Type	Polygon
Feature Type	Simple
Z-Aware	True
M-Aware	True
Split Model	Update Insert
Minimum Client Version	10.1
Alias	Validation Polygon Errors
OID Field	ObjectID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	CREATOR
Create Date Field	CREATIONDATE
Editor Field	UPDATEDBY
Edit Date Field	LASTUPDATE
Shape Field	Shape
Spatial Reference	GCS_WGS_1984
Catalog ID	{170EA31C-972A-422E-9F99-63F0DA5E044A}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

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

Indexes

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

main.ManholeInspection

Properties

Key	Value
Name	main.ManholeInspection
Dataset Type	Table
Dataset ID	112
Minimum Client Version	10.1
Alias	Manhole Inspection
OID Field	objectid
GlobalID Field	globalid
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{C3740377-5993-4A9B-9F41-51866AC6D94A}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Length	Editable	Required
objectid	OBJECTID	OID	Index	False	4	False	True
inspector	Inspector	String		True	50	True	False
inspectdt	Inspection Date	Date		True	8	True	False
inspectpurp	Purpose of Inspection	Short Integer		True	2	True	False
precleaning	Pre-Cleaning	Short Integer		True	2	True	False
precleaningdate	Pre-Cleaning Date	Date		True	8	True	False
weather	Weather	Short Integer		True	2	True	False
runoff	Runoff Potential	Short Integer		True	2	True	False
inspectionstatus	Inspection Status	Short Integer		True	2	True	False
evidsurcharge	Evidence of Surchage	Short Integer		True	2	True	False
coverfit	Cover Fit	Short Integer		True	2	True	False
covercondition	Cover Condition	Short Integer		True	2	True	False
coverinsertcondition	Cover Insert Condition	Short Integer		True	2	True	False
coverringcondition	Cover Ring Condition	Short Integer		True	2	True	False
framecondition	Frame Condition	Short Integer		True	2	True	False
framesealcondition	Frame Seal Condition	Short Integer		True	2	True	False
framesealinflow	Evidence of Frame Seal Inflow	Short Integer		True	2	True	False
notes	Notes	String		True	2000	True	False
assetguid	Asset GUID	GUID	Index	True	38	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_112_assetgui	False	True	assetguid
UUID_52	True	True	globalid
FDO_objectid	True	True	objectid

main.ManholeInspection__ATTACH

Properties

Key	Value
Name	main.ManholeInspection__ATTACH
Dataset Type	Table
Dataset ID	113
Minimum Client Version	10.1
Alias	ManholeInspection__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	{0799AE0E-BF07-4E04-A146-8F6137CBCA7E}
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	True
created_date	created_date	Date	Created	True	8	False	True
last_edited_user	last_edited_user	String	Editor	True	255	False	True
last_edited_date	last_edited_date	Date	Edited	True	8	False	True

Indexes

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

main.ManholeInspection__ATTACHREL

Key	Value
Name	main.ManholeInspection__ATTACHREL
Dataset Type	RelationshipClass
Dataset ID	124
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	True
Is Attributed	False
Origin Name	main.ManholeInspection
Origin Primary Key	globalid
Origin Foreign Key	REL_GLOBALID
Destination Name	main.ManholeInspection__ATTACH
Forward Path Label	attachment
Backward Path Label	object
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{D1D044FA-CB41-4006-9A8E-11FC90E06E48}

main.Network

Key	Value
Name	main.Network
Dataset Type	UtilityNetwork
Feature Dataset	main.UtilityNetwork
Dataset ID	6
Schema Generation	7
Pro Version	ArcGIS Pro 3.3.0
Creation Time	2024-04-26 11:12:25
Spatial Reference	NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet;NAVD88_height_(ftUS)
X-Min	500372.76851501653
X-Max	1270078.1610237253
Y-Min	1550391.9656166665
Y-Max	2190094.2549103117
Z-Min	0.00010000000474974513
Z-Max	0.00010000000474974513
Service Territory	main.ServiceTerritory

Key	Value
hasClusterKey	False

Domain Network Name	Domain Network Alias	Domain Network ID	Tier Definition	Subnetwork Controller Type	Creation Time
Structure	Structure	1	None		2024-04-26 11:12:25
Stormwater	Stormwater	2	Partitioned	Sink	2024-04-26 11:13:25

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

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

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

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

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

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

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

Category Name	Creation Time
Subnetwork Controller	2024-04-26 11:12:25
Subnetwork Tap	2024-04-26 11:12:25
Attribute Substitution	2024-04-26 11:12:25

Configuration Name	Configuration ID	Traversability Model	Default	Creation Time
Single terminal	0	Bidirectional	All	2024-04-26 11:12:25
Pressure Reducing	2	Directional	All	2024-04-26 11:14:00
Pressure Increasing	3	Directional	All	2024-04-26 11:14:00
Directional Dual Terminal	4	Directional	All	2024-04-26 11:14:00
Bidirectional Dual Terminal	5	Bidirectional	All	2024-04-26 11:14:00
Directional Manhole Terminal	6	Directional	All	2024-04-26 11:14:00

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

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

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

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

main.ServiceTerritory

Properties

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

Controller Membership

Key	Value
utilityNetworkName	main.Network

Fields

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

Indexes

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

main.Stormwater_Device_BMP_to_Inspection

Key	Value
Name	main.Stormwater_Device_BMP_to_Inspection
Dataset Type	RelationshipClass
Feature Dataset	main.UtilityNetwork
Dataset ID	130
Type	Composite
Cardinality	One To Many
Notification	None
Is Attachment	False
Is Attributed	False
Origin Name	main.StormwaterDevice
Origin Primary Key	globalid
Origin Foreign Key	assetguid
Destination Name	main.StormwaterBMPInspection
Forward Path Label	StormwaterBMPInspection
Backward Path Label	StormwaterDevice
Minimum Client Version	10.0
Editor Tracking Enabled	False
Catalog ID	{6FF4A8BD-B17B-42DB-B81D-81D49E94F6C2}

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

main.Stormwater_Device_Discharge_To_Inspection

main.StormwaterAssembly

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
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
subnetworkname	Subnetwork name	String		False		Unknown	2000	True	False
installdate	Install Date	Date		True			8	True	False
ownedby	Asset Owner	Short Integer		True	Asset_Owner	1	2	True	False
maintby	Asset Manager	Short Integer		True	Asset_Manager	1	2	True	False
symbolrotation	symbolrotation: Symbol Rotation	Short Integer		True	Symbol_Rotation		2	True	False
assetid	Asset ID	String		True			64	True	False
notes	Notes	String		True			2000	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	2	True	False
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

Subtypes

Assignments

main.StormwaterAssembly__ATTACH

Properties

Fields

Indexes

main.StormwaterAssembly__ATTACHREL

main.StormwaterBMPInspection

Properties

Fields

Indexes

main.StormwaterBMPInspection__ATTACH

Properties

Fields

Indexes

main.StormwaterBMPInspection__ATTACHREL

main.StormwaterDevice

main.StormwaterDevice__ATTACH

Properties

Fields

Indexes

main.StormwaterDevice__ATTACHREL

main.StormwaterEdgeObject

Properties

Controller Membership

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
ISCONNECTED	Is connected	Short Integer		False	Network_6_IsConnected	2	2	False	True
FLOWDIRECTION	Flow direction	Short Integer		True	Network_6_FlowDirection	1	2	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
SUBNETWORKNAME	Subnetwork name	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
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
constructionstatus	Construction Status	Short Integer		True	Construction_Status	6	2	True	False
created_user	created_user	String	Creator	True			255	False	False
created_date	created_date	Date	Created	True			8	False	False
last_edited_user	last_edited_user	String	Editor	True			255	False	False
last_edited_date	last_edited_date	Date	Edited	True			8	False	False

Indexes

Subtypes

Assignments

main.StormwaterJunction

Properties

Controller Membership

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
ISCONNECTED	Is connected	Short Integer		False	Network_6_IsConnected	2	2	False	True
SHAPE	Shape	Geometry	Index	False			8	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
SUBNETWORKNAME	Subnetwork name	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
installdate	Install Date	Date		True			8	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
symbolrotation	Symbol Rotation	Short Integer		True	Symbol_Rotation		2	True	False
material	Material	Short Integer		True			2	True	False
assetid	Asset ID	String		True			64	True	False
notes	Notes	String		True			2000	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	2	True	False
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

Subtypes

Assignments

Attribute Rules

StormwaterJunction-GenerateIDs

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

Junction Symbol Rotation

Key	Value
ID	11
Minimum Client Version	12.4
Evaluation Order	2
Name	Junction Symbol Rotation
Description	Symbol rotation calculation for junction features
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Field Name	symbolrotation
Editable	True
Enabled	True
Exclude From Client	False
Creation Time	2024-04-26 11:14:39
Script	// Assigned To: StormwaterJunction // Type: Calculation // Name: Junction Symbol Rotation // Description: Symbol rotation calculation for junction features // Subtypes: All // Field: symbolrotation // Trigger: Insert, Update // Exclude From Client: False // Disable: False // This calculation attribute rule intersects a line layer and based on the number of // intersected features, calculates the angle for the point // Set to true if the rotation setting is set to geographic in the layer properties var geographic_rotation = false; // Set the counter clockwise spin angle used for the symbol in the symbology options var symbol_flip_angle = 0 // Return if a value is already set, to recalculate an angle, the field must be set to null if (IsEmpty($feature.symbolrotation) == false) { return $feature.symbolrotation; } // Create a feature set to the line layer var lineClass = FeatureSetByName($datastore, "{16A07D31-4676-4014-8851-CD41B08D1C2A}", ["objectid"], true); // Find the intersecting lines var lines = Intersects(lineClass, $feature); var intersectcount = Count(lines); //If no lines intersect, return the original value if (intersectcount == 0) { return $feature.symbolrotation; } var diff_tol = 5; // Variable to store all found angles var angles = []; var new_segment = null; // Store the features geometry var feature_geometry = Geometry($feature); // Loop over all intersecting lines and find their angles var angle_type; var angle_value; for (var line in lines) { // Buffer and create an extenf of the point by a small amount to extract the segment var clip_area = Extent(Buffer($feature, .01, "meter")); // Clip the line by the extend and get the first line segment var segment = Clip(line, clip_area)["paths"][0]; // The features location is on the start of the line, get the angle from the feature to the end vertex if (Equals(segment[0], feature_geometry)) { angle_type = 'from' angle_value = Round(Angle(feature_geometry, segment[-1]), 0) } // The features location is on the end of the line, create a new segment from the feature to the start vertex else if (Equals(segment[-1], feature_geometry)) { angle_type = 'to' angle_value = Round(Angle(feature_geometry, segment[0]), 0) } // The features location is midspan of the segment, use the angle of the segment else { angle_type = 'mid' angle_value = Round(Angle(segment[0], segment[-1]), 0) } if (geographic_rotation == true) { // Convert Arithmetic to Geographic angle_value = (450 - angle_value) % 360; } // Add 180 to match 0 rotation in the TOC // Add user specified spin angle if their symbol is rotated angle_value = (angle_value + 180 + symbol_flip_angle) % 360; angles[Count(angles)] = {'angle': angle_value, 'type': angle_type}; } // If only one angle, return that value if (Count(angles) == 1) { // If the point is midspan, flip to match symbol as it if was on the end point if (angles[0]['type'] == 'mid') { return (angles[0]['angle'] + 180) % 360; } return angles[0]['angle']; } else if (Count(angles) == 2) { // If the feature is midpan of the first line, return the angle of the second line if (angles[0]['type'] == 'mid') return angles[1]['angle']; // If the feature is midpan of the second line, return the angle of the first line else if (angles[1]['type'] == 'mid') return angles[0]['angle']; // If the feature is at the end point of both lines, return the angle of the first line else if (angles[0]['type'] == 'to' && angles[1]['type'] == 'to') { return angles[0]['angle']; } // If the feature is at the start point of both lines, return the angle of the first line else if (angles[0]['type'] == 'from' && angles[1]['type'] == 'from') { return angles[0]['angle']; } // If the feature is at the start point of the first line and end of the second line, return the second line else if (angles[0]['type'] == 'from') { return angles[1]['angle']; } // If the feature is at the start point of the second line and start of the second line, return the first line return angles[0]['angle']; } else if (Count(angles) == 3) { // Flatten the angles to ignore direction var flat_angle1 = angles[0]['angle'] % 180; var flat_angle2 = angles[1]['angle'] % 180; var flat_angle3 = angles[2]['angle'] % 180; // Create differences between angles var angle_dif_a = Abs(flat_angle1 - flat_angle2); var angle_dif_b = Abs(flat_angle1 - flat_angle3); var angle_dif_c = Abs(flat_angle2 - flat_angle3); // If difference between line 1 and 2 is below the tolerance, meaning the lines follow the same plane, return the // third line if (angle_dif_a <= (diff_tol * 2) \|\| angle_dif_a >= (180 - (diff_tol * 2))) { return angles[2]['angle']; } // If difference between line 1 and 3 is below the tolerance, meaning the lines follow the same plane, return the // second line else if (angle_dif_b <= (diff_tol * 2) \|\| angle_dif_b >= (180 - (diff_tol * 2))) { return angles[1]['angle']; } // If difference between line 2 and 3 is below the tolerance, meaning the lines follow the same plane, return the // first line else if (angle_dif_c <= (diff_tol * 2) \|\| angle_dif_c >= (180 - (diff_tol * 2))) { return angles[0]['angle']; } // Return first if not covered above return angles[0]['angle']; } // All other cases, the first feature is returned else { return angles[0]['angle']; }

main.StormwaterJunction__ATTACH

Properties

Fields

Indexes

main.StormwaterJunction__ATTACHREL

main.StormwaterJunctionObject

Properties

Controller Membership

Fields

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

Indexes

Subtypes

Assignments

main.StormwaterLine

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
SUBNETWORKNAME	Subnetwork name	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
diameter	Diameter	Double		True			8	True	False
upelev	Upstream Elevation	Double		True			8	True	False
downelev	Downstream Elevation	Double		True			8	True	False
slope	Slope	Double		True			8	True	False
installdate	Install Date	Date		True			8	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
pipeshape	Culvert Shape, Pipe Shape	Short Integer		True			2	True	False
type	Type	Short Integer		True			2	True	False
lined	Lined?	Short Integer		True			2	True	False
lineryear	Liner Year	Short Integer		True			2	True	False
linermethod	Liner Method	Short Integer		True			2	True	False
assetid	Asset ID	String		True			64	True	False
notes	Notes	String		True			2000	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	2	True	False
material	Material	Short Integer		True			2	True	False
width	Width	Double		True			8	True	False
height	Height	Double		True			8	True	False
wall	Wall	Short Integer		True			2	True	False
measuredlength	Measured Length	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
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

StormwaterLine-GenerateIDs

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

Line - Snap to Manhole

Key	Value
ID	13
Minimum Client Version	12.7
Evaluation Order	2
Name	Line - Snap to Manhole
Description	Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:14:42
Script	// Assigned To: StormwaterLine // Type: Calculation // Name: Line - Snap to Manhole // Description: Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel. // Subtypes: All // Field: // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups/subtypes // Implementation Note: Instead of recreating this rule for each subtype, this rules uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. Industry data model includes Gravity Pipe, Force Main var asset_group = $feature.assetgroup; var valid_asset_groups = [4]; // The class names of the Manholes, Diversion Point // Implementation Note: These are just the class/table name and should not be fully qualified. var device_class = "StormwaterDevice"; var struct_junc_class = "StructureJunction"; // The class name of the Associations table // Implementation Note: Used for determining associations not on $feature var assoc_fs = FeatureSetByName($datastore, '{E7D20B1F-257E-457B-9668-A3F96B2330F7}', ['FROMGLOBALID', 'TOGLOBALID'], false); // The Asset Group and Asset Type of a Connection / Pipe Connection var conn_ag = 23; var conn_at = 241; // The Asset Group and Asset Type of the Manhole Channel // Implementation Note: The Asset Type value specifies what type of point that a Main can snap to. var manhole_chan = 301; var dir_manhole_chan = 302; var pipe_snap_types = 'AssetGroup in (32) and AssetType in (@manhole_chan, @dir_manhole_chan)'; // The Terminal Names used for connecting Directional Manhole Channels to Pipe Connections var from_terminal = "Downstream"; var to_terminal= "Upstream"; // Structure Junction - Stormwater Storm Vault sql // Implementation Note: SQL expression used to find Stormwater Storm Vault containers var vault_sql = 'ASSETGROUP in (208) and ASSETTYPE in (9)'; // The High Pipe Elevation field name on a Stormwater Storm Vault - Manhole var high_pipe_elev = "highpipeelev"; // Distance to offset Pipe line from snapped Manhole var offset_distance = 2; var percent_distance = 10; // if length of pipe is too short, pull back by this percent var offset_unit = 'feet'; // *********** End User Variables Section ********* // ********* Functions *********** // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_snapped_point_info(point_geo) { // Get point that intersects point_geo. Must match an AG and AT group specified in pipe_snap_types. var device_fs = get_features_switch_yard($datastore, device_class, ["globalid", "assetgroup", 'assettype'], true); var snapped_feats = Intersects(device_fs, Point(point_geo)); return First(Filter(snapped_feats, pipe_snap_types)); } function pull_line_back(line_geo, endpoint_geo, pull_back) { // Buffer the endpoint_geo point by 'pull_back' units. Use new buffer polygon to clip the line_geo. if ((Length(line_geo, offset_unit)) < pull_back * 3) { pull_back = (percent_distance / 100) * Length(line_geo, offset_unit); } var clip_geom = Buffer(endpoint_geo, pull_back, offset_unit); return Difference(line_geo, clip_geom); } function create_connection_points(new_line, create_from, create_to) { var new_conns = []; var paths = new_line['paths']; var new_from_point = Point({'x': paths[0][0]['x'], 'y': paths[0][0]['y'], 'z': paths[0][0]['z'], 'spatialReference': new_line['spatialReference']}); var new_to_point = Point({'x': paths[-1][-1]['x'], 'y': paths[-1][-1]['y'], 'z': paths[-1][-1]['z'], 'spatialReference': new_line['spatialReference']}); if (create_from) { var conn1 = { 'tag': 'newconn0', 'attributes': { 'AssetGroup': conn_ag, 'AssetType': conn_at }, 'geometry': new_from_point }; push(new_conns, conn1) } if (create_to) { var conn2 = { 'tag': 'newconn1', 'attributes': { 'AssetGroup': conn_ag, 'AssetType': conn_at }, 'geometry': new_to_point }; push(new_conns, conn2) } return new_conns } function reset_z(line_geo, from_to, z_value) { // adjust z-values of begin/end points in polyline. convert to dictionary to update. var line_dict = Dictionary(Text(line_geo)); line_dict['paths'][iif(from_to == 'from', 0, -1)][iif(from_to == 'from', 0, -1)][2] = z_value; // custom projections can sometimes cause SR to be dropped if (!HasKey(line_dict, "spatialReference")) line_dict["spatialReference"] = line_geo.spatialReference return Polyline(line_dict) } function get_container(manhole_id) { // Get Stormwater Vault - Manhole which is container of Manhole Channel we are snapping to var filtered_fs = Filter(assoc_fs, "TOGLOBALID = @manhole_id and ASSOCIATIONTYPE in (2)"); if (Count(filtered_fs) == 0) return null; var container = First(filtered_fs).fromglobalid; // verify container is a Stormwater Vault var vault = get_features_switch_yard($datastore, struct_junc_class, ['GLOBALID', 'ASSETGROUP', 'ASSETTYPE', high_pipe_elev], false); var filtered_vault = Filter(vault, "GLOBALID = @container and " + vault_sql); if (Count(filtered_vault) == 0) return null; return First(filtered_vault); } function create_connect_assocs(manhole_ch, idx) { // build association payload for connectivity var connect_assoc = { "fromClass": device_class, "fromGlobalID": manhole_ch.globalid, "toClass": device_class, "toGlobalid": 'newconn' + Text(idx) + ".globalid", "associationType": "connectivity" }; // if AT is Directional Manhole Channel, need to use terminals if (manhole_ch.assettype == dir_manhole_chan){ connect_assoc['fromTerminal'] = iif(idx == 0, from_terminal, to_terminal) } return connect_assoc; } function create_contain_assocs(pt_id, idx) { // build association payload for containment return { "fromClass": struct_junc_class, "fromGlobalID": pt_id, "toClass": device_class, "toGlobalid": 'newconn' + Text(idx) + ".globalid", "associationType": "containment" }; } function high_pipe_payload(manhole, pipe_z) { // if manhole High Pipe Elevation attribute is less then incoming Pipe Connection z, update High Pipe Elev var updates = []; if (IsEmpty(manhole[high_pipe_elev]) \|\| manhole[high_pipe_elev] < pipe_z) { var attr = {"globalid": manhole.globalid, "attributes": Dictionary(high_pipe_elev, pipe_z)}; push(updates, attr) } return updates } // *********** End Functions Section **************** // Validation // Limit the rule to valid asset groups if (!Includes(valid_asset_groups, asset_group)) { return; } // Get the start and end vertex of the line var assigned_line_geo = Geometry($feature); var paths = assigned_line_geo['paths']; var from_point = paths[0][0]; var to_point = paths[-1][-1]; // Get the snapped Device(s) var from_manhole_chan = get_snapped_point_info(Point(from_point)); var to_manhole_chan = get_snapped_point_info(Point(to_point)); if (IsEmpty(from_manhole_chan) && IsEmpty(to_manhole_chan)) return; // pull line back var new_line_geo = assigned_line_geo; if (!IsEmpty(from_manhole_chan)) { new_line_geo = pull_line_back(new_line_geo, Geometry(from_manhole_chan), offset_distance); // reset z-values to original new_line_geo = reset_z(new_line_geo, 'from', from_point['z']); } if (!IsEmpty(to_manhole_chan)) { new_line_geo = pull_line_back(new_line_geo, Geometry(to_manhole_chan), offset_distance); // reset z-values to original new_line_geo = reset_z(new_line_geo, 'to', to_point['z']); } // need to check for empty to get past runtime if (IsEmpty(new_line_geo)) return; // generate new Pipe Connections var new_conns = create_connection_points(new_line_geo, !IsEmpty(from_manhole_chan), !IsEmpty(to_manhole_chan)); // build associations var struct_junc_updates = []; var un_adds = []; if (!IsEmpty(from_manhole_chan)) { // connect Pipe Connection to Manhole Channel push(un_adds, create_connect_assocs(from_manhole_chan, 0)); // contain Pipe Connection in Stormwater Vault var from_contain = get_container(from_manhole_chan.globalid); if(!IsEmpty(from_contain)) { push(un_adds, create_contain_assocs(from_contain.globalid, 0)); } } if (!IsEmpty(to_manhole_chan)) { // connect Pipe Connection to Manhole Channel push(un_adds, create_connect_assocs(to_manhole_chan, 1)); // contain Pipe Connection in Stormwater Vault var to_contain = get_container(to_manhole_chan.globalid); if(!IsEmpty(to_contain)) { push(un_adds, create_contain_assocs(to_contain.globalid, 1)); // update High Pipe Elevation attribute on Stormwater Vault. only do this with pipe endpoints struct_junc_updates = high_pipe_payload(to_contain, new_line_geo['paths'][-1][-1]['z']); } } var edit_payload = [{ 'className': device_class, 'adds': new_conns }, { 'className': '^UN_Association', 'adds': un_adds }]; if (Count(struct_junc_updates) > 0) { push(edit_payload, {'className': struct_junc_class, 'updates': struct_junc_updates}) } return { "result": {"geometry": new_line_geo}, "edit": edit_payload };

Line - Set Attributes from Z

Key	Value
ID	14
Minimum Client Version	12.7
Evaluation Order	3
Name	Line - Set Attributes from Z
Description	Update upstream and downstream attributes a Main based on Geometry Z values of begin and endpoints of line.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:14:42
Script	// Assigned To: StormwaterLine // Type: Calculation // Name: Line - Set Attributes from Z // Description: Update upstream and downstream attributes a Main based on Geometry Z values of begin and endpoints of line. // Subtypes: All // Field: // Trigger: Insert, Update // Evaluation Order: 3 // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - Device - Set Attributes from Z // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups/subtypes // Implementation Note: Instead of recreating this rule for each subtype, this rule uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. var asset_group = $feature.assetgroup; var valid_asset_groups = [4, 5, 6, 7]; // Pipe, Open Channel, Culvert, Linear Drain // The attribute fields to update using Z values var upelev = "upelev"; var downelev = "downelev"; // *********** End User Variables Section *********** // Limit the rule to valid asset groups if (!Includes(valid_asset_groups, asset_group)) return; // Get the start and end vertex of the line var assigned_line_geo = Geometry($feature); var from_z = assigned_line_geo['paths'][0][0].z; var to_z = assigned_line_geo['paths'][-1][-1].z; if (IsEmpty(from_z) && IsEmpty(to_z)) return; var ret = {}; if (!IsEmpty(to_z)) ret[downelev] = Round(to_z, 2); if (!IsEmpty(from_z)) ret[upelev] = Round(from_z, 2); return {'result': {'attributes': ret}};

Line - Main Slope

Key	Value
ID	15
Minimum Client Version	12.7
Evaluation Order	4
Name	Line - Main Slope
Description	Adjusts the slope based on the upstream, downstream, and length of the main
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Field Name	slope
Editable	True
Enabled	True
Exclude From Client	False
Creation Time	2024-04-26 11:14:42
Script	// Assigned To: StormwaterLine // Type: Calculation // Name: Line - Main Slope // Description: Adjusts the slope based on the upstream, downstream, and length of the main // Subtypes: All // Field: slope // Trigger: Insert, Update // Evaluation Order: 4 // Exclude From Client: False // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups/subtypes // Implementation Note: Instead of recreating this rule for each subtype, this rules uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. var asset_group = $feature.assetgroup; var valid_asset_groups = [4, 5, 6, 7]; // Pipe, Open Channel, Culvert, Linear Drain // *********** End User Variables Section *********** // Limit the rule to valid asset groups if (!Includes(valid_asset_groups, asset_group)) return $feature.slope; if (IsEmpty($feature.UPELEV) \|\| IsEmpty($feature.DOWNELEV)) { return $feature.slope; } if (IsEmpty(Geometry($feature)) \|\| Length(Geometry($feature)) == 0) { return $feature.slope; } return ABS(($feature.UPELEV - $feature.DOWNELEV)/Length(Geometry($feature)));

Line - Snap to Manhole batch

Key	Value
ID	16
Minimum Client Version	12.7
Evaluation Order	1
Name	Line - Snap to Manhole batch
Description	Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel.
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2024-04-26 11:14:42
Script	// Assigned To: StormwaterLine // Type: Calculation // Name: Line - Snap to Manhole // Description: Generates pipe connection points when Stormwater Pipe is snapped to a Manhole Channel. // Subtypes: All // Field: // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset groups/subtypes // Implementation Note: Instead of recreating this rule for each subtype, this rules uses a list of subtypes and exits if not valid // If you have added Asset Groups, they will need to be added to this list. Industry data model includes Gravity Pipe, Force Main var asset_group = $feature.assetgroup; var valid_asset_groups = [4]; // The class names of the Manholes, Diversion Point // Implementation Note: These are just the class/table name and should not be fully qualified. var device_class = "StormwaterDevice"; var struct_junc_class = "StructureJunction"; // The class name of the Associations table // Implementation Note: Used for determining associations not on $feature var assoc_fs = FeatureSetByName($datastore, '{E7D20B1F-257E-457B-9668-A3F96B2330F7}', ['FROMGLOBALID', 'TOGLOBALID'], false); // The Asset Group and Asset Type of a Connection / Pipe Connection var conn_ag = 23; var conn_at = 241; // The Asset Group and Asset Type of the Manhole Channel // Implementation Note: The Asset Type value specifies what type of point that a Main can snap to. var manhole_chan = 301; var dir_manhole_chan = 302; var pipe_snap_types = 'AssetGroup in (32) and AssetType in (@manhole_chan, @dir_manhole_chan)'; // The Terminal Names used for connecting Directional Manhole Channels to Pipe Connections var from_terminal = "Downstream"; var to_terminal= "Upstream"; // Structure Junction - Stormwater Storm Vault sql // Implementation Note: SQL expression used to find Stormwater Storm Vault containers var vault_sql = 'ASSETGROUP in (208) and ASSETTYPE in (9)'; // The High Pipe Elevation field name on a Stormwater Storm Vault - Manhole var high_pipe_elev = "highpipeelev"; // Distance to offset Pipe line from snapped Manhole var offset_distance = 2; var percent_distance = 10; // if length of pipe is too short, pull back by this percent var offset_unit = 'feet'; // *********** End User Variables Section ********* // ********* Functions *********** // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_snapped_point_info(point_geo) { // Get point that intersects point_geo. Must match an AG and AT group specified in pipe_snap_types. var device_fs = get_features_switch_yard($datastore, device_class, ["globalid", "assetgroup", 'assettype'], true); var snapped_feats = Intersects(device_fs, Point(point_geo)); return First(Filter(snapped_feats, pipe_snap_types)); } function pull_line_back(line_geo, endpoint_geo, pull_back) { // Buffer the endpoint_geo point by 'pull_back' units. Use new buffer polygon to clip the line_geo. if ((Length(line_geo, offset_unit)) < pull_back * 3) { pull_back = (percent_distance / 100) * Length(line_geo, offset_unit); } var clip_geom = Buffer(endpoint_geo, pull_back, offset_unit); return Difference(line_geo, clip_geom); } function create_connection_points(new_line, create_from, create_to) { var new_conns = []; var paths = new_line['paths']; var new_from_point = Point({'x': paths[0][0]['x'], 'y': paths[0][0]['y'], 'z': paths[0][0]['z'], 'spatialReference': new_line['spatialReference']}); var new_to_point = Point({'x': paths[-1][-1]['x'], 'y': paths[-1][-1]['y'], 'z': paths[-1][-1]['z'], 'spatialReference': new_line['spatialReference']}); if (create_from) { var conn1 = { 'tag': 'newconn0', 'attributes': { 'AssetGroup': conn_ag, 'AssetType': conn_at }, 'geometry': new_from_point }; push(new_conns, conn1) } if (create_to) { var conn2 = { 'tag': 'newconn1', 'attributes': { 'AssetGroup': conn_ag, 'AssetType': conn_at }, 'geometry': new_to_point }; push(new_conns, conn2) } return new_conns } function reset_z(line_geo, from_to, z_value) { // adjust z-values of begin/end points in polyline. convert to dictionary to update. var line_dict = Dictionary(Text(line_geo)); line_dict['paths'][iif(from_to == 'from', 0, -1)][iif(from_to == 'from', 0, -1)][2] = z_value; // custom projections can sometimes cause SR to be dropped if (!HasKey(line_dict, "spatialReference")) line_dict["spatialReference"] = line_geo.spatialReference return Polyline(line_dict) } function get_container(manhole_id) { // Get Stormwater Vault - Manhole which is container of Manhole Channel we are snapping to var filtered_fs = Filter(assoc_fs, "TOGLOBALID = @manhole_id and ASSOCIATIONTYPE in (2)"); if (Count(filtered_fs) == 0) return null; var container = First(filtered_fs).fromglobalid; // verify container is a Stormwater Vault var vault = get_features_switch_yard($datastore, struct_junc_class, ['GLOBALID', 'ASSETGROUP', 'ASSETTYPE', high_pipe_elev], false); var filtered_vault = Filter(vault, "GLOBALID = @container and " + vault_sql); if (Count(filtered_vault) == 0) return null; return First(filtered_vault); } function create_connect_assocs(manhole_ch, idx) { // build association payload for connectivity var connect_assoc = { "fromClass": device_class, "fromGlobalID": manhole_ch.globalid, "toClass": device_class, "toGlobalid": 'newconn' + Text(idx) + ".globalid", "associationType": "connectivity" }; // if AT is Directional Manhole Channel, need to use terminals if (manhole_ch.assettype == dir_manhole_chan){ connect_assoc['fromTerminal'] = iif(idx == 0, from_terminal, to_terminal) } return connect_assoc; } function create_contain_assocs(pt_id, idx) { // build association payload for containment return { "fromClass": struct_junc_class, "fromGlobalID": pt_id, "toClass": device_class, "toGlobalid": 'newconn' + Text(idx) + ".globalid", "associationType": "containment" }; } function high_pipe_payload(manhole, pipe_z) { // if manhole High Pipe Elevation attribute is less then incoming Pipe Connection z, update High Pipe Elev var updates = []; if (IsEmpty(manhole[high_pipe_elev]) \|\| manhole[high_pipe_elev] < pipe_z) { var attr = {"globalid": manhole.globalid, "attributes": Dictionary(high_pipe_elev, pipe_z)}; push(updates, attr) } return updates } // *********** End Functions Section **************** // Validation // Limit the rule to valid asset groups if (!Includes(valid_asset_groups, asset_group)) { return; } // Get the start and end vertex of the line var assigned_line_geo = Geometry($feature); var paths = assigned_line_geo['paths']; var from_point = paths[0][0]; var to_point = paths[-1][-1]; // Get the snapped Device(s) var from_manhole_chan = get_snapped_point_info(Point(from_point)); var to_manhole_chan = get_snapped_point_info(Point(to_point)); if (IsEmpty(from_manhole_chan) && IsEmpty(to_manhole_chan)) return; // pull line back var new_line_geo = assigned_line_geo; if (!IsEmpty(from_manhole_chan)) { new_line_geo = pull_line_back(new_line_geo, Geometry(from_manhole_chan), offset_distance); // reset z-values to original new_line_geo = reset_z(new_line_geo, 'from', from_point['z']); } if (!IsEmpty(to_manhole_chan)) { new_line_geo = pull_line_back(new_line_geo, Geometry(to_manhole_chan), offset_distance); // reset z-values to original new_line_geo = reset_z(new_line_geo, 'to', to_point['z']); } // need to check for empty to get past runtime if (IsEmpty(new_line_geo)) return; // generate new Pipe Connections var new_conns = create_connection_points(new_line_geo, !IsEmpty(from_manhole_chan), !IsEmpty(to_manhole_chan)); // build associations var struct_junc_updates = []; var un_adds = []; if (!IsEmpty(from_manhole_chan)) { // connect Pipe Connection to Manhole Channel push(un_adds, create_connect_assocs(from_manhole_chan, 0)); // contain Pipe Connection in Stormwater Vault var from_contain = get_container(from_manhole_chan.globalid); if(!IsEmpty(from_contain)) { push(un_adds, create_contain_assocs(from_contain.globalid, 0)); } } if (!IsEmpty(to_manhole_chan)) { // connect Pipe Connection to Manhole Channel push(un_adds, create_connect_assocs(to_manhole_chan, 1)); // contain Pipe Connection in Stormwater Vault var to_contain = get_container(to_manhole_chan.globalid); if(!IsEmpty(to_contain)) { push(un_adds, create_contain_assocs(to_contain.globalid, 1)); // update High Pipe Elevation attribute on Stormwater Vault. only do this with pipe endpoints struct_junc_updates = high_pipe_payload(to_contain, new_line_geo['paths'][-1][-1]['z']); } } var edit_payload = [{ 'className': device_class, 'adds': new_conns }, { 'className': '^UN_Association', 'adds': un_adds }]; if (Count(struct_junc_updates) > 0) { push(edit_payload, {'className': struct_junc_class, 'updates': struct_junc_updates}) } return { "result": {"geometry": new_line_geo}, "edit": edit_payload };

main.StormwaterLine__ATTACH

Properties

Fields

Indexes

main.StormwaterLine__ATTACHREL

main.StormwaterSubnetLine

Properties

Controller Membership

Fields

Indexes

Subtypes

Assignments

main.Structure_Junction_Manhole_To_Inspection

main.StructureBoundary

Properties

Controller Membership

Fields

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

Indexes

Subtypes

Assignments

Attribute Rules

StructureBoundary-GenerateIDs

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

main.StructureBoundary__ATTACH

Properties

Fields

Indexes

main.StructureBoundary__ATTACHREL

main.StructureEdgeObject

Properties

Controller Membership

Fields

Indexes

Subtypes

Assignments

main.StructureJunction

Properties

Controller Membership

Fields

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

Indexes

Subtypes

Assignments

Attribute Rules

StructureJunction - Create Manhole Channel

Key	Value
ID	1
Minimum Client Version	12.7
Evaluation Order	1
Name	StructureJunction - Create Manhole Channel
Description	When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	False
Delete Trigger	False
Subtype	Sewer Storm Vault
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:14:29
Script	// Assigned To: StructureJunction // Type: Calculation // Name: StructureJunction - Create Manhole Channel // Description: When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel. // Subtypes: Sewer Storm Vault // Field: // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset types // Implementation Note: Instead of recreating this rule for each asset type, this rules uses a list of domains and exits if not valid var asset_type = $feature.assettype; var valid_asset_types = [9]; // The class name of StormwaterDevice / Manhole Channel var device_class = "StormwaterDevice"; // The Asset Group and Asset Type of a StormwaterDevice / Manhole Channel (non-directional) var manhole_chan_ag = 32; var manhole_chan_at = 301; // *********** End User Variables Section *********** // Limit the rule to valid asset types if (!Includes(valid_asset_types, asset_type)) { return; } var geom = Geometry($feature); var new_manhole_chan = { 'attributes': { 'AssetGroup': manhole_chan_ag, 'AssetType': manhole_chan_at }, 'geometry': geom, 'associationType': 'content', 'isContentVisible': true }; var edit_payload = [{ 'className': device_class, 'adds': [new_manhole_chan] }]; return {"edit": edit_payload};

StructureJunction-GenerateIDs

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

StructureJunction - Manhole Elevation Attributes

Key	Value
ID	3
Minimum Client Version	12.7
Evaluation Order	3
Name	StructureJunction - Manhole Elevation Attributes
Description	Set rim elevation, invert elevation, and depth on Sewer Storm Vault - Manhole from the Z value. Update Manhole Channel content feature z value if needed.
Type	Calculation
Batch	False
Insert Trigger	True
Update Trigger	True
Delete Trigger	False
Subtype	Sewer Storm Vault
Editable	True
Enabled	True
Exclude From Client	True
Creation Time	2024-04-26 11:14:29
Script	// Assigned To: StructureJunction // Type: Calculation // Name: StructureJunction - Manhole Elevation Attributes // Description: Set rim elevation, invert elevation, and depth on Sewer Storm Vault - Manhole from the Z value. Update Manhole Channel content feature z value if needed. // Subtypes: Sewer Storm Vault // Field: // Trigger: Insert, Update // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset types // Implementation Note: Instead of recreating this rule for each asset type, this rules uses a list of domains and exits if not valid var asset_type = $feature.assettype; var valid_asset_types = [9]; // The rim elevation, invert elevation and depth field names var rimelev_fld = "rimelev"; var invertelev_fld = "invertelev"; var depth_fld = "depth"; var depth = $feature.depth; // The class names of the Manhole Channels // Implementation Note: These are just the class/table name and should not be fully qualified. var device_class = "StormwaterDevice"; // Stormwater Device - Manhole Channel sql clause // Implementation Note: Sql expression used to find content Manhole Channels to update z value with Invert Elevation value var manhole_chan_sql = 'AssetGroup in (32) and AssetType in (301, 302)'; // *********** End User Variables Section ********* // ********* Functions ********* // monikerize FeatureSetByName function var get_features_switch_yard = FeatureSetByName; function get_content_manhole_chan() { // find Manhole Channel globalid that is content of $feature var associations = FeatureSetByAssociation($feature, 'content'); var filtered = Filter(associations, "className = @device_class"); var associated_ids = []; for (var row in filtered) { push(associated_ids, row.globalId) } if (Count(associated_ids) < 1) return null; var device_fs = get_features_switch_yard($datastore, device_class, ["globalid", "assetgroup", 'assettype'], true); var content_man_chan = First(Filter(device_fs, "GLOBALID in @associated_ids and " + manhole_chan_sql)); return iif(IsEmpty(content_man_chan), null, content_man_chan) } function update_geom(geo, new_z) { // Set z on point to new value var geo_dict = Dictionary(Text(geo)); geo_dict['z'] = new_z; return Point(drop_nans(geo_dict)) } function drop_nans(dict_with_nans) { // drop any keys with a value of NaN var new_dict = {}; for (var k in dict_with_nans) { if (!IsNan(dict_with_nans[k])) { new_dict[k] = dict_with_nans[k] } } return new_dict } // ********* End Functions Section **************** // Limit the rule to valid asset types if (!Includes(valid_asset_types, asset_type)) { return; } // Round z to 2 sigfigs var geo_z = Geometry($feature).z; geo_z = Round(geo_z, 2); // build payload to update rim elevation, invert elevation, depth if (IsEmpty(depth)) depth = 0; var res = {"attributes": Dictionary(rimelev_fld, geo_z, invertelev_fld, geo_z - depth, depth_fld, depth)}; var ret = {"result": res}; // Get manhole channel and update z to invertelev var man_chan = get_content_manhole_chan(); if (!IsEmpty(man_chan)) { // if invertelev of Manhole does not match Z of Manhole Channel, update the Manhole Channel if (Geometry(man_chan).z != res["attributes"][invertelev_fld]){ var update_manhole_chan = { "globalid": man_chan.globalid, 'geometry': update_geom(Geometry(man_chan), res["attributes"][invertelev_fld]) }; var edit_payload = [{ 'className': device_class, 'updates': [update_manhole_chan] }]; ret["edit"] = edit_payload } } return ret;

StructureJunction - Create Manhole Channel batch

Key	Value
ID	4
Minimum Client Version	12.7
Evaluation Order	1
Name	StructureJunction - Create Manhole Channel batch
Description	When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel.
Type	Calculation
Batch	True
Insert Trigger	False
Update Trigger	False
Delete Trigger	False
Subtype	Sewer Storm Vault
Editable	True
Enabled	False
Exclude From Client	True
Creation Time	2024-04-26 11:14:30
Script	// Assigned To: StructureJunction // Type: Calculation // Name: StructureJunction - Create Manhole Channel // Description: When a Sewer Storm Vault - Manhole is created, generate and contain a Manhole Channel. // Subtypes: Sewer Storm Vault // Field: // Trigger: Insert // Exclude From Client: True // Disable: False // Related Rules: Some rules rely on additional rules for execution. If this rule works in conjunction with another, they are listed below: // - None // Duplicated in: This rule may be implemented on other classes, they are listed here to aid you in adjusting those rules when a code change is required. // - None // *********** User Variables ********* // This section has the functions and variables that need to be adjusted based on your implementation // Limit the rule to valid asset types // Implementation Note: Instead of recreating this rule for each asset type, this rules uses a list of domains and exits if not valid var asset_type = $feature.assettype; var valid_asset_types = [9]; // The class name of StormwaterDevice / Manhole Channel var device_class = "StormwaterDevice"; // The Asset Group and Asset Type of a StormwaterDevice / Manhole Channel (non-directional) var manhole_chan_ag = 32; var manhole_chan_at = 301; // *********** End User Variables Section *********** // Limit the rule to valid asset types if (!Includes(valid_asset_types, asset_type)) { return; } var geom = Geometry($feature); var new_manhole_chan = { 'attributes': { 'AssetGroup': manhole_chan_ag, 'AssetType': manhole_chan_at }, 'geometry': geom, 'associationType': 'content', 'isContentVisible': true }; var edit_payload = [{ 'className': device_class, 'adds': [new_manhole_chan] }]; return {"edit": edit_payload};

main.StructureJunction__ATTACH

Properties

Fields

Indexes

main.StructureJunction__ATTACHREL

main.StructureJunctionObject

Properties

Controller Membership

Fields

Indexes

Subtypes

Assignments

main.StructureLine

Properties

Controller Membership

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Length	Editable	Required
OBJECTID	Object ID	OID	Index	False			8	False	True
ASSETGROUP	Asset group	Long Integer	Subtype	False		0	4	True	True
ASSETTYPE	Asset type	Short Integer		False		0	2	True	True
ASSOCIATIONSTATUS	Association status	Short Integer		False	Network_6_AssociationStatus	0	2	False	True
SUBNETWORKNAME	Subnetwork name	String	Index	False		Unknown	2000	False	True
FLOWDIRECTION	Flow direction	Short Integer		True	Network_6_FlowDirection	1	2	True	True
SHAPE	Shape	Geometry	Index	False			8	True	True
GLOBALID	Global ID	Global ID	Index	False			38	False	True
name	Name	String		True			64	True	False
notes	Notes	String		True			2000	True	False
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle_Combined	2	2	True	False
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	2	True	False
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	2	True	False
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
st_length(SHAPE)	shape_Length	Double	Length	True			0	False	True

Indexes

Subtypes

Assignments

main.StructureLine__ATTACH

Properties

Fields

Indexes

main.StructureLine__ATTACHREL

main.UtilityNetwork

Domains

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

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

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

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

Name	Is Unique	Is Ascending	Field Name
GDB_102_VALIDATI	False	True	VALIDATIONSTATUS
GDB_102_SUBNETWO	False	True	SUBNETWORKCONTROLLERNAME
GDB_102_SUBNETWO_1	False	True	SUBNETWORKNAME
GDB_102_SUPPORTE	False	True	SUPPORTEDSUBNETWORKNAME
GDB_102_SUPPORTI	False	True	SUPPORTINGSUBNETWORKNAME
UUID_43	True	True	GLOBALID
FDO_OBJECTID	True	True	OBJECTID
st_spindex__StormwaterDevice_SHAPE	True	True	SHAPE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Name	Is Unique	Is Ascending	Field Name
GDB_37_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_122_REL_GLOB	False	True	rel_globalid
UUID_62	True	True	globalid
FDO_attachmentid	True	True	attachmentid

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

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

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

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

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

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

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

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

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