Changes between Version 54 and Version 55 of ippToPsps_Object

Timestamp:

Nov 10, 2012, 9:39:18 PM (14 years ago)

Author:

chambers

Comment:

--

ippToPsps_Object

@@ -30 +30 @@
 || '''Object''' ||||||||||||||
 || '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
-|| objID||unknown||BIGINT||0||ODM object identifier index|| cpt file || EXT_ID ||
-|| ippObjID||unknown||BIGINT||0||IPP object number|| cpt file ||CAT_ID*1000000000 + OBJ_ID ||
-|| projectionCellID||unknown||INT||-999||projection cell identifier at discovery time|| || ||
-|| htmID||unknown||BIGINT||0||HTM index|| || to be DROPPED from table ||
-|| zoneID||unknown||INT||0||Zone index|| ||to be DROPPED from table ||
-|| stackVer||unknown||SMALLINT||-999 -||static stack version number|| || ||
-|| objInfoFlag||unknown||BIGINT||-999||flag indicating odd properties|| || ||
-|| varFlag||unknown||TINYINT||0||variable in difference image detections|| || ||
-|| surveyID||unknown||TINYINT||255||Survey ID|| config || as set in the ippToPsps config ||
-|| ra||degree||FLOAT||0|| Right Ascension|| cpt file || RA - where this is the RA at the reference epoch. Defaults to RA in stack if not seen in frames ||
-|| dec||degree||FLOAT||0|| Declination|| cpt file || DEC - where this is the Dec at the reference epoch. Defaults to Dec in stack if not seen in frames||
+|| objID||dimensionless||BIGINT||0||ODM object identifier index|| cpt file || EXT_ID ||
+|| ippObjID||dimensionless||BIGINT||0||IPP object number|| cpt file ||CAT_ID*1000000000 + OBJ_ID ||
+|| projectionCellID||dimensionless||INT||-999||projection cell identifier at discovery time|| || ||
+|| htmID||dimensionless||BIGINT||0||HTM index|| || to be DROPPED from table ||
+|| zoneID||dimensionless||INT||0||Zone index|| ||to be DROPPED from table ||
+|| stackVer||dimensionless||SMALLINT||-999 -||static stack version number|| || ||
+|| objInfoFlag||dimensionless||BIGINT||-999||flag indicating odd properties|| || ||
+|| varFlag||dimensionless||TINYINT||0||variable in difference image detections|| || ||
+|| surveyID||dimensionless||TINYINT||255||Survey ID|| config || as set in the ippToPsps config ||
+|| ra||degrees||FLOAT||0|| Right Ascension|| cpt file || RA - where this is the RA at the reference epoch. Defaults to RA in stack if not seen in frames ||
+|| dec||degrees||FLOAT||0|| Declination|| cpt file || DEC - where this is the Dec at the reference epoch. Defaults to Dec in stack if not seen in frames||
 || raErr||arcsec||REAL||0.0|| Right Ascension error|| cpt file || RA_ERR ||
 || decErr||arcsec||REAL||0.0|| Declination error|| cpt file  || DEC_ERR ||
@@ -48 +48 @@
 || lambda||degree||FLOAT||-999|| ecliptic longitude|| || populated during PSPS merge ||
 || beta||degree||FLOAT||-999|| ecliptic latitude|| || populated during PSPS merge ||
-|| l||degree||FLOAT||-999|| galactic longitude|| || populated during PSPS merge ||
-|| b||degree||FLOAT||-999|| galactic latitude|| || populated during PSPS merge ||
+|| l ||degrees||FLOAT||-999|| galactic longitude|| || populated during PSPS merge ||
+|| b ||degrees||FLOAT||-999|| galactic latitude|| || populated during PSPS merge ||
 || ~~~lsg~~~||~~~unknown~~~||~~~'''INT 8'''~~~||~~~-999~~~||~~~supergalactic longitude~~~|| || ~~~populated during PSPS merge~~~ ||
 || ~~~bsg~~~ ||~~~unknown~~~||~~~'''INT 8'''~~~||~~~-999~~~||~~~supergalactic latitude~~~|| || ~~~populated during PSPS merge~~~||
-|| nDetections||unknown||SMALLINT||-999||total number of detection measurements in all filters|| cpt file || sum of NCODE for different filters in dvo ||
-|| ng||unknown||SMALLINT||-999||number of measures in g filter|| cps file || NCODE ("number of detections in band")||
+|| nDetections||dimensionless||SMALLINT||-999||total number of detection measurements in all filters|| cpt file || sum of NCODE for different filters in dvo ||
+|| ng||dimensionless||SMALLINT||-999||number of measures in g filter|| cps file || NCODE ("number of detections in band")||
 ||  ||||||||||||||
 || The block below is repeated for filters r, i, z, y and w ||||||||||||||
@@ -70 +70 @@
 || gStackKronMagErr||mag||REAL||-999|| g stack kron mag err || cps file ||   FLUX_KRON_ERR /FLUX_KRON ||
 || gFlags ||unknown||SMALLINT||-999|| g flags || cps || flags ||
-|| gStackDetectID ||unknown||BIGINT||-999|| stackdetect id to map back to stackdetection table||cps or cpt || STACK_DETECT_ID ||
+|| gStackDetectID ||dimensionless||BIGINT||-999|| stackdetect id to map back to stackdetection table||cps or cpt || STACK_DETECT_ID ||
 || end repeat of block||||||||||||||
 || ||||||||||||||
-|| ~~~extra~~~ '''qf_perfect'''||unknown||REAL||-999|| qf_perfect|| cpt|| '''PSF_QF_PERFECT rename it qf_perfect''' ||
-|| sgSep||unknown||REAL||-999|| star/galaxy separator - true if any one color is|| cpt|| STARGAL_SEPrepresents fraction of time detections were 'extended' in P2s ||
-|| consistencyFlag||unknown||SMALLINT||0||Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation|| || ||
-|| dataRelease||unknown||TINYINT||0||Data release|| || ||
-|| updated||unknown||INT||-999||MJD of last update|| || ||
+|| ~~~extra~~~ '''qf_perfect'''||dimensionless||REAL||-999|| qf_perfect|| cpt|| '''PSF_QF_PERFECT rename it qf_perfect''' ||
+|| sgSep||dimensionless||REAL||-999|| star/galaxy separator - true if any one color is|| cpt|| STARGAL_SEPrepresents fraction of time detections were 'extended' in P2s ||
+|| consistencyFlag||dimensionless||SMALLINT||0||Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation|| || ||
+|| dataRelease||Mean Julian Day||TINYINT||0||Data release|| || ||
+|| updated||Mean Julian Day||INT||-999||MJD of last update|| || ||