Drinking Water - Public Water System Annually Reported Number of Service Connections Metered and Unmetered by Service Connection Type
This dataset includes the number of service connections, categorized by type and metering status, as submitted by public water systems via the electronic annual report (eAR) in sections 3 or 4 for calendar years 2013 through 2023 reporting year. It also includes facility public information details from the SDWIS database as metadata associated to the dataset. “Service connection” means the point of connection between the customer’s piping or constructed conveyance, and the water system’s meter, service pipe, or constructed conveyance. “Public water system” means a system for the provision of water for human consumption through pipes or other constructed conveyances that has 15 or more service connections or regularly serves at least 25 individuals daily at least 60 days out of the year. Public water systems submit critical water system information intended to assess the status of compliance with specific regulatory requirements such as source water capacity, provides updated contact and inventory information (such as population and number of service connections) to the to the Division of Drinking Water using the electronic Annual Report (eAR) submission process. **The data in the datasets below are electronically reported annually by public water systems to the State Water Resources Control Board - Division of Drinking Water. The data contained herein are public water system reported data and do not include a determination of accuracy or validity by regulatory staff. For data validated by regulatory staff, refer to the public water system inventory dataset from the Safe Drinking Water Information System (SDWIS), available at: https://data.ca.gov/dataset/drinking-water-public-water-system-information.** For more information about the eAR, visit the eAR Home Page: https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/ear.html
Data files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
Service Connections – Reporting Years 2013-2023 This dataset includes the number of service connections, categorized by type and metering status, as submitted by public water systems via the electronic annual report (eAR) in sections 3 or 4 for calendar years 2013 through 2023 reporting year. It also includes facility public information details from the SDWIS database as metadata associated to the dataset. “Service connection” means the point of connection between the customer’s piping or constructed conveyance, and the water system’s meter, service pipe, or constructed conveyance. “Public water system” means a system for the provision of water for human consumption through pipes or other constructed conveyances that has 15 or more service connections or regularly serves at least 25 individuals daily at least 60 days out of the year. Public water systems submit critical water system information intended to assess the status of compliance with specific regulatory requirements such as source water capacity, provides updated contact and inventory information (such as population and number of service connections) to the to the Division of Drinking Water using the electronic Annual Report (eAR) submission process. **The data in the datasets below are electronically reported annually by public water systems to the State Water Resources Control Board - Division of Drinking Water. The data contained herein are public water system reported data and do not include a determination of accuracy or validity by regulatory staff. For data validated by regulatory staff, refer to the public water system inventory dataset from the Safe Drinking Water Information System (SDWIS), available at: https://data.ca.gov/dataset/drinking-water-public-water-system-information.** For more information about the eAR, visit the eAR Home Page: https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/ear.html | Download | CSV 790.41 MB | 06/05/24 |
Service Connections – Reporting Years 2013-2023 This dataset includes the number of service connections, categorized by type and metering status, as submitted by public water systems via the electronic annual report (eAR) in sections 3 or 4 for calendar years 2013 through 2023 reporting year. It also includes facility public information details from the SDWIS database as metadata associated to the dataset. “Service connection” means the point of connection between the customer’s piping or constructed conveyance, and the water system’s meter, service pipe, or constructed conveyance. “Public water system” means a system for the provision of water for human consumption through pipes or other constructed conveyances that has 15 or more service connections or regularly serves at least 25 individuals daily at least 60 days out of the year. Public water systems submit critical water system information intended to assess the status of compliance with specific regulatory requirements such as source water capacity, provides updated contact and inventory information (such as population and number of service connections) to the to the Division of Drinking Water using the electronic Annual Report (eAR) submission process. **The data in the datasets below are electronically reported annually by public water systems to the State Water Resources Control Board - Division of Drinking Water. The data contained herein are public water system reported data and do not include a determination of accuracy or validity by regulatory staff. For data validated by regulatory staff, refer to the public water system inventory dataset from the Safe Drinking Water Information System (SDWIS), available at: https://data.ca.gov/dataset/drinking-water-public-water-system-information.** For more information about the eAR, visit the eAR Home Page: https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/ear.html | Download | ZIP 53.31 MB | 06/05/24 |
Service Connections – Reporting Years 2013-2016 This dataset includes the number of service connections, categorized by type and metering status, as submitted by public water systems via the electronic annual report (eAR) in sections 3 or 4 for calendar years 2013 through 2023 reporting year. It also includes facility public information details from the SDWIS database as metadata associated to the dataset. “Service connection” means the point of connection between the customer’s piping or constructed conveyance, and the water system’s meter, service pipe, or constructed conveyance. “Public water system” means a system for the provision of water for human consumption through pipes or other constructed conveyances that has 15 or more service connections or regularly serves at least 25 individuals daily at least 60 days out of the year. Public water systems submit critical water system information intended to assess the status of compliance with specific regulatory requirements such as source water capacity, provides updated contact and inventory information (such as population and number of service connections) to the to the Division of Drinking Water using the electronic Annual Report (eAR) submission process. **The data in the datasets below are electronically reported annually by public water systems to the State Water Resources Control Board - Division of Drinking Water. The data contained herein are public water system reported data and do not include a determination of accuracy or validity by regulatory staff. For data validated by regulatory staff, refer to the public water system inventory dataset from the Safe Drinking Water Information System (SDWIS), available at: https://data.ca.gov/dataset/drinking-water-public-water-system-information.** For more information about the eAR, visit the eAR Home Page: https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/ear.html | Download | CSV 368.67 MB | 06/05/24 |
Service Connections – Reporting Years 2017-2023 This dataset includes the number of service connections, categorized by type and metering status, as submitted by public water systems via the electronic annual report (eAR) in sections 3 or 4 for calendar years 2013 through 2023 reporting year. It also includes facility public information details from the SDWIS database as metadata associated to the dataset. “Service connection” means the point of connection between the customer’s piping or constructed conveyance, and the water system’s meter, service pipe, or constructed conveyance. “Public water system” means a system for the provision of water for human consumption through pipes or other constructed conveyances that has 15 or more service connections or regularly serves at least 25 individuals daily at least 60 days out of the year. Public water systems submit critical water system information intended to assess the status of compliance with specific regulatory requirements such as source water capacity, provides updated contact and inventory information (such as population and number of service connections) to the to the Division of Drinking Water using the electronic Annual Report (eAR) submission process. **The data in the datasets below are electronically reported annually by public water systems to the State Water Resources Control Board - Division of Drinking Water. The data contained herein are public water system reported data and do not include a determination of accuracy or validity by regulatory staff. For data validated by regulatory staff, refer to the public water system inventory dataset from the Safe Drinking Water Information System (SDWIS), available at: https://data.ca.gov/dataset/drinking-water-public-water-system-information.** For more information about the eAR, visit the eAR Home Page: https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/ear.html | Download | CSV 421.74 MB | 06/05/24 |
Supporting files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
Urban Water Reporting Number of Connections DATA DICTIONARY This is the data dictionary for the Urban Water Reporting Electronic Annual Report (EAR) Number of Connections dataset. It identifies the data elements that are pulled from the EAR report and those pulled from the federal database SDWIS at the time of the dataset creation (05/01/2025) | PDF 159.66 KB | 06/13/24 |
More details
The data is organized in long format and is provided as reported with minor formatting errors. The data may contain errors in reporting. The master file with all data is a large file that may be difficult to use for some users, that is why we provide multiple datasets for years 2013-2016 and for years 2017-2023, a master file in CSV format and a master file with all years and data in compressed (ZIP) format.
State of California. The data can be filtered by spatial references such as Latitude and Longitude, County, Hydrologic Units (HUC), etc.
Information per Public water system, annual as of December each year, number of connections by type by urban water supplier. One record per year per water system per connection type and metered and unmetered.
English
CSV (Flat File)