TABLE  ultravistaMapLcVariability

Contains statistical analysis of ULTRAVISTA remeasurements.

Photometric variability statistics for matched aperture photometry
Variability statistics in Y, J, H, Ks, Nb118 bands

Required constraints:
  • Primary key is (apertureID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
apertureIDbigint8 UID of aperture from MapApertureIDsultraVistaMapLc meta.main;meta.id
cuEventIDint4 UID of curation event giving rise to this record meta.code
fieldIDbigint8 field ID assigned by ProgrammeBuilder module when grouping. meta.id;obs.field
ynPosObs link to glossaryint4 Number of unflagged positive measurements in Y band0 
ynPosFlagObs link to glossaryint4 Number of flagged positive measurements in Y band by ultravistaMapRemeasurement.ppErrBits0 
ynNegObs link to glossaryint4 Number of unflagged negative measurements Y band0 
ynNegFlagObs link to glossaryint4 Number of flagged negative measurements in Y band by ultravistaMapRemeasurement.ppErrBits0 
ybestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the Y band-9999 
yminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
ymedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
ymaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
ytotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
ymeanMag link to glossaryreal4magMean Y magnitude-0.9999995e9 
ymedianMag link to glossaryreal4magMedian Y magnitude-0.9999995e9 
yMagRms link to glossaryreal4magrms of Y magnitude-0.9999995e9 
yMagMAD link to glossaryreal4magMedian Absolute Deviation of Y magnitude-0.9999995e9 
yskewness link to glossaryreal4 Skewness in Y band (see Sesar et al. 2007)-0.9999995e9 
yMinMag link to glossaryreal4 Minimum magnitude in Y band, of good detections-0.9999995e9 
yMaxMag link to glossaryreal4 Maximum magnitude in Y band, of good detections-0.9999995e9 
yNgt3sig link to glossarysmallint2 Number of good detections in Y-band that are more than 3 sigma deviations (yAperMagN < (yMeanMag-3*yMagRms)-9999 
yExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in Y band-0.9999995e9 
yIntRms link to glossaryreal4magIntrinsic rms in Y-band-0.9999995e9 
ychiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
yndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
yprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
yVarClass link to glossarysmallint2 Classification of variability in this band-9999 
jnPosObs link to glossaryint4 Number of unflagged positive measurements in J band0 
jnPosFlagObs link to glossaryint4 Number of flagged positive measurements in J band by ultravistaMapRemeasurement.ppErrBits0 
jnNegObs link to glossaryint4 Number of unflagged negative measurements J band0 
jnNegFlagObs link to glossaryint4 Number of flagged negative measurements in J band by ultravistaMapRemeasurement.ppErrBits0 
jbestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the J band-9999 
jminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
jmedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
jmaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
jtotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
jmeanMag link to glossaryreal4magMean J magnitude-0.9999995e9 
jmedianMag link to glossaryreal4magMedian J magnitude-0.9999995e9 
jMagRms link to glossaryreal4magrms of J magnitude-0.9999995e9 
jMagMAD link to glossaryreal4magMedian Absolute Deviation of J magnitude-0.9999995e9 
jskewness link to glossaryreal4 Skewness in J band (see Sesar et al. 2007)-0.9999995e9 
jMinMag link to glossaryreal4 Minimum magnitude in J band, of good detections-0.9999995e9 
jMaxMag link to glossaryreal4 Maximum magnitude in J band, of good detections-0.9999995e9 
jNgt3sig link to glossarysmallint2 Number of good detections in J-band that are more than 3 sigma deviations (jAperMagN < (jMeanMag-3*jMagRms)-9999 
jExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in J band-0.9999995e9 
jIntRms link to glossaryreal4magIntrinsic rms in J-band-0.9999995e9 
jchiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
jndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
jprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
jVarClass link to glossarysmallint2 Classification of variability in this band-9999 
hnPosObs link to glossaryint4 Number of unflagged positive measurements in H band0 
hnPosFlagObs link to glossaryint4 Number of flagged positive measurements in H band by ultravistaMapRemeasurement.ppErrBits0 
hnNegObs link to glossaryint4 Number of unflagged negative measurements H band0 
hnNegFlagObs link to glossaryint4 Number of flagged negative measurements in H band by ultravistaMapRemeasurement.ppErrBits0 
hbestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the H band-9999 
hminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
hmedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
hmaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
htotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
hmeanMag link to glossaryreal4magMean H magnitude-0.9999995e9 
hmedianMag link to glossaryreal4magMedian H magnitude-0.9999995e9 
hMagRms link to glossaryreal4magrms of H magnitude-0.9999995e9 
hMagMAD link to glossaryreal4magMedian Absolute Deviation of H magnitude-0.9999995e9 
hskewness link to glossaryreal4 Skewness in H band (see Sesar et al. 2007)-0.9999995e9 
hMinMag link to glossaryreal4 Minimum magnitude in H band, of good detections-0.9999995e9 
hMaxMag link to glossaryreal4 Maximum magnitude in H band, of good detections-0.9999995e9 
hNgt3sig link to glossarysmallint2 Number of good detections in H-band that are more than 3 sigma deviations (hAperMagN < (hMeanMag-3*hMagRms)-9999 
hExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in H band-0.9999995e9 
hIntRms link to glossaryreal4magIntrinsic rms in H-band-0.9999995e9 
hchiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
hndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
hprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
hVarClass link to glossarysmallint2 Classification of variability in this band-9999 
ksnPosObs link to glossaryint4 Number of unflagged positive measurements in Ks band0 
ksnPosFlagObs link to glossaryint4 Number of flagged positive measurements in Ks band by ultravistaMapRemeasurement.ppErrBits0 
ksnNegObs link to glossaryint4 Number of unflagged negative measurements Ks band0 
ksnNegFlagObs link to glossaryint4 Number of flagged negative measurements in Ks band by ultravistaMapRemeasurement.ppErrBits0 
ksbestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the Ks band-9999 
ksminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
ksmedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
ksmaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
kstotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
ksmeanMag link to glossaryreal4magMean Ks magnitude-0.9999995e9 
ksmedianMag link to glossaryreal4magMedian Ks magnitude-0.9999995e9 
ksMagRms link to glossaryreal4magrms of Ks magnitude-0.9999995e9 
ksMagMAD link to glossaryreal4magMedian Absolute Deviation of Ks magnitude-0.9999995e9 
ksskewness link to glossaryreal4 Skewness in Ks band (see Sesar et al. 2007)-0.9999995e9 
ksMinMag link to glossaryreal4 Minimum magnitude in Ks band, of good detections-0.9999995e9 
ksMaxMag link to glossaryreal4 Maximum magnitude in Ks band, of good detections-0.9999995e9 
ksNgt3sig link to glossarysmallint2 Number of good detections in Ks-band that are more than 3 sigma deviations (ksAperMagN < (ksMeanMag-3*ksMagRms)-9999 
ksExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in Ks band-0.9999995e9 
ksIntRms link to glossaryreal4magIntrinsic rms in Ks-band-0.9999995e9 
kschiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
ksndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
ksprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
ksVarClass link to glossarysmallint2 Classification of variability in this band-9999 
nb118nPosObs link to glossaryint4 Number of unflagged positive measurements in Nb118 band0 
nb118nPosFlagObs link to glossaryint4 Number of flagged positive measurements in Nb118 band by ultravistaMapRemeasurement.ppErrBits0 
nb118nNegObs link to glossaryint4 Number of unflagged negative measurements Nb118 band0 
nb118nNegFlagObs link to glossaryint4 Number of flagged negative measurements in Nb118 band by ultravistaMapRemeasurement.ppErrBits0 
nb118bestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the Nb118 band-9999 
nb118minCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
nb118medCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
nb118maxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
nb118totalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
nb118meanMag link to glossaryreal4magMean Nb118 magnitude-0.9999995e9 
nb118medianMag link to glossaryreal4magMedian Nb118 magnitude-0.9999995e9 
nb118MagRms link to glossaryreal4magrms of Nb118 magnitude-0.9999995e9 
nb118MagMAD link to glossaryreal4magMedian Absolute Deviation of Nb118 magnitude-0.9999995e9 
nb118skewness link to glossaryreal4 Skewness in Nb118 band (see Sesar et al. 2007)-0.9999995e9 
nb118MinMag link to glossaryreal4 Minimum magnitude in Nb118 band, of good detections-0.9999995e9 
nb118MaxMag link to glossaryreal4 Maximum magnitude in Nb118 band, of good detections-0.9999995e9 
nb118Ngt3sig link to glossarysmallint2 Number of good detections in Nb118-band that are more than 3 sigma deviations (nb118AperMagN < (nb118MeanMag-3*nb118MagRms)-9999 
nb118ExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in Nb118 band-0.9999995e9 
nb118IntRms link to glossaryreal4magIntrinsic rms in Nb118-band-0.9999995e9 
nb118chiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
nb118ndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
nb118probVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
nb118VarClass link to glossarysmallint2 Classification of variability in this band-9999 
variableClass link to glossaryint4 Classification of objects across all bands.-99999999 
Total length454