Plumbing Permits by US Government | Demographics and Population Studies

About this Dataset

Plumbing Permits

This data set pertains to all types of plumbing and mechanical permits. 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:19.467641
Tags: construction-permits, permit, permits

Tables

Table 1

@usgov.city_of_san_francisco_plumbing_permits.table_1

36.18 MB
502705 rows
31 columns


CREATE TABLE table_1 (
  "permit_number" VARCHAR,
  "application_date" TIMESTAMP,
  "block" VARCHAR,
  "lot" VARCHAR,
  "street_number" DOUBLE,
  "street_number_suffix" VARCHAR,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "unit" DOUBLE,
  "unit_suffix" VARCHAR,
  "description" VARCHAR,
  "status" VARCHAR,
  "filed_date" TIMESTAMP,
  "issued_date" TIMESTAMP,
  "completed_date" VARCHAR,
  "neighborhoods_analysis_boundaries" VARCHAR,
  "supervisor_district" DOUBLE,
  "zipcode" DOUBLE,
  "location" VARCHAR,
  "point_source" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "sf_find_neighborhoods_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "current_supervisor_districts_2" DOUBLE,
  "analysis_neighborhoods_2" DOUBLE,
  "current_police_districts_2_2" DOUBLE,
  "zip_codes_2" DOUBLE,
  "fire_prevention_districts_2" DOUBLE,
  "supervisor_districts_2" DOUBLE,
  "neighborhoods" DOUBLE
);