From e5d3578ffa6439562cfa1e5b107705c37a6367ae Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Fri, 18 Oct 2024 20:25:50 +0200
Subject: typofix

---
 schema.sql | 106 ++++++++++++++++++++++++++++++-------------------------------
 1 file changed, 53 insertions(+), 53 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index daa8ba2..c915ddd 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1050,10 +1050,10 @@ ALTER SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" OWNED BY postgis."nvr:Nati
 
 
 --
--- Name: nvr:Naturminne_polygon; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_punkt; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."nvr:Naturminne_polygon" (
+CREATE TABLE postgis."nvr:Naturminne_punkt" (
     ogc_fid bigint NOT NULL,
     "NVRID" integer NOT NULL,
     "NAMN" character varying(62) NOT NULL,
@@ -1065,31 +1065,28 @@ CREATE TABLE postgis."nvr:Naturminne_polygon" (
     "SENGALLDAT" date,
     "IUCNKAT" character varying(254) NOT NULL,
     "FORVALTARE" character varying(62) NOT NULL,
-    "LAND_HA" double precision,
-    "VATTEN_HA" double precision,
-    "SKOG_HA" double precision,
     "GEOSTATUS" character varying(62) NOT NULL,
     "DIARIENR" character varying(62),
     "LAGRUM" character varying(64) NOT NULL,
     "BESLMYND" character varying(32) NOT NULL,
-    wkb_geometry postgis.geometry(MultiPolygon,3006)
+    wkb_geometry postgis.geometry(MultiPoint,3006)
 );
 
 
-ALTER TABLE postgis."nvr:Naturminne_polygon" OWNER TO webmap_import;
+ALTER TABLE postgis."nvr:Naturminne_punkt" OWNER TO webmap_import;
 
 --
--- Name: TABLE "nvr:Naturminne_polygon"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "nvr:Naturminne_punkt"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."nvr:Naturminne_polygon" IS 'Naturminne, yta';
+COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt';
 
 
 --
--- Name: nvr:Naturminne_polygon_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq"
+CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -1097,20 +1094,20 @@ CREATE SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."nvr:Naturminne_polygon_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: nvr:Naturminne_polygon_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_polygon".ogc_fid;
+ALTER SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_punkt".ogc_fid;
 
 
 --
--- Name: nvr:Naturminne_punkt; Type: TABLE; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_yta; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE TABLE postgis."nvr:Naturminne_punkt" (
+CREATE TABLE postgis."nvr:Naturminne_yta" (
     ogc_fid bigint NOT NULL,
     "NVRID" integer NOT NULL,
     "NAMN" character varying(62) NOT NULL,
@@ -1122,28 +1119,31 @@ CREATE TABLE postgis."nvr:Naturminne_punkt" (
     "SENGALLDAT" date,
     "IUCNKAT" character varying(254) NOT NULL,
     "FORVALTARE" character varying(62) NOT NULL,
+    "LAND_HA" double precision,
+    "VATTEN_HA" double precision,
+    "SKOG_HA" double precision,
     "GEOSTATUS" character varying(62) NOT NULL,
     "DIARIENR" character varying(62),
     "LAGRUM" character varying(64) NOT NULL,
     "BESLMYND" character varying(32) NOT NULL,
-    wkb_geometry postgis.geometry(MultiPoint,3006)
+    wkb_geometry postgis.geometry(MultiPolygon,3006)
 );
 
 
-ALTER TABLE postgis."nvr:Naturminne_punkt" OWNER TO webmap_import;
+ALTER TABLE postgis."nvr:Naturminne_yta" OWNER TO webmap_import;
 
 --
--- Name: TABLE "nvr:Naturminne_punkt"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "nvr:Naturminne_yta"; Type: COMMENT; Schema: postgis; Owner: webmap_import
 --
 
-COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt';
+COMMENT ON TABLE postgis."nvr:Naturminne_yta" IS 'Naturminne, yta';
 
 
 --
--- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
 --
 
-CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq"
+CREATE SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq"
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -1151,13 +1151,13 @@ CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq"
     CACHE 1;
 
 
-ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import;
+ALTER TABLE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNER TO webmap_import;
 
 --
--- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
 --
 
-ALTER SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_punkt".ogc_fid;
+ALTER SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_yta".ogc_fid;
 
 
 --
@@ -2617,17 +2617,17 @@ ALTER TABLE ONLY postgis."nvr:Nationalpark" ALTER COLUMN ogc_fid SET DEFAULT nex
 
 
 --
--- Name: nvr:Naturminne_polygon ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_punkt ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."nvr:Naturminne_polygon" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_polygon_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_punkt_ogc_fid_seq"'::regclass);
 
 
 --
--- Name: nvr:Naturminne_punkt ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_yta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_punkt_ogc_fid_seq"'::regclass);
+ALTER TABLE ONLY postgis."nvr:Naturminne_yta" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_yta_ogc_fid_seq"'::regclass);
 
 
 --
@@ -3214,35 +3214,35 @@ ALTER TABLE ONLY postgis."nvr:Nationalpark"
 
 
 --
--- Name: nvr:Naturminne_polygon nvr:Naturminne_polygon_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."nvr:Naturminne_polygon"
-    ADD CONSTRAINT "nvr:Naturminne_polygon_NVRID_key" UNIQUE ("NVRID");
+ALTER TABLE ONLY postgis."nvr:Naturminne_punkt"
+    ADD CONSTRAINT "nvr:Naturminne_punkt_NVRID_key" UNIQUE ("NVRID");
 
 
 --
--- Name: nvr:Naturminne_polygon nvr:Naturminne_polygon_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."nvr:Naturminne_polygon"
-    ADD CONSTRAINT "nvr:Naturminne_polygon_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."nvr:Naturminne_punkt"
+    ADD CONSTRAINT "nvr:Naturminne_punkt_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
--- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_yta nvr:Naturminne_yta_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."nvr:Naturminne_punkt"
-    ADD CONSTRAINT "nvr:Naturminne_punkt_NVRID_key" UNIQUE ("NVRID");
+ALTER TABLE ONLY postgis."nvr:Naturminne_yta"
+    ADD CONSTRAINT "nvr:Naturminne_yta_NVRID_key" UNIQUE ("NVRID");
 
 
 --
--- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_yta nvr:Naturminne_yta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
 
-ALTER TABLE ONLY postgis."nvr:Naturminne_punkt"
-    ADD CONSTRAINT "nvr:Naturminne_punkt_pkey" PRIMARY KEY (ogc_fid);
+ALTER TABLE ONLY postgis."nvr:Naturminne_yta"
+    ADD CONSTRAINT "nvr:Naturminne_yta_pkey" PRIMARY KEY (ogc_fid);
 
 
 --
@@ -3786,17 +3786,17 @@ CREATE INDEX "nvr:Nationalpark_wkb_geometry_geom_idx" ON postgis."nvr:Nationalpa
 
 
 --
--- Name: nvr:Naturminne_polygon_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_punkt_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "nvr:Naturminne_polygon_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_polygon" USING gist (wkb_geometry);
+CREATE INDEX "nvr:Naturminne_punkt_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_punkt" USING gist (wkb_geometry);
 
 
 --
--- Name: nvr:Naturminne_punkt_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+-- Name: nvr:Naturminne_yta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
 
-CREATE INDEX "nvr:Naturminne_punkt_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_punkt" USING gist (wkb_geometry);
+CREATE INDEX "nvr:Naturminne_yta_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_yta" USING gist (wkb_geometry);
 
 
 --
@@ -4285,31 +4285,31 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" TO webmap_
 
 
 --
--- Name: TABLE "nvr:Naturminne_polygon"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "nvr:Naturminne_punkt"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."nvr:Naturminne_polygon" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."nvr:Naturminne_punkt" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "nvr:Naturminne_polygon_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "nvr:Naturminne_punkt_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" TO webmap_guest;
 
 
 --
--- Name: TABLE "nvr:Naturminne_punkt"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: TABLE "nvr:Naturminne_yta"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT ON TABLE postgis."nvr:Naturminne_punkt" TO webmap_guest;
+GRANT SELECT ON TABLE postgis."nvr:Naturminne_yta" TO webmap_guest;
 
 
 --
--- Name: SEQUENCE "nvr:Naturminne_punkt_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+-- Name: SEQUENCE "nvr:Naturminne_yta_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
 
-GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" TO webmap_guest;
+GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" TO webmap_guest;
 
 
 --
-- 
cgit v1.2.3

