diff options
author | Guilhem Moulin <guilhem@fripost.org> | 2025-06-07 18:19:47 +0200 |
---|---|---|
committer | Guilhem Moulin <guilhem@fripost.org> | 2025-06-07 19:47:13 +0200 |
commit | 07b3051125c227f91bf217be1f62032f0c3254c4 (patch) | |
tree | 01b046847c77c2fa016eae93aaf70fb68cf1e59d | |
parent | 5eb1fa424af776a8510ea6143b077d9727789d5b (diff) |
Rename “ren:*” tables to “sametinget:*”.
-rw-r--r-- | config.yml | 9 | ||||
-rw-r--r-- | schema.sql | 282 |
2 files changed, 145 insertions, 146 deletions
@@ -64,7 +64,6 @@ layer-groups: - 'sks:avverk_utford' ren: - 'sametinget:*' - - 'ren:*' vbk: 'vbk:*' mrr: 'mrr:*' ri: @@ -2806,7 +2805,7 @@ layers: with: null publish: utford - 'sametinget:betesomraden': + 'sametinget:betesomrade': description: 'Samebyarnas betesområden: Renbetesområden' create: # https://ext-dokument.lansstyrelsen.se/Gemensamt/Geodata/Datadistribution/Information,%20Skiktf%C3%B6rteckning%20och%20f%C3%B6rklaringar.pdf @@ -2855,7 +2854,7 @@ layers: BY_ID: - replace: 9999 with: null - publish: betesomraden + publish: betesomrade 'sametinget:flyttled': description: 'Samebyarnas markanvändningsredovisning: Flyttled' @@ -2935,7 +2934,7 @@ layers: type: regex publish: flyttled - 'ren:riks_ren': + 'sametinget:riksintresse_rennaringen': description: 'Riksintresse Rennäringen' create: geometry-type: MULTIPOLYGON @@ -2977,7 +2976,7 @@ layers: type: regex publish: riks_ren - 'ren:omr_riks': + 'sametinget:riksintresse_rennaringen_karnomrade': description: 'Riksintresse Rennäringen — Kärnområde' create: geometry-type: MULTIPOLYGON @@ -2444,38 +2444,37 @@ ALTER SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" OWNED BY postgis."nv -- --- Name: ren:omr_riks; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ren:omr_riks" ( +CREATE TABLE postgis."sametinget:betesomrade" ( ogc_fid bigint NOT NULL, - "LANK" character varying(254) NOT NULL, - "LANSKOD" character varying(25) NOT NULL, - "OMR_NR" integer, - "ARET_RUNT" integer, - "SAMEBY" character varying(62) NOT NULL, - "ANSVARIG" character varying(25) NOT NULL, + "SAMEBY_ID" integer NOT NULL, + "BY_ID" integer, + "NAMN" character varying(62) NOT NULL, + "SIGNATUR" character varying(25) NOT NULL, + "SAMEBY_TYP" character varying(62) NOT NULL, + "BY_OMR" boolean NOT NULL, + "OVR_OMR" boolean NOT NULL, "AKTUALITET" date NOT NULL, - "SIGNATUR" character varying(25), - "GlobalID" uuid NOT NULL, wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL ); -ALTER TABLE postgis."ren:omr_riks" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:betesomrade" OWNER TO webmap_import; -- --- Name: TABLE "ren:omr_riks"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:betesomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ren:omr_riks" IS 'Riksintresse Rennäringen — Kärnområde'; +COMMENT ON TABLE postgis."sametinget:betesomrade" IS 'Samebyarnas betesområden: Renbetesområden'; -- --- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" +CREATE SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -2483,44 +2482,55 @@ CREATE SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ren:omr_riks_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:betesomrade_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" OWNED BY postgis."ren:omr_riks".ogc_fid; +ALTER SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" OWNED BY postgis."sametinget:betesomrade".ogc_fid; -- --- Name: ren:riks_ren; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ren:riks_ren" ( +CREATE TABLE postgis."sametinget:flyttled" ( ogc_fid bigint NOT NULL, - "LAGRUM" character varying(254) NOT NULL, - "AKTUALITET" date NOT NULL, - "SIGNATUR" character varying(25) NOT NULL, - "LANK" character varying(254), + "LED_ID" integer NOT NULL, + "BYNR1" integer NOT NULL, + "BYNR2" integer NOT NULL, + "BYNR3" integer NOT NULL, + "SAMEBY1" character varying(62), + "SAMEBY2" character varying(62), + "SAMEBY3" character varying(62), + "KKOD" integer NOT NULL, + "BESKRIVNIN" character varying(62), + "ARSTID" character varying(62), + "KONV_AR" character varying(62), + "SIGNATUR" character varying(25), + "RIKSINTR" boolean NOT NULL, + "FAST_LED" boolean NOT NULL, + "AKTUALITET" character varying(10), "GlobalID" uuid NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL + wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL ); -ALTER TABLE postgis."ren:riks_ren" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:flyttled" OWNER TO webmap_import; -- --- Name: TABLE "ren:riks_ren"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:flyttled"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ren:riks_ren" IS 'Riksintresse Rennäringen'; +COMMENT ON TABLE postgis."sametinget:flyttled" IS 'Samebyarnas markanvändningsredovisning: Flyttled'; -- --- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" +CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -2528,103 +2538,93 @@ CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ren:riks_ren_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:flyttled_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren".ogc_fid; +ALTER SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" OWNED BY postgis."sametinget:flyttled".ogc_fid; -- --- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sametinget:betesomraden" ( +CREATE TABLE postgis."sametinget:riksintresse_rennaringen" ( ogc_fid bigint NOT NULL, - "SAMEBY_ID" integer NOT NULL, - "BY_ID" integer, - "NAMN" character varying(62) NOT NULL, - "SIGNATUR" character varying(25) NOT NULL, - "SAMEBY_TYP" character varying(62) NOT NULL, - "BY_OMR" boolean NOT NULL, - "OVR_OMR" boolean NOT NULL, + "LAGRUM" character varying(254) NOT NULL, "AKTUALITET" date NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL + "SIGNATUR" character varying(25) NOT NULL, + "LANK" character varying(254), + "GlobalID" uuid NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) ); -ALTER TABLE postgis."sametinget:betesomraden" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:riksintresse_rennaringen" OWNER TO webmap_import; -- --- Name: TABLE "sametinget:betesomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:riksintresse_rennaringen"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sametinget:betesomraden" IS 'Samebyarnas betesområden: Renbetesområden'; +COMMENT ON TABLE postgis."sametinget:riksintresse_rennaringen" IS 'Riksintresse Rennäringen'; -- --- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; +CREATE TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" ( + ogc_fid bigint NOT NULL, + "LANK" character varying(254) NOT NULL, + "LANSKOD" character varying(25) NOT NULL, + "OMR_NR" integer, + "ARET_RUNT" integer, + "SAMEBY" character varying(62) NOT NULL, + "ANSVARIG" character varying(25) NOT NULL, + "AKTUALITET" date NOT NULL, + "SIGNATUR" character varying(25), + "GlobalID" uuid NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); -ALTER TABLE postgis."sametinget:betesomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" OWNER TO webmap_import; -- --- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:riksintresse_rennaringen_karnomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" OWNED BY postgis."sametinget:betesomraden".ogc_fid; +COMMENT ON TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" IS 'Riksintresse Rennäringen — Kärnområde'; -- --- Name: sametinget:flyttled; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sametinget:flyttled" ( - ogc_fid bigint NOT NULL, - "LED_ID" integer NOT NULL, - "BYNR1" integer NOT NULL, - "BYNR2" integer NOT NULL, - "BYNR3" integer NOT NULL, - "SAMEBY1" character varying(62), - "SAMEBY2" character varying(62), - "SAMEBY3" character varying(62), - "KKOD" integer NOT NULL, - "BESKRIVNIN" character varying(62), - "ARSTID" character varying(62), - "KONV_AR" character varying(62), - "SIGNATUR" character varying(25), - "RIKSINTR" boolean NOT NULL, - "FAST_LED" boolean NOT NULL, - "AKTUALITET" character varying(10), - "GlobalID" uuid NOT NULL, - wkb_geometry postgis.geometry(MultiLineString,3006) NOT NULL -); +CREATE SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; -ALTER TABLE postgis."sametinget:flyttled" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: TABLE "sametinget:flyttled"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sametinget:flyttled" IS 'Samebyarnas markanvändningsredovisning: Flyttled'; +ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" OWNED BY postgis."sametinget:riksintresse_rennaringen_karnomrade".ogc_fid; -- --- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" +CREATE SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -2632,13 +2632,13 @@ CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sametinget:flyttled_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" OWNED BY postgis."sametinget:flyttled".ogc_fid; +ALTER SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" OWNED BY postgis."sametinget:riksintresse_rennaringen".ogc_fid; -- @@ -3770,31 +3770,31 @@ ALTER TABLE ONLY postgis."nvr:Vattenskyddsomrade" ALTER COLUMN ogc_fid SET DEFAU -- --- Name: ren:omr_riks ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:omr_riks" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:omr_riks_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sametinget:betesomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:betesomrade_ogc_fid_seq"'::regclass); -- --- Name: ren:riks_ren ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:riks_ren" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:riks_ren_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sametinget:flyttled" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:flyttled_ogc_fid_seq"'::regclass); -- --- Name: sametinget:betesomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:betesomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:betesomraden_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq"'::regclass); -- --- Name: sametinget:flyttled ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:flyttled" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:flyttled_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen_karnomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq"'::regclass); -- @@ -4694,67 +4694,67 @@ ALTER TABLE ONLY postgis."nvr:Vattenskyddsomrade" -- --- Name: ren:omr_riks ren:omr_riks_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade sametinget:betesomrade_SAMEBY_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:omr_riks" - ADD CONSTRAINT "ren:omr_riks_GlobalID_key" UNIQUE ("GlobalID"); +ALTER TABLE ONLY postgis."sametinget:betesomrade" + ADD CONSTRAINT "sametinget:betesomrade_SAMEBY_ID_key" UNIQUE ("SAMEBY_ID"); -- --- Name: ren:omr_riks ren:omr_riks_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade sametinget:betesomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:omr_riks" - ADD CONSTRAINT "ren:omr_riks_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sametinget:betesomrade" + ADD CONSTRAINT "sametinget:betesomrade_pkey" PRIMARY KEY (ogc_fid); -- --- Name: ren:riks_ren ren:riks_ren_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled sametinget:flyttled_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:riks_ren" - ADD CONSTRAINT "ren:riks_ren_GlobalID_key" UNIQUE ("GlobalID"); +ALTER TABLE ONLY postgis."sametinget:flyttled" + ADD CONSTRAINT "sametinget:flyttled_GlobalID_key" UNIQUE ("GlobalID"); -- --- Name: ren:riks_ren ren:riks_ren_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled sametinget:flyttled_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:riks_ren" - ADD CONSTRAINT "ren:riks_ren_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sametinget:flyttled" + ADD CONSTRAINT "sametinget:flyttled_pkey" PRIMARY KEY (ogc_fid); -- --- Name: sametinget:betesomraden sametinget:betesomraden_SAMEBY_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen sametinget:riksintresse_rennaringen_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:betesomraden" - ADD CONSTRAINT "sametinget:betesomraden_SAMEBY_ID_key" UNIQUE ("SAMEBY_ID"); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen" + ADD CONSTRAINT "sametinget:riksintresse_rennaringen_GlobalID_key" UNIQUE ("GlobalID"); -- --- Name: sametinget:betesomraden sametinget:betesomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade sametinget:riksintresse_rennaringen_karnomrade_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:betesomraden" - ADD CONSTRAINT "sametinget:betesomraden_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen_karnomrade" + ADD CONSTRAINT "sametinget:riksintresse_rennaringen_karnomrade_GlobalID_key" UNIQUE ("GlobalID"); -- --- Name: sametinget:flyttled sametinget:flyttled_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade sametinget:riksintresse_rennaringen_karnomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:flyttled" - ADD CONSTRAINT "sametinget:flyttled_GlobalID_key" UNIQUE ("GlobalID"); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen_karnomrade" + ADD CONSTRAINT "sametinget:riksintresse_rennaringen_karnomrade_pkey" PRIMARY KEY (ogc_fid); -- --- Name: sametinget:flyttled sametinget:flyttled_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen sametinget:riksintresse_rennaringen_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:flyttled" - ADD CONSTRAINT "sametinget:flyttled_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."sametinget:riksintresse_rennaringen" + ADD CONSTRAINT "sametinget:riksintresse_rennaringen_pkey" PRIMARY KEY (ogc_fid); -- @@ -5342,31 +5342,31 @@ CREATE INDEX "nvr:Vattenskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Vatt -- --- Name: ren:omr_riks_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ren:omr_riks_wkb_geometry_geom_idx" ON postgis."ren:omr_riks" USING gist (wkb_geometry); +CREATE INDEX "sametinget:betesomrade_wkb_geometry_geom_idx" ON postgis."sametinget:betesomrade" USING gist (wkb_geometry); -- --- Name: ren:riks_ren_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ren:riks_ren_wkb_geometry_geom_idx" ON postgis."ren:riks_ren" USING gist (wkb_geometry); +CREATE INDEX "sametinget:flyttled_wkb_geometry_geom_idx" ON postgis."sametinget:flyttled" USING gist (wkb_geometry); -- --- Name: sametinget:betesomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_geo; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sametinget:betesomraden_wkb_geometry_geom_idx" ON postgis."sametinget:betesomraden" USING gist (wkb_geometry); +CREATE INDEX "sametinget:riksintresse_rennaringen_karnomrade_wkb_geometry_geo" ON postgis."sametinget:riksintresse_rennaringen_karnomrade" USING gist (wkb_geometry); -- --- Name: sametinget:flyttled_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: sametinget:riksintresse_rennaringen_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sametinget:flyttled_wkb_geometry_geom_idx" ON postgis."sametinget:flyttled" USING gist (wkb_geometry); +CREATE INDEX "sametinget:riksintresse_rennaringen_wkb_geometry_geom_idx" ON postgis."sametinget:riksintresse_rennaringen" USING gist (wkb_geometry); -- @@ -6195,59 +6195,59 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" TO w -- --- Name: TABLE "ren:omr_riks"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:betesomrade"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ren:omr_riks" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sametinget:betesomrade" TO webmap_guest; -- --- Name: SEQUENCE "ren:omr_riks_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sametinget:betesomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:betesomrade_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "ren:riks_ren"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:flyttled"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."ren:riks_ren" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sametinget:flyttled" TO webmap_guest; -- --- Name: SEQUENCE "ren:riks_ren_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sametinget:flyttled_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "sametinget:betesomraden"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:riksintresse_rennaringen"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."sametinget:betesomraden" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sametinget:riksintresse_rennaringen" TO webmap_guest; -- --- Name: SEQUENCE "sametinget:betesomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "sametinget:riksintresse_rennaringen_karnomrade"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" TO webmap_guest; +GRANT SELECT ON TABLE postgis."sametinget:riksintresse_rennaringen_karnomrade" TO webmap_guest; -- --- Name: TABLE "sametinget:flyttled"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."sametinget:flyttled" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:riksintresse_rennaringen_karnomrade_ogc_fid_seq" TO webmap_guest; -- --- Name: SEQUENCE "sametinget:flyttled_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "sametinget:riksintresse_rennaringen_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."sametinget:riksintresse_rennaringen_ogc_fid_seq" TO webmap_guest; -- |