SECCHI Image Database Definition
SECCHI Image Database Definitions
;$Id: secchi_img_tables_def.html,v 1.9 2007/06/18 16:48:07 nathan Exp $
For databases SECCHI and SECCHI_FLIGHT
;
;$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,