Object Type	Table
Datasource	IPMA
Database	icsa

This table is the entry point into data concerning the solar weather at the time of an observation. It contains the times (in both UTK and standard notation) for which averaged space weather data is available, together with an ID for this time which is a link to the tables containing the space weather data itself.

Space weather data is stored for the preiod 11/95 to 5/98. The data stored in the period 11/95 to 3/96 (inclusive) is from the GOES-8 satellite, and from 4/96 to 5/98 is from the GOES-9 satellite.

The following data is stored:
         GOES X-ray, Mag., Electrons & Uncorrected Proton Channels (type 'G')
         GOES X-ray, Mag., Electrons & Corrected Proton Channels (type 'Z')
         GOES X-ray, Mag., Electrons & Corrected Integral Protons (type 'I')
         GOES X-ray, Mag., Electrons & HEPAD (type 'H')
         GOES X-ray, Mag., Electrons & Uncorrected Alpha-Particles (type 'A')

Type 'G' data is stored in both 1 and 5 minute averages, all other types are stored as 5 minute averages.

Please see the GOES data documentation for furhter information on this subject.

Use and Related Data

This table links an observation to a space weather ID through the time fields. The Space weather ID can then be used to retrieve space weather from the following tables which contain the data taken from the GOES-8 and 9 satellites:

      corrected_proton: the data from the Corrected Proton Channels in the
        type 'Z' file, stored as 5 minute averages.

        hepad: the HEPAD data from the type 'H' file, stored as 5 minute
        averages.

        integral_proton: the Corrected Integral Proton data from the type 'I'
        file, stored as 5 minute averages.

        uncorrected_alpha: the Uncorrected Alpha-Particles data from the type
        'A' file, stored as 5 minute averages.

        uncorrected_proton: the Uncorrected Proton Channels data from the
        type 'G' file, stored as 5 minute averages.

        xmagelectrons1: the X-ray, Mag., and Electrons data from the type
        'G' file, stored as 1 minute averages.

        xmagelectrons5: the X-ray, Mag., and Electrons data from the type
        'Z' file (same as in other types), stored as 5 minute averages.

Population

See SCREW 433 for further information.

Columns

Name	Datatype	Null

id	int	No

date	smalldatetime	No

utk	int	No

column id

space weather id - a unique number identifying the time of space weather measurements

column date

The time of the measurement (or averages).

column utk

The (above) time field converted to Universal Time Key.

Table Usage (MB)

Distribution of Table Space

Data	10.53	Data	32.36 %
Indexes	21.91	Indexes	67.38 %
Unused	0.08	Unused	0.25 %
Total	32.52	Number of Rows	678960

Dependencies

Referencing Objects

Object Name Object Type

dbo.space_weather.space_weather_ux1 INDEX

dbo.space_weather.space_weather_ux2 INDEX

dbo.space_weather.space_weather_ux3 INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.space_weather 
(
    id   int           NOT NULL,
    date smalldatetime NOT NULL,
    utk  int           NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.space_weather.space_weather_ux1	INDEX
dbo.space_weather.space_weather_ux2	INDEX
dbo.space_weather.space_weather_ux3	INDEX