Name: Major Roads
Display Field: NAME
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: This dataset is used citywide as base layer for many purposes and applications, including CityWorks. The street centerline is available for reference purposes only and does not represent exact engineering specifications. All street segments lie generally within the boundaries of the City of Oakland. Each street segment has a unique identifier attribute.Shapefile Field Name and Definitions:FieldDefinitionHJWSTREETS2_IDLegacy IDGEO_IDLegacy IDONEWAYCodes one-way streets, values are FT or TF. See below.MILESShape length in milesPREFIXPrefix for full street nameST_NAMEName of streetTYPELabel type of street (Street, Avenue, Way, etc.)SUFFIXSuffix for full street nameNAMEFull street nameL_LADDAddressing related fieldL_HADDAddressing related fieldR_LADDAddressing related fieldR_HADDAddressing related fieldCLASS1See BelowCLASS2See BelowHJWCODELocal Oakland Street type code (legacy)LLTEMPAddressing related fieldLHTEMPAddressing related fieldRLTEMPAddressing related fieldRHTEMPAddressing related fieldSHIELDLabeling field for highway shieldsL_ZIP_IDZIP identifier leftRULEIDUnknown legacy fieldR_ZIP_IDZIP identifier rightFACILITYIDCityworks facility identifierLEGACYIDCityworks Storage field for legacy facility IDWARRANTYDATECityworks Unused warranty date fieldINSTALLDATECityworks Unused install date fieldCONDITIONCityworks Unused condition fieldPOSTED_SPDPosted Speed Limit in miles per hour (Last Updated: July, 2018)FEDCLASSFederal Functional Classification. See below.LANES_LNumber of Lanes; see explanation below (Last Updated: July, 2018)LANES_RNumber of Lanes; see explanation below (Last Updated: July, 2018)LINETYPETo be populated with the type of line segment: street, alley, access road, trail, etc. This field will replace the legacy fields CLASS1 and CLASS2.OWNERTo be populated with the owner of the line segment: City of Oakland, Port of Oakland, Caltrans, East Bay Regional Park District, private development, and various institutions (e.g. Mills College, Merritt College).PavingIDLOCATIONCityworks fieldM_COMMENTStreet in moratorium Y =Yes, E=Expired.M_DATEPAVEDate of street segment paved.M_DATEENDMoratorium end date. Five years after M_DATEPAVE.M_PROJNUMProject number for the street paved.M_3YPStreet is in 2019 3-Year Plan. MS= major street, LS= local street, CD= council discretion, UC= utility coordinationMore Information:ONEWAY -Segments with FT or TF denote street segments that are one-way streets. FT means “From To” and TF means “To From”, and both tags refer to how the segments were drawn in GIS. For example, a one-way street labeled FT is one-way in the same direction that the segment was drawn (From To). A one-way street labeled TF is one-way in the opposite direction that the segment as drawn (To From).CLASS1 and CLASS2 -While each class has specific values, there is no correlation between each set of values. It appears that the Class2 field may have been created as an effort – never completed – to clean up the Class1 field. Class1• 10-14: Freeways, Interstates, and Freeway Ramps• 20-21: Local Streets• 30-33: Trails and Off Roadway Bike FacilitiesClass2• 0: No Data• 30, 33: Access Roads, Trails, and Paths• 31,32,34,35,36: Local StreetsFEDCLASS Interstate – 1Other Freeways or Expressways – 2Other Principal Arterial – 3Minor Arterial – 4Major Collector – 5Minor Collector – 6Local – 7LANES_L and LANES_R -The number of travel lanes on the street segment. For streets oriented mostly north/south, the left and right designations assume one is facing north. For streets oriented mostly east/west, the left and right designations assume one is facing east. For example, a street oriented north/south with one southbound lane and two northbound lanes has Lanes_L=1 and Lanes_R=2. Similarly, a one-way street with two westbound travel lanes has Lanes_L=2 and Lanes_R=0.***Update 01/07/2021: This FC was updated with the removal of several extraneous streets near the OAB Project Area, at the request of Jennifer Stanley***
Copyright Text: City of Oakland's Public Works/ IT updating this data.
City of Oakland's Department of Transportation, Bicycle & Pedestrian Program, added the fields for POSTED_SPD, LANES_L, and LANES_R, and corrected the data in the field ONEWAY.
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 6035880.57166241
YMin: 2086081.56959206
XMax: 6093793.98125156
YMax: 2148853.21841279
Spatial Reference: 102643 (2227)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[166,166,166,255],"width":1.25},"label":"Major Roads"},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GLOBALID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- HJWSTREETS2_ID (type: esriFieldTypeInteger, alias: HJWSTREETS2_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GEO_ID (type: esriFieldTypeDouble, alias: GEO_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ONEWAY (type: esriFieldTypeString, alias: ONEWAY, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- MILES (type: esriFieldTypeDouble, alias: MILES, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PREFIX (type: esriFieldTypeString, alias: PREFIX, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- ST_NAME (type: esriFieldTypeString, alias: ST_NAME, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- SUFFIX (type: esriFieldTypeString, alias: SUFFIX, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- L_LADD (type: esriFieldTypeDouble, alias: L_ADD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- L_HADD (type: esriFieldTypeDouble, alias: L_HADD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- R_LADD (type: esriFieldTypeDouble, alias: R_LADD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- R_HADD (type: esriFieldTypeDouble, alias: R_HADD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CLASS1 (type: esriFieldTypeDouble, alias: CLASS1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CLASS2 (type: esriFieldTypeDouble, alias: CLASS2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HJWCODE (type: esriFieldTypeInteger, alias: HJWCODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LLTEMP (type: esriFieldTypeInteger, alias: LLTEMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LHTEMP (type: esriFieldTypeInteger, alias: LHTEMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RLTEMP (type: esriFieldTypeInteger, alias: RLTEMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RHTEMP (type: esriFieldTypeInteger, alias: RHTEMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SHIELD (type: esriFieldTypeSmallInteger, alias: SHIELD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- L_ZIP_ID (type: esriFieldTypeString, alias: L_ZIP_ID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- RULEID (type: esriFieldTypeInteger, alias: RULEID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- R_ZIP_ID (type: esriFieldTypeString, alias: R_ZIP_ID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LEGACYID (type: esriFieldTypeString, alias: LEGACYID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- WARRANTYDATE (type: esriFieldTypeDate, alias: WARRANTYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- INSTALLDATE (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CONDITION (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- POSTED_SPD (type: esriFieldTypeSmallInteger, alias: POSTED_SPD, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FEDCLASS (type: esriFieldTypeInteger, alias: FEDCLASS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LANES_L (type: esriFieldTypeInteger, alias: LANES_L, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LANES_R (type: esriFieldTypeInteger, alias: LANES_R, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LINETYPE (type: esriFieldTypeString, alias: LINETYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- GIS_SECTION (type: esriFieldTypeString, alias: PavingID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- M_COMMENT (type: esriFieldTypeString, alias: M_COMMENT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- M_DATEPAVE (type: esriFieldTypeDate, alias: M_DATEPAVE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- M_DATEEND (type: esriFieldTypeDate, alias: M_DATEEND, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- M_PROJNUM (type: esriFieldTypeString, alias: M_PROJNUM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- M_3YP (type: esriFieldTypeString, alias: M_3YP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: OaklandStreets
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/6/2026 11:36:18 PM
Schema Last Edit Date: 3/6/2026 11:36:18 PM
Data Last Edit Date: 3/6/2026 11:36:18 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat