开发者

SQL Server 2005 Column Type to store LatLng Coordinates

In SQL Server 2005 what column type should I use to store a LatLng Coor开发者_如何学Godinate?

For example a Lat coordinate like 135.0058554

I know there are new types in SQL Server 2008 but I'm stuck with SQL Server 2005 for the time being.

thanks


Use Decimal.

For example:

Decimal(18,15) for high precision.


We're using numeic (12,8) and haven't had any problems with 55,000 Australian geocoded addresses.


We use "float" (8 bytes/15 digits), which has adequate (~micron) resolution for most needs and good performance/storage efficiency.

W.r.t. @OMG Ponies' point, I'm a proponent of signed decimal degrees over DMS.

p.s. a latitude of 135.0058554 is REALLY REALLY far north! :-)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜