ben/gtfs-dagster
SHA256
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions

added MCTS and WTA to agency_list.csv

Browse source
This commit is contained in:
Ben Varick 2025-11-05 18:33:31 -08:00
parent 2b47a45b8f
commit 38243834c5
Signed by: ben
SSH key fingerprint: SHA256:jWnpFDAcacYM5aPFpYRqlsamlDyKNpSj3jj+k4ojtUo
2 changed files with 3 additions and 1 deletions
Download patch file Download diff file Expand all files Collapse all files

2
data/gtfs/agency_list.csv
View file

@ -1,2 +1,4 @@
Name,GTFS,GTFS-RT_vehicles,GTFS-RT_trips,GTFS-RT_alerts Name,GTFS,GTFS-RT_vehicles,GTFS-RT_trips,GTFS-RT_alerts
Madison Metro,mdb-394,mdb-2097,mdb-2096,mdb-2095 Madison Metro,mdb-394,mdb-2097,mdb-2096,mdb-2095
Milwaukee County Transit System,mdb-2127,mdb-2130,mdb-2128,mdb-2129
Whatcom Transportation Authority,mdb-284,tld-4358-vp,tld-4358-tu,tld-4358-sa

1 Name GTFS GTFS-RT_vehicles GTFS-RT_trips GTFS-RT_alerts
2 Madison Metro mdb-394 mdb-2097 mdb-2096 mdb-2095
3 Milwaukee County Transit System mdb-2127 mdb-2130 mdb-2128 mdb-2129
4 Whatcom Transportation Authority mdb-284 tld-4358-vp tld-4358-tu tld-4358-sa

2
user_code/gtfs/assets.py
View file

@ -13,6 +13,6 @@ def agency_list(duckdb: DuckDBResource) -> None:
# Write to DuckDB # Write to DuckDB
with duckdb.get_connection() as conn: with duckdb.get_connection() as conn:
conn.execute(""" conn.execute("""
CREATE TABLE IF NOT EXISTS agency_list AS CREATE OR REPLACE TABLE agency_list AS
SELECT * FROM df SELECT * FROM df
""") """)