KD4PYR Database Status
Currently there are 1,677,687 records in the KD4PYR Weather Database.
Date range is from 1/1/1996 at 12:05:00 AM to 2/6/2012 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.
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.5.20
5,136 Page Views
| Page Format Modified: 1/6/2012 7:25:02 AM (PID:23) | Server Time: Mon 6-Feb-2012 at 19:54 EST (Tue 7-Feb-2012 at 00:54 UTC) |