odbcConnectManifold: ODBC connection to Manifold map files.

In mdsumner/manifoldr: Facilities for Manifold System

Description

Create an ODBC connection for Manifold GIS.

Usage

odbcConnectManifold(mapfile, unicode = TRUE, ansi = FALSE, opengis = TRUE)

Arguments

mapfile	character string, path to Manifold project *.map file
unicode	logical
ansi	logical
opengis	logical

Details

See odbcDriverConnect

See the documentation for the underlying driver: http://www.georeference.org/doc/using_the_manifold_odbc_driver.htm Be sure to set ansi = FALSE for some string escape cases like CoordSys("Drawing" AS COMPONENT).

Value

RODBC object

Examples

## Not run: 
f <- system.file("extdata", "AreaDrawing.map", package = "manifoldr")
#con <- odbcConnectManifold(f)
#tab <- RODBC::sqlQuery(con, "SELECT * FROM [Drawing]")
## drop [Geom (I)] and give a summary
#summary(subset(tab, select = -`Geom (I)`))

## issue a spatial query
qtx <- "SELECT [ID], [Name], [Length (I)] AS [Perim], 
     BranchCount([ID]) AS [nbranches] FROM [Drawing Table]"
#sq <- RODBC::sqlQuery(con, qtx)
#sq

## End(Not run)

mdsumner/manifoldr documentation built on May 22, 2019, 4:45 p.m.