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! :-)
精彩评论