Henriette's Herbal Homepage | ![]() Plant name databasePlant name database - you always did want to know what Achillea millefolium is called in Finnish, didn't you? Here's your chance. Delimited textfiles, uploadable into any good spreadsheet or database program. Based on Latin names of plants, giving common names and synonyms in Finnish, Swedish, English, German, and even some French. And Latin synonyms. All in all about 8000 Latin names, meaning about 6000 plants (who says Latin names are always right?)
BackgroundI've worked on this ever since I got my PC (about 1989?); before that
it lived as textfiles on the Mac which my sister now uses. I haven't been updating the thing very much lately - after getting 2 x 15 kg books in the mail (summer of '95) I've kind of given up on an all-encompassing database of plant names or uses or you-name-it. But for those of you who aren't that disillusioned yet: additions are always welcome. Email me your delimited textfiles - I'm much obliged. It's easily expandable. Just add another field to the main table (do I hear Spanish?) and add another table called spansyno.txt... send me those files too: HeK@hetta.pp.fi. Thanks. On my PC I've also linked the main table to the Genus.db, downloaded from Flora online, which gives all Families gratis as is (making it an easy spellcheck - if you don't get the family popup when you type in a Latin genus you've either got a fern, an olde Latin genus (found in another Flora online table), or you've misspelled the name). Any of the entries with Genus* Species* having a ':' behind it means it has a new Latin name; this is found in the newlati.txt table (or should be - if you do find mistakes let me know). Any of the entries with Genus* Species* having a '*' behind it means that the Latin name is used but another Latin name should be used instead (found in the newlati.txt table). It is made in Paradox (relational database program). You can see which fields are keyed (no double records allowed): the Asterixed ones (*). All tables are delimited and can be uploaded into any good database or spreadsheet program. All records have fields surrounded by " and ", and separated by comma ','. Every record is on its own line.
The tablesYou can download them all by FTP from sunsite.unc.edu or from sunsite.sut.ac.jp. Go to the directories (to see file size, dates, etc.) here: sunsite.unc.edu or here: sunsite.sut.ac.jp Main table: Latin and common plant names - planname.txtFTP sunsite.unc.edu
/ sunsite.sut.ac.jp
Latin synonyms - newlati.txtFTP sunsite.unc.edu
/ sunsite.sut.ac.jp
English synonyms - englsyno.txtFTP sunsite.unc.edu
/ sunsite.sut.ac.jp
German synonyms - germsyno.txtFTP sunsite.unc.edu
/ sunsite.sut.ac.jp
French synonyms - fransyno.txtFTP sunsite.unc.edu
/ sunsite.sut.ac.jp
Finnish synonyms - finnsyno.txtFTP sunsite.unc.edu
/ sunsite.sut.ac.jp
Swedish synonyms - swedsyno.txtFTP sunsite.unc.edu
/ sunsite.sut.ac.jp
Copyright Henriette Kress. Commercial use prohibited - but of course you can make me an offer. Email any comments to HeK@hetta.pp.fi - Page last updated 19May97. |