Project

General

Profile

SciencePortalProducts » History » Version 4

« Previous - Version 4/46 (diff) - Next » - Current version
Ricardo Ogando, 01/27/2016 01:31 PM


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

Latest Galaxy Spectroscopic Catalog for Y1A1 (25th of January)

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

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

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,,