Process stop data into a table

[yayen-lin]

Continue of #22.

Description

Manually process the data into stop sequence data for easier access.

Example data table

route number	stop_id	stop_lat	stop_lon	direction	distance_from_last_stop	travel_time_from_last_stop	number_of_boarding
2	1234	56.78	90.12	S	0.12	12	50
2	5678	90.12	34.56	N	0.34	34	100

Columns to consider to be added:

• Frequency

Data storage method

1. One file for each route, example file name: Route#.csv

• Saves file loading time

2. One file for all routes

• Increases loading time, in-program sorting & parsing

[RaenonX]

No Q&A format. Use imperative tones, and list all the tasks as concise as possible. Don't use/spam "!" and "?" in issues. We're formally talking about things, hence there should not be any emotional tone inside.

I also don't think I quite understand what you mean here, so here's my example (and I think an issue should look like) of the work for this subtask.

And, label is a categorizing thing. You shouldn't say what this issue is, because if you have 100000 issues, and 1000 of them are main tasks, you'll have 1000 labels, which is ineffective IMO. Also, labels CAN'T track if the main issue is completed. Use issue mentioning instead for linking the issues.

I am modifying all of your original content but keeping the original at below for your reference.

---

Solution 1

for more info #22

• First

  • We need to split all stops of a route by its direction
  • e.g. these stops are from southwest to northeast, and others are from northeast to southwest
  • so we'll have 2 tables for 2 directions

• Second

  • Sort the stops of a route by setting one starting point (maybe one end or another depends on the direction we're looking at) and sort them by distances
  • this approach doesn't yield a correct result so we need to manually correct them
  • this link has information about the stop order of all routes in Madison
    • if someone knows how to extract the data it'd save us a lot of work!! :))

Where to put the sorted data?

• come discuss in #26 !