-- -- 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: dammar; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.dammar ( ogc_fid bigint NOT NULL, "DammID" uuid NOT NULL, "LST_OBJID" character varying(32), "Datum" date NOT NULL, "DNamn" character varying(64), "Status" smallint NOT NULL, "Regleringstyp" smallint NOT NULL, "Konstruktion" smallint NOT NULL, "ByggAr" smallint, "DammHojd" real, "KronLangd" real, "Fiskvag" smallint NOT NULL, "FiskvagByggAr" smallint, "Fiskavledare" smallint, "Vandringshinder" boolean NOT NULL, "HARO" integer NOT NULL, "Vattendistrikt" character varying(10) NOT NULL, inrapp_lst character varying(32) NOT NULL, eu_cd character varying(32), vf_typ character varying(1), vy_eucd character varying(32), vy_vf_typ character varying(1), "DammanlID" character varying(64), "Namn" character varying(64), "Verksamhet" smallint, "OmbyggAr" smallint, "DG" real, "SG" real, "HojdSys" smallint, "MY" double precision, "RV" double precision, "Kommentar" character varying(254), "XX_Distance" double precision, wkb_geometry postgis.geometry(Point,3006) NOT NULL ); ALTER TABLE postgis.dammar OWNER TO webmap_import; -- -- Name: TABLE dammar; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis.dammar IS 'Dammar'; -- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.dammar_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.dammar_ogc_fid_seq OWNER TO webmap_import; -- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.dammar_ogc_fid_seq OWNED BY postgis.dammar.ogc_fid; -- -- Name: gigafactories; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.gigafactories ( ogc_fid bigint NOT NULL, "Name" character varying(254), "Url" character varying(254), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis.gigafactories OWNER TO webmap_import; -- -- Name: TABLE gigafactories; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis.gigafactories IS 'Stora industrisatsningar'; -- -- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.gigafactories_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import; -- -- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.gigafactories_ogc_fid_seq OWNED BY postgis.gigafactories.ogc_fid; -- -- Name: kommunyta; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.kommunyta ( ogc_fid bigint NOT NULL, objektidentitet uuid, skapad timestamp without time zone, kommunkod smallint NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis.kommunyta OWNER TO webmap_import; -- -- Name: TABLE kommunyta; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis.kommunyta IS 'Sveriges kommuner (Lantmäteriet)'; -- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.kommunyta_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.kommunyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.kommunyta_ogc_fid_seq OWNED BY postgis.kommunyta.ogc_fid; -- -- Name: lansyta; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.lansyta ( ogc_fid bigint NOT NULL, objektidentitet uuid, skapad timestamp without time zone, lanskod smallint NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis.lansyta OWNER TO webmap_import; -- -- Name: TABLE lansyta; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis.lansyta IS 'Sveriges län (Lantmäteriet)'; -- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.lansyta_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.lansyta_ogc_fid_seq OWNED BY postgis.lansyta.ogc_fid; -- -- Name: 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 varying(16) NOT NULL, "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); 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 varying(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); 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 varying(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); 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 varying(16) NOT NULL, "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); 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 varying(8) NOT NULL, "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character varying(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); 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 varying(16) NOT NULL, "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); 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 varying(8) NOT NULL, "ValidFrom" date NOT NULL, "ValidTo" date NOT NULL, "DiaryNr" character varying(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); 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 varying(16), "LastUpdated" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); 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 varying(12) NOT NULL, "STATUS" character varying(32) NOT NULL, "OBJNAMN" character varying(64), "FASTBET" character varying(64), "DATSTART" date NOT NULL, "DATSLUT" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."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 varying(12) NOT NULL, "ArendeAr" smallint NOT NULL, "NvaTyp" character varying(254), "Naturtyp" character varying(254), "AreaTot" double precision NOT NULL, "AreaProd" double precision NOT NULL, "Standort" character varying(254), "DatAvtal" date, "Url" character varying(254) NOT NULL, "Undertyp" character varying(64), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."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) NOT NULL ); ALTER TABLE postgis."nvr:Biosfarsomraden" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Biosfarsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Biosfarsomraden" IS 'Biosfärsområden (UNESCO)'; -- -- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNED BY postgis."nvr:Biosfarsomraden".ogc_fid; -- -- Name: nvr:Biotopskydd; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Biotopskydd" ( ogc_fid bigint NOT NULL, "Uuid" uuid NOT NULL, "Beteckn" character varying(12) NOT NULL, "ArendeAr" smallint NOT NULL, "Biotyp" character varying(254) NOT NULL, "Naturtyp" character varying(254), "AreaTot" double precision, "AreaProd" double precision, "Standort" character varying(254), "Datbeslut" date, "Url" character varying(254), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Biotopskydd" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Biotopskydd"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Biotopskydd" IS 'Biotopskydd i skogsmark (beslutade av Skogsstyrelsen)'; -- -- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNED BY postgis."nvr:Biotopskydd".ogc_fid; -- -- Name: nvr:Djur_och_vaxtskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(254) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(62) NOT NULL, "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Djur_och_vaxtskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" IS 'Djur- och växtskyddsområden'; -- -- Name: nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Djur_och_vaxtskyddsomrade".ogc_fid; -- -- Name: nvr:HELCOM; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:HELCOM" ( ogc_fid bigint NOT NULL, "BSPA_ID" integer NOT NULL, "NAME" character varying(62) NOT NULL, wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL ); ALTER TABLE postgis."nvr:HELCOM" OWNER TO webmap_import; -- -- Name: TABLE "nvr:HELCOM"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:HELCOM" IS 'Marina skyddade områden (Helcom MPA)'; -- -- Name: nvr:HELCOM_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:HELCOM_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:HELCOM_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" OWNED BY postgis."nvr:HELCOM".ogc_fid; -- -- Name: nvr:Interimistiskt_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Interimistiskt_forbud" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62), "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(16) NOT NULL, "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Interimistiskt_forbud" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Interimistiskt_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Interimistiskt_forbud" IS 'Interimistiska förbud'; -- -- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNED BY postgis."nvr:Interimistiskt_forbud".ogc_fid; -- -- Name: nvr:Kultureservat; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Kultureservat" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(16) NOT NULL, "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Kultureservat" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Kultureservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Kultureservat" IS 'Kulturreservat'; -- -- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Kultureservat_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" OWNED BY postgis."nvr:Kultureservat".ogc_fid; -- -- Name: nvr:Landskapsbildsskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Landskapsbildsskyddsomrade" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(16), "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Landskapsbildsskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" IS 'Landskapsbildsskyddsområden'; -- -- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Landskapsbildsskyddsomrade".ogc_fid; -- -- Name: nvr:Nationalpark; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Nationalpark" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(16) NOT NULL, "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Nationalpark" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Nationalpark"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Nationalpark" IS 'Nationalparker'; -- -- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Nationalpark_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" OWNED BY postgis."nvr:Nationalpark".ogc_fid; -- -- Name: nvr:Naturminne_punkt; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Naturminne_punkt" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(64) NOT NULL, "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPoint,3006) NOT NULL ); ALTER TABLE postgis."nvr:Naturminne_punkt" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Naturminne_punkt"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt'; -- -- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_punkt".ogc_fid; -- -- Name: nvr:Naturminne_yta; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Naturminne_yta" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(64) NOT NULL, "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Naturminne_yta" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Naturminne_yta"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Naturminne_yta" IS 'Naturminne, yta'; -- -- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_yta".ogc_fid; -- -- Name: nvr:Naturreservat; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Naturreservat" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(128) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(16), "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Naturreservat" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Naturreservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Naturreservat" IS 'Naturreservat'; -- -- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Naturreservat_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" OWNED BY postgis."nvr:Naturreservat".ogc_fid; -- -- Name: nvr:Naturvardsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Naturvardsomrade" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(64) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(16) NOT NULL, "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Naturvardsomrade" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Naturvardsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Naturvardsomrade" IS 'Naturvårdsområden'; -- -- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Naturvardsomrade".ogc_fid; -- -- Name: nvr:OSPAR; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:OSPAR" ( ogc_fid bigint NOT NULL, "ORIGIN" character varying(10) NOT NULL, "NAMN_N2000" character varying(64) NOT NULL, "MPA_ID" character varying(16) NOT NULL, "MPA_NAMN" character varying(64) NOT NULL, "N2000_SITE" character varying(16) NOT NULL, wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL ); ALTER TABLE postgis."nvr:OSPAR" OWNER TO webmap_import; -- -- Name: TABLE "nvr:OSPAR"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:OSPAR" IS 'Marina skyddade områden (Ospar MPA)'; -- -- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:OSPAR_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" OWNED BY postgis."nvr:OSPAR".ogc_fid; -- -- Name: nvr:Ovrigt_biotopskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(16) NOT NULL, "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Ovrigt_biotopskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" IS 'Biotopskydd utanför skogsmark'; -- -- Name: nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Ovrigt_biotopskyddsomrade".ogc_fid; -- -- Name: nvr:Ramsar; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Ramsar" ( ogc_fid bigint NOT NULL, "RAMSAR_ID" integer NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "NATION" character varying(32) NOT NULL, "NAMN" character varying(32) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "LINK" character varying(254) NOT NULL, "URSPR_BESL" date NOT NULL, "SEN_BESLUT" date, "LEGAL_ACT" character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Ramsar" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Ramsar"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Ramsar" IS 'Ramsar-områden (Våtmarkskonventionen)'; -- -- Name: nvr:Ramsar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Ramsar_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Ramsar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq" OWNED BY postgis."nvr:Ramsar".ogc_fid; -- -- Name: nvr:SCI_Rikstackande; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:SCI_Rikstackande" ( ogc_fid bigint NOT NULL, "NAMN" character varying(62) NOT NULL, "BEVPLAN" character varying(128) NOT NULL, "SITE_CODE" character varying(9) NOT NULL, "OMRADESTYP" character varying(16) NOT NULL, "UPPLAMNARE" character varying(62) NOT NULL, "SCI_FORSL" character varying(6) NOT NULL, "SCI_DATUM" character varying(6), "SAC_DATUM" character varying(6), "SPA_DATUM" character varying(6), "KVALITET" character varying(254) NOT NULL, "KARAKTAR" character varying(254) NOT NULL, "ARTER" character varying(254), "NATURTYPER" character varying(254), wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL ); ALTER TABLE postgis."nvr:SCI_Rikstackande" OWNER TO webmap_import; -- -- Name: TABLE "nvr:SCI_Rikstackande"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:SCI_Rikstackande" IS 'Habitatdirektivet (SCI, direktiv 92/43/EEG)'; -- -- Name: nvr:SCI_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:SCI_Rikstackande_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" OWNED BY postgis."nvr:SCI_Rikstackande".ogc_fid; -- -- Name: nvr:SPA_Rikstackande; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:SPA_Rikstackande" ( ogc_fid bigint NOT NULL, "NAMN" character varying(62) NOT NULL, "BEVPLAN" character varying(128) NOT NULL, "SITE_CODE" character varying(9) NOT NULL, "OMRADESTYP" character varying(16) NOT NULL, "UPPLAMNARE" character varying(62) NOT NULL, "SCI_FORSL" character varying(6), "SCI_DATUM" character varying(6), "SAC_DATUM" character varying(6), "SPA_DATUM" character varying(6) NOT NULL, "KVALITET" character varying(254) NOT NULL, "KARAKTAR" character varying(254) NOT NULL, "ARTER" character varying(254) NOT NULL, "NATURTYPER" character varying(254), wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL ); ALTER TABLE postgis."nvr:SPA_Rikstackande" OWNER TO webmap_import; -- -- Name: TABLE "nvr:SPA_Rikstackande"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:SPA_Rikstackande" IS 'Fågeldirektivet (SPA, direktiv 79/409/EEG)'; -- -- Name: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNED BY postgis."nvr:SPA_Rikstackande".ogc_fid; -- -- Name: nvr:Tilltradesforbud; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Tilltradesforbud" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "BESLSTAT" character varying(12) NOT NULL, "FORESKRTYP" character varying(16) NOT NULL, "FORESKRIFT" character varying(62) NOT NULL, "FRANDATUM" character varying(10) NOT NULL, "TILLDATUM" character varying(10) NOT NULL, "BESKRIVN" character varying(254), "OBJEKTNAMN" character varying(254) NOT NULL, "FORSKRNAMN" character varying(254), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Tilltradesforbud" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Tilltradesforbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Tilltradesforbud" IS 'Områden med föreskrifter som inskränker rätten att färdas eller vistas i området, permanent eller under en del av året'; -- -- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNED BY postgis."nvr:Tilltradesforbud".ogc_fid; -- -- Name: nvr:Varldsarv; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Varldsarv" ( ogc_fid bigint NOT NULL, "NAMN" character varying(64) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Varldsarv" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Varldsarv"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Varldsarv" IS 'Världsarv med mycket höga naturvärden (UNESCO)'; -- -- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Varldsarv_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" OWNED BY postgis."nvr:Varldsarv".ogc_fid; -- -- Name: nvr:Vattenskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvr:Vattenskyddsomrade" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(254) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "TILLSYNSMH" character varying(64) NOT NULL, "PROVNMHDIS" character varying(64), "PROVNMHTIL" character varying(64), "IUCNKAT" character varying(254) NOT NULL, "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(16), "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvr:Vattenskyddsomrade" OWNER TO webmap_import; -- -- Name: TABLE "nvr:Vattenskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvr:Vattenskyddsomrade" IS 'Vattenskyddsområden'; -- -- Name: nvr:Vattenskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Vattenskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Vattenskyddsomrade".ogc_fid; -- -- Name: ren:omr_riks; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."ren:omr_riks" ( ogc_fid bigint NOT NULL, "LANK" character varying(254) NOT NULL, "LANSKOD" character varying(25) NOT NULL, "OMR_NR" integer, "ARET_RUNT" integer, "SAMEBY" character varying(62) NOT NULL, "ANSVARIG" character varying(25) NOT NULL, "AKTUALITET" date NOT NULL, "SIGNATUR" character varying(25), "GlobalID" uuid NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."ren:omr_riks" OWNER TO webmap_import; -- -- Name: TABLE "ren:omr_riks"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."ren:omr_riks" IS 'Riksintresse Rennäringen — Kärnområde'; -- -- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."ren:omr_riks_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" OWNED BY postgis."ren:omr_riks".ogc_fid; -- -- Name: ren:riks_ren; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."ren:riks_ren" ( ogc_fid bigint NOT NULL, "LAGRUM" character varying(254) NOT NULL, "AKTUALITET" date NOT NULL, "SIGNATUR" character varying(25) NOT NULL, "LANK" character varying(254), "GlobalID" uuid NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."ren:riks_ren" OWNER TO webmap_import; -- -- Name: TABLE "ren:riks_ren"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."ren:riks_ren" IS 'Riksintresse Rennäringen'; -- -- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."ren:riks_ren_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren".ogc_fid; -- -- Name: ri:friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."ri:friluftsliv" ( ogc_fid bigint NOT NULL, "SKYDD" character varying(64) NOT NULL, "OMRADESNR" character varying(16) NOT NULL, "AMNESOMR" character varying(16) NOT NULL, "NAMN" character varying(127) NOT NULL, "LANK_VARDE" character varying(127) NOT NULL, "BESLDATUM" date, "LAGRUM" character varying(64) NOT NULL, "ARENDENR" character varying(11) NOT NULL, "LANK_BESLU" character varying(127) NOT NULL, "AKTIVITET" character varying(127), "NATURTYP" character varying(127), "AREA_LAND_" double precision, "AREA_VATTE" double precision, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."ri:friluftsliv" OWNER TO webmap_import; -- -- Name: TABLE "ri:friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."ri:friluftsliv" IS 'Riksintresse friluftsliv'; -- -- Name: ri:friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."ri:friluftsliv_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: ri:friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" OWNED BY postgis."ri:friluftsliv".ogc_fid; -- -- Name: ri:naturvard; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."ri:naturvard" ( ogc_fid bigint NOT NULL, "SKYDD" character varying(64) NOT NULL, "AMNESOMRAD" character varying(64) NOT NULL, "NAMN" character varying(127) NOT NULL, "BESKRIVNIN" character varying(254) NOT NULL, "LAGRUM" character varying(64) NOT NULL, "BESLUTSDAT" date NOT NULL, "ORGINALID" character varying(16) NOT NULL, "RIKSID" integer NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."ri:naturvard" OWNER TO webmap_import; -- -- Name: TABLE "ri:naturvard"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."ri:naturvard" IS 'Riksintresse naturvård'; -- -- Name: ri:naturvard_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."ri:naturvard_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."ri:naturvard_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: ri:naturvard_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."ri:naturvard_ogc_fid_seq" OWNED BY postgis."ri:naturvard".ogc_fid; -- -- Name: ri:obruten_kust; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."ri:obruten_kust" ( ogc_fid bigint NOT NULL, "ORIGINALID" character varying(16), "NAMN" character varying(64), "BESKRIVNIN" character varying(254), "METODBESKR" character varying(254), "TILLKDATUM" date, "REVDATUM" date, "ANM" character varying(254), "OBJTYP" character varying(254), "OBJEKTLANK" character varying(254), "REFERENS" character varying(254), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."ri:obruten_kust" OWNER TO webmap_import; -- -- Name: TABLE "ri:obruten_kust"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."ri:obruten_kust" IS 'Obruten kust (MB 4 kap 3§)'; -- -- Name: ri:obruten_kust_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."ri:obruten_kust_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: ri:obruten_kust_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" OWNED BY postgis."ri:obruten_kust".ogc_fid; -- -- Name: ri:obrutet_fjall; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."ri:obrutet_fjall" ( ogc_fid bigint NOT NULL, "ORIGINALID" character varying(16), "NAMN" character varying(64) NOT NULL, "BESKRIVNIN" character varying(254), "METODBESKR" character varying(254), "TILLKDATUM" date, "REVDATUM" date, "OBJEKTLANK" character varying(254), "REFERENS" character varying(254), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."ri:obrutet_fjall" OWNER TO webmap_import; -- -- Name: TABLE "ri:obrutet_fjall"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."ri:obrutet_fjall" IS 'Obrutet fjäll (MB 4 kap 5§)'; -- -- Name: ri:obrutet_fjall_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."ri:obrutet_fjall_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: ri:obrutet_fjall_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" OWNED BY postgis."ri:obrutet_fjall".ogc_fid; -- -- Name: ri:rorligt_friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."ri:rorligt_friluftsliv" ( ogc_fid bigint NOT NULL, "ORIGINALID" character varying(16), "NAMN" character varying(64), "BESKRIVNIN" character varying(254), "METODBESKR" character varying(254), "TILLKDATUM" date, "REVDATUM" date, "ANM" character varying(254), "OBJEKTLANK" character varying(254), "REFERENS" character varying(254), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."ri:rorligt_friluftsliv" OWNER TO webmap_import; -- -- Name: TABLE "ri:rorligt_friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."ri:rorligt_friluftsliv" IS 'Rörligt friluftsliv (MB 4 kap 1§ och 2§)'; -- -- Name: ri:rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: ri:rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" OWNED BY postgis."ri:rorligt_friluftsliv".ogc_fid; -- -- Name: ri:skyddade_vattendrag; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."ri:skyddade_vattendrag" ( ogc_fid bigint NOT NULL, "ORIGINALID" character varying(16), "NAMN" character varying(64) NOT NULL, "BESKRIVNIN" character varying(254), "METODBESKR" character varying(254), "TILLKDATUM" date, "REVDATUM" date, "ANM" character varying(254), "DIG_SKALA" integer, "OBJEKTLANK" character varying(254), "REFERENS" character varying(254), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."ri:skyddade_vattendrag" OWNER TO webmap_import; -- -- Name: TABLE "ri:skyddade_vattendrag"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."ri:skyddade_vattendrag" IS 'Skyddade vattendrag (MB 4 kap 6§)'; -- -- Name: ri:skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."ri:skyddade_vattendrag_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: ri:skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" OWNED BY postgis."ri:skyddade_vattendrag".ogc_fid; -- -- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sametinget:betesomraden" ( ogc_fid bigint NOT NULL, "SAMEBY_ID" integer NOT NULL, "BY_ID" integer, "NAMN" character varying(62) NOT NULL, "SIGNATUR" character varying(25) NOT NULL, "SAMEBY_TYP" character varying(62) NOT NULL, "BY_OMR" boolean NOT NULL, "OVR_OMR" boolean NOT NULL, "AKTUALITET" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."sametinget:betesomraden" OWNER TO webmap_import; -- -- Name: TABLE "sametinget:betesomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sametinget:betesomraden" IS 'Samebyarnas betesområden: Renbetesområden'; -- -- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sametinget:betesomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" OWNED BY postgis."sametinget:betesomraden".ogc_fid; -- -- Name: sametinget:flyttled; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sametinget:flyttled" ( ogc_fid bigint NOT NULL, "LED_ID" integer NOT NULL, "BYNR1" integer NOT NULL, "BYNR2" integer NOT NULL, "BYNR3" integer NOT NULL, "SAMEBY1" character varying(62), "SAMEBY2" character varying(62), "SAMEBY3" character varying(62), "KKOD" integer NOT NULL, "BESKRIVNIN" character varying(62), "ARSTID" character varying(62), "KONV_AR" character varying(62), "SIGNATUR" character varying(25), "RIKSINTR" boolean NOT NULL, "FAST_LED" boolean NOT NULL, "AKTUALITET" character varying(10), "GlobalID" uuid NOT NULL, wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL ); ALTER TABLE postgis."sametinget:flyttled" OWNER TO webmap_import; -- -- Name: TABLE "sametinget:flyttled"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sametinget:flyttled" IS 'Samebyarnas markanvändningsredovisning: Flyttled'; -- -- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sametinget:flyttled_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" OWNED BY postgis."sametinget:flyttled".ogc_fid; -- -- Name: sks:AvverkAnm; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:AvverkAnm" ( ogc_fid bigint NOT NULL, "OBJECTID" integer NOT NULL, "Beteckn" character varying(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) NOT NULL ); 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 varying(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) NOT NULL ); 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: svk:ledningar; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."svk:ledningar" ( ogc_fid bigint NOT NULL, "Placement" character varying(32), "Voltage" integer, wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL ); ALTER TABLE postgis."svk:ledningar" OWNER TO webmap_import; -- -- Name: TABLE "svk:ledningar"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."svk:ledningar" IS 'Kraftledningar (befintliga)'; -- -- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."svk:ledningar_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."svk:ledningar_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."svk:ledningar_ogc_fid_seq" OWNED BY postgis."svk:ledningar".ogc_fid; -- -- Name: svk:stationsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."svk:stationsomraden" ( ogc_fid bigint NOT NULL, wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL ); ALTER TABLE postgis."svk:stationsomraden" OWNER TO webmap_import; -- -- Name: TABLE "svk:stationsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."svk:stationsomraden" IS 'Stationsomraden'; -- -- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."svk:stationsomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" OWNED BY postgis."svk:stationsomraden".ogc_fid; -- -- Name: svk:stolpar; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."svk:stolpar" ( ogc_fid bigint NOT NULL, wkb_geometry postgis.geometry(PointZ,3006) NOT NULL ); ALTER TABLE postgis."svk:stolpar" OWNER TO webmap_import; -- -- Name: TABLE "svk:stolpar"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."svk:stolpar" IS 'Stolpar (befintliga)'; -- -- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."svk:stolpar_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."svk:stolpar_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."svk:stolpar_ogc_fid_seq" OWNED BY postgis."svk:stolpar".ogc_fid; -- -- Name: svk:transmissionsnatsprojekt; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."svk:transmissionsnatsprojekt" ( ogc_fid bigint NOT NULL, "Name" character varying(254), "Voltage" integer, "Url" character varying(254), wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL ); ALTER TABLE postgis."svk:transmissionsnatsprojekt" OWNER TO webmap_import; -- -- Name: TABLE "svk:transmissionsnatsprojekt"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."svk:transmissionsnatsprojekt" IS 'Transmissionsnätsprojekt'; -- -- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNED BY postgis."svk:transmissionsnatsprojekt".ogc_fid; -- -- Name: vbk:havsbaserad_vindkraft; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."vbk:havsbaserad_vindkraft" ( ogc_fid bigint NOT NULL, "OmrID" character varying(10) NOT NULL, "Projektnamn" character varying(62), "Organisationsnamn" character varying(254), "Organisationsnummer" character varying(11), "Projektstatus" character varying(62) NOT NULL, "Diarienummer" character varying(254), "AndringsansokanPagar" boolean, "SamradsunderlagInlamnat" date, "AnsokanInlamnat" date, "AnsokanAterkallad" date, "AnsokanBeviljad" date, "AnsokanAvslagen" date, "AnsokanOverklagad" date, "Natura2000_Ansokan" character varying(62) NOT NULL, "Natura2000_Beslutdatum" date, "UnderByggnation" boolean, "Uppfort" date, "PlaneratAntalVerkMin" smallint, "PlaneratAntalVerkMax" smallint, "PlaneradHojdMin" smallint, "PlaneradHojdMax" smallint, "PlaneradProduktionMin" real, "PlaneradProduktionMax" real, "PlaneradByggstart" date, "PlaneratDrift" date, "BeviljatAntalVerk" smallint, "UppfortAntalVerk" smallint, "BeviljadMaxhojd" smallint, "InstalleradEffekt" real, "Calprod" real, "ElNamn" character varying(62) NOT NULL, "SenasteUppdaterat" date NOT NULL, "Raderat" boolean NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."vbk:havsbaserad_vindkraft" OWNER TO webmap_import; -- -- Name: TABLE "vbk:havsbaserad_vindkraft"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."vbk:havsbaserad_vindkraft" IS 'Vindbrukskollen havsbaserad vindkraft (Länsstyrelsen)'; -- -- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNED BY postgis."vbk:havsbaserad_vindkraft".ogc_fid; -- -- Name: vbk:projekteringsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."vbk:projekteringsomraden" ( ogc_fid bigint NOT NULL, "OmrID" character varying(10) NOT NULL, "Projektnamn" character varying(62), "AntalVerk" smallint NOT NULL, "AntalEjXY" smallint NOT NULL, "Calprod" real, "PlaneradByggstart" date, "PlaneratDrift" date, "AndringsansokanPagar" boolean, "UnderByggnation" boolean, "Organisationsnamn" character varying(254), "Organisationsnummer" character varying(11), "ElNamn" character varying(62) NOT NULL, "SenasteUppdaterat" date, "EjAktuell" boolean NOT NULL, "Raderat" boolean NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."vbk:projekteringsomraden" OWNER TO webmap_import; -- -- Name: TABLE "vbk:projekteringsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."vbk:projekteringsomraden" IS 'Vindbrukskollen landbaserade projekteringsområden (Länsstyrelsen)'; -- -- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNED BY postgis."vbk:projekteringsomraden".ogc_fid; -- -- Name: vbk:vindkraftverk; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."vbk:vindkraftverk" ( ogc_fid bigint NOT NULL, "VerkID" character varying(14) NOT NULL, "OmrID" character varying(10) NOT NULL, "Projektnamn" character varying(62), "Status" character varying(62) NOT NULL, "Statuskod" smallint NOT NULL, "Handlingstyp" character varying(62), "Uppfort" date, "MB_Tillstand" date, "Totalhojd" smallint, "Navhojd" smallint, "Rotordiameter" smallint, "Maxeffekt" real, "Calprod" real, "Fabrikat" character varying(62), "Modell" character varying(62), "Organisationsnamn" character varying(254), "Organisationsnummer" character varying(11), "Placering" character varying(62), "ElNamn" character varying(62) NOT NULL, "SenasteUppdaterat" date, "EjAktuell" boolean, "Raderat" boolean NOT NULL, wkb_geometry postgis.geometry(Point,3006) NOT NULL ); ALTER TABLE postgis."vbk:vindkraftverk" OWNER TO webmap_import; -- -- Name: TABLE "vbk:vindkraftverk"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."vbk:vindkraftverk" IS 'Vindbrukskollen landbaserade vindkraftverk (Länsstyrelsen)'; -- -- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNED BY postgis."vbk:vindkraftverk".ogc_fid; -- -- Name: dammar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis.dammar ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.dammar_ogc_fid_seq'::regclass); -- -- Name: gigafactories ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis.gigafactories ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.gigafactories_ogc_fid_seq'::regclass); -- -- Name: kommunyta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis.kommunyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.kommunyta_ogc_fid_seq'::regclass); -- -- Name: 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_punkt ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_punkt_ogc_fid_seq"'::regclass); -- -- Name: nvr:Naturminne_yta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Naturminne_yta" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_yta_ogc_fid_seq"'::regclass); -- -- Name: nvr:Naturreservat ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Naturreservat" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturreservat_ogc_fid_seq"'::regclass); -- -- Name: nvr:Naturvardsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Naturvardsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturvardsomrade_ogc_fid_seq"'::regclass); -- -- Name: nvr:OSPAR ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:OSPAR" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:OSPAR_ogc_fid_seq"'::regclass); -- -- Name: nvr:Ovrigt_biotopskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Ovrigt_biotopskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq"'::regclass); -- -- Name: nvr:Ramsar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Ramsar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Ramsar_ogc_fid_seq"'::regclass); -- -- Name: nvr:SCI_Rikstackande ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:SCI_Rikstackande" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:SCI_Rikstackande_ogc_fid_seq"'::regclass); -- -- Name: nvr:SPA_Rikstackande ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:SPA_Rikstackande" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:SPA_Rikstackande_ogc_fid_seq"'::regclass); -- -- Name: nvr:Tilltradesforbud ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Tilltradesforbud" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Tilltradesforbud_ogc_fid_seq"'::regclass); -- -- Name: nvr:Varldsarv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Varldsarv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Varldsarv_ogc_fid_seq"'::regclass); -- -- Name: nvr:Vattenskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- ALTER TABLE ONLY postgis."nvr:Vattenskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Vattenskyddsomrade_ogc_fid_seq"'::regclass); -- -- Name: ren:omr_riks ogc_f