DBPREP Output File Specification and Description (19 Nov 2009) [arc06 WSDC D-I143 version 3.2] Interface Name: Level 1b Solar System Object Match Data Table Archive DB Interface Specification Type of Interface: program I/O Written By: DBPREP _________________________ T. L. Evans Read By: Database load utility Description: Version 3.2 of DBPREP (dated 11-20-2009) The output level 1b solar system object match data table includes concatenated data for all frames included in the DBPREP 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 ('a_mch'), 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_i1ba_mch_4_1.tbl.00453a /wise_i1ba_mch_4_1.bartbl.09431a The data dictionary defining the IPAC table format and the database table structure is below. \ Default Data Dictionary \ \ Date: 11-11-2009 \ \ \fixlen = T \alias = none \longitude = ra \latitude = dec \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 idnum IDNum WISE source number in frame, 0 if no association made i 6d integer y 1 1 n n n 2 source_id source_id source ID (scan ID, frame num, and source number) c 16s character(16) y 2 2 y y y 3 frame_id frame_id frame number i 03d integer y 1 3 n n y 4 scan_id scan_id scan ID c 6s character(6) y 1 4 n n y 5 w1nois W1nois noise in W1 from associated WISE src data, avg over frame if no association DN r 6.2f decimal(5,2) y 1 5 n n n 6 w2nois W2nois noise in W2 from associated WISE src data, avg over frame if no association DN r 6.2f decimal(5,2) y 1 6 n n n 7 w3nois W3nois noise in W3 from associated WISE src data, avg over frame if no association DN r 6.2f decimal(5,2) y 1 7 n n n 8 w4nois W4nois noise in W4 from associated WISE src data, avg over frame if no association DN r 6.2f decimal(5,2) y 1 8 n n n 9 mconf MConf match confidence: 2-D chi-square parameter, max 99.99, -9.99 if no association r 6.2f decimal(4,2) y 2 9 y y n 10 n N # of WISE point sources within assoc. threshold (max 9), 0 if no association i 1d integer y 2 10 n n n 11 dra dRA RA distance (WISE - SSO) arcsec r 6.1f decimal(4,1) y 2 11 y y n 12 ddec dDec Dec distance (WISE - SSO) arcsec r 6.1f decimal(4,1) y 2 12 y y n 13 ra RA predicted Right Ascension (J2000) deg r 10.6f decimal(9,6) y 2 13 y y n 14 dec Dec predicted Declination (J2000) deg r 10.6f decimal(8,6) y 2 14 y y y 15 objid ObjID Solar System object ID c 36s character(36) y 2 15 y y y 16 t T type of Solar System object: A,Y,C,P,S,T,X c 1s character(1) y 2 16 y y n 17 rhelio RHelio heliocentric distance AU r 9.5f decimal(8,5) y 2 17 y y n 18 rtopo Rtopo topocentric (spacecraft) distance AU r 9.5f decimal(8,5) y 1 18 y y n 19 phase Phase phase angle deg r 7.3f decimal(6,3) y 2 19 y y n 20 vmag VMag visual magnitude mag r 6.3f decimal(5,3) y 2 20 y y n 21 mu Mu proper motion arcsec/s r 7.3f decimal(6,3) y 2 21 y y n 22 theta Theta direction of proper motion (E of N) deg r 5.1f decimal(4,1) y 2 22 y y n 23 emj EMj semimajor axis of error ellipse arcsec r 4.1f decimal(3,1) y 2 23 n n n 24 emn EMn semiminor axis of error ellipse arcsec r 4.1f decimal(3,1) y 2 24 n n n 25 erang ErAng direction of EMj axis (E of N) deg r 5.1f decimal(4,1) y 2 25 n n n 26 perdist PerDist perihelion distance AU r 10.7f decimal(9,7) y 1 26 n n n 27 ecc Ecc orbital eccentricity r 9.7f decimal(8,7) y 1 27 n n n 28 incl Incl orbital inclination deg r 12.8f decimal(11,8) y 1 28 n n n 29 pv1 PV1 P vector (unit vector of Sun toward perihelion) X component r 11.8f decimal(9,8) y 1 29 n n n 30 pv2 PV2 P vector (unit vector of Sun toward perihelion) Y component r 11.8f decimal(9,8) y 1 30 n n n 31 pv3 PV3 P vector (unit vector of Sun toward perihelion) Z component r 11.8f decimal(9,8) y 1 31 n n n 32 qv1 QV1 Q vector (unit vector orthog to P in orb plane, rt-handed abt ang mom) X comp. r 11.8f decimal(9,8) y 1 32 n n n 33 qv2 QV2 Q vector (unit vector orthog to P in orb plane, rt-handed abt ang mom) Y comp. r 11.8f decimal(9,8) y 1 33 n n n 34 qv3 QV3 Q vector (unit vector orthog to P in orb plane, rt-handed abt ang mom) Z comp. r 11.8f decimal(9,8) y 1 34 n n n 35 pertime PerTime perihelion passage time, modified Julian date mJD r 13.5f decimal(12,5) y 1 35 n n n 36 err Err orbital element quality estimate r 4.1f decimal(3,1) y 1 36 n n n 37 amag Amag absolute magnitude mag r 5.2f decimal(4,2) y 2 37 y y n 38 slope Slope slope parameter for computing phase-dependent term in visual mag r 5.2f decimal(4,2) y 2 38 n n n 39 w1mpro w1mpro associated WISE source W1 profile-fit magnitude mag r 7.3f decimal(5,3) y 2 39 y y n 40 w1sgmp w1sgmp associated WISE source W1 profile-fit magnitude uncertainty mag r 5.3f decimal(4,3) y 2 40 y y n 41 w2mpro w2mpro associated WISE source W2 profile-fit magnitude mag r 7.3f decimal(5,3) y 2 41 y y n 42 w2sgmp w2sgmp associated WISE source W2 profile-fit magnitude uncertainty mag r 5.3f decimal(4,3) y 2 42 y y n 43 w3mpro w3mpro associated WISE source W3 profile-fit magnitude mag r 7.3f decimal(5,3) y 2 43 y y n 44 w3sgmp w3sgmp associated WISE source W3 profile-fit magnitude uncertainty mag r 5.3f decimal(4,3) y 2 44 y y n 45 w4mpro w4mpro associated WISE source W4 profile-fit magnitude mag r 7.3f decimal(5,3) y 2 45 y y n 46 w4sgmp w4sgmp associated WISE source W4 profile-fit magnitude uncertainty mag r 5.3f decimal(4,3) y 2 46 y y n 47 bond Bond Bond albedo r 5.3f decimal(4,3) y 1 47 y y n 48 sgbnd SgBnd Bond albedo uncertainty r 5.3f decimal(4,3) y 1 48 y y n 49 diam Diam diameter km r 7.2f decimal(6,2) y 2 49 y y n 50 sigdm SigDm diameter uncertainty km r 5.2f decimal(4,2) y 2 50 y y n 51 beam Beam beaming parameter r 5.3f decimal(4,3) y 1 51 y y n 52 sgbem SgBem beaming parameter uncertainty r 5.3f decimal(4,3) y 1 52 y y n 53 tss Tss sub-solar temperature K r 7.2f decimal(6,2) y 1 53 y y n 54 sgtss SgTss sub-solar temperature uncertainty K r 5.2f decimal(4,2) y 1 54 y y n 55 scan scan scan ID c 6s character(6) y 1 55 n n y 56 frame frame frame number i 03d integer y 1 56 n n y 57 obsepoch obsepoch Epoch of observation (frame) JD r 18.9f decimal(17,9) y 1 57 n n n 58 jul_date jul_date modified Julian date of the mid-point of the observation of the frame mjdate r 12.6f decimal(11,6) y 1 58 y y n 59 load_id load_id unique load ID number i 4d integer n 2 59 n n n 60 cntr cntr unique entry counter (key) number i 12d serial8 n 2 60 n n y 61 x x unit sphere (x,y,z) position x value r 19.16f decimal(17,16) n 2 61 h h n 62 y y unit sphere (x,y,z) position y value r 19.16f decimal(17,16) n 2 62 h h n 63 z z unit sphere (x,y,z) position z value r 19.16f decimal(17,16) n 2 63 h h n 64 spt_ind spt_ind spatial (x,y,z) index key i 9d integer n 2 64 h h y