mvw_cell_tower_names.sql

-- Materialized View: public.mvw_cellular_test

CREATE MATERIALIZED VIEW public.mvw_cellular_test AS 
 SELECT cellular_test.id,
    cellular_test.geom,
    cellular_test.licensee,
    cellular_test.loccity,
    us_states_lookup.name AS state_name
   FROM cellular_test
     INNER JOIN us_states_lookup ON cellular_test.locstate::text = us_states_lookup.abbr::text
WITH DATA;