get.all.SRDLdb: 'get.all.SRDLdb' retrieves entire SMRU Access database
In embiuw/rSRDL: Communicate with SMRU SRDL Access (Windows only) and PostreSQL (platform independent) databases
Description
Usage
Arguments
Details
Value
Author(s)
See Also
Examples
Description
get.all.SRDLdb retrieves entire SMRU Access database
Usage
1
get.all.SRDLdb(theDB = "ct34", thePath = "C:/MamVisAD/SMRUAccessDatabases")
Arguments
theDB
Name of database as defined in ODBC data sources
thePath
Path to folder where database is located, if running in 64-bit R.
Details
The database must first be set up as a DSN data source.
Note! On Windows, by default only 32-bit data sources can be used
and R (or RStudio) has to be run in 32-bit mode for these functions to work.
However, functionality has now been extended (experimental for now) to run under 64-bit R.
For this to worl, the path to the database must be specified.
Value
Returns a list of data frames, each corresponding to a SMRU Access data table.
Author(s)
Martin Biuw
See Also
tables.SRDLdb for database table names,
fields.SRDLdb for table field names,
ref.SRDLdb for ref ID codes,
dep.SRDLdb for retrieving deployments metadata
get.SRDLdb for retrieving single tables based on given selection criteria
Examples
1
dive <- get.all.SRDLdb('ct34')
embiuw/rSRDL documentation built on Jan. 27, 2021, 8:11 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Details Value Author(s) See Also Examples
Description
get.all.SRDLdb retrieves entire SMRU Access database
Usage
1 | get.all.SRDLdb(theDB = "ct34", thePath = "C:/MamVisAD/SMRUAccessDatabases")
|
Arguments
theDB |
Name of database as defined in ODBC data sources |
thePath |
Path to folder where database is located, if running in 64-bit R. |
Details
The database must first be set up as a DSN data source. Note! On Windows, by default only 32-bit data sources can be used and R (or RStudio) has to be run in 32-bit mode for these functions to work. However, functionality has now been extended (experimental for now) to run under 64-bit R. For this to worl, the path to the database must be specified.
Value
Returns a list of data frames, each corresponding to a SMRU Access data table.
Author(s)
Martin Biuw
See Also
tables.SRDLdb for database table names,
fields.SRDLdb for table field names,
ref.SRDLdb for ref ID codes,
dep.SRDLdb for retrieving deployments metadata
get.SRDLdb for retrieving single tables based on given selection criteria
Examples
1 | dive <- get.all.SRDLdb('ct34')
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.