20250712
23302000
1.0
FALSE
Paving_PCI
002
6035224.220659
6093785.207212
2087334.800713
2148806.642336
1
1.603
https://www.arcgis.com/sharing/rest/content/items/14d8886c4f414052b904ca8969a00123/info/thumbnail/ago_downloaded.png
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_California_III_FIPS_0403_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.8'><WKT>PROJCS["NAD_1983_StatePlane_California_III_FIPS_0403_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-120.5],PARAMETER["Standard_Parallel_1",37.06666666666667],PARAMETER["Standard_Parallel_2",38.43333333333333],PARAMETER["Latitude_Of_Origin",36.5],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2227]]</WKT><XOrigin>-115860600</XOrigin><YOrigin>-93269500</YOrigin><XYScale>36787427.345686711</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102643</WKID><LatestWKID>2227</LatestWKID></ProjectedCoordinateSystem>
20250710
19551900
20250710
19563400
150000000
5000
ItemDescription
Version 6.2 (Build 9200) ; Esri ArcGIS 10.9.1.28388
Paving_PCI
1
-122.324212
-122.11765
37.885118
37.713368
ABOUT {Paving_PCI} LAYER: The newly updated {Paving_PCI} feature service layer contains 3,963 records as of 5/8/2025, encompassing the latest segments derived from the consultant's data, primarily reflecting the 2024 Pavement Condition Index (PCI) values.
The "Paving_PCI" feature service has undergone comprehensive data cleansing and updates. The primary objective was to incorporate the 2024 Pavement Condition Index (PCI) values, sourced from raw survey data provided by the consultant. This layer is derived from the predecessor {5YP_Schedule} layer. The update process included deduplication and corrections to the data values in certain fields. The update process included the removal of duplicates and the rectification of data discrepancies in specific fields. The absence of unique mapping keys and missing FacilityID values. The original survey data posed several challenges, including misaligned data structures, lack of unique mapping keys, and missing FacilityID values. To accommodate the addition of the 2024 PCI values, a new field [PCI_2024] was added. Mapping for the 2024 PCI values was accomplished by creating a composite key using the columns [StIDSecID (with no spaces)]and [MAPSTSect (with spaces around -)] based on the values from [STREETID] and [Section ID] fields.
Through this update, we successfully eliminated 7,778 duplicate records and incorporated newly identified qualifying segments from the consultant's data that were previously absent. As a result, the record count is 3963 as of 5/6/2025 after the update.
Highlights:
1. Unique Key Establishment: A Facility ID has been established for this layer.
2. Mapping the 2024 PCI values from the consultant shapefile (via creating a composite key)
3. Duplicate Record Removal: A total of 7,778 duplicate records were removed.
4. Inclusion of New Paving Segments: includes 75 new segments identified from the consultant's data.
5. New Requested Fields added: [STATUS, PROJECT_NO, PM, YEAR_5YP].
6. Corrections have been applied to the values in the Council Districts and Plan Areas {Paving_PCI}
7. Feature service (3963 records as of 5/8/2025)https://oakgis.maps.arcgis.com/home/item.html?id=0ef0b8df125e44ff999dc02b568df3cc
8. used by the “Paving PCI Values” web map at https://oakgis.maps.arcgis.com/home/item.html?id=0deca095ccac4240bbef6d6b98b8a63f
By: David Lok
Updated: 5/8/2025
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>ABOUT {Paving_PCI} LAYER: The newly updated {Paving_PCI} feature service layer contains 3,963 records as of 5/8/2025, encompassing the latest segments derived from the consultant's data, primarily reflecting the 2024 Pavement Condition Index (PCI) values.</SPAN></P><P><SPAN /></P><P><SPAN>The "Paving_PCI" feature service has undergone comprehensive data cleansing and updates. The primary objective was to incorporate the 2024 Pavement Condition Index (PCI) values, sourced from raw survey data provided by the consultant. This layer is derived from the predecessor {5YP_Schedule} layer. The update process included deduplication and corrections to the data values in certain fields. The update process included the removal of duplicates and the rectification of data discrepancies in specific fields. The absence of unique mapping keys and missing FacilityID values. The original survey data posed several challenges, including misaligned data structures, lack of unique mapping keys, and missing FacilityID values. To accommodate the addition of the 2024 PCI values, a new field [PCI_2024] was added. Mapping for the 2024 PCI values was accomplished by creating a composite key using the columns [StIDSecID (with no spaces)]and [MAPSTSect (with spaces around -)] based on the values from [STREETID] and [Section ID] fields.</SPAN></P><P><SPAN /></P><P><SPAN>Through this update, we successfully eliminated 7,778 duplicate records and incorporated newly identified qualifying segments from the consultant's data that were previously absent. As a result, the record count is 3963 as of 5/6/2025 after the update.</SPAN></P><P><SPAN /></P><P><SPAN>Highlights: </SPAN></P><P><SPAN /></P><P><SPAN>Unique Key Establishment: A Facility ID has been established for this layer. </SPAN></P><P><SPAN>Mapping the 2024 PCI values from the consultant shapefile (via creating a composite key)</SPAN></P><P><SPAN>Duplicate Record Removal: A total of 7,778 duplicate records were removed. </SPAN></P><P><SPAN>Inclusion of New Paving Segments: includes 75 new segments identified from the consultant's data.</SPAN></P><P><SPAN>New Requested Fields added: [STATUS, PROJECT_NO, PM, YEAR_5YP].</SPAN></P><P><SPAN>Corrections have been applied to the values in the Council Districts and Plan Areas {Paving_PCI} </SPAN></P><P><SPAN>Feature service (3963 records as of 5/8/2025)https://oakgis.maps.arcgis.com/home/item.html?id=0ef0b8df125e44ff999dc02b568df3cc</SPAN></P><P><SPAN>used by the “Paving PCI Values” web map at https://oakgis.maps.arcgis.com/home/item.html?id=0deca095ccac4240bbef6d6b98b8a63f</SPAN></P><P><SPAN /></P><P><SPAN /></P><P><SPAN /></P><P><SPAN>**** DATA EVOLUTION ****</SPAN></P><P><SPAN /></P><P><SPAN>The predecessor for the {Paving_PCI} is {5YP_Schedule (AGOL_5YP_SchedUpdate)}, which contains 3,893 records as of May 7, 2025. In turn, the {5YP_Schedule (AGOL_5YP_SchedUpdate)} serves as the predecessor for the {PCI Data}. </SPAN></P><P><SPAN /></P><P><SPAN>evolves from …</SPAN></P><P><SPAN /></P><P><SPAN>{Paving_PCI} Feature service (3963 records as of 5/8/2025 ) at https://oakgis.maps.arcgis.com/home/item.html?id=0ef0b8df125e44ff999dc02b568df3cc , used by the“Paving PCI Values” web map at https://oakgis.maps.arcgis.com/home/item.html?id=0deca095ccac4240bbef6d6b98b8a63f</SPAN></P><P><SPAN /></P><P><SPAN>evolves from …</SPAN></P><P><SPAN /></P><P><SPAN>{5YP_Schedule (AGOL_5YP_SchedUpdate)} Feature service (3893 records as of 5/2/2025, public data collection) at https://oakgis.maps.arcgis.com/home/item.html?id=65be6d054f7748f5a5b9fc3d9bacaecf, used by “2022 Five-Year Planning” web map at https://oakgis.maps.arcgis.com/home/item.html?id=8efcb195195a499d8dbea013248cee4d</SPAN></P><P><SPAN /></P><P><SPAN>evolves from …</SPAN></P><P><SPAN /></P><P><SPAN>{PCI_DATA} Feature service (116611 records** as of 9/6/2023) at (https://oakgis.maps.arcgis.com/home/item.html?id=42a2ff1274c44547a534d8e1323d8d15 ) , used by The Pavement Condition Index (PCI) web map at (https://oakgis.maps.arcgis.com/home/item.html?id=e5ac7a25be1348c783021ca12503837d), and The City of Oakland's PCI Dashboard at (https://oakgis.maps.arcgis.com/home/item.html?id=5d844eacab5f40598fcd0e45376d785f).</SPAN></P><P><SPAN /></P><P><SPAN>***********</SPAN></P><P><SPAN /></P><P><SPAN>ABOUT {5YP_SCHEDULE (AGOL_5YP_SchedUpdate)}</SPAN></P><P><SPAN /></P><P><SPAN>The feature service {5YP_Schedule (AGOL_5YP_SchedUpdate)} underwent several updates in fields: </SPAN></P><P><SPAN /></P><P><SPAN>The field [Year_5YP] has been updated with the data drawn from the column [5YP_Year] of the 7/17/2024 “!!!2022 5YP Workplan.xlsx” spreadsheet with 2,025 records.</SPAN></P><P><SPAN>The fields [YEAROFCONS] and [UPD_YRCONS] were synchronized with the (YEAROFCONS) column from the “5YP Workplan Update,” provided by Sarah on 5/15/2024. </SPAN></P><P><SPAN>Additional prior updates include: correcting missing values in the City Council field, recalculating segment lengths in miles to address inaccuracies, and introducing a new field to store PCI values from 2018.</SPAN></P><P><SPAN /></P><P><SPAN /></P><P><SPAN /></P><P><SPAN>***********</SPAN></P><P><SPAN /></P><P><SPAN>ABOUT {PCI Data} Feature Service Layer (drive the dashboard)</SPAN></P><P><SPAN /></P><P><SPAN>The feature service layer {PCI Data} was established by OaklandGIS on July 28, 2023, with 11,661 records** last updated on June 17, 2022. (https://oakgis.maps.arcgis.com/home/item.html?id=42a2ff1274c44547a534d8e1323d8d15 ), Used by the Pavement Condition Index (PCI) web map at (https://oakgis.maps.arcgis.com/home/item.html?id=e5ac7a25be1348c783021ca12503837d), which drives The City of Oakland's PCI Dashboard at (https://oakgis.maps.arcgis.com/home/item.html?id=5d844eacab5f40598fcd0e45376d785f)).</SPAN></P><P><SPAN /></P><P><SPAN>** To enable the dashboard filters and visually present the corresponding data for the selected year from the left legend (under “Select a PCI Year”), the underlying feature service layer {PCI Data} replicates the entire dataset for each year displayed in the legend. This is achieved by adding a new column, [PCIsbyYr], which indicates the PCI records for the specific year, defined as PCI_Year. [The PCI_Year] column indicates the year associated with each record in PCIsbyYr. However, this method may not be viable in the long term, and it is essential to explore alternative solutions.</SPAN></P><P /><P><SPAN STYLE="font-weight:bold;"><SPAN>NOTE FROM HISTORICAL UPDATE</SPAN></SPAN></P><P /><P><SPAN><SPAN>The [Year_5YP] field in the feature service "5YP_Schedule" (AGOL_5YP_SchedUpdate), utilized in the web map (https://oakgis.maps.arcgis.com/home/item.html?id=8efcb195195a499d8dbea013248cee4d) "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.</SPAN></SPAN></P><UL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI><P><SPAN><SPAN>-2022 5YP Workplan.xlsx: 2025 records; feature service “5YP_Schedule: 3893 records</SPAN></SPAN></P></LI><LI><P /></LI></UL><P><SPAN><SPAN>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.</SPAN></SPAN></P><P /><P><SPAN><SPAN>This Paving dataset had been previously updated:</SPAN></SPAN></P><P><SPAN><SPAN>Populated values on records that did not have the City Council values.</SPAN></SPAN></P><P><SPAN><SPAN>Corrected values on records with wrong City Council values.</SPAN></SPAN></P><P><SPAN><SPAN>Added a new field to host the value of the Plan Areas.</SPAN></SPAN></P><P><SPAN><SPAN>Recalculated values on segments have inaccurate mileage. </SPAN></SPAN></P><P><SPAN><SPAN>Recalculated segment length in miles. </SPAN></SPAN></P><P><SPAN><SPAN>Added a new field to host PCI_2018 values.</SPAN></SPAN></P><P /><P STYLE="font-weight:bold;"><SPAN><SPAN>FIELDS ADDED IN THE PAST</SPAN></SPAN></P><P><SPAN><SPAN>[PLAN_AREA] - TEXT, 100 - the name of the plan area where the segment line is located.</SPAN></SPAN></P><P><SPAN><SPAN>[PCI_2018]</SPAN></SPAN><SPAN STYLE="font-weight:bold;"><SPAN>- </SPAN></SPAN><SPAN><SPAN>NUMERIC LONG – 2018 PCI values</SPAN></SPAN></P><P><SPAN><SPAN>[PCI2018_D] – DATE – PCI Date</SPAN></SPAN></P><P><SPAN><SPAN>[OAKEQRYORG] - NUMERIC DOUBLE – Oakland Equity Index.</SPAN></SPAN></P><P><SPAN><SPAN>[CCDWorstNotes] - TEXT, 254 - This is a new field for holding notes </SPAN></SPAN></P><P><SPAN><SPAN>[CCDWorst] - TEXT 10 - Yes values for specific segments</SPAN></SPAN></P><P /><P><SPAN><SPAN>ATTRIBUTE UPDATES</SPAN></SPAN></P><P><SPAN><SPAN>[OAKEQYINDX] - equity index based on tract data, including youths of ages below 19 years. </SPAN></SPAN></P><P><SPAN><SPAN>[PLAN_AREA] –Plan area information for the paving segment.</SPAN></SPAN></P><P><SPAN><SPAN>[CCD] – Council district information for the paving segment.</SPAN></SPAN></P><P><SPAN><SPAN>[MILES</SPAN></SPAN><SPAN STYLE="font-weight:bold;"><SPAN>] </SPAN></SPAN><SPAN><SPAN>– Recalculate the values in miles from the section length</SPAN></SPAN></P><P /><P><SPAN><SPAN>Past updates:</SPAN></SPAN></P><P><SPAN><SPAN>In August 2018, incorporated the (COC) Equity Index values in the field OAKEQTYINDX. </SPAN></SPAN></P><P /><P><SPAN /></P></DIV></DIV></DIV>
Paving _PCIPCI Condition Index
Shapefile
1.603
dataset
EPSG
5.3(9.0.0)
3963
Simple
FALSE
3963
TRUE
FALSE
Paving_PCI
Feature Class
3963
FID
FID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
OBJECTID
OBJECTID
Integer
10
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
FACILITYID
FACILITYID
String
30
0
0
STREET
STREET
String
50
0
0
BEGLOCATIO
BEGLOCATIO
String
50
0
0
ENDLOCATIO
ENDLOCATIO
String
50
0
0
FCDETAIL
FCDETAIL
String
50
0
0
FC
FC
String
5
0
0
SHAPEKEY
SHAPEKEY
String
20
0
0
STREETID
STREETID
String
10
0
0
SECTIONID
SECTIONID
String
10
0
0
GISSECTION
GISSECTION
String
20
0
0
SURFACETYP
SURFACETYP
String
15
0
0
MAPSTSect
MAPSTSect
String
100
0
0
YEAROFCONS
YEAROFCONS
Date
8
0
0
LANES
LANES
Integer
10
10
0
SECTIONLEN
SECTIONLEN
Double
19
0
0
SECTIONWID
SECTIONWID
Double
19
0
0
SECTIONARE
SECTIONARE
Double
19
0
0
SLABLENGTH
SLABLENGTH
Double
19
0
0
SLABWIDTH
SLABWIDTH
Double
19
0
0
NUMSLABS
NUMSLABS
Integer
10
10
0
TRAFFICIND
TRAFFICIND
Integer
10
10
0
ADT
ADT
Integer
10
10
0
PCI_2012
PCI_2012
Integer
10
10
0
PCI_2016
PCI_2016
Integer
10
10
0
ONEWAY
ONEWAY
String
15
0
0
SPEED
SPEED
Integer
10
10
0
NORMDT
NORMDT
Double
19
0
0
MILES
MILES
Double
19
0
0
BIKEWAYS
BIKEWAYS
String
1
0
0
TR
TR
String
4
0
0
TIER
TIER
String
30
0
0
TRUCK_ROUT
TRUCK_ROUT
String
40
0
0
DESCRIP
DESCRIP
String
50
0
0
OMC
OMC
String
30
0
0
EXTRALEGAL
EXTRALEGAL
String
1
0
0
CCD
CCD
String
10
0
0
CR_TOTAL
CR_TOTAL
Integer
10
10
0
CR_COMP
CR_COMP
Integer
10
10
0
CR_NONCOMP
CR_NONCOMP
Integer
10
10
0
CR_NOCURB
CR_NOCURB
Integer
10
10
0
BUSLINE
BUSLINE
String
3
0
0
PLAN_2014
PLAN_2014
String
25
0
0
PLAN_2019
PLAN_2019
String
25
0
0
PLAN_2022
PLAN_2022
String
25
0
0
SCHOOL_300
SCHOOL_300
String
3
0
0
SCHOOLPRIV
SCHOOLPRIV
String
3
0
0
UPDATED
UPDATED
String
50
0
0
PCI_2018
PCI_2018
Integer
10
10
0
StIDSecID
StIDSecID
String
254
0
0
PCI_2_2013
PCI_2_2013
Integer
10
10
0
PCI_2_2017
PCI_2_2017
Integer
10
10
0
PCI_2_2019
PCI_2_2019
Integer
10
10
0
PLAN_AREA
PLAN_AREA
String
254
0
0
PCI_2021
PCI_2021
String
25
0
0
PCI_2024
PCI_2024
Double
19
0
0
Shape_Leng
Shape_Leng
Double
19
0
0
STATUS
STATUS
String
25
0
0
YEAR_5YP
YEAR_5YP
String
25
0
0
PROJECT_NO
PROJECT_NO
String
25
0
0
PM
PM
String
50
0
0
20250710
/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2Mqp4ZVP4daNm37pI9u1QLdo0gVtik4wN4OT7Yqx93r09a6oSjJaHFNST1E+cf3T+lETOrfdU7T/eP+FOpo4kPuM1TRKZMLtVbdKki5P3l5x+FUjMk9w0zPgH7obg496sMMqQOuKiUonD9DwRXLUioux1U6nMtSKS2idi7RBi2AfXA6VFLZW+fM8kYBJZueR+frzUjQAqVVmVQccNjH0qXyTGgY/Oh45AyvvUtNGiaYy3t4oNzQoF3AA479cf1qibqTzi8dwAMnjcnTPvzV+A7VEZPOMgjsP/AK1MuLKKZ94yrgYypwcen8vyFY1IX1QpK+xNbf6RbJMZA0qM25xg59uOOmKtxsxXCHBznjvXPBJopmCgqM5JUuAffgVvDJUPkBsZIBzz3qqVRSXLIjVu6JUdgMdVHP1qLAbgEryAD6VMWBiJKbnbgketQOxTC5Gc8jNWkle5TbdrDmEhUiJiy9gcfjWdeQtNGAp5QkhdoOeK0FlCuMJuHIyMimmSBgXy4YHG3FYVKd9UNq5kW9tICCylCmMkp19QOf1rQQ8E5YKOOBTQQzAnC84wTmp0ChQMIRjgDoazpK7uxRQgJ3bjgZ9/SmTsBF82Pvrg596coUc7s/jnmmSMHdV4wPmb+n+faupFiocnAbr6fjSggD0z146VXktBNKx82VS3Xa/A+lPSzQEnzZScbclunv8ArQCJfmMyEIVRPm3dy3arqzGRc7ckdfY1nJYn7nnTsM93HXkVpQxLbANIecYx1+lSk1LyFsN+yhwzD7ox97A5oqG8kaR1t0kCgtknHXn0op8yHch8lCVIjCkdOOlS7WU7WHzYzx0qmL1lLLMkUbIoJzKPx/IEfnUkE7u671TgAnbIGwfTj3ra/s37ply+0XvIn+79P5Uh+8ppI23J0PpyKG4Xn+E5roi7q5zSVnYeeBmmlA4+bmlb7p+lLVbk7AVXaOc/XtQODnGfailBI6HFJrQaepQdds3Qkr8ycc4PB6/hVgM5J4Az1PU1FcTRC5CysudhzvPYnApEurbCnz4tpJwQ4/H9c1xyVnY7oO8bkpXaMrkn0J61YtplBwx+Q9jVWeZY4wQVYscLz1NUF1Ry7R7YiSM7S54/T6VjKDvzR3Bo6CRVXBjxk85ByKgknEqqDjjqcVVtb3zIcgruI5Ctn/OasCIMhbzYwo5OapNtagNeYBcsAF9SaZFNG+A7ocjpkU20YXB811YDOAG6gf8A16lyUGwhSexIzQ9Nx3sI08I43oB90c9z/XpVB1gkkXZK5CMSQsu3noQcnpzV5YYwr4RMnGRgc/54p5tkUZ2qD3IA6000xJ3VyhDia03oGIZiQwlDEgjjH4YNJAoWQs4lVxwodj8w/OpWZ2do7ZV+QYO84GSOOlSQxSFCs5R9xzwu3iqC9yRwACy8NgkVSGoXGPm8pWxz+7c8/l9auxg72jflhzx1x6/z/Kllhhdy8ybmVflAPftWc07aMGuwzTNSlkmZJY1KnBUorA5/EVpzcRsRHn5gevSs4R7ECqMBRhfarCXDTnLcHpgrxShPSzEn3B1wqSBcktgsPrRSknHzjI9Nx5opMCArG+dyqSeDkUGMfNgD5utV0R4pvKY5UYxj3z1/KrOSpw3Tsa76clNXZzVFyuyKl1M0KIyuU5K446/8Cospnnty7tv54PHTA/uk96luIElZQ2QpPUHGDjj/AD9KfDAsEWxSTznLYzQoy5730J5ly2H/APLP8KdTFP7s4p9akBRRRQBDcIhiDGNC4YZYjJI9PzOajS2g/wCeUeAcj5B/n1qeYM0DhMbyp256ZqBCSFIPBFctWNnoddGTa1HGKNg8eBtI5APr1qs1lAgO0vgjqZG4x+NWMqpy/wB4noOSf88fnSHzXz82wdsjJrJ6moOyQwFGLBUX5nJyxJ4HHc//AFqkijW4QCZgTGfuYGDxxn1qARMu5mZHdT1KgAD2HYkd6VZGZeGw3Tng/T2qNgLvlSeWXAUE8YHFMIUfxNkDqe9EczTKUZc9sEYP6091Qt8h4Azz/nnpRoxbjcIqDgBjjkHirNySI1bKkD24NU1UBQRyAckVKzsflGR6YHT0qkMq2mTJcSgbkZhtOeoA5Iz75q2hJ3IThSDjJ6GnRI8tqolc7guGZgCW9/bP9aV428vdyo64J6USYlsVpk3v5iY3p0545p6KGVZAc55xil3buRjjIpsZ2MY2zknKe+f65oWoyRHib5duzBzuHaguThGUsP7wHJHr+NMCZYZHDE8U4yNHIDggKOvFK19xWFQKzbirE9s9RRROY5UR2yCCM5OP0oqXoIrlWMiOxyTwTj8v8+9TEZGDVd7qAggSDK4J9hnP9DU4ZWAIIIPSu+EYw0RySk56jGXCkHO3sfSlV8pnv3HvS71/vCoWUb/kYAHqO1U5JdRKLfQlHGV9MU/PNRBwzD16frTpH8uMnBb0UDkmlJu10ONr2Y+kZ1T7zBfqcUwRlhmQkk/wg4A9vel2RxqWVFH0FNysJRuRG8g3bQxYnuqkj8+lQhnVXXyJMo2Oo6fn6U9znCHh34UY4UY604BIIMDO1Bz3JrmnLmOuEOUhjmR7yTGQQqrhhg55P+FWcE8A8VSWdo1/e2szu7chELAdv5ClS9YK262ugyDOdhwT6Z/H+dZtXLLbjndjJHb1FMKbyXUKCQMHHWpDuYYPSmZKNtxweFPpSYEsLrsA4X0YCkNvOPu3WwbeVMYIY+pz/T0qpdSPDGHiJ3ZGUILAj8KiTU7gQsSYZVAPAV+v5VhGbWjI5rbmisTRyur3PmKSCOAMfl1q47MCqKqtgA54pquJY2BYc498HvRFGx59+4z/ACroLTuS+VhCgcKHB+U8/lVO7kMcJLviJjz39/61M0fBYS7OSemTgZz/ADqCSKaa3ZDMPnGMMgwckf8A1/zqJK6sJoptewR8ZYd87Se1WVmiu12qQQACazk06UEgPHx90fNwP++qv2geCNkdeA3BH/1+awpvldyY3IpIV8wh3fDEcq2D9PWp00+KWVZGaRnQbQDKQMZB/oKWflHZFJ2EGpFDOwBKr3zmupO6LJ/soVNxO3jJDdKKJDJGhGSVPf8AxoqW7bICjcnMRRY/MJ6rkdO/WshbLLKfIYgNzhVIbkn1461rvIkSZdlCjuRUEN3bFVj+0qz4GRwKqcuaV7kRioqxNGCUG4svH3Djj2oXA3AdFPH5U2UF9oV3U56haqRo/mOLibdtYOSFC8DORx26Uyy0WX5X3j5Wyc/l/hU43Z3NgentWdDDPMQ8s6kgqwBiAwpGOnqf059quJFdDbuuwwBBP7oDI54/l+Vb0m9jnrRV7ljn1/SpIbVrqNx5gH4VH06dPSpLedoRlcEHgg1rJNrQxg0ndlSfTWiI3446FTTPKQrxuBBzvY4Pr+NaFzMs+07TkDBFVXQcn271zSjy7o64y5tmRx+bEp80l/RgvP4j+tOVldcggipVZV6gn8aqXUsceG3hZBztyMle9LRrQaunqiYocARuVx2PIP8An60Ah/kkABx09RUMd7AesqZJxw1TMElRScMDyGB/kakoWMbi2W+537kdajWzgSQPGME9h2FKkRViyk7yMEMSQacGO/5hhh97Hes5xugaJIFViWwGYDIyKliEcCLCgzIwyW6HmoRhWBX/APVUwbHKgEE+v6U6eq5epm3ysc0R8oiJX3FcEljx+tNnXyk8pJDu25ZuOB606RpJSLdXUMOXKcY9qegAkckFiSFUde1DV9DQrRI6TJvB2sMgdD+NXDEkiBxhhnseCfrTGi3b2GHdsDOMY5pADHICj4XHy5zjvyR+FKMElYVrCq6RsyFcrkDqeegzVUfK5i5wnTPp2/wqxLODHkgdcEAZxVGR5PNR1X5SdpJ9Ox/P+dWkMurMvkkbirevais8Wke0gyzYI24L8AdzjHWipcU9xMdcW4lQZkdcEfdOO9MNlEFH7yYEDbnfyevX/ParLk+S30/Wm7iGJBwOhJ6CnyodkJySQWOFpAiNn5VI5xke9GVUcHOT3HSmlgoZznaM4Oe1MYR7Y1jxgY4OPQdv0q1weQciqUaboo2OGzlupPJ//XV5VQRZAIbv6VtSlZ2Ma0bq4lNA4yPU06kHT8TXScgA5paQgGjBHQ/nQANk5yM1Eyqx+ZQRjoRmpS2OvFMyD3zzXNUjGJ1Upya1GyQI6KQBkdugNIHGBgDpwF71Ow+QE45OOlVpkeG6SMj5STznof8A69Zvl0cTSLld3JBz14PpSSsq7Ccbt+B7+v8Aj+FJuJ7AEe+aHjLfMoyQc896llDuvY80qsMgknj0pybPL3qSQTgDHNU7m5eN22LuOPQkD8vpWErxtLqRLbU0VVYwzFM7ucev1/WnRs7BQcRsynAB6Vn2t5JJH86EY/hIIH64q+5+QPtCuw4z9PSrjNPUpPQlVlUAomI1woPTP/1qF2MPMcttyQqqDk4pkjDZvJwTk5J46cVJas2wMQThQAR2J5NaIY3b5rBUQKvIbK4z6VWeMAmJ2APTnirQZAoUkbV4DHOMDHemlULfM65HOA2aTb6AUxuKY43qcEe4/wAaKfKvly7lOVbg+3pRTsmFjPgdpYZFb58A5fYABwOOCat7AUG3GMdKFARiqogX/ZOP0xVaFbiRFIfarLnBXJA+tJCje2pMEEq8kgZIwpI6GneVHnawJHoxJH60seDjywCB3HNHL/wLk9qHfoMjjAVjGuMJnA9u3+farccZMZIYc9sVF5EkUgfO3dwe/OMgfqalJyScAZ7CtoQctTKpUUdBBnHPWhen4mlpF6fjXUcgtFFFACEZHXFNeNsZj5JH5Gn0oJB4qKkOZGlOfIyqLmYv5PlxE5I+8w+ueKdJE7odxUqUw2D0PfmnfYLZhwrAYxjccfzqYPtQg4PGBntXI4tHVzrQz0gj3IuSJI+VG49M+n4/5zT0tYyFVi/y4H3z2GKkkjJGAWTnKsO1IM55++B+BoLFtreKGV8blyepOeD16/jTLzTklk67HBzuA+8PT+VK+SoK8PyBnkfj7cVOJQwCunzqOhJ/MetTJXIlHmIrWyjt3VvlMg/i6cZ6datT5POc4B71CSBnJHPc0pHBHWp5EloNRSHkEwwoMZJxVh3Me2JHUHIAyM1TMkYZXLfKo/LjHFAmQeWFfc/3iE5PbimlZWGWXEb73BbCcAd2OOnt/wDXqNmWORg6KSWwMKP8807zlYjduhjXvsIx+OMUKqiMCNlyoyBt4ORTewBLPGyMrgkYxt70U0uXRckJg5AHSihO6AzltpAoMdw67Wd+BkHIOB+Gc/hSJC86DbLIoOdoHcds1N5gWVoQcsRu9sUW6mKMR5B8v5c4+9wKaelwHy6gIpkieJU3ActIFwPoe3Haq9resXClFMrk5xIrY4qS4hgnlWSa4kTdhQyngc9/1qqpgN3iN3LAYADHnBxk/l0zUruhGs1wJLcK2d6uD9eNtFUPtKSzpFFgk4IIOMDvx+FXs4GTXXReljnrrW4E9h1pegpAO560tbGBBNdJGDgjIOCDxSxXCycEqHzjaDmnyRiQAEsMHOVOKWNNiBdxbHdutAh1FFFAwppUZJxTqKLAOjt/OBIkww5AIqAqD+B9eQamSQxyArUcq7pGcZCMfSuScOV+R2UqnMrMpsJDcJ8qlVzlgTk8dfb9akZnICiM7uoPapJ0Dp91dy8rngZFMSTbgE5Dc9ehqDQZE88rndCqbDx85z9elR/ZIxlFjjQkgnkseM89vU1LOshXKPsPPzFc9j/XBoSK5RSTJEOWOcH8KAFjsImIM6LKw4GSQBnr09eK0oIY7cFY1wDyME8etU7TzkLm5kjkBAwFXAHXP9Pyq7GWcgKRgHPrkVNwHSENjhm29SBn8KgaKA7gYVGT/D8p/Mc0spZ3xubBPRQRSKVkG1BIQBnf2NADDZwPHh7cDkADcSf50VYlcbQc55GRjrRSu0BRVASR6dKjIEcqsOd/BH4ZzRRVgth0qDaMErllPy8dwaiFvJHI379j2HygY4x/SiigB1vCR+83n5u2ParQ55wM49KKK0pfEZVvgFooorqOQKKKKACiiigAooooAQ0FdwGScDtRRXPiv4bLp/ENicCQfICc4yetR6iRawSyoPuLvA9/8/zoorA7hB8xUHuM8U5JGEZXsrEfWiimBIDjPr6ink+WjE5btjOKKKloRLKR5cJC4PT9KQKzAsH2jIGB78k/rRRUsCZSJomYqAQ2Priiiim2B//Z