1 files changed, 26 insertions, 2 deletions
diff --git a/config.yml b/config.yml
index 630817f..5f01b0b 100644
--- a/config.yml
+++ b/config.yml
@@ -3366,9 +3366,33 @@ layers:
           - replace: 'No'
             with: '0'
     publish:
-      area_offshore:
+      offshore_completed:
         where: |
-          "Raderat" IS FALSE
+          "Raderat" IS FALSE AND "Projektstatus" = 'Uppförd'
+      offshore_approved:
+        where: |
+          "Raderat" IS FALSE AND "Projektstatus" = 'Tillståndsansökan beviljad'
+      offshore_ammended:
+        where: |
+          "Raderat" IS FALSE AND "Projektstatus" = 'Ändringsansökan'
+      offshore_rejected:
+        where: |
+          "Raderat" IS FALSE AND "Projektstatus" = 'Tillståndsansökan avslagen'
+      offshore_appealed:
+        where: |
+          "Raderat" IS FALSE AND "Projektstatus" = 'Överklagad'
+      offshore_applied:
+        where: |
+          "Raderat" IS FALSE AND "Projektstatus" = 'Tillståndsansökan inlämnad'
+      offshore_consultation:
+        where: |
+          "Raderat" IS FALSE AND "Projektstatus" = 'Samråd inför tillståndsansökan'
+      offshore_investigation:
+        where: |
+          "Raderat" IS FALSE AND "Projektstatus" = 'Inledande undersökningar'
+      offshore_revoked:
+        where: |
+          "Raderat" IS FALSE AND "Projektstatus" = 'Inte aktuell eller återkallad'
 
   'mrr:ut_metaller_industrimineral_ansokta':
     # https://resource.sgu.se/dokument/produkter/mineralrattigheter-beskrivning.pdf