diff options
| -rw-r--r-- | schema.sql | 3370 |
1 files changed, 3296 insertions, 74 deletions
@@ -2,12 +2,13 @@ -- PostgreSQL database dump -- --- Dumped from database version 15.13 (Debian 15.13-0+deb12u1) --- Dumped by pg_dump version 15.13 (Debian 15.13-0+deb12u1) +-- Dumped from database version 17.5 (Debian 17.5-1) +-- Dumped by pg_dump version 17.5 (Debian 17.5-1) SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; +SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); @@ -31,6 +32,7 @@ ALTER DATABASE webmap OWNER TO postgres; SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; +SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); @@ -215,6 +217,202 @@ COMMENT ON TABLE postgis.dammar IS 'Dammar'; -- +-- Name: COLUMN dammar."DammID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DammID" IS 'Dammenhetens identitet'; + + +-- +-- Name: COLUMN dammar."LST_OBJID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."LST_OBJID" IS 'Länsstyrelsens objektid'; + + +-- +-- Name: COLUMN dammar."Datum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Datum" IS 'Datum för registrering av dammenheten i SVAR'; + + +-- +-- Name: COLUMN dammar."DNamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DNamn" IS 'Dammenhetens namn'; + + +-- +-- Name: COLUMN dammar."ByggAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."ByggAr" IS 'År för första byggnation av dammenheten'; + + +-- +-- Name: COLUMN dammar."DammHojd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DammHojd" IS 'Dammdelens högsta höjd (m)'; + + +-- +-- Name: COLUMN dammar."KronLangd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."KronLangd" IS 'Krönlängd (m)'; + + +-- +-- Name: COLUMN dammar."Fiskvag"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Fiskvag" IS 'Förekomst och typ av fiskväg vid dammenheten'; + + +-- +-- Name: COLUMN dammar."FiskvagByggAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."FiskvagByggAr" IS 'Byggår fiskväg'; + + +-- +-- Name: COLUMN dammar."Fiskavledare"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Fiskavledare" IS 'Finns fiskavledare till fiskvägen'; + + +-- +-- Name: COLUMN dammar."Vandringshinder"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Vandringshinder" IS 'Om dammenheten utgör ett vandringshinder'; + + +-- +-- Name: COLUMN dammar."HARO"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."HARO" IS 'Huvudavrinningsområdesnummer'; + + +-- +-- Name: COLUMN dammar."Vattendistrikt"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Vattendistrikt" IS 'Huvudavrinningsområdesnummer'; + + +-- +-- Name: COLUMN dammar.inrapp_lst; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.inrapp_lst IS 'Den Länsstyrelse dammenheten är inrapporterad av'; + + +-- +-- Name: COLUMN dammar.eu_cd; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.eu_cd IS 'Vattenförekomstidentitet'; + + +-- +-- Name: COLUMN dammar.vf_typ; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.vf_typ IS 'Typ av vattenförekomst'; + + +-- +-- Name: COLUMN dammar.vy_eucd; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.vy_eucd IS 'Vattenförekomstidentitet för eventuell vattenyta kopplat till dammanläggning'; + + +-- +-- Name: COLUMN dammar.vy_vf_typ; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.vy_vf_typ IS 'Typ av vattenförekomst för eventuell vattenyta kopplat till dammanläggning'; + + +-- +-- Name: COLUMN dammar."DammanlID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DammanlID" IS 'Identitet för eventuell dammanläggning dammenheten är kopplad till'; + + +-- +-- Name: COLUMN dammar."Namn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Namn" IS 'Dammanläggningens namn'; + + +-- +-- Name: COLUMN dammar."OmbyggAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."OmbyggAr" IS 'År för idrifttagande av anläggning i dess nuvarande skepnad'; + + +-- +-- Name: COLUMN dammar."DG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DG" IS 'Högsta dämningsgräns (m) enligt tillstånd'; + + +-- +-- Name: COLUMN dammar."SG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."SG" IS 'Högsta dämningsgräns (m) enligt tillstånd'; + + +-- +-- Name: COLUMN dammar."HojdSys"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."HojdSys" IS 'Höjdsystem som DG och SG räknats i'; + + +-- +-- Name: COLUMN dammar."MY"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."MY" IS 'Magasinsyta (km²) vid angiven DG'; + + +-- +-- Name: COLUMN dammar."RV"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."RV" IS 'Reglerbar volym (milj. m³)'; + + +-- +-- Name: COLUMN dammar."Kommentar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Kommentar" IS 'Inrapporterade kommentarer från Länsstyrelserna'; + + +-- +-- Name: COLUMN dammar."XX_Distance"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."XX_Distance" IS 'Distance to the closest SvK station or production dam'; + + +-- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -226,7 +424,7 @@ CREATE SEQUENCE postgis.dammar_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.dammar_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.dammar_ogc_fid_seq OWNER TO webmap_import; -- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -268,7 +466,7 @@ CREATE SEQUENCE postgis.gigafactories_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import; -- -- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -300,6 +498,27 @@ COMMENT ON TABLE postgis.kommunyta IS 'Sveriges kommuner (Lantmäteriet)'; -- +-- Name: COLUMN kommunyta.objektidentitet; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.kommunyta.objektidentitet IS 'Globalt unik identitet för generaliserat objekt'; + + +-- +-- Name: COLUMN kommunyta.skapad; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.kommunyta.skapad IS 'Tidpunkt när objektet ändrades'; + + +-- +-- Name: COLUMN kommunyta.kommunkod; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.kommunyta.kommunkod IS 'Fyrsiffrig kod för kommun'; + + +-- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -311,7 +530,7 @@ CREATE SEQUENCE postgis.kommunyta_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.kommunyta_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.kommunyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -345,7 +564,7 @@ CREATE SEQUENCE postgis.kommunyta_sub_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.kommunyta_sub_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.kommunyta_sub_ogc_fid_seq OWNER TO webmap_import; -- -- Name: kommunyta_sub_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -377,6 +596,27 @@ COMMENT ON TABLE postgis.lansyta IS 'Sveriges län (Lantmäteriet)'; -- +-- Name: COLUMN lansyta.objektidentitet; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.lansyta.objektidentitet IS 'Globalt unik identitet för generaliserat objekt'; + + +-- +-- Name: COLUMN lansyta.skapad; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.lansyta.skapad IS 'Tidpunkt när objektet ändrades'; + + +-- +-- Name: COLUMN lansyta.lanskod; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.lansyta.lanskod IS 'Tvåsiffrig kod för län'; + + +-- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -388,7 +628,7 @@ CREATE SEQUENCE postgis.lansyta_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -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 @@ -504,6 +744,13 @@ COMMENT ON TABLE postgis."lst:riksintresse_obruten_kust" IS 'Obruten kust (MB 4 -- +-- 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 @@ -601,6 +848,13 @@ COMMENT ON TABLE postgis."lst:riksintresse_rorligt_friluftsliv" IS 'Rörligt fri -- +-- 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 @@ -651,6 +905,13 @@ COMMENT ON TABLE postgis."lst:riksintresse_skyddade_vattendrag" IS 'Skyddade vat -- +-- 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 @@ -696,6 +957,41 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_ansokta" IS 'Bearbetnings -- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".name IS 'Namn på ansökt bearbetningskoncession'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".mineral IS 'Ansökta koncessionsmineraler'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".owners IS 'Sökanden av bearbetningskoncessionen'; + + +-- -- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -745,6 +1041,69 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_beviljade" IS 'Bearbetnin -- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".name IS 'Namn på beviljad bearbetningskoncession'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".licenceid IS 'Tillståndsid för bearbetningskoncessionen'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".dec_date IS 'Datum när bearbetningskoncessionen beviljades'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".validfrom IS 'Datum från och med när bearbetningskoncessionen började gälla'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".validto IS 'Sista dagen bearbetningskoncessionen gäller'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".mineral IS 'Koncessionsmineral'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".owners IS 'Innehavare av bearbetningskoncessionen'; + + +-- -- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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,6 +1150,48 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_forfallna" IS 'Bearbetnin -- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".name IS 'Namn på förfallen bearbetningskoncession'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".mineral IS 'Koncessionsmineral'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".owners IS 'Innehavare av bearbetningskoncessionen'; + + +-- -- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -835,6 +1236,34 @@ COMMENT ON TABLE postgis."mrr:markanvisningar_bk_ansokta" IS 'Markanvisningar ti -- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".name IS 'Namn på ansökt markanvisning'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".conc_name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".conc_name IS 'Bearbetningskoncession(er) som markanvisningen hör till'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- -- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -881,6 +1310,48 @@ COMMENT ON TABLE postgis."mrr:markanvisningar_bk_beviljade" IS 'Markanvisningar -- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".name IS 'Namn på beviljad markanvisning'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".licenceid IS 'Tillståndsid för markanvisningen'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".conc_name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".conc_name IS 'Bearbetningskoncession(er) som markanvisningen hör till'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".dec_date IS 'Datum när markanvisningen beviljades'; + + +-- -- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -926,6 +1397,41 @@ COMMENT ON TABLE postgis."mrr:ut_diamant_ansokta" IS 'Undersökningstillstånd - -- +-- Name: COLUMN "mrr:ut_diamant_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".name IS 'Namn på ansökt undersökningsområde'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".mineral IS 'Koncessionsmineral som ska eftersökas'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".owners IS 'Sökanden av undersökningstillståndet'; + + +-- -- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -975,6 +1481,69 @@ COMMENT ON TABLE postgis."mrr:ut_diamant_beviljade" IS 'Undersökningstillstånd -- +-- Name: COLUMN "mrr:ut_diamant_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".name IS 'Namn på beviljat undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".dec_date IS 'Datum när undersökningstillståndet beviljades'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".validto IS 'Sista dagen undersökningstillståndet gäller'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".mineral IS 'Koncessionsmineral som eftersöks'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".owners IS 'Innehavare av undersökningstillståndet'; + + +-- -- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -1024,6 +1593,69 @@ COMMENT ON TABLE postgis."mrr:ut_diamant_forbud" IS 'Undersökningstillstånd - -- +-- Name: COLUMN "mrr:ut_diamant_forbud".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".name IS 'Namn på undersökningstillstånd under förbudsår'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".validfrom IS 'Datum då undersökningstillståndets förbudsår startar'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".validto IS 'Datum då undersökningstillståndets förbudsår slutar'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -1069,6 +1701,41 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" IS 'Undersök -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".name IS 'Namn på ansökt undersökningsområde'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".mineral IS 'Koncessionsmineral som ska eftersökas'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".owners IS 'Sökanden av undersökningstillståndet'; + + +-- -- Name: mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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,6 +1785,69 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" IS 'Undersà -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".name IS 'Namn på beviljat undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".dec_date IS 'Datum när undersökningstillståndet beviljades'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".validto IS 'Sista dagen undersökningstillståndet gäller'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".mineral IS 'Koncessionsmineral som eftersöks'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".owners IS 'Innehavare av undersökningstillståndet'; + + +-- -- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1129,7 +1859,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1167,6 +1897,69 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forbud" IS 'Undersökn -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".name IS 'Namn på undersökningstillstånd under förbudsår'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".validfrom IS 'Datum då undersökningstillståndets förbudsår startar'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".validto IS 'Datum då undersökningstillståndets förbudsår slutar'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1178,7 +1971,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1216,6 +2009,69 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" IS 'Undersà -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".name IS 'Namn på förfallet undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".validto IS 'Sista dagen undersökningstillståndet gällde'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -1265,6 +2121,69 @@ COMMENT ON TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" IS 'Undersökningst -- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".name IS 'Namn på förfallet undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".validto IS 'Sista dagen undersökningstillståndet gällde'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -1365,6 +2284,20 @@ COMMENT ON TABLE postgis."nvk:riksintresse_friluftsliv" IS 'Riksintresse friluft -- +-- 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,6 +2406,104 @@ COMMENT ON TABLE postgis."nvk:skyddsvard_statlig_skog" IS 'Skyddsvärda statliga -- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."AR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."AR" IS 'År'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."NATURGEOGR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."NATURGEOGR" IS 'Naturgeografisk region'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."OBJEKTKATE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."OBJEKTKATE" IS 'Objektskategori'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."MARKAGARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."MARKAGARE" IS 'Markägare'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."VARDEKARNA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."VARDEKARNA" IS 'Areal värdekärna (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."UTV_MARK"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."UTV_MARK" IS 'Areal utvecklingsmark (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."TOTAL_AREA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."TOTAL_AREA" IS 'Totalareal (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."LAND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."LAND" IS 'Areal land (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."VATTEN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."VATTEN" IS 'Areal vatten (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."PROD_SKOG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."PROD_SKOG" IS 'Areal produktiv skogsmark (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."SKOG_O_FJG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."SKOG_O_FJG" IS 'Areal produktiv skogsmark ovanför fjällnära gräns (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."SKOG_N_FJG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."SKOG_N_FJG" IS 'Areal produktiv skogsmark nedanför fjällnära gräns (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."SKYDDSZON"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."SKYDDSZON" IS 'Areal skyddszon (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."ARRO_MARK"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."ARRO_MARK" IS 'Areal arronderingsmark (ha)'; + + +-- -- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1484,7 +2515,7 @@ CREATE SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNER TO webmap_import; +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 @@ -1516,6 +2547,13 @@ COMMENT ON TABLE postgis."nvr:Biosfarsomraden" IS 'Biosfärsområden (UNESCO)'; -- +-- Name: COLUMN "nvr:Biosfarsomraden"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biosfarsomraden"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- -- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1527,7 +2565,7 @@ CREATE SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1566,6 +2604,55 @@ COMMENT ON TABLE postgis."nvr:Biotopskydd" IS 'Biotopskydd i skogsmark (beslutad -- +-- Name: COLUMN "nvr:Biotopskydd"."Uuid"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Uuid" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."ArendeAr" IS 'År anmälan/ansökan registrerades'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Biotyp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Biotyp" IS 'Biotoptyp'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Standort"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Standort" IS 'Ståndortsindex'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Datbeslut"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Datbeslut" IS 'Datum för beslut'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; + + +-- -- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -1623,6 +2710,125 @@ COMMENT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" IS 'Djur- och växtskyd -- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; |