TABLE  mgcBrightSpec

Combination of extraction parameters that are unique to MGC_BRIGHT and the MGC redshift catalogue.

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
MGCIDbigint8 MGC object ID  
QUALITYtinyint1 Quality class  
HLRADIUSreal4pixelSemi-major axis of half-light ellipse  
INEXRtinyint1 Exclusion region flag (0 exclude/ 1 keep)  
MU_EFFreal4mag arcsec^-2Effective surface brightness  
SDSS_Nint4 Number of SDSS objects matched to MGC object  
SDSS_OBJIDbigint8 SDSS PhotoObject ID  
SDSS_RUNint4 SDSS run number  
SDSS_RERUNint4 SDSS rerun number  
SDSS_CAMCOLint4 SDSS camera column  
SDSS_FIELDint4 SDSS field number  
SDSS_RAfloat8 SDSS object right ascension in deg (J2000)  
SDSS_DECfloat8 SDSS object declination in deg (J2000)  
SDSS_PSFMAG_Ureal4 SDSS extinction corrected PSF magnitude  
SDSS_PSFMAG_Greal4 SDSS extinction corrected PSF magnitude  
SDSS_PSFMAG_Rreal4 SDSS extinction corrected PSF magnitude  
SDSS_PSFMAG_Ireal4 SDSS extinction corrected PSF magnitude  
SDSS_PSFMAG_Zreal4 SDSS extinction corrected PSF magnitude  
SDSS_PETMAG_Ureal4 SDSS extinction corrected Petrosian magnitude  
SDSS_PETMAG_Greal4 SDSS extinction corrected Petrosian magnitude  
SDSS_PETMAG_Rreal4 SDSS extinction corrected Petrosian magnitude  
SDSS_PETMAG_Ireal4 SDSS extinction corrected Petrosian magnitude  
SDSS_PETMAG_Zreal4 SDSS extinction corrected Petrosian magnitude  
SDSS_MODMAG_Ureal4 SDSS extinction corrected model magnitude  
SDSS_MODMAG_Greal4 SDSS extinction corrected model magnitude  
SDSS_MODMAG_Rreal4 SDSS extinction corrected model magnitude  
SDSS_MODMAG_Ireal4 SDSS extinction corrected model magnitude  
SDSS_MODMAG_Zreal4 SDSS extinction corrected model magnitude  
SDSS_EXTINC_Ureal4 SDSS Galactic extinction correction in mag  
SDSS_EXTINC_Greal4 SDSS Galactic extinction correction in mag  
SDSS_EXTINC_Rreal4 SDSS Galactic extinction correction in mag  
SDSS_EXTINC_Ireal4 SDSS Galactic extinction correction in mag  
SDSS_EXTINC_Zreal4 SDSS Galactic extinction correction in mag  
SDSS_PETR50_Ureal4 SDSS radius containing 50% Petrosian flux in arcsec  
SDSS_PETR50_Greal4 SDSS radius containing 50% Petrosian flux in arcsec  
SDSS_PETR50_Rreal4 SDSS radius containing 50% Petrosian flux in arcsec  
SDSS_PETR50_Ireal4 SDSS radius containing 50% Petrosian flux in arcsec  
SDSS_PETR50_Zreal4 SDSS radius containing 50% Petrosian flux in arcsec  
SDSS_TYPEsmallint2 SDSS morphological classification  
SDSS_CLASSsmallint2 MGC translation of SDSS_TYPE  
SDSS_SPECCLASSsmallint2 SDSS spectroscopic classification  
SDSS_SPCLASSsmallint2 MGC translation of SDSS_SPECCLASS  
TDFGRS_Nsmallint2 Number of 2dFGRS objects/spectra for this MGC object  
TDFGRS_NAMEvarchar10 2dFGRS object name  
TDFGRS_SEQNUMbigint8 2dFGRS sequence number  
TDFGRS_RAfloat8 2dFGRS object right ascension in deg (J2000)  
TDFGRS_DECfloat8 2dFGRS object declination in deg (J2000)  
TDFGRS_UKSTint4 UKST survey field number  
TDFGRS_BJGreal4 2dFGRS final b_J magnitude  
TDGRS_BJSELreal4 2dFGRS final extinction corrected b_J magnitude  
TDFGRS_SBBJMAGreal4 SSS b_J magnitude  
TDFGRS_SRRMAGreal4 SSS R magnitude  
TDGRS_IGALtinyint1 2dFGRS classification  
TDFGRS_CLASSsmallint2 MGC translation of TDFGRS_IGAL  
TQZ_NAMEvarchar20 2QZ object name  
TQZ_RAfloat8 2QZ object right ascension in deg (J2000)  
TQZ_DECfloat8 2QZ object declination in deg (J2000)  
TQZ_UKSTint4 UKST survey field number  
TQZ_BJreal4 2QZ bJ magnitude  
TQZ_UMBJreal4 2QZ U-bJ colour  
TQZ_BJMRreal4 2QZ bJ-R colour  
TQZ_DUSTreal4 2QZ E(B-V)  
TQZ_NOBStinyint1 Number of 2QZ spectra for this MGC object  
TQZ_IDENTvarchar10 2QZ identification  
TQZ_CLASSsmallint2 MGC translation of TQZ_IDENT  
NED_Nsmallint2 Number of NED objects matched to this MGC object  
NED_NAMEvarchar32 NED object name  
NED_RAfloat8 NED object right ascension in deg (J2000)  
NED_DECfloat8 NED object declination in deg (J2000)  
NED_IDENTvarchar4 NED identification  
NED_CLASSsmallint2 MGC translation of NED_IDENT  
PF_NAMEvarchar8 PFr object name  
PF_RAfloat8 PFr object right ascension in deg (J2000)  
PF_DECfloat8 PFr object declination in deg (J2000)  
PF_Rreal4 PFr R magnitude from USNO  
PF_Kreal4 PFr K magnitude from 2MASS  
PF_JMKreal4 PFr J-K colour from 2MASS  
LSBG_NAMEvarchar10 LSBG object name  
LSBG_RAfloat8 LSBG object right ascension in deg (J2000)  
LSBG_DECfloat8 LSBG object declination in deg (J2000)  
LSBG_BTOTfloat8 LSBG total B magnitude  
LSBG_MUCENreal4 LSBG central surface brightness in mag/arcsec^2  
LSBG_MUEFFreal4 LSBG effective surface brightness  
LSBG_REFFreal4 LSBG effective radius in arcsec  
MGCZ_ZHELIOreal4 MGCz heliocentric redshift  
MGCZ_ZQUALtinyint1 MGCz redshift quality  
SDSS_Zreal4 SDSS redshift  
SDSS_ZQUALtinyint1 SDSS redshift quality  
TDFGRS_ZHELIOreal4 2dFGRS heliocentric redshift  
TDFGRS_ZQUALtinyint1 2dFGRS redshift quality  
BESTTQZ_Zreal4 2qz redshift  
TQZ_ZQUALtinyint1 2QZ redshift quality  
NED_ZHELIOreal4 NED heliocentric redshift  
NED_ZQUALtinyint1 NED redshift quality  
PF_Zreal4 PFr redshift  
PF_ZQUALtinyint1 PFr redshift quality  
LSBG_Zreal4 LSBG heliocentric redshift  
LSBG_ZQUALtinyint1 LSBG redshift quality  
ZSOURCEvarchar10 Identifier for best redshift and quality  
BEST_Zreal4 Best redshift  
BEST_ZQUALtinyint1 Quality of best redshift  
N_SPECsmallint2 Total number of spectra for this object  
Total length488