XLSX
Conservation Actions, Per-Column Format
Reported actions to respond to drought/water shortage and/or encourage conservation, as reported in the DRINC Portal monthly report. In this format, each action is its own column, with a "Y" to denote if the action was implemented by the supplier for the corresponding reporting month.
Data dictionary
Field definitions supplied by the publishing agency in CKAN.
| Column | Type | Label | Description |
|---|---|---|---|
| Supplier Name | text | Supplier Name | — |
| Public Water System ID | text | Public Water System ID | — |
| Reporting Month | text | Reporting Month | — |
| Total Population Served | numeric | Total Population Served | — |
| County | text | County | — |
| Hydrologic Region | text | Hydrologic Region | — |
| Climate Zone | numeric | Climate Zone | — |
| Water Shortage Contingency Stage Invoked | text | Water Shortage Contingency Stage Invoked | — |
| DWR Stage | numeric | DWR Stage | — |
| Enacted any measures | text | Enacted any measures | — |
| Not experiencing local shortage | text | Not experiencing local shortage | — |
| don_t_have_the_resources_to_enact_any_of_the_listed_response | text | Don't have the resources to enact any of the listed Response Activities | — |
| Not Enacted Other | text | Not Enacted Other | — |
| Raising rates | text | Raising rates | — |
| Apply drought surcharges | text | Apply drought surcharges | — |
| reduced_allocations__for_agencies_with_budget_based_rates_ | text | Reduced allocations (for agencies with budget-based rates) | — |
| Residential water audits | text | Residential water audits | — |
| CII water audits | text | CII water audits | — |
| Expanded existing rebate program | text | Expanded existing rebate program | — |
| Rationing | text | Rationing | — |
| turf_replacement_rebate | text | Turf replacement/rebate | — |
| Demand Reduction Other | text | Demand Reduction Other | — |
| Greywater | text | Greywater | — |
| On-site treatment and reuse | text | On-site treatment and reuse | — |
| Desalination | text | Desalination | — |
| Recycled Water | text | Recycled Water | — |
| Remediated Groundwater | text | Remediated Groundwater | — |
| Supply Augmentation Other | text | Supply Augmentation Other | — |
| Weekly watering restrictions | text | Weekly watering restrictions | — |
| Use type restrictions | text | Use type restrictions | — |
| Excessive irrigation of outdoor landscapes | text | Excessive irrigation of outdoor landscapes | — |
| washing_a_motor_vehicle_with_a_hose_not_fitted_with_a_shut_o | text | Washing a motor vehicle with a hose not fitted with a shut-off nozzle | — |
| application_of_potable_water_directly_to_driveways_or_sidewa | text | Application of potable water directly to driveways or sidewalks | — |
| Use of potable water in decorative water features | text | Use of potable water in decorative water features | — |
| the_application_of_water_to_irrigate_turf_and_ornamental_lan | text | The application of water to irrigate turf and ornamental landscapes during and within 48 hours after measurable rainfall | — |
| Restrictions Other | text | Restrictions Other | — |
| not_serving_drinking_water_other_than_upon_request_in_eating | text | Not serving drinking water other than upon request in eating or drinking establishments | — |
| operators_of_hotels_and_motels_providing_guests_with_the_opt | text | Operators of hotels and motels providing guests with the option of choosing not to have towels and linens laundered daily | — |
| Requiring water-efficient and drought-tolerant landscaping | text | Requiring water-efficient and drought-tolerant landscaping | — |
| Industry Other | text | Industry Other | — |
| E-mails | text | E-mails | — |
| Paper mail | text | Paper mail | — |
| Notifications via Customer App | text | Notifications via Customer App | — |
| Website | text | Website | — |
| articles_news_releases | text | Articles/News releases | — |
| Youtube | text | Youtube | — |
| text | — | ||
| text | — | ||
| Other Social Media | text | Other Social Media | — |
| Community events | text | Community events | — |
| Door hanger | text | Door hanger | — |
| Workshops | text | Workshops | — |
| Television | text | Television | — |
| Radio | text | Radio | — |
| Billboard | text | Billboard | — |
| Paid Media Advertising | text | Paid Media Advertising | — |
| Bus shelter | text | Bus shelter | — |
| communication_other__fill_in_ | text | Communication Other (Fill-in) | — |
| Assigned a different rate tier | text | Assigned a different rate tier | — |
| Fine | text | Fine | — |
| Penalty Other | text | Penalty Other | — |
| Notification via Door hanger | text | Notification via Door hanger | — |
| Notification via Letter | text | Notification via Letter | — |
| Notification via Other | text | Notification via Other | — |
| Notification via Phone call | text | Notification via Phone call | — |
| Notification via customer app | text | Notification via customer app | — |
| Number of Water Waste incidents identified or reported | numeric | Number of Water Waste incidents identified or reported | — |
| Number of water waste complaints investigated | numeric | Number of water waste complaints investigated | — |
| Number of water wasters notified | numeric | Number of water wasters notified | — |
| Number of water waste incidents resulting in penalties | numeric | Number of water waste incidents resulting in penalties | — |
| Watering on wrong day | text | Watering on wrong day | — |
| Over-irrigating and causing runoff | text | Over-irrigating and causing runoff | — |
| Watering sidewalk | text | Watering sidewalk | — |
| Water use over budget | text | Water use over budget | — |
| Water Waste Other | text | Water Waste Other | — |
Resource details
| Format | XLSX |
|---|---|
| Size | 1.1 MB |
| Rows | 10,037 |
| Last updated | Sep 27, 2026 |
| Part of | Urban Retail Water Supplier - Water Conservation, Supply, and Demand (June 2014 onwards) |
CKAN Data API
Access resource data through the CKAN DataStore API. The examples below use this resource's ID.
Endpoints
The Data API provides these actions. Creating or updating records requires appropriate permissions; the query actions read public DataStore records.
| Create | https://ckan.cdt.dev.datopian.com/api/3/action/datastore_create |
|---|---|
| Update / insert | https://ckan.cdt.dev.datopian.com/api/3/action/datastore_upsert |
| Query | https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search |
| Query via SQL | https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search_sql |
Query examples
First five results
"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=70c0da06-4094-4110-8ac1-18d5c5883b21&limit=5"Results containing "jones"
"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=70c0da06-4094-4110-8ac1-18d5c5883b21&q=jones"SQL query
"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search_sql?sql=SELECT%20%2A%20FROM%20%2270c0da06-4094-4110-8ac1-18d5c5883b21%22%20LIMIT%205"SQL queries depend on whether SQL search is enabled by the portal.
OData query
Use the resource's OData URL and its field names for paging, selecting columns, or filtering rows.
ODATA_RESOURCE_URL?$top=5
ODATA_RESOURCE_URL?$skip=5&$top=5
ODATA_RESOURCE_URL?$select=FIELD_NAME&$filter=FIELD_NAME eq 'VALUE'Replace ODATA_RESOURCE_URL, FIELD_NAME, and VALUE with the details for the selected resource. See the OData query options guide (opens in a new tab) for more examples.
Use the API in code
JavaScript (JSONP)
var data = { resource_id: '70c0da06-4094-4110-8ac1-18d5c5883b21', limit: 5, q: 'jones' };
$.ajax({
url: 'https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search',
data: data,
dataType: 'jsonp',
success: function (response) {
console.log(response.result.total, response.result.records);
}
});Python
import json
from urllib.request import urlopen
url = 'https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=70c0da06-4094-4110-8ac1-18d5c5883b21&limit=5'
with urlopen(url) as response:
result = json.load(response)['result']
print(result['total'], result['records'])For parameters and response fields, see the CKAN DataStore documentation (opens in a new tab).