Table of extracted sources with calibrated magnitudes (applause_dr2.source_calib)
The table has 2592531200 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 | 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 |
pos meta.number |
(radians,radians) |
GIS index for (ra,dec) |