| videoTilePawPrints table with only good tile detections only and defaults |
| This view removes matches where there are pawprint detections but not a tile detection The details and SQL SELECT corresponding to this view are available here. |
| Name | Type | Length | Unit | Description | Default Value | Unified Content Descriptor |
|---|---|---|---|---|---|---|
| detectID | bigint | 8 | UID (unique over entire VSA via programme ID prefix) of this merged detection as assigned by merge algorithm | meta.id;meta.main | ||
| cuEventID | int | 4 | UID of curation event giving rise to this record | meta.bib | ||
| tileSetID | bigint | 8 | UID of the set of frames that this merged source comes from | meta.bib | ||
| ra | float | 8 | Degrees | Celestial Right Ascension | pos.eq.ra;meta.main | |
| dec | float | 8 | Degrees | Celestial Declination | pos.eq.dec;meta.main | |
| cx | float | 8 | unit vector of spherical co-ordinates | pos.distance;pos.cartesian.x | ||
| cy | float | 8 | unit vector of spherical co-ordinates | pos.distance;pos.cartesian.y | ||
| cz | float | 8 | unit vector of spherical co-ordinates | pos.distance;pos.cartesian.z | ||
| htmID | bigint | 8 | Hierarchical Triangular Mesh (HTM) index, 20 deep, for equatorial co-ordinates | pos.eq | ||
| l | float | 8 | Degrees | Galactic longitude | pos.galactic.lon | |
| b | float | 8 | Degrees | Galactic latitude | pos.galactic.lat | |
| lambda | float | 8 | Degrees | SDSS system spherical co-ordinate 1 | pos | |
| eta | float | 8 | Degrees | SDSS system spherical co-ordinate 2 | pos | |
| tlExtNum | tinyint | 1 | the extension number of the tile detection (should always be 2) | 2 | meta.id | |
| tlSeqNum | int | 4 | the running number of the tile detection | -99999999 | meta.id | |
| tlXi | real | 4 | arcsec | Offset of &As& detection from master position (+east/-west) | -0.9999995e9 | pos.eq.ra;arith.diff |
| tlEta | real | 4 | arcsec | Offset of &As& detection from master position (+north/-south) | -0.9999995e9 | pos.eq.dec;arith.diff |
| o1ExtNum | tinyint | 1 | the extension number of the O1 detection | 2 | meta.id | |
| o1SeqNum | int | 4 | the running number of the O1 detection | -99999999 | meta.id | |
| o1Xi | real | 4 | arcsec | Offset of O1 detection from master position (+east/-west) | -0.9999995e9 | pos.eq.ra;arith.diff |
| o1Eta | real | 4 | arcsec | Offset of O1 detection from master position (+north/-south) | -0.9999995e9 | pos.eq.dec;arith.diff |
| o2ExtNum | tinyint | 1 | the extension number of the O2 detection | 2 | meta.id | |
| o2SeqNum | int | 4 | the running number of the O2 detection | -99999999 | meta.id | |
| o2Xi | real | 4 | arcsec | Offset of O2 detection from master position (+east/-west) | -0.9999995e9 | pos.eq.ra;arith.diff |
| o2Eta | real | 4 | arcsec | Offset of O2 detection from master position (+north/-south) | -0.9999995e9 | pos.eq.dec;arith.diff |
| o3ExtNum | tinyint | 1 | the extension number of the O3 detection | 2 | meta.id | |
| o3SeqNum | int | 4 | the running number of the O3 detection | -99999999 | meta.id | |
| o3Xi | real | 4 | arcsec | Offset of O3 detection from master position (+east/-west) | -0.9999995e9 | pos.eq.ra;arith.diff |
| o3Eta | real | 4 | arcsec | Offset of O3 detection from master position (+north/-south) | -0.9999995e9 | pos.eq.dec;arith.diff |
| o4ExtNum | tinyint | 1 | the extension number of the O4 detection | 2 | meta.id | |
| o4SeqNum | int | 4 | the running number of the O4 detection | -99999999 | meta.id | |
| o4Xi | real | 4 | arcsec | Offset of O4 detection from master position (+east/-west) | -0.9999995e9 | pos.eq.ra;arith.diff |
| o4Eta | real | 4 | arcsec | Offset of O4 detection from master position (+north/-south) | -0.9999995e9 | pos.eq.dec;arith.diff |
| o5ExtNum | tinyint | 1 | the extension number of the O5 detection | 2 | meta.id | |
| o5SeqNum | int | 4 | the running number of the O5 detection | -99999999 | meta.id | |
| o5Xi | real | 4 | arcsec | Offset of O5 detection from master position (+east/-west) | -0.9999995e9 | pos.eq.ra;arith.diff |
| o5Eta | real | 4 | arcsec | Offset of O5 detection from master position (+north/-south) | -0.9999995e9 | pos.eq.dec;arith.diff |
| o6ExtNum | tinyint | 1 | the extension number of the O6 detection | 2 | meta.id | |
| o6SeqNum | int | 4 | the running number of the O6 detection | -99999999 | meta.id | |
| o6Xi | real | 4 | arcsec | Offset of O6 detection from master position (+east/-west) | -0.9999995e9 | pos.eq.ra;arith.diff |
| o6Eta | real | 4 | arcsec | Offset of O6 detection from master position (+north/-south) | -0.9999995e9 | pos.eq.dec;arith.diff |
| tileSetSeqNum | int | 4 | Running number of the match in this tile set | -99999999 | meta.bib | |
| Total length | 195 |