Package: rpostgis 1.5.1.900

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:Adrián Cidre González [aut, cre], Mathieu Basille [aut], David Bucklin [aut]

rpostgis_1.5.1.900.tar.gz
rpostgis_1.5.1.900.zip(r-4.5)rpostgis_1.5.1.900.zip(r-4.4)rpostgis_1.5.1.900.zip(r-4.3)
rpostgis_1.5.1.900.tgz(r-4.4-any)rpostgis_1.5.1.900.tgz(r-4.3-any)
rpostgis_1.5.1.900.tar.gz(r-4.5-noble)rpostgis_1.5.1.900.tar.gz(r-4.4-noble)
rpostgis_1.5.1.900.tgz(r-4.4-emscripten)rpostgis_1.5.1.900.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

On CRAN:

postgis postgresql-database

7.61 score 77 stars 1 packages 293 scripts 638 downloads 23 exports 24 dependencies

Last updated 2 months agofrom:df806b8ec0. Checks:OK: 1 ERROR: 6. Indexed: yes.

Target	Result	Date
Doc / Vignettes	OK	Oct 27 2024
R-4.5-win	ERROR	Oct 27 2024
R-4.5-linux	ERROR	Oct 27 2024
R-4.4-win	ERROR	Oct 27 2024
R-4.4-mac	ERROR	Oct 27 2024
R-4.3-win	ERROR	Oct 27 2024
R-4.3-mac	ERROR	Oct 27 2024

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 lattice lifecycle magrittr MASS proxy purrr raster Rcpp rlang RPostgreSQL s2 sf sp terra units vctrs 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