Geodatabase Documentation

Date: Wednesday, January 30, 2019
Time: 3:23:31 PM

Summary Information and Links

0 Feature Datasets and 9 Feature Classes
No Topology Datasets
No Geometric Networks
No Rasters
1 Table (Object Class)
2 Relationship Classes
25 Domains

Rasters

Workspace-Level Tables and Feature Classes

ValveInspection - Table
AirVacuumandAirReleaseAssembly - Feature Class
BackflowAssembly - Feature Class
BlowOffAssembly - Feature Class
FlowValve - Feature Class
FlushingandBlowOff - Feature Class
Outlet - Feature Class
PressureReducingStation - Feature Class
PressureValve - Feature Class
SystemValve - Feature Class

Relationship Classes

ValveInspection
ValveInspection2

Domains

Asset_Manager
Asset_Owner
Asset_Type_Water_Assembly_Air_Vacuum_&_Air_Release
Asset_Type_Water_Assembly_Backflow
Asset_Type_Water_Assembly_Blow_Off
Asset_Type_Water_Assembly_Pressure_Reducing_Station
Asset_Type_Water_Device_Control_Valve
Asset_Type_Water_Device_Flow_Valve
Asset_Type_Water_Device_Flushing_and_Blow_Off
Asset_Type_Water_Device_Outlet
Asset_Type_Water_Device_Pressure_Valve
Asset_Type_Water_Device_System_Valve
Boolean
ESRI_FIX_TYPE_DOMAIN
ESRI_NUM_SATS_DOMAIN
ESRI_STATION_ID_DOMAIN
Lifecycle_Combined
Pipe_Device_Status_Combined
Pipeline_Valve_Close_Direction
Symbol_Rotation
Water_Diameter
Water_Valve_Surface_Type
Water_Valve_Type
Yes_No
Yes_No_Not_Applicable

AirVacuumandAirReleaseAssembly - FeatureClass

Name AirVacuumandAirReleaseAssembly
ShapeType Point
FeatureType Simple
AliasName AirVacuumandAirReleaseAssembly
HasM false
HasZ false
HasAttachments false
Description AirVacuumandAirReleaseAssembly

Field DataType Length AliasName Description Domain DefaultValue IsNullable Precision Scale
assettype SmallInteger 2 Asset type assettype Asset_Type_Water_Assembly_Air_Vacuum_&_Air_Release false
creationdate Date 8 Creation date creationdate true
creator String 255 Creator creator true
lastupdate Date 8 Last update lastupdate true
updatedby String 255 Updated by updatedby true
globalid GlobalID 38 Global ID globalid false
installdate Date 8 Install Date installdate true
assetid String 64 Asset ID assetid true
notes String 2000 Notes notes false
symbolrotation SmallInteger 2 Symbol Rotation symbolrotation Symbol_Rotation true
lifecyclestatus SmallInteger 2 Lifecycle Status lifecyclestatus Lifecycle_Combined false
ESRIGNSS_RECEIVER String 50 Receiver Name ESRIGNSS_RECEIVER true
ESRIGNSS_H_RMS Double 8 Horizontal Accuracy (m) ESRIGNSS_H_RMS true
ESRIGNSS_V_RMS Double 8 Vertical Accuracy (m) ESRIGNSS_V_RMS true
ESRIGNSS_LATITUDE Double 8 Latitude ESRIGNSS_LATITUDE true
ESRIGNSS_LONGITUDE Double 8 Longitude ESRIGNSS_LONGITUDE true
ESRIGNSS_ALTITUDE Double 8 Altitude ESRIGNSS_ALTITUDE true
ESRIGNSS_PDOP Double 8 PDOP ESRIGNSS_PDOP true
ESRIGNSS_HDOP Double 8 HDOP ESRIGNSS_HDOP true
ESRIGNSS_VDOP Double 8 VDOP ESRIGNSS_VDOP true
ESRIGNSS_FIXTYPE SmallInteger 2 Fix Type ESRIGNSS_FIXTYPE ESRI_FIX_TYPE_DOMAIN true
ESRIGNSS_CORRECTIONAGE Double 8 Correction Age ESRIGNSS_CORRECTIONAGE true
ESRIGNSS_STATIONID SmallInteger 2 Station ID ESRIGNSS_STATIONID ESRI_STATION_ID_DOMAIN true
ESRIGNSS_NUMSATS SmallInteger 2 Number of Satellites ESRIGNSS_NUMSATS ESRI_NUM_SATS_DOMAIN true
ESRIGNSS_FIXDATETIME Date 8 Fix Time ESRIGNSS_FIXDATETIME true
ESRIGNSS_AVG_H_RMS Double 8 Average Horizontal Accuracy (m) ESRIGNSS_AVG_H_RMS true
ESRIGNSS_AVG_V_RMS Double 8 Average Vertical Accuracy (m) ESRIGNSS_AVG_V_RMS true
ESRIGNSS_AVG_POSITIONS SmallInteger 2 Averaged Positions ESRIGNSS_AVG_POSITIONS true
ESRIGNSS_H_STDDEV Double 8 Standard Deviation (m) ESRIGNSS_H_STDDEV true

BackflowAssembly - FeatureClass

Name BackflowAssembly
ShapeType Point
FeatureType Simple
AliasName BackflowAssembly
HasM false
HasZ false
HasAttachments false
Description BackflowAssembly

Field DataType Length AliasName Description Domain DefaultValue IsNullable Precision Scale
assettype SmallInteger 2 Asset type assettype Asset_Type_Water_Assembly_Backflow false
creationdate Date 8 Creation date creationdate true
creator String 255 Creator creator true
lastupdate Date 8 Last update lastupdate true
updatedby String 255 Updated by updatedby true
globalid GlobalID 38 Global ID globalid false
installdate Date 8 Install Date installdate true
assetid String 64 Asset ID assetid true
notes String 2000 Notes notes false
locked SmallInteger 2 Locked locked Yes_No true
symbolrotation SmallInteger 2 Symbol Rotation symbolrotation Symbol_Rotation true
lifecyclestatus SmallInteger 2 Lifecycle Status lifecyclestatus Lifecycle_Combined false
ESRIGNSS_RECEIVER String 50 Receiver Name ESRIGNSS_RECEIVER true
ESRIGNSS_H_RMS Double 8 Horizontal Accuracy (m) ESRIGNSS_H_RMS true
ESRIGNSS_V_RMS Double 8 Vertical Accuracy (m) ESRIGNSS_V_RMS true
ESRIGNSS_LATITUDE Double 8 Latitude ESRIGNSS_LATITUDE true
ESRIGNSS_LONGITUDE Double 8 Longitude ESRIGNSS_LONGITUDE true
ESRIGNSS_ALTITUDE Double 8 Altitude ESRIGNSS_ALTITUDE true
ESRIGNSS_PDOP Double 8 PDOP ESRIGNSS_PDOP true
ESRIGNSS_HDOP Double 8 HDOP ESRIGNSS_HDOP true
ESRIGNSS_VDOP Double 8 VDOP ESRIGNSS_VDOP true
ESRIGNSS_FIXTYPE SmallInteger 2 Fix Type ESRIGNSS_FIXTYPE ESRI_FIX_TYPE_DOMAIN true
ESRIGNSS_CORRECTIONAGE Double 8 Correction Age ESRIGNSS_CORRECTIONAGE true
ESRIGNSS_STATIONID SmallInteger 2 Station ID ESRIGNSS_STATIONID ESRI_STATION_ID_DOMAIN true
ESRIGNSS_NUMSATS SmallInteger 2 Number of Satellites ESRIGNSS_NUMSATS ESRI_NUM_SATS_DOMAIN true
ESRIGNSS_FIXDATETIME Date 8 Fix Time ESRIGNSS_FIXDATETIME true
ESRIGNSS_AVG_H_RMS Double 8 Average Horizontal Accuracy (m) ESRIGNSS_AVG_H_RMS true
ESRIGNSS_AVG_V_RMS Double 8 Average Vertical Accuracy (m) ESRIGNSS_AVG_V_RMS true
ESRIGNSS_AVG_POSITIONS SmallInteger 2 Averaged Positions ESRIGNSS_AVG_POSITIONS true
ESRIGNSS_H_STDDEV Double 8 Standard Deviation (m) ESRIGNSS_H_STDDEV true

BlowOffAssembly - FeatureClass

Name BlowOffAssembly
ShapeType Point
FeatureType Simple
AliasName BlowOffAssembly
HasM false
HasZ false
HasAttachments false
Description BlowOffAssembly

Field DataType Length AliasName Description Domain DefaultValue IsNullable Precision Scale
assettype SmallInteger 2 Asset type assettype Asset_Type_Water_Assembly_Blow_Off false
creationdate Date 8 Creation date creationdate true
creator String 255 Creator creator true
lastupdate Date 8 Last update lastupdate true
updatedby String 255 Updated by updatedby true
globalid GlobalID 38 Global ID globalid false
installdate Date 8 Install Date installdate true
assetid String 64 Asset ID assetid true
notes String 2000 Notes notes false
locked SmallInteger 2 Locked locked true
symbolrotation SmallInteger 2 Symbol Rotation symbolrotation Symbol_Rotation true
lifecyclestatus SmallInteger 2 Lifecycle Status lifecyclestatus Lifecycle_Combined false
ESRIGNSS_RECEIVER String 50 Receiver Name ESRIGNSS_RECEIVER true
ESRIGNSS_H_RMS Double 8 Horizontal Accuracy (m) ESRIGNSS_H_RMS true
ESRIGNSS_V_RMS Double 8 Vertical Accuracy (m) ESRIGNSS_V_RMS true
ESRIGNSS_LATITUDE Double 8 Latitude ESRIGNSS_LATITUDE true
ESRIGNSS_LONGITUDE Double 8 Longitude ESRIGNSS_LONGITUDE true
ESRIGNSS_ALTITUDE Double 8 Altitude ESRIGNSS_ALTITUDE true
ESRIGNSS_PDOP Double 8 PDOP ESRIGNSS_PDOP true
ESRIGNSS_HDOP Double 8 HDOP ESRIGNSS_HDOP true
ESRIGNSS_VDOP Double 8 VDOP ESRIGNSS_VDOP true
ESRIGNSS_FIXTYPE SmallInteger 2 Fix Type ESRIGNSS_FIXTYPE ESRI_FIX_TYPE_DOMAIN true
ESRIGNSS_CORRECTIONAGE Double 8 Correction Age ESRIGNSS_CORRECTIONAGE true
ESRIGNSS_STATIONID SmallInteger 2 Station ID ESRIGNSS_STATIONID ESRI_STATION_ID_DOMAIN true
ESRIGNSS_NUMSATS SmallInteger 2 Number of Satellites ESRIGNSS_NUMSATS ESRI_NUM_SATS_DOMAIN true
ESRIGNSS_FIXDATETIME Date 8 Fix Time ESRIGNSS_FIXDATETIME true
ESRIGNSS_AVG_H_RMS Double 8 Average Horizontal Accuracy (m) ESRIGNSS_AVG_H_RMS true
ESRIGNSS_AVG_V_RMS Double 8 Average Vertical Accuracy (m) ESRIGNSS_AVG_V_RMS true
ESRIGNSS_AVG_POSITIONS SmallInteger 2 Averaged Positions ESRIGNSS_AVG_POSITIONS true
ESRIGNSS_H_STDDEV Double 8 Standard Deviation (m) ESRIGNSS_H_STDDEV true

FlowValve - FeatureClass

Name FlowValve
ShapeType Point
FeatureType Simple
AliasName FlowValve
HasM false
HasZ false
HasAttachments false
Description FlowValve

Field DataType Length AliasName Description Domain DefaultValue IsNullable Precision Scale
assettype SmallInteger 2 Asset type assettype Asset_Type_Water_Device_Flow_Valve false
creationdate Date 8 Creation date creationdate true
creator String 255 Creator creator true
lastupdate Date 8 Last update lastupdate true
updatedby String 255 Updated by updatedby true
globalid GlobalID 38 Global ID globalid false
diameter Double 8 Diameter 1 diameter true
secondarydiameter Double 8 Diameter 2 secondarydiameter true
pressure Double 8 Pressure pressure true
installdate Date 8 Install Date installdate true
assetid String 64 Asset ID assetid true
ownedby SmallInteger 2 Owned By ownedby Asset_Owner true
maintby SmallInteger 2 Maintained By maintby Asset_Manager true
notes String 2000 Notes notes true
symbolrotation SmallInteger 2 Symbol Rotation symbolrotation Symbol_Rotation true
lastmaint Date 8 Last Maintenance lastmaint true
lifecyclestatus SmallInteger 2 Lifecycle Status lifecyclestatus Lifecycle_Combined false
ESRIGNSS_RECEIVER String 50 Receiver Name ESRIGNSS_RECEIVER true
ESRIGNSS_H_RMS Double 8 Horizontal Accuracy (m) ESRIGNSS_H_RMS true
ESRIGNSS_V_RMS Double 8 Vertical Accuracy (m) ESRIGNSS_V_RMS true
ESRIGNSS_LATITUDE Double 8 Latitude ESRIGNSS_LATITUDE true
ESRIGNSS_LONGITUDE Double 8 Longitude ESRIGNSS_LONGITUDE true
ESRIGNSS_ALTITUDE Double 8 Altitude ESRIGNSS_ALTITUDE true
ESRIGNSS_PDOP Double 8 PDOP ESRIGNSS_PDOP true
ESRIGNSS_HDOP Double 8 HDOP ESRIGNSS_HDOP true
ESRIGNSS_VDOP Double 8 VDOP ESRIGNSS_VDOP true
ESRIGNSS_FIXTYPE SmallInteger 2 Fix Type ESRIGNSS_FIXTYPE ESRI_FIX_TYPE_DOMAIN true
ESRIGNSS_CORRECTIONAGE Double 8 Correction Age ESRIGNSS_CORRECTIONAGE true
ESRIGNSS_STATIONID SmallInteger 2 Station ID ESRIGNSS_STATIONID ESRI_STATION_ID_DOMAIN true
ESRIGNSS_NUMSATS SmallInteger 2 Number of Satellites ESRIGNSS_NUMSATS ESRI_NUM_SATS_DOMAIN true
ESRIGNSS_FIXDATETIME Date 8 Fix Time ESRIGNSS_FIXDATETIME true
ESRIGNSS_AVG_H_RMS Double 8 Average Horizontal Accuracy (m) ESRIGNSS_AVG_H_RMS true
ESRIGNSS_AVG_V_RMS Double 8 Average Vertical Accuracy (m) ESRIGNSS_AVG_V_RMS true
ESRIGNSS_AVG_POSITIONS SmallInteger 2 Averaged Positions ESRIGNSS_AVG_POSITIONS true
ESRIGNSS_H_STDDEV Double 8 Standard Deviation (m) ESRIGNSS_H_STDDEV true

FlushingandBlowOff - FeatureClass

Name FlushingandBlowOff
ShapeType Point
FeatureType Simple
AliasName FlushingandBlowOff
HasM false
HasZ false
HasAttachments false
Description FlushingandBlowOff

Field DataType Length AliasName Description Domain DefaultValue IsNullable Precision Scale
assettype SmallInteger 2 Asset type assettype Asset_Type_Water_Device_Flushing_and_Blow_Off false
creationdate Date 8 Creation date creationdate true
creator String 255 Creator creator true
lastupdate Date 8 Last update lastupdate true
updatedby String 255 Updated by updatedby true
globalid GlobalID 38 Global ID globalid false
name String 64 Name name true
installdate Date 8 Install Date installdate true
assetid String 64 Asset ID assetid true
ownedby SmallInteger 2 Owned By ownedby Asset_Owner true
maintby SmallInteger 2 Maintained By maintby Asset_Manager true
notes String 2000 Notes notes true
symbolrotation SmallInteger 2 Symbol Rotation symbolrotation Symbol_Rotation true
lastmaint Date 8 Last Maintenance lastmaint true
lifecyclestatus SmallInteger 2 Lifecycle Status lifecyclestatus Lifecycle_Combined false
ESRIGNSS_RECEIVER String 50 Receiver Name ESRIGNSS_RECEIVER true
ESRIGNSS_H_RMS Double 8 Horizontal Accuracy (m) ESRIGNSS_H_RMS true
ESRIGNSS_V_RMS Double 8 Vertical Accuracy (m) ESRIGNSS_V_RMS true
ESRIGNSS_LATITUDE Double 8 Latitude ESRIGNSS_LATITUDE true
ESRIGNSS_LONGITUDE Double 8 Longitude ESRIGNSS_LONGITUDE true
ESRIGNSS_ALTITUDE Double 8 Altitude ESRIGNSS_ALTITUDE true
ESRIGNSS_PDOP Double 8 PDOP ESRIGNSS_PDOP true
ESRIGNSS_HDOP Double 8 HDOP ESRIGNSS_HDOP true
ESRIGNSS_VDOP Double 8 VDOP ESRIGNSS_VDOP true
ESRIGNSS_FIXTYPE SmallInteger 2 Fix Type ESRIGNSS_FIXTYPE ESRI_FIX_TYPE_DOMAIN true
ESRIGNSS_CORRECTIONAGE Double 8 Correction Age ESRIGNSS_CORRECTIONAGE true
ESRIGNSS_STATIONID SmallInteger 2 Station ID ESRIGNSS_STATIONID ESRI_STATION_ID_DOMAIN true
ESRIGNSS_NUMSATS SmallInteger 2 Number of Satellites ESRIGNSS_NUMSATS ESRI_NUM_SATS_DOMAIN true
ESRIGNSS_FIXDATETIME Date 8 Fix Time ESRIGNSS_FIXDATETIME true
ESRIGNSS_AVG_H_RMS Double 8 Average Horizontal Accuracy (m) ESRIGNSS_AVG_H_RMS true
ESRIGNSS_AVG_V_RMS Double 8 Average Vertical Accuracy (m) ESRIGNSS_AVG_V_RMS true
ESRIGNSS_AVG_POSITIONS SmallInteger 2 Averaged Positions ESRIGNSS_AVG_POSITIONS true
ESRIGNSS_H_STDDEV Double 8 Standard Deviation (m) ESRIGNSS_H_STDDEV true

Outlet - FeatureClass

Name Outlet
ShapeType Point
FeatureType Simple
AliasName Outlet
HasM false
HasZ false
HasAttachments false
Description Outlet

Field DataType Length AliasName Description Domain DefaultValue IsNullable Precision Scale
assettype SmallInteger 2 Asset type assettype Asset_Type_Water_Device_Outlet false
creationdate Date 8 Creation date creationdate true
creator String 255 Creator creator true
lastupdate Date 8 Last update lastupdate true
updatedby String 255 Updated by updatedby true
globalid GlobalID 38 Global ID globalid false
name String 64 Name name true
installdate Date 8 Install Date installdate true
assetid String 64 Asset ID assetid true
ownedby SmallInteger 2 Owned By ownedby Asset_Owner true
maintby SmallInteger 2 Maintained By maintby Asset_Manager true
notes String 2000 Notes notes true
symbolrotation SmallInteger 2 Symbol Rotation symbolrotation Symbol_Rotation true
lastmaint Date 8 Last Maintenance lastmaint true
lifecyclestatus SmallInteger 2 Lifecycle Status lifecyclestatus Lifecycle_Combined false
ESRIGNSS_RECEIVER String 50 Receiver Name ESRIGNSS_RECEIVER true
ESRIGNSS_H_RMS Double 8 Horizontal Accuracy (m) ESRIGNSS_H_RMS true
ESRIGNSS_V_RMS Double 8 Vertical Accuracy (m) ESRIGNSS_V_RMS true
ESRIGNSS_LATITUDE Double 8 Latitude ESRIGNSS_LATITUDE true
ESRIGNSS_LONGITUDE Double 8 Longitude ESRIGNSS_LONGITUDE true
ESRIGNSS_ALTITUDE Double 8 Altitude ESRIGNSS_ALTITUDE true
ESRIGNSS_PDOP Double 8 PDOP ESRIGNSS_PDOP true
ESRIGNSS_HDOP Double 8 HDOP ESRIGNSS_HDOP true
ESRIGNSS_VDOP Double 8 VDOP ESRIGNSS_VDOP true
ESRIGNSS_FIXTYPE SmallInteger 2 Fix Type ESRIGNSS_FIXTYPE ESRI_FIX_TYPE_DOMAIN true
ESRIGNSS_CORRECTIONAGE Double 8 Correction Age ESRIGNSS_CORRECTIONAGE true
ESRIGNSS_STATIONID SmallInteger 2 Station ID ESRIGNSS_STATIONID ESRI_STATION_ID_DOMAIN true
ESRIGNSS_NUMSATS SmallInteger 2 Number of Satellites ESRIGNSS_NUMSATS ESRI_NUM_SATS_DOMAIN true
ESRIGNSS_FIXDATETIME Date 8 Fix Time ESRIGNSS_FIXDATETIME true
ESRIGNSS_AVG_H_RMS Double 8 Average Horizontal Accuracy (m) ESRIGNSS_AVG_H_RMS true
ESRIGNSS_AVG_V_RMS Double 8 Average Vertical Accuracy (m) ESRIGNSS_AVG_V_RMS true
ESRIGNSS_AVG_POSITIONS SmallInteger 2 Averaged Positions ESRIGNSS_AVG_POSITIONS true
ESRIGNSS_H_STDDEV Double 8 Standard Deviation (m) ESRIGNSS_H_STDDEV true

PressureReducingStation - FeatureClass

Name PressureReducingStation
ShapeType Point
FeatureType Simple
AliasName PressureReducingStation
HasM false
HasZ false
HasAttachments false
Description PressureReducingStation

Field DataType Length AliasName Description Domain DefaultValue IsNullable Precision Scale
assettype SmallInteger 2 Asset type assettype Asset_Type_Water_Assembly_Pressure_Reducing_Station false
creationdate Date 8 Creation date creationdate true
creator String 255 Creator creator true
lastupdate Date 8 Last update lastupdate true
updatedby String 255 Updated by updatedby true
globalid GlobalID 38 Global ID globalid false
installdate Date 8 Install Date installdate true
assetid String 64 Asset ID assetid true
notes String 2000 Notes notes false
symbolrotation SmallInteger 2 Symbol Rotation symbolrotation Symbol_Rotation true
lifecyclestatus SmallInteger 2 Lifecycle Status lifecyclestatus Lifecycle_Combined false
ESRIGNSS_RECEIVER String 50 Receiver Name ESRIGNSS_RECEIVER true
ESRIGNSS_H_RMS Double 8 Horizontal Accuracy (m) ESRIGNSS_H_RMS true
ESRIGNSS_V_RMS Double 8 Vertical Accuracy (m) ESRIGNSS_V_RMS true
ESRIGNSS_LATITUDE Double 8 Latitude ESRIGNSS_LATITUDE true
ESRIGNSS_LONGITUDE Double 8 Longitude ESRIGNSS_LONGITUDE true
ESRIGNSS_ALTITUDE Double 8 Altitude ESRIGNSS_ALTITUDE true
ESRIGNSS_PDOP Double 8 PDOP ESRIGNSS_PDOP true
ESRIGNSS_HDOP Double 8 HDOP ESRIGNSS_HDOP true
ESRIGNSS_VDOP Double 8 VDOP ESRIGNSS_VDOP true
ESRIGNSS_FIXTYPE SmallInteger 2 Fix Type ESRIGNSS_FIXTYPE ESRI_FIX_TYPE_DOMAIN true
ESRIGNSS_CORRECTIONAGE Double 8 Correction Age ESRIGNSS_CORRECTIONAGE true
ESRIGNSS_STATIONID SmallInteger 2 Station ID ESRIGNSS_STATIONID ESRI_STATION_ID_DOMAIN true
ESRIGNSS_NUMSATS SmallInteger 2 Number of Satellites ESRIGNSS_NUMSATS ESRI_NUM_SATS_DOMAIN true
ESRIGNSS_FIXDATETIME Date 8 Fix Time ESRIGNSS_FIXDATETIME true
ESRIGNSS_AVG_H_RMS Double 8 Average Horizontal Accuracy (m) ESRIGNSS_AVG_H_RMS true
ESRIGNSS_AVG_V_RMS Double 8 Average Vertical Accuracy (m) ESRIGNSS_AVG_V_RMS true
ESRIGNSS_AVG_POSITIONS SmallInteger 2 Averaged Positions ESRIGNSS_AVG_POSITIONS true
ESRIGNSS_H_STDDEV Double 8 Standard Deviation (m) ESRIGNSS_H_STDDEV true

PressureValve - FeatureClass

Name PressureValve
ShapeType Point
FeatureType Simple
AliasName PressureValve
HasM false
HasZ false
HasAttachments false
Description PressureValve

Field DataType Length AliasName Description Domain DefaultValue IsNullable Precision Scale
assettype SmallInteger 2 Asset type assettype Asset_Type_Water_Device_Pressure_Valve false
creationdate Date 8 Creation date creationdate true
creator String 255 Creator creator true
lastupdate Date 8 Last update lastupdate true
updatedby String 255 Updated by updatedby true
globalid GlobalID 38 Global ID globalid false
diameter Double 8 Diameter diameter true
pressure Double 8 Pressure pressure true
installdate Date 8 Install Date installdate true
assetid String 64 Asset ID assetid true
ownedby SmallInteger 2 Owned By ownedby Asset_Owner true
maintby SmallInteger 2 Maintained By maintby Asset_Manager true
notes String 2000 Notes notes true
symbolrotation SmallInteger 2 Symbol Rotation symbolrotation Symbol_Rotation true
lastmaint Date 8 Last Maintenance lastmaint true
lifecyclestatus SmallInteger 2 Lifecycle Status lifecyclestatus Lifecycle_Combined false
ESRIGNSS_RECEIVER String 50 Receiver Name ESRIGNSS_RECEIVER true
ESRIGNSS_H_RMS Double 8 Horizontal Accuracy (m) ESRIGNSS_H_RMS true
ESRIGNSS_V_RMS Double 8 Vertical Accuracy (m) ESRIGNSS_V_RMS true
ESRIGNSS_LATITUDE Double 8 Latitude ESRIGNSS_LATITUDE true
ESRIGNSS_LONGITUDE Double 8 Longitude ESRIGNSS_LONGITUDE true
ESRIGNSS_ALTITUDE Double 8 Altitude ESRIGNSS_ALTITUDE true
ESRIGNSS_PDOP Double 8 PDOP ESRIGNSS_PDOP true
ESRIGNSS_HDOP Double 8 HDOP ESRIGNSS_HDOP true
ESRIGNSS_VDOP Double 8 VDOP ESRIGNSS_VDOP true
ESRIGNSS_FIXTYPE SmallInteger 2 Fix Type ESRIGNSS_FIXTYPE ESRI_FIX_TYPE_DOMAIN true
ESRIGNSS_CORRECTIONAGE Double 8 Correction Age ESRIGNSS_CORRECTIONAGE true
ESRIGNSS_STATIONID SmallInteger 2 Station ID ESRIGNSS_STATIONID ESRI_STATION_ID_DOMAIN true
ESRIGNSS_NUMSATS SmallInteger 2 Number of Satellites ESRIGNSS_NUMSATS ESRI_NUM_SATS_DOMAIN true
ESRIGNSS_FIXDATETIME Date 8 Fix Time ESRIGNSS_FIXDATETIME true
ESRIGNSS_AVG_H_RMS Double 8 Average Horizontal Accuracy (m) ESRIGNSS_AVG_H_RMS true
ESRIGNSS_AVG_V_RMS Double 8 Average Vertical Accuracy (m) ESRIGNSS_AVG_V_RMS true
ESRIGNSS_AVG_POSITIONS SmallInteger 2 Averaged Positions ESRIGNSS_AVG_POSITIONS true
ESRIGNSS_H_STDDEV Double 8 Standard Deviation (m) ESRIGNSS_H_STDDEV true

SystemValve - FeatureClass

Name SystemValve
ShapeType Point
FeatureType Simple
AliasName SystemValve
HasM false
HasZ false
HasAttachments false
Description SystemValve

Field DataType Length AliasName Description Domain DefaultValue IsNullable Precision Scale
assettype SmallInteger 2 Asset type assettype Asset_Type_Water_Device_System_Valve false
creationdate Date 8 Creation date creationdate true
creator String 255 Creator creator true
lastupdate Date 8 Last update lastupdate true
updatedby String 255 Updated by updatedby true
globalid GlobalID 38 Global ID globalid false
diameter Double 8 Diameter diameter Water_Diameter true
designtype SmallInteger 2 Valve Type designtype Water_Valve_Type true
normalstatus SmallInteger 2 Normal Status normalstatus Pipe_Device_Status_Combined false
presentstatus SmallInteger 2 Present Status presentstatus Pipe_Device_Status_Combined false
additionaldetails SmallInteger 2 Clockwise to Close additionaldetails Pipeline_Valve_Close_Direction true
designinfo Double 8 Turns to Close designinfo true
operable SmallInteger 2 Operable operable Boolean false
name String 64 Name name true
installdate Date 8 Install Date installdate true
assetid String 64 Asset ID assetid true
ownedby SmallInteger 2 Owned By ownedby Asset_Owner true
maintby SmallInteger 2 Maintained By maintby Asset_Manager true
additionaldevice SmallInteger 2 Has Bypass additionaldevice Yes_No true
notes String 2000 Notes notes true
symbolrotation SmallInteger 2 Symbol Rotation symbolrotation Symbol_Rotation true
lastmaint Date 8 Last Maintenance lastmaint true
lifecyclestatus SmallInteger 2 Lifecycle Status lifecyclestatus Lifecycle_Combined false
ESRIGNSS_RECEIVER String 50 Receiver Name ESRIGNSS_RECEIVER true
ESRIGNSS_H_RMS Double 8 Horizontal Accuracy (m) ESRIGNSS_H_RMS true
ESRIGNSS_V_RMS Double 8 Vertical Accuracy (m) ESRIGNSS_V_RMS true
ESRIGNSS_LATITUDE Double 8 Latitude ESRIGNSS_LATITUDE true
ESRIGNSS_LONGITUDE Double 8 Longitude ESRIGNSS_LONGITUDE true
ESRIGNSS_ALTITUDE Double 8 Altitude ESRIGNSS_ALTITUDE true
ESRIGNSS_PDOP Double 8 PDOP ESRIGNSS_PDOP true
ESRIGNSS_HDOP Double 8 HDOP ESRIGNSS_HDOP true
ESRIGNSS_VDOP Double 8 VDOP ESRIGNSS_VDOP true
ESRIGNSS_FIXTYPE SmallInteger 2 Fix Type ESRIGNSS_FIXTYPE ESRI_FIX_TYPE_DOMAIN true
ESRIGNSS_CORRECTIONAGE Double 8 Correction Age ESRIGNSS_CORRECTIONAGE true
ESRIGNSS_STATIONID SmallInteger 2 Station ID ESRIGNSS_STATIONID ESRI_STATION_ID_DOMAIN true
ESRIGNSS_NUMSATS SmallInteger 2 Number of Satellites ESRIGNSS_NUMSATS ESRI_NUM_SATS_DOMAIN true
ESRIGNSS_FIXDATETIME Date 8 Fix Time ESRIGNSS_FIXDATETIME true
ESRIGNSS_AVG_H_RMS Double 8 Average Horizontal Accuracy (m) ESRIGNSS_AVG_H_RMS true
ESRIGNSS_AVG_V_RMS Double 8 Average Vertical Accuracy (m) ESRIGNSS_AVG_V_RMS true
ESRIGNSS_AVG_POSITIONS SmallInteger 2 Averaged Positions ESRIGNSS_AVG_POSITIONS true
ESRIGNSS_H_STDDEV Double 8 Standard Deviation (m) ESRIGNSS_H_STDDEV true

ValveInspection - Table

Name	ValveInspection
AliasName	ValveInspection
HasAttachments	false

Description

ValveInspection

Field	DataType	Length	AliasName	Description	Domain	DefaultValue	IsNullable	Precision	Scale
paved	SmallInteger	2	Paved Over	paved	Yes_No_Not_Applicable		true
gsurface	SmallInteger	2	Ground Surface	gsurface	Water_Valve_Surface_Type		true
fintorque	Double	8	Final Torque (Ft Pounds)	fintorque			true
depthtonut	Double	8	Depth To Nut (Ft)	depthtonut			true
turns	Double	8	# of Turns	turns			true
operator	String	100	Name of Operator	operator			true
stem	SmallInteger	2	Stem OK?	stem	Yes_No		true
package	SmallInteger	2	Packing OK?	package	Yes_No		true
gears	SmallInteger	2	Gears OK?	gears	Yes_No		true
lube	SmallInteger	2	Lube Req'd?	lube	Yes_No		true
other	SmallInteger	2	Other Maint Req'd?	other	Yes_No		true
notes	String	2000	Notes	notes			true
valveid	GUID	38	Valve ID	valveid			true
globalid	GlobalID	38	GlobalID	globalid			false
creator	String	255	Creator	creator			true
creationdate	Date	8	CreationDate	creationdate			true
updatedby	String	255	UpdatedBy	updatedby			true
lastupdate	Date	8	LastUpdate	lastupdate			true
insdate	Date	8	Inspection Date	insdate			true

ValveInspection - RelationshipClass

Name	ValveInspection
Cardinality	OneToMany
IsAttributed	false
IsComposite	false

Description

ValveInspection

Origin Class Name	Origin Primary Key	Origin Foreign Key
SystemValve	globalid	valveid

Destination Class Name	Destination Primary Key	Destination Foreign Key
ValveInspection

ValveInspection2 - RelationshipClass

Name	ValveInspection2
Cardinality	OneToMany
IsAttributed	false
IsComposite	false

Description

ValveInspection2

Origin Class Name	Origin Primary Key	Origin Foreign Key
SystemValve	globalid	valveid

Destination Class Name	Destination Primary Key	Destination Foreign Key
ValveInspection

Asset_Manager - Domain

DomainName Asset_Manager
FieldType SmallInteger
Domain Type CodedValue

Code Name
1 Our Agency
2 Private
100 Other

Asset_Owner - Domain

DomainName Asset_Owner
FieldType SmallInteger
Domain Type CodedValue

Code Name
1 Our Agency
2 Private
100 Other

Asset_Type_Water_Assembly_Air_Vacuum_&_Air_Release - Domain

DomainName Asset_Type_Water_Assembly_Air_Vacuum_&_Air_Release
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
201 Air Vacuum & Air Release

Asset_Type_Water_Assembly_Backflow - Domain

DomainName Asset_Type_Water_Assembly_Backflow
FieldType SmallInteger
Domain Type CodedValue

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

Asset_Type_Water_Assembly_Blow_Off - Domain

DomainName Asset_Type_Water_Assembly_Blow_Off
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
41 Automatic
42 Manual

Asset_Type_Water_Assembly_Pressure_Reducing_Station - Domain

DomainName Asset_Type_Water_Assembly_Pressure_Reducing_Station
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
161 Pressure Reducing Station

Asset_Type_Water_Device_Control_Valve - Domain

DomainName Asset_Type_Water_Device_Control_Valve
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
161 Blow Off
171 Sampling
173 Bypass
174 Purge

Asset_Type_Water_Device_Flow_Valve - Domain

DomainName Asset_Type_Water_Device_Flow_Valve
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
1 Air Gap
2 Altitude
3 Check

Asset_Type_Water_Device_Flushing_and_Blow_Off - Domain

DomainName Asset_Type_Water_Device_Flushing_and_Blow_Off
FieldType SmallInteger
Domain Type CodedValue

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

Asset_Type_Water_Device_Outlet - Domain

DomainName Asset_Type_Water_Device_Outlet
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
641 Outlet
642 Yard Hydrant

Asset_Type_Water_Device_Pressure_Valve - Domain

DomainName Asset_Type_Water_Device_Pressure_Valve
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
201 Air & Vacuum
202 Air Release
203 Combination Air
204 Pressure Limiting
205 Pressure Reducing
206 Pressure Release
207 Pressure Sustaining

Asset_Type_Water_Device_System_Valve - Domain

DomainName Asset_Type_Water_Device_System_Valve
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
167 Isolation Zone
169 Supply
170 System
172 Pressure Zone
175 Interconnect

Boolean - Domain

DomainName Boolean
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 False
1 True

ESRI_FIX_TYPE_DOMAIN - Domain

DomainName ESRI_FIX_TYPE_DOMAIN
FieldType SmallInteger
Domain Type CodedValue

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

ESRI_NUM_SATS_DOMAIN - Domain

DomainName ESRI_NUM_SATS_DOMAIN
FieldType SmallInteger
Domain Type Range

Minimum Value Maximum Value
0 99

ESRI_STATION_ID_DOMAIN - Domain

DomainName ESRI_STATION_ID_DOMAIN
FieldType SmallInteger
Domain Type Range

Minimum Value Maximum Value
0 1023

Lifecycle_Combined - Domain

DomainName Lifecycle_Combined
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
1 Proposed
2 Approved
3 Proposed and Approved
4 Under Construction
6 Approved and Under Construction
7 Proposed, Approved and Under Construction
8 In Service
12 In Service and Under Construction
14 In Service, Under Construction, and Approved
15 In Service, Under Construction, Approved and Proposed
16 To Be Retired
24 In Service and To Be Retired
32 Abandoned

Pipe_Device_Status_Combined - Domain

DomainName Pipe_Device_Status_Combined
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Closed
1 Open
2 Inactive
3 Active

Pipeline_Valve_Close_Direction - Domain

DomainName Pipeline_Valve_Close_Direction
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Counter Clockwise
1 Clockwise

Symbol_Rotation - Domain

DomainName Symbol_Rotation
FieldType SmallInteger
Domain Type Range

Minimum Value Maximum Value
0 359

Water_Diameter - Domain

DomainName Water_Diameter
FieldType Double
Domain Type CodedValue

Code Name
0 Unknown
0.5 1/2"
0.75 3/4"
1 1"
1.25 1 1/4"
1.5 1 1/2"
2 2"
2.5 2 1/2"
3 3"
4 4"
6 6"
8 8"
10 10"
12 12"
14 14"
15 15"
16 16"
18 18"
20 20"
24 24"
30 30"
36 36"
40 40"
42 42"
48 48"
54 54"
60 60"
66 66"
72 72"
75 75"

Water_Valve_Surface_Type - Domain

DomainName Water_Valve_Surface_Type
FieldType SmallInteger
Domain Type CodedValue

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

Water_Valve_Type - Domain

DomainName Water_Valve_Type
FieldType SmallInteger
Domain Type CodedValue

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

Yes_No - Domain

DomainName Yes_No
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
1 Yes
2 No

Yes_No_Not_Applicable - Domain

DomainName Yes_No_Not_Applicable
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 Unknown
1 Yes
2 No
3 N/A

Name	AirVacuumandAirReleaseAssembly
ShapeType	Point
FeatureType	Simple
AliasName	AirVacuumandAirReleaseAssembly
HasM	false
HasZ	false
HasAttachments	false

Name	BackflowAssembly
ShapeType	Point
FeatureType	Simple
AliasName	BackflowAssembly
HasM	false
HasZ	false
HasAttachments	false

Name	BlowOffAssembly
ShapeType	Point
FeatureType	Simple
AliasName	BlowOffAssembly
HasM	false
HasZ	false
HasAttachments	false

Name	FlowValve
ShapeType	Point
FeatureType	Simple
AliasName	FlowValve
HasM	false
HasZ	false
HasAttachments	false

Name	FlushingandBlowOff
ShapeType	Point
FeatureType	Simple
AliasName	FlushingandBlowOff
HasM	false
HasZ	false
HasAttachments	false

Name	Outlet
ShapeType	Point
FeatureType	Simple
AliasName	Outlet
HasM	false
HasZ	false
HasAttachments	false

Name	PressureReducingStation
ShapeType	Point
FeatureType	Simple
AliasName	PressureReducingStation
HasM	false
HasZ	false
HasAttachments	false

Name	PressureValve
ShapeType	Point
FeatureType	Simple
AliasName	PressureValve
HasM	false
HasZ	false
HasAttachments	false

DomainName	Asset_Manager
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Owner
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Type_Water_Assembly_Air_Vacuum_&_Air_Release
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Type_Water_Assembly_Backflow
FieldType	SmallInteger
Domain Type	CodedValue

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

DomainName	Asset_Type_Water_Assembly_Blow_Off
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Type_Water_Assembly_Pressure_Reducing_Station
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Type_Water_Device_Control_Valve
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Type_Water_Device_Flow_Valve
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Type_Water_Device_Flushing_and_Blow_Off
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Type_Water_Device_Outlet
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Type_Water_Device_Pressure_Valve
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Asset_Type_Water_Device_System_Valve
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Boolean
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	ESRI_FIX_TYPE_DOMAIN
FieldType	SmallInteger
Domain Type	CodedValue

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

DomainName	ESRI_NUM_SATS_DOMAIN
FieldType	SmallInteger
Domain Type	Range

DomainName	ESRI_STATION_ID_DOMAIN
FieldType	SmallInteger
Domain Type	Range

DomainName	Lifecycle_Combined
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Pipe_Device_Status_Combined
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Pipeline_Valve_Close_Direction
FieldType	SmallInteger
Domain Type	CodedValue

DomainName	Symbol_Rotation
FieldType	SmallInteger
Domain Type	Range