Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Enable GBIF SQL downloads #249

Open
mjwestgate opened this issue Nov 10, 2024 · 0 comments
Open

Enable GBIF SQL downloads #249

mjwestgate opened this issue Nov 10, 2024 · 0 comments
Labels
enhancement New feature or request

Comments

@mjwestgate
Copy link
Collaborator

GBIF have recently added an SQL download option. This has some potential benefits:

  • Would support grouped counts in a single query, including species lookup (atlas_species()) and species counts.
  • Good alignment between dplyr verbs (select(), filter(), group_by() etc) and SQL
  • Less custom code required than e.g. predicates

Caveats include:

  • Not optimised for quick counts, so perhaps not possible to replace whole GBIF query architecture yet
  • Performance unknown
  • API classed as 'experimental'

Further information:
@mjwestgate mjwestgate added the enhancement New feature or request label Nov 10, 2024
mjwestgate added a commit that referenced this issue Nov 11, 2024
@mjwestgate
Start testing code for GBIF SQL (#249)
9fbd911 
This API is not public yet, so unable to begin properly; however could be useful for grouped counts, species counts, and supporting select() in occurrence downloads. Option to use dbplyr for automatic translation isn't looking promising; own solution may be preferable.
@mjwestgate mjwestgate mentioned this issue Jan 17, 2025
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@mjwestgate