Troubleshoot incorrect database pier correction values
Wrong default pier being selected for old observations, and pier correction times are incorrect in the database.
I believe this is due to bad data in the database. When a new pier was entered, existing mark records were re-referenced; but the data model requires a new mark be added with a new id (even if it's otherwise the same mark information as before). The observation stores the mark id that was used, causing it to select the wrong pier because there are now 2 piers with the same mark id.
- Document the data model and manual steps required to add a new pier correction.
- Use the attached spreadsheet to verify/correct pier corrections for one problem observatory.
- Verify correcting the pier corrections in the database results in the correct pier being selected for old observations.