San Francisco Building Permits

5 years and 200k building permits

@kaggle.aparnashastry_building_permit_applications_data

Table List

1 table(20.6 MB)

Building Permits

@kaggle.aparnashastry_building_permit_applications_data.building_permits

20.6 MB
198900 rows
43 columns

permit_number Permit Number	permit_type Permit Type	permit_type_definition Permit Type Definition	permit_creation_date Permit Creation Date	block Block	lot Lot	street_number Street Number	street_number_suffix Street Number Suffix	street_name Street Name	street_suffix Street Suffix	unit_suffix Unit Suffix	description Description	current_status Current Status	current_status_date Current Status Date	filed_date Filed Date	issued_date Issued Date	completed_date Completed Date	first_construction_document_date First Construction Document Date	structural_notification Structural Notification	number_of_existing_stories Number Of Existing Stories	number_of_proposed_stories Number Of Proposed Stories	voluntary_soft_story_retrofit Voluntary Soft-Story Retrofit	fire_only_permit Fire Only Permit	permit_expiration_date Permit Expiration Date	estimated_cost Estimated Cost	revised_cost Revised Cost	existing_use Existing Use	existing_units Existing Units	proposed_use Proposed Use	proposed_units Proposed Units	plansets Plansets	tidf_compliance TIDF Compliance	existing_construction_type Existing Construction Type	existing_construction_type_description Existing Construction Type Description	proposed_construction_type Proposed Construction Type	proposed_construction_type_description Proposed Construction Type Description	site_permit Site Permit	supervisor_district Supervisor District	neighborhoods_analysis_boundaries Neighborhoods - Analysis Boundaries	zipcode Zipcode	location Location	record_id Record ID
201505065519	4	sign - erect	Wed May 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	0326	023	140	nan	Ellis	St	nan	ground fl facade: to erect illuminated, electric, wall, single faced sign. n/a for maher ordinance 155-13.	expired	Thu Dec 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed May 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)		Mon Nov 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	6		nan	nan	Thu Nov 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4000	4000	tourist hotel/motel	143	nan		2	nan	3	constr type 3		nan	nan	3	Tenderloin	94102	(37.785719256680785, -122.40852313194863)	1380611233945
201604195146	4	sign - erect	Tue Apr 19 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0306	007	440	nan	Geary	St	nan	remove (e) awning and associated signs.	issued	Thu Aug 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 19 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		Thu Aug 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	7		nan	nan	Sun Dec 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1	500	tourist hotel/motel		nan		2	nan	3	constr type 3		nan	nan	3	Tenderloin	94102	(37.78733980600732, -122.41063199757738)	1420164406718
201605278609	3	additions alterations or repairs	Fri May 27 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0595	203	1647	nan	Pacific	Av	nan	installation of separating wall	withdrawn	Tue Sep 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 27 2016 00:00:00 GMT+0000 (Coordinated Universal Time)				nan	6	6	nan	nan		20000		retail sales	39	retail sales	39	2	nan	1	constr type 1	1	constr type 1	nan	3	Russian Hill	94109	(37.7946573324287, -122.42232562979227)	1424856504716
201611072166	8	otc alterations permit	Mon Nov 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0156	011	1230	nan	Pacific	Av	nan	repair dryrot & stucco at front of bldg.	complete	Mon Jul 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2	2	nan	nan	Fri Jul 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2000	2000	1 family dwelling	1	1 family dwelling	1	2	nan	5	wood frame (5)	5	wood frame (5)	nan	3	Nob Hill	94109	(37.79595867909168, -122.41557405519474)	1443574295566
201611283529	6	demolitions	Mon Nov 28 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0342	001	950	nan	Market	St	nan	demolish retail/office/commercial 3-story building	issued	Fri Dec 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 28 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		Mon Nov 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	3		nan	nan	Sat Dec 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	100000	100000	retail sales		nan		2	nan	3	constr type 3		nan	nan	6	Tenderloin	94102	(37.78315261897309, -122.40950883997789)	144548169992
201706149344	8	otc alterations permit	Wed Jun 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	4105	009	800	nan	Indiana	St	nan	evac maps	issued	Thu Jul 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		Thu Jul 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	5	5	nan	Y	Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4000	4000	apartments	326	apartments	326	2	nan	1	constr type 1	1	constr type 1	nan	10	Potrero Hill	94107	(37.75922331346539, -122.39170402628598)	1466911170855
201706300814	8	otc alterations permit	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1739	020	1291	nan	11th	Av	nan	re-roofing	complete	Wed Jul 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	3	3	nan	nan	Mon Jun 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	12000	12000	apartments	5	apartments	5		nan	5	wood frame (5)	5	wood frame (5)	nan	5	Inner Sunset	94122	(37.764145640138565, -122.46875112470363)	1468970403692
M803667	8	otc alterations permit	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	4789	014	1465	nan	Revere	Av	nan	streetspace	issued	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan			nan	nan				nan		nan			nan		nan		nan	nan	10	Bayview Hunters Point	94124	(37.73005099023611, -122.38784938916618)	1469035175050
M804227	8	otc alterations permit	Wed Jul 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1212	054	2094	nan	Fell	St	nan	street space permit	issued	Wed Jul 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		Wed Jul 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan			nan	nan			1	nan		nan			nan		nan		nan	nan	5	Lone Mountain/USF	94117	(37.772393498502595, -122.45231466824669)	1469198253772
M804767	8	otc alterations permit	Thu Jul 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1259	016	89	nan	Alpine	Tr	nan	street space	issued	Thu Jul 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		Thu Jul 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan			nan	nan				nan		nan			nan		nan		nan	nan	8	Haight Ashbury	94117	(37.7691724293766, -122.43734859051908)	146932394171


CREATE TABLE building_permits (
  "permit_number" VARCHAR,
  "permit_type" BIGINT,
  "permit_type_definition" VARCHAR,
  "permit_creation_date" TIMESTAMP,
  "block" VARCHAR,
  "lot" VARCHAR,
  "street_number" BIGINT,
  "street_number_suffix" VARCHAR,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "unit" DOUBLE,
  "unit_suffix" VARCHAR,
  "description" VARCHAR,
  "current_status" VARCHAR,
  "current_status_date" TIMESTAMP,
  "filed_date" TIMESTAMP,
  "issued_date" TIMESTAMP,
  "completed_date" TIMESTAMP,
  "first_construction_document_date" TIMESTAMP,
  "structural_notification" VARCHAR,
  "number_of_existing_stories" DOUBLE,
  "number_of_proposed_stories" DOUBLE,
  "voluntary_soft_story_retrofit" VARCHAR,
  "fire_only_permit" VARCHAR,
  "permit_expiration_date" TIMESTAMP,
  "estimated_cost" DOUBLE,
  "revised_cost" DOUBLE,
  "existing_use" VARCHAR,
  "existing_units" DOUBLE,
  "proposed_use" VARCHAR,
  "proposed_units" DOUBLE,
  "plansets" DOUBLE,
  "tidf_compliance" VARCHAR,
  "existing_construction_type" DOUBLE,
  "existing_construction_type_description" VARCHAR,
  "proposed_construction_type" DOUBLE,
  "proposed_construction_type_description" VARCHAR,
  "site_permit" VARCHAR,
  "supervisor_district" DOUBLE,
  "neighborhoods_analysis_boundaries" VARCHAR,
  "zipcode" DOUBLE,
  "location" VARCHAR,
  "record_id" BIGINT
);