I am using sql server 2008. I attempted to use geography data type. But i'm using lightswitch 2012 and it doesnt' support geography so I have to change the data type for long/lat. Whats the best practice in this case? decimal(9,6) ???
Asked
Active
Viewed 141 times
1 Answers
1
Yes using decimal(9,6) would be the best approach in your case.
Actually, Latitude is still easy to deal with. It's about 69 miles per degree.
Longitude is a little more complex, since 1° of longitude = (69.11) x (cosine of the latitude).
You may check out the Spatial data-types which are specially made for these purposes.
Rahul Tripathi
- 168,305
- 31
- 280
- 331
-
sigh I just explained why I can't use that – Sirus Dec 18 '13 at 18:21
-
@Sirus:- I am so sorry that I skipped that. Anyways in that case using decimal(9,6) would be the best approach! – Rahul Tripathi Dec 18 '13 at 18:23
-
Why to use lat/long expressed as miles? Why not Km? or even better degrees and transform for localized measure system by demand? – jean Dec 18 '13 at 19:32