Looking for catalogs ..
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

  
VII/240
  Millennium Galaxy Catalogue (Liske+, 2003) Please acknowledge the usage of the Millenium Galaxy Catalog
image/fits
Post annotation
img(gal)
1.VII/240/mgczcat*Millennium Galaxy Catalogue[image/fits] (Note) (69594 rows) (released 2017-06-20)
[METAtab] [METAcola]

 
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)
  MGC  MGC object ID/serial number (=ID) (meta.id;meta.main)
  MGCFN  MGC field number (=MGCFN) (obs.field)
  CCD  CCD number (=CCD) (meta.id;instr)
  Xpos pix Object x position (=X_IMAGE) (pos.cartesian.x;instr.det)
  Ypos pix Object y position (=Y_IMAGE) (pos.cartesian.y;instr.det)
  RAJ2000 deg (i) Object right ascension (J2000) (=ALPHA_J2000) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) Object declination (J2000) (=DELTA_J2000) (pos.eq.dec;meta.main)
  a pix Flux rms along major axis (=A_IMAGE) (phys.angSize;src)
  b pix Flux rms along minor axis (=B_IMAGE) (phys.angSize;src)
  PA deg [-90,+90] Position angle (=THETA_IMAGE) (pos.posAng)

ALL cols
    
 (i)indexed column
  HLRad pix Semi-major axis of half-light ellipse (=HLRADIUS) (phys.angSize;src)
  FWHM pix FWHM assuming a Gaussian core (=FWHM_IMAGE) (phys.angSize;src)
  Bkgrnd ct Background at object position (=BACKGRND) (instr.background)
  Bmag mag Best of MAG_AUTO and MAG_ISOCOR (=B_MGC) (phot.mag;em.opt.B)
  Bmagc mag B_MGC corrected for extinction (=BMGCDC) (phot.mag;em.opt.B)
  Bmu mag/arcsec2Effective surface brightness (=MU_EFF) (phot.mag.sb;em.opt.B)
  Qual  Quality class (=QUALITY) (Note 1)   (meta.code.qual)
  Stel   [0/1] Stellaricity (=STEL) (1 for star) (src.class.starGalaxy)
  Class   [0/15] Classification parameter (=CLASS) (Note 2)   (src.class)
  xReg   [0/1] Exclusion region flag (=INEXR) (Note 3)   (meta.code)
  NSDSS  Number of SDSS objects matched to MGC object (=SDSS_N) (meta.number)
  SDSSid (char) SDSS PhotoObject ID (=SDSS_OBJID) (meta.id.cross)
  SDSSrun  SDSS run number (=SDSS_RUN) (meta.id;obs)

ALL cols
    
 (i)indexed column
  SDSSrun2  SDSS rerun number (=SDSS_RERUN) (meta.id;obs)
  SDSScam  SDSS camera column (=SDSS_CAMCOL) (meta.id;instr)
  SDSSfld  SDSS field number (=SDSS_FIELD) (obs.field)
  RA1deg deg (n) SDSS object right ascension (J2000) (=SDSS_RA) (pos.eq.ra)
  DE1deg deg (n) SDSS object declination (J2000) (=SDSS_DEC) (pos.eq.dec)
  psfUmag mag (n) SDSS extinction corrected PSF magnitude (=SDSSPSFMAGU) (phot.mag;em.opt.U)
  psfGmag mag (n) SDSS extinction corrected PSF magnitude (=SDSSPSFMAGG) (phot.mag;em.opt.B)
  psfRmag mag (n) SDSS extinction corrected PSF magnitude (=SDSSPSFMAGR) (phot.mag;em.opt.R)
  psfImag mag (n) SDSS extinction corrected PSF magnitude (=SDSSPSFMAGI) (phot.mag;em.opt.I)
  psfZmag mag (n) SDSS extinction corrected PSF magnitude (=SDSSPSFMAGZ) (phot.mag;em.opt.I)
  petUmag mag (n) SDSS extinction corrected Petrosian magnitude (=SDSSPETMAGU) (phot.mag;em.opt.U)
  petGmag mag (n) SDSS extinction corrected Petrosian magnitude (=SDSSPETMAGG) (phot.mag;em.opt.B)
  petRmag mag (n) SDSS extinction corrected Petrosian magnitude (=SDSSPETMAGR) (phot.mag;em.opt.R)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  petImag mag (n) SDSS extinction corrected Petrosian magnitude (=SDSSPETMAGI) (phot.mag;em.opt.I)
  petZmag mag (n) SDSS extinction corrected Petrosian magnitude (=SDSSPETMAGZ) (phot.mag;em.opt.I)
  modUmag mag (n) SDSS extinction corrected model magnitude (=SDSSMODMAGU) (phot.mag;em.opt.U)
  modGmag mag (n) SDSS extinction corrected model magnitude (=SDSSMODMAGG) (phot.mag;em.opt.B)
  modRmag mag (n) SDSS extinction corrected model magnitude (=SDSSMODMAGR) (phot.mag;em.opt.R)
  modImag mag (n) SDSS extinction corrected model magnitude (=SDSSMODMAGI) (phot.mag;em.opt.I)
  modZmag mag (n) SDSS extinction corrected model magnitude (=SDSSMODMAGZ) (phot.mag;em.opt.I)
  galUext mag SDSS Galactic extinction correction (=SDSSEXTINCU) (phys.absorption)
  galGext mag SDSS Galactic extinction correction (=SDSSEXTINCG) (phys.absorption)
  galRext mag SDSS Galactic extinction correction (=SDSSEXTINCR) (phys.absorption)
  galIext mag SDSS Galactic extinction correction (=SDSSEXTINCI) (phys.absorption)
  galZext mag SDSS Galactic extinction correction (=SDSSEXTINCZ) (phys.absorption)
  R50U arcsec SDSS radius containing 50% Petrosian flux (=SDSSPETR50U) (phys.angSize;src)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  R50G arcsec SDSS radius containing 50% Petrosian flux (=SDSSPETR50G) (phys.angSize;src)
  R50R arcsec SDSS radius containing 50% Petrosian flux (=SDSSPETR50R) (phys.angSize;src)
  R50I arcsec SDSS radius containing 50% Petrosian flux (=SDSSPETR50I) (phys.angSize;src)
  R50Z arcsec SDSS radius containing 50% Petrosian flux (=SDSSPETR50Z) (phys.angSize;src)
  MType   [0/6] SDSS morphological classification (=SDSS_TYPE) (src.morph.type)
  Class1   [0/8] MGC translation of MType (=SDSS_CLASS) (src.class)
  SpClass   [0/8] SDSS spectroscopic classification (=SDSS_SPECCLASS) (src.spType)
  Class2   [0/14] MGC translation of SpClass (=SDSS_SPCLASS) (src.spType)
  N2dFGRS  Number of 2dFGRS objects/spectra for this MGC object (=TDFGRS_N) (meta.number)
  2dFGRS (char) 2dFGRS (Cat. VII/226) object name (=TDFGRS_NAME) (meta.id.cross)
  ID2dFGRS  2dFGRS sequence number (=TDFGRS_SEQNUM) (meta.id)
  RA2deg deg (n) 2dFGRS object right ascension (J2000) (=TDFGRS_RA) (pos.eq.ra)
  DE2deg deg (n) 2dFGRS object declination (J2000) (=TDFGRS_DEC) (pos.eq.dec)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  UKST  UKST survey field number (=TDFGRS_UKST) (obs.field)
  bJmag mag (n) 2dFGRS final bJ magnitude (=TDFGRS_BJG) (phot.mag;em.opt.B)
  bJmagc mag (n) 2dFGRS final extinction corrected bJ magnitude (=TDGRS_BJSEL) (phot.mag;em.opt.B)
  bJmagS mag (n) SuperCOSMOS Sky Surveys (=SSS) bJ magnitude (=TDFGRS_SBBJMAG) (phot.mag;em.opt.B)
  RmagS mag (n) SSS R magnitude (=TDFGRS_SRRMAG) (phot.mag;em.opt.R)
  Class3   [0/2] 2dFGRS classification (=TDGRS_IGAL) (src.class)
  Class4   [0/1] MGC translation of Class3 (=TDFGRS_CLASS) (src.class)
  2QZ (char) 2QZ (Cat. VII/233) object name (=TQZ_NAME) (meta.id.cross)
  RA3deg deg (n) 2QZ object right ascension (J2000) (=TQZ_RA) (pos.eq.ra)
  DE3deg deg (n) 2QZ object declination (J2000) (=TQZ_DEC) (pos.eq.dec)
  UKST2qz  (n) UKST survey field number (=TQZ_UKST) (obs.field)
  bJmag2 mag (n) 2QZ bJ magnitude (=TQZ_BJ) (phot.mag;em.opt.B)
  U-bJ mag (n) 2QZ U-bJ colour (=TQZ_UMBJ) (phot.color;em.opt.U;em.opt.B)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  bJ-R mag (n) 2QZ bJ-R colour (=TQZ_BJMR) (phot.color;em.opt.B;em.opt.R)
  E(B-V) mag (n) 2QZ color excess E(B-V) (=TQZ_DUST) (phot.color.excess)
  N2qz  Number of 2QZ spectra for this MGC object (=TQZ_NOBS) (meta.number)
  T2qz (char) 2QZ type (=TQZ_IDENT) (src.class)
  Class5   [0/8] MGC translation of T2qZ (=TQZ_CLASS) (src.class)
  NNED  Number of NED objects matched to this MGC object (=NED_N) (meta.number)
  NEDname (char) NED object name (=NED_NAME) (meta.id.cross)
  RA4deg deg (n) NED object right ascension (J2000) (=NED_RA) (pos.eq.ra)
  DE4deg deg (n) NED object declination (J2000) (=NED_DEC) (pos.eq.dec)
  NEDID (char) NED identification (=NED_IDENT) (src.class)
  Class6   [0/7] MGC translation of NEDID (=NED_CLASS) (src.class)
  PFr (char) PFr (Cat. J/AJ/127/646) object name (=PF_NAME) (meta.id.cross)
  RA5deg deg (n) PFr object right ascension (J2000) (=PF_RA) (pos.eq.ra)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  DE5deg deg (n) PFr object declination (J2000) (=PF_DEC) (pos.eq.dec)
  Rmag mag (n) PFr R magnitude from USNO (=PF_R) (phot.mag;em.opt.B)
  Kmag mag (n) PFr K magnitude from 2MASS (=PF_K) (phot.mag;em.IR.K)
  J-K mag (n) PFr J-K colour from 2MASS (=PF_JMK) (phot.color;em.IR.J;em.IR.K)
  LSBG (char) LSBG (Cat. J/MNRAS/304/297) object name (=LSBG_NAME) (meta.id.cross)
  RA6deg deg (n) LSBG object right ascension (J2000) (=LSBG_RA) (pos.eq.ra)
  DE6deg deg (n) LSBG object declination (J2000) (=LSBG_DEC) (pos.eq.dec)
  BTOT mag (n) LSBG total B magnitude (=LSBG_BTOT) (phot.mag;em.opt.B)
  SuBr mag/arcsec2(n) LSBG central surface brightness (=LSBG_MUCEN) (phot.mag.sb)
  SuBreff mag/arcsec2(n) LSBG effective surface brightness (=LSBG_MUEFF) (phot.mag.sb)
  Reff arcsec (n) LSBG effective radius (=LSBG_REFF) (phys.angSize;src)
  z1  (n) MGCz heliocentric redshift (=MGCZ_ZHELIO) (src.redshift)
  q_z1  (n) MGCz redshift quality (=MGCZ_ZQUAL) (Note 4)   (meta.code.qual)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  z2  (n) SDSS redshift (=SDSS_Z) (src.redshift)
  q_z2  (n) SDSS redshift quality (=SDSS_ZQUAL) (Note 4)   (meta.code.qual)
  z3  (n) 2dFGRS heliocentric redshift (=TDFGRS_ZHELIO) (src.redshift)
  q_z3  (n) 2dFGRS redshift quality (=TDFGRS_ZQUAL) See note (Note 4)   (meta.code.qual)
  z4  (n) 2QZ redshift (=TQZ_Z) (src.redshift)
  q_z4  (n) 2QZ redshift quality (=TQZ_ZQUAL) (Note 4)   (meta.code.qual)
  z5  (n) NED heliocentric redshift (=NED_ZHELIO) (src.redshift)
  q_z5  (n) NED redshift quality (=NED_ZQUAL) (Note 4)   (meta.code.qual)
  z6  (n) PFr redshift (=PF_Z) (src.redshift)
  q_z6  (n) PFr redshift quality (=PF_ZQUAL) (Note 4)   (meta.code.qual)
  z7  (n) LSBG heliocentric redshift (=LSBG_Z) (src.redshift)
  q_z7  (n) LSBG redshift quality (=LSBG_ZQUAL) (Note 4)   (meta.code.qual)
  r_z (char) Choice for best redshift+quality (=ZSOURCE) (meta.ref)
  z  (n) Best redshift (=BEST_Z) (src.redshift)
  q_z  (n) Quality of best redshift (=BEST_ZQUAL) See note (Note 4)   (meta.code.qual)
  Nsp  Total number of spectra for this object (=N_SPEC) (meta.number)
  FITS  Get the FITS (gzipped) file with the image and spectrum of the galaxy (meta.ref)
image/fits

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/VR1385228.err (2026-08-06T20:21:42)
-2
-source=VII/240
-ref=VIZ6a74ecd615230c
elapse time 1

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


Contents of error file (/tmp/VR1385228.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=VII%2F240
REMOTE_ADDR=172.19.0.1
REMOTE_PORT=56732
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR?-source=VII%2F240
SCRIPT_FILENAME=/srv/httpd/local/cgi/VizieR
SCRIPT_NAME=/local/viz-bin/VizieR
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=VII/240
################################################################

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

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=7240 and  tabid=1 order by colid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=7240 and tabid=1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   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'):
[1786047702]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   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'):
[1786047702]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   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=7240 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   SELECT catid FROM METAcat WHERE name='7240'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=7240 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=7240 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   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'):
[1786047702]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@TAPVIZIER1')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=7240): 2479 => 0.50
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   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'):
[1786047702]    Update METAhit set etime=839362902,  Ncalls = Ncalls+1 where catid=7240 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(1 'metaviz@TAPVIZIER1'):
[1786047702]    UPDATE METAstat set nlocal=nlocal+1, tlocal=839362902 Where phase=3 and catid=7240
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name From METAucd where ucdid>=0
....show_table(VII/240/mgczcat): show_status = (13, 105, 0, 0, 1)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=94
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=171
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=17
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=233
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=398
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=26
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=1115
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=399
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=1116
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=134
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=298
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=134
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=136
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=268
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=1221
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=126
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=20
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=207
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=682
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=117
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=792
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=68
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=109
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=304
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=99
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=97
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=76
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select famid, name, explain From METAfam where famid=166
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047702]   Select ucdid, name, class, explain From METAucd where ucdid=90
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=339
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=935
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1465
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1466
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1467
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1468
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1469
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=121
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=468
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=313
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=312
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=323
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1331
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=184
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=757
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=767
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=101
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=425
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=406
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=102
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=434
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=695
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=788
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1247
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=1255
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047703]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@TAPVIZIER1')
----inherit(u=used, h=hidden):
     [u] +source=VII/240
     [u] -ref=VIZ6a74ecd615230c
====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