{ "_id": "6a4ca08d07c3fd5c3260e9c9", "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-07-07 06:40:13 UTC", "User": "root" }, "Author": "Adrian Cidre Gonzalez [aut, cre] (ORCID:\n),\nMathieu Basille [aut] (ORCID: ),\nDavid Bucklin [aut]", "Maintainer": "Adrian Cidre Gonzalez ", "_user": "cidree", "_type": "src", "_file": "rpostgis_1.6.0.tar.gz", "_fileid": "https://r2.ropensci.org/cf8910d4874dd255fed93d74ccb63dc5fa3780318332534d6dfeabe81d61e4b4", "_filesize": 17172293, "_sha256": "cf8910d4874dd255fed93d74ccb63dc5fa3780318332534d6dfeabe81d61e4b4", "_expires": "2026-10-15T06:45:30.000Z", "_created": "2026-07-07T06:40:13.000Z", "_published": "2026-07-07T06:45:33.270Z", "_jobs": [ { "job": 85552763023, "time": 267, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8129999107" }, { "job": 85552763026, "time": 261, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8129997533" }, { "job": 85552763007, "time": 137, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8129961601" }, { "job": 85552762967, "time": 115, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8129955787" }, { "job": 85552274143, "time": 204, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8129922620" }, { "job": 85552763019, "time": 177, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8129972712" }, { "job": 85552763008, "time": 164, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8129969635" }, { "job": 85552762981, "time": 160, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8129968713" }, { "job": 85552763031, "time": 178, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8129973117" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/cidree/actions/runs/28846710057", "_status": "success", "_upstream": "https://github.com/cidree/rpostgis", "_commit": { "id": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "author": "Cidree ", "committer": "Cidree ", "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": 89, "description": "R | Shiny | Google Earth Engine | Python | Remote Sensing | Data science & Analytics" }, "_downloads": { "count": 641, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/rpostgis" }, "_devurl": "https://github.com/cidree/rpostgis", "_pkgdown": "https://cidree.github.io/rpostgis/", "_searchresults": 301, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/rpostgis.html", "manual.pdf" ], "_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", "MASS", "proxy", "Rcpp", "rlang", "RPostgreSQL", "s2", "sf", "terra", "units", "wk" ], "_score": 7.159807732969431, "_indexed": true, "_nocasepkg": "rpostgis", "_universes": [ "cidree" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.6.0", "date": "2026-07-07T06:43:34.000Z", "distro": "resolute", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "https://r2.ropensci.org/657cfed08b4decf080c1afdc404c56eeefc7b8a08d591b6998bdc257cf011ed0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28846710057" }, { "r": "4.6.1", "os": "linux", "version": "1.6.0", "date": "2026-07-07T06:43:35.000Z", "distro": "resolute", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "https://r2.ropensci.org/f4de132941913e25443af364a712c76df734dfdc2cb02c03d96bb2d64753ce84", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28846710057" }, { "r": "4.5.3", "os": "mac", "version": "1.6.0", "date": "2026-07-07T06:41:58.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "https://r2.ropensci.org/328b935a07d35000cb7bd511af0f0e4377341991d9fe69c57c545f380b5b4033", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28846710057" }, { "r": "4.6.1", "os": "mac", "version": "1.6.0", "date": "2026-07-07T06:41:51.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "https://r2.ropensci.org/60303744cfbe4c0be6e2326486bf64427c32c45a3644af977a94214cfbf0131d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28846710057" }, { "r": "4.6.0", "os": "wasm", "version": "1.6.0", "date": "2026-07-07T06:43:37.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "https://r2.ropensci.org/28e4af741e828fa90915b4bf3e519477ea9f38a127e664f5fcd71b6a5a3dae79", "status": "success", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28846710057" }, { "r": "4.7.0", "os": "win", "version": "1.6.0", "date": "2026-07-07T06:41:47.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "https://r2.ropensci.org/c438d9675daf4aa1c7dc795affb1dfdba215141016bfc4bdd35e165cd8c5b6e8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28846710057" }, { "r": "4.5.3", "os": "win", "version": "1.6.0", "date": "2026-07-07T06:41:43.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "https://r2.ropensci.org/d771445daf64378788d8b37aa29ec2cf176993dd63892af5950f6b02de6d1f3f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28846710057" }, { "r": "4.6.1", "os": "win", "version": "1.6.0", "date": "2026-07-07T06:41:50.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "https://r2.ropensci.org/241fdd4bb11a5f9efcc4e460a7b10ac8bec7aff30e1d6b5ebb1eb97e9fc1cc8f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28846710057" } ] }