About this Dataset

Boiler Permits

This data set pertains to all permits to operate boilers. Data includes details on application/permit numbers, job addresses, supervisorial districts, and the current status of the applications. Data is uploaded weekly by DBI. Users can access permit information online through DBI’s Permit Tracking System which is 24/7 at www.sfdbi.org/dbipts.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:11.755462
Tags: construction-permits, permit, permits

Tables

Table 1

@usgov.city_of_san_francisco_boiler_permits.table_1

4.8 MB
150,037 rows
26 columns

CREATE TABLE table_1 (
  "permit_number" BIGINT,
  "application_date" TIMESTAMP,
  "block" VARCHAR,
  "lot" VARCHAR,
  "street_number" DOUBLE,
  "street_number_suffix" VARCHAR,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "description" VARCHAR,
  "status" VARCHAR,
  "expiration_date" TIMESTAMP,
  "neighborhoods_analysis_boundaries" VARCHAR  -- Neighborhoods - Analysis Boundaries,
  "boiler_serial_number" VARCHAR,
  "boiler_type" VARCHAR,
  "model" VARCHAR,
  "removal_date" VARCHAR,
  "supervisor_district" DOUBLE,
  "zip_code" DOUBLE,
  "the_geom" VARCHAR,
  "point_source" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE
);