Workspace Properties

Key Value
Name WaterDistributionSystem
Workspace Type Remote Database
Workspace Factory Feature Service DB
Geodatabase Release
Date Exported 2025-01-31 18:52:35
Path

Datasets

Name Dataset Type Feature Dataset Dataset ID
L501009Flushing_and_Blow_Off FeatureClass -1
L505003Backflow FeatureClass -1
L501004Sample_Station FeatureClass -1
L501007Fire_Hydrant FeatureClass -1
L501012Service_Connection FeatureClass -1
L501010Service_Meter FeatureClass -1
L501013System_Meter FeatureClass -1
L501006Service_Valve FeatureClass -1
L501001Flow_Valve FeatureClass -1
L501003Pressure_Valve FeatureClass -1
L501002System_Valve FeatureClass -1
L510020Fitting FeatureClass -1
L501020Storage FeatureClass -1
L501005Pump FeatureClass -1
L501016Interconnect FeatureClass -1
L501017Treatment_Plant FeatureClass -1
L501018Well FeatureClass -1
L515002Service FeatureClass -1
L515001Water_Main FeatureClass -1
L905001Pipe_Casing FeatureClass -1
L910505Water_Pump_Station_Boundary FeatureClass -1
L910503Water_Storage_Boundary FeatureClass -1
L910507Water_Supply_Boundary FeatureClass -1
L920Service_Territory FeatureClass -1
L5010100Meter_Relate Table -1
L5010070Hydrant_Maintenance_Inspection Table -1
L5010020System_Valve_Inspection Table -1
L5050030Backflow_Inspection Table -1
L5050040Water_Sample Table -1
L5050041Hydrant_Relate Table -1

L501009Flushing_and_Blow_Off

Properties

Key Value
Name L501009Flushing_and_Blow_Off
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Flushing and Blow Off
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_Flushing_and_Blow_Off 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique ID assigned to the asset
name Name String True 0 0 64 True False Name of the asset
manufacturer Manufacturer Long Integer True 0 0 0 True False Manufacturer of the asset
model Model Long Integer True 0 0 0 True False Model number or name of the asset
installdate Install Date Date True 1 0 8 True False Date when the asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the asset
notes Notes String True 0 0 2000 True False Additional notes or comments about the asset
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance performed on the asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the asset was retired or decommissioned
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle of the symbol representing the asset
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the asset
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when the GNSS fix was obtained
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the asset record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the asset record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the asset record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the asset record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the asset's location

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D857F3DCA54 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_FLUSHING_AND_BLOW_OFF_Shape_sidx False True Shape

L505003Backflow

Properties

Key Value
Name L505003Backflow
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Backflow
OID Field objectid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R5L505003BackflowL5050030Backflow_Inspection

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
objectid objectid OID Index False 0 0 0 False True Unique identifier for each record
assettype Asset type Short Integer False Asset_Type_Water_Assembly_Backflow 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique ID assigned to the asset
installdate Install Date Date True 1 0 8 True False Date when the asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current status of the asset in its lifecycle
notes Notes String True 0 0 2000 True False Additional information about the asset
locked Locked Short Integer True Yes_No 0 0 0 0 True False Indicates if the asset is locked or not
manufacturer Manufacturer Long Integer True 0 0 0 True False Manufacturer of the asset
model Model Long Integer True 0 0 0 True False Model number of the asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the asset was retired
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 0 True False Rotation of the asset symbol on the map
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the asset
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the asset record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the asset record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the asset record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the asset record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the asset location

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__5242E632274E6978 True True objectid
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_BACKFLOW_Shape_sidx False True Shape

L501004Sample_Station

Properties

Key Value
Name L501004Sample_Station
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Sample Station
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details A featuer layer view with full editing capabilities.

RelationshipClassNames

Name Role Related To Cardinality Type
R33L501004Sample_StationL5050040Water_Sample

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
stationlocation Sample Station Location String True 0 0 255 True False Represents the location of the sample station
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each object in the layer
assetid Sample Station ID String True 0 0 64 True False Unique identifier for the sample station asset
installdate Install Date Date True 1 0 8 True False Date when the sample station was installed
lifecyclestatus Lifecycle Status Short Integer True Lifecycle 8 0 0 0 True False Status of the sample station in its lifecycle
notes Notes String True 0 0 2000 True False Additional information or comments about the sample station
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance performed on the sample station
inservicedate In-Service Date Date True 1 0 8 True False Date when the sample station was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the sample station was retired or decommissioned
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the sample station
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the sample station
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the sample station
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation of the symbol representing the sample station on the map
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the sample station
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN_1 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when the GNSS fix was obtained
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the sample station record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the sample station record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the sample station record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the sample station record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the sample station location

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D8551E91B78 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_SAMPLE_STATION_Shape_sidx False True Shape

L501007Fire_Hydrant

Properties

Key Value
Name L501007Fire_Hydrant
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Fire Hydrant
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R1L501007Fire_HydrantL5050041Hydrant_Relate
R15L501007Fire_HydrantL5010070Hydrant_Maintenance_Inspection

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_Fire_Hydrant 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique ID assigned to the asset
diameter Diameter Double True Water_Hydrant_Service_Diameter 0 0 0 0 True False Diameter of the fire hydrant
secondarydiameter Nozzle Diameter Double True Water_Hydrant_Nozzle_Diameter 0 0 0 0 True False Diameter of the nozzle of the fire hydrant
manufacturer Manufacturer Short Integer True Water_Fire_Hydrant_Manufacturer 0 0 0 True False Manufacturer of the fire hydrant
model Model Long Integer True 0 0 0 True False Model number or name of the fire hydrant
installdate Install Date Date True 1 0 8 True False Date when the fire hydrant was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the fire hydrant
inservicedate In-Service Date Date True 1 0 8 True False Date when the fire hydrant was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the fire hydrant was retired
notes Notes String True 0 0 2000 True False Additional notes or comments about the fire hydrant
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance performed on the fire hydrant
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the fire hydrant
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the fire hydrant
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the fire hydrant
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation of the symbol representing the fire hydrant on the map
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the fire hydrant
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when the GNSS fix was obtained
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
assignmenttype Assignment Type Long Integer True Fire Hydrant_assignmenttype_efa6b5d1-cd1e-4fe2-8746-628b3c7eaf2c 0 0 0 True False Type of assignment associated with the fire hydrant
assignmentdue Assignment Due Date True 1 0 8 True False Due date for the assignment
assignedon Assigned On Date True 1 0 8 True False Date when the assignment was made
station Assigned Station String True 0 0 255 True False Fire station assigned to the fire hydrant
shift Assigned Shift String True 0 0 255 True False Shift assigned to the fire hydrant
adoptionstatus Adoption Status String True adoptionstatus 0 0 255 True False Status of the fire hydrant in the adoption program
nickname Nickname String True 0 0 255 True False Nickname of the fire hydrant
publicview Public View String True Fire Hydrant_publicview_319bb766-c618-4e85-8d04-d2f58c09ef8e 0 0 255 True False Indicates whether the fire hydrant is visible to the public
adoptedby Adopted By String True 0 0 255 True False Entity that has adopted the fire hydrant
adoptedon Adopted On Date True 1 0 8 True False Date when the fire hydrant was adopted
created_user Creator String Creator;Index True 0 0 255 False True User who created the fire hydrant record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the fire hydrant record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the fire hydrant record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the fire hydrant record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the fire hydrant location

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85CCB55F39 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_FIRE_HYDRANT_Shape_sidx False True Shape

L501012Service_Connection

Properties

Key Value
Name L501012Service_Connection
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Service Connection
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_Service_Connection 0 0 0 0 True False Categorizes the type of water distribution asset
assetid Asset ID String True 0 0 64 True False Unique identifier for the water distribution asset
accountid Account ID String True 0 0 50 True False Identifier for the account associated with the asset
additionaldetails Critical Short Integer True Yes_No 2 0 0 0 True False Indicates if the service connection is critical
additionaldevice Metered Short Integer True Yes_No 2 0 0 0 True False Indicates if the asset is metered
installdate Install Date Date True 1 0 8 True False Date when the asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the asset was retired
notes Notes String True 0 0 2000 True False Additional notes or comments about the asset
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance on the asset
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the spatial data for the asset
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle for the asset symbol
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the asset
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the asset record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the asset record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the asset record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the asset record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the asset location

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D857E9A9829 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_SERVICE_CONNECTION_Shape_sidx False True Shape

L501010Service_Meter

Properties

Key Value
Name L501010Service_Meter
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Service Meter
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R17L501010Service_MeterL5010100Meter_Relate

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each record
assettype Asset type Short Integer False Asset_Type_Water_Device_Service_Meter 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique identifier for the asset
accountid Account ID String True 0 0 50 True False Identifier for the account associated with the asset
diameter Diameter Double True Water_Meter_Diameter 0 0 0 0 True False Diameter of the service meter
manufacturer Manufacturer Long Integer True 0 0 0 True False Manufacturer of the service meter
model Model Long Integer True 0 0 0 True False Model number of the service meter
installdate Install Date Date True 1 0 8 True False Date when the service meter was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the service meter
inservicedate In-Service Date Date True 1 0 8 True False Date when the service meter was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the service meter was retired
notes Notes String True 0 0 2000 True False Additional notes about the service meter
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance on the service meter
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the service meter
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity that maintains the service meter
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the service meter
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation of the symbol representing the service meter
globalid Global ID Global ID Index False 0 0 38 False True Global identifier for the service meter
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the service meter

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D851C04C41E True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_SERVICE_METER_Shape_sidx False True Shape

L501013System_Meter

Properties

Key Value
Name L501013System_Meter
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias System Meter
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R4L501013System_MeterL5010100Meter_Relate

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_System_Meter 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique identifier for the water distribution asset
accountid Account ID String True 0 0 50 True False Account associated with the water distribution asset
diameter Diameter Double True Water_Meter_Diameter 0 0 0 0 True False Diameter of the water meter
manufacturer Manufacturer Long Integer True 0 0 0 True False Manufacturer of the water meter
model Model Long Integer True 0 0 0 True False Model number of the water meter
installdate Install Date Date True 1 0 8 True False Date when the water meter was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water meter
notes Notes String True 0 0 2000 True False Additional notes about the water meter
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance on the water meter
inservicedate In-Service Date Date True 1 0 8 True False Date when the water meter was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water meter was retired
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the water meter
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity that maintains the water meter
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water meter
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level of the spatial data for the water meter
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation of the symbol representing the water meter
globalid Global ID Global ID Index False 0 0 38 False True Global identifier for the water meter
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the water meter record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the water meter record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the water meter record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the water meter record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the water meter

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85FE6A044F True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_SYSTEM_METER_Shape_sidx False True Shape

L501006Service_Valve

Properties

Key Value
Name L501006Service_Valve
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Service Valve
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_Service_Valve 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique ID assigned to the water distribution asset
diameter Diameter Double True Water_Diameter 0 0 0 0 True False Diameter of the water distribution asset
manufacturer Manufacturer Long Integer True 0 0 0 True False Manufacturer of the water distribution asset
model Model Long Integer True 0 0 0 True False Model number or name of the water distribution asset
designtype Valve Type Short Integer True Water_Valve_Type 0 0 0 0 True False Type of valve used in the water distribution asset
presentstatus Valve Status Short Integer True Pipeline_Valve_Status 1 0 0 0 True False Current operational status of the valve
additionaldetails Clockwise to Close Short Integer True Pipeline_Valve_Close_Direction 0 0 0 True False Direction to close the valve
designinfo Turns to Close Double True 0 0 0 True False Number of turns required to close the valve
operable Operable Short Integer False Boolean 1 0 0 0 True False Indicates if the valve is operable
operator Postindicator Valve Short Integer True Yes_No 0 0 0 True False Indicates if the valve is a postindicator valve
name Name String True 0 0 64 True False Name of the water distribution asset
installdate Install Date Date True 1 0 8 True False Date when the water distribution asset was installed
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the water distribution asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the water distribution asset
notes Notes String True 0 0 2000 True False Additional notes or comments about the water distribution asset
lastmaint Last Maintenance Date True 1 0 8 True False Date when the water distribution asset was last maintained
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water distribution asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the water distribution asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water distribution asset was retired
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water distribution asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle for the symbol representing the water distribution asset
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for each feature in the layer
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the feature
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the feature was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the feature
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the feature was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the water distribution asset

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85ABC3C459 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_SERVICE_VALVE_Shape_sidx False True Shape

L501001Flow_Valve

Properties

Key Value
Name L501001Flow_Valve
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Flow Valve
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_Flow_Valve 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique ID assigned to the water distribution asset
diameter Diameter Double True Water_Diameter 0 0 0 0 True False Diameter of the water distribution asset
installdate Install Date Date True 1 0 8 True False Date when the water distribution asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water distribution asset
notes Notes String True 0 0 2000 True False Additional notes or comments about the water distribution asset
manufacturer Manufacturer Long Integer True 0 0 0 True False Manufacturer of the water distribution asset
model Model Long Integer True 0 0 0 True False Model number or name of the water distribution asset
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance performed on the water distribution asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the water distribution asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water distribution asset was retired or decommissioned
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the water distribution asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the water distribution asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water distribution asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle of the symbol representing the water distribution asset
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for each feature in the layer
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the feature
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the feature was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the feature
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the feature was last edited
Shape Geometry Index True 0 0 0 True True Geometry of the feature

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D859B64B948 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_FLOW_VALVE_Shape_sidx False True Shape

L501003Pressure_Valve

Properties

Key Value
Name L501003Pressure_Valve
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Pressure Valve
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_Pressure_Valve 0 0 0 0 True False Type of the pressure valve
assetid Asset ID String True 0 0 64 True False Unique identifier for the asset
diameter Diameter Double True Water_Diameter 0 0 0 0 True False Diameter of the pressure valve
pressure Pressure Double True 0 0 0 True False Pressure level of the valve
manufacturer Manufacturer Long Integer True 0 0 0 True False Manufacturer of the pressure valve
model Model Long Integer True 0 0 0 True False Model number of the pressure valve
installdate Install Date Date True 1 0 8 True False Date when the pressure valve was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the pressure valve
notes Notes String True 0 0 2000 True False Additional notes about the pressure valve
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance on the pressure valve
inservicedate In-Service Date Date True 1 0 8 True False Date when the pressure valve was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the pressure valve was retired
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the pressure valve
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity that maintains the pressure valve
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the pressure valve
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation of the symbol representing the pressure valve
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the pressure valve
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the pressure valve record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the pressure valve record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the pressure valve record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the pressure valve record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the pressure valve

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D856408CE91 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_PRESSURE_VALVE_Shape_sidx False True Shape

L501002System_Valve

Properties

Key Value
Name L501002System_Valve
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias System Valve
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R19L501002System_ValveL5010020System_Valve_Inspection

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_System_Valve 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique ID assigned to the water distribution asset
diameter Diameter Double True Water_Diameter 0 0 0 0 True False Diameter of the water distribution asset
manufacturer Manufacturer Long Integer True 0 0 0 True False Manufacturer of the water distribution asset
model Model Long Integer True 0 0 0 True False Model number or name of the water distribution asset
designtype Valve Type Short Integer True Water_Valve_Type 0 0 0 0 True False Type of valve design
installdate Install Date Date True 1 0 8 True False Date when the water distribution asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water distribution asset
presentstatus Valve Status Short Integer True Pipeline_Valve_Status 1 0 0 0 True False Current operational status of the valve
inservicedate In-Service Date Date True 1 0 8 True False Date when the water distribution asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water distribution asset was retired
additionaldetails Clockwise to Close Short Integer True Pipeline_Valve_Close_Direction 0 0 0 True False Direction to close the valve
designinfo Turns to Close Double True 0 0 0 True False Number of turns required to close the valve
operable Operable Short Integer False Boolean 1 0 0 0 True False Indicates if the valve is operable
name Name String True 0 0 64 True False Name of the water distribution asset
additionaldevice Has Bypass Short Integer True Yes_No 0 0 0 0 True False Indicates if the valve has a bypass
notes Notes String True 0 0 2000 True False Additional notes or comments about the water distribution asset
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance performed on the water distribution asset
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the water distribution asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the water distribution asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water distribution asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle for the symbol representing the water distribution asset
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for each feature in the layer
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the feature
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the feature was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the feature
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the feature was last edited
Shape Geometry Index True 0 0 0 True True Geometry of the water distribution asset

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D852937378A True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_SYSTEM_VALVE_Shape_sidx False True Shape

L510020Fitting

Properties

Key Value
Name L510020Fitting
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Fitting
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Junction_Fitting 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique ID assigned to the water distribution asset
installdate Install Date Date True 1 0 8 True False Date when the asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current status of the asset in its lifecycle
notes Notes String True 0 0 2000 True False Additional information or comments about the asset
diameter Diameter Double True Water_Fitting_Diameter 0 0 0 0 True False Diameter of the water distribution asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the asset was retired from service
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle for the symbol representing the asset
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the asset
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the asset record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the asset record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the asset record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the asset record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the asset's location

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85009DB7EF True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_FITTING_Shape_sidx False True Shape

L501020Storage

Properties

Key Value
Name L501020Storage
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Storage
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_Storage 0 0 0 0 True False Categorizes the type of water storage device
assetid Asset ID String True 0 0 64 True False Unique identifier for each water storage asset
diameter Height Double True 0 0 0 True False Height of the water storage asset
secondarydiameter Width Double True 0 0 0 True False Width of the water storage asset
pressure Volume Double True 0 0 0 True False Volume of the water storage asset
installdate Install Date Date True 1 0 8 True False Date when the water storage asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water storage asset
notes Notes String True 0 0 2000 True False Additional information about the water storage asset
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance performed on the water storage asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the water storage asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water storage asset was retired
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the water storage asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the water storage asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water storage asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation of the symbol representing the water storage asset
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for each feature in the layer
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the feature
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the feature was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the feature
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the feature was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the water storage asset

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D855C82F7C0 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_STORAGE_Shape_sidx False True Shape

L501005Pump

Properties

Key Value
Name L501005Pump
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Pump
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Device_Pump 0 0 0 0 True False Type of the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique ID assigned to the water distribution asset
diameter Inlet Diameter Double True Water_Pump_Diameter 0 0 0 0 True False Inlet diameter of the pump
secondarydiameter Outlet Diameter Double True Water_Pump_Diameter 0 0 0 0 True False Outlet diameter of the pump
pressure Rated Pressure Double True 0 0 0 True False Rated pressure of the pump
manufacturer Manufacturer Long Integer True 0 0 0 True False Manufacturer of the pump
model Model Long Integer True 0 0 0 True False Model number or name of the pump
designtype Pump Type Short Integer True Water_Pump_Type 0 0 0 0 True False Type of pump design
designinfo Rated Flow Double True 0 0 0 True False Rated flow of the pump
operable Operable Short Integer False Boolean 1 0 0 0 True False Indicates if the pump is operable
name Name String True 0 0 64 True False Name of the pump
installdate Install Date Date True 1 0 8 True False Date when the pump was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the pump
notes Notes String True 0 0 2000 True False Additional notes or comments about the pump
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance performed on the pump
inservicedate In-Service Date Date True 1 0 8 True False Date when the pump was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the pump was retired
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the pump
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the pump
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the pump
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the spatial data for the pump
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle for the symbol representing the pump
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the pump
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the pump record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the pump record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the pump record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the pump record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the pump's location

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85C82C0A0C True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_PUMP_Shape_sidx False True Shape

L501016Interconnect

Properties

Key Value
Name L501016Interconnect
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Interconnect
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details A featuer layer view with full editing capabilities.

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
permittedflow Permitted Flow Double True 0 0 0 True False Indicates the maximum flow allowed for the water distribution asset
availableflow Available Flow Double True 0 0 0 True False Specifies the current flow available in the water distribution asset
emergency Emergency Only Short Integer True 5_Yes_No 0 0 0 True False Determines whether the asset is for emergency use only
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Connection Type Short Integer True Water_Interconnect_Connection_Type 0 0 0 True False Specifies the type of connection for the water distribution asset
assetid Asset ID String True 0 0 64 True False Unique identifier for the water distribution asset
name Name String True 0 0 64 True False Name of the water distribution asset
installdate Install Date Date True 1 0 8 True False Date when the water distribution asset was installed
lifecyclestatus Lifecycle Status Short Integer True Lifecycle 8 0 0 0 True False Current lifecycle status of the water distribution asset
notes Notes String True 0 0 2000 True False Additional information or comments about the water distribution asset
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance performed on the water distribution asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the water distribution asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water distribution asset was retired from service
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the water distribution asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the water distribution asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water distribution asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle for the symbol representing the water distribution asset
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the water distribution asset
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN_1 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the asset record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the asset record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the asset record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the asset record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the water distribution asset

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D8558DA0FB8 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_INTERCONNECT_Shape_sidx False True Shape

L501017Treatment_Plant

Properties

Key Value
Name L501017Treatment_Plant
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Treatment Plant
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details A featuer layer view with full editing capabilities.

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
permittedcapacity Permitted Capacity Double True 0 0 0 True False Indicates the maximum amount of water that the treatment plant is legally allowed to process
ratedcapacity Rated Capacity Double True 0 0 0 True False Specifies the maximum amount of water that the treatment plant can process under optimal conditions
averagedailyflow Average Daily Flow Double True 0 0 0 True False Represents the average amount of water processed by the treatment plant each day
filtrationtype Filtration Type Short Integer True Water_Supply_Filtration_Type 0 0 0 True False Specifies the type of filtration system used by the treatment plant
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each record in the dataset
assettype Treatment Plant Type Short Integer True Water_Treatment_Plant_Type 0 0 0 True False Indicates the type of water source the treatment plant is designed to process
assetid Asset ID String True 0 0 64 True False Unique identifier for each asset in the dataset
name Name String True 0 0 64 True False Name of the treatment plant
installdate Install Date Date True 1 0 8 True False Date when the treatment plant was installed
lifecyclestatus Lifecycle Status Short Integer True Lifecycle 8 0 0 0 True False Current status of the treatment plant in its lifecycle
notes Notes String True 0 0 2000 True False Additional information or comments about the treatment plant
lastmaint Last Maintenance Date True 1 0 8 True False Date when the treatment plant was last maintained
inservicedate In-Service Date Date True 1 0 8 True False Date when the treatment plant was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the treatment plant was retired from service
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the treatment plant
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the treatment plant
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the treatment plant
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the accuracy of the spatial data
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle for the symbol representing the treatment plant on a map
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for each record in the dataset
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN_1 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the record for the treatment plant
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record for the treatment plant was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the record for the treatment plant
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record for the treatment plant was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the treatment plant

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85D8E3FED0 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_TREATMENT_PLANT_Shape_sidx False True Shape

L501018Well

Properties

Key Value
Name L501018Well
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Point
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Well
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details A featuer layer view with full editing capabilities.

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
filtrationtype Filtration Type Short Integer True Water_Supply_Filtration_Type 0 0 0 True False Indicates the type of filtration used in the water supply
boredepth Bore Depth Double True 0 0 0 True False Specifies the depth of the borehole
aquiferdepth Aquifer Depth Double True 0 0 0 True False Specifies the depth of the aquifer
permittedflow Permitted Flow Double True 0 0 0 True False Indicates the flow rate permitted for the well
availableflow Available Flow Double True 0 0 0 True False Indicates the flow rate available from the well
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each object in the layer
assettype Asset type Short Integer True Asset_Type_Water_Device_Supply_WellType 0 0 0 0 True False Specifies the type of the water supply asset
assetid Asset ID String True 0 0 64 True False Unique identifier for each asset in the layer
name Name String True 0 0 64 True False Name of the water supply asset
installdate Install Date Date True 1 0 8 True False Date when the asset was installed
lifecyclestatus Lifecycle Status Short Integer True Lifecycle 8 0 0 0 True False Current lifecycle status of the asset
notes Notes String True 0 0 2000 True False Additional notes or comments about the asset
lastmaint Last Maintenance Date True 1 0 8 True False Date of the last maintenance performed on the asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the asset was retired from service
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the spatial data for the asset
symbolrotation Symbol Rotation Short Integer True Symbol_Rotation 0 0 0 True False Rotation angle for the symbol representing the asset
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for each object in the layer
ESRIGNSS_POSITIONSOURCETYPE Position source type Short Integer True ESRI_POSITIONSOURCETYPE_DOMAIN_1 0 0 0 True False Type of position source used to capture the asset location
ESRIGNSS_RECEIVER Receiver Name String True 0 0 50 True False Name of the receiver used to capture the asset's location
ESRIGNSS_LATITUDE Latitude Double True 0 0 0 True False Latitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_LONGITUDE Longitude Double True 0 0 0 True False Longitude position received from the GPS receiver before applying data transformations in the location profile
ESRIGNSS_ALTITUDE Altitude Double True 0 0 0 True False Ellipsoidal height received from the GPS receiver (not orthometric height, as used for z-values)
ESRIGNSS_H_RMS Horizontal Accuracy (m) Double True 0 0 0 True False Horizontal accuracy of the asset's location root mean square
ESRIGNSS_V_RMS Vertical Accuracy (m) Double True 0 0 0 True False Vertical accuracy of the asset's location root mean square
ESRIGNSS_FIXDATETIME Fix Time Date True 1 0 8 True False Time when the asset location was obtained
ESRIGNSS_FIXTYPE Fix Type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Type of fix used to capture the asset's location
ESRIGNSS_CORRECTIONAGE Correction Age Double True 0 0 0 True False Age of the correction used to capture the asset's location
ESRIGNSS_STATIONID Station ID Short Integer True ESRI_STATION_ID_DOMAIN 0 0 0 True False ID of the station used to capture the asset's location
ESRIGNSS_NUMSATS Number of Satellites Short Integer True ESRI_NUM_SATS_DOMAIN 0 0 0 True False Number of satellites used to capture the asset's location
ESRIGNSS_PDOP PDOP Double True 0 0 0 True False Position Dilution of Precision for the asset's location
ESRIGNSS_HDOP HDOP Double True 0 0 0 True False Horizontal Dilution of Precision for the asset's location
ESRIGNSS_VDOP VDOP Double True 0 0 0 True False Vertical Dilution of Precision for the asset's location
ESRIGNSS_DIRECTION Direction of travel (°) Double True 0 0 0 True False Direction of travel when the asset's location was captured
ESRIGNSS_SPEED Speed (km/h) Double True 0 0 0 True False Speed of travel when the asset's location was captured
ESRISNSR_AZIMUTH Compass reading (°) Double True 0 0 0 True False Compass reading when capturing the asset location
ESRIGNSS_AVG_H_RMS Average Horizontal Accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
ESRIGNSS_AVG_V_RMS Average Vertical Accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
ESRIGNSS_AVG_POSITIONS Averaged Positions Short Integer True 0 0 0 True False Number of positions averaged to capture the asset's location
ESRIGNSS_H_STDDEV Standard Deviation (m) Double True 0 0 0 True False Standard deviation of the horizontal accuracy
created_user Creator String Creator;Index True 0 0 255 False True User who created the asset record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the asset record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the asset record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the asset record was last edited
Shape Geometry Index True 0 0 0 True True Geometric representation of the asset

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D856C26F09A True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_WELL_Shape_sidx False True Shape

L515002Service

Properties

Key Value
Name L515002Service
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Polyline
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Service
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Line_Service 0 0 0 0 True False Categorizes the type of water distribution asset
assetid Asset ID String True 0 0 64 True False Unique identifier for the water distribution asset
diameter Diameter Double True Water_Service_Diameter 0 0 0 True False Specifies the diameter of the water distribution asset
material Material Short Integer True Water_Service_Material 0 0 0 0 True False Indicates the material composition of the water distribution asset
designtype Water Type Short Integer True Water_Type 1 0 0 0 True False Specifies the type of water the asset is designed to distribute
installdate Install Date Date True 1 0 8 True False Date when the water distribution asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water distribution asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the water distribution asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water distribution asset was retired
notes Notes String True 0 0 2000 True False Additional information or comments about the water distribution asset
measuredlength Measured Length Double True 0 0 0 True False The measured length of the water distribution asset
adddetails Tracer Wire Short Integer True Yes_No 0 0 0 0 True False Indicates if the service line has a tracer wire
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the water distribution asset
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the water distribution asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water distribution asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the spatial data for the water distribution asset
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the water distribution asset
esrignss_avg_h_rms Average horizontal accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
esrignss_avg_v_rms Average vertical accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
esrignss_worst_h_rms Worst horizontal accuracy (m) Double True 0 0 0 True False Worst horizontal accuracy of the GNSS data
esrignss_worst_v_rms Worst vertical accuracy (m) Double True 0 0 0 True False Worst vertical accuracy of the GNSS data
esrignss_worst_fixtype Worst fix type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Worst fix type of the GNSS data
esrignss_manual_locations Number of manual locations Long Integer True 0 0 0 True False Number of manual locations recorded for the water distribution asset
created_user Creator String Creator;Index True 0 0 255 False True User who created the record for the water distribution asset
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record for the water distribution asset was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the record for the water distribution asset
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record for the water distribution asset was last edited
Shape__Length Shape__Length Double Index;Length True 0 0 0 False True Length of the shape representing the water distribution asset
Shape Geometry Index True 0 0 0 True True Geometric representation of the water distribution asset

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D851F0C1BAD True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
Shape__Length_Index False True Shape__Length
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_SERVICE_Shape_sidx False True Shape

L515001Water_Main

Properties

Key Value
Name L515001Water_Main
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Polyline
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Water Main
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Water_Line_Water_Main 0 0 0 0 True False Categorizes the type of water main asset
assetid Asset ID String True 0 0 64 True False Unique identifier for the water main asset
diameter Diameter Double True Water_Main_Diameter 0 0 0 0 True False Specifies the diameter of the water main
material Material Short Integer True Water_Main_Material 0 0 0 0 True False Indicates the material used to construct the water main
designtype Water Type Short Integer True Water_Type 1 0 0 0 True False Specifies the type of water the main is designed to carry
installdate Install Date Date True 1 0 8 True False Date when the water main was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water main
notes Notes String True 0 0 2000 True False Additional information or comments about the water main
measuredlength Measured Length Double True 0 0 0 True False The measured length of the water main
adddetails Tracer Wire Short Integer True Yes_No 0 0 0 0 True False Indicates if the main has a tracer wire
inservicedate In-Service Date Date True 1 0 8 True False Date when the water main was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water main was retired
ownedby Owned By Short Integer True Asset_Owner 1 0 0 0 True False Entity that owns the water main
maintby Maintained By Short Integer True Asset_Manager 1 0 0 0 True False Entity responsible for maintaining the water main
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water main
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the accuracy of the spatial data
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the water main
esrignss_avg_h_rms Average horizontal accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
esrignss_avg_v_rms Average vertical accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
esrignss_worst_h_rms Worst horizontal accuracy (m) Double True 0 0 0 True False Worst horizontal accuracy of the GNSS data
esrignss_worst_v_rms Worst vertical accuracy (m) Double True 0 0 0 True False Worst vertical accuracy of the GNSS data
esrignss_worst_fixtype Worst fix type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Worst fix type of the GNSS data
esrignss_manual_locations Number of manual locations Long Integer True 0 0 0 True False Number of manual locations recorded for the water distribution asset
created_user Creator String Creator;Index True 0 0 255 False True User who created the record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record was last edited
Shape__Length Shape__Length Double Index;Length True 0 0 0 False True Length of the shape geometry
Shape Geometry Index True 0 0 0 True True Geometry of the water main

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D854BB40529 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
Shape__Length_Index False True Shape__Length
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_WATER_MAIN_Shape_sidx False True Shape

L905001Pipe_Casing

Properties

Key Value
Name L905001Pipe_Casing
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Polyline
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Pipe Casing
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Structure_Line_Pipeline_Casing 0 0 0 0 True False Category of the asset, such as casing or unknown
assetid Asset ID String True 0 0 64 True False Unique identifier for the asset
diameter Diameter Double True Pipeline_Casing_Diameter 0 0 0 0 True False Diameter of the pipe casing
filltype Fill Type Short Integer True Pipeline_Casing_Fill_Type 0 0 0 0 True False Type of material used to fill the pipe casing
measuredlength Measured Length Double True 0 0 0 True False Length of the pipe casing as measured in the field
installdate Install Date Date True 1 0 8 True False Date when the pipe casing was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current status of the pipe casing in its lifecycle
inservicedate In-Service Date Date True 1 0 8 True False Date when the pipe casing was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the pipe casing was retired from service
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the pipe casing
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the accuracy of the spatial data
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the feature
esrignss_avg_h_rms Average horizontal accuracy (m) Double True 0 0 0 True False Average horizontal accuracy of the asset's location
esrignss_avg_v_rms Average vertical accuracy (m) Double True 0 0 0 True False Average vertical accuracy of the asset's location
esrignss_worst_h_rms Worst horizontal accuracy (m) Double True 0 0 0 True False Worst horizontal accuracy of the GNSS data
esrignss_worst_v_rms Worst vertical accuracy (m) Double True 0 0 0 True False Worst vertical accuracy of the GNSS data
esrignss_worst_fixtype Worst fix type Short Integer True ESRI_FIX_TYPE_DOMAIN 0 0 0 True False Worst fix type of the GNSS data
esrignss_manual_locations Number of manual locations Long Integer True 0 0 0 True False Number of manual locations recorded for the water distribution asset
created_user Creator String Creator;Index True 0 0 255 False True User who created the feature
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the feature was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the feature
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the feature was last edited
Shape__Length Shape__Length Double Index;Length True 0 0 0 False True Length of the shape of the feature
Shape Geometry Index True 0 0 0 True True Geometric representation of the feature

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85ADFDF1F7 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
Shape__Length_Index False True Shape__Length
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_PIPE_CASING_Shape_sidx False True Shape

L910505Water_Pump_Station_Boundary

Properties

Key Value
Name L910505Water_Pump_Station_Boundary
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Polygon
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Water Pump Station Boundary
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Structure_Boundary_Water_Pump_Station_Boundary 0 0 0 0 True False Categorizes the type of water pump station boundary
assetid Asset ID String True 0 0 64 True False Unique identifier for each water pump station boundary
name Name String True 0 0 64 True False Name of the water pump station boundary
installdate Install Date Date True 1 0 8 True False Date when the water pump station boundary was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water pump station boundary
inservicedate In-Service Date Date True 1 0 8 True False Date when the water pump station boundary was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water pump station boundary was retired
notes Notes String True 0 0 2000 True False Additional information or comments about the water pump station boundary
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water pump station boundary
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Confidence level in the accuracy of the spatial data
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for each water pump station boundary
created_user Creator String Creator;Index True 0 0 255 False True User who created the record for the water pump station boundary
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record for the water pump station boundary was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the record for the water pump station boundary
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record for the water pump station boundary was last edited
Shape__Area Shape__Area Double Area;Index True 0 0 0 False True Area of the water pump station boundary
Shape__Length Shape__Length Double Index;Length True 0 0 0 False True Perimeter of the water pump station boundary
Shape Geometry Index True 0 0 0 True True Geometric representation of the water pump station boundary

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D8588554F85 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
Shape__Area_Index False True Shape__Area
Shape__Length_Index False True Shape__Length
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_WATER_PUMP_STATION_BOUNDARY_Shape_sidx False True Shape

L910503Water_Storage_Boundary

Properties

Key Value
Name L910503Water_Storage_Boundary
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Polygon
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Water Storage Boundary
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Structure_Boundary_Water_Storage_Boundary 0 0 0 0 True False Categorizes the type of water storage boundary asset
assetid Asset ID String True 0 0 64 True False Unique identifier for the water storage boundary asset
name Name String True 0 0 64 True False Name of the water storage boundary asset
installdate Install Date Date True 1 0 8 True False Date when the water storage boundary asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water storage boundary asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the water storage boundary asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water storage boundary asset was retired
notes Notes String True 0 0 2000 True False Additional information or comments about the water storage boundary asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water storage boundary asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the accuracy of the spatial data
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the water storage boundary asset
created_user Creator String Creator;Index True 0 0 255 False True User who created the record for the water storage boundary asset
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record for the water storage boundary asset was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the record for the water storage boundary asset
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record for the water storage boundary asset was last edited
Shape__Area Shape__Area Double Area;Index True 0 0 0 False True Area of the water storage boundary asset
Shape__Length Shape__Length Double Index;Length True 0 0 0 False True Perimeter length of the water storage boundary asset
Shape Geometry Index True 0 0 0 True True Geometric representation of the water storage boundary asset

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85D0D305E3 True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
Shape__Area_Index False True Shape__Area
Shape__Length_Index False True Shape__Length
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_WATER_STORAGE_BOUNDARY_Shape_sidx False True Shape

L910507Water_Supply_Boundary

Properties

Key Value
Name L910507Water_Supply_Boundary
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Polygon
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Water Supply Boundary
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
assettype Asset type Short Integer False Asset_Type_Structure_Boundary_Water_Supply_Boundary 0 0 0 0 True False Categorizes the type of water supply boundary asset
assetid Asset ID String True 0 0 64 True False Unique identifier for the water supply boundary asset
name Name String True 0 0 64 True False Name of the water supply boundary asset
installdate Install Date Date True 1 0 8 True False Date when the water supply boundary asset was installed
lifecyclestatus Lifecycle Status Short Integer False Lifecycle 8 0 0 0 True False Current lifecycle status of the water supply boundary asset
inservicedate In-Service Date Date True 1 0 8 True False Date when the water supply boundary asset was put into service
retireddate Retired Date Date True 1 0 8 True False Date when the water supply boundary asset was retired
notes Notes String True 0 0 2000 True False Additional information or comments about the water supply boundary asset
spatialsource Spatial Source Short Integer True Spatial_Source 0 0 0 0 True False Source of the spatial data for the water supply boundary asset
spatialconfidence Spatial Confidence Short Integer True Spatial_Confidence 0 0 0 0 True False Level of confidence in the accuracy of the spatial data
globalid Global ID Global ID Index False 0 0 38 False True Globally unique identifier for the water supply boundary asset
created_user Creator String Creator;Index True 0 0 255 False True User who created the record for the water supply boundary asset
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record for the water supply boundary asset was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the record for the water supply boundary asset
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record for the water supply boundary asset was last edited
Shape__Area Shape__Area Double Area;Index True 0 0 0 False True Area of the water supply boundary asset
Shape__Length Shape__Length Double Index;Length True 0 0 0 False True Perimeter length of the water supply boundary asset
Shape Geometry Index True 0 0 0 True True Geometric representation of the water supply boundary asset

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85D80C405D True True OBJECTID
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
Shape__Area_Index False True Shape__Area
Shape__Length_Index False True Shape__Length
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_WATER_SUPPLY_BOUNDARY_Shape_sidx False True Shape

L920Service_Territory

Properties

Key Value
Name L920Service_Territory
Dataset Type FeatureClass
Feature Dataset
Dataset ID -1
Geometry Type Polygon
Feature Type Simple
Z-Aware True
M-Aware True
Split Model Update Insert
Minimum Client Version 10.0
Alias Service Territory
OID Field objectid
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Shape Field Shape
Spatial Reference WGS_1984_Web_Mercator_Auxiliary_Sphere
X-Min -15000000
X-Max -6200000
Y-Min 2700000
Y-Max 6500000
Z-Min
Z-Max
M-Min
M-Max
Catalog ID
Class ID {52353152-891A-11D0-BEC6-00805F7C4268}
Extension Class ID
Details

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
objectid objectid OID Index False 0 0 0 False True Unique identifier for each record in the Service Territory dataset
name Utility Name String True 0 0 50 True False Name of the utility providing the water distribution service
globalid GLOBALID Global ID Index False 0 0 38 False True Globally unique identifier for each record, used for data replication and relationship management
created_user Creator String Creator;Index True 0 0 255 False True Username of the individual who created the record
created_date Creation Date Date Created;Index True 1 0 8 False True Date and time when the record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True Username of the individual who last edited the record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date and time when the record was last edited
Shape__Area Shape__Area Double Area;Index True 0 0 0 False True Calculated area of the service territory, useful for spatial analysis
Shape__Length Shape__Length Double Index;Length True 0 0 0 False True Calculated perimeter length of the service territory, useful for spatial analysis
Shape Geometry Index True 0 0 0 True True Geometric representation of the service territory, used for mapping and spatial analysis

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__5242E632829D58F8 True True objectid
FDO_globalid True True globalid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user
Shape__Area_Index False True Shape__Area
Shape__Length_Index False True Shape__Length
WaterDistributionSystem_ea717d9d85c840efa39b3a3a9c135877_SERVICE_TERRITORY_Shape_sidx False True Shape

L5010100Meter_Relate

Properties

Key Value
Name L5010100Meter_Relate
Dataset Type Table
Feature Dataset
Dataset ID -1
Minimum Client Version 10.0
Alias Meter Relate
OID Field OBJECTID
GlobalID Field GlobalID
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R17L501010Service_MeterL5010100Meter_Relate
R4L501013System_MeterL5010100Meter_Relate

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Represents a unique identifier for each feature in the layer
notes Notes String True 0 0 2000 True False Contains any additional information or observations about the feature
assetguid Asset GlobalID GUID Index True 0 0 38 True False Holds the Global Unique Identifier (GUID) of the asset
GlobalID GlobalID Global ID Index False 0 0 38 False True Stores the Global ID of the feature, which is a unique identifier used across different databases
created_user Creator String Creator;Index True 0 0 255 False True Indicates the user who initially created the feature
created_date Creation Date Date Created;Index True 1 0 8 False True Specifies the date when the feature was first created
last_edited_user Editor String Editor;Index True 0 0 255 False True Shows the user who last edited the feature
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Represents the date when the feature was last edited

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85B7F4C480 True True OBJECTID
FDO_GlobalID True True GlobalID
G18assetguid False True assetguid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user

L5010070Hydrant_Maintenance_Inspection

Properties

Key Value
Name L5010070Hydrant_Maintenance_Inspection
Dataset Type Table
Feature Dataset
Dataset ID -1
Minimum Client Version 10.0
Alias Hydrant Maintenance Inspection
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R15L501007Fire_HydrantL5010070Hydrant_Maintenance_Inspection

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each record in the dataset
maintstatus Maintenance Status Long Integer True Hydrant Maintenance Inspection_maintstatus_68a309a0-672b-4fee-819f-635cc4cfd004 0 0 0 True False Status of the maintenance work performed on the hydrant
inspector Inspector String True 0 0 50 True False Name of the person who inspected the hydrant
insdate Inspection Date Date True 1 0 8 True False Date when the inspection was carried out
chains Are chains missing? Short Integer True Hydrant Maintenance Inspection_chains_f7c75bbca8dc40c6a4d7c30445310227 0 0 0 True False Indicates if the chains of the hydrant are missing
paint Needs to be painted? Short Integer True Hydrant Maintenance Inspection_paint_eeea61eaf35b4178860faff2c273b13d 0 0 0 True False Indicates if the hydrant needs to be painted
marker Needs marker? Short Integer True Hydrant Maintenance Inspection_marker_2fb27f8ccf204b2d9ef394a6f8293b9d 0 0 0 True False Indicates if the hydrant needs a marker
oil Needs lubrication? Short Integer True Hydrant Maintenance Inspection_oil_d1f325d0a3494231931b0cd0b3b480a3 0 0 0 True False Indicates if the hydrant needs lubrication
greased Needs grease? Short Integer True Hydrant Maintenance Inspection_greased_0186ba99e1554fec89b95b1b8c51337e 0 0 0 True False Indicates if the hydrant needs grease
drain Drains correctly? Short Integer True Hydrant Maintenance Inspection_drain_b80965260b1d4c8690d6649a159175b0 0 0 0 True False Indicates if the hydrant drains correctly
notes Notes String True 0 0 2000 True False Additional notes or comments about the hydrant
pressure Pressure Double True 0 0 0 True False Pressure measurement of the hydrant
flowrate Flow Rate Double True 0 0 0 True False Rate at which water flows from the hydrant
flowduration Flow Duration Double True 0 0 0 True False Duration of the water flow from the hydrant
assetguid Asset GlobalID GUID Index True 0 0 38 True False Holds the Global Unique Identifier (GUID) of the asset
globalid GlobalID Global ID Index False 0 0 38 False True Global identifier for each record in the dataset
leaking Is the hydrant leaking? Long Integer True Hydrant Maintenance Inspection_leaking_6fa17eff-3cb0-4729-8506-1eec6c7c56eb 0 0 0 True False Indicates if the hydrant is leaking
operable Is the hydrant operable? Long Integer True Hydrant Maintenance Inspection_operable_6ca7468d-cf1a-4eff-8469-89ef1e21510a 0 0 0 True False Indicates if the hydrant is operable
inspgroup Inspection Group String True Hydrant Maintenance Inspection_inspgroup_d0eae362-17e9-4e29-81d7-aecd4ca007f5 0 0 75 True False Group that carried out the inspection
firestation Fire Station String True Hydrant Maintenance Inspection_firestation_0ffe772d-fdeb-4d73-85a9-a34fcd2ccaca 0 0 75 True False Fire station associated with the hydrant
totalused Total Water Used Double True 0 0 0 True False Total amount of water used from the hydrant
inspectiontype Inspection Type Long Integer True Hydrant Maintenance Inspection_inspectiontype_2bdda6ca-e3b6-4401-80bd-0391eb45d210 0 0 0 True False Type of inspection carried out on the hydrant
dischargecoe Discharge Coefficient Double True 0 0 0 True False Discharge coefficient of the hydrant
outletdiameter Outlet Diameter Double True 0 0 0 True False Diameter of the hydrant's outlet
discharge Available Fire Flow Double True 0 0 0 True False Available fire flow from the hydrant
staticpressure Static Pressure Double True 0 0 0 True False Static pressure of the hydrant
residualpressure Residual Pressure Long Integer True 0 0 0 True False Residual pressure of the hydrant
flush Flush Long Integer True Hydrant Maintenance Inspection_flush_0cccffac-e40c-45b3-889f-ac409c4a1161 0 0 0 True False Indicates if the hydrant was flushed
pitotpressure Pitot Pressure Double True 0 0 0 True False Pitot pressure of the hydrant
created_user Creator String Creator;Index True 0 0 255 False True User who created the record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record was last edited

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D8561BA319C True True OBJECTID
FDO_globalid True True globalid
G88assetguid False True assetguid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user

L5010020System_Valve_Inspection

Properties

Key Value
Name L5010020System_Valve_Inspection
Dataset Type Table
Feature Dataset
Dataset ID -1
Minimum Client Version 10.0
Alias System Valve Inspection
OID Field OBJECTID
GlobalID Field globalid
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R19L501002System_ValveL5010020System_Valve_Inspection

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each feature in the layer
paved Paved over? Short Integer True 5_Yes_No_Not_Applicable 0 0 0 0 True False Indicates whether the area over the valve is paved
gsurface Ground Surface Short Integer True 5_Water_Valve_Surface_Type 0 0 0 True False Type of ground surface where the valve is located
fintorque Final Torque Double True 0 0 0 True False Final torque measurement after valve inspection
depthtonut Depth To Nut Double True 0 0 0 True False Depth from the ground surface to the nut of the valve
turns # of Turns Double True 0 0 0 True False Number of turns required to fully open or close the valve
operator Name of Operator String True 0 0 100 True False Name of the operator who performed the valve inspection
stem Stem OK? Short Integer True 5_Yes_No 0 0 0 True False Indicates whether the valve stem is in good condition
package Packing OK? Short Integer True 5_Yes_No 0 0 0 True False Indicates whether the valve packing is in good condition
gears Gears OK? Short Integer True 5_Yes_No 0 0 0 True False Indicates whether the valve gears are in good condition
lube Needs lubrication? Short Integer True System Valve Inspection_lube_27884b99f1d64dcfad6b092d9cdd80fe 0 0 0 True False Indicates whether the valve needs lubrication
other Other maintenance required? Short Integer True System Valve Inspection_other_91ad1659e607423993cbaaec835fe2f2 0 0 0 True False Indicates whether other maintenance is required for the valve
notes Notes String True 0 0 2000 True False Additional notes or comments about the valve inspection
insdate Inspection Date Date True 1 0 8 True False Date when the valve inspection was performed
assetguid Asset GlobalID GUID Index True 0 0 38 True False Holds the Global Unique Identifier (GUID) of the asset
globalid GlobalID Global ID Index False 0 0 38 False True Unique global identifier for each feature in the layer
created_user Creator String Creator;Index True 0 0 255 False True Name of the user who created the feature
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the feature was created
last_edited_user Editor String Editor;Index True 0 0 255 False True Name of the user who last edited the feature
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the feature was last edited

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D8508A92F17 True True OBJECTID
FDO_globalid True True globalid
G109assetguid False True assetguid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user

L5050030Backflow_Inspection

Properties

Key Value
Name L5050030Backflow_Inspection
Dataset Type Table
Feature Dataset
Dataset ID -1
Minimum Client Version 10.0
Alias Backflow Inspection
OID Field OBJECTID
GlobalID Field GlobalID
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R5L505003BackflowL5050030Backflow_Inspection

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each object in the layer
FACILITYID Facility ID String Index True 0 0 20 True False Unique identifier for each facility
MANUFACTURER Manufacturer String True ManufactureTypes 0 0 50 True False Name of the company that manufactured the asset
MODEL Model String True 0 0 50 True False Model name or number of the asset
INSTALLDATE Installed Date Date True 1 0 8 True False Date when the asset was installed
assetguid Asset GlobalID GUID Index True 0 0 38 True False Holds the Global Unique Identifier (GUID) of the asset
GlobalID GlobalID Global ID Index False 0 0 38 False True Unique global identifier for each object in the layer
created_user Creator String Creator;Index True 0 0 255 False True User who created the record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True User who last edited the record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record was last edited

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85B1D21956 True True OBJECTID
FDO_GlobalID True True GlobalID
G35assetguid False True assetguid
G35FACILITYID False True FACILITYID
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user

L5050040Water_Sample

Properties

Key Value
Name L5050040Water_Sample
Dataset Type Table
Feature Dataset
Dataset ID -1
Minimum Client Version 10.0
Alias Water Sample
OID Field OBJECTID
GlobalID Field GlobalID
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R33L501004Sample_StationL5050040Water_Sample

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
testinfo Test Information String True 0 0 255 True False Contains details about the test conducted on the water sample
OBJECTID OBJECTID OID Index False 0 0 0 False True Unique identifier for each object in the dataset
sampleid Sample ID String True 0 0 255 True False Unique identifier for each water sample
samplelocation Sample Location String True 0 0 255 True False Location where the water sample was collected
sampledate Sample Date Date True 1 0 8 True False Date when the water sample was collected
collectorname Name of Collector String True 0 0 255 True False Name of the individual who collected the water sample
sampletype Sample Type Short Integer True Water_Sample_Type 0 0 0 True False Type of water sample collected, represented as a coded value
analysisdate Date of Analysis Date True 1 0 8 True False Date when the water sample was analyzed
laboratoryname Name of Laboratory String True 0 0 255 True False Name of the laboratory where the water sample was analyzed
analystname Name of Analyst String True 0 0 255 True False Name of the analyst who analyzed the water sample
analyticalmethod Analytical Method String True 0 0 255 True False Method used to analyze the water sample
analysisresults Analysis Results String True 0 0 255 True False Results of the water sample analysis
GlobalID GlobalID Global ID Index False 0 0 38 False True Globally unique identifier for each object in the dataset
samplestationGUID samplestationGUID GUID True 0 0 38 True False Unique identifier for the sample station where the water sample was collected
created_user Creator String Creator;Index True 0 0 255 False True Name of the user who created the record
created_date Creation Date Date Created;Index True 1 0 8 False True Date when the record was created
last_edited_user Editor String Editor;Index True 0 0 255 False True Name of the user who last edited the record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Date when the record was last edited

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D856F4BE47E True True OBJECTID
FDO_GlobalID True True GlobalID
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user

L5050041Hydrant_Relate

Properties

Key Value
Name L5050041Hydrant_Relate
Dataset Type Table
Feature Dataset
Dataset ID -1
Minimum Client Version 10.0
Alias Hydrant Relate
OID Field OBJECTID
GlobalID Field GlobalID
Subtype Field
Default Subtype
Editor Tracking Enabled True
Editor Tracking UTC True
Creator Field created_user
Create Date Field created_date
Editor Field last_edited_user
Edit Date Field last_edited_date
Catalog ID
Class ID {7A566981-C114-11D2-8A28-006097AFF44E}
Extension Class ID
Details

RelationshipClassNames

Name Role Related To Cardinality Type
R1L501007Fire_HydrantL5050041Hydrant_Relate

Field

Name Alias Type Usage Nullable Domain Default Value Precision Scale Length Editable Required Details
OBJECTID OBJECTID OID Index False 0 0 0 False True Represents a unique identifier for each object in the dataset
notes Notes String True 0 0 2000 True False Contains any additional information or comments about the asset
assetguid Asset GlobalID GUID Index True 0 0 38 True False Holds the Global Unique Identifier (GUID) of the asset
GlobalID GlobalID Global ID Index False 0 0 38 False True Holds the global identifier for each record in the dataset
created_user Creator String Creator;Index True 0 0 255 False True Indicates the user who initially created the record
created_date Creation Date Date Created;Index True 1 0 8 False True Specifies the date when the record was first created
last_edited_user Editor String Editor;Index True 0 0 255 False True Shows the user who last edited the record
last_edited_date Edit Date Date Edited;Index True 1 0 8 False True Represents the date when the record was last modified

Index

Name Is Unique Is Ascending Field Name
PK__WaterDis__F4B70D85F5BF9184 True True OBJECTID
FDO_GlobalID True True GlobalID
G86assetguid False True assetguid
created_dateIndex False True created_date
created_userIndex False False created_user
last_edited_dateIndex False True last_edited_date
last_edited_userIndex False False last_edited_user

Domains

Asset_Type_Water_Device_Pressure_Valve

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Pressure_Valve
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 9
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
201 Air and Vacuum
202 Air Release
203 Combination Air
204 Pressure Limiting
205 Pressure Reducing
206 Pressure Release
207 Pressure Sustaining
208 Surge

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501003Pressure_Valve assettype

5_Water_Valve_Surface_Type

Properties

Key Value
Owner
Domain Name 5_Water_Valve_Surface_Type
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 8
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Asphalt
2 Brick
3 Concrete
4 Dirt
5 Grass
6 Gravel
7 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010020System_Valve_Inspection gsurface

Symbol_Rotation

Properties

Key Value
Owner
Domain Name Symbol_Rotation
Description
Field Type Short Integer
Domain Type Range
Split Policy Duplicate
Merge Policy Default Value
# of Codes
# of Assignments 17

DomainRange

Minimum Maximum
0 359

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off symbolrotation
L505003Backflow symbolrotation
L501004Sample_Station symbolrotation
L501007Fire_Hydrant symbolrotation
L501012Service_Connection symbolrotation
L501010Service_Meter symbolrotation
L501013System_Meter symbolrotation
L501006Service_Valve symbolrotation
L501001Flow_Valve symbolrotation
L501003Pressure_Valve symbolrotation
L501002System_Valve symbolrotation
L510020Fitting symbolrotation
L501020Storage symbolrotation
L501005Pump symbolrotation
L501016Interconnect symbolrotation
L501017Treatment_Plant symbolrotation
L501018Well symbolrotation

Asset_Type_Water_Device_Flushing_and_Blow_Off

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Flushing_and_Blow_Off
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
361 Automatic Flushing
365 Blow Off
362 Fire Plug Valve
363 Hydrant
364 Post Hydrant

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off assettype

Water_Diameter

Properties

Key Value
Owner
Domain Name Water_Diameter
Description
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 30
# of Assignments 4

DomainCodedValue

Code Description Details
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
2 2"
2.5 2 1/2"
3 3"
4 4"
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"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501006Service_Valve diameter
L501001Flow_Valve diameter
L501003Pressure_Valve diameter
L501002System_Valve diameter

Asset_Type_Water_Device_Service_Valve

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Service_Valve
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
161 Blow Off
177 Flap
164 Hydrant
174 Purge
171 Sampling
176 Service

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501006Service_Valve assettype

Asset_Owner

Properties

Key Value
Owner
Domain Name Asset_Owner
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 19

DomainCodedValue

Code Description Details
1 Our Agency
2 Private
100 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off ownedby
L505003Backflow ownedby
L501004Sample_Station ownedby
L501007Fire_Hydrant ownedby
L501012Service_Connection ownedby
L501010Service_Meter ownedby
L501013System_Meter ownedby
L501006Service_Valve ownedby
L501001Flow_Valve ownedby
L501003Pressure_Valve ownedby
L501002System_Valve ownedby
L510020Fitting ownedby
L501020Storage ownedby
L501005Pump ownedby
L501016Interconnect ownedby
L501017Treatment_Plant ownedby
L501018Well ownedby
L515002Service ownedby
L515001Water_Main ownedby

Asset_Type_Water_Assembly_Backflow

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Assembly_Backflow
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 5
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Double Check Detector
2 Double Check Valve
3 Reduced Pressure Detector
4 Reduced Pressure Zone

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L505003Backflow assettype

Lifecycle

Properties

Key Value
Owner
Domain Name Lifecycle
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 10
# of Assignments 23

DomainCodedValue

Code Description Details
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

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off lifecyclestatus
L505003Backflow lifecyclestatus
L501004Sample_Station lifecyclestatus
L501007Fire_Hydrant lifecyclestatus
L501012Service_Connection lifecyclestatus
L501010Service_Meter lifecyclestatus
L501013System_Meter lifecyclestatus
L501006Service_Valve lifecyclestatus
L501001Flow_Valve lifecyclestatus
L501003Pressure_Valve lifecyclestatus
L501002System_Valve lifecyclestatus
L510020Fitting lifecyclestatus
L501020Storage lifecyclestatus
L501005Pump lifecyclestatus
L501016Interconnect lifecyclestatus
L501017Treatment_Plant lifecyclestatus
L501018Well lifecyclestatus
L515002Service lifecyclestatus
L515001Water_Main lifecyclestatus
L905001Pipe_Casing lifecyclestatus
L910505Water_Pump_Station_Boundary lifecyclestatus
L910503Water_Storage_Boundary lifecyclestatus
L910507Water_Supply_Boundary lifecyclestatus

Spatial_Confidence

Properties

Key Value
Owner
Domain Name Spatial_Confidence
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 23

DomainCodedValue

Code Description Details
0 Unknown
1 High
2 Medium
3 Low

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off spatialconfidence
L505003Backflow spatialconfidence
L501004Sample_Station spatialconfidence
L501007Fire_Hydrant spatialconfidence
L501012Service_Connection spatialconfidence
L501010Service_Meter spatialconfidence
L501013System_Meter spatialconfidence
L501006Service_Valve spatialconfidence
L501001Flow_Valve spatialconfidence
L501003Pressure_Valve spatialconfidence
L501002System_Valve spatialconfidence
L510020Fitting spatialconfidence
L501020Storage spatialconfidence
L501005Pump spatialconfidence
L501016Interconnect spatialconfidence
L501017Treatment_Plant spatialconfidence
L501018Well spatialconfidence
L515002Service spatialconfidence
L515001Water_Main spatialconfidence
L905001Pipe_Casing spatialconfidence
L910505Water_Pump_Station_Boundary spatialconfidence
L910503Water_Storage_Boundary spatialconfidence
L910507Water_Supply_Boundary spatialconfidence

Hydrant Maintenance Inspection_maintstatus_68a309a0-672b-4fee-819f-635cc4cfd004

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_maintstatus_68a309a0-672b-4fee-819f-635cc4cfd004
Description
Field Type Long Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 6
# of Assignments 1

DomainCodedValue

Code Description Details
1 Submitted
2 Acknowledged
3 Planned
4 Completed
5 Deferred
6 Rejected

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection maintstatus

Water_Meter_Diameter

Properties

Key Value
Owner
Domain Name Water_Meter_Diameter
Description
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 24
# of Assignments 2

DomainCodedValue

Code Description Details
0 Unknown
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
2 2"
2.25 2 1/4"
2.5 2 1/2"
3 3"
4 4"
4.5 4 1/2"
5.25 5 1/4"
6 6"
8 8"
10 10"
0.5 1/2"
0.625 5/8"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501010Service_Meter diameter
L501013System_Meter diameter

Asset_Type_Water_Device_Service_Meter

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Service_Meter
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 6
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
42 Commercial
50 Fire
45 Industrial
49 Irrigation
48 Residential

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501010Service_Meter assettype

Asset_Manager

Properties

Key Value
Owner
Domain Name Asset_Manager
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 19

DomainCodedValue

Code Description Details
1 Our Agency
2 Private
100 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off maintby
L505003Backflow maintby
L501004Sample_Station maintby
L501007Fire_Hydrant maintby
L501012Service_Connection maintby
L501010Service_Meter maintby
L501013System_Meter maintby
L501006Service_Valve maintby
L501001Flow_Valve maintby
L501003Pressure_Valve maintby
L501002System_Valve maintby
L510020Fitting maintby
L501020Storage maintby
L501005Pump maintby
L501016Interconnect maintby
L501017Treatment_Plant maintby
L501018Well maintby
L515002Service maintby
L515001Water_Main maintby

Spatial_Source

Properties

Key Value
Owner
Domain Name Spatial_Source
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 23

DomainCodedValue

Code Description Details
0 Unknown
1 As-Built
2 CAD
3 Digitized
4 GPS/GNSS
5 Field Sketch

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off spatialsource
L505003Backflow spatialsource
L501004Sample_Station spatialsource
L501007Fire_Hydrant spatialsource
L501012Service_Connection spatialsource
L501010Service_Meter spatialsource
L501013System_Meter spatialsource
L501006Service_Valve spatialsource
L501001Flow_Valve spatialsource
L501003Pressure_Valve spatialsource
L501002System_Valve spatialsource
L510020Fitting spatialsource
L501020Storage spatialsource
L501005Pump spatialsource
L501016Interconnect spatialsource
L501017Treatment_Plant spatialsource
L501018Well spatialsource
L515002Service spatialsource
L515001Water_Main spatialsource
L905001Pipe_Casing spatialsource
L910505Water_Pump_Station_Boundary spatialsource
L910503Water_Storage_Boundary spatialsource
L910507Water_Supply_Boundary spatialsource

ESRI_POSITIONSOURCETYPE_DOMAIN

Properties

Key Value
Owner
Domain Name ESRI_POSITIONSOURCETYPE_DOMAIN
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 5
# of Assignments 12

DomainCodedValue

Code Description Details
0 Unknown
1 User defined
2 Integrated (System) Location Provider
3 External GNSS Receiver
4 Network Location Provider

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off ESRIGNSS_POSITIONSOURCETYPE
L501007Fire_Hydrant ESRIGNSS_POSITIONSOURCETYPE
L501012Service_Connection ESRIGNSS_POSITIONSOURCETYPE
L501010Service_Meter ESRIGNSS_POSITIONSOURCETYPE
L501013System_Meter ESRIGNSS_POSITIONSOURCETYPE
L501006Service_Valve ESRIGNSS_POSITIONSOURCETYPE
L501001Flow_Valve ESRIGNSS_POSITIONSOURCETYPE
L501003Pressure_Valve ESRIGNSS_POSITIONSOURCETYPE
L501002System_Valve ESRIGNSS_POSITIONSOURCETYPE
L510020Fitting ESRIGNSS_POSITIONSOURCETYPE
L501020Storage ESRIGNSS_POSITIONSOURCETYPE
L501005Pump ESRIGNSS_POSITIONSOURCETYPE

adoptionstatus

Properties

Key Value
Owner
Domain Name adoptionstatus
Description
Field Type String
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
Available Available
Adopted Adopted

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501007Fire_Hydrant adoptionstatus

ESRI_FIX_TYPE_DOMAIN

Properties

Key Value
Owner
Domain Name ESRI_FIX_TYPE_DOMAIN
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 5
# of Assignments 20

DomainCodedValue

Code Description Details
0 Fix not valid
1 GPS
2 Differential GPS
4 RTK Fixed
5 RTK Float

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off ESRIGNSS_FIXTYPE
L505003Backflow ESRIGNSS_FIXTYPE
L501004Sample_Station ESRIGNSS_FIXTYPE
L501007Fire_Hydrant ESRIGNSS_FIXTYPE
L501012Service_Connection ESRIGNSS_FIXTYPE
L501010Service_Meter ESRIGNSS_FIXTYPE
L501013System_Meter ESRIGNSS_FIXTYPE
L501006Service_Valve ESRIGNSS_FIXTYPE
L501001Flow_Valve ESRIGNSS_FIXTYPE
L501003Pressure_Valve ESRIGNSS_FIXTYPE
L501002System_Valve ESRIGNSS_FIXTYPE
L510020Fitting ESRIGNSS_FIXTYPE
L501020Storage ESRIGNSS_FIXTYPE
L501005Pump ESRIGNSS_FIXTYPE
L501016Interconnect ESRIGNSS_FIXTYPE
L501017Treatment_Plant ESRIGNSS_FIXTYPE
L501018Well ESRIGNSS_FIXTYPE
L515002Service esrignss_worst_fixtype
L515001Water_Main esrignss_worst_fixtype
L905001Pipe_Casing esrignss_worst_fixtype

Asset_Type_Structure_Boundary_Water_Pump_Station_Boundary

Properties

Key Value
Owner
Domain Name Asset_Type_Structure_Boundary_Water_Pump_Station_Boundary
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
42 Booster Station
41 Pump Station

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L910505Water_Pump_Station_Boundary assettype

Water_Sample_Type

Properties

Key Value
Owner
Domain Name Water_Sample_Type
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
1 Grab Sample
2 Composite Sample
3 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5050040Water_Sample sampletype

ESRI_STATION_ID_DOMAIN

Properties

Key Value
Owner
Domain Name ESRI_STATION_ID_DOMAIN
Description
Field Type Short Integer
Domain Type Range
Split Policy Default Value
Merge Policy Default Value
# of Codes
# of Assignments 17

DomainRange

Minimum Maximum
0 1023

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off ESRIGNSS_STATIONID
L505003Backflow ESRIGNSS_STATIONID
L501004Sample_Station ESRIGNSS_STATIONID
L501007Fire_Hydrant ESRIGNSS_STATIONID
L501012Service_Connection ESRIGNSS_STATIONID
L501010Service_Meter ESRIGNSS_STATIONID
L501013System_Meter ESRIGNSS_STATIONID
L501006Service_Valve ESRIGNSS_STATIONID
L501001Flow_Valve ESRIGNSS_STATIONID
L501003Pressure_Valve ESRIGNSS_STATIONID
L501002System_Valve ESRIGNSS_STATIONID
L510020Fitting ESRIGNSS_STATIONID
L501020Storage ESRIGNSS_STATIONID
L501005Pump ESRIGNSS_STATIONID
L501016Interconnect ESRIGNSS_STATIONID
L501017Treatment_Plant ESRIGNSS_STATIONID
L501018Well ESRIGNSS_STATIONID

ESRI_NUM_SATS_DOMAIN

Properties

Key Value
Owner
Domain Name ESRI_NUM_SATS_DOMAIN
Description
Field Type Short Integer
Domain Type Range
Split Policy Default Value
Merge Policy Default Value
# of Codes
# of Assignments 17

DomainRange

Minimum Maximum
0 99

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501009Flushing_and_Blow_Off ESRIGNSS_NUMSATS
L505003Backflow ESRIGNSS_NUMSATS
L501004Sample_Station ESRIGNSS_NUMSATS
L501007Fire_Hydrant ESRIGNSS_NUMSATS
L501012Service_Connection ESRIGNSS_NUMSATS
L501010Service_Meter ESRIGNSS_NUMSATS
L501013System_Meter ESRIGNSS_NUMSATS
L501006Service_Valve ESRIGNSS_NUMSATS
L501001Flow_Valve ESRIGNSS_NUMSATS
L501003Pressure_Valve ESRIGNSS_NUMSATS
L501002System_Valve ESRIGNSS_NUMSATS
L510020Fitting ESRIGNSS_NUMSATS
L501020Storage ESRIGNSS_NUMSATS
L501005Pump ESRIGNSS_NUMSATS
L501016Interconnect ESRIGNSS_NUMSATS
L501017Treatment_Plant ESRIGNSS_NUMSATS
L501018Well ESRIGNSS_NUMSATS

Yes_No

Properties

Key Value
Owner
Domain Name Yes_No
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 7

DomainCodedValue

Code Description Details
0 Unknown
1 Yes
2 No

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L505003Backflow locked
L501012Service_Connection additionaldetails
L501012Service_Connection additionaldevice
L501006Service_Valve operator
L501002System_Valve additionaldevice
L515002Service adddetails
L515001Water_Main adddetails

Asset_Type_Structure_Boundary_Water_Storage_Boundary

Properties

Key Value
Owner
Domain Name Asset_Type_Structure_Boundary_Water_Storage_Boundary
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
6 Hydropneumatic Tank
1 Reservoir
2 Retention Area
3 Storage Tank
5 Surge Tank
4 Tower

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L910503Water_Storage_Boundary assettype

ESRI_POSITIONSOURCETYPE_DOMAIN_1

Properties

Key Value
Owner
Domain Name ESRI_POSITIONSOURCETYPE_DOMAIN_1
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 6
# of Assignments 4

DomainCodedValue

Code Description Details
0 Unknown
1 User defined
2 Integrated (System) Location Provider
3 External GNSS Receiver
4 Network Location Provider
5 Snapped

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501004Sample_Station ESRIGNSS_POSITIONSOURCETYPE
L501016Interconnect ESRIGNSS_POSITIONSOURCETYPE
L501017Treatment_Plant ESRIGNSS_POSITIONSOURCETYPE
L501018Well ESRIGNSS_POSITIONSOURCETYPE

Asset_Type_Water_Device_Fire_Hydrant

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Fire_Hydrant
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
321 Fire Hydrant

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501007Fire_Hydrant assettype

Water_Treatment_Plant_Type

Properties

Key Value
Owner
Domain Name Water_Treatment_Plant_Type
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
1 Groundwater
2 Surface Water
3 Desalination

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501017Treatment_Plant assettype

Water_Hydrant_Service_Diameter

Properties

Key Value
Owner
Domain Name Water_Hydrant_Service_Diameter
Description
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
4 4"
4.5 4 1/2"
5.25 5 1/4"
6 6"
8 8"
10 10"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501007Fire_Hydrant diameter

Water_Hydrant_Nozzle_Diameter

Properties

Key Value
Owner
Domain Name Water_Hydrant_Nozzle_Diameter
Description
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
2.5 2 1/2"
4.5 4 1/2"
5 5"
6 6"
4 4"
5.25 5 1/4"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501007Fire_Hydrant secondarydiameter

Water_Fire_Hydrant_Manufacturer

Properties

Key Value
Owner
Domain Name Water_Fire_Hydrant_Manufacturer
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 15
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
60 American Darling
61 Clow Corporation
62 Corey
63 Dresser
64 Eddy
65 Iowa Valve
66 Kennedy Valve
67 M&H Valve
68 Mueller Company
69 Traverse City
70 US Pipe
71 Waterous
72 Wood-Matthews
73 Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501007Fire_Hydrant manufacturer

Fire Hydrant_assignmenttype_efa6b5d1-cd1e-4fe2-8746-628b3c7eaf2c

Properties

Key Value
Owner
Domain Name Fire Hydrant_assignmenttype_efa6b5d1-cd1e-4fe2-8746-628b3c7eaf2c
Description
Field Type Long Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
3 Flow Test
2 Flush

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501007Fire_Hydrant assignmenttype

Fire Hydrant_publicview_319bb766-c618-4e85-8d04-d2f58c09ef8e

Properties

Key Value
Owner
Domain Name Fire Hydrant_publicview_319bb766-c618-4e85-8d04-d2f58c09ef8e
Description
Field Type String
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
1 Yes
2 No

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501007Fire_Hydrant publicview

Hydrant Maintenance Inspection_flush_0cccffac-e40c-45b3-889f-ac409c4a1161

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_flush_0cccffac-e40c-45b3-889f-ac409c4a1161
Description
Field Type Long Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
1 Yes
2 No

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection flush

Asset_Type_Water_Device_System_Meter

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_System_Meter
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 5
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
41 Bulk
43 DMA
44 Emergency Connection
47 Pump Station

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501013System_Meter assettype

Asset_Type_Water_Device_Service_Connection

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Service_Connection
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
61 Commercial
62 Fire
63 Industrial
64 Irrigation
65 Residential

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501012Service_Connection assettype

Asset_Type_Structure_Boundary_Water_Supply_Boundary

Properties

Key Value
Owner
Domain Name Asset_Type_Structure_Boundary_Water_Supply_Boundary
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
83 Interconnect
81 Treatment Plant
82 Well

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L910507Water_Supply_Boundary assettype

Water_Valve_Type

Properties

Key Value
Owner
Domain Name Water_Valve_Type
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 2

DomainCodedValue

Code Description Details
0 Unknown
20 Ball
21 Butterfly
22 Cone
23 Gate
24 Plug

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501006Service_Valve designtype
L501002System_Valve designtype

Pipeline_Valve_Status

Properties

Key Value
Owner
Domain Name Pipeline_Valve_Status
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 2
# of Assignments 2

DomainCodedValue

Code Description Details
0 Closed
1 Open

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501006Service_Valve presentstatus
L501002System_Valve presentstatus

Hydrant Maintenance Inspection_drain_b80965260b1d4c8690d6649a159175b0

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_drain_b80965260b1d4c8690d6649a159175b0
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 No
1 Yes

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection drain

Asset_Type_Water_Junction_Fitting

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Junction_Fitting
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 23
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
61 Clamp
41 Corporation Stop
42 Coupling
43 Cross
44 Elbow
45 End Cap
46 Expansion Joint
47 Flange
48 Plug
49 Reducer
50 Reducing Cross
51 Reducing Tee
52 Saddle
53 Screw
54 Sleeve
55 Tap
56 Tapping Saddle
62 Tapping Sleeve
57 Tee
58 Transition
59 Weld
60 Wye

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L510020Fitting assettype

Pipeline_Valve_Close_Direction

Properties

Key Value
Owner
Domain Name Pipeline_Valve_Close_Direction
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 2
# of Assignments 2

DomainCodedValue

Code Description Details
0 Counter Clockwise
1 Clockwise

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501006Service_Valve additionaldetails
L501002System_Valve additionaldetails

Boolean

Properties

Key Value
Owner
Domain Name Boolean
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 2
# of Assignments 3

DomainCodedValue

Code Description Details
0 False
1 True

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501006Service_Valve operable
L501002System_Valve operable
L501005Pump operable

Asset_Type_Water_Device_Flow_Valve

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Flow_Valve
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Air Gap
2 Altitude
3 Check

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501001Flow_Valve assettype

Asset_Type_Structure_Line_Pipeline_Casing

Properties

Key Value
Owner
Domain Name Asset_Type_Structure_Line_Pipeline_Casing
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Casing

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L905001Pipe_Casing assettype

Water_Service_Diameter

Properties

Key Value
Owner
Domain Name Water_Service_Diameter
Description
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 16
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
2 2"
2.25 2 1/4"
2.5 2 1/2"
3 3"
4 4"
4.5 4 1/2"
5.25 5 1/4"
6 6"
8 8"
10 10"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L515002Service diameter

Asset_Type_Water_Device_System_Valve

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_System_Valve
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
173 Bypass
175 Interconnect
167 Isolation Zone
172 Pressure Zone
169 Supply
170 System

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501002System_Valve assettype

Water_Fitting_Diameter

Properties

Key Value
Owner
Domain Name Water_Fitting_Diameter
Description
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 103
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
0.25 1/4"
0.375 3/8"
0.5 1/2"
0.625 5/8"
0.75 3/4"
1 1"
1.125 1 1/8"
1.25 1 1/4"
1.375 1 3/8"
1.5 1 1/2"
1.875 1 7/8"
2 2"
2.5 2 1/2"
3 3"
4 4"
5 5"
5.5 5 1/2"
6 6"
8 8"
10 10"
12 12"
14 14"
16 16"
18 18"
20 20"
24 24"
26 26"
30 30"
36 36"
40 40"
48 48"
1000 1" x 1/2"
1001 1" x 5/8"
1002 1" x 3/4"
1003 1 1/4" x 1/2"
1004 1 1/4" x 5/8"
1005 1 1/4" x 3/4"
1006 1 1/4" x 7/8"
1007 1 1/4" x 1"
1008 1 1/2" x 3/4"
1009 1 1/2" x 1"
1010 1 1/2" x 1 1/4"
1011 2" x 1"
1012 2" x 1 1/4"
1013 2" x 1 1/2"
1014 3" x 1 1/2"
1015 3" x 2"
1016 4" x 2"
1017 4" x 3"
1018 6" x 3"
1019 6" x 4"
1020 8" x 4"
1021 8" x 6"
1022 10" x 6"
1023 10" x 8"
1024 12" x 6"
1025 12" x 8"
1026 12" x 10"
1027 14" x 8"
1028 14" x 10"
1029 14" x 12"
1030 16" x 8"
1031 16" x 10"
1032 16" x 12"
1033 16" x 14"
1034 18" x 10"
1035 18" x 12"
1036 18" x 14"
1037 18" x 16"
1038 20" x 10"
1039 20" x 12"
1040 20" x 14"
1041 20" x 16"
1042 20" x 18"
1043 24" x 12"
1044 24" x 14"
1045 24" x 16"
1046 24" x 18"
1047 24" x 20"
1048 26" x 14"
1049 26" x 16"
1050 26" x 18"
1051 26" x 20"
1052 26" x 24"
1053 30" x 16"
1054 30" x 18"
1055 30" x 20"
1056 30" x 24"
1057 30" x 26"
1058 36" x 18"
1059 36" x 20"
1060 36" x 24"
1061 36" x 26"
1062 40" x 20"
1063 40" x 24"
1064 40" x 26"
1065 40" x 30"
1066 40" x 36"
1067 48" x 24"
1068 48" x 26"
1069 48" x 30"
1070 48" x 36"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L510020Fitting diameter

Water_Main_Diameter

Properties

Key Value
Owner
Domain Name Water_Main_Diameter
Description
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 22
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
4 4"
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"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L515001Water_Main diameter

Asset_Type_Water_Device_Storage

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Storage
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
566 Hydropneumatic Tank
561 Reservoir
562 Standpipe
563 Storage Tank
565 Surge Tank
564 Tower

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501020Storage assettype

Water_Supply_Filtration_Type

Properties

Key Value
Owner
Domain Name Water_Supply_Filtration_Type
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 6
# of Assignments 2

DomainCodedValue

Code Description Details
0 Unknown
1 Carbon
2 Reverse Osmosis
3 Ultraviolet Light
4 Sediment
5 Biological

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501017Treatment_Plant filtrationtype
L501018Well filtrationtype

Asset_Type_Water_Device_Pump

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Pump
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
281 Booster
282 Chemical
283 Primary

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501005Pump assettype

Water_Pump_Diameter

Properties

Key Value
Owner
Domain Name Water_Pump_Diameter
Description
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 14
# of Assignments 2

DomainCodedValue

Code Description Details
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"

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501005Pump diameter
L501005Pump secondarydiameter

Water_Pump_Type

Properties

Key Value
Owner
Domain Name Water_Pump_Type
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
40 Axial Flow
41 Centrifugal
42 Jet
43 Reciprocating
44 Rotary
45 Turbine

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501005Pump designtype

5_Yes_No

Properties

Key Value
Owner
Domain Name 5_Yes_No
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 3
# of Assignments 4

DomainCodedValue

Code Description Details
0 Unknown
1 Yes
2 No

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501016Interconnect emergency
L5010020System_Valve_Inspection stem
L5010020System_Valve_Inspection package
L5010020System_Valve_Inspection gears

System Valve Inspection_lube_27884b99f1d64dcfad6b092d9cdd80fe

Properties

Key Value
Owner
Domain Name System Valve Inspection_lube_27884b99f1d64dcfad6b092d9cdd80fe
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Yes
2 No

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010020System_Valve_Inspection lube

Hydrant Maintenance Inspection_marker_2fb27f8ccf204b2d9ef394a6f8293b9d

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_marker_2fb27f8ccf204b2d9ef394a6f8293b9d
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 No
1 Yes

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection marker

Water_Interconnect_Connection_Type

Properties

Key Value
Owner
Domain Name Water_Interconnect_Connection_Type
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
1 Buy
2 Sell
3 Buy or Sell

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501016Interconnect assettype

Asset_Type_Water_Device_Supply_WellType

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Device_Supply_WellType
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
6020 Water
6021 Monitoring
6022 Injection

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L501018Well assettype

Asset_Type_Water_Line_Service

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Line_Service
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 10
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
19 Air and Vacuum Service
18 Blow Off Service
12 Commercial Service
14 Fire Service
15 Hydrant Service
13 Industrial Service
16 Irrigation Service
11 Residential Service
17 Sampling Service

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L515002Service assettype

Pipeline_Casing_Diameter

Properties

Key Value
Owner
Domain Name Pipeline_Casing_Diameter
Description
Field Type Double
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 23
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
4 4
6 6
8 8
10 10
12 12
14 14
16 16
18 18
20 20
22 22
24 24
26 26
28 28
30 30
32 32
34 34
36 36
40 40
42 42
44 44
46 46
48 48

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L905001Pipe_Casing diameter

Water_Service_Material

Properties

Key Value
Owner
Domain Name Water_Service_Material
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
83 Cast Iron - CAS
84 Copper - COP
88 Ductile Iron - DIP
94 Polyvinyl Chloride - PVC
109 Lead - LP

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L515002Service material

Water_Type

Properties

Key Value
Owner
Domain Name Water_Type
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 7
# of Assignments 2

DomainCodedValue

Code Description Details
0 Unknown
1 Potable
2 Irrigation
3 Fire
4 Raw
5 Intermediate
6 Finished

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L515002Service designtype
L515001Water_Main designtype

Asset_Type_Water_Line_Water_Main

Properties

Key Value
Owner
Domain Name Asset_Type_Water_Line_Water_Main
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 6
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
2 Distribution Main
4 Drain
5 Overflow
3 Production
1 Transmission Main

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L515001Water_Main assettype

Water_Main_Material

Properties

Key Value
Owner
Domain Name Water_Main_Material
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 29
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
81 Asbestos Cement - AC
82 Brick - BR
83 Cast Iron - CAS
84 Copper - COP
85 Concrete (Non-Reinforced) - CP
86 Concrete Segments (Bolted) - CSB
87 Concrete Segments (Unbolted) - CSU
88 Ductile Iron - DIP
89 Galvanized Pipe - GP
90 Pitch Fiber (Orangeburg) - OB
91 Plastic/Steel Composite - PSC
92 Polyethylene - PE
93 Polypropylene - PP
94 Polyvinyl Chloride - PVC
95 Steel - SP
96 Transite - TTE
97 Wood - WD
98 Pre-stressed Concrete Cylinder Pipe - PCCP
99 Pre-stressed Concrete Embedded Cylinder Pipe AWWA C-301 - PCPE
100 Pre-stressed Concrete Lined Cylinder Pipe AWWA C-301 - PCPL
101 Steel Cylinder Reinforced Concrete Pipe - SRC
102 High Density Polyethylene - HDPE
103 Unreinforced Concrete Pipe - URC
104 Fiberglass Reinforced Pipe - FRP
105 Reinforced Concrete Pipe - RCP
106 Corrugated Pipe - CORR
107 Plastic - PLA
108 Non-Plastic - NPLA

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L515001Water_Main material

Pipeline_Casing_Fill_Type

Properties

Key Value
Owner
Domain Name Pipeline_Casing_Fill_Type
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Duplicate
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Grout
2 Pea Gravel
3 Sand

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L905001Pipe_Casing filltype

Hydrant Maintenance Inspection_chains_f7c75bbca8dc40c6a4d7c30445310227

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_chains_f7c75bbca8dc40c6a4d7c30445310227
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 No
1 Yes

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection chains

Hydrant Maintenance Inspection_paint_eeea61eaf35b4178860faff2c273b13d

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_paint_eeea61eaf35b4178860faff2c273b13d
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 No
1 Yes

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection paint

Hydrant Maintenance Inspection_oil_d1f325d0a3494231931b0cd0b3b480a3

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_oil_d1f325d0a3494231931b0cd0b3b480a3
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 No
1 Yes

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection oil

Hydrant Maintenance Inspection_greased_0186ba99e1554fec89b95b1b8c51337e

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_greased_0186ba99e1554fec89b95b1b8c51337e
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 No
1 Yes

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection greased

Hydrant Maintenance Inspection_leaking_6fa17eff-3cb0-4729-8506-1eec6c7c56eb

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_leaking_6fa17eff-3cb0-4729-8506-1eec6c7c56eb
Description
Field Type Long Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 No
1 Yes

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection leaking

Hydrant Maintenance Inspection_operable_6ca7468d-cf1a-4eff-8469-89ef1e21510a

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_operable_6ca7468d-cf1a-4eff-8469-89ef1e21510a
Description
Field Type Long Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
0 No
1 Yes

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection operable

Hydrant Maintenance Inspection_inspgroup_d0eae362-17e9-4e29-81d7-aecd4ca007f5

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_inspgroup_d0eae362-17e9-4e29-81d7-aecd4ca007f5
Description
Field Type String
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
0 Water Company
1 Fire Department
2 Contractor

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection inspgroup

Hydrant Maintenance Inspection_firestation_0ffe772d-fdeb-4d73-85a9-a34fcd2ccaca

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_firestation_0ffe772d-fdeb-4d73-85a9-a34fcd2ccaca
Description
Field Type String
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 10
# of Assignments 1

DomainCodedValue

Code Description Details
1 Station 1
2 Station 2
3 Station 3
4 Station 4
5 Station 5
6 Station 6
7 Station 7
8 Station 8
9 Station 9
10 Station 10

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection firestation

Hydrant Maintenance Inspection_inspectiontype_2bdda6ca-e3b6-4401-80bd-0391eb45d210

Properties

Key Value
Owner
Domain Name Hydrant Maintenance Inspection_inspectiontype_2bdda6ca-e3b6-4401-80bd-0391eb45d210
Description
Field Type Long Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 2
# of Assignments 1

DomainCodedValue

Code Description Details
3 Flow Test
2 Flush

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010070Hydrant_Maintenance_Inspection inspectiontype

5_Yes_No_Not_Applicable

Properties

Key Value
Owner
Domain Name 5_Yes_No_Not_Applicable
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 4
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Yes
2 No
3 N/A

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010020System_Valve_Inspection paved

System Valve Inspection_other_91ad1659e607423993cbaaec835fe2f2

Properties

Key Value
Owner
Domain Name System Valve Inspection_other_91ad1659e607423993cbaaec835fe2f2
Description
Field Type Short Integer
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 3
# of Assignments 1

DomainCodedValue

Code Description Details
0 Unknown
1 Yes
2 No

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5010020System_Valve_Inspection other

ManufactureTypes

Properties

Key Value
Owner
Domain Name ManufactureTypes
Description
Field Type String
Domain Type Coded Value
Split Policy Default Value
Merge Policy Default Value
# of Codes 11
# of Assignments 1

DomainCodedValue

Code Description Details
Ames Ames Company Inc
BAVCO BAVCO
Cla-Val Cla-Val
Conbraco Industries Conbraco Industries Inc
Febco Febco Backflow Prevention
Danfoss Flomatic Danfoss Flomatic Valve
Mid-West Instrument Mid-West Instrument
Watts Watts Regulator
Hunter Industries Hunter Industries
Wilkins Wilkins/Zurn Industries
Other Other

DomainUsage

Dataset Subtype Code Subtype Name Field Name
L5050030Backflow_Inspection MANUFACTURER