AHFMatch

This table provides the mapping between AHF halos from a simulation including gas and star formation with its corresponding dark matter only simulation. The match is performed based on the particleIds in each halo, using the AHF merger tree code. Since the mapping was done from halos in the gas simulation to halos in the dm simulation, it can happen that dm-haloIds occur multiple times.

Column Type UCD Unit Description
ahfId_Gas bigint meta.id; meta.main unique id for AHF halo in AHF table of corresponding simulation with gas and star formation
ahfId_DM bigint meta.id; meta.main unique id for AHF halo in AHF table of corresponding simulation with dark matter only

Example

Match the most massive halos at redshift 0 from the Clues3_LGGas simulation with its counterparts in the Clues3_LGDM simulation:

SELECT * FROM 
Clues3_LGGas.AHFMatch as m, 
Clues3_LGGas.AHF as gas, 
Clues3_LGDM.AHF as dm
WHERE m.ahfId_Gas = gas.ahfId 
AND m.ahfId_DM = dm.ahfId
ORDER BY gas.Mvir DESC
LIMIT 10

This query joins the corresponding AHF tables with the AHFMatch table to extract the properties of corresponding halos.

Proudly powered by Daiquiri
©2016 The CosmoSim databaseImprint and Data Protection Statement