Collecting POI data using Google API

R Code Steps

  1. Loading all the necessary R packages that will be used throughout the workflow
library(tidycensus)           # for accessing and working with U.S. Census Bureau data
library(sf)                   # for handling spatial data in simple features format
library(tmap)                 # for creating thematic maps and spatial visualizations
library(jsonlite)             # for reading and writing JSON data
library(tidyverse)            # a collection of packages like dplyr for data wrangling and visualization
library(httr)                 # for making HTTP requests to access APIs
library(reshape2)             # for reshaping datasets (wide to long format and vice versa)
library(here)                 # for managing project file paths in a reproducible way
library(knitr)                # for enabling integration of R code and outputs into documents
  1. Accessing census data and geting block groups for Scalding county, GA
tidycensus::census_api_key(Sys.getenv('CENSUS_API'))
## To install your API key for use in future sessions, run this function with `install = TRUE`.
bg <- suppressMessages(
  suppressWarnings(
    tidycensus::get_acs(geography = "block group", 
                      state = "GA",
                      county = c("Spalding"),
                      variables = c(hhincome = 'B19013_001'),
                      year = 2023,
                      survey = "acs5", 
                      geometry = TRUE, 
                      output = "wide") 
)
)
  1. Extracting and visualizing the block groups intersecting with City of Griffin boundary
griffin <- tigris::places('GA') %>% filter(NAME == 'Griffin')
bg_griffin <- bg[griffin,]
bg_griffin %>% head() %>% knitr::kable()
GEOID NAME hhincomeE hhincomeM geometry
2 132551607013 Block Group 3; Census Tract 1607.01; Spalding County; Georgia 71549 4671 MULTIPOLYGON (((-84.3203 33…
3 132551604021 Block Group 1; Census Tract 1604.02; Spalding County; Georgia NA NA MULTIPOLYGON (((-84.29188 3…
4 132551612012 Block Group 2; Census Tract 1612.01; Spalding County; Georgia 90104 33282 MULTIPOLYGON (((-84.29767 3…
5 132551607012 Block Group 2; Census Tract 1607.01; Spalding County; Georgia 22059 13331 MULTIPOLYGON (((-84.2921 33…
6 132551603001 Block Group 1; Census Tract 1603; Spalding County; Georgia 52830 13430 MULTIPOLYGON (((-84.26342 3…
7 132551608003 Block Group 3; Census Tract 1608; Spalding County; Georgia 41906 6306 MULTIPOLYGON (((-84.28829 3…
tmap_mode("view")

tm_shape(bg_griffin) + tm_borders(lwd = 1) +
  tm_shape(griffin) + tm_polygons(col = 'red', alpha = 0.5)
  1. Define function for calculating centroid coordinates and approximate radius for Block Groups: For each block group in Griffin, the geographic centroid and an approximate radius were computed. Polygons were projected for accurate distance measurement, the radius was calculated from the bounding box corner to the centroid, and centroids were transformed back to geographic coordinates for mapping and spatial analysis.
gcs_id <- 4326
pcs_id <- 32616

getXYRadius <- function(polygon, gcs_id, pcs_id){
  if (st_crs(polygon) != st_crs(pcs_id)){
    polygon <- polygon %>% st_transform(pcs_id)
  }
  
  bb <- st_bbox(polygon)
  bb_corner <- st_point(c(bb[1], bb[2])) %>% st_sfc(crs = pcs_id)
  bb_center <- bb %>% st_as_sfc() %>% st_centroid()
  r <- st_distance(bb_corner, bb_center)
  bb_center <- bb_center %>% st_transform(gcs_id)
  xy <- bb_center %>% st_coordinates() %>% as.vector()
  lon_lat_radius <- data.frame(x = xy[1],
                               y = xy[2],
                               r = r)
  return(lon_lat_radius)
}


bg_griffin_xyr <- data.frame(x = numeric(nrow(bg_griffin)),
                             y = NA,
                             r = NA)

for (i in 1:nrow(bg_griffin)){
  bg_griffin_xyr[i,] <- bg_griffin[i, ] %>%
    getXYRadius(gcs_id = gcs_id,
                pcs_id = pcs_id)
}
  1. Bounding Box & Fishnet Grid Generation: A regular grid of points (fishnet) was created over Griffin’s bounding box in projected coordinates. The city polygon was divided into equal intervals along x and y axes, grid points were converted to geographic coordinates, and each point was assigned a radius equal to half the cell diagonal. Buffers around these points were visualized to ensure full coverage of the city area.
griffin_bb <- griffin %>% st_transform(pcs_id) %>% st_bbox()
west <- griffin_bb[1]
east <- griffin_bb[3]
south <- griffin_bb[2]
north <- griffin_bb[4]

fishnet_n <- 4
dist <- abs(east - west)/fishnet_n

fish_x <- seq(from = west, to = east, by = dist)
fish_y <- seq(from = south, to = north, by = dist)

fishnet <- expand.grid(fish_x, fish_y) %>%
  rename(x = Var1, y = Var2) %>%
  st_as_sf(coords = c('x', 'y'), crs = pcs_id)

fishnet$x <- fishnet %>% st_transform(gcs_id) %>% st_coordinates() %>% .[,1]
fishnet$y <- fishnet %>% st_transform(gcs_id) %>% st_coordinates() %>% .[,2]
fishnet$r <- dist*(2^(1/2)/2) 

fishnet %>% 
  st_buffer(dist = .$r) %>% 
  tm_shape() +
  tm_polygons(alpha = 0.1, col = 'red') +
  tm_shape(griffin) + tm_borders(lwd = 2)
  1. Requesting Google API Data & parsing JSON into Data Frame: POI data for pharmacies and drugstores were collected using the Google Places Nearby Search API. The request included the required 8 fields—places.id, places.displayName, places.formattedAddress, places.location, places.types, places.priceLevel, places.rating, and places.userRatingCount. The API response was parsed into a structured data frame.
library(httr)

google_api_key <- Sys.getenv("GOOGLE_API")
lat <- 33.247602 
lon <- -84.270891 
radius <- 1609.34 

endpoint <- "https://places.googleapis.com/v1/places:searchNearby" 

body <- list(
  includedTypes = list("drugstore","pharmacy"),
  locationRestriction = list(
    circle = list(
      center = list(latitude = lat, longitude = lon),
      radius = radius
    )
  )
)

resp <- POST(
  endpoint,
  add_headers(
    "Content-Type" = "application/json",
    "X-Goog-Api-Key" = google_api_key,
    "X-Goog-FieldMask" = "places.displayName,places.formattedAddress,places.types"),
  body = body,
  encode = "json"
)
print(resp)
## Response [https://places.googleapis.com/v1/places:searchNearby]
##   Date: 2025-09-18 22:33
##   Status: 200
##   Content-Type: application/json; charset=UTF-8
##   Size: 4.7 kB
## {
##   "places": [
##     {
##       "types": [
##         "drugstore",
##         "convenience_store",
##         "food_store",
##         "health",
##         "food",
##         "clothing_store",
## ...
data <- content(resp, as="text")

data <- jsonlite::fromJSON(data, flatten = T) %>% as.data.frame() %>% knitr::kable()

knitr::kable(names(data))
knitr::kable(data)
x
|places.types |places.formattedAddress |places.displayName.text |places.displayName.languageCode |
|:———————————————————————————————————————————————————————————————————–|:—————————————|:—————————————-|:——————————-|
|drugstore , convenience_store, food_store , health , food , clothing_store , point_of_interest, store , establishment |405 S Hill St, Griffin, GA 30224, USA |Walgreens |en |
|convenience_store, gift_shop , discount_store , grocery_store , food_store , drugstore , health , food , point_of_interest, store , establishment |821 W Taylor St, Griffin, GA 30223, USA |Dollar General |en |
|pharmacy , gift_shop , consultant , health , point_of_interest, store , establishment |566 S 8th St, Griffin, GA 30224, USA |Wynn’s Pharmacy |en |
|pharmacy , health , point_of_interest, store , establishment |222 W Poplar St, Griffin, GA 30224, USA |U Save It Pharmacy |en |
|pharmacy , health , point_of_interest, store , establishment |622 S 8th St, Griffin, GA 30224, USA |Hospital Discount Drugs |en |
|pharmacy , health , point_of_interest, store , establishment |315 S 8th St, Griffin, GA 30224, USA |David’s Drug & Surgical |en |
|pharmacy , health , point_of_interest, store , establishment |405 S Hill St, Griffin, GA 30224, USA |Walgreens Pharmacy |en |
|pharmacy , drugstore , health , point_of_interest, store , establishment |131 W Taylor St, Griffin, GA 30223, USA |Claxton Hobbs Pharmacy |en |
|pharmacy , health , point_of_interest, store , establishment |322 S 6th St, Griffin, GA 30224, USA |Medication Expert |en |
|pharmacy , health , point_of_interest, store , establishment |566 S 8th St, Griffin, GA 30224, USA |Bartlett Crystal B |en |
|pharmacy , health , point_of_interest, store , establishment |405 S Hill St, Griffin, GA 30224, USA |COVID-19 Drive-Thru Testing at Walgreens |en |
|pharmacy , health , point_of_interest, store , establishment |131 W Taylor St, Griffin, GA 30223, USA |Peeler Michelle |en |
|pharmacy , health , point_of_interest, store , establishment |566 S 8th St, Griffin, GA 30224, USA |Duncan Annette W |en |
|pharmacy , health , point_of_interest, store , establishment |566 S 8th St, Griffin, GA 30224, USA |Bennett Clyde |en |
nearbySearch <- function(lat, lon, radius, types_vec, fieldmask_vec, google_api_key){
  
  endpoint <- "https://places.googleapis.com/v1/places:searchNearby" 
  
  body <- list(
    includedTypes = as.list(types_vec),
    locationRestriction = list(
      circle = list(
        center = list(latitude = lat, longitude = lon),
        radius = radius
      )
    ),
    rankPreference = "DISTANCE" 
  )
  
  resp <- POST(
    endpoint,
    add_headers(
      "Content-Type" = "application/json",
      "X-Goog-Api-Key" = google_api_key,
      "X-Goog-FieldMask" = paste(fieldmask_vec, collapse = ",")),
    body = body,
    encode = "json"
  )
  
  data <- content(resp, as="text") %>% 
    jsonlite::fromJSON(flatten = T) %>% 
    as.data.frame()
  
  if (nrow(data) == 20){
    print("WARNING: The response has 20 rows! Consider using a smaller spatial unit.")
  }
  
  return(data)
}
  1. Define nearbySearch() Function: A reusable function nearbySearch() was defined to automate this process for any location, returning results ranked by distance. The resulting dataset was saved as an RDS file for subsequent spatial analysis.
nearbySearch(lat = 33.247602,
             lon = -84.270891,
             radius = 1609.34,
             types_vec = c("drugstore","pharmacy"),
             fieldmask_vec = c("places.displayName",
                               "places.formattedAddress",
                               "places.types"),
             google_api_key = Sys.getenv(("GOOGLE_API"))
) %>% knitr::kable()
places.types places.formattedAddress places.displayName.text places.displayName.languageCode
pharmacy , health , point_of_interest, store , establishment 222 W Poplar St, Griffin, GA 30224, USA U Save It Pharmacy en
convenience_store, gift_shop , discount_store , grocery_store , food_store , drugstore , health , food , point_of_interest, store , establishment 821 W Taylor St, Griffin, GA 30223, USA Dollar General en
pharmacy , drugstore , health , point_of_interest, store , establishment 131 W Taylor St, Griffin, GA 30223, USA Claxton Hobbs Pharmacy en
pharmacy , health , point_of_interest, store , establishment 131 W Taylor St, Griffin, GA 30223, USA Peeler Michelle en
pharmacy , health , point_of_interest, store , establishment 315 S 8th St, Griffin, GA 30224, USA David’s Drug & Surgical en
pharmacy , health , point_of_interest, store , establishment 405 S Hill St, Griffin, GA 30224, USA COVID-19 Drive-Thru Testing at Walgreens en
drugstore , convenience_store, food_store , health , food , clothing_store , point_of_interest, store , establishment 405 S Hill St, Griffin, GA 30224, USA Walgreens en
pharmacy , health , point_of_interest, store , establishment 405 S Hill St, Griffin, GA 30224, USA Walgreens Pharmacy en
pharmacy , health , point_of_interest, store , establishment 322 S 6th St, Griffin, GA 30224, USA Medication Expert en
pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA Bennett Clyde en
pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA Duncan Annette W en
pharmacy , gift_shop , consultant , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA Wynn’s Pharmacy en
pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA Bartlett Crystal B en
pharmacy , health , point_of_interest, store , establishment 622 S 8th St, Griffin, GA 30224, USA Hospital Discount Drugs en
data_list <- vector("list", nrow(bg_griffin_xyr))
data_list %>% knitr::kable()
for (i in seq_len(nrow(bg_griffin_xyr))) {
  data_list[[i]] <- nearbySearch(
    lat = bg_griffin_xyr$y[i],
    lon = bg_griffin_xyr$x[i],
    radius = bg_griffin_xyr$r[i],
    types_vec = c("drugstore","pharmacy"), 
    fieldmask_vec = c("places.id",
                       "places.displayName",
                       "places.formattedAddress", 
                       "places.location", 
                       "places.types", 
                       "places.priceLevel", 
                       "places.rating", 
                       "places.userRatingCount"),
    google_api_key = Sys.getenv("GOOGLE_API")
  )
  
  Sys.sleep(1) 
}

data_all <- dplyr::bind_rows(data_list)
saveRDS(data_all, here('google_poi_data.rds'))
  1. Visualizing Results: The structure of the collected POI dataset was inspected using names() to view all column names. This provided a quick glimpse of the available fields and helped verify that the required information had been successfully retrieved before further analysis and visualization.
names(data_all)
##  [1] "places.id"                       "places.types"                   
##  [3] "places.formattedAddress"         "places.rating"                  
##  [5] "places.priceLevel"               "places.userRatingCount"         
##  [7] "places.location.latitude"        "places.location.longitude"      
##  [9] "places.displayName.text"         "places.displayName.languageCode"
  1. Creating Spatial Points and Mapping POIs: The POI dataset was converted into a POINT sf object using longitude and latitude, excluding rows with missing coordinates. An interactive map was created with tmap, showing the city boundary and POI locations. The points were styled by priceLevel and sized by userRatingCount, with pop-ups displaying the name and rating count of each location, enabling visual exploration of spatial patterns in pharmacy distribution.
data_all_sf <- data_all %>%
  rename(x = places.location.longitude, y = places.location.latitude) %>% 
  filter(!is.na(x) & !is.na(y)) %>%
  st_as_sf(coords = c("x", "y"), crs = 4326)


tm_shape(data_all_sf) + 
  tm_dots(col = "places.priceLevel" , 
          size = "places.userRatingCount",
          palette = "magma",
          popup.vars = c("Name" = "places.displayName.text",
                         "Rating Count" = "places.userRatingCount")) +
  tm_shape(griffin) + 
  tm_borders()
data_all %>% knitr::kable()
places.id places.types places.formattedAddress places.rating places.priceLevel places.userRatingCount places.location.latitude places.location.longitude places.displayName.text places.displayName.languageCode
ChIJhS0bgblh9IgRXsWcGEVHojQ pharmacy , drugstore , store , health , point_of_interest, establishment 1524 GA-16, Griffin, GA 30223, USA 2.3 PRICE_LEVEL_MODERATE 100 33.24501 -84.29424 Kroger Pharmacy en
ChIJYZw7t5KK9IgRaeKqe94IPwM drugstore , convenience_store, food_store , health , food , clothing_store , point_of_interest, store , establishment 1602 N Expy, Griffin, GA 30223, USA 3.2 PRICE_LEVEL_MODERATE 92 33.27481 -84.29009 Walgreens en
ChIJPaQo9xOL9IgRxL1mjhK7DKQ pharmacy , health , point_of_interest, store , establishment 1602 N Expy, Griffin, GA 30223, USA 4.0 NA 1 33.27482 -84.29017 COVID-19 Drive-Thru Testing at Walgreens en
ChIJfal1vJKK9IgRRTAUE1xcvg8 pharmacy , health , point_of_interest, store , establishment 1602 N Expy, Griffin, GA 30223, USA 3.5 PRICE_LEVEL_MODERATE 20 33.27484 -84.29031 Walgreens Pharmacy en
ChIJa-71qmGK9IgRGEKqF_wWEa4 veterinary_care , pharmacy , health , point_of_interest, store , establishment 656 N Expy, Griffin, GA 30223, USA 4.8 NA 554 33.25984 -84.28817 Griffin Animal Care en
ChIJw3LmIvKK9IgR9UMqBDlCXdc pharmacy , health , point_of_interest, store , establishment 1569 N Expy, Griffin, GA 30223, USA 3.1 PRICE_LEVEL_INEXPENSIVE 50 33.27241 -84.29667 Walmart Pharmacy en
ChIJx1ZtzfGK9IgRf1vDkLjfwRU convenience_store, gift_shop , discount_store , grocery_store , food_store , drugstore , health , food , point_of_interest, store , establishment 1665 W McIntosh Rd, Griffin, GA 30223, USA 4.1 PRICE_LEVEL_INEXPENSIVE 435 33.27425 -84.29778 Dollar General en
ChIJ6wFJIfCJ9IgR7C6W0dAjS-U discount_store , drugstore , convenience_store, grocery_store , food_store , gift_shop , store , health , food , point_of_interest, establishment 1523 A, 1523 Zebulon Rd, Griffin, GA 30224, USA 4.0 PRICE_LEVEL_INEXPENSIVE 264 33.20417 -84.28223 Dollar General en
ChIJVVWVqumJ9IgRPKkycm6SCEs pharmacy , store , health , point_of_interest, establishment 1655 Zebulon Rd, Griffin, GA 30224, USA NA NA NA 33.19787 -84.28326 COVID-19 Drive-Thru Testing at Walgreens en
ChIJrTcFjsSJ9IgRoVIlWlCcy8I pharmacy , store , health , point_of_interest, establishment 1655 Zebulon Rd, Griffin, GA 30224, USA 4.4 NA 18 33.19787 -84.28326 Walgreens Pharmacy en
ChIJ9VbYDkaJ9IgR7rCzlz5bc-I drugstore , convenience_store, clothing_store , food_store , store , health , food , point_of_interest, establishment 1655 Zebulon Rd, Griffin, GA 30224, USA 2.9 NA 39 33.19787 -84.28326 Walgreens en
ChIJSaOKtOiJ9IgRMucMJ8as0FQ grocery_store , atm , deli , market , pharmacy , bakery , supermarket , finance , food_store , store , health , food , point_of_interest, establishment 1735 Zebulon Rd, Griffin, GA 30223, USA 4.2 PRICE_LEVEL_MODERATE 1053 33.19483 -84.28583 Ingles Market en
ChIJQeT37sGJ9IgRvmHANBrq9lE pharmacy , store , health , point_of_interest, establishment 1735 Zebulon Rd, Griffin, GA 30224, USA 4.4 NA 24 33.19484 -84.28543 Ingles Pharmacy en
ChIJMYEOR26K9IgRV4dzYTigNsE convenience_store, gift_shop , discount_store , grocery_store , food_store , drugstore , health , food , point_of_interest, store , establishment 821 W Taylor St, Griffin, GA 30223, USA 4.0 PRICE_LEVEL_INEXPENSIVE 621 33.24782 -84.27631 Dollar General en
ChIJ8c85q_Zh9IgRGwshwNa6PQM grocery_store , convenience_store, market , gift_shop , discount_store , home_goods_store , food_store , drugstore , health , food , point_of_interest, store , establishment 105 Armstead Cir, Griffin, GA 30223, USA 5.0 NA 3 33.27876 -84.26069 DG Market en
ChIJMYEOR26K9IgRV4dzYTigNsE convenience_store, gift_shop , discount_store , grocery_store , food_store , drugstore , health , food , point_of_interest, store , establishment 821 W Taylor St, Griffin, GA 30223, USA 4.0 PRICE_LEVEL_INEXPENSIVE 621 33.24782 -84.27631 Dollar General en
ChIJh1mwedlh9IgRzhqWxCM0zZ8 pharmacy , health , point_of_interest, store , establishment 131 W Taylor St, Griffin, GA 30223, USA NA NA NA 33.24739 -84.26525 Peeler Michelle en
ChIJh1mwedlh9IgRTkgqyvUrBgo pharmacy , drugstore , health , point_of_interest, store , establishment 131 W Taylor St, Griffin, GA 30223, USA 4.9 NA 52 33.24733 -84.26533 Claxton Hobbs Pharmacy en
ChIJMYEOR26K9IgRV4dzYTigNsE gift_shop , convenience_store, discount_store , grocery_store , drugstore , food_store , store , health , point_of_interest, food , establishment 821 W Taylor St, Griffin, GA 30223, USA 4.0 PRICE_LEVEL_INEXPENSIVE 621 33.24782 -84.27631 Dollar General en
ChIJOT2OMNlh9IgRdCPDUiV2ya0 pharmacy , store , health , point_of_interest, establishment 222 W Poplar St, Griffin, GA 30224, USA 4.4 NA 61 33.24543 -84.26652 U Save It Pharmacy en
ChIJnwiNE95h9IgRfLy1MrYGS84 pharmacy , store , health , point_of_interest, establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bennett Clyde en
ChIJnwiNE95h9IgRqK9OVZHDB6k pharmacy , store , health , point_of_interest, establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Duncan Annette W en
ChIJ3a93bt5h9IgRDsfRVFNlnW8 pharmacy , gift_shop , consultant , store , health , point_of_interest, establishment 566 S 8th St, Griffin, GA 30224, USA 4.9 NA 97 33.24094 -84.26536 Wynn’s Pharmacy en
ChIJnwiNE95h9IgRD8dQtXeWExY pharmacy , store , health , point_of_interest, establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bartlett Crystal B en
ChIJBYevRdlh9IgRrUlugjo7PFY pharmacy , store , health , point_of_interest, establishment 315 S 8th St, Griffin, GA 30224, USA 4.6 NA 70 33.24520 -84.26586 David’s Drug & Surgical en
ChIJVVUVA9xh9IgRSIqN5NrQsnM pharmacy , store , health , point_of_interest, establishment 405 S Hill St, Griffin, GA 30224, USA NA NA NA 33.24408 -84.26451 COVID-19 Drive-Thru Testing at Walgreens en
ChIJkdS85KBh9IgR1ZHzxe1ueqI drugstore , convenience_store, food_store , clothing_store , store , health , point_of_interest, food , establishment 405 S Hill St, Griffin, GA 30224, USA 3.6 NA 45 33.24408 -84.26451 Walgreens en
ChIJwSZlrTRh9IgRPIJ68tr4BOA pharmacy , store , health , point_of_interest, establishment 405 S Hill St, Griffin, GA 30224, USA 3.1 NA 7 33.24408 -84.26451 Walgreens Pharmacy en
ChIJBW0lpuBh9IgRasP2iEM0APA pharmacy , store , health , point_of_interest, establishment 622 S 8th St, Griffin, GA 30224, USA 4.8 NA 66 33.23876 -84.26546 Hospital Discount Drugs en
ChIJh1mwedlh9IgRTkgqyvUrBgo pharmacy , drugstore , store , health , point_of_interest, establishment 131 W Taylor St, Griffin, GA 30223, USA 4.9 NA 52 33.24733 -84.26533 Claxton Hobbs Pharmacy en
ChIJh1mwedlh9IgRzhqWxCM0zZ8 pharmacy , store , health , point_of_interest, establishment 131 W Taylor St, Griffin, GA 30223, USA NA NA NA 33.24739 -84.26525 Peeler Michelle en
ChIJzXz7ub9h9IgR78zZFkljWTM pharmacy , health , store , point_of_interest, establishment 1012 Memorial Dr STE 15, Griffin, GA 30223, USA 3.0 NA 2 33.23939 -84.24684 Westbury Senior Care Pharmacy en
ChIJi5fbyr9h9IgR9oFywtt9Nt4 convenience_store, drugstore , discount_store , grocery_store , gift_shop , food_store , health , food , store , point_of_interest, establishment 1019 Memorial Dr, Griffin, GA 30224, USA 4.0 PRICE_LEVEL_INEXPENSIVE 428 33.24014 -84.24619 Dollar General en
ChIJxfRNG-Rh9IgRa4HeN79dP9g pharmacy , store , health , point_of_interest, establishment 736 S Hill St, Griffin, GA 30224, USA 3.2 NA 20 33.23308 -84.26405 CVS Pharmacy en
ChIJSdouyuZh9IgRolvfRInNTlc drugstore , convenience_store, food_store , clothing_store , store , health , food , point_of_interest, establishment 736 S Hill St, Griffin, GA 30224, USA 2.6 NA 121 33.23308 -84.26405 CVS en
ChIJBW0lpuBh9IgRasP2iEM0APA pharmacy , store , health , point_of_interest, establishment 622 S 8th St, Griffin, GA 30224, USA 4.8 NA 66 33.23876 -84.26546 Hospital Discount Drugs en
ChIJnwiNE95h9IgRfLy1MrYGS84 pharmacy , store , health , point_of_interest, establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bennett Clyde en
ChIJnwiNE95h9IgRqK9OVZHDB6k pharmacy , store , health , point_of_interest, establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Duncan Annette W en
ChIJ3a93bt5h9IgRDsfRVFNlnW8 pharmacy , gift_shop , consultant , store , health , point_of_interest, establishment 566 S 8th St, Griffin, GA 30224, USA 4.9 NA 97 33.24094 -84.26536 Wynn’s Pharmacy en
ChIJnwiNE95h9IgRD8dQtXeWExY pharmacy , store , health , point_of_interest, establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bartlett Crystal B en
ChIJzXz7ub9h9IgR78zZFkljWTM pharmacy , store , health , point_of_interest, establishment 1012 Memorial Dr STE 15, Griffin, GA 30223, USA 3.0 NA 2 33.23939 -84.24684 Westbury Senior Care Pharmacy en
ChIJi5fbyr9h9IgR9oFywtt9Nt4 convenience_store, gift_shop , drugstore , discount_store , grocery_store , food_store , store , health , food , point_of_interest, establishment 1019 Memorial Dr, Griffin, GA 30224, USA 4.0 PRICE_LEVEL_INEXPENSIVE 428 33.24014 -84.24619 Dollar General en
ChIJVVUVA9xh9IgRSIqN5NrQsnM pharmacy , store , health , point_of_interest, establishment 405 S Hill St, Griffin, GA 30224, USA NA NA NA 33.24408 -84.26451 COVID-19 Drive-Thru Testing at Walgreens en
ChIJkdS85KBh9IgR1ZHzxe1ueqI drugstore , convenience_store, food_store , clothing_store , store , health , food , point_of_interest, establishment 405 S Hill St, Griffin, GA 30224, USA 3.6 NA 45 33.24408 -84.26451 Walgreens en
ChIJwSZlrTRh9IgRPIJ68tr4BOA pharmacy , store , health , point_of_interest, establishment 405 S Hill St, Griffin, GA 30224, USA 3.1 NA 7 33.24408 -84.26451 Walgreens Pharmacy en
ChIJBbNCedth9IgRDnjUFVcwxiw pharmacy , store , health , point_of_interest, establishment 322 S 6th St, Griffin, GA 30224, USA NA NA NA 33.24496 -84.26193 Medication Expert en
ChIJBYevRdlh9IgRrUlugjo7PFY pharmacy , store , health , point_of_interest, establishment 315 S 8th St, Griffin, GA 30224, USA 4.6 NA 70 33.24520 -84.26586 David’s Drug & Surgical en
ChIJOT2OMNlh9IgRdCPDUiV2ya0 pharmacy , store , health , point_of_interest, establishment 222 W Poplar St, Griffin, GA 30224, USA 4.4 NA 61 33.24543 -84.26652 U Save It Pharmacy en
ChIJh1mwedlh9IgRTkgqyvUrBgo pharmacy , drugstore , store , health , point_of_interest, establishment 131 W Taylor St, Griffin, GA 30223, USA 4.9 NA 52 33.24733 -84.26533 Claxton Hobbs Pharmacy en
ChIJh1mwedlh9IgRzhqWxCM0zZ8 pharmacy , store , health , point_of_interest, establishment 131 W Taylor St, Griffin, GA 30223, USA NA NA NA 33.24739 -84.26525 Peeler Michelle en
ChIJzXz7ub9h9IgR78zZFkljWTM pharmacy , health , point_of_interest, store , establishment 1012 Memorial Dr STE 15, Griffin, GA 30223, USA 3.0 NA 2 33.23939 -84.24684 Westbury Senior Care Pharmacy en
ChIJi5fbyr9h9IgR9oFywtt9Nt4 convenience_store, gift_shop , discount_store , grocery_store , food_store , drugstore , health , food , point_of_interest, store , establishment 1019 Memorial Dr, Griffin, GA 30224, USA 4.0 PRICE_LEVEL_INEXPENSIVE 428 33.24014 -84.24619 Dollar General en
ChIJBbNCedth9IgRDnjUFVcwxiw pharmacy , health , point_of_interest, store , establishment 322 S 6th St, Griffin, GA 30224, USA NA NA NA 33.24496 -84.26193 Medication Expert en
ChIJBW0lpuBh9IgRasP2iEM0APA pharmacy , health , point_of_interest, store , establishment 622 S 8th St, Griffin, GA 30224, USA 4.8 NA 66 33.23876 -84.26546 Hospital Discount Drugs en
ChIJnwiNE95h9IgRfLy1MrYGS84 pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bennett Clyde en
ChIJnwiNE95h9IgRqK9OVZHDB6k pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Duncan Annette W en
ChIJ3a93bt5h9IgRDsfRVFNlnW8 pharmacy , gift_shop , consultant , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA 4.9 NA 97 33.24094 -84.26536 Wynn’s Pharmacy en
ChIJnwiNE95h9IgRD8dQtXeWExY pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bartlett Crystal B en
ChIJVVUVA9xh9IgRSIqN5NrQsnM pharmacy , health , point_of_interest, store , establishment 405 S Hill St, Griffin, GA 30224, USA NA NA NA 33.24408 -84.26451 COVID-19 Drive-Thru Testing at Walgreens en
ChIJkdS85KBh9IgR1ZHzxe1ueqI drugstore , convenience_store, food_store , health , food , clothing_store , point_of_interest, store , establishment 405 S Hill St, Griffin, GA 30224, USA 3.6 NA 45 33.24408 -84.26451 Walgreens en
ChIJwSZlrTRh9IgRPIJ68tr4BOA pharmacy , health , point_of_interest, store , establishment 405 S Hill St, Griffin, GA 30224, USA 3.1 NA 7 33.24408 -84.26451 Walgreens Pharmacy en
ChIJ8c85q_Zh9IgRGwshwNa6PQM grocery_store , convenience_store, discount_store , gift_shop , market , drugstore , food_store , food , health , point_of_interest, home_goods_store , store , establishment 105 Armstead Cir, Griffin, GA 30223, USA 5.0 NA 3 33.27876 -84.26069 DG Market en
ChIJ8cYNGLxj9IgRwbZMXQTV4NA gift_shop , convenience_store, discount_store , market , grocery_store , drugstore , food_store , store , health , point_of_interest, food , establishment 3040 Macon Rd, Orchard Hill, GA 30266, USA 4.0 PRICE_LEVEL_INEXPENSIVE 309 33.18485 -84.21079 Dollar General en
ChIJmaeU0CuK9IgRQSIAZc02l8U convenience_store, market , gift_shop , discount_store , grocery_store , food_store , drugstore , health , food , point_of_interest, store , establishment 1713 Williamson Zebulon Rd, Griffin, GA 30224, USA 4.2 PRICE_LEVEL_INEXPENSIVE 213 33.22181 -84.30965 Dollar General en
ChIJ6wFJIfCJ9IgR7C6W0dAjS-U gift_shop , convenience_store, discount_store , grocery_store , drugstore , food_store , store , health , point_of_interest, food , establishment 1523 A, 1523 Zebulon Rd, Griffin, GA 30224, USA 4.0 PRICE_LEVEL_INEXPENSIVE 264 33.20417 -84.28223 Dollar General en
ChIJVVWVqumJ9IgRPKkycm6SCEs pharmacy , store , health , point_of_interest, establishment 1655 Zebulon Rd, Griffin, GA 30224, USA NA NA NA 33.19787 -84.28326 COVID-19 Drive-Thru Testing at Walgreens en
ChIJrTcFjsSJ9IgRoVIlWlCcy8I pharmacy , store , health , point_of_interest, establishment 1655 Zebulon Rd, Griffin, GA 30224, USA 4.4 NA 18 33.19787 -84.28326 Walgreens Pharmacy en
ChIJ9VbYDkaJ9IgR7rCzlz5bc-I drugstore , convenience_store, food_store , clothing_store , store , health , point_of_interest, food , establishment 1655 Zebulon Rd, Griffin, GA 30224, USA 2.9 NA 39 33.19787 -84.28326 Walgreens en
ChIJQeT37sGJ9IgRvmHANBrq9lE pharmacy , store , health , point_of_interest, establishment 1735 Zebulon Rd, Griffin, GA 30224, USA 4.4 NA 24 33.19484 -84.28543 Ingles Pharmacy en
ChIJSaOKtOiJ9IgRMucMJ8as0FQ grocery_store , atm , supermarket , deli , bakery , market , pharmacy , food_store , store , finance , health , point_of_interest, food , establishment 1735 Zebulon Rd, Griffin, GA 30223, USA 4.2 PRICE_LEVEL_MODERATE 1053 33.19483 -84.28583 Ingles Market en
ChIJxfRNG-Rh9IgRa4HeN79dP9g pharmacy , health , point_of_interest, store , establishment 736 S Hill St, Griffin, GA 30224, USA 3.2 NA 20 33.23308 -84.26405 CVS Pharmacy en
ChIJSdouyuZh9IgRolvfRInNTlc drugstore , convenience_store, clothing_store , health , point_of_interest, food_store , food , store , establishment 736 S Hill St, Griffin, GA 30224, USA 2.6 NA 121 33.23308 -84.26405 CVS en
ChIJBW0lpuBh9IgRasP2iEM0APA pharmacy , health , point_of_interest, store , establishment 622 S 8th St, Griffin, GA 30224, USA 4.8 NA 66 33.23876 -84.26546 Hospital Discount Drugs en
ChIJnwiNE95h9IgRfLy1MrYGS84 pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bennett Clyde en
ChIJnwiNE95h9IgRqK9OVZHDB6k pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Duncan Annette W en
ChIJ3a93bt5h9IgRDsfRVFNlnW8 pharmacy , gift_shop , consultant , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA 4.9 NA 97 33.24094 -84.26536 Wynn’s Pharmacy en
ChIJnwiNE95h9IgRD8dQtXeWExY pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bartlett Crystal B en
ChIJi5fbyr9h9IgR9oFywtt9Nt4 convenience_store, discount_store , gift_shop , drugstore , grocery_store , food_store , food , point_of_interest, health , store , establishment 1019 Memorial Dr, Griffin, GA 30224, USA 4.0 PRICE_LEVEL_INEXPENSIVE 428 33.24014 -84.24619 Dollar General en
ChIJzXz7ub9h9IgR78zZFkljWTM pharmacy , point_of_interest, health , store , establishment 1012 Memorial Dr STE 15, Griffin, GA 30223, USA 3.0 NA 2 33.23939 -84.24684 Westbury Senior Care Pharmacy en
ChIJx1ZtzfGK9IgRf1vDkLjfwRU convenience_store, gift_shop , drugstore , discount_store , grocery_store , food_store , store , health , food , point_of_interest, establishment 1665 W McIntosh Rd, Griffin, GA 30223, USA 4.1 PRICE_LEVEL_INEXPENSIVE 435 33.27425 -84.29778 Dollar General en
ChIJw3LmIvKK9IgR9UMqBDlCXdc pharmacy , store , health , point_of_interest, establishment 1569 N Expy, Griffin, GA 30223, USA 3.1 PRICE_LEVEL_INEXPENSIVE 50 33.27241 -84.29667 Walmart Pharmacy en
ChIJfal1vJKK9IgRRTAUE1xcvg8 pharmacy , store , health , point_of_interest, establishment 1602 N Expy, Griffin, GA 30223, USA 3.5 PRICE_LEVEL_MODERATE 20 33.27484 -84.29031 Walgreens Pharmacy en
ChIJPaQo9xOL9IgRxL1mjhK7DKQ pharmacy , store , health , point_of_interest, establishment 1602 N Expy, Griffin, GA 30223, USA 4.0 NA 1 33.27482 -84.29017 COVID-19 Drive-Thru Testing at Walgreens en
ChIJYZw7t5KK9IgRaeKqe94IPwM drugstore , convenience_store, food_store , clothing_store , store , health , food , point_of_interest, establishment 1602 N Expy, Griffin, GA 30223, USA 3.2 PRICE_LEVEL_MODERATE 92 33.27481 -84.29009 Walgreens en
ChIJi5fbyr9h9IgR9oFywtt9Nt4 convenience_store, gift_shop , discount_store , grocery_store , food_store , drugstore , health , food , point_of_interest, store , establishment 1019 Memorial Dr, Griffin, GA 30224, USA 4.0 PRICE_LEVEL_INEXPENSIVE 428 33.24014 -84.24619 Dollar General en
ChIJx1ZtzfGK9IgRf1vDkLjfwRU convenience_store, discount_store , gift_shop , drugstore , grocery_store , food_store , food , health , point_of_interest, store , establishment 1665 W McIntosh Rd, Griffin, GA 30223, USA 4.1 PRICE_LEVEL_INEXPENSIVE 435 33.27425 -84.29778 Dollar General en
ChIJfal1vJKK9IgRRTAUE1xcvg8 pharmacy , health , point_of_interest, store , establishment 1602 N Expy, Griffin, GA 30223, USA 3.5 PRICE_LEVEL_MODERATE 20 33.27484 -84.29031 Walgreens Pharmacy en
ChIJPaQo9xOL9IgRxL1mjhK7DKQ pharmacy , health , point_of_interest, store , establishment 1602 N Expy, Griffin, GA 30223, USA 4.0 NA 1 33.27482 -84.29017 COVID-19 Drive-Thru Testing at Walgreens en
ChIJYZw7t5KK9IgRaeKqe94IPwM drugstore , convenience_store, clothing_store , food_store , food , health , point_of_interest, store , establishment 1602 N Expy, Griffin, GA 30223, USA 3.2 PRICE_LEVEL_MODERATE 92 33.27481 -84.29009 Walgreens en
ChIJw3LmIvKK9IgR9UMqBDlCXdc pharmacy , health , point_of_interest, store , establishment 1569 N Expy, Griffin, GA 30223, USA 3.1 PRICE_LEVEL_INEXPENSIVE 50 33.27241 -84.29667 Walmart Pharmacy en
ChIJmaeU0CuK9IgRQSIAZc02l8U convenience_store, discount_store , gift_shop , market , drugstore , grocery_store , food_store , food , health , point_of_interest, store , establishment 1713 Williamson Zebulon Rd, Griffin, GA 30224, USA 4.2 PRICE_LEVEL_INEXPENSIVE 213 33.22181 -84.30965 Dollar General en
ChIJhS0bgblh9IgRXsWcGEVHojQ pharmacy , drugstore , health , point_of_interest, store , establishment 1524 GA-16, Griffin, GA 30223, USA 2.3 PRICE_LEVEL_MODERATE 100 33.24501 -84.29424 Kroger Pharmacy en
ChIJw3LmIvKK9IgR9UMqBDlCXdc pharmacy , health , point_of_interest, store , establishment 1569 N Expy, Griffin, GA 30223, USA 3.1 PRICE_LEVEL_INEXPENSIVE 50 33.27241 -84.29667 Walmart Pharmacy en
ChIJx1ZtzfGK9IgRf1vDkLjfwRU convenience_store, discount_store , gift_shop , drugstore , grocery_store , food_store , food , health , point_of_interest, store , establishment 1665 W McIntosh Rd, Griffin, GA 30223, USA 4.1 PRICE_LEVEL_INEXPENSIVE 435 33.27425 -84.29778 Dollar General en
ChIJa-71qmGK9IgRGEKqF_wWEa4 veterinary_care , pharmacy , health , point_of_interest, store , establishment 656 N Expy, Griffin, GA 30223, USA 4.8 NA 554 33.25984 -84.28817 Griffin Animal Care en
ChIJmaeU0CuK9IgRQSIAZc02l8U convenience_store, discount_store , gift_shop , market , drugstore , grocery_store , food_store , food , health , point_of_interest, store , establishment 1713 Williamson Zebulon Rd, Griffin, GA 30224, USA 4.2 PRICE_LEVEL_INEXPENSIVE 213 33.22181 -84.30965 Dollar General en
ChIJfal1vJKK9IgRRTAUE1xcvg8 pharmacy , health , point_of_interest, store , establishment 1602 N Expy, Griffin, GA 30223, USA 3.5 PRICE_LEVEL_MODERATE 20 33.27484 -84.29031 Walgreens Pharmacy en
ChIJPaQo9xOL9IgRxL1mjhK7DKQ pharmacy , health , point_of_interest, store , establishment 1602 N Expy, Griffin, GA 30223, USA 4.0 NA 1 33.27482 -84.29017 COVID-19 Drive-Thru Testing at Walgreens en
ChIJYZw7t5KK9IgRaeKqe94IPwM drugstore , convenience_store, clothing_store , food_store , food , health , point_of_interest, store , establishment 1602 N Expy, Griffin, GA 30223, USA 3.2 PRICE_LEVEL_MODERATE 92 33.27481 -84.29009 Walgreens en
ChIJi5fbyr9h9IgR9oFywtt9Nt4 convenience_store, gift_shop , discount_store , grocery_store , food_store , drugstore , health , food , point_of_interest, store , establishment 1019 Memorial Dr, Griffin, GA 30224, USA 4.0 PRICE_LEVEL_INEXPENSIVE 428 33.24014 -84.24619 Dollar General en
ChIJzXz7ub9h9IgR78zZFkljWTM pharmacy , health , point_of_interest, store , establishment 1012 Memorial Dr STE 15, Griffin, GA 30223, USA 3.0 NA 2 33.23939 -84.24684 Westbury Senior Care Pharmacy en
ChIJBbNCedth9IgRDnjUFVcwxiw pharmacy , health , point_of_interest, store , establishment 322 S 6th St, Griffin, GA 30224, USA NA NA NA 33.24496 -84.26193 Medication Expert en
ChIJVVUVA9xh9IgRSIqN5NrQsnM pharmacy , health , point_of_interest, store , establishment 405 S Hill St, Griffin, GA 30224, USA NA NA NA 33.24408 -84.26451 COVID-19 Drive-Thru Testing at Walgreens en
ChIJkdS85KBh9IgR1ZHzxe1ueqI drugstore , convenience_store, food_store , health , food , clothing_store , point_of_interest, store , establishment 405 S Hill St, Griffin, GA 30224, USA 3.6 NA 45 33.24408 -84.26451 Walgreens en
ChIJwSZlrTRh9IgRPIJ68tr4BOA pharmacy , health , point_of_interest, store , establishment 405 S Hill St, Griffin, GA 30224, USA 3.1 NA 7 33.24408 -84.26451 Walgreens Pharmacy en
ChIJnwiNE95h9IgRfLy1MrYGS84 pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bennett Clyde en
ChIJnwiNE95h9IgRqK9OVZHDB6k pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Duncan Annette W en
ChIJ3a93bt5h9IgRDsfRVFNlnW8 pharmacy , gift_shop , consultant , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA 4.9 NA 97 33.24094 -84.26536 Wynn’s Pharmacy en
ChIJnwiNE95h9IgRD8dQtXeWExY pharmacy , health , point_of_interest, store , establishment 566 S 8th St, Griffin, GA 30224, USA NA NA NA 33.24094 -84.26536 Bartlett Crystal B en
ChIJh1mwedlh9IgRzhqWxCM0zZ8 pharmacy , health , point_of_interest, store , establishment 131 W Taylor St, Griffin, GA 30223, USA NA NA NA 33.24739 -84.26525 Peeler Michelle en
ChIJBYevRdlh9IgRrUlugjo7PFY pharmacy , health , point_of_interest, store , establishment 315 S 8th St, Griffin, GA 30224, USA 4.6 NA 70 33.24520 -84.26586 David’s Drug & Surgical en
ChIJh1mwedlh9IgRTkgqyvUrBgo pharmacy , drugstore , health , point_of_interest, store , establishment 131 W Taylor St, Griffin, GA 30223, USA 4.9 NA 52 33.24733 -84.26533 Claxton Hobbs Pharmacy en
ChIJBW0lpuBh9IgRasP2iEM0APA pharmacy , health , point_of_interest, store , establishment 622 S 8th St, Griffin, GA 30224, USA 4.8 NA 66 33.23876 -84.26546 Hospital Discount Drugs en
ChIJOT2OMNlh9IgRdCPDUiV2ya0 pharmacy , health , point_of_interest, store , establishment 222 W Poplar St, Griffin, GA 30224, USA 4.4 NA 61 33.24543 -84.26652 U Save It Pharmacy en
ChIJxfRNG-Rh9IgRa4HeN79dP9g pharmacy , health , point_of_interest, store , establishment 736 S Hill St, Griffin, GA 30224, USA 3.2 NA 20 33.23308 -84.26405 CVS Pharmacy en
ChIJSdouyuZh9IgRolvfRInNTlc drugstore , convenience_store, food_store , health , food , clothing_store , point_of_interest, store , establishment 736 S Hill St, Griffin, GA 30224, USA 2.6 NA 121 33.23308 -84.26405 CVS en

Questions & Answers

1. What city did you choose?
Answer: The city of Griffin situated in Scalding county in the state of Georgia.
2. Which two place types did you select?
Answer: I chose pharmacy and drugstore as the two place types under the Health and Wellness category.
3. How many rows does your dataset contain?
Answer: The POI dataset generated contains 116 rows
4. Upon visual inspection, do you notice any spatial patterns in how POIs are distributed across the city?
Answer: Pharmacies and drugstores POIs show a clustering pattern near the central part of the city. A few locations are situated on the periphery along major corridors, likely to serve travelers or suburban neighborhoods.
5. Did you observe any other interesting findings?
Answer:
- The central clusters of pharmacies in Griffin show smaller user rating counts, which may suggest that footfall is spread across multiple stores in the urban core. In contrast, the peripheral pharmacies show larger rating counts, indicating higher patronage at fewer locations. This pattern may imply that peripheral residents rely on a limited number of pharmacies, creating dominant, high-traffic anchor stores outside the core.
- From looking at the data set it can also be observed that most of all pharmacies and drugstores are situated inside other establishments, indicating they are often part of larger commercial or retail complexes.