Object Type	Table
Datasource	IPMA
Database	icsa

Contains the HEPAD data from the GOES-8 and GOES-9 type 'H' 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

p8	decimal(18,12)	No

p9	decimal(18,12)	No

p10	decimal(18,12)	No

p11	decimal(18,12)	No

a7	decimal(18,12)	No

a8	decimal(18,12)	No

column id

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

column p8

370 - 480 MeV (Protons/cm^2 sec sr MeV)

column p9

480 - 640 MeV (Protons/cm^2 sec sr MeV)

column p10

640 - 850 MeV (Protons/cm^2 sec sr MeV)

column p11

> 850 MeV (Protons/cm^2 sec sr MeV)

column a7

630 - 850 MeV (Alpha-particles/cm^2 sec sr MeV)

column a8

> 850 MeV (Alpha-particles/cm^2 sec sr MeV)

Table Usage (MB)

Distribution of Table Space

Data	8.29	Data	84.09 %
Indexes	1.48	Indexes	14.98 %
Unused	0.09	Unused	0.93 %
Total	9.86	Number of Rows	135792

Dependencies

Referencing Objects

Object Name Object Type

dbo.hepad.hepad_ux1 INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.hepad 
(
    id  int            NOT NULL,
    p8  decimal(18,12) NOT NULL,
    p9  decimal(18,12) NOT NULL,
    p10 decimal(18,12) NOT NULL,
    p11 decimal(18,12) NOT NULL,
    a7  decimal(18,12) NOT NULL,
    a8  decimal(18,12) NOT NULL
)
LOCK ALLPAGES
go