Okay, that title was a mouthful, but I wanted to accurately describe how decided to Geocode thousands of locations for a client of mine.<\/p>\n
Google, awesome as they are, have offered a ridiculously simple API to consume:<\/p>\n
But, they naturally have rate limits, and even if they didn't, I'd feel more comfortable using their API responsibly. It is completely free after all.<\/p>\n So, I decided to write a ColdFusion script which does the following:<\/p>\n Since we're only doing one record at a time, we'll have to set this up to run automatically at a specified interval. This is where the JavaScript part comes in.<\/p>\n I could have setup a cron job without much effort, but knowing me, I'd forget to remove it once geocoding is complete. So, I decided to open up my web browsers console, and drop in the following:<\/p>\n The 35 second interval is enough to comply with Google's 2,500 query\/day limit.<\/span> The ColdFusion script follows below:<\/p>\n <\/p>\n \t<cfloop query="locations"> \t <cfoutput>#SerializeJSON(point)#<\/cfoutput><\/p>\n \t <cfquery> \t <cfcatch><\/p>\n \t <cfquery> \t <\/cfcatch> A simple method to GeoCode a large number of addresses with ColdFusion while respecting Google’s query limit.<\/p>\n","protected":false},"author":1,"featured_media":1589,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"amp_status":""},"categories":[34,238,1],"tags":[202],"_links":{"self":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/1587"}],"collection":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/comments?post=1587"}],"version-history":[{"count":8,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/1587\/revisions"}],"predecessor-version":[{"id":1685,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/1587\/revisions\/1685"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/media\/1589"}],"wp:attachment":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/media?parent=1587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/categories?post=1587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/tags?post=1587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}http:\/\/maps.googleapis.com\/maps\/api\/geocode\/json?address=theaddress<\/em>&sensor=false<\/code><\/p>\n\n
setInterval(function() {
\n\t $.ajax({
\n\t url: 'http:\/\/www.mysite.com\/do-the-geocode-thing.cfm',
\n\t success: function(data) { <\/span>
\n\t console.log(data);
\n\t }
\n\t })
\n\t}, 35000);<\/span><\/code><\/p>\n<cfquery name="locations">
\n\t SELECT id, address
\n\t FROM locations
\n\t WHERE latitude = 0
\n\t AND failed_geocode = 0
\n\t LIMIT 1
\n\t<\/cfquery><\/p>\n
\n\t <cfset api = "http:\/\/maps.googleapis.com\/maps\/api\/geocode\/json?address=#URLEncodedFormat(address)#&sensor=false">
\n\t
\n\t <cfhttp url="#api#"><\/cfhttp>
\n\t
\n\t <cfset response = DeserializeJSON(cfhttp.FileContent)>
\n\t
\n\t
\n\t <cftry>
\n\t <cfset point = response["results"][1]["geometry"]["location"]><\/p>\n
\n\t UPDATE locations
\n\t SET latitude = <cfqueryparam value="#point.lat#">,
\n\t longitude = <cfqueryparam value="#point.lng#">
\n\t WHERE id = <cfqueryparam value="#locations.id#">
\n\t <\/cfquery><\/p>\n
\n\t UPDATE locations
\n\t SET failed_geocode = 1
\n\t WHERE id = <cfqueryparam value="#locations.id#">
\n\t <\/cfquery><\/p>\n
\n\t <\/cftry>
\n\t<\/cfloop><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"