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.859048
Tags: annual-progress-reports, building-permits, housing-and-community-development, rhna, streamlined-approval

Tables

Assigned 5th Cycle RHNA

@usgov.ca_gov_housing_permitting_activity_and_streamlined_min_e5d74deb.assigned_5th_cycle_rhna

21.33 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

20.06 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
);

5th Cycle Raw Data

@usgov.ca_gov_housing_permitting_activity_and_streamlined_min_e5d74deb.n_5th_cycle_raw_data

77 kB
3,586 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 (DR) Units,
  "vli_ndr_units" BIGINT  -- VLI (NDR) Units,
  "li_rhna" BIGINT,
  "li_permits" BIGINT,
  "li_dr_units" BIGINT  -- LI (DR) Units,
  "li_ndr_units" BIGINT  -- LI (NDR) Units,
  "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

30.21 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 (DR) Units,
  "vli_ndr_units" BIGINT  -- VLI (NDR) Units,
  "li_rhna" BIGINT,
  "li_permits" BIGINT,
  "li_dr_units" BIGINT  -- LI (DR) Units,
  "li_ndr_units" BIGINT  -- LI (NDR) Units,
  "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  -- Unnamed: 19
);