CSV
2015 CA AHSC With CalEnviroScreen Data And Population
This version of the original AHSC data contains Census 2010 population figures for cities and counties that were awarded AHSC grants as well as CalEnviroScreen scores and percentiles.
Data dictionary
Field definitions supplied by the publishing agency in CKAN.
| Column | Type | Label | Description |
|---|---|---|---|
| PIN | numeric | PIN | — |
| Project Name | text | Project Name | — |
| Applicant Developer | text | Applicant Developer | — |
| Award Date | date | Award Date | — |
| MPO | text | MPO | — |
| County | text | County | — |
| County Pop | numeric | County Pop | — |
| county_average_ces_3_0_score | numeric | County Average CES 3.0 Score | — |
| county_average_ces_3_0_percentile | numeric | County Average CES 3.0 Percentile | — |
| Project City | text | Project City | — |
| City Pop | numeric | City Pop | — |
| average_ces_3_0_score | numeric | Average CES 3.0 Score | — |
| average_ces_3_0_percentile | numeric | Average CES 3.0 Percentile | — |
| Rural | text | Rural | — |
| Senate District | numeric | Senate District | — |
| Assembly District | numeric | Assembly District | — |
| Project Type | text | Project Type | — |
| Affordable Housing Setaside | text | Affordable Housing Setaside | — |
| Disadvantaged Community Setaside | text | Disadvantaged Community Setaside | — |
| Total Awarded | text | Total Awarded | — |
| Affordable Housing Development | text | Affordable Housing Development | — |
| Housing-Related Infrastructure | text | Housing-Related Infrastructure | — |
| Transportation-Related Infrastructure | text | Transportation-Related Infrastructure | — |
| Planning | text | Planning | — |
| Programs | text | Programs | — |
| GHG Reductions per ARB Verification | numeric | GHG Reductions per ARB Verification | — |
| Metric Tons GHGs reduced per GGRF Requested | numeric | Metric Tons GHGs reduced per GGRF Requested | — |
| Number of affordable Units | numeric | Number of affordable Units | — |
| Number of ELI Units | numeric | Number of ELI Units | — |
| Number of VL Units | numeric | Number of VL Units | — |
| Number of L Units | numeric | Number of L Units | — |
| Percent Affordable | text | Percent Affordable | — |
| Senior | numeric | Senior | — |
| Supportive | numeric | Supportive | — |
| Transitional | numeric | Transitional | — |
| Veteran | numeric | Veteran | — |
| Housing Density | numeric | Housing Density | — |
| tri_as_percent_of_total_funds_requested_awarded | text | TRI as percent of total funds requested/awarded | — |
| Bikeways | text | Bikeways | — |
| walkways__crossings_and_traffic_calming | text | Walkways, crossings and traffic calming | — |
| bike_racks__storage__repair_kiosks | text | Bike racks, storage, repair kiosks | — |
| Transit Station Area Improvements | text | Transit Station Area Improvements | — |
| transit_service_intelligent_transportation_systems_its_techn | text | Transit Service/Intelligent Transportation Systems ITS Technology | — |
| streetscaping_street_furniture | text | Streetscaping/Street Furniture | — |
| Other Costs | text | Other Costs | — |
| transit_related_plans__specifications___estimates_ps_e_demol | text | Transit-Related Plans, Specifications & Estimates PS&E Demolition/Site Prep | — |
| Total sidewalks funded in linear ft | numeric | Total sidewalks funded in linear ft | — |
| Crosswalks installed | numeric | Crosswalks installed | — |
| Bike facilities funded in linear miles | numeric | Bike facilities funded in linear miles | — |
| bicycle_parking_storage_spaces | numeric | Bicycle parking/storage spaces | — |
| CoBenefit 1 | text | CoBenefit 1 | — |
| CoBenefit 2 | text | CoBenefit 2 | — |
| CoBenefit 3 | text | CoBenefit 3 | — |
| Latitude | numeric | Latitude | — |
| Longitude | numeric | Longitude | — |
Resource details
| Format | CSV |
|---|---|
| Size | 20 KB |
| Rows | 36 |
| Last updated | Sep 26, 2026 |
| Part of | California Affordable Housing and Sustainable Communities |
Other resources in this dataset
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=51c821e8-91ac-4dd3-b53d-e04aba17f30f&limit=5"Results containing "jones"
"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=51c821e8-91ac-4dd3-b53d-e04aba17f30f&q=jones"SQL query
"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search_sql?sql=SELECT%20%2A%20FROM%20%2251c821e8-91ac-4dd3-b53d-e04aba17f30f%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: '51c821e8-91ac-4dd3-b53d-e04aba17f30f', 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=51c821e8-91ac-4dd3-b53d-e04aba17f30f&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).