Changeset 38784
- Timestamp:
- Oct 5, 2015, 5:46:40 PM (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippToPsps/pspsschema/SchemaNew22.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection
r38722 r38784 1 1 2 diffObjID dimensionless BIGINT 8 NAdiff object identifier3 uniquePspsDFid dimensionless BIGINT 8 NAunique psps id (combination of batch_id, and counter) provided by ipptopsps4 diffDetID dimensionless BIGINT 8 NAdiff detection identifier5 diffDetMetaID dimensionless BIGINT 8 NAdiff detection meta identifier6 ippDetectID dimensionless BIGINT 8 NAipp detection id generated by IPP7 ippObjID dimensionless BIGINT 8 NAipp object id generated by IPP8 filterID dimensionless TINYINT 1 NAfilter ID: g=1, r=2, i=3, z=4, y=5, w=6, ...9 surveyID dimensionless TINYINT 1 NAsurvey flag identifierr10 randomDiffID dimensionless FLOAT 8 NArandom diff id2 diffObjID dimensionless BIGINT 8 NA diff object identifier 3 uniquePspsDFid dimensionless BIGINT 8 NA unique psps id (combination of batch_id, and counter) provided by ipptopsps 4 diffDetID dimensionless BIGINT 8 NA diff detection identifier 5 diffDetMetaID dimensionless BIGINT 8 NA diff detection meta identifier 6 ippDetectID dimensionless BIGINT 8 NA ipp detection id generated by IPP 7 ippObjID dimensionless BIGINT 8 NA ipp object id generated by IPP 8 filterID dimensionless TINYINT 1 NA filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ... 9 surveyID dimensionless TINYINT 1 NA survey flag identifierr 10 randomDiffID dimensionless FLOAT 8 NA random diff id 11 11 skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier 12 12 dvoRegionID dimensionless INT 4 0 identifier to dvo spatial region 13 obsTime MeanJulianDays FLOAT 8 -999Time of mid observation of positive detection in Mean Julian Days of positive detection14 xPos pixels REAL 4 -999measured x on diff image sky cell PSF fit15 yPos pixels REAL 4 -999measured y on diff image sky cell from PSF fit16 xPosErr pixels REAL 4 -999estimated error in x17 yPosErr pixels REAL 4 -999estimated error in y13 obsTime MeanJulianDays FLOAT 8 -999 Time of mid observation of positive detection in Mean Julian Days of positive detection 14 xPos pixels REAL 4 -999 measured x on diff image sky cell PSF fit 15 yPos pixels REAL 4 -999 measured y on diff image sky cell from PSF fit 16 xPosErr pixels REAL 4 -999 estimated error in x 17 yPosErr pixels REAL 4 -999 estimated error in y 18 18 pltScale arcsec/pix REAL 4 -999 plate scale at this location (from DVO) 19 19 posAngle degrees REAL 4 -999 position angle (sky-to-chip) at this location (from DVO) … … 28 28 airMass dimensionless REAL 4 0 airmass (informational) 29 29 ----------------------------------------------------- attributes of positive detection 30 DpsfFlux adu/seconds REAL 4 -999 PSF instrumental flux (in analog-to-digital units/sec) or adu/sec31 DpsfFluxErr adu/seconds REAL 4 -999 estimated error in flux32 DpsfMajorFWHM 33 DpsfMinorFWHM 34 DpsfTheta 35 DpsfCore 36 DpsfQf dimensionless REAL 4 -999PSF coverage factor37 DpsfQfPerfect dimensionless REAL 4 -999PSF-weighted fraction of pixels totally unmasked38 DpsfChiSq dimensionless REAL 4 -999reduced-chisq of the psf model fit. (ndof?, npix?)39 DpsfLikelihood dimensionless REAL 4 -999PSF likelihood40 DmomentXX arcsec^2 REAL 4 -999moment XX41 DmomentXY arcsec^2 REAL 4 -999moment XY42 DmomentYY arcsec^2 REAL 4 -999momeny YY43 DmomentR1 arcsec REAL 4 -999first radial moment44 DmomentRH arcsec REAL 4 -999r^1/2 weighted moment45 DmomentM3C arcsec^3 REAL 4 -9993rd moment sin(theta)46 DmomentM3S arcsec^3 REAL 4 -9993rd moment cos(theta)47 DmomentM4C arcsec^4 REAL 4 -9994th moment sin(theta)48 DmomentM4S arcsec^4 REAL 4 -9994th moment cos(theta)49 DapFlux adu/seconds REAL 4 -999Aperture flux50 DapFluxErr adu/seconds REAL 4 -999Aperture flux error51 DapFillF 52 DkronFlux adu/seconds REAL 4 -999Kron flux53 DkronFluxErr adu/seconds REAL 4 -999Kron flux error54 DkronRad raw pixels REAL 4 -999Kron radius30 DpsfFlux Jy REAL 4 -999 PSF flux 31 DpsfFluxErr Jy REAL 4 -999 PSF flux error 32 DpsfMajorFWHM arcsec REAL 4 -999 model PSF width in major axis 33 DpsfMinorFWHM arcsec REAL 4 -999 model PSF width in minor axis 34 DpsfTheta degrees REAL 4 -999 model PSF orientation angle degrees East of North 35 DpsfCore dimensionless REAL 4 -999 model PSF core parameter [k in (1 + kz + z^1.66)] 36 DpsfQf dimensionless REAL 4 -999 PSF coverage factor 37 DpsfQfPerfect dimensionless REAL 4 -999 PSF-weighted fraction of pixels totally unmasked 38 DpsfChiSq dimensionless REAL 4 -999 reduced-chisq of the psf model fit. (ndof?, npix?) 39 DpsfLikelihood dimensionless REAL 4 -999 PSF likelihood 40 DmomentXX arcsec^2 REAL 4 -999 moment XX 41 DmomentXY arcsec^2 REAL 4 -999 moment XY 42 DmomentYY arcsec^2 REAL 4 -999 momeny YY 43 DmomentR1 arcsec REAL 4 -999 first radial moment 44 DmomentRH arcsec REAL 4 -999 r^1/2 weighted moment 45 DmomentM3C arcsec^3 REAL 4 -999 3rd moment sin(theta) 46 DmomentM3S arcsec^3 REAL 4 -999 3rd moment cos(theta) 47 DmomentM4C arcsec^4 REAL 4 -999 4th moment sin(theta) 48 DmomentM4S arcsec^4 REAL 4 -999 4th moment cos(theta) 49 DapFlux Jy REAL 4 -999 Aperture flux 50 DapFluxErr Jy REAL 4 -999 Aperture flux error 51 DapFillF dimensionless REAL 4 -999 Aperture fill factor 52 DkronFlux Jy REAL 4 -999 Kron flux 53 DkronFluxErr Jy REAL 4 -999 Kron flux error 54 DkronRad arcsec REAL 4 -999 Kron radius 55 55 ------------------------------------------------------- from diff image cmf/smf files 56 56 diffNPos dimensionless REAL 4 -999 npix > 3sigma … … 64 64 diffNSN dimensionless REAL 4 -999 signal to noise of neg match source 65 65 ------------------------------------------------------- 66 Dsky adu/sec/pixel REAL 4 -999PSF sky level at source67 DskyErr adu/sec/pixel REAL 4 -999estimated error in sky68 DinfoFlag dimensionless INT 4 -999flag indicating provenance information69 DinfoFlag2 dimensionless INT 4 -999flag indicating provenance information70 DinfoFlag3 dimensionless INT 4 -999flag indicating provenance information71 dataRelease dimensionless TINYINT 1 NAData release when this detection was originally taken. Recalibrations do not affect this value.66 Dsky adu/sec/pixel REAL 4 -999 PSF sky level at source 67 DskyErr adu/sec/pixel REAL 4 -999 estimated error in sky 68 DinfoFlag dimensionless INT 4 -999 flag indicating provenance information 69 DinfoFlag2 dimensionless INT 4 -999 flag indicating provenance information 70 DinfoFlag3 dimensionless INT 4 -999 flag indicating provenance information 71 dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. Recalibrations do not affect this value.
Note:
See TracChangeset
for help on using the changeset viewer.
