About this Dataset

Mayor's Office Of Housing And Community Development Affordable Housing Pipeline

Snapshot of the Mayor’s Office of Housing and Community Development (MOHCD) and the Office of Community Investment and Infrastructure (OCII) affordable housing pipeline projects. The projects listed are in the process of development--or are anticipated to be developed--in partnership with non-profit or for-profit developers and financed through city funding agreements, ground leases, disposition and participation agreements and conduit bond financing. The Affordable Housing Pipeline also includes housing units produced by private developers through the Inclusionary Affordable Housing Program. Data reflects all projects as of September 30, 2023.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:19.670469
Tags: affordable-housing, mohcd, ocii, pipeline

Tables

Table 1

@usgov.city_of_san_francisco_affordable_housing_pipeline.table_1

87.75 kB
200 rows
67 columns

CREATE TABLE table_1 (
  "project_id" VARCHAR,
  "project_name" VARCHAR,
  "project_status" VARCHAR,
  "construction_status" VARCHAR,
  "plannning_approval_address" VARCHAR,
  "zip_code" BIGINT,
  "block" VARCHAR,
  "lot" VARCHAR,
  "supervisor_district" BIGINT,
  "city_analysis_neighborhood" VARCHAR,
  "planning_neighborhood" VARCHAR,
  "lead_agency" VARCHAR,
  "general_housing_program" VARCHAR,
  "specific_program_area" VARCHAR,
  "multiphase_or_multisite_project_name" VARCHAR,
  "redevelopment_project_area" VARCHAR,
  "project_type" VARCHAR,
  "housing_tenure" VARCHAR,
  "ssp_acquisition_date" TIMESTAMP,
  "issuance_of_notice_to_proceed_date" TIMESTAMP,
  "issuance_of_building_permit_date" TIMESTAMP,
  "issuance_of_first_construction_document_date" TIMESTAMP,
  "estimated_actual_construction_start_date" TIMESTAMP,
  "estimated_construction_completion_date" TIMESTAMP,
  "project_lead_sponsor" VARCHAR,
  "project_co_sponsor" VARCHAR,
  "project_owner" VARCHAR,
  "planning_case_number" VARCHAR,
  "planning_entitlements" VARCHAR,
  "entitlement_approval_date" TIMESTAMP,
  "section_415_declaration" VARCHAR,
  "total_project_units" BIGINT,
  "mohcd_affordable_units" BIGINT,
  "n__affordable" BIGINT  -- % Affordable,
  "sro_units" BIGINT,
  "studio_units" BIGINT,
  "n_1bd_units" BIGINT  -- 1bd Units,
  "n_2bd_units" BIGINT  -- 2bd Units,
  "n_3bd_units" BIGINT  -- 3bd Units,
  "n_4bd_units" BIGINT  -- 4bd Units,
  "n_5_bd_units" BIGINT  -- 5+ Bd Units,
  "mobility_units" BIGINT,
  "family_units" BIGINT,
  "senior_units" BIGINT,
  "tay_units" BIGINT,
  "homeless_units" BIGINT,
  "disabled_units" BIGINT,
  "losp_units" BIGINT,
  "public_housing_replacement_units" BIGINT,
  "n_20_ami" BIGINT  -- 20% AMI,
  "n_30_ami" BIGINT  -- 30% AMI,
  "n_40_ami" BIGINT  -- 40% AMi,
  "n_50_ami" BIGINT  -- 50% AMI,
  "n_55_ami" BIGINT  -- 55% AMI,
  "n_60_ami" BIGINT  -- 60% AMI,
  "n_80_ami" BIGINT  -- 80% AMI,
  "n_90_ami" BIGINT  -- 90% AMI,
  "n_100_ami" BIGINT  -- 100% AMI,
  "n_105_ami" BIGINT  -- 105% AMI,
  "n_110_ami" BIGINT  -- 110% AMI,
  "n_120_ami" BIGINT  -- 120% AMI,
  "n_130_ami" BIGINT  -- 130% AMI,
  "n_150_ami" BIGINT  -- 150% AMI,
  "ami_undeclared" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);