Object Type	Table
Datasource	IPMA
Database	icsa

Contains the Uncorrected Proton Channels data from the GOES-8 and GOES-9 type 'G' file, stored as 1 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

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 MeV (Protons/cm^2 sec sr MeV)

column p7

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

Table Usage (MB)

Distribution of Table Space

Data	47.36	Data	86.54 %
Indexes	7.31	Indexes	13.36 %
Unused	0.05	Unused	0.10 %
Total	54.72	Number of Rows	678960

Dependencies

Referencing Objects

Object Name Object Type

dbo.uncorrected_proton.uncorrected_proton_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.uncorrected_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.uncorrected_proton.uncorrected_proton_ux	INDEX