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

Compare with Current View Page History

« Previous Version 5 Next »

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+catalogRecordPhotoprimaryGSC241publicVOview
objIDlongID_DATABASE
Database IDobjIDmeta.recordxxx
hstIDcharID_MAIN
GSC2 Public IDhstIDmeta.id;meta.mainxxx
gsc1IDcharID_CROSSID
GSC1 IDgsc1IDmeta.id.crossxxx
gsc2IDcharID_IDENTIFIER
GSC2 Internal IDgsc2IDmeta.idx
x
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.errorx
x
raEpsilon


Alias for raErr


x
decErrdoubleERRORarcsecDec errordecErrstat.errorx
x
decEpsilon


Alias for decErr


x
posSourceunsignedByteID_CATALOG
Object coordinates sourceposSourcemeta.id;meta.datasetx
x
rapmfloatPOS_EQ_PMRAmas/yearRA proper motionrapmpos.pm;pos.eq.raxcx
decpmfloatPOS_EQ_PMDECmas/yearDec proper motiondecpmpos.pm;pos.eq.decxcx
rapmErrfloatERRORmas/yearRA pm errorrapmErrstat.errorxcx
decpmErrfloatERRORmas/yearDec pm errordecpmErrstat.errorxcx
deltaEpochfloatTIME_INTERVALyearTime interval used for PM computationdeltaEpochtime.intervalxcx
pmSourceunsignedByteID_CATALOG
Proper motion sourcepmSourcemeta.id;meta.datasetx
x
parallaxdoublePOS_PARLX_TRIGmasParallaxparallaxpos.parallax.trigx
x
plxErrdoubleERRORmasParallax errorplxErrstat.errorx
x
plxSourceunsignedByteID_CATALOG
Parallax sourceplxSourcemeta.id;meta.datasetx
x
radialVelocityfloatVELOCITY_HCkm/sRadial velocityradialVelocityspect.dopplerVelocityx
x
rvErrfloatERRORkm/sRadial velocity errorrvErrstat.errorx
x
rvSourceunsignedByteID_CATALOG
Radial velocity sourcervSourcemeta.id;meta.datasetx
x
classificationintCLASS_OBJECT
Object classification codeclassificationmeta.code.classx
x
class


Alias for classification


x
classSourceintID_CATALOG
Classification sourceclassSourcemeta.id;meta.datasetx
x
variableFlagcharCODE_VARIAB
Flag for known variablevariableFlagmeta.code.statusxxx
varSourceunsignedByteID_CATALOG
Variability sourcevarSourcemeta.id;meta.datasetx
x
multipleFlagcharCODE_MULT_FLAGFlag for known multiplemultipleFlagmeta.code.classxxx
multSourceunsignedByteID_CATALOG
Multiplicity sourcemultSourcemeta.id;meta.datasetx
x
gaiaGmagdoublePHOT_MAGmagGaia G band magnitudegaiaGmagphot.mag;em.optx
x
gaiaGmagErrfloatERRORmagGaia G band magnitude errorgaiaGmagErrstat.errorx
x
gaiaGmagCodeunsignedBytePHOT_SYS-ID
Gaia G band codegaiaGmagCodemeta.codex
x
OpgMagfloatPHOT_PHG_BmagPhotographic O band magnitudeOpgMagphot.mag;em.opt.Bx
x
OpgMagErrfloatERRORmagPhotographic O band magnitude errorOpgMagErrstat.errorx
x
OpgMagCodeunsignedBytePHOT_SYS-ID
Photographic O band codeOpgMagCodemeta.codex
x
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.Vx
x
VpgMagErrfloatERRORmagPhotographic V band magnitude errorVpgMagErrstat.errorx
x
VpgMagCodeunsignedBytePHOT_SYS-ID
Photographic V band codeVpgMagCodemeta.codex
x
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.Rx
x
EpgMagErrfloatERRORmagPhotographic E band magnitude errorEpgMagErrstat.errorx
x
EpgMagCodeunsignedBytePHOT_SYS-ID
Photographic E band codeEpgMagCodemeta.codex
x
NpgMagfloatPHOT_PHG_ImagPhotographic Near-IR magnitudeNpgMagphot.mag;em.opt.Ix
x
Nmag


Alias for NpgMag


x
NpgMagErrfloatERRORmagPhotographic Near-IR magnitude errorNpgMagErrstat.errorx
x
NmagErr


Alias ffor NpgMagErr


x
NpgMagCodeintPHOT_SYS-ID
Photographic Near-IR bandpass codeNpgMagCodemeta.codex
x
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.Ux
x
SDSSuMagErrfloatERRORmagSDSS u band magnitude errorSDSSuMagErrstat.errorx
x
SDSSuMagCodeunsignedBytePHOT_SYS-ID
SDSS u band codeSDSSuMagCodemeta.codex
x
SDSSuMagSourceunsignedByteID_CATALOG
SDSS u band magnitude sourceSDSSuMagSourcemeta.id;meta.datasetx

SDSSgMagfloatPHOT_SDSS_GmagSDSS g band magnitudeSDSSgMagphot.mag;em.opt.Bx
x
SDSSgMagErrfloatERRORmagSDSS g band magnitude errorSDSSgMagErrstat.errorx
x
SDSSgMagCodeintPHOT_SYS-ID
SDSS g band codeSDSSgMagCodemeta.codex
x
SDSSgMagSourceintID_CATALOG
SDSS g band magnitude sourceSDSSgMagSourcemeta.id;meta.datasetx

SDSSrMagfloatPHOT_SDSS_RmagSDSS r band magnitudeSDSSrMagphot.mag;em.opt.Rx
x
SDSSrMagErrfloatERRORmagSDSS r band magnitude errorSDSSrMagErrstat.errorx
x
SDSSrMagCodeintPHOT_SYS-ID
SDSS r band codeSDSSrMagCodemeta.codex
x
SDSSrMagSourceintID_CATALOG
SDSS r band magnitude sourceSDSSrMagSourcemeta.id;meta.datasetx

SDSSiMagfloatPHOT_SDSS_ImagSDSS i band magnitudeSDSSiMagphot.mag;em.opt.Ix
x
SDSSiMagErrfloatERRORmagSDSS i band magnitude errorSDSSiMagErrstat.errorx
x
SDSSiMagCodeintPHOT_SYS-ID
SDSS i band codeSDSSiMagCodemeta.codex
x
SDSSiMagSourceintID_CATALOG
SDSS i band magnitude sourceSDSSiMagSourcemeta.id;meta.datasetx

SDSSzMagfloatPHOT_SDSS_ZmagSDSS z band magnitudeSDSSzMagphot.mag;em.opt.Ix
x
SDSSzMagErrfloatERRORmagSDSS z band magnitude errorSDSSzMagErrstat.errorx
x
SDSSzMagCodeunsignedBytePHOT_SYS-ID
SDSS z band codeSDSSzMagCodemeta.codex
x
SDSSzMagSourceunsignedByteID_CATALOG
SDSS z band magnitude sourceSDSSzMagSourcemeta.id;meta.datasetx

PS1yMagfloatPHOT_MAGmagPanSTARRS y band magnitudePS1yMagphot.mag;em.IR.NIRx
x
PS1yMagErrfloatERRORmagPanSTARRS y band magnitude errorPS1yMagErrstat.errorx
x
PS1yMagCodeunsignedBytePHOT_SYS-ID
PanSTARRS y band codePS1yMagCodemeta.codex
x
PS1ymagSourceunsignedByteID_CATALOG
PanSTARRS y band magnitude sourcePS1ymagSourcemeta.id;meta.datasetx

tmassJmagdoublePHOT_MAG_Jmag2MASS J band magnitudetmassJmagphot.mag;em.IR.Jx
x
Jmag


Alias for tmassJmag


x
tmassJmagErrdoubleERRORmag2MASS J band magnitude errortmassJmagErrstat.errorx
x
JmagErr


Alias for tmassJmagErr


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


Alias for tmassJmageCode


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

tmassHmagdoublePHOT_MAG_Hmag2MASS H band magnitudetmassHmagphot.mag;em.IR.Hx
x
Hmag


Alias for tmassHmag


x
tmassHmagErrdoubleERRORmag2MASS H band magnitude errortmassHmagErrstat.errorx
x
HmagErr


Alias for tmassHmagErr


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


Alias for tmassHmagCode


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

tmassKsmagdoublePHOT_MAG_Kmag2MASS Ks band magnitudetmassKsmagphot.mag;em.IR.Kx
x
Kmag


Alias for tmassKsmag


x
tmassKsmagErrdoubleERRORmag2MASS Ks band magnitude errortmassKsmagErrstat.errorx
x
KmagErr


Alias for tmassKsmagErr


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


Alias for tmassKsmagCode


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

VistaZMagfloatPHOT_MAGmagVISTA Z band magnitudeVistaZMagphot.mag;em.IR.NIRx
x
VistaZMagErrfloatERRORmagVISTA Z band magnitude errorVistaZMagErrstat.errorx
x
VistaZMagCodeunsignedBytePHOT_SYS-ID
VISTA Z band codeVistaZMagCodemeta.codex
x
VistaZmagSourceunsignedByteID_CATALOG
VISTA Z band magnitude sourceVistaZmagSourcemeta.id;meta.datasetx

VistaYmagfloatPHOT_MAGmagVISTA Y band magnitudeVistaYmagphot.mag;em.IR.NIRx
x
VistaYMagErrfloatERRORmagVISTA Y band magnitude errorVistaYMagErrstat.errorx
x
VistaYMagCodeunsignedBytePHOT_SYS-ID
VISTA Y band codeVistaYMagCodemeta.codex
x
VistaYmagSourceunsignedByteID_CATALOG
VISTA Y band magnitude sourceVistaYmagSourcemeta.id;meta.datasetx

VistaKmagfloatPHOT_MAG_KmagVISTA K band magnitudeVistaKmagphot.mag;em.IR.Kx
x
VistaKMagErrfloatERRORmagVISTA K band magnitude errorVistaKMagErrstat.errorx
x
VistaKMagCodeunsignedBytePHOT_SYS-ID
VISTA K band codeVistaKMagCodemeta.codex
x
VistaKmagSourceunsignedByteID_CATALOG
VISTA K band magnitude sourceVistaKmagSourcemeta.id;meta.datasetx

WISEw1MagfloatPHOT_IR_3.4magWISE W1 (3.4um) band magnitudeWISEw1Magphot.mag;em.IR.3-4umx
x
WISEw1MagErrfloatERRORmagWISE W1 (3.4um) band magnitude errorWISEw1MagErrstat.errorx
x
WISEw1MagCodeunsignedBytePHOT_SYS-ID
WISE W1 (3.4um) band codeWISEw1MagCodemeta.codex
x
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-8umx
x
WISEw2MagErrfloatERRORmagWISE W2 (4.6um) band magnitude errorWISEw2MagErrstat.errorx
x
WISEw2MagCodeunsignedBytePHOT_SYS-ID
WISE W2 (4.6um) band codeWISEw2MagCodemeta.codex
x
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-15umx
x
WISEw3MagErrfloatERRORmagWISE W3 (12um) band magnitude errorWISEw3MagErrstat.errorx
x
WISEw3MagCodeunsignedBytePHOT_SYS-ID
WISE W3 (12um) band codeWISEw3MagCodemeta.codex
x
WISEw3MagSOurceunsignedByteID_CATALOG
WISE W3 (12um) band magnitude sourceWISEw3MagSOurcemeta.id;meta.datasetx

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

FUVmagfloatPHOT_MAG_UVmagGALEX FUV band magnitudeFUVmagphot.mag;em.UV.100-200nmx
x
FUVmagErrfloatERRORmagGALEX FUV band magnitude errorFUVmagErrstat.errorx
x
FUVmagCodeunsignedBytePHOT_SYS-ID
GALEX FUV band codeFUVmagCodemeta.codex
x
FUVmagSourceunsignedByteID_CATALOG
GALEX FUV band magnitude sourceFUVmagSourcemeta.id;meta.datasetx

NUVmagfloatPHOT_MAG_UVmagGALEX NUV band magnitudeNUVmagphot.mag;em.UVx
x
NUVmagErrfloatERRORmagGALEX NUV band magnitude errorNUVmagErrstat.errorx
x
NUVmagCodeunsignedBytePHOT_SYS-ID
GALEX NUV band codeNUVmagCodemeta.codex
x
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