<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>Dear Markus,</p>
<p><br>
</p>
<p>
<meta content="text/html; charset=UTF-8">
</p>
<div dir="ltr">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, "EmojiFont", "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;">
<p>many thanks for the quick reply and the added documentation! This is exactly what I was looking for.</p>
<p><br>
</p>
<p>Did you ever consider having a mechanism with which checklist maintainers could feed in mapping data or do you want this to be a purely functional dependency of the checklists? Having stateful mapping would allow for an easy mapping between legacy (often
non maintained) checklists/taxonomies and CoL. Could the same effect be achieved by adding synonyms to those legacy checklists.</p>
<p><br>
</p>
<p>Best regards!<br>
</p>
</div>
<div dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, "EmojiFont", "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;">
<p><br>
</p>
<div id="x_Signature">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:rgb(0,0,0); font-family:Calibri,Helvetica,sans-serif,"EmojiFont","Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols">
<div>
<p>--<br>
</p>
<p>Raffael Mancini</p>
<p>IT administrator and developer</p>
<p>Service d'information digital sur le patrimoine naturel (SIDPNAT)<br>
</p>
<p>Musée National d'Histoire Naturelle Luxembourg</p>
T: +352 247 66667 - https://mnhn.lu</div>
<p><br>
</p>
</div>
</div>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Markus Döring <mdoering@gbif.org><br>
<b>Sent:</b> 14 August 2023 14:23:00<br>
<b>To:</b> MANCINI Raffael; Catalogue of Life user announcements and discussion<br>
<b>Subject:</b> Re: [COL-Users] CLB API related data</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt">
<div class="PlainText">Dear Raffael,<br>
<br>
ChecklistBank (CLB) contains a NamesIndex which tracks unique names and automatically provides a mapping between all names of all datasets in CLB.<br>
I have added a section to the API docs here that might be valuable for you:<br>
<a href="https://github.com/CatalogueOfLife/backend/blob/master/API.md#names-index" id="LPlnk64002" previewremoved="true">https://github.com/CatalogueOfLife/backend/blob/master/API.md#names-index</a><br>
<br>
In particular there is a ID mapping export that seems to exactly suit your needs:<br>
<a href="https://github.com/CatalogueOfLife/backend/blob/master/API.md#names-index-id-mapping-exports" id="LPlnk317186" previewremoved="true">https://github.com/CatalogueOfLife/backend/blob/master/API.md#names-index-id-mapping-exports</a><br>
<br>
<br>
Best wishes,<br>
Markus<br>
<br>
<br>
> On 9. Aug 2023, at 14:09, MANCINI Raffael via COL-Users <col-users@lists.gbif.org> wrote:<br>
> <br>
> Dear list,<br>
> <br>
> I'm developing a national "datawarehouse"/repository for natural history observation/occurrence data integrating several sources including GBIF and iNaturalist. For this purpose I'm generating lists of names and taxa related to the different ingested observation
sources. In order to offer unified taxon search and filter functionality, I need equivalence mappings between ID-namespaces of different checklists (GBIF, CoL, internal, ornitho.lu, etc). I noticed that the CLB API offers the call `/dataset/{key}/nameusage/{id}/related`
which for key=3LR and datasetKey=139831 [iNat] returns a correspondence.<br>
> <br>
> Where does the data for this mapping come from? Examining both the CoL and iNat checklists NameRelation.tsv (from the CoLDP downloads) didn't give a match. Is this data imported into CLB though a different checklist or is it supplemented though some more
hidden datasource? The ID-namespace translation does not seem to be universally implemented and seems somehow tied to the dataset (translation from iNat to CoL didn't seem to work), is this correct? Do you plan on supporting my use-case more explicitly in
the future?<br>
> <br>
> I would prefer not to use the CLB API and instead import the relevant checklists into our postgresql database in order to allow for an efficient and flexible operation.<br>
> <br>
> Thanks for the great work that went into CLB and related projects!<br>
> <br>
> Best regards,<br>
> <br>
> --<br>
> Raffael Mancini<br>
> IT administrator and developer<br>
> Service d'information digital sur le patrimoine naturel (SIDPNAT)<br>
> Musée National d'Histoire Naturelle Luxembourg<br>
> T: +352 247 66667 - <a href="https://mnhn.lu" id="LPlnk675227">https://mnhn.lu</a><br>
> <br>
> _______________________________________________<br>
> COL-Users mailing list<br>
> COL-Users@lists.gbif.org<br>
> <a href="https://lists.gbif.org/mailman/listinfo/col-users">https://lists.gbif.org/mailman/listinfo/col-users</a><br>
<br>
<br>
</div>
</span></font></div>
</body>
</html>