<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Aptos;
panose-1:2 11 0 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="#467886" vlink="#96607D" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hey all,<o:p></o:p></p>
<p class="MsoNormal">This one is for those of you who manage “collecting events” as a separate table or group of tables in a relational database, with a one-to-many relationship to collection objects or specimen lots. I’d like to hear some different perspectives
on how your collection would handle the following situation:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">A jar containing 5 species of 5 species of land snails bears the following collecting data:
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">“Blue River at Rt. 101 Bridge, 5 mi N of Anywhere, USA. Station BS-2024-100. Crayfish seined from 1-2 ft of water in 1 pass, snails abundant on bank vegetation. B. Smith, 11-April-2024!”<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We know these specimens share a locality, collector, date of collection, etc. But the specific habitat is different, and taxonomists focusing on either group (crayfish or snails) might write the locality a bit differently, for example,
a crayfish biologist might write “Blue River at…” whereas a terrestrial malacologist might prefer “Along bank of Blue River at…” to indicate more clearly that the specimens were not found in the river itself. Furthermore, the gear type and method of collecting
is different (the crayfish were caught in a seine, but the snails were hand-caught on vegetation.)<o:p></o:p></p>
<p class="MsoNormal"><b>Would this be one collecting event in your collection, or two? How would you parse the data, and why?<o:p></o:p></b></p>
<p class="MsoNormal"><b><o:p> </o:p></b></p>
<p class="MsoNormal">(Assume that both the crayfish and snails are in-scope for your collection, of course.)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In my personal collecting, I have always treated “in” and “out” of the water as different stations even when at the same place, but I don’t want to impose my personal preference on our collection here without seeing what others do.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-Nate<o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;mso-ligatures:none">--<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:13.5pt;background:white">
<span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#333333;mso-ligatures:none"><img width="224" height="45" style="width:2.3333in;height:.4687in" id="Picture_x0020_1" src="cid:image001.png@01DA8C32.A47A41A0" alt="The Ohio State University"><br>
</span><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#BB0000;background:white;mso-ligatures:none">Nathaniel F. Shoobs</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#333333;mso-ligatures:none"><br>
Curator of Mollusks<br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#BB0000;background:white;mso-ligatures:none">College of Arts & Sciences</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#333333;mso-ligatures:none"> Dept. of Evolution,
Ecology, and Organismal Biology<br>
Museum of Biological Diversity, 1315 Kinnear Rd, Columbus, OH 43212<br>
614-688-1342 (Office)<br>
<a href="http://mbd.osu.edu"><span style="color:#0563C1;background:white">mbd.osu.edu</span></a></span><o:p></o:p></p>
</div>
</div>
</body>
</html>