TA for entomological database
I started to integrate my entomological database (before I used a custom made highly complex FileMaker DB) into my Zettelkasten running with The Arcive. And man, it works great!
From time to time my previous FileMaker solution has given me strange problems, since the database began to grow. So I started to search for a stable and reliable solution. I know, that many entomologists work with Excel sheets, which for me is much too inconvenient. Most museums use database programs. Many years ago there where different special database solutions available on the net, but meanwhile you can't find them anymore (only a solution for MSACCESS (I don’t use Windows) and another one for FileMaker).
I was tired to rely on complex but fragile solutions. I need a workhorse, simple and strong!
So I thought - maybe I can do it with .txt files only. And yes, it works great!
What do we need for an entomological data collection?
1.) Data for each taxon
2.) Ability to change a taxon to synonym status without changing the original file (to keep all links)
3.) Links to the place of storage for each specimen and back
4.) Links to hostplant data and back
6.) Easy way to copy data for label printing
7.) Ability to add data for detailed event decriptions, detailed locality descriptions, loan data, literature data etc. etc.
Everything can be done with simple .txt files. The main advantage is the beautiful simplicity and the speed - you can search and find data much faster than using a complex database program. You can store everything in one folder on your harddrive, and each file represents one specific datum (with database programs everything is hidden encrypted somewhere inside your program).
If you really want to break everything down to taxonomical steps, you can do so. What only means: much more files. I decided to use tags - so e.g.
Carabus (Acoptolabrus) constructicollis heilongjiangensis
will be tagged as
#coleoptera #carabidae #carabus #acoptolabrus
that's it. Everything will be available, regardless if you need subfamily, tribus, subtribus or what ever status in addition.
Maybe this can help other strange nerds like me, who have this inordinate fondness for beetles (or other insects)...
P.S.: As you can see, I also use TA for botanical data (interlinked with the coleoptera data) as well as for lepidoptera data.
P.P.S.: Posted this article on my blog
It looks like you're new here. If you want to get involved, click one of these buttons!