{ "_id": "6a61f9a335834fefe99ec01b", "Package": "DuckDBSpatial", "Version": "0.99.00", "Date": "2026-07-19", "Title": "DuckDB-Backed Spatial Data Structures", "Description": "Provides DuckDB-backed implementations of spatial data\nstructures for efficient out-of-memory operations on large\nspatial datasets. The package includes 68 sf-compatible spatial\nmethods (st_intersects, st_contains, st_within, etc.) and\nGeoParquet 1.0 I/O support via writeGeoParquet(). Ideal for\nspatial analysis, genomic interval analysis, and integration\nwith BiocDuckDB for MultiAssaySpatialExperiment workflows\nrequiring memory-efficient operations on large datasets.", "Authors@R": "c(\nperson(\"Patrick\", \"Aboyoun\", role=c(\"aut\", \"cre\"), email=\"aboyounp@gene.com\"),\nperson(\"Genentech, Inc.\", role=\"cph\")\n)", "License": "MIT + file LICENSE", "biocViews": "DataImport, DataRepresentation, Infrastructure, Software", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Collate": "'DuckDBTable-spatial.R' 'DuckDBColumn-spatial.R'\n'DuckDBDataFrame-spatial.R' 'coordinate-transform-graph.R'\n'coordinate-transforms.R' 'geoparquet-io.R'\n'points-coord-index.R' 'writeGeoParquet.R' 'zzz.R'", "Config/roxygen2/version": "8.0.0", "Config/pak/sysreqs": "libabsl-dev cmake libgdal-dev gdal-bin libgeos-dev\nlibicu-dev libssl-dev libproj-dev libsqlite3-dev\nlibudunits2-dev xz-utils zlib1g-dev", "Repository": "https://biocstaging.r-universe.dev", "Date/Publication": "2026-07-21 15:15:41 UTC", "RemoteUrl": "https://github.com/BiocStaging/DuckDBSpatial", "RemoteRef": "HEAD", "RemoteSha": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-23 11:09:57 UTC", "User": "root" }, "Author": "Patrick Aboyoun [aut, cre],\nGenentech, Inc. [cph]", "Maintainer": "Patrick Aboyoun ", "_user": "biocstaging", "_type": "src", "_file": "DuckDBSpatial_0.99.00.tar.gz", "_fileid": "https://r2.ropensci.org/e94ce4c278e8ccf15dcbe7b0cbee248c4287f9b5230b0676448403d625d7ddbb", "_filesize": 307243, "_sha256": "e94ce4c278e8ccf15dcbe7b0cbee248c4287f9b5230b0676448403d625d7ddbb", "_expires": "2026-10-31T11:23:14.000Z", "_created": "2026-07-23T11:09:57.000Z", "_published": "2026-07-23T11:23:15.750Z", "_bioccheck": { "error": 0, "warning": 1, "note": 11 }, "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001835468", "_status": "success", "_upstream": "https://github.com/BiocStaging/DuckDBSpatial", "_commit": { "id": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "author": "Patrick Aboyoun ", "committer": "Patrick Aboyoun ", "message": "package cleanup\n", "time": 1784646941 }, "_maintainer": { "name": "Patrick Aboyoun", "email": "aboyounp@gene.com" }, "_distro": "resolute", "_jobs": [ { "job": 89189552297, "time": 199, "config": "bioc-checks", "r": "4.6.1", "check": "WARNING", "artifact": "8561503510" }, { "job": 89189552318, "time": 309, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8561551808" }, { "job": 89189552311, "time": 317, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8561555541" }, { "job": 89189552365, "time": 209, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8561683309" }, { "job": 89189552377, "time": 345, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8561736869" }, { "job": 89188632342, "time": 264, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8561410805" }, { "job": 89189552381, "time": 199, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8561503698" }, { "job": 89189552428, "time": 434, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8561606307" }, { "job": 89189552437, "time": 392, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "8561589005" }, { "job": 89189552446, "time": 394, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8561590250" } ], "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.5.0", "role": "Depends" }, { "package": "methods", "role": "Depends" }, { "package": "DuckDBDataFrame", "role": "Depends" }, { "package": "sf", "role": "Depends" }, { "package": "BiocGenerics", "role": "Imports" }, { "package": "S4Vectors", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "BiocStyle", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" }, { "package": "jsonlite", "role": "Suggests" }, { "package": "lwgeom", "role": "Suggests" }, { "package": "nanoparquet", "role": "Suggests" } ], "_owner": "biocstaging", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-09", "n": 1 }, { "week": "2026-10", "n": 4 }, { "week": "2026-11", "n": 1 }, { "week": "2026-19", "n": 1 }, { "week": "2026-23", "n": 1 }, { "week": "2026-24", "n": 2 }, { "week": "2026-25", "n": 1 }, { "week": "2026-27", "n": 1 }, { "week": "2026-28", "n": 2 }, { "week": "2026-29", "n": 7 }, { "week": "2026-30", "n": 4 } ], "_tags": [], "_topics": [ "dataimport", "datarepresentation", "infrastructure", "software" ], "_stars": 0, "_contributors": [ { "user": "aboyounp-gne", "count": 27, "uuid": 171627243 } ], "_userbio": { "uuid": 278472782, "type": "organization", "name": "BiocStaging", "followers": 1 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/DuckDBSpatial" }, "_devurl": "https://github.com/biocstaging/duckdbspatial", "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/DuckDBSpatial.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE", "manual.pdf" ], "_cranurl": false, "_exports": [ "asCoordinateTransform", "coordinateSystem", "ctAffine", "ctAffineMatrix", "ctApply", "ctBetween", "ctBijection", "ctByDimension", "ctGraph", "ctIdentity", "ctInvert", "ctMapAxis", "ctPath", "ctRotation", "ctScale", "ctSequence", "ctTranslation", "enableGeoParquetConversion", "layerBboxRange", "layerSpatialMatch", "layerSpatialOverlaps", "layerSubsetByBbox", "layerSubsetByGeometry", "readGeoParquet", "spatialSortPoints", "st_affine", "st_build_area", "st_collect", "st_collect_agg", "st_contains", "st_contains_properly", "st_covered_by", "st_covers", "st_crosses", "st_dimension", "st_disjoint", "st_distance", "st_end_point", "st_envelope", "st_envelope_agg", "st_equals", "st_flip_coordinates", "st_geometry_type", "st_geomfromtext_sql", "st_inscribed_circle", "st_intersects_table", "st_is_closed", "st_is_empty", "st_is_ring", "st_is_simple", "st_is_within_distance", "st_length", "st_line_interpolate", "st_line_project", "st_line_substring", "st_make_envelope_sql", "st_num_geometries", "st_num_interior_rings", "st_num_points", "st_overlaps", "st_perimeter", "st_point_sql", "st_reduce_precision", "st_remove_repeated_points", "st_start_point", "st_touches", "st_union_agg", "st_within", "st_within_properly", "transformLayer", "writeGeoParquet", "writeSpatialPointsParquet" ], "_help": [ { "page": "asCoordinateTransform", "title": "Coerce a transform dict into a CoordinateTransform", "topics": [ "asCoordinateTransform" ] }, { "page": "coordinate-transforms", "title": "Coordinate-transform constructors (OME-NGFF RFC-5)", "topics": [ "coordinate-transforms", "ctAffine", "ctBijection", "ctByDimension", "ctIdentity", "ctMapAxis", "ctRotation", "ctScale", "ctSequence", "ctTranslation" ] }, { "page": "coordinateSystem", "title": "Define a named coordinate system", "topics": [ "coordinateSystem" ] }, { "page": "ctAffineMatrix", "title": "Lower a coordinate transform to a homogeneous affine matrix", "topics": [ "ctAffineMatrix" ] }, { "page": "ctApply", "title": "Apply a coordinate transform to a matrix of points", "topics": [ "ctApply" ] }, { "page": "ctBetween", "title": "Transform points between two coordinate systems", "topics": [ "ctBetween" ] }, { "page": "ctGraph", "title": "Build a coordinate-transform graph", "topics": [ "ctGraph" ] }, { "page": "ctInvert", "title": "Invert a coordinate transform", "topics": [ "ctInvert" ] }, { "page": "ctPath", "title": "Resolve the transform between two coordinate systems", "topics": [ "ctPath" ] }, { "page": "DuckDBColumn-spatial", "title": "Spatial operations on DuckDBColumn objects", "topics": [ "DuckDBColumn-spatial", "st_area.DuckDBColumn", "st_as_binary.DuckDBColumn", "st_as_sfc.DuckDBColumn", "st_as_text.DuckDBColumn", "st_bbox.DuckDBColumn", "st_boundary.DuckDBColumn", "st_buffer.DuckDBColumn", "st_build_area.DuckDBColumn", "st_centroid.DuckDBColumn", "st_collect.DuckDBColumn", "st_collection_extract.DuckDBColumn", "st_concave_hull.DuckDBColumn", "st_contains.DuckDBColumn", "st_contains_properly.DuckDBColumn", "st_convex_hull.DuckDBColumn", "st_coordinates.DuckDBColumn", "st_covered_by.DuckDBColumn", "st_covers.DuckDBColumn", "st_crosses.DuckDBColumn", "st_difference.DuckDBColumn", "st_dimension.DuckDBColumn", "st_disjoint.DuckDBColumn", "st_distance.DuckDBColumn", "st_end_point.DuckDBColumn", "st_envelope.DuckDBColumn", "st_equals.DuckDBColumn", "st_exterior_ring.DuckDBColumn", "st_flip_coordinates.DuckDBColumn", "st_geometry_type.DuckDBColumn", "st_inscribed_circle.DuckDBColumn", "st_intersection.DuckDBColumn", "st_intersects.DuckDBColumn", "st_is_closed.DuckDBColumn", "st_is_empty.DuckDBColumn", "st_is_ring.DuckDBColumn", "st_is_simple.DuckDBColumn", "st_is_valid.DuckDBColumn", "st_is_within_distance.DuckDBColumn", "st_length.DuckDBColumn", "st_line_interpolate.DuckDBColumn", "st_line_merge.DuckDBColumn", "st_line_project.DuckDBColumn", "st_line_substring.DuckDBColumn", "st_make_valid.DuckDBColumn", "st_minimum_rotated_rectangle.DuckDBColumn", "st_nearest_points.DuckDBColumn", "st_node.DuckDBColumn", "st_normalize.DuckDBColumn", "st_num_geometries.DuckDBColumn", "st_num_interior_rings.DuckDBColumn", "st_num_points.DuckDBColumn", "st_overlaps.DuckDBColumn", "st_perimeter.DuckDBColumn", "st_point_on_surface.DuckDBColumn", "st_reduce_precision.DuckDBColumn", "st_remove_repeated_points.DuckDBColumn", "st_reverse.DuckDBColumn", "st_simplify.DuckDBColumn", "st_start_point.DuckDBColumn", "st_touches.DuckDBColumn", "st_union.DuckDBColumn", "st_voronoi.DuckDBColumn", "st_within.DuckDBColumn", "st_within_properly.DuckDBColumn" ] }, { "page": "DuckDBTable-spatial", "title": "Spatial operations on DuckDBTable objects", "topics": [ "DuckDBTable-spatial", "st_area.DuckDBTable", "st_as_binary.DuckDBTable", "st_as_sfc.DuckDBTable", "st_as_text.DuckDBTable", "st_boundary.DuckDBTable", "st_buffer.DuckDBTable", "st_build_area", "st_build_area.default", "st_build_area.DuckDBTable", "st_centroid.DuckDBTable", "st_collect", "st_collect.default", "st_collection_extract.DuckDBTable", "st_collect_agg", "st_concave_hull.DuckDBTable", "st_contains", "st_contains.default", "st_contains.DuckDBTable", "st_contains_properly", "st_contains_properly.default", "st_contains_properly.DuckDBTable", "st_convex_hull.DuckDBTable", "st_covered_by", "st_covered_by.default", "st_covered_by.DuckDBTable", "st_covers", "st_covers.default", "st_covers.DuckDBTable", "st_crosses", "st_crosses.default", "st_crosses.DuckDBTable", "st_difference.DuckDBTable", "st_dimension", "st_dimension.default", "st_dimension.DuckDBTable", "st_disjoint", "st_disjoint.default", "st_disjoint.DuckDBTable", "st_distance", "st_distance.default", "st_distance.DuckDBTable", "st_end_point", "st_end_point.default", "st_end_point.DuckDBTable", "st_envelope", "st_envelope.DuckDBTable", "st_envelope_agg", "st_equals", "st_equals.default", "st_equals.DuckDBTable", "st_exterior_ring.DuckDBTable", "st_filter.DuckDBTable", "st_flip_coordinates", "st_flip_coordinates.default", "st_flip_coordinates.DuckDBTable", "st_geometry_type", "st_geometry_type.default", "st_geometry_type.DuckDBTable", "st_geomfromtext_sql", "st_inscribed_circle", "st_inscribed_circle.default", "st_inscribed_circle.DuckDBTable", "st_intersection.DuckDBTable", "st_intersects.DuckDBTable", "st_intersects_table", "st_is_closed", "st_is_closed.default", "st_is_closed.DuckDBTable", "st_is_empty", "st_is_empty.default", "st_is_empty.DuckDBTable", "st_is_ring", "st_is_ring.default", "st_is_ring.DuckDBTable", "st_is_simple", "st_is_simple.default", "st_is_simple.DuckDBTable", "st_is_valid.DuckDBTable", "st_is_within_distance", "st_is_within_distance.default", "st_is_within_distance.DuckDBTable", "st_join.DuckDBTable", "st_length", "st_length.default", "st_length.DuckDBTable", "st_line_interpolate", "st_line_interpolate.default", "st_line_interpolate.DuckDBTable", "st_line_merge.DuckDBTable", "st_line_project", "st_line_project.default", "st_line_project.DuckDBTable", "st_line_substring", "st_line_substring.default", "st_line_substring.DuckDBTable", "st_make_envelope_sql", "st_make_valid.DuckDBTable", "st_minimum_rotated_rectangle.DuckDBTable", "st_nearest_points.DuckDBTable", "st_node.DuckDBTable", "st_normalize.DuckDBTable", "st_num_geometries", "st_num_geometries.default", "st_num_geometries.DuckDBTable", "st_num_interior_rings", "st_num_interior_rings.default", "st_num_interior_rings.DuckDBTable", "st_num_points", "st_num_points.default", "st_num_points.DuckDBTable", "st_overlaps", "st_overlaps.default", "st_overlaps.DuckDBTable", "st_perimeter", "st_perimeter.default", "st_perimeter.DuckDBTable", "st_point_on_surface.DuckDBTable", "st_point_sql", "st_reduce_precision", "st_reduce_precision.default", "st_reduce_precision.DuckDBTable", "st_remove_repeated_points", "st_remove_repeated_points.default", "st_remove_repeated_points.DuckDBTable", "st_reverse.DuckDBTable", "st_simplify.DuckDBTable", "st_start_point", "st_start_point.default", "st_start_point.DuckDBTable", "st_touches", "st_touches.default", "st_touches.DuckDBTable", "st_union.DuckDBTable", "st_union_agg", "st_voronoi.DuckDBTable", "st_within", "st_within.default", "st_within.DuckDBTable", "st_within_properly", "st_within_properly.default", "st_within_properly.DuckDBTable" ] }, { "page": "enableGeoParquetConversion", "title": "Enable DuckDB GeoParquet conversion on a connection", "topics": [ "enableGeoParquetConversion" ] }, { "page": "layerBboxRange", "title": "Subset a points layer to a bounding box with a prunable range predicate", "topics": [ "layerBboxRange" ] }, { "page": "layerSpatialMatch", "title": "Match points in a lazy table layer to a geometry table", "topics": [ "layerSpatialMatch" ] }, { "page": "layerSpatialOverlaps", "title": "Test spatial intersection for a lazy table layer", "topics": [ "layerSpatialOverlaps" ] }, { "page": "layerSubsetByBbox", "title": "Row indices of a layer inside a bounding box", "topics": [ "layerSubsetByBbox" ] }, { "page": "layerSubsetByGeometry", "title": "Row indices of a layer intersecting a geometry", "topics": [ "layerSubsetByGeometry" ] }, { "page": "readGeoParquet", "title": "Read a GeoParquet file as a lazy 'DuckDBDataFrame'", "topics": [ "readGeoParquet" ] }, { "page": "spatialSortPoints", "title": "Reorder a points table by a Morton (Z-order) spatial key", "topics": [ "spatialSortPoints" ] }, { "page": "st_affine", "title": "Apply a 2-D affine coordinate transform to geometries", "topics": [ "st_affine" ] }, { "page": "transformLayer", "title": "Apply a coordinate transform to a spatial layer", "topics": [ "transformLayer" ] }, { "page": "writeGeoParquet", "title": "Write spatial data as GeoParquet", "topics": [ "writeGeoParquet" ] }, { "page": "writeSpatialPointsParquet", "title": "Write a coord-indexed (Morton-sorted) points Parquet", "topics": [ "writeSpatialPointsParquet" ] } ], "_readme": "https://github.com/BiocStaging/DuckDBSpatial/raw/HEAD/README.md", "_rundeps": [ "abind", "arrow", "assertthat", "BiocGenerics", "bit", "bit64", "blob", "class", "classInt", "cli", "cpp11", "DBI", "dbplyr", "DelayedArray", "dplyr", "duckdb", "DuckDBDataFrame", "e1071", "generics", "glue", "IRanges", "KernSmooth", "lattice", "lifecycle", "magrittr", "MASS", "Matrix", "MatrixGenerics", "matrixStats", "pillar", "pkgconfig", "proxy", "purrr", "R6", "Rcpp", "rlang", "s2", "S4Arrays", "S4Vectors", "sf", "SparseArray", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "units", "utf8", "vctrs", "withr", "wk", "XVector" ], "_vignettes": [ { "source": "DuckDBSpatial.Rmd", "filename": "DuckDBSpatial.html", "title": "Introduction to DuckDBSpatial", "author": "Patrick Aboyoun", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Installation", "Lazy spatial columns", "Spatial predicates and filtering", "Layer-level engines for coordinate columns", "GeoParquet I/O", "When to use DuckDBSpatial", "Session information" ], "created": "2026-07-06 22:44:21", "modified": "2026-07-08 14:22:07", "commits": 2 }, { "source": "DuckDBSpatial-design.Rmd", "filename": "DuckDBSpatial-design.html", "title": "Design and extension of DuckDBSpatial", "author": "Patrick Aboyoun", "engine": "knitr::rmarkdown", "headings": [ "Scope", "Architecture", "From sf generics to spatial SQL", "Two dispatch paths", "GeoParquet I/O", "Extending, and the BiocDuckDB integration", "Session information" ], "created": "2026-07-06 22:44:21", "modified": "2026-07-08 14:22:07", "commits": 2 } ], "_score": 4.041392685158225, "_indexed": true, "_nocasepkg": "duckdbspatial", "_universes": [ "biocstaging" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.99.00", "date": "2026-07-23T11:13:02.000Z", "distro": "resolute", "commit": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "fileid": "https://r2.ropensci.org/323ceb143689bbc9d31799bcb3ec7a066a564a1d667bb717b36e9778459927cf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001835468" }, { "r": "4.6.1", "os": "linux", "version": "0.99.00", "date": "2026-07-23T11:12:56.000Z", "distro": "resolute", "commit": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "fileid": "https://r2.ropensci.org/88dc6737312bb287be74398b4a5a3aaf4b99a1bd21c24c1cf473b9c7e4c66b33", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001835468" }, { "r": "4.5.3", "os": "mac", "version": "0.99.00", "date": "2026-07-23T11:18:44.000Z", "commit": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "fileid": "https://r2.ropensci.org/f4c89ef98c0db3607698211be0c526d7a5b92c796501890426d31da9d2f112db", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001835468" }, { "r": "4.6.1", "os": "mac", "version": "0.99.00", "date": "2026-07-23T11:19:10.000Z", "commit": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "fileid": "https://r2.ropensci.org/b34fc00bdf7317ba799ee713ceca2cbde9e0f2f97c7cc8acca2b8e5924d2b33b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001835468" }, { "r": "4.6.0", "os": "wasm", "version": "0.99.00", "date": "2026-07-23T11:13:51.000Z", "commit": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "fileid": "https://r2.ropensci.org/c817077d584f25589f18935f594647a5a6f9df7f697c75066811d963dde89bca", "status": "success", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001835468" }, { "r": "4.7.0", "os": "win", "version": "0.99.00", "date": "2026-07-23T11:15:06.000Z", "commit": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "fileid": "https://r2.ropensci.org/af23ba189ad40ad32de65e9a85e92a32af9ec7fb867150c11f32260b2e82fa51", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001835468" }, { "r": "4.5.3", "os": "win", "version": "0.99.00", "date": "2026-07-23T11:13:45.000Z", "commit": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "fileid": "https://r2.ropensci.org/741a264f2b7a688ec19195d03131c3a4d0d05bc001d3634904fb7c0d258d5279", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001835468" }, { "r": "4.6.1", "os": "win", "version": "0.99.00", "date": "2026-07-23T11:14:09.000Z", "commit": "1018d2fe81246b4a659df93fbb26ee6a724f3454", "fileid": "https://r2.ropensci.org/49954178c44bdb28e9e990dc45581e0e7a7509e7143fd7dcc6b55105f0fd409f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/30001835468" } ] }