{"type":"doc","content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Uppdatera skadetabellen","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"alter table skfab.damages add column deso text\nalter table skfab.damages add column regso text","type":"text"}]},{"type":"paragraph","content":[{"text":"Skapa ett temporärt schema SCB i sive-databasen och hämta in data från databas nationaldata, schema SIV. Skapa index för dessa tabeller","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"create index on scb.deso using gist(geometry);\ncreate index on scb.regso using gist(geometry);","type":"text"}]},{"type":"paragraph","content":[{"text":"Uppdatera skade-tabellen spatialt för RegSo och DeSo referens.","type":"text"}]},{"type":"paragraph","content":[{"text":"Slå tillfälligt av triggers","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"-- turn off triggersfor this sesssion\nSET session_replication_role = replica;\n-- Turn on triggers again\nSET session_replication_role = DEFAULT;","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Körning tar lång tid . Glöm inte slå av triggers","type":"text"}]}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"update skfab.damages d set regso = r.regso \nfrom scb.regso r\nwhere ST_WITHIN(ST_Transform(d.geometry,3006) ,r.geometry);\n\nupdate skfab.damages d set deso = r.deso \nfrom scb.deso r\nwhere ST_WITHIN(ST_Transform(d.geometry,3006) ,r.geometry);","type":"text"}]},{"type":"paragraph","content":[{"text":"Testa hur många poster som har uppdaterats","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"select count(*)\nfrom skfab.damages d\nwhere d.regso is null\n","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Ska vara c:a 3700 som inte har uppdaterats och 68000 som har uppdaterats. De flesta är Trondheim.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"Det temporära schemat SCB kan tas bort","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Konfigurera Weave","type":"text"}]},{"type":"paragraph","content":[{"text":"Lägga till listor","type":"text"}]},{"type":"paragraph","content":[{"text":"Lägga till kolumner i data definition dd_damages_all","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\t\t\n\t\t\t\tdd.scb_v_deso\n\t\t\t\tregso\n\t\t\t\tregsonamn\n\t\t\t\t0\n\t\t\n\t\t\n","type":"text"}]},{"type":"paragraph"}],"version":1}

Browser not supported