[Open-transport] SBB - HAFAS --> GTFS Conversion

Mon Apr 28 13:43:50 UTC 2014

Your approach sounds promising. We did some experiments of combining 
trips with the exact same type and the exact same station-route into 
GTFS routes, but this still left out those trips that had slightly 
different station-routes (for example, bus lines with a "main" route and 
an extended route that is only served every hour or so).

Currently, our main focus is not on converting the HAFAS-feed to a 100% 
"beautiful" GTFS feed but on developing a tool that gets a correct 
shapes.txt from geospatial data.

Patrick
-- 
web www.geops.de
rss www.geops.de/blog/feed
follow www.twitter.com/geops

On 28/04/14 15:27, Stefan de Konink wrote:
> On Mon, 28 Apr 2014, Patrick Brosi | geOps wrote:
>
>> As Stefan pointed out correctly, frequency-based HAFAS connections are
>> skipped and, most importantly, each HAFAS-trip maps to a GTFS trip
>> _and_ a GTFS route. This is because we could not yet find a reliable
>> mechanism to create "real" GTFS routes without creating id collisions.
>
> We have some ideas about this. But I agree this is an hairy issue.
>
> As you may have observed the 'unique key' per Z-line isn't unique either
> (because is unique in combination with the bitfeld), but must be unique
> for GTFS, hence requires a new id.
>
> You can do a distinct on routes, which we will be doing. But it requires
> a smart reverse mapping (for example with a CTE aggregation).
>
> Stefan