Time Series

Time series content is held in HydroShare using an Observations Data Model Version 2 (ODM2) format SQLite file.  This format was developed to accommodate a wide range of observational data with comprehensive metadata and is described here. You can also read more about the ODM2 information model in the following locations:

HydroShare currently supports upload of a SQLite file (https://sqlite.org/) in ODM2 (Observations Data Model Version 2) format or simple comma separated values (CSV) text files containing time series data. If you upload a SQLite file, HydroShare will automatically parse the file and extract the metadata description of your time series datasets for display in HydroShare. If you upload a CSV file, you will have the opportunity to create the metadata description for your time series datasets within HydroShare.

Example 1 - add existing sqlite file

A composite resource is created adding a .sqlite file in ODM2 format

to an empty composite resource.  HydroShare recognizes this as a .sqlite time series file and reads metadata from it, and sets the resource level Title, Abstract, Authors, Keywords and Coverage based on this metadata.  Time series content is stored in a folder depicted using a time series symbol; the folder contains the .sqlite file.


Example 2 - add CSV file

A composite resource is created and a csv file holding time series data added to it

In edit mode Right Click -> Set content type -> Time series.

This creates a time series content aggregation and reads data from the CSV file.  Both the original CSV file and ODM2.sqlite file are saved in the time series content aggregation folder.

Use the Metadata panel to add metadata for each time series read from the CSV file.

Edits you save are recorded in the ODM2.sqlite file.