From 4f56801e9737e1f9201ea5e2d1f23f759d65d437 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin 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