--- a/cmd/octree2contour/store.go	Sun Sep 23 16:01:04 2018 +0200
+++ b/cmd/octree2contour/store.go	Sun Sep 23 19:51:02 2018 +0200
@@ -2,6 +2,7 @@
 
 import (
 	"database/sql"
+	"time"
 
 	"gemma.intevation.de/gemma/pkg/octree"
 )
@@ -11,13 +12,28 @@
 	lines octree.MultiLineStringZ
 }
 
-const insertSQL = `
-INSERT INTO waterway.contour_lines (height, geom)
-VALUES ($1, ST_Transform(
-	ST_SetSRID(ST_GeomFromWKB($2), $3), 4326)::geography)
+const (
+	deleteSQL = `
+DELETE FROM waterway.sounding_results_lines
+WHERE sounding_result_id IN (SELECT id
+FROM waterway.sounding_results
+WHERE bottleneck_id = $1 AND date_info = $2)
 `
+	insertSQL = `
+INSERT INTO waterway.sounding_results_lines
+SELECT
+  sounding_result_id,
+  $1,
+  ST_Transform(ST_SetSRID(ST_GeomFromWKB($2), $3), 4326)::geography
+FROM waterway.sounding_results
+WHERE bottleneck_id = $4 AND date_info = $5
+`
+)
 
-func store(all []result, epsg uint32) error {
+func store(
+	all []result, epsg uint32,
+	bottleneck string, date time.Time,
+) error {
 
 	return run(func(db *sql.DB) error {
 
@@ -27,13 +43,20 @@
 		}
 		defer tx.Rollback()
 
+		if _, err := tx.Exec(deleteSQL, bottleneck, date); err != nil {
+			return err
+		}
+
 		stmt, err := tx.Prepare(insertSQL)
 		if err != nil {
 			return err
 		}
 
 		for _, r := range all {
-			if _, err := stmt.Exec(r.h, r.lines.AsWKB(), epsg); err != nil {
+			if _, err := stmt.Exec(
+				r.h, r.lines.AsWKB(), epsg,
+				bottleneck, date,
+			); err != nil {
 				return err
 			}
 		}