[API-users] Is there any NEO4J or graph-based driver for this API ?

Nicolas Noé n.noe at biodiversity.be
Mon May 30 19:15:59 CEST 2016


Hi all,

Python-dwca-reader[1] may also help to extract data from the download 
when populating the database

[1] http://python-dwca-reader.readthedocs.io/en/latest/

Best,

Nicolas

Le 30/05/16 14:48, Jan Legind a écrit :
>
> Dear Juan,
>
> 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.
>
> 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]
>
> 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.
>
> Best,
>
> Jan K. Legind, GBIF Data manager
>
> [1] http://www.gbif.org/developer/occurrence#search
>
> [2] https://github.com/sckott/pygbif
>
> [3] https://github.com/jlegind/GBIF-downloads
>
> *From:*API-users [mailto:api-users-bounces at lists.gbif.org] *On Behalf 
> Of *Mauro Cavalcanti
> *Sent:* 30. maj 2016 14:06
> *To:* Juan M. Escamilla Molgora
> *Cc:* api-users at lists.gbif.org
> *Subject:* Re: [API-users] Is there any NEO4J or graph-based driver 
> for this API ?
>
> Hi,
>
> 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.
>
> Best regards,
>
> 2016-05-30 8:59 GMT-03:00 Juan M. Escamilla Molgora 
> <j.escamillamolgora at lancaster.ac.uk 
> <mailto:j.escamillamolgora at lancaster.ac.uk>>:
>
> Hola,
>
> Is there any API for making relational queries like taxonomy, location 
> or timestamp?
>
> Thank you and best wishes
>
> Juan
> _______________________________________________
> API-users mailing list
> API-users at lists.gbif.org <mailto:API-users at lists.gbif.org>
> http://lists.gbif.org/mailman/listinfo/api-users
>
>
>
>
> -- 
>
> Dr. Mauro J. Cavalcanti
> E-mail: maurobio at gmail.com <mailto:maurobio at gmail.com>
> Web: http://sites.google.com/site/maurobio
>
>
>
> _______________________________________________
> API-users mailing list
> API-users at lists.gbif.org
> http://lists.gbif.org/mailman/listinfo/api-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gbif.org/pipermail/api-users/attachments/20160530/6202c1f0/attachment-0001.html>


More information about the API-users mailing list