Versions Compared

Version Old Version 1 New Version 2
Changes made by

Sven-Ola Svensson

Sven-Ola Svensson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

Körning tar lång tid

Code Block
languagesql
update skfab.damages d set regso = r.regso 
from scb.regso r
where ST_WITHIN(ST_Transform(d.geometry,3006) ,r.geometry);

update skfab.damages d set deso = r.deso 
from scb.deso r
where ST_WITHIN(ST_Transform(d.geometry,3006) ,r.geometry);

Testa hur många poster som har uppdaterats

Code Block
languagesql
select count(*)
from skfab.damages d
where d.regso is null

...