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