rpostgis: R Interface to a 'PostGIS' Database

Share:

Provides additional functions to the 'RPostgreSQL' package to interface R with a 'PostGIS'-enabled database, as well as convenient wrappers to common 'PostgreSQL' queries.

Author
Mathieu Basille [aut], David Bucklin [aut, cre]
Date of publication
2016-10-29 00:04:11
Maintainer
David Bucklin <dbucklin@ufl.edu>
License
GPL (>= 3)
Version
1.0.3
URLs

View on CRAN

Man pages

dbAddKey
Add key.
dbAsDate
Converts to timestamp.
dbBuildTableQuery
Builds CREATE TABLE query for a data frame object.
dbColumn
Add or remove a column.
dbComment
Comment table/view/schema.
dbConnCheck
Check if a supported PostgreSQL connection
dbDrop
Drop table/view/schema.
dbExistsTable
Check if a PostgreSQL table exists
dbIndex
Create an index.
dbSchema
Check and create schema.
dbTableInfo
Get information about table columns.
dbTableNameFix
Format input for database schema/table names.
dbVacuum
Vacuum.
dbVersion
Returns major.minor version of PostgreSQL (for version...
pgGetBoundary
Retrieve bounding envelope of geometries or rasters.
pgGetGeom
Load a PostGIS geometry from a PostgreSQL table/view into R.
pgGetLines
Load a PostGIS linestring geometry from a PostgreSQL...
pgGetPolys
Load a PostGIS polygon geometry from a PostgreSQL table/view...
pgGetPts
Load a PostGIS point geometry from a PostgreSQL table/view...
pgGetRast
Load raster from PostGIS database.
pgInsert
Inserts data into a PostgreSQL table.
pgInsertizeGeom
Format R data objects for insert into a PostgreSQL table.
pgListGeom
List geometries.
pgMakePts
Add a POINT or LINESTRING geometry field.
pgPostGIS
Check and create PostGIS extension.
pgSRID
Find (or create) PostGIS SRID based on CRS object.
rpostgis
R interface to a PostGIS database.

Files in this package

rpostgis
rpostgis/NAMESPACE
rpostgis/NEWS
rpostgis/R
rpostgis/R/pgInsertize.R
rpostgis/R/pgGetGeom.R
rpostgis/R/pgGetRast.R
rpostgis/R/dbIndex.R
rpostgis/R/pgInsert.R
rpostgis/R/pgMakePts.R
rpostgis/R/dbVacuum.R
rpostgis/R/dbAddKey.R
rpostgis/R/dbAsDate.R
rpostgis/R/dbTableInfo.R
rpostgis/R/dbDrop.R
rpostgis/R/pgGetBoundary.R
rpostgis/R/pgListGeom.R
rpostgis/R/pgSRID.R
rpostgis/R/dbUtils.R
rpostgis/R/dbComment.R
rpostgis/R/pgPostGIS.R
rpostgis/R/dbSchema.R
rpostgis/R/rpostgis-package.R
rpostgis/R/dbColumn.R
rpostgis/README.md
rpostgis/MD5
rpostgis/DESCRIPTION
rpostgis/man
rpostgis/man/rpostgis.Rd
rpostgis/man/pgInsertizeGeom.Rd
rpostgis/man/dbBuildTableQuery.Rd
rpostgis/man/pgInsert.Rd
rpostgis/man/pgMakePts.Rd
rpostgis/man/pgListGeom.Rd
rpostgis/man/dbTableInfo.Rd
rpostgis/man/dbVacuum.Rd
rpostgis/man/dbDrop.Rd
rpostgis/man/dbAddKey.Rd
rpostgis/man/pgGetGeom.Rd
rpostgis/man/pgSRID.Rd
rpostgis/man/dbColumn.Rd
rpostgis/man/dbExistsTable.Rd
rpostgis/man/dbAsDate.Rd
rpostgis/man/dbIndex.Rd
rpostgis/man/dbTableNameFix.Rd
rpostgis/man/pgGetRast.Rd
rpostgis/man/pgGetPts.Rd
rpostgis/man/pgGetLines.Rd
rpostgis/man/dbVersion.Rd
rpostgis/man/dbConnCheck.Rd
rpostgis/man/pgPostGIS.Rd
rpostgis/man/dbComment.Rd
rpostgis/man/dbSchema.Rd
rpostgis/man/pgGetBoundary.Rd
rpostgis/man/pgGetPolys.Rd