<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi all,<br>
<br>
do concur with Andy, and this problem (one-to-many relations) e.g.
holds also true for scanned insect drawers (x species from y
localities with z individualised tissues etc.), lichen/fungi
collections (x grows on y and consumes z and I do have tissues of
all) or if you want to match one regulation/permit to many
collection objects with different hierarchies / storage location.
<br>
<br>
Even though we tackled this nicely in our modular database, no
matter how nice your solution is, as soon as these data should get
shared, we run into troubles. Might be worth if somebody could
look into this ... especially if we are meant to stay on track of
utilised GR under the Nagoya Protocol, i.e. which part comes out
of what. So there might also a be legal responsibility not too
loose this connection when they share data in the public.<br>
<br>
All the best<br>
Dirk<br>
<br>
<br>
Am 03.03.2017 um 18:47 schrieb Bentley, Andrew Charles:<br>
</div>
<blockquote
cite="mid:052f1cfa27d441539dc723118d4300c9@ex13-ell-cr-13.home.ku.edu"
type="cite">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@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]-->
<div class="WordSection1">
<p class="MsoNormal">Hi all<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">During various conversations I have had
over the past couple of months in my capacity as Specify
usability consultant and ichthyology collection manager it has
become clear to me that one of the major hurdles that is
experienced with aggregators and sharing of data through
Darwin Core is the preparation field. Most of the other
one-to-many relationships have been taken care of
(identifications, measurements, collectors, sequences, media
etc.) through similar extensions or other means leaving
preparations as the only one left to tackle. Due to the
nature of fish collections and our propensity to utilize the
one-to-many relationship between specimens and preparations
for all the various preparations we house (ethanol, cleared
and stained, skeletal, tissue), coupled with the fact that
there is only a single field in Darwin Core for preparations,
mandates that we need to concatenate our preparations into a
string (or simply not map them) in order to be able to map
them effectively. As such these concatenations can and do
include information about preparation type, counts and various
other pieces of information thus littered the field with a
huge amount of unique values (160,000 to be exact). With the
ever increasing proliferation of tissue collections in all
disciplines this is becoming a more pressing issue for more
than just fish collections and is now more widespread across
all disciplines.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Given the above, I was thinking of
proposing a preparation extension to Darwin Core to
accommodate this but as a first step would like to get
feedback from the community as to the perceived need and
efficacy for such an extension. The extension need not be
very complex and would nominally include fields for
preparation type (controlled vocabulary), count (number),
prepared by (agent), prepared date and maybe a unique GUID.
However, the extension would only be useful if the aggregators
(GBIF, iDigBio etc.) were able to display the data within this
extension as part of their portal infrastructure thereby
increasing the usefulness of the records for research
purposes. Do you think such an extension would be useful?
What fields would you like to see included? Question for the
aggregators – would this data be able to be displayed fore
efficient use by the ever growing user community?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Any comments, suggestions, ideas for
additional fields etc. are most welcome. Please forward to
others who may not be on NHCOLL and who may be interested.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks in advance<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Andy<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"
lang="EN-AU"> A : A : A :<br>
}<(((_°>.,.,.,.}<(((_°>.,.,.,.}<)))_°><br>
V V V<br>
Andy Bentley<br>
Ichthyology Collection Manager<br>
University of Kansas<br>
Biodiversity Institute<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"
lang="EN-AU">Dyche Hall<br>
1345 Jayhawk Boulevard<br>
Lawrence, KS, 66045-7561<br>
USA<br>
<br>
Tel: (785) 864-3863<br>
Fax: (785) 864-5335 <br>
Email: <a moz-do-not-send="true" href="mailto:abentley@ku.edu"><span style="color:blue">abentley@ku.edu</span></a> <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"
lang="EN-AU"><a moz-do-not-send="true" href="https://urldefense.proofpoint.com/v2/url?u=http-3A__ichthyology.biodiversity.ku.edu_&d=DwMFAw&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=CLFZJ3fvGSmDp7xK1dNZfh6uGV_h-8NVlo3fXNoRNzI&m=39WrfUekMrju94v_4HVXBriqB-P3C3JDjHSPlGQ0F10&s=Y-pre1byIqhER5aOPnKwA6RU5zGLWaYvXiaAEpxSCV8&e="><span
style="color:blue">http://ichthyology.biodiversity.ku.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"
lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"
lang="EN-AU">SPNHC Past-President<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"
lang="EN-AU"><a moz-do-not-send="true" href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.spnhc.org_&d=DwMFAw&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=CLFZJ3fvGSmDp7xK1dNZfh6uGV_h-8NVlo3fXNoRNzI&m=39WrfUekMrju94v_4HVXBriqB-P3C3JDjHSPlGQ0F10&s=JsEgPq1MVcz4zQakIqqrd9BJT_JYieGi3tH_P58Qgwo&e="><span
style="color:blue">http://www.spnhc.org</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"
lang="EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"
lang="EN-AU"> :
: <br>
A : A : A :<br>
}<(((_°>.,.,.,.}<(((_°>.,.,.,.}<)))_°><br>
V V V</span><span
style="color:#1F497D" lang="EN-AU"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Nhcoll-l mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Nhcoll-l@mailman.yale.edu">Nhcoll-l@mailman.yale.edu</a>
<a class="moz-txt-link-freetext" href="http://mailman.yale.edu/mailman/listinfo/nhcoll-l">http://mailman.yale.edu/mailman/listinfo/nhcoll-l</a>
_______________________________________________
NHCOLL-L is brought to you by the Society for the Preservation of
Natural History Collections (SPNHC), an international society whose
mission is to improve the preservation, conservation and management of
natural history collections to ensure their continuing value to
society. See <a class="moz-txt-link-freetext" href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.spnhc.org&d=DwMD-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=CLFZJ3fvGSmDp7xK1dNZfh6uGV_h-8NVlo3fXNoRNzI&m=nZmDqhH2vjtf7cdg9gXJCDIL8U1ekW2iLMM1E3MFFb4&s=h82ZGamslkAz9hyWHbcFHL7evfoVNdAuzknPaG0wTCE&e=">http://www.spnhc.org</a> for membership information.
Advertising on NH-COLL-L is inappropriate.
</pre>
</blockquote>
<br>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Dirk Neumann
Tel: 089 / 8107-111
Fax: 089 / 8107-300
email: Dirk.Neumann(a)zsm.mwn.de
Postanschrift:
Staatliche Naturwissenschaftliche Sammlungen Bayerns
Zoologische Staatssammlung München
Dirk Neumann, Sektion Ichthyologie / DNA-Labor
Münchhausenstr. 21
81247 München
Besuchen Sie unsere Sammlung:
<a class="moz-txt-link-freetext" href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.zsm.mwn.de_ich_&d=DwMD-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=CLFZJ3fvGSmDp7xK1dNZfh6uGV_h-8NVlo3fXNoRNzI&m=nZmDqhH2vjtf7cdg9gXJCDIL8U1ekW2iLMM1E3MFFb4&s=aqbQ4xl7C65fOgg-BcYGI9M_OBEPpanTnRVLWBJL75k&e=">http://www.zsm.mwn.de/ich/</a>
---------
Dirk Neumann
Tel: +49-89-8107-111
Fax: +49-89-8107-300
email: Dirk.Neumann(a)zsm.mwn.de
postal address:
Bavarian Natural History Collections
The Bavarian State Collection of Zoology
Dirk Neumann, Section Ichthyology / DNA-Lab
Muenchhausenstr. 21
81247 Munich (Germany)
Visit our section at:
<a class="moz-txt-link-freetext" href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.zsm.mwn.de_ich_&d=DwMD-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=CLFZJ3fvGSmDp7xK1dNZfh6uGV_h-8NVlo3fXNoRNzI&m=nZmDqhH2vjtf7cdg9gXJCDIL8U1ekW2iLMM1E3MFFb4&s=aqbQ4xl7C65fOgg-BcYGI9M_OBEPpanTnRVLWBJL75k&e=">http://www.zsm.mwn.de/ich/</a>
</pre>
</body>
</html>