{
  "_id": "6ac36699d743750d376db76c",
  "Package": "rpostgis",
  "Version": "1.6.0",
  "Date": "2024-12-05",
  "Title": "R Interface to a 'PostGIS' Database",
  "Description": "Provides an interface between R and 'PostGIS'-enabled\n'PostgreSQL' databases to transparently transfer spatial data.\nBoth vector (points, lines, polygons) and raster data are\nsupported in read and write modes. Also provides convenience\nfunctions to execute common procedures in 'PostgreSQL/PostGIS'.",
  "Authors@R": "c(\nperson(\"Adrian\", \"Cidre Gonzalez\",\nemail = \"adrian.cidre@gmail.com\",\nrole = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-3310-3052\")),\nperson(\"Mathieu\", \"Basille\", email = \"mathieu@basille.org\",\nrole = c(\"aut\"),\ncomment = c(ORCID = \"0000-0001-9366-7127\")),\nperson(\"David\", \"Bucklin\",\nemail = \"david.bucklin@gmail.com\",\nrole = c(\"aut\")))",
  "SystemRequirements": "'PostgreSQL' with 'PostGIS' extension",
  "License": "GPL (>= 3)",
  "URL": "https://cidree.github.io/rpostgis/,\nhttps://github.com/Cidree/rpostgis",
  "BugReports": "https://github.com/Cidree/rpostgis/issues",
  "RoxygenNote": "7.3.2",
  "Encoding": "UTF-8",
  "Config/testthat/edition": "3",
  "Roxygen": "list(markdown = TRUE)",
  "Config/pak/sysreqs": "libabsl-dev cmake libgdal-dev gdal-bin libgeos-dev\nlibssl-dev libpq-dev libproj-dev libsqlite3-dev libudunits2-dev",
  "Repository": "https://cidree.r-universe.dev",
  "Date/Publication": "2024-12-06 10:23:44 UTC",
  "RemoteUrl": "https://github.com/cidree/rpostgis",
  "RemoteRef": "HEAD",
  "RemoteSha": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-05 08:53:44 UTC",
    "User": "root"
  },
  "Author": "Adrian Cidre Gonzalez [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-3310-3052>),\nMathieu Basille [aut] (ORCID: <https://orcid.org/0000-0001-9366-7127>),\nDavid Bucklin [aut]",
  "Maintainer": "Adrian Cidre Gonzalez <adrian.cidre@gmail.com>",
  "_user": "cidree",
  "_type": "src",
  "_file": "rpostgis_1.6.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/5b198f7a973b55ba580874db9e0513053240f45cbc163a369a758dab1ccf4353",
  "_filesize": 17169073,
  "_sha256": "5b198f7a973b55ba580874db9e0513053240f45cbc163a369a758dab1ccf4353",
  "_expires": "2027-01-13T08:57:58.000Z",
  "_created": "2026-10-05T08:53:44.000Z",
  "_published": "2026-10-05T08:58:01.210Z",
  "_jobs": [
    {
      "job": 111686750915,
      "time": 170,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11334980541"
    },
    {
      "job": 111686750817,
      "time": 190,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11335015999"
    },
    {
      "job": 111686750647,
      "time": 160,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11334676901"
    },
    {
      "job": 111686750743,
      "time": 144,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11334687151"
    },
    {
      "job": 111685416110,
      "time": 232,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11333874277"
    },
    {
      "job": 111686750852,
      "time": 120,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11335045451"
    },
    {
      "job": 111686750772,
      "time": 157,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11334796899"
    },
    {
      "job": 111686750885,
      "time": 116,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11334727034"
    },
    {
      "job": 111686750832,
      "time": 166,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11333884697"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/cidree/actions/runs/37286094348",
  "_status": "success",
  "_upstream": "https://github.com/cidree/rpostgis",
  "_commit": {
    "id": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
    "author": "Cidree <adrian.cidre@gmail.com>",
    "committer": "Cidree <adrian.cidre@gmail.com>",
    "message": "update website\n",
    "time": 1733480624
  },
  "_maintainer": {
    "name": "Adrian Cidre Gonzalez",
    "email": "adrian.cidre@gmail.com",
    "login": "cidree",
    "linkedin": "in/adrian-cidre",
    "description": "R | Shiny | Google Earth Engine | Python | Remote Sensing | Data science & Analytics",
    "uuid": 96820235,
    "orcid": "0000-0002-3310-3052"
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.3.0",
      "role": "Depends"
    },
    {
      "package": "RPostgreSQL",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "version": ">= 0.5",
      "role": "Depends"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "sf",
      "role": "Imports"
    },
    {
      "package": "stats",
      "role": "Imports"
    },
    {
      "package": "terra",
      "version": ">= 1.6.7",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "RPostgres",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "sp",
      "role": "Suggests"
    },
    {
      "package": "raster",
      "role": "Suggests"
    }
  ],
  "_owner": "cidree",
  "_selfowned": true,
  "_usedby": 2,
  "_updates": [],
  "_tags": [],
  "_topics": [
    "postgis",
    "postgresql-database"
  ],
  "_stars": 80,
  "_contributors": [
    {
      "user": "dnbucklin",
      "count": 270,
      "uuid": 12412492
    },
    {
      "user": "cidree",
      "count": 101,
      "uuid": 96820235
    },
    {
      "user": "basille",
      "count": 15,
      "uuid": 4000337
    }
  ],
  "_userbio": {
    "uuid": 96820235,
    "type": "user",
    "name": "Adrian Cidre",
    "followers": 91,
    "description": "R | Shiny | Google Earth Engine | Python | Remote Sensing | Data science & Analytics"
  },
  "_downloads": {
    "count": 590,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/rpostgis"
  },
  "_devurl": "https://github.com/cidree/rpostgis",
  "_pkgdown": "https://cidree.github.io/rpostgis/",
  "_searchresults": 309,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/rpostgis.html"
  ],
  "_homeurl": "https://github.com/cidree/rpostgis",
  "_realowner": "cidree",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.0.0",
      "date": "2016-08-20"
    },
    {
      "version": "1.0.2",
      "date": "2016-09-26"
    },
    {
      "version": "1.0.3",
      "date": "2016-10-28"
    },
    {
      "version": "1.1.0",
      "date": "2017-01-06"
    },
    {
      "version": "1.1.1",
      "date": "2017-01-18"
    },
    {
      "version": "1.2.0",
      "date": "2017-03-14"
    },
    {
      "version": "1.2.1",
      "date": "2017-05-07"
    },
    {
      "version": "1.3.0",
      "date": "2017-06-30"
    },
    {
      "version": "1.4.0",
      "date": "2017-12-10"
    },
    {
      "version": "1.4.1",
      "date": "2018-08-17"
    },
    {
      "version": "1.4.2",
      "date": "2018-11-12"
    },
    {
      "version": "1.4.3",
      "date": "2019-11-20"
    },
    {
      "version": "1.4.4",
      "date": "2023-05-06"
    },
    {
      "version": "1.5.0",
      "date": "2023-10-12"
    },
    {
      "version": "1.5.1",
      "date": "2023-11-20"
    },
    {
      "version": "1.6.0",
      "date": "2024-12-06"
    }
  ],
  "_exports": [
    "dbAddKey",
    "dbAsDate",
    "dbColumn",
    "dbComment",
    "dbDrop",
    "dbIndex",
    "dbReadDataFrame",
    "dbSchema",
    "dbTableInfo",
    "dbVacuum",
    "dbWriteDataFrame",
    "pgGetBoundary",
    "pgGetGeom",
    "pgGetRast",
    "pgInsert",
    "pgListGeom",
    "pgListRast",
    "pgMakePts",
    "pgMakeStp",
    "pgPostGIS",
    "pgSRID",
    "pgWriteGeom",
    "pgWriteRast"
  ],
  "_help": [
    {
      "page": "dbAddKey",
      "title": "Add key.",
      "topics": [
        "dbAddKey"
      ]
    },
    {
      "page": "dbAsDate",
      "title": "Converts to timestamp.",
      "topics": [
        "dbAsDate"
      ]
    },
    {
      "page": "dbColumn",
      "title": "Add or remove a column.",
      "topics": [
        "dbColumn"
      ]
    },
    {
      "page": "dbComment",
      "title": "Comment table/view/schema.",
      "topics": [
        "dbComment"
      ]
    },
    {
      "page": "dbDrop",
      "title": "Drop table/view/schema.",
      "topics": [
        "dbDrop"
      ]
    },
    {
      "page": "dbIndex",
      "title": "Create an index.",
      "topics": [
        "dbIndex"
      ]
    },
    {
      "page": "dbSchema",
      "title": "Check and create schema.",
      "topics": [
        "dbSchema"
      ]
    },
    {
      "page": "dbTableInfo",
      "title": "Get information about table columns.",
      "topics": [
        "dbTableInfo"
      ]
    },
    {
      "page": "dbVacuum",
      "title": "Vacuum.",
      "topics": [
        "dbVacuum"
      ]
    },
    {
      "page": "dbWriteDataFrame",
      "title": "Write/read in data frame mode to/from database table.",
      "topics": [
        "dbReadDataFrame",
        "dbReadDF",
        "dbWriteDataFrame",
        "dbWriteDF"
      ]
    },
    {
      "page": "pgGetBoundary",
      "title": "Retrieve bounding envelope of geometries or rasters.",
      "topics": [
        "pgGetBoundary"
      ]
    },
    {
      "page": "pgGetGeom",
      "title": "Load a PostGIS geometry from a PostgreSQL table/view/query into R.",
      "topics": [
        "pgGetGeom"
      ]
    },
    {
      "page": "pgGetRast",
      "title": "Load raster from PostGIS database into R.",
      "topics": [
        "pgGetRast"
      ]
    },
    {
      "page": "pgInsert",
      "title": "Inserts data into a PostgreSQL table.",
      "topics": [
        "pgInsert"
      ]
    },
    {
      "page": "pgListGeom",
      "title": "List geometries/rasters",
      "topics": [
        "pgListGeom",
        "pgListRast"
      ]
    },
    {
      "page": "pgMakePts",
      "title": "Add a POINT or LINESTRING geometry field.",
      "topics": [
        "pgMakePts",
        "pgMakeStp"
      ]
    },
    {
      "page": "pgPostGIS",
      "title": "Check and create PostGIS extension.",
      "topics": [
        "pgPostGIS"
      ]
    },
    {
      "page": "pgSRID",
      "title": "Find (or create) PostGIS SRID based on CRS object.",
      "topics": [
        "pgSRID"
      ]
    },
    {
      "page": "pgWriteGeom",
      "title": "Inserts data into a PostgreSQL table.",
      "topics": [
        "pgWriteGeom",
        "print.pgi"
      ]
    },
    {
      "page": "pgWriteRast",
      "title": "Write raster to PostGIS database table.",
      "topics": [
        "pgWriteRast"
      ]
    }
  ],
  "_pkglogo": "https://github.com/cidree/rpostgis/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/cidree/rpostgis/raw/HEAD/README.md",
  "_rundeps": [
    "class",
    "classInt",
    "cli",
    "DBI",
    "e1071",
    "KernSmooth",
    "lifecycle",
    "proxy",
    "Rcpp",
    "rlang",
    "RPostgreSQL",
    "s2",
    "sf",
    "terra",
    "units",
    "wk"
  ],
  "_score": 7.171199716800422,
  "_indexed": true,
  "_nocasepkg": "rpostgis",
  "_universes": [
    "cidree"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.6.0",
      "date": "2026-10-05T08:56:08.000Z",
      "distro": "resolute",
      "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
      "fileid": "https://r2.ropensci.org/b376d70a34492102e91eff7f4e099fcb6d13c973f5f3d6712b1d21b1ebd34b90",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/37286094348"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.6.0",
      "date": "2026-10-05T08:56:15.000Z",
      "distro": "resolute",
      "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
      "fileid": "https://r2.ropensci.org/b23df56358b23fc1c1d941b4bed3b08726415319534e06a651edf33d5bb80e9c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/37286094348"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.6.0",
      "date": "2026-10-05T08:56:02.000Z",
      "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
      "fileid": "https://r2.ropensci.org/55f6b23d2d88711c2faf1953acc1bb6db0c0be0184c2378ca8e054ea6f4feef6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/37286094348"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.6.0",
      "date": "2026-10-05T08:55:44.000Z",
      "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
      "fileid": "https://r2.ropensci.org/a33940a1d8486973cc30bd7bde94a930bdf6eaea1c2f4c80c5333097024fc980",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/37286094348"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.6.0",
      "date": "2026-10-05T08:56:19.000Z",
      "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
      "fileid": "https://r2.ropensci.org/4c54744287e6b816da5a0ddf993e99f0ddc6c0a712e315ec6416d2646683286c",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/37286094348"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.6.0",
      "date": "2026-10-05T08:55:20.000Z",
      "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
      "fileid": "https://r2.ropensci.org/4904e82552ec289e0e33b33460a13632fcb6c4ae56a608ce19996262241da9a9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/37286094348"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.6.0",
      "date": "2026-10-05T08:55:12.000Z",
      "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
      "fileid": "https://r2.ropensci.org/4e61ffddfa9b6a4a51827a6e46369d24359a5cba276b947b21a0ad81083e743c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/37286094348"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.6.0",
      "date": "2026-10-05T08:55:21.000Z",
      "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb",
      "fileid": "https://r2.ropensci.org/2a87a5c4e19f08bf133dfcc4872bb12bc78888c46f4fedbb9bfd9f3782b9f012",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/37286094348"
    }
  ]
}