From 4f56801e9737e1f9201ea5e2d1f23f759d65d437 Mon Sep 17 00:00:00 2001
From: Guilhem Moulin <guilhem@fripost.org>
Date: Sat, 19 Oct 2024 17:08:33 +0200
Subject: =?UTF-8?q?Add=20layers=20from=20Svenska=20Kraftn=C3=A4t=20(SvK).?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index c915ddd..78429a1 100644
--- a/schema.sql
+++ b/schema.sql
@@ -2286,6 +2286,171 @@ ALTER TABLE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNER TO webmap_import;
 ALTER SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNED BY postgis."sks:UtfordAvverk".ogc_fid;
 
 
+--
+-- Name: svk:ledningar; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."svk:ledningar" (
+    ogc_fid bigint NOT NULL,
+    "Placement" character varying(32),
+    "Voltage" integer,
+    wkb_geometry postgis.geometry(MultiLineString,3006)
+);
+
+
+ALTER TABLE postgis."svk:ledningar" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "svk:ledningar"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."svk:ledningar" IS 'Kraftledningar (befintliga)';
+
+
+--
+-- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."svk:ledningar_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."svk:ledningar_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: svk:ledningar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."svk:ledningar_ogc_fid_seq" OWNED BY postgis."svk:ledningar".ogc_fid;
+
+
+--
+-- Name: svk:stationsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."svk:stationsomraden" (
+    ogc_fid bigint NOT NULL,
+    wkb_geometry postgis.geometry(MultiPolygonZ,3006)
+);
+
+
+ALTER TABLE postgis."svk:stationsomraden" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "svk:stationsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."svk:stationsomraden" IS 'Stationsomraden';
+
+
+--
+-- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."svk:stationsomraden_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: svk:stationsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" OWNED BY postgis."svk:stationsomraden".ogc_fid;
+
+
+--
+-- Name: svk:stolpar; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."svk:stolpar" (
+    ogc_fid bigint NOT NULL,
+    wkb_geometry postgis.geometry(PointZ,3006)
+);
+
+
+ALTER TABLE postgis."svk:stolpar" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "svk:stolpar"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."svk:stolpar" IS 'Stolpar (befintliga)';
+
+
+--
+-- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."svk:stolpar_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."svk:stolpar_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: svk:stolpar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."svk:stolpar_ogc_fid_seq" OWNED BY postgis."svk:stolpar".ogc_fid;
+
+
+--
+-- Name: svk:transmissionsnatsprojekt; Type: TABLE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE TABLE postgis."svk:transmissionsnatsprojekt" (
+    ogc_fid bigint NOT NULL,
+    "Name" character varying(254),
+    "Voltage" integer,
+    "Url" character varying(254),
+    wkb_geometry postgis.geometry(MultiLineString,3006)
+);
+
+
+ALTER TABLE postgis."svk:transmissionsnatsprojekt" OWNER TO webmap_import;
+
+--
+-- Name: TABLE "svk:transmissionsnatsprojekt"; Type: COMMENT; Schema: postgis; Owner: webmap_import
+--
+
+COMMENT ON TABLE postgis."svk:transmissionsnatsprojekt" IS 'Transmissionsnätsprojekt';
+
+
+--
+-- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import
+--
+
+CREATE SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNER TO webmap_import;
+
+--
+-- Name: svk:transmissionsnatsprojekt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import
+--
+
+ALTER SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" OWNED BY postgis."svk:transmissionsnatsprojekt".ogc_fid;
+
+
 --
 -- Name: vbk:havsbaserad_vindkraft; Type: TABLE; Schema: postgis; Owner: webmap_import
 --
@@ -2784,6 +2949,34 @@ ALTER TABLE ONLY postgis."sks:AvverkAnm" ALTER COLUMN ogc_fid SET DEFAULT nextva
 ALTER TABLE ONLY postgis."sks:UtfordAvverk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:UtfordAvverk_ogc_fid_seq"'::regclass);
 
 
+--
+-- Name: svk:ledningar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:ledningar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:ledningar_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: svk:stationsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:stationsomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:stationsomraden_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: svk:stolpar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:stolpar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:stolpar_ogc_fid_seq"'::regclass);
+
+
+--
+-- Name: svk:transmissionsnatsprojekt ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:transmissionsnatsprojekt" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."svk:transmissionsnatsprojekt_ogc_fid_seq"'::regclass);
+
+
 --
 -- Name: vbk:havsbaserad_vindkraft ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import
 --
@@ -3605,6 +3798,38 @@ ALTER TABLE ONLY postgis."sks:UtfordAvverk"
     ADD CONSTRAINT "sks:UtfordAvverk_pkey" PRIMARY KEY (ogc_fid);
 
 
+--
+-- Name: svk:ledningar svk:ledningar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:ledningar"
+    ADD CONSTRAINT "svk:ledningar_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: svk:stationsomraden svk:stationsomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:stationsomraden"
+    ADD CONSTRAINT "svk:stationsomraden_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: svk:stolpar svk:stolpar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:stolpar"
+    ADD CONSTRAINT "svk:stolpar_pkey" PRIMARY KEY (ogc_fid);
+
+
+--
+-- Name: svk:transmissionsnatsprojekt svk:transmissionsnatsprojekt_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
+--
+
+ALTER TABLE ONLY postgis."svk:transmissionsnatsprojekt"
+    ADD CONSTRAINT "svk:transmissionsnatsprojekt_pkey" PRIMARY KEY (ogc_fid);
+
+
 --
 -- Name: vbk:havsbaserad_vindkraft vbk:havsbaserad_vindkraft_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import
 --
@@ -3953,6 +4178,34 @@ CREATE INDEX "sks:AvverkAnm_wkb_geometry_geom_idx" ON postgis."sks:AvverkAnm" US
 CREATE INDEX "sks:UtfordAvverk_wkb_geometry_geom_idx" ON postgis."sks:UtfordAvverk" USING gist (wkb_geometry);
 
 
+--
+-- Name: svk:ledningar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "svk:ledningar_wkb_geometry_geom_idx" ON postgis."svk:ledningar" USING gist (wkb_geometry);
+
+
+--
+-- Name: svk:stationsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "svk:stationsomraden_wkb_geometry_geom_idx" ON postgis."svk:stationsomraden" USING gist (wkb_geometry);
+
+
+--
+-- Name: svk:stolpar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "svk:stolpar_wkb_geometry_geom_idx" ON postgis."svk:stolpar" USING gist (wkb_geometry);
+
+
+--
+-- Name: svk:transmissionsnatsprojekt_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
+--
+
+CREATE INDEX "svk:transmissionsnatsprojekt_wkb_geometry_geom_idx" ON postgis."svk:transmissionsnatsprojekt" USING gist (wkb_geometry);
+
+
 --
 -- Name: vbk:havsbaserad_vindkraft_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import
 --
@@ -4627,6 +4880,62 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" TO webmap_
 GRANT SELECT ON TABLE postgis.spatial_ref_sys TO webmap_guest;
 
 
+--
+-- Name: TABLE "svk:ledningar"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."svk:ledningar" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "svk:ledningar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."svk:ledningar_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "svk:stationsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."svk:stationsomraden" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "svk:stationsomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."svk:stationsomraden_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "svk:stolpar"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."svk:stolpar" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "svk:stolpar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."svk:stolpar_ogc_fid_seq" TO webmap_guest;
+
+
+--
+-- Name: TABLE "svk:transmissionsnatsprojekt"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT ON TABLE postgis."svk:transmissionsnatsprojekt" TO webmap_guest;
+
+
+--
+-- Name: SEQUENCE "svk:transmissionsnatsprojekt_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import
+--
+
+GRANT SELECT,USAGE ON SEQUENCE postgis."svk:transmissionsnatsprojekt_ogc_fid_seq" TO webmap_guest;
+
+
 --
 -- Name: TABLE "vbk:havsbaserad_vindkraft"; Type: ACL; Schema: postgis; Owner: webmap_import
 --
-- 
cgit v1.2.3

