Large Utility Excavation Permits by US Government | Demographics and Population Studies

About this Dataset

Large Utility Excavation Permits

Large excavation permits issued by SF Public Works that are currently active or approved plus permits whose end date passed within the last year. This is a special data set created for the Dig Once Program. Large excavation permits are 1000 square feet in size or larger.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:39.445022
Tags: 5_, excavation, large, paving, permits, plan, utilities, utility, year

Tables

Table 1

@usgov.city_of_san_francisco_large_utility_excavation_permits.table_1

256.66 KB
2980 rows
17 columns


CREATE TABLE table_1 (
  "permit_number" VARCHAR,
  "street_name" VARCHAR,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "cnn" BIGINT,
  "agent" VARCHAR,
  "permit_purpose" VARCHAR,
  "permit_reason" VARCHAR,
  "permit_status" VARCHAR,
  "permit_start_date" VARCHAR,
  "permit_end_date" VARCHAR,
  "permit_renewed_from_permit_number" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);