| | 1 | == Object (OB) batches == |
| | 2 | |
| | 3 | object batches now consist of 2 tables |
| | 4 | |
| | 5 | * ObjectThin |
| | 6 | * MeanObject |
| | 7 | |
| | 8 | --------------------------- |
| | 9 | === ObjectThin VOTable description of PSPS table ObjectThin === |
| | 10 | --------------------------- |
| | 11 | ||objName || dimensionless || VARCHAR(32) || NA ||IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S where x is leading number of procesing version|| |
| | 12 | ||objID || dimensionless || BIGINT 8 || NA ||ODM object identifier index|| |
| | 13 | ||gcobjID || dimensionless || BIGINT 8 || NA ||galactic coordinates ODM object identifier|| |
| | 14 | ||ippObjID || dimensionless || BIGINT 8 || NA ||IPP object number|| |
| | 15 | ||surveyID || dimensionless || TINYINT 1 || 255 ||Survey ID|| |
| | 16 | ||skyCellID || dimensionless || REAL 4 || -999 ||single float giving PrimaryCell.SkyCell identifier|| |
| | 17 | ||htmID || dimensionless || BIGINT 8 || NA ||HTM index|| |
| | 18 | ||zoneID || dimensionless || INT 4 || NA ||Zone index|| |
| | 19 | ||randomID || dimensionless || BIGINT 8 || 0 ||Random integer between 0 and 2^32 - 4,394,967,296|| |
| | 20 | ||batchID || dimensionless || INT 4 || -999 ||batch id|| |
| | 21 | ||dvoRegionID || dimensionless || REAL 4 || -999 ||identifier of dvo spatial region -dvo cat id|| |
| | 22 | ||dataRelease || dimensionless || TINYINT 1 || NA ||Data release version of this table|| |
| | 23 | ||objInfoFlag || dimensionless || BIGINT 8 || -999 ||flag indicating odd properties|| |
| | 24 | ||qualityFlag || dimensionless || TINYINT 1 || 0 ||subset of objInfoFlag - flags related to goodness of object|| |
| | 25 | ||consistencyFlag || dimensionless || SMALLINT 2 || 0 ||Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation|| |
| | 26 | ||raStack || degrees || FLOAT 8 || -999 ||Right Ascension - best weighted RA across filters from stack WHENEVER an object is detected in the stack|| |
| | 27 | ||decStack || degrees || FLOAT 8 || -999 ||Declination - best weighted DEC across filters from stack WHENEVER an object is detected in the stack|| |
| | 28 | ||raStackErr || arcsec || REAL 4 || -999 ||Error in stack Right Ascension, note will have a systematic floor, and is not necessarily the best ra,dec for all objects|| |
| | 29 | ||decStackErr || arcsec || REAL 4 || -999 ||Error in stack Declination, note will have a systematic floor, and is not necessarily the best ra,dec for all objects|| |
| | 30 | ||raMean || degrees || FLOAT 8 || -999 ||Right Ascension from the Mean of RA from individual detections if it exists. This is for information only|| |
| | 31 | ||decMean || degrees || FLOAT 8 || -999 ||Declination from the Mean of Dec from individual detections if it exists. This is for information only|| |
| | 32 | ||raMeanErr || arcsec || REAL 4 || -999 ||Combination of the measurement errors in the Right Ascension from the mean detections if they exist|| |
| | 33 | ||decMeanErr || arcsec || REAL 4 || -999 ||Combination of the measurement errors in the Declination measurements if they exist|| |
| | 34 | ||raMeanStd || arcsec || REAL 4 || -999 ||standard deviation of Right Ascension measuments in detections if they exist|| |
| | 35 | ||decMeanStd || arcsec || REAL 4 || -999 ||standard deviation of Declination measurements in detections if they exist|| |
| | 36 | ||cx || dimensionless || FLOAT 8 || NA ||Cartesian x from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't || |
| | 37 | ||cy || dimensionless || FLOAT 8 || NA ||Cartesian y from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't || |
| | 38 | ||cz || dimensionless || FLOAT 8 || NA ||Cartesian z from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't || |
| | 39 | ||lambda || degrees || FLOAT 8 || -999 || ecliptic longitude from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't|| |
| | 40 | ||beta || degrees || FLOAT 8 || -999 || ecliptic latitude from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't|| |
| | 41 | ||l || degrees || FLOAT 8 || -999 || galactic longitude from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't|| |
| | 42 | ||b || degrees || FLOAT 8 || -999 || galactic latitude from stack Ra, Dec WENEVER a stack detection exists, and Mean Ra, Dec (mean of one?) when it doesn't|| |
| | 43 | ||nStackObjectRows || dimensionless || SMALLINT 2 || -999 ||number of independent StackObjectRows this object has. 0 if not detected in the stack, 1 if there is a primary, 2 or more if it is in an overlap region|| |
| | 44 | ||nStackDetections || dimensionless || SMALLINT 2 || 255 ||which filter bands it is detected in (not forced) or if it was masked in a band.|| |
| | 45 | ||nDetections || dimensionless || SMALLINT 2 || -999 ||total number of detection measurements in all filters|| |
| | 46 | ||ng || dimensionless || SMALLINT 2 || -999 ||number of measures in g filter|| |
| | 47 | ||nr || dimensionless || SMALLINT 2 || -999 ||number of measures in r filter|| |
| | 48 | ||ni || dimensionless || SMALLINT 2 || -999 ||number of measures in i filter|| |
| | 49 | ||nz || dimensionless || SMALLINT 2 || -999 ||number of measures in z filter|| |
| | 50 | ||ny || dimensionless || SMALLINT 2 || -999 ||number of measures in y filter|| |
| | 51 | --------------------------- |
| | 52 | === MeanObject VOTable description of PSPS table MeanObject === |
| | 53 | --------------------------- |
| | 54 | ||objID || dimensionless || BIGINT 8 || NA ||ODM object identifier index|| |
| | 55 | ||gcobjID || dimensionless || BIGINT 8 || NA ||galactic coordinates ODM object identifier|| |
| | 56 | ||gQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available g band detections|| |
| | 57 | ||gMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean g psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| |
| | 58 | ||gMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available g-band psf AB magnitudes|| |
| | 59 | ||gnIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| |
| | 60 | ||gMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| |
| | 61 | ||gMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| |
| | 62 | ||gMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| |
| | 63 | ||gMeanKronMag || AB magnitude || REAL 4 || -999 ||mean g kron AB magnitude from best available measurements|| |
| | 64 | ||gMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean g kron AB magnitude|| |
| | 65 | ||gnIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| |
| | 66 | ||gMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 67 | ||gMeanApMag || AB magnitude || REAL 4 || -999 ||mean g aperture AB magnitude from best available measurements|| |
| | 68 | ||gMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean g aperture AB magnitude|| |
| | 69 | ||gnIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| |
| | 70 | ||gMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 71 | ||gFlags || dimensionless || BIGINT 8 || NA ||flags for g mean|| |
| | 72 | ||rQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available r band detections|| |
| | 73 | ||rMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean r psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| |
| | 74 | ||rMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available r-band psf AB magnitudes|| |
| | 75 | ||rnIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| |
| | 76 | ||rMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| |
| | 77 | ||rMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| |
| | 78 | ||rMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| |
| | 79 | ||rMeanKronMag || AB magnitude || REAL 4 || -999 ||mean r kron AB magnitude from best available measurements|| |
| | 80 | ||rMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean r kron AB magnitude|| |
| | 81 | ||rnIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| |
| | 82 | ||rMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 83 | ||rMeanApMag || AB magnitude || REAL 4 || -999 ||mean r aperture AB magnitude from best available measurements|| |
| | 84 | ||rMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean r aperture AB magnitude|| |
| | 85 | ||rnIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| |
| | 86 | ||rMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 87 | ||rFlags || dimensionless || BIGINT 8 || NA ||flags for r mean|| |
| | 88 | ||iQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available i band detections|| |
| | 89 | ||iMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean i psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| |
| | 90 | ||iMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available i-band psf AB magnitudes|| |
| | 91 | ||inIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| |
| | 92 | ||iMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| |
| | 93 | ||iMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| |
| | 94 | ||iMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| |
| | 95 | ||iMeanKronMag || AB magnitude || REAL 4 || -999 ||mean i kron AB magnitude from best available measurements|| |
| | 96 | ||iMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean i kron AB magnitude|| |
| | 97 | ||inIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| |
| | 98 | ||iMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 99 | ||iMeanApMag || AB magnitude || REAL 4 || -999 ||mean i aperture AB magnitude from best available measurements|| |
| | 100 | ||iMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean i aperture AB magnitude|| |
| | 101 | ||inIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| |
| | 102 | ||iMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 103 | ||iFlags || dimensionless || BIGINT 8 || NA ||flags for i mean|| |
| | 104 | ||zQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available z band detections|| |
| | 105 | ||zMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean z psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| |
| | 106 | ||zMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available z-band psf AB magnitudes|| |
| | 107 | ||znIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| |
| | 108 | ||zMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| |
| | 109 | ||zMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| |
| | 110 | ||zMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| |
| | 111 | ||zMeanKronMag || AB magnitude || REAL 4 || -999 ||mean z kron AB magnitude from best available measurements|| |
| | 112 | ||zMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean z kron AB magnitude|| |
| | 113 | ||znIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| |
| | 114 | ||zMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 115 | ||zMeanApMag || AB magnitude || REAL 4 || -999 ||mean z aperture AB magnitude from best available measurements|| |
| | 116 | ||zMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean z aperture AB magnitude|| |
| | 117 | ||znIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| |
| | 118 | ||zMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 119 | ||zFlags || dimensionless || BIGINT 8 || NA ||flags for z mean|| |
| | 120 | ||yQfPerfect || dimensionless || REAL 4 || -999 ||maximum psf QfPerfect from best available y band detections|| |
| | 121 | ||yMeanPSFMag || AB magnitude || REAL 4 || -999 ||mean y psf AB magnitude from best available measurements (best available as currently defined by ipp "waterfall logic"|| |
| | 122 | ||yMeanPSFMagErr || AB magnitude || REAL 4 || -999 ||estimated error of best available y-band psf AB magnitudes|| |
| | 123 | ||ynIncPSFMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean psfMag|| |
| | 124 | ||yMeanPSFMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements - compared with MeanErr this is one measure of true variability|| |
| | 125 | ||yMinPSFMag || AB magnitude || REAL 4 || -999 ||minimum best available PSFMag - min and max are given for PSFMag as they may indicate variability|| |
| | 126 | ||yMaxPSFMag || AB magnitude || REAL 4 || -999 ||maxiumum best available PSFMag|| |
| | 127 | ||yMeanKronMag || AB magnitude || REAL 4 || -999 ||mean y kron AB magnitude from best available measurements|| |
| | 128 | ||yMeanKronMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean y kron AB magnitude|| |
| | 129 | ||ynIncKronMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Kron Mag|| |
| | 130 | ||yMeanKronMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 131 | ||yMeanApMag || AB magnitude || REAL 4 || -999 ||mean y aperture AB magnitude from best available measurements|| |
| | 132 | ||yMeanApMagErr || AB magnitude || REAL 4 || -999 ||estimated error of mean y aperture AB magnitude|| |
| | 133 | ||ynIncApMag || dimensionless || SMALLINT 2 || -999 ||number of best available detections included in mean Ap Mag|| |
| | 134 | ||yMeanApMagStd || dimensionless || REAL 4 || -999 ||standard deviation of best available measurements|| |
| | 135 | ||yFlags || dimensionless || BIGINT 8 || NA ||flags for y mean|| |
