GTFSrDB: Plumbing for GTFS-realtime
178 views
Skip to first unread message
Matt Conway
Sep 2, 2011, 11:54:34 PM9/2/11
to GTFS-realtime
I'd like to introduce a new project I've been working on: GTFS-
realtime, which will keep an SQL database up-to-date with the latest
GTFS-realtime data, allowing developers to access realtime data with
SQL, rather than figure out how to plumb the feeds into their app and
merge them with GTFS data.
It's designed to work with GTFSdb, so that static and realtime data
can be kept in the same database. It's written in Python and uses
SQLAlchemy, so it should work with most relational databases.
It can also be used to archive GTFS-realtime data for statistical
analysis; to do that, omit the -o option. In other cases, be sure to
specify -o to avoid filling your database with out of date
information!
More information is available on the announcement on my blog:
http://indicatrix.wordpress.com/2011/09/02/gtfsrdb-plumbing-for-gtfs-realtime/
and the project GitHub page:
https://github.com/mattwigway/gtfsrdb
Let me know if you find it useful or have questions!
realtime, which will keep an SQL database up-to-date with the latest
GTFS-realtime data, allowing developers to access realtime data with
SQL, rather than figure out how to plumb the feeds into their app and
merge them with GTFS data.
It's designed to work with GTFSdb, so that static and realtime data
can be kept in the same database. It's written in Python and uses
SQLAlchemy, so it should work with most relational databases.
It can also be used to archive GTFS-realtime data for statistical
analysis; to do that, omit the -o option. In other cases, be sure to
specify -o to avoid filling your database with out of date
information!
More information is available on the announcement on my blog:
http://indicatrix.wordpress.com/2011/09/02/gtfsrdb-plumbing-for-gtfs-realtime/
and the project GitHub page:
https://github.com/mattwigway/gtfsrdb
Let me know if you find it useful or have questions!
Brian Ferris
Sep 5, 2011, 4:00:41 AM9/5/11
to gtfs-r...@googlegroups.com
Thanks, Matt!
> --
> You received this message because you are subscribed to the Google Groups "GTFS-realtime" group.
> To post to this group, send email to gtfs-r...@googlegroups.com.
> To unsubscribe from this group, send email to gtfs-realtim...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/gtfs-realtime?hl=en.
>
>
Ryan Finnesey
Sep 5, 2011, 5:11:53 PM9/5/11
to gtfs-r...@googlegroups.com, Matt Conway
Hey Matt
Seems like a very cool project. I look forward to taking a look at it.
Cheers
Ryan
--
Jeffrey Munowitch
Sep 7, 2011, 9:12:50 PM9/7/11
to gtfs-r...@googlegroups.com
This looks like a very cool project and I look forward to using this as a base to any GTFS-realtime projects that I want to work on.
Any licensing info?
-Jeff
Matt Conway
Sep 9, 2011, 11:20:55 AM9/9/11
to gtfs-r...@googlegroups.com
It's under the Apache 2 license (the disclaimer is on the source, but I should probably be more upfront about it; I'm just switching to GitHub from Google Code, which requires license selection as a precursor to getting a source code repository). If there's an application you have in mind that's prohibited by that license (I can't imagine there would be), let me know and we can discuss it.
-Matt
--
You received this message because you are subscribed to the Google Groups "GTFS-realtime" group.
To view this discussion on the web visit https://groups.google.com/d/msg/gtfs-realtime/-/NdOF7eJzznwJ.
Reply all
Reply to author
Forward
0 new messages