Information and reviews for rail-trails in the United States
railtrails
Data frame with columns
Name of rail trail
distance (miles)
surface material
trail category
mean review rating
text description of trail
number of reviews
list column with a vector of reviews
the latitude for the trailhead (from Google Maps search of the trail's name)
the longitude for the trailhead (from Google Maps search of the trail's name)
https://www.traillink.com/
railtrails#> # A tibble: 3,846 x 11 #> state name distance surface category mean_review description n_reviews #> <chr> <chr> <dbl> <chr> <chr> <int> <chr> <chr> #> 1 AK Chase… 14.0 Dirt, … Rail-Tr… 4 "\r\n … 1 Reviews #> 2 AK Tony … 11.0 Asphalt Rail-Tr… 5 "The Tony Know… 5 Reviews #> 3 AK Bird … 13.0 Asphalt Rail-Tr… 5 "\r\n … 3 Reviews #> 4 AK Campb… 7.50 Asphal… Greenwa… 5 "\r\n … 3 Reviews #> 5 AK Goose… 1.50 Asphal… Greenwa… 0 "\r\n … 0 Reviews #> 6 AK Homer… 4.00 Asphalt Greenwa… 5 "On the southe… 1 Reviews #> 7 AK Lanie… 3.90 Asphal… Greenwa… 3 "The Lanie Fle… 1 Reviews #> 8 AK Palme… 6.10 Gravel Rail-Tr… 0 "As its name s… 0 Reviews #> 9 AK Ship … 2.60 Asphalt Rail-Tr… 4 " \r\nShip Cre… 1 Reviews #> 10 AL Chief… 33.0 Asphalt Rail-Tr… 5 "In northeast … 77 Revie… #> # ... with 3,836 more rows, and 3 more variables: raw_reviews <list>, #> # lat <dbl>, lng <dbl># to expand vector of review ratings in raw_reviews column: library(tidyr) railtrails <- railtrails %>% unnest(raw_reviews)