search

mhpob / otndo

A package to understand OTN data
https://otndo.obrien.page/
Creative Commons Attribution 4.0 International
3 stars 1 forks source link

different versions of receiver metadata fail due to new columns #10

Closed mhpob closed 3 months ago

mhpob commented 4 months ago

otndo was coded around v1.2 of the ACT receiver metadata sheet. Some data were uploaded using an easier version, causing a column mismatch.

Need to hunt down earlier versions and test/adjust clean_otn_deployment to accommodate.

mhpob commented 3 months ago

Older ACT deployment metadata columns are: OTN_ARRAY, STATION_NO, DEPLOY_DATE_TIME, DEPLOY_LAT, DEPLOY_LONG, BOTTOM_DEPTH, RISER_LENGTH, INSTRUMENT_DEPTH, INS_MODEL_NO, INS_SERIAL_NO, AR_MODEL_NO, AR_SERIAL_NO, DEPLOYED_BY, RECOVERED, RECOVER_DATE_TIME, RECOVER_LAT, RECOVER_LONG, DATA_DOWNLOAD, DOWNLOAD_DATE_TIME, FILENAME, COMMENTS.

Newer ACT deployment metadata columns are (differences in bold): OTN_ARRAY, STATION_NO, DEPLOY_DATE_TIME, DEPLOY_LAT, DEPLOY_LONG, BOTTOM_DEPTH, RISER_LENGTH, INSTRUMENT_DEPTH, INS_MODEL_NO, INS_SERIAL_NO, CODE_SET, TRANSMITTER, TRANSMIT_MODEL, AR_MODEL_NO, AR_SERIAL_NO, DEPLOYED_BY, RECOVERED, RECOVER_DATE_TIME, RECOVER_LAT, RECOVER_LONG, DATA_DOWNLOADED, DOWNLOAD_DATE_TIME, FILENAME, COMMENTS.

mhpob commented 3 months ago

Probably need to insert an NA transmitter column for sheets without an internal transmitter.

https://github.com/mhpob/otndo/blob/main/R/utilities_make.R#L87