{ "_id": "6a105f03acfb0bcc41ca5ea9", "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-05-08 09:10:19 UTC", "User": "root" }, "Author": "Adrian Cidre Gonzalez [aut, cre] (ORCID:\n),\nMathieu Basille [aut] (ORCID: ),\nDavid Bucklin [aut]", "Maintainer": "Adrian Cidre Gonzalez ", "MD5sum": "4ccc677f20bb0c95030340a22d71f8b6", "_user": "cidree", "_type": "src", "_file": "rpostgis_1.6.0.tar.gz", "_fileid": "d025650e7d768f57e627e66afd6f03bc8402ee5ae0fd958e50a114bdeeb75eba", "_filesize": 17172039, "_sha256": "d025650e7d768f57e627e66afd6f03bc8402ee5ae0fd958e50a114bdeeb75eba", "_created": "2026-05-08T09:10:19.000Z", "_published": "2026-05-22T13:49:55.713Z", "_distro": "noble", "_jobs": [ { "job": 77392911298, "time": 211, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6875806870" }, { "job": 77392911726, "time": 203, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6875804989" }, { "job": 77392911940, "time": 525, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6875908664" }, { "job": 77392911351, "time": 160, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6875827406" }, { "job": 77392911199, "time": 207, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6875746138" }, { "job": 77392910739, "time": 131, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7162112540" }, { "job": 77392911342, "time": 170, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6875793726" }, { "job": 77392911892, "time": 167, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6875792619" }, { "job": 77392911683, "time": 605, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6875912606" } ], "_buildurl": "https://github.com/r-universe/cidree/actions/runs/25547150266", "_status": "success", "_host": "GitHub-Actions", "_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", "uuid": 96820235, "orcid": "0000-0002-3310-3052" }, "_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", "description": "R | Shiny | Google Earth Engine | Python | Remote Sensing | Data science & Analytics" }, "_downloads": { "count": 668, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/rpostgis" }, "_devurl": "https://github.com/cidree/rpostgis", "_pkgdown": "https://cidree.github.io/rpostgis/", "_searchresults": 286, "_rbuild": "4.6.0", "_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.137607270504631, "_indexed": true, "_nocasepkg": "rpostgis", "_universes": [ "cidree" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.6.0", "date": "2026-05-08T09:13:01.000Z", "distro": "noble", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "d8d01bd5fa537688fa20f19f0024a5f7c75385ecff4c0e1983e0b2523bce3893", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/25547150266" }, { "r": "4.6.0", "os": "linux", "version": "1.6.0", "date": "2026-05-08T09:13:01.000Z", "distro": "noble", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "67566415f988526dbdeec7e0594c35985e7a15bcf7b164ef12417a5c1602cf0c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/25547150266" }, { "r": "4.5.3", "os": "mac", "version": "1.6.0", "date": "2026-05-08T09:19:00.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "834be1b5ca7559ec0f4846401fe62d7535d483fe65600cec2ba6883bf4c592ea", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/25547150266" }, { "r": "4.6.0", "os": "mac", "version": "1.6.0", "date": "2026-05-08T09:14:38.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "e892605d6bce5a967e0e1f855f136420af1e881a61e313ce3741016399ab5ef9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/25547150266" }, { "r": "4.7.0", "os": "win", "version": "1.6.0", "date": "2026-05-08T09:11:58.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "f4cdb3f20fa0fd2ec728668511af226792df27477855e53d145d6f0aaa6c89d1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/25547150266" }, { "r": "4.5.3", "os": "win", "version": "1.6.0", "date": "2026-05-08T09:11:55.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "0eac1b3bed8c5daa060f39f91effdd0a486345900a77fed2ade3b29066d5abb8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/25547150266" }, { "r": "4.6.0", "os": "win", "version": "1.6.0", "date": "2026-05-08T09:18:35.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "05f11ff78b5af170484b254bc554845fa5c0eed274743630defff42c9fda17fc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/25547150266" }, { "r": "4.6.0", "os": "wasm", "version": "1.6.0", "date": "2026-05-22T13:49:35.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "75c8c8aed13226760efd192cbd0cd3d182b21a368bc04845561f9c2ef093757d", "status": "success", "buildurl": "https://github.com/r-universe/cidree/actions/runs/25547150266" } ] }