Advanced: 01 Network site points.sql

File 01 Network site points.sql, 334 bytes (added by 231139, 10 days ago)
Line 
1-- QGIS point layer. Unique key: site_id; geometry: location.
2CREATE OR REPLACE VIEW public.v_network_site_points AS
3SELECT
4 ns.site_id,
5 ns.site_code,
6 ns.site_name,
7 ns.address,
8 ns.region,
9 ns.site_type,
10 ns.status,
11 ns.opened_at,
12 ns.location
13FROM public.network_sites ns
14WHERE ns.location IS NOT NULL;