paleolimbot commented on issue #1024: URL: https://github.com/apache/sedona-db/issues/1024#issuecomment-4918775398
Sorry it took me a second to circle back here. Does something like this work for you? ``` r library(sdplyr) #> Warning: package 'sdplyr' was built under R version 4.6.1 #> ── Attaching sdplyr packages ───────────────────────────────────── 0.4.0.9000 ── #> ✔ sedonadb 0.4.0.9000 #> ✔ sedonafns 0.3.0.9000 #> ✔ dplyr 1.2.1 # Load cities and countries from geoarrow-data cities_url <- "https://raw.githubusercontent.com/geoarrow/geoarrow-data/v0.2.0/natural-earth/files/natural-earth_cities.parquet"; cities <- sd_read_parquet(cities_url) cities |> filter( sd_intersects( geometry, wk::rct(-80, 40, -60, 60, wk::wk_crs_longlat())) ) #> <sedonab_dataframe: NA x 2> #> ┌──────────┬─────────────────────────────────────────────┐ #> │ name ┆ geometry │ #> │ utf8 ┆ geometry │ #> ╞══════════╪═════════════════════════════════════════════╡ #> │ Ottawa ┆ POINT(-75.7019612 45.4186427) │ #> ├╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ #> │ Toronto ┆ POINT(-79.38945855491194 43.66464454743429) │ #> ├╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ #> │ New York ┆ POINT(-73.99571754361698 40.72156174972766) │ #> └──────────┴─────────────────────────────────────────────┘ #> Preview of up to 6 row(s) ``` <sup>Created on 2026-07-08 with [reprex v2.1.1](https://reprex.tidyverse.org)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
