TABLE  videoDetection

Contains the individual VIDEO source detections for each frame.

This table contains the individual detections for sources originating
from multiframe images taken for the VIDEO (VIDEO).
Where a value is derived from an SExtractor(SE) parameter that parameter
name is mentioned in brackets.


Required constraints:
  • Primary key is (multiframeID,extNum,seqNum)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
multiframeIDbigint8 the UID of the relevant multiframe obs.field
extNumtinyint1 the extension number of this frame meta.number
cuEventIDint4 UID of curation event giving rise to this record meta.bib
seqNum tooltipint4 the running number of this detection {catalogue TType keyword: Sequence_number} meta.id
filterIDtinyint1 UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks,8=blank) meta.code;instr.filter
isoFlux link to glossaryreal4ADUInstrumental isophotal flux counts (SE: FLUX_ISO) {catalogue TType keyword: Isophotal_flux} phot.count;em.opt
isoMagreal4magCalibrated isophotal magnitude phot.mag
x tooltipreal4pixelsX coordinate of detection (SE: X_IMAGE) {catalogue TType keyword: X_coordinate} pos.cartesian.x;instr.plate
xErr tooltipreal4pixelsError in X coordinate (SE: ERRX2_IMAGE½) {catalogue TType keyword: X_coordinate_err} stat.error
y tooltipreal4pixelsY coordinate of detection (SE: Y_IMAGE) {catalogue TType keyword: Y_coordinate} pos.cartesian.y;instr.plate
yErr tooltipreal4pixelsError in Y coordinate (SE: ERRY2_IMAGE½) {catalogue TType keyword: Y_coordinate_err} stat.error
gauSig link to glossaryreal4pixelsRMS of axes of ellipse fit {catalogue TType keyword: Gaussian_sigma} src.morph.param
ellreal4 1-b/a, where a/b=semi-major/minor axes (SE: THETA_IMAGE) {catalogue TType keyword: Ellipticity} src.ellipticity
pa tooltipreal4degreesellipse fit orientation to x axis {catalogue TType keyword: Position_angle} pos.posAng
aProf1 link to glossaryreal4pixel²Isophotal area at level 0 (analysis threshold) (SE: ISO0) {catalogue TType keyword: Areal_1_profile} meta.number
aProf2 tooltipint4pixel²Isophotal area at level 1 above analysis threshold (SE: ISO1) {catalogue TType keyword: Areal_2_profile} meta.number
aProf3 tooltipint4pixel²Isophotal area at level 2 above analysis threshold (SE: ISO2) {catalogue TType keyword: Areal_3_profile} meta.number
aProf4 tooltipint4pixel²Isophotal area at level 3 above analysis threshold (SE: ISO3) {catalogue TType keyword: Areal_4_profile} meta.number
aProf5 tooltipint4pixel²Isophotal area at level 4 above analysis threshold (SE: ISO4) {catalogue TType keyword: Areal_5_profile} meta.number
aProf6 tooltipint4pixel²Isophotal area at level 5 above analysis threshold (SE: ISO5) {catalogue TType keyword: Areal_6_profile} meta.number
aProf7 tooltipint4pixel²Isophotal area at level 6 above analysis threshold (SE: ISO6) {catalogue TType keyword: Areal_7_profile} meta.number
aProf8 tooltipint4pixel²Isophotal area at level 7 above analysis threshold (SE: ISO7) {catalogue TType keyword: Areal_8_profile} meta.number
pHeight tooltipreal4ADUHighest pixel value above sky (SE: FLUX_MAX) {catalogue TType keyword: Peak_height} phot.count
pHeightErr tooltipreal4ADUError in peak height {catalogue TType keyword: Peak_height_err} stat.error
aperFlux1 tooltip real4ADUDefault aperture flux counts 1, no aperture correction applied (SE: FLUX_APER1) {catalogue TType keyword: Aper_flux_1} phot.count;em.opt
aperFlux1errreal4ADUError in aperture flux counts 1 (SE: FLUXERR_APER1) {catalogue TType keyword: Aper_flux_1_err} stat.error
aperMagNoAperCorr1 link to glossaryreal4magCalibrated and standard corrected (but no aperture correction applied) aperture magnitude 1 phot.mag
aperMag1real4magCalibrated and corrected aperture magnitude 1 phot.mag
aperMag1errreal4magError in calibrated aperture magnitude 1 stat.error
aperFlux2 tooltipreal4ADUDefault aperture flux 2, no aperture correction applied (SE: FLUX_APER2) {catalogue TType keyword: Aper_flux_2} phot.count;em.opt
aperFlux2errreal4ADUError in aperture flux 2 (SE: FLUXERR_APER2) {catalogue TType keyword: Aper_flux_2_err} stat.error
aperMagNoAperCorr2 link to glossaryreal4magCalibrated and standard corrected (but no aperture correction applied) aperture magnitude 2 phot.mag
aperMag2real4magCalibrated and corrected aperture magnitude 2 phot.mag
aperMag2errreal4magError in calibrated aperture magnitude 2 stat.error
aperFlux3 tooltipreal4ADUdefault aperture flux 3, no aperture correction applied (SE: FLUX_APER3) {catalogue TType keyword: Aper_flux_3}aperturephot.count;em.opt
aperFlux3errreal4ADUError in aperture flux 3 (SE: FLUXERR_APER3) {catalogue TType keyword: Aper_flux_3_err} stat.error
aperMagNoAperCorr3 link to glossaryreal4magCalibrated and standard corrected (but no aperture correction applied) aperture magnitude 3 phot.mag
aperMag3real4magCalibrated and corrected aperture magnitude 3 phot.mag
aperMag3errreal4magError in calibrated aperture magnitude 3 stat.error
aperFlux4 tooltipreal4ADUdefault aperture flux 4, no aperture correction applied (SE: FLUX_APER4) {catalogue TType keyword: Aper_flux_4}aperturephot.count;em.opt
aperFlux4errreal4ADUError in aperture flux 4 (SE: FLUXERR_APER4) {catalogue TType keyword: Aper_flux_4_err} stat.error
aperMagNoAperCorr4 link to glossaryreal4magCalibrated and standard corrected (but no aperture correction applied) aperture magnitude 4 phot.mag
aperMag4real4magCalibrated and corrected aperture magnitude 4 phot.mag
aperMag4errreal4magError in calibrated aperture magnitude 4 stat.error
aperFlux5 tooltipreal4ADUdefault aperture flux 5, no aperture correction applied (SE: FLUX_APER5) {catalogue TType keyword: Aper_flux_5}aperturephot.count;em.opt
aperFlux5errreal4ADUError in aperture flux 5 (SE: FLUXERR_APER5) {catalogue TType keyword: Aper_flux_5_err} stat.error
aperMagNoAperCorr5 link to glossaryreal4magCalibrated and standard corrected (but no aperture correction applied) aperture magnitude 5 phot.mag
aperMag5real4magCalibrated and corrected aperture magnitude 5 phot.mag
aperMag5errreal4magError in calibrated aperture magnitude 5 stat.error
aperFlux6 tooltipreal4ADUdefault aperture flux 6, no aperture correction applied (SE: FLUX_APER6) {catalogue TType keyword: Aper_flux_6}aperturephot.count;em.opt
aperFlux6errreal4ADUError in aperture flux 6 (SE: FLUXERR_APER6) {catalogue TType keyword: Aper_flux_6_err} stat.error
aperMagNoAperCorr6 link to glossaryreal4magCalibrated and standard corrected (but no aperture correction applied) aperture magnitude 6 phot.mag
aperMag6real4magCalibrated and corrected aperture magnitude 6 phot.mag
aperMag6errreal4magError in calibrated aperture magnitude 6 stat.error
aperFlux7 tooltipreal4ADUdefault aperture flux 7, no aperture correction applied (SE: FLUX_APER7) {catalogue TType keyword: Aper_flux_7}aperturephot.count;em.opt
aperFlux7errreal4ADUError in aperture flux 7 (SE: FLUXERR_APER7) {catalogue TType keyword: Aper_flux_7_err} stat.error
aperMagNoAperCorr7 link to glossaryreal4magCalibrated and standard corrected (but no aperture correction applied) aperture magnitude 7 phot.mag
aperMag7real4magCalibrated and corrected aperture magnitude 7 phot.mag
aperMag7errreal4magError in calibrated aperture magnitude 7 stat.error
aperFlux8 tooltipreal4ADUdefault aperture flux 8, no aperture correction applied (SE: FLUX_APER8) {catalogue TType keyword: Aper_flux_8}aperturephot.count;em.opt
aperFlux8errreal4ADUError in aperture flux 8 (SE: FLUXERR_APER8) {catalogue TType keyword: Aper_flux_8_err} stat.error
aperMag8real4magCalibrated and corrected aperture magnitude 8 phot.mag
aperMag8errreal4magError in calibrated aperture magnitude 8 stat.error
aperFlux9 tooltipreal4ADUdefault aperture flux 9, no aperture correction applied (SE: FLUX_APER9) {catalogue TType keyword: Aper_flux_9}aperturephot.count;em.opt
aperFlux9errreal4ADUError in aperture flux 9 (SE: FLUXERR_APER9) {catalogue TType keyword: Aper_flux_9_err} stat.error
aperMag9real4magCalibrated and corrected aperture magnitude 9 phot.mag
aperMag9errreal4magError in calibrated aperture magnitude 9 stat.error
aperFlux10 tooltipreal4ADUdefault aperture flux 10, no aperture correction applied (SE: FLUX_APER10) {catalogue TType keyword: Aper_flux_10}aperturephot.count;em.opt
aperFlux10errreal4ADUError in aperture flux 10 (SE: FLUXERR_APER10) {catalogue TType keyword: Aper_flux_10_err} stat.error
aperMag10real4magCalibrated and corrected aperture magnitude 10 phot.mag
aperMag10errreal4magError in calibrated aperture magnitude 10 stat.error
aperFlux11 tooltipreal4ADUdefault aperture flux 11, no aperture correction applied (SE: FLUX_APER11) {catalogue TType keyword: Aper_flux_11}aperturephot.count;em.opt
aperFlux11errreal4ADUError in aperture flux 11 (SE: FLUXERR_APER11) {catalogue TType keyword: Aper_flux_11_err} stat.error
aperMag11real4magCalibrated and corrected aperture magnitude 11 phot.mag
aperMag11errreal4magError in calibrated aperture magnitude 11 stat.error
aperFlux12 tooltipreal4ADUdefault aperture flux 12, no aperture correction applied (SE: FLUX_APER12) {catalogue TType keyword: Aper_flux_12}aperturephot.count;em.opt
aperFlux12errreal4ADUError in aperture flux 12 (SE: FLUXERR_APER12) {catalogue TType keyword: Aper_flux_12_err} stat.error
aperMag12real4magCalibrated and corrected aperture magnitude 12 phot.mag
aperMag12errreal4magError in calibrated aperture magnitude 12 stat.error
aperFlux13 tooltipreal4ADUdefault aperture flux 13, no aperture correction applied (SE: FLUX_APER13) {catalogue TType keyword: Aper_flux_13}aperturephot.count;em.opt
aperFlux13errreal4ADUError in aperture flux 13 (SE: FLUXERR_APER13) {catalogue TType keyword: Aper_flux_13_err} stat.error
aperMag13real4magCalibrated and corrected aperture magnitude 13 phot.mag
aperMag13errreal4magError in calibrated aperture magnitude 13 stat.error
petroRad link to glossaryreal4pixelsPetrosian radius (SE: PETRO_RADIUS*A_IMAGE) {catalogue TType keyword: Petr_radius} phys.angSize;src
kronRad tooltip real4pixelsKron radius as defined in SE by Graham and Driver (2005) (SE: KRON_RADIUS*A_IMAGE) {catalogue TType keyword: Kron_radius} phys.angSize;src
halfRadreal4pixelsSExtractor half-light radius (FRAC_RADIUS), calcuated assuming Kron flux is total flux {catalogue TType keyword: Half_radius} phys.angSize;src
hlCircRadAs link to glossaryreal4arcsecCircular half-light radius computed from curve of growth assuming petrosian flux is 90% of total-0.9999995e9phys.angSize;src
hlCircRadErrAs link to glossaryreal4arcsecError in hlCircRadAs-0.9999995e9phys.angSize;src
hlGeoRadAs link to glossaryreal4arcsecGeometric half-light radius-0.9999995e9phys.angSize;src
hlSMnRadAs link to glossaryreal4arcsecHalf-light semi-minor axis-0.9999995e9 
hlSMjRadAs link to glossaryreal4arcsecHalf-light semi-major axis-0.9999995e9 
hlCorSMnRadAs link to glossaryreal4arcsecSeeing corrected Half-light semi-minor axis-0.9999995e9 
hlCorSMjRadAsreal4arcsecSeeing corrected Half-light semi-major axis-0.9999995e9 
petroFluxreal4ADUflux within Petrosian radius circular aperture (SE: FLUX_PETRO) {catalogue TType keyword: Petr_flux} phot.count;em.opt
petroFluxErrreal4ADUerror on Petrosian flux (SE: FLUXERR_PETRO) {catalogue TType keyword: Petr_flux_err} stat.error
petroMagreal4magCalibrated Petrosian magnitude within circular aperture r_p phot.mag
petroMagErrreal4magerror on calibrated Petrosian magnitude stat.error
kronFluxreal4ADUflux within Kron radius circular aperture (SE: FLUX_AUTO) {catalogue TType keyword: Kron_flux} phot.count;em.opt
kronFluxErrreal4ADUerror on Kron flux (SE: FLUXERR_AUTO) {catalogue TType keyword: Kron_flux_err} stat.error
kronMagreal4magCalibrated Kron magnitude within circular aperture r_k phot.mag
kronMagErrreal4magerror on calibrated Kron magnitude stat.error
halfFluxreal4ADUHalf the total flux (max(isoFlux,aperFlux5), used in the halfRad calculation, not available in SE output {catalogue TType keyword: Half_flux}-0.9999995e9phot.count;em.opt
halfFluxErrreal4ADUerror on Half flux, not available in SE output {catalogue TType keyword: Half_flux_err}-0.9999995e9stat.error
halfMagreal4magCalibrated magnitude within circular aperture halfRad, not available in SE output phot.mag
halfMagErrreal4magCalibrated error on Half magnitude, not available in SE output stat.error
errBits link to glossaryint4 processing warning/error bitwise flags {catalogue TType keyword: Error_bit_flag} meta.code
skyreal4ADUlocal interpolated sky level from background tracker (SE: BACKGROUND) {catalogue TType keyword: Sky_level} instr.skyLevel
skyVarreal4ADUlocal estimate of variation in sky level around image (SE: THRESHOLD) {catalogue TType keyword: Sky_rms} instr.skyLevel
averageConfreal4 The average confidence level in the default 2 arcsec diameter aperture (aper3), not available in SE output {catalogue TType keyword: Av_conf}-99999999meta.code
mjdfloat8dayThe mean Modified Julian Day of each detection {catalogue TType keyword: MJDoff}  
ra link to glossaryfloat8DegreesCelestial Right Ascension pos.eq.ra;meta.main
dec link to glossaryfloat8DegreesCelestial Declination pos.eq.dec;meta.main
cxfloat8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.x
cyfloat8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.y
czfloat8 unit vector of spherical co-ordinates pos.distance;pos.cartesian.z
htmIDbigint8 Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates pos.eq
lfloat8DegreesGalactic longitude pos.galactic.lon
bfloat8DegreesGalactic latitude pos.galactic.lat
lambdafloat8DegreesSDSS system spherical co-ordinate 1 pos
etafloat8DegreesSDSS system spherical co-ordinate 2 pos
class tooltip smallint2 Flag indicating most probable morphological classification {catalogue TType keyword: Classification} src.class
classStat link to glossaryreal4 S-Extractor classification statistic CLASS_STAR (0 - galaxy, 1 - star) {catalogue TType keyword: Statistic} stat
psfFluxreal4 Not available in SE output {catalogue TType keyword: PSF_flux}-0.9999995e9 
psfFluxErrreal4 Not available in SE output {catalogue TType keyword: PSF_flux_err}-0.9999995e9 
psfMagreal4 Not available in SE output-0.9999995e9 
psfMagErrreal4 Not available in SE output-0.9999995e9 
psfFitXreal4 Not available in SE output {catalogue TType keyword: PSF_fit_X}-0.9999995e9 
psfFitXerrreal4 Not available in SE output {catalogue TType keyword: PSF_fit_X_err}-0.9999995e9 
psfFitYreal4 Not available in SE output {catalogue TType keyword: PSF_fit_Y}-0.9999995e9 
psfFitYerrreal4 Not available in SE output {catalogue TType keyword: PSF_fit_y_err}-0.9999995e9 
psfFitChi2real4 Not available in SE output {catalogue TType keyword: PSF_fit_chi2}-0.9999995e9 
psfFitDofsmallint2 Not available in SE output {catalogue TType keyword: PSF_fit_dof}-9999 
SerFlux1Dreal4 SExtractor parameter {catalogue TType keyword: 1D_Sersic_flux}-0.9999995e9 
SerMag1Dreal4 SExtractor parameter-0.9999995e9 
SerScaleLen1Dreal4 SExtractor parameter {catalogue TType keyword: 1D_Sersic_scale_len}-0.9999995e9 
SerIdx1Dreal4 SExtractor parameter {catalogue TType keyword: 1D_Sersic_index}-0.9999995e9 
SerFit1DChi2real4 SExtractor parameter {catalogue TType keyword: 1D_Sersic_fit_chi2}-0.9999995e9 
SerFitNu1Dreal4 SExtractor parameter {catalogue TType keyword: 1D_Sersic_fit_nu}-0.9999995e9 
SerFlux2Dreal4 SExtractor parameter {catalogue TType keyword: 2D_Sersic_flux}-0.9999995e9 
SerMag2Dreal4 SExtractor parameter-0.9999995e9 
SerScaleLen2Dreal4 SExtractor parameter {catalogue TType keyword: 2D_Sersic_scale_len}-0.9999995e9 
SerIdx2Dreal4 SExtractor parameter {catalogue TType keyword: 2D_Sersic_index}-0.9999995e9 
SerFit2DChi2real4 SExtractor parameter {catalogue TType keyword: 2D_Sersic_fit_chi2}-0.9999995e9 
SerFitNu2Dreal4 SExtractor parameter {catalogue TType keyword: 2D_Sersic_fit_nu}-0.9999995e9 
deltaMagreal4 sum of magnitude corrections for faster processing0.0 
illumCorrreal4 illumination correction0.0 
distortCorrreal4 distortion correction0.0 
saturatCorrreal4 saturation correction0.0 
ppErrBits link to glossaryint4 additional WFAU post-processing error bits0meta.code
deprecated link to glossarytinyint1 Code for a current (=0) or deprecated (!=0) detection0meta.code
objID link to glossarybigint8 Unique identifier for this detection or default for no detection-99999999meta.id;meta.main
Total length643