Translate x, y coordinates by delta x, delta y for point geometries

This function translates point geometries by the specified delta x and delta y values.

Usage

st_translate(dbSpatial, geomName = "geom", dx, dy, ...)

# S4 method for class 'dbSpatial'
st_translate(dbSpatial, geomName = "geom", dx, dy, ...)

Arguments

geomName: character string. The geometry column name in the dbSpatial object. Default: "geom".
dx: numeric.value to shift x coordinates by
dy: numeric. value to shift y coordinates by
...: additional arguments passed to methods
dbSpatial: object
name: string. name of table to add to dbSpatial object.

Value

dbSpatial object

Functions

st_translate(dbSpatial): Method for dbSpatial object

Examples

con = DBI::dbConnect(duckdb::duckdb(), ":memory:")

coordinates <- data.frame(x = c(100, 200, 300), y = c(500, 600, 700))
attributes <- data.frame(id = 1:3, name = c("A", "B", "C"))

# Combine the coordinates and attributes
dummy_data <- cbind(coordinates, attributes)
 
points <- dbSpatial(conn = con,
                    name = "points", 
                    value = dummy_data, 
                    overwrite = TRUE, 
                    x_colName = "x", 
                    y_colName = "y")

points
#> # Class:    dbSpatial 
#> # Source:   table<points> [?? x 5]
#> # Database: DuckDB 1.4.0 [unknown@Linux 6.11.0-1018-azure:R 4.5.1/:memory:]
#>       x     y    id name  geom      
#>   <dbl> <dbl> <int> <chr> <list>    
#> 1   100   500     1 A     <raw [32]>
#> 2   200   600     2 B     <raw [32]>
#> 3   300   700     3 C     <raw [32]>

points_translated <- st_translate(dbSpatial = points, dx = 100, dy = -20)

points_translated
#> # Class:    dbSpatial 
#> # Source:   SQL [?? x 5]
#> # Database: DuckDB 1.4.0 [unknown@Linux 6.11.0-1018-azure:R 4.5.1/:memory:]
#>       x     y    id name  geom      
#>   <dbl> <dbl> <int> <chr> <list>    
#> 1   100   500     1 A     <raw [32]>
#> 2   200   600     2 B     <raw [32]>
#> 3   300   700     3 C     <raw [32]>