--
-- PostgreSQL database dump
--

-- Dumped from database version 15.13 (Debian 15.13-0+deb12u1)
-- Dumped by pg_dump version 15.13 (Debian 15.13-0+deb12u1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

DROP DATABASE webmap;
--
-- Name: webmap; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE webmap WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = icu LOCALE = 'sv_SE.UTF-8' ICU_LOCALE = 'sv-SE-x-icu';


ALTER DATABASE webmap OWNER TO postgres;

\connect webmap

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: DATABASE webmap; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON DATABASE webmap IS 'Backend PostGIS database for KlimatanalysNorr tooling';


--
-- Name: postgis; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA postgis;


ALTER SCHEMA postgis OWNER TO postgres;

--
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA postgis;


--
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgis IS 'Geographic objects support for PostgreSQL';


--
-- Name: get_counties(postgis.geometry); Type: FUNCTION; Schema: postgis; Owner: postgres
--

CREATE FUNCTION postgis.get_counties(postgis.geometry) RETURNS smallint[]
    LANGUAGE sql IMMUTABLE STRICT PARALLEL SAFE
    AS $_$
    SELECT array_agg(DISTINCT t.lanskod ORDER BY t.lanskod)
      FROM postgis.lansyta_sub t
      -- Make use of spactial indices: filter out non-overlapping envelopes first.
      -- This function works for curves and points too, as the interior of a curve
      -- is the set of points between its endpoints, and the interior of a point is
      -- the point itself.  It also works for 3D input geometries (in that case the
      -- Z component is dropped).
      -- TODO we might want to check '*T*******' too (so a line exactly on a
      -- boundary segment would belong to both counties)
      WHERE t.wkb_geometry && $1 AND ST_Relate(t.wkb_geometry, $1, 'T********')
  $_$;


ALTER FUNCTION postgis.get_counties(postgis.geometry) OWNER TO postgres;

--
-- Name: get_municipalities(postgis.geometry); Type: FUNCTION; Schema: postgis; Owner: postgres
--

CREATE FUNCTION postgis.get_municipalities(postgis.geometry) RETURNS smallint[]
    LANGUAGE sql IMMUTABLE STRICT PARALLEL SAFE
    AS $_$
    SELECT array_agg(DISTINCT t.kommunkod ORDER BY t.kommunkod)
      FROM postgis.kommunyta_sub t
      -- Make use of spactial indices: filter out non-overlapping envelopes first.
      -- This function works for curves and points too, as the interior of a curve
      -- is the set of points between its endpoints, and the interior of a point is
      -- the point itself.  It also works for 3D input geometries (in that case the
      -- Z component is dropped).
      -- TODO we might want to check '*T*******' too (so a line exactly on a
      -- boundary segment would belong to both municipalities)
      WHERE t.wkb_geometry && $1 AND ST_Relate(t.wkb_geometry, $1, 'T********')
  $_$;


ALTER FUNCTION postgis.get_municipalities(postgis.geometry) OWNER TO postgres;

--
-- Name: kommunyta_subdivide_func(); Type: FUNCTION; Schema: postgis; Owner: webmap_import
--

CREATE FUNCTION postgis.kommunyta_subdivide_func() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    BEGIN
      -- Propagate changes to postgis.kommunyta to postgis.kommunyta_sub
      IF (TG_OP = 'DELETE' OR TG_OP = 'UPDATE') THEN
        DELETE FROM postgis.kommunyta_sub WHERE kommunkod = OLD.kommunkod;
      END IF;
      IF (TG_OP = 'UPDATE' OR TG_OP = 'INSERT') THEN
        INSERT INTO postgis.kommunyta_sub(kommunkod, wkb_geometry) VALUES
          (NEW.kommunkod, postgis.ST_Subdivide(NEW.wkb_geometry, 10));
      END IF;
      RETURN NULL;
    END;
  $$;


ALTER FUNCTION postgis.kommunyta_subdivide_func() OWNER TO webmap_import;

--
-- Name: lansyta_subdivide_func(); Type: FUNCTION; Schema: postgis; Owner: webmap_import
--

CREATE FUNCTION postgis.lansyta_subdivide_func() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
    BEGIN
      -- Propagate changes to postgis.lansyta to postgis.lansyta_sub
      IF (TG_OP = 'DELETE' OR TG_OP = 'UPDATE') THEN
        DELETE FROM postgis.lansyta_sub WHERE lanskod = OLD.lanskod;
      END IF;
      IF (TG_OP = 'UPDATE' OR TG_OP = 'INSERT') THEN
        INSERT INTO postgis.lansyta_sub(lanskod, wkb_geometry) VALUES
          (NEW.lanskod, postgis.ST_Subdivide(NEW.wkb_geometry, 10));
      END IF;
      RETURN NULL;
    END;
  $$;


ALTER FUNCTION postgis.lansyta_subdivide_func() OWNER TO webmap_import;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: dammar; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis.dammar (
    ogc_fid bigint NOT NULL,
    "DammID" uuid NOT NULL,
    "LST_OBJID" character varying(32),
    "Datum" date NOT NULL,
    "DNamn" character varying(64),
    "Status" smallint NOT NULL,
    "Regleringstyp" smallint NOT NULL,
    "Konstruktion" smallint NOT NULL,
    "ByggAr" smallint,
    "DammHojd" real,
    "KronLangd" real,
    "Fiskvag" smallint NOT NULL,
    "FiskvagByggAr" smallint,
    "Fiskavledare" smallint,
    "Vandringshinder" boolean NOT NULL,
    "HARO" integer NOT NULL,
    "Vattendistrikt" character varying(10) NOT NULL,
    inrapp_lst character varying(32) NOT NULL,
    eu_cd character varying(32),
    vf_typ character varying(1),
    vy_eucd character varying(32),
    vy_vf_typ character varying(1),
    "DammanlID" character varying(64),
    "Namn" character varying(64),
    "Verksamhet" smallint,
    "OmbyggAr" smallint,
    "DG" real,
    "SG" real,
    "HojdSys" smallint,
    "MY" double precision,
    "RV" double precision,
    "Kommentar" character varying(254),
    "XX_Distance" double precision,
    wkb_geometry postgis.geometry(Point,3006) NOT NULL
);


ALTER TABLE postgis.dammar OWNER TO webmap_import;

--
-- Name: TABLE dammar; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis.dammar IS 'Dammar';


--
-- Name: dammar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis.dammar_ogc_fid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis.dammar_ogc_fid_seq OWNER TO webmap_import;

--
-- Name: dammar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis.dammar_ogc_fid_seq OWNED BY postgis.dammar.ogc_fid;


--
-- Name: gigafactories; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis.gigafactories (
    ogc_fid bigint NOT NULL,
    "Name" character varying(254),
    "Url" character varying(254),
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis.gigafactories OWNER TO webmap_import;

--
-- Name: TABLE gigafactories; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis.gigafactories IS 'Stora industrisatsningar';


--
-- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis.gigafactories_ogc_fid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import;

--
-- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis.gigafactories_ogc_fid_seq OWNED BY postgis.gigafactories.ogc_fid;


--
-- Name: kommunyta; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis.kommunyta (
    ogc_fid bigint NOT NULL,
    objektidentitet uuid,
    skapad timestamp without time zone,
    kommunkod smallint NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis.kommunyta OWNER TO webmap_import;

--
-- Name: TABLE kommunyta; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis.kommunyta IS 'Sveriges kommuner (Lantmäteriet)';


--
-- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis.kommunyta_ogc_fid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis.kommunyta_ogc_fid_seq OWNER TO webmap_import;

--
-- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis.kommunyta_ogc_fid_seq OWNED BY postgis.kommunyta.ogc_fid;


--
-- Name: kommunyta_sub; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis.kommunyta_sub (
    ogc_fid bigint NOT NULL,
    kommunkod smallint NOT NULL,
    wkb_geometry postgis.geometry(Polygon,3006) NOT NULL
);


ALTER TABLE postgis.kommunyta_sub OWNER TO webmap_import;

--
-- Name: kommunyta_sub_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis.kommunyta_sub_ogc_fid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis.kommunyta_sub_ogc_fid_seq OWNER TO webmap_import;

--
-- Name: kommunyta_sub_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis.kommunyta_sub_ogc_fid_seq OWNED BY postgis.kommunyta_sub.ogc_fid;


--
-- Name: lansyta; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis.lansyta (
    ogc_fid bigint NOT NULL,
    objektidentitet uuid,
    skapad timestamp without time zone,
    lanskod smallint NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis.lansyta OWNER TO webmap_import;

--
-- Name: TABLE lansyta; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis.lansyta IS 'Sveriges län (Lantmäteriet)';


--
-- Name: lansyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis.lansyta_ogc_fid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import;

--
-- Name: lansyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis.lansyta_ogc_fid_seq OWNED BY postgis.lansyta.ogc_fid;


--
-- Name: lansyta_sub; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis.lansyta_sub (
    ogc_fid bigint NOT NULL,
    lanskod smallint NOT NULL,
    wkb_geometry postgis.geometry(Polygon,3006) NOT NULL
);


ALTER TABLE postgis.lansyta_sub OWNER TO webmap_import;

--
-- Name: lansyta_sub_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis.lansyta_sub_ogc_fid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis.lansyta_sub_ogc_fid_seq OWNER TO webmap_import;

--
-- Name: lansyta_sub_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis.lansyta_sub_ogc_fid_seq OWNED BY postgis.lansyta_sub.ogc_fid;


--
-- Name: mrr:bearbetningskoncessioner_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."mrr:bearbetningskoncessioner_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,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."mrr:bearbetningskoncessioner_ansokta" OWNER TO webmap_import;

--
-- Name: TABLE "mrr:bearbetningskoncessioner_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_ansokta" IS 'Bearbetningskoncessioner, ansökta (SGU)';


--
-- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_ansokta".ogc_fid;


--
-- Name: mrr:bearbetningskoncessioner_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."mrr:bearbetningskoncessioner_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,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."mrr:bearbetningskoncessioner_beviljade" OWNER TO webmap_import;

--
-- Name: TABLE "mrr:bearbetningskoncessioner_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_beviljade" IS 'Bearbetningskoncessioner, beviljade (SGU)';


--
-- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_beviljade".ogc_fid;


--
-- Name: mrr:bearbetningskoncessioner_forfallna; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."mrr:bearbetningskoncessioner_forfallna" (
    ogc_fid bigint 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,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."mrr:bearbetningskoncessioner_forfallna" OWNER TO webmap_import;

--
-- Name: TABLE "mrr:bearbetningskoncessioner_forfallna"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_forfallna" IS 'Bearbetningskoncessioner, förfallna (SGU)';


--
-- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_forfallna".ogc_fid;


--
-- Name: mrr:markanvisningar_bk_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."mrr:markanvisningar_bk_ansokta" (
    ogc_fid bigint 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,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."mrr:markanvisningar_bk_ansokta" OWNER TO webmap_import;

--
-- Name: TABLE "mrr:markanvisningar_bk_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."mrr:markanvisningar_bk_ansokta" IS 'Markanvisningar till bearbetningskoncessioner, ansökta (SGU)';


--
-- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:markanvisningar_bk_ansokta".ogc_fid;


--
-- Name: mrr:markanvisningar_bk_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."mrr:markanvisningar_bk_beviljade" (
    ogc_fid bigint 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,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."mrr:markanvisningar_bk_beviljade" OWNER TO webmap_import;

--
-- Name: TABLE "mrr:markanvisningar_bk_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."mrr:markanvisningar_bk_beviljade" IS 'Markanvisningar till bearbetningskoncessioner, beviljade (SGU)';


--
-- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:markanvisningar_bk_beviljade".ogc_fid;


--
-- Name: mrr:ut_diamant_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."mrr:ut_diamant_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,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."mrr:ut_diamant_ansokta" OWNER TO webmap_import;

--
-- Name: TABLE "mrr:ut_diamant_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."mrr:ut_diamant_ansokta" IS 'Undersökningstillstånd - Diamant, ansökta (SGU)';


--
-- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:ut_diamant_ansokta".ogc_fid;


--
-- Name: mrr:ut_diamant_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."mrr:ut_diamant_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,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."mrr:ut_diamant_beviljade" OWNER TO webmap_import;

--
-- Name: TABLE "mrr:ut_diamant_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."mrr:ut_diamant_beviljade" IS 'Undersökningstillstånd - Diamant, beviljade (SGU)';


--
-- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:ut_diamant_beviljade".ogc_fid;


--
-- Name: mrr:ut_diamant_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."mrr:ut_diamant_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,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."mrr:ut_diamant_forbud" OWNER TO webmap_import;

--
-- Name: TABLE "mrr:ut_diamant_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."mrr:ut_diamant_forbud" IS 'Undersökningstillstånd - Diamant, förbud (SGU)';


--
-- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

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,
    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,
    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,
    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,
    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,
    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;


--
-- Name: nvk:naturvardsavtal; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvk:naturvardsavtal" (
    ogc_fid bigint NOT NULL,
    "ID" integer NOT NULL,
    "DIARIENRNV" character varying(12) NOT NULL,
    "STATUS" character varying(32) NOT NULL,
    "OBJNAMN" character varying(64),
    "FASTBET" character varying(64),
    "DATSTART" date NOT NULL,
    "DATSLUT" date NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvk:naturvardsavtal" OWNER TO webmap_import;

--
-- Name: TABLE "nvk:naturvardsavtal"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvk:naturvardsavtal" IS 'Naturvårdsavtal (Naturvårdsverket, Länsstyrelse)';


--
-- Name: nvk:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvk:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNED BY postgis."nvk:naturvardsavtal".ogc_fid;


--
-- Name: nvr:Biosfarsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Biosfarsomraden" (
    ogc_fid bigint NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "NAMN" character varying(32) NOT NULL,
    "LINK" character varying(254) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Biosfarsomraden" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Biosfarsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Biosfarsomraden" IS 'Biosfärsområden (UNESCO)';


--
-- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNED BY postgis."nvr:Biosfarsomraden".ogc_fid;


--
-- Name: nvr:Biotopskydd; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Biotopskydd" (
    ogc_fid bigint NOT NULL,
    "Uuid" uuid NOT NULL,
    "Beteckn" character varying(12) NOT NULL,
    "ArendeAr" smallint NOT NULL,
    "Biotyp" character varying(254) NOT NULL,
    "Naturtyp" character varying(254),
    "AreaTot" double precision,
    "AreaProd" double precision,
    "Standort" character varying(254),
    "Datbeslut" date,
    "Url" character varying(254),
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Biotopskydd" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Biotopskydd"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Biotopskydd" IS 'Biotopskydd i skogsmark (beslutade av Skogsstyrelsen)';


--
-- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNED BY postgis."nvr:Biotopskydd".ogc_fid;


--
-- Name: nvr:Djur_och_vaxtskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(254) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(62) NOT NULL,
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Djur_och_vaxtskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" IS 'Djur- och växtskyddsområden';


--
-- Name: nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Djur_och_vaxtskyddsomrade".ogc_fid;


--
-- Name: nvr:HELCOM; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:HELCOM" (
    ogc_fid bigint NOT NULL,
    "BSPA_ID" integer NOT NULL,
    "NAME" character varying(62) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL
);


ALTER TABLE postgis."nvr:HELCOM" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:HELCOM"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:HELCOM" IS 'Marina skyddade områden (Helcom MPA)';


--
-- Name: nvr:HELCOM_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:HELCOM_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:HELCOM_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" OWNED BY postgis."nvr:HELCOM".ogc_fid;


--
-- Name: nvr:Interimistiskt_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Interimistiskt_forbud" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(62) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62),
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(16) NOT NULL,
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Interimistiskt_forbud" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Interimistiskt_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Interimistiskt_forbud" IS 'Interimistiska förbud';


--
-- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNED BY postgis."nvr:Interimistiskt_forbud".ogc_fid;


--
-- Name: nvr:Kultureservat; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Kultureservat" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(62) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(16) NOT NULL,
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Kultureservat" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Kultureservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Kultureservat" IS 'Kulturreservat';


--
-- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Kultureservat_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" OWNED BY postgis."nvr:Kultureservat".ogc_fid;


--
-- Name: nvr:Landskapsbildsskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Landskapsbildsskyddsomrade" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(62) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(16),
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Landskapsbildsskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" IS 'Landskapsbildsskyddsområden';


--
-- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Landskapsbildsskyddsomrade".ogc_fid;


--
-- Name: nvr:Nationalpark; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Nationalpark" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(62) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(16) NOT NULL,
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Nationalpark" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Nationalpark"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Nationalpark" IS 'Nationalparker';


--
-- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Nationalpark_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" OWNED BY postgis."nvr:Nationalpark".ogc_fid;


--
-- Name: nvr:Naturminne_punkt; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Naturminne_punkt" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(62) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62) NOT NULL,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(64) NOT NULL,
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPoint,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Naturminne_punkt" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Naturminne_punkt"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt';


--
-- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_punkt".ogc_fid;


--
-- Name: nvr:Naturminne_yta; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Naturminne_yta" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(62) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(64) NOT NULL,
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Naturminne_yta" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Naturminne_yta"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Naturminne_yta" IS 'Naturminne, yta';


--
-- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_yta".ogc_fid;


--
-- Name: nvr:Naturreservat; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Naturreservat" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(128) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(16),
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Naturreservat" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Naturreservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Naturreservat" IS 'Naturreservat';


--
-- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Naturreservat_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" OWNED BY postgis."nvr:Naturreservat".ogc_fid;


--
-- Name: nvr:Naturvardsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Naturvardsomrade" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(64) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(16) NOT NULL,
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Naturvardsomrade" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Naturvardsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Naturvardsomrade" IS 'Naturvårdsområden';


--
-- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Naturvardsomrade".ogc_fid;


--
-- Name: nvr:OSPAR; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:OSPAR" (
    ogc_fid bigint NOT NULL,
    "ORIGIN" character varying(10) NOT NULL,
    "NAMN_N2000" character varying(64) NOT NULL,
    "MPA_ID" character varying(16) NOT NULL,
    "MPA_NAMN" character varying(64) NOT NULL,
    "N2000_SITE" character varying(16) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL
);


ALTER TABLE postgis."nvr:OSPAR" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:OSPAR"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:OSPAR" IS 'Marina skyddade områden (Ospar MPA)';


--
-- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:OSPAR_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" OWNED BY postgis."nvr:OSPAR".ogc_fid;


--
-- Name: nvr:Ovrigt_biotopskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(62) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "IUCNKAT" character varying(254) NOT NULL,
    "FORVALTARE" character varying(62) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(16) NOT NULL,
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Ovrigt_biotopskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" IS 'Biotopskydd utanför skogsmark';


--
-- Name: nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Ovrigt_biotopskyddsomrade".ogc_fid;


--
-- Name: nvr:Ramsar; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Ramsar" (
    ogc_fid bigint NOT NULL,
    "RAMSAR_ID" integer NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "NATION" character varying(32) NOT NULL,
    "NAMN" character varying(32) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "LINK" character varying(254) NOT NULL,
    "URSPR_BESL" date NOT NULL,
    "SEN_BESLUT" date,
    "LEGAL_ACT" character varying(254) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Ramsar" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Ramsar"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Ramsar" IS 'Ramsar-områden (Våtmarkskonventionen)';


--
-- Name: nvr:Ramsar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Ramsar_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Ramsar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq" OWNED BY postgis."nvr:Ramsar".ogc_fid;


--
-- Name: nvr:SCI_Rikstackande; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:SCI_Rikstackande" (
    ogc_fid bigint NOT NULL,
    "NAMN" character varying(62) NOT NULL,
    "BEVPLAN" character varying(128) NOT NULL,
    "SITE_CODE" character varying(9) NOT NULL,
    "OMRADESTYP" character varying(16) NOT NULL,
    "UPPLAMNARE" character varying(62) NOT NULL,
    "SCI_FORSL" character varying(6) NOT NULL,
    "SCI_DATUM" character varying(6),
    "SAC_DATUM" character varying(6),
    "SPA_DATUM" character varying(6),
    "KVALITET" character varying(254) NOT NULL,
    "KARAKTAR" character varying(254) NOT NULL,
    "ARTER" character varying(254),
    "NATURTYPER" character varying(254),
    wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL
);


ALTER TABLE postgis."nvr:SCI_Rikstackande" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:SCI_Rikstackande"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:SCI_Rikstackande" IS 'Habitatdirektivet (SCI, direktiv 92/43/EEG)';


--
-- Name: nvr:SCI_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:SCI_Rikstackande_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" OWNED BY postgis."nvr:SCI_Rikstackande".ogc_fid;


--
-- Name: nvr:SPA_Rikstackande; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:SPA_Rikstackande" (
    ogc_fid bigint NOT NULL,
    "NAMN" character varying(62) NOT NULL,
    "BEVPLAN" character varying(128) NOT NULL,
    "SITE_CODE" character varying(9) NOT NULL,
    "OMRADESTYP" character varying(16) NOT NULL,
    "UPPLAMNARE" character varying(62) NOT NULL,
    "SCI_FORSL" character varying(6),
    "SCI_DATUM" character varying(6),
    "SAC_DATUM" character varying(6),
    "SPA_DATUM" character varying(6) NOT NULL,
    "KVALITET" character varying(254) NOT NULL,
    "KARAKTAR" character varying(254) NOT NULL,
    "ARTER" character varying(254) NOT NULL,
    "NATURTYPER" character varying(254),
    wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL
);


ALTER TABLE postgis."nvr:SPA_Rikstackande" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:SPA_Rikstackande"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:SPA_Rikstackande" IS 'Fågeldirektivet (SPA, direktiv 79/409/EEG)';


--
-- Name: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNED BY postgis."nvr:SPA_Rikstackande".ogc_fid;


--
-- Name: nvr:Tilltradesforbud; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Tilltradesforbud" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "BESLSTAT" character varying(12) NOT NULL,
    "FORESKRTYP" character varying(16) NOT NULL,
    "FORESKRIFT" character varying(62) NOT NULL,
    "FRANDATUM" character varying(10) NOT NULL,
    "TILLDATUM" character varying(10) NOT NULL,
    "BESKRIVN" character varying(254),
    "OBJEKTNAMN" character varying(254) NOT NULL,
    "FORSKRNAMN" character varying(254),
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Tilltradesforbud" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Tilltradesforbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Tilltradesforbud" IS 'Områden med föreskrifter som inskränker rätten att färdas eller vistas i området, permanent eller under en del av året';


--
-- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNED BY postgis."nvr:Tilltradesforbud".ogc_fid;


--
-- Name: nvr:Varldsarv; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Varldsarv" (
    ogc_fid bigint NOT NULL,
    "NAMN" character varying(64) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Varldsarv" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Varldsarv"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Varldsarv" IS 'Världsarv med mycket höga naturvärden (UNESCO)';


--
-- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Varldsarv_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" OWNED BY postgis."nvr:Varldsarv".ogc_fid;


--
-- Name: nvr:Vattenskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."nvr:Vattenskyddsomrade" (
    ogc_fid bigint NOT NULL,
    "NVRID" integer NOT NULL,
    "NAMN" character varying(254) NOT NULL,
    "SKYDDSTYP" character varying(32) NOT NULL,
    "BESLSTATUS" character varying(12) NOT NULL,
    "URSBESLDAT" date NOT NULL,
    "IKRAFTDATF" date,
    "URSGALLDAT" date,
    "SENGALLDAT" date,
    "TILLSYNSMH" character varying(64) NOT NULL,
    "PROVNMHDIS" character varying(64),
    "PROVNMHTIL" character varying(64),
    "IUCNKAT" character varying(254) NOT NULL,
    "LAND_HA" double precision,
    "VATTEN_HA" double precision,
    "SKOG_HA" double precision,
    "GEOSTATUS" character varying(62) NOT NULL,
    "DIARIENR" character varying(62),
    "LAGRUM" character varying(16),
    "BESLMYND" character varying(32) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."nvr:Vattenskyddsomrade" OWNER TO webmap_import;

--
-- Name: TABLE "nvr:Vattenskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."nvr:Vattenskyddsomrade" IS 'Vattenskyddsområden';


--
-- Name: nvr:Vattenskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: nvr:Vattenskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Vattenskyddsomrade".ogc_fid;


--
-- Name: ren:omr_riks; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."ren:omr_riks" (
    ogc_fid bigint 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) NOT NULL
);


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,
    "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) NOT NULL
);


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: 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 varying(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) NOT NULL
);


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) NOT NULL
);


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) NOT NULL
);


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) NOT NULL
);


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) NOT NULL
);


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) NOT NULL
);


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
--

CREATE TABLE postgis."sametinget:betesomraden" (
    ogc_fid bigint 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) NOT NULL
);


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:flyttled; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."sametinget:flyttled" (
    ogc_fid bigint 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) NOT NULL
);


ALTER TABLE postgis."sametinget:flyttled" OWNER TO webmap_import;

--
-- Name: TABLE "sametinget:flyttled"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."sametinget:flyttled" IS 'Samebyarnas markanvändningsredovisning: Flyttled';


--
-- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."sametinget:flyttled_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" OWNED BY postgis."sametinget:flyttled".ogc_fid;


--
-- Name: sks:atervatningsavtal; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."sks:atervatningsavtal" (
    ogc_fid bigint NOT NULL,
    "Uuid" uuid NOT NULL,
    "Beteckn" character varying(12) NOT NULL,
    "ArendeAr" smallint NOT NULL,
    "AvtalatDatum" date,
    "Url" character varying(252),
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."sks:atervatningsavtal" OWNER TO webmap_import;

--
-- Name: TABLE "sks:atervatningsavtal"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."sks:atervatningsavtal" IS 'Återvätningsavtal';


--
-- Name: sks:atervatningsavtal_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: sks:atervatningsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNED BY postgis."sks:atervatningsavtal".ogc_fid;


--
-- Name: sks:avverk_anmald; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."sks:avverk_anmald" (
    ogc_fid bigint NOT NULL,
    "OBJECTID" integer NOT NULL,
    "Beteckn" character varying(12) NOT NULL,
    "ArendeAr" smallint NOT NULL,
    "Inkomdatum" date NOT NULL,
    "AnmaldHa" real NOT NULL,
    "SkogsodlHa" real,
    "NatforHa" real,
    "AvvSasong" character varying(254) NOT NULL,
    "ArendeStatus" character varying(254) NOT NULL,
    "AvvHa" real,
    "AvverkningsanmalanKlass" character varying(254) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."sks:avverk_anmald" OWNER TO webmap_import;

--
-- Name: TABLE "sks:avverk_anmald"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."sks:avverk_anmald" IS 'Avverkningsanmälningar (Skogsstyrelsen)';


--
-- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."sks:avverk_anmald_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" OWNED BY postgis."sks:avverk_anmald".ogc_fid;


--
-- Name: sks:avverk_utford; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."sks:avverk_utford" (
    ogc_fid bigint NOT NULL,
    "OBJECTID" integer NOT NULL,
    "Beteckn" character varying(12),
    "ArendeAr" smallint NOT NULL,
    "Avverktyp" character varying(254) NOT NULL,
    "Skogstyp" character varying(254) NOT NULL,
    "AnmaldHa" real NOT NULL,
    "NatforHa" real,
    "Avvdatum" date,
    "KallaDatum" character varying(62),
    "Forebild" character varying(62),
    "Efterbild" character varying(62),
    "ArealHa" real NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."sks:avverk_utford" OWNER TO webmap_import;

--
-- Name: TABLE "sks:avverk_utford"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."sks:avverk_utford" IS 'Utförd avverkning (Skogsstyrelsen)';


--
-- Name: sks:avverk_utford_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."sks:avverk_utford_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: sks:avverk_utford_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" OWNED BY postgis."sks:avverk_utford".ogc_fid;


--
-- Name: sks:naturvarde; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."sks:naturvarde" (
    ogc_fid bigint NOT NULL,
    "ObjectId" integer NOT NULL,
    "Beteckn" character varying(12) NOT NULL,
    "Objnamn" character varying(62),
    "Datinv" date NOT NULL,
    "Biotop1" character varying(62),
    "Biotop2" character varying(62),
    "Biotop3" character varying(62),
    "Beskrivn1" character varying(62),
    "Beskrivn2" character varying(62),
    "Beskrivn3" character varying(62),
    "Url" character varying(254) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."sks:naturvarde" OWNER TO webmap_import;

--
-- Name: TABLE "sks:naturvarde"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."sks:naturvarde" IS 'Objekt med naturvärden - Skogsstyrelsen';


--
-- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."sks:naturvarde_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."sks:naturvarde_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" OWNED BY postgis."sks:naturvarde".ogc_fid;


--
-- Name: sks:naturvardsavtal; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."sks:naturvardsavtal" (
    ogc_fid bigint NOT NULL,
    "Uuid" uuid NOT NULL,
    "Beteckn" character varying(12) NOT NULL,
    "ArendeAr" smallint NOT NULL,
    "NvaTyp" character varying(254),
    "Naturtyp" character varying(254),
    "AreaTot" double precision NOT NULL,
    "AreaProd" double precision NOT NULL,
    "Standort" character varying(254),
    "DatAvtal" date,
    "Url" character varying(254) NOT NULL,
    "Undertyp" character varying(64),
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."sks:naturvardsavtal" OWNER TO webmap_import;

--
-- Name: TABLE "sks:naturvardsavtal"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."sks:naturvardsavtal" IS 'Naturvårdsavtal (Skogsstyrelsen)';


--
-- Name: sks:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: sks:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNED BY postgis."sks:naturvardsavtal".ogc_fid;


--
-- Name: sks:nyckelbiotop; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."sks:nyckelbiotop" (
    ogc_fid bigint NOT NULL,
    "Beteckn" character varying(12) NOT NULL,
    "Objnamn" character varying(62),
    "Datinv" date NOT NULL,
    "Biotop1" character varying(62),
    "Biotop2" character varying(62),
    "Biotop3" character varying(62),
    "Beskrivn1" character varying(62),
    "Beskrivn2" character varying(62),
    "Beskrivn3" character varying(62),
    "Beskrivn4" character varying(62),
    "Beskrivn5" character varying(62),
    "Beskrivn6" character varying(62),
    "Beskrivn7" character varying(62),
    "Beskrivn8" character varying(62),
    "Url" character varying(254) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."sks:nyckelbiotop" OWNER TO webmap_import;

--
-- Name: TABLE "sks:nyckelbiotop"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."sks:nyckelbiotop" IS 'Nyckelbiotoper - Skogsstyrelsen';


--
-- Name: sks:nyckelbiotop_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: sks:nyckelbiotop_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNED BY postgis."sks:nyckelbiotop".ogc_fid;


--
-- Name: sks:nyckelbiotop_storskogsbruk; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."sks:nyckelbiotop_storskogsbruk" (
    ogc_fid bigint NOT NULL,
    objectid integer NOT NULL,
    "Org" character varying(62) NOT NULL,
    "InkomDatum" date NOT NULL,
    "Url" character varying(254) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."sks:nyckelbiotop_storskogsbruk" OWNER TO webmap_import;

--
-- Name: TABLE "sks:nyckelbiotop_storskogsbruk"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."sks:nyckelbiotop_storskogsbruk" IS 'Nyckelbiotoper - storskogsbruket';


--
-- Name: sks:nyckelbiotop_storskogsbruk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: sks:nyckelbiotop_storskogsbruk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNED BY postgis."sks:nyckelbiotop_storskogsbruk".ogc_fid;


--
-- Name: sks:sumpskog; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."sks:sumpskog" (
    ogc_fid bigint NOT NULL,
    "OBJECTID" integer NOT NULL,
    "Namn" character varying(62),
    "Hydrtext" character varying(62),
    "Tradtext" character varying(62) NOT NULL,
    "Delklass" character varying(62),
    "Klassu" character varying(62),
    "Lovandel" character varying(62),
    "Krontakn" character varying(62),
    "Huggklas" character varying(62),
    "Andelva" character varying(62),
    "Ingrepp" character varying(62),
    "Ingrpavv" character varying(62),
    "Objnyck" character varying(62),
    "Delnyck" character varying(62),
    "Flygar" smallint,
    "Faltdat" date,
    "Invtekn" character varying(62) NOT NULL,
    "Invdat" date NOT NULL,
    "Ansvmynd" character varying(62) NOT NULL,
    "Url" character varying(252) NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."sks:sumpskog" OWNER TO webmap_import;

--
-- Name: TABLE "sks:sumpskog"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."sks:sumpskog" IS 'Sumpskogar';


--
-- Name: sks:sumpskog_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."sks:sumpskog_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."sks:sumpskog_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: sks:sumpskog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" OWNED BY postgis."sks:sumpskog".ogc_fid;


--
-- Name: svk:ledningar; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."svk:ledningar" (
    ogc_fid bigint NOT NULL,
    "Placement" character varying(32),
    "Voltage" integer,
    wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL
);


ALTER TABLE postgis."svk:ledningar" OWNER TO webmap_import;

--
-- Name: TABLE "svk:ledningar"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."svk:ledningar" IS 'Kraftledningar (befintliga)';


--
-- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."svk:ledningar_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."svk:ledningar_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."svk:ledningar_ogc_fid_seq" OWNED BY postgis."svk:ledningar".ogc_fid;


--
-- Name: svk:stationsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."svk:stationsomraden" (
    ogc_fid bigint NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL
);


ALTER TABLE postgis."svk:stationsomraden" OWNER TO webmap_import;

--
-- Name: TABLE "svk:stationsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."svk:stationsomraden" IS 'Stationsomraden';


--
-- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."svk:stationsomraden_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" OWNED BY postgis."svk:stationsomraden".ogc_fid;


--
-- Name: svk:stolpar; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."svk:stolpar" (
    ogc_fid bigint NOT NULL,
    wkb_geometry postgis.geometry(PointZ,3006) NOT NULL
);


ALTER TABLE postgis."svk:stolpar" OWNER TO webmap_import;

--
-- Name: TABLE "svk:stolpar"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."svk:stolpar" IS 'Stolpar (befintliga)';


--
-- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."svk:stolpar_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."svk:stolpar_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."svk:stolpar_ogc_fid_seq" OWNED BY postgis."svk:stolpar".ogc_fid;


--
-- Name: svk:transmissionsnatsprojekt; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."svk:transmissionsnatsprojekt" (
    ogc_fid bigint NOT NULL,
    "Name" character varying(254),
    "Voltage" integer,
    "Url" character varying(254),
    wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL
);


ALTER TABLE postgis."svk:transmissionsnatsprojekt" OWNER TO webmap_import;

--
-- Name: TABLE "svk:transmissionsnatsprojekt"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."svk:transmissionsnatsprojekt" IS 'Transmissionsnätsprojekt';


--
-- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNED BY postgis."svk:transmissionsnatsprojekt".ogc_fid;


--
-- Name: vbk:havsbaserad_vindkraft; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."vbk:havsbaserad_vindkraft" (
    ogc_fid bigint NOT NULL,
    "OmrID" character varying(10) NOT NULL,
    "Projektnamn" character varying(62),
    "Organisationsnamn" character varying(254),
    "Organisationsnummer" character varying(11),
    "Projektstatus" character varying(62) NOT NULL,
    "Diarienummer" character varying(254),
    "AndringsansokanPagar" boolean,
    "SamradsunderlagInlamnat" date,
    "AnsokanInlamnat" date,
    "AnsokanAterkallad" date,
    "AnsokanBeviljad" date,
    "AnsokanAvslagen" date,
    "AnsokanOverklagad" date,
    "Natura2000_Ansokan" character varying(62) NOT NULL,
    "Natura2000_Beslutdatum" date,
    "UnderByggnation" boolean,
    "Uppfort" date,
    "PlaneratAntalVerkMin" smallint,
    "PlaneratAntalVerkMax" smallint,
    "PlaneradHojdMin" smallint,
    "PlaneradHojdMax" smallint,
    "PlaneradProduktionMin" real,
    "PlaneradProduktionMax" real,
    "PlaneradByggstart" date,
    "PlaneratDrift" date,
    "BeviljatAntalVerk" smallint,
    "UppfortAntalVerk" smallint,
    "BeviljadMaxhojd" smallint,
    "InstalleradEffekt" real,
    "Calprod" real,
    "ElNamn" character varying(62) NOT NULL,
    "SenasteUppdaterat" date NOT NULL,
    "Raderat" boolean NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."vbk:havsbaserad_vindkraft" OWNER TO webmap_import;

--
-- Name: TABLE "vbk:havsbaserad_vindkraft"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."vbk:havsbaserad_vindkraft" IS 'Vindbrukskollen havsbaserad vindkraft (Länsstyrelsen)';


--
-- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNED BY postgis."vbk:havsbaserad_vindkraft".ogc_fid;


--
-- Name: vbk:projekteringsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."vbk:projekteringsomraden" (
    ogc_fid bigint NOT NULL,
    "OmrID" character varying(10) NOT NULL,
    "Projektnamn" character varying(62),
    "AntalVerk" smallint NOT NULL,
    "AntalEjXY" smallint NOT NULL,
    "Calprod" real,
    "PlaneradByggstart" date,
    "PlaneratDrift" date,
    "AndringsansokanPagar" boolean,
    "UnderByggnation" boolean,
    "Organisationsnamn" character varying(254),
    "Organisationsnummer" character varying(11),
    "ElNamn" character varying(62) NOT NULL,
    "SenasteUppdaterat" date,
    "EjAktuell" boolean NOT NULL,
    "Raderat" boolean NOT NULL,
    wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL
);


ALTER TABLE postgis."vbk:projekteringsomraden" OWNER TO webmap_import;

--
-- Name: TABLE "vbk:projekteringsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."vbk:projekteringsomraden" IS 'Vindbrukskollen landbaserade projekteringsområden (Länsstyrelsen)';


--
-- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNED BY postgis."vbk:projekteringsomraden".ogc_fid;


--
-- Name: vbk:vindkraftverk; Type: TABLE; Schema: postgis; Owner: webmap_import
--

CREATE TABLE postgis."vbk:vindkraftverk" (
    ogc_fid bigint NOT NULL,
    "VerkID" character varying(14) NOT NULL,
    "OmrID" character varying(10) NOT NULL,
    "Projektnamn" character varying(62),
    "Status" character varying(62) NOT NULL,
    "Statuskod" smallint NOT NULL,
    "Handlingstyp" character varying(62),
    "Uppfort" date,
    "MB_Tillstand" date,
    "Totalhojd" smallint,
    "Navhojd" smallint,
    "Rotordiameter" smallint,
    "Maxeffekt" real,
    "Calprod" real,
    "Fabrikat" character varying(62),
    "Modell" character varying(62),
    "Organisationsnamn" character varying(254),
    "Organisationsnummer" character varying(11),
    "Placering" character varying(62),
    "ElNamn" character varying(62) NOT NULL,
    "SenasteUppdaterat" date,
    "EjAktuell" boolean,
    "Raderat" boolean NOT NULL,
    wkb_geometry postgis.geometry(Point,3006) NOT NULL
);


ALTER TABLE postgis."vbk:vindkraftverk" OWNER TO webmap_import;

--
-- Name: TABLE "vbk:vindkraftverk"; Type: COMMENT; Schema: postgis; Owner: webmap_import
--

COMMENT ON TABLE postgis."vbk:vindkraftverk" IS 'Vindbrukskollen landbaserade vindkraftverk (Länsstyrelsen)';


--
-- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
--

CREATE SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNER TO webmap_import;

--
-- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
--

ALTER SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNED BY postgis."vbk:vindkraftverk".ogc_fid;


--
-- Name: layercache; Type: TABLE; Schema: public; Owner: webmap_import
--

CREATE TABLE public.layercache (
    ogc_fid bigint NOT NULL,
    layername character varying(255) NOT NULL,
    last_updated timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    fingerprint bytea NOT NULL
);


ALTER TABLE public.layercache OWNER TO webmap_import;

--
-- Name: TABLE layercache; Type: COMMENT; Schema: public; Owner: webmap_import
--

COMMENT ON TABLE public.layercache IS 'Layer metadata cache';


--
-- Name: layercache_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: webmap_import
--

CREATE SEQUENCE public.layercache_ogc_fid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.layercache_ogc_fid_seq OWNER TO webmap_import;

--
-- Name: layercache_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: webmap_import
--

ALTER SEQUENCE public.layercache_ogc_fid_seq OWNED BY public.layercache.ogc_fid;


--
-- Name: dammar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.dammar ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.dammar_ogc_fid_seq'::regclass);


--
-- Name: gigafactories ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.gigafactories ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.gigafactories_ogc_fid_seq'::regclass);


--
-- Name: kommunyta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.kommunyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.kommunyta_ogc_fid_seq'::regclass);


--
-- Name: kommunyta_sub ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.kommunyta_sub ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.kommunyta_sub_ogc_fid_seq'::regclass);


--
-- Name: lansyta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.lansyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.lansyta_ogc_fid_seq'::regclass);


--
-- Name: lansyta_sub ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.lansyta_sub ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.lansyta_sub_ogc_fid_seq'::regclass);


--
-- 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_forfallna" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq"'::regclass);


--
-- Name: mrr:markanvisningar_bk_ansokta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

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_bk_beviljade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

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:ut_diamant_ansokta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

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:ut_diamant_beviljade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

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:ut_diamant_forbud ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

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:ut_metaller_industrimineral_ansokta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

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:ut_metaller_industrimineral_beviljade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

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);


--
-- Name: nvk:naturvardsavtal ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvk:naturvardsavtal" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:naturvardsavtal_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Biosfarsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Biosfarsomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Biosfarsomraden_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Biotopskydd ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Biotopskydd" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Biotopskydd_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Djur_och_vaxtskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Djur_och_vaxtskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq"'::regclass);


--
-- Name: nvr:HELCOM ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:HELCOM" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:HELCOM_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Interimistiskt_forbud ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Interimistiskt_forbud" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Interimistiskt_forbud_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Kultureservat ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Kultureservat" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Kultureservat_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Landskapsbildsskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Landskapsbildsskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Nationalpark ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Nationalpark" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Nationalpark_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Naturminne_punkt ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_punkt_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Naturminne_yta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturminne_yta" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_yta_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Naturreservat ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturreservat" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturreservat_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Naturvardsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturvardsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturvardsomrade_ogc_fid_seq"'::regclass);


--
-- Name: nvr:OSPAR ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:OSPAR" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:OSPAR_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Ovrigt_biotopskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Ovrigt_biotopskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Ramsar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Ramsar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Ramsar_ogc_fid_seq"'::regclass);


--
-- Name: nvr:SCI_Rikstackande ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:SCI_Rikstackande" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:SCI_Rikstackande_ogc_fid_seq"'::regclass);


--
-- Name: nvr:SPA_Rikstackande ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:SPA_Rikstackande" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:SPA_Rikstackande_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Tilltradesforbud ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Tilltradesforbud" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Tilltradesforbud_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Varldsarv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Varldsarv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Varldsarv_ogc_fid_seq"'::regclass);


--
-- Name: nvr:Vattenskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Vattenskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Vattenskyddsomrade_ogc_fid_seq"'::regclass);


--
-- 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: 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
--

ALTER TABLE ONLY postgis."sametinget:betesomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:betesomraden_ogc_fid_seq"'::regclass);


--
-- Name: sametinget:flyttled ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sametinget:flyttled" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:flyttled_ogc_fid_seq"'::regclass);


--
-- Name: sks:atervatningsavtal ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:atervatningsavtal" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:atervatningsavtal_ogc_fid_seq"'::regclass);


--
-- Name: sks:avverk_anmald ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:avverk_anmald" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:avverk_anmald_ogc_fid_seq"'::regclass);


--
-- Name: sks:avverk_utford ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:avverk_utford" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:avverk_utford_ogc_fid_seq"'::regclass);


--
-- Name: sks:naturvarde ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:naturvarde" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:naturvarde_ogc_fid_seq"'::regclass);


--
-- Name: sks:naturvardsavtal ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:naturvardsavtal" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:naturvardsavtal_ogc_fid_seq"'::regclass);


--
-- Name: sks:nyckelbiotop ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:nyckelbiotop" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:nyckelbiotop_ogc_fid_seq"'::regclass);


--
-- Name: sks:nyckelbiotop_storskogsbruk ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:nyckelbiotop_storskogsbruk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq"'::regclass);


--
-- Name: sks:sumpskog ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:sumpskog" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:sumpskog_ogc_fid_seq"'::regclass);


--
-- Name: svk:ledningar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."svk:ledningar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:ledningar_ogc_fid_seq"'::regclass);


--
-- Name: svk:stationsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."svk:stationsomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:stationsomraden_ogc_fid_seq"'::regclass);


--
-- Name: svk:stolpar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."svk:stolpar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:stolpar_ogc_fid_seq"'::regclass);


--
-- Name: svk:transmissionsnatsprojekt ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."svk:transmissionsnatsprojekt" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:transmissionsnatsprojekt_ogc_fid_seq"'::regclass);


--
-- Name: vbk:havsbaserad_vindkraft ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."vbk:havsbaserad_vindkraft" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq"'::regclass);


--
-- Name: vbk:projekteringsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."vbk:projekteringsomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."vbk:projekteringsomraden_ogc_fid_seq"'::regclass);


--
-- Name: vbk:vindkraftverk ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."vbk:vindkraftverk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."vbk:vindkraftverk_ogc_fid_seq"'::regclass);


--
-- Name: layercache ogc_fid; Type: DEFAULT; Schema: public; Owner: webmap_import
--

ALTER TABLE ONLY public.layercache ALTER COLUMN ogc_fid SET DEFAULT nextval('public.layercache_ogc_fid_seq'::regclass);


--
-- Name: dammar dammar_DammID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.dammar
    ADD CONSTRAINT "dammar_DammID_key" UNIQUE ("DammID");


--
-- Name: dammar dammar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.dammar
    ADD CONSTRAINT dammar_pkey PRIMARY KEY (ogc_fid);


--
-- Name: gigafactories gigafactories_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.gigafactories
    ADD CONSTRAINT gigafactories_pkey PRIMARY KEY (ogc_fid);


--
-- Name: kommunyta kommunyta_kommunkod_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.kommunyta
    ADD CONSTRAINT kommunyta_kommunkod_key UNIQUE (kommunkod);


--
-- Name: kommunyta kommunyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.kommunyta
    ADD CONSTRAINT kommunyta_objektidentitet_key UNIQUE (objektidentitet);


--
-- Name: kommunyta kommunyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.kommunyta
    ADD CONSTRAINT kommunyta_pkey PRIMARY KEY (ogc_fid);


--
-- Name: lansyta lansyta_lanskod_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.lansyta
    ADD CONSTRAINT lansyta_lanskod_key UNIQUE (lanskod);


--
-- Name: lansyta lansyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.lansyta
    ADD CONSTRAINT lansyta_objektidentitet_key UNIQUE (objektidentitet);


--
-- Name: lansyta lansyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.lansyta
    ADD CONSTRAINT lansyta_pkey PRIMARY KEY (ogc_fid);


--
-- 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:ut_diamant_ansokta"
    ADD CONSTRAINT "mrr:ut_diamant_ansokta_diarynr_key" UNIQUE (diarynr);


--
-- Name: mrr:ut_diamant_ansokta mrr:ut_diamant_ansokta_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_diamant_ansokta"
    ADD CONSTRAINT "mrr:ut_diamant_ansokta_name_key" UNIQUE (name);


--
-- Name: mrr:ut_diamant_ansokta mrr:ut_diamant_ansokta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_diamant_ansokta"
    ADD CONSTRAINT "mrr:ut_diamant_ansokta_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: mrr:ut_diamant_beviljade mrr:ut_diamant_beviljade_diarynr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_diamant_beviljade"
    ADD CONSTRAINT "mrr:ut_diamant_beviljade_diarynr_key" UNIQUE (diarynr);


--
-- Name: mrr:ut_diamant_beviljade mrr:ut_diamant_beviljade_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_diamant_beviljade"
    ADD CONSTRAINT "mrr:ut_diamant_beviljade_licenceid_key" UNIQUE (licenceid);


--
-- Name: mrr:ut_diamant_beviljade mrr:ut_diamant_beviljade_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_diamant_beviljade"
    ADD CONSTRAINT "mrr:ut_diamant_beviljade_name_key" UNIQUE (name);


--
-- Name: mrr:ut_diamant_beviljade mrr:ut_diamant_beviljade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_diamant_beviljade"
    ADD CONSTRAINT "mrr:ut_diamant_beviljade_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: mrr:ut_diamant_forbud mrr:ut_diamant_forbud_licenceid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_diamant_forbud"
    ADD CONSTRAINT "mrr:ut_diamant_forbud_licenceid_key" UNIQUE (licenceid);


--
-- Name: mrr:ut_diamant_forbud mrr:ut_diamant_forbud_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_diamant_forbud"
    ADD CONSTRAINT "mrr:ut_diamant_forbud_name_key" UNIQUE (name);


--
-- Name: mrr:ut_diamant_forbud mrr:ut_diamant_forbud_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_diamant_forbud"
    ADD CONSTRAINT "mrr:ut_diamant_forbud_pkey" PRIMARY KEY (ogc_fid);


--
-- 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:ut_metaller_industrimineral_ansokta"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_ansokta_diarynr_key" UNIQUE (diarynr);


--
-- 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:ut_metaller_industrimineral_ansokta"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_ansokta_name_key" UNIQUE (name);


--
-- Name: mrr:ut_metaller_industrimineral_ansokta mrr:ut_metaller_industrimineral_ansokta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_ansokta"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_ansokta_pkey" PRIMARY KEY (ogc_fid);


--
-- 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:ut_metaller_industrimineral_beviljade"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_beviljade_diarynr_key" UNIQUE (diarynr);


--
-- 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:ut_metaller_industrimineral_beviljade"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_beviljade_licenceid_key" UNIQUE (licenceid);


--
-- 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:ut_metaller_industrimineral_beviljade"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_beviljade_name_key" UNIQUE (name);


--
-- Name: mrr:ut_metaller_industrimineral_beviljade mrr:ut_metaller_industrimineral_beviljade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_beviljade"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_beviljade_pkey" PRIMARY KEY (ogc_fid);


--
-- 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:ut_metaller_industrimineral_forbud"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forbud_licenceid_key" UNIQUE (licenceid);


--
-- 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:ut_metaller_industrimineral_forbud"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forbud_name_key" UNIQUE (name);


--
-- Name: mrr:ut_metaller_industrimineral_forbud mrr:ut_metaller_industrimineral_forbud_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_forbud"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forbud_pkey" PRIMARY KEY (ogc_fid);


--
-- 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:ut_metaller_industrimineral_forfallna"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forfallna_licenceid_key" UNIQUE (licenceid);


--
-- Name: mrr:ut_metaller_industrimineral_forfallna mrr:ut_metaller_industrimineral_forfallna_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_forfallna"
    ADD CONSTRAINT "mrr:ut_metaller_industrimineral_forfallna_pkey" PRIMARY KEY (ogc_fid);


--
-- 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: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);


--
-- Name: nvk:naturvardsavtal nvk:naturvardsavtal_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvk:naturvardsavtal"
    ADD CONSTRAINT "nvk:naturvardsavtal_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Biosfarsomraden nvr:Biosfarsomraden_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Biosfarsomraden"
    ADD CONSTRAINT "nvr:Biosfarsomraden_NAMN_key" UNIQUE ("NAMN");


--
-- Name: nvr:Biosfarsomraden nvr:Biosfarsomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Biosfarsomraden"
    ADD CONSTRAINT "nvr:Biosfarsomraden_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Biotopskydd nvr:Biotopskydd_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Biotopskydd"
    ADD CONSTRAINT "nvr:Biotopskydd_Beteckn_key" UNIQUE ("Beteckn");


--
-- Name: nvr:Biotopskydd nvr:Biotopskydd_Uuid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Biotopskydd"
    ADD CONSTRAINT "nvr:Biotopskydd_Uuid_key" UNIQUE ("Uuid");


--
-- Name: nvr:Biotopskydd nvr:Biotopskydd_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Biotopskydd"
    ADD CONSTRAINT "nvr:Biotopskydd_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Djur_och_vaxtskyddsomrade nvr:Djur_och_vaxtskyddsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Djur_och_vaxtskyddsomrade"
    ADD CONSTRAINT "nvr:Djur_och_vaxtskyddsomrade_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:HELCOM nvr:HELCOM_BSPA_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:HELCOM"
    ADD CONSTRAINT "nvr:HELCOM_BSPA_ID_key" UNIQUE ("BSPA_ID");


--
-- Name: nvr:HELCOM nvr:HELCOM_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:HELCOM"
    ADD CONSTRAINT "nvr:HELCOM_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Interimistiskt_forbud nvr:Interimistiskt_forbud_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Interimistiskt_forbud"
    ADD CONSTRAINT "nvr:Interimistiskt_forbud_NVRID_key" UNIQUE ("NVRID");


--
-- Name: nvr:Interimistiskt_forbud nvr:Interimistiskt_forbud_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Interimistiskt_forbud"
    ADD CONSTRAINT "nvr:Interimistiskt_forbud_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Kultureservat nvr:Kultureservat_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Kultureservat"
    ADD CONSTRAINT "nvr:Kultureservat_NVRID_key" UNIQUE ("NVRID");


--
-- Name: nvr:Kultureservat nvr:Kultureservat_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Kultureservat"
    ADD CONSTRAINT "nvr:Kultureservat_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Landskapsbildsskyddsomrade nvr:Landskapsbildsskyddsomrade_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Landskapsbildsskyddsomrade"
    ADD CONSTRAINT "nvr:Landskapsbildsskyddsomrade_NVRID_key" UNIQUE ("NVRID");


--
-- Name: nvr:Landskapsbildsskyddsomrade nvr:Landskapsbildsskyddsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Landskapsbildsskyddsomrade"
    ADD CONSTRAINT "nvr:Landskapsbildsskyddsomrade_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Nationalpark nvr:Nationalpark_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Nationalpark"
    ADD CONSTRAINT "nvr:Nationalpark_NVRID_key" UNIQUE ("NVRID");


--
-- Name: nvr:Nationalpark nvr:Nationalpark_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Nationalpark"
    ADD CONSTRAINT "nvr:Nationalpark_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturminne_punkt"
    ADD CONSTRAINT "nvr:Naturminne_punkt_NVRID_key" UNIQUE ("NVRID");


--
-- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturminne_punkt"
    ADD CONSTRAINT "nvr:Naturminne_punkt_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Naturminne_yta nvr:Naturminne_yta_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturminne_yta"
    ADD CONSTRAINT "nvr:Naturminne_yta_NVRID_key" UNIQUE ("NVRID");


--
-- Name: nvr:Naturminne_yta nvr:Naturminne_yta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturminne_yta"
    ADD CONSTRAINT "nvr:Naturminne_yta_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Naturreservat nvr:Naturreservat_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturreservat"
    ADD CONSTRAINT "nvr:Naturreservat_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Naturvardsomrade nvr:Naturvardsomrade_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturvardsomrade"
    ADD CONSTRAINT "nvr:Naturvardsomrade_NVRID_key" UNIQUE ("NVRID");


--
-- Name: nvr:Naturvardsomrade nvr:Naturvardsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Naturvardsomrade"
    ADD CONSTRAINT "nvr:Naturvardsomrade_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:OSPAR nvr:OSPAR_MPA_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:OSPAR"
    ADD CONSTRAINT "nvr:OSPAR_MPA_ID_key" UNIQUE ("MPA_ID");


--
-- Name: nvr:OSPAR nvr:OSPAR_MPA_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:OSPAR"
    ADD CONSTRAINT "nvr:OSPAR_MPA_NAMN_key" UNIQUE ("MPA_NAMN");


--
-- Name: nvr:OSPAR nvr:OSPAR_N2000_SITE_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:OSPAR"
    ADD CONSTRAINT "nvr:OSPAR_N2000_SITE_key" UNIQUE ("N2000_SITE");


--
-- Name: nvr:OSPAR nvr:OSPAR_NAMN_N2000_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:OSPAR"
    ADD CONSTRAINT "nvr:OSPAR_NAMN_N2000_key" UNIQUE ("NAMN_N2000");


--
-- Name: nvr:OSPAR nvr:OSPAR_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:OSPAR"
    ADD CONSTRAINT "nvr:OSPAR_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Ovrigt_biotopskyddsomrade nvr:Ovrigt_biotopskyddsomrade_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Ovrigt_biotopskyddsomrade"
    ADD CONSTRAINT "nvr:Ovrigt_biotopskyddsomrade_NVRID_key" UNIQUE ("NVRID");


--
-- Name: nvr:Ovrigt_biotopskyddsomrade nvr:Ovrigt_biotopskyddsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Ovrigt_biotopskyddsomrade"
    ADD CONSTRAINT "nvr:Ovrigt_biotopskyddsomrade_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Ramsar nvr:Ramsar_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Ramsar"
    ADD CONSTRAINT "nvr:Ramsar_NAMN_key" UNIQUE ("NAMN");


--
-- Name: nvr:Ramsar nvr:Ramsar_RAMSAR_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Ramsar"
    ADD CONSTRAINT "nvr:Ramsar_RAMSAR_ID_key" UNIQUE ("RAMSAR_ID");


--
-- Name: nvr:Ramsar nvr:Ramsar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Ramsar"
    ADD CONSTRAINT "nvr:Ramsar_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:SCI_Rikstackande nvr:SCI_Rikstackande_SITE_CODE_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:SCI_Rikstackande"
    ADD CONSTRAINT "nvr:SCI_Rikstackande_SITE_CODE_key" UNIQUE ("SITE_CODE");


--
-- Name: nvr:SCI_Rikstackande nvr:SCI_Rikstackande_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:SCI_Rikstackande"
    ADD CONSTRAINT "nvr:SCI_Rikstackande_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:SPA_Rikstackande nvr:SPA_Rikstackande_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:SPA_Rikstackande"
    ADD CONSTRAINT "nvr:SPA_Rikstackande_NAMN_key" UNIQUE ("NAMN");


--
-- Name: nvr:SPA_Rikstackande nvr:SPA_Rikstackande_SITE_CODE_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:SPA_Rikstackande"
    ADD CONSTRAINT "nvr:SPA_Rikstackande_SITE_CODE_key" UNIQUE ("SITE_CODE");


--
-- Name: nvr:SPA_Rikstackande nvr:SPA_Rikstackande_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:SPA_Rikstackande"
    ADD CONSTRAINT "nvr:SPA_Rikstackande_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Tilltradesforbud nvr:Tilltradesforbud_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Tilltradesforbud"
    ADD CONSTRAINT "nvr:Tilltradesforbud_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Varldsarv nvr:Varldsarv_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Varldsarv"
    ADD CONSTRAINT "nvr:Varldsarv_NAMN_key" UNIQUE ("NAMN");


--
-- Name: nvr:Varldsarv nvr:Varldsarv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Varldsarv"
    ADD CONSTRAINT "nvr:Varldsarv_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: nvr:Vattenskyddsomrade nvr:Vattenskyddsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."nvr:Vattenskyddsomrade"
    ADD CONSTRAINT "nvr:Vattenskyddsomrade_pkey" PRIMARY KEY (ogc_fid);


--
-- 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_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_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: 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
--

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:flyttled sametinget:flyttled_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sametinget:flyttled"
    ADD CONSTRAINT "sametinget:flyttled_GlobalID_key" UNIQUE ("GlobalID");


--
-- Name: sametinget:flyttled sametinget:flyttled_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sametinget:flyttled"
    ADD CONSTRAINT "sametinget:flyttled_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: sks:atervatningsavtal sks:atervatningsavtal_Uuid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:atervatningsavtal"
    ADD CONSTRAINT "sks:atervatningsavtal_Uuid_key" UNIQUE ("Uuid");


--
-- Name: sks:atervatningsavtal sks:atervatningsavtal_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:atervatningsavtal"
    ADD CONSTRAINT "sks:atervatningsavtal_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: sks:avverk_anmald sks:avverk_anmald_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:avverk_anmald"
    ADD CONSTRAINT "sks:avverk_anmald_OBJECTID_key" UNIQUE ("OBJECTID");


--
-- Name: sks:avverk_anmald sks:avverk_anmald_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:avverk_anmald"
    ADD CONSTRAINT "sks:avverk_anmald_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: sks:avverk_utford sks:avverk_utford_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:avverk_utford"
    ADD CONSTRAINT "sks:avverk_utford_Beteckn_key" UNIQUE ("Beteckn");


--
-- Name: sks:avverk_utford sks:avverk_utford_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:avverk_utford"
    ADD CONSTRAINT "sks:avverk_utford_OBJECTID_key" UNIQUE ("OBJECTID");


--
-- Name: sks:avverk_utford sks:avverk_utford_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:avverk_utford"
    ADD CONSTRAINT "sks:avverk_utford_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: sks:naturvarde sks:naturvarde_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:naturvarde"
    ADD CONSTRAINT "sks:naturvarde_Beteckn_key" UNIQUE ("Beteckn");


--
-- Name: sks:naturvarde sks:naturvarde_ObjectId_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:naturvarde"
    ADD CONSTRAINT "sks:naturvarde_ObjectId_key" UNIQUE ("ObjectId");


--
-- Name: sks:naturvarde sks:naturvarde_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:naturvarde"
    ADD CONSTRAINT "sks:naturvarde_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: sks:naturvardsavtal sks:naturvardsavtal_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:naturvardsavtal"
    ADD CONSTRAINT "sks:naturvardsavtal_Beteckn_key" UNIQUE ("Beteckn");


--
-- Name: sks:naturvardsavtal sks:naturvardsavtal_Uuid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:naturvardsavtal"
    ADD CONSTRAINT "sks:naturvardsavtal_Uuid_key" UNIQUE ("Uuid");


--
-- Name: sks:naturvardsavtal sks:naturvardsavtal_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:naturvardsavtal"
    ADD CONSTRAINT "sks:naturvardsavtal_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: sks:nyckelbiotop sks:nyckelbiotop_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:nyckelbiotop"
    ADD CONSTRAINT "sks:nyckelbiotop_Beteckn_key" UNIQUE ("Beteckn");


--
-- Name: sks:nyckelbiotop sks:nyckelbiotop_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:nyckelbiotop"
    ADD CONSTRAINT "sks:nyckelbiotop_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: sks:nyckelbiotop_storskogsbruk sks:nyckelbiotop_storskogsbruk_objectid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:nyckelbiotop_storskogsbruk"
    ADD CONSTRAINT "sks:nyckelbiotop_storskogsbruk_objectid_key" UNIQUE (objectid);


--
-- Name: sks:nyckelbiotop_storskogsbruk sks:nyckelbiotop_storskogsbruk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:nyckelbiotop_storskogsbruk"
    ADD CONSTRAINT "sks:nyckelbiotop_storskogsbruk_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: sks:sumpskog sks:sumpskog_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:sumpskog"
    ADD CONSTRAINT "sks:sumpskog_OBJECTID_key" UNIQUE ("OBJECTID");


--
-- Name: sks:sumpskog sks:sumpskog_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."sks:sumpskog"
    ADD CONSTRAINT "sks:sumpskog_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: svk:ledningar svk:ledningar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."svk:ledningar"
    ADD CONSTRAINT "svk:ledningar_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: svk:stationsomraden svk:stationsomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."svk:stationsomraden"
    ADD CONSTRAINT "svk:stationsomraden_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: svk:stolpar svk:stolpar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."svk:stolpar"
    ADD CONSTRAINT "svk:stolpar_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: svk:transmissionsnatsprojekt svk:transmissionsnatsprojekt_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."svk:transmissionsnatsprojekt"
    ADD CONSTRAINT "svk:transmissionsnatsprojekt_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: vbk:havsbaserad_vindkraft vbk:havsbaserad_vindkraft_OmrID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."vbk:havsbaserad_vindkraft"
    ADD CONSTRAINT "vbk:havsbaserad_vindkraft_OmrID_key" UNIQUE ("OmrID");


--
-- Name: vbk:havsbaserad_vindkraft vbk:havsbaserad_vindkraft_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."vbk:havsbaserad_vindkraft"
    ADD CONSTRAINT "vbk:havsbaserad_vindkraft_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: vbk:projekteringsomraden vbk:projekteringsomraden_OmrID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."vbk:projekteringsomraden"
    ADD CONSTRAINT "vbk:projekteringsomraden_OmrID_key" UNIQUE ("OmrID");


--
-- Name: vbk:projekteringsomraden vbk:projekteringsomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."vbk:projekteringsomraden"
    ADD CONSTRAINT "vbk:projekteringsomraden_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: vbk:vindkraftverk vbk:vindkraftverk_VerkID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."vbk:vindkraftverk"
    ADD CONSTRAINT "vbk:vindkraftverk_VerkID_key" UNIQUE ("VerkID");


--
-- Name: vbk:vindkraftverk vbk:vindkraftverk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis."vbk:vindkraftverk"
    ADD CONSTRAINT "vbk:vindkraftverk_pkey" PRIMARY KEY (ogc_fid);


--
-- Name: layercache layercache_layername_key; Type: CONSTRAINT; Schema: public; Owner: webmap_import
--

ALTER TABLE ONLY public.layercache
    ADD CONSTRAINT layercache_layername_key UNIQUE (layername);


--
-- Name: layercache layercache_pkey; Type: CONSTRAINT; Schema: public; Owner: webmap_import
--

ALTER TABLE ONLY public.layercache
    ADD CONSTRAINT layercache_pkey PRIMARY KEY (ogc_fid);


--
-- Name: dammar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX dammar_wkb_geometry_geom_idx ON postgis.dammar USING gist (wkb_geometry);


--
-- Name: gigafactories_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX gigafactories_wkb_geometry_geom_idx ON postgis.gigafactories USING gist (wkb_geometry);


--
-- Name: kommunyta_sub_kommunkod_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX kommunyta_sub_kommunkod_idx ON postgis.kommunyta_sub USING btree (kommunkod);


--
-- Name: kommunyta_sub_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX kommunyta_sub_wkb_geometry_geom_idx ON postgis.kommunyta_sub USING gist (wkb_geometry);


--
-- Name: kommunyta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX kommunyta_wkb_geometry_geom_idx ON postgis.kommunyta USING gist (wkb_geometry);


--
-- Name: lansyta_sub_lanskod_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX lansyta_sub_lanskod_idx ON postgis.lansyta_sub USING btree (lanskod);


--
-- Name: lansyta_sub_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX lansyta_sub_wkb_geometry_geom_idx ON postgis.lansyta_sub USING gist (wkb_geometry);


--
-- Name: lansyta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_geometry);


--
-- 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:markanvisningar_bk_ansokta_wkb_geometry_geom_idx" ON postgis."mrr:markanvisningar_bk_ansokta" USING gist (wkb_geometry);


--
-- Name: mrr:markanvisningar_bk_beviljade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "mrr:markanvisningar_bk_beviljade_wkb_geometry_geom_idx" ON postgis."mrr:markanvisningar_bk_beviljade" USING gist (wkb_geometry);


--
-- Name: mrr:ut_diamant_ansokta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "mrr:ut_diamant_ansokta_wkb_geometry_geom_idx" ON postgis."mrr:ut_diamant_ansokta" USING gist (wkb_geometry);


--
-- Name: mrr:ut_diamant_beviljade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "mrr:ut_diamant_beviljade_wkb_geometry_geom_idx" ON postgis."mrr:ut_diamant_beviljade" USING gist (wkb_geometry);


--
-- Name: mrr:ut_diamant_forbud_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "mrr:ut_diamant_forbud_wkb_geometry_geom_idx" ON postgis."mrr:ut_diamant_forbud" USING gist (wkb_geometry);


--
-- Name: mrr:ut_metaller_industrimineral_ansokta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "mrr:ut_metaller_industrimineral_ansokta_wkb_geometry_geom_idx" ON postgis."mrr:ut_metaller_industrimineral_ansokta" USING gist (wkb_geometry);


--
-- Name: mrr:ut_metaller_industrimineral_beviljade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "mrr:ut_metaller_industrimineral_beviljade_wkb_geometry_geom_idx" ON postgis."mrr:ut_metaller_industrimineral_beviljade" USING gist (wkb_geometry);


--
-- Name: mrr:ut_metaller_industrimineral_forbud_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

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);


--
-- Name: nvk:naturvardsavtal_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvk:naturvardsavtal_wkb_geometry_geom_idx" ON postgis."nvk:naturvardsavtal" USING gist (wkb_geometry);


--
-- Name: nvr:Biosfarsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Biosfarsomraden_wkb_geometry_geom_idx" ON postgis."nvr:Biosfarsomraden" USING gist (wkb_geometry);


--
-- Name: nvr:Biotopskydd_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Biotopskydd_wkb_geometry_geom_idx" ON postgis."nvr:Biotopskydd" USING gist (wkb_geometry);


--
-- Name: nvr:Djur_och_vaxtskyddsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Djur_och_vaxtskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Djur_och_vaxtskyddsomrade" USING gist (wkb_geometry);


--
-- Name: nvr:HELCOM_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:HELCOM_wkb_geometry_geom_idx" ON postgis."nvr:HELCOM" USING gist (wkb_geometry);


--
-- Name: nvr:Interimistiskt_forbud_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Interimistiskt_forbud_wkb_geometry_geom_idx" ON postgis."nvr:Interimistiskt_forbud" USING gist (wkb_geometry);


--
-- Name: nvr:Kultureservat_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Kultureservat_wkb_geometry_geom_idx" ON postgis."nvr:Kultureservat" USING gist (wkb_geometry);


--
-- Name: nvr:Landskapsbildsskyddsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Landskapsbildsskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Landskapsbildsskyddsomrade" USING gist (wkb_geometry);


--
-- Name: nvr:Nationalpark_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Nationalpark_wkb_geometry_geom_idx" ON postgis."nvr:Nationalpark" USING gist (wkb_geometry);


--
-- Name: nvr:Naturminne_punkt_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Naturminne_punkt_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_punkt" USING gist (wkb_geometry);


--
-- Name: nvr:Naturminne_yta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Naturminne_yta_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_yta" USING gist (wkb_geometry);


--
-- Name: nvr:Naturreservat_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Naturreservat_wkb_geometry_geom_idx" ON postgis."nvr:Naturreservat" USING gist (wkb_geometry);


--
-- Name: nvr:Naturvardsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Naturvardsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Naturvardsomrade" USING gist (wkb_geometry);


--
-- Name: nvr:OSPAR_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:OSPAR_wkb_geometry_geom_idx" ON postgis."nvr:OSPAR" USING gist (wkb_geometry);


--
-- Name: nvr:Ovrigt_biotopskyddsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Ovrigt_biotopskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Ovrigt_biotopskyddsomrade" USING gist (wkb_geometry);


--
-- Name: nvr:Ramsar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Ramsar_wkb_geometry_geom_idx" ON postgis."nvr:Ramsar" USING gist (wkb_geometry);


--
-- Name: nvr:SCI_Rikstackande_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:SCI_Rikstackande_wkb_geometry_geom_idx" ON postgis."nvr:SCI_Rikstackande" USING gist (wkb_geometry);


--
-- Name: nvr:SPA_Rikstackande_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:SPA_Rikstackande_wkb_geometry_geom_idx" ON postgis."nvr:SPA_Rikstackande" USING gist (wkb_geometry);


--
-- Name: nvr:Tilltradesforbud_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Tilltradesforbud_wkb_geometry_geom_idx" ON postgis."nvr:Tilltradesforbud" USING gist (wkb_geometry);


--
-- Name: nvr:Varldsarv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Varldsarv_wkb_geometry_geom_idx" ON postgis."nvr:Varldsarv" USING gist (wkb_geometry);


--
-- Name: nvr:Vattenskyddsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "nvr:Vattenskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Vattenskyddsomrade" USING gist (wkb_geometry);


--
-- 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: 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
--

CREATE INDEX "sametinget:betesomraden_wkb_geometry_geom_idx" ON postgis."sametinget:betesomraden" USING gist (wkb_geometry);


--
-- Name: sametinget:flyttled_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "sametinget:flyttled_wkb_geometry_geom_idx" ON postgis."sametinget:flyttled" USING gist (wkb_geometry);


--
-- Name: sks:atervatningsavtal_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "sks:atervatningsavtal_wkb_geometry_geom_idx" ON postgis."sks:atervatningsavtal" USING gist (wkb_geometry);


--
-- Name: sks:avverk_anmald_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "sks:avverk_anmald_wkb_geometry_geom_idx" ON postgis."sks:avverk_anmald" USING gist (wkb_geometry);


--
-- Name: sks:avverk_utford_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "sks:avverk_utford_wkb_geometry_geom_idx" ON postgis."sks:avverk_utford" USING gist (wkb_geometry);


--
-- Name: sks:naturvarde_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "sks:naturvarde_wkb_geometry_geom_idx" ON postgis."sks:naturvarde" USING gist (wkb_geometry);


--
-- Name: sks:naturvardsavtal_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "sks:naturvardsavtal_wkb_geometry_geom_idx" ON postgis."sks:naturvardsavtal" USING gist (wkb_geometry);


--
-- Name: sks:nyckelbiotop_storskogsbruk_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "sks:nyckelbiotop_storskogsbruk_wkb_geometry_geom_idx" ON postgis."sks:nyckelbiotop_storskogsbruk" USING gist (wkb_geometry);


--
-- Name: sks:nyckelbiotop_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "sks:nyckelbiotop_wkb_geometry_geom_idx" ON postgis."sks:nyckelbiotop" USING gist (wkb_geometry);


--
-- Name: sks:sumpskog_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "sks:sumpskog_wkb_geometry_geom_idx" ON postgis."sks:sumpskog" USING gist (wkb_geometry);


--
-- Name: svk:ledningar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "svk:ledningar_wkb_geometry_geom_idx" ON postgis."svk:ledningar" USING gist (wkb_geometry);


--
-- Name: svk:stationsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "svk:stationsomraden_wkb_geometry_geom_idx" ON postgis."svk:stationsomraden" USING gist (wkb_geometry);


--
-- Name: svk:stolpar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "svk:stolpar_wkb_geometry_geom_idx" ON postgis."svk:stolpar" USING gist (wkb_geometry);


--
-- Name: svk:transmissionsnatsprojekt_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "svk:transmissionsnatsprojekt_wkb_geometry_geom_idx" ON postgis."svk:transmissionsnatsprojekt" USING gist (wkb_geometry);


--
-- Name: vbk:havsbaserad_vindkraft_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "vbk:havsbaserad_vindkraft_wkb_geometry_geom_idx" ON postgis."vbk:havsbaserad_vindkraft" USING gist (wkb_geometry);


--
-- Name: vbk:projekteringsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "vbk:projekteringsomraden_wkb_geometry_geom_idx" ON postgis."vbk:projekteringsomraden" USING gist (wkb_geometry);


--
-- Name: vbk:vindkraftverk_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
--

CREATE INDEX "vbk:vindkraftverk_wkb_geometry_geom_idx" ON postgis."vbk:vindkraftverk" USING gist (wkb_geometry);


--
-- Name: kommunyta kommunyta_subdivide_trigger; Type: TRIGGER; Schema: postgis; Owner: webmap_import
--

CREATE TRIGGER kommunyta_subdivide_trigger AFTER INSERT OR DELETE OR UPDATE ON postgis.kommunyta FOR EACH ROW EXECUTE FUNCTION postgis.kommunyta_subdivide_func();


--
-- Name: lansyta lansyta_subdivide_trigger; Type: TRIGGER; Schema: postgis; Owner: webmap_import
--

CREATE TRIGGER lansyta_subdivide_trigger AFTER INSERT OR DELETE OR UPDATE ON postgis.lansyta FOR EACH ROW EXECUTE FUNCTION postgis.lansyta_subdivide_func();


--
-- Name: kommunyta_sub kommunyta_sub_kommunkod_fkey; Type: FK CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.kommunyta_sub
    ADD CONSTRAINT kommunyta_sub_kommunkod_fkey FOREIGN KEY (kommunkod) REFERENCES postgis.kommunyta(kommunkod) ON DELETE CASCADE;


--
-- Name: lansyta_sub lansyta_sub_lanskod_fkey; Type: FK CONSTRAINT; Schema: postgis; Owner: webmap_import
--

ALTER TABLE ONLY postgis.lansyta_sub
    ADD CONSTRAINT lansyta_sub_lanskod_fkey FOREIGN KEY (lanskod) REFERENCES postgis.lansyta(lanskod) ON DELETE CASCADE;


--
-- Name: DATABASE webmap; Type: ACL; Schema: -; Owner: postgres
--

GRANT CONNECT ON DATABASE webmap TO webmap_import;
GRANT CONNECT ON DATABASE webmap TO webmap_guest;


--
-- Name: SCHEMA postgis; Type: ACL; Schema: -; Owner: postgres
--

GRANT USAGE ON SCHEMA postgis TO webmap_import;
GRANT USAGE ON SCHEMA postgis TO webmap_guest;


--
-- Name: FUNCTION get_counties(postgis.geometry); Type: ACL; Schema: postgis; Owner: postgres
--

GRANT ALL ON FUNCTION postgis.get_counties(postgis.geometry) TO webmap_import;
GRANT ALL ON FUNCTION postgis.get_counties(postgis.geometry) TO webmap_guest;


--
-- Name: FUNCTION get_municipalities(postgis.geometry); Type: ACL; Schema: postgis; Owner: postgres
--

GRANT ALL ON FUNCTION postgis.get_municipalities(postgis.geometry) TO webmap_import;
GRANT ALL ON FUNCTION postgis.get_municipalities(postgis.geometry) TO webmap_guest;


--
-- Name: TABLE dammar; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis.dammar TO webmap_guest;


--
-- Name: SEQUENCE dammar_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis.dammar_ogc_fid_seq TO webmap_guest;


--
-- Name: TABLE geography_columns; Type: ACL; Schema: postgis; Owner: postgres
--

GRANT SELECT ON TABLE postgis.geography_columns TO webmap_guest;


--
-- Name: TABLE geometry_columns; Type: ACL; Schema: postgis; Owner: postgres
--

GRANT SELECT ON TABLE postgis.geometry_columns TO webmap_guest;


--
-- Name: TABLE gigafactories; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis.gigafactories TO webmap_guest;


--
-- Name: SEQUENCE gigafactories_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis.gigafactories_ogc_fid_seq TO webmap_guest;


--
-- Name: TABLE kommunyta; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis.kommunyta TO webmap_guest;


--
-- Name: SEQUENCE kommunyta_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis.kommunyta_ogc_fid_seq TO webmap_guest;


--
-- Name: TABLE kommunyta_sub; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis.kommunyta_sub TO webmap_guest;


--
-- Name: SEQUENCE kommunyta_sub_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis.kommunyta_sub_ogc_fid_seq TO webmap_guest;


--
-- Name: TABLE lansyta; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis.lansyta TO webmap_guest;


--
-- Name: SEQUENCE lansyta_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_ogc_fid_seq TO webmap_guest;


--
-- Name: TABLE lansyta_sub; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis.lansyta_sub TO webmap_guest;


--
-- Name: SEQUENCE lansyta_sub_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_sub_ogc_fid_seq TO webmap_guest;


--
-- 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:ut_diamant_ansokta" TO webmap_guest;


--
-- Name: SEQUENCE "mrr:ut_diamant_ansokta_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "mrr:ut_diamant_beviljade"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."mrr:ut_diamant_beviljade" TO webmap_guest;


--
-- Name: SEQUENCE "mrr:ut_diamant_beviljade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "mrr:ut_diamant_forbud"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."mrr:ut_diamant_forbud" TO webmap_guest;


--
-- Name: SEQUENCE "mrr:ut_diamant_forbud_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "mrr:ut_metaller_industrimineral_ansokta"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" TO webmap_guest;


--
-- Name: SEQUENCE "mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "mrr:ut_metaller_industrimineral_beviljade"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" TO webmap_guest;


--
-- Name: SEQUENCE "mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "mrr:ut_metaller_industrimineral_forbud"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."mrr:ut_metaller_industrimineral_forbud" TO webmap_guest;


--
-- Name: SEQUENCE "mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "mrr:ut_metaller_industrimineral_forfallna"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" TO webmap_guest;


--
-- Name: SEQUENCE "mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "mrr:ut_olja_gas_diamant_forfallna"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" TO webmap_guest;


--
-- 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:ut_olja_gas_diamant_forfallna_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvk:naturvardsavtal"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvk:naturvardsavtal" TO webmap_guest;


--
-- Name: SEQUENCE "nvk:naturvardsavtal_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Biosfarsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Biosfarsomraden" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Biosfarsomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Biotopskydd"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Biotopskydd" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Biotopskydd_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Djur_och_vaxtskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:HELCOM"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:HELCOM" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:HELCOM_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Interimistiskt_forbud"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Interimistiskt_forbud" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Interimistiskt_forbud_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Kultureservat"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Kultureservat" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Kultureservat_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Landskapsbildsskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Landskapsbildsskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Nationalpark"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Nationalpark" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Nationalpark_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Naturminne_punkt"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Naturminne_punkt" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Naturminne_punkt_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Naturminne_yta"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Naturminne_yta" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Naturminne_yta_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Naturreservat"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Naturreservat" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Naturreservat_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Naturvardsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Naturvardsomrade" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Naturvardsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:OSPAR"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:OSPAR" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:OSPAR_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Ovrigt_biotopskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Ramsar"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Ramsar" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Ramsar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:SCI_Rikstackande"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:SCI_Rikstackande" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:SCI_Rikstackande_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:SPA_Rikstackande"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:SPA_Rikstackande" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:SPA_Rikstackande_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Tilltradesforbud"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Tilltradesforbud" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Tilltradesforbud_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Varldsarv"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Varldsarv" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Varldsarv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "nvr:Vattenskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."nvr:Vattenskyddsomrade" TO webmap_guest;


--
-- Name: SEQUENCE "nvr:Vattenskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" TO webmap_guest;


--
-- 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 "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
--

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:flyttled"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."sametinget:flyttled" TO webmap_guest;


--
-- Name: SEQUENCE "sametinget:flyttled_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "sks:atervatningsavtal"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."sks:atervatningsavtal" TO webmap_guest;


--
-- Name: SEQUENCE "sks:atervatningsavtal_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "sks:avverk_anmald"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."sks:avverk_anmald" TO webmap_guest;


--
-- Name: SEQUENCE "sks:avverk_anmald_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "sks:avverk_utford"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."sks:avverk_utford" TO webmap_guest;


--
-- Name: SEQUENCE "sks:avverk_utford_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "sks:naturvarde"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."sks:naturvarde" TO webmap_guest;


--
-- Name: SEQUENCE "sks:naturvarde_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "sks:naturvardsavtal"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."sks:naturvardsavtal" TO webmap_guest;


--
-- Name: SEQUENCE "sks:naturvardsavtal_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "sks:nyckelbiotop"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."sks:nyckelbiotop" TO webmap_guest;


--
-- Name: SEQUENCE "sks:nyckelbiotop_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "sks:nyckelbiotop_storskogsbruk"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."sks:nyckelbiotop_storskogsbruk" TO webmap_guest;


--
-- Name: SEQUENCE "sks:nyckelbiotop_storskogsbruk_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "sks:sumpskog"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."sks:sumpskog" TO webmap_guest;


--
-- Name: SEQUENCE "sks:sumpskog_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE spatial_ref_sys; Type: ACL; Schema: postgis; Owner: postgres
--

GRANT SELECT ON TABLE postgis.spatial_ref_sys TO webmap_guest;


--
-- Name: TABLE "svk:ledningar"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."svk:ledningar" TO webmap_guest;


--
-- Name: SEQUENCE "svk:ledningar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."svk:ledningar_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "svk:stationsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."svk:stationsomraden" TO webmap_guest;


--
-- Name: SEQUENCE "svk:stationsomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "svk:stolpar"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."svk:stolpar" TO webmap_guest;


--
-- Name: SEQUENCE "svk:stolpar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."svk:stolpar_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "svk:transmissionsnatsprojekt"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."svk:transmissionsnatsprojekt" TO webmap_guest;


--
-- Name: SEQUENCE "svk:transmissionsnatsprojekt_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "vbk:havsbaserad_vindkraft"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."vbk:havsbaserad_vindkraft" TO webmap_guest;


--
-- Name: SEQUENCE "vbk:havsbaserad_vindkraft_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "vbk:projekteringsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."vbk:projekteringsomraden" TO webmap_guest;


--
-- Name: SEQUENCE "vbk:projekteringsomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE "vbk:vindkraftverk"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT ON TABLE postgis."vbk:vindkraftverk" TO webmap_guest;


--
-- Name: SEQUENCE "vbk:vindkraftverk_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" TO webmap_guest;


--
-- Name: TABLE layercache; Type: ACL; Schema: public; Owner: webmap_import
--

GRANT SELECT ON TABLE public.layercache TO webmap_guest;


--
-- Name: SEQUENCE layercache_ogc_fid_seq; Type: ACL; Schema: public; Owner: webmap_import
--

GRANT SELECT,USAGE ON SEQUENCE public.layercache_ogc_fid_seq TO webmap_guest;


--
-- PostgreSQL database dump complete
--

