GTFSDB & GTFSrDB

[eduabumah001]

Hello,

I am working on Accuracy and Effectiveness of GTFS Transit Feeds for Trip Planning in Public Transit Networks a public transit. I am using data of San Diego and MBTA (Boston city).I want to import both GTFS and GTFS-rt into PostgreSQL so I can perform my analysis on them. I have had a look on your instructors on both https://github.com/mattwigway/gtfsrdb & https://github.com/OpenTransitTools/gtfsdb but they are not working for me. For the GTFSDB it created tables but they are empty. And for GTFSrDB I got this error gtfsrdb.py: command not found.
Can you please assist me with the approach I need to follow.

Thanks & Regards,

[barbeau]

@eduabumah001 It's been a while since we used this tool internally. IIRC to use the tools together you have to use them in a specific order otherwise the one overwrites the other - maybe let the RT importer run continously, and then after you're done to the GTFS import? Keep backups in case I'm wrong so you don't accidentally overwrite the collected data.

If you contact me offline (https://www.linkedin.com/in/seanbarbeau/) we could likely use an alternate archiving system we've been running internally for a while now and share the collected data.

[eduabumah001]

Hey Barbeau,
I have used GTFSDB then GTFSrDB but when I checked PostgreSQL i found that only the tables are created but they are empty. And yes when I use the GTFSrDB it runs continuously giving me only warnings.
Is there another way to import both GTFS static and realtime into PostgreSQL?

P.S I could not contact you using LinkedIn.

[barbeau]

@eduabumah001 My USF contact info is in the profile here - https://github.com/CUTR-at-USF - please try that.