The [Year_5YP] field in the feature service "5YP_Schedule" (available at https://oakgis.maps.arcgis.com/home/item.html?id=8efcb195195a499d8dbea013248cee4d), utilized in the web map "2022 Five-Year Planning Plan," has been updated with the most recent data from the [5YP_Year] column of the spreadsheet. The mapping for the 2025 records is performed using the “!!!2022 5YP Workplan.xlsx” while the values in the [Year_5YP] field of the rest of the records remain unchanged. Update 05/02/2025.

• -2022 5YP Workplan.xlsx: 2025 records; feature service “5YP_Schedule: 3893 records

HISTORY (Previous Updated 7/17/2024):The [YEAROFCONS] field has been matched with the (YEAROFCONS) column from the “5YP Workplan Update” spreadsheet provided by Sarah on 5/15/2024. Despite having any data: updates, the layer name “5YP_update_8_29_2023” needs to be maintained to work properly with published maps/ apps on the ARGOL platform. However, a new column [UPD_YRCONS} is added to the layer hosting the matched [YEAROFCONS] values from the spreadsheet. 6/14/2024.

This Paving dataset had been previously updated:

Populated values on records that did not have the City Council values.

Corrected values on records with wrong City Council values.

Added a new field to host the value of the Plan Areas.

Recalculated values on segments have inaccurate mileage.

Recalculated segment length in miles.

Added a new field to host PCI_2018 values.

FIELDS ADDED IN THE PAST

[PLAN_AREA] - TEXT, 100 - the name of the plan area where the segment line is located.

[PCI_2018] - NUMERIC LONG – 2018 PCI values

[PCI2018_D] – DATE – PCI Date

[OAKEQRYORG] - NUMERIC DOUBLE – Oakland Equity Index.

[CCDWorstNotes] - TEXT, 254 - This is a new field for holding notes

[CCDWorst] - TEXT 10 - Yes values for specific segments

ATTRIBUTE UPDATES

[OAKEQYINDX] - equity index based on tracts data, including youths of ages below 19 years.

[PLAN_AREA] –plan area information for the paving segment.

[CCD] – council district information for the paving segment.

[MILES] – Recalculate the values in miles from section length

Past updates: In August 2018, incorporated the (COC) Equity Index values in the field OAKEQTYINDX.