mvw_hex_freq_geom.sql

CREATE MATERIALIZED VIEW public.mvw_cellular_count_geom_hex AS 
 SELECT uuid_generate_v4() AS oid,
    vw_cellular_count_geom_hex.id,
    vw_cellular_count_geom_hex.shape,
    COALESCE(vw_cellular_count_geom_hex.features, 0::bigint)::integer AS features
   FROM vw_cellular_count_geom_hex
WITH DATA;

CREATE INDEX sidx_mvw_cellular_count_geom_hex_shape
  ON public.mvw_cellular_count_geom_hex
  USING gist
  (shape);