HUH Botanical Authority Files

Names of Botanists

RDF/XML represents botanists and teams using terms from the FOAF, SKOS, and BIO ontologies. For examples see: Asa Grey or C. Sulivan & A. Gray See also: foaf=http://xmlns.com/foaf/0.1/ skos=http://www.w3.org/2004/02/skos/core# bio=http://purl.org/vocab/bio/0.1/

Minimal specimen records are also available as RDF/XML example.


Tab delimited files are one record per line, utf8 files with a header row containing the following fields. The field types listed reflect the field types and sizes of the underlying database fields from which these data were exported.

Example Records

GUID	HUHBOTANISTID   NAME    TYPEOFNAME      TYPEOFBOTANIST  START_YEAR      END_YEAR        STARTUNCERTAINTY        ENDUNCERTAINTY  UPDATE_DATE
http://purl.oclc.org/net/edu.harvard.huh/guid/uuid/6e52bd3f-b2c7-46dd-a96a-4ab74417c5f3 100322  Dominique Francois Delise       Variant Individual      1780    1841                    1994-01-25 12:00:00
http://purl.oclc.org/net/edu.harvard.huh/guid/uuid/b7a5fe2f-1675-4be4-a269-9867aaf99519 100323  Beddome, Col. Richard Henry     Variant Individual      1830    1911                    2008-06-23 03:27:33
http://purl.oclc.org/net/edu.harvard.huh/guid/uuid/b7a5fe2f-1675-4be4-a269-9867aaf99519 100323  Richard Henry Beddome   Variant Individual      1830    1911                    2008-06-23 03:27:33
http://purl.oclc.org/net/edu.harvard.huh/guid/uuid/0ff896f3-58e4-47da-9f16-d77faea234f4 100324  Granié, Étienne Marcelin        Variant Individual      1861    1937                    2009-05-06 01:29:47
http://purl.oclc.org/net/edu.harvard.huh/guid/uuid/0ff896f3-58e4-47da-9f16-d77faea234f4 100324  Granié-Blanc, Étienne Marcelin  Variant Individual      1861    1937                    2009-05-06 01:29:47
http://purl.oclc.org/net/edu.harvard.huh/guid/uuid/0ff896f3-58e4-47da-9f16-d77faea234f4 100324  Senne, frère    Variant Individual      1861    1937                    2009-05-06 01:29:47
http://purl.oclc.org/net/edu.harvard.huh/guid/uuid/0ff896f3-58e4-47da-9f16-d77faea234f4 100324  Sennen, hermano Variant Individual      1861    1937                    2009-05-06 01:29:47

The all_botanists file should be able to be imported into a mysql table using the following SQL statements.

create table if not exists huh_botanists (
   guid varchar(255) not null,
   huh_botanist_id int,
   name varchar(200),
   type_of_name varchar(24),
   type_of_botanist varchar(12),
   start_year int,
   end_year int,
   start_uncertainty varchar(24),
   end_uncertainty varchar(24),
   update_date datetime,
   huh_botanists_local_id int primary key not null auto_increment
);

load data infile 'all_botanists_2012July02.tab' 
   into table huh_botanists
   fields terminated by '\t' 
   ignore 1 lines 
   (guid, huh_botanist_id, name, type_of_name, type_of_botanist, start_year, end_year, start_uncertainty, end_uncertainty, update_date)
;

Distribution and Use Policy

Older copies of authority files for Names of Botanists

These 2008 authority files were generated from our 'Asa' database system, before migration into Specify, and before we began assigning persistent resolvable GUIDs to botanist records. They follow the table structure described above, with the exception of omission of the GUID field.

Old Files, Example Records

HUHBOTANISTID   NAME    TYPEOFNAME      TYPEOFBOTANIST  START_YEAR      END_YEAR        STARTUNCERTAINTY        ENDUNCERTAINTY  UPDATE_DATE
160876  Thiyag. author abbrev   Indiviudual     1999    null                    2000-05-22 00:00:00.0
130103  Sandi   author abbrev   Indiviudual     1794    1849                    1993-12-30 00:00:00.0
160875  Petunn. author abbrev   Indiviudual     1842    1919                    2000-04-08 00:00:00.0
126424  Pearsall        author abbrev   Indiviudual     1860    1936                    2005-01-29 00:00:00.0
120029  Pax     author abbrev   Indiviudual     1858    1942                    1993-03-31 00:00:00.0
160874  C. Perss.       author abbrev   Indiviudual     1960    null                    1999-10-12 00:00:00.0
160873  Devia   author abbrev   Indiviudual     1953    null                    1999-10-12 00:00:00.0
112807  R. Braga        author abbrev   Indiviudual     1964    null                    2001-06-06 00:00:00.0
160872  O. Nägeli       author abbrev   Indiviudual     1871    1938                    2002-08-19 00:00:00.0