I came across this question recently when I started with spatial programming. Some time ago I read a book that led me to this.
//sql server has a really cool dll that deals with spacial data such like //geography points and so on. //add this namespace Using Microsoft.SqlServer.Types;
//SqlGeography.Point(dblLat, dblLon, srid)
var lat_lon_point = Microsoft.SqlServer.Types.SqlGeography.Point(lat, lon, 4326);
This is the best way to work with your spatial space. then to save data use this in sql
CREATE TABLE myGeoTable { LatLonPoint GEOMETRY }
else if you use something else that isnt sql just convert the dot to hex and save it. After a long time, I know that this is the safest.
Jonny Jan 21 '15 at 13:36 2015-01-21 13:36
source share