Skip to content

Climsoft Data Model

Jump to bottom
Ian Edwards edited this page Apr 3, 2019 · 3 revisions

Below is the entity relationship diagram (ERD) created for Climsoft 4.0.

There have been a few changes since this diagram was produced, but overall it still conveys the model well.

The central aspect of the Climsoft data model is a single observations table (observationfinal), this records:

  • Station Id (recordedFrom)
  • Element Id (recordedBy), e.g. Maximum temperature, Precipitation total etc.
  • Duration of observation (period), e.g. hourly, daily
  • Observation date and time (obsDateTime)
  • Observation value (obsValue)
  • Quality control status (qcStatus)
  • ... etc.

We then have tables to store related metadata, including tables for station information, station history, element metadata, instrument metadata etc.

The current database schema (SQL) can always be downloaded from the database releases page.

Updates to the data model are discussed as part of the Climsoft road map. We very much welcome suggestions for data model improvements.

Clone this wiki locally