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

  
II/252
  The DENIS database, 2nd Release (DENIS Consortium, 2003)
This catalogue is obsoleted by B/denis
Post annotation
img(gal)
1.II/252/denis2nd release of DENIS (195 million sources) (195204157 rows) (released 2025-01-28)
[METAtab] [METAcola]
See also the DENIS home page

 
Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
ShowSortColumn  Constraint Explain   (UCD)
  RAJ2000 deg (i) Right ascension (J2000) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) Declination (J2000) (pos.eq.dec;meta.main)
  Image  DENIS image number (Note 1)   (meta.id;obs)
  Strip  DENIS strip number (obs.field)
  Imag mag (n)Magnitude in I band from PSF fit (phot.mag;em.opt.I)
  e_Imag mag (n)Magnitude error in I band from PSF fit (stat.error;phot.mag)
  Jmag mag (n)Magnitude in J band from PSF fit (phot.mag;em.IR.J)
  e_Jmag mag (n)Magnitude error in J band from PSF fit (stat.error;phot.mag)
  Kmag mag (n)Magnitude in K band from PSF fit (phot.mag;em.IR.K)
  e_Kmag mag (n)Magnitude error in K band from PSF fit (stat.error;phot.mag)
  Imag5.5 mag (n)Magnitude in I band from 5.5'' aperture (phot.mag;em.opt.I)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Imag5.5 mag (n)Error in I band mag from 5.5'' aperture (stat.error)
  Jmag5.5 mag (n)Magnitude in J band from 5.5'' aperture (phot.mag;em.IR.J)
  e_Jmag5.5 mag (n)Error in J band mag from 5.5'' aperture (stat.error)
  Kmag5.5 mag (n)Magnitude in K band from 5.5'' aperture (phot.mag;em.IR.K)
  e_Kmag5.5 mag (n)Error in K band mag from 5.5'' aperture (stat.error)
  Imag4.5 mag (n)Magnitude in I band from 4.5'' aperture (phot.mag;em.opt.I)
  e_Imag4.5 mag (n)Error in I band mag from 4.5'' aperture (stat.error)
  Jmag4.5 mag (n)Magnitude in J band from 4.5'' aperture (phot.mag;em.IR.J)
  e_Jmag4.5 mag (n)Error in J band mag from 4.5'' aperture (stat.error)
  Kmag4.5 mag (n)Magnitude in K band from 4.5'' aperture (phot.mag;em.IR.K)
  e_Kmag4.5 mag (n)Error in K band mag from 4.5'' aperture (stat.error)
  Imag3.5 mag (n)Magnitude in I band from 3.5'' aperture (phot.mag;em.opt.I)
  e_Imag3.5 mag (n)Error in I band mag from 3.5'' aperture (stat.error)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Jmag3.5 mag (n)Magnitude in J band from 3.5'' aperture (phot.mag;em.IR.J)
  e_Jmag3.5 mag (n)Error in J band mag from 3.5'' aperture (stat.error)
  Kmag3.5 mag (n)Magnitude in K band from 3.5'' aperture (phot.mag;em.IR.K)
  e_Kmag3.5 mag (n)Error in K band mag from 3.5'' aperture (stat.error)
  Imag3.5c mag (n)I band Magnitude in 3.5'' corrected aperture (phot.mag;em.opt.I)
  e_Imag3.5c mag (n)I band mag error in 3.5'' corrected aperture (stat.error)
  Jmag3.5c mag (n)J band Magnitude in 3.5'' corrected aperture (phot.mag;em.IR.J)
  e_Jmag3.5c mag (n)J band mag error in 3.5'' corrected aperture (stat.error)
  Kmag3.5c mag (n)K band Magnitude in 3.5'' corrected aperture (phot.mag;em.IR.K)
  e_Kmag3.5c mag (n)K band mag error in 3.5'' corrected aperture (stat.error)
  Imag2.5c mag (n)I band Magnitude in 2.5'' corrected aperture (phot.mag;em.opt.I)
  e_Imag2.5c mag (n)I band mag error in 2.5'' corrected aperture (stat.error)
  Jmag2.5c mag (n)J band Magnitude in 2.5'' corrected aperture (phot.mag;em.IR.J)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Jmag2.5c mag (n)J band mag error in 2.5'' corrected aperture (stat.error)
  Kmag2.5c mag (n)K band Magnitude in 2.5'' corrected aperture (phot.mag;em.IR.K)
  e_Kmag2.5c mag (n)K band mag error in 2.5'' corrected aperture (stat.error)
  Imag1.5c mag (n)I band Magnitude in 1.5'' corrected aperture (phot.mag;em.opt.I)
  e_Imag1.5c mag (n)I band mag error in 1.5'' corrected aperture (stat.error)
  Jmag1.5c mag (n)J band Magnitude in 1.5'' corrected aperture (phot.mag;em.IR.J)
  e_Jmag1.5c mag (n)J band mag error in 1.5'' corrected aperture (stat.error)
  Kmag1.5c mag (n)K band Magnitude in 1.5'' corrected aperture (phot.mag;em.IR.K)
  e_Kmag1.5c mag (n)K band mag error in 1.5'' corrected aperture (stat.error)
  Rmag mag (n)R magnitude of USNOA2.0 nearest match (phot.mag;em.opt.R)
  Bmag mag (n)B magnitude of USNOA2.0 nearest match (phot.mag;em.opt.B)
  q_Imag  (n) [0,100]Quality flag for I band (100=top) (meta.code.qual)
  q_Jmag  (n) [0,100]Quality flag for J band (100=top) (meta.code.qual)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  q_Kmag  (n) [0,100]Quality flag for K band (100=top) (meta.code.qual)
  Ipsf % (n) [0,100]Correlation to PSF for I band (Note 4)   (src.class.starGalaxy)
  Jpsf % (n) [0,100]Correlation to PSF for J band (Note 4)   (src.class.starGalaxy)
  Kpsf % (n) [0,100]Correlation to PSF for K band (Note 4)   (src.class.starGalaxy)
  IMpsf  (n) [0,1]Mean correlation to PSF in I band (Note 4)   (stat.correlation)
  JMpsf  (n) [0,1]Mean correlation to PSF in J band (Note 4)   (stat.correlation)
  KMpsf  (n) [0,1]Mean correlation to PSF in K band (Note 4)   (stat.correlation)
  Ix pix (n)Pixel x position in I band (pos.cartesian.x)
  Iy pix (n)Pixel y position in I band (pos.cartesian.y)
  Jx pix (n)Pixel x position in J band (pos.cartesian.x)
  Jy pix (n)Pixel y position in J band (pos.cartesian.y)
  Kx pix (n)Pixel x position in K band (pos.cartesian.x)
  Ky pix (n)Pixel y position in K band (pos.cartesian.y)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  A2RAdeg deg (n)Right Ascension of USNOA2.0 nearest match (pos.eq.ra)
  A2DEdeg deg (n)Declination of USNOA2.0 nearest match (pos.eq.dec)
  A2Ep yr (n)Epoch of USNOA2.0 nearest match (time.epoch)
  Dist mas (n)Distance to USNOA2.0 nearest match (pos.angDistance)
  ObsJD d (i) Julian day for DENIS observation (time.epoch)
  Iflg (char) Image and source flag in I band (Note 2)   (meta.code)
  Jflg (char) Image and source flag in J band (Note 2)   (meta.code)
  Kflg (char) Image and source flag in K band (Note 2)   (meta.code)
  mult  (n)Multiplicity flag (Note 3)   (meta.code.multip)
  Opt  Display the close Optical sources from USNO and GSC catalogues (meta.ref.url)
  DENIS (char) (i) DENIS name, identifier (meta.id;meta.main)

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/VR308056.err (2026-08-06T15:43:42)
-3
-source=II/252
-ref=VIZ6a74abae4b358
elapse time 0

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


Contents of error file (/tmp/VR308056.err):
....vizier, Version 7.5.8
CDSportal=http://cdsportal.cds.unistra.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=3cc090d0de86
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=localhost:8081
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_X_FORWARDED_FOR=216.73.217.111, 127.0.0.1
HTTP_X_FORWARDED_HOST=tapvizier1.u-strasbg.fr
HTTP_X_FORWARDED_SERVER=tapvizier1.cds.unistra.fr
LC_ALL=C
LD_LIBRARY_PATH=/srv/httpd/../lib:/srv/lib:/usr/local/lib:/usr/lib
LOGNAME=root
MACHTYPE=x86_64
MAX_UPLOADS=100000
METADB=metaviz@TAPVIZIER1 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
QUERY_STRING=-source=II%2F252
REMOTE_ADDR=172.19.0.1
REMOTE_PORT=41140
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=II%2F252
SCRIPT_FILENAME=/srv/httpd/local/cgi/VizieR-3
SCRIPT_NAME=/local/viz-bin/VizieR-3
SERVER_ADDR=172.19.0.3
SERVER_ADMIN=gilles.landais@astro.u-strasbg.fr
SERVER_NAME=localhost
SERVER_PORT=8081
SERVER_PROTOCOL=HTTP/1.1
SERVER_SIGNATURE=
SERVER_SOFTWARE=Apache/2.4.66 (Unix)
SESAME_SERVER=glu
SHLVL=1
USER=root
VENDOR=unknown
VIZCLONE_STATISTICS=no
Vaccess=*
Vprog=/srv/httpd/bin/vizier
Vprog_ls=-rwxr-xr-x 1 root root 974128 Aug  5 14:41 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=II/252
################################################################

....Trying '/srv/httpd/interfaces' => OK
....Trying '/srv/httpd/interfaces' => 3
....db1_interfaces(/srv/httpd/interfaces)
----db1_open(metaviz@TAPVIZIER1) gives: 0
----Open server: tapvizier1.cds.unistra.fr, port 5434 (type postgres base vizier)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select hstid, flag from METAhst where name='3cc090d0de86.astro.unistra.fr'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'II/252' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=2252 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=2252 order by tabid
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786031022]    insert into T1 values(2252)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@TAPVIZIER1'):
[1786031022]    insert into T2 values(2252)
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   select login from METAdba where login like 'large_tables%'
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 147/0 tuples [tested=147]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   SELECT catid FROM METAcat WHERE name='2252'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=2252 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=2252 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=2252 order by catid,tabid,colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select catid, morid, text From METAmor where catid=2252 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   select filename from METAtab where catid=2252 and tabid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   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 = 'METAqin'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select colid, off7, length, sep, fnull From METAqin where catid=2252 and tabid=1 and sep between 1 and 127 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=2252 and tabid=1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=9 and fltrid=8
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=9 and fltrid=6
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=54 and fltrid=5
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=2252 and  tabid=1 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   select filename from METAtab where catid=2252 and tabid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select colid, off7, length, sep, fnull From METAqin where catid=2252 and tabid=1 and sep between 1 and 127 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=2252 and tabid=1

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1'):
[1786031022]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, flags From METAtime where catid=2252 and tabid=1
#...meta_close(1): retrieved 1/1000 tuples [tested=1]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAtimeRel' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   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=49 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select catid, tabid, colid, time_rel_id From METAtimeRel where catid=2252 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   SELECT catid FROM METAcat WHERE name='2252'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=2252 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=2252 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   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@TAPVIZIER1')
----db1_open(metaviz@TAPVIZIER1) gives: 1
----Open server: tapvizier1.cds.unistra.fr, port 5434 (type postgres base vizier)
----db1_query(1 'metaviz@TAPVIZIER1'):
[1786031022]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@TAPVIZIER1')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=2252): 716 => 0.42
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select idori, kwdid, name, explain From METAorigin
----db1_open(metaviz@TAPVIZIER1) gives: 1
----Open server: tapvizier1.cds.unistra.fr, port 5434 (type postgres base vizier)
----db1_exec(1 'metaviz@TAPVIZIER1'):
[1786031022]    Update METAhit set etime=839346222,  Ncalls = Ncalls+1 where catid=2252 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(1 'metaviz@TAPVIZIER1'):
[1786031022]    UPDATE METAstat set nlocal=nlocal+1, tlocal=839346222 Where phase=3 and catid=2252
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name From METAucd where ucdid>=0
....show_table(II/252/denis): show_status = (13, 60, 0, 0, 1)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=90
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=330
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=94
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=186
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=447
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=693
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=767
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=754
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=68
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=109
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=304
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=99
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=346
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1344
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=398
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1115
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=399
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1116
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1367
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=228
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1110
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=67
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=108
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786031022]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@TAPVIZIER1')
----inherit(u=used, h=hidden):
     [u] +source=II/252
     [u] -ref=VIZ6a74abae4b358
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@TAPVIZIER1')
----db1_close(1 'metaviz@TAPVIZIER1')

Cite/acknowledge VizieR catalogue
Rules of usage of VizieR data

© UDS/CNRS

Contact