<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=utf-8">
<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:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:wf_segoe-ui_normal;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">In our relational database, we would also treat this as two separate collecting events. We consider a collecting event to be uniquely defined by a combination of the following:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Locality<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Habitat<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Date<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Collecting Method<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Collectors<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">In the example you provided, the crayfish and snails would be separated into separate containers and we assign a unique collecting event number to each event.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Brad<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="480" style="width:5.0in">
<tbody>
<tr>
<td width="141" style="width:105.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Arial",sans-serif"><img width="109" height="110" style="width:1.1354in;height:1.1458in" id="_x0000_i1028" src="https://projects.rom.on.ca/graphics/new_rom_logo.png"></span><span style="font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</td>
<td width="489" style="width:366.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Brad Hubley
</span></b><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
Collections Specialist, 2<br>
<br>
100 Queen's Park<br>
Toronto, ON M5S 2C6<br>
416-586-5764<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:0in 0in 0in 0in">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:6.0pt;font-family:"Arial",sans-serif"> <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:6.0pt;font-family:"Arial",sans-serif">ROM acknowledges that this museum sits on the ancestral lands of the Wendat, the Haudenosaunee Confederacy, and the
Anishinaabek Nation, which includes the Mississaugas of the Credit First Nation, since time immemorial to today.<br>
<br>
Le ROM reconnaît que le Musée est situé sur les terres ancestrales des Wendats, de la Confédération des Haudenosaunee et de la Nation Anishinabek, y compris la Première Nation des Mississaugas de Credit, et qu’ils occupent ces terres depuis la nuit des temps.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Nhcoll-l <nhcoll-l-bounces@mailman.yale.edu>
<b>On Behalf Of </b>Dean Pentcheff<br>
<b>Sent:</b> Monday, April 29, 2024 7:45 PM<br>
<b>To:</b> nhcoll-l@mailman.yale.edu<br>
<b>Subject:</b> Re: [Nhcoll-l] How does your collection handle sites with multiple habitats sampled?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width="100%" style="width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121">Some people who received this message don't often get email from
<a href="mailto:pentcheff@gmail.com">pentcheff@gmail.com</a>. <a href="https://aka.ms/LearnAboutSenderIdentification">
Learn why this is important</a><o:p></o:p></span></p>
</div>
</td>
<td width="75" style="width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt;align:left">
</td>
</tr>
</tbody>
</table>
<div>
<div style="mso-element:para-border-div;border:solid #FFEB9C 1.0pt;padding:0in 0in 0in 0in;background:#FFEB9C">
<p style="background:#FFEB9C;border:none;padding:0in"><b><span style="font-size:10.0pt;color:black">[EXTERNAL EMAIL]</span></b><span style="color:black">
</span><span style="font-size:8.0pt;color:black">DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe.</span><o:p></o:p></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal">Just to be pedantic, there's variation in whether databases are constructed with separate location and event tables, or take a unified view towards a location/event. Separate tables are useful in cases where there is repeat sampling at
a single location. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">But that said... we, too, would likely declare those to be separate events (also separate specimen lots — we'd likely separate them into two containers). In a slightly more debatable decision, we may also create separate "events" when a
single sample is split between ethanol and formalin preservative. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">-Dean<br>
-- <br>
Dean Pentcheff<br>
<a href="mailto:pentcheff@gmail.com" target="_blank">pentcheff@gmail.com</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:dpentche@nhm.org" target="_blank">pentcheff@nhm.org</a><br>
<a href="https://research.nhm.org/disco" target="_blank">https://research.nhm.org/disco</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><img border="0" width="300" height="73" style="width:3.125in;height:.7604in" id="_x0000_i1027" src="http://research.nhm.org/images/DISCO_lockup_4color-300.png"><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Fri, Apr 12, 2024 at 12:50<span style="font-family:"Arial",sans-serif"> </span>AM Tom Schiøtte <<a href="mailto:tschioette@snm.ku.dk">tschioette@snm.ku.dk</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:#1F497D">Hi Nate,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:#1F497D">I agree with Brian (and yourself apparently). In our setup collecting gear is part of the event record as is a field
for ‘Fresh water/Marine/Terrestrial’. These only give meaning when two events are recorded.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:#1F497D">Cheers</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:#1F497D">Tom</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Calibri",sans-serif;color:#1F497D">Tom Schiøtte</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Calibri",sans-serif;color:#1F497D"> </span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Calibri",sans-serif;color:#1F497D">Collection manager, Echinodermata & Mollusca</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Calibri",sans-serif;color:#1F497D">Natural History Museum of Denmark (Zoology)</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="DA" style="font-family:"Calibri",sans-serif;color:#1F497D">Universitetsparken 15</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="DA" style="font-family:"Calibri",sans-serif;color:#1F497D">DK 2100 Copenhagen OE</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="DA" style="font-family:"Calibri",sans-serif;color:#1F497D"> </span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="DA" style="font-family:"Calibri",sans-serif;color:#1F497D">+45 35 32 10 48</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="DA" style="font-family:"Calibri",sans-serif;color:#1F497D"><a href="mailto:TSchioette@snm.ku.dk" target="_blank">TSchioette@snm.ku.dk</a></span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="DA" style="font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="DA" style="font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="DA" style="font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;border-color:currentcolor currentcolor">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Calibri",sans-serif">From:</span></b><span style="font-family:"Calibri",sans-serif"> Nhcoll-l <<a href="mailto:nhcoll-l-bounces@mailman.yale.edu" target="_blank">nhcoll-l-bounces@mailman.yale.edu</a>>
<b>On Behalf Of </b>Sidlauskas, Brian<br>
<b>Sent:</b> 12. april 2024 02:15<br>
<b>To:</b> Shoobs, Nate <<a href="mailto:shoobs.1@osu.edu" target="_blank">shoobs.1@osu.edu</a>>;
<a href="mailto:nhcoll-l@mailman.yale.edu" target="_blank">nhcoll-l@mailman.yale.edu</a><br>
<b>Subject:</b> Re: [Nhcoll-l] How does your collection handle sites with multiple habitats sampled?</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width="100%" style="width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"wf_segoe-ui_normal",serif;color:#212121">You don't often get email from
<a href="mailto:brian.sidlauskas@oregonstate.edu" target="_blank">brian.sidlauskas@oregonstate.edu</a>.
<a href="https://aka.ms/LearnAboutSenderIdentification" target="_blank">Learn why this is important</a></span><o:p></o:p></p>
</div>
</td>
<td width="75" style="width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt">
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi Nate,<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Figured I’d respond to this one, since I’m asking you for more caliper advice.
<span style="font-family:"Segoe UI Emoji",sans-serif">😉</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">This sounds like a case of one locality with two different collecting events. Even when a team is targeting all the same nominal taxon (e.g., just fishes, or just insects, or whatever)
I think the differences in collecting method (trap versus seine versus shocker) are relevant when more than one method is used at a site. So, I’d record this as two separate collecting events with different associated data in the collection method field.
There might also be differences in fields like depth, start time and end time. I’d probably record the microhabitat details in a free text field (not the locality description).
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Best Fishes,
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">---- Brian<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:#E36C0A">____________________________________</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Brian Sidlauskas</span></b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Professor and Curator of Fishes</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Department of Fisheries, Wildlife and Conservation Sciences</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Oregon State University</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">104 Nash Hall</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Corvallis, OR 97331</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Pronouns: he/his/him</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><a href="mailto:brian.sidlauskas@oregonstate.edu" target="_blank" title="mailto:brian.sidlauskas@oregonstate.edu"><span style="color:#0563C1">brian.sidlauskas@oregonstate.edu</span></a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><a href="tel:541-737-6789" target="_blank"><span style="color:#0563C1">541-737-6789</span></a> (office) <a href="tel:541-224-3850" target="_blank" title="tel:541-224-3850"><span style="color:#0563C1">541-224-3850</span></a> (cell)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><a href="http://ichthyology.oregonstate.edu/" target="_blank" title="Original URL:
http://ichthyology.oregonstate.edu/
Click to follow link."><span style="color:#0563C1">http://ichthyology.oregonstate.edu</span></a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><a href="https://www.facebook.com/brian.sidlauskas" target="_blank" title="Original URL:
https://www.facebook.com/brian.sidlauskas
Click to follow link."><span style="color:#0563C1">https://www.facebook.com/brian.sidlauskas</span></a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><a href="https://twitter.com/briansidlauskas" target="_blank" title="Original URL:
https://twitter.com/briansidlauskas
Click to follow link."><span style="color:#0563C1">https://twitter.com/briansidlauskas</span></a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:"Calibri",sans-serif;color:black"><img border="0" width="96" height="104" style="width:1.0in;height:1.0833in" id="m_3675584203495811591_x005f_x0000_i1025" src="cid:image001.png@01DA9AD9.F8DA7CA0" alt="Logo
Description automatically generated with medium confidence"></span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;border-color:currentcolor currentcolor">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Calibri",sans-serif;color:black">From:
</span></b><span style="font-family:"Calibri",sans-serif;color:black">Nhcoll-l <<a href="mailto:nhcoll-l-bounces@mailman.yale.edu" target="_blank">nhcoll-l-bounces@mailman.yale.edu</a>> on behalf of "Shoobs, Nate" <<a href="mailto:shoobs.1@osu.edu" target="_blank">shoobs.1@osu.edu</a>><br>
<b>Date: </b>Thursday, April 11, 2024 at 6:39 PM<br>
<b>To: </b>"<a href="mailto:nhcoll-l@mailman.yale.edu" target="_blank">nhcoll-l@mailman.yale.edu</a>" <<a href="mailto:nhcoll-l@mailman.yale.edu" target="_blank">nhcoll-l@mailman.yale.edu</a>><br>
<b>Subject: </b>[Nhcoll-l] How does your collection handle sites with multiple habitats sampled?</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%;display:table;float:none">
<tbody>
<tr>
<td style="background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width="100%" style="width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121">You don't often get email from
<a href="mailto:shoobs.1@osu.edu" target="_blank">shoobs.1@osu.edu</a>. <a href="https://aka.ms/LearnAboutSenderIdentification" target="_blank">
Learn why this is important</a></span><o:p></o:p></p>
</div>
</td>
<td width="75" style="width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt">
</td>
</tr>
</tbody>
</table>
<div>
<p><span style="color:#D73F09">[This email originated from outside of OSU. Use caution with links and attachments.]</span><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hey all,<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">A jar containing 5 species of 5 species of land snails bears the following collecting data:
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">“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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b>Would this be one collecting event in your collection, or two? How would you parse the data, and why?</b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b> </b><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">(Assume that both the crayfish and snails are in-scope for your collection, of course.)<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">-Nate<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">--</span><o:p></o:p></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"><img border="0" width="224" height="45" style="width:2.3333in;height:.4687in" id="m_3675584203495811591Picture_x0020_1" src="cid:image002.png@01DA9AD9.F8DA7CA0" alt="The Ohio State University"></span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#333333"><br>
</span><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#BB0000;background:white">Nathaniel F. Shoobs</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#333333"><br>
Curator of Mollusks<br>
</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#BB0000;background:white">College of Arts & Sciences</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#333333"> 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/" target="_blank"><span style="color:#0563C1;background:white">mbd.osu.edu</span></a></span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Nhcoll-l mailing list<br>
<a href="mailto:Nhcoll-l@mailman.yale.edu" target="_blank">Nhcoll-l@mailman.yale.edu</a><br>
<a href="https://mailman.yale.edu/mailman/listinfo/nhcoll-l" target="_blank">https://mailman.yale.edu/mailman/listinfo/nhcoll-l</a><br>
<br>
_______________________________________________<br>
NHCOLL-L is brought to you by the Society for the Preservation of<br>
Natural History Collections (SPNHC), an international society whose<br>
mission is to improve the preservation, conservation and management of<br>
natural history collections to ensure their continuing value to<br>
society. See <a href="http://www.spnhc.org/" target="_blank">http://www.spnhc.org</a> for membership information.<br>
Advertising on NH-COLL-L is inappropriate.<o:p></o:p></p>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<p>On Now at ROM, <a href="https://www.rom.on.ca/en/exhibitions-galleries/exhibitions/wildlife-photographer-of-the-year-2023">
<i>Wildlife Photographer of the Year</i></a> showcases the best of the best in nature photography. Book tickets at
<a href="https://www.rom.on.ca/en">rom.ca</a>.</p>
<hr size="0" width="100%" align="center">
<p>À l’affiche du ROM, <a href="https://www.rom.on.ca/fr/expositions-et-galeries/expositions/le-photographe-naturaliste-de-lannee-2023">
<i>Le Photographe naturaliste de l’année</i></a> – l’excellence en matière de photographie naturaliste. Réservez vos billets
<a href="https://www.rom.on.ca/fr">rom.ca/fr</a>.</p>
</body>
</html>