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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en.
