About this Dataset

Right Of Way Exception Data

A table of restrictions and information about existing conditions in the public right of way. including permits, moratorium streets, AWSS, SFMTA bluebook, 5 year plan, bike lanes, jurisdiction, monuments, etc. AKA Street Restrictions, The Exception Table
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:07.497707
Tags: exceptions, permits, restrictions, street

Tables

Table 1

@usgov.city_of_san_francisco_right_of_way_exception_data.table_1

2.54 MB
108,551 rows
14 columns

CREATE TABLE table_1 (
  "ctrid" BIGINT,
  "cnn" BIGINT,
  "exceptioncode" VARCHAR,
  "permittype" VARCHAR,
  "jobordernum" VARCHAR,
  "projectname" VARCHAR,
  "effectivedate" VARCHAR,
  "expirationdate" VARCHAR,
  "contactname" VARCHAR,
  "contactphonenumber" VARCHAR,
  "restriction_tow" VARCHAR,
  "modifieddate" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR
);