diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 184 |
1 files changed, 184 insertions, 0 deletions
@@ -432,6 +432,50 @@ ALTER SEQUENCE postgis.lansyta_sub_ogc_fid_seq OWNED BY postgis.lansyta_sub.ogc_ -- +-- Name: lst:pagaende_naturreservatsbildning; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."lst:pagaende_naturreservatsbildning" ( + ogc_fid bigint NOT NULL, + "OBJECTID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "GRANSJUST" date, + "DOS_ID" integer, + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."lst:pagaende_naturreservatsbildning" OWNER TO webmap_import; + +-- +-- Name: TABLE "lst:pagaende_naturreservatsbildning"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."lst:pagaende_naturreservatsbildning" IS 'LstBD Pågående naturreservatsbildning'; + + +-- +-- Name: lst:pagaende_naturreservatsbildning_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: lst:pagaende_naturreservatsbildning_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" OWNED BY postgis."lst:pagaende_naturreservatsbildning".ogc_fid; + + +-- -- Name: lst:riksintresse_obruten_kust; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -1391,6 +1435,66 @@ ALTER SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" OWNED BY postgis -- +-- Name: nvk:skyddsvard_statlig_skog; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvk:skyddsvard_statlig_skog" ( + ogc_fid bigint NOT NULL, + "ID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "AR" smallint NOT NULL, + "NATURGEOGR" character varying(62), + "OBJEKTKATE" character varying(12), + "MARKAGARE" character varying(254), + "VARDEKARNA" double precision NOT NULL, + "UTV_MARK" double precision NOT NULL, + "TOTAL_AREA" double precision NOT NULL, + "LAND" double precision NOT NULL, + "VATTEN" double precision NOT NULL, + "PROD_SKOG" double precision NOT NULL, + "SKOG_O_FJG" double precision NOT NULL, + "SKOG_N_FJG" double precision NOT NULL, + "SKYDDSZON" double precision NOT NULL, + "ARRO_MARK" double precision NOT NULL, + "KRITERIER" character varying(254) NOT NULL, + "BESKRIVN" character varying(254) NOT NULL, + "LST_BEDOMN" character varying(254) NOT NULL, + "KALLOR" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL +); + + +ALTER TABLE postgis."nvk:skyddsvard_statlig_skog" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvk:skyddsvard_statlig_skog"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvk:skyddsvard_statlig_skog" IS 'Skyddsvärda statliga skogar'; + + +-- +-- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvk:skyddsvard_statlig_skog_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" OWNED BY postgis."nvk:skyddsvard_statlig_skog".ogc_fid; + + +-- -- Name: nvr:Biosfarsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -3490,6 +3594,13 @@ ALTER TABLE ONLY postgis.lansyta_sub ALTER COLUMN ogc_fid SET DEFAULT nextval('p -- +-- Name: lst:pagaende_naturreservatsbildning ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:pagaende_naturreservatsbildning" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq"'::regclass); + + +-- -- Name: lst:riksintresse_obruten_kust ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -3630,6 +3741,13 @@ ALTER TABLE ONLY postgis."nvk:riksintresse_naturvard" ALTER COLUMN ogc_fid SET D -- +-- Name: nvk:skyddsvard_statlig_skog ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:skyddsvard_statlig_skog" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq"'::regclass); + + +-- -- Name: nvr:Biosfarsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -3982,6 +4100,22 @@ ALTER TABLE ONLY postgis.lansyta -- +-- Name: lst:pagaende_naturreservatsbildning lst:pagaende_naturreservatsbildning_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:pagaende_naturreservatsbildning" + ADD CONSTRAINT "lst:pagaende_naturreservatsbildning_OBJECTID_key" UNIQUE ("OBJECTID"); + + +-- +-- Name: lst:pagaende_naturreservatsbildning lst:pagaende_naturreservatsbildning_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."lst:pagaende_naturreservatsbildning" + ADD CONSTRAINT "lst:pagaende_naturreservatsbildning_pkey" PRIMARY KEY (ogc_fid); + + +-- -- Name: lst:riksintresse_obruten_kust lst:riksintresse_obruten_kust_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -4358,6 +4492,14 @@ ALTER TABLE ONLY postgis."nvk:riksintresse_naturvard" -- +-- Name: nvk:skyddsvard_statlig_skog nvk:skyddsvard_statlig_skog_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvk:skyddsvard_statlig_skog" + ADD CONSTRAINT "nvk:skyddsvard_statlig_skog_pkey" PRIMARY KEY (ogc_fid); + + +-- -- Name: nvr:Biosfarsomraden nvr:Biosfarsomraden_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -5062,6 +5204,13 @@ CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_ge -- +-- Name: lst:pagaende_naturreservatsbildning_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "lst:pagaende_naturreservatsbildning_wkb_geometry_geom_idx" ON postgis."lst:pagaende_naturreservatsbildning" USING gist (wkb_geometry); + + +-- -- Name: lst:riksintresse_obruten_kust_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -5202,6 +5351,13 @@ CREATE INDEX "nvk:riksintresse_naturvard_wkb_geometry_geom_idx" ON postgis."nvk: -- +-- Name: nvk:skyddsvard_statlig_skog_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvk:skyddsvard_statlig_skog_wkb_geometry_geom_idx" ON postgis."nvk:skyddsvard_statlig_skog" USING gist (wkb_geometry); + + +-- -- Name: nvr:Biosfarsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -5635,6 +5791,20 @@ GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_sub_ogc_fid_seq TO webmap_guest; -- +-- Name: TABLE "lst:pagaende_naturreservatsbildning"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."lst:pagaende_naturreservatsbildning" TO webmap_guest; + + +-- +-- Name: SEQUENCE "lst:pagaende_naturreservatsbildning_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."lst:pagaende_naturreservatsbildning_ogc_fid_seq" TO webmap_guest; + + +-- -- Name: TABLE "lst:riksintresse_obruten_kust"; Type: ACL; Schema: postgis; Owner: webmap_import -- @@ -5915,6 +6085,20 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:riksintresse_naturvard_ogc_fid_seq" -- +-- Name: TABLE "nvk:skyddsvard_statlig_skog"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvk:skyddsvard_statlig_skog" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvk:skyddsvard_statlig_skog_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvk:skyddsvard_statlig_skog_ogc_fid_seq" TO webmap_guest; + + +-- -- Name: TABLE "nvr:Biosfarsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import -- |