From 35b84d8af9a0d03434a05e25989fe0e8b7ad1901 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Tue, 12 Aug 2025 19:53:09 +0200 Subject: Adjust SQL schema to PG 17 from Debian Trixie. Recent GDAL version can set comments on columns, which is now reflected on the schema. --- schema.sql | 4264 ++++++++++++++++++++++++++++++++++++++++++++++++++++-------- 1 file changed, 3743 insertions(+), 521 deletions(-) diff --git a/schema.sql b/schema.sql index b9896fd..49e02dc 100644 --- a/schema.sql +++ b/schema.sql @@ -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); @@ -214,6 +216,202 @@ ALTER TABLE postgis.dammar OWNER TO webmap_import; 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 @@ -299,6 +497,27 @@ ALTER TABLE postgis.kommunyta OWNER TO webmap_import; 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 @@ -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 @@ -376,6 +595,27 @@ ALTER TABLE postgis.lansyta OWNER TO webmap_import; 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 @@ -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 @@ -465,7 +705,7 @@ CREATE SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" OWNER TO webmap_import; +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 @@ -503,6 +743,13 @@ ALTER TABLE postgis."lst:riksintresse_obruten_kust" OWNER TO 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 -- @@ -515,7 +762,7 @@ CREATE SEQUENCE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" OWNER TO webmap_import; +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 @@ -563,7 +810,7 @@ CREATE SEQUENCE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" OWNER TO webmap_import; +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 @@ -600,6 +847,13 @@ ALTER TABLE postgis."lst:riksintresse_rorligt_friluftsliv" OWNER TO webmap_impor 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 -- @@ -612,7 +866,7 @@ CREATE SEQUENCE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; +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 @@ -650,6 +904,13 @@ ALTER TABLE postgis."lst:riksintresse_skyddade_vattendrag" OWNER TO webmap_impor 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 -- @@ -662,7 +923,7 @@ CREATE SEQUENCE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" OWNER TO webmap_import; +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 @@ -695,6 +956,41 @@ ALTER TABLE postgis."mrr:bearbetningskoncessioner_ansokta" OWNER TO webmap_impor COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_ansokta" IS 'Bearbetningskoncessioner, ansökta (SGU)'; +-- +-- 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 -- @@ -707,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 @@ -744,6 +1040,69 @@ ALTER TABLE postgis."mrr:bearbetningskoncessioner_beviljade" OWNER TO webmap_imp COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_beviljade" IS 'Bearbetningskoncessioner, beviljade (SGU)'; +-- +-- 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 -- @@ -756,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 @@ -791,7 +1150,49 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_forfallna" IS 'Bearbetnin -- --- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- 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 -- CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" @@ -802,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 @@ -834,6 +1235,34 @@ ALTER TABLE postgis."mrr:markanvisningar_bk_ansokta" OWNER TO webmap_import; COMMENT ON TABLE postgis."mrr:markanvisningar_bk_ansokta" IS 'Markanvisningar till bearbetningskoncessioner, ansökta (SGU)'; +-- +-- 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 -- @@ -846,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 @@ -880,6 +1309,48 @@ ALTER TABLE postgis."mrr:markanvisningar_bk_beviljade" OWNER TO webmap_import; COMMENT ON TABLE postgis."mrr:markanvisningar_bk_beviljade" IS 'Markanvisningar till bearbetningskoncessioner, beviljade (SGU)'; +-- +-- 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 -- @@ -892,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 @@ -925,6 +1396,41 @@ ALTER TABLE postgis."mrr:ut_diamant_ansokta" OWNER TO webmap_import; COMMENT ON TABLE postgis."mrr:ut_diamant_ansokta" IS 'Undersökningstillstånd - Diamant, ansökta (SGU)'; +-- +-- 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 -- @@ -937,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 @@ -974,6 +1480,69 @@ ALTER TABLE postgis."mrr:ut_diamant_beviljade" OWNER TO webmap_import; COMMENT ON TABLE postgis."mrr:ut_diamant_beviljade" IS 'Undersökningstillstånd - Diamant, beviljade (SGU)'; +-- +-- 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 -- @@ -986,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 @@ -1023,6 +1592,69 @@ ALTER TABLE postgis."mrr:ut_diamant_forbud" OWNER TO webmap_import; COMMENT ON TABLE postgis."mrr:ut_diamant_forbud" IS 'Undersökningstillstånd - Diamant, förbud (SGU)'; +-- +-- 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 -- @@ -1035,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 @@ -1068,6 +1700,41 @@ ALTER TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" OWNER TO webmap_im COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" IS 'Undersökningstillstånd - Metaller och industrimineral, ansökta (SGU)'; +-- +-- 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 -- @@ -1080,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 @@ -1118,67 +1785,193 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" IS 'Unders -- --- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".name IS 'Namn på beviljat undersökningstillstånd'; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_beviljade".ogc_fid; +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".licenceid IS 'Tillståndsid för undersökningstillståndet'; -- --- Name: mrr:ut_metaller_industrimineral_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."mrr:ut_metaller_industrimineral_forbud" ( - ogc_fid bigint NOT NULL, - name character varying(254) NOT NULL, - licenceid character varying(16), - diarynr character varying(16) NOT NULL, - validfrom date NOT NULL, - validto date NOT NULL, - mineral character varying(254) NOT NULL, - owners character varying(254) NOT NULL, - prospdata_url character varying(254), - prospdata_filesize_mb real, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".diarynr IS 'Ärendenummer i diariet'; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud" OWNER TO webmap_import; -- --- Name: TABLE "mrr:ut_metaller_industrimineral_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forbud" IS 'Undersökningstillstånd - Metaller och industrimineral, förbud (SGU)'; +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; -- --- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".dec_date IS 'Datum när undersökningstillståndet beviljades'; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNER TO webmap_import; +-- +-- 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 +-- + +CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 +-- + +ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNED BY postgis."mrr:ut_metaller_industrimineral_beviljade".ogc_fid; + + +-- +-- Name: mrr:ut_metaller_industrimineral_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."mrr:ut_metaller_industrimineral_forbud" ( + ogc_fid bigint NOT NULL, + name character varying(254) NOT NULL, + licenceid character varying(16), + diarynr character varying(16) NOT NULL, + validfrom date NOT NULL, + validto date NOT NULL, + mineral character varying(254) NOT NULL, + owners character varying(254) NOT NULL, + prospdata_url character varying(254), + prospdata_filesize_mb real, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud" OWNER TO webmap_import; + +-- +-- Name: TABLE "mrr:ut_metaller_industrimineral_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forbud" IS 'Undersökningstillstånd - Metaller och industrimineral, förbud (SGU)'; + + +-- +-- Name: 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 +-- + +CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 @@ -1215,6 +2008,69 @@ ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" OWNER TO webmap_ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" IS 'Undersökningstillstånd - Metaller och industrimineral, förfallna (SGU)'; +-- +-- 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 -- @@ -1227,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 @@ -1264,6 +2120,69 @@ ALTER TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" OWNER TO webmap_import; COMMENT ON TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" IS 'Undersökningstillstånd - Olja, gas och diamant, förfallna (SGU)'; +-- +-- 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 -- @@ -1276,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 @@ -1323,7 +2242,7 @@ CREATE SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvk:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1364,6 +2283,20 @@ ALTER TABLE postgis."nvk:riksintresse_friluftsliv" OWNER TO 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: COLUMN "nvk:riksintresse_friluftsliv"."AREA_VATTE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:riksintresse_friluftsliv"."AREA_VATTE" IS 'Areal vatten i hektar'; + + -- -- Name: nvk:riksintresse_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1376,7 +2309,7 @@ CREATE SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvk:riksintresse_friluftsliv_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 @@ -1424,7 +2357,7 @@ CREATE SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNER TO webmap_import; +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 @@ -1473,64 +2406,169 @@ COMMENT ON TABLE postgis."nvk:skyddsvard_statlig_skog" IS 'Skyddsvärda statliga -- --- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."AR"; Type: COMMENT; 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; - +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."AR" IS 'År'; -ALTER TABLE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."NATURGEOGR"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNED BY postgis."nvk:skyddsvard_statlig_skog".ogc_fid; +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."NATURGEOGR" IS 'Naturgeografisk region'; -- --- Name: nvr:Biosfarsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."OBJEKTKATE"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Biosfarsomraden" ( - ogc_fid bigint NOT NULL, - "SKYDDSTYP" character varying(32) NOT NULL, - "NAMN" character varying(32) NOT NULL, - "LINK" character varying(254) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."OBJEKTKATE" IS 'Objektskategori'; -ALTER TABLE postgis."nvr:Biosfarsomraden" OWNER TO webmap_import; -- --- Name: TABLE "nvr:Biosfarsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."MARKAGARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Biosfarsomraden" IS 'Biosfärsområden (UNESCO)'; +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."MARKAGARE" IS 'Markägare'; -- --- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."VARDEKARNA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."VARDEKARNA" IS 'Areal värdekärna (ha)'; -ALTER TABLE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import; - -- --- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- 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; + + +-- +-- Name: nvr:Biosfarsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Biosfarsomraden" ( + ogc_fid bigint NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "NAMN" character varying(32) NOT NULL, + "LINK" character varying(254) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Biosfarsomraden" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Biosfarsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Biosfarsomraden" IS 'Biosfärsområden (UNESCO)'; + + +-- +-- Name: 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 +-- + +CREATE SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 -- ALTER SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNED BY postgis."nvr:Biosfarsomraden".ogc_fid; @@ -1565,6 +2603,55 @@ ALTER TABLE postgis."nvr:Biotopskydd" OWNER TO webmap_import; COMMENT ON TABLE postgis."nvr:Biotopskydd" IS 'Biotopskydd i skogsmark (beslutade av Skogsstyrelsen)'; +-- +-- 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 -- @@ -1577,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 @@ -1622,6 +2709,125 @@ ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" OWNER TO webmap_import; COMMENT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" IS 'Djur- och växtskyddsområden'; +-- +-- 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 -- @@ -1634,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 @@ -1676,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 @@ -1722,124 +2928,129 @@ COMMENT ON TABLE postgis."nvr:Interimistiskt_forbud" IS 'Interimistiska förbud' -- --- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Interimistiskt_forbud"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +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'; -ALTER TABLE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Interimistiskt_forbud"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNED BY postgis."nvr:Interimistiskt_forbud".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."SKYDDSTYP" IS 'Skyddstyp'; -- --- Name: nvr:Kultureservat; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Interimistiskt_forbud"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Kultureservat" ( - ogc_fid bigint NOT NULL, - "NVRID" integer NOT NULL, - "NAMN" character varying(62) NOT NULL, - "SKYDDSTYP" character varying(32) NOT NULL, - "BESLSTATUS" character varying(12) NOT NULL, - "URSBESLDAT" date NOT NULL, - "IKRAFTDATF" date, - "URSGALLDAT" date, - "SENGALLDAT" date, - "IUCNKAT" character varying(254) NOT NULL, - "FORVALTARE" character varying(62) NOT NULL, - "LAND_HA" double precision, - "VATTEN_HA" double precision, - "SKOG_HA" double precision, - "GEOSTATUS" character varying(62) NOT NULL, - "DIARIENR" character varying(62), - "LAGRUM" character varying(16) NOT NULL, - "BESLMYND" character varying(32) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."BESLSTATUS" IS 'Beslutsstatus'; -ALTER TABLE postgis."nvr:Kultureservat" OWNER TO webmap_import; +-- +-- 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: TABLE "nvr:Kultureservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Interimistiskt_forbud"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Kultureservat" IS 'Kulturreservat'; +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; -- --- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Interimistiskt_forbud"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +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'; -ALTER TABLE postgis."nvr:Kultureservat_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Interimistiskt_forbud"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" OWNED BY postgis."nvr:Kultureservat".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; -- --- Name: nvr:Landskapsbildsskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Interimistiskt_forbud"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Landskapsbildsskyddsomrade" ( - ogc_fid bigint NOT NULL, - "NVRID" integer NOT NULL, - "NAMN" character varying(62) NOT NULL, - "SKYDDSTYP" character varying(32) NOT NULL, - "BESLSTATUS" character varying(12) NOT NULL, - "URSBESLDAT" date NOT NULL, - "IKRAFTDATF" date, - "URSGALLDAT" date, - "SENGALLDAT" date, - "IUCNKAT" character varying(254) NOT NULL, - "FORVALTARE" character varying(62) NOT NULL, - "LAND_HA" double precision, - "VATTEN_HA" double precision, - "SKOG_HA" double precision, - "GEOSTATUS" character varying(62) NOT NULL, - "DIARIENR" character varying(62), - "LAGRUM" character varying(16), - "BESLMYND" character varying(32) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."FORVALTARE" IS 'Förvaltare för området'; -ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade" OWNER TO webmap_import; +-- +-- 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: TABLE "nvr:Landskapsbildsskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Interimistiskt_forbud"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" IS 'Landskapsbildsskyddsområden'; +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; -- --- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Interimistiskt_forbud"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" +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 +-- + +CREATE SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1847,20 +3058,20 @@ 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:Interimistiskt_forbud_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Landskapsbildsskyddsomrade".ogc_fid; +ALTER SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNED BY postgis."nvr:Interimistiskt_forbud".ogc_fid; -- --- Name: nvr:Nationalpark; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Kultureservat; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Nationalpark" ( +CREATE TABLE postgis."nvr:Kultureservat" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, @@ -1883,188 +3094,139 @@ CREATE TABLE postgis."nvr:Nationalpark" ( ); -ALTER TABLE postgis."nvr:Nationalpark" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Kultureservat" OWNER TO webmap_import; -- --- Name: TABLE "nvr:Nationalpark"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Kultureservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Nationalpark" IS 'Nationalparker'; +COMMENT ON TABLE postgis."nvr:Kultureservat" IS 'Kulturreservat'; -- --- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - +COMMENT ON COLUMN postgis."nvr:Kultureservat"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; -ALTER TABLE postgis."nvr:Nationalpark_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" OWNED BY postgis."nvr:Nationalpark".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Kultureservat"."NAMN" IS 'Områdets namn'; -- --- Name: nvr:Naturminne_punkt; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Naturminne_punkt" ( - ogc_fid bigint NOT NULL, - "NVRID" integer NOT NULL, - "NAMN" character varying(62) NOT NULL, - "SKYDDSTYP" character varying(32) NOT NULL, - "BESLSTATUS" character varying(12) NOT NULL, - "URSBESLDAT" date NOT NULL, - "IKRAFTDATF" date, - "URSGALLDAT" date, - "SENGALLDAT" date, - "IUCNKAT" character varying(254) NOT NULL, - "FORVALTARE" character varying(62) NOT NULL, - "GEOSTATUS" character varying(62) NOT NULL, - "DIARIENR" character varying(62), - "LAGRUM" character varying(64) NOT NULL, - "BESLMYND" character varying(32) NOT NULL, - wkb_geometry postgis.geometry(MultiPoint,3006) NOT NULL -); +COMMENT ON COLUMN postgis."nvr:Kultureservat"."SKYDDSTYP" IS 'Skyddstyp'; -ALTER TABLE postgis."nvr:Naturminne_punkt" OWNER TO webmap_import; +-- +-- Name: COLUMN "nvr:Kultureservat"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."BESLSTATUS" IS 'Beslutsstatus'; + -- --- Name: TABLE "nvr:Naturminne_punkt"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt'; +COMMENT ON COLUMN postgis."nvr:Kultureservat"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; -- --- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +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'; -ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_punkt".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Kultureservat"."SENGALLDAT" IS 'Senaste gällandedatum'; -- --- Name: nvr:Naturminne_yta; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Naturminne_yta" ( - ogc_fid bigint NOT NULL, - "NVRID" integer NOT NULL, - "NAMN" character varying(62) NOT NULL, - "SKYDDSTYP" character varying(32) NOT NULL, - "BESLSTATUS" character varying(12) NOT NULL, - "URSBESLDAT" date NOT NULL, - "IKRAFTDATF" date, - "URSGALLDAT" date, - "SENGALLDAT" date, - "IUCNKAT" character varying(254) NOT NULL, - "FORVALTARE" character varying(62) NOT NULL, - "LAND_HA" double precision, - "VATTEN_HA" double precision, - "SKOG_HA" double precision, - "GEOSTATUS" character varying(62) NOT NULL, - "DIARIENR" character varying(62), - "LAGRUM" character varying(64) NOT NULL, - "BESLMYND" character varying(32) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); +COMMENT ON COLUMN postgis."nvr:Kultureservat"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; -ALTER TABLE postgis."nvr:Naturminne_yta" OWNER TO webmap_import; +-- +-- 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: TABLE "nvr:Naturminne_yta"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Naturminne_yta" IS 'Naturminne, yta'; +COMMENT ON COLUMN postgis."nvr:Kultureservat"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; -- --- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +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'; -ALTER TABLE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_yta".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Kultureservat"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; -- --- Name: nvr:Naturreservat; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Naturreservat" ( - ogc_fid bigint NOT NULL, - "NVRID" integer NOT NULL, - "NAMN" character varying(128) NOT NULL, - "SKYDDSTYP" character varying(32) NOT NULL, - "BESLSTATUS" character varying(12) NOT NULL, - "URSBESLDAT" date NOT NULL, - "IKRAFTDATF" date, - "URSGALLDAT" date, - "SENGALLDAT" date, - "IUCNKAT" character varying(254) NOT NULL, - "FORVALTARE" character varying(62) NOT NULL, - "LAND_HA" double precision, - "VATTEN_HA" double precision, - "SKOG_HA" double precision, - "GEOSTATUS" character varying(62) NOT NULL, - "DIARIENR" character varying(62), - "LAGRUM" character varying(16), - "BESLMYND" character varying(32) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); +COMMENT ON COLUMN postgis."nvr:Kultureservat"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; -ALTER TABLE postgis."nvr:Naturreservat" OWNER TO webmap_import; +-- +-- 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: TABLE "nvr:Naturreservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Kultureservat"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Naturreservat" IS 'Naturreservat'; +COMMENT ON COLUMN postgis."nvr:Kultureservat"."BESLMYND" IS 'Beslutsmyndighet'; -- --- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -2072,23 +3234,23 @@ 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:Kultureservat_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" OWNED BY postgis."nvr:Naturreservat".ogc_fid; +ALTER SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" OWNED BY postgis."nvr:Kultureservat".ogc_fid; -- --- Name: nvr:Naturvardsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Landskapsbildsskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Naturvardsomrade" ( +CREATE TABLE postgis."nvr:Landskapsbildsskyddsomrade" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, - "NAMN" character varying(64) NOT NULL, + "NAMN" character varying(62) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, "URSBESLDAT" date NOT NULL, @@ -2102,49 +3264,1024 @@ CREATE TABLE postgis."nvr:Naturvardsomrade" ( "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), - "LAGRUM" character varying(16) NOT NULL, + "LAGRUM" character varying(16), "BESLMYND" character varying(32) NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); -ALTER TABLE postgis."nvr:Naturvardsomrade" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade" OWNER TO webmap_import; -- --- Name: TABLE "nvr:Naturvardsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Landskapsbildsskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Naturvardsomrade" IS 'Naturvårdsområden'; +COMMENT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" IS 'Landskapsbildsskyddsområden'; -- --- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +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'; -ALTER TABLE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Naturvardsomrade".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; -- --- Name: nvr:OSPAR; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:OSPAR" ( - ogc_fid bigint NOT NULL, - "ORIGIN" character varying(10) NOT NULL, +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 +-- + +CREATE SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 +-- + +ALTER SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Landskapsbildsskyddsomrade".ogc_fid; + + +-- +-- Name: nvr:Nationalpark; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Nationalpark" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "IUCNKAT" character varying(254) NOT NULL, + "FORVALTARE" character varying(62) NOT NULL, + "LAND_HA" double precision, + "VATTEN_HA" double precision, + "SKOG_HA" double precision, + "GEOSTATUS" character varying(62) NOT NULL, + "DIARIENR" character varying(62), + "LAGRUM" character varying(16) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Nationalpark" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Nationalpark"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Nationalpark" IS 'Nationalparker'; + + +-- +-- Name: 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 +-- + +CREATE SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 +-- + +ALTER SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" OWNED BY postgis."nvr:Nationalpark".ogc_fid; + + +-- +-- Name: nvr:Naturminne_punkt; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Naturminne_punkt" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "IUCNKAT" character varying(254) NOT NULL, + "FORVALTARE" character varying(62) NOT NULL, + "GEOSTATUS" character varying(62) NOT NULL, + "DIARIENR" character varying(62), + "LAGRUM" character varying(64) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPoint,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Naturminne_punkt" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Naturminne_punkt"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt'; + + +-- +-- Name: 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 +-- + +CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 +-- + +ALTER SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_punkt".ogc_fid; + + +-- +-- Name: nvr:Naturminne_yta; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Naturminne_yta" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "IUCNKAT" character varying(254) NOT NULL, + "FORVALTARE" character varying(62) NOT NULL, + "LAND_HA" double precision, + "VATTEN_HA" double precision, + "SKOG_HA" double precision, + "GEOSTATUS" character varying(62) NOT NULL, + "DIARIENR" character varying(62), + "LAGRUM" character varying(64) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Naturminne_yta" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Naturminne_yta"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Naturminne_yta" IS 'Naturminne, yta'; + + +-- +-- Name: 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 +-- + +CREATE SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 +-- + +ALTER SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_yta".ogc_fid; + + +-- +-- Name: nvr:Naturreservat; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Naturreservat" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(128) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "IUCNKAT" character varying(254) NOT NULL, + "FORVALTARE" character varying(62) NOT NULL, + "LAND_HA" double precision, + "VATTEN_HA" double precision, + "SKOG_HA" double precision, + "GEOSTATUS" character varying(62) NOT NULL, + "DIARIENR" character varying(62), + "LAGRUM" character varying(16), + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Naturreservat" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Naturreservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Naturreservat" IS 'Naturreservat'; + + +-- +-- Name: 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 +-- + +CREATE SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 +-- + +ALTER SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" OWNED BY postgis."nvr:Naturreservat".ogc_fid; + + +-- +-- Name: nvr:Naturvardsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Naturvardsomrade" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(64) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "IUCNKAT" character varying(254) NOT NULL, + "FORVALTARE" character varying(62) NOT NULL, + "LAND_HA" double precision, + "VATTEN_HA" double precision, + "SKOG_HA" double precision, + "GEOSTATUS" character varying(62) NOT NULL, + "DIARIENR" character varying(62), + "LAGRUM" character varying(16) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Naturvardsomrade" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Naturvardsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Naturvardsomrade" IS 'Naturvårdsområden'; + + +-- +-- Name: 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 +-- + +CREATE SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 +-- + +ALTER SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Naturvardsomrade".ogc_fid; + + +-- +-- Name: nvr:OSPAR; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:OSPAR" ( + ogc_fid bigint NOT NULL, + "ORIGIN" character varying(10) NOT NULL, "NAMN_N2000" character varying(64) NOT NULL, "MPA_ID" character varying(16) NOT NULL, "MPA_NAMN" character varying(64) NOT NULL, @@ -2153,70 +4290,189 @@ CREATE TABLE postgis."nvr:OSPAR" ( ); -ALTER TABLE postgis."nvr:OSPAR" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:OSPAR" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:OSPAR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:OSPAR" IS 'Marina skyddade områden (Ospar MPA)'; + + +-- +-- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER 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 +-- + +ALTER SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" OWNED BY postgis."nvr:OSPAR".ogc_fid; + + +-- +-- Name: nvr:Ovrigt_biotopskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "IUCNKAT" character varying(254) NOT NULL, + "FORVALTARE" character varying(62) NOT NULL, + "LAND_HA" double precision, + "VATTEN_HA" double precision, + "SKOG_HA" double precision, + "GEOSTATUS" character varying(62) NOT NULL, + "DIARIENR" character varying(62), + "LAGRUM" character varying(16) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Ovrigt_biotopskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" IS 'Biotopskydd utanför skogsmark'; + + +-- +-- Name: 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: TABLE "nvr:OSPAR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:OSPAR" IS 'Marina skyddade områden (Ospar MPA)'; +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; -- --- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +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'; -ALTER TABLE postgis."nvr:OSPAR_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" OWNED BY postgis."nvr:OSPAR".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; -- --- Name: nvr:Ovrigt_biotopskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" ( - ogc_fid bigint NOT NULL, - "NVRID" integer NOT NULL, - "NAMN" character varying(62) NOT NULL, - "SKYDDSTYP" character varying(32) NOT NULL, - "BESLSTATUS" character varying(12) NOT NULL, - "URSBESLDAT" date NOT NULL, - "IKRAFTDATF" date, - "URSGALLDAT" date, - "SENGALLDAT" date, - "IUCNKAT" character varying(254) NOT NULL, - "FORVALTARE" character varying(62) NOT NULL, - "LAND_HA" double precision, - "VATTEN_HA" double precision, - "SKOG_HA" double precision, - "GEOSTATUS" character varying(62) NOT NULL, - "DIARIENR" character varying(62), - "LAGRUM" character varying(16) NOT NULL, - "BESLMYND" character varying(32) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; -ALTER TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" OWNER TO webmap_import; +-- +-- 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: TABLE "nvr:Ovrigt_biotopskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" IS 'Biotopskydd utanför skogsmark'; +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."BESLMYND" IS 'Beslutsmyndighet'; -- @@ -2231,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 @@ -2270,6 +4526,34 @@ ALTER TABLE postgis."nvr:Ramsar" OWNER TO webmap_import; 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 -- @@ -2282,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 @@ -2323,6 +4607,13 @@ ALTER TABLE postgis."nvr:SCI_Rikstackande" OWNER TO webmap_import; COMMENT ON TABLE postgis."nvr:SCI_Rikstackande" IS 'Habitatdirektivet (SCI, direktiv 92/43/EEG)'; +-- +-- 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 -- @@ -2335,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 @@ -2376,6 +4667,13 @@ ALTER TABLE postgis."nvr:SPA_Rikstackande" OWNER TO webmap_import; COMMENT ON TABLE postgis."nvr:SPA_Rikstackande" IS 'Fågeldirektivet (SPA, direktiv 79/409/EEG)'; +-- +-- 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 -- @@ -2388,141 +4686,288 @@ 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 +-- + +ALTER SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNED BY postgis."nvr:SPA_Rikstackande".ogc_fid; + + +-- +-- Name: nvr:Tilltradesforbud; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Tilltradesforbud" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "BESLSTAT" character varying(12) NOT NULL, + "FORESKRTYP" character varying(16) NOT NULL, + "FORESKRIFT" character varying(62) NOT NULL, + "FRANDATUM" character varying(10) NOT NULL, + "TILLDATUM" character varying(10) NOT NULL, + "BESKRIVN" character varying(254), + "OBJEKTNAMN" character varying(254) NOT NULL, + "FORSKRNAMN" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Tilltradesforbud" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Tilltradesforbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Tilltradesforbud" IS 'Områden med föreskrifter som inskränker rätten att färdas eller vistas i området, permanent eller under en del av året'; + + +-- +-- Name: 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 +-- + +CREATE SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +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 +-- + +ALTER SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNED BY postgis."nvr:Tilltradesforbud".ogc_fid; + + +-- +-- Name: nvr:Varldsarv; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Varldsarv" ( + ogc_fid bigint NOT NULL, + "NAMN" character varying(64) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Varldsarv" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Varldsarv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Varldsarv" IS 'Världsarv med mycket höga naturvärden (UNESCO)'; + + +-- +-- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER 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 +-- + +ALTER SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" OWNED BY postgis."nvr:Varldsarv".ogc_fid; + + +-- +-- Name: nvr:Vattenskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Vattenskyddsomrade" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(254) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "TILLSYNSMH" character varying(64) NOT NULL, + "PROVNMHDIS" character varying(64), + "PROVNMHTIL" character varying(64), + "IUCNKAT" character varying(254) NOT NULL, + "LAND_HA" double precision, + "VATTEN_HA" double precision, + "SKOG_HA" double precision, + "GEOSTATUS" character varying(62) NOT NULL, + "DIARIENR" character varying(62), + "LAGRUM" character varying(16), + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvr:Vattenskyddsomrade" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Vattenskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Vattenskyddsomrade" IS 'Vattenskyddsområden'; + + +-- +-- Name: 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: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNED BY postgis."nvr:SPA_Rikstackande".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; -- --- Name: nvr:Tilltradesforbud; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."TILLSYNSMH"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Tilltradesforbud" ( - ogc_fid bigint NOT NULL, - "NVRID" integer NOT NULL, - "BESLSTAT" character varying(12) NOT NULL, - "FORESKRTYP" character varying(16) NOT NULL, - "FORESKRIFT" character varying(62) NOT NULL, - "FRANDATUM" character varying(10) NOT NULL, - "TILLDATUM" character varying(10) NOT NULL, - "BESKRIVN" character varying(254), - "OBJEKTNAMN" character varying(254) NOT NULL, - "FORSKRNAMN" character varying(254), - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."TILLSYNSMH" IS 'Tillsynsmyndighet'; -ALTER TABLE postgis."nvr:Tilltradesforbud" OWNER TO webmap_import; -- --- Name: TABLE "nvr:Tilltradesforbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."PROVNMHDIS"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Tilltradesforbud" IS 'Områden med föreskrifter som inskränker rätten att färdas eller vistas i området, permanent eller under en del av året'; +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."PROVNMHDIS" IS 'Prövningsmyndighet för dispens'; -- --- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."PROVNMHTIL"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."PROVNMHTIL" IS 'Prövningsmyndighet för tillstånd'; -ALTER TABLE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNED BY postgis."nvr:Tilltradesforbud".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; -- --- Name: nvr:Varldsarv; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Varldsarv" ( - ogc_fid bigint NOT NULL, - "NAMN" character varying(64) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; -ALTER TABLE postgis."nvr:Varldsarv" OWNER TO webmap_import; -- --- Name: TABLE "nvr:Varldsarv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Varldsarv" IS 'Världsarv med mycket höga naturvärden (UNESCO)'; +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; -- --- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; -ALTER TABLE postgis."nvr:Varldsarv_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" OWNED BY postgis."nvr:Varldsarv".ogc_fid; +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; -- --- Name: nvr:Vattenskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Vattenskyddsomrade" ( - ogc_fid bigint NOT NULL, - "NVRID" integer NOT NULL, - "NAMN" character varying(254) NOT NULL, - "SKYDDSTYP" character varying(32) NOT NULL, - "BESLSTATUS" character varying(12) NOT NULL, - "URSBESLDAT" date NOT NULL, - "IKRAFTDATF" date, - "URSGALLDAT" date, - "SENGALLDAT" date, - "TILLSYNSMH" character varying(64) NOT NULL, - "PROVNMHDIS" character varying(64), - "PROVNMHTIL" character varying(64), - "IUCNKAT" character varying(254) NOT NULL, - "LAND_HA" double precision, - "VATTEN_HA" double precision, - "SKOG_HA" double precision, - "GEOSTATUS" character varying(62) NOT NULL, - "DIARIENR" character varying(62), - "LAGRUM" character varying(16), - "BESLMYND" character varying(32) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; -ALTER TABLE postgis."nvr:Vattenskyddsomrade" OWNER TO webmap_import; +-- +-- 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: TABLE "nvr:Vattenskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "nvr:Vattenskyddsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Vattenskyddsomrade" IS 'Vattenskyddsområden'; +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."BESLMYND" IS 'Beslutsmyndighet'; -- @@ -2537,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 @@ -2585,7 +5030,7 @@ CREATE SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sametinget:betesomrade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:betesomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2641,7 +5086,7 @@ 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."sametinget:flyttled_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2661,7 +5106,7 @@ CREATE TABLE postgis."sametinget:riksintresse_rennaringen" ( "SIGNATUR" character varying(25) NOT NULL, "LANK" character varying(254), "GlobalID" uuid NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); @@ -2689,7 +5134,7 @@ CREATE TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" ( "AKTUALITET" date NOT NULL, "SIGNATUR" character varying(25), "GlobalID" uuid NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); @@ -2714,7 +5159,7 @@ CREATE SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_ CACHE 1; -ALTER TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2735,7 +5180,7 @@ CREATE SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sametinget:riksintresse_rennaringen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2768,6 +5213,41 @@ ALTER TABLE postgis."sks:atervatningsavtal" OWNER TO webmap_import; COMMENT ON TABLE postgis."sks:atervatningsavtal" IS 'Återvätningsavtal'; +-- +-- Name: COLUMN "sks:atervatningsavtal"."Uuid"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:atervatningsavtal"."Uuid" IS 'Unikt ID'; + + +-- +-- Name: COLUMN "sks:atervatningsavtal"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +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 -- @@ -2780,7 +5260,7 @@ CREATE SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:atervatningsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2810,65 +5290,226 @@ CREATE TABLE postgis."sks:avverk_anmald" ( ); -ALTER TABLE postgis."sks:avverk_anmald" 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: COLUMN "sks:avverk_anmald"."NatforHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."NatforHa" IS 'Areal naturlig föryngring (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."AvvSasong"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +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 + NO MAXVALUE + CACHE 1; + + +ALTER SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" OWNED BY postgis."sks:avverk_anmald".ogc_fid; + + +-- +-- Name: sks:avverk_utford; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."sks:avverk_utford" ( + ogc_fid bigint NOT NULL, + "OBJECTID" integer NOT NULL, + "Beteckn" character varying(12), + "ArendeAr" smallint NOT NULL, + "Avverktyp" character varying(254) NOT NULL, + "Skogstyp" character varying(254) NOT NULL, + "AnmaldHa" real NOT NULL, + "NatforHa" real, + "Avvdatum" date, + "KallaDatum" character varying(62), + "Forebild" character varying(62), + "Efterbild" character varying(62), + "ArealHa" real NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."sks:avverk_utford" OWNER TO webmap_import; + +-- +-- Name: TABLE "sks:avverk_utford"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."sks:avverk_utford" IS 'Utförd avverkning (Skogsstyrelsen)'; + + +-- +-- Name: 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: COLUMN "sks:avverk_utford"."AnmaldHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."AnmaldHa" IS 'Areal anmält (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."NatforHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."NatforHa" IS 'Areal naturlig föryngring (ha)'; + -- --- Name: TABLE "sks:avverk_anmald"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:avverk_utford"."Avvdatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sks:avverk_anmald" IS 'Avverkningsanmälningar (Skogsstyrelsen)'; +COMMENT ON COLUMN postgis."sks:avverk_utford"."Avvdatum" IS 'Datum för avverkning'; -- --- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:avverk_utford"."KallaDatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - +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)'; -ALTER TABLE postgis."sks:avverk_anmald_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:avverk_utford"."Forebild"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" OWNED BY postgis."sks:avverk_anmald".ogc_fid; +COMMENT ON COLUMN postgis."sks:avverk_utford"."Forebild" IS 'Namnet på den gamla bilden i skillnadsanalysen'; -- --- Name: sks:avverk_utford; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:avverk_utford"."Efterbild"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sks:avverk_utford" ( - ogc_fid bigint NOT NULL, - "OBJECTID" integer NOT NULL, - "Beteckn" character varying(12), - "ArendeAr" smallint NOT NULL, - "Avverktyp" character varying(254) NOT NULL, - "Skogstyp" character varying(254) NOT NULL, - "AnmaldHa" real NOT NULL, - "NatforHa" real, - "Avvdatum" date, - "KallaDatum" character varying(62), - "Forebild" character varying(62), - "Efterbild" character varying(62), - "ArealHa" real NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - +COMMENT ON COLUMN postgis."sks:avverk_utford"."Efterbild" IS 'Namnet på den nya bilden i skillnadsanalysen'; -ALTER TABLE postgis."sks:avverk_utford" OWNER TO webmap_import; -- --- Name: TABLE "sks:avverk_utford"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:avverk_utford"."ArealHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sks:avverk_utford" IS 'Utförd avverkning (Skogsstyrelsen)'; +COMMENT ON COLUMN postgis."sks:avverk_utford"."ArealHa" IS 'Areal för ytan (ha)'; -- @@ -2883,7 +5524,7 @@ CREATE SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:avverk_utford_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:avverk_utford_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2922,6 +5563,41 @@ ALTER TABLE postgis."sks:naturvarde" OWNER TO 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: COLUMN "sks:naturvarde"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; + + -- -- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2934,7 +5610,7 @@ CREATE SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:naturvarde_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2973,6 +5649,41 @@ ALTER TABLE postgis."sks:naturvardsavtal" OWNER TO 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: COLUMN "sks:naturvardsavtal"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:naturvardsavtal"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +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 -- @@ -2985,7 +5696,7 @@ CREATE SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3028,6 +5739,34 @@ ALTER TABLE postgis."sks:nyckelbiotop" OWNER TO webmap_import; COMMENT ON TABLE postgis."sks:nyckelbiotop" IS 'Nyckelbiotoper - Skogsstyrelsen'; +-- +-- Name: COLUMN "sks:nyckelbiotop"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +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 -- @@ -3040,7 +5779,7 @@ CREATE SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:nyckelbiotop_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3072,6 +5811,34 @@ ALTER TABLE postgis."sks:nyckelbiotop_storskogsbruk" OWNER TO webmap_import; COMMENT ON TABLE postgis."sks:nyckelbiotop_storskogsbruk" IS 'Nyckelbiotoper - storskogsbruket'; +-- +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk".objectid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop_storskogsbruk".objectid IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk"."Org"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +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 -- @@ -3084,52 +5851,192 @@ CREATE SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: sks:nyckelbiotop_storskogsbruk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNED BY postgis."sks:nyckelbiotop_storskogsbruk".ogc_fid; + + +-- +-- Name: sks:sumpskog; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."sks:sumpskog" ( + ogc_fid bigint NOT NULL, + "OBJECTID" integer NOT NULL, + "Namn" character varying(62), + "Hydrtext" character varying(62), + "Tradtext" character varying(62) NOT NULL, + "Delklass" character varying(62), + "Klassu" character varying(62), + "Lovandel" character varying(62), + "Krontakn" character varying(62), + "Huggklas" character varying(62), + "Andelva" character varying(62), + "Ingrepp" character varying(62), + "Ingrpavv" character varying(62), + "Objnyck" character varying(62), + "Delnyck" character varying(62), + "Flygar" smallint, + "Faltdat" date, + "Invtekn" character varying(62) NOT NULL, + "Invdat" date NOT NULL, + "Ansvmynd" character varying(62) NOT NULL, + "Url" character varying(252) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."sks:sumpskog" OWNER TO webmap_import; + +-- +-- Name: TABLE "sks:sumpskog"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."sks:sumpskog" IS 'Sumpskogar'; + + +-- +-- Name: 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: sks:nyckelbiotop_storskogsbruk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:sumpskog"."Invdat"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNED BY postgis."sks:nyckelbiotop_storskogsbruk".ogc_fid; +COMMENT ON COLUMN postgis."sks:sumpskog"."Invdat" IS 'Inventeringdatum'; -- --- Name: sks:sumpskog; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:sumpskog"."Ansvmynd"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sks:sumpskog" ( - ogc_fid bigint NOT NULL, - "OBJECTID" integer NOT NULL, - "Namn" character varying(62), - "Hydrtext" character varying(62), - "Tradtext" character varying(62) NOT NULL, - "Delklass" character varying(62), - "Klassu" character varying(62), - "Lovandel" character varying(62), - "Krontakn" character varying(62), - "Huggklas" character varying(62), - "Andelva" character varying(62), - "Ingrepp" character varying(62), - "Ingrpavv" character varying(62), - "Objnyck" character varying(62), - "Delnyck" character varying(62), - "Flygar" smallint, - "Faltdat" date, - "Invtekn" character varying(62) NOT NULL, - "Invdat" date NOT NULL, - "Ansvmynd" character varying(62) NOT NULL, - "Url" character varying(252) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - +COMMENT ON COLUMN postgis."sks:sumpskog"."Ansvmynd" IS 'Ansvarig myndighet'; -ALTER TABLE postgis."sks:sumpskog" OWNER TO webmap_import; -- --- Name: TABLE "sks:sumpskog"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: COLUMN "sks:sumpskog"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sks:sumpskog" IS 'Sumpskogar'; +COMMENT ON COLUMN postgis."sks:sumpskog"."Url" IS 'Länk till Skogens pärlors formulär för objektet'; -- @@ -3144,7 +6051,7 @@ CREATE SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:sumpskog_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:sumpskog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3186,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 @@ -3226,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 @@ -3266,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 @@ -3309,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 @@ -3370,6 +6277,90 @@ ALTER TABLE postgis."vbk:havsbaserad_vindkraft" OWNER TO webmap_import; COMMENT ON TABLE postgis."vbk:havsbaserad_vindkraft" IS 'Vindbrukskollen havsbaserad vindkraft (Länsstyrelsen)'; +-- +-- 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 -- @@ -3382,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 @@ -3425,6 +6416,104 @@ ALTER TABLE postgis."vbk:projekteringsomraden" OWNER TO webmap_import; COMMENT ON TABLE postgis."vbk:projekteringsomraden" IS 'Vindbrukskollen landbaserade projekteringsområden (Länsstyrelsen)'; +-- +-- 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 -- @@ -3437,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 @@ -3487,6 +6576,139 @@ ALTER TABLE postgis."vbk:vindkraftverk" OWNER TO webmap_import; COMMENT ON TABLE postgis."vbk:vindkraftverk" IS 'Vindbrukskollen landbaserade vindkraftverk (Länsstyrelsen)'; +-- +-- 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 -- @@ -3499,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 @@ -3541,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 @@ -5503,10 +8725,10 @@ CREATE INDEX "sametinget:flyttled_wkb_geometry_geom_idx" ON postgis."sametinget: -- --- Name: sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_geo; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_geo" ON postgis."sametinget:riksintresse_rennaringen_karnomrade" USING gist (wkb_geometry); +CREATE INDEX "sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_idx" ON postgis."sametinget:riksintresse_rennaringen_karnomrade" USING gist (wkb_geometry); -- -- cgit v1.2.3