$Id: db_wispr_fits_description.txt,v 1.3 2019/11/12 18:02:43 nathan Exp $ wispr_fits ========== Datatypes --------- tinyint - 1 byte smallint - 2 byte mediumint - 3 byte int - 4 byte bigint - 8 byte float - 4 byte double - 8 byte blob - Binary Large Object: binary (byte) strings datetime - 'YYYY-MM-DDThh:mm:ss.sss' format varchar - string(length) WISPR_FITS_STRUCT ----------------- diskpath varchar(80) final tinyint(1) SIMPLE tinyint(1) ;Conforms to fits standard (T/F) BITPIX smallint(6) ;Number of bits per pixel (neg is floating point) 16, 32, -32, -64 NAXIS smallint(6) ;Number of axes in array 0,2,3 NAXIS1 smallint(6) ;Number of pixels in horizontal axis Positive NAXIS2 smallint(6) ;Number of pixels in vertical axis Positive EXTEND tinyint(1) ;Indicates there is (not) an extension T/F FILENAME varchar(50) ;Name of fits file : psp__wispr__VN_.fts ;level=[L1,L2,L3,cal]; tel=[1,2], region=[0..6], N=0 for quicklook else version increments ;microcode=LSB of DRB1 Microcode CRC [5] ;DATE-BEG= UTC YYYYHHMMThhmmss FILE_RAW varchar(20) ;Downloaded image filename APID varchar(6) ;Hex string Application ID [418,419,41a,41b,41e,41f] DATE datetime ;YYYY-MM-DDThh:mm:ss.sss [UTC] Time of file creation DATE_OBS datetime(3) ;YYYY-MM-DDThh:mm:ss.sss [UTC] Start time of observation DATE_BEG datetime(3) ;YYYY-MM-DDThh:mm:ss.sss [UTC] Start time of observation DATE_AVG datetime(3) ;YYYY-MM-DDThh:mm:ss.sss [UTC] Average time of observation DATE_END datetime(3) ;YYYY-MM-DDThh:mm:ss.sss [UTC] End time of (last) exposure OBT_BEG double ;MET when first pixel of first image is received from camera OBT_END double ;MET when first pixel of last image is received from camera NSUMEXP smallint(5) unsigned ;Total num in sequence NSUMBAD smallint(5) unsigned ;Number of images with invalid pixel counts XPOSURE float ;Effective exposure time (computed on ground) IP_TIMET smallint(5) unsigned ;Time between image received from camera and ship time READTIME float ;Time to readout raw image from camera in sec TELAPSE float ;Elapsed time between beginning and end of observation TIMESYS varchar(8) ;System used for time keywords (UTC) LEVEL varchar(8) ;Data processing Level (CAL1,L1,L2,L2b,L3) CREATOR varchar(40) ; / FITS creation software & version ORIGIN varchar(30) ;Where file was written (NRL) DETECTOR tinyint(4) ;1=Inner, 2=Outer REGION tinyint(3) unsigned ;Region (0..6) READOUT0 tinyint(3) unsigned ;Readout region if region=0 (1..6) CAMERA varchar(10) ; CICUCODE varchar(8) ;CIC ucode version ID hex string DRBUCODE varchar(8) ;DRB1 or DRB2 ucode (for single frame) DRB1UCOD varchar(8) ;DRB1 ucode Version ID hex string DRB2UCOD varchar(8) ;DRB2 ucode Version ID hex string OBJECT varchar(80) ;Type of object observed OBS_MODE varchar(80) ;[SYNOPTIC,SUBFIELD,HIGHCADENCE,NOSUM,LED,OFFPOINT,ROLLED,MOVING,BAD_DATA,SPECIAL] TARGET varchar(80) ;Type of target from planning TIMELINE varchar(10) ;string combination of Timeline index and address of OS run STUDY_ID varchar(12) ;Obs Seq ID = ISPREG7 (ref allos.txt) STUDYCNT smallint(5) unsigned ;Image count for observing sequence VERS_CAL varchar(8) ;Hex string packet header version number PRIORITY tinyint(3) unsigned ;Downlink priority VERSION tinyint(4) ;Version of file, starting at i=1 (CALi, Li) BSCALE float ;Ratio of physical to array value at 0 offset BZERO float ;Physical value for the array value 0 BUNIT varchar(10) ;Unit of physical value, varies with data Level DATAMIN float ;Minimum valid physical value DATAMAX float ;Maximum valid physical value BLANK float ;Value marking undefined pixels (0 for integer, NaN for floating pt) PXBEG1 smallint(5) unsigned ;First read-out detector row 1..1920 PXEND1 smallint(5) unsigned ;Last read-out detector row 1..1920 PXBEG2 smallint(5) unsigned ;First read-out detector column 1..2048 PXEND2 smallint(5) unsigned ;Last read-out detector column 1..2048 R1COL smallint(5) unsigned ;X subscript of start/end of readout on rectified detector 1..1920 R2COL smallint(5) unsigned ;X subscript of start/end of readout on rectified detector 1..1920 R1ROW smallint(5) unsigned ;Y subscript of start/end of readout on rectified detector 1..2048 R2ROW smallint(5) unsigned ;Y subscript of start/end of readout on rectified detector 1..2048 RECTIFY tinyint(1) Image has been rotated so ecliptic north is up T[F] RECTROTA tinyint(3) unsigned ;Argument for rotate.pro used to rectify image 0..7 NBIN1 smallint(5) unsigned ;Number of pixels binned along axis1; this will change to reflect changes in dimension. NBIN2 smallint(5) unsigned ;Number of pixels binned along axis2; this will change to reflect changes in dimension. NBIN smallint(5) unsigned ;Number of pixels binned; this will change to reflect any correction to the data. COMPRESS varchar(14) ;Data Compression Quality None, Lossless, Lossy[1..5] ;For Lossy, varies from 1 (lowest compression) to 5 (highest compression) COMP_RAT float ;Compressed/uncompressed quality ratio 0.0..1.0 COSMICR tinyint(1) ;Cosmic Ray Removal was enabled T/F DSTART1 smallint(5) unsigned ;First column of image array on data array 1 DSTOP1 smallint(5) unsigned ;Last column of image array on data array DSTART2 smallint(5) unsigned ;First row of image area on data array 1 DSTOP2 smallint(5) unsigned ;Last row of image area on data array IMGCTR smallint(5) unsigned ;Image counter from IDPU CCIMGSEQ smallint(5) unsigned ;Sequence time from camera frame header CCEXPCTL smallint(5) unsigned ;Exposure control value from camera frame header CCIMGCTR smallint(5) unsigned ;Image (frame) count from cameras COSMICS int(10) unsigned ;CRS corrected pixels CAMSATPX int(10) unsigned ;Pixels above saturation level CAMSTRVX int(10) unsigned ;Pixels below saturation level IP_INIT smallint(5) unsigned ;Init. Bits (no first/last sum) IPIMBUFF smallint(5) unsigned ;Image buffer size and base IPCMBUFF smallint(5) unsigned ;Image buffer size and base IPSATPX smallint(5) unsigned ;Pixel saturation IPSTRVPX smallint(5) unsigned ;Pixel starvation IPMINPX smallint(5) unsigned ;Pixel clamp, minimum IPMAXPX smallint(5) unsigned ;Pixel clamp maximum IPTRUNC smallint(5) unsigned ;Truncate command IPBIAS smallint(5) unsigned ;Bias function commanded IPCRSMUL float ;Threshold for replacement = IPCRSMUL * sqrt( current pixel ) IPBITSPP smallint(5) unsigned ;Bits per pixel before compression IPMASK smallint(5) unsigned ;Comma separated list of following 5 dec values: ;- mask enable and control ;- mask lower-left row ;- mask lower-left column ;- mask upper-right row ;- mask upper-right column IPMASKCR varchar(40) LEDSTATE varchar(8) ;State of LED1 and LED2 (LED1,LED2,LED1LED2,Off) LEDDAC smallint(5) unsigned ;Last commanded setting of LED1 or LED2 OFFSET smallint(5) unsigned ;Commanded offset value used in camera GAINCMD tinyint(3) unsigned ;Commanded gain value from register 0x50 (4 bits) for inner or outer GAINMODE varchar(4) ;(1=LOW=MIMON, 0=HIGH=MIMOFF, 2=SIMADC) IP_FUNC smallint(5) unsigned ;Pixel processing algorithm controls IPCMPCTL smallint(5) unsigned ;Compression control XFBYTES int(10) unsigned ;Number of bytes sent SCFLAGS varchar(80) ;Hex representation of 4 bytes of SPP flags CIE_T float ;DEG C DRB1_T float ;Inner DRB degC DET1_T float ;Inner detector Op degC DRB2_T float ;Outer DRB degC DET2_T float ;Outer detector Op degC ISPREG0 smallint(5) unsigned ;CIC Register 0 ISPREG1 smallint(5) unsigned ;CIC Register 1 ISPREG2 smallint(5) unsigned ;CIC Register 2 ISPREG3 smallint(5) unsigned ;CIC Register 3 ISPREG4 smallint(5) unsigned ;CIC Register 4 ISPREG5 smallint(5) unsigned ;CIC Register 5 ISPREG6 smallint(5) unsigned ;CIC Register 6 ISPREG7 smallint(5) unsigned ;CIC Register 7 ?? - not in PDF UCODREG0 smallint(5) unsigned ;Values in readout microcode programmable registers UCODREG1 smallint(5) unsigned ;Values in readout microcode programmable registers UCODREG2 smallint(5) unsigned ;Values in readout microcode programmable registers UCODREG3 smallint(5) unsigned ;Values in readout microcode programmable registers UCODREG4 smallint(5) unsigned ;Values in readout microcode programmable registers UCODREG5 smallint(5) unsigned ;Values in readout microcode programmable registers UCODREG6 smallint(5) unsigned ;Values in readout microcode programmable registers UCODREG7 smallint(5) unsigned ;Values in readout microcode programmable registers DSUN_OBS double ;[m] s/c distance from Sun SC_YAW float ;[deg] s/c yaw at DATE-AVG SC_PITCH float ;[deg] s/c yaw at DATE-AVG SC_ROLL float ;[deg] s/c roll at DATE-AVG -90..+90, 90..270 DATAZER int(11) ;Number of pixels=0 DATASAT int(11) ;Number of saturated pixels DSATVAL float DATAAVG float DATAMDN float DATASIG float ;Standard deviation of non-zero pixels DATAP01 int(11) ;1% of non-zero pixels are LE this value DATAP10 int(11) ;10% of non-zero pixels are LE this value DATAP25 int(11) ;25% of non-zero pixels are LE this value DATAP50 int(11) ;50% of non-zero pixels are LE this value DATAP75 int(11) ;75% of non-zero pixels are LE this value DATAP90 int(11) ;90% of non-zero pixels are LE this value DATAP95 int(11) ;95% of non-zero pixels are LE this value DATAP98 int(11) ;98% of non-zero pixels are LE this value DATAP99 int(11) ;99% of non-zero pixels are LE this value COMMENT blob ;Comments. Can be repeated HISTORY blob ;Comments of processing history, can be repeated