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/94/749
  RI photometry of cool dwarfs (Kirkpatrick+ 1994)
Post annotation
img(gal)
1.J/ApJS/94/749/table1(c)CTI objects observed spectroscopically (133 rows) (released 2013-03-06)
[METAtab] [METAcola]
2.J/ApJS/94/749/table5(c)Stars from the NLTT catalog (Cat. I/98) that should be in the CTI strip (60 rows) (released 2013-03-06)
[METAtab] [METAcola]
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. (meta.record)
   (ALL)CTI (char) (i) CTI name (meta.id;meta.main)
   (ALL)n_CTI (char) [AB:+] Note on CTI (Note 1)   (meta.note)
  (1)RA1950 "h:m:s" (i) Right ascension (1950) (pos.eq.ra;meta.main)
  (1)DE1950 "d:m:s" (i) Declination (1950) (pos.eq.dec;meta.main)
   (ALL)Rmag mag (n) CTI R magnitude (phot.mag;em.opt.R)
  (1)u_Rmag (char) Uncertainty flag on Rmag (meta.code.error)
   (ALL)R-I mag (n) CTI (R-I) colour index (phot.color;em.opt.R;em.opt.I)
   (ALL)e_R-I mag (n) rms uncertainty on R-I (stat.error;phot.color;em.opt.R)
  (1)u_R-I (char) Uncertainty flag on R-I (meta.code.error;phot.color;em.opt.R)
  (1)V-I mag (n) CTI (V-I) colour index (phot.color;em.opt.V;em.opt.I)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)e_V-I mag (n) rms uncertainty on V-I (stat.error;phot.color;em.opt.V)
  (1)u_V-I (char) Uncertainty flag on V-I (meta.code.error;phot.color;em.opt.V)
  (1)SpType (char) Spectral type (src.spType)
  (1)Date "Y:M:D" (n)Observation date (UT) (time.epoch;obs)
  (1)Date2 (char) Second day when there is an interval (meta.note)
  (1)Int s Integration time (time.epoch)
   (ALL)_RA.icrs "h:m:s" (n)(i) Right ascension (ICRS) (computed by VizieR, not part of the original data) (pos.eq.ra)
   (ALL)_DE.icrs "d:m:s" (n)(i) Declination (ICRS) (computed by VizieR, not part of the original data) (pos.eq.dec)
  (2)Name (char) Object name (meta.id;meta.main)
  (2)mr mag Red magnitude (Note 1)   (phot.mag;em.opt.R)
  (2)mpg mag Photographic magnitude (Note 1)   (phot.mag;em.opt)
  (2)col (char) Luyten's color class (src.class.color)
  (2)pm arcsec/yrTotal proper motion (pos.pm)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (2)RA1987 "h:m:s" (i) Right ascension (1987.5) (Note 2)   (pos.eq.ra;meta.main)
  (2)DE1987 "d:m:s" (i) Declination (1987.5) (2) (pos.eq.dec;meta.main)
  (2)l_Rmag (char) Limit flag on Rmag (meta.code.error)
  (2)n_Rmag (char) [V] V: CTI V magnitude in Rmag column (meta.note)
  (2)Note (char) Notes (meta.note)

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-08-24T14:49:55)
-3
-source=J/ApJS/94/749
-ref=VIZ68ab26946645c
elapse time 1

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 963736 Jun 11 08:12 /srv/httpd/bin/vizier
vizier -- Version 7.5.1
cgiprint -- version 9.68 (2016-01-16)
----db1_exec(0 'metaviz@VIZIR'):
[1756046996]    UPDATE METAstat set nlocal=nlocal+1, tlocal=809362196 Where phase=3 and catid=20940749
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1756046996]    Update METAhit set etime=809362196,  N2list = N2list+2 where catid=20940749 and hstid=-1 and btime=807348600
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1756046996]    Update METAhit set etime=809362196,  N2list = N2list+2 where catid=20940749 and hstid=-1 and btime=807348600
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1756046996]    UPDATE METAstat set nlocal=nlocal+1, tlocal=809362196 Where phase=3 and catid=20940749
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select famid, name From METAfam where famid>=0
....show_tuple: show_status = (20, 17, 0, 0, 0)
====Tuple 'J/ApJS/94/749' from 2/0 tables:
    #20940749.1 'J/ApJS/94/749/table1' 19/32 columns
    #20940749.2 'J/ApJS/94/749/table5' 18/32 columns
[00000003] col#000 v000 OA002 J/ApJS/94/749/table1*recno           
[80000003] col#001 v004 O6C03 J/ApJS/94/749/table1*CTI             
[00000003] col#002 v004 O4000 J/ApJS/94/749/table1*n_CTI           
[00000001] col#003 v311 O0023 J/ApJS/94/749/table1*RA1950          
[00000001] col#004 v011 O0023 J/ApJS/94/749/table1*DE1950          
[00000003] col#005 v001 O00C3 J/ApJS/94/749/table1*Rmag            
[00000001] col#006 v004 O4000 J/ApJS/94/749/table1*u_Rmag          
[00000003] col#007 v001 O00C3 J/ApJS/94/749/table1*R-I             
[00000003] col#008 v001 O00C0 J/ApJS/94/749/table1*e_R-I           
[00000001] col#009 v004 O4000 J/ApJS/94/749/table1*u_R-I           
[00000001] col#010 v001 O00C0 J/ApJS/94/749/table1*V-I             
[00000001] col#011 v001 O00C0 J/ApJS/94/749/table1*e_V-I           
[00000001] col#012 v004 O4000 J/ApJS/94/749/table1*u_V-I           
[00000001] col#013 v004 O4003 J/ApJS/94/749/table1*SpType          
[00000001] col#014 v020 O0083 J/ApJS/94/749/table1*Date            
[00000001] col#015 v004 O4000 J/ApJS/94/749/table1*Date2           
[00000001] col#016 v000 O0040 J/ApJS/94/749/table1*Int             
[00000003] col#017 v311 O9083 J/ApJS/94/749/table1*_RA.icrs        
[00000003] col#018 v011 O9083 J/ApJS/94/749/table1*_DE.icrs        
[00000003] col#000 v000 OA002 J/ApJS/94/749/table5*recno           
[00000002] col#001 v004 O4043 J/ApJS/94/749/table5*Name            
[00000002] col#002 v001 O0043 J/ApJS/94/749/table5*mr              
[00000002] col#003 v001 O0040 J/ApJS/94/749/table5*mpg             
[00000002] col#004 v004 O4003 J/ApJS/94/749/table5*col             
[00000002] col#005 v001 O0003 J/ApJS/94/749/table5*pm              
[00000002] col#006 v311 O0023 J/ApJS/94/749/table5*RA1987          
[00000002] col#007 v011 O0023 J/ApJS/94/749/table5*DE1987          
[80000003] col#008 v004 O6C03 J/ApJS/94/749/table5*CTI             
[00000003] col#009 v004 O4000 J/ApJS/94/749/table5*n_CTI           
[00000002] col#010 v004 O4000 J/ApJS/94/749/table5*l_Rmag          
[00000003] col#011 v001 O00C0 J/ApJS/94/749/table5*Rmag            
[00000002] col#012 v004 O4000 J/ApJS/94/749/table5*n_Rmag          
[00000003] col#013 v001 O00C3 J/ApJS/94/749/table5*R-I             
[00000003] col#014 v001 O00C0 J/ApJS/94/749/table5*e_R-I           
[00000002] col#015 v004 O4003 J/ApJS/94/749/table5*Note            
[00000003] col#016 v311 O9083 J/ApJS/94/749/table5*_RA.icrs        
[00000003] col#017 v011 O9083 J/ApJS/94/749/table5*_DE.icrs        

----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select famid, name, explain From METAfam where famid=313
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=64
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=101
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=323
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=90
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=930
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=300
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756046996]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/ApJS/94/749
     [u] -ref=VIZ68ab26946645c
====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