Water Distribution System

Workspace

Key	Value
Name	WaterDistributionSystem_146ebd1664d745878356f5f6cda9c411
Workspace Type	Remote Database
Workspace Factory	Feature Service DB
Geodatabase Release
Date Exported	2025-06-09 13:48:23
Path

Domain Name	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
5_Water_Valve_Surface_Type	Short Integer	Coded Value	Duplicate	Default Value	8	1
5_Yes_No	Short Integer	Coded Value	Duplicate	Default Value	3	4
5_Yes_No_Not_Applicable	Short Integer	Coded Value	Default Value	Default Value	4	1
adoptionstatus	String	Coded Value	Default Value	Default Value	2	1
Asset_Manager	Short Integer	Coded Value	Duplicate	Default Value	3	19
Asset_Owner	Short Integer	Coded Value	Duplicate	Default Value	3	19
Asset_Type_Structure_Boundary_Water_Pump_Station_Boundary	Short Integer	Coded Value	Duplicate	Default Value	3	1
Asset_Type_Structure_Boundary_Water_Storage_Boundary	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Structure_Boundary_Water_Supply_Boundary	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Structure_Line_Pipeline_Casing	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Water_Assembly_Backflow	Short Integer	Coded Value	Duplicate	Default Value	5	1
Asset_Type_Water_Device_Fire_Hydrant	Short Integer	Coded Value	Duplicate	Default Value	2	1
Asset_Type_Water_Device_Flow_Valve	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Water_Device_Flushing_and_Blow_Off	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Water_Device_Pressure_Valve	Short Integer	Coded Value	Duplicate	Default Value	9	1
Asset_Type_Water_Device_Pump	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Water_Device_Service_Connection	Short Integer	Coded Value	Duplicate	Default Value	6	1
Asset_Type_Water_Device_Service_Meter	Short Integer	Coded Value	Default Value	Default Value	6	1
Asset_Type_Water_Device_Service_Valve	Short Integer	Coded Value	Default Value	Default Value	7	1
Asset_Type_Water_Device_Storage	Short Integer	Coded Value	Duplicate	Default Value	7	1
Asset_Type_Water_Device_Supply_WellType	Short Integer	Coded Value	Duplicate	Default Value	4	1
Asset_Type_Water_Device_System_Meter	Short Integer	Coded Value	Duplicate	Default Value	5	1
Asset_Type_Water_Device_System_Valve	Short Integer	Coded Value	Default Value	Default Value	7	1
Asset_Type_Water_Junction_Fitting	Short Integer	Coded Value	Duplicate	Default Value	23	1
Asset_Type_Water_Line_Service	Short Integer	Coded Value	Duplicate	Default Value	10	1
Asset_Type_Water_Line_Water_Main	Short Integer	Coded Value	Duplicate	Default Value	6	1
Boolean	Short Integer	Coded Value	Duplicate	Default Value	2	3
ESRI_FIX_TYPE_DOMAIN	Short Integer	Coded Value	Default Value	Default Value	5	20
ESRI_NUM_SATS_DOMAIN	Short Integer	Range	Default Value	Default Value		17
ESRI_POSITIONSOURCETYPE_DOMAIN	Short Integer	Coded Value	Default Value	Default Value	5	12
ESRI_POSITIONSOURCETYPE_DOMAIN_1	Short Integer	Coded Value	Default Value	Default Value	6	4
ESRI_STATION_ID_DOMAIN	Short Integer	Range	Default Value	Default Value		17
Fire Hydrant_assignmenttype_efa6b5d1-cd1e-4fe2-8746-628b3c7eaf2c	Long Integer	Coded Value	Default Value	Default Value	2	1
Fire Hydrant_publicview_319bb766-c618-4e85-8d04-d2f58c09ef8e	String	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_chains_f7c75bbca8dc40c6a4d7c30445310227	Short Integer	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_drain_b80965260b1d4c8690d6649a159175b0	Short Integer	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_firestation_0ffe772d-fdeb-4d73-85a9-a34fcd2ccaca	String	Coded Value	Default Value	Default Value	10	1
Hydrant Maintenance Inspection_flush_0cccffac-e40c-45b3-889f-ac409c4a1161	Long Integer	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_greased_0186ba99e1554fec89b95b1b8c51337e	Short Integer	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_inspectiontype_2bdda6ca-e3b6-4401-80bd-0391eb45d210	Long Integer	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_inspgroup_d0eae362-17e9-4e29-81d7-aecd4ca007f5	String	Coded Value	Default Value	Default Value	3	1
Hydrant Maintenance Inspection_leaking_6fa17eff-3cb0-4729-8506-1eec6c7c56eb	Long Integer	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_maintstatus_68a309a0-672b-4fee-819f-635cc4cfd004	Long Integer	Coded Value	Default Value	Default Value	6	1
Hydrant Maintenance Inspection_marker_2fb27f8ccf204b2d9ef394a6f8293b9d	Short Integer	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_oil_d1f325d0a3494231931b0cd0b3b480a3	Short Integer	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_operable_6ca7468d-cf1a-4eff-8469-89ef1e21510a	Long Integer	Coded Value	Default Value	Default Value	2	1
Hydrant Maintenance Inspection_paint_eeea61eaf35b4178860faff2c273b13d	Short Integer	Coded Value	Default Value	Default Value	2	1
Lifecycle	Short Integer	Coded Value	Duplicate	Default Value	10	23
ManufactureTypes	String	Coded Value	Default Value	Default Value	11	1
Pipeline_Casing_Diameter	Double	Coded Value	Duplicate	Default Value	23	1
Pipeline_Casing_Fill_Type	Short Integer	Coded Value	Duplicate	Default Value	4	1
Pipeline_Valve_Close_Direction	Short Integer	Coded Value	Duplicate	Default Value	2	2
Pipeline_Valve_Status	Short Integer	Coded Value	Duplicate	Default Value	2	2
Spatial_Confidence	Short Integer	Coded Value	Duplicate	Default Value	4	23
Spatial_Source	Short Integer	Coded Value	Duplicate	Default Value	6	23
Symbol_Rotation	Short Integer	Range	Duplicate	Default Value		17
System Valve Inspection_lube_27884b99f1d64dcfad6b092d9cdd80fe	Short Integer	Coded Value	Default Value	Default Value	3	1
System Valve Inspection_other_91ad1659e607423993cbaaec835fe2f2	Short Integer	Coded Value	Default Value	Default Value	3	1
Water_Diameter	Double	Coded Value	Duplicate	Default Value	30	4
Water_Fire_Hydrant_Manufacturer	Short Integer	Coded Value	Default Value	Default Value	15	1
Water_Fitting_Diameter	Double	Coded Value	Duplicate	Default Value	103	1
Water_Hydrant_Nozzle_Diameter	Double	Coded Value	Duplicate	Default Value	7	1
Water_Hydrant_Service_Diameter	Double	Coded Value	Duplicate	Default Value	7	1
Water_Interconnect_Connection_Type	Short Integer	Coded Value	Default Value	Default Value	3	1
Water_Main_Diameter	Double	Coded Value	Duplicate	Default Value	22	1
Water_Main_Material	Short Integer	Coded Value	Duplicate	Default Value	29	1
Water_Meter_Diameter	Double	Coded Value	Duplicate	Default Value	24	2
Water_Pump_Diameter	Double	Coded Value	Duplicate	Default Value	14	2
Water_Pump_Type	Short Integer	Coded Value	Duplicate	Default Value	7	1
Water_Sample_Type	Short Integer	Coded Value	Default Value	Default Value	3	1
Water_Service_Diameter	Double	Coded Value	Duplicate	Default Value	16	1
Water_Service_Material	Short Integer	Coded Value	Duplicate	Default Value	6	1
Water_Supply_Filtration_Type	Short Integer	Coded Value	Default Value	Default Value	6	2
Water_Treatment_Plant_Type	Short Integer	Coded Value	Default Value	Default Value	3	1
Water_Type	Short Integer	Coded Value	Duplicate	Default Value	7	2
Water_Valve_Type	Short Integer	Coded Value	Duplicate	Default Value	6	2
Yes_No	Short Integer	Coded Value	Duplicate	Default Value	3	7

Datasets

Backflow

Properties

Key	Value
Name	Backflow
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{67D0ABFB-396E-43D4-BD68-01C0146B6467}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
objectid	objectid	OID	Index	False			0	0	False	True	Unique identifier for each feature in the layer
assettype	Asset type	Short Integer		False	Asset_Type_Water_Assembly_Backflow	0	0	0	True	False	Categorization of the backflow asset based on its type
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the asset for tracking purposes
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current stage or condition of the asset in its lifecycle
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
locked	Locked	Short Integer		True	Yes_No	0	0	0	True	False	Indicates whether the asset is locked or accessible
manufacturer	Manufacturer	Long Integer		True			0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Specific model designation of the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity or organization that owns the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__5242E6328453B46E	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_146ebd1664d745878356f5f6cda9c411_BACKFLOW_Shape_sidx	False	True	Shape

Backflow_Inspection

Properties

Key	Value
Name	Backflow_Inspection
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	Backflow Inspection
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{522E0B35-44CD-43F5-A191-CB4163C88858}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D8548BF8B8B	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

Fire_Hydrant

Properties

Key	Value
Name	Fire_Hydrant
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{0D20835B-A02D-4A93-BD5A-FAEF207A031A}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the type of water distribution asset
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the asset for tracking purposes
diameter	Diameter	Double		True	Water_Hydrant_Service_Diameter	0	0	0	True	False	Measurement of the main diameter of the fire hydrant
secondarydiameter	Nozzle Diameter	Double		True	Water_Hydrant_Nozzle_Diameter	0	0	0	True	False	Measurement of the nozzle diameter of the fire hydrant
manufacturer	Manufacturer	Short Integer		True	Water_Fire_Hydrant_Manufacturer		0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Specific model designation of the fire hydrant
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status in the lifecycle of the fire hydrant
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the fire hydrant
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the fire hydrant
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
assignmenttype	Assignment Type	Long Integer		True	Fire Hydrant_assignmenttype_efa6b5d1-cd1e-4fe2-8746-628b3c7eaf2c		0	0	True	False	Type of task assigned for the fire hydrant
assignmentdue	Assignment Due	Date		True			1	8	True	False	Deadline for completing the assigned task
assignedon	Assigned On	Date		True			1	8	True	False	Date when the task was assigned
station	Assigned Station	String		True			0	255	True	False	Station associated with the assigned task
shift	Assigned Shift	String		True			0	255	True	False	Shift associated with the assigned task
adoptionstatus	Adoption Status	String		True	adoptionstatus		0	255	True	False	Status indicating whether the fire hydrant is adopted
nickname	Nickname	String		True			0	255	True	False	Informal name or alias for the fire hydrant
publicview	Public View	String		True	Fire Hydrant_publicview_319bb766-c618-4e85-8d04-d2f58c09ef8e		0	255	True	False	Visibility of the fire hydrant to the public
adoptedby	Adopted By	String		True			0	255	True	False	Person or entity that adopted the fire hydrant
adoptedon	Adopted On	Date		True			1	8	True	False	Date when the fire hydrant was adopted
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D857F5B36C5	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_146ebd1664d745878356f5f6cda9c411_FIRE_HYDRANT_Shape_sidx	False	True	Shape

Fitting

Properties

Key	Value
Name	Fitting
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{C06B7E29-D8FB-4497-8885-B2F57626D283}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the fitting based on its type
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status of the fitting in its lifecycle
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the fitting
diameter	Diameter	Double		True	Water_Fitting_Diameter	0	0	0	True	False	Measurement of the fitting's diameter
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the fitting
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D8504FE4407	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_146ebd1664d745878356f5f6cda9c411_FITTING_Shape_sidx	False	True	Shape

Flow_Valve

Properties

Key	Value
Name	Flow_Valve
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{A0539444-8BEE-4B87-B8CD-A0071FD3628C}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the type of water distribution asset
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
diameter	Diameter	Double		True	Water_Diameter	0	0	0	True	False	Measurement of the asset's diameter
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status in the asset's lifecycle
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
manufacturer	Manufacturer	Long Integer		True			0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Reference to the specific model of the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D851A3AD987	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_146ebd1664d745878356f5f6cda9c411_FLOW_VALVE_Shape_sidx	False	True	Shape

Flushing_and_Blow_Off

Properties

Key	Value
Name	Flushing_and_Blow_Off
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{F184202E-7AB9-41DB-A6C4-CCBCEF85832B}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for each feature in the dataset
assettype	Asset type	Short Integer		False	Asset_Type_Water_Device_Flushing_and_Blow_Off	0	0	0	True	False	Categorization of the asset based on its function or type
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
name	Name	String		True			0	64	True	False	Descriptive name or label for the asset
manufacturer	Manufacturer	Long Integer		True			0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Specific version or design of the asset produced by the manufacturer
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current stage or condition in the asset's lifecycle
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was decommissioned or retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity or organization that owns the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D8543E0D004	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_146ebd1664d745878356f5f6cda9c411_FLUSHING_AND_BLOW_OFF_Shape_sidx	False	True	Shape

Hydrant_Maintenance_Inspection

Properties

Key	Value
Name	Hydrant_Maintenance_Inspection
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	Hydrant Maintenance Inspection
OID Field	OBJECTID
GlobalID Field	globalid
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{BEAEDBEB-5FF3-43F7-B3A5-643D5AF2AAB0}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False		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	True	False	Indicates the current status of maintenance activities for the hydrant
inspector	Inspector	String		True		0	50	True	False	Name or identifier of the person who performed the inspection
insdate	Inspection Date	Date		True		1	8	True	False	Date when the inspection was conducted
chains	Are chains missing?	Short Integer		True	Hydrant Maintenance Inspection_chains_f7c75bbca8dc40c6a4d7c30445310227	0	0	True	False	Specifies whether the chains on the hydrant are missing
paint	Needs to be painted?	Short Integer		True	Hydrant Maintenance Inspection_paint_eeea61eaf35b4178860faff2c273b13d	0	0	True	False	Indicates if the hydrant requires painting
marker	Needs marker?	Short Integer		True	Hydrant Maintenance Inspection_marker_2fb27f8ccf204b2d9ef394a6f8293b9d	0	0	True	False	Specifies if a marker is needed for the hydrant
oil	Needs lubrication?	Short Integer		True	Hydrant Maintenance Inspection_oil_d1f325d0a3494231931b0cd0b3b480a3	0	0	True	False	Indicates if the hydrant requires lubrication
greased	Needs grease?	Short Integer		True	Hydrant Maintenance Inspection_greased_0186ba99e1554fec89b95b1b8c51337e	0	0	True	False	Specifies if the hydrant needs to be greased
drain	Drains correctly?	Short Integer		True	Hydrant Maintenance Inspection_drain_b80965260b1d4c8690d6649a159175b0	0	0	True	False	Indicates whether the hydrant drains correctly
notes	Notes	String		True		0	2000	True	False	Additional comments or observations related to the inspection
pressure	Pressure	Double		True		0	0	True	False	Measurement of the water pressure at the hydrant
flowrate	Flow Rate	Double		True		0	0	True	False	Rate at which water flows from the hydrant during testing
flowduration	Flow Duration	Double		True		0	0	True	False	Duration of the water flow during testing
assetguid	Asset GlobalID	GUID	Index	True		0	38	True	False	Globally unique identifier for the asset
globalid	GlobalID	Global ID	Index	False		0	38	False	True	Globally unique identifier for the feature
leaking	Is the hydrant leaking?	Long Integer		True	Hydrant Maintenance Inspection_leaking_6fa17eff-3cb0-4729-8506-1eec6c7c56eb	0	0	True	False	Indicates if the hydrant is leaking water
operable	Is the hydrant operable?	Long Integer		True	Hydrant Maintenance Inspection_operable_6ca7468d-cf1a-4eff-8469-89ef1e21510a	0	0	True	False	Specifies whether the hydrant is functional and operable
inspgroup	Inspection Group	String		True	Hydrant Maintenance Inspection_inspgroup_d0eae362-17e9-4e29-81d7-aecd4ca007f5	0	75	True	False	Group or organization responsible for the inspection
firestation	Fire Station	String		True	Hydrant Maintenance Inspection_firestation_0ffe772d-fdeb-4d73-85a9-a34fcd2ccaca	0	75	True	False	Fire station associated with the hydrant inspection
totalused	Total Water Used	Double		True		0	0	True	False	Total amount of water used during the inspection or testing
inspectiontype	Inspection Type	Long Integer		True	Hydrant Maintenance Inspection_inspectiontype_2bdda6ca-e3b6-4401-80bd-0391eb45d210	0	0	True	False	Type of inspection performed on the hydrant
dischargecoe	Discharge Coefficient	Double		True		0	0	True	False	Coefficient used to calculate the discharge rate of the hydrant
outletdiameter	Outlet Diameter	Double		True		0	0	True	False	Diameter of the hydrant outlet used during testing
discharge	Available Fire Flow	Double		True		0	0	True	False	Amount of fire flow available from the hydrant
staticpressure	Static Pressure	Double		True		0	0	True	False	Water pressure in the hydrant when no flow is occurring
residualpressure	Residual Pressure	Long Integer		True		0	0	True	False	Water pressure in the hydrant during flow testing
flush	Flush	Long Integer		True	Hydrant Maintenance Inspection_flush_0cccffac-e40c-45b3-889f-ac409c4a1161	0	0	True	False	Indicates whether the hydrant was flushed during the inspection
pitotpressure	Pitot Pressure	Double		True		0	0	True	False	Pressure measured using a pitot tube during flow testing
created_user	Creator	String	Creator;Index	True		0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True		1	8	False	True	Records the date and time the record was created
last_edited_user	Editor	String	Editor;Index	True		0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True		1	8	False	True	Date and time of the most recent modification to the record

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D8522626979	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

Hydrant_Relate

Properties

Key	Value
Name	Hydrant_Relate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	Hydrant Relate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{C79D1665-9344-4F3E-973E-423F1D37D044}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D855DB9A3DA	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

Interconnect

Properties

Key	Value
Name	Interconnect
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{FE423343-B567-4823-8CFB-19E25AEF4723}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}
Details	A featuer layer view with full editing capabilities.

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
permittedflow	Permitted Flow	Double		True			0	0	True	False	Maximum flow rate allowed for the asset
availableflow	Available Flow	Double		True			0	0	True	False	Flow rate currently available for use
emergency	Emergency Only	Short Integer		True	5_Yes_No		0	0	True	False	Indicates if the asset is for emergency use only
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for the feature in the database
assettype	Connection Type	Short Integer		True	Water_Interconnect_Connection_Type		0	0	True	False	Type of connection associated with the asset
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
name	Name	String		True			0	64	True	False	Descriptive name of the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		True	Lifecycle	8	0	0	True	False	Current status in the asset's lifecycle
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN_1		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D854179072D	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_146ebd1664d745878356f5f6cda9c411_INTERCONNECT_Shape_sidx	False	True	Shape

Meter_Relate

Properties

Key	Value
Name	Meter_Relate
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	Meter Relate
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	created_user
Create Date Field	created_date
Editor Field	last_edited_user
Edit Date Field	last_edited_date
Catalog ID	{6186703B-75A0-4091-8FFD-DDD32AC18EEC}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D858CF80F4A	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

Pipe_Casing

Properties

Key	Value
Name	Pipe_Casing
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{DDD1D771-F958-40A8-8C63-8E6166F4185A}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the type of asset represented by the feature
assetid	Asset ID	String		True			0	64	True	False	Identifier used to track the specific asset
diameter	Diameter	Double		True	Pipeline_Casing_Diameter	0	0	0	True	False	Measurement of the width of the pipe casing
filltype	Fill Type	Short Integer		True	Pipeline_Casing_Fill_Type	0	0	0	True	False	Material used to fill the pipe casing
measuredlength	Measured Length	Double		True			0	0	True	False	Length of the pipe casing as measured in the field
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status in the lifecycle of the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	0	0	True	False	Level of confidence in the accuracy of the spatial data
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
esrignss_avg_h_rms	Average horizontal accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
esrignss_avg_v_rms	Average vertical accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
esrignss_worst_h_rms	Worst horizontal accuracy (m)	Double		True			0	0	True	False	Worst horizontal accuracy of GNSS measurements in meters
esrignss_worst_v_rms	Worst vertical accuracy (m)	Double		True			0	0	True	False	Worst vertical accuracy of GNSS measurements in meters
esrignss_worst_fixtype	Worst fix type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix with the worst accuracy
esrignss_manual_locations	Number of manual locations	Long Integer		True			0	0	True	False	Count of manually recorded GNSS locations
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Length of the geometry associated with the feature
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D853830A09B	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_146ebd1664d745878356f5f6cda9c411_PIPE_CASING_Shape_sidx	False	True	Shape

Pressure_Valve

Properties

Key	Value
Name	Pressure_Valve
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{4308A246-0DD6-458C-BD57-E0D80A279170}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the pressure valve based on its type
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the specific asset
diameter	Diameter	Double		True	Water_Diameter	0	0	0	True	False	Measurement of the valve's diameter
pressure	Pressure	Double		True			0	0	True	False	Pressure rating or capacity of the valve
manufacturer	Manufacturer	Long Integer		True			0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Specific model designation of the valve
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status in the lifecycle of the valve
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the valve
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the valve
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85C1824410	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_146ebd1664d745878356f5f6cda9c411_PRESSURE_VALVE_Shape_sidx	False	True	Shape

Pump

Properties

Key	Value
Name	Pump
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{5CF49BA9-9F1B-4B04-810C-41B474105D7A}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the pump based on its function or type
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
diameter	Inlet Diameter	Double		True	Water_Pump_Diameter	0	0	0	True	False	Measurement of the inlet diameter of the pump
secondarydiameter	Outlet Diameter	Double		True	Water_Pump_Diameter	0	0	0	True	False	Measurement of the outlet diameter of the pump
pressure	Rated Pressure	Double		True			0	0	True	False	Maximum pressure rating for the pump
manufacturer	Manufacturer	Long Integer		True			0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Reference to the specific model of the pump
designtype	Pump Type	Short Integer		True	Water_Pump_Type	0	0	0	True	False	Classification of the pump based on its design
designinfo	Rated Flow	Double		True			0	0	True	False	Flow rate specification for the pump
operable	Operable	Short Integer		False	Boolean	1	0	0	True	False	Indicates whether the pump is functional
name	Name	String		True			0	64	True	False	Name or label assigned to the pump
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status of the pump in its lifecycle
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the pump
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the pump
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85A2ADA3FB	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_146ebd1664d745878356f5f6cda9c411_PUMP_Shape_sidx	False	True	Shape

Sample_Station

Properties

Key	Value
Name	Sample_Station
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{D3A6FAD2-0F86-47FA-9EAA-D9F91E279659}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}
Details	A featuer layer view with full editing capabilities.

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
stationlocation	Sample Station Location	String		True			0	255	True	False	Location of the sample station
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for each record in the dataset
assetid	Sample Station ID	String		True			0	64	True	False	Identifier for the sample station asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		True	Lifecycle	8	0	0	True	False	Current status in the asset's lifecycle
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN_1		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85ADC846E7	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_146ebd1664d745878356f5f6cda9c411_SAMPLE_STATION_Shape_sidx	False	True	Shape

Service

Properties

Key	Value
Name	Service
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{BD5C628D-61DA-4FFA-AF91-A8ABD373CEA9}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the type of water distribution asset
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the specific asset
diameter	Diameter	Double		True	Water_Service_Diameter		0	0	True	False	Measurement of the asset's diameter
material	Material	Short Integer		True	Water_Service_Material	0	0	0	True	False	Composition of the asset's construction material
designtype	Water Type	Short Integer		True	Water_Type	1	0	0	True	False	Classification of the water type associated with the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status in the asset's lifecycle
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
measuredlength	Measured Length	Double		True			0	0	True	False	Recorded length of the asset
adddetails	Tracer Wire	Short Integer		True	Yes_No	0	0	0	True	False	Indicates whether tracer wire is present
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	0	0	True	False	Level of confidence in the accuracy of the spatial data
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
esrignss_avg_h_rms	Average horizontal accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
esrignss_avg_v_rms	Average vertical accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
esrignss_worst_h_rms	Worst horizontal accuracy (m)	Double		True			0	0	True	False	Worst horizontal accuracy of GNSS measurements in meters
esrignss_worst_v_rms	Worst vertical accuracy (m)	Double		True			0	0	True	False	Worst vertical accuracy of GNSS measurements in meters
esrignss_worst_fixtype	Worst fix type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix with the worst accuracy
esrignss_manual_locations	Number of manual locations	Long Integer		True			0	0	True	False	Count of manually recorded GNSS locations
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Length of the geometry associated with the feature
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85087C0303	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_146ebd1664d745878356f5f6cda9c411_SERVICE_Shape_sidx	False	True	Shape

Service_Connection

Properties

Key	Value
Name	Service_Connection
Dataset Type	FeatureClass
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
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	-13922544.80434906
X-Max	-7435795.38720206
Y-Min	2749288.308982668
Y-Max	6339991.598461661
Catalog ID	{10F2BD4F-48AD-41AE-BA9A-0AE10C577F48}
Class ID	{52353152-891A-11D0-BEC6-00805F7C4268}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the service connection based on its type
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the asset for tracking purposes
accountid	Account ID	String		True			0	50	True	False	Identifier associated with the account linked to the service connection
additionaldetails	Critical	Short Integer		True	Yes_No	2	0	0	True	False	Indicates whether the service connection is critical
additionaldevice	Metered	Short Integer		True	Yes_No	2	0	0	True	False	Specifies if the service connection is metered
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status of the service connection in its lifecycle
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the service connection
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the service connection
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D852BE20CBC	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_146ebd1664d745878356f5f6cda9c411_SERVICE_CONNECTION_Shape_sidx	False	True	Shape

Service_Meter

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for each feature in the layer
assettype	Asset type	Short Integer		False	Asset_Type_Water_Device_Service_Meter	0	0	0	True	False	Categorization of the type of water distribution asset
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the specific asset
accountid	Account ID	String		True			0	50	True	False	Identifier for the account associated with the asset
diameter	Diameter	Double		True	Water_Meter_Diameter	0	0	0	True	False	Measurement of the asset's diameter
manufacturer	Manufacturer	Long Integer		True			0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Reference to the specific model of the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status in the asset's lifecycle
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Service_Territory

Properties

Fields

Indexes

Service_Valve

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the type of water distribution asset
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
diameter	Diameter	Double		True	Water_Diameter	0	0	0	True	False	Measurement of the asset's diameter
manufacturer	Manufacturer	Long Integer		True			0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Reference to the specific model of the asset
designtype	Valve Type	Short Integer		True	Water_Valve_Type	0	0	0	True	False	Classification of the valve design
presentstatus	Valve Status	Short Integer		True	Pipeline_Valve_Status	1	0	0	True	False	Current operational status of the valve
additionaldetails	Clockwise to Close	Short Integer		True	Pipeline_Valve_Close_Direction		0	0	True	False	Indicates the direction required to close the valve
designinfo	Turns to Close	Double		True			0	0	True	False	Number of turns needed to close the valve
operable	Operable	Short Integer		False	Boolean	1	0	0	True	False	Indicates whether the asset is functional
operator	Postindicator Valve	Short Integer		True	Yes_No		0	0	True	False	Specifies if the valve has a post-indicator
name	Name	String		True			0	64	True	False	Name or label assigned to the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Stage of the asset in its lifecycle
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Storage

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for each feature in the dataset
assettype	Asset type	Short Integer		False	Asset_Type_Water_Device_Storage	0	0	0	True	False	Categorization of the type of water storage asset
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the asset for tracking purposes
diameter	Height	Double		True			0	0	True	False	Vertical measurement of the storage asset
secondarydiameter	Width	Double		True			0	0	True	False	Horizontal measurement of the storage asset
pressure	Volume	Double		True			0	0	True	False	Capacity or volume of the storage asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current phase or status in the asset's lifecycle
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity or organization that owns the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

System_Meter

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the type of water distribution asset
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
accountid	Account ID	String		True			0	50	True	False	Identifier for the account associated with the asset
diameter	Diameter	Double		True	Water_Meter_Diameter	0	0	0	True	False	Measurement of the asset's diameter
manufacturer	Manufacturer	Long Integer		True			0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Reference to the specific model of the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status in the asset's lifecycle
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

System_Valve

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the valve based on its function or type
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the asset for tracking purposes
diameter	Diameter	Double		True	Water_Diameter	0	0	0	True	False	Measurement of the valve's diameter
manufacturer	Manufacturer	Long Integer		True			0	0	True	False	Name of the company that produced the asset
model	Model	Long Integer		True			0	0	True	False	Specific model designation of the valve
designtype	Valve Type	Short Integer		True	Water_Valve_Type	0	0	0	True	False	Classification of the valve based on its design
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current stage in the lifecycle of the valve
presentstatus	Valve Status	Short Integer		True	Pipeline_Valve_Status	1	0	0	True	False	Operational state of the valve
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
additionaldetails	Clockwise to Close	Short Integer		True	Pipeline_Valve_Close_Direction		0	0	True	False	Indicates the direction required to close the valve
designinfo	Turns to Close	Double		True			0	0	True	False	Number of turns needed to fully close the valve
operable	Operable	Short Integer		False	Boolean	1	0	0	True	False	Indicates whether the valve is functional
name	Name	String		True			0	64	True	False	Name or label assigned to the valve
additionaldevice	Has Bypass	Short Integer		True	Yes_No	0	0	0	True	False	Indicates if the valve includes a bypass feature
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the valve
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the valve
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

System_Valve_Inspection

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for each record in the dataset
paved	Paved over?	Short Integer		True	5_Yes_No_Not_Applicable	0	0	0	True	False	Indicates whether the valve is paved over
gsurface	Ground Surface	Short Integer		True	5_Water_Valve_Surface_Type		0	0	True	False	Specifies the type of ground surface around the valve
fintorque	Final Torque	Double		True			0	0	True	False	Records the final torque applied during inspection
depthtonut	Depth To Nut	Double		True			0	0	True	False	Measures the depth to the valve nut
turns	# of Turns	Double		True			0	0	True	False	Counts the number of turns required to operate the valve
operator	Name of Operator	String		True			0	100	True	False	Stores the name of the operator performing the inspection
stem	Stem OK?	Short Integer		True	5_Yes_No		0	0	True	False	Indicates the condition of the valve stem
package	Packing OK?	Short Integer		True	5_Yes_No		0	0	True	False	Represents the condition of the valve packing
gears	Gears OK?	Short Integer		True	5_Yes_No		0	0	True	False	Shows whether the valve gears are functioning properly
lube	Needs lubrication?	Short Integer		True	System Valve Inspection_lube_27884b99f1d64dcfad6b092d9cdd80fe		0	0	True	False	Specifies if the valve requires lubrication
other	Other maintenance required?	Short Integer		True	System Valve Inspection_other_91ad1659e607423993cbaaec835fe2f2		0	0	True	False	Indicates if additional maintenance is needed for the valve
notes	Notes	String		True			0	2000	True	False	Provides space for additional comments or observations
insdate	Inspection Date	Date		True			1	8	True	False	Records the date of the valve inspection
assetguid	Asset GlobalID	GUID	Index	True			0	38	True	False	Globally unique identifier for the asset
globalid	GlobalID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
created_user	Creator	String	Creator;Index	True			0	255	False	True	Records the date and time the record was created
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Records the date and time the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record

Indexes

Treatment_Plant

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
permittedcapacity	Permitted Capacity	Double		True			0	0	True	False	Maximum capacity allowed for the treatment plant
ratedcapacity	Rated Capacity	Double		True			0	0	True	False	Designed operational capacity of the treatment plant
averagedailyflow	Average Daily Flow	Double		True			0	0	True	False	Average daily water flow processed by the treatment plant
filtrationtype	Filtration Type	Short Integer		True	Water_Supply_Filtration_Type		0	0	True	False	Type of filtration system used in the treatment plant
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for the feature in the layer
assettype	Treatment Plant Type	Short Integer		True	Water_Treatment_Plant_Type		0	0	True	False	Category of the treatment plant based on its water source
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
name	Name	String		True			0	64	True	False	Name of the treatment plant or asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		True	Lifecycle	8	0	0	True	False	Current status in the lifecycle of the asset
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN_1		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Water_Main

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the water main based on its function
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the water main asset
diameter	Diameter	Double		True	Water_Main_Diameter	0	0	0	True	False	Measurement of the water main's width
material	Material	Short Integer		True	Water_Main_Material	0	0	0	True	False	Type of material used to construct the water main
designtype	Water Type	Short Integer		True	Water_Type	1	0	0	True	False	Classification of the water main based on its water type
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status in the lifecycle of the water main
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the water main
measuredlength	Measured Length	Double		True			0	0	True	False	Recorded length of the water main
adddetails	Tracer Wire	Short Integer		True	Yes_No	0	0	0	True	False	Indicates whether tracer wire is present
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Entity responsible for owning the water main
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	0	0	True	False	Level of confidence in the accuracy of the spatial data
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
esrignss_avg_h_rms	Average horizontal accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
esrignss_avg_v_rms	Average vertical accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
esrignss_worst_h_rms	Worst horizontal accuracy (m)	Double		True			0	0	True	False	Worst horizontal accuracy of GNSS measurements in meters
esrignss_worst_v_rms	Worst vertical accuracy (m)	Double		True			0	0	True	False	Worst vertical accuracy of GNSS measurements in meters
esrignss_worst_fixtype	Worst fix type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix with the worst accuracy
esrignss_manual_locations	Number of manual locations	Long Integer		True			0	0	True	False	Count of manually recorded GNSS locations
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Length of the geometry representing the feature
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Water_Pump_Station_Boundary

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the asset based on its type or function
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
name	Name	String		True			0	64	True	False	Descriptive name of the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status of the asset within its lifecycle
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	0	0	True	False	Level of confidence in the accuracy of the spatial data
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape__Area	Shape__Area	Double	Area;Index	True			0	0	False	True	Calculated area of the feature's geometry
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Calculated perimeter length of the feature's geometry
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Water_Sample

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Precision	Length	Editable	Required	Details
testinfo	Test Information	String		True		0	255	True	False	Details or notes related to the water sample test
OBJECTID	OBJECTID	OID	Index	False		0	0	False	True	Unique identifier for the feature in the layer
sampleid	Sample ID	String		True		0	255	True	False	Identifier assigned to the water sample
samplelocation	Sample Location	String		True		0	255	True	False	Location where the water sample was collected
sampledate	Sample Date	Date		True		1	8	True	False	Date when the asset was retired
collectorname	Name of Collector	String		True		0	255	True	False	Person responsible for collecting the water sample
sampletype	Sample Type	Short Integer		True	Water_Sample_Type	0	0	True	False	Category or classification of the water sample
analysisdate	Date of Analysis	Date		True		1	8	True	False	Date when the water sample was analyzed
laboratoryname	Name of Laboratory	String		True		0	255	True	False	Name of the laboratory where the sample was analyzed
analystname	Name of Analyst	String		True		0	255	True	False	Name of the person who performed the analysis
analyticalmethod	Analytical Method	String		True		0	255	True	False	Procedure or technique used to analyze the water sample
analysisresults	Analysis Results	String		True		0	255	True	False	Outcome or findings from the water sample analysis
GlobalID	GlobalID	Global ID	Index	False		0	38	False	True	Globally unique identifier for the feature
samplestationGUID	samplestationGUID	GUID		True		0	38	True	False	Unique identifier for the sample station associated with the water sample
created_user	Creator	String	Creator;Index	True		0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True		1	8	False	True	Records the date and time the record was created
last_edited_user	Editor	String	Editor;Index	True		0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True		1	8	False	True	Date and time of the most recent modification to the record

Indexes

Water_Storage_Boundary

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the water storage asset based on its type
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the water storage asset
name	Name	String		True			0	64	True	False	Descriptive name of the water storage asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current status of the asset within its lifecycle
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Source of the spatial data used to define the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	0	0	True	False	Level of confidence in the accuracy of the spatial data
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape__Area	Shape__Area	Double	Area;Index	True			0	0	False	True	Calculated area of the feature's geometry
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Calculated perimeter length of the feature's geometry
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Water_Supply_Boundary

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False			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	True	False	Categorization of the water supply boundary asset
assetid	Asset ID	String		True			0	64	True	False	Identifier assigned to the asset for tracking purposes
name	Name	String		True			0	64	True	False	Descriptive name of the water supply boundary asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		False	Lifecycle	8	0	0	True	False	Current stage in the lifecycle of the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	0	0	0	True	False	Level of confidence in the accuracy of the spatial data
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Records the date and time the record was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape__Area	Shape__Area	Double	Area;Index	True			0	0	False	True	Calculated area of the feature's geometry
Shape__Length	Shape__Length	Double	Index;Length	True			0	0	False	True	Calculated perimeter length of the feature's geometry
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Well

Properties

Fields

Name	Alias	Type	Usage	Nullable	Domain	Default Value	Precision	Length	Editable	Required	Details
filtrationtype	Filtration Type	Short Integer		True	Water_Supply_Filtration_Type		0	0	True	False	Indicates the type of filtration system used for water treatment
boredepth	Bore Depth	Double		True			0	0	True	False	Represents the depth of the borehole in meters
aquiferdepth	Aquifer Depth	Double		True			0	0	True	False	Specifies the depth at which the aquifer is located
permittedflow	Permitted Flow	Double		True			0	0	True	False	Defines the maximum flow rate allowed for the well
availableflow	Available Flow	Double		True			0	0	True	False	Indicates the current flow rate available from the well
OBJECTID	OBJECTID	OID	Index	False			0	0	False	True	Unique identifier for the feature in the layer
assettype	Asset type	Short Integer		True	Asset_Type_Water_Device_Supply_WellType	0	0	0	True	False	Categorizes the type of water-related asset
assetid	Asset ID	String		True			0	64	True	False	Unique identifier assigned to the asset
name	Name	String		True			0	64	True	False	Name or label associated with the asset
installdate	Install Date	Date		True			1	8	True	False	Date when the asset was installed
lifecyclestatus	Lifecycle Status	Short Integer		True	Lifecycle	8	0	0	True	False	Represents the current lifecycle stage of the asset
notes	Notes	String		True			0	2000	True	False	Additional information or comments about the asset
lastmaint	Last Maintenance	Date		True			1	8	True	False	Date of the most recent maintenance performed on the asset
inservicedate	In-Service Date	Date		True			1	8	True	False	Date when the asset was put into active service
retireddate	Retired Date	Date		True			1	8	True	False	Date when the asset was retired
ownedby	Owned By	Short Integer		True	Asset_Owner	1	0	0	True	False	Indicates the entity that owns the asset
maintby	Maintained By	Short Integer		True	Asset_Manager	1	0	0	True	False	Entity or organization responsible for maintaining the asset
spatialsource	Spatial Source	Short Integer		True	Spatial_Source	0	0	0	True	False	Describes the source of spatial data for the asset's location
spatialconfidence	Spatial Confidence	Short Integer		True	Spatial_Confidence	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	True	False	Defines the rotation angle for the asset's symbol on the map
globalid	Global ID	Global ID	Index	False			0	38	False	True	Globally unique identifier for the feature
ESRIGNSS_POSITIONSOURCETYPE	Position source type	Short Integer		True	ESRI_POSITIONSOURCETYPE_DOMAIN_1		0	0	True	False	Indicates the type of position source used for GNSS data
ESRIGNSS_RECEIVER	Receiver Name	String		True			0	50	True	False	Name of the GNSS receiver used
ESRIGNSS_LATITUDE	Latitude	Double		True			0	0	True	False	Latitude coordinate of the asset
ESRIGNSS_LONGITUDE	Longitude	Double		True			0	0	True	False	Longitude coordinate of the asset
ESRIGNSS_ALTITUDE	Altitude	Double		True			0	0	True	False	Altitude of the asset's location above sea level
ESRIGNSS_H_RMS	Horizontal Accuracy (m)	Double		True			0	0	True	False	Horizontal accuracy of the GNSS measurement in meters
ESRIGNSS_V_RMS	Vertical Accuracy (m)	Double		True			0	0	True	False	Vertical accuracy of the GNSS measurement in meters
ESRIGNSS_FIXDATETIME	Fix Time	Date		True			1	8	True	False	Timestamp of the GNSS position fix
ESRIGNSS_FIXTYPE	Fix Type	Short Integer		True	ESRI_FIX_TYPE_DOMAIN		0	0	True	False	Type of GNSS fix obtained
ESRIGNSS_CORRECTIONAGE	Correction Age	Double		True			0	0	True	False	Age of the correction data used for GNSS positioning
ESRIGNSS_STATIONID	Station ID	Short Integer		True	ESRI_STATION_ID_DOMAIN		0	0	True	False	Identifier for the GNSS reference station
ESRIGNSS_NUMSATS	Number of Satellites	Short Integer		True	ESRI_NUM_SATS_DOMAIN		0	0	True	False	Number of satellites used for GNSS positioning
ESRIGNSS_PDOP	PDOP	Double		True			0	0	True	False	Positional dilution of precision for GNSS data
ESRIGNSS_HDOP	HDOP	Double		True			0	0	True	False	Horizontal dilution of precision for GNSS data
ESRIGNSS_VDOP	VDOP	Double		True			0	0	True	False	Vertical dilution of precision for GNSS data
ESRIGNSS_DIRECTION	Direction of travel (°)	Double		True			0	0	True	False	Direction of travel in degrees based on GNSS data
ESRIGNSS_SPEED	Speed (km/h)	Double		True			0	0	True	False	Speed of travel in kilometers per hour
ESRISNSR_AZIMUTH	Compass reading (°)	Double		True			0	0	True	False	Compass azimuth reading in degrees
ESRIGNSS_AVG_H_RMS	Average Horizontal Accuracy (m)	Double		True			0	0	True	False	Average horizontal accuracy of GNSS measurements
ESRIGNSS_AVG_V_RMS	Average Vertical Accuracy (m)	Double		True			0	0	True	False	Average vertical accuracy of GNSS measurements
ESRIGNSS_AVG_POSITIONS	Averaged Positions	Short Integer		True			0	0	True	False	Number of averaged GNSS positions
ESRIGNSS_H_STDDEV	Standard Deviation (m)	Double		True			0	0	True	False	Standard deviation of horizontal accuracy in meters
created_user	Creator	String	Creator;Index	True			0	255	False	True	User who created the feature
created_date	Creation Date	Date	Created;Index	True			1	8	False	True	Date and time when the feature was created
last_edited_user	Editor	String	Editor;Index	True			0	255	False	True	Tracks the user who last edited the record
last_edited_date	Edit Date	Date	Edited;Index	True			1	8	False	True	Date and time of the most recent modification to the record
Shape		Geometry	Index	True			0	0	True	True	Geometric representation of the feature

Indexes

Domains

5_Water_Valve_Surface_Type

5_Yes_No

5_Yes_No_Not_Applicable

adoptionstatus

Asset_Manager

Asset_Owner

Asset_Type_Structure_Boundary_Water_Pump_Station_Boundary

Asset_Type_Structure_Boundary_Water_Storage_Boundary

Asset_Type_Structure_Boundary_Water_Supply_Boundary

Asset_Type_Structure_Line_Pipeline_Casing

Asset_Type_Water_Assembly_Backflow

Asset_Type_Water_Device_Fire_Hydrant

Asset_Type_Water_Device_Flow_Valve

Asset_Type_Water_Device_Flushing_and_Blow_Off

Asset_Type_Water_Device_Pressure_Valve

Asset_Type_Water_Device_Pump

Asset_Type_Water_Device_Service_Connection

Asset_Type_Water_Device_Service_Meter

Asset_Type_Water_Device_Service_Valve

Asset_Type_Water_Device_Storage

Asset_Type_Water_Device_Supply_WellType

Asset_Type_Water_Device_System_Meter

Asset_Type_Water_Device_System_Valve

Asset_Type_Water_Junction_Fitting

Asset_Type_Water_Line_Service

Asset_Type_Water_Line_Water_Main

Boolean

ESRI_FIX_TYPE_DOMAIN

ESRI_NUM_SATS_DOMAIN

ESRI_POSITIONSOURCETYPE_DOMAIN

ESRI_POSITIONSOURCETYPE_DOMAIN_1

ESRI_STATION_ID_DOMAIN

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

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

Hydrant Maintenance Inspection_chains_f7c75bbca8dc40c6a4d7c30445310227

Hydrant Maintenance Inspection_drain_b80965260b1d4c8690d6649a159175b0

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

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

Hydrant Maintenance Inspection_greased_0186ba99e1554fec89b95b1b8c51337e

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

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

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

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

Hydrant Maintenance Inspection_marker_2fb27f8ccf204b2d9ef394a6f8293b9d

Hydrant Maintenance Inspection_oil_d1f325d0a3494231931b0cd0b3b480a3

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

Hydrant Maintenance Inspection_paint_eeea61eaf35b4178860faff2c273b13d

Lifecycle

ManufactureTypes

Pipeline_Casing_Diameter

Pipeline_Casing_Fill_Type

Pipeline_Valve_Close_Direction

Pipeline_Valve_Status

Spatial_Confidence

Spatial_Source

Symbol_Rotation

System Valve Inspection_lube_27884b99f1d64dcfad6b092d9cdd80fe

System Valve Inspection_other_91ad1659e607423993cbaaec835fe2f2

Water_Diameter

Water_Fire_Hydrant_Manufacturer

Water_Fitting_Diameter

Properties

Coded Values

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"

Domain Usage

Water_Hydrant_Nozzle_Diameter

Water_Hydrant_Service_Diameter

Water_Interconnect_Connection_Type

Water_Main_Diameter

Water_Main_Material

Water_Meter_Diameter

Water_Pump_Diameter

Water_Pump_Type

Water_Sample_Type

Water_Service_Diameter

Water_Service_Material

Water_Supply_Filtration_Type

Water_Treatment_Plant_Type

Water_Type

Water_Valve_Type

Yes_No

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D850857DBC9	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_146ebd1664d745878356f5f6cda9c411_SERVICE_METER_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__5242E632E3AC4E34	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_146ebd1664d745878356f5f6cda9c411_SERVICE_TERRITORY_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85C3D79054	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_146ebd1664d745878356f5f6cda9c411_SERVICE_VALVE_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D8580FBBC4F	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_146ebd1664d745878356f5f6cda9c411_STORAGE_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D8557FE1331	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_146ebd1664d745878356f5f6cda9c411_SYSTEM_METER_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D858DCD0BCE	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_146ebd1664d745878356f5f6cda9c411_SYSTEM_VALVE_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D854D711C26	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

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85D167EF15	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_146ebd1664d745878356f5f6cda9c411_TREATMENT_PLANT_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85E7E02AC8	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_146ebd1664d745878356f5f6cda9c411_WATER_MAIN_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D850231294E	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_146ebd1664d745878356f5f6cda9c411_WATER_PUMP_STATION_BOUNDARY_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85306B9F4A	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

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D852BE4971C	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_146ebd1664d745878356f5f6cda9c411_WATER_STORAGE_BOUNDARY_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85D41108EA	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_146ebd1664d745878356f5f6cda9c411_WATER_SUPPLY_BOUNDARY_Shape_sidx	False	True	Shape

Name	Is Unique	Is Ascending	Field Name
PK__WaterDis__F4B70D85BC5AD53D	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_146ebd1664d745878356f5f6cda9c411_WELL_Shape_sidx	False	True	Shape

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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