About this Dataset

List Of Streets And Intersections

A list of street segments and intersections sorted by street name and ascending address number. This data set is based on the City's GIS basemap and contains CNN id numbers for each record.

If you are looking for a geometric field for each street, please refer to Streets - Active and Retired (https://data.sfgov.org/Geographic-Locations-and-Boundaries/Streets-Active-and-Retired/3psu-pn9h)
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:49.338898
Tags: all, allcnnsinorder, basemap, city-reference-data, cnn, cnns, gis, in, intersection, order, ref-basemap, street

Tables

Table 1

@usgov.city_of_san_francisco_list_of_streets_and_intersections.table_1

1.5 MB
35,150 rows
15 columns

CREATE TABLE table_1 (
  "cnn" BIGINT,
  "streetname" VARCHAR,
  "from_st" VARCHAR,
  "to_st" VARCHAR,
  "cardinal" VARCHAR,
  "addrange" VARCHAR,
  "limits" VARCHAR,
  "location" VARCHAR,
  "theorder" BIGINT,
  "lf_fadd" DOUBLE,
  "rt_fadd" DOUBLE,
  "lf_tadd" DOUBLE,
  "rt_tadd" DOUBLE,
  "from_cnn" DOUBLE,
  "to_cnn" DOUBLE
);