search

glamod / glamod-ingest

Database preparation and ingestion for GLAMOD
BSD 2-Clause "Simplified" License
2 stars 1 forks source link

Change the `cdmlite` table structure: add `source_id` #12

Closed agstephens closed 4 years ago

agstephens commented 4 years ago

We decided to add the source ID to the CDM lite it allows lookups to the station config file and source config file.

Simon sent an email outlining the data policy changes that may be needed in this release and the source ID would be required in the CDM lite to do this.

We need to insert a new column at the start of the cdmlite:

Column 1: source_id Type: integer (lookup to cdm_full.source_configuration::source)

david-i-berry commented 4 years ago

For marine the above is correct.

agstephens commented 4 years ago

Added source_id to cdmlite table: https://github.com/glamod/glamod-ingest/commit/f74719a97eb6653274dae1e4f4b7962f9fbfb366

agstephens commented 4 years ago

Closing this. Separate issues will track restructure-land and restructure-marine to include source_id.