Skip to content

Instantly share code, notes, and snippets.

@geobabbler

geobabbler/hex_freq_geom.sql

Last active June 6, 2017 19:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save geobabbler/af50aebe1e518a8235622e660a550e79 to your computer and use it in GitHub Desktop.
Save geobabbler/af50aebe1e518a8235622e660a550e79 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hex_freq_geom.sql
CREATE OR REPLACE VIEW public.vw_cellular_count_geom_hex AS
SELECT us_hex_grid.id,
us_hex_grid.shape,
vw_cellular_freq_hex.features
FROM us_hex_grid
LEFT JOIN vw_cellular_freq_hex ON us_hex_grid.id = vw_cellular_freq_hex.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment