TABLE  hzqCompMapVariability

Contains statistical analysis of WSERV1000 remeasurements.

Photometric variability statistics for matched aperture photometry
Variability statistics in Z, Y, J, H, K, H2, Nbj, Nbh bands

Required constraints:
  • Primary key is (apertureID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
apertureIDbigint8 UID of aperture from MapApertureIDshzqCompMap 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
znPosObs link to glossaryint4 Number of unflagged positive measurements in Z band0 
znPosFlagObs link to glossaryint4 Number of flagged positive measurements in Z band by wserv1000MapRemeasurement.ppErrBits0 
znNegObs link to glossaryint4 Number of unflagged negative measurements Z band0 
znNegFlagObs link to glossaryint4 Number of flagged negative measurements in Z band by wserv1000MapRemeasurement.ppErrBits0 
zbestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the Z band-9999 
zminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
zmedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
zmaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
ztotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
zmeanMag link to glossaryreal4magMean Z magnitude-0.9999995e9 
zmedianMag link to glossaryreal4magMedian Z magnitude-0.9999995e9 
zMagRms link to glossaryreal4magrms of Z magnitude-0.9999995e9 
zMagMAD link to glossaryreal4magMedian Absolute Deviation of Z magnitude-0.9999995e9 
zskewness link to glossaryreal4 Skewness in Z band (see Sesar et al. 2007)-0.9999995e9 
zMinMag link to glossaryreal4 Minimum magnitude in Z band, of good detections-0.9999995e9 
zMaxMag link to glossaryreal4 Maximum magnitude in Z band, of good detections-0.9999995e9 
zNgt3sig link to glossarysmallint2 Number of good detections in Z-band that are more than 3 sigma deviations (zAperMagN < (zMeanMag-3*zMagRms)-9999 
zExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in Z band-0.9999995e9 
zIntRms link to glossaryreal4magIntrinsic rms in Z-band-0.9999995e9 
zchiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
zndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
zprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
zVarClass link to glossarysmallint2 Classification of variability in this band-9999 
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 wserv1000MapRemeasurement.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 wserv1000MapRemeasurement.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 wserv1000MapRemeasurement.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 wserv1000MapRemeasurement.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 wserv1000MapRemeasurement.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 wserv1000MapRemeasurement.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 
knPosObs link to glossaryint4 Number of unflagged positive measurements in K band0 
knPosFlagObs link to glossaryint4 Number of flagged positive measurements in K band by wserv1000MapRemeasurement.ppErrBits0 
knNegObs link to glossaryint4 Number of unflagged negative measurements K band0 
knNegFlagObs link to glossaryint4 Number of flagged negative measurements in K band by wserv1000MapRemeasurement.ppErrBits0 
kbestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the K band-9999 
kminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
kmedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
kmaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
ktotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
kmeanMag link to glossaryreal4magMean K magnitude-0.9999995e9 
kmedianMag link to glossaryreal4magMedian K magnitude-0.9999995e9 
kMagRms link to glossaryreal4magrms of K magnitude-0.9999995e9 
kMagMAD link to glossaryreal4magMedian Absolute Deviation of K magnitude-0.9999995e9 
kskewness link to glossaryreal4 Skewness in K band (see Sesar et al. 2007)-0.9999995e9 
kMinMag link to glossaryreal4 Minimum magnitude in K band, of good detections-0.9999995e9 
kMaxMag link to glossaryreal4 Maximum magnitude in K band, of good detections-0.9999995e9 
kNgt3sig link to glossarysmallint2 Number of good detections in K-band that are more than 3 sigma deviations (kAperMagN < (kMeanMag-3*kMagRms)-9999 
kExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in K band-0.9999995e9 
kIntRms link to glossaryreal4magIntrinsic rms in K-band-0.9999995e9 
kchiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
kndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
kprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
kVarClass link to glossarysmallint2 Classification of variability in this band-9999 
h2nPosObs link to glossaryint4 Number of unflagged positive measurements in H2 band0 
h2nPosFlagObs link to glossaryint4 Number of flagged positive measurements in H2 band by wserv1000MapRemeasurement.ppErrBits0 
h2nNegObs link to glossaryint4 Number of unflagged negative measurements H2 band0 
h2nNegFlagObs link to glossaryint4 Number of flagged negative measurements in H2 band by wserv1000MapRemeasurement.ppErrBits0 
h2bestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the H2 band-9999 
h2minCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
h2medCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
h2maxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
h2totalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
h2meanMag link to glossaryreal4magMean H2 magnitude-0.9999995e9 
h2medianMag link to glossaryreal4magMedian H2 magnitude-0.9999995e9 
h2MagRms link to glossaryreal4magrms of H2 magnitude-0.9999995e9 
h2MagMAD link to glossaryreal4magMedian Absolute Deviation of H2 magnitude-0.9999995e9 
h2skewness link to glossaryreal4 Skewness in H2 band (see Sesar et al. 2007)-0.9999995e9 
h2MinMag link to glossaryreal4 Minimum magnitude in H2 band, of good detections-0.9999995e9 
h2MaxMag link to glossaryreal4 Maximum magnitude in H2 band, of good detections-0.9999995e9 
h2Ngt3sig link to glossarysmallint2 Number of good detections in H2-band that are more than 3 sigma deviations (h2AperMagN < (h2MeanMag-3*h2MagRms)-9999 
h2ExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in H2 band-0.9999995e9 
h2IntRms link to glossaryreal4magIntrinsic rms in H2-band-0.9999995e9 
h2chiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
h2ndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
h2probVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
h2VarClass link to glossarysmallint2 Classification of variability in this band-9999 
nbjnPosObs link to glossaryint4 Number of unflagged positive measurements in Nbj band0 
nbjnPosFlagObs link to glossaryint4 Number of flagged positive measurements in Nbj band by wserv1000MapRemeasurement.ppErrBits0 
nbjnNegObs link to glossaryint4 Number of unflagged negative measurements Nbj band0 
nbjnNegFlagObs link to glossaryint4 Number of flagged negative measurements in Nbj band by wserv1000MapRemeasurement.ppErrBits0 
nbjbestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the Nbj band-9999 
nbjminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
nbjmedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
nbjmaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
nbjtotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
nbjmeanMag link to glossaryreal4magMean Nbj magnitude-0.9999995e9 
nbjmedianMag link to glossaryreal4magMedian Nbj magnitude-0.9999995e9 
nbjMagRms link to glossaryreal4magrms of Nbj magnitude-0.9999995e9 
nbjMagMAD link to glossaryreal4magMedian Absolute Deviation of Nbj magnitude-0.9999995e9 
nbjskewness link to glossaryreal4 Skewness in Nbj band (see Sesar et al. 2007)-0.9999995e9 
nbjMinMag link to glossaryreal4 Minimum magnitude in Nbj band, of good detections-0.9999995e9 
nbjMaxMag link to glossaryreal4 Maximum magnitude in Nbj band, of good detections-0.9999995e9 
nbjNgt3sig link to glossarysmallint2 Number of good detections in Nbj-band that are more than 3 sigma deviations (nbjAperMagN < (nbjMeanMag-3*nbjMagRms)-9999 
nbjExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in Nbj band-0.9999995e9 
nbjIntRms link to glossaryreal4magIntrinsic rms in Nbj-band-0.9999995e9 
nbjchiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
nbjndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
nbjprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
nbjVarClass link to glossarysmallint2 Classification of variability in this band-9999 
nbhnPosObs link to glossaryint4 Number of unflagged positive measurements in Nbh band0 
nbhnPosFlagObs link to glossaryint4 Number of flagged positive measurements in Nbh band by wserv1000MapRemeasurement.ppErrBits0 
nbhnNegObs link to glossaryint4 Number of unflagged negative measurements Nbh band0 
nbhnNegFlagObs link to glossaryint4 Number of flagged negative measurements in Nbh band by wserv1000MapRemeasurement.ppErrBits0 
nbhbestAper link to glossaryint4 Best aperture (1-3) for photometric statistics in the Nbh band-9999 
nbhminCadence link to glossaryreal4daysminimum gap between observations-0.9999995e9 
nbhmedCadence link to glossaryreal4daysmedian gap between observations-0.9999995e9 
nbhmaxCadence link to glossaryreal4daysmaximum gap between observations-0.9999995e9 
nbhtotalPeriod link to glossaryreal4daystotal period of observations (last obs-first obs)-0.9999995e9 
nbhmeanMag link to glossaryreal4magMean Nbh magnitude-0.9999995e9 
nbhmedianMag link to glossaryreal4magMedian Nbh magnitude-0.9999995e9 
nbhMagRms link to glossaryreal4magrms of Nbh magnitude-0.9999995e9 
nbhMagMAD link to glossaryreal4magMedian Absolute Deviation of Nbh magnitude-0.9999995e9 
nbhskewness link to glossaryreal4 Skewness in Nbh band (see Sesar et al. 2007)-0.9999995e9 
nbhMinMag link to glossaryreal4 Minimum magnitude in Nbh band, of good detections-0.9999995e9 
nbhMaxMag link to glossaryreal4 Maximum magnitude in Nbh band, of good detections-0.9999995e9 
nbhNgt3sig link to glossarysmallint2 Number of good detections in Nbh-band that are more than 3 sigma deviations (nbhAperMagN < (nbhMeanMag-3*nbhMagRms)-9999 
nbhExpRms link to glossaryreal4magRms calculated from polynomial fit to modal RMS as a function of magnitude in Nbh band-0.9999995e9 
nbhIntRms link to glossaryreal4magIntrinsic rms in Nbh-band-0.9999995e9 
nbhchiSqpd link to glossaryreal4 Chi square (per degree of freedom) fit to data (mean and expected rms)-0.9999995e9 
nbhndof link to glossarysmallint2 Number of degrees of freedom for chisquare-9999 
nbhprobVar link to glossaryreal4 Probability of variable from chi-square (and other data)-0.9999995e9 
nbhVarClass link to glossarysmallint2 Classification of variability in this band-9999 
variableClass link to glossaryint4 Classification of objects across all bands.-99999999 
Total length712