Pipeline

Road Classification Overlay ETL

Coverage: Coverage window unavailable for this page.

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

Page Navigation

Data Provenance

 
flowchart LR
  12_road_classification(["Road Classification Overlay ETL"])
  f1_12_road_classification[/"data/penndot-roadclass/roadwaysegments.json"/] --> 12_road_classification
  f2_12_road_classification[/"data/penndot-roadclass/roadwayadmin.json"/] --> 12_road_classification
  f3_12_road_classification[/"data/GTFS/shapes.txt"/] --> 12_road_classification
  f4_12_road_classification[/"data/GTFS/trips.txt"/] --> 12_road_classification
  a1_12_road_classification{"PennDOT ArcGIS Roadway Segments Layer (RMSSEG)"} --> 12_road_classification
  a2_12_road_classification{"PennDOT ArcGIS Roadway Admin Layer"} --> 12_road_classification
  12_road_classification --> tp_route_road_class[("route_road_class")]
  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 12_road_classification page;
  class tp_route_road_class table;
  class f1_12_road_classification,f2_12_road_classification,f3_12_road_classification,f4_12_road_classification file;
  class a1_12_road_classification,a2_12_road_classification api;

Source Code

 
"""Pipeline 12: load route-level road-classification metrics into prt.db."""

from prt_otp_analysis.road_overlay import main as road_main


def main() -> None:
    """Run road-classification overlay ETL."""
    road_main()


if __name__ == "__main__":
    main()

Tables Produced
TableDescription
route_road_class Route-level road-type metrics including length-weighted lane count, functional class, posted speed, arterial share, and divided-road share.

Sources
NameTypeWhy It MattersOwnerFreshnessCaveat
data/penndot-roadclass/roadwaysegments.json file Cached PennDOT ArcGIS roadwaysegments response (lane count, median type, geometry) for Allegheny County. Local project data owner not specified. Snapshot file; refresh by rerunning its pipeline step. May lag upstream source updates.
data/penndot-roadclass/roadwayadmin.json file Cached PennDOT ArcGIS roadwayadmin response (functional class, posted speed) for Allegheny County. 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.
PennDOT ArcGIS Roadway Segments Layer (RMSSEG) api Public state-roadway segment attributes including lane count and median type. Hosted by gis.penndot.gov. Queried during pipeline execution; freshness depends on upstream updates. Availability and schema can change without notice.
PennDOT ArcGIS Roadway Admin Layer api Public roadway administrative attributes including FHWA functional class and posted speed limit. Hosted by gis.penndot.gov. Queried during pipeline execution; freshness depends on upstream updates. Availability and schema can change without notice.