Create or connect to an ODM2 database.
create_sqlite()
Make a new ODM2 sqlite database
connect_sqlite()
Connect to an existing ODM2 sqlite database
disconnect_sqlite()
Disconnect from connect ODM2 sqlite database
Add descriptive metadata about sites, methods, variables, etc.
db_describe_annotation()
Add a new annotation text
db_describe_equipment()
Add a piece of equipment to the equipment table
db_describe_method()
Describe a new method
db_describe_organization()
Add a new entry to the Organizations table
db_describe_person()
Describe a new person in the people and affiliations tables
db_describe_sample()
Add details about a new sample
db_describe_site()
Describe a new site
db_describe_variable()
Describe a new variable
db_annotate()
Insert new annotation
db_add_relations()
Add relationships to related features table
Add different types of results to the database
db_insert_results_m()
Insert measurement data values to ODM2 database
db_insert_results_samples()
Insert sample result data values to ODM2 database
db_insert_results_samples_profile()
db_insert_results_ts()
Insert time series data values to ODM2 database
Query results in the database
db_get_annotations()
Get list of annotations currently in database
db_get_equipment()
Get list of equipment currently in database
db_get_methods()
Get list of methods currently in database
db_get_people()
Get list of people currently in database
db_get_results()
Query result data
db_get_samples()
Get list of sample codes currently in database
db_get_sites()
Get list of sampling feature codes currently in database
db_get_variables()
Get list of variables currently in database
db_get_water_level_ts()
Function to retrieve time series data with variablecode waterLevel from a specified sampling feature
make_vars_list()
Make variables list
get_site_codes()
Shiny gadget to get site codes of interest
get_variable_codes()
Shiny gadget to get variable codes of interest
get_cv_terms()
Print a list of controlled vocabulary terms