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/240/19
  Parallaxes of late-T and Y dwarfs (Kirkpatrick+, 2019)
ReadMe+ftp
2019ApJS..240...19K
Similar Catalogs
[METAcat] [METAcells] [stats]
Post annotation 		img(gal)
1.J/ApJS/240/19/table13The 20pc census of L0 to L5.5 dwarfs (91 rows) (released 2022-09-19)
[METAtab] [METAcola]

Simple ConstraintList Of Constraints
 
Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
ShowSortColumn  Constraint Explain   (UCD)
  recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
  Name (char) Discovery name of the source (meta.id;meta.main)
  f_Name (char) [b] Flag on Name (meta.code)
  OID (char) Other designation (meta.id)
  r_Name (char) Reference on Name (see refs.dat file) (meta.ref;pos.frame)
  plx mas [50.02/135.24] Adopted parallax (pos.parallax.trig)
  e_plx mas (n) [0.06/3.1] Parallax uncertainty (stat.error;pos.parallax)
  r_plx   [1/377] Reference on plx (see refs.dat file) (meta.ref;pos.frame)
  SpTopt (char) Optical spectral type (src.spType)
  r_SpTopt  (n) [303/375] Reference on SpTopt (see refs.dat file) (meta.ref;pos.frame)
  SpTnir (char) NIR spectral type (src.spType)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  r_SpTnir (char) Reference on SpTnir (see refs.dat file) (meta.ref;pos.frame)
  GLON deg Approximate Galactic longitude (pos.galactic.lon)
  GLAT deg Approximate Galactic latitude (pos.galactic.lat)
  SpT (char) Final adopted spectral type (src.spType)
  Teff1 K (n) [1500/1950] Effective temperature (lower range) (Note 1)   (phys.temperature.effective)
  Teff2 K (n) [1650/2100] Effective temperature (upper range) (Note 1)   (phys.temperature.effective)
  SimbadName (char) (n)Designation understandable by the Simbad data-base (meta.id)
  _RA.icrs deg (n)(i) Right Ascension (ICRS, epoch 2000) computed by CDS (pos.eq.ra)
  _DE.icrs deg (n)(i) Declination (ICRS, epoch 2000) computed by CDS (pos.eq.dec)

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-06T08:33:39)
-3
-source=J/ApJS/240/19/table13
-ref=VIZ67f23c644c757
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 963656 Mar 12 13:03 /srv/httpd/bin/vizier
vizier -- Version 7.4.6
cgiprint -- version 9.68 (2016-01-16)
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   select login from METAdba where dbaid=41
----db1_reset(0 'metaviz@VIZIR')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZIR'):
[1743928420]    insert into T1 values(35300147)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@VIZIR'):
[1743928420]    insert into T2 values(35300147)
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   select k.catid,k.kwdid from METAkwd k,T2 t where k.catid=t.id and ((-1*kwdid)<(select min(kwdno_min*1) from METAkwcat where name in ('Astronomy')) or  (-1*kwdid)>(select max(kwdno_max*1) from METAkwcat where name in ('Astronomy'))) order by catid
query(0 'metaviz@VIZIR'):
[1743928420]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=18670109 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select catid, morid, text From METAmor where catid=18670109 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=18670109 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=4
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=222 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=222 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=18670109 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=18670109 and tabid=3
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=18670109 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=18670109 and tabid=1
[1743928420]   Select ucdid, name, class, explain From METAucd where ucdid=256
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select famid, name, explain From METAfam where famid=1172
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select ucdid, name, class, explain From METAucd where ucdid=255
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select famid, name, explain From METAfam where famid=1171
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select ucdid, name, class, explain From METAucd where ucdid=225
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select famid, name, explain From METAfam where famid=1070
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743928420]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/ApJS/240/19/table13
     [u] -ref=VIZ67f23c644c757
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@VIZIR')
----db1_close(1 'metaviz@VIZIR')
→ Cite/acknowledge VizieR catalogue
→ Rules of usage of VizieR data

© Université de Strasbourg/CNRS

    • Contact