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