Download GAMA spectra for specific ranges of luminosity and colour
First we need to head to the Catalogue Query page located under the services dropdown tab at the top left of the main Data Central page.
You will then come to this page:
From here you can enter a title for the data pull, and also some notes on what is being attempted.
In the third text box you write the SQL code for this data pull. To find information about the surveys collected data, you can look in the schema. Which can be found on the front page.
The code for this Query would look like this:
SELECT t1.CATAID, t1.absmag_g, t1.absmag_r, ( 4 * 3.141592653589 * POWER(30.86 * POWER(10, 18), 2) * POWER(10, (t1.absmag_r + 48.594) * -0.4) ) AS Lum FROM gama_dr2.StellarMasses as t1 WHERE ( 4 * 3.141592653589 * POWER(30.86 * POWER(10, 18), 2) * POWER(10, (t1.absmag_r + 48.594) * -0.4) ) > POWER(10,30) AND t1.absmag_g-t1.absmag_r > 0.4;
Fill in the email and finally submit with the Queue button. Doing so will bring you to a page with a URL link, follow this link. Once you click this link you will be brought to a page with a table of all of the data.
Download the table of data using the download options on the top right.
Extract the files that were downloaded to your preferred location so that you can access the data. You may need to do this multiple times to get to the actual files.