Subject | Recommended floating-point type for latitude and longitude |
---|---|
Author | Daniel Albuschat |
Post date | 2006-10-12T08:47:52Z |
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
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