score:0

This is not the result that I am seeing.

Here's a query:

declare @pol1 Geography, @pol2 Geography

set @pol1 = Geography::STPolyFromText('POLYGON ((-2.91790532309701 53.3657440952224, -2.91790532309701 53.3567508791632, -2.90283703655041 53.3567508791632, -2.9028338560513 53.3657440952224, -2.91790532309701 53.3657440952224))', 4326);
set @pol2 = Geography::STPolyFromText('POLYGON ((-2.90283703655041 53.3657440952224, -2.90283703655041 53.3567508791632, -2.88776875000381 53.3567508791632, -2.88776556950469 53.3657440952224, -2.90283703655041 53.3657440952224))', 4326);

select @pol1.STUnion(@pol2)

Here's the result:

enter image description here

If you add the @pol3 from your question, you might see a seam form. Try running the query with Geometry instead of Geography, and the seam will disappear. I suspect that's the buldge of the earth pushing it out, so you might need more points to 'stitch it together' if using Geography.

(I'm actually trying to get it not to join, as described here.)


Related Articles