Package: rpostgis 1.6.0
Adrian Cidre Gonzalez
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:
rpostgis_1.6.0.tar.gz
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://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/cidree/rpostgis/issues
Pkgdown site:https://cidree.github.io
Last updated 20 days agofrom:3b79d99262. Checks:OK: 2. Indexed: no.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Dec 06 2024 |
| R-4.5-linux | OK | Dec 06 2024 |
Exports:dbAddKeydbAsDatedbColumndbCommentdbDropdbIndexdbReadDataFramedbSchemadbTableInfodbVacuumdbWriteDataFramepgGetBoundarypgGetGeompgGetRastpgInsertpgListGeompgListRastpgMakePtspgMakeStppgPostGISpgSRIDpgWriteGeompgWriteRast
Dependencies:classclassIntcliDBIe1071glueKernSmoothlifecyclemagrittrMASSproxyRcpprlangRPostgreSQLs2sfterraunitswk
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 |
