[postgis-devel] Re: Difference bug (was: Postgis)

strk at refractions.net strk at refractions.net
Mon Jul 25 10:44:21 PDT 2005


On Mon, Jul 25, 2005 at 08:47:12AM -0700, Martin Davis wrote:
> Almost certainly.  I can't read the hex, so I can't comment on why this
> might be occuring.  Can you post the WKT?

Sure, but transforming this to WKT reduces precision,
enough to pass the test:

select astext(difference(
astext('01030000000100000009000000215DE2E756673A419CB1D50C8868524179A3C8DF59673A410B9EDB5D876852419D13A3314B673A4173AB24F282685241239C6DD83A673A41ECC950DC80685241CC46FE2A2F673A414B3B231C80685241E74CB0C52D673A41EFB7A7E0806852417B14AE473B673A416766661683685241D7A370BD53673A4185EB518887685241215DE2E756673A419CB1D50C88685241'),
astext('01030000000100000005000000B87B621331673A4136EA036B81685241B90E118236673A41D91150717F6852415F2CA05B2E673A41A160D97B7E685241C3F528DC29673A41CDCCCC3C80685241B87B621331673A4136EA036B81685241')
));

 POLYGON((1730390.90579779 4825632.20054283,1730393.87415525 4825629.46652938,1730379.1938946 4825611.78348814,1730362.84542251 4825603.44243095,1730355.84602248 4825601.64258523,1730353.07572149 4825605.67211395,1730363.28 4825612.35,1730387.74 4825630.13,1730390.90579779 4825632.20054283))

... these are the input WKT ...

 POLYGON((1730390.90579779 4825632.20054283,1730393.87415525 4825629.46652938,1730379.1938946 4825611.78348814,1730362.84542251 4825603.44243095,1730351.16794245 4825600.43965037,1730349.77222138 4825603.51023672,1730363.28 4825612.35,1730387.74 4825630.13,1730390.90579779 4825632.20054283))

 POLYGON((1730353.07572149 4825605.67211395,1730358.50807278 4825597.77051207,1730350.3579128 4825593.93514267,1730345.86 4825600.95,1730353.07572149 4825605.67211395))

--strk;



More information about the postgis-devel mailing list