San Francisco Building Permits
5 years and 200k building permits
@kaggle.aparnashastry_building_permit_applications_data
5 years and 200k building permits
@kaggle.aparnashastry_building_permit_applications_data
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
);
Anyone who has the link will be able to view this.