From 6c42b9221b66ab1891f3f553fc72a7d5f8d65f58 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Wed, 12 Jun 2024 20:28:17 +0200 Subject: Add schema for MRR layers. --- config.yml | 386 +++++++++++++++++++++++++++++++ schema.sql | 756 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 1142 insertions(+) diff --git a/config.yml b/config.yml index efa1841..e6746d0 100644 --- a/config.yml +++ b/config.yml @@ -726,47 +726,280 @@ layers: # The list of layers available on the WMS server can be found at # https://maps3.sgu.se/geoserver/wms?SERVICE=WMS&VERSION=1.11&REQUEST=GetCapabilities 'mrr:bearbetningskoncessioner_applied': + description: Bearbetningskoncessioner, ansökta (SGU) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Name + type: String + unique: true + nullable: false + width: 254 + #comment: benämning på området + - name: Mineral + type: String + nullable: false + width: 254 + #comment: koncessionsmineral + - name: Applicant + type: String + nullable: false + width: 254 + #comment: sökandens namn + - name: ApplicationDate + type: Date + nullable: false + - name: DiaryNr + type: String + unique: true + nullable: false + width: 16 + - name: LastUpdated + # TODO convert to Date + type: String + width: 10 + nullable: false + #comment: datum för senaste uppdatering source: download: module: webmap-download-mrr layername: 'MRR:SE.GOV.SGU.MRR.BEARBETNINGSKONCESSIONER_APPLIED_VY' cache: mrr/bearbetningskoncessioner_applied.geojson + import: + format: GeoJSON + layername: 'MRR:SE.GOV.SGU.MRR.BEARBETNINGSKONCESSIONER_APPLIED_VY' + fields: + 'Name': Name + 'Mineral': Mineral + 'Applicant': Applicant + 'Application date': ApplicationDate + 'Diary nr': DiaryNr + 'Last updated': LastUpdated + 'mrr:bearbetningskoncessioner_approved': + description: Bearbetningskoncessioner, beviljade (SGU) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Name + type: String + unique: true + nullable: false + width: 254 + #comment: benämning på området + - name: Mineral + type: String + nullable: false + width: 254 + #comment: koncessionsmineral + - name: Owner + type: String + nullable: false + width: 254 + #comment: ägares namn + - name: ValidFrom + type: Date + nullable: false + #comment: när tillståndets giltighet börjar + - name: ValidTo + type: Date + nullable: false + #comment: när tillståndets giltighet slutar + - name: DiaryNr + type: String + # TODO map empty string to NULL + #unique: true + width: 16 + - name: LastUpdated + # TODO convert to Date + type: String + width: 10 + nullable: false + #comment: datum för senaste uppdatering source: download: module: webmap-download-mrr layername: 'MRR:SE.GOV.SGU.MRR.BEARBETNINGSKONCESSIONER_APPROVED_VY' cache: mrr/bearbetningskoncessioner_approved.geojson + import: + format: GeoJSON + layername: 'MRR:SE.GOV.SGU.MRR.BEARBETNINGSKONCESSIONER_APPROVED_VY' + fields: + 'Name': Name + 'Mineral': Mineral + 'Owner': Owner + 'Valid from': ValidFrom + 'Valid to': ValidTo + 'Diary nr': DiaryNr + 'Last updated': LastUpdated + 'mrr:markanvisningar': + description: Markanvisning till koncession (SGU) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Name + type: String + nullable: false + width: 254 + #comment: benämning på området + - name: DecisionDate + type: Date + # TODO map empty string to NULL + #comment: beslutsdatum + - name: DiaryNr + type: String + # TODO map empty string to NULL + #unique: true + width: 16 + - name: LastUpdated + # TODO convert to Date + type: String + width: 10 + nullable: false + #comment: datum för senaste uppdatering source: download: module: webmap-download-mrr layername: 'MRR:SE.GOV.SGU.MRR.MARKANVISNINGAR_VY' cache: mrr/markanvisningar.geojson + import: + format: GeoJSON + layername: 'MRR:SE.GOV.SGU.MRR.MARKANVISNINGAR_VY' + fields: + 'Name': Name + 'Decision date': DecisionDate + 'Diary nr': DiaryNr + 'Last updated': LastUpdated + 'mrr:mineral_applied': + description: Undersökningstillstånd, metallar och mineral, ansökta (SGU) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Name + type: String + unique: true + nullable: false + width: 254 + #comment: benämning på området + - name: Mineral + type: String + nullable: false + width: 254 + #comment: koncessionsmineral + - name: Applicant + type: String + nullable: false + width: 254 + #comment: sökandens namn + - name: ApplicationDate + type: Date + nullable: false + - name: DiaryNr + type: String + unique: true + nullable: false + width: 16 + - name: LastUpdated + # TODO convert to Date + type: String + width: 10 + nullable: false + #comment: datum för senaste uppdatering source: download: module: webmap-download-mrr layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_APPLIED_VY' cache: mrr/mineral_applied.geojson + import: + format: GeoJSON + layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_APPLIED_VY' + fields: + 'Name': Name + 'Mineral': Mineral + 'Applicant': Applicant + 'Application date': ApplicationDate + 'Diary nr': DiaryNr + 'Last updated': LastUpdated + 'mrr:mineral_approved': + description: Undersökningstillstånd, metallar och mineral, beviljade (SGU) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Name + type: String + unique: true + nullable: false + width: 254 + #comment: benämning på området + - name: Mineral + type: String + nullable: false + width: 254 + #comment: koncessionsmineral + - name: Owner + type: String + nullable: false + width: 254 + #comment: ägares namn + - name: LicenceID + type: String + unique: true + nullable: false + width: 8 + - name: ValidFrom + type: Date + nullable: false + #comment: när tillståndets giltighet börjar + - name: ValidTo + type: Date + nullable: false + #comment: när tillståndets giltighet slutar + - name: DiaryNr + type: String + # TODO map empty string to NULL + #unique: true + width: 16 + - name: LastUpdated + # TODO convert to Date + type: String + width: 10 + nullable: false + #comment: datum för senaste uppdatering source: download: module: webmap-download-mrr layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_APPROVED_VY' cache: mrr/mineral_approved.geojson + import: + format: GeoJSON + layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_APPROVED_VY' + fields: + 'Name': Name + 'Mineral': Mineral + 'Owner': Owner + 'Licence id': LicenceID + 'Valid from': ValidFrom + 'Valid to': ValidTo + 'Diary nr': DiaryNr + 'Last updated': LastUpdated + # 'mrr:mineral_expired': # source: # download: # module: webmap-download-mrr # layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_EXPIRED_2' # cache: mrr/mineral_expired.geojson +# # 'mrr:mineral_prohibited': # source: # download: # module: webmap-download-mrr # layername: 'MRR:SE.GOV.SGU.MRR.MINERAL_PROHIBITED_2' # cache: mrr/mineral_prohibited.geojson +# # 'mrr:ogd_expired': # source: # download: @@ -779,21 +1012,174 @@ layers: # module: webmap-download-mrr # layername: 'MRR:SE.GOV.SGU.MRR.OGD_PROHIBITED_2' # cache: mrr/ogd_prohibited.geojson + 'mrr:olja_gas_diamant_applied': + description: Undersökningstillstånd, olja, gas och diamant, ansökta (SGU) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Name + type: String + unique: true + nullable: false + width: 254 + #comment: benämning på området + - name: Mineral + type: String + nullable: false + width: 254 + #comment: koncessionsmineral + - name: Applicant + type: String + nullable: false + width: 254 + #comment: sökandens namn + - name: ApplicationDate + type: Date + nullable: false + - name: DiaryNr + type: String + unique: true + nullable: false + width: 16 + - name: LastUpdated + # TODO convert to Date + type: String + width: 10 + nullable: false + #comment: datum för senaste uppdatering source: download: module: webmap-download-mrr layername: 'MRR:SE.GOV.SGU.MRR.OLJA_GAS_DIAMANT_APPLIED_VY' cache: mrr/olja_gas_diamant_applied.geojson + import: + format: GeoJSON + layername: 'MRR:SE.GOV.SGU.MRR.OLJA_GAS_DIAMANT_APPLIED_VY' + fields: + 'Name': Name + 'Mineral': Mineral + 'Applicant': Applicant + 'Application date': ApplicationDate + 'Diary nr': DiaryNr + 'Last updated': LastUpdated + 'mrr:olja_gas_diamant_approved': + description: Undersökningstillstånd, olja, gas och diamant, beviljade (SGU) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Name + type: String + unique: true + nullable: false + width: 254 + #comment: benämning på området + - name: Mineral + type: String + nullable: false + width: 254 + #comment: koncessionsmineral + - name: Owner + type: String + nullable: false + width: 254 + #comment: ägares namn + - name: LicenceID + type: String + unique: true + nullable: false + width: 8 + - name: ValidFrom + type: Date + nullable: false + #comment: när tillståndets giltighet börjar + - name: ValidTo + type: Date + nullable: false + #comment: när tillståndets giltighet slutar + - name: DiaryNr + type: String + # TODO map empty string to NULL + #unique: true + width: 16 + - name: LastUpdated + # TODO convert to Date + type: String + width: 10 + nullable: false + #comment: datum för senaste uppdatering source: download: module: webmap-download-mrr layername: 'MRR:SE.GOV.SGU.MRR.OLJA_GAS_DIAMANT_APPROVED_VY' cache: mrr/olja_gas_diamant_approved.geojson + import: + format: GeoJSON + layername: 'MRR:SE.GOV.SGU.MRR.OLJA_GAS_DIAMANT_APPROVED_VY' + fields: + 'Name': Name + 'Mineral': Mineral + 'Owner': Owner + 'Licence id': LicenceID + 'Valid from': ValidFrom + 'Valid to': ValidTo + 'Diary nr': DiaryNr + 'Last updated': LastUpdated + 'mrr:torvkoncessioner': + description: Torvkoncessioner (SGU) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Name + type: String + unique: true + nullable: false + width: 254 + #comment: benämning på området + - name: Mineral + type: String + # TODO map empty string to NULL + width: 254 + #comment: koncessionsmineral + - name: Owner + type: String + nullable: false + width: 254 + #comment: ägares namn + - name: ValidFrom + type: Date + nullable: false + #comment: när tillståndets giltighet börjar + - name: ValidTo + type: Date + nullable: false + #comment: när tillståndets giltighet slutar + - name: DiaryNr + type: String + # TODO map empty string to NULL + #unique: true + width: 16 + - name: LastUpdated + # TODO convert to Date + type: String + width: 10 + nullable: false + #comment: datum för senaste uppdatering source: download: module: webmap-download-mrr layername: 'MRR:SE.GOV.SGU.MRR.TORVKONCESSIONER_VY' cache: mrr/torvkoncessioner.geojson + import: + format: GeoJSON + layername: 'MRR:SE.GOV.SGU.MRR.TORVKONCESSIONER_VY' + fields: + 'Name': Name + 'Mineral': Mineral + 'Owner': Owner + 'Valid from': ValidFrom + 'Valid to': ValidTo + 'Diary nr': DiaryNr + 'Last updated': LastUpdated diff --git a/schema.sql b/schema.sql index 25cf25b..b1ab6ad 100644 --- a/schema.sql +++ b/schema.sql @@ -159,6 +159,378 @@ ALTER TABLE postgis.lansyta_ogc_fid_seq OWNER TO webmap_import; ALTER SEQUENCE postgis.lansyta_ogc_fid_seq OWNED BY postgis.lansyta.ogc_fid; +-- +-- Name: mrr:bearbetningskoncessioner_applied; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."mrr:bearbetningskoncessioner_applied" ( + ogc_fid bigint NOT NULL, + "Name" character varying(254) NOT NULL, + "Mineral" character varying(254) NOT NULL, + "Applicant" character varying(254) NOT NULL, + "ApplicationDate" date NOT NULL, + "DiaryNr" character(16) NOT NULL, + "LastUpdated" character(10) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."mrr:bearbetningskoncessioner_applied" OWNER TO webmap_import; + +-- +-- Name: TABLE "mrr:bearbetningskoncessioner_applied"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_applied" IS 'Bearbetningskoncessioner, ansökta (SGU)'; + + +-- +-- Name: mrr:bearbetningskoncessioner_applied_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: mrr:bearbetningskoncessioner_applied_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_applied".ogc_fid; + + +-- +-- Name: mrr:bearbetningskoncessioner_approved; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."mrr:bearbetningskoncessioner_approved" ( + ogc_fid bigint NOT NULL, + "Name" character varying(254) NOT NULL, + "Mineral" character varying(254) NOT NULL, + "Owner" character varying(254) NOT NULL, + "ValidFrom" date NOT NULL, + "ValidTo" date NOT NULL, + "DiaryNr" character(16), + "LastUpdated" character(10) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."mrr:bearbetningskoncessioner_approved" OWNER TO webmap_import; + +-- +-- Name: TABLE "mrr:bearbetningskoncessioner_approved"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."mrr:bearbetningskoncessioner_approved" IS 'Bearbetningskoncessioner, beviljade (SGU)'; + + +-- +-- Name: mrr:bearbetningskoncessioner_approved_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: mrr:bearbetningskoncessioner_approved_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" OWNED BY postgis."mrr:bearbetningskoncessioner_approved".ogc_fid; + + +-- +-- Name: mrr:markanvisningar; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."mrr:markanvisningar" ( + ogc_fid bigint NOT NULL, + "Name" character varying(254) NOT NULL, + "DecisionDate" date, + "DiaryNr" character(16), + "LastUpdated" character(10) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."mrr:markanvisningar" OWNER TO webmap_import; + +-- +-- Name: TABLE "mrr:markanvisningar"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."mrr:markanvisningar" IS 'Markanvisning till koncession (SGU)'; + + +-- +-- Name: mrr:markanvisningar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."mrr:markanvisningar_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: mrr:markanvisningar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" OWNED BY postgis."mrr:markanvisningar".ogc_fid; + + +-- +-- Name: mrr:mineral_applied; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."mrr:mineral_applied" ( + ogc_fid bigint NOT NULL, + "Name" character varying(254) NOT NULL, + "Mineral" character varying(254) NOT NULL, + "Applicant" character varying(254) NOT NULL, + "ApplicationDate" date NOT NULL, + "DiaryNr" character(16) NOT NULL, + "LastUpdated" character(10) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."mrr:mineral_applied" OWNER TO webmap_import; + +-- +-- Name: TABLE "mrr:mineral_applied"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."mrr:mineral_applied" IS 'Undersökningstillstånd, metallar och mineral, ansökta (SGU)'; + + +-- +-- Name: mrr:mineral_applied_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."mrr:mineral_applied_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: mrr:mineral_applied_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq" OWNED BY postgis."mrr:mineral_applied".ogc_fid; + + +-- +-- Name: mrr:mineral_approved; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."mrr:mineral_approved" ( + ogc_fid bigint NOT NULL, + "Name" character varying(254) NOT NULL, + "Mineral" character varying(254) NOT NULL, + "Owner" character varying(254) NOT NULL, + "LicenceID" character(8) NOT NULL, + "ValidFrom" date NOT NULL, + "ValidTo" date NOT NULL, + "DiaryNr" character(16), + "LastUpdated" character(10) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."mrr:mineral_approved" OWNER TO webmap_import; + +-- +-- Name: TABLE "mrr:mineral_approved"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."mrr:mineral_approved" IS 'Undersökningstillstånd, metallar och mineral, beviljade (SGU)'; + + +-- +-- Name: mrr:mineral_approved_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."mrr:mineral_approved_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: mrr:mineral_approved_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq" OWNED BY postgis."mrr:mineral_approved".ogc_fid; + + +-- +-- Name: mrr:olja_gas_diamant_applied; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."mrr:olja_gas_diamant_applied" ( + ogc_fid bigint NOT NULL, + "Name" character varying(254) NOT NULL, + "Mineral" character varying(254) NOT NULL, + "Applicant" character varying(254) NOT NULL, + "ApplicationDate" date NOT NULL, + "DiaryNr" character(16) NOT NULL, + "LastUpdated" character(10) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."mrr:olja_gas_diamant_applied" OWNER TO webmap_import; + +-- +-- Name: TABLE "mrr:olja_gas_diamant_applied"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."mrr:olja_gas_diamant_applied" IS 'Undersökningstillstånd, olja, gas och diamant, ansökta (SGU)'; + + +-- +-- Name: mrr:olja_gas_diamant_applied_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: mrr:olja_gas_diamant_applied_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" OWNED BY postgis."mrr:olja_gas_diamant_applied".ogc_fid; + + +-- +-- Name: mrr:olja_gas_diamant_approved; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."mrr:olja_gas_diamant_approved" ( + ogc_fid bigint NOT NULL, + "Name" character varying(254) NOT NULL, + "Mineral" character varying(254) NOT NULL, + "Owner" character varying(254) NOT NULL, + "LicenceID" character(8) NOT NULL, + "ValidFrom" date NOT NULL, + "ValidTo" date NOT NULL, + "DiaryNr" character(16), + "LastUpdated" character(10) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."mrr:olja_gas_diamant_approved" OWNER TO webmap_import; + +-- +-- Name: TABLE "mrr:olja_gas_diamant_approved"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."mrr:olja_gas_diamant_approved" IS 'Undersökningstillstånd, olja, gas och diamant, beviljade (SGU)'; + + +-- +-- Name: mrr:olja_gas_diamant_approved_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: mrr:olja_gas_diamant_approved_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" OWNED BY postgis."mrr:olja_gas_diamant_approved".ogc_fid; + + +-- +-- Name: mrr:torvkoncessioner; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."mrr:torvkoncessioner" ( + ogc_fid bigint NOT NULL, + "Name" character varying(254) NOT NULL, + "Mineral" character varying(254), + "Owner" character varying(254) NOT NULL, + "ValidFrom" date NOT NULL, + "ValidTo" date NOT NULL, + "DiaryNr" character(16), + "LastUpdated" character(10) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."mrr:torvkoncessioner" OWNER TO webmap_import; + +-- +-- Name: TABLE "mrr:torvkoncessioner"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."mrr:torvkoncessioner" IS 'Torvkoncessioner (SGU)'; + + +-- +-- Name: mrr:torvkoncessioner_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."mrr:torvkoncessioner_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: mrr:torvkoncessioner_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" OWNED BY postgis."mrr:torvkoncessioner".ogc_fid; + + -- -- Name: sks:AvverkAnm; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -280,6 +652,62 @@ ALTER TABLE ONLY postgis.kommunyta ALTER COLUMN ogc_fid SET DEFAULT nextval('pos ALTER TABLE ONLY postgis.lansyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.lansyta_ogc_fid_seq'::regclass); +-- +-- Name: mrr:bearbetningskoncessioner_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq"'::regclass); + + +-- +-- Name: mrr:bearbetningskoncessioner_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq"'::regclass); + + +-- +-- Name: mrr:markanvisningar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:markanvisningar" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:markanvisningar_ogc_fid_seq"'::regclass); + + +-- +-- Name: mrr:mineral_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:mineral_applied" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:mineral_applied_ogc_fid_seq"'::regclass); + + +-- +-- Name: mrr:mineral_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:mineral_approved" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:mineral_approved_ogc_fid_seq"'::regclass); + + +-- +-- Name: mrr:olja_gas_diamant_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq"'::regclass); + + +-- +-- Name: mrr:olja_gas_diamant_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq"'::regclass); + + +-- +-- Name: mrr:torvkoncessioner ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:torvkoncessioner" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."mrr:torvkoncessioner_ogc_fid_seq"'::regclass); + + -- -- Name: sks:AvverkAnm ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -342,6 +770,166 @@ ALTER TABLE ONLY postgis.lansyta ADD CONSTRAINT lansyta_pkey PRIMARY KEY (ogc_fid); +-- +-- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" + ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_DiaryNr_key" UNIQUE ("DiaryNr"); + + +-- +-- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" + ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_Name_key" UNIQUE ("Name"); + + +-- +-- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" + ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" + ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_Name_key" UNIQUE ("Name"); + + +-- +-- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" + ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: mrr:markanvisningar mrr:markanvisningar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:markanvisningar" + ADD CONSTRAINT "mrr:markanvisningar_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: mrr:mineral_applied mrr:mineral_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:mineral_applied" + ADD CONSTRAINT "mrr:mineral_applied_DiaryNr_key" UNIQUE ("DiaryNr"); + + +-- +-- Name: mrr:mineral_applied mrr:mineral_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:mineral_applied" + ADD CONSTRAINT "mrr:mineral_applied_Name_key" UNIQUE ("Name"); + + +-- +-- Name: mrr:mineral_applied mrr:mineral_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:mineral_applied" + ADD CONSTRAINT "mrr:mineral_applied_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: mrr:mineral_approved mrr:mineral_approved_LicenceID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:mineral_approved" + ADD CONSTRAINT "mrr:mineral_approved_LicenceID_key" UNIQUE ("LicenceID"); + + +-- +-- Name: mrr:mineral_approved mrr:mineral_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:mineral_approved" + ADD CONSTRAINT "mrr:mineral_approved_Name_key" UNIQUE ("Name"); + + +-- +-- Name: mrr:mineral_approved mrr:mineral_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:mineral_approved" + ADD CONSTRAINT "mrr:mineral_approved_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied" + ADD CONSTRAINT "mrr:olja_gas_diamant_applied_DiaryNr_key" UNIQUE ("DiaryNr"); + + +-- +-- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied" + ADD CONSTRAINT "mrr:olja_gas_diamant_applied_Name_key" UNIQUE ("Name"); + + +-- +-- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_applied" + ADD CONSTRAINT "mrr:olja_gas_diamant_applied_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_LicenceID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" + ADD CONSTRAINT "mrr:olja_gas_diamant_approved_LicenceID_key" UNIQUE ("LicenceID"); + + +-- +-- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" + ADD CONSTRAINT "mrr:olja_gas_diamant_approved_Name_key" UNIQUE ("Name"); + + +-- +-- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" + ADD CONSTRAINT "mrr:olja_gas_diamant_approved_pkey" PRIMARY KEY (ogc_fid); + + +-- +-- Name: mrr:torvkoncessioner mrr:torvkoncessioner_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:torvkoncessioner" + ADD CONSTRAINT "mrr:torvkoncessioner_Name_key" UNIQUE ("Name"); + + +-- +-- Name: mrr:torvkoncessioner mrr:torvkoncessioner_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:torvkoncessioner" + ADD CONSTRAINT "mrr:torvkoncessioner_pkey" PRIMARY KEY (ogc_fid); + + -- -- Name: sks:AvverkAnm sks:AvverkAnm_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -396,6 +984,62 @@ CREATE INDEX kommunyta_wkb_geometry_geom_idx ON postgis.kommunyta USING gist (wk CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_geometry); +-- +-- Name: mrr:bearbetningskoncessioner_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "mrr:bearbetningskoncessioner_applied_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_applied" USING gist (wkb_geometry); + + +-- +-- Name: mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_approved" USING gist (wkb_geometry); + + +-- +-- Name: mrr:markanvisningar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "mrr:markanvisningar_wkb_geometry_geom_idx" ON postgis."mrr:markanvisningar" USING gist (wkb_geometry); + + +-- +-- Name: mrr:mineral_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "mrr:mineral_applied_wkb_geometry_geom_idx" ON postgis."mrr:mineral_applied" USING gist (wkb_geometry); + + +-- +-- Name: mrr:mineral_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "mrr:mineral_approved_wkb_geometry_geom_idx" ON postgis."mrr:mineral_approved" USING gist (wkb_geometry); + + +-- +-- Name: mrr:olja_gas_diamant_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "mrr:olja_gas_diamant_applied_wkb_geometry_geom_idx" ON postgis."mrr:olja_gas_diamant_applied" USING gist (wkb_geometry); + + +-- +-- Name: mrr:olja_gas_diamant_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "mrr:olja_gas_diamant_approved_wkb_geometry_geom_idx" ON postgis."mrr:olja_gas_diamant_approved" USING gist (wkb_geometry); + + +-- +-- Name: mrr:torvkoncessioner_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX "mrr:torvkoncessioner_wkb_geometry_geom_idx" ON postgis."mrr:torvkoncessioner" USING gist (wkb_geometry); + + -- -- Name: sks:AvverkAnm_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -468,6 +1112,118 @@ GRANT SELECT ON TABLE postgis.lansyta TO webmap_guest; GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_ogc_fid_seq TO webmap_guest; +-- +-- Name: TABLE "mrr:bearbetningskoncessioner_applied"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_applied" TO webmap_guest; + + +-- +-- Name: SEQUENCE "mrr:bearbetningskoncessioner_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "mrr:bearbetningskoncessioner_approved"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_approved" TO webmap_guest; + + +-- +-- Name: SEQUENCE "mrr:bearbetningskoncessioner_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "mrr:markanvisningar"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."mrr:markanvisningar" TO webmap_guest; + + +-- +-- Name: SEQUENCE "mrr:markanvisningar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "mrr:mineral_applied"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."mrr:mineral_applied" TO webmap_guest; + + +-- +-- Name: SEQUENCE "mrr:mineral_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "mrr:mineral_approved"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."mrr:mineral_approved" TO webmap_guest; + + +-- +-- Name: SEQUENCE "mrr:mineral_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "mrr:olja_gas_diamant_applied"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_applied" TO webmap_guest; + + +-- +-- Name: SEQUENCE "mrr:olja_gas_diamant_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "mrr:olja_gas_diamant_approved"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_approved" TO webmap_guest; + + +-- +-- Name: SEQUENCE "mrr:olja_gas_diamant_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" TO webmap_guest; + + +-- +-- Name: TABLE "mrr:torvkoncessioner"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis."mrr:torvkoncessioner" TO webmap_guest; + + +-- +-- Name: SEQUENCE "mrr:torvkoncessioner_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" TO webmap_guest; + + -- -- Name: TABLE "sks:AvverkAnm"; Type: ACL; Schema: postgis; Owner: webmap_import -- -- cgit v1.2.3