The dataset has been registered with GBIF here: https://www.gbif.org/dataset/80b4b440-eaca-4860-aadf-d0dfdd3e856e
- eml.xml a simple metadata descriptor in the EML format.
- meta.xml a darwin core archive descriptor file that explains the data file columns
- postgres.sql a SQL schema defining 2 basic tables both sharing the same identifier column. names is the parsed result while raw contains intermediate parsing results.
- names.txt all list names and their attributes parsed into Darwin Core compliant format together with a plain text version of the entire publication entry
- raw.txt all list names in their raw format (column html) and various intermediate parsing results
- opinions.txt a list of opinions with their references and links out. The same opinion can have multiple entries, i.e. references
Use the sql schema file postgres.sql to create a new tables for the names data.
\copy names from 'names.txt' NULL as ''
\copy raw from 'raw.txt' NULL as ''
\copy opinion from 'opinions.txt' NULL as ''
\copy (select * from names order by id) to 'names.txt' NULL as ''
\copy (select * from raw order by id) to 'raw.txt' NULL as ''
\copy (select * from opinion order by number) to 'opinions.txt' NULL as ''
\copy (select id,canonical,authorship,datepublished,originalcitation,status,classification,phylum,class_,order_,rank,typestatus,typename,typespecimen,typedesignatedby,typedesignationtype,gender,sic,synopsis,direction,opinions,rlpcomments,plaintext from names order by id) to 'names.txt' NULL as ''