Archives of Photographic PLates for Astronomical USE

Extracted sources with calibrated positions and magnitudes (applause_dr3.source_calib)

The table has 3511364096 rows, 82 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 DR3, 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 Nürnberg/Erlangen), the Hamburger Sternwarte (University of Hamburg) and Tartu Observatory. Plate material also has been made available from Thüringer Landessternwarte Tautenburg.

Columns

Name Type UCD Unit Description
source_id long meta.id
meta.main

Source identification number. The number is constructed as follows: process_id x 10000000 + source number in the image.

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

astrom_sub_grid short meta.number

Grid level for the finest sub-field where improved astrometric solution was applied to the source coordinates. Grid level is expressed as the number of divisions of an image in one axis. Possible values: 2, 4, 8, 16, 32.

astrom_sub_id int meta.id

Hierarchical sub-field number, corresponding to the sub-field where improved astrometric solution was applied to the source coordinates. See the astrom_sub table for details.

nn_dist float pos.angDistance arcsec

Distance to the nearest neighbor among extracted sources

zenith_angle float pos.az.zd

Zenith angle of the source

airmass float obs.airMass

Path length for light rays from a celestial source to pass through the atmosphere

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

natmag_plate float phot.mag
em.opt
mag

Magnitude of the source in the plate natural photometric system, obtained through photometric calibration for the whole plate

natmagerr_plate float stat.error
phot.mag
em.opt
mag

Error of the magnitude of the source in the plate natural photometric system, obtained through photometric calibration for the whole plate

phot_plate_flags short meta.code

Flag of photometric calibration: 0 - source is within the magnitude range of calibration stars; 1 - source is brighter than the brightest calibration star in the image; 2 - source is fainter than the plate faint limit

natmag_correction float phot.mag
em.opt
arith.diff
mag

Correction applied to the source magnitude in the plate natural photometric system, obtained through improved photometric calibration in sub-fields

natmag_sub float phot.mag
em.opt
mag

Magnitude of the source in the plate natural photometric system, obtained through improved photometric calibration in sub-fields

natmagerr_sub float stat.error
phot.mag
em.opt
mag

Error of the magnitude of the source in the plate natural photometric system, obtained through improved photometric calibration in sub-fields

natmag_residual float phot.mag
em.opt
arith.diff
mag

Residual of the source magnitude in the plate natural photometric system, after improved photometric calibration in sub-fields

phot_sub_grid short meta.number

Grid level for the finest sub-field where improved photometric calibration was applied to the source. Grid level is expressed as the number of divisions of an image in one axis. Possible values: 2, 4, 8, 16, 32.

phot_sub_id int meta.id

Hierarchical sub-field number, corresponding to the finest sub-field where improved photometric calibration was applied to the source. See the phot_sub table for details.

phot_sub_flags short meta.code

Flag of improved photometric calibration in the sub-field: 0 - source is within the magnitude range of calibration stars; 1 - source is brighter than the brightest calibration star in the sub-field; 2 - source is fainter than the faintest calibration star in the sub-field

phot_calib_flags short meta.code

Flag for photometric calibration stars: 0 - source is not a calibration star; 1 - source is a valid calibration star; 2 - source was found to be an outlier of the photometric calibration curve

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

match_radius float pos.angDistance arcsec

Radius in the sky plane that was used to cross-match extracted sources with external catalogues

tycho2_id char meta.id.cross

Tycho 2 identifier

tycho2_id_pad char meta.id.cross

Tycho 2 identifier padded

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.BT
mag

Estimated error on the calibrated magnitude vs BT mag Tycho-2 catalogue

tycho2_vtmagerr float stat.error
phot.mag
em.opt.VT
mag

Estimated error on the calibrated magnitude vs VT magTycho-2 catalogue

tycho2_hip int meta.id.cross

Identification of the matched HIPPARCOS catalogue object

tycho2_dist float pos.angDistance arcsec

Distance between the source and the Tycho-2 catalogue object

tycho2_dist2 float pos.angDistance arcsec

Distance between the source and second nearest object of the Tycho-2 catalogue

tycho2_nn_dist float pos.angDistance arcsec

Angular distance between the matched object and its nearest neighbor 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

Estimated error on the calibrated magnitude vs B mag UCAC4 catalogue

ucac4_vmagerr float stat.error
phot.mag
em.opt.V
mag

Estimated error on the calibrated V magnitude vs 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 nearest neighbour object in the UCAC4 catalogue

ucac4_nn_dist float pos.angDistance arcsec

Angular distance between the matched object and its nearest neighbor in the UCAC4 catalogue

apass_ra double pos.eq.ra deg

Right ascension from the APASS catalogue

apass_dec double pos.eq.dec deg

Declination from the APASS catalogue

apass_bmag float phot.mag
em.opt.B
mag

B magnitude from the APASS catalogue

apass_vmag float phot.mag
em.opt.V
mag

V magnitude from the APASS catalogue

apass_bmagerr float stat.error
phot.mag
em.opt.B
mag

Estimated error on the calibrated magnitude vs B mag APASS catalogue

apass_vmagerr float stat.error
phot.mag
em.opt.V
mag

Estimated error on the calibrated magnitude vs V mag APASS catalogue

apass_dist float pos.angDistance arcsec

Distance between the source and the APASS catalogue object

apass_dist2 float pos.angDistance arcsec

Distance between the source and the second nearest neighbour object in the APASS catalogue

apass_nn_dist float pos.angDistance arcsec

Angular distance between the matched object and its nearest neighbor in the APASS DR9 catalogue

timestamp_insert char time.creation Time[yyyy-mm-dd hh:mm:ss]

Timestamp of insert

timestamp_update char time.creation Time[yyyy-mm-dd hh:mm:ss]

Timestamp of last update

pos char meta.number (radians,radians)

GIS index for (ra,dec)