The missing (or desired) fields are denoted by # FIXME
in the generation script for ObsCore data for images:
Here're the FIXME line items:
r["target_name"] = ? # FIXME: to be scheduler field ID
r["obs_id"] = ? # FIXME: to be online OBSID
r["s_fov"] = ? # FIXME: fov - the diameter of a circle around s_ra, s_dec
For reference on the above fields, see Gregory Dubois-Felsmann's notes: https://confluence.lsstcorp.org/pages/viewpage.action?spaceKey=~gpdf&title=Satisfying+ObsCore+from+the+Gen3+Butler+Schema
As of now, the script succeeded in fetching all the other fields from the ci_hsc test dataset without loading the Exposure object of the corresponding FITS file into memory, taking about ~1 min (on my low-end PC) to process and generate 68 rows of ObsCore data.
FYI, the generated CVS raw output has been attached here as reference. This raw CVS output is to be combined with SQL DDL and DML scripts to insert the data into a local PostgreSQL database, which has been done with success, albeit using psql tool.
DM-24575 is now in review – I added science program and target name (as well as ra/dec).
Tim Jenness FYI, I've been running/debugging the script on the HSC RC2 datasets on the verification cluster. Will let you know if I run into anything.
Kenny has now transitioned off the DAX team. Any further work beyond current state on this will be separately ticketed and staffed by the SQuaRE team.
Kenny Lo you've tagged this ticket as ImgServ and data access team and written it as if this is to implement fixes in ImgServ. What I'm going to do is implement the fix for target name on
DM-24575and leave this ticket for you for handling the change (and as we have discussed field-of-view is not directly a registry problem).