RObsDat: Data Management for Hydrology and Beyond Using the Observations Data Model
Version 16.03

Data management in hydrology and other fields is facilitated with functions to enter and modify data in a database according to the Observations Data Model (ODM) standard by CUASHI (Consortium of Universities for the Advancement of Hydrologic Science). While this data model has been developed in hydrology, it is also useful for other fields. RObsDat helps in the setup of the database within one of the free database systems MariaDB, PostgreSQL or SQLite. It imports the controlled water vocabulary from the CUASHI web service and provides a smart interface between the analyst and the database: Already existing data entries are detected and duplicates avoided. The data import function converts different data table designs to make import simple. Cleaning and modifications of data are handled with a simple version control system. Variable and location names are treated in a user friendly way, accepting and processing multiple versions. When querying data from the database, it is stored in a spacetime objects within R for subsequent processing.

Browse man pages Browse package API and functions Browse package files

AuthorDominik Reusser
Date of publication2016-03-31 22:27:32
MaintainerDominik Reusser <reusser@pik-potsdam.de>
LicenseGPL
Version16.03
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("RObsDat")

Man pages

addCV: Extend controlled vocabularies
addDataValues: Add, delete or modify data to the observations database
addISOMetadata: Functions to provide reference to data sources
addOffsetType: Add detail information about Offset.
addQualityControlLevel: Add Quality metadata vocabulary
addSite: Add detail information about the observation site
addSpatialReferences: Add spatial reference system
addSynonym: Add a synonym for one of the entries in any meta data table
addUnits: Extend controlled vocabulary for units.
addVariable: Add an entry to the variables table
assembleDataWhereClause: Internal functions to generate a where clause for access to...
check.version: Internal function: check if database connection is present...
chr2date: Internal: Convert character to date object and guess time...
expandVar: Internal: make sure meta data information can be processed in...
exportSynonyms: Transfer synonyms
getDataValues: Retrieve data from the observations database
getMetadata: Get information about meta data
inherited_stfdf: Internal: Class inherited stfdf
odm1_1-class: Classes '"odm1_1"' and '"odm1_1Ver"'
odm.close: Open standard SQLite database delivered with the package and...
reload: Internal functions: helping to do things
RObsDat-package: R-Package to the observations Data Model from CUAHSI

Functions

==,inherited_stfdf,inherited_stfdf-method Man page
CVtables Man page Source code
IaddCV,odm1_1-method Man page
IaddDataValues,odm1_1-method Man page
IaddDataVersion,odm1_1-method Man page
IaddDataVersion,odm1_1Ver-method Man page
IaddISOMetadata,odm1_1-method Man page
IaddSite,odm1_1-method Man page
IaddSource,odm1_1-method Man page
IaddSpatialReferences,odm1_1-method Man page
IaddSynonym,odm1_1-method Man page
IaddUnits,odm1_1-method Man page
IaddVariable,odm1_1-method Man page
IarchiveDataValues,odm1_1-method Man page
IarchiveDataValues,odm1_1Ver-method Man page
IdbState,odm1_1-method Man page
IdbState,odm1_1Ver-method Man page
IdeleteDataValues,odm1_1-method Man page
IgetCV,odm1_1-method Man page
IgetCensorCode,odm1_1-method Man page
IgetCurrentDataVersion,odm1_1-method Man page
IgetCurrentDataVersion,odm1_1Ver-method Man page
IgetDataType,odm1_1-method Man page
IgetDataValues,odm1_1-method Man page
IgetDataVersions,odm1_1-method Man page
IgetDataVersions,odm1_1Ver-method Man page
IgetGeneralCategory,odm1_1-method Man page
IgetISOMetadata,odm1_1-method Man page
IgetMethods,odm1_1-method Man page
IgetNo,odm1_1-method Man page
IgetOffsetTypes,odm1_1-method Man page
IgetOldDataValues,odm1_1-method Man page
IgetOldDataValues,odm1_1Ver-method Man page
IgetQualifiers,odm1_1-method Man page
IgetQualityControlLevels,odm1_1-method Man page
IgetSampleMedium,odm1_1-method Man page
IgetSampleType,odm1_1-method Man page
IgetSamples,odm1_1-method Man page
IgetSite,odm1_1-method Man page
IgetSource,odm1_1-method Man page
IgetSpatialReferences,odm1_1-method Man page
IgetSpeciation,odm1_1-method Man page
IgetSynonymID,odm1_1-method Man page
IgetTopicCategory,odm1_1-method Man page
IgetUnits,odm1_1-method Man page
IgetValueType,odm1_1-method Man page
IgetVariable,odm1_1-method Man page
IgetVariableName,odm1_1-method Man page
IgetVerticalDatum,odm1_1-method Man page
IupdateDataValues,odm1_1-method Man page
RObsDat Man page
RObsDat-package Man page
[,inherited_stfdf-method Man page
addCV Man page Source code
addDataValues Man page Source code
addISOMetadata Man page Source code
addOffsetType Man page Source code
addQualityControlLevel Man page Source code
addSite Man page Source code
addSource Man page Source code
addSpatialReferences Man page Source code
addSynonym Man page Source code
addUnits Man page Source code
addVariable Man page Source code
assembleDataWhereClause Man page Source code
check.version Man page Source code
chr2date Man page Source code
cleanupMySQL Source code
createST Source code
deleteDataValues Man page Source code
exampleCommands Source code
expand.where Man page Source code
expandVar Man page Source code
exportSynonyms Man page Source code
getDataValues Man page Source code
getDataVersions Man page Source code
getDefaultDB Man page Source code
getID Man page Source code
getMetadata Man page Source code
guess.tz Man page Source code
h.m Man page Source code
id2name Man page Source code
importSynonyms Man page Source code
inherited_stfdf Man page Source code
inherited_stfdf-class Man page
longExample Source code
mdbExistsTable Source code
odm.close Man page Source code
odm1_1-class Man page
odm1_1Ver-class Man page
reload Man page Source code
restructureDataResult Man page Source code
run.query Man page Source code
run.sql.script Man page Source code
sqlstatements Man page Source code
sv Man page Source code
svk Man page Source code
todo Man page Source code
tz2offset Man page Source code
updateCV Man page Source code
updateDataValues Man page Source code

Files

inst
inst/setting_up_test_environment.sh
inst/odm1_1_addVersion.sql
inst/tests
inst/tests/test_metadata.R
inst/tests/test_longExample.R
inst/tests/test_versions.R
inst/tests/test_db_engines.R
inst/tests/test_various.R
inst/longexample
inst/longexample/life_expectancy_HDI_2009.csv
inst/longexample/electrification_2009.csv
inst/longexample/ofile_watergap_ipsla2nat_qstot_mean_2011_2040.csv
inst/longexample/syn.txt
inst/longexample/ofile_watergap_wfdnat_qstot_mean_1971_2000.csv
inst/longexample/access_sanitation2010.csv
inst/longexample/calorie_availability_2009_new.csv
inst/longexample/ofile_watergap_ipsla2nat_qstot_mean_2071_2100.csv
inst/longexample/ofile_watergap_cncm3a2nat_qstot_mean_2071_2100.csv
inst/longexample/ofile_watergap_ipsla2nat_qstot_mean_2041_2070.csv
inst/longexample/ofile_watergap_cncm3a2nat_qstot_mean_2041_2070.csv
inst/longexample/ofile_watergap_echama2nat_qstot_mean_2041_2070.csv
inst/longexample/solid_fuel_use2010.csv
inst/longexample/under5mortality_rate.csv
inst/longexample/ofile_watergap_cncm3a2nat_qstot_mean_2011_2040.csv
inst/longexample/MinimumDietaryEnergyRequirement.csv
inst/longexample/electricity_rate_2008_new.csv
inst/longexample/ofile_watergap_echama2nat_qstot_mean_2071_2100.csv
inst/longexample/Natl_Pop_Proj_A2.csv
inst/longexample/years_of_schooling_HDI_2009.csv
inst/longexample/pm10_latest_2009_Worldbank.csv
inst/longexample/healthcare_workforce_sum1000_latest.csv
inst/longexample/IPD_2009_selected_indicators1.csv
inst/longexample/ofile_watergap_echama2nat_qstot_mean_2011_2040.csv
inst/odm1_1_raw.sql
inst/RODM.db
inst/doc
inst/doc/RObsDat_Einstiegstutorial.R
inst/doc/RObsDat_Einstiegstutorial.Rnw
inst/doc/RObsDat_Einstiegstutorial.pdf
tests
tests/test-all.R
NAMESPACE
R
R/importSynonyms.R
R/testfun.R
R/exportSynonyms.R
R/updateCV.R
R/tz2offset.R
R/addSynonym.R
R/odm.close.R
R/addISOMetadata.R
R/expandVar.R
R/createST.R
R/getMetadata.R
R/getDataVersions.R
R/assembleDataWhereClause.R
R/svk.R
R/addOffsetType.R
R/addSource.R
R/addDataValues.R
R/odm1_1.R
R/getDefaultDB.R
R/reload.R
R/class_stfdf.R
R/mdbExistsTable.R
R/sv.R
R/guess.tz.R
R/updateDataValues.R
R/id2name.R
R/CVtables.R
R/restructureDataResult.R
R/expand.where.R
R/run.sql.script.R
R/addUnits.R
R/addVariable.R
R/addSite.R
R/addQualityControlLevel.R
R/getDataValues.R
R/getID.R
R/h.m.R
R/todo.R
R/addCV.R
R/run.query.R
R/chr2date.R
R/addSpatialReferences.R
R/deleteDataValues.R
R/sqlstatements.R
vignettes
vignettes/odm.pdf
vignettes/RObsDat_Einstiegstutorial.Rnw
vignettes/RObsDat.bib
vignettes/RObsDat_tutorial.pdf
vignettes/RObsDat_tutorial.tex
MD5
build
build/vignette.rds
DESCRIPTION
man
man/addQualityControlLevel.Rd
man/chr2date.Rd
man/reload.Rd
man/addISOMetadata.Rd
man/exportSynonyms.Rd
man/getDataValues.Rd
man/check.version.Rd
man/addOffsetType.Rd
man/addVariable.Rd
man/RObsDat-package.Rd
man/getMetadata.Rd
man/assembleDataWhereClause.Rd
man/addSite.Rd
man/odm1_1-class.Rd
man/expandVar.Rd
man/inherited_stfdf.Rd
man/addCV.Rd
man/addDataValues.Rd
man/odm.close.Rd
man/addUnits.Rd
man/addSynonym.Rd
man/addSpatialReferences.Rd
RObsDat documentation built on May 19, 2017, 9:57 a.m.