Creating Travel time for road segements

2017-09-19 11:08:48

I would like to calculate travel time by bicycle in postgis. Following this example from the book QGIS becoming a GIS power user, the calculation is in walking distance. How can I calculate if bicycle travel means are used.

ALTER TABLE newark_osm ADD COLUMN traveltime_min float8;

UPDATE newark_osm SET traveltime_min = length_m / 6000.0 *



FROM pgr_drivingdistance('SELECT id, source, target,

traveltime_min as cost FROM newark_osm'::text, 1,

100000::double precision, false, false) di (seq, id1,

id2, cost)

JOIN newark_osm rd ON di.id2 =;