aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2024-06-19 03:09:37 +0200
committerGuilhem Moulin <guilhem@fripost.org>2024-06-19 03:32:33 +0200
commitae01b2aae08033a4183b7c601dbf0381362f346b (patch)
tree3adbf5c18708d4344c7b3794eceac9ccee317644
parentb7531ec5c353c616bcb905964339b06b5c8b6ed0 (diff)
sks:UtfordAvverk: Add NOT NULL constraint on AnmaldHa column.
There are a couple (15) of NULL AnmaldHa's, all from Sep 1, 2005 in Borås, so we don't care about these.
-rw-r--r--config.yml2
-rw-r--r--schema.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/config.yml b/config.yml
index 450cc5f..183599c 100644
--- a/config.yml
+++ b/config.yml
@@ -556,7 +556,7 @@ layers:
- name: AnmaldHa
type: Real
subtype: Float32
- #nullable: false
+ nullable: false
#comment: areal anmält (ha)
- name: SkogsodlHa
type: Real
diff --git a/schema.sql b/schema.sql
index 07bda74..6fbef97 100644
--- a/schema.sql
+++ b/schema.sql
@@ -595,7 +595,7 @@ CREATE TABLE postgis."sks:UtfordAvverk" (
"ArendeAr" smallint NOT NULL,
"Avverktyp" character varying(254) NOT NULL,
"Skogstyp" character varying(254) NOT NULL,
- "AnmaldHa" real,
+ "AnmaldHa" real NOT NULL,
"SkogsodlHa" real NOT NULL,
"NatforHa" real NOT NULL,
"Avvdatum" date NOT NULL,