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

  
J/MNRAS/414/500
  Spitzer/IRS ATLAS project source (Hernan-Caballero+, 2011)
spectrum
Post annotation
img(gal)
1.J/MNRAS/414/500/catalogSpitzer/IRS ATLAS project source catalog, version 1.0 (739 rows) (released 2024-07-14)
[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)
  sp  Plot of the spectrum (meta.ref.url)
spectrum
  Name (char) Name (meta.id;meta.main)
  OName (char) NED name (meta.id)
  Ref (char) Reference for IRS spectrum (meta.ref;pos.frame)
  RAJ2000 "h:m:s" (i) Right ascension (J2000) (pos.eq.ra;meta.main)
  DEJ2000 "d:m:s" (i) Declination (J2000) (pos.eq.dec;meta.main)
  zbest  (n) Best available spectroscopic redshift (src.redshift;pos.heliocentric)
  zspec  (n) Optical spectroscopic redshift (src.redshift)
  zIRS  (n) Redshift from Spitzer/IRS spectrum (src.redshift;pos.heliocentric)
  Type (char) Optical AGN type or general galaxy type (src.class)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Class (char) Mid-IR classification: MIR_AGN, MIR_AGN1, MIR_AGN2, MIR_AGNx, MIR_COMP (composite), MIR_SB (starburst), or unknown (src.class)
  mag mag (n) Magnitude in reference optical band (negative values are non-detection limits) (negative value indicate a detection limit) (phot.mag)
  n_mag (char) Reference optical band (instr.bandpass)
  r_mag (char) R-like optical band name (meta.ref)
  F(R) Jy (n) R-like optical band flux density (phot.flux.density;em.opt.R)
  e_F(R) Jy (n) rms uncertainty on F(R) (Note 4)   (stat.error)
  r_F(R) (char) K-like NIR band name (meta.ref;pos.frame)
  F(K) Jy (n) K-like NIR band flux density (phot.mag;em.IR.K)
  e_F(K) Jy (n) rms uncertainty on F(K) (Note 4)   (stat.error)
  F(3.6) Jy (n) IRAC1 (3.6um) flux density (phot.flux.density;em.IR.3-4um)
  e_F(3.6) Jy (n) rms uncertainty on F(3.6) (Note 4)   (stat.error)
  F(8.0) Jy (n) IRAC4 (8.0um) flux density (phot.flux.density;em.IR.8-15um)
  e_F(8.0) Jy (n) rms uncertainty on F(8.0) (Note 4)   (stat.error)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  r_F(24) (char) Source of 24um data (meta.ref;pos.frame)
  F(24) Jy (n) 24um flux density (phot.flux.density;em.IR.15-30um)
  e_F(24) Jy (n) rms uncertainty on F(24) (Note 4)   (stat.error)
  r_F(70) (char) Source of 70um data (meta.ref;pos.frame)
  F(70) Jy (n) 70um or similar band flux density (phot.flux.density;em.IR.30-60um)
  e_F(70) Jy (n) rms uncertainty on F(70) (Note 4)   (stat.error)
  r_F(1.4) (char) Source of 1.4GHz data (meta.ref;pos.frame)
  F(1.4) Jy (n) 1.4GHz flux density (phot.flux.density;em.radio.750-1500MHz)
  e_F(1.4) Jy (n) rms uncertainty on F(1.4) (Note 4)   (stat.error)
  lam0 um (n) Short wavelength limit of observed IRS spectrum (em.wl)
  lam1 um (n) Long wavelength limit of observed IRS spectrum (em.wl)
  lrest0 um (n) Short wavelength limit of IRS spectrum (restframe) (em.wl)
  lrest1 um (n) Long wavelength limit of IRS spectrum (restframe) (em.wl)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  L(2.2) 10-7W (n) 2.2um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(2.2) 10-7W (n) rms uncertainty on L(2.2). (stat.error)
  L(3.6) 10-7W (n) 3.6um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(3.6) 10-7W (n) rms uncertainty on L(3.6). (stat.error)
  L(5.6) 10-7W (n) 5.6um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(5.6) 10-7W (n) rms uncertainty on L(5.6). (stat.error)
  L(7.0) 10-7W (n) 7.0um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(7.0) 10-7W (n) rms uncertainty on L(7.0). (stat.error)
  L(9.0) 10-7W (n) 9.0um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(9.0) 10-7W (n) rms uncertainty on L(9.0). (stat.error)
  L(10) 10-7W (n) 10.0um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(10) 10-7W (n) rms uncertainty on L(10). (stat.error)
  L(12) 10-7W (n) 12.0um restframe luminosity (νLν) (phys.luminosity;em.IR)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_L(12) 10-7W (n) rms uncertainty on L(12). (stat.error)
  L(14) 10-7W (n) 14.0um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(14) 10-7W (n) rms uncertainty on L(14). (stat.error)
  L(15) 10-7W (n) 15.0um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(15) 10-7W (n) rms uncertainty on L(15). (stat.error)
  L(18) 10-7W (n) 18.8um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(18) 10-7W (n) rms uncertainty on L(18). (stat.error)
  L(20) 10-7W (n) 20.0um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(20) 10-7W (n) rms uncertainty on L(20). (stat.error)
  L(25) 10-7W (n) 25.0um restframe luminosity (νLν) (phys.luminosity;em.IR)
  e_L(25) 10-7W (n) rms uncertainty on L(25). (stat.error)
  C7-10-14  (n) 7-10-14um "three-band" color index (Note 1)   (phot.color;em.IR;em.IR)
  fsil  (n) [-7/2] Status flag for silicate features, 0=OK, >0=warning, <0=error (Note 2)   (meta.code)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Ssil  (n) Silicate strength (spect.line.intensity)
  e_Ssil  (n) [-11/] rms uncertainty on Ssil (stat.error)
  lam.sil um (n) Restframe wavelength at which the silicate peak is measured (em.wl)
  e_lam.sil um (n) rms uncertainty on lambdasil (stat.error)
  c.sil 0.1W/m (n) Underlying continuum at the peak's wavelength (in erg/s/um) (phot.flux.density;em.IR)
  e_c.sil 0.1W/m (n) rms uncertainty on c.sil (stat.error)
  p.sil 0.1W/m (n) Feature's flux at peak's wavelength (in erg/s/um) (phot.flux.density;em.IR)
  e_p.sil 0.1W/m (n) rms uncertainty on p.sil (stat.error)
  W(sil) um (n) Equivalenth width of the silicate feature (spect.line.eqWidth)
  e_W(sil) um (n) rms uncertainty on W(sil) (stat.error)
  L(sil) 10-7W (n) Integrated luminosity of the silicate feature (phys.luminosity;em.IR)
  e_L(sil) 10-7W (n) rms uncertainty on L(sil) (stat.error)
  SNRsil  (n) Signal to noise ratio of the silicate feature (stat.snr)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  f6.2  (n) [-1/3] Status flag for 6.2um PAH measurement, 0=OK (Note 3)   (meta.code)
  L(6.2) 10-7W (n) 6.2um PAH integrated luminosity (phys.luminosity;em.IR)
  e_L(6.2) 10-7W (n) rms uncertainty on L(6.2) (stat.error)
  W(6.2) um (n) 6.2um PAH equivalent width (spect.line.eqWidth)
  e_W(6.2) um (n) rms uncertainty on W(6.2) (stat.error)
  Lc(6.2) 0.1W/m (n) 6.2um PAH underlying continuum luminosity (in erg/s/um) (phys.luminosity;em.IR)
  e_Lc(6.2) 0.1W/m (n) rms uncertainty on Lc(6.2) (stat.error)
  F(6.2) mW/m2 (n) 6.2um PAH integrated flux (phot.flux.density;em.IR.30-60um)
  e_F(6.2) mW/m2 (n) rms uncertainty on F(6.2) (stat.error)
  SNR6.2  (n) 6.2um PAH signal to noise ratio (stat.snr)
  f11.3  (n) [-1/3] Status flag for 11.3um PAH measurement, 0=OK (Note 3)   (meta.code)
  L(11.3) 10-7W (n) 11.3um PAH integrated luminosity (phys.luminosity;em.IR)
  e_L(11.3) 10-7W (n) rms uncertainty on L(11.3) (stat.error)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  W(11.3) um (n) 11.3um PAH equivalent width (spect.line.eqWidth)
  e_W(11.3) um (n) rms uncertainty on W(11.3) (stat.error)
  Lc(11.3) 0.1W/m (n) 11.3um PAH underlying continuum luminosity (in erg/s/um) (phys.luminosity;em.IR)
  e_Lc(11.3) 0.1W/m (n) rms uncertainty on Lc(11.3) (stat.error)
  F(11.3) mW/m2 (n) 11.3um PAH integrated flux (phot.flux.density;em.IR.30-60um)
  e_F(11.3) mW/m2 (n) rms uncertainty on F(11.3) (stat.error)
  SNR11.3  (n) 11.3um PAH signal to noise ratio (stat.snr)
  Cov % (n) [16/100] 5-15um restframe spectral coverage fraction (phot.flux)
  L(5-15) 10-7W (n) 5-15um restframe integrated luminosity (phys.luminosity;em.IR)
  rAGN  (n) Fraction of AGN component (stat.param)
  e_rAGN  (n) rms uncertainty on rAGN (stat.error)
  L(AGN) 10-7W (n) 5-15um luminosity of AGN component (phys.luminosity;em.IR)
  e_L(AGN) 10-7W (n) rms uncertainty on L(AGN) (stat.error)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  rHII  (n) Fraction of HII component (stat.param)
  e_rHII  (n) rms uncertainty on rHII (stat.error)
  L(HII) 10-7W (n) 5-15um luminosity of HII component (phys.luminosity;em.IR)
  e_L(HII) 10-7W (n) rms uncertainty on L(HII) (stat.error)
  rPDR  (n) Fraction of PDR component (stat.param)
  e_rPDR  (n) rms uncertainty on rPDR (stat.error)
  L(PDR) 10-7W (n) 5-15um luminosity of PDR component (phys.luminosity;em.IR)
  e_L(PDR) 10-7W (n) rms uncertainty on L(PDR) (stat.error)
  tau9.7  (n) 9.7um optical depth (phys.absorption.opticalDepth)
  e_tau9.7  (n) rms uncertainty on tau9.7 (stat.error)
  rchi2d  (n) chi square function of decomposition fit (stat.fit.chi2;phys.luminosity.fun;meta.modelled)
  rchi2  (n) Reduced chi square function of decomposition fit (stat.fit.chi2;phys.luminosity.fun;meta.modelled)
  BibCode (char) Reference bibcode for literature source of IRS spectra (meta.bib.bibcode)
  AGNtype (char) Unified optical AGN type: no_AGN, type1, type1.x (intermediate), or type2. (src.class)
  srcType (char) Final type(s): Sy1, Sy1.x, Sy2, LINER, QSO, QSO2, Stb (starburst galaxy), ULIRG (Ultra-luminous UR galaxy), SMG (SubMillimeter Galaxy), or other (src.class)
  SimbadName (char) Designation understandable by the Simbad data-base (meta.id)
  NED  ask the NED data-base about this object (meta.ref)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
Adapt form
Display your selection only Reset to default columns
usage  Display UCD1+    UCD1  
.errorfile=/tmp/V-3.err (2024-09-20T12:25:25)
-3
-source=J/MNRAS/414/500/catalog
-ref=VIZ66ed69b6be5ef
elapse time 1

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


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

################################################################
....(in): -source=J/MNRAS/414/500/catalog
################################################################

....Trying '/srv/httpd/interfaces' => OK
....Trying '/srv/httpd/interfaces' => 3
....db1_interfaces(/srv/httpd/interfaces)
----db1_open(metaviz@VIZIR) gives: 0
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_query(0 'metaviz@VIZIR'):
[1726835125]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdba'
----db1_query(0 'metaviz@VIZIR'):
[1726835125]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAtab'
----db1_query(0 'metaviz@VIZIR'):
[1726835125]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAcol'
----db1_query(0 'metaviz@VIZIR'):
[1726835125]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAcat'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAmor'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdic'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdig'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAfam'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAucd'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAauth'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select hstid, flag from METAhst where name='8ae129b2b46e.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/MNRAS/414/500/catalog' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   select login from METAdba where dbaid=46
----db1_reset(0 'metaviz@VIZIR')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZIR'):
[1726835126]    insert into T1 values(74140500)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@VIZIR'):
[1726835126]    insert into T2 values(74140500)
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   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@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAkwdef' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=0 and  tabid=11 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAfilter'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAsed'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 146/0 tuples [tested=146]
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=74140500 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74140500 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=74140500 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select catid, morid, text From METAmor where catid=74140500 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=74140500 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=0 and fltrid=3646
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=0 and fltrid=7131
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=0 and fltrid=7596
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=0 and fltrid=8073
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=0 and fltrid=8420
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=74140500 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=74140500 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=74140500 and tabid=1

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAtime' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=0 and  tabid=52 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, id From METAtime where catid=74140500 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=74140500 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74140500 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METApop' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_open(metaviz@VIZIR) gives: 1
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_query(1 'metaviz@VIZIR'):
[1726835126]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@VIZIR')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=74140500): 4787 => 0.54
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select idori, kwdid, name, explain From METAorigin
----db1_open(metaviz@VIZIR) gives: 1
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_exec(1 'metaviz@VIZIR'):
[1726835126]    Update METAhit set etime=780150326,  Ncalls = Ncalls+1 where catid=74140500 and hstid=-1 and btime=778420800
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1726835126]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780150326 Where phase=3 and catid=74140500
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/MNRAS/414/500/catalog): show_status = (10, 107, 0, 0, 2)
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=251
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1255
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=257
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1247
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=97
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=745
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=21
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=319
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=545
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=474
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=926
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=486
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=924
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1470
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=923
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=481
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=922
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=483
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=905
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=508
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=14
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1340
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=191
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=920
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1006
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=101
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=667
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=294
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1311
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=487
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=293
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1273
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=362
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1322
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=106
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1281
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=361
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=297
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=124
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1030
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=351
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=192
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=79
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=154
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select ucdid, name, class, explain From METAucd where ucdid=57
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726835126]   Select famid, name, explain From METAfam where famid=1254
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/MNRAS/414/500/catalog
     [u] -ref=VIZ66ed69b6be5ef
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@VIZIR')
----db1_close(1 'metaviz@VIZIR')

Cite/acknowledge VizieR catalogue
Rules of usage of VizieR data

© Université de Strasbourg/CNRS

    • Contact