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_hpic(c)Habitable worlds observatory Preliminary Input Catalog (HPIC) (original column names in green) (accessible after 2025-09-21)
[METAtab] [METAcola]
2.J/AJ/167/139/t_contList of contaminants from Gaia DR3 within 10" (original column names in green) (accessible after 2025-09-21)
[METAtab] [METAcola]

 
Standard Original
Query by Constraints constraints help applied on Columns (Output Order: + - )
ShowSortJoin tables
more join
Column  Constraint Explain   (UCD)
  (ALL)recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
   (ALL)ID (char) (i) Unique object name in HPIC (star_name) (meta.id;meta.main)
  (1)RAJ2000 deg (i) Right ascension in degrees (J2000) (ra) (pos.eq.ra;meta.main)
  (1)DEJ2000 deg (i) Declination in degrees (J2000) (dec) (pos.eq.dec;meta.main)
  (1)RA16deg deg (n) Right ascension in degrees (J2000) at Ep=2016 (ra_J2016) (pos.eq.ra)
  (1)DE16deg deg (n) Declination in degrees (J2000) at Ep=2016 (dec_J2016) (pos.eq.dec)
  (1)TIC  (n) [16855/2055627584] Tess Input Catalog identifier (IV/38, IV/39) (tic_id) (meta.id)
  (1)GaiaDR2 (char) Gaia DR2 identifier (I/345) (gaia_dr2_id) (meta.id)
  (1)GaiaDR3 (char) Gaia DR3 identifier (I/355, I/357) (gaia_dr3_id) (meta.id)
  (1)HIP  (n) [2/120250] Hipparcos identifier (I/239) (hip_name) (meta.id)
  (1)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
  (1)TYC (char) Tycho identifier (I/259) (tyc_name) (meta.id)
  (1)WDS (char) Washington Double Star catalog identifier (B/wds) (wds_designation) (meta.id)
  (1)Simbad (char) Simbad identifier (simbad_name) (meta.id)
  (1)Source (char) Flag for the source of the object (TESS or Gaia) (source_list_fl) (Note 1)   (meta.code)
  (1)pmRA mas/yr (n) [-4411/6766] Proper motion in right ascension (sy_pmra) (pos.pm;pos.eq.ra)
  (1)e_pmRA mas/yr (n) [6e-3/36] Uncertainty in pmRA (sy_pmraerr) (stat.error;pos.pm;pos.eq.ra)
  (1)pmDE mas/yr (n) [-5818/10363] Proper motion in declination (sy_pmdec) (pos.pm;pos.eq.dec)
  (1)e_pmDE mas/yr (n) [7e-3/35] Uncertainty in pmDE (sy_pmdecerr) (stat.error;pos.pm;pos.eq.dec)
  (1)pmRef (char) Source of proper motion (sy_pmsrc) (Note 2)   (meta.bib)
  (1)pmBib (char) Bibcode for pmRef (sy_pm_reflink) (meta.bib.bibcode;pos.pm)
  (1)Umag mag (n) [-1.6/17.4] Johnson U (364nm) magnitude (sy_ujmag) (phot.mag;em.opt.U)
  (1)e_Umag mag (n) [6e-4/0.05] Uncertainty in Umag (sy_ujmagerr) (stat.error;phot.mag;em.opt.U)
  (1)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
  (1)Bmag mag (n) [-1.5/18] Johnson B (442nm) magnitude (sy_bmag) (phot.mag;em.opt.B)
  (1)e_Bmag mag (n) [-0.04/161] Uncertainty in Bmag (sy_bmagerr) (stat.error;phot.mag;em.opt.B)
  (1)BmagBib (char) Bibcode for r_Bmag (sy_bmag_reflink) (meta.bib.bibcode;phot.mag;em.opt.B)
  (1)Vmag mag (n) [-1.5/17.9] Johnson V (540nm) magnitude (sy_vmag) (phot.mag;em.opt.V)
  (1)e_Vmag mag (n) [0/2.3] Uncertainty in Vmag (sy_vmagerr) (stat.error;phot.mag;em.opt.V)
  (1)VmagBib (char) Bibcode for r_Vmag (sy_vmag_reflink) (meta.bib.bibcode;phot.mag;em.opt.V)
  (1)Rmag mag (n) [-1.5/16.6] Johnson-Cousins R (647nm) magnitude (sy_rcmag) (phot.mag;em.opt.R)
  (1)e_Rmag mag (n) [6e-4/0.9] Uncertainty in Rmag (sy_rcmagerr) (stat.error;phot.mag;em.opt.R)
  (1)RmagBib (char) Bibcode for r_Rmag (sy_rcmag_reflink) (meta.bib.bibcode;phot.mag;em.opt.R)
  (1)Imag mag (n) [-1.7/14.5] Johnson-Cousins I (786.5nm) magnitude (sy_icmag) (phot.mag;em.opt.I)
  (1)e_Imag mag (n) [0/1] Uncertainty in Imag (sy_icmagerr) (stat.error;phot.mag;em.opt.I)
  (1)ImagBib (char) Bibcode of r_Imag (sy_icmag_reflink) (meta.bib.bibcode;phot.mag;em.opt.I)
  (1)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
  (1)e_Jmag mag (n) [0.01/10] Uncertainty in Jmag (sy_jmagerr) (stat.error;phot.mag;em.IR.J)
  (1)JmagBib (char) Bibcode for r_Jmag (sy_jmag_reflink) (meta.bib.bibcode;phot.mag;em.IR.J)
  (1)Hmag mag (n) [-3/17.6] 2MASS H (1.65um) magnitude (sy_hmag) (phot.mag;em.IR.H)
  (1)e_Hmag mag (n) [0.01/10] Uncertainty in Hmag (sy_hmagerr) (stat.error;phot.mag;em.IR.H)
  (1)HmagBib (char) Bibcode for r_Hmag (sy_hmag_reflink) (meta.bib.bibcode;phot.mag;em.IR.H)
  (1)Ksmag mag (n) [-3.3/17] 2MASS Ks (2.15um) magnitude (sy_kmag) (phot.mag;em.IR.K)
  (1)e_Ksmag mag (n) [1e-3/10] Uncertainty in Ksmag (sy_kmagerr) (stat.error;phot.mag;em.IR.K)
  (1)KsmagBib (char) Bibcode for r_Ksmag (sy_kmag_reflink) (meta.bib.bibcode;phot.mag;em.IR.K)
  (1)Tmag mag [-1.3/12] TESS (600-1000nm) magnitude from TIC v8.2 (IV/39) (sy_tmag) (phot.mag;em.opt.R)
  (1)e_Tmag mag (n) [6e-3/10.7] Uncertainty in Tmag (sy_tmagerr) (stat.error;phot.mag;em.opt.R)
  (1)plx mas (n) [-9e-3/768.1] Parallax (sy_plx) (pos.parallax)
  (1)e_plx mas (n) [8e-3/27.6] Uncertainty in plx (sy_plxerr) (stat.error;pos.parallax)
  (1)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
  (1)Dist pc (n) [1.3/50] Distance (sy_dist) (pos.distance)
  (1)e_Dist pc (n) [9e-5/50] Uncertainty in Dist (sy_disterr) (stat.error;pos.distance)
  (1)DistBib (char) Bibcode for r_Dist (sy_dist_reflink) (meta.bib.bibcode;pos.distance)
  (1)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)
  (1)spType (char) Spectral type from Simbad (st_spectype) (src.spType)
  (1)spTypeBib (char) Bibcode of spType source (st_spectype_reflink) (meta.bib.bibcode;src.spType)
  (1)fDwarf   [0/1] Boolean flag for if an object is a dwarf star (1=true) (dwarf_fl) (meta.code;src.spType)
  (1)Teff K (n) [2600/26083] Stellar effective temperature (st_teff) (phys.temperature.effective)
  (1)e_Teff K (n) [0.5/1020] Uncertainty in K (st_spectypeerr) (stat.error;phys.temperature.effective)
  (1)TeffBib (char) Bibcode for r_Teff (st_teff_reflink) (meta.bib.bibcode;phys.temperature.effective)
  (1)log(g)B [cm/s2] (n) [0.3/8.3] Stellar log surface gravity from bulk properties (st_logg) (phys.gravity)
  (1)e_log(g)B [cm/s2] (n) [5e-3/2.1] Uncertainty in log(g)B (st_loggerr) (stat.error;phys.gravity)
  (1)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
  (1)log(g)Sp [cm/s2] (n) [0.7/5.9] Stellar log gravity from spectroscopy (st_loggspec) (phys.gravity)
  (1)e_log(g)Sp [cm/s2] (n) [0/1.22] Uncertainty in log(g)Sp (st_loggspecerr) (stat.error;phys.gravity)
  (1)log(g)SpBib (char) Bibcode for r_log(g)Sp (st_loggspec_reflink) (meta.bib.bibcode;phys.gravity)
  (1)[Fe/H] [Sun] (n) [-3.8/1.6] Stellar metallicity (st_met) (phys.abund.Fe)
  (1)e_[Fe/H] [Sun] (n) [0/2.3] Uncertainty in [Fe/H] (st_meterr) (stat.error;phys.abund.Fe)
  (1)[Fe/H]Bib (char) Bibcode for r_[Fe/H] (st_met_reflink) (meta.bib.bibcode;phys.abund.Fe)
  (1)log(L) [Lsun] (n) [-3.5/3.8] Stellar log luminosity (st_lum) (phys.luminosity)
  (1)e_log(L) [Lsun] (n) [4e-5/2.1] Uncertainty in log(L) (st_lumerr) (stat.error;phys.luminosity)
  (1)log(L)Bib (char) Bibcode for r_log(L) (st_lum_reflink) (meta.bib.bibcode;phys.luminosity)
  (1)Rad Rsun (n) [0.01/95.1] Stellar radius (st_rad) (phys.size.radius)
  (1)e_Rad Rsun (n) [3e-4/47.8] Uncertainty in Rad (st_raderr) (stat.error;phys.size.radius)
  (1)RadBib (char) Bibcode for r_Rad (st_rad_reflink) (meta.bib.bibcode;phys.size.radius)
  (1)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
  (1)e_Mass Msun (n) [1.5e-5/0.8] Uncertainty in Mass (st_masserr) (stat.error;phys.mass)
  (1)MassBib (char) Bibcode for r_Mass (st_mass_reflink) (meta.bib.bibcode;phys.mass)
  (1)f_Mass   [0/1] Boolean flag for if the mass measurement is unreliable (1=true) (uncertain_M_flag) (meta.code;phys.mass)
  (1)Age Gyr (n) [0.1/13.6] Stellar age (st_age) (time.age)
  (1)e_Age Gyr (n) [0/6.7] Uncertainty in Age (st_ageerr) (stat.error;time.age)
  (1)AgeBib (char) Bibcode for r_Age (st_age_reflink) (meta.bib.bibcode;time.age)
  (1)fCont  (n) [1/1] Boolean flag for if there are nearby contaminants (1=true) (contaminant_fl) (meta.code)
  (1)NCont  (n)Number of potential contaminants for this object (link to Contaminant table) (meta.number)
  (1)SepContB arcsec (n) [3e-3/10] Angular separation from brightest Gaia contaminant (brightest_sep) (pos.angDistance)
  (1)dGmagContB mag (n) [2.1/22.6] Gaia G (673nm) magnitude difference with brightest Gaia contaminant (brightest_Gmag) (phot.mag;arith.diff)
  (1)GaiaContB (char) Gaia identifier of nearest contaminant (brightest_id) (meta.id.assoc)
  (1)SepContN arcsec (n) [3e-3/10] Angular separation from nearest Gaia contaminant (nearest_sep) (pos.angDistance)
  (1)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
  (1)GaiaContN (char) Gaia identifier of nearest contaminant (nearest_id) (meta.id.assoc)
  (1)fBinar   [0/1] Boolean flag if star is a known binary (1=true) (known_binary_fl) (meta.code)
  (1)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)
  (1)WDScomp (char) WDS system component (wds_comp) (meta.id)
  (1)SepWDS arcsec (n) [0/86838] WDS angular separation (wds_sep) (pos.angDistance)
  (1)dVmagWDS mag (n) [-12.8/23.5] WDS V (540nm) magnitude difference (wds_delta_mag) (phot.mag;arith.diff)
  (1)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)
  (1)SepGCNS arcsec (n) [0.7/3596] GCNS angular separation (GCNS_sep) (pos.angDistance)
  (1)dGmagGCNS mag (n) [-11.8/14.4] GCNS G (673nm) magnitude difference (GCNS_mag_diff) (phot.mag;arith.diff)
  (1)fPl   [0/1] Boolean flag for if there are known planets (1=true) (sy_planets_flag) (meta.code)
  (1)Host (char) Name of the exoplanet host star in the NASA Exoplanet Archive (only present for planet hosts) (hostname) (meta.id.parent)
  (2)Cont (char) Gaia DR3 (I/355, I/357) identifier of the potential contaminant (contaminant_Gaia_DR3_id) (meta.id.assoc)
  (2)SepAng arcsec [3e-3/10] Angular separation between HPIC object and contaminant (andDist) (pos.angDistance)
  (2)Gmag mag (n) [2.1/22.6] Gaia G (673nm) magnitude of the contaminant (I/355, I/357) (Gmag) (phot.mag;em.opt.V)

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-24T03:17:31)
-3
-source=J/AJ/167/139
-ref=VIZ68aa844b38bbce
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=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%2FApJ%2F707%2F482
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=59828
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FApJ%2F707%2F482
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/ApJ/707/482
################################################################

....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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select hstid, flag from METAhst where name='b448cffa3102.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/ApJ/707/482' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=17070482 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17070482 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   select login from METAdba where dbaid=44
----db1_reset(0 'metaviz@VIZIR')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZIR'):
[1756005452]    insert into T1 values(17070482)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@VIZIR'):
[1756005452]    insert into T2 values(17070482)
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   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'):
[1756005452]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 147/0 tuples [tested=147]
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=17070482 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17070482 order by tabid
     [u] +source=J/ApJ/762/46/galaxies
     [u] -ref=VIZ68aa844c38bc0f
====inherit(): added 0 hidden fields
@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=713
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=682
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=716
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=448
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=447
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=693
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=928
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=689
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=742
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=260
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=1209
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=236
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=951
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=323
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=1331
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=225
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=1070
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=187
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=976
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=126
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=920
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=191
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=995
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=221
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=1052
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=196
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=1025
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=368
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=1360
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=228
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=1110
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=5
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=462
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=75
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=159
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=177
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select ucdid, name, class, explain From METAucd where ucdid=77
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=185
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756005452]   Select famid, name, explain From METAfam where famid=875
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/AJ/167/139
     [u] -ref=VIZ68aa844b38bbce
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@VIZIR')

Cite/acknowledge VizieR catalogue
Rules of usage of VizieR data

© Université de Strasbourg/CNRS

    • Contact