[Google Maps API v2] Geocoding postcodes from Australia return inconsistent results
What could possibly be the reason why the coordinates are inconsistent
when geocoding Australian postcodes.These postcodes (i.e 0821, 0822,
0838, 0871, 0881) shows inconsistent results. There are times this
display results but there are also times that this doesn't. We don't
know now what we do so that all postcodes displays results. We used
the haversine formula but we don't know where we would possibly be
wrong.
Here's our query using the haversine formula:
SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) *
cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) *
sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance <
25 ORDER BY distance LIMIT 0 , 20;
Here's the url of the site
http://www.toyotires.com.au/dealer-finder/dealer-finder.htm
Please, if someone has an idea how to fix this things we would really
appreciate your help.
--
You received this message because you are subscribed to the Google Groups "Google Maps API V2" group.
To post to this group, send email to google-maps-api@googlegroups.com.
To unsubscribe from this group, send email to google-maps-api+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en.
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home