Tallada at 21:04, 30 November 2020

2020-11-30T21:04:59Z

Show changes

Tallada: /* Comments */

2020-11-30T21:04:31Z

Comments

Show changes

Tallada: /* Internal Table */

2020-11-28T02:11:58Z

Internal Table

Tallada: /* Internal Table */

2020-11-27T00:24:29Z

Internal Table

Show changes

Tallada at 00:51, 26 November 2020

2020-11-26T00:51:35Z

Show changes

Tallada: Created page with "== Original DR9 == === Raw data === Downloaded from NERSC /global/cfs/cdirs/cosmo/work/legacysurvey/dr9m Directories: south/tractor north/tractor Downloaded using bbcp f..."

2020-11-23T21:47:46Z

Created page with "== Original DR9 == === Raw data === Downloaded from NERSC /global/cfs/cdirs/cosmo/work/legacysurvey/dr9m Directories: south/tractor north/tractor Downloaded using bbcp f..."

Show changes

@@ Line 242: / Line 242: @@
 === Internal Table ===
-  CREATE TABLE `cosmohub`.`legacysurvey_dr9`(
+  CREATE TABLE `cosmohub`.`legacy_survey_dr9`(
    `release` smallint,
    `brickid` int,
@@ Line 435: / Line 435: @@
-  INSERT OVERWRITE TABLE cosmohub.legacysurvey_dr9
+  INSERT INTO TABLE cosmohub.legacy_survey_dr9
-  SELECT release, brickid, brickname, objid, brick_primary, maskbits, fitbits,
+  SELECT  release, brickid, brickname, objid, brick_primary, maskbits, fitbits, type, ra, `dec`, ra_ivar, dec_ivar,
- type, ra, `dec`, ra_ivar, dec_ivar, bx, `by`, dchisq, ebv, mjd_min, mjd_max,
+ bx, `by`, dchisq, ebv, mjd_min, mjd_max, ref_cat, ref_id, pmra, pmdec, parallax, pmra_ivar, pmdec_ivar,
- ref_cat, ref_id, pmra, pmdec, parallax, pmra_ivar, pmdec_ivar, parallax_ivar,
+ parallax_ivar, ref_epoch, gaia_phot_g_mean_mag, gaia_phot_g_mean_flux_over_error, gaia_phot_g_n_obs,
- ref_epoch, gaia_phot_g_mean_mag, gaia_phot_g_mean_flux_over_error, gaia_phot_g_n_obs,
+  gaia_phot_bp_mean_mag, gaia_phot_bp_mean_flux_over_error, gaia_phot_bp_n_obs, gaia_phot_rp_mean_mag,
-  gaia_phot_bp_mean_mag, gaia_phot_bp_mean_flux_over_error, gaia_phot_bp_n_obs,
+  gaia_phot_rp_mean_flux_over_error, gaia_phot_rp_n_obs, gaia_phot_variable_flag, gaia_astrometric_excess_noise,
-  gaia_phot_rp_mean_mag, gaia_phot_rp_mean_flux_over_error, gaia_phot_rp_n_obs,
+ gaia_astrometric_excess_noise_sig, gaia_astrometric_n_obs_al, gaia_astrometric_n_good_obs_al,
- gaia_phot_variable_flag, gaia_astrometric_excess_noise, gaia_astrometric_excess_noise_sig,
+ gaia_astrometric_weight_al, gaia_duplicated_source, gaia_a_g_val, gaia_e_bp_min_rp_val,
- gaia_astrometric_n_obs_al, gaia_astrometric_n_good_obs_al, gaia_astrometric_weight_al,
+ gaia_phot_bp_rp_excess_factor, gaia_astrometric_sigma5d_max, gaia_astrometric_params_solved, flux_g, flux_r,
- gaia_duplicated_source, gaia_a_g_val, gaia_e_bp_min_rp_val, gaia_phot_bp_rp_excess_factor,
+  flux_z, flux_w1, flux_w2, flux_w3, flux_w4, flux_ivar_g, flux_ivar_r, flux_ivar_z, flux_ivar_w1, flux_ivar_w2,
- gaia_astrometric_sigma5d_max, gaia_astrometric_params_solved, flux_g, flux_r,
+ flux_ivar_w3, flux_ivar_w4, fiberflux_g, fiberflux_r, fiberflux_z, fibertotflux_g, fibertotflux_r, fibertotflux_z,
-  flux_z, flux_w1, flux_w2, flux_w3, flux_w4, flux_ivar_g, flux_ivar_r, flux_ivar_z,
+ apflux_g, apflux_r, apflux_z, apflux_resid_g, apflux_resid_r, apflux_resid_z, apflux_blobresid_g,
- flux_ivar_w1, flux_ivar_w2, flux_ivar_w3, flux_ivar_w4, fiberflux_g, fiberflux_r,
+  apflux_blobresid_r, apflux_blobresid_z, apflux_ivar_g, apflux_ivar_r, apflux_ivar_z, apflux_masked_g,
- fiberflux_z, fibertotflux_g, fibertotflux_r, fibertotflux_z, apflux_g, apflux_r,
+  apflux_masked_r, apflux_masked_z, apflux_w1, apflux_w2, apflux_w3, apflux_w4, apflux_resid_w1, apflux_resid_w2,
- apflux_z, apflux_resid_g, apflux_resid_r, apflux_resid_z, apflux_blobresid_g,
+ apflux_resid_w3, apflux_resid_w4, apflux_ivar_w1, apflux_ivar_w2, apflux_ivar_w3, apflux_ivar_w4,
-  apflux_blobresid_r, apflux_blobresid_z, apflux_ivar_g, apflux_ivar_r, apflux_ivar_z,
+ mw_transmission_g, mw_transmission_r, mw_transmission_z, mw_transmission_w1, mw_transmission_w2,
-  apflux_masked_g, apflux_masked_r, apflux_masked_z, apflux_w1, apflux_w2, apflux_w3,
+  mw_transmission_w3, mw_transmission_w4, nobs_g, nobs_r, nobs_z, nobs_w1, nobs_w2, nobs_w3, nobs_w4, rchisq_g,
- apflux_w4, apflux_resid_w1, apflux_resid_w2, apflux_resid_w3, apflux_resid_w4,
+ rchisq_r, rchisq_z, rchisq_w1, rchisq_w2, rchisq_w3, rchisq_w4, fracflux_g, fracflux_r, fracflux_z, fracflux_w1,
- apflux_ivar_w1, apflux_ivar_w2, apflux_ivar_w3, apflux_ivar_w4, mw_transmission_g,
+ fracflux_w2, fracflux_w3, fracflux_w4, fracmasked_g, fracmasked_r, fracmasked_z, fracin_g, fracin_r, fracin_z,
- mw_transmission_r, mw_transmission_z, mw_transmission_w1, mw_transmission_w2,
+  anymask_g, anymask_r, anymask_z, allmask_g, allmask_r, allmask_z, wisemask_w1, wisemask_w2, psfsize_g, psfsize_r,
-  mw_transmission_w3, mw_transmission_w4, nobs_g, nobs_r, nobs_z, nobs_w1, nobs_w2,
+ psfsize_z, psfdepth_g, psfdepth_r, psfdepth_z, galdepth_g, galdepth_r, galdepth_z, nea_g, nea_r, nea_z,
- nobs_w3, nobs_w4, rchisq_g, rchisq_r, rchisq_z, rchisq_w1, rchisq_w2, rchisq_w3,
+ blob_nea_g, blob_nea_r, blob_nea_z, psfdepth_w1, psfdepth_w2, psfdepth_w3, psfdepth_w4, wise_coadd_id, wise_x,
- rchisq_w4, fracflux_g, fracflux_r, fracflux_z, fracflux_w1, fracflux_w2, fracflux_w3,
+  wise_y, lc_flux_w1, lc_flux_w2, lc_flux_ivar_w1, lc_flux_ivar_w2, lc_nobs_w1, lc_nobs_w2, lc_fracflux_w1,
- fracflux_w4, fracmasked_g, fracmasked_r, fracmasked_z, fracin_g, fracin_r, fracin_z,
+ lc_fracflux_w2, lc_rchisq_w1, lc_rchisq_w2, lc_mjd_w1, lc_mjd_w2, lc_epoch_index_w1, lc_epoch_index_w2, sersic,
-  anymask_g, anymask_r, anymask_z, allmask_g, allmask_r, allmask_z, wisemask_w1,
+ sersic_ivar, shape_r, shape_r_ivar, shape_e1, shape_e1_ivar, shape_e2, shape_e2_ivar
- wisemask_w2, psfsize_g, psfsize_r, psfsize_z, psfdepth_g, psfdepth_r, psfdepth_z,
+  FROM cosmohub.legacy_survey_dr9_p
+  ;

Legacy Survey DR9 - Revision history

Tallada at 21:04, 30 November 2020

Tallada: /* Comments */

Tallada: /* Internal Table */

Tallada: /* Internal Table */

Tallada at 00:51, 26 November 2020

Tallada: Created page with "== Original DR9 == === Raw data === Downloaded from NERSC /global/cfs/cdirs/cosmo/work/legacysurvey/dr9m Directories: south/tractor north/tractor Downloaded using bbcp f..."