Table information for 'ppmxl.main'


This table is available for ADQL queries and through the TAP endpoint.

Resource Description: PPMXL is a catalog of positions, proper motions, 2MASS- and optical photometry of 900 million stars and galaxies, aiming to be complete down to about V=20 full-sky. It is the result of a re-reduction of USNO-B1 together with 2MASS to the ICRS as represented by PPMX.

For a list of all services and tables belonging to this table's resource, see Information on resource 'ppmxl/q'

Citing this table

This table has an associated publication. If you use data from it, it may be appropriate to reference 2010AJ....139.2440R (ADS BibTeX entry for the publication) either in addition to or instead of the service reference.

To cite the table as such, we suggest the following BibTeX entry:

  title={Untitled Resource},
  author={Röser, S.; Demleitner, M.; Schilbach, E.},
  howpublished={{VO} resource provided by the {XAO} Data Center}

Resource Documentation

To query this data, you can use

You can retrieve also the whole data set as a gzipped text file from (39.4 GiB). The columns in the text file are in database order as documented in the table info in DB order with columns separated by vertical bars ("|").

David Tholen kindly provided code to convert this into a collection of files for easy consumption by FORTRAN programs.


Sorted by DB column index. [Sort alphabetically]

NameTable Head DescriptionUnitUCD
ipix Id Identifier (Q3C ipix of the USNO-B 1.0 object) N/A;meta.main
raj2000 RA Right Ascension J2000.0, epoch 2000.0 deg pos.eq.ra;meta.main
dej2000 Dec Declination J2000.0, epoch 2000.0 deg pos.eq.dec;meta.main
e_raepRA E_raepra Mean error in RA*cos(delta) at mean epoch deg stat.error;pos.eq.ra;meta.main
e_deepDE E_deepde Mean error in Dec at mean epoch deg stat.error;pos.eq.dec;meta.main
pmRA PM(RA) Proper Motion in RA*cos(delta) deg/yr;pos.eq.ra
pmDE PM(Dec) Proper Motion in Dec deg/yr;pos.eq.dec
e_pmRA Err. PM(RA) Mean error in pmRA*cos(delta) deg/yr stat.error;;pos.eq.ra
e_pmDE Err. PM(Dec) Mean error in pmDE deg/yr stat.error;;pos.eq.dec
nobs #obs Number of observations used [Note 4] N/A meta.number;obs
epRA Epra Mean Epoch (RA) yr time.epoch;pos.eq.ra
epDE Epde Mean Epoch (Dec) yr time.epoch;pos.eq.dec
Jmag m_J J selected default magnitude from 2MASS mag phot.mag;em.IR.J
e_Jmag Err(m_J) J total magnitude uncertainty mag stat.error;phot.mag;em.IR.J
Hmag m_H H selected default magnitude from 2MASS mag phot.mag;em.IR.H
e_Hmag Err(m_H) H total magnitude uncertainty mag stat.error;phot.mag;em.IR.H
Kmag m_K_s K_s selected default magnitude from 2MASS mag phot.mag;em.IR.K
e_Kmag Err(m_K_s) K_s total magnitude uncertainty mag stat.error;phot.mag;em.IR.K
b1mag USNO mag (B1) B mag from USNO-B, first epoch [Note 1] N/A phot.mag;em.opt.B
b2mag USNO mag (B2) B mag from USNO-B, second epoch [Note 1] N/A phot.mag;em.opt.B
r1mag USNO mag (R1) R mag from USNO-B, first epoch [Note 1] N/A phot.mag;em.opt.R
r2mag USNO mag (R2) R mag from USNO-B, second epoch [Note 1] N/A phot.mag;em.opt.R
imag USNO mag (I) I mag from USNO-B [Note 1] N/A phot.mag;em.opt.I
magSurveys USNO Mag src. Surveys the USNO-B magnitudes are taken from [Note 2] N/A meta.code
flags Flags Flags [Note 3] N/A meta.code

Columns that are parts of indices are marked like this.


The following services may use the data contained in this table:


VO nerds may sometimes need VOResource XML for this table.