postGIStools: Tools for Interacting with 'PostgreSQL' / 'PostGIS' Databases

Functions to convert geometry and 'hstore' data types from 'PostgreSQL' into standard R objects, as well as to simplify the import of R data frames (including spatial data frames) into 'PostgreSQL'.

Author
Philippe Marchand [aut, cre], Richard Ellison [aut]
Date of publication
2016-10-10 08:28:43
Maintainer
Philippe Marchand <pmarchand@sesync.org>
License
GPL-3
Version
0.2.1
URLs

View on CRAN

Man pages

extract-hstore
Extract or replace hstore values by key
get_postgis_query
Send SELECT query and parse geometry, hstore columns
new_hstore
Create a empty hstore
postgis_insert_update
Insert or update records in a PostgreSQL table from a R data...
postGIStools-package
postGIStools: Tools for interacting with PostgreSQL / PostGIS...

Files in this package

postGIStools
postGIStools/inst
postGIStools/inst/doc
postGIStools/inst/doc/postGIStools-vignette.R
postGIStools/inst/doc/postGIStools-vignette.html
postGIStools/inst/doc/postGIStools-vignette.Rmd
postGIStools/tests
postGIStools/tests/testthat.R
postGIStools/tests/testthat
postGIStools/tests/testthat/test_insert_update.R
postGIStools/tests/testthat/test_get_query.R
postGIStools/tests/testthat/test_hstore.R
postGIStools/tests/testthat/country_sp.rds
postGIStools/NAMESPACE
postGIStools/NEWS.md
postGIStools/R
postGIStools/R/postgis_utils.R
postGIStools/R/get_postgis_query.R
postGIStools/R/postgis_insert_update.R
postGIStools/R/postGIStools.R
postGIStools/R/hstore.R
postGIStools/vignettes
postGIStools/vignettes/postGIStools-vignette.Rmd
postGIStools/README.md
postGIStools/MD5
postGIStools/build
postGIStools/build/vignette.rds
postGIStools/DESCRIPTION
postGIStools/man
postGIStools/man/extract-hstore.Rd
postGIStools/man/new_hstore.Rd
postGIStools/man/postGIStools-package.Rd
postGIStools/man/postgis_insert_update.Rd
postGIStools/man/get_postgis_query.Rd