Reference
Sources Inventory
Unified catalog of files, APIs, tables, and library dependencies used in this project.
Built 2026-06-15 11:52 UTC · Commit e5cf673
Inventory
Includes source ownership, freshness expectations, and caveats inferred from manifests.
| Name | Type | Description | Owner | Freshness | Caveat |
|---|---|---|---|---|---|
| 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. |
| NOAA NCEI Daily Summaries API | api | Daily weather observations for station USW00094823 (Pittsburgh). | Hosted by www.ncei.noaa.gov. | Queried during pipeline execution; freshness depends on upstream updates. | Availability and schema can change without notice. |
| OpenStreetMap Overpass API | api | Public query endpoint for OSM nodes tagged highway=traffic_signals. | Hosted by overpass-api.de. | 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. |
| 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 Traffic Layer | api | Public roadway segment AADT and truck percentage attributes. | Hosted by gis.penndot.gov. | Queried during pipeline execution; freshness depends on upstream updates. | Availability and schema can change without notice. |
| 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. |
| WPRDC Pick Lookup | api | Public lookup for pick period date ranges. | Hosted by data.wprdc.org. | Queried during pipeline execution; freshness depends on upstream updates. | Availability and schema can change without notice. |
| WPRDC Schedule Monthly Aggregate | api | Public dataset of route-level monthly schedule aggregates. | Hosted by data.wprdc.org. | Queried during pipeline execution; freshness depends on upstream updates. | Availability and schema can change without notice. |
| analyses/51_traffic_signals_otp | dependency | Python library dependency used by one or more analyses or pipeline steps. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| analyses/53_stop_signal_placement | dependency | Python library dependency used by one or more analyses or pipeline steps. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| analyses/55_road_classification_otp | dependency | Python library dependency used by one or more analyses or pipeline steps. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| branca | dependency | Utility library used by Folium for map templating, colormaps, and HTML components. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| folium | dependency | Mapping library used to render interactive geospatial visualizations. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| geopandas | dependency | Python library dependency used by one or more analyses or pipeline steps. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| matplotlib | dependency | Plotting library used to generate static charts. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| numpy | dependency | Numerical computing library for vectorized arrays and matrix operations. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| polars | dependency | Dataframe library used for fast tabular data transformations and aggregation. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| scipy | dependency | Scientific computing library used for statistical tests and numerical routines. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| shapely | dependency | Python library dependency used by one or more analyses or pipeline steps. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| statsmodels | dependency | Statistical modeling library used for regression and time-series methods. | Open-source Python ecosystem maintainers. | Version pinned by project environment until dependency updates are applied. | Library updates may change behavior or defaults. |
| analyses/53_stop_signal_placement/output/stop_classifications.csv | file | Per-stop near-side / far-side / mid-block classification from Analysis 53. | 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/stop_times.txt | file | GTFS stop sequence per trip. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/GTFS/stops.txt | file | GTFS stop locations and stop_code join key. | 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. |
| data/PRT_Current_Routes_Full_System_de0e48fcbed24ebc8b0d933e47b56682.csv | file | Current route metadata and mode classifications. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/PRT_Stop_Reference_Lookup_Table.csv | file | Historical stop reference file with geography attributes. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/Transit_stops_(current)_by_route_e040ee029227468ebf9d217402a82fa9.csv | file | Current stop-to-route coverage and trip counts. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/allegheny-go/demographics_summary.csv | file | Allegheny Go enrollee demographic summary. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/allegheny-go/enrollments_weekly.csv | file | Weekly Allegheny Go enrollment counts by enrollment type. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/allegheny-go/tract_reach.csv | file | Allegheny Go households reached per census tract. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/average-ridership/12bb84ed-397e-435c-8d1b-8ce543108698.csv | file | Average ridership by route and month. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/bus-stop-usage/wprdc_stop_data.csv | file | Pre-pandemic weekday boardings and alightings per stop (WPRDC), keyed by PRT internal stop_id; used to weight signal-stop placement by ridership. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/noaa-weather/daily_raw.csv | file | Cached NOAA daily observations for Pittsburgh station. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/ntd-annual-service/2023_TS2.2_Service_Data.xlsx | file | NTD TS2.2 workbook with annual service data by system. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/ntd-monthly-ridership/December 2025 Complete Monthly Ridership (with adjustments and estimates)_260202.xlsx | file | NTD monthly ridership workbook containing agency metadata and UPT series. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/osm-signals/traffic_signals_raw.json | file | Cached OpenStreetMap Overpass response of traffic-signal nodes 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/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-traffic/aadt_raw.json | file | Cached PennDOT ArcGIS feature response for Allegheny County roadway segments. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| 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/prt-stop-signals/bus_stops_with_signals_2602.xlsx | file | PRT-provided spreadsheet (Samuel Buckley, 2026) tagging each of 6,306 bus stops as no-signal, near-side, far-side, or busway/BRT. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/routes_by_month.csv | file | Monthly route OTP source table in wide format. | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| 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/wprdc-schedule/paac_pick_lookup.csv | file | Pick period lookup metadata (cached copy when available). | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| data/wprdc-schedule/schedule_monthly_agg.csv | file | Monthly route/day-type schedule aggregates (cached copy when available). | Local project data owner not specified. | Snapshot file; refresh by rerunning its pipeline step. | May lag upstream source updates. |
| allegheny_go_weekly | table | Database table consumed by one or more analyses. | Project pipeline owner not linked. | Refresh cadence unknown. | Coverage depends on upstream source availability and ETL assumptions. |
| census_tracts | table | Database table consumed by one or more analyses. | Project pipeline owner not linked. | Refresh cadence unknown. | Coverage depends on upstream source availability and ETL assumptions. |
| ntd_agency | table | Agency dimension table keyed by NTD ID, mode, and TOS. Produced by NTD Ridership ETL. | Produced by NTD Ridership ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| ntd_annual_service | table | Annual VRH, VRM, UPT, VOMS by NTD system (1991-2023). Produced by NTD Annual Service ETL. | Produced by NTD Annual Service ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| ntd_fleet_age | table | Database table consumed by one or more analyses. | Project pipeline owner not linked. | Refresh cadence unknown. | Coverage depends on upstream source availability and ETL assumptions. |
| ntd_ridership | table | Monthly UPT facts by NTD ID, mode, and TOS. Produced by NTD Ridership ETL. | Produced by NTD Ridership ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| otp_monthly | table | Monthly OTP values by route. Produced by Data Ingestion. | Produced by Data Ingestion. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| ridership_monthly | table | Monthly ridership by route and day type. Produced by Data Ingestion. | Produced by Data Ingestion. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| route_road_city | table | Route-level city-network road-width metrics including length-weighted lane count, one-way share, and limited-access (freeway) share. Produced by City Centerline Overlay ETL. | Produced by City Centerline Overlay ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| route_road_class | table | Route-level road-type metrics including length-weighted lane count, functional class, posted speed, arterial share, and divided-road share. Produced by Road Classification Overlay ETL. | Produced by Road Classification Overlay ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| route_road_pavement | table | Route-level pavement-quality metrics including length-weighted IRI roughness, overall pavement index, and share of length rated poor. Produced by NHS Pavement-Condition Overlay ETL. | Produced by NHS Pavement-Condition Overlay ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| route_signals | table | Route-level traffic signal count, representative route length, and signal density. Produced by Signal Overlay ETL. | Produced by Signal Overlay ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| route_stops | table | Route-stop bridge with service frequency metrics. Produced by Data Ingestion. | Produced by Data Ingestion. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| route_traffic | table | Route-level traffic exposure metrics including weighted AADT and match quality. Produced by Traffic Overlay ETL. | Produced by Traffic Overlay ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| routes | table | Route dimension table. Produced by Data Ingestion. | Produced by Data Ingestion. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| scheduled_trips_monthly | table | Monthly route/day-type scheduled trip counts and distance metrics. Produced by Scheduled Trips ETL. | Produced by Scheduled Trips ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| stop_reference | table | Historical stop metadata and geography. Produced by Data Ingestion. | Produced by Data Ingestion. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| stop_signals | table | Per-stop authoritative signal classification (signal_class, has_signal) keyed by stop_code with resolved GTFS stop_id. Produced by PRT Stop-Signal Classification ETL. | Produced by PRT Stop-Signal Classification ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| stops | table | Physical stop dimension table. Produced by Data Ingestion. | Produced by Data Ingestion. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |
| weather_monthly | table | Monthly precipitation, temperature, snowfall, and wind summary features. Produced by Weather ETL. | Produced by Weather ETL. | Updated when the producing pipeline step is rerun. | Coverage depends on upstream source availability and ETL assumptions. |