This table contains the different aperture identifiers for each observation. The values contained in this table are calculated when populating the pointing and slewing tables. However, since each aperture identifier for each pointing- or slewing within each observation is stored in these tables, this separate aperture id. table has been introduced to avoid duplicated values for a given observation and make searching on aperture identifiers faster. Note that the aperture identifiers from the slewing table still need to be introduced into the aperture identifier table.
Use
and Related Data
The following table represents the possible aperture identifiers and
their corresponding field-of-view, or aperture size in arcseconds. The
aperture identifier consists of three characters, of which the first represents
the instrument; C(AM), L(WS), P(HT) or S(WS), the second represents the
focal plane aperture and the third is used to distinguish between different
field-of-views having the same focal plane aperture for the same instrument.
|
|
|
| C1A | 192x192 |
| C1B | 96x96 |
| C1C | 48x48 |
| L1A | 84 |
| P1A | 52.71 |
| P1B | 77.9 |
| P1C | 98.55 |
| P1D | 119.18 |
| P1E | 126.06x126.06 |
| P1F | 179.92 |
| P1G | 4.58 |
| P1H | 8.18 |
| P1I | 10.77 |
| P1J | 13.75 |
| P1K | 18.79 |
| P1L | 29.02x31.17 |
| P1M | 22.92 |
| P2A | 130.64x130.64 |
| P2B | 178.77x178.77 |
| P3A | 24.29x24.29 |
| S1A | 14x20 |
| S1B | 14x27 |
| S1C | 10x39 |
| S2A | 14x20 |
| S2B | 14x27 |
| S2C | 10x39 |
| S3A | 14x20 |
| S3B | 20x27 |
| S3C | 20x33 |
| S4A | 17x40 |
Population
Populated, as part of the post-BKRP population, from the pointing and slewing tables.
A script file called aid.csh has been developed to build and
populate this table. This script takes the following arguments:
aid.csh:
This assumes that the table has been created in database icsa.aid.csh -build:
This builds the table from the pointing and slewing tables.aid.csh -build_all:
Since no intermediated tables are used, has the same functionality as the -build option.
| Columns |
| Name | Datatype | Null |
| obsno | int | No |
| aid | char(3) | No |
column aid
See Use and Related Data above.
column obsno
Observation number constructed as follows:
revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.
See SCREW 385 for more information.
|
Table Usage (MB) |
Distribution of Table Space |
|
Data |
1.03 |
Data |
30.67 % |
|
Indexes |
2.29 |
Indexes |
67.94 % |
|
Unused |
0.05 |
Unused |
1.39 % |
|
Total |
3.37 |
Number
of Rows |
96782 |
| Dependencies |
| Referencing Objects |
| Object Name | Object Type |
| dbo.aid.aid_nc_ix | INDEX |
| dbo.aid.aid_nc_ux | INDEX |
| Referenced Objects |
| Object Name | Object Type |
| DDL |
CREATE TABLE dbo.aid
(
obsno int NOT NULL,
aid char(3) NOT NULL
)
LOCK ALLPAGES
go