Sunday, September 18, 2011

[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


Real Estate