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 641 downloads 23 exports 17 dependencies

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

Target	Result	Time
linux-devel-x86_64	OK	267
source / vignettes	OK	204
linux-release-x86_64	OK	261
macos-release-arm64	OK	115
macos-oldrel-arm64	OK	137
windows-devel	OK	164
windows-release	OK	178
windows-oldrel	OK	160
wasm-release	OK	177

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