Subject Recommended floating-point type for latitude and longitude
Author Daniel Albuschat
Hello there,

I'd like to save global latitude and longitude data in my database,
which can look like this:
Longitude: 7.33220348221289
Latitude: 51.1492514558089

My best guess is using numeric(18,2) and always multipy the value by
10000000000 before
storing it to the database, but I'd like to hear your opinion on this.

Regards,
Daniel Albuschat

--
eat(this); // delicious suicide