Some public stops/stations are missing in GTFS as they're missing in physical_station table

[planarnetwork]

Some public stops/stations are missing in GTFS as they're missing in physical_station table

[mk-fg]

Actually, this L35246 example illustrates another problem, which probably should be considered when fixing this one.

Joined CIF schedule / stop_times entries currently processed by the script for L35246 are:

  L35246   23167 P 2017-05-22 2017-12-08 12345.. A ZTU 00:02 00:02 T
  L35246   23167 P 2017-05-22 2017-12-08 12345.. A GUN 00:05 00:05 T
  L35246   23167 P 2017-05-22 2017-12-08 12345.. A KWG 00:08 00:08 T
  ...

While actual entries in these tables are:

  L35246   23167 P 2017-05-22 2017-12-08 12345.. A ZUM --:-- 22:43 TB
  L35246   23167 P 2017-05-22 2017-12-08 12345.. A ZTU 00:02 00:02 T
  L35246   23167 P 2017-05-22 2017-12-08 12345.. A GUN 00:05 00:05 T
  L35246   23167 P 2017-05-22 2017-12-08 12345.. A KWG 00:08 00:08 T
  ...

Note how including that first entry effectively changes service dates!

So condition in aforementioned "massive query" that gets schedule/stop times should not have crs_code IS NOT NULL in it, as that might prevent script from ever processing that first stop, and set wrong date for GTFS trip (like it does here), regardless of whether such stop will end up in GTFS trip or get discaded.

[linusnorton]

Doing a quick query to check for departure stations with no CRS only returns 12 services starting from LRDDEAC which is a depot. Given we understand TB to mean that passengers can get on or off and LRDDEAC is a depot I think we can skip it. I won't add any extra checks for days etc at this point but I will add that extra join.... because you can never have enough joins.