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/254/11
  The Spitzer Kepler Survey (SpiKeS) catalog (Werner+, 2021)
Post annotation
img(gal)
1.J/ApJS/254/11/spikesThe Spitzer Kepler Survey (SpiKeS) catalog (191984 rows) (released 2022-01-17)
[METAtab] [METAcola]

 
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)
  KIC   [757076/1.3e+7] KIC identifier (meta.id;meta.main)
  KOI  (n) [1.01/8297.01] Kepler object of interest ID (meta.id.assoc)
  Kepler (char) Kepler planet name (meta.id.assoc)
  RAJ2000 deg (i) [279.62/301.83] KIC right ascension (J2000) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) [36.5/52.5] KIC declination (J2000) (pos.eq.dec;meta.main)
  F3.6 mJy (n) [0.036/411.4] Spitzer/IRAC 3.6um flux density (phot.mag;em.IR.3-4um)
  e_F3.6 mJy (n) [0.0008/7.5] F3.6 uncertainty (stat.error)
  3.6mag mag (n) [7/17.22] Spitzer/IRAC 3.6um magnitude (phot.mag;em.IR.3-4um)
  e_3.6mag mag (n) [0.015/0.024] 3.6mag uncertainty (stat.error)
  o_F3.6  (n) [1/10] Number of IRAC 3.6um observations (meta.number)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  F4.5 mJy (n) [0.017/980.4] Spitzer/IRAC 4.5um flux density (phot.mag;em.IR.4-8um)
  e_F4.5 mJy (n) [0.00048/15.7] F4.5 uncertainty (stat.error)
  4.5mag mag (n) [5.6/17.6] Spitzer/IRAC 4.5um magnitude (phot.mag;em.IR.4-8um)
  e_4.5mag mag (n) [0.01/0.03] 4.5mag uncertainty (stat.error)
  o_F4.5  (n) [1/9] Number of IRAC 4.5um observations (meta.number)
  Flags (char) Flags from SpiKeS (Note 1)   (meta.code.error)
  Kpmag mag (n) [5/20.8] Kepler-band magnitude (phot.mag;em.opt)
  2MASS (char) 2MASS designation (JHHMMSSss+DDMMSSs) (meta.id.cross)
  Jmag mag (n) [2.19/17.01] 2MASS J (1.25um) band magnitude (phot.mag;em.IR.J)
  e_Jmag mag (n) [0.016/0.51] Jmag uncertainty (stat.error;phot.mag)
  Hmag mag (n) [1.23/17.55] 2MASS H (1.65um) band magnitude (phot.mag;em.IR.H)
  e_Hmag mag (n) [0.014/10] Hmag uncertainty (stat.error;phot.mag)
  Ksmag mag (n) [0.86/17.4] 2MASS Ks (2.17um) band magnitude (phot.mag;em.IR.K)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Ksmag mag (n) [0.01/10] Ksmag uncertainty (stat.error;phot.mag)
  WISEA (char) AllWISE designation (JHHMMSS.ss+DDMMSS.s) (meta.id.cross)
  RAWdeg deg (n) AllWISE right ascension (J2000) (pos.eq.ra)
  DEWdeg deg (n) AllWISE declination (J2000) (pos.eq.dec)
  W1mag mag (n) [-1.93/17.17] AllWISE W1 (3.35um) magnitude (phot.mag;em.IR.3-4um)
  e_W1mag mag (n) [0.017/0.54] W1mag mean error (stat.error;phot.mag)
  W2mag mag (n) [-1.5/17.8] AllWISE W2 (4.6um) magnitude (phot.mag;em.IR.4-8um)
  e_W2mag mag (n) [0.01/0.53] W2mag mean error (stat.error;phot.mag)
  W3mag mag (n) [-1.1/13.6] AllWISE W3 (11.6um) magnitude (phot.flux.density;em.IR.8-15um)
  e_W3mag mag (n) [0.007/0.55] W3mag mean error (stat.error;phot.mag)
  W4mag mag (n) [-2.1/10.1] AllWISE W4 (22.1um) magnitude (phot.flux.density;em.IR.15-30um)
  e_W4mag mag (n) [0.001/0.55] W4mag mean error (stat.error;phot.mag)
  WISE  (n) Unique AllWISE source ID (meta.id)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  ccf (char) AllWISE contamination and confusion flag (see II/328) (Note 2)   (meta.code)
  ex  (n) [0/5] AllWISE extended source (0=point source; see II/328) (Note 3)   (meta.code)
  var (char) AllWISE variability flag, one per band (>7=variable; see II/328) (Note 4)   (meta.code;src.var)
  qph (char) AllWISE photometric quality flag, one per band (A=SNR>10; see II/328) (meta.code.qual;phot)
  SepW arcsec (n) [0.00048/1] Angular separation of AllWISE from SpiKeS source (pos.angDistance)
  CatWISE (char) CatWISE objID (meta.id.cross)
  RACdeg deg (n) CatWISE right ascension (ICRS) (pos.eq.ra)
  DECdeg deg (n) CatWISE declination (ICRS) (pos.eq.dec)
  W1Cmag mag (n) [3.65/16.73] CatWISE W1 (3.35um) magnitude (phot.mag;em.IR.3-4um)
  e_W1Cmag mag (n) [0.006/0.3] W1Cmag mean error (stat.error;phot.mag)
  W2Cmag mag (n) [2.94/17.61] CatWISE W2 (4.6um) magnitude (phot.mag;em.IR.4-8um)
  e_W2Cmag mag (n) [0.004/0.3] W2Cmag mean error (stat.error;phot.mag)
  Teff K (n) [2661/27730] Stellar effective temperature from Mathur+, 2017, J/ApJS/229/30 (phys.temperature.effective)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Teff K (n) [0/1939] Teff negative uncertainty (stat.error;phys.temperature.effective)
  E_Teff K (n) [0/1015] Teff positive uncertainty (stat.error;stat.max)
  logg [cm/s2] (n) [-0.16/5.52] log of stellar surface gravity from Mathur+, 2017, J/ApJS/229/30 (phys.gravity)
  e_logg [cm/s2] (n) [0/0.9] logg negative uncertainty (stat.error)
  E_logg [cm/s2] (n) [0/2] logg positive uncertainty (stat.error;stat.max)
  [Fe/H] [-] (n) [-1.98/0.6] Stellar metallicity from Mathur+, 2017, J/ApJS/229/30 (phys.abund.Z)
  e_[Fe/H] [-] (n) [0/1.1] [Fe/H] negative uncertainty (stat.error;phys.abund.Fe)
  E_[Fe/H] [-] (n) [0/1.4] [Fe/H] positive uncertainty (stat.error;stat.max)
  Mass Msun (n) [0.094/3.8] Stellar mass from Mathur+, 2017, J/ApJS/229/30 (phys.mass)
  e_Mass Msun (n) [0/2.6] Mass negative uncertainty (stat.error;phys.mass)
  E_Mass Msun (n) [0/1.6] Mass positive uncertainty (stat.error;stat.max)
  Rad Rsun (n) [0.1/301] Stellar radius from Mathur+, 2017, J/ApJS/229/30 (phys.size.radius)
  e_Rad Rsun (n) [0/180] Rad negative uncertainty (stat.error)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  E_Rad Rsun (n) [0/42] Rad positive uncertainty (stat.error;stat.max)
  Den g/cm3 (n) [1.8e-7/117] Stellar density from Mathur+, 2017, J/ApJS/229/30 (phys.density)
  e_Den g/cm3 (n) [0/95] Den negative uncertainty (stat.error)
  E_Den g/cm3 (n) [0/24] Den positive uncertainty (stat.error;stat.max)
  Av mag (n) [0/1.04] AV extinction from Mathur+, 2017, J/ApJS/229/30 (phys.absorption)
  e_Av mag (n) [0/0.8] Av negative uncertainty (stat.error)
  E_Av mag (n) [0/0.3] Av positive uncertainty (stat.error;stat.max)
  Gaia  (n) Gaia DR2 identifier (meta.id.cross)
  RAGdeg deg (n) Gaia DR2 barycentric right ascension (ICRS) at Ep=2015.5 (pos.eq.ra)
  DEGdeg deg (n) Gaia DR2 barycentric declination (ICRS) at Ep=2015.5 (pos.eq.dec)
  rest pc (n) [19.16/18402] Bailer-Jones+ 2018, I/347 estimated distance (pos.distance)
  b_rest pc (n) [19/14137] Lower bound on the confidence interval of the estimated distance (pos.distance;stat.fit.param)
  B_rest pc (n) [19/23911] Upper bound on the confidence interval of the estimated distance (pos.distance;stat.fit.param)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  rlen pc (n) [774/2337] Length scale used in the prior for the distance estimation (pos.distance;instr.setup)
  ResFlag  (n) [1/2] Result flag (2=median; see I/347) (meta.code)
  ModFlag  (n) [1/2] Number of modes in the posterior (see I/347) (meta.code)
  Plx mas (n) [-8.7/52.2] Gaia DR2 absolute stellar parallax (pos.parallax)
  e_Plx mas (n) [0.01/1.4] Standard error of parallax (stat.error;pos.parallax)
  pmRA mas/yr (n) [-61.4/137] Gaia DR2 proper motion in RA direction (pmRA*cosDE) (pos.pm;pos.eq.ra)
  e_pmRA mas/yr (n) [0.02/3.3] pmRA standard error (stat.error;pos.pm;pos.eq.ra)
  pmDE mas/yr (n) [-67/64] Gaia DR2 proper motion in DEC direction (pos.pm;pos.eq.dec)
  e_pmDE mas/yr (n) [0.02/2.7] pmDE uncertainty (stat.error;pos.pm;pos.eq.dec)
  SepG arcsec (n) [0.0004/1] Angular separation of Gaia DR2 from SpiKes sources (pos.angDistance)
  Simbad  ask the Simbad data-base about this object (meta.ref.url)

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 (2024-09-19T21:12:59)
-3
-source=J/ApJS/254/11
-ref=VIZ66ec93db27dc5
elapse time 0

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


Contents of error file (/tmp/V-3.err):
CDSportal=http://cdsportal.u-strasbg.fr/StoreVizierData.html
COCAT=130.79.128.31
COCATPORT=1801
CONTEXT_DOCUMENT_ROOT=/srv/httpd/local/cgi/
CONTEXT_PREFIX=/local/viz-bin/
Content=text/html
DOCKER=yes
DOCUMENT_ROOT=/srv/httpd/Pages/
GATEWAY_INTERFACE=CGI/1.1
GLUDIR=/srv/glu
GLUHOME=/srv/glu
GROUP=root
HOME=/srv/httpd
HOST=8ae129b2b46e
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=cds:8082
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_X_FORWARDED_FOR=3.143.204.127
HTTP_X_FORWARDED_HOST=viz-beta.u-strasbg.fr
HTTP_X_FORWARDED_SERVER=viz-beta.u-strasbg.fr
LC_ALL=C
LD_LIBRARY_PATH=/srv/httpd/../lib:/srv/lib:/usr/local/lib:/usr/lib
LOGNAME=root
MACHTYPE=x86_64
METADB=metaviz@VIZIR asu asu4VizieR
MOCCMD=mocset query /srv/httpd/mocs/mocset10.bin cone -p 5 
NEWS=/VizieR/+news.htx
OSTYPE=linux
PATH=/srv/httpd/bin:/usr/local/bin:/usr/bin:/bin
PATH_INFO=/
PWD=/srv/httpd/cgi
QMOCCMD=.ext-tsv/qat2s_asu --out.form tsv --noheader --out.max=999999999 --source=%s --moc=%s
QUERY_STRING=-source=J%2FApJS%2F254%2F11
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=59834
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FApJS%2F254%2F11
SCRIPT_FILENAME=/srv/httpd/local/cgi/VizieR-3
SCRIPT_NAME=/local/viz-bin/VizieR-3
SERVER_ADDR=172.17.0.2
SERVER_ADMIN=gilles.landais@astro.u-strasbg.fr
SERVER_NAME=cds
SERVER_PORT=8082
SERVER_PROTOCOL=HTTP/1.1
SERVER_SIGNATURE=
SERVER_SOFTWARE=Apache/2.4.57 (Unix)
SESAME_SERVER=glu
SHLVL=1
USER=root
VENDOR=unknown
VSEARCH_HOST=cdsarc.cds.unistra.fr
VSEARCH_REDIRECT=http://cdsarc.cds.unistra.fr
Vaccess=*
Vprog=/srv/httpd/bin/vizier
Vprog_ls=-rwxr-xr-x 1 root root 963216 Sep 12 07:38 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=J/ApJS/254/11
################################################################

....Trying '/srv/httpd/interfaces' => OK
....Trying '/srv/httpd/interfaces' => 3
....db1_interfaces(/srv/httpd/interfaces)
----db1_open(metaviz@VIZIR) gives: 0
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAdba'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAtab'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAcol'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAcat'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAmor'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAdic'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAdig'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAfam'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAucd'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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 = 'METAauth'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select hstid, flag from METAhst where name='8ae129b2b46e.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/ApJS/254/11' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=22540011 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22540011 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   select login from METAdba where dbaid=45
----db1_reset(0 'metaviz@VIZIR')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZIR'):
[1726780379]    insert into T1 values(22540011)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@VIZIR'):
[1726780379]    insert into T2 values(22540011)
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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_query(0 'metaviz@VIZIR'):
[1726780379]   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'):
[1726780379]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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'):
[1726780379]   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'):
[1726780379]   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'):
[1726780379]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 146/0 tuples [tested=146]
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=22540011 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22540011 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=22540011 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select catid, morid, text From METAmor where catid=22540011 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=22540011 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=4
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=703 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=703 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=22540011 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=22540011 and tabid=1

====Contents of more_defs:
(nil)
====argColors='(nil)'

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAtime' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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'):
[1726780379]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   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=22540011 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=22540011 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22540011 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select idori, kwdid, name, explain From METAorigin
----db1_open(metaviz@VIZIR) gives: 1
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_exec(1 'metaviz@VIZIR'):
[1726780379]    Update METAhit set etime=780095579,  Ncalls = Ncalls+1 where catid=22540011 and hstid=-1 and btime=778420800
------------(0 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1726780379]    Insert into METAhit (catid, hstid, btime, etime, Ncalls, N2list) VALUES (22540011,-1,778420800,780095579, 1,0)
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1726780379]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780095579 Where phase=3 and catid=22540011
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/ApJS/254/11/spikes): show_status = (30, 56, 0, 0, 1)
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=75
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=159
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=926
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=665
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=925
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=666
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=64
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=930
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=741
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=76
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=166
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=693
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=928
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=689
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=924
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=480
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=923
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=481
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=177
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=324
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=110
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=68
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=98
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=228
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1110
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=225
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1070
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=187
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=976
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=129
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=920
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=126
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=196
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1025
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=221
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1052
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=175
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=940
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=121
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=468
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=236
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=951
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=355
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=45
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1045
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=260
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1211
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726780379]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/ApJS/254/11
     [u] -ref=VIZ66ec93db27dc5
====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