dbo.integral_proton

 

Object Type

Table

Datasource

IPMA

Database

icsa

 

Contains the GOES-8 and GOES-9 Corrected Integral Proton data from the type 'I' 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
i1 decimal(18,12) No
i2 decimal(18,12) No
i3 decimal(18,12) No
i4 decimal(18,12) No
i5 decimal(18,12) No
i6 decimal(18,12) No
i7 decimal(18,12) No


column id

space weather id, a unique number identifying the time of the measurement through the space_weather table.
column i1
> 1 MeV (protons/cm^2 sec sr)
column i2
> 5 MeV (protons/cm^2 sec sr)
column i3
> 10 MeV (protons/cm^2 sec sr)
column i4
> 30 MeV (protons/cm^2 sec sr)
column i5
> 50 MeV (protons/cm^2 sec sr)
column i6
> 60 MeV (protons/cm^2 sec sr)
column i7
> 100 MeV (protons/cm^2 sec sr)

Table Usage (MB)

Distribution of Table Space

 

Data

9.47

Data

86.04 %

Indexes

1.48

Indexes

13.41 %

Unused

0.06

Unused

0.55 %

Total

11.01

Number of Rows

135792

Dependencies
Referencing Objects
Object Name Object Type
dbo.integral_proton.integral_protin_ux INDEX
Referenced Objects
Object Name Object Type

DDL 

CREATE TABLE dbo.integral_proton 
(
    id int            NOT NULL,
    i1 decimal(18,12) NOT NULL,
    i2 decimal(18,12) NOT NULL,
    i3 decimal(18,12) NOT NULL,
    i4 decimal(18,12) NOT NULL,
    i5 decimal(18,12) NOT NULL,
    i6 decimal(18,12) NOT NULL,
    i7 decimal(18,12) NOT NULL
)
LOCK ALLPAGES
go