I have GPX trails of vehicles/bikes of a particular city. Meaning, lat/lon, timestamp of bike trails from where a particular bike started and ended at different hours of the day. I have sets of these trails for different bikes roaming around the city.
Now, I want to know if it is possible with PostGIS+pgRouting+any other combination to know how much time it takes to go from point A to point B in a particular range of hours by using the data I already have. Assume I have enough data for the city in terms of bike trails.
I do not want to use OSM data. But, if it is required, I am fine with using it.
Sample data:
أكثر...
Now, I want to know if it is possible with PostGIS+pgRouting+any other combination to know how much time it takes to go from point A to point B in a particular range of hours by using the data I already have. Assume I have enough data for the city in terms of bike trails.
I do not want to use OSM data. But, if it is required, I am fine with using it.
Sample data:
BikeID, Lat, Lon, timeStamp
1234,13.9845583,77.6052433,1431849998287
1234,13.9846133,77.6052366,1431850069237
1234,13.9846333,77.6051566,1431850102429
95,13.9845683,77.6050683,1431850138314
95,13.9845683,77.6050683,1431850172455
1234,13.9845583,77.6052433,1431849998287
1234,13.9846133,77.6052366,1431850069237
1234,13.9846333,77.6051566,1431850102429
95,13.9845683,77.6050683,1431850138314
95,13.9845683,77.6050683,1431850172455
أكثر...