Return to search results
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
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "Rafael Maestu",
"@type": "vcard:Contact",
"hasEmail": "mailto:Rafael.Maestu@waterboards.ca.gov"
}
|
| description | 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 |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "Service Connections – Reporting Years 2013-2016",
"format": "CSV",
"mediaType": "text/csv",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=123534a4-1719-4588-af78-357fdbfa4708&limit=0",
"description": "Includes the number of service connections as of December 31 of each calendar year for the reported years between 2013 and 2026. Count indicates the number of service connections for a public water system for a particular type of service.
“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.
The electronic Annual Report (eAR) requires the PWS to provide the number of connections by type and potable metered or unmetered. Values included in the report for connection types include:
• Agricultural Irrigation (Irrigation of commercially-grown crops)
• Commercial/Institutional (Retail establishments, office buildings, laundries, schools, prisons, hospitals, dormitories, nursing homes, hotels, churches, campgrounds)
• Industrial (All manufacturing)
• Inactive Service Connections all types (Include only service connections that have been physically disconnected)
• Landscape Irrigation (Parks, play fields, cemeteries, median strips, golf courses)
• Multi-family Residential (Apartments, condominiums, town houses, duplexes and mobile home parks)
• Single-family Residential (single family detached dwellings)
• Other (Fire suppression, street cleaning, line flushing, construction meters, temporary meters).
This data in the eAR is self-reported by PWS. The eAR data in this dataset includes some data that appears to have not been reported correctly, in other cases the numbers just look to be irrational. The data is provided as originally reported with minor transformations for machine readability and usability.",
"downloadURL": "https://data.ca.gov/dataset/7c6e7a7f-2594-4c72-9985-fc2fb71e09f9/resource/123534a4-1719-4588-af78-357fdbfa4708/download/2013-2016-connections-by-type-urban-water-reported-ear-status-public.csv",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "Service Connections – Reporting Years 2017-2023",
"format": "CSV",
"mediaType": "text/csv",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=1694c3ec-0ef2-4425-8287-47ade4d54dc2&limit=0",
"description": "Includes the number of service connections as of December 31 of each calendar year for the reported years between 2017 and 2023. Count indicates the number of service connections for a public water system for a particular type of service.
“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.
The electronic Annual Report (eAR) requires the PWS to provide the number of connections by type and potable metered or unmetered. Values included in the report for connection types include:
• Agricultural Irrigation (Irrigation of commercially-grown crops)
• Commercial/Institutional (Retail establishments, office buildings, laundries, schools, prisons, hospitals, dormitories, nursing homes, hotels, churches, campgrounds)
• Industrial (All manufacturing)
• Inactive Service Connections all types (Include only service connections that have been physically disconnected)
• Landscape Irrigation (Parks, play fields, cemeteries, median strips, golf courses)
• Multi-family Residential (Apartments, condominiums, town houses, duplexes and mobile home parks)
• Single-family Residential (single family detached dwellings)
• Other (Fire suppression, street cleaning, line flushing, construction meters, temporary meters).
This data in the eAR is self-reported by PWS. The eAR data in this dataset includes some data that appears to have not been reported correctly, in other cases the numbers just look to be irrational. The data is provided as originally reported with minor transformations for machine readability and usability.",
"downloadURL": "https://data.ca.gov/dataset/7c6e7a7f-2594-4c72-9985-fc2fb71e09f9/resource/1694c3ec-0ef2-4425-8287-47ade4d54dc2/download/2017-2023-connections-by-type-urban-water-reported-ear-status-public.csv",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "Service Connections – Reporting Years 2013-2023",
"format": "CSV",
"mediaType": "text/csv",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=8c633f58-b064-4290-82bc-ed68c9015bf6&limit=0",
"description": "Includes the number of service connections as of December 31 of each calendar year for the reported years between 2013 and 2023. Count indicates the number of service connections for a public water system for a particular type of service.
“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.
The electronic Annual Report (eAR) requires the PWS to provide the number of connections by type and potable metered or unmetered. Values included in the report for connection types include:
• Agricultural Irrigation (Irrigation of commercially-grown crops)
• Commercial/Institutional (Retail establishments, office buildings, laundries, schools, prisons, hospitals, dormitories, nursing homes, hotels, churches, campgrounds)
• Industrial (All manufacturing)
• Inactive Service Connections all types (Include only service connections that have been physically disconnected)
• Landscape Irrigation (Parks, play fields, cemeteries, median strips, golf courses)
• Multi-family Residential (Apartments, condominiums, town houses, duplexes and mobile home parks)
• Single-family Residential (single family detached dwellings)
• Other (Fire suppression, street cleaning, line flushing, construction meters, temporary meters).
This data in the eAR is self-reported by PWS. The eAR data in this dataset includes some data that appears to have not been reported correctly, in other cases the numbers just look to be irrational. The data is provided as originally reported with minor transformations for machine readability and usability.",
"downloadURL": "https://data.ca.gov/dataset/7c6e7a7f-2594-4c72-9985-fc2fb71e09f9/resource/8c633f58-b064-4290-82bc-ed68c9015bf6/download/2013-2023-connections-by-type-urban-water-reported-ear-status-public.csv",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "Service Connections – Reporting Years 2013-2023",
"format": "ZIP",
"mediaType": "application/zip",
"description": "Includes the number of service connections as of December 31 of each calendar year for the reported years between 2013 and 2023. Count indicates the number of service connections for a public water system for a particular type of service.
“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.
The electronic Annual Report (eAR) requires the PWS to provide the number of connections by type and potable metered or unmetered. Values included in the report for connection types include:
• Agricultural Irrigation (Irrigation of commercially-grown crops)
• Commercial/Institutional (Retail establishments, office buildings, laundries, schools, prisons, hospitals, dormitories, nursing homes, hotels, churches, campgrounds)
• Industrial (All manufacturing)
• Inactive Service Connections all types (Include only service connections that have been physically disconnected)
• Landscape Irrigation (Parks, play fields, cemeteries, median strips, golf courses)
• Multi-family Residential (Apartments, condominiums, town houses, duplexes and mobile home parks)
• Single-family Residential (single family detached dwellings)
• Other (Fire suppression, street cleaning, line flushing, construction meters, temporary meters).
This data in the eAR is self-reported by PWS. The eAR data in this dataset includes some data that appears to have not been reported correctly, in other cases the numbers just look to be irrational. The data is provided as originally reported with minor transformations for machine readability and usability.",
"downloadURL": "https://data.ca.gov/dataset/7c6e7a7f-2594-4c72-9985-fc2fb71e09f9/resource/17907100-6632-462f-9b51-519c754837b9/download/2013-2023-connections-by-type-urban-water-reported-ear-status-public.zip"
},
{
"@type": "dcat:Distribution",
"title": "Urban Water Reporting Number of Connections DATA DICTIONARY",
"format": "PDF",
"mediaType": "application/pdf",
"description": "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)",
"downloadURL": "https://data.ca.gov/dataset/7c6e7a7f-2594-4c72-9985-fc2fb71e09f9/resource/1ef3ef10-a44b-4026-b653-d20ca70c24da/download/ear-service-connections-data-dictionary.pdf"
}
]
|
| identifier | 7c6e7a7f-2594-4c72-9985-fc2fb71e09f9 |
| issued | 2024-06-05T19:15:10.631623 |
| keyword |
[
"Drinking Water",
"EAR",
"Electronic Annual Report",
"Service Connections",
"Urban Water",
"Urban Water Reporting",
"Urban Water Service Connections",
"Water Conservation Reporting",
"Water Loss",
"eAR"
]
|
| license | http://www.opendefinition.org/licenses/cc-by |
| modified | 2025-05-08T21:54:19.690443 |
| publisher |
{
"name": "California State Water Resources Control Board",
"@type": "org:Organization"
}
|
| title | Drinking Water - Public Water System Annually Reported Number of Service Connections Metered and Unmetered by Service Connection Type |
