dbo.slewing

 

Object Type

Table

Datasource

IPMA

Database

icsa

 

Position information for each 'non-fixed' pointing (slewing) observation. Note that the Aperture Shape can either be a 'R'ectangle or a 'C'ircle. Multiple pointing entries can exist for observations. These entries are distinguished by the position identifier (pid) column.

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.

Use and Related Data

See SCREW 358: Population of the PMA slewing Table.

Population

This table has been populated during BKRP by the OLP Post Processor (PPR).
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.
See table aperture id (aid) for more information about possible values etc.
column dec
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:
revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type
See SCREW 385 for further details.
column pid
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:
C     Circular
R     Rectangular.
column utc1
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