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

Access

You can access this table using the query interface and download the results afterwards.

Digital object identifier

You can use the following DOI to cite this table in a publication:

https://doi.org/10.17876/plate/dr.4/12

License

This dataset is published under the CC0 1.0 Universal (CC0 1.0).