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) |
You can access this table using the query interface and download the results afterwards.
You can use the following DOI to cite this table in a publication:
This dataset is published under the CC0 1.0 Universal (CC0 1.0).