General Database Information - Weather Station - Garrett Galleries Photography

Data on this website is stored in a single MySQL database consisting of three tables:

• noaamonthly
  

• noaayearly
  

• vwsdata
  

The data in these tables is entered as follows:

noaamonthly

The data in this table is added each month from the NOAA report generated by Virtual Weather Station software.  We simply print the report and then manually enter the data from the printed report.  This is done at the beginning of each month for the prior month.

noaayearly

The data in this table is added each year from the NOAA report generated by Virtual Weather Station software.  We simply print the report and then manually enter the data from the printed report.  This is done at the beginning of each year for the prior year.

vwsdata

This data is captured from the Virtual Weather Station software every 30 minutes on the hour/half-hour.  The data is uploaded to the table automatically via ftp by a software package called VWsql.  

For specific table layout information on these tables, see the individual table layout pages.