From 5f0b055c01bd122b938e94313c3b7bc8bd9b68e3 Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Mon, 23 May 2011 11:30:44 +0000 Subject: [PATCH] Update load_topology.sql to properly set MBR field of faces. git-svn-id: http://svn.osgeo.org/postgis/trunk@7210 b70326c6-7e19-0410-871a-916f4a2858ee --- topology/test/load_topology.sql.in | 3 +++ topology/test/regress/st_addedgenewfaces_expected | 4 ++-- 2 files changed, 5 insertions(+), 2 deletions(-) diff --git a/topology/test/load_topology.sql.in b/topology/test/load_topology.sql.in index 4a7d315bd..866f8a941 100644 --- a/topology/test/load_topology.sql.in +++ b/topology/test/load_topology.sql.in @@ -193,5 +193,8 @@ INSERT INTO city_data.edge VALUES(26, 20, 20, 26, -26, 9, 1, -- UPDATE Edge id sequence SELECT setval('city_data.edge_data_edge_id_seq', 26); +-- Set face minimum bounding rectangle +UPDATE city_data.face set mbr = ST_SetSRID( ( select st_extent(geom) from city_data.edge where left_face = face_id or right_face = face_id ), @SRID@ ) where face_id != 0; + END; diff --git a/topology/test/regress/st_addedgenewfaces_expected b/topology/test/regress/st_addedgenewfaces_expected index 6402df8c4..a53f10928 100644 --- a/topology/test/regress/st_addedgenewfaces_expected +++ b/topology/test/regress/st_addedgenewfaces_expected @@ -85,8 +85,8 @@ T18|E43|-44|44|33|0 F3,F4|{3:10,3:11,3:23,3:24,3:25} F5,N4|{1:4,3:12,3:13} F0| -F1| -F9| +F1|POLYGON((3 30,3 38,16 38,16 30,3 30)) +F9|POLYGON((4 31,4 34,7 34,7 31,4 31)) F10|POLYGON((21 14,21 22,35 22,35 14,21 14)) F11|POLYGON((21 14,21 22,35 22,35 14,21 14)) F12|POLYGON((35 14,35 22,47 22,47 14,35 14)) -- 2.50.1