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/452/2087
  Galaxy And Mass Assembly (GAMA): DR2 (Liske+, 2015)
ReadMe+ftp
2015MNRAS.452.2087L
Similar Catalogs
[METAcat] [METAcells] [stats]
Post annotation 		img(gal)
1.J/MNRAS/452/2087/tilingScience targets and information for tiling and spectroscopic observation (InputCatA V16) (169850 rows) (released 2024-08-15)
[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)
  CataID  Unique GAMA ID of object (CATAID) (meta.id;meta.main)
  objID  SDSS objid (OBJID) (meta.id)
  RAJ2000 deg (i) Right ascension (J2000) (RA) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) Declination (J2000) (DEC) (pos.eq.dec;meta.main)
  rmagFib mag 3-arcsec fiber r magnitude (FIBERMAG_R) (phot.mag;em.opt.R)
  rPmag mag Extinction-corrected SDSS DR6 Petrosian magnitude (R_PETRO) (phot.mag;em.opt.R)
  uMmag mag (n) Extinction-corrected SDSS DR6 u magnitude (U_MODEL) (phot.mag;meta.modelled)
  gMmag mag (n) Extinction-corrected SDSS DR6 g magnitude (G_MODEL) (phot.mag;meta.modelled)
  rMmag mag Extinction-corrected SDSS DR6 r magnitude (R_MODEL) (phot.mag;meta.modelled)
  iMmag mag Extinction-corrected SDSS DR6 i magnitude (I_MODEL) (phot.mag;meta.modelled)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  zMmag mag Extinction-corrected SDSS DR6 z magnitude (Z_MODEL) (phot.mag;meta.modelled)
  SCode  Survey code for redshift source (SURVEY_CODE) (Note 1)   (meta.code)
  z  (n) Spectroscopic redshift (Z) (src.redshift)
  NQ  Quality of redshift (NQ) (meta.code.qual)
  SpecId (char) ID of spectrum from SpecAll table (SPECID) (meta.id)
  NGamaSpec  Number of GAMA spectra matched to object (NUMGAMASPEC) (meta.number)
  SuBrR mag/arcsec+2SDSS Petro half-light surface brightness (R_SB) (phot.mag.sb)
  SG-sepr mag rpsf–rmodel star-galaxy separation parameter (SG_SEP) (src.class.starGalaxy)
  SG-SepJK mag (n) J-K-f_locus star-galaxy separation parameter (SGSEPJK) (src.class.starGalaxy)
  Kmag mag (n) Extinction-corrected r-defined auto AB K magnitude (K_AUTO) (phot.mag;em.IR.K)
  TFlag  Bitwise target criteria (TARGET_FLAGS) (Note 2)   (meta.note)
  SClass  Useful for selecting samples (SURVEY_CLASS) (Note 3)   (meta.code)
  PClass  Priorities for targeting (PRIORITY_CLASS) (Note 4)   (meta.code)
  NClass  Number of priority_class≥8 targets within 40 arcsec (NEIGHBOUR_CLASS) (meta.number)
  MasK10  Mask value 0.0 to 1.0 around V<10 stars (MASKIC10) (Note 5)   (meta.code)
  Mask12  Mask value 0.0 to 1.0 around V<12 stars (MASKIC12) (Note 5)   (meta.code)
  VClass  Visual classification (VIS_CLASS) (Note 6)   (meta.code.class)
  n_VClass (char) Initials of classifiers, xxx for none (VISCLASSUSER) (meta.note)
  DR2Flag   [0,1] Indicates whether spectra, redshifts and ancillary data for this object are released in DR2 (DR2_FLAG) (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-08-23T23:33:15)
-3
-source=J/MNRAS/452/2087/tiling
-ref=VIZ68aa4fbb342f1d
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=b448cffa3102
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_CACHE_CONTROL=max-age=0
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_VIA=1.1 squid-proxy-5b5d847c96-l5qcg (squid/6.10)
HTTP_X_FORWARDED_FOR=10.3.175.99, 216.73.216.136
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%2FA%2BA%2F610%2FA63%2Flcw151t
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=44960
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FA%2BA%2F610%2FA63%2Flcw151t
SCRIPT_FILENAME=/srv/httpd/local/cgi/VizieR-3
SCRIPT_NAME=/local/viz-bin/VizieR-3
SERVER_ADDR=172.17.0.3
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 963736 Jun 11 08:12 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=J/A+A/610/A63/lcw151t
################################################################

....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'):
[1755991995]   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'):
[1755991995]   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'):
[1755991995]   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'):
[1755991995]   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'):
[1755991995]   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'):
[1755991995]   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'):
[1755991995]   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'):
[1755991995]   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'):
[1755991995]   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'):
[1755991995]   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'
ble2): show_status = (6, 1, 0, 0, 0)
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=63
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=93
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=257
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=1247
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=106
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=9
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=581
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=288
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=1326
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=1255
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=VIII/108/table2
     [u] -ref=VIZ68aa4fbb342f36
====inherit(): added 0 hidden fields
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=1467
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=79
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=534
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=1247
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=68
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=177
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=117
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=799
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=304
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=99
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=743
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=193
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select ucdid, name, class, explain From METAucd where ucdid=63
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=93
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755991995]   Select famid, name, explain From METAfam where famid=313
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/MNRAS/452/2087/tiling
     [u] -ref=VIZ68aa4fbb342f1d
====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