I got confused by the following 2 Questions already asked.
In the above questions someone is saying that decimal is a good datatype while someone is saying one should use MySQL's spatial extensions and others are saying using float is good because Google is also using float in their application here. So what should be the final solution for this problem?
Thanks
based on my experience if you need only lat and lng as seprated values an otimal solution is based on data type
decimal(16,12)
with this format you can localize point on maps with a precision very near to millimeter, and this for normal maps application is more than enough
Do the math! Six decimal places is enough precision to distinguish two lovers kissing. 8 or 12 is ludicrous. Here is a list of likely choices.
FLOAT
gives you a resolution of 1.7 meters or 5.6 feet. 39.95467480000001, -75.19447579999996
is an artifact of the displaying 39.9546748, -75.1944758
.