library(dplyr)
## Warning: package 'dplyr' was built under R version 4.2.3
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(leaflet)

con <- ecotoolbox::eco_gis_connect()
NZ_geo <- tbl(con, dbplyr::in_schema(
  "maps",
  "wb_countries_admin0_10m"
)) %>%
  filter(iso_a2 == "NZ") %>%
  mutate(shape = sql("ST_AsText(geom)")) %>%
  show_query() %>% 
  collect() %>%
  mutate(
    shape = sf::st_as_sfc(shape)
  )
## <SQL>
## SELECT *, ST_AsText(geom) AS "shape"
## FROM "maps"."wb_countries_admin0_10m"
## WHERE ("iso_a2" = 'NZ')
NZ_sites <- tbl(con, dbplyr::in_schema(
  "public",
  "counter_geom"
)) %>%
  filter(site_id %in% c(300028373, 300028375, 300028376, 300028377)) %>%
  mutate(shape = sql("ST_AsText(geom)")) %>%
    show_query() %>% 
  collect() %>%
  mutate(
    shape = sf::st_as_sfc(shape)
  )
## <SQL>
## SELECT *, ST_AsText(geom) AS "shape"
## FROM "public"."counter_geom"
## WHERE ("site_id" IN (300028373.0, 300028375.0, 300028376.0, 300028377.0))
NZ_geo %>% 
  sf::st_as_sf() %>% 
leaflet()  %>% 
  addProviderTiles(
    "OpenStreetMap",
    group = "OpenStreetMap"
  ) %>% 
  addPolygons( color = "red") %>% 
  addCircleMarkers(data = NZ_sites) %>% 
  setView(lng = 170,
          lat = -40, zoom = 4) 
## Assuming "longitude" and "latitude" are longitude and latitude, respectively