Housing Permitting Activity And Streamlined Ministerial Approval Process (SB35) Determination by US Government | Demographics and Population Studies

About this Dataset

Housing Permitting Activity And Streamlined Ministerial Approval Process (SB35) Determination

A summary of the housing units reported in the Housing Element Annual Progress Forms for the 5th and 6th cycles compared to the Regional Housing Needs Allocation (RHNA) for the purposes of SB 35 determination.
Organization: State of California
Last updated: 2022-11-25T07:02:59.859042
Tags: annual-progress-reports, building-permits, housing-and-community-development, rhna, streamlined-approval

Tables

SB 35 Determination Data

@usgov.ca_gov_housing_permitting_activity_and_streamlined_min_e5d74deb.sb_35_determination_data

87.09 KB
539 rows
45 columns


CREATE TABLE sb_35_determination_data (
  "county" VARCHAR,
  "jurisdiction" VARCHAR,
  "planning_period_progress" VARCHAR,
  "planning_period_evaluated" VARCHAR,
  "planning_period_length_years" BIGINT,
  "planning_period_half_way_point" BIGINT,
  "n_1st_apr" BIGINT,
  "last_apr" BIGINT,
  "planning_period_beginning" TIMESTAMP,
  "planning_period_end" TIMESTAMP,
  "vli_rhna" BIGINT,
  "vli_permits" DOUBLE,
  "vli_dr_units" DOUBLE,
  "vli_ndr_units" DOUBLE,
  "vli_remain_units" BIGINT,
  "vli_complete" VARCHAR,
  "prorated_vli_rhna" BIGINT,
  "excess_vli" BIGINT,
  "li_rhna" BIGINT,
  "li_permits" DOUBLE,
  "li_dr_units" DOUBLE,
  "li_ndr_units" DOUBLE,
  "li_remain_units" BIGINT,
  "lower_permits" BIGINT,
  "lower_remain" BIGINT,
  "li_complete" VARCHAR,
  "lower_complete" VARCHAR,
  "mod_rhna" BIGINT,
  "mod_permits" DOUBLE,
  "mod_remain_units" BIGINT,
  "mod_complete" VARCHAR,
  "above_mod_rhna" BIGINT,
  "above_mod_permits" DOUBLE,
  "above_mod_remain_units" BIGINT,
  "above_mod_complete" VARCHAR,
  "rhna_total" BIGINT,
  "total_permits" DOUBLE,
  "total_remain" BIGINT,
  "proration_factor" VARCHAR,
  "n_10" VARCHAR,
  "n_50" VARCHAR,
  "exempt" VARCHAR,
  "most_recent_year_apr_status" VARCHAR,
  "exempt_but_for_most_recent_year_apr" VARCHAR,
  "n_50_but_for_most_recent_year" VARCHAR
);

5th Cycle Raw Data

@usgov.ca_gov_housing_permitting_activity_and_streamlined_min_e5d74deb.n_5th_cycle_raw_data

75.2 KB
3586 rows
19 columns


CREATE TABLE n_5th_cycle_raw_data (
  "jurisdiction" VARCHAR,
  "county" VARCHAR,
  "period" VARCHAR,
  "apr_year" BIGINT,
  "apr_status" VARCHAR,
  "vli_rhna" BIGINT,
  "vli_permits" BIGINT,
  "vli_dr_units" BIGINT,
  "vli_ndr_units" BIGINT,
  "li_rhna" BIGINT,
  "li_permits" BIGINT,
  "li_dr_units" BIGINT,
  "li_ndr_units" BIGINT,
  "mod_rhna" BIGINT,
  "mod_permits" BIGINT,
  "above_mod_rhna" BIGINT,
  "above_mod_permits" BIGINT,
  "rhna_total" BIGINT,
  "total_units_year_submitted" BIGINT
);

6th Cycle Raw Data

@usgov.ca_gov_housing_permitting_activity_and_streamlined_min_e5d74deb.n_6th_cycle_raw_data

29.5 KB
363 rows
20 columns


CREATE TABLE n_6th_cycle_raw_data (
  "jurisdiction" VARCHAR,
  "county" VARCHAR,
  "period" VARCHAR,
  "apr_year" BIGINT,
  "apr_status" VARCHAR,
  "vli_rhna" BIGINT,
  "vli_permits" BIGINT,
  "vli_dr_units" BIGINT,
  "vli_ndr_units" BIGINT,
  "li_rhna" BIGINT,
  "li_permits" BIGINT,
  "li_dr_units" BIGINT,
  "li_ndr_units" BIGINT,
  "mod_rhna" BIGINT,
  "mod_permits" BIGINT,
  "above_mod_rhna" BIGINT,
  "above_mod_permits" BIGINT,
  "rhna_total" BIGINT,
  "total_units_year_submitted" BIGINT,
  "unnamed_19" VARCHAR
);

Assigned 5th Cycle RHNA

@usgov.ca_gov_housing_permitting_activity_and_streamlined_min_e5d74deb.assigned_5th_cycle_rhna

20.83 KB
539 rows
6 columns


CREATE TABLE assigned_5th_cycle_rhna (
  "jurisdiction" VARCHAR,
  "very_low_income_rhna" BIGINT,
  "low_income_rhna" BIGINT,
  "moderate_income_rhna" BIGINT,
  "above_moderate_income_rhna" BIGINT,
  "total" BIGINT
);

Assigned 6th Cycle RHNA

@usgov.ca_gov_housing_permitting_activity_and_streamlined_min_e5d74deb.assigned_6th_cycle_rhna

19.59 KB
438 rows
6 columns


CREATE TABLE assigned_6th_cycle_rhna (
  "jurisdiction" VARCHAR,
  "very_low_income_rhna" BIGINT,
  "low_income_rhna" BIGINT,
  "moderate_income_rhna" BIGINT,
  "above_moderate_income_rhna" BIGINT,
  "total" BIGINT
);