Planning Department Records - Projects by US Government | Demographics and Population Studies

About this Dataset

Planning Department Records - Projects

A. SUMMARY This dataset is a list of projects and project data captured by PRJ records from the Planning Department's Accela database. Supplemental applications required by the Planning Department to review development projects are captured as related child records (CHILD_ID column) with the PRJ record serving as the parent record. The dataset for related child records and other Planning records can be found at https://data.sfgov.org/Economy-and-Community/Planning-Department-Non-Projects/y673-d69b/about_data. B. HOW THE DATASET IS CREATED Records have been exported from the Planning Department's Accela permitting system. C. UPDATE PROCESS Updated nightly D. HOW TO USE THIS DATASET For further information on permits: https://sfplanning.org/permits
Organization: City of San Francisco
Last updated: 2025-03-29T17:08:09.637051
Tags: planning, projects

Tables

Table 1

@usgov.city_of_san_francisco_planning_department_records_projects.table_1

8.86 MB
53016 rows
106 columns


CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "record_type" VARCHAR,
  "project_name" VARCHAR,
  "description" VARCHAR,
  "record_status" VARCHAR,
  "project_address" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "child_id" VARCHAR,
  "open_date" VARCHAR,
  "close_date" VARCHAR,
  "building_permits" VARCHAR,
  "applicant" VARCHAR,
  "applicant_org" VARCHAR,
  "assigned_to_planner" VARCHAR,
  "project_decision" VARCHAR,
  "project_decision_date" VARCHAR,
  "environmental_document_type" VARCHAR,
  "environmental_document_date" VARCHAR,
  "number_of_units_net" DOUBLE,
  "number_of_market_rate_units_net" BIGINT,
  "number_of_affordable_units_net" BIGINT,
  "number_of_units_exist" BIGINT,
  "number_market_rate_units_exist" BIGINT,
  "number_affordable_units_exist" BIGINT,
  "number_of_units_prop" BIGINT,
  "number_market_rate_units_prop" BIGINT,
  "number_affordable_units_prop" BIGINT,
  "change_of_use" VARCHAR,
  "additions" VARCHAR,
  "new_construction" VARCHAR,
  "leg_zone_change" VARCHAR,
  "demolition" VARCHAR,
  "lot_line_adjust" VARCHAR,
  "facade_alt" VARCHAR,
  "row_improve" VARCHAR,
  "other_prj_desc" VARCHAR,
  "formula_retail" VARCHAR,
  "cannabis" VARCHAR,
  "massage" VARCHAR,
  "tobacco" VARCHAR,
  "financial" VARCHAR,
  "other_non_res_desc" VARCHAR,
  "special_needs" VARCHAR,
  "senior" VARCHAR,
  "affordable_units" VARCHAR,
  "student" VARCHAR,
  "inclusionary" VARCHAR,
  "adu" VARCHAR,
  "legalization" VARCHAR,
  "sb35" VARCHAR,
  "ab2162" VARCHAR,
  "housing_sustainability_dist" VARCHAR,
  "rental_units" VARCHAR,
  "ownership_units" VARCHAR,
  "unkown_units" VARCHAR,
  "sb330" VARCHAR,
  "homesf" VARCHAR,
  "state_density_bonus_analyzed" VARCHAR,
  "state_density_bonus_individual" VARCHAR,
  "ahbp_100_percent_affordable" VARCHAR,
  "environmental_review_type" VARCHAR,
  "residential_exist" DOUBLE,
  "parking_spaces_exist" DOUBLE,
  "car_share_spaces_exist" DOUBLE,
  "parking_gsf_exist" DOUBLE,
  "retail_commercial_exist" DOUBLE,
  "office_exist" DOUBLE,
  "industrial_pdr_exist" DOUBLE,
  "medical_exist" DOUBLE,
  "visitor_exist" DOUBLE,
  "cie_exist" DOUBLE,
  "residential_prop" DOUBLE,
  "parking_spaces_prop" DOUBLE,
  "car_share_spaces_prop" DOUBLE,
  "parking_gsf_prop" DOUBLE,
  "retail_commercial_prop" DOUBLE,
  "office_prop" DOUBLE,
  "industrial_pdr_prop" DOUBLE,
  "medical_prop" DOUBLE,
  "visitor_prop" DOUBLE,
  "cie_prop" DOUBLE,
  "residential_studio_exist" DOUBLE,
  "residential_1br_exist" DOUBLE,
  "residential_2br_exist" DOUBLE,
  "residential_3br_exist" DOUBLE,
  "residential_adu_studio_exist" DOUBLE,
  "residential_adu_1br_exist" DOUBLE,
  "residential_adu_2br_exist" DOUBLE,
  "residential_adu_3br_exist" DOUBLE,
  "residential_gh_rooms_exist" DOUBLE,
  "residential_gh_beds_exist" DOUBLE,
  "residential_sro_exist" DOUBLE,
  "residential_micro_exist" DOUBLE,
  "residential_studio_prop" DOUBLE,
  "residential_1br_prop" DOUBLE,
  "residential_2br_prop" DOUBLE,
  "residential_3br_prop" DOUBLE,
  "residential_adu_studio_prop" DOUBLE,
  "residential_adu_1br_prop" DOUBLE
);