sfgov/list-of-streets-and-intersections-pu5n-qu5c
 
Readme
Updated 7 hours ago
Indexed 2 hours ago

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
CNNcnncnnNumberCNN of street segment or intersection
streetnamestreetnamestreetnameTextStreet name
from_stfrom_stfrom_stTextCross street 1
to_stto_stto_stTextCross street 2
cardinalcardinalcardinalTextDirection/Side of street for divided streets
addrangeaddrangeaddrangeTextaddress range of street segment
limitslimitslimitsTextA description of location combining from_st, to_st, cardinal and addrange
locationlocationlocationTextA description of location combining streetname, from_st, to_st, cardinal and addrange
theOrdertheordertheorderNumberA field used to order the list to keep in ascending street name and then address order
LF_FADDlf_faddlf_faddNumberLeft side from address number
RT_FADDrt_faddrt_faddNumberRight side from address number
LF_TADDlf_taddlf_taddNumberLeft side to address number
RT_TADDrt_taddrt_taddNumberRight side to address number
FROM_CNNfrom_cnnfrom_cnnNumberfrom intersection CNN
TO_CNNto_cnnto_cnnNumberto intersection CNN
Upstream Metadata