Description Usage Arguments Details Value Examples
Create an ODBC connection for Manifold GIS.
1 | odbcConnectManifold(mapfile, unicode = TRUE, ansi = FALSE, opengis = TRUE)
|
mapfile |
character string, path to Manifold project *.map file |
unicode |
logical |
ansi |
logical |
opengis |
logical |
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).
RODBC object
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | ## 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)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.