Add a derived flag to db?

SnowEx / snowexsql

A project to access the SnowEx database holding data from the NASA SnowEx campaign

https://snowexsql.readthedocs.io/en/latest/readme.html

GNU General Public License v3.0

23 stars 6 forks source link

Add a derived flag to db? #94

Open micahjohnson150 opened 1 month ago

micahjohnson150 commented 1 month ago

Is your feature request related to a problem? Please describe. Some data that may go into the db may end up being a derived form of other data in the db. It would be nice to know when thats the case.

Ex. SWE summary file is in the point db (soon) and is derived from the density files

Describe the solution you'd like I think the best solution is a boolean column that adds if the product is derived or not.

This was discussed with @micah-prime @jomey @aaarendt today during our meeting.

jomey commented 1 month ago

Should this be a DB repo issue?

jomey commented 2 weeks ago

Logging some discussions thoughts: The new DB structure will introduce a table called 'Measurement Types'. The thought was that we could create a record there indicating a "real" measurement or a "composite". This could also accommodate this use case.