Mercurial > gemma
changeset 1684:b20b68adfe80
Waterway axis: Removed unique geohash index.
We need to discuss if this index kind is the right way to prevent duplicates.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 27 Dec 2018 23:23:36 +0100 |
parents | 509e8728e846 |
children | 8f5a5c86f2a9 |
files | schema/gemma.sql |
diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Thu Dec 27 22:49:35 2018 +0100 +++ b/schema/gemma.sql Thu Dec 27 23:23:36 2018 +0100 @@ -302,7 +302,8 @@ objnam varchar NOT NULL, nobjnam varchar ) - CREATE UNIQUE INDEX ON waterway_axis ((ST_GeoHash(wtwaxs, 23))) + -- TODO: @tom: Why did you choose this index kind? + -- CREATE UNIQUE INDEX ON waterway_axis ((ST_GeoHash(wtwaxs, 23))) -- This table allows linkage between 1D ISRS location codes and 2D space -- e.g. for cutting bottleneck area out of waterway area based on virtual