-- -- PostgreSQL database dump -- -- Dumped from database version 15.13 (Debian 15.13-0+deb12u1) -- Dumped by pg_dump version 15.13 (Debian 15.13-0+deb12u1) SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; DROP DATABASE webmap; -- -- Name: webmap; Type: DATABASE; Schema: -; Owner: postgres -- CREATE DATABASE webmap WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = icu LOCALE = 'sv_SE.UTF-8' ICU_LOCALE = 'sv-SE-x-icu'; ALTER DATABASE webmap OWNER TO postgres; \connect webmap SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Name: DATABASE webmap; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON DATABASE webmap IS 'Backend PostGIS database for KlimatanalysNorr tooling'; -- -- Name: postgis; Type: SCHEMA; Schema: -; Owner: postgres -- CREATE SCHEMA postgis; ALTER SCHEMA postgis OWNER TO postgres; -- -- Name: postgis; Type: EXTENSION; Schema: -; Owner: - -- CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA postgis; -- -- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: -- COMMENT ON EXTENSION postgis IS 'Geographic objects support for PostgreSQL'; -- -- Name: get_counties(postgis.geometry); Type: FUNCTION; Schema: postgis; Owner: postgres -- CREATE FUNCTION postgis.get_counties(postgis.geometry) RETURNS smallint[] LANGUAGE sql IMMUTABLE STRICT PARALLEL SAFE AS $_$ SELECT array_agg(DISTINCT t.lanskod ORDER BY t.lanskod) FROM postgis.lansyta_sub t -- Make use of spactial indices: filter out non-overlapping envelopes first. -- This function works for curves and points too, as the interior of a curve -- is the set of points between its endpoints, and the interior of a point is -- the point itself. It also works for 3D input geometries (in that case the -- Z component is dropped). -- TODO we might want to check '*T*******' too (so a line exactly on a -- boundary segment would belong to both counties) WHERE t.wkb_geometry && $1 AND ST_Relate(t.wkb_geometry, $1, 'T********') $_$; ALTER FUNCTION postgis.get_counties(postgis.geometry) OWNER TO postgres; -- -- Name: get_municipalities(postgis.geometry); Type: FUNCTION; Schema: postgis; Owner: postgres -- CREATE FUNCTION postgis.get_municipalities(postgis.geometry) RETURNS smallint[] LANGUAGE sql IMMUTABLE STRICT PARALLEL SAFE AS $_$ SELECT array_agg(DISTINCT t.kommunkod ORDER BY t.kommunkod) FROM postgis.kommunyta_sub t -- Make use of spactial indices: filter out non-overlapping envelopes first. -- This function works for curves and points too, as the interior of a curve -- is the set of points between its endpoints, and the interior of a point is -- the point itself. It also works for 3D input geometries (in that case the -- Z component is dropped). -- TODO we might want to check '*T*******' too (so a line exactly on a -- boundary segment would belong to both municipalities) WHERE t.wkb_geometry && $1 AND ST_Relate(t.wkb_geometry, $1, 'T********') $_$; ALTER FUNCTION postgis.get_municipalities(postgis.geometry) OWNER TO postgres; -- -- Name: kommunyta_subdivide_func(); Type: FUNCTION; Schema: postgis; Owner: webmap_import -- CREATE FUNCTION postgis.kommunyta_subdivide_func() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN -- Propagate changes to postgis.kommunyta to postgis.kommunyta_sub IF (TG_OP = 'DELETE' OR TG_OP = 'UPDATE') THEN DELETE FROM postgis.kommunyta_sub WHERE kommunkod = OLD.kommunkod; END IF; IF (TG_OP = 'UPDATE' OR TG_OP = 'INSERT') THEN INSERT INTO postgis.kommunyta_sub(kommunkod, wkb_geometry) VALUES (NEW.kommunkod, postgis.ST_Subdivide(NEW.wkb_geometry, 10)); END IF; RETURN NULL; END; $$; ALTER FUNCTION postgis.kommunyta_subdivide_func() OWNER TO webmap_import; -- -- Name: lansyta_subdivide_func(); Type: FUNCTION; Schema: postgis; Owner: webmap_import -- CREATE FUNCTION postgis.lansyta_subdivide_func() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN -- Propagate changes to postgis.lansyta to postgis.lansyta_sub IF (TG_OP = 'DELETE' OR TG_OP = 'UPDATE') THEN DELETE FROM postgis.lansyta_sub WHERE lanskod = OLD.lanskod; END IF; IF (TG_OP = 'UPDATE' OR TG_OP = 'INSERT') THEN INSERT INTO postgis.lansyta_sub(lanskod, wkb_geometry) VALUES (NEW.lanskod, postgis.ST_Subdivide(NEW.wkb_geometry, 10)); END IF; RETURN NULL; END; $$; ALTER FUNCTION postgis.lansyta_subdivide_func() OWNER TO webmap_import; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: dammar; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.dammar ( ogc_fid bigint NOT NULL, "DammID" uuid NOT NULL, "LST_OBJID" character varying(32), "Datum" date NOT NULL, "DNamn" character varying(64), "Status" smallint NOT NULL, "Regleringstyp" smallint NOT NULL, "Konstruktion" smallint NOT NULL, "ByggAr" smallint, "DammHojd" real, "KronLangd" real, "Fiskvag" smallint NOT NULL, "FiskvagByggAr" smallint, "Fiskavledare" smallint, "Vandringshinder" boolean NOT NULL, "HARO" integer NOT NULL, "Vattendistrikt" character varying(10) NOT NULL, inrapp_lst character varying(32) NOT NULL, eu_cd character varying(32), vf_typ character varying(1), vy_eucd character varying(32), vy_vf_typ character varying(1), "DammanlID" character varying(64), "Namn" character varying(64), "Verksamhet" smallint, "OmbyggAr" smallint, "DG" real, "SG" real, "HojdSys" smallint, "MY" double precision, "RV" double precision, "Kommentar" character varying(254), "XX_Distance" double precision, wkb_geometry postgis.geometry(Point,3006) NOT NULL ); ALTER TABLE postgis.dammar OWNER TO webmap_import; -- -- Name: TABLE dammar; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis.dammar IS 'Dammar'; -- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.dammar_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.dammar_ogc_fid_seq OWNER TO webmap_import; -- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.dammar_ogc_fid_seq OWNED BY postgis.dammar.ogc_fid; -- -- Name: gigafactories; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.gigafactories ( ogc_fid bigint NOT NULL, "Name" character varying(254), "Url" character varying(254), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis.gigafactories OWNER TO webmap_import; -- -- Name: TABLE gigafactories; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis.gigafactories IS 'Stora industrisatsningar'; -- -- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.gigafactories_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import; -- -- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.gigafactories_ogc_fid_seq OWNED BY postgis.gigafactories.ogc_fid; -- -- Name: kommunyta; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.kommunyta ( ogc_fid bigint NOT NULL, objektidentitet uuid, skapad timestamp without time zone, kommunkod smallint NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis.kommunyta OWNER TO webmap_import; -- -- Name: TABLE kommunyta; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis.kommunyta IS 'Sveriges kommuner (Lantmäteriet)'; -- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.kommunyta_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.kommunyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.kommunyta_ogc_fid_seq OWNED BY postgis.kommunyta.ogc_fid; -- -- Name: kommunyta_sub; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.kommunyta_sub ( ogc_fid bigint NOT NULL, kommunkod smallint NOT NULL, wkb_geometry postgis.geometry(Polygon,3006) NOT NULL ); ALTER TABLE postgis.kommunyta_sub OWNER TO webmap_import; -- -- Name: kommunyta_sub_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.kommunyta_sub_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.kommunyta_sub_ogc_fid_seq OWNER TO webmap_import; -- -- Name: kommunyta_sub_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.kommunyta_sub_ogc_fid_seq OWNED BY postgis.kommunyta_sub.ogc_fid; -- -- Name: lansyta; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.lansyta ( ogc_fid bigint NOT NULL, objektidentitet uuid, skapad timestamp without time zone, lanskod smallint NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis.lansyta OWNER TO webmap_import; -- -- Name: TABLE lansyta; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis.lansyta IS 'Sveriges län (Lantmäteriet)'; -- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.lansyta_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.lansyta_ogc_fid_seq OWNED BY postgis.lansyta.ogc_fid; -- -- Name: lansyta_sub; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis.lansyta_sub ( ogc_fid bigint NOT NULL, lanskod smallint NOT NULL, wkb_geometry postgis.geometry(Polygon,3006) NOT NULL ); ALTER TABLE postgis.lansyta_sub OWNER TO webmap_import; -- -- Name: lansyta_sub_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis.lansyta_sub_ogc_fid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis.lansyta_sub_ogc_fid_seq OWNER TO webmap_import; -- -- Name: lansyta_sub_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis.lansyta_sub_ogc_fid_seq OWNED BY postgis.lansyta_sub.ogc_fid; -- -- Name: lst:pagaende_naturreservatsbildning; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."lst:pagaende_naturreservatsbildning" ( ogc_fid bigint NOT NULL, "NAMN" character varying(62) NOT NULL, "GRANSJUST" date, "DOS_ID" integer, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."lst:pagaende_naturreservatsbildning" OWNER TO webmap_import; -- -- Name: TABLE "lst:pagaende_naturreservatsbildning"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."lst:pagaende_naturreservatsbildning" IS 'LstBD Pågående naturreservatsbildning'; -- -- Name: lst:pagaende_naturreservatsbildning_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:pagaende_naturreservatsbildning_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" OWNED BY postgis."lst:pagaende_naturreservatsbildning".ogc_fid; -- -- Name: lst:riksintresse_obruten_kust; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."lst:riksintresse_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."lst:riksintresse_obruten_kust" OWNER TO webmap_import; -- -- Name: TABLE "lst:riksintresse_obruten_kust"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."lst:riksintresse_obruten_kust" IS 'Obruten kust (MB 4 kap 3 §)'; -- -- Name: lst:riksintresse_obruten_kust_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:riksintresse_obruten_kust_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" OWNED BY postgis."lst:riksintresse_obruten_kust".ogc_fid; -- -- Name: lst:riksintresse_obrutet_fjall; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."lst:riksintresse_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."lst:riksintresse_obrutet_fjall" OWNER TO webmap_import; -- -- Name: TABLE "lst:riksintresse_obrutet_fjall"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."lst:riksintresse_obrutet_fjall" IS 'Obrutet fjäll (MB 4 kap 5 §)'; -- -- Name: lst:riksintresse_obrutet_fjall_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:riksintresse_obrutet_fjall_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" OWNED BY postgis."lst:riksintresse_obrutet_fjall".ogc_fid; -- -- Name: lst:riksintresse_rorligt_friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."lst:riksintresse_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."lst:riksintresse_rorligt_friluftsliv" OWNER TO webmap_import; -- -- Name: TABLE "lst:riksintresse_rorligt_friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."lst:riksintresse_rorligt_friluftsliv" IS 'Rörligt friluftsliv (MB 4 kap 1 och 2 §§)'; -- -- Name: lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" OWNED BY postgis."lst:riksintresse_rorligt_friluftsliv".ogc_fid; -- -- Name: lst:riksintresse_skyddade_vattendrag; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."lst:riksintresse_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."lst:riksintresse_skyddade_vattendrag" OWNER TO webmap_import; -- -- Name: TABLE "lst:riksintresse_skyddade_vattendrag"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."lst:riksintresse_skyddade_vattendrag" IS 'Skyddade vattendrag (MB 4 kap 6 §)'; -- -- Name: lst:riksintresse_skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:riksintresse_skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" OWNED BY postgis."lst:riksintresse_skyddade_vattendrag".ogc_fid; -- -- Name: mrr:bearbetningskoncessioner_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:bearbetningskoncessioner_ansokta" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, diarynr character varying(16) NOT NULL, appl_date date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:bearbetningskoncessioner_ansokta" OWNER TO webmap_import; -- -- Name: TABLE "mrr:bearbetningskoncessioner_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_ansokta" IS 'Bearbetningskoncessioner, ansökta (SGU)'; -- -- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_ansokta".ogc_fid; -- -- Name: mrr:bearbetningskoncessioner_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:bearbetningskoncessioner_beviljade" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, licenceid character varying(16), diarynr character varying(16) NOT NULL, appl_date date NOT NULL, dec_date date NOT NULL, validfrom date NOT NULL, validto date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:bearbetningskoncessioner_beviljade" OWNER TO webmap_import; -- -- Name: TABLE "mrr:bearbetningskoncessioner_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_beviljade" IS 'Bearbetningskoncessioner, beviljade (SGU)'; -- -- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_beviljade".ogc_fid; -- -- Name: mrr:bearbetningskoncessioner_forfallna; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:bearbetningskoncessioner_forfallna" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, licenceid character varying(16), diarynr character varying(16) NOT NULL, appl_date date, mineral character varying(254) NOT NULL, owners character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:bearbetningskoncessioner_forfallna" OWNER TO webmap_import; -- -- Name: TABLE "mrr:bearbetningskoncessioner_forfallna"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_forfallna" IS 'Bearbetningskoncessioner, förfallna (SGU)'; -- -- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_forfallna".ogc_fid; -- -- Name: mrr:markanvisningar_bk_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:markanvisningar_bk_ansokta" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, diarynr character varying(16) NOT NULL, conc_name character varying(254) NOT NULL, appl_date date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:markanvisningar_bk_ansokta" OWNER TO webmap_import; -- -- Name: TABLE "mrr:markanvisningar_bk_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:markanvisningar_bk_ansokta" IS 'Markanvisningar till bearbetningskoncessioner, ansökta (SGU)'; -- -- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:markanvisningar_bk_ansokta".ogc_fid; -- -- Name: mrr:markanvisningar_bk_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:markanvisningar_bk_beviljade" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, licenceid character varying(16), diarynr character varying(16) NOT NULL, conc_name character varying(254) NOT NULL, appl_date date NOT NULL, dec_date date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:markanvisningar_bk_beviljade" OWNER TO webmap_import; -- -- Name: TABLE "mrr:markanvisningar_bk_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:markanvisningar_bk_beviljade" IS 'Markanvisningar till bearbetningskoncessioner, beviljade (SGU)'; -- -- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:markanvisningar_bk_beviljade".ogc_fid; -- -- Name: mrr:ut_diamant_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:ut_diamant_ansokta" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, diarynr character varying(16) NOT NULL, appl_date date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:ut_diamant_ansokta" OWNER TO webmap_import; -- -- Name: TABLE "mrr:ut_diamant_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:ut_diamant_ansokta" IS 'Undersökningstillstånd - Diamant, ansökta (SGU)'; -- -- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:ut_diamant_ansokta".ogc_fid; -- -- Name: mrr:ut_diamant_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:ut_diamant_beviljade" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, licenceid character varying(16), diarynr character varying(16) NOT NULL, appl_date date NOT NULL, dec_date date NOT NULL, validfrom date NOT NULL, validto date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:ut_diamant_beviljade" OWNER TO webmap_import; -- -- Name: TABLE "mrr:ut_diamant_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:ut_diamant_beviljade" IS 'Undersökningstillstånd - Diamant, beviljade (SGU)'; -- -- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:ut_diamant_beviljade".ogc_fid; -- -- Name: mrr:ut_diamant_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:ut_diamant_forbud" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, licenceid character varying(16), diarynr character varying(16) NOT NULL, validfrom date NOT NULL, validto date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(254) NOT NULL, prospdata_url character varying(254), prospdata_filesize_mb real, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:ut_diamant_forbud" OWNER TO webmap_import; -- -- Name: TABLE "mrr:ut_diamant_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:ut_diamant_forbud" IS 'Undersökningstillstånd - Diamant, förbud (SGU)'; -- -- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" OWNED BY postgis."mrr:ut_diamant_forbud".ogc_fid; -- -- Name: mrr:ut_metaller_industrimineral_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, diarynr character varying(16) NOT NULL, appl_date date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" OWNER TO webmap_import; -- -- Name: TABLE "mrr:ut_metaller_industrimineral_ansokta"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" IS 'Undersökningstillstånd - Metaller och industrimineral, ansökta (SGU)'; -- -- Name: mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_ansokta".ogc_fid; -- -- Name: mrr:ut_metaller_industrimineral_beviljade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, licenceid character varying(16), diarynr character varying(16) NOT NULL, appl_date date NOT NULL, dec_date date NOT NULL, validfrom date NOT NULL, validto date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" OWNER TO webmap_import; -- -- Name: TABLE "mrr:ut_metaller_industrimineral_beviljade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" IS 'Undersökningstillstånd - Metaller och industrimineral, beviljade (SGU)'; -- -- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_beviljade".ogc_fid; -- -- Name: mrr:ut_metaller_industrimineral_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:ut_metaller_industrimineral_forbud" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, licenceid character varying(16), diarynr character varying(16) NOT NULL, validfrom date NOT NULL, validto date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(254) NOT NULL, prospdata_url character varying(254), prospdata_filesize_mb real, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud" OWNER TO webmap_import; -- -- Name: TABLE "mrr:ut_metaller_industrimineral_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forbud" IS 'Undersökningstillstånd - Metaller och industrimineral, förbud (SGU)'; -- -- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_forbud".ogc_fid; -- -- Name: mrr:ut_metaller_industrimineral_forfallna; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, licenceid character varying(16), diarynr character varying(16) NOT NULL, validfrom date NOT NULL, validto date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(510) NOT NULL, prospdata_url character varying(254), prospdata_filesize_mb real, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" OWNER TO webmap_import; -- -- Name: TABLE "mrr:ut_metaller_industrimineral_forfallna"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" IS 'Undersökningstillstånd - Metaller och industrimineral, förfallna (SGU)'; -- -- Name: mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_forfallna".ogc_fid; -- -- Name: mrr:ut_olja_gas_diamant_forfallna; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" ( ogc_fid bigint NOT NULL, name character varying(254) NOT NULL, licenceid character varying(16), diarynr character varying(16) NOT NULL, validfrom date NOT NULL, validto date NOT NULL, mineral character varying(254) NOT NULL, owners character varying(510) NOT NULL, prospdata_url character varying(254), prospdata_filesize_mb real, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" OWNER TO webmap_import; -- -- Name: TABLE "mrr:ut_olja_gas_diamant_forfallna"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" IS 'Undersökningstillstånd - Olja, gas och diamant, förfallna (SGU)'; -- -- Name: mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" OWNED BY postgis."mrr:ut_olja_gas_diamant_forfallna".ogc_fid; -- -- Name: nvk:naturvardsavtal; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvk:naturvardsavtal" ( ogc_fid bigint NOT NULL, "ID" integer NOT NULL, "DIARIENRNV" character varying(12) NOT NULL, "STATUS" character varying(32) NOT NULL, "OBJNAMN" character varying(64), "FASTBET" character varying(64), "DATSTART" date NOT NULL, "DATSLUT" date NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvk:naturvardsavtal" OWNER TO webmap_import; -- -- Name: TABLE "nvk:naturvardsavtal"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvk:naturvardsavtal" IS 'Naturvårdsavtal (Naturvårdsverket, Länsstyrelse)'; -- -- Name: nvk:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvk:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNED BY postgis."nvk:naturvardsavtal".ogc_fid; -- -- Name: nvk:riksintresse_friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvk:riksintresse_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."nvk:riksintresse_friluftsliv" OWNER TO webmap_import; -- -- Name: TABLE "nvk:riksintresse_friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvk:riksintresse_friluftsliv" IS 'Riksintresse friluftsliv'; -- -- Name: nvk:riksintresse_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvk:riksintresse_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" OWNED BY postgis."nvk:riksintresse_friluftsliv".ogc_fid; -- -- Name: nvk:riksintresse_naturvard; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvk:riksintresse_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."nvk:riksintresse_naturvard" OWNER TO webmap_import; -- -- Name: TABLE "nvk:riksintresse_naturvard"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvk:riksintresse_naturvard" IS 'Riksintresse naturvård'; -- -- Name: nvk:riksintresse_naturvard_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvk:riksintresse_naturvard_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNED BY postgis."nvk:riksintresse_naturvard".ogc_fid; -- -- Name: nvk:skyddsvard_statlig_skog; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."nvk:skyddsvard_statlig_skog" ( ogc_fid bigint NOT NULL, "ID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, "AR" smallint NOT NULL, "NATURGEOGR" character varying(62), "OBJEKTKATE" character varying(12), "MARKAGARE" character varying(254), "VARDEKARNA" double precision NOT NULL, "UTV_MARK" double precision NOT NULL, "TOTAL_AREA" double precision NOT NULL, "LAND" double precision NOT NULL, "VATTEN" double precision NOT NULL, "PROD_SKOG" double precision NOT NULL, "SKOG_O_FJG" double precision NOT NULL, "SKOG_N_FJG" double precision NOT NULL, "SKYDDSZON" double precision NOT NULL, "ARRO_MARK" double precision NOT NULL, "KRITERIER" character varying(254) NOT NULL, "BESKRIVN" character varying(254) NOT NULL, "LST_BEDOMN" character varying(254) NOT NULL, "KALLOR" character varying(254), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."nvk:skyddsvard_statlig_skog" OWNER TO webmap_import; -- -- Name: TABLE "nvk:skyddsvard_statlig_skog"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."nvk:skyddsvard_statlig_skog" IS 'Skyddsvärda statliga skogar'; -- -- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNED BY postgis."nvk:skyddsvard_statlig_skog".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: sametinget:betesomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sametinget:betesomrade" ( 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:betesomrade" OWNER TO webmap_import; -- -- Name: TABLE "sametinget:betesomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sametinget:betesomrade" IS 'Samebyarnas betesområden: Renbetesområden'; -- -- Name: sametinget:betesomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sametinget:betesomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:betesomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" OWNED BY postgis."sametinget:betesomrade".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: sametinget:riksintresse_rennaringen; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sametinget:riksintresse_rennaringen" ( ogc_fid bigint NOT NULL, "LAGRUM" character varying(254) NOT NULL, "AKTUALITET" date NOT NULL, "SIGNATUR" character varying(25) NOT NULL, "LANK" character varying(254), "GlobalID" uuid NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."sametinget:riksintresse_rennaringen" OWNER TO webmap_import; -- -- Name: TABLE "sametinget:riksintresse_rennaringen"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sametinget:riksintresse_rennaringen" IS 'Riksintresse Rennäringen'; -- -- Name: sametinget:riksintresse_rennaringen_karnomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" ( ogc_fid bigint NOT NULL, "LANK" character varying(254) NOT NULL, "LANSKOD" character varying(25) NOT NULL, "OMR_NR" integer, "ARET_RUNT" integer, "SAMEBY" character varying(62) NOT NULL, "ANSVARIG" character varying(25) NOT NULL, "AKTUALITET" date NOT NULL, "SIGNATUR" character varying(25), "GlobalID" uuid NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) ); ALTER TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" OWNER TO webmap_import; -- -- Name: TABLE "sametinget:riksintresse_rennaringen_karnomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" IS 'Riksintresse Rennäringen — Kärnområde'; -- -- Name: sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" OWNED BY postgis."sametinget:riksintresse_rennaringen_karnomrade".ogc_fid; -- -- Name: sametinget:riksintresse_rennaringen_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:riksintresse_rennaringen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" OWNED BY postgis."sametinget:riksintresse_rennaringen".ogc_fid; -- -- Name: sks:atervatningsavtal; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:atervatningsavtal" ( ogc_fid bigint NOT NULL, "Uuid" uuid NOT NULL, "Beteckn" character varying(12) NOT NULL, "ArendeAr" smallint NOT NULL, "AvtalatDatum" date, "Url" character varying(252), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."sks:atervatningsavtal" OWNER TO webmap_import; -- -- Name: TABLE "sks:atervatningsavtal"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:atervatningsavtal" IS 'Återvätningsavtal'; -- -- Name: sks:atervatningsavtal_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:atervatningsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNED BY postgis."sks:atervatningsavtal".ogc_fid; -- -- Name: sks:avverk_anmald; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:avverk_anmald" ( ogc_fid bigint NOT NULL, "OBJECTID" integer NOT NULL, "Beteckn" character varying(12) NOT NULL, "ArendeAr" smallint NOT NULL, "Inkomdatum" date NOT NULL, "AnmaldHa" real NOT NULL, "SkogsodlHa" real, "NatforHa" real, "AvvSasong" character varying(254) NOT NULL, "ArendeStatus" character varying(254) NOT NULL, "AvvHa" real, "AvverkningsanmalanKlass" character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."sks:avverk_anmald" OWNER TO webmap_import; -- -- Name: TABLE "sks:avverk_anmald"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:avverk_anmald" IS 'Avverkningsanmälningar (Skogsstyrelsen)'; -- -- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:avverk_anmald_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" OWNED BY postgis."sks:avverk_anmald".ogc_fid; -- -- Name: sks:avverk_utford; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:avverk_utford" ( ogc_fid bigint NOT NULL, "OBJECTID" integer NOT NULL, "Beteckn" character varying(12), "ArendeAr" smallint NOT NULL, "Avverktyp" character varying(254) NOT NULL, "Skogstyp" character varying(254) NOT NULL, "AnmaldHa" real NOT NULL, "NatforHa" real, "Avvdatum" date, "KallaDatum" character varying(62), "Forebild" character varying(62), "Efterbild" character varying(62), "ArealHa" real NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."sks:avverk_utford" OWNER TO webmap_import; -- -- Name: TABLE "sks:avverk_utford"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:avverk_utford" IS 'Utförd avverkning (Skogsstyrelsen)'; -- -- Name: sks:avverk_utford_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:avverk_utford_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:avverk_utford_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" OWNED BY postgis."sks:avverk_utford".ogc_fid; -- -- Name: sks:naturvarde; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:naturvarde" ( ogc_fid bigint NOT NULL, "ObjectId" integer NOT NULL, "Beteckn" character varying(12) NOT NULL, "Objnamn" character varying(62), "Datinv" date NOT NULL, "Biotop1" character varying(62), "Biotop2" character varying(62), "Biotop3" character varying(62), "Beskrivn1" character varying(62), "Beskrivn2" character varying(62), "Beskrivn3" character varying(62), "Url" character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."sks:naturvarde" OWNER TO webmap_import; -- -- Name: TABLE "sks:naturvarde"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:naturvarde" IS 'Objekt med naturvärden - Skogsstyrelsen'; -- -- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:naturvarde_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" OWNED BY postgis."sks:naturvarde".ogc_fid; -- -- Name: sks:naturvardsavtal; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:naturvardsavtal" ( ogc_fid bigint NOT NULL, "Uuid" uuid NOT NULL, "Beteckn" character varying(12) NOT NULL, "ArendeAr" smallint NOT NULL, "NvaTyp" character varying(254), "Naturtyp" character varying(254), "AreaTot" double precision NOT NULL, "AreaProd" double precision NOT NULL, "Standort" character varying(254), "DatAvtal" date, "Url" character varying(254) NOT NULL, "Undertyp" character varying(64), wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."sks:naturvardsavtal" OWNER TO webmap_import; -- -- Name: TABLE "sks:naturvardsavtal"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:naturvardsavtal" IS 'Naturvårdsavtal (Skogsstyrelsen)'; -- -- Name: sks:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNED BY postgis."sks:naturvardsavtal".ogc_fid; -- -- Name: sks:nyckelbiotop; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:nyckelbiotop" ( ogc_fid bigint NOT NULL, "Beteckn" character varying(12) NOT NULL, "Objnamn" character varying(62), "Datinv" date NOT NULL, "Biotop1" character varying(62), "Biotop2" character varying(62), "Biotop3" character varying(62), "Beskrivn1" character varying(62), "Beskrivn2" character varying(62), "Beskrivn3" character varying(62), "Beskrivn4" character varying(62), "Beskrivn5" character varying(62), "Beskrivn6" character varying(62), "Beskrivn7" character varying(62), "Beskrivn8" character varying(62), "Url" character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."sks:nyckelbiotop" OWNER TO webmap_import; -- -- Name: TABLE "sks:nyckelbiotop"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:nyckelbiotop" IS 'Nyckelbiotoper - Skogsstyrelsen'; -- -- Name: sks:nyckelbiotop_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:nyckelbiotop_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNED BY postgis."sks:nyckelbiotop".ogc_fid; -- -- Name: sks:nyckelbiotop_storskogsbruk; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:nyckelbiotop_storskogsbruk" ( ogc_fid bigint NOT NULL, objectid integer NOT NULL, "Org" character varying(62) NOT NULL, "InkomDatum" date NOT NULL, "Url" character varying(254) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."sks:nyckelbiotop_storskogsbruk" OWNER TO webmap_import; -- -- Name: TABLE "sks:nyckelbiotop_storskogsbruk"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:nyckelbiotop_storskogsbruk" IS 'Nyckelbiotoper - storskogsbruket'; -- -- Name: sks:nyckelbiotop_storskogsbruk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:nyckelbiotop_storskogsbruk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNED BY postgis."sks:nyckelbiotop_storskogsbruk".ogc_fid; -- -- Name: sks:sumpskog; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."sks:sumpskog" ( ogc_fid bigint NOT NULL, "OBJECTID" integer NOT NULL, "Namn" character varying(62), "Hydrtext" character varying(62), "Tradtext" character varying(62) NOT NULL, "Delklass" character varying(62), "Klassu" character varying(62), "Lovandel" character varying(62), "Krontakn" character varying(62), "Huggklas" character varying(62), "Andelva" character varying(62), "Ingrepp" character varying(62), "Ingrpavv" character varying(62), "Objnyck" character varying(62), "Delnyck" character varying(62), "Flygar" smallint, "Faltdat" date, "Invtekn" character varying(62) NOT NULL, "Invdat" date NOT NULL, "Ansvmynd" character varying(62) NOT NULL, "Url" character varying(252) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."sks:sumpskog" OWNER TO webmap_import; -- -- Name: TABLE "sks:sumpskog"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."sks:sumpskog" IS 'Sumpskogar'; -- -- Name: sks:sumpskog_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."sks:sumpskog_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:sumpskog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" OWNED BY postgis."sks:sumpskog".ogc_fid; -- -- Name: svk:ledningar; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."svk:ledningar" ( ogc_fid bigint NOT NULL, "Placement" character varying(32), "Voltage" integer, wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL ); ALTER TABLE postgis."svk:ledningar" OWNER TO webmap_import; -- -- Name: TABLE "svk:ledningar"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."svk:ledningar" IS 'Kraftledningar (befintliga)'; -- -- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."svk:ledningar_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."svk:ledningar_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."svk:ledningar_ogc_fid_seq" OWNED BY postgis."svk:ledningar".ogc_fid; -- -- Name: svk:stationsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."svk:stationsomraden" ( ogc_fid bigint NOT NULL, wkb_geometry postgis.geometry(MultiPolygonZ,3006) NOT NULL ); ALTER TABLE postgis."svk:stationsomraden" OWNER TO webmap_import; -- -- Name: TABLE "svk:stationsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."svk:stationsomraden" IS 'Stationsomraden'; -- -- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."svk:stationsomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" OWNED BY postgis."svk:stationsomraden".ogc_fid; -- -- Name: svk:stolpar; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."svk:stolpar" ( ogc_fid bigint NOT NULL, wkb_geometry postgis.geometry(PointZ,3006) NOT NULL ); ALTER TABLE postgis."svk:stolpar" OWNER TO webmap_import; -- -- Name: TABLE "svk:stolpar"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."svk:stolpar" IS 'Stolpar (befintliga)'; -- -- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."svk:stolpar_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."svk:stolpar_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."svk:stolpar_ogc_fid_seq" OWNED BY postgis."svk:stolpar".ogc_fid; -- -- Name: svk:transmissionsnatsprojekt; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."svk:transmissionsnatsprojekt" ( ogc_fid bigint NOT NULL, "Name" character varying(254), "Voltage" integer, "Url" character varying(254), wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL ); ALTER TABLE postgis."svk:transmissionsnatsprojekt" OWNER TO webmap_import; -- -- Name: TABLE "svk:transmissionsnatsprojekt"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- COMMENT ON TABLE postgis."svk:transmissionsnatsprojekt" IS 'Transmissionsnätsprojekt'; -- -- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- CREATE SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- ALTER SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNED BY postgis."svk:transmissionsnatsprojekt".ogc_fid; -- -- Name: vbk:havsbaserad_vindkraft; Type: TABLE; Schema: postgis; Owner: webmap_import -- CREATE TABLE postgis."vbk:havsbaserad_vindkraft" ( ogc_fid bigint NOT NULL, "OmrID" character varying(10) NOT NULL, "Projektnamn" character varying(62), "Organisationsnamn" character varying(254), "Organisationsnummer" character varying(11), "Projektstatus" character varying(62) NOT NULL, "Diarienummer" character varying(254), "AndringsansokanPagar" boolean, "SamradsunderlagInlamnat" date, "AnsokanInlamnat" date, "AnsokanAterkallad" date, "AnsokanBeviljad" date, "AnsokanAvslagen" date, "AnsokanOverklagad" date, "Natura2000_Ansokan" character varying(62) NOT NULL, "Natura2000_Beslutdatum" date, "UnderByggnation" boolean, "Uppfort" date, "PlaneratAntalVerkMin" smallint, "PlaneratAntalVerkMax" smallint, "PlaneradHojdMin" smallint, "PlaneradHojdMax" smallint, "PlaneradProduktionMin" real, "PlaneradProduktionMax" real, "PlaneradByggstart" date, "PlaneratDrift" date, "BeviljatAntalVerk" smallint, "UppfortAntalVerk" smallint, "BeviljadMaxhojd" smallint, "InstalleradEffekt" real, "Calprod" real, "ElNamn" character varying(62) NOT NULL, "SenasteUppdaterat" date NOT NULL, "Raderat" boolean NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); ALTER TABLE postgis."vbk:havsbaserad_vindkraft" OWNER TO webmap_import; -- -- Name: TABLE "vbk:havsbasera