KD4PYR Database Status


Currently there are 1,482,472 records in the KD4PYR Weather Database.
Date range is from 1/1/1996 at 12:05:00 AM to 3/11/2010 at 6:15:00 PM.

The data captured at five minute intervals from the weather station are
loaded to a database once every three hours. The graphs displayed below are
built from the weather database at the time this web page is loaded.



Weather Graph2 Weather Graph1


Database Record Format


Field Type Collation Null Key Default Extra Privileges Comment
Date date NO PRI 0000-00-00 -- select Date of Observation (Local)
Time time NO PRI 00:00:00 -- select Time of Observation (Local)
Temp float(4,1) YES 0 -- select Temperature at Observation Time
Humid float(3,0) YES 0 -- select Humidity at Observation Time
Dewpt float(4,1) YES 0 -- select Dewpoint at Observation Time
Windsp float(4,1) YES 0 -- select Wind Speed at Observation Time
WindDir char(4) latin1_swedish_ci YES 0 -- select Wind Direction at Observation Time
WindRun float(4,2) YES 0 -- select Wind Run During Last Five Minutes
WindHi float(4,1) YES 0 -- select High Wind Speed During Last Five Minutes
WindChl float(4,1) YES 0 -- select Wind Chill at Observation Time
HeatIdx float(4,1) YES 0 -- select Heat Index at Observation Time
TwhIdx float(4,1) YES 0 -- select Apparent Temperature at Observation Time
Barom float(5,3) YES 0 -- select Barometer at Observation Time
Rain float(4,2) YES 0 -- select Rain Fall During Last Five Minutes
HeatDD float(5,3) YES 0 -- select Heating Degree Days During Last Five Minutes
CoolDD float(5,3) YES 0 -- select Cooling Degree Days During Last Five Minutes
v. 5.1.44

3,206 Page Views

Page Format Modified: 1/5/2010 2:28:45 PM (PID:23) Server Time: Thu 11-Mar-2010 at 21:01 EST (Fri 12-Mar-2010 at 02:01 UTC)