Understanding what file types can be uploaded into a Time Series resource

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.

CSV files uploaded to HydroShare must have a single date/time column called “ValueDateTime.” The following is an example of the first few lines of a data file containing a single time series of water temperature values. Files may have any number of data columns, but each must have a unique column name. There are no restrictions on which variables, methods, sites, etc. can have data in your file - the only restriction is that they must all share the same “ValueDateTime” column.

You should specify your date/time values in the format “yyyy-mm-dd hh:mm:ss” for correct interpretation by HydroShare. You will have the opportunity to specify the correct UTC Offset for your date/time values as part of the metadata description created in HydroShare.

The easiest way to get started with Time Series resources in HydroShare is to upload CSV files. However, if you want to use SQLite files to take advantage of HydroShare’s automated metadata extraction features, you can learn more about ODM2 and tools available for working with ODM2 databases on the ODM2 GitHub repository (https://github.com/ODM2/ODM2/wiki/documentation).