From a40c3c3e5739608ee21632b67006eddd3309b367 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin 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. --- config.yml | 304 ++++++++++++++++++++++++++++++++++ schema.sql | 538 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 842 insertions(+) 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 @@ -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