{ "_id": "6a25150a4b233be19838b260", "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-06-07 06:47:35 UTC", "User": "root" }, "Author": "Adrian Cidre Gonzalez [aut, cre] (ORCID:\n),\nMathieu Basille [aut] (ORCID: ),\nDavid Bucklin [aut]", "Maintainer": "Adrian Cidre Gonzalez ", "MD5sum": "5c571598297a499cb35a07ba9bbeee02", "_user": "cidree", "_type": "src", "_file": "rpostgis_1.6.0.tar.gz", "_fileid": "c674d66c7d0443523d67b1b646b1ffdb692e09e86db81c557294384ef73c30b1", "_filesize": 17172425, "_sha256": "c674d66c7d0443523d67b1b646b1ffdb692e09e86db81c557294384ef73c30b1", "_created": "2026-06-07T06:47:35.000Z", "_published": "2026-06-07T06:51:54.647Z", "_distro": "noble", "_jobs": [ { "job": 79938581310, "time": 193, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7461615474" }, { "job": 79938581311, "time": 210, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7461617513" }, { "job": 79938581271, "time": 158, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7461611171" }, { "job": 79938581267, "time": 156, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7461610947" }, { "job": 79938393423, "time": 205, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7461592903" }, { "job": 79938581282, "time": 119, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7461606746" }, { "job": 79938581313, "time": 170, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7461612610" }, { "job": 79938581312, "time": 151, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7461610638" }, { "job": 79938581306, "time": 155, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7461610844" } ], "_buildurl": "https://github.com/r-universe/cidree/actions/runs/27085247714", "_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", "description": "R | Shiny | Google Earth Engine | Python | Remote Sensing | Data science & Analytics", "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": 512, "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.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.159807732969431, "_indexed": true, "_nocasepkg": "rpostgis", "_universes": [ "cidree" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.6.0", "date": "2026-06-07T06:50:01.000Z", "distro": "noble", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "4469814a1ea98f2058249e842fd63bd0b473fb27a5ef27a2e02b6893eb4431fb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/27085247714" }, { "r": "4.6.0", "os": "linux", "version": "1.6.0", "date": "2026-06-07T06:50:13.000Z", "distro": "noble", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "e73d8cc42c7e8b5352a9b4caa5306134295df43cfd364a5db6df0ebf7d764e1d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/27085247714" }, { "r": "4.5.3", "os": "mac", "version": "1.6.0", "date": "2026-06-07T06:49:43.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "b3d00d16e6861498e05faba7ea8fb2cc5c187e33022f94ccc536098f5fff8109", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/27085247714" }, { "r": "4.6.0", "os": "mac", "version": "1.6.0", "date": "2026-06-07T06:49:43.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "46f771c7d8a842462ccd395df7f79b40f10e52f2f97d44f2e641043f3ab7eea6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/27085247714" }, { "r": "4.6.0", "os": "wasm", "version": "1.6.0", "date": "2026-06-07T06:50:04.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "03822f3cb7a69b9603247c47bfff299fd20c8f81dce46578816d0d7361156321", "status": "success", "buildurl": "https://github.com/r-universe/cidree/actions/runs/27085247714" }, { "r": "4.7.0", "os": "win", "version": "1.6.0", "date": "2026-06-07T06:49:20.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "9a9e8783ab92ab0a70376fc2d93d11e88b92fa8a9106acc1dca16d6c5734f446", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/27085247714" }, { "r": "4.5.3", "os": "win", "version": "1.6.0", "date": "2026-06-07T06:49:06.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "60406ac51c21f14ff1e44e390a2ee4888011907cc97d0009d363c13e6e8ce668", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/27085247714" }, { "r": "4.6.0", "os": "win", "version": "1.6.0", "date": "2026-06-07T06:49:03.000Z", "commit": "192197a76bf8998afc8bb10868dcf5c91bcfcedb", "fileid": "1039af7ea5b4b9d985273f9b23dda9f550f62399f22d62876310cdd69f2838d6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/27085247714" } ] }