CSV
2015 CA Affordable Housing And Sustainable Communities (AHSC) Awards
This dataset includes all Affordable Housing and Sustainable Communities Awards. This includes the location of the awards, the award amounts, award amounts for each Project component, GHG reductions, and co-benefits.
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 | — |
| Project City | text | Project City | — |
| 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 | 17 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=6618d37e-dd4f-480e-8160-2f1ab8285815&limit=5"Results containing "jones"
"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=6618d37e-dd4f-480e-8160-2f1ab8285815&q=jones"SQL query
"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search_sql?sql=SELECT%20%2A%20FROM%20%226618d37e-dd4f-480e-8160-2f1ab8285815%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: '6618d37e-dd4f-480e-8160-2f1ab8285815', 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=6618d37e-dd4f-480e-8160-2f1ab8285815&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).