Roadway Structures

Structures in the right-of-way, maintained by Public Works. Includes Barriers; Retaining Walls; Stairs; Bridges; Tunnels, Overpasses; Pedestrian Overpasses; Ramps; Trestles; Viaducts; and other types of structures.


Publishing Department: GSA - Public Works

Dataset Link: https://data.sfgov.org/d/bnax-tqec

Field Name (opt. alias)Field DefinitionAPI Key
CROSSST1crossst1
CROSSST2crossst2
LARGE_KEYlarge_key
MEDIUM_KEYmedium_key
OBJECTID (ObjectID)The system ID generated by Esri ArcGIS software. Not an administrative ID.objectid
Shape_lenshape_len
SMALL_KEYsmall_key
STR_MAKEstr_make
STR_NAMEstr_name
STREETNAME (Street Name)The name of the street including the type (e.g. Market St)streetname
STRUCT_ID2struct_id2
STRUCT_LINstruct_lin
the_geom (Geometry)Contains the geometry of the record in Well Known Text (WKT) format.the_geom
X_COORD (X Coordinate)x_coord
Y_COORD (Y Coordinate)y_coord