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/509/3966
  Galaxy Zoo DR1&2, DR5 and DeepL version (Walmsley+, 2022)
ReadMe+ftp
2022MNRAS.509.3966W
Similar Catalogs
[METAcat] [METAcells] [stats]
Post annotation 		img(gal)
1.J/MNRAS/509/3966/gzdv1-2*Volunteer classifications for GZ DECaLS DR1&2 (Note) (92960 rows) (released 2025-02-12)
[METAtab] [METAcola]

Simple ConstraintList Of Constraints
 
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)
  IAUname (char) IAU name JHHMMSS.ss+DDMMSS.s (iauname) (meta.id;meta.main)
  RAJ2000 deg (i) Right Ascension (ra) (J2000) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) Declination (dec) (J2000) (pos.eq.dec;meta.main)
  z  Heliocentric redshift (redshift) (src.redshift)
  rMag mag (n) Absolute magnitude from elliptical Petrosian fluxes in rest-frame in SDSS r band (ABmag systems) (elpetroabsmagr) (phys.magAbs)
  Ar mag Galactic extinction corrected (ABmag systems) flux in SDSS r band (sersicnmgyr) (phys.absorption.gal)
  Pth50 arcsec Azimuthally-averaged SDSS-style 50 per cent Petrosian light radius r-band (petro_th50) (phys.angSize;src)
  Pth90 arcsec Azimuthally-averaged SDSS-style 90 per cent Petrosian light radius r-band (petro_th90) (phys.angSize;src)
  Pth100 arcsec Azimuthally-averaged SDSS-style Petrosian light radius r-band (petro_theta) (phys.angSize;src)
  Class (char) Classification group only pre-active ones (upload_group) (src.class)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  Active (char) [False] The active priority galaxies flag (activelearningon) (meta.code)
  DR5 (char) [False True] Flag indicate if the galaxy is present in volunteers DR5 data (ingzdc) (meta.code)
  DR1-2 (char) [DR1 DR2] Flag indicate if the galaxy is present in volunteers DR1 or DR2 data (data_release) (meta.code)
  NbSOF  Total number of volunteers who answered the Smooth of Featured question (smooth-or-featured_total-votes) (meta.number)
  Smooth  (n) Fraction of volunteers who responded "Smooth" to the "Smooth or Featured" question (smooth-or-featuredsmoothfraction) (meta.number)
  Featured  (n) Fraction of volunteers who responded "Featured or Disk" to the "Smooth or Featured" question (smooth-or-featured_featured-or -disk_fraction) (meta.number)
  Artifact  (n) Fraction of volunteers who responded "Artifact or Star" to the "Smooth or Featured" question (smooth-or-featured artifact_fraction) (meta.number)
  NbHR  Total number of volunteers who answered the "How rounded is it" question (how-rounded_total-votes) (meta.number)
  RR  (n) Fraction of volunteers who responded "completely round" to the "How rounded is it" question (how-rounded_completely _fraction) (meta.number)
  RIB  (n) Fraction of volunteers who responded "In between" to the "How rounded is it" question (how-roundedin–betweenfraction) (meta.number)
  RCS  (n) Fraction of volunteers who responded "Cigar shape" to the "How rounded is it" question (how-roundedcigar–shapedfraction) (meta.number)
  NbDEO  Total number of volunteers who answered the "Disk viewed edge-on" question (disk-edge-on_total-votes) (meta.number)
  DEOyes  (n) Fraction of volunteers who responded "yes" to the "Disk viewed edge-on" question (disk-edge-onyesfraction) (meta.number)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  DEOno  (n) Fraction of volunteers who responded "no" to the "Disk viewed edge-on" question (disk-edge-onnofraction) (meta.number)
  NbEOB  Total number of volunteers who answered the "edge-on-bulge shape" question (edge-on-bulge_total-votes) (meta.number)
  EOBR  (n) Fraction of volunteers who responded "Rounded" to the "edge-on-bulge shape" question (edge-on-bulgeroundedfraction) (meta.number)
  EOBB  (n) Fraction of volunteers who responded "Boxy" to the "edge-on-bulge shape" question (edge-on-bulgeboxyfraction) (meta.number)
  EOBNo  (n) Fraction of volunteers who responded "No bulge" to the "edge-on-bulge shape" question (edge-on-bulgenonefraction) (meta.number)
  NbSOB  Total number of volunteers who answered the "sign of bar feature" question (bar_total-votes) (meta.number)
  BYo  (n) Fraction of volunteers who responded "Yes bar" to the "sign of bar feature" question (baryesfraction) (meta.number)
  BNo  (n) Fraction of volunteers who responded "No bar" to the "sign of bar feature" question (barnofraction) (meta.number)
  NbHSA  Total number of volunteers who answered the "Has spiral arms" question (has-spiral arms_total-votes) (meta.number)
  HSAyes  (n) Fraction of volunteers who responded "yes" to the "Has spiral arms" question (has-spiral armsyesfraction) (meta.number)
  HSAno  (n) Fraction of volunteers who responded "no" to the "Has spiral arms" question (has-spiral armsnofraction) (meta.number)
  NbSW  Total number of volunteers who answered the "How tightly wound spiral arms appear" question (spiral-winding_total-votes) (meta.number)
  SWT  (n) Fraction of volunteers who responded "Tight" to the "How tightly" question (spiral-windingtightfraction) (meta.number)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  SWM  (n) Fraction of volunteers who responded "Medium" to the "How tightly" question (spiral-windingmediumfraction) (meta.number)
  SWL  (n) Fraction of volunteers who responded "Loose" to the "How tightly" question (spiral-windingloosefraction) (meta.number)
  NbSA  Total number of volunteers who answered the "How many spiral arms" question (spiral-arm-count_total-votes) (meta.number)
  SAC1  (n) Total number of volunteers who responded "1 arm" to the "How many spiral arms" question (spiral-arm-count1fraction) (meta.number)
  SAC2  (n) Total number of volunteers who responded "2 arms" to the "How many spiral arms" question (spiral-arm-count2fraction) (meta.number)
  SAC3  (n) Total number of volunteers who responded "3 arms" to the "How many spiral arms" question (spiral-arm-count3fraction) (meta.number)
  SAC4  (n) Total number of volunteers who responded "4 arms" to the "How many spiral arms" question (spiral-arm-count4fraction) (meta.number)
  SAC4+  (n) Total number of volunteers who responded "More than 4 arms" to the "How many spiral arms" question (spiral-arm-count more–than–4fraction) (meta.number)
  NbBulge  Total number of volunteers who answered the "bulge size" question (bulge-size_total-votes) (meta.number)
  BSNo  (n) Fraction of volunteers who responded "No bulge" to the "bulge size" question (bulge-sizenonefraction) (meta.number)
  BSO  (n) Fraction of volunteers who responded "Obvious" to the "bulge size" question (bulge-sizeobviousfraction) (meta.number)
  BSD  (n) Fraction of volunteers who responded "bulge size dominant" to the "bulge size" question (bulge-sizedominantfraction) (meta.number)
  NbM  (n) Total number of volunteers who answered the "Galaxy merging or tidal debris" question (merging_total-votes) (meta.number)
  MM  (n) Total number of volunteers who responded "Merging galaxy" to the "Galaxy merging or tidal debris" question (mergingmergerfraction) (meta.number)
  MTD  (n) Total number of volunteers who responded "Tidal debris" to the "Galaxy merging or disturbed" question (merging_tidal-debris _fraction) (meta.number)
  MBO  (n) Total number of volunteers who responded "Both" to the "Galaxy merging or tidal debris" question (mergingbothfraction) (meta.number)
  Mno  (n) Total number of volunteers who responded "Neither" to the "Galaxy merging or disturbed" question (mergingneitherfraction) (meta.number)
  WSS  (n) Mean distance from center of all pixels above double the 20th percentile (wrongsizestatistic) (meta.number)
  WSW (char) [False True] True if WSS > 161.0 our suggested starting cut to the mean distance of all pixels from center (wrongsizewarning) (meta.code)

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 (2025-04-05T15:06:10)
-3
-source=J/MNRAS/509/3966/gzdv1-2
-ref=VIZ67f146e23f549a
elapse time 0

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=5cb18c391f9b
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.21.43.123
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 --out='!/_((RA)|(DE))J2000|recno/'
QUERY_STRING=-source=J%2FMNRAS%2F509%2F3966%2Fgzdauto
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=57156
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FMNRAS%2F509%2F3966%2Fgzdauto
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 963656 Mar 12 13:03 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=J/MNRAS/509/3966/gzdauto
################################################################

....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'):
[1743865570]   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'):
[1743865570]   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'):
[1743865570]   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'):
[1743865570]   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'):
[1743865570]   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'):
[1743865570]   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'):
[1743865570]   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'):
[1743865570]   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'):
[1743865570]   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'):
[1743865570]   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'):
[1743865570]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select hstid, flag from METAhst where name='5cb18c391f9b.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/MNRAS/509/3966/gzdauto' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   select login from METAdba where dbaid=46
----db1_reset(0 'metaviz@VIZIR')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZIR'):
[1743865570]    insert into T1 values(75093966)
------------(1 records affected)
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_exec(1 'metaviz@VIZIR'):
[1743865570]    Update METAhit set etime=797180770,  Ncalls = Ncalls+1 where catid=75093966 and hstid=-1 and btime=796829400
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1743865570]    UPDATE METAstat set nlocal=nlocal+1, tlocal=797180770 Where phase=3 and catid=75093966
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/MNRAS/509/3966/gzdv1-2): show_status = (14, 42, 0, 0, 0)
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=1247
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=193
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=391
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=123
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=466
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=134
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=298
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=134
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@VIZIR')
-------db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=--------db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid----d----db1_reset(0 'metaviz@VIZIR')
b1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1743865570]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/MNRAS/509/3966/gzdv1-2
     [u] -ref=VIZ67f146e23f549a
====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