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.

GALAH logo

GALAH

The Galactic Archaeology with HERMES survey is collecting stellar parameters and abundances for one million stars in the Milky Way. GALAH yields a comprehensive view of the formation & evolution of the Galaxy.
March 27, 2018 by S. Martell
Oct. 11, 2020, 3:49 a.m. J. Simpson

Sample queries

GALAH DR2

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 = 0

How 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 = 0

Potential 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
March 27, 2018 by S. Martell
Oct. 11, 2020, 3:49 a.m. J. Simpson