diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 4916 |
1 files changed, 4398 insertions, 518 deletions
@@ -2,12 +2,13 @@ -- 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) +-- Dumped from database version 17.5 (Debian 17.5-1) +-- Dumped by pg_dump version 17.5 (Debian 17.5-1) SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; +SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); @@ -31,6 +32,7 @@ ALTER DATABASE webmap OWNER TO postgres; SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; +SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); @@ -215,6 +217,202 @@ COMMENT ON TABLE postgis.dammar IS 'Dammar'; -- +-- Name: COLUMN dammar."DammID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DammID" IS 'Dammenhetens identitet'; + + +-- +-- Name: COLUMN dammar."LST_OBJID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."LST_OBJID" IS 'Länsstyrelsens objektid'; + + +-- +-- Name: COLUMN dammar."Datum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Datum" IS 'Datum för registrering av dammenheten i SVAR'; + + +-- +-- Name: COLUMN dammar."DNamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DNamn" IS 'Dammenhetens namn'; + + +-- +-- Name: COLUMN dammar."ByggAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."ByggAr" IS 'År för första byggnation av dammenheten'; + + +-- +-- Name: COLUMN dammar."DammHojd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DammHojd" IS 'Dammdelens högsta höjd (m)'; + + +-- +-- Name: COLUMN dammar."KronLangd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."KronLangd" IS 'Krönlängd (m)'; + + +-- +-- Name: COLUMN dammar."Fiskvag"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Fiskvag" IS 'Förekomst och typ av fiskväg vid dammenheten'; + + +-- +-- Name: COLUMN dammar."FiskvagByggAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."FiskvagByggAr" IS 'Byggår fiskväg'; + + +-- +-- Name: COLUMN dammar."Fiskavledare"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Fiskavledare" IS 'Finns fiskavledare till fiskvägen'; + + +-- +-- Name: COLUMN dammar."Vandringshinder"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Vandringshinder" IS 'Om dammenheten utgör ett vandringshinder'; + + +-- +-- Name: COLUMN dammar."HARO"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."HARO" IS 'Huvudavrinningsområdesnummer'; + + +-- +-- Name: COLUMN dammar."Vattendistrikt"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Vattendistrikt" IS 'Huvudavrinningsområdesnummer'; + + +-- +-- Name: COLUMN dammar.inrapp_lst; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.inrapp_lst IS 'Den Länsstyrelse dammenheten är inrapporterad av'; + + +-- +-- Name: COLUMN dammar.eu_cd; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.eu_cd IS 'Vattenförekomstidentitet'; + + +-- +-- Name: COLUMN dammar.vf_typ; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.vf_typ IS 'Typ av vattenförekomst'; + + +-- +-- Name: COLUMN dammar.vy_eucd; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.vy_eucd IS 'Vattenförekomstidentitet för eventuell vattenyta kopplat till dammanläggning'; + + +-- +-- Name: COLUMN dammar.vy_vf_typ; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.vy_vf_typ IS 'Typ av vattenförekomst för eventuell vattenyta kopplat till dammanläggning'; + + +-- +-- Name: COLUMN dammar."DammanlID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DammanlID" IS 'Identitet för eventuell dammanläggning dammenheten är kopplad till'; + + +-- +-- Name: COLUMN dammar."Namn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Namn" IS 'Dammanläggningens namn'; + + +-- +-- Name: COLUMN dammar."OmbyggAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."OmbyggAr" IS 'År för idrifttagande av anläggning i dess nuvarande skepnad'; + + +-- +-- Name: COLUMN dammar."DG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DG" IS 'Högsta dämningsgräns (m) enligt tillstånd'; + + +-- +-- Name: COLUMN dammar."SG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."SG" IS 'Högsta dämningsgräns (m) enligt tillstånd'; + + +-- +-- Name: COLUMN dammar."HojdSys"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."HojdSys" IS 'Höjdsystem som DG och SG räknats i'; + + +-- +-- Name: COLUMN dammar."MY"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."MY" IS 'Magasinsyta (km²) vid angiven DG'; + + +-- +-- Name: COLUMN dammar."RV"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."RV" IS 'Reglerbar volym (milj. m³)'; + + +-- +-- Name: COLUMN dammar."Kommentar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Kommentar" IS 'Inrapporterade kommentarer från Länsstyrelserna'; + + +-- +-- Name: COLUMN dammar."XX_Distance"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."XX_Distance" IS 'Distance to the closest SvK station or production dam'; + + +-- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -226,7 +424,7 @@ CREATE SEQUENCE postgis.dammar_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.dammar_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.dammar_ogc_fid_seq OWNER TO webmap_import; -- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -268,7 +466,7 @@ CREATE SEQUENCE postgis.gigafactories_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import; -- -- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -300,6 +498,27 @@ COMMENT ON TABLE postgis.kommunyta IS 'Sveriges kommuner (Lantmäteriet)'; -- +-- Name: COLUMN kommunyta.objektidentitet; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.kommunyta.objektidentitet IS 'Globalt unik identitet för generaliserat objekt'; + + +-- +-- Name: COLUMN kommunyta.skapad; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.kommunyta.skapad IS 'Tidpunkt när objektet ändrades'; + + +-- +-- Name: COLUMN kommunyta.kommunkod; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.kommunyta.kommunkod IS 'Fyrsiffrig kod för kommun'; + + +-- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -311,7 +530,7 @@ CREATE SEQUENCE postgis.kommunyta_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.kommunyta_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.kommunyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -327,7 +546,7 @@ ALTER SEQUENCE postgis.kommunyta_ogc_fid_seq OWNED BY postgis.kommunyta.ogc_fid; CREATE TABLE postgis.kommunyta_sub ( ogc_fid bigint NOT NULL, kommunkod smallint NOT NULL, - wkb_geometry postgis.geometry(Polygon,3006) + wkb_geometry postgis.geometry(Polygon,3006) NOT NULL ); @@ -345,7 +564,7 @@ CREATE SEQUENCE postgis.kommunyta_sub_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.kommunyta_sub_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -377,6 +596,27 @@ COMMENT ON TABLE postgis.lansyta IS 'Sveriges län (Lantmäteriet)'; -- +-- Name: COLUMN lansyta.objektidentitet; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.lansyta.objektidentitet IS 'Globalt unik identitet för generaliserat objekt'; + + +-- +-- Name: COLUMN lansyta.skapad; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.lansyta.skapad IS 'Tidpunkt när objektet ändrades'; + + +-- +-- Name: COLUMN lansyta.lanskod; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.lansyta.lanskod IS 'Tvåsiffrig kod för län'; + + +-- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -388,7 +628,7 @@ CREATE SEQUENCE postgis.lansyta_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -404,7 +644,7 @@ ALTER SEQUENCE postgis.lansyta_ogc_fid_seq OWNED BY postgis.lansyta.ogc_fid; CREATE TABLE postgis.lansyta_sub ( ogc_fid bigint NOT NULL, lanskod smallint NOT NULL, - wkb_geometry postgis.geometry(Polygon,3006) + wkb_geometry postgis.geometry(Polygon,3006) NOT NULL ); @@ -422,7 +662,7 @@ CREATE SEQUENCE postgis.lansyta_sub_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.lansyta_sub_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -432,6 +672,267 @@ ALTER SEQUENCE postgis.lansyta_sub_ogc_fid_seq OWNED BY postgis.lansyta_sub.ogc_ -- +-- 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 SEQUENCE 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: COLUMN "lst:riksintresse_obruten_kust"."ANM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."lst:riksintresse_obruten_kust"."ANM" IS 'Anmärkning'; + + +-- +-- 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 SEQUENCE 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 SEQUENCE 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: COLUMN "lst:riksintresse_rorligt_friluftsliv"."ANM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."lst:riksintresse_rorligt_friluftsliv"."ANM" IS 'Anmärkning'; + + +-- +-- 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 SEQUENCE 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: COLUMN "lst:riksintresse_skyddade_vattendrag"."ANM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."lst:riksintresse_skyddade_vattendrag"."ANM" IS 'Anmärkning'; + + +-- +-- 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 SEQUENCE 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 -- @@ -456,6 +957,41 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_ansokta" IS 'Bearbetnings -- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".name IS 'Namn på ansökt bearbetningskoncession'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".mineral IS 'Ansökta koncessionsmineraler'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".owners IS 'Sökanden av bearbetningskoncessionen'; + + +-- -- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -467,7 +1003,7 @@ CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -505,6 +1041,69 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_beviljade" IS 'Bearbetnin -- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".name IS 'Namn på beviljad bearbetningskoncession'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".licenceid IS 'Tillståndsid för bearbetningskoncessionen'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".dec_date IS 'Datum när bearbetningskoncessionen beviljades'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".validfrom IS 'Datum från och med när bearbetningskoncessionen började gälla'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".validto IS 'Sista dagen bearbetningskoncessionen gäller'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".mineral IS 'Koncessionsmineral'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".owners IS 'Innehavare av bearbetningskoncessionen'; + + +-- -- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -516,7 +1115,7 @@ CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -551,6 +1150,48 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_forfallna" IS 'Bearbetnin -- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".name IS 'Namn på förfallen bearbetningskoncession'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".mineral IS 'Koncessionsmineral'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".owners IS 'Innehavare av bearbetningskoncessionen'; + + +-- -- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -562,7 +1203,7 @@ CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -595,6 +1236,34 @@ COMMENT ON TABLE postgis."mrr:markanvisningar_bk_ansokta" IS 'Markanvisningar ti -- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".name IS 'Namn på ansökt markanvisning'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".conc_name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".conc_name IS 'Bearbetningskoncession(er) som markanvisningen hör till'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- -- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -606,7 +1275,7 @@ CREATE SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -641,6 +1310,48 @@ COMMENT ON TABLE postgis."mrr:markanvisningar_bk_beviljade" IS 'Markanvisningar -- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".name IS 'Namn på beviljad markanvisning'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".licenceid IS 'Tillståndsid för markanvisningen'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".conc_name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".conc_name IS 'Bearbetningskoncession(er) som markanvisningen hör till'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".dec_date IS 'Datum när markanvisningen beviljades'; + + +-- -- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -652,7 +1363,7 @@ CREATE SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -686,6 +1397,41 @@ COMMENT ON TABLE postgis."mrr:ut_diamant_ansokta" IS 'Undersökningstillstånd - -- +-- Name: COLUMN "mrr:ut_diamant_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".name IS 'Namn på ansökt undersökningsområde'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".mineral IS 'Koncessionsmineral som ska eftersökas'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".owners IS 'Sökanden av undersökningstillståndet'; + + +-- -- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -697,7 +1443,7 @@ CREATE SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -735,6 +1481,69 @@ COMMENT ON TABLE postgis."mrr:ut_diamant_beviljade" IS 'Undersökningstillstånd -- +-- Name: COLUMN "mrr:ut_diamant_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".name IS 'Namn på beviljat undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".dec_date IS 'Datum när undersökningstillståndet beviljades'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".validto IS 'Sista dagen undersökningstillståndet gäller'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".mineral IS 'Koncessionsmineral som eftersöks'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".owners IS 'Innehavare av undersökningstillståndet'; + + +-- -- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -746,7 +1555,7 @@ CREATE SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -784,6 +1593,69 @@ COMMENT ON TABLE postgis."mrr:ut_diamant_forbud" IS 'Undersökningstillstånd - -- +-- Name: COLUMN "mrr:ut_diamant_forbud".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".name IS 'Namn på undersökningstillstånd under förbudsår'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".validfrom IS 'Datum då undersökningstillståndets förbudsår startar'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".validto IS 'Datum då undersökningstillståndets förbudsår slutar'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -795,7 +1667,7 @@ CREATE SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -829,6 +1701,41 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" IS 'Undersök -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".name IS 'Namn på ansökt undersökningsområde'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".mineral IS 'Koncessionsmineral som ska eftersökas'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".owners IS 'Sökanden av undersökningstillståndet'; + + +-- -- Name: mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -840,7 +1747,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -878,6 +1785,69 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" IS 'Unders -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".name IS 'Namn på beviljat undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".dec_date IS 'Datum när undersökningstillståndet beviljades'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".validto IS 'Sista dagen undersökningstillståndet gäller'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".mineral IS 'Koncessionsmineral som eftersöks'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".owners IS 'Innehavare av undersökningstillståndet'; + + +-- -- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -889,7 +1859,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -927,6 +1897,69 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forbud" IS 'Undersökn -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".name IS 'Namn på undersökningstillstånd under förbudsår'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".validfrom IS 'Datum då undersökningstillståndets förbudsår startar'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".validto IS 'Datum då undersökningstillståndets förbudsår slutar'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -938,7 +1971,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -976,6 +2009,69 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" IS 'Unders -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".name IS 'Namn på förfallet undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".validto IS 'Sista dagen undersökningstillståndet gällde'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -987,7 +2083,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1025,6 +2121,69 @@ COMMENT ON TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" IS 'Undersökningst -- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".name IS 'Namn på förfallet undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".validto IS 'Sista dagen undersökningstillståndet gällde'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1036,7 +2195,7 @@ CREATE SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1046,10 +2205,10 @@ ALTER SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" OWNED BY -- --- Name: nva:Naturvardsverket_Lansstyrelse; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvk:naturvardsavtal; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nva:Naturvardsverket_Lansstyrelse" ( +CREATE TABLE postgis."nvk:naturvardsavtal" ( ogc_fid bigint NOT NULL, "ID" integer NOT NULL, "DIARIENRNV" character varying(12) NOT NULL, @@ -1062,20 +2221,20 @@ CREATE TABLE postgis."nva:Naturvardsverket_Lansstyrelse" ( ); -ALTER TABLE postgis."nva:Naturvardsverket_Lansstyrelse" OWNER TO webmap_import; +ALTER TABLE postgis."nvk:naturvardsavtal" OWNER TO webmap_import; -- --- Name: TABLE "nva:Naturvardsverket_Lansstyrelse"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvk:naturvardsavtal"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nva:Naturvardsverket_Lansstyrelse" IS 'Naturvårdsavtal (Naturvårdsverket, Länsstyrelse)'; +COMMENT ON TABLE postgis."nvk:naturvardsavtal" IS 'Naturvårdsavtal (Naturvårdsverket, Länsstyrelse)'; -- --- Name: nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvk:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" +CREATE SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1083,50 +2242,66 @@ CREATE SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvk:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" OWNED BY postgis."nva:Naturvardsverket_Lansstyrelse".ogc_fid; +ALTER SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNED BY postgis."nvk:naturvardsavtal".ogc_fid; -- --- Name: nva:Skogsstyrelsen; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvk:riksintresse_friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nva:Skogsstyrelsen" ( +CREATE TABLE postgis."nvk:riksintresse_friluftsliv" ( 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), + "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."nva:Skogsstyrelsen" OWNER TO webmap_import; +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: COLUMN "nvk:riksintresse_friluftsliv"."AREA_LAND_"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:riksintresse_friluftsliv"."AREA_LAND_" IS 'Areal land i hektar'; + -- --- Name: TABLE "nva:Skogsstyrelsen"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvk:riksintresse_friluftsliv"."AREA_VATTE"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nva:Skogsstyrelsen" IS 'Naturvårdsavtal (Skogsstyrelsen)'; +COMMENT ON COLUMN postgis."nvk:riksintresse_friluftsliv"."AREA_VATTE" IS 'Areal vatten i hektar'; -- --- Name: nva:Skogsstyrelsen_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvk:riksintresse_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" +CREATE SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1134,13 +2309,219 @@ CREATE SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nva:Skogsstyrelsen_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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: nva:Skogsstyrelsen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvk:riksintresse_naturvard; Type: TABLE; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" OWNED BY postgis."nva:Skogsstyrelsen".ogc_fid; +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 SEQUENCE 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: COLUMN "nvk:skyddsvard_statlig_skog"."AR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."AR" IS 'År'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."NATURGEOGR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."NATURGEOGR" IS 'Naturgeografisk region'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."OBJEKTKATE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."OBJEKTKATE" IS 'Objektskategori'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."MARKAGARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."MARKAGARE" IS 'Markägare'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."VARDEKARNA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."VARDEKARNA" IS 'Areal värdekärna (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."UTV_MARK"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."UTV_MARK" IS 'Areal utvecklingsmark (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."TOTAL_AREA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."TOTAL_AREA" IS 'Totalareal (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."LAND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."LAND" IS 'Areal land (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."VATTEN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."VATTEN" IS 'Areal vatten (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."PROD_SKOG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."PROD_SKOG" IS 'Areal produktiv skogsmark (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."SKOG_O_FJG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."SKOG_O_FJG" IS 'Areal produktiv skogsmark ovanför fjällnära gräns (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."SKOG_N_FJG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."SKOG_N_FJG" IS 'Areal produktiv skogsmark nedanför fjällnära gräns (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."SKYDDSZON"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."SKYDDSZON" IS 'Areal skyddszon (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."ARRO_MARK"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."ARRO_MARK" IS 'Areal arronderingsmark (ha)'; + + +-- +-- 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 SEQUENCE 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; -- @@ -1166,6 +2547,13 @@ COMMENT ON TABLE postgis."nvr:Biosfarsomraden" IS 'Biosfärsområden (UNESCO)'; -- +-- Name: COLUMN "nvr:Biosfarsomraden"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biosfarsomraden"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- -- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1177,7 +2565,7 @@ CREATE SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1216,6 +2604,55 @@ COMMENT ON TABLE postgis."nvr:Biotopskydd" IS 'Biotopskydd i skogsmark (beslutad -- +-- Name: COLUMN "nvr:Biotopskydd"."Uuid"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Uuid" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."ArendeAr" IS 'År anmälan/ansökan registrerades'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Biotyp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Biotyp" IS 'Biotoptyp'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Standort"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Standort" IS 'Ståndortsindex'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Datbeslut"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Datbeslut" IS 'Datum för beslut'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; + + +-- -- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1227,7 +2664,7 @@ CREATE SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1273,6 +2710,125 @@ COMMENT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" IS 'Djur- och växtskyd -- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1284,7 +2840,7 @@ CREATE SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1326,7 +2882,7 @@ CREATE SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:HELCOM_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1372,6 +2928,125 @@ COMMENT ON TABLE postgis."nvr:Interimistiskt_forbud" IS 'Interimistiska förbud' -- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1383,7 +3058,7 @@ CREATE SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1429,6 +3104,125 @@ COMMENT ON TABLE postgis."nvr:Kultureservat" IS 'Kulturreservat'; -- +-- Name: COLUMN "nvr:Kultureservat"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1440,7 +3234,7 @@ CREATE SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Kultureservat_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1486,6 +3280,125 @@ COMMENT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" IS 'Landskapsbildsskyd -- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1497,7 +3410,7 @@ CREATE SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1543,6 +3456,125 @@ COMMENT ON TABLE postgis."nvr:Nationalpark" IS 'Nationalparker'; -- +-- Name: COLUMN "nvr:Nationalpark"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1554,7 +3586,7 @@ CREATE SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Nationalpark_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1597,6 +3629,104 @@ COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt'; -- +-- Name: COLUMN "nvr:Naturminne_punkt"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1608,7 +3738,7 @@ CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1654,6 +3784,125 @@ COMMENT ON TABLE postgis."nvr:Naturminne_yta" IS 'Naturminne, yta'; -- +-- Name: COLUMN "nvr:Naturminne_yta"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1665,7 +3914,7 @@ CREATE SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1711,6 +3960,125 @@ COMMENT ON TABLE postgis."nvr:Naturreservat" IS 'Naturreservat'; -- +-- Name: COLUMN "nvr:Naturreservat"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1722,7 +4090,7 @@ CREATE SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturreservat_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1768,6 +4136,125 @@ COMMENT ON TABLE postgis."nvr:Naturvardsomrade" IS 'Naturvårdsområden'; -- +-- Name: COLUMN "nvr:Naturvardsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1779,7 +4266,7 @@ CREATE SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1824,7 +4311,7 @@ CREATE SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:OSPAR_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1870,6 +4357,125 @@ COMMENT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" IS 'Biotopskydd utanfö -- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1881,7 +4487,7 @@ CREATE SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1921,6 +4527,34 @@ COMMENT ON TABLE postgis."nvr:Ramsar" IS 'Ramsar-områden (Våtmarkskonventionen -- +-- Name: COLUMN "nvr:Ramsar"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ramsar"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Ramsar"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ramsar"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Ramsar"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ramsar"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Ramsar"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ramsar"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- -- Name: nvr:Ramsar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1932,7 +4566,7 @@ CREATE SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Ramsar_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -1974,6 +4608,13 @@ COMMENT ON TABLE postgis."nvr:SCI_Rikstackande" IS 'Habitatdirektivet (SCI, dire -- +-- Name: COLUMN "nvr:SCI_Rikstackande"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:SCI_Rikstackande"."NAMN" IS 'Områdets namn'; + + +-- -- Name: nvr:SCI_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1985,7 +4626,7 @@ CREATE SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -2027,6 +4668,13 @@ COMMENT ON TABLE postgis."nvr:SPA_Rikstackande" IS 'Fågeldirektivet (SPA, direk -- +-- Name: COLUMN "nvr:SPA_Rikstackande"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:SPA_Rikstackande"."NAMN" IS 'Områdets namn'; + + +-- -- Name: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2038,7 +4686,7 @@ CREATE SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -2076,6 +4724,20 @@ COMMENT ON TABLE postgis."nvr:Tilltradesforbud" IS 'Områden med föreskrifter s -- +-- Name: COLUMN "nvr:Tilltradesforbud"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Tilltradesforbud"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Tilltradesforbud"."BESLSTAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Tilltradesforbud"."BESLSTAT" IS 'Beslutsstatus'; + + +-- -- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2087,7 +4749,7 @@ CREATE SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -2128,7 +4790,7 @@ CREATE SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Varldsarv_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -2176,6 +4838,139 @@ COMMENT ON TABLE postgis."nvr:Vattenskyddsomrade" IS 'Vattenskyddsområden'; -- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."TILLSYNSMH"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."TILLSYNSMH" IS 'Tillsynsmyndighet'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."PROVNMHDIS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."PROVNMHDIS" IS 'Prövningsmyndighet för dispens'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."PROVNMHTIL"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."PROVNMHTIL" IS 'Prövningsmyndighet för tillstånd'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Vattenskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2187,7 +4982,7 @@ CREATE SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -2197,38 +4992,37 @@ ALTER SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" OWNED BY postgis."nv -- --- Name: ren:omr_riks; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ren:omr_riks" ( +CREATE TABLE postgis."sametinget:betesomrade" ( 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, + "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, - "SIGNATUR" character varying(25), - "GlobalID" uuid NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); -ALTER TABLE postgis."ren:omr_riks" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:betesomrade" OWNER TO webmap_import; -- --- Name: TABLE "ren:omr_riks"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:betesomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ren:omr_riks" IS 'Riksintresse Rennäringen — Kärnområde'; +COMMENT ON TABLE postgis."sametinget:betesomrade" IS 'Samebyarnas betesområden: Renbetesområden'; -- --- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" +CREATE SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -2236,44 +5030,55 @@ CREATE SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ren:omr_riks_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" OWNED BY postgis."ren:omr_riks".ogc_fid; +ALTER SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" OWNED BY postgis."sametinget:betesomrade".ogc_fid; -- --- Name: ren:riks_ren; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ren:riks_ren" ( +CREATE TABLE postgis."sametinget:flyttled" ( 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), + "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(MultiPolygon,3006) NOT NULL + wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL ); -ALTER TABLE postgis."ren:riks_ren" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:flyttled" OWNER TO webmap_import; -- --- Name: TABLE "ren:riks_ren"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:flyttled"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ren:riks_ren" IS 'Riksintresse Rennäringen'; +COMMENT ON TABLE postgis."sametinget:flyttled" IS 'Samebyarnas markanvändningsredovisning: Flyttled'; -- --- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" +CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -2281,100 +5086,93 @@ CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ren:riks_ren_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren".ogc_fid; +ALTER SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" OWNED BY postgis."sametinget:flyttled".ogc_fid; -- --- Name: ri:friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ri:friluftsliv" ( +CREATE TABLE postgis."sametinget:riksintresse_rennaringen" ( 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, + "LAGRUM" character varying(254) NOT NULL, + "AKTUALITET" date NOT NULL, + "SIGNATUR" character varying(25) NOT NULL, + "LANK" character varying(254), + "GlobalID" uuid NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); -ALTER TABLE postgis."ri:friluftsliv" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:riksintresse_rennaringen" OWNER TO webmap_import; -- --- Name: TABLE "ri:friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:riksintresse_rennaringen"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ri:friluftsliv" IS 'Riksintresse friluftsliv'; +COMMENT ON TABLE postgis."sametinget:riksintresse_rennaringen" IS 'Riksintresse Rennäringen'; -- --- Name: ri:friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +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) NOT NULL +); -ALTER TABLE postgis."ri:friluftsliv_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" OWNER TO webmap_import; -- --- Name: ri:friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:riksintresse_rennaringen_karnomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" OWNED BY postgis."ri:friluftsliv".ogc_fid; +COMMENT ON TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" IS 'Riksintresse Rennäringen — Kärnområde'; -- --- Name: ri:naturvard; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ri:naturvard" ( - ogc_fid bigint NOT NULL, - "SKYDD" character varying(64) NOT NULL, - "AMNESOMRAD" character varying(64) NOT NULL, - "NAMN" character varying(127) NOT NULL, - "BESKRIVNIN" character varying(254) NOT NULL, - "LAGRUM" character varying(64) NOT NULL, - "BESLUTSDAT" date NOT NULL, - "ORGINALID" character varying(16) NOT NULL, - "RIKSID" integer NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); +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."ri:naturvard" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: TABLE "ri:naturvard"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ri:naturvard" IS 'Riksintresse naturvård'; +ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" OWNED BY postgis."sametinget:riksintresse_rennaringen_karnomrade".ogc_fid; -- --- Name: ri:naturvard_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ri:naturvard_ogc_fid_seq" +CREATE SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -2382,49 +5180,79 @@ CREATE SEQUENCE postgis."ri:naturvard_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ri:naturvard_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ri:naturvard_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ri:naturvard_ogc_fid_seq" OWNED BY postgis."ri:naturvard".ogc_fid; +ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" OWNED BY postgis."sametinget:riksintresse_rennaringen".ogc_fid; -- --- Name: ri:obruten_kust; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sks:atervatningsavtal; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ri:obruten_kust" ( +CREATE TABLE postgis."sks:atervatningsavtal" ( 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), + "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."ri:obruten_kust" OWNER TO webmap_import; +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: TABLE "ri:obruten_kust"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:atervatningsavtal"."Uuid"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ri:obruten_kust" IS 'Obruten kust (MB 4 kap 3§)'; +COMMENT ON COLUMN postgis."sks:atervatningsavtal"."Uuid" IS 'Unikt ID'; -- --- Name: ri:obruten_kust_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:atervatningsavtal"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" +COMMENT ON COLUMN postgis."sks:atervatningsavtal"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:atervatningsavtal"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:atervatningsavtal"."ArendeAr" IS 'Ärendeår'; + + +-- +-- Name: COLUMN "sks:atervatningsavtal"."AvtalatDatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:atervatningsavtal"."AvtalatDatum" IS 'Avtalat datum'; + + +-- +-- Name: COLUMN "sks:atervatningsavtal"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:atervatningsavtal"."Url" IS 'Länk till Skogens pärlors formulär för objektet'; + + +-- +-- 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 @@ -2432,47 +5260,127 @@ CREATE SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ri:obruten_kust_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ri:obruten_kust_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sks:atervatningsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" OWNED BY postgis."ri:obruten_kust".ogc_fid; +ALTER SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNED BY postgis."sks:atervatningsavtal".ogc_fid; -- --- Name: ri:obrutet_fjall; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_anmald; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ri:obrutet_fjall" ( +CREATE TABLE postgis."sks:avverk_anmald" ( 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), + "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."ri:obrutet_fjall" OWNER TO webmap_import; +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: COLUMN "sks:avverk_anmald"."OBJECTID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."OBJECTID" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."ArendeAr" IS 'År anmälan/ansökan registrerades'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."Inkomdatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."Inkomdatum" IS 'Anmälan/ansökan inkom datum'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."AnmaldHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."AnmaldHa" IS 'Areal anmält (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."SkogsodlHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."SkogsodlHa" IS 'Areal plantering (ha)'; + -- --- Name: TABLE "ri:obrutet_fjall"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:avverk_anmald"."NatforHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ri:obrutet_fjall" IS 'Obrutet fjäll (MB 4 kap 5§)'; +COMMENT ON COLUMN postgis."sks:avverk_anmald"."NatforHa" IS 'Areal naturlig föryngring (ha)'; -- --- Name: ri:obrutet_fjall_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:avverk_anmald"."AvvSasong"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" +COMMENT ON COLUMN postgis."sks:avverk_anmald"."AvvSasong" IS 'Avverkningssäsong'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."ArendeStatus"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."ArendeStatus" IS 'Ärendestatus'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."AvvHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."AvvHa" IS 'Avverkad areal (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."AvverkningsanmalanKlass"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."AvverkningsanmalanKlass" IS 'Avverkningsamalan/NyAvverkningsanmalan'; + + +-- +-- 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 @@ -2480,48 +5388,135 @@ CREATE SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ri:obrutet_fjall_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ri:obrutet_fjall_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" OWNED BY postgis."ri:obrutet_fjall".ogc_fid; +ALTER SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" OWNED BY postgis."sks:avverk_anmald".ogc_fid; -- --- Name: ri:rorligt_friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_utford; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ri:rorligt_friluftsliv" ( +CREATE TABLE postgis."sks:avverk_utford" ( 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), + "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."ri:rorligt_friluftsliv" OWNER TO webmap_import; +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: COLUMN "sks:avverk_utford"."OBJECTID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."OBJECTID" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."ArendeAr" IS 'År anmälan/ansökan registrerades'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Avverktyp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Avverktyp" IS 'Vad anmälan/ansökan gäller'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Skogstyp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Skogstyp" IS 'Anger om avverkning är inom fjällnära skog, ädellövskog eller normal skog'; + -- --- Name: TABLE "ri:rorligt_friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:avverk_utford"."AnmaldHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ri:rorligt_friluftsliv" IS 'Rörligt friluftsliv (MB 4 kap 1§ och 2§)'; +COMMENT ON COLUMN postgis."sks:avverk_utford"."AnmaldHa" IS 'Areal anmält (ha)'; -- --- Name: ri:rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:avverk_utford"."NatforHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" +COMMENT ON COLUMN postgis."sks:avverk_utford"."NatforHa" IS 'Areal naturlig föryngring (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Avvdatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Avvdatum" IS 'Datum för avverkning'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."KallaDatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."KallaDatum" IS 'Ursprung för datum för avverkning (vid ”Uppgift saknas” är det vanligen Skogsstyrelsens personal som registrerat datumet)'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Forebild"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Forebild" IS 'Namnet på den gamla bilden i skillnadsanalysen'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Efterbild"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Efterbild" IS 'Namnet på den nya bilden i skillnadsanalysen'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."ArealHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."ArealHa" IS 'Areal för ytan (ha)'; + + +-- +-- 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 @@ -2529,49 +5524,85 @@ CREATE SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ri:rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_utford_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" OWNED BY postgis."ri:rorligt_friluftsliv".ogc_fid; +ALTER SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" OWNED BY postgis."sks:avverk_utford".ogc_fid; -- --- Name: ri:skyddade_vattendrag; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvarde; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ri:skyddade_vattendrag" ( +CREATE TABLE postgis."sks:naturvarde" ( 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), + "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."ri:skyddade_vattendrag" OWNER TO webmap_import; +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: COLUMN "sks:naturvarde"."ObjectId"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."ObjectId" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:naturvarde"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:naturvarde"."Objnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."Objnamn" IS 'Namn på objektet'; + + +-- +-- Name: COLUMN "sks:naturvarde"."Datinv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."Datinv" IS 'Datum för fältinventering'; + -- --- Name: TABLE "ri:skyddade_vattendrag"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:naturvarde"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ri:skyddade_vattendrag" IS 'Skyddade vattendrag (MB 4 kap 6§)'; +COMMENT ON COLUMN postgis."sks:naturvarde"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; -- --- Name: ri:skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" +CREATE SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -2579,47 +5610,85 @@ CREATE SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ri:skyddade_vattendrag_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ri:skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" OWNED BY postgis."ri:skyddade_vattendrag".ogc_fid; +ALTER SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" OWNED BY postgis."sks:naturvarde".ogc_fid; -- --- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvardsavtal; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sametinget:betesomraden" ( +CREATE TABLE postgis."sks:naturvardsavtal" ( 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, + "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."sametinget:betesomraden" OWNER TO webmap_import; +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: COLUMN "sks:naturvardsavtal"."Uuid"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."Uuid" IS 'Unik identitet'; + -- --- Name: TABLE "sametinget:betesomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:naturvardsavtal"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sametinget:betesomraden" IS 'Samebyarnas betesområden: Renbetesområden'; +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."Beteckn" IS 'Ärendebeteckning'; -- --- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:naturvardsavtal"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."ArendeAr" IS 'År anmälan/ansökan registrerades'; + + +-- +-- Name: COLUMN "sks:naturvardsavtal"."Standort"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."Standort" IS 'Ståndortsindex'; + + +-- +-- Name: COLUMN "sks:naturvardsavtal"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; + + +-- +-- 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 @@ -2627,55 +5696,82 @@ CREATE SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sametinget:betesomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" OWNED BY postgis."sametinget:betesomraden".ogc_fid; +ALTER SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNED BY postgis."sks:naturvardsavtal".ogc_fid; -- --- Name: sametinget:flyttled; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sks:nyckelbiotop; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sametinget:flyttled" ( +CREATE TABLE postgis."sks:nyckelbiotop" ( 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 + "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."sametinget:flyttled" OWNER TO webmap_import; +ALTER TABLE postgis."sks:nyckelbiotop" OWNER TO webmap_import; -- --- Name: TABLE "sametinget:flyttled"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sks:nyckelbiotop"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sametinget:flyttled" IS 'Samebyarnas markanvändningsredovisning: Flyttled'; +COMMENT ON TABLE postgis."sks:nyckelbiotop" IS 'Nyckelbiotoper - Skogsstyrelsen'; -- --- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:nyckelbiotop"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" +COMMENT ON COLUMN postgis."sks:nyckelbiotop"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop"."Objnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop"."Objnamn" IS 'Namn på objektet'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop"."Datinv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop"."Datinv" IS 'Datum för fältinventering'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; + + +-- +-- 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 @@ -2683,50 +5779,71 @@ CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sametinget:flyttled_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sks:nyckelbiotop_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; +ALTER SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNED BY postgis."sks:nyckelbiotop".ogc_fid; -- --- Name: sks:AvverkAnm; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sks:nyckelbiotop_storskogsbruk; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sks:AvverkAnm" ( +CREATE TABLE postgis."sks:nyckelbiotop_storskogsbruk" ( 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, - "ArendeStatus" character varying(254) NOT NULL, - "AvvSasong" character varying(254) NOT NULL, - "AvvHa" real, - "AvverkningsanmalanKlass" character varying(254) 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:AvverkAnm" OWNER TO webmap_import; +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: TABLE "sks:AvverkAnm"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk".objectid; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sks:AvverkAnm" IS 'Avverkningsanmälningar (Skogsstyrelsen)'; +COMMENT ON COLUMN postgis."sks:nyckelbiotop_storskogsbruk".objectid IS 'Unik identitet'; -- --- Name: sks:AvverkAnm_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk"."Org"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" +COMMENT ON COLUMN postgis."sks:nyckelbiotop_storskogsbruk"."Org" IS 'Namn på Organisation som gjort inventeringen'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk"."InkomDatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop_storskogsbruk"."InkomDatum" IS 'Datum då data inkommit till Skogsstyrelsen'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop_storskogsbruk"."Url" IS 'Länk till Skogens Pärlors visningsformulär'; + + +-- +-- 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 @@ -2734,51 +5851,199 @@ CREATE SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:AvverkAnm_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sks:AvverkAnm_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sks:nyckelbiotop_storskogsbruk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" OWNED BY postgis."sks:AvverkAnm".ogc_fid; +ALTER SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNED BY postgis."sks:nyckelbiotop_storskogsbruk".ogc_fid; -- --- Name: sks:UtfordAvverk; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sks:sumpskog; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sks:UtfordAvverk" ( +CREATE TABLE postgis."sks:sumpskog" ( 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, + "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:UtfordAvverk" OWNER TO webmap_import; +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: COLUMN "sks:sumpskog"."OBJECTID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."OBJECTID" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Namn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Namn" IS 'Objektnamn'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Hydrtext"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Hydrtext" IS 'Hydrologisk text, ex. kärrskog, mosseskog'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Tradtext"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Tradtext" IS 'Trädslag'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Delklass"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Delklass" IS 'Klass på delobjektet'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Klassu"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Klassu" IS 'Klass på objektet'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Lovandel"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Lovandel" IS 'Lövandel'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Krontakn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Krontakn" IS 'Krontäckning'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Huggklas"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Huggklas" IS 'Huggningsklass'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Andelva"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Andelva" IS 'Andel öppet vatten'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Ingrepp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Ingrepp" IS 'Ingrepp på delobjekt (max 4)'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Ingrpavv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Ingrpavv" IS 'Grad av påverkan på delobjekt (max 4)'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Objnyck"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Objnyck" IS 'Nyckelord på objektnivå'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Delnyck"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Delnyck" IS 'Nyckelord på delobjektsnivå'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Flygar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Flygar" IS 'Flygbildsår'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Faltdat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Faltdat" IS 'Faltdat'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Invtekn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Invtekn" IS 'Inventeringsteknik'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Invdat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Invdat" IS 'Inventeringdatum'; + -- --- Name: TABLE "sks:UtfordAvverk"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:sumpskog"."Ansvmynd"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sks:UtfordAvverk" IS 'Utförd avverkning (Skogsstyrelsen)'; +COMMENT ON COLUMN postgis."sks:sumpskog"."Ansvmynd" IS 'Ansvarig myndighet'; -- --- Name: sks:UtfordAvverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:sumpskog"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" +COMMENT ON COLUMN postgis."sks:sumpskog"."Url" IS 'Länk till Skogens pärlors formulär för objektet'; + + +-- +-- 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 @@ -2786,13 +6051,13 @@ CREATE SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sks:UtfordAvverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sks:sumpskog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNED BY postgis."sks:UtfordAvverk".ogc_fid; +ALTER SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" OWNED BY postgis."sks:sumpskog".ogc_fid; -- @@ -2828,7 +6093,7 @@ CREATE SEQUENCE postgis."svk:ledningar_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."svk:ledningar_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -2868,7 +6133,7 @@ CREATE SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."svk:stationsomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -2908,7 +6173,7 @@ CREATE SEQUENCE postgis."svk:stolpar_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."svk:stolpar_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -2951,7 +6216,7 @@ CREATE SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE 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 @@ -3013,6 +6278,90 @@ COMMENT ON TABLE postgis."vbk:havsbaserad_vindkraft" IS 'Vindbrukskollen havsbas -- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."OmrID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."OmrID" IS 'ID-nummer i Vindbruksollen för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Projektnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Projektnamn" IS 'Namn på projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Organisationsnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Organisationsnamn" IS 'Namnet på verksamhetsutövaren för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Organisationsnummer"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Organisationsnummer" IS 'Verksamhetsutövarens organisationsnummer'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."AndringsansokanPagar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."AndringsansokanPagar" IS 'Om ändringsansökan pågår'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."UnderByggnation"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."UnderByggnation" IS 'Om projekteringsområdet är under byggnation'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Uppfort"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Uppfort" IS 'Uppförandedatum för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."PlaneradByggstart"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."PlaneradByggstart" IS 'Datumangivelse för planerad byggstart för projektet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."PlaneratDrift"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."PlaneratDrift" IS 'Datumangivelse för planerat idrifttagande för projektet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Calprod"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Calprod" IS 'Den beräknade årsproduktionern (GWh) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."ElNamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."ElNamn" IS 'Elområde dit vindkraftverket tillhör'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."SenasteUppdaterat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."SenasteUppdaterat" IS 'Datum då vindkraftverket senast sparats i Vindbrukskollen'; + + +-- -- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -3024,7 +6373,7 @@ CREATE SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3068,6 +6417,104 @@ COMMENT ON TABLE postgis."vbk:projekteringsomraden" IS 'Vindbrukskollen landbase -- +-- Name: COLUMN "vbk:projekteringsomraden"."OmrID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."OmrID" IS 'ID-nummer i Vindbruksollen för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."Projektnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."Projektnamn" IS 'Namn på projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."AntalVerk"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."AntalVerk" IS 'Antal vindkraftverk exklusive status "Ej aktuell/återkallat"'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."AntalEjXY"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."AntalEjXY" IS 'Antal vindkraftverk utan koordinater som tillhör projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."Calprod"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."Calprod" IS 'Summan av verkens uppgivna beräknade årsproduktion (GWh)'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."PlaneradByggstart"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."PlaneradByggstart" IS 'Datumangivelse för planerad byggstart för projektet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."PlaneratDrift"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."PlaneratDrift" IS 'Datumangivelse för planerat idrifttagande för projektet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."AndringsansokanPagar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."AndringsansokanPagar" IS 'Om ändringsansökan pågår'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."UnderByggnation"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."UnderByggnation" IS 'Om projekteringsområdet är under byggnation'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."Organisationsnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."Organisationsnamn" IS 'Namnet på verksamhetsutövaren för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."Organisationsnummer"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."Organisationsnummer" IS 'Verksamhetsutövarens organisationsnummer'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."ElNamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."ElNamn" IS 'Elområde dit projekteringsområdet tillhör'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."SenasteUppdaterat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."SenasteUppdaterat" IS 'Datum då projektet senast sparats i Vindbrukskollen (om datum saknas har området inte sparats efter nov 2018)'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."EjAktuell"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."EjAktuell" IS 'Om samtliga verk inom projekteringsområdet har status ej aktuellt / återkallat / avslag med laga kraft'; + + +-- -- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -3079,7 +6526,7 @@ CREATE SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3130,6 +6577,139 @@ COMMENT ON TABLE postgis."vbk:vindkraftverk" IS 'Vindbrukskollen landbaserade vi -- +-- Name: COLUMN "vbk:vindkraftverk"."VerkID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."VerkID" IS 'ID-nummer i Vindbrukskollen för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."OmrID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."OmrID" IS 'ID-nummer i Vindbruksollen för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Projektnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Projektnamn" IS 'Namn på projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Status"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Status" IS 'Status för vindkraftverket (t.ex beviljat)'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Handlingstyp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Handlingstyp" IS 'Aktuell prövningsgrund enligt Miljöbalken eller Plan och Bygglagen'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Uppfort"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Uppfort" IS 'Uppförandedatum för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."MB_Tillstand"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."MB_Tillstand" IS 'Datum för tidsbegränsning av miljötillståndet'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Totalhojd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Totalhojd" IS 'Totalhöjd (m) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Navhojd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Navhojd" IS 'Navhöjd (m) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Rotordiameter"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Rotordiameter" IS 'Rotordiameter (m) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Maxeffekt"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Maxeffekt" IS 'Ansökt eller installerad maxeffekt (MW) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Calprod"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Calprod" IS 'Den beräknade årsproduktionern (GWh) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Fabrikat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Fabrikat" IS 'Namn på vindkraftverkets fabrikat'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Modell"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Modell" IS 'Namn på vindkraftverkets modell'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Organisationsnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Organisationsnamn" IS 'Namnet på verksamhetsutövaren för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Organisationsnummer"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Organisationsnummer" IS 'Verksamhetsutövarens organisationsnummer'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Placering"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Placering" IS 'Anger om verket är placerat på land eller i vatten'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."ElNamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."ElNamn" IS 'Elområde dit vindkraftverket tillhör'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."SenasteUppdaterat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."SenasteUppdaterat" IS 'Datum då vindkraftverket senast sparats i Vindbrukskollen (om datum saknas har vindkraftverket inte sparats efter nov 2018)'; + + +-- -- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -3141,7 +6721,7 @@ CREATE SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3183,7 +6763,7 @@ CREATE SEQUENCE public.layercache_ogc_fid_seq CACHE 1; -ALTER TABLE public.layercache_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE public.layercache_ogc_fid_seq OWNER TO webmap_import; -- -- Name: layercache_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: webmap_import @@ -3235,6 +6815,41 @@ ALTER TABLE ONLY postgis.lansyta_sub ALTER COLUMN ogc_fid SET DEFAULT nextval('p -- +-- Name: lst:pagaende_naturreservatsbildning ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:pagaende_naturreservatsbildning" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq"'::regclass); + + +-- +-- Name: lst:riksintresse_obruten_kust ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_obruten_kust" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:riksintresse_obruten_kust_ogc_fid_seq"'::regclass); + + +-- +-- Name: lst:riksintresse_obrutet_fjall ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_obrutet_fjall" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq"'::regclass); + + +-- +-- Name: lst:riksintresse_rorligt_friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_rorligt_friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq"'::regclass); + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_skyddade_vattendrag" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq"'::regclass); + + +-- -- Name: mrr:bearbetningskoncessioner_ansokta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -3326,17 +6941,31 @@ ALTER TABLE ONLY postgis."mrr:ut_olja_gas_diamant_forfallna" ALTER COLUMN ogc_fi -- --- Name: nva:Naturvardsverket_Lansstyrelse ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: nvk:naturvardsavtal ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:naturvardsavtal" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:naturvardsavtal_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvk:riksintresse_friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nva:Naturvardsverket_Lansstyrelse" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."nvk:riksintresse_friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq"'::regclass); -- --- Name: nva:Skogsstyrelsen ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: nvk:riksintresse_naturvard ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nva:Skogsstyrelsen_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."nvk:riksintresse_naturvard" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:riksintresse_naturvard_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvk:skyddsvard_statlig_skog ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:skyddsvard_statlig_skog" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq"'::regclass); -- @@ -3480,87 +7109,87 @@ ALTER TABLE ONLY postgis."nvr:Vattenskyddsomrade" ALTER COLUMN ogc_fid SET DEFAU -- --- Name: ren:omr_riks ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:omr_riks" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:omr_riks_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sametinget:betesomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:betesomrade_ogc_fid_seq"'::regclass); -- --- Name: ren:riks_ren ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:riks_ren" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:riks_ren_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sametinget:flyttled" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:flyttled_ogc_fid_seq"'::regclass); -- --- Name: ri:friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:friluftsliv_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq"'::regclass); -- --- Name: ri:naturvard ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:naturvard" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:naturvard_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen_karnomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq"'::regclass); -- --- Name: ri:obruten_kust ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:atervatningsavtal ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:obruten_kust" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:obruten_kust_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:atervatningsavtal" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:atervatningsavtal_ogc_fid_seq"'::regclass); -- --- Name: ri:obrutet_fjall ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_anmald ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:obrutet_fjall" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:obrutet_fjall_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:avverk_anmald" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:avverk_anmald_ogc_fid_seq"'::regclass); -- --- Name: ri:rorligt_friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_utford ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:rorligt_friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:rorligt_friluftsliv_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:avverk_utford" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:avverk_utford_ogc_fid_seq"'::regclass); -- --- Name: ri:skyddade_vattendrag ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvarde ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:skyddade_vattendrag" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:skyddade_vattendrag_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:naturvarde" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:naturvarde_ogc_fid_seq"'::regclass); -- --- Name: sametinget:betesomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvardsavtal ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:betesomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:betesomraden_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:naturvardsavtal" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:naturvardsavtal_ogc_fid_seq"'::regclass); -- --- Name: sametinget:flyttled ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:nyckelbiotop ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:flyttled" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:flyttled_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:nyckelbiotop" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:nyckelbiotop_ogc_fid_seq"'::regclass); -- --- Name: sks:AvverkAnm ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:nyckelbiotop_storskogsbruk ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:AvverkAnm" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:AvverkAnm_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:nyckelbiotop_storskogsbruk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq"'::regclass); -- --- Name: sks:UtfordAvverk ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:sumpskog ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:UtfordAvverk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:UtfordAvverk_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:sumpskog" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:sumpskog_ogc_fid_seq"'::regclass); -- @@ -3692,6 +7321,62 @@ ALTER TABLE ONLY postgis.lansyta -- +-- Name: lst:pagaende_naturreservatsbildning lst:pagaende_naturreservatsbildning_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:pagaende_naturreservatsbildning" + ADD CONSTRAINT "lst:pagaende_naturreservatsbildning_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: lst:riksintresse_obruten_kust lst:riksintresse_obruten_kust_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_obruten_kust" + ADD CONSTRAINT "lst:riksintresse_obruten_kust_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: lst:riksintresse_obrutet_fjall lst:riksintresse_obrutet_fjall_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_obrutet_fjall" + ADD CONSTRAINT "lst:riksintresse_obrutet_fjall_ORIGINALID_key" UNIQUE ("ORIGINALID"); + + +-- +-- Name: lst:riksintresse_obrutet_fjall lst:riksintresse_obrutet_fjall_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_obrutet_fjall" + ADD CONSTRAINT "lst:riksintresse_obrutet_fjall_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: lst:riksintresse_rorligt_friluftsliv lst:riksintresse_rorligt_friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_rorligt_friluftsliv" + ADD CONSTRAINT "lst:riksintresse_rorligt_friluftsliv_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag lst:riksintresse_skyddade_vattendrag_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_skyddade_vattendrag" + ADD CONSTRAINT "lst:riksintresse_skyddade_vattendrag_ORIGINALID_key" UNIQUE ("ORIGINALID"); + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag lst:riksintresse_skyddade_vattendrag_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_skyddade_vattendrag" + ADD CONSTRAINT "lst:riksintresse_skyddade_vattendrag_pkey" PRIMARY KEY (ogc_fid); + + +-- -- Name: mrr:bearbetningskoncessioner_ansokta mrr:bearbetningskoncessioner_ansokta_diarynr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -3988,35 +7673,43 @@ ALTER TABLE ONLY postgis."mrr:ut_olja_gas_diamant_forfallna" -- --- Name: nva:Naturvardsverket_Lansstyrelse nva:Naturvardsverket_Lansstyrelse_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nvk:naturvardsavtal nvk:naturvardsavtal_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:naturvardsavtal" + ADD CONSTRAINT "nvk:naturvardsavtal_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvk:riksintresse_friluftsliv nvk:riksintresse_friluftsliv_OMRADESNR_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nva:Naturvardsverket_Lansstyrelse" - ADD CONSTRAINT "nva:Naturvardsverket_Lansstyrelse_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."nvk:riksintresse_friluftsliv" + ADD CONSTRAINT "nvk:riksintresse_friluftsliv_OMRADESNR_key" UNIQUE ("OMRADESNR"); -- --- Name: nva:Skogsstyrelsen nva:Skogsstyrelsen_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nvk:riksintresse_friluftsliv nvk:riksintresse_friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" - ADD CONSTRAINT "nva:Skogsstyrelsen_Beteckn_key" UNIQUE ("Beteckn"); +ALTER TABLE ONLY postgis."nvk:riksintresse_friluftsliv" + ADD CONSTRAINT "nvk:riksintresse_friluftsliv_pkey" PRIMARY KEY (ogc_fid); -- --- Name: nva:Skogsstyrelsen nva:Skogsstyrelsen_Uuid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nvk:riksintresse_naturvard nvk:riksintresse_naturvard_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" - ADD CONSTRAINT "nva:Skogsstyrelsen_Uuid_key" UNIQUE ("Uuid"); +ALTER TABLE ONLY postgis."nvk:riksintresse_naturvard" + ADD CONSTRAINT "nvk:riksintresse_naturvard_pkey" PRIMARY KEY (ogc_fid); -- --- Name: nva:Skogsstyrelsen nva:Skogsstyrelsen_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nvk:skyddsvard_statlig_skog nvk:skyddsvard_statlig_skog_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" - ADD CONSTRAINT "nva:Skogsstyrelsen_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."nvk:skyddsvard_statlig_skog" + ADD CONSTRAINT "nvk:skyddsvard_statlig_skog_pkey" PRIMARY KEY (ogc_fid); -- @@ -4356,179 +8049,219 @@ ALTER TABLE ONLY postgis."nvr:Vattenskyddsomrade" -- --- Name: ren:omr_riks ren:omr_riks_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade sametinget:betesomrade_SAMEBY_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:omr_riks" - ADD CONSTRAINT "ren:omr_riks_GlobalID_key" UNIQUE ("GlobalID"); +ALTER TABLE ONLY postgis."sametinget:betesomrade" + ADD CONSTRAINT "sametinget:betesomrade_SAMEBY_ID_key" UNIQUE ("SAMEBY_ID"); -- --- Name: ren:omr_riks ren:omr_riks_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade sametinget:betesomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:omr_riks" - ADD CONSTRAINT "ren:omr_riks_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sametinget:betesomrade" + ADD CONSTRAINT "sametinget:betesomrade_pkey" PRIMARY KEY (ogc_fid); -- --- Name: ren:riks_ren ren:riks_ren_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled sametinget:flyttled_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:riks_ren" - ADD CONSTRAINT "ren:riks_ren_GlobalID_key" UNIQUE ("GlobalID"); +ALTER TABLE ONLY postgis."sametinget:flyttled" + ADD CONSTRAINT "sametinget:flyttled_GlobalID_key" UNIQUE ("GlobalID"); -- --- Name: ren:riks_ren ren:riks_ren_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled sametinget:flyttled_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:riks_ren" - ADD CONSTRAINT "ren:riks_ren_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sametinget:flyttled" + ADD CONSTRAINT "sametinget:flyttled_pkey" PRIMARY KEY (ogc_fid); -- --- Name: ri:friluftsliv ri:friluftsliv_OMRADESNR_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen sametinget:riksintresse_rennaringen_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:friluftsliv" - ADD CONSTRAINT "ri:friluftsliv_OMRADESNR_key" UNIQUE ("OMRADESNR"); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen" + ADD CONSTRAINT "sametinget:riksintresse_rennaringen_GlobalID_key" UNIQUE ("GlobalID"); -- --- Name: ri:friluftsliv ri:friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade sametinget:riksintresse_rennaringen_karnomrade_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:friluftsliv" - ADD CONSTRAINT "ri:friluftsliv_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen_karnomrade" + ADD CONSTRAINT "sametinget:riksintresse_rennaringen_karnomrade_GlobalID_key" UNIQUE ("GlobalID"); -- --- Name: ri:naturvard ri:naturvard_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade sametinget:riksintresse_rennaringen_karnomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:naturvard" - ADD CONSTRAINT "ri:naturvard_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen_karnomrade" + ADD CONSTRAINT "sametinget:riksintresse_rennaringen_karnomrade_pkey" PRIMARY KEY (ogc_fid); -- --- Name: ri:obruten_kust ri:obruten_kust_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen sametinget:riksintresse_rennaringen_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:obruten_kust" - ADD CONSTRAINT "ri:obruten_kust_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen" + ADD CONSTRAINT "sametinget:riksintresse_rennaringen_pkey" PRIMARY KEY (ogc_fid); -- --- Name: ri:obrutet_fjall ri:obrutet_fjall_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:atervatningsavtal sks:atervatningsavtal_Uuid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:obrutet_fjall" - ADD CONSTRAINT "ri:obrutet_fjall_ORIGINALID_key" UNIQUE ("ORIGINALID"); +ALTER TABLE ONLY postgis."sks:atervatningsavtal" + ADD CONSTRAINT "sks:atervatningsavtal_Uuid_key" UNIQUE ("Uuid"); -- --- Name: ri:obrutet_fjall ri:obrutet_fjall_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:atervatningsavtal sks:atervatningsavtal_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:obrutet_fjall" - ADD CONSTRAINT "ri:obrutet_fjall_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sks:atervatningsavtal" + ADD CONSTRAINT "sks:atervatningsavtal_pkey" PRIMARY KEY (ogc_fid); -- --- Name: ri:rorligt_friluftsliv ri:rorligt_friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_anmald sks:avverk_anmald_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:rorligt_friluftsliv" - ADD CONSTRAINT "ri:rorligt_friluftsliv_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sks:avverk_anmald" + ADD CONSTRAINT "sks:avverk_anmald_OBJECTID_key" UNIQUE ("OBJECTID"); -- --- Name: ri:skyddade_vattendrag ri:skyddade_vattendrag_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_anmald sks:avverk_anmald_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:skyddade_vattendrag" - ADD CONSTRAINT "ri:skyddade_vattendrag_ORIGINALID_key" UNIQUE ("ORIGINALID"); +ALTER TABLE ONLY postgis."sks:avverk_anmald" + ADD CONSTRAINT "sks:avverk_anmald_pkey" PRIMARY KEY (ogc_fid); -- --- Name: ri:skyddade_vattendrag ri:skyddade_vattendrag_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_utford sks:avverk_utford_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ri:skyddade_vattendrag" - ADD CONSTRAINT "ri:skyddade_vattendrag_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sks:avverk_utford" + ADD CONSTRAINT "sks:avverk_utford_Beteckn_key" UNIQUE ("Beteckn"); -- --- Name: sametinget:betesomraden sametinget:betesomraden_SAMEBY_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_utford sks:avverk_utford_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:betesomraden" - ADD CONSTRAINT "sametinget:betesomraden_SAMEBY_ID_key" UNIQUE ("SAMEBY_ID"); +ALTER TABLE ONLY postgis."sks:avverk_utford" + ADD CONSTRAINT "sks:avverk_utford_OBJECTID_key" UNIQUE ("OBJECTID"); -- --- Name: sametinget:betesomraden sametinget:betesomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_utford sks:avverk_utford_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:betesomraden" - ADD CONSTRAINT "sametinget:betesomraden_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sks:avverk_utford" + ADD CONSTRAINT "sks:avverk_utford_pkey" PRIMARY KEY (ogc_fid); -- --- Name: sametinget:flyttled sametinget:flyttled_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvarde sks:naturvarde_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:flyttled" - ADD CONSTRAINT "sametinget:flyttled_GlobalID_key" UNIQUE ("GlobalID"); +ALTER TABLE ONLY postgis."sks:naturvarde" + ADD CONSTRAINT "sks:naturvarde_Beteckn_key" UNIQUE ("Beteckn"); -- --- Name: sametinget:flyttled sametinget:flyttled_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvarde sks:naturvarde_ObjectId_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:flyttled" - ADD CONSTRAINT "sametinget:flyttled_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sks:naturvarde" + ADD CONSTRAINT "sks:naturvarde_ObjectId_key" UNIQUE ("ObjectId"); -- --- Name: sks:AvverkAnm sks:AvverkAnm_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvarde sks:naturvarde_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:AvverkAnm" - ADD CONSTRAINT "sks:AvverkAnm_OBJECTID_key" UNIQUE ("OBJECTID"); +ALTER TABLE ONLY postgis."sks:naturvarde" + ADD CONSTRAINT "sks:naturvarde_pkey" PRIMARY KEY (ogc_fid); -- --- Name: sks:AvverkAnm sks:AvverkAnm_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvardsavtal sks:naturvardsavtal_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:AvverkAnm" - ADD CONSTRAINT "sks:AvverkAnm_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sks:naturvardsavtal" + ADD CONSTRAINT "sks:naturvardsavtal_Beteckn_key" UNIQUE ("Beteckn"); -- --- Name: sks:UtfordAvverk sks:UtfordAvverk_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvardsavtal sks:naturvardsavtal_Uuid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:UtfordAvverk" - ADD CONSTRAINT "sks:UtfordAvverk_Beteckn_key" UNIQUE ("Beteckn"); +ALTER TABLE ONLY postgis."sks:naturvardsavtal" + ADD CONSTRAINT "sks:naturvardsavtal_Uuid_key" UNIQUE ("Uuid"); -- --- Name: sks:UtfordAvverk sks:UtfordAvverk_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvardsavtal sks:naturvardsavtal_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:UtfordAvverk" - ADD CONSTRAINT "sks:UtfordAvverk_OBJECTID_key" UNIQUE ("OBJECTID"); +ALTER TABLE ONLY postgis."sks:naturvardsavtal" + ADD CONSTRAINT "sks:naturvardsavtal_pkey" PRIMARY KEY (ogc_fid); -- --- Name: sks:UtfordAvverk sks:UtfordAvverk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:nyckelbiotop sks:nyckelbiotop_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:UtfordAvverk" - ADD CONSTRAINT "sks:UtfordAvverk_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sks:nyckelbiotop" + ADD CONSTRAINT "sks:nyckelbiotop_Beteckn_key" UNIQUE ("Beteckn"); + + +-- +-- Name: sks:nyckelbiotop sks:nyckelbiotop_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sks:nyckelbiotop" + ADD CONSTRAINT "sks:nyckelbiotop_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: sks:nyckelbiotop_storskogsbruk sks:nyckelbiotop_storskogsbruk_objectid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sks:nyckelbiotop_storskogsbruk" + ADD CONSTRAINT "sks:nyckelbiotop_storskogsbruk_objectid_key" UNIQUE (objectid); + + +-- +-- Name: sks:nyckelbiotop_storskogsbruk sks:nyckelbiotop_storskogsbruk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sks:nyckelbiotop_storskogsbruk" + ADD CONSTRAINT "sks:nyckelbiotop_storskogsbruk_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: sks:sumpskog sks:sumpskog_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sks:sumpskog" + ADD CONSTRAINT "sks:sumpskog_OBJECTID_key" UNIQUE ("OBJECTID"); + + +-- +-- Name: sks:sumpskog sks:sumpskog_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sks:sumpskog" + ADD CONSTRAINT "sks:sumpskog_pkey" PRIMARY KEY (ogc_fid); -- @@ -4684,6 +8417,41 @@ CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_ge -- +-- Name: lst:pagaende_naturreservatsbildning_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:pagaende_naturreservatsbildning_wkb_geometry_geom_idx" ON postgis."lst:pagaende_naturreservatsbildning" USING gist (wkb_geometry); + + +-- +-- Name: lst:riksintresse_obruten_kust_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:riksintresse_obruten_kust_wkb_geometry_geom_idx" ON postgis."lst:riksintresse_obruten_kust" USING gist (wkb_geometry); + + +-- +-- Name: lst:riksintresse_obrutet_fjall_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:riksintresse_obrutet_fjall_wkb_geometry_geom_idx" ON postgis."lst:riksintresse_obrutet_fjall" USING gist (wkb_geometry); + + +-- +-- Name: lst:riksintresse_rorligt_friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:riksintresse_rorligt_friluftsliv_wkb_geometry_geom_idx" ON postgis."lst:riksintresse_rorligt_friluftsliv" USING gist (wkb_geometry); + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:riksintresse_skyddade_vattendrag_wkb_geometry_geom_idx" ON postgis."lst:riksintresse_skyddade_vattendrag" USING gist (wkb_geometry); + + +-- -- Name: mrr:bearbetningskoncessioner_ansokta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -4775,17 +8543,31 @@ CREATE INDEX "mrr:ut_olja_gas_diamant_forfallna_wkb_geometry_geom_idx" ON postgi -- --- Name: nva:Naturvardsverket_Lansstyrelse_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: nvk:naturvardsavtal_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvk:naturvardsavtal_wkb_geometry_geom_idx" ON postgis."nvk:naturvardsavtal" USING gist (wkb_geometry); + + +-- +-- Name: nvk:riksintresse_friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvk:riksintresse_friluftsliv_wkb_geometry_geom_idx" ON postgis."nvk:riksintresse_friluftsliv" USING gist (wkb_geometry); + + +-- +-- Name: nvk:riksintresse_naturvard_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "nva:Naturvardsverket_Lansstyrelse_wkb_geometry_geom_idx" ON postgis."nva:Naturvardsverket_Lansstyrelse" USING gist (wkb_geometry); +CREATE INDEX "nvk:riksintresse_naturvard_wkb_geometry_geom_idx" ON postgis."nvk:riksintresse_naturvard" USING gist (wkb_geometry); -- --- Name: nva:Skogsstyrelsen_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: nvk:skyddsvard_statlig_skog_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "nva:Skogsstyrelsen_wkb_geometry_geom_idx" ON postgis."nva:Skogsstyrelsen" USING gist (wkb_geometry); +CREATE INDEX "nvk:skyddsvard_statlig_skog_wkb_geometry_geom_idx" ON postgis."nvk:skyddsvard_statlig_skog" USING gist (wkb_geometry); -- @@ -4929,87 +8711,87 @@ CREATE INDEX "nvr:Vattenskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Vatt -- --- Name: ren:omr_riks_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ren:omr_riks_wkb_geometry_geom_idx" ON postgis."ren:omr_riks" USING gist (wkb_geometry); +CREATE INDEX "sametinget:betesomrade_wkb_geometry_geom_idx" ON postgis."sametinget:betesomrade" USING gist (wkb_geometry); -- --- Name: ren:riks_ren_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ren:riks_ren_wkb_geometry_geom_idx" ON postgis."ren:riks_ren" USING gist (wkb_geometry); +CREATE INDEX "sametinget:flyttled_wkb_geometry_geom_idx" ON postgis."sametinget:flyttled" USING gist (wkb_geometry); -- --- Name: ri:friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ri:friluftsliv_wkb_geometry_geom_idx" ON postgis."ri:friluftsliv" USING gist (wkb_geometry); +CREATE INDEX "sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_idx" ON postgis."sametinget:riksintresse_rennaringen_karnomrade" USING gist (wkb_geometry); -- --- Name: ri:naturvard_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ri:naturvard_wkb_geometry_geom_idx" ON postgis."ri:naturvard" USING gist (wkb_geometry); +CREATE INDEX "sametinget:riksintresse_rennaringen_wkb_geometry_geom_idx" ON postgis."sametinget:riksintresse_rennaringen" USING gist (wkb_geometry); -- --- Name: ri:obruten_kust_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sks:atervatningsavtal_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ri:obruten_kust_wkb_geometry_geom_idx" ON postgis."ri:obruten_kust" USING gist (wkb_geometry); +CREATE INDEX "sks:atervatningsavtal_wkb_geometry_geom_idx" ON postgis."sks:atervatningsavtal" USING gist (wkb_geometry); -- --- Name: ri:obrutet_fjall_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_anmald_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ri:obrutet_fjall_wkb_geometry_geom_idx" ON postgis."ri:obrutet_fjall" USING gist (wkb_geometry); +CREATE INDEX "sks:avverk_anmald_wkb_geometry_geom_idx" ON postgis."sks:avverk_anmald" USING gist (wkb_geometry); -- --- Name: ri:rorligt_friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sks:avverk_utford_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ri:rorligt_friluftsliv_wkb_geometry_geom_idx" ON postgis."ri:rorligt_friluftsliv" USING gist (wkb_geometry); +CREATE INDEX "sks:avverk_utford_wkb_geometry_geom_idx" ON postgis."sks:avverk_utford" USING gist (wkb_geometry); -- --- Name: ri:skyddade_vattendrag_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvarde_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ri:skyddade_vattendrag_wkb_geometry_geom_idx" ON postgis."ri:skyddade_vattendrag" USING gist (wkb_geometry); +CREATE INDEX "sks:naturvarde_wkb_geometry_geom_idx" ON postgis."sks:naturvarde" USING gist (wkb_geometry); -- --- Name: sametinget:betesomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sks:naturvardsavtal_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sametinget:betesomraden_wkb_geometry_geom_idx" ON postgis."sametinget:betesomraden" USING gist (wkb_geometry); +CREATE INDEX "sks:naturvardsavtal_wkb_geometry_geom_idx" ON postgis."sks:naturvardsavtal" USING gist (wkb_geometry); -- --- Name: sametinget:flyttled_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sks:nyckelbiotop_storskogsbruk_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sametinget:flyttled_wkb_geometry_geom_idx" ON postgis."sametinget:flyttled" USING gist (wkb_geometry); +CREATE INDEX "sks:nyckelbiotop_storskogsbruk_wkb_geometry_geom_idx" ON postgis."sks:nyckelbiotop_storskogsbruk" USING gist (wkb_geometry); -- --- Name: sks:AvverkAnm_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sks:nyckelbiotop_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sks:AvverkAnm_wkb_geometry_geom_idx" ON postgis."sks:AvverkAnm" USING gist (wkb_geometry); +CREATE INDEX "sks:nyckelbiotop_wkb_geometry_geom_idx" ON postgis."sks:nyckelbiotop" USING gist (wkb_geometry); -- --- Name: sks:UtfordAvverk_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sks:sumpskog_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sks:UtfordAvverk_wkb_geometry_geom_idx" ON postgis."sks:UtfordAvverk" USING gist (wkb_geometry); +CREATE INDEX "sks:sumpskog_wkb_geometry_geom_idx" ON postgis."sks:sumpskog" USING gist (wkb_geometry); -- @@ -5222,6 +9004,76 @@ GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_sub_ogc_fid_seq TO webmap_guest; -- +-- Name: TABLE "lst:pagaende_naturreservatsbildning"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:pagaende_naturreservatsbildning" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:pagaende_naturreservatsbildning_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "lst:riksintresse_obruten_kust"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:riksintresse_obruten_kust" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:riksintresse_obruten_kust_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "lst:riksintresse_obrutet_fjall"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:riksintresse_obrutet_fjall" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:riksintresse_obrutet_fjall_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "lst:riksintresse_rorligt_friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:riksintresse_rorligt_friluftsliv" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "lst:riksintresse_skyddade_vattendrag"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:riksintresse_skyddade_vattendrag" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:riksintresse_skyddade_vattendrag_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" TO webmap_guest; + + +-- -- Name: TABLE "mrr:bearbetningskoncessioner_ansokta"; Type: ACL; Schema: postgis; Owner: webmap_import -- @@ -5404,31 +9256,59 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fi -- --- Name: TABLE "nva:Naturvardsverket_Lansstyrelse"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvk:naturvardsavtal"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvk:naturvardsavtal" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvk:naturvardsavtal_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."nva:Naturvardsverket_Lansstyrelse" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" TO webmap_guest; -- --- Name: SEQUENCE "nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvk:riksintresse_friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvk:riksintresse_friluftsliv" TO webmap_guest; -- --- Name: TABLE "nva:Skogsstyrelsen"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvk:riksintresse_friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."nva:Skogsstyrelsen" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" TO webmap_guest; -- --- Name: SEQUENCE "nva:Skogsstyrelsen_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvk:riksintresse_naturvard"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvk:riksintresse_naturvard" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvk:riksintresse_naturvard_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvk:skyddsvard_statlig_skog"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvk:skyddsvard_statlig_skog" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvk:skyddsvard_statlig_skog_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" TO webmap_guest; -- @@ -5712,171 +9592,171 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" TO w -- --- Name: TABLE "ren:omr_riks"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:betesomrade"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ren:omr_riks" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sametinget:betesomrade" TO webmap_guest; -- --- Name: SEQUENCE "ren:omr_riks_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sametinget:betesomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "ren:riks_ren"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:flyttled"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ren:riks_ren" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sametinget:flyttled" TO webmap_guest; -- --- Name: SEQUENCE "ren:riks_ren_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sametinget:flyttled_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "ri:friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:riksintresse_rennaringen"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ri:friluftsliv" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sametinget:riksintresse_rennaringen" TO webmap_guest; -- --- Name: SEQUENCE "ri:friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:riksintresse_rennaringen_karnomrade"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" TO webmap_guest; -- --- Name: TABLE "ri:naturvard"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ri:naturvard" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" TO webmap_guest; -- --- Name: SEQUENCE "ri:naturvard_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sametinget:riksintresse_rennaringen_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:naturvard_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "ri:obruten_kust"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sks:atervatningsavtal"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ri:obruten_kust" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sks:atervatningsavtal" TO webmap_guest; -- --- Name: SEQUENCE "ri:obruten_kust_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sks:atervatningsavtal_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "ri:obrutet_fjall"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sks:avverk_anmald"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ri:obrutet_fjall" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sks:avverk_anmald" TO webmap_guest; -- --- Name: SEQUENCE "ri:obrutet_fjall_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sks:avverk_anmald_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "ri:rorligt_friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sks:avverk_utford"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ri:rorligt_friluftsliv" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sks:avverk_utford" TO webmap_guest; -- --- Name: SEQUENCE "ri:rorligt_friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sks:avverk_utford_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "ri:skyddade_vattendrag"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sks:naturvarde"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ri:skyddade_vattendrag" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sks:naturvarde" TO webmap_guest; -- --- Name: SEQUENCE "ri:skyddade_vattendrag_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sks:naturvarde_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "sametinget:betesomraden"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sks:naturvardsavtal"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."sametinget:betesomraden" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sks:naturvardsavtal" TO webmap_guest; -- --- Name: SEQUENCE "sametinget:betesomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sks:naturvardsavtal_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "sametinget:flyttled"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sks:nyckelbiotop"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."sametinget:flyttled" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sks:nyckelbiotop" TO webmap_guest; -- --- Name: SEQUENCE "sametinget:flyttled_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sks:nyckelbiotop_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "sks:AvverkAnm"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sks:nyckelbiotop_storskogsbruk"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."sks:AvverkAnm" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sks:nyckelbiotop_storskogsbruk" TO webmap_guest; -- --- Name: SEQUENCE "sks:AvverkAnm_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sks:nyckelbiotop_storskogsbruk_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "sks:UtfordAvverk"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sks:sumpskog"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."sks:UtfordAvverk" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sks:sumpskog" TO webmap_guest; -- --- Name: SEQUENCE "sks:UtfordAvverk_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sks:sumpskog_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" TO webmap_guest; -- |