VizieR

CfA VizieR . ADAC VizieR . Cambridge (UK) VizieR . IUCAA VizieR . INASAN VizieR .

VizieR

Simple TargetList Of TargetsFast Xmatch with large catalogs or Simbad
Target Name (resolved by Sesame) or Position:
Target dimension:
NB: The epoch used for the query is the original epoch of the table(s)Radius Box size

  
J/ApJS/247/28
  K2 star parameters from Gaia & LAMOST (Hardegree-Ullman+, 2020)
Post annotation
img(gal)
1.J/ApJS/247/28/table1(c)K2 stellar parameters (244337 rows)
2.J/ApJS/247/28/table3(c)Refined K2 planet parameters (816 rows)
Help Xmatch is

 
Query by Constraints constraints help applied on Columns (Output Order: + - )
ShowSortJoin tables
more join
Column  Constraint Explain   (UCD)
  (ALL)recno  Record number assigned by the VizieR team. Should Not be used for identification. ((unassigned);phys.veloc.orbital;arith.diff;phys.veloc)
  (1)Np  (n)Number of planet measurements for this star (link to Table 3) ((unassigned);phys.veloc.orbital;arith.diff;src.var)
   (ALL)EPIC  (i) [201048855/251411166] EPIC identifier ((unassigned);(unassigned);(unassigned);spect.line.veloc;arith)
  (1)Camp   [1/18] K2 Campaigns (1 to 18; from 2014 May to July 2018) ((unassigned);phys.veloc.orbital;arith.diff;spect.line.veloc;stat.median)
  (1)PS  (n) Pan-STARRS objID ((unassigned);(unassigned);(unassigned);src.class.starGalaxy)
  (1)Gaia  Gaia DR2 identifier ((unassigned);(unassigned);(unassigned);src.class.starGalaxy)
  (1)LAMOST  (n) LAMOST ObsID ((unassigned);phys.veloc.orbital;arith.diff;src.class.starGalaxy)
  (1)gmag mag [8/22] Apparent g band magnitude (Note 1)   ((unassigned);(unassigned);(unassigned);stat.filling;(unassigned);(unassigned))
  (1)e_gmag mag [0/0.9] Uncertainty in gmag ((unassigned);(unassigned);(unassigned);time.age;stat.probability;(unassigned);(unassigned))
  (1)rmag mag [7.3/21] Apparent r band magnitude (Note 1)   ((unassigned);phys.veloc.orbital;arith.diff;stat.filling;(unassigned);(unassigned))
  (1)e_rmag mag [0/0.9] Uncertainty in rmag ((unassigned);(unassigned);(unassigned);time.age;stat.probability;(unassigned);(unassigned))

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)imag mag [6.4/19.1] Apparent i band magnitude (Note 1)   ((unassigned);(unassigned);(unassigned);stat.filling;(unassigned);(unassigned))
  (1)e_imag mag [0.001/0.9] Uncertainty in imag ((unassigned);(unassigned);(unassigned);time.age;stat.probability;(unassigned);(unassigned))
  (1)Jmag mag [4.3/17.4] 2MASS J band magnitude ((unassigned);(unassigned);(unassigned);stat.filling;(unassigned);(unassigned))
  (1)e_Jmag mag [0.01/0.4] Uncertainty in Jmag ((unassigned);(unassigned);(unassigned);time.age;stat.probability;(unassigned);(unassigned))
  (1)Hmag mag [3.4/16.8] 2MASS H band magnitude ((unassigned);(unassigned);(unassigned);stat.filling;(unassigned);(unassigned))
  (1)e_Hmag mag [0.005/0.4] Uncertainty in Hmag ((unassigned);(unassigned);(unassigned);time.age;stat.probability;(unassigned);(unassigned))
  (1)Ksmag mag [3.1/16.4] 2MASS Ks band magnitude ((unassigned);(unassigned);(unassigned);stat.filling;(unassigned);(unassigned))
  (1)e_Ksmag mag [0.01/0.6] Uncertainty in Ksmag ((unassigned);(unassigned);(unassigned);time.age;stat.probability;(unassigned);(unassigned))
  (1)Kpmag mag [7/20] Kepler band magnitude (Note 2)   ((unassigned);(unassigned);(unassigned);stat.filling;(unassigned);(unassigned))
  (1)e_Kpmag mag [0.001/1] Uncertainty in Kpmag ((unassigned);phys.veloc.orbital;arith.diff;time.age;stat.probability;(unassigned);(unassigned))
  (1)Dist pc [10.6/17713] Gaia DR2 based distance (Note 3)   ((unassigned);phys.veloc.orbital;arith.diff;em.UV.10-50nm;arith;meta.main)
  (1)E_Dist pc [0.01/5686] Upper uncertainty in Dist ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (1)e_Dist pc [0.01/4328] Lower uncertainty in Dist ((unassigned);(unassigned);(unassigned);time.age;meta.main)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)Ag   [0.001/12.7] Reddening in the g band (Note 4)   ((unassigned);(unassigned);(unassigned);phys.dust)
  (1)Ar   [0.001/9.3] Reddening in the r band (Note 4)   ((unassigned);phys.veloc.orbital;arith.diff;phys.dust)
  (1)Ai   [0.001/7] Reddening in the i band (Note 4)   ((unassigned);(unassigned);(unassigned);phys.dust)
  (1)AJ   [0/2.5] Reddening in the J band (Note 4)   ((unassigned);(unassigned);(unassigned);phys.dust)
  (1)AH   [0/1.3] Reddening in the H band (Note 4)   ((unassigned);phys.veloc.orbital;arith.diff;phys.dust)
  (1)AKs   [0/0.7] Reddening in the Ks band (Note 4)   ((unassigned);(unassigned);(unassigned);phys.dust)
  (1)gMag mag [-2.5/14.3] Absolute g band magnitude (Note 5)   ((unassigned);phys.veloc.orbital;arith.diff;(unassigned))
  (1)E_gMag mag [0.005/1.2] Upper uncertainty in gMag ((unassigned);phys.veloc.orbital;arith.diff;time.age;pos.phaseAng;meta.main)
  (1)e_gMag mag [0.005/1.2] Lower uncertainty in gMag ((unassigned);(unassigned);(unassigned);time.age;stat.probability)
  (1)rMag mag [-2.4/13.3] Absolute r band magnitude (Note 5)   ((unassigned);(unassigned);(unassigned);(unassigned))
  (1)E_rMag mag [0.006/1.2] Upper uncertainty in rMag ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (1)e_rMag mag [0.005/1.2] Lower uncertainty in rMag ((unassigned);(unassigned);(unassigned);time.age;stat.probability)
  (1)iMag mag [-2.9/12.1] Absolute i band magnitude (Note 5)   ((unassigned);(unassigned);(unassigned);(unassigned))

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)E_iMag mag [0.005/1.2] Upper uncertainty in iMag ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (1)e_iMag mag [0.005/1.2] Lower uncertainty in iMag ((unassigned);(unassigned);(unassigned);time.age;stat.probability)
  (1)JMag mag [-4.6/10.8] Absolute J band magnitude (Note 5)   ((unassigned);(unassigned);(unassigned);(unassigned);(unassigned);(unassigned))
  (1)E_JMag mag [0.01/0.9] Upper uncertainty in JMag ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (1)e_JMag mag [0.01/1.1] Lower uncertainty in JMag ((unassigned);(unassigned);(unassigned);time.age;stat.probability;(unassigned);(unassigned))
  (1)HMag mag [-5.4/10.6] Absolute H band magnitude (Note 5)   ((unassigned);(unassigned);(unassigned);(unassigned);(unassigned);(unassigned))
  (1)E_HMag mag [0.01/0.9] Upper uncertainty in HMag ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (1)e_HMag mag [0.01/1.2] Lower uncertainty in HMag ((unassigned);(unassigned);(unassigned);time.age;stat.probability;(unassigned);(unassigned))
  (1)KsMag mag [-5.6/10.5] Absolute Ks band magnitude (Note 5)   ((unassigned);(unassigned);(unassigned);(unassigned);(unassigned);(unassigned))
  (1)E_KsMag mag [0.01/0.9] Upper uncertainty in KsMag ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (1)e_KsMag mag [0.01/1.1] Lower uncertainty in KsMag ((unassigned);(unassigned);(unassigned);time.age;stat.probability;(unassigned);(unassigned))
   (ALL)SpT (char) Spectral Type (Note 6)   ((unassigned);(unassigned);(unassigned);pos.posAng;meta.main)
   (ALL)Teff K [3130/8498] Effective surface temperature (Note 6)   ((unassigned);(unassigned);(unassigned);em.radio)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)e_Teff K [3/596] Uncertainty in Teff ((unassigned);(unassigned);(unassigned);time.age;em.radio.20-100MHz)
  (1)logg [cm/s2] [0.3/5.6] log of surface gravity (Note 6)   ((unassigned);(unassigned);(unassigned);(unassigned))
  (1)E_logg [cm/s2] [0.002/1] Upper uncertainty in logg ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (1)e_logg [cm/s2] [0.002/1] Lower uncertainty in logg ((unassigned);(unassigned);(unassigned);time.age;meta.main)
  (1)[Fe/H] [-] [-2.5/0.7] Metallicity (Note 6)   ((unassigned);(unassigned);(unassigned);pos.emergenceAng)
  (1)e_[Fe/H] [-] [0.003/0.6] Uncertainty in [Fe/H] ((unassigned);(unassigned);(unassigned);time.age;phys.reflectance.bidirectional)
   (ALL)Rstar Rsun [0.03/77] Stellar radius, solar units (Note 7)   ((unassigned);(unassigned);(unassigned);stat.fit.residual;(unassigned))
   (ALL)E_Rstar Rsun [0.001/35] Upper uncertainty in Rstar ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
   (ALL)e_Rstar Rsun [0.001/22] Lower uncertainty in Rstar ((unassigned);(unassigned);(unassigned);time.age;meta.main)
   (ALL)Mstar Msun [-0.8/979] Stellar mass, solar units (Note 7)   ((unassigned);(unassigned);(unassigned);stat.fit.residual;(unassigned))
   (ALL)E_Mstar Msun [0/320] Upper uncertainty in Mstar ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
   (ALL)e_Mstar Msun [0/233] Lower uncertainty in Mstar ((unassigned);(unassigned);(unassigned);time.age;meta.main)
  (1)2M (char) Display the 2MASS data (Cutri+ 2003, II/246) within 3" ((unassigned);(unassigned);(unassigned);pos.geocentric)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
   (ALL)_RA deg (i) Positions (J2000) from Gaia (I/345) (right ascension part) ((unassigned);(unassigned);(unassigned);(unassigned);arith)
   (ALL)_DE deg (i) Positions (J2000) from Gaia (I/345) (declination part) ((unassigned);(unassigned);(unassigned);(unassigned);arith)
  (2)ID  Planet candidate ID ((unassigned);(unassigned);(unassigned);spect.line.veloc;arith)
  (2)Planet (char) Confirmed Planet Name ((unassigned);(unassigned);(unassigned);spect.line.veloc)
  (2)Rp/R*   [0.006/0.8] Ratio, Planet/Star radius ((unassigned);(unassigned);(unassigned);(unassigned);instr.offset)
  (2)E_Rp/R*   [0.0002/0.4] Upper uncertainty in Rp/R* ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (2)e_Rp/R*   [0.0004/0.2] Lower uncertainty in Rp/R* ((unassigned);(unassigned);(unassigned);time.age;meta.main)
  (2)Per d [0.17/80] Period ((unassigned);(unassigned);(unassigned);phys.dust;meta.main)
  (2)E_Per d [6.3e-7/70] Upper uncertainty in Per ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (2)e_Per d [6.3e-7/20] Lower uncertainty in Per ((unassigned);(unassigned);(unassigned);time.age;meta.main)
  (2)r_Per   [1/7] Reference for period and Rp/R* (Note 1)   ((unassigned);(unassigned);(unassigned);phys.veloc.dispersion;(unassigned))
  (2)E_Teff K [11/138] Uncertainty in Teff ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (2)Lstar Lsun [0.01/833] Stellar luminosity ((unassigned);(unassigned);(unassigned);(unassigned))

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (2)E_Lstar Lsun [0.002/750] Upper uncertainty in Lstar ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (2)e_Lstar Lsun [0.002/485] Lower uncertainty in Lstar ((unassigned);(unassigned);(unassigned);time.age;meta.main)
  (2)a au [0.005/0.4] Planet, semi-major axis ((unassigned);(unassigned);(unassigned);(unassigned);pos.az.zd;meta.main)
  (2)E_a au [4e-5/0.2] Upper uncertainty in a ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (2)e_a au [4.2e-5/0.08] Lower uncertainty in a ((unassigned);(unassigned);(unassigned);time.age;meta.main)
  (2)Fp Earth [0.7/3593074] Ratio of incident flux relative to Earth incident flux ((unassigned);(unassigned);(unassigned);meta.abstract;instr.offset)
  (2)E_Fp Earth [0.1/4551392] Upper uncertainty in Fp ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (2)e_Fp Earth [0.1/2136602] Lower uncertainty in Fp ((unassigned);(unassigned);(unassigned);time.age;meta.main)
  (2)Rp Rgeo [0.6/823] Planet radius, Earth units ((unassigned);(unassigned);(unassigned);(unassigned))
  (2)E_Rp Rgeo [0.04/927] Upper uncertainty in Rp ((unassigned);(unassigned);(unassigned);time.age;pos.phaseAng;meta.main)
  (2)e_Rp Rgeo [0.06/481] Lower uncertainty in Rp ((unassigned);(unassigned);(unassigned);time.age;meta.main)
  (2)PCat  (n)Display data from Crossfield+, 2016, J/ApJS/226/7 ; Kruse+, 2019, J/ApJS/244/11 and Mayo+, 2018, J/AJ/155/136 within 3" ((unassigned);(unassigned);(unassigned);pos.geocentric)
  (2)Simbad (char) ask the Simbad data-base about this object ((unassigned);(unassigned);(unassigned);pos.geocentric)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
Adapt form
Display your selection only Reset to default columns
usage  Display UCD1+    UCD1  


The following problems were encountered in this VizieR run:
****Error execute query: UPDATE METAstat set nother=nother+1, tother=846427595 Where phase=3 and catid=22470028
**** 
**** --POSTGRES MSG db=0
**** Report from: stdb_pg,     Status: STDB_ERR 
****ERROR:  invalid page in block 0 of relation base/16403/6104 
****ERROR:  invalid page in block 0 of relation base/16403/6104 
****Error execute query: UPDATE METAstat set nother=nother+1, tother=846427595 Where phase=3 and catid=22470028
**** 
**** --POSTGRES MSG db=0
**** Report from: stdb_pg,     Status: STDB_ERR 
****ERROR:  invalid page in block 0 of relation base/16403/6104 
****ERROR:  invalid page in block 0 of relation base/16403/6104 
If you can't find a solution, report to CDS and insert into your message the following details:

.errorfile=/tmp/VR3473458.err (2026-10-27T14:46:32)
-3
-source=J/ApJS/247/28
-ref=VIZ6ae0b94a350032
elapse time 3