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/ApJS/166/249
  Stellar dynamics and proper motions in 47Tuc (McLaughlin+, 2006)
Post annotation
img(gal)
1.J/ApJS/166/249/table3(c)Stars used for astrometric calibration, and the resulting cluster center point/star (8 rows) (released 2018-01-02)
[METAtab] [METAcola]
2.J/ApJS/166/249/table4(c)129733 stars in the Master Frame (129733 rows) (released 2018-01-02)
[METAtab] [METAcola]
3.J/ApJS/166/249/table5(c)Proper motions and displacement data for 14366 stars (14366 rows) (released 2018-01-02)
[METAtab] [METAcola]
Help Xmatch is

 
Query by Constraints constraints help applied on Columns (Output Order: + - )
ShowSortJoin tables
more join
Column  Constraint Explain   (UCD)
  (ALL)recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
  (1)AName (char) Name of object on Fig. 3 (meta.id)
   (ALL)Name  (n) Sequential star number (meta.id;meta.main)
   (ALL)F475W mag (n) HST/ACS F475W VEGAMAG system magnitude (phot.mag;em.opt.B)
  (1)xraw pix Raw X position in the top chip (WFC1) of the j8cd01a9q_flt frame from program GO-9028 (pos.cartesian.x;instr.det)
  (1)yraw pix Raw Y position in the top chip (WFC1) of the j8cd01a9q_flt frame from program GO-9028 (pos.cartesian.y;instr.det)
  (1+2)oRA arcsec Right ascension offset from center (Note G1)   (pos.eq.ra;arith.diff)
  (1+2)oDE arcsec Declination offset from center (Note G1)   (pos.eq.dec;arith.diff)
  (1)RAJ2000 "h:m:s" (i) Hour of right ascension (J2000) (pos.eq.ra;meta.main)
  (1)e_RAJ2000 s Error on right ascension (J2000) (stat.error;pos.eq.ra)
  (1)DEJ2000 "d:m:s" (i) Degree of declination (J2000) (pos.eq.dec;meta.main)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)e_DEJ2000 arcsec Error on declination (J2000) (stat.error;pos.eq.dec)
  (2)n_Name (char) M for stars having proper motions in table5 (meta.ref.url)
  (2)min mag Faintest star that could be included in the neighbourhood as "OK" (Note 2)   (phot.mag)
  (2)OK  Star OK? (Note 3)   (meta.code)
  (2)c % Local completeness fraction (Note 4)   (meta.note)
  (2)Xpix47 pix X location in the meta image, 47TucMaster.fits (pos.cartesian.x;instr.det)
  (2)Ypix47 pix Y location in the meta image, 47TucMaster.fits (pos.cartesian.y;instr.det)
  (2)Xpixrf pix X location in the ref. image, j8cd01a9q_w.fits (pos.cartesian.x;instr.det)
  (2)Ypixrf pix Y location in the ref. image, j8cd01a9q_w.fits (pos.cartesian.y;instr.det)
  (2+3)RAJ2000 deg (i) Right ascension (J2000, Ep=2002.26) (pos.eq.ra;meta.main)
  (2+3)DEJ2000 deg (i) Declination (J2000, Ep=2002.26) (pos.eq.dec;meta.main)
  (3)Xpos arcsec Offset in RA from cluster center (pos.eq.ra;arith.diff)
  (3)Ypos arcsec Offset in DE from cluster center (pos.eq.dec;arith.diff)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (3)Vmag mag Calibrated V magnitude (phot.mag;em.opt.V)
  (3)Umag mag Calibrated U magnitude (phot.mag;em.opt.U)
  (3)pmRA mas/yr Weighted least-squares proper motion along RA (pos.pm;pos.eq.ra)
  (3)e_pmRA mas/yr rms uncertainty on pmRA (stat.error;pos.pm;pos.eq.ra)
  (3)chi2RA  chi-square of the weighted least-squares fit to Xpos vs time (pos.cartesian.x;meta.modelled)
  (3)P(chi2RA)  Probability for chi2RA (Note 2)   (stat.probability)
  (3)pmDE mas/yr Weighted least-squares proper motion along DE (pos.pm;pos.eq.dec)
  (3)e_pmDE mas/yr rms uncertainty on pmDE (stat.error;pos.pm;pos.eq.dec)
  (3)chi2DE  chi-square of the weighted least-squares fit to Ypos vs time (stat.weight)
  (3)P(chi2DE)  Probability for chi2DE (Note 2)   (stat.probability)
  (3)X1pos mas (n) RA displacements of the star from nominal position for dataset MEYLANe1 (1995.82) (pos.eq.ra)
  (3)e_X1pos mas (n) rms uncertainty on X1pos (stat.error)
  (3)X2pos mas (n) RA displacements of the star from nominal position for dataset MEYLANe2 (1997.84) (pos.eq.ra)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (3)e_X2pos mas (n) rms uncertainty on X2pos (stat.error)
  (3)X3pos mas (n) RA displacements of the star from nominal position for dataset GILLILU1 (1999.51) (pos.eq.ra)
  (3)e_X3pos mas (n) rms uncertainty on X3pos (stat.error)
  (3)X4pos mas (n) RA displacements of the star from nominal position for dataset MEYLANe3 (1999.82) (pos.eq.ra)
  (3)e_X4pos mas (n) rms uncertainty on X4pos (stat.error)
  (3)X5pos mas (n) RA displacements of the star from nominal position for dataset GILLILU2 (2001.53) (pos.eq.ra)
  (3)e_X5pos mas (n) rms uncertainty on X5pos (stat.error)
  (3)X6pos mas (n) RA displacements of the star from nominal position for dataset WFC-MEUR (2002.26) (pos.eq.ra)
  (3)e_X6pos mas (n) rms uncertainty on X6pos (stat.error)
  (3)X7pos mas (n) RA displacements of the star from nominal position for dataset HRC-MEUR (2002.26) (pos.eq.ra)
  (3)e_X7pos mas (n) rms uncertainty on X7pos (stat.error)
  (3)X8pos mas (n) RA displacements of the star from nominal position for dataset WFC-BOHL (2002.28) (pos.eq.ra)
  (3)e_X8pos mas (n) rms uncertainty on X8pos (stat.error)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (3)X9pos mas (n) RA displacements of the star from nominal position for dataset WFC-KING (2002.52) (pos.eq.ra)
  (3)e_X9pos mas (n) rms uncertainty on X9pos (stat.error)
  (3)X10pos mas (n) RA displacements of the star from nominal position for dataset HRC-KING (2002.56) (pos.eq.ra)
  (3)e_X10pos mas (n) rms uncertainty on X10pos (stat.error)
  (3)Y1pos mas (n) DE displacements of the star from nominal position for dataset MEYLANe1 (1995.82) (pos.eq.dec;arith.diff)
  (3)e_Y1pos mas (n) rms uncertainty on Y1pos (stat.error)
  (3)Y2pos mas (n) DE displacements of the star from nominal position for dataset MEYLANe2 (1997.84) (pos.eq.dec;arith.diff)
  (3)e_Y2pos mas (n) rms uncertainty on Y2pos (stat.error)
  (3)Y3pos mas (n) DE displacements of the star from nominal position for dataset GILLILU1 (1999.51) (pos.eq.dec;arith.diff)
  (3)e_Y3pos mas (n) rms uncertainty on Y3pos (stat.error)
  (3)Y4pos mas (n) DE displacements of the star from nominal position for dataset MEYLANe3 (1999.82) (pos.eq.dec;arith.diff)
  (3)e_Y4pos mas (n) rms uncertainty on Y4pos (stat.error)
  (3)Y5pos mas (n) DE displacements of the star from nominal position for dataset GILLILU2 (2001.53) (pos.eq.dec;arith.diff)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (3)e_Y5pos mas (n) rms uncertainty on Y5pos (stat.error)
  (3)Y6pos mas (n) DE displacements of the star from nominal position for dataset WFC-MEUR (2002.26) (pos.eq.dec;arith.diff)
  (3)e_Y6pos mas (n) rms uncertainty on Y6pos (stat.error)
  (3)Y7pos mas (n) DE displacements of the star from nominal position for dataset HRC-MEUR (2002.26) (pos.eq.dec;arith.diff)
  (3)e_Y7pos mas (n) rms uncertainty on Y7pos (stat.error)
  (3)Y8pos mas (n) DE displacements of the star from nominal position for dataset WFC-BOHL (2002.28) (pos.eq.dec;arith.diff)
  (3)e_Y8pos mas (n) rms uncertainty on Y8pos (stat.error)
  (3)Y9pos mas (n) DE displacements of the star from nominal position for dataset WFC-KING (2002.52) (pos.eq.dec;arith.diff)
  (3)e_Y9pos mas (n) rms uncertainty on Y9pos (stat.error)
  (3)Y10pos mas (n) DE displacements of the star from nominal position for dataset HRC-KING (2002.56) (pos.eq.dec;arith.diff)
  (3)e_Y10pos mas (n) rms uncertainty on Y10pos (stat.error)

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-07-08T20:27:04)
-3
-source=J/ApJS/166/249
-ref=VIZ668c4b985adc6
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=7c2ef6d5c63e
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.14.255.241
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@PCDS 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
QUERY_STRING=-source=J%2FApJS%2F166%2F249
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=50800
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FApJS%2F166%2F249
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.unistra.fr
VSEARCH_REDIRECT=http://cdsarc.unistra.fr
Vaccess=*
Vprog=/srv/httpd/bin/vizier
Vprog_ls=-rwxr-xr-x 1 root root 953872 Jun 13 11:00 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=J/ApJS/166/249
################################################################

....Trying '/srv/httpd/interfaces' => OK
....Trying '/srv/httpd/interfaces' => 3
....db1_interfaces(/srv/httpd/interfaces)
----db1_open(metaviz@PCDS) gives: 0
----Open server: 130.79.128.40, port 5432 (type postgres base vizier)
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select hstid, flag from METAhst where name='7c2ef6d5c63e.astro.unistra.fr'
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/ApJS/166/249' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=21660249 and (authid=0)
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=21660249 order by tabid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   select login from METAdba where dbaid=45
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   select k.catid,k.kwdid from METAkwd k where catid=21660249 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@PCDS'):
[1720470424]   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@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@PCDS'):
[1720470424]   select login from METAdba where login like 'large_tables%'
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 146/0 tuples [tested=146]
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=21660249 order by catid,tabid,colid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select catid, morid, text From METAmor where catid=21660249 order by morid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=21660249 and tabid=1
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=403 and fltrid=2
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=21660249 and tabid=2
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=21660249 and tabid=3
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=402 and fltrid=7
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=54 and fltrid=3

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=21660249 and  tabid=1 order by colid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=21660249 and tabid=1
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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@PCDS'):
[1720470424]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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=21660249 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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=21660249 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select catid, morid, text From METAmor where catid=21660249 order by morid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=21660249 and  tabid=2 order by colid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=21660249 and tabid=2
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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=21660249 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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=21660249 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=21660249 and  tabid=3 order by colid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=21660249 and tabid=3
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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=21660249 and tabid=3
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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=21660249 and tabid=3
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=21660249 and (authid=0)
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=21660249 order by tabid
----db1_query(0 'metaviz@PCDS'):
[1720470424]   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@PCDS')
----db1_open(metaviz@PCDS) gives: 1
----Open server: 130.79.128.40, port 5432 (type postgres base vizier)
----db1_query(1 'metaviz@PCDS'):
[1720470424]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@PCDS')
++++popularity(all): 1.68785e+07 => 7.23
++++popularity(catid=21660249): 3496 => 0.49
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select idori, kwdid, name, explain From METAorigin
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name From METAucd where ucdid>=0
----db1_exec(0 'metaviz@PCDS'):
[1720470424]    Update METAhit set etime=773785624,  Ncalls = Ncalls+1 where catid=21660249 and hstid=-1 and btime=773161200
------------(1 records affected)
----db1_exec(0 'metaviz@PCDS'):
[1720470424]    UPDATE METAstat set nlocal=nlocal+1, tlocal=773785624 Where phase=3 and catid=21660249
------------(1 records affected)
----db1_exec(0 'metaviz@PCDS'):
[1720470424]    Update METAhit set etime=773785624,  N2list = N2list+2 where catid=21660249 and hstid=-1 and btime=773161200
------------(1 records affected)
----db1_exec(0 'metaviz@PCDS'):
[1720470424]    Update METAhit set etime=773785624,  N2list = N2list+2 where catid=21660249 and hstid=-1 and btime=773161200
------------(1 records affected)
----db1_exec(0 'metaviz@PCDS'):
[1720470424]    UPDATE METAstat set nlocal=nlocal+1, tlocal=773785624 Where phase=3 and catid=21660249
------------(1 records affected)
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name From METAfam where famid>=0
....show_tuple: show_status = (29, 55, 0, 0, 0)
====Tuple 'J/ApJS/166/249' from 3/0 tables:
    #21660249.1 'J/ApJS/166/249/table3' 12/24 columns
    #21660249.2 'J/ApJS/166/249/table4' 15/24 columns
    #21660249.3 'J/ApJS/166/249/table5' 57/72 columns
[00000007] col#000 v000 OA002 J/ApJS/166/249/table3*recno           
[00000001] col#001 v264 O4043 J/ApJS/166/249/table3*AName           
[80000007] col#002 v000 O0883 J/ApJS/166/249/table3*Name            
[00000007] col#003 v001 O00C3 J/ApJS/166/249/table3*F475W           
[00000001] col#004 v000 O0040 J/ApJS/166/249/table3*xraw            
[00000001] col#005 v000 O0040 J/ApJS/166/249/table3*yraw            
[00000003] col#006 v001 O0003 J/ApJS/166/249/table3*oRA             
[00000003] col#007 v001 O0003 J/ApJS/166/249/table3*oDE             
[00000001] col#008 v311 O0023 J/ApJS/166/249/table3*RAJ2000         
[00000001] col#009 v001 O0043 J/ApJS/166/249/table3*e_RAJ2000       
[00000001] col#010 v011 O0023 J/ApJS/166/249/table3*DEJ2000         
[00000001] col#011 v001 O0043 J/ApJS/166/249/table3*e_DEJ2000       
[00000007] col#000 v000 OA002 J/ApJS/166/249/table4*recno           
[00000003] col#001 v001 O0003 J/ApJS/166/249/table4*oRA             
[00000003] col#002 v001 O0003 J/ApJS/166/249/table4*oDE             
[00000002] col#003 v004 OC803 J/ApJS/166/249/table4*n_Name          
[80000007] col#004 v000 O3403 J/ApJS/166/249/table4*Name            
[00000007] col#005 v001 O00C3 J/ApJS/166/249/table4*F475W           
[00000002] col#006 v001 O0043 J/ApJS/166/249/table4*min             
[00000002] col#007 v000 O0043 J/ApJS/166/249/table4*OK              
[00000002] col#008 v001 O0043 J/ApJS/166/249/table4*c               
[00000002] col#009 v001 O0000 J/ApJS/166/249/table4*Xpix47          
[00000002] col#010 v001 O0000 J/ApJS/166/249/table4*Ypix47          
[00000002] col#011 v001 O0000 J/ApJS/166/249/table4*Xpixrf          
[00000002] col#012 v001 O0000 J/ApJS/166/249/table4*Ypixrf          
[00000006] col#013 v311 O1023 J/ApJS/166/249/table4*RAJ2000         
[00000006] col#014 v001 O0023 J/ApJS/166/249/table4*DEJ2000         
[00000007] col#000 v000 OA002 J/ApJS/166/249/table5*recno           
[80000007] col#001 v000 O1803 J/ApJS/166/249/table5*Name            
[00000004] col#002 v001 O0000 J/ApJS/166/249/table5*Xpos            
[00000004] col#003 v001 O0000 J/ApJS/166/249/table5*Ypos            
[00000004] col#004 v001 O0043 J/ApJS/166/249/table5*Vmag            
[00000004] col#005 v001 O0043 J/ApJS/166/249/table5*Umag            
[00000007] col#006 v001 O0043 J/ApJS/166/249/table5*F475W           
[00000006] col#007 v311 O0023 J/ApJS/166/249/table5*RAJ2000         
[00000006] col#008 v011 O0023 J/ApJS/166/249/table5*DEJ2000         
[00000004] col#009 v001 O0063 J/ApJS/166/249/table5*pmRA            
[00000004] col#010 v001 O0043 J/ApJS/166/249/table5*e_pmRA          
[00000004] col#011 v001 O0000 J/ApJS/166/249/table5*chi2RA          
[00000004] col#012 v001 O0000 J/ApJS/166/249/table5*P(chi2RA)       
[00000004] col#013 v001 O0063 J/ApJS/166/249/table5*pmDE            
[00000004] col#014 v001 O0043 J/ApJS/166/249/table5*e_pmDE          
[00000004] col#015 v001 O0000 J/ApJS/166/249/table5*chi2DE          
[00000004] col#016 v001 O0000 J/ApJS/166/249/table5*P(chi2DE)       
[00000004] col#017 v001 O0080 J/ApJS/166/249/table5*X1pos           
[00000004] col#018 v001 O00C0 J/ApJS/166/249/table5*e_X1pos         
[00000004] col#019 v001 O0080 J/ApJS/166/249/table5*X2pos           
[00000004] col#020 v001 O00C0 J/ApJS/166/249/table5*e_X2pos         
[00000004] col#021 v001 O0080 J/ApJS/166/249/table5*X3pos           
[00000004] col#022 v001 O00C0 J/ApJS/166/249/table5*e_X3pos         
[00000004] col#023 v001 O0080 J/ApJS/166/249/table5*X4pos           
[00000004] col#024 v001 O00C0 J/ApJS/166/249/table5*e_X4pos         
[00000004] col#025 v001 O0080 J/ApJS/166/249/table5*X5pos           
[00000004] col#026 v001 O00C0 J/ApJS/166/249/table5*e_X5pos         
[00000004] col#027 v001 O0080 J/ApJS/166/249/table5*X6pos           
[00000004] col#028 v001 O00C0 J/ApJS/166/249/table5*e_X6pos         
[00000004] col#029 v001 O0080 J/ApJS/166/249/table5*X7pos           
[00000004] col#030 v001 O00C0 J/ApJS/166/249/table5*e_X7pos         
[00000004] col#031 v001 O0080 J/ApJS/166/249/table5*X8pos           
[00000004] col#032 v001 O00C0 J/ApJS/166/249/table5*e_X8pos         
[00000004] col#033 v001 O0080 J/ApJS/166/249/table5*X9pos           
[00000004] col#034 v001 O00C0 J/ApJS/166/249/table5*e_X9pos         
[00000004] col#035 v001 O0080 J/ApJS/166/249/table5*X10pos          
[00000004] col#036 v001 O00C0 J/ApJS/166/249/table5*e_X10pos        
[00000004] col#037 v001 O0080 J/ApJS/166/249/table5*Y1pos           
[00000004] col#038 v001 O00C0 J/ApJS/166/249/table5*e_Y1pos         
[00000004] col#039 v001 O0080 J/ApJS/166/249/table5*Y2pos           
[00000004] col#040 v001 O00C0 J/ApJS/166/249/table5*e_Y2pos         
[00000004] col#041 v001 O0080 J/ApJS/166/249/table5*Y3pos           
[00000004] col#042 v001 O00C0 J/ApJS/166/249/table5*e_Y3pos         
[00000004] col#043 v001 O0080 J/ApJS/166/249/table5*Y4pos           
[00000004] col#044 v001 O00C0 J/ApJS/166/249/table5*e_Y4pos         
[00000004] col#045 v001 O0080 J/ApJS/166/249/table5*Y5pos           
[00000004] col#046 v001 O00C0 J/ApJS/166/249/table5*e_Y5pos         
[00000004] col#047 v001 O0080 J/ApJS/166/249/table5*Y6pos           
[00000004] col#048 v001 O00C0 J/ApJS/166/249/table5*e_Y6pos         
[00000004] col#049 v001 O0080 J/ApJS/166/249/table5*Y7pos           
[00000004] col#050 v001 O00C0 J/ApJS/166/249/table5*e_Y7pos         
[00000004] col#051 v001 O0080 J/ApJS/166/249/table5*Y8pos           
[00000004] col#052 v001 O00C0 J/ApJS/166/249/table5*e_Y8pos         
[00000004] col#053 v001 O0080 J/ApJS/166/249/table5*Y9pos           
[00000004] col#054 v001 O00C0 J/ApJS/166/249/table5*e_Y9pos         
[00000004] col#055 v001 O0080 J/ApJS/166/249/table5*Y10pos          
[00000004] col#056 v001 O00C0 J/ApJS/166/249/table5*e_Y10pos        

----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1466
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=398
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=26
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1115
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=399
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1116
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=5
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1166
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1136
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=745
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1343
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=716
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=935
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=622
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=79
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=151
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=449
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1351
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1720470424]   Select ucdid, name, class, explain From METAucd where ucdid=366
----db1_reset(0 'metaviz@PCDS')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/ApJS/166/249
     [u] -ref=VIZ668c4b985adc6
====inherit(): added 0 hidden fields
----db1_close(0 'metaviz@PCDS')

Cite/acknowledge VizieR catalogue
Rules of usage of VizieR data

© Université de Strasbourg/CNRS

    • Contact