DBI_appendSFtoTable: Append sf table to a Microsoft SQL table
In MARC-KC/marcR: Helpful Functions Used By The MARC-GIS Team

DBI_appendSFtoTable

R Documentation

Append sf table to a Microsoft SQL table

Description

Usage

DBI_appendSFtoTable(
  conn,
  sfTable,
  schema,
  tableName,
  createTableQuery = NULL,
  warnings = getOption("warn")
)

Arguments

`conn`	A `DBIConnection` object, as returned by `dbConnect()`.
`sfTable`	sf object to append to specified database table
`schema`	Name of schema that table is under. character vector of length 1.
`tableName`	Name of table. character vector of length 1.
`createTableQuery`	Currently unused. Always NULL
`warnings`	Warning key. Use `-1` to hide warning messages in function.

Creation notes

First created on 2020-11-03 with the script OSMdownloadAndSFtoSQLInterface.R in the MARC-KC/HelpLibrary Repository

Author(s)

Jacob Peterson

Examples

## Not run: 
library(DBI)

con <- connectODBC("<servername>.<databaseName>.<schemaName>")

#This is not set up to be a real example
tableColNames <- DBI_appendSFtoTable(con, sfTable, "<schemaName>", "<tableName>")

## End(Not run)

MARC-KC/marcR documentation built on June 2, 2022, 9:31 p.m.