From a40c3c3e5739608ee21632b67006eddd3309b367 Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Fri, 18 Oct 2024 15:57:02 +0200
Subject: =?UTF-8?q?Add=20layers=20for=20Naturv=C3=A5rdsverkets=20and=20L?=
 =?UTF-8?q?=C3=A4nsstyrelserns=20Riksintressen.?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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.
---
 schema.sql | 538 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 538 insertions(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index ce88dae..daa8ba2 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1776,6 +1776,304 @@ ALTER TABLE postgis."ren:riks_ren_ogc_fid_seq" OWNER TO webmap_import;
 ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren".ogc_fid;
 
 
+--
+-- 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
 --
@@ -2416,6 +2714,48 @@ ALTER TABLE ONLY postgis."ren:omr_riks" ALTER COLUMN ogc_fid SET DEFAULT nextval
 ALTER TABLE ONLY postgis."ren:riks_ren" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:riks_ren_ogc_fid_seq"'::regclass);
 
 
+--
+-- 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
 --
@@ -3113,6 +3453,78 @@ ALTER TABLE ONLY postgis."ren:riks_ren"
     ADD CONSTRAINT "ren:riks_ren_pkey" PRIMARY KEY (ogc_fid);
 
 
+--
+-- 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
 --
@@ -3471,6 +3883,48 @@ CREATE INDEX "ren:omr_riks_wkb_geometry_geom_idx" ON postgis."ren:omr_riks" USIN
 CREATE INDEX "ren:riks_ren_wkb_geometry_geom_idx" ON postgis."ren:riks_ren" USING gist (wkb_geometry);
 
 
+--
+-- 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
 --
@@ -4026,6 +4480,90 @@ GRANT SELECT ON TABLE postgis."ren:riks_ren" TO webmap_guest;
 GRANT SELECT,USAGE ON SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" TO webmap_guest;
 
 
+--
+-- 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
 --
-- 
cgit v1.2.3

