2MAPPS Software Interface Specification DBM02 4.5 99/04/06 Interface Name: DBMAN/DB Extended Source Data Interface Type of Interface: Database (Informix) Field Data Specification Written By: ECATOUT_SPRING99 ____________________ R. Cutri Read By: Informix DB Description: ECATOUT_SPRING99 reformats the data contained in the 2MASS Extended Source Database Fields into the format for the release catalogs. This SIS describes the DB fields (AKA "table columns") for the resulting extended source data. Descriptions of the point source, scan/quality, auxiliary, and calibration DB data are found in the other DBMxx SISs. The DB table containing this data from survey scans is named "ext_src", and the table containing this data from calibration scans is named "ext_src_c". Both are in the "tmass" DB. If a field is not applicable or contains a "bad or N/A measurement value" (see previous 2MAPPS SISs for details) for a certain source, the field will contain "NULL" values as defined by the DB. However, some fields are defined slightly differently for LCSB data, as indicated by "LCSB:" in the descriptions below, and some behave differently for band-filled data, as indicated by "BF" in the descriptions below. The descriptions below contain the following information: 1. "Name" contains the names of the DB fields or table columns. Note that they are all in lower case, because the DB doesn't distinguish between upper and lower case names. If there is a number in parentheses after the name, please refer to the numbered notes at the end of the descriptions for more information. Many fields are repeated 3 times, once for each band, but are found only once in the description below; these fields contain "" in the name, where "b" is understood to mean "j", "h", and "k". NOTE: The "cntr" column MUST be the first column in each table. 2. "Description" contains short descriptions of the field contents. 3. "Units" contains the units of the values in the fields. 4. "DBType" contains the DB data storage types for the fields. Note that some data types are further defined by values in parentheses following the type name. Also, these types are NOT cast in stone and could change, especially for the position fields. 5. "Null" indicates (y/n) whether the DB fields accept NULL values. 6. "Idx" contains a code indicating whether fields are indexed and what type of indexes they have. If the code is "0", the field is not indexed. If it is "1", the field has a simple index. If there is a "u" after the digit(s), the index is a "unique" one. If the code has a 2-digit number, the first digit indicates to which composite index the field belongs, and the second digit indicates the ordering of the fields within the composite index. If the code has a 3-digit number, the field will have both a simple and composite index. 7. "Fmt" contains a C-like description of the best formats for displaying the field contents, *excluding* a leading space for field separation. 8. "Tbl" contains the (sub-)table ID to which the fields belong. NOTE: The "cntr" field will be the first field in each sub-table, and is used as a join index. The 1st sub-table ("01") is the "main" sub-table, and must contain one entry per table cntr number; any other sub-table will not contain an entry for a cntr number if its fields would all be NULL. 9. "Min", "Sho", and "Std" indicate (y/n) whether the DB fields are found in the "mini", "short", and "standard" table output views. NOTE: A line beginning with "-------" can only be used herein to delineate the section of field/data dictionary lines seen below. Name Description Units DBType Null Idx Fmt Tbl Min Sho Std ---------------------------------------------------------------------------------------------------------------------------------------------- cntr entry counter (key) number (unique within table) - integer n 1 9d 01 n y y hemis hemisphere (N/S) of observation - char(1) n 24 1s 01 n n y date observation date - date n 121 yymmdd 01 n n y scan scan number (unique within date) - smallint n 122 3hd 01 n n y coadd 3-digit coadd number (unique within scan) - smallint n 23 03hd 01 n n y id source ID number (unique within scan, coadd) - integer n 0 6d 01 n n y ra right ascension (J2000 decimal deg) based on peak pixel deg decimal(9,6) n 1 10.6f 01 y y y dec declination (J2000 decimal deg) based on peak pixel deg decimal(8,6) n 1 10.6f 01 y y y glon galactic longitude (decimal deg) based on peak pixel deg decimal(9,6) n 0 10.6f 01 n n y glat galactic latitude (decimal deg) based on peak pixel deg decimal(9,6) n 1 10.6f 01 n n y designation (15) source designation formed from sexigesimal coordinates - char(14) n 0 15s 01 n y y x unit sphere x value - decimal(17,16) n 0 19.16f 01 n n n y unit sphere y value - decimal(17,16) n 0 19.16f 01 n n n z unit sphere z value - decimal(17,16) n 0 19.16f 01 n n n x_coadd x (cross-scan) position (coadd coord.) arcsec decimal(4,1) n 1 6.1f 01 n n n y_coadd y (in-scan) position (coadd coord.) arcsec decimal(5,1) n 1 6.1f 01 n n n r_3sig 3-sigma K isophotal semi-major axis arcsec decimal(4,1) y 0 5.1f 01 y y y _ba minor/major axis ratio fit to the 3-sigma isophote - decimal(4,3) y 0 5.3f 01 y y y _phi angle to 3-sigma major axis (E of N) deg smallint y 0 3hd 01 y y y _m (1) selected "default" magnitude mag decimal(5,3) y 1 6.3f 01 y y y _msig (2,16) "default" mag uncertainty mag decimal(4,3) y 0 5.3f 01 y y y _flg (3) confusion flag for "default" magnitude - smallint y 0 1hd 01 y y y j_mtype source of J "default" mag (0=j_m_k20fe, 1=j_m_j21fe) - smallint n 0 1hd 01 y y y h_mtype source of H "default" mag (0=h_m_k20fe, 1=h_m_j21fe) - smallint n 0 1hd 01 y y y k_mtype source of K "default" mag (0=k_m_k20fe, 1=k_m_j21fe) - smallint n 0 1hd 01 y y y Total elliptical photometry _r_e Kron elliptical aperture semi-major axis arcsec decimal(4,1) y 0 5.1f 01 n n n _m_e Kron elliptical aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_e (16) 1-sigma uncertainty in Kron elliptical mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_e (3) confusion flag for Kron elliptical mag - smallint y 0 1hd 01 n n n Total photometry using K fiducial elliptical aperture r_fe (4) K fiducial Kron elliptical aperture semi-major axis arcsec decimal(4,1) y 0 5.1f 01 n n n _m_fe fiducial Kron elliptical aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_fe (16) 1-sigma uncertainty in fiducial Kron ell. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_fe (3) confusion flag for fiducial Kron ell. mag - smallint y 0 1hd 01 n n n Total circular photometry _r_c Kron circular aperture radius arcsec decimal(4,1) y 0 5.1f 01 n n n _m_c Kron circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_c (16) 1-sigma uncertainty in Kron circular mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_c (3) confusion flag for Kron circular mag - smallint y 0 1hd 01 n n n Total photom using K fiducial circular aperture r_fc (4) K fiducial Kron circular aperture radius arcsec decimal(4,1) y 0 5.1f 01 n n n _m_fc fiducial Kron circular magnitude mag decimal(5,3) y 1 6.3f 01 n n n _msig_fc (16) 1-sigma uncertainty in fiducial Kron circ. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_fc (3) confusion flag for fiducial Kron circ. mag - smallint y 0 1hd 01 n n n Isophotal photom at 20 mag/sq.arcsec using ell ap _r_i20e 20mag/sq." isophotal elliptical ap. semi-major axis arcsec decimal(4,1) y 0 5.1f 01 n n n _m_i20e 20mag/sq." isophotal elliptical ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_i20e (16) 1-sigma uncertainty in 20mag/sq." iso. ell. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_i20e (3) confusion flag for 20mag/sq." iso. ell. mag - smallint y 0 1hd 01 n n n Isophotal photom at 20 using K fiducial ellip ap r_k20fe (4) 20mag/sq." isophotal K fiducial ell. ap. semi-major axis arcsec decimal(4,1) y 0 5.1f 01 n n y _m_k20fe 20mag/sq." isophotal fiducial ell. ap. magnitude mag decimal(5,3) y 1 6.3f 01 n n y _msig_k20fe(16) 1-sigma uncertainty in 20mag/sq." iso.fid.ell.mag mag decimal(4,3) y 0 5.3f 01 n n y _flg_k20fe (3) confusion flag for 20mag/sq." iso. fid. ell. mag - smallint y 0 1hd 01 n n y Isophotal photom at 20 using circ ap _r_i20c 20mag/sq." isophotal circular aperture radius arcsec decimal(4,1) y 0 5.1f 01 n n n _m_i20c 20mag/sq." isophotal circular ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_i20c (16) 1-sigma uncertainty in 20mag/sq." iso. circ. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_i20c (3) confusion flag for 20mag/sq." iso. circ. mag - smallint y 0 1hd 01 n n n Isophotal photom at 20 using K fiducial circ ap r_k20fc (4) 20mag/sq." isophotal K fiducial circular ap. radius arcsec decimal(4,1) y 0 5.1f 01 n n n _m_k20fc 20mag/sq." isophotal fiducial circ. ap. mag mag decimal(5,3) y 1 6.3f 01 n n n _msig_k20fc(16) 1-sigma uncertainty in 20mag/sq." iso.fid.circ. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_k20fc (3) confusion flag for 20mag/sq." iso. fid. circ. mag - smallint y 0 1hd 01 n n n Isophotal photom at 21 mag/sq.arcsec using ell ap _r_i21e 21mag/sq." isophotal elliptical ap. semi-major axis arcsec decimal(4,1) y 0 5.1f 01 n n n _m_i21e 21mag/sq." isophotal elliptical ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_i21e (16) 1-sigma uncertainty in 21mag/sq." iso. ell. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_i21e (3) confusion flag for 21mag/sq." iso. ell. mag - smallint y 0 1hd 01 n n n Isophotal photom at 21 using J fiducial ellip ap r_j21fe (4) 21mag/sq." isophotal J fiducial ell. ap. semi-major axis arcsec decimal(4,1) y 0 5.1f 01 n n n _m_j21fe 21mag/sq." isophotal fiducial ell. ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_j21fe(16) 1-sigma uncertainty in 21mag/sq." iso.fid.ell.mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_j21fe (3) confusion flag for 21mag/sq." iso. fid. ell. mag - smallint y 0 1hd 01 n n n Isophotal photom at 21 using circ ap _r_i21c 21mag/sq." isophotal circular aperture radius arcsec decimal(4,1) y 0 5.1f 01 n n n _m_i21c 21mag/sq." isophotal circular ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_i21c (16) 1-sigma uncertainty in 21mag/sq." iso. circ. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_i21c (3) confusion flag for 21mag/sq." iso. circ. mag - smallint y 0 1hd 01 n n n Isophotal photom at 21 using J fiducial circ ap r_j21fc (4) 21mag/sq." isophotal J fiducial circular ap. radius arcsec decimal(4,1) y 0 5.1f 01 n n n _m_j21fc 21mag/sq." isophotal fiducial circ. ap. mag mag decimal(5,3) y 0 6.3f 01 n n n _msig_j21fc(16) 1-sigma uncertainty in 21mag/sq." iso.fid.circ.mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_j21fc (3) confusion flag for 21mag/sq." iso. fid. circ. mag - smallint y 0 1hd 01 n n n Photometry from extrapolation fit _r_ext extrapolation radius arcsec decimal(4,1) y 0 5.1f 01 n n n _m_ext mag from fit extrapolation mag decimal(5,3) y 0 6.3f 01 n n n Photometry from fixed circular aperture _m_5 5 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_5 (16) 1-sigma uncertainty in 5 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_5 (3) confusion flag for 5 arcsec circular ap. mag - smallint y 0 1hd 01 n n n _m_7 7 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_7 (16) 1-sigma uncertainty in 7 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_7 (3) confusion flag for 7 arcsec circular ap. mag - smallint y 0 1hd 01 n n n _m_10 10 arcsec radius circular aperture magnitude mag decimal(5,3) y 1 6.3f 01 n n y _msig_10 (16) 1-sigma uncertainty in 10 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n y _flg_10 (3) confusion flag for 10 arcsec circular ap. mag - smallint y 0 1hd 01 n n y _m_15 15 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_15 (16) 1-sigma uncertainty in 15 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_15 (3) confusion flag for 15 arcsec circular ap. mag - smallint y 0 1hd 01 n n n _m_20 20 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_20 (16) 1-sigma uncertainty in 20 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_20 (3) confusion flag for 20 arcsec circular ap. mag - smallint y 0 1hd 01 n n n _m_25 25 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_25 (16) 1-sigma uncertainty in 25 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_25 (3) confusion flag for 25 arcsec circular ap. mag - smallint y 0 1hd 01 n n n _m_30 30 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_30 (16) 1-sigma uncertainty in 30 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_30 (3) confusion flag for 30 arcsec circular ap. mag - smallint y 0 1hd 01 n n n _m_40 40 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_40 (16) 1-sigma uncertainty in 40 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_40 (3) confusion flag for 40 arcsec circular ap. mag - smallint y 0 1hd 01 n n n _m_50 50 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_50 (16) 1-sigma uncertainty in 50 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_50 (3) confusion flag for 50 arcsec circular ap. mag - smallint y 0 1hd 01 n n n _m_60 60 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_60 (16) 1-sigma uncertainty in 60 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_60 (3) confusion flag for 60 arcsec circular ap. mag - smallint y 0 1hd 01 n n n _m_70 70 arcsec radius circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n n _msig_70 (16) 1-sigma uncertainty in 70 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n n _flg_70 (3) confusion flag for 70 arcsec circular ap. mag - smallint y 0 1hd 01 n n n System photometry _m_sys (5) system photometry magnitude mag decimal(5,3) y 0 6.3f 01 n n y _msig_sys (16) 1-sigma uncertainty in system photometry mag mag decimal(4,3) y 0 5.3f 01 n n y sys_flg system flag: 0=no system, 1=nearby galaxy flux incl. in mag - smallint y 0 1hd 01 n n y contam_flg (17) stellar and artifact contamination flag - smallint y 0 1hd 01 n n y 3-sigma radii and mean surface brightness _r_3signorm 3-sigma radius normalized by shape radius arcsec decimal(5,1) y 0 6.1f 01 n n n _mnsurfb mean surface brightness at the 3-sig norm. radius mag decimal(5,2) y 0 6.2f 01 n n n 5-sigma area ratios _5sig_ba minor/major axis ratio fit to the 5-sigma isophote - decimal(4,3) y 0 5.3f 01 n n n _5sig_phi angle to 5-sigma major axis (E of N) deg smallint y 0 3hd 01 n n n 5-sigma to 3-sigma area _d_area 5-sigma to 3-sigma differential area - smallint y 0 3hd 01 n n n _perc_darea 5-sigma to 3-sigma percent area change - smallint y 0 3hd 01 n n n Bi-symmetric quantities _bisym_rat bi-symmetric flux ratio - decimal(4,3) y 0 5.3f 01 n n n _bisym_chi bi-symmetric cross-correlation chi - decimal(5,3) y 0 6.3f 01 n n n Parameters for extended src discrimination from point srcs _sh0 ridge shape (LCSB: BSNR limit) - decimal(4,2) y 0 5.2f 01 n y y _sig_sh0 ridge shape sigma (LCSB: B2SNR limit) - decimal(4,2) y 0 5.2f 01 n y y _sc_mxdn mxdn (score) (LCSB: BSNR - block/smoothed SNR) - decimal(5,1) y 0 6.1f 01 n n n _sc_sh shape (score) - decimal(5,1) y 0 6.1f 01 n n n _sc_wsh wsh (score) (LCSB: PSNR - peak raw SNR) - decimal(5,1) y 0 6.1f 01 n n n _sc_r23 r23 (score) (LCSB: TSNR - integrated SNR for r=15) - decimal(5,1) y 0 6.1f 01 n n n _sc_1mm 1st moment (score) (LCSB: super blk 2,4,8 SNR) - decimal(5,1) y 0 6.1f 01 n n n _sc_2mm 2nd moment (score) (LCSB: SNRMAX - super SNR max) - decimal(5,1) y 0 6.1f 01 n n n _sc_vmn vmean (score) - decimal(5,1) y 0 6.1f 01 n n n _sc_vint vint (score) - decimal(5,1) y 0 6.1f 01 n n n _scalen alpha scale length - decimal(5,1) y 0 6.1f 01 n n n _sc_r1 r1 (score) - decimal(5,1) y 0 6.1f 01 n n n _sc_msh median shape score - decimal(5,1) y 0 6.1f 01 n n n _subst2 residual background #2 (score) - decimal(5,1) y 0 6.1f 01 n n n j_chif_ellf J % chi-fraction for elliptical fit to 3-sig isophote - decimal(5,1) y 0 6.1f 01 n n n k_chif_ellf K % chi-fraction for elliptical fit to 3-sig isophote - decimal(5,1) y 0 6.1f 01 n n n sup_chif_ellf super-coadd % chi-fraction for ellip. fit to 3-sig isophote - decimal(5,1) y 0 6.1f 01 n n n Coadd background, brightness _back coadd median background - decimal(5,1) y 0 6.1f 01 n y y _resid_ann residual annulus background median DN decimal(6,3) y 0 7.3f 01 n n n _peak peak pixel brightness mag decimal(5,2) y 0 6.2f 01 n n y _5surf central surface brightness (r<=5) mag decimal(5,2) y 0 6.2f 01 n y y j_bndg_per J banding Fourier Transf. period on this side of coadd arcsec smallint y 0 5d 01 n n y j_bndg_amp J banding maximum FT amplitude on this side of coadd DN decimal(5,3) y 0 6.3f 01 n n y h_bndg_per H banding Fourier Transf. period on this side of coadd arcsec smallint y 0 5d 01 n n y h_bndg_amp H banding maximum FT amplitude on this side of coadd DN decimal(5,3) y 0 6.3f 01 n n y k_bndg_per K banding Fourier Transf. period on this side of coadd arcsec smallint y 0 5d 01 n n y k_bndg_amp K banding maximum FT amplitude on this side of coadd DN decimal(5,3) y 0 6.3f 01 n n y _seetrack band seetracking score - decimal(3,1) y 0 4.1f 01 n y y _airglow band airglow score - decimal(5,2) y 0 6.2f 01 n n n density coadd log(density) of stars with k<14 mag - decimal(4,2) y 0 5.2f 01 n n y Super-coadd parameters sup_ra super-coadd centroid RA (J2000 decimal deg) deg decimal(9,6) n 0 10.6f 01 n n n sup_dec super-coadd centroid Dec (J2000 decimal deg) deg decimal(8,6) n 0 10.6f 01 n n n sup_r_3sig super-coadd 3-sigma isophotal semi-major axis radius arcsec decimal(4,1) y 0 5.1f 01 n n n sup_ba minor/major axis ratio fit to 3-sig. super-coadd isophote - decimal(4,3) y 0 5.3f 01 n n n sup_phi super-coadd angle to major axis (E of N) deg smallint y 0 3hd 01 n n n sup_r_3signorm super-coadd 3-sigma radius normalized by shape radius arcsec decimal(5,1) y 0 6.1f 01 n n n sup_mnsurfb super-coadd mean surface brightness at 3-sig norm. radius mag decimal(5,2) y 0 6.2f 01 n n n Postage-stamp image parameters im_nx size of postage stamp image in pixels - smallint n 0 2hd 01 n n n n_blank (6) number of blanked source records - smallint n 0 4hd 01 n y y n_sub (6) number of subtracted source records - smallint n 0 4hd 01 n y y bl_sub_flg blanked/subtracted src description flag - smallint n 0 1hd 01 n n n Other parameters id_flg (7) type/galaxy ID flag (0=non-catalog, 1=catalog, 2=LCSB) - smallint n 0 1hd 01 n y y id_cat matched galaxy's catalog name - char(10) y 0 10s 01 n y y r_ngc distance from nearest big galaxy arcsec decimal(5,2) y 0 6.2f 01 n n y fg_flg flux-growth convergence flag - char(6) y 0 6s 01 n n n blk_fac LCSB blocking factor (1, 2, 4, 8) - smallint y 0 1hd 01 n n n ellfit_flg ellipse fitting contamination flag - smallint y 0 1hd 01 n n n Color parameters j_h (8) default J-H mag color mag decimal(5,3) y 1 7.3f 01 n y y j_h_sig (9) sigma for J-H mag color mag decimal(4,3) y 0 5.3f 01 n y y h_k (8) default H-K mag color mag decimal(5,3) y 1 7.3f 01 n y y h_k_sig (9) sigma for H-K mag color mag decimal(4,3) y 0 5.3f 01 n y y j_k (8) default J-K mag color mag decimal(5,3) y 1 7.3f 01 n y y j_k_sig (9) sigma for J-K mag color mag decimal(4,3) y 0 5.3f 01 n y y b_r B-R mag color of associated optical source mag decimal(5,3) y 0 7.3f 01 n n y r_k (8) default R-K mag color (using associated optical source) mag decimal(5,3) y 0 7.3f 01 n n y b_k (8) default B-K mag color mag decimal(5,3) y 0 7.3f 01 n n y r_j (8) default R-J mag color mag decimal(5,3) y 0 7.3f 01 n n y b_j (8) default B-J mag color mag decimal(5,3) y 0 7.3f 01 n n y pts_key (10) key to point source data DB record - integer y 1 9d 01 n y y mp_key (11) key to minor planet prediction DB record - integer y 0 5d 01 n n n night_key (12) key to night data record in "scan DB" - integer n 1 4d 01 n n n scan_key (13) key to scan data record in "scan DB" - integer n 1 6d 01 n n n coadd_key (14) key to coadd data record in "scan DB" - integer n 1 7d 01 n n n spt_ind spatial (x,y,z) index key - integer n 1 9d 01 n n n clr_ind color index key - integer y 0 9d 01 n n n dup_src has duplicate source extractions (overlap areas) - smallint y 0 1hd 01 n n y use_src this extraction of duplicate source is to be used - smallint y 0 1hd 01 n n y e_score extended score: 1(point-like) < e_score < 2 (extended) - decimal(5,2) y 0 6.2f 01 n y y g_score galaxy score: 1(point-like) < g_score < 2 (extended) - decimal(5,2) y 0 6.2f 01 n y y feye (18) "eye" score for source - smallint y 0 2hd 01 n y y ---------------------------------------------------------------------------------------------------------------------------------------------- total # columns = 413, # bytes/row = 1454 ---------------------------------------------------------------------------------------------------------------------------------------------- NOTES: (1) This is the selected "default" magnitude for each band. The first choice for the [jhk]_m values are the mags in each band at 20 mag/sq.arcsec w/K fiducial circular aperture ([jhk]_m_k20fc), indicated by [jhk]_mtype values of 0. If, however, the K band mag in this group is > 14.0 (including negative flux or no mag found), all 3 [jhk]_m values will be the mags at 21 mag/sq.arcsec w/J fiducial circular aperture ([jhk]_m_j21fc) and the flags [jhk]_mtype are set to 1. If any one of chosen set of "default" mags is > 99, indicating no mag found, the DB entry for that "default" mag will be set to NULL.
Thus, the [jhk]_mtype flags will indicate the source of the "default" mags and sigmas as follows:
0: [jhk]_m_k20fe values
1: [jhk]_m_j21fe values
------------------------- (2) The mag sigma values corresponding to the selected "default" magnitude for each band are put in the [jhk]_msig fields. See also note (16). ------------------------- (3) The confusion flags [jhk]_flg* for each mag are defined as follows:
0 if no other sources within aperture used
1 if ap contained pixels masked off in coadd
2 if ap contained pixels masked off due to neighboring sources
3 if ap contained pixels that had a point source flux subtracted off
4 if ap contained pixels within bright star mask
5 if ap contained pixels masked off due to persistence
6 if aperture ran into coadd boundary
7 if ap contained pixels within bright galaxy mask
9 if integrated flux is negative
If the integrated flux is negative, a mag value is calculated using
BFMag = 99.0 - [ZERO_CAL - 2.5 log10(|flux|)];
the resulting mag range is between ~ 75 and 99. ------------------------- (4) "Fiducial" apertures are determined for each type of total and isophotal photometry measurements as described in the GALWORKS SDS. Essentially, they are used to make mag measurements for each type of photometry with the same aperture size in all three bands. The fiducial band for the total Kron photometry and 20mag/sq." isophotal photometry is the K band, and for the 21mag/sq." isophotal photometry it is the J band. ------------------------- (5) The system flux includes the flux from this extended source and anything else in the immediate area, including stars and neighboring galaxies that "touch" this source. ------------------------- (6) These parameters refer to sources that were blanked and/or subtracted from the images before doing photometry. Data for each of these blanked/ subtracted sources are found in the blanked and subtracted source tables. ------------------------- (7) This flag indicates the extended source catalog type as follows:
0 = extended source not found in another catalog
1 = extended source is found in galaxy catalog (ID found in id_cat field)
2 = LCSB (Low Central Surface Brightness) source
------------------------- (8) Magnitude colors are calculated using the [jhk]_m default mags and sigmas for the extended sources and the optical mags [br]_m_opt in the associated point source entry. If one of the mags used in a color calculation is NULL, the color value is an upper or lower limit. (Color limits are NOT calculated when both mags are NULL.) ------------------------- (9) 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 mags used in the calculation is NULL, the color sigma is the other band's mag sigma. ------------------------- (10) If the source has point source data (i.e. it is not an LCSB), this field will be set to the key of the record in the point source table containing the point source data. The point source data will also have the same date, hemisphere, scan, id keys. ------------------------- (11) 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. ------------------------- (12) 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. ------------------------- (13) 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, scan keys. ------------------------- (14) This field is set to the key of the record containing the corresponding J, H, and K band coadd data in the coadd data table. The records will also have the same date, hemisphere, scan, coadd keys. ------------------------- (15) This is the object sequence designation, or object "name" as specified by the IAU recommendations on source nomenclature. It is derived from the J2000 sexigesimal coordinates of the source and has the form HHMMSSS+/-DDMMSS, where HH are the hours of right ascension, MM the RA minutes and SSS are the deci-seconds of RA. DD are the degrees in declination, MM are DEC minutes and SS the declination seconds. Note that both the RA deci-seconds of time and DEC seconds of arc are truncated rather than rounded, per the IAU recommendation. ------------------------- (16) All quoted magnitude uncertainties are the "combined" uncertainties for each band that provide an estimate of all random errors that contribute to the photometry. These uncertainties are the quadratic combination of the source extraction uncertainites, the photometric zero point offset uncertainties from the night during which the source was observed ([jhk]_zperr from the "Scan Data" table), and the residual flat-fielding errors (estimated to be 0.005 mags for all bands). The simple measurement uncertainty can be recovered by backing out the contributions of the photometric zero point uncertainty and the flat-fielding uncertainty from the values listed. ------------------------- (17) The stellar and artifact contamination flag provides information about whether the extended source brightness estimate may be contaminated by superimposed point sources, or possible confusion with image artifacts generated by nearby bright stars (e.g. latent images, diffraction spikes, confusion halos and ghosts, and stripes). The value of the flag is given by: (stellar_contam_flg*10) + artflag. "Stellar_contam_flg"=0 if there is no contamination by superimposed point sources and =1 if there is. "Artflag" is the key to possible bright star artifact contamination and has the value: 0=no contamination, 1=dichroic glint, 2=latent or persistence image, 3=diffraction spike, 4=confusion in wings of a bright star. ------------------------- (18) The "eye" score gives the source type for those sources examined "by eye":
-1 = no verification (i.e., not examined)
-2 = unknown
1 = galaxy
2 = non-extended (e.g., star, double, triple, artifact)
---------------------------------------------------------------------------------------------------------------------------------------------- Possible NULL fields -------------------- All fields can be NULL at times, except for the first 15 fields listed above (cntr through y_coadd), fiducial radii fields, flag fields, super-coadd fields, and the night, scan, and coadd data keys. The number of NULLs will be non-negligible, since extended srcs often can only be detected in 1 or 2 bands, and only the "default" mags will contain a band-fill mag value. However, the mag colors that involve only one NULL or band-filled mag will be upper or lower limits. For LCSB srcs, the following fields are NULL (including all elliptical aperture mag fields): r_3sig _ba _phi _r_e _m_e _msig_e _flg_e r_fe _m_fe _msig_fe _flg_fe _r_i20e _m_i20e _msig_i20e _flg_i20e r_k20fe _m_k20fe _msig_k20fe _flg_k20fe _r_i21e _m_i21e _msig_i21e _flg_i21e r_j21fe _m_j21fe _msig_j21fe _flg_j21fe _r_ext _m_ext _m_sys _msig_sys sys_flg contam_flg _5sig_ba _5sig_phi _bisym_rat _bisym_chi _sc_vmn _sc_vint _sc_r1 _sc_msh _subst2 _resid_ann ellfit_flg pts_key mp_key