tag:blogger.com,1999:blog-6621561.post1193329524887876079..comments2023-11-03T05:56:36.182-07:00Comments on ConceptDev (Craig Dunn's blog): SQL Server 2008 Geometry: STUnion AggregateCraig Dunnhttp://www.blogger.com/profile/09377896535933926653noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-6621561.post-53123738228547583712014-10-22T08:16:12.757-07:002014-10-22T08:16:12.757-07:00Can we have the links working please? Thanks.Can we have the links working please? Thanks.Sumanihttps://www.blogger.com/profile/02182793482328803314noreply@blogger.comtag:blogger.com,1999:blog-6621561.post-82269736197891116252014-10-17T19:57:42.754-07:002014-10-17T19:57:42.754-07:00Sorry, it's almost 7 years since I wrote this!...Sorry, it's almost 7 years since I wrote this! The server that most of the code was hosted on no longer exists. I'll try to look over the weekend to see if I have it backed-up anywhere...Craig Dunnhttps://www.blogger.com/profile/09377896535933926653noreply@blogger.comtag:blogger.com,1999:blog-6621561.post-51380417724449160162014-10-16T23:11:42.417-07:002014-10-16T23:11:42.417-07:00This looks very interesting and I would like to te...This looks very interesting and I would like to test this, but all links are broken. Any plans to fix this?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6621561.post-63687981096022203822010-05-27T09:39:06.468-07:002010-05-27T09:39:06.468-07:00Thanks a lot, this really saved a lot of pain. I w...Thanks a lot, this really saved a lot of pain. I was trying to use the SQLSpatialToll from Codeplex but that somehow didnt meet my requirement for geometry data type. This did though! You are a life saver :)Anonymoushttps://www.blogger.com/profile/14392541524727505933noreply@blogger.comtag:blogger.com,1999:blog-6621561.post-33162376449728730742009-04-18T12:34:00.000-07:002009-04-18T12:34:00.000-07:00fixed it by applying the MakeValid() function to t...fixed it by applying the MakeValid() function to the geom column:<br /><br />select dbo.UnionAggregate(geom.MakeValid())<br />from county<br />groupby stateidUnknownhttps://www.blogger.com/profile/13478246670256895481noreply@blogger.comtag:blogger.com,1999:blog-6621561.post-28601728533344968262009-04-18T12:30:00.001-07:002009-04-18T12:30:00.001-07:00Msg 6522, Level 16, State 1, Line 1
A .NET Framewo...Msg 6522, Level 16, State 1, Line 1<br />A .NET Framework error occurred during execution of user-defined routine or aggregate "UnionAggregate": <br />System.ArgumentException: 24144: This operation cannot be completed because the instance is not valid. Use MakeValid to convert the instance to a valid instance. Note that MakeValid may cause the points of a geometry instance to shift slightly.<br />System.ArgumentException: <br /> at Microsoft.SqlServer.Types.SqlGeometry.ThrowIfInvalid()<br /> at Microsoft.SqlServer.Types.SqlGeometry.STUnion(SqlGeometry other)<br /> at SilverlightEarth.Geoquery.SqlClr.UnionAggregate.Accumulate(SqlGeometry value)Unknownhttps://www.blogger.com/profile/13478246670256895481noreply@blogger.comtag:blogger.com,1999:blog-6621561.post-50845349480696010562009-04-18T12:30:00.000-07:002009-04-18T12:30:00.000-07:00i'm getting the following error when running a gro...i'm getting the following error when running a group by queryUnknownhttps://www.blogger.com/profile/13478246670256895481noreply@blogger.comtag:blogger.com,1999:blog-6621561.post-73109640770783429042009-03-30T15:41:00.000-07:002009-03-30T15:41:00.000-07:00Thanks Rick,wow it's funny when you read stuff tha...Thanks Rick,<BR/>wow it's funny when you read stuff that you forget writing! those lines were actually *my* bug - i wasn't "lifting my pen" between drawing the outer and inner 'geometries'. This was fixed in a later version of <A HREF="http://geoquery2008.com" REL="nofollow">Geoquery 2008</A>Craig Dunnhttps://www.blogger.com/profile/09377896535933926653noreply@blogger.comtag:blogger.com,1999:blog-6621561.post-78006915352514284092009-03-30T08:11:00.000-07:002009-03-30T08:11:00.000-07:00Great work.Regarding the unexpected lines, I suspe...Great work.<BR/><BR/>Regarding the unexpected lines, I suspect it is from a rounding issue in STUnion. This causes all sorts of problems. <BR/><BR/>https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=379953&wa=wsignin1.0Rickhttps://www.blogger.com/profile/01496051309823728975noreply@blogger.com