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
3
votes
4 answers

Associating nearby points with a path

Given a set of ordered points, and a path made up of ordered lat,lon points that goes near those points (in lat/lon coordinates), I want to associate the points with the path, ideally with good algorithmic complexity (n*log(n)) or better, but maybe…
Russell
  • 368
  • 2
  • 4
  • 17
3
votes
2 answers

Protobuf GTFS Realtime invalid wire-type

I have built my c# classes using the tool at https://protogen.marcgravell.com/ from the gtfs-realtime.proto file at https://developers.google.com/transit/gtfs-realtime/gtfs-realtime.proto Im pulling in a feed from…
user7841585
3
votes
0 answers

org.neo4j.kernel.GraphDatabaseQueryService No dependency satisfies interface

I am just writing a simple program where I am uploading my GTFS files to Neo4j Spatial. I believe it's some configuration error or some problem with Neo4j-spatial libraries, which is why I am not uploading my code which is quite basic as specified…
joe
  • 143
  • 10
3
votes
1 answer

Update two columns that are interdependent row-wise using data.table

I want to create a data.table with the departure and arrival times between bus stops. This is the format of my data.table. (reproducible dataset below) trip_id stop_sequence arrival_time departure_time travel_time 1: a 1 …
rafa.pereira
  • 13,251
  • 6
  • 71
  • 109
3
votes
1 answer

How to understand MTA's real-time gtfs data feeds

So far I've filled out the MTA online registration form for a Developer's API Key. Then in my android project, I implemented the gtfs realtime bindings dependecy from one of Google's github repositories, compile group: 'com.google.transit', name:…
Chris Gong
  • 8,031
  • 4
  • 30
  • 51
3
votes
1 answer

Creating iGraph graph from GTFS data with R

My goal is to convert GTFS stop and trip information into a graph where the vertices are the stops (from GTFS's stops.txt) and edges are trips (from GTFS's stop_times.txt). The first steps are evident: > library(igraph) #Reading in GTFS files >…
Hendrik
  • 1,158
  • 4
  • 15
  • 30
3
votes
2 answers

How can I do this complex SQL query using Django ORM? (sub-query with a join)

I'm used to writing my own SQL queries and I'm trying to get used to the whole ORM thing that seems to be so popular nowadays. Here's the query: SELECT * FROM routes WHERE route_id IN ( SELECT DISTINCT t.route_id FROM stop_times AS st LEFT…
Murat Ayfer
  • 3,894
  • 6
  • 29
  • 26
3
votes
2 answers

C# Get Full File Path

I have an ASP FileUpload control and I am uploading: C:\Documents and Settings\abpa\Desktop\TTPublisher\apache-tomcat-6.0.26\webapps\ttpub\WEB-INF\classes\org\gtfs\tmp\GTFS_Rail\routes.txt What is the C# code to grab this entire string using the…
balexander
  • 23,131
  • 14
  • 45
  • 68
3
votes
1 answer

How can I install & configure OpenTripPlanner on my server?

I want to use OpenTripPlanner for multimodal journeyplanning. I would like to use GTFS and GTFS-RT data together with openstreetmaps. My Platform: Ubuntu 10.04 (Lucid) LTS I found a lot of information on the internet, but a lot of it is old and…
BastiaanWW
  • 1,259
  • 4
  • 18
  • 34
3
votes
1 answer

How can I import GTFS files into MySQL?

GTFS is a common format for public transportation schedules. The General Transit Feed Specification (GTFS) defines a common format for public transportation schedules and associated geographic information. GTFS "feeds" allow public transit…
SparkAndShine
  • 17,001
  • 22
  • 90
  • 134
3
votes
2 answers

How can I list all the trips from one stop to another using GTFS?

I am using the below table: 1 0051ML66220600132482 06:00:00 06:00:00 1538 100 0 1 2 0051ML66220600132482 06:00:00 06:00:00 1540 200 0 0 3 0051ML66220600132482 06:00:00 06:00:00 1541 …
Yonkee
  • 1,781
  • 3
  • 31
  • 56
3
votes
1 answer

No idea how to interpret GTFS-realtime data

Sorry to come off as a "help vampire". I'm new to Android and very new to GTFS. I'm trying to read the data from NYC Subway lines from MTA, which is in GTFS-realtime format. Everything works fine; I've established the URL connection and parsed the…
Shubhang Desai
  • 329
  • 3
  • 17
3
votes
3 answers

How do I view and collect real time GTFS from a feed

I have experience using the static GTFS files which define the operating model for a specific public transport network. However my city has just release a real time feed for the bus locations and other status updates for the network. My question is,…
Tom
  • 925
  • 3
  • 10
  • 24
3
votes
2 answers

GTFS - how to combine the protocol buffers and GTFS file?

I am trying to look at the New York City Subway Realtime GTFS Feeds. After a lot of reading around, I learned about Protocol Buffers and installed the protoc compiler. New York City Transit has the file nyct-subway.proto.txt the first line says…
john mangual
  • 7,718
  • 13
  • 56
  • 95
3
votes
3 answers

How can I make my GTFS queries run faster?

I'm trying to play with a GTFS database, namely the one provided by the RATP for Paris and its suburbs. The set of data is huge. The stop_times table has 14 million rows. Here's the tables schemas:…
Benoit Duffez
  • 11,839
  • 12
  • 77
  • 125
1 2
3
18 19