diff options
| -rw-r--r-- | config.yml | 16 | ||||
| -rw-r--r-- | schema.sql | 1076 |
2 files changed, 547 insertions, 545 deletions
@@ -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 @@ -432,6 +432,203 @@ ALTER SEQUENCE postgis.lansyta_sub_ogc_fid_seq OWNED BY postgis.lansyta_sub.ogc_ -- +-- 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 -- @@ -1093,6 +1290,107 @@ ALTER SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" OWNED BY postgis."nvk:n -- +-- 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,304 +2538,6 @@ 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 --- - -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 -- @@ -3490,6 +3490,34 @@ ALTER TABLE ONLY postgis.lansyta_sub ALTER COLUMN ogc_fid SET DEFAULT nextval('p -- +-- 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 -- @@ -3588,6 +3616,20 @@ ALTER TABLE ONLY postgis."nvk:naturvardsavtal" ALTER COLUMN ogc_fid SET DEFAULT -- +-- 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 -- @@ -3742,48 +3784,6 @@ ALTER TABLE ONLY postgis."ren:riks_ren" ALTER COLUMN ogc_fid SET DEFAULT nextval -- --- 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 -- @@ -3982,6 +3982,54 @@ ALTER TABLE ONLY postgis.lansyta -- +-- 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."lst:riksintresse_obrutet_fjall" + ADD CONSTRAINT "lst:riksintresse_obrutet_fjall_ORIGINALID_key" UNIQUE ("ORIGINALID"); + + +-- +-- Name: lst:riksintresse_obrutet_fjall lst:riksintresse_obrutet_fjall_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_obrutet_fjall" + ADD CONSTRAINT "lst:riksintresse_obrutet_fjall_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: lst:riksintresse_rorligt_friluftsliv lst:riksintresse_rorligt_friluftsliv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_rorligt_friluftsliv" + ADD CONSTRAINT "lst:riksintresse_rorligt_friluftsliv_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag lst:riksintresse_skyddade_vattendrag_ORIGINALID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_skyddade_vattendrag" + ADD CONSTRAINT "lst:riksintresse_skyddade_vattendrag_ORIGINALID_key" UNIQUE ("ORIGINALID"); + + +-- +-- Name: lst:riksintresse_skyddade_vattendrag lst:riksintresse_skyddade_vattendrag_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:riksintresse_skyddade_vattendrag" + ADD CONSTRAINT "lst:riksintresse_skyddade_vattendrag_pkey" PRIMARY KEY (ogc_fid); + + +-- -- Name: mrr:bearbetningskoncessioner_ansokta mrr:bearbetningskoncessioner_ansokta_diarynr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -4286,6 +4334,30 @@ ALTER TABLE ONLY postgis."nvk:naturvardsavtal" -- +-- 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 -- @@ -4654,78 +4726,6 @@ ALTER TABLE ONLY postgis."ren:riks_ren" -- --- 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 -- @@ -5062,6 +5062,34 @@ CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_ge -- +-- 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 -- @@ -5160,6 +5188,20 @@ CREATE INDEX "nvk:naturvardsavtal_wkb_geometry_geom_idx" ON postgis."nvk:naturva -- +-- 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 -- @@ -5314,48 +5356,6 @@ CREATE INDEX "ren:riks_ren_wkb_geometry_geom_idx" ON postgis."ren:riks_ren" USIN -- --- 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 -- @@ -5635,6 +5635,62 @@ 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 -- @@ -5831,6 +5887,34 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:naturvardsavtal_ogc_fid_seq" TO webm -- +-- 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 -- @@ -6139,90 +6223,6 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" TO webmap_gues -- --- 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 -- |