{
  "_id": "6a3abc1044e65c5976a8fb71",
  "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 <brown.andrewg@gmail.com>",
  "Description": "Build Open Geospatial Consortium 'GeoPackage' files\n(<https://www.geopackage.org/>). '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-06-23 14:25:51 UTC",
  "RemoteUrl": "https://github.com/brownag/gpkg",
  "RemoteRef": "HEAD",
  "RemoteSha": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-06-23 16:48:38 UTC",
    "User": "root"
  },
  "Author": "Andrew Brown [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-4565-533X>)",
  "MD5sum": "9d5439c2a31006a7fd85d1c21380fa7a",
  "_user": "brownag",
  "_type": "src",
  "_file": "gpkg_0.0.14.tar.gz",
  "_fileid": "8fbaef9682764f27317115d81feaab01bfde8ecde8c1460dbe4ff95b08756b4b",
  "_filesize": 246366,
  "_sha256": "8fbaef9682764f27317115d81feaab01bfde8ecde8c1460dbe4ff95b08756b4b",
  "_created": "2026-06-23T16:48:38.000Z",
  "_published": "2026-06-23T17:02:08.843Z",
  "_distro": "resolute",
  "_jobs": [
    {
      "job": 83010463828,
      "time": 143,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "7827512758"
    },
    {
      "job": 83010463818,
      "time": 141,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "ERROR",
      "artifact": "7827512132"
    },
    {
      "job": 83010463840,
      "time": 96,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7827771100"
    },
    {
      "job": 83010463789,
      "time": 91,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7827755921"
    },
    {
      "job": 83009832779,
      "time": 173,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7827454818"
    },
    {
      "job": 83010463868,
      "time": 110,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7827499400"
    },
    {
      "job": 83010463785,
      "time": 118,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7827502714"
    },
    {
      "job": 83010463822,
      "time": 122,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7827504291"
    },
    {
      "job": 83010463813,
      "time": 122,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7827520786"
    }
  ],
  "_buildurl": "https://github.com/r-universe/brownag/actions/runs/28041805841",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/brownag/gpkg",
  "_commit": {
    "id": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
    "author": "dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "build(deps): bump actions/checkout from 6 to 7 (#41)\n\nBumps [actions/checkout](https://github.com/actions/checkout) from 6 to 7.\n- [Release notes](https://github.com/actions/checkout/releases)\n- [Changelog](https://github.com/actions/checkout/blob/main/CHANGELOG.md)\n- [Commits](https://github.com/actions/checkout/compare/v6...v7)\n\n---\nupdated-dependencies:\n- dependency-name: actions/checkout\n  dependency-version: '7'\n  dependency-type: direct:production\n  update-type: version-update:semver-major\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>\nCo-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>",
    "time": 1782224751
  },
  "_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
    },
    {
      "week": "2026-26",
      "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",
    "followers": 204,
    "description": "let the beauty we love be what we do. there are hundreds of ways to kneel and kiss the ground."
  },
  "_downloads": {
    "count": 375,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/gpkg"
  },
  "_devurl": "https://github.com/brownag/gpkg",
  "_pkgdown": "https://humus.rocks/gpkg/",
  "_searchresults": 36,
  "_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.811575005870593,
  "_indexed": true,
  "_nocasepkg": "gpkg",
  "_universes": [
    "brownag"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.0.14",
      "date": "2026-06-23T16:50:47.000Z",
      "distro": "resolute",
      "commit": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
      "fileid": "dffbd55c8626ae3d5376f42f544c08eb24ec430376ccef6df48f327fd7a0c788",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/brownag/actions/runs/28041805841"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.0.14",
      "date": "2026-06-23T16:50:45.000Z",
      "distro": "resolute",
      "commit": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
      "fileid": "95b8aab01fb77cc0ecef67ae4d9b05f741247e4feb1b867b746050c0878b7e7d",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/brownag/actions/runs/28041805841"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.0.14",
      "date": "2026-06-23T17:01:20.000Z",
      "commit": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
      "fileid": "cbe6a8da4983c66d948fa96e47146ee19b05b3defc678b7d97e663c0c8e19155",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/brownag/actions/runs/28041805841"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.0.14",
      "date": "2026-06-23T17:00:43.000Z",
      "commit": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
      "fileid": "c1787e71389676edef0dd3acbb76310646d4547c609a4f0dfd3532cdd9f0516b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/brownag/actions/runs/28041805841"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.0.14",
      "date": "2026-06-23T16:50:42.000Z",
      "commit": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
      "fileid": "768eca8e68748e9661bd689b7973b0510b8e382e7f9e64ef15ddeba3a28c8dc9",
      "status": "success",
      "buildurl": "https://github.com/r-universe/brownag/actions/runs/28041805841"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.0.14",
      "date": "2026-06-23T16:50:08.000Z",
      "commit": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
      "fileid": "237e586699704073bbbea9dc4c4bb9223a559eef592bfb21e7cce2723e95345f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/brownag/actions/runs/28041805841"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.0.14",
      "date": "2026-06-23T16:50:15.000Z",
      "commit": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
      "fileid": "8f1694bf27cc64d9fb2f87b676b9534fe7e6449a3574aaaca68433d399ee1de2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/brownag/actions/runs/28041805841"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.0.14",
      "date": "2026-06-23T16:50:55.000Z",
      "commit": "e0cd94c6c6103b6f6742656ef9d0b53f35933257",
      "fileid": "53cc62b2618a2931779c78343263e5b73fa7cf8fa6d2473ae9751afabfd1a334",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/brownag/actions/runs/28041805841"
    }
  ]
}