Add layers for Naturvårdsverkets and Länsstyrelserns Riksintressen.

Cf. https://skyddadnatur.naturvardsverket.se/ .  We exclude
Nationalstadspark (MB 4 kap 7§) since the only entry is in Stockholm
(Kungliga nationalstadsparken, Ulriksdal-Haga-Brunnsviken-Djurgården)
outside our extent.

2 files changed, 842 insertions, 0 deletions

diff --git a/config.yml b/config.yml
index 7148f5c..683b85d 100644
--- a/config.yml
+++ b/config.yml
@@ -66,6 +66,7 @@ layer-groups:
     - 'ren:*'
   vbk: 'vbk:*'
   mrr: 'mrr:*'
+  ri: 'ri:*'
 
 
 # Global GDAL/OGR configuration options, cf. https://gdal.org/user/configoptions.html and
@@ -3579,3 +3580,306 @@ layers:
             with: '{0}-{1}-{2}'
             type: regex
     publish: appr_pc
+
+  'ri:naturvard':
+    # https://geodatakatalogen.naturvardsverket.se/geonetwork/srv/swe/catalog.search#/metadata/fb9ff32f-b6f8-4d8e-ac5c-20ebb0986908
+    description: Riksintresse naturvård
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: SKYDD
+          type: String
+          width: 64
+          nullable: false
+        - name: AMNESOMRAD
+          type: String
+          width: 64
+          nullable: false
+        - name: NAMN
+          type: String
+          width: 127
+          nullable: false
+        - name: BESKRIVNIN
+          type: String
+          width: 254
+          nullable: false
+        - name: LAGRUM
+          type: String
+          width: 64
+          nullable: false
+        - name: BESLUTSDAT
+          type: Date
+          nullable: false
+        - name: ORGINALID
+          type: String
+          width: 16
+          # XXX how come there is no UNIQUE constraint here?
+          unique: false
+          nullable: false
+        - name: RIKSID
+          type: Integer
+          # XXX how come there is no UNIQUE constraint here?
+          unique: false
+          nullable: false
+    source:
+      download: 'https://geodata.naturvardsverket.se/nedladdning/riksintresse/RI_Naturvard.zip'
+      cache: nvk/
+      unar:
+        format: zip
+        patterns:
+          - 'RIKSINTRESSE_NATURVARD.*'
+    import:
+      path: 'RIKSINTRESSE_NATURVARD.shp'
+      format: ESRI Shapefile
+      layername: RIKSINTRESSE_NATURVARD
+    publish: naturvard
+
+  'ri:friluftsliv':
+    # https://geodatakatalogen.naturvardsverket.se/geonetwork/srv/swe/catalog.search#/metadata/22afb5cb-cdb0-4f3a-8b0f-a34344285864
+    description: Riksintresse friluftsliv
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: SKYDD
+          type: String
+          width: 64
+          nullable: false
+        - name: OMRADESNR
+          type: String
+          width: 16
+          unique: true
+          nullable: false
+        - name: AMNESOMR
+          type: String
+          width: 16
+          nullable: false
+        - name: NAMN
+          type: String
+          width: 127
+          nullable: false
+        - name: LANK_VARDE
+          type: String
+          width: 127
+          nullable: false
+        - name: BESLDATUM
+          type: Date
+        - name: LAGRUM
+          type: String
+          width: 64
+          nullable: false
+        - name: ARENDENR
+          type: String
+          width: 11
+          nullable: false
+        - name: LANK_BESLU
+          type: String
+          width: 127
+          nullable: false
+        - name: AKTIVITET
+          type: String
+          width: 127
+        - name: NATURTYP
+          type: String
+          width: 127
+        - name: AREA_LAND_
+          # XXX convert to m²?
+          type: Real
+          comment: Areal land i hektar
+        - name: AREA_VATTE
+          # XXX convert to m²?
+          type: Real
+          comment: Areal vatten i hektar
+    source:
+      download: 'https://geodata.naturvardsverket.se/nedladdning/riksintresse/RI_Friluftsliv.zip'
+      cache: nvk/
+      unar:
+        format: zip
+        patterns:
+          - 'RIKSINTRESSE_FRILUFTSLIV.*'
+    import:
+      path: 'RIKSINTRESSE_FRILUFTSLIV.shp'
+      format: ESRI Shapefile
+      layername: RIKSINTRESSE_FRILUFTSLIV
+    publish: friluftsliv
+
+  'ri:rorligt_friluftsliv':
+    # https://ext-geodatakatalog-forv.lansstyrelsen.se/PlaneringsKatalogen/GetMetaDataById?id=22afb5cb-cdb0-4f3a-8b0f-a34344285864_C
+    description: Rörligt friluftsliv (MB 4 kap 1§ och 2§)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: ORIGINALID
+          type: String
+          width: 16
+        - name: NAMN
+          type: String
+          width: 64
+        - name: BESKRIVNIN
+          type: String
+          width: 254
+        - name: METODBESKR
+          type: String
+          width: 254
+        - name: TILLKDATUM
+          type: Date
+        - name: REVDATUM
+          type: Date
+        - name: ANM
+          type: String
+          width: 254
+        - name: OBJEKTLANK
+          type: String
+          width: 254
+        - name: REFERENS
+          type: String
+          width: 254
+    source:
+      download: 'https://ext-dokument.lansstyrelsen.se/gemensamt/geodata/ShapeExport/lst.LST_RI_Rorligt_friluftsliv_MB4kap2.zip'
+      cache: lst/
+      unar:
+        format: zip
+        patterns:
+          - 'lst.LST_RI_Rorligt_friluftsliv_MB4kap2.*'
+    import:
+      path: 'lst.LST_RI_Rorligt_friluftsliv_MB4kap2.shp'
+      format: ESRI Shapefile
+      layername: lst.LST_RI_Rorligt_friluftsliv_MB4kap2
+    publish: rorligt_friluftsliv
+
+  'ri:obruten_kust':
+    # https://ext-geodatakatalog.lansstyrelsen.se/GeodataKatalogen/srv/api/records/GetMetaDataById?id=2b5b141f-a9a4-433a-8dc7-bf983acdb859
+    description: Obruten kust (MB 4 kap 3§)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: ORIGINALID
+          type: String
+          width: 16
+        - name: NAMN
+          type: String
+          width: 64
+        - name: BESKRIVNIN
+          type: String
+          width: 254
+        - name: METODBESKR
+          type: String
+          width: 254
+        - name: TILLKDATUM
+          type: Date
+        - name: REVDATUM
+          type: Date
+        - name: ANM
+          type: String
+          width: 254
+        - name: OBJTYP
+          type: String
+          width: 254
+        - name: OBJEKTLANK
+          type: String
+          width: 254
+        - name: REFERENS
+          type: String
+          width: 254
+    source:
+      download: 'https://ext-dokument.lansstyrelsen.se/gemensamt/geodata/ShapeExport/lst.LST_RI_Obruten_kust_MB4kap3.zip'
+      cache: lst/
+      unar:
+        format: zip
+        patterns:
+          - 'lst.LST_RI_Obruten_kust_MB4kap3.*'
+    import:
+      path: 'lst.LST_RI_Obruten_kust_MB4kap3.shp'
+      format: ESRI Shapefile
+      layername: lst.LST_RI_Obruten_kust_MB4kap3
+    publish: obruten_kust
+
+  'ri:obrutet_fjall':
+    # https://ext-geodatakatalog.lansstyrelsen.se/GeodataKatalogen/srv/api/records/GetMetaDataById?id=b1d59cb0-2e71-4c08-b99d-e4cc7507cb92
+    description: Obrutet fjäll (MB 4 kap 5§)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: ORIGINALID
+          type: String
+          width: 16
+          unique: true
+        - name: NAMN
+          type: String
+          width: 64
+          nullable: false
+        - name: BESKRIVNIN
+          type: String
+          width: 254
+        - name: METODBESKR
+          type: String
+          width: 254
+        - name: TILLKDATUM
+          type: Date
+        - name: REVDATUM
+          type: Date
+        - name: OBJEKTLANK
+          type: String
+          width: 254
+        - name: REFERENS
+          type: String
+          width: 254
+    source:
+      download: 'https://ext-dokument.lansstyrelsen.se/gemensamt/geodata/ShapeExport/lst.Lst_RI_Obrutet_fjall_MB4kap5.zip'
+      cache: lst/
+      unar:
+        format: zip
+        patterns:
+          - 'lst.Lst_RI_Obrutet_fjall_MB4kap5.*'
+    import:
+      path: 'lst.Lst_RI_Obrutet_fjall_MB4kap5.shp'
+      format: ESRI Shapefile
+      layername: lst.Lst_RI_Obrutet_fjall_MB4kap5
+    publish: obrutet_fjall
+
+  'ri:skyddade_vattendrag':
+    # https://ext-geodatakatalog.lansstyrelsen.se/GeodataKatalogen/srv/api/records/GetMetaDataById?id=61e21a50-4320-4db4-8e44-56252dab777e
+    description: Skyddade vattendrag (MB 4 kap 6§)
+    create:
+      geometry-type: MULTIPOLYGON
+      fields:
+        - name: ORIGINALID
+          type: String
+          width: 16
+          unique: true
+        - name: NAMN
+          type: String
+          width: 64
+          nullable: false
+        - name: BESKRIVNIN
+          type: String
+          width: 254
+        - name: METODBESKR
+          type: String
+          width: 254
+        - name: TILLKDATUM
+          type: Date
+        - name: REVDATUM
+          type: Date
+        - name: ANM
+          type: String
+          width: 254
+        - name: DIG_SKALA
+          type: Integer
+        - name: OBJEKTLANK
+          type: String
+          width: 254
+        - name: REFERENS
+          type: String
+          width: 254
+    source:
+      download: 'https://ext-dokument.lansstyrelsen.se/gemensamt/geodata/ShapeExport/lst.LST_RI_Skyddade_vattendrag_MB4kap6.zip'
+      cache: lst/
+      unar:
+        format: zip
+        patterns:
+          - 'lst.LST_RI_Skyddade_vattendrag_MB4kap6.*'
+    import:
+      path: 'lst.LST_RI_Skyddade_vattendrag_MB4kap6.shp'
+      format: ESRI Shapefile
+      layername: lst.LST_RI_Skyddade_vattendrag_MB4kap6
+    publish: skyddade_vattendrag
diff --git a/schema.sql b/schema.sql
index ce88dae..daa8ba2 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1777,6 +1777,304 @@ ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren
 
 
 --
+-- Name: ri:friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."ri:friluftsliv" (
+    ogc_fid bigint NOT NULL,
+    "SKYDD" character varying(64) NOT NULL,
+    "OMRADESNR" character varying(16) NOT NULL,
+    "AMNESOMR" character varying(16) NOT NULL,
+    "NAMN" character varying(127) NOT NULL,
+    "LANK_VARDE" character varying(127) NOT NULL,
+    "BESLDATUM" date,
+    "LAGRUM" character varying(64) NOT NULL,
+    "ARENDENR" character(11) NOT NULL,
+    "LANK_BESLU" character varying(127) NOT NULL,
+    "AKTIVITET" character varying(127),
+    "NATURTYP" character varying(127),
+    "AREA_LAND_" double precision,
+    "AREA_VATTE" double precision,
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
+);
+
+
+ALTER TABLE postgis."ri:friluftsliv" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "ri:friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."ri:friluftsliv" IS 'Riksintresse friluftsliv';
+
+
+--
+-- Name: ri:friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."ri:friluftsliv_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: ri:friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" OWNED BY postgis."ri:friluftsliv".ogc_fid;
+
+
+--
+-- Name: ri:naturvard; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."ri:naturvard" (
+    ogc_fid bigint NOT NULL,
+    "SKYDD" character varying(64) NOT NULL,
+    "AMNESOMRAD" character varying(64) NOT NULL,
+    "NAMN" character varying(127) NOT NULL,
+    "BESKRIVNIN" character varying(254) NOT NULL,
+    "LAGRUM" character varying(64) NOT NULL,
+    "BESLUTSDAT" date NOT NULL,
+    "ORGINALID" character varying(16) NOT NULL,
+    "RIKSID" integer NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
+);
+
+
+ALTER TABLE postgis."ri:naturvard" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "ri:naturvard"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."ri:naturvard" IS 'Riksintresse naturvård';
+
+
+--
+-- Name: ri:naturvard_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."ri:naturvard_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."ri:naturvard_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: ri:naturvard_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."ri:naturvard_ogc_fid_seq" OWNED BY postgis."ri:naturvard".ogc_fid;
+
+
+--
+-- Name: ri:obruten_kust; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."ri:obruten_kust" (
+    ogc_fid bigint NOT NULL,
+    "ORIGINALID" character varying(16),
+    "NAMN" character varying(64),
+    "BESKRIVNIN" character varying(254),
+    "METODBESKR" character varying(254),
+    "TILLKDATUM" date,
+    "REVDATUM" date,
+    "ANM" character varying(254),
+    "OBJTYP" character varying(254),
+    "OBJEKTLANK" character varying(254),
+    "REFERENS" character varying(254),
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
+);
+
+
+ALTER TABLE postgis."ri:obruten_kust" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "ri:obruten_kust"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."ri:obruten_kust" IS 'Obruten kust (MB 4 kap 3§)';
+
+
+--
+-- Name: ri:obruten_kust_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."ri:obruten_kust_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: ri:obruten_kust_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" OWNED BY postgis."ri:obruten_kust".ogc_fid;
+
+
+--
+-- Name: ri:obrutet_fjall; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."ri:obrutet_fjall" (
+    ogc_fid bigint NOT NULL,
+    "ORIGINALID" character varying(16),
+    "NAMN" character varying(64) NOT NULL,
+    "BESKRIVNIN" character varying(254),
+    "METODBESKR" character varying(254),
+    "TILLKDATUM" date,
+    "REVDATUM" date,
+    "OBJEKTLANK" character varying(254),
+    "REFERENS" character varying(254),
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
+);
+
+
+ALTER TABLE postgis."ri:obrutet_fjall" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "ri:obrutet_fjall"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."ri:obrutet_fjall" IS 'Obrutet fjäll (MB 4 kap 5§)';
+
+
+--
+-- Name: ri:obrutet_fjall_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."ri:obrutet_fjall_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: ri:obrutet_fjall_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" OWNED BY postgis."ri:obrutet_fjall".ogc_fid;
+
+
+--
+-- Name: ri:rorligt_friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."ri:rorligt_friluftsliv" (
+    ogc_fid bigint NOT NULL,
+    "ORIGINALID" character varying(16),
+    "NAMN" character varying(64),
+    "BESKRIVNIN" character varying(254),
+    "METODBESKR" character varying(254),
+    "TILLKDATUM" date,
+    "REVDATUM" date,
+    "ANM" character varying(254),
+    "OBJEKTLANK" character varying(254),
+    "REFERENS" character varying(254),
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
+);
+
+
+ALTER TABLE postgis."ri:rorligt_friluftsliv" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "ri:rorligt_friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."ri:rorligt_friluftsliv" IS 'Rörligt friluftsliv (MB 4 kap 1§ och 2§)';
+
+
+--
+-- Name: ri:rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: ri:rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" OWNED BY postgis."ri:rorligt_friluftsliv".ogc_fid;
+
+
+--
+-- Name: ri:skyddade_vattendrag; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."ri:skyddade_vattendrag" (
+    ogc_fid bigint NOT NULL,
+    "ORIGINALID" character varying(16),
+    "NAMN" character varying(64) NOT NULL,
+    "BESKRIVNIN" character varying(254),
+    "METODBESKR" character varying(254),
+    "TILLKDATUM" date,
+    "REVDATUM" date,
+    "ANM" character varying(254),
+    "DIG_SKALA" integer,
+    "OBJEKTLANK" character varying(254),
+    "REFERENS" character varying(254),
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
+);
+
+
+ALTER TABLE postgis."ri:skyddade_vattendrag" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "ri:skyddade_vattendrag"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."ri:skyddade_vattendrag" IS 'Skyddade vattendrag (MB 4 kap 6§)';
+
+
+--
+-- Name: ri:skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."ri:skyddade_vattendrag_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: ri:skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" OWNED BY postgis."ri:skyddade_vattendrag".ogc_fid;
+
+
+--
 -- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
@@ -2417,6 +2715,48 @@ ALTER TABLE ONLY postgis."ren:riks_ren" ALTER COLUMN ogc_fid SET DEFAULT nextval
 
 
 --
+-- Name: ri:friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:friluftsliv_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: ri:naturvard ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:naturvard" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:naturvard_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: ri:obruten_kust ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:obruten_kust" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:obruten_kust_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: ri:obrutet_fjall ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:obrutet_fjall" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:obrutet_fjall_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: ri:rorligt_friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:rorligt_friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:rorligt_friluftsliv_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: ri:skyddade_vattendrag ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:skyddade_vattendrag" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:skyddade_vattendrag_ogc_fid_seq"'::regclass);
+
+
+--
 -- Name: sametinget:betesomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
@@ -3114,6 +3454,78 @@ ALTER TABLE ONLY postgis."ren:riks_ren"
 
 
 --
+-- Name: ri:friluftsliv ri:friluftsliv_OMRADESNR_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:friluftsliv"
+    ADD CONSTRAINT "ri:friluftsliv_OMRADESNR_key" UNIQUE ("OMRADESNR");
+
+
+--
+-- Name: ri:friluftsliv ri:friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:friluftsliv"
+    ADD CONSTRAINT "ri:friluftsliv_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: ri:naturvard ri:naturvard_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:naturvard"
+    ADD CONSTRAINT "ri:naturvard_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: ri:obruten_kust ri:obruten_kust_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:obruten_kust"
+    ADD CONSTRAINT "ri:obruten_kust_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: ri:obrutet_fjall ri:obrutet_fjall_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:obrutet_fjall"
+    ADD CONSTRAINT "ri:obrutet_fjall_ORIGINALID_key" UNIQUE ("ORIGINALID");
+
+
+--
+-- Name: ri:obrutet_fjall ri:obrutet_fjall_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:obrutet_fjall"
+    ADD CONSTRAINT "ri:obrutet_fjall_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: ri:rorligt_friluftsliv ri:rorligt_friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:rorligt_friluftsliv"
+    ADD CONSTRAINT "ri:rorligt_friluftsliv_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: ri:skyddade_vattendrag ri:skyddade_vattendrag_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:skyddade_vattendrag"
+    ADD CONSTRAINT "ri:skyddade_vattendrag_ORIGINALID_key" UNIQUE ("ORIGINALID");
+
+
+--
+-- Name: ri:skyddade_vattendrag ri:skyddade_vattendrag_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."ri:skyddade_vattendrag"
+    ADD CONSTRAINT "ri:skyddade_vattendrag_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
 -- Name: sametinget:betesomraden sametinget:betesomraden_SAMEBY_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
@@ -3472,6 +3884,48 @@ CREATE INDEX "ren:riks_ren_wkb_geometry_geom_idx" ON postgis."ren:riks_ren" USIN
 
 
 --
+-- Name: ri:friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "ri:friluftsliv_wkb_geometry_geom_idx" ON postgis."ri:friluftsliv" USING gist (wkb_geometry);
+
+
+--
+-- Name: ri:naturvard_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "ri:naturvard_wkb_geometry_geom_idx" ON postgis."ri:naturvard" USING gist (wkb_geometry);
+
+
+--
+-- Name: ri:obruten_kust_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "ri:obruten_kust_wkb_geometry_geom_idx" ON postgis."ri:obruten_kust" USING gist (wkb_geometry);
+
+
+--
+-- Name: ri:obrutet_fjall_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "ri:obrutet_fjall_wkb_geometry_geom_idx" ON postgis."ri:obrutet_fjall" USING gist (wkb_geometry);
+
+
+--
+-- Name: ri:rorligt_friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "ri:rorligt_friluftsliv_wkb_geometry_geom_idx" ON postgis."ri:rorligt_friluftsliv" USING gist (wkb_geometry);
+
+
+--
+-- Name: ri:skyddade_vattendrag_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "ri:skyddade_vattendrag_wkb_geometry_geom_idx" ON postgis."ri:skyddade_vattendrag" USING gist (wkb_geometry);
+
+
+--
 -- Name: sametinget:betesomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
@@ -4027,6 +4481,90 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" TO webmap_gues
 
 
 --
+-- Name: TABLE "ri:friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."ri:friluftsliv" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "ri:friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "ri:naturvard"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."ri:naturvard" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "ri:naturvard_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."ri:naturvard_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "ri:obruten_kust"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."ri:obruten_kust" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "ri:obruten_kust_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "ri:obrutet_fjall"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."ri:obrutet_fjall" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "ri:obrutet_fjall_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "ri:rorligt_friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."ri:rorligt_friluftsliv" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "ri:rorligt_friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "ri:skyddade_vattendrag"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."ri:skyddade_vattendrag" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "ri:skyddade_vattendrag_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" TO webmap_guest;
+
+
+--
 -- Name: TABLE "sametinget:betesomraden"; Type: ACL; Schema: postgis; Owner: webmap_import
 --