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/358
  SkyMapper Southern Sky Survey. DR1.1 (Wolf+, 2018)
Post annotation
img(gal)
1.II/358/smssSkyMapper DR1.1 (original column names in green) (285159194 rows) (released 2025-10-16)
[METAtab] [METAcola]

 
Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
Standard Original
ShowSortColumn  Constraint Explain   (UCD)
  ObjectId  (i) Global unique object ID in the master table (object_id) (meta.id;meta.main)
  RAICRS deg (i) Mean ICRS Right Ascension of the object (raj2000) (pos.eq.ra;meta.main)
  DEICRS deg (i) Mean ICRS Declination of the object (dej2000) (pos.eq.dec;meta.main)
  e_RAICRS mas RMS variation around the mean Right Ascension, in milliarcseconds (e_raj2000) (stat.error;pos.eq.ra)
  e_DEICRS mas RMS variation around the mean Declination, in milliarcseconds (e_dej2000) (stat.error;pos.eq.dec)
  SMSS (char) (i) SkyMapper Southern Survey designation of the form SMSS Jhhmmss.ss±ddmmss.s, derived from mean ICRS coordinates (HHMMSS.s+DDMMSS.s) (smss_j) (meta.id)
  EpMean d Mean MJD epoch of the observations (mean_epoch) (time.epoch;stat.mean)
  e_EpMean d (n) RMS variation around the mean epoch (rms_epoch) (stat.stdev;time.epoch)
  GLON deg Galactic longitude derived from ICRS coordinates. Not to be used as primary astrometric reference (glon) (pos.galactic.lon)
  GLAT deg Galactic latitude derived from ICRS coordinates. Not to be used as primary astrometric reference (glat) (pos.galactic.lat)
  flags   [0/4096] Bitwise OR of Source Extractor flags across all observations (flags) (Note 1)   (meta.code)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Niflags  Total number of flagged pixels from bad, saturated, and crosstalk pixel masks across all observations (nimaflags) (meta.code)
  Ngood   [1/91] Number of observations used across all filters (ngood) (meta.number)
  Ngoodmin   [0/11] Minimum number of observations used in any filter (excluding filters with 0 observations) (ngood_min) (meta.number)
  Nchmax   [1/5] Maximum number of child sources combined into this global object_id in any filter (nch_max) (meta.number)
  flagsu   [-1/100] Bitwise OR of Source Extractor flags from u-band measurements in photometry table (u_flags) (Note 1)   (meta.code)
  Niflagsu  (n) Number of flagged pixels from bad, saturated, and crosstalk pixel masks from u-band measurements in photometry table (u_nimaflags) (meta.code)
  Ngoodu  Number of u-band observations used (u_ngood) (meta.number)
  Nchu   [-1/4] Number of u-band child sources combined into this object_id (u_nch) (meta.number)
  Nvisitu   [0/35] Number of u-band observations for which the mean RA/Dec position fell on a CCD (u_nvisit) (meta.number)
  flagsv   [-1/45] Bitwise OR of Source Extractor flags from v-band measurements in photometry table (v_flags) (Note 1)   (meta.code)
  Niflagsv  (n) Number of flagged pixels from bad, saturated, and crosstalk pixel masks from v-band measurements in photometry table (v_nimaflags) (meta.code)
  Ngoodv   [0/19] Number of v-band observations used (v_ngood) (meta.number)
  Nchv   [-1/4] Number of v-band child sources combined into this object_id (v_nch) (meta.number)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Nvisitv   [0/16] Number of v-band observations for which the mean RA/Dec position fell on a CCD (v_nvisit) (meta.number)
  flagsg   [-1/56] Bitwise OR of Source Extractor flags from g-band measurements in photometry table (g_flags) (Note 1)   (meta.code)
  Niflagsg  (n) Number of flagged pixels from bad, saturated, and crosstalk pixel masks from g-band measurements in photometry table (g_nimaflags) (meta.code)
  Ngoodg  Number of g-band observations used (g_ngood) (meta.number)
  Nchg   [-1/4] Number of g-band child sources combined into this object_id (g_nch) (meta.number)
  Nvisitg   [0/17] Number of g-band observations for which the mean RA/Dec position fell on a CCD (g_nvisit) (meta.number)
  flagsr   [-1/60] Bitwise OR of Source Extractor flags from r-band measurements in photometry table (r_flags) (Note 1)   (meta.code)
  Niflagsr  (n) Number of flagged pixels from bad, saturated, and crosstalk pixel masks from r-band measurements in photometry table (r_nimaflags) (meta.code)
  Ngoodr  Number of r-band observations used (r_ngood) (meta.number)
  Nchr   [-1/5] Number of r-band child sources combined into this object_id (r_nch) (meta.number)
  Nvisitr   [0/17] Number of r-band observations for which the mean RA/Dec position fell on a CCD (r_nvisit) (meta.number)
  flagsi   [-1/49] Bitwise OR of Source Extractor flags from i-band measurements in photometry table (i_flags) (Note 1)   (meta.code)
  Niflagsi  (n) Number of flagged pixels from bad, saturated, and crosstalk pixel masks from i-band measurements in photometry table (i_nimaflags) (meta.code)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Ngoodi   [0/16] Number of i-band observations used (i_ngood) (meta.number)
  Nchi   [-1/5] Number of i-band child sources combined into this object_id (i_nch) (meta.number)
  Nvisiti   [0/12] Number of i-band observations for which the mean RA/Dec position fell on a CCD (i_nvisit) (meta.number)
  flagsz   [-1/50] Bitwise OR of Source Extractor flags from z-band measurements in photometry table (z_flags) (Note 1)   (meta.code)
  Niflagsz  (n) Number of flagged pixels from bad, saturated, and crosstalk pixel masks from z-band measurements in photometry table (z_nimaflags) (meta.code)
  Ngoodz   [0/16] Number of z-band observations used (z_ngood) (meta.number)
  Nchz   [-1/5] Number of z-band child sources combined into this object_id (z_nch) (meta.number)
  Nvisitz   [0/11] Number of z-band observations for which the mean RA/Dec position fell on a CCD (z_nvisit) (meta.number)
  ClassStar  Maximum stellarity index from photometry table (between 0=no star and 1=star) (class_star) (src.class.starGalaxy;stat.mean)
  RadrPetro pix Mean r-band Petrosian radius (radius_petro) (phys.angSize;stat.mean)
  a pix Mean r-band semi-major axis length (a) (phys.angSize.smajAxis;stat.mean)
  e_a pix Error in mean r-band semi-major axis length (e_a) (stat.error;phys.angSize.smajAxis)
  b pix Mean r-band semi-minor axis length (b) (phys.angSize.sminAxis;stat.mean)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_b pix Error in mean r-band semi-minor axis length (e_b) (stat.error;phys.angSize.sminAxis)
  PA deg [-90/90] Mean r-band position angle (E of N, -90..+90 deg) (pa) (pos.posAng;stat.mean)
  e_PA deg Error in mean r-band position angle (e_pa) (stat.error;pos.posAng)
  uPSF mag (n) Mean u-band PSF magnitude (u_psf) (phot.mag;stat.mean)
  e_uPSF mag (n) Error in u-band PSF magnitude (e_u_psf) (stat.error;phot.mag)
  uPetro mag (n) Mean u-band Petrosian magnitude (u_petro) (phot.mag;stat.mean)
  e_uPetro mag (n) Error in u-band Petrosian magnitude (e_u_petro) (stat.error;phot.mag)
  vPSF mag (n) Mean v-band PSF magnitude (v_psf) (phot.mag;em.opt.V)
  e_vPSF mag (n) Error in v-band PSF magnitude (e_v_psf) (stat.error)
  vPetro mag (n) Mean v-band Petrosian magnitude (v_petro) (phot.mag;em.opt.V)
  e_vPetro mag (n) Error in v-band Petrosian magnitude (e_v_petro) (stat.error)
  gPSF mag (n) Mean g-band PSF magnitude (g_psf) (phot.mag;stat.mean)
  e_gPSF mag (n) Error in g-band PSF magnitude (e_g_psf) (stat.error;phot.mag)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  gPetro mag (n) Mean g-band Petrosian magnitude (g_petro) (phot.mag;stat.mean)
  e_gPetro mag (n) Error in g-band Petrosian magnitude (e_g_petro) (stat.error;phot.mag)
  rPSF mag (n) Mean r-band PSF magnitude (r_psf) (phot.mag;stat.mean)
  e_rPSF mag (n) Error in r-band PSF magnitude (e_r_psf) (stat.error;phot.mag)
  rPetro mag (n) Mean r-band Petrosian magnitude (r_petro) (phot.mag;stat.mean)
  e_rPetro mag (n) Error in r-band Petrosian magnitude (e_r_petro) (stat.error;phot.mag)
  iPSF mag (n) Mean i-band PSF magnitude (i_psf) (phot.mag;stat.mean)
  e_iPSF mag (n) Error in i-band PSF magnitude (e_i_psf) (stat.error;phot.mag)
  iPetro mag (n) Mean i-band Petrosian magnitude (i_petro) (phot.mag;stat.mean)
  e_iPetro mag (n) Error in i-band Petrosian magnitude (e_i_petro) (stat.error;phot.mag)
  zPSF mag (n) Mean z-band PSF magnitude (z_psf) (phot.mag;stat.mean)
  e_zPSF mag (n) Error in z-band PSF magnitude (e_z_psf) (stat.error;phot.mag)
  zPetro mag (n) Mean z-band Petrosian magnitude (z_petro) (phot.mag;stat.mean)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_zPetro mag (n) Error in z-band Petrosian magnitude (e_z_petro) (stat.error;phot.mag)
  E(B-V) mag E(B-V) from Schlegel et al. (1998ApJ...500..525S) extinction maps at the ICRS coordinates (ebmv_sfd) (phot.color.excess;phys.absorption)
  Prox arcsec Distance to next-closest DR1 source (=60 if no sources within 15 arcsec) (prox) (pos.angDistance)
  ProxId  (n) object_id of next-closest DR1 source (prox_id) (meta.id)
  EDRId  (n) object_id of closest Early Data Release source (edr_id) (meta.id.cross)
  EDRDist arcsec (n) Distance to closest Early Data Release source (edr_dist) (pos.angDistance)
  2MASSKey1  (n) Unique identifier (ptskey/extkey) of closest 2MASS source (twomass_key1) (meta.id.cross)
  2MASSDist1 arcsec (n) Distance on sky to closest 2MASS source (twomass_dist1) (pos.angDistance)
  2MASSCat1 (char) [cpsx -] 2MASS catalogue of closest match (point source PSC, or extended XSC) (twomass_cat1) (meta.code)
  2MASSKey2  (n) Unique identifier (ptskey/extkey) of second closest 2MASS source (twomass_key2) (meta.id.cross)
  2MASSDist2 arcsec (n) Distance on sky to second closest 2MASS source (twomass_dist2) (pos.angDistance)
  2MASSCat2 (char) [cpsx -] 2MASS catalogue of second closest match (point source PSC, or extended XSC) (twomass_cat2) (meta.code)
  ALLWISECntr  (n) Unique identifier (cntr) of closest AllWISE source (allwise_cntr) (meta.id.cross)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  ALLWISEDist arcsec (n) Distance on sky to closest AllWISE source (allwise_dist) (pos.angDistance)
  UCAC4Mpos  (n) Unique identifier (mpos) of closest UCAC4 source (ucac4_mpos) (meta.id.cross)
  UCAC4Dist arcsec (n) Distance on sky to closest UCAC4 source (ucac4_dist) (pos.angDistance)
  APASSRecno  (n) Unique identifier (recno) of closest APASS DR9 source (only useful for this copy of APASS) (apass_recno) (meta.id.cross)
  APASSDist arcsec (n) Distance on sky to closest APASS DR9 source (apass_dist) (pos.angDistance)
  Gaiadr1Id  (n) Unique identifier (source_id) of closest Gaia DR1 source (gaia_dr1_id) (meta.id.cross)
  Gaiadr1Dist arcsec (n) Distance on sky to closest Gaia DR1 source (gaia_dr1_dist) (pos.angDistance)
  PS1dr1Id  (n) Unique identifier (objID) of closest Pan-STARRS1 DR1 source (ps1_dr1_id) (meta.id.cross)
  PS1dr1Dist arcsec (n) Distance on sky to closest Pan-STARRS1 DR1 source (ps1_dr1_dist) (pos.angDistance)
  GALEXbcsId  (n) Unique identifier (objid) of closest GALEX AIS source (Bianchi et al., 2014, Cat. II/335) (galex_bcs_id) (meta.id.cross)
  GALEXbcsDist arcsec (n) Distance on sky to closest GALEX AIS source (galex_bcs_dist) (pos.angDistance)
  Gaiadr2Id1  (n) Unique identifier (source_id) of closest Gaia DR2 source (gaia_dr2_id1) (meta.id.cross)
  Gaiadr2Dist1 arcsec (n) Distance on sky to closest Gaia DR2 source (gaia_dr2_dist1) (pos.angDistance)
  Gaiadr2Id2  (n) Unique identifier (source_id) of second-closest Gaia DR2 source (gaia_dr2_id2) (meta.id.cross)
  Gaiadr2Dist2 arcsec (n) Distance on sky to second-closest Gaia DR2 source (gaia_dr2_dist2) (pos.angDistance)
  (u-v)PSF mag (n) (upsf–vpsf) color, computed by CDS (uv_psf_color) (phot.color)
  (u-g)PSF mag (n) (upsf–gpsf) color, computed by CDS (ug_psf_color) (phot.color)
  (g-r)PSF mag (n) (gpsf–rpsf) color, computed by CDS (gr_psf_color) (phot.color)
  (g-i)PSF mag (n) (gpsf–ipsf) color, computed by CDS (gi_psf_color) (phot.color)
  (i-z)PSF mag (n) (ipsf–zpsf) color, computed by CDS (iz_psf_color) (phot.color)

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/VR1343902.err (2026-08-06T20:16:38)
-3
-source=II/358/smss
-ref=VIZ6a74eba614819e
elapse time 0

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


Contents of error file (/tmp/VR1343902.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%2F358%2Fsmss
REMOTE_ADDR=172.19.0.1
REMOTE_PORT=54698
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=II%2F358%2Fsmss
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/358/smss
################################################################

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

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   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'):
[1786047398]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   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'):
[1786047398]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   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=2358 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   SELECT catid FROM METAcat WHERE name='2358'
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=2358 and (authid=0)
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=2358 order by tabid
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   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'):
[1786047398]    Update METAhit set etime=839362598,  Ncalls = Ncalls+1 where catid=2358 and hstid=-1 and btime=838906200
------------(1 records affected)
----db1_exec(1 'metaviz@TAPVIZIER1'):
[1786047398]    UPDATE METAstat set nlocal=nlocal+1, tlocal=839362598 Where phase=3 and catid=2358
------------(1 records affected)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name From METAucd where ucdid>=0
....show_table(II/358/smss): show_status = (30, 79, 0, 0, 0)
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=359
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=1367
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=363
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=256
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=1172
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=255
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=1171
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=304
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=99
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=134
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=134
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=135
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=136
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=136
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=268
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=1221
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=744
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=747
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=1466
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=742
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=738
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=1469
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=102
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=121
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=434
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=228
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=1110
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=76
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select ucdid, name, class, explain From METAucd where ucdid=101
----db1_reset(0 'metaviz@TAPVIZIER1')
----db1_query(0 'metaviz@TAPVIZIER1'):
[1786047398]   Select famid, name, explain From METAfam where famid=404
----db1_reset(0 'metaviz@TAPVIZIER1')
----inherit(u=used, h=hidden):
     [u] +source=II/358/smss
     [u] -ref=VIZ6a74eba614819e
====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