Weather Database Ideas

[bigroo]

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.

[orange]

There are sites with various weather info
http://www.wunderground.com/US/FL/Palm_Beach.html
http://www.wunderground.com/history/
http://www.weather.com/maps/maptype/...her_large.html

[bigroo]

Thanks Orange,

This web site is just super with lots of data and plus historical data. There is even a place to download data as a csv, this will make it easier to import the data into the database for each month of the year.

Thanks, I did not know about this website!!
I knew I would get good answers here!!

[HMEpartsmanager]

Looking for additional ideas for tables listed below:

tblLocation
**Locationid
City
State

I would definintely add ZipCode. If you are doing it for yourself, and maybe each city near you is 1 zip code, then it is not a problem. However, there are plenty of cities where there are multiple zip codes and their weather patterns are different. Low valley area versus higher elevation areas, yet same city name.

[bigroo]

Hi HMEpartsmanager,

Thanks for your input, I beleive I have my tables created, plus with information from the above website, additional columns I would not have thought of, so I am well on my way.

Yes, this is for my own use!!
Ok, now the query design.

From the above website I see the CSV for the data which I can import into the database.

I want to breakup the row entry once in the database and send the data to the 4 different tables. I know these will need to be done in a certian order I guess.
Would this be a case of just setting up "Append Queries" for each bit of data for each table and list them one after the other in a macro under a button, or is there another way to do this?