Object Type	Table
Datasource	IPMA
Database	icsa

Contains the data from the GOES-8 and GOES-9 Corrected Proton Channels in the type 'Z' 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.

Please see the GOES documentation for further information (ftp.ngdc.noaa.gov in directory STP/GOES/AVERAGED).

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

p1	decimal(18,12)	No

p2	decimal(18,12)	No

p3	decimal(18,12)	No

p4	decimal(18,12)	No

p5	decimal(18,12)	No

p6	decimal(18,12)	No

p7	decimal(18,12)	No

column id

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

column p1

0.6 - 4.2 MeV (Protons/cm^2 sec sr MeV)

column p2

4.2 - 8.7 MeV (Protons/cm^2 sec sr MeV)

column p3

8.7 - 14.5 MeV (Protons/cm^2 sec sr MeV)

column p4

15.0 - 44.0 MeV (Protons/cm^2 sec sr MeV)

column p5

39.0 - 82.0 MeV (Protons/cm^2 sec sr MeV)

column p6

84.0 - 200.0 MeV (Protons/cm^2 sec sr MeV)

column p7

110.0- 500.0 MeV (Protons/cm^2 sec sr MeV)

Table Usage (MB)

Distribution of Table Space

Data	9.47	Data	85.96 %
Indexes	1.48	Indexes	13.42 %
Unused	0.07	Unused	0.62 %
Total	11.02	Number of Rows	135792

Dependencies

Referencing Objects

Object Name Object Type

dbo.corrected_proton.corrected_proton_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.corrected_proton 
(
    id int            NOT NULL,
    p1 decimal(18,12) NOT NULL,
    p2 decimal(18,12) NOT NULL,
    p3 decimal(18,12) NOT NULL,
    p4 decimal(18,12) NOT NULL,
    p5 decimal(18,12) NOT NULL,
    p6 decimal(18,12) NOT NULL,
    p7 decimal(18,12) NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.corrected_proton.corrected_proton_ux	INDEX