diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 309 |
1 files changed, 309 insertions, 0 deletions
@@ -2287,6 +2287,171 @@ ALTER SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNED BY postgis."sks:Utfo -- +-- 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 -- @@ -2785,6 +2950,34 @@ ALTER TABLE ONLY postgis."sks:UtfordAvverk" ALTER COLUMN ogc_fid SET DEFAULT nex -- +-- 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 -- @@ -3606,6 +3799,38 @@ ALTER TABLE ONLY postgis."sks:UtfordAvverk" -- +-- 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 -- @@ -3954,6 +4179,34 @@ CREATE INDEX "sks:UtfordAvverk_wkb_geometry_geom_idx" ON postgis."sks:UtfordAvve -- +-- 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 -- @@ -4628,6 +4881,62 @@ 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 -- |