SNe added with wrong coordinates

[pbrown801]

Unfortunately a list of supernovae were submitted with the wrong RA. We are really sorry. Below is the corrected list of objects for which the processing ran at the wrong coordinates. Let us know if we can help fix this.

SN2016gsb,91.11725,-20.34026111111111,0.0097,Ia
SN2016fej,310.166125,-54.310066666666664,0.010914,Ia
SN2016euj,36.84041666666667,-23.92925,0.017,Ia
SN2016eoa,5.3462499999999995,22.43563888888889,0.020771,Ia
SN2016ekt,328.366175,-34.40581944444444,0.017,Ia
SN2016ekg,330.01500000000004,-30.185277777777777,0.017,Ia
SN2016eja,336.38233333333335,38.98430555555556,0.04,Ia
SN2016eiy,203.66099999999997,-23.681430555555558,0.008663,Ia
SN2016eii,46.97291666666667,-69.02977777777778,0.036,Ia
SN2016daj,31.15625,21.585680555555555,0.032,Ia
SN2016coj,182.02833333333334,65.17719444444445,0.004483,Ia
SN2016cnx,151.72687916666666,-15.716852777777778,0.029444,Ia
SN2016ccz,217.78858333333335,27.236055555555556,0.015,Ia
SN2016bqs,230.88766666666666,9.357111111111111,0.032916,Ia
SN2016blc,162.20599166666668,-20.263633333333335,0.012,Ia
SN2016asf,102.65304166666667,31.11237777777778,0.021,Ia
SN2016F,24.88345833333333,33.82668055555556,0.016138,Ia
SN2015ar,16.83491666666667,32.39994444444444,0.017005,Ia
SN2015ak,333.8319583333334,-65.54816666666666,0.01037,Ia
SN2015N,325.82037499999996,43.579888888888895,0.01492,Ia
SN2015I,109.44041666666666,23.34461111111111,0.0076,Ia
SN2015F,114.06566666666666,-69.50638888888889,0.00489,Ia
SN2014ap,172.55541666666667,24.168444444444447,0.023516,Ia
SN2014ai,139.93404166666664,33.76372222222222,0.023176,Ia
SN2014J,148.92549999999997,69.67386111111112,0.000677,Ia
SN2014I,85.5825,-25.544416666666667,0.03,Ia
SN2013hn,207.2465416666667,-30.290694444444448,0.01514,Ia
SN2013gy,55.57033333333334,-4.721805555555556,0.014023,Ia
SN2013gs,142.78695833333333,46.38483333333333,0.016888,Ia
SN2013gh,330.591,-18.916777777777778,0.0088,Ia
SN2013fy,324.3630416666667,-47.032111111111114,0.03,Ia
SN2013fw,318.4367083333333,13.575972222222221,0.01695,Ia
SN2013fn,315.099,-14.497833333333332,0.027,Ia
SN2013eu,156.09295833333334,78.60652777777777,0.009266,Ia
SN2013eh,244.03829166666662,38.54805555555556,0.034999,Ia
SN2013dy,334.5733333333333,40.56933333333334,0.003889,Ia
SN2013cs,198.8117083333333,-17.965444444444444,0.00924,Ia
SN2013cg,141.73654166666668,-24.78322222222222,0.007952,Ia
SN2013bs,259.34179166666667,41.066722222222225,0.027612,Ia
SN2013ag,192.89591666666666,26.629277777777776,0.02129,Ia
SN2013aa,218.14116666666666,-44.22438888888889,0.003999,Ia
SN2013Q,356.7827916666667,29.486527777777777,0.017239,Ia
SN2013E,150.023,-34.233694444444446,0.009413,Ia
SN2012ht,163.34479166666668,16.77636111111111,0.003559,Ia
SN2012hr,95.41025,-59.71405555555556,0.007562,Ia
SN2012hj,166.82995833333334,46.3795,0.024597,Ia
SN2012fr,53.39995833333333,-36.12713888888889,0.005457,Ia
SN2012cp,206.757,33.89333333333333,0.016531,Ia
SN2012bl,305.9803333333333,-48.35480555555556,0.018706,Ia
SN2011iv,54.71395833333333,-35.592222222222226,0.006494,Ia
SN2011im,341.1050833333333,-0.16722222222222222,0.016228,Ia
SN2011ia,146.264375,64.2598611111111,0.019,Ia
SN2011hb,351.98129166666666,8.779361111111111,0.028924,Ia
SN2011fs,334.33133333333336,35.580555555555556,0.020914,Ia
SN2011dm,329.17329166666667,73.29691666666666,0.00494,Ia
SN2011de,235.971875,67.76180555555555,0.029187,Ia
SN2011by,178.93983333333333,55.326055555555556,0.002843,Ia
SN2011at,142.23983333333334,-14.805722222222222,0.006758,Ia
SN2011ao,178.462625,33.362861111111116,0.010706,Ia
SN2011aa,114.17762499999999,74.443,0.012355,Ia
SN2011M,75.173125,62.244055555555555,0.017432,Ia
SN2011B,133.95041666666665,78.21711111111111,0.00467,Ia
SN2010ko,83.206,-14.096083333333334,0.010441,Ia
SN2010kg,70.03500000000001,7.35,0.016642,Ia
SN2010jn,144.375,23.1608,0.025047,Ia
SN2010ih,105.68179166666665,-28.62366666666667,0.007288,Ia
SN2010gp,253.239125,2.387888888888889,0.02448,Ia
SN2010gn,259.4587916666667,40.881277777777775,0.0365,Ia
SN2010ev,156.37079166666666,-39.83088888888889,0.009211,Ia
SN2010cr,202.35429166666665,11.796222222222221,0.02157,Ia
SN2010Y,162.76625,65.77972222222222,0.01086,Ia
SN2009jr,306.6084583333333,2.9089166666666664,0.016548,Ia
SN2009ig,39.54841666666666,-1.3125833333333334,0.00877,Ia
SN2009gf,213.90462499999998,14.280166666666668,0.018523,Ia
SN2009cz,138.75008333333332,29.735305555555556,0.021138,Ia
SN2009an,185.69750000000002,65.85111111111111,0.009233,Ia
SN2009Y,220.59866666666667,-17.246750000000002,0.009353,Ia
SNF20080514002,,,0.0221,Ia
SN2008hv,136.89191666666667,3.3922499999999998,0.012549,Ia
SN2008hs,36.373416666666664,41.84308333333333,0.017369,Ia
SN2008ha,353.7195416666667,18.226499999999998,0.004647,Ia
SN2008ge,62.102833333333336,-47.896499999999996,0.004043,Ia
SN2008ec,345.819,8.872166666666667,0.016317,Ia
SN2008Q,21.238458333333334,9.550416666666667,0.007935,Ia
SN2007sr,180.47000000000003,-18.972694444444443,0.005688,Ia
SN2007on,54.71208333333333,-35.575,0.006494,Ia
SN2007cv,159.43916666666667,-27.0825,0.007562,Ia
SN2007co,275.765,29.897111111111112,0.016962,Ia
SN2007bm,171.25958333333332,-9.798277777777777,0.006211,Ia
SN2007af,215.587625,-0.3937777777777778,0.005464,Ia
SN2007S,150.13025000000002,4.407277777777778,0.01388,Ia
SN2006mr,50.6785,-37.20791666666667,0.00587,Ia
SN2006ej,9.749041666666665,-9.015722222222223,0.02045,Ia
SN2006dm,355.4493333333333,-3.669,0.02202,Ia
SN2006X,185.72470833333333,15.80888888888889,0.00524,Ia
SN2006E,208.369375,5.206333333333333,0.00272,Ia
SN2005df,64.40770833333333,-62.769305555555555,0.00435,Ia
SN2005cf,230.388,-7.449194444444445,0.00646,Ia
SN2005am,139.05195833333335,-16.304444444444446,0.0079,Ia
ASASSN-15ts,53.67508333333333,-20.8464,0.059978,Ia
ASASSN-15tj,118.86945833333334,52.1579,0.022265,Ia
ASASSN-15so,168.5459875,48.31867777777778,0.007125,Ia
ASASSN-15sf,2.8649999999999998,-6.427333333333333,0.027,Ia
ASASSN-15rw,33.99229166666667,12.237388888888889,0.0189,Ia
ASASSN-15rq,2.0130833333333333,-36.564391666666666,0.025,Ia
ASASSN-15qc,9.824916666666667,3.950038888888889,0.017649,Ia
ASASSN-15ar,37.084833333333336,10.384408333333333,0.02882,Ia
ASASSN-14fa,43.09608333333334,-31.821666666666665,0.022589,Ia
ASASSN-14ar,137.42375,37.60180555555556,0.02298,Ia
ASASSN-13dd,136.903125,3.394361111111111,0.01255,Ia
ASASSN-13ch,244.14191666666665,-0.5909444444444445,0.01646,Ia

[manning-ncsa]

We have taken this discussion offline, but for reference, I deleted the transients with a script similar to this:

from host.models import Transient


transients_to_delete = [
    'ASASSN-13dd',
    'ASASSN-13ch',
    ...
]

transients_deleted = []
transients = Transient.objects.filter(name__in=transients_to_delete)
for transient in transients:
    print(f'''Deleting transient "{transient.name}"...''')
    transient.delete()
    transients_deleted.append(transient.name)
deleted_transients = [transient.name for transient in transients]
for transient_name in [transient_name for transient_name in transients_to_delete
                       if transient_name not in deleted_transients]:
    print(f'''Unknown transient: "{transient_name}"...''')

print(f'''{len(transients_to_delete)} transients listed for deletion.''')
print(f'''Deleted {len(transients_deleted)} transients.''')

and a kubectl exec command like this:

$ kubectl exec -n blast -i -c app api-server-0 -- \
    python manage.py shell < blast_delete_transient_list.py