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

  
VI/90
  Wide-Field Plate Database (Tsvetkov+ 1997)
Post annotation
img(gal)
1.VI/90/maindata(c)Main data file (323635 rows) (released 1998-06-08)
[METAtab] [METAcola]
2.VI/90/archivesList of plate archives (294 rows) (released 1998-06-08)
[METAtab] [METAcola]
3.VI/90/qualityPlate quality data (51549 rows) (released 1998-06-08)
[METAtab] [METAcola]
4.VI/90/notesNotes (53217 rows) (released 1998-06-08)
[METAtab] [METAcola]
5.VI/90/observerObservers' names (35993 rows) (released 1998-06-08)
[METAtab] [METAcola]

 
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)IDobs (char) WFPDB observatory identifier (Note)   (meta.id;meta.main)
   (ALL)IDins cm Instrument aperture (Note)   (instr.fov)
   (ALL)IDsuf1 (char) [A-Z] Suffix to the instrument identifier (Note)   (meta.note)
  (1+3+4+5)IDno  Original plate number (Note)   (obs.field)
  (1+3+4+5)IDsuf2 (char) [A-Z] Suffix to the original plate number (Note)   (meta.note)
  (1)RAJ2000 "h:m:s" (n)(i) Right ascension (hours) (J2000.0) (pos.eq.ra;meta.main)
  (1)DEJ2000 "d:m:s" (n)(i) Declination sign (J2000.0) (pos.eq.dec;meta.main)
  (1)CCOD (char) [EMU] Code for Error, Missing data, or Uncertainty of coordinates (meta.note)
  (1)DATE "Y:M:D" (n) Date of observation, year (UT) (time.epoch)
  (1)UT "h:m:s" (n) Observation time (hour) (UT) (time.epoch)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)TCOD (char) [EMU] Code for Error, Missing data, or Uncertainty of observation time (meta.note)
  (1)OBJNAM (char) Object or field designation (obs.field)
  (1)OBJTYP (char) Object type code (Note)   (src.class)
  (1)METHOD  (n) Method of observation code (Note)   (meta.code)
  (1)MULTEX  (n) Multiplicity of exposure (meta.code.multip)
  (1)EXP min (n) Exposure time (Note)   (time.duration;obs.exposure)
  (1)EMULS (char) Emulsion type (instr.plate.emulsion)
  (1)FILT (char) Filter type (meta.code;instr.filter)
  (1)SPEC (char) Spectral band (instr.bandpass)
  (1)DIMx cm (n) X dimension of plate (phys.size;instr.plate)
  (1)DIMy cm (n) Y dimension of plate (phys.size;instr.plate)
  (1)PQUAL   [0,1] Pointer to file 'quality' (meta.code)
  (1)PNOT   [0,1] Pointer to file 'notes' (meta.note)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)POBS   [0,1] Pointer to file 'observer' (meta.code)
  (1)PAVA   [0,9] Pointer to file 'availability' (Note)   (meta.code)
  (1)PDIG   [0,1] Pointer to file 'digitisation' (Note)   (meta.code)
  (2)LOCs (char) Location of the plate archive, town (site) (meta.id;instr.obsty)
  (2)LOCc (char) Location of the plate archive, country (meta.id;instr.obsty)
  (2)OBSn (char) Observatory, name (meta.id;instr.obsty)
  (2)OBSs (char) Observatory, site (meta.id;instr.obsty)
  (2)OBSc (char) Observatory, country (meta.id;instr.obsty)
  (2)MNo  (n) Marsden's number (meta.id)
  (2)TZ- (char) Time zone, sign (meta.note)
  (2)TZ h (n) Time zone (meta.code;pos.earth.lon)
  (2)LON "d:m:s" (n) Observatory longitude, sign (pos.earth.lon)
  (2)LAT "d:m:s" (n) Observatory latitude, sign (pos.earth.lat)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (2)ALT m (n) Observatory altitude (pos.earth;instr.obsty)
  (2)MULT  (n) Multiplicity of telescope cameras (meta.code.multip)
  (2)APR m (n) Clear aperture of the telescope (phys.size;instr.tel)
  (2)MD m (n) Diameter of telescope mirror (phys.size;instr.tel)
  (2)FL m (n) Focal length of the telescope (instr.tel.focalLength)
  (2)SCL arcsec/mm(n) Plate scale (instr.scale)
  (2)ITYPE (char) Instrument type (Note)   (meta.code;instr)
  (2)FIELD deg (n) Field angular dimension (phys.angSize;src)
  (2)YEAR1 yr (n) Year of beginning of telescope operation (time.epoch)
  (2)YEAR2 yr (n) Year of end of telescope operation (time.epoch)
  (2)PF (char) [F ] Indication 'F' for 'film' (meta.note)
  (2)NPd  (n) Number of direct plates (meta.number)
  (2)NPUNd (char) [: ] Uncertainty of the number of plates (meta.note)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (2)CFORMd (char) Plate catalog form (direct plates) (Note)   (meta.code)
  (2)NPs  (n)Number of objective prism plates (meta.number)
  (2)NPUNs (char) [: ] Uncertainty of the number of plates (meta.note)
  (2)CFORMs (char) Plate catalog form (obj. prism plates) (Note)   (meta.code)
  (2)QUAL (char) [ABD ] Code for quality of the plate archive (Note)   (meta.code.qual)
  (2)ANAME (char) Astronomer in charge (obs.observer)
  (3+4+5)CONT (char) Continuation sign (1, 2, ...) or blank (meta.note)
  (3)QTEXT (char) Text of quality information (meta.code.qual)
  (4)NTEXT (char) Text of note (meta.note)
  (5)OBSNAM (char) Observer's name(s) (obs.observer)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
Adapt form
Display your selection only Reset to default columns
usage  Display UCD1+    UCD1  
.errorfile=/tmp/V-3.err (2024-09-21T02:41:52)
-3
-source=VI/90
-ref=VIZ66ee3270214699
elapse time 0

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


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

################################################################
....(in): -source=VI/90
################################################################

....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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select hstid, flag from METAhst where name='8ae129b2b46e.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'VI/90' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=6090 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=6090 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where dbaid=36
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select k.catid,k.kwdid from METAkwd k where catid=6090 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'):
[1726886512]   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'):
[1726886512]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   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'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 146/0 tuples [tested=146]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=6090 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select catid, morid, text From METAmor where catid=6090 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=3
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=4
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=5

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=6090 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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'):
[1726886512]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select catid, morid, text From METAmor where catid=6090 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=6090 and  tabid=2 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=6090 and  tabid=3 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=3
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=3
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=3
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=6090 and  tabid=4 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=4
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=4
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=4
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=6090 and  tabid=5 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=6090 and tabid=5
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=5
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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=6090 and tabid=5
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=6090 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=6090 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   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'):
[1726886512]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@VIZIR')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=6090): 672 => 0.41
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select idori, kwdid, name, explain From METAorigin
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name From METAucd where ucdid>=0
----db1_exec(0 'metaviz@VIZIR'):
[1726886512]    Update METAhit set etime=780201712,  Ncalls = Ncalls+1 where catid=6090 and hstid=-1 and btime=778420800
------------(0 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726886512]    Insert into METAhit (catid, hstid, btime, etime, Ncalls, N2list) VALUES (6090,-1,778420800,780201712, 1,0)
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726886512]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780201712 Where phase=3 and catid=6090
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726886512]    Update METAhit set etime=780201712,  N2list = N2list+2 where catid=6090 and hstid=-1 and btime=778420800
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726886512]    Update METAhit set etime=780201712,  N2list = N2list+2 where catid=6090 and hstid=-1 and btime=778420800
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726886512]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780201712 Where phase=3 and catid=6090
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726886512]    Update METAhit set etime=780201712,  N2list = N2list+2 where catid=6090 and hstid=-1 and btime=778420800
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726886512]    Update METAhit set etime=780201712,  N2list = N2list+2 where catid=6090 and hstid=-1 and btime=778420800
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726886512]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780201712 Where phase=3 and catid=6090
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name From METAfam where famid>=0
....show_tuple: show_status = (38, 46, 0, 0, 0)
====Tuple 'VI/90' from 5/0 tables:
    #6090.1 'VI/90/maindata' 27/40 columns
    #6090.2 'VI/90/archives' 33/48 columns
    #6090.3 'VI/90/quality' 8/24 columns
    #6090.4 'VI/90/notes' 8/24 columns
    #6090.5 'VI/90/observer' 8/24 columns
[0000001f] col#000 v000 OA002 VI/90/maindata*recno           
[0000001f] col#001 v004 O6003 VI/90/maindata*IDobs           
[0000001f] col#002 v000 O2043 VI/90/maindata*IDins           
[0000001f] col#003 v004 O6003 VI/90/maindata*IDsuf1          
[0000001d] col#004 v000 O2003 VI/90/maindata*IDno            
[0000001d] col#005 v004 O6003 VI/90/maindata*IDsuf2          
[00000001] col#006 v311 O10A3 VI/90/maindata*RAJ2000         
[00000001] col#007 v011 O10A3 VI/90/maindata*DEJ2000         
[00000001] col#008 v004 O4003 VI/90/maindata*CCOD            
[00000001] col#009 v020 O0083 VI/90/maindata*DATE            
[00000001] col#010 v011 O0083 VI/90/maindata*UT              
[00000001] col#011 v004 O4000 VI/90/maindata*TCOD            
[00000001] col#012 v004 O4040 VI/90/maindata*OBJNAM          
[00000001] col#013 v004 O4000 VI/90/maindata*OBJTYP          
[00000001] col#014 v000 O00C0 VI/90/maindata*METHOD          
[00000001] col#015 v000 O00C0 VI/90/maindata*MULTEX          
[00000001] col#016 v001 O0080 VI/90/maindata*EXP             
[00000001] col#017 v004 O4040 VI/90/maindata*EMULS           
[00000001] col#018 v004 O4040 VI/90/maindata*FILT            
[00000001] col#019 v004 O4000 VI/90/maindata*SPEC            
[00000001] col#020 v000 O00C0 VI/90/maindata*DIMx            
[00000001] col#021 v000 O00C0 VI/90/maindata*DIMy            
[00000001] col#022 v000 O0040 VI/90/maindata*PQUAL           
[00000001] col#023 v000 O0040 VI/90/maindata*PNOT            
[00000001] col#024 v000 O0040 VI/90/maindata*POBS            
[00000001] col#025 v000 O0040 VI/90/maindata*PAVA            
[00000001] col#026 v000 O0040 VI/90/maindata*PDIG            
[0000001f] col#000 v000 OA002 VI/90/archives*recno           
[0000001f] col#001 v004 O4003 VI/90/archives*IDobs           
[0000001f] col#002 v000 O0043 VI/90/archives*IDins           
[0000001f] col#003 v004 O4003 VI/90/archives*IDsuf1          
[00000002] col#004 v004 O4043 VI/90/archives*LOCs            
[00000002] col#005 v004 O4043 VI/90/archives*LOCc            
[00000002] col#006 v004 O4043 VI/90/archives*OBSn            
[00000002] col#007 v004 O4043 VI/90/archives*OBSs            
[00000002] col#008 v004 O4040 VI/90/archives*OBSc            
[00000002] col#009 v000 O00C0 VI/90/archives*MNo             
[00000002] col#010 v004 O4000 VI/90/archives*TZ-             
[00000002] col#011 v000 O00C0 VI/90/archives*TZ              
[00000002] col#012 v011 O0080 VI/90/archives*LON             
[00000002] col#013 v011 O0080 VI/90/archives*LAT             
[00000002] col#014 v000 O00C0 VI/90/archives*ALT             
[00000002] col#015 v000 O00C0 VI/90/archives*MULT            
[00000002] col#016 v001 O00C0 VI/90/archives*APR             
[00000002] col#017 v001 O00C0 VI/90/archives*MD              
[00000002] col#018 v001 O00C0 VI/90/archives*FL              
[00000002] col#019 v000 O00C0 VI/90/archives*SCL             
[00000002] col#020 v004 O4000 VI/90/archives*ITYPE           
[00000002] col#021 v001 O00C0 VI/90/archives*FIELD           
[00000002] col#022 v000 O00C0 VI/90/archives*YEAR1           
[00000002] col#023 v000 O00C0 VI/90/archives*YEAR2           
[00000002] col#024 v004 O4000 VI/90/archives*PF              
[00000002] col#025 v000 O0080 VI/90/archives*NPd             
[00000002] col#026 v004 O4000 VI/90/archives*NPUNd           
[00000002] col#027 v004 O4000 VI/90/archives*CFORMd          
[00000002] col#028 v000 O0080 VI/90/archives*NPs             
[00000002] col#029 v004 O4000 VI/90/archives*NPUNs           
[00000002] col#030 v004 O4000 VI/90/archives*CFORMs          
[00000002] col#031 v004 O4000 VI/90/archives*QUAL            
[00000002] col#032 v004 O4040 VI/90/archives*ANAME           
[0000001f] col#000 v000 OA002 VI/90/quality*recno           
[0000001f] col#001 v004 O4003 VI/90/quality*IDobs           
[0000001f] col#002 v000 O0043 VI/90/quality*IDins           
[0000001f] col#003 v004 O4003 VI/90/quality*IDsuf1          
[0000001d] col#004 v000 O0003 VI/90/quality*IDno            
[0000001d] col#005 v004 O4003 VI/90/quality*IDsuf2          
[0000001c] col#006 v004 O4003 VI/90/quality*CONT            
[00000004] col#007 v004 O4043 VI/90/quality*QTEXT           
[0000001f] col#000 v000 OA002 VI/90/notes*recno           
[0000001f] col#001 v004 O4003 VI/90/notes*IDobs           
[0000001f] col#002 v000 O0043 VI/90/notes*IDins           
[0000001f] col#003 v004 O4003 VI/90/notes*IDsuf1          
[0000001d] col#004 v000 O0003 VI/90/notes*IDno            
[0000001d] col#005 v004 O4003 VI/90/notes*IDsuf2          
[0000001c] col#006 v004 O4003 VI/90/notes*CONT            
[00000008] col#007 v004 O4043 VI/90/notes*NTEXT           
[0000001f] col#000 v000 OA002 VI/90/observer*recno           
[0000001f] col#001 v004 O4003 VI/90/observer*IDobs           
[0000001f] col#002 v000 O0043 VI/90/observer*IDins           
[0000001f] col#003 v004 O4003 VI/90/observer*IDsuf1          
[0000001d] col#004 v000 O0003 VI/90/observer*IDno            
[0000001d] col#005 v004 O4003 VI/90/observer*IDsuf2          
[0000001c] col#006 v004 O4003 VI/90/observer*CONT            
[00000010] col#007 v004 O4043 VI/90/observer*OBSNAM          

----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=32
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=205
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1261
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=94
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=186
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1373
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=171
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=97
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=67
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=108
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=416
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=430
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1370
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=40
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=241
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=30
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=230
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=21
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=258
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=219
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=39
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=239
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=313
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=33
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=349
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=350
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=184
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=240
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1380
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1126
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=239
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1123
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=238
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=52
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1356
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=53
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=1357
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=43
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=250
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=17
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=266
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=134
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=298
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=124
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=68
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select ucdid, name, class, explain From METAucd where ucdid=96
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726886512]   Select famid, name, explain From METAfam where famid=176
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=VI/90
     [u] -ref=VIZ66ee3270214699
====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