Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 FieldDescriptionExamples
General Details
AuthorCreator of the SDB file
Application SourceName of application that produced the dataSource
Application VersionVersion number of application4.3.1.0000
Scenario NameeWater Source scenario name 
Project NameeWater Source project name
Metadata VersionVersion of the SDB file format0.0.1.0
Time Series Details
Element TypeElement type

Node

Link

Water Feature TypeFeature type

Gauge

Storage

Straight Through Routing

SiteFeature (node/link) name  TimestepTime stepDailyin SourceGauge #5
Element NameThe type of attribute recorded for the site

Downstream Flow

Constituents

StructureAttribute recorded for the site

Downstream Flow

Constituents@TSS@Downstream Flow Concentration

Start DateTime series start date2000-01-01 00:00:00
End DateTime series end date2000-12-31 24:00:00
SiteFeature (node/link) name in SourceGauge #5
StructureAttribute recorded for the site

Downstream Flow

Constituents@TSS@Downstream Flow Concentration

Water Feature TypeFeature type

Gauge

Storage

Straight Through RoutingTimestep
Time stepDaily
UnitsData unitscubic metres per second (m³/s)Application SourceName of application that produced the dataSource
Application VersionVersion number of application4.3.1.0000
Date InDate that the time series was saved to the SDB2018-01-09 16:54:30AuthorCreator of the SDB file 
Element TypeElement type

Node

Link

Element NameThe type of attribute recorded for the site

Downstream Flow

Constituents

Metadata VersionVersion of the SDB file format0.0.1.0

Using the SDB File Format

The SDB file format can be created , queried and imported, using the Results Manager.

...

iconfalse

...

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