SF Housing Balance March 2016
From San Francisco Open Data
@kaggle.san_francisco_sf_housing_balance_march_2016
From San Francisco Open Data
@kaggle.san_francisco_sf_housing_balance_march_2016
The Board of Supervisors passed Ordinance No. 53-15 requiring the San Francisco Planning Department to monitor and report bi-annually on the Housing Balance between new market rate housing and new affordable housing production.
This is a dataset hosted by the city of San Francisco. The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore San Francisco's Data using Kaggle and all of the data sources available through the San Francisco organization page!
This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.
Cover photo by Hanson Lu on Unsplash
Unsplash Images are distributed under a unique Unsplash License.
CREATE TABLE housing_balance_march_2016 (
"st_num" BIGINT,
"st_name" VARCHAR,
"st_type" VARCHAR,
"apn" VARCHAR,
"units" BIGINT,
"netunits_c" BIGINT,
"aff_hsg" BIGINT,
"aff_target" VARCHAR,
"app_no" VARCHAR,
"form" BIGINT,
"ext_use" VARCHAR,
"prop_use" VARCHAR,
"action" VARCHAR,
"action_date" TIMESTAMP,
"bp_descript" VARCHAR,
"staff" VARCHAR,
"year" BIGINT,
"yr_qtr" VARCHAR,
"pln_district_name" VARCHAR,
"supdist" VARCHAR,
"supervisor" BIGINT,
"height" VARCHAR,
"zoning_sim" VARCHAR,
"zoning_districtname" VARCHAR,
"location" VARCHAR
);Anyone who has the link will be able to view this.