{ "_id": "6aab8ac93d719c1f8406b6cd", "Package": "gpkg", "Type": "Package", "Title": "Utilities for the Open Geospatial Consortium 'GeoPackage' Format", "Version": "0.0.14", "Authors@R": "person(given=\"Andrew\", family=\"Brown\", email=\"brown.andrewg@gmail.com\", role=c(\"aut\", \"cre\"), comment=c(ORCID=\"0000-0002-4565-533X\"))", "Maintainer": "Andrew Brown ", "Description": "Build Open Geospatial Consortium 'GeoPackage' files\n(). 'GDAL' utilities for reading\nand writing spatial data are provided by the 'terra' package.\nAdditional 'GeoPackage' and 'SQLite' features for attributes\nand tabular data are implemented with the 'RSQLite' package.", "URL": "https://humus.rocks/gpkg/, https://github.com/brownag/gpkg", "BugReports": "https://github.com/brownag/gpkg/issues", "License": "CC0", "RoxygenNote": "7.3.3", "Roxygen": "list(markdown = TRUE)", "Encoding": "UTF-8", "LazyData": "true", "VignetteBuilder": "knitr", "Repository": "https://brownag.r-universe.dev", "Date/Publication": "2026-08-17 23:43:56 UTC", "RemoteUrl": "https://github.com/brownag/gpkg", "RemoteRef": "HEAD", "RemoteSha": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-17 06:29:54 UTC", "User": "root" }, "Author": "Andrew Brown [aut, cre] (ORCID:\n)", "_user": "brownag", "_type": "src", "_file": "gpkg_0.0.14.tar.gz", "_fileid": "https://r2.ropensci.org/b66ec12aceb3ae443133051e5d1cd652137612abeef49b28edfe24ea39b3eaea", "_filesize": 241312, "_sha256": "b66ec12aceb3ae443133051e5d1cd652137612abeef49b28edfe24ea39b3eaea", "_expires": "2026-12-26T06:37:59.000Z", "_created": "2026-09-17T06:29:54.000Z", "_published": "2026-09-17T06:38:01.407Z", "_jobs": [ { "job": 105100598351, "time": 175, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "10483527350" }, { "job": 105100598285, "time": 155, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "10483802050" }, { "job": 105100598355, "time": 149, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "10483428794" }, { "job": 105100598425, "time": 440, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10483592636" }, { "job": 105099764216, "time": 219, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10483067657" }, { "job": 105100598226, "time": 122, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10483592144" }, { "job": 105100598352, "time": 108, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10483044304" }, { "job": 105100598256, "time": 103, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10483212582" }, { "job": 105100598275, "time": 99, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10484081904" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/brownag/actions/runs/35189813847", "_status": "success", "_upstream": "https://github.com/brownag/gpkg", "_commit": { "id": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "author": "dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>", "committer": "GitHub ", "message": "build(deps): bump JamesIves/github-pages-deploy-action (#42)\n\nBumps [JamesIves/github-pages-deploy-action](https://github.com/jamesives/github-pages-deploy-action) from 4.8.0 to 4.9.0.\n- [Release notes](https://github.com/jamesives/github-pages-deploy-action/releases)\n- [Commits](https://github.com/jamesives/github-pages-deploy-action/compare/v4.8.0...v4.9.0)\n\n---\nupdated-dependencies:\n- dependency-name: JamesIves/github-pages-deploy-action\n dependency-version: 4.9.0\n dependency-type: direct:production\n update-type: version-update:semver-minor\n...\n\nSigned-off-by: dependabot[bot] \nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>", "time": 1787010236 }, "_maintainer": { "name": "Andrew Brown", "email": "brown.andrewg@gmail.com", "login": "brownag", "mastodon": "@humus_rocks@fosstodon.org", "orcid": "0000-0002-4565-533X", "twitter": "@humus_rocks", "description": "let the beauty we love be what we do. there are hundreds of ways to kneel and kiss the ground.", "uuid": 20842828 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.1.0", "role": "Depends" }, { "package": "utils", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "terra", "version": ">= 1.6", "role": "Suggests" }, { "package": "gdalraster", "role": "Suggests" }, { "package": "tinytest", "role": "Suggests" }, { "package": "sf", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "brownag", "_selfowned": true, "_usedby": 2, "_updates": [ { "week": "2025-52", "n": 1 }, { "week": "2026-01", "n": 8 }, { "week": "2026-03", "n": 1 }, { "week": "2026-26", "n": 1 }, { "week": "2026-34", "n": 1 } ], "_tags": [ { "name": "0.0.14", "date": "2026-01-13" } ], "_topics": [ "dbi", "geopackage", "geospatial", "gis", "raster", "spatial", "sqlite", "vector" ], "_stars": 24, "_contributors": [ { "user": "brownag", "count": 138, "uuid": 20842828 }, { "user": "andrewbrown-usda", "count": 42, "uuid": 302319657 } ], "_userbio": { "uuid": 20842828, "type": "user", "name": "Andrew Gene Brown", "followers": 214, "description": "let the beauty we love be what we do. there are hundreds of ways to kneel and kiss the ground." }, "_downloads": { "count": 347, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/gpkg" }, "_devurl": "https://github.com/brownag/gpkg", "_pkgdown": "https://humus.rocks/gpkg/", "_searchresults": 37, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/gpkg.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md" ], "_homeurl": "https://github.com/brownag/gpkg", "_realowner": "brownag", "_cranurl": true, "_releases": [ { "version": "0.0.7", "date": "2023-11-21" }, { "version": "0.0.8", "date": "2024-02-20" }, { "version": "0.0.12", "date": "2025-03-16" }, { "version": "0.0.14", "date": "2026-04-03" } ], "_exports": [ "geopackage", "gpkg", "gpkg_2d_gridded_coverage_ancillary", "gpkg_2d_gridded_tile_ancillary", "gpkg_add_contents", "gpkg_add_geometry_columns", "gpkg_add_metadata_extension", "gpkg_add_relatedtables_extension", "gpkg_add_spatial_ref_sys", "gpkg_bbox", "gpkg_collect", "gpkg_connect", "gpkg_connection", "gpkg_contents", "gpkg_create_2d_gridded_coverage_ancillary", "gpkg_create_2d_gridded_tile_ancillary", "gpkg_create_contents", "gpkg_create_dummy_features", "gpkg_create_empty_features", "gpkg_create_empty_grid", "gpkg_create_geometry_columns", "gpkg_create_spatial_ref_sys", "gpkg_create_spatial_view", "gpkg_default_nodata", "gpkg_delete_contents", "gpkg_delete_spatial_ref_sys", "gpkg_disconnect", "gpkg_execute", "gpkg_extensions", "gpkg_is_connected", "gpkg_list_contents", "gpkg_list_srs", "gpkg_list_tables", "gpkg_ogr_contents", "gpkg_ogr_query", "gpkg_query", "gpkg_rast", "gpkg_read", "gpkg_remove_attributes", "gpkg_sf", "gpkg_source", "gpkg_spatial_ref_sys", "gpkg_table", "gpkg_table_pragma", "gpkg_tables", "gpkg_tbl", "gpkg_tile_set_data_null", "gpkg_update_contents", "gpkg_update_table", "gpkg_validate", "gpkg_vect", "gpkg_write", "gpkg_write_attributes" ], "_datasets": [ { "name": "gpkg_creation_options", "title": "GeoPackage Creation Options", "object": "gpkg_creation_options", "class": [ "data.frame" ], "fields": [ "creation_option", "value_string", "values", "description" ], "rows": 32, "table": true, "tojson": true }, { "name": "gpkg_sqlite_tables", "title": "GeoPackage Dataset", "object": "gpkg_sqlite_tables", "class": [ "data.frame" ], "fields": [ "table_name" ], "rows": 10, "table": true, "tojson": true } ], "_help": [ { "page": "geopackage-class", "title": "'geopackage' Constructors", "topics": [ "geopackage", "geopackage.character", "geopackage.geopackage", "geopackage.list", "geopackage.missing", "geopackage.SQLiteConnection", "gpkg" ] }, { "page": "gpkg_2d_gridded_coverage_ancillary", "title": "Get 'gpkg_2d_gridded_coverage_ancillary' Table", "topics": [ "gpkg_2d_gridded_coverage_ancillary" ] }, { "page": "gpkg_2d_gridded_tile_ancillary", "title": "Get 'gpkg_2d_gridded_tile_ancillary' Table", "topics": [ "gpkg_2d_gridded_tile_ancillary" ] }, { "page": "gpkg-contents", "title": "Add, Remove, Update and Create 'gpkg_contents' table and records", "topics": [ "gpkg_add_contents", "gpkg_create_contents", "gpkg_delete_contents", "gpkg_update_contents" ] }, { "page": "gpkg_add_metadata_extension", "title": "Add 'Metadata' extension", "topics": [ "gpkg_add_metadata_extension" ] }, { "page": "gpkg_add_relatedtables_extension", "title": "Add 'Related Tables' extension", "topics": [ "gpkg_add_relatedtables_extension" ] }, { "page": "gpkg-connection", "title": "Create SQLite Connection to GeoPackage", "topics": [ "gpkg_connect", "gpkg_connect.character", "gpkg_connect.geopackage", "gpkg_connection", "gpkg_connection.default", "gpkg_disconnect", "gpkg_disconnect.geopackage", "gpkg_disconnect.SQLiteConnection", "gpkg_disconnect.src_SQLiteConnection", "gpkg_disconnect.tbl_SQLiteConnection", "gpkg_is_connected", "gpkg_is_connected.geopackage" ] }, { "page": "gpkg_contents", "title": "Get 'gpkg_contents' or 'gpkg_ogr_contents' Table", "topics": [ "gpkg_contents", "gpkg_ogr_contents" ] }, { "page": "gridded-ancillary", "title": "Create 2D Gridded Coverage and Tile Ancillary Tables", "topics": [ "gpkg_create_2d_gridded_coverage_ancillary", "gpkg_create_2d_gridded_tile_ancillary" ] }, { "page": "gpkg_create_dummy_features", "title": "Create a Dummy Feature Dataset in a GeoPackage", "topics": [ "gpkg_create_dummy_features" ] }, { "page": "gpkg-features", "title": "Create an empty feature table", "topics": [ "gpkg_create_empty_features" ] }, { "page": "gpkg_create_empty_grid", "title": "Create an empty grid table", "topics": [ "gpkg_create_empty_grid" ] }, { "page": "gpkg-geometry-columns", "title": "GeoPackage Geometry Columns", "topics": [ "gpkg_add_geometry_columns", "gpkg_create_geometry_columns" ] }, { "page": "gpkg_create_spatial_view", "title": "Create a Spatial View", "topics": [ "gpkg_create_spatial_view" ] }, { "page": "gpkg_creation_options", "title": "GeoPackage Creation Options", "topics": [ "gpkg_creation_options" ] }, { "page": "gpkg_default_nodata", "title": "Get Default NoData Value for GeoPackage Raster Datatypes", "topics": [ "gpkg_default_nodata" ] }, { "page": "gpkg_execute", "title": "Execute an SQL statement in a GeoPackage", "topics": [ "gpkg_execute" ] }, { "page": "gpkg_extensions", "title": "Get Geopackage Extensions", "topics": [ "gpkg_extensions" ] }, { "page": "gpkg_list_contents", "title": "List Tables Registered in a GeoPackage 'gpkg_contents'", "topics": [ "gpkg_list_contents" ] }, { "page": "gpkg_list_tables", "title": "List Tables in a GeoPackage", "topics": [ "gpkg_list_tables" ] }, { "page": "gpkg_query", "title": "Query a GeoPackage for Tabular Result", "topics": [ "gpkg_ogr_query", "gpkg_query" ] }, { "page": "gpkg_read", "title": "Read data from a GeoPackage", "topics": [ "gpkg_read" ] }, { "page": "gpkg_source", "title": "Get Source File of a _geopackage_ object", "topics": [ "gpkg_source", "gpkg_source.geopackage" ] }, { "page": "gpkg-srs", "title": "GeoPackage Spatial Reference System", "topics": [ "gpkg_add_spatial_ref_sys", "gpkg_create_spatial_ref_sys", "gpkg_delete_spatial_ref_sys", "gpkg_list_srs", "gpkg_spatial_ref_sys" ] }, { "page": "gpkg_sqlite_tables", "title": "GeoPackage Dataset", "topics": [ "gpkg_sqlite_tables" ] }, { "page": "gpkg_table", "title": "Lazy Access to Tables by Name", "topics": [ "gpkg_collect", "gpkg_rast", "gpkg_sf", "gpkg_table", "gpkg_table.default", "gpkg_table_pragma", "gpkg_table_pragma.default", "gpkg_tbl", "gpkg_vect" ] }, { "page": "gpkg_tables", "title": "Get Tables from a _geopackage_ object", "topics": [ "gpkg_tables", "gpkg_tables.default" ] }, { "page": "gpkg_tile_set_data_null", "title": "Set 'data_null' Metadata for a GeoPackage Tile Dataset", "topics": [ "gpkg_tile_set_data_null" ] }, { "page": "gpkg_update_table", "title": "Update a Table by Name", "topics": [ "gpkg_update_table" ] }, { "page": "gpkg_validate", "title": "Validate a GeoPackage", "topics": [ "gpkg_validate" ] }, { "page": "gpkg_write", "title": "Write data to a GeoPackage", "topics": [ "gpkg_write" ] }, { "page": "gpkg-attributes", "title": "Write or Remove Attribute Table in a GeoPackage", "topics": [ "gpkg_remove_attributes", "gpkg_write_attributes" ] } ], "_readme": "https://github.com/brownag/gpkg/raw/HEAD/README.md", "_rundeps": [ "DBI" ], "_vignettes": [ { "source": "intro.Rmd", "filename": "intro.html", "title": "Introduction to gpkg", "engine": "knitr::rmarkdown", "headings": [ "Background", "What is a GeoPackage?", "Create a Geopackage", "Insert Vector Layers", "Insert Attribute Table", "Read a GeoPackage", "Inspect Contents of GeoPackage", "Lazy Data Access", "Method 1: gpkg_table_pragma()", "Method 2: gpkg_vect() and gpkg_query()", "Method 3: gpkg_rast()", "Method 4: gpkg_table()", "Managing Connections" ], "created": "2023-12-07 05:19:34", "modified": "2025-08-02 04:04:43", "commits": 4 } ], "_score": 7.124504224834282, "_indexed": true, "_nocasepkg": "gpkg", "_universes": [ "brownag" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.14", "date": "2026-09-17T06:32:31.000Z", "distro": "resolute", "commit": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "fileid": "https://r2.ropensci.org/95accd3fda61b30d06d8d713c48fbfe46ea7e552564788179825aff7137c0b6e", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/brownag/actions/runs/35189813847" }, { "r": "4.6.1", "os": "linux", "version": "0.0.14", "date": "2026-09-17T06:32:23.000Z", "distro": "resolute", "commit": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "fileid": "https://r2.ropensci.org/474b046407c43a6c56ba50a7f7a1490644c9af5e9d5e5397773984d997204d41", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/brownag/actions/runs/35189813847" }, { "r": "4.5.3", "os": "mac", "version": "0.0.14", "date": "2026-09-17T06:32:05.000Z", "commit": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "fileid": "https://r2.ropensci.org/a6a97b03b0919ad19777b905bb420e86cce21da0d8a0b0ef7ad9c44fcf6bc2f9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/35189813847" }, { "r": "4.6.1", "os": "mac", "version": "0.0.14", "date": "2026-09-17T06:36:31.000Z", "commit": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "fileid": "https://r2.ropensci.org/92a4ddc6f807449e509bafec1ebfe6d6ccd10ca179be9a2a29bbdcbb3b00d664", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/35189813847" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.14", "date": "2026-09-17T06:32:14.000Z", "commit": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "fileid": "https://r2.ropensci.org/2431a41fc2cbf9789d95798601eddaced1d60b63de0f0c57caf59e85faea1176", "status": "success", "buildurl": "https://github.com/r-universe/brownag/actions/runs/35189813847" }, { "r": "4.7.0", "os": "win", "version": "0.0.14", "date": "2026-09-17T06:31:35.000Z", "commit": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "fileid": "https://r2.ropensci.org/c24a26443e266991493cc3d466b48725b6612c46022bef318bbbb8a1732d910b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/35189813847" }, { "r": "4.5.3", "os": "win", "version": "0.0.14", "date": "2026-09-17T06:31:15.000Z", "commit": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "fileid": "https://r2.ropensci.org/80f4255e36418bd391e02500a5b4f1ad95703e7f780f6667f2da8211852b2559", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/35189813847" }, { "r": "4.6.1", "os": "win", "version": "0.0.14", "date": "2026-09-17T06:31:14.000Z", "commit": "e37ae69c7d95e88133c38eef5691bc20aee9fbbc", "fileid": "https://r2.ropensci.org/76feddcc8e615ac6ef49e857bbe3db91cb2408540b52cad64c9b9d924a72efad", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/35189813847" } ] }