State Geom Column is not 100% accurate


The state geom was calculated by getting the union of all counties for each state. This resulted in a good enough geometry object, but not 100% accurate. It seems as if this causes an error when trying to create a geography object from the geometry class.

file attachments


mrains wrote Jul 14, 2010 at 5:39 PM

Also, I have noticed the polygon information includes strange gaps in the middle of the state, it almost looks like degenerate polygons. Hopwever the other files do not seem to suffer from this issue from first glance.

wrote Jun 21, 2011 at 8:43 AM

pasikavec wrote Jun 21, 2011 at 8:43 AM

I don´t know what am I doing wrong, but a lot of states are displayed with strange lines in map. I save data to SQL Server 2008 R2 as Geometry type. See Attachment.

wrote Feb 14, 2013 at 1:32 AM