Sample queries
The first 1000 stars with reliable stellar parameters
We highly recommend only using those stellar parameters for stars with flag_cannon = 0, i.e., there is no information suggesting the star's parameters are untrustworthy. See the table schema for more information on the flagging.
If you wish to get the entire table, simply remove the TOP 1000 line.
SELECT
TOP 1000
*
FROM galah_dr2.galahdr2cat
WHERE
flag_cannon = 0How many stars have reliable oxygen and barium abundances?
We recommend only using a given elemental abundance for a given star where flag_x_fe = 0 (where x is the element symbol in lower case, e.g., ba, o).
These individual element flags are set to 8 if the global flag_cannon > 0, so it is not necessary to include flag_cannon = 0 in this query. See the table schema for more information on the flagging.
SELECT
COUNT(*)
FROM galah_dr2.galahdr2cat
WHERE
flag_ba_fe = 0 and flag_o_fe = 0Potential members of the globular cluster NGC362
The globular cluster NGC362 was serendipitously observed as part of one our regular survey fields (field_id = 32). The cluster has a large systemic radial velocity, so we find the stars in that field that are potential members.
SELECT
*
FROM galah_dr2.galahdr2cat
WHERE
field_id = 32 and rv_synt > 200 and rv_synt < 230