Pipeline

NHS Pavement-Condition Overlay ETL

Coverage: Coverage window unavailable for this page.

Built 2026-06-15 11:52 UTC · Commit e5cf673

Page Navigation

Data Provenance

 
flowchart LR
  14_pavement_overlay(["NHS Pavement-Condition Overlay ETL"])
  f1_14_pavement_overlay[/"data/spc-pavement/pavement_raw.geojson"/] --> 14_pavement_overlay
  f2_14_pavement_overlay[/"data/GTFS/shapes.txt"/] --> 14_pavement_overlay
  f3_14_pavement_overlay[/"data/GTFS/trips.txt"/] --> 14_pavement_overlay
  a1_14_pavement_overlay{"SPC NHS Pavement Condition (PM2_Roadways, ArcGIS)"} --> 14_pavement_overlay
  14_pavement_overlay --> tp_route_road_pavement[("route_road_pavement")]
  classDef page fill:#dbeafe,stroke:#1d4ed8,color:#1e3a8a,stroke-width:2px;
  classDef table fill:#ecfeff,stroke:#0e7490,color:#164e63;
  classDef dep fill:#fff7ed,stroke:#c2410c,color:#7c2d12,stroke-dasharray: 4 2;
  classDef file fill:#eef2ff,stroke:#6366f1,color:#3730a3;
  classDef api fill:#f0fdf4,stroke:#16a34a,color:#14532d;
  classDef pipeline fill:#f5f3ff,stroke:#7c3aed,color:#4c1d95;
  class 14_pavement_overlay page;
  class tp_route_road_pavement table;
  class f1_14_pavement_overlay,f2_14_pavement_overlay,f3_14_pavement_overlay file;
  class a1_14_pavement_overlay api;

Source Code

 
"""Pipeline step 14: build the route_road_pavement table from SPC's NHS
pavement-condition layer. Thin wrapper around prt_otp_analysis.road_overlay_pavement.main."""

from prt_otp_analysis.road_overlay_pavement import main as pavement_main

if __name__ == "__main__":
    pavement_main()

Tables Produced
TableDescription
route_road_pavement Route-level pavement-quality metrics including length-weighted IRI roughness, overall pavement index, and share of length rated poor.

Sources
NameTypeWhy It MattersOwnerFreshnessCaveat
data/spc-pavement/pavement_raw.geojson file Cached SPC NHS pavement-condition GeoJSON (ROUGH_INDX/IRI, OVERALL_PV, IRI_RATING, geometry) in WGS84. Local project data owner not specified. Snapshot file; refresh by rerunning its pipeline step. May lag upstream source updates.
data/GTFS/shapes.txt file GTFS route shape geometry points. Local project data owner not specified. Snapshot file; refresh by rerunning its pipeline step. May lag upstream source updates.
data/GTFS/trips.txt file GTFS shape-to-route mapping. Local project data owner not specified. Snapshot file; refresh by rerunning its pipeline step. May lag upstream source updates.
SPC NHS Pavement Condition (PM2_Roadways, ArcGIS) api Southwestern Pennsylvania Commission feature service of NHS pavement condition (IRI roughness, overall pavement index, IRI rating) derived from PennDOT roadway-management data. Hosted by services3.arcgis.com. Queried during pipeline execution; freshness depends on upstream updates. Availability and schema can change without notice.