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/167/139
  HPIC catalog and potential contaminants from Gaia (Tuchow+, 2024)
Post annotation
img(gal)
1.J/AJ/167/139/t_hpicHabitable worlds observatory Preliminary Input Catalog (HPIC) (original column names in green) (accessible after 2025-09-21)
[METAtab] [METAcola]

  Table J/AJ/167/139/t_hpic accessible after 2025-09-21 [METAcola]

 

Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
Standard Original
ShowSortColumn  Constraint Explain   (UCD)
  recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
  ID (char) (i) Unique object name in HPIC (star_name) (meta.id;meta.main)
  RAJ2000 deg (i) Right ascension in degrees (J2000) (ra) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) Declination in degrees (J2000) (dec) (pos.eq.dec;meta.main)
  RA16deg deg (n) Right ascension in degrees (J2000) at Ep=2016 (ra_J2016) (pos.eq.ra)
  DE16deg deg (n) Declination in degrees (J2000) at Ep=2016 (dec_J2016) (pos.eq.dec)
  TIC  (n) [16855/2055627584] Tess Input Catalog identifier (IV/38, IV/39) (tic_id) (meta.id)
  GaiaDR2 (char) Gaia DR2 identifier (I/345) (gaia_dr2_id) (meta.id)
  GaiaDR3 (char) Gaia DR3 identifier (I/355, I/357) (gaia_dr3_id) (meta.id)
  HIP  (n) [2/120250] Hipparcos identifier (I/239) (hip_name) (meta.id)
  2MASS (char) 2MASS identifier (HHMMSSss+DDMMSSs) (II/246) (tm_name) (meta.id)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  TYC (char) Tycho identifier (I/259) (tyc_name) (meta.id)
  WDS (char) Washington Double Star catalog identifier (B/wds) (wds_designation) (meta.id)
  Simbad (char) Simbad identifier (simbad_name) (meta.id)
  Source (char) Flag for the source of the object (TESS or Gaia) (source_list_fl) (Note 1)   (meta.code)
  pmRA mas/yr (n) [-4411/6766] Proper motion in right ascension (sy_pmra) (pos.pm;pos.eq.ra)
  e_pmRA mas/yr (n) [6e-3/36] Uncertainty in pmRA (sy_pmraerr) (stat.error;pos.pm;pos.eq.ra)
  pmDE mas/yr (n) [-5818/10363] Proper motion in declination (sy_pmdec) (pos.pm;pos.eq.dec)
  e_pmDE mas/yr (n) [7e-3/35] Uncertainty in pmDE (sy_pmdecerr) (stat.error;pos.pm;pos.eq.dec)
  pmRef (char) Source of proper motion (sy_pmsrc) (Note 2)   (meta.bib)
  pmBib (char) Bibcode for pmRef (sy_pm_reflink) (meta.bib.bibcode;pos.pm)
  Umag mag (n) [-1.6/17.4] Johnson U (364nm) magnitude (sy_ujmag) (phot.mag;em.opt.U)
  e_Umag mag (n) [6e-4/0.05] Uncertainty in Umag (sy_ujmagerr) (stat.error;phot.mag;em.opt.U)
  UmagBib (char) Bibcode for r_Umag (sy_ujmag_reflink) (meta.bib.bibcode;phot.mag;em.opt.U)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Bmag mag (n) [-1.5/18] Johnson B (442nm) magnitude (sy_bmag) (phot.mag;em.opt.B)
  e_Bmag mag (n) [-0.04/161] Uncertainty in Bmag (sy_bmagerr) (stat.error;phot.mag;em.opt.B)
  BmagBib (char) Bibcode for r_Bmag (sy_bmag_reflink) (meta.bib.bibcode;phot.mag;em.opt.B)
  Vmag mag (n) [-1.5/17.9] Johnson V (540nm) magnitude (sy_vmag) (phot.mag;em.opt.V)
  e_Vmag mag (n) [0/2.3] Uncertainty in Vmag (sy_vmagerr) (stat.error;phot.mag;em.opt.V)
  VmagBib (char) Bibcode for r_Vmag (sy_vmag_reflink) (meta.bib.bibcode;phot.mag;em.opt.V)
  Rmag mag (n) [-1.5/16.6] Johnson-Cousins R (647nm) magnitude (sy_rcmag) (phot.mag;em.opt.R)
  e_Rmag mag (n) [6e-4/0.9] Uncertainty in Rmag (sy_rcmagerr) (stat.error;phot.mag;em.opt.R)
  RmagBib (char) Bibcode for r_Rmag (sy_rcmag_reflink) (meta.bib.bibcode;phot.mag;em.opt.R)
  Imag mag (n) [-1.7/14.5] Johnson-Cousins I (786.5nm) magnitude (sy_icmag) (phot.mag;em.opt.I)
  e_Imag mag (n) [0/1] Uncertainty in Imag (sy_icmagerr) (stat.error;phot.mag;em.opt.I)
  ImagBib (char) Bibcode of r_Imag (sy_icmag_reflink) (meta.bib.bibcode;phot.mag;em.opt.I)
  Jmag mag (n) [-2.3/16.6] 2MASS J (1.25um) magnitude (sy_jmag) (phot.mag;em.IR.J)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Jmag mag (n) [0.01/10] Uncertainty in Jmag (sy_jmagerr) (stat.error;phot.mag;em.IR.J)
  JmagBib (char) Bibcode for r_Jmag (sy_jmag_reflink) (meta.bib.bibcode;phot.mag;em.IR.J)
  Hmag mag (n) [-3/17.6] 2MASS H (1.65um) magnitude (sy_hmag) (phot.mag;em.IR.H)
  e_Hmag mag (n) [0.01/10] Uncertainty in Hmag (sy_hmagerr) (stat.error;phot.mag;em.IR.H)
  HmagBib (char) Bibcode for r_Hmag (sy_hmag_reflink) (meta.bib.bibcode;phot.mag;em.IR.H)
  Ksmag mag (n) [-3.3/17] 2MASS Ks (2.15um) magnitude (sy_kmag) (phot.mag;em.IR.K)
  e_Ksmag mag (n) [1e-3/10] Uncertainty in Ksmag (sy_kmagerr) (stat.error;phot.mag;em.IR.K)
  KsmagBib (char) Bibcode for r_Ksmag (sy_kmag_reflink) (meta.bib.bibcode;phot.mag;em.IR.K)
  Tmag mag [-1.3/12] TESS (600-1000nm) magnitude from TIC v8.2 (IV/39) (sy_tmag) (phot.mag;em.opt.R)
  e_Tmag mag (n) [6e-3/10.7] Uncertainty in Tmag (sy_tmagerr) (stat.error;phot.mag;em.opt.R)
  plx mas (n) [-9e-3/768.1] Parallax (sy_plx) (pos.parallax)
  e_plx mas (n) [8e-3/27.6] Uncertainty in plx (sy_plxerr) (stat.error;pos.parallax)
  plxBib (char) Bibcode for r_plx (sy_plx_reflink) (meta.bib.bibcode;pos.parallax)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Dist pc (n) [1.3/50] Distance (sy_dist) (pos.distance)
  e_Dist pc (n) [9e-5/50] Uncertainty in Dist (sy_disterr) (stat.error;pos.distance)
  DistBib (char) Bibcode for r_Dist (sy_dist_reflink) (meta.bib.bibcode;pos.distance)
  f_Dist   [0/1] Boolean flag for distance measurements that deviate from the value given by Simbad (1=true) (ambiguous_dist_fl) (meta.code;pos.distance)
  spType (char) Spectral type from Simbad (st_spectype) (src.spType)
  spTypeBib (char) Bibcode of spType source (st_spectype_reflink) (meta.bib.bibcode;src.spType)
  fDwarf   [0/1] Boolean flag for if an object is a dwarf star (1=true) (dwarf_fl) (meta.code;src.spType)
  Teff K (n) [2600/26083] Stellar effective temperature (st_teff) (phys.temperature.effective)
  e_Teff K (n) [0.5/1020] Uncertainty in K (st_spectypeerr) (stat.error;phys.temperature.effective)
  TeffBib (char) Bibcode for r_Teff (st_teff_reflink) (meta.bib.bibcode;phys.temperature.effective)
  log(g)B [cm/s2] (n) [0.3/8.3] Stellar log surface gravity from bulk properties (st_logg) (phys.gravity)
  e_log(g)B [cm/s2] (n) [5e-3/2.1] Uncertainty in log(g)B (st_loggerr) (stat.error;phys.gravity)
  log(g)BBib (char) Bibcode for r_log(g)B (st_logg_reflink) (meta.bib.bibcode;phys.gravity)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  log(g)Sp [cm/s2] (n) [0.7/5.9] Stellar log gravity from spectroscopy (st_loggspec) (phys.gravity)
  e_log(g)Sp [cm/s2] (n) [0/1.22] Uncertainty in log(g)Sp (st_loggspecerr) (stat.error;phys.gravity)
  log(g)SpBib (char) Bibcode for r_log(g)Sp (st_loggspec_reflink) (meta.bib.bibcode;phys.gravity)
  [Fe/H] [Sun] (n) [-3.8/1.6] Stellar metallicity (st_met) (phys.abund.Fe)
  e_[Fe/H] [Sun] (n) [0/2.3] Uncertainty in [Fe/H] (st_meterr) (stat.error;phys.abund.Fe)
  [Fe/H]Bib (char) Bibcode for r_[Fe/H] (st_met_reflink) (meta.bib.bibcode;phys.abund.Fe)
  log(L) [Lsun] (n) [-3.5/3.8] Stellar log luminosity (st_lum) (phys.luminosity)
  e_log(L) [Lsun] (n) [4e-5/2.1] Uncertainty in log(L) (st_lumerr) (stat.error;phys.luminosity)
  log(L)Bib (char) Bibcode for r_log(L) (st_lum_reflink) (meta.bib.bibcode;phys.luminosity)
  Rad Rsun (n) [0.01/95.1] Stellar radius (st_rad) (phys.size.radius)
  e_Rad Rsun (n) [3e-4/47.8] Uncertainty in Rad (st_raderr) (stat.error;phys.size.radius)
  RadBib (char) Bibcode for r_Rad (st_rad_reflink) (meta.bib.bibcode;phys.size.radius)
  Mass Msun (n) [0.07/6.6] Stellar mass (st_mass) (phys.mass)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Mass Msun (n) [1.5e-5/0.8] Uncertainty in Mass (st_masserr) (stat.error;phys.mass)
  MassBib (char) Bibcode for r_Mass (st_mass_reflink) (meta.bib.bibcode;phys.mass)
  f_Mass   [0/1] Boolean flag for if the mass measurement is unreliable (1=true) (uncertain_M_flag) (meta.code;phys.mass)
  Age Gyr (n) [0.1/13.6] Stellar age (st_age) (time.age)
  e_Age Gyr (n) [0/6.7] Uncertainty in Age (st_ageerr) (stat.error;time.age)
  AgeBib (char) Bibcode for r_Age (st_age_reflink) (meta.bib.bibcode;time.age)
  fCont  (n) [1/1] Boolean flag for if there are nearby contaminants (1=true) (contaminant_fl) (meta.code)
  NCont  (n)Number of potential contaminants for this object (link to Contaminant table) (meta.number)
  SepContB arcsec (n) [3e-3/10] Angular separation from brightest Gaia contaminant (brightest_sep) (pos.angDistance)
  dGmagContB mag (n) [2.1/22.6] Gaia G (673nm) magnitude difference with brightest Gaia contaminant (brightest_Gmag) (phot.mag;arith.diff)
  GaiaContB (char) Gaia identifier of nearest contaminant (brightest_id) (meta.id.assoc)
  SepContN arcsec (n) [3e-3/10] Angular separation from nearest Gaia contaminant (nearest_sep) (pos.angDistance)
  dGmagContN mag (n) [2.1/22.6] Gaia G (673nm) magnitude difference with Gaia nearest contaminant (nearest_Gmag) (phot.mag;arith.diff)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  GaiaContN (char) Gaia identifier of nearest contaminant (nearest_id) (meta.id.assoc)
  fBinar   [0/1] Boolean flag if star is a known binary (1=true) (known_binary_fl) (meta.code)
  fBinarG   [0/1] Boolean flag if object is tagged as a binary by Gaia DR3 (I/357) (1=true) (gaia_binary_fl) (Note 13)   (meta.code)
  WDScomp (char) WDS system component (wds_comp) (meta.id)
  SepWDS arcsec (n) [0/86838] WDS angular separation (wds_sep) (pos.angDistance)
  dVmagWDS mag (n) [-12.8/23.5] WDS V (540nm) magnitude difference (wds_delta_mag) (phot.mag;arith.diff)
  GCNSasc (char) Gaia DR3 identifier for object's companion in Gaia Catalog of Nearby Stars (GCNS, J/A+A/649/A6) (GCNS_companion) (meta.id.assoc)
  SepGCNS arcsec (n) [0.7/3596] GCNS angular separation (GCNS_sep) (pos.angDistance)
  dGmagGCNS mag (n) [-11.8/14.4] GCNS G (673nm) magnitude difference (GCNS_mag_diff) (phot.mag;arith.diff)
  fPl   [0/1] Boolean flag for if there are known planets (1=true) (sy_planets_flag) (meta.code)
  Host (char) Name of the exoplanet host star in the NASA Exoplanet Archive (only present for planet hosts) (hostname) (meta.id.parent)

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-24T07:41:44)
-3
-source=J/AJ/167/139/t_hpic
-ref=VIZ68aac2383e978b
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=b448cffa3102
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_CACHE_CONTROL=max-age=0
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_VIA=1.1 squid-proxy-5b5d847c96-l5qcg (squid/6.10)
HTTP_X_FORWARDED_FOR=10.3.175.99, 216.73.216.136
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 --out='!/_((RA)|(DE))J2000|recno/'
QUERY_STRING=-source=J%2FAJ%2F167%2F139%2Ft_hpic
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=35080
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FAJ%2F167%2F139%2Ft_hpic
SCRIPT_FILENAME=/srv/httpd/local/cgi/VizieR-3
SCRIPT_NAME=/local/viz-bin/VizieR-3
SERVER_ADDR=172.17.0.3
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 963736 Jun 11 08:12 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=J/AJ/167/139/t_hpic
################################################################

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

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   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'):
[1756021304]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   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'):
[1756021304]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   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=51670139 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=51670139 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51670139 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   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'):
[1756021304]    Update METAhit set etime=809336504,  Ncalls = Ncalls+1 where catid=51670139 and hstid=-1 and btime=807348600
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1756021304]    UPDATE METAstat set nlocal=nlocal+1, tlocal=809336504 Where phase=3 and catid=51670139
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/AJ/167/139/t_hpic): show_status = (7, 93, 0, 0, 0)
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=55
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1255
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=57
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1254
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=935
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=713
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=682
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=716
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=448
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=447
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=693
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=928
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=689
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=742
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=260
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1209
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=236
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=951
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=323
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1331
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=225
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1070
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=187
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=976
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=126
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=920
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=191
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=995
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=221
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1052
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=196
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1025
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=368
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1360
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=228
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=1110
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=5
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=462
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=75
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=159
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=177
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select ucdid, name, class, explain From METAucd where ucdid=77
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756021304]   Select famid, name, explain From METAfam where famid=185
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/AJ/167/139/t_hpic
     [u] -ref=VIZ68aac2383e978b
====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