{ "_id": "6adbc64f077e75fa285b039c", "Package": "dbSpatial", "Title": "Spatial Data Operations for Database-Backed Geometries", "Version": "0.1.3", "Authors@R": "c(person(\"Edward\", \"C. Ruiz\", , \"ecr7407@gmail.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-9174-5387\")),\nperson(\"Jiaji\", \"George Chen\", email = \"jiajic@bu.edu\", role = c(\"aut\")),\nperson(\"Ruben\", \"Dries\", email = \"rubendries@gmail.com\",role = c(\"aut\", \"rev\")))", "Description": "Provides database-backed spatial geometry classes and\nmethods for working with vector spatial data in 'DuckDB'. The\npackage supports loading, converting, querying, joining, and\nmeasuring spatial geometries through familiar 'sf'-style\ninterfaces while keeping geometry columns lazy inside the\ndatabase. It integrates with 'dbProject' to preserve database\npaths, live connections, and spatial table metadata across\ninteractive sessions. The package follows the Simple Features\nframework described by Pebesma (2018)\n and uses DuckDB's spatial extension\n.", "License": "GPL-3 | MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "VignetteBuilder": "knitr", "URL": "https://github.com/dbverse-org/dbspatial-r,\nhttps://dbverse-org.github.io/dbspatial-r/", "BugReports": "https://github.com/dbverse-org/dbspatial-r/issues", "Config/testthat/edition": "3", "Collate": "'utils.R' 'generics.R' 'classes.R' 'accessors.R'\n'as_dbSpatial.R' 'coerce.R' 'constructors.R' 'dbSpatial.R'\n'extract.R' 'geometry_ops.R' 'global.R' 'imports.R'\n'input_validation.R' 'loadSpatial.R' 'measurements.R' 'show.R'\n'sim_dbSpatial.R' 'sql_gen.R' 'st_as_sf.R' 'st_bbox.R'\n'st_geometry_type.R' 'st_geometrytype.R' 'st_is_valid.R'\n'st_spatial_join.R' 'st_join.R' 'st_read.R' 'st_translate.R'\n'st_xmax.R' 'st_ymax.R' 'vect.R'", "Config/pak/sysreqs": "libabsl-dev cmake libgdal-dev gdal-bin libgeos-dev\nmake libicu-dev libuv1-dev libssl-dev libproj-dev\nlibsqlite3-dev libudunits2-dev xz-utils", "Repository": "https://dbverse-org.r-universe.dev", "Date/Publication": "2026-10-23 16:49:58 UTC", "RemoteUrl": "https://github.com/dbverse-org/dbspatial-r", "RemoteRef": "HEAD", "RemoteSha": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-23 19:40:48 UTC", "User": "root" }, "Author": "Edward C. Ruiz [aut, cre] (ORCID:\n),\nJiaji George Chen [aut],\nRuben Dries [aut, rev]", "Maintainer": "Edward C. Ruiz ", "_user": "dbverse-org", "_type": "src", "_file": "dbSpatial_0.1.3.tar.gz", "_fileid": "https://r2.ropensci.org/0ddb39fa3a5d4d117a824e294aa30d0763f3d9a144d2b3e581b95d4bc329bf1f", "_filesize": 270826, "_sha256": "0ddb39fa3a5d4d117a824e294aa30d0763f3d9a144d2b3e581b95d4bc329bf1f", "_expires": "2027-01-31T20:40:43.000Z", "_created": "2026-10-23T19:40:48.000Z", "_published": "2026-10-23T20:40:46.979Z", "_upstream": "https://github.com/dbverse-org/dbspatial-r", "_status": "success", "_maintainer": { "name": "Edward C. Ruiz", "email": "ecr7407@gmail.com", "login": "ed2uiz", "bluesky": "@ed2uiz.bsky.social", "description": "omics x infra x ai", "uuid": 32622519, "orcid": "0000-0002-9174-5387" }, "_jobs": [ { "job": 120619190117, "time": 256, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12527955664" }, { "job": 120619190110, "time": 241, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12526559463" }, { "job": 120619190190, "time": 2457, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "12529182846" }, { "job": 120619189989, "time": 203, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12527083143" }, { "job": 120616935188, "time": 297, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12526913187" }, { "job": 120619190065, "time": 126, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12528020315" }, { "job": 120619190114, "time": 3328, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12530203199" }, { "job": 120619190086, "time": 3532, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "12529659337" }, { "job": 120619190140, "time": 2179, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12528194570" } ], "_buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40012684517", "_commit": { "id": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "author": "Eddie Ruiz <32622519+Ed2uiz@users.noreply.github.com>", "committer": "GitHub ", "message": "Merge pull request #4 from dbverse-org/fix/exact-coordinates\n\nKeep exact coordinates and reduce memory in as_dbSpatial()", "time": 1792774198 }, "_distro": "resolute", "_host": "GitHub-Actions", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "methods", "role": "Imports" }, { "package": "tools", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "duckdb", "version": ">= 1.4.0", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "terra", "role": "Imports" }, { "package": "sf", "role": "Imports" }, { "package": "e1071", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "crayon", "role": "Imports" }, { "package": "checkmate", "role": "Imports" }, { "package": "cli", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "tidyselect", "role": "Imports" }, { "package": "dbProject", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "dbverse-org", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-52", "n": 6 }, { "week": "2026-01", "n": 20 }, { "week": "2026-02", "n": 3 }, { "week": "2026-03", "n": 11 }, { "week": "2026-04", "n": 1 }, { "week": "2026-18", "n": 1 }, { "week": "2026-19", "n": 8 }, { "week": "2026-21", "n": 2 }, { "week": "2026-22", "n": 2 }, { "week": "2026-26", "n": 5 }, { "week": "2026-43", "n": 2 } ], "_tags": [ { "name": "v0.0.0.9110", "date": "2026-01-13" } ], "_stars": 3, "_contributors": [ { "user": "ed2uiz", "count": 192, "uuid": 32622519 } ], "_userbio": { "uuid": 210240781, "type": "organization", "name": "dbverse-org", "followers": 7 }, "_downloads": { "count": 429, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbSpatial" }, "_devurl": "https://github.com/dbverse-org/dbspatial-r", "_pkgdown": "https://dbverse-org.github.io/dbspatial-r/", "_searchresults": 16, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dbSpatial.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/dbverse-org/dbspatial-r", "_realowner": "dbverse-org", "_cranurl": true, "_releases": [ { "version": "0.1.1", "date": "2026-05-27" }, { "version": "0.1.2", "date": "2026-06-23" }, { "version": "0.1.3", "date": "2026-10-14" }, { "version": "0.1.4", "date": "2026-10-23" } ], "_exports": [ "as_dbSpatial", "dbSpatial", "head", "loadSpatial", "st_as_geojson", "st_geometrytype", "st_npoints", "st_translate", "st_x", "st_xmax", "st_y", "st_ymax", "tail", "vect" ], "_help": [ { "page": "cash-dbSpatial-method", "title": "Column extraction for dbSpatial", "topics": [ "$,dbSpatial-method" ] }, { "page": "as_dbSpatial", "title": "Convert an sf or terra object to a 'dbSpatial' object", "concept": [ "dbSpatial" ], "topics": [ "as_dbSpatial" ] }, { "page": "dbSpatial", "title": "Create a 'dbSpatial' object with geometry data type", "concept": [ "dbSpatial" ], "topics": [ "dbSpatial", "dbSpatial-class" ] }, { "page": "dbSpatial_options", "title": "dbSpatial Package Global Options", "concept": [ "options" ], "topics": [ "dbSpatial-options", "dbSpatial_options" ] }, { "page": "head", "title": "head method for dbSpatial", "concept": [ "dbData" ], "topics": [ "head,dbSpatial-method" ] }, { "page": "loadSpatial", "title": "Install and/or load DuckDB spatial extension", "concept": [ "duckdb-ext" ], "topics": [ "loadSpatial" ] }, { "page": "show", "title": "show method for dbSpatial", "concept": [ "dbSpatial" ], "topics": [ "show,dbSpatial-method" ] }, { "page": "st_area", "title": "Get area of geometries", "concept": [ "measurements" ], "topics": [ "st_area", "st_area.dbSpatial" ] }, { "page": "st_as_geojson", "title": "Convert to GeoJSON", "concept": [ "constructors" ], "topics": [ "st_as_geojson", "st_as_geojson.dbSpatial" ] }, { "page": "st_as_sf.dbSpatial", "title": "Convert dbSpatial objects to sf objects", "concept": [ "dbSpatial" ], "topics": [ "st_as_sf.dbSpatial" ] }, { "page": "st_as_text", "title": "Convert to WKT", "concept": [ "constructors" ], "topics": [ "st_as_text", "st_as_text.dbSpatial" ] }, { "page": "st_bbox", "title": "Compute bounding box for dbSpatial object", "concept": [ "geom_summary" ], "topics": [ "st_bbox", "st_bbox.dbSpatial" ] }, { "page": "st_buffer", "title": "Compute buffer around geometry", "concept": [ "geometry_ops" ], "topics": [ "st_buffer", "st_buffer.dbSpatial" ] }, { "page": "st_centroid", "title": "Compute centroid of geometry", "concept": [ "geometry_ops" ], "topics": [ "st_centroid", "st_centroid.dbSpatial" ] }, { "page": "st_geometrytype", "title": "Get geometry types (DuckDB-native)", "concept": [ "geom_scalar" ], "topics": [ "st_geometrytype" ] }, { "page": "st_join.dbSpatial", "title": "Spatial join for dbSpatial objects", "topics": [ "st_join.dbSpatial" ] }, { "page": "st_length", "title": "Get length of geometries", "concept": [ "measurements" ], "topics": [ "st_length", "st_length.dbSpatial" ] }, { "page": "st_npoints", "title": "Get number of points", "concept": [ "accessors" ], "topics": [ "st_npoints", "st_npoints,dbSpatial-method" ] }, { "page": "st_perimeter", "title": "Get perimeter of geometries", "concept": [ "measurements" ], "topics": [ "st_perimeter", "st_perimeter.dbSpatial" ] }, { "page": "st_simplify", "title": "Simplify geometry", "concept": [ "geometry_ops" ], "topics": [ "st_simplify", "st_simplify.dbSpatial" ] }, { "page": "st_translate", "title": "Translate x, y coordinates by delta x, delta y for point geometries", "concept": [ "geom_construction" ], "topics": [ "st_translate", "st_translate,dbSpatial-method" ] }, { "page": "st_x", "title": "Get X coordinate", "concept": [ "accessors" ], "topics": [ "st_x", "st_x,dbSpatial-method" ] }, { "page": "st_xmax", "title": "Get maximum x coordinate", "concept": [ "geom_summary" ], "topics": [ "st_xmax", "st_xmax,dbSpatial-method" ] }, { "page": "st_y", "title": "Get Y coordinate", "concept": [ "accessors" ], "topics": [ "st_y", "st_y,dbSpatial-method" ] }, { "page": "st_ymax", "title": "Get maximum y coordinate", "concept": [ "geom_summary" ], "topics": [ "st_ymax", "st_ymax,dbSpatial-method" ] }, { "page": "tail", "title": "tail method for dbSpatial", "concept": [ "dbData" ], "topics": [ "tail,dbSpatial-method" ] }, { "page": "vect-dbSpatial-method", "title": "Create SpatVector objects", "concept": [ "dbSpatial" ], "topics": [ "vect,dbSpatial-method" ] } ], "_readme": "https://github.com/dbverse-org/dbspatial-r/raw/HEAD/README.md", "_rundeps": [ "askpass", "backports", "blob", "checkmate", "class", "classInt", "cli", "connections", "cpp11", "crayon", "curl", "DBI", "dbplyr", "dbProject", "digest", "dplyr", "duckdb", "e1071", "fs", "generics", "glue", "httr", "jsonlite", "KernSmooth", "lifecycle", "magrittr", "mime", "openssl", "pillar", "pins", "pkgconfig", "proxy", "purrr", "R6", "rappdirs", "Rcpp", "rlang", "rscontract", "s2", "sf", "stringi", "stringr", "sys", "terra", "tibble", "tidyr", "tidyselect", "units", "utf8", "uuid", "vctrs", "whisker", "withr", "wk", "yaml" ], "_vignettes": [ { "source": "class_structure.Rmd", "filename": "class_structure.html", "title": "Class Structure", "engine": "knitr::rmarkdown", "headings": [ "Class Structure", "Minimal example" ], "created": "2024-01-03 03:00:59", "modified": "2026-10-23 16:48:58", "commits": 10 }, { "source": "getting_started.Rmd", "filename": "getting_started.html", "title": "Getting Started", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Creating a DuckDB connection", "Reading in spatial data from various sources", "From data.frames", "From .csv file", "From {terra} objects: SpatVector" ], "created": "2024-01-03 03:00:59", "modified": "2026-10-23 16:48:58", "commits": 9 }, { "source": "spatial_operations.Rmd", "filename": "spatial_operations.html", "title": "Spatial Operations", "engine": "knitr::rmarkdown", "headings": [ "Setup", "Geometry Operations", "Measurements", "Spatial Joins", "Convert to sf" ], "created": "2024-01-03 03:00:59", "modified": "2026-10-23 16:48:58", "commits": 16 } ], "_score": 5.8987251815894925, "_indexed": true, "_nocasepkg": "dbspatial", "_universes": [ "dbverse-org", "ed2uiz" ], "_previous": "0.1.2", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.3", "date": "2026-10-23T19:44:08.000Z", "distro": "resolute", "commit": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "fileid": "https://r2.ropensci.org/a3642359425829a2a5c00fa314b95051d5306d43b0f203da6a34bf9c75101b69", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40012684517" }, { "r": "4.6.1", "os": "linux", "version": "0.1.3", "date": "2026-10-23T19:43:48.000Z", "distro": "resolute", "commit": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "fileid": "https://r2.ropensci.org/12a67ff198e55d09f03cadce26a730a626a19035ce648387a9cb61ab3851e18c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40012684517" }, { "r": "4.5.3", "os": "mac", "version": "0.1.3", "date": "2026-10-23T20:20:30.000Z", "commit": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "fileid": "https://r2.ropensci.org/78131e0653293702999831f6092b76817a0b57113881dd7eea0d5c6473d7e719", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40012684517" }, { "r": "4.6.1", "os": "mac", "version": "0.1.3", "date": "2026-10-23T19:43:08.000Z", "commit": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "fileid": "https://r2.ropensci.org/c3af75fa2d70918846c813d00fcacece58bc7584111f619100a0fb6bc29d5936", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40012684517" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.3", "date": "2026-10-23T19:43:29.000Z", "commit": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "fileid": "https://r2.ropensci.org/0364f39c81232dcd19391b8a9aa708b0f9a045607f4a111cf485e2813bcf04d0", "status": "success", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40012684517" }, { "r": "4.7.0", "os": "win", "version": "0.1.3", "date": "2026-10-23T20:34:53.000Z", "commit": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "fileid": "https://r2.ropensci.org/091384a783ab8e57ac7d7d3c9ce092647700a0c4419e394732e2080b133cce49", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40012684517" }, { "r": "4.5.3", "os": "win", "version": "0.1.3", "date": "2026-10-23T20:38:16.000Z", "commit": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "fileid": "https://r2.ropensci.org/5f40a766e4ce2c80febf473b04e2d65d60cad608b7596917a33cdea689ec2808", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40012684517" }, { "r": "4.6.1", "os": "win", "version": "0.1.3", "date": "2026-10-23T20:16:28.000Z", "commit": "f65e12c239277a0b75267bacc4b1a368a2281c7d", "fileid": "https://r2.ropensci.org/cf39ac6641cc0344e53dbc5cadac5b144d08ec178447d3ba51b216d854b41c43", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dbverse-org/actions/runs/40012684517" } ] }