-- -- PostgreSQL database dump -- -- Dumped from database version 15.8 (Debian 15.8-0+deb12u1) -- Dumped by pg_dump version 15.8 (Debian 15.8-0+deb12u1) SET statement_timeout = 0; SET lock_timeout = 0; 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'; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- 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) ); 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: 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) ); 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: mrr:bearbetningskoncessioner_applied; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:bearbetningskoncessioner_applied" ( ogc_fid bigint NOT NULL, "Name" character varying(254) NOT NULL, "Mineral" character varying(254) NOT NULL, "Applicant" character varying(254) NOT NULL, "ApplicationDate" date NOT NULL, "DiaryNr" character(16) NOT NULL, "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."mrr:bearbetningskoncessioner_applied" OWNER TO webmap_import; -- -- Name: TABLE "mrr:bearbetningskoncessioner_applied"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_applied" IS 'Bearbetningskoncessioner, ansökta (SGU)'; -- -- Name: mrr:bearbetningskoncessioner_applied_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:bearbetningskoncessioner_applied_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_applied".ogc_fid; -- -- Name: mrr:bearbetningskoncessioner_approved; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:bearbetningskoncessioner_approved" ( ogc_fid bigint NOT NULL, "Name" character varying(254) NOT NULL, "Mineral" character varying(254) NOT NULL, "Owner" character varying(254) NOT NULL, "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."mrr:bearbetningskoncessioner_approved" OWNER TO webmap_import; -- -- Name: TABLE "mrr:bearbetningskoncessioner_approved"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_approved" IS 'Bearbetningskoncessioner, beviljade (SGU)'; -- -- Name: mrr:bearbetningskoncessioner_approved_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:bearbetningskoncessioner_approved_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_approved".ogc_fid; -- -- Name: mrr:markanvisningar; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:markanvisningar" ( ogc_fid bigint NOT NULL, "Name" character varying(254) NOT NULL, "DecisionDate" date, "DiaryNr" character(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."mrr:markanvisningar" OWNER TO webmap_import; -- -- Name: TABLE "mrr:markanvisningar"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:markanvisningar" IS 'Markanvisning till koncession (SGU)'; -- -- Name: mrr:markanvisningar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:markanvisningar_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:markanvisningar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" OWNED BY postgis."mrr:markanvisningar".ogc_fid; -- -- Name: mrr:mineral_applied; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:mineral_applied" ( ogc_fid bigint NOT NULL, "Name" character varying(254) NOT NULL, "Mineral" character varying(254) NOT NULL, "Applicant" character varying(254) NOT NULL, "ApplicationDate" date NOT NULL, "DiaryNr" character(16) NOT NULL, "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."mrr:mineral_applied" OWNER TO webmap_import; -- -- Name: TABLE "mrr:mineral_applied"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:mineral_applied" IS 'Undersökningstillstånd, metallar och mineral, ansökta (SGU)'; -- -- Name: mrr:mineral_applied_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:mineral_applied_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:mineral_applied_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq" OWNED BY postgis."mrr:mineral_applied".ogc_fid; -- -- Name: mrr:mineral_approved; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:mineral_approved" ( ogc_fid bigint NOT NULL, "Name" character varying(254) NOT NULL, "Mineral" character varying(254) NOT NULL, "Owner" character varying(254) NOT NULL, "LicenceID" character(8) NOT NULL, "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."mrr:mineral_approved" OWNER TO webmap_import; -- -- Name: TABLE "mrr:mineral_approved"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:mineral_approved" IS 'Undersökningstillstånd, metallar och mineral, beviljade (SGU)'; -- -- Name: mrr:mineral_approved_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:mineral_approved_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:mineral_approved_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq" OWNED BY postgis."mrr:mineral_approved".ogc_fid; -- -- Name: mrr:olja_gas_diamant_applied; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:olja_gas_diamant_applied" ( ogc_fid bigint NOT NULL, "Name" character varying(254) NOT NULL, "Mineral" character varying(254) NOT NULL, "Applicant" character varying(254) NOT NULL, "ApplicationDate" date NOT NULL, "DiaryNr" character(16) NOT NULL, "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."mrr:olja_gas_diamant_applied" OWNER TO webmap_import; -- -- Name: TABLE "mrr:olja_gas_diamant_applied"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:olja_gas_diamant_applied" IS 'Undersökningstillstånd, olja, gas och diamant, ansökta (SGU)'; -- -- Name: mrr:olja_gas_diamant_applied_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:olja_gas_diamant_applied_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" OWNED BY postgis."mrr:olja_gas_diamant_applied".ogc_fid; -- -- Name: mrr:olja_gas_diamant_approved; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:olja_gas_diamant_approved" ( ogc_fid bigint NOT NULL, "Name" character varying(254) NOT NULL, "Mineral" character varying(254) NOT NULL, "Owner" character varying(254) NOT NULL, "LicenceID" character(8) NOT NULL, "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."mrr:olja_gas_diamant_approved" OWNER TO webmap_import; -- -- Name: TABLE "mrr:olja_gas_diamant_approved"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:olja_gas_diamant_approved" IS 'Undersökningstillstånd, olja, gas och diamant, beviljade (SGU)'; -- -- Name: mrr:olja_gas_diamant_approved_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:olja_gas_diamant_approved_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" OWNED BY postgis."mrr:olja_gas_diamant_approved".ogc_fid; -- -- Name: mrr:torvkoncessioner; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:torvkoncessioner" ( ogc_fid bigint NOT NULL, "Name" character varying(254) NOT NULL, "Mineral" character varying(254), "Owner" character varying(254) NOT NULL, "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."mrr:torvkoncessioner" OWNER TO webmap_import; -- -- Name: TABLE "mrr:torvkoncessioner"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:torvkoncessioner" IS 'Torvkoncessioner (SGU)'; -- -- Name: mrr:torvkoncessioner_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:torvkoncessioner_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:torvkoncessioner_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" OWNED BY postgis."mrr:torvkoncessioner".ogc_fid; -- -- Name: nva:Naturvardsverket_Lansstyrelse; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nva:Naturvardsverket_Lansstyrelse" ( ogc_fid bigint NOT NULL, "ID" integer NOT NULL, "DIARIENRNV" character(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) ); ALTER TABLE postgis."nva:Naturvardsverket_Lansstyrelse" OWNER TO webmap_import; -- -- Name: TABLE "nva:Naturvardsverket_Lansstyrelse"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nva:Naturvardsverket_Lansstyrelse" IS 'Naturvårdsavtal (Naturvårdsverket, Länsstyrelse)'; -- -- Name: nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" OWNED BY postgis."nva:Naturvardsverket_Lansstyrelse".ogc_fid; -- -- Name: nva:Skogsstyrelsen; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nva:Skogsstyrelsen" ( ogc_fid bigint NOT NULL, "Uuid" uuid NOT NULL, "Beteckn" character(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 NOT NULL, "Url" character varying(254) NOT NULL, "Undertyp" character varying(64), wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."nva:Skogsstyrelsen" OWNER TO webmap_import; -- -- Name: TABLE "nva:Skogsstyrelsen"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nva:Skogsstyrelsen" IS 'Naturvårdsavtal (Skogsstyrelsen)'; -- -- Name: nva:Skogsstyrelsen_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nva:Skogsstyrelsen_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nva:Skogsstyrelsen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" OWNED BY postgis."nva:Skogsstyrelsen".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) ); 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(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) ); 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) ); 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) ); 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) ); 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) ); 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) ); 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) ); 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_polygon; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Naturminne_polygon" ( 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) ); ALTER TABLE postgis."nvr:Naturminne_polygon" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Naturminne_polygon"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Naturminne_polygon" IS 'Naturminne, yta'; -- -- Name: nvr:Naturminne_polygon_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Naturminne_polygon_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Naturminne_polygon_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_polygon".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) ); 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: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) ); 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) ); 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) ); 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) ); 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) ); 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(9) NOT NULL, "OMRADESTYP" character varying(16) NOT NULL, "UPPLAMNARE" character varying(62) NOT NULL, "SCI_FORSL" character(6) NOT NULL, "SCI_DATUM" character(6), "SAC_DATUM" character(6), "SPA_DATUM" character(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) ); 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(9) NOT NULL, "OMRADESTYP" character varying(16) NOT NULL, "UPPLAMNARE" character varying(62) NOT NULL, "SCI_FORSL" character(6), "SCI_DATUM" character(6), "SAC_DATUM" character(6), "SPA_DATUM" character(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) ); 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) ); 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) ); 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) ); 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) ); 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) ); ALTER TABLE postgis."ren:riks_ren" OWNER TO webmap_import; -- -- Name: TABLE "ren:riks_ren"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."ren:riks_ren" IS 'Riksintresse Rennäringen'; -- -- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."ren:riks_ren_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren".ogc_fid; -- -- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sametinget:betesomraden" ( ogc_fid bigint NOT NULL, "SAMEBY_ID" integer NOT NULL, "BY_ID" integer, "NAMN" character varying(62) NOT NULL, "SIGNATUR" character varying(25) NOT NULL, "SAMEBY_TYP" character varying(62) NOT NULL, "BY_OMR" boolean NOT NULL, "OVR_OMR" boolean NOT NULL, "AKTUALITET" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."sametinget:betesomraden" OWNER TO webmap_import; -- -- Name: TABLE "sametinget:betesomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sametinget:betesomraden" IS 'Samebyarnas betesområden: Renbetesområden'; -- -- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sametinget:betesomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" OWNED BY postgis."sametinget:betesomraden".ogc_fid; -- -- Name: sametinget: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) ); 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:AvverkAnm; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:AvverkAnm" ( ogc_fid bigint NOT NULL, "OBJECTID" integer NOT NULL, "Beteckn" character(12) NOT NULL, "ArendeAr" smallint NOT NULL, "Avverktyp" character varying(254) NOT NULL, "Andamal" character varying(62) NOT NULL, "Skogstyp" character varying(254) NOT NULL, "Inkomdatum" date NOT NULL, "AnmaldHa" real NOT NULL, "SkogsodlHa" real NOT NULL, "NatforHa" real NOT NULL, "ArendeStatus" character varying(254) NOT NULL, "AvvSasong" character varying(254) NOT NULL, "AvvHa" real, "AvverkningsanmalanKlass" character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."sks:AvverkAnm" OWNER TO webmap_import; -- -- Name: TABLE "sks:AvverkAnm"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:AvverkAnm" IS 'Avverkningsanmälningar (Skogsstyrelsen)'; -- -- Name: sks:AvverkAnm_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:AvverkAnm_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:AvverkAnm_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" OWNED BY postgis."sks:AvverkAnm".ogc_fid; -- -- Name: sks:UtfordAvverk; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:UtfordAvverk" ( ogc_fid bigint NOT NULL, "OBJECTID" integer NOT NULL, "Beteckn" character(12), "ArendeAr" smallint NOT NULL, "Avverktyp" character varying(254) NOT NULL, "Skogstyp" character varying(254) NOT NULL, "AnmaldHa" real NOT NULL, "SkogsodlHa" real NOT NULL, "NatforHa" real NOT NULL, "Avvdatum" date NOT NULL, "KallaDatum" date, "KallaAreal" character varying(62), "Forebild" character varying(62), "Efterbild" character varying(62), "ArealHa" real NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."sks:UtfordAvverk" OWNER TO webmap_import; -- -- Name: TABLE "sks:UtfordAvverk"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:UtfordAvverk" IS 'Utförd avverkning (Skogsstyrelsen)'; -- -- Name: sks:UtfordAvverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:UtfordAvverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNED BY postgis."sks:UtfordAvverk".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(10) NOT NULL, "Projektnamn" character varying(62), "Organisationsnamn" character varying(254), "Organisationsnummer" character(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) ); 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(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(11), "ElNamn" character varying(62) NOT NULL, "SenasteUppdaterat" date, "EjAktuell" boolean NOT NULL, "Raderat" boolean NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); 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(14) NOT NULL, "OmrID" character(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(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) ); 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: 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: 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: mrr:bearbetningskoncessioner_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq"'::regclass); -- -- Name: mrr:bearbetningskoncessioner_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq"'::regclass); -- -- Name: mrr:markanvisningar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:markanvisningar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:markanvisningar_ogc_fid_seq"'::regclass); -- -- Name: mrr:mineral_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:mineral_applied" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:mineral_applied_ogc_fid_seq"'::regclass); -- -- Name: mrr:mineral_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:mineral_approved" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:mineral_approved_ogc_fid_seq"'::regclass); -- -- Name: mrr:olja_gas_diamant_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq"'::regclass); -- -- Name: mrr:olja_gas_diamant_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq"'::regclass); -- -- Name: mrr:torvkoncessioner ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:torvkoncessioner" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:torvkoncessioner_ogc_fid_seq"'::regclass); -- -- Name: nva:Naturvardsverket_Lansstyrelse ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nva:Naturvardsverket_Lansstyrelse" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq"'::regclass); -- -- Name: nva:Skogsstyrelsen ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nva:Skogsstyrelsen_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_polygon ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Naturminne_polygon" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_polygon_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: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: 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:AvverkAnm ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."sks:AvverkAnm" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:AvverkAnm_ogc_fid_seq"'::regclass); -- -- Name: sks:UtfordAvverk ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."sks:UtfordAvverk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:UtfordAvverk_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: 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_applied mrr:bearbetningskoncessioner_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_DiaryNr_key" UNIQUE ("DiaryNr"); -- -- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_Name_key" UNIQUE ("Name"); -- -- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_pkey" PRIMARY KEY (ogc_fid); -- -- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_DiaryNr_key" UNIQUE ("DiaryNr"); -- -- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_Name_key" UNIQUE ("Name"); -- -- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_pkey" PRIMARY KEY (ogc_fid); -- -- Name: mrr:markanvisningar mrr:markanvisningar_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:markanvisningar" ADD CONSTRAINT "mrr:markanvisningar_DiaryNr_key" UNIQUE ("DiaryNr"); -- -- Name: mrr:markanvisningar mrr:markanvisningar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:markanvisningar" ADD CONSTRAINT "mrr:markanvisningar_pkey" PRIMARY KEY (ogc_fid); -- -- Name: mrr:mineral_applied mrr:mineral_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:mineral_applied" ADD CONSTRAINT "mrr:mineral_applied_DiaryNr_key" UNIQUE ("DiaryNr"); -- -- Name: mrr:mineral_applied mrr:mineral_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:mineral_applied" ADD CONSTRAINT "mrr:mineral_applied_Name_key" UNIQUE ("Name"); -- -- Name: mrr:mineral_applied mrr:mineral_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:mineral_applied" ADD CONSTRAINT "mrr:mineral_applied_pkey" PRIMARY KEY (ogc_fid); -- -- Name: mrr:mineral_approved mrr:mineral_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:mineral_approved" ADD CONSTRAINT "mrr:mineral_approved_DiaryNr_key" UNIQUE ("DiaryNr"); -- -- Name: mrr:mineral_approved mrr:mineral_approved_LicenceID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:mineral_approved" ADD CONSTRAINT "mrr:mineral_approved_LicenceID_key" UNIQUE ("LicenceID"); -- -- Name: mrr:mineral_approved mrr:mineral_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:mineral_approved" ADD CONSTRAINT "mrr:mineral_approved_Name_key" UNIQUE ("Name"); -- -- Name: mrr:mineral_approved mrr:mineral_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:mineral_approved" ADD CONSTRAINT "mrr:mineral_approved_pkey" PRIMARY KEY (ogc_fid); -- -- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied" ADD CONSTRAINT "mrr:olja_gas_diamant_applied_DiaryNr_key" UNIQUE ("DiaryNr"); -- -- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied" ADD CONSTRAINT "mrr:olja_gas_diamant_applied_Name_key" UNIQUE ("Name"); -- -- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied" ADD CONSTRAINT "mrr:olja_gas_diamant_applied_pkey" PRIMARY KEY (ogc_fid); -- -- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" ADD CONSTRAINT "mrr:olja_gas_diamant_approved_DiaryNr_key" UNIQUE ("DiaryNr"); -- -- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_LicenceID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" ADD CONSTRAINT "mrr:olja_gas_diamant_approved_LicenceID_key" UNIQUE ("LicenceID"); -- -- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" ADD CONSTRAINT "mrr:olja_gas_diamant_approved_Name_key" UNIQUE ("Name"); -- -- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" ADD CONSTRAINT "mrr:olja_gas_diamant_approved_pkey" PRIMARY KEY (ogc_fid); -- -- Name: mrr:torvkoncessioner mrr:torvkoncessioner_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:torvkoncessioner" ADD CONSTRAINT "mrr:torvkoncessioner_DiaryNr_key" UNIQUE ("DiaryNr"); -- -- Name: mrr:torvkoncessioner mrr:torvkoncessioner_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:torvkoncessioner" ADD CONSTRAINT "mrr:torvkoncessioner_Name_key" UNIQUE ("Name"); -- -- Name: mrr:torvkoncessioner mrr:torvkoncessioner_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."mrr:torvkoncessioner" ADD CONSTRAINT "mrr:torvkoncessioner_pkey" PRIMARY KEY (ogc_fid); -- -- Name: nva:Naturvardsverket_Lansstyrelse nva:Naturvardsverket_Lansstyrelse_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nva:Naturvardsverket_Lansstyrelse" ADD CONSTRAINT "nva:Naturvardsverket_Lansstyrelse_pkey" PRIMARY KEY (ogc_fid); -- -- Name: nva:Skogsstyrelsen nva:Skogsstyrelsen_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" ADD CONSTRAINT "nva:Skogsstyrelsen_Beteckn_key" UNIQUE ("Beteckn"); -- -- Name: nva:Skogsstyrelsen nva:Skogsstyrelsen_Uuid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" ADD CONSTRAINT "nva:Skogsstyrelsen_Uuid_key" UNIQUE ("Uuid"); -- -- Name: nva:Skogsstyrelsen nva:Skogsstyrelsen_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" ADD CONSTRAINT "nva:Skogsstyrelsen_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_polygon nvr:Naturminne_polygon_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Naturminne_polygon" ADD CONSTRAINT "nvr:Naturminne_polygon_NVRID_key" UNIQUE ("NVRID"); -- -- Name: nvr:Naturminne_polygon nvr:Naturminne_polygon_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Naturminne_polygon" ADD CONSTRAINT "nvr:Naturminne_polygon_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: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: 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:AvverkAnm sks:AvverkAnm_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."sks:AvverkAnm" ADD CONSTRAINT "sks:AvverkAnm_Beteckn_key" UNIQUE ("Beteckn"); -- -- Name: sks:AvverkAnm sks:AvverkAnm_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."sks:AvverkAnm" ADD CONSTRAINT "sks:AvverkAnm_OBJECTID_key" UNIQUE ("OBJECTID"); -- -- Name: sks:AvverkAnm sks:AvverkAnm_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."sks:AvverkAnm" ADD CONSTRAINT "sks:AvverkAnm_pkey" PRIMARY KEY (ogc_fid); -- -- Name: sks:UtfordAvverk sks:UtfordAvverk_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."sks:UtfordAvverk" ADD CONSTRAINT "sks:UtfordAvverk_Beteckn_key" UNIQUE ("Beteckn"); -- -- Name: sks:UtfordAvverk sks:UtfordAvverk_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."sks:UtfordAvverk" ADD CONSTRAINT "sks:UtfordAvverk_OBJECTID_key" UNIQUE ("OBJECTID"); -- -- Name: sks:UtfordAvverk sks:UtfordAvverk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."sks:UtfordAvverk" ADD CONSTRAINT "sks:UtfordAvverk_pkey" PRIMARY KEY (ogc_fid); -- -- 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: 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_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_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "mrr:bearbetningskoncessioner_applied_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_applied" USING gist (wkb_geometry); -- -- Name: mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_approved" USING gist (wkb_geometry); -- -- Name: mrr:markanvisningar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "mrr:markanvisningar_wkb_geometry_geom_idx" ON postgis."mrr:markanvisningar" USING gist (wkb_geometry); -- -- Name: mrr:mineral_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "mrr:mineral_applied_wkb_geometry_geom_idx" ON postgis."mrr:mineral_applied" USING gist (wkb_geometry); -- -- Name: mrr:mineral_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "mrr:mineral_approved_wkb_geometry_geom_idx" ON postgis."mrr:mineral_approved" USING gist (wkb_geometry); -- -- Name: mrr:olja_gas_diamant_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "mrr:olja_gas_diamant_applied_wkb_geometry_geom_idx" ON postgis."mrr:olja_gas_diamant_applied" USING gist (wkb_geometry); -- -- Name: mrr:olja_gas_diamant_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "mrr:olja_gas_diamant_approved_wkb_geometry_geom_idx" ON postgis."mrr:olja_gas_diamant_approved" USING gist (wkb_geometry); -- -- Name: mrr:torvkoncessioner_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "mrr:torvkoncessioner_wkb_geometry_geom_idx" ON postgis."mrr:torvkoncessioner" USING gist (wkb_geometry); -- -- Name: nva:Naturvardsverket_Lansstyrelse_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "nva:Naturvardsverket_Lansstyrelse_wkb_geometry_geom_idx" ON postgis."nva:Naturvardsverket_Lansstyrelse" USING gist (wkb_geometry); -- -- Name: nva:Skogsstyrelsen_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "nva:Skogsstyrelsen_wkb_geometry_geom_idx" ON postgis."nva:Skogsstyrelsen" 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_polygon_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "nvr:Naturminne_polygon_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_polygon" 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: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: 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:AvverkAnm_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "sks:AvverkAnm_wkb_geometry_geom_idx" ON postgis."sks:AvverkAnm" USING gist (wkb_geometry); -- -- Name: sks:UtfordAvverk_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- CREATE INDEX "sks:UtfordAvverk_wkb_geometry_geom_idx" ON postgis."sks:UtfordAvverk" 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: 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: 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 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 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 "mrr:bearbetningskoncessioner_applied"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_applied" TO webmap_guest; -- -- Name: SEQUENCE "mrr:bearbetningskoncessioner_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "mrr:bearbetningskoncessioner_approved"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_approved" TO webmap_guest; -- -- Name: SEQUENCE "mrr:bearbetningskoncessioner_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "mrr:markanvisningar"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."mrr:markanvisningar" TO webmap_guest; -- -- Name: SEQUENCE "mrr:markanvisningar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "mrr:mineral_applied"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."mrr:mineral_applied" TO webmap_guest; -- -- Name: SEQUENCE "mrr:mineral_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "mrr:mineral_approved"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."mrr:mineral_approved" TO webmap_guest; -- -- Name: SEQUENCE "mrr:mineral_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "mrr:olja_gas_diamant_applied"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_applied" TO webmap_guest; -- -- Name: SEQUENCE "mrr:olja_gas_diamant_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "mrr:olja_gas_diamant_approved"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_approved" TO webmap_guest; -- -- Name: SEQUENCE "mrr:olja_gas_diamant_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "mrr:torvkoncessioner"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."mrr:torvkoncessioner" TO webmap_guest; -- -- Name: SEQUENCE "mrr:torvkoncessioner_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "nva:Naturvardsverket_Lansstyrelse"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."nva:Naturvardsverket_Lansstyrelse" TO webmap_guest; -- -- Name: SEQUENCE "nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "nva:Skogsstyrelsen"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."nva:Skogsstyrelsen" TO webmap_guest; -- -- Name: SEQUENCE "nva:Skogsstyrelsen_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."nva:Skogsstyrelsen_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_polygon"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."nvr:Naturminne_polygon" TO webmap_guest; -- -- Name: SEQUENCE "nvr:Naturminne_polygon_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_polygon_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: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 "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:AvverkAnm"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."sks:AvverkAnm" TO webmap_guest; -- -- Name: SEQUENCE "sks:AvverkAnm_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" TO webmap_guest; -- -- Name: TABLE "sks:UtfordAvverk"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT ON TABLE postgis."sks:UtfordAvverk" TO webmap_guest; -- -- Name: SEQUENCE "sks:UtfordAvverk_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- GRANT SELECT,USAGE ON SEQUENCE postgis."sks:UtfordAvverk_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 "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; -- -- PostgreSQL database dump complete --