Add layer data for Rennäringen.

From Sametinget via Länsstyrelsen.

2 files changed, 664 insertions, 5 deletions

diff --git a/config.yml b/config.yml
index ec5ec50..6ee2a99 100644
--- a/config.yml
+++ b/config.yml
@@ -56,7 +56,9 @@ layer-groups:
     - kommunyta
   nvr: 'nvr:*'
   sks: 'sks:*'
-  st: 'st:*'
+  ren:
+    - 'sametinget:*'
+    - 'ren:*'
   vbk: 'vbk:*'
   mrr: 'mrr:*'
 
@@ -665,15 +667,262 @@ layers:
             with: null
     publish: clearcut_comp
 
-  'st:betesomraden':
+  'sametinget:betesomraden':
+    # https://ext-geodatakatalog-forv.lansstyrelsen.se/PlaneringsKatalogen/GetMetaDataById?id=a216dea8-bfcb-4984-a18b-3a421cde2d57_C
+    # Licens behövs, cf. 'Samebyarnas_betesomraden/Samebyarnas betesområden/avtal.pdf'
+    description: 'Samebyarnas betesområden: Renbetesområden'
+    create:
+      # https://ext-dokument.lansstyrelsen.se/Gemensamt/Geodata/Datadistribution/Information,%20Skiktf%C3%B6rteckning%20och%20f%C3%B6rklaringar.pdf
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: OBJECTID
+          type: Integer
+          unique: true
+          nullable: false
+        - name: SAMEBY_ID
+          type: Integer
+          unique: true
+          nullable: false
+        - name: BY_ID
+          type: Integer
+        - name: NAMN
+          type: String
+          width: 62
+          nullable: false
+        - name: SIGNATUR
+          type: String
+          width: 25
+          nullable: false
+        - name: SAMEBY_TYP
+          type: String
+          width: 62
+          nullable: false
+        - name: BY_OMR
+          type: Integer
+          subtype: Bool
+          nullable: false
+        - name: OVR_OMR
+          type: Integer
+          subtype: Bool
+          nullable: false
+        - name: AKTUALITET
+          type: Date
+          nullable: false
     source:
       download: 'https://ext-dokument.lansstyrelsen.se/Gemensamt/Geodata/Datadistribution/SWEREF99TM/Sametinget/Samebyarnas_betesomraden.zip'
       cache: sametinget/
+      unar:
+        format: zip
+        patterns:
+          - 'Samebyarnas_betesomraden/Samebyarnas betesområden/IRENMARK_DBO_sameby.*'
+    import:
+      path: 'Samebyarnas_betesomraden/Samebyarnas betesområden/IRENMARK_DBO_sameby.shp'
+      format: ESRI Shapefile
+      layername: IRENMARK_DBO_sameby
+      value-map:
+        BY_ID:
+          - replace: 9999
+            with: null
+    publish: betesomraden
 
-  'st:markanvandning':
+  'sametinget:flytled':
+    # https://ext-geodatakatalog-forv.lansstyrelsen.se/PlaneringsKatalogen/GetMetaDataById?id=19b7addd-a790-4829-991f-f2266009e863_C
+    # Licens behövs, cf. 'Samebyarnas_betesomraden/Samebyarnas betesområden/avtal.pdf'
+    description: 'Samebyarnas markanvändningsredovisning: Flyttled'
+    create:
+      # https://ext-dokument.lansstyrelsen.se/Gemensamt/Geodata/Datadistribution/Information,%20Skiktf%C3%B6rteckning%20och%20f%C3%B6rklaringar.pdf
+      geometry-type: MULTILINESTRING
+      fields:
+        - name: OBJECTID
+          type: Integer
+          unique: true
+          nullable: false
+        - name: LED_ID
+          type: Integer
+          nullable: false
+          # NOTE: these could be provided as a list instead
+        - name: BYNR1
+          type: Integer
+          nullable: false
+        - name: BYNR2
+          type: Integer
+          nullable: false
+        - name: BYNR3
+          type: Integer
+          nullable: false
+        - name: SAMEBY1
+          type: String
+          width: 62
+        - name: SAMEBY2
+          type: String
+          width: 62
+        - name: SAMEBY3
+          type: String
+          width: 62
+        - name: KKOD
+          type: Integer
+          nullable: false
+        - name: BESKRIVNIN
+          type: String
+          width: 62
+        - name: ARSTID
+          type: String
+          width: 62
+        - name: KONV_AR
+          type: String
+          width: 62
+        - name: SIGNATUR
+          type: String
+          width: 25
+        - name: RIKSINTR
+          type: Integer
+          subtype: Bool
+          nullable: false
+        - name: FAST_LED
+          type: Integer
+          subtype: Bool
+          nullable: false
+        - name: AKTUALITET
+          # XXX these have a mix of YYYY, YYMMDD, YYYYMMDD
+          type: String
+          width: 10
+        - name: GlobalID
+          type: String
+          subtype: UUID
+          #width: 36
+          unique: true
+          nullable: false
     source:
       download: 'http://ext-dokument.lansstyrelsen.se/Gemensamt/Geodata/Datadistribution/SWEREF99TM/Sametinget/Samebyarnas_markanvandningsredovisning.zip'
       cache: sametinget/
+      unar:
+        format: zip
+        patterns:
+          - 'Samebyarnas markanvändningsredovisning/Stategiska områden/IRENMARK_DBO_led.*'
+    import:
+      path: 'Samebyarnas markanvändningsredovisning/Stategiska områden/IRENMARK_DBO_led.shp'
+      format: ESRI Shapefile
+      layername: IRENMARK_DBO_led
+      value-map:
+        GlobalID:
+          - replace: '\{([0-9A-Fa-f]{8}-[0-9A-Fa-f]{4}-[0-9A-Fa-f]{4}-[0-9A-Fa-f]{4}-[0-9A-Fa-f]{12})\}'
+            with: '{0}'
+            type: regex
+    publish: flytled
+
+  'ren:riks_ren':
+    # https://ext-geodatakatalog-forv.lansstyrelsen.se/PlaneringsKatalogen/GetMetaDataById?id=103cf137-9d56-452b-97d6-9b12cba6c864_C
+    description: 'Riksintresse Rennäringen'
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: OBJECTID
+          type: Integer
+          unique: true
+          nullable: false
+        - name: LAGRUM
+          type: String
+          width: 254
+          nullable: false
+        - name: AKTUALITET
+          type: Date
+          nullable: false
+        - name: SIGNATUR
+          type: String
+          width: 25
+          nullable: false
+        - name: LANK
+          type: String
+          width: 254
+        - name: GlobalID
+          type: String
+          subtype: UUID
+          #width: 36
+          unique: true
+          nullable: false
+    source:
+      download: 'https://ext-dokument.lansstyrelsen.se/gemensamt/geodata/ShapeExport/ren.riks_ren.zip'
+      cache: ren/
+      unar:
+        format: zip
+        patterns:
+          - 'ren.riks_ren.*'
+    import:
+      path: ren.riks_ren.shp
+      format: ESRI Shapefile
+      layername: ren.riks_ren
+      value-map:
+        GlobalID:
+          - replace: '\{([0-9A-Fa-f]{8}-[0-9A-Fa-f]{4}-[0-9A-Fa-f]{4}-[0-9A-Fa-f]{4}-[0-9A-Fa-f]{12})\}'
+            with: '{0}'
+            type: regex
+    publish: riks_ren
+
+  'ren:omr_riks':
+    # https://ext-geodatakatalog-forv.lansstyrelsen.se/PlaneringsKatalogen/GetMetaDataById?id=b665a528-cd25-4612-8ab3-fa3e692b46c3_C
+    description: 'Riksintresse Rennäringen — Kärnområde'
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: OBJECTID
+          type: Integer
+          unique: true
+          nullable: false
+        - name: LANK
+          type: String
+          width: 254
+          nullable: false
+        - name: LANSKOD
+          type: String
+          width: 25
+          nullable: false
+        - name: OMR_NR
+          type: Integer
+        - name: ARET_RUNT
+          type: Integer
+        - name: SAMEBY
+          type: String
+          width: 62
+          nullable: false
+        - name: ANSVARIG
+          type: String
+          width: 25
+          nullable: false
+        - name: AKTUALITET
+          type: Date
+          nullable: false
+        - name: SIGNATUR
+          type: String
+          width: 25
+        - name: GlobalID
+          type: String
+          subtype: UUID
+          #width: 36
+          unique: true
+          nullable: false
+    source:
+      download: 'https://ext-dokument.lansstyrelsen.se/gemensamt/geodata/ShapeExport/ren.omr_riks.zip'
+      cache: ren/
+      unar:
+        format: zip
+        patterns:
+          - 'ren.omr_riks.*'
+    import:
+      path: ren.omr_riks.shp
+      format: ESRI Shapefile
+      layername: ren.omr_riks
+      value-map:
+        OMR_NR:
+          - replace: 9999
+            with: null
+        ARET_RUNT:
+          - replace: 9999
+            with: null
+        GlobalID:
+          - replace: '\{([0-9A-Fa-f]{8}-[0-9A-Fa-f]{4}-[0-9A-Fa-f]{4}-[0-9A-Fa-f]{4}-[0-9A-Fa-f]{12})\}'
+            with: '{0}'
+            type: regex
+    publish: omr_riks
 
   'vbk:vindkraftverk':
     description: Vindbrukskollen landbaserade vindkraftverk (Länsstyrelsen)
diff --git a/schema.sql b/schema.sql
index 962bce1..e119193 100644
--- a/schema.sql
+++ b/schema.sql
@@ -2,8 +2,8 @@
 -- PostgreSQL database dump
 --
 
--- Dumped from database version 15.6 (Debian 15.6-0+deb12u1)
--- Dumped by pg_dump version 15.6 (Debian 15.6-0+deb12u1)
+-- Dumped from database version 15.8 (Debian 15.8-0+deb12u1)
+-- Dumped by pg_dump version 15.8 (Debian 15.8-0+deb12u1)
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
@@ -532,6 +532,208 @@ ALTER SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" OWNED BY postgis."mrr:
 
 
 --
+-- Name: ren:omr_riks; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."ren:omr_riks" (
+    ogc_fid bigint NOT NULL,
+    "OBJECTID" integer NOT NULL,
+    "LANK" character varying(254) NOT NULL,
+    "LANSKOD" character varying(25) NOT NULL,
+    "OMR_NR" integer,
+    "ARET_RUNT" integer,
+    "SAMEBY" character varying(62) NOT NULL,
+    "ANSVARIG" character varying(25) NOT NULL,
+    "AKTUALITET" date NOT NULL,
+    "SIGNATUR" character varying(25),
+    "GlobalID" uuid NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
+);
+
+
+ALTER TABLE postgis."ren:omr_riks" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "ren:omr_riks"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."ren:omr_riks" IS 'Riksintresse Rennäringen — Kärnområde';
+
+
+--
+-- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."ren:omr_riks_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."ren:omr_riks_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" OWNED BY postgis."ren:omr_riks".ogc_fid;
+
+
+--
+-- Name: ren:riks_ren; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."ren:riks_ren" (
+    ogc_fid bigint NOT NULL,
+    "OBJECTID" integer NOT NULL,
+    "LAGRUM" character varying(254) NOT NULL,
+    "AKTUALITET" date NOT NULL,
+    "SIGNATUR" character varying(25) NOT NULL,
+    "LANK" character varying(254),
+    "GlobalID" uuid NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
+);
+
+
+ALTER TABLE postgis."ren:riks_ren" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "ren:riks_ren"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."ren:riks_ren" IS 'Riksintresse Rennäringen';
+
+
+--
+-- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."ren:riks_ren_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren".ogc_fid;
+
+
+--
+-- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."sametinget:betesomraden" (
+    ogc_fid bigint NOT NULL,
+    "OBJECTID" integer NOT NULL,
+    "SAMEBY_ID" integer NOT NULL,
+    "BY_ID" integer,
+    "NAMN" character varying(62) NOT NULL,
+    "SIGNATUR" character varying(25) NOT NULL,
+    "SAMEBY_TYP" character varying(62) NOT NULL,
+    "BY_OMR" boolean NOT NULL,
+    "OVR_OMR" boolean NOT NULL,
+    "AKTUALITET" date NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
+);
+
+
+ALTER TABLE postgis."sametinget:betesomraden" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "sametinget:betesomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."sametinget:betesomraden" IS 'Samebyarnas betesområden: Renbetesområden';
+
+
+--
+-- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."sametinget:betesomraden_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" OWNED BY postgis."sametinget:betesomraden".ogc_fid;
+
+
+--
+-- Name: sametinget:flytled; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."sametinget:flytled" (
+    ogc_fid bigint NOT NULL,
+    "OBJECTID" integer NOT NULL,
+    "LED_ID" integer NOT NULL,
+    "BYNR1" integer NOT NULL,
+    "BYNR2" integer NOT NULL,
+    "BYNR3" integer NOT NULL,
+    "SAMEBY1" character varying(62),
+    "SAMEBY2" character varying(62),
+    "SAMEBY3" character varying(62),
+    "KKOD" integer NOT NULL,
+    "BESKRIVNIN" character varying(62),
+    "ARSTID" character varying(62),
+    "KONV_AR" character varying(62),
+    "SIGNATUR" character varying(25),
+    "RIKSINTR" boolean NOT NULL,
+    "FAST_LED" boolean NOT NULL,
+    "AKTUALITET" character varying(10),
+    "GlobalID" uuid NOT NULL,
+    wkb_geometry postgis.geometry(MultiLineString,3006)
+);
+
+
+ALTER TABLE postgis."sametinget:flytled" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "sametinget:flytled"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."sametinget:flytled" IS 'Samebyarnas markanvändningsredovisning: Flyttled';
+
+
+--
+-- Name: sametinget:flytled_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."sametinget:flytled_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."sametinget:flytled_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: sametinget:flytled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."sametinget:flytled_ogc_fid_seq" OWNED BY postgis."sametinget:flytled".ogc_fid;
+
+
+--
 -- Name: sks:AvverkAnm; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
@@ -900,6 +1102,34 @@ ALTER TABLE ONLY postgis."mrr:torvkoncessioner" ALTER COLUMN ogc_fid SET DEFAULT
 
 
 --
+-- Name: ren:omr_riks ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ren:omr_riks" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:omr_riks_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: ren:riks_ren ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ren:riks_ren" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:riks_ren_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: sametinget:betesomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."sametinget:betesomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:betesomraden_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: sametinget:flytled ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."sametinget:flytled" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:flytled_ogc_fid_seq"'::regclass);
+
+
+--
 -- Name: sks:AvverkAnm ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
@@ -1183,6 +1413,102 @@ ALTER TABLE ONLY postgis."mrr:torvkoncessioner"
 
 
 --
+-- Name: ren:omr_riks ren:omr_riks_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ren:omr_riks"
+    ADD CONSTRAINT "ren:omr_riks_GlobalID_key" UNIQUE ("GlobalID");
+
+
+--
+-- Name: ren:omr_riks ren:omr_riks_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ren:omr_riks"
+    ADD CONSTRAINT "ren:omr_riks_OBJECTID_key" UNIQUE ("OBJECTID");
+
+
+--
+-- Name: ren:omr_riks ren:omr_riks_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ren:omr_riks"
+    ADD CONSTRAINT "ren:omr_riks_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: ren:riks_ren ren:riks_ren_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ren:riks_ren"
+    ADD CONSTRAINT "ren:riks_ren_GlobalID_key" UNIQUE ("GlobalID");
+
+
+--
+-- Name: ren:riks_ren ren:riks_ren_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ren:riks_ren"
+    ADD CONSTRAINT "ren:riks_ren_OBJECTID_key" UNIQUE ("OBJECTID");
+
+
+--
+-- Name: ren:riks_ren ren:riks_ren_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ren:riks_ren"
+    ADD CONSTRAINT "ren:riks_ren_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: sametinget:betesomraden sametinget:betesomraden_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."sametinget:betesomraden"
+    ADD CONSTRAINT "sametinget:betesomraden_OBJECTID_key" UNIQUE ("OBJECTID");
+
+
+--
+-- Name: sametinget:betesomraden sametinget:betesomraden_SAMEBY_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."sametinget:betesomraden"
+    ADD CONSTRAINT "sametinget:betesomraden_SAMEBY_ID_key" UNIQUE ("SAMEBY_ID");
+
+
+--
+-- Name: sametinget:betesomraden sametinget:betesomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."sametinget:betesomraden"
+    ADD CONSTRAINT "sametinget:betesomraden_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: sametinget:flytled sametinget:flytled_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."sametinget:flytled"
+    ADD CONSTRAINT "sametinget:flytled_GlobalID_key" UNIQUE ("GlobalID");
+
+
+--
+-- Name: sametinget:flytled sametinget:flytled_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."sametinget:flytled"
+    ADD CONSTRAINT "sametinget:flytled_OBJECTID_key" UNIQUE ("OBJECTID");
+
+
+--
+-- Name: sametinget:flytled sametinget:flytled_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."sametinget:flytled"
+    ADD CONSTRAINT "sametinget:flytled_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
 -- Name: sks:AvverkAnm sks:AvverkAnm_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
@@ -1341,6 +1667,34 @@ CREATE INDEX "mrr:torvkoncessioner_wkb_geometry_geom_idx" ON postgis."mrr:torvko
 
 
 --
+-- Name: ren:omr_riks_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "ren:omr_riks_wkb_geometry_geom_idx" ON postgis."ren:omr_riks" USING gist (wkb_geometry);
+
+
+--
+-- Name: ren:riks_ren_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "ren:riks_ren_wkb_geometry_geom_idx" ON postgis."ren:riks_ren" USING gist (wkb_geometry);
+
+
+--
+-- Name: sametinget:betesomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "sametinget:betesomraden_wkb_geometry_geom_idx" ON postgis."sametinget:betesomraden" USING gist (wkb_geometry);
+
+
+--
+-- Name: sametinget:flytled_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "sametinget:flytled_wkb_geometry_geom_idx" ON postgis."sametinget:flytled" USING gist (wkb_geometry);
+
+
+--
 -- Name: sks:AvverkAnm_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
@@ -1546,6 +1900,62 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" TO web
 
 
 --
+-- Name: TABLE "ren:omr_riks"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."ren:omr_riks" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "ren:omr_riks_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "ren:riks_ren"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."ren:riks_ren" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "ren:riks_ren_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "sametinget:betesomraden"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."sametinget:betesomraden" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "sametinget:betesomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "sametinget:flytled"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."sametinget:flytled" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "sametinget:flytled_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:flytled_ogc_fid_seq" TO webmap_guest;
+
+
+--
 -- Name: TABLE "sks:AvverkAnm"; Type: ACL; Schema: postgis; Owner: webmap_import
 --