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

About this Dataset

Utility Excavation Moratorium Streets

Street segments and intersections that have been paved within the last 5 years
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:12.946932
Tags: 5_, excavation, five, moratorium, paving, permits, plan, utilities, year

Tables

Table 1

@usgov.city_of_san_francisco_utility_excavation_moratorium_streets.table_1

315.19 kB
3,347 rows
19 columns

CREATE TABLE table_1 (
  "cnn" BIGINT,
  "streetname" VARCHAR,
  "limits" VARCHAR,
  "jobordernum" VARCHAR,
  "effectivedate" VARCHAR,
  "expirationdate" VARCHAR,
  "modifieddate" VARCHAR,
  "id" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR,
  "point" VARCHAR,
  "neighborhoods" VARCHAR,
  "sf_find_neighborhoods" VARCHAR,
  "current_police_districts" VARCHAR,
  "current_supervisor_districts" VARCHAR,
  "analysis_neighborhoods" VARCHAR
);