Amendment 1 Attachment 2 DSFC GIS Utility Data Dictionary 20230818.pdf

DSFC GIS Utility Data Dictionary Last updated: 8/18/2023 i | P a g e

Table of Contents Introduction Structure Feature Classes

Building

Drawings

Fence Line

Repair

Sewer Component

Sewer Fitting

Sewer LiftStation

Sewer Main

Sewer Manhole

Sewer Meter

Sewer Pump

Sewer Service Line

Sewer Treatment Area

Sewer Valve

Water Component

Water Disinfection

Water Fitting

Water Hydrant

Water Main

Water Meter

Water Pump

Water Service Line

Water Source

Water Tank

Water Valve

Domains

Table of Figures Figure 1: Domains and Feature Class Comparison Table

Figure 2: Domain Code Description Pairs

1 | P a g e

Introduction This document should be used in support of activities where users digitize new data for incorporation into or are updating attribution for existing data in the authoritative data set. Items outlined in this document correspond directly to the IHS DSFC GIS Utility Standard Geodatabase template.

Structure Built upon previous iterations of data sets, the IHS DSFC GIS Utility Standard Geodatabase is a single location for Water and Sewer infrastructure feature layers as well as layers for other supporting information like buildings, fences, and drawings. IHS maintains an authoritative version of this dataset within the ArcGIS Portal environment with cross‐platform capabilities within CAD. Wherever the dataset is accessed from the schema remains the same. This document as well as the DSFC GIS Utility Data

Dictionary – Fields For Completion Excel file outline the fields and domains that are contained within this data set.

Additionally, when viewing the Geodatabase within ESRI software the presence of ATTACH layers and relationship classes exist for each of the layers outlined in this document. The ATTACH layers are solely for storage of attachments, which has been allowed for each layer within the data set. These items can be managed via the attachment manager within ESRI products. Do not make manual changes to the attribute tables of these items.

Feature Classes The following feature classes within the IHS DSFC GIS Standard Geodatabase are presented here alphabetically. While there is no requirement for fields in attribute tables to be filled out, it is recommended that information be filled out to the completeness and extent in which it is feasible, should the data be available. Populating data following these guidelines and utilizing the geodatabase structure from the IHS DSFC GIS standard Geodatabase allows for easy incorporation of new data into the authoritative dataset. Each section includes a brief description of the layer and its purpose, as well as a table that outlines the Field Name, Field Alias, Data Types, Domains, Default Values, Length. The feature class tables in this chapter will have highlighted fields pertaining to the color coded recommendations below:

Must be filled out to populate in GIS

Indicates that fields are auto‐populated by SQL backend script

Recommended fields for completion as part of Operational Guideline

Note that General background fields like Object ID, Global ID, created_user, created_date, last_edited_user, last_edited_date, and Shape fields are not included in this document as those are not part of the items to be manually edited by users. However, when viewing the data within ESRI or CADD applications, these fields may be visible to the user.

2 | P a g e

Building The Building feature class is represented as a polygon layer. Buildings represent the footprint of a structure serving as a shed or storage area.

Field Name Alias Data Type Domain Default Value

Length

BUILDINGID Building Identifier String 254

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

BUILDINGTYPE Building Type String dBuildingType 50

MATERIAL Primary Construction Material String dBuildingMaterial 50

MANUFACTURER Building Manufacturer String 150

DIMENSIONS Dimensions String 254

NUMBER_OF_ROOMS Number of Rooms SmallInteger 2

CAPACITY Capacity String 50

AREA_SQFT Area (sq ft) Double 8

COMMENTS Comments String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

STARS_KEY STARS Unique ID String 20

PROJECTNAME Project that Updated the system String 80

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

OMDS_SYSTEM OMDS System String 20

Drawings The Drawings feature class is represented as a point feature. It is a location to provide additional information about any associated drawings.

Field Name Alias Data Type Domain Default Value

Length

NOTES NOTES String 255

DRAWINGTYPE Drawing Type String 255

DESCRIPTION DESCRIPTION String 255

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

3 | P a g e

Fence Line The Fence feature class is represented as a linear feature. A fence may represent a collective set of landscape amenities such as a decorative structure, physical security barrier, or serve various purposes to protect government owned entities.

Field Name Alias Data Type Domain Default Value

Length

FENCEID Fence Unique ID String 254

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Type String 50

MATERIAL Material String 254

TYPE_OF_GATE Type of Gate String 254

DIMENSIONS Dimensions String 254

LOCKS_OWNER Locks/Owner String 254

LENGTH_FT LENGTH_FT Double 8

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

STARS_KEY STARS Unique ID String 20

PROJECTNAME Project that Updated the system String 80

COLLECTIONMETHOD COLLECTIONMETHOD String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

Repair The Repair feature class is represented as a point feature. Repairs may identify where maintenance or repairs occurred and relate to a workorder. This layer allows for capturing workorder identification, repair date, systems repaired, etc.

Field Name Alias Data Type Domain Default Value

Length

REPAIRID Repair Unique ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

WORKORDER_KEY Work order ID String 50

REPAIRDATE Repair Date Date 8

REPAIR Repair Performed String 255

DIFFICULTIES Difficulties Encountered String 255

4 | P a g e

Field Name Alias Data Type Domain Default Value

Length

SYSTEMREPAIRED Utility System Repaired String dUtilitySystem 50

COMMENTS General Comments String 200

CADFILE CAD file used to update system String 120

PROJECTNAME Project that Updated the system String 80

COLLECTIONMETHOD COLLECTIONMETHOD String dCollectionMethod 255

Sewer Component The Sewer Component feature class is represented as a point feature. designed as a place to store miscellaneous features that are not specifically allocated with their own feature class and attributes. It allows for capturing basic information such as item type, names, backup power, maintenance status, etc.

See the domain table dSewerComponentType for specific sewer component type examples.

Field Name Alias Data Type Domain Default Value

Length

SSCOMPONENTEID Component ID String 50

COMPONENTTYPE Sewer System Component String dSewerComponentType 255

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

BACKUPPOWER Backup power available String dYesNo 10

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

SIZE Size in HP or Capacity Double 8

PROJECTNAME Project that Updated the system String 80

STARS_KEY STARS Unique ID String 20

COLLECTIONMETHOD COLLECTIONMETHOD String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

ENABLED Enabled SmallInteger EnabledDomain 1 2

5 | P a g e

Sewer Disinfection

The Sewer Disinfection feature class is represented as a point feature. Disinfection is the process of eliminating pathogens and microorganisms in treated wastewater before dispersing effluent into the environment. See the domain table dDissenfectionType for specific disinfection type examples.

Field Name Alias Data Type Domain Default Value

Length

SSDISINFECTIONID Identifier String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Type String dDissenfectionType 50

MANUFACTURER Manufacturer String 254

SYSTEM_PRESSURE System Pressure Double 8

TARGET_FEED_RATE Target Feed Rate for System Double 8

CONTACT_BASIN_FOR_CONTACT_TIME

Contact Basin for Contact Time? String 254

CAPACITY Capacity String 50

CL_PUMP_DESCRIPTION

Chlorine Pump Manufacturer, Model, Etc. String 50

CL_STORAGEVOLUME

Chlorine Storage Vessel Volume String 50

MODEL Model Number String 50

PERCENT_CHLORINE % Chlorine Double 8

CURRENT_FEED_RATE Current Feed Rate String 50

CHLORINE_GAS_SCRUBBER Chlorine Gas Scrubber? String dYesNo 10

CLEANING_INTERVAL Cleaning Interval String 50

CLEANING_MANUAL_OR_AUTOMATIC

Cleaning: Manual or Automatic? String dManualAutomatic 25

CONTAINMENT_VESSELS Containment Vessels? String 50

NUMBER_OF_BULBS # of Bulbs SmallInteger 2

NUMBER_DAYS_STORAGE # of Days of Storage SmallInteger 2

COMMENTS COMMENTS String 255

CADFILE

CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME

Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY

Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

6 | P a g e

Value

Length

ANCILLARYROLE AncillaryRole SmallInteger AncillaryRoleDomain 2

ENABLED Enabled SmallInteger EnabledDomain 2

OMDS_SYSTEM OMDS_SYSTEM String 20

Sewer Fitting The Sewer Fitting feature class is represented as a point feature. It represents where two pipes are connected. This is represented as a point feature. The fitting can represent a joint or connector location where two different types of pipe or size are connected. See the domain table dSewerFittingType for specific fitting examples.

Field Name Alias Data Type Domain Default Value

Length

SSFITTINGID Fitting ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

FITTINGTYPE Fitting Type String dSewerFittingType 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME Project that Updated the system String 80

STARS_KEY STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

Sewer LiftStation The Sewer Lift Station feature class is represented as a point feature The layer represents a facility used for pumping wastewater from a lower to a higher elevation.

Field Name Alias Data Type Domain Default Value

Length

LIFTSTATIONID Lift Station ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

INLET_ELEVATION Inlet Elevation Double 8

7 | P a g e

Value

Length

GROUND_ELEVATION Ground Elevation Double 8

WET_WELL_DIAMETER Wet Well Diameter (ft) Double 8

YEAR_INSTALLED Year Installed SmallInteger dYear 2

CAPACITY Capacity Double 8

DEPTH Depth (ft) Double 8

BACKUP_POWER Backup Power? (Yes/No) String dYesNo 10

PUMP_FLOW_CAPACITY Pump Flow Capacity Double 8

RUN_TIME Run Time (per cycle) Integer 4

TYPE Type String dSewerPumpType 50

COMMENTS COMMENTS String 255

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME

Project that Updated the system String 80

STARS_KEY STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

PUMP_OUTLET_CONNECT_SIZE_IN Size (in) Double 8

WET_WELL_LENGTH Wet Well Length (ft) Double 8

WET_WELL_WIDTH Wet Well Width (ft) Double 8

OMDS_SYSTEM OMDS System String 255

Sewer Main The Sewer Main feature class is represented as a linear feature. A sewer main is a pipe that collects and transports wastewater away from its sources of generation to a treatment plant. Sewers generally rely on gravity to move the wastewater through the collection system, although force and pressure mains are used when topography or soil conditions are unfavorable for a gravity system. See the domain table dMainType for specific type examples.

Field Name Alias Data Type Domain Default Value

Length

SSMAINID Main ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Gravity or Forced Main String dMainType 25

MATERIAL Material String dSewerPipeMaterial 50

DIAMETER Diameter (in.) Double dDiameter 8

LINER Liner String dLiningMethod 50

LINEDYEAR Year Lined SmallInteger dYear 2

8 | P a g e

Value

Length

INSTALLYEAR Install Year SmallInteger dYear 2

ASTM ASTM Number String 50

DRNUMBER DR Number String 50

SIZINGCLASS Sizing Class String 10

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME Project that Updated the system String 80

STARS_KEY STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

ENABLED Enabled SmallInteger EnabledDomain 1 2

SLOPE_PERCENTAGE Slope Percentage Double 8

UPSTREAMMANHOLEID Upstream Manhole ID String 50

DOWNSTREAMMANHOLEID Downstream Manhole ID String 50

Sewer Manhole The Sewer Manholes feature class is represented as a point feature. Manholes are structures that connect two or more pipes within the system. See the domain table dManholeType for specific examples.

Field Name Alias Data Type Domain Default Value

Length

SSMANHOLEID Manhole ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Manhole Type String dManholeType 50

INVERTELEVATION Invert Depth Inlet (ft) Double 8

RIMELEVATION Rim Elevation (in) Double 8

ACCESSTYPE Access Type String dManholeAccess 20

MATERIAL Material String dManholeMaterial 50

BARRELDIAM Manhole Barrel Diameter (in) Double 8

TOPSECTION Transition from Lid to Barrel String 50

LIDDIAMETER Manhole Lid Diameter (in) Double 8

CONFSPACEPERMIT

Confined Space Permitted Required String dYesNo 10

LINED Lined (yes/no) String dYesNo 10

STEPS Steps (yes/no) String dYesNo 10

DESCRIPTION Description String 255

9 | P a g e

Value

Length

INSTALLYEAR Install Year SmallInteger dYear 2

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME Project that Updated the system String 80

STARS_KEY STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality None 5

ENABLED Enabled SmallInteger EnabledDomain 1 2

SYMBOLROTATION Symbol Rotation Double 8

INVERT_OUT_FT Invert Out (ft) Double 8

INVERT_1_IN_FT Invert #1 (ft) Double 8

INVERT_2_IN_FT Invert #2 (ft) Double 8

INVERT_3_IN_FT Invert #3 (ft) Double 8

INVERT_4_IN_FT Invert #4 (ft) Double 8

Sewer Meter The Sewer Meter feature class is represented as a point feature. See the domain table dMeterType for specific type examples.

Field Name Alias Data Type Domain Default Value

Length

SSMETERID Meter ID String 50

AREAKEY Area ID String dArea 255

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Meter Type String dMeterType 255

SIZE Size (in) Double 8

MANUFACTURER Manufacturer String 50

MODEL_NUMBER Model Number String 50

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

10 | P a g e

Value

Length

QUALITY Location Quality determination String dQuality 5

Sewer Pump The Sewer Pump feature class is represented as a point feature. See the domain table dSewerPumpType for specific type examples.

Field Name Alias Data Type Domain Default Value

Length

SSPUMPID Pump ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Type String dSewerPumpType 50

PUMP_DESCRIPTION Pump (Make/Model/Hp) String 254

MAXIMUM_FLOW Maximum Flow Double 8

MINIMUM_FLOW Mininmum Flow Double 8

PUMP_RATING Pump rating Double 8

PUMP_DESIGN_POINT Pump Design Point String 254

PRESSURE_SETTING Pressure Setting Double 8

ELEVATION Elevation Double 8

MOTOR_DESCRIPTION Motor (Make/Model/Hp) String 254

POWER_REQUIREMENTS Power (Volts/Phase/Amps) String 254

VFD VFD (Yes/No) String dYesNo 10

SOFT_START Soft Start(Yes/No) String dYesNo 10

ELECTRIC_METER_NUMBER Electric Meter # String 50

YEAR_INSTALLED Year Installed SmallInteger dYear 2

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME

Project that Updated the system String 80

STARS_KEY STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

LIFECYCLESTATUS LifecycleStatus String dLifecycleStatus Active 20

PUMP_OUTLET_CONNECT_SIZE_IN

Pump Outlet Connection Size (In.) Double 8

11 | P a g e

Sewer Service Line The Sewer Service Line feature class is represented as a linear feature. The layer represents service lines with the primary function of transporting wastewater from the customer to the sewer main.

Field Name Alias Data Type Domain Default Value

Length

SSLATERALLINEID Lateral Line ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

MATERIAL Material String dSewerPipeMaterial 50

DIAMETER Diameter (in) Double dDiameter 8

UPSTREAMINVERT Upstream Invert Depth (in) Double 8

DOWNSTREAMINVERT Downstream Invert Depth(in) Double 8

LINER Liner String dLiningMethod 50

LINEDYEAR Year Lined SmallInteger dYear 2

CLEANOUTQTY Number of cleanout points SmallInteger 2

SLOPE Slope in degrees Double 8

ASTM ASTM Number String 50

DRNUMBER DR Number String 50

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME Project that Updated the system String 80

STARS_KEY STARS Unique ID String 20

QUALITY Location Quality determination String dQuality 5

ENABLED Enabled SmallInteger EnabledDomain 1 2

SIZINGSYSTEM Sizing System String dSizingClass 10

Sewer Treatment Area The Sewer Treatment Area feature class is represented as a polygon feature. Treatment areas are drainage fields, Lagoons or other storage areas used to process and improve sewage output. See the domain table dSewerTreatmentType for specific examples.

Field Name Alias Data Type Domain Default Value

Length

SSTREATMENTID Identifier String 50

AREAKEY IHS Area String dArea 25

12 | P a g e

Value

Length

OWNER Owner String 255

TOP_DIKE_ELEVATION Top of Dike Elevation Double 8

FLOOR_ELEVATION Floor Elevation Double 8

HWL_SURFACE_AREA HWL Surface Area (acres) Double 8

DESIGN_DEPTH Design Depth (ft.) Double 8

CAPACITY Capacity (acre‐ft.) Double 8

LINER_TYPE Liner Type String dLiningMethod 50

LOADING_RATE Loading Rate (gpm/sf) Double 8

TYPE_TREATMENT Type String dSewerTreatmentType Lagoon 50

SOURCE_CONCENTRATION

Source Concentration (BOD, TSS,TKN, ETC.) String 50

DESIGN_RETENTION_TIME Design Retension Time (days) SmallInteger 2

NUMBER_UNITS_CELLS Number of Units or Cells SmallInteger 2

HWL_SURFACE_AREA_CALCULATED

CALULATED‐HWL Surface Area (acres) Double 8

COMMENTS Comments String 254

INSTALLYEAR Install Year SmallInteger dYear 2

CADFILE

CAD file used to update system String 200

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME

Project that Updated the system String 80

STARS_KEY STARS Unique ID String 20

QUALITY

Location Quality determination String dQuality 5

COLLECTIONMETHOD COLLECTIONMETHOD String dCollectionMethod 25

OMDS_SYSTEM OMDS System String 20

BACKUPPOWER Backup power available String dYesNo 255

SIZE Size in HP or Capacity Double 8

Sewer Valve The Sewer Valve feature class is represented as a point feature. Sewer Valves are used to regulate the flow and pressure within the collection system. Valves may function to regulate or relieve pressure, throttle flow, prevent backflow, or isolate portions of the collection system. See the domain table dSystemValveType for specific type examples.

Field Name Alias Data Type Domain Default Value

Length

SSVALVEID Valve ID String 50

AREAKEY IHS Area String dArea 25

13 | P a g e

Value

Length

TRIBE Tribe String dTribe 255

OWNER Owner String 255

VALVETYPE Valve Type String dSystemValveType 255

NORMALLYOPEN Normally Open SmallInteger 2

TURNSTOCLOSE TurnsToClose SmallInteger 2

OPERABLE Operable (yes/no) String dYesNo 10

CONTROLVALVETYPE Control Valve Type String dControlValveType 50

CLOCKTOCLOSE Clockwise to Close (yes/no) String dYesNo 12

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME

Project that Updated the system String 80

STARS_KEY STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

ENABLED Enabled SmallInteger EnabledDomain 1 2

SIZE Size(in) Double dDiameter 8

MANUFACTURER Manufacturer String 255

MODEL Model Number String 50

DESIGN_DOWNSTREAM_PRESSURE

Design Downstream Pressure (PSI) SmallInteger 2

DESIGN_UPSTREAM_PRESSURE Design Upstream Pressure (PSI) SmallInteger 2

FLOW_SETTING Flow Setting String 50

LEVEL_SETTING Level Setting String 50

SUPPORT_ACCESSORIES

Support Accessories (e.g., Vaults, Gauges, Shut‐Off Valves) String 50

Water Component The Water Component feature class is represented as a point feature. It is designed as a place to store miscellaneous features that are not specifically allocated with their own feature class and attributes. It allows for capturing basic information such as item type, names, backup power, maintenance status, etc.

See the domain table dWaterComponentType for specific component examples.

Field Name Alias Data Type Domain Default Value

Length

WACOMPONENTID wNetworkStructureID String 50

AREAKEY IHS Area String dArea 25

14 | P a g e

Value

Length

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Type String dWaterComponentType 50

INSTALLYEAR Install Year SmallInteger dYear 2

COMMENTS COMMENTS String 255

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

PROJECTNAME Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

ANCILLARYROLE AncillaryRole SmallInteger AncillaryRoleDomain 0 2

ENABLED Enabled SmallInteger EnabledDomain 1 2

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

Water Disinfection The Water Disinfection feature class is represented as a point feature. Disinfection is the process to eliminate pathogens and microorganisms in treated water to aid in safe drinking water distribution. See the domain table dDissenfectionType for specific disinfection type examples.

Field Name Alias Data Type Domain Default Value

Length

WADISINFECTIONID Identifier String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

MANUFACTURER Manufacturer String 254

SYSTEM_PRESSURE System Pressure Double 8

TARGET_FEED_RATE Target Feed Rate for System Double 8

CONTACT_BASIN_FOR_CONTACT_TIME

Contact Basin for Contact Time? String 254

TYPE Type String dDissenfectionType 50

CAPACITY Capacity String 50

CL_PUMP_DESCRIPTION

Chlorine Pump Manufacturer, Model, Etc. String 50

CL_STORAGE

Chlorine Storage Vessel Volume String 50

MODEL Model Number String 50

PERCENT_CHLORINE % Chlorine Double 8

15 | P a g e

Value

Length

CURRENT_FEED_RATE Current Feed Rate String 50

CHLORINE_GAS_SCRUBBER

Chlorine Gas Scrubber (yes/no) String dYesNo 10

CLEANING_INTERVAL Cleaning Interval String 50

CLEANING_MANUAL_OR_AUTOMATIC

Cleaning: Manual or Automatic? String dManualAutomatic 50

CONTAINMENT_VESSELS

Containment Vessels (yes/no) String dYesNo 10

NUMBER_OF_BULBS # of Bulbs SmallInteger 2

NUMBER_DAYS_STORAGE # of Days of Storage SmallInteger 2

COMMENTS COMMENTS String 255

CADFILE

CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

PROJECTNAME

Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 50

QUALITY

Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

ANCILLARYROLE AncillaryRole SmallInteger AncillaryRoleDomain 2

ENABLED Enabled SmallInteger EnabledDomain 2

Water Fitting The Water Fitting feature class is represented as a point feature. It represents where two pipes are connected. The fitting can represent a joint or connector location where two different types of pipe or size are connected. See the domain table dWaterFittingType for specific fitting examples.

Field Name Alias Data Type Domain Default Value

Length

WAFITTINGID Fitting ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

FITTINGTYPE Fitting Type String dWaterFittingType 255

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

16 | P a g e

Value

Length

PROJECTNAME Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

Water Hydrant The Water Hydrant feature class is represented as a point feature. It is composed of a discharge pipe with a valve and a spout at which water may be drawn from a water main for fighting fires. Refer to the domain list dHydrantType for valid hydrant types.

Field Name Alias Data Type Domain Default Value

Length

WAHYDRANTID Hydrant ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

HYDRANTCLASS Fire Hydrant Classification String dHydrantClass 10

MANUFACTURER Manufacturer String 255

MODEL Model Number String 50

TYPE Hydrant Type String dHydrantType 25

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR InstallYear SmallInteger dYear 2

LIFECYCLESTATUS LifecycleStatus String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

ANCILLARYROLE AncillaryRole SmallInteger AncillaryRoleDomain 0 2

ENABLED Enabled SmallInteger EnabledDomain 1 2

HYDRANTLEAD Lead Size (in) Double 8

OUTLETSIZE Outlet Size (in) Double 8

OUTLETSIZE2 Outlet Size #2 (in) Double 8

17 | P a g e

Water Main The Water Main feature class is represented as a linear feature. A water pipe is operated and maintained with the purpose of distribution, transmission, or production. Refer to the domain list dWaterMainType for valid main types.

Field Name Alias Data Type Domain Default Value

Length

WAMAINID Main ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

INSTALLYEAR Install Year SmallInteger dYear 2

MATERIAL Material String dWaterPipeMaterial 50

DIAMETER Diameter (in) Double dDiameter 8

PURPOSE Water Line Purpose String dWaterPurpose 50

POTABLE Potable Water String dYesNo 5

CASED Cased (yes/no) String dYesNo 10

TYPE Type String dWaterMainType 50

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

ASTM ASTM Number String 50

DRNUMBER DR Number String 50

SIZINGCLASS Sizing Class String dSizingClass 10

CASINGSIZE Casing interior Diam (in.) Double 8

METERS Number of Meters Double 8

Water Meter The Water Meter feature class is represented as a point feature. Meters are instruments used to measure the quantity of water volume passing thorough a specific location. Refer to the domain list dMeterType for valid main types.

Field Name Alias Data Type Domain Default Value

Length

WAMETERID Meter ID String 50

AREAKEY Area ID String dArea 255

18 | P a g e

Value

Length

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Meter Type String dMeterType 255

SIZE Size (in) Double 8

MANUFACTURER Manufacturer String 50

MODEL_NUMBER Model Number String 50

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

Water Pump The Water Pump feature class is represented as a point feature. Pump stations are used to generate or increase pressure in the distribution system. Pumps are used to increase pressure or introduce additional flow into the water distribution system. See the domain table dPumpType for specific type examples.

Field Name Alias Data Type Domain Default Value

Length

WAPUMPID Pump ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Pump Type String dPumpType 25

ELECTRIC_METER_NUMBER Electric Meter # String 50

FACILITY_TO_TANK_FOR_PRESSURE

Facility (Pump to Tank/to Maintain System Pressure) String 50

PUMP_DESCRIPTION Pump (Make/Model/Hp) String 254

MAXIMUM_FLOW Maximum Flow Double 8

MINIMUM_FLOW Mininmum Flow Double 8

PUMP_RATING Pump rating Double 8

PUMP_DESIGN_POINT Pump Design Point String 254

PRESSURE_SETTING Pressure Setting Double 8

ELEVATION Elevation Double 8

MOTOR_DESCRIPTION Motor (Make/Model/Hp) String 254

19 | P a g e

Value

Length

POWER_REQUIREMENTS Power (Volts/Phase/Amps) String 254

VFD VFD (Yes/No) String dYesNo 10

SOFT_START Soft Start(Yes/No) String dYesNo 10

ABOVE_BELOW_GRADE Above or Below Grade? String 50

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME

Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

ANCILLARYROLE AncillaryRole SmallInteger AncillaryRoleDomain 0 2

Water Service Line Th Water Service Line feature class is represented as a linear feature. This layer typically represents pipes providing service from a water main to a structure.

Field Name Alias Data Type Domain Default Value

Length

WALATERALLINEID Lateral Line ID String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

MATERIAL Material String dWaterPipeMaterial 50

DIAMETER Diameter Double dDiameter 8

PURPOSE Water Line Purpose String dWaterPurpose 50

POTABLE Potable Water String dYesNo 5

ASTM ASTM Number String 50

DRNUMBER DR Number String 50

SIZINGSYSTEM Sizing Class String dSizingClass 10

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

INSTALLYEAR Install Year SmallInteger dYear 2

20 | P a g e

Value

Length

PROJECTNAME Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

Water Source The Water Source feature class is represented as a point feature. Water sources may represent a well, reservoir, pump station, where the water flows away from a controller or source. See the domain table dWaSourceType for specific type examples.

Field Name Alias Data Type Domain Default Value

Length

WASOURCEID

Unique Well or Source ID Number String 50

AREAKEY IHS Area String dArea 25

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 50

SOURCETYPE SOURCETYPE SmallInteger dWaSourceType 0 2

NAME Name of Supplier String 80

DESCRIPTION Description String 255

PURPOSE Purpose String dWellPurpose 10

SCREENTYPE Screen Type String dScreenType 255

CASING_MATERIAL Casing Material String dWellCasingMaterial 120

DROP_PIPE_DESCRIPTION Drop Pipe Size/Material/Length String 254

SCREEN_LENGTH Screen Length SmallInteger 2

SCREEN_MATERIAL Sreen Material String dWellScreenMaterial 120

SCREEN_SEGMENTS

Screen Segments Lengths/Depths String 254

SCREEN_SLOT_SIZE Screen Slot Size (in) Double 8

CAPACITY Specific Capacity (GPM/ft) Double 8

STATIC_WATER_LEVEL Static Water Level (ft) Double 8

TOTAL_DEPTH Total Depth (ft) Double 8

ANNUAL_AVERAGE_PRODUCTION

Annual Average Production (GPD) Double 8

PUMPTEST_DRAWDOWN_LEVEL Pumptest Drawdown Level (ft) Double 8

PUMPTEST_RATE Pumptest Pumping Rate (GPM) Double 8

CASING_SIZE Casing size (Inside diameter, in.) Double 8

CASED Cased (yes/no) String dYesNo 10

COMMENTS Comments String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Year Well Put into Operation SmallInteger dYear 2

21 | P a g e

Value

Length

LIFECYCLESTATUS Life Cycle Status String dLifecycleStatus Active 24

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME

Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 50

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double dSymbolRotation 8

Water Tank The Water Tank feature class is represented as a point feature. A tank is used for water storage and has two primary functions: equalizing storage to satisfy peak distribution demands and emergency storage.

See the domain table dWaterTankType for specific type examples.

Field Name Alias Data Type Domain Default Value

Length

WATANKID Tank ID String 50

AREAKEY Area ID String dArea 255

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

CAPACITY Capacity(gal) Double 8

MATERIAL Material String dWaterTankMaterial 50

OVERFLOW_HEIGHT Overflow Height (ft) SmallInteger 2

DIMENSIONS Dimensions String 254

TYPE Type String dWaterTankType 50

MANUFACTURER Manufacturer String 120

SEPERATE_INLET_OUTLET Separate Inlet/Outlet? (Yes/No) String dYesNo 10

CATHODIC_PROTECTION Cathodic Protection? (yes/No) String dYesNo 10

FREQUENCY_OF_CLEANING Frequency of Cleaning String 50

DATE_LAST_PAINTED Date Last Painted Date 8

DATE_LAST_CLEANED Date Last Cleaned Date 8

INLET_PIPE_SIZE_IN Intlet Pipe Size (in) Double 8

OUTLET_PIPE_SIZE_IN Outlet Pipe Size (in) Double 8

BASEELEVATION Elevation of Base of Tank Double 8

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

22 | P a g e

Value

Length

PROJECTNAME Project that Updated the system String 80

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

Water Valve The Water Valve feature class is represented as a point feature. Valves are used to control the flow of water in a water distribution system. See the domain table dSystemValveTypefor specific type examples.

Field Name Alias Data Type Domain Default Value

Length

WAVALVEID Valve ID String 50

AREAKEY Area ID String dArea 255

DISTRICT District String dDistricts 50

TRIBE Tribe String dTribe 255

OWNER Owner String 255

TYPE Valve Type String dSystemValveType 255

CLOCKTOCLOSE Turn Clockwise To Close SmallInteger 2

NORMALLYOPEN Normally Open SmallInteger EnabledDomain 1 2

TURNSTOCLOSE Turns To Close SmallInteger 2

DESIGN_DOWNSTREAM_PRESSURE

Design Down‐Stream Pressure (psi) SmallInteger 2

DESIGN_UPSTREAM_PRESSURE

Design Up‐Stream Pressure (psi) SmallInteger 2

FLOW_SETTING Flow Setting String 50

LEVEL_SETTING Level Setting String 50

MANUFACTURER Manufacturer String 50

MODEL_NUMBER Model Number String 50

STYLE

Style (Straight, angled, reverse flow) String 50

SUPPORT_ACCESSORIES

Support Accessories (i.e.

Vaults, Guages, Shut Off Valves) String 50

SIZE Size (in) Double 8

COMMENTS COMMENTS String 255

CADFILE CAD file used to update system String 200

INSTALLYEAR Install Year SmallInteger dYear 2

LIFECYCLESTATUS Lifecycle Status String dLifecycleStatus Active 20

MAINTENANCESTATUS Utility Condition String dUtilityCondition 15

PROJECTNAME

Project that Updated the system String 80

23 | P a g e

Value

Length

STARS_ID STARS Unique ID String 20

COLLECTIONMETHOD Collection Method String dCollectionMethod 255

QUALITY Location Quality determination String dQuality 5

SYMBOLROTATION Symbol Rotation Double 8

ENABLED Enabled SmallInteger EnabledDomain 1 2

CONTROLVALVETYPE Control Valve Type String dControlValveType 255

OMDS_SYSTEM OMDS System String 20

VAULT_LOCATION Vault Location String dYesNo 255

RIMELEVATION Rim Elevation Double 8

ACCESSTYPE Access Type String dManholeAccess 255

INVERTELEVATION Invert Elevation Depth Double 8

Domains Attribute domains are rules that describe the legal values of a field type. They are used to constrain the values allowed for an attribute for a table or feature class. They provide a method for enforcing data integrity by limiting what can be placed on a field to a valid list or range of choices. Whenever a domain is associated with an attribute field, only the values within that domain are valid for the field. In other words, the field will not accept a value that is not in that domain. Attribute domains can be shared across feature classes and tables in a geodatabase.

This chapter displays two figures that contain sets of tables. The first figure (Figure 1) shows what domains are present in each of the layers. The Key for this figure is displayed below.

Feature Name list of the Features currently contained within the Utilities geodatabase

Domains list of the Domains currently contained within the Utilities geodatabase

Highlighted "x" indicates the Feature uses the Domain

The second Figure set contains the Code/Description Pairs, listed in alphabetical order, for each of the

Domains within the dataset (Figure 2).

24 | P a g e

Figure 1: Domains and Feature Class Comparison Table

Feature Name

Domain Name B u ild in g

D ra w in gs

Fe n ce _L e

R p ai r

Se w e r_ C o m p o n e n t

Se w e r_ D is in fe ct io

Se w e r_ Fi tt in g

Se w e r_ Li ft St at e r_ M ai e r_ M an h o le e r_ M e te r

Se w e r_ P u m p e r_ Se rv ic e _L e r_ Tr e at m e n t_ A re a

Se w e r_ V al ve

W at e r_ C o m p o n e n t

W at e r_ D is in fe ct e r_ Fi tt in g

W at e r_ H yd ra n t

W at e r_ M e r_ M e te r

W at e r_ P u e r_ Se rv ic e _L e r_ So u rc e r_ Ta n k

W at e r_ V

AncillaryRoleDomain x x x x x dArea x x x x x x x x x x x x x x x x x x x x x x x x x x dBuildingMaterial x dBuildingType x dCollectionMethod x x x x x x x x x x x x x x x x x x x x x x x x dControlValveType x x dDiameter x x x x x dDissenfectionType x x dDistricts x x x x x x x x x x x x x x x x x x x x x x x x x x dHydrantClass x dHydrantType x dLifecycleStatus x x x x x x x x x x x x x x x x x x x x x x x x dLiningMethod x x x dMainType x dManholeAccess x x dManholeMaterial x dManholeType x dMeterType x x dPumpType x dQuality x x x x x x x x x x x x x x x x x x x x x x x x x dScreenType x dSewerComponentType x dSewerFittingType x

25 | P a g e dSewerPipeMaterial x x dSewerPumpType x x dSewerTreatmentType x dSewerValveType x dSizingClass x x x dSymbolRotation x dTribe x x x x x x x x x x x x x x x x x x x x x x x x x x dUtilityCondition x x x x x x x x x x x x x x x x x x x x x x x dUtilitySystem x dWaSourceType x dWaterComponentType x dWaterFittingType x dWaterMainType x dWaterPipeMaterial x x dWaterPurpose x x dWaterTankMaterial x dWaterTankType x dWaterValveType x dWellCasingMaterial x dWellPurpose x dWellScreenMaterial x dYear x x x x x x x x x x x x x x x x x x x x x x x dYesNo x x x x x x x x x x x x x x

EnabledDomain x x x x x x x x x x x x x x x x

Domain Name

B u ild in g

D ra w gs

Fe ce _L

R p ai r

Se w e r_ C o m p o n e n t

Se w e r_ D is in fe ct e r_ Fi tt in g

Se w e r_ Li ft St at e r_ M e r_ M an h o le e r_ M e te r

Se w e r_ P u e r_ Se rv ic e _L e r_ Tr e at m e n t_ A re a

Se w e r_ V e r_ C o m p o n e n t

W at e r_ D is in fe ct e r_ Fi tt in g

W at e r_ H yd ra n t

W at e r_ M e r_ M e te r

W at e r_ P u e r_ Se rv ic e _L e r_ So u rc e r_ Ta n k

W at e r_ V

Feature Name

26 | P a g e

Figure 2: Domain Code Description Pairs AncillaryRoleDomain dCollectionMethod

Field Type: SmallInteger FieldType String

Domain Type: CodedValue Domain Type CodedValue

Code Description Code Description

0 None CADConversion CAD Conversion

1 Source GPSMappingGrade GPS Collection Mapping Grade

2 Sink GPSSurveyGrade GPS Collection Survey Grade

HeadsUpDigitization Heads Up Digitization dArea Other Other

FieldType String Photogrammetry Photogrammetry

Domain Type CodedValue Unknown Unknown

Code Description

AL Alaska dControlValveType

AN Albuquerque FieldType String

BE Bemidji Domain Type CodedValue

BI Billings Code Description

CA California Air Valve Air Valve

GP Great Plains Altitude Altitude

NA Navajo Atmospheric Vacuum Atmospheric Vacuum

NS Nashville Backflow Control Backflow Control

OK Oklahoma Blowoff Blowoff

PH Phoenix Check Check

PO Portland Combination Combination

TU Tucson Other Other

Pressure Reducer Pressure Reducer dBuildingMaterial Reduced Pressure Zone Reduced Pressure Zone

FieldType String Surge Relief Surge Relief

Domain Type CodedValue Unknown Unknown

Code Description Vacuum Vacuum

Concrete Block Concrete Block

Other Other dDiameter

Poured Concrete Poured Concrete FieldType Double

PreCast Concrete PreCast Concrete Domain Type Range

Steel Steel Minimum value: 1 Maximum value: 5000

Unknown Unknown

Wood Wood dDissenfectionType

FieldType String dBuildingType Domain Type CodedValue

FieldType String Code Description

Domain Type CodedValue Calcium HypoChloride Calcium HypoChloride

Code Description Chloramine Chloramine

Admin Admin Chlorine Gas Chlorine Gas

Chlorination Chlorination Other Other

Garage Garage Sodium HypoChloride Sodium HypoChloride

Other Other TriChlor TriChlor

Pump House Pump House Unknown Unknown

Sewer Treatment Sewer Treatment UV UV

Storage Storage Water Treatment Water Treatment

Well House Well House

27 | P a g e dDistricts dHydrantClass

FieldType String FieldType String

Domain Type CodedValue Domain Type CodedValue

Code Description Code Description

Albuquerque Albuquerque AA 1500 GPM

Santa Fe Santa Fe A 1000‐1499 GPM

Aleut Aleut B 500‐999 GPM

Interior‐Anthc Lead Interior‐Anthc Lead C Less than 500 GPM

Interior‐Vsw Or Other Lead Interior‐Vsw Or Other Lead Northwest‐Anthc Lead Northwest‐Anthc Lead dHydrantType

Northwest‐Vsw Or Other Lead Northwest‐Vsw Or Other Lead FieldType String

Southern‐Anthc Lead Southern‐Anthc Lead Domain Type CodedValue

Southern‐Vsw Or Other Lead Southern‐Vsw Or Other Lead Code Description

Statewide Statewide Fire Fire

Vsw Only Vsw Only Flush Flush

Western‐Anthc Lead Western‐Anthc Lead Other Other

Western‐Vsw Or Other Lead Western‐Vsw Or Other Lead Unknown Unknown

Area Wide Area Wide Grand Rapids Grand Rapids dLifecycleStatus

Minnesota Minnesota FieldType String

Rhinelander Rhinelander Domain Type CodedValue

Northeast Northeast Code Description

Northwest Northwest Abandoned Abandoned

Southwest Southwest Proposed Proposed

Escondido Escondido Removed Removed

Redding Redding Active Active

Sacramento Sacramento Aberdeen Aberdeen dLiningMethod

Minot Minot FieldType String

Pierre Pierre Domain Type CodedValue

Sioux City Sioux City Code Description

Fort Defiance Fort Defiance Cured in Place Cured in Place

Gallup Gallup Fold and Form or Deform/Reform

Fold and Form or Deform/Reform Shiprock Shiprock

Tuba City Tuba City Segmented Panel Segmented Panel

Northern Northern Segmented Pipe Segmented Pipe

Southern Southern Spiral Wound Spiral Wound

Eastern Eastern Other Other

Self Gov Self Gov None None

Western Western Eado Eado dMainType

Reno Reno FieldType String

Wado Wado Domain Type CodedValue

Olympic Olympic Code Description

Seattle Seattle Forced Main Forced Main

Spokane Spokane Gravity Main Gravity Main

Western Oregon Western Oregon Small Diameter Gravity

Small Diameter Gravity Eastern District Eastern District

Western District Western District Unspecified Unspecified

28 | P a g e dManholeAccess dPumpType

Domain Type CodedValue Domain Type CodedValue

Code Description Code Description

Hand Hole Hand Hole Well Well

Confined Space Confined Space Booster Booster dManholeMaterial dQuality

FieldType String Description Location Quality Levels per 38‐02

Domain Type CodedValue FieldType String

Code Description Domain Type CodedValue

Brick Brick Code Description

Composite Composite

QL‐D

QL‐D is the most basic level of information for utility locations. It comes solely from existing utility records or verbal recollections, both typically unreliable sources. It may provide an overall "feel" for the congestion of utilities but is often h

Concrete Concrete

Fiberglass Fiberglass

HDPE HDPE

Steel Steel

Other Other

Unknown Unknown dManholeType

QL‐C

QL‐C is probably the most used level of information. It involves surveying visible utility facilities (e.g., manholes, valve boxes, etc.) and correlating this information with existing utility records (QL‐D information). When using this information, it

FieldType String

Domain Type CodedValue

Code Description

Drop Drop

Shallow Shallow

Standard Standard

Other Other

Unknown Unknown

QL‐B

QL‐B involves the application of appropriate surface geophysical methods to determine the existence and horizontal position of virtually all utilities within the project limits. This activity is called "designating". The information obtained in this ma dManualAutomatic

FieldType String

Domain Type CodedValue

Code Description

Automatic Automatic

Manual Manual

QL‐A

QL‐A, also known as "locating", is the highest level of accuracy presently available and involves the full use of the subsurface utility engineering services. It provides information for the precise plan and profile mapping of underground utilities thr dMeterType

FieldType String

Domain Type CodedValue

Code Description

Flume Flume

MAG MAG

Turbine Turbine

Other Other

29 | P a g e dScreenType dSewerPumpType

Domain Type CodedValue Domain Type CodedValue

Code Description Code Description

Inline Inline Effluent Lift Effluent Lift

Slotted Slotted Effluent Submersible Effluent Submersible

Shutter Screen Shutter Screen Effluent Suction Lift Effluent Suction Lift

Telescoping Telescoping Effluent Vacuum Effluent Vacuum

Wire Wrap Wire Wrap Submersible Submersible

Suction Lift Suction Lift dSewerComponentType Vacuum Vacuum

FieldType String Other Other

Domain Type CodedValue

Code Description dSewerTreatmentType

Cleanout Cleanout FieldType String

D‐Box D‐Box Domain Type CodedValue

Flow Meter Flow Meter Code Description

Other Other In‐Ground Pressure System In‐Ground Pressure System

Septic Tank Septic Tank Mound Mound

Tide Chamber Tide Chamber Lagoon Lagoon

Treatment Plant Treatment Plant ET ET

Discharge Point Discharge Point ETA ETA

Sand Filter Sand Filter dSewerFittingType Spray Field Spray Field

FieldType String Septic System Septic System

Domain Type CodedValue Drainfield Drainfield

Code Description

Bend Bend dSewerValveType

Cap Cap FieldType String

Other Other Domain Type CodedValue

Reducer Reducer Code Description

Saddle Saddle BackFlow Preventer BackFlowPreventer

Tee Tee Gate Gate

Other Other dSewerPipeMaterial Plug Plug

FieldType String AirRelease Air Release

Domain Type CodedValue Control Type Control Type

Code Description CorporationStop CorporationStop

ABS Plastic ABS Plastic AirVacuum Air/Vacuum Combo

Asbestos Cement Asbestos Cement

Brick Brick dSizingClass

Cast Iron Cast Iron FieldType String

Concrete Concrete Domain Type CodedValue

Ductile Iron Ductile Iron Code Description

HDPE HDPE CTS CTS

Other Other DPS DPS

PE PE IPS IPS

PVC PVC

VC VC

30 | P a g e dScreenType dSewerPumpType

Domain Type CodedValue Domain Type CodedValue

Code Description Code Description

Inline Inline Effluent Lift Effluent Lift

Slotted Slotted Effluent Submersible Effluent Submersible

Shutter Screen Shutter Screen Effluent Suction Lift…