Jannis R

Mit dem DELFI-Datensatz vom 21.03.2022: ```sql SELECT COUNT(*) FROM ( SELECT stop_id, stop_name, st_y(stop_loc::geometry) as stop_lat, st_x(stop_loc::geometry) as stop_lon FROM stops WHERE location_type = 'stop' -- 0 AND stop_id SIMILAR...

Mit dem DELFI-Datensatz vom 21.03.2022: ```sql WITH stops AS NOT MATERIALIZED ( SELECT *, st_y(stop_loc::geometry) as stop_lat, st_x(stop_loc::geometry) as stop_lon FROM stops ) SELECT a.parent_station, a.stop_id, a.stop_name, b.parent_station, b.stop_id, b.stop_name,...

Toll wäre beides: Eine permanente, stabile URL für jede Version des Datensatzes (z.b. `https://static.opendata-oepnv.de/delfi/gtfs-2020-04-01.zip`), sowie eine für den jeweils aktuellsten Datensatz (z.b. `https://static.opendata-oepnv.de/delfi/gtfs-latest.zip`).

von https://github.com/mfdz/GTFS-Issues/issues/29#issuecomment-599261012: > Bei Einrichtung der permanenten URL sollte zudem darauf geachtet werden, dass der Server die Abfragemethode `HEAD` zum reinen Abruf von Headern unterstützt [...], so dass abrufende Anwendungen...

I implemented a temporary workaround: `https://delfi-gtfs-url.now.sh/api/latest` redirects to the latest zip URL that returns `2xx`.

> I implemented a temporary workaround: `https://delfi-gtfs-url.now.sh/api/latest` redirects to the latest zip URL that returns `2xx`. The workaround is broken because the download doesn't work without a login cookie anymore....

@juliuste has built the workaround's successor: https://github.com/juliuste/opendata-oepnv/blob/main/readme.md

> I would like to run the import publicly visible, for example on GitHub Actions, in order to enable more people to fix things without having access to the server....

cc @osm-ToniE

I'm the maintainer of the underlying [`db-hafas` lib](https://www.npmjs.com/package/db-hafas), which is a bit outdated but should work. Can you access error logs or investigate what's going on?