I need a table of all the objects in a particular coordinate range, for cross-matching purposes

Question

Hi,

I'm a radio astronomer and am wanting to cross-match radio against DES galaxies. I need a table of all the objects, as per the following SQL query, but it caps the output table at 500,000 objects (meaning I don't get all the objects in the range I want):

SELECT RA, DEC

FROM des_dr2.main

WHERE (ra BETWEEN 33 and 40

and dec BETWEEN -7 and -2)

The table output gives me objects between the following ranges:

33.000004 36.869875

-6.999995 -5.780898

How can I access bigger tables, as I'll eventually need the entire southern sky?!

Thank you.

Albany

Answer 1

Hi, please run the query in the Jupyter notebook server instead, using the queryClient. (there are many examples in our notebook collection: https://github.com/astro-datalab/notebooks-latest/

For long running queries, please use async mode (argument `async_=True` in the `queryClient.query()` call.)