Top "Sqlgeography" questions

The MS SQL Server SqlGeography type represents data in a geodetic (round earth) coordinate system.

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query and without using SET FORCEPLAN

I am running following: DECLARE @g geography; declare @point nvarchar(50) ='' declare @i int =0, @lat decimal(8,6) =0.0, @long decimal(8,6) =0.0, @start datetime = …

sql-server sql-server-2008 indexing spatial-index sqlgeography
Convert SQL geography to C#

What is the C# equivalent of this geospatial T-SQL code? DECLARE @g geography; DECLARE @h geography; SET @g = geography::STGeomFromText(…

c# sql-server tsql sqlgeography
How do I select Lat & Long coordinates back out of SQL Server Geography data type field

Considering the SQL Server 'geography' data type... I can enter an array of latitude and longitude (btw is that the …

sql sqlgeography
Is it possible to use SqlGeography with Linq to Sql?

I've been having quite a few problems trying to use Microsoft.SqlServer.Types.SqlGeography. I know full well that support …

c# sql-server linq-to-sql geography sqlgeography
Enter data in geography column in SQL Server management studio

I've created a new table in SQL Server Management Studio, which includes a Geography column. Now, I'm trying to enter …

sql-server-2008 sqlgeography
One of the identified items was in an invalid format - Microsoft.SqlServer.Type

I'm trying to retrieve geography data from my SQl Server 2012 DB with: new SqlDataAdapter("SELECT [SpatialColumn] FROM [SpatialTable]", myConnection).Fill(…

c# sql-server sql-server-2012 geography sqlgeography
DB geography type MakeValid does not seem to be working

I have an application where the user draws zones and later I check if a polyline crosses them. All of …

c# .net tsql sqlgeography
Create a SqlGeography polygon-circle from a center and radius

I would like to save a circle in a sql-server 2008 geography field, using c#. In c# I have a latitude, …

c# sql-server geospatial sqlgeography
Reformat SQLGeography polygons to JSON

I am building a web service that serves geographic boundary data in JSON format. The geographic data is stored in …

c# json geojson sqlgeography wkt