SECCHI Image Database Definition
; ;$Log: secchi_img_tables_def.html,v $ ;Revision 1.9 2007/06/18 16:48:07 nathan ;updated status values to be unsigned ; ;Revision 1.8 2006/09/08 19:24:06 nathan ;update defn for DOWNLINK ; ;Revision 1.7 2006/09/08 17:16:38 nathan ;Modify EVENT and SEB_PROG; update defn for DISKPATH, LEDCOLOR ; ;Revision 1.6 2006/08/31 17:58:44 nathan ;remove CVS name/date/vers for individual tables ; ;Revision 1.5 2006/08/30 21:33:11 nathan ;added ; for all comments ; ;Revision 1.4 2006/07/19 19:17:09 esfand ;made more changes - aee ; ;Revision 1.3 2006/07/19 18:28:12 nathan ;made some values unsigned ; TABLE_DESC tinyint = 1 byte TABLE_DESC smallint = 2 byte TABLE_DESC mediumint = 3 byte TABLE_DESC int = 4 byte TABLE_DESC bigint = 8 byte TABLE_DESC char: fixed-length string TABLE_DESC varchar: variable length (up to max) string TABLE_DESC Mapping from number to string equivalent provided by def_scc_enums.pro. TABLE_DESC Indexing fields are for most commonly searched values; TABLE_DESC noted with TABLE_INDX. TABLE_NAME IMG_SEB_HDR TABLE_AUTH nathan TABLE_DATE 2006/08/30 TABLE_VERS 6 TABLE_DESC Image headers produced by the SECCHI FSW; Where applicable, values are as found in the raw science header. TABLE_DESC For field names, preference is given to SECCHI FITS Header tag names, then FSW header field names. TABLE_DESC FSW header structure field names are noted in parenthesis as first item in description. If not the database TABLE_DESC field name, FITS header tag name is noted in parenthesis after item description. TABLE_INDX OBSRVTRY tinyint, ;(platformid) 1=STEREO-A, 2=STEREO-B TABLE_INDX SYNC tinyint, ;(sync) 0=Not Synced, 1=SC-AB Synced TABLE_DEFN OBS_ID smallint unsigned, ;(osnumber) Observing Sequence number TABLE_INDX SEB_PROG tinyint, ;(imagetype) SEB program: 0=Normal, 1=Dark, 2=Double, ;3=LED, 4=Continuous, 5=Series, 6=Normal TABLE_DEFN OBS_PROG varchar(32), ;Proc name or JOP ID TABLE_INDX OBSSETID smallint, ;(campaignset) Set/Campaign ID number TABLE_DEFN LEDCOLOR tinyint, ;(cmdledmode) For calibration LED images: ;LEDCOLOR = 1 2 3 ;EUVI: FPA-Blue Tel-Purple Tel-Blue ;COR2: Tel-Red (door-close) FPA-Violet FPA-Blue ;Others:FPA-Red FPA-Violet FPA-Blue ;For non-LED images: LEDCOLOR = 0 (None) TABLE_INDX FILEORIG varchar(14), ;(filename) YMDDaaaa.APT TABLE_INDX FILENAME char(25), ;yyyymmdd_hhmmss_LATTS.fts (FSW n/a) where ;yyyymmdd_hhmmss: DATE_OBS ;L: Image type: ; n = Normal Image ; m = Multiple Exposures Combined Onboard ; d = Double Image ; k = Dark Image ; e = LED Image ; c = Continuous Image ; s = Sequence Image ; 1 = Total Brightness (Level-1 Image) ;A: Destination (3=RT, 4=SSR1, 5=SSR2, 7=SPW) ;TT: Telescope (eu,c1,c2,h1,h2,gt) ;S: A or B, S/C C=other, N=non-flight TABLE_DEFN THUMB_FN varchar(25), ;Thumbnail image filename yyyymmdd_hhmmss_LATTS.jpg TABLE_DEFN SYNCED_FN varchar(25), ;Null or filename if sync is set (FSW n/a) TABLE_DEFN SPWX tinyint, ;1 if image was also sent down SPWX channel, else 0 TABLE_DEFN DATE_MOD datetime, ;Date/time (UTC) processed (FSW n/a) TABLE_INDX DATE_OBS datetime, ;(actualexptime) Date/time (UTC) command sent to expose shutter TABLE_DEFN DATE_AVG datetime, ;Mid point of exposure(s) Date/time (UTC) of single or summed images TABLE_DEFN DATE_END datetime, ;Date/time (UTC) End of the (last) exposure for current image TABLE_INDX DETECTOR tinyint, ;(telescopeid) Telescope number: 3=EUVI,2=COR1,1=COR2,5=HI1,4=HI2 TABLE_INDX FILTER tinyint unsigned, ;(cmdfilterposition) 0-179 EUVI filter wheel commanded step number mapped to 4 ; positions: 0-44 45-89 90-134 135-179 ; S1 (Clear) DBL (Al+1a) S2 (Al+1b) OPEN (Al+2) ; (Other four cameras are filterless.) TABLE_INDX POLAR_QUAD tinyint unsigned, ;COR1&2:(cmdpolarposition) 0-143 Polarizer wheel commanded positions mapped ; to (x - fwz)*2.5 degrees, where fwz=0 except COR1A fwz=4 (FITS: POLAR) ; EUVI:(cmdquadposition) 0-23 quadrant selector mapped to 4 sectors (FITS: SECTOR) ; 2 8 14 20 (assuming CW motion) ; 304A 195A 284A 175A ; (HI1&2 have no polarizer) TABLE_DEFN POLAR2 tinyint unsigned, ;(cmdpolarposition_2) Commanded polarizer position for 2nd of double exposure images ; (COR only; FITS POLAR in secondary header) TABLE_DEFN EXPTIME float, ;(actualexpduration) Exposure duration (seconds) TABLE_DEFN EXPTIME2 float, ;(actualexpduration_2) Exposure duration used for 2nd of double exposure images TABLE_INDX BIASMEAN float, ;(meanbias) Bias calculated as average of 15th column of readout TABLE_DEFN BIASSDEV float, ;(stddevbias) Standard deviation of 15th column TABLE_DEFN IMGSEQ tinyint unsigned, ;(imgseq) Image sequence counter for SCIP/HI sequences TABLE_DEFN IMGCTR smallint unsigned, ;Image counter (reset every midnight) TABLE_DEFN DATE_CMD datetime, ;(cmdexptime) Date_obs - travel_time - same as filename TABLE_DEFN P1ROW smallint, ;(p1row) Readout coordinate P1 row: 1-2176 TABLE_DEFN P1COL smallint, ;(p1col) Readout coordinate P1 col: 1-2176 TABLE_DEFN P2ROW smallint, ;(p2row) Readout coordinate P2 row: 1-2176 TABLE_DEFN P2COL smallint, ;(p2col) Readout coordinate P2 col: 1-2176 TABLE_DEFN SUMROW tinyint, ;(sumrow) On-chip x summing value (FITS SUMMED, CCDSUM, IPSUM) TABLE_INDX SUMCOL tinyint, ;(sumcol) On chip y summing value (FITS SUMMED, CCDSUM, IPSUM) TABLE_INDX SEBXSUM tinyint, ;(sebxsum) Image processing x summing value (FITS SUMMED, CCDSUM, IPSUM) TABLE_DEFN SEBYSUM tinyint, ;(sebysum) Image processing y summing value (FITS SUMMED, CCDSUM, IPSUM) TABLE_INDX NAXIS1 smallint, ;Number of columns in image: 0-2176 (0=header only)(FSW n/a) TABLE_DEFN NAXIS2 smallint, ;Number of rows in image: 0-2176 (0=header only) (FSW n/a) TABLE_DEFN DOORSTAT tinyint unsigned, ;(actualdoorposition) Door position: 2=open, 0=closed, 1=in_transit, 3=off, otherwise error TABLE_INDX DATALEVEL tinyint, ;0=Level-0.5, 1=Level-1, 2= level-2, 3=level-3, ...., (FSW n/a) TABLE_INDX DOWNLINK tinyint, ;(11th char of filename) 2=RealTime, 3=RealTime from SSR1, 4=SSR1, 5=SSR2, 7=SpaceWeather from SSR, 1=GroundTest TABLE_DEFN IP_00_19 varchar(60), ;(ipcmdlog) description of image processing steps, three numeral chars per step TABLE_DEFN DISKPATH varchar(80), ;relative disk path of file: append to getenv_slash('secchi')(FSW n/a) ;Ex. "L0/a/img/euvi/20061105/" TABLE_DEFN SYNCPATH varchar(80), ;relative disk path of synced file, if any, or null: append to getenv_slash('secchi') (FSW n/a) TABLE_DEFN EVENT smallint unsigned, ;(critevent) TABLE_DEFN COSMICS int, ;Number of pixels removed by cosmic ray scrub; If NAXIS1>0, then it is the mean. TABLE_NAME IMG_SEB_HDR_EXT TABLE_AUTH nathan TABLE_DATE 2006/08/30 TABLE_VERS 5 TABLE_DESC Extended portion of image headers; header values not included in IMG_SEB_HDR table TABLE_DESC TABLE_INDX FILEORIG varchar(14), ;(filename) YMDDaaaa.APT TABLE_DEFN DATE_MOD datetime, ;Date/time (UTC) processed (FSW n/a) TABLE_INDX DATE_OBS datetime, ;(actualexptime) Date/time (UTC) command sent to expose shutter TABLE_DEFN EXPCMD float, ;(cmdexpduration) Exposure duration commanded (sec) TABLE_DEFN EXPCMD2 float, ;(cmdexpduration2) Exposure duration commanded (sec) (FITS EXPCMD in secondary header) TABLE_DEFN OFFSET smallint, ;(offset) Commanded Offset value used in camera TABLE_DEFN GAINCMD smallint, ;(gain) Commanded Gain value used in camera TABLE_DEFN GAINMODE tinyint, ;(gainmode) FPGA Mode (1=LOW or 0=HIGH) TABLE_DEFN ENCODERP tinyint, ;(actualpolarposition) actual encoder value of polarizer TABLE_DEFN ENCODERP2 tinyint, ;(actualpolarposition2) actual encoder value of polarizer for second exposure (FITS ENCODERP in secondary header) TABLE_DEFN SHUTTDIR tinyint, ;(actualshutterdirection) CCW, CW, or NONE means no shutter used TABLE_DEFN READFILE varchar(24) ;The name of file of readout tables used onboard (from pipeline), version number appended TABLE_DEFN WAVEFILE varchar(24) ;The name file of waveforms used onboard (from pipeline), version number appended TABLE_DEFN READ_TBL tinyint, ;(readouttableid) [0-7] which table in WGA_FILE used for readout TABLE_DEFN CLR_TBL tinyint, ;(clrtableid) [0-7] which table in WGA_FILE used for clear TABLE_DEFN DATE_CLR datetime, ;(actualccdclearstarttime) Date/time of start of clear table TABLE_DEFN DATE_RO datetime, ;(actualimageretrievestarttime) Date/time of start of image retrieval TABLE_DEFN READTIME float, ;(actualreadouttime) Duration of readout (sec) TABLE_DEFN IP_TIME smallint, ;(ipprocessingtime) duration of onboard processing time (sec) TABLE_DEFN COMPRSSN tinyint, ;(ipcmdlog) code indicating algorithm used for compression TABLE_DEFN COMPFACT float, ; compression factor achieved (FSW n/a) TABLE_DEFN NMISSING smallint, ; number of blocks missing (FSW n/a) TABLE_DEFN OBJECT varchar(20), ; What is supposed to be in image (FSW n/a) TABLE_DEFN CROTA float, ;Rotation angle of solar north in image (degrees) (FSW n/a) TABLE_DEFN DSUN_OBS float, ;Distance to the sun (meters) (FSW n/a) TABLE_DEFN LEDPULSE int unsigned, ;(cmdledpulses) Number of LED pulses TABLE_DEFN VERSION tinyint unsigned, ; Identifier of FSW header version TABLE_DEFN CEB_STAT tinyint unsigned, ;(cebintfstatus) CEB-Link-status (enum CAMERA_INTERFACE_STATUS) TABLE_DEFN CAM_STAT tinyint unsigned, ;(ccdintfstatus) CCD-Interface-status (enum CAMERAPROGRAM_STATE) TABLE_DEFN DATAAVG float, ;Average value of image pixels TABLE_DEFN DATASIG float, ;Standard deviation of average over image TABLE_DEFN LIGHTTRAVELOFFSETTIME int, ;light travel time offset in ms as set by IS TABLE_DEFN IMGBUFFEROFFSET tinyint, ;SDRAM image buffer slot number for image capture [0-26] TABLE_DEFN PREEXPSCSTATUS smallint unsigned, ;Spacecraft Status byte before exposure TABLE_DEFN POSTEXPSCSTATUS smallint unsigned, ;Spacecraft Status byte after exposure TABLE_DEFN ACTUALOPENTIME int, ;Raw reading from MEB of actual shutter open time (when the opening edge ofthe blade crosses the center of the CCD) source: mechanism readback TABLE_DEFN ACTUALCLOSETIME int, ;Raw reading from MEB of actual shutter close time (when the closing edge of theblade crosses the center of the CCD) source: mechanism readback TABLE_DEFN ACTUALOPENTIME_2 int, TABLE_DEFN ACTUALCLOSETIME_2 int, TABLE_DEFN ACTUALSHUTTERPOSITION tinyint, ;State of shutter during exposure open=1 closed=0 TABLE_DEFN ACTUALPOLARDIRECTION tinyint, ; polarizer or quadrant selector CW or CCW TABLE_DEFN DATASATPERC float, ; Percent of image with saturated pixels TABLE_NAME IMG_CAL_BIAS TABLE_AUTH nathan TABLE_DATE 2006/08/30 TABLE_VERS 5 TABLE_DESC Image calibration bias TABLE_INDX FILEORIG varchar(14), ;YMDDaaaa.APT (filename) TABLE_INDX DATE_MOD datetime, ;Date/time (UTC) processed (FSW n/a) TABLE_DEFN DATE_OBS datetime, ;Date/time (UTC) command sent to expose shutter (actualexptime) TABLE_DEFN BIAS float, ;Bias (under/over scan) computed from dark TABLE_DEFN BIASSTD float, ;Standard deviation TABLE_DEFN METHOD tinyint, ;Method of calculating bias (0-3): ; 0=underscan, 1=overscan, ; 2=second dark, 3=backward readout TABLE_NAME IMG_CAL_LED TABLE_AUTH nathan TABLE_DATE 2006/08/30 TABLE_VERS 5 TABLE_DESC Image calibration LED TABLE_INDX FILEORIG varchar(14), ;YMDDaaaa.APT (filename) TABLE_DEFN DATE_MOD datetime, ;Date/time (UTC) processed (FSW n/a) TABLE_INDX DATE_OBS datetime, ;Date/time (UTC) command sent to expose shutter (actualexptime) TABLE_DEFN NUM_DARK_PIX int unsigned, ;Number of dark pixels (FSW n/a) TABLE_DEFN LEDCOLOR tinyint, ;For calibration LED images (cmdledmode): ; LEDCOLOR = 1 3 2 ; EUVI: FPA-Blue Tel-Blue Tel-Purple ; COR2: Tel-Red FPA-Blue FPA-Violet ; Others: FPA-Red FPA-Blue FPA-Violet ; For non-calibration LED images: LEDCOLOR = 0 (None) TABLE_DEFN LEDPULSE int unsigned, ;Number of LED pulses (cmdledpulses) TABLE_NAME IMG_CAL_DARK TABLE_AUTH nathan TABLE_DATE 2006/08/30 TABLE_VERS 5 TABLE_DESC Image calibration dark TABLE_INDX FILEORIG varchar(14), ;YMDDaaaa.APT (filename) TABLE_DEFN DATE_MOD datetime, ;Date/time (UTC) processed (FSW n/a) TABLE_INDX DATE_OBS datetime, ;Date/time (UTC) command sent to expose shutter (actualexptime) TABLE_DEFN EXPTIME float, ;Exposure duration (seconds) (actualexpduration) TABLE_DEFN DARK_CURRENT float, ;Dark current (DN/sec) (FSW n/a) TABLE_DEFN NUM_HOT_PIX int, ;Number of hot pixels (FSW n/a) TABLE_NAME IMG_HIST_CMNT TABLE_AUTH nathan TABLE_DATE 2006/08/30 TABLE_VERS 5 TABLE_DESC Image Comment/History Information TABLE_INDX FILENAME char(25), ;yyyymmdd_hhmmss_LATTS.fts (FSW n/a) where TABLE_INDX DATE_MOD datetime, ;Date/time (UTC) processed TABLE_INDX DATE_OBS datetime, ;Date/time (UTC/ECS) command sent to expose shutter TABLE_DEFN FLAG varchar(7), ;'comment' = entry is a comment ;'history' = entry is a history TABLE_DEFN INFO varchar(80), ;comment/history text TABLE_NAME IMG_EUVI_GT TABLE_AUTH nathan TABLE_DATE 2006/08/30 TABLE_VERS 5 TABLE_DESC EUVI GT data (extended header) TABLE_INDX FILEORIG varchar(14), ;(filename) YMDDaaaa.APT TABLE_DESC DATE_MOD datetime, ;Date/time (UTC) processed (FSW n/a) TABLE_INDX DATE_OBS datetime, ;(actualexptime) Date/time (UTC) command sent to expose shutter TABLE_DEFN FPS_CMD tinyint, ; (useFPS) TABLE_DEFN FPS_ON tinyint, ; (actualFPSmode) TABLE_DEFN ENCODERF tinyint unsigned, ; actual encoder value of filter wheel (actualfilterposition) TABLE_DEFN ENCODERQ tinyint, ;Quadrant selector encoder value (actualpolarposition) TABLE_DEFN ACTUALFILTERDIRECTION tinyint, TABLE_DEFN ACTUALSCFINEPOINTMODE tinyint, TABLE_DEFN FPSOFFY smallint, ;YOFFSET TABLE_DEFN FPSOFFZ smallint, ;ZOFFSET TABLE_DEFN SPARE1 smallint unsigned, TABLE_DEFN FPSNUMS int unsigned, ;NUMFPSSAMPLES TABLE_DEFN FPSGTSY int, ;FPSYSUM TABLE_DEFN FPSGTSZ int, ;FPSZSUM TABLE_DEFN FPSGTQY int, ;FPSYSQUARE TABLE_DEFN FPSGTQZ int, ;FPSZSQUARE TABLE_DEFN FPSERS1 int, ;PZTERRSUM1 TABLE_DEFN FPSERS2 int, ;PZTERRSUM2 TABLE_DEFN FPSERS3 int, ;PZTERRSUM3 TABLE_DEFN FPSERQ1 int, ;PZTERRSQUARE1 TABLE_DEFN FPSERQ2 int, ;PZTERRSQUARE2 TABLE_DEFN FPSERQ3 int, ;PZTERRSQUARE3 TABLE_DEFN FPSDAS1 int, ;PZTDACSUM1 TABLE_DEFN FPSDAS2 int, ;PZTDACSUM2 TABLE_DEFN FPSDAS3 int, ;PZTDACSUM3 TABLE_DEFN FPSDAQ1 int, ;PZTDACSQUARE1 TABLE_DEFN FPSDAQ2 int, ;PZTDACSQUARE2 TABLE_DEFN FPSDAQ3 int, ;PZTDACSQUARE3 TABLE_DEFN SPARE2 smallint unsigned, TABLE_DEFN PZT1YCOORDXFORM smallint, TABLE_DEFN PZT2YCOORDXFORM smallint, TABLE_DEFN PZT3YCOORDXFORM smallint, TABLE_DEFN PZT1ZCOORDXFORM smallint, TABLE_DEFN PZT2ZCOORDXFORM smallint, TABLE_DEFN PZT3ZCOORDXFORM smallint, TABLE_DEFN PZT1VOLTPREDICT0 smallint, TABLE_DEFN PZT1VOLTPREDICT1 smallint, TABLE_DEFN PZT1VOLTPREDICT2 smallint, TABLE_DEFN PZT1VOLTPREDICT3 smallint, TABLE_DEFN PZT1VOLTPREDICT4 smallint, TABLE_DEFN PZT2VOLTPREDICT0 smallint, TABLE_DEFN PZT2VOLTPREDICT1 smallint, TABLE_DEFN PZT2VOLTPREDICT2 smallint, TABLE_DEFN PZT2VOLTPREDICT3 smallint, TABLE_DEFN PZT2VOLTPREDICT4 smallint, TABLE_DEFN PZT3VOLTPREDICT0 smallint, TABLE_DEFN PZT3VOLTPREDICT1 smallint, TABLE_DEFN PZT3VOLTPREDICT2 smallint, TABLE_DEFN PZT3VOLTPREDICT3 smallint, TABLE_DEFN PZT3VOLTPREDICT4 smallint, TABLE_DEFN PZT1PIDCOE0 smallint TABLE_DEFN PZT1PIDCOE1 smallint, TABLE_DEFN PZT1PIDCOE2 smallint, TABLE_DEFN PZT1PIDCOE3 smallint, TABLE_DEFN PZT2PIDCOE0 smallint TABLE_DEFN PZT2PIDCOE1 smallint, TABLE_DEFN PZT2PIDCOE2 smallint, TABLE_DEFN PZT2PIDCOE3 smallint, TABLE_DEFN PZT3PIDCOE0 smallint TABLE_DEFN PZT3PIDCOE1 smallint, TABLE_DEFN PZT3PIDCOE2 smallint, TABLE_DEFN PZT3PIDCOE3 smallint,