Re: Trapeze AVL/ITS data to GTFS-RT Feed...

1,127 views
Skip to first unread message

Sean Barbeau

unread,
Oct 9, 2012, 1:31:48 PM10/9/12
to gtfs-r...@googlegroups.com
Tack,
We've been working on producing a GTFS-realtime feed in Tampa, FL using HART's realtime data.  Our project is open-source under Apache 2.0 on Github and is based on some of the GTFS-realtime community tools:
https://github.com/CUTR-at-USF/HART-GTFS-realtimeGenerator/wiki

While HART has an Orbital OrbCAD AVL system, we're also pulling the real-time data from a SQL DB (MS SQL Server).  So, it may be as simple as modifying the SQL query to pull the correct Trapeze database fields, and the rest of your project would essentially be the same as ours.

Sean

Sean Barbeau
Center for Urban Transportation Research
University of South Florida

On Monday, October 8, 2012 9:26:22 PM UTC-4, Tack Hammer wrote:
Has anyone out there done the work yet to publish GTFS-RT feed from Trapeze's AVL/ITS system? We, CATA in Lansing Michigan, are capturing all the data real-time in our backend SQL DB, but need code to publish the GTFS-RT feed. Trapeze has not yet developed a solution so we're looking for someone who has already done this or has the skill set to hire to do the work. Thx!

Tack Hammer

unread,
Oct 10, 2012, 2:05:31 PM10/10/12
to gtfs-r...@googlegroups.com
Supplemental: CATA is using the Trapeze Novus product and not the Transti Master solution
 

Ken Conaway

unread,
Oct 10, 2012, 6:29:59 PM10/10/12
to gtfs-r...@googlegroups.com
Oh. Then that might be a little bit harder although Trapeze should probably be getting more involved with creating APIs for their AVL systems like they do in Europe.

@makar

unread,
Dec 1, 2012, 12:19:12 PM12/1/12
to gtfs-r...@googlegroups.com
Hi Ken

Did you managed to solve the problem?


четверг, 11 октября 2012 г., 2:29:59 UTC+4 пользователь Ken Conaway написал:

Tack Hammer

unread,
Jan 14, 2014, 9:44:45 AM1/14/14
to gtfs-r...@googlegroups.com
Nothing new. Still looking for a anyone who had developed code to publish GTFS-RT feed from Trapeze's Novus ITS system.

Stefan de Konink

unread,
Jan 14, 2014, 9:46:39 AM1/14/14
to gtfs-r...@googlegroups.com
On Tuesday, January 14, 2014 3:44:45 PM CEST, Tack Hammer wrote:
> Nothing new. Still looking for a anyone who had developed code
> to publish GTFS-RT feed from Trapeze's Novus ITS system.

Never worked with their system, but if you can show me the code how you capture the realtime data. Then I am quite confident we can write a convertor to GTFS-RT in no time :)

Please contact me offlist if you are interested :)

Stefan

@makar

unread,
Jan 14, 2014, 9:56:42 AM1/14/14
to gtfs-r...@googlegroups.com
Hi Tack

Do you have any access to datafeed?
We've been working with different projects related to inter-format transformations. Including GTFS
Probably could help.

Kind regards,
Evgeni Makarov


вторник, 14 января 2014 г., 18:44:45 UTC+4 пользователь Tack Hammer написал:

Ramesh P

unread,
Jan 14, 2014, 2:03:06 PM1/14/14
to gtfs-r...@googlegroups.com
We are working with Trapeze in providing GTFS-RT information to Google. We use Trapeze Novus CAD/AVL system. We are COTA.
It is a Trapeze developed solution.

Sirinya Matute

unread,
Apr 17, 2014, 3:41:09 PM4/17/14
to gtfs-r...@googlegroups.com
I work in marketing and customer service for the Santa Monica Big Blue Bus and are very interested in publishing our data in the GTFS-RT format. To follow up on what Ramesh from COTA said, we just heard a presentation from Trapeze concerning their solution for publishing data in the GTFS-RT format by pulling information from TransitMaster. Should you be a Trapeze shop interested in doing something similar, I might recommend you speak with your account manager. I look forward to sharing how our process goes. Our riders are beyond deserving of this information.

Michael Smith

unread,
Apr 17, 2014, 5:54:14 PM4/17/14
to gtfs-r...@googlegroups.com
Sirinya,

Can you let folks know how much Trapeze wants to charge for this feature? My experience with Trapeze is that it would be quite an impressively large amount.

Mike


--
You received this message because you are subscribed to the Google Groups "GTFS-realtime" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gtfs-realtim...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gtfs-realtime/e5491ef6-45ab-44cf-88e8-345805e2e290%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Andrew Byrd

unread,
Apr 18, 2014, 4:49:38 AM4/18/14
to gtfs-r...@googlegroups.com
Hi everyone,

I was thinking the same thing. I've heard of people paying large sums for commercial GTFS and GTFS-RT export plugins. Do consider the option of pooling your resources with other agencies and launching / joining an open source project to produce and maintain the shared public resources needed for GTFS-RT production and distribution.

These are cases where the product needed and built by one agency can be readily used and contributed to by other agencies.

-Andrew

Barbeau, Sean

unread,
Apr 18, 2014, 9:26:51 AM4/18/14
to gtfs-r...@googlegroups.com

I completely agree with Andrew in terms of the community banding together to support GTFS and GTFS-rt export.

 

So far we’ve developed an open-source GTFS-rt exporter for Orbital/ACS/Xerox OrbCAD (SQL Server data source – should also be easily generalizable to any RDMS data source):

https://github.com/CUTR-at-USF/HART-GTFS-realtimeGenerator/wiki

 

…and we have another GTFS-rt exporter near completion for Syncromatics (REST-API data source):

https://github.com/CUTR-at-USF/bullrunner-gtfs-realtime-generator

 

OneBusAway also includes one for NextBus APIs:

https://github.com/OneBusAway/onebusaway-gtfs-realtime-from-nextbus-cli

 

For our convertors, neither we or the agency had to pay anything to the vendor to develop this software.  So, if vendors are charging licensing fees just for permission to do this, make sure they know there are competitors out there that aren’t.

 

Also, I’ve heard from at least one vendor (TransLoc) that developing GTFS-rt export themselves isn’t on their roadmap since there isn’t a demand for it from their customers.  So, make sure your vendor knows that you are interested in GTFS-rt export, and encourage other peers to do the same.

 

Sean

--
You received this message because you are subscribed to a topic in the Google Groups "GTFS-realtime" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/gtfs-realtime/mrAxFw1fNvo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to gtfs-realtim...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gtfs-realtime/5350E722.8010409%40fastmail.net.

Tack Hammer

unread,
Apr 18, 2014, 9:49:04 AM4/18/14
to gtfs-r...@googlegroups.com
Yes, it is my understanding that Trapeze has or is close to porting their Transit Master solution to work with the Novus product. But as the tenor of this thread conveys, the cost indications were getting seem absurd so we're still keeping our eye to the ground for alternatives. I'll probably may look into the open source solution just posted about by Sean.

Tack Hammer

unread,
Apr 18, 2014, 9:55:40 AM4/18/14
to gtfs-r...@googlegroups.com
Sean: Cudos for this open source development effort. That's what I was hoping would be happening. On the left you have the high priced vertical applications from vendors and that's needed internally. As you get close the public on the right, you have the Open Source free solutions like GTFS. Most major development vendors have come to realize the developing to open standards that let users take advantage of open source organically increases the value and ultimately profit for their organization. The transit industry just seems to be coming along a bit slow figuring that value formula out.

Stefan de Konink

unread,
Apr 18, 2014, 9:58:57 AM4/18/14
to gtfs-r...@googlegroups.com
On Friday, April 18, 2014 3:55:40 PM CEST, Tack Hammer wrote:
> ... vendors and that's needed
> internally. The transit industry just seems to be coming along
> a bit slow figuring that value formula out.

Just wait for a vendor that delivers you an open source fleet management
tool ;) that produces open standards. Yes, that is emerging.

Stefan

Frumin, Michael

unread,
Apr 18, 2014, 10:01:47 AM4/18/14
to gtfs-r...@googlegroups.com
OneBusAway, in particular the OneBusAwayNYC extension modules, is significant part of that -- it receives raw/simple data from the buses (location, driver login info), figures out what they are doing (i.e. integrates to the schedule), and makes the result available to customers and to dispatching tools via a number of open API's. Perhaps as Stefan said there are some forthcoming open source dispatching tools that could use that info for dispatching and management purposes.



-----Original Message-----
From: gtfs-r...@googlegroups.com [mailto:gtfs-r...@googlegroups.com] On Behalf Of Stefan de Konink
Sent: Friday, April 18, 2014 9:59 AM
To: gtfs-r...@googlegroups.com
--
You received this message because you are subscribed to the Google Groups "GTFS-realtime" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gtfs-realtim...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gtfs-realtime/2dcd4316-d116-431b-84ea-98211af5b4c4%40konink.de.

Sohail Hussaini

unread,
Jul 25, 2014, 7:01:22 PM7/25/14
to gtfs-r...@googlegroups.com

I am trying to connect to Novus CAD server. Does anyone know of what unicode format it uses. It connects but when I send a startup message string it does not recognize it. I already tried ASCII string it did not work. Unicode does not seem to work sofar. Is it 8, 16, or 32 bit unicode ? Would byte order matter ?

Sohail Hussaini

unread,
Jul 25, 2014, 7:07:30 PM7/25/14
to gtfs-r...@googlegroups.com
I am trying to connect to Novaus CAD server. Do you know what string format it uses ? The socket connection is successful but when I send the startup message it does not recognize it. I already tried ASCII string. Unicode has not worked sofar. Is it 8, 16, or 32 bit unicode. Does byte order matter. I am sending from a linux device.
Reply all
Reply to author
Forward
0 new messages