DELETE FROM LOISStatistik2.dbo.KL_monitorering_omraader
GO
-- INSERT INTO LOISStatistik2.dbo.KL_monitorering_omraader (DimGeometriId, StatKortId, Centroid_X, Centroid_Y, CentroidLat, CentroidLong, Geometri, size, image_URL, text, Map_ID) SELECT L.DimGeometriId, L.StatKortId, L.Geometri.STCentroid().STX, L.Geometri.STCentroid().STY, 0, 0, L.Geometri, 3, '', '',CONCAT(CONCAT(L.GeometriName,'_'),L.StatKortId) FROM LOISStatistik2.LOISstatistikSystem.DimGeometri L INNER JOIN LOISStatistik2.dbo.KL_monitorering_Statkort AS K ON K.StatKortId=L.StatKortId

INSERT INTO LOISStatistik2.dbo.KL_monitorering_omraader (DimGeometriId, StatKortId, Centroid_X, Centroid_Y, CentroidLat, CentroidLong, Geometri, size, image_URL, text, Map_ID) SELECT L.DimGeometriId, L.StatKortId, L.Geometri.STCentroid().STX, L.Geometri.STCentroid().STY, 0, 0, L.Geometri, 3, '', '',(CAST(L.GeometriName AS VARCHAR)+'_'+CAST(L.StatKortId AS VARCHAR)) FROM LOISStatistik2.LOISstatistikSystem.DimGeometri L INNER JOIN LOISStatistik2.dbo.KL_monitorering_Statkort AS K ON K.StatKortId=L.StatKortId
GO
DELETE FROM KL_monitorering_centroide_UTM
INSERT INTO KL_monitorering_centroide_UTM (DimGeometriId, Centroid_X, Centroid_Y, CentroidLat, CentroidLong, Geometri) SELECT DimGeometriId, Centroid_X, Centroid_Y, CentroidLat, CentroidLong, (geometry::STPointFromText('POINT('+CAST(CAST(Centroid_X AS decimal(13, 2)) AS varchar)+' '+CAST(CAST(Centroid_Y AS decimal(13, 2)) AS varchar)+')', 25832)) FROM KL_monitorering_omraader AS O 
GO