Calculate the travel time on foot between two coordinates with R and OpenStreetMap (OSM)

Question

I'm trying to calculate the time on foot by two coordinates with OpenStreetMap.

I'm using this dataset: https://github.com/JayScribes/Geocode-Distance/blob/main/NYC%20Bike%20Share%20Data.csv

And this is my code:

library(readr)
NYC_Bike_Share_Data <- read_csv("NYC Bike Share Data.csv")
View(NYC_Bike_Share_Data)

library(osrm)
osrm_conn <- osrm::osrmTable(profile = "foot-walking")
 
origen<-c(NYC_Bike_Share_Data$ss_lat,NYC_Bike_Share_Data$sslong)
destino<-c(NYC_Bike_Share_Data$es_lat,NYC_Bike_Share_Data$es_long)


duracion <- osrmTable(osrm_conn, loc = c(origen, destino))$durations[1]

Output:

Error: "loc" should be a data.frame or a matrix of coordinates, an sfc POINT object or an sf POINT object.

Dave2e · Accepted Answer · 2023-11-03 21:07:40Z

0

Your definitions are incorrect, you are making vectors and not data frames/matrixes using the c() function.
Also, it is convention to list longitude as the first column followed by latitude.

Note: orsm limits calls to less than 1000 points, so you will need to subdivide your dataset.

The following should work for you:

NYC_Bike_Share_Data <- read.csv("NYC Bike Share Data.csv")

library(osrm)

origen<-NYC_Bike_Share_Data[ ,c("ss_long", "ss_lat")]
destino<-NYC_Bike_Share_Data[ ,c("es_long", "es_lat")]

duracion <- osrmTable(src = origen, dst =destino,  osrm_profile = "foot", measure = "duration")

This is resulting is a matrix instead of a single output value for each row. Also the matrix is asymmetric thus going from A to B is different than going from B to A. I am not sure if this is expected. You will need to extract the diagonal from this matrix for your final answer.

diag(duracion$durations)

edited Nov 3, 2023 at 21:07

answered Nov 2, 2023 at 22:31

Dave2e

24.3k18 gold badges46 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Amc Over a year ago

I have a problem with this line "osrm_conn <- osrm::osrmTable(profile = "foot-walking")".Specifically: "Error in osrm::osrmTable(profile = "foot-walking") : unused argument (profile = "foot-walking")"

Dave2e Over a year ago

@Amc, I am not sure where this came from but it was in your code osrm::osrmTable(profile = "foot-walking"). I deleted it now and fixed a typo in the last line. orsmTable() is not behaving as expected.

Collectives™ on Stack Overflow

Calculate the travel time on foot between two coordinates with R and OpenStreetMap (OSM)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related