About this Dataset

Streets – Active And Retired

A. SUMMARY A list of street centerlines, including both active and retired streets. These centerlines are identified by their Centerline Network Number ("CNN"). B. HOW THE DATASET IS CREATED This data is extracted from the Department of Public Works Basemap. Supervisor District and Analysis Neighborhood are added during the loading process. These boundaries utilize the centroid (middle) of the line to determine the district or neighborhood. C. UPDATE PROCESS This dataset refreshes daily, though the data may not change every day. D. HOW TO USE THIS DATASET Note 1: The Class Code field is used for symbolization: 1 = Freeway 2 = Major street/Highway 3 = Arterial street 4 = Collector Street 5 = Residential Street 6 = Freeway Ramp 0 = Other (private streets, paper street, etc.) E. RELATED DATASETS

Understanding street-level data
Organization: City of San Francisco
Last updated: 2021-08-07T18:31:18.247863
Tags: streets

Tables

Table 1

@usgov.city_of_san_francisco_streets_active_and_retired.table_1

1.69 MB
17145 rows
33 columns


CREATE TABLE table_1 (
  "cnn" BIGINT,
  "lf_fadd" DOUBLE,
  "lf_toadd" DOUBLE,
  "rt_fadd" DOUBLE,
  "rt_toadd" DOUBLE,
  "street" VARCHAR,
  "st_type" VARCHAR,
  "f_st" VARCHAR,
  "t_st" VARCHAR,
  "f_node_cnn" DOUBLE,
  "t_node_cnn" DOUBLE,
  "accepted" BOOLEAN,
  "active" BOOLEAN,
  "classcode" DOUBLE,
  "date_added" TIMESTAMP,
  "date_altered" TIMESTAMP,
  "date_dropped" TIMESTAMP,
  "gds_chg_id_add" VARCHAR,
  "gds_chg_id_altered" VARCHAR,
  "gds_chg_id_dropped" VARCHAR,
  "jurisdiction" VARCHAR,
  "layer" VARCHAR,
  "nhood" VARCHAR,
  "oneway" VARCHAR,
  "street_gc" VARCHAR,
  "streetname" VARCHAR,
  "streetname_gc" VARCHAR,
  "zip_code" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "line" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);