Climsoft Data Model - climsoft/Climsoft GitHub Wiki

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, Total precipitation 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.