From 835391504328c087cd79d84f5ca3baf2d576d6f1 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Fri, 8 Jun 2012 17:18:37 +0000 Subject: [PATCH] snaptogrid to get rid of false failures on mingw-64 resulting from single digit rounding differences git-svn-id: http://svn.osgeo.org/postgis/trunk@9871 b70326c6-7e19-0410-871a-916f4a2858ee --- .../MultiToSinglePoint-w.select.expected | 132 +++++++++--------- .../loader/MultiToSinglePoint.select.expected | 132 +++++++++--------- regress/loader/MultiToSinglePoint.select.sql | 2 +- .../NotReallyMultiPoint-w.select.expected | 132 +++++++++--------- .../NotReallyMultiPoint.select.expected | 132 +++++++++--------- regress/loader/NotReallyMultiPoint.select.sql | 2 +- 6 files changed, 266 insertions(+), 266 deletions(-) diff --git a/regress/loader/MultiToSinglePoint-w.select.expected b/regress/loader/MultiToSinglePoint-w.select.expected index b80e20e69..db78a7999 100644 --- a/regress/loader/MultiToSinglePoint-w.select.expected +++ b/regress/loader/MultiToSinglePoint-w.select.expected @@ -1,66 +1,66 @@ -POINT(580936.142822989 819465.261818573) -POINT(506358.893822162 607539.257299624) -POINT(630565.963576575 527840.458930382) -POINT(315456.492217951 345306.814088522) -POINT(471022.700765905 736736.493043649) -POINT(500018.609208153 615679.275075901) -POINT(219498.722491731 315980.375130241) -POINT(319224.669258993 318928.062445705) -POINT(568650.774421983 460462.130343988) -POINT(556409.113539159 729253.30990305) -POINT(513863.467629622 702618.742174883) -POINT(578737.93900689 752848.936014613) -POINT(574438.608452132 769113.196326717) -POINT(542424.351008234 668316.880130952) -POINT(400265.835331173 734407.03359561) -POINT(451759.863004144 412686.100723883) -POINT(569910.583609289 459856.209410486) -POINT(463382.922608931 699974.019885147) -POINT(604477.021809125 740527.999129056) -POINT(507899.651882106 708318.275562585) -POINT(417174.241778919 505305.090947582) -POINT(577806.69952663 694316.933395063) -POINT(576210.383288164 714992.288047029) -POINT(577656.942500652 695830.735895674) -POINT(581803.77911474 693852.464252684) -POINT(483239.070139275 239264.868230516) -POINT(584627.388419181 693322.924133717) -POINT(531622.192358354 716647.04090078) -POINT(581975.365599073 694284.048851616) -POINT(446160.135881017 550892.865025523) -POINT(529311.59036645 610942.506187195) -POINT(581808.72698778 695841.703111349) -POINT(504782.468510898 615893.18621198) -POINT(622500.156247537 752230.030256728) -POINT(349366.222335089 363016.921231509) -POINT(594903.330738372 545923.436927693) -POINT(441308.570185706 229022.749014213) -POINT(605633.269658534 771823.459750208) -POINT(318054.396825439 406677.968765208) -POINT(606814.490943 683559.837390652) -POINT(427202.24558416 526355.921118875) -POINT(585605.654583162 428734.299958661) -POINT(348498.220290712 696622.254661199) -POINT(447753.888233448 552268.218021069) -POINT(562081.950510856 696159.347584696) -POINT(449917.461533751 516567.922516446) -POINT(509151.60703826 594632.163260898) -POINT(565466.43527563 673573.123642044) -POINT(492421.362355858 719117.799265052) -POINT(613346.499961959 691449.747538779) -POINT(341505.39322594 347633.860111487) -POINT(335130.109224021 221738.458568427) -POINT(520476.859199935 607380.893420555) -POINT(610931.065287928 690104.943360865) -POINT(577692.981621935 695342.840693476) -POINT(623744.425211874 697297.79933633) -POINT(439667.99409899 646984.255696235) -POINT(507141.140300172 606418.246119218) -POINT(575383.927230225 737533.321867288) -POINT(413215.495253968 523736.836314417) -POINT(561887.180888466 504214.422382654) -POINT(583428.220763956 759656.927730192) -POINT(421018.925048973 813910.215413168) -POINT(621373.929808485 690044.79287378) -POINT(470983.159331542 620692.733330001) -POINT(508947.758356538 706720.507141173) +POINT(580936.14282 819465.26182) +POINT(506358.89382 607539.2573) +POINT(630565.96358 527840.45893) +POINT(315456.49222 345306.81409) +POINT(471022.70077 736736.49304) +POINT(500018.60921 615679.27508) +POINT(219498.72249 315980.37513) +POINT(319224.66926 318928.06245) +POINT(568650.77442 460462.13034) +POINT(556409.11354 729253.3099) +POINT(513863.46763 702618.74217) +POINT(578737.93901 752848.93601) +POINT(574438.60845 769113.19633) +POINT(542424.35101 668316.88013) +POINT(400265.83533 734407.0336) +POINT(451759.863 412686.10072) +POINT(569910.58361 459856.20941) +POINT(463382.92261 699974.01989) +POINT(604477.02181 740527.99913) +POINT(507899.65188 708318.27556) +POINT(417174.24178 505305.09095) +POINT(577806.69953 694316.9334) +POINT(576210.38329 714992.28805) +POINT(577656.9425 695830.7359) +POINT(581803.77911 693852.46425) +POINT(483239.07014 239264.86823) +POINT(584627.38842 693322.92413) +POINT(531622.19236 716647.0409) +POINT(581975.3656 694284.04885) +POINT(446160.13588 550892.86503) +POINT(529311.59037 610942.50619) +POINT(581808.72699 695841.70311) +POINT(504782.46851 615893.18621) +POINT(622500.15625 752230.03026) +POINT(349366.22234 363016.92123) +POINT(594903.33074 545923.43693) +POINT(441308.57019 229022.74901) +POINT(605633.26966 771823.45975) +POINT(318054.39683 406677.96877) +POINT(606814.49094 683559.83739) +POINT(427202.24558 526355.92112) +POINT(585605.65458 428734.29996) +POINT(348498.22029 696622.25466) +POINT(447753.88823 552268.21802) +POINT(562081.95051 696159.34758) +POINT(449917.46153 516567.92252) +POINT(509151.60704 594632.16326) +POINT(565466.43528 673573.12364) +POINT(492421.36236 719117.79927) +POINT(613346.49996 691449.74754) +POINT(341505.39323 347633.86011) +POINT(335130.10922 221738.45857) +POINT(520476.8592 607380.89342) +POINT(610931.06529 690104.94336) +POINT(577692.98162 695342.84069) +POINT(623744.42521 697297.79934) +POINT(439667.9941 646984.2557) +POINT(507141.1403 606418.24612) +POINT(575383.92723 737533.32187) +POINT(413215.49525 523736.83631) +POINT(561887.18089 504214.42238) +POINT(583428.22076 759656.92773) +POINT(421018.92505 813910.21541) +POINT(621373.92981 690044.79287) +POINT(470983.15933 620692.73333) +POINT(508947.75836 706720.50714) diff --git a/regress/loader/MultiToSinglePoint.select.expected b/regress/loader/MultiToSinglePoint.select.expected index b80e20e69..db78a7999 100644 --- a/regress/loader/MultiToSinglePoint.select.expected +++ b/regress/loader/MultiToSinglePoint.select.expected @@ -1,66 +1,66 @@ -POINT(580936.142822989 819465.261818573) -POINT(506358.893822162 607539.257299624) -POINT(630565.963576575 527840.458930382) -POINT(315456.492217951 345306.814088522) -POINT(471022.700765905 736736.493043649) -POINT(500018.609208153 615679.275075901) -POINT(219498.722491731 315980.375130241) -POINT(319224.669258993 318928.062445705) -POINT(568650.774421983 460462.130343988) -POINT(556409.113539159 729253.30990305) -POINT(513863.467629622 702618.742174883) -POINT(578737.93900689 752848.936014613) -POINT(574438.608452132 769113.196326717) -POINT(542424.351008234 668316.880130952) -POINT(400265.835331173 734407.03359561) -POINT(451759.863004144 412686.100723883) -POINT(569910.583609289 459856.209410486) -POINT(463382.922608931 699974.019885147) -POINT(604477.021809125 740527.999129056) -POINT(507899.651882106 708318.275562585) -POINT(417174.241778919 505305.090947582) -POINT(577806.69952663 694316.933395063) -POINT(576210.383288164 714992.288047029) -POINT(577656.942500652 695830.735895674) -POINT(581803.77911474 693852.464252684) -POINT(483239.070139275 239264.868230516) -POINT(584627.388419181 693322.924133717) -POINT(531622.192358354 716647.04090078) -POINT(581975.365599073 694284.048851616) -POINT(446160.135881017 550892.865025523) -POINT(529311.59036645 610942.506187195) -POINT(581808.72698778 695841.703111349) -POINT(504782.468510898 615893.18621198) -POINT(622500.156247537 752230.030256728) -POINT(349366.222335089 363016.921231509) -POINT(594903.330738372 545923.436927693) -POINT(441308.570185706 229022.749014213) -POINT(605633.269658534 771823.459750208) -POINT(318054.396825439 406677.968765208) -POINT(606814.490943 683559.837390652) -POINT(427202.24558416 526355.921118875) -POINT(585605.654583162 428734.299958661) -POINT(348498.220290712 696622.254661199) -POINT(447753.888233448 552268.218021069) -POINT(562081.950510856 696159.347584696) -POINT(449917.461533751 516567.922516446) -POINT(509151.60703826 594632.163260898) -POINT(565466.43527563 673573.123642044) -POINT(492421.362355858 719117.799265052) -POINT(613346.499961959 691449.747538779) -POINT(341505.39322594 347633.860111487) -POINT(335130.109224021 221738.458568427) -POINT(520476.859199935 607380.893420555) -POINT(610931.065287928 690104.943360865) -POINT(577692.981621935 695342.840693476) -POINT(623744.425211874 697297.79933633) -POINT(439667.99409899 646984.255696235) -POINT(507141.140300172 606418.246119218) -POINT(575383.927230225 737533.321867288) -POINT(413215.495253968 523736.836314417) -POINT(561887.180888466 504214.422382654) -POINT(583428.220763956 759656.927730192) -POINT(421018.925048973 813910.215413168) -POINT(621373.929808485 690044.79287378) -POINT(470983.159331542 620692.733330001) -POINT(508947.758356538 706720.507141173) +POINT(580936.14282 819465.26182) +POINT(506358.89382 607539.2573) +POINT(630565.96358 527840.45893) +POINT(315456.49222 345306.81409) +POINT(471022.70077 736736.49304) +POINT(500018.60921 615679.27508) +POINT(219498.72249 315980.37513) +POINT(319224.66926 318928.06245) +POINT(568650.77442 460462.13034) +POINT(556409.11354 729253.3099) +POINT(513863.46763 702618.74217) +POINT(578737.93901 752848.93601) +POINT(574438.60845 769113.19633) +POINT(542424.35101 668316.88013) +POINT(400265.83533 734407.0336) +POINT(451759.863 412686.10072) +POINT(569910.58361 459856.20941) +POINT(463382.92261 699974.01989) +POINT(604477.02181 740527.99913) +POINT(507899.65188 708318.27556) +POINT(417174.24178 505305.09095) +POINT(577806.69953 694316.9334) +POINT(576210.38329 714992.28805) +POINT(577656.9425 695830.7359) +POINT(581803.77911 693852.46425) +POINT(483239.07014 239264.86823) +POINT(584627.38842 693322.92413) +POINT(531622.19236 716647.0409) +POINT(581975.3656 694284.04885) +POINT(446160.13588 550892.86503) +POINT(529311.59037 610942.50619) +POINT(581808.72699 695841.70311) +POINT(504782.46851 615893.18621) +POINT(622500.15625 752230.03026) +POINT(349366.22234 363016.92123) +POINT(594903.33074 545923.43693) +POINT(441308.57019 229022.74901) +POINT(605633.26966 771823.45975) +POINT(318054.39683 406677.96877) +POINT(606814.49094 683559.83739) +POINT(427202.24558 526355.92112) +POINT(585605.65458 428734.29996) +POINT(348498.22029 696622.25466) +POINT(447753.88823 552268.21802) +POINT(562081.95051 696159.34758) +POINT(449917.46153 516567.92252) +POINT(509151.60704 594632.16326) +POINT(565466.43528 673573.12364) +POINT(492421.36236 719117.79927) +POINT(613346.49996 691449.74754) +POINT(341505.39323 347633.86011) +POINT(335130.10922 221738.45857) +POINT(520476.8592 607380.89342) +POINT(610931.06529 690104.94336) +POINT(577692.98162 695342.84069) +POINT(623744.42521 697297.79934) +POINT(439667.9941 646984.2557) +POINT(507141.1403 606418.24612) +POINT(575383.92723 737533.32187) +POINT(413215.49525 523736.83631) +POINT(561887.18089 504214.42238) +POINT(583428.22076 759656.92773) +POINT(421018.92505 813910.21541) +POINT(621373.92981 690044.79287) +POINT(470983.15933 620692.73333) +POINT(508947.75836 706720.50714) diff --git a/regress/loader/MultiToSinglePoint.select.sql b/regress/loader/MultiToSinglePoint.select.sql index e68081804..716254c28 100644 --- a/regress/loader/MultiToSinglePoint.select.sql +++ b/regress/loader/MultiToSinglePoint.select.sql @@ -1,2 +1,2 @@ -select ST_Asewkt(the_geom) from loadedshp; +select ST_Asewkt(ST_SnapToGrid(the_geom,0.00001)) from loadedshp; diff --git a/regress/loader/NotReallyMultiPoint-w.select.expected b/regress/loader/NotReallyMultiPoint-w.select.expected index ea5570206..467d1af2d 100644 --- a/regress/loader/NotReallyMultiPoint-w.select.expected +++ b/regress/loader/NotReallyMultiPoint-w.select.expected @@ -1,66 +1,66 @@ -MULTIPOINT(580936.142822989 819465.261818573) -MULTIPOINT(506358.893822162 607539.257299624) -MULTIPOINT(630565.963576575 527840.458930382) -MULTIPOINT(315456.492217951 345306.814088522) -MULTIPOINT(471022.700765905 736736.493043649) -MULTIPOINT(500018.609208153 615679.275075901) -MULTIPOINT(219498.722491731 315980.375130241) -MULTIPOINT(319224.669258993 318928.062445705) -MULTIPOINT(568650.774421983 460462.130343988) -MULTIPOINT(556409.113539159 729253.30990305) -MULTIPOINT(513863.467629622 702618.742174883) -MULTIPOINT(578737.93900689 752848.936014613) -MULTIPOINT(574438.608452132 769113.196326717) -MULTIPOINT(542424.351008234 668316.880130952) -MULTIPOINT(400265.835331173 734407.03359561) -MULTIPOINT(451759.863004144 412686.100723883) -MULTIPOINT(569910.583609289 459856.209410486) -MULTIPOINT(463382.922608931 699974.019885147) -MULTIPOINT(604477.021809125 740527.999129056) -MULTIPOINT(507899.651882106 708318.275562585) -MULTIPOINT(417174.241778919 505305.090947582) -MULTIPOINT(577806.69952663 694316.933395063) -MULTIPOINT(576210.383288164 714992.288047029) -MULTIPOINT(577656.942500652 695830.735895674) -MULTIPOINT(581803.77911474 693852.464252684) -MULTIPOINT(483239.070139275 239264.868230516) -MULTIPOINT(584627.388419181 693322.924133717) -MULTIPOINT(531622.192358354 716647.04090078) -MULTIPOINT(581975.365599073 694284.048851616) -MULTIPOINT(446160.135881017 550892.865025523) -MULTIPOINT(529311.59036645 610942.506187195) -MULTIPOINT(581808.72698778 695841.703111349) -MULTIPOINT(504782.468510898 615893.18621198) -MULTIPOINT(622500.156247537 752230.030256728) -MULTIPOINT(349366.222335089 363016.921231509) -MULTIPOINT(594903.330738372 545923.436927693) -MULTIPOINT(441308.570185706 229022.749014213) -MULTIPOINT(605633.269658534 771823.459750208) -MULTIPOINT(318054.396825439 406677.968765208) -MULTIPOINT(606814.490943 683559.837390652) -MULTIPOINT(427202.24558416 526355.921118875) -MULTIPOINT(585605.654583162 428734.299958661) -MULTIPOINT(348498.220290712 696622.254661199) -MULTIPOINT(447753.888233448 552268.218021069) -MULTIPOINT(562081.950510856 696159.347584696) -MULTIPOINT(449917.461533751 516567.922516446) -MULTIPOINT(509151.60703826 594632.163260898) -MULTIPOINT(565466.43527563 673573.123642044) -MULTIPOINT(492421.362355858 719117.799265052) -MULTIPOINT(613346.499961959 691449.747538779) -MULTIPOINT(341505.39322594 347633.860111487) -MULTIPOINT(335130.109224021 221738.458568427) -MULTIPOINT(520476.859199935 607380.893420555) -MULTIPOINT(610931.065287928 690104.943360865) -MULTIPOINT(577692.981621935 695342.840693476) -MULTIPOINT(623744.425211874 697297.79933633) -MULTIPOINT(439667.99409899 646984.255696235) -MULTIPOINT(507141.140300172 606418.246119218) -MULTIPOINT(575383.927230225 737533.321867288) -MULTIPOINT(413215.495253968 523736.836314417) -MULTIPOINT(561887.180888466 504214.422382654) -MULTIPOINT(583428.220763956 759656.927730192) -MULTIPOINT(421018.925048973 813910.215413168) -MULTIPOINT(621373.929808485 690044.79287378) -MULTIPOINT(470983.159331542 620692.733330001) -MULTIPOINT(508947.758356538 706720.507141173) +MULTIPOINT(580936.14282 819465.26182) +MULTIPOINT(506358.89382 607539.2573) +MULTIPOINT(630565.96358 527840.45893) +MULTIPOINT(315456.49222 345306.81409) +MULTIPOINT(471022.70077 736736.49304) +MULTIPOINT(500018.60921 615679.27508) +MULTIPOINT(219498.72249 315980.37513) +MULTIPOINT(319224.66926 318928.06245) +MULTIPOINT(568650.77442 460462.13034) +MULTIPOINT(556409.11354 729253.3099) +MULTIPOINT(513863.46763 702618.74217) +MULTIPOINT(578737.93901 752848.93601) +MULTIPOINT(574438.60845 769113.19633) +MULTIPOINT(542424.35101 668316.88013) +MULTIPOINT(400265.83533 734407.0336) +MULTIPOINT(451759.863 412686.10072) +MULTIPOINT(569910.58361 459856.20941) +MULTIPOINT(463382.92261 699974.01989) +MULTIPOINT(604477.02181 740527.99913) +MULTIPOINT(507899.65188 708318.27556) +MULTIPOINT(417174.24178 505305.09095) +MULTIPOINT(577806.69953 694316.9334) +MULTIPOINT(576210.38329 714992.28805) +MULTIPOINT(577656.9425 695830.7359) +MULTIPOINT(581803.77911 693852.46425) +MULTIPOINT(483239.07014 239264.86823) +MULTIPOINT(584627.38842 693322.92413) +MULTIPOINT(531622.19236 716647.0409) +MULTIPOINT(581975.3656 694284.04885) +MULTIPOINT(446160.13588 550892.86503) +MULTIPOINT(529311.59037 610942.50619) +MULTIPOINT(581808.72699 695841.70311) +MULTIPOINT(504782.46851 615893.18621) +MULTIPOINT(622500.15625 752230.03026) +MULTIPOINT(349366.22234 363016.92123) +MULTIPOINT(594903.33074 545923.43693) +MULTIPOINT(441308.57019 229022.74901) +MULTIPOINT(605633.26966 771823.45975) +MULTIPOINT(318054.39683 406677.96877) +MULTIPOINT(606814.49094 683559.83739) +MULTIPOINT(427202.24558 526355.92112) +MULTIPOINT(585605.65458 428734.29996) +MULTIPOINT(348498.22029 696622.25466) +MULTIPOINT(447753.88823 552268.21802) +MULTIPOINT(562081.95051 696159.34758) +MULTIPOINT(449917.46153 516567.92252) +MULTIPOINT(509151.60704 594632.16326) +MULTIPOINT(565466.43528 673573.12364) +MULTIPOINT(492421.36236 719117.79927) +MULTIPOINT(613346.49996 691449.74754) +MULTIPOINT(341505.39323 347633.86011) +MULTIPOINT(335130.10922 221738.45857) +MULTIPOINT(520476.8592 607380.89342) +MULTIPOINT(610931.06529 690104.94336) +MULTIPOINT(577692.98162 695342.84069) +MULTIPOINT(623744.42521 697297.79934) +MULTIPOINT(439667.9941 646984.2557) +MULTIPOINT(507141.1403 606418.24612) +MULTIPOINT(575383.92723 737533.32187) +MULTIPOINT(413215.49525 523736.83631) +MULTIPOINT(561887.18089 504214.42238) +MULTIPOINT(583428.22076 759656.92773) +MULTIPOINT(421018.92505 813910.21541) +MULTIPOINT(621373.92981 690044.79287) +MULTIPOINT(470983.15933 620692.73333) +MULTIPOINT(508947.75836 706720.50714) diff --git a/regress/loader/NotReallyMultiPoint.select.expected b/regress/loader/NotReallyMultiPoint.select.expected index ea5570206..467d1af2d 100644 --- a/regress/loader/NotReallyMultiPoint.select.expected +++ b/regress/loader/NotReallyMultiPoint.select.expected @@ -1,66 +1,66 @@ -MULTIPOINT(580936.142822989 819465.261818573) -MULTIPOINT(506358.893822162 607539.257299624) -MULTIPOINT(630565.963576575 527840.458930382) -MULTIPOINT(315456.492217951 345306.814088522) -MULTIPOINT(471022.700765905 736736.493043649) -MULTIPOINT(500018.609208153 615679.275075901) -MULTIPOINT(219498.722491731 315980.375130241) -MULTIPOINT(319224.669258993 318928.062445705) -MULTIPOINT(568650.774421983 460462.130343988) -MULTIPOINT(556409.113539159 729253.30990305) -MULTIPOINT(513863.467629622 702618.742174883) -MULTIPOINT(578737.93900689 752848.936014613) -MULTIPOINT(574438.608452132 769113.196326717) -MULTIPOINT(542424.351008234 668316.880130952) -MULTIPOINT(400265.835331173 734407.03359561) -MULTIPOINT(451759.863004144 412686.100723883) -MULTIPOINT(569910.583609289 459856.209410486) -MULTIPOINT(463382.922608931 699974.019885147) -MULTIPOINT(604477.021809125 740527.999129056) -MULTIPOINT(507899.651882106 708318.275562585) -MULTIPOINT(417174.241778919 505305.090947582) -MULTIPOINT(577806.69952663 694316.933395063) -MULTIPOINT(576210.383288164 714992.288047029) -MULTIPOINT(577656.942500652 695830.735895674) -MULTIPOINT(581803.77911474 693852.464252684) -MULTIPOINT(483239.070139275 239264.868230516) -MULTIPOINT(584627.388419181 693322.924133717) -MULTIPOINT(531622.192358354 716647.04090078) -MULTIPOINT(581975.365599073 694284.048851616) -MULTIPOINT(446160.135881017 550892.865025523) -MULTIPOINT(529311.59036645 610942.506187195) -MULTIPOINT(581808.72698778 695841.703111349) -MULTIPOINT(504782.468510898 615893.18621198) -MULTIPOINT(622500.156247537 752230.030256728) -MULTIPOINT(349366.222335089 363016.921231509) -MULTIPOINT(594903.330738372 545923.436927693) -MULTIPOINT(441308.570185706 229022.749014213) -MULTIPOINT(605633.269658534 771823.459750208) -MULTIPOINT(318054.396825439 406677.968765208) -MULTIPOINT(606814.490943 683559.837390652) -MULTIPOINT(427202.24558416 526355.921118875) -MULTIPOINT(585605.654583162 428734.299958661) -MULTIPOINT(348498.220290712 696622.254661199) -MULTIPOINT(447753.888233448 552268.218021069) -MULTIPOINT(562081.950510856 696159.347584696) -MULTIPOINT(449917.461533751 516567.922516446) -MULTIPOINT(509151.60703826 594632.163260898) -MULTIPOINT(565466.43527563 673573.123642044) -MULTIPOINT(492421.362355858 719117.799265052) -MULTIPOINT(613346.499961959 691449.747538779) -MULTIPOINT(341505.39322594 347633.860111487) -MULTIPOINT(335130.109224021 221738.458568427) -MULTIPOINT(520476.859199935 607380.893420555) -MULTIPOINT(610931.065287928 690104.943360865) -MULTIPOINT(577692.981621935 695342.840693476) -MULTIPOINT(623744.425211874 697297.79933633) -MULTIPOINT(439667.99409899 646984.255696235) -MULTIPOINT(507141.140300172 606418.246119218) -MULTIPOINT(575383.927230225 737533.321867288) -MULTIPOINT(413215.495253968 523736.836314417) -MULTIPOINT(561887.180888466 504214.422382654) -MULTIPOINT(583428.220763956 759656.927730192) -MULTIPOINT(421018.925048973 813910.215413168) -MULTIPOINT(621373.929808485 690044.79287378) -MULTIPOINT(470983.159331542 620692.733330001) -MULTIPOINT(508947.758356538 706720.507141173) +MULTIPOINT(580936.14282 819465.26182) +MULTIPOINT(506358.89382 607539.2573) +MULTIPOINT(630565.96358 527840.45893) +MULTIPOINT(315456.49222 345306.81409) +MULTIPOINT(471022.70077 736736.49304) +MULTIPOINT(500018.60921 615679.27508) +MULTIPOINT(219498.72249 315980.37513) +MULTIPOINT(319224.66926 318928.06245) +MULTIPOINT(568650.77442 460462.13034) +MULTIPOINT(556409.11354 729253.3099) +MULTIPOINT(513863.46763 702618.74217) +MULTIPOINT(578737.93901 752848.93601) +MULTIPOINT(574438.60845 769113.19633) +MULTIPOINT(542424.35101 668316.88013) +MULTIPOINT(400265.83533 734407.0336) +MULTIPOINT(451759.863 412686.10072) +MULTIPOINT(569910.58361 459856.20941) +MULTIPOINT(463382.92261 699974.01989) +MULTIPOINT(604477.02181 740527.99913) +MULTIPOINT(507899.65188 708318.27556) +MULTIPOINT(417174.24178 505305.09095) +MULTIPOINT(577806.69953 694316.9334) +MULTIPOINT(576210.38329 714992.28805) +MULTIPOINT(577656.9425 695830.7359) +MULTIPOINT(581803.77911 693852.46425) +MULTIPOINT(483239.07014 239264.86823) +MULTIPOINT(584627.38842 693322.92413) +MULTIPOINT(531622.19236 716647.0409) +MULTIPOINT(581975.3656 694284.04885) +MULTIPOINT(446160.13588 550892.86503) +MULTIPOINT(529311.59037 610942.50619) +MULTIPOINT(581808.72699 695841.70311) +MULTIPOINT(504782.46851 615893.18621) +MULTIPOINT(622500.15625 752230.03026) +MULTIPOINT(349366.22234 363016.92123) +MULTIPOINT(594903.33074 545923.43693) +MULTIPOINT(441308.57019 229022.74901) +MULTIPOINT(605633.26966 771823.45975) +MULTIPOINT(318054.39683 406677.96877) +MULTIPOINT(606814.49094 683559.83739) +MULTIPOINT(427202.24558 526355.92112) +MULTIPOINT(585605.65458 428734.29996) +MULTIPOINT(348498.22029 696622.25466) +MULTIPOINT(447753.88823 552268.21802) +MULTIPOINT(562081.95051 696159.34758) +MULTIPOINT(449917.46153 516567.92252) +MULTIPOINT(509151.60704 594632.16326) +MULTIPOINT(565466.43528 673573.12364) +MULTIPOINT(492421.36236 719117.79927) +MULTIPOINT(613346.49996 691449.74754) +MULTIPOINT(341505.39323 347633.86011) +MULTIPOINT(335130.10922 221738.45857) +MULTIPOINT(520476.8592 607380.89342) +MULTIPOINT(610931.06529 690104.94336) +MULTIPOINT(577692.98162 695342.84069) +MULTIPOINT(623744.42521 697297.79934) +MULTIPOINT(439667.9941 646984.2557) +MULTIPOINT(507141.1403 606418.24612) +MULTIPOINT(575383.92723 737533.32187) +MULTIPOINT(413215.49525 523736.83631) +MULTIPOINT(561887.18089 504214.42238) +MULTIPOINT(583428.22076 759656.92773) +MULTIPOINT(421018.92505 813910.21541) +MULTIPOINT(621373.92981 690044.79287) +MULTIPOINT(470983.15933 620692.73333) +MULTIPOINT(508947.75836 706720.50714) diff --git a/regress/loader/NotReallyMultiPoint.select.sql b/regress/loader/NotReallyMultiPoint.select.sql index e68081804..716254c28 100644 --- a/regress/loader/NotReallyMultiPoint.select.sql +++ b/regress/loader/NotReallyMultiPoint.select.sql @@ -1,2 +1,2 @@ -select ST_Asewkt(the_geom) from loadedshp; +select ST_Asewkt(ST_SnapToGrid(the_geom,0.00001)) from loadedshp; -- 2.40.0