DBPREP Output File Specification and Description (19 Nov 2009) [arc08 WSDC D-I150 version 3.2] Interface Name: Level 1b Image Frame Metadata Table Archive Image Service DB Interface Specification Type of Interface: program I/O Written By: IMGPREP _________________________ T. L. Evans Read By: Database load utility Description: Version 3.2 of IMGPREP (dated 11-20-2009) The output level 1b image frame metadata table includes concatenated data for all frames included in the IMGPREP run. The table name follows the WISE/IRSA DB table naming convention and is determined by the input parameters 'out_dir' and 'out_base', the access type ('i' for internal), data type ('m_frm'), data level ('1b'), DB table version number, load ID number, output format (bar-delimited or IPAC table), and the scan ID string. For example: /wise_i1bm_frm_4_1.tbl.97394b /wise_i1bm_frm_4_1.bartbl.17485a The data dictionary defining the IPAC table format and the database table structure is below. \ Default Data Dictionary \ Date: 11-17-2009 \ \ \ \fixlen = T \alias = none \longitude = crval1 \latitude = crval2 \primary = cntr \spt_ind = spt_ind \x = x \y = y \z = z |cntr| name | original_name | description | units | intype | format | dbtype |nulls|tableflg|groupid|irsadef| sel |indx| notes | | i | c | c | c | c | c | c | c | c | i | i | c | c | c | c | 1 band band WISE band number i 1d integer n 2 1 y y n 2 naxis naxis number of data axes i 1d integer n 2 2 y y n 3 naxis1 naxis1 number of pixels in x (data axis 1) i 4d integer n 2 3 y y n 4 naxis2 naxis2 number of pixels in y (data axis 2) i 4d integer n 2 4 y y n 5 wrelease wrelease release version of WSDS pipeline c 15s character(15) y 2 5 y y n 6 crpix1 crpix1 reference pixel value for axis 1 (x) pix r 6.1f decimal(4,1) n 2 6 y y n 7 crpix2 crpix2 reference pixel value for axis 2 (y) pix r 6.1f decimal(4,1) n 2 7 y y n 8 crval1 crval1 reference RA J2000 position at crpix1,crpix2 deg r 16.12f decimal(15,12) n 2 8 y y n 9 crval2 crval2 reference Dec J2000 position at crpix1,crpix2 deg r 16.12f decimal(15,12) n 2 9 y y n 10 ctype1 ctype1 projection type (with distortion) for axis 1 (x) c 13s character(13) y 2 10 y y n 11 ctype2 ctype2 projection type (with distortion) for axis 2 (y) c 13s character(13) y 2 11 y y n 12 equinox equinox equinox of WCS information year r 6.1f decimal(5,1) y 2 12 y y n 13 bunit bunit image data unit c 20s character(20) y 2 13 y y n 14 elon elon ecliptic longitude of crval1,crval2 deg r 16.12f decimal(15,12) n 2 14 y y n 15 elat elat ecliptic latitude of crval1,crval2 deg r 16.12f decimal(15,12) n 2 15 y y n 16 glon glon galactic longitude of crval1,crval2 deg r 16.12f decimal(15,12) n 2 16 y y n 17 glat glat galactic latitude of crval1,crval2 deg r 16.12f decimal(15,12) n 2 17 y y n 18 ra1 ra1 RA J2000 position at corner #1 (crpix1,crpix2=-.5,-.5) deg r 16.12f decimal(15,12) n 2 18 y y n 19 dec1 dec1 Dec J2000 position at corner #1 (crpix1,crpix2=-.5,-.5) deg r 16.12f decimal(15,12) n 2 19 y y n 20 ra2 ra2 RA J2000 position at corner #2 (crpix1,crpix2=naxis1+.5,-.5) deg r 16.12f decimal(15,12) n 2 20 y y n 21 dec2 dec2 Dec J2000 position at corner #2 (crpix1,crpix2=naxis1+.5,-.5) deg r 16.12f decimal(15,12) n 2 21 y y n 22 ra3 ra3 RA J2000 position at corner #3 (crpix1,crpix2=naxis1+.5,naxis1+.5) deg r 16.12f decimal(15,12) n 2 22 y y n 23 dec3 dec3 Dec J2000 position at corner #3 (crpix1,crpix2=naxis1+.5,naxis1+.5) deg r 16.12f decimal(15,12) n 2 23 y y n 24 ra4 ra4 RA J2000 position at corner #4 (crpix1,crpix2=-.5,naxis1+.5) deg r 16.12f decimal(15,12) n 2 24 y y n 25 dec4 dec4 Dec J2000 position at corner #4 (crpix1,crpix2=-.5,naxis1+.5) deg r 16.12f decimal(15,12) n 2 25 y y n 26 magzp magzp relative photometric zero-point mag mag r 9.5f decimal(7,5) y 2 26 y y n 27 magzpunc magzpunc 1-sigma uncertainty in photometric zero-point mag mag r 9.6f decimal(7,6) y 2 27 y y n 28 scan_id scan_id scan ID c 6s character(6) n 2 28 y y n 29 scangrp scangrp scan group ID c 2s character(2) y 2 29 y y n 30 frame_id frame_id frame number in scan i 03d integer n 2 30 y y n 31 l0file l0file corresponding level 0 image file name c 200s character(200) y 2 31 y y n 32 date_obs date_obs date and time of mid-point of frame observation, UTC datetimeZ c 24s character(24) n 2 32 y y n 33 mjd_obs mjd_obs modified julian date of mid-point of frame observation, UTC mjdate r 14.8f decimal(13,8) n 2 33 y y n 34 dtanneal dtanneal time since last anneal sec r 18.11f decimal(17,11) y 2 34 y y n 35 utanneal utanneal date and time of last anneal, UTC datetimeZ c 24s character(20) y 2 35 y y n 36 unixt unixt UNIX date-time in sec of mid-point of frame observation, UTC sec r 16.5f decimal(15,5) n 2 36 y y n 37 ephemt ephemt ephemeris date-time in sec of mid-point of frame observation, UTC sec r 16.6f decimal(15,6) n 2 37 y y n 38 exptime exptime frame exposure time sec r 4.1f decimal(3,1) y 2 38 y y n 39 tsamp tsamp sec r 4.1f decimal(3,1) y 2 39 y y n 40 wcdelt1 wcdelt1 deg/pix scale at crpix1,crpix2 for axis 1 (x) deg/pix r 21.18f decimal(19,18) n 2 40 y y n 41 wcdelt2 wcdelt2 deg/pix scale at crpix1,crpix2 for axis 2 (y) deg/pix r 21.18f decimal(19,18) n 2 41 y y n 42 crder1 crder1 uncertainty in crval1 (RA) deg r 20.14e smallfloat y 2 42 y y n 43 crder2 crder2 uncertainty in crval2 (Dec) deg r 20.14e smallfloat y 2 43 y y n 44 csdradec csdradec costandard deviation in crval1 and crval2 (RA and Dec) deg r 20.14e smallfloat y 2 44 y y n 45 pxscal1 pxscal1 arcsec/pix scale at crpix1,crpix2 for axis 1 (x) asec/pix r 17.14f decimal(15,14) y 2 45 y y n 46 pxscal2 pxscal2 arcsec/pix scale at crpix1,crpix2 for axis 2 (y) asec/pix r 17.14f decimal(15,14) y 2 46 y y n 47 uncrts1 uncrts1 uncertainty in wcdelt1 deg/pix r 20.14e smallfloat y 2 47 y y n 48 uncrts2 uncrts2 uncertainty in wcdelt2 deg/pix r 20.14e smallfloat y 2 48 y y n 49 wcrota2 wcrota2 image twist angle of +axis2 W of N deg r 18.13f decimal(16,13) n 2 49 y y n 50 pa pa position angle of +axis2 E of N deg r 18.13f decimal(16,13) y 2 50 y y n 51 uncrtpa uncrtpa uncertainty in position angle deg r 21.18f decimal(19,18) y 2 51 y y n 52 skew skew measure of non-orthogonality of frame axes r 5.1f decimal(3,1) y 2 52 y y n 53 cd1_1 cd1_1 CD matrix element 1_1 deg/pix r 21.18f decimal(19,18) y 2 53 y y n 54 cd1_2 cd1_2 CD matrix element 1_2 deg/pix r 21.18f decimal(19,18) y 2 54 y y n 55 cd2_1 cd2_1 CD matrix element 2_1 deg/pix r 21.18f decimal(19,18) y 2 55 y y n 56 cd2_2 cd2_2 CD matrix element 2_2 deg/pix r 21.18f decimal(19,18) y 2 56 y y n 57 debgain debgain digital electronics box gain (e-/eff. slope units, Sample-Up-the-Ramp weights) e-/DEB ADU r 9.3f decimal(8,3) y 2 57 y y n 58 febgain febgain flight electronics box gain for individ. non-destructively read samples in ramp e-/SUR ADU r 10.4f decimal(9,4) y 2 58 y y n 59 date_imgprep date_imgprep date and time of imgprep run, UTC datetimeZ c 20s character(20) y 2 59 y y n 60 load_id load_id unique load ID number i 4d integer n 2 60 n n n 61 cntr cntr unique entry counter (key) number i 12d serial8 n 2 61 y y n 62 x x unit sphere (x,y,z) position x value r 19.16f decimal(17,16) n 2 62 y y n 63 y y unit sphere (x,y,z) position y value r 19.16f decimal(17,16) n 2 63 y y n 64 z z unit sphere (x,y,z) position z value r 19.16f decimal(17,16) n 2 64 y y n 65 spt_ind spt_ind spatial (x,y,z) index key i 9d integer n 2 65 y y n