Mercurial > gemma

changeset 135:731fb359b29c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Schema: Make responsibility_areas multi polygons. As responsibility_areas are based on country borders, and countries may consist of multiple polygons (think islands for example) we need to use MULTIPOLYGON as data type.
author Sascha Wilde <wilde@intevation.de>
date Fri, 29 Jun 2018 11:56:34 +0200
parents f4523620ba5d
children 25dba84d5703
files schema/gemma.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Jun 28 17:26:38 2018 +0200
+++ b/schema/gemma.sql	Fri Jun 29 11:56:34 2018 +0200
@@ -60,7 +60,7 @@
 
 CREATE TABLE gemma.responsibility_areas (
        country char(2) PRIMARY KEY REFERENCES countries,
-       area geometry(POLYGON, 4326) --XXX: Should be geography (elsewhere too)
+       area geometry(MULTIPOLYGON, 4326) --XXX: Should be geography (elsewhere too)
        );
 
 CREATE TABLE gemma.language_codes (