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>
