[INSTRM-815] Provide additional opDB columns from FITS headers Created: 16/Nov/19  Updated: 19/Dec/19  Resolved: 16/Dec/19

Status: Done
Project: Instrument control development
Component/s: spt_operational_database
Affects Version/s: None
Fix Version/s: None

Type: Story Priority: Normal
Reporter: hassan Assignee: karr
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Blocks
blocks INSTRM-751 Update mcsexposure schema with all te... Done
Story Points: 1

 Description   

In relation to INSTRM-751, provide a list of additional columns needed in the opDB mcs_exposure table in order to run the MCS analysis code using the opDB only - that is, without needing to rely on reading any FITS headers.



 Comments   
Comment by karr [ 13/Dec/19 ]

List of FITS header keywords that I use in my analysis, or that we varied as part of the engineering runs, 

exptime
altitude
inr-str
adc-str 
dom-tmp
dom-prs
dom-hum
out-tmp
out-prs
out-hum
date-obs
hst
w_mccovt
w_mcm1t

 

Comment by Kiyoto Yabe [ 13/Dec/19 ]

Do you like the exactly same names for the database column as those here?

Comment by karr [ 13/Dec/19 ]

 

We should probably use the same format as the other variables (ie, out_tmp instead of out-tmp). The current ones would work, or if we went them to be more descriptive, we could use something like the following. 

exptime
altitude
instrument_rotation
adc_pa
dome_temperature
dome_pressure
dome_humidity
outside_temperature
outside_pressure
outside_humidity
date_observed
hst
coverpanel_temperature
mainmirror_temperature

Comment by Kiyoto Yabe [ 14/Dec/19 ]

OK, thank you. I will propose something and ask you to confirm.

Comment by Kiyoto Yabe [ 19/Dec/19 ]

Hi karr & chyan

I changed the column names of mcs_exposure more descriptively like this:

  • mcs_frame_id = Column(Integer, primary_key=True, unique=True, index=True, autoincrement=False, comment='MCS frame identifier as generated from Gen2')
  • pfs_visit_id = Column(Integer, ForeignKey('pfs_visit.pfs_visit_id'))
  • mcs_exptime = Column(REAL, comment='The exposure time for the frame [sec]')
  • altitude = Column(REAL, comment='The telescope attitude [deg]')
  • azimuth = Column(REAL, comment='The telescope azimuth [deg]')
  • insrot = Column(REAL, comment='The telescope instrument rotation angle [deg]')
  • adc_pa = Column(REAL, comment='ADC PA at which the exposure started [deg]')
  • dome_temperature = Column(REAL, comment='Dome temperature [K]')
  • dome_pressure = Column(REAL, comment='Dome pressure [hPa]')
  • dome_humidity = Column(REAL, comment='Dome humidity [%]')
  • outside_temperature = Column(REAL, comment='Outside temperature [K]')
  • outside_pressure = Column(REAL, comment='Outside pressure [hPa]')
  • outside_humidity = Column(REAL, comment='Outside humidity [%]')
  • mcs_cover_temperature = Column(REAL, comment='MCS cover panel temperature [degC]')
  • mcs_m1_temperature = Column(REAL, comment='MCS primary mirror temperature [degC]')
  • taken_at = Column(DateTime, comment='The time at which the exposure was taken [YYYY-MM-DDThh-mm-sss]')
  • taken_in_hst_at = Column(DateTime, comment='The time (in HST) at which the exposure was taken [YYYY-MM-DDThh-mm-sss]')

 

Is this all fine with you?

 

Generated at Sat Feb 10 16:28:55 JST 2024 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.