<div dir="ltr">Nicolas,<br>
<br>That's also a good option, although a little bit less easier to use than pygbif.<br>
<br>
Another option is rgbif (<a href="https://github.com/ropensci/rgbif">https://github.com/ropensci/rgbif</a>), a R package which has much of the same functionality of pygbif.<br>
<br>
Best regards,<br><div class="gmail_extra"><br><div class="gmail_quote">2016-05-30 14:15 GMT-03:00 Nicolas Noé <span dir="ltr"><<a href="mailto:n.noe@biodiversity.be" target="_blank">n.noe@biodiversity.be</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<font size="-1"><font face="Verdana">Hi all,<br>
<br>
Python-dwca-reader[1] may also help to extract data from the
download when populating the database<br>
<br>
[1] <a href="http://python-dwca-reader.readthedocs.io/en/latest/" target="_blank">http://python-dwca-reader.readthedocs.io/en/latest/</a><br>
<br>
Best,<br>
<br>
Nicolas<br>
</font></font><br>
<div>Le 30/05/16 14:48, Jan Legind a écrit :<br>
</div>
<blockquote type="cite">
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Dear
Juan,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Unfortunately
we have no tool for creating these kind of SQL like queries
to the portal. I am sure you are aware that the filters in
the occurrence search pages can be applied in combination in
numerous ways. The API can go even further in this
regard[1], but it not well suited for retrieving occurrence
records since there is a 200.000 records ceiling making it
unfit for species exceeding this number.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)">There
is going be updates to the pygbif package[2] in the near
future that will enable you to launch user downloads
programmatically where a whole list of different species can
be used as a query parameter as well as adding polygons.[3]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)">In
the meantime, Mauro’s suggestion is excellent. If you can
narrow your search down until it returns a manageable
download (say less than 100 million records), importing this
into a database should be doable. From there, you can refine
using SQL queries.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Best,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)">Jan
K. Legind, GBIF Data manager <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)">[1]
<a href="http://www.gbif.org/developer/occurrence#search" target="_blank">http://www.gbif.org/developer/occurrence#search</a>
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)">[2]
<a href="https://github.com/sckott/pygbif" target="_blank">https://github.com/sckott/pygbif</a>
<u></u>
<u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)">[3]
<a href="https://github.com/jlegind/GBIF-downloads" target="_blank">https://github.com/jlegind/GBIF-downloads</a>
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10pt;font-family:"Tahoma","sans-serif"">
API-users [<a href="mailto:api-users-bounces@lists.gbif.org" target="_blank">mailto:api-users-bounces@lists.gbif.org</a>]
<b>On Behalf Of </b>Mauro Cavalcanti<br>
<b>Sent:</b> 30. maj 2016 14:06<br>
<b>To:</b> Juan M. Escamilla Molgora<br>
<b>Cc:</b> <a href="mailto:api-users@lists.gbif.org" target="_blank">api-users@lists.gbif.org</a><br>
<b>Subject:</b> Re: [API-users] Is there any NEO4J or
graph-based driver for this API ?<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12pt">Hi,<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12pt">One
solution I have successfully adopted for this is to
download the records (either "manually" via browser or,
yet better, using a Python script using the fine pygbif
library), storing them into a MySQL or SQLite database and
then perform the relational queries. I can provide
examples if you are interested.<u></u><u></u></p>
</div>
<p class="MsoNormal">Best regards,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">2016-05-30 8:59 GMT-03:00 Juan M.
Escamilla Molgora <<a href="mailto:j.escamillamolgora@lancaster.ac.uk" target="_blank">j.escamillamolgora@lancaster.ac.uk</a>>:<u></u><u></u></p>
<p class="MsoNormal">Hola,<br>
<br>
Is there any API for making relational queries like
taxonomy, location or timestamp?<br>
<br>
Thank you and best wishes<br>
<br>
Juan<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><u></u><u></u></p>
</div>
<p class="MsoNormal"><br>
<br clear="all"><span class=""><font color="#888888">
<br>
-- <u></u><u></u></font></span></p><span class=""><font color="#888888">
<div>
<p class="MsoNormal">Dr. Mauro J. Cavalcanti<br>
E-mail: <a href="mailto:maurobio@gmail.com" target="_blank">maurobio@gmail.com</a><br>
Web: <a href="http://sites.google.com/site/maurobio" target="_blank">http://sites.google.com/site/maurobio</a><u></u><u></u></p>
</div>
</font></span></div><span class=""><font color="#888888">
</font></span></div><span class=""><font color="#888888">
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
API-users mailing list
<a href="mailto:API-users@lists.gbif.org" target="_blank">API-users@lists.gbif.org</a>
<a href="http://lists.gbif.org/mailman/listinfo/api-users" target="_blank">http://lists.gbif.org/mailman/listinfo/api-users</a>
</pre>
</font></span></blockquote>
<br>
</div>
<br>_______________________________________________<br>
API-users mailing list<br>
<a href="mailto:API-users@lists.gbif.org">API-users@lists.gbif.org</a><br>
<a href="http://lists.gbif.org/mailman/listinfo/api-users" rel="noreferrer" target="_blank">http://lists.gbif.org/mailman/listinfo/api-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Dr. Mauro J. Cavalcanti<br>E-mail: <a href="mailto:maurobio@gmail.com" target="_blank">maurobio@gmail.com</a><br>Web: <a href="http://sites.google.com/site/maurobio" target="_blank">http://sites.google.com/site/maurobio</a></div>
</div></div>