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