Archives of Photographic PLates for Astronomical USE

Extracted sources (applause_dr4.source)

The table has 4486298192 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 DR4, 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

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

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

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

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

model_prediction float stat.likelihood

likelihood of being an artifact (0) or a detection (1)

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