KiDS DR4

From Public PIC Wiki
Jump to navigation Jump to search

Comments

ALTER TABLE kids_dr4 CHANGE id id string COMMENT 'ESO_ID IAU astronomical source designation';
ALTER TABLE kids_dr4 CHANGE theli_name theli_name string COMMENT 'Name of the pointing in AW convention';
ALTER TABLE kids_dr4 CHANGE kids_tile kids_tile string COMMENT 'Name of the pointing in THELI convention';
ALTER TABLE kids_dr4 CHANGE seqnr seqnr int COMMENT 'Running object number within the catalogue';
ALTER TABLE kids_dr4 CHANGE slid slid int COMMENT 'AstroWise Source list ID';
ALTER TABLE kids_dr4 CHANGE sid sid int COMMENT 'AstroWise Source ID within the source list';
ALTER TABLE kids_dr4 CHANGE flux_auto flux_auto float COMMENT 'r-band flux (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_auto fluxerr_auto float COMMENT 'Error on FLUX_AUTO (count)';
ALTER TABLE kids_dr4 CHANGE mag_auto mag_auto float COMMENT 'r-band magnitude (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_auto magerr_auto float COMMENT 'Error on MAG_AUTO (mag)';
ALTER TABLE kids_dr4 CHANGE kron_radius kron_radius float COMMENT 'Scaling radius of the ellipse for magnitude measurements (pix)';
ALTER TABLE kids_dr4 CHANGE backgr backgr float COMMENT 'Background count at centroid position (count)';
ALTER TABLE kids_dr4 CHANGE level level float COMMENT 'Detection threshold above background (count)';
ALTER TABLE kids_dr4 CHANGE mu_threshold mu_threshold float COMMENT 'Detection threshold above background (mag arcsec^-2)';
ALTER TABLE kids_dr4 CHANGE maxval maxval float COMMENT 'Peak flux above background (count)';
ALTER TABLE kids_dr4 CHANGE mu_max mu_max float COMMENT 'Peak surface brightness above background (mag arcsec^-2)';
ALTER TABLE kids_dr4 CHANGE isoarea_world isoarea_world float COMMENT 'Isophotal area above analysis threshold (deg^2)';
ALTER TABLE kids_dr4 CHANGE xpos xpos float COMMENT 'Centroid x position in the THELI image (pix)';
ALTER TABLE kids_dr4 CHANGE ypos ypos float COMMENT 'Centroid y position in the THELI image (pix)';
ALTER TABLE kids_dr4 CHANGE raj2000 raj2000 double COMMENT 'Centroid sky position right ascension (J2000) (deg)';
ALTER TABLE kids_dr4 CHANGE decj2000 decj2000 double COMMENT 'Centroid sky position declination (J2000) (deg)';
ALTER TABLE kids_dr4 CHANGE a_world a_world float COMMENT 'Profile RMS along major axis (deg)';
ALTER TABLE kids_dr4 CHANGE b_world b_world float COMMENT 'Profile RMS along minor axis (deg)';
ALTER TABLE kids_dr4 CHANGE theta_j2000 theta_j2000 float COMMENT 'Position angle (West of North) (deg)';
ALTER TABLE kids_dr4 CHANGE theta_world theta_world float COMMENT 'Position angle (Counterclockwise from world x-axis (deg)';
ALTER TABLE kids_dr4 CHANGE erra_world erra_world float COMMENT 'World RMS position error along major axis (deg)';
ALTER TABLE kids_dr4 CHANGE errb_world errb_world float COMMENT 'World RMS position error along minor axis (deg)';
ALTER TABLE kids_dr4 CHANGE errtheta_j2000 errtheta_j2000 float COMMENT 'Error on THETA_J2000 (deg)';
ALTER TABLE kids_dr4 CHANGE errtheta_world errtheta_world float COMMENT 'Error on THETA_WORLD (deg)';
ALTER TABLE kids_dr4 CHANGE fwhm_image fwhm_image float COMMENT 'FWHM assuming a gaussian object profile (pix)';
ALTER TABLE kids_dr4 CHANGE fwhm_world fwhm_world float COMMENT 'FWHM assuming a gaussian object profile (deg)';
ALTER TABLE kids_dr4 CHANGE flag flag int COMMENT 'SExtractor extraction flags';
ALTER TABLE kids_dr4 CHANGE flux_radius flux_radius float COMMENT 'Half-light radius (pix)';
ALTER TABLE kids_dr4 CHANGE class_star class_star float COMMENT 'Star-galaxy classifier';
ALTER TABLE kids_dr4 CHANGE extinction_u extinction_u float COMMENT 'Galactic extinction in the u band (mag)';
ALTER TABLE kids_dr4 CHANGE extinction_g extinction_g float COMMENT 'Galactic extinction in the g band (mag)';
ALTER TABLE kids_dr4 CHANGE extinction_r extinction_r float COMMENT 'Galactic extinctio in the r band (mag)';
ALTER TABLE kids_dr4 CHANGE extinction_i extinction_i float COMMENT 'Galactic extincion in the i band (mag)';
ALTER TABLE kids_dr4 CHANGE agaper_0p7 agaper_0p7 float COMMENT 'Major axis of GAaP aperture minaper 0.7arcs (arcsec)';
ALTER TABLE kids_dr4 CHANGE bgaper_0p7 bgaper_0p7 float COMMENT 'Minor axis of GAaP aperture minaper 0.7arcs (arcsec)';
ALTER TABLE kids_dr4 CHANGE agaper_1p0 agaper_1p0 float COMMENT 'Major axis of GAaP aperture minaper 1.0arcs (arcsec)';
ALTER TABLE kids_dr4 CHANGE bgaper_1p0 bgaper_1p0 float COMMENT 'Minor axis of GAaP aperture minaper 1.0arcs (arcsec)';
ALTER TABLE kids_dr4 CHANGE pagaap pagaap float COMMENT 'Position angle of major axis of GAaP aperture (North of West) (deg)';
ALTER TABLE kids_dr4 CHANGE flag_gaap_0p7_u flag_gaap_0p7_u int COMMENT 'GAaP Flag for MAG_GAAP_u minaper 0.7arcs';
ALTER TABLE kids_dr4 CHANGE flag_gaap_0p7_g flag_gaap_0p7_g int COMMENT 'GAaP Flag for MAG_GAAP_g minaper 0.7arcs';
ALTER TABLE kids_dr4 CHANGE flag_gaap_0p7_r flag_gaap_0p7_r int COMMENT 'GAaP Flag for MAG_GAAP_r minaper 0.7arcs';
ALTER TABLE kids_dr4 CHANGE flag_gaap_0p7_i flag_gaap_0p7_i int COMMENT 'GAaP Flag for MAG_GAAP_i minaper 0.7arcs';
ALTER TABLE kids_dr4 CHANGE flux_gaap_0p7_u flux_gaap_0p7_u float COMMENT 'GAAP u-band flux minaper 0.7arcs (count)';
ALTER TABLE kids_dr4 CHANGE flux_gaap_0p7_g flux_gaap_0p7_g float COMMENT 'GAAP g-band flux minaper 0.7arcs (count)';
ALTER TABLE kids_dr4 CHANGE flux_gaap_0p7_r flux_gaap_0p7_r float COMMENT 'GAAP r-band flux minaper 0.7arcs (count)';
ALTER TABLE kids_dr4 CHANGE flux_gaap_0p7_i flux_gaap_0p7_i float COMMENT 'GAAP i-band flux minaper 0.7arcs (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_0p7_u fluxerr_gaap_0p7_u float COMMENT 'Error on FLUX_GAAP_u minaper 0.7arcs (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_0p7_g fluxerr_gaap_0p7_g float COMMENT 'Error on FLUX_GAAP_g minaper 0.7arcs (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_0p7_r fluxerr_gaap_0p7_r float COMMENT 'Error on FLUX_GAAP_r minaper 0.7arcs (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_0p7_i fluxerr_gaap_0p7_i float COMMENT 'Error on FLUX_GAAP_i minaper 0.7arcs (count)';
ALTER TABLE kids_dr4 CHANGE flag_gaap_1p0_u flag_gaap_1p0_u int COMMENT 'GAaP Flag for MAG_GAAP_u minaper 1.0arcs';
ALTER TABLE kids_dr4 CHANGE flag_gaap_1p0_g flag_gaap_1p0_g int COMMENT 'GAaP Flag for MAG_GAAP_g minaper 1.0arcs';
ALTER TABLE kids_dr4 CHANGE flag_gaap_1p0_r flag_gaap_1p0_r int COMMENT 'GAaP Flag for MAG_GAAP_r minaper 1.0arcs';
ALTER TABLE kids_dr4 CHANGE flag_gaap_1p0_i flag_gaap_1p0_i int COMMENT 'GAaP Flag for MAG_GAAP_i minaper 1.0arcs';
ALTER TABLE kids_dr4 CHANGE flux_gaap_1p0_u flux_gaap_1p0_u float COMMENT 'GAAP u-band flux minaper 1.0arcs (count)';
ALTER TABLE kids_dr4 CHANGE flux_gaap_1p0_g flux_gaap_1p0_g float COMMENT 'GAAP g-band flux minaper 1.0arcs (count)';
ALTER TABLE kids_dr4 CHANGE flux_gaap_1p0_r flux_gaap_1p0_r float COMMENT 'GAAP r-band flux minaper 1.0arcs (count)';
ALTER TABLE kids_dr4 CHANGE flux_gaap_1p0_i flux_gaap_1p0_i float COMMENT 'GAAP i-band flux minaper 1.0arcs (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_1p0_u fluxerr_gaap_1p0_u float COMMENT 'Error on FLUX_GAAP_u minaper 1.0arcs (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_1p0_g fluxerr_gaap_1p0_g float COMMENT 'Error on FLUX_GAAP_g minaper 1.0arcs (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_1p0_r fluxerr_gaap_1p0_r float COMMENT 'Error on FLUX_GAAP_r minaper 1.0arcs (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_1p0_i fluxerr_gaap_1p0_i float COMMENT 'Error on FLUX_GAAP_i minaper 1.0arcs (count)';
ALTER TABLE kids_dr4 CHANGE mag_iso mag_iso float COMMENT 'r-band Isophotal Magnitude (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_iso magerr_iso float COMMENT 'Error on MAG_ISO (mag)';
ALTER TABLE kids_dr4 CHANGE flux_iso flux_iso float COMMENT 'r-band Isophotal Flux (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_iso fluxerr_iso float COMMENT 'Error on FLUX_ISO (count)';
ALTER TABLE kids_dr4 CHANGE mag_isocor mag_isocor float COMMENT 'r-band Corrected Isophotal Magnitude (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_isocor magerr_isocor float COMMENT 'Error on MAG_ISOCOR (mag)';
ALTER TABLE kids_dr4 CHANGE flux_isocor flux_isocor float COMMENT 'r-band Corrected Isophotal Flux (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_isocor fluxerr_isocor float COMMENT 'Error on FLUX_ISOCOR (count)';
ALTER TABLE kids_dr4 CHANGE nimaflags_iso nimaflags_iso int COMMENT 'Number of flagged pixels over the isophotal profile';
ALTER TABLE kids_dr4 CHANGE imaflags_iso imaflags_iso int COMMENT 'FLAG-image flags ORed over the isophotal profile';
ALTER TABLE kids_dr4 CHANGE xmin_image xmin_image int COMMENT 'Minimum x-coordinate among detected pixels (pixel)';
ALTER TABLE kids_dr4 CHANGE ymin_image ymin_image int COMMENT 'Minimum y-coordinate among detected pixels (pixel)';
ALTER TABLE kids_dr4 CHANGE xmax_image xmax_image int COMMENT 'Maximum x-coordinate among detected pixels (pixel)';
ALTER TABLE kids_dr4 CHANGE ymax_image ymax_image int COMMENT 'Maximum x-coordinate among detected pixels (pixel)';
ALTER TABLE kids_dr4 CHANGE x_world x_world double COMMENT 'Barycentre position along world x axis (deg)';
ALTER TABLE kids_dr4 CHANGE y_world y_world double COMMENT 'Barycentre position along world y axis (deg)';
ALTER TABLE kids_dr4 CHANGE x2_world x2_world float COMMENT 'Variance of position along X_WORLD (alpha) (deg^2)';
ALTER TABLE kids_dr4 CHANGE y2_world y2_world float COMMENT 'Variance of position along X_WORLD (delta) (deg^2)';
ALTER TABLE kids_dr4 CHANGE xy_world xy_world float COMMENT 'Covariance of position X_WORLD/Y_WORLD (deg^2)';
ALTER TABLE kids_dr4 CHANGE errx2_world errx2_world float COMMENT 'Error on XY_WORLD (deg^2)';
ALTER TABLE kids_dr4 CHANGE erry2_world erry2_world float COMMENT 'Error on XY_WORLD (deg^2)';
ALTER TABLE kids_dr4 CHANGE errxy_world errxy_world float COMMENT 'Error on XY_WORLD (deg^2)';
ALTER TABLE kids_dr4 CHANGE cxx_world cxx_world float COMMENT 'SExtractor Cxx object ellipse parameter (deg^-2)';
ALTER TABLE kids_dr4 CHANGE cyy_world cyy_world float COMMENT 'SExtractor Cyy object ellipse parameter (deg^-2)';
ALTER TABLE kids_dr4 CHANGE cxy_world cxy_world float COMMENT 'SExtractor Cxy object ellipse parameter (deg^-2)';
ALTER TABLE kids_dr4 CHANGE errcxx_world errcxx_world float COMMENT 'Error on CXX_WORLD (deg^-2)';
ALTER TABLE kids_dr4 CHANGE errcyy_world errcyy_world float COMMENT 'Error on CYY_WORLD (deg^-2)';
ALTER TABLE kids_dr4 CHANGE errcxy_world errcxy_world float COMMENT 'Error on CXY_WORLD (deg^-2)';
ALTER TABLE kids_dr4 CHANGE a_image a_image double COMMENT 'Profile RMS along x-axis (pix)';
ALTER TABLE kids_dr4 CHANGE b_image b_image double COMMENT 'Profile RMS along y-axis (pix)';
ALTER TABLE kids_dr4 CHANGE erra_image erra_image float COMMENT 'Error on A_IMAGE (pix)';
ALTER TABLE kids_dr4 CHANGE errb_image errb_image float COMMENT 'Error on B_IMAGE (pix)';
ALTER TABLE kids_dr4 CHANGE s_ellipticity s_ellipticity float COMMENT 'SExtractor Ellipticity (1-B_IMAGE/A_IMAGE)';
ALTER TABLE kids_dr4 CHANGE s_elongation s_elongation float COMMENT 'SExtractor Elongation (A_IMAGE/B_IMAGE)';
ALTER TABLE kids_dr4 CHANGE mag_aper_4 mag_aper_4 float COMMENT 'r-band Magnitude within a circular aperture of 4 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_aper_4 magerr_aper_4 float COMMENT 'Error on MAG_APER_4 (mag)';
ALTER TABLE kids_dr4 CHANGE flux_aper_4 flux_aper_4 float COMMENT 'r-band Flux within a circular aperture of 4 pixels (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_4 fluxerr_aper_4 float COMMENT 'Error on FLUX_APER_4 (count)';
ALTER TABLE kids_dr4 CHANGE mag_aper_6 mag_aper_6 float COMMENT 'r-band Magnitude within a circular aperture of 6 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_aper_6 magerr_aper_6 float COMMENT 'Error on MAG_APER_6 (mag)';
ALTER TABLE kids_dr4 CHANGE flux_aper_6 flux_aper_6 float COMMENT 'r-band Flux within a circular aperture of 6 pixels (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_6 fluxerr_aper_6 float COMMENT 'Error on FLUX_APER_6 (count)';
ALTER TABLE kids_dr4 CHANGE mag_aper_8 mag_aper_8 float COMMENT 'r-band Magnitude within a circular aperture of 8 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_aper_8 magerr_aper_8 float COMMENT 'Error on MAG_APER_8 (mag)';
ALTER TABLE kids_dr4 CHANGE flux_aper_8 flux_aper_8 float COMMENT 'r-band Flux within a circular aperture of 8 pixels (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_8 fluxerr_aper_8 float COMMENT 'Error on FLUX_APER_8 (count)';
ALTER TABLE kids_dr4 CHANGE mag_aper_10 mag_aper_10 float COMMENT 'r-band Magnitude within a circular aperture of 10 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_aper_10 magerr_aper_10 float COMMENT 'Error on MAG_APER_10 (mag)';
ALTER TABLE kids_dr4 CHANGE flux_aper_10 flux_aper_10 float COMMENT 'r-band Flux within a circular aperture of 10 pixels (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_10 fluxerr_aper_10 float COMMENT 'Error on FLUX_APER_10 (count)';
ALTER TABLE kids_dr4 CHANGE mag_aper_14 mag_aper_14 float COMMENT 'r-band Magnitude within a circular aperture of 14 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_aper_14 magerr_aper_14 float COMMENT 'Error on MAG_APER_14 (mag)';
ALTER TABLE kids_dr4 CHANGE flux_aper_14 flux_aper_14 float COMMENT 'r-band Flux within a circular aperture of 14 pixels (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_14 fluxerr_aper_14 float COMMENT 'Error on FLUX_APER_14 (count)';
ALTER TABLE kids_dr4 CHANGE mag_aper_20 mag_aper_20 float COMMENT 'r-band Magnitude within a circular aperture of 20 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_aper_20 magerr_aper_20 float COMMENT 'Error on MAG_APER_20 (mag)';
ALTER TABLE kids_dr4 CHANGE flux_aper_20 flux_aper_20 float COMMENT 'r-band Flux within a circular aperture of 20 pixels (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_20 fluxerr_aper_20 float COMMENT 'Error on FLUX_APER_20 (count)';
ALTER TABLE kids_dr4 CHANGE mag_aper_30 mag_aper_30 float COMMENT 'r-band Magnitude within a circular aperture of 30 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE maggerr_aper_30 maggerr_aper_30 float COMMENT 'Error on MAG_APER_30 (mag)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_30 fluxerr_aper_30 float COMMENT 'r-band Flux within a circular aperture of 30 pixels (count)';
ALTER TABLE kids_dr4 CHANGE flux_aper_30 flux_aper_30 float COMMENT 'Error on FLUX_APER_30 (count)';
ALTER TABLE kids_dr4 CHANGE mag_aper_40 mag_aper_40 float COMMENT 'r-band Magnitude within a circular aperture of 40 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_aper_40 magerr_aper_40 float COMMENT 'Error on MAG_APER_40 (mag)';
ALTER TABLE kids_dr4 CHANGE flux_aper_40 flux_aper_40 float COMMENT 'r-band Flux within a circular aperture of 40 pixels (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_40 fluxerr_aper_40 float COMMENT 'Error on FLUX_APER_40 (count)';
ALTER TABLE kids_dr4 CHANGE mag_aper_60 mag_aper_60 float COMMENT 'r-band Magnitude within a circular aperture of 60 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_aper_60 magerr_aper_60 float COMMENT 'Error on MAG_APER_60 (mag)';
ALTER TABLE kids_dr4 CHANGE flux_aper_60 flux_aper_60 float COMMENT 'r-band Flux within a circular aperture of 60 pixels (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_60 fluxerr_aper_60 float COMMENT 'Error on FLUX_APER_60 (count)';
ALTER TABLE kids_dr4 CHANGE mag_aper_100 mag_aper_100 float COMMENT 'r-band Magnitude within a circular aperture of 100 pixels (mag)';
ALTER TABLE kids_dr4 CHANGE magerr_aper_100 magerr_aper_100 float COMMENT 'Error on MAG_APER_100 (mag)';
ALTER TABLE kids_dr4 CHANGE flux_aper_100 flux_aper_100 float COMMENT 'r-band Flux within a circular aperture of 100 pixels (count)';
ALTER TABLE kids_dr4 CHANGE fluxerr_aper_100 fluxerr_aper_100 float COMMENT 'Error on FLUX_APER_100 (count)';
ALTER TABLE kids_dr4 CHANGE iso0 iso0 int COMMENT 'Isophotal area at level 0 (pixel^2)';
ALTER TABLE kids_dr4 CHANGE iso1 iso1 int COMMENT 'Isophotal area at level 1 (pixel^2)';
ALTER TABLE kids_dr4 CHANGE iso2 iso2 int COMMENT 'Isophotal area at level 2 (pixel^2)';
ALTER TABLE kids_dr4 CHANGE iso3 iso3 int COMMENT 'Isophotal area at level 3 (pixel^2)';
ALTER TABLE kids_dr4 CHANGE iso4 iso4 int COMMENT 'Isophotal area at level 4 (pixel^2)';
ALTER TABLE kids_dr4 CHANGE iso5 iso5 int COMMENT 'Isophotal area at level 5 (pixel^2)';
ALTER TABLE kids_dr4 CHANGE iso6 iso6 int COMMENT 'Isophotal area at level 6 (pixel^2)';
ALTER TABLE kids_dr4 CHANGE iso7 iso7 int COMMENT 'Isophotal area at level 7 (pixel^2)';
ALTER TABLE kids_dr4 CHANGE alpha_j2000 alpha_j2000 double COMMENT 'SExtractor named Centroid sky position right ascension (J2000) (deg)';
ALTER TABLE kids_dr4 CHANGE delta_j2000 delta_j2000 double COMMENT 'SEXtractor named Centroid sky position declination (J2000) (deg)';
ALTER TABLE kids_dr4 CHANGE sg2dphot sg2dphot int COMMENT '2DPhot Star/Galaxy classifier (1 for high confidence star)';
ALTER TABLE kids_dr4 CHANGE htm htm int COMMENT 'Hierarchical Triangular Mesh (level 25)';
ALTER TABLE kids_dr4 CHANGE field_pos field_pos int COMMENT 'Reference number to field parameters';
ALTER TABLE kids_dr4 CHANGE mag_gaap_0p7_z mag_gaap_0p7_z float COMMENT 'Z magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_0p7_z magerr_gaap_0p7_z float COMMENT 'Z magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_0p7_z flux_gaap_0p7_z float COMMENT 'Z flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_0p7_z fluxerr_gaap_0p7_z float COMMENT 'Z flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_0p7_z flag_gaap_0p7_z int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE mag_gaap_1p0_z mag_gaap_1p0_z float COMMENT 'Z magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_1p0_z magerr_gaap_1p0_z float COMMENT 'Z magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_1p0_z flux_gaap_1p0_z float COMMENT 'Z flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_1p0_z fluxerr_gaap_1p0_z float COMMENT 'Z flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_1p0_z flag_gaap_1p0_z int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE mag_gaap_0p7_y mag_gaap_0p7_y float COMMENT 'Y magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_0p7_y magerr_gaap_0p7_y float COMMENT 'Y magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_0p7_y flux_gaap_0p7_y float COMMENT 'Y flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_0p7_y fluxerr_gaap_0p7_y float COMMENT 'Y flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_0p7_y flag_gaap_0p7_y int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE mag_gaap_1p0_y mag_gaap_1p0_y float COMMENT 'Y magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_1p0_y magerr_gaap_1p0_y float COMMENT 'Y magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_1p0_y flux_gaap_1p0_y float COMMENT 'Y flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_1p0_y fluxerr_gaap_1p0_y float COMMENT 'Y flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_1p0_y flag_gaap_1p0_y int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE mag_gaap_0p7_j mag_gaap_0p7_j float COMMENT 'J magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_0p7_j magerr_gaap_0p7_j float COMMENT 'J magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_0p7_j flux_gaap_0p7_j float COMMENT 'J flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_0p7_j fluxerr_gaap_0p7_j float COMMENT 'J flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_0p7_j flag_gaap_0p7_j int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE mag_gaap_1p0_j mag_gaap_1p0_j float COMMENT 'J magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_1p0_j magerr_gaap_1p0_j float COMMENT 'J magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_1p0_j flux_gaap_1p0_j float COMMENT 'J flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_1p0_j fluxerr_gaap_1p0_j float COMMENT 'J flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_1p0_j flag_gaap_1p0_j int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE mag_gaap_0p7_h mag_gaap_0p7_h float COMMENT 'H magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_0p7_h magerr_gaap_0p7_h float COMMENT 'H magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_0p7_h flux_gaap_0p7_h float COMMENT 'H flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_0p7_h fluxerr_gaap_0p7_h float COMMENT 'H flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_0p7_h flag_gaap_0p7_h int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE mag_gaap_1p0_h mag_gaap_1p0_h float COMMENT 'H magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_1p0_h magerr_gaap_1p0_h float COMMENT 'H magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_1p0_h flux_gaap_1p0_h float COMMENT 'H flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_1p0_h fluxerr_gaap_1p0_h float COMMENT 'H flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_1p0_h flag_gaap_1p0_h int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE mag_gaap_0p7_ks mag_gaap_0p7_ks float COMMENT 'Ks magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_0p7_ks magerr_gaap_0p7_ks float COMMENT 'Ks magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_0p7_ks flux_gaap_0p7_ks float COMMENT 'Ks flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_0p7_ks fluxerr_gaap_0p7_ks float COMMENT 'Ks flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_0p7_ks flag_gaap_0p7_ks int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE mag_gaap_1p0_ks mag_gaap_1p0_ks float COMMENT 'Ks magnitude';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_1p0_ks magerr_gaap_1p0_ks float COMMENT 'Ks magnitude error';
ALTER TABLE kids_dr4 CHANGE flux_gaap_1p0_ks flux_gaap_1p0_ks float COMMENT 'Ks flux';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_1p0_ks fluxerr_gaap_1p0_ks float COMMENT 'Ks flux error';
ALTER TABLE kids_dr4 CHANGE flag_gaap_1p0_ks flag_gaap_1p0_ks int COMMENT 'GAAP photometry Flag';
ALTER TABLE kids_dr4 CHANGE extinction_z extinction_z float COMMENT 'Galactic extinction in the Z band (mag)';
ALTER TABLE kids_dr4 CHANGE extinction_y extinction_y float COMMENT 'Galactic extinction in the Y band (mag)';
ALTER TABLE kids_dr4 CHANGE extinction_j extinction_j float COMMENT 'Galactic extinction in the J band (mag)';
ALTER TABLE kids_dr4 CHANGE extinction_h extinction_h float COMMENT 'Galactic extinction in the H band (mag)';
ALTER TABLE kids_dr4 CHANGE extinction_ks extinction_ks float COMMENT 'Galactic extinction in the Ks band (mag)';
ALTER TABLE kids_dr4 CHANGE mag_gaap_0p7_u mag_gaap_0p7_u float COMMENT 'u-band GAaP magnitude min_aper=0.7arcsec';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_0p7_u magerr_gaap_0p7_u float COMMENT 'u-band GAaP magnitude error min_aper=0.7arcsec';
ALTER TABLE kids_dr4 CHANGE mag_gaap_0p7_g mag_gaap_0p7_g float COMMENT 'g-band GAaP magnitude min_aper=0.7arcsec';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_0p7_g magerr_gaap_0p7_g float COMMENT 'g-band GAaP magnitude error min_aper=0.7arcsec';
ALTER TABLE kids_dr4 CHANGE mag_gaap_0p7_r mag_gaap_0p7_r float COMMENT 'r-band GAaP magnitude min_aper=0.7arcsec';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_0p7_r magerr_gaap_0p7_r float COMMENT 'r-band GAaP magnitude error min_aper=0.7arcsec';
ALTER TABLE kids_dr4 CHANGE mag_gaap_0p7_i mag_gaap_0p7_i float COMMENT 'i-band GAaP magnitude min_aper=0.7arcsec';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_0p7_i magerr_gaap_0p7_i float COMMENT 'i-band GAaP magnitude error min_aper=0.7arcsec';
ALTER TABLE kids_dr4 CHANGE mag_gaap_1p0_u mag_gaap_1p0_u float COMMENT 'u-band GAaP magnitude min_aper=1.0arcsec';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_1p0_u magerr_gaap_1p0_u float COMMENT 'u-band GAaP magnitude error min_aper=1.0arcsec';
ALTER TABLE kids_dr4 CHANGE mag_gaap_1p0_g mag_gaap_1p0_g float COMMENT 'g-band GAaP magnitude min_aper=1.0arcsec';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_1p0_g magerr_gaap_1p0_g float COMMENT 'g-band GAaP magnitude error min_aper=1.0arcsec';
ALTER TABLE kids_dr4 CHANGE mag_gaap_1p0_r mag_gaap_1p0_r float COMMENT 'r-band GAaP magnitude min_aper=1.0arcsec';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_1p0_r magerr_gaap_1p0_r float COMMENT 'r-band GAaP magnitude error min_aper=1.0arcsec';
ALTER TABLE kids_dr4 CHANGE mag_gaap_1p0_i mag_gaap_1p0_i float COMMENT 'i-band GAaP magnitude min_aper=1.0arcsec';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_1p0_i magerr_gaap_1p0_i float COMMENT 'i-band GAaP magnitude error min_aper=1.0arcsec';
ALTER TABLE kids_dr4 CHANGE mag_gaap_u mag_gaap_u float COMMENT 'u-band GAaP magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_u magerr_gaap_u float COMMENT 'u-band GAaP magnitude error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flux_gaap_u flux_gaap_u float COMMENT 'u-band GAaP flux optimal min_aper';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_u fluxerr_gaap_u float COMMENT 'u-band GAaP flux error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flag_gaap_u flag_gaap_u int COMMENT 'GAaP Flag for MAG_GAAP_u optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_gaap_g mag_gaap_g float COMMENT 'g-band GAaP magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_g magerr_gaap_g float COMMENT 'g-band GAaP magnitude error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flux_gaap_g flux_gaap_g float COMMENT 'g-band GAaP flux optimal min_aper';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_g fluxerr_gaap_g float COMMENT 'g-band GAaP flux error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flag_gaap_g flag_gaap_g int COMMENT 'GAaP Flag for MAG_GAAP_g optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_gaap_r mag_gaap_r float COMMENT 'r-band GAaP magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_r magerr_gaap_r float COMMENT 'r-band GAaP magnitude error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flux_gaap_r flux_gaap_r float COMMENT 'r-band GAaP flux optimal min_aper';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_r fluxerr_gaap_r float COMMENT 'r-band GAaP flux error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flag_gaap_r flag_gaap_r int COMMENT 'GAaP Flag for MAG_GAAP_r optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_gaap_i mag_gaap_i float COMMENT 'i-band GAaP magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_i magerr_gaap_i float COMMENT 'i-band GAaP magnitude error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flux_gaap_i flux_gaap_i float COMMENT 'i-band GAaP flux optimal min_aper';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_i fluxerr_gaap_i float COMMENT 'i-band GAaP flux error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flag_gaap_i flag_gaap_i int COMMENT 'GAaP Flag for MAG_GAAP_i optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_gaap_z mag_gaap_z float COMMENT 'Z-band GAaP magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_z magerr_gaap_z float COMMENT 'Z-band GAaP magnitude error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flux_gaap_z flux_gaap_z float COMMENT 'Z-band GAaP flux optimal min_aper';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_z fluxerr_gaap_z float COMMENT 'Z-band GAaP flux error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flag_gaap_z flag_gaap_z int COMMENT 'GAaP Flag for MAG_GAAP_Z optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_gaap_y mag_gaap_y float COMMENT 'Y-band GAaP magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_y magerr_gaap_y float COMMENT 'Y-band GAaP magnitude error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flux_gaap_y flux_gaap_y float COMMENT 'Y-band GAaP flux optimal min_aper';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_y fluxerr_gaap_y float COMMENT 'Y-band GAaP flux error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flag_gaap_y flag_gaap_y int COMMENT 'GAaP Flag for MAG_GAAP_Y optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_gaap_j mag_gaap_j float COMMENT 'J-band GAaP magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_j magerr_gaap_j float COMMENT 'J-band GAaP magnitude error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flux_gaap_j flux_gaap_j float COMMENT 'J-band GAaP flux optimal min_aper';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_j fluxerr_gaap_j float COMMENT 'J-band GAaP flux error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flag_gaap_j flag_gaap_j int COMMENT 'GAaP Flag for MAG_GAAP_J optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_gaap_h mag_gaap_h float COMMENT 'H-band GAaP magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_h magerr_gaap_h float COMMENT 'H-band GAaP magnitude error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flux_gaap_h flux_gaap_h float COMMENT 'H-band GAaP flux optimal min_aper';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_h fluxerr_gaap_h float COMMENT 'H-band GAaP flux error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flag_gaap_h flag_gaap_h int COMMENT 'GAaP Flag for MAG_GAAP_H optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_gaap_ks mag_gaap_ks float COMMENT 'Ks-band GAaP magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE magerr_gaap_ks magerr_gaap_ks float COMMENT 'Ks-band GAaP magnitude error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flux_gaap_ks flux_gaap_ks float COMMENT 'Ks-band GAaP flux optimal min_aper';
ALTER TABLE kids_dr4 CHANGE fluxerr_gaap_ks fluxerr_gaap_ks float COMMENT 'Ks-band GAaP flux error optimal min_aper';
ALTER TABLE kids_dr4 CHANGE flag_gaap_ks flag_gaap_ks int COMMENT 'GAaP Flag for MAG_GAAP_Ks optimal min_aper';
ALTER TABLE kids_dr4 CHANGE agaper agaper float COMMENT 'Major axis of GAaP aperture optimal min_aper (arcsec)';
ALTER TABLE kids_dr4 CHANGE bgaper bgaper float COMMENT 'Minor axis of GAaP aperture optimal min_aper (arcsec)';
ALTER TABLE kids_dr4 CHANGE mag_lim_u mag_lim_u float COMMENT 'u-band limiting magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_lim_g mag_lim_g float COMMENT 'g-band limiting magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_lim_r mag_lim_r float COMMENT 'r-band limiting magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_lim_i mag_lim_i float COMMENT 'i-band limiting magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_lim_z mag_lim_z float COMMENT 'Z-band limiting magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_lim_y mag_lim_y float COMMENT 'Y-band limiting magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_lim_j mag_lim_j float COMMENT 'J-band limiting magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_lim_h mag_lim_h float COMMENT 'H-band limiting magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE mag_lim_ks mag_lim_ks float COMMENT 'Ks-band limiting magnitude optimal min_aper';
ALTER TABLE kids_dr4 CHANGE z_b z_b double COMMENT '9-band BPZ redshift estimate; peak of posterior probability distribu';
ALTER TABLE kids_dr4 CHANGE z_b_min z_b_min double COMMENT 'Lower bound of the 68% confidence interval of Z_B';
ALTER TABLE kids_dr4 CHANGE z_b_max z_b_max double COMMENT 'Upper bound of the 68% confidence interval of Z_B';
ALTER TABLE kids_dr4 CHANGE t_b t_b double COMMENT 'Spectral type corresponding to Z_B';
ALTER TABLE kids_dr4 CHANGE odds odds double COMMENT 'Empirical ODDS of Z_B';
ALTER TABLE kids_dr4 CHANGE z_ml z_ml double COMMENT '9-band BPZ maximum likelihood redshift';
ALTER TABLE kids_dr4 CHANGE t_ml t_ml double COMMENT 'Spectral type corresponding to Z_ML';
ALTER TABLE kids_dr4 CHANGE chi_squared_bpz chi_squared_bpz double COMMENT 'chi sqared value associated with Z_B';
ALTER TABLE kids_dr4 CHANGE m_0 m_0 double COMMENT 'Reference magnitude for BPZ prior';
ALTER TABLE kids_dr4 CHANGE bpz_filt bpz_filt int COMMENT 'filters with good photometry (BPZ)';
ALTER TABLE kids_dr4 CHANGE nbpz_filt nbpz_filt int COMMENT 'number of filters with good phot. (BPZ)';
ALTER TABLE kids_dr4 CHANGE bpz_nondetfilt bpz_nondetfilt int COMMENT 'filters with faint photometry (BPZ)';
ALTER TABLE kids_dr4 CHANGE nbpz_nondetfilt nbpz_nondetfilt int COMMENT 'number of filters with faint phot. (BPZ)';
ALTER TABLE kids_dr4 CHANGE bpz_flagfilt bpz_flagfilt int COMMENT 'flagged filters (BPZ)';
ALTER TABLE kids_dr4 CHANGE nbpz_flagfilt nbpz_flagfilt int COMMENT 'number of flagged filters (BPZ)';
ALTER TABLE kids_dr4 CHANGE sg_flag sg_flag float COMMENT 'Star/Gal Classifier';
ALTER TABLE kids_dr4 CHANGE mask mask int COMMENT '9-band mask information';
ALTER TABLE kids_dr4 CHANGE colour_gaap_u_g colour_gaap_u_g float COMMENT 'u-g colour index';
ALTER TABLE kids_dr4 CHANGE colour_gaap_g_r colour_gaap_g_r float COMMENT 'g-r colour index';
ALTER TABLE kids_dr4 CHANGE colour_gaap_r_i colour_gaap_r_i float COMMENT 'r-i colour index';
ALTER TABLE kids_dr4 CHANGE colour_gaap_i_z colour_gaap_i_z float COMMENT 'i-Z colour index';
ALTER TABLE kids_dr4 CHANGE colour_gaap_z_y colour_gaap_z_y float COMMENT 'Z-Y colour index';
ALTER TABLE kids_dr4 CHANGE colour_gaap_y_j colour_gaap_y_j float COMMENT 'Y-J colour index';
ALTER TABLE kids_dr4 CHANGE colour_gaap_j_h colour_gaap_j_h float COMMENT 'J-H colour index';
ALTER TABLE kids_dr4 CHANGE colour_gaap_h_ks colour_gaap_h_ks float COMMENT 'H-Ks colour index';