Stack Overflow
Stack Overflow

Questions tagged [gtfs]

The General Transit Feed Specification (GTFS) defines a common format for public transportation schedules and associated geographic information.

The General Transit Feed Specification (GTFS) defines a common format for public transportation schedules and associated geographic information. GTFS "feeds" allow public transit agencies to publish their transit data and developers to write applications that consume that data in an interoperable way. GTFS-realtime is an extension to GTFS that allows public transportation agencies to provide realtime updates about their fleet to application developers.

273 questions
2
votes
1 answer

Plotting GTFS object routes with tidytransit in R

I need to plot General transit Feed Specification (GTFS) object routes and their frequencies. For this purpose I have run the following code from the package manual https://cran.r-project.org/web/packages/tidytransit/tidytransit.pdf to get some…
BRCN
  • 635
  • 1
  • 12
  • 26
2
votes
3 answers

How can I make this LINQ query of an Enumerable DataTable of GTFS data faster?

I'm working with the GTFS data for the New York City MTA subway system. I need to find the stop times for each route at a specific stop. To do that, I get the stop times from a StopTimes DataTable that I have, for a specific stop_id. I only want…
Matt McCormick
  • 678
  • 1
  • 9
  • 22
2
votes
1 answer

MySQL handling over 24h date format

I'm currently working with a data set that has time formatted over 24h, for example, 27:20:01 (which is 03:20:01). I've been using a query like this STR_TO_DATE(stop_times.arrival_time, "%H:%i:%s") >= STR_TO_DATE("03:14:46", "%H:%i:%s") to get…
John
  • 313
  • 3
  • 14
2
votes
2 answers

GTFS-realtime-bindings for iOS

MTA Subway data (among other data) is formatted in GTFS-realtime. In order to convert the protobuf into a string representation I must run it through some Google protobuf tools using gtfs-realtime.proto. The only problem is that, as can be seen…
IHaveAQuestion
  • 789
  • 8
  • 26
2
votes
0 answers

SQLite, read and parse a fairly large amount of data

I am reading latitudes and longitudes (as doubles) from a fairly large SQlite table. Using an external tool (DB Browser for Sqlite) the query takes 200ms to execute (over 2 millions results). However, in my code (same query) it takes around 8-10…
Tim Trewartha
  • 364
  • 3
  • 10
2
votes
2 answers

Geolocation and Haversine formula

I am trying to create a basic web application that detects the users geolocation, queries a mySQL database, and returns all bus stops within say 5 kilometers. The GTFS feed including the Longitude and Latitude have been inserted into a mySQL…
Bigredthelogger
  • 21
  • 2
2
votes
2 answers

Is there any way to convert Transport for London's TransXChange data to GTFS?

There used to be a tool by Google called Transxchange2GoogleTransit, but the project looks abandoned. It's not working with the latest NaPTAN data format which was released two years ago.
Louay Alakkad
  • 7,132
  • 2
  • 22
  • 45
2
votes
2 answers

What are some of the problems with GTFS?

I am intersted in replacing my current data format that I use with GTFS, but I hear and read from here and there that there are flaws in GTFS file format. Most of the time I see that you can't somehow predict some things such as delays or some…
dimrizo
  • 479
  • 1
  • 5
  • 14
2
votes
2 answers

streaming gtfs real time data into human readable format

I'm trying to download readable gtfs real time data (protocol buffer format) using Java so I can view it in a text file. I tried a couple of approaches: Approach #1: URL url = new URL(uri); byte[] buffer = new byte[4096]; InputStream is =…
Village Idiot
  • 21
  • 1
  • 2
2
votes
2 answers

splitting gtfs transit data into smaller ones

I sometime have a very large size of gtfs zip file - valid for a period of 6 months, but this is not economic for loading such big data size into a low resource (for example, 2 gig of memory and 10 gig hard disk) EC2 server. I hope to be able split…
Dung
  • 19,199
  • 9
  • 59
  • 54
2
votes
1 answer

Why the same query can take 1000 times as long depending on the where clause?

I have a rather big query that collects a lot of information in several tables, using joins. The database is a GTFS transit information from a city public transportation system. I'm running the same query with a different WHERE clause, and the time…
Benoit Duffez
  • 11,839
  • 12
  • 77
  • 125
2
votes
1 answer

How to use GTFS-realtime in OpenTripPlanner standalone?

I developed a tool to convert german transit data into GTFS and GTFS-realtime. Now I've got the task to test these files in OTP and I installed this standalone…
antje
  • 21
  • 3
2
votes
1 answer

How to get GTFS text files into an iOS app?

Really general question, but I have a bunch of GTFS text files and I would like to use them in my app. The end goal is to be able to locate the users current location and match it up with the nearest bus stop via the GTFS stop.txt file. How exactly…
Benny Tan
  • 45
  • 5
2
votes
1 answer

Where to find GTFS realtime file

I have been doing extensive research on GTFS and GTFS-Realtime. All I want to be able to do, is find out how late a certain bus would be. I can't seem to find where I can connect to, to properly search for a specific bus number. So my questions…
Sam1342
  • 23
  • 3
2
votes
1 answer

GTFS Query to list all departure and arrival times between two stop names

I'm working with GTFS structure for the first time and am having trouble with the queries. I've got the transit data into mysql tables, and am free to query them, but I feel like I'm doing far too many queries and for loops to get the simplest…
Miro
  • 5,307
  • 2
  • 39
  • 64
1 2 3
…
18 19