12.3 Raster to H3

12.10

create table denver_ele_h3 as
select
    h3_lat_lng_to_cell(a.geom, 11) as h3,
    avg(val) as avg_ele
from
    (
        select
            r.*
        from
            denver_elevation,
            lateral ST_PixelAsCentroids(rast, 1) as r
    ) a
group by
    1

12.11

select
    r.*
from
    denver_elevation,
    lateral ST_PixelAsCentroids(rast, 1) as r