Package: rpostgis 1.6.0

rpostgis: R Interface to a 'PostGIS' Database

Provides an interface between R and 'PostGIS'-enabled 'PostgreSQL' databases to transparently transfer spatial data. Both vector (points, lines, polygons) and raster data are supported in read and write modes. Also provides convenience functions to execute common procedures in 'PostgreSQL/PostGIS'.

Authors:Adrian Cidre Gonzalez [aut, cre], Mathieu Basille [aut], David Bucklin [aut]

rpostgis_1.6.0.tar.gz
rpostgis_1.6.0.zip(r-4.5)rpostgis_1.6.0.zip(r-4.4)rpostgis_1.6.0.zip(r-4.3)
rpostgis_1.6.0.tgz(r-4.5-any)rpostgis_1.6.0.tgz(r-4.4-any)rpostgis_1.6.0.tgz(r-4.3-any)
rpostgis_1.6.0.tar.gz(r-4.5-noble)rpostgis_1.6.0.tar.gz(r-4.4-noble)
rpostgis_1.6.0.tgz(r-4.4-emscripten)rpostgis_1.6.0.tgz(r-4.3-emscripten)
rpostgis.pdf |rpostgis.html✨
rpostgis/json (API)
NEWS

# Install 'rpostgis' in R:

install.packages('rpostgis', repos = c('https://cidree.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/cidree/rpostgis/issues

Pkgdown site:https://cidree.github.io

On CRAN:

postgis postgresql-database

7.67 score 79 stars 2 packages 244 scripts 810 downloads 23 exports 19 dependencies

Last updated 4 months agofrom:192197a76b. Checks:1 OK, 8 ERROR. Indexed: yes.

Target	Result	Latest binary
Doc / Vignettes	OK	Mar 06 2025
R-4.5-win	ERROR	Mar 06 2025
R-4.5-mac	ERROR	Mar 06 2025
R-4.5-linux	ERROR	Mar 06 2025
R-4.4-win	ERROR	Mar 06 2025
R-4.4-mac	ERROR	Mar 06 2025
R-4.4-linux	ERROR	Mar 06 2025
R-4.3-win	ERROR	Mar 06 2025
R-4.3-mac	ERROR	Mar 06 2025

Exports:dbAddKey dbAsDate dbColumn dbComment dbDrop dbIndex dbReadDataFrame dbSchema dbTableInfo dbVacuum dbWriteDataFrame pgGetBoundary pgGetGeom pgGetRast pgInsert pgListGeom pgListRast pgMakePts pgMakeStp pgPostGIS pgSRID pgWriteGeom pgWriteRast

Dependencies:class classInt cli DBI e1071 glue KernSmooth lifecycle magrittr MASS proxy Rcpp rlang RPostgreSQL s2 sf terra units wk

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Add key.	dbAddKey
Converts to timestamp.	dbAsDate
Add or remove a column.	dbColumn
Comment table/view/schema.	dbComment
Drop table/view/schema.	dbDrop
Create an index.	dbIndex
Check and create schema.	dbSchema
Get information about table columns.	dbTableInfo
Vacuum.	dbVacuum
Write/read in data frame mode to/from database table.	dbReadDataFrame dbReadDF dbWriteDataFrame dbWriteDF
Retrieve bounding envelope of geometries or rasters.	pgGetBoundary
Load a PostGIS geometry from a PostgreSQL table/view/query into R.	pgGetGeom
Load raster from PostGIS database into R.	pgGetRast
Inserts data into a PostgreSQL table.	pgInsert
List geometries/rasters	pgListGeom pgListRast
Add a POINT or LINESTRING geometry field.	pgMakePts pgMakeStp
Check and create PostGIS extension.	pgPostGIS
Find (or create) PostGIS SRID based on CRS object.	pgSRID
Inserts data into a PostgreSQL table.	pgWriteGeom print.pgi
Write raster to PostGIS database table.	pgWriteRast