About this Dataset

California Affordable Housing And Sustainable Communities

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.
Organization: State of California
Last updated: 2021-09-08T16:15:42.869001
Tags: affordable-housing, cap-and-trade, disadvantaged-communities, greenhouse-gas-reduction-fund, housing, infrastructure, sb-535, sustainable-communities-strategies, transportation

Tables

2015 CA Affordable Housing And Sustainable Communities (AHSC) Awards

@usgov.ca_gov_california_affordable_housing_and_sustainable_c_606e9aa2.n_2015_ca_affordable_housing_and_sustainable_communiti_2e13169d

45.33 KB
36 rows
49 columns


CREATE TABLE n_2015_ca_affordable_housing_and_sustainable_communiti_2e13169d (
  "pin" BIGINT,
  "project_name" VARCHAR,
  "applicant_developer" VARCHAR,
  "award_date" VARCHAR,
  "mpo" VARCHAR,
  "county" VARCHAR,
  "project_city" VARCHAR,
  "rural" VARCHAR,
  "senate_district" BIGINT,
  "assembly_district" BIGINT,
  "project_type" VARCHAR,
  "affordable_housing_setaside" VARCHAR,
  "disadvantaged_community_setaside" VARCHAR,
  "total_awarded" VARCHAR,
  "affordable_housing_development" VARCHAR,
  "housing_related_infrastructure" VARCHAR,
  "transportation_related_infrastructure" VARCHAR,
  "planning" VARCHAR,
  "programs" VARCHAR,
  "ghg_reductions_per_arb_verification" DOUBLE,
  "metric_tons_ghgs_reduced_per_ggrf_requested" DOUBLE,
  "number_of_affordable_units" DOUBLE,
  "number_of_eli_units" DOUBLE,
  "number_of_vl_units" DOUBLE,
  "number_of_l_units" DOUBLE,
  "percent_affordable" VARCHAR,
  "senior" DOUBLE,
  "supportive" DOUBLE,
  "transitional" DOUBLE,
  "veteran" DOUBLE,
  "housing_density" DOUBLE,
  "tri_as_percent_of_total_funds_requested_awarded" VARCHAR,
  "bikeways" VARCHAR,
  "walkways_crossings_and_traffic_calming" VARCHAR,
  "bike_racks_storage_repair_kiosks" VARCHAR,
  "transit_station_area_improvements" VARCHAR,
  "transit_service_intelligent_transportation_systems_its_10cf025c" VARCHAR,
  "streetscaping_street_furniture" VARCHAR,
  "other_costs" VARCHAR,
  "transit_related_plans_specifications_estimates_ps_e_de_59bfb6c4" VARCHAR,
  "total_sidewalks_funded_in_linear_ft" DOUBLE,
  "crosswalks_installed" DOUBLE,
  "bike_facilities_funded_in_linear_miles" DOUBLE,
  "bicycle_parking_storage_spaces" DOUBLE,
  "cobenefit_1" VARCHAR,
  "cobenefit_2" VARCHAR,
  "cobenefit_3" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2015 CA AHSC With CalEnviroScreen Data And Population

@usgov.ca_gov_california_affordable_housing_and_sustainable_c_606e9aa2.n_2015_ca_ahsc_with_calenviroscreen_data_and_population

50.94 KB
36 rows
55 columns


CREATE TABLE n_2015_ca_ahsc_with_calenviroscreen_data_and_population (
  "pin" BIGINT,
  "project_name" VARCHAR,
  "applicant_developer" VARCHAR,
  "award_date" VARCHAR,
  "mpo" VARCHAR,
  "county" VARCHAR,
  "county_pop" DOUBLE,
  "county_average_ces_3_0_score" DOUBLE,
  "county_average_ces_3_0_percentile" DOUBLE,
  "project_city" VARCHAR,
  "city_pop" BIGINT,
  "average_ces_3_0_score" DOUBLE,
  "average_ces_3_0_percentile" DOUBLE,
  "rural" VARCHAR,
  "senate_district" BIGINT,
  "assembly_district" BIGINT,
  "project_type" VARCHAR,
  "affordable_housing_setaside" VARCHAR,
  "disadvantaged_community_setaside" VARCHAR,
  "total_awarded" VARCHAR,
  "affordable_housing_development" VARCHAR,
  "housing_related_infrastructure" VARCHAR,
  "transportation_related_infrastructure" VARCHAR,
  "planning" VARCHAR,
  "programs" VARCHAR,
  "ghg_reductions_per_arb_verification" DOUBLE,
  "metric_tons_ghgs_reduced_per_ggrf_requested" DOUBLE,
  "number_of_affordable_units" DOUBLE,
  "number_of_eli_units" DOUBLE,
  "number_of_vl_units" DOUBLE,
  "number_of_l_units" DOUBLE,
  "percent_affordable" VARCHAR,
  "senior" DOUBLE,
  "supportive" DOUBLE,
  "transitional" DOUBLE,
  "veteran" DOUBLE,
  "housing_density" DOUBLE,
  "tri_as_percent_of_total_funds_requested_awarded" VARCHAR,
  "bikeways" VARCHAR,
  "walkways_crossings_and_traffic_calming" VARCHAR,
  "bike_racks_storage_repair_kiosks" VARCHAR,
  "transit_station_area_improvements" VARCHAR,
  "transit_service_intelligent_transportation_systems_its_10cf025c" VARCHAR,
  "streetscaping_street_furniture" VARCHAR,
  "other_costs" VARCHAR,
  "transit_related_plans_specifications_estimates_ps_e_de_59bfb6c4" VARCHAR,
  "total_sidewalks_funded_in_linear_ft" DOUBLE,
  "crosswalks_installed" DOUBLE,
  "bike_facilities_funded_in_linear_miles" DOUBLE,
  "bicycle_parking_storage_spaces" DOUBLE,
  "cobenefit_1" VARCHAR,
  "cobenefit_2" VARCHAR,
  "cobenefit_3" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

2017 CA Affordable Housing And Sustainable Communities (AHSC) Round 3 Awards

@usgov.ca_gov_california_affordable_housing_and_sustainable_c_606e9aa2.n_2017_ca_affordable_housing_and_sustainable_communiti_d6d19f32

9.03 KB
19 rows
9 columns


CREATE TABLE n_2017_ca_affordable_housing_and_sustainable_communiti_d6d19f32 (
  "project_type" VARCHAR,
  "pin" BIGINT,
  "project_name" VARCHAR,
  "applicants" VARCHAR,
  "project_location" VARCHAR,
  "project_area_type" VARCHAR,
  "dac" VARCHAR,
  "low_income" VARCHAR,
  "n__total_ahsc_requested" VARCHAR
);