Example Queries for TAP Service

Objects with a known spectral type

Obtaining objects with a known spectral type:

SELECT * 
 FROM mudehar.Sources WHERE gos_spty <> '' OR skiff_spty <> ''

Cone search

Search objects using a cone search:

SELECT * 
 FROM mudehar.Sources 
 WHERE CONTAINS(POINT('', ra, dec), CIRCLE('', 307.3083, 40.3260, .005)) = 1

Cone search

Obtaining all information about a specific star including the data of the pointing block using its GOS name (for example 'Cyg_OB2-1':

SELECT s.*, ob.exp_names, ob.exp_ts, ob.exp_jd 
 FROM mudehar.Sources s JOIN mudehar.Pointing_block ob ON s.pb_id = ob.id 
 WHERE NAME_GOS = 'Cyg_OB2-1'