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.

AuthorDominik Reusser
Date of publication2016-03-31 22:27:32
MaintainerDominik Reusser <reusser@pik-potsdam.de>
LicenseGPL
Version16.03

View on CRAN

Files in this package

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

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

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