<div>
if you had a table containing the geography of each country it is quite easy
</div>


if you had a table containing the geography of each country it is quite easy

<div>
The NOAA provides coastline data, unfortunately it's just a series of points. While it's simple to create a geography object from them, it doesn't provide the name of the country.<br />
<br />
<a href="http://rimmer.ngdc.noaa.gov/coast/" rel="ugc">http://rimmer.ngdc.noaa.gov/coast/</a><br />
<br />
Also have a look here:<br />
<a href="http://www.collinssoftware.com/freegis_by_region.htm" rel="ugc">http://www.collinssoftware.com/freegis_by_region.htm</a>
</div>


The NOAA provides coastline data, unfortunately it's just a series of points. While it's simple to create a geography object from them, it doesn't provide the name of the country.

http://rimmer.ngdc.noaa.gov/coast/ [http://rimmer.ngdc.noaa.gov/coast/]

Also have a look here:
http://www.collinssoftware.com/freegis_by_region.htm [http://www.collinssoftware.com/freegis_by_region.htm]

<div>
I also have a basic set of data that contains the bounding rectangle for countries, you could either test for a point being inside the rectangle, or a point closest to the rectangle's centroid.<br />
However it's not guaranteed as if you take a point just inside the border of a large country, the centroid of the neighbouring small country may be closer, so the wrong country could be returned.
</div>


I also have a basic set of data that contains the bounding rectangle for countries, you could either test for a point being inside the rectangle, or a point closest to the rectangle's centroid.
However it's not guaranteed as if you take a point just inside the border of a large country, the centroid of the neighbouring small country may be closer, so the wrong country could be returned.

<div>
<div class="content wysiwyg-content">
Hi, is it possible to determine country name by having only geographic coordinate in SQL Server 2008?
</div>
</div>


Hi, is it possible to determine country name by having only geographic coordinate in SQL Server 2008?

Determine Country by Geographic Coordinate

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.