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/A+A/615/A12
  24 nearby open clusters TGAS and HSOY reanalysis (Yen+, 2018)
ReadMe+ftp
2018A&A...615A..12Y
Similar Catalogs
[METAcat] [METAcells] [stats]
Post annotation 		img(gal)
1.J/A+A/615/A12/table1(c)List of derived parameters for 24 clusters (24 rows) (released 2018-09-25)
[METAtab] [METAcola]
2.J/A+A/615/A12/tablec(c)Membership lists for 24 clusters (5334 rows) (released 2018-09-25)
[METAtab] [METAcola]
Help Xmatch is

Simple ConstraintList Of Constraints
 
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. (meta.record)
   (ALL)Name (char) NGC, IC, or other common designation (meta.id)
  (1)MWSC  MWSC sequential number (meta.record)
  (1)RA_ICRS "h:m:s" (i) Right ascension (ICRS) (pos.eq.ra;meta.main)
  (1)DE_ICRS "d:m:s" (i) Declination (ICRS) (pos.eq.dec;meta.main)
   (ALL)pmRA mas/yr Mean TGAS proper motion in RA*cos(DE) (pos.pm;pos.eq.ra)
   (ALL)e_pmRA mas/yr Formal error of mean TGAS proper motion in RA*cos(DE) (stat.error;pos.pm;pos.eq.ra)
   (ALL)pmDE mas/yr Mean TGAS proper motion in DE (pos.pm;pos.eq.dec)
   (ALL)e_pmDE mas/yr Formal error of mean TGAS proper motion in DE (stat.error;pos.pm;pos.eq.dec)
   (ALL)plx mas Mean TGAS parallax (pos.parallax.trig)
   (ALL)e_plx mas Mean TGAS parallax error (stat.error;pos.parallax)

ALL cols		    
 (i)indexed column
  (1)logt [yr] Logarithm of age (time.age)
  (1)E_logt [yr] Upper error on logt (stat.error;stat.max)
  (1)e_logt [yr] Lower error on logt (stat.error)
  (1)E(B-V) mag Color-excess in (B-V) (phot.color;em.opt.B;em.opt.V)
  (1)e_E(B-V) mag Error of color-excess (stat.error)
  (1)d pc Distance from Sun (pos.distance;pos.heliocentric)
  (1)e_d pc Error of distance (stat.error)
  (1)Nt  Number of TGAS stars (meta.number)
  (1)Nh  Number of HSOY stars (meta.number)
  (1)Nhip  Number of Hipparcos stars (meta.number)
  (1)SimbadName (char) Designation understandable by the Simbad data-base (meta.id)
  (2)Tab (char) Table name (C1-C24) (meta.id;meta.table)
  (2)StarID  Gaia DR1 Source ID or Hipparcos identifier (meta.id;meta.main)

ALL cols		    
 (i)indexed column
  (2)RA_ICRS deg (i) Right ascension (ICRS) (pos.eq.ra;meta.main)
  (2)DE_ICRS deg (i) Declination (ICRS) (pos.eq.dec;meta.main)
  (2)Mass Msun Stellar mass (phys.mass)
  (2)Bmag mag (n) B magnitude in Johnson system (phot.mag;em.opt.B)
  (2)e_Bmag mag (n) Error of B magnitude (stat.error;phot.mag;em.opt.B)
  (2)Vmag mag (n) V magnitude in Johnson system (phot.mag;em.opt.V)
  (2)e_Vmag mag (n) Error of V magnitude (stat.error;phot.mag;em.opt.V)
  (2)Jmag mag (n) 2MASS J magnitude (phot.mag;em.IR.J)
  (2)e_Jmag mag (n) Error of J magnitude (stat.error;phot.mag;em.IR.J)
  (2)Hmag mag (n) 2MASS H magnitude (phot.mag;em.IR.H)
  (2)e_Hmag mag (n) Error of H magnitude (stat.error;phot.mag;em.IR.H)
  (2)Ksmag mag (n) 2MASS Ks magnitude (phot.mag;em.IR.K)
  (2)e_Ksmag mag (n) Error of Ks magnitude (stat.error;phot.mag;em.IR.K)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  (2)Gmag mag (n) Gaia G-band mean magnitude (phot.mag;em.opt.R)
  (2)Flag  Flag for catalog (Note 1)   (meta.code.error)

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  
.errorfile=/tmp/V-3.err (2025-04-05T18:26:33)
-3
-source=J/A+A/615/A12
-ref=VIZ67f175d98082
elapse time 0

Options: wopt=0, optS=0, onote=0, opt1=8, opos=0

Contents of error file (/tmp/V-3.err):
-rwxr-xr-x 1 root root 963656 Mar 12 13:03 /srv/httpd/bin/vizier
vizier -- Version 7.4.6
cgiprint -- version 9.68 (2016-01-16)
[1743877593]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=0 and  tabid=52 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, id From METAtime where catid=36150012 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, id From METAtime where catid=36150012 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select catid, morid, text From METAmor where catid=36150012 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=36150012 and  tabid=2 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=36150012 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, id From METAtime where catid=36150012 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, id From METAtime where catid=36150012 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=36150012 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36150012 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select idori, kwdid, name, explain From METAorigin
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name From METAucd where ucdid>=0
----db1_exec(0 'metaviz@VIZIR'):
[1743877593]    Update METAhit set etime=797192793,  Ncalls = Ncalls+1 where catid=36150012 and hstid=-1 and btime=796829400
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1743877593]    UPDATE METAstat set nlocal=nlocal+1, tlocal=797192793 Where phase=3 and catid=36150012
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1743877593]    Update METAhit set etime=797192793,  N2list = N2list+2 where catid=36150012 and hstid=-1 and btime=796829400
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1743877593]    Update METAhit set etime=797192793,  N2list = N2list+2 where catid=36150012 and hstid=-1 and btime=796829400
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1743877593]    UPDATE METAstat set nlocal=nlocal+1, tlocal=797192793 Where phase=3 and catid=36150012
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name From METAfam where famid>=0
....show_tuple: show_status = (45, 2, 0, 0, 0)
====Tuple 'J/A+A/615/A12' from 2/0 tables:
    #36150012.1 'J/A+A/615/A12/table1' 22/32 columns
    #36150012.2 'J/A+A/615/A12/tablec' 25/40 columns
[00000003] col#000 v000 OA002 J/A+A/615/A12/table1*recno           
[00000003] col#001 v004 O6043 J/A+A/615/A12/table1*Name            
[00000001] col#002 v000 O0043 J/A+A/615/A12/table1*MWSC            
[00000001] col#003 v311 O0023 J/A+A/615/A12/table1*RA_ICRS         
[00000001] col#004 v011 O0023 J/A+A/615/A12/table1*DE_ICRS         
[00000003] col#005 v001 O0023 J/A+A/615/A12/table1*pmRA            
[00000003] col#006 v001 O0043 J/A+A/615/A12/table1*e_pmRA          
[00000003] col#007 v001 O0023 J/A+A/615/A12/table1*pmDE            
[00000003] col#008 v001 O0043 J/A+A/615/A12/table1*e_pmDE          
[00000003] col#009 v001 O0043 J/A+A/615/A12/table1*plx             
[00000003] col#010 v001 O0043 J/A+A/615/A12/table1*e_plx           
[00000001] col#011 v001 O0043 J/A+A/615/A12/table1*logt            
[00000001] col#012 v001 O0043 J/A+A/615/A12/table1*E_logt          
[00000001] col#013 v001 O0043 J/A+A/615/A12/table1*e_logt          
[00000001] col#014 v001 O0043 J/A+A/615/A12/table1*E(B-V)          
[00000001] col#015 v001 O0043 J/A+A/615/A12/table1*e_E(B-V)        
[00000001] col#016 v001 O0043 J/A+A/615/A12/table1*d               
[00000001] col#017 v001 O0043 J/A+A/615/A12/table1*e_d             
[00000001] col#018 v000 O0043 J/A+A/615/A12/table1*Nt              
[00000001] col#019 v000 O0043 J/A+A/615/A12/table1*Nh              
[00000001] col#020 v000 O0043 J/A+A/615/A12/table1*Nhip            
[00000001] col#021 v044 OC043 J/A+A/615/A12/table1*SimbadName      
[00000003] col#000 v000 OA002 J/A+A/615/A12/tablec*recno           
[00000002] col#001 v004 O4003 J/A+A/615/A12/tablec*Tab             
[00000003] col#002 v004 O4043 J/A+A/615/A12/tablec*Name            
[00000002] col#003 v006 O2003 J/A+A/615/A12/tablec*StarID          
[00000002] col#004 v311 O2023 J/A+A/615/A12/tablec*RA_ICRS         
[00000002] col#005 v011 O2023 J/A+A/615/A12/tablec*DE_ICRS         
[00000003] col#006 v001 O2023 J/A+A/615/A12/tablec*pmRA            
[00000003] col#007 v001 O0043 J/A+A/615/A12/tablec*e_pmRA          
[00000003] col#008 v001 O2023 J/A+A/615/A12/tablec*pmDE            
[00000003] col#009 v001 O0043 J/A+A/615/A12/tablec*e_pmDE          
[00000003] col#010 v001 O00C3 J/A+A/615/A12/tablec*plx             
[00000003] col#011 v001 O00C3 J/A+A/615/A12/tablec*e_plx           
[00000002] col#012 v001 O0043 J/A+A/615/A12/tablec*Mass            
[00000002] col#013 v001 O00C3 J/A+A/615/A12/tablec*Bmag            
[00000002] col#014 v001 O00C3 J/A+A/615/A12/tablec*e_Bmag          
[00000002] col#015 v001 O00C3 J/A+A/615/A12/tablec*Vmag            
[00000002] col#016 v001 O00C3 J/A+A/615/A12/tablec*e_Vmag          
[00000002] col#017 v001 O00C3 J/A+A/615/A12/tablec*Jmag            
[00000002] col#018 v001 O00C3 J/A+A/615/A12/tablec*e_Jmag          
[00000002] col#019 v001 O00C3 J/A+A/615/A12/tablec*Hmag            
[00000002] col#020 v001 O00C3 J/A+A/615/A12/tablec*e_Hmag          
[00000002] col#021 v001 O00C3 J/A+A/615/A12/tablec*Ksmag           
[00000002] col#022 v001 O00C3 J/A+A/615/A12/tablec*e_Ksmag         
[00000002] col#023 v001 O00C3 J/A+A/615/A12/tablec*Gmag            
[00000002] col#024 v000 O0043 J/A+A/615/A12/tablec*Flag            

----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=184
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=264
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=1211
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=260
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=368
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=1360
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=101
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=434
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=236
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=257
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=1192
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=85
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=192
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=196
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=1025
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=682
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=716
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=693
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=928
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=689
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=742
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select ucdid, name, class, explain From METAucd where ucdid=64
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743877593]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/A+A/615/A12
     [u] -ref=VIZ67f175d98082
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@VIZIR')
→ Cite/acknowledge VizieR catalogue
→ Rules of usage of VizieR data

© Université de Strasbourg/CNRS

    • Contact