Detection Batches
The input for the detection batch is one IPP camera-stage smf file for a given exposure, as well as an associated DVO database from which to retrieve object, and other, IDs. One FITS file is generated for each exposure.
PSPS tables
1 Primary extension
1 FrameMeta extension
1 ImageMeta extension per chip
1 Detection extension per chip
1 SkinnyObject extension per chip
1 ObjectCalColor extension per chip
The full table definitions can be seen here
The 'object ID' is featured in the last three tables, and must remain unique across the exposure (it is generated within DVO). In the merged PSPS database, the primary key on the detections table is both the object ID and detection ID, meaning the the same object can appear in multiple, overlapping exposures as they will have different detection IDs.
Current IPP to PSPS mappings
The following table details the current mapping between IPP and PSPS. The source of smf files queued by ippToPsps is a list of cam_ids that are loaded into the relevant DVO database. These cam_ids are then used to obtain metadata from the IPP GPC1 database, as well as the location of the smfs themselves.
| FrameMeta | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| frameID | dimensionless | INT | 0 | unique exposure/frame identifier. | GPC1 database | SELECT exp_id FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id |
| frameName | dimensionless | VARCHAR(32) | frame name provided by camera software | GPC1 database | SELECT exp_name FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id | |
| surveyID | dimensionless | TINYINT | 0 | survey flag identifier | GPC1 database | SELECT camRun.dist_group FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id. The IPP dist_group is then used to get the surveyID from the PSPS 'Survey' table here |
| filterID | dimensionless | TINYINT | 0 | filter identifier | smf primary header | Single character filter (grizy) is used to get PSPS ID from Filter table here |
| cameraID | dimensionless | SMALLINT | 0 | camera identifier | NA | hardcoded to 1 |
| cameraConfigID | dimensionless | SMALLINT | 0 | camera configuration identifier | NA | hardcoded to 1 |
| telescopeID | dimensionless | SMALLINT | 0 | telescope identifier | NA | hardcoded to 1 |
| analysisVer | alphanumeric | VARCHAR(MAX) | IPP software analysis release | GPC1 database | camRun.software_ver for this cam_id | |
| p1Recip | alphanumeric | VARCHAR(MAX) | IPP phase 1 MD5 Checksum | NA | empty | |
| p2Recip | alphanumeric | VARCHAR(MAX) | IPP phase 2 MD5 Checksum | NA | empty | |
| p3Recip | alphanumeric | VARCHAR(MAX) | IPP phase 3 MD5 Checksum | NA | empty | |
| nOTA | dimensionless | SMALLINT | -999 | number of valid OTA/CCD images in this exposure | smf file | count of psf extensions successfully read from the smf file |
| photoScat | magnitudes | REAL | -999 | global photometric scatter | smf primary header | ZPT_ERR |
| numPhotoRef | dimensionless | INT | -999 | number of photometric reference sources | smf XYnn.hdr extensions | sum of NASTRO over all OTAs |
| expStart | days | FLOAT | -999 | exposure start time in MJD | smf primary header | MJD-OBS |
| expTime | seconds | REAL | -999 | exposure time | smf primary header | EXPREQ |
| airmass | dimensionless | REAL | -999 | airmass at mid-exposure (check - might be at start) | smf primary header | AIRMASS |
| raBore | degrees | FLOAT | -999 | RA of telescope boresight - in future this needs work | smf primary header | RA |
| decBore | degrees | FLOAT | -999 | DEC of telescope boresight | smf primary header | DEC |
| ctype1 | alphanumeric | VARCHAR(MAX) | name of astrometric projection in RA | smf primary header | CTYPE1 | |
| ctype2 | alphanumeric | VARCHAR(MAX) | name of astrometric projection in DEC | smf primary header | CTYPE2 | |
| crval1 | degrees | FLOAT | -999 | RA corresponding to reference pixel | smf primary header | CRVAL1 |
| crval2 | degrees | FLOAT | -999 | DEC corresponding to reference pixel | smf primary header | CRVAL2 |
| crpix1 | dimensionless | FLOAT | -999 | reference pixel value for RA | smf primary header | CRPIX1 |
| crpix2 | dimensionless | FLOAT | -999 | reference pixel value for DEC | smf primary header | CRPIX2 |
| cdelt1 | degrees/pixel | FLOAT | -999 | scale factor for RA | smf primary header | CDELT1 |
| cdelt2 | degrees/pixel | FLOAT | -999 | scale factor for DEC | smf primary header | CDELT2 |
| pc001001 | dimensionless | FLOAT | -999 | elements of rotation/Dcale matrix | smf primary header | PC001001 |
| pc001002 | dimensionless | FLOAT | -999 | elements of rotation/Dcale matrix | smf primary header | PC001002 |
| pc002001 | dimensionless | FLOAT | -999 | elements of rotation/Dcale matrix | smf primary header | PC002001 |
| pc002002 | dimensionless | FLOAT | -999 | elements of rotation/Dcale matrix | smf primary header | PC002002 |
| polyOrder | dimensionless | TINYINT | 255 | polynomial order of astrometry fit | smf primary header | NPLYTERM |
| pca1x3y0 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA1X3Y0 |
| pca1x2y1 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA1X2Y1 |
| pca1x1y2 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA1X1Y2 |
| pca1x0y3 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA1X0Y3 |
| pca1x2y0 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA1X2Y0 |
| pca1x1y1 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA1X1Y1 |
| pca1x0y2 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA1X0Y2 |
| pca2x3y0 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA2X3Y0 |
| pca2x2y1 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA2X2Y1 |
| pca2x1y2 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA2X1Y2 |
| pca2x0y3 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA2X0Y3 |
| pca2x2y0 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA2X2Y0 |
| pca2x1y1 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA2X1Y1 |
| pca2x0y2 | dimensionless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf primary header | PCA2X0Y2 |
| calibModNum | dimensionless | SMALLINT | 0 | calibration modification number | NA | hardcoded to 1 |
| batchID | dimensionless | INT32 | 0 | batchID | NA | hardcoded to 1 |
| dataRelease | dimensionless | TINYINT | 0 | Data release version number | NA | hardcoded to 1 |
| ImageMeta | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| imageID | dimensionless | BIGINT | 0 | unique ID for each image, hashed from frameID and ccdID (ALEX) | GPC1 and smf extension name | frameID (below) mashed together with OTA number |
| frameID | dimensionless | INT | 0 | frame identifier, also known as exposure number | GPC1 database | SELECT exp_id FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id |
| ccdID | dimensionless | SMALLINT | 0 | ccd cell identifier in the focal plane | smf | OTA number |
| photoCalID | dimensionless | INT | 0 | photometry reduction code identifier | DVO | image->photcode from DVO Image structure |
| filterID | dimensionless | TINYINT | 0 | filter ID | smf primary header | same as for FrameMeta (see above) |
| bias | ADU | REAL | -999 | detector bias level | GPC1 database | rawExp.bg |
| biasScat | ADU | REAL | -999 | scatter in bias level | GPC1 database | rawExp.bg_stdev |
| sky | ADU/pixel | REAL | -999 | mean sky level | smf XYnn.hdr extension | MSKY_MN |
| skyScat | ADU/pixel | REAL | -999 | scatter in mean sky level | smf XYnn.hdr extension | MSKY_SIG |
| nDetect | dimensionless | INT | -999 | number of detections on CCD | smf XYnn.psf extension | count of detections retrieved from the psf extension |
| magSat | magnitude | REAL | -999 | saturation magnitude level | smf XYnn.hdr extension | FSATUR |
| completMag | magnitude | REAL | -999 | 95% completion level in mag | smf XYnn.hdr extension | FLIMIT |
| astroScat | arcsec | REAL | -999 | astrometric scatter for chip | smf XYnn.hdr extension | CERROR |
| photoScat | magnitude | REAL | -999 | photometric scatter for chip | smf primary header | ZPT_OBS |
| numAstroRef | dimensionless | INT | -999 | number of astrometric reference sources | smf XYnn.hdr extension | NASTRO |
| numPhotoRef | dimensionless | INT | -999 | number of photometric reference sources | smf XYnn.hdr extension | NASTRO |
| nx | pixels | SMALLINT | -999 | chip dimension in x | smf XYnn.hdr extension | CNAXIS1 |
| ny | pixels | SMALLINT | -999 | chip dimension in y | smf XYnn.hdr extension | CNAXIS2 |
| psfModelID | dimensionless | INT | -999 | PSF model identifier | NA | empty CZW: Available from config as PSF_MODEL = PS_MODEL_PS1_V1 |
| psfFwhm | raw pixels | REAL | -999 | model psf full width at half maximum at chip center - raw pixels are approx 0.256 arcsec | smf XYnn.hdr extension | (FWHM_MAJ + FWHM_MIN) / 2.0 |
| psfWidMajor | raw pixels | REAL | -999 | model PSF parameters at chip center | smf XYnn.hdr extension | FWHM_MAJ |
| psfWidMinor | raw pixels | REAL | -999 | model PSF parameters at chip center | smf XYnn.hdr extension | FWHM_MIN |
| psfTheta | degrees | REAL | -999 | model PSF parameters at chip center | smf XYnn.hdr extension | ANGLE |
| momentFwhm | raw pixels | REAL | -999 | average PSF full width at half maximum from moments | smf XYnn.hdr extension | (IQ_FW1 + IQ_FW2) / 2.0 |
| momentWidMajor | raw pixels | REAL | -999 | average PSF parameters from moments | smf XYnn.hdr extension | IQ_FW1 |
| momentWidMinor | raw pixels | REAL | -999 | average PSF parameters from moments | smf XYnn.hdr extension | IQ_FW2 |
| apResid | magnitudes | REAL | -999 | corrected aperture residual | smf XYnn.hdr extension | APMIFIT |
| dapResid | magnitudes | REAL | -999 | scatter of aperture corrections | smf XYnn.hdr extension | DAPMIFIT |
| detectorID | alphnumeric | VARCHAR(32) | identifier for actual CCD chip | smf XYnn.hdr extension | DETECTOR | |
| qaFlags | dimensionless | BIGINT | -999 | Q/A flags for this OTA | DVO | image->flags from DVO Image structure |
| detrend1 | alphanumeric | VARCHAR(MAX) | identifier of detrend image 1 | smf XYnn.hdr extension | DETREND.MASK | |
| detrend2 | alphanumeric | VARCHAR(MAX) | identifier of detrend image 2 | smf XYnn.hdr extension | DETREND.DARK | |
| detrend3 | alphanumeric | VARCHAR(MAX) | identifier of detrend image 3 | smf XYnn.hdr extension | DETREND.FLAT | |
| detrend4 | alphanumeric | VARCHAR(MAX) | identifier of detrend image 4 | NA | empty CZW: can we add DETREND.FRINGE | |
| detrend5 | alphanumeric | VARCHAR(MAX) | identifier of detrend image 5 | NA | empty CZW: can we add DETREND.LINEARITY | |
| detrend6 | alphanumeric | VARCHAR(MAX) | identifier of detrend image 6 | NA | empty | |
| detrend7 | alphanumeric | VARCHAR(MAX) | identifier of detrend image 7 | NA | empty | |
| detrend8 | alphanumeric | VARCHAR(MAX) | identifier of detrend image 8 | NA | empty | |
| photoZero | magnitude | REAL | -999 | local derived photometric zero point | smf primary header | ZPT_OBS |
| ctype1 | alphanumeric | VARCHAR(MAX) | name of astrometric projection in RA | smf XYnn.hdr extension | CTYPE1 | |
| ctype2 | alphanumeric | VARCHAR(MAX) | name of astrometric projection in DEC | smf XYnn.hdr extension | CTYPE2 | |
| crval1 | degrees | FLOAT | -999 | RA corresponding to reference pixel | smf XYnn.hdr extension | CRVAL1 |
| crval2 | degrees | FLOAT | -999 | DEC corresponding to reference pixel | smf XYnn.hdr extension | CRVAL2 |
| crpix1 | pixels | FLOAT | -999 | reference pixel value for RA | smf XYnn.hdr extension | CRPIX1 |
| crpix2 | pixels | FLOAT | -999 | reference pixel value for DEC | smf XYnn.hdr extension | CRPIX2 |
| cdelt1 | degrees/pixel | FLOAT | -999 | scale factor for RA | smf XYnn.hdr extension | CDELT1 |
| cdelt2 | degrees/pixel | FLOAT | -999 | scale factor for DEC | smf XYnn.hdr extension | CDELT2 |
| pc001001 | dimensionsless | FLOAT | -999 | elements of rotation/Dcale matrix | smf XYnn.hdr extension | PC001001 |
| pc001002 | dimensionsless | FLOAT | -999 | elements of rotation/Dcale matrix | smf XYnn.hdr extension | PC001002 |
| pc002001 | dimensionsless | FLOAT | -999 | elements of rotation/Dcale matrix | smf XYnn.hdr extension | PC002001 |
| pc002002 | dimensionsless | FLOAT | -999 | elements of rotation/Dcale matrix | smf XYnn.hdr extension | PC002002 |
| polyOrder | dimensionless - ditto | TINYINT | 255 | polynomial order of astrometry fit | smf XYnn.hdr extension | NPLYTERM |
| pca1x3y0 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA1X3Y0 |
| pca1x2y1 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA1X2Y1 |
| pca1x1y2 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA1X1Y2 |
| pca1x0y3 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA1X0Y3 |
| pca1x2y0 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA1X2Y0 |
| pca1x1y1 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA1X1Y1 |
| pca1x0y2 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA1X0Y2 |
| pca2x3y0 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA2X3Y0 |
| pca2x2y1 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA2X2Y1 |
| pca2x1y2 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA2X1Y2 |
| pca2x0y3 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA2X0Y3 |
| pca2x2y0 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA2X2Y0 |
| pca2x1y1 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA2X1Y1 |
| pca2x0y2 | dimensionsless | FLOAT | -999 | polynomial coefficients for the astrometric fit | smf XYnn.hdr extension | PCA2X0Y2 |
| calibModNum | dimensionless | SMALLINT | 0 | calibration modification number | NA | hardcoded to 1 |
| dataRelease | dimensionless | TINYINT | 0 | Data release | NA | hardcoded to 1 |
| Detection | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| objID | dimensionless | BIGINT | 0 | ODM object identifier | DVO | ave.extID from dvoDetection structure |
| detectID | dimensionless | BIGINT | 0 | ODM detection identifier | DVO | meas.extID from dvoDetection structure |
| ippObjID | dimensionless | BIGINT | 0 | object id generated by IPP | DVO | ave.catID*1000000000 + ave.objID from dvoDetection structure |
| ippDetectID | dimensionless | BIGINT | 0 | detection id generated by IPP | smf XYnn.psf extension | IPP_IDET |
| filterID | dimensionless | TINYINT | 0 | filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ... | smf primary header | same as for FrameMeta (see above) |
| surveyID | dimensionless | TINYINT | 0 | survey flag identifier | GPC1 | same as for FrameMeta (see above) |
| imageID | dimensionless | BIGINT | 0 | image id hash of frame identifier & OTA/CCD number | GPC1 and smf extension name | same as for ImageMeta (see above) |
| obsTime | Mean Julian Days | FLOAT | -999 | Time of mid observation | smf primary header | (MJD-OBS + EXPTIME) / 172800.0 |
| xPos | raw pixels | REAL | -999 | measured x on CCD from PSF fit | smf XYnn.psf extension | X_PSF |
| yPos | raw pixels | REAL | -999 | measured y on CCD from PSF fit | smf XYnn.psf extension | Y_PSF |
| xPosErr | raw pixels | REAL | -999 | estimated error in x | smf XYnn.psf extension | X_PSF_SIG |
| yPosErr | raw pixels | REAL | -999 | estimated error in y | smf XYnn.psf extension | Y_PSF_SIG |
| psfFlux | adu/sec | REAL | -999 | PSF instrumental flux (in analog-to-digital units/sec) or adu/sec | smf primary header (EXPTIME) and XYnn.psf extension | POW(10.0, (-0.4*PSF_INST_MAG)) / EXPTIME |
| psfFluxErr | adu/sec | REAL | -999 | estimated error in flux | smf primary header (EXPTIME) and XYnn.psf extension | ABS((PSF_INST_MAG_SIG*(POW(10.0, (-0.4*PSF_INST_MAG)) / EXPTIME)) / 1.085736) |
| peakADU | adu | REAL | -999 | peak count in source pixel - where counts are anlog-to-digital units | smf primary header (EXPTIME) and XYnn.psf extension | POW(10.0, (-0.4*PEAK_FLUX_AS_MAG)) / EXPTIME |
| psfWidMajor | raw pixels | REAL | -999 | model PSF width in major axis | smf XYnn.psf extension | PSF_MAJOR |
| psfWidMinor | raw pixels | REAL | -999 | model PSF width in minor axis | smf XYnn.psf extension | PSF_MINOR |
| psfTheta | degrees East of North | REAL | -999 | model PSF orientation angle | smf XYnn.psf extension | PSF_THETA |
| psfLikelihood | dimensionless | REAL | -999 | PSF likelihood | smf XYnn.psf extension | |
| psfQf | none | REAL | -999 | PSF coverage factor | smf XYnn.psf extension | PSF_QF |
| momentXX | raw pixels | REAL | -999 | moment XX | smf XYnn.psf extension | MOMENTS_XX |
| momentXY | raw pixels | REAL | -999 | moment XY | smf XYnn.psf extension | MOMENTS_XY |
| momentYY | raw pixels | REAL | -999 | momeny YY | smf XYnn.psf extension | MOMENTS_YY |
| apFlux | adu/sec | REAL | -999 | Aperture Flux | smf XYnn.psf extension | AP_MAG (converted to flux) |
| apFluxErr | adu/sec | REAL | -999 | Aperture magnitude error | NA | empty |
| kronFlux | adu/sec | REAL | -999 | Kron flux | smf XYnn.psf extension | KRON_FLUX / expTime convert to adu/s |
| kronFluxErr | adu/sec | REAL | -999 | Kron flux error | smf XYnn.psf extension | KRON_FLUX_ERR / expTime convert to adu/s |
| kronRad | raw pixels | REAL | -999 | Kron radius | NA | empty |
| kronRadErr | raw pixels | REAL | -999 | Kron radius error | NA | empty |
| psfQfPerfect | dimensionless | REAL | -999 | smf XYnn.psf extension | | |
| psfChiSq | dimensionless | REAL | -999 | smf XYnn.psf extension | | |
| infoFlag | none | BIGINT | -999 | flag indicating provenance information | smf XYnn.psf extension and DVO | dvoDetection.meas.dbFlags << 46| FLAGS2 <<32 | FLAGS |
| sky | adu/sec/pixel | REAL | -999 | PSF sky level at source | smf XYnn.psf extension | SKY |
| skyErr | adu/sec/pixel | REAL | -999 | estimated error in sky | smf XYnn.psf extension | SKY_SIGMA |
| sgSep | dimensionless | REAL | -999 | star/galaxy separator | | |
| activeFlag | dimensionless | TINYINT | -999 | indicates whether this detection/orphan is still a detection/orphan | NA | hardcoded to 0 |
| assocDate | dimensionless | DATE | 28881231 | date object association assigned | NA | date that batch has been prepared |
| historyModNum | dimensionless | SMALLINT | 0 | modification number in the O-D association history | NA | hardcoded to 0 |
| dataRelease | dimensionless | TINYINT | 0 | Data release when this detection was originally taken. Recalibrations do not affect this value. | NA | hardcoded to 0 |
| SkinnyObject | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| objID | unknown | BIGINT | 0 | ODM object identifier index | DVO | same as Detection table - see above |
| ippObjID | unknown | BIGINT | 0 | IPP object number | DVO | same as Detection table - see above |
| projectionCellID | unknown | INT | -999 | projection cell identifier at discovery time | NA | empty CZW: the skycell_id contains this |
| dataRelease | unknown | TINYINT | 0 | Data release to propagate to the object | NA | hardcoded to 0 |
| surveyID | unknown | TINYINT | 255 | surveyID | GPC1 | same as for FrameMeta (see above) |
| ObjectCalColor | ||||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| objID | unknown | BIGINT | 0 | ODM object identifier | DVO | same as Detection table - see above |
| ippObjID | unknown | BIGINT | 0 | ipp object identifier | DVO | same as Detection table - see above |
| filterID | unknown | TINYINT | 0 | filter identifier | smf primary header | same as for FrameMeta (see above) |
| calColor | mag | REAL | 0 | | NA | empty |
| calColorErr | mag | REAL | 0 | | NA | empty |
| calibModNum | unknown | SMALLINT | 0 | calibration modification number | NA | hardcoded to 1 |
| dataRelease | unknown | TINYINT | 0 | Data release when this color calibration was established | NA | hardcoded to 0 |
| dataRelease | unknown | TINYINT | 0 | Data release when this color calibration was established | NA | hardcoded to 0 |
| DetectionCalib | - previously all done by psps | |||||
| ODM attribute | units | Data type | Default | Description | IPP source | IPP variable/notes |
| objID | dimensionless | BIGINT 8 | NA | ODM object identifier | dvo | |
| detectID | dimensionless | BIGINT 8 | NA | ODM detection identifier | dvo | |
| ippObjID | dimensionless | BIGINT 8 | NA | IPP object identifier | dvo | |
| ippDetectID | dimensionless | BIGINT 8 | NA | detection ID generated by IPP | dvo | |
| filterID | dimensionless | TINYINT 1 | NA | filter identifier | dvo | |
| surveyID | dimensionless | TINYINT 1 | NA | survey flag identifier | dvo | |
| ra | degrees | FLOAT 8 | NA | Right Ascension | dvo | |
| dec | degrees | FLOAT 8 | NA | No comment | dvo | |
| raErr | arcsec | REAL 4 | 0.0 | Right Ascension error | dvo | |
| decErr | arcsec | REAL 4 | NA | No comment | dvo | |
| zp | magnitudes | REAL 4 | NA | zeropoint | dvo | |
| zperr | magnitudes | REAL 4 | 0.0 | zeropoint err | dvo | |
| exptime | seconds | REAL 4 | NA | exptime | dvo | |
| airmass | dimensionless | REAL 4 | 0.0 | airmass | dvo | |
| dataRelease | TINYINT 1 | dimensionless | Data release when this detection was generated. | |||
desirement for re-ordering
collect star galaxy separators ==
after KronRadErr:
sgSep psfLikelihood psfQf psfQfperfect psfChiSq
future requirements for frame metadata
scheduling chunk name
mount (alt, az, timestamp), calibrated (alt, az, timestamp), names of mount model, pointing model, secondary mirror model, primary mirror model, focus model, (l) otis release number
observatory atmospheric pressure, temperature, dew point/humidity
future requirements for image metadata
gain, detection efficiency ....
