Streets – Active and Retired

data.sfgov.org | Last Updated 9 Dec 2019

Street Centerlines, active and retired.

Tags: streets

This dataset has the following 29 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
cnncnnnumberCenterline Network Number - unique identifier for dataset
lf_faddlf_faddnumberFrom address number on left side of street, the lowest number in the address range
lf_toaddlf_toaddnumberTo address number on left side of street, the highest number in the address range
rt_faddrt_faddnumberFrom address number on right side of street, the lowest number in the address range
rt_toaddrt_toaddnumberTo address number on right side of street, the highest number in the address range
streetstreettextStreet name without street type
st_typest_typetextStreet Type (AVE, ST, BLVD, et al.)
f_stf_sttextThe street name of the segment intersects at its beginning.
t_stt_sttextThe street name of the segment intersects at its end.
f_node_cnnf_node_cnnnumberCenterline Network Number for the node/intersection that the street segment begins from.
t_node_cnnt_node_cnnnumberCenterline Network Number for the node/intersection that the street segment ends on.
acceptedacceptedcheckboxAccepted by City and County of San Francisco for maintenance.
activeactivecheckboxActive street segment, i.e., not retired.
classcodeclasscodenumberClassification code for street segment
date_addeddate_addedcalendar_dateDate added to dataset by Public Works.
date_altereddate_alteredcalendar_dateDate altered to dataset by Public Works.
date_droppeddate_droppedcalendar_dateDate dropped to dataset by Public Works.
gds_chg_id_addgds_chg_id_addtextThe internal change transaction id when the segment was added.
gds_chg_id_alteredgds_chg_id_alteredtextThe internal change transaction id when the segment was altered.
gds_chg_id_droppedgds_chg_id_droppedtextThe internal change transaction id when the segment was dropped/retired.
jurisdictionjurisdictiontextAgency with jurisdiction over the segment, if any.
layerlayertextDerived from the source AutoCAD drawing, this field indicates the category of segment. Definitions for each of the values: Freeways such as 80, 280 and 101. Paper, the centerline segment is present on Assessor and/or Public Works map, but is not an actual street in reality. Paper_fwys, the centerline segment is present on Assessor and/or Public Works map, but is not an actual street in reality, and is under or near a freeway. Paper_water, the centerline segment is present on Assessor and/or Public Works map, but is not an actual street in reality, and is under water in the Bay. PARKS, street segement maintained by Recreation and Park Department, e.g., in Golden Gate Park. Parks_NPS_FtMaso, street segement maintained by the National Park Service within Fort Mason. Parks_NPS_Presid, street segement maintained by the National Park Service within the Presidio. Private, street segment is not maintained by the City and is not on an Assessor or Public Works map. Private_parking, street segment is not maintained by the City and is not on an Assessor or Public Works map, and is a parking lot. PSEUDO, street segment created for use in addressing. Streets, standard street centerline segement. Streets_HuntersP, standard street centerline segement within the Hunters Point Shipyard area. Streets_Pedestri, standard street centerline segement, but pedestrian access only. Streets_TI, standard street centerline segement within Treasure Island. Streets_YBI, standard street centerline segement within Yerba Buena Island. UPROW, Unpaved Right of Way street centerline segment.
nhoodnhoodtextSFRealtor-defined neighborhood that the segment is primarily intersects
onewayonewaytextIndicates if street segment is a one way street: possible values are F (the segment is one way beginning at the "from" street) , T (the segment is one way beginning at the "to" street), or B (traffic is legal in "both" directions)
street_gcstreet_gctextStreet name without street type, with the numbered streets with leading zeroes dropped to facilitate geocoding
streetnamestreetnametextFull street name and street type
streetname_gcstreetname_gctextFull street name and street type, with the numbered streets with leading zeroes dropped to facilitate geocoding
zip_codezip_codenumberZIP Code that street segment falls in.
linelinelineGeometry