{"@type": "dcat:Dataset", "accessLevel": "public", "contactPoint": {"@type": "vcard:Contact", "fn": "Rafael Maestu", "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.\r\n\r\n\u201cService connection\u201d means the point of connection between the customer\u2019s piping or constructed conveyance, and the water system\u2019s meter, service pipe, or constructed conveyance.\r\n\r\n\u201cPublic water system\u201d 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.\r\n\r\nPublic 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.\r\n\r\n**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.**\r\n\r\nFor 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", "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=123534a4-1719-4588-af78-357fdbfa4708&limit=0", "describedByType": "application/json", "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. \r\n\u201cService connection\u201d means the point of connection between the customer\u2019s piping or constructed conveyance, and the water system\u2019s meter, service pipe, or constructed conveyance. \r\nThe 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:\r\n\u2022\tAgricultural Irrigation (Irrigation of commercially-grown crops)\r\n\u2022\tCommercial/Institutional (Retail establishments, office buildings, laundries, schools, prisons, hospitals, dormitories, nursing homes, hotels, churches, campgrounds)\r\n\u2022\tIndustrial (All manufacturing)\r\n\u2022\tInactive Service Connections all types (Include only service connections that have been physically disconnected)\r\n\u2022\tLandscape Irrigation (Parks, play fields, cemeteries, median strips, golf courses)\r\n\u2022\tMulti-family Residential (Apartments, condominiums, town houses, duplexes and mobile home parks)\r\n\u2022\tSingle-family Residential (single family detached dwellings)\r\n\u2022\tOther (Fire suppression, street cleaning, line flushing, construction meters, temporary meters). \r\nThis 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", "format": "CSV", "mediaType": "text/csv", "title": "Service Connections \u2013 Reporting Years 2013-2016"}, {"@type": "dcat:Distribution", "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=1694c3ec-0ef2-4425-8287-47ade4d54dc2&limit=0", "describedByType": "application/json", "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. \r\n\u201cService connection\u201d means the point of connection between the customer\u2019s piping or constructed conveyance, and the water system\u2019s meter, service pipe, or constructed conveyance. \r\nThe 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:\r\n\u2022\tAgricultural Irrigation (Irrigation of commercially-grown crops)\r\n\u2022\tCommercial/Institutional (Retail establishments, office buildings, laundries, schools, prisons, hospitals, dormitories, nursing homes, hotels, churches, campgrounds)\r\n\u2022\tIndustrial (All manufacturing)\r\n\u2022\tInactive Service Connections all types (Include only service connections that have been physically disconnected)\r\n\u2022\tLandscape Irrigation (Parks, play fields, cemeteries, median strips, golf courses)\r\n\u2022\tMulti-family Residential (Apartments, condominiums, town houses, duplexes and mobile home parks)\r\n\u2022\tSingle-family Residential (single family detached dwellings)\r\n\u2022\tOther (Fire suppression, street cleaning, line flushing, construction meters, temporary meters). \r\nThis 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", "format": "CSV", "mediaType": "text/csv", "title": "Service Connections \u2013 Reporting Years 2017-2023"}, {"@type": "dcat:Distribution", "describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=8c633f58-b064-4290-82bc-ed68c9015bf6&limit=0", "describedByType": "application/json", "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. \r\n\u201cService connection\u201d means the point of connection between the customer\u2019s piping or constructed conveyance, and the water system\u2019s meter, service pipe, or constructed conveyance. \r\nThe 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:\r\n\u2022\tAgricultural Irrigation (Irrigation of commercially-grown crops)\r\n\u2022\tCommercial/Institutional (Retail establishments, office buildings, laundries, schools, prisons, hospitals, dormitories, nursing homes, hotels, churches, campgrounds)\r\n\u2022\tIndustrial (All manufacturing)\r\n\u2022\tInactive Service Connections all types (Include only service connections that have been physically disconnected)\r\n\u2022\tLandscape Irrigation (Parks, play fields, cemeteries, median strips, golf courses)\r\n\u2022\tMulti-family Residential (Apartments, condominiums, town houses, duplexes and mobile home parks)\r\n\u2022\tSingle-family Residential (single family detached dwellings)\r\n\u2022\tOther (Fire suppression, street cleaning, line flushing, construction meters, temporary meters). \r\nThis 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", "format": "CSV", "mediaType": "text/csv", "title": "Service Connections \u2013 Reporting Years 2013-2023"}, {"@type": "dcat:Distribution", "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. \r\n\u201cService connection\u201d means the point of connection between the customer\u2019s piping or constructed conveyance, and the water system\u2019s meter, service pipe, or constructed conveyance. \r\nThe 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:\r\n\u2022\tAgricultural Irrigation (Irrigation of commercially-grown crops)\r\n\u2022\tCommercial/Institutional (Retail establishments, office buildings, laundries, schools, prisons, hospitals, dormitories, nursing homes, hotels, churches, campgrounds)\r\n\u2022\tIndustrial (All manufacturing)\r\n\u2022\tInactive Service Connections all types (Include only service connections that have been physically disconnected)\r\n\u2022\tLandscape Irrigation (Parks, play fields, cemeteries, median strips, golf courses)\r\n\u2022\tMulti-family Residential (Apartments, condominiums, town houses, duplexes and mobile home parks)\r\n\u2022\tSingle-family Residential (single family detached dwellings)\r\n\u2022\tOther (Fire suppression, street cleaning, line flushing, construction meters, temporary meters). \r\nThis 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", "format": "ZIP", "mediaType": "application/zip", "title": "Service Connections \u2013 Reporting Years 2013-2023"}, {"@type": "dcat:Distribution", "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", "format": "PDF", "mediaType": "application/pdf", "title": "Urban Water Reporting Number of Connections DATA DICTIONARY"}], "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": {"@type": "org:Organization", "name": "California State Water Resources Control Board"}, "title": "Drinking Water - Public Water System Annually Reported Number of Service Connections Metered and Unmetered by Service Connection Type"}