VBK: Use the shapefile as source for offshore projects.

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

1 files changed, 20 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: |