VizieR

CfA VizieR . ADAC VizieR . CADC VizieR . Cambridge (UK) VizieR . IUCAA VizieR . Beijing (Ch) VizieR .

VizieR

start AladinLite
I/252/out The USNO-A2.0 Catalogue (Monet+ 1998)
The Full Catalogue (526280881 rows)
Definitions: [METAtab] [METAcola] [stats]
  USNO-A2.0=0375-03084915
Post annotation about this record

Note: USNO-A2.0 contains 526,280,881 sources, and is based on a re-reduction of the Precision Measuring Machine (PMM) scans from POSS-I O and E plates (>=-18°) and SRC-J and ESO-R plates (<=-20°). USNO-A2.0 was created by Dave Monet () and collaborators at Flagstaff Station, U.S. Naval Observatory.
The major difference between USNO-A2.0 and its previous version USNO-A1.0 is that A1.0 used the Guide Star Catalog as its reference frame whereas A2.0 uses the ICRF as realized by the USNO ACT catalog (Urban et al. 1997). The VizieR search engine uses an on-line compressed version (3.6Gbytes) which was generated at CDS.

ColumnValue  Explain   (UCD)
_RAJ200007 07 13.28616 "h:m:s" Right ascension (FK5, Equinox=J2000.0) (computed by VizieR, not part of the original data. The format may include more digits than the original data because of internal accuracy requirements in VizieR and across other CDS services) (pos.eq.ra)
_DEJ2000-51 58 05.7828 "d:m:s" Declination (FK5, Equinox=J2000.0) (computed by VizieR, not part of the original data. The format may include more digits than the original data because of internal accuracy requirements in VizieR and across other CDS services) (pos.eq.dec)
_RAB195007 06 01.26125 "h:m:s" Right ascension (FK4, Equinox=B1950.0) (computed by VizieR, not part of the original data. The format may include more digits than the original data because of internal accuracy requirements in VizieR and across other CDS services) (pos.eq.ra)
_DEB1950-51 53 18.5819 "d:m:s" Declination (FK4, Equinox=B1950.0) (computed by VizieR, not part of the original data. The format may include more digits than the original data because of internal accuracy requirements in VizieR and across other CDS services) (pos.eq.dec)
_Glon262.45945939 deg Galactic longitude (computed by VizieR, not part of the original data. The format may include more digits than the original data because of internal accuracy requirements in VizieR and across other CDS services) (pos.galactic.lon)
_Glat-18.74957760 deg Galactic latitude (computed by VizieR, not part of the original data. The format may include more digits than the original data because of internal accuracy requirements in VizieR and across other CDS services) (pos.galactic.lat)

USNO-A2.00375-03084915  (i) Original designation in USNO-A2.0 catalogue (Note)   (meta.id;meta.main)
RAJ2000106.805359 deg (i) Right ascension (ICRS) mean of blue/red plates (pos.eq.ra;meta.main)
DEJ2000-51.968273 deg (i) Declination (ICRS) mean of blue/red plates (pos.eq.dec;meta.main)
ACTflagA   [A] 'A' when star belongs to ACT (Cat. I/246) (meta.code)
Mflag    [*] '*' magnitudes are probably wrong (meta.code)
Bmag99.9 mag Magnitude from blue plate (phot.mag;em.opt.B)
Rmag 6.1 mag Magnitude from red plate (phot.mag;em.opt.R)
Epoch 0.000 yr Mean epoch of position (Note)   (time.epoch)
  
.errorfile=/tmp/VR05805.err (2019-04-19T23:18:04)
-5
-out.add=.
-source=I/252/out
USNO-A2.0=0375-03084915
-ref=VIZ5cba572d16ad


The following problems were encountered in this VizieR run:
....vizier, Version 6.9
CDSportal=http://cdsportal.u-strasbg.fr/StoreVizierData.html
COCAT=130.79.128.31
COCATPORT=1801
CONTEXT_DOCUMENT_ROOT=/srv/httpd/cgi/
CONTEXT_PREFIX=/viz-bin/
Content=text/html
DOCUMENT_ROOT=/srv/httpd/Pages/
GATEWAY_INTERFACE=CGI/1.1
GLUDIR=/srv/glu
HOME=/srv/httpd
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=viztext.astro.unistra.fr
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_X_FORWARDED_FOR=18.212.239.56, 130.79.128.30
HTTP_X_FORWARDED_HOST=cdsweb.u-strasbg.fr, viztext.astro.unistra.fr
HTTP_X_FORWARDED_SERVER=cds.u-strasbg.fr, viztext.astro.unistra.fr
LC_ALL=C
LD_LIBRARY_PATH=/srv/./lib:/srv/httpd/../lib:/srv/lib:/usr/local/lib:/usr/lib
METADB=metaviz@PCDS asu asu4VizieR
NEWS=/VizieR/+news.htx
PATH=/srv/httpd/bin:/usr/local/bin:/srv/./bin:/usr/bin:/bin
PATH_INFO=/
PWD=/srv/httpd/cgi
QUERY_STRING=-out.add=.&amp;-source=I/252/out&amp;USNO-A2.0=0375-03084915
REMOTE_ADDR=172.18.0.1
REMOTE_PORT=40674
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/viz-bin/VizieR-5?-out.add=.&amp;-source=I/252/out&amp;USNO-A2.0=0375-03084915
SCRIPT_FILENAME=/srv/httpd/cgi/VizieR-5
SCRIPT_NAME=/viz-bin/VizieR-5
SERVER_ADDR=172.18.0.3
SERVER_ADMIN=gilles.landais@astro.u-strasbg.fr
SERVER_NAME=viztext.astro.unistra.fr
SERVER_PORT=80
SERVER_PROTOCOL=HTTP/1.1
SERVER_SIGNATURE=
SERVER_SOFTWARE=Apache/2.4.27 (Unix)
SESAME_SERVER=glu
SYBASE=/srv
SYCOMP=.
Vroot=/srv/httpd
v_started=2019-04-19T23:18:04 from pid=5789

################################################################
....(in): -out.add=.
....(in): -source=I/252/out
....(in): USNO-A2.0=0375-03084915
################################################################

....Trying '/srv/httpd/interfaces' => OK
....Trying '/srv/httpd/interfaces' => 4
....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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715884]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select hstid, flag from METAhst where name='58e0ea878716.u-strasbg.fr'

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'I/252/out' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@PCDS')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@PCDS'):
[1555715885]    insert into T1 values(1252)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@PCDS'):
[1555715885]    insert into T2 values(1252)
------------(1 records affected)
----db1_query(0 'metaviz@PCDS'):
[1555715885]   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@PCDS'):
[1555715885]   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'):
[1555715885]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, morexplain From METAcol where catid=0 and  tabid=11 order by colid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   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'):
[1555715885]   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'):
[1555715885]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@PCDS'):
[1555715885]   select login from METAdba where login like 'vizls%'
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 140/0 tuples [tested=140]
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid From METAcat where catid=1252 and (authid=0)
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=1252
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, morexplain From METAcol where catid=1252 order by catid,tabid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select catid, morid, text From METAmor where catid=1252 order by morid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   select filename from METAtab where catid=1252 and tabid=1
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   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 = 'METAqin'
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select colid, off7, length, sep, fnull From METAqin where catid=1252 and tabid=1 and sep=0 order by colid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=1252 and tabid=1
----display_row(I/252/out), option=5, onote=0
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, morexplain From METAcol where catid=1252 and  tabid=1 order by colid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   select filename from METAtab where catid=1252 and tabid=1
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select colid, off7, length, sep, fnull From METAqin where catid=1252 and tabid=1 and sep=0 order by colid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=1252 and tabid=1
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name From METAucd where ucdid>=0
++++increase the precision for computed column 9
++++increase the precision for computed column 9
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name From METAfam where famid>=0
#...CooCompute  fk5(Eq=2000, Ep=2000) from:  fk5(Eq=2000, Ep=2000) [x1]
....[Epoch=(Epoch)*1+0.000000]
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid From METAcat where catid=1252 and (authid=0)
----db1_reset(0 'metaviz@PCDS')
----db1_open(metaviz@TAP_PROXY) gives: 1
----Open server: tapvizier.u-strasbg.fr, port 5435 (type postgres base vizier)
----db1_query(1 'metaviz@TAP_PROXY'):
[1555715885]   select dbname from METAtab where name='I/252/out'
----db1_close(1 'metaviz@TAP_PROXY')
change name to usnoa2 'login=vizls@TAP_PROXY)
++++increase the precision for computed column 9
++++increase the precision for computed column 9
#...CooCompute  fk4(Eq=1950, Ep=2000) from:  fk5(Eq=2000, Ep=2000) [x2]
....[Epoch=(Epoch)*1+0.000000]
++++increase the precision for computed column 9
++++increase the precision for computed column 9
#...CooCompute  gal(Eq=-nan, Ep=2000) from:  fk5(Eq=2000, Ep=2000) [x3]
....[Epoch=(Epoch)*1+0.000000]
....LaunchQuery: Columns, starting by = for Displayed ones:
..  =_RAJ2000 =_DEJ2000 =_RAB1950 =_DEB1950 =_Glon =_Glat =USNO-A2.0 =RAJ2000 =DEJ2000 =ACTflag =Mflag =Bmag =Rmag =Epoch
++++update index constraint to USNO-A2.0==0375-03084915
----db1_open(vizls@TAP_PROXY) gives: 1
----Open server: tapvizier.u-strasbg.fr, port 5435 (type postgres base vizier)
....TAPquery - set timeout
----db1_query(1 'vizls@TAP_PROXY'):
[1555715885]   Select USNO_A2_0, RAJ2000, DEJ2000, ACTflag, Mflag, Bmag, Rmag, Epoch From usnoa2 Where (USNO_A2_0 = '0375-03084915')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid From METAcat where catid=1252 and (authid=0)
----db1_reset(0 'metaviz@PCDS')
****vc_coo: abnormal Epoch value from column 'Epoch': 0.000000 (assume 2000.000000)
****vc_coo: abnormal Epoch value from column 'Epoch': 0.000000 (assume 2000.000000)
****vc_coo: abnormal Epoch value from column 'Epoch': 0.000000 (assume 2000.000000)
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1160
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1133
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=256
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1172
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=255
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1171
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@PCDS')
++++Column 'RA(ICRS)' referenced by 'ACTflag' not found in table 'I/252/out'
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=754
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=767
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1367
----db1_reset(0 'metaviz@PCDS')
#...meta_close(1): retrieved 1/50 tuples [tested=1]
----db1_open(metaviz@PCDS) gives: 2
----Open server: 130.79.128.40, port 5432 (type postgres base vizier)
----db1_exec(2 'metaviz@PCDS'):
[1555715885]    Update METAhit set etime=609031085,  Ncalls = Ncalls+1 where catid=1252 and hstid=-1 and btime=607483800
------------(1 records affected)
----db1_exec(2 'metaviz@PCDS'):
[1555715885]    UPDATE METAstat set nlocal=nlocal+1, tlocal=609031085 Where phase=5 and catid=1252
------------(1 records affected)
....meta_stat(cat=1252, phase=5): 1 'local' updates
If you can't find a solution, report to CDS and insert into your message the following details:

.errorfile=/tmp/VR05805.err (2019-04-19T23:18:04)
-5
-out.add=.
-source=I/252/out
USNO-A2.0=0375-03084915
-ref=VIZ5cba572d16ad
elapse time 1

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


Contents of error file (/tmp/VR05805.err):
....vizier, Version 6.9
CDSportal=http://cdsportal.u-strasbg.fr/StoreVizierData.html
COCAT=130.79.128.31
COCATPORT=1801
CONTEXT_DOCUMENT_ROOT=/srv/httpd/cgi/
CONTEXT_PREFIX=/viz-bin/
Content=text/html
DOCUMENT_ROOT=/srv/httpd/Pages/
GATEWAY_INTERFACE=CGI/1.1
GLUDIR=/srv/glu
HOME=/srv/httpd
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=viztext.astro.unistra.fr
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_X_FORWARDED_FOR=18.212.239.56, 130.79.128.30
HTTP_X_FORWARDED_HOST=cdsweb.u-strasbg.fr, viztext.astro.unistra.fr
HTTP_X_FORWARDED_SERVER=cds.u-strasbg.fr, viztext.astro.unistra.fr
LC_ALL=C
LD_LIBRARY_PATH=/srv/./lib:/srv/httpd/../lib:/srv/lib:/usr/local/lib:/usr/lib
METADB=metaviz@PCDS asu asu4VizieR
NEWS=/VizieR/+news.htx
PATH=/srv/httpd/bin:/usr/local/bin:/srv/./bin:/usr/bin:/bin
PATH_INFO=/
PWD=/srv/httpd/cgi
QUERY_STRING=-out.add=.&amp;-source=I/252/out&amp;USNO-A2.0=0375-03084915
REMOTE_ADDR=172.18.0.1
REMOTE_PORT=40674
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/viz-bin/VizieR-5?-out.add=.&amp;-source=I/252/out&amp;USNO-A2.0=0375-03084915
SCRIPT_FILENAME=/srv/httpd/cgi/VizieR-5
SCRIPT_NAME=/viz-bin/VizieR-5
SERVER_ADDR=172.18.0.3
SERVER_ADMIN=gilles.landais@astro.u-strasbg.fr
SERVER_NAME=viztext.astro.unistra.fr
SERVER_PORT=80
SERVER_PROTOCOL=HTTP/1.1
SERVER_SIGNATURE=
SERVER_SOFTWARE=Apache/2.4.27 (Unix)
SESAME_SERVER=glu
SYBASE=/srv
SYCOMP=.
Vroot=/srv/httpd
v_started=2019-04-19T23:18:04 from pid=5789

################################################################
....(in): -out.add=.
....(in): -source=I/252/out
....(in): USNO-A2.0=0375-03084915
################################################################

....Trying '/srv/httpd/interfaces' => OK
....Trying '/srv/httpd/interfaces' => 4
....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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   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'):
[1555715884]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715884]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select hstid, flag from METAhst where name='58e0ea878716.u-strasbg.fr'

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'I/252/out' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@PCDS')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@PCDS'):
[1555715885]    insert into T1 values(1252)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@PCDS'):
[1555715885]    insert into T2 values(1252)
------------(1 records affected)
----db1_query(0 'metaviz@PCDS'):
[1555715885]   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@PCDS'):
[1555715885]   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'):
[1555715885]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, morexplain From METAcol where catid=0 and  tabid=11 order by colid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   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'):
[1555715885]   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'):
[1555715885]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@PCDS'):
[1555715885]   select login from METAdba where login like 'vizls%'
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 140/0 tuples [tested=140]
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid From METAcat where catid=1252 and (authid=0)
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=1252
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, morexplain From METAcol where catid=1252 order by catid,tabid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select catid, morid, text From METAmor where catid=1252 order by morid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   select filename from METAtab where catid=1252 and tabid=1
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   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 = 'METAqin'
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select colid, off7, length, sep, fnull From METAqin where catid=1252 and tabid=1 and sep=0 order by colid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=1252 and tabid=1
----display_row(I/252/out), option=5, onote=0
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, morexplain From METAcol where catid=1252 and  tabid=1 order by colid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   select filename from METAtab where catid=1252 and tabid=1
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select colid, off7, length, sep, fnull From METAqin where catid=1252 and tabid=1 and sep=0 order by colid
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=1252 and tabid=1
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name From METAucd where ucdid>=0
++++increase the precision for computed column 9
++++increase the precision for computed column 9
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name From METAfam where famid>=0
#...CooCompute  fk5(Eq=2000, Ep=2000) from:  fk5(Eq=2000, Ep=2000) [x1]
....[Epoch=(Epoch)*1+0.000000]
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid From METAcat where catid=1252 and (authid=0)
----db1_reset(0 'metaviz@PCDS')
----db1_open(metaviz@TAP_PROXY) gives: 1
----Open server: tapvizier.u-strasbg.fr, port 5435 (type postgres base vizier)
----db1_query(1 'metaviz@TAP_PROXY'):
[1555715885]   select dbname from METAtab where name='I/252/out'
----db1_close(1 'metaviz@TAP_PROXY')
change name to usnoa2 'login=vizls@TAP_PROXY)
++++increase the precision for computed column 9
++++increase the precision for computed column 9
#...CooCompute  fk4(Eq=1950, Ep=2000) from:  fk5(Eq=2000, Ep=2000) [x2]
....[Epoch=(Epoch)*1+0.000000]
++++increase the precision for computed column 9
++++increase the precision for computed column 9
#...CooCompute  gal(Eq=-nan, Ep=2000) from:  fk5(Eq=2000, Ep=2000) [x3]
....[Epoch=(Epoch)*1+0.000000]
....LaunchQuery: Columns, starting by = for Displayed ones:
..  =_RAJ2000 =_DEJ2000 =_RAB1950 =_DEB1950 =_Glon =_Glat =USNO-A2.0 =RAJ2000 =DEJ2000 =ACTflag =Mflag =Bmag =Rmag =Epoch
++++update index constraint to USNO-A2.0==0375-03084915
----db1_open(vizls@TAP_PROXY) gives: 1
----Open server: tapvizier.u-strasbg.fr, port 5435 (type postgres base vizier)
....TAPquery - set timeout
----db1_query(1 'vizls@TAP_PROXY'):
[1555715885]   Select USNO_A2_0, RAJ2000, DEJ2000, ACTflag, Mflag, Bmag, Rmag, Epoch From usnoa2 Where (USNO_A2_0 = '0375-03084915')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid From METAcat where catid=1252 and (authid=0)
----db1_reset(0 'metaviz@PCDS')
****vc_coo: abnormal Epoch value from column 'Epoch': 0.000000 (assume 2000.000000)
****vc_coo: abnormal Epoch value from column 'Epoch': 0.000000 (assume 2000.000000)
****vc_coo: abnormal Epoch value from column 'Epoch': 0.000000 (assume 2000.000000)
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1160
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1133
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=256
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1172
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=255
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1171
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@PCDS')
++++Column 'RA(ICRS)' referenced by 'ACTflag' not found in table 'I/252/out'
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=754
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=767
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@PCDS')
----db1_query(0 'metaviz@PCDS'):
[1555715885]   Select famid, name, explain From METAfam where famid=1367
----db1_reset(0 'metaviz@PCDS')
#...meta_close(1): retrieved 1/50 tuples [tested=1]
----db1_open(metaviz@PCDS) gives: 2
----Open server: 130.79.128.40, port 5432 (type postgres base vizier)
----db1_exec(2 'metaviz@PCDS'):
[1555715885]    Update METAhit set etime=609031085,  Ncalls = Ncalls+1 where catid=1252 and hstid=-1 and btime=607483800
------------(1 records affected)
----db1_exec(2 'metaviz@PCDS'):
[1555715885]    UPDATE METAstat set nlocal=nlocal+1, tlocal=609031085 Where phase=5 and catid=1252
------------(1 records affected)
....meta_stat(cat=1252, phase=5): 1 'local' updates
----db1_close(0 'metaviz@PCDS')
----db1_close(1 'vizls@TAP_PROXY')
----db1_close(2 'metaviz@PCDS')

Thanks for acknowledging the VizieR Service
Rules of usage of VizieR data

© Université de Strasbourg/CNRS

    • Contact