You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »

DB Table name : catalogRecord

DB View : PhotoPrimary for compatibity with previous version of catalogue

DB View : GSC241publicVOview or use with outward facing services such as VO webservices

FieldNameDataTypeUCDunitFieldDescriptioniducd1+catalogRecordGSC241publicVOviewPhotoprimary
objIDlongID_DATABASE
Database IDobjIDmeta.recordxxx
hstIDcharID_MAIN
GSC2 Public IDhstIDmeta.id;meta.mainxxx
gsc1IDcharID_CROSSID
GSC1 IDgsc1IDmeta.id.crossxxx
gsc2IDcharID_IDENTIFIER
GSC2 Internal IDgsc2IDmeta.idxx
compassgsc2idlongID_CROSSID
COMPASS IDcompassgsc2idmeta.id.crossx

GAIAsourceIDlongID_CROSSID
GAIA DR1 IDGAIAsourceIDmeta.id.crossx

usageFlagshortCODE_MISC
Flag for previously used guide starusageFlagmeta.codex

sourceStatuslongCODE_MISC
Object status codessourceStatusmeta.code.statusxxx
radoublePOS_EQ_RA_MAINdegreeRight Ascension (ICRS)rapos.eq.ra;meta.mainxxx
decdoublePOS_EQ_DEC_MAINdegreeDeclination (ICRS)decpos.eq.dec;meta.mainxxx
epochfloatTIME_EPOCHyearEpoch of coordinateepochtime.epoch;obsxxx
raErrdoubleERRORarcsecRA errorraErrstat.errorxx
raEpsilon


Alias for raErr



x
decErrdoubleERRORarcsecDec errordecErrstat.errorxx
decEpsilon


Alias for decErr



x
posSourceunsignedByteID_CATALOG
Object coordinates sourceposSourcemeta.id;meta.datasetxx
rapmfloatPOS_EQ_PMRAmas/yearRA proper motionrapmpos.pm;pos.eq.raxxc
decpmfloatPOS_EQ_PMDECmas/yearDec proper motiondecpmpos.pm;pos.eq.decxxc
rapmErrfloatERRORmas/yearRA pm errorrapmErrstat.errorxxc
decpmErrfloatERRORmas/yearDec pm errordecpmErrstat.errorxxc
deltaEpochfloatTIME_INTERVALyearTime interval used for PM computationdeltaEpochtime.intervalxxc
pmSourceunsignedByteID_CATALOG
Proper motion sourcepmSourcemeta.id;meta.datasetxx
parallaxdoublePOS_PARLX_TRIGmasParallaxparallaxpos.parallax.trigxx
plxErrdoubleERRORmasParallax errorplxErrstat.errorxx
plxSourceunsignedByteID_CATALOG
Parallax sourceplxSourcemeta.id;meta.datasetxx
radialVelocityfloatVELOCITY_HCkm/sRadial velocityradialVelocityspect.dopplerVelocityxx
rvErrfloatERRORkm/sRadial velocity errorrvErrstat.errorxx
rvSourceunsignedByteID_CATALOG
Radial velocity sourcervSourcemeta.id;meta.datasetxx
classificationintCLASS_OBJECT
Object classification codeclassificationmeta.code.classxx
class


Alias for classification



x
classSourceintID_CATALOG
Classification sourceclassSourcemeta.id;meta.datasetxx
variableFlagcharCODE_VARIAB
Flag for known variablevariableFlagmeta.code.statusxxx
varSourceunsignedByteID_CATALOG
Variability sourcevarSourcemeta.id;meta.datasetxx
multipleFlagcharCODE_MULT_FLAGFlag for known multiplemultipleFlagmeta.code.classxxx
multSourceunsignedByteID_CATALOG
Multiplicity sourcemultSourcemeta.id;meta.datasetxx
gaiaGmagdoublePHOT_MAGmagGaia G band magnitudegaiaGmagphot.mag;em.optxx
gaiaGmagErrfloatERRORmagGaia G band magnitude errorgaiaGmagErrstat.errorxx
gaiaGmagCodeunsignedBytePHOT_SYS-ID
Gaia G band codegaiaGmagCodemeta.codexx
OpgMagfloatPHOT_PHG_BmagPhotographic O band magnitudeOpgMagphot.mag;em.opt.Bxx
OpgMagErrfloatERRORmagPhotographic O band magnitude errorOpgMagErrstat.errorxx
OpgMagCodeunsignedBytePHOT_SYS-ID
Photographic O band codeOpgMagCodemeta.codexx
JpgMagfloatPHOT_PHG_BJmagPhotographic Blue magnitudeJpgMagphot.mag;em.opt.Bxxx
JpgMagErrfloatERRORmagPhotographic Blue magnitude errorJpgMagErrstat.errorxxx
JpgMagCodeintPHOT_SYS-ID
Photographic Blue bandpass codeJpgMagCodemeta.codexxx
VpgMagfloatPHOT_PHG_VmagPhotographic V band magnitudeVpgMagphot.mag;em.opt.Vxx
VpgMagErrfloatERRORmagPhotographic V band magnitude errorVpgMagErrstat.errorxx
VpgMagCodeunsignedBytePHOT_SYS-ID
Photographic V band codeVpgMagCodemeta.codexx
FpgMagfloatPHOT_PHG_RmagPhotographic Red magnitudeFpgMagphot.mag;em.opt.Rxxx
FpgMagErrfloatERRORmagPhotographic Red magnitude errorFpgMagErrstat.errorxxx
FpgMagCodeintPHOT_SYS-ID
Photographic Red bandpass codeFpgMagCodemeta.codexxx
EpgMagfloatPHOT_PHG_RmagPhotographic E band magnitudeEpgMagphot.mag;em.opt.Rxx
EpgMagErrfloatERRORmagPhotographic E band magnitude errorEpgMagErrstat.errorxx
EpgMagCodeunsignedBytePHOT_SYS-ID
Photographic E band codeEpgMagCodemeta.codexx
NpgMagfloatPHOT_PHG_ImagPhotographic Near-IR magnitudeNpgMagphot.mag;em.opt.Ixx
Nmag


Alias for NpgMag



x
NpgMagErrfloatERRORmagPhotographic Near-IR magnitude errorNpgMagErrstat.errorxx
NmagErr


Alias ffor NpgMagErr



x
NpgMagCodeintPHOT_SYS-ID
Photographic Near-IR bandpass codeNpgMagCodemeta.codexx
NmagCode


Alias for NpgMagCode



x
UmagfloatPHOT_MAG_UmagU band magnitudeUmagphot.mag;em.opt.Uxxx
UmagErrfloatERRORmagU band magnitude errorUmagErrstat.errorxxx
UmagCodeintPHOT_SYS-ID
U band bandpass codeUmagCodemeta.codexxx
UmagSourceunsignedByteID_CATALOG
U band magnitude sourceUmagSourcemeta.id;meta.datasetx

BmagfloatPHOT_MAG_BmagB band magnitudeBmagphot.mag;em.opt.Bxxx
BmagErrfloatERRORmagB band magnitude errorBmagErrstat.errorxxx
BmagCodeintPHOT_SYS-ID
B band bandpass codeBmagCodemeta.codexxx
BmagSourceintID_CATALOG
B band magnitude sourceBmagSourcemeta.id;meta.datasetx

VmagfloatPHOT_MAG_VmagV band magnitudeVmagphot.mag;em.opt.Vxxx
VmagErrfloatERRORmagV band magnitude errorVmagErrstat.errorxxx
VMagCodeintPHOT_SYS-ID
V band bandpass codeVMagCodemeta.codexxx
VmagSourceintID_CATALOG
V band magnitude sourceVmagSourcemeta.id;meta.datasetx

RmagfloatPHOT_MAG_RmagR band magnitudeRmagphot.mag;em.opt.Rxxx
RmagErrfloatERRORmagR band magnitude errorRmagErrstat.errorxxx
RmagCodeintPHOT_SYS-ID
R band bandpass codeRmagCodemeta.codexxx
RmagSourceunsignedByteID_CATALOG
R band magnitude sourceRmagSourcemeta.id;meta.datasetx

ImagfloatPHOT_MAG_ImagI band magnitudeImagphot.mag;em.opt.Ixxx
ImagErrfloatERRORmagI band magnitude errorImagErrstat.errorxxx
ImagCodeintPHOT_SYS-ID
I band bandpass codeImagCodemeta.codexxx
ImagSourceunsignedByteID_CATALOG
I band magnitude sourceImagSourcemeta.id;meta.datasetx

SDSSuMagfloatPHOT_SDSS_UmagSDSS u band magnitudeSDSSuMagphot.mag;em.opt.Uxx
SDSSuMagErrfloatERRORmagSDSS u band magnitude errorSDSSuMagErrstat.errorxx
SDSSuMagCodeunsignedBytePHOT_SYS-ID
SDSS u band codeSDSSuMagCodemeta.codexx
SDSSuMagSourceunsignedByteID_CATALOG
SDSS u band magnitude sourceSDSSuMagSourcemeta.id;meta.datasetx

SDSSgMagfloatPHOT_SDSS_GmagSDSS g band magnitudeSDSSgMagphot.mag;em.opt.Bxx
SDSSgMagErrfloatERRORmagSDSS g band magnitude errorSDSSgMagErrstat.errorxx
SDSSgMagCodeintPHOT_SYS-ID
SDSS g band codeSDSSgMagCodemeta.codexx
SDSSgMagSourceintID_CATALOG
SDSS g band magnitude sourceSDSSgMagSourcemeta.id;meta.datasetx

SDSSrMagfloatPHOT_SDSS_RmagSDSS r band magnitudeSDSSrMagphot.mag;em.opt.Rxx
SDSSrMagErrfloatERRORmagSDSS r band magnitude errorSDSSrMagErrstat.errorxx
SDSSrMagCodeintPHOT_SYS-ID
SDSS r band codeSDSSrMagCodemeta.codexx
SDSSrMagSourceintID_CATALOG
SDSS r band magnitude sourceSDSSrMagSourcemeta.id;meta.datasetx

SDSSiMagfloatPHOT_SDSS_ImagSDSS i band magnitudeSDSSiMagphot.mag;em.opt.Ixx
SDSSiMagErrfloatERRORmagSDSS i band magnitude errorSDSSiMagErrstat.errorxx
SDSSiMagCodeintPHOT_SYS-ID
SDSS i band codeSDSSiMagCodemeta.codexx
SDSSiMagSourceintID_CATALOG
SDSS i band magnitude sourceSDSSiMagSourcemeta.id;meta.datasetx

SDSSzMagfloatPHOT_SDSS_ZmagSDSS z band magnitudeSDSSzMagphot.mag;em.opt.Ixx
SDSSzMagErrfloatERRORmagSDSS z band magnitude errorSDSSzMagErrstat.errorxx
SDSSzMagCodeunsignedBytePHOT_SYS-ID
SDSS z band codeSDSSzMagCodemeta.codexx
SDSSzMagSourceunsignedByteID_CATALOG
SDSS z band magnitude sourceSDSSzMagSourcemeta.id;meta.datasetx

PS1yMagfloatPHOT_MAGmagPanSTARRS y band magnitudePS1yMagphot.mag;em.IR.NIRxx
PS1yMagErrfloatERRORmagPanSTARRS y band magnitude errorPS1yMagErrstat.errorxx
PS1yMagCodeunsignedBytePHOT_SYS-ID
PanSTARRS y band codePS1yMagCodemeta.codexx
PS1ymagSourceunsignedByteID_CATALOG
PanSTARRS y band magnitude sourcePS1ymagSourcemeta.id;meta.datasetx

tmassJmagdoublePHOT_MAG_Jmag2MASS J band magnitudetmassJmagphot.mag;em.IR.Jxx
Jmag


Alias for tmassJmag



x
tmassJmagErrdoubleERRORmag2MASS J band magnitude errortmassJmagErrstat.errorxx
JmagErr


Alias for tmassJmagErr



x
tmassJmagCodeintPHOT_SYS-ID
2MASS J band codetmassJmagCodemeta.codexx
JmagCode


Alias for tmassJmageCode



x
tmassJmagSourceintID_CATALOG
2MASS J band magnitude sourcetmassJmagSourcemeta.id;meta.datasetx

tmassHmagdoublePHOT_MAG_Hmag2MASS H band magnitudetmassHmagphot.mag;em.IR.Hxx
Hmag


Alias for tmassHmag



x
tmassHmagErrdoubleERRORmag2MASS H band magnitude errortmassHmagErrstat.errorxx
HmagErr


Alias for tmassHmagErr



x
tmassHmagCodeintPHOT_SYS-ID
2MASS H band codetmassHmagCodemeta.codexx
HmagCode


Alias for tmassHmagCode



x
tmassHmagSourceintID_CATALOG
2MASS H band magnitude sourcetmassHmagSourcemeta.id;meta.datasetx

tmassKsmagdoublePHOT_MAG_Kmag2MASS Ks band magnitudetmassKsmagphot.mag;em.IR.Kxx
Kmag


Alias for tmassKsmag



x
tmassKsmagErrdoubleERRORmag2MASS Ks band magnitude errortmassKsmagErrstat.errorxx
KmagErr


Alias for tmassKsmagErr



x
tmassKsmagCodeintPHOT_SYS-ID
2MASS Ks band codetmassKsmagCodemeta.codexx
KmagCode


Alias for tmassKsmagCode



x
tmassKsmagSourceintID_CATALOG
2MASS Ks band magnitude sourcetmassKsmagSourcemeta.id;meta.datasetx

VistaZMagfloatPHOT_MAGmagVISTA Z band magnitudeVistaZMagphot.mag;em.IR.NIRxx
VistaZMagErrfloatERRORmagVISTA Z band magnitude errorVistaZMagErrstat.errorxx
VistaZMagCodeunsignedBytePHOT_SYS-ID
VISTA Z band codeVistaZMagCodemeta.codexx
VistaZmagSourceunsignedByteID_CATALOG
VISTA Z band magnitude sourceVistaZmagSourcemeta.id;meta.datasetx

VistaYmagfloatPHOT_MAGmagVISTA Y band magnitudeVistaYmagphot.mag;em.IR.NIRxx
VistaYMagErrfloatERRORmagVISTA Y band magnitude errorVistaYMagErrstat.errorxx
VistaYMagCodeunsignedBytePHOT_SYS-ID
VISTA Y band codeVistaYMagCodemeta.codexx
VistaYmagSourceunsignedByteID_CATALOG
VISTA Y band magnitude sourceVistaYmagSourcemeta.id;meta.datasetx

VistaKmagfloatPHOT_MAG_KmagVISTA K band magnitudeVistaKmagphot.mag;em.IR.Kxx
VistaKMagErrfloatERRORmagVISTA K band magnitude errorVistaKMagErrstat.errorxx
VistaKMagCodeunsignedBytePHOT_SYS-ID
VISTA K band codeVistaKMagCodemeta.codexx
VistaKmagSourceunsignedByteID_CATALOG
VISTA K band magnitude sourceVistaKmagSourcemeta.id;meta.datasetx

WISEw1MagfloatPHOT_IR_3.4magWISE W1 (3.4um) band magnitudeWISEw1Magphot.mag;em.IR.3-4umxx
WISEw1MagErrfloatERRORmagWISE W1 (3.4um) band magnitude errorWISEw1MagErrstat.errorxx
WISEw1MagCodeunsignedBytePHOT_SYS-ID
WISE W1 (3.4um) band codeWISEw1MagCodemeta.codexx
WISEw1MagSOurceunsignedByteID_CATALOG
WISE W1 (3.4um) band magnitude sourceWISEw1MagSOurcemeta.id;meta.datasetx

WISEw2MagfloatPHOT_IR_4.2magWISE W2 (4.6um) band magnitudeWISEw2Magphot.mag;em.IR.4-8umxx
WISEw2MagErrfloatERRORmagWISE W2 (4.6um) band magnitude errorWISEw2MagErrstat.errorxx
WISEw2MagCodeunsignedBytePHOT_SYS-ID
WISE W2 (4.6um) band codeWISEw2MagCodemeta.codexx
WISEw2MagSOurceunsignedByteID_CATALOG
WISE W2 (4.6um) band magnitude sourceWISEw2MagSOurcemeta.id;meta.datasetx

WISEw3MagfloatPHOT_FLUX_IR_12magWISE W3 (12um) band magnitudeWISEw3Magphot.flux.density;em.IR.8-15umxx
WISEw3MagErrfloatERRORmagWISE W3 (12um) band magnitude errorWISEw3MagErrstat.errorxx
WISEw3MagCodeunsignedBytePHOT_SYS-ID
WISE W3 (12um) band codeWISEw3MagCodemeta.codexx
WISEw3MagSOurceunsignedByteID_CATALOG
WISE W3 (12um) band magnitude sourceWISEw3MagSOurcemeta.id;meta.datasetx

WISEw4MagfloatPHOT_FLUX_IR_25magWISE W4 (22um) band magnitudeWISEw4Magphot.flux.density;em.IR.15-30umxx
WISEw4MagErrfloatERRORmagWISE W4 (22um) band magnitude errorWISEw4MagErrstat.errorxx
WISEw4MagCodeunsignedBytePHOT_SYS-ID
WISE W4 (22um) band codeWISEw4MagCodemeta.codexx
WISEw4MagSOurceunsignedByteID_CATALOG
WISE W4 (22um) band magnitude sourceWISEw4MagSOurcemeta.id;meta.datasetx

FUVmagfloatPHOT_MAG_UVmagGALEX FUV band magnitudeFUVmagphot.mag;em.UV.100-200nmxx
FUVmagErrfloatERRORmagGALEX FUV band magnitude errorFUVmagErrstat.errorxx
FUVmagCodeunsignedBytePHOT_SYS-ID
GALEX FUV band codeFUVmagCodemeta.codexx
FUVmagSourceunsignedByteID_CATALOG
GALEX FUV band magnitude sourceFUVmagSourcemeta.id;meta.datasetx

NUVmagfloatPHOT_MAG_UVmagGALEX NUV band magnitudeNUVmagphot.mag;em.UVxx
NUVmagErrfloatERRORmagGALEX NUV band magnitude errorNUVmagErrstat.errorxx
NUVmagCodeunsignedBytePHOT_SYS-ID
GALEX NUV band codeNUVmagCodemeta.codexx
NUVmagSourceunsignedByteID_CATALOG
GALEX NUV band magnitude sourceNUVmagSourcemeta.id;meta.datasetx

gsc2semiMajorAxisfloatOBS_PARAMpixelsSemiMajor diameter of objectgsc2semiMajorAxisphys.angSize.smajAxisxxx
gsc2eccentricityfloatOBS_PARAM
Eccentricity of objectgsc2eccentricityphys.size.axisRatioxxx
gsc2positionAnglefloatOBS_PARAMdegreePosition Angle (North thru East)gsc2positionAnglepos.posAngxxx
magfloatPHOT_MAGmag'best' available magmagphot.mag
x
  • No labels