search

gbif / portal-feedback

User feedback for the GBIF API, website and published data. You can ask questions here. 🗨❓
30 stars 16 forks source link

Adding H3 grids to SQL API #5484

Open sformel-usgs opened 1 month ago

sformel-usgs commented 1 month ago

The SQL API offers 3 gridded versions of the data: https://techdocs.gbif.org/en/data-use/api-sql-download-functions#grid-functions

Would it be possible to add an H3 grid as a product (at as high a resolution as possible)? In the United States we're seeing a lot of interest in using this grid and it would save us significant computation time if it could be added to the GBIF downloads.

We discussed briefly at the Data Use Club today and @jhnwllr suggested we pull an issue here with the request. Tagging @mathewbiddle who is also working with H3 and may be able to offer more details about the use case.

MattBlissett commented 1 month ago

It should be possible.

After discussions on hexagonal grids earlier in the year we added ISEA 3H grids, which is an OGC standard

https://techdocs.gbif.org/en/data-use/api-sql-download-functions#isea3h-grid-cell-code-gbif_isea3hcode

See https://github.com/gbif/occurrence-cube/issues/23 for some discussion on that.

sformel-usgs commented 1 month ago

Thanks @MattBlissett ! I'll also look more into ISEA 3H grids. This is still new territory for me, but an open standard makes sense to follow.

MathewBiddle commented 1 month ago

We've been tinkering with H3 grids at: