From 2d8f839914feb2b9d31f2682b1c9992dd21c9b16 Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Wed, 4 Jun 2025 15:44:51 +0200
Subject: VBK: Use the shapefile as source for offshore projects.
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

The file appears to be official and updated as often as the GPKG
nowdays.  Both have 101 distinct features.

And unlike the GPKG the multipolygons are not split, so we add the
UNIQUE CONSTRAINT on "OmrID".

For some reason there are a lot of duplicates in the GPKG.

    sqlite> SELECT "ObjectID", COUNT(*) FROM "lst_vbk_havsbaserad_vindkraft" GROUP BY 1 ORDER BY 2;
    101|9
    1|24
    2|24
    […]
    100|24
---
 config.yml | 40 ++++++++++++++++++++--------------------
 schema.sql |  8 ++++++++
 2 files changed, 28 insertions(+), 20 deletions(-)

diff --git a/config.yml b/config.yml
index fe991e2..8a369a4 100644
--- a/config.yml
+++ b/config.yml
@@ -3164,13 +3164,7 @@ layers:
           alias: Områdes-ID
           type: String
           width: 10
-          # XXX The provided GeoPKG splits multi polygons into several
-          # features of geometry type polygon.  lst.vbk_vindkraftverk.zip
-          # has also LST.vbk_havsbaserad_vindkraft.shp with the proper
-          # features, but unfortunately that layer doesn't seem to be
-          # updated as often (and also isn't official).  So we remove
-          # the UNIQUE condition for now.
-          #unique: true
+          unique: true
           nullable: false
           comment: ID-nummer i Vindbruksollen för projekteringsområdet
         - name: Projektnamn
@@ -3306,32 +3300,34 @@ layers:
       path: vbk/lst.vbk_havsbaserad_vindkraft.zip
       unar:
         format: zip
+        patterns:
+          - 'lst.vbk_havsbaserad_vindkraft.*'
     import:
-      path: LST.vbk_havsbaserad_vindkraft.gpkg
-      format: GPKG
-      layername: vbk_havsbaserad_vindkraft
+      path: lst.vbk_havsbaserad_vindkraft.shp
+      format: ESRI Shapefile
+      layername: lst.vbk_havsbaserad_vindkraft
       field-map:
         OMRID: OmrID
-        HAVSPARKNAMN: Projektnamn
+        HAVSPARKNA: Projektnamn
         Orgnamn: Organisationsnamn
         Orgnr: Organisationsnummer
-        ArendeStatus: Projektstatus
+        ArendeStat: Projektstatus
         DNR: Diarienummer
-        AndringsansokanPagar: AndringsansokanPagar
+        Andringsan: AndringsansokanPagar
         SAMRAD: SamradsunderlagInlamnat
         ANSOKINL: AnsokanInlamnat
         ATERKALL: AnsokanAterkallad
-        ANSOKTILLST: AnsokanBeviljad
+        ANSOKTILLS: AnsokanBeviljad
         ANSOKAVSL: AnsokanAvslagen
-        ANSOKOVERKL: AnsokanOverklagad
+        ANSOKOVERK: AnsokanOverklagad
         N2000ANS: Natura2000_Ansokan
         N2000BES: Natura2000_Beslutdatum
         UNDERBYGGN: UnderByggnation
         UPPFORD: Uppfort
         Planantmin: PlaneratAntalVerkMin
         planantmax: PlaneratAntalVerkMax
-        Planhojdmin: PlaneradHojdMin
-        Planhojdmax: PlaneradHojdMax
+        Planhojdmi: PlaneradHojdMin
+        Planhojdma: PlaneradHojdMax
         PlanGWhmin: PlaneradProduktionMin
         PlanGWhmax: PlaneradProduktionMax
         PBYGGSTART: PlaneradByggstart
@@ -3340,9 +3336,9 @@ layers:
         Uppfortant: UppfortAntalVerk
         BevMaxHojd: BeviljadMaxhojd
         InstallEff: InstalleradEffekt
-        BeraknadGWh: Calprod
+        BeraknadGW: Calprod
         Elomrade: ElNamn
-        SenasteUppdaterat: SenasteUppdaterat
+        SenasteUpp: SenasteUppdaterat
         Raderat: Raderat
       value-map:
         Orgnamn:
@@ -3354,7 +3350,7 @@ layers:
         DNR:
           - replace: ''
             with: null
-        AndringsansokanPagar:
+        Andringsan:
           - replace: 'Ja'
             with: '1'
           - replace: 'Nej'
@@ -3369,6 +3365,10 @@ layers:
             with: '1'
           - replace: 'No'
             with: '0'
+        SenasteUpp:
+          - replace: '([0-9]{4})([0-9]{2})([0-9]{2})'
+            with: '{0}-{1}-{2}'
+            type: regex
     publish:
       area_offshore:
         where: |
diff --git a/schema.sql b/schema.sql
index 91a4631..c16eac0 100644
--- a/schema.sql
+++ b/schema.sql
@@ -4576,6 +4576,14 @@ ALTER TABLE ONLY postgis."svk:transmissionsnatsprojekt"
     ADD CONSTRAINT "svk:transmissionsnatsprojekt_pkey" PRIMARY KEY (ogc_fid);
 
 
+--
+-- Name: vbk:havsbaserad_vindkraft vbk:havsbaserad_vindkraft_OmrID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."vbk:havsbaserad_vindkraft"
+    ADD CONSTRAINT "vbk:havsbaserad_vindkraft_OmrID_key" UNIQUE ("OmrID");
+
+
 --
 -- Name: vbk:havsbaserad_vindkraft vbk:havsbaserad_vindkraft_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
-- 
cgit v1.2.3