Jump to Navigation

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

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.

Main menu 2