[Taxacom] recursive SQL database for taxonomy available?

Richard Pyle deepreef at bishopmuseum.org
Tue Jan 14 13:28:16 CST 2014

Hi Kim,

We have a number of recursive representations of things (including asserted
taxonomic hierarchies) in GNUB (Global Names Usage Bank), and I would say
that the content is "substantial".  And, of course, it is open source.

Are you more interested in the data, or the SQL statements to generate
recursion (i.e., transform a hierarchical nested set of records in a single
table to a flattened concatenated, delimited list of elements in sequence)?
I could go on for hours about both; however, I think it's in the best
interests of everyone (including myself) that I not attempt to do that now.

But I am more than happy to elaborate in more detail, if you are interested,
and if I have a better understanding of what you are looking for.

It could represent a "teachable moment" for how GNUB captures taxonomic


> -----Original Message-----
> From: taxacom-bounces at mailman.nhm.ku.edu [mailto:taxacom-
> bounces at mailman.nhm.ku.edu] On Behalf Of Kim van der Linde
> Sent: Tuesday, January 14, 2014 6:29 AM
> To: TAXACOM (taxacom at mailman.nhm.ku.edu)
> Subject: [Taxacom] recursive SQL database for taxonomy available?
> Hi,
> I am wondering if there is an open source recursive taxonomic SQL (MySQL
> or other) database available that contains a substantial number of species
> and higher taxa?
> Kim
> _______________________________________________
> Taxacom Mailing List
> Taxacom at mailman.nhm.ku.edu
> http://mailman.nhm.ku.edu/mailman/listinfo/taxacom
> The Taxacom Archive back to 1992 may be searched with either of these
> methods:
> (1) by visiting http://taxacom.markmail.org
> (2) a Google search specified as:
> site:mailman.nhm.ku.edu/pipermail/taxacom  your search terms here
> Celebrating 26 years of Taxacom in 2013.

More information about the Taxacom mailing list