-- -- PostgreSQL database dump -- -- Dumped from database version 15.6 (Debian 15.6-0+deb12u1) -- Dumped by pg_dump version 15.6 (Debian 15.6-0+deb12u1) 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: 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, "Skogstyp" character varying(254) NOT NULL, "Inkomdatum" date NOT NULL, "AnmaldHa" real NOT NULL, "SkogsodlHa" real NOT NULL, "NatforHa" real NOT NULL, "AvvSasong" character varying(254) NOT NULL, "ArendeStat" character varying(254) NOT NULL, "AvvHa" real, "Avverkning" 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: 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: 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: 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 "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 --