diff options
author | Guilhem Moulin <guilhem@fripost.org> | 2024-10-16 16:40:27 +0200 |
---|---|---|
committer | Guilhem Moulin <guilhem@fripost.org> | 2024-10-17 22:07:35 +0200 |
commit | 4a99837165666a56b5e9623d8b26e93d69203650 (patch) | |
tree | 80586cfdd52d51949d645a7f5fdfac6b92ac10a6 /schema.sql | |
parent | a0eb735932c6ffb2dbc11af1c53773a664b2142a (diff) |
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 2135 |
1 files changed, 2135 insertions, 0 deletions
@@ -532,6 +532,1157 @@ ALTER SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" OWNED BY postgis."mrr: -- +-- Name: nva:Naturvardsverket_Lansstyrelse; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nva:Naturvardsverket_Lansstyrelse" ( + ogc_fid bigint NOT NULL, + "ID" integer NOT NULL, + "DIARIENRNV" character(12) NOT NULL, + "STATUS" character varying(32) NOT NULL, + "OBJNAMN" character varying(64), + "FASTBET" character varying(64), + "DATSTART" date NOT NULL, + "DATSLUT" date NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nva:Naturvardsverket_Lansstyrelse" OWNER TO webmap_import; + +-- +-- Name: TABLE "nva:Naturvardsverket_Lansstyrelse"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nva:Naturvardsverket_Lansstyrelse" IS 'Naturvårdsavtal (Naturvårdsverket, Länsstyrelse)'; + + +-- +-- Name: nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" OWNED BY postgis."nva:Naturvardsverket_Lansstyrelse".ogc_fid; + + +-- +-- Name: nva:Skogsstyrelsen; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nva:Skogsstyrelsen" ( + ogc_fid bigint NOT NULL, + "Uuid" uuid NOT NULL, + "Beteckn" character(12) NOT NULL, + "ArendeAr" smallint NOT NULL, + "NvaTyp" character varying(254), + "Naturtyp" character varying(254), + "AreaTot" double precision NOT NULL, + "AreaProd" double precision NOT NULL, + "Standort" character varying(254), + "DatAvtal" date NOT NULL, + "Url" character varying(254) NOT NULL, + "Undertyp" character varying(64), + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nva:Skogsstyrelsen" OWNER TO webmap_import; + +-- +-- Name: TABLE "nva:Skogsstyrelsen"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nva:Skogsstyrelsen" IS 'Naturvårdsavtal (Skogsstyrelsen)'; + + +-- +-- Name: nva:Skogsstyrelsen_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nva:Skogsstyrelsen_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nva:Skogsstyrelsen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" OWNED BY postgis."nva:Skogsstyrelsen".ogc_fid; + + +-- +-- Name: nvr:Biosfarsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Biosfarsomraden" ( + ogc_fid bigint NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "NAMN" character varying(32) NOT NULL, + "LINK" character varying(254) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Biosfarsomraden" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Biosfarsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Biosfarsomraden" IS 'Biosfärsområden (UNESCO)'; + + +-- +-- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNED BY postgis."nvr:Biosfarsomraden".ogc_fid; + + +-- +-- Name: nvr:Biotopskydd; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Biotopskydd" ( + ogc_fid bigint NOT NULL, + "Uuid" uuid NOT NULL, + "Beteckn" character(12) NOT NULL, + "ArendeAr" smallint NOT NULL, + "Biotyp" character varying(254) NOT NULL, + "Naturtyp" character varying(254), + "AreaTot" double precision, + "AreaProd" double precision, + "Standort" character varying(254), + "Datbeslut" date, + "Url" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Biotopskydd" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Biotopskydd"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Biotopskydd" IS 'Biotopskydd i skogsmark (beslutade av Skogsstyrelsen)'; + + +-- +-- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNED BY postgis."nvr:Biotopskydd".ogc_fid; + + +-- +-- Name: nvr:Djur_och_vaxtskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(254) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "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(62) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Djur_och_vaxtskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" IS 'Djur- och växtskyddsområden'; + + +-- +-- Name: nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Djur_och_vaxtskyddsomrade".ogc_fid; + + +-- +-- Name: nvr:HELCOM; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:HELCOM" ( + ogc_fid bigint NOT NULL, + "BSPA_ID" integer NOT NULL, + "NAME" character varying(62) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygonZ,3006) +); + + +ALTER TABLE postgis."nvr:HELCOM" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:HELCOM"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:HELCOM" IS 'Marina skyddade områden (Helcom MPA)'; + + +-- +-- Name: nvr:HELCOM_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:HELCOM_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:HELCOM_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" OWNED BY postgis."nvr:HELCOM".ogc_fid; + + +-- +-- Name: nvr:Interimistiskt_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Interimistiskt_forbud" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "IUCNKAT" character varying(254) NOT NULL, + "FORVALTARE" character varying(62), + "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(16) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Interimistiskt_forbud" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Interimistiskt_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Interimistiskt_forbud" IS 'Interimistiska förbud'; + + +-- +-- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNED BY postgis."nvr:Interimistiskt_forbud".ogc_fid; + + +-- +-- Name: nvr:Kultureservat; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Kultureservat" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "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(16) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Kultureservat" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Kultureservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Kultureservat" IS 'Kulturreservat'; + + +-- +-- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Kultureservat_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" OWNED BY postgis."nvr:Kultureservat".ogc_fid; + + +-- +-- Name: nvr:Landskapsbildsskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Landskapsbildsskyddsomrade" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "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(16), + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Landskapsbildsskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" IS 'Landskapsbildsskyddsområden'; + + +-- +-- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Landskapsbildsskyddsomrade".ogc_fid; + + +-- +-- Name: nvr:Nationalpark; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Nationalpark" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "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(16) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Nationalpark" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Nationalpark"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Nationalpark" IS 'Nationalparker'; + + +-- +-- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Nationalpark_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" OWNED BY postgis."nvr:Nationalpark".ogc_fid; + + +-- +-- Name: nvr:Naturminne_polygon; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Naturminne_polygon" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "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) +); + + +ALTER TABLE postgis."nvr:Naturminne_polygon" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Naturminne_polygon"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Naturminne_polygon" IS 'Naturminne, yta'; + + +-- +-- Name: nvr:Naturminne_polygon_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Naturminne_polygon_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Naturminne_polygon_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; + + +-- +-- Name: nvr:Naturminne_punkt; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Naturminne_punkt" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "IUCNKAT" character varying(254) NOT NULL, + "FORVALTARE" character varying(62) NOT NULL, + "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) +); + + +ALTER TABLE postgis."nvr:Naturminne_punkt" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Naturminne_punkt"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt'; + + +-- +-- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Naturminne_punkt_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; + + +-- +-- Name: nvr:Naturreservat; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Naturreservat" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(128) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "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(16), + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Naturreservat" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Naturreservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Naturreservat" IS 'Naturreservat'; + + +-- +-- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Naturreservat_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Naturreservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" OWNED BY postgis."nvr:Naturreservat".ogc_fid; + + +-- +-- Name: nvr:Naturvardsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Naturvardsomrade" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(64) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "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(16) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Naturvardsomrade" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Naturvardsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Naturvardsomrade" IS 'Naturvårdsområden'; + + +-- +-- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Naturvardsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Naturvardsomrade".ogc_fid; + + +-- +-- Name: nvr:OSPAR; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:OSPAR" ( + ogc_fid bigint NOT NULL, + "ORIGIN" character varying(10) NOT NULL, + "NAMN_N2000" character varying(64) NOT NULL, + "MPA_ID" character varying(16) NOT NULL, + "MPA_NAMN" character varying(64) NOT NULL, + "N2000_SITE" character varying(16) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygonZ,3006) +); + + +ALTER TABLE postgis."nvr:OSPAR" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:OSPAR"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:OSPAR" IS 'Marina skyddade områden (Ospar MPA)'; + + +-- +-- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:OSPAR_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:OSPAR_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" OWNED BY postgis."nvr:OSPAR".ogc_fid; + + +-- +-- Name: nvr:Ovrigt_biotopskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(62) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "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(16) NOT NULL, + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Ovrigt_biotopskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" IS 'Biotopskydd utanför skogsmark'; + + +-- +-- Name: nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Ovrigt_biotopskyddsomrade".ogc_fid; + + +-- +-- Name: nvr:Ramsar; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Ramsar" ( + ogc_fid bigint NOT NULL, + "RAMSAR_ID" integer NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "NATION" character varying(32) NOT NULL, + "NAMN" character varying(32) NOT NULL, + "LAND_HA" double precision, + "VATTEN_HA" double precision, + "SKOG_HA" double precision, + "LINK" character varying(254) NOT NULL, + "URSPR_BESL" date NOT NULL, + "SEN_BESLUT" date, + "LEGAL_ACT" character varying(254) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Ramsar" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Ramsar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Ramsar" IS 'Ramsar-områden (Våtmarkskonventionen)'; + + +-- +-- Name: nvr:Ramsar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Ramsar_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Ramsar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq" OWNED BY postgis."nvr:Ramsar".ogc_fid; + + +-- +-- Name: nvr:SCI_Rikstackande; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:SCI_Rikstackande" ( + ogc_fid bigint NOT NULL, + "NAMN" character varying(62) NOT NULL, + "BEVPLAN" character varying(128) NOT NULL, + "SITE_CODE" character(9) NOT NULL, + "OMRADESTYP" character varying(16) NOT NULL, + "UPPLAMNARE" character varying(62) NOT NULL, + "SCI_FORSL" character(6) NOT NULL, + "SCI_DATUM" character(6), + "SAC_DATUM" character(6), + "SPA_DATUM" character(6), + "KVALITET" character varying(254) NOT NULL, + "KARAKTAR" character varying(254) NOT NULL, + "ARTER" character varying(254), + "NATURTYPER" character varying(254), + wkb_geometry postgis.geometry(MultiPolygonZ,3006) +); + + +ALTER TABLE postgis."nvr:SCI_Rikstackande" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:SCI_Rikstackande"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:SCI_Rikstackande" IS 'Habitatdirektivet (SCI, direktiv 92/43/EEG)'; + + +-- +-- Name: nvr:SCI_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:SCI_Rikstackande_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" OWNED BY postgis."nvr:SCI_Rikstackande".ogc_fid; + + +-- +-- Name: nvr:SPA_Rikstackande; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:SPA_Rikstackande" ( + ogc_fid bigint NOT NULL, + "NAMN" character varying(62) NOT NULL, + "BEVPLAN" character varying(128) NOT NULL, + "SITE_CODE" character(9) NOT NULL, + "OMRADESTYP" character varying(16) NOT NULL, + "UPPLAMNARE" character varying(62) NOT NULL, + "SCI_FORSL" character(6), + "SCI_DATUM" character(6), + "SAC_DATUM" character(6), + "SPA_DATUM" character(6) NOT NULL, + "KVALITET" character varying(254) NOT NULL, + "KARAKTAR" character varying(254) NOT NULL, + "ARTER" character varying(254) NOT NULL, + "NATURTYPER" character varying(254), + wkb_geometry postgis.geometry(MultiPolygonZ,3006) +); + + +ALTER TABLE postgis."nvr:SPA_Rikstackande" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:SPA_Rikstackande"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:SPA_Rikstackande" IS 'Fågeldirektivet (SPA, direktiv 79/409/EEG)'; + + +-- +-- Name: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:SPA_Rikstackande_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" OWNED BY postgis."nvr:SPA_Rikstackande".ogc_fid; + + +-- +-- Name: nvr:Tilltradesforbud; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Tilltradesforbud" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "BESLSTAT" character varying(12) NOT NULL, + "FORESKRTYP" character varying(16) NOT NULL, + "FORESKRIFT" character varying(62) NOT NULL, + "FRANDATUM" character varying(10) NOT NULL, + "TILLDATUM" character varying(10) NOT NULL, + "BESKRIVN" character varying(254), + "OBJEKTNAMN" character varying(254) NOT NULL, + "FORSKRNAMN" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Tilltradesforbud" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Tilltradesforbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Tilltradesforbud" IS 'Områden med föreskrifter som inskränker rätten att färdas eller vistas i området, permanent eller under en del av året'; + + +-- +-- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Tilltradesforbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" OWNED BY postgis."nvr:Tilltradesforbud".ogc_fid; + + +-- +-- Name: nvr:Varldsarv; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Varldsarv" ( + ogc_fid bigint NOT NULL, + "NAMN" character varying(64) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Varldsarv" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Varldsarv"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Varldsarv" IS 'Världsarv med mycket höga naturvärden (UNESCO)'; + + +-- +-- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Varldsarv_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Varldsarv_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" OWNED BY postgis."nvr:Varldsarv".ogc_fid; + + +-- +-- Name: nvr:Vattenskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."nvr:Vattenskyddsomrade" ( + ogc_fid bigint NOT NULL, + "NVRID" integer NOT NULL, + "NAMN" character varying(254) NOT NULL, + "SKYDDSTYP" character varying(32) NOT NULL, + "BESLSTATUS" character varying(12) NOT NULL, + "URSBESLDAT" date NOT NULL, + "IKRAFTDATF" date, + "URSGALLDAT" date, + "SENGALLDAT" date, + "TILLSYNSMH" character varying(64) NOT NULL, + "PROVNMHDIS" character varying(64), + "PROVNMHTIL" character varying(64), + "IUCNKAT" character varying(254) 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(16), + "BESLMYND" character varying(32) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."nvr:Vattenskyddsomrade" OWNER TO webmap_import; + +-- +-- Name: TABLE "nvr:Vattenskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."nvr:Vattenskyddsomrade" IS 'Vattenskyddsområden'; + + +-- +-- Name: nvr:Vattenskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: nvr:Vattenskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Vattenskyddsomrade".ogc_fid; + + +-- -- Name: ren:omr_riks; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -1098,6 +2249,160 @@ ALTER TABLE ONLY postgis."mrr:torvkoncessioner" ALTER COLUMN ogc_fid SET DEFAULT -- +-- Name: nva:Naturvardsverket_Lansstyrelse ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nva:Naturvardsverket_Lansstyrelse" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq"'::regclass); + + +-- +-- Name: nva:Skogsstyrelsen ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nva:Skogsstyrelsen_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Biosfarsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Biosfarsomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Biosfarsomraden_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Biotopskydd ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Biotopskydd" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Biotopskydd_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Djur_och_vaxtskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Djur_och_vaxtskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:HELCOM ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:HELCOM" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:HELCOM_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Interimistiskt_forbud ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Interimistiskt_forbud" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Interimistiskt_forbud_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Kultureservat ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Kultureservat" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Kultureservat_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Landskapsbildsskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Landskapsbildsskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Nationalpark ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Nationalpark" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Nationalpark_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Naturminne_polygon 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); + + +-- +-- Name: nvr:Naturminne_punkt 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); + + +-- +-- Name: nvr:Naturreservat ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Naturreservat" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturreservat_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Naturvardsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Naturvardsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturvardsomrade_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:OSPAR ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:OSPAR" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:OSPAR_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Ovrigt_biotopskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Ovrigt_biotopskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Ramsar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Ramsar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Ramsar_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:SCI_Rikstackande ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:SCI_Rikstackande" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:SCI_Rikstackande_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:SPA_Rikstackande ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:SPA_Rikstackande" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:SPA_Rikstackande_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Tilltradesforbud ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Tilltradesforbud" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Tilltradesforbud_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Varldsarv ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Varldsarv" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Varldsarv_ogc_fid_seq"'::regclass); + + +-- +-- Name: nvr:Vattenskyddsomrade ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Vattenskyddsomrade" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Vattenskyddsomrade_ogc_fid_seq"'::regclass); + + +-- -- Name: ren:omr_riks ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -1409,6 +2714,374 @@ ALTER TABLE ONLY postgis."mrr:torvkoncessioner" -- +-- Name: nva:Naturvardsverket_Lansstyrelse nva:Naturvardsverket_Lansstyrelse_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nva:Naturvardsverket_Lansstyrelse" + ADD CONSTRAINT "nva:Naturvardsverket_Lansstyrelse_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nva:Skogsstyrelsen nva:Skogsstyrelsen_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" + ADD CONSTRAINT "nva:Skogsstyrelsen_Beteckn_key" UNIQUE ("Beteckn"); + + +-- +-- Name: nva:Skogsstyrelsen nva:Skogsstyrelsen_Uuid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" + ADD CONSTRAINT "nva:Skogsstyrelsen_Uuid_key" UNIQUE ("Uuid"); + + +-- +-- Name: nva:Skogsstyrelsen nva:Skogsstyrelsen_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nva:Skogsstyrelsen" + ADD CONSTRAINT "nva:Skogsstyrelsen_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Biosfarsomraden nvr:Biosfarsomraden_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Biosfarsomraden" + ADD CONSTRAINT "nvr:Biosfarsomraden_NAMN_key" UNIQUE ("NAMN"); + + +-- +-- Name: nvr:Biosfarsomraden nvr:Biosfarsomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Biosfarsomraden" + ADD CONSTRAINT "nvr:Biosfarsomraden_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Biotopskydd nvr:Biotopskydd_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Biotopskydd" + ADD CONSTRAINT "nvr:Biotopskydd_Beteckn_key" UNIQUE ("Beteckn"); + + +-- +-- Name: nvr:Biotopskydd nvr:Biotopskydd_Uuid_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Biotopskydd" + ADD CONSTRAINT "nvr:Biotopskydd_Uuid_key" UNIQUE ("Uuid"); + + +-- +-- Name: nvr:Biotopskydd nvr:Biotopskydd_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Biotopskydd" + ADD CONSTRAINT "nvr:Biotopskydd_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Djur_och_vaxtskyddsomrade nvr:Djur_och_vaxtskyddsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Djur_och_vaxtskyddsomrade" + ADD CONSTRAINT "nvr:Djur_och_vaxtskyddsomrade_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:HELCOM nvr:HELCOM_BSPA_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:HELCOM" + ADD CONSTRAINT "nvr:HELCOM_BSPA_ID_key" UNIQUE ("BSPA_ID"); + + +-- +-- Name: nvr:HELCOM nvr:HELCOM_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:HELCOM" + ADD CONSTRAINT "nvr:HELCOM_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Interimistiskt_forbud nvr:Interimistiskt_forbud_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Interimistiskt_forbud" + ADD CONSTRAINT "nvr:Interimistiskt_forbud_NVRID_key" UNIQUE ("NVRID"); + + +-- +-- Name: nvr:Interimistiskt_forbud nvr:Interimistiskt_forbud_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Interimistiskt_forbud" + ADD CONSTRAINT "nvr:Interimistiskt_forbud_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Kultureservat nvr:Kultureservat_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Kultureservat" + ADD CONSTRAINT "nvr:Kultureservat_NVRID_key" UNIQUE ("NVRID"); + + +-- +-- Name: nvr:Kultureservat nvr:Kultureservat_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Kultureservat" + ADD CONSTRAINT "nvr:Kultureservat_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Landskapsbildsskyddsomrade nvr:Landskapsbildsskyddsomrade_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Landskapsbildsskyddsomrade" + ADD CONSTRAINT "nvr:Landskapsbildsskyddsomrade_NVRID_key" UNIQUE ("NVRID"); + + +-- +-- Name: nvr:Landskapsbildsskyddsomrade nvr:Landskapsbildsskyddsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Landskapsbildsskyddsomrade" + ADD CONSTRAINT "nvr:Landskapsbildsskyddsomrade_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Nationalpark nvr:Nationalpark_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Nationalpark" + ADD CONSTRAINT "nvr:Nationalpark_NVRID_key" UNIQUE ("NVRID"); + + +-- +-- Name: nvr:Nationalpark nvr:Nationalpark_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Nationalpark" + ADD CONSTRAINT "nvr:Nationalpark_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Naturminne_polygon nvr:Naturminne_polygon_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"); + + +-- +-- Name: nvr:Naturminne_polygon nvr:Naturminne_polygon_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); + + +-- +-- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_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"); + + +-- +-- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_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); + + +-- +-- Name: nvr:Naturreservat nvr:Naturreservat_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Naturreservat" + ADD CONSTRAINT "nvr:Naturreservat_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Naturvardsomrade nvr:Naturvardsomrade_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Naturvardsomrade" + ADD CONSTRAINT "nvr:Naturvardsomrade_NVRID_key" UNIQUE ("NVRID"); + + +-- +-- Name: nvr:Naturvardsomrade nvr:Naturvardsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Naturvardsomrade" + ADD CONSTRAINT "nvr:Naturvardsomrade_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:OSPAR nvr:OSPAR_MPA_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:OSPAR" + ADD CONSTRAINT "nvr:OSPAR_MPA_ID_key" UNIQUE ("MPA_ID"); + + +-- +-- Name: nvr:OSPAR nvr:OSPAR_MPA_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:OSPAR" + ADD CONSTRAINT "nvr:OSPAR_MPA_NAMN_key" UNIQUE ("MPA_NAMN"); + + +-- +-- Name: nvr:OSPAR nvr:OSPAR_N2000_SITE_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:OSPAR" + ADD CONSTRAINT "nvr:OSPAR_N2000_SITE_key" UNIQUE ("N2000_SITE"); + + +-- +-- Name: nvr:OSPAR nvr:OSPAR_NAMN_N2000_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:OSPAR" + ADD CONSTRAINT "nvr:OSPAR_NAMN_N2000_key" UNIQUE ("NAMN_N2000"); + + +-- +-- Name: nvr:OSPAR nvr:OSPAR_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:OSPAR" + ADD CONSTRAINT "nvr:OSPAR_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Ovrigt_biotopskyddsomrade nvr:Ovrigt_biotopskyddsomrade_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Ovrigt_biotopskyddsomrade" + ADD CONSTRAINT "nvr:Ovrigt_biotopskyddsomrade_NVRID_key" UNIQUE ("NVRID"); + + +-- +-- Name: nvr:Ovrigt_biotopskyddsomrade nvr:Ovrigt_biotopskyddsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Ovrigt_biotopskyddsomrade" + ADD CONSTRAINT "nvr:Ovrigt_biotopskyddsomrade_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Ramsar nvr:Ramsar_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Ramsar" + ADD CONSTRAINT "nvr:Ramsar_NAMN_key" UNIQUE ("NAMN"); + + +-- +-- Name: nvr:Ramsar nvr:Ramsar_RAMSAR_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Ramsar" + ADD CONSTRAINT "nvr:Ramsar_RAMSAR_ID_key" UNIQUE ("RAMSAR_ID"); + + +-- +-- Name: nvr:Ramsar nvr:Ramsar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Ramsar" + ADD CONSTRAINT "nvr:Ramsar_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:SCI_Rikstackande nvr:SCI_Rikstackande_SITE_CODE_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:SCI_Rikstackande" + ADD CONSTRAINT "nvr:SCI_Rikstackande_SITE_CODE_key" UNIQUE ("SITE_CODE"); + + +-- +-- Name: nvr:SCI_Rikstackande nvr:SCI_Rikstackande_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:SCI_Rikstackande" + ADD CONSTRAINT "nvr:SCI_Rikstackande_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:SPA_Rikstackande nvr:SPA_Rikstackande_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:SPA_Rikstackande" + ADD CONSTRAINT "nvr:SPA_Rikstackande_NAMN_key" UNIQUE ("NAMN"); + + +-- +-- Name: nvr:SPA_Rikstackande nvr:SPA_Rikstackande_SITE_CODE_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:SPA_Rikstackande" + ADD CONSTRAINT "nvr:SPA_Rikstackande_SITE_CODE_key" UNIQUE ("SITE_CODE"); + + +-- +-- Name: nvr:SPA_Rikstackande nvr:SPA_Rikstackande_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:SPA_Rikstackande" + ADD CONSTRAINT "nvr:SPA_Rikstackande_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Tilltradesforbud nvr:Tilltradesforbud_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Tilltradesforbud" + ADD CONSTRAINT "nvr:Tilltradesforbud_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Varldsarv nvr:Varldsarv_NAMN_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Varldsarv" + ADD CONSTRAINT "nvr:Varldsarv_NAMN_key" UNIQUE ("NAMN"); + + +-- +-- Name: nvr:Varldsarv nvr:Varldsarv_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Varldsarv" + ADD CONSTRAINT "nvr:Varldsarv_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: nvr:Vattenskyddsomrade nvr:Vattenskyddsomrade_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."nvr:Vattenskyddsomrade" + ADD CONSTRAINT "nvr:Vattenskyddsomrade_pkey" PRIMARY KEY (ogc_fid); + + +-- -- Name: ren:omr_riks ren:omr_riks_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -1631,6 +3304,160 @@ CREATE INDEX "mrr:torvkoncessioner_wkb_geometry_geom_idx" ON postgis."mrr:torvko -- +-- Name: nva:Naturvardsverket_Lansstyrelse_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nva:Naturvardsverket_Lansstyrelse_wkb_geometry_geom_idx" ON postgis."nva:Naturvardsverket_Lansstyrelse" USING gist (wkb_geometry); + + +-- +-- Name: nva:Skogsstyrelsen_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nva:Skogsstyrelsen_wkb_geometry_geom_idx" ON postgis."nva:Skogsstyrelsen" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Biosfarsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Biosfarsomraden_wkb_geometry_geom_idx" ON postgis."nvr:Biosfarsomraden" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Biotopskydd_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Biotopskydd_wkb_geometry_geom_idx" ON postgis."nvr:Biotopskydd" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Djur_och_vaxtskyddsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Djur_och_vaxtskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Djur_och_vaxtskyddsomrade" USING gist (wkb_geometry); + + +-- +-- Name: nvr:HELCOM_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:HELCOM_wkb_geometry_geom_idx" ON postgis."nvr:HELCOM" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Interimistiskt_forbud_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Interimistiskt_forbud_wkb_geometry_geom_idx" ON postgis."nvr:Interimistiskt_forbud" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Kultureservat_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Kultureservat_wkb_geometry_geom_idx" ON postgis."nvr:Kultureservat" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Landskapsbildsskyddsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Landskapsbildsskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Landskapsbildsskyddsomrade" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Nationalpark_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Nationalpark_wkb_geometry_geom_idx" ON postgis."nvr:Nationalpark" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Naturminne_polygon_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); + + +-- +-- Name: nvr:Naturminne_punkt_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); + + +-- +-- Name: nvr:Naturreservat_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Naturreservat_wkb_geometry_geom_idx" ON postgis."nvr:Naturreservat" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Naturvardsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Naturvardsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Naturvardsomrade" USING gist (wkb_geometry); + + +-- +-- Name: nvr:OSPAR_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:OSPAR_wkb_geometry_geom_idx" ON postgis."nvr:OSPAR" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Ovrigt_biotopskyddsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Ovrigt_biotopskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Ovrigt_biotopskyddsomrade" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Ramsar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Ramsar_wkb_geometry_geom_idx" ON postgis."nvr:Ramsar" USING gist (wkb_geometry); + + +-- +-- Name: nvr:SCI_Rikstackande_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:SCI_Rikstackande_wkb_geometry_geom_idx" ON postgis."nvr:SCI_Rikstackande" USING gist (wkb_geometry); + + +-- +-- Name: nvr:SPA_Rikstackande_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:SPA_Rikstackande_wkb_geometry_geom_idx" ON postgis."nvr:SPA_Rikstackande" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Tilltradesforbud_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Tilltradesforbud_wkb_geometry_geom_idx" ON postgis."nvr:Tilltradesforbud" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Varldsarv_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Varldsarv_wkb_geometry_geom_idx" ON postgis."nvr:Varldsarv" USING gist (wkb_geometry); + + +-- +-- Name: nvr:Vattenskyddsomrade_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "nvr:Vattenskyddsomrade_wkb_geometry_geom_idx" ON postgis."nvr:Vattenskyddsomrade" USING gist (wkb_geometry); + + +-- -- Name: ren:omr_riks_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -1864,6 +3691,314 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" TO web -- +-- Name: TABLE "nva:Naturvardsverket_Lansstyrelse"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nva:Naturvardsverket_Lansstyrelse" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nva:Skogsstyrelsen"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nva:Skogsstyrelsen" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nva:Skogsstyrelsen_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Biosfarsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Biosfarsomraden" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Biosfarsomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Biotopskydd"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Biotopskydd" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Biotopskydd_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Djur_och_vaxtskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:HELCOM"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:HELCOM" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:HELCOM_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Interimistiskt_forbud"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Interimistiskt_forbud" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Interimistiskt_forbud_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Kultureservat"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Kultureservat" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Kultureservat_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Landskapsbildsskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Landskapsbildsskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Nationalpark"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Nationalpark" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Nationalpark_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Naturminne_polygon"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Naturminne_polygon" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Naturminne_polygon_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; + + +-- +-- Name: TABLE "nvr:Naturminne_punkt"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Naturminne_punkt" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Naturminne_punkt_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; + + +-- +-- Name: TABLE "nvr:Naturreservat"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Naturreservat" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Naturreservat_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Naturvardsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Naturvardsomrade" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Naturvardsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:OSPAR"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:OSPAR" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:OSPAR_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Ovrigt_biotopskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Ramsar"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Ramsar" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Ramsar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:SCI_Rikstackande"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:SCI_Rikstackande" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:SCI_Rikstackande_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:SPA_Rikstackande"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:SPA_Rikstackande" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:SPA_Rikstackande_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Tilltradesforbud"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Tilltradesforbud" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Tilltradesforbud_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Varldsarv"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Varldsarv" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Varldsarv_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "nvr:Vattenskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."nvr:Vattenskyddsomrade" TO webmap_guest; + + +-- +-- Name: SEQUENCE "nvr:Vattenskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" TO webmap_guest; + + +-- -- Name: TABLE "ren:omr_riks"; Type: ACL; Schema: postgis; Owner: webmap_import -- |