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:
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
Last updated 3 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:dbAddKeydbAsDatedbColumndbCommentdbDropdbIndexdbReadDataFramedbSchemadbTableInfodbVacuumdbWriteDataFramepgGetBoundarypgGetGeompgGetRastpgInsertpgListGeompgListRastpgMakePtspgMakeStppgPostGISpgSRIDpgWriteGeompgWriteRast
Dependencies:classclassIntcliDBIe1071glueKernSmoothlatticelifecyclemagrittrMASSproxypurrrrasterRcpprlangRPostgreSQLs2sfspterraunitsvctrswk
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 |