Examples
DR1: Master catalogue
Get Master table of the DR1 galaxies
SELECT * FROM dr1.Master
DR1: get PPAK cubes filtered
Retrieve DR1 PPAK fits files for all the late type galaxies (morphological T-type greater than 0) at the redshift less than 0.030 and belonging to the voids 482 or 487
SELECT galaxy, file FROM dr1.PPAK_cubes WHERE galaxy IN ( SELECT galaxy FROM dr1.Master WHERE morphology > 0 AND redshift <= 0.030 AND void IN (482,487) )
DR1: get a selection of PPAK Footprint and Moment0 images
Get DR1 PPAK Footprint and Moment0 images of the selected galaxies
SELECT galaxy, img_footprint AS Footprint_Image , img_moment AS Moment0_Image FROM dr1.PPAK_images WHERE galaxy IN (52731,52732,52733,52734,52735)
DR1: Morphological data from galaxies of a given void
Get morphological data from galaxies from a given void. Customize: Change void id to the wanted. Wanted table can also be changed,instead of Morphology.
SELECT mor.* FROM dr1.Master m, dr1.Morpho mor WHERE m.galaxy = mor.galaxy AND m.void = 439