SciencePortalProducts » History » Version 42
« Previous -
Version 42/46
(diff) -
Next » -
Current version
Aurelio Rosell, 02/16/2016 01:44 PM
- Table of contents
- Science Portal Products
- Latest Galaxy Spectroscopic Catalog for Y1A1 (25th of January) - NO PRIMUS -
- Gold v1.2 matched to spectroscopic catalog 25th January - NO PRIMUS -
- Gold v1.2 matched to PRIMUS catalog 25th January
- Star Spectroscopic Catalog - Calibration -
- Y1A1 DFULL photometric sample matched to 25th Jan Spectroscopic Catalog -
Science Portal Products¶
Introduction
These products have been created by the Science Portal, with the contribution of Julia Gschwend, Aurelio Carnero, Ricardo Ogando, Angelo Fausti, Flavia Sobreira, Luiz da Costa and all the DES-Brazil group and IT Team, and of course, with contribution from the DES collaboration!
This page lists Science Portal products that have been exported to NCSA database.
In the near future, the available products at NCSA will be shown in a interface of the Science Portal instance at Fermilab.
Please report anything strange to helpdesk@linea.gov.br
Latest Galaxy Spectroscopic Catalog for Y1A1 (25th of January) - NO PRIMUS -¶
This is the last version of galaxy spectroscopic catalog used in the Y1A1 photo-z analysis.
There will be changes only if bugs are found.
TABLE NAME IN DESDM DATABASE = brportal.e_10022146_295159
Example query using easyaccess: Describe the content of the table
describe_table brportal.e_10022146_295159
Example query using easyaccess: Create a fits file containing all data:
select * from brportal.e_10022146_295159; > spec_cat_y1a1.fits
The data can also be found as fits file here with README
Details
We have produced a new galaxy spectroscopic catalog suitable for Y1A1. This new version contains the last OzDES observations released on the 5th of January 2016, the final DR3 zcosmos bright galaxy sample and two small surveys spotted by Ben hoyle, GLASS and XXL_AAOmega, plus all the other surveys available in previous versions. This version will be the final version for Y1A1 Analysis, unless a bug is found in the catalog or a major survey appears in the literature, as it was discussed in the last telecon.
| Column Name | Data Type | Data Format | Description |
|---|---|---|---|
| FLAG_DES | NUMBER | 22,,0 | Normalized redshift quality flag, 3 and 4 are recommended |
| Z | BINARY_DOUBLE | 8,, | Spectroscopic redshift |
| IDSPEC | NUMBER | 22,,0 | Obsolote 9999 |
| TILENAME | VARCHAR2 | 12,, | DES tilename if in DES footprint, None if out of footprint |
| ERR_Z | BINARY_DOUBLE | 8,, | Error in redshift, 99 if not given |
| SOURCE | VARCHAR2 | 13,, | Survey of origin |
| FLAG | BINARY_DOUBLE | 8,, | Original quality flag in source |
| RA | BINARY_DOUBLE | 8,, | Right Ascencion |
| DEC | BINARY_DOUBLE | 8,, | Declination |
| ID | NUMBER | 22,,0 | Internal ID |
Gold v1.2 matched to spectroscopic catalog 25th January - NO PRIMUS -¶
TABLE NAME IN DESDM DATABASE = brportal.Y1A1_SPEC_GOLD_V2_WEIGHT_DEPTH
Also, it is here
This catalog contains a match to Y1A1 Gold sample, including extra-columns, computed with the Help of Christopher Bonnet (weights + valid/train flag) and Antonella Palmese (depth information)
| Column Name | Data Type | Data Format | Description |
|---|---|---|---|
| FLAG_DES | NUMBER | 22,,0 | Normalized redshift quality flag, 3 and 4 are recommended |
| Z | BINARY_DOUBLE | 8,, | Spectroscopic redshift |
| ERR_Z | BINARY_DOUBLE | 8,, | Error in redshift, 99 if not given |
| SOURCE | VARCHAR2 | 13,, | Survey of origin |
| FLAG | BINARY_DOUBLE | 8,, | Original quality flag in source |
| RA_SPEC | BINARY_DOUBLE | 8,, | Right Ascencion spectroscopic sample |
| DEC_SPEC | BINARY_DOUBLE | 8,, | Declination spectroscopic sample |
| SEPARATION | BINARY_DOUBLE | 8,, | Separation in arcsec from the matching to photometry |
| DES_FIELD | VARCHAR2 | 10,, | Field in Y1A1 |
| G_R | BINARY_DOUBLE | 8,, | mag_auto_g-mag_auto_r |
| R_I | BINARY_DOUBLE | 8,, | mag_auto_r-mag_auto_i |
| I_Z | BINARY_DOUBLE | 8,, | mag_auto_i-mag_auto_z |
| VALID | NUMBER | 22,11,0 | train,valid flag. If use in validation = 1, if not, in training |
| WL_VALID_WEIGHTS | BINARY_DOUBLE | 8,, | weight for WL sample, after valid flag |
| WL_TRAIN_WEIGHTS | BINARY_DOUBLE | 8,, | weight for WL sample, after train flag |
| WL_ALL_WEIGHTS | BINARY_DOUBLE | 8,, | weight for WL sample, together valid and train |
| LSS_VALID_WEIGHTS | BINARY_DOUBLE | 8,, | weight for LSS sample, after valid flag |
| LSS_TRAIN_WEIGHTS | BINARY_DOUBLE | 8,, | weight for LSS sample, after train flag |
| LSS_ALL_WEIGHTS | BINARY_DOUBLE | 8,, | weight for LSS sample, together valid and train |
| COADD_OBJECTS_ID_1 | NUMBER | 22,, | coadd objects id |
| RA | BINARY_DOUBLE | 8,, | y1a1 ra |
| DEC | BINARY_DOUBLE | 8,, | y1a1 dec |
| COADD_OBJECTS_ID_2 | NUMBER | 22,, | coadd objects id twice |
| DEPTH_MAG_AUTO_GRIZY | BINARY_DOUBLE | 8,, | y1a1 mag auto depth in 10sigma band grizY gold |
| + GOLD columns | ALL GOLD COLUMNS | xx | All gold columns |
Gold v1.2 matched to PRIMUS catalog 25th January¶
TABLE NAME IN DESDM DATABASE = brportal.primus_gold_y1a1_spec_weights
Also "here":
We separated the Primus data in a different file, We weighted separately to LSS and WL as above
Star Spectroscopic Catalog - Calibration -¶
This is a first spectroscopically selected star catalog overlapping DES footprint.
Requested by Douglas Tucker.
TABLE NAME IN DESDM DATABASE = brportal.e_10022133_295145
Example query using easyaccess: Describe the content of the table
describe_table brportal.e_10022133_295145
Example query using easyaccess: Create a fits file containing all data:
select * from brportal.e_10022133_295145; > star_catalog.fits
Details
We have produced a clean and high quality star spectroscopic catalog after the request by Douglas Tucker. This new version contains the last version of all the available spectroscopic surveys maintained at the Science Portal.
| Column Name | Data Type | Data Format | Description |
|---|---|---|---|
| FLAG_DES | NUMBER | 22,,0 | Normalized redshift quality flag, 3 and 4 are recommended |
| Z | BINARY_DOUBLE | 8,, | Spectroscopic redshift |
| IDSPEC | NUMBER | 22,,0 | Obsolote 9999 |
| TILENAME | VARCHAR2 | 12,, | DES tilename if in DES footprint, None if out of footprint |
| ERR_Z | BINARY_DOUBLE | 8,, | Error in redshift, 99 if not given |
| SOURCE | VARCHAR2 | 13,, | Survey of origin |
| FLAG | BINARY_DOUBLE | 8,, | Original quality flag in source |
| RA | BINARY_DOUBLE | 8,, | Right Ascencion |
| DEC | BINARY_DOUBLE | 8,, | Declination |
| ID | NUMBER | 22,,0 | Internal ID |
Y1A1 DFULL photometric sample matched to 25th Jan Spectroscopic Catalog -¶
This is a first released of a match between Y1A1 DFULL data to the last spectroscopic sample (25th of January)
Requested by Manda Banerji.
TABLE NAME IN DESDM DATABASE = brportal.e_10022181_295280
Example query using easyaccess: Describe the content of the table
describe_table brportal.e_10022181_295280
Example query using easyaccess: Create a fits file containing all data:
select * from brportal.e_10022181_295280; > dfull_spec.fits
Details
We have produced a clean and high quality spectroscopic catalog, that was after matched to DFULL Y1A1 coadd data, using a matching radius of 1 arcsec.
| Column Name | Data Type | Data Format | Description |
|---|---|---|---|
| MAG_DETMODEL_Y | BINARY_DOUBLE | 8,, | |
| MAG_DETMODEL_Z | BINARY_DOUBLE | 8,, | |
| COADD_OBJECTS_ID | NUMBER | 22,,0 | |
| MAG_DETMODEL_R | BINARY_DOUBLE | 8,, | |
| MAGERR_MODEL_R | BINARY_DOUBLE | 8,, | |
| MAG_DETMODEL_I | BINARY_DOUBLE | 8,, | |
| SPREADERR_MODEL_R | BINARY_DOUBLE | 8,, | |
| SPREAD_MODEL_R | BINARY_DOUBLE | 8,, | |
| MAG_DETMODEL_G | BINARY_DOUBLE | 8,, | |
| MAGERR_DETMODEL_G | BINARY_DOUBLE | 8,, | |
| MAG_AUTO_G | BINARY_DOUBLE | 8,, | |
| MAG_AUTO_I | BINARY_DOUBLE | 8,, | |
| MAGERR_MODEL_Y | BINARY_DOUBLE | 8,, | |
| MAGERR_DETMODEL_I | BINARY_DOUBLE | 8,, | |
| ID | NUMBER | 22,,0 | Internal Spectroscopic ID |
| MAG_AUTO_R | BINARY_DOUBLE | 8,, | |
| SOURCE | VARCHAR2 | 13,, | Origin of spectroscopic information |
| RA | BINARY_DOUBLE | 8,, | |
| MAG_AUTO_Z | BINARY_DOUBLE | 8,, | |
| MAG_AUTO_Y | BINARY_DOUBLE | 8,, | |
| MAGERR_DETMODEL_Z | BINARY_DOUBLE | 8,, | |
| MAGERR_DETMODEL_Y | BINARY_DOUBLE | 8,, | |
| MAGERR_DETMODEL_R | BINARY_DOUBLE | 8,, | |
| SPREAD_MODEL_I | BINARY_DOUBLE | 8,, | |
| SPREADERR_MODEL_G | BINARY_DOUBLE | 8,, | |
| SPREADERR_MODEL_I | BINARY_DOUBLE | 8,, | |
| TILENAME | VARCHAR2 | 12,, | |
| FLAG_DES | NUMBER | 22,,0 | Normalized redshift quality flag, 3 and 4 are recommended |
| SPREAD_MODEL_Y | BINARY_DOUBLE | 8,, | |
| SPREAD_MODEL_Z | BINARY_DOUBLE | 8,, | |
| DES_FIELD | VARCHAR2 | 23,, | DES field (SN, VVDS, COSMOS...) |
| SPREADERR_MODEL_Y | BINARY_DOUBLE | 8,, | |
| SPREADERR_MODEL_Z | BINARY_DOUBLE | 8,, | |
| SPREAD_MODEL_G | BINARY_DOUBLE | 8,, | |
| MAGERR_MODEL_Z | BINARY_DOUBLE | 8,, | |
| Z | BINARY_DOUBLE | 8,, | Spectroscopic redshift |
| MAG_MODEL_I | BINARY_DOUBLE | 8,, | |
| MAGERR_AUTO_Y | BINARY_DOUBLE | 8,, | |
| MAGERR_AUTO_Z | BINARY_DOUBLE | 8,, | |
| MAGERR_AUTO_G | BINARY_DOUBLE | 8,, | |
| MAG_MODEL_G | BINARY_DOUBLE | 8,, | |
| FLAG | BINARY_DOUBLE | 8,, | Original quality flag |
| MAGERR_AUTO_R | BINARY_DOUBLE | 8,, | |
| ERR_Z | BINARY_DOUBLE | 8,, | Error in spectroscopic redshift |
| PIX_4096_NEST | NUMBER | 22,,0 | Healpix pixel in nside = 4096 (nest) |
| MAG_MODEL_Y | BINARY_DOUBLE | 8,, | |
| MAGERR_AUTO_I | BINARY_DOUBLE | 8,, | |
| MAGERR_MODEL_I | BINARY_DOUBLE | 8,, | |
| MAG_MODEL_Z | BINARY_DOUBLE | 8,, | |
| MAGERR_MODEL_G | BINARY_DOUBLE | 8,, | |
| DEC | BINARY_DOUBLE | 8,, | |
| MAG_MODEL_R | BINARY_DOUBLE | 8,, |