COLUMN CONSTRAINTS/OUTPUT COLUMN SELECTION
|
|
Table Selection
|
Sexagesimal Output
|
| Name |
Description |
Sel |
Low Limit (include >,≥,=) |
Up Limit (include <,≤,=) |
Units |
Indx |
DBType |
|
cntr |
entry counter (key) number (unique within table) |
|
|
|
|
X |
integer |
|
hemis |
hemisphere (N/S) of observation |
|
|
|
|
X |
char(1) |
|
xdate |
observation date |
|
|
|
|
|
date(yyyy-mm-dd) |
|
scan |
scan number (unique within date) |
|
|
|
|
|
smallint |
|
tile |
tile ID number |
|
|
|
|
|
integer |
|
ra |
right ascension (J2000 decimal deg) of scan center |
|
|
|
deg |
|
decimal(9,6) |
|
dec |
declination (J2000 decimal deg) of scan center |
|
|
|
deg |
X |
decimal(8,6) |
|
glon |
galactic longitude (decimal deg) of scan center |
|
|
|
deg |
|
decimal(9,6) |
|
glat |
galactic latitude (decimal deg) of scan center |
|
|
|
deg |
|
decimal(9,6) |
|
ra_1 |
right ascension (J2000 decimal deg) of scan corner 1 |
|
|
|
deg |
|
decimal(9,6) |
|
dec_1 |
declination (J2000 decimal deg) of scan corner 1 |
|
|
|
deg |
|
decimal(8,6) |
|
ra_2 |
right ascension (J2000 decimal deg) of scan corner 2 |
|
|
|
deg |
|
decimal(9,6) |
|
dec_2 |
declination (J2000 decimal deg) of scan corner 2 |
|
|
|
deg |
|
decimal(8,6) |
|
ra_3 |
right ascension (J2000 decimal deg) of scan corner 3 |
|
|
|
deg |
|
decimal(9,6) |
|
dec_3 |
declination (J2000 decimal deg) of scan corner 3 |
|
|
|
deg |
|
decimal(8,6) |
|
ra_4 |
right ascension (J2000 decimal deg) of scan corner 4 |
|
|
|
deg |
|
decimal(9,6) |
|
dec_4 |
declination (J2000 decimal deg) of scan corner 4 |
|
|
|
deg |
|
decimal(8,6) |
|
sd |
direction of scan -- north/south-bound (n/s) |
|
|
|
|
|
char(1) |
|
qual |
quality score for scan (0-10) |
|
|
|
|
|
smallint |
|
hgl |
single-frame H-band glitch flag (0:not found,1:found) |
|
|
|
|
|
smallint |
|
cld |
downgrade from DB photom. overlap comparison (clouds) (0,1) |
|
|
|
|
|
smallint |
|
xph |
downgrade from DB photom. overlap compar. (non-cloud) (0,1) |
|
|
|
|
|
smallint |
|
anom |
entry in coadd anomaly table (0:not found,1:found) |
|
|
|
|
|
smallint |
|
ut |
beginning UT of scan data |
|
|
|
time |
|
datetime(h-s) |
|
jdate |
Julian date beginning UT of scan data |
|
|
|
jdate |
|
decimal(9,4) |
|
airm |
beginning airmass of scan |
|
|
|
|
|
decimal(5,4) |
|
zd |
beginning zenith distance of scan data |
|
|
|
deg |
|
decimal(3,1) |
|
ha |
beginning hour angle of scan data |
|
|
|
hr |
|
decimal(7,6) |
|
rh |
relative humidity (%) at beginning of scan |
|
|
|
% |
|
smallint |
|
air_temp |
air temperature (deg C) at beginning of scan |
|
|
|
degC |
|
decimal(3,1) |
|
tel_temp |
telescope tube girdle temperature (deg C) at beg. of scan |
|
|
|
degC |
|
decimal(3,1) |
|
focus |
telescope focus setting |
|
|
|
|
|
smallint |
|
hry |
H-band detector array switched, north only (o=old, n=new) |
|
|
|
|
|
char(1) |
|
c_strat |
calibration strategy, north only (o=old, n=new) |
|
|
|
|
|
char(1) |
|
j_zp_ap |
J band ap. calibration photometric zero-point for scan |
|
|
|
mag |
|
decimal(5,4) |
|
h_zp_ap |
H band ap. calibration photometric zero-point for scan |
|
|
|
mag |
|
decimal(5,4) |
|
k_zp_ap |
K band ap. calibration photometric zero-point for scan |
|
|
|
mag |
|
decimal(5,4) |
|
h_zperr_ap |
H band ap. calibration rms error of zero-point for scan |
|
|
|
mag |
|
decimal(5,4) |
|
k_zperr_ap |
K band ap. calibration rms error of zero-point for scan |
|
|
|
mag |
|
decimal(5,4) |
|
j_n_snr10 |
number of J point sources with SNR>10 (instrumental m<=15.8) |
|
|
|
|
|
integer |
|
h_n_snr10 |
number of H point sources with SNR>10 (instrumental m<=15.1) |
|
|
|
|
|
integer |
|
k_n_snr10 |
number of K point sources with SNR>10 (instrumental m<=14.3) |
|
|
|
|
|
integer |
|
n_ext |
number of regular extended sources detected in scan |
|
|
|
|
|
integer |
|
j_shape_avg |
J band average seeing shape for scan |
|
|
|
|
|
decimal(6,3) |
|
h_shape_avg |
H band average seeing shape for scan |
|
|
|
|
|
decimal(6,3) |
|
k_shape_avg |
K band average seeing shape for scan |
|
|
|
|
|
decimal(6,3) |
|
j_shape_rms |
rms of J band avg seeing shape for scan |
|
|
|
|
|
decimal(6,3) |
|
h_shape_rms |
rms of H band avg seeing shape for scan |
|
|
|
|
|
decimal(6,3) |
|
k_shape_rms |
rms of K band avg seeing shape for scan |
|
|
|
|
|
decimal(6,3) |
|
j_2mrat |
J band average 2nd image moment ratio for scan |
|
|
|
|
|
decimal(6,3) |
|
h_2mrat |
H band average 2nd image moment ratio for scan |
|
|
|
|
|
decimal(6,3) |
|
k_2mrat |
K band average 2nd image moment ratio for scan |
|
|
|
|
|
decimal(6,3) |
|
j_psp |
J photometric sensitivity param: j_shape_avg*(j_fbg_avg^.29) |
|
|
|
|
|
decimal(6,3) |
|
h_psp |
H photometric sensitivity param: h_shape_avg*(h_fbg_avg^.29) |
|
|
|
|
|
decimal(6,3) |
|
k_psp |
K photometric sensitivity param: k_shape_avg*(k_fbg_avg^.29) |
|
|
|
|
|
decimal(6,3) |
|
j_pts_noise |
log10 of J band modal point src noise estimate |
|
|
|
logmJy |
|
decimal(6,4) |
|
h_pts_noise |
log10 of H band modal point src noise estimate |
|
|
|
logmJy |
|
decimal(6,4) |
|
k_pts_noise |
log10 of K band modal point src noise estimate |
|
|
|
logmJy |
|
decimal(6,4) |
|
j_msnr10 |
J mag at which SNR=10 is achieved, from j_psp and j_zp_ap |
|
|
|
mag |
|
decimal(5,3) |
|
h_msnr10 |
H mag at which SNR=10 is achieved, from h_psp and h_zp_ap |
|
|
|
mag |
|
decimal(5,3) |
|
k_msnr10 |
K mag at which SNR=10 is achieved, from k_psp and k_zp_ap |
|
|
|
mag |
|
decimal(5,3) |
|
cat |
Catalog indicator 1=catalog, 0=not catalog |
|
|
|
|
|
smallint |