From 46e386f4b7c295051e51a2284c33bafded82549c Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Sat, 7 Jun 2025 20:08:24 +0200
Subject: Add missing layers to schema.sql.

---
 schema.sql | 184 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 184 insertions(+)

(limited to 'schema.sql')

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

