[INSTRM-1311] Add a table of distortion parameters for sanity check Created: 30/Jun/21 Updated: 15/Oct/21 Resolved: 09/Sep/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: | EngRun, opDB | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Story Points: | 1 | ||||||||
| Sprint: | EngRun03 | ||||||||
| Description |
|
To check the coordinate system and transformation, a new table (`camera_model_f3c_mcs`) to store some distortion parameters is needed. In addition to `mcs_frame_id`, the table includes columns of `matrix`, `distor`, `rot_vector`, & `tran_vector`, all of which need to be array types. |
| Comments |
| Comment by Kiyoto Yabe [ 30/Jun/21 ] |
|
fix pushed Table "public.camera_model_f3c_mcs" Column | Type | Collation | Nullable | Default --------------+---------+-----------+----------+--------- mcs_frame_id | integer | | not null | matrix | real[] | | | distor | real[] | | | rot_vector | real[] | | | tran_vector | real[] | | | Indexes: "camera_model_f3c_mcs_pkey" PRIMARY KEY, btree (mcs_frame_id) Foreign-key constraints: "camera_model_f3c_mcs_mcs_frame_id_fkey" FOREIGN KEY (mcs_frame_id) REFERENCES mcs_exposure(mcs_frame_id) |
| Comment by cloomis [ 01/Jul/21 ] |
|
Is this a use of SQL99 ARRAYs? Or is that some clever sqlalchemy construction? |
| Comment by Kiyoto Yabe [ 01/Jul/21 ] |
|
SQL ARRAY https://docs.sqlalchemy.org/en/14/core/type_basics.html#sqlalchemy.types.ARRAY |
| Comment by Kiyoto Yabe [ 26/Aug/21 ] |
|
The table is already there, and I'll close this ticket once I confirm the table can be populated properly. |
| Comment by hassan [ 08/Sep/21 ] |
|
Kiyoto Yabe: did you check the table population? Can this ticket be closed now? |
| Comment by Kiyoto Yabe [ 08/Sep/21 ] |
|
No population of the table yet, so cannot close the ticket now. |