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

262.82 kB
2,980 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
);