Changes between Version 28 and Version 29 of ippToPsps_Detections
- Timestamp:
- Jun 23, 2011, 9:15:25 AM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ippToPsps_Detections
v28 v29 23 23 = Unresolved fields = 24 24 25 || '''IPP source''' || '''IPP variable''' || '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Notes''' || '''Description''' ||26 25 || '''!FrameMeta''' |||||||||||||||| 26 || '''IPP source''' || '''IPP variable''' || '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Notes''' || '''Description''' || 27 27 |||||| frameID||unknown||INT||0|| ||unique exposure/frame identifier.|| 28 28 |||||| frameName||unknown||VARCHAR(32)|| || ||frame name provided by camera software|| … … 37 37 |||||| p3Recip||unknown||VARCHAR(MAX)|| || ||IPP phase 3 MD5 Checksum|| 38 38 |||||| nOTA||unknown||SMALLINT||-999|| ||number of valid OTA/CCD images in this exposure|| 39 |||||| photoScat||mag||REAL||-999|| || global photometric scatter (unit = mag)||39 |||||| photoScat||mag||REAL||-999|| || global photometric scatter|| 40 40 |||||| numPhotoRef||unknown||INT||-999|| ||number of photometric reference sources|| 41 |||||| expStart||day||FLOAT||-999|| || exposure start time in MJD (unit = day)||42 |||||| expTime||s||REAL||-999|| || exposure time (unit = s)||41 |||||| expStart||day||FLOAT||-999|| || exposure start time in MJD|| 42 |||||| expTime||s||REAL||-999|| || exposure time|| 43 43 |||||| airmass||unknown||REAL||-999|| ||airmass at mid-exposure|| 44 |||||| raBore||deg||FLOAT||-999|| || RA of telescope boresight (unit = deg)||45 |||||| decBore||deg||FLOAT||-999|| || DEC of telescope boresight (unit = deg)||44 |||||| raBore||deg||FLOAT||-999|| || RA of telescope boresight|| 45 |||||| decBore||deg||FLOAT||-999|| || DEC of telescope boresight|| 46 46 |||||| ctype1||unknown||VARCHAR(MAX)|| || ||name of astrometric projection in RA|| 47 47 |||||| ctype2||unknown||VARCHAR(MAX)|| || ||name of astrometric projection in DEC|| 48 |||||| crval1||deg||FLOAT||-999|| || RA corresponding to reference pixel (unit = deg)||49 |||||| crval2||deg||FLOAT||-999|| || DEC corresponding to reference pixel (unit = deg)||48 |||||| crval1||deg||FLOAT||-999|| || RA corresponding to reference pixel|| 49 |||||| crval2||deg||FLOAT||-999|| || DEC corresponding to reference pixel|| 50 50 |||||| crpix1||unknown||FLOAT||-999|| ||reference pixel value for RA|| 51 51 |||||| crpix2||unknown||FLOAT||-999|| ||reference pixel value for DEC|| … … 74 74 |||||| dataRelease||unknown||TINYINT||0|| ||Data release|| 75 75 || '''!ImageMeta''' |||||||||||||||| 76 || '''IPP source''' || '''IPP variable''' || '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Notes''' || '''Description''' || 76 77 |||||| imageID||unknown||BIGINT||0|| ||unique ID for each image, hashed from frameID and ccdID (ALEX)|| 77 78 |||||| frameID||unknown||INT||0|| ||frame identifier, also known as exposure number|| … … 79 80 |||||| photoCalID||unknown||INT||0|| ||photometry reduction code identifier|| 80 81 |||||| filterID||unknown||TINYINT||0|| ||filter ID|| 81 |||||| bias||ADU||REAL||-999|| || detector bias level (unit = ADU)||82 |||||| biasScat||ADU||REAL||-999|| || scatter in bias level (unit = ADU)||83 |||||| sky||ADU||REAL||-999|| || mean sky level (unit = ADU)||84 |||||| skyScat||ADU||REAL||-999|| || scatter in mean sky level (unit = ADU)||82 |||||| bias||ADU||REAL||-999|| || detector bias level|| 83 |||||| biasScat||ADU||REAL||-999|| || scatter in bias level|| 84 |||||| sky||ADU||REAL||-999|| || mean sky level|| 85 |||||| skyScat||ADU||REAL||-999|| || scatter in mean sky level|| 85 86 |||||| nDetect||unknown||INT||-999|| ||number of detections on CCD|| 86 |||||| magSat||mag||REAL||-999|| || saturation magnitude level (unit = mag)||87 |||||| completMag||mag||REAL||-999|| || 95% completion level in mag (unit = mag)||88 |||||| astroScat||mag||REAL||-999|| || astrometric scatter for chip (unit = mag)||87 |||||| magSat||mag||REAL||-999|| || saturation magnitude level|| 88 |||||| completMag||mag||REAL||-999|| || 95% completion level in mag|| 89 |||||| astroScat||mag||REAL||-999|| || astrometric scatter for chip|| 89 90 |||||| photoScat||unknown||REAL||-999|| ||photometric scatter for chip|| 90 91 |||||| numAstroRef||unknown||INT||-999|| ||number of astrometric reference sources|| … … 93 94 |||||| ny||unknown||SMALLINT||-999|| ||chip dimension in y|| 94 95 |||||| psfModelID||unknown||INT||-999|| ||PSF model identifier|| 95 |||||| psfFwhm||arcsec||REAL||-999|| || model psf full width at half maximum at chip center (unit = arcsec)||96 |||||| psfWidMajor||arcsec||REAL||-999|| || model PSF parameters at chip center (unit = arcsec)||97 |||||| psfWidMinor||arcsec||REAL||-999|| || model PSF parameters at chip center (unit = arcsec)||98 |||||| psfTheta||deg||REAL||-999|| || model PSF parameters at chip center (unit = deg)||99 |||||| momentFwhm||arcsec||REAL||-999|| || average PSF full width at half maximum from moments (unit = arcsec)||100 |||||| momentWidMajor||arcsec||REAL||-999|| || average PSF parameters from moments (unit = arcsec)||101 |||||| momentWidMinor||arcsec||REAL||-999|| || average PSF parameters from moments (unit = arcsec)||96 |||||| psfFwhm||arcsec||REAL||-999|| || model psf full width at half maximum at chip center|| 97 |||||| psfWidMajor||arcsec||REAL||-999|| || model PSF parameters at chip center|| 98 |||||| psfWidMinor||arcsec||REAL||-999|| || model PSF parameters at chip center|| 99 |||||| psfTheta||deg||REAL||-999|| || model PSF parameters at chip center|| 100 |||||| momentFwhm||arcsec||REAL||-999|| || average PSF full width at half maximum from moments|| 101 |||||| momentWidMajor||arcsec||REAL||-999|| || average PSF parameters from moments|| 102 |||||| momentWidMinor||arcsec||REAL||-999|| || average PSF parameters from moments|| 102 103 |||||| apResid||unknown||REAL||-999|| ||corrected aperture residual|| 103 104 |||||| dapResid||unknown||REAL||-999|| ||scatter of aperture corrections|| … … 112 113 |||||| detrend7||unknown||VARCHAR(MAX)|| || ||identifier of detrend image 7|| 113 114 |||||| detrend8||unknown||VARCHAR(MAX)|| || ||identifier of detrend image 8|| 114 |||||| photoZero||mag||REAL||-999|| || local derived photometric zero point (unit = mag)||115 |||||| photoZero||mag||REAL||-999|| || local derived photometric zero point|| 115 116 |||||| ctype1||unknown||VARCHAR(MAX)|| || ||name of astrometric projection in RA|| 116 117 |||||| ctype2||unknown||VARCHAR(MAX)|| || ||name of astrometric projection in DEC|| 117 |||||| crval1||deg||FLOAT||-999|| || RA corresponding to reference pixel (unit = deg)||118 |||||| crval2||deg||FLOAT||-999|| || DEC corresponding to reference pixel (unit = deg)||119 |||||| crpix1||pix||FLOAT||-999|| || reference pixel value for RA (unit = pix)||120 |||||| crpix2||pix||FLOAT||-999|| || reference pixel value for DEC (unit = pix)||118 |||||| crval1||deg||FLOAT||-999|| || RA corresponding to reference pixel|| 119 |||||| crval2||deg||FLOAT||-999|| || DEC corresponding to reference pixel|| 120 |||||| crpix1||pix||FLOAT||-999|| || reference pixel value for RA|| 121 |||||| crpix2||pix||FLOAT||-999|| || reference pixel value for DEC|| 121 122 |||||| cdelt1||unknown||FLOAT||-999|| ||scale factor for RA|| 122 123 |||||| cdelt2||unknown||FLOAT||-999|| ||scale factor for DEC|| … … 142 143 |||||| calibModNum||unknown||SMALLINT||0|| ||calibration modification number|| 143 144 |||||| dataRelease||unknown||TINYINT||0|| ||Data release|| 144 || '''Detection''' |||||||||||||||| 145 || '''!Detection''' |||||||||||||||| 146 || '''IPP source''' || '''IPP variable''' || '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Notes''' || '''Description''' || 145 147 |||||| objID||unknown||BIGINT||0|| ||ODM object identifier|| 146 148 |||||| detectID||unknown||BIGINT||0|| ||ODM detection identifier|| … … 150 152 |||||| surveyID||unknown||TINYINT||0|| ||survey flag identifier|| 151 153 |||||| imageID||unknown||BIGINT||0|| ||image id hash of frame identifier & OTA/CCD number|| 152 |||||| obsTime||day||FLOAT||-999|| || Time of mid observation (unit = day)||153 |||||| xPos||pix||REAL||-999|| || measured x on CCD from PSF fit (unit = pix)||154 |||||| yPos||pix||REAL||-999|| || measured y on CCD from PSF fit (unit = pix)||155 |||||| xPosErr||pix||REAL||-999|| || estimated error in x (unit = pix)||156 |||||| yPosErr||pix||REAL||-999|| || estimated error in y (unit = pix)||157 |||||| instFlux||adu/s||REAL||-999|| || PSF instrumental flux (unit = adu/s)||158 |||||| instFluxErr||adu/s||REAL||-999|| || estimated error in flux (unit = adu/s)||159 |||||| peakADU||adu||REAL||-999|| || peak count in source pixel (unit = adu)||160 |||||| psfWidMajor||arcsec||REAL||-999|| || model PSF width in major axis (unit = arcsec)||161 |||||| psfWidMinor||arcsec||REAL||-999|| || model PSF width in minor axis (unit = arcsec)||162 |||||| psfTheta||deg||REAL||-999|| || model PSF orientation angle (unit = deg)||154 |||||| obsTime||day||FLOAT||-999|| || Time of mid observation|| 155 |||||| xPos||pix||REAL||-999|| || measured x on CCD from PSF fit|| 156 |||||| yPos||pix||REAL||-999|| || measured y on CCD from PSF fit|| 157 |||||| xPosErr||pix||REAL||-999|| || estimated error in x|| 158 |||||| yPosErr||pix||REAL||-999|| || estimated error in y|| 159 |||||| instFlux||adu/s||REAL||-999|| || PSF instrumental flux|| 160 |||||| instFluxErr||adu/s||REAL||-999|| || estimated error in flux|| 161 |||||| peakADU||adu||REAL||-999|| || peak count in source pixel|| 162 |||||| psfWidMajor||arcsec||REAL||-999|| || model PSF width in major axis|| 163 |||||| psfWidMinor||arcsec||REAL||-999|| || model PSF width in minor axis|| 164 |||||| psfTheta||deg||REAL||-999|| || model PSF orientation angle|| 163 165 |||||| psfLikelihood||unknown||REAL||-999|| ||PSF likelihood|| 164 166 |||||| psfCf||unknown||REAL||-999|| ||PSF coverage factor|| 165 |||||| momentXX||arcsec||REAL||-999|| || moment XX (unit = arcsec)||166 |||||| momentXY||arcsec||REAL||-999|| || moment XY (unit = arcsec)||167 |||||| momentYY||arcsec||REAL||-999|| || momeny YY (unit = arcsec)||168 |||||| apMag||magnitude||REAL||-999|| || Aperture magnitude (unit = magnitude)||169 |||||| apMagErr||magnitude||REAL||-999|| || Aperture magnitude error (unit = magnitude)||170 |||||| kronFlux||magnitude||REAL||-999|| || Kron flux (unit = magnitude)||171 |||||| kronFluxErr||magnitude||REAL||-999|| || Kron flux error (unit = magnitude)||172 |||||| kronRad||arcsecs||REAL||-999|| || Kron radius (unit = arcsecs)||173 |||||| kronRadErr||arcsecs||REAL||-999|| || Kron radius error (unit = arcsecs)||167 |||||| momentXX||arcsec||REAL||-999|| || moment XX|| 168 |||||| momentXY||arcsec||REAL||-999|| || moment XY|| 169 |||||| momentYY||arcsec||REAL||-999|| || momeny YY|| 170 |||||| apMag||magnitude||REAL||-999|| || Aperture magnitude|| 171 |||||| apMagErr||magnitude||REAL||-999|| || Aperture magnitude error|| 172 |||||| kronFlux||magnitude||REAL||-999|| || Kron flux|| 173 |||||| kronFluxErr||magnitude||REAL||-999|| || Kron flux error|| 174 |||||| kronRad||arcsecs||REAL||-999|| || Kron radius|| 175 |||||| kronRadErr||arcsecs||REAL||-999|| || Kron radius error|| 174 176 |||||| crLikelihood||unknown||REAL||-999|| ||Likelihood the source is a cosmic ray|| 175 177 |||||| extendedLikelihood||unknown||REAL||-999|| ||Likelihood the source is extended|| 176 178 |||||| infoFlag||unknown||BIGINT||-999|| ||flag indicating provenance information|| 177 |||||| sky||adu||REAL||-999|| || PSF sky level at source (unit = adu)||178 |||||| skyErr||adu||REAL||-999|| || estimated error in sky (unit = adu)||179 |||||| sky||adu||REAL||-999|| || PSF sky level at source|| 180 |||||| skyErr||adu||REAL||-999|| || estimated error in sky|| 179 181 |||||| sgSep||unknown||REAL||-999|| ||star/galaxy separator|| 180 182 |||||| activeFlag||unknown||TINYINT||-999|| ||indicates whether this detection/orphan is still a detection/orphan|| … … 183 185 |||||| dataRelease||unknown||TINYINT||0|| ||Data release when this detection was originally taken. Recalibrations do not affect this value.|| 184 186 || '''!SkinnyObject''' |||||||||||||||| 187 || '''IPP source''' || '''IPP variable''' || '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Notes''' || '''Description''' || 185 188 |||||| objID||unknown||BIGINT||0|| ||ODM object identifier index|| 186 189 |||||| ippObjID||unknown||BIGINT||0|| ||IPP object number|| … … 189 192 |||||| surveyID||unknown||TINYINT||255|| ||surveyID </coluumn>|| 190 193 || '''!ObjectCalColor''' |||||||||||||||| 194 || '''IPP source''' || '''IPP variable''' || '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Notes''' || '''Description''' || 191 195 |||||| objID||unknown||BIGINT||0|| ||ODM object identifier|| 192 196 |||||| ippObjID||unknown||BIGINT||0|| ||ipp object identifier|| 193 197 |||||| filterID||unknown||TINYINT||0|| ||filter identifier|| 194 |||||| calColor||mag||REAL||0|| || color adopted for magnitude calculation (unit = mag)||195 |||||| calColorErr||mag||REAL||0|| || error in calibrating color (unit = mag)||198 |||||| calColor||mag||REAL||0|| || color adopted for magnitude calculation|| 199 |||||| calColorErr||mag||REAL||0|| || error in calibrating color|| 196 200 |||||| calibModNum||unknown||SMALLINT||0|| ||calibration modification number|| 197 201 |||||| dataRelease||unknown||TINYINT||0|| ||Data release when this color calibration was established|| 198 199 202 = Running = 200 203
