no such column service_id

eMerzh commented 3 months ago

Hello,

not sure if it's my config , the gtfs or a bug,

(file: https://opendata.tec-wl.be/Current%20GTFS/TEC-GTFS.zip) but when i try to run this with a GTFS unzipped folder i got:


Started GeoJSON creation for 1 agencies.
Starting GTFS import for 1 file using SQLite database at :memory:
Importing GTFS from /Users/bmaron/Downloads/TEC-GTFS/
Importing - agency.txt - 5 lines imported
Skipping - areas.txt
Skipping - attributions.txt
Importing - booking_rules.txt - No file found
Importing - calendar_dates.txt - 807 lines imported
Importing - calendar.txt - 376 lines imported
Skipping - fare_attributes.txt
Skipping - fare_leg_rules.txt
Importing - fare_media.txt - No file found
Skipping - fare_products.txt
Importing - fare_rules.txt - No file found
Skipping - fare_transfer_rules.txt
Importing - feed_info.txt - 1 lines imported
Importing - frequencies.txt - No file found
Skipping - levels.txt
Importing - location_groups.txt - No file found
Importing - location_group_stops.txt - No file found
Importing - locations.geojson - No file found
Importing - networks.txt - No file found
Skipping - pathways.txt
Importing - route_networks.txt - No file found
Importing - routes.txt - 884 lines imported
Importing - shapes.txt - 5948496 lines imported
Skipping - stop_areas.txt
Importing - stop_times.txt - 6613632 lines imported
Importing - stops.txt - 31557 lines imported
Importing - timeframes.txt - No file found
Importing - transfers.txt - No file found
Importing - translations.txt - No file found
Importing - trips.txt - 214712 lines imported
Completed GTFS import for 1 agency

Starting GeoJSON creation for tec
Error: no such column: service_id
[  SqliteError: service_id

  - wrappers.js:5 Database.prepare
    [91e41f07a2ac43c9]/[better-sqlite3]/lib/methods/wrappers.js:5:21

  - routes.js:52 getRoutes
    [91e41f07a2ac43c9]/[gtfs]/lib/gtfs/routes.js:52:6

  - gtfs-to-geojson.js:140 buildGeoJSON
    [91e41f07a2ac43c9]/[gtfs-to-geojson]/lib/gtfs-to-geojson.js:140:20

  - gtfs-to-geojson.js:256 gtfsToGeoJSON
    [91e41f07a2ac43c9]/[gtfs-to-geojson]/lib/gtfs-to-geojson.js:256:11

  - gtfs-to-geojson.js:35 async setupImport
    [91e41f07a2ac43c9]/[gtfs-to-geojson]/bin/gtfs-to-geojson.js:35:3

] {
  code: 'SQLITE_ERROR'
}

Any idea how i can solve this?

brendannee commented 2 months ago

Thanks for reporting this issue.

I published an updated version https://github.com/BlinkTagInc/gtfs-to-geojson/releases/tag/3.7.0 which I think should solve this issue.

Try it out and let me know if it works for you.

eMerzh commented 2 months ago

It Does indeed fixed my issue 🎉 Thanks a lot for your quick reaction.

BlinkTagInc / gtfs-to-geojson

no such column service_id #25