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.
BikeID, Lat, Lon, timeStamp