wolfkillj (9/19/2014)
okbangas (9/19/2014)
I have some doubt on the correctness of this question. As you get the coordinates from a GPS system and your task is to store the coordinates (calculation of distance is not mentioned), I sincerely think that both geography and geometry would do, but the best option would possibly be to decimal numbers. If you should do calculation on the coordinates, it would be a completely different story.Given that geography and geometry were the only options, geography is definitely the best available answer. I agree, though, that unless there's a known need to apply any of the spatial functions to the data, it's probably best to store the coordinates as decimals[/url]. They can always be converted to the geography type as needed.
First of all, thanks to all for the response and taking the time to answer the question.
Geometry and geography are the only spatial data types available in SQL Server, hence no other options given;-) There is quite some misunderstanding when it comes to the spatial data and datatypes, the purpose of this question being an attempt to clarify this to a certain degree (easier to write a question than an article:-P)
Have a good weekend everyone and thanks again for the response.
😎