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
0
votes
1 answer

How do I use calendar exceptions to generate accurate schedules using GTFS?

I'm having trouble figuring out the GTFS query to obtain the next 20 schedules for a given stop ID and a given direction. I know the stop ID, the trip direction ID, the time (now) and the date (today) I wrote SELECT DISTINCT ST.departure_time FROM…
facewindu
  • 705
  • 3
  • 11
  • 31
0
votes
0 answers

How to make a shapes.txt in GTFS

I've been compiling data to make a GTFS but i want to know what are some of the GIS systems that people are using to create the shapes.txt. What are some of the problems you are running into and what are some of the benefits of your workflow.
user3551829
  • 1
0
votes
1 answer

How do I quickly find travel times between transit stops with transfers - using GTFS data in PostgreSQL

I have a PostgreSQL database (with PostGIS) and GTFS data (https://developers.google.com/transit/gtfs/reference) from several transit agencies imported. I have identified all potential transfer locations based on proximity, and populated a table…
Paul
  • 63
  • 5
0
votes
1 answer

Does anyone know how to map GTFS data info into http://simcity.vasile.ch/sbb/?

Need your suggestions , in order to go with a script that is already working using google map & json files? Or Do i use any other open source code to show live train simulator using GTFS Data. My aim is to create a running simulator somthing…
user2977345
  • 3
  • 1
0
votes
0 answers

Getting routes associated with bus stops

I have GTFS data and I want to have information about routes departing from bus stop. For particular stop I used this code: select stops.stop_id, stops.stop_name, stops.stop_lat, stops.stop_lon, stops.zone_id, GROUP_CONCAT( distinct…
dargod
  • 334
  • 1
  • 15
0
votes
1 answer

Understanding how to architect improve a Python/Flask app running on Heroku

Context I've written a simple service that consists of A Python Script Running in Flask Framework Hosted on Heroku - (currently running 1 dyno) The mechanics of the data transfer are somewhat unique Something calls the Heroku app The Heroku app…
drc
  • 1,905
  • 4
  • 22
  • 28
0
votes
3 answers

What does it mean "To derive timestamp from a time server."?

Context I'm learning how to use Google's - GTFS-realtime The timestamps that are supplied by a service adhering to this standard are described on this page: https://developers.google.com/transit/gtfs-realtime/reference Part of the instructions…
drc
  • 1,905
  • 4
  • 22
  • 28
0
votes
1 answer

GTFS data - stop data

Feeling bit rusty about my SQL skills at the moment. What I would like to achieve is connect two SQL queries into one which give me basically all information about particular stop. First query is simple one. It takes all stop informations. Piece of…
dargod
  • 334
  • 1
  • 15
0
votes
1 answer

SQlite query for stop times in GTFS data

I am working with GTFS data on Android (SQlite). And I would like to improve performance when I do select queries in my database filled with GTFS data. The query below select the stop times associated to a route at a stop: The first sub query gets…
vital
  • 1,308
  • 3
  • 13
  • 28
0
votes
1 answer

Finding the routes associated with a stop in GTFS, not vice versa (maybe similar)

I hope someone can help. Hi am building a transit app for Android and I have hit a snag. I would like to get all of the busses/routes which service a particular stop. e.g. Stop No: 12345 have Busses: 123 & 321. I have this piece of SQL: SELECT…
RichC
  • 73
  • 1
  • 10
0
votes
1 answer

Python script for Sqlite time subtraction after midnight

I have a database of General Transit Feed Specification data for a city that defines transit service after midnight as hour > 24. So, in the stop_times table, we have many times defined for example as 25:00:00, 26:00:00, etc. Since I need to perform…
George
  • 343
  • 2
  • 15
0
votes
2 answers

Use of compressed GTFS data in Android app

I am looking to develop a transit app using GTFS static data. One of the constraints I've set to myself is that the app should use minimal mobile data transfers. Therefore, I would like to embed all the data in the app. My issue is that GTFS data…
chopchop
  • 1,905
  • 2
  • 22
  • 37
0
votes
2 answers

Get the latitude longitude for a point on a shape (path)

I have a a list of points (latitude,longitude), it's a bus path and around this path I have some points (bus stops), the points are not on the path. I need to project the bus stops points on the path for compute the traveled distance from the…
Maxime
  • 357
  • 2
  • 10
  • 23
-1
votes
1 answer

Schedule Viewer GTFS

When i am trying to run Schedule Viewer from PC, it is looking for Google Map API Key, and it doesn't show the routeS on the Google Map, it never asked before, worked fine. Any feedback from Google,or anybody facing the problem.
user1184466
  • 1
  • 1
-1
votes
0 answers

Call MTA API to get response formatted as a json object

I've tried a few different ways to get a response formatted from the MTA API in json (without modification, it returns a protobuf). Unfortunately, I've come pretty close but just can't seem to get a properly json formatted object. Here's the…
Kunal Mehta
  • 1
  • 1
1 2 3
…
18
19