From 4a99837165666a56b5e9623d8b26e93d69203650 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Wed, 16 Oct 2024 16:40:27 +0200 Subject: =?UTF-8?q?Add=20layers=20for=20Naturv=C3=A5rdsregistret=20and=20N?= =?UTF-8?q?aturv=C3=A5rdsavtal.?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- config.yml | 1656 +++++++++++++++++++++++++++++++- schema.sql | 3143 ++++++++++++++++++++++++++++++++++++++++++++++++++---------- 2 files changed, 4255 insertions(+), 544 deletions(-) diff --git a/config.yml b/config.yml index 88201b0..6fe026d 100644 --- a/config.yml +++ b/config.yml @@ -54,7 +54,12 @@ layer-groups: administrativindelning: - lansyta - kommunyta - nvr: 'nvr:*' + nvr: + - 'nvr:*' + # naturvårdsavtal isn't part of naturvårdsregistret, but we include them + # anyway since both refer to restricted/protected nature and users + # are likely to be interested in both + - 'nva:*' sks: 'sks:*' ren: - 'sametinget:*' @@ -357,102 +362,1673 @@ layers: - kommunkod - 'nvr:TILLTRADESFORBUD': + 'nvr:Tilltradesforbud': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: 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 + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + # XXX how come there is no UNIQUE constraint here? + unique: false + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: BESLSTAT + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: FORESKRTYP + type: String + width: 16 + nullable: false + - name: FORESKRIFT + type: String + width: 62 + nullable: false + - name: FRANDATUM + type: String + width: 10 + nullable: false + - name: TILLDATUM + type: String + width: 10 + nullable: false + - name: BESKRIVN + type: String + width: 254 + - name: OBJEKTNAMN + type: String + width: 254 + nullable: false + - name: FORSKRNAMN + type: String + width: 254 source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/TILLTRADESFORBUD.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'Tilltradesforbud.*' + import: + path: 'Tilltradesforbud.shp' + format: ESRI Shapefile + layername: Tilltradesforbud + publish: tilltradesforbud - 'nvr:NP': + 'nvr:Nationalpark': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Nationalparker + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + unique: true + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 62 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + nullable: false + comment: Förvaltare för området + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 16 + nullable: false + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/NP.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'NP/NP_polygon.*' + import: + path: 'NP/NP_polygon.shp' + format: ESRI Shapefile + layername: NP_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: nationalpark - 'nvr:NR': + 'nvr:Naturreservat': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Naturreservat + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + # XXX how come there is no UNIQUE constraint here? + unique: false + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 128 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + nullable: false + comment: Förvaltare för området + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 16 + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/NR.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'NR/NR_polygon.*' + import: + path: 'NR/NR_polygon.shp' + format: ESRI Shapefile + layername: NR_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: + naturreservat: + where: | + "BESLMYND" IS NULL OR "BESLMYND" != 'Kommun' + naturreservat_kommunalt: + where: | + "BESLMYND" = 'Kommun' - 'nvr:NVO': + 'nvr:Naturvardsomrade': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Naturvårdsområden + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + unique: true + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 64 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + nullable: false + comment: Förvaltare för området + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 16 + nullable: false + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/NVO.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'NVO/NVO_polygon.*' + import: + path: 'NVO/NVO_polygon.shp' + format: ESRI Shapefile + layername: NVO_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: naturvardsomrade - 'nvr:DVO': + 'nvr:Djur_och_vaxtskyddsomrade': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Djur- och växtskyddsområden + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + # XXX how come there is no UNIQUE constraint here? + unique: false + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 254 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + nullable: false + comment: Förvaltare för området + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 62 + nullable: false + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/DVO.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'DVO/DVO_polygon.*' + import: + path: 'DVO/DVO_polygon.shp' + format: ESRI Shapefile + layername: DVO_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: djur_och_vaxtskyddsomrade - 'nvr:KR': - source: - download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/KR.zip' - cache: naturvardsregistret/ - - 'nvr:VSO': - source: - download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/VSO.zip' - cache: naturvardsregistret/ - - 'nvr:LBSO': - source: - download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/LBSO.zip' - cache: naturvardsregistret/ - - 'nvr:OBO': - source: - download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/OBO.zip' - cache: naturvardsregistret/ - - 'nvr:NM': - source: - download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/NM.zip' - cache: naturvardsregistret/ - - 'nvr:IF': + 'nvr:Kultureservat': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Kulturreservat + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + unique: true + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 62 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + nullable: false + comment: Förvaltare för området + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 16 + nullable: false + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet + source: + download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/KR.zip' + cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'KR/KR_polygon.*' + import: + path: 'KR/KR_polygon.shp' + format: ESRI Shapefile + layername: KR_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: kulturreservat + + 'nvr:Vattenskyddsomrade': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Vattenskyddsområden + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + # XXX how come there is no UNIQUE constraint here? + unique: false + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 254 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: TILLSYNSMH + type: String + width: 64 + nullable: false + comment: Tillsynsmyndighet + - name: PROVNMHDIS + type: String + width: 64 + comment: Prövningsmyndighet för dispens + - name: PROVNMHTIL + type: String + width: 64 + comment: Prövningsmyndighet för tillstånd + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 16 + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet + source: + download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/VSO.zip' + cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'VSO/VSO_polygon.*' + import: + path: 'VSO/VSO_polygon.shp' + format: ESRI Shapefile + layername: VSO_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: vattenskyddsomrade + + 'nvr:Landskapsbildsskyddsomrade': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Landskapsbildsskyddsområden + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + unique: true + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 62 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + nullable: false + comment: Förvaltare för området + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 16 + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet + source: + download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/LBSO.zip' + cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'LBSO/LBSO_polygon.*' + import: + path: 'LBSO/LBSO_polygon.shp' + format: ESRI Shapefile + layername: LBSO_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: Landskapsbildsskyddsomrade + + 'nvr:Biotopskydd': + # https://www.geodata.se/geodataportalen/GetMetaDataById?ID=772d46b8-25a2-42f7-b3da-4b17f610bc53 + description: Biotopskydd i skogsmark (beslutade av Skogsstyrelsen) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Uuid + type: String + subtype: UUID + #width: 36 + unique: true + nullable: false + comment: Unik identitet + - name: Beteckn + type: String + width: 12 + unique: true + nullable: false + comment: Ärendebeteckning + - name: ArendeAr + type: Integer + subtype: Int16 + nullable: false + comment: År anmälan/ansökan registrerades + - name: Biotyp + type: String + width: 254 + nullable: false + - name: Naturtyp + type: String + width: 254 + - name: AreaTot + type: Real + - name: AreaProd + type: Real + - name: Standort + type: String + width: 254 + - name: Datbeslut + type: Date + - name: Url + type: String + width: 254 + source: + download: 'https://geodpags.skogsstyrelsen.se/geodataport/data/sksBiotopskydd_gpkg.zip' + cache: sks/ + unar: + format: zip + import: + path: sksBiotopskydd.gpkg + format: GPKG + layername: BiotopskyddYta + value-map: + Standort: + - replace: 'saknas' + with: null + publish: skogligt_biotopskyddsomrade + + 'nvr:Ovrigt_biotopskyddsomrade': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Biotopskydd utanför skogsmark + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + unique: true + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 62 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + nullable: false + comment: Förvaltare för området + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 16 + nullable: false + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet + source: + download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/OBO.zip' + cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'OBO/OBO_polygon.*' + import: + path: 'OBO/OBO_polygon.shp' + format: ESRI Shapefile + layername: OBO_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: ovrigt_biotopskyddsomrade + + 'nvr:Naturminne_punkt': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Naturminne, punkt + create: + geometry-type: MULTIPOINT + fields: + - name: NVRID + type: Integer + unique: true + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 62 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + nullable: false + comment: Förvaltare för området + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 64 + nullable: false + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet + source: + download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/NM.zip' + cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'NM/NM_point.*' + import: + path: 'NM/NM_point.shp' + format: ESRI Shapefile + layername: NM_point + publish: naturminne_punkt + + 'nvr:Naturminne_polygon': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Naturminne, yta + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + unique: true + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 62 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + nullable: false + comment: Förvaltare för området + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 64 + nullable: false + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet + source: + download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/NM.zip' + cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'NM/NM_polygon.*' + import: + path: 'NM/NM_polygon.shp' + format: ESRI Shapefile + layername: NM_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: naturminne_polygon + + 'nvr:Interimistiskt_forbud': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Interimistiska förbud + create: + geometry-type: MULTIPOLYGON + fields: + - name: NVRID + type: Integer + unique: true + nullable: false + comment: Områdets unika ID i naturvårdsregistret + - name: NAMN + type: String + width: 62 + nullable: false + comment: Områdets namn + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: BESLSTATUS + type: String + width: 12 + nullable: false + comment: Beslutsstatus + - name: URSBESLDAT + type: Date + nullable: false + comment: Ursprungligt beslutsdatum + - name: IKRAFTDATF + type: Date + comment: Ikraftträdandedatum för föreskrifte + - name: URSGALLDAT + type: Date + comment: Ursprungligt gällandedatum + - name: SENGALLDAT + type: Date + comment: Senaste gällandedatum + - name: IUCNKAT + alias: IUCNkategori + type: String + width: 254 + nullable: false + comment: Klassificering av skyddade områden enligt internationella naturvårdsunionens + - name: FORVALTARE + type: String + width: 62 + comment: Förvaltare för området + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: GEOSTATUS + type: String + width: 62 + nullable: false + comment: Hur ytter gränsen för området har mätts in + - name: DIARIENR + type: String + width: 62 + nullable: true + comment: Diarienummer i beslutande myndighets diarium + - name: LAGRUM + type: String + width: 16 + nullable: false + comment: Lagrum som använts som grund för beslutet + - name: BESLMYND + type: String + width: 32 + nullable: false + comment: Beslutsmyndighet source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/IF.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'IF/IF_polygon.*' + import: + path: 'IF/IF_polygon.shp' + format: ESRI Shapefile + layername: IF_polygon + value-map: + DIARIENR: + - replace: 'xxxxxx' + with: null + publish: interimistiskt_forbud 'nvr:SPA_Rikstackande': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Fågeldirektivet (SPA, direktiv 79/409/EEG) + create: + geometry-type: MULTIPOLYGONZ + fields: + - name: NAMN + type: String + width: 62 + unique: true + nullable: false + comment: Områdets namn + - name: BEVPLAN + type: String + width: 128 + nullable: false + - name: SITE_CODE + type: String + width: 9 + unique: true + nullable: false + - name: OMRADESTYP + type: String + width: 16 + nullable: false + - name: UPPLAMNARE + type: String + width: 62 + nullable: false + - name: SCI_FORSL + type: String + width: 6 + - name: SCI_DATUM + type: String + width: 6 + - name: SAC_DATUM + type: String + width: 6 + - name: SPA_DATUM + type: String + width: 6 + nullable: false + - name: KVALITET + type: String + width: 254 + nullable: false + - name: KARAKTAR + type: String + width: 254 + nullable: false + - name: ARTER + type: String + width: 254 + nullable: false + - name: NATURTYPER + type: String + width: 254 source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/SPA_Rikstackande.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'SPA_rikstackande.*' + import: + path: 'SPA_rikstackande.shp' + format: ESRI Shapefile + layername: SPA_rikstackande + publish: fageldirektivet 'nvr:SCI_Rikstackande': - source: - download: - url: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/SCI_Rikstackande.zip' - max-size: 134217728 # 128MiB - cache: naturvardsregistret/ + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Habitatdirektivet (SCI, direktiv 92/43/EEG) + create: + geometry-type: MULTIPOLYGONZ + fields: + - name: NAMN + type: String + width: 62 + # XXX how come there is no UNIQUE constraint here? + unique: false + nullable: false + comment: Områdets namn + - name: BEVPLAN + type: String + width: 128 + nullable: false + - name: SITE_CODE + type: String + width: 9 + unique: true + nullable: false + - name: OMRADESTYP + type: String + width: 16 + nullable: false + - name: UPPLAMNARE + type: String + width: 62 + nullable: false + - name: SCI_FORSL + type: String + width: 6 + nullable: false + - name: SCI_DATUM + type: String + width: 6 + - name: SAC_DATUM + type: String + width: 6 + - name: SPA_DATUM + type: String + width: 6 + - name: KVALITET + type: String + width: 254 + nullable: false + - name: KARAKTAR + type: String + width: 254 + nullable: false + - name: ARTER + type: String + width: 254 + - name: NATURTYPER + type: String + width: 254 + sources: + - source: + download: + url: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/SCI_Rikstackande.zip' + max-size: 134217728 # 128MiB + cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'SCI_alvar_AC_lan/SCI_alvar_AC_lan.*' + import: + path: 'SCI_alvar_AC_lan/SCI_alvar_AC_lan.shp' + format: ESRI Shapefile + layername: SCI_alvar_AC_lan + - source: + download: + url: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/SCI_Rikstackande.zip' + max-size: 134217728 # 128MiB + cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'SCI_alvar_BD_lan/SCI_alvar_BD_lan.*' + import: + path: 'SCI_alvar_BD_lan/SCI_alvar_BD_lan.shp' + format: ESRI Shapefile + layername: SCI_alvar_BD_lan + - source: + download: + url: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/SCI_Rikstackande.zip' + max-size: 134217728 # 128MiB + cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'SCI_ej_alvar_rikstackande/SCI_ej_alvar_rikstackande.*' + import: + path: 'SCI_ej_alvar_rikstackande/SCI_ej_alvar_rikstackande.shp' + format: ESRI Shapefile + layername: SCI_ej_alvar_rikstackande + publish: habitatdirektivet 'nvr:HELCOM': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Marina skyddade områden (Helcom MPA) + create: + geometry-type: MULTIPOLYGONZ + fields: + - name: BSPA_ID + type: Integer + unique: true + nullable: false + - name: NAME + type: String + width: 62 + nullable: false source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/HELCOM.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'PS_HELCOM/PS_HELCOM.*' + import: + path: 'PS_HELCOM/PS_HELCOM.shp' + format: ESRI Shapefile + layername: PS_HELCOM + publish: helcom - 'nvr:Ramsar_2018': + 'nvr:Ramsar': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Ramsar-områden (Våtmarkskonventionen) + create: + geometry-type: MULTIPOLYGON + fields: + - name: RAMSAR_ID + type: Integer + unique: true + nullable: false + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: NATION + type: String + width: 32 + nullable: false + - name: NAMN + type: String + width: 32 + unique: true + nullable: false + - name: LAND_HA + # XXX convert to m²? + type: Real + comment: Areal land i hektar (våtmarker ingår i landarealen) + - name: VATTEN_HA + # XXX convert to m²? + type: Real + comment: Areal vatten i hektar (både sötvatten och marint vatten ingår) + - name: SKOG_HA + # XXX convert to m²? + type: Real + comment: Skogsmarksareal i hektar + - name: LINK + type: String + width: 254 + nullable: false + - name: URSPR_BESL + type: Date + nullable: false + - name: SEN_BESLUT + type: Date + - name: LEGAL_ACT + type: String + width: 254 + nullable: false source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Ramsar_2018.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'RAMSAR.*' + import: + path: 'RAMSAR.shp' + format: ESRI Shapefile + layername: RAMSAR + publish: helcom 'nvr:OSPAR': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Marina skyddade områden (Ospar MPA) + create: + geometry-type: MULTIPOLYGONZ + fields: + - name: ORIGIN + type: String + width: 10 + nullable: false + - name: NAMN_N2000 + type: String + width: 64 + unique: true + nullable: false + - name: MPA_ID + type: String + width: 16 + unique: true + nullable: false + - name: MPA_NAMN + type: String + width: 64 + unique: true + nullable: false + - name: N2000_SITE + type: String + width: 16 + unique: true + nullable: false source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/OSPAR.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'PS_OSPAR/PS_OSPAR.*' + import: + path: 'PS_OSPAR/PS_OSPAR.shp' + format: ESRI Shapefile + layername: PS_OSPAR + publish: ospar 'nvr:Varldsarv': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Världsarv med mycket höga naturvärden (UNESCO) + create: + geometry-type: MULTIPOLYGON + fields: + - name: NAMN + type: String + width: 64 + unique: true + nullable: false source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Varldsarv.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'VARLDSARV.*' + import: + path: 'VARLDSARV.shp' + format: ESRI Shapefile + layername: VARLDSARV + publish: varldsarv - 'nvr:biosfarsomraden': + 'nvr:Biosfarsomraden': + # https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/Naturvardsregistret_beskrivning_av_oppna_data.pdf + description: Biosfärsområden (UNESCO) + create: + geometry-type: MULTIPOLYGON + fields: + - name: SKYDDSTYP + type: String + width: 32 + nullable: false + comment: Skyddstyp + - name: NAMN + type: String + width: 32 + unique: true + nullable: false + - name: LINK + type: String + width: 254 + nullable: false source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/biosfarsomraden.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'BIOSFARSOMRADEN.*' + import: + path: 'BIOSFARSOMRADEN.shp' + format: ESRI Shapefile + layername: BIOSFARSOMRADEN + publish: biosfarsomraden - 'nvr:NVA': + 'nva:Naturvardsverket_Lansstyrelse': + # https://geodatakatalogen.naturvardsverket.se/geonetwork/srv/swe/catalog.search#/metadata/3a5790ff-8cd3-45ea-bbee-28cf2c1b6b06 + description: Naturvårdsavtal (Naturvårdsverket, Länsstyrelse) + create: + geometry-type: MULTIPOLYGON + fields: + - name: ID + type: Integer + # XXX how come there is no UNIQUE constraint here? + unique: false + nullable: false + - name: DIARIENRNV + type: String + width: 12 + # XXX how come there is no UNIQUE constraint here? + unique: false + nullable: false + - name: STATUS + type: String + width: 32 + nullable: false + - name: OBJNAMN + type: String + width: 64 + - name: FASTBET + type: String + width: 64 + - name: DATSTART + type: Date + nullable: false + - name: DATSLUT + type: Date + nullable: false source: download: 'https://geodata.naturvardsverket.se/nedladdning/naturvardsregistret/NVA.zip' cache: naturvardsregistret/ + unar: + format: zip + patterns: + - 'NVA.*' + import: + path: 'NVA.shp' + format: ESRI Shapefile + layername: NVA + publish: naturvardsavtal + + 'nva:Skogsstyrelsen': + # https://www.geodata.se/geodataportalen/GetMetaDataById?ID=f56d281c-8246-40aa-83cd-9db0d4389d5a + description: Naturvårdsavtal (Skogsstyrelsen) + create: + geometry-type: MULTIPOLYGON + fields: + - name: Uuid + type: String + subtype: UUID + #width: 36 + unique: true + nullable: false + comment: Unik identitet + - name: Beteckn + type: String + width: 12 + unique: true + nullable: false + comment: Ärendebeteckning + - name: ArendeAr + type: Integer + subtype: Int16 + nullable: false + comment: År anmälan/ansökan registrerades + - name: NvaTyp + type: String + width: 254 + - name: Naturtyp + type: String + width: 254 + - name: AreaTot + type: Real + nullable: false + - name: AreaProd + type: Real + nullable: false + - name: Standort + type: String + width: 254 + - name: DatAvtal + type: Date + nullable: false + - name: Url + type: String + width: 254 + nullable: false + - name: Undertyp + type: String + width: 64 + source: + download: 'https://geodpags.skogsstyrelsen.se/geodataport/data/sksNaturvardsavtal_gpkg.zip' + cache: sks/ + unar: + format: zip + import: + path: 'sksNaturvardsavtal.gpkg' + format: GPKG + layername: NaturvardsavtalYta + value-map: + Standort: + - replace: 'saknas' + with: null + publish: naturvardsavtal_skogsstyrelsen 'sks:AvverkAnm': # https://geodpags.skogsstyrelsen.se/geodataport/feeds/AvverkAnm.xml diff --git a/schema.sql b/schema.sql index 4263765..ce88dae 100644 --- a/schema.sql +++ b/schema.sql @@ -532,38 +532,36 @@ ALTER SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" OWNED BY postgis."mrr: -- --- Name: ren:omr_riks; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nva:Naturvardsverket_Lansstyrelse; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ren:omr_riks" ( +CREATE TABLE postgis."nva:Naturvardsverket_Lansstyrelse" ( ogc_fid bigint NOT NULL, - "LANK" character varying(254) NOT NULL, - "LANSKOD" character varying(25) NOT NULL, - "OMR_NR" integer, - "ARET_RUNT" integer, - "SAMEBY" character varying(62) NOT NULL, - "ANSVARIG" character varying(25) NOT NULL, - "AKTUALITET" date NOT NULL, - "SIGNATUR" character varying(25), - "GlobalID" uuid 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."ren:omr_riks" OWNER TO webmap_import; +ALTER TABLE postgis."nva:Naturvardsverket_Lansstyrelse" OWNER TO webmap_import; -- --- Name: TABLE "ren:omr_riks"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nva:Naturvardsverket_Lansstyrelse"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ren:omr_riks" IS 'Riksintresse Rennäringen — Kärnområde'; +COMMENT ON TABLE postgis."nva:Naturvardsverket_Lansstyrelse" IS 'Naturvårdsavtal (Naturvårdsverket, Länsstyrelse)'; -- --- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" +CREATE SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -571,44 +569,50 @@ CREATE SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ren:omr_riks_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" OWNED BY postgis."ren:omr_riks".ogc_fid; +ALTER SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" OWNED BY postgis."nva:Naturvardsverket_Lansstyrelse".ogc_fid; -- --- Name: ren:riks_ren; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nva:Skogsstyrelsen; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."ren:riks_ren" ( +CREATE TABLE postgis."nva:Skogsstyrelsen" ( ogc_fid bigint NOT NULL, - "LAGRUM" character varying(254) NOT NULL, - "AKTUALITET" date NOT NULL, - "SIGNATUR" character varying(25) NOT NULL, - "LANK" character varying(254), - "GlobalID" uuid 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."ren:riks_ren" OWNER TO webmap_import; +ALTER TABLE postgis."nva:Skogsstyrelsen" OWNER TO webmap_import; -- --- Name: TABLE "ren:riks_ren"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nva:Skogsstyrelsen"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."ren:riks_ren" IS 'Riksintresse Rennäringen'; +COMMENT ON TABLE postgis."nva:Skogsstyrelsen" IS 'Naturvårdsavtal (Skogsstyrelsen)'; -- --- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nva:Skogsstyrelsen_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" +CREATE SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -616,47 +620,42 @@ CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."ren:riks_ren_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nva:Skogsstyrelsen_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nva:Skogsstyrelsen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren".ogc_fid; +ALTER SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" OWNED BY postgis."nva:Skogsstyrelsen".ogc_fid; -- --- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Biosfarsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sametinget:betesomraden" ( +CREATE TABLE postgis."nvr:Biosfarsomraden" ( ogc_fid bigint NOT NULL, - "SAMEBY_ID" integer NOT NULL, - "BY_ID" integer, - "NAMN" character varying(62) NOT NULL, - "SIGNATUR" character varying(25) NOT NULL, - "SAMEBY_TYP" character varying(62) NOT NULL, - "BY_OMR" boolean NOT NULL, - "OVR_OMR" boolean NOT NULL, - "AKTUALITET" date 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."sametinget:betesomraden" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Biosfarsomraden" OWNER TO webmap_import; -- --- Name: TABLE "sametinget:betesomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Biosfarsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sametinget:betesomraden" IS 'Samebyarnas betesområden: Renbetesområden'; +COMMENT ON TABLE postgis."nvr:Biosfarsomraden" IS 'Biosfärsområden (UNESCO)'; -- --- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -664,55 +663,49 @@ CREATE SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sametinget:betesomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Biosfarsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" OWNED BY postgis."sametinget:betesomraden".ogc_fid; +ALTER SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" OWNED BY postgis."nvr:Biosfarsomraden".ogc_fid; -- --- Name: sametinget:flyttled; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Biotopskydd; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sametinget:flyttled" ( +CREATE TABLE postgis."nvr:Biotopskydd" ( ogc_fid bigint NOT NULL, - "LED_ID" integer NOT NULL, - "BYNR1" integer NOT NULL, - "BYNR2" integer NOT NULL, - "BYNR3" integer NOT NULL, - "SAMEBY1" character varying(62), - "SAMEBY2" character varying(62), - "SAMEBY3" character varying(62), - "KKOD" integer NOT NULL, - "BESKRIVNIN" character varying(62), - "ARSTID" character varying(62), - "KONV_AR" character varying(62), - "SIGNATUR" character varying(25), - "RIKSINTR" boolean NOT NULL, - "FAST_LED" boolean NOT NULL, - "AKTUALITET" character varying(10), - "GlobalID" uuid NOT NULL, - wkb_geometry postgis.geometry(MultiLineString,3006) + "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."sametinget:flyttled" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Biotopskydd" OWNER TO webmap_import; -- --- Name: TABLE "sametinget:flyttled"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Biotopskydd"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sametinget:flyttled" IS 'Samebyarnas markanvändningsredovisning: Flyttled'; +COMMENT ON TABLE postgis."nvr:Biotopskydd" IS 'Biotopskydd i skogsmark (beslutade av Skogsstyrelsen)'; -- --- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -720,53 +713,56 @@ CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sametinget:flyttled_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Biotopskydd_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" OWNED BY postgis."sametinget:flyttled".ogc_fid; +ALTER SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" OWNED BY postgis."nvr:Biotopskydd".ogc_fid; -- --- Name: sks:AvverkAnm; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Djur_och_vaxtskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sks:AvverkAnm" ( +CREATE TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" ( ogc_fid bigint NOT NULL, - "OBJECTID" integer NOT NULL, - "Beteckn" character(12) NOT NULL, - "ArendeAr" smallint NOT NULL, - "Avverktyp" character varying(254) NOT NULL, - "Andamal" character varying(62) NOT NULL, - "Skogstyp" character varying(254) NOT NULL, - "Inkomdatum" date NOT NULL, - "AnmaldHa" real NOT NULL, - "SkogsodlHa" real NOT NULL, - "NatforHa" real NOT NULL, - "ArendeStatus" character varying(254) NOT NULL, - "AvvSasong" character varying(254) NOT NULL, - "AvvHa" real, - "AvverkningsanmalanKlass" character varying(254) 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."sks:AvverkAnm" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" OWNER TO webmap_import; -- --- Name: TABLE "sks:AvverkAnm"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Djur_och_vaxtskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sks:AvverkAnm" IS 'Avverkningsanmälningar (Skogsstyrelsen)'; +COMMENT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" IS 'Djur- och växtskyddsområden'; -- --- Name: sks:AvverkAnm_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -774,53 +770,41 @@ CREATE SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:AvverkAnm_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sks:AvverkAnm_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" OWNED BY postgis."sks:AvverkAnm".ogc_fid; +ALTER SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Djur_och_vaxtskyddsomrade".ogc_fid; -- --- Name: sks:UtfordAvverk; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:HELCOM; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."sks:UtfordAvverk" ( +CREATE TABLE postgis."nvr:HELCOM" ( ogc_fid bigint NOT NULL, - "OBJECTID" integer NOT NULL, - "Beteckn" character(12), - "ArendeAr" smallint NOT NULL, - "Avverktyp" character varying(254) NOT NULL, - "Skogstyp" character varying(254) NOT NULL, - "AnmaldHa" real NOT NULL, - "SkogsodlHa" real NOT NULL, - "NatforHa" real NOT NULL, - "Avvdatum" date NOT NULL, - "KallaDatum" date, - "KallaAreal" character varying(62), - "Forebild" character varying(62), - "Efterbild" character varying(62), - "ArealHa" real NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) + "BSPA_ID" integer NOT NULL, + "NAME" character varying(62) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygonZ,3006) ); -ALTER TABLE postgis."sks:UtfordAvverk" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:HELCOM" OWNER TO webmap_import; -- --- Name: TABLE "sks:UtfordAvverk"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:HELCOM"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."sks:UtfordAvverk" IS 'Utförd avverkning (Skogsstyrelsen)'; +COMMENT ON TABLE postgis."nvr:HELCOM" IS 'Marina skyddade områden (Helcom MPA)'; -- --- Name: sks:UtfordAvverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:HELCOM_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -828,72 +812,56 @@ CREATE SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:HELCOM_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: sks:UtfordAvverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:HELCOM_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNED BY postgis."sks:UtfordAvverk".ogc_fid; +ALTER SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" OWNED BY postgis."nvr:HELCOM".ogc_fid; -- --- Name: vbk:havsbaserad_vindkraft; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Interimistiskt_forbud; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."vbk:havsbaserad_vindkraft" ( +CREATE TABLE postgis."nvr:Interimistiskt_forbud" ( ogc_fid bigint NOT NULL, - "OmrID" character(10) NOT NULL, - "Projektnamn" character varying(62), - "Organisationsnamn" character varying(254), - "Organisationsnummer" character(11), - "Projektstatus" character varying(62) NOT NULL, - "Diarienummer" character varying(254), - "AndringsansokanPagar" boolean, - "SamradsunderlagInlamnat" date, - "AnsokanInlamnat" date, - "AnsokanAterkallad" date, - "AnsokanBeviljad" date, - "AnsokanAvslagen" date, - "AnsokanOverklagad" date, - "Natura2000_Ansokan" character varying(62) NOT NULL, - "Natura2000_Beslutdatum" date, - "UnderByggnation" boolean, - "Uppfort" date, - "PlaneratAntalVerkMin" smallint, - "PlaneratAntalVerkMax" smallint, - "PlaneradHojdMin" smallint, - "PlaneradHojdMax" smallint, - "PlaneradProduktionMin" real, - "PlaneradProduktionMax" real, - "PlaneradByggstart" date, - "PlaneratDrift" date, - "BeviljatAntalVerk" smallint, - "UppfortAntalVerk" smallint, - "BeviljadMaxhojd" smallint, - "InstalleradEffekt" real, - "Calprod" real, - "ElNamn" character varying(62) NOT NULL, - "SenasteUppdaterat" date NOT NULL, - "Raderat" boolean 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."vbk:havsbaserad_vindkraft" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Interimistiskt_forbud" OWNER TO webmap_import; -- --- Name: TABLE "vbk:havsbaserad_vindkraft"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Interimistiskt_forbud"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."vbk:havsbaserad_vindkraft" IS 'Vindbrukskollen havsbaserad vindkraft (Länsstyrelsen)'; +COMMENT ON TABLE postgis."nvr:Interimistiskt_forbud" IS 'Interimistiska förbud'; -- --- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -901,54 +869,56 @@ CREATE SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Interimistiskt_forbud_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNED BY postgis."vbk:havsbaserad_vindkraft".ogc_fid; +ALTER SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" OWNED BY postgis."nvr:Interimistiskt_forbud".ogc_fid; -- --- Name: vbk:projekteringsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Kultureservat; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."vbk:projekteringsomraden" ( +CREATE TABLE postgis."nvr:Kultureservat" ( ogc_fid bigint NOT NULL, - "OmrID" character(10) NOT NULL, - "Projektnamn" character varying(62), - "AntalVerk" smallint NOT NULL, - "AntalEjXY" smallint NOT NULL, - "Calprod" real, - "PlaneradByggstart" date, - "PlaneratDrift" date, - "AndringsansokanPagar" boolean, - "UnderByggnation" boolean, - "Organisationsnamn" character varying(254), - "Organisationsnummer" character(11), - "ElNamn" character varying(62) NOT NULL, - "SenasteUppdaterat" date, - "EjAktuell" boolean NOT NULL, - "Raderat" boolean 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."vbk:projekteringsomraden" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Kultureservat" OWNER TO webmap_import; -- --- Name: TABLE "vbk:projekteringsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Kultureservat"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."vbk:projekteringsomraden" IS 'Vindbrukskollen landbaserade projekteringsområden (Länsstyrelsen)'; +COMMENT ON TABLE postgis."nvr:Kultureservat" IS 'Kulturreservat'; -- --- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -956,61 +926,56 @@ CREATE SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Kultureservat_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Kultureservat_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNED BY postgis."vbk:projekteringsomraden".ogc_fid; +ALTER SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" OWNED BY postgis."nvr:Kultureservat".ogc_fid; -- --- Name: vbk:vindkraftverk; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Landskapsbildsskyddsomrade; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."vbk:vindkraftverk" ( +CREATE TABLE postgis."nvr:Landskapsbildsskyddsomrade" ( ogc_fid bigint NOT NULL, - "VerkID" character(14) NOT NULL, - "OmrID" character(10) NOT NULL, - "Projektnamn" character varying(62), - "Status" character varying(62) NOT NULL, - "Statuskod" smallint NOT NULL, - "Handlingstyp" character varying(62), - "Uppfort" date, - "MB_Tillstand" date, - "Totalhojd" smallint, - "Navhojd" smallint, - "Rotordiameter" smallint, - "Maxeffekt" real, - "Calprod" real, - "Fabrikat" character varying(62), - "Modell" character varying(62), - "Organisationsnamn" character varying(254), - "Organisationsnummer" character(11), - "Placering" character varying(62), - "ElNamn" character varying(62) NOT NULL, - "SenasteUppdaterat" date, - "EjAktuell" boolean, - "Raderat" boolean NOT NULL, - wkb_geometry postgis.geometry(Point,3006) + "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."vbk:vindkraftverk" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade" OWNER TO webmap_import; -- --- Name: TABLE "vbk:vindkraftverk"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Landskapsbildsskyddsomrade"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."vbk:vindkraftverk" IS 'Vindbrukskollen landbaserade vindkraftverk (Länsstyrelsen)'; +COMMENT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" IS 'Landskapsbildsskyddsområden'; -- --- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1018,849 +983,3019 @@ CREATE SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Landskapsbildsskyddsomrade_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNED BY postgis."vbk:vindkraftverk".ogc_fid; +ALTER SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" OWNED BY postgis."nvr:Landskapsbildsskyddsomrade".ogc_fid; -- --- Name: kommunyta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: nvr:Nationalpark; Type: TABLE; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.kommunyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.kommunyta_ogc_fid_seq'::regclass); +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: lansyta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Nationalpark"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.lansyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.lansyta_ogc_fid_seq'::regclass); +COMMENT ON TABLE postgis."nvr:Nationalpark" IS 'Nationalparker'; -- --- Name: mrr:bearbetningskoncessioner_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: nvr:Nationalpark_ogc_fid_seq; Type: SEQUENCE; 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); +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: mrr:bearbetningskoncessioner_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: 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 +-- + +CREATE TABLE postgis."ren:omr_riks" ( + ogc_fid bigint NOT NULL, + "LANK" character varying(254) NOT NULL, + "LANSKOD" character varying(25) NOT NULL, + "OMR_NR" integer, + "ARET_RUNT" integer, + "SAMEBY" character varying(62) NOT NULL, + "ANSVARIG" character varying(25) NOT NULL, + "AKTUALITET" date NOT NULL, + "SIGNATUR" character varying(25), + "GlobalID" uuid NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."ren:omr_riks" OWNER TO webmap_import; + +-- +-- Name: TABLE "ren:omr_riks"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."ren:omr_riks" IS 'Riksintresse Rennäringen — Kärnområde'; + + +-- +-- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."ren:omr_riks_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: ren:omr_riks_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."ren:omr_riks_ogc_fid_seq" OWNED BY postgis."ren:omr_riks".ogc_fid; + + +-- +-- Name: ren:riks_ren; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."ren:riks_ren" ( + ogc_fid bigint NOT NULL, + "LAGRUM" character varying(254) NOT NULL, + "AKTUALITET" date NOT NULL, + "SIGNATUR" character varying(25) NOT NULL, + "LANK" character varying(254), + "GlobalID" uuid NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."ren:riks_ren" OWNER TO webmap_import; + +-- +-- Name: TABLE "ren:riks_ren"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."ren:riks_ren" IS 'Riksintresse Rennäringen'; + + +-- +-- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."ren:riks_ren_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: ren:riks_ren_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."ren:riks_ren_ogc_fid_seq" OWNED BY postgis."ren:riks_ren".ogc_fid; + + +-- +-- Name: sametinget:betesomraden; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."sametinget:betesomraden" ( + ogc_fid bigint NOT NULL, + "SAMEBY_ID" integer NOT NULL, + "BY_ID" integer, + "NAMN" character varying(62) NOT NULL, + "SIGNATUR" character varying(25) NOT NULL, + "SAMEBY_TYP" character varying(62) NOT NULL, + "BY_OMR" boolean NOT NULL, + "OVR_OMR" boolean NOT NULL, + "AKTUALITET" date NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."sametinget:betesomraden" OWNER TO webmap_import; + +-- +-- Name: TABLE "sametinget:betesomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."sametinget:betesomraden" IS 'Samebyarnas betesområden: Renbetesområden'; + + +-- +-- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."sametinget:betesomraden_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: sametinget:betesomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."sametinget:betesomraden_ogc_fid_seq" OWNED BY postgis."sametinget:betesomraden".ogc_fid; + + +-- +-- Name: sametinget:flyttled; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."sametinget:flyttled" ( + ogc_fid bigint NOT NULL, + "LED_ID" integer NOT NULL, + "BYNR1" integer NOT NULL, + "BYNR2" integer NOT NULL, + "BYNR3" integer NOT NULL, + "SAMEBY1" character varying(62), + "SAMEBY2" character varying(62), + "SAMEBY3" character varying(62), + "KKOD" integer NOT NULL, + "BESKRIVNIN" character varying(62), + "ARSTID" character varying(62), + "KONV_AR" character varying(62), + "SIGNATUR" character varying(25), + "RIKSINTR" boolean NOT NULL, + "FAST_LED" boolean NOT NULL, + "AKTUALITET" character varying(10), + "GlobalID" uuid NOT NULL, + wkb_geometry postgis.geometry(MultiLineString,3006) +); + + +ALTER TABLE postgis."sametinget:flyttled" OWNER TO webmap_import; + +-- +-- Name: TABLE "sametinget:flyttled"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."sametinget:flyttled" IS 'Samebyarnas markanvändningsredovisning: Flyttled'; + + +-- +-- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."sametinget:flyttled_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: sametinget:flyttled_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."sametinget:flyttled_ogc_fid_seq" OWNED BY postgis."sametinget:flyttled".ogc_fid; + + +-- +-- Name: sks:AvverkAnm; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."sks:AvverkAnm" ( + ogc_fid bigint NOT NULL, + "OBJECTID" integer NOT NULL, + "Beteckn" character(12) NOT NULL, + "ArendeAr" smallint NOT NULL, + "Avverktyp" character varying(254) NOT NULL, + "Andamal" character varying(62) NOT NULL, + "Skogstyp" character varying(254) NOT NULL, + "Inkomdatum" date NOT NULL, + "AnmaldHa" real NOT NULL, + "SkogsodlHa" real NOT NULL, + "NatforHa" real NOT NULL, + "ArendeStatus" character varying(254) NOT NULL, + "AvvSasong" character varying(254) NOT NULL, + "AvvHa" real, + "AvverkningsanmalanKlass" character varying(254) NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."sks:AvverkAnm" OWNER TO webmap_import; + +-- +-- Name: TABLE "sks:AvverkAnm"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."sks:AvverkAnm" IS 'Avverkningsanmälningar (Skogsstyrelsen)'; + + +-- +-- Name: sks:AvverkAnm_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."sks:AvverkAnm_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: sks:AvverkAnm_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."sks:AvverkAnm_ogc_fid_seq" OWNED BY postgis."sks:AvverkAnm".ogc_fid; + + +-- +-- Name: sks:UtfordAvverk; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."sks:UtfordAvverk" ( + ogc_fid bigint NOT NULL, + "OBJECTID" integer NOT NULL, + "Beteckn" character(12), + "ArendeAr" smallint NOT NULL, + "Avverktyp" character varying(254) NOT NULL, + "Skogstyp" character varying(254) NOT NULL, + "AnmaldHa" real NOT NULL, + "SkogsodlHa" real NOT NULL, + "NatforHa" real NOT NULL, + "Avvdatum" date NOT NULL, + "KallaDatum" date, + "KallaAreal" character varying(62), + "Forebild" character varying(62), + "Efterbild" character varying(62), + "ArealHa" real NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."sks:UtfordAvverk" OWNER TO webmap_import; + +-- +-- Name: TABLE "sks:UtfordAvverk"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."sks:UtfordAvverk" IS 'Utförd avverkning (Skogsstyrelsen)'; + + +-- +-- Name: sks:UtfordAvverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: sks:UtfordAvverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."sks:UtfordAvverk_ogc_fid_seq" OWNED BY postgis."sks:UtfordAvverk".ogc_fid; + + +-- +-- Name: vbk:havsbaserad_vindkraft; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."vbk:havsbaserad_vindkraft" ( + ogc_fid bigint NOT NULL, + "OmrID" character(10) NOT NULL, + "Projektnamn" character varying(62), + "Organisationsnamn" character varying(254), + "Organisationsnummer" character(11), + "Projektstatus" character varying(62) NOT NULL, + "Diarienummer" character varying(254), + "AndringsansokanPagar" boolean, + "SamradsunderlagInlamnat" date, + "AnsokanInlamnat" date, + "AnsokanAterkallad" date, + "AnsokanBeviljad" date, + "AnsokanAvslagen" date, + "AnsokanOverklagad" date, + "Natura2000_Ansokan" character varying(62) NOT NULL, + "Natura2000_Beslutdatum" date, + "UnderByggnation" boolean, + "Uppfort" date, + "PlaneratAntalVerkMin" smallint, + "PlaneratAntalVerkMax" smallint, + "PlaneradHojdMin" smallint, + "PlaneradHojdMax" smallint, + "PlaneradProduktionMin" real, + "PlaneradProduktionMax" real, + "PlaneradByggstart" date, + "PlaneratDrift" date, + "BeviljatAntalVerk" smallint, + "UppfortAntalVerk" smallint, + "BeviljadMaxhojd" smallint, + "InstalleradEffekt" real, + "Calprod" real, + "ElNamn" character varying(62) NOT NULL, + "SenasteUppdaterat" date NOT NULL, + "Raderat" boolean NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."vbk:havsbaserad_vindkraft" OWNER TO webmap_import; + +-- +-- Name: TABLE "vbk:havsbaserad_vindkraft"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."vbk:havsbaserad_vindkraft" IS 'Vindbrukskollen havsbaserad vindkraft (Länsstyrelsen)'; + + +-- +-- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: vbk:havsbaserad_vindkraft_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq" OWNED BY postgis."vbk:havsbaserad_vindkraft".ogc_fid; + + +-- +-- Name: vbk:projekteringsomraden; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."vbk:projekteringsomraden" ( + ogc_fid bigint NOT NULL, + "OmrID" character(10) NOT NULL, + "Projektnamn" character varying(62), + "AntalVerk" smallint NOT NULL, + "AntalEjXY" smallint NOT NULL, + "Calprod" real, + "PlaneradByggstart" date, + "PlaneratDrift" date, + "AndringsansokanPagar" boolean, + "UnderByggnation" boolean, + "Organisationsnamn" character varying(254), + "Organisationsnummer" character(11), + "ElNamn" character varying(62) NOT NULL, + "SenasteUppdaterat" date, + "EjAktuell" boolean NOT NULL, + "Raderat" boolean NOT NULL, + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis."vbk:projekteringsomraden" OWNER TO webmap_import; + +-- +-- Name: TABLE "vbk:projekteringsomraden"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."vbk:projekteringsomraden" IS 'Vindbrukskollen landbaserade projekteringsområden (Länsstyrelsen)'; + + +-- +-- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: vbk:projekteringsomraden_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."vbk:projekteringsomraden_ogc_fid_seq" OWNED BY postgis."vbk:projekteringsomraden".ogc_fid; + + +-- +-- Name: vbk:vindkraftverk; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis."vbk:vindkraftverk" ( + ogc_fid bigint NOT NULL, + "VerkID" character(14) NOT NULL, + "OmrID" character(10) NOT NULL, + "Projektnamn" character varying(62), + "Status" character varying(62) NOT NULL, + "Statuskod" smallint NOT NULL, + "Handlingstyp" character varying(62), + "Uppfort" date, + "MB_Tillstand" date, + "Totalhojd" smallint, + "Navhojd" smallint, + "Rotordiameter" smallint, + "Maxeffekt" real, + "Calprod" real, + "Fabrikat" character varying(62), + "Modell" character varying(62), + "Organisationsnamn" character varying(254), + "Organisationsnummer" character(11), + "Placering" character varying(62), + "ElNamn" character varying(62) NOT NULL, + "SenasteUppdaterat" date, + "EjAktuell" boolean, + "Raderat" boolean NOT NULL, + wkb_geometry postgis.geometry(Point,3006) +); + + +ALTER TABLE postgis."vbk:vindkraftverk" OWNER TO webmap_import; + +-- +-- Name: TABLE "vbk:vindkraftverk"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis."vbk:vindkraftverk" IS 'Vindbrukskollen landbaserade vindkraftverk (Länsstyrelsen)'; + + +-- +-- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNER TO webmap_import; + +-- +-- Name: vbk:vindkraftverk_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNED BY postgis."vbk:vindkraftverk".ogc_fid; + + +-- +-- Name: kommunyta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.kommunyta ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.kommunyta_ogc_fid_seq'::regclass); + + +-- +-- Name: lansyta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +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 +-- 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: 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 +-- + +ALTER TABLE ONLY postgis."ren:omr_riks" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:omr_riks_ogc_fid_seq"'::regclass); + + +-- +-- Name: ren:riks_ren ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."ren:riks_ren" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:riks_ren_ogc_fid_seq"'::regclass); + + +-- +-- Name: sametinget:betesomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sametinget:betesomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:betesomraden_ogc_fid_seq"'::regclass); + + +-- +-- Name: sametinget:flyttled ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sametinget:flyttled" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:flyttled_ogc_fid_seq"'::regclass); + + +-- +-- Name: sks:AvverkAnm ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sks:AvverkAnm" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:AvverkAnm_ogc_fid_seq"'::regclass); + + +-- +-- Name: sks:UtfordAvverk ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sks:UtfordAvverk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:UtfordAvverk_ogc_fid_seq"'::regclass); + + +-- +-- Name: vbk:havsbaserad_vindkraft ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."vbk:havsbaserad_vindkraft" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq"'::regclass); + + +-- +-- Name: vbk:projekteringsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."vbk:projekteringsomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."vbk:projekteringsomraden_ogc_fid_seq"'::regclass); + + +-- +-- Name: vbk:vindkraftverk ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."vbk:vindkraftverk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."vbk:vindkraftverk_ogc_fid_seq"'::regclass); + + +-- +-- Name: kommunyta kommunyta_kommunkod_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.kommunyta + ADD CONSTRAINT kommunyta_kommunkod_key UNIQUE (kommunkod); + + +-- +-- Name: kommunyta kommunyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.kommunyta + ADD CONSTRAINT kommunyta_objektidentitet_key UNIQUE (objektidentitet); + + +-- +-- Name: kommunyta kommunyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.kommunyta + ADD CONSTRAINT kommunyta_pkey PRIMARY KEY (ogc_fid); + + +-- +-- Name: lansyta lansyta_lanskod_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.lansyta + ADD CONSTRAINT lansyta_lanskod_key UNIQUE (lanskod); + + +-- +-- Name: lansyta lansyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.lansyta + ADD CONSTRAINT lansyta_objektidentitet_key UNIQUE (objektidentitet); + + +-- +-- Name: lansyta lansyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +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_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" + ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_DiaryNr_key" UNIQUE ("DiaryNr"); + + +-- +-- 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_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:markanvisningar" + ADD CONSTRAINT "mrr:markanvisningar_DiaryNr_key" UNIQUE ("DiaryNr"); + + +-- +-- 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_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:mineral_approved" + ADD CONSTRAINT "mrr:mineral_approved_DiaryNr_key" UNIQUE ("DiaryNr"); + + +-- +-- 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_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" + ADD CONSTRAINT "mrr:olja_gas_diamant_approved_DiaryNr_key" UNIQUE ("DiaryNr"); + + +-- +-- 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_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."mrr:torvkoncessioner" + ADD CONSTRAINT "mrr:torvkoncessioner_DiaryNr_key" UNIQUE ("DiaryNr"); + + +-- +-- 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: 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 +-- + +ALTER TABLE ONLY postgis."ren:omr_riks" + ADD CONSTRAINT "ren:omr_riks_GlobalID_key" UNIQUE ("GlobalID"); + + +-- +-- Name: ren:omr_riks ren:omr_riks_pkey; Type: CONSTRAINT; 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); +ALTER TABLE ONLY postgis."ren:omr_riks" + ADD CONSTRAINT "ren:omr_riks_pkey" PRIMARY KEY (ogc_fid); -- --- Name: mrr:mineral_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: ren:riks_ren ren:riks_ren_GlobalID_key; Type: CONSTRAINT; 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); +ALTER TABLE ONLY postgis."ren:riks_ren" + ADD CONSTRAINT "ren:riks_ren_GlobalID_key" UNIQUE ("GlobalID"); -- --- Name: mrr:mineral_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: ren:riks_ren ren:riks_ren_pkey; Type: CONSTRAINT; 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); +ALTER TABLE ONLY postgis."ren:riks_ren" + ADD CONSTRAINT "ren:riks_ren_pkey" PRIMARY KEY (ogc_fid); -- --- Name: mrr:olja_gas_diamant_applied ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomraden sametinget:betesomraden_SAMEBY_ID_key; Type: CONSTRAINT; 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); +ALTER TABLE ONLY postgis."sametinget:betesomraden" + ADD CONSTRAINT "sametinget:betesomraden_SAMEBY_ID_key" UNIQUE ("SAMEBY_ID"); -- --- Name: mrr:olja_gas_diamant_approved ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomraden sametinget:betesomraden_pkey; Type: CONSTRAINT; 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); +ALTER TABLE ONLY postgis."sametinget:betesomraden" + ADD CONSTRAINT "sametinget:betesomraden_pkey" PRIMARY KEY (ogc_fid); -- --- Name: mrr:torvkoncessioner ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled sametinget:flyttled_GlobalID_key; Type: CONSTRAINT; 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); +ALTER TABLE ONLY postgis."sametinget:flyttled" + ADD CONSTRAINT "sametinget:flyttled_GlobalID_key" UNIQUE ("GlobalID"); -- --- Name: ren:omr_riks ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled sametinget:flyttled_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:omr_riks" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:omr_riks_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sametinget:flyttled" + ADD CONSTRAINT "sametinget:flyttled_pkey" PRIMARY KEY (ogc_fid); -- --- Name: ren:riks_ren ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:AvverkAnm sks:AvverkAnm_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:riks_ren" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."ren:riks_ren_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:AvverkAnm" + ADD CONSTRAINT "sks:AvverkAnm_Beteckn_key" UNIQUE ("Beteckn"); -- --- Name: sametinget:betesomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:AvverkAnm sks:AvverkAnm_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:betesomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:betesomraden_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:AvverkAnm" + ADD CONSTRAINT "sks:AvverkAnm_OBJECTID_key" UNIQUE ("OBJECTID"); -- --- Name: sametinget:flyttled ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:AvverkAnm sks:AvverkAnm_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:flyttled" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sametinget:flyttled_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:AvverkAnm" + ADD CONSTRAINT "sks:AvverkAnm_pkey" PRIMARY KEY (ogc_fid); -- --- Name: sks:AvverkAnm ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:UtfordAvverk sks:UtfordAvverk_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:AvverkAnm" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:AvverkAnm_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:UtfordAvverk" + ADD CONSTRAINT "sks:UtfordAvverk_Beteckn_key" UNIQUE ("Beteckn"); -- --- Name: sks:UtfordAvverk ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:UtfordAvverk sks:UtfordAvverk_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:UtfordAvverk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."sks:UtfordAvverk_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:UtfordAvverk" + ADD CONSTRAINT "sks:UtfordAvverk_OBJECTID_key" UNIQUE ("OBJECTID"); -- --- Name: vbk:havsbaserad_vindkraft ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: sks:UtfordAvverk sks:UtfordAvverk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."vbk:havsbaserad_vindkraft" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."vbk:havsbaserad_vindkraft_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."sks:UtfordAvverk" + ADD CONSTRAINT "sks:UtfordAvverk_pkey" PRIMARY KEY (ogc_fid); -- --- Name: vbk:projekteringsomraden ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: vbk:havsbaserad_vindkraft vbk:havsbaserad_vindkraft_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."vbk:projekteringsomraden" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."vbk:projekteringsomraden_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."vbk:havsbaserad_vindkraft" + ADD CONSTRAINT "vbk:havsbaserad_vindkraft_pkey" PRIMARY KEY (ogc_fid); -- --- Name: vbk:vindkraftverk ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: vbk:projekteringsomraden vbk:projekteringsomraden_OmrID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."vbk:vindkraftverk" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."vbk:vindkraftverk_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."vbk:projekteringsomraden" + ADD CONSTRAINT "vbk:projekteringsomraden_OmrID_key" UNIQUE ("OmrID"); -- --- Name: kommunyta kommunyta_kommunkod_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: vbk:projekteringsomraden vbk:projekteringsomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.kommunyta - ADD CONSTRAINT kommunyta_kommunkod_key UNIQUE (kommunkod); +ALTER TABLE ONLY postgis."vbk:projekteringsomraden" + ADD CONSTRAINT "vbk:projekteringsomraden_pkey" PRIMARY KEY (ogc_fid); -- --- Name: kommunyta kommunyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: vbk:vindkraftverk vbk:vindkraftverk_VerkID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.kommunyta - ADD CONSTRAINT kommunyta_objektidentitet_key UNIQUE (objektidentitet); +ALTER TABLE ONLY postgis."vbk:vindkraftverk" + ADD CONSTRAINT "vbk:vindkraftverk_VerkID_key" UNIQUE ("VerkID"); -- --- Name: kommunyta kommunyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: vbk:vindkraftverk vbk:vindkraftverk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.kommunyta - ADD CONSTRAINT kommunyta_pkey PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."vbk:vindkraftverk" + ADD CONSTRAINT "vbk:vindkraftverk_pkey" PRIMARY KEY (ogc_fid); -- --- Name: lansyta lansyta_lanskod_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: kommunyta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.lansyta - ADD CONSTRAINT lansyta_lanskod_key UNIQUE (lanskod); +CREATE INDEX kommunyta_wkb_geometry_geom_idx ON postgis.kommunyta USING gist (wkb_geometry); -- --- Name: lansyta lansyta_objektidentitet_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: lansyta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.lansyta - ADD CONSTRAINT lansyta_objektidentitet_key UNIQUE (objektidentitet); +CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_geometry); -- --- Name: lansyta lansyta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: mrr:bearbetningskoncessioner_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis.lansyta - ADD CONSTRAINT lansyta_pkey PRIMARY KEY (ogc_fid); +CREATE INDEX "mrr:bearbetningskoncessioner_applied_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_applied" USING gist (wkb_geometry); -- --- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" - ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_DiaryNr_key" UNIQUE ("DiaryNr"); +CREATE INDEX "mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_approved" USING gist (wkb_geometry); -- --- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: mrr:markanvisningar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" - ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_Name_key" UNIQUE ("Name"); +CREATE INDEX "mrr:markanvisningar_wkb_geometry_geom_idx" ON postgis."mrr:markanvisningar" USING gist (wkb_geometry); -- --- Name: mrr:bearbetningskoncessioner_applied mrr:bearbetningskoncessioner_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: mrr:mineral_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" - ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_pkey" PRIMARY KEY (ogc_fid); +CREATE INDEX "mrr:mineral_applied_wkb_geometry_geom_idx" ON postgis."mrr:mineral_applied" USING gist (wkb_geometry); -- --- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: mrr:mineral_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" - ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_DiaryNr_key" UNIQUE ("DiaryNr"); +CREATE INDEX "mrr:mineral_approved_wkb_geometry_geom_idx" ON postgis."mrr:mineral_approved" USING gist (wkb_geometry); -- --- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: mrr:olja_gas_diamant_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" - ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_Name_key" UNIQUE ("Name"); +CREATE INDEX "mrr:olja_gas_diamant_applied_wkb_geometry_geom_idx" ON postgis."mrr:olja_gas_diamant_applied" USING gist (wkb_geometry); -- --- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: mrr:olja_gas_diamant_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" - ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_pkey" PRIMARY KEY (ogc_fid); +CREATE INDEX "mrr:olja_gas_diamant_approved_wkb_geometry_geom_idx" ON postgis."mrr:olja_gas_diamant_approved" USING gist (wkb_geometry); -- --- Name: mrr:markanvisningar mrr:markanvisningar_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: mrr:torvkoncessioner_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:markanvisningar" - ADD CONSTRAINT "mrr:markanvisningar_DiaryNr_key" UNIQUE ("DiaryNr"); +CREATE INDEX "mrr:torvkoncessioner_wkb_geometry_geom_idx" ON postgis."mrr:torvkoncessioner" USING gist (wkb_geometry); -- --- Name: mrr:markanvisningar mrr:markanvisningar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nva:Naturvardsverket_Lansstyrelse_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:markanvisningar" - ADD CONSTRAINT "mrr:markanvisningar_pkey" PRIMARY KEY (ogc_fid); +CREATE INDEX "nva:Naturvardsverket_Lansstyrelse_wkb_geometry_geom_idx" ON postgis."nva:Naturvardsverket_Lansstyrelse" USING gist (wkb_geometry); -- --- Name: mrr:mineral_applied mrr:mineral_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nva:Skogsstyrelsen_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:mineral_applied" - ADD CONSTRAINT "mrr:mineral_applied_DiaryNr_key" UNIQUE ("DiaryNr"); +CREATE INDEX "nva:Skogsstyrelsen_wkb_geometry_geom_idx" ON postgis."nva:Skogsstyrelsen" USING gist (wkb_geometry); -- --- Name: mrr:mineral_applied mrr:mineral_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nvr:Biosfarsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:mineral_applied" - ADD CONSTRAINT "mrr:mineral_applied_Name_key" UNIQUE ("Name"); +CREATE INDEX "nvr:Biosfarsomraden_wkb_geometry_geom_idx" ON postgis."nvr:Biosfarsomraden" USING gist (wkb_geometry); -- --- Name: mrr:mineral_applied mrr:mineral_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- 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 -- -ALTER TABLE ONLY postgis."mrr:mineral_applied" - ADD CONSTRAINT "mrr:mineral_applied_pkey" PRIMARY KEY (ogc_fid); +CREATE INDEX "ren:omr_riks_wkb_geometry_geom_idx" ON postgis."ren:omr_riks" USING gist (wkb_geometry); -- --- Name: mrr:mineral_approved mrr:mineral_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: ren:riks_ren_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:mineral_approved" - ADD CONSTRAINT "mrr:mineral_approved_DiaryNr_key" UNIQUE ("DiaryNr"); +CREATE INDEX "ren:riks_ren_wkb_geometry_geom_idx" ON postgis."ren:riks_ren" USING gist (wkb_geometry); -- --- Name: mrr:mineral_approved mrr:mineral_approved_LicenceID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:betesomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:mineral_approved" - ADD CONSTRAINT "mrr:mineral_approved_LicenceID_key" UNIQUE ("LicenceID"); +CREATE INDEX "sametinget:betesomraden_wkb_geometry_geom_idx" ON postgis."sametinget:betesomraden" USING gist (wkb_geometry); -- --- Name: mrr:mineral_approved mrr:mineral_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sametinget:flyttled_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:mineral_approved" - ADD CONSTRAINT "mrr:mineral_approved_Name_key" UNIQUE ("Name"); +CREATE INDEX "sametinget:flyttled_wkb_geometry_geom_idx" ON postgis."sametinget:flyttled" USING gist (wkb_geometry); -- --- Name: mrr:mineral_approved mrr:mineral_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:AvverkAnm_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:mineral_approved" - ADD CONSTRAINT "mrr:mineral_approved_pkey" PRIMARY KEY (ogc_fid); +CREATE INDEX "sks:AvverkAnm_wkb_geometry_geom_idx" ON postgis."sks:AvverkAnm" USING gist (wkb_geometry); -- --- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: sks:UtfordAvverk_wkb_geometry_geom_idx; Type: INDEX; 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"); +CREATE INDEX "sks:UtfordAvverk_wkb_geometry_geom_idx" ON postgis."sks:UtfordAvverk" USING gist (wkb_geometry); -- --- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: vbk:havsbaserad_vindkraft_wkb_geometry_geom_idx; Type: INDEX; 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"); +CREATE INDEX "vbk:havsbaserad_vindkraft_wkb_geometry_geom_idx" ON postgis."vbk:havsbaserad_vindkraft" USING gist (wkb_geometry); -- --- Name: mrr:olja_gas_diamant_applied mrr:olja_gas_diamant_applied_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: vbk:projekteringsomraden_wkb_geometry_geom_idx; Type: INDEX; 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); +CREATE INDEX "vbk:projekteringsomraden_wkb_geometry_geom_idx" ON postgis."vbk:projekteringsomraden" USING gist (wkb_geometry); -- --- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: vbk:vindkraftverk_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" - ADD CONSTRAINT "mrr:olja_gas_diamant_approved_DiaryNr_key" UNIQUE ("DiaryNr"); +CREATE INDEX "vbk:vindkraftverk_wkb_geometry_geom_idx" ON postgis."vbk:vindkraftverk" USING gist (wkb_geometry); -- --- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_LicenceID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: DATABASE webmap; Type: ACL; Schema: -; Owner: postgres -- -ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" - ADD CONSTRAINT "mrr:olja_gas_diamant_approved_LicenceID_key" UNIQUE ("LicenceID"); +GRANT CONNECT ON DATABASE webmap TO webmap_import; +GRANT CONNECT ON DATABASE webmap TO webmap_guest; -- --- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SCHEMA postgis; Type: ACL; Schema: -; Owner: postgres -- -ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" - ADD CONSTRAINT "mrr:olja_gas_diamant_approved_Name_key" UNIQUE ("Name"); +GRANT USAGE ON SCHEMA postgis TO webmap_import; +GRANT USAGE ON SCHEMA postgis TO webmap_guest; -- --- Name: mrr:olja_gas_diamant_approved mrr:olja_gas_diamant_approved_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE geography_columns; Type: ACL; Schema: postgis; Owner: postgres -- -ALTER TABLE ONLY postgis."mrr:olja_gas_diamant_approved" - ADD CONSTRAINT "mrr:olja_gas_diamant_approved_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT ON TABLE postgis.geography_columns TO webmap_guest; -- --- Name: mrr:torvkoncessioner mrr:torvkoncessioner_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE geometry_columns; Type: ACL; Schema: postgis; Owner: postgres -- -ALTER TABLE ONLY postgis."mrr:torvkoncessioner" - ADD CONSTRAINT "mrr:torvkoncessioner_DiaryNr_key" UNIQUE ("DiaryNr"); +GRANT SELECT ON TABLE postgis.geometry_columns TO webmap_guest; -- --- Name: mrr:torvkoncessioner mrr:torvkoncessioner_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE kommunyta; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:torvkoncessioner" - ADD CONSTRAINT "mrr:torvkoncessioner_Name_key" UNIQUE ("Name"); +GRANT SELECT ON TABLE postgis.kommunyta TO webmap_guest; -- --- Name: mrr:torvkoncessioner mrr:torvkoncessioner_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE kommunyta_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."mrr:torvkoncessioner" - ADD CONSTRAINT "mrr:torvkoncessioner_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT,USAGE ON SEQUENCE postgis.kommunyta_ogc_fid_seq TO webmap_guest; -- --- Name: ren:omr_riks ren:omr_riks_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE lansyta; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:omr_riks" - ADD CONSTRAINT "ren:omr_riks_GlobalID_key" UNIQUE ("GlobalID"); +GRANT SELECT ON TABLE postgis.lansyta TO webmap_guest; -- --- Name: ren:omr_riks ren:omr_riks_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE lansyta_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:omr_riks" - ADD CONSTRAINT "ren:omr_riks_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_ogc_fid_seq TO webmap_guest; -- --- Name: ren:riks_ren ren:riks_ren_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "mrr:bearbetningskoncessioner_applied"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:riks_ren" - ADD CONSTRAINT "ren:riks_ren_GlobalID_key" UNIQUE ("GlobalID"); +GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_applied" TO webmap_guest; -- --- Name: ren:riks_ren ren:riks_ren_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "mrr:bearbetningskoncessioner_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."ren:riks_ren" - ADD CONSTRAINT "ren:riks_ren_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_applied_ogc_fid_seq" TO webmap_guest; -- --- Name: sametinget:betesomraden sametinget:betesomraden_SAMEBY_ID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "mrr:bearbetningskoncessioner_approved"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:betesomraden" - ADD CONSTRAINT "sametinget:betesomraden_SAMEBY_ID_key" UNIQUE ("SAMEBY_ID"); +GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_approved" TO webmap_guest; -- --- Name: sametinget:betesomraden sametinget:betesomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "mrr:bearbetningskoncessioner_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:betesomraden" - ADD CONSTRAINT "sametinget:betesomraden_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:bearbetningskoncessioner_approved_ogc_fid_seq" TO webmap_guest; -- --- Name: sametinget:flyttled sametinget:flyttled_GlobalID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "mrr:markanvisningar"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:flyttled" - ADD CONSTRAINT "sametinget:flyttled_GlobalID_key" UNIQUE ("GlobalID"); +GRANT SELECT ON TABLE postgis."mrr:markanvisningar" TO webmap_guest; -- --- Name: sametinget:flyttled sametinget:flyttled_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "mrr:markanvisningar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sametinget:flyttled" - ADD CONSTRAINT "sametinget:flyttled_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" TO webmap_guest; -- --- Name: sks:AvverkAnm sks:AvverkAnm_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "mrr:mineral_applied"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:AvverkAnm" - ADD CONSTRAINT "sks:AvverkAnm_Beteckn_key" UNIQUE ("Beteckn"); +GRANT SELECT ON TABLE postgis."mrr:mineral_applied" TO webmap_guest; -- --- Name: sks:AvverkAnm sks:AvverkAnm_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "mrr:mineral_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:AvverkAnm" - ADD CONSTRAINT "sks:AvverkAnm_OBJECTID_key" UNIQUE ("OBJECTID"); +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:mineral_applied_ogc_fid_seq" TO webmap_guest; -- --- Name: sks:AvverkAnm sks:AvverkAnm_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "mrr:mineral_approved"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:AvverkAnm" - ADD CONSTRAINT "sks:AvverkAnm_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT ON TABLE postgis."mrr:mineral_approved" TO webmap_guest; -- --- Name: sks:UtfordAvverk sks:UtfordAvverk_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "mrr:mineral_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:UtfordAvverk" - ADD CONSTRAINT "sks:UtfordAvverk_Beteckn_key" UNIQUE ("Beteckn"); +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:mineral_approved_ogc_fid_seq" TO webmap_guest; -- --- Name: sks:UtfordAvverk sks:UtfordAvverk_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "mrr:olja_gas_diamant_applied"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:UtfordAvverk" - ADD CONSTRAINT "sks:UtfordAvverk_OBJECTID_key" UNIQUE ("OBJECTID"); +GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_applied" TO webmap_guest; -- --- Name: sks:UtfordAvverk sks:UtfordAvverk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "mrr:olja_gas_diamant_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."sks:UtfordAvverk" - ADD CONSTRAINT "sks:UtfordAvverk_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:olja_gas_diamant_applied_ogc_fid_seq" TO webmap_guest; -- --- Name: vbk:havsbaserad_vindkraft vbk:havsbaserad_vindkraft_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "mrr:olja_gas_diamant_approved"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."vbk:havsbaserad_vindkraft" - ADD CONSTRAINT "vbk:havsbaserad_vindkraft_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_approved" TO webmap_guest; -- --- Name: vbk:projekteringsomraden vbk:projekteringsomraden_OmrID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "mrr:olja_gas_diamant_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."vbk:projekteringsomraden" - ADD CONSTRAINT "vbk:projekteringsomraden_OmrID_key" UNIQUE ("OmrID"); +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:olja_gas_diamant_approved_ogc_fid_seq" TO webmap_guest; -- --- Name: vbk:projekteringsomraden vbk:projekteringsomraden_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "mrr:torvkoncessioner"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."vbk:projekteringsomraden" - ADD CONSTRAINT "vbk:projekteringsomraden_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT ON TABLE postgis."mrr:torvkoncessioner" TO webmap_guest; -- --- Name: vbk:vindkraftverk vbk:vindkraftverk_VerkID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "mrr:torvkoncessioner_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."vbk:vindkraftverk" - ADD CONSTRAINT "vbk:vindkraftverk_VerkID_key" UNIQUE ("VerkID"); +GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" TO webmap_guest; -- --- Name: vbk:vindkraftverk vbk:vindkraftverk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nva:Naturvardsverket_Lansstyrelse"; Type: ACL; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."vbk:vindkraftverk" - ADD CONSTRAINT "vbk:vindkraftverk_pkey" PRIMARY KEY (ogc_fid); +GRANT SELECT ON TABLE postgis."nva:Naturvardsverket_Lansstyrelse" TO webmap_guest; -- --- Name: kommunyta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX kommunyta_wkb_geometry_geom_idx ON postgis.kommunyta USING gist (wkb_geometry); +GRANT SELECT,USAGE ON SEQUENCE postgis."nva:Naturvardsverket_Lansstyrelse_ogc_fid_seq" TO webmap_guest; -- --- Name: lansyta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nva:Skogsstyrelsen"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX lansyta_wkb_geometry_geom_idx ON postgis.lansyta USING gist (wkb_geometry); +GRANT SELECT ON TABLE postgis."nva:Skogsstyrelsen" TO webmap_guest; -- --- Name: mrr:bearbetningskoncessioner_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nva:Skogsstyrelsen_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "mrr:bearbetningskoncessioner_applied_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_applied" USING gist (wkb_geometry); +GRANT SELECT,USAGE ON SEQUENCE postgis."nva:Skogsstyrelsen_ogc_fid_seq" TO webmap_guest; -- --- Name: mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Biosfarsomraden"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "mrr:bearbetningskoncessioner_approved_wkb_geometry_geom_idx" ON postgis."mrr:bearbetningskoncessioner_approved" USING gist (wkb_geometry); +GRANT SELECT ON TABLE postgis."nvr:Biosfarsomraden" TO webmap_guest; -- --- Name: mrr:markanvisningar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Biosfarsomraden_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "mrr:markanvisningar_wkb_geometry_geom_idx" ON postgis."mrr:markanvisningar" USING gist (wkb_geometry); +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Biosfarsomraden_ogc_fid_seq" TO webmap_guest; -- --- Name: mrr:mineral_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Biotopskydd"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "mrr:mineral_applied_wkb_geometry_geom_idx" ON postgis."mrr:mineral_applied" USING gist (wkb_geometry); +GRANT SELECT ON TABLE postgis."nvr:Biotopskydd" TO webmap_guest; -- --- Name: mrr:mineral_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Biotopskydd_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "mrr:mineral_approved_wkb_geometry_geom_idx" ON postgis."mrr:mineral_approved" USING gist (wkb_geometry); +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Biotopskydd_ogc_fid_seq" TO webmap_guest; -- --- Name: mrr:olja_gas_diamant_applied_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Djur_och_vaxtskyddsomrade"; Type: ACL; 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); +GRANT SELECT ON TABLE postgis."nvr:Djur_och_vaxtskyddsomrade" TO webmap_guest; -- --- Name: mrr:olja_gas_diamant_approved_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq"; Type: ACL; 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); +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Djur_och_vaxtskyddsomrade_ogc_fid_seq" TO webmap_guest; -- --- Name: mrr:torvkoncessioner_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:HELCOM"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "mrr:torvkoncessioner_wkb_geometry_geom_idx" ON postgis."mrr:torvkoncessioner" USING gist (wkb_geometry); +GRANT SELECT ON TABLE postgis."nvr:HELCOM" TO webmap_guest; -- --- Name: ren:omr_riks_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:HELCOM_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ren:omr_riks_wkb_geometry_geom_idx" ON postgis."ren:omr_riks" USING gist (wkb_geometry); +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:HELCOM_ogc_fid_seq" TO webmap_guest; -- --- Name: ren:riks_ren_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Interimistiskt_forbud"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "ren:riks_ren_wkb_geometry_geom_idx" ON postgis."ren:riks_ren" USING gist (wkb_geometry); +GRANT SELECT ON TABLE postgis."nvr:Interimistiskt_forbud" TO webmap_guest; -- --- Name: sametinget:betesomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Interimistiskt_forbud_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sametinget:betesomraden_wkb_geometry_geom_idx" ON postgis."sametinget:betesomraden" USING gist (wkb_geometry); +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Interimistiskt_forbud_ogc_fid_seq" TO webmap_guest; -- --- Name: sametinget:flyttled_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Kultureservat"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sametinget:flyttled_wkb_geometry_geom_idx" ON postgis."sametinget:flyttled" USING gist (wkb_geometry); +GRANT SELECT ON TABLE postgis."nvr:Kultureservat" TO webmap_guest; -- --- Name: sks:AvverkAnm_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Kultureservat_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sks:AvverkAnm_wkb_geometry_geom_idx" ON postgis."sks:AvverkAnm" USING gist (wkb_geometry); +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Kultureservat_ogc_fid_seq" TO webmap_guest; -- --- Name: sks:UtfordAvverk_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Landskapsbildsskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "sks:UtfordAvverk_wkb_geometry_geom_idx" ON postgis."sks:UtfordAvverk" USING gist (wkb_geometry); +GRANT SELECT ON TABLE postgis."nvr:Landskapsbildsskyddsomrade" TO webmap_guest; -- --- Name: vbk:havsbaserad_vindkraft_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Landskapsbildsskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "vbk:havsbaserad_vindkraft_wkb_geometry_geom_idx" ON postgis."vbk:havsbaserad_vindkraft" USING gist (wkb_geometry); +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Landskapsbildsskyddsomrade_ogc_fid_seq" TO webmap_guest; -- --- Name: vbk:projekteringsomraden_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Nationalpark"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "vbk:projekteringsomraden_wkb_geometry_geom_idx" ON postgis."vbk:projekteringsomraden" USING gist (wkb_geometry); +GRANT SELECT ON TABLE postgis."nvr:Nationalpark" TO webmap_guest; -- --- Name: vbk:vindkraftverk_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Nationalpark_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "vbk:vindkraftverk_wkb_geometry_geom_idx" ON postgis."vbk:vindkraftverk" USING gist (wkb_geometry); +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" TO webmap_guest; -- --- Name: DATABASE webmap; Type: ACL; Schema: -; Owner: postgres +-- Name: TABLE "nvr:Naturminne_polygon"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT CONNECT ON DATABASE webmap TO webmap_import; -GRANT CONNECT ON DATABASE webmap TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Naturminne_polygon" TO webmap_guest; -- --- Name: SCHEMA postgis; Type: ACL; Schema: -; Owner: postgres +-- Name: SEQUENCE "nvr:Naturminne_polygon_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT USAGE ON SCHEMA postgis TO webmap_import; -GRANT USAGE ON SCHEMA postgis TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE geography_columns; Type: ACL; Schema: postgis; Owner: postgres +-- Name: TABLE "nvr:Naturminne_punkt"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis.geography_columns TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Naturminne_punkt" TO webmap_guest; -- --- Name: TABLE geometry_columns; Type: ACL; Schema: postgis; Owner: postgres +-- Name: SEQUENCE "nvr:Naturminne_punkt_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis.geometry_columns TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE kommunyta; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Naturreservat"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis.kommunyta TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Naturreservat" TO webmap_guest; -- --- Name: SEQUENCE kommunyta_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Naturreservat_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis.kommunyta_ogc_fid_seq TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturreservat_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE lansyta; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Naturvardsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis.lansyta TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Naturvardsomrade" TO webmap_guest; -- --- Name: SEQUENCE lansyta_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Naturvardsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis.lansyta_ogc_fid_seq TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturvardsomrade_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "mrr:bearbetningskoncessioner_applied"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:OSPAR"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_applied" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:OSPAR" TO webmap_guest; -- --- Name: SEQUENCE "mrr:bearbetningskoncessioner_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:OSPAR_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; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:OSPAR_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "mrr:bearbetningskoncessioner_approved"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Ovrigt_biotopskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."mrr:bearbetningskoncessioner_approved" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Ovrigt_biotopskyddsomrade" TO webmap_guest; -- --- Name: SEQUENCE "mrr:bearbetningskoncessioner_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Ovrigt_biotopskyddsomrade_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; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Ovrigt_biotopskyddsomrade_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "mrr:markanvisningar"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Ramsar"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."mrr:markanvisningar" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Ramsar" TO webmap_guest; -- --- Name: SEQUENCE "mrr:markanvisningar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Ramsar_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:markanvisningar_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Ramsar_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "mrr:mineral_applied"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:SCI_Rikstackande"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."mrr:mineral_applied" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:SCI_Rikstackande" TO webmap_guest; -- --- Name: SEQUENCE "mrr:mineral_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:SCI_Rikstackande_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; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:SCI_Rikstackande_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "mrr:mineral_approved"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:SPA_Rikstackande"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."mrr:mineral_approved" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:SPA_Rikstackande" TO webmap_guest; -- --- Name: SEQUENCE "mrr:mineral_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:SPA_Rikstackande_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; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:SPA_Rikstackande_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "mrr:olja_gas_diamant_applied"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Tilltradesforbud"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_applied" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Tilltradesforbud" TO webmap_guest; -- --- Name: SEQUENCE "mrr:olja_gas_diamant_applied_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Tilltradesforbud_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; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Tilltradesforbud_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "mrr:olja_gas_diamant_approved"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Varldsarv"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."mrr:olja_gas_diamant_approved" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Varldsarv" TO webmap_guest; -- --- Name: SEQUENCE "mrr:olja_gas_diamant_approved_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Varldsarv_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; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Varldsarv_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "mrr:torvkoncessioner"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Vattenskyddsomrade"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."mrr:torvkoncessioner" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Vattenskyddsomrade" TO webmap_guest; -- --- Name: SEQUENCE "mrr:torvkoncessioner_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Vattenskyddsomrade_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."mrr:torvkoncessioner_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Vattenskyddsomrade_ogc_fid_seq" TO webmap_guest; -- -- cgit v1.2.3