|
|
This page and it's links comprise the main tables (on the left-hand panel) that make up what is called the consolidated database of the Station Logs and files produced through automatic monitoring of the 5MHz Beacons. This part of the web and the tables themselves are in an early stage of development, so readers and users of the data will need a little patience. There are a small number of errors and omissions in the table which have yet to be corrected. These are mostly due to keying errors and possibly due to processing the data. Hopefully, both the presentation and data integrity will improve with further work. It is therefore sensible to check for the latest version of the tables before any serious analysis is undertaken. Error reports can be sent to 5MHz_Working_Group@rsgb.org.uk. IntroductionThe database has been developed using MS ACCESS. It is already too large to sensibly offer as a download, so instead the main tables are offered in CSV format, which are relatively small files. These could be uploaded into any relational databasing application such as MySQL, ACCESS, etc. for subsequent analysis and processing. The CSV files can alternatively be individually imported into a spreadsheeting application for viewing and data manipulation and processing. The opportunities for experimentation with the data are huge. Work is in hand to port the database tables and its queries to mySQL that will be served online. The development of this is more or less complete (late November 2007) and should be online for development purposes before the end of the year. The plan is to have it hosted within the RSGB domain probably starting around March 2008. The only proviso with use of the data is that due acknowledgement is given to "RSGB 5MHz Experiment", which is a simple shorthand the many who have contributed to the creation of the data, either though just operating on 5MHz, designing, building and hosting beacons, though submitting their Station Logs, or though offering their output files from automatic monitoring of the beacons. Current status of the databaseManual MonitoringThe database uploads have been few and far between since mid-summer on account of three factors. Firstly, an error where duplicate records were identified was spotted; this took some time to find a good automatic solution to correct the error. It was corrected in the database update published in mid-August. Since then problems finding effort to key in paper logs, and time spent working on some verification software delayed the update until mid-November. As of 3rd December 2007 there are 48,333 QSOs or beacon reports in the table that contains data from the Station Logs.; this is an increase of 4,380 since June. All are encouraged to submit their 5MHz logs, see link for further information. The following two tables show the breakdown within this table. The first table shows how many times each station has been logged in the database (it almost certainly includes some incorrectly logged calls):
The following table shows the number of reports submitted by individuals to the database:
Automatic Beacon monitoringIn addition to the data that has been logged by manual means, the number of data records that have been obtained through automatic monitoring is growing rapidly. The latest updated was completed on 3rd December 2007. It should be understood that each record is a unique 15 minute monitoring report so may or may not contain actual reception of one or more of the three beacons. The more data that we collect for any particular 15 min transmission the better will be the subsequent analysis. The contributions from the various monitoring stations are:
I would also like to acknowledge G0DJA, who submitted 617 records from the earlier "single beacon" version of the auto-monitoring program. This data is now in a separate data table (called "gb3ral log") with the same design and data format as that for the 3 Beacon auto-monitoring. I would be happy to receive single-beacon files from gb3ral.exe, with the header, as for the 3 Beacon files, added to the top of the text file. I will then add this data to the new gb3ral data table. I have a large amount of monitoring data from G4ZFQ, which is in the queue to upload.
|
| Copyright © 2005 RSGB. All rights reserved. Last modified: |