[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