From 3bd492be08a97c16c813bc57773028def5c69e23 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Wed, 12 Jun 2024 02:01:47 +0200 Subject: sks:UtfordAvverk: Add UNIQUE constraint on OBJECTID. Not sure why I thought there was duplicates but I must have done something wrong as there are none in the 667034+223463+214082+ 72656 = 1177234 features found after removing the spatial filter. --- config.yml | 3 +-- schema.sql | 8 ++++++++ 2 files changed, 9 insertions(+), 2 deletions(-) diff --git a/config.yml b/config.yml index e82dce5..efa1841 100644 --- a/config.yml +++ b/config.yml @@ -515,8 +515,7 @@ layers: # https://www.skogsstyrelsen.se/globalassets/sjalvservice/karttjanster/geodatatjanster/produktbeskrivningar/utforda-avverkningar---produktbeskrivning.pdf - name: OBJECTID type: Integer - # XXX there are duplicates(!?) - #unique: true + unique: true nullable: false #comment: unik identitet - name: Beteckn diff --git a/schema.sql b/schema.sql index 3cb7d18..25cf25b 100644 --- a/schema.sql +++ b/schema.sql @@ -366,6 +366,14 @@ ALTER TABLE ONLY postgis."sks:AvverkAnm" ADD CONSTRAINT "sks:AvverkAnm_pkey" PRIMARY KEY (ogc_fid); +-- +-- Name: sks:UtfordAvverk sks:UtfordAvverk_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sks:UtfordAvverk" + ADD CONSTRAINT "sks:UtfordAvverk_OBJECTID_key" UNIQUE ("OBJECTID"); + + -- -- Name: sks:UtfordAvverk sks:UtfordAvverk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -- cgit v1.2.3