Useful queries
A number of example queries dealing with specific tables can also be found at each table type documentation, see Database Tables.
And if you cannot find what you are looking for, please send us a message via the Contact form.
How to get redshifts and snapshot numbers for a simulation?
For each simulation, there is a table called redshifts
, e.g. MDR1 Redshifts
. This tables contains redshifts (zred) with their scale factor (aexp) and snapshot number (snapnum) of the simulation.
A query would look like this:
SELECT zred, snapnum, aexp FROM mdr1.redshifts
ORDER BY snapnum DESC
If you want to know which data is available for each redshift, then consult the availhalos
tables for each simulation,
e.g. MDR1 AvailHalos
table. It contains a table with the snapshot numbers, redshifts and available halo data, like FOF- and BDM-catalogue, halo profiles etc. Consult the corresponding documentation for the possible columns.
SELECT snapnum, fof FROM mdpl.availhalos
WHERE fof IS NOT NULL ORDER BY snapnum
How to find the main branch of one FOF halo?
SELECT prog.* FROM mdr1.fofmtree AS prog,
( SELECT foftreeid, mainleafid FROM MDR1.FOFMtree WHERE fofid = 85000000000 ) AS descend
WHERE prog.foftreeid BETWEEN descend.foftreeid AND descend.mainleafid
ORDER BY prog.foftreeid ASC
Replace the fofid
85000000000 by the fofid
of the halo you are interested in (choose from the mdr1.fof
table). See Merger trees for more information on the structure of merger trees in the database.
How to extract progenitors of BDM halos?
Unfortunately, it is not possible to do this directly, since there are no merger tree tables for BDM-catalogues available in the database.
The halos' bdmid
s of different timesteps are NOT related with each other, that link can only be established with a merger tree. Since we only have merger trees for FOF and Rockstar catalogues in the database, you could use e.g. the FOF merger tree and match BDM halos with their closest FOF halo.