nb1. Query one source

import numpy as np
import astropy
import astropy.coordinates
import pyvo
import pandas as pd

service = pyvo.dal.TAPService("https://almascience.eso.org/tap")      # for the EU ALMA TAP service

# service = pyvo.dal.TAPService("https://almascience.nao.ac.jp/tap")  # for the EA ALMA TAP service
# service = pyvo.dal.TAPService("https://almascience.nrao.edu/tap")   # for the NA ALMA TAP service

def query_coordinate(service, ra, dec, radius):
    """Queries ALMA footprints that intersect the search circle
    
       service        pyvo TAPService instance           
       ra             Right Ascension in decimal degrees
       dec            Declination in decimal degrees
       radius         Search radius in decimal degrees
           
       returns        pandas table
       """    
    
    query = f"""
            SELECT * 
            FROM ivoa.obscore   
            WHERE INTERSECTS(CIRCLE('ICRS',{ra},{dec},{radius}),s_region)=1  """
    
    return service.search(query).to_table().to_pandas()

def query_coordinate_display_distance(service, ra, dec, radius):
    """Queries ALMA footprints that intersect the search circle
    
       service        pyvo TAPService instance           
       ra             Right Ascension in decimal degrees
       dec            Declination in decimal degrees
       radius         Search radius in decimal degrees
           
       returns        pandas table including the distance column
       """    

    query = f""" 
            SELECT DISTANCE(POINT('ICRS', s_ra, s_dec), POINT('ICRS',{ra},{dec})) AS dist, * 
            FROM ivoa.obscore 
            WHERE INTERSECTS(CIRCLE('ICRS',{ra},{dec},{radius}),s_region)=1 
            ORDER BY dist"""

    return service.search(query).to_table().to_pandas()

def query_alma_source_name_exact(service, source_name):
    """ queries the ALMA source name as given by the PI
    
       service        pyvo TAPService instance           
       source_name    complete source name 
           
       returns        pandas table
    """
    
    query = f"""  
            SELECT *  
            FROM ivoa.obscore  
            WHERE target_name = '{source_name}' """
    
    return service.search(query).to_table().to_pandas()


def query_alma_source_name_included(service, source_name):
    """ queries a portion of the ALMA source name as given by the PI
    
       service        pyvo TAPService instance           
       source_name    portion of the source name 
           
       returns        pandas table
    """   
    
    query = f""" 
            SELECT *  
            FROM ivoa.obscore  
            WHERE target_name LIKE '%{source_name}%'  """
    
    return service.search(query).to_table().to_pandas()

coordinates = astropy.coordinates.SkyCoord.from_name("Cen A")