Databases Galore - 3

Yesterday I said "(I plan to do two today to make up for it" but I did not get around to it because of some unexpected disruptions.

The best laid plans of mice and men eh?

I did finish one additional program this morning.

It accepts a "country id code" composed of three digits, then contacts the mySQL Server which collects the data from all weather stations in that specified country, then the program prints out a report on each weather station for each year available at that location.

For example, I printed out the info for the U.S. and that one report ended up having 514,535 lines of text (1,921 stations).

Today's post will concern a smaller country with fewer weather stations (only 7) so it will fit in a single post, and will give the gist of what a report looks like:

---

[UPDATE: I updated the dizzying numbers(1000 lines plus) with the following graphs of the country and its 7 stations]

There are a couple of things about the graphs I should explain, now that the individual numbers that were here are no longer here.

The year 2014 only has data available through August.

So those figures may gyrate from the norm.

Click on any graph to get a larger view of it.Later today, I may add an option to the program so it will print in HTML table format.

Note that these 7 stations are in different locations in Burkina Faso, and that they don't begin with the same year because some are older.

Looking at the data is an education in geography as well as some fundamentals of climate science, which is collecting and storing accurate and usable data.

We citizens on our own can find out about and take interest in the things that matter.

Plus, it allows us to have less "faith / trust" due to having personal experience and knowledge on the issue (The Pillars of Knowledge: Faith and Trust?).

This data has not been smoothed or rounded so there are jumps where data are missing for several months (wars, disasters, etc. at a station).

Thanks to the scientists who have made it available to us.

It gives new meaning to "don't try this at home" because it does not take a rocket scientist to make databases and convert the data to graphs.

We can see it for ourselves.

Meanwhile, back in DC, some are dancing to the war drums on a "deth starr" while others are listening to the music of the Earth.

The music is alarming because making war while our environment dies is tempting destruction on two fronts.

The death stars are killing the Earth with little to no remorse as it turns out (Oil-Qaeda: The Indictment - 3).

The words at the beginning of the song "Deth Starr" (video below) tell of the dangers facing civilization, yet the most important thing of all to them is building weapons of mass destruction.

The next post in this series is here, the previous post in this series is here.

---

"Listen To The Music", by The Doobie Brothers

<

---

"Deth Starr", by Tenacious D

---