A project I’m currently working on utilises a document oriented database to store static transit data. Currently I’m building an algorithm that takes the static GTFS table data, reshuffles in to suit my purposes, and ultimately updates the database.
So far, it looks like the trip data and stop time data are ordered to match each other. That is to say, the first row of trip data file has its stop times in the first few rows of the stop time data file, for example. (probably easier to follow a visual example: Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.)
Is this intentional? (I’m hoping yes, as it would greatly reduce the amount of code needed, while also keeping the amount of processing needed to a minimum)