Pipeline

City Centerline Overlay ETL

Coverage: Coverage window unavailable for this page.

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

Page Navigation

Data Provenance

flowchart LR
  13_city_centerline(["City Centerline Overlay ETL"])
  f1_13_city_centerline[/"data/pgh-centerline/centerline_raw.geojson"/] --> 13_city_centerline
  f2_13_city_centerline[/"data/GTFS/shapes.txt"/] --> 13_city_centerline
  f3_13_city_centerline[/"data/GTFS/trips.txt"/] --> 13_city_centerline
  a1_13_city_centerline{"City of Pittsburgh Street Centerline (ArcGIS Hub)"} --> 13_city_centerline
  13_city_centerline --> tp_route_road_city[("route_road_city")]
  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 13_city_centerline page;
  class tp_route_road_city table;
  class f1_13_city_centerline,f2_13_city_centerline,f3_13_city_centerline file;
  class a1_13_city_centerline api;

  Source Code
    
      """Pipeline step 13: build the route_road_city table from the City of Pittsburgh
street centerline. Thin wrapper around prt_otp_analysis.road_overlay_city.main."""

from prt_otp_analysis.road_overlay_city import main as city_main

if __name__ == "__main__":
    city_main()

Tables Produced

Table	Description
`route_road_city`	Route-level city-network road-width metrics including length-weighted lane count, one-way share, and limited-access (freeway) share.

Sources

Name	Type	Why It Matters	Owner	Freshness	Caveat
data/pgh-centerline/centerline_raw.geojson	file	Cached City of Pittsburgh street-centerline GeoJSON (lane count, CFCC road class, one-way flag, 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.
City of Pittsburgh Street Centerline (ArcGIS Hub)	api	Public city street-centerline feature service with lane count, Census Feature Class Code, and one-way attributes.	Hosted by hub.arcgis.com.	Queried during pipeline execution; freshness depends on upstream updates.	Availability and schema can change without notice.