Skip to main content

NGDC database of AAVSO SID events back to 1958

HRHA's picture
HRHA
Offline
Joined: 2010-10-15

 

To run this database you have to have a local MySQL data base to which you can create a database.

http://dev.mysql.com/downloads/

 

You'll have to change the extension from .txt to .mysql after you download the file.  It creates a SID database you can connect too. There will be a table there called ngdcsid with all 35 MB of data from 1958 to 2009.  NGDC no longer supports the AAVSO SID data submissions as of 2009.  So, this is all there is for SID flare data. 

 

I also put a SQL statement up there, aavso_tabs.sql, also as a .txt extension (change the .txt to .sql).  These NGDC data have other VLF flare stations than just AAVSO submitters.  So it's important to link the AAVSO_ID with the station ( aavso_yr_id.sql)  after loading the AAVSO submitters for these older times.

 

R. 

 

AttachmentSize
ngdc_database.txt33.57 MB
AAVSO_ID.csv4.54 KB
AAVSO_ID_tabs.txt4.38 KB
AAVSO_yr_ID.txt390 bytes
AAVSO 49 Bay State Rd. Cambridge, MA 02138 aavso@aavso.org 617-354-0484