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

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.

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

View on CRAN

Functions

addCV Man page
addDataValues Man page
addISOMetadata Man page
addOffsetType Man page
addQualityControlLevel Man page
addSite Man page
addSource Man page
addSpatialReferences Man page
addSynonym Man page
addUnits Man page
addVariable Man page
assembleDataWhereClause Man page
check.version Man page
chr2date Man page
CVtables Man page
deleteDataValues Man page
expandVar Man page
expand.where Man page
exportSynonyms Man page
getDataValues Man page
getDataVersions Man page
getDefaultDB Man page
getID Man page
getMetadata Man page
guess.tz Man page
h.m Man page
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
id2name Man page
IdbState,odm1_1-method Man page
IdbState,odm1_1Ver-method Man page
IdeleteDataValues,odm1_1-method Man page
IgetCensorCode,odm1_1-method Man page
IgetCurrentDataVersion,odm1_1-method Man page
IgetCurrentDataVersion,odm1_1Ver-method Man page
IgetCV,odm1_1-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
IgetSamples,odm1_1-method Man page
IgetSampleType,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
IgetVariableName,odm1_1-method Man page
IgetVariable,odm1_1-method Man page
IgetVerticalDatum,odm1_1-method Man page
importSynonyms Man page
inherited_stfdf Man page
inherited_stfdf-class Man page
==,inherited_stfdf,inherited_stfdf-method Man page
[,inherited_stfdf-method Man page
IupdateDataValues,odm1_1-method Man page
odm1_1-class Man page
odm1_1Ver-class Man page
odm.close Man page
reload Man page
restructureDataResult Man page
RObsDat Man page
RObsDat-package Man page
run.query Man page
run.sql.script Man page
sqlstatements Man page
sv Man page
svk Man page
todo Man page
tz2offset Man page
updateCV Man page
updateDataValues Man page

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

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.