<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 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:"Consolas","serif";
color:black;}
span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
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 bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi Christian,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’ve written a small Python script that runs through the DarwinCore archive Markus mentioned, extracts a given list of terms (taxon, vernacular names, but can
be extended) and writes bulk files that can be loaded into SQL Server. It’s lacking any documentation (apart from some inline comments), since I’ve only used it internally. But if you’re familiar with Python, it’s probably easy to adapt to MySQL’s format.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Just let me know if you want to give it a try.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Jörg<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="DE" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">Von:</span></b><span lang="DE" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> API-users [mailto:api-users-bounces@lists.gbif.org]
<b>Im Auftrag von </b>Köhler Christian<br>
<b>Gesendet:</b> Mittwoch, 16. November 2016 11:01<br>
<b>An:</b> api-users@lists.gbif.org<br>
<b>Betreff:</b> Re: [API-users] Backbone data as SQL<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi,<br>
<br>
I already looked at both of the git project. Looks interesting. Is I am more "pythonic" the idb-backend is easier to adapt for me.
<br>
Thanks for showing me. I was hoping that someone already addressed the question as it seemed to me quite obviously to provide the data in a widely used format like sql. I have the feeling I am reenventing the wheel ;-)
<br>
<br>
The "B-HIT" tool seems to be a reasonable alternative to get a the desired data into an sql data base. In case you are interested, have a look here:<br>
<a href="https://www.researchgate.net/publication/283543150_B-HIT_-_A_Tool_for_Harvesting_and_Indexing_Biodiversity_Data">https://www.researchgate.net/publication/283543150_B-HIT_-_A_Tool_for_Harvesting_and_Indexing_Biodiversity_Data</a><br>
<a href="https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4636251/">https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4636251/</a><br>
<br>
Cheers<br>
Chris<br>
<br>
<br>
Am 14.11.2016 um 17:40 schrieb Scott Chamberlain:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">Hi Chris, I started something a while back to automate building a SQLite version of the backbone taxonomy (<a href="https://github.com/ropensci/gbif-backbone-sql">https://github.com/ropensci/gbif-backbone-sql</a>) but it's not quite done
yet. Idea is to run on Heroku (e.g., once a day), resulting in a fresh SQLite version of the backbone taxonomy on Amazon S3.
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Scott<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Mon, Nov 14, 2016 at 7:50 AM Markus Döring <<a href="mailto:mdoering@gbif.org">mdoering@gbif.org</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p class="MsoNormal">Hi Chris, <o:p></o:p></p>
<div>
<p class="MsoNormal">the latest GBIF backbone is always available as a Darwin Core archive. This is mostly a collection of tab delimited text files with the accepted and synonym names at its core.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">You can find the latest and previous, archived versions here:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://rs.gbif.org/datasets/backbone/" target="_blank">http://rs.gbif.org/datasets/backbone/</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Best,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Markus<o:p></o:p></p>
</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">--<br>
Markus Döring<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Software Developer<br>
Global Biodiversity Information Facility (GBIF)<o:p></o:p></p>
<div>
<p class="MsoNormal"><a href="mailto:mdoering@gbif.org" target="_blank">mdoering@gbif.org</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://www.gbif.org" target="_blank">http://www.gbif.org</a><o:p></o:p></p>
</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"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On 14 Nov 2016, at 16:42, Köhler Christian <<a href="mailto:C.Koehler@zfmk.de" target="_blank">C.Koehler@zfmk.de</a>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Hi,<br>
<br>
we are developing an application to curate taxonomic and morphological<br>
data for scientists. At the moment we are evaluating different taxonomic<br>
backbones to be used within our application. The GIBF taxonomic backbone<br>
seems to be an good choice in regards to quality, number of entries and<br>
acceptance.<br>
<br>
Due to the nature of our application, a web service to browse the<br>
taxonomy will not fulfil our requirements. A local copy of the GIBF data<br>
as SQL would be an ideal solution. I looked for this data publicly<br>
available to no avail. "Harvesting" the GBIF rest api seems not a good<br>
option. Are there plans to provide current taxonomic backbone data in<br>
the future? Maybe the data is already available, but I failed to find it<br>
yet.<br>
<br>
Regards<br>
Chris<br>
<br>
--<br>
Christian Köhler<br>
Tel.: 0228 9122-434<br>
<br>
Zoologisches Forschungsmuseum Alexander Koenig<br>
Leibniz-Institut für Biodiversität der Tiere<br>
Adenauerallee 160, 53113 Bonn, Germany<br>
<a href="http://www.zfmk.de" target="_blank">www.zfmk.de</a><br>
<br>
Stiftung des öffentlichen Rechts<br>
Direktor: Prof. J. Wolfgang Wägele<br>
Sitz: Bonn<br>
--<br>
Zoologisches Forschungsmuseum Alexander Koenig<br>
- Leibniz-Institut für Biodiversität der Tiere -<br>
Adenauerallee 160, 53113 Bonn, Germany<br>
<a href="http://www.zfmk.de" target="_blank">www.zfmk.de</a><br>
<br>
Stiftung des öffentlichen Rechts; Direktor: Prof. J. Wolfgang Wägele<br>
Sitz: Bonn<br>
_______________________________________________<br>
API-users mailing list<br>
<a href="mailto:API-users@lists.gbif.org" target="_blank">API-users@lists.gbif.org</a><br>
<a href="http://lists.gbif.org/mailman/listinfo/api-users" target="_blank">http://lists.gbif.org/mailman/listinfo/api-users</a><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
API-users mailing list<br>
<a href="mailto:API-users@lists.gbif.org" target="_blank">API-users@lists.gbif.org</a><br>
<a href="http://lists.gbif.org/mailman/listinfo/api-users" target="_blank">http://lists.gbif.org/mailman/listinfo/api-users</a><o:p></o:p></p>
</blockquote>
</div>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
<p><o:p> </o:p></p>
<pre>-- <o:p></o:p></pre>
<pre>Christian Köhler<o:p></o:p></pre>
<pre>Tel.: 0228 9122-434<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Zoologisches Forschungsmuseum Alexander Koenig<o:p></o:p></pre>
<pre>Leibniz-Institut für Biodiversität der Tiere<o:p></o:p></pre>
<pre>Adenauerallee 160, 53113 Bonn, Germany<o:p></o:p></pre>
<pre><a href="http://www.zfmk.de">www.zfmk.de</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Stiftung des öffentlichen Rechts<o:p></o:p></pre>
<pre>Direktor: Prof. J. Wolfgang Wägele<o:p></o:p></pre>
<pre>Sitz: Bonn <o:p></o:p></pre>
<p class="MsoNormal">-- <br>
Zoologisches Forschungsmuseum Alexander Koenig<br>
- Leibniz-Institut für Biodiversität der Tiere -<br>
Adenauerallee 160, 53113 Bonn, Germany<br>
<a href="http://www.zfmk.de">www.zfmk.de</a><br>
<br>
Stiftung des öffentlichen Rechts; Direktor: Prof. J. Wolfgang Wägele<br>
Sitz: Bonn<o:p></o:p></p>
</div>
</body>
</html>