Pavement Condition Index (PCI) Scores from DataSF (pulled daily)

Streets Data - Pavement Condition Index (PCI) Scores Data pushed to ArcGIS Online on July 27, 2026 at 5:35 AM by SFGIS. Data from: https://data.sfgov.org/d/5aye-4rtt Description of dataset columns: CNN CNN of street segment or intersection location Street_Name Street name PCI_Score Paving Condition Index Score From_Street Cross street 1 To_Street Cross street 2 PCI_Change_Date Date condition score last updated Treatment_or_Survey Treatment: a full curb to curb, end to end street resurfacing treatment of an intersection or block; Survey: a visual inspection of a block that yields a pavement condition index (PCI) from 0 to 100 Street_Accepted_For_Maintenance Street accepted for maintenance by Public Works Functional_Class The functional class of the street segment: Arterial, Collector or Residential.\n X A coordinate whose value is determined by measuring parallel to an x-axis. CA State Plane III. Y A coordinate whose value is determined by measuring parallel to a y-axis. CA State Plane III. Latitude A geographic coordinate expressed in decimal degrees that specifies the north-south position of a point on the Earth's surface and assuming a WGS84 coordinate system. Longitude A geographic coordinate expressed in decimal degrees that specifies the east-west position of a point on the Earth's surface and assuming a WGS84 coordinate system. Line Represents vector geometry objects on a map Point Represents vector geometry objects on a map Neighborhoods This column was automatically created in order to record in what polygon from the dataset 'Neighborhoods' (jwn9-ihcz) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. SF Find Neighborhoods This column was automatically created in order to record in what polygon from the dataset 'SF Find Neighborhoods' (6qbp-sg9q) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. Current Police Districts This column was automatically created in order to record in what polygon from the dataset 'Current Police Districts' (qgnn-b9vv) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. Current Supervisor Districts This column was automatically created in order to record in what polygon from the dataset 'Current Supervisor Districts' (26cr-cadq) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. Analysis Neighborhoods This column was automatically created in order to record in what polygon from the dataset 'Analysis Neighborhoods' (ajp5-b2md) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. Note: If no description was provided by DataSF, the cell is left blank. See the source data for more information.街道数据集 - 路面状况指数（Pavement Condition Index，PCI）评分数据，由SFGIS于2026年7月27日凌晨5:35推送至ArcGIS Online。数据来源：https://data.sfgov.org/d/5aye-4rtt 数据集字段说明如下： - CNN：对应街道路段或交叉口位置的CNN - Street_Name：街道名称 - PCI_Score：路面状况指数评分 - From_Street：起始交叉街道1 - To_Street：终止交叉街道2 - PCI_Change_Date：路面状况评分的最后更新日期 - Treatment_or_Survey：处理或勘测：指对交叉口或路段开展全路缘至全路缘、全路段的路面翻新作业；或对路段进行目视勘测，得出0至100分的路面状况指数（PCI） - Street_Accepted_For_Maintenance：已由公共工程部门受理维护的街道 - Functional_Class：街道路段的功能分类，分为主干道（Arterial）、次干道（Collector）与居民区道路（Residential）三类 - X：以加州第三州平面坐标系（CA State Plane III）为基准，沿X轴方向测量得到的坐标值 - Y：以加州第三州平面坐标系（CA State Plane III）为基准，沿Y轴方向测量得到的坐标值 - Latitude：采用WGS84坐标系的十进制地理坐标，用于表述地球表面某点的南北方位 - Longitude：采用WGS84坐标系的十进制地理坐标，用于表述地球表面某点的东西方位 - Line：用于表示地图上的矢量几何对象 - Point：用于表示地图上的矢量几何对象 - Neighborhoods：该列自动生成，用于记录`point`列中的点属于数据集`Neighborhoods`（jwn9-ihcz）中的哪一个多边形，可用于在可视化画布与数据透镜中创建区域分级统计图 - SF Find Neighborhoods：该列自动生成，用于记录`point`列中的点属于数据集`SF Find Neighborhoods`（6qbp-sg9q）中的哪一个多边形，可用于在可视化画布与数据透镜中创建区域分级统计图 - Current Police Districts：该列自动生成，用于记录`point`列中的点属于数据集`Current Police Districts`（qgnn-b9vv）中的哪一个多边形，可用于在可视化画布与数据透镜中创建区域分级统计图 - Current Supervisor Districts：该列自动生成，用于记录`point`列中的点属于数据集`Current Supervisor Districts`（26cr-cadq）中的哪一个多边形，可用于在可视化画布与数据透镜中创建区域分级统计图 - Analysis Neighborhoods：该列自动生成，用于记录`point`列中的点属于数据集`Analysis Neighborhoods`（ajp5-b2md）中的哪一个多边形，可用于在可视化画布与数据透镜中创建区域分级统计图 备注：若DataSF未提供对应字段描述，则对应单元格留空。更多信息请查阅源数据。