[Open-transport] DIVA to GTFS transformation tools

Sun Nov 9 14:06:41 UTC 2014

On 09.11.2014 14:57, Thomas wrote:

> Did we (Stichting OpenGeo) ever tell about regularly receiving DINO data
> from the AVV (Aachen) ? I build a importer for that for our
> integration-platform[1] which exports to GTFS[2]

Nope, you didn't ;D

I have never laid hands on a DINO feed, but, judging from your code, it 
appears to be quite different from the DIVA data I've seen so far. As 
mentioned in the README.md, the results of my A-beautiful-mind-like 
staring at columns and trying to make sense of them are included in my 
thesis (still working on publishing it as ePub to make hotlinking to 
sections easier).

To give you an impression of the data layout, this is a typical route 
definition file in DIVA:

``` snip
FORMAT002009000000000023 "\\DING-ULM2\\Doe" 27.03.13  14:49:220 
BW00000000000000000000
EMYYYYYYYYYq08YY0YYYYNY
FW012H105010581048105910601061107910781087116012411240
WdH    S   S
WaH
WzH            000000000
WlH
MSH01    01    01        01
STH0120001    0011    0021    0031    0041    0051    0061    0071 
0081    0091    0102    0112
ZZH
PFH  02
FTH00001120002*0601020504020101N0265000 -099900000000000000
FTH00002120002*0601020607020101N0265000 -099900000000000000
FAH00515000000001051510000110         0              000000000 
0000150033000150100000000000026415001-0999N   0             000
FAH00615000000001061510000110         0              000000000 
0000150048000150100000000000026415001-0999N   0             000
FAH00725000000001072510000210         0  N           000000000 
0000150018000150100000000000026415001-0999N   0             000
FAH00825000000001082510000110         0  N           000000000 
0000150025000150100000000000026415001-0999N   0             000
FAH00925000000001092510000110         0  N           000000000 
0000150057000150100000000000026415001-0999N   0             000
UEHO1 000000 "" 08126L03       Y00000[...]
UEHO2 000000 "" 08245L03       N00000[...]
EEH "Universität Süd" 0051500000000000000_00000000000000000000
EEH "Universität Süd" 0061500000000000000_00000000000000000000
EEH "Universität Süd" 0072500000000000000_00000000000000000000
EEH "Universität Süd" 0082500000000000000_00000000000000000000
EEH "Universität Süd" 0092500000000000000_00000000000000000000
BUH "15" "bus" "SWU_Verkehr" "Willy-Brandt-Platz - Universität Süd" "" 
"" "" 11111600N ""N  ""
LAH00000000000010000000012
La000001050000000000
La000001058000000000
La000001048000000000
La000001059000000000
La000001060000000000
La000001061000000000
La000001079000000000
La000001078000000000
La000001087000000000
La000001160000000000
La000001241000000000
La000001240000000000
``` snap

regards,
-stk