annotate schema/updates/1204/02.delete-contours.sql @ 5095:e21cbb9768a2

Prevent duplicate fairway areas In principal, there can be only one or no fairway area at each point on the map. Since polygons from real data will often be topologically inexact, just disallow equal geometries. This will also help to avoid importing duplicates with concurrent imports, once the history of fairway dimensions will be preserved.
author Tom Gottfried <tom@intevation.de>
date Wed, 25 Mar 2020 18:10:02 +0100
parents c657dec6b0fa
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4578
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 DELETE FROM sys_admin.published_services WHERE name = 'waterway.sounding_differences'::regclass;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2 DELETE FROM sys_admin.published_services WHERE name = 'waterway.sounding_results_contour_lines_geoserver'::regclass;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 DROP VIEW waterway.sounding_results_contour_lines_geoserver;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5 DROP VIEW waterway.sounding_differences;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6 DROP TABLE caching.sounding_differences_contour_lines;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
7 DROP TABLE waterway.sounding_results_contour_lines;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
8