aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2024-10-18 15:57:02 +0200
committerGuilhem Moulin <guilhem@fripost.org>2024-10-18 17:26:18 +0200
commita40c3c3e5739608ee21632b67006eddd3309b367 (patch)
tree749e137ced977bd6ca3f4ca49304e24a339db01b
parent7cb7e29ad8250cc9f0fe75848282fda3d2c5b914 (diff)
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.
-rw-r--r--config.yml304
-rw-r--r--schema.sql538
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
--