Fire Permits by US Government | Demographics and Population Studies

About this Dataset

Fire Permits

Information on Fire Permits issued by the Fire Department for a particular location. Key fields include Permit Number, Permit Type, Address, Permit Start Dt, Permit Status, Special Conditions, Location.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:16.788964
Tags: fire-safety, permits

Tables

Table 1

@usgov.city_of_san_francisco_fire_permits.table_1

4.55 MB
80825 rows
36 columns


CREATE TABLE table_1 (
  "permit_number" BIGINT,
  "permit_type" VARCHAR,
  "permit_type_description" VARCHAR,
  "permit_address" VARCHAR,
  "permit_zipcode" DOUBLE,
  "battalion" VARCHAR,
  "station_area" VARCHAR,
  "fire_prevention_district" VARCHAR,
  "permit_application_date" TIMESTAMP,
  "permit_date_approved" TIMESTAMP,
  "inspection_number" DOUBLE,
  "expiration_date" TIMESTAMP,
  "night_place_of_assembly_permit" BOOLEAN,
  "permit_status" VARCHAR,
  "inspection_date" TIMESTAMP,
  "hearing_calendar_date" TIMESTAMP,
  "hearing_status" VARCHAR,
  "permit_fee" DOUBLE,
  "referral_fee" DOUBLE,
  "posting_fee" DOUBLE,
  "date_all_permit_fees_were_paid" TIMESTAMP,
  "unit_count" DOUBLE,
  "unit_type" VARCHAR,
  "permit_holder" VARCHAR,
  "tax_class" VARCHAR,
  "dba_name_associated_with_this_permit_holder" VARCHAR,
  "supervisor_district" DOUBLE,
  "neighborhood_district" VARCHAR,
  "location" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE
);