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

Share:

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.

Author
Dominik Reusser
Date of publication
2016-03-31 22:27:32
Maintainer
Dominik Reusser <reusser@pik-potsdam.de>
License
GPL
Version
16.03

View on CRAN

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

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