diff options
author | Guilhem Moulin <guilhem@fripost.org> | 2025-06-07 18:04:43 +0200 |
---|---|---|
committer | Guilhem Moulin <guilhem@fripost.org> | 2025-06-07 18:32:04 +0200 |
commit | 5eb1fa424af776a8510ea6143b077d9727789d5b (patch) | |
tree | 32cd0f766dc32bd81c660b4d752ec11118978328 /schema.sql | |
parent | a9f4fe2c9a22b9806263cf0fd9e5996727d501b1 (diff) |
Rename “ri:*” tables to “nvk:riksintresse_*” and “lst:riksintresse_*”.
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 1076 |
1 files changed, 538 insertions, 538 deletions
@@ -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 -- |