I'd like to know which tool works best for connecting each origin and destination of a bikeshare trip. I have splitted the large csv file into months but they still include at least 200.000 rows each. The csv file has information about Object ID, geographical position of the origin station and destination station, and the belonging times. Using an OD cost matrix firstly runs for hours and secondly will connect all the points, right?
Probably I am thinking way to complicated. My aim is to produce a flow map along the streets which shows which areas are most used by the bikeshare system.
Thanks in advance!