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.
Jason Wolfkill