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.7)rpostgis_1.6.0.zip(r-4.6)rpostgis_1.6.0.zip(r-4.5)
rpostgis_1.6.0.tgz(r-4.6-any)rpostgis_1.6.0.tgz(r-4.5-any)
rpostgis_1.6.0.tar.gz(r-4.7-any)rpostgis_1.6.0.tar.gz(r-4.6-any)
rpostgis_1.6.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
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/docs site:https://cidree.github.io

On CRAN:

postgis postgresql-database

7.14 score 80 stars 2 packages 286 scripts 668 downloads 23 exports 17 dependencies

Last updated from:192197a76b. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	211
source / vignettes	OK	207
linux-release-x86_64	OK	203
macos-release-arm64	OK	160
macos-oldrel-arm64	OK	525
windows-devel	OK	170
windows-release	OK	605
windows-oldrel	OK	167
wasm-release	OK	131

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 KernSmooth lifecycle 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