[Taxacom] recursive SQL database for taxonomy available?
er at xs4all.nl
Fri Jan 17 11:10:25 CST 2014
On Fri, January 17, 2014 17:08, Markus Döring wrote:
> Hi Kim & Erik,
> I've dumped the GBIF backbone from our postgres 9.3 server and placed it here (427MB):
The dump took just over 4 minutes to load (postgres 9.4devel).
Thank you very much Markus, this is much fun and really useful.
> The tables should be fairly straight forward with taxa being in "name_usage" and names in "name".
> A simple join to get the core properties for a taxon would be this sql:
> select u.id, parent_fk,n.scientific_name, rank, status, p.citation as publlishedIn from name_usage u join name n on
> name_fk=n.id left join citation p on name_published_in_fk=p.id order by rank limit 100;
> The backbone is the current live one with the higher classification coming from the Catalog of Life.
> Quick facts:
> taxa incl synonyms: 4.416.347
> synonyms: 1.143.026
> names: 4.410.899
> accepted taxa by rank:
> KINGDOM: 9
> PHYLUM: 111
> CLASS: 272
> ORDER: 1183
> SUPERFAMILY: 356
> FAMILY: 20760
> GENUS: 390790
> SPECIES: 2497114
> SUBSPECIES: 171473
> VARIETY: 149011
> SUBVARIETY: 1070
> FORM: 40473
> Markus Döring
> Software Developer
> Global Biodiversity Information Facility (GBIF)
> mdoering at gbif.org
More information about the Taxacom