From 981a97c572ee064b4f3ade5d1fc9e5c4397701ff Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Mon, 28 Apr 2025 12:47:31 +0200
Subject: =?UTF-8?q?Update=20Mineralr=C3=A4ttigheter=20import=20logic.?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Thanks to EU Directive 2019/1024 of the European Parliament and of the
Council of 20 June 2019 on open data and the re-use of public sector
information, and the Commission Implementing Regulation (EU) 2023/138 of
21 December 2022, the mineral register is now available under the terms
of the CC0 1.0 Universal licence, see
https://www.sgu.se/produkter-och-tjanster/geologiska-data/malmer-och-mineral--geologiska-data/mineralrattigheter-och-prospektering/

Given we no longer need to parse SVG images from the webmap, we drop
webmap-download-mrr.py and add layers for expired and forbidden permits
(ut_metaller_industrimineral_forfallna, ut_olja_gas_diamant_forfallna,
bearbetningskoncessioner_forfallna, ut_metaller_industrimineral_forbud,
ut_diamant_forbud) as well as markanvisningar_bk_ansokta.

Unfortunately the GeoPackage file doesn't include peat concessions, so
we drop them from config.yml for now.  Should they be of interest we can
always restore webmap-download-mrr.py and/or order the register from
Bergsstaten, cf. https://resource.sgu.se/bergsstaten/exporter-ur-mrr-info.pdf .
---
 schema.sql | 1037 ++++++++++++++++++++++++++++++++++++++++++++----------------
 1 file changed, 772 insertions(+), 265 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index e5a1002..0afcee2 100644
--- a/schema.sql
+++ b/schema.sql
@@ -274,35 +274,35 @@ ALTER SEQUENCE postgis.lansyta_ogc_fid_seq OWNED BY postgis.lansyta.ogc_fid;
 
 
 --
--- Name: mrr:bearbetningskoncessioner_applied; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."mrr:bearbetningskoncessioner_applied" (
+CREATE TABLE postgis."mrr:bearbetningskoncessioner_ansokta" (
     ogc_fid bigint NOT NULL,
-    "Name" character varying(254) NOT NULL,
-    "Mineral" character varying(254) NOT NULL,
-    "Applicant" character varying(254) NOT NULL,
-    "ApplicationDate" date NOT NULL,
-    "DiaryNr" character varying(16) NOT NULL,
-    "LastUpdated" date NOT NULL,
+    name character varying(254) NOT NULL,
+    diarynr character varying(16) NOT NULL,
+    appl_date date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(254) NOT NULL,
+    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
 
-ALTER TABLE postgis."mrr:bearbetningskoncessioner_applied" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:bearbetningskoncessioner_ansokta" OWNER TO webmap_import;
 
 --
--- Name: TABLE "mrr:bearbetningskoncessioner_applied"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:bearbetningskoncessioner_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_applied" IS 'Bearbetningskoncessioner, ansökta (SGU)';
+COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_ansokta" IS 'Bearbetningskoncessioner, ansökta (SGU)';
 
 
 --
--- Name: mrr:bearbetningskoncessioner_applied_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq"
+CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -310,46 +310,49 @@ CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: mrr:bearbetningskoncessioner_applied_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_applied".ogc_fid;
+ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_ansokta".ogc_fid;
 
 
 --
--- Name: mrr:bearbetningskoncessioner_approved; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."mrr:bearbetningskoncessioner_approved" (
+CREATE TABLE postgis."mrr:bearbetningskoncessioner_beviljade" (
     ogc_fid bigint NOT NULL,
-    "Name" character varying(254) NOT NULL,
-    "Mineral" character varying(254) NOT NULL,
-    "Owner" character varying(254) NOT NULL,
-    "ValidFrom" date NOT NULL,
-    "ValidTo" date NOT NULL,
-    "DiaryNr" character varying(16),
-    "LastUpdated" date NOT NULL,
+    name character varying(254) NOT NULL,
+    licenceid character varying(16),
+    diarynr character varying(16) NOT NULL,
+    appl_date date NOT NULL,
+    dec_date date NOT NULL,
+    validfrom date NOT NULL,
+    validto date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(254) NOT NULL,
+    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
 
-ALTER TABLE postgis."mrr:bearbetningskoncessioner_approved" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:bearbetningskoncessioner_beviljade" OWNER TO webmap_import;
 
 --
--- Name: TABLE "mrr:bearbetningskoncessioner_approved"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:bearbetningskoncessioner_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_approved" IS 'Bearbetningskoncessioner, beviljade (SGU)';
+COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_beviljade" IS 'Bearbetningskoncessioner, beviljade (SGU)';
 
 
 --
--- Name: mrr:bearbetningskoncessioner_approved_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq"
+CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -357,43 +360,46 @@ CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: mrr:bearbetningskoncessioner_approved_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_approved".ogc_fid;
+ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_beviljade".ogc_fid;
 
 
 --
--- Name: mrr:markanvisningar; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_forfallna; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."mrr:markanvisningar" (
+CREATE TABLE postgis."mrr:bearbetningskoncessioner_forfallna" (
     ogc_fid bigint NOT NULL,
-    "Name" character varying(254) NOT NULL,
-    "DecisionDate" date,
-    "DiaryNr" character varying(16),
-    "LastUpdated" date NOT NULL,
+    name character varying(254) NOT NULL,
+    licenceid character varying(16),
+    diarynr character varying(16) NOT NULL,
+    appl_date date,
+    mineral character varying(254) NOT NULL,
+    owners character varying(254) NOT NULL,
+    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
 
-ALTER TABLE postgis."mrr:markanvisningar" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:bearbetningskoncessioner_forfallna" OWNER TO webmap_import;
 
 --
--- Name: TABLE "mrr:markanvisningar"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:bearbetningskoncessioner_forfallna"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."mrr:markanvisningar" IS 'Markanvisning till koncession (SGU)';
+COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_forfallna" IS 'Bearbetningskoncessioner, förfallna (SGU)';
 
 
 --
--- Name: mrr:markanvisningar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq"
+CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -401,45 +407,44 @@ CREATE SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."mrr:markanvisningar_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: mrr:markanvisningar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" OWNED BY postgis."mrr:markanvisningar".ogc_fid;
+ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_forfallna".ogc_fid;
 
 
 --
--- Name: mrr:mineral_applied; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:markanvisningar_bk_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."mrr:mineral_applied" (
+CREATE TABLE postgis."mrr:markanvisningar_bk_ansokta" (
     ogc_fid bigint NOT NULL,
-    "Name" character varying(254) NOT NULL,
-    "Mineral" character varying(254) NOT NULL,
-    "Applicant" character varying(254) NOT NULL,
-    "ApplicationDate" date NOT NULL,
-    "DiaryNr" character varying(16) NOT NULL,
-    "LastUpdated" date NOT NULL,
+    name character varying(254) NOT NULL,
+    diarynr character varying(16) NOT NULL,
+    conc_name character varying(254) NOT NULL,
+    appl_date date NOT NULL,
+    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
 
-ALTER TABLE postgis."mrr:mineral_applied" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:markanvisningar_bk_ansokta" OWNER TO webmap_import;
 
 --
--- Name: TABLE "mrr:mineral_applied"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:markanvisningar_bk_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."mrr:mineral_applied" IS 'Undersökningstillstånd, metallar och mineral, ansökta (SGU)';
+COMMENT ON TABLE postgis."mrr:markanvisningar_bk_ansokta" IS 'Markanvisningar till bearbetningskoncessioner, ansökta (SGU)';
 
 
 --
--- Name: mrr:mineral_applied_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq"
+CREATE SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -447,47 +452,46 @@ CREATE SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."mrr:mineral_applied_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: mrr:mineral_applied_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq" OWNED BY postgis."mrr:mineral_applied".ogc_fid;
+ALTER SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:markanvisningar_bk_ansokta".ogc_fid;
 
 
 --
--- Name: mrr:mineral_approved; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:markanvisningar_bk_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."mrr:mineral_approved" (
+CREATE TABLE postgis."mrr:markanvisningar_bk_beviljade" (
     ogc_fid bigint NOT NULL,
-    "Name" character varying(254) NOT NULL,
-    "Mineral" character varying(254) NOT NULL,
-    "Owner" character varying(254) NOT NULL,
-    "LicenceID" character varying(8) NOT NULL,
-    "ValidFrom" date NOT NULL,
-    "ValidTo" date NOT NULL,
-    "DiaryNr" character varying(16),
-    "LastUpdated" date NOT NULL,
+    name character varying(254) NOT NULL,
+    licenceid character varying(16),
+    diarynr character varying(16) NOT NULL,
+    conc_name character varying(254) NOT NULL,
+    appl_date date NOT NULL,
+    dec_date date NOT NULL,
+    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
 
-ALTER TABLE postgis."mrr:mineral_approved" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:markanvisningar_bk_beviljade" OWNER TO webmap_import;
 
 --
--- Name: TABLE "mrr:mineral_approved"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:markanvisningar_bk_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."mrr:mineral_approved" IS 'Undersökningstillstånd, metallar och mineral, beviljade (SGU)';
+COMMENT ON TABLE postgis."mrr:markanvisningar_bk_beviljade" IS 'Markanvisningar till bearbetningskoncessioner, beviljade (SGU)';
 
 
 --
--- Name: mrr:mineral_approved_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq"
+CREATE SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -495,45 +499,45 @@ CREATE SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."mrr:mineral_approved_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: mrr:mineral_approved_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq" OWNED BY postgis."mrr:mineral_approved".ogc_fid;
+ALTER SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:markanvisningar_bk_beviljade".ogc_fid;
 
 
 --
--- Name: mrr:olja_gas_diamant_applied; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."mrr:olja_gas_diamant_applied" (
+CREATE TABLE postgis."mrr:ut_diamant_ansokta" (
     ogc_fid bigint NOT NULL,
-    "Name" character varying(254) NOT NULL,
-    "Mineral" character varying(254) NOT NULL,
-    "Applicant" character varying(254) NOT NULL,
-    "ApplicationDate" date NOT NULL,
-    "DiaryNr" character varying(16) NOT NULL,
-    "LastUpdated" date NOT NULL,
+    name character varying(254) NOT NULL,
+    diarynr character varying(16) NOT NULL,
+    appl_date date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(254) NOT NULL,
+    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
 
-ALTER TABLE postgis."mrr:olja_gas_diamant_applied" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:ut_diamant_ansokta" OWNER TO webmap_import;
 
 --
--- Name: TABLE "mrr:olja_gas_diamant_applied"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_diamant_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."mrr:olja_gas_diamant_applied" IS 'Undersökningstillstånd, olja, gas och diamant, ansökta (SGU)';
+COMMENT ON TABLE postgis."mrr:ut_diamant_ansokta" IS 'Undersökningstillstånd - Diamant, ansökta (SGU)';
 
 
 --
--- Name: mrr:olja_gas_diamant_applied_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq"
+CREATE SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -541,47 +545,49 @@ CREATE SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: mrr:olja_gas_diamant_applied_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" OWNED BY postgis."mrr:olja_gas_diamant_applied".ogc_fid;
+ALTER SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:ut_diamant_ansokta".ogc_fid;
 
 
 --
--- Name: mrr:olja_gas_diamant_approved; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."mrr:olja_gas_diamant_approved" (
+CREATE TABLE postgis."mrr:ut_diamant_beviljade" (
     ogc_fid bigint NOT NULL,
-    "Name" character varying(254) NOT NULL,
-    "Mineral" character varying(254) NOT NULL,
-    "Owner" character varying(254) NOT NULL,
-    "LicenceID" character varying(8) NOT NULL,
-    "ValidFrom" date NOT NULL,
-    "ValidTo" date NOT NULL,
-    "DiaryNr" character varying(16),
-    "LastUpdated" date NOT NULL,
+    name character varying(254) NOT NULL,
+    licenceid character varying(16),
+    diarynr character varying(16) NOT NULL,
+    appl_date date NOT NULL,
+    dec_date date NOT NULL,
+    validfrom date NOT NULL,
+    validto date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(254) NOT NULL,
+    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
 
-ALTER TABLE postgis."mrr:olja_gas_diamant_approved" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:ut_diamant_beviljade" OWNER TO webmap_import;
 
 --
--- Name: TABLE "mrr:olja_gas_diamant_approved"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_diamant_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."mrr:olja_gas_diamant_approved" IS 'Undersökningstillstånd, olja, gas och diamant, beviljade (SGU)';
+COMMENT ON TABLE postgis."mrr:ut_diamant_beviljade" IS 'Undersökningstillstånd - Diamant, beviljade (SGU)';
 
 
 --
--- Name: mrr:olja_gas_diamant_approved_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq"
+CREATE SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -589,46 +595,49 @@ CREATE SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: mrr:olja_gas_diamant_approved_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" OWNED BY postgis."mrr:olja_gas_diamant_approved".ogc_fid;
+ALTER SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:ut_diamant_beviljade".ogc_fid;
 
 
 --
--- Name: mrr:torvkoncessioner; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."mrr:torvkoncessioner" (
+CREATE TABLE postgis."mrr:ut_diamant_forbud" (
     ogc_fid bigint NOT NULL,
-    "Name" character varying(254) NOT NULL,
-    "Mineral" character varying(254),
-    "Owner" character varying(254) NOT NULL,
-    "ValidFrom" date NOT NULL,
-    "ValidTo" date NOT NULL,
-    "DiaryNr" character varying(16),
-    "LastUpdated" date NOT NULL,
+    name character varying(254) NOT NULL,
+    licenceid character varying(16),
+    diarynr character varying(16) NOT NULL,
+    validfrom date NOT NULL,
+    validto date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(254) NOT NULL,
+    prospdata_url character varying(254),
+    prospdata_filesize_mb real,
+    export_date date NOT NULL,
     wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
 );
 
 
-ALTER TABLE postgis."mrr:torvkoncessioner" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:ut_diamant_forbud" OWNER TO webmap_import;
 
 --
--- Name: TABLE "mrr:torvkoncessioner"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_diamant_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."mrr:torvkoncessioner" IS 'Torvkoncessioner (SGU)';
+COMMENT ON TABLE postgis."mrr:ut_diamant_forbud" IS 'Undersökningstillstånd - Diamant, förbud (SGU)';
 
 
 --
--- Name: mrr:torvkoncessioner_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq"
+CREATE SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -636,13 +645,259 @@ CREATE SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."mrr:torvkoncessioner_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: mrr:torvkoncessioner_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" OWNED BY postgis."mrr:torvkoncessioner".ogc_fid;
+ALTER SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" OWNED BY postgis."mrr:ut_diamant_forbud".ogc_fid;
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" (
+    ogc_fid bigint NOT NULL,
+    name character varying(254) NOT NULL,
+    diarynr character varying(16) NOT NULL,
+    appl_date date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(254) NOT NULL,
+    export_date date NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
+);
+
+
+ALTER TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "mrr:ut_metaller_industrimineral_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" IS 'Undersökningstillstånd - Metaller och industrimineral, ansökta (SGU)';
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_ansokta".ogc_fid;
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" (
+    ogc_fid bigint NOT NULL,
+    name character varying(254) NOT NULL,
+    licenceid character varying(16),
+    diarynr character varying(16) NOT NULL,
+    appl_date date NOT NULL,
+    dec_date date NOT NULL,
+    validfrom date NOT NULL,
+    validto date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(254) NOT NULL,
+    export_date date NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
+);
+
+
+ALTER TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "mrr:ut_metaller_industrimineral_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" IS 'Undersökningstillstånd - Metaller och industrimineral, beviljade (SGU)';
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_beviljade".ogc_fid;
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."mrr:ut_metaller_industrimineral_forbud" (
+    ogc_fid bigint NOT NULL,
+    name character varying(254) NOT NULL,
+    licenceid character varying(16),
+    diarynr character varying(16) NOT NULL,
+    validfrom date NOT NULL,
+    validto date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(254) NOT NULL,
+    prospdata_url character varying(254),
+    prospdata_filesize_mb real,
+    export_date date NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
+);
+
+
+ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "mrr:ut_metaller_industrimineral_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forbud" IS 'Undersökningstillstånd - Metaller och industrimineral, förbud (SGU)';
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_forbud".ogc_fid;
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_forfallna; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" (
+    ogc_fid bigint NOT NULL,
+    name character varying(254) NOT NULL,
+    licenceid character varying(16),
+    diarynr character varying(16) NOT NULL,
+    validfrom date NOT NULL,
+    validto date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(510) NOT NULL,
+    prospdata_url character varying(254),
+    prospdata_filesize_mb real,
+    export_date date NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
+);
+
+
+ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "mrr:ut_metaller_industrimineral_forfallna"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" IS 'Undersökningstillstånd - Metaller och industrimineral, förfallna (SGU)';
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_forfallna".ogc_fid;
+
+
+--
+-- Name: mrr:ut_olja_gas_diamant_forfallna; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" (
+    ogc_fid bigint NOT NULL,
+    name character varying(254) NOT NULL,
+    licenceid character varying(16),
+    diarynr character varying(16) NOT NULL,
+    validfrom date NOT NULL,
+    validto date NOT NULL,
+    mineral character varying(254) NOT NULL,
+    owners character varying(510) NOT NULL,
+    prospdata_url character varying(254),
+    prospdata_filesize_mb real,
+    export_date date NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
+);
+
+
+ALTER TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "mrr:ut_olja_gas_diamant_forfallna"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" IS 'Undersökningstillstånd - Olja, gas och diamant, förfallna (SGU)';
+
+
+--
+-- Name: mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" OWNED BY postgis."mrr:ut_olja_gas_diamant_forfallna".ogc_fid;
 
 
 --
@@ -2820,59 +3075,94 @@ ALTER TABLE ONLY postgis.lansyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postg
 
 
 --
--- Name: mrr:bearbetningskoncessioner_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_ansokta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_ansokta" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_beviljade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_beviljade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_forfallna ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_forfallna" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq"'::regclass);
 
 
 --
--- Name: mrr:bearbetningskoncessioner_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:markanvisningar_bk_ansokta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."mrr:markanvisningar_bk_ansokta" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq"'::regclass);
 
 
 --
--- Name: mrr:markanvisningar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:markanvisningar_bk_beviljade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:markanvisningar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:markanvisningar_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."mrr:markanvisningar_bk_beviljade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq"'::regclass);
 
 
 --
--- Name: mrr:mineral_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_ansokta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:mineral_applied" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:mineral_applied_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."mrr:ut_diamant_ansokta" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:ut_diamant_ansokta_ogc_fid_seq"'::regclass);
 
 
 --
--- Name: mrr:mineral_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_beviljade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:mineral_approved" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:mineral_approved_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."mrr:ut_diamant_beviljade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:ut_diamant_beviljade_ogc_fid_seq"'::regclass);
 
 
 --
--- Name: mrr:olja_gas_diamant_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_forbud ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."mrr:ut_diamant_forbud" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:ut_diamant_forbud_ogc_fid_seq"'::regclass);
 
 
 --
--- Name: mrr:olja_gas_diamant_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_ansokta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_ansokta" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq"'::regclass);
 
 
 --
--- Name: mrr:torvkoncessioner ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_beviljade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:torvkoncessioner" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:torvkoncessioner_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_beviljade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_forbud ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_forbud" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_forfallna ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_forfallna" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: mrr:ut_olja_gas_diamant_forfallna ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:ut_olja_gas_diamant_forfallna" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq"'::regclass);
 
 
 --
@@ -3242,187 +3532,299 @@ ALTER TABLE ONLY postgis.lansyta
 
 
 --
--- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_ansokta mrr:bearbetningskoncessioner_ansokta_diarynr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_ansokta"
+    ADD CONSTRAINT "mrr:bearbetningskoncessioner_ansokta_diarynr_key" UNIQUE (diarynr);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_ansokta mrr:bearbetningskoncessioner_ansokta_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_ansokta"
+    ADD CONSTRAINT "mrr:bearbetningskoncessioner_ansokta_name_key" UNIQUE (name);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_ansokta mrr:bearbetningskoncessioner_ansokta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_ansokta"
+    ADD CONSTRAINT "mrr:bearbetningskoncessioner_ansokta_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_beviljade mrr:bearbetningskoncessioner_beviljade_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_beviljade"
+    ADD CONSTRAINT "mrr:bearbetningskoncessioner_beviljade_licenceid_key" UNIQUE (licenceid);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_beviljade mrr:bearbetningskoncessioner_beviljade_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_beviljade"
+    ADD CONSTRAINT "mrr:bearbetningskoncessioner_beviljade_name_key" UNIQUE (name);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_beviljade mrr:bearbetningskoncessioner_beviljade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_beviljade"
+    ADD CONSTRAINT "mrr:bearbetningskoncessioner_beviljade_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_forfallna mrr:bearbetningskoncessioner_forfallna_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_forfallna"
+    ADD CONSTRAINT "mrr:bearbetningskoncessioner_forfallna_name_key" UNIQUE (name);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_forfallna mrr:bearbetningskoncessioner_forfallna_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_forfallna"
+    ADD CONSTRAINT "mrr:bearbetningskoncessioner_forfallna_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: mrr:markanvisningar_bk_ansokta mrr:markanvisningar_bk_ansokta_diarynr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:markanvisningar_bk_ansokta"
+    ADD CONSTRAINT "mrr:markanvisningar_bk_ansokta_diarynr_key" UNIQUE (diarynr);
+
+
+--
+-- Name: mrr:markanvisningar_bk_ansokta mrr:markanvisningar_bk_ansokta_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:markanvisningar_bk_ansokta"
+    ADD CONSTRAINT "mrr:markanvisningar_bk_ansokta_name_key" UNIQUE (name);
+
+
+--
+-- Name: mrr:markanvisningar_bk_ansokta mrr:markanvisningar_bk_ansokta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:markanvisningar_bk_ansokta"
+    ADD CONSTRAINT "mrr:markanvisningar_bk_ansokta_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: mrr:markanvisningar_bk_beviljade mrr:markanvisningar_bk_beviljade_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:markanvisningar_bk_beviljade"
+    ADD CONSTRAINT "mrr:markanvisningar_bk_beviljade_licenceid_key" UNIQUE (licenceid);
+
+
+--
+-- Name: mrr:markanvisningar_bk_beviljade mrr:markanvisningar_bk_beviljade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:markanvisningar_bk_beviljade"
+    ADD CONSTRAINT "mrr:markanvisningar_bk_beviljade_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: mrr:ut_diamant_ansokta mrr:ut_diamant_ansokta_diarynr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied"
-    ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_DiaryNr_key" UNIQUE ("DiaryNr");
+ALTER TABLE ONLY postgis."mrr:ut_diamant_ansokta"
+    ADD CONSTRAINT "mrr:ut_diamant_ansokta_diarynr_key" UNIQUE (diarynr);
 
 
 --
--- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_ansokta mrr:ut_diamant_ansokta_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied"
-    ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_Name_key" UNIQUE ("Name");
+ALTER TABLE ONLY postgis."mrr:ut_diamant_ansokta"
+    ADD CONSTRAINT "mrr:ut_diamant_ansokta_name_key" UNIQUE (name);
 
 
 --
--- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_ansokta mrr:ut_diamant_ansokta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied"
-    ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."mrr:ut_diamant_ansokta"
+    ADD CONSTRAINT "mrr:ut_diamant_ansokta_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
--- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_beviljade mrr:ut_diamant_beviljade_diarynr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved"
-    ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_Name_key" UNIQUE ("Name");
+ALTER TABLE ONLY postgis."mrr:ut_diamant_beviljade"
+    ADD CONSTRAINT "mrr:ut_diamant_beviljade_diarynr_key" UNIQUE (diarynr);
 
 
 --
--- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_beviljade mrr:ut_diamant_beviljade_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved"
-    ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."mrr:ut_diamant_beviljade"
+    ADD CONSTRAINT "mrr:ut_diamant_beviljade_licenceid_key" UNIQUE (licenceid);
 
 
 --
--- Name: mrr:markanvisningar mrr:markanvisningar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_beviljade mrr:ut_diamant_beviljade_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:markanvisningar"
-    ADD CONSTRAINT "mrr:markanvisningar_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."mrr:ut_diamant_beviljade"
+    ADD CONSTRAINT "mrr:ut_diamant_beviljade_name_key" UNIQUE (name);
 
 
 --
--- Name: mrr:mineral_applied mrr:mineral_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_beviljade mrr:ut_diamant_beviljade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:mineral_applied"
-    ADD CONSTRAINT "mrr:mineral_applied_DiaryNr_key" UNIQUE ("DiaryNr");
+ALTER TABLE ONLY postgis."mrr:ut_diamant_beviljade"
+    ADD CONSTRAINT "mrr:ut_diamant_beviljade_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
--- Name: mrr:mineral_applied mrr:mineral_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_forbud mrr:ut_diamant_forbud_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:mineral_applied"
-    ADD CONSTRAINT "mrr:mineral_applied_Name_key" UNIQUE ("Name");
+ALTER TABLE ONLY postgis."mrr:ut_diamant_forbud"
+    ADD CONSTRAINT "mrr:ut_diamant_forbud_licenceid_key" UNIQUE (licenceid);
 
 
 --
--- Name: mrr:mineral_applied mrr:mineral_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_forbud mrr:ut_diamant_forbud_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:mineral_applied"
-    ADD CONSTRAINT "mrr:mineral_applied_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."mrr:ut_diamant_forbud"
+    ADD CONSTRAINT "mrr:ut_diamant_forbud_name_key" UNIQUE (name);
 
 
 --
--- Name: mrr:mineral_approved mrr:mineral_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_forbud mrr:ut_diamant_forbud_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:mineral_approved"
-    ADD CONSTRAINT "mrr:mineral_approved_DiaryNr_key" UNIQUE ("DiaryNr");
+ALTER TABLE ONLY postgis."mrr:ut_diamant_forbud"
+    ADD CONSTRAINT "mrr:ut_diamant_forbud_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
--- Name: mrr:mineral_approved mrr:mineral_approved_LicenceID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_ansokta mrr:ut_metaller_industrimineral_ansokta_diarynr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:mineral_approved"
-    ADD CONSTRAINT "mrr:mineral_approved_LicenceID_key" UNIQUE ("LicenceID");
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_ansokta"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_ansokta_diarynr_key" UNIQUE (diarynr);
 
 
 --
--- Name: mrr:mineral_approved mrr:mineral_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_ansokta mrr:ut_metaller_industrimineral_ansokta_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:mineral_approved"
-    ADD CONSTRAINT "mrr:mineral_approved_Name_key" UNIQUE ("Name");
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_ansokta"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_ansokta_name_key" UNIQUE (name);
 
 
 --
--- Name: mrr:mineral_approved mrr:mineral_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_ansokta mrr:ut_metaller_industrimineral_ansokta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:mineral_approved"
-    ADD CONSTRAINT "mrr:mineral_approved_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_ansokta"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_ansokta_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
--- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_beviljade mrr:ut_metaller_industrimineral_beviljade_diarynr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied"
-    ADD CONSTRAINT "mrr:olja_gas_diamant_applied_DiaryNr_key" UNIQUE ("DiaryNr");
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_beviljade"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_beviljade_diarynr_key" UNIQUE (diarynr);
 
 
 --
--- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_beviljade mrr:ut_metaller_industrimineral_beviljade_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied"
-    ADD CONSTRAINT "mrr:olja_gas_diamant_applied_Name_key" UNIQUE ("Name");
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_beviljade"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_beviljade_licenceid_key" UNIQUE (licenceid);
 
 
 --
--- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_beviljade mrr:ut_metaller_industrimineral_beviljade_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied"
-    ADD CONSTRAINT "mrr:olja_gas_diamant_applied_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_beviljade"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_beviljade_name_key" UNIQUE (name);
 
 
 --
--- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_beviljade mrr:ut_metaller_industrimineral_beviljade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved"
-    ADD CONSTRAINT "mrr:olja_gas_diamant_approved_DiaryNr_key" UNIQUE ("DiaryNr");
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_beviljade"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_beviljade_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
--- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_LicenceID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_forbud mrr:ut_metaller_industrimineral_forbud_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved"
-    ADD CONSTRAINT "mrr:olja_gas_diamant_approved_LicenceID_key" UNIQUE ("LicenceID");
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_forbud"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forbud_licenceid_key" UNIQUE (licenceid);
 
 
 --
--- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_forbud mrr:ut_metaller_industrimineral_forbud_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved"
-    ADD CONSTRAINT "mrr:olja_gas_diamant_approved_Name_key" UNIQUE ("Name");
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_forbud"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forbud_name_key" UNIQUE (name);
 
 
 --
--- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_forbud mrr:ut_metaller_industrimineral_forbud_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved"
-    ADD CONSTRAINT "mrr:olja_gas_diamant_approved_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_forbud"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forbud_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
--- Name: mrr:torvkoncessioner mrr:torvkoncessioner_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_forfallna mrr:ut_metaller_industrimineral_forfallna_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:torvkoncessioner"
-    ADD CONSTRAINT "mrr:torvkoncessioner_DiaryNr_key" UNIQUE ("DiaryNr");
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_forfallna"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forfallna_licenceid_key" UNIQUE (licenceid);
 
 
 --
--- Name: mrr:torvkoncessioner mrr:torvkoncessioner_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_forfallna mrr:ut_metaller_industrimineral_forfallna_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:torvkoncessioner"
-    ADD CONSTRAINT "mrr:torvkoncessioner_Name_key" UNIQUE ("Name");
+ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_forfallna"
+    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forfallna_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
--- Name: mrr:torvkoncessioner mrr:torvkoncessioner_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_olja_gas_diamant_forfallna mrr:ut_olja_gas_diamant_forfallna_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."mrr:torvkoncessioner"
-    ADD CONSTRAINT "mrr:torvkoncessioner_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."mrr:ut_olja_gas_diamant_forfallna"
+    ADD CONSTRAINT "mrr:ut_olja_gas_diamant_forfallna_licenceid_key" UNIQUE (licenceid);
+
+
+--
+-- Name: mrr:ut_olja_gas_diamant_forfallna mrr:ut_olja_gas_diamant_forfallna_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."mrr:ut_olja_gas_diamant_forfallna"
+    ADD CONSTRAINT "mrr:ut_olja_gas_diamant_forfallna_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
@@ -4086,59 +4488,94 @@ CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_ge
 
 
 --
--- Name: mrr:bearbetningskoncessioner_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: mrr:bearbetningskoncessioner_ansokta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "mrr:bearbetningskoncessioner_ansokta_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_ansokta" USING gist (wkb_geometry);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_beviljade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "mrr:bearbetningskoncessioner_beviljade_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_beviljade" USING gist (wkb_geometry);
+
+
+--
+-- Name: mrr:bearbetningskoncessioner_forfallna_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "mrr:bearbetningskoncessioner_forfallna_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_forfallna" USING gist (wkb_geometry);
+
+
+--
+-- Name: mrr:markanvisningar_bk_ansokta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "mrr:bearbetningskoncessioner_applied_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_applied" USING gist (wkb_geometry);
+CREATE INDEX "mrr:markanvisningar_bk_ansokta_wkb_geometry_geom_idx" ON postgis."mrr:markanvisningar_bk_ansokta" USING gist (wkb_geometry);
 
 
 --
--- Name: mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: mrr:markanvisningar_bk_beviljade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_approved" USING gist (wkb_geometry);
+CREATE INDEX "mrr:markanvisningar_bk_beviljade_wkb_geometry_geom_idx" ON postgis."mrr:markanvisningar_bk_beviljade" USING gist (wkb_geometry);
 
 
 --
--- Name: mrr:markanvisningar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_ansokta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "mrr:markanvisningar_wkb_geometry_geom_idx" ON postgis."mrr:markanvisningar" USING gist (wkb_geometry);
+CREATE INDEX "mrr:ut_diamant_ansokta_wkb_geometry_geom_idx" ON postgis."mrr:ut_diamant_ansokta" USING gist (wkb_geometry);
 
 
 --
--- Name: mrr:mineral_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_beviljade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "mrr:mineral_applied_wkb_geometry_geom_idx" ON postgis."mrr:mineral_applied" USING gist (wkb_geometry);
+CREATE INDEX "mrr:ut_diamant_beviljade_wkb_geometry_geom_idx" ON postgis."mrr:ut_diamant_beviljade" USING gist (wkb_geometry);
 
 
 --
--- Name: mrr:mineral_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_diamant_forbud_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "mrr:mineral_approved_wkb_geometry_geom_idx" ON postgis."mrr:mineral_approved" USING gist (wkb_geometry);
+CREATE INDEX "mrr:ut_diamant_forbud_wkb_geometry_geom_idx" ON postgis."mrr:ut_diamant_forbud" USING gist (wkb_geometry);
 
 
 --
--- Name: mrr:olja_gas_diamant_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_ansokta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "mrr:olja_gas_diamant_applied_wkb_geometry_geom_idx" ON postgis."mrr:olja_gas_diamant_applied" USING gist (wkb_geometry);
+CREATE INDEX "mrr:ut_metaller_industrimineral_ansokta_wkb_geometry_geom_idx" ON postgis."mrr:ut_metaller_industrimineral_ansokta" USING gist (wkb_geometry);
 
 
 --
--- Name: mrr:olja_gas_diamant_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_beviljade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "mrr:olja_gas_diamant_approved_wkb_geometry_geom_idx" ON postgis."mrr:olja_gas_diamant_approved" USING gist (wkb_geometry);
+CREATE INDEX "mrr:ut_metaller_industrimineral_beviljade_wkb_geometry_geom_idx" ON postgis."mrr:ut_metaller_industrimineral_beviljade" USING gist (wkb_geometry);
 
 
 --
--- Name: mrr:torvkoncessioner_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: mrr:ut_metaller_industrimineral_forbud_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "mrr:torvkoncessioner_wkb_geometry_geom_idx" ON postgis."mrr:torvkoncessioner" USING gist (wkb_geometry);
+CREATE INDEX "mrr:ut_metaller_industrimineral_forbud_wkb_geometry_geom_idx" ON postgis."mrr:ut_metaller_industrimineral_forbud" USING gist (wkb_geometry);
+
+
+--
+-- Name: mrr:ut_metaller_industrimineral_forfallna_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "mrr:ut_metaller_industrimineral_forfallna_wkb_geometry_geom_idx" ON postgis."mrr:ut_metaller_industrimineral_forfallna" USING gist (wkb_geometry);
+
+
+--
+-- Name: mrr:ut_olja_gas_diamant_forfallna_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "mrr:ut_olja_gas_diamant_forfallna_wkb_geometry_geom_idx" ON postgis."mrr:ut_olja_gas_diamant_forfallna" USING gist (wkb_geometry);
 
 
 --
@@ -4515,115 +4952,185 @@ GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_ogc_fid_seq TO webmap_guest;
 
 
 --
--- Name: TABLE "mrr:bearbetningskoncessioner_applied"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:bearbetningskoncessioner_ansokta"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_ansokta" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "mrr:bearbetningskoncessioner_beviljade"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_beviljade" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "mrr:bearbetningskoncessioner_forfallna"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_forfallna" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "mrr:markanvisningar_bk_ansokta"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."mrr:markanvisningar_bk_ansokta" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "mrr:markanvisningar_bk_ansokta_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "mrr:markanvisningar_bk_beviljade"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."mrr:markanvisningar_bk_beviljade" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "mrr:markanvisningar_bk_beviljade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "mrr:ut_diamant_ansokta"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_applied" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."mrr:ut_diamant_ansokta" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "mrr:bearbetningskoncessioner_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "mrr:ut_diamant_ansokta_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" TO webmap_guest;
 
 
 --
--- Name: TABLE "mrr:bearbetningskoncessioner_approved"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_diamant_beviljade"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_approved" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."mrr:ut_diamant_beviljade" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "mrr:bearbetningskoncessioner_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "mrr:ut_diamant_beviljade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" TO webmap_guest;
 
 
 --
--- Name: TABLE "mrr:markanvisningar"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_diamant_forbud"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."mrr:markanvisningar" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."mrr:ut_diamant_forbud" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "mrr:markanvisningar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "mrr:ut_diamant_forbud_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" TO webmap_guest;
 
 
 --
--- Name: TABLE "mrr:mineral_applied"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_metaller_industrimineral_ansokta"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."mrr:mineral_applied" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "mrr:mineral_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" TO webmap_guest;
 
 
 --
--- Name: TABLE "mrr:mineral_approved"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_metaller_industrimineral_beviljade"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."mrr:mineral_approved" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "mrr:mineral_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" TO webmap_guest;
 
 
 --
--- Name: TABLE "mrr:olja_gas_diamant_applied"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_metaller_industrimineral_forbud"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_applied" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."mrr:ut_metaller_industrimineral_forbud" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "mrr:olja_gas_diamant_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" TO webmap_guest;
 
 
 --
--- Name: TABLE "mrr:olja_gas_diamant_approved"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_metaller_industrimineral_forfallna"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_approved" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "mrr:olja_gas_diamant_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" TO webmap_guest;
 
 
 --
--- Name: TABLE "mrr:torvkoncessioner"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "mrr:ut_olja_gas_diamant_forfallna"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."mrr:torvkoncessioner" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "mrr:torvkoncessioner_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" TO webmap_guest;
 
 
 --
-- 
cgit v1.2.3

