Difference between revisions of "ZEST v1.0"

From Public PIC Wiki
Jump to navigation Jump to search
Line 4: Line 4:
  
 
== SQL ==
 
== SQL ==
−
    CREATE EXTERNAL TABLE tallada.zest (
+
<pre>
−
        `SequentialID` INT COMMENT "Identification number",
+
CREATE EXTERNAL TABLE tallada.zest (
−
        `RA` FLOAT COMMENT "Right ascension (degrees)",
+
    `SequentialID` INT COMMENT "Identification number",
−
        `DEC` FLOAT COMMENT "Declination (degrees)",
+
    `RA` FLOAT COMMENT "Right ascension (degrees)",
−
        `CAPAK_ID` FLOAT COMMENT "ID based on ground-based photometric catalog of Capak 2006",
+
    `DEC` FLOAT COMMENT "Declination (degrees)",
−
        `CAPAK_RA` FLOAT COMMENT "Closest matched right ascension to ground-based catalog within 0.6\" (degrees)",
+
    `CAPAK_ID` FLOAT COMMENT "ID based on ground-based photometric catalog of Capak 2006",
−
        `CAPAK_DEC` FLOAT COMMENT "Closest matched declination to ground-based catalog within 0.6\" (degrees)",
+
    `CAPAK_RA` FLOAT COMMENT "Closest matched right ascension to ground-based catalog within 0.6\" (degrees)",
−
        `ACS_MAG_AUTO` FLOAT COMMENT "Total magnitude of object- used for catalog selection",
+
    `CAPAK_DEC` FLOAT COMMENT "Closest matched declination to ground-based catalog within 0.6\" (degrees)",
−
        `ACS_MAGERR_AUTO` FLOAT COMMENT "Magnitude error",
+
    `ACS_MAG_AUTO` FLOAT COMMENT "Total magnitude of object- used for catalog selection",
−
        `ACS_X_IMAGE` FLOAT COMMENT "X-pixel position on ACS-tile",
+
    `ACS_MAGERR_AUTO` FLOAT COMMENT "Magnitude error",
−
        `ACS_Y_IMAGE` FLOAT COMMENT "Y-pixel position on ACS-tile",
+
    `ACS_X_IMAGE` FLOAT COMMENT "X-pixel position on ACS-tile",
−
        `ACS_XPEAK_IMAGE` FLOAT COMMENT "X-pixel position of object peak flux on ACS tile",
+
    `ACS_Y_IMAGE` FLOAT COMMENT "Y-pixel position on ACS-tile",
−
        `ACS_YPEAK_IMAGE` FLOAT COMMENT "Y-pixel position of object peak flux on ACS tile",
+
    `ACS_XPEAK_IMAGE` FLOAT COMMENT "X-pixel position of object peak flux on ACS tile",
−
        `ACS_ALPHAPEAK_` FLOAT COMMENT "RA of object peak flux (degrees)",
+
    `ACS_YPEAK_IMAGE` FLOAT COMMENT "Y-pixel position of object peak flux on ACS tile",
−
        `ACS_DELTAPEAK_` FLOAT COMMENT "Dec of object peak flux (degrees)",
+
    `ACS_ALPHAPEAK_` FLOAT COMMENT "RA of object peak flux (degrees)",
−
        `ACS_A_IMAGE` FLOAT COMMENT "SExtractor semi-major axis",
+
    `ACS_DELTAPEAK_` FLOAT COMMENT "Dec of object peak flux (degrees)",
−
        `ACS_B_IMAGE` FLOAT COMMENT "SExtractor semi-minor axis",
+
    `ACS_A_IMAGE` FLOAT COMMENT "SExtractor semi-major axis",
−
        `ACS_THETA_IMAGE` FLOAT COMMENT "SExtractor position angle",
+
    `ACS_B_IMAGE` FLOAT COMMENT "SExtractor semi-minor axis",
−
        `ACS_ELONGATION` FLOAT COMMENT "SExtractor a/b [semi-major axis / semi minor axis]",
+
    `ACS_THETA_IMAGE` FLOAT COMMENT "SExtractor position angle",
−
        `ACS_CLASS_STAR` FLOAT COMMENT "SExtractor stellarity parameter",
+
    `ACS_ELONGATION` FLOAT COMMENT "SExtractor a/b [semi-major axis / semi minor axis]",
−
        `ACS_IDENT` FLOAT COMMENT "Unique number that identifies object",
+
    `ACS_CLASS_STAR` FLOAT COMMENT "SExtractor stellarity parameter",
−
        `ACS_SE` FLOAT COMMENT "0 = Detection from 'cold' pass of Sextractor, 1 = Detection from 'hot' pass of Sextractor",
+
    `ACS_IDENT` FLOAT COMMENT "Unique number that identifies object",
−
        `ACS_MU_CLASS` FLOAT COMMENT "Type of object (1 = galaxy, 2 = star, 3 = spurious)",
+
    `ACS_SE` FLOAT COMMENT "0 = Detection from 'cold' pass of Sextractor, 1 = Detection from 'hot' pass of Sextractor",
−
        `ACS_OVERLAP` FLOAT COMMENT "Object overlap flag. All objects here have overlap =1 i.e. no overlap.",
+
    `ACS_MU_CLASS` FLOAT COMMENT "Type of object (1 = galaxy, 2 = star, 3 = spurious)",
−
        `ACS_NEARSTAR` FLOAT COMMENT "Object in star mask flag. All the objects in this morphological catalog have \"nearstar = 1\" which means they are not in a star mask.",
+
    `ACS_OVERLAP` FLOAT COMMENT "Object overlap flag. All objects here have overlap =1 i.e. no overlap.",
−
        `ACS_MASK` FLOAT COMMENT "Object in automatic mask flag: 2 = star used to make automatic mask",
+
    `ACS_NEARSTAR` FLOAT COMMENT "Object in star mask flag. All the objects in this morphological catalog have \"nearstar = 1\" which means they are not in a star mask.",
−
        `ACS_MASKED` FLOAT COMMENT "Object in manual mask flag: -1 = manual mask (astrophysical obj), 0 = manual mask (artifact or image defect), 1 = not in manual mask",
+
    `ACS_MASK` FLOAT COMMENT "Object in automatic mask flag: 2 = star used to make automatic mask",
−
        `ACS_CLEAN` FLOAT COMMENT "Object useable flag: 0 = do not use this object, 1 = use this object",
+
    `ACS_MASKED` FLOAT COMMENT "Object in manual mask flag: -1 = manual mask (astrophysical obj), 0 = manual mask (artifact or image defect), 1 = not in manual mask",
−
        `ACS_UNIQUE` FLOAT COMMENT "Object unique flag. All the objects in this morphological catalog have \"unique = 1\" which means they are all \"unique\" in the original ACS catalog.",
+
    `ACS_CLEAN` FLOAT COMMENT "Object useable flag: 0 = do not use this object, 1 = use this object",
−
        `GG` FLOAT COMMENT "ZEST Gini coefficient",
+
    `ACS_UNIQUE` FLOAT COMMENT "Object unique flag. All the objects in this morphological catalog have \"unique = 1\" which means they are all \"unique\" in the original ACS catalog.",
−
        `M20` FLOAT COMMENT "ZEST second order moment of the 20% brightest pixels",
+
    `GG` FLOAT COMMENT "ZEST Gini coefficient",
−
        `CC` FLOAT COMMENT "ZEST concentration",
+
    `M20` FLOAT COMMENT "ZEST second order moment of the 20% brightest pixels",
−
        `AA` FLOAT COMMENT "ZEST asymmetry",
+
    `CC` FLOAT COMMENT "ZEST concentration",
−
        `R20` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 20% of total light (pixels)",
+
    `AA` FLOAT COMMENT "ZEST asymmetry",
−
        `R50` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 50% of total light (pixels)",
+
    `R20` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 20% of total light (pixels)",
−
        `R80` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 80% of total light (pixels)",
+
    `R50` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 50% of total light (pixels)",
−
        `RPET` FLOAT COMMENT "Zest semi-major axis length for Petrosian Radius ellipse (pixels)",
+
    `R80` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 80% of total light (pixels)",
−
        `FLAGRPET` FLOAT COMMENT "Petrosian radius flag: 0 = single Petrosian radius measured, 2 = multiple radii measured (noisy SB profile), 5 = SB profile was corrected for diffuse light contribution from neighboring object(s)",
+
    `RPET` FLOAT COMMENT "Zest semi-major axis length for Petrosian Radius ellipse (pixels)",
−
        `FLUX_GIM2D` FLOAT COMMENT "GIM2D total flux (counts)",
+
    `FLAGRPET` FLOAT COMMENT "Petrosian radius flag: 0 = single Petrosian radius measured, 2 = multiple radii measured (noisy SB profile), 5 = SB profile was corrected for diffuse light contribution from neighboring object(s)",
−
        `LE_FLUX_GIM2D` FLOAT COMMENT "LE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
+
    `FLUX_GIM2D` FLOAT COMMENT "GIM2D total flux (counts)",
−
        `UE_FLUX_GIM2D` FLOAT COMMENT "UE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
+
    `LE_FLUX_GIM2D` FLOAT COMMENT "LE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
−
        `R_GIM2D` FLOAT COMMENT "GIM2D psf-convolved half-light radius of object (arcseconds)",
+
    `UE_FLUX_GIM2D` FLOAT COMMENT "UE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
−
        `LE_R_GIM2D` FLOAT COMMENT "99% conf. lower error on R_GIM2D",
+
    `R_GIM2D` FLOAT COMMENT "GIM2D psf-convolved half-light radius of object (arcseconds)",
−
        `UE_R_GIM2D` FLOAT COMMENT "99% conf. upper error on R_GIM2D",
+
    `LE_R_GIM2D` FLOAT COMMENT "99% conf. lower error on R_GIM2D",
−
        `ELL_GIM2D` FLOAT COMMENT "GIM2D ellipticity = 1-b/a of object",
+
    `UE_R_GIM2D` FLOAT COMMENT "99% conf. upper error on R_GIM2D",
−
        `LE_ELL_GIM2D` FLOAT COMMENT "99% conf. lower error on ELL_GIM2D",
+
    `ELL_GIM2D` FLOAT COMMENT "GIM2D ellipticity = 1-b/a of object",
−
        `UE_ELL_GIM2D` FLOAT COMMENT "99% conf. upper error on ELL_GIM2D",
+
    `LE_ELL_GIM2D` FLOAT COMMENT "99% conf. lower error on ELL_GIM2D",
−
        `PA_GIM2D` FLOAT COMMENT "GIM2D position angle of object - cw from +y-axis (degrees)",
+
    `UE_ELL_GIM2D` FLOAT COMMENT "99% conf. upper error on ELL_GIM2D",
−
        `LE_PA_GIM2D` FLOAT COMMENT "99% conf. lower error on PA_GIM2D",
+
    `PA_GIM2D` FLOAT COMMENT "GIM2D position angle of object - cw from +y-axis (degrees)",
−
        `UE_PA_GIM2D` FLOAT COMMENT "99% conf. upper error on PA_GIM2D",
+
    `LE_PA_GIM2D` FLOAT COMMENT "99% conf. lower error on PA_GIM2D",
−
        `DX_GIM2D` FLOAT COMMENT "x-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
+
    `UE_PA_GIM2D` FLOAT COMMENT "99% conf. upper error on PA_GIM2D",
−
        `LE_DX_GIM2D` FLOAT COMMENT "99% conf. lower error on DX_GIM2D",
+
    `DX_GIM2D` FLOAT COMMENT "x-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
−
        `UE_DX_GIM2D` FLOAT COMMENT "99% conf. upper error on DX_GIM2D",
+
    `LE_DX_GIM2D` FLOAT COMMENT "99% conf. lower error on DX_GIM2D",
−
        `DY_GIM2D` FLOAT COMMENT "y-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
+
    `UE_DX_GIM2D` FLOAT COMMENT "99% conf. upper error on DX_GIM2D",
−
        `LE_DY_GIM2D` FLOAT COMMENT "99% conf. lower error on DY_GIM2D",
+
    `DY_GIM2D` FLOAT COMMENT "y-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
−
        `UE_DY_GIM2D` FLOAT COMMENT "99% conf. upper error on DY_GIM2D",
+
    `LE_DY_GIM2D` FLOAT COMMENT "99% conf. lower error on DY_GIM2D",
−
        `SERSIC_N_GIM2D` FLOAT COMMENT "GIM2D Sersic index",
+
    `UE_DY_GIM2D` FLOAT COMMENT "99% conf. upper error on DY_GIM2D",
−
        `LE_N_GIM2D` FLOAT COMMENT "99% conf. lower error on SERSIC_N_GIM2D",
+
    `SERSIC_N_GIM2D` FLOAT COMMENT "GIM2D Sersic index",
−
        `UE_N_GIM2D` FLOAT COMMENT "99% conf. upper error on SERSIC_N_GIM2D",
+
    `LE_N_GIM2D` FLOAT COMMENT "99% conf. lower error on SERSIC_N_GIM2D",
−
        `R_0P5_GIM2D` FLOAT COMMENT "GIM2D half-light radius of object without PSF convolution (arcseconds)",
+
    `UE_N_GIM2D` FLOAT COMMENT "99% conf. upper error on SERSIC_N_GIM2D",
−
        `CHI_GIM2D` FLOAT COMMENT "reduced CHI2 of the best GIM2D model fit",
+
    `R_0P5_GIM2D` FLOAT COMMENT "GIM2D half-light radius of object without PSF convolution (arcseconds)",
−
        `ITER_GIM2D` FLOAT COMMENT "no. of iterations required for GIM2D fit to converge",
+
    `CHI_GIM2D` FLOAT COMMENT "reduced CHI2 of the best GIM2D model fit",
−
        `PC_1` FLOAT COMMENT "ZEST first principal component",
+
    `ITER_GIM2D` FLOAT COMMENT "no. of iterations required for GIM2D fit to converge",
−
        `PC_2` FLOAT COMMENT "ZEST second principal component",
+
    `PC_1` FLOAT COMMENT "ZEST first principal component",
−
        `PC_3` FLOAT COMMENT "ZEST third principal component",
+
    `PC_2` FLOAT COMMENT "ZEST second principal component",
−
        `TYPE` FLOAT COMMENT "ZEST Type CLASS (1 = Early type, 2 = Disk, 3 = Irregular Galaxy, 9 = no classification)",
+
    `PC_3` FLOAT COMMENT "ZEST third principal component",
−
        `BULG` FLOAT COMMENT "ZEST \"Bulgeness\" CLASS - only for Type 2 (disk) galaxies: 0 = bulge dominated galaxy, 1,2 = INTermediate-bulge galaxies, 3 = pure disk galaxy, 9 = no classification",
+
    `TYPE` FLOAT COMMENT "ZEST Type CLASS (1 = Early type, 2 = Disk, 3 = Irregular Galaxy, 9 = no classification)",
−
        `IRRE` FLOAT COMMENT "ZEST Irregularity CLASS - only for Type 1 (elliptical) galaxies: 0 = regular, 1 = irregular, 9 = no value",
+
    `BULG` FLOAT COMMENT "ZEST \"Bulgeness\" CLASS - only for Type 2 (disk) galaxies: 0 = bulge dominated galaxy, 1,2 = INTermediate-bulge galaxies, 3 = pure disk galaxy, 9 = no classification",
−
        `ELLI` FLOAT COMMENT "ZEST Ellipticity CLASS, 0 = fac-on, 1,2 = increasingly higher elongation, 3 = edge-on, 9 = no classification of elongation",
+
    `IRRE` FLOAT COMMENT "ZEST Irregularity CLASS - only for Type 1 (elliptical) galaxies: 0 = regular, 1 = irregular, 9 = no value",
−
        `STELLARITY` FLOAT COMMENT "Visual Stellarity flag: 0 if ACS_CLASS_STAR<0.6 (object is ASSUMED to be a galaxy, no visual inspection), 0 if ACS_CLASS_STAR>=0.6 AND object visually identified as a galaxy, 1 if ACS_CLASS_STAR>=0.6 AND visually identified as a star, 2 if ACS_CLASS_STAR>=0.8 (object is assumed to be a star and was not visually inspected), 3 if ACS_CLASS_STAR<0.6 but object is visually identified as a star (e.g. saturated star, etc)",
+
    `ELLI` FLOAT COMMENT "ZEST Ellipticity CLASS, 0 = fac-on, 1,2 = increasingly higher elongation, 3 = edge-on, 9 = no classification of elongation",
−
        `JUNKFLAG` FLOAT COMMENT "0 = good object, 1 = spurious",
+
    `STELLARITY` FLOAT COMMENT "Visual Stellarity flag: 0 if ACS_CLASS_STAR<0.6 (object is ASSUMED to be a galaxy, no visual inspection), 0 if ACS_CLASS_STAR>=0.6 AND object visually identified as a galaxy, 1 if ACS_CLASS_STAR>=0.6 AND visually identified as a star, 2 if ACS_CLASS_STAR>=0.8 (object is assumed to be a star and was not visually inspected), 3 if ACS_CLASS_STAR<0.6 but object is visually identified as a star (e.g. saturated star, etc)",
−
        `ACSTile` STRING COMMENT "ACS TILE number from which the object is extracted"
+
    `JUNKFLAG` FLOAT COMMENT "0 = good object, 1 = spurious",
−
    )
+
    `ACSTile` STRING COMMENT "ACS TILE number from which the object is extracted"
−
    ROW FORMAT DELIMITED
+
)
−
    FIELDS TERMINATED BY ','
+
ROW FORMAT DELIMITED
−
    LOCATION '/user/tallada/data/zest'
+
FIELDS TERMINATED BY ','
−
    ;
+
LOCATION '/user/tallada/data/zest'
 +
;
 +
</pre>
  
−
    CREATE TABLE cosmohub.zest (
+
<pre>
−
        `SequentialID` INT COMMENT "Identification number",
+
CREATE TABLE cosmohub.zest (
−
        `RA` FLOAT COMMENT "Right ascension (degrees)",
+
    `SequentialID` INT COMMENT "Identification number",
−
        `DEC` FLOAT COMMENT "Declination (degrees)",
+
    `RA` FLOAT COMMENT "Right ascension (degrees)",
−
        `CAPAK_ID` FLOAT COMMENT "ID based on ground-based photometric catalog of Capak 2006",
+
    `DEC` FLOAT COMMENT "Declination (degrees)",
−
        `CAPAK_RA` FLOAT COMMENT "Closest matched right ascension to ground-based catalog within 0.6\" (degrees)",
+
    `CAPAK_ID` FLOAT COMMENT "ID based on ground-based photometric catalog of Capak 2006",
−
        `CAPAK_DEC` FLOAT COMMENT "Closest matched declination to ground-based catalog within 0.6\" (degrees)",
+
    `CAPAK_RA` FLOAT COMMENT "Closest matched right ascension to ground-based catalog within 0.6\" (degrees)",
−
        `ACS_MAG_AUTO` FLOAT COMMENT "Total magnitude of object- used for catalog selection",
+
    `CAPAK_DEC` FLOAT COMMENT "Closest matched declination to ground-based catalog within 0.6\" (degrees)",
−
        `ACS_MAGERR_AUTO` FLOAT COMMENT "Magnitude error",
+
    `ACS_MAG_AUTO` FLOAT COMMENT "Total magnitude of object- used for catalog selection",
−
        `ACS_X_IMAGE` FLOAT COMMENT "X-pixel position on ACS-tile",
+
    `ACS_MAGERR_AUTO` FLOAT COMMENT "Magnitude error",
−
        `ACS_Y_IMAGE` FLOAT COMMENT "Y-pixel position on ACS-tile",
+
    `ACS_X_IMAGE` FLOAT COMMENT "X-pixel position on ACS-tile",
−
        `ACS_XPEAK_IMAGE` FLOAT COMMENT "X-pixel position of object peak flux on ACS tile",
+
    `ACS_Y_IMAGE` FLOAT COMMENT "Y-pixel position on ACS-tile",
−
        `ACS_YPEAK_IMAGE` FLOAT COMMENT "Y-pixel position of object peak flux on ACS tile",
+
    `ACS_XPEAK_IMAGE` FLOAT COMMENT "X-pixel position of object peak flux on ACS tile",
−
        `ACS_ALPHAPEAK_` FLOAT COMMENT "RA of object peak flux (degrees)",
+
    `ACS_YPEAK_IMAGE` FLOAT COMMENT "Y-pixel position of object peak flux on ACS tile",
−
        `ACS_DELTAPEAK_` FLOAT COMMENT "Dec of object peak flux (degrees)",
+
    `ACS_ALPHAPEAK_` FLOAT COMMENT "RA of object peak flux (degrees)",
−
        `ACS_A_IMAGE` FLOAT COMMENT "SExtractor semi-major axis",
+
    `ACS_DELTAPEAK_` FLOAT COMMENT "Dec of object peak flux (degrees)",
−
        `ACS_B_IMAGE` FLOAT COMMENT "SExtractor semi-minor axis",
+
    `ACS_A_IMAGE` FLOAT COMMENT "SExtractor semi-major axis",
−
        `ACS_THETA_IMAGE` FLOAT COMMENT "SExtractor position angle",
+
    `ACS_B_IMAGE` FLOAT COMMENT "SExtractor semi-minor axis",
−
        `ACS_ELONGATION` FLOAT COMMENT "SExtractor a/b [semi-major axis / semi minor axis]",
+
    `ACS_THETA_IMAGE` FLOAT COMMENT "SExtractor position angle",
−
        `ACS_CLASS_STAR` FLOAT COMMENT "SExtractor stellarity parameter",
+
    `ACS_ELONGATION` FLOAT COMMENT "SExtractor a/b [semi-major axis / semi minor axis]",
−
        `ACS_IDENT` FLOAT COMMENT "Unique number that identifies object",
+
    `ACS_CLASS_STAR` FLOAT COMMENT "SExtractor stellarity parameter",
−
        `ACS_SE` FLOAT COMMENT "0 = Detection from 'cold' pass of Sextractor, 1 = Detection from 'hot' pass of Sextractor",
+
    `ACS_IDENT` FLOAT COMMENT "Unique number that identifies object",
−
        `ACS_MU_CLASS` FLOAT COMMENT "Type of object (1 = galaxy, 2 = star, 3 = spurious)",
+
    `ACS_SE` FLOAT COMMENT "0 = Detection from 'cold' pass of Sextractor, 1 = Detection from 'hot' pass of Sextractor",
−
        `ACS_OVERLAP` FLOAT COMMENT "Object overlap flag. All objects here have overlap =1 i.e. no overlap.",
+
    `ACS_MU_CLASS` FLOAT COMMENT "Type of object (1 = galaxy, 2 = star, 3 = spurious)",
−
        `ACS_NEARSTAR` FLOAT COMMENT "Object in star mask flag. All the objects in this morphological catalog have \"nearstar = 1\" which means they are not in a star mask.",
+
    `ACS_OVERLAP` FLOAT COMMENT "Object overlap flag. All objects here have overlap =1 i.e. no overlap.",
−
        `ACS_MASK` FLOAT COMMENT "Object in automatic mask flag: 2 = star used to make automatic mask",
+
    `ACS_NEARSTAR` FLOAT COMMENT "Object in star mask flag. All the objects in this morphological catalog have \"nearstar = 1\" which means they are not in a star mask.",
−
        `ACS_MASKED` FLOAT COMMENT "Object in manual mask flag: -1 = manual mask (astrophysical obj), 0 = manual mask (artifact or image defect), 1 = not in manual mask",
+
    `ACS_MASK` FLOAT COMMENT "Object in automatic mask flag: 2 = star used to make automatic mask",
−
        `ACS_CLEAN` FLOAT COMMENT "Object useable flag: 0 = do not use this object, 1 = use this object",
+
    `ACS_MASKED` FLOAT COMMENT "Object in manual mask flag: -1 = manual mask (astrophysical obj), 0 = manual mask (artifact or image defect), 1 = not in manual mask",
−
        `ACS_UNIQUE` FLOAT COMMENT "Object unique flag. All the objects in this morphological catalog have \"unique = 1\" which means they are all \"unique\" in the original ACS catalog.",
+
    `ACS_CLEAN` FLOAT COMMENT "Object useable flag: 0 = do not use this object, 1 = use this object",
−
        `GG` FLOAT COMMENT "ZEST Gini coefficient",
+
    `ACS_UNIQUE` FLOAT COMMENT "Object unique flag. All the objects in this morphological catalog have \"unique = 1\" which means they are all \"unique\" in the original ACS catalog.",
−
        `M20` FLOAT COMMENT "ZEST second order moment of the 20% brightest pixels",
+
    `GG` FLOAT COMMENT "ZEST Gini coefficient",
−
        `CC` FLOAT COMMENT "ZEST concentration",
+
    `M20` FLOAT COMMENT "ZEST second order moment of the 20% brightest pixels",
−
        `AA` FLOAT COMMENT "ZEST asymmetry",
+
    `CC` FLOAT COMMENT "ZEST concentration",
−
        `R20` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 20% of total light (pixels)",
+
    `AA` FLOAT COMMENT "ZEST asymmetry",
−
        `R50` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 50% of total light (pixels)",
+
    `R20` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 20% of total light (pixels)",
−
        `R80` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 80% of total light (pixels)",
+
    `R50` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 50% of total light (pixels)",
−
        `RPET` FLOAT COMMENT "Zest semi-major axis length for Petrosian Radius ellipse (pixels)",
+
    `R80` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 80% of total light (pixels)",
−
        `FLAGRPET` FLOAT COMMENT "Petrosian radius flag: 0 = single Petrosian radius measured, 2 = multiple radii measured (noisy SB profile), 5 = SB profile was corrected for diffuse light contribution from neighboring object(s)",
+
    `RPET` FLOAT COMMENT "Zest semi-major axis length for Petrosian Radius ellipse (pixels)",
−
        `FLUX_GIM2D` FLOAT COMMENT "GIM2D total flux (counts)",
+
    `FLAGRPET` FLOAT COMMENT "Petrosian radius flag: 0 = single Petrosian radius measured, 2 = multiple radii measured (noisy SB profile), 5 = SB profile was corrected for diffuse light contribution from neighboring object(s)",
−
        `LE_FLUX_GIM2D` FLOAT COMMENT "LE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
+
    `FLUX_GIM2D` FLOAT COMMENT "GIM2D total flux (counts)",
−
        `UE_FLUX_GIM2D` FLOAT COMMENT "UE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
+
    `LE_FLUX_GIM2D` FLOAT COMMENT "LE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
−
        `R_GIM2D` FLOAT COMMENT "GIM2D psf-convolved half-light radius of object (arcseconds)",
+
    `UE_FLUX_GIM2D` FLOAT COMMENT "UE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
−
        `LE_R_GIM2D` FLOAT COMMENT "99% conf. lower error on R_GIM2D",
+
    `R_GIM2D` FLOAT COMMENT "GIM2D psf-convolved half-light radius of object (arcseconds)",
−
        `UE_R_GIM2D` FLOAT COMMENT "99% conf. upper error on R_GIM2D",
+
    `LE_R_GIM2D` FLOAT COMMENT "99% conf. lower error on R_GIM2D",
−
        `ELL_GIM2D` FLOAT COMMENT "GIM2D ellipticity = 1-b/a of object",
+
    `UE_R_GIM2D` FLOAT COMMENT "99% conf. upper error on R_GIM2D",
−
        `LE_ELL_GIM2D` FLOAT COMMENT "99% conf. lower error on ELL_GIM2D",
+
    `ELL_GIM2D` FLOAT COMMENT "GIM2D ellipticity = 1-b/a of object",
−
        `UE_ELL_GIM2D` FLOAT COMMENT "99% conf. upper error on ELL_GIM2D",
+
    `LE_ELL_GIM2D` FLOAT COMMENT "99% conf. lower error on ELL_GIM2D",
−
        `PA_GIM2D` FLOAT COMMENT "GIM2D position angle of object - cw from +y-axis (degrees)",
+
    `UE_ELL_GIM2D` FLOAT COMMENT "99% conf. upper error on ELL_GIM2D",
−
        `LE_PA_GIM2D` FLOAT COMMENT "99% conf. lower error on PA_GIM2D",
+
    `PA_GIM2D` FLOAT COMMENT "GIM2D position angle of object - cw from +y-axis (degrees)",
−
        `UE_PA_GIM2D` FLOAT COMMENT "99% conf. upper error on PA_GIM2D",
+
    `LE_PA_GIM2D` FLOAT COMMENT "99% conf. lower error on PA_GIM2D",
−
        `DX_GIM2D` FLOAT COMMENT "x-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
+
    `UE_PA_GIM2D` FLOAT COMMENT "99% conf. upper error on PA_GIM2D",
−
        `LE_DX_GIM2D` FLOAT COMMENT "99% conf. lower error on DX_GIM2D",
+
    `DX_GIM2D` FLOAT COMMENT "x-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
−
        `UE_DX_GIM2D` FLOAT COMMENT "99% conf. upper error on DX_GIM2D",
+
    `LE_DX_GIM2D` FLOAT COMMENT "99% conf. lower error on DX_GIM2D",
−
        `DY_GIM2D` FLOAT COMMENT "y-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
+
    `UE_DX_GIM2D` FLOAT COMMENT "99% conf. upper error on DX_GIM2D",
−
        `LE_DY_GIM2D` FLOAT COMMENT "99% conf. lower error on DY_GIM2D",
+
    `DY_GIM2D` FLOAT COMMENT "y-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
−
        `UE_DY_GIM2D` FLOAT COMMENT "99% conf. upper error on DY_GIM2D",
+
    `LE_DY_GIM2D` FLOAT COMMENT "99% conf. lower error on DY_GIM2D",
−
        `SERSIC_N_GIM2D` FLOAT COMMENT "GIM2D Sersic index",
+
    `UE_DY_GIM2D` FLOAT COMMENT "99% conf. upper error on DY_GIM2D",
−
        `LE_N_GIM2D` FLOAT COMMENT "99% conf. lower error on SERSIC_N_GIM2D",
+
    `SERSIC_N_GIM2D` FLOAT COMMENT "GIM2D Sersic index",
−
        `UE_N_GIM2D` FLOAT COMMENT "99% conf. upper error on SERSIC_N_GIM2D",
+
    `LE_N_GIM2D` FLOAT COMMENT "99% conf. lower error on SERSIC_N_GIM2D",
−
        `R_0P5_GIM2D` FLOAT COMMENT "GIM2D half-light radius of object without PSF convolution (arcseconds)",
+
    `UE_N_GIM2D` FLOAT COMMENT "99% conf. upper error on SERSIC_N_GIM2D",
−
        `CHI_GIM2D` FLOAT COMMENT "reduced CHI2 of the best GIM2D model fit",
+
    `R_0P5_GIM2D` FLOAT COMMENT "GIM2D half-light radius of object without PSF convolution (arcseconds)",
−
        `ITER_GIM2D` FLOAT COMMENT "no. of iterations required for GIM2D fit to converge",
+
    `CHI_GIM2D` FLOAT COMMENT "reduced CHI2 of the best GIM2D model fit",
−
        `PC_1` FLOAT COMMENT "ZEST first principal component",
+
    `ITER_GIM2D` FLOAT COMMENT "no. of iterations required for GIM2D fit to converge",
−
        `PC_2` FLOAT COMMENT "ZEST second principal component",
+
    `PC_1` FLOAT COMMENT "ZEST first principal component",
−
        `PC_3` FLOAT COMMENT "ZEST third principal component",
+
    `PC_2` FLOAT COMMENT "ZEST second principal component",
−
        `TYPE` FLOAT COMMENT "ZEST Type CLASS (1 = Early type, 2 = Disk, 3 = Irregular Galaxy, 9 = no classification)",
+
    `PC_3` FLOAT COMMENT "ZEST third principal component",
−
        `BULG` FLOAT COMMENT "ZEST \"Bulgeness\" CLASS - only for Type 2 (disk) galaxies: 0 = bulge dominated galaxy, 1,2 = INTermediate-bulge galaxies, 3 = pure disk galaxy, 9 = no classification",
+
    `TYPE` FLOAT COMMENT "ZEST Type CLASS (1 = Early type, 2 = Disk, 3 = Irregular Galaxy, 9 = no classification)",
−
        `IRRE` FLOAT COMMENT "ZEST Irregularity CLASS - only for Type 1 (elliptical) galaxies: 0 = regular, 1 = irregular, 9 = no value",
+
    `BULG` FLOAT COMMENT "ZEST \"Bulgeness\" CLASS - only for Type 2 (disk) galaxies: 0 = bulge dominated galaxy, 1,2 = INTermediate-bulge galaxies, 3 = pure disk galaxy, 9 = no classification",
−
        `ELLI` FLOAT COMMENT "ZEST Ellipticity CLASS, 0 = fac-on, 1,2 = increasingly higher elongation, 3 = edge-on, 9 = no classification of elongation",
+
    `IRRE` FLOAT COMMENT "ZEST Irregularity CLASS - only for Type 1 (elliptical) galaxies: 0 = regular, 1 = irregular, 9 = no value",
−
        `STELLARITY` FLOAT COMMENT "Visual Stellarity flag: 0 if ACS_CLASS_STAR<0.6 (object is ASSUMED to be a galaxy, no visual inspection), 0 if ACS_CLASS_STAR>=0.6 AND object visually identified as a galaxy, 1 if ACS_CLASS_STAR>=0.6 AND visually identified as a star, 2 if ACS_CLASS_STAR>=0.8 (object is assumed to be a star and was not visually inspected), 3 if ACS_CLASS_STAR<0.6 but object is visually identified as a star (e.g. saturated star, etc)",
+
    `ELLI` FLOAT COMMENT "ZEST Ellipticity CLASS, 0 = fac-on, 1,2 = increasingly higher elongation, 3 = edge-on, 9 = no classification of elongation",
−
        `JUNKFLAG` FLOAT COMMENT "0 = good object, 1 = spurious",
+
    `STELLARITY` FLOAT COMMENT "Visual Stellarity flag: 0 if ACS_CLASS_STAR<0.6 (object is ASSUMED to be a galaxy, no visual inspection), 0 if ACS_CLASS_STAR>=0.6 AND object visually identified as a galaxy, 1 if ACS_CLASS_STAR>=0.6 AND visually identified as a star, 2 if ACS_CLASS_STAR>=0.8 (object is assumed to be a star and was not visually inspected), 3 if ACS_CLASS_STAR<0.6 but object is visually identified as a star (e.g. saturated star, etc)",
−
        `ACSTile` STRING COMMENT "ACS TILE number from which the object is extracted"
+
    `JUNKFLAG` FLOAT COMMENT "0 = good object, 1 = spurious",
−
    )
+
    `ACSTile` STRING COMMENT "ACS TILE number from which the object is extracted"
−
    CLUSTERED BY (`SequentialID`)
+
)
−
    INTO 4 BUCKETS
+
CLUSTERED BY (`SequentialID`)
−
    STORED AS ORC
+
INTO 4 BUCKETS
−
    ;
+
STORED AS ORC
 +
;
 +
</pre>
  
−
    INSERT OVERWRITE TABLE cosmohub.zest
+
<pre>
−
    SELECT * FROM tallada.zest
+
INSERT OVERWRITE TABLE cosmohub.zest
−
    ;
+
SELECT * FROM tallada.zest
 +
;
 +
</pre>

Revision as of 12:24, 18 February 2019

Data

Downloaded on 2019-02-18 from https://irsa.ipac.caltech.edu/data/COSMOS/tables/morphology/cosmos_morph_zurich_1.0.tbl

SQL

CREATE EXTERNAL TABLE tallada.zest (
    `SequentialID` INT COMMENT "Identification number",
    `RA` FLOAT COMMENT "Right ascension (degrees)",
    `DEC` FLOAT COMMENT "Declination (degrees)",
    `CAPAK_ID` FLOAT COMMENT "ID based on ground-based photometric catalog of Capak 2006",
    `CAPAK_RA` FLOAT COMMENT "Closest matched right ascension to ground-based catalog within 0.6\" (degrees)",
    `CAPAK_DEC` FLOAT COMMENT "Closest matched declination to ground-based catalog within 0.6\" (degrees)",
    `ACS_MAG_AUTO` FLOAT COMMENT "Total magnitude of object- used for catalog selection",
    `ACS_MAGERR_AUTO` FLOAT COMMENT "Magnitude error",
    `ACS_X_IMAGE` FLOAT COMMENT "X-pixel position on ACS-tile",
    `ACS_Y_IMAGE` FLOAT COMMENT "Y-pixel position on ACS-tile",
    `ACS_XPEAK_IMAGE` FLOAT COMMENT "X-pixel position of object peak flux on ACS tile",
    `ACS_YPEAK_IMAGE` FLOAT COMMENT "Y-pixel position of object peak flux on ACS tile",
    `ACS_ALPHAPEAK_` FLOAT COMMENT "RA of object peak flux (degrees)",
    `ACS_DELTAPEAK_` FLOAT COMMENT "Dec of object peak flux (degrees)",
    `ACS_A_IMAGE` FLOAT COMMENT "SExtractor semi-major axis",
    `ACS_B_IMAGE` FLOAT COMMENT "SExtractor semi-minor axis",
    `ACS_THETA_IMAGE` FLOAT COMMENT "SExtractor position angle",
    `ACS_ELONGATION` FLOAT COMMENT "SExtractor a/b [semi-major axis / semi minor axis]",
    `ACS_CLASS_STAR` FLOAT COMMENT "SExtractor stellarity parameter",
    `ACS_IDENT` FLOAT COMMENT "Unique number that identifies object",
    `ACS_SE` FLOAT COMMENT "0 = Detection from 'cold' pass of Sextractor, 1 = Detection from 'hot' pass of Sextractor",
    `ACS_MU_CLASS` FLOAT COMMENT "Type of object (1 = galaxy, 2 = star, 3 = spurious)",
    `ACS_OVERLAP` FLOAT COMMENT "Object overlap flag. All objects here have overlap =1 i.e. no overlap.",
    `ACS_NEARSTAR` FLOAT COMMENT "Object in star mask flag. All the objects in this morphological catalog have \"nearstar = 1\" which means they are not in a star mask.",
    `ACS_MASK` FLOAT COMMENT "Object in automatic mask flag: 2 = star used to make automatic mask",
    `ACS_MASKED` FLOAT COMMENT "Object in manual mask flag: -1 = manual mask (astrophysical obj), 0 = manual mask (artifact or image defect), 1 = not in manual mask",
    `ACS_CLEAN` FLOAT COMMENT "Object useable flag: 0 = do not use this object, 1 = use this object",
    `ACS_UNIQUE` FLOAT COMMENT "Object unique flag. All the objects in this morphological catalog have \"unique = 1\" which means they are all \"unique\" in the original ACS catalog.",
    `GG` FLOAT COMMENT "ZEST Gini coefficient",
    `M20` FLOAT COMMENT "ZEST second order moment of the 20% brightest pixels",
    `CC` FLOAT COMMENT "ZEST concentration",
    `AA` FLOAT COMMENT "ZEST asymmetry",
    `R20` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 20% of total light (pixels)",
    `R50` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 50% of total light (pixels)",
    `R80` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 80% of total light (pixels)",
    `RPET` FLOAT COMMENT "Zest semi-major axis length for Petrosian Radius ellipse (pixels)",
    `FLAGRPET` FLOAT COMMENT "Petrosian radius flag: 0 = single Petrosian radius measured, 2 = multiple radii measured (noisy SB profile), 5 = SB profile was corrected for diffuse light contribution from neighboring object(s)",
    `FLUX_GIM2D` FLOAT COMMENT "GIM2D total flux (counts)",
    `LE_FLUX_GIM2D` FLOAT COMMENT "LE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
    `UE_FLUX_GIM2D` FLOAT COMMENT "UE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
    `R_GIM2D` FLOAT COMMENT "GIM2D psf-convolved half-light radius of object (arcseconds)",
    `LE_R_GIM2D` FLOAT COMMENT "99% conf. lower error on R_GIM2D",
    `UE_R_GIM2D` FLOAT COMMENT "99% conf. upper error on R_GIM2D",
    `ELL_GIM2D` FLOAT COMMENT "GIM2D ellipticity = 1-b/a of object",
    `LE_ELL_GIM2D` FLOAT COMMENT "99% conf. lower error on ELL_GIM2D",
    `UE_ELL_GIM2D` FLOAT COMMENT "99% conf. upper error on ELL_GIM2D",
    `PA_GIM2D` FLOAT COMMENT "GIM2D position angle of object - cw from +y-axis (degrees)",
    `LE_PA_GIM2D` FLOAT COMMENT "99% conf. lower error on PA_GIM2D",
    `UE_PA_GIM2D` FLOAT COMMENT "99% conf. upper error on PA_GIM2D",
    `DX_GIM2D` FLOAT COMMENT "x-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
    `LE_DX_GIM2D` FLOAT COMMENT "99% conf. lower error on DX_GIM2D",
    `UE_DX_GIM2D` FLOAT COMMENT "99% conf. upper error on DX_GIM2D",
    `DY_GIM2D` FLOAT COMMENT "y-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
    `LE_DY_GIM2D` FLOAT COMMENT "99% conf. lower error on DY_GIM2D",
    `UE_DY_GIM2D` FLOAT COMMENT "99% conf. upper error on DY_GIM2D",
    `SERSIC_N_GIM2D` FLOAT COMMENT "GIM2D Sersic index",
    `LE_N_GIM2D` FLOAT COMMENT "99% conf. lower error on SERSIC_N_GIM2D",
    `UE_N_GIM2D` FLOAT COMMENT "99% conf. upper error on SERSIC_N_GIM2D",
    `R_0P5_GIM2D` FLOAT COMMENT "GIM2D half-light radius of object without PSF convolution (arcseconds)",
    `CHI_GIM2D` FLOAT COMMENT "reduced CHI2 of the best GIM2D model fit",
    `ITER_GIM2D` FLOAT COMMENT "no. of iterations required for GIM2D fit to converge",
    `PC_1` FLOAT COMMENT "ZEST first principal component",
    `PC_2` FLOAT COMMENT "ZEST second principal component",
    `PC_3` FLOAT COMMENT "ZEST third principal component",
    `TYPE` FLOAT COMMENT "ZEST Type CLASS (1 = Early type, 2 = Disk, 3 = Irregular Galaxy, 9 = no classification)",
    `BULG` FLOAT COMMENT "ZEST \"Bulgeness\" CLASS - only for Type 2 (disk) galaxies: 0 = bulge dominated galaxy, 1,2 = INTermediate-bulge galaxies, 3 = pure disk galaxy, 9 = no classification",
    `IRRE` FLOAT COMMENT "ZEST Irregularity CLASS - only for Type 1 (elliptical) galaxies: 0 = regular, 1 = irregular, 9 = no value",
    `ELLI` FLOAT COMMENT "ZEST Ellipticity CLASS, 0 = fac-on, 1,2 = increasingly higher elongation, 3 = edge-on, 9 = no classification of elongation",
    `STELLARITY` FLOAT COMMENT "Visual Stellarity flag: 0 if ACS_CLASS_STAR<0.6 (object is ASSUMED to be a galaxy, no visual inspection), 0 if ACS_CLASS_STAR>=0.6 AND object visually identified as a galaxy, 1 if ACS_CLASS_STAR>=0.6 AND visually identified as a star, 2 if ACS_CLASS_STAR>=0.8 (object is assumed to be a star and was not visually inspected), 3 if ACS_CLASS_STAR<0.6 but object is visually identified as a star (e.g. saturated star, etc)",
    `JUNKFLAG` FLOAT COMMENT "0 = good object, 1 = spurious",
    `ACSTile` STRING COMMENT "ACS TILE number from which the object is extracted"
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/user/tallada/data/zest'
;

CREATE TABLE cosmohub.zest (
    `SequentialID` INT COMMENT "Identification number",
    `RA` FLOAT COMMENT "Right ascension (degrees)",
    `DEC` FLOAT COMMENT "Declination (degrees)",
    `CAPAK_ID` FLOAT COMMENT "ID based on ground-based photometric catalog of Capak 2006",
    `CAPAK_RA` FLOAT COMMENT "Closest matched right ascension to ground-based catalog within 0.6\" (degrees)",
    `CAPAK_DEC` FLOAT COMMENT "Closest matched declination to ground-based catalog within 0.6\" (degrees)",
    `ACS_MAG_AUTO` FLOAT COMMENT "Total magnitude of object- used for catalog selection",
    `ACS_MAGERR_AUTO` FLOAT COMMENT "Magnitude error",
    `ACS_X_IMAGE` FLOAT COMMENT "X-pixel position on ACS-tile",
    `ACS_Y_IMAGE` FLOAT COMMENT "Y-pixel position on ACS-tile",
    `ACS_XPEAK_IMAGE` FLOAT COMMENT "X-pixel position of object peak flux on ACS tile",
    `ACS_YPEAK_IMAGE` FLOAT COMMENT "Y-pixel position of object peak flux on ACS tile",
    `ACS_ALPHAPEAK_` FLOAT COMMENT "RA of object peak flux (degrees)",
    `ACS_DELTAPEAK_` FLOAT COMMENT "Dec of object peak flux (degrees)",
    `ACS_A_IMAGE` FLOAT COMMENT "SExtractor semi-major axis",
    `ACS_B_IMAGE` FLOAT COMMENT "SExtractor semi-minor axis",
    `ACS_THETA_IMAGE` FLOAT COMMENT "SExtractor position angle",
    `ACS_ELONGATION` FLOAT COMMENT "SExtractor a/b [semi-major axis / semi minor axis]",
    `ACS_CLASS_STAR` FLOAT COMMENT "SExtractor stellarity parameter",
    `ACS_IDENT` FLOAT COMMENT "Unique number that identifies object",
    `ACS_SE` FLOAT COMMENT "0 = Detection from 'cold' pass of Sextractor, 1 = Detection from 'hot' pass of Sextractor",
    `ACS_MU_CLASS` FLOAT COMMENT "Type of object (1 = galaxy, 2 = star, 3 = spurious)",
    `ACS_OVERLAP` FLOAT COMMENT "Object overlap flag. All objects here have overlap =1 i.e. no overlap.",
    `ACS_NEARSTAR` FLOAT COMMENT "Object in star mask flag. All the objects in this morphological catalog have \"nearstar = 1\" which means they are not in a star mask.",
    `ACS_MASK` FLOAT COMMENT "Object in automatic mask flag: 2 = star used to make automatic mask",
    `ACS_MASKED` FLOAT COMMENT "Object in manual mask flag: -1 = manual mask (astrophysical obj), 0 = manual mask (artifact or image defect), 1 = not in manual mask",
    `ACS_CLEAN` FLOAT COMMENT "Object useable flag: 0 = do not use this object, 1 = use this object",
    `ACS_UNIQUE` FLOAT COMMENT "Object unique flag. All the objects in this morphological catalog have \"unique = 1\" which means they are all \"unique\" in the original ACS catalog.",
    `GG` FLOAT COMMENT "ZEST Gini coefficient",
    `M20` FLOAT COMMENT "ZEST second order moment of the 20% brightest pixels",
    `CC` FLOAT COMMENT "ZEST concentration",
    `AA` FLOAT COMMENT "ZEST asymmetry",
    `R20` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 20% of total light (pixels)",
    `R50` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 50% of total light (pixels)",
    `R80` FLOAT COMMENT "ZEST semi-major axis length of ellipse encompassing 80% of total light (pixels)",
    `RPET` FLOAT COMMENT "Zest semi-major axis length for Petrosian Radius ellipse (pixels)",
    `FLAGRPET` FLOAT COMMENT "Petrosian radius flag: 0 = single Petrosian radius measured, 2 = multiple radii measured (noisy SB profile), 5 = SB profile was corrected for diffuse light contribution from neighboring object(s)",
    `FLUX_GIM2D` FLOAT COMMENT "GIM2D total flux (counts)",
    `LE_FLUX_GIM2D` FLOAT COMMENT "LE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
    `UE_FLUX_GIM2D` FLOAT COMMENT "UE_FLUX_GIM2D (99% conf. lower error on R_GIM2D)",
    `R_GIM2D` FLOAT COMMENT "GIM2D psf-convolved half-light radius of object (arcseconds)",
    `LE_R_GIM2D` FLOAT COMMENT "99% conf. lower error on R_GIM2D",
    `UE_R_GIM2D` FLOAT COMMENT "99% conf. upper error on R_GIM2D",
    `ELL_GIM2D` FLOAT COMMENT "GIM2D ellipticity = 1-b/a of object",
    `LE_ELL_GIM2D` FLOAT COMMENT "99% conf. lower error on ELL_GIM2D",
    `UE_ELL_GIM2D` FLOAT COMMENT "99% conf. upper error on ELL_GIM2D",
    `PA_GIM2D` FLOAT COMMENT "GIM2D position angle of object - cw from +y-axis (degrees)",
    `LE_PA_GIM2D` FLOAT COMMENT "99% conf. lower error on PA_GIM2D",
    `UE_PA_GIM2D` FLOAT COMMENT "99% conf. upper error on PA_GIM2D",
    `DX_GIM2D` FLOAT COMMENT "x-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
    `LE_DX_GIM2D` FLOAT COMMENT "99% conf. lower error on DX_GIM2D",
    `UE_DX_GIM2D` FLOAT COMMENT "99% conf. upper error on DX_GIM2D",
    `DY_GIM2D` FLOAT COMMENT "y-offset of GIM2D-model center from ACS-coordinate center (arcseconds)",
    `LE_DY_GIM2D` FLOAT COMMENT "99% conf. lower error on DY_GIM2D",
    `UE_DY_GIM2D` FLOAT COMMENT "99% conf. upper error on DY_GIM2D",
    `SERSIC_N_GIM2D` FLOAT COMMENT "GIM2D Sersic index",
    `LE_N_GIM2D` FLOAT COMMENT "99% conf. lower error on SERSIC_N_GIM2D",
    `UE_N_GIM2D` FLOAT COMMENT "99% conf. upper error on SERSIC_N_GIM2D",
    `R_0P5_GIM2D` FLOAT COMMENT "GIM2D half-light radius of object without PSF convolution (arcseconds)",
    `CHI_GIM2D` FLOAT COMMENT "reduced CHI2 of the best GIM2D model fit",
    `ITER_GIM2D` FLOAT COMMENT "no. of iterations required for GIM2D fit to converge",
    `PC_1` FLOAT COMMENT "ZEST first principal component",
    `PC_2` FLOAT COMMENT "ZEST second principal component",
    `PC_3` FLOAT COMMENT "ZEST third principal component",
    `TYPE` FLOAT COMMENT "ZEST Type CLASS (1 = Early type, 2 = Disk, 3 = Irregular Galaxy, 9 = no classification)",
    `BULG` FLOAT COMMENT "ZEST \"Bulgeness\" CLASS - only for Type 2 (disk) galaxies: 0 = bulge dominated galaxy, 1,2 = INTermediate-bulge galaxies, 3 = pure disk galaxy, 9 = no classification",
    `IRRE` FLOAT COMMENT "ZEST Irregularity CLASS - only for Type 1 (elliptical) galaxies: 0 = regular, 1 = irregular, 9 = no value",
    `ELLI` FLOAT COMMENT "ZEST Ellipticity CLASS, 0 = fac-on, 1,2 = increasingly higher elongation, 3 = edge-on, 9 = no classification of elongation",
    `STELLARITY` FLOAT COMMENT "Visual Stellarity flag: 0 if ACS_CLASS_STAR<0.6 (object is ASSUMED to be a galaxy, no visual inspection), 0 if ACS_CLASS_STAR>=0.6 AND object visually identified as a galaxy, 1 if ACS_CLASS_STAR>=0.6 AND visually identified as a star, 2 if ACS_CLASS_STAR>=0.8 (object is assumed to be a star and was not visually inspected), 3 if ACS_CLASS_STAR<0.6 but object is visually identified as a star (e.g. saturated star, etc)",
    `JUNKFLAG` FLOAT COMMENT "0 = good object, 1 = spurious",
    `ACSTile` STRING COMMENT "ACS TILE number from which the object is extracted"
)
CLUSTERED BY (`SequentialID`)
INTO 4 BUCKETS
STORED AS ORC
;

INSERT OVERWRITE TABLE cosmohub.zest
SELECT * FROM tallada.zest
;
Retrieved from "http://pwiki.pic.es/index.php?title=ZEST_v1.0&oldid=299"