Changes between Version 52 and Version 53 of ippToPsps_Object

Timestamp:

Oct 27, 2012, 7:26:56 AM (14 years ago)

Author:

heather

Comment:

--

ippToPsps_Object

@@ -43 +43 @@
 || raErr||arcsec||REAL||0.0|| Right Ascension error|| cpt file || RA_ERR ||
 || decErr||arcsec||REAL||0.0|| Declination error|| cpt file  || DEC_ERR ||
-|| ~~~cx~~~ '''gStackMetaId'''||unknown||'''INT 8'''||0||~~~Cartesian x~~~|| || ~~~populated during PSPS merge~~~ to be '''gstackmetaid''' ||
-|| ~~~cy~~~ '''rStackMetaId'''||unknown||'''INT 8'''||0||~~~Cartesian y~~~|| || ~~~populated during PSPS merge~~~ to be '''rstackmetaid''' ||
-|| ~~~cz~~~ '''iStackMetaId'''||unknown||'''INT 8'''||0||~~~Cartesian z~~~|| || ~~~populated during PSPS merge~~~ to be '''istackmetaid''' ||
+|| ~~~cx~~~ ||~~~unknown~~~||~~~INT 8~~~||~~~0~~~||~~~Cartesian x~~~|| || ~~~populated during PSPS merge~~~ these 5 columns were moved/relabeled to accomodate [filter]stackDetectId ||
+|| ~~~cy~~~ ||~~~unknown~~~||~~~INT 8~~~||~~~0~~~||~~~Cartesian y~~~|| || ~~~populated during PSPS merge~~~ ||
+|| ~~~cz~~~ ||~~~unknown~~~||~~~INT 8~~~||~~~0~~~||~~~Cartesian z~~~|| || ~~~populated during PSPS merge~~~ ||
 || 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 ||
-|| ~~~lsg~~~ '''zStackMetaId'''||unknown||'''INT 8'''||-999||~~~supergalactic longitude~~~|| || ~~~populated during PSPS merge~~~ to be '''zstackmetaid'''||
-|| ~~~bsg~~~ '''yStackMetaId'''||unknown||'''INT 8'''||-999||~~~supergalactic latitude~~~|| || ~~~populated during PSPS merge~~~ to be '''ystackmetaid'''||
+|| ~~~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 ||
-|| gStackPSFFluxErr||degree||FLOAT||-999|| gstack psf flux err|| cps|| FLUX_PSF_ERR -flux error for psf g stack measurements||
-|| rStackPSFFluxErr||degree||FLOAT||-999||r stack psf flux err||cps || FLUX_PSF_ERR -flux error for psf r stack measurements ||
-|| iStackPSFFluxErr||arcsec||REAL||-999|| i stack psf flux err|| cps|| FLUX_PSF_ERR -flux error for psf i stack measurements  ||
-|| zStackPSFFluxErr||arcsec||REAL||-999|| z stack psf flux err|| cps|| FLUX_PSF_ERR -flux error for psf z stack measurements ||
 || ng||unknown||SMALLINT||-999||number of measures in g filter|| cps file || NCODE ("number of detections in band")||
 ||  ||||||||||||||
@@ -68 +64 @@
 || end repeat of block||||||||||||||
 || ||||||||||||||
-||gStackPSFFlux ||mag||REAL||-999|| g psf flux stack|| cps file || FLUX_PSF||
-||rStackPSFFlux ||mag||REAL||-999|| r psf flux stack|| cps file  || FLUX_PSF||
-||iStackPSFFlux ||mag||REAL||-999||  i psf flux stack|| cps file || FLUX_PSF||
-|| zStackPSFFlux||mag||REAL||-999|| z psf flux stack|| cps file || FLUX_PSF||
+|| The block below is repeated for filters r, i, z, and y||||||||||||||
+||gStackPSFMag ||mag||REAL||-999|| g psf flux stack|| cps file || ~~~FLUX_PSF~~~  calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9||
+|| gStackPSFMagErr||degree||FLOAT||-999|| gstack psf flux err|| cps|| FLUX_PSF_ERR/FLUX_PSF  -flux error for psf g stack measurements||
+|| gStackKronMag||mag||REAL||-999|| g kron magnitude from stack frames|| cps ||  calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9||
 || gStackKronMagErr||mag||REAL||-999|| g stack kron mag err || cps file ||   FLUX_KRON_ERR /FLUX_KRON ||
-|| rStackKronMagErr||mag||REAL||-999|| r stack kron mag err|| cps file ||    FLUX_KRON_ERR /FLUX_KRON ||
-|| iStackKronMagErr||mag||REAL||-999|| i stack kron mag err||cps file  ||    FLUX_KRON_ERR /FLUX_KRON ||
-|| zStackKronMagErr||mag||REAL||-999|| z stack kron mag err ||cps file  ||   FLUX_KRON_ERR /FLUX_KRON ||
-|| gStackKronMag||mag||REAL||-999|| g kron magnitude from stack frames|| cps ||  calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9||
 || gFlags ||unknown||SMALLINT||-999|| g flags || cps || flags ||
-|| rStackKronMag ||mag||REAL||-999|| r kron magnitude from stack frames||cps ||  calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9 ||
-|| rFlags||unknown||SMALLINT||-999||r flags || cps||  flags || 
-|| iStackKronMag||mag||REAL||-999|| i kron magnitude from stack frames||cps ||  calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9||
-|| iFlags||unknown||SMALLINT||-999||i flags || cps ||  flags||
-|| zStackKronMag||mag||REAL||-999|| z kron magnitude from stack frames||cps ||  calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9||
-|| zFlags||unknown||SMALLINT||-999|| z flags || cps|| flags || 
-|| yStackKronMag||mag||REAL||-999|| y kron magnitude from stack frames||cps ||  calculated from stackKronMag (AB mag) = -2.5 * log(FLUX_KRON) + 8.9 ||
-|| yFlags||unknown||SMALLINT||-999||y flags || cps || flags || 
-|| yStackPSFFLux||unknown||REAL||-999|| y psf flux stack|| cps || FLUX_PSF ||
-|| yStackKronMagErr||unknown||REAL||-999||y stack kron flux err || cps || FLUX_KRON_ERR /FLUX_KRON  ||
-|| yStackPSFFluxErr||unknown||REAL||-999||y stack psf flux err|| cps || FLUX_PSF_ERR ||
+|| gStackDetectID ||unknown||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 ||