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 <[email protected]> > 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 <[email protected]> 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 >>> <[email protected]> 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 <[email protected]> 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 >>>> >>>> >>> >> >
