[INSTRM-1240] Add a table for the cordinate transformation between MCS and PFI Created: 15/Apr/21 Updated: 14/May/21 Resolved: 14/May/21 |
|
| Status: | Done |
| Project: | Instrument control development |
| Component/s: | spt_operational_database |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Normal |
| Reporter: | Kiyoto Yabe | Assignee: | Kiyoto Yabe |
| Resolution: | Done | Votes: | 0 |
| Labels: | opDB | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
As a separate table from `cobra_match`, we need to store information on the coordinate transformation from MCS pix to PFI mm based on the fiducial fiber measurement. Depending on the functional form, we need to keep some coefficients, which will be discussed in this ticket as well as other required columns. |
| Comments |
| Comment by Kiyoto Yabe [ 16/Apr/21 ] |
|
My initial proposal is to add `mcs_pfi_transformation` table linking with `mcs_exposure.mcs_frame_id`. I'm not sure what coefficients we need, so they are completely placeholders. Any comments are welcome. > chyan karr cloomis hassan class mcs_pfi_transformation(Base): ''' The MCS-PFI coordinate transformation including coefficients ''' __tablename__ = 'mcs_pfi_transformation' mcs_frame_id = Column(Integer, ForeignKey('mcs_exposure.mcs_frame_id'), primary_key=True, unique=True, autoincrement=False, comment='MCS frame identifier as generated from Gen2') c0 = Column(REAL, comment='coefficient 0') c1 = Column(REAL, comment='coefficient 1') c2 = Column(REAL, comment='coefficient 2') def __init__(self, mcs_frame_id, c0, c1, c2 ): self.mcs_frame_id = mcs_frame_id self.c0 = c0 self.c1 = c1 self.c2 = c2 |
| Comment by hassan [ 16/Apr/21 ] |
|
So if we were to do an affine transformation between the two coordinate systems, you would store the full 9 coefficients for the 3x3 matrix this way, correct? |