dbo.xmagelectrons1

 

Object Type

Table

Datasource

IPMA

Database

icsa

 

Contains the X-ray, Magnetic and Electrons data from the GOES-8 and 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
xl decimal(18,12) No
xs decimal(18,12) No
hp decimal(18,12) No
he decimal(18,12) No
hn decimal(18,12) No
ht decimal(18,12) No
e1 decimal(18,12) No


column id

space weather id, a unique number identifying the time of the measurement through the space_weather table.
column x1
XL 1-8 Amstrong X-rays
column xs
XS 0.5-4 Amstrong X-rays
column hp
Hp parallel to satellite spin axis
column he
He Earthword
column hn
Hn Normal to Hp and Hg, points East for GOES-5+
column ht
Magnitude of total magnetic field vector
column el
> 2 MeV (Electrons/cm^2 sec sr)

Table Usage (MB)

Distribution of Table Space

 

Data

47.36

Data

86.50 %

Indexes

7.31

Indexes

13.35 %

Unused

0.08

Unused

0.15 %

Total

54.75

Number of Rows

678960

Dependencies
Referencing Objects
Object Name Object Type
dbo.xmagelectrons1.xmagelectrons1_ux INDEX
Referenced Objects
Object Name Object Type

DDL 

CREATE TABLE dbo.xmagelectrons1 
(
    id int            NOT NULL,
    xl decimal(18,12) NOT NULL,
    xs decimal(18,12) NOT NULL,
    hp decimal(18,12) NOT NULL,
    he decimal(18,12) NOT NULL,
    hn decimal(18,12) NOT NULL,
    ht decimal(18,12) NOT NULL,
    e1 decimal(18,12) NOT NULL
)
LOCK ALLPAGES
go