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/306
  The SDSS Photometric Catalog, Release 8 (Adelman-McCarthy+, 2011)
2011yCat.2306....0A
This catalogue is obsoleted by VizieR
Post annotation
img(gal)
1.II/306/sdss8Data Release 8 (469,053,874 primary sources, plus 324,960,076 secondary sources). Notice that the new reductions used for the SDSS-DR8 introduced some errors in the astrometry, especially at declinations {delta}>=41°; when possible, the astrometry of the SDSS-DR7 (Cat. II/294) should be preferred. (Note) (794013950 rows) (released 2025-11-26)
[METAtab] [METAcola]
SDSS is also available from http://www.sdss.org/

 
Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
ShowSortColumn  Constraint Explain   (UCD)
  objID  (i) SDSS unique object identifier (2) (links to SDSS-DR8 details) (Note)   (meta.id;meta.main)
  RA_ICRS deg (i) Right Ascension of the object (ICRS) (ra) (pos.eq.ra;meta.main)
  e_RA_ICRS arcsec Mean error on RAdeg (raErr) (stat.error;pos.eq.ra)
  DE_ICRS deg (i) Declination of the object (ICRS) (dec) (pos.eq.dec;meta.main)
  e_DE_ICRS arcsec Mean error on DEdeg (decErr) (stat.error;pos.eq.dec)
  mode   [1,2] 1: primary (469,053,874 sources), 2: secondary (324,960,076 sources). (qualified to =1 by default) (meta.code.class)
  q_mode (char) [+] '+' indicates clean photometry (105,969,748 sources with mode 1+) (meta.code.qual;instr.setup)
  cl  Type (class) of object (3=galaxy, 6=star) (Note 1)   (src.class)
  SDSS8 (char) (i) SDSS-DR8 name, based on J2000 position (meta.id)
  m_SDSS8 (char) [*] The asterisk indicates that 2 different SDSS objects share the same SDSS8 name (meta.code.multip)
  Im  Image from SDSS-serveur (meta.ref.url)

ALL cols
    
 (i)indexed column
  R   [8] Release inclusion (all observations were reprocessed, value is always 8) (meta.note)
  SDSS-ID (char) [0-9 -] SDSS object identifier (Note 2)   (meta.id)
  SpObjID  Pointer to the spectrum of object, or 0 (7) (Tip: to select SDSS spectroscopic sources, enter the condition *[1-9]*) (Note)   (meta.id)
  parentID  Pointer to parent (if object deblended) (meta.id.parent)
  flags  Photo Object Attribute flags (Note 3)   (meta.code.error)
  Status  Hexadecimal status (Note 4)   (meta.code)
  zsp  (n) Spectroscopic redshift (when SpObjID>0) (Note 7)   (src.redshift)
  e_zsp  (n) Mean error on zsp (Note 7)   (stat.error)
  umag mag (n)(i) Model magnitude in u filter, AB scale (u) (Note 5)   (phot.mag;em.opt.U)
  e_umag mag (n) Mean error on umag (err_u) (stat.error;phot.mag)
  gmag mag (n)(i) Model magnitude in g filter, AB scale (g) (Note 5)   (phot.mag;em.opt.B)
  e_gmag mag (n) Mean error on gmag (err_g) (stat.error;phot.mag)
  rmag mag (n)(i) Model magnitude in r filter, AB scale (r) (Note 5)   (phot.mag;em.opt.R)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_rmag mag (n) Mean error on rmag (err_r) (stat.error;phot.mag)
  imag mag (n)(i) Model magnitude in i filter, AB scale (i) (Note 5)   (phot.mag;em.opt.I)
  e_imag mag (n) Mean error on imag (err_i) (stat.error;phot.mag)
  zmag mag (n)(i) Model magnitude in z filter, AB scale (z) (Note 5)   (phot.mag;em.opt.I)
  e_zmag mag (n) Mean error on zmag (err_z) (stat.error;phot.mag)
  Q  Quality of the observation (0=unknown): 1=bad 2=acceptable 3=good 4=missing 5=hole (Note 6)   (meta.code.qual;obs.param;obs)
  ObsDate yr (i) Mean Observation date (time.epoch;obs;stat.mean)
  uFlags  Detection flags, u band (flags_u) (Note 3)   (meta.code)
  us   [0,1] 0=notStar, 1=Star in u band (probPSF_u) (src.class.starGalaxy)
  uc   [0,9] Phototype in u band, 6=Star (type_u) (Note 1)   (src.class.starGalaxy)
  uDate yr Date of observation in u band (Note 6)   (time.epoch)
  u'mag mag (n) Model magnitude in u filter (= umag) (Note 5)   (phot.mag;em.opt.U)
  e_u'mag mag (n) Mean error on u'mag (= e_umag) (stat.error;phot.mag)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  upmag mag (n) PSF magnitude in u band (psfMag_u) (phot.mag;em.opt.U)
  e_upmag mag (n) Mean error on upmag (psfMagErr_u) (stat.error;phot.mag)
  uPmag mag (n) Petrosian magnitude in u band (petroMag_u) (phot.mag;em.opt.U)
  e_uPmag mag (n) Mean error on uPmag (petroMagErr_u) (stat.error;phot.mag)
  uPrad arcsec (n) Petrosian radius in u band (petroRad_u) (phys.angSize;src)
  e_uPrad arcsec (n) Mean error in uPrad (petroRadErr_u) (stat.error)
  uoRA arcsec (n) Offset of u position along RA (offsetRa_u) (pos.angDistance)
  uoDE arcsec (n) Offset of u position along Dec (offsetDec_u) (pos.angDistance)
  udVrad arcsec (n) de Vaucouleurs fit radius, u band (deVRad_u) (phys.angSize;src)
  udVell arcsec (n) de Vaucouleurs fit ellipt, u band (1-deVAB_u) (src.ellipticity)
  uPA deg (n) Position angle of dVrad in u band (deVPhi_u) (pos.posAng)
  gFlags  Detection flags, g band (flags_g) (Note 3)   (meta.code)
  gs   [0,1] 0=notStar, 1=Star in g band (probPSF_g) (src.class.starGalaxy)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  gc   [0,9] Phototype in g band, 6=Star (type_g) (Note 1)   (src.class.starGalaxy)
  gDate yr Date of observation in g band (Note 6)   (time.epoch)
  g'mag mag (n) Model magnitude in g filter (= gmag) (Note 5)   (phot.mag;em.opt.B)
  e_g'mag mag (n) Mean error on g'mag (= e_gmag) (stat.error;phot.mag)
  gpmag mag (n) PSF magnitude in g band (psfMag_g) (phot.mag;em.opt.B)
  e_gpmag mag (n) Mean error on gpmag (psfMagErr_g) (stat.error;phot.mag)
  gPmag mag (n) Petrosian magnitude in g band (petroMag_g) (phot.mag;em.opt.B)
  e_gPmag mag (n) Mean error on gPmag (petroMagErr_g) (stat.error;phot.mag)
  gPrad arcsec (n) Petrosian radius in g band (petroMagErr_g) (phys.angSize;src)
  e_gPrad arcsec (n) Mean error in gPrad (petroMagErr_g) (stat.error)
  goRA arcsec (n) Offset of g position along RA (offsetRa_g) (pos.angDistance)
  goDE arcsec (n) Offset of g position along Dec (offsetDec_g) (pos.angDistance)
  gdVrad arcsec (n) de Vaucouleurs fit radius, g band (deVRad_g) (phys.angSize;src)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  gdVell arcsec (n) de Vaucouleurs fit ellipt, g band (1-deVAB_g) (src.ellipticity)
  gPA deg (n) Position angle of dVrad in g band (deVPhi_g) (pos.posAng)
  rFlags  Detection flags, r band (flags_r) (Note 3)   (meta.code)
  rs   [0,1] 0=notStar, 1=Star in r band (probPSF_r) (src.class.starGalaxy)
  rc   [0,9] Phototype in r band, 6=Star (type_r) (Note 1)   (src.class.starGalaxy)
  rDate yr Date of observation in r band (Note 6)   (time.epoch)
  r'mag mag (n) Model magnitude in r filter (= rmag) (Note 5)   (phot.mag;em.opt.R)
  e_r'mag mag (n) Mean error on r'mag (= e_rmag) (stat.error;phot.mag)
  rpmag mag (n) PSF magnitude in r band (psfMag_r) (phot.mag;em.opt.R)
  e_rpmag mag (n) Mean error on rpmag (psfMagErr_r) (stat.error;phot.mag)
  rPmag mag (n) Petrosian magnitude in r band (petroMag_r) (phot.mag;em.opt.R)
  e_rPmag mag (n) Mean error on rPmag (petroMagErr_r) (stat.error;phot.mag)
  rPrad arcsec (n) Petrosian radius in r band (petroMagErr_r) (phys.angSize;src)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_rPrad arcsec (n) Mean error in rPrad (petroMagErr_r) (stat.error)
  roRA arcsec (n) Offset of r position along RA (offsetRa_r) (pos.angDistance)
  roDE arcsec (n) Offset of r position along Dec (offsetDec_r) (pos.angDistance)
  rdVrad arcsec (n) de Vaucouleurs fit radius, r band (deVRad_r) (phys.angSize;src)
  rdVell arcsec (n) de Vaucouleurs fit ellipt, r band (1-deVAB_r) (src.ellipticity)
  rPA deg (n) Position angle of dVrad in r band (deVPhi_r) (pos.posAng)
  iFlags  Detection flags, i band (flags_i) (Note 3)   (meta.code)
  is   [0,1] 0=notStar, 1=Star in i band (probPSF_i) (src.class.starGalaxy)
  ic   [0,9] Phototype in i band, 6=Star (type_i) (Note 1)   (src.class.starGalaxy)
  iDate yr Date of observation in i band (Note 6)   (time.epoch)
  i'mag mag (n) Model magnitude in i filter (= imag) (Note 5)   (phot.mag;em.opt.I)
  e_i'mag mag (n) Mean error on i'mag (= e_imag) (stat.error;phot.mag)
  ipmag mag (n) PSF magnitude in i band (psfMag_i) (phot.mag;em.opt.I)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_ipmag mag (n) Mean error on ipmag (psfMagErr_i) (stat.error;phot.mag)
  iPmag mag (n) Petrosian magnitude in i band (petroMag_i) (phot.mag;em.opt.I)
  e_iPmag mag (n) Mean error on iPmag (petroMagErr_i) (stat.error;phot.mag)
  iPrad arcsec (n) Petrosian radius in i band (petroMagErr_i) (phys.angSize;src)
  e_iPrad arcsec (n) Mean error in iPrad (petroMagErr_i) (stat.error)
  ioRA arcsec (n) Offset of i position along RA (offsetRa_i) (pos.angDistance)
  ioDE arcsec (n) Offset of i position along Dec (offsetDec_i) (pos.angDistance)
  idVrad arcsec (n) de Vaucouleurs fit radius, i band (deVRad_i) (phys.angSize;src)
  idVell arcsec (n) de Vaucouleurs fit ellipt, i band (1-deVAB_i) (src.ellipticity)
  iPA deg (n) Position angle of dVrad in i band (deVPhi_i) (pos.posAng)
  zFlags  Detection flags, z band (flags_z) (Note 3)   (meta.code)
  zs   [0,1] 0=notStar, 1=Star in z band (probPSF_z) (src.class.starGalaxy)
  zc   [0,9] Phototype in z band, 6=Star (type_z) (Note 1)   (src.class.starGalaxy)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  zDate yr Date of observation in z band (Note 6)   (time.epoch)
  z'mag mag (n) Model magnitude in z filter (= zmag) (Note 5)   (phot.mag;em.opt.I)
  e_z'mag mag (n) Mean error on z'mag (= e_zmag) (stat.error;phot.mag)
  zpmag mag (n) PSF magnitude in z band (psfMag_z) (phot.mag;em.opt.I)
  e_zpmag mag (n) Mean error on zpmag (psfMagErr_z) (stat.error;phot.mag)
  zPmag mag (n) Petrosian magnitude in z band (petroMag_z) (phot.mag;em.opt.I)
  e_zPmag mag (n) Mean error on zPmag (petroMagErr_z) (stat.error;phot.mag)
  zPrad arcsec (n) Petrosian radius in z band (petroMagErr_z) (phys.angSize;src)
  e_zPrad arcsec (n) Mean error in zPrad (petroMagErr_z) (stat.error)
  zoRA arcsec (n) Offset of z position along RA (offsetRa_z) (pos.angDistance)
  zoDE arcsec (n) Offset of z position along Dec (offsetDec_z) (pos.angDistance)
  zdVrad arcsec (n) de Vaucouleurs fit radius, z band (deVRad_z) (phys.angSize;src)
  zdVell arcsec (n) de Vaucouleurs fit ellipt, z band (1-deVAB_z) (src.ellipticity)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  zPA deg (n) Position angle of dVrad in z band (deVPhi_z) (pos.posAng)
  pmRA mas/yr (n) Proper motion along RightAscension (pmRa) (Note 8)   (pos.pm;pos.eq.ra)
  e_pmRA mas/yr (n) Mean error on pmRA (pmRaErr) (Note 8)   (stat.error;pos.pm;pos.eq.ra)
  pmDE mas/yr (n) Proper motion along Declination (pmDec) (Note 8)   (pos.pm;pos.eq.dec)
  e_pmDE mas/yr (n) Mean error on pmDE (pmDecErr) (Note 8)   (stat.error;pos.pm;pos.eq.dec)
  sigRA arcsec (n) RMS residual of proper motion fit in RA (Note 8)   (stat.fit.residual)
  sigDE arcsec (n) RMS residual of proper motion fit in Dec (Note 8)   (stat.fit.residual)
  M  Number of USNO-B objects matched within 1arcsec (match) (Note 8)   (meta.number)
  N  Number of detections used in the pm fit, including SDSS (nFit) (Note 8)   (meta.number)
  g(O) mag (n) Magnitude from O plate recalibrated to g (Note 8)   (phot.mag;em.opt.B)
  r(E) mag (n) Magnitude from E plate recalibrated to r (Note 8)   (phot.mag;em.opt.R)
  g(J) mag (n) Magnitude from J plate recalibrated to g (Note 8)   (phot.mag;em.opt.B)
  r(F) mag (n) Magnitude from F plate recalibrated to r (Note 8)   (phot.mag;em.opt.R)
  i(N) mag (n) Magnitude from N plate recalibrated to i (Note 8)   (phot.mag;em.opt.I)

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/VR239416.err (2026-08-06T15:22:54)
-3
-source=II/306
-ref=VIZ6a74a6ce3a738
elapse time 0

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


Contents of error file (/tmp/VR239416.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%2F306
REMOTE_ADDR=172.19.0.1
REMOTE_PORT=35492
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=II%2F306
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/306
################################################################

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

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   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'):
[1786029774]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   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'):
[1786029774]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   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=2306 and tabid=1
#...meta_close(1): retrieved 6/1000 tuples [tested=6]
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   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'):
[1786029774]   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'):
[1786029774]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select catid, tabid, colid, time_rel_id From METAtimeRel where catid=2306 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 1
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   SELECT catid FROM METAcat WHERE name='2306'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=2306 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=2306 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   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'):
[1786029774]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@TAPVIZIER1')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=2306): 205701 => 0.78
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   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'):
[1786029774]    Update METAhit set etime=839344974,  Ncalls = Ncalls+1 where catid=2306 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(1 'metaviz@TAPVIZIER1'):
[1786029774]    UPDATE METAstat set nlocal=nlocal+1, tlocal=839344974 Where phase=3 and catid=2306
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name From METAucd where ucdid>=0
....show_table(II/306/sdss8): show_status = (20, 108, 0, 0, 1)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=63
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=93
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=68
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=45
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=109
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=97
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=67
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=108
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=313
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=77
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=185
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=64
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1247
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=935
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1465
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1466
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1467
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1468
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1469
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=97
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=90
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=359
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=304
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=99
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=134
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=298
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=134
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=228
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1166
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1136
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=307
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=953
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=268
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1221
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=356
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=150
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=754
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=767
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786029774]   Select famid, name, explain From METAfam where famid=762
----db1_reset(0 'metaviz@TAPVIZIER1')
----inherit(u=used, h=hidden):
     [u] +source=II/306
     [u] -ref=VIZ6a74a6ce3a738
====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