Data dictionary
Field definitions supplied by the publishing agency in CKAN.
| Column | Type | Label | Description |
|---|---|---|---|
| FACILITY ID | numeric | FACILITY ID | — |
| FACILITY NAME | text | FACILITY NAME | — |
| AGENCY NAME | text | AGENCY NAME | — |
| PLACE TYPE | text | PLACE TYPE | — |
| PLACE SUBTYPE | text | PLACE SUBTYPE | — |
| FACILITY TYPE | text | FACILITY TYPE | — |
| AGENCY TYPE | text | AGENCY TYPE | — |
| unsafe___of_agencies | numeric | # OF AGENCIES | — |
| PLACE ADDRESS | text | PLACE ADDRESS | — |
| PLACE CITY | text | PLACE CITY | — |
| PLACE ZIP | text | PLACE ZIP | — |
| PLACE COUNTY | text | PLACE COUNTY | — |
| PLACE LATITUDE | text | PLACE LATITUDE | — |
| PLACE LONGITUDE | numeric | PLACE LONGITUDE | — |
| SIC CODE 1 | text | SIC CODE 1 | — |
| SIC DESC 1 | text | SIC DESC 1 | — |
| SIC CODE 2 | text | SIC CODE 2 | — |
| SIC DESC 2 | text | SIC DESC 2 | — |
| SIC CODE 3 | numeric | SIC CODE 3 | — |
| SIC DESC 3 | text | SIC DESC 3 | — |
| NAICS CODE 1 | numeric | NAICS CODE 1 | — |
| NAICS DESC 1 | text | NAICS DESC 1 | — |
| NAICS CODE 2 | numeric | NAICS CODE 2 | — |
| NAICS DESC 2 | text | NAICS DESC 2 | — |
| NAICS CODE 3 | numeric | NAICS CODE 3 | — |
| NAICS DESC 3 | text | NAICS DESC 3 | — |
| unsafe___of_places | numeric | # OF PLACES | — |
| SOURCE OF FACILITY | text | SOURCE OF FACILITY | — |
| DESIGN FLOW | text | DESIGN FLOW | — |
| THREAT TO WATER QUALITY | numeric | THREAT TO WATER QUALITY | — |
| COMPLEXITY | text | COMPLEXITY | — |
| PRETREATMENT | text | PRETREATMENT | — |
| FACILITY WASTE TYPE | text | FACILITY WASTE TYPE | — |
| FACILITY WASTE TYPE 2 | text | FACILITY WASTE TYPE 2 | — |
| FACILITY WASTE TYPE 3 | text | FACILITY WASTE TYPE 3 | — |
| FACILITY WASTE TYPE 4 | text | FACILITY WASTE TYPE 4 | — |
| WDID | text | WDID | — |
| REG MEASURE ID | text | REG MEASURE ID | — |
| REG MEASURE TYPE | text | REG MEASURE TYPE | — |
| order__ | text | ORDER # | — |
| npdes___ca_ | text | NPDES # CA# | — |
| MAJOR-MINOR | text | MAJOR-MINOR | — |
| NPDES TYPE | text | NPDES TYPE | — |
| RECLAMATION | text | RECLAMATION | — |
| DREDGE FILL FEE | numeric | DREDGE FILL FEE | — |
| unsafe_301h | text | 301H | — |
| APPLICATION FEE AMT RECEIVED | numeric | APPLICATION FEE AMT RECEIVED | — |
| STATUS | text | STATUS | — |
| STATUS DATE | text | STATUS DATE | — |
| EFFECTIVE DATE | text | EFFECTIVE DATE | — |
| expiration_review_date | text | EXPIRATION/REVIEW DATE | — |
| TERMINATION DATE | text | TERMINATION DATE | — |
| WDR REVIEW - AMEND | text | WDR REVIEW - AMEND | — |
| wdr_review___revise_renew | text | WDR REVIEW - REVISE/RENEW | — |
| WDR REVIEW - RESCIND | text | WDR REVIEW - RESCIND | — |
| WDR REVIEW - NO ACTION REQUIRED | text | WDR REVIEW - NO ACTION REQUIRED | — |
| WDR REVIEW - PENDING | text | WDR REVIEW - PENDING | — |
| WDR REVIEW - PLANNED | numeric | WDR REVIEW - PLANNED | — |
| STATUS ENROLLEE | text | STATUS ENROLLEE | — |
| individual_general | text | INDIVIDUAL/GENERAL | — |
| FEE CODE | text | FEE CODE | — |
| direction_voice | text | DIRECTION/VOICE | — |
| enforcement_id__eid_ | text | ENFORCEMENT ID (EID) | — |
| REGION | text | REGION | — |
| order___resolution_number | text | ORDER / RESOLUTION NUMBER | — |
| ENFORCEMENT ACTION TYPE | text | ENFORCEMENT ACTION TYPE | — |
| ENF ACTION EFFECTIVE DATE | text | ENF ACTION EFFECTIVE DATE | — |
| adoption___issuance_date | text | ADOPTION / ISSUANCE DATE | — |
| ACHIEVE DATE | text | ACHIEVE DATE | — |
| enf_action_term__date | text | ENF ACTION TERM. DATE | — |
| ACL ISSUANCE DATE | text | ACL ISSUANCE DATE | — |
| EPL ISSUANCE DATE | text | EPL ISSUANCE DATE | — |
| ENF ACTION STATUS | text | ENF ACTION STATUS | — |
| TITLE | text | TITLE | — |
| DESCRIPTION | text | DESCRIPTION | — |
| PROGRAM | text | PROGRAM | — |
| PROGRAM CATEGORY | text | PROGRAM CATEGORY | — |
| unsafe___of_programs | text | # OF PROGRAMS | — |
| LATEST MILESTONE COMPLETION DATE | text | LATEST MILESTONE COMPLETION DATE | — |
| TOTAL ASSESSMENT AMOUNT | numeric | TOTAL ASSESSMENT AMOUNT | — |
| INITIAL ASSESSED AMOUNT | numeric | INITIAL ASSESSED AMOUNT | — |
| liability___amount | numeric | LIABILITY $ AMOUNT | — |
| project___amount | numeric | PROJECT $ AMOUNT | — |
| liability___paid | numeric | LIABILITY $ PAID | — |
| project___completed | numeric | PROJECT $ COMPLETED | — |
| total___paid_completed_amount | numeric | TOTAL $ PAID/COMPLETED AMOUNT | — |
| AGENCY ISSUING ENF | text | AGENCY ISSUING ENF | — |
| DATE OF OLDEST VIOLATION LINKED TO ENFORCEMENT ACTION | text | DATE OF OLDEST VIOLATION LINKED TO ENFORCEMENT ACTION | — |
Resource details
| Format | CSV |
|---|---|
| Size | 44 MB |
| Rows | 53,416 |
| Last updated | Sep 27, 2026 |
| Part of | Surface Water - Water Quality Regulatory Information |
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=64f25cad-2e10-4a66-8368-79293f56c2f1&limit=5"Results containing "jones"
"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=64f25cad-2e10-4a66-8368-79293f56c2f1&q=jones"SQL query
"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search_sql?sql=SELECT%20%2A%20FROM%20%2264f25cad-2e10-4a66-8368-79293f56c2f1%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: '64f25cad-2e10-4a66-8368-79293f56c2f1', 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=64f25cad-2e10-4a66-8368-79293f56c2f1&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).