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✨
DESCRIPTION |NEWS
card.svg |card.png
rpostgis/json (API)

# 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.16 score 80 stars 2 packages 301 scripts 512 downloads 23 exports 17 dependencies

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

Target	Result	Time
linux-devel-x86_64	OK	193
source / vignettes	OK	205
linux-release-x86_64	OK	210
macos-release-arm64	OK	156
macos-oldrel-arm64	OK	158
windows-devel	OK	170
windows-release	OK	155
windows-oldrel	OK	151
wasm-release	OK	119

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