COLUMN CONSTRAINTS/OUTPUT COLUMN SELECTION
|
|
Table Selection
|
Sexagesimal Output
|
| Name |
Description |
Sel |
Low Limit (include >,≥,=) |
Up Limit (include <,≤,=) |
Units |
Indx |
DBType |
|
gcntr |
unique group counter |
|
|
|
|
X |
integer |
|
napp |
# of apparitions found in group |
|
|
|
|
|
smallint |
|
gcnf |
group confusion flag |
|
|
|
|
|
smallint |
|
sdet |
# of apparitions detected from different scans |
|
|
|
|
|
smallint |
|
ra |
group average RA |
|
|
|
|
|
decimal(15,6) |
|
dec |
group average Dec |
|
|
|
|
X |
decimal(15,6) |
|
emj_mrg |
position error |
|
|
|
|
|
decimal(15,6) |
|
emn_mrg |
position error |
|
|
|
|
|
decimal(15,6) |
|
ean_mrg |
position angle error |
|
|
|
|
|
smallint |
|
sep_avg |
average radial separation (asec) from group position |
|
|
|
|
|
decimal(15,6) |
|
sep_sig |
population sigma of radial separation distribution (asec) |
|
|
|
|
|
decimal(11,9) |
|
use_cntr |
apparition selected based on maximum distance to edge. |
|
|
|
|
|
integer |
|
smin |
min number of overlapping scans within search radius |
|
|
|
|
|
smallint |
|
smax |
max number of overlapping scans within search radius |
|
|
|
|
|
smallint |
|
spos |
number of overlapping scans at group position. |
|
|
|
|
|
smallint |
|
j_m_7_avg |
average 7 arcsec radius circular aperture J magnitude |
|
|
|
|
|
decimal(7,4) |
|
h_m_7_avg |
average 7 arcsec radius circular aperture H magnitude |
|
|
|
|
|
decimal(7,4) |
|
k_m_7_avg |
average 7 arcsec radius circular aperture K magnitude |
|
|
|
|
|
decimal(7,4) |
|
j_mstdev_7 |
sigma mean of average magnitude_7 J band |
|
|
|
|
|
decimal(7,4) |
|
h_mstdev_7 |
sigma mean of average magnitude_7 H band |
|
|
|
|
|
decimal(7,4) |
|
k_mstdev_7 |
sigma mean of average magnitude_7 K band |
|
|
|
|
|
decimal(7,4) |
|
max_7_flg |
max confusion flag, all bands |
|
|
|
|
|
smallint |
|
j_m_k20fe_avg |
average J k20fe isophotal fiducial ell. ap. magnitude |
|
|
|
|
|
decimal(7,4) |
|
h_m_k20fe_avg |
average H k20fe isophotal fiducial ell. ap. magnitude |
|
|
|
|
|
decimal(7,4) |
|
k_m_k20fe_avg |
average K k20fe isophotal fiducial ell. ap. magnitude |
|
|
|
|
|
decimal(7,4) |
|
j_mstdev_k20fe |
sigma mean of average k20fe magnitude J band |
|
|
|
|
|
decimal(7,4) |
|
h_mstdev_k20fe |
sigma mean of average k20fe magnitude H band |
|
|
|
|
|
decimal(7,4) |
|
k_mstdev_k20fe |
sigma mean of average k20fe magnitude K band |
|
|
|
|
|
decimal(7,4) |
|
max_k20fe_flg |
max confusion flag, all bands |
|
|
|
|
|
smallint |
|
j_m_7_wavg |
weighted average 7 arcsec radius circular aperture,J band |
|
|
|
|
|
decimal(7,4) |
|
h_m_7_wavg |
weighted average 7 arcsec radius circular aperture,H band |
|
|
|
|
|
decimal(7,4) |
|
k_m_7_wavg |
weighted average 7 arcsec radius circular aperture,K band |
|
|
|
|
|
decimal(7,4) |
|
j_m_7_wunc |
uncertainty of weighted mean, 7 arcsec radius circular aperture J magnitude |
|
|
|
|
|
decimal(7,4) |
|
h_m_7_wunc |
uncertainty of weighted mean, 7 arcsec radius circular aperture H magnitude |
|
|
|
|
|
decimal(7,4) |
|
k_m_7_wunc |
uncertainty of weighted mean, 7 arcsec radius circular aperture K magnitude |
|
|
|
|
|
decimal(7,4) |
|
j_m_k20fe_wavg |
weighted average k20fe isophotal fiducial elliptical aperture,J band |
|
|
|
|
|
decimal(7,4) |
|
h_m_k20fe_wavg |
weighted average k20fe isophotal fiducial elliptical aperture,H band |
|
|
|
|
|
decimal(7,4) |
|
k_m_k20fe_wavg |
weighted average k20fe isophotal fiducial elliptical aperture,K band |
|
|
|
|
|
decimal(7,4) |
|
j_m_k20fe_wunc |
uncertainty of weighted mean, k20fe isophotal fiducial elliptical ap. J band |
|
|
|
|
|
decimal(7,4) |
|
h_m_k20fe_wunc |
uncertainty of weighted mean, k20fe isophotal fiducial elliptical ap. H band |
|
|
|
|
|
decimal(7,4) |
|
k_m_k20fe_wunc |
uncertainty of weighted mean, k20fe isophotal fiducial elliptical ap. K band |
|
|
|
|
|
decimal(7,4) |
|
j_n_7 |
# of apparitions contributing to avg 7 arcsec radial circular ap. mag,J band |
|
|
|
|
|
smallint |
|
h_n_7 |
# of apparitions contributing to avg 7 arcsec radial circular ap. mag, H band |
|
|
|
|
|
smallint |
|
k_n_7 |
# of apparitions contributing to avg 7 arcsec radial circular ap. mag, K band |
|
|
|
|
|
smallint |
|
j_n_k20fe |
# of apparitions contributing to avg k20fe isophotal fiducial ell. ap., J band |
|
|
|
|
|
smallint |
|
h_n_k20fe |
# of apparitions contributing to avg k20fe isophotal fiducial ell. ap., H band |
|
|
|
|
|
smallint |
|
k_n_k20fe |
# of apparitions contributing to avg k20fe isophotal fiducial ell. ap., K band |
|
|
|
|
|
smallint |
|
j_mchisq_7 |
chi square value for 7 arcsec radial circular aperture magnitudes, J band |
|
|
|
|
|
decimal(15,6) |
|
h_mchisq_7 |
chi square value for 7 arcsec radial circular aperture magnitudes, H band |
|
|
|
|
|
decimal(15,6) |
|
k_mchisq_7 |
chi square value for 7 arcsec radial circular aperture magnitudes, K band |
|
|
|
|
|
decimal(15,6) |
|
j_mndev_7 |
min deviation from weighted mean, 7 arcsec radial circular ap. magnitude J band |
|
|
|
|
|
decimal(15,6) |
|
h_mndev_7 |
min deviation from weighted mean, 7 arcsec radial circular ap. magnitude H band |
|
|
|
|
|
decimal(15,6) |
|
k_mndev_7 |
min deviation from weighted mean, 7 arcsec radial circular ap. magnitude K band |
|
|
|
|
|
decimal(15,6) |
|
j_mxdev_7 |
max deviation from weighted meani 7 arcsec radial circular ap. magnitude J band |
|
|
|
|
|
decimal(15,6) |
|
h_mxdev_7 |
max deviation from weighted meani 7 arcsec radial circular ap. magnitude H band |
|
|
|
|
|
decimal(15,6) |
|
k_mxdev_7 |
max deviation from weighted meani 7 arcsec radial circular ap. magnitude K band |
|
|
|
|
|
decimal(15,6) |
|
j_mchisq_k20fe |
chi square value for k20fe isophotal fiducial elliptical ap., J band |
|
|
|
|
|
decimal(15,6) |
|
h_mchisq_k20fe |
chi square value for k20fe isophotal fiducial elliptical ap., H band |
|
|
|
|
|
decimal(15,6) |
|
k_mchisq_k20fe |
chi square value for k20fe isophotal fiducial elliptical ap., K band |
|
|
|
|
|
decimal(15,6) |
|
j_mndev_k20fe |
min deviation from weighted mean, k20fe isophotal fiducial elliptical ap.,J band |
|
|
|
|
|
decimal(15,6) |
|
h_mndev_k20fe |
min deviation from weighted mean, k20fe isophotal fiducial elliptical ap.,H band |
|
|
|
|
|
decimal(15,6) |
|
k_mndev_k20fe |
min deviation from weighted mean, k20fe isophotal fiducial elliptical ap.,K band |
|
|
|
|
|
decimal(15,6) |
|
j_mxdev_k20fe |
max deviation from weighted mean, k20fe isophotal fiducial elliptical ap.,J band |
|
|
|
|
|
decimal(15,6) |
|
h_mxdev_k20fe |
max deviation from weighted mean, k20fe isophotal fiducial elliptical ap.,H band |
|
|
|
|
|
decimal(15,6) |
|
k_mxdev_k20fe |
max deviation from weighted mean, k20fe isophotal fiducial elliptical ap.,K band |
|
|
|
|
|
decimal(15,6) |
|
r_k20fe_avg |
average radius |
|
|
|
|
|
decimal(6,3) |
|
k_ba_avg |
average axis (minor to major) ratio |
|
|
|
|
|
decimal(6,3) |
|
k_phi_avg |
average position angle (east of north) |
|
|
|
|
|
decimal(6,3) |
|
k_n_shape |
# of apparitions with valid shape parameters contributing to the average |
|
|
|
|
|
smallint |
|
r_k20fe_rms |
distribution sigma mean for the major axis Ks-band isophotal fiducial radius |
|
|
|
|
|
decimal(6,3) |
|
k_ba_rms |
distribution sigma mean for the Ks-band minor/major axis ratio |
|
|
|
|
|
decimal(6,3) |
|
k_phi_rms |
dstribution sigma mean for the Ks-band angle to major axis |
|
|
|
|
|
decimal(6,3) |
|
sup_ba_avg |
avg axis (minor to major) ratio |
|
|
|
|
|
decimal(6,3) |
|
sup_phi_avg |
avg position angle (east of north) |
|
|
|
|
|
decimal(6,3) |
|
sup_n_shape |
# of apparitions contributing to the average |
|
|
|
|
|
smallint |
|
sup_ba_rms |
sigma mean for the combined J+H+Ks ("super coadd") minor/major axis ratio |
|
|
|
|
|
decimal(6,3) |
|
sup_phi_rms |
sigma mean for the combined J+H+Ks ("super coadd") angle to major axis |
|
|
|
|
|
decimal(6,3) |
|
n_dist |
# of apparitions too close to edge (<= 15") |
|
|
|
|
|
smallint |
|
rel_avg |
average rel scores for all apparitions in group, rounded to nearest character |
|
|
|
|
|
character(8) |