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/AJ/159/282
  Membership in Ophiuchus & Upper Scorpius complex (Esplin+, 2020)
Post annotation
img(gal)
1.J/AJ/159/282/table1Members of the Ophiuchus Complex (373 rows) (released 2022-11-04)
[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)
  2MASS (char) 2MASS Point Source Catalog source name (meta.id;meta.main)
  UGCS (char) UKIDSS Galactic Clusters Survey source name (Note 1)   (meta.id.cross)
  ugcs  (n)Display data from UGCS (II/319) within 1" (meta.ref.url)
  WISEA (char) AllWISE source name (Note 2)   (meta.id.cross)
  Gaia  (n) Gaia DR2 source name (meta.id.cross)
  SR (char) Designation from Struve & Rudkjobing, 1949ApJ...109...92S (meta.id.cross)
  DoAr  (n) Designation from Dolidze & Arakelyan, 1959AZh....36..444D (meta.id.cross)
  GSS  (n) Designation from Grasdalen+, 1973ApJ...184L..53G (meta.id.cross)
  VSSG  (n) Designation from Vrba+, 1975ApJ...197...77V (meta.id.cross)
  Elias (char) Designation from Elias+, 1978ApJ...223..859E (meta.id.cross)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  ROX (char) Designation from Montmerle+, 1983ApJ...269..182M (meta.id.cross)
  WL  (n) Designation from Wilking & Lada, 1983ApJ...274..698W (meta.id.cross)
  WSB (char) Designation from Wilking+, 1987AJ.....94..106W (meta.id.cross)
  HBC  (n) Designation from Herbig & Bell, 1988LicOB1111....1H (meta.id.cross)
  WLY (char) Designation from Wilking+, 1989ApJ...340..823W (meta.id.cross)
  LFAM (char) Designation from Leous+, 1991ApJ...379..683L (meta.id.cross)
  GY  (n) Designation from Greene & Young, 1992ApJ...395..516G (meta.id.cross)
  ROXs (char) Designation from Bouvier & Appenzeller, 1992A&AS...92..481B (meta.id.cross)
  ROXR1 (char) Designation from Casanova+, 1995ApJ...439..752C (meta.id.cross)
  ROXA (char) Designation from Kamata+, 1997PASJ...49..461K (meta.id.cross)
  RXJ (char) Designation from Martin+, 1998MNRAS.300..733M (meta.id.cross)
  ROXR (char) Designation from Grosso+, 2000, J/A+A/359/113 (meta.id.cross)
  ISOOph  (n) Designation from Botemps+, 2001, J/A+A/372/173 (meta.id.cross)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  ROXN  (n) Designation from Ozawa+, 2005, J/A+A/429/963 (meta.id.cross)
  CFHTWIROph  (n) Designation from Alves de Oliveira+, 2010, J/A+A/515/A75 (meta.id.cross)
  OName (char) Other common identifier (meta.id)
  RAJ2000 deg (i) [243.1/248.7] Right Ascension (J2000) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) [-26.5/-19.8] Declination (J2000) (pos.eq.dec;meta.main)
  Ref-Pos (char) Reference RAdeg and DEdeg positions (Note 3)   (meta.bib)
  Region (char) Region in Figure 1 (meta.bib.fig)
  SpType (char) Spectral Type (src.spType)
  r_SpType (char) Reference for SpType (meta.ref;pos.frame)
  SpT (char) Adopted spectral type (src.spType)
  pmRA mas/yr (n) [-17.9/3.5] Proper motion in RA from Gaia DR2 (pos.pm;pos.eq.ra)
  e_pmRA mas/yr (n) [0.08/3.9] Error in GaiapmRA (stat.error;pos.pm;pos.eq.ra)
  pmDE mas/yr (n) [-34.6/-16.6] Proper motion in DE from Gaia DR2 (pos.pm;pos.eq.dec)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_pmDE mas/yr (n) [0.04/2.74] Error in GaiapmDE (stat.error;pos.pm;pos.eq.dec)
  plx mas (n) [3.29/15.54] Parallax from Gaia DR2 (pos.parallax.trig)
  e_plx mas (n) [0.03/1.95] Error in plx (stat.error;pos.parallax)
  Gmag mag (n) [4.85/21.4] G magnitude from Gaia DR2 (phot.mag;em.opt)
  e_Gmag mag (n) [4.85/21.4] Error in Gmag (stat.error;phot.mag)
  BPmag mag (n) [5.07/22.1] G_BP magnitude from Gaia DR2 (phot.mag;em.opt)
  e_BPmag mag (n) [0.001/0.45] Error in GBPmag (stat.error;phot.mag)
  RPmag mag (n) [4.59/19.2] G_RP magnitude from Gaia DR2 (phot.mag;em.opt)
  e_RPmag mag (n) [0.001/0.18] Error in GRPmag (stat.error;phot.mag)
  RUWE  (n) [0.77/31.8] Re-normalized unit weight error from Lindegren+, 2018. (stat.error)
  pmRA-IR mas/yr (n) [-174.6/42.6] Proper motion in RA from IRAC (pos.pm;pos.eq.ra)
  e_pmRA-IR mas/yr (n) [0.18/182.3] Error in IRpmRA (stat.error;pos.pm)
  pmDE-IR mas/yr (n) [-188.5/17] Proper motion DE from IRAC (pos.pm;pos.eq.dec)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_pmDE-IR mas/yr (n) [0.15/131.7] Error in IRpmDE (stat.error;pos.pm)
  Jmag mag (n) [3.57/19.2] J magnitude (phot.mag;em.IR.J)
  e_Jmag mag (n) [0.01/0.29] Error in Jmag (stat.error;phot.mag)
  r_Jmag (char) Reference for Jmag (Note 4)   (meta.ref;pos.frame)
  Hmag mag (n) [3.35/17.53] H magnitude (phot.mag;em.IR.H)
  e_Hmag mag (n) [0/0.25] Error in Hmag (stat.error;phot.mag)
  r_Hmag (char) Reference for Hmag (Note 4)   (meta.ref;pos.frame)
  Kmag mag (n) [3.17/15.97] Ks or K magnitude (phot.mag;em.IR.K)
  e_Kmag mag (n) [0/0.52] Error in Kmag (stat.error;phot.mag)
  r_Kmag (char) Reference for Kmag (Note 4)   (meta.ref;pos.frame)
  3.6mag mag (n) [3.47/14.8] Spitzer/IRAC 3.6um magnitude (phot.mag;em.IR.3-4um)
  e_3.6mag mag (n) [0.01/0.05] Error in 3.6mag (stat.error)
  f_3.6mag (char) Flag on 3.6mag (Note 5)   (meta.code)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  4.5mag mag (n) [3.46/14.7] Spitzer/IRAC 4.5um magnitude (phot.mag;em.IR.4-8um)
  e_4.5mag mag (n) [0.02/0.05] Error in 4.5mag (stat.error)
  f_4.5mag (char) Flag on 4.5mag (Note 5)   (meta.code)
  5.8mag mag (n) [3.46/15.1] Spitzer/IRAC 5.8um magnitude (phot.flux.density;em.IR.4-8um)
  e_5.8mag mag (n) [0.01/0.2] Error in 5.8mag (stat.error)
  f_5.8mag (char) Flag on 5.8mag (Note 5)   (meta.code)
  8.0mag mag (n) [2.76/15.1] Spitzer/IRAC 8.0um magnitude (phot.flux.density;em.IR.8-15um)
  e_8.0mag mag (n) [0/0.44] Error in 8.0mag (stat.error)
  f_8.0mag (char) Flag on 8.0mag (Note 5)   (meta.code)
  24mag mag (n) [-0.04/10.9] Spitzer/MIPS 24um magnitude (phot.flux.density;em.IR.15-30um)
  e_24mag mag (n) [0.01/0.37] Error in 24mag (stat.error)
  f_24mag (char) Flag on 24mag (Note 5)   (meta.code)
  W1mag mag (n) [5.4/15.3] WISE W1 magnitude (33526Å) (phot.mag;em.IR.3-4um)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_W1mag mag (n) [0.01/0.29] Error in W1mag (stat.error;phot.mag)
  f_W1mag (char) Flag on W1mag (Note 5)   (meta.code)
  W2mag mag (n) [6.1/14.8] WISE W2 magnitude (46028Å) (phot.mag;em.IR.4-8um)
  e_W2mag mag (n) [0.01/0.21] Error in W2mag (stat.error;phot.mag)
  f_W2mag (char) Flag on W2mag (Note 5)   (meta.code)
  W3mag mag (n) [2.63/12.11] WISE W3 magnitude (115608Å) (phot.flux.density;em.IR.8-15um)
  e_W3mag mag (n) [0.01/0.4] Error in W3mag (stat.error;phot.mag)
  f_W3mag (char) Flag on W3mag (Note 5)   (meta.code)
  W4mag mag (n) [-1.61/9] WISE W4 magnitude (220883Å) (phot.flux.density;em.IR.15-30um)
  e_W4mag mag (n) [0.01/0.43] Error in W4mag (stat.error;phot.mag)
  f_W4mag (char) Flag on W4mag (Note 5)   (meta.code)
  Exc4.5 (char) Excess present in [4.5]? (phot.flux;arith.ratio)
  Exc8.0 (char) Excess present in [8.0]? (phot.flux;arith.ratio)
  Exc24 (char) Excess present in [24]? (phot.flux;arith.ratio)
  ExcW2 (char) Excess present in W2? (phot.flux;arith.ratio)
  ExcW3 (char) Excess present in W3? (phot.flux;arith.ratio)
  ExcW4 (char) Excess present in W4? (phot.flux;arith.ratio)
  DiskType (char) Disk Type (src.class)
  Ak mag (n) [0.04/6.62] Extinction in K (phys.absorption)
  f_Ak (char) Method for estimating Ak (Note 6)   (meta.code)

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-20T08:34:09)
-3
-source=J/AJ/159/282/table1
-ref=VIZ66ed338266c90
elapse time 1

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.145.8.188
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%2FApJ%2F806%2FL35
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=35626
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FApJ%2F806%2FL35
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/ApJ/806/L35
################################################################

....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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select hstid, flag from METAhst where name='8ae129b2b46e.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/ApJ/806/L35' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=18069035 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@VIZIR'):
[1726821249]    insert into T2 values(51590282)
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   select k.catid,k.kwdid from METAkwd k,T2 t ------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZIR'):
[1726821249]    insert into T1 values(18069035)
------------(1 records affected)
------------db1_tcreate(0): temporary table----db1_query(0 'metaviz@VIZIR'):
[1726821249]   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'):
[1726821249]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   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'):
[1726821249]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 146/0 tuples [tested=146]
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=51590282 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51590282 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51590282 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select catid, morid, text From METAmor where catid=51590282 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590282 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=4
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=704 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=703 and fltrid=4
----db1_query(0 'metaviz@VIZIR'):
[1726821249]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=703 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=703 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=703 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=803 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=803 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=803 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590282 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590282 and tabid=3
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590282 and tabid=4
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590282 and tabid=5
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590282 and tabid=6
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590282 and tabid=7
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51590282 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590282 and tabid=1

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

....DisplayFile(/srv/------------(0 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1726821250]    Insert into METAhit (catid, hstid, btime, etime, Ncalls, N2list) VALUES (18069035,-1,778420800,780136449, 1,0)
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1726821250]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780136450 Where phase=3 and catid=18069035
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/ApJ/806/L35/table2): show_status = (12, 1, 0, 0, 0)
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1135
----db1----db1_open(metaviz@VIZIR) gives: 1
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_exec(1 'metaviz@VIZIR'):
[1726821250]    Update METAhit se----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam wh------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1726821250]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780136450 Where phase=3 and catid=51590282
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/AJ/159/282/table1): show_status = (26, 70, 0, 0, 0)
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=76
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=166
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=55
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1255
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=58
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=187
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=323
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1332
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=251
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=264
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1211
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=260
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=930
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=741
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=730
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=928
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=734
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=743
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=926
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=665
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=925
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=666
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1461
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=924
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=1470
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=923
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=481
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=480
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=106
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=9
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=548
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=96
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select ucdid, name, class, explain From METAucd where ucdid=121
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726821250]   Select famid, name, explain From METAfam where famid=470
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/AJ/159/282/table1
     [u] -ref=VIZ66ed338266c90
====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