dbo.wavelengths_display

 

Object Type

Table

Datasource

IPMA

Database

icsa

 


This table contains information on the wavelengths of an observation for display purposes. The values in the 'wavelengths' table are ranges, and as such it is useful for searches for observations over a particular wavelength (or indeed wavelength range). However, for many observations a wavelength range does not make sense and a reference wavelength should be displayed instead.

See SPR 2823 ('Broad-band filters in PMA') for further details.

Use and Related Data

Wavelength ranges are related to a specific observation. The information in this table should be consistant (and for many observations, identical) with the information stored in the 'wavelengths' table.

Population

The information in this table is derived directly from the information in the 'wavelengths' table. See SPR 2823 for details.
Columns
Name Datatype Null
obsno int No
countno int No
lower int No
upper int Yes


column countno

     Index to distinguish between different entries for one observation.

column lower

     Lower wavelength. Units:microns/1000 (values are divided by 1000 to safe space, but in the ISO Data Archive UI, these values are shown in microns).

column obsno

     Observation number constructed as follows:

revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.
     Please see SCREW 385 for more information.

column upper

     Upper wavelength. Units: microns/1000 (values are divided by 1000 to safe space, but in the ISO Data Archive UI, these values are shown in microns).
 

Table Usage (MB)

Distribution of Table Space

 

Data

17.20

Data

34.68 %

Indexes

31.59

Indexes

63.69 %

Unused

0.81

Unused

1.63 %

Total

49.60

Number of Rows

706969

Dependencies
Referencing Objects
Object Name Object Type
dbo.wavelengths_display.wavelengths_display_nia_ix INDEX
dbo.wavelengths_display.wavelengths_display_ux INDEX
Referenced Objects
Object Name Object Type

DDL 

CREATE TABLE dbo.wavelengths_display 
(
    obsno   int NOT NULL,
    countno int NOT NULL,
    lower   int NOT NULL,
    upper   int NULL
)
LOCK ALLPAGES
go