HakaiInstitute / hakai-datasets

Hakai Datasets that are going into https://catalogue.hakai.org/erddap/
0 stars 0 forks source link

add hakai erddap ctd tables to erddap schema #121

Closed JessyBarrette closed 1 year ago

JessyBarrette commented 1 year ago

I am getting ready to redirect the Hakai ERDDAP CTD datasets towards the Hakai database from the temporary files hosted on the server.

To proceed I need to get generate a view/table version of the hakai ctd. ctd.ctd_file_cast_data and ctd. ctd_post_qc_data tables to retrieve exclusively the Hakai Institute CTD data.

Before merging here's two steps needed to discuss or apply:

JessyBarrette commented 1 year ago

This is related to https://github.com/HakaiInstitute/hakai-ctd-processing-manual/issues/1

n-a-t-e commented 1 year ago

CTD data from our DB that is going to erddap should be either in files or tables, not views. Performance is way better with tables and there has been no issue with how that has been done up to now

JessyBarrette commented 1 year ago

@n-a-t-e table sounds great to me!

JessyBarrette commented 1 year ago

I will manually generate those present table on hakai db and the present PR will joined to the associated datasets.xml later