Changeset 37182
- Timestamp:
- Aug 4, 2014, 4:29:17 PM (12 years ago)
- Location:
- branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES
- Files:
-
- 2 added
- 16 edited
-
Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended (added)
-
Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt (added)
-
Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement (modified) (3 diffs)
-
Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackApFlx (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitDeV (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitExp (modified) (3 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitFlx (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC1 (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC2 (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitPet (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitSer (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackModelFitThin (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackObjectExtra (modified) (2 diffs)
-
Fundamental_IPP_Data_Product_Tables/StackObjectThin (modified) (1 diff)
-
Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt (modified) (3 diffs)
-
MetaData_Tables/StackMeta (modified) (1 diff)
-
MetaData_Tables/StackMeta.txt (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement
r37000 r37182 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 -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt
r37000 r37182 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 -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx
r37000 r37182 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 -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV
r37137 r37182 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 object ID generated by IPP 5 surveyID dimensionless TINYINT 1 NA survey flag 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 loaded14 9 -------------------------------------------------------- replicate below for all filters (grizy) 15 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp
r37162 r37182 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 object ID generated by IPP 5 surveyID dimensionless TINYINT 1 NA survey flag 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 region 13 dataRelease dimensionless TINYINT 1 NA Data release when this table was loaded 14 -------------------------------------------------------- replicate below for all filters (grizy) 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 … … 31 26 gExpCf dimensionless REAL 4 -999 Exponential fit coverage factor 32 27 gExpLikelihood dimensionless REAL 4 -999 Exponential fit likelihood factor 33 -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlx
r37137 r37182 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 object ID generated by IPP 5 surveyID dimensionless TINYINT 1 NA survey flag 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 loaded14 9 -------------------------------------------------------- replicate below for all filters (grizy) 15 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC1
r37137 r37182 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 object ID generated by IPP 5 surveyID dimensionless TINYINT 1 NA survey flag 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 loaded14 9 -------------------------------------------------------- replicate below for all filters (grizy) 15 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitFlxC2
r37137 r37182 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 object ID generated by IPP 5 surveyID dimensionless TINYINT 1 NA survey flag 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 loaded14 9 -------------------------------------------------------- replicate below for all filters (grizy) 15 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitPet
r37167 r37182 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 ippbjID 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 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer
r37137 r37182 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 object ID generated by IPP 5 surveyID dimensionless TINYINT 1 NA survey flag 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 loaded14 9 -------------------------------------------------------- replicate below for all filters (grizy) 15 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitThin
r37137 r37182 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 object ID generated by IPP 5 surveyID dimensionless TINYINT 1 NA survey flag 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 loaded14 9 -------------------------------------------------------- replicate below for all filters (grizy) 15 10 gippDetectID dimensionless BIGINT 8 NA ipp detect identifier -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectExtra
r37159 r37182 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 object ID generated by IPP 5 surveyID dimensionless TINYINT 1 NA survey flag 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 detection was originally taken.14 ------------------------------------------------------------------------------------------15 -- attributes for all stack detections in all filters (these are currently forced anyway)16 -- Replicate the section below for each filter, changing the prefex ("g" in this example)17 9 ------------------------------------------------------------------------------------------ 18 10 gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin
r37159 r37182 1 1 2 objID dimensionless BIGINT 8 NA ODM object identifier 3 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier 4 ippObjID dimensionless BIGINT 8 NA object ID generated by IPP [this is a per-object, not per-filter value] 5 surveyID dimensionless TINYINT 1 NA survey flag identifier 6 skyCellID dimensionless REAL 4 -999 single float giving PrimaryCell.SkyCell identifier 7 randomStackObjID dimensionless BIGINT 8 NA random stack id 8 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 primaryDetection dimensionless TINYINT 1 255 identifies if this row is a primary stack detection. True about 80% of time. 10 bestDetection dimensionless TINYINT 1 255 identifies if this row is a best detection or not. Also set if only a primary detection exists. 11 -- the Primary Dectection, 0 to 3 possible secondary dectections, and the "best" per filter. 12 dvoRegionID dimensionless INT 4 -999 identifier to dvo spatial region 13 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. 14 15 ------------------------------------------------------------------------------------------ 15 16 -- attributes for all stack detections in all filters (these are currently forced anyway) 16 17 -- Replicate the section below for each filter, changing the prefex ("g" in this example) 17 18 ------------------------------------------------------------------------------------------ 18 gippDetectID dimensionless BIGINT 8 NA detection ID generated by IPP19 gstackDetectID dimensionless BIGINT 8 NA ODM detection identifier20 gstackMetaID dimensionless BIGINT 8 NA stack identifier19 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 Ascension23 gdec degrees FLOAT 8 NA Declination24 graErr arcsec REAL 4 NA Right Ascension error25 gdecErr arcsec REAL 4 NA Declination error (same as RA error - need?)26 gPSFMag AB_magnitude REAL 4 -999 g psf AB magnitude from stack27 gPSFMagErr AB_magnitude REAL 4 -999 estimated error of g psf AB magnitude from stack28 gApMag AB_magnitude REAL 4 -999 g Aperture AB magnitude from stack29 gApMagErr AB_magnitude REAL 4 -999 estimated error of g Ap Mag AB magnitude from stack30 gKronMag AB_magnitude REAL 4 -999 g kron AB magnitude from stack31 gKronMagErr AB_magnitude REAL 4 -999 estimated error of g kron AB magnitude from stack32 gsky adu/secs/arcsec REAL 4 -999 PSF sky level at source (adu)33 gskyErr adu/secs/arcsec REAL 4 -999 estimated error in sky34 ginfoFlag dimensionless INT 4 0 informational bits35 ginfoFlag2 dimensionless INT 4 0 informational bits36 gnFrames dimensionless INT 4 -999 Number of frames contributing to source23 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 37 38 38 39 -- [220 byte/filter/obj + 44 byte/obj] -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt
r37177 r37182 1 1 2 2 objID = dvo = average.extID [calculated in addstar] 3 gcObjID = dvo = average.extIDgc *** NOT SET [DROP?]4 3 ippObjID = dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition] 5 4 surveyID = ipptopsps : internal, from survey name 6 skyCellID = *** we need to decide how we should store this 5 tessID = smf : TESS_ID (table mapping) 6 projectionID = smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) 7 skycellID = smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) 7 8 randomStackObjID = ipptopsps (RANDOM on sql into mysql) 8 9 stackDetectRowID = PSPS ? … … 10 11 bestDetection = dvo *** THIS CANNOT BE SET UNTIL LATER 11 12 = 12 dvoRegionID = dvo = average.catID *** NOT YET CARRIED IN FROM dvopsps13 dvoRegionID = dvo = measure.catID 13 14 dataRelease = ippToPsps : user input (skychunk.dataRelease) 14 15 -- … … 33 34 gskyErr = smf : SKY_SIGMA / exptime 34 35 ginfoFlag = smf : FLAGS 35 ginfoFlag2 = smf + dvo : FLAGS2 | secfilt.flags << 13 *** CHECK THIS36 ginfoFlag2 = smf + dvo : FLAGS2 | measure.flags << 13 *** CHECK THIS 36 37 gnFrames = smf : N_FRAMES -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta
r37177 r37182 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 analysisVer dimensionless SMALLINT 2 -999 analysis version index x 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 nPhotomRef 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 fnilutemr eidriecnatl ifidier 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 -
branches/eam_branches/ipp-20140717/ippToPsps/pspsschema/SchemaNew18.0/PSPS_TABLES/MetaData_Tables/StackMeta.txt
r37177 r37182 4 4 filterID | ipptopsps : internal, lookup from filter (griz) 5 5 stackTypeID | ipptopsps : internal, *** hard-wired name *** 6 skyCellID | *** we need to decide how we should store this. 6 tessID | smf : TESS_ID (table mapping) 7 projectionID | smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) 8 skycellID | smf : parse SKYCELL (skycell.NNN or skycell.MMMM.NNN) 7 9 photoCalID | dvo.images : photcode 8 10 magSat | * NOT SET
Note:
See TracChangeset
for help on using the changeset viewer.
