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/MNRAS/462/3616
  Gaia SPSS variability monitoring (Marinoni+, 2016)
timeSerie
Post annotation
img(gal)
1.J/MNRAS/462/3616/table3(c)Results of the SPSS short-term constancy monitoring campaigns (162 rows) (released 2024-08-16)
[METAtab] [METAcola]
2.J/MNRAS/462/3616/table2Best light curves for the 162 monitored SPSS (9377 rows) (released 2024-08-16)
[METAtab] [METAcola]

 
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)LC (char) Show the light curves (meta.ref.url)
   (ALL)SPSSid  (i) [1/355] The SPSS id (meta.id)
   (ALL)StarName (char) The SPSS name (meta.id;meta.main)
  (1)RAJ2000 "h:m:s" (i) Right Ascension (J2000) (pos.eq.ra;meta.main)
  (1)DEJ2000 "d:m:s" (i) Declination (J2000) (pos.eq.dec;meta.main)
  (1)SpType (char) Spectral Type (src.spType)
   (ALL)Inst (char) The instrument used (instr.setup)
   (ALL)Band (char) [BVg] The photometric band used (instr.bandpass)
  (1)SkyQual (char) Sky quality (meta.code.qual)
  (1)l_Amp (char) [<≥ ] Limit flag on Amp (Note 1)   (meta.code.error)

ALL cols
    
 (i)indexed column
  (1)Amp mag Amplitude (Note 2)   (phot.mag)
  (1)SigPrec mag Precision of the light curve (meta.code.qual)
  (1)CompStars  Number of comparison stars (meta.number)
  (1)Verdict (char) Verdict, Accepted or Rejected (Note 3)   (meta.code)
  (1)Notes (char) Additional comments (meta.note)
  (1)SimbadName (char) Designation understandable by the Simbad data-base (meta.id)
  (2)HJD d Heliocentric Julian Day (time.epoch;pos.heliocentric)
  (2)Dm mag The magnitude difference of each point with respect to the average magnitude of comparison stars (phot.mag;arith.diff)
  (2)dm mag The errors of individual epoch measures for the SPSS (stat.error)

ALL cols
    
 (i)indexed column
Adapt form
Display your selection only Reset to default columns
usage  Display UCD1+    UCD1  
.errorfile=/tmp/V-3.err (2025-04-07T21:44:58)
-3
-source=J/MNRAS/462/3616
-ref=VIZ67f4475acf73e
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)
[1744062298]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAkwdef' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   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=11 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAfilter'
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAsed'
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 146/0 tuples [tested=146]
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=74222302 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74222302 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=74222302 order by catid,tabid,colid
--db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select idori, kwdid, name, explain From METAorigin
----db1_exec(0 'metaviz@VIZIR'):
[1744062298]    Update METAhit set etime=797377498,  Ncalls = Ncalls+1 where catid=74821690 and hstid=-1 and btime=796829400
------------(0 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1744062298]    Insert into METAhit (catid, hstid, btime, etime, Ncalls, N2list) VALUES (74821690,-1,796829400,797377498, 1,0)
[1744062298]   Select famid, name, explain From METAfam where famid=319
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=68
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=64
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=103
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=1385
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=313
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=257
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=5
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=462
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744062298]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/MNRAS/462/3616
     [u] -ref=VIZ67f4475acf73e
====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