| | 1 | == Detection Batches (PV2) == |
| | 2 | |
| | 3 | as a reference, the old (pv1) version of the tables -> [wiki:ippToPsps_Stack] |
| | 4 | |
| | 5 | == Proposed ippToPsps mappings == |
| | 6 | |
| | 7 | ||'''ODM attribute'''|| '''units''' ||'''Data type''' ||'''Default''' ||'''Description''' ||'''IPP source''' ||'''IPP variable/notes'''||'''HAFcomments''' || |
| | 8 | ||'''StackDetection'''|| || || || || || || || |
| | 9 | ||objID ||dimensionless || BIGINT 8 || NA || ODM object identifier |
| | 10 | ||surveyID ||dimensionless || TINYINT 1 || NA ||survey flag identifier |
| | 11 | ||skyCellID ||dimensionless || INT 4 || -999 ||skycell identifier |
| | 12 | ||primarySkyCell || dimensionless || TINYINT 1 || 255|| identifies best stack detection for Stacks overlapping the same region of the sky. |
| | 13 | ||projectionCell || Ddimensionless || INT 4 || -999 ||projection cell identifier |
| | 14 | ||stackDetectID || dimensionless || BIGINT 8 || NA || ODM detection identifier |
| | 15 | ||ippDetectID || dimensionless || BIGINT 8 || NA ||detection ID generated by IPP |
| | 16 | ||assocDate || dimensionless || DATE 8 || 28881231 || date object association assigned |
| | 17 | ||historyModNum || dimensionless || SMALLINT 2 || 0 || modification number in the O-D association history |
| | 18 | ||dataRelease || dimensionless || TINYINT 1 || NA|| Data release when this detection was originally taken. |
| | 19 | ||repeat below for each filter || || || || attributes for all stack detections in all filters (these are currently forced anyway) |
| | 20 | ||gStackMetaID || dimensionless ||BIGINT 8 ||NA stack identifier |
| | 21 | ||gxPos ||pixels || REAL 4 || -999 ||measured x in sky Cell from PSF fit |
| | 22 | ||gyPos ||pixels || REAL 4 || -999 ||measured y in sky Cell from PSF fit |
| | 23 | ||gxPosErr ||pixels || REAL 4 || -999 ||estimated error in x |
| | 24 | ||gyPosErr ||pixels || REAL 4|| -999 || estimated error in y |
| | 25 | ||gra || degrees || FLOAT 8 || NA ||Right Ascension || from stackDetectionCalib |
| | 26 | ||gdec || degrees || FLOAT 8 || NA || Declination || from stackDetectionCalib |
| | 27 | ||graErr ||arcsec || REAL 4 || NA || Right Ascension error || from stackDetectionCalib |
| | 28 | ||gdecErr ||arcsec || REAL 4 || NA || Declination error (same as RA error - need?) || from stackDetectionCalib |
| | 29 | ||gzp ||magnitude || REAL 4 || 0 ||zeropoint , no error given || from stackDetectionCalib |
| | 30 | ||gexpTime || seconds || REAL 4 ||-999 ||total exposure time (informational) || from stackDetectionCalib |
| | 31 | ||gpsfFlux || adu/seconds || REAL 4 ||-999 || PSF instrumental flux |
| | 32 | ||gpsfFluxErr || adu/seconds || REAL 4 || -999 ||Estimated error in instrumental flux |
| | 33 | ||gpeakFlux || adu || REAL 4 || -999 || ratio of peak flux to total flux |
| | 34 | ||gpsfMajorFWHM ||arcsec || REAL 4 ||-999 ||PSF width in major axis |
| | 35 | ||gpsfMinorFWHM ||arcsec || REAL 4 ||-999 ||PSF width in minor axis |
| | 36 | ||gpsfThetaFWHM || degrees ||REAL 4 || -999 ||PSF orientation angle. Degrees East of North. |
| | 37 | ||gpsfMxx ||pixels squared || REAL 4 || -999 || PSF orientation angle. Degrees East of North. |
| | 38 | ||gpsfMxy ||pixels squared ||REAL 4 || -999 || PSF width in major axis |
| | 39 | ||gpsfMyy ||pixels squared ||REAL 4 || -999 || PSF width in minor axis |
| | 40 | ||gpsfLikelihood || dimensionless ||REAL 4 || -999 || PSF likelihood |
| | 41 | ||gpsfQf ||dimensionless ||REAL 4 || -999 || PSF coverage factor |
| | 42 | ||gpsfQfPerfect || dimensionless ||REAL 4 || -999 || PSF-weighted fraction of pixels totally unmasked |
| | 43 | ||gpsfChiSq ||dimensionless ||REAL 4 || -999 || PSF-weighted fraction of pixels to. |
| | 44 | ||gmomentXX ||pixels squared || REAL 4 || -999 || moment XX |
| | 45 | ||gmomentXY || pixels squared ||REAL 4 || -999 || moment XY |
| | 46 | ||gmomentYY || pixels squared ||REAL 4 || -999 || moment YY |
| | 47 | ||gmomentM3C || pixels squared ||REAL 4 || -999 || moment M3C |
| | 48 | ||gmomentM3S || pixels squared ||REAL 4 || -999 || moment M3S |
| | 49 | ||gmomentM4C || pixels squared || REAL 4 || -999 || moment M4C |
| | 50 | ||gmomentM4S || pixels squared|| REAL 4 || -999 || moment M4S |
| | 51 | ||gmomentR1 || pixels || REAL 4 || -999 || moment R1 |
| | 52 | ||gmomentRH || sqrt pixels || REAL 4 || -999 || moment RH (drop?) |
| | 53 | ||gApFlux || adu/seconds ||REAL 4 || -999 ||Aperture magnitude |
| | 54 | ||gApFluxErr || adu/seconds ||REAL 4 || -999 ||Aperture magnitude error |
| | 55 | ||gApFillFac || dimensionless || REAL 4 || -999 || Aperture fill factor - ~ redundant with psfQF, keep? |
| | 56 | ||gKronFlux || adu/seconds ||REAL 4 || -999 || Kron flux |
| | 57 | ||gKronFluxErr|| adu/seconds || REAL 4|| -999 || Kron flux error |
| | 58 | ||gKronRad || arcsec ||REAL 4 || -999 || Kron radius |
| | 59 | ||gSky || adu/secs/pixel || REAL 4 || -999 || PSF sky level at source (adu) |
| | 60 | ||gSkyErr || adu/secs/pixel || REAL 4 || -999 || estimated error in sky |
| | 61 | ||gSGsep1 ||dimensionless || REAL 4 || -999 || star/galaxy separator |
| | 62 | ||ginfoFlag ||dimensionless || BIGINT 8 || -999 || indicator of strange propeties |
| | 63 | ||gnFrames ||dimensionless|| INT 4 || -999 || Number of frames contributing to source |
| | 64 | |
| | 65 | Heather has a lot of problems with this - it looks more like an object table, not the stack table. It's lacking metadata to go back to the stacks, and it's lacking time domain information. ippToPsps ingests one stack at a time, this would imply 5 (?). |
