From 5eb1fa424af776a8510ea6143b077d9727789d5b Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Sat, 7 Jun 2025 18:04:43 +0200 Subject: =?UTF-8?q?Rename=20=E2=80=9Cri:*=E2=80=9D=20tables=20to=20?= =?UTF-8?q?=E2=80=9Cnvk:riksintresse=5F*=E2=80=9D=20and=20=E2=80=9Clst:rik?= =?UTF-8?q?sintresse=5F*=E2=80=9D.?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- config.yml | 16 +- schema.sql | 1110 ++++++++++++++++++++++++++++++------------------------------ 2 files changed, 564 insertions(+), 562 deletions(-) diff --git a/config.yml b/config.yml index cbb0f15..8273d54 100644 --- a/config.yml +++ b/config.yml @@ -67,7 +67,9 @@ layer-groups: - 'ren:*' vbk: 'vbk:*' mrr: 'mrr:*' - ri: 'ri:*' + ri: + - 'nvk:riksintresse_*' + - 'lst:riksintresse_*' svk: 'svk:*' misc: - dammar @@ -4348,7 +4350,7 @@ layers: - replace: '-' with: null - 'ri:naturvard': + 'nvk:riksintresse_naturvard': description: Riksintresse naturvård create: geometry-type: MULTIPOLYGON @@ -4399,7 +4401,7 @@ layers: layername: RIKSINTRESSE_NATURVARD publish: naturvard - 'ri:friluftsliv': + 'nvk:riksintresse_friluftsliv': description: Riksintresse friluftsliv create: geometry-type: MULTIPOLYGON @@ -4465,7 +4467,7 @@ layers: layername: RIKSINTRESSE_FRILUFTSLIV publish: friluftsliv - 'ri:rorligt_friluftsliv': + 'lst:riksintresse_rorligt_friluftsliv': description: Rörligt friluftsliv (MB 4 kap 1 och 2 §§) create: geometry-type: MULTIPOLYGON @@ -4508,7 +4510,7 @@ layers: layername: lst.LST_RI_Rorligt_friluftsliv_MB4kap2 publish: rorligt_friluftsliv - 'ri:obruten_kust': + 'lst:riksintresse_obruten_kust': description: Obruten kust (MB 4 kap 3 §) create: geometry-type: MULTIPOLYGON @@ -4554,7 +4556,7 @@ layers: layername: lst.LST_RI_Obruten_kust_MB4kap3 publish: obruten_kust - 'ri:obrutet_fjall': + 'lst:riksintresse_obrutet_fjall': description: Obrutet fjäll (MB 4 kap 5 §) create: geometry-type: MULTIPOLYGON @@ -4595,7 +4597,7 @@ layers: layername: lst.Lst_RI_Obrutet_fjall_MB4kap5 publish: obrutet_fjall - 'ri:skyddade_vattendrag': + 'lst:riksintresse_skyddade_vattendrag': description: Skyddade vattendrag (MB 4 kap 6 §) create: geometry-type: MULTIPOLYGON diff --git a/schema.sql b/schema.sql index 492b4ab..052f6b4 100644 --- a/schema.sql +++ b/schema.sql @@ -431,6 +431,203 @@ ALTER TABLE postgis.lansyta_sub_ogc_fid_seq OWNER TO webmap_import; ALTER SEQUENCE postgis.lansyta_sub_ogc_fid_seq OWNED BY postgis.lansyta_sub.ogc_fid; +-- +-- Name: lst:riksintresse_obruten_kust; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."lst:riksintresse_obruten_kust" ( + ogc_fid bigint NOT NULL, + "ORIGINALID" character varying(16), + "NAMN" character varying(64), + "BESKRIVNIN" character varying(254), + "METODBESKR" character varying(254), + "TILLKDATUM" date, + "REVDATUM" date, + "ANM" character varying(254), + "OBJTYP" character varying(254), + "OBJEKTLANK" character varying(254), + "REFERENS" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."lst:riksintresse_obruten_kust" OWNER TO webmap_import; + +-- +-- Name: TABLE "lst:riksintresse_obruten_kust"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."lst:riksintresse_obruten_kust" IS 'Obruten kust (MB 4 kap 3 §)'; + + +-- +-- Name: lst:riksintresse_obruten_kust_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: lst:riksintresse_obruten_kust_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" OWNED BY postgis."lst:riksintresse_obruten_kust".ogc_fid; + + +-- +-- Name: lst:riksintresse_obrutet_fjall; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."lst:riksintresse_obrutet_fjall" ( + ogc_fid bigint NOT NULL, + "ORIGINALID" character varying(16), + "NAMN" character varying(64) NOT NULL, + "BESKRIVNIN" character varying(254), + "METODBESKR" character varying(254), + "TILLKDATUM" date, + "REVDATUM" date, + "OBJEKTLANK" character varying(254), + "REFERENS" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."lst:riksintresse_obrutet_fjall" OWNER TO webmap_import; + +-- +-- Name: TABLE "lst:riksintresse_obrutet_fjall"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."lst:riksintresse_obrutet_fjall" IS 'Obrutet fjäll (MB 4 kap 5 §)'; + + +-- +-- Name: lst:riksintresse_obrutet_fjall_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: lst:riksintresse_obrutet_fjall_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" OWNED BY postgis."lst:riksintresse_obrutet_fjall".ogc_fid; + + +-- +-- Name: lst:riksintresse_rorligt_friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."lst:riksintresse_rorligt_friluftsliv" ( + ogc_fid bigint NOT NULL, + "ORIGINALID" character varying(16), + "NAMN" character varying(64), + "BESKRIVNIN" character varying(254), + "METODBESKR" character varying(254), + "TILLKDATUM" date, + "REVDATUM" date, + "ANM" character varying(254), + "OBJEKTLANK" character varying(254), + "REFERENS" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."lst:riksintresse_rorligt_friluftsliv" OWNER TO webmap_import; + +-- +-- Name: TABLE "lst:riksintresse_rorligt_friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."lst:riksintresse_rorligt_friluftsliv" IS 'Rörligt friluftsliv (MB 4 kap 1 och 2 §§)'; + + +-- +-- Name: lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" OWNED BY postgis."lst:riksintresse_rorligt_friluftsliv".ogc_fid; + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."lst:riksintresse_skyddade_vattendrag" ( + ogc_fid bigint NOT NULL, + "ORIGINALID" character varying(16), + "NAMN" character varying(64) NOT NULL, + "BESKRIVNIN" character varying(254), + "METODBESKR" character varying(254), + "TILLKDATUM" date, + "REVDATUM" date, + "ANM" character varying(254), + "DIG_SKALA" integer, + "OBJEKTLANK" character varying(254), + "REFERENS" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."lst:riksintresse_skyddade_vattendrag" OWNER TO webmap_import; + +-- +-- Name: TABLE "lst:riksintresse_skyddade_vattendrag"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."lst:riksintresse_skyddade_vattendrag" IS 'Skyddade vattendrag (MB 4 kap 6 §)'; + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: lst:riksintresse_skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" OWNED BY postgis."lst:riksintresse_skyddade_vattendrag".ogc_fid; + + -- -- Name: mrr:bearbetningskoncessioner_ansokta; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -1092,6 +1289,107 @@ ALTER TABLE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNER TO webmap_import; ALTER SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNED BY postgis."nvk:naturvardsavtal".ogc_fid; +-- +-- Name: nvk:riksintresse_friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvk:riksintresse_friluftsliv" ( + ogc_fid bigint NOT NULL, + "SKYDD" character varying(64) NOT NULL, + "OMRADESNR" character varying(16) NOT NULL, + "AMNESOMR" character varying(16) NOT NULL, + "NAMN" character varying(127) NOT NULL, + "LANK_VARDE" character varying(127) NOT NULL, + "BESLDATUM" date, + "LAGRUM" character varying(64) NOT NULL, + "ARENDENR" character varying(11) NOT NULL, + "LANK_BESLU" character varying(127) NOT NULL, + "AKTIVITET" character varying(127), + "NATURTYP" character varying(127), + "AREA_LAND_" double precision, + "AREA_VATTE" double precision, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvk:riksintresse_friluftsliv" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvk:riksintresse_friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvk:riksintresse_friluftsliv" IS 'Riksintresse friluftsliv'; + + +-- +-- Name: nvk:riksintresse_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvk:riksintresse_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" OWNED BY postgis."nvk:riksintresse_friluftsliv".ogc_fid; + + +-- +-- Name: nvk:riksintresse_naturvard; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvk:riksintresse_naturvard" ( + ogc_fid bigint NOT NULL, + "SKYDD" character varying(64) NOT NULL, + "AMNESOMRAD" character varying(64) NOT NULL, + "NAMN" character varying(127) NOT NULL, + "BESKRIVNIN" character varying(254) NOT NULL, + "LAGRUM" character varying(64) NOT NULL, + "BESLUTSDAT" date NOT NULL, + "ORGINALID" character varying(16) NOT NULL, + "RIKSID" integer NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvk:riksintresse_naturvard" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvk:riksintresse_naturvard"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvk:riksintresse_naturvard" IS 'Riksintresse naturvård'; + + +-- +-- Name: nvk:riksintresse_naturvard_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvk:riksintresse_naturvard_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNED BY postgis."nvk:riksintresse_naturvard".ogc_fid; + + -- -- Name: nvr:Biosfarsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -2240,308 +2538,10 @@ ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren -- --- Name: ri:friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ri:friluftsliv" ( - ogc_fid bigint NOT NULL, - "SKYDD" character varying(64) NOT NULL, - "OMRADESNR" character varying(16) NOT NULL, - "AMNESOMR" character varying(16) NOT NULL, - "NAMN" character varying(127) NOT NULL, - "LANK_VARDE" character varying(127) NOT NULL, - "BESLDATUM" date, - "LAGRUM" character varying(64) NOT NULL, - "ARENDENR" character varying(11) NOT NULL, - "LANK_BESLU" character varying(127) NOT NULL, - "AKTIVITET" character varying(127), - "NATURTYP" character varying(127), - "AREA_LAND_" double precision, - "AREA_VATTE" double precision, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - - -ALTER TABLE postgis."ri:friluftsliv" OWNER TO webmap_import; - --- --- Name: TABLE "ri:friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import --- - -COMMENT ON TABLE postgis."ri:friluftsliv" IS 'Riksintresse friluftsliv'; - - --- --- Name: ri:friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import --- - -CREATE SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE postgis."ri:friluftsliv_ogc_fid_seq" OWNER TO webmap_import; - --- --- Name: ri:friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import --- - -ALTER SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" OWNED BY postgis."ri:friluftsliv".ogc_fid; - - --- --- Name: ri:naturvard; Type: TABLE; Schema: postgis; Owner: webmap_import --- - -CREATE TABLE postgis."ri:naturvard" ( - ogc_fid bigint NOT NULL, - "SKYDD" character varying(64) NOT NULL, - "AMNESOMRAD" character varying(64) NOT NULL, - "NAMN" character varying(127) NOT NULL, - "BESKRIVNIN" character varying(254) NOT NULL, - "LAGRUM" character varying(64) NOT NULL, - "BESLUTSDAT" date NOT NULL, - "ORGINALID" character varying(16) NOT NULL, - "RIKSID" integer NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - - -ALTER TABLE postgis."ri:naturvard" OWNER TO webmap_import; - --- --- Name: TABLE "ri:naturvard"; Type: COMMENT; Schema: postgis; Owner: webmap_import --- - -COMMENT ON TABLE postgis."ri:naturvard" IS 'Riksintresse naturvård'; - - --- --- Name: ri:naturvard_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import --- - -CREATE SEQUENCE postgis."ri:naturvard_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE postgis."ri:naturvard_ogc_fid_seq" OWNER TO webmap_import; - --- --- Name: ri:naturvard_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import --- - -ALTER SEQUENCE postgis."ri:naturvard_ogc_fid_seq" OWNED BY postgis."ri:naturvard".ogc_fid; - - --- --- Name: ri:obruten_kust; Type: TABLE; Schema: postgis; Owner: webmap_import --- - -CREATE TABLE postgis."ri:obruten_kust" ( - ogc_fid bigint NOT NULL, - "ORIGINALID" character varying(16), - "NAMN" character varying(64), - "BESKRIVNIN" character varying(254), - "METODBESKR" character varying(254), - "TILLKDATUM" date, - "REVDATUM" date, - "ANM" character varying(254), - "OBJTYP" character varying(254), - "OBJEKTLANK" character varying(254), - "REFERENS" character varying(254), - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - - -ALTER TABLE postgis."ri:obruten_kust" OWNER TO webmap_import; - --- --- Name: TABLE "ri:obruten_kust"; Type: COMMENT; Schema: postgis; Owner: webmap_import --- - -COMMENT ON TABLE postgis."ri:obruten_kust" IS 'Obruten kust (MB 4 kap 3§)'; - - --- --- Name: ri:obruten_kust_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import --- - -CREATE SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE postgis."ri:obruten_kust_ogc_fid_seq" OWNER TO webmap_import; - --- --- Name: ri:obruten_kust_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import --- - -ALTER SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" OWNED BY postgis."ri:obruten_kust".ogc_fid; - - --- --- Name: ri:obrutet_fjall; Type: TABLE; Schema: postgis; Owner: webmap_import --- - -CREATE TABLE postgis."ri:obrutet_fjall" ( - ogc_fid bigint NOT NULL, - "ORIGINALID" character varying(16), - "NAMN" character varying(64) NOT NULL, - "BESKRIVNIN" character varying(254), - "METODBESKR" character varying(254), - "TILLKDATUM" date, - "REVDATUM" date, - "OBJEKTLANK" character varying(254), - "REFERENS" character varying(254), - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - - -ALTER TABLE postgis."ri:obrutet_fjall" OWNER TO webmap_import; - --- --- Name: TABLE "ri:obrutet_fjall"; Type: COMMENT; Schema: postgis; Owner: webmap_import --- - -COMMENT ON TABLE postgis."ri:obrutet_fjall" IS 'Obrutet fjäll (MB 4 kap 5§)'; - - --- --- Name: ri:obrutet_fjall_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import --- - -CREATE SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE postgis."ri:obrutet_fjall_ogc_fid_seq" OWNER TO webmap_import; - --- --- Name: ri:obrutet_fjall_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import --- - -ALTER SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" OWNED BY postgis."ri:obrutet_fjall".ogc_fid; - - --- --- Name: ri:rorligt_friluftsliv; Type: TABLE; Schema: postgis; Owner: webmap_import --- - -CREATE TABLE postgis."ri:rorligt_friluftsliv" ( - ogc_fid bigint NOT NULL, - "ORIGINALID" character varying(16), - "NAMN" character varying(64), - "BESKRIVNIN" character varying(254), - "METODBESKR" character varying(254), - "TILLKDATUM" date, - "REVDATUM" date, - "ANM" character varying(254), - "OBJEKTLANK" character varying(254), - "REFERENS" character varying(254), - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - - -ALTER TABLE postgis."ri:rorligt_friluftsliv" OWNER TO webmap_import; - --- --- Name: TABLE "ri:rorligt_friluftsliv"; Type: COMMENT; Schema: postgis; Owner: webmap_import --- - -COMMENT ON TABLE postgis."ri:rorligt_friluftsliv" IS 'Rörligt friluftsliv (MB 4 kap 1§ och 2§)'; - - --- --- Name: ri:rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import --- - -CREATE SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" OWNER TO webmap_import; - --- --- Name: ri:rorligt_friluftsliv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import --- - -ALTER SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" OWNED BY postgis."ri:rorligt_friluftsliv".ogc_fid; - - --- --- Name: ri:skyddade_vattendrag; Type: TABLE; Schema: postgis; Owner: webmap_import --- - -CREATE TABLE postgis."ri:skyddade_vattendrag" ( - ogc_fid bigint NOT NULL, - "ORIGINALID" character varying(16), - "NAMN" character varying(64) NOT NULL, - "BESKRIVNIN" character varying(254), - "METODBESKR" character varying(254), - "TILLKDATUM" date, - "REVDATUM" date, - "ANM" character varying(254), - "DIG_SKALA" integer, - "OBJEKTLANK" character varying(254), - "REFERENS" character varying(254), - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL -); - - -ALTER TABLE postgis."ri:skyddade_vattendrag" OWNER TO webmap_import; - --- --- Name: TABLE "ri:skyddade_vattendrag"; Type: COMMENT; Schema: postgis; Owner: webmap_import --- - -COMMENT ON TABLE postgis."ri:skyddade_vattendrag" IS 'Skyddade vattendrag (MB 4 kap 6§)'; - - --- --- Name: ri:skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import --- - -CREATE SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE postgis."ri:skyddade_vattendrag_ogc_fid_seq" OWNER TO webmap_import; - --- --- Name: ri:skyddade_vattendrag_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import --- - -ALTER SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" OWNED BY postgis."ri:skyddade_vattendrag".ogc_fid; - - --- --- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import --- - -CREATE TABLE postgis."sametinget:betesomraden" ( +CREATE TABLE postgis."sametinget:betesomraden" ( ogc_fid bigint NOT NULL, "SAMEBY_ID" integer NOT NULL, "BY_ID" integer, @@ -3489,6 +3489,34 @@ ALTER TABLE ONLY postgis.lansyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postg ALTER TABLE ONLY postgis.lansyta_sub ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.lansyta_sub_ogc_fid_seq'::regclass); +-- +-- Name: lst:riksintresse_obruten_kust ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_obruten_kust" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:riksintresse_obruten_kust_ogc_fid_seq"'::regclass); + + +-- +-- Name: lst:riksintresse_obrutet_fjall ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_obrutet_fjall" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq"'::regclass); + + +-- +-- Name: lst:riksintresse_rorligt_friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_rorligt_friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq"'::regclass); + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_skyddade_vattendrag" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq"'::regclass); + + -- -- Name: mrr:bearbetningskoncessioner_ansokta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -3587,6 +3615,20 @@ ALTER TABLE ONLY postgis."mrr:ut_olja_gas_diamant_forfallna" ALTER COLUMN ogc_fi ALTER TABLE ONLY postgis."nvk:naturvardsavtal" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:naturvardsavtal_ogc_fid_seq"'::regclass); +-- +-- Name: nvk:riksintresse_friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:riksintresse_friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvk:riksintresse_naturvard ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:riksintresse_naturvard" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:riksintresse_naturvard_ogc_fid_seq"'::regclass); + + -- -- Name: nvr:Biosfarsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -3741,48 +3783,6 @@ ALTER TABLE ONLY postgis."ren:omr_riks" ALTER COLUMN ogc_fid SET DEFAULT nextval ALTER TABLE ONLY postgis."ren:riks_ren" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:riks_ren_ogc_fid_seq"'::regclass); --- --- Name: ri:friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:friluftsliv_ogc_fid_seq"'::regclass); - - --- --- Name: ri:naturvard ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:naturvard" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:naturvard_ogc_fid_seq"'::regclass); - - --- --- Name: ri:obruten_kust ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:obruten_kust" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:obruten_kust_ogc_fid_seq"'::regclass); - - --- --- Name: ri:obrutet_fjall ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:obrutet_fjall" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:obrutet_fjall_ogc_fid_seq"'::regclass); - - --- --- Name: ri:rorligt_friluftsliv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:rorligt_friluftsliv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:rorligt_friluftsliv_ogc_fid_seq"'::regclass); - - --- --- Name: ri:skyddade_vattendrag ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:skyddade_vattendrag" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ri:skyddade_vattendrag_ogc_fid_seq"'::regclass); - - -- -- Name: sametinget:betesomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -3942,43 +3942,91 @@ ALTER TABLE ONLY postgis.kommunyta -- --- Name: kommunyta kommunyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: kommunyta kommunyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.kommunyta + ADD CONSTRAINT kommunyta_objektidentitet_key UNIQUE (objektidentitet); + + +-- +-- Name: kommunyta kommunyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.kommunyta + ADD CONSTRAINT kommunyta_pkey PRIMARY KEY (ogc_fid); + + +-- +-- Name: lansyta lansyta_lanskod_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.lansyta + ADD CONSTRAINT lansyta_lanskod_key UNIQUE (lanskod); + + +-- +-- Name: lansyta lansyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.lansyta + ADD CONSTRAINT lansyta_objektidentitet_key UNIQUE (objektidentitet); + + +-- +-- Name: lansyta lansyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.lansyta + ADD CONSTRAINT lansyta_pkey PRIMARY KEY (ogc_fid); + + +-- +-- Name: lst:riksintresse_obruten_kust lst:riksintresse_obruten_kust_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_obruten_kust" + ADD CONSTRAINT "lst:riksintresse_obruten_kust_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: lst:riksintresse_obrutet_fjall lst:riksintresse_obrutet_fjall_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.kommunyta - ADD CONSTRAINT kommunyta_objektidentitet_key UNIQUE (objektidentitet); +ALTER TABLE ONLY postgis."lst:riksintresse_obrutet_fjall" + ADD CONSTRAINT "lst:riksintresse_obrutet_fjall_ORIGINALID_key" UNIQUE ("ORIGINALID"); -- --- Name: kommunyta kommunyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: lst:riksintresse_obrutet_fjall lst:riksintresse_obrutet_fjall_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.kommunyta - ADD CONSTRAINT kommunyta_pkey PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."lst:riksintresse_obrutet_fjall" + ADD CONSTRAINT "lst:riksintresse_obrutet_fjall_pkey" PRIMARY KEY (ogc_fid); -- --- Name: lansyta lansyta_lanskod_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: lst:riksintresse_rorligt_friluftsliv lst:riksintresse_rorligt_friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.lansyta - ADD CONSTRAINT lansyta_lanskod_key UNIQUE (lanskod); +ALTER TABLE ONLY postgis."lst:riksintresse_rorligt_friluftsliv" + ADD CONSTRAINT "lst:riksintresse_rorligt_friluftsliv_pkey" PRIMARY KEY (ogc_fid); -- --- Name: lansyta lansyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: lst:riksintresse_skyddade_vattendrag lst:riksintresse_skyddade_vattendrag_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.lansyta - ADD CONSTRAINT lansyta_objektidentitet_key UNIQUE (objektidentitet); +ALTER TABLE ONLY postgis."lst:riksintresse_skyddade_vattendrag" + ADD CONSTRAINT "lst:riksintresse_skyddade_vattendrag_ORIGINALID_key" UNIQUE ("ORIGINALID"); -- --- Name: lansyta lansyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: lst:riksintresse_skyddade_vattendrag lst:riksintresse_skyddade_vattendrag_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.lansyta - ADD CONSTRAINT lansyta_pkey PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."lst:riksintresse_skyddade_vattendrag" + ADD CONSTRAINT "lst:riksintresse_skyddade_vattendrag_pkey" PRIMARY KEY (ogc_fid); -- @@ -4285,6 +4333,30 @@ ALTER TABLE ONLY postgis."nvk:naturvardsavtal" ADD CONSTRAINT "nvk:naturvardsavtal_pkey" PRIMARY KEY (ogc_fid); +-- +-- Name: nvk:riksintresse_friluftsliv nvk:riksintresse_friluftsliv_OMRADESNR_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:riksintresse_friluftsliv" + ADD CONSTRAINT "nvk:riksintresse_friluftsliv_OMRADESNR_key" UNIQUE ("OMRADESNR"); + + +-- +-- Name: nvk:riksintresse_friluftsliv nvk:riksintresse_friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:riksintresse_friluftsliv" + ADD CONSTRAINT "nvk:riksintresse_friluftsliv_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvk:riksintresse_naturvard nvk:riksintresse_naturvard_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:riksintresse_naturvard" + ADD CONSTRAINT "nvk:riksintresse_naturvard_pkey" PRIMARY KEY (ogc_fid); + + -- -- Name: nvr:Biosfarsomraden nvr:Biosfarsomraden_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -4653,78 +4725,6 @@ ALTER TABLE ONLY postgis."ren:riks_ren" ADD CONSTRAINT "ren:riks_ren_pkey" PRIMARY KEY (ogc_fid); --- --- Name: ri:friluftsliv ri:friluftsliv_OMRADESNR_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:friluftsliv" - ADD CONSTRAINT "ri:friluftsliv_OMRADESNR_key" UNIQUE ("OMRADESNR"); - - --- --- Name: ri:friluftsliv ri:friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:friluftsliv" - ADD CONSTRAINT "ri:friluftsliv_pkey" PRIMARY KEY (ogc_fid); - - --- --- Name: ri:naturvard ri:naturvard_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:naturvard" - ADD CONSTRAINT "ri:naturvard_pkey" PRIMARY KEY (ogc_fid); - - --- --- Name: ri:obruten_kust ri:obruten_kust_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:obruten_kust" - ADD CONSTRAINT "ri:obruten_kust_pkey" PRIMARY KEY (ogc_fid); - - --- --- Name: ri:obrutet_fjall ri:obrutet_fjall_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:obrutet_fjall" - ADD CONSTRAINT "ri:obrutet_fjall_ORIGINALID_key" UNIQUE ("ORIGINALID"); - - --- --- Name: ri:obrutet_fjall ri:obrutet_fjall_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:obrutet_fjall" - ADD CONSTRAINT "ri:obrutet_fjall_pkey" PRIMARY KEY (ogc_fid); - - --- --- Name: ri:rorligt_friluftsliv ri:rorligt_friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:rorligt_friluftsliv" - ADD CONSTRAINT "ri:rorligt_friluftsliv_pkey" PRIMARY KEY (ogc_fid); - - --- --- Name: ri:skyddade_vattendrag ri:skyddade_vattendrag_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:skyddade_vattendrag" - ADD CONSTRAINT "ri:skyddade_vattendrag_ORIGINALID_key" UNIQUE ("ORIGINALID"); - - --- --- Name: ri:skyddade_vattendrag ri:skyddade_vattendrag_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."ri:skyddade_vattendrag" - ADD CONSTRAINT "ri:skyddade_vattendrag_pkey" PRIMARY KEY (ogc_fid); - - -- -- Name: sametinget:betesomraden sametinget:betesomraden_SAMEBY_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -5061,6 +5061,34 @@ CREATE INDEX lansyta_sub_wkb_geometry_geom_idx ON postgis.lansyta_sub USING gist CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_geometry); +-- +-- Name: lst:riksintresse_obruten_kust_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:riksintresse_obruten_kust_wkb_geometry_geom_idx" ON postgis."lst:riksintresse_obruten_kust" USING gist (wkb_geometry); + + +-- +-- Name: lst:riksintresse_obrutet_fjall_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:riksintresse_obrutet_fjall_wkb_geometry_geom_idx" ON postgis."lst:riksintresse_obrutet_fjall" USING gist (wkb_geometry); + + +-- +-- Name: lst:riksintresse_rorligt_friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:riksintresse_rorligt_friluftsliv_wkb_geometry_geom_idx" ON postgis."lst:riksintresse_rorligt_friluftsliv" USING gist (wkb_geometry); + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:riksintresse_skyddade_vattendrag_wkb_geometry_geom_idx" ON postgis."lst:riksintresse_skyddade_vattendrag" USING gist (wkb_geometry); + + -- -- Name: mrr:bearbetningskoncessioner_ansokta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -5159,6 +5187,20 @@ CREATE INDEX "mrr:ut_olja_gas_diamant_forfallna_wkb_geometry_geom_idx" ON postgi CREATE INDEX "nvk:naturvardsavtal_wkb_geometry_geom_idx" ON postgis."nvk:naturvardsavtal" USING gist (wkb_geometry); +-- +-- Name: nvk:riksintresse_friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvk:riksintresse_friluftsliv_wkb_geometry_geom_idx" ON postgis."nvk:riksintresse_friluftsliv" USING gist (wkb_geometry); + + +-- +-- Name: nvk:riksintresse_naturvard_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvk:riksintresse_naturvard_wkb_geometry_geom_idx" ON postgis."nvk:riksintresse_naturvard" USING gist (wkb_geometry); + + -- -- Name: nvr:Biosfarsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -5313,48 +5355,6 @@ CREATE INDEX "ren:omr_riks_wkb_geometry_geom_idx" ON postgis."ren:omr_riks" USIN CREATE INDEX "ren:riks_ren_wkb_geometry_geom_idx" ON postgis."ren:riks_ren" USING gist (wkb_geometry); --- --- Name: ri:friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import --- - -CREATE INDEX "ri:friluftsliv_wkb_geometry_geom_idx" ON postgis."ri:friluftsliv" USING gist (wkb_geometry); - - --- --- Name: ri:naturvard_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import --- - -CREATE INDEX "ri:naturvard_wkb_geometry_geom_idx" ON postgis."ri:naturvard" USING gist (wkb_geometry); - - --- --- Name: ri:obruten_kust_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import --- - -CREATE INDEX "ri:obruten_kust_wkb_geometry_geom_idx" ON postgis."ri:obruten_kust" USING gist (wkb_geometry); - - --- --- Name: ri:obrutet_fjall_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import --- - -CREATE INDEX "ri:obrutet_fjall_wkb_geometry_geom_idx" ON postgis."ri:obrutet_fjall" USING gist (wkb_geometry); - - --- --- Name: ri:rorligt_friluftsliv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import --- - -CREATE INDEX "ri:rorligt_friluftsliv_wkb_geometry_geom_idx" ON postgis."ri:rorligt_friluftsliv" USING gist (wkb_geometry); - - --- --- Name: ri:skyddade_vattendrag_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import --- - -CREATE INDEX "ri:skyddade_vattendrag_wkb_geometry_geom_idx" ON postgis."ri:skyddade_vattendrag" USING gist (wkb_geometry); - - -- -- Name: sametinget:betesomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -5634,6 +5634,62 @@ GRANT SELECT ON TABLE postgis.lansyta_sub TO webmap_guest; GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_sub_ogc_fid_seq TO webmap_guest; +-- +-- Name: TABLE "lst:riksintresse_obruten_kust"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:riksintresse_obruten_kust" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:riksintresse_obruten_kust_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:riksintresse_obruten_kust_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "lst:riksintresse_obrutet_fjall"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:riksintresse_obrutet_fjall" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:riksintresse_obrutet_fjall_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:riksintresse_obrutet_fjall_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "lst:riksintresse_rorligt_friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:riksintresse_rorligt_friluftsliv" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:riksintresse_rorligt_friluftsliv_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "lst:riksintresse_skyddade_vattendrag"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:riksintresse_skyddade_vattendrag" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:riksintresse_skyddade_vattendrag_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:riksintresse_skyddade_vattendrag_ogc_fid_seq" TO webmap_guest; + + -- -- Name: TABLE "mrr:bearbetningskoncessioner_ansokta"; Type: ACL; Schema: postgis; Owner: webmap_import -- @@ -5830,6 +5886,34 @@ GRANT SELECT ON TABLE postgis."nvk:naturvardsavtal" TO webmap_guest; GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" TO webmap_guest; +-- +-- Name: TABLE "nvk:riksintresse_friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvk:riksintresse_friluftsliv" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvk:riksintresse_friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:riksintresse_friluftsliv_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvk:riksintresse_naturvard"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvk:riksintresse_naturvard" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvk:riksintresse_naturvard_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" TO webmap_guest; + + -- -- Name: TABLE "nvr:Biosfarsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import -- @@ -6138,90 +6222,6 @@ GRANT SELECT ON TABLE postgis."ren:riks_ren" TO webmap_guest; GRANT SELECT,USAGE ON SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" TO webmap_guest; --- --- Name: TABLE "ri:friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT ON TABLE postgis."ri:friluftsliv" TO webmap_guest; - - --- --- Name: SEQUENCE "ri:friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:friluftsliv_ogc_fid_seq" TO webmap_guest; - - --- --- Name: TABLE "ri:naturvard"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT ON TABLE postgis."ri:naturvard" TO webmap_guest; - - --- --- Name: SEQUENCE "ri:naturvard_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:naturvard_ogc_fid_seq" TO webmap_guest; - - --- --- Name: TABLE "ri:obruten_kust"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT ON TABLE postgis."ri:obruten_kust" TO webmap_guest; - - --- --- Name: SEQUENCE "ri:obruten_kust_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:obruten_kust_ogc_fid_seq" TO webmap_guest; - - --- --- Name: TABLE "ri:obrutet_fjall"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT ON TABLE postgis."ri:obrutet_fjall" TO webmap_guest; - - --- --- Name: SEQUENCE "ri:obrutet_fjall_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:obrutet_fjall_ogc_fid_seq" TO webmap_guest; - - --- --- Name: TABLE "ri:rorligt_friluftsliv"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT ON TABLE postgis."ri:rorligt_friluftsliv" TO webmap_guest; - - --- --- Name: SEQUENCE "ri:rorligt_friluftsliv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:rorligt_friluftsliv_ogc_fid_seq" TO webmap_guest; - - --- --- Name: TABLE "ri:skyddade_vattendrag"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT ON TABLE postgis."ri:skyddade_vattendrag" TO webmap_guest; - - --- --- Name: SEQUENCE "ri:skyddade_vattendrag_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import --- - -GRANT SELECT,USAGE ON SEQUENCE postgis."ri:skyddade_vattendrag_ogc_fid_seq" TO webmap_guest; - - -- -- Name: TABLE "sametinget:betesomraden"; Type: ACL; Schema: postgis; Owner: webmap_import -- -- cgit v1.2.3