Version
Source version 4.3.1
Description
The Source Database (SDB) file format is Source's binary file format for storing time series data and associated metadata. SDB files support querying and searching, providing an efficient means of extracting individual time series from large data stores. The SDB supports the metadata listed in the table below. Some of the metadata fields are only relevant if the SDB file has been created from Results Manager based the results of a Source simulation.
| Metadata Field | Description | Examples | ||||
|---|---|---|---|---|---|---|
| General Details | ||||||
| Author | Creator of the SDB file | |||||
| Application Source | Name of application that produced the data | Source | ||||
| Application Version | Version number of application | 4.3.1.0000 | ||||
| Scenario Name | eWater Source scenario name | |||||
| Project Name | eWater Source project name | Timestep | Time step | Daily | ||
| Metadata Version | Version of the SDB file format | 0.0.1.0 | ||||
| Time Series Details | ||||||
| Element Type | Element type | Node Link | ||||
| Water Feature Type | Feature type | Gauge Storage Straight Through Routing | ||||
| Site | Feature (node/link) name in Source | Gauge #5 | ||||
| Element Name | The type of attribute recorded for the site | Downstream Flow Constituents | ||||
| Structure | Attribute recorded for the site | Downstream Flow Constituents@TSS@Downstream Flow Concentration | ||||
| Start Date | Time series start date | 2000-01-01 00:00:00 | ||||
| End Date | Time series end date | 2000-12-31 24:00:00 | ||||
| Site | Feature (node/link) name in Source | Gauge #5 | ||||
| Structure | Attribute recorded for the site | Downstream Flow Constituents@TSS@Downstream Flow Concentration | ||||
| Water Feature Type | Feature type | Gauge Storage Straight Through Routing | ||||
| Timestep | Time step | Daily | ||||
| Units | Data units | cubic metres per second (m³/s) | ||||
| Application Source | Name of application that produced the data | Source | ||||
| Application Version | Version number of application | 4.3.1.0000 | ||||
| Date In | Date that the time series was saved to the SDB | 2018-01-09 16:54:30 | ||||
| Author | Creator of the SDB file | |||||
| Element Type | Element type | Node Link | ||||
| Element Name | The type of attribute recorded for the site | Downstream Flow Constituents | ||||
| Metadata Version | Version of the SDB file format | 0.0.1.0 | ||||
Using the SDB File Format
The SDB file format can be created , queried and imported, using the Results Manager.
...
| icon | false |
|---|
...
Save As and Open options, in the same way as all other time series
...
formats in Source - as found in Data Sources and Results Manager. However, the query filter whereby only certain fields are loaded, is only available through Results Manager.