In [1]:

    

from lightcurve_pipeline.utils.utils import SETTINGS
from lightcurve_pipeline.database.database_interface import session
from lightcurve_pipeline.database.database_interface import Metadata
from xml.dom import minidom
import urllib2


    

In [2]:

    

query = session.query(Metadata.targname).all()
targnames = set([result[0] for result in query])
coords_list = []


    

In [3]:

    

for targname in targnames:
    web_string = 'http://mastresolver.stsci.edu/Santa-war/query?name={}'.format(targname)
    try:
        xmldoc = minidom.parse(urllib2.urlopen(web_string))
        ra = str(xmldoc.getElementsByTagName('ra')[0].childNodes[0].data)
        dec = str(xmldoc.getElementsByTagName('dec')[0].childNodes[0].data)
    except:
        ra = 'NA'
        dec = 'NA'
        
    coords = (ra, dec)
    coords_list.append(coords)


    

In [4]:

    

sucessful_coords_list = []
for targname, coords in zip(targnames, coords_list):
    if coords != ('NA', 'NA'):
        if coords_list.count(coords) > 1:
            print targname, coords


    

    




NGC3516 ('166.69788', '72.56858')
Q2128-123 ('322.89692', '-12.118')
MRK-509 ('311.04058', '-10.72348')
NGC-4395 ('186.45359', '33.54693')
AV75 ('12.63496', '-72.87681')
NGC-3516 ('166.69788', '72.56858')
IRAS-F04250-5718 ('66.50302', '-57.20027')
HD39801 ('88.79293899', '7.407064')
BETELGEUSE ('88.79293899', '7.407064')
V822CEN ('224.59141', '-31.66858')
RBS542 ('66.50302', '-57.20027')
NGC4395 ('186.45359', '33.54693')
CENX-4 ('224.59141', '-31.66858')
MRK421 ('166.11381', '38.20883')
PHL1598 ('322.89692', '-12.118')
MARK509 ('311.04058', '-10.72348')
AZV75 ('12.63496', '-72.87681')
MRK-0421 ('166.11381', '38.20883')

In [ ]: