Advanced: 01 Network site points.sql

-- QGIS point layer. Unique key: site_id; geometry: location.
CREATE OR REPLACE VIEW public.v_network_site_points AS
SELECT
    ns.site_id,
    ns.site_code,
    ns.site_name,
    ns.address,
    ns.region,
    ns.site_type,
    ns.status,
    ns.opened_at,
    ns.location
FROM public.network_sites ns
WHERE ns.location IS NOT NULL;