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

  
I/239
  The Hipparcos and Tycho Catalogues (ESA 1997)
ReadMe+ftp
1997HIP...C......0E
Similar Catalogs
timeSerie
[METAcat] [METAcells] [stats]
1 annotation(s) (on 1 specific record(s)) 		img(gal)
1.I/239/tyc_mainThe main part of Tycho Catalogue[timeSerie] (1058332 rows) (released 2021-11-18)
[METAtab] [METAcola]
metaI/239/tyc_main
Note that the errors on the proper motions are large (∼50mas/yr), and therefore the positions computed at an epoch different from 1991.25 have a large (∼0.4") uncertainty.
The Tycho Epoch Photometry data can be accessed from the morePhoto column (includes VT, BT and Hp photometric data for Hipparcos stars [filter responses]

Simple ConstraintList Of Constraints
 
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)
  TYC (char) (i) TYC1-3 (TYC number) (Note T1)   (meta.id;meta.main)
  Proxy (char) [HT] Proximity flag (T2) (meta.code)
  RAhms (char) Right ascension in h m s, ICRS (J1991.25) (T3) (pos.eq.ra)
  DEdms (char) Declination in deg ' ", ICRS (J1991.25) (T4) (pos.eq.dec)
  Vmag mag (n) Magnitude in Johnson V (T5) (phot.mag;em.opt.V)
  r_Vmag (char) [BDTV] Source of magnitude (Note T7)   (meta.ref;pos.frame)
  RAICRS deg (i) alpha, degrees (ICRS, Epoch=J1991.25) (Note T8)   (pos.eq.ra;meta.main)
  DEICRS deg (i) delta, degrees (ICRS, Epoch=J1991.25) (Note T9)   (pos.eq.dec;meta.main)
  AstroRef (char) [X] Reference flag for astrometry (Note T10)   (meta.bib)
  Plx mas (n) Trigonometric parallax (Note T11)   (pos.parallax.trig)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  pmRA mas/yr (n) Proper motion mu_alpha.cos(delta), ICRS (Note T12)   (pos.pm;pos.eq.ra)
  pmDE mas/yr (n) Proper motion mu_delta, ICRS (Note T13)   (pos.pm;pos.eq.dec)
  e_RAICRS mas (n) Standard error in RA*cos(delta) (Note T14)   (stat.error;pos.eq.ra)
  e_DEICRS mas (n) Standard error in DE (Note T15)   (stat.error;pos.eq.dec)
  e_Plx mas (n) Standard error in Plx (Note T16)   (stat.error;pos.parallax)
  e_pmRA mas/yr (n) Standard error in pmRA (Note T17)   (stat.error;pos.pm;pos.eq.ra)
  e_pmDE mas/yr (n) Standard error in pmDE (Note T18)   (stat.error;pos.pm;pos.eq.dec)
  DE:RA  (n) [-1/1] Correlation, DE/RA*cos(delta) (T19) (stat.correlation)
  Plx:RA  (n) [-1/1] Correlation, Plx/RA*cos(delta) (T20) (stat.correlation)
  Plx:DE  (n) [-1/1] Correlation, Plx/DE (T21) (stat.correlation)
  pmRA:RA  (n) [-1/1] Correlation, pmRA/RA*cos(delta) (T22) (stat.correlation)
  pmRA:DE  (n) [-1/1] Correlation, pmRA/DE (T23) (stat.correlation)
  pmRA:Plx  (n) [-1/1] Correlation, pmRA/Plx (T24) (stat.correlation)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  pmDE:RA  (n) [-1/1] Correlation, pmDE/RA*cos(delta) (T25) (stat.correlation)
  pmDE:DE  (n) [-1/1] Correlation, pmDE/DE (T26) (stat.correlation)
  pmDE:Plx  (n) [-1/1] Correlation, pmDE/Plx (T27) (stat.correlation)
  pmDE:pmRA  (n) [-1/1] Correlation, pmDE/pmRA (T28) (stat.correlation)
  Nastro  (n) Number of transits for astrometry (T29) (meta.number)
  F2  (n) Goodness-of-fit parameter (Note T30)   (stat.fit.goodness)
  HIP  (n)(i) Hipparcos HIP number (T31) (meta.id)
  BTmag mag (n) Mean BT magnitude (T32) (phot.mag;em.opt.B)
  e_BTmag mag (n) Standard error in BTmag (T33) (stat.error;phot.mag)
  VTmag mag (n) Mean VT magnitude (T34) (phot.mag;em.opt.V)
  e_VTmag mag (n) Standard error in VTmag (T35) (stat.error;phot.mag)
  r_BTmag (char) [DMNT] Source of photometry (Note T36)   (meta.ref)
  B-V mag (n) Johnson B-V colour (T37) (phot.color;em.opt.B;em.opt.V)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  e_B-V mag (n) Standard error on B-V (T38) (stat.error;phot.color;em.opt.B)
  Q  (n) Astrometric quality flag, Q (Note T40)   (meta.code.qual)
  Fs  (n) Signal-to-noise ratio of the star image(T41) (meta.note)
  Source (char) [HPR] Source of astrometric data (Note T42)   (meta.bib)
  Nphoto  (n) Number of transits for photometry (T43) (meta.number)
  VTscat mag (n) Estimate of VTmag scatter (T44) (stat.error)
  VTmax mag (n) VTmag at maximum (15th percentile) (T45) (phot.mag;em.opt.V)
  VTmin mag (n) VTmag at minimum (85th percentile) (T46) (phot.mag;em.opt.V)
  Var (char) [GN] Known variability from GCVS/NSV (Note T47)   (meta.code;src.var)
  VarFlag (char) [UVW] Variability from Tycho (Note T48)   (src.var)
  MultFlag (char) [DRSYZ] Duplicity from Tycho (Note T49)   (meta.code.multip)
  morePhoto (char) Annex of Tycho Epoch photometry A or B, set to - for inaccessible B epoch photometry, b for reconstructed epoch photometry, c for added epoch photometry (meta.code)
timeSerie
  m_HIP (char) CCDM component identifier (T51) (meta.code.multip)
  PPM  (n) [1/789676] PPM and Supplement (Note T52)   (meta.id.cross)
  HD  (n) [1/359083] HD cat. III/135 (T53) (meta.id.cross)
  BD (char) Bonner DM I/119, I/122 (T54) (meta.id.cross)
  CoD (char) Cordoba DM I/114 (T55) (meta.id.cross)
  CPD (char) Cape Photographic DM I/108 (T56) (meta.id.cross)
  Remark (char) [JKLM] Notes (Note T57)   (meta.note)
  EpPhot  Tycho (and Hipparcos) Epoch Photometry, directly available for A, B and b types (meta.ref.url)
timeSerie
  _RA.icrs deg (n)(i) Right Ascension (ICRS, epoch 2000) computed by CDS (pos.eq.ra)
  _DE.icrs deg (n)(i) Declination (ICRS, epoch 2000) computed by CDS (pos.eq.dec)

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-04-08T14:36:36)
-3
-source=I/239/tyc_main
-ref=VIZ67f53475133212
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=5cb18c391f9b
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7
HTTP_ACCEPT_ENCODING=gzip, deflate
HTTP_CACHE_CONTROL=no-cache
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=cds:8082
HTTP_PRAGMA=no-cache
HTTP_UPGRADE_INSECURE_REQUESTS=1
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_X_FORWARDED_FOR=3.138.190.225
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=I%2F239%2Ftyc_main
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=53032
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=I%2F239%2Ftyc_main
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 963656 Mar 12 13:03 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=I/239/tyc_main
################################################################

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

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   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'):
[1744122997]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   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'):
[1744122997]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   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=1239 and tabid=15
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=1239 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=1239 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METApop' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_open(metaviz@VIZIR) gives: 1
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_query(1 'metaviz@VIZIR'):
[1744122997]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@VIZIR')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=1239): 884695 => 0.87
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   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'):
[1744122997]    Update METAhit set etime=797438197,  Ncalls = Ncalls+1 where catid=1239 and hstid=-1 and btime=796829400
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1744122997]    UPDATE METAstat set nlocal=nlocal+1, tlocal=797438197 Where phase=3 and catid=1239
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name From METAucd where ucdid>=0
....show_table(I/239/tyc_main): show_status = (11, 47, 0, 0, 1)
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=716
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=251
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1255
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=55
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=264
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1211
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=260
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=346
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1344
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=353
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=139
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=847
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=848
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=101
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=688
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=68
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=138
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=747
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=324
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=110
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=67
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=106
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=108
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=76
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=166
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=1261
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744122997]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=I/239/tyc_main
     [u] -ref=VIZ67f53475133212
====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