<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
Hi,
<div class="">if there is a demand in having the backbone as a SQL file we should maybe consider to provide one directly from GBIF ChecklistBanks relational model.</div>
<div class="">Would a single table with all taxa be sufficient as a start or are vernacular names, images and other additional information key?</div>
<div class="">I can probably supply a sql dump for the core taxonomy quickly, let me try.</div>
<div class=""><br class="">
</div>
<div class="">Markus</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On 16 Nov 2016, at 11:01, Köhler Christian <<a href="mailto:C.Koehler@zfmk.de" class="">C.Koehler@zfmk.de</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix">Hi,<br class="">
<br class="">
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 class="">
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 class="">
<br class="">
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 class="">
<a class="moz-txt-link-freetext" 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 class="">
<a class="moz-txt-link-freetext" href="https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4636251/">https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4636251/</a><br class="">
<br class="">
Cheers<br class="">
Chris<br class="">
<br class="">
<br class="">
Am 14.11.2016 um 17:40 schrieb Scott Chamberlain:<br class="">
</div>
<blockquote cite="mid:CAD-oS=9Tc3_90T=4oB2S_kzWsjmnhGPQ1E+fc6HtHZ5rrrvJHw@mail.gmail.com" type="cite" class="">
<div dir="ltr" class="">Hi Chris, I started something a while back to automate building a SQLite version of the backbone taxonomy (<a moz-do-not-send="true" href="https://github.com/ropensci/gbif-backbone-sql" class="">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.
<div class=""><br class="">
</div>
<div class="">Scott</div>
</div>
<br class="">
<div class="gmail_quote">
<div dir="ltr" class="">On Mon, Nov 14, 2016 at 7:50 AM Markus Döring <<a moz-do-not-send="true" href="mailto:mdoering@gbif.org" class="">mdoering@gbif.org</a>> wrote:<br class="">
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word" class="gmail_msg">Hi Chris,
<div class="gmail_msg">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.</div>
<div class="gmail_msg">You can find the latest and previous, archived versions here:</div>
<div class="gmail_msg"><a moz-do-not-send="true" href="http://rs.gbif.org/datasets/backbone/" class="gmail_msg" target="_blank">http://rs.gbif.org/datasets/backbone/</a></div>
<div class="gmail_msg"><br class="gmail_msg">
</div>
<div class="gmail_msg">Best,</div>
<div class="gmail_msg">Markus</div>
<div class="gmail_msg"><br class="gmail_msg">
</div>
<div class="gmail_msg"><br class="gmail_msg">
<div class="gmail_msg">
<div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; word-wrap: break-word;" class="gmail_msg">
--<br class="gmail_msg">
Markus Döring</div>
<div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; word-wrap: break-word;" class="gmail_msg">
Software Developer<br class="gmail_msg">
Global Biodiversity Information Facility (GBIF)<br class="gmail_msg">
<div class="gmail_msg"><a moz-do-not-send="true" href="mailto:mdoering@gbif.org" class="gmail_msg" target="_blank">mdoering@gbif.org</a></div>
<div class="gmail_msg"><a moz-do-not-send="true" href="http://www.gbif.org/" class="gmail_msg" target="_blank">http://www.gbif.org</a></div>
<div class="gmail_msg"><br class="gmail_msg">
</div>
<div class="gmail_msg"><br class="gmail_msg">
</div>
<div class="gmail_msg"><br class="gmail_msg">
</div>
</div>
<br class=" gmail_msg m_6703429565373641011Apple-interchange-newline
">
</div>
</div>
</div>
<div style="word-wrap:break-word" class="gmail_msg">
<div class="gmail_msg"><br class="gmail_msg">
<div class="gmail_msg">
<blockquote type="cite" class="gmail_msg">
<div class="gmail_msg">On 14 Nov 2016, at 16:42, Köhler Christian <<a moz-do-not-send="true" href="mailto:C.Koehler@zfmk.de" class="gmail_msg" target="_blank">C.Koehler@zfmk.de</a>> wrote:</div>
<br class=" gmail_msg m_6703429565373641011Apple-interchange-newline
">
<div class="gmail_msg">
<div class="gmail_msg">Hi,<br class="gmail_msg">
<br class="gmail_msg">
we are developing an application to curate taxonomic and morphological<br class="gmail_msg">
data for scientists. At the moment we are evaluating different taxonomic<br class="gmail_msg">
backbones to be used within our application. The GIBF taxonomic backbone<br class="gmail_msg">
seems to be an good choice in regards to quality, number of entries and<br class="gmail_msg">
acceptance.<br class="gmail_msg">
<br class="gmail_msg">
Due to the nature of our application, a web service to browse the<br class="gmail_msg">
taxonomy will not fulfil our requirements. A local copy of the GIBF data<br class="gmail_msg">
as SQL would be an ideal solution. I looked for this data publicly<br class="gmail_msg">
available to no avail. "Harvesting" the GBIF rest api seems not a good<br class="gmail_msg">
option. Are there plans to provide current taxonomic backbone data in<br class="gmail_msg">
the future? Maybe the data is already available, but I failed to find it<br class="gmail_msg">
yet.<br class="gmail_msg">
<br class="gmail_msg">
Regards<br class="gmail_msg">
Chris<br class="gmail_msg">
<br class="gmail_msg">
--<br class="gmail_msg">
Christian Köhler<br class="gmail_msg">
Tel.: 0228 9122-434<br class="gmail_msg">
<br class="gmail_msg">
Zoologisches Forschungsmuseum Alexander Koenig<br class="gmail_msg">
Leibniz-Institut für Biodiversität der Tiere<br class="gmail_msg">
Adenauerallee 160, 53113 Bonn, Germany<br class="gmail_msg">
<a moz-do-not-send="true" href="http://www.zfmk.de/" class="gmail_msg" target="_blank">www.zfmk.de</a><br class="gmail_msg">
<br class="gmail_msg">
Stiftung des öffentlichen Rechts<br class="gmail_msg">
Direktor: Prof. J. Wolfgang Wägele<br class="gmail_msg">
Sitz: Bonn<br class="gmail_msg">
--<br class="gmail_msg">
Zoologisches Forschungsmuseum Alexander Koenig<br class="gmail_msg">
- Leibniz-Institut für Biodiversität der Tiere -<br class="gmail_msg">
Adenauerallee 160, 53113 Bonn, Germany<br class="gmail_msg">
<a moz-do-not-send="true" href="http://www.zfmk.de/" class="gmail_msg" target="_blank">www.zfmk.de</a><br class="gmail_msg">
<br class="gmail_msg">
Stiftung des öffentlichen Rechts; Direktor: Prof. J. Wolfgang Wägele<br class="gmail_msg">
Sitz: Bonn<br class="gmail_msg">
_______________________________________________<br class="gmail_msg">
API-users mailing list<br class="gmail_msg">
<a moz-do-not-send="true" href="mailto:API-users@lists.gbif.org" class="gmail_msg" target="_blank">API-users@lists.gbif.org</a><br class="gmail_msg">
<a moz-do-not-send="true" href="http://lists.gbif.org/mailman/listinfo/api-users" class="gmail_msg" target="_blank">http://lists.gbif.org/mailman/listinfo/api-users</a><br class="gmail_msg">
</div>
</div>
</blockquote>
</div>
<br class="gmail_msg">
</div>
</div>
_______________________________________________<br class="gmail_msg">
API-users mailing list<br class="gmail_msg">
<a moz-do-not-send="true" href="mailto:API-users@lists.gbif.org" class="gmail_msg" target="_blank">API-users@lists.gbif.org</a><br class="gmail_msg">
<a moz-do-not-send="true" href="http://lists.gbif.org/mailman/listinfo/api-users" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.gbif.org/mailman/listinfo/api-users</a><br class="gmail_msg">
</blockquote>
</div>
</blockquote>
<br class="">
<p class=""><br class="">
</p>
<pre class="moz-signature" cols="72">--
Christian Köhler
Tel.: 0228 9122-434
Zoologisches Forschungsmuseum Alexander Koenig
Leibniz-Institut für Biodiversität der Tiere
Adenauerallee 160, 53113 Bonn, Germany
<a class="moz-txt-link-abbreviated" href="http://www.zfmk.de/">www.zfmk.de</a>
Stiftung des öffentlichen Rechts
Direktor: Prof. J. Wolfgang Wägele
Sitz: Bonn </pre>
-- <br class="">
Zoologisches Forschungsmuseum Alexander Koenig<br class="">
- Leibniz-Institut für Biodiversität der Tiere -<br class="">
Adenauerallee 160, 53113 Bonn, Germany<br class="">
<a href="http://www.zfmk.de" class="">www.zfmk.de</a><br class="">
<br class="">
Stiftung des öffentlichen Rechts; Direktor: Prof. J. Wolfgang Wägele<br class="">
Sitz: Bonn<br class="">
</div>
_______________________________________________<br class="">
API-users mailing list<br class="">
<a href="mailto:API-users@lists.gbif.org" class="">API-users@lists.gbif.org</a><br class="">
http://lists.gbif.org/mailman/listinfo/api-users<br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
</body>
</html>