The table has 1662440576 rows, 51 columns.
Description
This is the main table of extracted sources. A row in the source table corresponds to an extracted source from a plate scan. The table contains extracted (instrumental) values provided by the SExtractor software. Calibrated data, like sky coordinates, are stored in the source_calib table. Unique Identifier source_id
Attribution
If you have made substantial use of the data provided by APPLAUSE DR1, 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) and the Hamburger Sternwarte (University of Hamburg).
Columns
| Name | Type | UCD | Unit | Description |
|---|---|---|---|---|
| source_id | int |
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 |
|
| source_num | int | meta.number |
Source number within the image |
|
| x_source | double | pos.cartesian.x |
Source coordinate along x-axis |
|
| y_source | double | pos.cartesian.y |
Source coordinate along y-axis |
|
| erra_source | float |
stat.error phys.size.smajAxis |
pix |
Uncertainty on the semi-major axis length |
| errb_source | float |
stat.error phys.size.sminAxis |
pix |
Uncertainty on the semi-minor axis length |
| errtheta_source | float |
stat.error pos.posAng |
deg |
Uncertainty on the position angle |
| a_source | float | phys.size.smajAxis | pix |
Semi-major axis length of the source |
| b_source | float | phys.size.sminAxis | pix |
Semi-minor axis length of the source |
| theta_source | float | pos.posAng | deg |
Position angle |
| elongation | float | phys.size.axisRatio |
Source elongation (a_source / b_source) |
|
| x_peak | int | pos.cartesian.x |
Source peak (brightest pixel) coordinate along x-axis |
|
| y_peak | int | pos.cartesian.y |
Source peak (brightest pixel) coordinate along y-axis |
|
| flag_usepsf | short | meta.code |
1 if source position has been determined by PSF fitting, 0 if barycenter has been used |
|
| x_image | double | pos.cartesian.x |
Source barycenter coordinate along x-axis |
|
| y_image | double | pos.cartesian.y |
Source barycenter coordinate along y-axis |
|
| erra_image | float |
stat.error phys.size.smajAxis |
pix |
Uncertainty on the semi-major axis length (barycenter method) |
| errb_image | float |
stat.error phys.size.sminAxis |
pix |
Uncertainty on the semi-minor axis length (barycenter method) |
| errtheta_image | float |
stat.error pos.posAng |
deg |
Uncertainty on the position angle (barycenter method) |
| x_psf | double | pos.cartesian.x |
Source coordinate along x-axis, determined by PSF fitting |
|
| y_psf | double | pos.cartesian.y |
Source coordinate along y-axis, determined by PSF fitting |
|
| erra_psf | float |
stat.error phys.size.smajAxis |
pix |
Uncertainty on the semi-major axis length (PSF fitting) |
| errb_psf | float |
stat.error phys.size.sminAxis |
pix |
Uncertainty on the semi-minor axis length (PSF fitting) |
| errtheta_psf | float |
stat.error pos.posAng |
deg |
Uncertainty on the position angle (PSF fitting) |
| mag_auto | float | phot.mag | mag |
Kron-like elliptical aperture magnitude |
| magerr_auto | float |
stat.error phot.mag |
mag |
Error for mag_auto |
| flux_auto | float | phot.count |
Flux within a Kron-like elliptical aperture |
|
| fluxerr_auto | float |
stat.error phot.count |
Error for flux_auto |
|
| mag_iso | float | phot.mag | mag |
Isophotal magnitude |
| magerr_iso | float |
stat.error phot.mag |
mag |
Error for isophotal magnitude |
| flux_iso | float | phot.count |
Isophotal flux |
|
| fluxerr_iso | float |
stat.error phot.count |
Error for isophotal flux |
|
| flux_max | float | phot.count |
Peak flux above background |
|
| flux_radius | float | stat.value | pix |
Fraction-of-light radius |
| isoarea | int | stat.value | pix2 |
Isophotal area above threshold |
| sqrt_isoarea | float | stat.value | pix |
Square root of the isophotal area above threshold |
| background | float | stat.value |
Background value |
|
| sextractor_flags | short | meta.code |
Flags given by SExtractor |
|
| 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 |
| 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) |
|
| flag_rim | short | meta.code |
1 if source is found to be at plate rim, 0 otherwise |
|
| flag_negradius | short | meta.code |
1 if flux_radius is negative, 0 otherwise |
|
| flag_clean | short | meta.code |
1 if source is not at the rim, flux_radius is not negative, and elongation < 5, 0 otherwise |
|
| 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 |
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).