Comments (2)
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.
from dtd2mysql.
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.
from dtd2mysql.
Related Issues (20)
- max_old_space_size too small and not configurable? HOT 6
- dtd2mysql --timetable Error: Column count doesn't match value count at row 1 HOT 3
- --gtfs-zip error failing to build files and zip file HOT 5
- --fares-clean error (not sure if vital) HOT 1
- Error extracting Fare Data HOT 5
- Setting environment variables. HOT 17
- network_flow_restriction query filters out clusters HOT 4
- Filename mismatch HOT 6
- Data too long for log filename HOT 1
- Replacement bus GTFS route_type HOT 2
- Critical problem with route_type. Bus and rail trips under one route HOT 9
- Invalid or unsupported zip format HOT 6
- Incorrect schedules for ~1200 trips (associations) HOT 10
- list both stations and platforms in the GTFS output HOT 1
- TOC from Z-records aren't imported
- GTFS produced by timetable revision 930 contains invalid calendar HOT 1
- Joins at the beginning of the route should not be processed HOT 6
- Implement train splitting / joining as GTFS transfers HOT 3
- CR record in MCA file isn't handled HOT 4
- What is the use of addLateNightServices? HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dtd2mysql.