swishdbtools overview Introduction DESCRIPTION DEPRECATED DESCRIPTION-code NO TANGLE Package: swishdbtools Type: Package Title: Database tools for use with the SWISH project Version: 1.4.1 Date: 2017-11-22 Author: ivanhanigan Maintainer: <ivan.hanigan@gmail.com> Depends: foreign, rgdal, plyr Description: database tools License: GPL (>= 2) run tests package doc functions add_datadscr test-add_datadscr R-add_datadscr add_filedscr test-add_filedscr R-add_filedscr add_stdydscr test-add_stdydscr R-add_stdydscr connect2postgres test-connect2postgres R-connect2postgres man-connect2postgres connect2postgres2 R-connect2postgres2 test-connect2postgres2 man-connect2postgres2 data_inventory_etl R-data_inventory_etl test-data_inventory_etl ddiindexdb_remove_file test-ddiindexdb_remove_file R-ddiindexdb_remove_file man-ddiindexdb_remove_file ddiindexdb_sync_study test-ddiindexdb_sync_study R-ddiindexdb_sync_study man-ddiindexdb_sync_study DEPRECATED df2ddi DEPRECATED sql_insert fixGeom test-fixGeom R-fixGeom man-fixGeom get_file_extension R-get_file_extension test-get_file_extension man-get_file_extension get_passwordTable test-get_passwordTable R-get_passwordTable man-get_passwordTable get_pgpass test-get_pgpass R-get_pgpass man-get_pgpass get_pgpass_remote R-get_pgpass_remote test-get_pgpass_remote man-get_pgpass_remote getPassword test-getPassword R-getPassword man-getPassword LinuxOperatingSystem test-LinuxOperatingSystem R-LinuxOperatingSystem man-LinuxOperatingSystem load2ddiindex_data test-load2ddiindex_data R-load2ddiindex_data man-load2ddiindex_data load2ddiindex_file test-load2ddiindex_file R-load2ddiindex_file man-load2ddiindex_file load2ddiindex_study test-load2ddiindex_study R-load2ddiindex_study load2postgres test-load2postgres R-load2postgres load2postgres_raster load2postgres_shp lsos test-lsos R-lsos man-lsos make_ddixml test-make_ddixml R-make_ddixml, this is a horrible hack. rewrite with XML package pgListTables test-pgListTables R-pgListTables man-pgListTables pipe_postgres_data points2geom test-points2geom R-points2geom man-points2geom postgis_join_attributes test-postgis_join_attributes R-postgis_join_attributes man-postgis_join_attributes postgis_raster_extract test-postgis_raster_extract R-postgis_raster_extract man-postgis_raster_extract postgis_reproject R-postgis_reproject test-postgis_reproject man-postgis_reproject readGDAL2 test-readGDAL2 R-readGDAL2 man-readGDAL2 readOGR2 test-readOGR2 R-readOGR2 man-readOGR2 read_file R-read_file test-read_file man-read_file shp2pgis test-shp2pgis R-shp2pgis man-shp2pgis sql_add_column test-sql_add_column R-sql_add_column man-sql_add_column sql_add_lag test-sql_add_lag R-sql_add_lag dev-code man-sql_add_lag sql_join test-sql_join R-sql_join man-sql_join sql_subset test-sql_subset.r R-sql_subset.r man-sql_subset.Rd sql_subset_into test-sql_subset_into R-sql_subset_into sql_summarise test-sql_summarise R-sql_summarise man-sql_summarise sql_transform test-sql_transform R-sql_transform man-sql_transform rbase_tsfill rbase_tsfill sqldf_lag test-sqldf_lag R-sqldf_lag man-sqldf_lag swish_tempfile R-swish_tempfile test-swish_tempfile man-swish_tempfile swish_temptable R-swish_temptable test-swish_temptable man-swish_temptable vignettes