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/A+A/633/A154
  HDBSCAN star, galaxy, QSO classification (Logan+, 2020)
ReadMe+ftp
2020A&A...633A.154L
Similar Catalogs
[METAcat] [METAcells] [stats]
Post annotation 		img(gal)
1.J/A+A/633/A154/cpzCPz catalogue with object classifications (48686 rows) (released 2020-04-24)
[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)
  id (char) Spectroscopic redshift ID (Note G1)   (meta.id;meta.main)
  RAJ2000 deg (i) Spectroscopic redshift right ascension (J2000) (Note G1)   (pos.eq.ra;meta.main)
  DEJ2000 deg (i) Spectroscopic redshift declination (J2000) (Note G1)   (pos.eq.dec;meta.main)
  z  Spectroscopic redshift value (Note G1)   (src.redshift)
  Hclass   [0/3] Spectroscopic redshift classification (0=star, 1=galaxy, 3=QSO) (Note 2)   (meta.code.class)
  umag mag u band total magnitude (phot.mag;em.opt.U)
  e_umag mag u band total magnitude error (stat.error;phot.mag;em.opt.U)
  gmag mag g band total magnitude (phot.mag;em.opt.B)
  e_gmag mag (n) g band total magnitude error (stat.error;phot.mag;em.opt.B)
  rmag mag r band total magnitude (phot.mag;em.opt.R)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  e_rmag mag r band total magnitude error (stat.error;phot.mag;em.opt.R)
  imag mag i band total magnitude (phot.mag;em.opt.I)
  e_imag mag i band total magnitude error (stat.error;phot.mag;em.opt.I)
  zmag mag z band total magnitude (phot.mag;em.opt.I)
  e_zmag mag z band total magnitude error (stat.error;phot.mag;em.opt.I)
  Ymag mag Y band total magnitude (phot.mag;em.IR.J)
  e_Ymag mag Y band total magnitude error (stat.error;phot.mag;em.opt.B)
  Jmag mag J band total magnitude (phot.mag;em.IR.J)
  e_Jmag mag J band total magnitude error (stat.error;phot.mag;em.IR.J)
  Hmag mag H band total magnitude (phot.mag;em.IR.H)
  e_Hmag mag H band total magnitude error (stat.error;phot.mag;em.IR.H)
  Kmag mag K band total magnitude (phot.mag;em.IR.K)
  e_Kmag mag K band total magnitude error (stat.error;phot.mag;em.IR.K)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  W1mag mag W1 band total magnitude (phot.mag;em.IR.3-4um)
  e_W1mag mag W1 band total magnitude error (stat.error;phot.mag)
  W2mag mag W2 band total magnitude (phot.mag;em.IR.4-8um)
  e_W2mag mag W2 band total magnitude error (stat.error;phot.mag)
  u3mag mag u band 3 arcsecond magnitude (phot.mag;em.opt.U)
  e_u3mag mag (n) u band 3 arcsecond magnitude error (stat.error;phot.mag)
  g3mag mag g band 3 arcsecond magnitude (phot.mag;em.opt.B)
  e_g3mag mag g band 3 arcsecond magnitude error (stat.error;phot.mag)
  r3mag mag r band 3 arcsecond magnitude (phot.mag;em.opt.R)
  e_r3mag mag r band 3 arcsecond magnitude error (stat.error;phot.mag)
  i3mag mag i band 3 arcsecond magnitude (phot.mag;em.opt.I)
  e_i3mag mag i band 3 arcsecond magnitude error (stat.error;phot.mag)
  Z3mag mag z band 3 arcsecond magnitude (phot.mag;em.opt.I)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  e_Z3mag mag z band 3 arcsecond magnitude error (stat.error;phot.mag)
  Y3mag mag Y band 3 arcsecond magnitude (phot.mag;em.IR.J)
  e_Y3mag mag Y band 3 arcsecond magnitude error (stat.error;phot.mag)
  J3mag mag J band 3 arcsecond magnitude (phot.mag;em.IR.J)
  e_J3mag mag J band 3 arcsecond magnitude error (stat.error;phot.mag;em.IR.J)
  H3mag mag H band 3 arcsecond magnitude (phot.mag;em.IR.H)
  e_H3mag mag H band 3 arcsecond magnitude error (stat.error;phot.mag;em.IR.H)
  K3mag mag K band 3 arcsecond magnitude (phot.mag;em.IR.K)
  e_K3mag mag K band 3 arcsecond magnitude error (stat.error;phot.mag;em.IR.K)
  Yhlr arcsec (n) Y band half light radius (HLR) (phys.angSize;src)
  Jhlr arcsec (n) J band half light radius (HLR) (phys.angSize;src)
  Hhlr arcsec (n) H band half light radius (HLR) (phys.angSize;src)
  Khlr arcsec (n) K band half light radius (HLR) (phys.angSize;src)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  PCAs1c  PCA components, STAR HDBSCAN binary classifiers, 'optimal' method setup, colours used (pcastar1_colours) (meta.code.class)
  PCAs2c  PCA components, STAR HDBSCAN binary classifiers, 'optimal' method setup, colours used (pcastar2_colours) (meta.code.class)
  PCAs3c  PCA components, STAR HDBSCAN binary classifiers, 'optimal' method setup, colours used (pcastar3_colours) (meta.code.class)
  PCAg1c  PCA components, GAL HDBSCAN binary classifiers, 'optimal' method setup, colours used (pcagal1_colours) (meta.code.class)
  PCAg2c  PCA components, GAL HDBSCAN binary classifiers, 'optimal' method setup, colours used (pcagal2_colours) (meta.code.class)
  PCAg3c  PCA components, GAL HDBSCAN binary classifiers, 'optimal' method setup, colours used (pcagal3_colours) (meta.code.class)
  PCAq1c  PCA components, QSO HDBSCAN binary classifiers, 'optimal' method setup, colours used (pcaqso1_colours) (meta.code.class)
  PCAq2c  PCA components, QSO HDBSCAN binary classifiers, 'optimal' method setup, colours used (pcaqso2_colours) (meta.code.class)
  PCAq3c  PCA components, QSO HDBSCAN binary classifiers, 'optimal' method setup, colours used (pcaqso3_colours) (meta.code.class)
  ClasscO   [0/3] Consolidation method classification (0=outlier, 1=star, 2=gal, 3=QSO), colours used (hdbscanclassoptimalmethod_colours) (meta.code.class)
  CassscA   [0/3] (0=outlier, 1=star, 2=gal, 3=QSO), colours used (hdbscanclassalternativemethod_colours) (meta.code.class)
  dpc   [0/1] Doubly positively classified objects, colours used (doublepositivescolours) (meta.code)
  Poutc  Outlier probability , colours used (outlierprobabilitycolours) (stat.fit.goodness)

ALL cols		    
(n) indicates a possible blank or NULL column(i)indexed column
  Pstarc  Star probability, colours used (starprobabilitycolours) (stat.fit.goodness)
  Pgalc  Galaxy probability, colours used (galprobabilitycolours) (stat.fit.goodness)
  Pqsoc  QSO probability, colours used (QSOprobabilitycolours) (stat.fit.goodness)
  Labelc   [0/3] Final labels, 'highest probability' method (highestprobabilitylabels) (meta.code.class)
  PCAs1cHLR  (n) PCA components, STAR HDBSCAN binary classifiers, 'optimal' method setup, colours & HLR used (pcastar1_colours+HLR) (meta.code.class)
  PCAs2cHLR  (n) PCA components, STAR HDBSCAN binary classifiers, 'optimal' method setup, colours & HLR used (pcastar2_colours+HLR) (meta.code.class)
  PCAs3cHLR  (n) PCA components, STAR HDBSCAN binary classifiers, 'optimal' method setup, colours & HLR used (pcastar3_colours+HLR) (meta.code.class)
  PCAg1cHLR  (n) PCA components, GAL HDBSCAN binary classifiers, 'optimal' method setup , colours & HLR used (pcagal1_colours+HLR) (meta.code.class)
  PCAg2cHLR  (n) PCA components, GAL HDBSCAN binary classifiers, 'optimal' method setup , colours & HLR used (pcagal2_colours+HLR) (meta.code.class)
  PCAg3cHLR  (n) PCA components, GAL HDBSCAN binary classifiers, 'optimal' method setup , colours & HLR used (pcagal3_colours+HLR) (meta.code.class)
  PCAq1cHLR  (n) PCA components, QSO HDBSCAN binary classifiers, 'optimal' method setup , colours & HLR used (pcaqso1_colours+HLR) (meta.code.class)
  PCAq2cHLR  (n) PCA components, QSO HDBSCAN binary classifiers, 'optimal' method setup , colours & HLR used (pcaqso2_colours+HLR) (meta.code.class)
  PCAq3cHLR  (n) PCA components, QSO HDBSCAN binary classifiers, 'optimal' method setup , colours & HLR used (pcaqso3_colours+HLR) (meta.code.class)
  ClasscHLRO  (n) [0/3] Optimal consolidation method classification (0=outlier, 1=star, 2=gal, 3=QSO), colours & H LR used (hdbscanclassoptimalmethod_colours+HLR) (meta.code.class)
  ClasscHLRA  (n) [0/3] Alternative consolidation method classification (0=outlier, 1=star, 2=gal, 3=QSO), colours & HLR used (hdbscanclassalternativemethod_colours+HLR) (meta.code.class)
  dpcHLR  (n) [0/1] Doubly positively classified objects, colours & HLR used (doublepositivescolours+HLR) (meta.code)
  PoutcHLR  (n) Outlier probability, colours & HLR used (outlierprobabilitycolours+HLRs) (stat.fit.goodness)
  PstarcHLR  (n) Star probability, colours & HLR used (starprobabilitycolours+HLRs) (stat.fit.goodness)
  PgalcHLR  (n) Galaxy probability, colours & HLR used (galprobabilitycolours+HLRs) (stat.fit.goodness)
  PqsocHLR  (n) QSO probability, colours & HLR used (QSOprobabilitycolours+HLRs) (stat.fit.goodness)
  LabelcHLR  (n) [0/3] Final labels for when the 'highest probability' method is used, colours & HLR used (highestprobabilitylabels_colours+HLRs) (meta.code.class)

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-10T16:55:25)
-3
-source=J/A+A/633/A154/cpz
-ref=VIZ67f7f7fd42b9
elapse time 0

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

Contents of error file (/tmp/V-3.err):
-rwxr-xr-x 1 root root 963736 Apr 10 15:32 /srv/httpd/bin/vizier
vizier -- Version 7.5
cgiprint -- version 9.68 (2016-01-16)
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAtimeRel' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   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=49 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select catid, tabid, colid, time_rel_id From METAtimeRel where catid=36260119 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 1
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=36260119 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36260119 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   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'):
[1744304125]    Update METAhit set etime=797619325,  Ncalls = Ncalls+1 where catid=36260119 and hstid=-1 and btime=796829400
y(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=1469
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=749
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=730
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select ucdid, name, class, explain From METAucd where ucdid=928
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=734
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=743
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select ucdid, name, class, explain From METAucd where ucdid=926
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=665
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select ucdid, name, class, explain From METAucd where ucdid=925
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=666
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=608
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select ucdid, name, class, explain From METAucd where ucdid=134
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select ucdid, name, class, explain From METAucd where ucdid=298
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=134
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select ucdid, name, class, explain From METAucd where ucdid=353
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=1351
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744304125]   Select famid, name, explain From METAfam where famid=99
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/A+A/633/A154/cpz
     [u] -ref=VIZ67f7f7fd42b9
====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