Changes between Version 33 and Version 34 of ippToPSPSSAS39CZWNotes
- Timestamp:
- Sep 16, 2015, 1:13:25 PM (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ippToPSPSSAS39CZWNotes
v33 v34 38 38 39 39 == dvoRegionID == 40 41 It appears that the REAL/-999 version is more correct? 40 42 41 43 {{{ … … 51 53 52 54 == ForcedWarpExtended == 55 56 Should these be transitions to Janskies? 53 57 54 58 {{{ … … 68 72 69 73 == ImageMeta.nx/ny == 74 75 Proposal: Drop these columns, as they are currently incorrectly population, they will be identical for all rows, and the confuse the number of detection column names. 76 70 77 {{{ 71 78 nx ImageMeta pixels SMALLINT -999 "Image dimension in x." … … 76 83 77 84 == posImageID/negImageID == 85 86 I cannot find which columns these link to or reference. 87 78 88 {{{ 79 89 posImageID DiffMeta dimensionless BIGINT NA "positive image identifier" … … 82 92 83 93 == psfModelID == 94 95 Is the VARCHAR(100) version correct? 96 84 97 {{{ 85 98 psfModelID ForcedWarpMeta dimensionless VARCHAR(100) "PSF model identifier." … … 89 102 90 103 == skyCellID == 104 105 Which version/default is correct? Proposal: This column (skycellID), tessID, and projectionID should index a table like the GPC1.skycell table, which lists tessellation, skycell_id, ra, dec, l, b, and the width and height of the skycell on the sky. This information is currently unavailable in PSPS, and would make skycellID more useful. 106 91 107 {{{ 92 108 skyCellID DiffDetection dimensionless REAL -999 "Skycell region identifier." … … 102 118 103 119 == ForcedMeanObject/DiffDetections/ForcedWarpMeasurement.Xflags == 120 121 Can these all be converted to INT/0 columns? 122 104 123 {{{ 105 124 gFlags ForcedMeanObject dimensionless BIGINT NA "Information flag bitmask indicating details of the photometry from forced single epoch g filter detections. Values listed in ObjectInfoFlags." … … 128 147 129 148 == Qf/Cf == 149 150 These seem inconsistent. After asking Gene, he claims that no Cf parameters will be measured (and are scheduled to be dropped from the schema), so all coverage factors in PSPS will be Qf. 151 130 152 {{{ 131 153 gpetCf StackPetrosian dimensionless REAL -999 "Petrosian (1976) fit coverage factor for g filter stack detection." … … 144 166 145 167 == ra/dec == 168 169 Values seem to be consistently FLOAT, errors are consistently REAL, but the defaults are not consistent. Are these correct as is, or should the defaults be different? 170 146 171 {{{ 147 172 dec Detection degrees FLOAT NA "Declination."
