Changeset 37246 for trunk/ippToPsps/pspsschema/SchemaNew18.0
- Timestamp:
- Aug 12, 2014, 4:10:18 PM (12 years ago)
- Location:
- trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES
- Files:
-
- 7 deleted
- 17 edited
- 24 copied
-
Fundamental_IPP_Data_Product_Tables/Detection (modified) (3 diffs)
-
Fundamental_IPP_Data_Product_Tables/Detection.txt (modified) (1 diff)
-
Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended )
-
Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt )
-
Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (modified) (3 diffs)
-
Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/MeanObject (modified) (1 diff)
-
Fundamental_IPP_Data_Product_Tables/MeanObject.txt (modified) (1 diff)
-
Fundamental_IPP_Data_Product_Tables/ObjectThin (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/ObjectThin.txt (modified) (1 diff)
-
Fundamental_IPP_Data_Product_Tables/StackApFlx (modified) (3 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackApFlx.txt (modified) (1 diff)
-
Fundamental_IPP_Data_Product_Tables/StackApFlxFull (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull )
-
Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFull.txt )
-
Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1 (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1 )
-
Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC1.txt )
-
Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2 (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2 )
-
Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxFullC2.txt )
-
Fundamental_IPP_Data_Product_Tables/StackModelFit (deleted)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt )
-
Fundamental_IPP_Data_Product_Tables/StackModelFitExp (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt )
-
Fundamental_IPP_Data_Product_Tables/StackModelFitExtra (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra )
-
Fundamental_IPP_Data_Product_Tables/StackModelFitFlx (deleted)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC1 (deleted)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC2 (deleted)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitPet (deleted)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitSer (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt )
-
Fundamental_IPP_Data_Product_Tables/StackModelFitThin (deleted)
-
Fundamental_IPP_Data_Product_Tables/StackObjectExtra (deleted)
-
Fundamental_IPP_Data_Product_Tables/StackObjectExtra.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra.txt )
-
Fundamental_IPP_Data_Product_Tables/StackObjectRaw (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw )
-
Fundamental_IPP_Data_Product_Tables/StackObjectRaw.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectRaw.txt )
-
Fundamental_IPP_Data_Product_Tables/StackObjectThin (modified) (1 diff)
-
Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt )
-
Fundamental_IPP_Data_Product_Tables/StackPetrosian (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian )
-
Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt )
-
Fundamental_IPP_Data_Product_Tables/notes.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/notes.txt )
-
Fundamental_IPP_Data_Product_Tables/schema18.notes.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/schema18.notes.txt )
-
MetaData_Tables/FrameMeta (modified) (1 diff)
-
MetaData_Tables/FrameMeta.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/FrameMeta.txt )
-
MetaData_Tables/ImageMeta (modified) (1 diff)
-
MetaData_Tables/ImageMeta.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/ImageMeta.txt )
-
MetaData_Tables/StackMeta (modified) (1 diff)
-
MetaData_Tables/StackMeta.txt (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt )
-
MetaData_Tables/TessellationType (copied) (copied from branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/TessellationType )
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection
r37000 r37246 1 1 objID dimensionless BIGINT 8 NA ODM object identifier 2 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier3 2 detectID dimensionless BIGINT 8 NA ODM detection identifier 4 3 ippObjID dimensionless BIGINT 8 NA detection id generated by IPP … … 48 47 apFluxErr adu/seconds REAL 4 -999 Aperture flux error 49 48 apFillF dimensionless REAL 4 -999 Aperture fill factor 49 apRadius arcsec REAL 4 -999 Aperture radius 50 50 kronFlux adu/seconds REAL 4 -999 Kron flux 51 51 kronFluxErr adu/seconds REAL 4 -999 Kron flux error 52 52 kronRad arcsec REAL 4 -999 Kron radius 53 kronRadErr arcsec REAL 4 -999 Kron radius error (DROP)54 53 sky adu/sec/pixel REAL 4 -999 PSF sky level at source 55 54 skyErr adu/sec/pixel REAL 4 -999 estimated error in sky … … 59 58 -- 60 59 -- [231 bytes/det] 60 61 ### do we want apRadius? 62 ### relevant code spots: 63 ### config/tables.P2.vot, detectionbatch.py:315 -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection.txt
r37000 r37246 1 objID = dvo / addstar 2 gcObjID = dvo / addstar [EAM: add to addstar] 3 detectID = dvo / addstar 4 ippObjID = dvo / addstar 5 ippDetectID = dvo / addstar 6 filterID = smf / ipptopsps 7 surveyID = ipptopsps 8 imageID = smf header 9 randomDetID = ipptopsps 10 dvoRegionID = dvo / catID [EAM: add to dvopsps] 11 obsTime = smf 12 xPos = smf 13 yPos = smf 14 xPosErr = smf [EAM: modify errors to match relastro?] 15 yPosErr = smf 16 pltScale = smf 17 posAngle = smf 18 ----------------= 19 ra = dvo / relastro 20 dec = dvo / relastro 21 raErr = dvo / relastro 22 decErr = dvo / relastro 23 zp = dvo / relphot 24 telluricExt = zp - zpNominal (dvopsps) [EAM: add to dvopsps] 25 expTime = smf 26 airMass = smf 27 ----------------= 28 psfFlux = smf [OK: ipptopsps uses PSF_FLUX] 29 psfFluxErr = smf 30 psfMajorFWHM = smf [PSF_MAJOR is Sxx parameter, NOT FWHM] [EAM: add PSF_FWHM_MAJ to smf, keep PSF_MAJOR] 31 psfMinorFWHM = smf [PSF_MINOR is Sxx parameter, NOT FWHM] [EAM: add PSF_FWHM_MIN to smf, keep PSF_MINOR] 32 psfTheta = smf 33 psfCore = smf [EAM: add PSF_CORE to smf] 34 psfQf = smf 35 psfQfPerfect = smf 36 psfChiSq = smf 37 psfLikelihood = ipptopsps 38 momentXX = smf 39 momentXY = smf 40 momentYY = smf 41 momentR1 = smf 42 momentRH = smf [XXX : MOMENTS_RH is NOT half-light radius : keep as MOMENTS_RH or calculate?] 43 momentM3C = smf 44 momentM3S = smf 45 momentM4C = smf 46 momentM4S = smf 47 apFlux = smf [requires PS1_V4] 48 apFluxErr = smf [requires PS1_V4] 49 apFillF = smf [EAM: add to pmSource and smf] 50 kronFlux = smf 51 kronFluxErr = smf 52 kronRad = (2.5*R1) : Ken : drop this or MOMENTS_R1? 53 kronRadErr = [not calculated] : drop this 54 sky = smf 55 skyErr = smf 56 infoFlag = smf 57 infoFlag2 = smf 58 dataRelease = ippToPsps 1 objID + dvo = average.extID [calculated in addstar] 2 detectID + dvo = measure.extID [calculated in addstar] 3 ippObjID + dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition] 4 ippDetectID + smf:IPP_IDET 5 filterID + ipptopsps : internal, lookup from filter (grizy) 6 surveyID + ipptopsps : internal, from survey name 7 imageID - ipptopsps : expID x y (*** is this right???) (smf:IMAGEID / gpc1.chipRun.chip_image_id)_ 8 randomDetID + ipptopsps : RANDOM from sql 9 dvoRegionID + dvo:average.catID 10 obsTime + smf:MJD-OBS + 0.5 EXPTIME / 84600 11 xPos + smf:X_PSF 12 yPos + smf:Y_PSF 13 xPosErr + smf:X_PSF_SIG 14 yPosErr + smf:Y_PSF_SIG 15 pltScale + smf:PLTSCALE (negative -> sky parity) 16 posAngle + smf:POSANGLE 17 --------------- 18 ra + dvo:measure.ra 19 dec + dvo:measure.dec 20 raErr + smf:X_PSF_SIG * abs(PLTSCALE) 21 decErr + smf:Y_PSF_SIG * abs(PLTSCALE) 22 zp + dvo / dvopsps : zp 23 telluricExt + dvo / dvopsps : zp - zpNominal (dvopsps) 24 expTime + dvo:measure.dt [converted to seconds] 25 airMass + dvo:measure.airmass 26 --------------- 27 psfFlux + smf:PSF_INST_FLUX / EXPTIME 28 psfFluxErr + smf:PSF_INST_FLUX_SIG / EXPTIME 29 psfMajorFWHM + smf:PSF_FWHM_MAJ 30 psfMinorFWHM + smf:PSF_FWHM_MIN 31 psfTheta + smf:PSF_THETA 32 psfCore + smf:PSF_CORE 33 psfQf + smf:PSF_QF 34 psfQfPerfect + smf:PSF_QF_PERFECT 35 psfChiSq + smf:PSF_CHISQ 36 psfLikelihood + smf:psfLikelihood(EXT_NSIGMA) 37 momentXX + smf:MOMENTS_XX 38 momentXY + smf:MOMENTS_XY 39 momentYY + smf:MOMENTS_YY 40 momentR1 + smf:MOMENTS_R1 41 momentRH + smf:MOMENTS_RH 42 momentM3C + smf:MOMENTS_M3C 43 momentM3S + smf:MOMENTS_M3S 44 momentM4C + smf:MOMENTS_M4C 45 momentM4S + smf:MOMENTS_M4S 46 apFlux + smf:AP_FLUX 47 apFluxErr + smf:AP_FLUX_SIG 48 apFillF + smf:AP_NPIX / (pi * (AP_MAG_RADIUS - 0.5)^2) 49 kronFlux + smf:KRON_FLUX 50 kronFluxErr + smf:KRON_FLUX_ERR 51 kronRad + smf:2.5*MOMENTS_R1 52 sky + smf:SKY / exptime 53 skyErr + smf:SKY_SIGMA / exptime 54 infoFlag + smf:FLAGS 55 infoFlag2 + smf:FLAGS2 | (dvo.measure.flags << 13) 56 dataRelease + ippToPsps : user input (skychunk.dataRelease) -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement
r37000 r37246 1 1 2 objID dimensionless BIGINT 8 NA ODM object identifier 2 3 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier … … 37 38 momentM4S arcsec^4 REAL 4 -999 4th moment cos(theta) 38 39 39 lensObjSmearX11 arcsec^-2 REAL 4 -999 per-object smear polarizability X11 term40 lensObjSmearX12 arcsec^-2 REAL 4 -999 per-object smear polarizability X12 term41 lensObjSmearX22 arcsec^-2 REAL 4 -999 per-object smear polarizability X22 term42 lensObjSmearE1 arcsec^-2 REAL 4 -999 per-object smear polarizability E1 term43 lensObjSmearE2 arcsec^-2 REAL 4 -999 per-object smear polarizability E2 term44 lensObjShearX11 dimensionless REAL 4 -999 per-object shear polarizability X11 term45 lensObjShearX12 dimensionless REAL 4 -999 per-object shear polarizability X12 term46 lensObjShearX22 dimensionless REAL 4 -999 per-object shear polarizability X22 term47 lensObjShearE1 dimensionless REAL 4 -999 per-object shear polarizability E1 term48 lensObjShearE2 dimensionless REAL 4 -999 per-object shear polarizability E2 term49 lensPSFSmearX11 arcsec^-2 REAL 4 -999 psf model smear polarizability X11 term50 lensPSFSmearX12 arcsec^-2 REAL 4 -999 psf model smear polarizability X12 term51 lensPSFSmearX22 arcsec^-2 REAL 4 -999 psf model smear polarizability X22 term52 lensPSFSmearE1 arcsec^-2 REAL 4 -999 psf model smear polarizability E1 term53 lensPSFSmearE2 arcsec^-2 REAL 4 -999 psf model smear polarizability E2 term54 lensPSFShearX11 dimensionless REAL 4 -999 psf model shear polarizability X11 term55 lensPSFShearX12 dimensionless REAL 4 -999 psf model shear polarizability X12 term56 lensPSFShearX22 dimensionless REAL 4 -999 psf model shear polarizability X22 term57 lensPSFShearE1 dimensionless REAL 4 -999 psf model shear polarizability E1 term58 lensPSFShearE2 dimensionless REAL 4 -999 psf model shear polarizability E2 term59 60 40 apFlux adu/seconds REAL 4 -999 Aperture flux 61 41 apFluxErr adu/seconds REAL 4 -999 Aperture flux error … … 66 46 kronRadErr arcsed REAL 4 -999 Kron radius error 67 47 ------------------------------------------------------ 68 flxR5 adu/seconds REAL 4 -999 Flux inside r = 569 flxR5Err adu/seconds REAL 4 -999 estimated error is flxR570 flxR5Std adu/seconds REAL 4 -999 estimated standard deviation in flxR571 flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R572 flxR6 adu/seconds REAL 4 -999 Flux inside r = 673 flxR6Err adu/seconds REAL 4 -999 estimated error is flxR674 flxR6Std adu/seconds REAL 4 -999 estimated standard deviation in flxR675 flxR6Fill dimensionless REAL 4 -999 estimated filling factor at R676 ------------------------------------------------------77 48 sky adu/sec/pixel REAL 4 -999 PSF sky level at source 78 49 skyErr adu/sec/pixel REAL 4 -999 estimated error in sky -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt
r37000 r37246 38 38 momentM4S = smf 39 39 = 40 lensObjSmearX11 = smf [PS1_V5]41 lensObjSmearX12 = smf [PS1_V5]42 lensObjSmearX22 = smf [PS1_V5]43 lensObjSmearE1 = smf [PS1_V5]44 lensObjSmearE2 = smf [PS1_V5]45 lensObjShearX11 = smf [PS1_V5]46 lensObjShearX12 = smf [PS1_V5]47 lensObjShearX22 = smf [PS1_V5]48 lensObjShearE1 = smf [PS1_V5]49 lensObjShearE2 = smf [PS1_V5]50 lensPSFSmearX11 = smf [PS1_V5]51 lensPSFSmearX12 = smf [PS1_V5]52 lensPSFSmearX22 = smf [PS1_V5]53 lensPSFSmearE1 = smf [PS1_V5]54 lensPSFSmearE2 = smf [PS1_V5]55 lensPSFShearX11 = smf [PS1_V5]56 lensPSFShearX12 = smf [PS1_V5]57 lensPSFShearX22 = smf [PS1_V5]58 lensPSFShearE1 = smf [PS1_V5]59 lensPSFShearE2 = smf [PS1_V5]60 =61 40 apFlux = smf [PS1_V4] 62 41 apFluxErr = smf [PS1_V4] … … 67 46 kronRadErr = [drop : not currently calculated] 68 47 ---------------- = 69 flxR5 = smf [?? calculated?]70 flxR5Err = smf [?? calculated?]71 flxR5Std = smf [?? calculated?]72 flxR5Fill = smf [?? calculated?]73 flxR6 = smf [?? calculated?]74 flxR6Err = smf [?? calculated?]75 flxR6Std = smf [?? calculated?]76 flxR6Fill = smf [?? calculated?]77 ---------------- =78 48 sky = smf 79 49 skyErr = smf -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject
r37000 r37246 4 4 5 5 objID dimensionless BIGINT 8 NA ODM object identifier index 6 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier7 6 gQfPerfect dimensionless REAL 4 -999 maximum psf qfPerfect from best available g band detections 8 7 gMeanPSFMag AB_magnitude REAL 4 -999 mean g psf AB magnitude from best available measurements (best available as current defined by ipp "waterfall logic" 9 8 gMeanPSFMagErr AB_magnitude REAL 4 -999 estimated error of best availalbe g-band psf AB magnitudes (individual errors added in quadrature) 10 gnIncPSFMag dimensionless SMALLINT 2 -999 number of best available detections included in mean psfMag11 9 gMeanPSFMagStd dimensioless REAL 4 -999 standard deviation of best available measurements - compared with MeanErr this is one measure of true variability 12 gMinPSFMag AB_magnitude REAL 4 -999 minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability. 13 gMaxPSFMag AB_magnitude REAL 4 -999 maximum best available PSFMag 10 gMeanPSFMagMin AB_magnitude REAL 4 -999 minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability. 11 gMeanPSFMagMax AB_magnitude REAL 4 -999 maximum best available PSFMag 12 gMeanPSFMagNpt dimensionless SMALLINT 2 -999 number of best available detections included in mean psfMag 14 13 15 14 gMeanKronMag AB_magnitude REAL 4 -999 mean g kron AB magnitude from best available measurements 16 15 gMeanKronMagErr AB_magnitude REAL 4 -999 estimated error of mean g kron AB magnitude 17 g nIncKronMag dimensionless SMALLINT 2 -999 number of best available detections included mean Kron mag18 gMeanKronMag Std dimensioless REAL 4 -999 standard deviation of best available measurements16 gMeanKronMagStd dimensionless REAL 4 -999 standard deviation of best available measurements 17 gMeanKronMagNpt dimensionless SMALLINT 2 -999 number of best available detections included mean Kron mag 19 18 20 19 gMeanApMag AB_magnitude REAL 4 -999 mean g kron AB magnitude from best available measurements 21 20 gMeanApMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude mean 22 gnIncApMag dimensionless SMALLINT 2 -999 number of detections included in best available mean of Kron mag in g filter23 21 gMeanApMagStd dimensioless REAL 4 -999 standard deviation of best available measurements 24 gFlags dimensionless BIGINT 8 NA flags for g mean 22 gMeanApMagNpt dimensionless SMALLINT 2 -999 number of detections included in best available mean of Kron mag in g filter 23 24 gFlags dimensionless INT 4 0 flags for g mean [XXX secfilt.flags is 4byte] 25 25 -- duplicate for other filters 26 26 -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject.txt
r37000 r37246 1 1 2 *** I've checked that these are plausible, not exact 2 3 4 objID + dvo / addstar 5 gQfPerfect + dvo / relphot / secfilt.psfQfMax 6 gMeanPSFMag + dvo / relphot / secfilt.M 7 gMeanPSFMagErr + dvo / relphot / secfilt.dM 8 gMeanPSFMagStd + dvo / relphot / secfilt.Mstdev 9 gMeanPSFMagMin + dvo / relphot / secfilt.Min 10 gMeanPSFMagMax + dvo / relphot / secfilt.Max 11 gMeanPSFMagNpt + dvo / relphot / secfilt.Nused 3 12 13 gMeanKronMag + dvo / relphot / secfilt.Mkron 14 gMeanKronMagErr + dvo / relphot / secfilt.dMkron 15 gMeanKronMagStd + dvo / relphot / secfilt.sMkron 16 gMeanKronMagNpt + dvo / relphot / secfilt.NusedKron 4 17 5 objID = dvo / addstar 6 gcObjID = dvo / addstar 7 gQfPerfect = dvo / relphot / secfilt. [XXX Not calculated] 8 gMeanPSFMag = dvo / relphot / secfilt.M 9 gMeanPSFMagErr = dvo / relphot / secfilt.dM 10 gnIncPSFMag = dvo / relphot / secfilt.Nused [XXX : ensure .Nused matches .M] 11 gMeanPSFMagStd = dvo / relphot / secfilt.Mstdev 12 gMinPSFMag = dvo / relphot / secfilt.Min [XXX: replace M_20, M_80 with Min, Max] 13 gMaxPSFMag = dvo / relphot / secfilt.Max [XXX: replace M_20, M_80 with Min, Max] 14 = 15 gMeanKronMag = dvo / relphot / secfilt.Mkron 16 gMeanKronMagErr = dvo / relphot / secfilt.dMkron 17 gnIncKronMag = dvo / relphot / secfilt.nMkron [XXX : not calculated] 18 gMeanKronMagStd = dvo / relphot / secfilt.MstdevKron [XXX : not calculated] 19 = 20 gMeanApMag = dvo / relphot / secfilt.Map 21 gMeanApMagErr = dvo / relphot / secfilt.? [XXX : not calculated] 22 gnIncApMag = dvo / relphot / secfilt.? [XXX : not calculated] 23 gMeanApMagStd = dvo / relphot / secfilt.? [XXX : not calculated] 18 gMeanApMag + dvo / relphot / secfilt.Map 19 gMeanApMagErr + dvo / relphot / secfilt.dMap 20 gMeanApMagStd + dvo / relphot / secfilt.sMap 21 gMeanApMagNpt + dvo / relphot / secfilt.NusedAp 24 22 25 gFlags =dvo / relphot / secfilt.flags23 gFlags + dvo / relphot / secfilt.flags -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin
r37000 r37246 2 2 objName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S where x is leading number of procesing version 3 3 objID dimensionless BIGINT 8 NA ODM object identifier index 4 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier5 4 ippObjID dimensionless BIGINT 8 NA IPP object number 6 5 surveyID dimensionless TINYINT 1 255 Survey ID 7 skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier8 6 htmID dimensionless BIGINT 8 NA HTM index 9 7 zoneID dimensionless INT 4 NA Zone index 8 tessID dimensionless TINYINT 1 -1 ID mapping to tessellation names (eg, RINGS.V3, MD01.V3, etc) 9 projectionID dimensionless SMALLINT 2 -999 valid values 0 - < 10000 10 skyCellID dimensionless TINYINT 1 255 valid values 0 - 143 (12x12 grid) 10 11 randomID dimensionless BIGINT 8 0 Random integer between 0 and 2^32 = 4,394,967,296 remaining ramdom integer 0 11 12 batchID dimensionless BIGINT 8 -999 batch id … … 23 24 raMeanErr arcsec REAL 4 -999 Combination of the measurement Errors in the Right Ascension from the mean detections if they exist 24 25 decMeanErr arcsec REAL 4 -999 Combination of the measurement Errors in the Declination measurements if they exist 25 raMeanStd arcsec Real 4 -999 standard deviation of Right Ascension measurements in detections if they exist 26 decMeanStd arcsec REAL 4 -999 standard deviation of the Declination measurements if they exist 26 posMeanChisq dimensionless REAL 4 -999 chisq of mean position 27 27 -------------------------------------------------------------------------------------------------------- 28 28 -- Note: the following three sets of coordinate systems are based on stack if it exists, and mean if it does not. -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin.txt
r37000 r37246 1 1 2 objName = ipptopsps3 objID = dvo / addstar4 gcobjID = dvo / addstar 5 ippObjID = dvo / addstar 6 surveyID = ipptopsps 7 skyCellID = smf header 8 htmID = PSPS 9 zoneID = PSPS 10 randomID = ipptopsps 11 batchID = ipptopsps 12 dvoRegionID = dvo / catID 13 d ataRelease = ipptopsps14 objInfoFlag = dvo / relastro,relphot [define] 15 qualityFlag = dvo / relastro,relphot [define] 16 consistencyFlag = ipptopsps?17 raStack = dvo / allow recalibration? [ADD to average.d] 18 decStack = dvo / allow recalibration?19 raStackErr = dvo / allow recalibration?20 decStackErr = dvo / allow recalibration?21 raMean = dvo / relastro 22 decMean = dvo / relastro 23 raMeanErr = dvo / relastro 24 decMeanErr = dvo / relastro 25 raMeanStd = dvo / relastro 26 decMeanStd = dvo / relastro 27 ----------------- =28 -- =29 -- =30 -- =31 -- =32 -- =33 cx =PSPS34 cy =PSPS35 cz =PSPS36 lambda =PSPS37 beta =PSPS38 l =PSPS39 b =PSPS40 ----------------- =41 nStackObjectRows = dvo [ADD to average.d]42 -- =43 nStackDetections = dvo / relphot [Sum of not-forced stack detections]44 nDetections = dvo / relphot [Sum of ng+nr, etc?]45 ng = dvo / relphot [Sum of GPC1.g.XY?? measure.d]46 nr = dvo / relphot [ditto]47 ni = dvo / relphot48 nz = dvo / relphot49 ny = dvo / relphot2 objName - ipptopsps : move to dvopsps? 3 objID + dvo:average.extID 4 ippObjID + dvo:(average.objID | average.catID << 32) 5 surveyID + ipptopsps : internal, from survey name 6 htmID - PSPS 7 zoneID - PSPS 8 tessID + average.tessID 9 projectionID + average.projectionID 10 skycellID + average.skycellID 11 randomID + ipptopsps : RANDOM from sql 12 batchID + ipptopsps : internal 13 dvoRegionID + dvo:average.catID 14 dataRelease + ipptopsps : user input (skychunk.dataRelease) 15 objInfoFlag + dvo:average.flags 16 qualityFlag - (dvo:average.flags >> 24) & 0xFF *** correct?? 17 consistencyFlag - *** hard-wired in ipptopsps to 0 18 raStack + dvo:average.Rstk *** not calculated? 19 decStack + dvo:average.Dstk *** not calculated? 20 raStackErr + dvo:average.dRstk *** not calculated? 21 decStackErr + dvo:average.dDstk *** not calculated? 22 raMean + dvo:average.R 23 decMean + dvo:average.D 24 raMeanErr + dvo:average.dR 25 decMeanErr + dvo:average.dD 26 posMeanChisq + dvo:average.ChiSqAve 27 ----------------- 28 -- 29 -- 30 -- 31 -- 32 -- 33 cx - PSPS 34 cy - PSPS 35 cz - PSPS 36 lambda - PSPS 37 beta - PSPS 38 l - PSPS 39 b - PSPS 40 ----------------- 41 nStackObjectRows - do in dvopsps 42 -- 43 nStackDetections - sum of secfilt.NstackDet (sum in sql) 44 nDetections + ipptopsps:Sum of ng+nr in sql 45 ng + dvo:secfilt.ncode ** check that this is right 46 nr + dvo:secfilt.ncode ** check that this is right 47 ni + dvo:secfilt.ncode ** check that this is right 48 nz + dvo:secfilt.ncode ** check that this is right 49 ny + dvo:secfilt.ncode ** check that this is right -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx
r37000 r37246 1 1 2 2 objID dimensionless BIGINT 8 NA ODM object identifier 3 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier4 3 ippObjID dimensionless BIGINT 8 NA ipp object identifier 5 surveyID dimensionless TINYINT 1 0 stack type identifier6 skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier7 4 randomStackObjID dimensionless BIGINT 8 NA random stack id 8 5 stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best … … 10 7 bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. 11 8 -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. 12 dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region13 dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded.14 9 ------------------------------------------------------- replicate to end for each filter g,r,i,z,y 15 10 gippDetectID dimensionless BIGINT 8 NA stack identifier … … 17 12 gstackMetaID dimensionless BIGINT 8 NA stack identifier 18 13 --------------------------------------------------------unconvolved 19 gflxR3 adu/secondsREAL 4 -999 Flux inside r = 320 gflxR3Err adu/secondsREAL 4 -999 estimated error is flxR321 gflxR3Std adu/secondsREAL 4 -999 estimated standard deviation in flxR314 gflxR3 Jy REAL 4 -999 Flux inside r = 3 15 gflxR3Err Jy REAL 4 -999 estimated error is flxR3 16 gflxR3Std Jy REAL 4 -999 estimated standard deviation in flxR3 22 17 gflxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 23 gflxR4 adu/secondsREAL 4 -999 Flux inside r = 424 gflxR4Err adu/secondsREAL 4 -999 estimated error is flxR425 gflxR4Std adu/secondsREAL 4 -999 estimated standard deviation in flxR418 gflxR4 Jy REAL 4 -999 Flux inside r = 4 19 gflxR4Err Jy REAL 4 -999 estimated error is flxR4 20 gflxR4Std Jy REAL 4 -999 estimated standard deviation in flxR4 26 21 gflxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 27 gflxR5 adu/secondsREAL 4 -999 Flux inside r = 528 gflxR5Err adu/secondsREAL 4 -999 estimated error is flxR529 gflxR5Std adu/secondsREAL 4 -999 estimated standard deviation in flxR522 gflxR5 Jy REAL 4 -999 Flux inside r = 5 23 gflxR5Err Jy REAL 4 -999 estimated error is flxR5 24 gflxR5Std Jy REAL 4 -999 estimated standard deviation in flxR5 30 25 gflxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 31 26 ---------------------------------------------------- convolved across all bands to 6 or 8 pixels 32 gc1flxR3 adu/secondsREAL 4 -999 Flux inside r = 333 gc1flxR3Err adu/secondsREAL 4 -999 estimated error is c1flxR334 gc1flxR3Std adu/secondsREAL 4 -999 estimated standard deviation in c1flxR327 gc1flxR3 Jy REAL 4 -999 Flux inside r = 3 28 gc1flxR3Err Jy REAL 4 -999 estimated error is c1flxR3 29 gc1flxR3Std Jy REAL 4 -999 estimated standard deviation in c1flxR3 35 30 gc1flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 36 gc1flxR4 adu/secondsREAL 4 -999 Flux inside r = 437 gc1flxR4Err adu/secondsREAL 4 -999 estimated error is c1flxR438 gc1flxR4Std adu/secondsREAL 4 -999 estimated standard deviation in c1flxR431 gc1flxR4 Jy REAL 4 -999 Flux inside r = 4 32 gc1flxR4Err Jy REAL 4 -999 estimated error is c1flxR4 33 gc1flxR4Std Jy REAL 4 -999 estimated standard deviation in c1flxR4 39 34 gc1flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 40 gc1flxR5 adu/secondsREAL 4 -999 Flux inside r = 541 gc1flxR5Err adu/secondsREAL 4 -999 estimated error is c1flxR542 gc1flxR5Std adu/secondsREAL 4 -999 estimated standard deviation in c1flxR535 gc1flxR5 Jy REAL 4 -999 Flux inside r = 5 36 gc1flxR5Err Jy REAL 4 -999 estimated error is c1flxR5 37 gc1flxR5Std Jy REAL 4 -999 estimated standard deviation in c1flxR5 43 38 gc1flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 44 39 ---------------------------------------------------- convolved across all bands to 6 or 8 pixels 45 gc2flxR3 adu/secondsREAL 4 -999 Flux inside r = 346 gc2flxR3Err adu/secondsREAL 4 -999 estimated error in c2flxR347 gc2flxR3Std adu/secondsREAL 4 -999 estimated standard deviation in c2flxR340 gc2flxR3 Jy REAL 4 -999 Flux inside r = 3 41 gc2flxR3Err Jy REAL 4 -999 estimated error in c2flxR3 42 gc2flxR3Std Jy REAL 4 -999 estimated standard deviation in c2flxR3 48 43 gc2flxR3Fill dimensionless REAL 4 -999 estimated filling factor at R3 49 gc2flxR4 adu/secondsREAL 4 -999 Flux inside r = 450 gc2flxR4Err adu/secondsREAL 4 -999 estimated error in c2flxR451 gc2flxR4Std adu/secondsREAL 4 -999 estimated standard deviation in c2flxR444 gc2flxR4 Jy REAL 4 -999 Flux inside r = 4 45 gc2flxR4Err Jy REAL 4 -999 estimated error in c2flxR4 46 gc2flxR4Std Jy REAL 4 -999 estimated standard deviation in c2flxR4 52 47 gc2flxR4Fill dimensionless REAL 4 -999 estimated filling factor at R4 53 gc2flxR5 adu/secondsREAL 4 -999 Flux inside r = 554 gc2flxR5Err adu/secondsREAL 4 -999 estimated error in c2flxR555 gc2flxR5Std adu/secondsREAL 4 -999 estimated standard deviation in c2flxR548 gc2flxR5 Jy REAL 4 -999 Flux inside r = 5 49 gc2flxR5Err Jy REAL 4 -999 estimated error in c2flxR5 50 gc2flxR5Std Jy REAL 4 -999 estimated standard deviation in c2flxR5 56 51 gc2flxR5Fill dimensionless REAL 4 -999 estimated filling factor at R5 57 52 -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt
r37000 r37246 1 1 2 objID = dvo/addstar 3 gcObjID = dvo/addstar 4 ippObjID = dvo/addstar average.objID + (average.catID << 32) 5 surveyID = ipptopsps 6 skyCellID = smf header 7 randomStackObjID = ipptopsps 8 stackDetectRowID = PSPS ? 9 primaryDetection = dvo 10 bestDetection = dvo 11 -- = 12 dvoRegionID = dvo / catID 13 dataRelease = ipptopsps 14 ---------------- = 15 gippDetectID = dvo/addstar 16 gstackDetectID = dvopsps (see StackObject.txt) 17 gstackMetaID = dvopsps (see StackObject.txt) 18 ---------------- = 19 gflxR3 = smf 20 gflxR3Err = smf 21 gflxR3Std = smf 22 gflxR3Fill = smf 23 gflxR4 = smf 24 gflxR4Err = smf 25 gflxR4Std = smf 26 gflxR4Fill = smf 27 gflxR5 = smf 28 gflxR5Err = smf 29 gflxR5Std = smf 30 gflxR5Fill = smf 31 ---------------- = 32 gc1flxR3 = smf 33 gc1flxR3Err = smf 34 gc1flxR3Std = smf 35 gc1flxR3Fill = smf 36 gc1flxR4 = smf 37 gc1flxR4Err = smf 38 gc1flxR4Std = smf 39 gc1flxR4Fill = smf 40 gc1flxR5 = smf 41 gc1flxR5Err = smf 42 gc1flxR5Std = smf 43 gc1flxR5Fill = smf 44 ---------------- = 45 gc2flxR3 = smf 46 gc2flxR3Err = smf 47 gc2flxR3Std = smf 48 gc2flxR3Fill = smf 49 gc2flxR4 = smf 50 gc2flxR4Err = smf 51 gc2flxR4Std = smf 52 gc2flxR4Fill = smf 53 gc2flxR5 = smf 54 gc2flxR5Err = smf 55 gc2flxR5Std = smf 56 gc2flxR5Fill = smf 2 objID + from StackObjectThin 3 ippObjID + from StackObjectThin 4 randomStackObjID + from StackObjectThin 5 stackDetectRowID - PSPS 6 primaryDetection - from StackObjectThin NOT YET TESTED 7 bestDetection - from StackObjectThin CANNOT BE SET until after PV3 8 -- 9 ---------------- 10 gippDetectID + from StackObjectThin 11 gstackDetectID + from StackObjectThin 12 gstackMetaID + from StackObjectThin 13 ---------------- 14 gflxR3 + cmf : APER_FLUX_3 15 gflxR3Err + cmf : APER_FLUX_ERR_3 16 gflxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf 17 gflxR3Fill + cmf : APER_FILL_3 18 gflxR4 + cmf : APER_FLUX_4 19 gflxR4Err + cmf : APER_FLUX_ERR_4 20 gflxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf 21 gflxR4Fill + cmf : APER_FILL_4 22 gflxR5 + cmf : APER_FLUX_5 23 gflxR5Err + cmf : APER_FLUX_ERR_5 24 gflxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf 25 gflxR5Fill + cmf : APER_FILL_5 26 ---------------- 27 gc1flxR3 + cmf : APER_FLUX_3 28 gc1flxR3Err + cmf : APER_FLUX_ERR_3 29 gc1flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf 30 gc1flxR3Fill + cmf : APER_FILL_3 31 gc1flxR4 + cmf : APER_FLUX_4 32 gc1flxR4Err + cmf : APER_FLUX_ERR_4 33 gc1flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf 34 gc1flxR4Fill + cmf : APER_FILL_4 35 gc1flxR5 + cmf : APER_FLUX_5 36 gc1flxR5Err + cmf : APER_FLUX_ERR_5 37 gc1flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf 38 gc1flxR5Fill + cmf : APER_FILL_5 39 ---------------- 40 gc2flxR3 + cmf : APER_FLUX_3 41 gc2flxR3Err + cmf : APER_FLUX_ERR_3 42 gc2flxR3Std - cmf : APER_FLUX_STDEV_3 : ** badly defined in cmf 43 gc2flxR3Fill + cmf : APER_FILL_3 44 gc2flxR4 + cmf : APER_FLUX_4 45 gc2flxR4Err + cmf : APER_FLUX_ERR_4 46 gc2flxR4Std - cmf : APER_FLUX_STDEV_4 : ** badly defined in cmf 47 gc2flxR4Fill + cmf : APER_FILL_4 48 gc2flxR5 + cmf : APER_FLUX_5 49 gc2flxR5Err + cmf : APER_FLUX_ERR_5 50 gc2flxR5Std - cmf : APER_FLUX_STDEV_5 : ** badly defined in cmf 51 gc2flxR5Fill + cmf : APER_FILL_5 -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV
r37000 r37246 1 1 2 2 objID dimensionless BIGINT 8 NA ODM object identifier 3 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier 4 surveyID dimensionless TINYINT 1 NA survey flag identifier 5 skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier 3 ippObjID dimensionless BIGINT 8 NA object ID generated by IPP 6 4 randomStackObjID dimensionless BIGINT 8 NA random stack id 7 5 stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best … … 9 7 bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. 10 8 -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. 11 dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region12 dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded13 9 -------------------------------------------------------- replicate below for all filters (grizy) 14 ippObjID dimensionless BIGINT 8 NA ipp object identifier15 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier 16 11 gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier 17 12 gstackMetaID dimensionless BIGINT 8 NA stack identifier 18 13 ---------------------------------------------------------------------------------------- 19 g deVRadius arcsec REAL 4 -999 deVaucouleurs radius20 g deVRadiusErr arcsec REAL 4 -999 estimated error in deVaucouleurs radius21 g deVFlux adu/seconds REAL 4 -999 deVaucouleurs flux22 g deVFluxErr adu/seconds REAL 4 -999 estimated error in deVaucouleurs flux23 g deVAb dimensionless REAL 4 -999 deVaucoulerus axis ratio24 g deVAbErr dimensionless REAL 4 -999 estimated error in deVaucoulerus axis ratio25 g deVPhi degrees REAL 4 -999 estmated phi of deVaucouleurs axis. Degrees East of North.26 g deVPhiErr degrees REAL 4 -999 estmated error of phi of deVaucouleurs axis27 graDeVOff arcsec REAL 4 -999 Offset in RA of deVaucouleurs fit from PSF RA28 gdecDeVOff arcsec REAL 4 -999 Offset in DEC of deVaucouleurs fit from PSF DEC14 gDeVRadius arcsec REAL 4 -999 DeVaucouleurs radius 15 gDeVRadiusErr arcsec REAL 4 -999 estimated error in DeVaucouleurs radius 16 gDeVMag AB_mag REAL 4 -999 DeVaucouleurs flux 17 gDeVMagErr AB_mag REAL 4 -999 estimated error in DeVaucouleurs flux 18 gDeVAb dimensionless REAL 4 -999 DeVaucoulerus axis ratio 19 gDeVAbErr dimensionless REAL 4 -999 estimated error in DeVaucoulerus axis ratio 20 gDeVPhi degrees REAL 4 -999 estmated phi of DeVaucouleurs axis. Degrees East of North. 21 gDeVPhiErr degrees REAL 4 -999 estmated error of phi of DeVaucouleurs axis 22 graDeVOff arcsec REAL 4 -999 Offset in RA of DeVaucouleurs fit from PSF RA 23 gdecDeVOff arcsec REAL 4 -999 Offset in DEC of DeVaucouleurs fit from PSF DEC 29 24 graDeVOffErr arcsec REAL 4 -999 estimated error in ra offset 30 25 gdecDeVOffErr arcsec REAL 4 -999 estimated error in dec offset 31 g deVCf dimensionless REAL 4 -999 deVaucouleurs fit coverage factor32 g deVLikelihood dimensionless REAL 4 -999 deVaucouleurs fit likelihood factor26 gDeVCf dimensionless REAL 4 -999 DeVaucouleurs fit coverage factor 27 gDeVLikelihood dimensionless REAL 4 -999 DeVaucouleurs fit likelihood factor -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp
r37000 r37246 1 1 2 2 objID dimensionless BIGINT 8 NA ODM object identifier 3 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier 4 surveyID dimensionless TINYINT 1 NA survey flag identifier 5 skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier 3 ippObjID dimensionless BIGINT 8 NA object ID generated by IPP 6 4 randomStackObjID dimensionless BIGINT 8 NA random stack id 7 5 stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best … … 9 7 bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. 10 8 -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. 11 dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region 12 dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded 13 -------------------------------------------------------- replicate below for all filters (grizy) 14 gippObjID dimensionless BIGINT 8 NA ipp object identifier 9 ------------------------------------------------------- replicate below for all filters (grizy) 15 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier 16 11 gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier 17 12 gstackMetaID dimensionless BIGINT 8 NA stack identifier 18 13 ---------------------------------------------------------------------------------------- 19 g expRadius arcsec REAL 4 -999 Exponential fit radius20 g expRadiusErr arcsec REAL 4 -999 estimated error in Exponential fit radius21 g expFlux adu/secondsREAL 4 -999 Exponential fit flux22 g expFluxErr adu/secondsREAL 4 -999 estimated error in expFlux23 g expAb dimensionless REAL 4 -999 Exponential fit axis ratio24 g expAbErr dimensionless REAL 4 -999 estimated error in Exponential fit axis ratio25 g expPhi degrees REAL 4 -999 estmated phi of Exponential axis26 g expPhiErr degrees REAL 4 -999 estmated error of phi of Exponential axis27 g raExpOff dimensionless REAL 4 -999 Offset in RA of Exponential fit from PSF RA28 g decExpOff dimensionless REAL 4 -999 Offset in DEC of Exponential fit from PSF DEC29 g raExpOffErr dimensionless REAL 4 -999 estimated error in raExpOff30 g decExpOffErr dimensionless REAL 4 -999 estimated error in decExpOff31 g expCf dimensionless REAL 4 -999 Exponential fit coverage factor32 g expLikelihood dimensionless REAL 4 -999 Exponential fit likelihood factor33 14 gExpRadius arcsec REAL 4 -999 Exponential fit radius 15 gExpRadiusErr arcsec REAL 4 -999 estimated error in Exponential fit radius 16 gExpMag AB_mag REAL 4 -999 Exponential fit flux 17 gExpMagErr AB_mag REAL 4 -999 estimated error in expFlux 18 gExpAb dimensionless REAL 4 -999 Exponential fit axis ratio (minor / major) 19 gExpAbErr dimensionless REAL 4 -999 estimated error in Exponential fit axis ratio 20 gExpPhi degrees REAL 4 -999 estmated phi of Exponential axis 21 gExpPhiErr degrees REAL 4 -999 estmated error of phi of Exponential axis 22 gExpRa degrees DOUBLE 8 -999 RA of Exponential fit 23 gExpDec degrees DOUBLE 8 -999 DEC of Exponential fit 24 gExpRaErr arcsec REAL 4 -999 estimated error in RA 25 gExpDecErr arcsec REAL 4 -999 estimated error in DEC 26 gExpCf dimensionless REAL 4 -999 Exponential fit coverage factor 27 gExpChisq dimensionless REAL 4 -999 Exponential fit chi square 28 -- gExpLikelihood dimensionless REAL 4 -999 Exponential fit likelihood factor -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer
r37000 r37246 1 1 2 2 objID dimensionless BIGINT 8 NA ODM object identifier 3 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier 4 surveyID dimensionless TINYINT 1 NA survey flag identifier 5 skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier 3 ippObjID dimensionless BIGINT 8 NA object ID generated by IPP 6 4 randomStackObjID dimensionless BIGINT 8 NA random stack id 7 5 stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best … … 9 7 bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. 10 8 -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. 11 dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region12 dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded13 9 -------------------------------------------------------- replicate below for all filters (grizy) 14 gippObjID dimensionless BIGINT 8 NA ipp object identifier15 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier 16 11 gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier 17 12 gstackMetaID dimensionless BIGINT 8 NA stack identifier 18 13 ---------------------------------------------------------------------------------------- 19 g serRadius arcsec REAL 4 -999 Sersic radius20 g serRadiusErr arcsed REAL 4 -999 estimated error in Sersic radius21 g serFlux adu/secondsREAL 4 -999 Sersic Flux22 g serFluxErr adu/secondsREAL 4 -999 estimated error in serFlux23 g serAb dimensionless REAL 4 -999 Sersic axis ratio24 g serAbErr dimensionlessn REAL 4 -999 estimated error in Sersic axis ratio25 g serNu dimensionlessn REAL 4 -999 Sersic index26 g serNuErr diemensionless REAL 4 -999 estimated error in Sersic index27 g serPhi degrees REAL 4 -999 estmated phi of Sersic axis28 g serPhiErr degrees REAL 4 -999 estmated error of phi of Sersic axis14 gSerRadius arcsec REAL 4 -999 Sersic radius 15 gSerRadiusErr arcsed REAL 4 -999 estimated error in Sersic radius 16 gSerMag AB_mag REAL 4 -999 Sersic Flux 17 gSerMagErr AB_mag REAL 4 -999 estimated error in serFlux 18 gSerAb dimensionless REAL 4 -999 Sersic axis ratio 19 gSerAbErr dimensionlessn REAL 4 -999 estimated error in Sersic axis ratio 20 gSerNu dimensionlessn REAL 4 -999 Sersic index 21 gSerNuErr diemensionless REAL 4 -999 estimated error in Sersic index 22 gSerPhi degrees REAL 4 -999 estmated phi of Sersic axis 23 gSerPhiErr degrees REAL 4 -999 estmated error of phi of Sersic axis 29 24 graSerOff dimensionless REAL 4 -999 Offset in RA of Sersic fit from PSF RA 30 25 gdecSerOff dimensionless REAL 4 -999 Offset in DEC of Sersic fit from PSF DEC -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin
r37000 r37246 1 1 2 objID dimensionless BIGINT 8 NA ODM object identifier 3 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier 4 surveyID dimensionless TINYINT 1 NA survey flag identifier 5 skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier 6 randomStackObjID dimensionless BIGINT 8 NA random stack id 7 stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best 8 primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. 9 bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. 10 the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. 11 dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region 12 dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. 2 objID dimensionless BIGINT 8 NA ODM object identifier 3 ippObjID dimensionless BIGINT 8 NA object ID generated by IPP [this is a per-object, not per-filter value] 4 surveyID dimensionless TINYINT 1 NA survey flag identifier 5 tessID dimensionless TINYINT 1 -1 ID mapping to tessellation names (eg, RINGS.V3, MD01.V3, etc) 6 projectionID dimensionless SMALLINT 2 -999 valid values 0 - < 10000 7 skyCellID dimensionless TINYINT 1 255 valid values 0 - 143 (12x12 grid) 8 randomStackObjID dimensionless BIGINT 8 NA random stack id 9 stackDetectRowID dimensionless BIGINT 8 NA identifies which of up to 5 possible stackdetctions this Row refers to: Primary, up to 3 Secondary, 1 best 10 primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. 11 bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. 12 -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. 13 dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region 14 dataRelease dimensionless TINYINT 1 NA Data release when this detection was originally taken. 13 15 ------------------------------------------------------------------------------------------ 14 16 -- attributes for all stack detections in all filters (these are currently forced anyway) 15 17 -- Replicate the section below for each filter, changing the prefex ("g" in this example) 16 18 ------------------------------------------------------------------------------------------ 17 gippObjID dimensionless BIGINT 8 NA object ID generated by IPP 18 gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP 19 gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier 20 gstackMetaID dimensionless BIGINT 8 NA stack identifier 19 gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP 20 gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier 21 gstackMetaID dimensionless BIGINT 8 NA stack identifier 21 22 ------------------------------------------------------------------------------------------ 22 gra degrees FLOAT 8 NA Right Ascension 23 gdec degrees FLOAT 8 NA Declination 24 graErr arcsec REAL 4 NA Right Ascension error 25 gdecErr arcsec REAL 4 NA Declination error (same as RA error - need?) 26 gzp magnitude REAL 4 0 zeropoint , no error given 27 gPSFMag AB_magnitude REAL 4 -999 g psf AB magnitude from stack 28 gPSFMagErr AB_magnitude REAL 4 -999 estimated error of g psf AB magnitude from stack 29 gApMag AB_magnitude REAL 4 -999 g Aperture AB magnitude from stack 30 gApMagErr AB_magnitude REAL 4 -999 estimated error of g Ap Mag AB magnitude from stack 31 gKronMag AB_magnitude REAL 4 -999 g kron AB magnitude from stack 32 gKronMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude from stack 33 gsky adu/secs/arcsec REAL 4 -999 PSF sky level at source (adu) 34 gskyErr adu/secs/arcsec REAL 4 -999 estimated error in sky 35 ginfoFlag dimensionless INT 4 -999 indicator of strange propeties 36 ginfoFlag2 dimensionless INT 4 -999 indicator of strange propeties 37 gnFrames dimensionless INT 4 -999 Number of frames contributing to source 23 gra degrees FLOAT 8 NA Right Ascension 24 gdec degrees FLOAT 8 NA Declination 25 graErr arcsec REAL 4 NA Right Ascension error 26 gdecErr arcsec REAL 4 NA Declination error (same as RA error - need?) 27 gPSFMag AB_magnitude REAL 4 -999 g psf AB magnitude from stack 28 gPSFMagErr AB_magnitude REAL 4 -999 estimated error of g psf AB magnitude from stack 29 gApMag AB_magnitude REAL 4 -999 g Aperture AB magnitude from stack 30 gApMagErr AB_magnitude REAL 4 -999 estimated error of g Ap Mag AB magnitude from stack 31 gKronMag AB_magnitude REAL 4 -999 g kron AB magnitude from stack 32 gKronMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude from stack 33 gsky adu/secs/arcsec REAL 4 -999 PSF sky level at source (adu) 34 gskyErr adu/secs/arcsec REAL 4 -999 estimated error in sky 35 ginfoFlag dimensionless INT 4 0 informational bits 36 ginfoFlag2 dimensionless INT 4 0 informational bits 37 gnFrames dimensionless INT 4 -999 Number of frames contributing to source 38 38 39 39 -- [220 byte/filter/obj + 44 byte/obj] -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/FrameMeta
r37000 r37246 1 frameID dimensionless INT 4 NAunique exposure/frame identifier.2 frameName dimensionless VARCHAR(32) 32 NAframe name provided by camera software3 surveyID dimensionless TINYINT 1 NAsurvey flag identifier4 filterID dimensionless TINYINT 1 NAfilter identifier5 cameraID dimensionless SMALLINT 2 NAcamera identifier6 cameraConfigID dimensionless SMALLINT 2 NAcamera configuration identifier7 telescopeID dimensionless SMALLINT 2 NAtelescope identifier8 analysisVer alphanumeric VARCHAR(MAX) 8000IPP software analysis release9 p1Recip alphanumeric VARCHAR(MAX) 8000IPP phase 1 MD5 Checksum10 p2Recip alphanumeric VARCHAR(MAX) 8000IPP phase 2 MD5 Checksum11 p3Recip alphanumeric VARCHAR(MAX) 8000IPP phase 3 MD5 Checksum12 nOTA alphanumeric SMALLINT 2 -999number of valid OTA/CCD images in this exposure13 photoScat magnitude REAL 4 -999global photometric scatter14 numPhotoRef dimensionless INT 4 -999number of photometric reference sources15 expStart days FLOAT 8 -999exposure start time in MJD16 expTime seconds REAL 4 -999exposure time17 airmass dimensionless REAL 4 -999airmass at mid-exposure18 raBore degrees FLOAT 8 -999RA of telescope boresight19 decBore degrees FLOAT 8 -999DEC of telescope boresight20 ctype1 alphanumeric VARCHAR(MAX) 8000name of astrometric projection in RA21 ctype2 VARCHAR(MAX) 8000name of astrometric projection in DEC22 crval1 degrees FLOAT 8 -999RA corresponding to reference pixel23 crval2 degrees FLOAT 8 -999DEC corresponding to reference pixel24 crpix1 pc001001 FLOAT 8 -999reference pixel value for RA25 crpix2 dimensionless FLOAT 8 -999reference pixel value for DEC26 cdelt1 degrees/pixel FLOAT 8 -999scale factor for RA27 cdelt2 degrees/pixel FLOAT 8 -999scale factor for DEC28 pc001001 dimensionless FLOAT 8 -999elements of rotation/Dcale matrix29 pc001002 dimensionless FLOAT 8 -999elements of rotation/Dcale matrix30 pc002001 dimensionless FLOAT 8 -999elements of rotation/Dcale matrix31 pc002002 dimensionless FLOAT 8 -999elements of rotation/Dcale matrix32 polyOrder dimensionless TINYINT 1 255polynomial order of astrometry fit33 pca1x3y0 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit34 pca1x2y1 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit35 pca1x1y2 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit36 pca1x0y3 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit37 pca1x2y0 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit38 pca1x1y1 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit39 pca1x0y2 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit40 pca2x3y0 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit41 pca2x2y1 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit42 pca2x1y2 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit43 pca2x0y3 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit44 pca2x2y0 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit45 pca2x1y1 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit46 pca2x0y2 dimensionless FLOAT 8 -999polynomial coefficients for the astrometric fit47 calibModNum dimensionless SMALLINT 2 NAcalibration modification number48 batchID dimensionless BIGINT 8 NAbatch ID49 dataRelease dimensionless TINYINT 1 NAData release Version of this table1 frameID dimensionless INT 4 NA unique exposure/frame identifier. 2 frameName dimensionless VARCHAR(32) 32 NA frame name provided by camera software 3 surveyID dimensionless TINYINT 1 NA survey flag identifier 4 filterID dimensionless TINYINT 1 NA filter identifier 5 cameraID dimensionless SMALLINT 2 NA camera identifier 6 cameraConfigID dimensionless SMALLINT 2 NA camera configuration identifier 7 telescopeID dimensionless SMALLINT 2 NA telescope identifier 8 analysisVer alphanumeric VARCHAR(MAX) 8000 NA IPP software analysis release 9 p1Recip alphanumeric VARCHAR(MAX) 8000 NA IPP phase 1 MD5 Checksum 10 p2Recip alphanumeric VARCHAR(MAX) 8000 NA IPP phase 2 MD5 Checksum 11 p3Recip alphanumeric VARCHAR(MAX) 8000 NA IPP phase 3 MD5 Checksum 12 nOTA alphanumeric SMALLINT 2 -999 number of valid OTA/CCD images in this exposure 13 photoScat magnitude REAL 4 -999 global photometric scatter 14 numPhotoRef dimensionless INT 4 -999 number of photometric reference sources 15 expStart days FLOAT 8 -999 exposure start time in MJD 16 expTime seconds REAL 4 -999 exposure time 17 airmass dimensionless REAL 4 -999 airmass at mid-exposure 18 raBore degrees FLOAT 8 -999 RA of telescope boresight 19 decBore degrees FLOAT 8 -999 DEC of telescope boresight 20 ctype1 alphanumeric VARCHAR(MAX) 8000 NA name of astrometric projection in RA 21 ctype2 alphanumeric VARCHAR(MAX) 8000 NA name of astrometric projection in DEC 22 crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel 23 crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel 24 crpix1 dimensionless FLOAT 8 -999 reference pixel value for RA 25 crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC 26 cdelt1 degrees/pixel FLOAT 8 -999 scale factor for RA 27 cdelt2 degrees/pixel FLOAT 8 -999 scale factor for DEC 28 pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 29 pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 30 pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 31 pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 32 polyOrder dimensionless TINYINT 1 255 polynomial order of astrometry fit 33 pca1x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 34 pca1x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 35 pca1x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 36 pca1x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 37 pca1x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 38 pca1x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 39 pca1x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 40 pca2x3y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 41 pca2x2y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 42 pca2x1y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 43 pca2x0y3 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 44 pca2x2y0 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 45 pca2x1y1 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 46 pca2x0y2 dimensionless FLOAT 8 -999 polynomial coefficients for the astrometric fit 47 calibModNum dimensionless SMALLINT 2 NA calibration modification number 48 batchID dimensionless BIGINT 8 NA batch ID 49 dataRelease dimensionless TINYINT 1 NA Data release Version of this table -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/ImageMeta
r37000 r37246 22 22 psfWidMinor arcsec REAL 4 -999 model PSF parameters at chip center 23 23 psfTheta degrees REAL 4 -999 model PSF parameters at chip center 24 momentXX pixels REAL 4 -999 moment XX 25 momentXY pixels REAL 4 -999 moment XY 26 momentYY pixels REAL 4 -999 moment YY 27 momentM3C pixels squared REAL 4 -999 moment M3C 28 momentM3S pixels squared REAL 4 -999 moment M3S 29 momentM4C pixels squared REAL 4 -999 moment M4C 30 momentM4S pixels squared REAL 4 -999 moment M4S 31 momentR1 pixels REAL 4 -999 moment R1 32 momentRH sqrt pixels REAL 4 -999 moment RH 33 apResid magnitide REAL 4 -999 corrected aperture residual 34 dapResid magnitide REAL 4 -999 scatter of aperture corrections 24 momentMajor pixels REAL 4 -999 momentMajor 25 momentMinor pixels REAL 4 -999 momentMinor 26 momentM2C pixels squared REAL 4 -999 momentM2C 27 momentM2S pixels squared REAL 4 -999 momentM2S 28 momentM3 pixels squared REAL 4 -999 momentM3 29 momentM4 pixels squared REAL 4 -999 momentM4 30 apResid magnitude REAL 4 -999 corrected aperture residual 31 dapResid magnitude REAL 4 -999 scatter of aperture corrections 35 32 detectorID alphanumeric VARCHAR(32) 32 identifier for actual CCD chip 36 33 qaFlags dimensionless BIGINT 8 -999 Q/A flags for this OTA -
trunk/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta
r37000 r37246 1 stackMetaID dimensionless BIGINT 8 NA stack identifier 2 batchID dimensionless BIGINT 8 NA batch identifier 3 surveyID dimensionless TINYINT 1 NA survey flag identifier 4 filterID dimensionless TINYINT 1 NA fnilutemr eidriecnatl ifidier 5 stackTypeID dimensionless TINYINT 1 0 stack type identifier 6 skyCellID dimensionless REAL 4 NA skycell region identifier 7 photoCalID dimensionless INT 4 NA photometry code 8 magSat dimensionless REAL 4 -999 saturation magnitude level 9 analVer dimensionless SMALLINT 2 -999 analysis version index 10 expTime seconds REAL 4 -999 exposure time 11 nP2Images dimensionless SMALLINT 2 -999 number of P2 images contributing to this cell 12 completMag magnitudes REAL 4 -999 95% completion level in mag 13 astroScat dimensionless REAL 4 -999 astrometric scatter for chip 14 photoScat dimensionless REAL 4 -999 photometric scatter for chip 15 nAstroRef dimensionless INT 4 -999 number of astrometric reference sources 16 nPhoRef dimensionless INT 4 -999 number of photometric reference sources 17 psfModelID dimensionless VARCHAR(MAX) 8000 PSF model identifier 18 psfFwhm_mean arcsec FLOAT 8 -999 mean PSF FWHM in the stack 19 psfFwhm_max arcsec FLOAT 8 -999 maximum PSF FWHM in the stack 20 photoZero magnitudes REAL 4 -999 local derived photometric zero point 21 photoColor magnitudes REAL 4 -999 local derived photometric color term 22 ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA 23 ctype2 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in DEC 24 crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel 25 crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel 26 crpix1 dimensionless FLOAT 8 -999 reference pixel value for RA 27 crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC 28 cdelt1 deg/pixel FLOAT 8 -999 scale factor for RA 29 cdelt2 deg/pixel FLOAT 8 -999 scale factor for DEC 30 pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 31 pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 32 pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 33 pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 34 calibModNum dimensionless SMALLINT 2 NA calibration modification number 35 dataRelease dimensionless TINYINT 1 NA Data release 1 stackMetaID dimensionless BIGINT 8 NA stack identifier 2 batchID dimensionless BIGINT 8 NA batch identifier 3 surveyID dimensionless TINYINT 1 NA survey flag identifier 4 filterID dimensionless TINYINT 1 NA filter number identifier 5 stackTypeID dimensionless TINYINT 1 0 stack type identifier 6 tessID dimensionless TINYINT 1 -1 ID mapping to tessellation names (eg, RINGS.V3, MD01.V3, etc) 7 projectionID dimensionless SMALLINT 2 -999 valid values 0 - < 10000 8 skyCellID dimensionless TINYINT 1 255 valid values 0 - 143 (12x12 grid) 9 photoCalID dimensionless INT 4 NA photometry code 10 magSat dimensionless REAL 4 -999 saturation magnitude level 11 analysisVer dimensionless INT 4 -999 analysis version index x 12 expTime seconds REAL 4 -999 exposure time 13 nP2Images dimensionless SMALLINT 2 -999 number of P2 images contributing to this cell 14 completMag magnitudes REAL 4 -999 95% completion level in mag 15 astroScat dimensionless REAL 4 -999 astrometric scatter for chip 16 photoScat dimensionless REAL 4 -999 photometric scatter for chip 17 nAstroRef dimensionless INT 4 -999 number of astrometric reference sources 18 nPhotomRef dimensionless INT 4 -999 number of photometric reference sources 19 psfModelID dimensionless VARCHAR(MAX) 8000 PSF model identifier 20 psfFwhm_mean arcsec FLOAT 8 -999 mean PSF FWHM in the stack 21 psfFwhm_max arcsec FLOAT 8 -999 maximum PSF FWHM in the stack 22 photoZero magnitudes REAL 4 -999 local derived photometric zero point 23 photoColor magnitudes REAL 4 -999 local derived photometric color term 24 ctype1 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in RA 25 ctype2 alphanumeric VARCHAR(MAX) 8000 name of astrometric projection in DEC 26 crval1 degrees FLOAT 8 -999 RA corresponding to reference pixel 27 crval2 degrees FLOAT 8 -999 DEC corresponding to reference pixel 28 crpix1 dimensionless FLOAT 8 -999 reference pixel value for RA 29 crpix2 dimensionless FLOAT 8 -999 reference pixel value for DEC 30 cdelt1 deg/pixel FLOAT 8 -999 scale factor for RA 31 cdelt2 deg/pixel FLOAT 8 -999 scale factor for DEC 32 pc001001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 33 pc001002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 34 pc002001 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 35 pc002002 dimensionless FLOAT 8 -999 elements of rotation/Dcale matrix 36 calibModNum dimensionless SMALLINT 2 NA calibration modification number 37 dataRelease dimensionless TINYINT 1 NA Data release
Note:
See TracChangeset
for help on using the changeset viewer.
