From 6c42b9221b66ab1891f3f553fc72a7d5f8d65f58 Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Wed, 12 Jun 2024 20:28:17 +0200
Subject: Add schema for MRR layers.

---
 config.yml | 386 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 386 insertions(+)

(limited to 'config.yml')

diff --git a/config.yml b/config.yml
index efa1841..e6746d0 100644
--- a/config.yml
+++ b/config.yml
@@ -726,47 +726,280 @@ layers:
   # The list of layers available on the WMS server can be found at
   # https://maps3.sgu.se/geoserver/wms?SERVICE=WMS&VERSION=1.11&REQUEST=GetCapabilities
   'mrr:bearbetningskoncessioner_applied':
+    description: Bearbetningskoncessioner, ansökta (SGU)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: Name
+          type: String
+          unique: true
+          nullable: false
+          width: 254
+          #comment: benämning på området
+        - name: Mineral
+          type: String
+          nullable: false
+          width: 254
+          #comment: koncessionsmineral
+        - name: Applicant
+          type: String
+          nullable: false
+          width: 254
+          #comment: sökandens namn
+        - name: ApplicationDate
+          type: Date
+          nullable: false
+        - name: DiaryNr
+          type: String
+          unique: true
+          nullable: false
+          width: 16
+        - name: LastUpdated
+          # TODO convert to Date
+          type: String
+          width: 10
+          nullable: false
+          #comment: datum för senaste uppdatering
     source:
       download:
         module: webmap-download-mrr
         layername: 'MRR:SE.GOV.SGU.MRR.BEARBETNINGSKONCESSIONER_APPLIED_VY'
       cache: mrr/bearbetningskoncessioner_applied.geojson
+    import:
+      format: GeoJSON
+      layername: 'MRR:SE.GOV.SGU.MRR.BEARBETNINGSKONCESSIONER_APPLIED_VY'
+      fields:
+        'Name': Name
+        'Mineral': Mineral
+        'Applicant': Applicant
+        'Application date': ApplicationDate
+        'Diary nr': DiaryNr
+        'Last updated': LastUpdated
+
   'mrr:bearbetningskoncessioner_approved':
+    description: Bearbetningskoncessioner, beviljade (SGU)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: Name
+          type: String
+          unique: true
+          nullable: false
+          width: 254
+          #comment: benämning på området
+        - name: Mineral
+          type: String
+          nullable: false
+          width: 254
+          #comment: koncessionsmineral
+        - name: Owner
+          type: String
+          nullable: false
+          width: 254
+          #comment: ägares namn
+        - name: ValidFrom
+          type: Date
+          nullable: false
+          #comment: när tillståndets giltighet börjar
+        - name: ValidTo
+          type: Date
+          nullable: false
+          #comment: när tillståndets giltighet slutar
+        - name: DiaryNr
+          type: String
+          # TODO map empty string to NULL
+          #unique: true
+          width: 16
+        - name: LastUpdated
+          # TODO convert to Date
+          type: String
+          width: 10
+          nullable: false
+          #comment: datum för senaste uppdatering
     source:
       download:
         module: webmap-download-mrr
         layername: 'MRR:SE.GOV.SGU.MRR.BEARBETNINGSKONCESSIONER_APPROVED_VY'
       cache: mrr/bearbetningskoncessioner_approved.geojson
+    import:
+      format: GeoJSON
+      layername: 'MRR:SE.GOV.SGU.MRR.BEARBETNINGSKONCESSIONER_APPROVED_VY'
+      fields:
+        'Name': Name
+        'Mineral': Mineral
+        'Owner': Owner
+        'Valid from': ValidFrom
+        'Valid to': ValidTo
+        'Diary nr': DiaryNr
+        'Last updated': LastUpdated
+
   'mrr:markanvisningar':
+    description: Markanvisning till koncession (SGU)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: Name
+          type: String
+          nullable: false
+          width: 254
+          #comment: benämning på området
+        - name: DecisionDate
+          type: Date
+          # TODO map empty string to NULL
+          #comment: beslutsdatum
+        - name: DiaryNr
+          type: String
+          # TODO map empty string to NULL
+          #unique: true
+          width: 16
+        - name: LastUpdated
+          # TODO convert to Date
+          type: String
+          width: 10
+          nullable: false
+          #comment: datum för senaste uppdatering
     source:
       download:
         module: webmap-download-mrr
         layername: 'MRR:SE.GOV.SGU.MRR.MARKANVISNINGAR_VY'
       cache: mrr/markanvisningar.geojson
+    import:
+      format: GeoJSON
+      layername: 'MRR:SE.GOV.SGU.MRR.MARKANVISNINGAR_VY'
+      fields:
+        'Name': Name
+        'Decision date': DecisionDate
+        'Diary nr': DiaryNr
+        'Last updated': LastUpdated
+
   'mrr:mineral_applied':
+    description: Undersökningstillstånd, metallar och mineral, ansökta (SGU)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: Name
+          type: String
+          unique: true
+          nullable: false
+          width: 254
+          #comment: benämning på området
+        - name: Mineral
+          type: String
+          nullable: false
+          width: 254
+          #comment: koncessionsmineral
+        - name: Applicant
+          type: String
+          nullable: false
+          width: 254
+          #comment: sökandens namn
+        - name: ApplicationDate
+          type: Date
+          nullable: false
+        - name: DiaryNr
+          type: String
+          unique: true
+          nullable: false
+          width: 16
+        - name: LastUpdated
+          # TODO convert to Date
+          type: String
+          width: 10
+          nullable: false
+          #comment: datum för senaste uppdatering
     source:
       download:
         module: webmap-download-mrr
         layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_APPLIED_VY'
       cache: mrr/mineral_applied.geojson
+    import:
+      format: GeoJSON
+      layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_APPLIED_VY'
+      fields:
+        'Name': Name
+        'Mineral': Mineral
+        'Applicant': Applicant
+        'Application date': ApplicationDate
+        'Diary nr': DiaryNr
+        'Last updated': LastUpdated
+
   'mrr:mineral_approved':
+    description: Undersökningstillstånd, metallar och mineral, beviljade (SGU)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: Name
+          type: String
+          unique: true
+          nullable: false
+          width: 254
+          #comment: benämning på området
+        - name: Mineral
+          type: String
+          nullable: false
+          width: 254
+          #comment: koncessionsmineral
+        - name: Owner
+          type: String
+          nullable: false
+          width: 254
+          #comment: ägares namn
+        - name: LicenceID
+          type: String
+          unique: true
+          nullable: false
+          width: 8
+        - name: ValidFrom
+          type: Date
+          nullable: false
+          #comment: när tillståndets giltighet börjar
+        - name: ValidTo
+          type: Date
+          nullable: false
+          #comment: när tillståndets giltighet slutar
+        - name: DiaryNr
+          type: String
+          # TODO map empty string to NULL
+          #unique: true
+          width: 16
+        - name: LastUpdated
+          # TODO convert to Date
+          type: String
+          width: 10
+          nullable: false
+          #comment: datum för senaste uppdatering
     source:
       download:
         module: webmap-download-mrr
         layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_APPROVED_VY'
       cache: mrr/mineral_approved.geojson
+    import:
+      format: GeoJSON
+      layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_APPROVED_VY'
+      fields:
+        'Name': Name
+        'Mineral': Mineral
+        'Owner': Owner
+        'Licence id': LicenceID
+        'Valid from': ValidFrom
+        'Valid to': ValidTo
+        'Diary nr': DiaryNr
+        'Last updated': LastUpdated
+
 #  'mrr:mineral_expired':
 #    source:
 #      download:
 #        module: webmap-download-mrr
 #        layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_EXPIRED_2'
 #      cache: mrr/mineral_expired.geojson
+#
 #  'mrr:mineral_prohibited':
 #    source:
 #      download:
 #        module: webmap-download-mrr
 #        layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_PROHIBITED_2'
 #      cache: mrr/mineral_prohibited.geojson
+#
 #  'mrr:ogd_expired':
 #    source:
 #      download:
@@ -779,21 +1012,174 @@ layers:
 #        module: webmap-download-mrr
 #        layername: 'MRR:SE.GOV.SGU.MRR.OGD_PROHIBITED_2'
 #      cache: mrr/ogd_prohibited.geojson
+
   'mrr:olja_gas_diamant_applied':
+    description: Undersökningstillstånd, olja, gas och diamant, ansökta (SGU)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: Name
+          type: String
+          unique: true
+          nullable: false
+          width: 254
+          #comment: benämning på området
+        - name: Mineral
+          type: String
+          nullable: false
+          width: 254
+          #comment: koncessionsmineral
+        - name: Applicant
+          type: String
+          nullable: false
+          width: 254
+          #comment: sökandens namn
+        - name: ApplicationDate
+          type: Date
+          nullable: false
+        - name: DiaryNr
+          type: String
+          unique: true
+          nullable: false
+          width: 16
+        - name: LastUpdated
+          # TODO convert to Date
+          type: String
+          width: 10
+          nullable: false
+          #comment: datum för senaste uppdatering
     source:
       download:
         module: webmap-download-mrr
         layername: 'MRR:SE.GOV.SGU.MRR.OLJA_GAS_DIAMANT_APPLIED_VY'
       cache: mrr/olja_gas_diamant_applied.geojson
+    import:
+      format: GeoJSON
+      layername: 'MRR:SE.GOV.SGU.MRR.OLJA_GAS_DIAMANT_APPLIED_VY'
+      fields:
+        'Name': Name
+        'Mineral': Mineral
+        'Applicant': Applicant
+        'Application date': ApplicationDate
+        'Diary nr': DiaryNr
+        'Last updated': LastUpdated
+
   'mrr:olja_gas_diamant_approved':
+    description: Undersökningstillstånd, olja, gas och diamant, beviljade (SGU)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: Name
+          type: String
+          unique: true
+          nullable: false
+          width: 254
+          #comment: benämning på området
+        - name: Mineral
+          type: String
+          nullable: false
+          width: 254
+          #comment: koncessionsmineral
+        - name: Owner
+          type: String
+          nullable: false
+          width: 254
+          #comment: ägares namn
+        - name: LicenceID
+          type: String
+          unique: true
+          nullable: false
+          width: 8
+        - name: ValidFrom
+          type: Date
+          nullable: false
+          #comment: när tillståndets giltighet börjar
+        - name: ValidTo
+          type: Date
+          nullable: false
+          #comment: när tillståndets giltighet slutar
+        - name: DiaryNr
+          type: String
+          # TODO map empty string to NULL
+          #unique: true
+          width: 16
+        - name: LastUpdated
+          # TODO convert to Date
+          type: String
+          width: 10
+          nullable: false
+          #comment: datum för senaste uppdatering
     source:
       download:
         module: webmap-download-mrr
         layername: 'MRR:SE.GOV.SGU.MRR.OLJA_GAS_DIAMANT_APPROVED_VY'
       cache: mrr/olja_gas_diamant_approved.geojson
+    import:
+      format: GeoJSON
+      layername: 'MRR:SE.GOV.SGU.MRR.OLJA_GAS_DIAMANT_APPROVED_VY'
+      fields:
+        'Name': Name
+        'Mineral': Mineral
+        'Owner': Owner
+        'Licence id': LicenceID
+        'Valid from': ValidFrom
+        'Valid to': ValidTo
+        'Diary nr': DiaryNr
+        'Last updated': LastUpdated
+
   'mrr:torvkoncessioner':
+    description: Torvkoncessioner (SGU)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: Name
+          type: String
+          unique: true
+          nullable: false
+          width: 254
+          #comment: benämning på området
+        - name: Mineral
+          type: String
+          # TODO map empty string to NULL
+          width: 254
+          #comment: koncessionsmineral
+        - name: Owner
+          type: String
+          nullable: false
+          width: 254
+          #comment: ägares namn
+        - name: ValidFrom
+          type: Date
+          nullable: false
+          #comment: när tillståndets giltighet börjar
+        - name: ValidTo
+          type: Date
+          nullable: false
+          #comment: när tillståndets giltighet slutar
+        - name: DiaryNr
+          type: String
+          # TODO map empty string to NULL
+          #unique: true
+          width: 16
+        - name: LastUpdated
+          # TODO convert to Date
+          type: String
+          width: 10
+          nullable: false
+          #comment: datum för senaste uppdatering
     source:
       download:
         module: webmap-download-mrr
         layername: 'MRR:SE.GOV.SGU.MRR.TORVKONCESSIONER_VY'
       cache: mrr/torvkoncessioner.geojson
+    import:
+      format: GeoJSON
+      layername: 'MRR:SE.GOV.SGU.MRR.TORVKONCESSIONER_VY'
+      fields:
+        'Name': Name
+        'Mineral': Mineral
+        'Owner': Owner
+        'Valid from': ValidFrom
+        'Valid to': ValidTo
+        'Diary nr': DiaryNr
+        'Last updated': LastUpdated
-- 
cgit v1.2.3