Street Acceptance Data by US Government | Demographics and Population Studies

About this Dataset

Street Acceptance Data

List of streets by block (street segment) accepted for maintenance. Please Note: a few block may appear in this list more than once due to multiple Caltrans maintenance agreement links per block.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:19.953674
Tags: acceptance, accepted, caltrans, jurisdiction, maintenance, of, paving, right, streets, way

Tables

Table 1

@usgov.city_of_san_francisco_street_acceptance_data.table_1

1.27 MB
13010 rows
16 columns


CREATE TABLE table_1 (
  "cnn" BIGINT,
  "streetname" VARCHAR,
  "limits" VARCHAR,
  "ordinancenumber" VARCHAR,
  "dateaccepted" TIMESTAMP,
  "bosfilenumber" VARCHAR,
  "dpwordernumber" VARCHAR,
  "length_ft" DOUBLE,
  "jurisdiction" VARCHAR,
  "cadot_maint_agreement" VARCHAR,
  "ma_link" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);