Brussels parks — Google review corpus

Load data
library(leaflet)
library(htmltools)

cnt   <- read.csv("reviews/REVIEW_COUNTS_BY_PARK_v4.csv", stringsAsFactors = FALSE, fileEncoding = "UTF-8")
parks <- read.csv("Brussels_Parks_mapping_data.csv", stringsAsFactors = FALSE, fileEncoding = "UTF-8")
miss  <- read.csv("missing_green_spaces.csv", stringsAsFactors = FALSE, fileEncoding = "UTF-8",
                  colClasses = c(google_place_id = "character", postcode = "character"))

# coordinates and type: CSV parks
a <- data.frame(id = parks$google_place_id_resolved, muni = parks$municipality,
                lat = parks$latitude, lon = parks$longitude,
                type = ifelse(parks$is_playground_api == "yes", "Playground", "Park"))

# inventory-gap places, largest site per place ID
g <- miss[miss$google_place_id != "", ]
g <- g[order(-g$area_ha), ]
g <- g[!duplicated(g$google_place_id), ]
pc <- c("1000" = "Bruxelles", "1020" = "Laeken", "1030" = "Schaerbeek", "1040" = "Etterbeek",
        "1050" = "Ixelles", "1060" = "Saint-Gilles", "1070" = "Anderlecht", "1080" = "Molenbeek-Saint-Jean",
        "1081" = "Koekelberg", "1082" = "Berchem-Sainte-Agathe", "1083" = "Ganshoren", "1090" = "Jette",
        "1120" = "Neder-Over-Heembeek", "1130" = "Haren", "1140" = "Evere", "1150" = "Woluwe-Saint-Pierre",
        "1160" = "Auderghem", "1170" = "Watermael-Boitsfort", "1180" = "Uccle", "1190" = "Forest",
        "1200" = "Woluwe-Saint-Lambert", "1210" = "Saint-Josse-ten-Noode")
b <- data.frame(id = g$google_place_id, muni = unname(pc[sub("/.*", "", g$postcode)]),
                lat = g$lat, lon = g$lon,
                type = ifelse(grepl("playground", g$google_types), "Playground", "Park"))

# added by hand (Google Places location)
d <- data.frame(id   = c("ChIJA--8tNHFw0cRL7ksOmMLBCE", "ChIJdxn6WunQw0cRUbMmVMit51g"),
                muni = c("Saint-Gilles", "La Hulpe"),
                lat  = c(50.828992, 50.737948), lon = c(4.349092, 4.472079), type = "Park")

xy <- rbind(a, b, d)
xy <- xy[!duplicated(xy$id), ]
stopifnot("place IDs without coordinates" = all(cnt$GoogleID %in% xy$id))
pl <- merge(cnt, xy, by.x = "GoogleID", by.y = "id")

192,667 Google reviews for 243 parks and playgrounds (36% with text). Symbol size shows the number of reviews (five manual classes).

Map
fmt <- function(v) formatC(v, format = "d", big.mark = ",")

# classes (manual breaks)
brks <- c(0, 100, 250, 1000, 5000, Inf)
rad  <- c(4, 7, 11, 16, 23)                         # px, one per class
labs <- c("1–100", "101–250", "251–1,000", "1,001–5,000", "> 5,000")
pl$radius <- rad[cut(pl$n_reviews, brks, labels = FALSE, include.lowest = TRUE)]
pl <- pl[order(-pl$n_reviews), ]                    # large first, small on top

# fill by type
cols <- c(Park = "#2E7D32", Playground = "#EF8A17")

# popup and hover label
pl$reg <- ifelse(pl$region == "inside_brussels", "Brussels-Capital Region", "Outside Brussels-Capital Region")
pl$popup <- sprintf(
  "<b>%s</b><br>%s<br>%s<br>%s<br>Reviews: <b>%s</b> (%s with text)<br>%s–%s<br><a href='https://www.google.com/maps/place/?q=place_id:%s' target='_blank'>Open in Google Maps</a>",
  htmlEscape(pl$ParkName), ifelse(is.na(pl$muni) | pl$muni == "", "—", htmlEscape(pl$muni)), pl$reg, pl$type,
  fmt(pl$n_reviews), fmt(pl$n_with_text), pl$first, pl$last, pl$GoogleID
)
pl$label <- paste0(pl$ParkName, " (", fmt(pl$n_reviews), ")")

# size legend
size_legend <- function(r, labs, title) {
  d <- 2 * max(r) + 2
  rows <- paste0(
    "<div style='display:flex;align-items:center;margin:3px 0'>",
    "<span style='width:", d, "px;display:flex;justify-content:center'>",
    "<span style='width:", 2 * r, "px;height:", 2 * r,
    "px;border-radius:50%;border:1px solid #000;background:rgba(128,128,128,.35)'></span></span>",
    "<span style='margin-left:6px'>", labs, "</span></div>",
    collapse = ""
  )
  HTML(paste0("<b>", title, "</b>", rows))
}

leaflet(pl, width = "100%", height = "85vh") |>
  addTiles("https://mt1.google.com/vt/lyrs=m&x={x}&y={y}&z={z}",    # Google roadmap
           attribution = "Map data &copy; Google", group = "Google roadmap") |>
  addTiles("https://mt1.google.com/vt/lyrs=y&x={x}&y={y}&z={z}",    # Google hybrid
           attribution = "Imagery &copy; Google", group = "Google hybrid") |>
  setView(lng = 4.37, lat = 50.84, zoom = 12) |>
  addCircleMarkers(
    lng = ~lon, lat = ~lat, radius = ~radius, group = ~type,
    color = "#000", weight = 1, opacity = 0.9,
    fillColor = ~unname(cols[type]), fillOpacity = 0.55,
    popup = ~popup, label = ~label,
    labelOptions = labelOptions(direction = "top", textsize = "12px")
  ) |>
  addControl(size_legend(rad, labs, "Google reviews"), position = "bottomright") |>
  addLegend("bottomright", colors = unname(cols), labels = names(cols), opacity = 0.7, title = "Type") |>
  addLayersControl(baseGroups = c("Google roadmap", "Google hybrid"), overlayGroups = names(cols),
                   options = layersControlOptions(collapsed = FALSE)) |>
  addScaleBar("bottomleft", options = scaleBarOptions(imperial = FALSE))