In [1]:
from lightcurve_pipeline.ingest.resolve_target import get_targname
from lightcurve_pipeline.utils.utils import SETTINGS
from lightcurve_pipeline.database.database_interface import session
from lightcurve_pipeline.database.database_interface import Metadata
In [2]:
query = session.query(Metadata.targname).all()
targnames = set([result[0] for result in query])
In [3]:
new_targnames = [get_targname(targname) for targname in targnames]
Changed TARGNAME from WD1654+160-COPY to WD1654+160
Changed TARGNAME from V405-PEG to V405PEG
Changed TARGNAME from SDSS-J100535.24+013445.7 to SDSSJ100535.24+013445.7
Changed TARGNAME from VV2006-J112224.1+031802 to VV2006J112224.1+031802
Changed TARGNAME from LBQS-0107-0235 to LBQS0107-0235
Changed TARGNAME from LBQS-0107-0232 to LBQS0107-0232
Changed TARGNAME from MRK-5 to MRK5
Changed TARGNAME from SK-69279 to SK69279
Changed TARGNAME from GD-362 to GD362
Changed TARGNAME from QSO-B1440+3539 to QSOB1440+3539
Changed TARGNAME from SDSS-J093001.90+284858.4 to SDSSJ093001.90+284858.4
Changed TARGNAME from D33-J013346.2+304439.9 to D33J013346.2+304439.9
Changed TARGNAME from NGC-6833 to NGC6833
Changed TARGNAME from 2MASS-J09591486+3203573 to 2MASSJ09591486+3203573
Changed TARGNAME from NGC-6905 to NGC6905
Changed TARGNAME from MARS-2 to MARS
Changed TARGNAME from MARS-1 to MARS
Changed TARGNAME from QSO-B1309+3531 to QSOB1309+3531
Changed TARGNAME from LHS-310 to LHS310
Changed TARGNAME from MRK-509 to MRK509
Changed TARGNAME from SDSS-J141038.39+230447.1 to SDSSJ141038.39+230447.1
Changed TARGNAME from EUROPA-4-SECOND to EUROPA-4
Changed TARGNAME from AZV-326 to AZV326
Changed TARGNAME from AZV-327 to AZV327
Changed TARGNAME from NGC-4395 to NGC4395
Changed TARGNAME from PG-1115+158 to PG1115+158
Changed TARGNAME from 2MASX-J13135774+3518527 to 2MASXJ13135774+3518527
Changed TARGNAME from HD-38029 to HD38029
Changed TARGNAME from SDSS-J1507 to SDSSJ1507
Changed TARGNAME from V1108-HER to V1108HER
Changed TARGNAME from SDSS-J124129.64+285212.0 to SDSSJ124129.64+285212.0
Changed TARGNAME from VV2006-J130524.3+035731 to VV2006J130524.3+035731
Changed TARGNAME from VV2006-J125124.6+055420 to VV2006J125124.6+055420
Changed TARGNAME from HD-209458 to HD209458
Changed TARGNAME from MRK-36 to MRK36
Changed TARGNAME from MRK-33 to MRK33
Changed TARGNAME from QSO-B1254+571 to QSOB1254+571
Changed TARGNAME from 1RXS-J023238.8-371812 to 1RXSJ023238.8-371812
Changed TARGNAME from SDSS-J093706.85+170021.5 to SDSSJ093706.85+170021.5
Changed TARGNAME from QSO-J1701+6412 to QSOJ1701+6412
Changed TARGNAME from PG-1148+549 to PG1148+549
Changed TARGNAME from WD-1057+719 to WD1057+719
Changed TARGNAME from AZV-261 to AZV261
Changed TARGNAME from AZV-267 to AZV267
Changed TARGNAME from VV2000-J093603.9+320709 to VV2000J093603.9+320709
Changed TARGNAME from NGC-3516 to NGC3516
Changed TARGNAME from COMET-LEE2 to COMET-LEE
Changed TARGNAME from IRAS-L06229-6434-COPY to IRAS-L06229-6434
Changed TARGNAME from SDSS-J113137.16+155645.3 to SDSSJ113137.16+155645.3
Changed TARGNAME from SK-65-22 to SK6522
Changed TARGNAME from 2MASS-J13250381+2717189 to 2MASSJ13250381+2717189
Changed TARGNAME from V405-AUR to V405AUR
Changed TARGNAME from NGC-985 to NGC985
Changed TARGNAME from HD-188112 to HD188112
Changed TARGNAME from AZV-243 to AZV243
Changed TARGNAME from QSO-B1229+204 to QSOB1229+204
Changed TARGNAME from JUPITER-NORTH-9 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-8 to JUPITER-NORTH
Changed TARGNAME from TWA-3A to TWA3A
Changed TARGNAME from JUPITER-NORTH-1 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-3 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-2 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-5 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-4 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-7 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-6 to JUPITER-NORTH
Changed TARGNAME from SDSS-J111215.82+111745.0 to SDSSJ111215.82+111745.0
Changed TARGNAME from QSO-232154+155834 to QSO232154+155834
Changed TARGNAME from EUROPA3 to EUROPA
Changed TARGNAME from EUROPA2 to EUROPA
Changed TARGNAME from SK-155 to SK155
Changed TARGNAME from HD-204827 to HD204827
Changed TARGNAME from AZV-307 to AZV307
Changed TARGNAME from GW-LIB-COPY to GWLIB
Changed TARGNAME from QSO-163056+043559 to QSO163056+043559
Changed TARGNAME from QSO-B0157+001 to QSOB0157+001
Changed TARGNAME from NGC-3259 to NGC3259
Changed TARGNAME from 2MASS-J11321056+1335091 to 2MASSJ11321056+1335091
Changed TARGNAME from TWA-2 to TWA2
Changed TARGNAME from TWA-7 to TWA7
Changed TARGNAME from 2MASX-J10053271-2417161 to 2MASXJ10053271-2417161
Changed TARGNAME from ESO-031--G-008 to ESO031-G008
Changed TARGNAME from SDSS-J130728.45+542652.3 to SDSSJ130728.45+542652.3
Changed TARGNAME from SDSS-J115552.80+292238.4 to SDSSJ115552.80+292238.4
Changed TARGNAME from GD-408 to GD408
Changed TARGNAME from AZV-468 to AZV468
Changed TARGNAME from AZV-461 to AZV461
Changed TARGNAME from V410-TAU to V410TAU
Changed TARGNAME from SDSS-J142927.28+523849.5 to SDSSJ142927.28+523849.5
Changed TARGNAME from JUP-S-2-VISIT4 to JUP-S-2
Changed TARGNAME from JUP-S-2-VISIT5 to JUP-S-2
Changed TARGNAME from JUP-S-2-VISIT2 to JUP-S-2
Changed TARGNAME from JUP-S-2-VISIT3 to JUP-S-2
Changed TARGNAME from LHS-310-UPDATED to LHS310
Changed TARGNAME from VV2006-J091431.8+083742 to VV2006J091431.8+083742
Changed TARGNAME from PG-1407+265 to PG1407+265
Changed TARGNAME from V803-CEN to V803CEN
Changed TARGNAME from JUP-N-1-VISIT6 to JUP-N-1
Changed TARGNAME from JUP-N-1-VISIT7 to JUP-N-1
Changed TARGNAME from JUP-N-1-VISIT4 to JUP-N-1
Changed TARGNAME from JUP-N-1-VISIT5 to JUP-N-1
Changed TARGNAME from JUP-N-1-VISIT2 to JUP-N-1
Changed TARGNAME from JUP-N-1-VISIT3 to JUP-N-1
Changed TARGNAME from NGC-3227 to NGC3227
Changed TARGNAME from QSO-B0906+3248 to QSOB0906+3248
Changed TARGNAME from 2MASS-J14042827+3353426 to 2MASSJ14042827+3353426
Changed TARGNAME from QSO-1503-4155 to QSO1503-4155
Changed TARGNAME from SK-67-5 to SK675
Changed TARGNAME from 1RXS-J105010.3-140431 to 1RXSJ105010.3-140431
Changed TARGNAME from CALLISTO-COPY to CALLISTO
Changed TARGNAME from NAME-RW-AUR-A to RW-AUR-A
Changed TARGNAME from JUPITER-NORTH-14 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-11 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-10 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-13 to JUPITER-NORTH
Changed TARGNAME from JUPITER-NORTH-12 to JUPITER-NORTH
Changed TARGNAME from NGC-7094 to NGC7094
Changed TARGNAME from 2MASX-J17172551+2911075 to 2MASXJ17172551+2911075
Changed TARGNAME from SDSS-J004042.09-110957.7 to SDSSJ004042.09-110957.7
Changed TARGNAME from JUP-SOUTH2 to JUP-SOUTH
Changed TARGNAME from AZV-476 to AZV476
Changed TARGNAME from QSO-215743+233037 to QSO215743+233037
Changed TARGNAME from QSO-B1435-0645 to QSOB1435-0645
Changed TARGNAME from 2MASS-J13482237+2456498 to 2MASSJ13482237+2456498
Changed TARGNAME from QSO-B0007+107 to QSOB0007+107
Changed TARGNAME from QSO-B0844+349 to QSOB0844+349
Changed TARGNAME from JUPITER-NORTH-SPOT-SHORTVISIT to JUPITER-NORTH-SPOT
Changed TARGNAME from AZV-95 to AZV95
Changed TARGNAME from NGC-3783 to NGC3783
Changed TARGNAME from 2MASS-J14294076+0321257 to 2MASSJ14294076+0321257
Changed TARGNAME from SDSS-J083803.67+540642.1 to SDSSJ083803.67+540642.1
Changed TARGNAME from WD-J1929+4447 to WDJ1929+4447
Changed TARGNAME from 2MASS-J09512393+3542490 to 2MASSJ09512393+3542490
Changed TARGNAME from V836-TAU to V836TAU
Changed TARGNAME from NGC-4051 to NGC4051
Changed TARGNAME from HS-1522+6615 to HS1522+6615
Changed TARGNAME from MRK-390 to MRK390
Changed TARGNAME from AZV-446 to AZV446
Changed TARGNAME from MRK-1499 to MRK1499
Changed TARGNAME from QSO-J0456-2159 to QSOJ0456-2159
Changed TARGNAME from RXS-J00057-5007 to RXSJ00057-5007
Changed TARGNAME from NGC-5548 to NGC5548
Changed TARGNAME from FIRST-J020930.7-043826 to FIRSTJ020930.7-043826
Changed TARGNAME from SDSS-J151507.43+065708.3 to SDSSJ151507.43+065708.3
Changed TARGNAME from SDSS-J125013.50+073441.5 to SDSSJ125013.50+073441.5
Changed TARGNAME from HD-163296 to HD163296
Changed TARGNAME from SDSS-J160519.70+144852.2 to SDSSJ160519.70+144852.2
Changed TARGNAME from V485-CEN to V485CEN
Changed TARGNAME from JUPITER-SOUTH-3 to JUPITER-SOUTH
Changed TARGNAME from JUPITER-SOUTH-2 to JUPITER-SOUTH
Changed TARGNAME from XTE-J1118+480 to XTEJ1118+480
Changed TARGNAME from QSO-B0026+129 to QSOB0026+129
Changed TARGNAME from HD-169142 to HD169142
Changed TARGNAME from GD-71 to GD71
Changed TARGNAME from SK-190 to SK190
Changed TARGNAME from AZV-189 to AZV189
Changed TARGNAME from SDSS-J135726.27+043541.4 to SDSSJ135726.27+043541.4
Changed TARGNAME from GJ-436 to GJ436
Changed TARGNAME from AZV-238 to AZV238
Changed TARGNAME from MRK-1044 to MRK1044
Changed TARGNAME from VV2006-J105910.9+051935 to VV2006J105910.9+051935
Changed TARGNAME from SDSS-J081552.00+215623.6 to SDSSJ081552.00+215623.6
Changed TARGNAME from NGC5139-UIT-2-REVISED to NGC5139-UIT-2
Changed TARGNAME from TOL-0440-381 to TOL0440-381
Changed TARGNAME from SDSS-J140347.22+062812.1 to SDSSJ140347.22+062812.1
Changed TARGNAME from AZV-77 to AZV77
Changed TARGNAME from SK-66-172 to SK66172
Changed TARGNAME from QSO-J1019+2745 to QSOJ1019+2745
Changed TARGNAME from HD-142527 to HD142527
Changed TARGNAME from QSO-091620+240804 to QSO091620+240804
Changed TARGNAME from QSO-B1124+271 to QSOB1124+271
Changed TARGNAME from HD-6655 to HD6655
Changed TARGNAME from 2MASS-J09311671+2628474 to 2MASSJ09311671+2628474
Changed TARGNAME from SDSS-J074511.56+194926.5 to SDSSJ074511.56+194926.5
Changed TARGNAME from PG-1206+459 to PG1206+459
Changed TARGNAME from G-191B2B to G191B2B
Changed TARGNAME from QSO-B0923+201 to QSOB0923+201
Changed TARGNAME from GD-40 to GD40
Changed TARGNAME from VV2006-J140655.7+015713 to VV2006J140655.7+015713
Changed TARGNAME from MRK-829 to MRK829
Changed TARGNAME from WD-2218+706 to WD2218+706
Changed TARGNAME from EUROPA-ECLIPSE-COPY to EUROPA-ECLIPSE
Changed TARGNAME from AZV-429 to AZV429
Changed TARGNAME from SK-68140 to SK68140
Changed TARGNAME from PG-1630+377 to PG1630+377
Changed TARGNAME from VV96-J100254.6+324039 to VV96J100254.6+324039
Changed TARGNAME from 4C-13.41 to 4C13.41
Changed TARGNAME from QSO-B2214+139 to QSOB2214+139
Changed TARGNAME from QSO-023306-014950 to QSO023306-014950
Changed TARGNAME from 2MASX-J13242823+0446298 to 2MASXJ13242823+0446298
Changed TARGNAME from SK-9 to SK9
Changed TARGNAME from GD-133 to GD133
Changed TARGNAME from 2MASS-J10512569+1247462 to 2MASSJ10512569+1247462
Changed TARGNAME from VV2006-J085259.2+031320 to VV2006J085259.2+031320
Changed TARGNAME from VV2006-J131545.2+152556 to VV2006J131545.2+152556
Changed TARGNAME from AZV-43 to AZV43
Changed TARGNAME from AZV-47 to AZV47
Changed TARGNAME from SK-68155 to SK68155
Changed TARGNAME from V2129-OPH to V2129OPH
Changed TARGNAME from SDSS-J150928.29+070235.7 to SDSSJ150928.29+070235.7
Changed TARGNAME from COMET-ISON-EPOCH2-OFFSET to COMET-ISON-OFFSET
Changed TARGNAME from V446-HER to V446HER
Changed TARGNAME from V455-AND to V455AND
Changed TARGNAME from MRK-727 to MRK727
Changed TARGNAME from 2MASX-J15442722+2743237 to 2MASXJ15442722+2743237
Changed TARGNAME from JUPITER-NORTH-SPOT-LONGVISIT to JUPITER-NORTH-SPOT
Changed TARGNAME from LHS3003-UPDATE to LHS3003
Changed TARGNAME from MRK-589 to MRK589
Changed TARGNAME from IRAS23365+3604-TWEAK to IRAS23365+3604
Changed TARGNAME from UGCA-116 to UGCA116
Changed TARGNAME from AZV-439 to AZV439
Changed TARGNAME from MRK-105 to MRK105
Changed TARGNAME from VV2006-J105956.1+121151 to VV2006J105956.1+121151
Changed TARGNAME from NAME-UX-TAU-A to UX-TAU-A
Changed TARGNAME from V819-TAU to V819TAU
Changed TARGNAME from WD-1657+343 to WD1657+343
Changed TARGNAME from CL-NGC-330-ELS-4 to NGC-330-ELS-4
Changed TARGNAME from WD-0320-539 to WD0320-539
Changed TARGNAME from SDSS-J150952.19+111047.0 to SDSSJ150952.19+111047.0
Changed TARGNAME from V709-CAS to V709CAS
Changed TARGNAME from 4C-06.41 to 4C06.41
Changed TARGNAME from QSO-1504-4152 to QSO1504-4152
Changed TARGNAME from TOL-1247-232 to TOL1247-232
Changed TARGNAME from WD-0308-565 to WD0308-565
Changed TARGNAME from GW-LIB-COPY2 to GWLIB
Changed TARGNAME from VV2006-J080838.8+051440 to VV2006J080838.8+051440
Changed TARGNAME from SDSS-J090704.88+532656.6 to SDSSJ090704.88+532656.6
Changed TARGNAME from SDSS-J145424.33+304658.3 to SDSSJ145424.33+304658.3
Changed TARGNAME from PG-1225-079 to PG1225-079
Changed TARGNAME from QSO-170621+590406 to QSO170621+590406
Changed TARGNAME from NGC-3353 to NGC3353
Changed TARGNAME from COMET-ISON-EPOCH2 to COMET-ISON
Changed TARGNAME from COMET-ISON-EPOCH1 to COMET-ISON
Changed TARGNAME from JUPITER-SOUTH-1 to JUPITER-SOUTH
Changed TARGNAME from TOL26-UPDATED to TOL26
Changed TARGNAME from NGC-7469 to NGC7469
Changed TARGNAME from UGCA-166 to UGCA166
Changed TARGNAME from SK-68-135 to SK68135
Changed TARGNAME from QSO-B0050+124 to QSOB0050+124
Changed TARGNAME from QSO-214927-085903 to QSO214927-085903
Changed TARGNAME from QSO-B1307+085 to QSOB1307+085
Changed TARGNAME from SDSS-J151237.05+012846. to SDSSJ151237.05+012846.
Changed TARGNAME from SDSS-J135424.90+243006.3 to SDSSJ135424.90+243006.3
Changed TARGNAME from SDSS-J082354.96+280621.6 to SDSSJ082354.96+280621.6
Changed TARGNAME from HS-2209+8229 to HS2209+8229
Changed TARGNAME from ESO-141-55 to ESO141-55
Changed TARGNAME from HD-189733 to HD189733
Changed TARGNAME from VV2006-J112005.0+041323 to VV2006J112005.0+041323
Changed TARGNAME from UGC-12011 to UGC12011
Changed TARGNAME from G-111-72 to G111-72
Changed TARGNAME from SK-71-45 to SK7145
Changed TARGNAME from QSO-B1139+305 to QSOB1139+305
Changed TARGNAME from FBQS-0751+2919 to FBQS0751+2919
Changed TARGNAME from QSO-B1411+4414 to QSOB1411+4414
Changed TARGNAME from NGC-7673 to NGC7673
Changed TARGNAME from IO-EMERGED-2 to IO-EMERGED
Changed TARGNAME from V471-TAU to V471TAU
Changed TARGNAME from HD-169454 to HD169454
Changed TARGNAME from 2MASX-J17402482+4743586 to 2MASXJ17402482+4743586
Changed TARGNAME from VV2006-J111507.6+023757 to VV2006J111507.6+023757
Changed TARGNAME from HD-104237 to HD104237
Changed TARGNAME from HS-0033+4300 to HS0033+4300
Changed TARGNAME from RXS-J21388-3828 to RXSJ21388-3828
Changed TARGNAME from AZV-148 to AZV148
Changed TARGNAME from UKS-0242-724 to UKS0242-724
Changed TARGNAME from JUP-S-1-VISIT3 to JUP-S-1
Changed TARGNAME from JUP-S-1-VISIT2 to JUP-S-1
Changed TARGNAME from JUP-S-1-VISIT5 to JUP-S-1
Changed TARGNAME from JUP-S-1-VISIT4 to JUP-S-1
Changed TARGNAME from JUP-S-1-VISIT7 to JUP-S-1
Changed TARGNAME from JUP-S-1-VISIT6 to JUP-S-1
Changed TARGNAME from 2MASX-J01013113+4229356 to 2MASXJ01013113+4229356
Changed TARGNAME from 2MASS-J10131797+0500342 to 2MASSJ10131797+0500342
Changed TARGNAME from MRK-279 to MRK279
Changed TARGNAME from PG-1522+101 to PG1522+101
Changed TARGNAME from WD-0947+857 to WD0947+857
Changed TARGNAME from AZV-388 to AZV388
Changed TARGNAME from SDSS-J103304.86+211216.1 to SDSSJ103304.86+211216.1
Changed TARGNAME from 2MASS-J15412146+2817063 to 2MASSJ15412146+2817063
Changed TARGNAME from PG-1351+489 to PG1351+489
Changed TARGNAME from 2MASS-J14312586+2442203 to 2MASSJ14312586+2442203
Changed TARGNAME from QSO-B1126-041 to QSOB1126-041
Changed TARGNAME from GW-LIB to GWLIB
Changed TARGNAME from VV2000-J150204.1+064514 to VV2000J150204.1+064514
Changed TARGNAME from SDSS-J085053.12+445122.5 to SDSSJ085053.12+445122.5
Changed TARGNAME from QSO-B2356-309 to QSOB2356-309
Changed TARGNAME from AZV-177 to AZV177
Changed TARGNAME from GANYMEDE1A-REPEAT to GANYMEDE1A
Changed TARGNAME from NGC4214-OBJECT-1-REVISIT to NGC4214-OBJECT-1
Changed TARGNAME from SDSS-J145735.13+223201.8 to SDSSJ145735.13+223201.8
Changed TARGNAME from MARS-STIS to MARS
Changed TARGNAME from EUROPA-TRANSIT2 to EUROPA-TRANSIT
Changed TARGNAME from UM-305 to UM305
Changed TARGNAME from JUP-NORTH2 to JUP-NORTH
Changed TARGNAME from RXS-J23218-7026 to RXSJ23218-7026
Changed TARGNAME from NGC-2808 to NGC2808
Changed TARGNAME from QSO-B1115+080A to QSOB1115+080A
Changed TARGNAME from UPWIND-COPY to UPWIND
Changed TARGNAME from IO-WEST-2 to IO-WEST
Changed TARGNAME from IO-WEST-1 to IO-WEST
Changed TARGNAME from GD-303 to GD303
Changed TARGNAME from SK-70-115 to SK70115
Changed TARGNAME from VV2006-J015953.0+134554 to VV2006J015953.0+134554
Changed TARGNAME from MRK-0421 to MRK0421
Changed TARGNAME from GD-205 to GD205
Changed TARGNAME from LBQS-1435-0134 to LBQS1435-0134
Changed TARGNAME from SKY-NEAR-MARS-VISIT-01 to SKY-NEAR-MARS
Changed TARGNAME from SKY-NEAR-MARS-VISIT-02 to SKY-NEAR-MARS
Changed TARGNAME from SDSS-J221806.67+005223.6 to SDSSJ221806.67+005223.6
Changed TARGNAME from PG-1338+416 to PG1338+416
Changed TARGNAME from QSO-003916-511701 to QSO003916-511701
Changed TARGNAME from SK-116 to SK116
Changed TARGNAME from 2MASS-J09215939+4509126 to 2MASSJ09215939+4509126
Changed TARGNAME from SDSS-J131535.06+620728.6 to SDSSJ131535.06+620728.6
Changed TARGNAME from FBQS.J130451.4+245445 to FBQSJ130451.4+245445
Changed TARGNAME from H-1821+643 to H1821+643
Changed TARGNAME from 4C--01.61 to 4C01.61
Changed TARGNAME from SK-143 to SK143
Changed TARGNAME from SK-68129 to SK68129
Changed TARGNAME from QSO-B1617+1731 to QSOB1617+1731
Changed TARGNAME from JUP-N-SPECTRO-VISIT9 to JUP-N-SPECTRO
Changed TARGNAME from QSO-B1351+6400 to QSOB1351+6400
Changed TARGNAME from SDSS-J131802.01+262830.3 to SDSSJ131802.01+262830.3
Changed TARGNAME from JUP-N-SPECTRO-VISIT8 to JUP-N-SPECTRO
In [4]:
changed_targnames = set(new_targnames) - targnames
In [5]:
print len(changed_targnames), len(targnames)
244 1745
In [ ]:
Content source: justincely/lightcurve_pipeline
Similar notebooks: