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/ApJ/912/49
  Clumps identified in z<0.06 SDSS Stripe 82 sample (Mehta+, 2021)
Post annotation
img(gal)
1.J/ApJ/912/49/table1The clump catalog (original column names in green) (543 rows) (released 2022-12-05)
[METAtab] [METAcola]

 
Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
Standard Original
ShowSortColumn  Constraint Explain   (UCD)
  recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
  ID (char) Galaxy Identification number in SDSS Stripe 82 coadd-epoch catalog (meta.id;meta.main)
  m_ID  (n)Number of clumps for this galaxy (meta.code.multip)
  RAGdeg deg Right Ascension of the galaxy center of mass (CoM) (J2000) (ra) (pos.eq.ra)
  DEGdeg deg [-1.25/1.25] Declination of the galaxy center of mass (CoM) (J2000) (dec) (pos.eq.dec)
  zDR14   [0.0059/0.06] Galaxy redshift available from DR14 (redshift) (src.redshift;pos.heliocentric)
  SpObjID (char) SDSS spectrum ID number centered on the galaxy, if available (specobjid) (meta.id)
  Run   [106/206] SDSS run number (meta.id)
  ReRun   [2] SDSS rerun number (meta.id;obs)
  CamCol   [1/6] SDSS camera column (meta.number)
  Field   [79/779] SDSS field number (meta.id;obs.field)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Obj   [12/1639] SDSS object ID within the field (meta.id)
  uPSF arcsec [1.26/1.71] u-band PSF FWHM (psf-fwhm-u) (instr.det.psf)
  gPSF arcsec [1.25/1.53] g-band PSF FWHM (psf-fwhm-g) (instr.det.psf)
  rPSF arcsec [1.11/1.52] r-band PSF FWHM (psf-fwhm-r) (instr.det.psf)
  iPSF arcsec [1.03/1.5] i-band PSF FWHM (psf-fwhm-i) (instr.det.psf)
  zPSF arcsec [1.06/1.5] z-band PSF FWHM (psf-fwhm-z) (instr.det.psf)
  Reff arcsec [2.31/14.07] Galaxy effective radius (gal_reff) (phys.angSize)
  amaj arcsec [2.45/18.07] Galaxy semi-major axis (gal_sma) (phys.angSize.smajAxis)
  bmin arcsec [0/9.24] Galaxy semi-minor axis (gal_smb) (phys.angSize.sminAxis)
  PA deg [-45/44] Galaxy position angle (gal_theta) (pos.posAng)
  Fu uJy [106/3189] Flux within a Kron-like elliptical (AUTO) u-band aperture (gal_flux_u) (phot.flux.density;em.opt.U)
  e_Fu uJy [0.9/9] Error for AUTO u-band flux (gal_fluxerr_u) (stat.error)
  umag mag [15.14/18.83] Kron-like elliptical (AUTO) aperture u-band magnitude (gal_mag_u) (phot.mag;em.opt.U)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_umag mag [0.0013/0.03] Error on AUTO u-band magnitude (gal_magerr_u) (stat.error;phot.mag)
  Fg uJy [284/8322] Flux within a Kron-like elliptical (AUTO) g-band aperture (gal_flux_g) (phot.flux.density;em.opt.B)
  e_Fg uJy [0.62/4.11] Error for AUTO g-band flux (gal_fluxerr_g) (stat.error)
  gmag mag [14.09/17.77] Kron-like elliptical (AUTO) aperture g-band magnitude (gal_mag_g) (phot.mag;em.opt.B)
  e_gmag mag [0.0002/0.006] Error on AUTO g-band magnitude (gal_magerr_g) (stat.error;phot.mag)
  Fr uJy [332/13235] Flux within a Kron-like elliptical (AUTO) r-band aperture (gal_flux_r) (phot.flux.density;em.opt.R)
  e_Fr uJy [0.93/5.7] Error for AUTO r-band flux (gal_fluxerr_r) (stat.error)
  rmag mag [13.59/17.6] Kron-like elliptical (AUTO) aperture r-band magnitude (gal_mag_r) (phot.mag;em.opt.R)
  e_rmag mag [0.0002/0.006] Error on AUTO r-band magnitude (gal_magerr_r) (stat.error;phot.mag)
  Fi uJy [327/16184] Flux within a Kron-like elliptical (AUTO) i-band aperture (gal_flux_i) (phot.flux.density;em.opt.I)
  e_Fi uJy [1.53/8.04] Error for AUTO i-band flux (gal_fluxerr_i) (stat.error)
  imag mag [13.37/17.62] Kron-like elliptical (AUTO) aperture i-band magnitude (gal_mag_i) (phot.mag;em.opt.I)
  e_imag mag [0.0002/0.008] Error on AUTO i-band magnitude (gal_magerr_i) (stat.error;phot.mag)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Fz uJy [328/18198] Flux within a Kron-like elliptical (AUTO) z-band aperture (gal_flux_z) (phot.flux.density;em.opt.I)
  e_Fz uJy [5.35/30.52] Error for AUTO z-band flux (gal_fluxerr_z) (stat.error)
  zmag mag [13.24/17.61] Kron-like elliptical (AUTO) aperture z-band magnitude (gal_mag_z) (phot.mag;em.opt.I)
  e_zmag mag [0.0007/0.03] Error on AUTO z-band magnitude (gal_magerr_z) (stat.error;phot.mag)
  E(B-V) mag [0.019/0.16] Galactic extinction in E(B-V) at galaxy position (gal_ext_ebv) (phot.color.excess)
  Av mag [0.06/0.48] Galactic extinction in AV at galaxy position (gal_ext_AV) (phys.absorption.gal)
  logMs [Msun] [7.44/11.12] Log stellar mass (gal_logMst) (phys.mass)
  e_logMs [Msun] [-0.24/0.14] Lower 1σ error in logMs (gal_logMst_l68) (stat.error)
  E_logMs [Msun] [-0.005/0.4] Upper 1σ error in logMs (gal_logMst_u68) (stat.error;stat.max)
  logAge [yr] [7.51/10.14] Log stellar age (gal_logage) (time.age)
  e_logAge [yr] [-0.4/0.09] Lower 1σ error in logAge (gal_logage_l68) (stat.error;time.age)
  E_logAge [yr] [-0.011/1.61] Upper 1σ error in logAge (gal_logage_u68) (stat.error;stat.max)
  logtau [yr] [6.5/10.5] Log star-formation timescale; for exponential SFH (gal_logtau) (time.scale)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_logtau [yr] [-1.05/0.9] Lower 1σ error in logtau (gal_logtau_l68) (stat.error)
  E_logtau [yr] [-0.12/2.74] Upper 1σ error in logtau (gal_logtau_u68) (stat.error;stat.max)
  logSFR [Msun/yr](n) [/1.5] Log star-formation rate (gal_logSFR) (phys.SFR)
  e_logSFR [Msun/yr](n) [-0.62/0.2] Lower 1σ error in logSFR (gal_logSFR_l68) (stat.error;phys.SFR)
  E_logSFR [Msun/yr](n) [-0.2/] Upper 1σ error in logSFR (gal_logSFR_u68) (stat.error;stat.max)
  f_logSFR (char) i=infinity (meta.code)
  Z [Sun] [-2.2/0.12] Log stellar metallicity (gal_Z_star) (phys.abund.Z)
  e_Z [Sun] [-1.2/0.03] Lower 1σ error in Z (gal_Z_star_l68) (stat.error;src.redshift)
  E_Z [Sun] [-1.07/1.2] Upper 1σ error in Z (gal_Z_star_u68) (stat.error;stat.max)
  logOH [-] [6.5/8.9] Gas-phase metallicity; log(OH)+12 (gal_logOH) (phys.abund)
  e_logOH [-] [-1.2/0.022] Lower 1σ error in logOH (gal_logOH_l68) (stat.error)
  E_logOH [-] [-1.07/1.2] Upper 1σ error in logOH (gal_logOH_u68) (stat.error;stat.max)
  Av5500 mag [0/1.51] Attenuation at 5500Å (gal_AV) (phys.absorption)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Av5500 mag [-0.9/0.015] Lower 1σ error in Av5500 (gal_AV_l68) (stat.error)
  E_Av5500 mag [-0.04/0.26] Upper 1σ error in Av5500 (gal_AV_u68) (stat.error;stat.max)
  Clump   [1/48] Clump identification number (clump_id) (meta.id)
  RAJ2000 deg (i) Clump Right Ascension (J2000) (clump_ra) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) [-1.25/1.25] Clump Declination (J2000) (clump_dec) (pos.eq.dec;meta.main)
  ClspID (char) SDSS spectrum ID number centered on the clump, if available (clump_specobjid) (meta.id)
  Prox   [0/1] Proximity flag for the clump (clump_prox_flag) (meta.code)
  ClDist arcsec [1.29/40.87] Clump galactocentric distance (clump_distance) (pos.distance;pos.galactocentric)
  ClDreff   [0.15/4.68] Clump galactocentric distance normalized by galaxy effective radius (clump_distnorm) (pos.distance)
  ClDamaj   [0.12/3.3] Clump galactocentric distance normalized by galaxy semi-major axis (clump_dist_sma) (pos.distance)
  ClGC kpc [0.26/16.38] Clump galactocentric distance (clump_distphys) (pos.distance;pos.galactocentric)
  ClFu uJy [0/88.32] Flux within a Kron-like elliptical (AUTO) u-band aperture (clump_flux_u) (phot.flux.density;em.opt.U)
  e_ClFu uJy [0.12/0.31] Error for AUTO u-band flux (clump_fluxerr_u) (stat.error)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  Clumag mag (n) [19/27.2] Kron-like elliptical (AUTO) aperture u-band magnitude (clump_mag_u) (phot.mag;em.opt.U)
  e_Clumag mag (n) [0.002/4] Error on AUTO u-band magnitude (clump_magerr_u) (stat.error;phot.mag)
  ClFg uJy [0/178] Flux within a Kron-like elliptical (AUTO) g-band aperture (clump_flux_g) (phot.flux.density;em.opt.B)
  e_ClFg uJy [0.06/0.2] Error for AUTO g-band flux (clump_fluxerr_g) (stat.error)
  Clgmag mag (n) [18/24.6] Kron-like elliptical (AUTO) aperture g-band magnitude (clump_mag_g) (phot.mag;em.opt.B)
  e_Clgmag mag (n) [0.0006/0.3] Error on AUTO g-band magnitude (clump_magerr_g) (stat.error;phot.mag)
  ClFr uJy [0/176] Flux within a Kron-like elliptical (AUTO) r-band aperture (clump_flux_r) (phot.flux.density;em.opt.R)
  e_ClFr uJy [0.12/0.2] Error for AUTO r-band flux (clump_fluxerr_r) (stat.error)
  Clrmag mag (n) [18/23.8] Kron-like elliptical (AUTO) aperture r-band magnitude (clump_mag_r) (phot.mag;em.opt.R)
  e_Clrmag mag (n) [0.001/0.2] Error on AUTO r-band magnitude (clump_magerr_r) (stat.error;phot.mag)
  ClFi uJy [0/201] Flux within a Kron-like elliptical (AUTO) i-band aperture (clump_flux_i) (phot.flux.density;em.opt.I)
  e_ClFi uJy [0.19/0.3] Error for AUTO i-band flux (clump_fluxerr_i) (stat.error)
  Climag mag (n) [18/24.7] Kron-like elliptical (AUTO) aperture i-band magnitude (clump_mag_i) (phot.mag;em.opt.I)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Climag mag (n) [0.001/0.5] Error on AUTO i-band magnitude (clump_magerr_i) (stat.error;phot.mag)
  ClFz uJy [0/223] Flux within a Kron-like elliptical (AUTO) z-band aperture (clump_flux_z) (phot.flux.density;em.opt.I)
  e_ClFz uJy [0.7/1.2] Error for AUTO z-band flux (clump_fluxerr_z) (stat.error)
  Clzmag mag (n) [18/27.1] Kron-like elliptical (AUTO) aperture z-band magnitude (clump_mag_z) (phot.mag;em.opt.I)
  e_Clzmag mag (n) [0.004/17.22] Error on AUTO z-band magnitude (clump_magerr_z) (stat.error;phot.mag)
  CllogMs [Msun] [4/9.6] Log stellar mass (clump_logMst) (phys.mass)
  e_CllogMs [Msun] [-0.6/1.2] Lower 1σ error on CllogMs (clump_logMst_l68) (stat.error)
  E_CllogMs [Msun] [-0.1/1.5] Upper 1σ error on CllogMs (clump_logMst_u68) (stat.error;stat.max)
  CllogAge [yr] [6/10.2] Log stellar age (clump_logage) (time.age)
  e_CllogAge [yr] [-1.63/2.3] Lower 1σ error on CllogAge (clump_logage_l68) (stat.error)
  E_CllogAge [yr] [-0.15/3.3] Upper 1σ error on CllogAge (clump_logage_u68) (stat.error;stat.max)
  CllogSFR [Msun/yr] [-3.75/1.1] Log star-formation rate (clump_logSFR) (phys.SFR)
  e_CllogSFR [Msun/yr] [-1.56/0.3] Lower 1σ error on CllogSFR (clump_logSFR_l68) (stat.error)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  E_CllogSFR [Msun/yr] [-0.9/0.91] Upper 1σ error on CllogSFR (clump_logSFR_u68) (stat.error;stat.max)
  ClZ [Sun] [-1.52/0.007] Log stellar metallicity (clump_Z_star) (phys.abund.Z)
  e_ClZ [Sun] [-1.03/0.21] Lower 1σ error on ClZ (clump_Z_star_l68) (stat.error)
  E_ClZ [Sun] [-0.2/0.94] Upper 1σ error on ClZ (clump_Z_star_u68) (stat.error;stat.max)
  CllogOH [-] [7.19/8.72] Gas-phase metallicity; log(OH)+12 (clump_logOH) (phys.abund)
  e_CllogOH [-] [-1.04/0.21] Lower 1σ error on CllogOH (clump_logOH_l68) (stat.error)
  E_CllogOH [-] [-0.2/0.95] Upper 1σ error on CllogOH (clump_logOH_u68) (stat.error;stat.max)
  ClAv mag [0/4.4] Attenuation at 5500Å (clump_AV) (phys.absorption)
  e_ClAv mag [-1.9/0.1] Lower 1σ error on ClAv (clump_AV_l68) (stat.error)
  E_ClAv mag [-0.72/1.02] Upper 1σ error on ClAv (clump_AV_u68) (stat.error;stat.max)
  Sloan  Display the online SDSS-DR16 data for the nearest object (meta.ref.url)

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-20T07:01:58)
-3
-source=J/ApJ/912/49
-ref=VIZ66ed1de655e2b
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=3.145.8.176
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%2FApJ%2F912%2F49
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=52106
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FApJ%2F912%2F49
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/ApJ/912/49
################################################################

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

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   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'):
[1726815718]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   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'):
[1726815718]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   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=19120049 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=19120049 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19120049 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   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'):
[1726815718]    Update METAhit set etime=780130918,  Ncalls = Ncalls+1 where catid=19120049 and hstid=-1 and btime=778420800
------------(0 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1726815718]    Insert into METAhit (catid, hstid, btime, etime, Ncalls, N2list) VALUES (19120049,-1,778420800,780130918, 1,0)
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1726815718]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780130918 Where phase=3 and catid=19120049
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/ApJ/912/49/table1): show_status = (68, 44, 0, 0, 1)
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=67
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=108
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1167
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1137
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=257
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1247
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=184
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=339
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=90
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=94
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=171
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=28
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=246
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=134
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=134
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=136
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=136
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=268
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1221
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=935
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=542
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1465
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=543
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1466
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=545
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1467
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=931
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=546
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1468
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1469
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=102
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=434
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=123
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=468
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=196
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1025
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=368
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1360
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=381
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1379
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=1061
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=129
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select famid, name, explain From METAfam where famid=919
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815718]   Select ucdid, name, class, explain From METAucd where ucdid=125
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select famid, name, explain From METAfam where famid=916
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select ucdid, name, class, explain From METAucd where ucdid=121
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select ucdid, name, class, explain From METAucd where ucdid=236
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select ucdid, name, class, explain From METAucd where ucdid=254
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select famid, name, explain From METAfam where famid=1174
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select famid, name, explain From METAfam where famid=947
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815719]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/ApJ/912/49
     [u] -ref=VIZ66ed1de655e2b
====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