Archives of Photographic PLates for Astronomical USE

Table of extracted sources with calibrated magnitudes (applause_dr2.source_calib)

The table has 2591758848 rows, 68 columns.

Description

Sources with calibrated magnitudes by pyplate. For calibration a crossmatch of UCAC4 and APASS was used. Catalog identifiers are given, together with match quality indicators, when a match in those cataclogs has been indentified. The magnitude calibration uses the values of the phot_* tables. Unique Identifier source_id

Attribution

If you have made substantial use of the data provided by APPLAUSE DR2, kindly include this acknowledgement

Funding for APPLAUSE has been provided by DFG (German Research Foundation, Grant), Leibniz Institute for Astrophysics Potsdam (AIP), Dr. Remeis Sternwarte Bamberg (University Nuernberg/Erlangen), the Hamburger Sternwarte (University of Hamburg) and Tartu Observatory.

Columns

Name Type UCD Unit Description
source_id long meta.id
meta.main
Source identification number
process_id int meta.id Process identification number
scan_id int meta.id Scan identification number
exposure_id int meta.id Exposure identification number
plate_id int meta.id Plate identification number
archive_id int meta.id Archive identification number
annular_bin short meta.code Annular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)
dist_center double pos.distance pix Distance of the source from plate center
dist_edge double pos.distance pix Distance of the source from plate edge
sextractor_flags short meta.code Flags given by SExtractor
raj2000 double pos.eq.ra deg Right ascension of the source (equinox J2000)
dej2000 double pos.eq.dec deg Declination of the source (equinox J2000)
x_sphere double pos.cartesian.x Source x-coordinate on the unit sphere
y_sphere double pos.cartesian.y Source y-coordinate on the unit sphere
z_sphere double pos.cartesian.z Source z-coordinate on the unit sphere
healpix256 int pos.healpix Source HEALPix number (nside=256, nested ordering)
raj2000_wcs double pos.eq.ra deg Right ascension of the source based on WCS solution of the plate
dej2000_wcs double pos.eq.dec deg Declination of the source based on WCS solution of the plate
raj2000_sub double pos.eq.ra deg Right ascension of the source based on improved astrometric solution in a sub-field
dej2000_sub double pos.eq.dec deg Declination of the source based on improved astrometric solution in a sub-field
raerr_sub float stat.error
pos.eq.ra
arcsec Error for raj2000_sub
decerr_sub float stat.error
pos.eq.dec
arcsec Error for dej2000_sub
gridsize_sub short meta.number Number of sub-fields along one axis
nn_dist float pos.angDistance arcsec Distance to the nearest neighbor among extracted sources
natmag float phot.mag
em.opt
mag Calibrated magnitude of the source in the plate natural photometric system
natmagerr float stat.error
phot.mag
em.opt
mag Estimated error on the calibrated magnitude of the source in the plate natural photometric system
bmag float phot.mag
em.opt.B
mag Calibrated B magnitude of the source
bmagerr float stat.error
phot.mag
em.opt.B
mag Estimated error on the calibrated B magnitude of the source
vmag float phot.mag
em.opt.V
mag Calibrated V magnitude of the source
vmagerr float stat.error
phot.mag
em.opt.V
mag Estimated error on the calibrated V magnitude of the source
flag_calib_star short meta.code 1 if the source was used for photometric calibration, 0 otherwise
flag_calib_outlier short meta.code 1 if the source was found to be an outlier of the photometric calibration curve, 0 otherwise
color_term float stat.fit.param Color term of the plate, characterizing color response of the emulsion and filter used
color_bv float phot.color
em.opt.B
em.opt.V
mag B-V color index of the source, based on the UCAC4 or Tycho-2 catalogue
cat_natmag float phot.mag
em.opt
mag Magnitude of the source in the plate natural photometric system, B+color_term×(B-V), based on the UCAC4 or Tycho-2 catalogue
tycho2_id char meta.id.cross Identification of the matched Tycho-2 catalogue object
tycho2_ra double pos.eq.ra deg Right ascension from the Tycho-2 catalogue
tycho2_dec double pos.eq.dec deg Declination from the Tycho-2 catalogue
tycho2_btmag float phot.mag
em.opt.B
mag BT magnitude from the Tycho-2 catalogue
tycho2_vtmag float phot.mag
em.opt.V
mag VT magnitude from the Tycho-2 catalogue
tycho2_btmagerr float stat.error
phot.mag
em.opt.B
mag Error on BT magnitude from the Tycho-2 catalogue
tycho2_vtmagerr float stat.error
phot.mag
em.opt.V
mag Error on VT magnitude from the Tycho-2 catalogue
tycho2_hip int meta.id.cross Identification of the matched HIPPARCOS catalogue object
tycho2_dist float pos.angDistance arcsec Angular distance between the source and the matched Tycho-2 catalogue object
tycho2_dist2 float pos.angDistance arcsec Distance between the source and the second-to-nearest Tycho-2 catalogue object
tycho2_nn_dist float pos.angDistance arcsec Distance between the source and its nearest neighbour in the Tycho-2 catalogue
ucac4_id char meta.id.cross Identification of the matched UCAC4 catalogue object
ucac4_ra double pos.eq.ra deg Right ascension from the UCAC4 catalogue
ucac4_dec double pos.eq.dec deg Declination from the UCAC4 catalogue
ucac4_bmag float phot.mag
em.opt.B
mag B magnitude from the UCAC4 catalogue
ucac4_vmag float phot.mag
em.opt.V
mag V magnitude from the UCAC4 catalogue
ucac4_bmagerr float stat.error
phot.mag
em.opt.B
mag Error on B magnitude from the UCAC4 catalogue
ucac4_vmagerr float stat.error
phot.mag
em.opt.V
mag Error on V magnitude from the UCAC4 catalogue
ucac4_dist float pos.angDistance arcsec Distance between the source and the UCAC4 catalogue object
ucac4_dist2 float pos.angDistance arcsec Distance between the source and the second-to-nearest UCAC4 catalogue object
ucac4_nn_dist float pos.angDistance arcsec Distance between the source and its nearest neighbour in the UCAC4 catalogue
apass_ra double pos.eq.ra deg Right ascension from the APASS DR9 catalogue
apass_dec double pos.eq.ra deg Right ascension from the APASS DR9 catalogue
apass_bmag float phot.mag
em.opt.B
mag B magnitude from the APASS DR9 catalogue
apass_vmag float phot.mag
em.opt.V
mag V magnitude from the APASS DR9 catalogue
apass_bmagerr float stat.error
phot.mag
em.opt.B
mag Error on B magnitude from the APASS DR9 catalogue
apass_vmagerr float stat.error
phot.mag
em.opt.V
mag Error on V magnitude from the APASS DR9 catalogue
apass_dist float pos.angDistance arcsec Distance between the source and the APASS DR9 catalogue object
apass_dist2 float pos.angDistance arcsec Distance between the source and the second-to-nearest APASS DR9 catalogue object
apass_nn_dist float pos.angDistance arcsec Distance between the source and its nearest neighbour in the APASS DR9 catalogue
timestamp_insert timestamp time.creation Time[yyyy-mm-dd hh:mm:ss] Timestamp of insert
timestamp_update timestamp time.creation Time[yyyy-mm-dd hh:mm:ss] Timestamp of last update
pos spoint meta.number GIS index for (ra,dec)