Hi All,
I am wanting to create a weather database to collect daily tempertures, rainfall, snowfall, Humidity, wind speed, direction etc.
Looking for additional ideas for tables listed below:
tblLocation
**Locationid
City
State
tblday
**dayid
Locationid
tblweather
DayID
Max
Min
SkyCover
Rainfall
Snowfall
SnowDepth
Wind
Speed
Direction
HumH
HumL
This is my starting point, what other information would be needed?
I am open to ideas. At present I will only track my location with daily data, but I hope to add historical data as well to start a trend.