Closed aostrow closed 3 years ago
all thicker:
UPDATE public.pmm_geometryinformation SET
linewidth = '2'::smallint
WHERE
geometrytype = 'linestring' and status = '1'
```;
loggin trial thicker
UPDATE public.pmm_geometryinformation SET
linewidth = '10'::smallint
WHERE
status = '1'
and name LIKE '%logging trail%'
or name = 'path'
or name LIKE '%forest road%';
but also keeps underlying stuff readbale:
UPDATE public.pmm_geometryinformation SET
color = '#000000AA'::character varying(255)
WHERE
status = '1'
and name LIKE '%logging trail%'
or name = 'path'
or name LIKE '%forest road%';
fences thicker:
UPDATE public.pmm_geometryinformation SET
linewidth = '2'::smallint
--select * from public.pmm_geometryinformation
WHERE
status = '1'
and name LIKE '%ence%'
and name NOT LIKE '%Core 6%'
and name NOT LIKE '%LitterLinks%'
;
all borders of new grassland experiments thicker
UPDATE public.pmm_geometryinformation SET
linewidth = '2'::smallint WHERE
name = 'LanduseExp - BSE' and status = '1';
UPDATE public.pmm_geometryinformation SET
linewidth = '2'::smallint WHERE
name = 'LanduseExp - F-0' and status = '1';
Some widths needs to be adapted manually: