Test Journal File
Richard Pyle
Hi All,
I've assembed a raw set of Journal names into a single flat table, which
I've just uploaded as a zipped tab-delimited file
(http://groups.google.com/group/taxonlit/web/MasterJournals.zip). First row
contains column headings (field names).
There are just over 200,000 records, and I have no idea how many actual
journals this distills down to. It ranges from very clean (ZooRec) to
semi-clean (Rod's BioGUID dataset) to godawful messy (some of the raw Bishop
Museum records). A bunch of these are not even journal titles (exported
from myriad EndNote files, which are probably full of errors and
inconsistencies). Some have ISSNs; some do not. Different providers had
different metadata (some had call numbers, some had publsher data, etc.)
I thought this might be useful for anyone who wants to play around with
reconciling them. Obviously, many could be reconciled via ISSN (except
these would need to be proofed to catch errors in the ISSN number).
However, many others will require some clever parsing/matching algorithms.
I'll be chipping away at reconciling the HNS, ZooRec, and Taxonomer sets
(all relatively small and managable, and of immediate need for me). The
"JounralID" is just a randomly assigned primary key value, which we can use
as a pseudo-GUID within context. If anyone has more records from more
sources they'd like to include, it might be easiest to send them to me, then
I'll generate a revised file and post it back. Or, add them to your own
local copy if you prefer.
I'm thinking this could serve as seed content for the "Global References
Index" (what we called the "dirty bucket" at TDWG).
Enjoy....
Aloha,
Rich
Richard L. Pyle, PhD
Database Coordinator for Natural Sciences
and Associate Zoologist in Ichthyology
Department of Natural Sciences, Bishop Museum
1525 Bernice St., Honolulu, HI 96817
Ph: (808)848-4115, Fax: (808)847-8252
email: deep...@bishopmuseum.org
http://hbs.bishopmuseum.org/staff/pylerichard.html