diff options
| author | Guilhem Moulin <guilhem@fripost.org> | 2025-08-12 19:53:09 +0200 |
|---|---|---|
| committer | Guilhem Moulin <guilhem@fripost.org> | 2025-08-12 20:06:09 +0200 |
| commit | 35b84d8af9a0d03434a05e25989fe0e8b7ad1901 (patch) | |
| tree | c9f5b301e5f2af923c5412d4ed52afd09ec787c7 | |
| parent | 412d9fb7280f382578698ce77831f1649e75c959 (diff) | |
Adjust SQL schema to PG 17 from Debian Trixie.
Recent GDAL version can set comments on columns, which is now reflected
on the schema.
| -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)'; + + +-- +-- 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,6 +2928,125 @@ COMMENT ON TABLE postgis."nvr:Interimistiskt_forbud" IS 'Interimistiska förbud' -- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Interimistiskt_forbud"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Interimistiskt_forbud"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1733,7 +3058,7 @@ CREATE SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1779,6 +3104,125 @@ COMMENT ON TABLE postgis."nvr:Kultureservat" IS 'Kulturreservat'; -- +-- Name: COLUMN "nvr:Kultureservat"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Kultureservat"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Kultureservat"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1790,7 +3234,7 @@ CREATE SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Kultureservat_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1836,6 +3280,125 @@ COMMENT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" IS 'Landskapsbildsskyd -- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Landskapsbildsskyddsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Landskapsbildsskyddsomrade"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1847,7 +3410,7 @@ CREATE SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1893,6 +3456,125 @@ COMMENT ON TABLE postgis."nvr:Nationalpark" IS 'Nationalparker'; -- +-- Name: COLUMN "nvr:Nationalpark"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Nationalpark"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Nationalpark"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1904,7 +3586,7 @@ CREATE SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Nationalpark_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1947,6 +3629,104 @@ COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt'; -- +-- Name: COLUMN "nvr:Naturminne_punkt"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Naturminne_punkt"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_punkt"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1958,7 +3738,7 @@ CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2004,6 +3784,125 @@ COMMENT ON TABLE postgis."nvr:Naturminne_yta" IS 'Naturminne, yta'; -- +-- Name: COLUMN "nvr:Naturminne_yta"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Naturminne_yta"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturminne_yta"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2015,7 +3914,7 @@ CREATE SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2061,6 +3960,125 @@ COMMENT ON TABLE postgis."nvr:Naturreservat" IS 'Naturreservat'; -- +-- Name: COLUMN "nvr:Naturreservat"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Naturreservat"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturreservat"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2072,7 +4090,7 @@ CREATE SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturreservat_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2118,6 +4136,125 @@ COMMENT ON TABLE postgis."nvr:Naturvardsomrade" IS 'Naturvårdsområden'; -- +-- Name: COLUMN "nvr:Naturvardsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Naturvardsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Naturvardsomrade"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2129,7 +4266,7 @@ CREATE SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2174,7 +4311,7 @@ CREATE SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:OSPAR_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2220,6 +4357,125 @@ COMMENT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" IS 'Biotopskydd utanfö -- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Ovrigt_biotopskyddsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ovrigt_biotopskyddsomrade"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -2271,6 +4527,34 @@ COMMENT ON TABLE postgis."nvr:Ramsar" IS 'Ramsar-områden (Våtmarkskonventionen -- +-- Name: COLUMN "nvr:Ramsar"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ramsar"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Ramsar"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ramsar"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Ramsar"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ramsar"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Ramsar"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Ramsar"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- -- Name: nvr:Ramsar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -2324,6 +4608,13 @@ COMMENT ON TABLE postgis."nvr:SCI_Rikstackande" IS 'Habitatdirektivet (SCI, dire -- +-- Name: COLUMN "nvr:SCI_Rikstackande"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:SCI_Rikstackande"."NAMN" IS 'Områdets namn'; + + +-- -- Name: nvr:SCI_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -2377,6 +4668,13 @@ COMMENT ON TABLE postgis."nvr:SPA_Rikstackande" IS 'Fågeldirektivet (SPA, direk -- +-- Name: COLUMN "nvr:SPA_Rikstackande"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:SPA_Rikstackande"."NAMN" IS 'Områdets namn'; + + +-- -- Name: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2388,7 +4686,7 @@ CREATE SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2426,6 +4724,20 @@ COMMENT ON TABLE postgis."nvr:Tilltradesforbud" IS 'Områden med föreskrifter s -- +-- Name: COLUMN "nvr:Tilltradesforbud"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Tilltradesforbud"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Tilltradesforbud"."BESLSTAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Tilltradesforbud"."BESLSTAT" IS 'Beslutsstatus'; + + +-- -- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2437,7 +4749,7 @@ CREATE SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2478,7 +4790,7 @@ CREATE SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Varldsarv_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2526,6 +4838,139 @@ COMMENT ON TABLE postgis."nvr:Vattenskyddsomrade" IS 'Vattenskyddsområden'; -- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."TILLSYNSMH"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."TILLSYNSMH" IS 'Tillsynsmyndighet'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."PROVNMHDIS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."PROVNMHDIS" IS 'Prövningsmyndighet för dispens'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."PROVNMHTIL"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."PROVNMHTIL" IS 'Prövningsmyndighet för tillstånd'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."SKOG_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."SKOG_HA" IS 'Skogsmarksareal i hektar'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."GEOSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."GEOSTATUS" IS 'Hur ytter gränsen för området har mätts in'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."DIARIENR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."DIARIENR" IS 'Diarienummer i beslutande myndighets diarium'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."LAGRUM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."LAGRUM" IS 'Lagrum som använts som grund för beslutet'; + + +-- +-- Name: COLUMN "nvr:Vattenskyddsomrade"."BESLMYND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Vattenskyddsomrade"."BESLMYND" IS 'Beslutsmyndighet'; + + +-- -- Name: nvr:Vattenskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -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 @@ -2769,6 +5214,41 @@ 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'; +</ |