Sewer Data Dictionary

Contents

Introduction
The data dictionary includes a description of the elements in the Sewer Data Dictionary. It will help you understand what elements are used to create the utility network and provide a description of what they are.

FeatureClass

ServiceTerritory

Class Details
DatasetType ShapeType Alias Has Attachment
FEATURE_CLASS SIMPLE Service Territory False
Fields
Name Alias Type Default Value Domain Nullable Description
objectid OBJECTID OID False
creator CREATOR TEXT (255) True
creationdate CREATIONDATE DATE True
updatedby UPDATEDBY TEXT (255) True
lastupdate LASTUPDATE DATE True
globalid GLOBALID GUID False
shape shape GEOMETRY True
name Utility Name TEXT (255) True
shape_length shape_Length DOUBLE True
shape_area shape_Area DOUBLE True

SewerAssembly

Class Details
DatasetType ShapeType Alias Has Attachment
FEATURE_CLASS SIMPLE Sewer Assembly True
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
globalid Global ID GUID False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
systemsubnetworkname systemsubnetworkname TEXT (2000) Unknown False
sewershedsubnetworkname sewershedsubnetworkname TEXT (2000) Unknown False
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Combined False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
notes Notes TEXT (2000) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
regionsubnetworkname regionsubnetworkname TEXT (2000) Unknown False
Subtypes
Code Name Description
0 Unknown
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
globalid Global ID GUID False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
systemsubnetworkname systemsubnetworkname TEXT (2000) Unknown False
sewershedsubnetworkname sewershedsubnetworkname TEXT (2000) Unknown False
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
notes Notes TEXT (2000) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
regionsubnetworkname regionsubnetworkname TEXT (2000) False
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX

SewerDevice

Class Details
DatasetType ShapeType Alias Has Attachment
FEATURE_CLASS SIMPLE SewerDevice True
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT 1 Pipeline_Valve_Status False
activevol Activate Volume SHORT 0 Event_Level False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Combined False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtypes
Code Name Description
0 Unknown
5 Pump
1 Flow Valve
2 Controllable Valve
3 Relief Valve
10 Meter
15 Treatment
26 Weir
25 Monitoring
27 Gate
7 Service Connection
21 Cleanout
50 Anode
51 Rectifier
52 Test Point
30 Grease Trap
31 Backflow Preventer
23 Connection
22 Outlet
53 Groundbed
32 Manhole Channel
4 Intake
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Pump
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Pump False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT Sewer_Liftstation_Pump_Type True
diameter Diameter DOUBLE Sewer_Pump_Inlet_Diameter True
secondarydiameter Discharge Diameter DOUBLE Sewer_Pump_Discharge_Diameter True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Pump: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
61 Pump Pipe Directional Dual Terminal ['Subnetwork Controller'] NONE DO_NOT_SPLIT END_VERTEX
62 Pump with Grinder Pipe Directional Dual Terminal ['Subnetwork Controller'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Flow Valve
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Flow_Valve False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT 1 Pipeline_Valve_Status False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE Sewer_Flow_Valve_Diameter True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT Pipeline_Valve_Status True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT Yes_No True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT Collection_Status True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT Ground_Location True
groundtype Ground Type SHORT Ground_Type True
operatingstatus Operating Status SHORT Sewer_Valve_Operating_Status True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Flow Valve: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
41 Air Gap Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
42 Altitude Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
43 Check Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Controllable Valve
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Controllable_Valve False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT 1 Pipeline_Valve_Status False
activevol Activate Volume SHORT False
designtype Type SHORT Sewer_Controllable_Valve_Type True
diameter Diameter DOUBLE Sewer_Controllable_Valve_Diameter True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT Pipeline_Valve_Status True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT Pipeline_Valve_Close_Direction True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT Yes_No True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT Collection_Status True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT Ground_Location True
groundtype Ground Type SHORT Ground_Type True
operatingstatus Operating Status SHORT Sewer_Valve_Operating_Status True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Controllable Valve: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
141 System Single terminal ['Isolation'] NONE DO_NOT_SPLIT END_VERTEX
142 Vault Single terminal ['Isolation'] NONE DO_NOT_SPLIT END_VERTEX
143 Elder Single terminal ['Isolation'] NONE DO_NOT_SPLIT END_VERTEX
144 Diverting Single terminal ['Isolation'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Relief Valve
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Relief_Valve False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT 1 Pipeline_Valve_Status False
activevol Activate Volume SHORT False
designtype Type SHORT Sewer_Device_Operation True
diameter Diameter DOUBLE Sewer_Relief_Valve_Diameter True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT Pipeline_Valve_Status True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT Yes_No True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT Collection_Status True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT Sewer_Controllable_Valve_Type True
groundlocation Ground Location SHORT Ground_Location True
groundtype Ground Type SHORT Ground_Type True
operatingstatus Operating Status SHORT Sewer_Valve_Operating_Status True
assetrating Asset Rating SHORT Sewer_Asset_Rating True
offsetvalve Offset Valve SHORT Yes_No True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT Sewer_ARV_Operating_Status True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Relief Valve: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
121 Air & Vacuum Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
122 Air Release Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
123 Combination Air Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
124 Blow Off Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Meter
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Meter False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT Boolean True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Meter: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
161 Bulk Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
162 Station Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
163 Flow Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Treatment
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Treatment False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT Boolean True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Treatment: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
201 Treatment Plant Pipe Directional Dual Terminal ['Subnetwork Controller'] NONE DO_NOT_SPLIT END_VERTEX
202 Comminutor Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
203 Storage Tank Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
204 Clarifier Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
205 Chlorine Contact Basin Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
206 Aeration Basin Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
207 ABW Filters Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
208 Sludge Holding Tank Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
209 Recovered Water Tank Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Weir
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Weir False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Weir: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
281 Broad-Crested Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
282 Combination Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
283 Labyrinth Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
284 Minimum Energy Loss Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
285 Sharp-Crested Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
286 V-Notch Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Monitoring
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Monitoring False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Monitoring: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
181 Pressure Sensor Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
182 Temperature Sensor Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Gate
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Gate False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT 1 Pipeline_Valve_Status False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT Pipeline_Valve_Status True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Gate: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
101 Gate Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
102 Stop Log Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Service Connection
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Service_Connection False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT Sewer_Service_Meter_Type True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT Boolean True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Service Connection: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
1 Commercial Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
2 Industrial Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
3 Residential Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Cleanout
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Cleanout False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT Sewer_Cleanout_Access_Type True
diameter Diameter DOUBLE Sewer_Cleanout_Access_Diameter True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT Sewer_Cleanout_Material True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Cleanout: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
81 Cleanout Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
82 Lamp Hole Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
83 Terminal Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
85 Pig Port Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Anode
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Anode False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT CP_Anode_Material True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE CP_Anode_Weight True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Anode: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
901 ICCP Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
902 Galvanic Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Rectifier
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Rectifier False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT CP_Rectifier_Manufacturer True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT CP_Rectifier_Cooling_Method True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Rectifier: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
941 Rectifier Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Test Point
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Test_Point False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT CP_Test_Point_Wire_Count True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Test Point: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
981 Test Point Sewer Terminal Block ['CP Only', 'Subnetwork Controller'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Grease Trap
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Grease_Trap False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT Location True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Grease Trap: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
311 Grease Trap Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
312 Grease Interceptor Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
313 Grease Recovery Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Backflow Preventer
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Backflow_Preventer False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT Backflow_Preventer_Manufacturer True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Backflow Preventer: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
321 Backflow Preventer Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Connection
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Connection False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT 0 Event_Level False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Connection: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
241 Pipe Connection Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Outlet
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Outlet False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT 0 Event_Level False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Outlet: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
221 Effluent Discharge Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
222 Overflow Pipe Directional Dual Terminal ['Subnetwork Controller'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Groundbed
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Groundbed False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT Groundbed_Depth True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Groundbed: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
911 Anode Bed Pipe Bidirectional Dual Terminal ['CP Only', 'Subnetwork Controller'] CONTAINER DO_NOT_SPLIT END_VERTEX
Subtype: Manhole Channel
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Manhole_Channel False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT True
operatingstatus Operating Status SHORT True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Manhole Channel: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
301 Manhole Channel Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
302 Directional Manhole Channel Directional Manhole Terminal ['Subnetwork Controller'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Intake
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Device_Intake False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
presentstatus Present Status SHORT False
activevol Activate Volume SHORT False
designtype Type SHORT True
diameter Diameter DOUBLE True
secondarydiameter Discharge Diameter DOUBLE True
pressure Rated Pressure DOUBLE True
normalstatus Normal Status SHORT True
operable Operable SHORT 1 Boolean True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
notes Notes TEXT (2000) True
accountid Account ID TEXT (50) True
material Material SHORT True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
inspectiondate Inspection Date DATE True
model Model TEXT (64) True
elevation Elevation DOUBLE True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
clocktoclose Clockwise to Close SHORT True
location Location SHORT True
manufacturer Manufacturer SHORT True
depth Groundbed Depth SHORT True
coolingmethod Cooling Method SHORT True
bypassvalve Bypass Valve SHORT True
ratedflow Rated Flow DOUBLE True
turnstoclose Turns to Close DOUBLE True
weight Weight DOUBLE True
testwirecount Test Wire Count SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
recordnumber Record Number TEXT (255) True
usetype Use Type SHORT Sewer_Asset_Use_Type True
collectiondate Collection Date DATE True
collectionstatus Collection Status SHORT Collection_Status True
serviceaddress Service Address TEXT (75) True
shutofftype Shutoff Type SHORT True
groundlocation Ground Location SHORT True
groundtype Ground Type SHORT Ground_Type True
operatingstatus Operating Status SHORT Sewer_Valve_Operating_Status True
assetrating Asset Rating SHORT True
offsetvalve Offset Valve SHORT True
hyperlink Hyperlink TEXT (255) True
countycritical County Critical SHORT True
additionalstatus additionalstatus: Operating Status, Install Status SHORT True
critical Critical Customer SHORT True
subnetworkbarrier Is Barrier for SHORT Subnetwork_Barrier True
inservicedate In-Service Date DATE True
lastmaint Last Maintenance DATE True
retireddate Retired Date DATE True
Subtype: Intake: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
50 Candy Cane Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
51 Electronic Air Admission Control Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
52 Air Intake Single terminal [] NONE DO_NOT_SPLIT END_VERTEX

SewerJunction

Class Details
DatasetType ShapeType Alias Has Attachment
FEATURE_CLASS SIMPLE Sewer Junction True
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Combined False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
watertype Water Type SHORT Sewer_Asset_Water_Type True
usetype Use Type SHORT Sewer_Asset_Use_Type True
recordnumber Record Number TEXT (255) True
Subtypes
Code Name Description
0 Unknown
20 Fitting
50 Wire Junction
51 Insulation Junction
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
watertype Water Type SHORT Sewer_Asset_Water_Type True
usetype Use Type SHORT Sewer_Asset_Use_Type True
recordnumber Record Number TEXT (255) True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Fitting
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Junction_Fitting False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
watertype Water Type SHORT Sewer_Asset_Water_Type True
usetype Use Type SHORT Sewer_Asset_Use_Type True
recordnumber Record Number TEXT (255) True
Subtype: Fitting: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
41 Coupling Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
42 Cross Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
43 Elbow Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
44 End Cap Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
45 Expansion Joint Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
46 Flange Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
47 Plug Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
48 Reducer Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
49 Reducing Cross Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
50 Reducing Tee Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
51 Saddle Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
52 Screw Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
53 Sleeve Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
54 Tap Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
55 Tapping Saddle Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
56 Tee Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
57 Transition Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
58 Weld Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
59 Wye Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Wire Junction
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Junction_Wire_Junction False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
watertype Water Type SHORT Sewer_Asset_Water_Type True
usetype Use Type SHORT Sewer_Asset_Use_Type True
recordnumber Record Number TEXT (255) True
Subtype: Wire Junction: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
901 Bond Junction Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
902 Test Lead Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
903 Tracer Wire Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Insulation Junction
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Junction_Insulation_Junction False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
symbolrotation Symbol Rotation SHORT Sewer_Symbol_Rotation True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
watertype Water Type SHORT Sewer_Asset_Water_Type True
usetype Use Type SHORT Sewer_Asset_Use_Type True
recordnumber Record Number TEXT (255) True
Subtype: Insulation Junction: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
941 Flange Insert Single terminal [] NONE DO_NOT_SPLIT END_VERTEX

SewerLine

Class Details
DatasetType ShapeType Alias Has Attachment
FEATURE_CLASS SIMPLE Sewer Line True
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
fromdeviceterminal From device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
todeviceterminal To device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Size/Diameter DOUBLE True
linertype Liner Type SHORT True
downelev Downstream Elevation DOUBLE True
upelev Upstream Elevation DOUBLE True
slope Slope DOUBLE True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Combined False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
tracerwire Tracer Wire SHORT True
measuredlength Measured Length DOUBLE True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
material Material SHORT True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
mainshape Main Shape SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
frommh From Manhole TEXT (25) True
tomh To Manhole TEXT (25) True
inspectiondate Inspection Date DATE True
yearrehabilitated Year Rehabilitated DATE True
recordnumber Record Number TEXT (255) True
recordsheetnumber Record Sheet Number TEXT (30) True
hyperlink Hyperlink TEXT (255) True
oqr PACP Overall Quick Rating TEXT (255) True
opr PACP Overall Pipe Rating DOUBLE True
opri PACP Overall Pipe Rating Index DOUBLE True
sqr PACP Structural Quick Rating TEXT (255) True
spr PACP Structural Pipe Rating DOUBLE True
spri PACP Structural Pipe Rating Index DOUBLE True
omqr PACP Operation Maintenance Quick Rating TEXT (255) True
ompr PACP Operation Maintenance Pipe Rating DOUBLE True
ompri PACP Operation Maintenance Pipe Rating Index DOUBLE True
height Height DOUBLE True
width Width DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
forcemainpressuretype Force Main Pressure Type SHORT True
shape_length SHAPE_Length DOUBLE True
Subtypes
Code Name Description
0 Unknown
50 Bonding Line
51 Test Lead Wire
52 Rectifier Cable
1 Sewer Gravity Main
2 Sewer Force Main
3 Lateral
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
fromdeviceterminal From device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
todeviceterminal To device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Size/Diameter DOUBLE True
linertype Liner Type SHORT True
downelev Downstream Elevation DOUBLE True
upelev Upstream Elevation DOUBLE True
slope Slope DOUBLE True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
tracerwire Tracer Wire SHORT Yes_No True
measuredlength Measured Length DOUBLE True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT True
cpoverride Cathodic Protection Override SHORT True
material Material SHORT True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
mainshape Main Shape SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
frommh From Manhole TEXT (25) True
tomh To Manhole TEXT (25) True
inspectiondate Inspection Date DATE True
yearrehabilitated Year Rehabilitated DATE True
recordnumber Record Number TEXT (255) True
recordsheetnumber Record Sheet Number TEXT (30) True
hyperlink Hyperlink TEXT (255) True
oqr PACP Overall Quick Rating TEXT (255) True
opr PACP Overall Pipe Rating DOUBLE True
opri PACP Overall Pipe Rating Index DOUBLE True
sqr PACP Structural Quick Rating TEXT (255) True
spr PACP Structural Pipe Rating DOUBLE True
spri PACP Structural Pipe Rating Index DOUBLE True
omqr PACP Operation Maintenance Quick Rating TEXT (255) True
ompr PACP Operation Maintenance Pipe Rating DOUBLE True
ompri PACP Operation Maintenance Pipe Rating Index DOUBLE True
height Height DOUBLE True
width Width DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
forcemainpressuretype Force Main Pressure Type SHORT True
shape_length SHAPE_Length DOUBLE True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Bonding Line
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Line_Bonding_Line False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
fromdeviceterminal From device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
todeviceterminal To device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Size/Diameter DOUBLE CP_Wire_Gauge True
linertype Liner Type SHORT True
downelev Downstream Elevation DOUBLE True
upelev Upstream Elevation DOUBLE True
slope Slope DOUBLE True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
tracerwire Tracer Wire SHORT Yes_No True
measuredlength Measured Length DOUBLE True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
material Material SHORT True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
mainshape Main Shape SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
frommh From Manhole TEXT (25) True
tomh To Manhole TEXT (25) True
inspectiondate Inspection Date DATE True
yearrehabilitated Year Rehabilitated DATE True
recordnumber Record Number TEXT (255) True
recordsheetnumber Record Sheet Number TEXT (30) True
hyperlink Hyperlink TEXT (255) True
oqr PACP Overall Quick Rating TEXT (255) True
opr PACP Overall Pipe Rating DOUBLE True
opri PACP Overall Pipe Rating Index DOUBLE True
sqr PACP Structural Quick Rating TEXT (255) True
spr PACP Structural Pipe Rating DOUBLE True
spri PACP Structural Pipe Rating Index DOUBLE True
omqr PACP Operation Maintenance Quick Rating TEXT (255) True
ompr PACP Operation Maintenance Pipe Rating DOUBLE True
ompri PACP Operation Maintenance Pipe Rating Index DOUBLE True
height Height DOUBLE True
width Width DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
forcemainpressuretype Force Main Pressure Type SHORT True
shape_length SHAPE_Length DOUBLE True
Subtype: Bonding Line: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
941 Wire Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
942 Strap Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Test Lead Wire
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Line_Test_Lead_Wire False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
fromdeviceterminal From device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
todeviceterminal To device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Size/Diameter DOUBLE CP_Wire_Gauge True
linertype Liner Type SHORT True
downelev Downstream Elevation DOUBLE True
upelev Upstream Elevation DOUBLE True
slope Slope DOUBLE True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
tracerwire Tracer Wire SHORT Yes_No True
measuredlength Measured Length DOUBLE True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
material Material SHORT True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
mainshape Main Shape SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
frommh From Manhole TEXT (25) True
tomh To Manhole TEXT (25) True
inspectiondate Inspection Date DATE True
yearrehabilitated Year Rehabilitated DATE True
recordnumber Record Number TEXT (255) True
recordsheetnumber Record Sheet Number TEXT (30) True
hyperlink Hyperlink TEXT (255) True
oqr PACP Overall Quick Rating TEXT (255) True
opr PACP Overall Pipe Rating DOUBLE True
opri PACP Overall Pipe Rating Index DOUBLE True
sqr PACP Structural Quick Rating TEXT (255) True
spr PACP Structural Pipe Rating DOUBLE True
spri PACP Structural Pipe Rating Index DOUBLE True
omqr PACP Operation Maintenance Quick Rating TEXT (255) True
ompr PACP Operation Maintenance Pipe Rating DOUBLE True
ompri PACP Operation Maintenance Pipe Rating Index DOUBLE True
height Height DOUBLE True
width Width DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
forcemainpressuretype Force Main Pressure Type SHORT True
shape_length SHAPE_Length DOUBLE True
Subtype: Test Lead Wire: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
901 Aqua Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
902 Blue Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
903 Forest Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
904 Green Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
905 Lavender Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
906 Orange Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
907 Pink Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
908 Red Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
909 Yellow Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
910 Purple Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Rectifier Cable
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Line_Rectifier_Cable False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
fromdeviceterminal From device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
todeviceterminal To device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Size/Diameter DOUBLE CP_Wire_Gauge True
linertype Liner Type SHORT True
downelev Downstream Elevation DOUBLE True
upelev Upstream Elevation DOUBLE True
slope Slope DOUBLE True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
tracerwire Tracer Wire SHORT Yes_No True
measuredlength Measured Length DOUBLE True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
material Material SHORT True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
mainshape Main Shape SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
frommh From Manhole TEXT (25) True
tomh To Manhole TEXT (25) True
inspectiondate Inspection Date DATE True
yearrehabilitated Year Rehabilitated DATE True
recordnumber Record Number TEXT (255) True
recordsheetnumber Record Sheet Number TEXT (30) True
hyperlink Hyperlink TEXT (255) True
oqr PACP Overall Quick Rating TEXT (255) True
opr PACP Overall Pipe Rating DOUBLE True
opri PACP Overall Pipe Rating Index DOUBLE True
sqr PACP Structural Quick Rating TEXT (255) True
spr PACP Structural Pipe Rating DOUBLE True
spri PACP Structural Pipe Rating Index DOUBLE True
omqr PACP Operation Maintenance Quick Rating TEXT (255) True
ompr PACP Operation Maintenance Pipe Rating DOUBLE True
ompri PACP Operation Maintenance Pipe Rating Index DOUBLE True
height Height DOUBLE True
width Width DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
forcemainpressuretype Force Main Pressure Type SHORT True
shape_length SHAPE_Length DOUBLE True
Subtype: Rectifier Cable: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
961 Rectifier Cable Single terminal ['CP Only'] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Sewer Gravity Main
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Line_Sewer_Gravity_Main False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
fromdeviceterminal From device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
todeviceterminal To device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Size/Diameter DOUBLE Sewer_Main_Diameter True
linertype Liner Type SHORT Sewer_Main_Liner True
downelev Downstream Elevation DOUBLE True
upelev Upstream Elevation DOUBLE True
slope Slope DOUBLE True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
tracerwire Tracer Wire SHORT Yes_No True
measuredlength Measured Length DOUBLE True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
material Material SHORT Sewer_Main_Material True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
mainshape Main Shape SHORT Sewer_Main_Shape True
watertype Water Type SHORT Sewer_Asset_Water_Type True
frommh From Manhole TEXT (25) True
tomh To Manhole TEXT (25) True
inspectiondate Inspection Date DATE True
yearrehabilitated Year Rehabilitated DATE True
recordnumber Record Number TEXT (255) True
recordsheetnumber Record Sheet Number TEXT (30) True
hyperlink Hyperlink TEXT (255) True
oqr PACP Overall Quick Rating TEXT (255) True
opr PACP Overall Pipe Rating DOUBLE True
opri PACP Overall Pipe Rating Index DOUBLE True
sqr PACP Structural Quick Rating TEXT (255) True
spr PACP Structural Pipe Rating DOUBLE True
spri PACP Structural Pipe Rating Index DOUBLE True
omqr PACP Operation Maintenance Quick Rating TEXT (255) True
ompr PACP Operation Maintenance Pipe Rating DOUBLE True
ompri PACP Operation Maintenance Pipe Rating Index DOUBLE True
height Height DOUBLE True
width Width DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
forcemainpressuretype Force Main Pressure Type SHORT True
shape_length SHAPE_Length DOUBLE True
Subtype: Sewer Gravity Main: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
1 Collector Gravity Main Single terminal [] NONE DO_NOT_SPLIT ANY_VERTEX
2 Interceptor Gravity Main Single terminal [] NONE DO_NOT_SPLIT ANY_VERTEX
Subtype: Sewer Force Main
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Line_Sewer_Force_Main False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
fromdeviceterminal From device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
todeviceterminal To device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Size/Diameter DOUBLE Sewer_Main_Diameter True
linertype Liner Type SHORT True
downelev Downstream Elevation DOUBLE True
upelev Upstream Elevation DOUBLE True
slope Slope DOUBLE True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
tracerwire Tracer Wire SHORT Yes_No True
measuredlength Measured Length DOUBLE True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
material Material SHORT Sewer_Main_Material True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
mainshape Main Shape SHORT Sewer_Main_Shape True
watertype Water Type SHORT Sewer_Asset_Water_Type True
frommh From Manhole TEXT (25) True
tomh To Manhole TEXT (25) True
inspectiondate Inspection Date DATE True
yearrehabilitated Year Rehabilitated DATE True
recordnumber Record Number TEXT (255) True
recordsheetnumber Record Sheet Number TEXT (30) True
hyperlink Hyperlink TEXT (255) True
oqr PACP Overall Quick Rating TEXT (255) True
opr PACP Overall Pipe Rating DOUBLE True
opri PACP Overall Pipe Rating Index DOUBLE True
sqr PACP Structural Quick Rating TEXT (255) True
spr PACP Structural Pipe Rating DOUBLE True
spri PACP Structural Pipe Rating Index DOUBLE True
omqr PACP Operation Maintenance Quick Rating TEXT (255) True
ompr PACP Operation Maintenance Pipe Rating DOUBLE True
ompri PACP Operation Maintenance Pipe Rating Index DOUBLE True
height Height DOUBLE True
width Width DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
forcemainpressuretype Force Main Pressure Type SHORT Sewer_Line_Pressure_Type True
shape_length SHAPE_Length DOUBLE True
Subtype: Sewer Force Main: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
41 Force Main Single terminal [] NONE DO_NOT_SPLIT ANY_VERTEX
Subtype: Lateral
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Sewer_Line_Lateral_Service False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
fromdeviceterminal From device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
todeviceterminal To device terminal SHORT 0 UtilityNetwork_5_TerminalNames False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname System Subnetwork TEXT (2000) Unknown False
regionsubnetworkname Region Subnetwork TEXT (2000) Unknown False
sewershedsubnetworkname Basin Subnetwork TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Size/Diameter DOUBLE Sewer_Lateral_Diameter True
linertype Liner Type SHORT Sewer_Main_Liner True
downelev Downstream Elevation DOUBLE True
upelev Upstream Elevation DOUBLE True
slope Slope DOUBLE True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
tracerwire Tracer Wire SHORT Yes_No True
measuredlength Measured Length DOUBLE True
notes Notes TEXT (2000) True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
cptraceability Cathodic Protection Traceability SHORT CP_Traceability True
cpoverride Cathodic Protection Override SHORT CP_Traceability True
material Material SHORT Sewer_Lateral_Material True
bondedinsulated Bonded/Insulated SHORT Bonded_Insulated True
mainshape Main Shape SHORT True
watertype Water Type SHORT Sewer_Asset_Water_Type True
frommh From Manhole TEXT (25) True
tomh To Manhole TEXT (25) True
inspectiondate Inspection Date DATE True
yearrehabilitated Year Rehabilitated DATE True
recordnumber Record Number TEXT (255) True
recordsheetnumber Record Sheet Number TEXT (30) True
hyperlink Hyperlink TEXT (255) True
oqr PACP Overall Quick Rating TEXT (255) True
opr PACP Overall Pipe Rating DOUBLE True
opri PACP Overall Pipe Rating Index DOUBLE True
sqr PACP Structural Quick Rating TEXT (255) True
spr PACP Structural Pipe Rating DOUBLE True
spri PACP Structural Pipe Rating Index DOUBLE True
omqr PACP Operation Maintenance Quick Rating TEXT (255) True
ompr PACP Operation Maintenance Pipe Rating DOUBLE True
ompri PACP Operation Maintenance Pipe Rating Index DOUBLE True
height Height DOUBLE True
width Width DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
forcemainpressuretype Force Main Pressure Type SHORT True
shape_length SHAPE_Length DOUBLE True
Subtype: Lateral: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT ANY_VERTEX
121 Commercial Single terminal [] NONE DO_NOT_SPLIT ANY_VERTEX
122 Industrial Single terminal [] NONE DO_NOT_SPLIT ANY_VERTEX
123 Residential Single terminal [] NONE DO_NOT_SPLIT ANY_VERTEX
124 Air Release Single terminal [] NONE DO_NOT_SPLIT ANY_VERTEX
125 Air Intake Single terminal [] NONE DO_NOT_SPLIT ANY_VERTEX

SewerSubnetLine

Class Details
DatasetType ShapeType Alias Has Attachment
FEATURE_CLASS SIMPLE Sewer Networks False
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
subnetworkname Subnetwork name TEXT (64) Unknown False
isdirty Is dirty SHORT 1 UtilityNetwork_5_IsDirty False
tiername Tier name SHORT 0 False
subnetworkcontrollernames Subnetwork controller names TEXT (1073741822) Unknown False
lastupdatesubnetwork Last update subnetwork DATE True
lastackexportsubnetwork Last ack export subnetwork DATE True
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
forcelength Force Main Length DOUBLE True
serviceconcnt Service Connection Count LONG True
gravitylength Gravity Main Length DOUBLE True
manholecnt Manhole Count LONG True
shape_length SHAPE_Length DOUBLE True
Subtypes
Code Name Description
0 Unknown
1 Sewer Cathodic Protection
2 Sewer Collection System
3 Sewer Collection Region
4 Sewer Collection Basin
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
subnetworkname Subnetwork name TEXT (64) Unknown False
isdirty Is dirty SHORT 1 UtilityNetwork_5_IsDirty False
tiername Tier name SHORT False
subnetworkcontrollernames Subnetwork controller names TEXT (1073741822) Unknown False
lastupdatesubnetwork Last update subnetwork DATE True
lastackexportsubnetwork Last ack export subnetwork DATE True
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
forcelength Force Main Length DOUBLE True
serviceconcnt Service Connection Count LONG True
gravitylength Gravity Main Length DOUBLE True
manholecnt Manhole Count LONG True
shape_length SHAPE_Length DOUBLE True
Subtype: Sewer Cathodic Protection
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
subnetworkname Subnetwork name TEXT (64) Unknown False
isdirty Is dirty SHORT 1 UtilityNetwork_5_IsDirty False
tiername Tier name SHORT False
subnetworkcontrollernames Subnetwork controller names TEXT (1073741822) Unknown False
lastupdatesubnetwork Last update subnetwork DATE True
lastackexportsubnetwork Last ack export subnetwork DATE True
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
forcelength Force Main Length DOUBLE True
serviceconcnt Service Connection Count LONG True
gravitylength Gravity Main Length DOUBLE True
manholecnt Manhole Count LONG True
shape_length SHAPE_Length DOUBLE True
Subtype: Sewer Collection System
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
subnetworkname Subnetwork name TEXT (64) Unknown False
isdirty Is dirty SHORT 1 UtilityNetwork_5_IsDirty False
tiername Tier name SHORT False
subnetworkcontrollernames Subnetwork controller names TEXT (1073741822) Unknown False
lastupdatesubnetwork Last update subnetwork DATE True
lastackexportsubnetwork Last ack export subnetwork DATE True
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
forcelength Force Main Length DOUBLE True
serviceconcnt Service Connection Count LONG True
gravitylength Gravity Main Length DOUBLE True
manholecnt Manhole Count LONG True
shape_length SHAPE_Length DOUBLE True
Subtype: Sewer Collection Region
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
subnetworkname Subnetwork name TEXT (64) Unknown False
isdirty Is dirty SHORT 1 UtilityNetwork_5_IsDirty False
tiername Tier name SHORT False
subnetworkcontrollernames Subnetwork controller names TEXT (1073741822) Unknown False
lastupdatesubnetwork Last update subnetwork DATE True
lastackexportsubnetwork Last ack export subnetwork DATE True
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
forcelength Force Main Length DOUBLE True
serviceconcnt Service Connection Count LONG True
gravitylength Gravity Main Length DOUBLE True
manholecnt Manhole Count LONG True
shape_length SHAPE_Length DOUBLE True
Subtype: Sewer Collection Basin
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
subnetworkname Subnetwork name TEXT (64) Unknown False
isdirty Is dirty SHORT 1 UtilityNetwork_5_IsDirty False
tiername Tier name SHORT False
subnetworkcontrollernames Subnetwork controller names TEXT (1073741822) Unknown False
lastupdatesubnetwork Last update subnetwork DATE True
lastackexportsubnetwork Last ack export subnetwork DATE True
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
forcelength Force Main Length DOUBLE True
serviceconcnt Service Connection Count LONG True
gravitylength Gravity Main Length DOUBLE True
manholecnt Manhole Count LONG True
shape_length SHAPE_Length DOUBLE True

StructureBoundary

Class Details
DatasetType ShapeType Alias Has Attachment
FEATURE_CLASS SIMPLE Structure Boundary True
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Combined False
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
notes Notes TEXT (2000) True
assetid Asset ID TEXT (64) True
shape_length SHAPE_Length DOUBLE True
shape_area SHAPE_Area DOUBLE True
Subtypes
Code Name Description
0 Unknown
307 Sewer Treatment Plant Boundary
208 Sewer Storm Vault Boundary
301 Sewer Lift Station Boundary
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Status False
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
notes Notes TEXT (2000) True
assetid Asset ID TEXT (64) True
shape_length SHAPE_Length DOUBLE True
shape_area SHAPE_Area DOUBLE True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Sewer Treatment Plant Boundary
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Structure_Boundary_Sewer_Treatment_Plant_Boundary False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
notes Notes TEXT (2000) True
assetid Asset ID TEXT (64) True
shape_length SHAPE_Length DOUBLE True
shape_area SHAPE_Area DOUBLE True
Subtype: Sewer Treatment Plant Boundary: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
81 Treatment Plant Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
Subtype: Sewer Storm Vault Boundary
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Structure_Boundary_Sewer_Storm_Vault_Boundary False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
notes Notes TEXT (2000) True
assetid Asset ID TEXT (64) True
shape_length SHAPE_Length DOUBLE True
shape_area SHAPE_Area DOUBLE True
Subtype: Sewer Storm Vault Boundary: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
1 Baffle Chamber Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
4 Regulator Chamber Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
5 Tide Gate Chamber Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
16 Wet Well Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
Subtype: Sewer Lift Station Boundary
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Structure_Boundary_Sewer_Lift_Station_Boundary False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
name Name TEXT (64) True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
notes Notes TEXT (2000) True
assetid Asset ID TEXT (64) True
shape_length SHAPE_Length DOUBLE True
shape_area SHAPE_Area DOUBLE True
Subtype: Sewer Lift Station Boundary: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
41 Lift Station Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX

StructureJunction

Class Details
DatasetType ShapeType Alias Has Attachment
FEATURE_CLASS SIMPLE Structure Junction True
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
conetype Cone Type SHORT True
location Manhole Location SHORT True
surface Manhole Surface Type SHORT True
covershape Cover Shape SHORT True
channel Channel SHORT True
bench Bench SHORT True
material Frame Material SHORT True
secondarymaterial Wall Material SHORT True
numsteps Number of Steps SHORT True
stepmaterial Step Material SHORT True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Combined False
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT 0 Sewer_Symbol_Rotation True
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
rimelev Rim Elevation DOUBLE True
invertelev Invert Elevation DOUBLE True
depth Depth DOUBLE True
highpipeelev High Pipe Elevation DOUBLE True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
notes Notes TEXT (2000) True
manholetype Manhole Type SHORT True
recordnumber Record Number TEXT (255) True
serviceaddress Service Address TEXT (50) True
hyperlink Hyperlink TEXT (255) True
collectiondate Collection Date DATE True
stationid Station ID TEXT (20) True
name Asset Name TEXT (75) True
countycritical County Critical SHORT True
plant Plant Facility TEXT (25) True
pumptype Pump Type SHORT True
linedyear Lined Year SHORT True
linertype Liner Type SHORT True
liftstationtype Lift Station Type SHORT True
diameter Diameter DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
watertype Water Type SHORT Sewer_Asset_Water_Type True
barreldiameter Barrel Diameter DOUBLE True
covertype Cover Type SHORT True
coverdiameter Manhole Cover Diameter DOUBLE True
interconnect Interconnect SHORT True
sanitarybasinid Sanitary Basin ID TEXT (25) True
inspectiondate Inspection Date DATE True
buffertype BufferType SHORT True
manholeid Manhole ID TEXT (10) True
structurecondition Condition SHORT True
flowdir Flow Direction TEXT (5) True
groundtype Ground Type SHORT True
designtype Design Type SHORT True
Subtypes
Code Name Description
0 Unknown
208 Sewer Storm Vault
301 Sewer Lift Station
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
conetype Cone Type SHORT True
location Manhole Location SHORT True
surface Manhole Surface Type SHORT True
covershape Cover Shape SHORT True
channel Channel SHORT True
bench Bench SHORT True
material Frame Material SHORT True
secondarymaterial Wall Material SHORT True
numsteps Number of Steps SHORT True
stepmaterial Step Material SHORT True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Status False
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT 0 Sewer_Symbol_Rotation True
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
rimelev Rim Elevation DOUBLE True
invertelev Invert Elevation DOUBLE True
depth Depth DOUBLE True
highpipeelev High Pipe Elevation DOUBLE True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
notes Notes TEXT (2000) True
manholetype Manhole Type SHORT True
recordnumber Record Number TEXT (255) True
serviceaddress Service Address TEXT (50) True
hyperlink Hyperlink TEXT (255) True
collectiondate Collection Date DATE True
stationid Station ID TEXT (20) True
name Asset Name TEXT (75) True
countycritical County Critical SHORT True
plant Plant Facility TEXT (25) True
pumptype Pump Type SHORT True
linedyear Lined Year SHORT True
linertype Liner Type SHORT True
liftstationtype Lift Station Type SHORT True
diameter Diameter DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
watertype Water Type SHORT Sewer_Asset_Water_Type True
barreldiameter Barrel Diameter DOUBLE True
covertype Cover Type SHORT True
coverdiameter Manhole Cover Diameter DOUBLE True
interconnect Interconnect SHORT True
sanitarybasinid Sanitary Basin ID TEXT (25) True
inspectiondate Inspection Date DATE True
buffertype BufferType SHORT True
manholeid Manhole ID TEXT (10) True
structurecondition Condition SHORT True
flowdir Flow Direction TEXT (5) True
groundtype Ground Type SHORT True
designtype Design Type SHORT True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Sewer Storm Vault
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Structure_Junction_Sewer_Storm_Vault False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
conetype Cone Type SHORT Structure_Sewer_Storm_Vault_Manhole_Cone True
location Manhole Location SHORT Structure_Sewer_Storm_Vault_Manhole_Location True
surface Manhole Surface Type SHORT Structure_Sewer_Storm_Manhole_Surface True
covershape Cover Shape SHORT Structure_Sewer_Storm_Access_Point_Cover_Shape True
channel Channel SHORT Yes_No True
bench Bench SHORT Yes_No True
material Frame Material SHORT Structure_Sewer_Storm_Manhole_Frame_Material True
secondarymaterial Wall Material SHORT Structure_Sewer_Storm_Manhole_Wall_Material True
numsteps Number of Steps SHORT True
stepmaterial Step Material SHORT Structure_Sewer_Storm_Manhole_Step_Material True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT 0 Sewer_Symbol_Rotation True
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
rimelev Rim Elevation DOUBLE True
invertelev Invert Elevation DOUBLE True
depth Depth DOUBLE True
highpipeelev High Pipe Elevation DOUBLE True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
notes Notes TEXT (2000) True
manholetype Manhole Type SHORT Sewer_Storm_Manhole_Type True
recordnumber Record Number TEXT (255) True
serviceaddress Service Address TEXT (50) True
hyperlink Hyperlink TEXT (255) True
collectiondate Collection Date DATE True
stationid Station ID TEXT (20) True
name Asset Name TEXT (75) True
countycritical County Critical SHORT True
plant Plant Facility TEXT (25) True
pumptype Pump Type SHORT True
linedyear Lined Year SHORT True
linertype Liner Type SHORT Sewer_Liner_Type True
liftstationtype Lift Station Type SHORT True
diameter Diameter DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
watertype Water Type SHORT Sewer_Asset_Water_Type True
barreldiameter Barrel Diameter DOUBLE Structure_Sewer_Storm_Manhole_Barrel_Diameter True
covertype Cover Type SHORT Sewer_Manhole_Cover_Type True
coverdiameter Manhole Cover Diameter DOUBLE Sewer_Manhole_Cover_Diameter True
interconnect Interconnect SHORT Yes_No True
sanitarybasinid Sanitary Basin ID TEXT (25) True
inspectiondate Inspection Date DATE True
buffertype BufferType SHORT Sewer_Buffer_Type True
manholeid Manhole ID TEXT (10) True
structurecondition Condition SHORT Condition True
flowdir Flow Direction TEXT (5) Sewer_Manhole_Flow_Direction True
groundtype Ground Type SHORT Ground_Type True
designtype Design Type SHORT Sewer_Vacuum_Valve_Pit_Config True
Subtype: Sewer Storm Vault: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
1 Baffle Chamber Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
4 Regulator Chamber Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
5 Tide Gate Chamber Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
9 Manhole Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
16 Wet Well Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
18 Vacuum Valve Pit Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
19 Grease Interceptor Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
20 Solids Interceptor Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
21 Oil Interceptor Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
Subtype: Sewer Lift Station
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Structure_Junction_Sewer_Lift_Station False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
conetype Cone Type SHORT True
location Manhole Location SHORT True
surface Manhole Surface Type SHORT True
covershape Cover Shape SHORT True
channel Channel SHORT True
bench Bench SHORT True
material Frame Material SHORT True
secondarymaterial Wall Material SHORT True
numsteps Number of Steps SHORT True
stepmaterial Step Material SHORT True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
ownedby Owned By SHORT Sewer_Asset_Owner True
maintby Maintained By SHORT Sewer_Asset_Manager True
symbolrotation Symbol Rotation SHORT 0 Sewer_Symbol_Rotation True
installdate Install Date DATE True
assetid Asset ID TEXT (64) True
rimelev Rim Elevation DOUBLE True
invertelev Invert Elevation DOUBLE True
depth Depth DOUBLE True
highpipeelev High Pipe Elevation DOUBLE True
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
notes Notes TEXT (2000) True
manholetype Manhole Type SHORT True
recordnumber Record Number TEXT (255) True
serviceaddress Service Address TEXT (50) True
hyperlink Hyperlink TEXT (255) True
collectiondate Collection Date DATE True
stationid Station ID TEXT (20) True
name Asset Name TEXT (75) True
countycritical County Critical SHORT Boolean True
plant Plant Facility TEXT (25) True
pumptype Pump Type SHORT Sewer_Liftstation_Pump_Type True
linedyear Lined Year SHORT True
linertype Liner Type SHORT Sewer_Liner_Type True
liftstationtype Lift Station Type SHORT Sewer_Lift_Station_Type True
diameter Diameter DOUBLE True
usetype Use Type SHORT Sewer_Asset_Use_Type True
watertype Water Type SHORT Sewer_Asset_Water_Type True
barreldiameter Barrel Diameter DOUBLE True
covertype Cover Type SHORT True
coverdiameter Manhole Cover Diameter DOUBLE True
interconnect Interconnect SHORT True
sanitarybasinid Sanitary Basin ID TEXT (25) True
inspectiondate Inspection Date DATE True
buffertype BufferType SHORT True
manholeid Manhole ID TEXT (10) True
structurecondition Condition SHORT True
flowdir Flow Direction TEXT (5) True
groundtype Ground Type SHORT True
designtype Design Type SHORT True
Subtype: Sewer Lift Station: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
81 Lift Station Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX

StructureLine

Class Details
DatasetType ShapeType Alias Has Attachment
FEATURE_CLASS SIMPLE Structure Line True
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Diameter DOUBLE False
measuredlength Measured Length DOUBLE True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Combined False
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
assetid Asset ID TEXT (64) True
shape_length SHAPE_Length DOUBLE True
Subtypes
Code Name Description
0 Unknown
201 Sewer Storm Casing
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Diameter DOUBLE False
measuredlength Measured Length DOUBLE True
lifecyclestatus Lifecycle Status SHORT 0 Lifecycle_Status False
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
assetid Asset ID TEXT (64) True
shape_length SHAPE_Length DOUBLE True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
Subtype: Sewer Storm Casing
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
shape Shape GEOMETRY False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 Asset_Type_Structure_Line_Sewer_Storm_Casing False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
diameter Diameter DOUBLE Structure_Sewer_Storm_Casing_Diameter False
measuredlength Measured Length DOUBLE True
lifecyclestatus Lifecycle Status SHORT 8 Lifecycle_Status False
spatialsource Spatial Source SHORT Spatial_Source True
spatialconfidence Spatial Confidence SHORT Spatial_Confidence True
assetid Asset ID TEXT (64) True
shape_length SHAPE_Length DOUBLE True
Subtype: Sewer Storm Casing: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX
1 Casing Single terminal [] CONTAINER DO_NOT_SPLIT END_VERTEX
Table

SewerEdgeObject

Class Details
DatasetType ShapeType Alias Has Attachment
TABLE Sewer Edge Object False
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname systemsubnetworkname TEXT (2000) Unknown False
regionsubnetworkname regionsubnetworkname TEXT (2000) Unknown False
sewershedsubnetworkname sewershedsubnetworkname TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
Subtypes
Code Name Description
0 Unknown
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname systemsubnetworkname TEXT (2000) Unknown False
regionsubnetworkname regionsubnetworkname TEXT (2000) Unknown False
sewershedsubnetworkname sewershedsubnetworkname TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX

SewerJunctionObject

Class Details
DatasetType ShapeType Alias Has Attachment
TABLE Sewer Junction Object False
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname systemsubnetworkname TEXT (2000) Unknown False
regionsubnetworkname regionsubnetworkname TEXT (2000) Unknown False
sewershedsubnetworkname sewershedsubnetworkname TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
Subtypes
Code Name Description
0 Unknown
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
issubnetworkcontroller Is subnetwork controller SHORT 0 UtilityNetwork_5_IsSubnetworkController False
isconnected Is connected SHORT 2 UtilityNetwork_5_IsConnected False
subnetworkcontrollername Subnetwork controller name TEXT (2000) Unknown False
tiername Tier name SHORT 0 UtilityNetwork_5_TierName False
tierrank Tier rank LONG 0 False
terminalconfiguration Terminal path TEXT (128) Default False
globalid Global ID GUID False
cpsubnetworkname cpsubnetworkname TEXT (2000) Unknown False
supportedsubnetworkname Supported subnetwork name TEXT (2000) Unknown False
supportingsubnetworkname Supporting subnetwork name TEXT (2000) Unknown False
systemsubnetworkname systemsubnetworkname TEXT (2000) Unknown False
regionsubnetworkname regionsubnetworkname TEXT (2000) Unknown False
sewershedsubnetworkname sewershedsubnetworkname TEXT (2000) Unknown False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX

SewerManholeInspection

Class Details
DatasetType ShapeType Alias Has Attachment
TABLE Sewer Manhole Inspection True
Fields
Name Alias Type Default Value Domain Nullable Description
objectid OBJECTID OID False
inspector Inspector TEXT (50) True
inspectdt Inspection Date DATE True
inspectpurp Inspection Purpose SHORT Inspection_Manhole_Purpose True
precleaning Pre-Cleaning SHORT Inspection_Manhole_Pre-Cleaning True
precleaningdt Pre-Cleaning Date DATE True
weather Weather SHORT Inspection_Manhole_Weather True
runoff Runoff Potential SHORT Inspection_Manhole_Runoff_Potential True
inspectionstatus Inspection Status SHORT Inspection_Manhole_Status True
evidsurcharge Evidence of Surcharge SHORT Yes_No True
coverfit Cover Fit SHORT Inspection_Manhole_Cover_Fit True
covercondition Cover Condition SHORT Inspection_Manhole_Cover_Condition True
coverinsertcondition Cover Insert Condition SHORT Inspection_Manhole_Cover_Insert_Condition True
coverringcondition Cover Ring Condition SHORT Inspection_Manhole_Adjustable_Ring_Condition True
framecondition Frame Condition SHORT Inspection_Manhole_Frame_Condition True
framesealcondition Frame Seal Condition SHORT Inspection_Manhole_Frame_Seal_Condition True
framesealinflow Evidence of Frame Seal Inflow SHORT Inspection_Manhole_Frame_Seal_Inflow True
notes Notes TEXT (2000) True
assetguid Asset Guid GUID True
created_user created_user TEXT (255) True
created_date created_date DATE True
last_edited_user last_edited_user TEXT (255) True
last_edited_date last_edited_date DATE True
globalid GlobalID GUID False
creationdate CreationDate DATE True
creator Creator TEXT (128) True
editdate EditDate DATE True
editor Editor TEXT (128) True

StructureEdgeObject

Class Details
DatasetType ShapeType Alias Has Attachment
TABLE Structure Edge Object False
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Supported subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
Subtypes
Code Name Description
0 Unknown
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Supported subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX

StructureJunctionObject

Class Details
DatasetType ShapeType Alias Has Attachment
TABLE Structure Junction Object False
Fields
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
assetgroup Asset group LONG 0 False
assettype Asset type SHORT 0 False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Supported subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
Subtypes
Code Name Description
0 Unknown
Subtype: Unknown
Name Alias Type Default Value Domain Nullable Description
objectid Object ID OID False
assetgroup Asset group LONG False
assettype Asset type SHORT 0 UtilityNetwork_5_UnknownAssetType False
associationstatus Association status SHORT 0 UtilityNetwork_5_AssociationStatus False
subnetworkname Supported subnetwork name TEXT (2000) Unknown False
globalid Global ID GUID False
creationdate Creation date DATE True
creator Creator TEXT (255) True
lastupdate Last update DATE True
updatedby Updated by TEXT (255) True
Subtype: Unknown: Asset Types
Code Name Alternate Name Description terminalConfigurationName categories associationRoleType splitContent connectivityPolicy
0 Unknown Single terminal [] NONE DO_NOT_SPLIT END_VERTEX

Attribute Domains

Asset_Type_Sewer_Device_Anode

The Asset Types for the Sewer Device's Asset Group Anode
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
901 ICCP
902 Galvanic

Asset_Type_Sewer_Device_Backflow_Preventer

The asset type for the sewer device's asset group backflow preventer.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
321 Backflow Preventer

Asset_Type_Sewer_Device_Cleanout

The asset type for the sewer device's asset group cleanout.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
81 Cleanout
82 Lamp Hole
83 Terminal
85 Pig Port

Asset_Type_Sewer_Device_Connection

The asset type for the sewer device's asset group connection point.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
241 Pipe Connection

Asset_Type_Sewer_Device_Controllable_Valve

The asset type for the sewer device's asset group controllable valve
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
141 System
142 Vault
143 Elder
144 Diverting

Asset_Type_Sewer_Device_Flow_Valve

The asset type for the sewer device's asset group flow valve.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
41 Air Gap
42 Altitude
43 Check

Asset_Type_Sewer_Device_Gate

The asset type for the sewer device's asset group gate.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
101 Gate
102 Stop Log

Asset_Type_Sewer_Device_Grease_Trap

The asset type for the sewer device's asset group grease trap.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
311 Grease Trap
312 Grease Interceptor
313 Grease Recovery

Asset_Type_Sewer_Device_Groundbed

The Asset Type domain for the asset group's groundbed.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
911 Anode Bed

Asset_Type_Sewer_Device_Intake

The asset type for the sewer device's asset group intake.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
50 Candy Cane
51 Electronic Air Admission Control
52 Air Intake

Asset_Type_Sewer_Device_Manhole_Channel

The asset type for the sewer device's asset group manhole channel.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
301 Manhole Channel
302 Directional Manhole Channel

Asset_Type_Sewer_Device_Meter

The asset type for the sewer device's asset group meter.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
161 Bulk
162 Station
163 Flow

Asset_Type_Sewer_Device_Monitoring

The asset type for the sewer junction's asset group monitoring
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
181 Pressure Sensor
182 Temperature Sensor

Asset_Type_Sewer_Device_Outlet

The Asset Types for the sewer device asset group outlet.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
221 Effluent Discharge
222 Overflow

Asset_Type_Sewer_Device_Pump

The asset type for the sewer device's asset group pump.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
61 Pump
62 Pump with Grinder

Asset_Type_Sewer_Device_Rectifier

The Asset Types for the Sewer Device Asset Group Rectifier
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
941 Rectifier

Asset_Type_Sewer_Device_Relief_Valve

The asset type for the sewer device's asset group relief valve.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
121 Air & Vacuum
122 Air Release
123 Combination Air
124 Blow Off

Asset_Type_Sewer_Device_Service_Connection

The asset type for the sewer device's asset group service connection.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Commercial
2 Industrial
3 Residential

Asset_Type_Sewer_Device_Test_Point

The Asset Types for the Sewer Device's Asset Group Test Point
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
981 Test Point

Asset_Type_Sewer_Device_Treatment

The asset type for the sewer device's asset group treatment.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
201 Treatment Plant
202 Comminutor
203 Storage Tank
204 Clarifier
205 Chlorine Contact Basin
206 Aeration Basin
207 ABW Filters
208 Sludge Holding Tank
209 Recovered Water Tank

Asset_Type_Sewer_Device_Weir

The asset type for the sewer device's asset group weir.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
281 Broad-Crested
282 Combination
283 Labyrinth
284 Minimum Energy Loss
285 Sharp-Crested
286 V-Notch

Asset_Type_Sewer_Junction_Fitting

The asset type for the sewer junction's asset group fitting.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
41 Coupling
42 Cross
43 Elbow
44 End Cap
45 Expansion Joint
46 Flange
47 Plug
48 Reducer
49 Reducing Cross
50 Reducing Tee
51 Saddle
52 Screw
53 Sleeve
54 Tap
55 Tapping Saddle
56 Tee
57 Transition
58 Weld
59 Wye

Asset_Type_Sewer_Junction_Insulation_Junction

The Asset Types for the Sewer Junction's Asset Group Insulation Junction
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
941 Flange Insert

Asset_Type_Sewer_Junction_Wire_Junction

The Asset Types for the Sewer Junction's Asset Group Wire Junction
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
901 Bond Junction
902 Test Lead
903 Tracer Wire

Asset_Type_Sewer_Line_Bonding_Line

The Asset Types for the Sewer Line's Asset Group Bonding Line
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
941 Wire
942 Strap

Asset_Type_Sewer_Line_Lateral_Service

The asset type for the sewer line's lateral service.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
121 Commercial
122 Industrial
123 Residential
124 Air Release
125 Air Intake

Asset_Type_Sewer_Line_Rectifier_Cable

The Asset Types for the Sewer Line's Asset Group Rectifier Cable
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
961 Rectifier Cable

Asset_Type_Sewer_Line_Sewer_Force_Main

The asset type for the sewer line's asset group sewer force main.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
41 Force Main

Asset_Type_Sewer_Line_Sewer_Gravity_Main

The asset type for the sewer line's asset group sewer gravity main.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Collector Gravity Main
2 Interceptor Gravity Main

Asset_Type_Sewer_Line_Test_Lead_Wire

The Asset Types for the Sewer Line's Asset Group Test Lead Wire
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
901 Aqua
902 Blue
903 Forest
904 Green
905 Lavender
906 Orange
907 Pink
908 Red
909 Yellow
910 Purple

Asset_Type_Structure_Boundary_Sewer_Lift_Station_Boundary

The asset type of the structure boundary's asset group sewer lift station footprint.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
41 Lift Station

Asset_Type_Structure_Boundary_Sewer_Storm_Vault_Boundary

The asset type for the structure boundary's asset group sewer storm vault
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Baffle Chamber
4 Regulator Chamber
5 Tide Gate Chamber
16 Wet Well

Asset_Type_Structure_Boundary_Sewer_Treatment_Plant_Boundary

The asset type of the structure boundary's asset group sewer treatment plant footprint.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
81 Treatment Plant

Asset_Type_Structure_Junction_Sewer_Lift_Station

The asset type for the structure junction's asset group sewer lift station.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
81 Lift Station

Asset_Type_Structure_Junction_Sewer_Storm_Vault

The asset type for the structure junction's asset group sewer storm vault.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Baffle Chamber
4 Regulator Chamber
5 Tide Gate Chamber
9 Manhole
16 Wet Well
18 Vacuum Valve Pit
19 Grease Interceptor
20 Solids Interceptor
21 Oil Interceptor

Asset_Type_Structure_Line_Sewer_Storm_Casing

The asset type for the structure line's asset group sewer storm casing.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Casing

Backflow_Preventer_Manufacturer

Manufacturers of backflow preventers
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Ames Company Inc
2 BAVCO
3 Cla-Val
4 Conbraco Industries Inc
5 Febco Backflow Prevention
6 Danfoss Flomatic Valve
7 Mid-West Instrument
8 Watts Regulator
9 Hunter Industries
10 Wilkins/Zurn Industries
100 Other

Bonded_Insulated

Values to indicate if a feature is bonded or insulated.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
1 Bonded
2 Insulated

Boolean

True or false
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 False
1 True

Collection_Status

Collection status for sewer assets.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Not Collected
1 Collected Inspected
2 Collected Not Inspected
3 Could Not Locate
4 Do Not Collect
5 Needs Attention

Condition

Condition
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Excellent
2 Very Good
3 Good
4 Fair
5 Poor
6 Very Poor

CP_Anode_Material

List of materials used for Anodes
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
11 Carbon-Graphite
12 Cast Iron
13 Galvanic
14 Graphite
15 Magnesium
16 Magnesium (High Grade B)
17 Magnesium (High Potential)
18 Mixed Metal Oxide
19 Scrap Steel
20 Zinc

CP_Anode_Weight

List of valid anode weights
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
0.75 3/4 lb
1 1 lb
1.5 1 1/2 lb
3 3 lb
5 5 lb
9 9 lb
17 17 lb
20 20 lb
32 32 lb
48 48 lb

CP_Rectifier_Cooling_Method

List of rectifier cooling methods
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
21 Fan Cooling
22 Convection Cooling
23 System Cooling
24 Assisted Cooling

CP_Rectifier_Manufacturer

List of manufacturers for rectifiers
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
80 Goodall
81 Kerotest
82 Rockwell
83 R.W. Lyall

CP_Test_Point_Wire_Count

Number of wires on a test point
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8

CP_Traceability

Valid cathodic protection status values
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
1 Traceable
2 Not Traceable

CP_Wire_Gauge

List of valid sizes used for wire/cable gauges
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
4 4
8 8

Event_Level

The event level value of a stormwater or sewer device.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Low Event
50 Medium Event
100 High Event

Groundbed_Depth

The depth of bed.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Shallow
2 Deep

Ground_Location

Specifies the location of an asset being above or below
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Above
1 Below

Ground_Type

The type of ground cover.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
1 Asphalt
8 Asphalt Driveway
9 Asphalt Sidewalk
2 Brick
3 Concrete
10 Concrete Driveway
11 Concrete Sidewalk
4 Dirt
5 Grass
6 Gravel
7 Other
0 Unknown

Inspection_Manhole_Adjustable_Ring_Condition

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Sound
2 Cracked
3 Broken
4 Corroded/Pitted/Worn
5 Leaking
6 Poor Installation

Inspection_Manhole_Cover_Condition

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Sound
2 Cracked
3 Broken
4 Missing
5 Corroded/Pitted
6 Bolts Missing

Inspection_Manhole_Cover_Fit

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Oversized
2 Undersized
3 Rocks/Wobbles
4 Good

Inspection_Manhole_Cover_Insert_Condition

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Sound
2 Poorly Fitting
3 Cracked/Torn/Holes
4 Leaking
5 Insert Fell

Inspection_Manhole_Frame_Condition

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Sound
2 Cracked
3 Broken
4 Missing
5 Corroded/Pitted/Worn
6 Coated

Inspection_Manhole_Frame_Seal_Condition

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Sound
2 Cracked
3 Loose/Not Attached
4 Offset

Inspection_Manhole_Frame_Seal_Inflow

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 None
2 Stains
3 I&I Visible - Weeper
4 I&I Visible - Dripper
5 I&I Visible - Runner
6 I&I Visible - Gusher
7 Dye Test Positive

Inspection_Manhole_Pre-Cleaning

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Jetting
2 Heavy Cleaning
3 No Pre-Cleaning

Inspection_Manhole_Purpose

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Maintenance Required
2 I&I Investigation
3 Post-Rehab Survey
4 Pre-Rehab Survey
5 Pre-Acceptance
6 Routine Assessment
7 CIP Assessment
8 Resurvey for Any Reason

Inspection_Manhole_Runoff_Potential

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Sheeting
2 Pounding
3 Inundated

Inspection_Manhole_Status

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Surface Inspection
2 Descent Inspection
3 Remote Inspection
4 Not Found
5 Not Opened
6 Surcharged/Debris
7 Not Inspected - Traffic
8 No Access
9 Buried and Marked

Inspection_Manhole_Weather

Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Very Dry
2 Dry
3 Damp
4 Light Rain
5 Heavy Rain
6 Snow
7 Saturated

Lifecycle_Combined

Bitwise combination of lifecycle states for subnetwork management
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Proposed
2 Approved
3 Proposed and Approved
4 Under Construction
6 Approved and Under Construction
7 Proposed, Approved and Under Construction
8 In Service
12 In Service and Under Construction
14 In Service, Under Construction, and Approved
15 In Service, Under Construction, Approved and Proposed
16 To Be Retired
24 In Service and To Be Retired
32 Abandoned
64 Retired
128 Removed
256 Out of Service
512 Not Found

Lifecycle_Status

Valid lifecycle states for the assets.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Proposed
2 Approved
4 Under Construction
8 In Service
16 To Be Retired
32 Abandoned
64 Retired
128 Removed
256 Out of Service
512 Not Found

Location

Specifies the location of an asset being inside or outside
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Inside
2 Outside

Pipeline_Valve_Close_Direction

The close direction of a valve
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Counter Clockwise
1 Clockwise
2 Unknown

Pipeline_Valve_Status

The state of a device
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Closed
1 Open
2 Unknown

Sewer_ARV_Operating_Status

Operating status for ARVs
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 ARV operational
2 Corrosion on assembly/structure/ARV
3 ARV not operational
4 Structure/assembly/ARV damaged
5 Leaks from housing/assembly/ARV
6 Not Accessible
7 Not Installed

Sewer_Asset_Manager

The manager of the asset.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
1 Utilities
2 Private
3 Facilities
4 Parks
5 School Board
6 Solid Waste
7 Bee Ridge Utility
8 City of North Port
9 City of Sarasota
10 City of Venice
11 Englewood Water District
12 Pluris Southgate
13 Sproat-Kiney
14 Sylvan Lea
15 Braden River Utilities
16 Manatee County
17 Peace River Authority
100 Other

Sewer_Asset_Owner

The owner of the asset.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
1 Sarasota County
2 Private
7 Bee Ridge Utility
8 City of North Port
9 City of Sarasota
10 City of Venice
11 Englewood Water District
12 Pluris Southgate
13 Sproat-Kiney
14 Sylvan Lea
15 Braden River Utilities
16 Manatee County
17 Peace River Authority
100 Other

Sewer_Asset_Rating

Asset condition rating
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Excellent
2 Good
3 Fair
4 Poor
5 Very Poor
6 Could not locate

Sewer_Asset_Use_Type

Sewer use type
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Force Main
2 Gravity
3 Low Pressure
4 Vacuum

Sewer_Asset_Water_Type

Water type for sewer
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Sewage
2 Reclaimed
3 Effluent
4 Combined
5 Treated

Sewer_Buffer_Type

Buffer tank type
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Single Buffer
2 Double Buffer
3 Multiple Buffer

Sewer_Cleanout_Access_Diameter

The access diameter of sewer cleanouts.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
1.75 1 3/4"
2 2"
2.5 2 1/2"
3 3"
4 4"
5 5"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"

Sewer_Cleanout_Access_Type

Cleanout access type
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Lid
2 Hand
3 Cover
4 Grate
5 Door

Sewer_Cleanout_Material

The material of sewer cleanouts.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
1 Acrylonitrile Butadiene Styrene - ABS
2 Cast Iron - CAS
4 Concrete Pipe (non-reinforced) - CP
3 Copper - COP
5 Ductile Iron Pipe - DIP
6 Galvanized - GP
11 High Density Polyethylene - HDPE
7 Polyethylene - PE
8 Polypropylene - PP
9 Polyvinyle Chloride - PVC
10 Steel - SP
12 Vitrified Clay - VCP
0 Unknown - UNK
13 Non-Lead Unknown - NL

Sewer_Controllable_Valve_Diameter

The diameter of sewer controllable valves.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
1.75 1 3/4"
2 2"
2.5 2 1/2"
3 3"
4 4"
5 5"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"
30 30"
36 36"
40 40"
42 42"
48 48"
54 54"
60 60"
66 66"
72 72"
75 75"

Sewer_Controllable_Valve_Type

The types of sewer controllable valves.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Ball
2 Butterfly
3 Cone
4 Gate
5 Plug
6 Roundway
7 Wheel
8 Inserta
9 EZ Gate

Sewer_Device_Operation

Operation auto or manual
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Automatic
2 Manual

Sewer_Flow_Valve_Diameter

The diameter of a sewer flow valve.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
1.75 1 3/4"
2 2"
2.5 2 1/2"
3 3"
4 4"
5 5"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"
30 30"
36 36"
40 40"
42 42"
48 48"
54 54"
60 60"
66 66"
72 72"
75 75"

Sewer_Lateral_Diameter

The diameter of sewer laterals.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
1.75 1 3/4"
2 2"
2.5 2 1/2"
3 3"
4 4"
5 5"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"

Sewer_Lateral_Material

The material of sewer laterals.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
7 ABS Plastic - ABS
8 Cast Iron - CAS
19 Clay Tile - CT
10 Concrete - CP
9 Copper - COP
11 Ductile Iron - DIP
12 Galvanized - GP
18 High Density Polyethylene - HDPE
20 Non-Lead Unknown - NL
13 Polyethylene - PE
14 Polypropylene - PP
15 Polyvinyle Chloride - PVC
16 Steel - SP
0 Unknown - UNK
17 Vitrified Clay Pipe - VCP

Sewer_Liftstation_Pump_Type

Pump type for liftstations
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Submersible Non-Clog
2 Submersible
3 Non-Clog
4 Grinder
5 Chopper
6 Booster
7 Emergency Bypass
8 Air

Sewer_Lift_Station_Type

Sewer lift station type
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Regional Lift Station
2 Master Lift Station
3 Master Vacuum Pump Station
4 Community Lift Station
5 Neighborhood Lift Station
6 Low Flow Lift Station
7 Limited Use Lift Station
8 Booster Pump Station
9 Grinder Station
10 Septic Tank Effluent Pump
11 Eductors

Sewer_Liner_Type

Structure Liner Type
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Cementitious
2 Epoxy
3 Polymer
4 Plastic
5 Rubber
6 Cured in place
7 Fiberglass
8 Polyurethane
9 Needs Lining
10 None
11 Bitumastic
12 Geopolymere

Sewer_Line_Pressure_Type

Sewer line pressure type
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 High Pressure
2 Low Pressure
3 Vacuum

Sewer_Main_Diameter

The diameter of sewer interceptor mains.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
1.75 1 3/4"
2 2"
2.5 2 1/2"
3 3"
4 4"
5 5"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
21 21"
24 24"
27 27"
30 30"
36 36"
40 40"
42 42"
48 48"
54 54"
60 60"
66 66"
72 72"
75 75"

Sewer_Main_Liner

The lining method of sewer collector mains.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
1 Cured-In-Place Pipe - CIP
2 Fold and Form or Deform/Reform - FF
3 Formed-In-Place Liner - FP
4 Grout-In-Place Liner - GP
5 Glass Reinforced Cement - GRC
6 None - N
7 Continuous Slip Liner - SC
8 Sectional Slip Liner - SE
9 Spray Liner - SL
10 Segmented Panel - SN
11 Segmented Pipe - SP
12 Spiral Wound - SW
100 Other - ZZ
0 Unknown - UNK

Sewer_Main_Material

The material of sewer mains.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
1 Acrylonitrile Butadiene Styrene - ABS
2 Asbestos Cement - AC
3 Asphalt - ASP
4 Brick - BR
5 Cast Iron - CAS
6 Clay Tile - CT
7 Concrete Pipe (Non-Reinforced) - CP
8 Concrete Segments (Bolted) - CSB
9 Concrete Segments (Unbolted) - CSU
10 Cured in Place Pipe - CIPP
11 Ductile Iron Pipe - DIP
12 Fiberglass Reinforced Pipe - FRP
13 Galvanized Pipe - GP
14 Glass Reinforced Cement - GRC
15 High Density Polyethylene - HDPE
27 Non-Lead Unknown - NL
16 Other - OTH
17 Plastic/Steel Composite - PSC
18 Polyethylene - PE
19 Polypropylene - PP
20 Polyvinyle Chloride - PVC
21 Pre-Stressed Concrete Cylinder Pipe - PCCP
22 Reinforced Concrete Pipe - RCP
23 Reinforced Plastic Pipe (Truss Pipe) - RPM
24 Segmented Block - SB
25 Steel Pipe - SP
0 Unknown - UNK
26 Vitrified Clay Pipe - VCP

Sewer_Main_Shape

The shape of sewer collector mains.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Circular
2 Horseshoe
3 Oblong
4 Rectangular
5 Trapezoidal
6 Triangular

Sewer_Manhole_Cover_Diameter

Manhole cover diameter
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
21.75 21 3/4"
22 22"
22.25 22 1/4"
22.5 22 1/2"
22.75 22 3/4"
23.25 23 1/4"
23.5 23 1/2"
23.75 23 3/4"
24 24"
24.75 24 3/4"
25 25"
27 27"
42 42"

Sewer_Manhole_Cover_Type

Manhole cover type
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Standard W/ Lock
2 Standard W/ Ears
3 Non-District
4 Water Tight
5 Rectangular
6 Hinged
7 Standard

Sewer_Manhole_Flow_Direction

Flow direction in manhole.
Domain Details
Type Split Policy Merge Policy
TEXT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
N North
S South
E East
W West
NE Northeast
SE Southeast
NW Northwest
SW Southwest

Sewer_Pump_Discharge_Diameter

The discharge diameter of sewer pumps.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
4 4"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"
36 36"
48 48"

Sewer_Pump_Inlet_Diameter

The inlet diameter of sewer pumps.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
4 4"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"
36 36"
48 48"

Sewer_Pump_Type

The type of sewer pumps.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
11 Axial Flow
12 Centrifugal
13 Jet
14 Reciprocating
15 Rotary
16 Turbine
100 Other

Sewer_Relief_Valve_Diameter

The diameter of sewer relief valves.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
1.75 1 3/4"
2 2"
2.5 2 1/2"
3 3"
4 4"
5 5"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"
30 30"
36 36"
40 40"
42 42"
48 48"
54 54"
60 60"
66 66"
72 72"
75 75"

Sewer_Service_Meter_Type

Server meter type
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Single
2 Double
3 Multiple

Sewer_Storm_Manhole_Type

The types of sewer and storm manholes.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
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
13 Discharge Manhole
14 Inside Drop Manhole
15 Outside Drop Manhole
16 Sedimentation Manhole
17 Splitter Manhole
18 Terminal Manhole
19 Doghouse Manhole
20 Eductor Manhole

Sewer_Symbol_Rotation

The rotation of an asset's symbol
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Min Max
0 359

Sewer_Vacuum_Valve_Pit_Config

Type of Vacuum Valve Pit
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Buffer Tank
2 Type A
3 Type B
4 Type C

Sewer_Valve_Operating_Status

Operating status for asset type valves.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Operating
2 Leaking
3 Frozen
4 Spins Free
5 Not Accessible
6 Not Installed
7 Op Nut Rounded or Missing

Spatial_Confidence

Confidence values for the data
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 High
2 Medium
3 Low

Spatial_Source

Source of the data
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 As-Built
2 CAD
3 Digitized
4 GPS/GNSS
5 Field Sketch
6 Half Section Maps
7 System Master Map
8 Surveyed
9 Valve Mark-up Maps
10 TV Logs
11 SUD Billing Data

Structure_Sewer_Storm_Access_Point_Cover_Shape

The cover shape of structure sewer storm access points.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Circular
2 Horseshoe
3 Oblong
4 Rectangular
5 Trapezoidal
6 Triangular
7 Arched (with flat bottom)
8 Square
9 U-Shaped with Flat Top

Structure_Sewer_Storm_Casing_Diameter

The diameter of structure sewer storm casings.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
10 10"
14 14"
16 16"
18 18"
20 20"
30 30"

Structure_Sewer_Storm_Manhole_Barrel_Diameter

Manhole barrel diameter in feet.
Domain Details
Type Split Policy Merge Policy
DOUBLE DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
3 3'
4 4'
5 5'
6 6'
7 7'
8 8'
9 9'
10 10'

Structure_Sewer_Storm_Manhole_Frame_Material

The material of the frame of a manhole structure
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
1 ABS Plastic - ABS
5 Cast Iron - CAS
11 Ductile Iron - DIP
15 High Density Polyethylene - HDPE
17 Plastic/Steel Composite - PSC
18 Polyethylene - PE
19 Polypropylene - PP
20 Polyvinyl Chloride - PVC
23 Reinforced Plastic (Truss) - RMP
25 Steel - SP
0 Unknown - UNK
100 Other - OTH

Structure_Sewer_Storm_Manhole_Step_Material

The material of the steps of a manhole structure
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Metal
2 Plastic
3 Brick

Structure_Sewer_Storm_Manhole_Surface

The surface type of structure manholes.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Asphalt
2 Concrete Pavement
3 Concrete Collar
4 Grass/Dirt
5 Gravel
100 Other

Structure_Sewer_Storm_Manhole_Wall_Material

The material of the wall of a manhole structure
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
4 Brick - BR
7 Concrete (Non-Reinforced) - CP
22 Concrete (Reinforced) - RCP
8 Concrete Segments (Bolted) - CSB
9 Concrete Segments (Unbolted) - CSU
12 Fiberglass - FG
15 High Density Polyethylene - HDPE
18 Polyethylene - PE
19 Polypropylene - PP
20 Polyvinyl Chloride - PVC
21 Pre-Stressed Concrete Cylinder Pipe - PCCP
25 Steel - SP
0 Unknown - UNK

Structure_Sewer_Storm_Vault_Manhole_Cone

The cone type of structure manholes.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Straight
2 Offset

Structure_Sewer_Storm_Vault_Manhole_Location

The location of structure manholes.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Main Highway
2 Light Highway
3 Easement/Right of Way
4 Woods
5 Sidewalk
6 Parking Lot
7 Alley
8 Ditch
9 Building
10 Creek
11 Railway
12 Airport
13 Yard

Subnetwork_Barrier

Domain used for network attribute subnetwork barrier
Domain Details
Type Split Policy Merge Policy
SHORT DEFAULT DEFAULT
Domain Values
Code Value Alternate Name Description
1 System
2 Region
3 Basin

UtilityNetwork_5_AssociationStatus

Indicates how the feature participates in associations.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 None
1 Container
2 Structure
4 Content
5 Content and Container
6 Content and Structure
8 Attachment
9 Attachment and Container
10 Attachment and Structure
12 Attachment and Content
13 Attachment and Content and Container
14 Attachment and Content and Structure
16 Visible Content
17 Visible Content and Container
18 Visible Content and Structure
24 Visible Content and Attachment
25 Visible Content and Attachment and Container
26 Visible Content and Attachment and Structure
32 Connectivity
33 Connectivity and Container
34 Connectivity and Structure
36 Connectivity and Content
37 Connectivity and Content and Container
38 Connectivity and Content and Structure
40 Connectivity and Attachment
41 Connectivity and Attachment and Container
42 Connectivity and Attachment and Structure
44 Connectivity and Attachment and Content
45 Connectivity and Attachment and Content and Container
46 Connectivity and Attachment and Content and Structure
48 Connectivity and Visible Content
49 Connectivity and Visible Content and Container
50 Connectivity and Visible Content and Structure
56 Connectivity and Visible Content and Attachment
57 Connectivity and Visible Content and Attachment and Container
58 Connectivity and Visible Content and Attachment and Structure

UtilityNetwork_5_FeatureSourceID

The source feature class name in the utility network.
Domain Details
Type Split Policy Merge Policy
SHORT DEFAULT DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Association
2 System Junction
3 System Junction Object
4 Structure Junction
5 Structure Line
6 Structure Boundary
7 Structure Junction Object
8 Structure Edge Object
9 Sewer Device
10 Sewer Line
11 Sewer Assembly
12 Sewer Junction
13 Sewer Subnet Line
14 Sewer Junction Object
15 Sewer Edge Object

UtilityNetwork_5_IsConnected

Indicates if the feature is connected to a subnetwork controller.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 False
1 True
2 Unknown

UtilityNetwork_5_IsContentVisible

Indicates if the content or attachment association is visible for containment associations.
Domain Details
Type Split Policy Merge Policy
SHORT DEFAULT DEFAULT
Domain Values
Code Value Alternate Name Description
0 False
1 True

UtilityNetwork_5_IsDeleted

Indicates if a subnetwork has been marked for deletion.
Domain Details
Type Split Policy Merge Policy
SHORT DEFAULT DEFAULT
Domain Values
Code Value Alternate Name Description
0 False
1 True

UtilityNetwork_5_IsDirty

Indicates if a subnetwork is dirty.
Domain Details
Type Split Policy Merge Policy
SHORT DEFAULT DEFAULT
Domain Values
Code Value Alternate Name Description
0 False
1 True
2 Invalid

UtilityNetwork_5_IsSubnetworkController

Indicates if a device feature is a subnetwork controller.
Domain Details
Type Split Policy Merge Policy
SHORT DEFAULT DEFAULT
Domain Values
Code Value Alternate Name Description
0 False
1 True

UtilityNetwork_5_TerminalNames

The terminal names in the utility network.
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 None
1 Single Terminal
2 High Pressure In
3 Low Pressure Out
4 Low Pressure In
5 High Pressure Out
6 Inlet Port
7 Outlet Port
8 Port One
9 Port Two
10 Terminal One
11 Terminal Two
12 Terminal Three
13 Terminal Four
14 Terminal Five
15 Terminal Six
16 Terminal Seven
17 Terminal Eight
18 Upstream
19 Upstream 2
20 Downstream
21 Downstream 2
22 Port One
23 Port Two
24 Port Three
25 Port Four

UtilityNetwork_5_TierName

The tier names in the utility network.
Domain Details
Type Split Policy Merge Policy
SHORT DEFAULT DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Sewer Cathodic Protection
2 Sewer Collection System
3 Sewer Collection Region
4 Sewer Collection Basin

UtilityNetwork_5_TierTopologyType

The type of topology for each tier.
Domain Details
Type Split Policy Merge Policy
SHORT DEFAULT DEFAULT
Domain Values
Code Value Alternate Name Description
1 Radial
2 Mesh

UtilityNetwork_5_UnknownAssetType

The AssetType domain for the Unknown AssetGroup.
Domain Details
Type Split Policy Merge Policy
SHORT DEFAULT DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown

Yes_No

A yes/no indicator
Domain Details
Type Split Policy Merge Policy
SHORT DUPLICATE DEFAULT
Domain Values
Code Value Alternate Name Description
0 Unknown
1 Yes
2 No