SRID conflict when querying SQL Server


Because we're displaying on SRID 3857, but the SQL Server data is stored in 4326, when we query based on the coordinates on the display SQL Server is returning data that isn't relevant to the display because of the projection of a geometric polygon onto a spheroid.
I've attached a screenshot demoing the issue. There have been earthquakes in the southern US, but they aren't displayed. You can see the curve where the results stop representing the projection issue.
I guess at some point the polygon needs to be reprojected into the right SRID but my attempts have failed :-(

file attachments


marcuswatson wrote Jun 26, 2012 at 10:41 AM

Hmm - attachment didn't get through. Trying again.

wrote Jun 26, 2012 at 10:42 AM

wrote Jun 26, 2012 at 10:42 AM

wrote Jun 26, 2012 at 10:44 AM

wrote Feb 14, 2013 at 2:32 AM