Yes, Google encourages you to cache the results in your database, but not if your database is large.
>From one of the articles linked on that Google page: "Though it is possible to geocode addresses on the fly using the Maps API GClientGeocoder JavaScript class, it is often preferable to pre- geocode addresses if possible to avoid repeated lookups for known addresses. This is common, for example, when creating a 'store finder' to locate a company's businesses geographically on a map. Note that this technique should not be used for geocoding databases with thousands of addresses, as this goes against the intended use of this service." See http://code.google.com/apis/maps/articles/phpsqlgeocode.html I don't know where the line is exactly, and Google does not say, but "databases with thousands of addresses" seem to be out of bounds. A literal reading of that language would mean that < 2,000 is okay, but >1,999 is not okay. On Oct 23, 12:36 pm, "Barry Hunter" <[EMAIL PROTECTED]> wrote: > See:http://code.google.com/apis/maps/articles/ > > Google encourage you to _cache_ the results in your database - the > important bit is they are to be used with the Gmap. > > On Thu, Oct 23, 2008 at 5:30 PM, wb <[EMAIL PROTECTED]> wrote: > > > It was returning a 620 error. > > > You guys are right, I do want to geocode all the restaurants in my > > database. Do you have any suggestions how I can do this in batches? > > > We have almost 1 million addresses (all in North America and Europe) > > in an SQL database. What do I need to geocode all of them? Do I need a > > third party software? I believe the Google user agreement says > > something like we're not supposed to store the coordinates returned > > from the Google geocoder in a database... > > -- > Barry > > -www.nearby.org.uk-www.geograph.org.uk- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" 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 -~----------~----~----~----~------~----~------~--~---
