<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">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 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>
<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>
<br>
Cheers<br>
Chris<br>
<br>
<br>
Am 14.11.2016 um 17:40 schrieb Scott Chamberlain:<br>
</div>
<blockquote cite="mid:CAD-oS=9Tc3_90T=4oB2S_kzWsjmnhGPQ1E+fc6HtHZ5rrrvJHw@mail.gmail.com" type="cite">
<div dir="ltr">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">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><br>
</div>
<div>Scott</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr">On Mon, Nov 14, 2016 at 7:50 AM Markus Döring <<a moz-do-not-send="true" href="mailto:mdoering@gbif.org">mdoering@gbif.org</a>> wrote:<br>
</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="color:rgb(0,0,0);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="color:rgb(0,0,0);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="m_6703429565373641011Apple-interchange-newline
gmail_msg">
</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="m_6703429565373641011Apple-interchange-newline
gmail_msg">
<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>
<p><br>
</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>
Zoologisches Forschungsmuseum Alexander Koenig<br>
- Leibniz-Institut für Biodiversität der Tiere -<br>
Adenauerallee 160, 53113 Bonn, Germany<br>
www.zfmk.de<br>
<br>
Stiftung des öffentlichen Rechts; Direktor: Prof. J. Wolfgang Wägele<br>
Sitz: Bonn<br>
</body>
</html>