Data Terms

Key to data in Public Water System General data files and in Source data files

Public Water System General Data Files

Data Type Description
PwsID Text - 5 The ID which uniquely identifies a PWS. Assigned by the Office of Drinking Water when a new PWS is identified.
SystemName Text - 5 The name of a public water system.
Group Text - 1 A single character, A or B, that represents the category of the system.
County Text - 20 The name of the county where the PWS is located.
OwnerTypeDesc Text - 35 A description of the type of ownership for a given PWS.
ResPop Numeric - 6 The residential population served by the PWS.
ResConn Numeric - 6 The quantity of active residential connections for a given PWS.
TotalConn Numeric - 8 The total number of connections for a given PWS.
EffectiveDate Date - 8 The date on which a PWS becomes effective, i.e. identified as an active PWS by the Office of Drinking Water.
PwsAttn Text - 35 First address line pertaining to a specific PWS.
PwsAddress2 Text - 35 Second line of the mailing address pertaining to a PWS.
PwsCity Text - 35 The city name of the PWS address.
PwsState Text - 2 The state name of the PWS address.
PwsZipCode Text - 9 The zip code of the PWS address.
ApprovServices Numeric - 7 The quantity of approved services (per plans) for a given PWS.

Source Files

Data Type Description
PwsID Text - 5 The ID which uniquely identifies a PWS. Assigned by the Office of Drinking Water when a new PWS is identified.
Group Text - 1 A single character, A or B, that represents the category of the system.
SystemName Text - 5 The name of a PWS.
County Text - 20 The name of the county where the PWS is located.
SrcNum Text - 2 A number which uniquely identifies a given source within a PWS.
Src_Name Text - 35 The official or standard name of a given source as determined by the PWS.
SourceType Text - 35 A description of the type of source.
SourceUse Text - 35 A description of the use of the source (emergency, seasonal, permanent).
TrObjective Text - 35 The name of the treatment objective related to a specific source.
TrProcess Text - 35 The description of the treatment process for a given PWS of drinking water source.
Src_EffectiveDate Date - 8 The date on which a given source becomes effective, i.e. becomes actively used by the PWS as a source of drinking water.
Src_InactiveDate Date - 8 The date on which a given source is no longer active, i.e. is not being used as a source of drinking water.

Public Disclosure Statement

The information provided in this website is believed to be accurate and reliable. However, the Washington State Department of Health (DOH) assumes no responsibility for errors in the content of the information provided. Further, DOH assumes no responsibility for the use of the information provided. Information provided is considered public information and may be distributed or copied.