{ "_id": "6a116119acfb0bcc41ceda14", "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-01-13 19:24:58 UTC", "RemoteUrl": "https://github.com/brownag/gpkg", "RemoteRef": "HEAD", "RemoteSha": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-23 08:06:46 UTC", "User": "root" }, "Author": "Andrew Brown [aut, cre] (ORCID:\n)", "MD5sum": "30425f6422c23918da84b7305e1f9298", "_user": "brownag", "_type": "src", "_file": "gpkg_0.0.14.tar.gz", "_fileid": "c7bace3f150b82dd57d6bc7483aad128b04a3a0d3ad0c6cac43fc9ac824e8b7a", "_filesize": 240869, "_sha256": "c7bace3f150b82dd57d6bc7483aad128b04a3a0d3ad0c6cac43fc9ac824e8b7a", "_created": "2026-05-23T08:06:46.000Z", "_published": "2026-05-23T08:11:05.602Z", "_distro": "noble", "_jobs": [ { "job": 77508255262, "time": 146, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "7175530931" }, { "job": 77508255266, "time": 135, "config": "linux-release-x86_64", "r": "4.6.0", "check": "ERROR", "artifact": "7175529806" }, { "job": 77508255282, "time": 227, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7175535574" }, { "job": 77508255275, "time": 161, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7175530850" }, { "job": 77508116149, "time": 160, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7175517353" }, { "job": 77508255236, "time": 105, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7175527045" }, { "job": 77508255238, "time": 225, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7175538096" }, { "job": 77508255255, "time": 221, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7175537673" }, { "job": 77508255258, "time": 189, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7175534795" } ], "_buildurl": "https://github.com/r-universe/brownag/actions/runs/26327640512", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/brownag/gpkg", "_commit": { "id": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "author": "dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>", "committer": "GitHub ", "message": "build(deps): bump JamesIves/github-pages-deploy-action (#40)\n\nBumps [JamesIves/github-pages-deploy-action](https://github.com/jamesives/github-pages-deploy-action) from 4.7.6 to 4.8.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.7.6...v4.8.0)\n\n---\nupdated-dependencies:\n- dependency-name: JamesIves/github-pages-deploy-action\n dependency-version: 4.8.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": 1768332298 }, "_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 }, "_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": 1, "_updates": [ { "week": "2025-31", "n": 1 }, { "week": "2025-52", "n": 1 }, { "week": "2026-01", "n": 8 }, { "week": "2026-03", "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": 180, "uuid": 20842828 } ], "_userbio": { "uuid": 20842828, "type": "user", "name": "Andrew Gene Brown", "description": "let the beauty we love be what we do. there are hundreds of ways to kneel and kiss the ground." }, "_downloads": { "count": 419, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/gpkg" }, "_devurl": "https://github.com/brownag/gpkg", "_pkgdown": "https://humus.rocks/gpkg/", "_searchresults": 35, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/gpkg.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_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": 6.702430536445526, "_indexed": true, "_nocasepkg": "gpkg", "_universes": [ "brownag" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.14", "date": "2026-05-23T08:08:56.000Z", "distro": "noble", "commit": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "fileid": "185e96c677cff5604a3addf1f319f54781fc5557ea0099a185284e3eb4338dac", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/brownag/actions/runs/26327640512" }, { "r": "4.6.0", "os": "linux", "version": "0.0.14", "date": "2026-05-23T08:08:47.000Z", "distro": "noble", "commit": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "fileid": "a09e6617e095b2a7a5987c02d58feae0b27f5f590fc14c59019ff21ed3678c96", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/brownag/actions/runs/26327640512" }, { "r": "4.5.3", "os": "mac", "version": "0.0.14", "date": "2026-05-23T08:09:59.000Z", "commit": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "fileid": "77d11ad882cda8170cd3829e84ec483122f49f5d6b8f2b66bb0266ee2385d1a3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/26327640512" }, { "r": "4.6.0", "os": "mac", "version": "0.0.14", "date": "2026-05-23T08:09:08.000Z", "commit": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "fileid": "7cff9fc3545486af17d57c2b0fc3948f529b641ebadce2f75f294bb937db87cd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/26327640512" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.14", "date": "2026-05-23T08:08:47.000Z", "commit": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "fileid": "6dc90de5b7231300ce7d42260d435748c49de9798466234f99b0dff2986bfc4a", "status": "success", "buildurl": "https://github.com/r-universe/brownag/actions/runs/26327640512" }, { "r": "4.7.0", "os": "win", "version": "0.0.14", "date": "2026-05-23T08:10:09.000Z", "commit": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "fileid": "e66b496b34e19fd39332dc9555246e3df7ec83b05053334f0d8aa61e9cafbd6e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/26327640512" }, { "r": "4.5.3", "os": "win", "version": "0.0.14", "date": "2026-05-23T08:10:07.000Z", "commit": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "fileid": "ee93a327a49bedce641d43fa2f04ff7fe82ee6760f5a9445b6593cecb77653bd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/26327640512" }, { "r": "4.6.0", "os": "win", "version": "0.0.14", "date": "2026-05-23T08:09:41.000Z", "commit": "a3c317aeee883c215be0f345f78d7c4f6053f07b", "fileid": "6aaa199833cc6c43a0b0b28e43df5a62178676a9a5fa46818b39611973f2273f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brownag/actions/runs/26327640512" } ] }