sf_readSQL: Read Spatial SQL Table to sf
In MARC-GIS/marcR: Helpful Functions Used By The MARC-GIS Team

Description Usage Arguments Value Creation notes Author(s) Examples

View source: R/DBIhelpers.R

Is basically a wrapper around sf::st_read() that does a necessary transformation on the SQL geometry datatype to read in as a sf table

1	sf_readSQL(conn, schema, tableName, geomCol)

`conn`	A `DBIConnection` object, as returned by `dbConnect()`.
`schema`	Name of schema that table is under. character vector of length 1.
`tableName`	Name of table. character vector of length 1.
`geomCol`	Character vector of length 1 containing the name of the geometry column in the SQL table

An sf object

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

Jacob Peterson

## Not run: 
library(DBI)

con <- connectODBC("DB_MARC_PRD.marcdl")

#This is not set up to be a real example
tableColNames <- sf_readSQL(con, "marcdl", "TestTable", "geom")

## End(Not run)