aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--config.yml8
-rw-r--r--schema.sql106
2 files changed, 57 insertions, 57 deletions
diff --git a/config.yml b/config.yml
index 683b85d..562f709 100644
--- a/config.yml
+++ b/config.yml
@@ -1124,7 +1124,7 @@ layers:
DIARIENR:
- replace: 'xxxxxx'
with: null
- publish: Landskapsbildsskyddsomrade
+ publish: landskapsbildsskyddsomrade
'nvr:Biotopskydd':
# https://www.geodata.se/geodataportalen/GetMetaDataById?ID=772d46b8-25a2-42f7-b3da-4b17f610bc53
@@ -1366,7 +1366,7 @@ layers:
layername: NM_point
publish: naturminne_punkt
- 'nvr:Naturminne_polygon':
+ 'nvr:Naturminne_yta':
# https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf
description: Naturminne, yta
create:
@@ -1463,7 +1463,7 @@ layers:
DIARIENR:
- replace: 'xxxxxx'
with: null
- publish: naturminne_polygon
+ publish: naturminne_yta
'nvr:Interimistiskt_forbud':
# https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf
@@ -1819,7 +1819,7 @@ layers:
path: 'RAMSAR.shp'
format: ESRI Shapefile
layername: RAMSAR
- publish: helcom
+ publish: ramsar
'nvr:OSPAR':
# https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf
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;
--