diff options
| -rw-r--r-- | schema.sql | 3370 |
1 files changed, 3296 insertions, 74 deletions
@@ -2,12 +2,13 @@ -- PostgreSQL database dump -- --- Dumped from database version 15.13 (Debian 15.13-0+deb12u1) --- Dumped by pg_dump version 15.13 (Debian 15.13-0+deb12u1) +-- Dumped from database version 17.5 (Debian 17.5-1) +-- Dumped by pg_dump version 17.5 (Debian 17.5-1) SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; +SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); @@ -31,6 +32,7 @@ ALTER DATABASE webmap OWNER TO postgres; SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; +SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); @@ -215,6 +217,202 @@ COMMENT ON TABLE postgis.dammar IS 'Dammar'; -- +-- Name: COLUMN dammar."DammID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DammID" IS 'Dammenhetens identitet'; + + +-- +-- Name: COLUMN dammar."LST_OBJID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."LST_OBJID" IS 'Länsstyrelsens objektid'; + + +-- +-- Name: COLUMN dammar."Datum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Datum" IS 'Datum för registrering av dammenheten i SVAR'; + + +-- +-- Name: COLUMN dammar."DNamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DNamn" IS 'Dammenhetens namn'; + + +-- +-- Name: COLUMN dammar."ByggAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."ByggAr" IS 'År för första byggnation av dammenheten'; + + +-- +-- Name: COLUMN dammar."DammHojd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DammHojd" IS 'Dammdelens högsta höjd (m)'; + + +-- +-- Name: COLUMN dammar."KronLangd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."KronLangd" IS 'Krönlängd (m)'; + + +-- +-- Name: COLUMN dammar."Fiskvag"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Fiskvag" IS 'Förekomst och typ av fiskväg vid dammenheten'; + + +-- +-- Name: COLUMN dammar."FiskvagByggAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."FiskvagByggAr" IS 'Byggår fiskväg'; + + +-- +-- Name: COLUMN dammar."Fiskavledare"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Fiskavledare" IS 'Finns fiskavledare till fiskvägen'; + + +-- +-- Name: COLUMN dammar."Vandringshinder"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Vandringshinder" IS 'Om dammenheten utgör ett vandringshinder'; + + +-- +-- Name: COLUMN dammar."HARO"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."HARO" IS 'Huvudavrinningsområdesnummer'; + + +-- +-- Name: COLUMN dammar."Vattendistrikt"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Vattendistrikt" IS 'Huvudavrinningsområdesnummer'; + + +-- +-- Name: COLUMN dammar.inrapp_lst; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.inrapp_lst IS 'Den Länsstyrelse dammenheten är inrapporterad av'; + + +-- +-- Name: COLUMN dammar.eu_cd; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.eu_cd IS 'Vattenförekomstidentitet'; + + +-- +-- Name: COLUMN dammar.vf_typ; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.vf_typ IS 'Typ av vattenförekomst'; + + +-- +-- Name: COLUMN dammar.vy_eucd; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.vy_eucd IS 'Vattenförekomstidentitet för eventuell vattenyta kopplat till dammanläggning'; + + +-- +-- Name: COLUMN dammar.vy_vf_typ; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar.vy_vf_typ IS 'Typ av vattenförekomst för eventuell vattenyta kopplat till dammanläggning'; + + +-- +-- Name: COLUMN dammar."DammanlID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DammanlID" IS 'Identitet för eventuell dammanläggning dammenheten är kopplad till'; + + +-- +-- Name: COLUMN dammar."Namn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Namn" IS 'Dammanläggningens namn'; + + +-- +-- Name: COLUMN dammar."OmbyggAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."OmbyggAr" IS 'År för idrifttagande av anläggning i dess nuvarande skepnad'; + + +-- +-- Name: COLUMN dammar."DG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."DG" IS 'Högsta dämningsgräns (m) enligt tillstånd'; + + +-- +-- Name: COLUMN dammar."SG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."SG" IS 'Högsta dämningsgräns (m) enligt tillstånd'; + + +-- +-- Name: COLUMN dammar."HojdSys"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."HojdSys" IS 'Höjdsystem som DG och SG räknats i'; + + +-- +-- Name: COLUMN dammar."MY"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."MY" IS 'Magasinsyta (km²) vid angiven DG'; + + +-- +-- Name: COLUMN dammar."RV"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."RV" IS 'Reglerbar volym (milj. m³)'; + + +-- +-- Name: COLUMN dammar."Kommentar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."Kommentar" IS 'Inrapporterade kommentarer från Länsstyrelserna'; + + +-- +-- Name: COLUMN dammar."XX_Distance"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.dammar."XX_Distance" IS 'Distance to the closest SvK station or production dam'; + + +-- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -226,7 +424,7 @@ CREATE SEQUENCE postgis.dammar_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.dammar_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.dammar_ogc_fid_seq OWNER TO webmap_import; -- -- Name: dammar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -268,7 +466,7 @@ CREATE SEQUENCE postgis.gigafactories_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import; -- -- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -300,6 +498,27 @@ COMMENT ON TABLE postgis.kommunyta IS 'Sveriges kommuner (Lantmäteriet)'; -- +-- Name: COLUMN kommunyta.objektidentitet; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.kommunyta.objektidentitet IS 'Globalt unik identitet för generaliserat objekt'; + + +-- +-- Name: COLUMN kommunyta.skapad; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.kommunyta.skapad IS 'Tidpunkt när objektet ändrades'; + + +-- +-- Name: COLUMN kommunyta.kommunkod; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.kommunyta.kommunkod IS 'Fyrsiffrig kod för kommun'; + + +-- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -311,7 +530,7 @@ CREATE SEQUENCE postgis.kommunyta_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.kommunyta_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.kommunyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: kommunyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -345,7 +564,7 @@ CREATE SEQUENCE postgis.kommunyta_sub_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.kommunyta_sub_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.kommunyta_sub_ogc_fid_seq OWNER TO webmap_import; -- -- Name: kommunyta_sub_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -377,6 +596,27 @@ COMMENT ON TABLE postgis.lansyta IS 'Sveriges län (Lantmäteriet)'; -- +-- Name: COLUMN lansyta.objektidentitet; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.lansyta.objektidentitet IS 'Globalt unik identitet för generaliserat objekt'; + + +-- +-- Name: COLUMN lansyta.skapad; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.lansyta.skapad IS 'Tidpunkt när objektet ändrades'; + + +-- +-- Name: COLUMN lansyta.lanskod; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis.lansyta.lanskod IS 'Tvåsiffrig kod för län'; + + +-- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -388,7 +628,7 @@ CREATE SEQUENCE postgis.lansyta_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import; -- -- Name: lansyta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -422,7 +662,7 @@ CREATE SEQUENCE postgis.lansyta_sub_ogc_fid_seq CACHE 1; -ALTER TABLE postgis.lansyta_sub_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE postgis.lansyta_sub_ogc_fid_seq OWNER TO webmap_import; -- -- Name: lansyta_sub_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -465,7 +705,7 @@ CREATE SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:pagaende_naturreservatsbildning_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -504,6 +744,13 @@ COMMENT ON TABLE postgis."lst:riksintresse_obruten_kust" IS 'Obruten kust (MB 4 -- +-- Name: COLUMN "lst:riksintresse_obruten_kust"."ANM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."lst:riksintresse_obruten_kust"."ANM" IS 'Anmärkning'; + + +-- -- Name: lst:riksintresse_obruten_kust_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -515,7 +762,7 @@ CREATE SEQUENCE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:riksintresse_obruten_kust_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -563,7 +810,7 @@ CREATE SEQUENCE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:riksintresse_obrutet_fjall_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -601,6 +848,13 @@ COMMENT ON TABLE postgis."lst:riksintresse_rorligt_friluftsliv" IS 'Rörligt fri -- +-- Name: COLUMN "lst:riksintresse_rorligt_friluftsliv"."ANM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."lst:riksintresse_rorligt_friluftsliv"."ANM" IS 'Anmärkning'; + + +-- -- Name: lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -612,7 +866,7 @@ CREATE SEQUENCE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -651,6 +905,13 @@ COMMENT ON TABLE postgis."lst:riksintresse_skyddade_vattendrag" IS 'Skyddade vat -- +-- Name: COLUMN "lst:riksintresse_skyddade_vattendrag"."ANM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."lst:riksintresse_skyddade_vattendrag"."ANM" IS 'Anmärkning'; + + +-- -- Name: lst:riksintresse_skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -662,7 +923,7 @@ CREATE SEQUENCE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: lst:riksintresse_skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -696,6 +957,41 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_ansokta" IS 'Bearbetnings -- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".name IS 'Namn på ansökt bearbetningskoncession'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".mineral IS 'Ansökta koncessionsmineraler'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_ansokta".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_ansokta".owners IS 'Sökanden av bearbetningskoncessionen'; + + +-- -- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -707,7 +1003,7 @@ CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:bearbetningskoncessioner_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -745,6 +1041,69 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_beviljade" IS 'Bearbetnin -- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".name IS 'Namn på beviljad bearbetningskoncession'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".licenceid IS 'Tillståndsid för bearbetningskoncessionen'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".dec_date IS 'Datum när bearbetningskoncessionen beviljades'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".validfrom IS 'Datum från och med när bearbetningskoncessionen började gälla'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".validto IS 'Sista dagen bearbetningskoncessionen gäller'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".mineral IS 'Koncessionsmineral'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_beviljade".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_beviljade".owners IS 'Innehavare av bearbetningskoncessionen'; + + +-- -- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -756,7 +1115,7 @@ CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:bearbetningskoncessioner_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -791,6 +1150,48 @@ COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_forfallna" IS 'Bearbetnin -- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".name IS 'Namn på förfallen bearbetningskoncession'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".mineral IS 'Koncessionsmineral'; + + +-- +-- Name: COLUMN "mrr:bearbetningskoncessioner_forfallna".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:bearbetningskoncessioner_forfallna".owners IS 'Innehavare av bearbetningskoncessionen'; + + +-- -- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -802,7 +1203,7 @@ CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:bearbetningskoncessioner_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -835,6 +1236,34 @@ COMMENT ON TABLE postgis."mrr:markanvisningar_bk_ansokta" IS 'Markanvisningar ti -- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".name IS 'Namn på ansökt markanvisning'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".conc_name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".conc_name IS 'Bearbetningskoncession(er) som markanvisningen hör till'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- -- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -846,7 +1275,7 @@ CREATE SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:markanvisningar_bk_ansokta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:markanvisningar_bk_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -881,6 +1310,48 @@ COMMENT ON TABLE postgis."mrr:markanvisningar_bk_beviljade" IS 'Markanvisningar -- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".name IS 'Namn på beviljad markanvisning'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".licenceid IS 'Tillståndsid för markanvisningen'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".conc_name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".conc_name IS 'Bearbetningskoncession(er) som markanvisningen hör till'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:markanvisningar_bk_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:markanvisningar_bk_beviljade".dec_date IS 'Datum när markanvisningen beviljades'; + + +-- -- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -892,7 +1363,7 @@ CREATE SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:markanvisningar_bk_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:markanvisningar_bk_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -926,6 +1397,41 @@ COMMENT ON TABLE postgis."mrr:ut_diamant_ansokta" IS 'Undersökningstillstånd - -- +-- Name: COLUMN "mrr:ut_diamant_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".name IS 'Namn på ansökt undersökningsområde'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".mineral IS 'Koncessionsmineral som ska eftersökas'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_ansokta".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_ansokta".owners IS 'Sökanden av undersökningstillståndet'; + + +-- -- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -937,7 +1443,7 @@ CREATE SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_diamant_ansokta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_diamant_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -975,6 +1481,69 @@ COMMENT ON TABLE postgis."mrr:ut_diamant_beviljade" IS 'Undersökningstillstånd -- +-- Name: COLUMN "mrr:ut_diamant_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".name IS 'Namn på beviljat undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".dec_date IS 'Datum när undersökningstillståndet beviljades'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".validto IS 'Sista dagen undersökningstillståndet gäller'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".mineral IS 'Koncessionsmineral som eftersöks'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_beviljade".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_beviljade".owners IS 'Innehavare av undersökningstillståndet'; + + +-- -- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -986,7 +1555,7 @@ CREATE SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_diamant_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_diamant_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1024,6 +1593,69 @@ COMMENT ON TABLE postgis."mrr:ut_diamant_forbud" IS 'Undersökningstillstånd - -- +-- Name: COLUMN "mrr:ut_diamant_forbud".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".name IS 'Namn på undersökningstillstånd under förbudsår'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".validfrom IS 'Datum då undersökningstillståndets förbudsår startar'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".validto IS 'Datum då undersökningstillståndets förbudsår slutar'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_diamant_forbud".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_diamant_forbud".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1035,7 +1667,7 @@ CREATE SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_diamant_forbud_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_diamant_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1069,6 +1701,41 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_ansokta" IS 'Undersök -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".name IS 'Namn på ansökt undersökningsområde'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".mineral IS 'Koncessionsmineral som ska eftersökas'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_ansokta".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_ansokta".owners IS 'Sökanden av undersökningstillståndet'; + + +-- -- Name: mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1080,7 +1747,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_ansokta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1118,6 +1785,69 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_beviljade" IS 'Unders -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".name IS 'Namn på beviljat undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".appl_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".appl_date IS 'Datum när ansökan inkom till Bergsstaten'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".dec_date; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".dec_date IS 'Datum när undersökningstillståndet beviljades'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".validto IS 'Sista dagen undersökningstillståndet gäller'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".mineral IS 'Koncessionsmineral som eftersöks'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_beviljade".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_beviljade".owners IS 'Innehavare av undersökningstillståndet'; + + +-- -- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1129,7 +1859,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_beviljade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1167,6 +1897,69 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forbud" IS 'Undersökn -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".name IS 'Namn på undersökningstillstånd under förbudsår'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".validfrom IS 'Datum då undersökningstillståndets förbudsår startar'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".validto IS 'Datum då undersökningstillståndets förbudsår slutar'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forbud".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forbud".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1178,7 +1971,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1216,6 +2009,69 @@ COMMENT ON TABLE postgis."mrr:ut_metaller_industrimineral_forfallna" IS 'Unders -- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".name IS 'Namn på förfallet undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".validto IS 'Sista dagen undersökningstillståndet gällde'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_metaller_industrimineral_forfallna".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_metaller_industrimineral_forfallna".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1227,7 +2083,7 @@ CREATE SEQUENCE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_metaller_industrimineral_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1265,6 +2121,69 @@ COMMENT ON TABLE postgis."mrr:ut_olja_gas_diamant_forfallna" IS 'Undersökningst -- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".name; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".name IS 'Namn på förfallet undersökningstillstånd'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".licenceid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".licenceid IS 'Tillståndsid för undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".diarynr; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".diarynr IS 'Ärendenummer i diariet'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".validfrom; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".validfrom IS 'Datum från och med när undersökningstillståndet började gälla'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".validto; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".validto IS 'Sista dagen undersökningstillståndet gällde'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".mineral; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".mineral IS 'Koncessionsmineral som eftersökts'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".owners; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".owners IS 'Innehavare av undersökningstillståndet'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".prospdata_url; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".prospdata_url IS 'Länk till nedladdning av återrapporterad prospekteringsinformation'; + + +-- +-- Name: COLUMN "mrr:ut_olja_gas_diamant_forfallna".prospdata_filesize_mb; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."mrr:ut_olja_gas_diamant_forfallna".prospdata_filesize_mb IS 'Filstorlek i Mb för återrapporterad prospekteringsinformation'; + + +-- -- Name: mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1276,7 +2195,7 @@ CREATE SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: mrr:ut_olja_gas_diamant_forfallna_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1323,7 +2242,7 @@ CREATE SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvk:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1365,6 +2284,20 @@ COMMENT ON TABLE postgis."nvk:riksintresse_friluftsliv" IS 'Riksintresse friluft -- +-- Name: COLUMN "nvk:riksintresse_friluftsliv"."AREA_LAND_"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:riksintresse_friluftsliv"."AREA_LAND_" IS 'Areal land i hektar'; + + +-- +-- Name: COLUMN "nvk:riksintresse_friluftsliv"."AREA_VATTE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:riksintresse_friluftsliv"."AREA_VATTE" IS 'Areal vatten i hektar'; + + +-- -- Name: nvk:riksintresse_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1376,7 +2309,7 @@ CREATE SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvk:riksintresse_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1424,7 +2357,7 @@ CREATE SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvk:riksintresse_naturvard_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1473,6 +2406,104 @@ COMMENT ON TABLE postgis."nvk:skyddsvard_statlig_skog" IS 'Skyddsvärda statliga -- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."AR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."AR" IS 'År'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."NATURGEOGR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."NATURGEOGR" IS 'Naturgeografisk region'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."OBJEKTKATE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."OBJEKTKATE" IS 'Objektskategori'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."MARKAGARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."MARKAGARE" IS 'Markägare'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."VARDEKARNA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."VARDEKARNA" IS 'Areal värdekärna (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."UTV_MARK"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."UTV_MARK" IS 'Areal utvecklingsmark (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."TOTAL_AREA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."TOTAL_AREA" IS 'Totalareal (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."LAND"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."LAND" IS 'Areal land (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."VATTEN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."VATTEN" IS 'Areal vatten (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."PROD_SKOG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."PROD_SKOG" IS 'Areal produktiv skogsmark (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."SKOG_O_FJG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."SKOG_O_FJG" IS 'Areal produktiv skogsmark ovanför fjällnära gräns (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."SKOG_N_FJG"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."SKOG_N_FJG" IS 'Areal produktiv skogsmark nedanför fjällnära gräns (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."SKYDDSZON"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."SKYDDSZON" IS 'Areal skyddszon (ha)'; + + +-- +-- Name: COLUMN "nvk:skyddsvard_statlig_skog"."ARRO_MARK"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvk:skyddsvard_statlig_skog"."ARRO_MARK" IS 'Areal arronderingsmark (ha)'; + + +-- -- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1484,7 +2515,7 @@ CREATE SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1516,6 +2547,13 @@ COMMENT ON TABLE postgis."nvr:Biosfarsomraden" IS 'Biosfärsområden (UNESCO)'; -- +-- Name: COLUMN "nvr:Biosfarsomraden"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biosfarsomraden"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- -- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1527,7 +2565,7 @@ CREATE SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1566,6 +2604,55 @@ COMMENT ON TABLE postgis."nvr:Biotopskydd" IS 'Biotopskydd i skogsmark (beslutad -- +-- Name: COLUMN "nvr:Biotopskydd"."Uuid"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Uuid" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."ArendeAr" IS 'År anmälan/ansökan registrerades'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Biotyp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Biotyp" IS 'Biotoptyp'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Standort"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Standort" IS 'Ståndortsindex'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Datbeslut"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Datbeslut" IS 'Datum för beslut'; + + +-- +-- Name: COLUMN "nvr:Biotopskydd"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Biotopskydd"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; + + +-- -- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -1577,7 +2664,7 @@ CREATE SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -1623,6 +2710,125 @@ COMMENT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" IS 'Djur- och växtskyd -- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."NVRID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."NVRID" IS 'Områdets unika ID i naturvårdsregistret'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."NAMN"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."NAMN" IS 'Områdets namn'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."SKYDDSTYP"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."SKYDDSTYP" IS 'Skyddstyp'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."BESLSTATUS"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."BESLSTATUS" IS 'Beslutsstatus'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."URSBESLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."URSBESLDAT" IS 'Ursprungligt beslutsdatum'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."IKRAFTDATF"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."IKRAFTDATF" IS 'Ikraftträdandedatum för föreskrifte'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."URSGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."URSGALLDAT" IS 'Ursprungligt gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."SENGALLDAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."SENGALLDAT" IS 'Senaste gällandedatum'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."IUCNKAT"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."IUCNKAT" IS 'Klassificering av skyddade områden enligt internationella naturvårdsunionens'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."FORVALTARE"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."FORVALTARE" IS 'Förvaltare för området'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."LAND_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."LAND_HA" IS 'Areal land i hektar (våtmarker ingår i landarealen)'; + + +-- +-- Name: COLUMN "nvr:Djur_och_vaxtskyddsomrade"."VATTEN_HA"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."nvr:Djur_och_vaxtskyddsomrade"."VATTEN_HA" IS 'Areal vatten i hektar (både sötvatten och marint vatten ingår)'; + + +-- +-- 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'; + + +-- +-- Name: COLUMN "sks:atervatningsavtal"."AvtalatDatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:atervatningsavtal"."AvtalatDatum" IS 'Avtalat datum'; + + +-- +-- Name: COLUMN "sks:atervatningsavtal"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:atervatningsavtal"."Url" IS 'Länk till Skogens pärlors formulär för objektet'; + + +-- -- Name: sks:atervatningsavtal_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2780,7 +5260,7 @@ CREATE SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:atervatningsavtal_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:atervatningsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2820,6 +5300,83 @@ COMMENT ON TABLE postgis."sks:avverk_anmald" IS 'Avverkningsanmälningar (Skogss -- +-- Name: COLUMN "sks:avverk_anmald"."OBJECTID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."OBJECTID" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."ArendeAr" IS 'År anmälan/ansökan registrerades'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."Inkomdatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."Inkomdatum" IS 'Anmälan/ansökan inkom datum'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."AnmaldHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."AnmaldHa" IS 'Areal anmält (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."SkogsodlHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."SkogsodlHa" IS 'Areal plantering (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."NatforHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."NatforHa" IS 'Areal naturlig föryngring (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."AvvSasong"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."AvvSasong" IS 'Avverkningssäsong'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."ArendeStatus"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."ArendeStatus" IS 'Ärendestatus'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."AvvHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."AvvHa" IS 'Avverkad areal (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_anmald"."AvverkningsanmalanKlass"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_anmald"."AvverkningsanmalanKlass" IS 'Avverkningsamalan/NyAvverkningsanmalan'; + + +-- -- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2831,7 +5388,7 @@ CREATE SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:avverk_anmald_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:avverk_anmald_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:avverk_anmald_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2872,6 +5429,90 @@ COMMENT ON TABLE postgis."sks:avverk_utford" IS 'Utförd avverkning (Skogsstyrel -- +-- Name: COLUMN "sks:avverk_utford"."OBJECTID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."OBJECTID" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."ArendeAr" IS 'År anmälan/ansökan registrerades'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Avverktyp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Avverktyp" IS 'Vad anmälan/ansökan gäller'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Skogstyp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Skogstyp" IS 'Anger om avverkning är inom fjällnära skog, ädellövskog eller normal skog'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."AnmaldHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."AnmaldHa" IS 'Areal anmält (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."NatforHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."NatforHa" IS 'Areal naturlig föryngring (ha)'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Avvdatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Avvdatum" IS 'Datum för avverkning'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."KallaDatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."KallaDatum" IS 'Ursprung för datum för avverkning (vid ”Uppgift saknas” är det vanligen Skogsstyrelsens personal som registrerat datumet)'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Forebild"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Forebild" IS 'Namnet på den gamla bilden i skillnadsanalysen'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."Efterbild"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."Efterbild" IS 'Namnet på den nya bilden i skillnadsanalysen'; + + +-- +-- Name: COLUMN "sks:avverk_utford"."ArealHa"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:avverk_utford"."ArealHa" IS 'Areal för ytan (ha)'; + + +-- -- Name: sks:avverk_utford_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2883,7 +5524,7 @@ CREATE SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:avverk_utford_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:avverk_utford_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:avverk_utford_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2923,6 +5564,41 @@ COMMENT ON TABLE postgis."sks:naturvarde" IS 'Objekt med naturvärden - Skogssty -- +-- Name: COLUMN "sks:naturvarde"."ObjectId"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."ObjectId" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:naturvarde"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:naturvarde"."Objnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."Objnamn" IS 'Namn på objektet'; + + +-- +-- Name: COLUMN "sks:naturvarde"."Datinv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."Datinv" IS 'Datum för fältinventering'; + + +-- +-- Name: COLUMN "sks:naturvarde"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvarde"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; + + +-- -- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2934,7 +5610,7 @@ CREATE SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:naturvarde_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:naturvarde_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:naturvarde_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -2974,6 +5650,41 @@ COMMENT ON TABLE postgis."sks:naturvardsavtal" IS 'Naturvårdsavtal (Skogsstyrel -- +-- Name: COLUMN "sks:naturvardsavtal"."Uuid"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."Uuid" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:naturvardsavtal"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:naturvardsavtal"."ArendeAr"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."ArendeAr" IS 'År anmälan/ansökan registrerades'; + + +-- +-- Name: COLUMN "sks:naturvardsavtal"."Standort"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."Standort" IS 'Ståndortsindex'; + + +-- +-- Name: COLUMN "sks:naturvardsavtal"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:naturvardsavtal"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; + + +-- -- Name: sks:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -2985,7 +5696,7 @@ CREATE SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:naturvardsavtal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3029,6 +5740,34 @@ COMMENT ON TABLE postgis."sks:nyckelbiotop" IS 'Nyckelbiotoper - Skogsstyrelsen' -- +-- Name: COLUMN "sks:nyckelbiotop"."Beteckn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop"."Beteckn" IS 'Ärendebeteckning'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop"."Objnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop"."Objnamn" IS 'Namn på objektet'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop"."Datinv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop"."Datinv" IS 'Datum för fältinventering'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop"."Url" IS 'Länk till visningsformulär i Skogens Pärlor'; + + +-- -- Name: sks:nyckelbiotop_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -3040,7 +5779,7 @@ CREATE SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:nyckelbiotop_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:nyckelbiotop_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3073,6 +5812,34 @@ COMMENT ON TABLE postgis."sks:nyckelbiotop_storskogsbruk" IS 'Nyckelbiotoper - s -- +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk".objectid; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop_storskogsbruk".objectid IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk"."Org"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop_storskogsbruk"."Org" IS 'Namn på Organisation som gjort inventeringen'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk"."InkomDatum"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop_storskogsbruk"."InkomDatum" IS 'Datum då data inkommit till Skogsstyrelsen'; + + +-- +-- Name: COLUMN "sks:nyckelbiotop_storskogsbruk"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:nyckelbiotop_storskogsbruk"."Url" IS 'Länk till Skogens Pärlors visningsformulär'; + + +-- -- Name: sks:nyckelbiotop_storskogsbruk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -3084,7 +5851,7 @@ CREATE SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:nyckelbiotop_storskogsbruk_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:nyckelbiotop_storskogsbruk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3133,6 +5900,146 @@ COMMENT ON TABLE postgis."sks:sumpskog" IS 'Sumpskogar'; -- +-- Name: COLUMN "sks:sumpskog"."OBJECTID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."OBJECTID" IS 'Unik identitet'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Namn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Namn" IS 'Objektnamn'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Hydrtext"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Hydrtext" IS 'Hydrologisk text, ex. kärrskog, mosseskog'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Tradtext"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Tradtext" IS 'Trädslag'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Delklass"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Delklass" IS 'Klass på delobjektet'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Klassu"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Klassu" IS 'Klass på objektet'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Lovandel"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Lovandel" IS 'Lövandel'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Krontakn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Krontakn" IS 'Krontäckning'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Huggklas"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Huggklas" IS 'Huggningsklass'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Andelva"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Andelva" IS 'Andel öppet vatten'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Ingrepp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Ingrepp" IS 'Ingrepp på delobjekt (max 4)'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Ingrpavv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Ingrpavv" IS 'Grad av påverkan på delobjekt (max 4)'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Objnyck"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Objnyck" IS 'Nyckelord på objektnivå'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Delnyck"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Delnyck" IS 'Nyckelord på delobjektsnivå'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Flygar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Flygar" IS 'Flygbildsår'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Faltdat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Faltdat" IS 'Faltdat'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Invtekn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Invtekn" IS 'Inventeringsteknik'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Invdat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Invdat" IS 'Inventeringdatum'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Ansvmynd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Ansvmynd" IS 'Ansvarig myndighet'; + + +-- +-- Name: COLUMN "sks:sumpskog"."Url"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."sks:sumpskog"."Url" IS 'Länk till Skogens pärlors formulär för objektet'; + + +-- -- Name: sks:sumpskog_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -3144,7 +6051,7 @@ CREATE SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:sumpskog_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."sks:sumpskog_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: sks:sumpskog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3186,7 +6093,7 @@ CREATE SEQUENCE postgis."svk:ledningar_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."svk:ledningar_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."svk:ledningar_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3226,7 +6133,7 @@ CREATE SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."svk:stationsomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3266,7 +6173,7 @@ CREATE SEQUENCE postgis."svk:stolpar_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."svk:stolpar_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."svk:stolpar_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3309,7 +6216,7 @@ CREATE SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3371,6 +6278,90 @@ COMMENT ON TABLE postgis."vbk:havsbaserad_vindkraft" IS 'Vindbrukskollen havsbas -- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."OmrID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."OmrID" IS 'ID-nummer i Vindbruksollen för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Projektnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Projektnamn" IS 'Namn på projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Organisationsnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Organisationsnamn" IS 'Namnet på verksamhetsutövaren för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Organisationsnummer"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Organisationsnummer" IS 'Verksamhetsutövarens organisationsnummer'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."AndringsansokanPagar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."AndringsansokanPagar" IS 'Om ändringsansökan pågår'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."UnderByggnation"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."UnderByggnation" IS 'Om projekteringsområdet är under byggnation'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Uppfort"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Uppfort" IS 'Uppförandedatum för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."PlaneradByggstart"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."PlaneradByggstart" IS 'Datumangivelse för planerad byggstart för projektet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."PlaneratDrift"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."PlaneratDrift" IS 'Datumangivelse för planerat idrifttagande för projektet'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."Calprod"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."Calprod" IS 'Den beräknade årsproduktionern (GWh) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."ElNamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."ElNamn" IS 'Elområde dit vindkraftverket tillhör'; + + +-- +-- Name: COLUMN "vbk:havsbaserad_vindkraft"."SenasteUppdaterat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:havsbaserad_vindkraft"."SenasteUppdaterat" IS 'Datum då vindkraftverket senast sparats i Vindbrukskollen'; + + +-- -- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -3382,7 +6373,7 @@ CREATE SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3426,6 +6417,104 @@ COMMENT ON TABLE postgis."vbk:projekteringsomraden" IS 'Vindbrukskollen landbase -- +-- Name: COLUMN "vbk:projekteringsomraden"."OmrID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."OmrID" IS 'ID-nummer i Vindbruksollen för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."Projektnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."Projektnamn" IS 'Namn på projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."AntalVerk"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."AntalVerk" IS 'Antal vindkraftverk exklusive status "Ej aktuell/återkallat"'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."AntalEjXY"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."AntalEjXY" IS 'Antal vindkraftverk utan koordinater som tillhör projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."Calprod"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."Calprod" IS 'Summan av verkens uppgivna beräknade årsproduktion (GWh)'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."PlaneradByggstart"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."PlaneradByggstart" IS 'Datumangivelse för planerad byggstart för projektet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."PlaneratDrift"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."PlaneratDrift" IS 'Datumangivelse för planerat idrifttagande för projektet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."AndringsansokanPagar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."AndringsansokanPagar" IS 'Om ändringsansökan pågår'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."UnderByggnation"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."UnderByggnation" IS 'Om projekteringsområdet är under byggnation'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."Organisationsnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."Organisationsnamn" IS 'Namnet på verksamhetsutövaren för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."Organisationsnummer"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."Organisationsnummer" IS 'Verksamhetsutövarens organisationsnummer'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."ElNamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."ElNamn" IS 'Elområde dit projekteringsområdet tillhör'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."SenasteUppdaterat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."SenasteUppdaterat" IS 'Datum då projektet senast sparats i Vindbrukskollen (om datum saknas har området inte sparats efter nov 2018)'; + + +-- +-- Name: COLUMN "vbk:projekteringsomraden"."EjAktuell"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:projekteringsomraden"."EjAktuell" IS 'Om samtliga verk inom projekteringsområdet har status ej aktuellt / återkallat / avslag med laga kraft'; + + +-- -- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -3437,7 +6526,7 @@ CREATE SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3488,6 +6577,139 @@ COMMENT ON TABLE postgis."vbk:vindkraftverk" IS 'Vindbrukskollen landbaserade vi -- +-- Name: COLUMN "vbk:vindkraftverk"."VerkID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."VerkID" IS 'ID-nummer i Vindbrukskollen för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."OmrID"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."OmrID" IS 'ID-nummer i Vindbruksollen för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Projektnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Projektnamn" IS 'Namn på projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Status"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Status" IS 'Status för vindkraftverket (t.ex beviljat)'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Handlingstyp"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Handlingstyp" IS 'Aktuell prövningsgrund enligt Miljöbalken eller Plan och Bygglagen'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Uppfort"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Uppfort" IS 'Uppförandedatum för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."MB_Tillstand"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."MB_Tillstand" IS 'Datum för tidsbegränsning av miljötillståndet'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Totalhojd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Totalhojd" IS 'Totalhöjd (m) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Navhojd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Navhojd" IS 'Navhöjd (m) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Rotordiameter"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Rotordiameter" IS 'Rotordiameter (m) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Maxeffekt"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Maxeffekt" IS 'Ansökt eller installerad maxeffekt (MW) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Calprod"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Calprod" IS 'Den beräknade årsproduktionern (GWh) för vindkraftverket'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Fabrikat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Fabrikat" IS 'Namn på vindkraftverkets fabrikat'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Modell"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Modell" IS 'Namn på vindkraftverkets modell'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Organisationsnamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Organisationsnamn" IS 'Namnet på verksamhetsutövaren för projekteringsområdet'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Organisationsnummer"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Organisationsnummer" IS 'Verksamhetsutövarens organisationsnummer'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."Placering"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."Placering" IS 'Anger om verket är placerat på land eller i vatten'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."ElNamn"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."ElNamn" IS 'Elområde dit vindkraftverket tillhör'; + + +-- +-- Name: COLUMN "vbk:vindkraftverk"."SenasteUppdaterat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON COLUMN postgis."vbk:vindkraftverk"."SenasteUppdaterat" IS 'Datum då vindkraftverket senast sparats i Vindbrukskollen (om datum saknas har vindkraftverket inte sparats efter nov 2018)'; + + +-- -- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- @@ -3499,7 +6721,7 @@ CREATE SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNER TO webmap_import; +ALTER SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNER TO webmap_import; -- -- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import @@ -3541,7 +6763,7 @@ CREATE SEQUENCE public.layercache_ogc_fid_seq CACHE 1; -ALTER TABLE public.layercache_ogc_fid_seq OWNER TO webmap_import; +ALTER SEQUENCE public.layercache_ogc_fid_seq OWNER TO webmap_import; -- -- Name: layercache_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: webmap_import @@ -5503,10 +8725,10 @@ CREATE INDEX "sametinget:flyttled_wkb_geometry_geom_idx" ON postgis."sametinget: -- --- Name: sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_geo; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_geo" ON postgis."sametinget:riksintresse_rennaringen_karnomrade" USING gist (wkb_geometry); +CREATE INDEX "sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_idx" ON postgis."sametinget:riksintresse_rennaringen_karnomrade" USING gist (wkb_geometry); -- |