diff options
-rw-r--r-- | config.yml | 8 | ||||
-rw-r--r-- | schema.sql | 106 |
2 files changed, 57 insertions, 57 deletions
@@ -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 @@ -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; -- |