vlad/TIMRRN
1
0
Fork 0
Code Issues 7 Pull requests Projects Releases Packages Wiki Activity Actions

Filter out GTFS data that does not travel to Timisoara #1

New issue
Open
opened 2026-05-06 03:23:46 +02:00 by vlad · 3 comments
vlad commented 2026-05-06 03:23:46 +02:00
Owner
Copy link

The GTFS files include transit routes for all of Romania, which need to be limited to just routes going to-from-through Timisoara

The GTFS files include transit routes for all of Romania, which need to be limited to just routes going to-from-through Timisoara
vlad self-assigned this 2026-05-06 03:23:46 +02:00
vlad commented 2026-05-11 13:37:06 +02:00
Author
Owner
Copy link

Most of Romanian Transit Traffic going through/to Timisoara flow either through Bucharest or Iasi, with a couple notable exceptions around Timis County and International routes (of which there is only 1)

Most of Romanian Transit Traffic going through/to Timisoara flow either through Bucharest or Iasi, with a couple notable exceptions around Timis County and International routes (of which there is only 1)
vlad commented 2026-05-11 13:38:11 +02:00
Author
Owner
Copy link

@vlad wrote in #1 (comment):

Most of Romanian Transit Traffic going through/to Timisoara flow either through Bucharest or Iasi, with a couple notable exceptions around Timis County and International routes (of which there is only 1)

can be useful when getting routeIds, since, if we prune the routes to only have the ones going to Timisoara, we can store routeIds on AppInit

@vlad wrote in https://git.outnight.eu/vlad/TIMRRN/issues/1#issuecomment-34: > Most of Romanian Transit Traffic going through/to Timisoara flow either through Bucharest or Iasi, with a couple notable exceptions around Timis County and International routes (of which there is only 1) can be useful when getting routeIds, since, if we prune the routes to only have the ones going to Timisoara, we can store routeIds on AppInit
vlad commented 2026-05-15 19:13:47 +02:00
Author
Owner
Copy link

Database file now has foreign key and on cascade delete constraints added; Filtering out the data shouldn't be difficult since we can look through all stops where stop_id in stop_times (matching trip_id) and seeing if Timisoara Nord/Est/Sud is on that route.

Database file now has foreign key and on cascade delete constraints added; Filtering out the data shouldn't be difficult since we can look through all stops where stop_id in stop_times (matching trip_id) and seeing if Timisoara Nord/Est/Sud is on that route.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
No results found.
Labels
Clear labels   
bug
Something is not working

  
duplicate
This issue or pull request already exists

  
enhancement
New feature

  
help wanted
Need some help

  
invalid
Something is wrong

  
question
More information is needed

  
wontfix
This won't be fixed

No labels
bug
duplicate
enhancement
help wanted
invalid
question
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
vlad
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Blocks
#3 Create a speed estimation algorithm using GTFS data
vlad/TIMRRN
Reference
vlad/TIMRRN#1
No description provided.