Mercurial > gemma
diff schema/gemma.sql @ 135:731fb359b29c
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 | d349db18bece |
children | 4e2451d561b1 |
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 (