| 28 | | * Finished remaining development work for stack batches: |
| 29 | | * questions about how to populate PSPS flux columns: Jim and Gene settled on a solution and I implemented it in code |
| 30 | | * numerous schema changes |
| 31 | | * work on GPC1 queries to list available stacks, get contributing OTAs for each |
| 32 | | * new temp Db table to store meta data from DVO, eg flags, photcode etc |
| 33 | | * redesigned ippToPsps database to keep track of batch types, processing, whether they are loaded or merged etc |
| 34 | | * fixed issue of !NaNs in fits headers not writing to database |
| 35 | | * changes to lots of SQL due to Heather's changes in gpc1 addRun table |
| 36 | | * now performing clean-up in Db before export to FITS, i.e. removing NULL objIDs, NULL fluxes etc |
| | 28 | * Finished remaining development work for stack batches: |
| | 29 | * questions about how to populate PSPS flux columns: Jim and Gene settled on a solution and I implemented it in code |
| | 30 | * numerous schema changes |
| | 31 | * work on GPC1 queries to list available stacks, get contributing OTAs for each |
| | 32 | * new temp Db table to store meta data from DVO, eg flags, photcode etc |
| | 33 | * redesigned ippToPsps database to keep track of batch types, processing, whether they are loaded or merged etc |
| | 34 | * fixed issue of !NaNs in fits headers not writing to database |
| | 35 | * changes to lots of SQL due to Heather's changes in gpc1 addRun table |
| | 36 | * now performing clean-up in Db before export to FITS, i.e. removing NULL objIDs, NULL fluxes etc |
| 38 | | * Successfully tested loading and merging of new stack batches. Problems encountered: |
| 39 | | * missing tables: !SkinnyObject, !ObjectCalColor in stack batches. Added these to code. |
| 40 | | * NULLs sneaking in to new 'updated' column in Object table: we had forgotten to add a default. Changed schema |
| 41 | | * crazy -999 "NULL"s don't fit in byte field and so broke load. Fixed |
| 42 | | * merge stage was expecting all contributing images for the stack to be loaded already. Sue fixed this. |
| | 38 | * Successfully tested loading and merging of new stack batches. Problems encountered: |
| | 39 | * missing tables: !SkinnyObject, !ObjectCalColor in stack batches. Added these to code. |
| | 40 | * NULLs sneaking in to new 'updated' column in Object table: we had forgotten to add a default. Changed schema |
| | 41 | * crazy -999 "NULL"s don't fit in byte field and so broke load. Fixed |
| | 42 | * merge stage was expecting all contributing images for the stack to be loaded already. Sue fixed this. |
