Validity of the pointing information in this table (UTC1 and UTC2) is derived by taking the time from the IIPH for a single pointing entry (the IIPH contains pointing entries with an interval of 0.5 seconds) and substracting 0.25 seconds to get UTC1 and adding 0.25 seconds to get UTC2.
Columns |
Name | Datatype | Null |
obsno | int | No |
pid | int | No |
ra | float | No |
dec | float | No |
roll | float | No |
mjd1 | float | No |
mjd2 | float | No |
utc1 | float | No |
utc2 | float | No |
utk1 | float | No |
utk2 | float | No |
aid | char(3) | No |
shape | char(1) | No |
column aid
Aperture id. Three characters: (i) instrument, (ii) aperture and (iii) aperture modifier.column dec
See table aperture id (aid) for more information about possible values etc.
Center point declination. Units: degrees.column mjd1
Expected start of pointing in Modified Julian Day.column mjd2
Expected end of pointing in Modified Julian Day.column obsno
Observation number constructed as follows:column pidrevolution number * 1000000 + target number * 1000 + observation sequence number * 10 + typeSee SCREW 385 for further details.
Pointing identifier. To distinguish multiple slewing (pointing) entries for the same observation (counting from zero).column ra
Center point right ascension. Units: hours.column roll
Center point roll angle. Units: degrees.column rpid
Raster point identifier ; first two digits corresponding to raster-points along the horizontal axis, second two digits corresponding to raster-points along the vertical axis (will be set to '0101' for standard, non-raster pointings).column shape
Shape of the aperture used:column utc1C Circular
R Rectangular.
Expected start of pointing in UTC since 1989.column utc2
Expected end of pointing in UTC since 1989.column utk1
Expected start of pointing in UTK. Calculated from utc1.column utk2
Expected end of pointing in UTK. Calculated from utc2.
Table Usage (MB) |
Distribution of Table Space |
Data |
909.89 |
Data |
86.83 % |
Indexes |
109.03 |
Indexes |
10.40 % |
Unused |
28.96 |
Unused |
2.76 % |
Total |
1047.89 |
Number
of Rows |
6616019 |
Dependencies |
Referencing Objects |
Object Name | Object Type |
dbo.slewing.slewing_cx | INDEX |
dbo.slewing.slewing_ux | INDEX |
Referenced Objects |
Object Name | Object Type |
DDL |
CREATE TABLE dbo.slewing
(
obsno int NOT NULL,
pid int NOT NULL,
ra float NOT NULL,
dec float NOT NULL,
roll float NOT NULL,
mjd1 float NOT NULL,
mjd2 float NOT NULL,
utc1 float NOT NULL,
utc2 float NOT NULL,
utk1 float NOT NULL,
utk2 float NOT NULL,
aid char(3) NOT NULL,
shape char(1) NOT NULL
)
LOCK ALLPAGES
go