You'll find a list of all my blog posts in the blog archive.

Distanskurs i örtterapi.

Plant data

Blog categories: 

You have data on how many plants?

Some of the various herb-related sites out there proudly exhibit things like "7000 plants in our database" and similar.

So on a whim, I did a quick and dirty database query: count the number of unique latin names with URLs attached.
I have data on 4200 different plants, give or take a few.

And, lemmesee, I have photos of 2164 genera online.

I can't get mysql to give me the combined number, though: add any WHERE clause at all to that "SELECT COUNT ( DISTINCT column ) FROM table" and the numbers are utterly, totally, completely, and hopelessly wrong.

Anyway, gotta add more URLs to the database (and to the site), in order to get that 7000.