About this Dataset

Regression Data For Inclusionary Housing Simulation Model

In order to understand how higher inclusionary housing requirements affects the feasibility of new market-rate housing development, the Controller's Office contracted with Blue Sky Consulting Group to statistically model the factors that affect the probability of housing development in San Francisco. This data underlies the model reported in our preliminary report. An overview of the statistical analysis is provided in main section of the report, with more details provided in the Appendix.
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:01.018212
Tags: inclusionary-housing, probability, regression-model, statistics

Tables

Table 1

@usgov.city_of_san_francisco_regression_for_inclusionary_hous_d5919272.table_1

9.21 MB
2,315,130 rows
105 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "dev_year" BIGINT,
  "mapblklot_master" VARCHAR,
  "mapblklot_year" VARCHAR,
  "res_dummy" BIGINT,
  "price_oea" DOUBLE,
  "inc_costsqft" DOUBLE,
  "inc_unitfee1000" DOUBLE,
  "price_zillow" DOUBLE,
  "rentcomm_yrend" DOUBLE,
  "rentcomm_avg" DOUBLE,
  "constr_index" DOUBLE,
  "bldg_index" DOUBLE,
  "permits_msa_tot" BIGINT,
  "permits_msa_5plus" BIGINT,
  "sfcity_unemprate" DOUBLE,
  "sfcity_emp" BIGINT,
  "sfmsa_unemprate" DOUBLE,
  "sfmsa_emp" BIGINT,
  "dj_tsm" DOUBLE,
  "sp500" DOUBLE,
  "nasdaq" DOUBLE,
  "conf_cb" DOUBLE,
  "conf_um" DOUBLE,
  "intrate_10yr" DOUBLE,
  "intrate_mortg" DOUBLE,
  "landuse_asgiven" VARCHAR,
  "lu_yr_missing" BIGINT,
  "lu_yr_cie" BIGINT,
  "lu_yr_ind" BIGINT,
  "lu_yr_med" BIGINT,
  "lu_yr_mips" BIGINT,
  "lu_yr_mixed" BIGINT,
  "lu_yr_openspace" BIGINT,
  "lu_yr_paperlot" BIGINT,
  "lu_yr_public" BIGINT,
  "lu_yr_resid" BIGINT,
  "lu_yr_retail" BIGINT,
  "lu_yr_row" BIGINT,
  "lu_yr_vacant" BIGINT,
  "lu_yr_visitor" BIGINT,
  "zoning_asgiven" VARCHAR,
  "z_commercial" BIGINT,
  "z_dtr" BIGINT,
  "z_missing" BIGINT,
  "z_mixeduse" BIGINT,
  "z_open" BIGINT,
  "z_pdr" BIGINT,
  "z_public" BIGINT,
  "z_rc3" BIGINT,
  "z_rc4" BIGINT,
  "z_redev" BIGINT,
  "z_res_low" BIGINT,
  "z_rm1" BIGINT,
  "z_rm2" BIGINT,
  "z_rm3" BIGINT,
  "z_rm4" BIGINT,
  "z_rsd" BIGINT,
  "z_rto" BIGINT,
  "z_sli" BIGINT,
  "z_slr" BIGINT,
  "z_sso" BIGINT,
  "parkingminreq" DOUBLE,
  "area" DOUBLE,
  "bldg_sqft_use" DOUBLE,
  "env_1000_dens" DOUBLE,
  "shistoric1" BIGINT,
  "devpotential_dens" DOUBLE,
  "n_bayview" BIGINT,
  "n_bernal" BIGINT,
  "n_castro" BIGINT,
  "n_china" BIGINT,
  "n_crocker" BIGINT,
  "n_diamond" BIGINT,
  "n_downtown" BIGINT,
  "n_excel" BIGINT,
  "n_finan" BIGINT,
  "n_ggpark" BIGINT,
  "n_haight" BIGINT,
  "n_inrich" BIGINT,
  "n_insun" BIGINT,
  "n_lakeshore" BIGINT,
  "n_marina" BIGINT,
  "n_mission" BIGINT,
  "n_missbay" BIGINT,
  "n_nob" BIGINT,
  "n_noe" BIGINT,
  "n_northb" BIGINT,
  "n_oceanv" BIGINT,
  "n_outmiss" BIGINT,
  "n_outrich" BIGINT,
  "n_outsun" BIGINT,
  "n_pachts" BIGINT,
  "n_parkside" BIGINT,
  "n_potrero" BIGINT,
  "n_presid" BIGINT,
  "n_presidht" BIGINT,
  "n_russian" BIGINT,
  "n_seacliff" BIGINT,
  "n_soma" BIGINT
);