aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2024-10-27 23:17:38 +0100
committerGuilhem Moulin <guilhem@fripost.org>2024-10-27 23:17:38 +0100
commitc36edde5f028a7a64cb44eaf7260215a25ada75b (patch)
treea6ddcc200e837cde67858e37608b476402bad18e
parent39658412ab12f332446f1ca8acad37a8255b0009 (diff)
nva:Skogsstyrelsen: Remove NOT NULL constraint on the DatAvtal column.
As of today SK 117-2024 has not contract date set, so the constraint fails during import. https://www.skogsstyrelsen.se/skogens-parlor/NVAvtal/?objektid=4020527
-rw-r--r--config.yml1
-rw-r--r--schema.sql2
2 files changed, 1 insertions, 2 deletions
diff --git a/config.yml b/config.yml
index eee8e0f..224b439 100644
--- a/config.yml
+++ b/config.yml
@@ -2020,7 +2020,6 @@ layers:
comment: Ståndortsindex
- name: DatAvtal
type: Date
- nullable: false
- name: Url
type: String
width: 254
diff --git a/schema.sql b/schema.sql
index 14260ca..7249816 100644
--- a/schema.sql
+++ b/schema.sql
@@ -706,7 +706,7 @@ CREATE TABLE postgis."nva:Skogsstyrelsen" (
"AreaTot" double precision NOT NULL,
"AreaProd" double precision NOT NULL,
"Standort" character varying(254),
- "DatAvtal" date NOT NULL,
+ "DatAvtal" date,
"Url" character varying(254) NOT NULL,
"Undertyp" character varying(64),
wkb_geometry postgis.geometry(MultiPolygon,3006) NOT NULL