[Nhcoll-l] Entomology taxonomy for database

Tue Dec 16 15:23:22 EST 2025

Hello Deborah,

Thank you very much for this. We’re giving it a try. It took a while to cull the list, but I think we got what we needed.

Thank you also to everyone else that replied and offered their files (Nathalie, Christine, and others—I apologize if I’ve left your name out).
I may be in touch depending on how our trials with the GBIF dataset go. I imported it to EMU, but the file was so large excel truncated it, and I may have missed something. Time will tell as we move forward cataloging our bugs!

All the best,

Rod

[cid:image001.jpg at 01DC6E9F.D3F70930]

Telework on Thursdays

From: Deborah Paul <dlpaul at illinois.edu>
Sent: Friday, December 12, 2025 1:44 PM
To: nhcoll-l at mailman.yale.edu
Cc: Pellegrini, Rodrigo [DOS] <Rodrigo.Pellegrini at sos.nj.gov>
Subject: [EXTERNAL] Re: [Nhcoll-l] Entomology taxonomy for database

*** CAUTION ***

This message came from an EXTERNAL address (dlpaul at illinois.edu<mailto:dlpaul at illinois.edu>). DO NOT click on links or attachments unless you know the sender and the content is safe.
New Jersey State Government Employees Should Forward Messages That May Be Cyber Security Risks To PhishReport at cyber.nj.gov<mailto:PhishReport at cyber.nj.gov>.

Hi Rod,

Glad to hear you have a paleoentomologist with you. You can get names and taxonomy you need from Catalogue of Life via their exporter.

1. You will need a GBIF account (do you have one? they are instant to get) to Login.
2. Log in to Checklist Bank (where COL datasets live, to search and download). https://www.checklistbank.org/<https://urldefense.com/v3/__https:/www.checklistbank.org/__;!!J30X0ZrnC1oQtbA!NA-nX3xSyytKOKTAtJjNtRBTtJc-JKD-Ed4NO_Sz58PFvRheH3ARKLnSQpgZhzcZbn921tlKUXvQ_bN1iakxMM3f_qu8$>
3. Go to "Datasets" and find the most recent "Annual Release"
(this one: https://www.checklistbank.org/dataset/310463/about<https://urldefense.com/v3/__https:/www.checklistbank.org/dataset/310463/about__;!!J30X0ZrnC1oQtbA!NA-nX3xSyytKOKTAtJjNtRBTtJc-JKD-Ed4NO_Sz58PFvRheH3ARKLnSQpgZhzcZbn921tlKUXvQ_bN1iakxMLVrMbvM$>)
[cid:image002.png at 01DC6E9F.D3F70930]
4. Click on Downloads to generate a download: (see options to pick below);
[cid:image003.png at 01DC6E9F.D3F70930]

5. You will get more that you want / need (i. e. classification above Family level). You can of course delete the columns you are not interested in.

Please holler if you have questions. The COL team will help. I pinged my colleague Geoff Ower, one of the COL Developers to be sure I've pointed you in a useful direction.

Best,
Debbie

On 12/12/2025 12:10 PM, Pellegrini, Rodrigo [DOS] wrote:

Greetings everyone,

We are currently making an effort to catalog our entomology collection at the NJSM, ...

A paleoentomologist recently joined our ranks, and has been identifying, re-identifying and assigning catalog numbers to our old (recent) insects, and the time to import them into our database, EMU, is nigh.

Needless to say, our taxonomy tables in the database lack insect taxonomy. ... I'm wondering if anybody here would be kind enough to share their entomology taxonomy tables as a CSV file, for me to import them into our database. We are hoping to get a file that includes up to the Family level, and we could create the genus species for the species represented in our collections.

... if your database (whatever it may be) can produce a comma-separated-file with understandable headers for the hierarchy (or a key of what the backend name headers correspond to in the hierarchy), I can make it work.

It would save us a ton of time, and we would very much appreciate it. Please let me know directly at Rodrigo.Pellegrini at sos.nj.gov<mailto:Rodrigo.Pellegrini at sos.nj.gov> if you can help us out.

Thank you very much for your time,

Rod

--

- Deborah Paul, Biodiversity Informatics Community Liaison

- Species File Group (INHS), University of Illinois

-- Natural History Collections and Museomics NHCM Editor-in-Chief https://nhcm.pensoft.net<https://urldefense.com/v3/__https:/nhcm.pensoft.net__;!!J30X0ZrnC1oQtbA!NA-nX3xSyytKOKTAtJjNtRBTtJc-JKD-Ed4NO_Sz58PFvRheH3ARKLnSQpgZhzcZbn921tlKUXvQ_bN1iakxMG-LKUh9$>

-- Biodiversity Information Standards (TDWG) Past Chair 2021-2022

-- Florida State University Courtesy Appointment

-- Species File Group and Events https://speciesfilegroup.org<https://urldefense.com/v3/__https:/speciesfilegroup.org__;!!J30X0ZrnC1oQtbA!NA-nX3xSyytKOKTAtJjNtRBTtJc-JKD-Ed4NO_Sz58PFvRheH3ARKLnSQpgZhzcZbn921tlKUXvQ_bN1iakxMHjBxTx9$>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.yale.edu/pipermail/nhcoll-l/attachments/20251216/8a8ad21b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 12276 bytes
Desc: image001.jpg
URL: <http://mailman.yale.edu/pipermail/nhcoll-l/attachments/20251216/8a8ad21b/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 74265 bytes
Desc: image002.png
URL: <http://mailman.yale.edu/pipermail/nhcoll-l/attachments/20251216/8a8ad21b/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 30046 bytes
Desc: image003.png
URL: <http://mailman.yale.edu/pipermail/nhcoll-l/attachments/20251216/8a8ad21b/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Rodrigo Pellegrini.vcf
Type: text/x-vcard
Size: 1887 bytes
Desc: Rodrigo Pellegrini.vcf
URL: <http://mailman.yale.edu/pipermail/nhcoll-l/attachments/20251216/8a8ad21b/attachment.vcf>