lter / LTER-core-metabase

RDB model, based on the GCE LTER Metabase, with adaptations from other LTER sites
https://lter.github.io/LTER-core-metabase/
GNU General Public License v3.0
9 stars 4 forks source link

newer columns lack example content #81

Open gastil opened 4 years ago

gastil commented 4 years ago

The example data was entered before several new columns, such as in table DataSet, columns UpdateFrequency and MaintenanceDescription.

Suggested content: Screen Shot 2019-10-09 at 4 11 11 PM (Based on corresponding real SBC datasets.)

Code to UPDATE:

update lter_metabase."DataSet"
set "PubDate" = '2019-08-07',
    "UpdateFrequency" = 'annually',
    "MaintenanceDescription" = 'Ongoing time series.'
where "DataSetID" = 99013;

update lter_metabase."DataSet"
set "PubDate" = '2016-09-08',
    "UpdateFrequency" = 'notPlanned',
    "MaintenanceDescription" = 'Completed timeseries. No future data updates anticpated.'
where "DataSetID" = 99021;

update lter_metabase."DataSet"
set "PubDate" = '2019-01-15',
    "UpdateFrequency" = 'annually',
    "MaintenanceDescription" = 'Ongoing time series. Data updates may be delayed by analysis.'
where "DataSetID" = 99024;

update lter_metabase."DataSet"
set "PubDate" = '2014-01-14',
    "UpdateFrequency" = 'notPlanned',
    "MaintenanceDescription" = 'Completed timeseries. No future data updates anticpated.'
where "DataSetID" = 99054;
gastil commented 4 years ago

Another place new columns lack useful content in example rows:

update pkg_mgmt.maintenance_changehistory
set revision_notes = 'Upgrade to EML2.1 and migrating to pasta from metacat. ACLs added.',
change_scope= 'Metadata',
change_date='2013-04-02',
revision_number=7
where revision_notes='First';

update pkg_mgmt.maintenance_changehistory
set revision_notes = 'Converted datetimes to ISO-8601 along with regular timeseries update',
change_scope= 'Metadata and Data',
change_date='2014-02-28',
revision_number=8
where revision_notes='Second';

insert into pkg_mgmt.maintenance_changehistory 
values (99054,4,'Conclude timeseries. Mark update frequency as notPlanned.', 'Metadata','2012-02-14','mobrien');

insert into pkg_mgmt.maintenance_changehistory 
values (99024,16,'All years data recalculated with corrected algorithm.', 'Data','2016-10-10','mobrien');

insert into pkg_mgmt.maintenance_changehistory 
values (99024,17,'Added ORCiDs with regular timeseries update.', 'Metadata and Data','2017-12-19','mobrien');

Im going to edit these data directly rather than insert statements in a patch for the next table. The data will load with the next OBF. Example rows only matter for new users.