Ingest Ultracool Sheet v2.0

[kelle]

(This should really be broken up into individual issues.)
https://bit.ly/ultracoolsheet
Things to ingest

• Missing sources
• Radial velocities Ingest radial velocities from the Ultracool Sheet #506
• K photometry from Vista Ingest non-2MASS JHK photometry from Ultracool sheet #526~~
• L and M band photometry from the literature
• JHK_MKO photometry from the literature Ingest YJHK MKO photometry from Ultracool Sheet #525
• Spitzer photometry Ingest Spitzer photometry from the Ultracool Sheet #515
• Literature parallaxes, especially Kirk21 Ingest literature parallaxes from Ultracool Sheet #527
• Parallaxes for sources without Gaia parallaxes.

Lower priority

• designations into other names (WISEA, CWISE, Gaia DR2, Gaia DR3, 2MASS, PanStarrs1, MKO/ULAS, etc.)
• Ages from UCS+Banyan into Modeled Parameters. Reference = the UCS Zenodo ref.

[kelle]

Here's some code which can help with mapping their reference codes onto ours.

db.Publications.update().where(db.Publications.c.publication == 'Dupu12a').\
    values(publication='Dupu12').execute()
# Fix some references
'''for i, ref in enumerate(df.ref_plx_lit):
    if ref == 'Burg08b':
        df.ref_plx_lit[i] = "Burg08c"
    if ref == 'Burg08c':
        df.ref_plx_lit[i] = "Burg08d"
    if ref == 'Burg08d':
        df.ref_plx_lit[i] = "Burg08b"
    if ref == 'Gagn15b':
        df.ref_plx_lit[i] = "Gagn15c"
    if ref == 'Gagn15c':
        df.ref_plx_lit[i] = "Gagn15b"
    if ref == 'Lodi07a':
        df.ref_plx_lit[i] = "Lodi07b"
    if ref == 'Lodi07b':
        df.ref_plx_lit[i] = "Lodi07a"
    if ref == 'Reid02c':
        df.ref_plx_lit[i] = "Reid02b"
    if ref == 'Reid06a':
        df.ref_plx_lit[i] = "Reid06b"
    if ref == 'Reid06b':
        df.ref_plx_lit[i] = "Reid06a"
    if ref == 'Scho04b':
        df.ref_plx_lit[i] = "Scho04a"
    if ref == 'Scho10a':
        df.ref_plx_lit[i] = "Scho10b"
    if ref == 'Tinn93b':
        df.ref_plx_lit[i] = "Tinn93c"
    if ref == 'Lieb79f':
        df.ref_plx_lit[i] = "Lieb79"
    if ref == 'Prob83c':
        df.ref_plx_lit[i] = "Prob83"
    if ref == 'Jame08a':
        df.ref_plx_lit[i] = 'Jame08'
    if ref == 'Lepi05a':
        df.ref_plx_lit[i] = 'Lepi05'
    if ref == 'Lodi05b':
        df.ref_plx_lit[i] = 'Lodi05'
    if ref == 'Tinn95c':
        df.ref_plx_lit[i] = 'Tinn95'
    if ref == 'Roes10b':
        df.ref_plx_lit[i] = 'Roes10'
    if ref == 'Hog_00a':
        df.ref_plx_lit[i] = 'Hog_00'
    if ref == 'Ditt14a':
        df.ref_plx_lit[i] = 'Ditt14'
    if ref == 'Schn16b':
        df.ref_plx_lit[i] = 'Schn16'
    if ref == 'Tinn03b':
        df.ref_plx_lit[i] = 'Tinn03'
    if ref == 'Phan08a':
        df.ref_plx_lit[i] = 'Phan08'
    if ref == 'Gizi15a':
        df.ref_plx_lit[i] = 'Gizi15'
        '''