DBPREP Output File Specification and Description (19 Nov 2009) [arc07 WSDC D-I144 version 3.2] Interface Name: Level 1b Solar System Object Frame Metadata 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 frame metadata 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_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_i1ba_frm_4_1.tbl.76543a /wise_i1ba_frm_4_1.bartbl.16143a The data dictionary defining the IPAC table format and the database table structure is below. \fixlen = T \ Default Data Dictionary \ Date: 11-11-2009 \ \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| |int | char | char | char | char | char | char | char |char | int | int | char | char|char| char| 1 nmch Nmch number of WISE/SSO (solar system object) matches in frame i 4d integer y 2 1 y y y 2 ratmch RatMch match rate, Nmch/number of SSOs r 5.3f decimal(4,3) y 2 2 y y n 3 avgdx AvgDX average X offset in arcsec, null if nstat = 0 arcsec r 11.6f decimal(9,6) y 2 3 y y n 4 avgdy AvgDY average Y offset in arcsec, null if nstat = 0 arcsec r 11.6f decimal(9,6) y 2 4 y y n 5 sigdx SigDX sigma of X offset in arcsec, null if nstat = 0 arcsec r 9.6f decimal(8,6) y 2 5 y y n 6 sigdy SigDY sigma of Y offset in arcsec, null if nstat = 0 arcsec r 9.6f decimal(8,6) y 2 6 y y n 7 avgchsq AvgChSq reduced 2-D chi-square, null if nstat = 0 r 7.3f decimal(6,3) y 2 7 y y n 8 nstat Nstat number of clean matches for stats i 5d integer y 2 8 y y n 9 ndc nDC number of disconnected SSOs i 5d integer y 2 9 n n n 10 nnow3w4 NnoW3W4 number of fruitless matches i 5d integer y 2 10 n n n 11 nw3 nW3 number of band 3-only matches i 5d integer y 2 11 n n n 12 nw4 nW4 number of band 4-only matches i 5d integer y 2 12 n n n 13 nw3w4 nW3W4 number of band 3 and 4 matches i 5d integer y 2 13 n n n 14 frame_id frame_id frame number i 03d integer y 2 14 y y y 15 scan_id scan_id scan ID c 6s character(6) y 2 15 y y y 16 load_id load_id unique load ID number i 4d integer n 2 16 n n n 17 cntr cntr unique entry counter (key) number i 12d serial8 y 2 17 n n y