Solar Event Catalogue


Description of the SEC database architecture.
Cross queries among different catalogues are possible by using common fields.

Tables

Table nameDescriptionCatalogue URL
goes_xray_flareGEV GOES event listftp://ftp.ngdc.noaa.gov/STP/SOLAR_DATA/SOLAR_FLARES/FLARES_XRAY
halpha_flares_eventSolar H-alpha Flare eventshttp://www.ngdc.noaa.gov/stp/SOLAR/ftpsolarflares.html#halpha
sgas_eventNOAA SGAS Energetic Eventsftp://solar.sec.noaa.gov/pub/forecasts/SGAS
yohkoh_flare_listYohkoh HXT Flare Listhttp://isass1.solar.isas.jaxa.jp/sxt_co/hxt_flare_list.txt
hessi_flareHESSI Flare Listhttp://hesperia.gsfc.nasa.gov/ssw/hessi/dbase
kso_flareKanzelhoehe Flare Listhttp://www.kso.ac.at
eit_listEIT Waveshttp://umbra.nascom.nasa.gov/eit #[Contributed by Barbara Thompson (NASA/GSFC)]
yohkoh_sxt_trace_listYohkoh SXT TRACE flare listhttp://www.lmsal.com/nitta/sxt_trace_flares/list.html
noaa_proton_eventNOAA Proton Eventshttp://umbra.nascom.nasa.gov/SEP/seps.html
lasco_cme_catLASCO CME Cataloguehttp://cdaw.gsfc.nasa.gov/CME_list/UNIVERSAL/text_ver/univ_all.txt
lasco_cme_listLASCO Preliminary CME Listftp://lasco6.nascom.nasa.gov/pub/lasco/status
bas_magnetic_stormsBAS Magnetic Stormshttp://www.antarctica.ac.uk/SatelliteRisks #[Contributed by Richard Horne (BAS)]
srs_listNOAA SRS Active Regionsftp://solar.sec.noaa.gov/pub/forecasts/SRS
soho_campSoHO Campaignhttp://sohowww.nascom.nasa.gov/data/summary/asplanned/campaign/soho_campaign.dat
dsd_listNOAA Daily Solar Datahttp://www.sec.noaa.gov/ftpdir/indices/old_indices
sidc_sunspot_numberSIDC Smoothed Monthly Sunspot No.http://sidc.oma.be/DATA/monthssn.dat
drao_10cm_fluxDRAO 10.7cm Radio Flux Monitorhttp://www.spaceweather.gc.ca/sx-eng.php

Attributes

goes_xray_flarehalpha_flares_eventsgas_eventyohkoh_flare_listhessi_flarekso_flareeit_listyohkoh_sxt_trace_listnoaa_proton_event
GEV GOES event listSolar H-alpha Flare eventsNOAA SGAS Energetic EventsYohkoh HXT Flare ListHESSI Flare ListKanzelhoehe Flare ListEIT WavesYohkoh SXT TRACE flare listNOAA Proton Events
time_start
time_peak
time_end
nar
latitude
longitude
xray_class
optical_class
long_carr
ntime_start
ntime_end
time_start
time_peak
time_end
nar
latitude
longitude
xray_class
optical_class
long_carr
time_start
time_peak
time_end
nar
latitude
longitude
xray_class
optical_class
radio_245mhz
radio_10cm
radio_sweep_ii
radio_sweep_iv
swf
long_carr
ntime_start
ntime_end
time_start
time_peak
time_end
nar
latitude
longitude
xray_class
optical_class
hxt_lo
hxt_m1
hxt_m2
hxt_hi
rem
yoh_event
time_start
time_peak
time_end
nar
x_arcsec
y_arcsec
radial_arcsec
duration
count_sec_peak
total_count
energy_kev
flare_number
time_start
time_peak
time_end
latitude
longitude
optical_class
long_carr
time_start_m
time_peak_m
time_end_m
time_start
latitude
longitude
pa_central
description
previmg_time
img_time
quality
speed_planeofsky
speed_proj
time_start
time_end
x_arcsec
y_arcsec
xray_class
link
time_start_sxt
time_end_sxt
n_img
x_arcsec_sxt
y_arcsec_sxt
time_sxt_trace
wl_dom
n171
n195
n284
n1600
n1216
nwl
time_start
time_peak
nar
latitude
longitude
proton_flux
assoc_cme
assoc_flare_pk
xray_class
optical_class

lasco_cme_catlasco_cme_listbas_magnetic_stormssrs_listsoho_campdsd_listsidc_sunspot_numberdrao_10cm_flux
LASCO CME CatalogueLASCO Preliminary CME ListBAS Magnetic StormsNOAA SRS Active RegionsSoHO CampaignNOAA Daily Solar DataSIDC Smoothed Monthly Sunspot No.DRAO 10.7cm Radio Flux Monitor
time_start
pa_central
pa_measure
pa_width
linear_speed
speed2_init
speed2_final
speed2_20r
acceleration
time_start
pa_central
description
time_start
time_peak
time_end
dst
hduration
time_start
nar
latitude
longitude
long_carr
area
zurich_class
p_value
c_value
long_extent
n_spots
mag_class
region_type
time_start
time_end
sohoc_num
sohoc_name
sohoc_type
sohoc_obj
sohoc_coord
sohoc_part
sohoc_comm
time_start
radio_10cm
sesc_ssn
ssa
new_regions
stan_smf
xray_bkg
c_flares
m_flares
x_flares
opts_flares
opt1_flares
opt2_flares
opt3_flares
time_start
time_end
ssn
time_start
time_end
sfu_observed
sfu_adjusted
sfu_series_d


Attribute details

Field nameTypeDescriptiongoes_
xray_
flare
halpha_
flares_
event
sgas_
event
yohkoh_
flare_
list
hessi_
flare
kso_
flare
eit_
list
yohkoh_
sxt_
trace_
list
noaa_
proton_
event
lasco_
cme_
cat
lasco_
cme_
list
bas_
magnetic_
storms
srs_
list
soho_
camp
dsd_
list
sidc_
sunspot_
number
drao_
10cm_
flux
accelerationfloatacceleration [km/sec^2]         X       
areafloatarea            X    
assoc_cmestringassociated CME        X        
assoc_flare_pkdatetimepeak time for associated flare        X        
c_flaresintegerclass C flares              X  
count_sec_peakintegerpeak of counts per sec [s-1]    X            
c_valuestringc value            X    
descriptionstringevent description      X   X      
dstintegermagnetic field [nT]           X     
durationintegerduration [s]    X            
energy_kevfloatenergy [keV]    X            
flare_numberintegerflare id number    X            
hdurationintegerduration [h]           X     
hxt_hiintegerHXT hi   X             
hxt_lointegerHXT lo   X             
hxt_m1integerHXT m1   X             
hxt_m2integerHXT m2   X             
img_timedatetimeImage Time      X          
latitudefloatheliographic latitudeXXXX XX X   X    
linear_speedfloatlinear speed [km/sec]         X       
linkstringThe location of the SXT PFI file at ISAS       X         
long_carrfloatCarrington longitudeXXX  X      X    
long_extentfloatlongitudinal extension            X    
longitudefloatheliographic longitudeXXXX XX X   X    
mag_classstringmag class            X    
m_flaresintegerclass M flares              X  
n1216integerNumber of TRACE images at 1216 A       X         
n1600integerNumber of TRACE images at 1600 A       X         
n171integerNumber of TRACE images at 171 A       X         
n195integerNumber of TRACE images at 195 A       X         
n284integerNumber of TRACE images at 284 A       X         
narintegeractive region numberXXXXX   X   X    
new_regionsintegernew regions              X  
n_imgintegerNumber of flare mode SXT images       X         
n_spotsintegernumber of sunspots            X    
ntime_enddatetimeselection end timeX X              
ntime_startdatetimeselection start timeX X              
nwlintegerNumber of TRACE images at WL       X         
opt1_flaresintegeropt1 flares              X  
opt2_flaresintegeropt2 flares              X  
opt3_flaresintegeropt3 flares              X  
optical_classstringoptical importance classXXXX X  X        
opts_flaresintegeropts flares              X  
pa_centralfloatpolar angle [deg]      X  XX      
pa_measurefloatpolar angle measure [deg]         X       
pa_widthfloatpolar angle width [deg]         X       
previmg_timedatetimePrevious Image Time      X          
proton_fluxfloatproton flux units        X        
p_valuestringp value            X    
qualitystringQuality Rating      X          
radial_arcsecfloatsun radius [arcsec]    X            
radio_10cmintegerradio emission at 10 cm  X           X  
radio_245mhzintegerradio emission at 245 MHz  X              
radio_sweep_iibooleanradio sweep type II  X              
radio_sweep_ivbooleanradio sweep type IV  X              
region_typestringactive region type            X    
remstringRemarks   X             
sesc_ssnintegersesc sunspot number              X  
sfu_adjustedfloatadjusted solar flux units                X
sfu_observedfloatobserved solar flux units                X
sfu_series_dfloatseries d solar flux units                X
sohoc_commstringSoHO Campaign comments             X   
sohoc_coordstringSoHO Campaign coordinators             X   
sohoc_namestringSoHO Campaign name             X   
sohoc_numintegerSoHO Campaign number             X   
sohoc_objstringSoHO Campaign objective             X   
sohoc_partstringSoHO Campaign participants             X   
sohoc_typestringSoHO Campaign type             X   
speed2_20rfloat2nd order speed at 20 R [km/sec]         X       
speed2_finalfloat2nd order final speed [km/sec]         X       
speed2_initfloat2nd order initial speed [km/sec]         X       
speed_planeofskyfloatPlane-of-Sky Speed      X          
speed_projfloatProjected Speed      X          
ssaintegersunspot area              X  
ssnfloatsunspot number               X 
stan_smfintegerstan smf              X  
swfstringshort wave fade  X              
time_enddatetimeevent end timeXXXXXX X   X X XX
time_end_mstringevent end time modifier     X           
time_end_sxtdatetimeTimes of the last flare mode SXT images       X         
time_peakdatetimeevent peak timeXXXXXX  X  X     
time_peak_mstringevent peak modifier     X           
time_startdatetimeevent start timeXXXXXXXXXXXXXXXXX
time_start_mstringevent start time modifier     X           
time_start_sxtdatetimeTimes of the first flare mode SXT images       X         
time_sxt_tracedatetimeTime of the TRACE image closest to time_start_sxt       X         
total_countintegertotal counts    X            
wl_domintegerWavelength at which the greatest number of images is taken       X         
x_arcsecfloatx position [arcsec]    X  X         
x_arcsec_sxtfloatCoord. X (arcsec from disk center) of the center of the 6th SXT flare mode image       X         
x_flaresintegerclass X flares              X  
xray_bkgstringx-ray bkg              X  
xray_classstringx-ray importance classXXXX   XX        
y_arcsecfloaty position [arcsec]    X  X         
y_arcsec_sxtfloatCoord. Y (arcsec from disk center) of the center of the 6th SXT flare mode image       X         
yoh_eventintegerYohkoh event   X             
zurich_classstringZurich classification            X    

Designed and maintained by INAF - Trieste Astronomical Observatory
INAF Trieste Astronomical Observatory