This project retrieves real-time transit data from Hillsborough Area Regional Transit (HART)'s OrbCAD Automatic Vehicle Location (AVL) system and formats the data into the General Transit Feed Specification (GTFS)-realtime format. GTFS-realtime feeds can be consumed by applications such as OneBusAway and Google Transit to provide real-time transit data updates.
In this project, we serve up two types of GTFS-realtime data for HART:
We use the OneBusAway GTFS-realtime Exporter project to help produce and serve the GTFS-realtime feed.
Here's the architecture that is being used, with this project ("HART GTFS-realtime Generator") being the module in the middle:
This project uses Apache Maven, so you'll need to install and configure Maven to run on the command line. Then, run
mvn package to create the JAR file.
This project expects a file
config.properties, which contains credential information (e.g., username, password) for the database to be present in the parent directory of the application (which avoids accidentally checking this file into version control). For example, if the
cutr-gtfs-realtime-hart-1.0.1.jar file is in the directory
c:\gtfs-realtime-feed, you would need to put the
config.properties in the
config.properties file should contain the following fields:
host=123.456.789.001 portNumber=1433 databaseName=OrbCAD_III user=this_is_my_username password=this_is_my_password
host is the IP address of your database server,
portNumber is set to the database access port (
1433 is the default for Microsoft SQL Server),
databaseName is set to the name of the database that contains the real-time transit info you want to translate to GTFS-realtime,
this_is_my_username is replaced with the username of the user with permissions to execute queries against the database, and
this_is_my_password is replaced with the password of that user.
Below are the 5 arguments that we can feed into the program:
Execute the following via the command line to start the software that retrieves the real-time data from HART and hosts the Trip Updates and Vehicle Positions GTFS-realtime files on an embedded Jetty web server:
java -jar cutr-gtfs-realtime-hart-1.0.1.jar --tripUpdatesUrl=http://localhost:8088/trip-updates --vehiclePositionsUrl=http://localhost:8088/vehicle-positions --tripUpdatesPath=C:\Test\tripUpdates.pb --vehiclePositionsPath=C:\Test\vehiclePositions.pb --refreshInterval=5
NOTE: HART's SQL Server database is not open access. Therefore, you will not be able to execute a local copy of this application and pull back information from HART. However, you can point this tool at your own database to test by editing the
config.properties file to point to your own database. The SQL query that is executed to pull back records is:
SELECT [vehicle] as vehicle_id,[latitude],[longitude],[time],[delay],[speed],[bearing],[route] as route_id, [trip] as trip_id,[stop] as stop_id,[sequence] as seq FROM h_BusEvents ORDER BY trip_id, vehicle_id, seq ASC;
Therefore, if you provide a database table with the name
h_BusEvents with the same column names in the
 and some test data, you should be able to pull back this test data and see it formatted in GTFS-realtime. Note that your database should return only real-time data for this query - if a route/trip does not have real-time data, that record should not be returned by the query.
The code expects the data types for each field to be the following values (using Microsoft SQL Server data types from the database we originally built this for) - if your data is different, you may need to modify the code to handle different types (e.g., if your speed values are decimals and you want to keep this precision):
Here's an example dataset, based on actual real-time data for vehicles 1007, 2306, and 2308:
vehicle,latitude,longitude,time,delay,speed,bearing,route,trip,stop,sequence 1007,-82.458206,27.955198,20:08.0,-300,0,210,2,909728,4648,55 2306,-82.479233,27.981339,20:23.0,-180,13,270,14,910705,7378,10 2308,-82.442924,28.073837,19:00.0,-180,5,165,33,911647,605,13 ...
Full example dataset is in a CSV file here. You could try to import this data into a SQL database table to test, or manually create the records yourself with the exact same field names.
While the application is running, we can check the Trip Updates feed by browsing to links in an internet browser on the machine this application is running on:
http://localhost:8088/trip-updates?debugto see the Trip Updates feed in plain text, for HART debugging purposes only.
http://localhost:8088/trip-updatesto see the feed in Protocol Buffer format, which is the default GTFS-realtime format that would be consumed by applications.
While the application is running, we can check the Vehicle Positions feed by browsing to following links in an internet browser on the machine this application is running on:
http://localhost:8088/vehicle-positions?debugto see the feed in plain text, for HART debugging purposes only.
http://localhost:8088/vehicle-positionsto see the feed in Protocol Buffer format, which is the default GTFS-realtime format that would be consumed by applications.
Here's example links to view the information in the plain text debugging format:
...and Protocol Buffer Format (should be used by apps):