def desQuery(self,ra,dec,radius_arcmin=1,columns="*"):
radius_degree = CoordinateParser.getMinToDegree(radius_arcmin)
query_template = "SELECT {0:s} FROM des_dr1.main WHERE q3c_radial_query(ra,dec,{1:f},{2:f},{3:f})"
query = query_template.format(columns, ra, dec, radius_degree)
df = None
try:
result = qc.query(self.getToken(), sql=query) # by default the result is a CSV formatted string
result = result.decode('utf8').replace("'", '"')
df = helpers.convert(result, 'pandas')
except Exception as e:
print(e)
return df
def getData(ra, dec, radius=1.0, columns='*'):
query_template = \
"""SELECT {0:s} FROM nsc_dr1.object
WHERE q3c_radial_query(ra,dec,{1:f},{2:f},{3:f})"""
query = query_template.format(columns, ra, dec, radius)
print(query)
try:
result = qc.query(
token,
sql=query) # by default the result is a CSV formatted string
except Exception as e:
print(e.message)
df = helpers.convert(result, 'table') # pandas
return df
def getDataCuts(ra,
dec,
radius=1.0,
columns='ra,dec,gmag,rmag',
colcutlo=None,
colcuthi=None,
classcut=None,
fwhmcut=None,
errcut=None):
query_template = \
"""SELECT {0:s} FROM nsc_dr1.object
WHERE q3c_radial_query(ra,dec,{1:f},{2:f},{3:f})"""
# (gmag-rmag)>({4:f}) and (gmag-rmag)<{5:f} and class_star>{6:f} and
# fwhm<{7:f} and gerr<{8:f} and rerr<{8:f}
query = query_template.format(columns, ra, dec, radius, colcutlo, colcuthi,
classcut, fwhmcut, errcut)
if colcutlo is not None:
query += " and (gmag-rmag)>(" + "{0:f}".format(colcutlo) + ")"
if colcuthi is not None:
query += " and (gmag-rmag)<" + "{0:f}".format(colcuthi)
if classcut is not None:
query += " and class_star>" + "{0:f}".format(classcut)
if fwhmcut is not None: query += " and fwhm<" + "{0:f}".format(fwhmcut)
if errcut is not None: query += " and gerr<" + "{0:f}".format(errcut)
if errcut is not None: query += " and rerr<" + "{0:f}".format(errcut)
print(query)
try:
result = qc.query(
token,
sql=query) # by default the result is a CSV formatted string
except Exception as e:
print(e.message)
df = helpers.convert(result, 'table') # pandas
return df