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

  
I/298
  LSPM-North Catalog (Lepine+ 2005)
ReadMe+ftp
2005AJ....129.1483L
Similar Catalogs
[METAcat] [METAcells] [stats]
Post annotation 		img(gal)
1.I/298/lspm_n(c)The LSPM catalog (north) (61977 rows) (released 2005-07-19)
[METAtab] [METAcola]
2.I/298/table3(c)NLTT stars not listed in the LSPM catalog (1859 rows) (released 2005-07-19)
[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)
  (1)LSPM (char) LSPM star name (Note 1)   
  (1)LHS (char) LHS catalogue (I/87) identification
   (ALL)NLTT  (n) NLTT catalogue (I/98) identification (Note 2)   
  (1)HIP  (n) Hipparcos catalog (I/239) identification
  (1)TYC1  (n) Tycho-2 catalog (I/259) identification
  (1)TYC2  (n) Tycho-2 catalog (I/259) identification
  (1)TYC3  (n) Tycho-2 catalog (I/259) identification
  (1)ASCC2.5  (n) ASCC2.5 catalog (I/280) identification
  (1)UCAC2  (n) UCAC2 catalog (I/289) identification
  (1)OName (char) Original name in astronomical literature (Note 3)   

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)2MASS (char) 2MASS catalog (II/246) identification
  (1)USNO-B1 (char) USNO-B1.0 catalog (I/284) identification
   (ALL)RAJ2000 deg (i) Right Ascension in degrees (J2000, Ep=J2000) (pos.eq.ra;meta.main)
   (ALL)DEJ2000 deg (i) Declination in degrees (J2000, Ep=J2000) (pos.eq.dec;meta.main)
  (1)rPM arcsec/yrTotal relative Proper Motion (Note 4)   
  (1)rPMRA arcsec/yrRelative proper Motion in Right Ascension (Note 4)   
  (1)rPMDE arcsec/yrRelative Proper Motion in Declination (Note 4)   
   (ALL)pm arcsec/yrTotal Proper Motion (Note 5)   
   (ALL)pmRA arcsec/yrProper Motion in Right Ascension (Note 5)   
   (ALL)pmDE arcsec/yrProper Motion in Declination (Note 5)   
  (1)Aflag (char) [ASTO ] Astrometric Flag (Note 6)   
  (1)Bmag mag (n) Optical B magnitude (Note 7)   
  (1)Vmag mag (n) Optical V magnitude (Note 7)   

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)BJmag mag (n) Photographic Blue (IIIaJ) magnitude (Note 8)   
  (1)RFmag mag (n) Photographic Red (IIIaF) magnitude (Note 8)   
  (1)INmag mag (n) Photographic Infrared (IVN) mag. (Note 8)   
  (1)Jmag mag (n) Infrared J magnitude (Note 9)   
  (1)Hmag mag (n) Infrared H magnitude (Note 9)   
  (1)Kmag mag (n) Infrared Ks magnitude (Note 9)   
  (1)Vemag mag (n) Estimated V magnitude (Note 10)   
  (1)V-J mag (n) Estimated V-J color (Note 10)   
  (2)RALdeg deg Right Ascension in degrees (J2000) in the NLTT catalog
  (2)DELdeg deg Declination in degrees (J2000) in the NLTT catalog
  (2)rmag mag Red magnitude in the NLTT catalog
  (2)bmag mag Photographic blue magnitude in NLTT catalog
  (2)pmL arcsec/yrProper motion in NLTT catalog

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  (2)pmLPA deg Proper motion angle in NLTT catalog
  (2)why (char) [BDLNST] Explicative flag (Note 2)   

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-24T11:05:13)
-3
-source=I/298
-ref=VIZ68aaf1e92ac09
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
[1756033514]   select login from METAdba where dbaid=35
----db1_reset(0 'metaviz@VIZIR')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZIR'):
[1756033514]    insert into T1 values(5126)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@VIZIR'):
[1756033514]    insert into T2 values(5126)
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   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
-db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   Select famid, name, explain From METAfam where famid=693
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   Select famid, name, explain From METAfam where famid=689
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   Select famid, name, explain From METAfam where famid=719
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   Select famid, name, explain From METAfam where famid=742
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   Select famid, name, explain From METAfam where famid=1220
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756033514]   Select famid, name, explain From METAfam where famid=313
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=I/298
     [u] -ref=VIZ68aaf1e92ac09
====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