Data Central uses cookies to make your browsing experience better. By using Data Central you agree to its use of cookies. Learn more I agree

Documentation

Find information, examples, FAQs and extensive descriptions of the data, curated by the survey teams.

Docs hc

Help Center

Browse FAQs, guides and tutorials on common use cases.
Feb. 5, 2018 by L. Mannering
May 20, 2020, 6 a.m. J. Tocknell

Query Service Examples

The purpose of the catalogue query service is to search through all the catalogues within Data Central and extract useful information which can then be used within other Data Central tools, such as the Single Object Viewer or Bulk Download. Below are some examples to help you get started, as well as links to example science use cases where the query service is used. More detailed documentation for the query service can be found in the reference.

Examples

If you have an example you'd like to add, please get in touch.

Return all galaxies in a pair, with redshift (0.1< z<0.3) and quality flag cut.

SELECT t1.PairID, t1.Gal1CATAID, t1.Gal2CATAID, t2.CATAID, t2.Z, t2.nQ
FROM gama_dr2.G3CGalsInPair as t1
INNER JOIN gama_dr2.StellarMasses as t2 on t2.CATAID = t1.Gal1CATAID
WHERE t2.Z BETWEEN 0.1 and 0.3
AND t2.nQ > 2

For GAMA groups with Ngal>4 and 0.02< z <0.1, how many brightest cluster galaxies are also central cluster galaxies.

SELECT t1.GroupID, t1.Nfof, t1.IterCenCATAID, t1.Zfof, t1.BCGCATAID
FROM   gama_dr2.G3CFoFGroup as t1
WHERE  t1.Zfof BETWEEN 0.02 and 0.1
AND    t1.Nfof > 4

Select all galaxies that are denied as being in a group based on the GAMA group catalogue and also in an over-dense environment using the EnvironmentalMeasures catalogue (SIGMA_5>5), and have stellar mass>10^10.

SELECT t1.CATAID, t1.GroupID, t2.fluxscale, t2.logmstar, t3.SurfaceDensity
FROM gama_dr2.G3CGal as t1
INNER JOIN gama_dr2.StellarMasses as t2 on t2.CATAID = t1.CATAID
INNER JOIN gama_dr2.EnvironmentMeasures as t3 on t3.CATAID = t1.CATAID
WHERE t1.GroupID = 0
AND t3.SurfaceDensity > 5
AND (t2.logmstar + LOG10(t2.fluxscale) - 2*LOG10(0.67/0.7)) > 10

Using ADQL

SELECT top 50 a.aat_id,g.CATAID
FROM aat.aat_archive as a, gama_dr2.InputCatA as g
WHERE 1 = CONTAINS(
    POINT('ICRS', g.RA, g.DEC),
    CIRCLE(
        'ICRS',
        a.observation_log_raj2000_int/3600000.0,
        a.observation_log_decj2000_int/3600000.0,
        1.0
    )
) and g.CATAID=202627
Feb. 5, 2018 by L. Mannering
May 20, 2020, 6 a.m. J. Tocknell