From 46e386f4b7c295051e51a2284c33bafded82549c Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Sat, 7 Jun 2025 20:08:24 +0200 Subject: Add missing layers to schema.sql. --- schema.sql | 184 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 184 insertions(+) diff --git a/schema.sql b/schema.sql index 7a5e67f..1a65924 100644 --- a/schema.sql +++ b/schema.sql @@ -431,6 +431,50 @@ ALTER TABLE postgis.lansyta_sub_ogc_fid_seq OWNER TO webmap_import; ALTER SEQUENCE postgis.lansyta_sub_ogc_fid_seq OWNED BY postgis.lansyta_sub.ogc_fid; +-- +-- Name: lst:pagaende_naturreservatsbildning; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."lst:pagaende_naturreservatsbildning" ( + ogc_fid bigint NOT NULL, + "OBJECTID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "GRANSJUST" date, + "DOS_ID" integer, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."lst:pagaende_naturreservatsbildning" OWNER TO webmap_import; + +-- +-- Name: TABLE "lst:pagaende_naturreservatsbildning"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."lst:pagaende_naturreservatsbildning" IS 'LstBD Pågående naturreservatsbildning'; + + +-- +-- Name: lst:pagaende_naturreservatsbildning_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: lst:pagaende_naturreservatsbildning_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" OWNED BY postgis."lst:pagaende_naturreservatsbildning".ogc_fid; + + -- -- Name: lst:riksintresse_obruten_kust; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -1390,6 +1434,66 @@ ALTER TABLE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNER TO webmap_imp ALTER SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNED BY postgis."nvk:riksintresse_naturvard".ogc_fid; +-- +-- Name: nvk:skyddsvard_statlig_skog; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvk:skyddsvard_statlig_skog" ( + ogc_fid bigint NOT NULL, + "ID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "AR" smallint NOT NULL, + "NATURGEOGR" character varying(62), + "OBJEKTKATE" character varying(12), + "MARKAGARE" character varying(254), + "VARDEKARNA" double precision NOT NULL, + "UTV_MARK" double precision NOT NULL, + "TOTAL_AREA" double precision NOT NULL, + "LAND" double precision NOT NULL, + "VATTEN" double precision NOT NULL, + "PROD_SKOG" double precision NOT NULL, + "SKOG_O_FJG" double precision NOT NULL, + "SKOG_N_FJG" double precision NOT NULL, + "SKYDDSZON" double precision NOT NULL, + "ARRO_MARK" double precision NOT NULL, + "KRITERIER" character varying(254) NOT NULL, + "BESKRIVN" character varying(254) NOT NULL, + "LST_BEDOMN" character varying(254) NOT NULL, + "KALLOR" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvk:skyddsvard_statlig_skog" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvk:skyddsvard_statlig_skog"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvk:skyddsvard_statlig_skog" IS 'Skyddsvärda statliga skogar'; + + +-- +-- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNED BY postgis."nvk:skyddsvard_statlig_skog".ogc_fid; + + -- -- Name: nvr:Biosfarsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -3489,6 +3593,13 @@ ALTER TABLE ONLY postgis.lansyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postg ALTER TABLE ONLY postgis.lansyta_sub ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.lansyta_sub_ogc_fid_seq'::regclass); +-- +-- Name: lst:pagaende_naturreservatsbildning ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:pagaende_naturreservatsbildning" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq"'::regclass); + + -- -- Name: lst:riksintresse_obruten_kust ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -3629,6 +3740,13 @@ ALTER TABLE ONLY postgis."nvk:riksintresse_friluftsliv" ALTER COLUMN ogc_fid SET ALTER TABLE ONLY postgis."nvk:riksintresse_naturvard" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:riksintresse_naturvard_ogc_fid_seq"'::regclass); +-- +-- Name: nvk:skyddsvard_statlig_skog ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:skyddsvard_statlig_skog" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq"'::regclass); + + -- -- Name: nvr:Biosfarsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -3981,6 +4099,22 @@ ALTER TABLE ONLY postgis.lansyta ADD CONSTRAINT lansyta_pkey PRIMARY KEY (ogc_fid); +-- +-- Name: lst:pagaende_naturreservatsbildning lst:pagaende_naturreservatsbildning_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:pagaende_naturreservatsbildning" + ADD CONSTRAINT "lst:pagaende_naturreservatsbildning_OBJECTID_key" UNIQUE ("OBJECTID"); + + +-- +-- Name: lst:pagaende_naturreservatsbildning lst:pagaende_naturreservatsbildning_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:pagaende_naturreservatsbildning" + ADD CONSTRAINT "lst:pagaende_naturreservatsbildning_pkey" PRIMARY KEY (ogc_fid); + + -- -- Name: lst:riksintresse_obruten_kust lst:riksintresse_obruten_kust_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -4357,6 +4491,14 @@ ALTER TABLE ONLY postgis."nvk:riksintresse_naturvard" ADD CONSTRAINT "nvk:riksintresse_naturvard_pkey" PRIMARY KEY (ogc_fid); +-- +-- Name: nvk:skyddsvard_statlig_skog nvk:skyddsvard_statlig_skog_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:skyddsvard_statlig_skog" + ADD CONSTRAINT "nvk:skyddsvard_statlig_skog_pkey" PRIMARY KEY (ogc_fid); + + -- -- Name: nvr:Biosfarsomraden nvr:Biosfarsomraden_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -5061,6 +5203,13 @@ CREATE INDEX lansyta_sub_wkb_geometry_geom_idx ON postgis.lansyta_sub USING gist CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_geometry); +-- +-- Name: lst:pagaende_naturreservatsbildning_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:pagaende_naturreservatsbildning_wkb_geometry_geom_idx" ON postgis."lst:pagaende_naturreservatsbildning" USING gist (wkb_geometry); + + -- -- Name: lst:riksintresse_obruten_kust_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -5201,6 +5350,13 @@ CREATE INDEX "nvk:riksintresse_friluftsliv_wkb_geometry_geom_idx" ON postgis."nv CREATE INDEX "nvk:riksintresse_naturvard_wkb_geometry_geom_idx" ON postgis."nvk:riksintresse_naturvard" USING gist (wkb_geometry); +-- +-- Name: nvk:skyddsvard_statlig_skog_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvk:skyddsvard_statlig_skog_wkb_geometry_geom_idx" ON postgis."nvk:skyddsvard_statlig_skog" USING gist (wkb_geometry); + + -- -- Name: nvr:Biosfarsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -5634,6 +5790,20 @@ GRANT SELECT ON TABLE postgis.lansyta_sub TO webmap_guest; GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_sub_ogc_fid_seq TO webmap_guest; +-- +-- Name: TABLE "lst:pagaende_naturreservatsbildning"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:pagaende_naturreservatsbildning" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:pagaende_naturreservatsbildning_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" TO webmap_guest; + + -- -- Name: TABLE "lst:riksintresse_obruten_kust"; Type: ACL; Schema: postgis; Owner: webmap_import -- @@ -5914,6 +6084,20 @@ GRANT SELECT ON TABLE postgis."nvk:riksintresse_naturvard" TO webmap_guest; GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" TO webmap_guest; +-- +-- Name: TABLE "nvk:skyddsvard_statlig_skog"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvk:skyddsvard_statlig_skog" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvk:skyddsvard_statlig_skog_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" TO webmap_guest; + + -- -- Name: TABLE "nvr:Biosfarsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import -- -- cgit v1.2.3