Object Type	Table
Datasource	IPMA
Database	icsa

Contains the GOES-8 and GOES-9 Uncorrected Alpha-Particles data from the type 'A' file, stored as 5 minute averages. 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.

Use and Related Data

Can be linked to an observation through the space_weather table using the id to link to this table and then the time (UTK) to link to an observation.

More space weather data for a given ID (and hence time) can also be retrieved for the following tables that also contain GOES-8 and 9 data:

corrected_proton
hepad
integral_proton
uncorrected_alpha
uncorrected_proton
xmagelectrons5

Population

Populated from GOES-8 and GOES-9 satellite data.

Columns

Name	Datatype	Null

id	int	No

a1	decimal(18,12)	No

a2	decimal(18,12)	No

a3	decimal(18,12)	No

a4	decimal(18,12)	No

a5	decimal(18,12)	No

a6	decimal(18,12)	No

column id

space weather id, a unique number identifying the time of the measurement through the space_weather table.

column a1

3.8 - 9.9 MeV (Alpha-particles/cm^2 sec sr MeV)

column a2

9.9 - 21.3 MeV (Alpha-particles/cm^2 sec sr MeV)

column a3

21.3 - 61.0 MeV (Alpha-particles/cm^2 sec sr MeV)

column a4

60.0 - 180 MeV (Alpha-particles/cm^2 sec sr MeV)

column a5

160.0 - 260 MeV (Alpha-particles/cm^2 sec sr MeV)

column a6

330.0 - 500 MeV (Alpha-particles/cm^2 sec sr MeV)

Table Usage (MB)

Distribution of Table Space

Data	8.29	Data	84.17 %
Indexes	1.48	Indexes	14.99 %
Unused	0.08	Unused	0.83 %
Total	9.85	Number of Rows	135792

Dependencies

Referencing Objects

Object Name Object Type

dbo.uncorrected_alpha.uncorrected_alpha_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.uncorrected_alpha 
(
    id int            NOT NULL,
    a1 decimal(18,12) NOT NULL,
    a2 decimal(18,12) NOT NULL,
    a3 decimal(18,12) NOT NULL,
    a4 decimal(18,12) NOT NULL,
    a5 decimal(18,12) NOT NULL,
    a6 decimal(18,12) NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.uncorrected_alpha.uncorrected_alpha_ux	INDEX