You are viewing a plain text version of this content. The canonical link for it is here.
Posted to geospatial@apache.org by Julian Hyde <jh...@apache.org> on 2018/09/28 17:58:23 UTC
H3
There was a lot of talk about H3 during the geospatial track. “It will change the world (or at least the way we represent it)” said George, IIRC.
I presume these are the best resources for it: https://github.com/uber/h3 <https://github.com/uber/h3> (code) and https://uber.github.io/h3/#/ <https://uber.github.io/h3/#/> (documentation).
Does anyone know of a SQL database that has added H3 functions? Also, is there are pure Java implementation (not just bindings that talk to a C back-end)?
Aside: H3 is an awful name for a library when it comes to search. Worse than “Go” and “C++”, if that was possible.
Julian
Re: H3
Posted by George Percivall <gp...@opengeospatial.org>.
Julian,
Some responses to the question
> "SQL database that has added DGGS functions”?
1. There is a PostgreSQL binding for H3 at https://github.com/dlr-eoc/pgh3
2. Riskaware's Open-Eaggr DGGS (https://github.com/riskaware-ltd/open-eaggr) says it integrates with Postgres and uses ISEA3H and ISEA4T grids.
3. there is an R library here: https://github.com/r-barnes/dggridR
On the up and coming: NRCan is supporting a project to create a DGGS domain language which is essentially SQL/noSQL style image algebra for DGGS. It features DGGS data fusion capabilities through simple command sets - traverse, compute, select and aggregate summaries ala map/filter/reduce. The intention is to publish the DGGS Language in the open community and a repository of executables on Github. It is presently in predesign phase so guessing a year away. Some consultation within the OGC DGGS community will occur early in the new year although the topic has already been discussed in the SWG and DWG.
Regards,
George
> On Sep 28, 2018, at 5:08 PM, George Percivall <gp...@opengeospatial.org> wrote:
>
> Julian,
>
> No worries I appreciate that you quoted me as it is an opportunity to advance the discussion.
> Will let you know if the DGGS working group members respond to your question: "SQL database that has added DGGS functions”?
>
> Thanks for the kind words. It was a pleasure to organize the track. Lets see if there is continuing interest in the geospatial as a cross-project topic.
>
> George
>
>
>
>> On Sep 28, 2018, at 5:04 PM, Julian Hyde <jh...@apache.org> wrote:
>>
>> George,
>>
>> Thank you for clarifying - and sorry if I misquoted you.
>>
>> It is definitely helpful to know that DGGS is a hot area, and that there are moves to standardize.
>>
>> And thank you, again, for organizing and chairing the track. I attended several of the sessions and felt a commonality of purpose among the various speakers. A good basis for a cross-project Geospatial community inside the ASF.
>>
>> Julian
>>
>>
>>> On Sep 28, 2018, at 1:50 PM, George Percivall <gp...@opengeospatial.org> wrote:
>>>
>>>
>>> My comment was about Discrete Global Grid Systems in general and the role of the OGC standard.
>>>
>>> OGC Discrete Global Grid Systems standard
>>> http://docs.opengeospatial.org/as/15-104r5/15-104r5.html
>>>
>>> From the OGC DGGS standard: "A DGGS is a spatial reference system that uses a hierarchical tessellation of cells to partition and address the globe. DGGS are characterized by the properties of their cell structure, geo-encoding, quantization strategy and associated mathematical functions.The OGC DGGS Abstract Specification supports the specification of standardized DGGS infrastructures that enable the integrated analysis of very large, multi-source, multi-resolution, multi-dimensional, distributed geospatial data. Interoperability between OGC DGGS implementations is anticipated through implementation standards, and extension interface encodings of OGC Web Services.”
>>>
>>> H3 is a good example of a DGGS.
>>> Uber presented H3 to the OGC DGGS Working group at the most recent OGC meeting earlier this month.
>>>
>>> There are other DGGSs:
>>> https://www.researchgate.net/publication/303093407_The_rHEALPix_Discrete_Global_Grid_System
>>> https://www.slideshare.net/ClintonDow/dggs-python-geopython-2017
>>> https://vimeo.com/204787821
>>> https://www.youtube.com/watch?v=xh5csOiRVsk
>>> https://www.unece.org/fileadmin/DAM/stats/documents/ece/ces/ge.58/2017/mtg3/S1_LEWIS_DGGS_pres_final.pdf
>>>
>>> Julian - I will ask around for an "SQL database that has added DGGS functions"
>>>
>>> George
>>>
>>>
>>>
>>>
>>>> On Sep 28, 2018, at 1:58 PM, Julian Hyde <jh...@apache.org> wrote:
>>>>
>>>> There was a lot of talk about H3 during the geospatial track. “It will change the world (or at least the way we represent it)” said George, IIRC.
>>>>
>>>> I presume these are the best resources for it: https://github.com/uber/h3 <https://github.com/uber/h3> (code) and https://uber.github.io/h3/#/ <https://uber.github.io/h3/#/> (documentation).
>>>>
>>>> Does anyone know of a SQL database that has added H3 functions? Also, is there are pure Java implementation (not just bindings that talk to a C back-end)?
>>>>
>>>> Aside: H3 is an awful name for a library when it comes to search. Worse than “Go” and “C++”, if that was possible.
>>>>
>>>> Julian
>>>>
>>>>
>>>
>>
>
Re: H3
Posted by George Percivall <gp...@opengeospatial.org>.
Julian,
No worries I appreciate that you quoted me as it is an opportunity to advance the discussion.
Will let you know if the DGGS working group members respond to your question: "SQL database that has added DGGS functions”?
Thanks for the kind words. It was a pleasure to organize the track. Lets see if there is continuing interest in the geospatial as a cross-project topic.
George
> On Sep 28, 2018, at 5:04 PM, Julian Hyde <jh...@apache.org> wrote:
>
> George,
>
> Thank you for clarifying - and sorry if I misquoted you.
>
> It is definitely helpful to know that DGGS is a hot area, and that there are moves to standardize.
>
> And thank you, again, for organizing and chairing the track. I attended several of the sessions and felt a commonality of purpose among the various speakers. A good basis for a cross-project Geospatial community inside the ASF.
>
> Julian
>
>
>> On Sep 28, 2018, at 1:50 PM, George Percivall <gp...@opengeospatial.org> wrote:
>>
>>
>> My comment was about Discrete Global Grid Systems in general and the role of the OGC standard.
>>
>> OGC Discrete Global Grid Systems standard
>> http://docs.opengeospatial.org/as/15-104r5/15-104r5.html
>>
>> From the OGC DGGS standard: "A DGGS is a spatial reference system that uses a hierarchical tessellation of cells to partition and address the globe. DGGS are characterized by the properties of their cell structure, geo-encoding, quantization strategy and associated mathematical functions.The OGC DGGS Abstract Specification supports the specification of standardized DGGS infrastructures that enable the integrated analysis of very large, multi-source, multi-resolution, multi-dimensional, distributed geospatial data. Interoperability between OGC DGGS implementations is anticipated through implementation standards, and extension interface encodings of OGC Web Services.”
>>
>> H3 is a good example of a DGGS.
>> Uber presented H3 to the OGC DGGS Working group at the most recent OGC meeting earlier this month.
>>
>> There are other DGGSs:
>> https://www.researchgate.net/publication/303093407_The_rHEALPix_Discrete_Global_Grid_System
>> https://www.slideshare.net/ClintonDow/dggs-python-geopython-2017
>> https://vimeo.com/204787821
>> https://www.youtube.com/watch?v=xh5csOiRVsk
>> https://www.unece.org/fileadmin/DAM/stats/documents/ece/ces/ge.58/2017/mtg3/S1_LEWIS_DGGS_pres_final.pdf
>>
>> Julian - I will ask around for an "SQL database that has added DGGS functions"
>>
>> George
>>
>>
>>
>>
>>> On Sep 28, 2018, at 1:58 PM, Julian Hyde <jh...@apache.org> wrote:
>>>
>>> There was a lot of talk about H3 during the geospatial track. “It will change the world (or at least the way we represent it)” said George, IIRC.
>>>
>>> I presume these are the best resources for it: https://github.com/uber/h3 <https://github.com/uber/h3> (code) and https://uber.github.io/h3/#/ <https://uber.github.io/h3/#/> (documentation).
>>>
>>> Does anyone know of a SQL database that has added H3 functions? Also, is there are pure Java implementation (not just bindings that talk to a C back-end)?
>>>
>>> Aside: H3 is an awful name for a library when it comes to search. Worse than “Go” and “C++”, if that was possible.
>>>
>>> Julian
>>>
>>>
>>
>
Re: H3
Posted by Julian Hyde <jh...@apache.org>.
George,
Thank you for clarifying - and sorry if I misquoted you.
It is definitely helpful to know that DGGS is a hot area, and that there are moves to standardize.
And thank you, again, for organizing and chairing the track. I attended several of the sessions and felt a commonality of purpose among the various speakers. A good basis for a cross-project Geospatial community inside the ASF.
Julian
> On Sep 28, 2018, at 1:50 PM, George Percivall <gp...@opengeospatial.org> wrote:
>
>
> My comment was about Discrete Global Grid Systems in general and the role of the OGC standard.
>
> OGC Discrete Global Grid Systems standard
> http://docs.opengeospatial.org/as/15-104r5/15-104r5.html
>
> From the OGC DGGS standard: "A DGGS is a spatial reference system that uses a hierarchical tessellation of cells to partition and address the globe. DGGS are characterized by the properties of their cell structure, geo-encoding, quantization strategy and associated mathematical functions.The OGC DGGS Abstract Specification supports the specification of standardized DGGS infrastructures that enable the integrated analysis of very large, multi-source, multi-resolution, multi-dimensional, distributed geospatial data. Interoperability between OGC DGGS implementations is anticipated through implementation standards, and extension interface encodings of OGC Web Services.”
>
> H3 is a good example of a DGGS.
> Uber presented H3 to the OGC DGGS Working group at the most recent OGC meeting earlier this month.
>
> There are other DGGSs:
> https://www.researchgate.net/publication/303093407_The_rHEALPix_Discrete_Global_Grid_System
> https://www.slideshare.net/ClintonDow/dggs-python-geopython-2017
> https://vimeo.com/204787821
> https://www.youtube.com/watch?v=xh5csOiRVsk
> https://www.unece.org/fileadmin/DAM/stats/documents/ece/ces/ge.58/2017/mtg3/S1_LEWIS_DGGS_pres_final.pdf
>
> Julian - I will ask around for an "SQL database that has added DGGS functions"
>
> George
>
>
>
>
>> On Sep 28, 2018, at 1:58 PM, Julian Hyde <jh...@apache.org> wrote:
>>
>> There was a lot of talk about H3 during the geospatial track. “It will change the world (or at least the way we represent it)” said George, IIRC.
>>
>> I presume these are the best resources for it: https://github.com/uber/h3 <https://github.com/uber/h3> (code) and https://uber.github.io/h3/#/ <https://uber.github.io/h3/#/> (documentation).
>>
>> Does anyone know of a SQL database that has added H3 functions? Also, is there are pure Java implementation (not just bindings that talk to a C back-end)?
>>
>> Aside: H3 is an awful name for a library when it comes to search. Worse than “Go” and “C++”, if that was possible.
>>
>> Julian
>>
>>
>
Re: H3
Posted by George Percivall <gp...@opengeospatial.org>.
My comment was about Discrete Global Grid Systems in general and the role of the OGC standard.
OGC Discrete Global Grid Systems standard
http://docs.opengeospatial.org/as/15-104r5/15-104r5.html
From the OGC DGGS standard: "A DGGS is a spatial reference system that uses a hierarchical tessellation of cells to partition and address the globe. DGGS are characterized by the properties of their cell structure, geo-encoding, quantization strategy and associated mathematical functions.The OGC DGGS Abstract Specification supports the specification of standardized DGGS infrastructures that enable the integrated analysis of very large, multi-source, multi-resolution, multi-dimensional, distributed geospatial data. Interoperability between OGC DGGS implementations is anticipated through implementation standards, and extension interface encodings of OGC Web Services.”
H3 is a good example of a DGGS.
Uber presented H3 to the OGC DGGS Working group at the most recent OGC meeting earlier this month.
There are other DGGSs:
https://www.researchgate.net/publication/303093407_The_rHEALPix_Discrete_Global_Grid_System
https://www.slideshare.net/ClintonDow/dggs-python-geopython-2017
https://vimeo.com/204787821
https://www.youtube.com/watch?v=xh5csOiRVsk
https://www.unece.org/fileadmin/DAM/stats/documents/ece/ces/ge.58/2017/mtg3/S1_LEWIS_DGGS_pres_final.pdf
Julian - I will ask around for an "SQL database that has added DGGS functions"
George
> On Sep 28, 2018, at 1:58 PM, Julian Hyde <jh...@apache.org> wrote:
>
> There was a lot of talk about H3 during the geospatial track. “It will change the world (or at least the way we represent it)” said George, IIRC.
>
> I presume these are the best resources for it: https://github.com/uber/h3 <https://github.com/uber/h3> (code) and https://uber.github.io/h3/#/ <https://uber.github.io/h3/#/> (documentation).
>
> Does anyone know of a SQL database that has added H3 functions? Also, is there are pure Java implementation (not just bindings that talk to a C back-end)?
>
> Aside: H3 is an awful name for a library when it comes to search. Worse than “Go” and “C++”, if that was possible.
>
> Julian
>
>