| Column # | Column Name | Description | Units | Data Type | Nulls Allowed | Indexed | In Mini Set | In Short Set | In Standard Set |
|---|---|---|---|---|---|---|---|---|---|
| 1 | cntr | entry counter (key) number (unique within table) | --- | integer | n | 1 | n | y | y |
| 2 | hemis | hemisphere (N/S) of observation | --- | char(1) | n | 23 | n | n | y |
| 3 | date | observation date | --- | date | n | 121 | n | n | y |
| 4 | scan | scan number (unique within date) | --- | smallint | n | 22 | n | n | y |
| 5 | id | source ID number (unique within scan) | --- | integer | n | 0 | n | n | y |
| 6 | ra | right ascension (J2000 decimal deg) | deg | decimal(9,6) | n | 0 | y | y | y |
| 7 | dec | declination (J2000 decimal deg) | deg | decimal(8,6) | n | 1 | y | y | y |
| 8 | glon | galactic longitude (decimal deg) | deg | decimal(9,6) | n | 0 | n | n | y |
| 9 | glat | galactic latitude (decimal deg) | deg | decimal(9,6) | n | 1 | n | n | y |
| 10 | x | unit sphere x value | --- | decimal(17,16) | n | 0 | n | n | n |
| 11 | y | unit sphere y value | --- | decimal(17,16) | n | 0 | n | n | n |
| 12 | z | unit sphere z value | --- | decimal(17,16) | n | 0 | n | n | n |
| 13 | err_maj | major axis of 1-sigma error ellipse | arcsec | decimal(3,2) | n | 0 | n | y | y |
| 14 | err_min | minor axis of 1-sigma error ellipse | arcsec | decimal(3,2) | n | 0 | n | y | y |
| 15 | err_ang | angle of error ellipse major axis (E of N) | deg | smallint | n | 0 | n | y | y |
| 16 | x_scan | x (cross-scan) position (U-Scan coord.) | arcsec | decimal(5,2) | n | 0 | n | n | n |
| 17 | y_scan | y (in-scan) position (U-Scan coord.) | arcsec | decimal(7,2) | n | 0 | n | n | n |
| 18 | cnf_flg | "confusion" flags from band merging | --- | char(6) | n | 0 | n | n | y |
| Notes for cnf_flg: The bandmerge confusion flag consists of 6 single-digit numbers defined as follows: Digit #1: Number of H matches found by J seed (0 if no J seed) Digit #2: Number of K matches found by J seed (0 if no J seed) Digit #3: Number of J matches found by H seed (0 if no H seed) Digit #4: Number of K matches found by H seed (0 if no H seed) Digit #5: Number of J matches found by K seed (0 if no K seed) Digit #6: Number of H matches found by K seed (0 if no K seed) | |||||||||
| 19 | j_m | J selected "default" magnitude | mag | decimal(5,3) | y | 1 | y | y | y |
| Notes for j_m: This is the selected "default" magnitude for each band. For most srcs, the [jhk]_m values are the PSF fit mags for each band, or, if the PSF fit mag for a band is null, the standard aperture mag for that band. However, if a src is matched to a R1 src in a band, and the 1st digit of the [jhk]_mrg_flg for that band is > 0, the [jhk]_m value for that band is the R1 aperture mag ([jhk]_m_r1). On the other hand, if a src is band-filled in a band ([jhk]_prg_flg = 'fil'), the value of [jhk]_m for that band is the band-fill 95%-confidence upper limit mag (found in the large ap. mag column). | |||||||||
| 20 | h_m | H selected "default" magnitude | mag | decimal(5,3) | y | 1 | y | y | y |
| Notes for h_m: This is the selected "default" magnitude for each band. For most srcs, the [jhk]_m values are the PSF fit mags for each band, or, if the PSF fit mag for a band is null, the standard aperture mag for that band. However, if a src is matched to a R1 src in a band, and the 1st digit of the [jhk]_mrg_flg for that band is > 0, the [jhk]_m value for that band is the R1 aperture mag ([jhk]_m_r1). On the other hand, if a src is band-filled in a band ([jhk]_prg_flg = 'fil'), the value of [jhk]_m for that band is the band-fill 95%-confidence upper limit mag (found in the large ap. mag column). | |||||||||
| 21 | k_m | K selected "default" magnitude | mag | decimal(5,3) | y | 1 | y | y | y |
| Notes for k_m: This is the selected "default" magnitude for each band. For most srcs, the [jhk]_m values are the PSF fit mags for each band, or, if the PSF fit mag for a band is null, the standard aperture mag for that band. However, if a src is matched to a R1 src in a band, and the 1st digit of the [jhk]_mrg_flg for that band is > 0, the [jhk]_m value for that band is the R1 aperture mag ([jhk]_m_r1). On the other hand, if a src is band-filled in a band ([jhk]_prg_flg = 'fil'), the value of [jhk]_m for that band is the band-fill 95%-confidence upper limit mag (found in the large ap. mag column). | |||||||||
| 22 | j_msig | J "default" mag uncertainty | mag | decimal(4,3) | y | 0 | y | y | y |
| Notes for j_msig: The mag sigma values corresponding to the selected "default" magnitude for each band are put in the [jhk]_msig fields. | |||||||||
| 23 | h_msig | H "default" mag uncertainty | mag | decimal(4,3) | y | 0 | y | y | y |
| Notes for h_msig: The mag sigma values corresponding to the selected "default" magnitude for each band are put in the [jhk]_msig fields. | |||||||||
| 24 | k_msig | K "default" mag uncertainty | mag | decimal(4,3) | y | 0 | y | y | y |
| Notes for k_msig: The mag sigma values corresponding to the selected "default" magnitude for each band are put in the [jhk]_msig fields. | |||||||||
| 25 | j_m_psf | J PSF-fit magnitude (BF aperture-photometry mag) | mag | decimal(5,3) | y | 0 | n | n | n |
| Notes for j_m_psf: If a src is band-filled in a band ([jhk]_prg_flg = 'fil'), this field in that band contains the band-filled aperture-photometry mag. It is calculated by finding a mag value for the measured flux within the band-fill aperture: BFMag = ZERO_CAL - 2.5 log10(flux) where ZERO_CAL is the zero calibration magnitude. Note that this field may have to represent a negative flux; in such a case, the value is BFMag = 99.0 - [ZERO_CAL - 2.5 log10(|flux|)] This encoding requires fluxes close to zero to be clipped. The clipping distance is set to 0.01 DN above zero for positive fluxes and below zero for negative fluxes. For example, the positive flux 0.0005 DN would be clipped at 0.01 DN and encoded as BFMag = ZERO_CAL - 2.5 log10(0.01) = 24.93 (for ZERO_CAL = 19.93) For a negative flux of -0.0005 DN, the clipping would yield -0.01 DN, and the encoding would be BFMag = 99.0 - [ZERO_CAL - 2.5 log10(0.01)] = 74.07 (for ZERO_CAL = 19.93) BFMags near 50 cannot occur, so 50 marks the boundary between positive and negative flux encoding. | |||||||||
| 26 | h_m_psf | H PSF-fit magnitude (BF aperture-photometry mag) | mag | decimal(5,3) | y | 0 | n | n | n |
| Notes for h_m_psf: If a src is band-filled in a band ([jhk]_prg_flg = 'fil'), this field in that band contains the band-filled aperture-photometry mag. It is calculated by finding a mag value for the measured flux within the band-fill aperture: BFMag = ZERO_CAL - 2.5 log10(flux) where ZERO_CAL is the zero calibration magnitude. Note that this field may have to represent a negative flux; in such a case, the value is BFMag = 99.0 - [ZERO_CAL - 2.5 log10(|flux|)] This encoding requires fluxes close to zero to be clipped. The clipping distance is set to 0.01 DN above zero for positive fluxes and below zero for negative fluxes. For example, the positive flux 0.0005 DN would be clipped at 0.01 DN and encoded as BFMag = ZERO_CAL - 2.5 log10(0.01) = 24.93 (for ZERO_CAL = 19.93) For a negative flux of -0.0005 DN, the clipping would yield -0.01 DN, and the encoding would be BFMag = 99.0 - [ZERO_CAL - 2.5 log10(0.01)] = 74.07 (for ZERO_CAL = 19.93) BFMags near 50 cannot occur, so 50 marks the boundary between positive and negative flux encoding. | |||||||||
| 27 | k_m_psf | K PSF-fit magnitude (BF aperture-photometry mag) | mag | decimal(5,3) | y | 0 | n | n | n |
| Notes for k_m_psf: If a src is band-filled in a band ([jhk]_prg_flg = 'fil'), this field in that band contains the band-filled aperture-photometry mag. It is calculated by finding a mag value for the measured flux within the band-fill aperture: BFMag = ZERO_CAL - 2.5 log10(flux) where ZERO_CAL is the zero calibration magnitude. Note that this field may have to represent a negative flux; in such a case, the value is BFMag = 99.0 - [ZERO_CAL - 2.5 log10(|flux|)] This encoding requires fluxes close to zero to be clipped. The clipping distance is set to 0.01 DN above zero for positive fluxes and below zero for negative fluxes. For example, the positive flux 0.0005 DN would be clipped at 0.01 DN and encoded as BFMag = ZERO_CAL - 2.5 log10(0.01) = 24.93 (for ZERO_CAL = 19.93) For a negative flux of -0.0005 DN, the clipping would yield -0.01 DN, and the encoding would be BFMag = 99.0 - [ZERO_CAL - 2.5 log10(0.01)] = 74.07 (for ZERO_CAL = 19.93) BFMags near 50 cannot occur, so 50 marks the boundary between positive and negative flux encoding. | |||||||||
| 28 | j_msig_psf | J PSF-fit mag error (BF mag 1-sigma uncertainty) | mag | decimal(4,3) | y | 0 | n | n | n |
| 29 | h_msig_psf | H PSF-fit mag error (BF mag 1-sigma uncertainty) | mag | decimal(4,3) | y | 0 | n | n | n |
| 30 | k_msig_psf | K PSF-fit mag error (BF mag 1-sigma uncertainty) | mag | decimal(4,3) | y | 0 | n | n | n |
| 31 | j_psfchi | J band reduced chi-squared value of fit | --- | decimal(5,2) | y | 0 | n | n | y |
| 32 | h_psfchi | H band reduced chi-squared value of fit | --- | decimal(5,2) | y | 0 | n | n | y |
| 33 | k_psfchi | K band reduced chi-squared value of fit | --- | decimal(5,2) | y | 0 | n | n | y |
| 34 | j_psf_id | J band ID number of PSF used for fitting | --- | smallint | y | 0 | n | n | n |
| 35 | h_psf_id | H band ID number of PSF used for fitting | --- | smallint | y | 0 | n | n | n |
| 36 | k_psf_id | K band ID number of PSF used for fitting | --- | smallint | y | 0 | n | n | n |
| 37 | j_skyval | J estimated sky (bkgnd) level (BF noise within ap.) | DN | decimal(7,2) | y | 0 | n | n | n |
| 38 | h_skyval | H estimated sky (bkgnd) level (BF noise within ap.) | DN | decimal(7,2) | y | 0 | n | n | n |
| 39 | k_skyval | K estimated sky (bkgnd) level (BF noise within ap.) | DN | decimal(7,2) | y | 0 | n | n | n |
| 40 | j_blend | J band number of objects grouped with source | --- | smallint | y | 0 | n | y | y |
| 41 | h_blend | H band number of objects grouped with source | --- | smallint | y | 0 | n | y | y |
| 42 | k_blend | K band number of objects grouped with source | --- | smallint | y | 0 | n | y | y |
| 43 | j_peakpix | J band peak pixel level above background | DN | decimal(7,2) | y | 0 | n | n | n |
| 44 | h_peakpix | H band peak pixel level above background | DN | decimal(7,2) | y | 0 | n | n | n |
| 45 | k_peakpix | K band peak pixel level above background | DN | decimal(7,2) | y | 0 | n | n | n |
| 46 | j_m_stdap | J standard aperture magnitude | mag | decimal(5,3) | y | 0 | n | n | y |
| 47 | h_m_stdap | H standard aperture magnitude | mag | decimal(5,3) | y | 0 | n | n | y |
| 48 | k_m_stdap | K standard aperture magnitude | mag | decimal(5,3) | y | 0 | n | n | y |
| 49 | j_msig_stdap | J standard ap. mag uncertainty | mag | decimal(4,3) | y | 0 | n | n | y |
| 50 | h_msig_stdap | H standard ap. mag uncertainty | mag | decimal(4,3) | y | 0 | n | n | y |
| 51 | k_msig_stdap | K standard ap. mag uncertainty | mag | decimal(4,3) | y | 0 | n | n | y |
| 52 | j_m_lgap | J large ap. magnitude (BF 95%-confidence upper limit) | mag | decimal(5,3) | y | 0 | n | n | n |
| Notes for j_m_lgap: If a src is band-filled in a band ([jhk]_prg_flg = 'fil'), the value of this field is the 95%-confidence upper limit. This value is computed as follows: Lim95 = integrated flux + (2 * noise) where the noise in this case means the "local noise", computed as follows (using the DAOPHOT algorithm): noise = sqrt(error1 + error2 + error3) where error1 = variance in the local sky = npix * skyvar npix = number of pixels in the aperture skyvar = the variance of the sky brightness error2 = photon noise = int. flux * Gain error3 = (skyvar/nsky) * (npix ** 2) nsky = number pixels in sky annulus (skyvar/nsky) = square of the standard error of the mean sky brightness For the case in which the integrated flux is negative, the upper limit is Lim95 = 2 * noise where noise = sqrt(error1 + error3) | |||||||||
| 53 | h_m_lgap | H large ap. magnitude (BF 95%-confidence upper limit) | mag | decimal(5,3) | y | 0 | n | n | n |
| Notes for h_m_lgap: If a src is band-filled in a band ([jhk]_prg_flg = 'fil'), the value of this field is the 95%-confidence upper limit. This value is computed as follows: Lim95 = integrated flux + (2 * noise) where the noise in this case means the "local noise", computed as follows (using the DAOPHOT algorithm): noise = sqrt(error1 + error2 + error3) where error1 = variance in the local sky = npix * skyvar npix = number of pixels in the aperture skyvar = the variance of the sky brightness error2 = photon noise = int. flux * Gain error3 = (skyvar/nsky) * (npix ** 2) nsky = number pixels in sky annulus (skyvar/nsky) = square of the standard error of the mean sky brightness For the case in which the integrated flux is negative, the upper limit is Lim95 = 2 * noise where noise = sqrt(error1 + error3) | |||||||||
| 54 | k_m_lgap | K large ap. magnitude (BF 95%-confidence upper limit) | mag | decimal(5,3) | y | 0 | n | n | n |
| Notes for k_m_lgap: If a src is band-filled in a band ([jhk]_prg_flg = 'fil'), the value of this field is the 95%-confidence upper limit. This value is computed as follows: Lim95 = integrated flux + (2 * noise) where the noise in this case means the "local noise", computed as follows (using the DAOPHOT algorithm): noise = sqrt(error1 + error2 + error3) where error1 = variance in the local sky = npix * skyvar npix = number of pixels in the aperture skyvar = the variance of the sky brightness error2 = photon noise = int. flux * Gain error3 = (skyvar/nsky) * (npix ** 2) nsky = number pixels in sky annulus (skyvar/nsky) = square of the standard error of the mean sky brightness For the case in which the integrated flux is negative, the upper limit is Lim95 = 2 * noise where noise = sqrt(error1 + error3) | |||||||||
| 55 | j_msig_lgap | J large ap. mag uncertainty | mag | decimal(4,3) | y | 0 | n | n | n |
| 56 | h_msig_lgap | H large ap. mag uncertainty | mag | decimal(4,3) | y | 0 | n | n | n |
| 57 | k_msig_lgap | K large ap. mag uncertainty | mag | decimal(4,3) | y | 0 | n | n | n |
| 58 | j_m_r1 | J R1 aperture magnitude | mag | decimal(5,3) | y | 0 | n | n | y |
| 59 | h_m_r1 | H R1 aperture magnitude | mag | decimal(5,3) | y | 0 | n | n | y |
| 60 | k_m_r1 | K R1 aperture magnitude | mag | decimal(5,3) | y | 0 | n | n | y |
| 61 | j_msig_r1 | J R1 mag uncertainty | mag | decimal(4,3) | y | 0 | n | n | y |
| 62 | h_msig_r1 | H R1 mag uncertainty | mag | decimal(4,3) | y | 0 | n | n | y |
| 63 | k_msig_r1 | K R1 mag uncertainty | mag | decimal(4,3) | y | 0 | n | n | y |
| 64 | j_prob_pers | J band persistence probability | --- | decimal(4,3) | n | 0 | n | y | y |
| 65 | h_prob_pers | H band persistence probability | --- | decimal(4,3) | n | 0 | n | y | y |
| 66 | k_prob_pers | K band persistence probability | --- | decimal(4,3) | n | 0 | n | y | y |
| 67 | j_prnt_id | J band persistence parent ID number | --- | integer | y | 0 | n | n | n |
| 68 | h_prnt_id | H band persistence parent ID number | --- | integer | y | 0 | n | n | n |
| 69 | k_prnt_id | K band persistence parent ID number | --- | integer | y | 0 | n | n | n |
| 70 | j_prg_flg | J band "purge" flags (BF flag ='fil') | --- | char(3) | n | 0 | n | y | y |
| Notes for j_prg_flg: The "purge" flag consists of either the string 'fil', which indicates the src was band-filled in this band, or 3 single-digit numbers defined as follows: Digit #1: glint flag: 1 if src is (or is confused with) a filter glint Digit #2: diffraction spike flag: 1 if src is contaminated by a horizontal "stripe" (due to a bright star) at delta y = 0, 128, -128 camera pix 5 if src is bright enough to be accepted as a real src but is contaminated by a diffraction spike 6 if src is likely part of a diffraction spike Digit #3: confusion flag: 1 if ONE R2 (unmerged) or R1 src is found within the confusion radius of the brighter src 2 if more than 1 R2 src is found within the confusion radius | |||||||||
| 71 | h_prg_flg | H band "purge" flags (BF flag ='fil') | --- | char(3) | n | 0 | n | y | y |
| Notes for h_prg_flg: The "purge" flag consists of either the string 'fil', which indicates the src was band-filled in this band, or 3 single-digit numbers defined as follows: Digit #1: glint flag: 1 if src is (or is confused with) a filter glint Digit #2: diffraction spike flag: 1 if src is contaminated by a horizontal "stripe" (due to a bright star) at delta y = 0, 128, -128 camera pix 5 if src is bright enough to be accepted as a real src but is contaminated by a diffraction spike 6 if src is likely part of a diffraction spike Digit #3: confusion flag: 1 if ONE R2 (unmerged) or R1 src is found within the confusion radius of the brighter src 2 if more than 1 R2 src is found within the confusion radius | |||||||||
| 72 | k_prg_flg | K band "purge" flags (BF flag ='fil') | --- | char(3) | n | 0 | n | y | y |
| Notes for k_prg_flg: The "purge" flag consists of either the string 'fil', which indicates the src was band-filled in this band, or 3 single-digit numbers defined as follows: Digit #1: glint flag: 1 if src is (or is confused with) a filter glint Digit #2: diffraction spike flag: 1 if src is contaminated by a horizontal "stripe" (due to a bright star) at delta y = 0, 128, -128 camera pix 5 if src is bright enough to be accepted as a real src but is contaminated by a diffraction spike 6 if src is likely part of a diffraction spike Digit #3: confusion flag: 1 if ONE R2 (unmerged) or R1 src is found within the confusion radius of the brighter src 2 if more than 1 R2 src is found within the confusion radius | |||||||||
| 73 | j_mrg_flg | J band "merge" flags (BF status flags) | --- | char(6) | n | 0 | n | y | y |
| Notes for j_mrg_flg: The R1 merge flag, in the not-band-filled case, consists of four 1- and 2-digit numbers defined as follows: Digit #1: mag/postion to-use flag: 0 if mag & position to use is from R2 data 1 if mag to use is from R1 data, pos from R2-R1 2 if mag & position to use is from R1 data Digit #2: R1 flag: 0 if src is not an R1-only src 1 if src is an R1-only src 2 if src is a saturated R1 src and a new mag could not be calculated from its 1st persistence src Digits #3-4: # of possible R2-R1 matches to this R1 src Digits #5-6: # of possible R1 matches to this R2-R1 src The band-fill status flags are not yet defined. | |||||||||
| 74 | h_mrg_flg | H band "merge" flags (BF status flags) | --- | char(6) | n | 0 | n | y | y |
| Notes for h_mrg_flg: The R1 merge flag, in the not-band-filled case, consists of four 1- and 2-digit numbers defined as follows: Digit #1: mag/postion to-use flag: 0 if mag & position to use is from R2 data 1 if mag to use is from R1 data, pos from R2-R1 2 if mag & position to use is from R1 data Digit #2: R1 flag: 0 if src is not an R1-only src 1 if src is an R1-only src 2 if src is a saturated R1 src and a new mag could not be calculated from its 1st persistence src Digits #3-4: # of possible R2-R1 matches to this R1 src Digits #5-6: # of possible R1 matches to this R2-R1 src The band-fill status flags are not yet defined. | |||||||||
| 75 | k_mrg_flg | K band "merge" flags (BF status flags) | --- | char(6) | n | 0 | n | y | y |
| Notes for k_mrg_flg: The R1 merge flag, in the not-band-filled case, consists of four 1- and 2-digit numbers defined as follows: Digit #1: mag/postion to-use flag: 0 if mag & position to use is from R2 data 1 if mag to use is from R1 data, pos from R2-R1 2 if mag & position to use is from R1 data Digit #2: R1 flag: 0 if src is not an R1-only src 1 if src is an R1-only src 2 if src is a saturated R1 src and a new mag could not be calculated from its 1st persistence src Digits #3-4: # of possible R2-R1 matches to this R1 src Digits #5-6: # of possible R1 matches to this R2-R1 src The band-fill status flags are not yet defined. | |||||||||
| 76 | j_pix_flg | J "pixel" src extraction flags (BF # bad pixels in ap.) | --- | char(4) | n | 0 | n | n | y |
| Notes for j_pix_flg: The "pixel" source extraction flag consists of either the number of bad pixels in the band-fill aperture, if the src was band-filled in this band, or 4 single-digit numbers defined as follows: Digit #1: Nsat: # of frames with saturated pixels within the std. aperture Digit #2: Nbad: # of frames with bad pixels within the std. aperture Digit #3: Napmag: # of frames with 3-sigma ap. mag detections Digit #4: Nposs: # of std. ap. mag measurements possible | |||||||||
| 77 | h_pix_flg | H "pixel" src extraction flags (BF # bad pixels in ap.) | --- | char(4) | n | 0 | n | n | y |
| Notes for h_pix_flg: The "pixel" source extraction flag consists of either the number of bad pixels in the band-fill aperture, if the src was band-filled in this band, or 4 single-digit numbers defined as follows: Digit #1: Nsat: # of frames with saturated pixels within the std. aperture Digit #2: Nbad: # of frames with bad pixels within the std. aperture Digit #3: Napmag: # of frames with 3-sigma ap. mag detections Digit #4: Nposs: # of std. ap. mag measurements possible | |||||||||
| 78 | k_pix_flg | K "pixel" src extraction flags (BF # bad pixels in ap.) | --- | char(4) | n | 0 | n | n | y |
| Notes for k_pix_flg: The "pixel" source extraction flag consists of either the number of bad pixels in the band-fill aperture, if the src was band-filled in this band, or 4 single-digit numbers defined as follows: Digit #1: Nsat: # of frames with saturated pixels within the std. aperture Digit #2: Nbad: # of frames with bad pixels within the std. aperture Digit #3: Napmag: # of frames with 3-sigma ap. mag detections Digit #4: Nposs: # of std. ap. mag measurements possible | |||||||||
| 79 | j_cal | J mag calibration value for source | mag | decimal(4,3) | n | 0 | n | n | n |
| 80 | h_cal | H mag calibration value for source | mag | decimal(4,3) | n | 0 | n | n | n |
| 81 | k_cal | K mag calibration value for source | mag | decimal(4,3) | n | 0 | n | n | n |
| 82 | gal_contam | src contaminated by galaxy (check blanked/subtracted tbl) | --- | smallint | n | 0 | n | n | y |
| 83 | dist_edge_ns | distance to nearest north or south full-coverage scan edge | arcsec | decimal(6,1) | n | 0 | n | y | y |
| 84 | dist_edge_ew | distance to nearest east or west full-coverage scan edge | arcsec | decimal(4,1) | n | 0 | n | y | y |
| 85 | dist_edge_flg | flag indicating which edges ([n|s][e|w]) are nearest to src | --- | char(2) | n | 0 | n | y | y |
| 86 | id_opt | associated optical source catalog ID ("best" match) | --- | char(13) | y | 0 | n | y | y |
| Notes for id_opt: The catalog ID and other association parameters are given for the "best" optical match found. The ID consists of a single-letter abbreviation for the catalog (e.g., 'T' for Tycho, 'U' for USNO-A) followed immediately by the ID of the object within that catalog, with no embedded blanks. | |||||||||
| 87 | dist_opt | distance in arcsec relative to associated optical source | arcsec | decimal(4,2) | y | 0 | y | y | y |
| 88 | phi_opt | position angle relative to optical source (E of N) | deg | smallint | y | 0 | n | y | y |
| 89 | b_m_opt | catalog blue mag of associated optical source | mag | decimal(4,2) | y | 0 | y | y | y |
| 90 | r_m_opt | catalog red mag of associated optical source | mag | decimal(4,2) | y | 0 | y | y | y |
| 91 | nopt_mchs | number of optical sources matched to this 2MASS source | --- | smallint | n | 0 | n | y | y |
| 92 | n2mass_mchs | number of 2MASS sources matched to this optical source | --- | smallint | n | 0 | n | y | y |
| 93 | j_h | default J-H mag color | mag | decimal(5,3) | y | 1 | n | n | y |
| Notes for j_h: For bands with source detections and non-negative fluxes, the [jhk]_m default mag values are used to calculate the mag colors J-H,...R-K,...etc. If one of the bands used in the calculation is band-filled, the color value becomes an upper or lower limit and is calculated using the band-fill 95%-confidence upper limit value. (Color limits are NOT calculated when both bands are band-filled.) | |||||||||
| 94 | j_h_sig | sigma for J-H mag color | mag | decimal(4,3) | y | 0 | n | n | y |
| Notes for j_h_sig: For colors having detections in both bands, the color mag sigma values are the root-sum-square of the two mag sigmas. If one of the bands used in the calculation is band-filled, the color sigma is the other band's mag sigma. | |||||||||
| 95 | h_k | default H-K mag color | mag | decimal(5,3) | y | 1 | n | n | y |
| Notes for h_k: For bands with source detections and non-negative fluxes, the [jhk]_m default mag values are used to calculate the mag colors J-H,...R-K,...etc. If one of the bands used in the calculation is band-filled, the color value becomes an upper or lower limit and is calculated using the band-fill 95%-confidence upper limit value. (Color limits are NOT calculated when both bands are band-filled.) | |||||||||
| 96 | h_k_sig | sigma for H-K mag color | mag | decimal(4,3) | y | 0 | n | n | y |
| Notes for h_k_sig: For colors having detections in both bands, the color mag sigma values are the root-sum-square of the two mag sigmas. If one of the bands used in the calculation is band-filled, the color sigma is the other band's mag sigma. | |||||||||
| 97 | j_k | default J-K mag color | mag | decimal(5,3) | y | 1 | n | n | y |
| Notes for j_k: For bands with source detections and non-negative fluxes, the [jhk]_m default mag values are used to calculate the mag colors J-H,...R-K,...etc. If one of the bands used in the calculation is band-filled, the color value becomes an upper or lower limit and is calculated using the band-fill 95%-confidence upper limit value. (Color limits are NOT calculated when both bands are band-filled.) | |||||||||
| 98 | j_k_sig | sigma for J-K mag color | mag | decimal(4,3) | y | 0 | n | n | y |
| Notes for j_k_sig: For colors having detections in both bands, the color mag sigma values are the root-sum-square of the two mag sigmas. If one of the bands used in the calculation is band-filled, the color sigma is the other band's mag sigma. | |||||||||
| 99 | b_r | B-R mag color of associated optical source | mag | decimal(5,3) | y | 0 | n | n | y |
| 100 | r_k | default R-K mag color | mag | decimal(5,3) | y | 0 | n | n | y |
| Notes for r_k: For bands with source detections and non-negative fluxes, the [jhk]_m default mag values are used to calculate the mag colors J-H,...R-K,...etc. If one of the bands used in the calculation is band-filled, the color value becomes an upper or lower limit and is calculated using the band-fill 95%-confidence upper limit value. (Color limits are NOT calculated when both bands are band-filled.) | |||||||||
| 101 | b_k | default B-K mag color | mag | decimal(5,3) | y | 0 | n | n | y |
| Notes for b_k: For bands with source detections and non-negative fluxes, the [jhk]_m default mag values are used to calculate the mag colors J-H,...R-K,...etc. If one of the bands used in the calculation is band-filled, the color value becomes an upper or lower limit and is calculated using the band-fill 95%-confidence upper limit value. (Color limits are NOT calculated when both bands are band-filled.) | |||||||||
| 102 | r_j | default R-J mag color | mag | decimal(5,3) | y | 0 | n | n | y |
| Notes for r_j: For bands with source detections and non-negative fluxes, the [jhk]_m default mag values are used to calculate the mag colors J-H,...R-K,...etc. If one of the bands used in the calculation is band-filled, the color value becomes an upper or lower limit and is calculated using the band-fill 95%-confidence upper limit value. (Color limits are NOT calculated when both bands are band-filled.) | |||||||||
| 103 | b_j | default B-J mag color | mag | decimal(5,3) | y | 0 | n | n | y |
| Notes for b_j: For bands with source detections and non-negative fluxes, the [jhk]_m default mag values are used to calculate the mag colors J-H,...R-K,...etc. If one of the bands used in the calculation is band-filled, the color value becomes an upper or lower limit and is calculated using the band-fill 95%-confidence upper limit value. (Color limits are NOT calculated when both bands are band-filled.) | |||||||||
| 104 | dup_src | has duplicate source extractions (overlap areas) | --- | smallint | y | 0 | n | n | y |
| 105 | use_src | this extraction of duplicate source is to be used | --- | smallint | y | 0 | n | n | y |
| 106 | ext_key_1 | key to 1st extended source data DB record | --- | integer | y | 1 | n | n | y |
| Notes for ext_key_1: If there is extended src data for this src, the ext_key_1 field is set to the key of the record in the extended source table containing the ext. src data. The ext. src data will also have the same date, hemisphere, scan, id keys. | |||||||||
| 107 | ext_key_2 | key to 2nd extended source data DB record (if necessary) | --- | integer | y | 1 | n | n | y |
| Notes for ext_key_2: If there is a duplicate ext. src extraction for this src in a different coadd, the ext_key_2 field is set to the key of the record of the 2nd extraction. The ext. src data will also have the same date, hemisphere, scan, id keys. | |||||||||
| 108 | mp_key | key to minor planet prediction DB record | --- | integer | y | 0 | n | n | n |
| Notes for mp_key: If a minor planet (asteroid) is predicted at this src's position, the field is set to the key of the record containing the minor planet prediction data (see the minor planet tbls). The minor planet data will also have the same date, hemisphere, scan, id keys. | |||||||||
| 109 | exbr_key | key to extended bright source DB record | --- | integer | y | 0 | n | n | n |
| Notes for exbr_key: Not yet in use. | |||||||||
| 110 | night_key | key to night data record in the night data table | --- | integer | n | 1 | n | n | n |
| Notes for night_key: This field is set to the key of the record containing the corresponding night data in the night data table. The records will also have the same date and hemisphere keys. | |||||||||
| 111 | scan_key | key to scan data record in the scan data table | --- | integer | n | 1 | n | n | n |
| Notes for scan_key: This field is set to the key of the record containing the corresponding scan data in the scan data table. The records will also have the same date, hemisphere, and scan keys. | |||||||||
| 112 | spt_ind | spatial (x,y,z) index key | --- | integer | n | 1 | n | n | n |
| 113 | clr_ind | color index key | --- | integer | y | 0 | n | n | n |
