| | 1 | == Diff Object (DO) batches == |
| | 2 | |
| | 3 | Diff Object batches (new for PV2) have one table |
| | 4 | |
| | 5 | * DiffDetObject |
| | 6 | |
| | 7 | --------------------------- |
| | 8 | === DiffDetObject VOTable description of PSPS table DifDetObject === |
| | 9 | --------------------------- |
| | 10 | ||diffObjName || alphanumeric || VARCHAR(100) || NA ||IAU Name constructed from objID position PS1.x JHHMMSS.SS+/-|| |
| | 11 | ||diffObjID || dimensionless || BIGINT 8 || NA ||ODM object identifier index|| |
| | 12 | ||diffgcobjID || dimensionless || BIGINT 8 || NA ||galactic coordinates ODM object identifier|| |
| | 13 | ||ippObjID || dimensionless || BIGINT 8 || NA ||IPP object number|| |
| | 14 | ||surveyID || dimensionless || TINYINT 1 || 255 ||Survey ID|| |
| | 15 | ||skyCellID || dimensionless || REAL 4 || -999 ||single float giving PrimaryCell.SkyCell identifier|| |
| | 16 | ||htmID || dimensionless || BIGINT 8 || NA ||HTM index|| |
| | 17 | ||zoneID || dimensionless || INT 4 || NA ||Zone index|| |
| | 18 | ||randomID || dimensionless || BIGINT 8 || 0 ||Random integer between 0 and 2^32 = 4,394,967,296|| |
| | 19 | ||batchID || dimensionless || INT 4 || -999 ||batchID|| |
| | 20 | ||dvoRegionID || dimensionless || REAL 4 || -999 ||identifier to dvo spatial region|| |
| | 21 | ||objInfoFlag || dimensionless || BIGINT 8 || -999 ||flag indicating odd properties|| |
| | 22 | ||qualityFlag || dimensionless || TINYINT 1 || 0 ||subset of objInfoFlag - flags related to goodness of object|| |
| | 23 | ||consistencyFlag || dimensionless || SMALLINT 2 || 0 ||Value computed from associated detections, it is originally given by IPP and should agree with the ODM validation|| |
| | 24 | ||ra || degrees || FLOAT 8 || NA || Right Ascension|| |
| | 25 | ||dec || degrees || FLOAT 8 || NA || Declination|| |
| | 26 | ||raErr || arcsec || REAL 4 || 0.0 || Right Ascension error|| |
| | 27 | ||decErr || arcsec || REAL 4 || 0.0 || Declination error|| |
| | 28 | ||cx || dimensionless || FLOAT 8 || NA ||Cartesian x || |
| | 29 | ||cy || dimensionless || FLOAT 8 || NA ||Cartesian y || |
| | 30 | ||cz || dimensionless || FLOAT 8 || NA ||Cartesian z || |
| | 31 | ||lambda || degrees || FLOAT 8 || -999 || ecliptic longitude|| |
| | 32 | ||beta || degrees || FLOAT 8 || -999 || ecliptic latitude|| |
| | 33 | ||l || degrees || FLOAT 8 || -999 || galactic longitude|| |
| | 34 | ||b || degrees || FLOAT 8 || -999 || galactic latitude|| |
| | 35 | ||qfPerfect || dimensionless || REAL 4 || -999 ||qf perfect|| |
| | 36 | ||dataRelease || dimensionless || TINYINT 1 || NA ||Data release|| |
| | 37 | ||nDetections || dimensionless || SMALLINT 2 || -999 ||total number of detection measurements in all filters|| |
| | 38 | ||ng || dimensionless || SMALLINT 2 || -999 ||number of measures in g filter|| |
| | 39 | ||nr || dimensionless || SMALLINT 2 || -999 ||number of measures in r filter|| |
| | 40 | ||ni || dimensionless || SMALLINT 2 || -999 ||number of measures in i filter|| |
| | 41 | ||nz || dimensionless || SMALLINT 2 || -999 ||number of measures in z filter|| |
| | 42 | ||ny || dimensionless || SMALLINT 2 || -999 ||number of measures in y filter|| |
