From 83c6f27f5c2acf80dbf44a8b49174629a79680d1 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 29 Jul 2025 21:39:04 +0200 Subject: [PATCH] reduce precision of interpolations to OSM precision --- lib-sql/functions/interpolation.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/lib-sql/functions/interpolation.sql b/lib-sql/functions/interpolation.sql index 452ef7c3..7e8877cc 100644 --- a/lib-sql/functions/interpolation.sql +++ b/lib-sql/functions/interpolation.sql @@ -309,7 +309,7 @@ BEGIN IF NEW.startnumber IS NULL THEN NEW.startnumber := startnumber; NEW.endnumber := endnumber; - NEW.linegeo := sectiongeo; + NEW.linegeo := ST_ReducePrecision(sectiongeo, 0.0000001); NEW.postcode := postcode; ELSE INSERT INTO location_property_osmline @@ -317,7 +317,8 @@ BEGIN startnumber, endnumber, step, address, postcode, country_code, geometry_sector, indexed_status) - VALUES (sectiongeo, NEW.partition, NEW.osm_id, NEW.parent_place_id, + VALUES (ST_ReducePrecision(sectiongeo, 0.0000001), + NEW.partition, NEW.osm_id, NEW.parent_place_id, startnumber, endnumber, NEW.step, NEW.address, postcode, NEW.country_code, NEW.geometry_sector, 0); -- 2.39.5