Update the database schema to handle new columns and line types added to the MET-11.0.0-beta5 output.

[JohnHalleyGotway]

Describe the Enhancement

MET development version 11.0.0-beta5 changes the output from the TC-Pairs and TC-Stat tools in the 2 ways described below. This issue is to update the database schema accordingly to handle this new data for MET version 11.0.0.

• PR Feature #2036 rename MET#2346 for issue Enhance TC-Pairs consensus logic to compute the spread of the location, wind speed, and pressure. MET#2036 renames the TCMPR columns as follows:
  OLD: NUM_MEMBERS TRACK_SPREAD DIST_MEAN MSLP_SPREAD MAX_WIND_SPREAD
  NEW: NUM_MEMBERS TRACK_SPREAD TRACK_STDEV MSLP_STDEV MAX_WIND_STDEV
• PR Feature #2321 tc_diag_changes MET#2347 for issue Refine TCDIAG output from TC-Pairs as needed MET#2321 adds 2 new columns to the TCDIAG line type as follows:
  OLD: TOTAL INDEX DIAG_SOURCE N_DIAG
  NEW: TOTAL INDEX DIAG_SOURCE TRACK_SOURCE FIELD_SOURCE N_DIAG

The new TRACK_SOURCE and FIELD_SOURCE columns are strings and should be handled the same as the DIAG_SOURCE string.

Please find updated sample output data in this tarfile:
ftp.rap.ucar.edu/incoming/irap/met_help/NB20221116_develop_test_output.tar.gz

In particular see:
Updated TCMPR lines in test_output/tc_pairs/al132020_CONSENSUS.tcst.
Updated TCDIAG lines in test_output/tc_pairs/al092022_20220926_DIAGNOSTICS.tcst.

Time Estimate

Estimate the amount of work required here.
Issues should represent approximately 1 to 3 days of work.

Sub-Issues

Consider breaking the enhancement down into sub-issues.
None needed.

Relevant Deadlines

List relevant project deadlines here or state NONE.

Funding Source

Define the source of funding and account keys here or state NONE.

Define the Metadata

Assignee

• Select engineer(s) or no engineer required: @venitahagerty
• Select scientist(s) or no scientist required: none needed

Labels

• Select component(s)
• Select priority
• Select requestor(s)

Projects and Milestone

• Select Repository and/or Organization level Project(s) or add alert: NEED PROJECT ASSIGNMENT label
• Select Milestone as the next official version or Future Versions

Define Related Issue(s)

Consider the impact to the other METplus components.

• METplus, MET, METdataio, METviewer, METexpress, METcalcpy, METplotpy
  None needed.

Enhancement Checklist

See the METplus Workflow for details.

• Complete the issue definition above, including the Time Estimate and Funding Source.
• Fork this repository or create a branch of develop.
  Branch name: feature_<Issue Number>_<Description>
• Complete the development and test your changes.
• Add/update log messages for easier debugging.
• Add/update unit tests.
• Add/update documentation.
• Push local changes to GitHub.
• Submit a pull request to merge into develop.
  Pull request: feature <Issue Number> <Description>
• Define the pull request metadata, as permissions allow.
  Select: Reviewer(s) and Development issues

Select: Repository level development cycle Project for the next official release
Select: Milestone as the next official version

• Iterate until the reviewer(s) accept and merge your changes.
• Delete your fork or branch.
• Close this issue.

[venitahagerty]

This issue was closed by completion of PR 139