Name: Utility Excavation Permits
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Utility Excavation Permits

Excavation permits issued by SF Public Works whose status is active or approved and not past their end date. This is a subset of Street-Use Permits dataset (https://data.sfgov.org/d/b6tj-gt35/data).
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:54.089367
Tags: 5_, excavation, paving, permits, plan, utilities, year

Tables

Table 1

@usgov.city_of_san_francisco_utility_excavation_permits.table_1

103.41 KB
3973 rows
11 columns


CREATE TABLE table_1 (
  "permit_number" VARCHAR,
  "streetname" VARCHAR,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "utility_contractor" VARCHAR,
  "permit_reason" VARCHAR,
  "utility_type" VARCHAR,
  "effective_date" VARCHAR,
  "expiration_date" VARCHAR,
  "status" VARCHAR,
  "cnn" BIGINT
);