20250508
14002200
1.0
FALSE
Paving_PCI
002
6035224.220659
6093785.207212
2087334.800713
2148806.642336
1
1.603
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>
20250508
15582400
20250508
15582400
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
Summary: 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.
Updated: 5/8/2025
<p><span style='font-family:"Aptos",sans-serif;'><strong>ABOUT {Paving_PCI}</strong> <strong>LAYER: </strong>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><a><span style='font-family:"Aptos",sans-serif;'>The "<strong>Paving_PCI</strong>" feature service </span></a><span style='font-family:"Aptos",sans-serif;'>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 <span> </span>{<strong>5YP_Schedule}</strong><span> </span>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 <span> </span>[STREETID] and [Section ID] fields.</span></p><p><span style='font-family:"Aptos",sans-serif;'>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 <strong>3963</strong> as of <span> </span>5/6/2025 after the update.</span></p><p><span style='font-family:"Aptos",sans-serif;'><strong>Highlights: </strong></span></p><ol><li><span style='font-family:"Aptos",sans-serif;'>Unique Key Establishment: A Facility ID has been established for this layer. </span></li><li><span style='font-family:"Aptos",sans-serif;'>Mapping the 2024 PCI values from the consultant shapefile (via creating a composite key)</span></li><li><span style='font-family:"Aptos",sans-serif;'>Duplicate Record Removal: A total of 7,778 duplicate records were removed. </span></li><li><span style='font-family:"Aptos",sans-serif;'>Inclusion of New Paving Segments: includes 75 new segments identified from the consultant's data.</span></li><li><span style='font-family:"Aptos",sans-serif;'>New Requested Fields added: [STATUS, PROJECT_NO, PM, YEAR_5YP].</span></li><li><span style='font-family:"Aptos",sans-serif;'>Corrections have been applied to the values in the Council Districts and Plan Areas <strong>{Paving_PCI} </strong></span></li><li><span style='font-family:"Aptos",sans-serif;'><strong>Feature service </strong>(3963 records as of 5/8/2025)</span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=0ef0b8df125e44ff999dc02b568df3cc' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=0ef0b8df125e44ff999dc02b568df3cc</span></a></li><li><span style='font-family:"Aptos",sans-serif;'>used by the<strong> </strong>“<strong>Paving PCI Values</strong>” w<strong>eb map </strong>at </span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=0deca095ccac4240bbef6d6b98b8a63f' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=0deca095ccac4240bbef6d6b98b8a63f</span></a></li></ol><p> </p><p><span style='font-family:"Aptos",sans-serif;'><strong>**** DATA EVOLUTION ****</strong></span></p><p><span style='font-family:"Aptos",sans-serif;'>The predecessor for the <strong>{Paving_PCI} </strong>is <strong>{5YP_Schedule (AGOL_5YP_SchedUpdate)},</strong> which contains <strong>3</strong>,893 records<strong> </strong>as of May 7, 2025. In turn, the <strong>{5YP_Schedule (AGOL_5YP_SchedUpdate)} </strong>serves as the predecessor<strong> </strong>for the <strong>{PCI Data}. </strong><span><strong> </strong></span></span></p><p><span style='font-family:"Aptos",sans-serif;'>evolves from …</span></p><p><span style='font-family:"Aptos",sans-serif;'><strong>{Paving_PCI} Feature service </strong>(3963 records as of 5/8/2025 ) at </span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=0ef0b8df125e44ff999dc02b568df3cc' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=0ef0b8df125e44ff999dc02b568df3cc</span></a><span style='font-family:"Aptos",sans-serif;'> , used by the“<strong>Paving PCI Values</strong>” web map at </span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=0deca095ccac4240bbef6d6b98b8a63f' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=0deca095ccac4240bbef6d6b98b8a63f</span></a></p><p><span style='font-family:"Aptos",sans-serif;'>evolves from …</span></p><p><span style='font-family:"Aptos",sans-serif;'><strong>{5YP_Schedule (AGOL_5YP_SchedUpdate)} Feature service </strong>(3893 records as of 5/2/2025,<strong> </strong>public data collection) at </span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=65be6d054f7748f5a5b9fc3d9bacaecf' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=65be6d054f7748f5a5b9fc3d9bacaecf</span></a><span style='font-family:"Aptos",sans-serif;'>, used by <strong>“2022 Five-Year Planning” web map</strong> at </span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=8efcb195195a499d8dbea013248cee4d' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=8efcb195195a499d8dbea013248cee4d</span></a></p><p><span style='font-family:"Aptos",sans-serif;'>evolves from …</span></p><p><span style='font-family:"Aptos",sans-serif;'><strong>{PCI_DATA} Feature service </strong>(116611 records** as of 9/6/2023) at (</span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=42a2ff1274c44547a534d8e1323d8d15' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=42a2ff1274c44547a534d8e1323d8d15</span></a><span style='font-family:"Aptos",sans-serif;'> ) , used by <strong>The Pavement Condition Index (PCI) web map</strong> at (</span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=e5ac7a25be1348c783021ca12503837d)' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=e5ac7a25be1348c783021ca12503837d</span></a><span style='font-family:"Aptos",sans-serif;'>), and <strong>The City of Oakland's PCI Dashboard</strong> at (</span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=5d844eacab5f40598fcd0e45376d785f)' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=5d844eacab5f40598fcd0e45376d785f)</span></a><span style='font-family:"Aptos",sans-serif;'>.</span></p><p><span style='font-family:"Aptos",sans-serif;'>***********</span></p><p><span style='font-family:"Aptos",sans-serif;'><strong>ABOUT {5YP_SCHEDULE (AGOL_5YP_SchedUpdate)}</strong></span></p><p><span style='font-family:"Aptos",sans-serif;'>The feature service<strong> {5YP_Schedule (AGOL_5YP_SchedUpdate)} </strong>underwent several updates in fields: </span></p><ul><li><span style='font-family:"Aptos",sans-serif;'>The field <strong>[Year_5YP]</strong> has been updated with the data drawn from the column [5YP_Year] of the 7/17/2024 <i>“!!!2022 5YP Workplan.xlsx</i>” spreadsheet with 2,025 records.</span></li><li><span style='font-family:"Aptos",sans-serif;'>The fields <strong>[YEAROFCONS]</strong> and <strong>[UPD_YRCONS]</strong> were synchronized with the (YEAROFCONS) column from the “<i>5YP Workplan Update</i>,” provided by Sarah on 5/15/2024. </span></li><li><span style='font-family:"Aptos",sans-serif;'><strong>Additional prior updates include</strong>: 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></li></ul><p> </p><p><span style='font-family:"Aptos",sans-serif;'>***********</span></p><p><span style='font-family:"Aptos",sans-serif;'><strong>ABOUT </strong>{PC<strong>I Data</strong>} Feature Service Layer (drive the dashboard)</span></p><p><span style='font-family:"Aptos",sans-serif;'>The feature service layer<strong> {PCI Data} </strong><span> </span>was established by OaklandGIS on July 28, 2023, with <strong>11,661</strong> records** last updated on June 17, 2022. (</span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=42a2ff1274c44547a534d8e1323d8d15' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=42a2ff1274c44547a534d8e1323d8d15</span></a><span style='font-family:"Aptos",sans-serif;'> ), <strong>Used by the Pavement Condition Index (PCI) web map</strong> at (</span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=e5ac7a25be1348c783021ca12503837d)' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=e5ac7a25be1348c783021ca12503837d)</span></a><span style='font-family:"Aptos",sans-serif;'>, which drives<strong> The City of Oakland's PCI Dashboard</strong> at (</span><a target='_blank' href='https://oakgis.maps.arcgis.com/home/item.html?id=5d844eacab5f40598fcd0e45376d785f)' rel='nofollow ugc noopener noreferrer'><span style='font-family:"Aptos",sans-serif;'>https://oakgis.maps.arcgis.com/home/item.html?id=5d844eacab5f40598fcd0e45376d785f)</span></a><span style='font-family:"Aptos",sans-serif;'>).</span></p><p><span style='font-family:"Aptos",sans-serif;'>** 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 <strong>{PCI Data}</strong> 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><span style='font-family:"Aptos",sans-serif; font-size:9.0pt;'> </span></p><p><span style='font-family:"Aptos",sans-serif; font-size:9.0pt;'><strong>KEY FIELDS NEED TO BE KEPT</strong></span></p><p><span style='font-family:"Aptos",sans-serif; font-size:9.0pt;'>- [MAPSTSect]</span></p><p><span style='font-family:"Aptos",sans-serif; font-size:9.0pt;'>- [StIDSecID]</span></p><p><span style='font-family:"Aptos",sans-serif; font-size:9.0pt;'> </span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'> </span></p><p><span style='font-family:"Aptos",sans-serif; font-size:9.0pt;'><strong>NOTE FROM HISTORICAL UPDATE</strong></span></p><p> </p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>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></p><p style='margin-left:0in; text-indent:-.25in;'><span style='color:black; font-family:"Times New Roman",serif; font-size:9.0pt;'><span>·</span><span style='font:7.0pt "Times New Roman";'> </span></span><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>-2022 5YP Workplan.xlsx: 2025 records; feature service “5YP_Schedule: 3893 records</span></p><p style='margin-left:0in; text-indent:-.25in;'><span style='color:black; font-family:"Times New Roman",serif; font-size:9.0pt;'><span>·</span><span style='font:7.0pt "Times New Roman";'> </span></span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>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></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'> </span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>This Paving dataset had been previously updated:</span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>Populated values on records that did not have the City Council values.</span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>Corrected values on records with wrong City Council values.</span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>Added a new field to host the value of the Plan Areas.</span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>Recalculated values on segments have inaccurate mileage.</span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>Recalculated segment length in miles.</span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>Added a new field to host PCI_2018 values.</span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'><strong>FIELDS ADDED IN THE PAST</strong></span></p><p><span style='color:black; font-family:"Aptos",sans-serif; font-size:9.0pt;'>[PLAN_AREA] - TEXT, 100 - the name of the plan area where the segment line is located.</span></p>
pavingPCIPaving_PCI
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
20250508
/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iqZmaHDvcRFS/3fQE4xuz25PTt2qtLrEE0EwgaUALxMiZGc4P0xx19R71Si2UotlC6LXMsrFflkkCgYKq4HOCzYHY8DI+lRIv2g79hYO6IET5VI4JG49WwW/DvxUqDdJCJGjZyDvZECgsOBjOf73QLnPWnQRqrwGSMrt3SsdvOzHHUg5AYcqM8VveyNtkFw5/tNJg0zKoYBzGMdgcggd8jt0ptm6r5jTzOkPLKY4efvMOykD73r3pxeMTM7NJGSUDuV3NnGfcrwxwf9nvUKRzs5CSSeZgsUcEFm5Bzu452nOMDHpS6WDoWJWRZC9ssgQDKn5UUDoW6ZHTGeOnXkVeiv5QMSqN6jkdyOx9M/yz9M0IAoYtAuXkOclSNw/usD0P58kdehkjs2vEjZMRyAHbKfmA57DuM+/wCozSaXUlpdTcR1dAynKnkGlpkUYjjVcKCBztGAT9KfWBiFZeoWcCCa5mkATaT85GAx47+3HX+dalFNOzGnYwVH78SK5AYgsGGG29RnPGeSMkc89Tip5Iz5hdc+WFyo6ng4z0HIHBznqM5xRdRXUs0jvGyqnETMwIGTzwOSOnX06URAwShNyDzQJEO4kl92OM8kYPIGOOwrW5pcqz3D+YrO0W9GRQ+DnBGRjqff6n6Uy2hMkEh/0gISRJtbG04/2ck59h+NLMYZfOhUiOUMzldqsCe/bjGME/7PbINS28+2S9kQESAKCxYnGRuOAOBjLE+4xzVdNCuhFPAYBm4iaUjLMGZcjIHOc468c4HNNnhKRxoxaOYgrEXBz9OR97JU9+hyRxViSzu/L2xpIq7iWckFicfexzk9s9u3Aqq+9UeUcjdkeZ1bkkZ7E4GcH1HPXAncaY6wtlvI1j5R9+7h924Do2QAOcsRxjoO9dIAAAB0FY+kArcurJsITCgZwwyOQT26c9/wrZrOo9TKo9QooorMgKKKKACiiigDlTv8lCscSyEEfL+87EfgRhzxxkgd6cVjx5eUclcDrHIQAM4HXJXa2T3HSpbnBnV3IEoUYeUGJlyeMtjGchSeO9OATyH3FlwQY0lj3q3XAJB9SVOa6bnRch3zeVLMd+5kETEkn58c5bjIycYHUj87unTCNpnSNniiCxfKQArd8DjHVc5PpVC2VEVolCRI0odHZlAUDkHJHfbj5RgVcdp/scrSeWfMYlADkhh8vRuvQcYzn3pS7Cl2ElW2lt5XDMGO5wrREgA4IxxxwV5PTA9KluGt4mZ1fcjNtCn5wSepyenoPxx61AZI4pUj+zpDwvyeYUJYA4JBxnkjnJ+6cdKasIgIUqWkVQMMwIB2nJPqxIP5nHchWEOE6S7ZBEtwFI3q/YemPbr0P65OtYbWt942bmJL7RjnPfk8/wCRxWOIlzPIxPluNzqF3dRgnH5c9eT04JuQXJtVdfKYnqxOSM4JzkZJ6e/5AEqSutBSV1oa1FVYb+KRTuDxsvDBlOFYdRnocVZVldQykEEZBFZNNGbTQtFFFIQmBuLYGSME1jTW8lozOuxgYxvXbnv6AjABxg44xW1TJY0kjZXA246+lVF2Ki7GIsSyWwmwVi2sG24wT65x3BP5kcgYNiJkhhWfjLDeUMWx5GIPfgMeT0HNSRWDYcrNIFPKZOOexwOgzzjufSklvo7ON4p1VSQxVSeM9SOwxznPHHuDVt30Rbd9EZ9tIbtnLRwwKFJYphQg6HII78jdyPbvTsJ9qd4nWSSN95MZzjkE9Dkr0X6g8Y6kChZhFLKI5pDhmUAksflYYA7+p4yO/WtaW2iELx7xHJKPv99w5zj681TdmNuzKdgrm+EbltsSkgj7rH8v9s/mK16zLKG4j3yosZEjE8Ekbd3AX6jnPToKuxySAqk6gOehXo3H6d6znqyJasmoooqCAooooAKKKKAOdfDSTSKxYMcARuWAGCDgEEHgZ6jpx0FRS7o5HwpRtxG9crznHO3IznaQMjrjjipi8txCuA7RoMqSm4bcdMqcn+JTUKkABXlO0Kcc784AwM4yuVYD8K6UdCI98Quo5IvkYRMQoTJXAB4GOGAz0bHPX1lkjxHHEohkSIorPhm+ZRuOdoweOOfTpUO6KK0X93tBI3FgFAUZOB6ZG7jg429M06QxyEHGY4uQ7LhQ2cjCjjHDdTxz7Uxk0UkYvhLJMY1iyrl22dAM4U9uV9eFNO2bpmeNyiureVhOACc7sngE8Hb6DORwBFHazSQKGeXzZ5Ag8zDKeu/GOnyg555PpVqSFrdmiZduz5lcRkooJPIA6YyOc/wVLsS7C2xDtFK6sAU5BJUEE4b8OQfwOQM5MDRG3L+YjMFLDK5U+49cFWwMcjavtUbXPlbg5VflAOGDNkkLtAzjgMeCeMk1LeyNLJ5nVXOGAf5OCBk56ZHY4BwM0WdwtqNErRtEgkcb+FcZbdkfnkZJ6kk9O4pYpZElDI6I3UCRfX6DAPXnnPbjBpzB8sqcqwJG8ZBPrk8Z9+hGehzkxENimVo5Rz5e0ZyRg5yo5PueffpQBLBfX0ZKSJkBlwxxJuBIGAQQR65IyPc1fj1OJiVZXBU7XJGAD/P1P4GsImCdu6hT/AmBjGQ2Og6fjn35so6lY4pwSdp3qScbfQsMnv0PH8ynFCcUbqzxPtw4y33QeCeM9KbckFVjJ++wzz2HJz7Y4/GsS6nV3HDGJuo2fK/LMTjr3PHUdeoFOSM/YgquVuJSfLkQ7vKXOAAfU8+gJz2GKjk6k8hJqUjzXSJFcxuhyFjQqSGweGznv6D29ctMYltoi6kmNgfLdTz329TjgA4Pr71BFA/kI5ctsAUMoywYck4ypHUevTJOOTowQoBHLs/fkcIBt3DjlgRn+HI446Vb0VinoidGtrmKONGZSwLLtJ3L689qQWLSshvHjnC/9M8ZPbIyR6/nVPbPbXuQY44pcupRt2cYPzDA4znkdM1aivphBvmt2ZlJD+UOVPXkE/r/ACqGmtiWmti/TJIxIoGSpByrDsarLqUTJny5d+Mqm0ZYeoOcH86lhu45iFGVcjIVh1Hseh/Cos0RZoejvuKSD5hyGA4IqSoZflmhcDJJKY9iM/0qagQUUUUgCiiigDB8rG54Z1EjuUUMTE7nOMkjtuycAdzTLvzHumaaKbyfu7sISQuR2PJySOQMbs9afE8MKLtfHkqWwcxnOOOnyklT6VXM08tsYxKvQBy2NwAySR2Jzk/lnOcV0K9zdCSW/wBtlJeQS7+u1M49Pl6lcgn32Dsak2N57fv/ADiCEDFiCSOvPTOSRtPbd6VDEzRSeYw2t25Py57+vbGepC8cGkbcHOGMuQSSPvNxyPrg8g8DeSckUxlqFoYbu3neA+YG2+YFwcMO46E8qePX2rWZXleTaMpKFAkUjGzuPXPJ/MVjR3e9gs7Aq+0bx0+Y/ePp1J+pXjAroCY4YxkqiLgDPAFZz0M56EBW2sI5Jidg5JLP1PfqetYU0hdnI8xjnfjkjOeePvYOD07E/WrN9Oj3ckhk3Qp8jD5dhHHXgk8kjgH0NVCDvPkoJoyd6KPu4+vQDJPTnk9B0qCtqyoq2pLFLJakTrgAIQ3UjB9RxyABwcdD3NTS7Lm384REKMKAI1K7s+pGQM/8B49+awE0l3uGW+X/AJafeBzjg8g4x3HPp2qQJJFAVeaRSuC5DYUjoScEBvfI5PftTaKZG10oZi7ERx7vM3YAB4I5UYPTHPFPEbLKCvzKACTM20D58Z6cEEDt+Bpk08iPlFMUioTEMEn0G5QOmcYz0x0/uosBO9oz5gLYeRP42YdcqcgZI6DvTAcqHZ5ZWRS8o+VlGOoJU9ecnuMdOmTm4kQ8qGaV2G4FmXONwBOOp7lgR9Tz0xSAkSZN75Mv3494JTjO49CMHPrnOOvJsNKlyXIMbSKgHluCCnU9MbsDJHUcDoaTExWEqSM0bjzG6qwG3gkjtnj8B044OJGuZREyCHzA7Avu4J+bkE9COOvpxjg4YwwSgXn7zlf6f5/NsVIVEK7JZNx+7syBn0U9O2Oh44zwM1IizBfRAvDI+HBJQ+ueQBnqcf0+gbDHFLJ5T7/kJ8uTODjHI/I5HseOlQw+WGZJ2cEJyq4I2knI6Z7HngnHtUX2jy2lmVSuTuCs+cHqB7HJII/2wMmlbsK3YtXMRtplKB/KZdkcUJ24b6ZAP5jp3qpcDbJyrFl+Ybf4uRkfUgSDv1P1OwlzG7hVOQc4Oe4JH9Dj6GqV1bC2jd0K4ZlOMAHOTn68HHrj1pRfcUX3LlrEI7eMBzJhR8xbdnjqCanJAxk9a51NRl05yQrXED8mJcFkx95lA6j1Hr0PJxsw3MGoWYktpY5ElUlSRuH4j2PUUpRa1FKLWpPHIkqB43V1PQqcinVSspthNu6sCGOxvKZFPfAz6fyFXalqzJaswooopCK9xaJPGQMI5IIYDof85/OsW5spoHJSP92MgELkY47fh06fLyTmuioq4zaKjNo5ZWVpC8mWDAkYPOenX8lz3ywFJKIljQo5kycN+7wQe4A9Dk4xxluc8VvXenw3KltuH5Py8bjgjn8+vX3rMn02SOZWdS0bEBgnOOf/ANfHrt6kVoppmqkmRafax3kkodIpVAJwzHnnsevrzjkBR0q9eLI4PE7sFwwbb8qnr0x+h7HkVZto1aML5iMwGflwGQ+nH5fh3qO9FxKrRiJX2dZFbBGe23v24z79cCp5ryJ5rszcbV2DlQcjuDxnIP0+mRzwMilVjuYbsFu+ev8Akc/4KaaHVlBDEgg+4PfP9c/Q+1OfbsUn5dud27Ax+f589M88HFWUCkghgWyMdO/H/wBbH4Y4GDUxkVmWR+NozkdW+mOo4z+XBxVNrhQ5VSM85J6dOhz9AOeex7VPFJHI4ZFBkB+VSMle5Yk8nr/IEd6GgaHEQyW+wwxqmd8jhsEjcSFO3j9f6VLp0cUupPLHvXyxyhxhTgDHH/Age/A9Khm3BQVZyiFtxAzubBOTwc8/n/tAVFD5pjnJO4cqcA7wT1K85x948cdRjrhW0DoXtQk8pLtwkMg3KSsh/wBnnHPoB+v1rPiheTCZjmZcjKkcKD2GcY3HqSSfSpvOj2wQwgEg72MWFVsdzgdMjOcd6fgOVDZm+XO1G9M4GfXtnj+IkChaIFoiODzExdHckG4lcMWHTHORwByAPp7Ye0vmSBmXLNzhhggdMn8O3P8APEUcQRpJoWyqjt69eg69zgenOcc2pU86Im3C7m/1pU429Oc89sH8BjsaHuD3K7Hna6h5/MDlgecDoCe3A6+wz61FMhaGUjfhwSsYfaAeP8fwwOvBqQBc43Eqxypx827PDD8f1+uTbtItpDyKVd8EFercfw+nXrxxyMc072C9ivHsYukbzLI8nyfvCRgkkA5yM8545GRnFXjdQXcbW0z7XLYBxzx39iOR+FJK0IgwhiQbwuFTCnHb8COe3bjtXjtxKj3IJUTSAOrAEgE9j9T+XvzU6PUnR6liVvsbx2yRtcCRT8rAdgT1A9umO49hTIbe3kuybRpLeTYfNaM5ycjBOchv4uetXUskVIw7Mzou3eGK+mcYPAOOn0p7QlF3Q8OP7xJ3ex/xqOYnmK721zCyzi5muShz5TqgGO+3AHOM4yT/AFq1DcRXCb4ZFcA4OD0PofQ+1ORw6K69GAIqre2iyhZ0iVp0I7DLrnlT65GcA8Zwfelvoxb7lyis03r2smZYJorcnG6UrhT9QxwPr+fQEo5WHKzSoooqSQooooAZJFHLjzI0fHTcoOKz7mR7SXy7VxvfnY/K54xnv0zwPbArTopp2GnYzTamcedJbBJCAd8R2SZ9x0OPc1nXsM0MbFDuQDcxCkOvvtxnHXkdOeueOjprxrIMN25BHUH2qlOzKU7HK2940G/ZGqq6bPuZHXkjtnp7H8M01ZJH8tNv7xOhT7x/Hr9CfQn0rTm0lZEmIaJZImCqx+66hRjeOx5IyO35VnQq8PmF2ZJUBQqUGeMDJB4Oflx2PHIxmt009UbJp7FtwzQlZCu4DbsGFDtgHPXAH6Z6gEZpbdiz+SD04UkYYqBzgYPB69+MeuaZEHkhDNKodctjBDMc9jnOTznPPbkc04Ws1ujHEbKpIWRSTtIGTgbcZ6jsOuMHNT5E+QjqJZ5ZGBfGFww+83BwcfgMZ9z6GVUEDFpVxNuA27iVY47nuO/rwCSKbG0cWIZAwCnOwjBJycqCOvJI78E5PeldmZllQMGJ+RRkhR6n1/xx67qQDXLBRK6Mecq4+9tI+n+ceuCUluFhjSSFAJ1bIIXIK9P1z9f5GXaXf5QFHHBwT+fTHPbHX05DChTEbF0kXgKmCQex7cEHv6Ee1AAUWUtNExMuOhO0p2PXoOAD7EZ6cyzXZMBIjbeRkvjG0Zx8o7d/Xp3pjRq6FUCM3RWIO0L7E/Ucn29c02Fg06xMXk52K+VJ6DPUbT2wevT1oEQmGVdzyk7goIHsTtB545x0OeBjpmrtlGlxbzosrOXKDPQ7BwD7Hg/pTYLWW5XMFwFWHYIjJGcsByNwOPXGR79KspZXEbJKrReYMZAyMjAGN3Pp6DP5Um+gNjbe5ltpvsskMkg3lRIGLZJ579OPerl4+y1lHO4oQvHfHFZ90txFcllJHmfxmTAXjJPIwOBj8M49L6E3lkwb5d4ZCQCPUZwen07VD6Mh9GSLNCUQrIm1vu89fpUlZtvCrS3sDf6xiC8ijHOOOfpt49c1dRnQqkpBJ4DgYB/wNJolokdFkRkcAqwwQe4opaKSbWwJtBRRRSEFFFFABRRRQAUUUUAZ90xiumYCTYQrHaVCqc4LNnnAGOnTFZXnpPqLJPIHV4V/exHlXywO09xjGfYjueehkjL7WVgrKcgkZHpisa+by7qWO5MZ3gSggkYVePw/iyeeo64wdYO+hrB3FdQixxysGfoqqceYOuY/Yen8I9uCxnjeEQRPuwd25yygEYH04OO2QOxzmprfyp7Iw3rplgUQN0QYyACf4hjPPPHtk047P7P5gM2WLExmQbt5HGC+eOp6jOCcd6peY0TLHKzrEHDFTuEbnGMjoTjjAwM47HHNSfaA8YjfC7j8uBg+g45wBwAOeo4OQDGHUSfvkG9SwMhBIzyME9h146ct7VCS8chRypYn5vMHGOmD69cZ/A96LXHYshyY0kbAYEgZbAYgke+M8nv/AMC5JBKDAQzJG6nJbOd3sePTHHPb3BrsZPLaQlFhJycyZGf9rJ9gSMD8ccybElmj8uSRAxEfA5yDkbvT+Lpg5z1AosFgFwy27qY+nfcCwxk5/n69e+STFJG7qshI/eIVMgBw5HO0E8/3j+HqTlGBMayL8jSjbnPbJA/EY/L6DEskjuQIuWQFQpbgH2/zjkZ7YewFvSTslaIY4T59qEAHj9SS9Xrq7W1UEqWPoOwyBn8yKyLee4tXIjUOXHCkEA+n4+nrjBxjJGklJMp5d/4yc7ceo44BI6dz24qHG7uS43dy3JeSXULxmJI85GC+W4Gcjp068En2qezntXI2RiJz0UjH5fl0/Os5bcuoEjg5XqUDbcZwWyOfqOOnGMUOqxzshjO3o2F+6wGcjHPQL27L9VfKtg5VsXbm+kguBHHAuWbBJPJ4Pbv045/lirEUiX1qwPGflbaeh9QapLJ5luvnSqfKwyuE3MSMEHHoePr29atJJKhEf7tVIAjY5K9O2Ov0JBqWiWh8UjCYW52gxrk/7Q6DH9fy96KdcQ7wrqgMispB74B5/TP50VD1JJ6KKKQgooooAKKKKACiiigAqvdWUV2Y/NziM7lxjr2P+f6VYopp2BOxhzaY8I4l4ACocc9RjnPUtj8qkbSzbssVvKxWQbSjYIwPXj9ce3fNa5AZSrAEEYIPeoHhjjXIeVT0G1yefYHirU2Xzsy2smQeajME3FVVc7hzyO/THuOBgDrUXlvG23aEVGyqA7drY6+zc9jj04OTfigvIZFdiZOSWzjp7AY54/z3kutojF0QrDABjJ4Prn/6/A70+YrmMQQTySk+aIJDgLGAWYLxxnOCMjtxnGeSaVtOVLpYtlrKASxOxxhuAP4jnuP5+tWo3EkgXy2yT8o/iU//AFh/F9AcHpamsHERL/vVOWkAOGPHr3/Q8DtkVfM0VzWMi2tU8iLyooowyJ+8XdknJyByDk5qVReW0W3arYAZVyCATnPOFx75x39M1bGIQrN5cgfKq5IwmAcjp1xnORj6CmMcRbGYoDzyDufJHU9uce5JGDngnNcL3K8VzIqsbiCTZnJK9eOOOwOR0J45+lWIbyKC5ZZIlOFGY8gsCSccDv1yT+GMnLABwkhIf+E/3sfTuOB+IxxineWLpGGcFWwHA5JB4I/w+o74odgdiWWWLzGhj2+V97c2QR7EcErz265PpTTd+cqtDJnkHzQAd4HTnoQTt+YdvTqFXWFWIW+PLmQYY9j6leuR0JPbPfmoEwjujByT8zBcDzM9T/vdj69/Skl3FbuWbnaiGVkZ1j4VOMjvjuOO2eMdOerrS/tvsUkgzI79QylQ5Ppnt/nmmK/AlVsFiN0RIx5eD2JwDkHjtzTdgk229uokUjDAEgFe/OOARx19uwwraWYumo22BN7uikmw6nCg4xyehIGSM/xZyB0oqytsbaZXUlnV8MGPr0I7DIyMcDJ9qKmT7Ck+xq0UUVmZhRRRQAUUUUAFFFFABRRRQAUUUUAMaMPIrMTheQBxz7+v0/8ArVXliEcslwhwUTdt7HrnI9eBzRRTQ0xfIjtCJIlxlgpHsTjj0xn+n0p6hdv9pFsAAhIDe+R/9eiirhq9S4avUoW4+2XAtySpzgPnPGA3I79B/PrU4cuZY5Mt5bOpOcbtuBn260UVo9y3uV1laWV4yADCcFu5wGPHpwpH4+nFTSAiWS03MEiXkqcFhgnHt93H5egFFFD3G9xfsYu7V3Z9rRSbV2jowPX6c9P6cCtDOZbSOYZU7gQM5wDnj36fy7jNFFC1uJall53RGC7Qyx+YzYzuJAz19cgH6djTt8mm3U7F/NZU3HPGeMn15PHPsKKKXkHkbMsIkVsfK5XAb09D+BooorFNoxTaP//Z